SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002283s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.83' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://ic118.com/stock&keyword=210&page=286&srecordnum=7433' [ RunTime:0.001925s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002246s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000774s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003379s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.000398s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002336s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000342s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002093s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000941s ]
UPDATE `stock_search` SET `count` = 5085 , `updatetime` = '2026-06-08 22:48:31' WHERE `partno` = '210' [ RunTime:0.001895s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000275s ]
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.000456s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002642s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.224783s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '210%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 5700,20 [ RunTime:0.130673s ]
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` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('18755125','18754605','18754603','18754602','18754594','18754583','18754581','18754577','18754559','18753979','18753976','18753945','18753940','18753929','18753926','18753910','18753909','18753903','18753892','18753880') ORDER BY FIELD(s.id, 18755125,18754605,18754603,18754602,18754594,18754583,18754581,18754577,18754559,18753979,18753976,18753945,18753940,18753929,18753926,18753910,18753909,18753903,18753892,18753880) [ RunTime:0.036862s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18755125 LIMIT 4 [ RunTime:0.032990s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18755125 ORDER BY `minOrder` ASC [ RunTime:0.046199s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.019427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18755125 ORDER BY `unit` DESC [ RunTime:0.038800s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.014117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18755125 LIMIT 2 [ RunTime:0.016038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18755125 ORDER BY `minOrder` ASC [ RunTime:0.029088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18754605 LIMIT 4 [ RunTime:0.017369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754605 ORDER BY `minOrder` ASC [ RunTime:0.009846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18754605 ORDER BY `unit` DESC [ RunTime:0.047429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18754605 LIMIT 2 [ RunTime:0.034722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754605 ORDER BY `minOrder` ASC [ RunTime:0.022158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18754603 LIMIT 4 [ RunTime:0.051605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754603 ORDER BY `minOrder` ASC [ RunTime:0.035577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18754603 ORDER BY `unit` DESC [ RunTime:0.042967s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18754603 LIMIT 2 [ RunTime:0.038004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754603 ORDER BY `minOrder` ASC [ RunTime:0.021501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18754602 LIMIT 4 [ RunTime:0.005613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754602 ORDER BY `minOrder` ASC [ RunTime:0.022754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18754602 ORDER BY `unit` DESC [ RunTime:0.085518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18754602 LIMIT 2 [ RunTime:0.029513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754602 ORDER BY `minOrder` ASC [ RunTime:0.011693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18754594 LIMIT 4 [ RunTime:0.018729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754594 ORDER BY `minOrder` ASC [ RunTime:0.053403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18754594 ORDER BY `unit` DESC [ RunTime:0.020648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18754594 LIMIT 2 [ RunTime:0.070527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754594 ORDER BY `minOrder` ASC [ RunTime:0.016328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18754583 LIMIT 4 [ RunTime:0.016848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754583 ORDER BY `minOrder` ASC [ RunTime:0.025747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18754583 ORDER BY `unit` DESC [ RunTime:0.051904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18754583 LIMIT 2 [ RunTime:0.007121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754583 ORDER BY `minOrder` ASC [ RunTime:0.011900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18754581 LIMIT 4 [ RunTime:0.016326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754581 ORDER BY `minOrder` ASC [ RunTime:0.034949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18754581 ORDER BY `unit` DESC [ RunTime:0.008174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18754581 LIMIT 2 [ RunTime:0.032951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754581 ORDER BY `minOrder` ASC [ RunTime:0.008892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18754577 LIMIT 4 [ RunTime:0.021863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754577 ORDER BY `minOrder` ASC [ RunTime:0.005741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18754577 ORDER BY `unit` DESC [ RunTime:0.047877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18754577 LIMIT 2 [ RunTime:0.047165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754577 ORDER BY `minOrder` ASC [ RunTime:0.020078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18754559 LIMIT 4 [ RunTime:0.042962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754559 ORDER BY `minOrder` ASC [ RunTime:0.044020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18754559 ORDER BY `unit` DESC [ RunTime:0.081485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18754559 LIMIT 2 [ RunTime:0.077343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754559 ORDER BY `minOrder` ASC [ RunTime:0.013649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753979 LIMIT 4 [ RunTime:0.038413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753979 ORDER BY `minOrder` ASC [ RunTime:0.021039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753979 ORDER BY `unit` DESC [ RunTime:0.016539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753979 LIMIT 2 [ RunTime:0.022250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753979 ORDER BY `minOrder` ASC [ RunTime:0.025116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753976 LIMIT 4 [ RunTime:0.020743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753976 ORDER BY `minOrder` ASC [ RunTime:0.014122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753976 ORDER BY `unit` DESC [ RunTime:0.087000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753976 LIMIT 2 [ RunTime:0.023879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753976 ORDER BY `minOrder` ASC [ RunTime:0.025078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753945 LIMIT 4 [ RunTime:0.016029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753945 ORDER BY `minOrder` ASC [ RunTime:0.057652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753945 ORDER BY `unit` DESC [ RunTime:0.004468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753945 LIMIT 2 [ RunTime:0.029670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753945 ORDER BY `minOrder` ASC [ RunTime:0.011798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753940 LIMIT 4 [ RunTime:0.049476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753940 ORDER BY `minOrder` ASC [ RunTime:0.050709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753940 ORDER BY `unit` DESC [ RunTime:0.018792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753940 LIMIT 2 [ RunTime:0.027521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753940 ORDER BY `minOrder` ASC [ RunTime:0.010859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753929 LIMIT 4 [ RunTime:0.011131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753929 ORDER BY `minOrder` ASC [ RunTime:0.050980s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753929 ORDER BY `unit` DESC [ RunTime:0.011905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753929 LIMIT 2 [ RunTime:0.025389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753929 ORDER BY `minOrder` ASC [ RunTime:0.006229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753926 LIMIT 4 [ RunTime:0.029501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753926 ORDER BY `minOrder` ASC [ RunTime:0.035165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753926 ORDER BY `unit` DESC [ RunTime:0.066988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753926 LIMIT 2 [ RunTime:0.040001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753926 ORDER BY `minOrder` ASC [ RunTime:0.039770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753910 LIMIT 4 [ RunTime:0.039671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753910 ORDER BY `minOrder` ASC [ RunTime:0.004802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753910 ORDER BY `unit` DESC [ RunTime:0.036262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753910 LIMIT 2 [ RunTime:0.029155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753910 ORDER BY `minOrder` ASC [ RunTime:0.013282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753909 LIMIT 4 [ RunTime:0.027089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753909 ORDER BY `minOrder` ASC [ RunTime:0.052522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753909 ORDER BY `unit` DESC [ RunTime:0.093567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753909 LIMIT 2 [ RunTime:0.034327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753909 ORDER BY `minOrder` ASC [ RunTime:0.013281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753903 LIMIT 4 [ RunTime:0.040467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753903 ORDER BY `minOrder` ASC [ RunTime:0.027646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753903 ORDER BY `unit` DESC [ RunTime:0.018129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753903 LIMIT 2 [ RunTime:0.030155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753903 ORDER BY `minOrder` ASC [ RunTime:0.004733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753892 LIMIT 4 [ RunTime:0.006589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753892 ORDER BY `minOrder` ASC [ RunTime:0.014722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753892 ORDER BY `unit` DESC [ RunTime:0.020546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753892 LIMIT 2 [ RunTime:0.015233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753892 ORDER BY `minOrder` ASC [ RunTime:0.004004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753880 LIMIT 4 [ RunTime:0.015149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753880 ORDER BY `minOrder` ASC [ RunTime:0.033314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753880 ORDER BY `unit` DESC [ RunTime:0.016575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753880 LIMIT 2 [ RunTime:0.005844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753880 ORDER BY `minOrder` ASC [ RunTime:0.018155s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.006616s ]