SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.005874s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock&keyword=228&page=496&srecordnum=10000' [ RunTime:0.006411s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002250s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000684s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001207s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.007032s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001118s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001809s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.000953s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.004796s ]
UPDATE `stock_search` SET `count` = 201 , `updatetime` = '2026-06-11 02:03:30' WHERE `partno` = '228' [ RunTime:0.007569s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.002005s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000172s ]
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.000289s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001247s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.350836s ]
SELECT `s`.`id` FROM `stock` `s` WHERE `lockUser` = 0 AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '228%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 9900,20 [ RunTime:0.190419s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `lockUser` = 0 AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('12451398','12451397','12451396','12451395','12451394','12451393','12451392','12451391','12451390','12451389','12451388','12451387','12451386','12451385','12451384','12451383','12451382','12451381','12451380','12451379') ORDER BY FIELD(s.id, 12451398,12451397,12451396,12451395,12451394,12451393,12451392,12451391,12451390,12451389,12451388,12451387,12451386,12451385,12451384,12451383,12451382,12451381,12451380,12451379) [ RunTime:0.033014s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451398 LIMIT 4 [ RunTime:0.027528s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451398 ORDER BY `minOrder` ASC [ RunTime:0.008553s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451398 ORDER BY `unit` DESC [ RunTime:0.023063s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.014652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451398 LIMIT 2 [ RunTime:0.028120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451398 ORDER BY `minOrder` ASC [ RunTime:0.011075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451397 LIMIT 4 [ RunTime:0.013426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451397 ORDER BY `minOrder` ASC [ RunTime:0.021945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451397 ORDER BY `unit` DESC [ RunTime:0.012337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451397 LIMIT 2 [ RunTime:0.042058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451397 ORDER BY `minOrder` ASC [ RunTime:0.011253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451396 LIMIT 4 [ RunTime:0.031161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451396 ORDER BY `minOrder` ASC [ RunTime:0.012816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451396 ORDER BY `unit` DESC [ RunTime:0.022786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451396 LIMIT 2 [ RunTime:0.073651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451396 ORDER BY `minOrder` ASC [ RunTime:0.022325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451395 LIMIT 4 [ RunTime:0.033354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451395 ORDER BY `minOrder` ASC [ RunTime:0.029816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451395 ORDER BY `unit` DESC [ RunTime:0.044176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451395 LIMIT 2 [ RunTime:0.074499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451395 ORDER BY `minOrder` ASC [ RunTime:0.008258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451394 LIMIT 4 [ RunTime:0.012849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451394 ORDER BY `minOrder` ASC [ RunTime:0.050209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451394 ORDER BY `unit` DESC [ RunTime:0.035685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451394 LIMIT 2 [ RunTime:0.019251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451394 ORDER BY `minOrder` ASC [ RunTime:0.009794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451393 LIMIT 4 [ RunTime:0.020410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451393 ORDER BY `minOrder` ASC [ RunTime:0.034784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451393 ORDER BY `unit` DESC [ RunTime:0.022635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451393 LIMIT 2 [ RunTime:0.033704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451393 ORDER BY `minOrder` ASC [ RunTime:0.013433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451392 LIMIT 4 [ RunTime:0.012250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451392 ORDER BY `minOrder` ASC [ RunTime:0.009939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451392 ORDER BY `unit` DESC [ RunTime:0.007966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451392 LIMIT 2 [ RunTime:0.021707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451392 ORDER BY `minOrder` ASC [ RunTime:0.005835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451391 LIMIT 4 [ RunTime:0.032749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451391 ORDER BY `minOrder` ASC [ RunTime:0.019637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451391 ORDER BY `unit` DESC [ RunTime:0.007721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451391 LIMIT 2 [ RunTime:0.008466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451391 ORDER BY `minOrder` ASC [ RunTime:0.005801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451390 LIMIT 4 [ RunTime:0.009084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451390 ORDER BY `minOrder` ASC [ RunTime:0.010671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451390 ORDER BY `unit` DESC [ RunTime:0.014455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451390 LIMIT 2 [ RunTime:0.010247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451390 ORDER BY `minOrder` ASC [ RunTime:0.011869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451389 LIMIT 4 [ RunTime:0.029370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451389 ORDER BY `minOrder` ASC [ RunTime:0.016911s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451389 ORDER BY `unit` DESC [ RunTime:0.008506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451389 LIMIT 2 [ RunTime:0.016656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451389 ORDER BY `minOrder` ASC [ RunTime:0.022746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451388 LIMIT 4 [ RunTime:0.009148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451388 ORDER BY `minOrder` ASC [ RunTime:0.017902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451388 ORDER BY `unit` DESC [ RunTime:0.017913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451388 LIMIT 2 [ RunTime:0.011724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451388 ORDER BY `minOrder` ASC [ RunTime:0.020375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451387 LIMIT 4 [ RunTime:0.013442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451387 ORDER BY `minOrder` ASC [ RunTime:0.038936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451387 ORDER BY `unit` DESC [ RunTime:0.017918s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451387 LIMIT 2 [ RunTime:0.009329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451387 ORDER BY `minOrder` ASC [ RunTime:0.015032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451386 LIMIT 4 [ RunTime:0.022220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451386 ORDER BY `minOrder` ASC [ RunTime:0.025845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451386 ORDER BY `unit` DESC [ RunTime:0.034625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451386 LIMIT 2 [ RunTime:0.017940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451386 ORDER BY `minOrder` ASC [ RunTime:0.014961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451385 LIMIT 4 [ RunTime:0.011620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451385 ORDER BY `minOrder` ASC [ RunTime:0.007007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451385 ORDER BY `unit` DESC [ RunTime:0.017738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451385 LIMIT 2 [ RunTime:0.018559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451385 ORDER BY `minOrder` ASC [ RunTime:0.014446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451384 LIMIT 4 [ RunTime:0.019230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451384 ORDER BY `minOrder` ASC [ RunTime:0.010181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451384 ORDER BY `unit` DESC [ RunTime:0.019738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451384 LIMIT 2 [ RunTime:0.016428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451384 ORDER BY `minOrder` ASC [ RunTime:0.016331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451383 LIMIT 4 [ RunTime:0.017445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451383 ORDER BY `minOrder` ASC [ RunTime:0.006053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451383 ORDER BY `unit` DESC [ RunTime:0.014084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451383 LIMIT 2 [ RunTime:0.023235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451383 ORDER BY `minOrder` ASC [ RunTime:0.009938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451382 LIMIT 4 [ RunTime:0.008764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451382 ORDER BY `minOrder` ASC [ RunTime:0.012596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451382 ORDER BY `unit` DESC [ RunTime:0.028372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451382 LIMIT 2 [ RunTime:0.025542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451382 ORDER BY `minOrder` ASC [ RunTime:0.015241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451381 LIMIT 4 [ RunTime:0.043619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451381 ORDER BY `minOrder` ASC [ RunTime:0.024529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451381 ORDER BY `unit` DESC [ RunTime:0.029652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451381 LIMIT 2 [ RunTime:0.048450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451381 ORDER BY `minOrder` ASC [ RunTime:0.030140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451380 LIMIT 4 [ RunTime:0.016701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451380 ORDER BY `minOrder` ASC [ RunTime:0.048937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451380 ORDER BY `unit` DESC [ RunTime:0.032420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451380 LIMIT 2 [ RunTime:0.009232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451380 ORDER BY `minOrder` ASC [ RunTime:0.038845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451379 LIMIT 4 [ RunTime:0.018647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451379 ORDER BY `minOrder` ASC [ RunTime:0.023684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451379 ORDER BY `unit` DESC [ RunTime:0.020886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451379 LIMIT 2 [ RunTime:0.006881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451379 ORDER BY `minOrder` ASC [ RunTime:0.004884s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.006603s ]