Kissner's club radiko

リクエスト&メッセージ

REQUEST & MESSAGE

Kiss FM HOME DOCTOR(月)

放送時間
月 10:50~
SOUND CREW
公式サイト
https://www.kiss-fm.co.jp/pc2/home_doctor/

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

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

新規会員登録

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

お寄せいただいたメッセージは情報誌KissPRESSに掲載する場合がございます

※ 必須項目

PROGRAM
番組
Kiss FM HOME DOCTOR(月)
KISS NAME
Kissネーム
番組内で読まれる名前です
REQUEST ARTIST
リクエストアーティスト
REQUEST SONG
リクエスト曲
MESSAGE
メッセージ
GENDER
性別
AGE
年齢
半角数字
ADDRESS
都道府県
市町村区
OCCUPATION
ご職業
LISTENING METHOD
主にどこで聴いていますか?
主にどの方法で聴いてますか?
(default) 27 queries took 938 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `kissnersclubs`23231
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';110
3SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
4SHOW FULL COLUMNS FROM `prefs`220
5SHOW FULL COLUMNS FROM `jobs`220
6SHOW FULL COLUMNS FROM `sexes`220
7SELECT `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
8SELECT `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-10-18 03:19:15' AND ((`GuestEvent`.`release_end` >= '2021-10-18 03:19:15') 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` = 10) AND (`BroadcastDay`.`day` = 17) AND (LPAD(`BroadcastTime`.`broadcast_end`, 5, '0') > '27:19'))) OR (((`BroadcastDay`.`year` = 2021) AND (`BroadcastDay`.`month` = 10) AND (`BroadcastDay`.`day` = 18)))) ORDER BY `BroadcastDay`.`year` ASC, `BroadcastDay`.`month` ASC, `BroadcastDay`.`day` ASC, LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') ASC LIMIT 111343
9SHOW FULL COLUMNS FROM `program_presents`992
10SELECT `ProgramPresent`.`id` FROM `program_presents` AS `ProgramPresent` WHERE `ProgramPresent`.`program_id` = 247 AND `ProgramPresent`.`release_start` <= '2021-10-17 22:19:15' AND `ProgramPresent`.`release_end` >= '2021-10-17 22:19:15' 000
11SHOW FULL COLUMNS FROM `broadcast_times`881
12SELECT `Program`.*, `BroadcastTime`.* FROM `broadcast_times` AS `BroadcastTime` INNER JOIN programs AS `Program` ON (`Program`.`id` = `BroadcastTime`.`program_id` AND `Program`.`program_id` = '247' AND `Program`.`corner` = 1) WHERE `BroadcastTime`.`broadcast_day_id` = 4073 AND LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') <= '27:19' ORDER BY LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') DESC LIMIT 1000
13SHOW FULL COLUMNS FROM `banners`14141
14SHOW FULL COLUMNS FROM `presents`39391
15SHOW FULL COLUMNS FROM `require_member_flgs`220
16SHOW FULL COLUMNS FROM `visible_flgs`220
17SHOW FULL COLUMNS FROM `programs`34341
18SELECT `Sex`.`id`, `Sex`.`name` FROM `sexes` AS `Sex` WHERE 1 = 1 220
19SELECT `Job`.`id`, `Job`.`name` FROM `jobs` AS `Job` WHERE 1 = 1 15150
20SELECT `Pref`.`id`, `Pref`.`name` FROM `prefs` AS `Pref` WHERE 1 = 1 47470
21SHOW FULL COLUMNS FROM `spots`221
22SELECT `Spot`.`id`, `Spot`.`name` FROM `spots` AS `Spot` WHERE 1 = 1 550
23SHOW FULL COLUMNS FROM `listen_witches`220
24SELECT `ListenWitch`.`id`, `ListenWitch`.`name` FROM `listen_witches` AS `ListenWitch` WHERE 1 = 1 550
25SHOW FULL COLUMNS FROM `request_mails`26261
26SELECT `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` = '10') AND (`BroadcastDay`.`day` = '17'))) LEFT JOIN (select program_id,broadcast_day_id,broadcast_start,broadcast_end,0 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') <= '27:19' AND LPAD(`BroadcastTime`.`broadcast_end`,5,'0') > '27:19') 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 4848586
27SELECT `Program`.`id`, `Program`.`name`, `Program`.`request_mail`, `Program`.`present_flg` FROM `programs` AS `Program` WHERE `Program`.`id` = 436 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 1110