SHOW FULL COLUMNS FROM `dynasty` [ RunTime:0.001449s ]
SELECT * FROM `dynasty` ORDER BY `sort` ASC [ RunTime:0.000594s ]
SHOW FULL COLUMNS FROM `poem_type` [ RunTime:0.001196s ]
SELECT * FROM `poem_type` ORDER BY `id` ASC [ RunTime:0.000263s ]
SHOW FULL COLUMNS FROM `poem_theme` [ RunTime:0.001107s ]
SELECT * FROM `poem_theme` ORDER BY `id` ASC [ RunTime:0.000288s ]
SHOW FULL COLUMNS FROM `poet_author` [ RunTime:0.001151s ]
SELECT * FROM `poet_author` ORDER BY `id` ASC [ RunTime:0.000382s ]
SHOW FULL COLUMNS FROM `poem_famous_line` [ RunTime:0.001125s ]
SHOW FULL COLUMNS FROM `poem` [ RunTime:0.001269s ]
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.000605s ]
SELECT * FROM `poem` WHERE ( `id` IN (10,21) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.000415s ]
SELECT * FROM `poet_author` WHERE ( `id` IN (8,4) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.000357s ]
SELECT * FROM `poem` WHERE ( `id` IN (10,21) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.000358s ]
SELECT * FROM `dynasty` WHERE ( `id` IN (6,5) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.000338s ]
SELECT * FROM `poem` WHERE ( `id` IN (10,21) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.000328s ]
SELECT * FROM `poem_type` WHERE ( `id` IN (2,1) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.000317s ]
SELECT COUNT(*) AS think_count FROM `poem` WHERE `poem`.`dynasty_id` = '10' [ RunTime:0.000329s ]
SELECT COUNT(*) AS think_count FROM `poem` [ RunTime:0.000270s ]
SELECT * FROM `dynasty` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000339s ]
SELECT * FROM `poet_author` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000334s ]
SELECT * FROM `poem_theme` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000321s ]
SELECT * FROM `dynasty` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000310s ]
SELECT * FROM `poet_author` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000344s ]
SELECT * FROM `poem_theme` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000329s ]