SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001670s ]
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=7530' [ RunTime:0.173126s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.004375s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.011078s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003313s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.025320s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003148s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.010691s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002025s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.039274s ]
UPDATE `stock_search` SET `count` = 5867 , `updatetime` = '2026-06-09 01:04:07' WHERE `partno` = '210' [ RunTime:0.027534s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.036234s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.020785s ]
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.011222s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001983s ]
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.474937s ]
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.204849s ]
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 ('14508493','14435460','14412559','14412558','14412557','14412556','14395412','14395411','14395410','14395409','14395408','14395407','14395405','14395404','14395403','14395402','14395401','14385254','14382665','14382664') ORDER BY FIELD(s.id, 14508493,14435460,14412559,14412558,14412557,14412556,14395412,14395411,14395410,14395409,14395408,14395407,14395405,14395404,14395403,14395402,14395401,14385254,14382665,14382664) [ RunTime:0.011714s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14508493 LIMIT 4 [ RunTime:0.022591s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14508493 ORDER BY `minOrder` ASC [ RunTime:0.009557s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14508493 ORDER BY `unit` DESC [ RunTime:0.022232s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14508493 LIMIT 2 [ RunTime:0.015390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14508493 ORDER BY `minOrder` ASC [ RunTime:0.009465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14435460 LIMIT 4 [ RunTime:0.013098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14435460 ORDER BY `minOrder` ASC [ RunTime:0.029861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14435460 ORDER BY `unit` DESC [ RunTime:0.041620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14435460 LIMIT 2 [ RunTime:0.007743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14435460 ORDER BY `minOrder` ASC [ RunTime:0.051110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14412559 LIMIT 4 [ RunTime:0.016699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14412559 ORDER BY `minOrder` ASC [ RunTime:0.016174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14412559 ORDER BY `unit` DESC [ RunTime:0.014797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14412559 LIMIT 2 [ RunTime:0.029602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14412559 ORDER BY `minOrder` ASC [ RunTime:0.033078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14412558 LIMIT 4 [ RunTime:0.025628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14412558 ORDER BY `minOrder` ASC [ RunTime:0.007386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14412558 ORDER BY `unit` DESC [ RunTime:0.027371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14412558 LIMIT 2 [ RunTime:0.007479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14412558 ORDER BY `minOrder` ASC [ RunTime:0.019773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14412557 LIMIT 4 [ RunTime:0.005949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14412557 ORDER BY `minOrder` ASC [ RunTime:0.007484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14412557 ORDER BY `unit` DESC [ RunTime:0.002278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14412557 LIMIT 2 [ RunTime:0.010612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14412557 ORDER BY `minOrder` ASC [ RunTime:0.008921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14412556 LIMIT 4 [ RunTime:0.010358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14412556 ORDER BY `minOrder` ASC [ RunTime:0.012896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14412556 ORDER BY `unit` DESC [ RunTime:0.006884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14412556 LIMIT 2 [ RunTime:0.021440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14412556 ORDER BY `minOrder` ASC [ RunTime:0.019599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395412 LIMIT 4 [ RunTime:0.009521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395412 ORDER BY `minOrder` ASC [ RunTime:0.004309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395412 ORDER BY `unit` DESC [ RunTime:0.012999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395412 LIMIT 2 [ RunTime:0.007270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395412 ORDER BY `minOrder` ASC [ RunTime:0.022979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395411 LIMIT 4 [ RunTime:0.006567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395411 ORDER BY `minOrder` ASC [ RunTime:0.024989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395411 ORDER BY `unit` DESC [ RunTime:0.044151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395411 LIMIT 2 [ RunTime:0.120782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395411 ORDER BY `minOrder` ASC [ RunTime:0.019204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395410 LIMIT 4 [ RunTime:0.031292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395410 ORDER BY `minOrder` ASC [ RunTime:0.067778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395410 ORDER BY `unit` DESC [ RunTime:0.014375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395410 LIMIT 2 [ RunTime:0.005288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395410 ORDER BY `minOrder` ASC [ RunTime:0.011714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395409 LIMIT 4 [ RunTime:0.013559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395409 ORDER BY `minOrder` ASC [ RunTime:0.002430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395409 ORDER BY `unit` DESC [ RunTime:0.002571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395409 LIMIT 2 [ RunTime:0.004532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395409 ORDER BY `minOrder` ASC [ RunTime:0.004719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395408 LIMIT 4 [ RunTime:0.016711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395408 ORDER BY `minOrder` ASC [ RunTime:0.002790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395408 ORDER BY `unit` DESC [ RunTime:0.010685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395408 LIMIT 2 [ RunTime:0.008051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395408 ORDER BY `minOrder` ASC [ RunTime:0.007967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395407 LIMIT 4 [ RunTime:0.017075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395407 ORDER BY `minOrder` ASC [ RunTime:0.016942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395407 ORDER BY `unit` DESC [ RunTime:0.046374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395407 LIMIT 2 [ RunTime:0.036847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395407 ORDER BY `minOrder` ASC [ RunTime:0.022032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395405 LIMIT 4 [ RunTime:0.010971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395405 ORDER BY `minOrder` ASC [ RunTime:0.010821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395405 ORDER BY `unit` DESC [ RunTime:0.009140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395405 LIMIT 2 [ RunTime:0.019622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395405 ORDER BY `minOrder` ASC [ RunTime:0.012392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395404 LIMIT 4 [ RunTime:0.002969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395404 ORDER BY `minOrder` ASC [ RunTime:0.005140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395404 ORDER BY `unit` DESC [ RunTime:0.014120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395404 LIMIT 2 [ RunTime:0.011051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395404 ORDER BY `minOrder` ASC [ RunTime:0.002179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395403 LIMIT 4 [ RunTime:0.009897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395403 ORDER BY `minOrder` ASC [ RunTime:0.015636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395403 ORDER BY `unit` DESC [ RunTime:0.004511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395403 LIMIT 2 [ RunTime:0.009365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395403 ORDER BY `minOrder` ASC [ RunTime:0.001991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395402 LIMIT 4 [ RunTime:0.003771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395402 ORDER BY `minOrder` ASC [ RunTime:0.005208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395402 ORDER BY `unit` DESC [ RunTime:0.015229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395402 LIMIT 2 [ RunTime:0.014390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395402 ORDER BY `minOrder` ASC [ RunTime:0.015330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395401 LIMIT 4 [ RunTime:0.017177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395401 ORDER BY `minOrder` ASC [ RunTime:0.013605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395401 ORDER BY `unit` DESC [ RunTime:0.007272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395401 LIMIT 2 [ RunTime:0.007970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395401 ORDER BY `minOrder` ASC [ RunTime:0.002216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14385254 LIMIT 4 [ RunTime:0.020151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14385254 ORDER BY `minOrder` ASC [ RunTime:0.008785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14385254 ORDER BY `unit` DESC [ RunTime:0.010155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14385254 LIMIT 2 [ RunTime:0.011921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14385254 ORDER BY `minOrder` ASC [ RunTime:0.019039s ]
select * from pdf where partno='2101A 0065000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.008173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14382665 LIMIT 4 [ RunTime:0.048636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14382665 ORDER BY `minOrder` ASC [ RunTime:0.005313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14382665 ORDER BY `unit` DESC [ RunTime:0.015144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14382665 LIMIT 2 [ RunTime:0.032575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14382665 ORDER BY `minOrder` ASC [ RunTime:0.016690s ]
select * from pdf where partno='2108A 0061000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.030878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14382664 LIMIT 4 [ RunTime:0.040357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14382664 ORDER BY `minOrder` ASC [ RunTime:0.040499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14382664 ORDER BY `unit` DESC [ RunTime:0.006888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14382664 LIMIT 2 [ RunTime:0.005674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14382664 ORDER BY `minOrder` ASC [ RunTime:0.020500s ]
select * from pdf where partno='2108A 0031000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.023181s ]
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.088199s ]