SHOW FULL COLUMNS FROM `tool_poetry` [ RunTime:0.003903s ]
SELECT `id`,`name`,`content`,`author`,`dynasty`,`tag`,`ywjzsy`,`ywckzly`,`ywjzse`,`ywckzle`,`czbj`,`czckzl`,`jsy`,`jsckzly`,`jse`,`jsckzle`,`sxy`,`sxckzly`,`sxe`,`sxckzle`,`jj`,`wyzs`,`yj`,`xzsf`,`xzckzl`,`dj`,`pj`,`jx`,`views`,`status`,`switch`,`updatetime`,`createtime` FROM `tool_poetry` WHERE `switch` = 1 AND `id` = 193931 LIMIT 1 [ RunTime:0.011183s ]
SHOW FULL COLUMNS FROM `tool_poet` [ RunTime:0.003819s ]
SELECT `id` FROM `tool_poet` WHERE `name` = '彭龟年' LIMIT 1 [ RunTime:0.008165s ]
SHOW FULL COLUMNS FROM `tool_category` [ RunTime:0.001653s ]
SELECT `id` FROM `tool_category` WHERE `type` = 'dynasty' AND `name` = '宋代' LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_poetry` SET `views` = `views` + 1 WHERE `id` = 193931 [ RunTime:0.003657s ]
SELECT `id`,`name` FROM `tool_poetry` WHERE `author` = '彭龟年' AND `switch` = 1 ORDER BY rand() LIMIT 20 [ RunTime:0.190517s ]
SELECT `id`,`name`,`image` FROM `tool_poet` WHERE `id` IN (9109,10434,5597,3307,10016,12938,12917,6915,1096,1490,1430,7421) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.004444s ]
SELECT `id`,`name` FROM `tool_poetry` WHERE `id` < 193931 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001054s ]
SELECT `id`,`name` FROM `tool_poetry` WHERE `id` > 193931 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001101s ]