[ DB ] CONNECT:[ UseTime:0.013996s ] mysql:host=47.111.145.171;dbname=demo_shanghaiamt;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `menu` [ RunTime:0.009849s ]
[ 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.009428s ]
[ SQL ] SELECT * FROM `menu` WHERE `pathinfo` IN ('press/what_new','press/what_new/') AND `status` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.009191s ]
[ SQL ] SHOW COLUMNS FROM `menu_info` [ RunTime:0.009501s ]
[ SQL ] SELECT * FROM `menu_info` WHERE `lang` = 'cn' AND `menu_id` = 47 [ RunTime:0.009261s ]
[ SQL ] SELECT * FROM `menu` WHERE `pid` = 47 AND `status` = 1 LIMIT 1 [ RunTime:0.009313s ]
[ SQL ] SELECT * FROM `menu` WHERE `id` = 5 AND `status` = 1 LIMIT 1 [ RunTime:0.009223s ]
[ SQL ] SELECT * FROM `menu_info` WHERE `lang` = 'cn' AND `menu_id` = 5 [ RunTime:0.009220s ]
[ SQL ] SELECT * FROM `menu` WHERE `status` = 1 AND `pid` = 5 ORDER BY `id` ASC [ RunTime:0.009256s ]
[ SQL ] SELECT * FROM `menu_info` WHERE `lang` = 'cn' AND `menu_id` IN (22,30,31,41,44,47,49,66) [ RunTime:0.013719s ]
[ SQL ] SHOW COLUMNS FROM `news_category` [ RunTime:0.009532s ]
[ SQL ] SELECT * FROM `news_category` WHERE `status` = 1 ORDER BY `pid`,`sort` DESC,`id` [ RunTime:0.009188s ]
[ SQL ] SHOW COLUMNS FROM `news` [ RunTime:0.009601s ]
[ 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` = 5 AND `news`.`status` = 1 [ RunTime:0.009239s ]
[ 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` = 5 AND `news`.`status` = 1 ORDER BY `sort` DESC,`create_time` DESC,`id` DESC LIMIT 30,10 [ RunTime:0.037298s ]