SHOW FULL COLUMNS FROM `tool_lyric` [ RunTime:0.001169s ]
SELECT `id`,`title`,`singer`,`content` FROM `tool_lyric` WHERE `switch` = 1 AND `id` = 101847 LIMIT 1 [ RunTime:0.001094s ]
UPDATE `tool_lyric` SET `views` = `views` + 1 WHERE `id` = 101847 [ RunTime:0.003070s ]
SELECT `id`,`title` FROM `tool_lyric` WHERE `id` IN (71523,535686,22852,160177,655915,370137,412550,285517,384969,738533,147149,617959,493436,251901,10374,501239,95881,643438,179881,260009,612485,217737,133470,726054,436353,418486,484971,40896,19336,460339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.024127s ]
SELECT `id`,`title` FROM `tool_lyric` WHERE `id` < 101847 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003724s ]
SELECT `id`,`title` FROM `tool_lyric` WHERE `id` > 101847 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002273s ]
热门工具排行榜