Kissner's club radiko

ゲスト情報

GUEST

    Array
    (
        [0_0] => Array
            (
                [GuestEvent] => Array
                    (
                        [id] => 3172
                        [kind] => guest
                        [event_date] => 2017-09-19
                        [article_title] => コヤマシュウ(SCOOBIE DO)
    9/19(火) アットイーズ に登場!
                        [description] => 9/19(火) 11時30分からの アットイーズ に コヤマシュウ(SCOOBIE DO) が登場します!
                        [text] => 9/19(火) 11時30分からの アットイーズ コヤマシュウ(SCOOBIE DO) が登場します!
    
    質問・メッセージも受付中☆
    
    オフィシャルサイトはこちら
    http://www.scoobie-do.com/
                        [artist_info] => ~リリース情報~ 
    ●13枚目のニューアルバム『CRACKLACK』
     2017.10.04(水) 発売決定! 
    
    ~ライブ情報~ 
    「『CRACKLACK』発売記念インストアライヴ&サイン会」
    ■2017.11.02日(木)19:00 START タワーレコード梅田NU茶屋町店6F イベントスペース
    ※入場無料 
    
    「Funk-a-lismo! vol.11」 
    ■2017.11.28(火)OPEN19:00/START19:30 神戸太陽と虎 
                        [url] => 
                        [image0] => scoobiedo_20170915102810.jpg
                        [image0_caption] => 
                        [image1] => 
                        [image1_caption] => 
                        [image2] => 
                        [image2_caption] => 
                        [movie_youtube] => 
                        [sort_number] => 82908095
                        [toppage_disp_flg_id] => 1
                        [visible_flg_id] => 1
                        [release_start] => 2017-09-12 10:34:00
                        [release_end] => 2017-09-20 00:00:00
                        [period_flg] => 0
                        [modified] => 2017-09-22 16:33:06
                        [created] => 2017-09-12 10:49:09
                        [program_id] => 1571
                        [guest_name] => コヤマシュウ(SCOOBIE DO)
                        [image] => Array
                            (
                                [0] => /img/src/guest_event/scoobiedo_20170915102810.jpg
                                [1] => 
                                [2] => 
                            )
    
                        [event_date_array] => Array
                            (
                                [0] => Array
                                    (
                                        [y] => 2017
                                        [m] => 09
                                        [d] => 19
                                        [day] => Tue
                                        [holiday] => 
                                    )
    
                            )
    
                    )
    
                [Program] => Array
                    (
                        [id] => 
                        [program_id] => 
                        [name] => 
                        [same_information] => 
                        [catch_copy] => 
                        [notice] => 
                        [tp_title] => 
                        [tp_description] => 
                        [tp_disp_mon] => 
                        [tp_disp_tue] => 
                        [tp_disp_wed] => 
                        [tp_disp_thu] => 
                        [tp_disp_fri] => 
                        [tp_disp_sat] => 
                        [tp_disp_sun] => 
                        [url] => 
                        [mobile_url] => 
                        [corner] => 
                        [request_mail] => 
                        [mail_type] => 
                        [soundcrew] => 
                        [sort] => 
                        [program_info] => 
                        [radio_station] => 
                        [present_flg] => 
                        [release_start] => 
                        [release_end] => 
                        [radiko_contents1] => 
                        [radiko_contents2] => 
                        [message_flg] => 
                        [thumbnail] => 
                        [twitter] => 
                        [created] => 
                        [modified] => 
                    )
    
                [BroadcastDay] => Array
                    (
                        [id] => 2580
                        [year] => 2017
                        [month] => 9
                        [day] => 19
                        [created] => 2017-09-06 00:00:02
                        [modified] => 2017-09-06 00:00:02
                    )
    
                [BroadcastTime] => Array
                    (
                    )
    
                [Guest] => Array
                    (
                    )
    
            )
    
    )
    
  • 2017.9.19 - Tue

    • コヤマシュウ(SCOOBIE DO)

