SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001369s ]
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` = '' , `host` = 'https://ic118.com/stock&keyword=210&page=89&srecordnum=7530' [ RunTime:0.002735s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001376s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000536s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001805s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.000287s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001240s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002171s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002679s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000746s ]
UPDATE `stock_search` SET `count` = 4571 , `updatetime` = '2026-06-08 19:01:10' WHERE `partno` = '210' [ RunTime:0.000647s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000232s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000198s ]
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.000349s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001360s ]
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.362929s ]
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 1760,20 [ RunTime:0.125043s ]
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 ('11692461','11689537','10750939','36760909','36760706','36589827','36337311','36336924','34402313','34402085','34401887','34401856','33615671','33432205','18588231','14680785','14674556','13799596','13478611','12960206') ORDER BY FIELD(s.id, 11692461,11689537,10750939,36760909,36760706,36589827,36337311,36336924,34402313,34402085,34401887,34401856,33615671,33432205,18588231,14680785,14674556,13799596,13478611,12960206) [ RunTime:0.057343s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.033770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11692461 LIMIT 4 [ RunTime:0.023362s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.014769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11692461 ORDER BY `minOrder` ASC [ RunTime:0.020200s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.009904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11692461 ORDER BY `unit` DESC [ RunTime:0.011222s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11692461 LIMIT 2 [ RunTime:0.035315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11692461 ORDER BY `minOrder` ASC [ RunTime:0.026980s ]
select * from pdf where partno='21038211825' and brandshort='HARTING' limit 1 [ RunTime:0.012598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11689537 LIMIT 4 [ RunTime:0.028354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11689537 ORDER BY `minOrder` ASC [ RunTime:0.013618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11689537 ORDER BY `unit` DESC [ RunTime:0.030836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11689537 LIMIT 2 [ RunTime:0.026486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11689537 ORDER BY `minOrder` ASC [ RunTime:0.011121s ]
select * from pdf where partno='21010000036' and brandshort='HARTING' limit 1 [ RunTime:0.019347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10750939 LIMIT 4 [ RunTime:0.051836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10750939 ORDER BY `minOrder` ASC [ RunTime:0.047588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10750939 ORDER BY `unit` DESC [ RunTime:0.014149s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10750939 LIMIT 2 [ RunTime:0.024019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10750939 ORDER BY `minOrder` ASC [ RunTime:0.031379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36760909 LIMIT 4 [ RunTime:0.005353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760909 ORDER BY `minOrder` ASC [ RunTime:0.046193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36760909 ORDER BY `unit` DESC [ RunTime:0.074527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36760909 LIMIT 2 [ RunTime:0.055585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760909 ORDER BY `minOrder` ASC [ RunTime:0.006625s ]
select * from pdf where partno='210-504' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.017767s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003450s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-504' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.006865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36760706 LIMIT 4 [ RunTime:0.022955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760706 ORDER BY `minOrder` ASC [ RunTime:0.028245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36760706 ORDER BY `unit` DESC [ RunTime:0.021336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36760706 LIMIT 2 [ RunTime:0.022861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760706 ORDER BY `minOrder` ASC [ RunTime:0.008311s ]
select * from pdf where partno='210-113' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.011707s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-113' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.006582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36589827 LIMIT 4 [ RunTime:0.013946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36589827 ORDER BY `minOrder` ASC [ RunTime:0.077378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36589827 ORDER BY `unit` DESC [ RunTime:0.032800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36589827 LIMIT 2 [ RunTime:0.030652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36589827 ORDER BY `minOrder` ASC [ RunTime:0.037379s ]
select * from pdf where partno='2103185' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.014198s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103185' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.033895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36337311 LIMIT 4 [ RunTime:0.028533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36337311 ORDER BY `minOrder` ASC [ RunTime:0.059957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36337311 ORDER BY `unit` DESC [ RunTime:0.014737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36337311 LIMIT 2 [ RunTime:0.060095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36337311 ORDER BY `minOrder` ASC [ RunTime:0.011142s ]
select * from pdf where partno='2106163' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.072107s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106163' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.056410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36336924 LIMIT 4 [ RunTime:0.034307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36336924 ORDER BY `minOrder` ASC [ RunTime:0.141904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36336924 ORDER BY `unit` DESC [ RunTime:0.043635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36336924 LIMIT 2 [ RunTime:0.066725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36336924 ORDER BY `minOrder` ASC [ RunTime:0.088031s ]
select * from pdf where partno='2106182' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.033196s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106182' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.070581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34402313 LIMIT 4 [ RunTime:0.071994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34402313 ORDER BY `minOrder` ASC [ RunTime:0.115776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34402313 ORDER BY `unit` DESC [ RunTime:0.085404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34402313 LIMIT 2 [ RunTime:0.051882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34402313 ORDER BY `minOrder` ASC [ RunTime:0.047402s ]
select * from pdf where partno='21033216510' and brandshort='HARTING' limit 1 [ RunTime:0.020649s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033216510' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.075865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34402085 LIMIT 4 [ RunTime:0.043866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34402085 ORDER BY `minOrder` ASC [ RunTime:0.081294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34402085 ORDER BY `unit` DESC [ RunTime:0.112227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34402085 LIMIT 2 [ RunTime:0.026085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34402085 ORDER BY `minOrder` ASC [ RunTime:0.017780s ]
select * from pdf where partno='21033216420' and brandshort='HARTING' limit 1 [ RunTime:0.079338s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033216420' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.040134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34401887 LIMIT 4 [ RunTime:0.066938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34401887 ORDER BY `minOrder` ASC [ RunTime:0.067750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34401887 ORDER BY `unit` DESC [ RunTime:0.039181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34401887 LIMIT 2 [ RunTime:0.087863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34401887 ORDER BY `minOrder` ASC [ RunTime:0.013872s ]
select * from pdf where partno='21033991401' and brandshort='HARTING' limit 1 [ RunTime:0.025998s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033991401' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.058753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34401856 LIMIT 4 [ RunTime:0.045070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34401856 ORDER BY `minOrder` ASC [ RunTime:0.016517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34401856 ORDER BY `unit` DESC [ RunTime:0.052008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34401856 LIMIT 2 [ RunTime:0.116425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34401856 ORDER BY `minOrder` ASC [ RunTime:0.032357s ]
select * from pdf where partno='21033962532' and brandshort='HARTING' limit 1 [ RunTime:0.016373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033962532' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.066692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33615671 LIMIT 4 [ RunTime:0.029233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33615671 ORDER BY `minOrder` ASC [ RunTime:0.015965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33615671 ORDER BY `unit` DESC [ RunTime:0.035743s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33615671 LIMIT 2 [ RunTime:0.095202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33615671 ORDER BY `minOrder` ASC [ RunTime:0.016621s ]
select * from pdf where partno='2106-5304' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.025709s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106-5304' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.042344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33432205 LIMIT 4 [ RunTime:0.060141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33432205 ORDER BY `minOrder` ASC [ RunTime:0.022577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33432205 ORDER BY `unit` DESC [ RunTime:0.105926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33432205 LIMIT 2 [ RunTime:0.017777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33432205 ORDER BY `minOrder` ASC [ RunTime:0.024948s ]
select * from pdf where partno='21011009984' and brandshort='HARTING' limit 1 [ RunTime:0.018637s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21011009984' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.057610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18588231 LIMIT 4 [ RunTime:0.040278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18588231 ORDER BY `minOrder` ASC [ RunTime:0.057831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18588231 ORDER BY `unit` DESC [ RunTime:0.032227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18588231 LIMIT 2 [ RunTime:0.015480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18588231 ORDER BY `minOrder` ASC [ RunTime:0.007336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14680785 LIMIT 4 [ RunTime:0.051515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14680785 ORDER BY `minOrder` ASC [ RunTime:0.071905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14680785 ORDER BY `unit` DESC [ RunTime:0.060732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14680785 LIMIT 2 [ RunTime:0.077028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14680785 ORDER BY `minOrder` ASC [ RunTime:0.022359s ]
select * from pdf where partno='21033711403' and brandshort='HARTING' limit 1 [ RunTime:0.037199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14674556 LIMIT 4 [ RunTime:0.044619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14674556 ORDER BY `minOrder` ASC [ RunTime:0.068145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14674556 ORDER BY `unit` DESC [ RunTime:0.052919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14674556 LIMIT 2 [ RunTime:0.014523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14674556 ORDER BY `minOrder` ASC [ RunTime:0.027518s ]
select * from pdf where partno='21033752400' and brandshort='HARTING' limit 1 [ RunTime:0.016140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13799596 LIMIT 4 [ RunTime:0.034133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13799596 ORDER BY `minOrder` ASC [ RunTime:0.054939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13799596 ORDER BY `unit` DESC [ RunTime:0.018433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13799596 LIMIT 2 [ RunTime:0.092318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13799596 ORDER BY `minOrder` ASC [ RunTime:0.012125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13478611 LIMIT 4 [ RunTime:0.017858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13478611 ORDER BY `minOrder` ASC [ RunTime:0.075082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13478611 ORDER BY `unit` DESC [ RunTime:0.050925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13478611 LIMIT 2 [ RunTime:0.011141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13478611 ORDER BY `minOrder` ASC [ RunTime:0.007307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12960206 LIMIT 4 [ RunTime:0.028664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12960206 ORDER BY `minOrder` ASC [ RunTime:0.033268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12960206 ORDER BY `unit` DESC [ RunTime:0.072331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12960206 LIMIT 2 [ RunTime:0.003243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12960206 ORDER BY `minOrder` ASC [ RunTime:0.028546s ]
select * from pdf where partno='21038612825' and brandshort='HARTING' limit 1 [ RunTime:0.047246s ]
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.033333s ]