SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002274s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.220' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.002861s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002699s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000527s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003054s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.000406s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002747s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000345s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002147s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.003840s ]
UPDATE `stock_search` SET `count` = 1914 , `updatetime` = '2026-06-06 21:01:11' WHERE `partno` = '210' [ RunTime:0.001951s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001778s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000298s ]
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.000472s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002194s ]
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.076543s ]
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 700,20 [ RunTime:0.036724s ]
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 ('11883451','13800239','34360153','12632750','35294927','13438159','13314805','35294381','34358552','34280116','11037715','13521489','34360119','16197347','10848209','10831804','13413286','10859346','33855324','34360612') ORDER BY FIELD(s.id, 11883451,13800239,34360153,12632750,35294927,13438159,13314805,35294381,34358552,34280116,11037715,13521489,34360119,16197347,10848209,10831804,13413286,10859346,33855324,34360612) [ RunTime:0.027610s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11883451 LIMIT 4 [ RunTime:0.006298s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11883451 ORDER BY `minOrder` ASC [ RunTime:0.006027s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11883451 ORDER BY `unit` DESC [ RunTime:0.005378s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11883451 LIMIT 2 [ RunTime:0.007786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11883451 ORDER BY `minOrder` ASC [ RunTime:0.000492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13800239 LIMIT 4 [ RunTime:0.006086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13800239 ORDER BY `minOrder` ASC [ RunTime:0.002861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13800239 ORDER BY `unit` DESC [ RunTime:0.015776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13800239 LIMIT 2 [ RunTime:0.010476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13800239 ORDER BY `minOrder` ASC [ RunTime:0.005652s ]
select * from pdf where partno='21023576305' and brandshort='HARTING' limit 1 [ RunTime:0.005048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34360153 LIMIT 4 [ RunTime:0.004089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34360153 ORDER BY `minOrder` ASC [ RunTime:0.006948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34360153 ORDER BY `unit` DESC [ RunTime:0.006837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34360153 LIMIT 2 [ RunTime:0.010844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34360153 ORDER BY `minOrder` ASC [ RunTime:0.013985s ]
select * from pdf where partno='21008515-02' and brandshort='Chogori Technologies Inc.' limit 1 [ RunTime:0.011065s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002555s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21008515-02' OR `brand` LIKE 'Chogori Technologies Inc.%' ) ) LIMIT 1 [ RunTime:0.002358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12632750 LIMIT 4 [ RunTime:0.014503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12632750 ORDER BY `minOrder` ASC [ RunTime:0.006622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12632750 ORDER BY `unit` DESC [ RunTime:0.006497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12632750 LIMIT 2 [ RunTime:0.003225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12632750 ORDER BY `minOrder` ASC [ RunTime:0.005290s ]
select * from pdf where partno='2106751-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35294927 LIMIT 4 [ RunTime:0.000634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35294927 ORDER BY `minOrder` ASC [ RunTime:0.012139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35294927 ORDER BY `unit` DESC [ RunTime:0.006497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35294927 LIMIT 2 [ RunTime:0.007881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35294927 ORDER BY `minOrder` ASC [ RunTime:0.007364s ]
select * from pdf where partno='2101-0200-15' and brandshort='Encitech Connectors AB' limit 1 [ RunTime:0.028386s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101-0200-15' OR `brand` LIKE 'Encitech Connectors AB%' ) ) LIMIT 1 [ RunTime:0.016751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13438159 LIMIT 4 [ RunTime:0.016248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13438159 ORDER BY `minOrder` ASC [ RunTime:0.003579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13438159 ORDER BY `unit` DESC [ RunTime:0.015277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13438159 LIMIT 2 [ RunTime:0.012057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13438159 ORDER BY `minOrder` ASC [ RunTime:0.007403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13314805 LIMIT 4 [ RunTime:0.011918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13314805 ORDER BY `minOrder` ASC [ RunTime:0.012391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13314805 ORDER BY `unit` DESC [ RunTime:0.012161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13314805 LIMIT 2 [ RunTime:0.009296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13314805 ORDER BY `minOrder` ASC [ RunTime:0.000743s ]
select * from pdf where partno='2104-440-SS' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.018142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35294381 LIMIT 4 [ RunTime:0.014857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35294381 ORDER BY `minOrder` ASC [ RunTime:0.029963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35294381 ORDER BY `unit` DESC [ RunTime:0.011656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35294381 LIMIT 2 [ RunTime:0.001983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35294381 ORDER BY `minOrder` ASC [ RunTime:0.010199s ]
select * from pdf where partno='2101-0180-13' and brandshort='Encitech Connectors AB' limit 1 [ RunTime:0.008662s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101-0180-13' OR `brand` LIKE 'Encitech Connectors AB%' ) ) LIMIT 1 [ RunTime:0.016339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34358552 LIMIT 4 [ RunTime:0.002595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34358552 ORDER BY `minOrder` ASC [ RunTime:0.022730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34358552 ORDER BY `unit` DESC [ RunTime:0.019789s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34358552 LIMIT 2 [ RunTime:0.008869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34358552 ORDER BY `minOrder` ASC [ RunTime:0.005657s ]
select * from pdf where partno='21005211-01' and brandshort='Chogori Technologies Inc.' limit 1 [ RunTime:0.008874s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21005211-01' OR `brand` LIKE 'Chogori Technologies Inc.%' ) ) LIMIT 1 [ RunTime:0.007541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34280116 LIMIT 4 [ RunTime:0.018119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34280116 ORDER BY `minOrder` ASC [ RunTime:0.004433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34280116 ORDER BY `unit` DESC [ RunTime:0.009817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34280116 LIMIT 2 [ RunTime:0.011259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34280116 ORDER BY `minOrder` ASC [ RunTime:0.001259s ]
select * from pdf where partno='2102785-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.013855s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102785-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.007067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11037715 LIMIT 4 [ RunTime:0.013136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11037715 ORDER BY `minOrder` ASC [ RunTime:0.006717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11037715 ORDER BY `unit` DESC [ RunTime:0.028197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11037715 LIMIT 2 [ RunTime:0.003942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11037715 ORDER BY `minOrder` ASC [ RunTime:0.003413s ]
select * from pdf where partno='21033216410' and brandshort='HARTING' limit 1 [ RunTime:0.003313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13521489 LIMIT 4 [ RunTime:0.013249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13521489 ORDER BY `minOrder` ASC [ RunTime:0.025445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13521489 ORDER BY `unit` DESC [ RunTime:0.038363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13521489 LIMIT 2 [ RunTime:0.006229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13521489 ORDER BY `minOrder` ASC [ RunTime:0.009373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34360119 LIMIT 4 [ RunTime:0.007251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34360119 ORDER BY `minOrder` ASC [ RunTime:0.019656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34360119 ORDER BY `unit` DESC [ RunTime:0.007140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34360119 LIMIT 2 [ RunTime:0.004669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34360119 ORDER BY `minOrder` ASC [ RunTime:0.001690s ]
select * from pdf where partno='21006515-02' and brandshort='Chogori Technologies Inc.' limit 1 [ RunTime:0.007564s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21006515-02' OR `brand` LIKE 'Chogori Technologies Inc.%' ) ) LIMIT 1 [ RunTime:0.011069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16197347 LIMIT 4 [ RunTime:0.010662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16197347 ORDER BY `minOrder` ASC [ RunTime:0.017999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16197347 ORDER BY `unit` DESC [ RunTime:0.002907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16197347 LIMIT 2 [ RunTime:0.020716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16197347 ORDER BY `minOrder` ASC [ RunTime:0.015232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10848209 LIMIT 4 [ RunTime:0.015739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10848209 ORDER BY `minOrder` ASC [ RunTime:0.010638s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10848209 ORDER BY `unit` DESC [ RunTime:0.011665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10848209 LIMIT 2 [ RunTime:0.024955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10848209 ORDER BY `minOrder` ASC [ RunTime:0.042123s ]
select * from pdf where partno='21033112811' and brandshort='HARTING' limit 1 [ RunTime:0.019090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10831804 LIMIT 4 [ RunTime:0.021025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10831804 ORDER BY `minOrder` ASC [ RunTime:0.016408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10831804 ORDER BY `unit` DESC [ RunTime:0.012930s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10831804 LIMIT 2 [ RunTime:0.014763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10831804 ORDER BY `minOrder` ASC [ RunTime:0.013729s ]
select * from pdf where partno='21033112411' and brandshort='HARTING' limit 1 [ RunTime:0.043094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13413286 LIMIT 4 [ RunTime:0.016143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13413286 ORDER BY `minOrder` ASC [ RunTime:0.021521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13413286 ORDER BY `unit` DESC [ RunTime:0.016444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13413286 LIMIT 2 [ RunTime:0.041498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13413286 ORDER BY `minOrder` ASC [ RunTime:0.029377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10859346 LIMIT 4 [ RunTime:0.050764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10859346 ORDER BY `minOrder` ASC [ RunTime:0.049568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10859346 ORDER BY `unit` DESC [ RunTime:0.021388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10859346 LIMIT 2 [ RunTime:0.025545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10859346 ORDER BY `minOrder` ASC [ RunTime:0.023272s ]
select * from pdf where partno='21033812821' and brandshort='HARTING' limit 1 [ RunTime:0.038043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33855324 LIMIT 4 [ RunTime:0.044033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33855324 ORDER BY `minOrder` ASC [ RunTime:0.020975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33855324 ORDER BY `unit` DESC [ RunTime:0.018606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33855324 LIMIT 2 [ RunTime:0.001521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33855324 ORDER BY `minOrder` ASC [ RunTime:0.010590s ]
select * from pdf where partno='2108690000' and brandshort='Weidmüller' limit 1 [ RunTime:0.013366s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108690000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.019450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34360612 LIMIT 4 [ RunTime:0.027824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34360612 ORDER BY `minOrder` ASC [ RunTime:0.011628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34360612 ORDER BY `unit` DESC [ RunTime:0.005877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34360612 LIMIT 2 [ RunTime:0.006080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34360612 ORDER BY `minOrder` ASC [ RunTime:0.005321s ]
select * from pdf where partno='21033812821' and brandshort='HARTING' limit 1 [ RunTime:0.003493s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033812821' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.017420s ]
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.008961s ]