SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002426s ]
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.005066s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003883s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.014063s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002593s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.002955s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002399s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.008934s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002426s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.003250s ]
UPDATE `stock_search` SET `count` = 4171 , `updatetime` = '2026-06-08 16:51:52' WHERE `partno` = '210' [ RunTime:0.005207s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000483s ]
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.000965s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001251s ]
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.002772s ]
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 1540,20 [ RunTime:0.076071s ]
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 ('35490471','34401367','33453696','33303264','33129755','32277859','32277858','32163357','32163356','14682100','14317451','13187312','12613753','10901019','10900452','10832442','36760627','34404263','34403055','34399140') ORDER BY FIELD(s.id, 35490471,34401367,33453696,33303264,33129755,32277859,32277858,32163357,32163356,14682100,14317451,13187312,12613753,10901019,10900452,10832442,36760627,34404263,34403055,34399140) [ RunTime:0.011351s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35490471 LIMIT 4 [ RunTime:0.005610s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35490471 ORDER BY `minOrder` ASC [ RunTime:0.032644s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35490471 ORDER BY `unit` DESC [ RunTime:0.015814s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35490471 LIMIT 2 [ RunTime:0.012579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35490471 ORDER BY `minOrder` ASC [ RunTime:0.003583s ]
select * from pdf where partno='21033391301' and brandshort='HARTING' limit 1 [ RunTime:0.008139s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001868s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033391301' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.026628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34401367 LIMIT 4 [ RunTime:0.003934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34401367 ORDER BY `minOrder` ASC [ RunTime:0.006770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34401367 ORDER BY `unit` DESC [ RunTime:0.014577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34401367 LIMIT 2 [ RunTime:0.007511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34401367 ORDER BY `minOrder` ASC [ RunTime:0.002711s ]
select * from pdf where partno='21033962506' and brandshort='HARTING' limit 1 [ RunTime:0.015230s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033962506' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.039293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33453696 LIMIT 4 [ RunTime:0.026143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33453696 ORDER BY `minOrder` ASC [ RunTime:0.033895s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33453696 ORDER BY `unit` DESC [ RunTime:0.060932s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33453696 LIMIT 2 [ RunTime:0.042983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33453696 ORDER BY `minOrder` ASC [ RunTime:0.009742s ]
select * from pdf where partno='21011009933' and brandshort='HARTING' limit 1 [ RunTime:0.038908s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21011009933' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.030243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33303264 LIMIT 4 [ RunTime:0.050671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33303264 ORDER BY `minOrder` ASC [ RunTime:0.169481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33303264 ORDER BY `unit` DESC [ RunTime:0.162545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33303264 LIMIT 2 [ RunTime:0.036853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33303264 ORDER BY `minOrder` ASC [ RunTime:0.050702s ]
select * from pdf where partno='210-254' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.020050s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-254' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33129755 LIMIT 4 [ RunTime:0.080758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33129755 ORDER BY `minOrder` ASC [ RunTime:0.098693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33129755 ORDER BY `unit` DESC [ RunTime:0.013025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33129755 LIMIT 2 [ RunTime:0.002226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33129755 ORDER BY `minOrder` ASC [ RunTime:0.008026s ]
select * from pdf where partno='210-490' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.015909s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-490' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.008522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277859 LIMIT 4 [ RunTime:0.041520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277859 ORDER BY `minOrder` ASC [ RunTime:0.064317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277859 ORDER BY `unit` DESC [ RunTime:0.010012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277859 LIMIT 2 [ RunTime:0.011263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277859 ORDER BY `minOrder` ASC [ RunTime:0.005303s ]
select * from pdf where partno='2106431-4' and brandshort='te connectivity / raychem' limit 1 [ RunTime:0.002637s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106431-4' OR `brand` LIKE 'te connectivity / raychem%' ) ) LIMIT 1 [ RunTime:0.011330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277858 LIMIT 4 [ RunTime:0.000458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277858 ORDER BY `minOrder` ASC [ RunTime:0.001721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277858 ORDER BY `unit` DESC [ RunTime:0.008571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277858 LIMIT 2 [ RunTime:0.008714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277858 ORDER BY `minOrder` ASC [ RunTime:0.006349s ]
select * from pdf where partno='2106112-2' and brandshort='te connectivity' limit 1 [ RunTime:0.008688s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106112-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.006868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32163357 LIMIT 4 [ RunTime:0.039253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163357 ORDER BY `minOrder` ASC [ RunTime:0.008513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32163357 ORDER BY `unit` DESC [ RunTime:0.007450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32163357 LIMIT 2 [ RunTime:0.000265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163357 ORDER BY `minOrder` ASC [ RunTime:0.004382s ]
select * from pdf where partno='2106431-4' and brandshort='te connectivity / raychem' limit 1 [ RunTime:0.000638s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106431-4' OR `brand` LIKE 'te connectivity / raychem%' ) ) LIMIT 1 [ RunTime:0.001069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32163356 LIMIT 4 [ RunTime:0.000238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163356 ORDER BY `minOrder` ASC [ RunTime:0.005811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32163356 ORDER BY `unit` DESC [ RunTime:0.028314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32163356 LIMIT 2 [ RunTime:0.014822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163356 ORDER BY `minOrder` ASC [ RunTime:0.000530s ]
select * from pdf where partno='2106112-2' and brandshort='te connectivity' limit 1 [ RunTime:0.013491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106112-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.026001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14682100 LIMIT 4 [ RunTime:0.031496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14682100 ORDER BY `minOrder` ASC [ RunTime:0.030611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14682100 ORDER BY `unit` DESC [ RunTime:0.041458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14682100 LIMIT 2 [ RunTime:0.024534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14682100 ORDER BY `minOrder` ASC [ RunTime:0.002903s ]
select * from pdf where partno='21033391301' and brandshort='HARTING' limit 1 [ RunTime:0.000564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14317451 LIMIT 4 [ RunTime:0.000433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14317451 ORDER BY `minOrder` ASC [ RunTime:0.013174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14317451 ORDER BY `unit` DESC [ RunTime:0.038445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14317451 LIMIT 2 [ RunTime:0.007858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14317451 ORDER BY `minOrder` ASC [ RunTime:0.029429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187312 LIMIT 4 [ RunTime:0.033127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187312 ORDER BY `minOrder` ASC [ RunTime:0.016979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187312 ORDER BY `unit` DESC [ RunTime:0.011887s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187312 LIMIT 2 [ RunTime:0.025169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187312 ORDER BY `minOrder` ASC [ RunTime:0.014011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12613753 LIMIT 4 [ RunTime:0.016170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613753 ORDER BY `minOrder` ASC [ RunTime:0.033492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12613753 ORDER BY `unit` DESC [ RunTime:0.028703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12613753 LIMIT 2 [ RunTime:0.003300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613753 ORDER BY `minOrder` ASC [ RunTime:0.009809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10901019 LIMIT 4 [ RunTime:0.003470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10901019 ORDER BY `minOrder` ASC [ RunTime:0.001330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10901019 ORDER BY `unit` DESC [ RunTime:0.009543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10901019 LIMIT 2 [ RunTime:0.017090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10901019 ORDER BY `minOrder` ASC [ RunTime:0.004683s ]
select * from pdf where partno='21033962402' and brandshort='HARTING' limit 1 [ RunTime:0.010629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10900452 LIMIT 4 [ RunTime:0.007982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10900452 ORDER BY `minOrder` ASC [ RunTime:0.015013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10900452 ORDER BY `unit` DESC [ RunTime:0.016849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10900452 LIMIT 2 [ RunTime:0.002037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10900452 ORDER BY `minOrder` ASC [ RunTime:0.003362s ]
select * from pdf where partno='21033962505' and brandshort='HARTING' limit 1 [ RunTime:0.003126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10832442 LIMIT 4 [ RunTime:0.003218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10832442 ORDER BY `minOrder` ASC [ RunTime:0.023708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10832442 ORDER BY `unit` DESC [ RunTime:0.002114s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10832442 LIMIT 2 [ RunTime:0.005521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10832442 ORDER BY `minOrder` ASC [ RunTime:0.012561s ]
select * from pdf where partno='21033962506' and brandshort='HARTING' limit 1 [ RunTime:0.002767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36760627 LIMIT 4 [ RunTime:0.002301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760627 ORDER BY `minOrder` ASC [ RunTime:0.021643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36760627 ORDER BY `unit` DESC [ RunTime:0.011924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36760627 LIMIT 2 [ RunTime:0.006053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760627 ORDER BY `minOrder` ASC [ RunTime:0.004933s ]
select * from pdf where partno='210-112' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000380s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-112' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.016915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34404263 LIMIT 4 [ RunTime:0.037389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34404263 ORDER BY `minOrder` ASC [ RunTime:0.006791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34404263 ORDER BY `unit` DESC [ RunTime:0.024905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34404263 LIMIT 2 [ RunTime:0.005258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34404263 ORDER BY `minOrder` ASC [ RunTime:0.009619s ]
select * from pdf where partno='21031112305' and brandshort='HARTING' limit 1 [ RunTime:0.001202s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21031112305' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.001165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34403055 LIMIT 4 [ RunTime:0.008039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34403055 ORDER BY `minOrder` ASC [ RunTime:0.012940s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34403055 ORDER BY `unit` DESC [ RunTime:0.002868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34403055 LIMIT 2 [ RunTime:0.005164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34403055 ORDER BY `minOrder` ASC [ RunTime:0.003587s ]
select * from pdf where partno='2101549-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.000379s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101549-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.000448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34399140 LIMIT 4 [ RunTime:0.000614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34399140 ORDER BY `minOrder` ASC [ RunTime:0.009799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34399140 ORDER BY `unit` DESC [ RunTime:0.002082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34399140 LIMIT 2 [ RunTime:0.001585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34399140 ORDER BY `minOrder` ASC [ RunTime:0.001994s ]
select * from pdf where partno='21033192401' and brandshort='HARTING' limit 1 [ RunTime:0.001152s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033192401' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.002475s ]
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.005847s ]