SHOW FULL COLUMNS FROM `dynasty` [ RunTime:0.001162s ]
SELECT * FROM `dynasty` ORDER BY `sort` ASC [ RunTime:0.000691s ]
SHOW FULL COLUMNS FROM `poem_type` [ RunTime:0.000984s ]
SELECT * FROM `poem_type` ORDER BY `id` ASC [ RunTime:0.000280s ]
SHOW FULL COLUMNS FROM `poem_theme` [ RunTime:0.000873s ]
SELECT * FROM `poem_theme` ORDER BY `id` ASC [ RunTime:0.000248s ]
SHOW FULL COLUMNS FROM `poet_author` [ RunTime:0.002184s ]
SELECT * FROM `poet_author` ORDER BY `id` ASC [ RunTime:0.000397s ]
SHOW FULL COLUMNS FROM `poem_famous_line` [ RunTime:0.001077s ]
SHOW FULL COLUMNS FROM `poem` [ RunTime:0.000960s ]
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.000395s ]
SELECT * FROM `poem` WHERE ( `id` IN (10,8) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.000461s ]
SELECT * FROM `poet_author` WHERE ( `id` IN (4,3) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.000312s ]
SELECT * FROM `poem` WHERE ( `id` IN (10,8) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.000292s ]
SELECT * FROM `dynasty` WHERE ( `id` = 5 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000285s ]
SELECT * FROM `poem` WHERE ( `id` IN (10,8) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.000291s ]
SELECT * FROM `poem_type` WHERE ( `id` = 1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000273s ]
SELECT COUNT(*) AS think_count FROM `poem` WHERE `poem`.`type_id` = '5' [ RunTime:0.000250s ]
SELECT COUNT(*) AS think_count FROM `poem` [ RunTime:0.000214s ]
SELECT * FROM `dynasty` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000331s ]
SELECT * FROM `poet_author` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000251s ]
SELECT * FROM `poem_theme` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000243s ]
SELECT * FROM `dynasty` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000248s ]
SELECT * FROM `poet_author` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000248s ]
SELECT * FROM `poem_theme` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000245s ]