SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001579s ]
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` = '' [ RunTime:0.007969s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001561s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.018651s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001963s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.004243s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001467s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.008290s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001247s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.010578s ]
UPDATE `stock_search` SET `count` = 4149 , `updatetime` = '2026-06-08 16:49:36' WHERE `partno` = '210' [ RunTime:0.001203s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000204s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000233s ]
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.000447s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001496s ]
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.127745s ]
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 5660,20 [ RunTime:0.132368s ]
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 ('18842921','18842920','18837299','18836737','18836312','18836297','18836226','18836204','18836183','18835451','18833544','18788282','18788170','18787910','18786962','18786924','18786923','18781661','18781660','18758453') ORDER BY FIELD(s.id, 18842921,18842920,18837299,18836737,18836312,18836297,18836226,18836204,18836183,18835451,18833544,18788282,18788170,18787910,18786962,18786924,18786923,18781661,18781660,18758453) [ RunTime:0.102745s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.011234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842921 LIMIT 4 [ RunTime:0.113100s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842921 ORDER BY `minOrder` ASC [ RunTime:0.042868s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18842921 ORDER BY `unit` DESC [ RunTime:0.046845s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.020204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18842921 LIMIT 2 [ RunTime:0.153640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842921 ORDER BY `minOrder` ASC [ RunTime:0.033784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842920 LIMIT 4 [ RunTime:0.158012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842920 ORDER BY `minOrder` ASC [ RunTime:0.023981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18842920 ORDER BY `unit` DESC [ RunTime:0.092469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18842920 LIMIT 2 [ RunTime:0.166125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842920 ORDER BY `minOrder` ASC [ RunTime:0.049099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837299 LIMIT 4 [ RunTime:0.100317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837299 ORDER BY `minOrder` ASC [ RunTime:0.055836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18837299 ORDER BY `unit` DESC [ RunTime:0.130444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18837299 LIMIT 2 [ RunTime:0.129450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837299 ORDER BY `minOrder` ASC [ RunTime:0.057184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18836737 LIMIT 4 [ RunTime:0.116401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836737 ORDER BY `minOrder` ASC [ RunTime:0.102162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18836737 ORDER BY `unit` DESC [ RunTime:0.065116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18836737 LIMIT 2 [ RunTime:0.057321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836737 ORDER BY `minOrder` ASC [ RunTime:0.059145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18836312 LIMIT 4 [ RunTime:0.140076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836312 ORDER BY `minOrder` ASC [ RunTime:0.109101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18836312 ORDER BY `unit` DESC [ RunTime:0.063865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18836312 LIMIT 2 [ RunTime:0.072153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836312 ORDER BY `minOrder` ASC [ RunTime:0.050775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18836297 LIMIT 4 [ RunTime:0.027430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836297 ORDER BY `minOrder` ASC [ RunTime:0.069758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18836297 ORDER BY `unit` DESC [ RunTime:0.065540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18836297 LIMIT 2 [ RunTime:0.007346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836297 ORDER BY `minOrder` ASC [ RunTime:0.035038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18836226 LIMIT 4 [ RunTime:0.046690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836226 ORDER BY `minOrder` ASC [ RunTime:0.026531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18836226 ORDER BY `unit` DESC [ RunTime:0.114370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18836226 LIMIT 2 [ RunTime:0.106858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836226 ORDER BY `minOrder` ASC [ RunTime:0.120946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18836204 LIMIT 4 [ RunTime:0.031724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836204 ORDER BY `minOrder` ASC [ RunTime:0.017432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18836204 ORDER BY `unit` DESC [ RunTime:0.041126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18836204 LIMIT 2 [ RunTime:0.057560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836204 ORDER BY `minOrder` ASC [ RunTime:0.055084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18836183 LIMIT 4 [ RunTime:0.069044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836183 ORDER BY `minOrder` ASC [ RunTime:0.071647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18836183 ORDER BY `unit` DESC [ RunTime:0.050643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18836183 LIMIT 2 [ RunTime:0.080732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836183 ORDER BY `minOrder` ASC [ RunTime:0.018872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835451 LIMIT 4 [ RunTime:0.036837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835451 ORDER BY `minOrder` ASC [ RunTime:0.096337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18835451 ORDER BY `unit` DESC [ RunTime:0.039662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18835451 LIMIT 2 [ RunTime:0.106795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835451 ORDER BY `minOrder` ASC [ RunTime:0.107909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18833544 LIMIT 4 [ RunTime:0.123977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18833544 ORDER BY `minOrder` ASC [ RunTime:0.184643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18833544 ORDER BY `unit` DESC [ RunTime:0.092687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18833544 LIMIT 2 [ RunTime:0.101320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18833544 ORDER BY `minOrder` ASC [ RunTime:0.103008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18788282 LIMIT 4 [ RunTime:0.112900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18788282 ORDER BY `minOrder` ASC [ RunTime:0.046161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18788282 ORDER BY `unit` DESC [ RunTime:0.084398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18788282 LIMIT 2 [ RunTime:0.131976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18788282 ORDER BY `minOrder` ASC [ RunTime:0.080581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18788170 LIMIT 4 [ RunTime:0.061665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18788170 ORDER BY `minOrder` ASC [ RunTime:0.042885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18788170 ORDER BY `unit` DESC [ RunTime:0.055034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18788170 LIMIT 2 [ RunTime:0.038220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18788170 ORDER BY `minOrder` ASC [ RunTime:0.020241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18787910 LIMIT 4 [ RunTime:0.084331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18787910 ORDER BY `minOrder` ASC [ RunTime:0.104188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18787910 ORDER BY `unit` DESC [ RunTime:0.069830s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18787910 LIMIT 2 [ RunTime:0.012997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18787910 ORDER BY `minOrder` ASC [ RunTime:0.025419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18786962 LIMIT 4 [ RunTime:0.104382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18786962 ORDER BY `minOrder` ASC [ RunTime:0.095195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18786962 ORDER BY `unit` DESC [ RunTime:0.195358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18786962 LIMIT 2 [ RunTime:0.066345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18786962 ORDER BY `minOrder` ASC [ RunTime:0.031812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18786924 LIMIT 4 [ RunTime:0.044422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18786924 ORDER BY `minOrder` ASC [ RunTime:0.036218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18786924 ORDER BY `unit` DESC [ RunTime:0.095582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18786924 LIMIT 2 [ RunTime:0.166349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18786924 ORDER BY `minOrder` ASC [ RunTime:0.064075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18786923 LIMIT 4 [ RunTime:0.038138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18786923 ORDER BY `minOrder` ASC [ RunTime:0.086733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18786923 ORDER BY `unit` DESC [ RunTime:0.090559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18786923 LIMIT 2 [ RunTime:0.147496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18786923 ORDER BY `minOrder` ASC [ RunTime:0.044088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781661 LIMIT 4 [ RunTime:0.082000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781661 ORDER BY `minOrder` ASC [ RunTime:0.139242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781661 ORDER BY `unit` DESC [ RunTime:0.159900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781661 LIMIT 2 [ RunTime:0.050749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781661 ORDER BY `minOrder` ASC [ RunTime:0.037769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781660 LIMIT 4 [ RunTime:0.078751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781660 ORDER BY `minOrder` ASC [ RunTime:0.050999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781660 ORDER BY `unit` DESC [ RunTime:0.050720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781660 LIMIT 2 [ RunTime:0.050839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781660 ORDER BY `minOrder` ASC [ RunTime:0.050918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18758453 LIMIT 4 [ RunTime:0.093261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18758453 ORDER BY `minOrder` ASC [ RunTime:0.152006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18758453 ORDER BY `unit` DESC [ RunTime:0.181979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18758453 LIMIT 2 [ RunTime:0.087067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18758453 ORDER BY `minOrder` ASC [ RunTime:0.038426s ]
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.147821s ]