SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001313s ]
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=309&srecordnum=7527' [ RunTime:0.006785s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001504s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004315s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001883s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.009257s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001775s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005382s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001473s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.013404s ]
UPDATE `stock_search` SET `count` = 4315 , `updatetime` = '2026-06-08 17:24:33' WHERE `partno` = '210' [ RunTime:0.020384s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.009112s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.003416s ]
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.006673s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001681s ]
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.001838s ]
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 6160,20 [ RunTime:0.078169s ]
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 ('14395403','14395402','14395401','14385254','14382665','14382664','14382159','14382158','14382000','14381999','14381998','14381997','14381828','14381513','14380891','14380890','14376672','14375951','14362744','14362681') ORDER BY FIELD(s.id, 14395403,14395402,14395401,14385254,14382665,14382664,14382159,14382158,14382000,14381999,14381998,14381997,14381828,14381513,14380891,14380890,14376672,14375951,14362744,14362681) [ RunTime:0.049644s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.012345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395403 LIMIT 4 [ RunTime:0.018556s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395403 ORDER BY `minOrder` ASC [ RunTime:0.038773s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.009661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395403 ORDER BY `unit` DESC [ RunTime:0.019372s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395403 LIMIT 2 [ RunTime:0.004892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395403 ORDER BY `minOrder` ASC [ RunTime:0.007546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395402 LIMIT 4 [ RunTime:0.007445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395402 ORDER BY `minOrder` ASC [ RunTime:0.000775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395402 ORDER BY `unit` DESC [ RunTime:0.002816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395402 LIMIT 2 [ RunTime:0.006905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395402 ORDER BY `minOrder` ASC [ RunTime:0.005140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395401 LIMIT 4 [ RunTime:0.001014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395401 ORDER BY `minOrder` ASC [ RunTime:0.007556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395401 ORDER BY `unit` DESC [ RunTime:0.003392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395401 LIMIT 2 [ RunTime:0.007583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395401 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14385254 LIMIT 4 [ RunTime:0.001177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14385254 ORDER BY `minOrder` ASC [ RunTime:0.000829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14385254 ORDER BY `unit` DESC [ RunTime:0.009447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14385254 LIMIT 2 [ RunTime:0.000659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14385254 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
select * from pdf where partno='2101A 0065000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14382665 LIMIT 4 [ RunTime:0.006628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14382665 ORDER BY `minOrder` ASC [ RunTime:0.001582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14382665 ORDER BY `unit` DESC [ RunTime:0.008931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14382665 LIMIT 2 [ RunTime:0.001618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14382665 ORDER BY `minOrder` ASC [ RunTime:0.000810s ]
select * from pdf where partno='2108A 0061000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14382664 LIMIT 4 [ RunTime:0.001479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14382664 ORDER BY `minOrder` ASC [ RunTime:0.001999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14382664 ORDER BY `unit` DESC [ RunTime:0.012757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14382664 LIMIT 2 [ RunTime:0.014999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14382664 ORDER BY `minOrder` ASC [ RunTime:0.004947s ]
select * from pdf where partno='2108A 0031000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.002583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14382159 LIMIT 4 [ RunTime:0.006890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14382159 ORDER BY `minOrder` ASC [ RunTime:0.014337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14382159 ORDER BY `unit` DESC [ RunTime:0.006866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14382159 LIMIT 2 [ RunTime:0.000853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14382159 ORDER BY `minOrder` ASC [ RunTime:0.008020s ]
select * from pdf where partno='2107A 0061000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14382158 LIMIT 4 [ RunTime:0.000931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14382158 ORDER BY `minOrder` ASC [ RunTime:0.018965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14382158 ORDER BY `unit` DESC [ RunTime:0.012357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14382158 LIMIT 2 [ RunTime:0.002177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14382158 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
select * from pdf where partno='2107A 0031000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.003820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14382000 LIMIT 4 [ RunTime:0.001076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14382000 ORDER BY `minOrder` ASC [ RunTime:0.001362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14382000 ORDER BY `unit` DESC [ RunTime:0.004416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14382000 LIMIT 2 [ RunTime:0.007031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14382000 ORDER BY `minOrder` ASC [ RunTime:0.000620s ]
select * from pdf where partno='2106A 0065000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14381999 LIMIT 4 [ RunTime:0.000856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14381999 ORDER BY `minOrder` ASC [ RunTime:0.000705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14381999 ORDER BY `unit` DESC [ RunTime:0.003487s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14381999 LIMIT 2 [ RunTime:0.004567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14381999 ORDER BY `minOrder` ASC [ RunTime:0.002768s ]
select * from pdf where partno='2106A 0035000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14381998 LIMIT 4 [ RunTime:0.007791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14381998 ORDER BY `minOrder` ASC [ RunTime:0.001960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14381998 ORDER BY `unit` DESC [ RunTime:0.000731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14381998 LIMIT 2 [ RunTime:0.004225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14381998 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
select * from pdf where partno='2106A 0061000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.001307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14381997 LIMIT 4 [ RunTime:0.000682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14381997 ORDER BY `minOrder` ASC [ RunTime:0.003521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14381997 ORDER BY `unit` DESC [ RunTime:0.003208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14381997 LIMIT 2 [ RunTime:0.001433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14381997 ORDER BY `minOrder` ASC [ RunTime:0.000624s ]
select * from pdf where partno='2106A 0031000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14381828 LIMIT 4 [ RunTime:0.002942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14381828 ORDER BY `minOrder` ASC [ RunTime:0.002781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14381828 ORDER BY `unit` DESC [ RunTime:0.007159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14381828 LIMIT 2 [ RunTime:0.001105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14381828 ORDER BY `minOrder` ASC [ RunTime:0.003573s ]
select * from pdf where partno='2105A 0065000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.001132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14381513 LIMIT 4 [ RunTime:0.002603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14381513 ORDER BY `minOrder` ASC [ RunTime:0.002304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14381513 ORDER BY `unit` DESC [ RunTime:0.007622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14381513 LIMIT 2 [ RunTime:0.007798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14381513 ORDER BY `minOrder` ASC [ RunTime:0.003818s ]
select * from pdf where partno='2104A 0065000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.004544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14380891 LIMIT 4 [ RunTime:0.002527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14380891 ORDER BY `minOrder` ASC [ RunTime:0.000555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14380891 ORDER BY `unit` DESC [ RunTime:0.004809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14380891 LIMIT 2 [ RunTime:0.008167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14380891 ORDER BY `minOrder` ASC [ RunTime:0.001310s ]
select * from pdf where partno='2103A 0065000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.001809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14380890 LIMIT 4 [ RunTime:0.000633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14380890 ORDER BY `minOrder` ASC [ RunTime:0.000487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14380890 ORDER BY `unit` DESC [ RunTime:0.002233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14380890 LIMIT 2 [ RunTime:0.001674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14380890 ORDER BY `minOrder` ASC [ RunTime:0.000263s ]
select * from pdf where partno='2103A 0035000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.002251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14376672 LIMIT 4 [ RunTime:0.002612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14376672 ORDER BY `minOrder` ASC [ RunTime:0.011003s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14376672 ORDER BY `unit` DESC [ RunTime:0.007673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14376672 LIMIT 2 [ RunTime:0.005521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14376672 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
select * from pdf where partno='2109A 0061000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.002255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14375951 LIMIT 4 [ RunTime:0.000902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14375951 ORDER BY `minOrder` ASC [ RunTime:0.000479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14375951 ORDER BY `unit` DESC [ RunTime:0.003568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14375951 LIMIT 2 [ RunTime:0.004015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14375951 ORDER BY `minOrder` ASC [ RunTime:0.001693s ]
select * from pdf where partno='2100A 0065000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.003327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14362744 LIMIT 4 [ RunTime:0.002326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14362744 ORDER BY `minOrder` ASC [ RunTime:0.000528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14362744 ORDER BY `unit` DESC [ RunTime:0.002359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14362744 LIMIT 2 [ RunTime:0.003889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14362744 ORDER BY `minOrder` ASC [ RunTime:0.000281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14362681 LIMIT 4 [ RunTime:0.000792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14362681 ORDER BY `minOrder` ASC [ RunTime:0.002699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14362681 ORDER BY `unit` DESC [ RunTime:0.000537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14362681 LIMIT 2 [ RunTime:0.009460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14362681 ORDER BY `minOrder` ASC [ RunTime:0.000314s ]
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.000367s ]