[ DB ] CONNECT:[ UseTime:0.015626s ] mysql:host=47.111.145.171;dbname=demo_shanghaiamt;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `expo` [ RunTime:0.010919s ]
[ SQL ] SELECT * FROM `expo` WHERE `status` = 1 ORDER BY `id` DESC [ RunTime:0.010457s ]
[ SQL ] SHOW COLUMNS FROM `menu` [ RunTime:0.010653s ]
[ 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 `m`.`header_status` = 1 AND `i`.`name` <> '' AND `i`.`lang` = 'cn' ORDER BY `m`.`pid`,`m`.`sort` DESC,`m`.`id` [ RunTime:0.010584s ]
[ SQL ] SHOW COLUMNS FROM `siteinfo` [ RunTime:0.010869s ]
[ SQL ] SELECT `config_name`,`config_value` FROM `siteinfo` WHERE `status` = 1 [ RunTime:0.010449s ]
[ SQL ] SELECT * FROM `menu` WHERE `pathinfo` IN ('press/e-newsletter','press/e-newsletter/') AND `status` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.010478s ]
[ SQL ] SHOW COLUMNS FROM `menu_info` [ RunTime:0.010575s ]
[ SQL ] SELECT * FROM `menu_info` WHERE `lang` = 'cn' AND `menu_id` = 49 [ RunTime:0.010362s ]
[ SQL ] SELECT * FROM `menu` WHERE `pid` = 49 AND `status` = 1 LIMIT 1 [ RunTime:0.010536s ]
[ SQL ] SELECT * FROM `menu` WHERE `id` = 5 AND `status` = 1 LIMIT 1 [ RunTime:0.010415s ]
[ SQL ] SELECT * FROM `menu_info` WHERE `lang` = 'cn' AND `menu_id` = 5 [ RunTime:0.010524s ]
[ SQL ] SELECT * FROM `menu` WHERE `status` = 1 AND `pid` = 5 ORDER BY `id` ASC [ RunTime:0.010651s ]
[ SQL ] SELECT * FROM `menu_info` WHERE `lang` = 'cn' AND `menu_id` IN (22,30,31,41,44,47,49,66) [ RunTime:0.015655s ]
[ SQL ] SHOW COLUMNS FROM `news_category` [ RunTime:0.011004s ]
[ SQL ] SELECT * FROM `news_category` WHERE `status` = 1 ORDER BY `pid`,`sort` DESC,`id` [ RunTime:0.010343s ]
[ SQL ] SHOW COLUMNS FROM `news` [ RunTime:0.010823s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `news` `news` INNER JOIN `news_info` `info` ON `news`.`id`=`info`.`news_id` INNER JOIN `news_category` `category` ON `news`.`category_id`=`category`.`id` WHERE `info`.`lang` = 'cn' AND `info`.`title` <> '' AND `category_id` = 6 AND `news`.`status` = 1 [ RunTime:0.014061s ]
[ 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`.`publish_time`,`news`.`create_time`,`news`.`update_time`,`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`,`category`.`id` AS `category__id`,`category`.`cate_name_cn` AS `category__cate_name_cn`,`category`.`cate_name_en` AS `category__cate_name_en`,`category`.`pathinfo` AS `category__pathinfo`,`category`.`pid` AS `category__pid`,`category`.`image` AS `category__image`,`category`.`brief_cn` AS `category__brief_cn`,`category`.`brief_en` AS `category__brief_en`,`category`.`is_menu` AS `category__is_menu`,`category`.`tpl_name` AS `category__tpl_name`,`category`.`sort` AS `category__sort`,`category`.`status` AS `category__status`,`category`.`create_time` AS `category__create_time`,`category`.`update_time` AS `category__update_time` FROM `news` `news` INNER JOIN `news_info` `info` ON `news`.`id`=`info`.`news_id` INNER JOIN `news_category` `category` ON `news`.`category_id`=`category`.`id` WHERE `info`.`lang` = 'cn' AND `info`.`title` <> '' AND `category_id` = 6 AND `news`.`status` = 1 ORDER BY `sort` DESC,`create_time` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.011001s ]
