SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001642s ]
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=464&srecordnum=10000' [ RunTime:0.001806s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003135s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000628s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001315s ]
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.001964s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000215s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.000993s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.000431s ]
UPDATE `stock_search` SET `count` = 1182 , `updatetime` = '2026-06-12 02:28:43' WHERE `partno` = '228' [ RunTime:0.007396s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.004349s ]
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.000913s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001730s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.265788s ]
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 9260,20 [ RunTime:0.154638s ]
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 ('12452123','12452122','12452121','12452120','12452119','12452118','12452117','12452116','12452115','12452114','12452113','12452112','12452111','12452110','12452109','12452108','12452107','12452106','12452105','12452104') ORDER BY FIELD(s.id, 12452123,12452122,12452121,12452120,12452119,12452118,12452117,12452116,12452115,12452114,12452113,12452112,12452111,12452110,12452109,12452108,12452107,12452106,12452105,12452104) [ RunTime:0.033055s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452123 LIMIT 4 [ RunTime:0.009563s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452123 ORDER BY `minOrder` ASC [ RunTime:0.012517s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452123 ORDER BY `unit` DESC [ RunTime:0.012092s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452123 LIMIT 2 [ RunTime:0.007032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452123 ORDER BY `minOrder` ASC [ RunTime:0.018882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452122 LIMIT 4 [ RunTime:0.028654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452122 ORDER BY `minOrder` ASC [ RunTime:0.019082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452122 ORDER BY `unit` DESC [ RunTime:0.019449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452122 LIMIT 2 [ RunTime:0.034393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452122 ORDER BY `minOrder` ASC [ RunTime:0.004084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452121 LIMIT 4 [ RunTime:0.055324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452121 ORDER BY `minOrder` ASC [ RunTime:0.035579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452121 ORDER BY `unit` DESC [ RunTime:0.064103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452121 LIMIT 2 [ RunTime:0.020672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452121 ORDER BY `minOrder` ASC [ RunTime:0.010931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452120 LIMIT 4 [ RunTime:0.042566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452120 ORDER BY `minOrder` ASC [ RunTime:0.064001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452120 ORDER BY `unit` DESC [ RunTime:0.034006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452120 LIMIT 2 [ RunTime:0.038279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452120 ORDER BY `minOrder` ASC [ RunTime:0.000388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452119 LIMIT 4 [ RunTime:0.041992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452119 ORDER BY `minOrder` ASC [ RunTime:0.056451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452119 ORDER BY `unit` DESC [ RunTime:0.077220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452119 LIMIT 2 [ RunTime:0.041882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452119 ORDER BY `minOrder` ASC [ RunTime:0.026291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452118 LIMIT 4 [ RunTime:0.080171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452118 ORDER BY `minOrder` ASC [ RunTime:0.088242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452118 ORDER BY `unit` DESC [ RunTime:0.040087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452118 LIMIT 2 [ RunTime:0.043787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452118 ORDER BY `minOrder` ASC [ RunTime:0.034577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452117 LIMIT 4 [ RunTime:0.014328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452117 ORDER BY `minOrder` ASC [ RunTime:0.013662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452117 ORDER BY `unit` DESC [ RunTime:0.009542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452117 LIMIT 2 [ RunTime:0.083036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452117 ORDER BY `minOrder` ASC [ RunTime:0.061624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452116 LIMIT 4 [ RunTime:0.032808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452116 ORDER BY `minOrder` ASC [ RunTime:0.045305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452116 ORDER BY `unit` DESC [ RunTime:0.036417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452116 LIMIT 2 [ RunTime:0.073091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452116 ORDER BY `minOrder` ASC [ RunTime:0.020868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452115 LIMIT 4 [ RunTime:0.024760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452115 ORDER BY `minOrder` ASC [ RunTime:0.032910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452115 ORDER BY `unit` DESC [ RunTime:0.042128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452115 LIMIT 2 [ RunTime:0.002957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452115 ORDER BY `minOrder` ASC [ RunTime:0.001012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452114 LIMIT 4 [ RunTime:0.061013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452114 ORDER BY `minOrder` ASC [ RunTime:0.024499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452114 ORDER BY `unit` DESC [ RunTime:0.180689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452114 LIMIT 2 [ RunTime:0.022551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452114 ORDER BY `minOrder` ASC [ RunTime:0.021816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452113 LIMIT 4 [ RunTime:0.094730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452113 ORDER BY `minOrder` ASC [ RunTime:0.054427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452113 ORDER BY `unit` DESC [ RunTime:0.042645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452113 LIMIT 2 [ RunTime:0.050852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452113 ORDER BY `minOrder` ASC [ RunTime:0.013465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452112 LIMIT 4 [ RunTime:0.057472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452112 ORDER BY `minOrder` ASC [ RunTime:0.043301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452112 ORDER BY `unit` DESC [ RunTime:0.089463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452112 LIMIT 2 [ RunTime:0.091837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452112 ORDER BY `minOrder` ASC [ RunTime:0.023958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452111 LIMIT 4 [ RunTime:0.038102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452111 ORDER BY `minOrder` ASC [ RunTime:0.058607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452111 ORDER BY `unit` DESC [ RunTime:0.071381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452111 LIMIT 2 [ RunTime:0.083870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452111 ORDER BY `minOrder` ASC [ RunTime:0.029617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452110 LIMIT 4 [ RunTime:0.050138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452110 ORDER BY `minOrder` ASC [ RunTime:0.063451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452110 ORDER BY `unit` DESC [ RunTime:0.042200s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452110 LIMIT 2 [ RunTime:0.052959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452110 ORDER BY `minOrder` ASC [ RunTime:0.007781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452109 LIMIT 4 [ RunTime:0.015019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452109 ORDER BY `minOrder` ASC [ RunTime:0.020519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452109 ORDER BY `unit` DESC [ RunTime:0.040172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452109 LIMIT 2 [ RunTime:0.040612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452109 ORDER BY `minOrder` ASC [ RunTime:0.039274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452108 LIMIT 4 [ RunTime:0.041646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452108 ORDER BY `minOrder` ASC [ RunTime:0.018406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452108 ORDER BY `unit` DESC [ RunTime:0.126320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452108 LIMIT 2 [ RunTime:0.036572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452108 ORDER BY `minOrder` ASC [ RunTime:0.015509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452107 LIMIT 4 [ RunTime:0.124678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452107 ORDER BY `minOrder` ASC [ RunTime:0.048973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452107 ORDER BY `unit` DESC [ RunTime:0.105640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452107 LIMIT 2 [ RunTime:0.060591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452107 ORDER BY `minOrder` ASC [ RunTime:0.052963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452106 LIMIT 4 [ RunTime:0.047493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452106 ORDER BY `minOrder` ASC [ RunTime:0.059677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452106 ORDER BY `unit` DESC [ RunTime:0.065701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452106 LIMIT 2 [ RunTime:0.064433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452106 ORDER BY `minOrder` ASC [ RunTime:0.036579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452105 LIMIT 4 [ RunTime:0.044779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452105 ORDER BY `minOrder` ASC [ RunTime:0.050240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452105 ORDER BY `unit` DESC [ RunTime:0.069402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452105 LIMIT 2 [ RunTime:0.034528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452105 ORDER BY `minOrder` ASC [ RunTime:0.056429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452104 LIMIT 4 [ RunTime:0.032275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452104 ORDER BY `minOrder` ASC [ RunTime:0.059912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452104 ORDER BY `unit` DESC [ RunTime:0.038901s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452104 LIMIT 2 [ RunTime:0.026792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452104 ORDER BY `minOrder` ASC [ RunTime:0.006483s ]
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.016021s ]