SHOW FULL COLUMNS FROM `woo_cms_document` [ RunTime:0.001129s ]
SELECT `id`,`title`,`menu_id`,`menu_ids`,`ex_title`,`document_model_id`,`is_verify`,`date`,`image`,`images`,`tag`,`list_order`,`admin_id`,`user_id`,`is_top`,`is_top_time`,`visit_count`,`comment_count`,`like_count`,`dislike_count`,`collection_count`,`is_hot`,`is_new`,`is_index`,`is_slide`,`is_headlines`,`is_special`,`is_recommend`,`is_roll`,`is_guest`,`is_comment`,`view_template`,`seo_title`,`seo_keywords`,`seo_description`,`ex_link`,`route`,`summary`,`create_time`,`update_time`,`delete_time` FROM `woo_cms_document` `cms_document` WHERE ( `is_top` = 1 ) AND `cms_document`.`delete_time` = '0' ORDER BY `is_top_time` LIMIT 1 [ RunTime:0.000489s ]
UPDATE `woo_cms_document` `cms_document` SET `is_top` = 0 , `is_top_time` = 0 WHERE ( `is_top` = 1 ) AND `cms_document`.`delete_time` = '0' ORDER BY `is_top_time` [ RunTime:0.002592s ]
SHOW FULL COLUMNS FROM `woo_cms_document_live` [ RunTime:0.000828s ]
SELECT COUNT(*) AS think_count FROM `woo_cms_document_live` `live` INNER JOIN `woo_cms_document` `document` ON `live`.`id`=`document`.`id` WHERE `document`.`delete_time` = '0' AND `document`.`is_verify` = '1' AND ( `document`.`menu_id` = '59' OR FIND_IN_SET('59', `document`.`menu_ids`) ) LIMIT 1 [ RunTime:0.000319s ]
SELECT `live`.`id`,`live`.`author`,`live`.`from`,`live`.`status`,`live`.`vurl`,`live`.`vtime`,`live`.`starttime`,`live`.`endtime`,`live`.`advertise`,`live`.`adpic`,`live`.`adurl`,`live`.`note`,`live`.`content`,`document`.`id` AS `document__id`,`document`.`title` AS `document__title`,`document`.`menu_id` AS `document__menu_id`,`document`.`menu_ids` AS `document__menu_ids`,`document`.`ex_title` AS `document__ex_title`,`document`.`document_model_id` AS `document__document_model_id`,`document`.`is_verify` AS `document__is_verify`,`document`.`date` AS `document__date`,`document`.`image` AS `document__image`,`document`.`images` AS `document__images`,`document`.`tag` AS `document__tag`,`document`.`list_order` AS `document__list_order`,`document`.`admin_id` AS `document__admin_id`,`document`.`user_id` AS `document__user_id`,`document`.`is_top` AS `document__is_top`,`document`.`is_top_time` AS `document__is_top_time`,`document`.`visit_count` AS `document__visit_count`,`document`.`comment_count` AS `document__comment_count`,`document`.`like_count` AS `document__like_count`,`document`.`dislike_count` AS `document__dislike_count`,`document`.`collection_count` AS `document__collection_count`,`document`.`is_hot` AS `document__is_hot`,`document`.`is_new` AS `document__is_new`,`document`.`is_index` AS `document__is_index`,`document`.`is_slide` AS `document__is_slide`,`document`.`is_headlines` AS `document__is_headlines`,`document`.`is_special` AS `document__is_special`,`document`.`is_recommend` AS `document__is_recommend`,`document`.`is_roll` AS `document__is_roll`,`document`.`is_guest` AS `document__is_guest`,`document`.`is_comment` AS `document__is_comment`,`document`.`view_template` AS `document__view_template`,`document`.`seo_title` AS `document__seo_title`,`document`.`seo_keywords` AS `document__seo_keywords`,`document`.`seo_description` AS `document__seo_description`,`document`.`ex_link` AS `document__ex_link`,`document`.`route` AS `document__route`,`document`.`summary` AS `document__summary`,`document`.`create_time` AS `document__create_time`,`document`.`update_time` AS `document__update_time`,`document`.`delete_time` AS `document__delete_time` FROM `woo_cms_document_live` `live` INNER JOIN `woo_cms_document` `document` ON `live`.`id`=`document`.`id` WHERE `document`.`delete_time` = '0' AND `document`.`is_verify` = '1' AND ( `document`.`menu_id` = '59' OR FIND_IN_SET('59', `document`.`menu_ids`) ) ORDER BY `is_top` DESC,`list_order` DESC LIMIT 0,12 [ RunTime:0.000606s ]