SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003107s ]
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=445&srecordnum=10000' [ RunTime:0.002798s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001308s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000582s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001604s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000333s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001956s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000312s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001464s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.003363s ]
UPDATE `stock_search` SET `count` = 1958 , `updatetime` = '2026-06-12 09:18:32' WHERE `partno` = '228' [ RunTime:0.002289s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000354s ]
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.002918s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002667s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.000446s ]
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 8880,20 [ RunTime:0.173995s ]
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 ('15429886','15429885','15429884','15429883','15429882','15429881','15429880','15429879','15429878','15429877','15429876','15429875','15429874','15429873','15429872','15429871','15429870','15429869','15429868','15429867') ORDER BY FIELD(s.id, 15429886,15429885,15429884,15429883,15429882,15429881,15429880,15429879,15429878,15429877,15429876,15429875,15429874,15429873,15429872,15429871,15429870,15429869,15429868,15429867) [ RunTime:0.024085s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15429886 LIMIT 4 [ RunTime:0.008814s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429886 ORDER BY `minOrder` ASC [ RunTime:0.019260s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15429886 ORDER BY `unit` DESC [ RunTime:0.019408s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15429886 LIMIT 2 [ RunTime:0.007034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429886 ORDER BY `minOrder` ASC [ RunTime:0.004280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15429885 LIMIT 4 [ RunTime:0.008113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429885 ORDER BY `minOrder` ASC [ RunTime:0.010232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15429885 ORDER BY `unit` DESC [ RunTime:0.015937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15429885 LIMIT 2 [ RunTime:0.009679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429885 ORDER BY `minOrder` ASC [ RunTime:0.002815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15429884 LIMIT 4 [ RunTime:0.039877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429884 ORDER BY `minOrder` ASC [ RunTime:0.020715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15429884 ORDER BY `unit` DESC [ RunTime:0.016810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15429884 LIMIT 2 [ RunTime:0.028699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429884 ORDER BY `minOrder` ASC [ RunTime:0.019201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15429883 LIMIT 4 [ RunTime:0.017687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429883 ORDER BY `minOrder` ASC [ RunTime:0.031778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15429883 ORDER BY `unit` DESC [ RunTime:0.005268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15429883 LIMIT 2 [ RunTime:0.016112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429883 ORDER BY `minOrder` ASC [ RunTime:0.002400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15429882 LIMIT 4 [ RunTime:0.003661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429882 ORDER BY `minOrder` ASC [ RunTime:0.013959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15429882 ORDER BY `unit` DESC [ RunTime:0.035660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15429882 LIMIT 2 [ RunTime:0.007338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429882 ORDER BY `minOrder` ASC [ RunTime:0.005311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15429881 LIMIT 4 [ RunTime:0.009378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429881 ORDER BY `minOrder` ASC [ RunTime:0.026360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15429881 ORDER BY `unit` DESC [ RunTime:0.024688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15429881 LIMIT 2 [ RunTime:0.026318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429881 ORDER BY `minOrder` ASC [ RunTime:0.014399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15429880 LIMIT 4 [ RunTime:0.011064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429880 ORDER BY `minOrder` ASC [ RunTime:0.034763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15429880 ORDER BY `unit` DESC [ RunTime:0.018206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15429880 LIMIT 2 [ RunTime:0.014968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429880 ORDER BY `minOrder` ASC [ RunTime:0.008497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15429879 LIMIT 4 [ RunTime:0.020911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429879 ORDER BY `minOrder` ASC [ RunTime:0.025622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15429879 ORDER BY `unit` DESC [ RunTime:0.022359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15429879 LIMIT 2 [ RunTime:0.031134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429879 ORDER BY `minOrder` ASC [ RunTime:0.033256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15429878 LIMIT 4 [ RunTime:0.009586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429878 ORDER BY `minOrder` ASC [ RunTime:0.016135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15429878 ORDER BY `unit` DESC [ RunTime:0.020830s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15429878 LIMIT 2 [ RunTime:0.054092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429878 ORDER BY `minOrder` ASC [ RunTime:0.018356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15429877 LIMIT 4 [ RunTime:0.010404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429877 ORDER BY `minOrder` ASC [ RunTime:0.017503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15429877 ORDER BY `unit` DESC [ RunTime:0.013165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15429877 LIMIT 2 [ RunTime:0.012266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429877 ORDER BY `minOrder` ASC [ RunTime:0.020449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15429876 LIMIT 4 [ RunTime:0.001768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429876 ORDER BY `minOrder` ASC [ RunTime:0.008722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15429876 ORDER BY `unit` DESC [ RunTime:0.012532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15429876 LIMIT 2 [ RunTime:0.007565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429876 ORDER BY `minOrder` ASC [ RunTime:0.010124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15429875 LIMIT 4 [ RunTime:0.018014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429875 ORDER BY `minOrder` ASC [ RunTime:0.010234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15429875 ORDER BY `unit` DESC [ RunTime:0.033982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15429875 LIMIT 2 [ RunTime:0.010110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429875 ORDER BY `minOrder` ASC [ RunTime:0.009706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15429874 LIMIT 4 [ RunTime:0.009533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429874 ORDER BY `minOrder` ASC [ RunTime:0.007247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15429874 ORDER BY `unit` DESC [ RunTime:0.011145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15429874 LIMIT 2 [ RunTime:0.026165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429874 ORDER BY `minOrder` ASC [ RunTime:0.037899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15429873 LIMIT 4 [ RunTime:0.043940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429873 ORDER BY `minOrder` ASC [ RunTime:0.020579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15429873 ORDER BY `unit` DESC [ RunTime:0.035093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15429873 LIMIT 2 [ RunTime:0.016241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429873 ORDER BY `minOrder` ASC [ RunTime:0.034665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15429872 LIMIT 4 [ RunTime:0.017998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429872 ORDER BY `minOrder` ASC [ RunTime:0.005915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15429872 ORDER BY `unit` DESC [ RunTime:0.010472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15429872 LIMIT 2 [ RunTime:0.014651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429872 ORDER BY `minOrder` ASC [ RunTime:0.011767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15429871 LIMIT 4 [ RunTime:0.011910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429871 ORDER BY `minOrder` ASC [ RunTime:0.005870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15429871 ORDER BY `unit` DESC [ RunTime:0.012884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15429871 LIMIT 2 [ RunTime:0.024060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429871 ORDER BY `minOrder` ASC [ RunTime:0.015220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15429870 LIMIT 4 [ RunTime:0.004813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429870 ORDER BY `minOrder` ASC [ RunTime:0.017603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15429870 ORDER BY `unit` DESC [ RunTime:0.038767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15429870 LIMIT 2 [ RunTime:0.003305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429870 ORDER BY `minOrder` ASC [ RunTime:0.003322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15429869 LIMIT 4 [ RunTime:0.004919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429869 ORDER BY `minOrder` ASC [ RunTime:0.017491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15429869 ORDER BY `unit` DESC [ RunTime:0.019878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15429869 LIMIT 2 [ RunTime:0.012802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429869 ORDER BY `minOrder` ASC [ RunTime:0.006031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15429868 LIMIT 4 [ RunTime:0.006892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429868 ORDER BY `minOrder` ASC [ RunTime:0.017973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15429868 ORDER BY `unit` DESC [ RunTime:0.002385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15429868 LIMIT 2 [ RunTime:0.012534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429868 ORDER BY `minOrder` ASC [ RunTime:0.006903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15429867 LIMIT 4 [ RunTime:0.019436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429867 ORDER BY `minOrder` ASC [ RunTime:0.001330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15429867 ORDER BY `unit` DESC [ RunTime:0.006036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15429867 LIMIT 2 [ RunTime:0.003981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15429867 ORDER BY `minOrder` ASC [ RunTime:0.007435s ]
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.007529s ]