SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001170s ]
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=484&srecordnum=10000' [ RunTime:0.003566s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001311s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000491s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001315s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000256s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001462s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000272s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001155s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.003915s ]
UPDATE `stock_search` SET `count` = 1141 , `updatetime` = '2026-06-11 19:30:53' WHERE `partno` = '228' [ RunTime:0.003244s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000274s ]
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.000451s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001899s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.214671s ]
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 9660,20 [ RunTime:0.177753s ]
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 ('12451651','12451650','12451649','12451648','12451647','12451646','12451645','12451644','12451643','12451642','12451641','12451640','12451639','12451638','12451637','12451636','12451635','12451634','12451633','12451632') ORDER BY FIELD(s.id, 12451651,12451650,12451649,12451648,12451647,12451646,12451645,12451644,12451643,12451642,12451641,12451640,12451639,12451638,12451637,12451636,12451635,12451634,12451633,12451632) [ RunTime:0.101280s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.011182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451651 LIMIT 4 [ RunTime:0.002492s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451651 ORDER BY `minOrder` ASC [ RunTime:0.017544s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451651 ORDER BY `unit` DESC [ RunTime:0.020454s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.016468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451651 LIMIT 2 [ RunTime:0.011120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451651 ORDER BY `minOrder` ASC [ RunTime:0.013544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451650 LIMIT 4 [ RunTime:0.011249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451650 ORDER BY `minOrder` ASC [ RunTime:0.022137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451650 ORDER BY `unit` DESC [ RunTime:0.033955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451650 LIMIT 2 [ RunTime:0.065624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451650 ORDER BY `minOrder` ASC [ RunTime:0.014137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451649 LIMIT 4 [ RunTime:0.039602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451649 ORDER BY `minOrder` ASC [ RunTime:0.024326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451649 ORDER BY `unit` DESC [ RunTime:0.033390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451649 LIMIT 2 [ RunTime:0.044606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451649 ORDER BY `minOrder` ASC [ RunTime:0.004647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451648 LIMIT 4 [ RunTime:0.051476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451648 ORDER BY `minOrder` ASC [ RunTime:0.054205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451648 ORDER BY `unit` DESC [ RunTime:0.043707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451648 LIMIT 2 [ RunTime:0.015884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451648 ORDER BY `minOrder` ASC [ RunTime:0.028941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451647 LIMIT 4 [ RunTime:0.020949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451647 ORDER BY `minOrder` ASC [ RunTime:0.030233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451647 ORDER BY `unit` DESC [ RunTime:0.020665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451647 LIMIT 2 [ RunTime:0.054304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451647 ORDER BY `minOrder` ASC [ RunTime:0.024700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451646 LIMIT 4 [ RunTime:0.044482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451646 ORDER BY `minOrder` ASC [ RunTime:0.035164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451646 ORDER BY `unit` DESC [ RunTime:0.004155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451646 LIMIT 2 [ RunTime:0.033542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451646 ORDER BY `minOrder` ASC [ RunTime:0.002812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451645 LIMIT 4 [ RunTime:0.017932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451645 ORDER BY `minOrder` ASC [ RunTime:0.003137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451645 ORDER BY `unit` DESC [ RunTime:0.011559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451645 LIMIT 2 [ RunTime:0.021310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451645 ORDER BY `minOrder` ASC [ RunTime:0.010820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451644 LIMIT 4 [ RunTime:0.011007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451644 ORDER BY `minOrder` ASC [ RunTime:0.056427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451644 ORDER BY `unit` DESC [ RunTime:0.018590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451644 LIMIT 2 [ RunTime:0.028021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451644 ORDER BY `minOrder` ASC [ RunTime:0.012649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451643 LIMIT 4 [ RunTime:0.010252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451643 ORDER BY `minOrder` ASC [ RunTime:0.018129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451643 ORDER BY `unit` DESC [ RunTime:0.021432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451643 LIMIT 2 [ RunTime:0.011651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451643 ORDER BY `minOrder` ASC [ RunTime:0.015423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451642 LIMIT 4 [ RunTime:0.027961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451642 ORDER BY `minOrder` ASC [ RunTime:0.041941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451642 ORDER BY `unit` DESC [ RunTime:0.022239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451642 LIMIT 2 [ RunTime:0.061881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451642 ORDER BY `minOrder` ASC [ RunTime:0.015359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451641 LIMIT 4 [ RunTime:0.023738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451641 ORDER BY `minOrder` ASC [ RunTime:0.108108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451641 ORDER BY `unit` DESC [ RunTime:0.032600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451641 LIMIT 2 [ RunTime:0.006434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451641 ORDER BY `minOrder` ASC [ RunTime:0.014253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451640 LIMIT 4 [ RunTime:0.020239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451640 ORDER BY `minOrder` ASC [ RunTime:0.044709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451640 ORDER BY `unit` DESC [ RunTime:0.029206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451640 LIMIT 2 [ RunTime:0.024276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451640 ORDER BY `minOrder` ASC [ RunTime:0.019363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451639 LIMIT 4 [ RunTime:0.011491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451639 ORDER BY `minOrder` ASC [ RunTime:0.028919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451639 ORDER BY `unit` DESC [ RunTime:0.066843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451639 LIMIT 2 [ RunTime:0.027424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451639 ORDER BY `minOrder` ASC [ RunTime:0.044926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451638 LIMIT 4 [ RunTime:0.026917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451638 ORDER BY `minOrder` ASC [ RunTime:0.034550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451638 ORDER BY `unit` DESC [ RunTime:0.049939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451638 LIMIT 2 [ RunTime:0.048982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451638 ORDER BY `minOrder` ASC [ RunTime:0.037615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451637 LIMIT 4 [ RunTime:0.011126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451637 ORDER BY `minOrder` ASC [ RunTime:0.020268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451637 ORDER BY `unit` DESC [ RunTime:0.086951s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451637 LIMIT 2 [ RunTime:0.043836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451637 ORDER BY `minOrder` ASC [ RunTime:0.026507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451636 LIMIT 4 [ RunTime:0.019649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451636 ORDER BY `minOrder` ASC [ RunTime:0.023817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451636 ORDER BY `unit` DESC [ RunTime:0.018105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451636 LIMIT 2 [ RunTime:0.011701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451636 ORDER BY `minOrder` ASC [ RunTime:0.012192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451635 LIMIT 4 [ RunTime:0.026732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451635 ORDER BY `minOrder` ASC [ RunTime:0.039087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451635 ORDER BY `unit` DESC [ RunTime:0.053305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451635 LIMIT 2 [ RunTime:0.037590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451635 ORDER BY `minOrder` ASC [ RunTime:0.023395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451634 LIMIT 4 [ RunTime:0.084176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451634 ORDER BY `minOrder` ASC [ RunTime:0.027201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451634 ORDER BY `unit` DESC [ RunTime:0.069750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451634 LIMIT 2 [ RunTime:0.039361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451634 ORDER BY `minOrder` ASC [ RunTime:0.015592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451633 LIMIT 4 [ RunTime:0.074611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451633 ORDER BY `minOrder` ASC [ RunTime:0.028735s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451633 ORDER BY `unit` DESC [ RunTime:0.072218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451633 LIMIT 2 [ RunTime:0.078458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451633 ORDER BY `minOrder` ASC [ RunTime:0.005111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451632 LIMIT 4 [ RunTime:0.020520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451632 ORDER BY `minOrder` ASC [ RunTime:0.007847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451632 ORDER BY `unit` DESC [ RunTime:0.019281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451632 LIMIT 2 [ RunTime:0.012747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451632 ORDER BY `minOrder` ASC [ RunTime:0.014546s ]
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.138336s ]