SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001770s ]
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=462&srecordnum=10000' [ RunTime:0.001759s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001087s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000705s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003651s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000773s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002580s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003783s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002065s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.002525s ]
UPDATE `stock_search` SET `count` = 1184 , `updatetime` = '2026-06-12 02:28:43' WHERE `partno` = '228' [ RunTime:0.006379s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.002614s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.003392s ]
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.004006s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002778s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.240380s ]
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 9220,20 [ RunTime:0.150621s ]
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 ('12452163','12452162','12452161','12452160','12452159','12452158','12452157','12452156','12452155','12452154','12452153','12452152','12452151','12452150','12452149','12452148','12452147','12452146','12452145','12452144') ORDER BY FIELD(s.id, 12452163,12452162,12452161,12452160,12452159,12452158,12452157,12452156,12452155,12452154,12452153,12452152,12452151,12452150,12452149,12452148,12452147,12452146,12452145,12452144) [ RunTime:0.024527s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452163 LIMIT 4 [ RunTime:0.012634s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452163 ORDER BY `minOrder` ASC [ RunTime:0.011828s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452163 ORDER BY `unit` DESC [ RunTime:0.000601s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452163 LIMIT 2 [ RunTime:0.007494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452163 ORDER BY `minOrder` ASC [ RunTime:0.004610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452162 LIMIT 4 [ RunTime:0.021482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452162 ORDER BY `minOrder` ASC [ RunTime:0.030605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452162 ORDER BY `unit` DESC [ RunTime:0.033645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452162 LIMIT 2 [ RunTime:0.040032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452162 ORDER BY `minOrder` ASC [ RunTime:0.006709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452161 LIMIT 4 [ RunTime:0.045296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452161 ORDER BY `minOrder` ASC [ RunTime:0.088251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452161 ORDER BY `unit` DESC [ RunTime:0.042109s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452161 LIMIT 2 [ RunTime:0.030070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452161 ORDER BY `minOrder` ASC [ RunTime:0.091440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452160 LIMIT 4 [ RunTime:0.084314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452160 ORDER BY `minOrder` ASC [ RunTime:0.080056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452160 ORDER BY `unit` DESC [ RunTime:0.028960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452160 LIMIT 2 [ RunTime:0.091577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452160 ORDER BY `minOrder` ASC [ RunTime:0.050082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452159 LIMIT 4 [ RunTime:0.015986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452159 ORDER BY `minOrder` ASC [ RunTime:0.083786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452159 ORDER BY `unit` DESC [ RunTime:0.020242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452159 LIMIT 2 [ RunTime:0.059118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452159 ORDER BY `minOrder` ASC [ RunTime:0.035375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452158 LIMIT 4 [ RunTime:0.057016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452158 ORDER BY `minOrder` ASC [ RunTime:0.027826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452158 ORDER BY `unit` DESC [ RunTime:0.035021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452158 LIMIT 2 [ RunTime:0.028955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452158 ORDER BY `minOrder` ASC [ RunTime:0.041563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452157 LIMIT 4 [ RunTime:0.030293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452157 ORDER BY `minOrder` ASC [ RunTime:0.032226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452157 ORDER BY `unit` DESC [ RunTime:0.016498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452157 LIMIT 2 [ RunTime:0.051044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452157 ORDER BY `minOrder` ASC [ RunTime:0.023510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452156 LIMIT 4 [ RunTime:0.081955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452156 ORDER BY `minOrder` ASC [ RunTime:0.036771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452156 ORDER BY `unit` DESC [ RunTime:0.013656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452156 LIMIT 2 [ RunTime:0.037993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452156 ORDER BY `minOrder` ASC [ RunTime:0.035682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452155 LIMIT 4 [ RunTime:0.040991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452155 ORDER BY `minOrder` ASC [ RunTime:0.046813s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452155 ORDER BY `unit` DESC [ RunTime:0.028876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452155 LIMIT 2 [ RunTime:0.065531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452155 ORDER BY `minOrder` ASC [ RunTime:0.091217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452154 LIMIT 4 [ RunTime:0.054716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452154 ORDER BY `minOrder` ASC [ RunTime:0.041749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452154 ORDER BY `unit` DESC [ RunTime:0.019925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452154 LIMIT 2 [ RunTime:0.071899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452154 ORDER BY `minOrder` ASC [ RunTime:0.035926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452153 LIMIT 4 [ RunTime:0.069408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452153 ORDER BY `minOrder` ASC [ RunTime:0.075881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452153 ORDER BY `unit` DESC [ RunTime:0.036782s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452153 LIMIT 2 [ RunTime:0.053515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452153 ORDER BY `minOrder` ASC [ RunTime:0.026648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452152 LIMIT 4 [ RunTime:0.011166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452152 ORDER BY `minOrder` ASC [ RunTime:0.065745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452152 ORDER BY `unit` DESC [ RunTime:0.048841s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452152 LIMIT 2 [ RunTime:0.044043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452152 ORDER BY `minOrder` ASC [ RunTime:0.000611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452151 LIMIT 4 [ RunTime:0.087164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452151 ORDER BY `minOrder` ASC [ RunTime:0.066523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452151 ORDER BY `unit` DESC [ RunTime:0.061495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452151 LIMIT 2 [ RunTime:0.028573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452151 ORDER BY `minOrder` ASC [ RunTime:0.030813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452150 LIMIT 4 [ RunTime:0.047392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452150 ORDER BY `minOrder` ASC [ RunTime:0.052023s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452150 ORDER BY `unit` DESC [ RunTime:0.014419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452150 LIMIT 2 [ RunTime:0.052526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452150 ORDER BY `minOrder` ASC [ RunTime:0.011459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452149 LIMIT 4 [ RunTime:0.019876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452149 ORDER BY `minOrder` ASC [ RunTime:0.013238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452149 ORDER BY `unit` DESC [ RunTime:0.079017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452149 LIMIT 2 [ RunTime:0.044765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452149 ORDER BY `minOrder` ASC [ RunTime:0.010062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452148 LIMIT 4 [ RunTime:0.037687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452148 ORDER BY `minOrder` ASC [ RunTime:0.025834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452148 ORDER BY `unit` DESC [ RunTime:0.083338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452148 LIMIT 2 [ RunTime:0.044507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452148 ORDER BY `minOrder` ASC [ RunTime:0.015255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452147 LIMIT 4 [ RunTime:0.053895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452147 ORDER BY `minOrder` ASC [ RunTime:0.070929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452147 ORDER BY `unit` DESC [ RunTime:0.039518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452147 LIMIT 2 [ RunTime:0.078969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452147 ORDER BY `minOrder` ASC [ RunTime:0.025503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452146 LIMIT 4 [ RunTime:0.086264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452146 ORDER BY `minOrder` ASC [ RunTime:0.081718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452146 ORDER BY `unit` DESC [ RunTime:0.011938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452146 LIMIT 2 [ RunTime:0.162328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452146 ORDER BY `minOrder` ASC [ RunTime:0.028511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452145 LIMIT 4 [ RunTime:0.055554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452145 ORDER BY `minOrder` ASC [ RunTime:0.035548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452145 ORDER BY `unit` DESC [ RunTime:0.018118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452145 LIMIT 2 [ RunTime:0.079442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452145 ORDER BY `minOrder` ASC [ RunTime:0.042601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12452144 LIMIT 4 [ RunTime:0.052860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452144 ORDER BY `minOrder` ASC [ RunTime:0.056127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12452144 ORDER BY `unit` DESC [ RunTime:0.031512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12452144 LIMIT 2 [ RunTime:0.030622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12452144 ORDER BY `minOrder` ASC [ RunTime:0.019707s ]
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.100518s ]