SHOW FULL COLUMNS FROM `sys_service_area` [ RunTime:0.000935s ]
SELECT `id` AS `id`,`code` AS `code`,`name` AS `name`,`grade` AS `grade`,`initial` AS `initial` FROM `sys_service_area` WHERE `hot` = 1 AND `deleted` = 0 [ RunTime:0.001838s ]
SELECT `id` AS `id`,`code` AS `code`,`name` AS `name`,`grade` AS `grade`,`initial` AS `initial` FROM `sys_service_area` WHERE `initial` <> 'null' AND `deleted` = 0 ORDER BY `initial` [ RunTime:0.002287s ]
SHOW FULL COLUMNS FROM `ccp_ad_content` [ RunTime:0.000862s ]
SELECT `id` AS `id`,`jump_url` AS `jumpurl`,`ad_name` AS `title` FROM `ccp_ad_content` WHERE `place_id` = 3 AND `is_show` = 1 [ RunTime:0.000498s ]
SELECT `id` AS `id`,`jump_url` AS `jumpurl`,`ad_name` AS `title` FROM `ccp_ad_content` WHERE `place_id` = 3 AND `is_show` = 1 [ RunTime:0.000475s ]
SHOW FULL COLUMNS FROM `jrls_creation_question` [ RunTime:0.000867s ]
SELECT COUNT(*) AS think_count FROM `jrls_creation_question` WHERE `publish_status` = 1 LIMIT 1 [ RunTime:0.000578s ]
SELECT `id` AS `id`,`create_time` AS `createTime`,`question_title` AS `questionTitle`,`desciption` AS `desciption`,`create_status` AS `createStatus`,`sub_title` AS `subTitle`,`law_point` AS `lawPoint`,`seo_title` AS `seoTitle`,`seo_description` AS `seoDescription`,`seo_keywords` AS `seoKeywords`,`new_label` AS `newLabel` FROM `jrls_creation_question` WHERE `publish_status` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000563s ]
SHOW FULL COLUMNS FROM `ccp_customer_authority` [ RunTime:0.000838s ]
SELECT COUNT(*) AS think_count FROM `ccp_customer_authority` WHERE ( auth_end_time >now() ) LIMIT 1 [ RunTime:0.001784s ]
SHOW FULL COLUMNS FROM `cms_article` [ RunTime:0.000853s ]
SHOW FULL COLUMNS FROM `cms_article_day_views` [ RunTime:0.000699s ]
SELECT Article.id as id,Article.title as title,Article.jump_url as jumpurl,Article.channel_id as channelId,Article.seo_description as seoDescription,ArticleDayView.views_count as views_count FROM `cms_article` `Article` INNER JOIN `cms_article_day_views` `ArticleDayView` ON `Article`.`id`=`ArticleDayView`.`bus_id` WHERE `deleted` = 0 AND `channel_id` IN ('mrsf','pfzs','pfal') AND ( date_sub(curdate(), interval 7 day) <= ArticleDayView.date_time ) GROUP BY `ArticleDayView`.`bus_id` ORDER BY `views_count` DESC LIMIT 6 [ RunTime:0.082316s ]