SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002309s ]
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` = '' [ RunTime:0.004240s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002358s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.016085s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002182s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.008145s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002539s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.014519s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002083s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.029618s ]
UPDATE `stock_search` SET `count` = 2782 , `updatetime` = '2026-06-08 08:13:58' WHERE `partno` = '210' [ RunTime:0.039192s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.011823s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.008202s ]
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.026790s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002746s ]
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.018999s ]
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 1180,20 [ RunTime:0.102596s ]
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 ('33409317','34399204','34399197','34394665','11900192','10756270','35489279','34322313','13188375','34322033','33477126','12898820','10814455','35489489','34409920','33615796','33154059','32277759','32163257','35298116') ORDER BY FIELD(s.id, 33409317,34399204,34399197,34394665,11900192,10756270,35489279,34322313,13188375,34322033,33477126,12898820,10814455,35489489,34409920,33615796,33154059,32277759,32163257,35298116) [ RunTime:0.045916s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.016120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33409317 LIMIT 4 [ RunTime:0.000809s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33409317 ORDER BY `minOrder` ASC [ RunTime:0.037303s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33409317 ORDER BY `unit` DESC [ RunTime:0.063344s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.018427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33409317 LIMIT 2 [ RunTime:0.052766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33409317 ORDER BY `minOrder` ASC [ RunTime:0.016084s ]
select * from pdf where partno='21010000051' and brandshort='HARTING' limit 1 [ RunTime:0.046129s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002354s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21010000051' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.063173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34399204 LIMIT 4 [ RunTime:0.033665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34399204 ORDER BY `minOrder` ASC [ RunTime:0.045325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34399204 ORDER BY `unit` DESC [ RunTime:0.099072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34399204 LIMIT 2 [ RunTime:0.035311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34399204 ORDER BY `minOrder` ASC [ RunTime:0.036089s ]
select * from pdf where partno='21023592301' and brandshort='HARTING' limit 1 [ RunTime:0.049805s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21023592301' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.082558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34399197 LIMIT 4 [ RunTime:0.013664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34399197 ORDER BY `minOrder` ASC [ RunTime:0.013868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34399197 ORDER BY `unit` DESC [ RunTime:0.016833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34399197 LIMIT 2 [ RunTime:0.078028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34399197 ORDER BY `minOrder` ASC [ RunTime:0.009535s ]
select * from pdf where partno='21033194501' and brandshort='HARTING' limit 1 [ RunTime:0.036238s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033194501' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.089709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34394665 LIMIT 4 [ RunTime:0.096824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34394665 ORDER BY `minOrder` ASC [ RunTime:0.097334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34394665 ORDER BY `unit` DESC [ RunTime:0.230161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34394665 LIMIT 2 [ RunTime:0.088942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34394665 ORDER BY `minOrder` ASC [ RunTime:0.046538s ]
select * from pdf where partno='2102343-4' and brandshort='WEC' limit 1 [ RunTime:0.086655s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102343-4' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.136742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11900192 LIMIT 4 [ RunTime:0.027136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11900192 ORDER BY `minOrder` ASC [ RunTime:0.093874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11900192 ORDER BY `unit` DESC [ RunTime:0.190183s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11900192 LIMIT 2 [ RunTime:0.138450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11900192 ORDER BY `minOrder` ASC [ RunTime:0.065703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10756270 LIMIT 4 [ RunTime:0.046897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10756270 ORDER BY `minOrder` ASC [ RunTime:0.167658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10756270 ORDER BY `unit` DESC [ RunTime:0.141069s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10756270 LIMIT 2 [ RunTime:0.177727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10756270 ORDER BY `minOrder` ASC [ RunTime:0.082950s ]
select * from pdf where partno='21023592301' and brandshort='HARTING' limit 1 [ RunTime:0.000699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35489279 LIMIT 4 [ RunTime:0.079052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35489279 ORDER BY `minOrder` ASC [ RunTime:0.079991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35489279 ORDER BY `unit` DESC [ RunTime:0.063680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35489279 LIMIT 2 [ RunTime:0.072138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35489279 ORDER BY `minOrder` ASC [ RunTime:0.046141s ]
select * from pdf where partno='21033752400' and brandshort='HARTING' limit 1 [ RunTime:0.074826s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033752400' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.029770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34322313 LIMIT 4 [ RunTime:0.040322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322313 ORDER BY `minOrder` ASC [ RunTime:0.119360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34322313 ORDER BY `unit` DESC [ RunTime:0.014613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34322313 LIMIT 2 [ RunTime:0.080831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322313 ORDER BY `minOrder` ASC [ RunTime:0.070446s ]
select * from pdf where partno='210-93-310-41-001000' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.033702s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-93-310-41-001000' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.045778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13188375 LIMIT 4 [ RunTime:0.019411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188375 ORDER BY `minOrder` ASC [ RunTime:0.069503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13188375 ORDER BY `unit` DESC [ RunTime:0.027391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13188375 LIMIT 2 [ RunTime:0.059873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188375 ORDER BY `minOrder` ASC [ RunTime:0.017273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34322033 LIMIT 4 [ RunTime:0.025293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322033 ORDER BY `minOrder` ASC [ RunTime:0.092705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34322033 ORDER BY `unit` DESC [ RunTime:0.059340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34322033 LIMIT 2 [ RunTime:0.051635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322033 ORDER BY `minOrder` ASC [ RunTime:0.054944s ]
select * from pdf where partno='210-93-640-41-001000' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.053713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-93-640-41-001000' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.052792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33477126 LIMIT 4 [ RunTime:0.051159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33477126 ORDER BY `minOrder` ASC [ RunTime:0.053294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33477126 ORDER BY `unit` DESC [ RunTime:0.227592s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33477126 LIMIT 2 [ RunTime:0.168170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33477126 ORDER BY `minOrder` ASC [ RunTime:0.026442s ]
select * from pdf where partno='2102502-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.176791s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102502-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.192453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12898820 LIMIT 4 [ RunTime:0.057848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12898820 ORDER BY `minOrder` ASC [ RunTime:0.049693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12898820 ORDER BY `unit` DESC [ RunTime:0.021002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12898820 LIMIT 2 [ RunTime:0.031900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12898820 ORDER BY `minOrder` ASC [ RunTime:0.035962s ]
select * from pdf where partno='21038212511' and brandshort='HARTING' limit 1 [ RunTime:0.022603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10814455 LIMIT 4 [ RunTime:0.029410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10814455 ORDER BY `minOrder` ASC [ RunTime:0.018757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10814455 ORDER BY `unit` DESC [ RunTime:0.027076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10814455 LIMIT 2 [ RunTime:0.020026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10814455 ORDER BY `minOrder` ASC [ RunTime:0.003285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35489489 LIMIT 4 [ RunTime:0.018032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35489489 ORDER BY `minOrder` ASC [ RunTime:0.014038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35489489 ORDER BY `unit` DESC [ RunTime:0.014367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35489489 LIMIT 2 [ RunTime:0.009577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35489489 ORDER BY `minOrder` ASC [ RunTime:0.003250s ]
select * from pdf where partno='21033111501' and brandshort='HARTING' limit 1 [ RunTime:0.004545s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033111501' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.012029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34409920 LIMIT 4 [ RunTime:0.020845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34409920 ORDER BY `minOrder` ASC [ RunTime:0.007385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34409920 ORDER BY `unit` DESC [ RunTime:0.007997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34409920 LIMIT 2 [ RunTime:0.027057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34409920 ORDER BY `minOrder` ASC [ RunTime:0.002732s ]
select * from pdf where partno='21033091505' and brandshort='HARTING' limit 1 [ RunTime:0.040310s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033091505' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.084293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33615796 LIMIT 4 [ RunTime:0.038300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33615796 ORDER BY `minOrder` ASC [ RunTime:0.057858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33615796 ORDER BY `unit` DESC [ RunTime:0.016182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33615796 LIMIT 2 [ RunTime:0.021118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33615796 ORDER BY `minOrder` ASC [ RunTime:0.012242s ]
select * from pdf where partno='2102-1207' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.004507s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102-1207' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.008771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33154059 LIMIT 4 [ RunTime:0.004864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33154059 ORDER BY `minOrder` ASC [ RunTime:0.010490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33154059 ORDER BY `unit` DESC [ RunTime:0.009469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33154059 LIMIT 2 [ RunTime:0.004311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33154059 ORDER BY `minOrder` ASC [ RunTime:0.003251s ]
select * from pdf where partno='2100-7' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.002282s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100-7' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.006496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277759 LIMIT 4 [ RunTime:0.010763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277759 ORDER BY `minOrder` ASC [ RunTime:0.004564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277759 ORDER BY `unit` DESC [ RunTime:0.008452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277759 LIMIT 2 [ RunTime:0.003892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277759 ORDER BY `minOrder` ASC [ RunTime:0.003254s ]
select * from pdf where partno='2106136-2' and brandshort='te connectivity / p&b' limit 1 [ RunTime:0.004614s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106136-2' OR `brand` LIKE 'te connectivity / p&b%' ) ) LIMIT 1 [ RunTime:0.003349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32163257 LIMIT 4 [ RunTime:0.003856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163257 ORDER BY `minOrder` ASC [ RunTime:0.005983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32163257 ORDER BY `unit` DESC [ RunTime:0.014282s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32163257 LIMIT 2 [ RunTime:0.018707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163257 ORDER BY `minOrder` ASC [ RunTime:0.004054s ]
select * from pdf where partno='2106136-2' and brandshort='te connectivity / p&b' limit 1 [ RunTime:0.002255s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106136-2' OR `brand` LIKE 'te connectivity / p&b%' ) ) LIMIT 1 [ RunTime:0.002257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35298116 LIMIT 4 [ RunTime:0.006913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35298116 ORDER BY `minOrder` ASC [ RunTime:0.004810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35298116 ORDER BY `unit` DESC [ RunTime:0.013095s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35298116 LIMIT 2 [ RunTime:0.008984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35298116 ORDER BY `minOrder` ASC [ RunTime:0.001626s ]
select * from pdf where partno='210113003' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.003671s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210113003' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.009047s ]
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.069949s ]