リクエスト&メッセージ radiko

リクエスト・メッセージ

REQUEST & MESSAGE

プレゼントが見つかりません

(default) 14 queries took 541 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `NowPlaying`.`id`, `NowPlaying`.`on_air_time`, `NowPlaying`.`artist`, `NowPlaying`.`song`, `NowPlaying`.`created`, `NowPlaying`.`modified` FROM `now_playings` AS `NowPlaying` WHERE `NowPlaying`.`id` = 1 LIMIT 1110
2SELECT `Sex`.`id`, `Sex`.`name` FROM `sexes` AS `Sex` WHERE 1 = 1 220
3SELECT `Job`.`id`, `Job`.`name` FROM `jobs` AS `Job` WHERE 1 = 1 15150
4SELECT `Pref`.`id`, `Pref`.`name` FROM `prefs` AS `Pref` WHERE 1 = 1 47470
5SHOW FULL COLUMNS FROM `spots`222
6SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
7SELECT `Spot`.`id`, `Spot`.`name` FROM `spots` AS `Spot` WHERE 1 = 1 550
8SHOW FULL COLUMNS FROM `listen_witches`220
9SELECT `ListenWitch`.`id`, `ListenWitch`.`name` FROM `listen_witches` AS `ListenWitch` WHERE 1 = 1 550
10SHOW FULL COLUMNS FROM `request_mails`26261
11SELECT `Program`.`id`, `Program`.`name`, `Program`.`catch_copy`, `Program`.`notice`, `Program`.`url`, `Program`.`soundcrew`, `Program`.`broadcast`, `Program`.`thumbnail`, `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` = '2022') AND (`BroadcastDay`.`month` = '08') AND (`BroadcastDay`.`day` = '09'))) LEFT JOIN (select program_id,broadcast_day_id,broadcast_start,broadcast_end,2 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') <= '19:07' AND LPAD(`BroadcastTime`.`broadcast_end`,5,'0') > '19:07') 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()) OR (`Program`.`id` = 2762) OR (`Program`.`id` = 2775))) AND (`Program`.`mail_type` > 0) AND (((`Program`.`release_end` is null) OR (`Program`.`release_end` >= CURDATE()) OR (((`Program`.`release_end` is not null) AND (`Program`.`release_end` >= CURDATE())))))) ORDER BY `Program`.`sort` ASC, `Program`.`id` ASC, `DefBroadcastTime`.`week` ASC 3636536
12SELECT `Program`.`id`, `Program`.`name`, `Program`.`request_mail`, `Program`.`present_flg`, `Program`.`thumbnail`, `ProgramPresent`.`name` FROM `programs` AS `Program` INNER JOIN program_presents AS `ProgramPresent` ON (((`ProgramPresent`.`id` = '3713') AND (`ProgramPresent`.`program_id` = `Program`.`id`) AND (`ProgramPresent`.`release_start` <= ADDTIME(NOW(), '-05:00:00')) AND (((`ProgramPresent`.`release_end` is null) OR (((`ProgramPresent`.`release_end` is not null) AND (`ProgramPresent`.`release_end` >= ADDTIME(NOW(), '-05:00:00')))))))) WHERE `Program`.`id` = 414 AND LENGTH(`Program`.`request_mail`) > 5 AND ((`Program`.`release_start` <= CURDATE()) OR (`Program`.`id` = 2762) OR (`Program`.`id` = 2775)) AND ((`Program`.`release_end` is null) OR (((`Program`.`release_end` is not null) AND (`Program`.`release_end` >= CURDATE())))) LIMIT 1001
13SHOW FULL COLUMNS FROM `program_presents`991
14SELECT `ProgramPresent`.`id`, `ProgramPresent`.`kind`, `ProgramPresent`.`program_id`, `ProgramPresent`.`name`, `ProgramPresent`.`description`, `ProgramPresent`.`release_start`, `ProgramPresent`.`release_end`, `ProgramPresent`.`created`, `ProgramPresent`.`modified` FROM `program_presents` AS `ProgramPresent` WHERE `id` = 3713 LIMIT 1110