SHOW FULL COLUMNS FROM `dt_column` [ slave|RunTime:0.079740s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `dt_column` `c` LEFT JOIN `dt_live` `l` ON `l`.`column_id`=`c`.`id` LEFT JOIN (select count(id) count,sum(duration) live_length,live_id from dt_live_video where deleted = 0 and open_back=1 group by live_id) v ON `l`.`id`=`v`.`live_id` WHERE `c`.`status` = '4' AND `c`.`deleted` = '0' AND `c`.`spread` = '1' AND `c`.`memberid` = '0' AND `c`.`to_coursewave` = '1' AND `l`.`deleted` = '0' AND `l`.`status` = '4' AND `c`.`type` IN ('live','column') AND ( c.type = 'column' or v.count > 0 ) GROUP BY `c`.`id` ) `_group_count_` LIMIT 1 [ slave|RunTime:0.118733s ]
SELECT c.id,c.type,c.title,c.subtitle,c.cover_url,c.tag,c.updatetime,(case when c.type='live' then v.count else c.has_chapters end) as has_chapters,c.has_courses,c.pv,(case when c.type='live' then v.live_length else sum(l.live_length) end) as live_length FROM `dt_column` `c` LEFT JOIN `dt_live` `l` ON `l`.`column_id`=`c`.`id` LEFT JOIN (select count(id) count,sum(duration) live_length,live_id from dt_live_video where deleted = 0 and open_back=1 group by live_id) v ON `l`.`id`=`v`.`live_id` WHERE `c`.`status` = '4' AND `c`.`deleted` = '0' AND `c`.`spread` = '1' AND `c`.`memberid` = '0' AND `c`.`to_coursewave` = '1' AND `l`.`deleted` = '0' AND `l`.`status` = '4' AND `c`.`type` IN ('live','column') AND ( c.type = 'column' or v.count > 0 ) GROUP BY `c`.`id` ORDER BY `c`.`updatetime` DESC LIMIT 20,20 [ slave|RunTime:0.126511s ]
