SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001508s ]
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.002573s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001678s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000533s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001729s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.000448s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001543s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000326s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002023s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.005176s ]
UPDATE `stock_search` SET `count` = 2012 , `updatetime` = '2026-06-06 21:11:23' WHERE `partno` = '210' [ RunTime:0.018407s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000259s ]
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.000542s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001647s ]
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.054758s ]
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 1360,20 [ RunTime:0.033733s ]
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 ('34399721','33884963','33618643','33618639','13794524','12991127','11447286','10857101','10834082','35489362','35296887','34362279','13794531','12236778','12198589','11758247','11756083','10902366','34401892','34322461') ORDER BY FIELD(s.id, 34399721,33884963,33618643,33618639,13794524,12991127,11447286,10857101,10834082,35489362,35296887,34362279,13794531,12236778,12198589,11758247,11756083,10902366,34401892,34322461) [ RunTime:0.003978s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34399721 LIMIT 4 [ RunTime:0.000404s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34399721 ORDER BY `minOrder` ASC [ RunTime:0.002393s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34399721 ORDER BY `unit` DESC [ RunTime:0.000492s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34399721 LIMIT 2 [ RunTime:0.000361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34399721 ORDER BY `minOrder` ASC [ RunTime:0.001455s ]
select * from pdf where partno='21032812405' and brandshort='HARTING' limit 1 [ RunTime:0.001590s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002047s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21032812405' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.001355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33884963 LIMIT 4 [ RunTime:0.007388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33884963 ORDER BY `minOrder` ASC [ RunTime:0.000820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33884963 ORDER BY `unit` DESC [ RunTime:0.004835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33884963 LIMIT 2 [ RunTime:0.000814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33884963 ORDER BY `minOrder` ASC [ RunTime:0.000273s ]
select * from pdf where partno='2102582-1' and brandshort='WEC' limit 1 [ RunTime:0.001006s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102582-1' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.002580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33618643 LIMIT 4 [ RunTime:0.004142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33618643 ORDER BY `minOrder` ASC [ RunTime:0.020282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33618643 ORDER BY `unit` DESC [ RunTime:0.000551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33618643 LIMIT 2 [ RunTime:0.000475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33618643 ORDER BY `minOrder` ASC [ RunTime:0.002096s ]
select * from pdf where partno='2104-5301' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000727s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104-5301' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.007056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33618639 LIMIT 4 [ RunTime:0.004743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33618639 ORDER BY `minOrder` ASC [ RunTime:0.000898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33618639 ORDER BY `unit` DESC [ RunTime:0.000380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33618639 LIMIT 2 [ RunTime:0.000399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33618639 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
select * from pdf where partno='2104-5304' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.002982s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104-5304' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.012407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13794524 LIMIT 4 [ RunTime:0.015464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13794524 ORDER BY `minOrder` ASC [ RunTime:0.006766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13794524 ORDER BY `unit` DESC [ RunTime:0.000637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13794524 LIMIT 2 [ RunTime:0.005834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13794524 ORDER BY `minOrder` ASC [ RunTime:0.000494s ]
select * from pdf where partno='21035991506' and brandshort='HARTING' limit 1 [ RunTime:0.003109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12991127 LIMIT 4 [ RunTime:0.001263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12991127 ORDER BY `minOrder` ASC [ RunTime:0.000584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12991127 ORDER BY `unit` DESC [ RunTime:0.000614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12991127 LIMIT 2 [ RunTime:0.002507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12991127 ORDER BY `minOrder` ASC [ RunTime:0.001881s ]
select * from pdf where partno='21038212512' and brandshort='HARTING' limit 1 [ RunTime:0.006045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11447286 LIMIT 4 [ RunTime:0.002670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11447286 ORDER BY `minOrder` ASC [ RunTime:0.000628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11447286 ORDER BY `unit` DESC [ RunTime:0.000521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11447286 LIMIT 2 [ RunTime:0.000606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11447286 ORDER BY `minOrder` ASC [ RunTime:0.002160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10857101 LIMIT 4 [ RunTime:0.001174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10857101 ORDER BY `minOrder` ASC [ RunTime:0.003210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10857101 ORDER BY `unit` DESC [ RunTime:0.000369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10857101 LIMIT 2 [ RunTime:0.000965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10857101 ORDER BY `minOrder` ASC [ RunTime:0.000278s ]
select * from pdf where partno='21033112810' and brandshort='HARTING' limit 1 [ RunTime:0.003361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10834082 LIMIT 4 [ RunTime:0.001629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10834082 ORDER BY `minOrder` ASC [ RunTime:0.001687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10834082 ORDER BY `unit` DESC [ RunTime:0.002225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10834082 LIMIT 2 [ RunTime:0.002251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10834082 ORDER BY `minOrder` ASC [ RunTime:0.000292s ]
select * from pdf where partno='21021851430' and brandshort='HARTING' limit 1 [ RunTime:0.000711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35489362 LIMIT 4 [ RunTime:0.001527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35489362 ORDER BY `minOrder` ASC [ RunTime:0.005219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35489362 ORDER BY `unit` DESC [ RunTime:0.002022s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35489362 LIMIT 2 [ RunTime:0.001847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35489362 ORDER BY `minOrder` ASC [ RunTime:0.000354s ]
select * from pdf where partno='21033176805' and brandshort='HARTING' limit 1 [ RunTime:0.001223s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033176805' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.000656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35296887 LIMIT 4 [ RunTime:0.000357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35296887 ORDER BY `minOrder` ASC [ RunTime:0.000699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35296887 ORDER BY `unit` DESC [ RunTime:0.002590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35296887 LIMIT 2 [ RunTime:0.012337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35296887 ORDER BY `minOrder` ASC [ RunTime:0.002372s ]
select * from pdf where partno='210612043' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.009205s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210612043' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.001666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34362279 LIMIT 4 [ RunTime:0.016446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34362279 ORDER BY `minOrder` ASC [ RunTime:0.027801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34362279 ORDER BY `unit` DESC [ RunTime:0.033660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34362279 LIMIT 2 [ RunTime:0.004841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34362279 ORDER BY `minOrder` ASC [ RunTime:0.000363s ]
select * from pdf where partno='2101553-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.001083s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101553-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.021453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13794531 LIMIT 4 [ RunTime:0.019630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13794531 ORDER BY `minOrder` ASC [ RunTime:0.027086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13794531 ORDER BY `unit` DESC [ RunTime:0.006734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13794531 LIMIT 2 [ RunTime:0.027591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13794531 ORDER BY `minOrder` ASC [ RunTime:0.015985s ]
select * from pdf where partno='21033111501' and brandshort='HARTING' limit 1 [ RunTime:0.010328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12236778 LIMIT 4 [ RunTime:0.043244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12236778 ORDER BY `minOrder` ASC [ RunTime:0.008237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12236778 ORDER BY `unit` DESC [ RunTime:0.087784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12236778 LIMIT 2 [ RunTime:0.039802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12236778 ORDER BY `minOrder` ASC [ RunTime:0.028076s ]
select * from pdf where partno='21033012007' and brandshort='HARTING' limit 1 [ RunTime:0.044860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12198589 LIMIT 4 [ RunTime:0.065226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12198589 ORDER BY `minOrder` ASC [ RunTime:0.082269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12198589 ORDER BY `unit` DESC [ RunTime:0.042892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12198589 LIMIT 2 [ RunTime:0.103286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12198589 ORDER BY `minOrder` ASC [ RunTime:0.054628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11758247 LIMIT 4 [ RunTime:0.064042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11758247 ORDER BY `minOrder` ASC [ RunTime:0.112214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11758247 ORDER BY `unit` DESC [ RunTime:0.122643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11758247 LIMIT 2 [ RunTime:0.120620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11758247 ORDER BY `minOrder` ASC [ RunTime:0.046681s ]
select * from pdf where partno='21033011000' and brandshort='HARTING' limit 1 [ RunTime:0.109911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11756083 LIMIT 4 [ RunTime:0.190798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11756083 ORDER BY `minOrder` ASC [ RunTime:0.036899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11756083 ORDER BY `unit` DESC [ RunTime:0.159914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11756083 LIMIT 2 [ RunTime:0.097751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11756083 ORDER BY `minOrder` ASC [ RunTime:0.026291s ]
select * from pdf where partno='21038611825' and brandshort='HARTING' limit 1 [ RunTime:0.080668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10902366 LIMIT 4 [ RunTime:0.086562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10902366 ORDER BY `minOrder` ASC [ RunTime:0.100879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10902366 ORDER BY `unit` DESC [ RunTime:0.019147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10902366 LIMIT 2 [ RunTime:0.036967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10902366 ORDER BY `minOrder` ASC [ RunTime:0.022994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34401892 LIMIT 4 [ RunTime:0.023836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34401892 ORDER BY `minOrder` ASC [ RunTime:0.108366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34401892 ORDER BY `unit` DESC [ RunTime:0.024024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34401892 LIMIT 2 [ RunTime:0.061571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34401892 ORDER BY `minOrder` ASC [ RunTime:0.009572s ]
select * from pdf where partno='21033095502' and brandshort='HARTING' limit 1 [ RunTime:0.020103s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033095502' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.021921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34322461 LIMIT 4 [ RunTime:0.040388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322461 ORDER BY `minOrder` ASC [ RunTime:0.023806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34322461 ORDER BY `unit` DESC [ RunTime:0.019029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34322461 LIMIT 2 [ RunTime:0.046381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34322461 ORDER BY `minOrder` ASC [ RunTime:0.017273s ]
select * from pdf where partno='210-93-324-41-001000' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.063077s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-93-324-41-001000' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.011169s ]
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.040946s ]