SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001357s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.83' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://ic118.com/stock&keyword=210&page=288&srecordnum=7544' [ RunTime:0.002737s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001810s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000419s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001562s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.000965s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001202s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000485s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001223s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000706s ]
UPDATE `stock_search` SET `count` = 5465 , `updatetime` = '2026-06-08 22:54:16' WHERE `partno` = '210' [ RunTime:0.001591s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000220s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000213s ]
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.000369s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001833s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.104170s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '210%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 5740,20 [ RunTime:0.075650s ]
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` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('18713005','18712220','18712108','18712107','18712076','18706207','18703147','18701781','18701552','18701147','18701146','18701063','18700972','18700791','18700738','18700736','18700684','18700655','18700649','18700623') ORDER BY FIELD(s.id, 18713005,18712220,18712108,18712107,18712076,18706207,18703147,18701781,18701552,18701147,18701146,18701063,18700972,18700791,18700738,18700736,18700684,18700655,18700649,18700623) [ RunTime:0.024351s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18713005 LIMIT 4 [ RunTime:0.003915s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18713005 ORDER BY `minOrder` ASC [ RunTime:0.014918s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18713005 ORDER BY `unit` DESC [ RunTime:0.008337s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18713005 LIMIT 2 [ RunTime:0.010643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18713005 ORDER BY `minOrder` ASC [ RunTime:0.000547s ]
select * from pdf where partno='21040' and brandshort='3M' limit 1 [ RunTime:0.025186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18712220 LIMIT 4 [ RunTime:0.014368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18712220 ORDER BY `minOrder` ASC [ RunTime:0.014386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18712220 ORDER BY `unit` DESC [ RunTime:0.012107s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18712220 LIMIT 2 [ RunTime:0.024954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18712220 ORDER BY `minOrder` ASC [ RunTime:0.011851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18712108 LIMIT 4 [ RunTime:0.006208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18712108 ORDER BY `minOrder` ASC [ RunTime:0.008963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18712108 ORDER BY `unit` DESC [ RunTime:0.009246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18712108 LIMIT 2 [ RunTime:0.003472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18712108 ORDER BY `minOrder` ASC [ RunTime:0.003857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18712107 LIMIT 4 [ RunTime:0.007612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18712107 ORDER BY `minOrder` ASC [ RunTime:0.016802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18712107 ORDER BY `unit` DESC [ RunTime:0.008995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18712107 LIMIT 2 [ RunTime:0.030587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18712107 ORDER BY `minOrder` ASC [ RunTime:0.004101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18712076 LIMIT 4 [ RunTime:0.016422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18712076 ORDER BY `minOrder` ASC [ RunTime:0.017013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18712076 ORDER BY `unit` DESC [ RunTime:0.013212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18712076 LIMIT 2 [ RunTime:0.033431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18712076 ORDER BY `minOrder` ASC [ RunTime:0.007182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18706207 LIMIT 4 [ RunTime:0.019680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18706207 ORDER BY `minOrder` ASC [ RunTime:0.029589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18706207 ORDER BY `unit` DESC [ RunTime:0.047214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18706207 LIMIT 2 [ RunTime:0.019751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18706207 ORDER BY `minOrder` ASC [ RunTime:0.008034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18703147 LIMIT 4 [ RunTime:0.028256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18703147 ORDER BY `minOrder` ASC [ RunTime:0.031203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18703147 ORDER BY `unit` DESC [ RunTime:0.028698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18703147 LIMIT 2 [ RunTime:0.010943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18703147 ORDER BY `minOrder` ASC [ RunTime:0.019343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18701781 LIMIT 4 [ RunTime:0.018758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18701781 ORDER BY `minOrder` ASC [ RunTime:0.017011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18701781 ORDER BY `unit` DESC [ RunTime:0.012280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18701781 LIMIT 2 [ RunTime:0.002234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18701781 ORDER BY `minOrder` ASC [ RunTime:0.012602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18701552 LIMIT 4 [ RunTime:0.016810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18701552 ORDER BY `minOrder` ASC [ RunTime:0.009873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18701552 ORDER BY `unit` DESC [ RunTime:0.023601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18701552 LIMIT 2 [ RunTime:0.028366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18701552 ORDER BY `minOrder` ASC [ RunTime:0.028244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18701147 LIMIT 4 [ RunTime:0.025726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18701147 ORDER BY `minOrder` ASC [ RunTime:0.011659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18701147 ORDER BY `unit` DESC [ RunTime:0.007496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18701147 LIMIT 2 [ RunTime:0.012368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18701147 ORDER BY `minOrder` ASC [ RunTime:0.012838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18701146 LIMIT 4 [ RunTime:0.011800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18701146 ORDER BY `minOrder` ASC [ RunTime:0.025977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18701146 ORDER BY `unit` DESC [ RunTime:0.020109s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18701146 LIMIT 2 [ RunTime:0.021301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18701146 ORDER BY `minOrder` ASC [ RunTime:0.006385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18701063 LIMIT 4 [ RunTime:0.007134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18701063 ORDER BY `minOrder` ASC [ RunTime:0.019250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18701063 ORDER BY `unit` DESC [ RunTime:0.021928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18701063 LIMIT 2 [ RunTime:0.013472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18701063 ORDER BY `minOrder` ASC [ RunTime:0.003439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18700972 LIMIT 4 [ RunTime:0.009815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700972 ORDER BY `minOrder` ASC [ RunTime:0.022936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18700972 ORDER BY `unit` DESC [ RunTime:0.015973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18700972 LIMIT 2 [ RunTime:0.012678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700972 ORDER BY `minOrder` ASC [ RunTime:0.005410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18700791 LIMIT 4 [ RunTime:0.012916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700791 ORDER BY `minOrder` ASC [ RunTime:0.008951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18700791 ORDER BY `unit` DESC [ RunTime:0.022861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18700791 LIMIT 2 [ RunTime:0.031113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700791 ORDER BY `minOrder` ASC [ RunTime:0.001515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18700738 LIMIT 4 [ RunTime:0.004720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700738 ORDER BY `minOrder` ASC [ RunTime:0.011892s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18700738 ORDER BY `unit` DESC [ RunTime:0.014452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18700738 LIMIT 2 [ RunTime:0.010264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700738 ORDER BY `minOrder` ASC [ RunTime:0.012096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18700736 LIMIT 4 [ RunTime:0.012002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700736 ORDER BY `minOrder` ASC [ RunTime:0.011791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18700736 ORDER BY `unit` DESC [ RunTime:0.065708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18700736 LIMIT 2 [ RunTime:0.055210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700736 ORDER BY `minOrder` ASC [ RunTime:0.009267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18700684 LIMIT 4 [ RunTime:0.014345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700684 ORDER BY `minOrder` ASC [ RunTime:0.027033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18700684 ORDER BY `unit` DESC [ RunTime:0.014158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18700684 LIMIT 2 [ RunTime:0.016285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700684 ORDER BY `minOrder` ASC [ RunTime:0.015752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18700655 LIMIT 4 [ RunTime:0.009930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700655 ORDER BY `minOrder` ASC [ RunTime:0.026534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18700655 ORDER BY `unit` DESC [ RunTime:0.015878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18700655 LIMIT 2 [ RunTime:0.016894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700655 ORDER BY `minOrder` ASC [ RunTime:0.020920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18700649 LIMIT 4 [ RunTime:0.012354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700649 ORDER BY `minOrder` ASC [ RunTime:0.015716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18700649 ORDER BY `unit` DESC [ RunTime:0.013976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18700649 LIMIT 2 [ RunTime:0.013204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700649 ORDER BY `minOrder` ASC [ RunTime:0.058130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18700623 LIMIT 4 [ RunTime:0.015866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700623 ORDER BY `minOrder` ASC [ RunTime:0.012342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18700623 ORDER BY `unit` DESC [ RunTime:0.009252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18700623 LIMIT 2 [ RunTime:0.012293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700623 ORDER BY `minOrder` ASC [ RunTime:0.019835s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.006900s ]