SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002723s ]
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=433&srecordnum=10000' [ RunTime:0.001893s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001728s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000538s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001122s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000232s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001380s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000249s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001025s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.000508s ]
UPDATE `stock_search` SET `count` = 1980 , `updatetime` = '2026-06-12 13:16:16' WHERE `partno` = '228' [ RunTime:0.002986s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000185s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.001331s ]
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.001774s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001368s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.197059s ]
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 8640,20 [ RunTime:0.169189s ]
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 ('16433226','16414130','16355852','16148277','16147183','15600346','15591029','15590657','15589478','15589266','15587569','15581054','15549024','15549023','15547261','15454861','15454736','15454637','15443667','15443666') ORDER BY FIELD(s.id, 16433226,16414130,16355852,16148277,16147183,15600346,15591029,15590657,15589478,15589266,15587569,15581054,15549024,15549023,15547261,15454861,15454736,15454637,15443667,15443666) [ RunTime:0.011346s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16433226 LIMIT 4 [ RunTime:0.010138s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16433226 ORDER BY `minOrder` ASC [ RunTime:0.006818s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16433226 ORDER BY `unit` DESC [ RunTime:0.006200s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16433226 LIMIT 2 [ RunTime:0.007834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16433226 ORDER BY `minOrder` ASC [ RunTime:0.002938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16414130 LIMIT 4 [ RunTime:0.008755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16414130 ORDER BY `minOrder` ASC [ RunTime:0.007442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16414130 ORDER BY `unit` DESC [ RunTime:0.013468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16414130 LIMIT 2 [ RunTime:0.005621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16414130 ORDER BY `minOrder` ASC [ RunTime:0.006637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16355852 LIMIT 4 [ RunTime:0.002769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16355852 ORDER BY `minOrder` ASC [ RunTime:0.002746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16355852 ORDER BY `unit` DESC [ RunTime:0.000663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16355852 LIMIT 2 [ RunTime:0.000633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16355852 ORDER BY `minOrder` ASC [ RunTime:0.001618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16148277 LIMIT 4 [ RunTime:0.005633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16148277 ORDER BY `minOrder` ASC [ RunTime:0.004410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16148277 ORDER BY `unit` DESC [ RunTime:0.002907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16148277 LIMIT 2 [ RunTime:0.002013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16148277 ORDER BY `minOrder` ASC [ RunTime:0.001858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16147183 LIMIT 4 [ RunTime:0.005944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16147183 ORDER BY `minOrder` ASC [ RunTime:0.008086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16147183 ORDER BY `unit` DESC [ RunTime:0.006804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16147183 LIMIT 2 [ RunTime:0.006985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16147183 ORDER BY `minOrder` ASC [ RunTime:0.001880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15600346 LIMIT 4 [ RunTime:0.008247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15600346 ORDER BY `minOrder` ASC [ RunTime:0.004925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15600346 ORDER BY `unit` DESC [ RunTime:0.007517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15600346 LIMIT 2 [ RunTime:0.006898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15600346 ORDER BY `minOrder` ASC [ RunTime:0.003905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15591029 LIMIT 4 [ RunTime:0.006079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15591029 ORDER BY `minOrder` ASC [ RunTime:0.005521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15591029 ORDER BY `unit` DESC [ RunTime:0.025158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15591029 LIMIT 2 [ RunTime:0.007856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15591029 ORDER BY `minOrder` ASC [ RunTime:0.004008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15590657 LIMIT 4 [ RunTime:0.015256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15590657 ORDER BY `minOrder` ASC [ RunTime:0.007323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15590657 ORDER BY `unit` DESC [ RunTime:0.009744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15590657 LIMIT 2 [ RunTime:0.010852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15590657 ORDER BY `minOrder` ASC [ RunTime:0.003211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15589478 LIMIT 4 [ RunTime:0.011852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15589478 ORDER BY `minOrder` ASC [ RunTime:0.008669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15589478 ORDER BY `unit` DESC [ RunTime:0.002376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15589478 LIMIT 2 [ RunTime:0.010217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15589478 ORDER BY `minOrder` ASC [ RunTime:0.002176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15589266 LIMIT 4 [ RunTime:0.002653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15589266 ORDER BY `minOrder` ASC [ RunTime:0.002037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15589266 ORDER BY `unit` DESC [ RunTime:0.004508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15589266 LIMIT 2 [ RunTime:0.004704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15589266 ORDER BY `minOrder` ASC [ RunTime:0.013008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15587569 LIMIT 4 [ RunTime:0.007332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15587569 ORDER BY `minOrder` ASC [ RunTime:0.011260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15587569 ORDER BY `unit` DESC [ RunTime:0.000666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15587569 LIMIT 2 [ RunTime:0.007648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15587569 ORDER BY `minOrder` ASC [ RunTime:0.000370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15581054 LIMIT 4 [ RunTime:0.004837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15581054 ORDER BY `minOrder` ASC [ RunTime:0.008399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15581054 ORDER BY `unit` DESC [ RunTime:0.002646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15581054 LIMIT 2 [ RunTime:0.012881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15581054 ORDER BY `minOrder` ASC [ RunTime:0.004690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15549024 LIMIT 4 [ RunTime:0.007261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15549024 ORDER BY `minOrder` ASC [ RunTime:0.001577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15549024 ORDER BY `unit` DESC [ RunTime:0.002969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15549024 LIMIT 2 [ RunTime:0.001639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15549024 ORDER BY `minOrder` ASC [ RunTime:0.000948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15549023 LIMIT 4 [ RunTime:0.005660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15549023 ORDER BY `minOrder` ASC [ RunTime:0.005800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15549023 ORDER BY `unit` DESC [ RunTime:0.002208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15549023 LIMIT 2 [ RunTime:0.005397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15549023 ORDER BY `minOrder` ASC [ RunTime:0.002377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15547261 LIMIT 4 [ RunTime:0.004591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15547261 ORDER BY `minOrder` ASC [ RunTime:0.006468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15547261 ORDER BY `unit` DESC [ RunTime:0.022118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15547261 LIMIT 2 [ RunTime:0.006327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15547261 ORDER BY `minOrder` ASC [ RunTime:0.006897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15454861 LIMIT 4 [ RunTime:0.004709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15454861 ORDER BY `minOrder` ASC [ RunTime:0.016606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15454861 ORDER BY `unit` DESC [ RunTime:0.029068s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15454861 LIMIT 2 [ RunTime:0.015302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15454861 ORDER BY `minOrder` ASC [ RunTime:0.003618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15454736 LIMIT 4 [ RunTime:0.007682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15454736 ORDER BY `minOrder` ASC [ RunTime:0.010231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15454736 ORDER BY `unit` DESC [ RunTime:0.003643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15454736 LIMIT 2 [ RunTime:0.007096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15454736 ORDER BY `minOrder` ASC [ RunTime:0.002038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15454637 LIMIT 4 [ RunTime:0.002103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15454637 ORDER BY `minOrder` ASC [ RunTime:0.006027s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15454637 ORDER BY `unit` DESC [ RunTime:0.000937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15454637 LIMIT 2 [ RunTime:0.000631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15454637 ORDER BY `minOrder` ASC [ RunTime:0.000541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15443667 LIMIT 4 [ RunTime:0.006041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15443667 ORDER BY `minOrder` ASC [ RunTime:0.006329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15443667 ORDER BY `unit` DESC [ RunTime:0.000703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15443667 LIMIT 2 [ RunTime:0.005673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15443667 ORDER BY `minOrder` ASC [ RunTime:0.003784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15443666 LIMIT 4 [ RunTime:0.002821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15443666 ORDER BY `minOrder` ASC [ RunTime:0.006121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15443666 ORDER BY `unit` DESC [ RunTime:0.021153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15443666 LIMIT 2 [ RunTime:0.001990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15443666 ORDER BY `minOrder` ASC [ RunTime:0.014651s ]
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.001218s ]