SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002616s ]
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=356&srecordnum=7544' [ RunTime:0.005177s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002951s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.005757s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003274s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.003774s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002291s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003081s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002463s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.005599s ]
UPDATE `stock_search` SET `count` = 5568 , `updatetime` = '2026-06-08 22:55:01' WHERE `partno` = '210' [ RunTime:0.010344s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.002013s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000299s ]
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.000917s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002635s ]
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.001644s ]
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 7100,20 [ RunTime:0.109661s ]
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 ('12029856','12029750','12029731','12029526','12029458','12029326','12029180','12029179','12029149','12028914','12028789','12028162','12027891','12027386','12027152','12026953','12026914','12026826','12026587','12026538') ORDER BY FIELD(s.id, 12029856,12029750,12029731,12029526,12029458,12029326,12029180,12029179,12029149,12028914,12028789,12028162,12027891,12027386,12027152,12026953,12026914,12026826,12026587,12026538) [ RunTime:0.027532s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12029856 LIMIT 4 [ RunTime:0.002890s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029856 ORDER BY `minOrder` ASC [ RunTime:0.004723s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12029856 ORDER BY `unit` DESC [ RunTime:0.004650s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12029856 LIMIT 2 [ RunTime:0.006141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029856 ORDER BY `minOrder` ASC [ RunTime:0.003252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12029750 LIMIT 4 [ RunTime:0.015574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029750 ORDER BY `minOrder` ASC [ RunTime:0.009215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12029750 ORDER BY `unit` DESC [ RunTime:0.000527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12029750 LIMIT 2 [ RunTime:0.003987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029750 ORDER BY `minOrder` ASC [ RunTime:0.001442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12029731 LIMIT 4 [ RunTime:0.006489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029731 ORDER BY `minOrder` ASC [ RunTime:0.022488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12029731 ORDER BY `unit` DESC [ RunTime:0.004369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12029731 LIMIT 2 [ RunTime:0.008687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029731 ORDER BY `minOrder` ASC [ RunTime:0.000511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12029526 LIMIT 4 [ RunTime:0.024248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029526 ORDER BY `minOrder` ASC [ RunTime:0.023809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12029526 ORDER BY `unit` DESC [ RunTime:0.008701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12029526 LIMIT 2 [ RunTime:0.010373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029526 ORDER BY `minOrder` ASC [ RunTime:0.003791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12029458 LIMIT 4 [ RunTime:0.008919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029458 ORDER BY `minOrder` ASC [ RunTime:0.018616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12029458 ORDER BY `unit` DESC [ RunTime:0.007781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12029458 LIMIT 2 [ RunTime:0.008679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029458 ORDER BY `minOrder` ASC [ RunTime:0.013936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12029326 LIMIT 4 [ RunTime:0.000398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029326 ORDER BY `minOrder` ASC [ RunTime:0.006648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12029326 ORDER BY `unit` DESC [ RunTime:0.000545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12029326 LIMIT 2 [ RunTime:0.002885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029326 ORDER BY `minOrder` ASC [ RunTime:0.006095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12029180 LIMIT 4 [ RunTime:0.014182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029180 ORDER BY `minOrder` ASC [ RunTime:0.003220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12029180 ORDER BY `unit` DESC [ RunTime:0.000925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12029180 LIMIT 2 [ RunTime:0.017484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029180 ORDER BY `minOrder` ASC [ RunTime:0.003832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12029179 LIMIT 4 [ RunTime:0.003883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029179 ORDER BY `minOrder` ASC [ RunTime:0.009533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12029179 ORDER BY `unit` DESC [ RunTime:0.003479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12029179 LIMIT 2 [ RunTime:0.000393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029179 ORDER BY `minOrder` ASC [ RunTime:0.000311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12029149 LIMIT 4 [ RunTime:0.000398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029149 ORDER BY `minOrder` ASC [ RunTime:0.007802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12029149 ORDER BY `unit` DESC [ RunTime:0.010305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12029149 LIMIT 2 [ RunTime:0.008005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029149 ORDER BY `minOrder` ASC [ RunTime:0.004421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12028914 LIMIT 4 [ RunTime:0.000432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12028914 ORDER BY `minOrder` ASC [ RunTime:0.004848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12028914 ORDER BY `unit` DESC [ RunTime:0.000846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12028914 LIMIT 2 [ RunTime:0.002224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12028914 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12028789 LIMIT 4 [ RunTime:0.002175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12028789 ORDER BY `minOrder` ASC [ RunTime:0.021006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12028789 ORDER BY `unit` DESC [ RunTime:0.006366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12028789 LIMIT 2 [ RunTime:0.000465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12028789 ORDER BY `minOrder` ASC [ RunTime:0.003577s ]
select * from pdf where partno='2109452-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12028162 LIMIT 4 [ RunTime:0.003113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12028162 ORDER BY `minOrder` ASC [ RunTime:0.028572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12028162 ORDER BY `unit` DESC [ RunTime:0.019314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12028162 LIMIT 2 [ RunTime:0.006051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12028162 ORDER BY `minOrder` ASC [ RunTime:0.005310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12027891 LIMIT 4 [ RunTime:0.000882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12027891 ORDER BY `minOrder` ASC [ RunTime:0.005571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12027891 ORDER BY `unit` DESC [ RunTime:0.014786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12027891 LIMIT 2 [ RunTime:0.030060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12027891 ORDER BY `minOrder` ASC [ RunTime:0.000597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12027386 LIMIT 4 [ RunTime:0.001541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12027386 ORDER BY `minOrder` ASC [ RunTime:0.001626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12027386 ORDER BY `unit` DESC [ RunTime:0.005555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12027386 LIMIT 2 [ RunTime:0.011938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12027386 ORDER BY `minOrder` ASC [ RunTime:0.000535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12027152 LIMIT 4 [ RunTime:0.000501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12027152 ORDER BY `minOrder` ASC [ RunTime:0.006188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12027152 ORDER BY `unit` DESC [ RunTime:0.002543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12027152 LIMIT 2 [ RunTime:0.009711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12027152 ORDER BY `minOrder` ASC [ RunTime:0.003551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12026953 LIMIT 4 [ RunTime:0.005916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12026953 ORDER BY `minOrder` ASC [ RunTime:0.001598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12026953 ORDER BY `unit` DESC [ RunTime:0.001889s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12026953 LIMIT 2 [ RunTime:0.002390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12026953 ORDER BY `minOrder` ASC [ RunTime:0.000831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12026914 LIMIT 4 [ RunTime:0.000552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12026914 ORDER BY `minOrder` ASC [ RunTime:0.008312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12026914 ORDER BY `unit` DESC [ RunTime:0.007212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12026914 LIMIT 2 [ RunTime:0.001153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12026914 ORDER BY `minOrder` ASC [ RunTime:0.000548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12026826 LIMIT 4 [ RunTime:0.000625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12026826 ORDER BY `minOrder` ASC [ RunTime:0.001522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12026826 ORDER BY `unit` DESC [ RunTime:0.000586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12026826 LIMIT 2 [ RunTime:0.000603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12026826 ORDER BY `minOrder` ASC [ RunTime:0.000508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12026587 LIMIT 4 [ RunTime:0.000504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12026587 ORDER BY `minOrder` ASC [ RunTime:0.000876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12026587 ORDER BY `unit` DESC [ RunTime:0.000614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12026587 LIMIT 2 [ RunTime:0.000456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12026587 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12026538 LIMIT 4 [ RunTime:0.000416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12026538 ORDER BY `minOrder` ASC [ RunTime:0.000663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12026538 ORDER BY `unit` DESC [ RunTime:0.003310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12026538 LIMIT 2 [ RunTime:0.000407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12026538 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
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.000565s ]