SHOW FULL COLUMNS FROM `dt_coursewave_user_buys` [ slave|RunTime:0.076949s ]
SELECT `data_id` FROM `dt_coursewave_user_buys` WHERE `userid` = 0 AND `type` <> 'vip' AND `expiretime` > '2022-06-27 13:15:50' [ slave|RunTime:0.076925s ]
SELECT `data_id` FROM `dt_coursewave_user_buys` WHERE `userid` = 0 AND `type` = 'vip' AND `expiretime` > '2022-06-27 13:15:51' [ slave|RunTime:0.076822s ]
SHOW FULL COLUMNS FROM `dt_column` [ slave|RunTime:0.077646s ]
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.076630s ]
SHOW FULL COLUMNS FROM `dt_teacher` [ slave|RunTime:0.077374s ]
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` = '9103' [ slave|RunTime:0.076803s ]
SHOW FULL COLUMNS FROM `dt_live_video` [ slave|RunTime:0.076991s ]
SHOW FULL COLUMNS FROM `dt_category_data` [ slave|RunTime:0.076893s ]
SELECT `vid` FROM `dt_category_data` WHERE `did` = 9103 [ slave|RunTime:0.076701s ]
SHOW FULL COLUMNS FROM `dt_category` [ slave|RunTime:0.076806s ]
SELECT `id` FROM `dt_category` WHERE `id` = 278 AND `fid` = 2 AND `memberid` = 0 AND `college_id` = 0 [ slave|RunTime:0.077939s ]
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` = '278' 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` <> '9103' 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.224165s ]
银行对公存贷营销之链式裂变-1
试看 时长：1:40:53
