SHOW FULL COLUMNS FROM `gs_poems` [ RunTime:0.003165s ]
SELECT * FROM `gs_poems` WHERE `id` = 42796 LIMIT 1 [ RunTime:0.002529s ]
SHOW FULL COLUMNS FROM `gs_authors` [ RunTime:0.003299s ]
SELECT * FROM `gs_authors` WHERE ( `id` = 1653 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002942s ]
SHOW FULL COLUMNS FROM `gs_dynasties` [ RunTime:0.002982s ]
SELECT * FROM `gs_dynasties` WHERE ( `id` = 5 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003242s ]
SHOW FULL COLUMNS FROM `gs_forms` [ RunTime:0.003003s ]
SELECT * FROM `gs_forms` WHERE ( `id` IS NULL ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004184s ]
SHOW FULL COLUMNS FROM `gs_tags` [ RunTime:0.003202s ]
SHOW FULL COLUMNS FROM `gs_poem_tags` [ RunTime:0.044556s ]
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` = '42796' ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.072471s ]
SHOW FULL COLUMNS FROM `gs_poem_contents` [ RunTime:0.003050s ]
SELECT * FROM `gs_poem_contents` WHERE `poem_id` = 42796 ORDER BY `sort_order` ASC [ RunTime:0.002979s ]
UPDATE `gs_poems` SET `view_count` = `view_count` + 1 WHERE `id` = 42796 [ RunTime:0.004364s ]
SHOW FULL COLUMNS FROM `gs_quotes` [ RunTime:0.003133s ]
SELECT * FROM `gs_quotes` WHERE `poem_id` = 42796 ORDER BY `position` ASC [ RunTime:0.002635s ]
SELECT * FROM `gs_poems` WHERE `status` = 1 AND `id` <> 42796 AND `author_id` = 1653 ORDER BY `view_count` DESC LIMIT 6 [ RunTime:0.002611s ]
SELECT * FROM `gs_authors` WHERE ( `id` = 1653 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002414s ]
SELECT * FROM `gs_dynasties` WHERE ( `id` = 5 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003366s ]
SELECT * FROM `gs_poems` WHERE `status` = 1 AND `id` NOT IN (42796,42797) AND `dynasty` = '唐' ORDER BY `view_count` DESC LIMIT 5 [ RunTime:0.002989s ]
SELECT * FROM `gs_authors` WHERE ( `id` IN (2625,2742,2681,1614,2674) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.002688s ]
SELECT * FROM `gs_dynasties` WHERE ( `id` = 5 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002648s ]
SHOW FULL COLUMNS FROM `gs_collections` [ RunTime:0.003104s ]
SELECT * FROM `gs_collections` WHERE `status` = 1 ORDER BY `sort_order` ASC [ RunTime:0.002586s ]