SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.000980s ]
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=497&srecordnum=10000' [ RunTime:0.011183s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001636s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001261s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001635s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000278s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001414s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000842s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001819s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.000973s ]
UPDATE `stock_search` SET `count` = 202 , `updatetime` = '2026-06-11 02:03:30' WHERE `partno` = '228' [ RunTime:0.004165s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.004912s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.002939s ]
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.004012s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001488s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.303613s ]
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 9920,20 [ RunTime:0.197207s ]
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 ('12451378','12451377','12451376','12451375','12451374','12451373','12451372','12451371','12451370','12451369','12451368','12451367','12451366','12451365','12451364','12451363','12451362','12451361','12451360','12451359') ORDER BY FIELD(s.id, 12451378,12451377,12451376,12451375,12451374,12451373,12451372,12451371,12451370,12451369,12451368,12451367,12451366,12451365,12451364,12451363,12451362,12451361,12451360,12451359) [ RunTime:0.034700s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.016511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451378 LIMIT 4 [ RunTime:0.010661s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451378 ORDER BY `minOrder` ASC [ RunTime:0.029645s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451378 ORDER BY `unit` DESC [ RunTime:0.023531s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451378 LIMIT 2 [ RunTime:0.013986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451378 ORDER BY `minOrder` ASC [ RunTime:0.014620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451377 LIMIT 4 [ RunTime:0.018741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451377 ORDER BY `minOrder` ASC [ RunTime:0.016684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451377 ORDER BY `unit` DESC [ RunTime:0.032962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451377 LIMIT 2 [ RunTime:0.036240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451377 ORDER BY `minOrder` ASC [ RunTime:0.006108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451376 LIMIT 4 [ RunTime:0.024865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451376 ORDER BY `minOrder` ASC [ RunTime:0.054941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451376 ORDER BY `unit` DESC [ RunTime:0.047593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451376 LIMIT 2 [ RunTime:0.035566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451376 ORDER BY `minOrder` ASC [ RunTime:0.019388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451375 LIMIT 4 [ RunTime:0.029459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451375 ORDER BY `minOrder` ASC [ RunTime:0.038805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451375 ORDER BY `unit` DESC [ RunTime:0.040194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451375 LIMIT 2 [ RunTime:0.052083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451375 ORDER BY `minOrder` ASC [ RunTime:0.035749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451374 LIMIT 4 [ RunTime:0.030331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451374 ORDER BY `minOrder` ASC [ RunTime:0.031885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451374 ORDER BY `unit` DESC [ RunTime:0.005953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451374 LIMIT 2 [ RunTime:0.037101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451374 ORDER BY `minOrder` ASC [ RunTime:0.006491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451373 LIMIT 4 [ RunTime:0.026673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451373 ORDER BY `minOrder` ASC [ RunTime:0.036270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451373 ORDER BY `unit` DESC [ RunTime:0.023237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451373 LIMIT 2 [ RunTime:0.013216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451373 ORDER BY `minOrder` ASC [ RunTime:0.012717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451372 LIMIT 4 [ RunTime:0.009929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451372 ORDER BY `minOrder` ASC [ RunTime:0.009830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451372 ORDER BY `unit` DESC [ RunTime:0.018723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451372 LIMIT 2 [ RunTime:0.006681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451372 ORDER BY `minOrder` ASC [ RunTime:0.032499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451371 LIMIT 4 [ RunTime:0.019115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451371 ORDER BY `minOrder` ASC [ RunTime:0.006444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451371 ORDER BY `unit` DESC [ RunTime:0.008821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451371 LIMIT 2 [ RunTime:0.009340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451371 ORDER BY `minOrder` ASC [ RunTime:0.002888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451370 LIMIT 4 [ RunTime:0.010566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451370 ORDER BY `minOrder` ASC [ RunTime:0.005835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451370 ORDER BY `unit` DESC [ RunTime:0.016708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451370 LIMIT 2 [ RunTime:0.016563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451370 ORDER BY `minOrder` ASC [ RunTime:0.025166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451369 LIMIT 4 [ RunTime:0.013109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451369 ORDER BY `minOrder` ASC [ RunTime:0.018455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451369 ORDER BY `unit` DESC [ RunTime:0.016410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451369 LIMIT 2 [ RunTime:0.007884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451369 ORDER BY `minOrder` ASC [ RunTime:0.020712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451368 LIMIT 4 [ RunTime:0.020332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451368 ORDER BY `minOrder` ASC [ RunTime:0.012266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451368 ORDER BY `unit` DESC [ RunTime:0.008163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451368 LIMIT 2 [ RunTime:0.034741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451368 ORDER BY `minOrder` ASC [ RunTime:0.002664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451367 LIMIT 4 [ RunTime:0.011466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451367 ORDER BY `minOrder` ASC [ RunTime:0.034865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451367 ORDER BY `unit` DESC [ RunTime:0.010529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451367 LIMIT 2 [ RunTime:0.010019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451367 ORDER BY `minOrder` ASC [ RunTime:0.013477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451366 LIMIT 4 [ RunTime:0.005453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451366 ORDER BY `minOrder` ASC [ RunTime:0.020055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451366 ORDER BY `unit` DESC [ RunTime:0.021690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451366 LIMIT 2 [ RunTime:0.046632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451366 ORDER BY `minOrder` ASC [ RunTime:0.012836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451365 LIMIT 4 [ RunTime:0.011301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451365 ORDER BY `minOrder` ASC [ RunTime:0.009738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451365 ORDER BY `unit` DESC [ RunTime:0.024576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451365 LIMIT 2 [ RunTime:0.013718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451365 ORDER BY `minOrder` ASC [ RunTime:0.012215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451364 LIMIT 4 [ RunTime:0.005984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451364 ORDER BY `minOrder` ASC [ RunTime:0.007354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451364 ORDER BY `unit` DESC [ RunTime:0.013671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451364 LIMIT 2 [ RunTime:0.015188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451364 ORDER BY `minOrder` ASC [ RunTime:0.014860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451363 LIMIT 4 [ RunTime:0.018989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451363 ORDER BY `minOrder` ASC [ RunTime:0.018075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451363 ORDER BY `unit` DESC [ RunTime:0.013556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451363 LIMIT 2 [ RunTime:0.002698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451363 ORDER BY `minOrder` ASC [ RunTime:0.006183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451362 LIMIT 4 [ RunTime:0.010227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451362 ORDER BY `minOrder` ASC [ RunTime:0.018103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451362 ORDER BY `unit` DESC [ RunTime:0.013340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451362 LIMIT 2 [ RunTime:0.011580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451362 ORDER BY `minOrder` ASC [ RunTime:0.001092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451361 LIMIT 4 [ RunTime:0.017935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451361 ORDER BY `minOrder` ASC [ RunTime:0.013031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451361 ORDER BY `unit` DESC [ RunTime:0.025610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451361 LIMIT 2 [ RunTime:0.015885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451361 ORDER BY `minOrder` ASC [ RunTime:0.000988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451360 LIMIT 4 [ RunTime:0.021736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451360 ORDER BY `minOrder` ASC [ RunTime:0.012603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451360 ORDER BY `unit` DESC [ RunTime:0.037644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451360 LIMIT 2 [ RunTime:0.036879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451360 ORDER BY `minOrder` ASC [ RunTime:0.008312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451359 LIMIT 4 [ RunTime:0.013550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451359 ORDER BY `minOrder` ASC [ RunTime:0.026916s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451359 ORDER BY `unit` DESC [ RunTime:0.016841s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451359 LIMIT 2 [ RunTime:0.012896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451359 ORDER BY `minOrder` ASC [ RunTime:0.006330s ]
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.197452s ]