SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001586s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock&keyword=228&page=477&srecordnum=10000' [ RunTime:0.002950s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001345s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000502s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001874s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000277s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001298s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000258s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001120s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.000420s ]
UPDATE `stock_search` SET `count` = 1149 , `updatetime` = '2026-06-11 20:41:04' WHERE `partno` = '228' [ RunTime:0.000788s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.018085s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.004655s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.010563s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001416s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.268932s ]
SELECT `s`.`id` FROM `stock` `s` WHERE `lockUser` = 0 AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '228%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 9520,20 [ RunTime:0.135848s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `lockUser` = 0 AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('12451820','12451819','12451818','12451817','12451816','12451815','12451814','12451813','12451812','12451811','12451810','12451809','12451808','12451807','12451806','12451805','12451804','12451803','12451802','12451801') ORDER BY FIELD(s.id, 12451820,12451819,12451818,12451817,12451816,12451815,12451814,12451813,12451812,12451811,12451810,12451809,12451808,12451807,12451806,12451805,12451804,12451803,12451802,12451801) [ RunTime:0.015960s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451820 LIMIT 4 [ RunTime:0.013318s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.009275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451820 ORDER BY `minOrder` ASC [ RunTime:0.010341s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.014891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451820 ORDER BY `unit` DESC [ RunTime:0.008536s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451820 LIMIT 2 [ RunTime:0.004330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451820 ORDER BY `minOrder` ASC [ RunTime:0.003286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451819 LIMIT 4 [ RunTime:0.004842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451819 ORDER BY `minOrder` ASC [ RunTime:0.007246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451819 ORDER BY `unit` DESC [ RunTime:0.017517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451819 LIMIT 2 [ RunTime:0.015033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451819 ORDER BY `minOrder` ASC [ RunTime:0.003722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451818 LIMIT 4 [ RunTime:0.007370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451818 ORDER BY `minOrder` ASC [ RunTime:0.003288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451818 ORDER BY `unit` DESC [ RunTime:0.014436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451818 LIMIT 2 [ RunTime:0.013456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451818 ORDER BY `minOrder` ASC [ RunTime:0.005769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451817 LIMIT 4 [ RunTime:0.010816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451817 ORDER BY `minOrder` ASC [ RunTime:0.014909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451817 ORDER BY `unit` DESC [ RunTime:0.012458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451817 LIMIT 2 [ RunTime:0.027630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451817 ORDER BY `minOrder` ASC [ RunTime:0.059407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451816 LIMIT 4 [ RunTime:0.009822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451816 ORDER BY `minOrder` ASC [ RunTime:0.011536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451816 ORDER BY `unit` DESC [ RunTime:0.015765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451816 LIMIT 2 [ RunTime:0.017757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451816 ORDER BY `minOrder` ASC [ RunTime:0.003547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451815 LIMIT 4 [ RunTime:0.016671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451815 ORDER BY `minOrder` ASC [ RunTime:0.009760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451815 ORDER BY `unit` DESC [ RunTime:0.028210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451815 LIMIT 2 [ RunTime:0.024587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451815 ORDER BY `minOrder` ASC [ RunTime:0.006101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451814 LIMIT 4 [ RunTime:0.018611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451814 ORDER BY `minOrder` ASC [ RunTime:0.011494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451814 ORDER BY `unit` DESC [ RunTime:0.033664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451814 LIMIT 2 [ RunTime:0.017511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451814 ORDER BY `minOrder` ASC [ RunTime:0.010971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451813 LIMIT 4 [ RunTime:0.017116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451813 ORDER BY `minOrder` ASC [ RunTime:0.012732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451813 ORDER BY `unit` DESC [ RunTime:0.039916s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451813 LIMIT 2 [ RunTime:0.000463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451813 ORDER BY `minOrder` ASC [ RunTime:0.040805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451812 LIMIT 4 [ RunTime:0.019502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451812 ORDER BY `minOrder` ASC [ RunTime:0.046869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451812 ORDER BY `unit` DESC [ RunTime:0.026336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451812 LIMIT 2 [ RunTime:0.040653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451812 ORDER BY `minOrder` ASC [ RunTime:0.010927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451811 LIMIT 4 [ RunTime:0.010093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451811 ORDER BY `minOrder` ASC [ RunTime:0.017236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451811 ORDER BY `unit` DESC [ RunTime:0.004262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451811 LIMIT 2 [ RunTime:0.036412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451811 ORDER BY `minOrder` ASC [ RunTime:0.028558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451810 LIMIT 4 [ RunTime:0.021337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451810 ORDER BY `minOrder` ASC [ RunTime:0.015139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451810 ORDER BY `unit` DESC [ RunTime:0.011689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451810 LIMIT 2 [ RunTime:0.041050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451810 ORDER BY `minOrder` ASC [ RunTime:0.005834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451809 LIMIT 4 [ RunTime:0.009254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451809 ORDER BY `minOrder` ASC [ RunTime:0.015185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451809 ORDER BY `unit` DESC [ RunTime:0.033462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451809 LIMIT 2 [ RunTime:0.020787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451809 ORDER BY `minOrder` ASC [ RunTime:0.026324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451808 LIMIT 4 [ RunTime:0.018604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451808 ORDER BY `minOrder` ASC [ RunTime:0.019587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451808 ORDER BY `unit` DESC [ RunTime:0.041990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451808 LIMIT 2 [ RunTime:0.019126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451808 ORDER BY `minOrder` ASC [ RunTime:0.019712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451807 LIMIT 4 [ RunTime:0.044389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451807 ORDER BY `minOrder` ASC [ RunTime:0.024819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451807 ORDER BY `unit` DESC [ RunTime:0.018038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451807 LIMIT 2 [ RunTime:0.044710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451807 ORDER BY `minOrder` ASC [ RunTime:0.007503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451806 LIMIT 4 [ RunTime:0.013078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451806 ORDER BY `minOrder` ASC [ RunTime:0.010574s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451806 ORDER BY `unit` DESC [ RunTime:0.005592s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451806 LIMIT 2 [ RunTime:0.058410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451806 ORDER BY `minOrder` ASC [ RunTime:0.018052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451805 LIMIT 4 [ RunTime:0.023063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451805 ORDER BY `minOrder` ASC [ RunTime:0.007646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451805 ORDER BY `unit` DESC [ RunTime:0.011128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451805 LIMIT 2 [ RunTime:0.026148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451805 ORDER BY `minOrder` ASC [ RunTime:0.006347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451804 LIMIT 4 [ RunTime:0.033381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451804 ORDER BY `minOrder` ASC [ RunTime:0.025691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451804 ORDER BY `unit` DESC [ RunTime:0.011395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451804 LIMIT 2 [ RunTime:0.009084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451804 ORDER BY `minOrder` ASC [ RunTime:0.010892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451803 LIMIT 4 [ RunTime:0.012560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451803 ORDER BY `minOrder` ASC [ RunTime:0.051990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451803 ORDER BY `unit` DESC [ RunTime:0.027472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451803 LIMIT 2 [ RunTime:0.013376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451803 ORDER BY `minOrder` ASC [ RunTime:0.030978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451802 LIMIT 4 [ RunTime:0.015208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451802 ORDER BY `minOrder` ASC [ RunTime:0.018086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451802 ORDER BY `unit` DESC [ RunTime:0.038744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451802 LIMIT 2 [ RunTime:0.022751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451802 ORDER BY `minOrder` ASC [ RunTime:0.026229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451801 LIMIT 4 [ RunTime:0.021775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451801 ORDER BY `minOrder` ASC [ RunTime:0.018876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451801 ORDER BY `unit` DESC [ RunTime:0.058939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451801 LIMIT 2 [ RunTime:0.029663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451801 ORDER BY `minOrder` ASC [ RunTime:0.025614s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.128838s ]