SHOW FULL COLUMNS FROM `tool_category` [ RunTime:0.001241s ]
SELECT `id`,`name`,`nickname`,`pid` FROM `tool_category` WHERE `type` = 'tool' AND `status` = 'normal' AND `pid` <> 0 ORDER BY `views` DESC LIMIT 24 [ RunTime:0.002022s ]
SHOW FULL COLUMNS FROM `tool_couplet` [ RunTime:0.001361s ]
SELECT `a`.`hp`,`a`.`sl`,`a`.`xl`,`a`.`yy`,b.name as Cname,b.id as Cid FROM `tool_couplet` `a` INNER JOIN `tool_category` `b` ON `a`.`category_id`=`b`.`id` WHERE `a`.`id` = '20789' AND `a`.`switch` = '1' LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_couplet` SET `views` = `views` + 1 WHERE `id` = 20789 [ RunTime:0.001959s ]
SELECT `id`,`hp` FROM `tool_couplet` WHERE `id` IN (27343,14331,8710,10964,23399,11283,3897,5361,4177,2455,16359,10159,13151,1606,9744,29521,5520,12259,11581,9372,22648,2889,29176,13681) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.000543s ]
SELECT `id`,`hp` FROM `tool_couplet` WHERE `category_id` = 542 AND `switch` = 1 ORDER BY rand() LIMIT 24 [ RunTime:0.012421s ]
SELECT `id`,`hp` FROM `tool_couplet` WHERE `id` < 20789 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`hp` FROM `tool_couplet` WHERE `id` > 20789 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]
热门工具排行榜