SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001775s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.60' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.003443s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001668s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004141s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002210s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.60' ) [ RunTime:0.007808s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001827s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001499s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002776s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.010899s ]
UPDATE `stock_search` SET `count` = 2478 , `updatetime` = '2026-06-08 05:08:28' WHERE `partno` = '210' [ RunTime:0.003607s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.008913s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.008110s ]
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.002247s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001490s ]
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.002084s ]
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 1240,20 [ RunTime:0.059832s ]
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 ('13317169','12619398','34401777','34322197','33303158','11922890','11529987','34404873','34401164','34399426','10862592','10750938','36760483','34401513','33466253','33453348','19578023','13316883','11900193','11484465') ORDER BY FIELD(s.id, 13317169,12619398,34401777,34322197,33303158,11922890,11529987,34404873,34401164,34399426,10862592,10750938,36760483,34401513,33466253,33453348,19578023,13316883,11900193,11484465) [ RunTime:0.020490s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13317169 LIMIT 4 [ RunTime:0.017649s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13317169 ORDER BY `minOrder` ASC [ RunTime:0.005718s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13317169 ORDER BY `unit` DESC [ RunTime:0.003165s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13317169 LIMIT 2 [ RunTime:0.025311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13317169 ORDER BY `minOrder` ASC [ RunTime:0.001899s ]
select * from pdf where partno='2108-832-N' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.016830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12619398 LIMIT 4 [ RunTime:0.008904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12619398 ORDER BY `minOrder` ASC [ RunTime:0.005164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12619398 ORDER BY `unit` DESC [ RunTime:0.009481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12619398 LIMIT 2 [ RunTime:0.026853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12619398 ORDER BY `minOrder` ASC [ RunTime:0.008847s ]
select * from pdf where partno='2103191-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.009593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34401777 LIMIT 4 [ RunTime:0.018051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34401777 ORDER BY `minOrder` ASC [ RunTime:0.024534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34401777 ORDER BY `unit` DESC [ RunTime:0.023884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34401777 LIMIT 2 [ RunTime:0.036447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34401777 ORDER BY `minOrder` ASC [ RunTime:0.008579s ]
select * from pdf where partno='21021451430' and brandshort='HARTING' limit 1 [ RunTime:0.028338s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004330s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21021451430' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.016190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34322197 LIMIT 4 [ RunTime:0.021857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322197 ORDER BY `minOrder` ASC [ RunTime:0.061578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34322197 ORDER BY `unit` DESC [ RunTime:0.046503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34322197 LIMIT 2 [ RunTime:0.012740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322197 ORDER BY `minOrder` ASC [ RunTime:0.001980s ]
select * from pdf where partno='210-47-624-41-001000' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.025945s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-47-624-41-001000' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.014563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33303158 LIMIT 4 [ RunTime:0.013492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33303158 ORDER BY `minOrder` ASC [ RunTime:0.023973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33303158 ORDER BY `unit` DESC [ RunTime:0.021334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33303158 LIMIT 2 [ RunTime:0.011967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33303158 ORDER BY `minOrder` ASC [ RunTime:0.001756s ]
select * from pdf where partno='2104-1292' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.019682s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104-1292' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.020462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11922890 LIMIT 4 [ RunTime:0.020857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11922890 ORDER BY `minOrder` ASC [ RunTime:0.024126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11922890 ORDER BY `unit` DESC [ RunTime:0.036846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11922890 LIMIT 2 [ RunTime:0.019710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11922890 ORDER BY `minOrder` ASC [ RunTime:0.001357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11529987 LIMIT 4 [ RunTime:0.034453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11529987 ORDER BY `minOrder` ASC [ RunTime:0.023276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11529987 ORDER BY `unit` DESC [ RunTime:0.028202s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11529987 LIMIT 2 [ RunTime:0.011021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11529987 ORDER BY `minOrder` ASC [ RunTime:0.022378s ]
select * from pdf where partno='2102061-3' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.008509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34404873 LIMIT 4 [ RunTime:0.006814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34404873 ORDER BY `minOrder` ASC [ RunTime:0.028392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34404873 ORDER BY `unit` DESC [ RunTime:0.025122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34404873 LIMIT 2 [ RunTime:0.014027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34404873 ORDER BY `minOrder` ASC [ RunTime:0.022980s ]
select * from pdf where partno='21033812820' and brandshort='HARTING' limit 1 [ RunTime:0.026806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033812820' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.027576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34401164 LIMIT 4 [ RunTime:0.019241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34401164 ORDER BY `minOrder` ASC [ RunTime:0.049928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34401164 ORDER BY `unit` DESC [ RunTime:0.050885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34401164 LIMIT 2 [ RunTime:0.007689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34401164 ORDER BY `minOrder` ASC [ RunTime:0.021759s ]
select * from pdf where partno='21033812807' and brandshort='HARTING' limit 1 [ RunTime:0.024127s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033812807' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.034492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34399426 LIMIT 4 [ RunTime:0.025742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34399426 ORDER BY `minOrder` ASC [ RunTime:0.022281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34399426 ORDER BY `unit` DESC [ RunTime:0.042750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34399426 LIMIT 2 [ RunTime:0.050404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34399426 ORDER BY `minOrder` ASC [ RunTime:0.013896s ]
select * from pdf where partno='21033191801' and brandshort='HARTING' limit 1 [ RunTime:0.021548s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033191801' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.015160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10862592 LIMIT 4 [ RunTime:0.035295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10862592 ORDER BY `minOrder` ASC [ RunTime:0.031138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10862592 ORDER BY `unit` DESC [ RunTime:0.050830s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10862592 LIMIT 2 [ RunTime:0.028692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10862592 ORDER BY `minOrder` ASC [ RunTime:0.012499s ]
select * from pdf where partno='21033812820' and brandshort='HARTING' limit 1 [ RunTime:0.018870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10750938 LIMIT 4 [ RunTime:0.034783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10750938 ORDER BY `minOrder` ASC [ RunTime:0.022318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10750938 ORDER BY `unit` DESC [ RunTime:0.018773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10750938 LIMIT 2 [ RunTime:0.029931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10750938 ORDER BY `minOrder` ASC [ RunTime:0.029755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36760483 LIMIT 4 [ RunTime:0.032431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760483 ORDER BY `minOrder` ASC [ RunTime:0.034832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36760483 ORDER BY `unit` DESC [ RunTime:0.026421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36760483 LIMIT 2 [ RunTime:0.077647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760483 ORDER BY `minOrder` ASC [ RunTime:0.026006s ]
select * from pdf where partno='210-114' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.007188s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-114' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.017472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34401513 LIMIT 4 [ RunTime:0.027081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34401513 ORDER BY `minOrder` ASC [ RunTime:0.008846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34401513 ORDER BY `unit` DESC [ RunTime:0.011435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34401513 LIMIT 2 [ RunTime:0.039617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34401513 ORDER BY `minOrder` ASC [ RunTime:0.021838s ]
select * from pdf where partno='21033712415' and brandshort='HARTING' limit 1 [ RunTime:0.027063s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033712415' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.021578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33466253 LIMIT 4 [ RunTime:0.025437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33466253 ORDER BY `minOrder` ASC [ RunTime:0.039079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33466253 ORDER BY `unit` DESC [ RunTime:0.030301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33466253 LIMIT 2 [ RunTime:0.093019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33466253 ORDER BY `minOrder` ASC [ RunTime:0.044065s ]
select * from pdf where partno='2103247-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.038727s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103247-6' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.069421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33453348 LIMIT 4 [ RunTime:0.051423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33453348 ORDER BY `minOrder` ASC [ RunTime:0.043423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33453348 ORDER BY `unit` DESC [ RunTime:0.085321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33453348 LIMIT 2 [ RunTime:0.039216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33453348 ORDER BY `minOrder` ASC [ RunTime:0.068047s ]
select * from pdf where partno='21011009934' and brandshort='HARTING' limit 1 [ RunTime:0.067693s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21011009934' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.027526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19578023 LIMIT 4 [ RunTime:0.044855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578023 ORDER BY `minOrder` ASC [ RunTime:0.014505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19578023 ORDER BY `unit` DESC [ RunTime:0.032563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19578023 LIMIT 2 [ RunTime:0.049164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578023 ORDER BY `minOrder` ASC [ RunTime:0.000688s ]
select * from pdf where partno='21011009932' and brandshort='HARTING' limit 1 [ RunTime:0.034336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13316883 LIMIT 4 [ RunTime:0.038498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316883 ORDER BY `minOrder` ASC [ RunTime:0.036875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13316883 ORDER BY `unit` DESC [ RunTime:0.012312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13316883 LIMIT 2 [ RunTime:0.059161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316883 ORDER BY `minOrder` ASC [ RunTime:0.002900s ]
select * from pdf where partno='2106-632-B-12' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.015113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11900193 LIMIT 4 [ RunTime:0.020579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11900193 ORDER BY `minOrder` ASC [ RunTime:0.006419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11900193 ORDER BY `unit` DESC [ RunTime:0.042808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11900193 LIMIT 2 [ RunTime:0.098254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11900193 ORDER BY `minOrder` ASC [ RunTime:0.017586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11484465 LIMIT 4 [ RunTime:0.008941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484465 ORDER BY `minOrder` ASC [ RunTime:0.006619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11484465 ORDER BY `unit` DESC [ RunTime:0.011613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11484465 LIMIT 2 [ RunTime:0.060912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484465 ORDER BY `minOrder` ASC [ RunTime:0.002470s ]
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.003949s ]