SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001448s ]
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=432&srecordnum=10000' [ RunTime:0.001912s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001190s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000516s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002190s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000310s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001273s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000244s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001227s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.000918s ]
UPDATE `stock_search` SET `count` = 1979 , `updatetime` = '2026-06-12 13:16:16' WHERE `partno` = '228' [ RunTime:0.002252s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000286s ]
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.000463s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001270s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.221114s ]
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 8620,20 [ RunTime:0.137055s ]
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 ('16733021','16731772','16730779','16614381','16453155','16453153','16453152','16453151','16453150','16453149','16453148','16453147','16453146','16453145','16453144','16433340','16433272','16433271','16433270','16433259') ORDER BY FIELD(s.id, 16733021,16731772,16730779,16614381,16453155,16453153,16453152,16453151,16453150,16453149,16453148,16453147,16453146,16453145,16453144,16433340,16433272,16433271,16433270,16433259) [ RunTime:0.006857s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16733021 LIMIT 4 [ RunTime:0.001176s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16733021 ORDER BY `minOrder` ASC [ RunTime:0.001496s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16733021 ORDER BY `unit` DESC [ RunTime:0.000840s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16733021 LIMIT 2 [ RunTime:0.006603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16733021 ORDER BY `minOrder` ASC [ RunTime:0.003708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16731772 LIMIT 4 [ RunTime:0.006270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16731772 ORDER BY `minOrder` ASC [ RunTime:0.004597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16731772 ORDER BY `unit` DESC [ RunTime:0.015959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16731772 LIMIT 2 [ RunTime:0.011001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16731772 ORDER BY `minOrder` ASC [ RunTime:0.002677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16730779 LIMIT 4 [ RunTime:0.010654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16730779 ORDER BY `minOrder` ASC [ RunTime:0.011184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16730779 ORDER BY `unit` DESC [ RunTime:0.011760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16730779 LIMIT 2 [ RunTime:0.009558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16730779 ORDER BY `minOrder` ASC [ RunTime:0.005353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16614381 LIMIT 4 [ RunTime:0.009749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16614381 ORDER BY `minOrder` ASC [ RunTime:0.003702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16614381 ORDER BY `unit` DESC [ RunTime:0.000450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16614381 LIMIT 2 [ RunTime:0.000410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16614381 ORDER BY `minOrder` ASC [ RunTime:0.000258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16453155 LIMIT 4 [ RunTime:0.000844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16453155 ORDER BY `minOrder` ASC [ RunTime:0.004764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16453155 ORDER BY `unit` DESC [ RunTime:0.003400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16453155 LIMIT 2 [ RunTime:0.004550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16453155 ORDER BY `minOrder` ASC [ RunTime:0.001415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16453153 LIMIT 4 [ RunTime:0.001810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16453153 ORDER BY `minOrder` ASC [ RunTime:0.003493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16453153 ORDER BY `unit` DESC [ RunTime:0.004824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16453153 LIMIT 2 [ RunTime:0.005238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16453153 ORDER BY `minOrder` ASC [ RunTime:0.002060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16453152 LIMIT 4 [ RunTime:0.009682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16453152 ORDER BY `minOrder` ASC [ RunTime:0.004531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16453152 ORDER BY `unit` DESC [ RunTime:0.003467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16453152 LIMIT 2 [ RunTime:0.001595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16453152 ORDER BY `minOrder` ASC [ RunTime:0.002113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16453151 LIMIT 4 [ RunTime:0.006263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16453151 ORDER BY `minOrder` ASC [ RunTime:0.005496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16453151 ORDER BY `unit` DESC [ RunTime:0.006937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16453151 LIMIT 2 [ RunTime:0.007062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16453151 ORDER BY `minOrder` ASC [ RunTime:0.005694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16453150 LIMIT 4 [ RunTime:0.002809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16453150 ORDER BY `minOrder` ASC [ RunTime:0.007495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16453150 ORDER BY `unit` DESC [ RunTime:0.015806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16453150 LIMIT 2 [ RunTime:0.013279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16453150 ORDER BY `minOrder` ASC [ RunTime:0.003883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16453149 LIMIT 4 [ RunTime:0.004249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16453149 ORDER BY `minOrder` ASC [ RunTime:0.012516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16453149 ORDER BY `unit` DESC [ RunTime:0.013065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16453149 LIMIT 2 [ RunTime:0.012505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16453149 ORDER BY `minOrder` ASC [ RunTime:0.003685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16453148 LIMIT 4 [ RunTime:0.005674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16453148 ORDER BY `minOrder` ASC [ RunTime:0.007935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16453148 ORDER BY `unit` DESC [ RunTime:0.015522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16453148 LIMIT 2 [ RunTime:0.001468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16453148 ORDER BY `minOrder` ASC [ RunTime:0.011834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16453147 LIMIT 4 [ RunTime:0.003204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16453147 ORDER BY `minOrder` ASC [ RunTime:0.006998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16453147 ORDER BY `unit` DESC [ RunTime:0.003657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16453147 LIMIT 2 [ RunTime:0.009430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16453147 ORDER BY `minOrder` ASC [ RunTime:0.005219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16453146 LIMIT 4 [ RunTime:0.003910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16453146 ORDER BY `minOrder` ASC [ RunTime:0.003802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16453146 ORDER BY `unit` DESC [ RunTime:0.011228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16453146 LIMIT 2 [ RunTime:0.000521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16453146 ORDER BY `minOrder` ASC [ RunTime:0.007559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16453145 LIMIT 4 [ RunTime:0.000737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16453145 ORDER BY `minOrder` ASC [ RunTime:0.004571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16453145 ORDER BY `unit` DESC [ RunTime:0.000532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16453145 LIMIT 2 [ RunTime:0.006064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16453145 ORDER BY `minOrder` ASC [ RunTime:0.003094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16453144 LIMIT 4 [ RunTime:0.006600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16453144 ORDER BY `minOrder` ASC [ RunTime:0.008885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16453144 ORDER BY `unit` DESC [ RunTime:0.005080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16453144 LIMIT 2 [ RunTime:0.005211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16453144 ORDER BY `minOrder` ASC [ RunTime:0.003508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16433340 LIMIT 4 [ RunTime:0.004568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16433340 ORDER BY `minOrder` ASC [ RunTime:0.006221s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16433340 ORDER BY `unit` DESC [ RunTime:0.001028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16433340 LIMIT 2 [ RunTime:0.008162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16433340 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16433272 LIMIT 4 [ RunTime:0.007591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16433272 ORDER BY `minOrder` ASC [ RunTime:0.001579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16433272 ORDER BY `unit` DESC [ RunTime:0.005658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16433272 LIMIT 2 [ RunTime:0.020896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16433272 ORDER BY `minOrder` ASC [ RunTime:0.007951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16433271 LIMIT 4 [ RunTime:0.013512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16433271 ORDER BY `minOrder` ASC [ RunTime:0.005772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16433271 ORDER BY `unit` DESC [ RunTime:0.030393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16433271 LIMIT 2 [ RunTime:0.027183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16433271 ORDER BY `minOrder` ASC [ RunTime:0.004148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16433270 LIMIT 4 [ RunTime:0.002877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16433270 ORDER BY `minOrder` ASC [ RunTime:0.011240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16433270 ORDER BY `unit` DESC [ RunTime:0.006618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16433270 LIMIT 2 [ RunTime:0.003552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16433270 ORDER BY `minOrder` ASC [ RunTime:0.004182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16433259 LIMIT 4 [ RunTime:0.004197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16433259 ORDER BY `minOrder` ASC [ RunTime:0.002079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16433259 ORDER BY `unit` DESC [ RunTime:0.004178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16433259 LIMIT 2 [ RunTime:0.000481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16433259 ORDER BY `minOrder` ASC [ RunTime:0.000341s ]
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.070116s ]