SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001781s ]
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=100&srecordnum=10000' [ RunTime:0.002530s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001481s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001236s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002751s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000369s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002495s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005406s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002040s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.004646s ]
UPDATE `stock_search` SET `count` = 1992 , `updatetime` = '2026-06-12 15:11:19' WHERE `partno` = '228' [ RunTime:0.000522s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002418s ]
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 `isDisplay` = 1 AND ( `partno` LIKE '228%' OR `brand` LIKE '228%' ) AND `s`.`status` <> '2' ) LIMIT 1980,20 [ RunTime:0.060163s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449257 LIMIT 4 [ RunTime:0.012728s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449257 ORDER BY `minOrder` ASC [ RunTime:0.005560s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.010563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12449257 ORDER BY `unit` DESC [ RunTime:0.002609s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12449257 LIMIT 2 [ RunTime:0.000533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449257 ORDER BY `minOrder` ASC [ RunTime:0.003975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449258 LIMIT 4 [ RunTime:0.006464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449258 ORDER BY `minOrder` ASC [ RunTime:0.012024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12449258 ORDER BY `unit` DESC [ RunTime:0.003066s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12449258 LIMIT 2 [ RunTime:0.005652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449258 ORDER BY `minOrder` ASC [ RunTime:0.004467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449259 LIMIT 4 [ RunTime:0.000738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449259 ORDER BY `minOrder` ASC [ RunTime:0.002252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12449259 ORDER BY `unit` DESC [ RunTime:0.006315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12449259 LIMIT 2 [ RunTime:0.005705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449259 ORDER BY `minOrder` ASC [ RunTime:0.002567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449260 LIMIT 4 [ RunTime:0.001063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449260 ORDER BY `minOrder` ASC [ RunTime:0.002184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12449260 ORDER BY `unit` DESC [ RunTime:0.012489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12449260 LIMIT 2 [ RunTime:0.015928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449260 ORDER BY `minOrder` ASC [ RunTime:0.005644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449261 LIMIT 4 [ RunTime:0.002854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449261 ORDER BY `minOrder` ASC [ RunTime:0.006490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12449261 ORDER BY `unit` DESC [ RunTime:0.012753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12449261 LIMIT 2 [ RunTime:0.012693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449261 ORDER BY `minOrder` ASC [ RunTime:0.015323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449262 LIMIT 4 [ RunTime:0.007281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449262 ORDER BY `minOrder` ASC [ RunTime:0.009172s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12449262 ORDER BY `unit` DESC [ RunTime:0.016583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12449262 LIMIT 2 [ RunTime:0.010815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449262 ORDER BY `minOrder` ASC [ RunTime:0.036071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449263 LIMIT 4 [ RunTime:0.008292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449263 ORDER BY `minOrder` ASC [ RunTime:0.004155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12449263 ORDER BY `unit` DESC [ RunTime:0.009357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12449263 LIMIT 2 [ RunTime:0.015778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449263 ORDER BY `minOrder` ASC [ RunTime:0.003725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449264 LIMIT 4 [ RunTime:0.008893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449264 ORDER BY `minOrder` ASC [ RunTime:0.001188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12449264 ORDER BY `unit` DESC [ RunTime:0.006369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12449264 LIMIT 2 [ RunTime:0.004384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449264 ORDER BY `minOrder` ASC [ RunTime:0.007632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449265 LIMIT 4 [ RunTime:0.003310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449265 ORDER BY `minOrder` ASC [ RunTime:0.021139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12449265 ORDER BY `unit` DESC [ RunTime:0.010889s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12449265 LIMIT 2 [ RunTime:0.033144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449265 ORDER BY `minOrder` ASC [ RunTime:0.006641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449266 LIMIT 4 [ RunTime:0.005082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449266 ORDER BY `minOrder` ASC [ RunTime:0.005475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12449266 ORDER BY `unit` DESC [ RunTime:0.002818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12449266 LIMIT 2 [ RunTime:0.003500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449266 ORDER BY `minOrder` ASC [ RunTime:0.008275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449267 LIMIT 4 [ RunTime:0.002877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449267 ORDER BY `minOrder` ASC [ RunTime:0.007666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12449267 ORDER BY `unit` DESC [ RunTime:0.010272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12449267 LIMIT 2 [ RunTime:0.002173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449267 ORDER BY `minOrder` ASC [ RunTime:0.001133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449268 LIMIT 4 [ RunTime:0.000649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449268 ORDER BY `minOrder` ASC [ RunTime:0.003931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12449268 ORDER BY `unit` DESC [ RunTime:0.005459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12449268 LIMIT 2 [ RunTime:0.002788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449268 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449269 LIMIT 4 [ RunTime:0.005815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449269 ORDER BY `minOrder` ASC [ RunTime:0.008823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12449269 ORDER BY `unit` DESC [ RunTime:0.012987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12449269 LIMIT 2 [ RunTime:0.016496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449269 ORDER BY `minOrder` ASC [ RunTime:0.000857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449270 LIMIT 4 [ RunTime:0.018373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449270 ORDER BY `minOrder` ASC [ RunTime:0.005036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12449270 ORDER BY `unit` DESC [ RunTime:0.016892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12449270 LIMIT 2 [ RunTime:0.008408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449270 ORDER BY `minOrder` ASC [ RunTime:0.011694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449271 LIMIT 4 [ RunTime:0.006516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449271 ORDER BY `minOrder` ASC [ RunTime:0.003656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12449271 ORDER BY `unit` DESC [ RunTime:0.010031s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12449271 LIMIT 2 [ RunTime:0.006012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449271 ORDER BY `minOrder` ASC [ RunTime:0.002183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449272 LIMIT 4 [ RunTime:0.021193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449272 ORDER BY `minOrder` ASC [ RunTime:0.003392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12449272 ORDER BY `unit` DESC [ RunTime:0.002922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12449272 LIMIT 2 [ RunTime:0.006823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449272 ORDER BY `minOrder` ASC [ RunTime:0.002816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449273 LIMIT 4 [ RunTime:0.007114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449273 ORDER BY `minOrder` ASC [ RunTime:0.007508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12449273 ORDER BY `unit` DESC [ RunTime:0.007388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12449273 LIMIT 2 [ RunTime:0.018328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449273 ORDER BY `minOrder` ASC [ RunTime:0.028828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449274 LIMIT 4 [ RunTime:0.009372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449274 ORDER BY `minOrder` ASC [ RunTime:0.024828s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12449274 ORDER BY `unit` DESC [ RunTime:0.012639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12449274 LIMIT 2 [ RunTime:0.010567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449274 ORDER BY `minOrder` ASC [ RunTime:0.009977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449275 LIMIT 4 [ RunTime:0.016274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449275 ORDER BY `minOrder` ASC [ RunTime:0.034219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12449275 ORDER BY `unit` DESC [ RunTime:0.018178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12449275 LIMIT 2 [ RunTime:0.016331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449275 ORDER BY `minOrder` ASC [ RunTime:0.015357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449276 LIMIT 4 [ RunTime:0.009709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449276 ORDER BY `minOrder` ASC [ RunTime:0.011290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12449276 ORDER BY `unit` DESC [ RunTime:0.007388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12449276 LIMIT 2 [ RunTime:0.009738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12449276 ORDER BY `minOrder` ASC [ RunTime:0.002007s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '228%' OR `brand` LIKE '228%' ) AND `s`.`status` <> '2' ) AND ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '228%' OR `brand` LIKE '228%' ) AND `s`.`status` <> '2' ) LIMIT 1980,20 [ RunTime:0.128407s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '228%' OR `brand` LIKE '228%' ) AND `s`.`status` <> '2' ) ) tmp GROUP BY `brand` [ RunTime:0.091452s ]
SELECT DISTINCT `categoryid` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '228%' OR `brand` LIKE '228%' ) AND `s`.`status` <> '2' ) AND `categoryid` > 0 [ RunTime:0.069283s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 643 [ RunTime:0.009103s ]