SHOW FULL COLUMNS FROM `gs_poems` [ RunTime:0.005252s ]
SELECT * FROM `gs_poems` WHERE `id` = 304100 LIMIT 1 [ RunTime:0.002524s ]
SHOW FULL COLUMNS FROM `gs_authors` [ RunTime:0.003218s ]
SELECT * FROM `gs_authors` WHERE ( `id` = 11302 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002079s ]
SHOW FULL COLUMNS FROM `gs_dynasties` [ RunTime:0.003659s ]
SELECT * FROM `gs_dynasties` WHERE ( `id` = 7 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002194s ]
SHOW FULL COLUMNS FROM `gs_forms` [ RunTime:0.002899s ]
SELECT * FROM `gs_forms` WHERE ( `id` IS NULL ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002238s ]
SHOW FULL COLUMNS FROM `gs_tags` [ RunTime:0.002522s ]
SHOW FULL COLUMNS FROM `gs_poem_tags` [ RunTime:0.003010s ]
SELECT `gs_tags`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`poem_id` AS `pivot__poem_id`,`pivot`.`tag_id` AS `pivot__tag_id`,`pivot`.`created_at` AS `pivot__created_at` FROM `gs_tags` INNER JOIN `gs_poem_tags` `pivot` ON `pivot`.`tag_id`=`gs_tags`.`id` WHERE ( `pivot`.`poem_id` = '304100' ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.002252s ]
SHOW FULL COLUMNS FROM `gs_poem_contents` [ RunTime:0.002693s ]
SELECT * FROM `gs_poem_contents` WHERE `poem_id` = 304100 ORDER BY `sort_order` ASC [ RunTime:0.002119s ]
UPDATE `gs_poems` SET `view_count` = `view_count` + 1 WHERE `id` = 304100 [ RunTime:0.003494s ]
SHOW FULL COLUMNS FROM `gs_quotes` [ RunTime:0.004547s ]
SELECT * FROM `gs_quotes` WHERE `poem_id` = 304100 ORDER BY `position` ASC [ RunTime:0.002165s ]
SELECT * FROM `gs_poems` WHERE `status` = 1 AND `id` <> 304100 AND `author_id` = 11302 ORDER BY `view_count` DESC LIMIT 6 [ RunTime:0.004098s ]
SELECT * FROM `gs_authors` WHERE ( `id` = 11302 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.010926s ]
SELECT * FROM `gs_dynasties` WHERE ( `id` = 7 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001997s ]
SELECT * FROM `gs_poems` WHERE `status` = 1 AND `id` NOT IN (304100,304105,304101,304102,304103,304104) AND `dynasty` = '宋' ORDER BY `view_count` DESC LIMIT 1 [ RunTime:0.022592s ]
SELECT * FROM `gs_authors` WHERE ( `id` = 10298 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002774s ]
SELECT * FROM `gs_dynasties` WHERE ( `id` = 7 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002362s ]
SHOW FULL COLUMNS FROM `gs_collections` [ RunTime:0.003259s ]
SELECT * FROM `gs_collections` WHERE `status` = 1 ORDER BY `sort_order` ASC [ RunTime:0.002226s ]