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

ゲスト情報

GUEST

    Array
    (
        [0_0] => Array
            (
                [GuestEvent] => Array
                    (
                        [id] => 5314
                        [kind] => guest
                        [event_date] => 2020-11-09
                        [article_title] => 入野自由・GRANRODEO(コメント)
                        [description] => 放送日:11/9(月) 
    番組:4 SEASONS [text] => 10時台 入野自由、GRANDRODEOからメッセージが到着! ●入野自由  11月4日に3rdフルアルバム「Life is...」をリリース! オフィシャルサイト http://kiramune.jp/artist/irino/ ●GRANRODEO 11/4にGRANRODEO Singles Collection “RODEO BEAT SHAKE”をリリース! オフィシャルサイト https://granrodeo.net/ [artist_info] => [url] => [image0] => image15f8e93c410896.jpg [image0_caption] => [image1] => image25f8e93c721f45.jpg [image1_caption] => [image2] => [image2_caption] => [movie_youtube] => [sort_number] => 1 [toppage_disp_flg_id] => 1 [visible_flg_id] => 1 [release_start] => 2020-11-02 11:00:00 [release_end] => [period_flg] => 0 [modified] => 2020-10-20 16:37:47 [created] => 2020-10-20 16:01:27 [program_id] => 414 [guest_name] => 入野自由・GRANRODEO(コメント) [image] => Array ( [0] => /kiss_editor/img/guest/6800-6899/6881/image15f8e93c410896_resize.jpg [1] => /kiss_editor/img/guest/6800-6899/6881/image25f8e93c721f45_resize.jpg [2] => ) [event_date_array] => Array ( [0] => Array ( [y] => 2020 [m] => 11 [d] => 09 [day] => Mon [holiday] => ) ) ) [Program] => Array ( [id] => 414 [program_id] => 0 [name] => 4 SEASONS [same_information] => 4 SEASONS [catch_copy] => [notice] => 自然・歴史・グルメ…魅力に溢れた神戸の街で何よりも輝いているのが、この街を誇り、愛する「人」。神戸にはまだまだ知られていないこと、素敵な場所が隠されています。そんな神戸の街を紐とき、地元の方々にもご満足いただける情報をお伝えしていくのが、この「4 SEASONS」。皆様のライフスタイルを豊かに彩る番組を提供いたします。私たちが何より大切にしているのは、この街の知られざる魅力をふんだんにお届けし、その素晴らしさを改めて知っていただくこと。日々の生活を彩る心地よいサウンドと、神戸に精通したサウンドクルーが番組をナビゲート。神戸の美しい四季を、ラジオを通して受け止めてください。 [tp_title] => Kiss FM KOBE朝のワイドプログラム [tp_description] => ウィークデーの朝はここから始まる♪ 7:30~11:00 ON AIR 神戸・兵庫の四季を音楽と情報で彩るKiss FM KOBE朝のワイドプログラム サウンドクルー: 中野 耕史(月・火・水)、浜平 恭子(木・金) [tp_disp_mon] => 1 [tp_disp_tue] => 1 [tp_disp_wed] => 1 [tp_disp_thu] => 1 [tp_disp_fri] => 1 [tp_disp_sat] => 0 [tp_disp_sun] => 0 [url] => http://www.kiss-fm.co.jp/4seasons/ [mobile_url] => http://www.kiss-fm.co.jp/4seasons/ [corner] => 0 [request_mail] => 4_season_s@kiss-fm.co.jp [mail_type] => 1 [soundcrew] => 浜平 恭子(月・火)、クマガイタツロウ(水・木) [broadcast] => 毎週 月~木 7:30~11:00 [sort] => 1 [program_info] => 1 [radio_station] => 1 [present_flg] => 1 [release_start] => 2012-04-01 [release_end] => 2022-03-31 [radiko_contents1] => [radiko_contents2] => [message_flg] => 0 [thumbnail] => thumbnail.jpg [twitter] => kiss_4seasons [delete_flag] => 0 [created] => 2012-03-26 21:26:49 [modified] => 2022-04-01 00:48:19 ) [BroadcastDay] => Array ( [id] => 3728 [year] => 2020 [month] => 11 [day] => 9 [created] => 2020-10-27 00:00:01 [modified] => 2020-10-27 00:00:01 ) [BroadcastTime] => Array ( [broadcast_day_id] => 3728 [program_id] => 414 [broadcast_start] => 7:30 [broadcast_end] => 11:00 ) [Guest] => Array ( [id] => 6881 [event_guest_id] => 5314 [flow] => 1 [type] => 202 [room] => 0 [room_etc] => [name] => 入野自由・GRANRODEO(コメント) [guest_data] => [program_id] => 35 [user_id] => [onair_date] => 2020-11-09 [onair_date_multi] => 2020-11-09 [onair_time] => 10:00 [rec_date] => [rec_time] => [visit_time] => [release] => [msg] => [image1] => image15f8e93c410896.jpg [image2] => image25f8e93c721f45.jpg [image3] => [user_id_created] => 5 [user_id_modified] => 5 [open_flg] => 1 [delete_flg] => 0 [created] => 2020-10-20 16:01:27 [modified] => 2020-10-20 16:37:47 [buf_user_id] => [buf_user_id_created] => [buf_user_id_modified] => [buf_program_id] => ) [sort] => 2020-11-0907:3010:00 ) )
  • 2020.11.9 - Mon

    • 7:30 - 11:00

      4 SEASONS

      10時台

      入野自由・GRANRODEO(コメント)

(default) 20 queries took 1541 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
2SHOW FULL COLUMNS FROM `banners`15151
3SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
4SHOW FULL COLUMNS FROM `presents`39391
5SHOW FULL COLUMNS FROM `require_member_flgs`221
6SHOW FULL COLUMNS FROM `visible_flgs`220
7SHOW FULL COLUMNS FROM `programs`36361
8SELECT `GuestEvent`.*, `Program`.*, `BroadcastDay`.* FROM `guest_events` AS `GuestEvent` LEFT JOIN programs AS `Program` ON (`Program`.`id` = `GuestEvent`.`program_id`) LEFT JOIN broadcast_days AS `BroadcastDay` ON (`BroadcastDay`.`year` = DATE_FORMAT(RIGHT(`GuestEvent`.`event_date`,10), '%Y') AND `BroadcastDay`.`month` = DATE_FORMAT(RIGHT(`GuestEvent`.`event_date`,10), '%c') AND `BroadcastDay`.`day` = DATE_FORMAT(RIGHT(`GuestEvent`.`event_date`,10), '%e')) WHERE `GuestEvent`.`kind` = 'guest' AND `GuestEvent`.`visible_flg_id` = 1 AND `GuestEvent`.`release_start` <= '2022-05-29 10:47:01' AND `GuestEvent`.`id` = 5314 ORDER BY LEFT(`GuestEvent`.`event_date`, 10) ASC, `Program`.`sort` ASC, `GuestEvent`.`sort_number` DESC, `GuestEvent`.`release_start` DESC 111
9SELECT `BroadcastTime`.`id`, `BroadcastTime`.`program_id`, `BroadcastTime`.`broadcast_day_id`, `BroadcastTime`.`sponsor`, `BroadcastTime`.`broadcast_start`, `BroadcastTime`.`broadcast_end`, `BroadcastTime`.`created`, `BroadcastTime`.`modified` FROM `broadcast_times` AS `BroadcastTime` WHERE `BroadcastTime`.`broadcast_day_id` = 3728 AND `BroadcastTime`.`program_id` = 414 113
10SELECT `Banner`.`id`, `Banner`.`banner_type`, `Banner`.`word`, `Banner`.`url`, `Banner`.`image`, `Banner`.`image_l`, `Banner`.`popup_flg`, `Banner`.`release_start`, `Banner`.`release_end`, `Banner`.`visible_flg_id`, `Banner`.`delete_flag`, `Banner`.`sort_number`, `Banner`.`career_flg`, `Banner`.`modified`, `Banner`.`created` FROM `banners` AS `Banner` WHERE `visible_flg_id` = 1 AND `banner_type` = 5 AND `career_flg` = 0 AND `release_start` <= '2022-05-29 10:47:01' AND `release_end` >= '2022-05-29 10:47:01' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 991
11SELECT `Banner`.`id`, `Banner`.`banner_type`, `Banner`.`word`, `Banner`.`url`, `Banner`.`image`, `Banner`.`image_l`, `Banner`.`popup_flg`, `Banner`.`release_start`, `Banner`.`release_end`, `Banner`.`visible_flg_id`, `Banner`.`delete_flag`, `Banner`.`sort_number`, `Banner`.`career_flg`, `Banner`.`modified`, `Banner`.`created` FROM `banners` AS `Banner` WHERE `visible_flg_id` = 1 AND `banner_type` = 4 AND `career_flg` = 0 AND `release_start` <= '2022-05-29 10:47:01' AND `release_end` >= '2022-05-29 10:47:01' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 001
12SELECT `Banner`.`id`, `Banner`.`banner_type`, `Banner`.`word`, `Banner`.`url`, `Banner`.`image`, `Banner`.`image_l`, `Banner`.`popup_flg`, `Banner`.`release_start`, `Banner`.`release_end`, `Banner`.`visible_flg_id`, `Banner`.`delete_flag`, `Banner`.`sort_number`, `Banner`.`career_flg`, `Banner`.`modified`, `Banner`.`created` FROM `banners` AS `Banner` WHERE `visible_flg_id` = 1 AND `banner_type` = 2 AND `career_flg` = 0 AND `release_start` <= '2022-05-29 10:47:01' AND `release_end` >= '2022-05-29 10:47:01' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 17171
13SELECT `Banner`.`id`, `Banner`.`banner_type`, `Banner`.`word`, `Banner`.`url`, `Banner`.`image`, `Banner`.`image_l`, `Banner`.`popup_flg`, `Banner`.`release_start`, `Banner`.`release_end`, `Banner`.`visible_flg_id`, `Banner`.`delete_flag`, `Banner`.`sort_number`, `Banner`.`career_flg`, `Banner`.`modified`, `Banner`.`created` FROM `banners` AS `Banner` WHERE `visible_flg_id` = 1 AND `banner_type` = 3 AND `career_flg` = 0 AND `release_start` <= '2022-05-29 10:47:01' AND `release_end` >= '2022-05-29 10:47:01' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 001
14SELECT `Banner`.`id`, `Banner`.`banner_type`, `Banner`.`word`, `Banner`.`url`, `Banner`.`image`, `Banner`.`image_l`, `Banner`.`popup_flg`, `Banner`.`release_start`, `Banner`.`release_end`, `Banner`.`visible_flg_id`, `Banner`.`delete_flag`, `Banner`.`sort_number`, `Banner`.`career_flg`, `Banner`.`modified`, `Banner`.`created` FROM `banners` AS `Banner` WHERE `visible_flg_id` = 1 AND `banner_type` = 1 AND `career_flg` = 0 AND `release_start` <= '2022-05-29 10:47:01' AND `release_end` >= '2022-05-29 10:47:01' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 001
15SELECT `Present`.`id`, `Present`.`title`, `Present`.`capacity`, `Present`.`description`, `Present`.`text`, `Present`.`override_url`, `Present`.`client_name`, `Present`.`client_url`, `Present`.`img_main1`, `Present`.`img_main2`, `Present`.`img_main3`, `Present`.`img_main4`, `Present`.`img_main5`, `Present`.`img_main6`, `Present`.`img_main7`, `Present`.`img_main8`, `Present`.`img_main9`, `Present`.`img_main10`, `Present`.`img_caption1`, `Present`.`img_caption2`, `Present`.`img_caption3`, `Present`.`img_caption4`, `Present`.`img_caption5`, `Present`.`img_caption6`, `Present`.`img_caption7`, `Present`.`img_caption8`, `Present`.`img_caption9`, `Present`.`img_caption10`, `Present`.`img_thmb`, `Present`.`img_mobile`, `Present`.`start_datetime`, `Present`.`end_datetime`, `Present`.`require_member_flg_id`, `Present`.`popup_id`, `Present`.`visible_flg_id`, `Present`.`sort_number`, `Present`.`status_code`, `Present`.`modified`, `Present`.`created`, `require_member_flg`.`id`, `require_member_flg`.`name`, `visible_flg`.`id`, `visible_flg`.`name` FROM `presents` AS `Present` LEFT JOIN `require_member_flgs` AS `require_member_flg` ON (`Present`.`require_member_flg_id` = `require_member_flg`.`id`) LEFT JOIN `visible_flgs` AS `visible_flg` ON (`Present`.`visible_flg_id` = `visible_flg`.`id`) WHERE `visible_flg_id` = 1 AND `status_code` = 0 AND `start_datetime` <= '2022-05-29 10:47:01' AND `end_datetime` >= '2022-05-29 10:47:01' ORDER BY `Present`.`sort_number` ASC 552
16SHOW FULL COLUMNS FROM `news_flash_soap`19191
17SHOW FULL COLUMNS FROM `news_flash_category_where`661
18SELECT `NewsFlashCategoryWhere`.`id`, `NewsFlashCategoryWhere`.`category`, `NewsFlashCategoryWhere`.`gi_category`, `NewsFlashCategoryWhere`.`gi_subcategory`, `NewsFlashCategoryWhere`.`open_flg`, `NewsFlashCategoryWhere`.`sort` FROM `news_flash_category_where` AS `NewsFlashCategoryWhere` WHERE `open_flg` = 1 440
19SELECT `NewsFlashSoap`.*, `NewsFlashSoap2`.id FROM `news_flash_soap` AS `NewsFlashSoap` LEFT JOIN news_flash_soap AS `NewsFlashSoap2` ON (`NewsFlashSoap`.`document_id` = `NewsFlashSoap2`.`document_id` AND `NewsFlashSoap`.`id` < `NewsFlashSoap2`.`id`) WHERE `NewsFlashSoap`.`visible_flg_id` = 1 AND `NewsFlashSoap`.`created` <= '2022-05-29 10:47:01' AND `NewsFlashSoap`.`view_position` = 0 AND ((`NewsFlashSoap`.`limit_time` IS NULL) OR (`NewsFlashSoap`.`category` = 'WeatherEmergencyWarningsAndWarningsAndAdvisories') OR (((NOT (`NewsFlashSoap`.`limit_time` IS NULL)) AND (`NewsFlashSoap`.`limit_time` >= '2022-05-29 10:47:01')))) AND ((`NewsFlashSoap`.`category` = 'EvacuationOrder') OR (`NewsFlashSoap`.`category` = 'WeatherEmergencyWarningsAndWarningsAndAdvisories') OR (`NewsFlashSoap`.`category` = 'SeismicIntensityInformation') OR (`NewsFlashSoap`.`category` = 'EarthquakeAndSeismicIntensityInformation')) AND ((`NewsFlashSoap`.`area_name` Like '%兵庫県%') OR (`NewsFlashSoap`.`area_name` Like '%全国%')) AND `NewsFlashSoap2`.`id` IS NULL ORDER BY `NewsFlashSoap`.`created` DESC, `NewsFlashSoap`.`id` DESC 75751522
20SELECT `Program`.`id`, `Program`.`name`, `Program`.`same_information`, `Program`.`catch_copy`, `Program`.`notice`, `Program`.`soundcrew`, `Program`.`broadcast`, `Program`.`thumbnail`, `Program`.`url`, `Program`.`twitter`, `DefBroadcastTime`.`broadcast_start`, `DefBroadcastTime`.`broadcast_end`, `DefBroadcastTime`.`week`, `Soundcrew`.`id`, `Soundcrew`.`name`, `Soundcrew`.`name_kana` FROM `programs` AS `Program` 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` AND `Soundcrew`.`release_start` <= CURDATE() AND ((`Soundcrew`.`release_end` is null) OR (((`Soundcrew`.`release_end` is not null) AND (`Soundcrew`.`release_end` >= CURDATE()))))) WHERE ((`Program`.`corner` = 0) AND (`Program`.`program_info` > 0) AND (`Program`.`radio_station` = 1) AND (`Program`.`release_start` <= CURDATE()) AND (((`Program`.`release_end` is null) OR (((`Program`.`release_end` is not null) AND (`Program`.`release_end` >= CURDATE())))))) ORDER BY `Program`.`sort` ASC, `DefBroadcastTime`.`week` ASC, `Program`.`same_information` ASC, `Program`.`id` ASC 33332
(reg_db) 2 queries took 13 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` = 5314 LIMIT 1116
2SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` = (5314) 117