SHOW FULL COLUMNS FROM `tool_abbr` [ RunTime:0.001224s ]
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` = 1199 LIMIT 1 [ RunTime:0.000560s ]
UPDATE `tool_abbr` SET `views` = `views` + 1 WHERE `id` = 1199 [ RunTime:0.007406s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` IN (7203,11836,10923,7851,10767,5745,8436,4532,10538,9390,14386,4556,6013,11849,6279,13604,13733,398,10053,13987,2496,10534,7921,1609,5456,4549,7267,11615,11899,5892,15414,12391,6549,11276,4673,13674) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.000938s ]
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` = 'biotech' AND `a`.`id` <> '1199' AND `a`.`switch` = '1' [ RunTime:0.000839s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` < 1199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` > 1199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]
热门工具排行榜