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

Saturday Junction

放送時間
毎週 土 11:00~12:55
SOUND CREW
藤原 岬
公式サイト
https://kiss-fm.co.jp/junction/

※ 必須項目

PROGRAM
番組
Saturday Junction
RADIO NAME
ラジオネーム
番組内で読まれる名前です
REQUEST ARTIST
リクエストアーティスト
REQUEST SONG
リクエスト曲
MESSAGE
メッセージ
GENDER
性別
AGE
年齢
半角数字
ADDRESS
都道府県
市町村区
OCCUPATION
ご職業
LISTENING METHOD
主にどこで聴いていますか?
主にどの方法で聴いてますか?
(default) 13 queries took 479 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `now_playings`661
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
3SELECT `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
4SELECT `Sex`.`id`, `Sex`.`name` FROM `sexes` AS `Sex` WHERE 1 = 1 220
5SELECT `Job`.`id`, `Job`.`name` FROM `jobs` AS `Job` WHERE 1 = 1 15150
6SELECT `Pref`.`id`, `Pref`.`name` FROM `prefs` AS `Pref` WHERE 1 = 1 47470
7SHOW FULL COLUMNS FROM `spots`221
8SELECT `Spot`.`id`, `Spot`.`name` FROM `spots` AS `Spot` WHERE 1 = 1 550
9SHOW FULL COLUMNS FROM `listen_witches`220
10SELECT `ListenWitch`.`id`, `ListenWitch`.`name` FROM `listen_witches` AS `ListenWitch` WHERE 1 = 1 550
11SHOW FULL COLUMNS FROM `request_mails`26261
12SELECT `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` = '05') AND (`BroadcastDay`.`day` = '21'))) 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') <= '6:02' AND LPAD(`BroadcastTime`.`broadcast_end`,5,'0') > '6:02') 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 4040476
13SELECT `Program`.`id`, `Program`.`name`, `Program`.`request_mail`, `Program`.`present_flg`, `Program`.`thumbnail` FROM `programs` AS `Program` WHERE `Program`.`id` = 2628 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 1110