SHOW FULL COLUMNS FROM `dt_column` [ slave|RunTime:0.068747s ]
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 ('column','live') AND ( c.type = 'column' or v.count > 0 ) GROUP BY `c`.`id` ) `_group_count_` LIMIT 1 [ slave|RunTime:0.110946s ]
SHOW FULL COLUMNS FROM `dt_category` [ slave|RunTime:0.068440s ]
SELECT `name`,`id` FROM `dt_category` WHERE `fid` = 2 AND `deleted` = 0 AND `memberid` = 0 AND `college_id` = 0 [ slave|RunTime:0.068315s ]
SELECT `id` FROM `dt_category` WHERE `id` = 3 AND `fid` = 2 AND `memberid` = 0 AND `college_id` = 0 [ slave|RunTime:0.067962s ]
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` INNER JOIN `dt_category` `ca` ON `ca`.`id`=`d`.`vid` 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 `ca`.`fid` = '3' 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`.`type` IN ('column','live') AND ( c.type = 'column' or v.count > 0 ) GROUP BY `c`.`id` ) `_group_count_` LIMIT 1 [ slave|RunTime:0.238854s ]
SHOW FULL COLUMNS FROM `dt_college_position` [ slave|RunTime:0.068663s ]
SHOW FULL COLUMNS FROM `dt_college_position_column_type` [ slave|RunTime:0.068645s ]
SELECT `id`,`position_id`,`name`,`ad_words` FROM `dt_college_position_column_type` WHERE `deleted` = 0 [ slave|RunTime:0.068126s ]
SELECT distinct sp.type_id FROM `dt_column` `c` INNER JOIN `dt_college_position_stage_pack_course` `pc` ON `pc`.`data_id`=`c`.`id` INNER JOIN `dt_college_position_stage_pack` `sp` ON `sp`.`id`=`pc`.`stage_pack_id` INNER JOIN `dt_college_position_column_stage` `s` ON `s`.`id`=`sp`.`stage_id` WHERE `c`.`status` = '4' AND `sp`.`status` = '1' AND `sp`.`deleted` = '0' AND `s`.`deleted` = '0' AND `c`.`deleted` = '0' AND `pc`.`deleted` = '0' [ slave|RunTime:0.069692s ]