SHOW FULL COLUMNS FROM `dynasty` [ RunTime:0.000862s ]
SELECT * FROM `dynasty` ORDER BY `sort` ASC [ RunTime:0.000258s ]
SHOW FULL COLUMNS FROM `poem_type` [ RunTime:0.000822s ]
SELECT * FROM `poem_type` ORDER BY `id` ASC [ RunTime:0.000234s ]
SHOW FULL COLUMNS FROM `poem_theme` [ RunTime:0.000775s ]
SELECT * FROM `poem_theme` ORDER BY `id` ASC [ RunTime:0.000235s ]
SHOW FULL COLUMNS FROM `poet_author` [ RunTime:0.000850s ]
SELECT * FROM `poet_author` ORDER BY `id` ASC [ RunTime:0.000299s ]
SHOW FULL COLUMNS FROM `poem_famous_line` [ RunTime:0.000853s ]
SHOW FULL COLUMNS FROM `poem` [ RunTime:0.000938s ]
SELECT * FROM `poem_famous_line` WHERE EXISTS ( SELECT * FROM `poem` WHERE ( `poem`.`id` = `poem_famous_line`.`poem_id` ) AND `poem`.`is_recommended` = '1' ) ORDER BY RAND() LIMIT 2 [ RunTime:0.000417s ]
SELECT * FROM `poem` WHERE ( `id` IN (10,1) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.000365s ]
SELECT * FROM `poet_author` WHERE ( `id` IN (4,1) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.000298s ]
SELECT * FROM `poem` WHERE ( `id` IN (10,1) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.000287s ]
SELECT * FROM `dynasty` WHERE ( `id` = 5 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000261s ]
SELECT * FROM `poem` WHERE ( `id` IN (10,1) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.000283s ]
SELECT * FROM `poem_type` WHERE ( `id` = 1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000258s ]
SELECT COUNT(*) AS think_count FROM `poem` WHERE `poem`.`dynasty_id` = '4' [ RunTime:0.000250s ]
SELECT COUNT(*) AS think_count FROM `poem` [ RunTime:0.000219s ]
SELECT * FROM `dynasty` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000318s ]
SELECT * FROM `poet_author` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000254s ]
SELECT * FROM `poem_theme` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000301s ]
SELECT * FROM `dynasty` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000275s ]
SELECT * FROM `poet_author` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000324s ]
SELECT * FROM `poem_theme` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000297s ]