SHOW FULL COLUMNS FROM `cms_site_page` [ RunTime:0.001005s ]
SELECT `sp`.*,`st`.`tp_uid`,`st`.`hot_flag`,`st`.`new_flag`,`st`.`popular_flag` FROM `cms_site_page` `sp` LEFT JOIN `cms_site_tp` `st` ON `sp`.`tp_id`=`st`.`id` WHERE `sp`.`site_id` = '1955' AND `sp`.`page_uid` = 'detail' LIMIT 1 [ RunTime:0.000261s ]
SHOW FULL COLUMNS FROM `cms_site_module` [ RunTime:0.000802s ]
SELECT `a`.`id`,`a`.`name`,`a`.`description`,`a`.`module_img`,`a`.`module_emoji`,`a`.`module_key`,`a`.`tag_id`,`a`.`cat_id`,`a`.`pc_num`,`a`.`mobile_num` FROM `cms_site_module` `a` LEFT JOIN `cms_site_page` `b` ON `a`.`page_id`=`b`.`id` WHERE `a`.`site_id` = '1955' AND `a`.`status` = '1' AND `b`.`page_uid` = 'detail' ORDER BY `a`.`sort` DESC [ RunTime:0.000381s ]
SHOW FULL COLUMNS FROM `cms_site_news` [ RunTime:0.000755s ]
SELECT `sa`.`id`,`sa`.`news_id`,`sa`.`top_flag`,`sa`.`hot_flag`,`c`.`cat_name`,`a`.`cat_id`,`a`.`title`,`a`.`summary`,`a`.`thumb_small`,`a`.`thumb_middle`,`a`.`thumb_big`,`a`.`author`,`a`.`view_count`,`click_count`,`share_count`,`a`.`publish_time`,`a`.`create_time`,`a`.`update_time`,sa.create_time as site_create_time,sa.update_time as site_update_time FROM `cms_site_news` `sa` INNER JOIN `cms_news` `a` ON `sa`.`news_id`=`a`.`id` INNER JOIN `cms_categories` `c` ON `a`.`cat_id`=`c`.`id` WHERE `sa`.`site_id` = '1955' AND `sa`.`detail_module_id` = '51891' AND `a`.`status` = '1' AND `sa`.`status` = '1' ORDER BY `a`.`update_time` DESC LIMIT 20 [ RunTime:0.000449s ]
SELECT `sa`.`id`,`sa`.`news_id`,`sa`.`top_flag`,`sa`.`hot_flag`,`c`.`cat_name`,`a`.`cat_id`,`a`.`title`,`a`.`summary`,`a`.`thumb_small`,`a`.`thumb_middle`,`a`.`thumb_big`,`a`.`author`,`a`.`view_count`,`click_count`,`share_count`,`a`.`publish_time`,`a`.`create_time`,`a`.`update_time`,sa.create_time as site_create_time,sa.update_time as site_update_time FROM `cms_site_news` `sa` INNER JOIN `cms_news` `a` ON `sa`.`news_id`=`a`.`id` INNER JOIN `cms_categories` `c` ON `a`.`cat_id`=`c`.`id` WHERE `sa`.`site_id` = '1955' AND `sa`.`detail_module_id` = '51898' AND `a`.`status` = '1' AND `sa`.`status` = '1' ORDER BY `a`.`update_time` DESC LIMIT 20 [ RunTime:0.000329s ]
SHOW FULL COLUMNS FROM `ads_unit` [ RunTime:0.000740s ]
SELECT * FROM `ads_unit` WHERE `site_id` = 1955 AND `status` = 1 ORDER BY `unit_type` ASC [ RunTime:0.000453s ]
SHOW FULL COLUMNS FROM `cms_site_category` [ RunTime:0.000769s ]
SELECT `seo_title`,`seo_keywords`,`seo_description`,`page_hero`,`page_hero_bg` FROM `cms_site_category` WHERE `name` = 'detail' AND `site_id` = '1955' LIMIT 1 [ RunTime:0.000238s ]
SELECT `sa`.`id`,`sa`.`sort`,`sa`.`create_time`,sa.create_time as site_create_time,sa.update_time as site_update_time,`sa`.`site_id`,a.id as news_id,`a`.`title`,`a`.`summary`,`a`.`seo_title`,`a`.`seo_keywords`,`a`.`seo_description`,`a`.`thumb_big`,`a`.`thumb_middle`,`a`.`thumb_small`,`a`.`author`,`a`.`click_count`,`a`.`share_count`,`a`.`view_count`,`a`.`publish_time`,`a`.`update_time`,a.create_time as content_create_time,`a`.`cat_id`,`c`.`cat_name`,`ad`.`content` FROM `cms_site_news` `sa` INNER JOIN `cms_news` `a` ON `sa`.`news_id`=`a`.`id` LEFT JOIN `cms_categories` `c` ON `a`.`cat_id`=`c`.`id` LEFT JOIN `cms_news_detail` `ad` ON `a`.`id`=`ad`.`news_id` WHERE `sa`.`status` = '1' AND `a`.`status` = '1' AND `sa`.`site_id` = '1955' AND `a`.`id` = '56929' LIMIT 1 [ RunTime:0.000393s ]
SELECT `sa`.`id`,`sa`.`sort`,`sa`.`create_time`,sa.create_time as site_create_time,sa.update_time as site_update_time,`sa`.`site_id`,a.id as news_id,`a`.`title`,`a`.`summary`,`a`.`seo_title`,`a`.`seo_keywords`,`a`.`seo_description`,`a`.`thumb_big`,`a`.`thumb_middle`,`a`.`thumb_small`,`a`.`author`,`a`.`click_count`,`a`.`share_count`,`a`.`view_count`,`a`.`publish_time`,`a`.`update_time`,a.create_time as content_create_time,`a`.`cat_id`,`c`.`cat_name` FROM `cms_site_news` `sa` INNER JOIN `cms_news` `a` ON `sa`.`news_id`=`a`.`id` LEFT JOIN `cms_categories` `c` ON `a`.`cat_id`=`c`.`id` WHERE `a`.`cat_id` = '0' AND `sa`.`site_id` = '1955' AND `sa`.`status` = '1' AND `a`.`status` = '1' AND `sa`.`id` <> '0' ORDER BY `a`.`create_time` DESC LIMIT 20 [ RunTime:0.000375s ]
Leave a Comment