SHOW FULL COLUMNS FROM `dt_coursewave_user_buys` [ slave|RunTime:0.079118s ]
SELECT `data_id` FROM `dt_coursewave_user_buys` WHERE `userid` = 0 AND `type` <> 'vip' AND `expiretime` > '2022-08-11 02:13:45' [ slave|RunTime:0.078859s ]
SELECT `data_id` FROM `dt_coursewave_user_buys` WHERE `userid` = 0 AND `type` = 'vip' AND `expiretime` > '2022-08-11 02:13:45' [ slave|RunTime:0.078727s ]
SHOW FULL COLUMNS FROM `dt_column` [ slave|RunTime:0.079593s ]
SELECT `c`.`id` FROM `dt_column` `c` INNER JOIN `dt_column_data` `cd` ON `cd`.`dataid`=`c`.`id` WHERE `cd`.`status` = '1' AND 0 = 1 AND `c`.`status` = '4' AND `c`.`deleted` = '0' [ slave|RunTime:0.078733s ]
SELECT * FROM `dt_column` WHERE `id` = 942 AND `deleted` = 0 LIMIT 1 [ slave|RunTime:0.079291s ]
SHOW FULL COLUMNS FROM `dt_teacher` [ slave|RunTime:0.079369s ]
SELECT `t`.`teacherid`,`t`.`web_top`,`t`.`web_name`,`ct`.`column_id`,`t`.`web_face` FROM `dt_teacher` `t` INNER JOIN `dt_column_teacher` `ct` ON `ct`.`teacher_id`=`t`.`teacherid` WHERE `t`.`deleted` = '0' AND `t`.`web_audit` = '1' AND `ct`.`column_id` = '942' [ slave|RunTime:0.078941s ]
SHOW FULL COLUMNS FROM `dt_live` [ slave|RunTime:0.079776s ]
SELECT `id`,`live_length`,`title`,`live_url`,`sort`,`cover_url` FROM `dt_live` WHERE `deleted` = 0 AND `status` = 4 AND `column_id` = 942 ORDER BY `sort` [ slave|RunTime:0.079295s ]
SHOW FULL COLUMNS FROM `dt_category_data` [ slave|RunTime:0.079122s ]
SELECT `vid` FROM `dt_category_data` WHERE `did` = 942 [ slave|RunTime:0.078891s ]
SHOW FULL COLUMNS FROM `dt_category` [ slave|RunTime:0.079166s ]
SELECT `id` FROM `dt_category` WHERE `id` = 149 AND `fid` = 2 AND `memberid` = 0 AND `college_id` = 0 [ slave|RunTime:0.078735s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `dt_column` `c` INNER JOIN `dt_category_data` `d` ON `d`.`did`=`c`.`id` 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 `d`.`tb` = 'column' AND `d`.`vid` = '149' AND `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`.`id` <> '942' AND `c`.`type` IN ('column','live') AND ( c.type = 'column' or v.count > 0 ) GROUP BY `c`.`id` ) `_group_count_` LIMIT 1 [ slave|RunTime:0.217321s ]
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` INNER JOIN `dt_category_data` `d` ON `d`.`did`=`c`.`id` 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 `d`.`tb` = 'column' AND `d`.`vid` = '149' AND `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`.`id` <> '942' AND `c`.`type` IN ('column','live') AND ( c.type = 'column' or v.count > 0 ) GROUP BY `c`.`id` ORDER BY `c`.`updatetime` DESC LIMIT 0,8 [ slave|RunTime:0.214276s ]