SHOW FULL COLUMNS FROM `tool_abbr` [ RunTime:0.005812s ]
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` = 14008 LIMIT 1 [ RunTime:0.012570s ]
UPDATE `tool_abbr` SET `views` = `views` + 1 WHERE `id` = 14008 [ RunTime:0.015284s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` IN (10096,14708,4021,7483,8982,5174,87,5943,14987,4182,9640,10246,9386,5280,7659,9163,7383,4151,2105,9417,7882,15079,8206,864,3101,9198,11186,5314,13655,1696,3936,9629,11493,401,1981,965) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.015944s ]
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` = 'TMA' AND `a`.`id` <> '14008' AND `a`.`switch` = '1' [ RunTime:0.011384s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` < 14008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003832s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` > 14008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001559s ]
热门工具排行榜