[ DB ] CONNECT:[ UseTime:0.002157s ] mysql:host=47.110.148.119;dbname=iclean_test;charset=utf8
[ SQL ] SHOW COLUMNS FROM `menu` [ RunTime:0.001514s ]
[ SQL ] SELECT * FROM `menu` WHERE `pathinfo` = 'news/info/871' AND `status` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000948s ]
[ SQL ] SELECT * FROM `menu` WHERE `pathinfo` = 'news/info/871' AND `status` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001029s ]
[ SQL ] SHOW COLUMNS FROM `news` [ RunTime:0.001299s ]
[ SQL ] SELECT `news`.`id`,`news`.`category_id`,`news`.`type_id`,`news`.`title_data`,`news`.`image`,`news`.`source_url`,`news`.`publish_date`,`news`.`clicks`,`news`.`is_top`,`news`.`is_hot`,`news`.`is_home`,`news`.`status`,`news`.`create_time`,`news`.`update_time`,`news`.`is_banner`,`info`.`title` AS `info__title`,`info`.`sub_title` AS `info__sub_title`,`info`.`brief` AS `info__brief`,`info`.`content` AS `info__content`,`info`.`author` AS `info__author`,`info`.`source` AS `info__source`,`info`.`meta_title` AS `info__meta_title`,`info`.`meta_desc` AS `info__meta_desc`,`info`.`meta_kws` AS `info__meta_kws` FROM `news` `news` INNER JOIN `news_info` `info` ON `news`.`id`=`info`.`news_id` WHERE `info`.`lang` = 'cn' AND `news`.`id` = 871 AND `news`.`status` = 1 LIMIT 1 [ RunTime:0.205065s ]
[ SQL ] UPDATE `news` SET `clicks` = `clicks` + 1 WHERE `id` = 871 [ RunTime:0.041370s ]
[ SQL ] SHOW COLUMNS FROM `news_category` [ RunTime:0.001720s ]
[ SQL ] SELECT * FROM `news_category` WHERE `status` = 1 ORDER BY `pid`,`sort` DESC,`id` [ RunTime:0.000950s ]
[ SQL ] SELECT `news`.`id`,`news`.`category_id`,`news`.`type_id`,`news`.`title_data`,`news`.`image`,`news`.`source_url`,`news`.`publish_date`,`news`.`create_uid`,`news`.`create_uname`,`news`.`clicks`,`news`.`is_top`,`news`.`is_hot`,`news`.`is_home`,`news`.`sort`,`news`.`status`,`news`.`create_time`,`news`.`update_time`,`news`.`is_banner`,`info`.`news_id` AS `info__news_id`,`info`.`title` AS `info__title`,`info`.`image` AS `info__image`,`info`.`brief` AS `info__brief`,`info`.`content` AS `info__content`,`info`.`outlink` AS `info__outlink` FROM `news` `news` INNER JOIN `news_info` `info` ON `news`.`id`=`info`.`news_id` WHERE `info`.`lang` = 'cn' AND `info`.`title` <> '' AND `category_id` = 34 AND `news`.`id` > 871 AND `status` = 1 ORDER BY `news`.`id` LIMIT 1 [ RunTime:0.884649s ]
[ SQL ] SELECT `news`.`id`,`news`.`category_id`,`news`.`type_id`,`news`.`title_data`,`news`.`image`,`news`.`source_url`,`news`.`publish_date`,`news`.`create_uid`,`news`.`create_uname`,`news`.`clicks`,`news`.`is_top`,`news`.`is_hot`,`news`.`is_home`,`news`.`sort`,`news`.`status`,`news`.`create_time`,`news`.`update_time`,`news`.`is_banner`,`info`.`news_id` AS `info__news_id`,`info`.`title` AS `info__title`,`info`.`image` AS `info__image`,`info`.`brief` AS `info__brief`,`info`.`content` AS `info__content`,`info`.`outlink` AS `info__outlink` FROM `news` `news` INNER JOIN `news_info` `info` ON `news`.`id`=`info`.`news_id` WHERE `info`.`lang` = 'cn' AND `info`.`title` <> '' AND `category_id` = 34 AND `news`.`id` < 871 AND `status` = 1 ORDER BY `news`.`id` DESC LIMIT 1 [ RunTime:0.012750s ]
[ SQL ] SELECT `news`.`id`,`news`.`image`,`news`.`create_time`,`info`.`news_id` AS `info__news_id`,`info`.`title` AS `info__title`,`info`.`brief` AS `info__brief`,`info`.`image` AS `info__image`,`info`.`outlink` AS `info__outlink` FROM `news` `news` INNER JOIN `news_info` `info` ON `news`.`id`=`info`.`news_id` WHERE `info`.`lang` = 'cn' AND `info`.`title` <> '' AND `news`.`id` <> 871 AND `category_id` = 34 AND `status` = 1 ORDER BY `id` DESC LIMIT 3 [ RunTime:0.013088s ]
