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

リクエスト&メッセージ

REQUEST & MESSAGE

アフター 純喫茶 山石

放送時間
毎週 日 20:30~20:55
SOUND CREW
ターザン山下、山本俊之、金澤佳世

Kissner's Club会員の方はこちら

自動入力をご利用頂けます

Kissner's Club会員以外の方もリクエストメッセージの投稿やプレゼント応募に参加できます

※ 必須項目

PROGRAM
番組
アフター 純喫茶 山石
Kiss NAME
Kissネーム
番組内で読まれる名前です
REQUEST ARTIST
リクエストアーティスト
REQUEST SONG
リクエスト曲
MESSAGE
メッセージ
GENDER
性別
AGE
年齢
半角数字
ADDRESS
都道府県
市町村区
OCCUPATION
ご職業
LISTENING METHOD
主にどこで聴いていますか?
主にどの方法で聴いてますか?
(default) 12 queries took 570 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 221
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`221
6SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
7SELECT `Spot`.`id`, `Spot`.`name` FROM `spots` AS `Spot` WHERE 1 = 1 550
8SHOW FULL COLUMNS FROM `listen_witches`221
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:01' AND LPAD(`BroadcastTime`.`broadcast_end`,5,'0') > '19:01') 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 3636564
12SELECT `Program`.`id`, `Program`.`name`, `Program`.`request_mail`, `Program`.`present_flg`, `Program`.`thumbnail` FROM `programs` AS `Program` WHERE `Program`.`id` = 2560 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 1111