SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002448s ]
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=436&srecordnum=10000' [ RunTime:0.002980s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002199s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000602s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002421s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.003613s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002162s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000343s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003056s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.004523s ]
UPDATE `stock_search` SET `count` = 1966 , `updatetime` = '2026-06-12 10:22:30' WHERE `partno` = '228' [ RunTime:0.005187s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000286s ]
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.001477s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002864s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.289392s ]
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 8700,20 [ RunTime:0.211833s ]
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 ('15430085','15430084','15430083','15430082','15430081','15430080','15430079','15430078','15430077','15430076','15430075','15430074','15430073','15430072','15430071','15430070','15430069','15430068','15430067','15430066') ORDER BY FIELD(s.id, 15430085,15430084,15430083,15430082,15430081,15430080,15430079,15430078,15430077,15430076,15430075,15430074,15430073,15430072,15430071,15430070,15430069,15430068,15430067,15430066) [ RunTime:0.060515s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430085 LIMIT 4 [ RunTime:0.034757s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430085 ORDER BY `minOrder` ASC [ RunTime:0.013971s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15430085 ORDER BY `unit` DESC [ RunTime:0.011140s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15430085 LIMIT 2 [ RunTime:0.000799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430085 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430084 LIMIT 4 [ RunTime:0.025776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430084 ORDER BY `minOrder` ASC [ RunTime:0.022092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15430084 ORDER BY `unit` DESC [ RunTime:0.020196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15430084 LIMIT 2 [ RunTime:0.046847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430084 ORDER BY `minOrder` ASC [ RunTime:0.006342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430083 LIMIT 4 [ RunTime:0.003323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430083 ORDER BY `minOrder` ASC [ RunTime:0.028194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15430083 ORDER BY `unit` DESC [ RunTime:0.012418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15430083 LIMIT 2 [ RunTime:0.022701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430083 ORDER BY `minOrder` ASC [ RunTime:0.016094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430082 LIMIT 4 [ RunTime:0.021029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430082 ORDER BY `minOrder` ASC [ RunTime:0.027380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15430082 ORDER BY `unit` DESC [ RunTime:0.008647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15430082 LIMIT 2 [ RunTime:0.011389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430082 ORDER BY `minOrder` ASC [ RunTime:0.007159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430081 LIMIT 4 [ RunTime:0.024165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430081 ORDER BY `minOrder` ASC [ RunTime:0.031489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15430081 ORDER BY `unit` DESC [ RunTime:0.005506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15430081 LIMIT 2 [ RunTime:0.025207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430081 ORDER BY `minOrder` ASC [ RunTime:0.007784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430080 LIMIT 4 [ RunTime:0.014872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430080 ORDER BY `minOrder` ASC [ RunTime:0.009310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15430080 ORDER BY `unit` DESC [ RunTime:0.011043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15430080 LIMIT 2 [ RunTime:0.028128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430080 ORDER BY `minOrder` ASC [ RunTime:0.006059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430079 LIMIT 4 [ RunTime:0.010930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430079 ORDER BY `minOrder` ASC [ RunTime:0.030230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15430079 ORDER BY `unit` DESC [ RunTime:0.018791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15430079 LIMIT 2 [ RunTime:0.024168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430079 ORDER BY `minOrder` ASC [ RunTime:0.014898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430078 LIMIT 4 [ RunTime:0.011212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430078 ORDER BY `minOrder` ASC [ RunTime:0.014512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15430078 ORDER BY `unit` DESC [ RunTime:0.043404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15430078 LIMIT 2 [ RunTime:0.006106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430078 ORDER BY `minOrder` ASC [ RunTime:0.025073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430077 LIMIT 4 [ RunTime:0.011924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430077 ORDER BY `minOrder` ASC [ RunTime:0.040330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15430077 ORDER BY `unit` DESC [ RunTime:0.039476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15430077 LIMIT 2 [ RunTime:0.033542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430077 ORDER BY `minOrder` ASC [ RunTime:0.022196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430076 LIMIT 4 [ RunTime:0.009380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430076 ORDER BY `minOrder` ASC [ RunTime:0.019068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15430076 ORDER BY `unit` DESC [ RunTime:0.010314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15430076 LIMIT 2 [ RunTime:0.014209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430076 ORDER BY `minOrder` ASC [ RunTime:0.013604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430075 LIMIT 4 [ RunTime:0.003866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430075 ORDER BY `minOrder` ASC [ RunTime:0.023478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15430075 ORDER BY `unit` DESC [ RunTime:0.008381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15430075 LIMIT 2 [ RunTime:0.010151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430075 ORDER BY `minOrder` ASC [ RunTime:0.005241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430074 LIMIT 4 [ RunTime:0.008194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430074 ORDER BY `minOrder` ASC [ RunTime:0.017143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15430074 ORDER BY `unit` DESC [ RunTime:0.001800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15430074 LIMIT 2 [ RunTime:0.011150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430074 ORDER BY `minOrder` ASC [ RunTime:0.007906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430073 LIMIT 4 [ RunTime:0.002511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430073 ORDER BY `minOrder` ASC [ RunTime:0.013259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15430073 ORDER BY `unit` DESC [ RunTime:0.007129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15430073 LIMIT 2 [ RunTime:0.016248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430073 ORDER BY `minOrder` ASC [ RunTime:0.008989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430072 LIMIT 4 [ RunTime:0.016892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430072 ORDER BY `minOrder` ASC [ RunTime:0.003450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15430072 ORDER BY `unit` DESC [ RunTime:0.017298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15430072 LIMIT 2 [ RunTime:0.017682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430072 ORDER BY `minOrder` ASC [ RunTime:0.023323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430071 LIMIT 4 [ RunTime:0.008137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430071 ORDER BY `minOrder` ASC [ RunTime:0.002011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15430071 ORDER BY `unit` DESC [ RunTime:0.008950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15430071 LIMIT 2 [ RunTime:0.008175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430071 ORDER BY `minOrder` ASC [ RunTime:0.009991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430070 LIMIT 4 [ RunTime:0.020746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430070 ORDER BY `minOrder` ASC [ RunTime:0.014238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15430070 ORDER BY `unit` DESC [ RunTime:0.018836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15430070 LIMIT 2 [ RunTime:0.007449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430070 ORDER BY `minOrder` ASC [ RunTime:0.017784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430069 LIMIT 4 [ RunTime:0.009454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430069 ORDER BY `minOrder` ASC [ RunTime:0.005665s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15430069 ORDER BY `unit` DESC [ RunTime:0.016389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15430069 LIMIT 2 [ RunTime:0.012893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430069 ORDER BY `minOrder` ASC [ RunTime:0.002728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430068 LIMIT 4 [ RunTime:0.014973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430068 ORDER BY `minOrder` ASC [ RunTime:0.027259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15430068 ORDER BY `unit` DESC [ RunTime:0.024938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15430068 LIMIT 2 [ RunTime:0.016453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430068 ORDER BY `minOrder` ASC [ RunTime:0.012252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430067 LIMIT 4 [ RunTime:0.008230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430067 ORDER BY `minOrder` ASC [ RunTime:0.015910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15430067 ORDER BY `unit` DESC [ RunTime:0.013453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15430067 LIMIT 2 [ RunTime:0.000743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430067 ORDER BY `minOrder` ASC [ RunTime:0.008535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430066 LIMIT 4 [ RunTime:0.000676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430066 ORDER BY `minOrder` ASC [ RunTime:0.007673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15430066 ORDER BY `unit` DESC [ RunTime:0.012078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15430066 LIMIT 2 [ RunTime:0.006706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430066 ORDER BY `minOrder` ASC [ RunTime:0.012763s ]
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.152332s ]