SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001500s ]
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=465&srecordnum=10000' [ RunTime:0.002659s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001350s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000539s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001545s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000328s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001625s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000357s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001571s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.000441s ]
UPDATE `stock_search` SET `count` = 1183 , `updatetime` = '2026-06-12 02:28:43' WHERE `partno` = '228' [ RunTime:0.007976s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.003027s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.002799s ]
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.000978s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002588s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.256413s ]
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 9280,20 [ RunTime:0.156101s ]
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 ('12452103','12452102','12452101','12452100','12452099','12452098','12452097','12452096','12452095','12452094','12452093','12452092','12452091','12452090','12452089','12452088','12452087','12452086','12452085','12452084') ORDER BY FIELD(s.id, 12452103,12452102,12452101,12452100,12452099,12452098,12452097,12452096,12452095,12452094,12452093,12452092,12452091,12452090,12452089,12452088,12452087,12452086,12452085,12452084) [ RunTime:0.018342s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452103 LIMIT 4 [ RunTime:0.015464s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452103 ORDER BY `minOrder` ASC [ RunTime:0.014213s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452103 ORDER BY `unit` DESC [ RunTime:0.012324s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452103 LIMIT 2 [ RunTime:0.024021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452103 ORDER BY `minOrder` ASC [ RunTime:0.006181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452102 LIMIT 4 [ RunTime:0.048420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452102 ORDER BY `minOrder` ASC [ RunTime:0.011625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452102 ORDER BY `unit` DESC [ RunTime:0.040450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452102 LIMIT 2 [ RunTime:0.099816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452102 ORDER BY `minOrder` ASC [ RunTime:0.057410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452101 LIMIT 4 [ RunTime:0.021344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452101 ORDER BY `minOrder` ASC [ RunTime:0.042648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452101 ORDER BY `unit` DESC [ RunTime:0.077410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452101 LIMIT 2 [ RunTime:0.068520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452101 ORDER BY `minOrder` ASC [ RunTime:0.012781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452100 LIMIT 4 [ RunTime:0.038299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452100 ORDER BY `minOrder` ASC [ RunTime:0.032985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452100 ORDER BY `unit` DESC [ RunTime:0.059691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452100 LIMIT 2 [ RunTime:0.084640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452100 ORDER BY `minOrder` ASC [ RunTime:0.033259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452099 LIMIT 4 [ RunTime:0.059843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452099 ORDER BY `minOrder` ASC [ RunTime:0.082334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452099 ORDER BY `unit` DESC [ RunTime:0.112180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452099 LIMIT 2 [ RunTime:0.050481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452099 ORDER BY `minOrder` ASC [ RunTime:0.021331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452098 LIMIT 4 [ RunTime:0.039158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452098 ORDER BY `minOrder` ASC [ RunTime:0.074011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452098 ORDER BY `unit` DESC [ RunTime:0.015521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452098 LIMIT 2 [ RunTime:0.031454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452098 ORDER BY `minOrder` ASC [ RunTime:0.007148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452097 LIMIT 4 [ RunTime:0.043079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452097 ORDER BY `minOrder` ASC [ RunTime:0.108411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452097 ORDER BY `unit` DESC [ RunTime:0.063983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452097 LIMIT 2 [ RunTime:0.035754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452097 ORDER BY `minOrder` ASC [ RunTime:0.023671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452096 LIMIT 4 [ RunTime:0.003581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452096 ORDER BY `minOrder` ASC [ RunTime:0.059977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452096 ORDER BY `unit` DESC [ RunTime:0.068014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452096 LIMIT 2 [ RunTime:0.082448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452096 ORDER BY `minOrder` ASC [ RunTime:0.077883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452095 LIMIT 4 [ RunTime:0.085781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452095 ORDER BY `minOrder` ASC [ RunTime:0.082311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452095 ORDER BY `unit` DESC [ RunTime:0.056930s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452095 LIMIT 2 [ RunTime:0.051645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452095 ORDER BY `minOrder` ASC [ RunTime:0.005031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452094 LIMIT 4 [ RunTime:0.052025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452094 ORDER BY `minOrder` ASC [ RunTime:0.049454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452094 ORDER BY `unit` DESC [ RunTime:0.049245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452094 LIMIT 2 [ RunTime:0.078757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452094 ORDER BY `minOrder` ASC [ RunTime:0.055210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452093 LIMIT 4 [ RunTime:0.037964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452093 ORDER BY `minOrder` ASC [ RunTime:0.029298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452093 ORDER BY `unit` DESC [ RunTime:0.064069s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452093 LIMIT 2 [ RunTime:0.085081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452093 ORDER BY `minOrder` ASC [ RunTime:0.020105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452092 LIMIT 4 [ RunTime:0.071809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452092 ORDER BY `minOrder` ASC [ RunTime:0.044474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452092 ORDER BY `unit` DESC [ RunTime:0.050578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452092 LIMIT 2 [ RunTime:0.039365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452092 ORDER BY `minOrder` ASC [ RunTime:0.011696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452091 LIMIT 4 [ RunTime:0.044071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452091 ORDER BY `minOrder` ASC [ RunTime:0.034492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452091 ORDER BY `unit` DESC [ RunTime:0.020264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452091 LIMIT 2 [ RunTime:0.007344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452091 ORDER BY `minOrder` ASC [ RunTime:0.011007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452090 LIMIT 4 [ RunTime:0.063036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452090 ORDER BY `minOrder` ASC [ RunTime:0.056843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452090 ORDER BY `unit` DESC [ RunTime:0.013451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452090 LIMIT 2 [ RunTime:0.043626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452090 ORDER BY `minOrder` ASC [ RunTime:0.017620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452089 LIMIT 4 [ RunTime:0.034579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452089 ORDER BY `minOrder` ASC [ RunTime:0.076575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452089 ORDER BY `unit` DESC [ RunTime:0.030190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452089 LIMIT 2 [ RunTime:0.065969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452089 ORDER BY `minOrder` ASC [ RunTime:0.045802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452088 LIMIT 4 [ RunTime:0.031007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452088 ORDER BY `minOrder` ASC [ RunTime:0.126252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452088 ORDER BY `unit` DESC [ RunTime:0.080808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452088 LIMIT 2 [ RunTime:0.074259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452088 ORDER BY `minOrder` ASC [ RunTime:0.031892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452087 LIMIT 4 [ RunTime:0.022223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452087 ORDER BY `minOrder` ASC [ RunTime:0.086700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452087 ORDER BY `unit` DESC [ RunTime:0.043456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452087 LIMIT 2 [ RunTime:0.038789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452087 ORDER BY `minOrder` ASC [ RunTime:0.042792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452086 LIMIT 4 [ RunTime:0.013362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452086 ORDER BY `minOrder` ASC [ RunTime:0.052163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452086 ORDER BY `unit` DESC [ RunTime:0.074162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452086 LIMIT 2 [ RunTime:0.078345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452086 ORDER BY `minOrder` ASC [ RunTime:0.022460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452085 LIMIT 4 [ RunTime:0.074382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452085 ORDER BY `minOrder` ASC [ RunTime:0.047468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452085 ORDER BY `unit` DESC [ RunTime:0.027602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452085 LIMIT 2 [ RunTime:0.023910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452085 ORDER BY `minOrder` ASC [ RunTime:0.015486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452084 LIMIT 4 [ RunTime:0.015899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452084 ORDER BY `minOrder` ASC [ RunTime:0.008831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452084 ORDER BY `unit` DESC [ RunTime:0.032766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452084 LIMIT 2 [ RunTime:0.017315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452084 ORDER BY `minOrder` ASC [ RunTime:0.006374s ]
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.003127s ]