(default) 22 queries took 497 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `guest_events`25251
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
3SHOW FULL COLUMNS FROM `mailmag_pc_flgs`221
4SHOW FULL COLUMNS FROM `mailmag_mobile_flgs`220
5SHOW FULL COLUMNS FROM `htmlmail_flgs`220
6SHOW FULL COLUMNS FROM `now_playings`661
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-19 17:45:33' AND ((`GuestEvent`.`release_end` >= '2021-10-19 17:45:33') 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` = 19) AND (LPAD(`BroadcastTime`.`broadcast_end`, 5, '0') > '17:45'))) OR (((`BroadcastDay`.`year` = 2021) AND (`BroadcastDay`.`month` = 10) AND (`BroadcastDay`.`day` = 20)))) ORDER BY `BroadcastDay`.`year` ASC, `BroadcastDay`.`month` ASC, `BroadcastDay`.`day` ASC, LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') ASC LIMIT 111477
9SELECT `ProgramPresent`.`id` FROM `program_presents` AS `ProgramPresent` WHERE `ProgramPresent`.`program_id` = 3 AND `ProgramPresent`.`release_start` <= '2021-10-19 12:45:33' AND `ProgramPresent`.`release_end` >= '2021-10-19 12:45:33' 772
10SELECT `Program`.*, `BroadcastTime`.* FROM `broadcast_times` AS `BroadcastTime` INNER JOIN programs AS `Program` ON (`Program`.`id` = `BroadcastTime`.`program_id` AND `Program`.`program_id` = '3' AND `Program`.`corner` = 1) WHERE `BroadcastTime`.`broadcast_day_id` = 4075 AND LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') <= '17:45' ORDER BY LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') DESC LIMIT 1110
11SELECT `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` <= '2021-10-19 17:45:34' AND `GuestEvent`.`id` = 3172 ORDER BY LEFT(`GuestEvent`.`event_date`, 10) ASC, `Program`.`sort` ASC, `GuestEvent`.`sort_number` DESC, `GuestEvent`.`release_start` DESC 111
12SELECT `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` = 2580 AND `BroadcastTime`.`program_id` IS NULL 000
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`.`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` <= '2021-10-19 17:45:34' AND `release_end` >= '2021-10-19 17:45:34' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 991
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`.`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` <= '2021-10-19 17:45:34' AND `release_end` >= '2021-10-19 17:45:34' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 331
15SELECT `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`.`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` <= '2021-10-19 17:45:34' AND `release_end` >= '2021-10-19 17:45:34' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 19191
16SELECT `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`.`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` <= '2021-10-19 17:45:34' AND `release_end` >= '2021-10-19 17:45:34' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 001
17SELECT `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`.`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` <= '2021-10-19 17:45:34' AND `release_end` >= '2021-10-19 17:45:34' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 001
18SELECT `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` <= '2021-10-19 17:45:34' AND `end_datetime` >= '2021-10-19 17:45:34' ORDER BY `Present`.`sort_number` ASC 553
19SHOW FULL COLUMNS FROM `news_flash_soap`19191
20SHOW FULL COLUMNS FROM `news_flash_category_where`661
21SELECT `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
22SELECT `Program`.`id`, `Program`.`name`, `Program`.`same_information`, `Program`.`catch_copy`, `Program`.`notice`, `Program`.`soundcrew`, `Program`.`url`, `Program`.`twitter`, `DefBroadcastTime`.`broadcast_start`, `DefBroadcastTime`.`broadcast_end`, `DefBroadcastTime`.`week`, `Soundcrew`.`id`, `Soundcrew`.`name`, `Soundcrew`.`name_kana` FROM `programs` AS `Program` INNER 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 ((`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 42424
(reg_db) 2 queries took 21 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` = 3172 LIMIT 10010
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` = (3172) 0011