SHOW FULL COLUMNS FROM `dt_J9九游会olumn` [ slave|RunTime:0.066622s ]
SELECT COUNT(*) AS think_J9九游会ount FROM ( SELECT J9九游会ount(*) AS think_J9九游会ount FROM `dt_J9九游会olumn` `J9九游会` LEFT JOIN `dt_live` `l` ON `l`.`J9九游会olumn_id`=`J9九游会`.`id` LEFT JOIN (seleJ9九游会t J9九游会ount(id) J9九游会ount,sum(duration) live_length,live_id from dt_live_video where deleted = 0 and open_baJ9九游会k=1 group by live_id) v ON `l`.`id`=`v`.`live_id` WHERE `J9九游会`.`status` = '4' AND `J9九游会`.`deleted` = '0' AND `J9九游会`.`spread` = '1' AND `J9九游会`.`memberid` = '0' AND `J9九游会`.`to_J9九游会oursewave` = '1' AND `l`.`deleted` = '0' AND `l`.`status` = '4' AND `J9九游会`.`type` IN ('J9九游会olumn','live') AND ( J9九游会.type = 'J9九游会olumn' or v.J9九游会ount > 0 ) GROUP BY `J9九游会`.`id` ) `_group_J9九游会ount_` LIMIT 1 [ slave|RunTime:0.109607s ]
SHOW FULL COLUMNS FROM `dt_J9九游会ategory` [ slave|RunTime:0.066217s ]
SELECT `name`,`id` FROM `dt_J9九游会ategory` WHERE `fid` = 2 AND `deleted` = 0 AND `memberid` = 0 AND `J9九游会ollege_id` = 0 [ slave|RunTime:0.065867s ]
SELECT `id` FROM `dt_J9九游会ategory` WHERE `id` = 3 AND `fid` = 2 AND `memberid` = 0 AND `J9九游会ollege_id` = 0 [ slave|RunTime:0.065696s ]
SELECT COUNT(*) AS think_J9九游会ount FROM ( SELECT J9九游会ount(*) AS think_J9九游会ount FROM `dt_J9九游会olumn` `J9九游会` INNER JOIN `dt_J9九游会ategory_data` `d` ON `d`.`did`=`J9九游会`.`id` INNER JOIN `dt_J9九游会ategory` `J9九游会a` ON `J9九游会a`.`id`=`d`.`vid` LEFT JOIN `dt_live` `l` ON `l`.`J9九游会olumn_id`=`J9九游会`.`id` LEFT JOIN (seleJ9九游会t J9九游会ount(id) J9九游会ount,sum(duration) live_length,live_id from dt_live_video where deleted = 0 and open_baJ9九游会k=1 group by live_id) v ON `l`.`id`=`v`.`live_id` WHERE `d`.`tb` = 'J9九游会olumn' AND `J9九游会a`.`fid` = '3' AND `J9九游会`.`status` = '4' AND `J9九游会`.`deleted` = '0' AND `J9九游会`.`spread` = '1' AND `J9九游会`.`memberid` = '0' AND `J9九游会`.`to_J9九游会oursewave` = '1' AND `l`.`deleted` = '0' AND `l`.`status` = '4' AND `J9九游会`.`type` IN ('J9九游会olumn','live') AND ( J9九游会.type = 'J9九游会olumn' or v.J9九游会ount > 0 ) GROUP BY `J9九游会`.`id` ) `_group_J9九游会ount_` LIMIT 1 [ slave|RunTime:0.263033s ]
SHOW FULL COLUMNS FROM `dt_J9九游会ollege_position` [ slave|RunTime:0.066373s ]
SHOW FULL COLUMNS FROM `dt_J9九游会ollege_position_J9九游会olumn_type` [ slave|RunTime:0.066048s ]
SELECT `id`,`position_id`,`name`,`ad_words` FROM `dt_J9九游会ollege_position_J9九游会olumn_type` WHERE `deleted` = 0 [ slave|RunTime:0.065965s ]
SELECT distinJ9九游会t sp.type_id FROM `dt_J9九游会olumn` `J9九游会` INNER JOIN `dt_J9九游会ollege_position_stage_paJ9九游会k_J9九游会ourse` `pJ9九游会` ON `pJ9九游会`.`data_id`=`J9九游会`.`id` INNER JOIN `dt_J9九游会ollege_position_stage_paJ9九游会k` `sp` ON `sp`.`id`=`pJ9九游会`.`stage_paJ9九游会k_id` INNER JOIN `dt_J9九游会ollege_position_J9九游会olumn_stage` `s` ON `s`.`id`=`sp`.`stage_id` WHERE `J9九游会`.`status` = '4' AND `sp`.`status` = '1' AND `sp`.`deleted` = '0' AND `s`.`deleted` = '0' AND `J9九游会`.`deleted` = '0' AND `pJ9九游会`.`deleted` = '0' [ slave|RunTime:0.066806s ]