SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002643s ]
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.005018s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002026s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000598s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003638s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.000308s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002247s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005333s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002515s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.005834s ]
UPDATE `stock_search` SET `count` = 1915 , `updatetime` = '2026-06-06 21:01:11' WHERE `partno` = '210' [ RunTime:0.005128s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000414s ]
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.001746s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002961s ]
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.002721s ]
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 980,20 [ RunTime:0.070010s ]
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 ('35489442','13423996','12996084','34400970','33409317','34399204','34399197','34394665','11900192','10756270','35489279','34322313','13188375','34322033','33477126','12898820','10814455','35489489','34409920','33615796') ORDER BY FIELD(s.id, 35489442,13423996,12996084,34400970,33409317,34399204,34399197,34394665,11900192,10756270,35489279,34322313,13188375,34322033,33477126,12898820,10814455,35489489,34409920,33615796) [ RunTime:0.037948s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35489442 LIMIT 4 [ RunTime:0.009588s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35489442 ORDER BY `minOrder` ASC [ RunTime:0.004467s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35489442 ORDER BY `unit` DESC [ RunTime:0.010406s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35489442 LIMIT 2 [ RunTime:0.003094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35489442 ORDER BY `minOrder` ASC [ RunTime:0.008433s ]
select * from pdf where partno='21033532C00' and brandshort='HARTING' limit 1 [ RunTime:0.008764s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001369s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033532C00' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.016589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13423996 LIMIT 4 [ RunTime:0.014786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13423996 ORDER BY `minOrder` ASC [ RunTime:0.004067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13423996 ORDER BY `unit` DESC [ RunTime:0.002239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13423996 LIMIT 2 [ RunTime:0.003707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13423996 ORDER BY `minOrder` ASC [ RunTime:0.001898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12996084 LIMIT 4 [ RunTime:0.011433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12996084 ORDER BY `minOrder` ASC [ RunTime:0.002694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12996084 ORDER BY `unit` DESC [ RunTime:0.010870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12996084 LIMIT 2 [ RunTime:0.013570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12996084 ORDER BY `minOrder` ASC [ RunTime:0.006773s ]
select * from pdf where partno='21033021000407' and brandshort='HARTING' limit 1 [ RunTime:0.009245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34400970 LIMIT 4 [ RunTime:0.010329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34400970 ORDER BY `minOrder` ASC [ RunTime:0.001663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34400970 ORDER BY `unit` DESC [ RunTime:0.008096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34400970 LIMIT 2 [ RunTime:0.006346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34400970 ORDER BY `minOrder` ASC [ RunTime:0.003165s ]
select * from pdf where partno='21031112405' and brandshort='HARTING' limit 1 [ RunTime:0.007137s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21031112405' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.003789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33409317 LIMIT 4 [ RunTime:0.016427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33409317 ORDER BY `minOrder` ASC [ RunTime:0.011109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33409317 ORDER BY `unit` DESC [ RunTime:0.018624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33409317 LIMIT 2 [ RunTime:0.017376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33409317 ORDER BY `minOrder` ASC [ RunTime:0.007684s ]
select * from pdf where partno='21010000051' and brandshort='HARTING' limit 1 [ RunTime:0.017045s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21010000051' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.007886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34399204 LIMIT 4 [ RunTime:0.012505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34399204 ORDER BY `minOrder` ASC [ RunTime:0.007260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34399204 ORDER BY `unit` DESC [ RunTime:0.016862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34399204 LIMIT 2 [ RunTime:0.009510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34399204 ORDER BY `minOrder` ASC [ RunTime:0.012439s ]
select * from pdf where partno='21023592301' and brandshort='HARTING' limit 1 [ RunTime:0.004402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21023592301' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.008305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34399197 LIMIT 4 [ RunTime:0.009415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34399197 ORDER BY `minOrder` ASC [ RunTime:0.013219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34399197 ORDER BY `unit` DESC [ RunTime:0.031965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34399197 LIMIT 2 [ RunTime:0.012841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34399197 ORDER BY `minOrder` ASC [ RunTime:0.014234s ]
select * from pdf where partno='21033194501' and brandshort='HARTING' limit 1 [ RunTime:0.003457s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033194501' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.007853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34394665 LIMIT 4 [ RunTime:0.003272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34394665 ORDER BY `minOrder` ASC [ RunTime:0.013726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34394665 ORDER BY `unit` DESC [ RunTime:0.009998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34394665 LIMIT 2 [ RunTime:0.019215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34394665 ORDER BY `minOrder` ASC [ RunTime:0.005450s ]
select * from pdf where partno='2102343-4' and brandshort='WEC' limit 1 [ RunTime:0.013084s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102343-4' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.011265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11900192 LIMIT 4 [ RunTime:0.014764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11900192 ORDER BY `minOrder` ASC [ RunTime:0.010341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11900192 ORDER BY `unit` DESC [ RunTime:0.012424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11900192 LIMIT 2 [ RunTime:0.006114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11900192 ORDER BY `minOrder` ASC [ RunTime:0.004354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10756270 LIMIT 4 [ RunTime:0.006081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10756270 ORDER BY `minOrder` ASC [ RunTime:0.018559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10756270 ORDER BY `unit` DESC [ RunTime:0.005780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10756270 LIMIT 2 [ RunTime:0.004225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10756270 ORDER BY `minOrder` ASC [ RunTime:0.003703s ]
select * from pdf where partno='21023592301' and brandshort='HARTING' limit 1 [ RunTime:0.003249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35489279 LIMIT 4 [ RunTime:0.011487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35489279 ORDER BY `minOrder` ASC [ RunTime:0.002784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35489279 ORDER BY `unit` DESC [ RunTime:0.019099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35489279 LIMIT 2 [ RunTime:0.010951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35489279 ORDER BY `minOrder` ASC [ RunTime:0.000484s ]
select * from pdf where partno='21033752400' and brandshort='HARTING' limit 1 [ RunTime:0.010309s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033752400' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.005974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34322313 LIMIT 4 [ RunTime:0.025290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322313 ORDER BY `minOrder` ASC [ RunTime:0.022987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34322313 ORDER BY `unit` DESC [ RunTime:0.018528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34322313 LIMIT 2 [ RunTime:0.012067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322313 ORDER BY `minOrder` ASC [ RunTime:0.004589s ]
select * from pdf where partno='210-93-310-41-001000' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.012350s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-93-310-41-001000' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.009510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13188375 LIMIT 4 [ RunTime:0.007915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188375 ORDER BY `minOrder` ASC [ RunTime:0.004346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13188375 ORDER BY `unit` DESC [ RunTime:0.002436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13188375 LIMIT 2 [ RunTime:0.000652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13188375 ORDER BY `minOrder` ASC [ RunTime:0.004798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34322033 LIMIT 4 [ RunTime:0.004610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322033 ORDER BY `minOrder` ASC [ RunTime:0.015323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34322033 ORDER BY `unit` DESC [ RunTime:0.011450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34322033 LIMIT 2 [ RunTime:0.011217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322033 ORDER BY `minOrder` ASC [ RunTime:0.002434s ]
select * from pdf where partno='210-93-640-41-001000' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.027770s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-93-640-41-001000' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.010644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33477126 LIMIT 4 [ RunTime:0.035888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33477126 ORDER BY `minOrder` ASC [ RunTime:0.040974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33477126 ORDER BY `unit` DESC [ RunTime:0.038342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33477126 LIMIT 2 [ RunTime:0.031936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33477126 ORDER BY `minOrder` ASC [ RunTime:0.007866s ]
select * from pdf where partno='2102502-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.012570s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102502-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.014617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12898820 LIMIT 4 [ RunTime:0.010094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12898820 ORDER BY `minOrder` ASC [ RunTime:0.027838s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12898820 ORDER BY `unit` DESC [ RunTime:0.010167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12898820 LIMIT 2 [ RunTime:0.008809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12898820 ORDER BY `minOrder` ASC [ RunTime:0.008772s ]
select * from pdf where partno='21038212511' and brandshort='HARTING' limit 1 [ RunTime:0.017175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10814455 LIMIT 4 [ RunTime:0.018860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10814455 ORDER BY `minOrder` ASC [ RunTime:0.025053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10814455 ORDER BY `unit` DESC [ RunTime:0.069176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10814455 LIMIT 2 [ RunTime:0.100497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10814455 ORDER BY `minOrder` ASC [ RunTime:0.007886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35489489 LIMIT 4 [ RunTime:0.021435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35489489 ORDER BY `minOrder` ASC [ RunTime:0.024536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35489489 ORDER BY `unit` DESC [ RunTime:0.020776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35489489 LIMIT 2 [ RunTime:0.060164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35489489 ORDER BY `minOrder` ASC [ RunTime:0.008717s ]
select * from pdf where partno='21033111501' and brandshort='HARTING' limit 1 [ RunTime:0.010272s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033111501' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.025006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34409920 LIMIT 4 [ RunTime:0.015334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34409920 ORDER BY `minOrder` ASC [ RunTime:0.026262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34409920 ORDER BY `unit` DESC [ RunTime:0.017775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34409920 LIMIT 2 [ RunTime:0.028963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34409920 ORDER BY `minOrder` ASC [ RunTime:0.005765s ]
select * from pdf where partno='21033091505' and brandshort='HARTING' limit 1 [ RunTime:0.007405s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033091505' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.010667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33615796 LIMIT 4 [ RunTime:0.015501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33615796 ORDER BY `minOrder` ASC [ RunTime:0.014620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33615796 ORDER BY `unit` DESC [ RunTime:0.011607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33615796 LIMIT 2 [ RunTime:0.028125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33615796 ORDER BY `minOrder` ASC [ RunTime:0.014885s ]
select * from pdf where partno='2102-1207' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.006000s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102-1207' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.011509s ]
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.007517s ]