SHOW FULL COLUMNS FROM `dt_coursewave_user_buys` [ slave|RunTime:0.073701s ]
SELECT `data_id` FROM `dt_coursewave_user_buys` WHERE `userid` = 0 AND `type` <> 'vip' AND `expiretime` > '2022-06-16 20:37:22' [ slave|RunTime:0.072992s ]
SELECT `data_id` FROM `dt_coursewave_user_buys` WHERE `userid` = 0 AND `type` = 'vip' AND `expiretime` > '2022-06-16 20:37:22' [ slave|RunTime:0.072863s ]
SHOW FULL COLUMNS FROM `dt_column` [ slave|RunTime:0.073729s ]
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.072796s ]
SELECT * FROM `dt_column` WHERE `id` = 9237 AND `deleted` = 0 LIMIT 1 [ slave|RunTime:0.073232s ]
SHOW FULL COLUMNS FROM `dt_teacher` [ slave|RunTime:0.073615s ]
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` = '9237' [ slave|RunTime:0.073980s ]
SHOW FULL COLUMNS FROM `dt_live_video` [ slave|RunTime:0.073305s ]
SELECT `v`.`id`,v.video_url as live_url,`l`.`title`,`v`.`sort`,v.duration as live_length,`l`.`cover_url` FROM `dt_live_video` `v` INNER JOIN `dt_live` `l` ON `l`.`id`=`v`.`live_id` WHERE `l`.`column_id` = '9237' AND `v`.`deleted` = '0' AND `l`.`deleted` = '0' AND `v`.`open_back` = '1' ORDER BY `v`.`sort` [ slave|RunTime:0.073168s ]
SHOW FULL COLUMNS FROM `dt_category_data` [ slave|RunTime:0.073084s ]
SELECT `vid` FROM `dt_category_data` WHERE `did` = 9237 [ slave|RunTime:0.073027s ]
SHOW FULL COLUMNS FROM `dt_category` [ slave|RunTime:0.073106s ]
SELECT `id` FROM `dt_category` WHERE `id` = 350 AND `fid` = 2 AND `memberid` = 0 AND `college_id` = 0 [ slave|RunTime:0.072799s ]
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` = '350' 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` <> '9237' 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.074243s ]