SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003353s ]
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=304&srecordnum=7527' [ RunTime:0.006434s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001879s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.006346s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002057s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.002288s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001799s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000887s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001735s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.002150s ]
UPDATE `stock_search` SET `count` = 5653 , `updatetime` = '2026-06-08 22:55:59' WHERE `partno` = '210' [ RunTime:0.008082s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.004123s ]
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.005538s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002103s ]
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.001009s ]
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 6060,20 [ RunTime:0.083303s ]
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 ('14708555','14708424','14708361','14699012','14696598','14696593','14696591','14696587','14696584','14696581','14696580','14696562','14696561','14696560','14695724','14695723','14695722','14695721','14695720','14695719') ORDER BY FIELD(s.id, 14708555,14708424,14708361,14699012,14696598,14696593,14696591,14696587,14696584,14696581,14696580,14696562,14696561,14696560,14695724,14695723,14695722,14695721,14695720,14695719) [ RunTime:0.014378s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14708555 LIMIT 4 [ RunTime:0.004983s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14708555 ORDER BY `minOrder` ASC [ RunTime:0.012121s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14708555 ORDER BY `unit` DESC [ RunTime:0.000730s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14708555 LIMIT 2 [ RunTime:0.002124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14708555 ORDER BY `minOrder` ASC [ RunTime:0.002163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14708424 LIMIT 4 [ RunTime:0.003226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14708424 ORDER BY `minOrder` ASC [ RunTime:0.001352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14708424 ORDER BY `unit` DESC [ RunTime:0.017404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14708424 LIMIT 2 [ RunTime:0.001505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14708424 ORDER BY `minOrder` ASC [ RunTime:0.002057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14708361 LIMIT 4 [ RunTime:0.006178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14708361 ORDER BY `minOrder` ASC [ RunTime:0.003100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14708361 ORDER BY `unit` DESC [ RunTime:0.001407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14708361 LIMIT 2 [ RunTime:0.003235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14708361 ORDER BY `minOrder` ASC [ RunTime:0.000286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14699012 LIMIT 4 [ RunTime:0.000262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14699012 ORDER BY `minOrder` ASC [ RunTime:0.015564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14699012 ORDER BY `unit` DESC [ RunTime:0.006515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14699012 LIMIT 2 [ RunTime:0.006098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14699012 ORDER BY `minOrder` ASC [ RunTime:0.002185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14696598 LIMIT 4 [ RunTime:0.009418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14696598 ORDER BY `minOrder` ASC [ RunTime:0.001559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14696598 ORDER BY `unit` DESC [ RunTime:0.011571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14696598 LIMIT 2 [ RunTime:0.010562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14696598 ORDER BY `minOrder` ASC [ RunTime:0.012157s ]
select * from pdf where partno='21034494301' and brandshort='HARTING' limit 1 [ RunTime:0.007041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14696593 LIMIT 4 [ RunTime:0.002924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14696593 ORDER BY `minOrder` ASC [ RunTime:0.044895s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14696593 ORDER BY `unit` DESC [ RunTime:0.012157s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14696593 LIMIT 2 [ RunTime:0.007126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14696593 ORDER BY `minOrder` ASC [ RunTime:0.012248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14696591 LIMIT 4 [ RunTime:0.010720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14696591 ORDER BY `minOrder` ASC [ RunTime:0.020300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14696591 ORDER BY `unit` DESC [ RunTime:0.002894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14696591 LIMIT 2 [ RunTime:0.005264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14696591 ORDER BY `minOrder` ASC [ RunTime:0.002657s ]
select * from pdf where partno='21034157404' and brandshort='HARTING' limit 1 [ RunTime:0.002208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14696587 LIMIT 4 [ RunTime:0.030000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14696587 ORDER BY `minOrder` ASC [ RunTime:0.029387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14696587 ORDER BY `unit` DESC [ RunTime:0.006425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14696587 LIMIT 2 [ RunTime:0.004575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14696587 ORDER BY `minOrder` ASC [ RunTime:0.013120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14696584 LIMIT 4 [ RunTime:0.001406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14696584 ORDER BY `minOrder` ASC [ RunTime:0.065935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14696584 ORDER BY `unit` DESC [ RunTime:0.012246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14696584 LIMIT 2 [ RunTime:0.016746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14696584 ORDER BY `minOrder` ASC [ RunTime:0.009015s ]
select * from pdf where partno='21034496304' and brandshort='HARTING' limit 1 [ RunTime:0.006469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14696581 LIMIT 4 [ RunTime:0.028872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14696581 ORDER BY `minOrder` ASC [ RunTime:0.017539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14696581 ORDER BY `unit` DESC [ RunTime:0.019136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14696581 LIMIT 2 [ RunTime:0.004756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14696581 ORDER BY `minOrder` ASC [ RunTime:0.002789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14696580 LIMIT 4 [ RunTime:0.006493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14696580 ORDER BY `minOrder` ASC [ RunTime:0.030713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14696580 ORDER BY `unit` DESC [ RunTime:0.004452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14696580 LIMIT 2 [ RunTime:0.001364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14696580 ORDER BY `minOrder` ASC [ RunTime:0.021755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14696562 LIMIT 4 [ RunTime:0.005187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14696562 ORDER BY `minOrder` ASC [ RunTime:0.053434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14696562 ORDER BY `unit` DESC [ RunTime:0.001852s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14696562 LIMIT 2 [ RunTime:0.006913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14696562 ORDER BY `minOrder` ASC [ RunTime:0.006787s ]
select * from pdf where partno='21045164502' and brandshort='HARTING' limit 1 [ RunTime:0.023259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14696561 LIMIT 4 [ RunTime:0.014732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14696561 ORDER BY `minOrder` ASC [ RunTime:0.011239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14696561 ORDER BY `unit` DESC [ RunTime:0.021410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14696561 LIMIT 2 [ RunTime:0.008476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14696561 ORDER BY `minOrder` ASC [ RunTime:0.014252s ]
select * from pdf where partno='21044161502' and brandshort='HARTING' limit 1 [ RunTime:0.006426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14696560 LIMIT 4 [ RunTime:0.006173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14696560 ORDER BY `minOrder` ASC [ RunTime:0.005066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14696560 ORDER BY `unit` DESC [ RunTime:0.000482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14696560 LIMIT 2 [ RunTime:0.003788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14696560 ORDER BY `minOrder` ASC [ RunTime:0.003498s ]
select * from pdf where partno='21044161501' and brandshort='HARTING' limit 1 [ RunTime:0.017860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14695724 LIMIT 4 [ RunTime:0.016475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695724 ORDER BY `minOrder` ASC [ RunTime:0.009704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14695724 ORDER BY `unit` DESC [ RunTime:0.005344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14695724 LIMIT 2 [ RunTime:0.008160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695724 ORDER BY `minOrder` ASC [ RunTime:0.004152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14695723 LIMIT 4 [ RunTime:0.004569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695723 ORDER BY `minOrder` ASC [ RunTime:0.007646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14695723 ORDER BY `unit` DESC [ RunTime:0.020286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14695723 LIMIT 2 [ RunTime:0.001961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695723 ORDER BY `minOrder` ASC [ RunTime:0.011640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14695722 LIMIT 4 [ RunTime:0.011252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695722 ORDER BY `minOrder` ASC [ RunTime:0.003989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14695722 ORDER BY `unit` DESC [ RunTime:0.001766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14695722 LIMIT 2 [ RunTime:0.002148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695722 ORDER BY `minOrder` ASC [ RunTime:0.002983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14695721 LIMIT 4 [ RunTime:0.000563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695721 ORDER BY `minOrder` ASC [ RunTime:0.003095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14695721 ORDER BY `unit` DESC [ RunTime:0.000520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14695721 LIMIT 2 [ RunTime:0.002335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695721 ORDER BY `minOrder` ASC [ RunTime:0.001726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14695720 LIMIT 4 [ RunTime:0.005000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695720 ORDER BY `minOrder` ASC [ RunTime:0.000852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14695720 ORDER BY `unit` DESC [ RunTime:0.000922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14695720 LIMIT 2 [ RunTime:0.000403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695720 ORDER BY `minOrder` ASC [ RunTime:0.002687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14695719 LIMIT 4 [ RunTime:0.005198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695719 ORDER BY `minOrder` ASC [ RunTime:0.009440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14695719 ORDER BY `unit` DESC [ RunTime:0.014297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14695719 LIMIT 2 [ RunTime:0.006450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695719 ORDER BY `minOrder` ASC [ RunTime:0.004707s ]
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.001927s ]