SHOW FULL COLUMNS FROM `tool_abbr` [ RunTime:0.005205s ]
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` = 3490 LIMIT 1 [ RunTime:0.002816s ]
UPDATE `tool_abbr` SET `views` = `views` + 1 WHERE `id` = 3490 [ RunTime:0.005209s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` IN (14764,13705,4637,11204,14727,4619,10274,12198,10358,2340,2084,7361,13445,11474,3516,7779,9282,8644,4009,3956,4706,6345,6595,12095,15408,8844,2423,3648,10981,9675,8636,12989,4573,9310,9045,15741) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.004213s ]
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` = 'BEJ' AND `a`.`id` <> '3490' AND `a`.`switch` = '1' [ RunTime:0.004001s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` < 3490 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` > 3490 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]
热门工具排行榜