SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001519s ]
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.034520s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002053s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.014262s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002325s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.008108s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002151s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.020740s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002018s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.016102s ]
UPDATE `stock_search` SET `count` = 2813 , `updatetime` = '2026-06-08 08:15:18' WHERE `partno` = '210' [ RunTime:0.073190s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.036358s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.041945s ]
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.042262s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002649s ]
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.029190s ]
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 1740,20 [ RunTime:0.166374s ]
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 ('33303439','19509576','19509565','14257811','13786469','12183192','11692461','11689537','10750939','36760909','36760706','36589827','36337311','36336924','34402313','34402085','34401887','34401856','33615671','33432205') ORDER BY FIELD(s.id, 33303439,19509576,19509565,14257811,13786469,12183192,11692461,11689537,10750939,36760909,36760706,36589827,36337311,36336924,34402313,34402085,34401887,34401856,33615671,33432205) [ RunTime:0.095713s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.039616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33303439 LIMIT 4 [ RunTime:0.063240s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.028774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33303439 ORDER BY `minOrder` ASC [ RunTime:0.114281s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33303439 ORDER BY `unit` DESC [ RunTime:0.051155s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33303439 LIMIT 2 [ RunTime:0.104381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33303439 ORDER BY `minOrder` ASC [ RunTime:0.079241s ]
select * from pdf where partno='210-103' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.061110s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003443s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-103' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.123442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19509576 LIMIT 4 [ RunTime:0.183826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19509576 ORDER BY `minOrder` ASC [ RunTime:0.076481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19509576 ORDER BY `unit` DESC [ RunTime:0.128723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19509576 LIMIT 2 [ RunTime:0.114041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19509576 ORDER BY `minOrder` ASC [ RunTime:0.022537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19509565 LIMIT 4 [ RunTime:0.030570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19509565 ORDER BY `minOrder` ASC [ RunTime:0.064621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19509565 ORDER BY `unit` DESC [ RunTime:0.089091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19509565 LIMIT 2 [ RunTime:0.083772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19509565 ORDER BY `minOrder` ASC [ RunTime:0.038703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14257811 LIMIT 4 [ RunTime:0.041110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14257811 ORDER BY `minOrder` ASC [ RunTime:0.171628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14257811 ORDER BY `unit` DESC [ RunTime:0.118621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14257811 LIMIT 2 [ RunTime:0.113743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14257811 ORDER BY `minOrder` ASC [ RunTime:0.072843s ]
select * from pdf where partno='2101' and brandshort='Kitronik Ltd.' limit 1 [ RunTime:0.132840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13786469 LIMIT 4 [ RunTime:0.090477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13786469 ORDER BY `minOrder` ASC [ RunTime:0.098680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13786469 ORDER BY `unit` DESC [ RunTime:0.101098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13786469 LIMIT 2 [ RunTime:0.074219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13786469 ORDER BY `minOrder` ASC [ RunTime:0.000565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12183192 LIMIT 4 [ RunTime:0.023740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12183192 ORDER BY `minOrder` ASC [ RunTime:0.070873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12183192 ORDER BY `unit` DESC [ RunTime:0.042798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12183192 LIMIT 2 [ RunTime:0.165037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12183192 ORDER BY `minOrder` ASC [ RunTime:0.061043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11692461 LIMIT 4 [ RunTime:0.126537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11692461 ORDER BY `minOrder` ASC [ RunTime:0.040925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11692461 ORDER BY `unit` DESC [ RunTime:0.172551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11692461 LIMIT 2 [ RunTime:0.072145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11692461 ORDER BY `minOrder` ASC [ RunTime:0.039317s ]
select * from pdf where partno='21038211825' and brandshort='HARTING' limit 1 [ RunTime:0.029657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11689537 LIMIT 4 [ RunTime:0.094701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11689537 ORDER BY `minOrder` ASC [ RunTime:0.095611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11689537 ORDER BY `unit` DESC [ RunTime:0.042935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11689537 LIMIT 2 [ RunTime:0.043987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11689537 ORDER BY `minOrder` ASC [ RunTime:0.074476s ]
select * from pdf where partno='21010000036' and brandshort='HARTING' limit 1 [ RunTime:0.069567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10750939 LIMIT 4 [ RunTime:0.053131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10750939 ORDER BY `minOrder` ASC [ RunTime:0.093988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10750939 ORDER BY `unit` DESC [ RunTime:0.198509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10750939 LIMIT 2 [ RunTime:0.140764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10750939 ORDER BY `minOrder` ASC [ RunTime:0.080878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36760909 LIMIT 4 [ RunTime:0.228106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760909 ORDER BY `minOrder` ASC [ RunTime:0.073335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36760909 ORDER BY `unit` DESC [ RunTime:0.190989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36760909 LIMIT 2 [ RunTime:0.070626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760909 ORDER BY `minOrder` ASC [ RunTime:0.126025s ]
select * from pdf where partno='210-504' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.035805s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-504' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.071753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36760706 LIMIT 4 [ RunTime:0.051008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760706 ORDER BY `minOrder` ASC [ RunTime:0.043487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36760706 ORDER BY `unit` DESC [ RunTime:0.143785s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36760706 LIMIT 2 [ RunTime:0.159640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760706 ORDER BY `minOrder` ASC [ RunTime:0.056307s ]
select * from pdf where partno='210-113' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.084838s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-113' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.027577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36589827 LIMIT 4 [ RunTime:0.070218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36589827 ORDER BY `minOrder` ASC [ RunTime:0.121140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36589827 ORDER BY `unit` DESC [ RunTime:0.122591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36589827 LIMIT 2 [ RunTime:0.043777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36589827 ORDER BY `minOrder` ASC [ RunTime:0.116364s ]
select * from pdf where partno='2103185' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.089361s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103185' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.137942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36337311 LIMIT 4 [ RunTime:0.143454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36337311 ORDER BY `minOrder` ASC [ RunTime:0.083074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36337311 ORDER BY `unit` DESC [ RunTime:0.040822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36337311 LIMIT 2 [ RunTime:0.046660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36337311 ORDER BY `minOrder` ASC [ RunTime:0.055358s ]
select * from pdf where partno='2106163' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.018430s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106163' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.043147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36336924 LIMIT 4 [ RunTime:0.054774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36336924 ORDER BY `minOrder` ASC [ RunTime:0.050349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36336924 ORDER BY `unit` DESC [ RunTime:0.024981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36336924 LIMIT 2 [ RunTime:0.017270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36336924 ORDER BY `minOrder` ASC [ RunTime:0.005579s ]
select * from pdf where partno='2106182' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.024965s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106182' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.032903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34402313 LIMIT 4 [ RunTime:0.021277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34402313 ORDER BY `minOrder` ASC [ RunTime:0.008925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34402313 ORDER BY `unit` DESC [ RunTime:0.038496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34402313 LIMIT 2 [ RunTime:0.028030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34402313 ORDER BY `minOrder` ASC [ RunTime:0.013582s ]
select * from pdf where partno='21033216510' and brandshort='HARTING' limit 1 [ RunTime:0.032514s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033216510' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.030815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34402085 LIMIT 4 [ RunTime:0.030550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34402085 ORDER BY `minOrder` ASC [ RunTime:0.068982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34402085 ORDER BY `unit` DESC [ RunTime:0.014971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34402085 LIMIT 2 [ RunTime:0.040271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34402085 ORDER BY `minOrder` ASC [ RunTime:0.000563s ]
select * from pdf where partno='21033216420' and brandshort='HARTING' limit 1 [ RunTime:0.015594s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033216420' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.060661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34401887 LIMIT 4 [ RunTime:0.083103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34401887 ORDER BY `minOrder` ASC [ RunTime:0.035882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34401887 ORDER BY `unit` DESC [ RunTime:0.031365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34401887 LIMIT 2 [ RunTime:0.051871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34401887 ORDER BY `minOrder` ASC [ RunTime:0.026474s ]
select * from pdf where partno='21033991401' and brandshort='HARTING' limit 1 [ RunTime:0.007541s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033991401' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.009769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34401856 LIMIT 4 [ RunTime:0.027472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34401856 ORDER BY `minOrder` ASC [ RunTime:0.012531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34401856 ORDER BY `unit` DESC [ RunTime:0.026567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34401856 LIMIT 2 [ RunTime:0.008324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34401856 ORDER BY `minOrder` ASC [ RunTime:0.010634s ]
select * from pdf where partno='21033962532' and brandshort='HARTING' limit 1 [ RunTime:0.028301s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033962532' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.030456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33615671 LIMIT 4 [ RunTime:0.011595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33615671 ORDER BY `minOrder` ASC [ RunTime:0.055081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33615671 ORDER BY `unit` DESC [ RunTime:0.026453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33615671 LIMIT 2 [ RunTime:0.010192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33615671 ORDER BY `minOrder` ASC [ RunTime:0.008196s ]
select * from pdf where partno='2106-5304' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.011676s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106-5304' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.011373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33432205 LIMIT 4 [ RunTime:0.022707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33432205 ORDER BY `minOrder` ASC [ RunTime:0.029948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33432205 ORDER BY `unit` DESC [ RunTime:0.022020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33432205 LIMIT 2 [ RunTime:0.009611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33432205 ORDER BY `minOrder` ASC [ RunTime:0.015104s ]
select * from pdf where partno='21011009984' and brandshort='HARTING' limit 1 [ RunTime:0.004506s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21011009984' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.003116s ]
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.002005s ]