[ DB ] CONNECT:[ UseTime:0.001508s ] mysql:host=47.110.148.119;dbname=iclean_test;charset=utf8
[ SQL ] SHOW COLUMNS FROM `menu` [ RunTime:0.001435s ]
[ SQL ] SELECT `m`.*,`i`.`name`,`i`.`outlink`,`i`.`target` FROM `menu` `m` LEFT JOIN `menu_info` `i` ON `m`.`id`=`i`.`menu_id` WHERE `m`.`status` = 1 AND `i`.`name` <> '' AND `i`.`lang` = 'cn' ORDER BY `m`.`pid`,`m`.`sort` DESC,`m`.`id` [ RunTime:0.001352s ]
[ SQL ] SELECT * FROM `menu` WHERE `pathinfo` = 'news' AND `status` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001111s ]
[ SQL ] SHOW COLUMNS FROM `menu_info` [ RunTime:0.001437s ]
[ SQL ] SELECT * FROM `menu_info` WHERE `lang` = 'cn' AND `menu_id` = 167 [ RunTime:0.000943s ]
[ SQL ] SELECT * FROM `menu` WHERE `pathinfo` = 'news' AND `status` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000837s ]
[ SQL ] SELECT * FROM `menu_info` WHERE `lang` = 'cn' AND `menu_id` = 167 [ RunTime:0.000816s ]
[ SQL ] SHOW COLUMNS FROM `news` [ RunTime:0.001324s ]
[ SQL ] SHOW COLUMNS FROM `news_info` [ RunTime:0.001203s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `news` `news` INNER JOIN `news_info` `info` ON `news`.`id`=`info`.`news_id` WHERE `info`.`lang` = 'cn' AND `status` = 1 AND `title` <> '' [ RunTime:0.001257s ]
[ 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`.`id` AS `info__id`,`info`.`news_id` AS `info__news_id`,`info`.`lang` AS `info__lang`,`info`.`title` AS `info__title`,`info`.`sub_title` AS `info__sub_title`,`info`.`image` AS `info__image`,`info`.`brief` AS `info__brief`,`info`.`content` AS `info__content`,`info`.`author` AS `info__author`,`info`.`source` AS `info__source`,`info`.`outlink` AS `info__outlink`,`info`.`clicks` AS `info__clicks`,`info`.`meta_title` AS `info__meta_title`,`info`.`meta_desc` AS `info__meta_desc`,`info`.`meta_kws` AS `info__meta_kws`,`info`.`info_status` AS `info__info_status` FROM `news` `news` INNER JOIN `news_info` `info` ON `news`.`id`=`info`.`news_id` WHERE `info`.`lang` = 'cn' AND `status` = 1 AND `title` <> '' ORDER BY `sort` DESC,`id` DESC LIMIT 0,6 [ RunTime:0.002951s ]
