SHOW FULL COLUMNS FROM `dynasty` [ RunTime:0.001202s ]
SELECT * FROM `dynasty` ORDER BY `sort` ASC [ RunTime:0.000278s ]
SHOW FULL COLUMNS FROM `poem_type` [ RunTime:0.000859s ]
SELECT * FROM `poem_type` ORDER BY `id` ASC [ RunTime:0.000273s ]
SHOW FULL COLUMNS FROM `poem_theme` [ RunTime:0.000818s ]
SELECT * FROM `poem_theme` ORDER BY `id` ASC [ RunTime:0.000265s ]
SHOW FULL COLUMNS FROM `poet_author` [ RunTime:0.000870s ]
SELECT * FROM `poet_author` ORDER BY `id` ASC [ RunTime:0.000271s ]
SHOW FULL COLUMNS FROM `poem_famous_line` [ RunTime:0.000861s ]
SHOW FULL COLUMNS FROM `poem` [ RunTime:0.000996s ]
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.000418s ]
SELECT * FROM `poem` WHERE ( `id` IN (10,4) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.000384s ]
SELECT * FROM `poet_author` WHERE ( `id` IN (4,2) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.000313s ]
SELECT * FROM `poem` WHERE ( `id` IN (10,4) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.000357s ]
SELECT * FROM `dynasty` WHERE ( `id` = 5 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000299s ]
SELECT * FROM `poem` WHERE ( `id` IN (10,4) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.000326s ]
SELECT * FROM `poem_type` WHERE ( `id` = 1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000300s ]
SELECT COUNT(*) AS think_count FROM `poem` WHERE `poem`.`dynasty_id` = '2' [ RunTime:0.000273s ]
SELECT COUNT(*) AS think_count FROM `poem` [ RunTime:0.000260s ]
SELECT * FROM `dynasty` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000313s ]
SELECT * FROM `poet_author` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000280s ]
SELECT * FROM `poem_theme` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000274s ]
SELECT * FROM `dynasty` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000270s ]
SELECT * FROM `poet_author` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000270s ]
SELECT * FROM `poem_theme` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000265s ]