Array
(
[title] => 川田 一輝
[keywords] => 川田 一輝,サウンドクルー,DJ
[description] =>
[soundcrews] => Array
(
[0] => Array
(
[id] => 24
[name] => 川田 一輝
[name_kana] => かわた かずき
[message] => 大阪生まれ西宮育ち。学生時代からアカペラを始めとする歌や音楽が大好きで「もっと声で人に喜んでもらいたい」その思いで今はラジオで喋っています♪別名"爽やか趣味人"。バンド活動やロードバイク、卓球、神戸の街ブラなど。今は毎週釣りに行き、あらゆる魚料理にチャレンジ！美味しい魚の見分け方教えますよー！目指せ"神戸のお兄ちゃん"番組はもちろん、街で見かけても「Kissの川ちゃーん！」気軽に声かけてね♪アナタと1番近いサウンドクルーへ。
[history] =>
[favorites] =>
[url] =>
[blog] =>
[twitter] =>
[birthday] => 05/15
[zodiac] => おうし座
[blood] => B
[Program] => Array
(
[0] => Array
(
[id] => 2499
[name] => Kiss Music Presenter スパシャン FRIDAY
[same_information] => Kiss Music Presenter スパシャン FRIDAY
[catch_copy] =>
[notice] => Kiss FM KOBE 夕方の看板番組が金曜日に拡大！今聴きたいリクエスト曲を軽快なトークと共にテンポよくオンエア。旬のアーティストや今後活躍が期待される関西在住のアーティストの楽曲・インタビュー・メッセージを紹介する3時間のミュージックプログラム。
[url] => http://www.kiss-fm.co.jp/program_blog/presenter/
[request_mail] => k_m_presen_ter@kiss-fm.co.jp
[mail_type] => 1
[image_data] => Array
(
[path] => /home/kiss-fm.co.jp/public_html/www.kiss-fm.co.jp/img/src/program/2499
[name] => thumbnail.jpg
[src] => https://www.kiss-fm.co.jp/img/src/program/2499/thumbnail.jpg
)
[week] => Array
(
[0] => Array
(
[week] => 金
[week_time] => 16:00～19:00
)
)
[week_cnt] => 1
)
)
[image] => Array
(
[illust] => /img/src/soundcrew/24/illust.jpg
[icon] => /img/src/soundcrew/24/icon.jpg
)
)
)
)
SOUND CREW
かわた かずき
大阪生まれ西宮育ち。学生時代からアカペラを始めとする歌や音楽が大好きで「もっと声で人に喜んでもらいたい」その思いで今はラジオで喋っています♪別名"爽やか趣味人"。バンド活動やロードバイク、卓球、神戸の街ブラなど。今は毎週釣りに行き、あらゆる魚料理にチャレンジ！美味しい魚の見分け方教えますよー！目指せ"神戸のお兄ちゃん"番組はもちろん、街で見かけても「Kissの川ちゃーん！」気軽に声かけてね♪アナタと1番近いサウンドクルーへ。
Kiss Music Presenter スパシャン FRIDAY
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `NowPlaying`.`id`, `NowPlaying`.`on_air_time`, `NowPlaying`.`artist`, `NowPlaying`.`song`, `NowPlaying`.`created`, `NowPlaying`.`modified` FROM `now_playings` AS `NowPlaying` WHERE `NowPlaying`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
| 2 | SELECT `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-21 14:08:16' AND ((`GuestEvent`.`release_end` >= '2021-10-21 14:08:16') 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` = 21) AND (LPAD(`BroadcastTime`.`broadcast_end`, 5, '0') > '14:08'))) OR (((`BroadcastDay`.`year` = 2021) AND (`BroadcastDay`.`month` = 10) AND (`BroadcastDay`.`day` = 22)))) ORDER BY `BroadcastDay`.`year` ASC, `BroadcastDay`.`month` ASC, `BroadcastDay`.`day` ASC, LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') ASC LIMIT 1 | 1 | 1 | 414 | |
| 3 | SELECT `ProgramPresent`.`id` FROM `program_presents` AS `ProgramPresent` WHERE `ProgramPresent`.`program_id` = 2626 AND `ProgramPresent`.`release_start` <= '2021-10-21 09:08:16' AND `ProgramPresent`.`release_end` >= '2021-10-21 09:08:16' | 2 | 2 | 0 | |
| 4 | SELECT `Program`.*, `BroadcastTime`.* FROM `broadcast_times` AS `BroadcastTime` INNER JOIN programs AS `Program` ON (`Program`.`id` = `BroadcastTime`.`program_id` AND `Program`.`program_id` = '2626' AND `Program`.`corner` = 1) WHERE `BroadcastTime`.`broadcast_day_id` = 4077 AND LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') <= '14:08' ORDER BY LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') DESC LIMIT 1 | 1 | 1 | 0 | |
| 5 | SELECT `Soundcrew`.`id`, `Soundcrew`.`name`, `Soundcrew`.`name_kana`, `Soundcrew`.`message`, `Soundcrew`.`history`, `Soundcrew`.`favorites`, `Soundcrew`.`url`, `Soundcrew`.`blog`, `Soundcrew`.`twitter`, `Soundcrew`.`birthday`, `Zodiac`.`name`, `Blood`.`name`, `DefBroadcastTime`.`week`, `DefBroadcastTime`.`broadcast_start`, `DefBroadcastTime`.`broadcast_end`, `Program`.`id`, `Program`.`name`, `Program`.`same_information`, `Program`.`catch_copy`, `Program`.`notice`, `Program`.`url`, `Program`.`request_mail`, `Program`.`mail_type` FROM `soundcrews` AS `Soundcrew` LEFT JOIN zodiacs AS `Zodiac` ON (`Zodiac`.`id` = `Soundcrew`.`zodiac_id`) LEFT JOIN bloods AS `Blood` ON (`Blood`.`id` = `Soundcrew`.`blood_id`) INNER JOIN def_program_soundcrews AS `DefProgramSoundcrew` ON (`Soundcrew`.`id` = `DefProgramSoundcrew`.`soundcrew_id`) LEFT JOIN def_broadcast_times AS `DefBroadcastTime` ON (`DefBroadcastTime`.`id` = `DefProgramSoundcrew`.`broadcast_time_id`) INNER JOIN programs AS `Program` ON (`Program`.`id` = `DefBroadcastTime`.`program_id`) WHERE ((`Soundcrew`.`radio_station` = 1) AND (`Soundcrew`.`id` != 42) AND (`Soundcrew`.`release_start` <= CURDATE()) AND (((`Soundcrew`.`release_end` is null) OR (((`Soundcrew`.`release_end` is not null) AND (`Soundcrew`.`release_end` >= CURDATE())))))) ORDER BY `Soundcrew`.`sort` ASC, `Program`.`sort` ASC, `DefBroadcastTime`.`week` ASC, `DefBroadcastTime`.`broadcast_start` ASC | 29 | 29 | 2 |