SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001352s ]
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=463&srecordnum=10000' [ RunTime:0.001970s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001075s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000526s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001383s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000303s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002587s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000374s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001376s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.000670s ]
UPDATE `stock_search` SET `count` = 1181 , `updatetime` = '2026-06-12 02:28:43' WHERE `partno` = '228' [ RunTime:0.006418s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.002979s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000260s ]
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.000446s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001949s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.294034s ]
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 9240,20 [ RunTime:0.150912s ]
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 ('12452143','12452142','12452141','12452140','12452139','12452138','12452137','12452136','12452135','12452134','12452133','12452132','12452131','12452130','12452129','12452128','12452127','12452126','12452125','12452124') ORDER BY FIELD(s.id, 12452143,12452142,12452141,12452140,12452139,12452138,12452137,12452136,12452135,12452134,12452133,12452132,12452131,12452130,12452129,12452128,12452127,12452126,12452125,12452124) [ RunTime:0.018674s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452143 LIMIT 4 [ RunTime:0.005157s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452143 ORDER BY `minOrder` ASC [ RunTime:0.006648s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452143 ORDER BY `unit` DESC [ RunTime:0.011266s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452143 LIMIT 2 [ RunTime:0.009972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452143 ORDER BY `minOrder` ASC [ RunTime:0.001980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452142 LIMIT 4 [ RunTime:0.008777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452142 ORDER BY `minOrder` ASC [ RunTime:0.024984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452142 ORDER BY `unit` DESC [ RunTime:0.063400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452142 LIMIT 2 [ RunTime:0.026926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452142 ORDER BY `minOrder` ASC [ RunTime:0.009555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452141 LIMIT 4 [ RunTime:0.029238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452141 ORDER BY `minOrder` ASC [ RunTime:0.049340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452141 ORDER BY `unit` DESC [ RunTime:0.023892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452141 LIMIT 2 [ RunTime:0.048408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452141 ORDER BY `minOrder` ASC [ RunTime:0.004536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452140 LIMIT 4 [ RunTime:0.045257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452140 ORDER BY `minOrder` ASC [ RunTime:0.035428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452140 ORDER BY `unit` DESC [ RunTime:0.049722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452140 LIMIT 2 [ RunTime:0.051162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452140 ORDER BY `minOrder` ASC [ RunTime:0.019290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452139 LIMIT 4 [ RunTime:0.019153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452139 ORDER BY `minOrder` ASC [ RunTime:0.088945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452139 ORDER BY `unit` DESC [ RunTime:0.025149s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452139 LIMIT 2 [ RunTime:0.103643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452139 ORDER BY `minOrder` ASC [ RunTime:0.030702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452138 LIMIT 4 [ RunTime:0.066876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452138 ORDER BY `minOrder` ASC [ RunTime:0.076141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452138 ORDER BY `unit` DESC [ RunTime:0.052143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452138 LIMIT 2 [ RunTime:0.091757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452138 ORDER BY `minOrder` ASC [ RunTime:0.041522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452137 LIMIT 4 [ RunTime:0.032405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452137 ORDER BY `minOrder` ASC [ RunTime:0.035899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452137 ORDER BY `unit` DESC [ RunTime:0.034150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452137 LIMIT 2 [ RunTime:0.009873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452137 ORDER BY `minOrder` ASC [ RunTime:0.009766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452136 LIMIT 4 [ RunTime:0.041713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452136 ORDER BY `minOrder` ASC [ RunTime:0.018192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452136 ORDER BY `unit` DESC [ RunTime:0.047779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452136 LIMIT 2 [ RunTime:0.085684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452136 ORDER BY `minOrder` ASC [ RunTime:0.001063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452135 LIMIT 4 [ RunTime:0.023760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452135 ORDER BY `minOrder` ASC [ RunTime:0.049198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452135 ORDER BY `unit` DESC [ RunTime:0.050907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452135 LIMIT 2 [ RunTime:0.024360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452135 ORDER BY `minOrder` ASC [ RunTime:0.014426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452134 LIMIT 4 [ RunTime:0.080419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452134 ORDER BY `minOrder` ASC [ RunTime:0.129476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452134 ORDER BY `unit` DESC [ RunTime:0.103832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452134 LIMIT 2 [ RunTime:0.021040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452134 ORDER BY `minOrder` ASC [ RunTime:0.012346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452133 LIMIT 4 [ RunTime:0.036440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452133 ORDER BY `minOrder` ASC [ RunTime:0.051360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452133 ORDER BY `unit` DESC [ RunTime:0.058005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452133 LIMIT 2 [ RunTime:0.025146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452133 ORDER BY `minOrder` ASC [ RunTime:0.028087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452132 LIMIT 4 [ RunTime:0.035443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452132 ORDER BY `minOrder` ASC [ RunTime:0.025931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452132 ORDER BY `unit` DESC [ RunTime:0.045237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452132 LIMIT 2 [ RunTime:0.011135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452132 ORDER BY `minOrder` ASC [ RunTime:0.082345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452131 LIMIT 4 [ RunTime:0.044525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452131 ORDER BY `minOrder` ASC [ RunTime:0.010411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452131 ORDER BY `unit` DESC [ RunTime:0.022182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452131 LIMIT 2 [ RunTime:0.064953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452131 ORDER BY `minOrder` ASC [ RunTime:0.059046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452130 LIMIT 4 [ RunTime:0.034588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452130 ORDER BY `minOrder` ASC [ RunTime:0.042912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452130 ORDER BY `unit` DESC [ RunTime:0.029494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452130 LIMIT 2 [ RunTime:0.020605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452130 ORDER BY `minOrder` ASC [ RunTime:0.021028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452129 LIMIT 4 [ RunTime:0.044180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452129 ORDER BY `minOrder` ASC [ RunTime:0.106956s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452129 ORDER BY `unit` DESC [ RunTime:0.024024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452129 LIMIT 2 [ RunTime:0.012504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452129 ORDER BY `minOrder` ASC [ RunTime:0.045397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452128 LIMIT 4 [ RunTime:0.024053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452128 ORDER BY `minOrder` ASC [ RunTime:0.009305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452128 ORDER BY `unit` DESC [ RunTime:0.014771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452128 LIMIT 2 [ RunTime:0.029016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452128 ORDER BY `minOrder` ASC [ RunTime:0.030243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452127 LIMIT 4 [ RunTime:0.028504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452127 ORDER BY `minOrder` ASC [ RunTime:0.043127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452127 ORDER BY `unit` DESC [ RunTime:0.082828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452127 LIMIT 2 [ RunTime:0.061233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452127 ORDER BY `minOrder` ASC [ RunTime:0.046299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452126 LIMIT 4 [ RunTime:0.089088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452126 ORDER BY `minOrder` ASC [ RunTime:0.048965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452126 ORDER BY `unit` DESC [ RunTime:0.027199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452126 LIMIT 2 [ RunTime:0.108986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452126 ORDER BY `minOrder` ASC [ RunTime:0.049713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452125 LIMIT 4 [ RunTime:0.047772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452125 ORDER BY `minOrder` ASC [ RunTime:0.045467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452125 ORDER BY `unit` DESC [ RunTime:0.101166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452125 LIMIT 2 [ RunTime:0.113046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452125 ORDER BY `minOrder` ASC [ RunTime:0.071441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452124 LIMIT 4 [ RunTime:0.042800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452124 ORDER BY `minOrder` ASC [ RunTime:0.044332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452124 ORDER BY `unit` DESC [ RunTime:0.084455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452124 LIMIT 2 [ RunTime:0.050523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452124 ORDER BY `minOrder` ASC [ RunTime:0.039439s ]
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.162723s ]