SHOW FULL COLUMNS FROM `dt_coursewave_user_buys` [ slave|RunTime:0.069778s ]
SELECT `data_id` FROM `dt_coursewave_user_buys` WHERE `userid` = 0 AND `type` <> 'vip' AND `expiretime` > '2022-06-27 12:37:10' [ slave|RunTime:0.069314s ]
SELECT `data_id` FROM `dt_coursewave_user_buys` WHERE `userid` = 0 AND `type` = 'vip' AND `expiretime` > '2022-06-27 12:37:10' [ slave|RunTime:0.069411s ]
SHOW FULL COLUMNS FROM `dt_column` [ slave|RunTime:0.070282s ]
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.069430s ]
SELECT * FROM `dt_column` WHERE `id` = 745 AND `deleted` = 0 LIMIT 1 [ slave|RunTime:0.069907s ]
SHOW FULL COLUMNS FROM `dt_teacher` [ slave|RunTime:0.069918s ]
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` = '745' [ slave|RunTime:0.069486s ]
SHOW FULL COLUMNS FROM `dt_live` [ slave|RunTime:0.069961s ]
SELECT `id`,`live_length`,`title`,`live_url`,`sort`,`cover_url` FROM `dt_live` WHERE `deleted` = 0 AND `status` = 4 AND `column_id` = 745 ORDER BY `sort` [ slave|RunTime:0.069546s ]
SHOW FULL COLUMNS FROM `dt_category_data` [ slave|RunTime:0.069598s ]
SELECT `vid` FROM `dt_category_data` WHERE `did` = 745 [ slave|RunTime:0.069408s ]
SHOW FULL COLUMNS FROM `dt_category` [ slave|RunTime:0.069606s ]
SELECT `id` FROM `dt_category` WHERE `id` = 88 AND `fid` = 2 AND `memberid` = 0 AND `college_id` = 0 [ slave|RunTime:0.069261s ]
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` = '88' 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` <> '745' 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.197707s ]
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` = '88' 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` <> '745' 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.197304s ]
第一讲：社群营销批量获客策略
试看 时长：0:23:12
