SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002421s ]
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=82&srecordnum=7544' [ RunTime:0.001882s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.004022s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000766s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001872s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.002443s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001172s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000256s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001088s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.006293s ]
UPDATE `stock_search` SET `count` = 5413 , `updatetime` = '2026-06-08 22:53:48' WHERE `partno` = '210' [ RunTime:0.011233s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.003491s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000396s ]
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.000531s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001400s ]
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.003725s ]
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 1620,20 [ RunTime:0.087951s ]
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 ('36760639','36760635','36760634','36760558','36760555','34409357','33616169','12985118','12892225','11447288','10853832','10839590','10832333','114','38519418','36760829','36760759','36760753','36760688','34411219') ORDER BY FIELD(s.id, 36760639,36760635,36760634,36760558,36760555,34409357,33616169,12985118,12892225,11447288,10853832,10839590,10832333,114,38519418,36760829,36760759,36760753,36760688,34411219) [ RunTime:0.007280s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36760639 LIMIT 4 [ RunTime:0.000526s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760639 ORDER BY `minOrder` ASC [ RunTime:0.003126s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002272s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36760639 ORDER BY `unit` DESC [ RunTime:0.007599s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36760639 LIMIT 2 [ RunTime:0.015384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760639 ORDER BY `minOrder` ASC [ RunTime:0.009207s ]
select * from pdf where partno='210-113' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.002088s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003071s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-113' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.004263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36760635 LIMIT 4 [ RunTime:0.000421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760635 ORDER BY `minOrder` ASC [ RunTime:0.003871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36760635 ORDER BY `unit` DESC [ RunTime:0.000686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36760635 LIMIT 2 [ RunTime:0.002643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760635 ORDER BY `minOrder` ASC [ RunTime:0.000739s ]
select * from pdf where partno='210-112' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.011602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-112' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.002098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36760634 LIMIT 4 [ RunTime:0.011823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760634 ORDER BY `minOrder` ASC [ RunTime:0.005715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36760634 ORDER BY `unit` DESC [ RunTime:0.001043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36760634 LIMIT 2 [ RunTime:0.011564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760634 ORDER BY `minOrder` ASC [ RunTime:0.007975s ]
select * from pdf where partno='210-197' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.006875s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-197' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.001096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36760558 LIMIT 4 [ RunTime:0.000560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760558 ORDER BY `minOrder` ASC [ RunTime:0.003014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36760558 ORDER BY `unit` DESC [ RunTime:0.004343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36760558 LIMIT 2 [ RunTime:0.007083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760558 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
select * from pdf where partno='210-196' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.002357s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-196' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36760555 LIMIT 4 [ RunTime:0.000405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760555 ORDER BY `minOrder` ASC [ RunTime:0.004356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36760555 ORDER BY `unit` DESC [ RunTime:0.000451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36760555 LIMIT 2 [ RunTime:0.000408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760555 ORDER BY `minOrder` ASC [ RunTime:0.003580s ]
select * from pdf where partno='210-114' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000447s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-114' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34409357 LIMIT 4 [ RunTime:0.000405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34409357 ORDER BY `minOrder` ASC [ RunTime:0.006835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34409357 ORDER BY `unit` DESC [ RunTime:0.000438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34409357 LIMIT 2 [ RunTime:0.003536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34409357 ORDER BY `minOrder` ASC [ RunTime:0.000458s ]
select * from pdf where partno='21011301013' and brandshort='HARTING' limit 1 [ RunTime:0.000446s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21011301013' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.010998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33616169 LIMIT 4 [ RunTime:0.004285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33616169 ORDER BY `minOrder` ASC [ RunTime:0.001938s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33616169 ORDER BY `unit` DESC [ RunTime:0.002350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33616169 LIMIT 2 [ RunTime:0.014349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33616169 ORDER BY `minOrder` ASC [ RunTime:0.003825s ]
select * from pdf where partno='2104-5307' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.002504s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104-5307' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12985118 LIMIT 4 [ RunTime:0.000414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12985118 ORDER BY `minOrder` ASC [ RunTime:0.003450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12985118 ORDER BY `unit` DESC [ RunTime:0.002775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12985118 LIMIT 2 [ RunTime:0.002003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12985118 ORDER BY `minOrder` ASC [ RunTime:0.000636s ]
select * from pdf where partno='21038122511' and brandshort='HARTING' limit 1 [ RunTime:0.000425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12892225 LIMIT 4 [ RunTime:0.000399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12892225 ORDER BY `minOrder` ASC [ RunTime:0.001233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12892225 ORDER BY `unit` DESC [ RunTime:0.000433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12892225 LIMIT 2 [ RunTime:0.000388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12892225 ORDER BY `minOrder` ASC [ RunTime:0.003667s ]
select * from pdf where partno='21010000018' and brandshort='HARTING' limit 1 [ RunTime:0.002581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11447288 LIMIT 4 [ RunTime:0.004978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11447288 ORDER BY `minOrder` ASC [ RunTime:0.003677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11447288 ORDER BY `unit` DESC [ RunTime:0.004194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11447288 LIMIT 2 [ RunTime:0.000427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11447288 ORDER BY `minOrder` ASC [ RunTime:0.003219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10853832 LIMIT 4 [ RunTime:0.004891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10853832 ORDER BY `minOrder` ASC [ RunTime:0.000956s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10853832 ORDER BY `unit` DESC [ RunTime:0.000392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10853832 LIMIT 2 [ RunTime:0.000400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10853832 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
select * from pdf where partno='21011301013' and brandshort='HARTING' limit 1 [ RunTime:0.000426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10839590 LIMIT 4 [ RunTime:0.000396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10839590 ORDER BY `minOrder` ASC [ RunTime:0.004495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10839590 ORDER BY `unit` DESC [ RunTime:0.019968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10839590 LIMIT 2 [ RunTime:0.003635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10839590 ORDER BY `minOrder` ASC [ RunTime:0.005372s ]
select * from pdf where partno='21033812824' and brandshort='HARTING' limit 1 [ RunTime:0.002502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10832333 LIMIT 4 [ RunTime:0.006628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10832333 ORDER BY `minOrder` ASC [ RunTime:0.001356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10832333 ORDER BY `unit` DESC [ RunTime:0.002818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10832333 LIMIT 2 [ RunTime:0.000364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10832333 ORDER BY `minOrder` ASC [ RunTime:0.000413s ]
select * from pdf where partno='21023812431' and brandshort='HARTING' limit 1 [ RunTime:0.000432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 114 LIMIT 4 [ RunTime:0.011054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 114 ORDER BY `minOrder` ASC [ RunTime:0.001839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 114 ORDER BY `unit` DESC [ RunTime:0.002691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 114 LIMIT 2 [ RunTime:0.000429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 114 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106KL-04W-B40-L00' OR `brand` LIKE 'NMB TECHNOLOGIES%' ) ) LIMIT 1 [ RunTime:0.000600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38519418 LIMIT 4 [ RunTime:0.000346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38519418 ORDER BY `minOrder` ASC [ RunTime:0.000872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38519418 ORDER BY `unit` DESC [ RunTime:0.000357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38519418 LIMIT 2 [ RunTime:0.000404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38519418 ORDER BY `minOrder` ASC [ RunTime:0.000404s ]
select * from pdf where partno='2101720' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000798s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101720' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36760829 LIMIT 4 [ RunTime:0.000340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760829 ORDER BY `minOrder` ASC [ RunTime:0.002898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36760829 ORDER BY `unit` DESC [ RunTime:0.000441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36760829 LIMIT 2 [ RunTime:0.000380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760829 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
select * from pdf where partno='210-113' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000781s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-113' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36760759 LIMIT 4 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760759 ORDER BY `minOrder` ASC [ RunTime:0.000895s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36760759 ORDER BY `unit` DESC [ RunTime:0.000993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36760759 LIMIT 2 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760759 ORDER BY `minOrder` ASC [ RunTime:0.000413s ]
select * from pdf where partno='210-113' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-113' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36760753 LIMIT 4 [ RunTime:0.000384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760753 ORDER BY `minOrder` ASC [ RunTime:0.000719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36760753 ORDER BY `unit` DESC [ RunTime:0.004691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36760753 LIMIT 2 [ RunTime:0.000384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760753 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
select * from pdf where partno='210-111' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000506s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-111' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36760688 LIMIT 4 [ RunTime:0.000378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760688 ORDER BY `minOrder` ASC [ RunTime:0.001055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36760688 ORDER BY `unit` DESC [ RunTime:0.001654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36760688 LIMIT 2 [ RunTime:0.002613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760688 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
select * from pdf where partno='210-196' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001913s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-196' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34411219 LIMIT 4 [ RunTime:0.000381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34411219 ORDER BY `minOrder` ASC [ RunTime:0.003373s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34411219 ORDER BY `unit` DESC [ RunTime:0.000406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34411219 LIMIT 2 [ RunTime:0.000376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34411219 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
select * from pdf where partno='21033211530' and brandshort='HARTING' limit 1 [ RunTime:0.000519s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033211530' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.000412s ]
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.000510s ]