SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002045s ]
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=466&srecordnum=10000' [ RunTime:0.023151s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001713s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.014738s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003390s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000444s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002418s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001630s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002418s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.007483s ]
UPDATE `stock_search` SET `count` = 1175 , `updatetime` = '2026-06-12 01:18:18' WHERE `partno` = '228' [ RunTime:0.005162s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000541s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.002091s ]
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.000712s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002433s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.112940s ]
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 9300,20 [ RunTime:0.165315s ]
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 ('12452083','12452082','12452081','12452080','12452079','12452078','12452077','12452076','12452075','12452074','12452073','12452072','12452071','12452070','12452069','12452068','12452067','12452066','12452065','12452064') ORDER BY FIELD(s.id, 12452083,12452082,12452081,12452080,12452079,12452078,12452077,12452076,12452075,12452074,12452073,12452072,12452071,12452070,12452069,12452068,12452067,12452066,12452065,12452064) [ RunTime:0.034447s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452083 LIMIT 4 [ RunTime:0.032027s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452083 ORDER BY `minOrder` ASC [ RunTime:0.013496s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452083 ORDER BY `unit` DESC [ RunTime:0.013420s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452083 LIMIT 2 [ RunTime:0.014035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452083 ORDER BY `minOrder` ASC [ RunTime:0.006155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452082 LIMIT 4 [ RunTime:0.021279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452082 ORDER BY `minOrder` ASC [ RunTime:0.021867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452082 ORDER BY `unit` DESC [ RunTime:0.040473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452082 LIMIT 2 [ RunTime:0.024684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452082 ORDER BY `minOrder` ASC [ RunTime:0.033728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452081 LIMIT 4 [ RunTime:0.004545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452081 ORDER BY `minOrder` ASC [ RunTime:0.022210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452081 ORDER BY `unit` DESC [ RunTime:0.022902s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452081 LIMIT 2 [ RunTime:0.004020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452081 ORDER BY `minOrder` ASC [ RunTime:0.012627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452080 LIMIT 4 [ RunTime:0.021473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452080 ORDER BY `minOrder` ASC [ RunTime:0.017416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452080 ORDER BY `unit` DESC [ RunTime:0.015735s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452080 LIMIT 2 [ RunTime:0.018669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452080 ORDER BY `minOrder` ASC [ RunTime:0.003411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452079 LIMIT 4 [ RunTime:0.027141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452079 ORDER BY `minOrder` ASC [ RunTime:0.015035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452079 ORDER BY `unit` DESC [ RunTime:0.048902s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452079 LIMIT 2 [ RunTime:0.075790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452079 ORDER BY `minOrder` ASC [ RunTime:0.027740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452078 LIMIT 4 [ RunTime:0.026880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452078 ORDER BY `minOrder` ASC [ RunTime:0.014335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452078 ORDER BY `unit` DESC [ RunTime:0.064368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452078 LIMIT 2 [ RunTime:0.033930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452078 ORDER BY `minOrder` ASC [ RunTime:0.017546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452077 LIMIT 4 [ RunTime:0.032744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452077 ORDER BY `minOrder` ASC [ RunTime:0.042313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452077 ORDER BY `unit` DESC [ RunTime:0.025663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452077 LIMIT 2 [ RunTime:0.020025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452077 ORDER BY `minOrder` ASC [ RunTime:0.005058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452076 LIMIT 4 [ RunTime:0.066232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452076 ORDER BY `minOrder` ASC [ RunTime:0.026131s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452076 ORDER BY `unit` DESC [ RunTime:0.017202s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452076 LIMIT 2 [ RunTime:0.029197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452076 ORDER BY `minOrder` ASC [ RunTime:0.008366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452075 LIMIT 4 [ RunTime:0.006524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452075 ORDER BY `minOrder` ASC [ RunTime:0.025981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452075 ORDER BY `unit` DESC [ RunTime:0.020049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452075 LIMIT 2 [ RunTime:0.013167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452075 ORDER BY `minOrder` ASC [ RunTime:0.022598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452074 LIMIT 4 [ RunTime:0.007610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452074 ORDER BY `minOrder` ASC [ RunTime:0.010240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452074 ORDER BY `unit` DESC [ RunTime:0.048428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452074 LIMIT 2 [ RunTime:0.004480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452074 ORDER BY `minOrder` ASC [ RunTime:0.006517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452073 LIMIT 4 [ RunTime:0.009395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452073 ORDER BY `minOrder` ASC [ RunTime:0.009303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452073 ORDER BY `unit` DESC [ RunTime:0.037665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452073 LIMIT 2 [ RunTime:0.043135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452073 ORDER BY `minOrder` ASC [ RunTime:0.010157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452072 LIMIT 4 [ RunTime:0.009112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452072 ORDER BY `minOrder` ASC [ RunTime:0.004450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452072 ORDER BY `unit` DESC [ RunTime:0.034962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452072 LIMIT 2 [ RunTime:0.031040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452072 ORDER BY `minOrder` ASC [ RunTime:0.039045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452071 LIMIT 4 [ RunTime:0.022002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452071 ORDER BY `minOrder` ASC [ RunTime:0.059633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452071 ORDER BY `unit` DESC [ RunTime:0.022169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452071 LIMIT 2 [ RunTime:0.027590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452071 ORDER BY `minOrder` ASC [ RunTime:0.011916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452070 LIMIT 4 [ RunTime:0.014006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452070 ORDER BY `minOrder` ASC [ RunTime:0.009765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452070 ORDER BY `unit` DESC [ RunTime:0.018098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452070 LIMIT 2 [ RunTime:0.010895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452070 ORDER BY `minOrder` ASC [ RunTime:0.001330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452069 LIMIT 4 [ RunTime:0.007831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452069 ORDER BY `minOrder` ASC [ RunTime:0.012263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452069 ORDER BY `unit` DESC [ RunTime:0.007147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452069 LIMIT 2 [ RunTime:0.020640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452069 ORDER BY `minOrder` ASC [ RunTime:0.011850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452068 LIMIT 4 [ RunTime:0.010266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452068 ORDER BY `minOrder` ASC [ RunTime:0.012697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452068 ORDER BY `unit` DESC [ RunTime:0.030435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452068 LIMIT 2 [ RunTime:0.013881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452068 ORDER BY `minOrder` ASC [ RunTime:0.008522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452067 LIMIT 4 [ RunTime:0.004991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452067 ORDER BY `minOrder` ASC [ RunTime:0.039117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452067 ORDER BY `unit` DESC [ RunTime:0.029064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452067 LIMIT 2 [ RunTime:0.080792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452067 ORDER BY `minOrder` ASC [ RunTime:0.017508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452066 LIMIT 4 [ RunTime:0.026589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452066 ORDER BY `minOrder` ASC [ RunTime:0.082910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452066 ORDER BY `unit` DESC [ RunTime:0.018387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452066 LIMIT 2 [ RunTime:0.046839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452066 ORDER BY `minOrder` ASC [ RunTime:0.039689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452065 LIMIT 4 [ RunTime:0.013413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452065 ORDER BY `minOrder` ASC [ RunTime:0.014701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452065 ORDER BY `unit` DESC [ RunTime:0.006137s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452065 LIMIT 2 [ RunTime:0.024401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452065 ORDER BY `minOrder` ASC [ RunTime:0.013088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452064 LIMIT 4 [ RunTime:0.014665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452064 ORDER BY `minOrder` ASC [ RunTime:0.006402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452064 ORDER BY `unit` DESC [ RunTime:0.005322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452064 LIMIT 2 [ RunTime:0.005627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452064 ORDER BY `minOrder` ASC [ RunTime:0.002688s ]
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.003854s ]