SHOW FULL COLUMNS FROM `tool_lyric` [ RunTime:0.001348s ]
SELECT `id`,`title`,`singer`,`content` FROM `tool_lyric` WHERE `switch` = 1 AND `id` = 200523 LIMIT 1 [ RunTime:0.002866s ]
UPDATE `tool_lyric` SET `views` = `views` + 1 WHERE `id` = 200523 [ RunTime:0.003457s ]
SELECT `id`,`title` FROM `tool_lyric` WHERE `id` IN (746382,115659,588465,352713,491367,302170,699489,560794,589538,524330,337399,819,266993,706669,812343,641604,141454,272984,425150,93929,105818,214491,547102,738326,91334,716119,249449,791779,666099,373870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.025600s ]
SELECT `id`,`title` FROM `tool_lyric` WHERE `id` < 200523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003716s ]
SELECT `id`,`title` FROM `tool_lyric` WHERE `id` > 200523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003341s ]
热门工具排行榜