SHOW FULL COLUMNS FROM `tool_abbr` [ RunTime:0.002502s ]
SELECT (SELECT name FROM tool_category WHERE tool_category.id = tool_abbr.category_id) AS Cname,id,abbr,full,prc,meaning,category_id FROM `tool_abbr` WHERE `switch` = 1 AND `id` = 10063 LIMIT 1 [ RunTime:0.002686s ]
UPDATE `tool_abbr` SET `views` = `views` + 1 WHERE `id` = 10063 [ RunTime:0.012954s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` IN (14479,9304,11569,8065,10959,13269,2661,2198,7820,9532,277,8035,2975,3200,1516,3910,9129,7486,2819,12930,11349,3170,13672,8244,11722,6204,11668,433,2772,8746,9417,8610,10617,10031,2378,6953) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.005722s ]
SELECT `a`.`id`,`a`.`abbr`,`a`.`full`,`a`.`prc`,b.id as cid,`b`.`name` FROM `tool_abbr` `a` INNER JOIN `tool_category` `b` ON `a`.`category_id`=`b`.`id` WHERE `a`.`abbr` = 'b.com.' AND `a`.`id` <> '10063' AND `a`.`switch` = '1' [ RunTime:0.004350s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` < 10063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005697s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` > 10063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002602s ]
热门工具排行榜