SHOW FULL COLUMNS FROM `tool_abbr` [ RunTime:0.001475s ]
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` = 2970 LIMIT 1 [ RunTime:0.000683s ]
UPDATE `tool_abbr` SET `views` = `views` + 1 WHERE `id` = 2970 [ RunTime:0.002918s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` IN (381,8696,3879,1550,12510,3122,6074,10921,8496,3316,14096,12319,6600,4132,9801,2866,11464,14992,13482,1907,2205,992,15561,6087,3234,13496,8641,10955,11203,2199,6621,6634,5457,1274,4027) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.000937s ]
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` = 'MCHC' AND `a`.`id` <> '2970' AND `a`.`switch` = '1' [ RunTime:0.001141s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` < 2970 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` > 2970 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]