SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001630s ]
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=494&srecordnum=10000' [ RunTime:0.005407s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001109s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001708s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001112s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.002390s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001830s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001166s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001342s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.002549s ]
UPDATE `stock_search` SET `count` = 201 , `updatetime` = '2026-06-11 02:03:30' WHERE `partno` = '228' [ RunTime:0.000668s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001617s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000278s ]
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.000497s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002511s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.340790s ]
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 9860,20 [ RunTime:0.194832s ]
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 ('12451438','12451437','12451436','12451435','12451434','12451433','12451432','12451431','12451430','12451429','12451428','12451427','12451426','12451425','12451424','12451423','12451422','12451421','12451420','12451419') ORDER BY FIELD(s.id, 12451438,12451437,12451436,12451435,12451434,12451433,12451432,12451431,12451430,12451429,12451428,12451427,12451426,12451425,12451424,12451423,12451422,12451421,12451420,12451419) [ RunTime:0.036049s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.020423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451438 LIMIT 4 [ RunTime:0.021775s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.022266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451438 ORDER BY `minOrder` ASC [ RunTime:0.006252s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.013978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451438 ORDER BY `unit` DESC [ RunTime:0.013014s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.029806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451438 LIMIT 2 [ RunTime:0.024250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451438 ORDER BY `minOrder` ASC [ RunTime:0.008973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451437 LIMIT 4 [ RunTime:0.031645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451437 ORDER BY `minOrder` ASC [ RunTime:0.055545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451437 ORDER BY `unit` DESC [ RunTime:0.021608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451437 LIMIT 2 [ RunTime:0.038313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451437 ORDER BY `minOrder` ASC [ RunTime:0.047545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451436 LIMIT 4 [ RunTime:0.046281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451436 ORDER BY `minOrder` ASC [ RunTime:0.019026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451436 ORDER BY `unit` DESC [ RunTime:0.053762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451436 LIMIT 2 [ RunTime:0.080709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451436 ORDER BY `minOrder` ASC [ RunTime:0.001620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451435 LIMIT 4 [ RunTime:0.010031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451435 ORDER BY `minOrder` ASC [ RunTime:0.013085s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451435 ORDER BY `unit` DESC [ RunTime:0.031543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451435 LIMIT 2 [ RunTime:0.051587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451435 ORDER BY `minOrder` ASC [ RunTime:0.016469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451434 LIMIT 4 [ RunTime:0.019294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451434 ORDER BY `minOrder` ASC [ RunTime:0.024393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451434 ORDER BY `unit` DESC [ RunTime:0.022230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451434 LIMIT 2 [ RunTime:0.031532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451434 ORDER BY `minOrder` ASC [ RunTime:0.032098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451433 LIMIT 4 [ RunTime:0.005527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451433 ORDER BY `minOrder` ASC [ RunTime:0.022676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451433 ORDER BY `unit` DESC [ RunTime:0.011925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451433 LIMIT 2 [ RunTime:0.004871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451433 ORDER BY `minOrder` ASC [ RunTime:0.009049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451432 LIMIT 4 [ RunTime:0.018590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451432 ORDER BY `minOrder` ASC [ RunTime:0.013132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451432 ORDER BY `unit` DESC [ RunTime:0.036437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451432 LIMIT 2 [ RunTime:0.014897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451432 ORDER BY `minOrder` ASC [ RunTime:0.003695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451431 LIMIT 4 [ RunTime:0.006797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451431 ORDER BY `minOrder` ASC [ RunTime:0.011968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451431 ORDER BY `unit` DESC [ RunTime:0.006833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451431 LIMIT 2 [ RunTime:0.010910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451431 ORDER BY `minOrder` ASC [ RunTime:0.016993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451430 LIMIT 4 [ RunTime:0.011629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451430 ORDER BY `minOrder` ASC [ RunTime:0.032724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451430 ORDER BY `unit` DESC [ RunTime:0.018235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451430 LIMIT 2 [ RunTime:0.013434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451430 ORDER BY `minOrder` ASC [ RunTime:0.014503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451429 LIMIT 4 [ RunTime:0.018028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451429 ORDER BY `minOrder` ASC [ RunTime:0.006602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451429 ORDER BY `unit` DESC [ RunTime:0.013527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451429 LIMIT 2 [ RunTime:0.011177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451429 ORDER BY `minOrder` ASC [ RunTime:0.002171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451428 LIMIT 4 [ RunTime:0.019770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451428 ORDER BY `minOrder` ASC [ RunTime:0.028552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451428 ORDER BY `unit` DESC [ RunTime:0.009059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451428 LIMIT 2 [ RunTime:0.013622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451428 ORDER BY `minOrder` ASC [ RunTime:0.023321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451427 LIMIT 4 [ RunTime:0.016110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451427 ORDER BY `minOrder` ASC [ RunTime:0.004327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451427 ORDER BY `unit` DESC [ RunTime:0.027537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451427 LIMIT 2 [ RunTime:0.020014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451427 ORDER BY `minOrder` ASC [ RunTime:0.012002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451426 LIMIT 4 [ RunTime:0.019518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451426 ORDER BY `minOrder` ASC [ RunTime:0.017967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451426 ORDER BY `unit` DESC [ RunTime:0.040142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451426 LIMIT 2 [ RunTime:0.007315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451426 ORDER BY `minOrder` ASC [ RunTime:0.006648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451425 LIMIT 4 [ RunTime:0.035216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451425 ORDER BY `minOrder` ASC [ RunTime:0.024667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451425 ORDER BY `unit` DESC [ RunTime:0.012900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451425 LIMIT 2 [ RunTime:0.013821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451425 ORDER BY `minOrder` ASC [ RunTime:0.013985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451424 LIMIT 4 [ RunTime:0.015142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451424 ORDER BY `minOrder` ASC [ RunTime:0.023887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451424 ORDER BY `unit` DESC [ RunTime:0.022769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451424 LIMIT 2 [ RunTime:0.000996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451424 ORDER BY `minOrder` ASC [ RunTime:0.006489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451423 LIMIT 4 [ RunTime:0.008223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451423 ORDER BY `minOrder` ASC [ RunTime:0.013524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451423 ORDER BY `unit` DESC [ RunTime:0.007310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451423 LIMIT 2 [ RunTime:0.020809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451423 ORDER BY `minOrder` ASC [ RunTime:0.004362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451422 LIMIT 4 [ RunTime:0.014700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451422 ORDER BY `minOrder` ASC [ RunTime:0.021890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451422 ORDER BY `unit` DESC [ RunTime:0.023084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451422 LIMIT 2 [ RunTime:0.026749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451422 ORDER BY `minOrder` ASC [ RunTime:0.030889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451421 LIMIT 4 [ RunTime:0.011617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451421 ORDER BY `minOrder` ASC [ RunTime:0.020630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451421 ORDER BY `unit` DESC [ RunTime:0.011021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451421 LIMIT 2 [ RunTime:0.034252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451421 ORDER BY `minOrder` ASC [ RunTime:0.008566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451420 LIMIT 4 [ RunTime:0.040232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451420 ORDER BY `minOrder` ASC [ RunTime:0.017603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451420 ORDER BY `unit` DESC [ RunTime:0.024229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451420 LIMIT 2 [ RunTime:0.049595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451420 ORDER BY `minOrder` ASC [ RunTime:0.014770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451419 LIMIT 4 [ RunTime:0.006841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451419 ORDER BY `minOrder` ASC [ RunTime:0.023436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451419 ORDER BY `unit` DESC [ RunTime:0.006152s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451419 LIMIT 2 [ RunTime:0.014409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451419 ORDER BY `minOrder` ASC [ RunTime:0.023304s ]
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.137030s ]