SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001664s ]
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=319&srecordnum=7544' [ RunTime:0.016067s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001394s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001055s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001272s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.001114s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001121s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000235s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001115s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000327s ]
UPDATE `stock_search` SET `count` = 5693 , `updatetime` = '2026-06-08 22:56:33' WHERE `partno` = '210' [ RunTime:0.001522s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000221s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000191s ]
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.000288s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001402s ]
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.000339s ]
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 6360,20 [ RunTime:0.059636s ]
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 ('13524056','13524055','13524054','13524053','13524052','13524051','13524050','13524049','13509483','13509482','13509481','13508981','13508980','13508979','13508016','13508015','13506818','13506817','13506816','13506815') ORDER BY FIELD(s.id, 13524056,13524055,13524054,13524053,13524052,13524051,13524050,13524049,13509483,13509482,13509481,13508981,13508980,13508979,13508016,13508015,13506818,13506817,13506816,13506815) [ RunTime:0.009333s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524056 LIMIT 4 [ RunTime:0.000844s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13524056 ORDER BY `minOrder` ASC [ RunTime:0.000646s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13524056 ORDER BY `unit` DESC [ RunTime:0.003075s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13524056 LIMIT 2 [ RunTime:0.022771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13524056 ORDER BY `minOrder` ASC [ RunTime:0.007306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524055 LIMIT 4 [ RunTime:0.010323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13524055 ORDER BY `minOrder` ASC [ RunTime:0.005490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13524055 ORDER BY `unit` DESC [ RunTime:0.018260s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13524055 LIMIT 2 [ RunTime:0.017571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13524055 ORDER BY `minOrder` ASC [ RunTime:0.000665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524054 LIMIT 4 [ RunTime:0.004092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13524054 ORDER BY `minOrder` ASC [ RunTime:0.024057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13524054 ORDER BY `unit` DESC [ RunTime:0.006963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13524054 LIMIT 2 [ RunTime:0.007395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13524054 ORDER BY `minOrder` ASC [ RunTime:0.004569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524053 LIMIT 4 [ RunTime:0.007501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13524053 ORDER BY `minOrder` ASC [ RunTime:0.025141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13524053 ORDER BY `unit` DESC [ RunTime:0.005556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13524053 LIMIT 2 [ RunTime:0.018590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13524053 ORDER BY `minOrder` ASC [ RunTime:0.011223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524052 LIMIT 4 [ RunTime:0.009185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13524052 ORDER BY `minOrder` ASC [ RunTime:0.018869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13524052 ORDER BY `unit` DESC [ RunTime:0.000760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13524052 LIMIT 2 [ RunTime:0.009349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13524052 ORDER BY `minOrder` ASC [ RunTime:0.002535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524051 LIMIT 4 [ RunTime:0.015757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13524051 ORDER BY `minOrder` ASC [ RunTime:0.004583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13524051 ORDER BY `unit` DESC [ RunTime:0.018226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13524051 LIMIT 2 [ RunTime:0.013893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13524051 ORDER BY `minOrder` ASC [ RunTime:0.014483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524050 LIMIT 4 [ RunTime:0.008400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13524050 ORDER BY `minOrder` ASC [ RunTime:0.001849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13524050 ORDER BY `unit` DESC [ RunTime:0.005152s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13524050 LIMIT 2 [ RunTime:0.012664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13524050 ORDER BY `minOrder` ASC [ RunTime:0.004576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524049 LIMIT 4 [ RunTime:0.026259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13524049 ORDER BY `minOrder` ASC [ RunTime:0.016005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13524049 ORDER BY `unit` DESC [ RunTime:0.003621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13524049 LIMIT 2 [ RunTime:0.000747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13524049 ORDER BY `minOrder` ASC [ RunTime:0.007265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13509483 LIMIT 4 [ RunTime:0.019143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13509483 ORDER BY `minOrder` ASC [ RunTime:0.010760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13509483 ORDER BY `unit` DESC [ RunTime:0.004424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13509483 LIMIT 2 [ RunTime:0.006746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13509483 ORDER BY `minOrder` ASC [ RunTime:0.007370s ]
select * from pdf where partno='2105A 0035000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.003305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13509482 LIMIT 4 [ RunTime:0.004679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13509482 ORDER BY `minOrder` ASC [ RunTime:0.002991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13509482 ORDER BY `unit` DESC [ RunTime:0.013788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13509482 LIMIT 2 [ RunTime:0.014500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13509482 ORDER BY `minOrder` ASC [ RunTime:0.003596s ]
select * from pdf where partno='2105A 0061000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13509481 LIMIT 4 [ RunTime:0.001038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13509481 ORDER BY `minOrder` ASC [ RunTime:0.021246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13509481 ORDER BY `unit` DESC [ RunTime:0.000759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13509481 LIMIT 2 [ RunTime:0.016726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13509481 ORDER BY `minOrder` ASC [ RunTime:0.001353s ]
select * from pdf where partno='2105A 0031000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.006908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13508981 LIMIT 4 [ RunTime:0.036687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13508981 ORDER BY `minOrder` ASC [ RunTime:0.054326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13508981 ORDER BY `unit` DESC [ RunTime:0.015607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13508981 LIMIT 2 [ RunTime:0.011705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13508981 ORDER BY `minOrder` ASC [ RunTime:0.013691s ]
select * from pdf where partno='2104A 0035000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13508980 LIMIT 4 [ RunTime:0.011027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13508980 ORDER BY `minOrder` ASC [ RunTime:0.015107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13508980 ORDER BY `unit` DESC [ RunTime:0.019172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13508980 LIMIT 2 [ RunTime:0.027089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13508980 ORDER BY `minOrder` ASC [ RunTime:0.016356s ]
select * from pdf where partno='2104A 0061000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.001271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13508979 LIMIT 4 [ RunTime:0.010666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13508979 ORDER BY `minOrder` ASC [ RunTime:0.009320s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13508979 ORDER BY `unit` DESC [ RunTime:0.012954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13508979 LIMIT 2 [ RunTime:0.001045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13508979 ORDER BY `minOrder` ASC [ RunTime:0.000621s ]
select * from pdf where partno='2104A 0031000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.001662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13508016 LIMIT 4 [ RunTime:0.020820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13508016 ORDER BY `minOrder` ASC [ RunTime:0.021322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13508016 ORDER BY `unit` DESC [ RunTime:0.006216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13508016 LIMIT 2 [ RunTime:0.004954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13508016 ORDER BY `minOrder` ASC [ RunTime:0.002208s ]
select * from pdf where partno='2103A 0061000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.007367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13508015 LIMIT 4 [ RunTime:0.015864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13508015 ORDER BY `minOrder` ASC [ RunTime:0.011652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13508015 ORDER BY `unit` DESC [ RunTime:0.019448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13508015 LIMIT 2 [ RunTime:0.016180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13508015 ORDER BY `minOrder` ASC [ RunTime:0.008873s ]
select * from pdf where partno='2103A 0031000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.002078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13506818 LIMIT 4 [ RunTime:0.010040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13506818 ORDER BY `minOrder` ASC [ RunTime:0.007959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13506818 ORDER BY `unit` DESC [ RunTime:0.015724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13506818 LIMIT 2 [ RunTime:0.012085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13506818 ORDER BY `minOrder` ASC [ RunTime:0.003222s ]
select * from pdf where partno='2102A 0065000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13506817 LIMIT 4 [ RunTime:0.007310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13506817 ORDER BY `minOrder` ASC [ RunTime:0.022870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13506817 ORDER BY `unit` DESC [ RunTime:0.001705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13506817 LIMIT 2 [ RunTime:0.005415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13506817 ORDER BY `minOrder` ASC [ RunTime:0.001279s ]
select * from pdf where partno='2102A 0035000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.002057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13506816 LIMIT 4 [ RunTime:0.007257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13506816 ORDER BY `minOrder` ASC [ RunTime:0.007669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13506816 ORDER BY `unit` DESC [ RunTime:0.005842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13506816 LIMIT 2 [ RunTime:0.016359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13506816 ORDER BY `minOrder` ASC [ RunTime:0.011845s ]
select * from pdf where partno='2102A 0061000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.023199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13506815 LIMIT 4 [ RunTime:0.019752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13506815 ORDER BY `minOrder` ASC [ RunTime:0.022336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13506815 ORDER BY `unit` DESC [ RunTime:0.046405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13506815 LIMIT 2 [ RunTime:0.026369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13506815 ORDER BY `minOrder` ASC [ RunTime:0.021757s ]
select * from pdf where partno='2102A 0031000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.013136s ]
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.019213s ]