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

イベント

EVENT

  • 2022.07.01 - Fri

    2022.08.31 - Wed

    Kiss FM KOBE第2回ラジオCMコンテスト

  • 2022.08.08 - Mon

    人気ロックバンド THE ORAL CIGARETTESを迎えて
    「Kiss Music Presenter FRIDAY」公開インタビュー収録決定!

  • 2022.07.31 - Sun

    Kiss FM KOBE × 神戸マツダイベントスクエア プレミアムライブ Vol.3 DEPAPEPE

  • 2022.07.10 - Sun

    20代から実践できる 将来のための資産形成セミナー

  • 2022.07.05 - Tue

    Kiss FM KOBE主催 松任谷由実 コンサートツアー 深海の街 姫路公演

  • 2022.07.08 - Fri

    2022.07.09 - Sat

    Kiss FM KOBE主催 松任谷由実 コンサートツアー 深海の街 神戸公演

  • 2022.07.29 - Fri

    2022.07.30 - Sat

    2022.07.31 - Sun

    Kiss FM KOBE協力 FUJI ROCK FESTIVAL’22

  • 2022.08.05 - Fri

    Kiss FM KOBE主催
    かつしかトリオ Liveツアー2022

  • Kiss FM KOBE 協力
    GET THE CLASSICS ASKA Premium Symphonic Concert 2022西宮公演

  • 2022.08.20 - Sat

    2022.08.21 - Sun

    Kiss FM KOBE協力 SUMMER SONIC 2022

  • 2022.09.02 - Fri

    2022.09.03 - Sat

    2022.09.04 - Sun

    Kiss FM KOBE協力
    ディズニー・オン・アイス JAPAN TOUR 35th ANNIVERSARY

  • 2022.09.29 - Thu

    Kiss FM KOBE主催
    山下達郎 PERFORMANCE 2022 姫路公演

  • 2022.10.17 - Mon

    Kiss FM KOBE後援 ノラ・ジョーンズ 大阪公演

  • 2022.11.02 - Wed

    2022.11.03 - Thu

    Kiss FM KOBE主催
    山下達郎 PERFORMANCE 2022 神戸公演

  • 2022.11.05 - Sat

    Kiss FM KOBE後援
    AIMYON 弾き語りLIVE 2022 -サーチライト- in 阪神甲子園球場

(reg_db) 4 queries took 5 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `informations`29291
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
3SELECT COUNT(*) AS `count` FROM `informations` AS `Information` WHERE `visible_flg_id` = 1 AND `delete_flag` = 0 AND `release_start` <= '2022-07-03 20:19:51' AND `release_end` >= '2022-07-03 20:19:51' AND `kind` = 'event' 112
4SELECT `Information`.`id`, `Information`.`kind`, `Information`.`event_date`, `Information`.`article_title`, `Information`.`description`, `Information`.`article_name`, `Information`.`text`, `Information`.`artist_info`, `Information`.`article_info`, `Information`.`override_url`, `Information`.`url`, `Information`.`image0`, `Information`.`image0_caption`, `Information`.`image1`, `Information`.`image1_caption`, `Information`.`image2`, `Information`.`image2_caption`, `Information`.`movie_youtube`, `Information`.`sort_number`, `Information`.`toppage_disp_flg_id`, `Information`.`visible_flg_id`, `Information`.`delete_flag`, `Information`.`release_start`, `Information`.`release_end`, `Information`.`period_flg`, `Information`.`modified`, `Information`.`created`, `Information`.`program_id`, `Information`.`guest_name` FROM `informations` AS `Information` WHERE `visible_flg_id` = 1 AND `delete_flag` = 0 AND `release_start` <= '2022-07-03 20:19:51' AND `release_end` >= '2022-07-03 20:19:51' AND `kind` = 'event' ORDER BY `sort_number` ASC, `id` DESC LIMIT 1515152
(default) 9 queries took 2 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 `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-07-03 20:19:51' AND `release_end` >= '2022-07-03 20:19:51' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 990
3SELECT `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-07-03 20:19:51' AND `release_end` >= '2022-07-03 20:19:51' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 000
4SELECT `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-07-03 20:19:51' AND `release_end` >= '2022-07-03 20:19:51' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 17170
5SELECT `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-07-03 20:19:51' AND `release_end` >= '2022-07-03 20:19:51' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 000
6SELECT `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-07-03 20:19:51' AND `release_end` >= '2022-07-03 20:19:51' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 000
7SELECT `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-07-03 20:19:51' AND `end_datetime` >= '2022-07-03 20:19:51' ORDER BY `Present`.`sort_number` ASC 770
8SELECT `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
9SELECT `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 30302