| 1 | SELECT `NowPlaying`.`id`, `NowPlaying`.`on_air_time`, `NowPlaying`.`artist`, `NowPlaying`.`song`, `NowPlaying`.`created`, `NowPlaying`.`modified` FROM `now_playings` AS `NowPlaying` WHERE `NowPlaying`.`id` = 1 LIMIT 1 | | 1 | 1 | 0 |
| 2 | SELECT `BroadcastDay`.*, `BroadcastTime`.*, `Program`.*, `subSoundcrew`.*, `subGuestEvent`.* FROM `broadcast_days` AS `BroadcastDay` INNER JOIN broadcast_times AS `BroadcastTime` ON (`BroadcastTime`.`broadcast_day_id` = `BroadcastDay`.`id`) INNER JOIN programs AS `Program` ON (`Program`.`id` = `BroadcastTime`.`program_id` AND `Program`.`corner` = 0) LEFT JOIN (SELECT `ProgramSoundcrew`.`broadcast_time_id`, group_concat(distinct `Soundcrew`.`name` SEPARATOR ",") AS soundcrew_name, group_concat(distinct `Soundcrew`.`id` SEPARATOR ",") AS soundcrew_id, group_concat(distinct `Soundcrew`.`sort` SEPARATOR ",") AS soundcrew_sort FROM soundcrews AS `Soundcrew` INNER JOIN program_soundcrews AS `ProgramSoundcrew` ON (`ProgramSoundcrew`.`soundcrew_id` = `Soundcrew`.`id`) WHERE 1 = 1 GROUP BY `ProgramSoundcrew`.`broadcast_time_id` ORDER BY `Soundcrew`.`sort` ASC ) AS `subSoundcrew` ON (`subSoundcrew`.`broadcast_time_id` = `BroadcastTime`.`id`) LEFT JOIN (SELECT `GuestEvent`.`program_id`, `GuestEvent`.`event_date`, group_concat(distinct `GuestEvent`.`guest_name` SEPARATOR ",") AS guest_event_name, group_concat(distinct `GuestEvent`.`id` SEPARATOR ",") AS guest_event_id FROM guest_events AS `GuestEvent` WHERE `GuestEvent`.`kind` = 'guest' AND `GuestEvent`.`visible_flg_id` = 1 AND `GuestEvent`.`release_start` <= '2021-11-27 18:06:06' AND ((`GuestEvent`.`release_end` >= '2021-11-27 18:06:06') OR (`GuestEvent`.`release_end` IS NULL)) GROUP BY `GuestEvent`.`program_id`, `GuestEvent`.`event_date` ORDER BY `GuestEvent`.`sort_number` ASC ) AS `subGuestEvent` ON (`subGuestEvent`.`program_id` = `Program`.`id` AND `subGuestEvent`.`event_date` Like CONCAT('%', date_format(CONCAT(`BroadcastDay`.`year`,'-',`BroadcastDay`.`month`,'-',`BroadcastDay`.`day`), '%Y-%m-%d'), '%')) WHERE ((((`BroadcastDay`.`year` = 2021) AND (`BroadcastDay`.`month` = 11) AND (`BroadcastDay`.`day` = 27) AND (LPAD(`BroadcastTime`.`broadcast_end`, 5, '0') > '18:06'))) OR (((`BroadcastDay`.`year` = 2021) AND (`BroadcastDay`.`month` = 11) AND (`BroadcastDay`.`day` = 28)))) ORDER BY `BroadcastDay`.`year` ASC, `BroadcastDay`.`month` ASC, `BroadcastDay`.`day` ASC, LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') ASC LIMIT 1 | | 1 | 1 | 626 |
| 3 | SELECT `ProgramPresent`.`id` FROM `program_presents` AS `ProgramPresent` WHERE `ProgramPresent`.`program_id` = 2515 AND `ProgramPresent`.`release_start` <= '2021-11-27 13:06:06' AND `ProgramPresent`.`release_end` >= '2021-11-27 13:06:06' | | 0 | 0 | 0 |
| 4 | SHOW FULL COLUMNS FROM `broadcast_times` | | 8 | 8 | 1 |
| 5 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | | 1 | 1 | 0 |
| 6 | SELECT `Program`.*, `BroadcastTime`.* FROM `broadcast_times` AS `BroadcastTime` INNER JOIN programs AS `Program` ON (`Program`.`id` = `BroadcastTime`.`program_id` AND `Program`.`program_id` = '2515' AND `Program`.`corner` = 1) WHERE `BroadcastTime`.`broadcast_day_id` = 4114 AND LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') <= '18:06' ORDER BY LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') DESC LIMIT 1 | | 0 | 0 | 0 |
| 7 | SELECT `Sex`.`id`, `Sex`.`name` FROM `sexes` AS `Sex` WHERE 1 = 1 | | 2 | 2 | 0 |
| 8 | SELECT `Job`.`id`, `Job`.`name` FROM `jobs` AS `Job` WHERE 1 = 1 | | 15 | 15 | 0 |
| 9 | SELECT `Pref`.`id`, `Pref`.`name` FROM `prefs` AS `Pref` WHERE 1 = 1 | | 47 | 47 | 0 |
| 10 | SHOW FULL COLUMNS FROM `spots` | | 2 | 2 | 1 |
| 11 | SELECT `Spot`.`id`, `Spot`.`name` FROM `spots` AS `Spot` WHERE 1 = 1 | | 5 | 5 | 0 |
| 12 | SHOW FULL COLUMNS FROM `listen_witches` | | 2 | 2 | 1 |
| 13 | SELECT `ListenWitch`.`id`, `ListenWitch`.`name` FROM `listen_witches` AS `ListenWitch` WHERE 1 = 1 | | 5 | 5 | 0 |
| 14 | SHOW FULL COLUMNS FROM `request_mails` | | 26 | 26 | 1 |
| 15 | SELECT `Program`.`id`, `Program`.`name`, `Program`.`catch_copy`, `Program`.`notice`, `Program`.`url`, `DefBroadcastTime`.`broadcast_start`, `DefBroadcastTime`.`broadcast_end`, `DefBroadcastTime`.`week`, `BroadcastTime`.`broadcast_start`, `BroadcastTime`.`broadcast_end`, `BroadcastTime`.`week`, `Soundcrew`.`id`, `Soundcrew`.`name` FROM `programs` AS `Program` INNER JOIN broadcast_days AS `BroadcastDay` ON (((`BroadcastDay`.`year` = '2021') AND (`BroadcastDay`.`month` = '11') AND (`BroadcastDay`.`day` = '27'))) LEFT JOIN (select program_id,broadcast_day_id,broadcast_start,broadcast_end,6 as week from broadcast_times) AS `BroadcastTime` ON (`BroadcastTime`.`broadcast_day_id` = `BroadcastDay`.`id` AND `BroadcastTime`.`program_id` = `Program`.`id` AND LPAD(`BroadcastTime`.`broadcast_start`,5,'0') <= '18:06' AND LPAD(`BroadcastTime`.`broadcast_end`,5,'0') > '18:06') LEFT JOIN def_broadcast_times AS `DefBroadcastTime` ON (`Program`.`id` = `DefBroadcastTime`.`program_id` AND `DefBroadcastTime`.`release_start` <= CURDATE() AND ((`DefBroadcastTime`.`release_end` is null) OR (((`DefBroadcastTime`.`release_end` is not null) AND (`DefBroadcastTime`.`release_end` >= CURDATE()))))) LEFT JOIN def_program_soundcrews AS `DefProgramSoundcrew` ON (`DefBroadcastTime`.`id` = `DefProgramSoundcrew`.`broadcast_time_id`) LEFT JOIN soundcrews AS `Soundcrew` ON (`DefProgramSoundcrew`.`soundcrew_id` = `Soundcrew`.`id`) WHERE ((LENGTH(`Program`.`request_mail`) > 5) AND (`Program`.`release_start` <= CURDATE()) AND (`Program`.`mail_type` > 0) AND (((`BroadcastTime`.`week` is not null) OR (`DefBroadcastTime`.`week` is not null) OR (`Program`.`message_flg` = 1)))) ORDER BY `Program`.`sort` ASC, `Program`.`id` ASC, `DefBroadcastTime`.`week` ASC | | 48 | 48 | 544 |
| 16 | SELECT `Program`.`id`, `Program`.`name`, `Program`.`request_mail`, `Program`.`present_flg` FROM `programs` AS `Program` WHERE `Program`.`id` = 2472 AND LENGTH(`Program`.`request_mail`) > 5 AND `Program`.`release_start` <= CURDATE() AND ((`Program`.`release_end` is null) OR (((`Program`.`release_end` is not null) AND (`Program`.`release_end` >= CURDATE())))) LIMIT 1 | | 1 | 1 | 0 |
