SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002583s ]
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=498&srecordnum=10000' [ RunTime:0.005976s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002139s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001434s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002904s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000410s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002459s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000412s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002194s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.000654s ]
UPDATE `stock_search` SET `count` = 203 , `updatetime` = '2026-06-11 02:03:30' WHERE `partno` = '228' [ RunTime:0.006837s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000280s ]
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.000536s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002904s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.190487s ]
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 9940,20 [ RunTime:0.189006s ]
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 ('12451358','12451357','12451356','12451355','12451354','12451353','12451352','12451351','12451350','12451349','12451348','12451347','12451346','12451345','12451344','12451343','12451342','12451341','12451340','12451339') ORDER BY FIELD(s.id, 12451358,12451357,12451356,12451355,12451354,12451353,12451352,12451351,12451350,12451349,12451348,12451347,12451346,12451345,12451344,12451343,12451342,12451341,12451340,12451339) [ RunTime:0.012657s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451358 LIMIT 4 [ RunTime:0.046506s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451358 ORDER BY `minOrder` ASC [ RunTime:0.020292s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451358 ORDER BY `unit` DESC [ RunTime:0.027257s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451358 LIMIT 2 [ RunTime:0.016104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451358 ORDER BY `minOrder` ASC [ RunTime:0.029783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451357 LIMIT 4 [ RunTime:0.027369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451357 ORDER BY `minOrder` ASC [ RunTime:0.014218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451357 ORDER BY `unit` DESC [ RunTime:0.011567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451357 LIMIT 2 [ RunTime:0.035729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451357 ORDER BY `minOrder` ASC [ RunTime:0.019641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451356 LIMIT 4 [ RunTime:0.006402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451356 ORDER BY `minOrder` ASC [ RunTime:0.026321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451356 ORDER BY `unit` DESC [ RunTime:0.004352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451356 LIMIT 2 [ RunTime:0.014429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451356 ORDER BY `minOrder` ASC [ RunTime:0.037082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451355 LIMIT 4 [ RunTime:0.049308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451355 ORDER BY `minOrder` ASC [ RunTime:0.011048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451355 ORDER BY `unit` DESC [ RunTime:0.037858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451355 LIMIT 2 [ RunTime:0.005181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451355 ORDER BY `minOrder` ASC [ RunTime:0.011464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451354 LIMIT 4 [ RunTime:0.027326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451354 ORDER BY `minOrder` ASC [ RunTime:0.016772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451354 ORDER BY `unit` DESC [ RunTime:0.038684s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451354 LIMIT 2 [ RunTime:0.093536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451354 ORDER BY `minOrder` ASC [ RunTime:0.034498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451353 LIMIT 4 [ RunTime:0.018160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451353 ORDER BY `minOrder` ASC [ RunTime:0.043307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451353 ORDER BY `unit` DESC [ RunTime:0.004833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451353 LIMIT 2 [ RunTime:0.020958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451353 ORDER BY `minOrder` ASC [ RunTime:0.010993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451352 LIMIT 4 [ RunTime:0.055501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451352 ORDER BY `minOrder` ASC [ RunTime:0.030851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451352 ORDER BY `unit` DESC [ RunTime:0.015466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451352 LIMIT 2 [ RunTime:0.003192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451352 ORDER BY `minOrder` ASC [ RunTime:0.008962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451351 LIMIT 4 [ RunTime:0.002675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451351 ORDER BY `minOrder` ASC [ RunTime:0.033682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451351 ORDER BY `unit` DESC [ RunTime:0.049075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451351 LIMIT 2 [ RunTime:0.012741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451351 ORDER BY `minOrder` ASC [ RunTime:0.002130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451350 LIMIT 4 [ RunTime:0.005375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451350 ORDER BY `minOrder` ASC [ RunTime:0.008728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451350 ORDER BY `unit` DESC [ RunTime:0.012516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451350 LIMIT 2 [ RunTime:0.008162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451350 ORDER BY `minOrder` ASC [ RunTime:0.013707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451349 LIMIT 4 [ RunTime:0.014974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451349 ORDER BY `minOrder` ASC [ RunTime:0.028958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451349 ORDER BY `unit` DESC [ RunTime:0.016245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451349 LIMIT 2 [ RunTime:0.012660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451349 ORDER BY `minOrder` ASC [ RunTime:0.036790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451348 LIMIT 4 [ RunTime:0.012290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451348 ORDER BY `minOrder` ASC [ RunTime:0.017877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451348 ORDER BY `unit` DESC [ RunTime:0.017293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451348 LIMIT 2 [ RunTime:0.029594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451348 ORDER BY `minOrder` ASC [ RunTime:0.012403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451347 LIMIT 4 [ RunTime:0.012001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451347 ORDER BY `minOrder` ASC [ RunTime:0.034104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451347 ORDER BY `unit` DESC [ RunTime:0.011024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451347 LIMIT 2 [ RunTime:0.003418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451347 ORDER BY `minOrder` ASC [ RunTime:0.015038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451346 LIMIT 4 [ RunTime:0.009373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451346 ORDER BY `minOrder` ASC [ RunTime:0.020849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451346 ORDER BY `unit` DESC [ RunTime:0.019362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451346 LIMIT 2 [ RunTime:0.024837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451346 ORDER BY `minOrder` ASC [ RunTime:0.007762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451345 LIMIT 4 [ RunTime:0.022041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451345 ORDER BY `minOrder` ASC [ RunTime:0.021500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451345 ORDER BY `unit` DESC [ RunTime:0.010757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451345 LIMIT 2 [ RunTime:0.020061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451345 ORDER BY `minOrder` ASC [ RunTime:0.017636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451344 LIMIT 4 [ RunTime:0.015138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451344 ORDER BY `minOrder` ASC [ RunTime:0.014850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451344 ORDER BY `unit` DESC [ RunTime:0.023462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451344 LIMIT 2 [ RunTime:0.034515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451344 ORDER BY `minOrder` ASC [ RunTime:0.013474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451343 LIMIT 4 [ RunTime:0.017257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451343 ORDER BY `minOrder` ASC [ RunTime:0.005333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451343 ORDER BY `unit` DESC [ RunTime:0.005633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451343 LIMIT 2 [ RunTime:0.022765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451343 ORDER BY `minOrder` ASC [ RunTime:0.003267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451342 LIMIT 4 [ RunTime:0.020071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451342 ORDER BY `minOrder` ASC [ RunTime:0.006410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451342 ORDER BY `unit` DESC [ RunTime:0.015726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451342 LIMIT 2 [ RunTime:0.029820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451342 ORDER BY `minOrder` ASC [ RunTime:0.021668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451341 LIMIT 4 [ RunTime:0.018139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451341 ORDER BY `minOrder` ASC [ RunTime:0.020723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451341 ORDER BY `unit` DESC [ RunTime:0.017225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451341 LIMIT 2 [ RunTime:0.015142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451341 ORDER BY `minOrder` ASC [ RunTime:0.006918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451340 LIMIT 4 [ RunTime:0.014179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451340 ORDER BY `minOrder` ASC [ RunTime:0.042530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451340 ORDER BY `unit` DESC [ RunTime:0.023580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451340 LIMIT 2 [ RunTime:0.048651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451340 ORDER BY `minOrder` ASC [ RunTime:0.040118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12451339 LIMIT 4 [ RunTime:0.039850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451339 ORDER BY `minOrder` ASC [ RunTime:0.006345s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12451339 ORDER BY `unit` DESC [ RunTime:0.040304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12451339 LIMIT 2 [ RunTime:0.029234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12451339 ORDER BY `minOrder` ASC [ RunTime:0.018862s ]
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.116781s ]