SHOW FULL COLUMNS FROM `tool_abbr` [ RunTime:0.002326s ]
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` = 6345 LIMIT 1 [ RunTime:0.002334s ]
UPDATE `tool_abbr` SET `views` = `views` + 1 WHERE `id` = 6345 [ RunTime:0.002198s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` IN (5790,10191,7753,10613,7809,15424,4680,11186,6450,2654,7282,2872,9260,6012,5676,15399,2107,11968,8775,5779,15400,8636,13566,11605,11780,1965,13788,11920,2398,4475,12688,1878,9894,6128,6774,15532) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.022568s ]
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` = 'MPJ' AND `a`.`id` <> '6345' AND `a`.`switch` = '1' [ RunTime:0.008740s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` < 6345 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` > 6345 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001706s ]
热门工具排行榜