SHOW FULL COLUMNS FROM `data_settings` [ RunTime:0.000520s ]
SELECT `keyword`,`value` FROM `data_settings` [ RunTime:0.000266s ]
SHOW FULL COLUMNS FROM `data_pages` [ RunTime:0.000464s ]
SELECT * FROM `data_pages` WHERE `status` = 1 [ RunTime:0.000244s ]
SHOW FULL COLUMNS FROM `data_news` [ RunTime:0.000506s ]
SHOW FULL COLUMNS FROM `data_news_read` [ RunTime:0.000501s ]
SHOW FULL COLUMNS FROM `data_comment` [ RunTime:0.000350s ]
SHOW FULL COLUMNS FROM `data_news_collection` [ RunTime:0.000305s ]
SELECT *,(SELECT COUNT(*) AS think_count FROM `data_news_read` `count_table` WHERE ( `count_table`.`news_id` =data_news.id )) AS `news_read_count`,(SELECT COUNT(*) AS think_count FROM `data_comment` `count_table` WHERE ( `count_table`.`news_id` =data_news.id )) AS `comment_count`,(SELECT COUNT(*) AS think_count FROM `data_news_collection` `count_table` WHERE ( `count_table`.`news_id` =data_news.id )) AS `news_collection_count` FROM `data_news` WHERE `id` = 2052 LIMIT 1 [ RunTime:0.000735s ]
SHOW FULL COLUMNS FROM `data_journalnum` [ RunTime:0.000298s ]
SELECT * FROM `data_journalnum` WHERE `id` = 101 [ RunTime:0.000186s ]
SELECT * FROM `data_news` WHERE `journalnumpage_id` = 686 AND `journalnum_id` = 101 AND `journal_id` = 14 AND ( id < 2052 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000311s ]
SELECT * FROM `data_news` WHERE `journalnumpage_id` = 686 AND `journalnum_id` = 101 AND `journal_id` = 14 AND ( id > 2052 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000264s ]
SELECT * FROM `data_journalnum` ORDER BY `issue` DESC LIMIT 0,300 [ RunTime:0.000531s ]
SELECT * FROM `data_journalnum` WHERE `id` = 101 ORDER BY `issue` DESC LIMIT 1 [ RunTime:0.000182s ]
SHOW FULL COLUMNS FROM `data_journalnumpage` [ RunTime:0.000303s ]
SELECT * FROM `data_journalnumpage` WHERE `journalnum_id` = 101 ORDER BY `create_time` ASC [ RunTime:0.000446s ]
SELECT *,(SELECT COUNT(*) AS think_count FROM `data_news_read` `count_table` WHERE ( `count_table`.`news_id` =data_news.id )) AS `news_read_count`,(SELECT COUNT(*) AS think_count FROM `data_comment` `count_table` WHERE ( `count_table`.`news_id` =data_news.id )) AS `comment_count` FROM `data_news` WHERE `journalnumpage_id` = 680 AND `status` = 1 ORDER BY `topping` DESC,`sort_time` DESC,`id` DESC [ RunTime:0.000503s ]
SELECT *,(SELECT COUNT(*) AS think_count FROM `data_news_read` `count_table` WHERE ( `count_table`.`news_id` =data_news.id )) AS `news_read_count`,(SELECT COUNT(*) AS think_count FROM `data_comment` `count_table` WHERE ( `count_table`.`news_id` =data_news.id )) AS `comment_count` FROM `data_news` WHERE `journalnumpage_id` = 681 AND `status` = 1 ORDER BY `topping` DESC,`sort_time` DESC,`id` DESC [ RunTime:0.000489s ]
SELECT *,(SELECT COUNT(*) AS think_count FROM `data_news_read` `count_table` WHERE ( `count_table`.`news_id` =data_news.id )) AS `news_read_count`,(SELECT COUNT(*) AS think_count FROM `data_comment` `count_table` WHERE ( `count_table`.`news_id` =data_news.id )) AS `comment_count` FROM `data_news` WHERE `journalnumpage_id` = 682 AND `status` = 1 ORDER BY `topping` DESC,`sort_time` DESC,`id` DESC [ RunTime:0.000493s ]
SELECT *,(SELECT COUNT(*) AS think_count FROM `data_news_read` `count_table` WHERE ( `count_table`.`news_id` =data_news.id )) AS `news_read_count`,(SELECT COUNT(*) AS think_count FROM `data_comment` `count_table` WHERE ( `count_table`.`news_id` =data_news.id )) AS `comment_count` FROM `data_news` WHERE `journalnumpage_id` = 683 AND `status` = 1 ORDER BY `topping` DESC,`sort_time` DESC,`id` DESC [ RunTime:0.000425s ]
SELECT *,(SELECT COUNT(*) AS think_count FROM `data_news_read` `count_table` WHERE ( `count_table`.`news_id` =data_news.id )) AS `news_read_count`,(SELECT COUNT(*) AS think_count FROM `data_comment` `count_table` WHERE ( `count_table`.`news_id` =data_news.id )) AS `comment_count` FROM `data_news` WHERE `journalnumpage_id` = 684 AND `status` = 1 ORDER BY `topping` DESC,`sort_time` DESC,`id` DESC [ RunTime:0.000613s ]
SELECT *,(SELECT COUNT(*) AS think_count FROM `data_news_read` `count_table` WHERE ( `count_table`.`news_id` =data_news.id )) AS `news_read_count`,(SELECT COUNT(*) AS think_count FROM `data_comment` `count_table` WHERE ( `count_table`.`news_id` =data_news.id )) AS `comment_count` FROM `data_news` WHERE `journalnumpage_id` = 685 AND `status` = 1 ORDER BY `topping` DESC,`sort_time` DESC,`id` DESC [ RunTime:0.000470s ]
SELECT *,(SELECT COUNT(*) AS think_count FROM `data_news_read` `count_table` WHERE ( `count_table`.`news_id` =data_news.id )) AS `news_read_count`,(SELECT COUNT(*) AS think_count FROM `data_comment` `count_table` WHERE ( `count_table`.`news_id` =data_news.id )) AS `comment_count` FROM `data_news` WHERE `journalnumpage_id` = 686 AND `status` = 1 ORDER BY `topping` DESC,`sort_time` DESC,`id` DESC [ RunTime:0.000536s ]
SELECT *,(SELECT COUNT(*) AS think_count FROM `data_news_read` `count_table` WHERE ( `count_table`.`news_id` =data_news.id )) AS `news_read_count`,(SELECT COUNT(*) AS think_count FROM `data_comment` `count_table` WHERE ( `count_table`.`news_id` =data_news.id )) AS `comment_count` FROM `data_news` WHERE `journalnumpage_id` = 687 AND `status` = 1 ORDER BY `topping` DESC,`sort_time` DESC,`id` DESC [ RunTime:0.000452s ]
SELECT * FROM `data_journalnumpage` WHERE `journalnum_id` = 101 ORDER BY `create_time` ASC [ RunTime:0.000465s ]
SHOW FULL COLUMNS FROM `data_page` [ RunTime:0.000313s ]
SELECT * FROM `data_page` WHERE `journalnumpage_id` = 680 ORDER BY `create_time` ASC [ RunTime:0.000763s ]
SELECT * FROM `data_page` WHERE `journalnumpage_id` = 681 ORDER BY `create_time` ASC [ RunTime:0.000756s ]
SELECT * FROM `data_page` WHERE `journalnumpage_id` = 682 ORDER BY `create_time` ASC [ RunTime:0.000684s ]
SELECT * FROM `data_page` WHERE `journalnumpage_id` = 683 ORDER BY `create_time` ASC [ RunTime:0.000681s ]
SELECT * FROM `data_page` WHERE `journalnumpage_id` = 684 ORDER BY `create_time` ASC [ RunTime:0.000799s ]
SELECT * FROM `data_page` WHERE `journalnumpage_id` = 685 ORDER BY `create_time` ASC [ RunTime:0.000717s ]
SELECT * FROM `data_page` WHERE `journalnumpage_id` = 686 ORDER BY `create_time` ASC [ RunTime:0.000735s ]
SELECT * FROM `data_page` WHERE `journalnumpage_id` = 687 ORDER BY `create_time` ASC [ RunTime:0.000686s ]