SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003136s ]
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.005682s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003643s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.007013s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002769s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.011374s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002930s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.008544s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002481s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.007902s ]
UPDATE `stock_search` SET `count` = 4126 , `updatetime` = '2026-06-08 16:47:22' WHERE `partno` = '210' [ RunTime:0.011859s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.004421s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.002126s ]
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.000706s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002326s ]
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.010261s ]
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 5620,20 [ RunTime:0.110351s ]
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 ('19567488','19567487','19567486','19567484','19567483','19567482','19567481','19567480','19567479','19567478','19567477','19535465','19535075','19534544','19534181','19532856','19532855','19532773','19532726','19532671') ORDER BY FIELD(s.id, 19567488,19567487,19567486,19567484,19567483,19567482,19567481,19567480,19567479,19567478,19567477,19535465,19535075,19534544,19534181,19532856,19532855,19532773,19532726,19532671) [ RunTime:0.088991s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.023018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567488 LIMIT 4 [ RunTime:0.069274s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567488 ORDER BY `minOrder` ASC [ RunTime:0.086001s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.046678s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567488 ORDER BY `unit` DESC [ RunTime:0.048961s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567488 LIMIT 2 [ RunTime:0.037568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567488 ORDER BY `minOrder` ASC [ RunTime:0.024643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567487 LIMIT 4 [ RunTime:0.081373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567487 ORDER BY `minOrder` ASC [ RunTime:0.070554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567487 ORDER BY `unit` DESC [ RunTime:0.031579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567487 LIMIT 2 [ RunTime:0.098875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567487 ORDER BY `minOrder` ASC [ RunTime:0.029448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567486 LIMIT 4 [ RunTime:0.047648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567486 ORDER BY `minOrder` ASC [ RunTime:0.011388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567486 ORDER BY `unit` DESC [ RunTime:0.030463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567486 LIMIT 2 [ RunTime:0.072470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567486 ORDER BY `minOrder` ASC [ RunTime:0.012718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567484 LIMIT 4 [ RunTime:0.073764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567484 ORDER BY `minOrder` ASC [ RunTime:0.050325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567484 ORDER BY `unit` DESC [ RunTime:0.055615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567484 LIMIT 2 [ RunTime:0.045886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567484 ORDER BY `minOrder` ASC [ RunTime:0.013933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567483 LIMIT 4 [ RunTime:0.032597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567483 ORDER BY `minOrder` ASC [ RunTime:0.012112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567483 ORDER BY `unit` DESC [ RunTime:0.045121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567483 LIMIT 2 [ RunTime:0.065219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567483 ORDER BY `minOrder` ASC [ RunTime:0.035708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567482 LIMIT 4 [ RunTime:0.105455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567482 ORDER BY `minOrder` ASC [ RunTime:0.080922s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567482 ORDER BY `unit` DESC [ RunTime:0.040725s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567482 LIMIT 2 [ RunTime:0.114568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567482 ORDER BY `minOrder` ASC [ RunTime:0.038125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567481 LIMIT 4 [ RunTime:0.090686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567481 ORDER BY `minOrder` ASC [ RunTime:0.131747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567481 ORDER BY `unit` DESC [ RunTime:0.113173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567481 LIMIT 2 [ RunTime:0.180240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567481 ORDER BY `minOrder` ASC [ RunTime:0.049756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567480 LIMIT 4 [ RunTime:0.064288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567480 ORDER BY `minOrder` ASC [ RunTime:0.013812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567480 ORDER BY `unit` DESC [ RunTime:0.058738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567480 LIMIT 2 [ RunTime:0.028066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567480 ORDER BY `minOrder` ASC [ RunTime:0.052630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567479 LIMIT 4 [ RunTime:0.069645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567479 ORDER BY `minOrder` ASC [ RunTime:0.050196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567479 ORDER BY `unit` DESC [ RunTime:0.072228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567479 LIMIT 2 [ RunTime:0.119960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567479 ORDER BY `minOrder` ASC [ RunTime:0.063446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567478 LIMIT 4 [ RunTime:0.034827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567478 ORDER BY `minOrder` ASC [ RunTime:0.052991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567478 ORDER BY `unit` DESC [ RunTime:0.128549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567478 LIMIT 2 [ RunTime:0.145660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567478 ORDER BY `minOrder` ASC [ RunTime:0.017855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19567477 LIMIT 4 [ RunTime:0.044568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567477 ORDER BY `minOrder` ASC [ RunTime:0.035554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19567477 ORDER BY `unit` DESC [ RunTime:0.071569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19567477 LIMIT 2 [ RunTime:0.014797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19567477 ORDER BY `minOrder` ASC [ RunTime:0.048874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19535465 LIMIT 4 [ RunTime:0.072924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535465 ORDER BY `minOrder` ASC [ RunTime:0.055195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19535465 ORDER BY `unit` DESC [ RunTime:0.065119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19535465 LIMIT 2 [ RunTime:0.032925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535465 ORDER BY `minOrder` ASC [ RunTime:0.040782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19535075 LIMIT 4 [ RunTime:0.054728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535075 ORDER BY `minOrder` ASC [ RunTime:0.052371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19535075 ORDER BY `unit` DESC [ RunTime:0.086851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19535075 LIMIT 2 [ RunTime:0.029553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535075 ORDER BY `minOrder` ASC [ RunTime:0.024000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19534544 LIMIT 4 [ RunTime:0.043792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19534544 ORDER BY `minOrder` ASC [ RunTime:0.053913s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19534544 ORDER BY `unit` DESC [ RunTime:0.091693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19534544 LIMIT 2 [ RunTime:0.105958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19534544 ORDER BY `minOrder` ASC [ RunTime:0.037109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19534181 LIMIT 4 [ RunTime:0.006154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19534181 ORDER BY `minOrder` ASC [ RunTime:0.049671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19534181 ORDER BY `unit` DESC [ RunTime:0.072263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19534181 LIMIT 2 [ RunTime:0.047210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19534181 ORDER BY `minOrder` ASC [ RunTime:0.030063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19532856 LIMIT 4 [ RunTime:0.047571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19532856 ORDER BY `minOrder` ASC [ RunTime:0.036852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19532856 ORDER BY `unit` DESC [ RunTime:0.039096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19532856 LIMIT 2 [ RunTime:0.028954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19532856 ORDER BY `minOrder` ASC [ RunTime:0.003928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19532855 LIMIT 4 [ RunTime:0.046405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19532855 ORDER BY `minOrder` ASC [ RunTime:0.025727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19532855 ORDER BY `unit` DESC [ RunTime:0.065758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19532855 LIMIT 2 [ RunTime:0.088751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19532855 ORDER BY `minOrder` ASC [ RunTime:0.008254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19532773 LIMIT 4 [ RunTime:0.038360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19532773 ORDER BY `minOrder` ASC [ RunTime:0.049646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19532773 ORDER BY `unit` DESC [ RunTime:0.044875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19532773 LIMIT 2 [ RunTime:0.039411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19532773 ORDER BY `minOrder` ASC [ RunTime:0.005961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19532726 LIMIT 4 [ RunTime:0.062381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19532726 ORDER BY `minOrder` ASC [ RunTime:0.064549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19532726 ORDER BY `unit` DESC [ RunTime:0.084071s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19532726 LIMIT 2 [ RunTime:0.048249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19532726 ORDER BY `minOrder` ASC [ RunTime:0.015741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19532671 LIMIT 4 [ RunTime:0.023009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19532671 ORDER BY `minOrder` ASC [ RunTime:0.026897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19532671 ORDER BY `unit` DESC [ RunTime:0.041557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19532671 LIMIT 2 [ RunTime:0.011719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19532671 ORDER BY `minOrder` ASC [ RunTime:0.028114s ]
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.003530s ]