スケジュール - 千葉県学童保育連絡協議会

カレンダー

2018年 12月7日(金)

今日へ

予定一覧

タイムライン

公開情報

戻る

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgent359d31d6737416e23d489d7c778cb8fe
  time1571611897
  countdown10
  languageja
- setting(false)
- _Token(array)
  keye77372b67f68329c7ba72207456931392f53b5ce930294187dbfa080c92dfe8e884a92c16f09d5863ffbb354eff9ff3c6c047fd246fc53f64815a14afc39758c
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  e77372b67f68329c7ba72207456931392f53b5ce930294187dbfa080c92dfe8e884a92c16f09d5863ffbb354eff9ff3c6c047fd246fc53f64815a14afc39758c1571608298
- 359d31d6737416e23d489d7c778cb8fecalendars(array)
  17/calendars/calendars/index?year=2018&month=12&day=7&style=daily&tab=list&frame_id=17
====
Request
+
Request

Cake Params
- plugincalendars
- controllercalendars
- actionindex
- named(empty)
- pass(empty)
- isAjax(false)
- _Token(array)
  keye77372b67f68329c7ba72207456931392f53b5ce930294187dbfa080c92dfe8e884a92c16f09d5863ffbb354eff9ff3c6c047fd246fc53f64815a14afc39758c
  unlockedFields(empty)
Post data

No post data.

Query string
- year2018
- month12
- day7
- styledaily
- tablist
- frame_id17
Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(array)
  0controller
  1action
- options(array)
  key[a-zA-Z0-9_]+
- defaults(array)
  plugincalendars
- template/calendars/:controller/:action
====

Sql Log

Sql Logs

master

Total Time: 11 ms
Total Queries: 75 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Page`.`weight` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE `Page`.`id` = 4 LIMIT 1	1	1	0
SELECT `Frame`.`id`, `Frame`.`room_id`, `Frame`.`box_id`, `Frame`.`plugin_key`, `Frame`.`block_id`, `Frame`.`key`, `Frame`.`header_type`, `Frame`.`weight`, `Frame`.`is_deleted`, `Frame`.`default_action`, `Frame`.`default_setting_action`, `FramePublicLanguage`.`id`, `FramePublicLanguage`.`language_id`, `FramePublicLanguage`.`frame_id`, `FramePublicLanguage`.`is_public`, `FramesLanguage`.`id`, `FramesLanguage`.`language_id`, `FramesLanguage`.`frame_id`, `FramesLanguage`.`name`, `FramesLanguage`.`is_origin`, `FramesLanguage`.`is_translation`, `FramesLanguage`.`is_original_copy`, `Block`.`id`, `Block`.`room_id`, `Block`.`plugin_key`, `Block`.`key`, `Block`.`public_type`, `Block`.`publish_start`, `Block`.`publish_end`, `Block`.`content_count`, `BlocksLanguage`.`language_id`, `BlocksLanguage`.`block_id`, `BlocksLanguage`.`name`, `BlocksLanguage`.`is_origin`, `BlocksLanguage`.`is_translation`, `BlocksLanguage`.`is_original_copy` FROM `LAA0857082-chibagakudo`.`nc3_frames` AS `Frame` INNER JOIN `LAA0857082-chibagakudo`.`nc3_frame_public_languages` AS `FramePublicLanguage` ON (`FramePublicLanguage`.`frame_id` = `Frame`.`id` AND `FramePublicLanguage`.`language_id` IN ('0', '2') AND `FramePublicLanguage`.`is_public` = '1') INNER JOIN `LAA0857082-chibagakudo`.`nc3_frames_languages` AS `FramesLanguage` ON (`FramesLanguage`.`frame_id` = `Frame`.`id` AND `FramesLanguage`.`language_id` = '2') LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks` AS `Block` ON (`Frame`.`block_id` = `Block`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND `BlocksLanguage`.`language_id` = '2') WHERE `Frame`.`id` = 17 LIMIT 1	1	1	0
SELECT `Box`.`id`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id` FROM `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` WHERE `Box`.`id` = 150 LIMIT 1	1	1	0
SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`weight`, `Page`.`sort_key`, `Page`.`child_count`, `Page`.`permalink`, `Page`.`slug`, `Page`.`is_container_fluid`, `Page`.`theme` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE `Page`.`id` = 15 LIMIT 1	1	1	0
SELECT `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`active`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` WHERE `id` = 11 LIMIT 1	1	1	0
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name` FROM `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` WHERE `room_id` = 11 AND `language_id` = 2 LIMIT 1	1	1	0
SELECT `PagesLanguage`.`id`, `PagesLanguage`.`language_id`, `PagesLanguage`.`page_id`, `PagesLanguage`.`name`, `PagesLanguage`.`meta_title`, `PagesLanguage`.`meta_description`, `PagesLanguage`.`meta_keywords`, `PagesLanguage`.`meta_robots` FROM `LAA0857082-chibagakudo`.`nc3_pages_languages` AS `PagesLanguage` WHERE `PagesLanguage`.`page_id` = 15 AND `PagesLanguage`.`language_id` = 2 LIMIT 1	1	1	0
SELECT `PluginsRoom`.`plugin_key` FROM `LAA0857082-chibagakudo`.`nc3_plugins_rooms` AS `PluginsRoom` WHERE `room_id` = 11	4	4	0
SELECT `BlockRolePermission`.`id`, `BlockRolePermission`.`roles_room_id`, `BlockRolePermission`.`block_key`, `BlockRolePermission`.`permission`, `BlockRolePermission`.`value` FROM `LAA0857082-chibagakudo`.`nc3_block_role_permissions` AS `BlockRolePermission` WHERE block_key = ('8219470cdd5c03712901243e3e449645') AND `roles_room_id` IS NULL	0	0	0
SELECT `BlockSetting`.`block_key`, `BlockSetting`.`field_name`, `BlockSetting`.`value` FROM `LAA0857082-chibagakudo`.`nc3_block_settings` AS `BlockSetting` WHERE `room_id` = 11 AND block_key = ('8219470cdd5c03712901243e3e449645') AND `field_name` IN ('use_workflow', 'use_comment_approval')	1	1	0
SELECT `PageContainer`.`id`, `PageContainer`.`page_id`, `PageContainer`.`container_type`, `PageContainer`.`is_published`, `PageContainer`.`is_configured` FROM `LAA0857082-chibagakudo`.`nc3_page_containers` AS `PageContainer` WHERE `PageContainer`.`page_id` = 15	5	5	0
SELECT `BoxesPageContainer`.`id`, `BoxesPageContainer`.`page_container_id`, `BoxesPageContainer`.`page_id`, `BoxesPageContainer`.`container_type`, `BoxesPageContainer`.`box_id`, `BoxesPageContainer`.`is_published`, `BoxesPageContainer`.`weight`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`weight`, `Room`.`sort_key`, `Room`.`child_count`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `RoomsLanguage`.`id`, `RoomsLanguage`.`name` FROM `LAA0857082-chibagakudo`.`nc3_boxes_page_containers` AS `BoxesPageContainer` INNER JOIN `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` ON (`Box`.`id` = `BoxesPageContainer`.`box_id`) INNER JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Box`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` ON (`RoomsLanguage`.`language_id` = '2' AND `Room`.`id` = `RoomsLanguage`.`room_id`) WHERE `BoxesPageContainer`.`page_container_id` IN (71, 72, 73, 74, 75) AND `BoxesPageContainer`.`is_published` = '1' ORDER BY `BoxesPageContainer`.`page_container_id` ASC, `BoxesPageContainer`.`weight` ASC	5	5	0
SELECT `Frame`.`id`, `Frame`.`room_id`, `Frame`.`box_id`, `Frame`.`plugin_key`, `Frame`.`block_id`, `Frame`.`key`, `Frame`.`header_type`, `Frame`.`weight`, `Frame`.`is_deleted`, `Frame`.`default_action`, `Frame`.`default_setting_action`, `FramePublicLanguage`.`id`, `FramePublicLanguage`.`language_id`, `FramePublicLanguage`.`frame_id`, `FramePublicLanguage`.`is_public`, `FramesLanguage`.`id`, `FramesLanguage`.`language_id`, `FramesLanguage`.`frame_id`, `FramesLanguage`.`name`, `FramesLanguage`.`is_origin`, `FramesLanguage`.`is_translation`, `FramesLanguage`.`is_original_copy`, `Block`.`id`, `Block`.`room_id`, `Block`.`plugin_key`, `Block`.`key`, `Block`.`public_type`, `Block`.`publish_start`, `Block`.`publish_end`, `Block`.`content_count`, `BlocksLanguage`.`language_id`, `BlocksLanguage`.`block_id`, `BlocksLanguage`.`name`, `BlocksLanguage`.`is_origin`, `BlocksLanguage`.`is_translation`, `BlocksLanguage`.`is_original_copy` FROM `LAA0857082-chibagakudo`.`nc3_frames` AS `Frame` INNER JOIN `LAA0857082-chibagakudo`.`nc3_frame_public_languages` AS `FramePublicLanguage` ON (`FramePublicLanguage`.`frame_id` = `Frame`.`id` AND `FramePublicLanguage`.`language_id` IN ('0', '2') AND `FramePublicLanguage`.`is_public` = '1') INNER JOIN `LAA0857082-chibagakudo`.`nc3_frames_languages` AS `FramesLanguage` ON (`FramesLanguage`.`frame_id` = `Frame`.`id` AND `FramesLanguage`.`language_id` = '2') LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks` AS `Block` ON (`Frame`.`block_id` = `Block`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND `BlocksLanguage`.`language_id` = '2') WHERE `Frame`.`box_id` IN (17, 18, 150, 19, 20) AND `Frame`.`is_deleted` = '0' ORDER BY `Frame`.`box_id` ASC, `Frame`.`is_deleted` ASC, `Frame`.`weight` ASC	2	2	0
SELECT `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`active`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` WHERE id = (1)	1	1	0
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name` FROM `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` WHERE `room_id` = 1 AND `language_id` = 2 LIMIT 1	1	1	0
SELECT `Page`.`sort_key` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE `Page`.`id` = 15 LIMIT 1	1	1	0
SELECT `Page`.`id` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE 1 = 1 AND `Page`.`sort_key` IN ('~00000001', '~00000001-00000005') ORDER BY `Page`.`sort_key` asc	2	2	0
SELECT `Page`.`theme` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE `id` IN (1, 15) AND `theme` IS NOT NULL ORDER BY `sort_key` desc LIMIT 1	0	0	0
SELECT `Room`.`sort_key` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` WHERE `Room`.`id` = 11 LIMIT 1	1	1	0
SELECT `Room`.`id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` WHERE 1 = 1 AND `Room`.`sort_key` IN ('~00000001', '~00000001-00000001', '~00000001-00000001-00000004') ORDER BY `Room`.`sort_key` asc	3	3	0
SELECT `Room`.`theme` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` WHERE `id` IN (4, 1, 11) AND `theme` IS NOT NULL ORDER BY `sort_key` desc LIMIT 1	1	1	0
SELECT `CalendarFrameSetting`.`id`, `CalendarFrameSetting`.`frame_key`, `CalendarFrameSetting`.`display_type`, `CalendarFrameSetting`.`start_pos`, `CalendarFrameSetting`.`display_count`, `CalendarFrameSetting`.`is_myroom`, `CalendarFrameSetting`.`is_select_room`, `CalendarFrameSetting`.`timeline_base_time`, `CalendarFrameSetting`.`created_user`, `CalendarFrameSetting`.`created`, `CalendarFrameSetting`.`modified_user`, `CalendarFrameSetting`.`modified`, `Frame`.`id`, `Frame`.`room_id`, `Frame`.`box_id`, `Frame`.`plugin_key`, `Frame`.`block_id`, `Frame`.`key`, `Frame`.`header_type`, `Frame`.`weight`, `Frame`.`is_deleted`, `Frame`.`default_action`, `Frame`.`default_setting_action`, `Frame`.`created_user`, `Frame`.`created`, `Frame`.`modified_user`, `Frame`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `LAA0857082-chibagakudo`.`nc3_calendar_frame_settings` AS `CalendarFrameSetting` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frames` AS `Frame` ON (`CalendarFrameSetting`.`frame_key` = `Frame`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`CalendarFrameSetting`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`CalendarFrameSetting`.`modified_user` = `TrackableUpdater`.`id`) WHERE `frame_key` = '1a59a3167e70d1248c021b20b4f2e34a' LIMIT 1	1	1	1
SELECT `CalendarFrameSettingSelectRoom`.`id`, `CalendarFrameSettingSelectRoom`.`calendar_frame_setting_id`, `CalendarFrameSettingSelectRoom`.`room_id`, `CalendarFrameSettingSelectRoom`.`created_user`, `CalendarFrameSettingSelectRoom`.`created`, `CalendarFrameSettingSelectRoom`.`modified_user`, `CalendarFrameSettingSelectRoom`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_calendar_frame_setting_select_rooms` AS `CalendarFrameSettingSelectRoom` WHERE `CalendarFrameSettingSelectRoom`.`calendar_frame_setting_id` = (1) ORDER BY `id` ASC	0	0	1	maybe slow
SELECT `Room`.`space_id`, `Room`.`id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` WHERE `space_id` = 1	1	1	1
SELECT `Room`.`space_id`, `Room`.`id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` WHERE `parent_id` = 4	3	3	1	maybe slow
SELECT `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`weight`, `Room`.`sort_key`, `Room`.`child_count`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `Space`.`id`, `Space`.`parent_id`, `Space`.`lft`, `Space`.`rght`, `Space`.`type`, `Space`.`plugin_key`, `Space`.`default_setting_action`, `Space`.`room_disk_size`, `Space`.`room_id_root`, `Space`.`page_id_top`, `Space`.`permalink`, `Space`.`is_m17n`, `Space`.`after_user_save_model`, `Space`.`created_user`, `Space`.`created`, `Space`.`modified_user`, `Space`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) WHERE `Room`.`parent_id` = 4 ORDER BY `Room`.`sort_key` ASC	3	3	1	maybe slow
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` IN (1, 2, 3)	6	6	0
SELECT * FROM `LAA0857082-chibagakudo`.`nc3_roles_rooms` AS `RolesRoom` INNER JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoomsUser`.`user_id` IS NULL) WHERE `RolesRoom`.`room_id` IN (1, 2)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = 2 AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC	6	6	0
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` IN (1, 7, 9, 10, 11, 15)	7	7	0
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` IN (1, 7, 9, 10, 11, 15)	5	5	0
SELECT `Room`.`id`, `Room`.`parent_id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` WHERE `Room`.`id` IN (1, 1, 7, 9, 10, 11, 15) AND 1 = 1 ORDER BY `Room`.`sort_key` asc	6	6	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC	6	6	0
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` IN (1, 7, 9, 10, 11, 15)	7	7	0
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` IN (1, 7, 9, 10, 11, 15)	5	5	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = 4 AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC	2	2	0
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` IN (13, 14)	2	2	0
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` IN (13, 14)	0	0	0
SELECT `Room`.`id`, `Room`.`parent_id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` WHERE `Room`.`id` IN (3, 13, 14) AND 1 = 1 ORDER BY `Room`.`sort_key` asc	3	3	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC	6	6	0
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` IN (1, 7, 9, 10, 11, 15)	7	7	0
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` IN (1, 7, 9, 10, 11, 15)	5	5	0
SELECT `RolesRoomsUser`.`id`, `RolesRoomsUser`.`roles_room_id`, `RolesRoomsUser`.`user_id`, `RolesRoomsUser`.`room_id`, `RolesRoomsUser`.`access_count`, `RolesRoomsUser`.`last_accessed`, `RolesRoom`.`id`, `RolesRoom`.`room_id`, `RolesRoom`.`role_key`, `Room`.* FROM `LAA0857082-chibagakudo`.`nc3_roles_rooms_users` AS `RolesRoomsUser` INNER JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id) INNER JOIN `LAA0857082-chibagakudo`.`nc3_room_roles` AS `RoomRole` ON (`RoomRole`.`role_key` = RolesRoom .role_key) INNER JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`RolesRoom`.`room_id` = Room .id) INNER JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `User` ON (`RolesRoomsUser`.`user_id` = User .id) WHERE NOT (`Room`.`page_id_top` IS NULL) AND `RolesRoomsUser`.`user_id` IS NULL AND `RolesRoomsUser`.`room_id` IN (1, 7, 9, 10, 11, 15)	0	0	1	maybe slow
SELECT `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`weight`, `Room`.`sort_key`, `Room`.`child_count`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` WHERE `Room`.`id` IN (1, 7, 9, 10, 11, 15) ORDER BY `Room`.`id` ASC	6	6	0
SELECT `RoomsLanguages`.`id`, `RoomsLanguages`.`language_id`, `RoomsLanguages`.`is_origin`, `RoomsLanguages`.`is_translation`, `RoomsLanguages`.`is_original_copy`, `RoomsLanguages`.`room_id`, `RoomsLanguages`.`name`, `RoomsLanguages`.`created_user`, `RoomsLanguages`.`created`, `RoomsLanguages`.`modified_user`, `RoomsLanguages`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguages` WHERE `room_id` IN (1, 7, 9, 10, 11, 15) AND `language_id` = 2	6	6	1	maybe slow
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = 2 AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC	6	6	0
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` IN (1, 7, 9, 10, 11, 15)	7	7	0
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` IN (1, 7, 9, 10, 11, 15)	5	5	0
SELECT `Room`.`id`, `Room`.`parent_id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` WHERE `Room`.`id` IN (1, 1, 7, 9, 10, 11, 15) AND 1 = 1 ORDER BY `Room`.`sort_key` asc	6	6	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC	6	6	0
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` IN (1, 7, 9, 10, 11, 15)	7	7	0
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` IN (1, 7, 9, 10, 11, 15)	5	5	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = 4 AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC	2	2	0
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` IN (13, 14)	2	2	0
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` IN (13, 14)	0	0	0
SELECT `Room`.`id`, `Room`.`parent_id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` WHERE `Room`.`id` IN (3, 13, 14) AND 1 = 1 ORDER BY `Room`.`sort_key` asc	3	3	0
SELECT `CalendarEvent`.`id`, `CalendarEvent`.`calendar_rrule_id`, `CalendarEvent`.`key`, `CalendarEvent`.`room_id`, `CalendarEvent`.`language_id`, `CalendarEvent`.`is_origin`, `CalendarEvent`.`is_translation`, `CalendarEvent`.`is_original_copy`, `CalendarEvent`.`target_user`, `CalendarEvent`.`title`, `CalendarEvent`.`title_icon`, `CalendarEvent`.`location`, `CalendarEvent`.`contact`, `CalendarEvent`.`description`, `CalendarEvent`.`is_allday`, `CalendarEvent`.`start_date`, `CalendarEvent`.`start_time`, `CalendarEvent`.`dtstart`, `CalendarEvent`.`end_date`, `CalendarEvent`.`end_time`, `CalendarEvent`.`dtend`, `CalendarEvent`.`timezone_offset`, `CalendarEvent`.`status`, `CalendarEvent`.`is_active`, `CalendarEvent`.`is_latest`, `CalendarEvent`.`recurrence_event_id`, `CalendarEvent`.`exception_event_id`, `CalendarEvent`.`is_enable_mail`, `CalendarEvent`.`email_send_timing`, `CalendarEvent`.`created_user`, `CalendarEvent`.`created`, `CalendarEvent`.`modified_user`, `CalendarEvent`.`modified`, `CalendarRrule`.`id`, `CalendarRrule`.`calendar_id`, `CalendarRrule`.`key`, `CalendarRrule`.`name`, `CalendarRrule`.`rrule`, `CalendarRrule`.`icalendar_uid`, `CalendarRrule`.`icalendar_comp_name`, `CalendarRrule`.`room_id`, `CalendarRrule`.`created_user`, `CalendarRrule`.`created`, `CalendarRrule`.`modified_user`, `CalendarRrule`.`modified`, `Language`.`id`, `Language`.`code`, `Language`.`weight`, `Language`.`is_active`, `Language`.`created_user`, `Language`.`created`, `Language`.`modified_user`, `Language`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `LAA0857082-chibagakudo`.`nc3_calendar_events` AS `CalendarEvent` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_calendar_rrules` AS `CalendarRrule` ON (`CalendarEvent`.`calendar_rrule_id` = `CalendarRrule`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_languages` AS `Language` ON (`CalendarEvent`.`language_id` = `Language`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`CalendarEvent`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`CalendarEvent`.`modified_user` = `TrackableUpdater`.`id`) WHERE ((`CalendarEvent`.`is_active` = '1') OR (`CalendarEvent`.`is_latest` = '1')) AND ((`CalendarEvent`.`language_id` = 2) OR (`CalendarEvent`.`is_translation` = '0')) AND `CalendarEvent`.`dtstart` >= '20181031150000' AND `CalendarEvent`.`dtend` < '20190131150000' AND `CalendarEvent`.`room_id` IN (1, 7, 9, 10, 11, 15) ORDER BY `CalendarEvent`.`dtstart` ASC	5	5	2	maybe slow
SELECT `CalendarEventShareUser`.`id`, `CalendarEventShareUser`.`calendar_event_id`, `CalendarEventShareUser`.`share_user`, `CalendarEventShareUser`.`created_user`, `CalendarEventShareUser`.`created`, `CalendarEventShareUser`.`modified_user`, `CalendarEventShareUser`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_calendar_event_share_users` AS `CalendarEventShareUser` WHERE `CalendarEventShareUser`.`calendar_event_id` IN (23, 25, 21, 26, 22) ORDER BY `id` ASC	0	0	1	maybe slow
SELECT `CalendarEventContent`.`id`, `CalendarEventContent`.`model`, `CalendarEventContent`.`content_key`, `CalendarEventContent`.`calendar_event_id`, `CalendarEventContent`.`created_user`, `CalendarEventContent`.`created`, `CalendarEventContent`.`modified_user`, `CalendarEventContent`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_calendar_event_contents` AS `CalendarEventContent` WHERE `CalendarEventContent`.`calendar_event_id` IN (23, 25, 21, 26, 22) ORDER BY `id` ASC	0	0	0
SELECT `PluginsRoom`.`plugin_key` FROM `LAA0857082-chibagakudo`.`nc3_plugins_rooms` AS `PluginsRoom` WHERE `room_id` = 1	22	22	0
SELECT `BlockRolePermission`.`id`, `BlockRolePermission`.`roles_room_id`, `BlockRolePermission`.`block_key`, `BlockRolePermission`.`permission`, `BlockRolePermission`.`value` FROM `LAA0857082-chibagakudo`.`nc3_block_role_permissions` AS `BlockRolePermission` WHERE `block_key` = 'block_2' AND `roles_room_id` IS NULL	0	0	0
SELECT `Room`.`id`, `Room`.`page_id_top` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC	6	6	0
SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`weight`, `Page`.`sort_key`, `Page`.`child_count`, `Page`.`permalink`, `PagesLanguage`.`page_id`, `PagesLanguage`.`name`, `MenuFramesPage`.`id`, `MenuFramesPage`.`page_id`, `MenuFramesPage`.`folder_type`, `MenuFramesPage`.`is_hidden` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` INNER JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) INNER JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) INNER JOIN `LAA0857082-chibagakudo`.`nc3_pages_languages` AS `PagesLanguage` ON (`Page`.`id` = PagesLanguage .page_id) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_menu_frames_pages` AS `MenuFramesPage` ON (`Page`.`id` = MenuFramesPage .page_id AND `MenuFramesPage`.`frame_key` = 'frame_2') LEFT JOIN `LAA0857082-chibagakudo`.`nc3_pages_languages` AS `OriginPagesLanguage` ON (`PagesLanguage`.`page_id` = `OriginPagesLanguage`.`page_id` AND `OriginPagesLanguage`.`language_id` = '2') WHERE `Page`.`room_id` IN (1, 7, 9, 10, 11, 15) AND ((`PagesLanguage`.`language_id` = '2') OR (((`Space`.`is_m17n` = '0') AND (((`PagesLanguage`.`id` = `OriginPagesLanguage`.`id`) OR (`OriginPagesLanguage`.`id` IS NULL)))))) AND `Page`.`id` = PagesLanguage .page_id ORDER BY `Page`.`sort_key` asc	7	7	0
SELECT `MenuFrameSetting`.`id`, `MenuFrameSetting`.`frame_key`, `MenuFrameSetting`.`display_type`, `MenuFrameSetting`.`is_private_room_hidden`, `MenuFrameSetting`.`created_user`, `MenuFrameSetting`.`created`, `MenuFrameSetting`.`modified_user`, `MenuFrameSetting`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_menu_frame_settings` AS `MenuFrameSetting` WHERE `frame_key` = 'frame_2' LIMIT 1	1	1	0
SELECT `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `MenuFramesRoom`.`id`, `MenuFramesRoom`.`room_id`, `MenuFramesRoom`.`is_hidden` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` INNER JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) INNER JOIN `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` ON (`Room`.`id` = RoomsLanguage .room_id AND ((`RoomsLanguage`.`language_id` = '2') OR (`Space`.`is_m17n` = '0'))) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_menu_frames_rooms` AS `MenuFramesRoom` ON (`Room`.`id` = MenuFramesRoom .room_id AND `MenuFramesRoom`.`frame_key` = 'frame_2') LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `OriginRoomsLanguage` ON (`RoomsLanguage`.`room_id` = `OriginRoomsLanguage`.`room_id` AND `OriginRoomsLanguage`.`language_id` = '2') WHERE `Room`.`id` IN (1, 7, 9, 10, 11, 15) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`id` = RoomsLanguage .room_id AND ((`RoomsLanguage`.`language_id` = 2) OR (((`Space`.`is_m17n` = '0') AND (((`RoomsLanguage`.`id` = `OriginRoomsLanguage`.`id`) OR (`OriginRoomsLanguage`.`id` IS NULL)))))) ORDER BY `Room`.`sort_key` asc	6	6	0
SELECT `PagesLanguage`.`page_id`, `PagesLanguage`.`language_id`, `PagesLanguage`.`name` FROM `LAA0857082-chibagakudo`.`nc3_pages_languages` AS `PagesLanguage` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` ON (`PagesLanguage`.`page_id` = `Page`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_languages` AS `Language` ON (`PagesLanguage`.`language_id` = `Language`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`PagesLanguage`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`PagesLanguage`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_pages_languages` AS `OriginPagesLanguage` ON (`PagesLanguage`.`page_id` = `OriginPagesLanguage`.`page_id` AND `OriginPagesLanguage`.`language_id` = 2) WHERE ((`PagesLanguage`.`language_id` = 2) OR (((`Space`.`is_m17n` = '0') AND (((`PagesLanguage`.`id` = `OriginPagesLanguage`.`id`) OR (`OriginPagesLanguage`.`id` IS NULL)))))) AND `Page`.`room_id` IN (1, 7, 9, 10, 11, 15)	7	7	0
SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`weight`, `Page`.`sort_key`, `Page`.`child_count`, `Page`.`permalink`, `Page`.`slug`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Space`.`id`, `Space`.`permalink` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_pages` AS `ParentPage` ON (`Page`.`parent_id` = `ParentPage`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Page`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Page`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) WHERE `Page`.`id` IN (1, 4, 7, 13, 14, 15, 19)	7	7	0
SELECT `ChildPage`.`id`, `ChildPage`.`room_id`, `ChildPage`.`root_id`, `ChildPage`.`parent_id`, `ChildPage`.`lft`, `ChildPage`.`rght`, `ChildPage`.`weight`, `ChildPage`.`sort_key`, `ChildPage`.`child_count`, `ChildPage`.`permalink`, `ChildPage`.`slug`, `ChildPage`.`is_container_fluid`, `ChildPage`.`theme`, `ChildPage`.`created_user`, `ChildPage`.`created`, `ChildPage`.`modified_user`, `ChildPage`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `ChildPage` WHERE `ChildPage`.`parent_id` IN (1, 4, 7, 13, 14, 15, 19)	6	6	0
SELECT `Page`.`sort_key` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE `Page`.`id` = 15 LIMIT 1	1	1	0
SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`weight`, `Page`.`sort_key`, `Page`.`child_count`, `Page`.`permalink`, `Page`.`slug`, `Page`.`is_container_fluid`, `Page`.`theme`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE 1 = 1 AND `Page`.`sort_key` IN ('~00000001', '~00000001-00000005') ORDER BY `Page`.`sort_key` asc	2	2	0
SELECT COUNT(*) AS `count` FROM `LAA0857082-chibagakudo`.`nc3_menu_frames_rooms` AS `MenuFramesRoom` WHERE `MenuFramesRoom`.`frame_key` = 'frame_2'	1	1	0
SELECT COUNT(*) AS `count` FROM `LAA0857082-chibagakudo`.`nc3_menu_frames_pages` AS `MenuFramesPage` WHERE `MenuFramesPage`.`frame_key` = 'frame_2'	1	1	0
SELECT `Page`.`id`, `Page`.`parent_id` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_pages` AS `ParentPage` ON (`Page`.`parent_id` = `ParentPage`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Page`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Page`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_pages_languages` AS `PagesLanguage` ON (`PagesLanguage`.`page_id` = `Page`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_pages_languages` AS `OriginPagesLanguage` ON (`PagesLanguage`.`page_id` = `OriginPagesLanguage`.`page_id` AND `OriginPagesLanguage`.`language_id` = 2) WHERE ((`PagesLanguage`.`language_id` = 2) OR (((`Space`.`is_m17n` = '0') AND (((`PagesLanguage`.`id` = `OriginPagesLanguage`.`id`) OR (`OriginPagesLanguage`.`id` IS NULL)))))) AND `PagesLanguage`.`page_id` = `Page`.`id` AND `Page`.`room_id` IN (1, 7, 9, 10, 11, 15) AND 1 = 1 ORDER BY `Page`.`sort_key` asc	7	7	0
SELECT `Page`.`sort_key` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE `Page`.`id` = 15 LIMIT 1	1	1	0
SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`weight`, `Page`.`sort_key`, `Page`.`child_count`, `Page`.`permalink`, `Page`.`slug`, `Page`.`is_container_fluid`, `Page`.`theme`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE 1 = 1 AND `Page`.`sort_key` IN ('~00000001', '~00000001-00000005') ORDER BY `Page`.`sort_key` asc	2	2	1	maybe slow

19 duplicate queries run.

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 20.14 MB

Message	Memory use
Component initialization	8.12 MB
Controller action start	9.70 MB
Controller render start	13.04 MB
Component initialization #2	15.51 MB
Controller action start #2	15.62 MB
Controller render start #2	16.02 MB
View render complete	16.29 MB

Timers

Total Request Time: 783 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	270.68
Event: Controller.initialize	46.83
Event: Controller.startup	2.50
Controller action	198.08
Event: Controller.beforeRender	36.57
» Processing toolbar data	34.11
Rendering View	134.03
» Event: View.beforeRender	0.97
» Rendering APP/Plugin/Calendars/View/Calendars/daily.ctp	58.57
» » Rendering APP/Plugin/Calendars/View/Elements/scripts.ctp	0.81
» » Rendering APP/Plugin/Calendars/View/Elements/Calendars/calendar_tabs.ctp	3.33
» » Rendering APP/Plugin/NetCommons/View/Elements/load_datetimepicker.ctp	0.47
» » Rendering APP/Plugin/Calendars/View/Elements/Calendars/daily_tabs.ctp	18.49
» » Rendering APP/Plugin/Calendars/View/Elements/Calendars/daily_list.ctp	15.50
» Event: View.afterRender	2.37
» » Rendering APP/Plugin/Frames/View/Elements/frame.ctp	1.29
» » Rendering APP/Plugin/Pages/View/Elements/page_main.ctp	0.73
» Event: View.beforeLayout	62.21
» » Rendering APP/Plugin/Pages/View/Elements/page_major.ctp	61.99
» » » Rendering APP/Plugin/Boxes/View/Elements/render_boxes.ctp	61.61
» » » » Rendering APP/Plugin/Frames/View/Elements/render_frames.ctp	61.35
» » » » » Event: Controller.initialize #2	8.50
» » » » » Event: Controller.startup #2	0.55
» » » » » Controller action #2	29.20
» » » » » Event: Controller.beforeRender #2	14.73
» » » » » » Processing toolbar data #2	14.40
Rendering View #2	0.00
» » » » » » Event: View.beforeRender #2	0.09
» » » » » » Rendering APP/Plugin/Menus/View/Menus/index.ctp	2.33
» » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/major/index.ctp #2	1.91
» » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/major/list.ctp	0.19
» » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/major/list.ctp #2	0.16
» » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/major/list.ctp #3	0.16
» » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/major/list.ctp #4	0.19
» » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/major/list.ctp #5	0.16
» » » » » » Event: View.afterRender #2	0.78
» » » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #2	0.27
» » » » » » » Rendering APP/Plugin/Pages/View/Elements/page_main.ctp #2	0.26
» » » » » » Event: Controller.shutdown	0.05
» » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #3	0.23
» » Rendering APP/Plugin/Pages/View/Layouts/default.ctp	6.99
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_favicon.ctp	0.32
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_css.ctp	0.66
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_theme_css.ctp	0.27
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_js.ctp	0.62
» » » Rendering APP/Plugin/Wysiwyg/View/Elements/mathjax_js.ctp	0.28
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_header.ctp	3.60
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_footer.ctp	0.12
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- meta(array)
  0(array)
  namedescription
  content千葉県学童保育連絡協議会のホームページです。
  1(array)
  namekeywords
  content千葉県千葉学童保育ルーム放課後児童クラブ連絡協議会指導員支援員保護者小学生
  2(array)
  namerobots
  contentindex,follow
  3(array)
  namecopyright
  contentCopyright © 2017 千葉県学童保育連絡協議会
  4(array)
  nameauthor
  content千葉県学童保育連絡協議会
- pageTitleスケジュール - 千葉県学童保育連絡協議会
- modal(null)
- page(array)
  Page(array)
  id15
  room_id11
  root_id1
  parent_id1
  weight5
  sort_key~00000001-00000005
  child_count0
  permalinkschedule
  slugschedule
  is_container_fluid(false)
  theme(null)
  full_permalinkschedule
  PagesLanguage(array)
  id19
  language_id2
  page_id15
  nameスケジュール
  meta_title(null)
  meta_description(null)
  meta_keywords(null)
  meta_robots(null)
  PageContainer(array)
  71(array)
  id71
  page_id15
  container_type1
  is_published(true)
  is_configured(false)
  Box(array)
  17(array)
  BoxesPageContainer(array)
  id302
  page_container_id71
  page_id15
  container_type1
  box_id17
  is_published(true)
  weight1
  Box(array)
  id17
  container_id(null)
  type1
  space_id1
  room_id1
  page_id(null)
  container_type1
  weight(null)
  Room(array)
  id1
  space_id2
  page_id_top4
  parent_id4
  weight1
  sort_key~00000001-00000001
  child_count5
  active(true)
  in_draft(false)
  default_role_keyvisitor
  need_approval(true)
  default_participation(true)
  page_layout_permitted(true)
  themeMichael2nd
  RoomsLanguage(array)
  id1
  name公開情報
  72(array)
  id72
  page_id15
  container_type2
  is_published(true)
  is_configured(false)
  Box(array)
  18(array)
  BoxesPageContainer(array)
  id303
  page_container_id72
  page_id15
  container_type2
  box_id18
  is_published(true)
  weight1
  Box(array)
  id18
  container_id(null)
  type1
  space_id1
  room_id1
  page_id(null)
  container_type2
  weight(null)
  Room(array)
  id1
  space_id2
  page_id_top4
  parent_id4
  weight1
  sort_key~00000001-00000001
  child_count5
  active(true)
  in_draft(false)
  default_role_keyvisitor
  need_approval(true)
  default_participation(true)
  page_layout_permitted(true)
  themeMichael2nd
  RoomsLanguage(array)
  id1
  name公開情報
  Frame(array)
  2(array)
  id2
  language_id2
  frame_id2
  name
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  room_id1
  box_id18
  plugin_keymenus
  block_id2
  keyframe_2
  header_typenone
  weight0
  is_deleted(false)
  default_action
  default_setting_action
  Frame(array)
  id2
  room_id1
  box_id18
  plugin_keymenus
  block_id2
  keyframe_2
  header_typenone
  weight0
  is_deleted(false)
  default_action
  default_setting_action
  FramePublicLanguage(array)
  id2
  language_id0
  frame_id2
  is_public(true)
  FramesLanguage(array)
  id2
  language_id2
  frame_id2
  name
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  Block(array)
  id2
  room_id1
  plugin_keymenus
  keyblock_2
  public_type1
  publish_start(null)
  publish_end(null)
  content_count0
  BlocksLanguage(array)
  language_id2
  block_id2
  name(null)
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  73(array)
  id73
  page_id15
  container_type3
  is_published(true)
  is_configured(false)
  Box(array)
  150(array)
  BoxesPageContainer(array)
  id318
  page_container_id73
  page_id15
  container_type3
  box_id150
  is_published(true)
  weight1
  Box(array)
  id150
  container_id(null)
  type4
  space_id2
  room_id11
  page_id15
  container_type3
  weight(null)
  Room(array)
  id11
  space_id2
  page_id_top15
  parent_id1
  weight4
  sort_key~00000001-00000001-00000004
  child_count0
  active(true)
  in_draft(false)
  default_role_keygeneral_user
  need_approval(false)
  default_participation(true)
  page_layout_permitted(null)
  theme(null)
  RoomsLanguage(array)
  id15
  nameスケジュール
  Frame(array)
  17(array)
  id17
  language_id2
  frame_id17
  nameカレンダー
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  room_id11
  box_id150
  plugin_keycalendars
  block_id15
  key1a59a3167e70d1248c021b20b4f2e34a
  header_typedefault
  weight1
  is_deleted(false)
  default_action
  default_setting_action
  Frame(array)
  id17
  room_id11
  box_id150
  plugin_keycalendars
  block_id15
  key1a59a3167e70d1248c021b20b4f2e34a
  header_typedefault
  weight1
  is_deleted(false)
  default_action
  default_setting_action
  FramePublicLanguage(array)
  id15
  language_id0
  frame_id17
  is_public(true)
  FramesLanguage(array)
  id15
  language_id2
  frame_id17
  nameカレンダー
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  Block(array)
  id15
  room_id11
  plugin_keycalendars
  key8219470cdd5c03712901243e3e449645
  public_type1
  publish_start(null)
  publish_end(null)
  content_count0
  BlocksLanguage(array)
  language_id2
  block_id15
  name
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  74(array)
  id74
  page_id15
  container_type4
  is_published(true)
  is_configured(false)
  Box(array)
  19(array)
  BoxesPageContainer(array)
  id304
  page_container_id74
  page_id15
  container_type4
  box_id19
  is_published(true)
  weight1
  Box(array)
  id19
  container_id(null)
  type1
  space_id1
  room_id1
  page_id(null)
  container_type4
  weight(null)
  Room(array)
  id1
  space_id2
  page_id_top4
  parent_id4
  weight1
  sort_key~00000001-00000001
  child_count5
  active(true)
  in_draft(false)
  default_role_keyvisitor
  need_approval(true)
  default_participation(true)
  page_layout_permitted(true)
  themeMichael2nd
  RoomsLanguage(array)
  id1
  name公開情報
  75(array)
  id75
  page_id15
  container_type5
  is_published(true)
  is_configured(false)
  Box(array)
  20(array)
  BoxesPageContainer(array)
  id305
  page_container_id75
  page_id15
  container_type5
  box_id20
  is_published(true)
  weight1
  Box(array)
  id20
  container_id(null)
  type1
  space_id1
  room_id1
  page_id(null)
  container_type5
  weight(null)
  Room(array)
  id1
  space_id2
  page_id_top4
  parent_id4
  weight1
  sort_key~00000001-00000001
  child_count5
  active(true)
  in_draft(false)
  default_role_keyvisitor
  need_approval(true)
  default_participation(true)
  page_layout_permitted(true)
  themeMichael2nd
  RoomsLanguage(array)
  id1
  name公開情報
- frameId17
- languageId2
- vars(array)
  returnUrl/calendars/calendars/index?year=2018&month=12&day=7&style=daily&tab=list&frame_id=17
  frame_key1a59a3167e70d1248c021b20b4f2e34a
  CalendarFrameSetting(array)
  id1
  frame_key1a59a3167e70d1248c021b20b4f2e34a
  display_type2
  start_pos0
  display_count3
  is_myroom(true)
  is_select_room(false)
  timeline_base_time8
  created_user2
  created2017-07-22 12:36:57
  modified_user2
  modified2017-07-22 12:37:19
  today(array)
  year2019
  month10
  day21
  hour03
  min51
  sec38
  year2018
  month12
  day7
  week5
  dayOfTheWeek1
  mInfo(array)
  yearOfPrevMonth2018
  prevMonth11
  daysInPrevMonth30
  yearOfNextMonth2019
  nextMonth1
  daysInNextMonth31
  year2018
  month12
  wdayOf1stDay6
  daysInMonth31
  wdayOfLastDay1
  numOfWeek6
  holidays(array)
  0(array)
  Holiday(array)
  id1321
  keyholiday_661
  holiday_rrule_id33
  language_id2
  is_origin(true)
  is_translation(true)
  is_original_copy(false)
  holiday2018-11-03
  title文化の日
  is_substitute0
  created_user0
  created2017-05-07 08:12:43
  modified_user0
  modified2017-05-07 08:12:43
  HolidayRrule(array)
  id33
  is_variable(false)
  month_day1974-11-03
  week0
  day_of_the_week
  can_substitute(true)
  start_year1974
  end_year2033
  rruleFREQ=YEARLY;INTERVAL=1;BYMONTH=11;UNTIL=20331102T150000
  created_user0
  created2017-05-07 08:12:41
  modified_user0
  modified2017-05-07 08:12:41
  input_month_day(array)
  month11
  day03
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2017-05-07 08:12:29
  modified_user(null)
  modified2017-05-07 08:12:29
  TrackableCreator(array)
  id(null)
  handlename(null)
  TrackableUpdater(array)
  id(null)
  handlename(null)
  1(array)
  Holiday(array)
  id1469
  keyholiday_735
  holiday_rrule_id35
  language_id2
  is_origin(true)
  is_translation(true)
  is_original_copy(false)
  holiday2018-11-23
  title勤労感謝の日
  is_substitute0
  created_user0
  created2017-05-07 08:12:43
  modified_user0
  modified2017-05-07 08:12:43
  HolidayRrule(array)
  id35
  is_variable(false)
  month_day1974-11-23
  week0
  day_of_the_week
  can_substitute(true)
  start_year1974
  end_year2033
  rruleFREQ=YEARLY;INTERVAL=1;BYMONTH=11;UNTIL=20331122T150000
  created_user0
  created2017-05-07 08:12:41
  modified_user0
  modified2017-05-07 08:12:41
  input_month_day(array)
  month11
  day23
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2017-05-07 08:12:29
  modified_user(null)
  modified2017-05-07 08:12:29
  TrackableCreator(array)
  id(null)
  handlename(null)
  TrackableUpdater(array)
  id(null)
  handlename(null)
  2(array)
  Holiday(array)
  id2089
  key5e1cbfc8056c86a2d498e42d625a008d
  holiday_rrule_id36
  language_id2
  is_origin(true)
  is_translation(true)
  is_original_copy(false)
  holiday2018-12-23
  title天皇誕生日
  is_substitute0
  created_user0
  created2019-10-14 06:59:44
  modified_user0
  modified2019-10-14 06:59:44
  HolidayRrule(array)
  id36
  is_variable(false)
  month_day2001-12-23
  week1
  day_of_the_weekSU
  can_substitute(true)
  start_year1989
  end_year2018
  rrule
  created_user0
  created2017-05-07 08:12:41
  modified_user0
  modified2019-10-14 06:59:43
  input_month_day(array)
  month12
  day23
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2017-05-07 08:12:29
  modified_user(null)
  modified2017-05-07 08:12:29
  TrackableCreator(array)
  id(null)
  handlename(null)
  TrackableUpdater(array)
  id(null)
  handlename(null)
  3(array)
  Holiday(array)
  id2091
  key5e1cbfc8056c86a2d498e42d625a008d
  holiday_rrule_id36
  language_id2
  is_origin(true)
  is_translation(true)
  is_original_copy(false)
  holiday2018-12-24
  title(振替休日)
  is_substitute1
  created_user0
  created2019-10-14 06:59:44
  modified_user0
  modified2019-10-14 06:59:44
  HolidayRrule(array)
  id36
  is_variable(false)
  month_day2001-12-23
  week1
  day_of_the_weekSU
  can_substitute(true)
  start_year1989
  end_year2018
  rrule
  created_user0
  created2017-05-07 08:12:41
  modified_user0
  modified2019-10-14 06:59:43
  input_month_day(array)
  month12
  day23
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2017-05-07 08:12:29
  modified_user(null)
  modified2017-05-07 08:12:29
  TrackableCreator(array)
  id(null)
  handlename(null)
  TrackableUpdater(array)
  id(null)
  handlename(null)
  4(array)
  Holiday(array)
  id113
  keyholiday_57
  holiday_rrule_id2
  language_id2
  is_origin(true)
  is_translation(true)
  is_original_copy(false)
  holiday2019-01-01
  title元日
  is_substitute0
  created_user0
  created2017-05-07 08:12:42
  modified_user0
  modified2017-05-07 08:12:42
  HolidayRrule(array)
  id2
  is_variable(false)
  month_day1975-01-01
  week0
  day_of_the_week
  can_substitute(true)
  start_year1975
  end_year2033
  rruleFREQ=YEARLY;INTERVAL=1;BYMONTH=1;UNTIL=20321231T150000
  created_user0
  created2017-05-07 08:12:41
  modified_user0
  modified2017-05-07 08:12:41
  input_month_day(array)
  month01
  day01
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2017-05-07 08:12:29
  modified_user(null)
  modified2017-05-07 08:12:29
  TrackableCreator(array)
  id(null)
  handlename(null)
  TrackableUpdater(array)
  id(null)
  handlename(null)
  5(array)
  Holiday(array)
  id251
  keyholiday_126
  holiday_rrule_id5
  language_id2
  is_origin(true)
  is_translation(true)
  is_original_copy(false)
  holiday2019-01-14
  title成人の日
  is_substitute0
  created_user0
  created2017-05-07 08:12:42
  modified_user0
  modified2017-05-07 08:12:42
  HolidayRrule(array)
  id5
  is_variable(true)
  month_day2000-01-10
  week2
  day_of_the_weekMO
  can_substitute(false)
  start_year2000
  end_year2033
  rruleFREQ=YEARLY;INTERVAL=1;BYMONTH=1;BYDAY=2MO;UNTIL=20330109T150000
  created_user0
  created2017-05-07 08:12:41
  modified_user0
  modified2017-05-07 08:12:41
  input_month_day(array)
  month01
  day10
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2017-05-07 08:12:29
  modified_user(null)
  modified2017-05-07 08:12:29
  TrackableCreator(array)
  id(null)
  handlename(null)
  TrackableUpdater(array)
  id(null)
  handlename(null)
  parentIdType(array)
  public1
  private2
  member3
  roomSpaceMaps(array)
  12
  72
  92
  102
  112
  152
  roomsLanguages(array)
  0(array)
  RoomsLanguages(array)
  id1
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  room_id1
  name公開情報
  created_user(null)
  created2017-05-07 08:12:34
  modified_user2
  modified2017-10-28 07:13:34
  1(array)
  RoomsLanguages(array)
  id11
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  room_id7
  nameお知らせ
  created_user1
  created2017-05-07 08:32:55
  modified_user2
  modified2017-11-03 14:43:49
  2(array)
  RoomsLanguages(array)
  id13
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  room_id9
  name私たちについて
  created_user2
  created2017-06-03 01:07:31
  modified_user1
  modified2017-11-03 15:35:12
  3(array)
  RoomsLanguages(array)
  id14
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  room_id10
  nameリンク
  created_user2
  created2017-07-22 12:08:17
  modified_user2
  modified2017-07-22 12:08:17
  4(array)
  RoomsLanguages(array)
  id15
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  room_id11
  nameスケジュール
  created_user2
  created2017-07-22 12:32:54
  modified_user1
  modified2017-11-28 14:14:07
  5(array)
  RoomsLanguages(array)
  id19
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  room_id15
  nameイベント、勉強会
  created_user1
  created2017-11-03 15:41:52
  modified_user2
  modified2017-11-23 08:08:29
  exposeRoomOptions(array)
  1公開情報
  7　お知らせ
  9　私たちについて
  10　リンク
  11　スケジュール
  15　イベント、勉強会
  myself(null)
  spaceNameOfRooms(array)
  1public
  7public
  9public
  10public
  11public
  15public
  13group
  14group
  allRoomNames(array)
  1公開情報
  7お知らせ
  9私たちについて
  10リンク
  11スケジュール
  15イベント、勉強会
  13加盟団体向け
  14常任幹事限定
  plans(array)
  0(array)
  CalendarEvent(array)
  id23
  calendar_rrule_id23
  key88fc1ce854985879b1c8dad853d10358
  room_id11
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user5
  title千葉保育センター大掃除
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20181223
  start_time010000
  dtstart20181223010000
  end_date20181223
  end_time040000
  dtend20181223040000
  timezone_offset9.0
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  created_user5
  created2018-12-17 23:00:38
  modified_user5
  modified2018-12-17 23:00:38
  pseudo_friend_share_plan(false)
  is_share(false)
  CalendarRrule(array)
  id23
  calendar_id1
  key81e7ed7613fc1b0ced04ead146c20816
  name
  rrule
  icalendar_uid20181223T010000Z-5c182a96e3297@
  icalendar_comp_namecalendar
  room_id11
  created_user5
  created2018-12-17 23:00:38
  modified_user5
  modified2018-12-17 23:00:38
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2017-05-07 08:12:29
  modified_user(null)
  modified2017-05-07 08:12:29
  TrackableCreator(array)
  id5
  handlename佐藤花子
  TrackableUpdater(array)
  id5
  handlename佐藤花子
  CalendarEventShareUser(empty)
  CalendarEventContent(empty)
  1(array)
  CalendarEvent(array)
  id25
  calendar_rrule_id25
  key6a0ccfb39da150371b7ab3d1a28470a5
  room_id11
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user5
  title特別研修「荒牧光子さんのお正月飾り（しめ縄づくり、干支人形）」
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20181223
  start_time043000
  dtstart20181223043000
  end_date20181223
  end_time063000
  dtend20181223063000
  timezone_offset9.0
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  created_user5
  created0000-00-00 00:00:00
  modified_user5
  modified2018-12-17 23:02:53
  pseudo_friend_share_plan(false)
  is_share(false)
  CalendarRrule(array)
  id25
  calendar_id1
  key1fae8aaf7cdc1594e91a171efc14d983
  name
  rrule
  icalendar_uid20181223T043000Z-5c182af2b1084@
  icalendar_comp_namecalendar
  room_id11
  created_user5
  created2018-12-17 23:02:10
  modified_user5
  modified2018-12-17 23:02:53
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2017-05-07 08:12:29
  modified_user(null)
  modified2017-05-07 08:12:29
  TrackableCreator(array)
  id5
  handlename佐藤花子
  TrackableUpdater(array)
  id5
  handlename佐藤花子
  CalendarEventShareUser(empty)
  CalendarEventContent(empty)
  2(array)
  CalendarEvent(array)
  id21
  calendar_rrule_id21
  keye9ba6b36fcf480e529211b99bad44689
  room_id11
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user5
  title事務局会議
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20190114
  start_time010000
  dtstart20190114010000
  end_date20190114
  end_time030000
  dtend20190114030000
  timezone_offset9.0
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  created_user5
  created2018-12-09 03:42:25
  modified_user5
  modified2018-12-09 03:42:25
  pseudo_friend_share_plan(false)
  is_share(false)
  CalendarRrule(array)
  id21
  calendar_id1
  key842a1ebd39a22ceeaba6c2b6350858f6
  name
  rrule
  icalendar_uid20190114T010000Z-5c0c8f21518da@
  icalendar_comp_namecalendar
  room_id11
  created_user5
  created2018-12-09 03:42:25
  modified_user5
  modified2018-12-09 03:42:25
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2017-05-07 08:12:29
  modified_user(null)
  modified2017-05-07 08:12:29
  TrackableCreator(array)
  id5
  handlename佐藤花子
  TrackableUpdater(array)
  id5
  handlename佐藤花子
  CalendarEventShareUser(empty)
  CalendarEventContent(empty)
  3(array)
  CalendarEvent(array)
  id26
  calendar_rrule_id26
  key41994a0fac48b7242dd5218886917bf4
  room_id11
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user5
  title常任幹事会
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20190120
  start_time020000
  dtstart20190120020000
  end_date20190120
  end_time030000
  dtend20190120030000
  timezone_offset9.0
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  created_user5
  created2018-12-28 00:39:03
  modified_user5
  modified2018-12-28 00:39:03
  pseudo_friend_share_plan(false)
  is_share(false)
  CalendarRrule(array)
  id26
  calendar_id1
  keyb558a6da0b3bfe25dff3f5ac05307859
  name
  rrule
  icalendar_uid20190120T020000Z-5c2570a79e0c3@
  icalendar_comp_namecalendar
  room_id11
  created_user5
  created2018-12-28 00:39:03
  modified_user5
  modified2018-12-28 00:39:03
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2017-05-07 08:12:29
  modified_user(null)
  modified2017-05-07 08:12:29
  TrackableCreator(array)
  id5
  handlename佐藤花子
  TrackableUpdater(array)
  id5
  handlename佐藤花子
  CalendarEventShareUser(empty)
  CalendarEventContent(empty)
  4(array)
  CalendarEvent(array)
  id22
  calendar_rrule_id22
  key8d6a17904d866637ec27b85766bef082
  room_id11
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user5
  title幹事会
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20190120
  start_time040000
  dtstart20190120040000
  end_date20190120
  end_time060000
  dtend20190120060000
  timezone_offset9.0
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  created_user5
  created2018-12-09 04:07:13
  modified_user5
  modified2018-12-09 04:07:13
  pseudo_friend_share_plan(false)
  is_share(false)
  CalendarRrule(array)
  id22
  calendar_id1
  key7353b64f54036b8b8cec3570199ec139
  name
  rrule
  icalendar_uid20190120T040000Z-5c0c94f184c24@
  icalendar_comp_namecalendar
  room_id11
  created_user5
  created2018-12-09 04:07:13
  modified_user5
  modified2018-12-09 04:07:13
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2017-05-07 08:12:29
  modified_user(null)
  modified2017-05-07 08:12:29
  TrackableCreator(array)
  id5
  handlename佐藤花子
  TrackableUpdater(array)
  id5
  handlename佐藤花子
  CalendarEventShareUser(empty)
  CalendarEventContent(empty)
  tablist
  selectRooms(empty)
  styledaily
- hasSwitchLang(false)
- switchLanguages(array)
  0(array)
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
- $request->data(empty)
- $this->validationErrors(array)
  UploadFile(empty)
  UploadFilesContent(empty)
  SiteSetting(empty)
  Language(empty)
  Page(empty)
  Room(empty)
  RolesRoomsUser(empty)
  Space(empty)
  RolesRoom(empty)
  RoomsLanguage(empty)
  CalendarEvent(empty)
  MailSetting(empty)
  MailQueue(empty)
  MailQueueUser(empty)
  Block(empty)
  CalendarFrameSetting(empty)
  CalendarActionPlan(empty)
  Frame(empty)
  Calendar(empty)
  CalendarPermission(empty)
  DefaultRolePermission(empty)
  BlockSetting(empty)
  TrackableCreator(empty)
  TrackableUpdater(empty)
  CalendarFrameSettingSelectRoom(empty)
  ParentRoom(empty)
  ChildRoom(empty)
  RoomRole(empty)
  User(empty)
  Holiday(empty)
  RoomsLanguages(empty)
  CalendarRrule(empty)
  CalendarEventShareUser(empty)
  CalendarEventContent(empty)
- Loaded Helpers(array)
  0Html
  1M17n
  2BackTo
  3Button
  4LinkButton
  5Date
  6MessageFlash
  7NetCommonsForm
  8NetCommonsHtml
  9CalendarMonthly
  10CalendarTurnCalendar
  11CalendarLegend
  12CalendarButton
  13DisplayUser
  14Number
  15SimpleGraph
  16PageLayout
  17Composer
  18DebugTimer
  19Toolbar
  20CalendarUrl
  21CalendarCommon
  22DatetimePicker
  23NetCommonsTime
  24FormInput
  25Form
  26CalendarDaily
  27Blocks
  28Boxes
  29Frames
  30html
  31Flash
  32Session
  33HtmlToolbar
====

Environment

App Constants

Constant	Value
UPLOADS_ROOT	'/home/users/2/hiho.jp-chibagakudo/web/app/Uploads/'
CONFIG	'/home/users/2/hiho.jp-chibagakudo/web/app/Config/'
HTMLPURIFIER_PREFIX	'/home/users/2/hiho.jp-chibagakudo/web/vendors/ezyang/htmlpurifier/library'
NC3_VERSION	'3.3.0'

CakePHP Constants

Constant	Value
APP	'/home/users/2/hiho.jp-chibagakudo/web/app/'
APP_DIR	'app'
APPLIBS	'/home/users/2/hiho.jp-chibagakudo/web/app/Lib/'
CACHE	'/home/users/2/hiho.jp-chibagakudo/web/app/tmp/cache/'
CAKE	'/home/users/2/hiho.jp-chibagakudo/web/vendors/cakephp/cakephp/lib/Cake/'
CAKE_CORE_INCLUDE_PATH	'/home/users/2/hiho.jp-chibagakudo/web/vendors/cakephp/cakephp/lib'
CORE_PATH	'/home/users/2/hiho.jp-chibagakudo/web/vendors/cakephp/cakephp/lib/'
CAKE_VERSION	'2.10.19'
CSS	'/home/users/2/hiho.jp-chibagakudo/web/app/webroot/css/'
CSS_URL	'css/'
DS	'/'
FULL_BASE_URL	'http://chibagakudo.hiho.jp'
IMAGES	'/home/users/2/hiho.jp-chibagakudo/web/app/webroot/img/'
IMAGES_URL	'img/'
JS	'/home/users/2/hiho.jp-chibagakudo/web/app/webroot/js/'
JS_URL	'js/'
LOGS	'/home/users/2/hiho.jp-chibagakudo/web/app/tmp/logs/'
ROOT	'/home/users/2/hiho.jp-chibagakudo/web'
TESTS	'/home/users/2/hiho.jp-chibagakudo/web/app/Test/'
TMP	'/home/users/2/hiho.jp-chibagakudo/web/app/tmp/'
VENDORS	'/home/users/2/hiho.jp-chibagakudo/web/vendors/'
WEBROOT_DIR	'webroot'
WWW_ROOT	'/home/users/2/hiho.jp-chibagakudo/web/app/webroot/'

PHP Environment

Environment Variable	Value
Php Version	'7.1.5'
Redirect Redirect Unique Id	'XaysuZ0HalUAAHUepqoAAAAW'
Redirect Redirect Mef Proxy Addr	'172.19.45.95'
Redirect Redirect Nss Sdb Use Cache	'YES'
Redirect Redirect Status	'200'
Redirect Unique Id	'XaysuZ0HalUAAHUepqoAAAAW'
Redirect Mef Proxy Addr	'172.19.45.95'
Redirect Nss Sdb Use Cache	'YES'
Redirect Status	'200'
Unique Id	'XaysuZ0HalUAAHUepqoAAAAW'
Mef Proxy Addr	'172.19.45.95'
Nss Sdb Use Cache	'YES'
Http Host	'chibagakudo.hiho.jp'
Http X Forwarded Host	'chibagakudo.hiho.jp'
Http X Forwarded For	'3.228.24.192'
Http X Forwarded Proto	'http'
Http User Agent	'CCBot/2.0 (https://commoncrawl.org/faq/)'
Http Accept	'text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8'
Http Accept Language	'en-US,en;q=0.5'
Http If Modified Since	'Tue, 19 Feb 2019 00:19:08 GMT'
Http Accept Encoding	'gzip'
Path	'/sbin:/usr/sbin:/bin:/usr/bin'
Server Signature	''
Server Software	'Apache'
Server Name	'chibagakudo.hiho.jp'
Server Addr	'172.19.46.85'
Server Port	'80'
Remote Addr	'3.228.24.192'
Document Root	'/home/users/2/hiho.jp-chibagakudo/web'
Request Scheme	'http'
Context Prefix	''
Context Document Root	'/home/users/2/hiho.jp-chibagakudo/web'
Server Admin	'https://lolipop.jp/support/'
Script Filename	'/home/users/2/hiho.jp-chibagakudo/web/app/webroot/index.php'
Remote Port	'38772'
Redirect Query String	'year=2018&month=12&day=7&style=daily&tab=list&frame_id=17'
Redirect Url	'/app/webroot/calendars/calendars/index'
Gateway Interface	'CGI/1.1'
Server Protocol	'HTTP/1.1'
Request Method	'GET'
Query String	'year=2018&month=12&day=7&style=daily&tab=list&frame_id=17'
Request Uri	'/calendars/calendars/index?year=2018&month=12&day=7&style=daily&tab=list&frame_id=17'
Script Name	'/app/webroot/index.php'
Php Self	'/app/webroot/index.php'
Request Time Float	(float) 1571597497.855
Request Time	(int) 1571597497

====

Include
+
Included Files

Include Paths
- 1/usr/local/php/7.1/lib/php
- 2-> /home/users/2/hiho.jp-chibagakudo/web/vendors/cakephp/cakephp/lib/Cake/
Included Files
- core(array)
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/AuthComponent.php
  1CORE/Controller/Component/FlashComponent.php
  2CORE/Controller/Component/RequestHandlerComponent.php
  3CORE/Controller/Component/SessionComponent.php
  4CORE/Controller/Component/SecurityComponent.php
  5CORE/Controller/Component/PaginatorComponent.php
  6CORE/Controller/Component/Auth/FormAuthenticate.php
  7CORE/Controller/Component/Auth/BaseAuthenticate.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ModelBehavior.php
  3CORE/Model/ConnectionManager.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/CakeObject.php
  Routing(array)
  0CORE/Routing/Router.php
  1CORE/Routing/Dispatcher.php
  2CORE/Routing/Filter/AssetDispatcher.php
  3CORE/Routing/DispatcherFilter.php
  4CORE/Routing/Filter/CacheDispatcher.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Inflector.php
  1CORE/Utility/ObjectCollection.php
  2CORE/Utility/Debugger.php
  3CORE/Utility/CakeText.php
  4CORE/Utility/ClassRegistry.php
  5CORE/Utility/Set.php
  6CORE/Utility/Folder.php
  7CORE/Utility/Security.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/AppController.php
  1APP/Controller/AppControllerNC.php
  Model(array)
  0APP/Model/AppModel.php
  Other(array)
  0APP/webroot/index.php
  Utility(array)
  0APP/Utility/Hash.php
- plugins(array)
  Auth(array)
  Config(array)
  0Auth/Config/routes.php
  Model(array)
  0Auth/Model/AutoUserRegist.php
  Blocks(array)
  Behavior(array)
  0Blocks/Model/Behavior/BlockSettingBehavior.php
  1Blocks/Model/Behavior/BlockRolePermissionBehavior.php
  2Blocks/Model/Behavior/BlockBehavior.php
  Model(array)
  0Blocks/Model/Block.php
  1Blocks/Model/BlocksAppModel.php
  2Blocks/Model/BlockSetting.php
  Calendars(array)
  Config(array)
  0Calendars/Config/routes.php
  Controller(array)
  0Calendars/Controller/CalendarsController.php
  1Calendars/Controller/CalendarsAppController.php
  Model(array)
  0Calendars/Model/CalendarEvent.php
  1Calendars/Model/CalendarsAppModel.php
  2Calendars/Model/CalendarFrameSetting.php
  3Calendars/Model/CalendarActionPlan.php
  4Calendars/Model/Calendar.php
  5Calendars/Model/CalendarPermission.php
  6Calendars/Model/CalendarFrameSettingSelectRoom.php
  7Calendars/Model/CalendarRrule.php
  Behavior(array)
  0Calendars/Model/Behavior/CalendarValidateBehavior.php
  1Calendars/Model/Behavior/CalendarAppBehavior.php
  2Calendars/Model/Behavior/CalendarInsertPlanBehavior.php
  3Calendars/Model/Behavior/CalendarUpdatePlanBehavior.php
  4Calendars/Model/Behavior/CalendarDeletePlanBehavior.php
  5Calendars/Model/Behavior/CalendarSearchPlanBehavior.php
  6Calendars/Model/Behavior/CalendarRoleAndPermBehavior.php
  7Calendars/Model/Behavior/CalendarExposeRoomBehavior.php
  8Calendars/Model/Behavior/CalendarPlanOptionBehavior.php
  9Calendars/Model/Behavior/CalendarPlanTimeValidateBehavior.php
  10Calendars/Model/Behavior/CalendarPlanRruleValidateBehavior.php
  11Calendars/Model/Behavior/CalendarValidateAppBehavior.php
  12Calendars/Model/Behavior/CalendarPlanValidateBehavior.php
  13Calendars/Model/Behavior/CalendarPlanGenerationBehavior.php
  14Calendars/Model/Behavior/CalendarMailBehavior.php
  15Calendars/Model/Behavior/CalendarTopicsBehavior.php
  16Calendars/Model/Behavior/CalendarLinkBehavior.php
  Plugin(array)
  0Calendars/Utility/CalendarPermissiveRooms.php
  1Calendars/Utility/CalendarTime.php
  Component(array)
  0Calendars/Controller/Component/CalendarsComponent.php
  DataTypes(array)
  Behavior(array)
  0DataTypes/Model/Behavior/TimezoneBehavior.php
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
  Files(array)
  Behavior(array)
  0Files/Model/Behavior/AttachmentBehavior.php
  1Files/Model/Behavior/UploadFileDisableThumbnailBehavior.php
  2Files/Model/Behavior/UploadFileValidateBehavior.php
  3Files/Model/Behavior/UploadValidatorWrapBehavior.php
  Model(array)
  0Files/Model/UploadFile.php
  1Files/Model/FilesAppModel.php
  2Files/Model/UploadFilesContent.php
  Frames(array)
  Config(array)
  0Frames/Config/routes.php
  Model(array)
  0Frames/Model/Frame.php
  1Frames/Model/FramesAppModel.php
  Groups(array)
  Config(array)
  0Groups/Config/routes.php
  Holidays(array)
  Config(array)
  0Holidays/Config/routes.php
  Model(array)
  0Holidays/Model/Holiday.php
  1Holidays/Model/HolidaysAppModel.php
  Install(array)
  Config(array)
  0Install/Config/routes.php
  M17n(array)
  Model(array)
  0M17n/Model/Language.php
  1M17n/Model/M17nAppModel.php
  Behavior(array)
  0M17n/Model/Behavior/SaveM17nBehavior.php
  1M17n/Model/Behavior/M17nBehavior.php
  Mails(array)
  Behavior(array)
  0Mails/Model/Behavior/MailQueueBehavior.php
  1Mails/Model/Behavior/MailQueueDeleteBehavior.php
  Model(array)
  0Mails/Model/MailSettingFixedPhrase.php
  1Mails/Model/MailsAppModel.php
  2Mails/Model/MailSetting.php
  3Mails/Model/MailQueue.php
  4Mails/Model/MailQueueUser.php
  Menus(array)
  Config(array)
  0Menus/Config/routes.php
  MobileDetect(array)
  Component(array)
  0MobileDetect/Controller/Component/MobileDetectComponent.php
  NetCommons(array)
  Config(array)
  0NetCommons/Config/bootstrap.php
  1NetCommons/Config/routes.php
  Plugin(array)
  0NetCommons/Utility/NetCommonsCache.php
  1NetCommons/Utility/Current.php
  2NetCommons/Lib/CurrentLib.php
  3NetCommons/Lib/LibAppObject.php
  4NetCommons/Lib/SettingMode.php
  5NetCommons/Lib/Current/CurrentLibPlugin.php
  6NetCommons/Lib/Current/CurrentLibLanguage.php
  7NetCommons/Lib/Current/CurrentLibUser.php
  8NetCommons/Lib/NcPermission.php
  9NetCommons/Lib/Current/CurrentLibPermission.php
  10NetCommons/Lib/Current/CurrentLibRoom.php
  11NetCommons/Lib/ControlPanel.php
  12NetCommons/Lib/Current/CurrentLibFrame.php
  13NetCommons/Lib/Current/CurrentLibPage.php
  14NetCommons/Lib/Current/CurrentLibBlock.php
  15NetCommons/Utility/NetCommonsSecurity.php
  16NetCommons/Utility/NetCommonsTime.php
  Model(array)
  0NetCommons/Model/NetCommonsAppModel.php
  Behavior(array)
  0NetCommons/Model/Behavior/TrackableBehavior.php
  1NetCommons/Model/Behavior/NetCommonsValidationRuleBehavior.php
  2NetCommons/Model/Behavior/NetCommonsCacheBehavior.php
  3NetCommons/Model/Behavior/OriginalKeyBehavior.php
  4NetCommons/Model/Behavior/NetCommonsTreeBehavior.php
  Controller(array)
  0NetCommons/Controller/NetCommonsAppController.php
  Component(array)
  0NetCommons/Controller/Component/AccessCtrlComponent.php
  1NetCommons/Controller/Component/AssetComponent.php
  2NetCommons/Controller/Component/PermissionComponent.php
  3NetCommons/Controller/Component/NetCommonsComponent.php
  4NetCommons/Controller/Component/NetCommonsTimeComponent.php
  Pages(array)
  Config(array)
  0Pages/Config/routes.php
  Plugin(array)
  0Pages/Routing/Route/SlugRoute.php
  Component(array)
  0Pages/Controller/Component/PageLayoutComponent.php
  Model(array)
  0Pages/Model/Page.php
  1Pages/Model/PagesAppModel.php
  2Pages/Model/PagesLanguage.php
  Behavior(array)
  0Pages/Model/Behavior/PagesTreeBehavior.php
  1Pages/Model/Behavior/SavePageBehavior.php
  2Pages/Model/Behavior/GetPageBehavior.php
  3Pages/Model/Behavior/PageAssociationsBehavior.php
  PluginManager(array)
  Model(array)
  0PluginManager/Model/Plugin.php
  1PluginManager/Model/PluginsRole.php
  Behavior(array)
  0PluginManager/Model/Behavior/PluginBehavior.php
  1PluginManager/Model/Behavior/PluginBowerBehavior.php
  2PluginManager/Model/Behavior/PluginComposerBehavior.php
  3PluginManager/Model/Behavior/PluginThemeBehavior.php
  4PluginManager/Model/Behavior/PluginWebrootBehavior.php
  PrivateSpace(array)
  Behavior(array)
  0PrivateSpace/Model/Behavior/PrivateSpaceBehavior.php
  PublicSpace(array)
  Component(array)
  0PublicSpace/Controller/Component/PublicSpaceComponent.php
  Questionnaires(array)
  Config(array)
  0Questionnaires/Config/routes.php
  Quizzes(array)
  Config(array)
  0Quizzes/Config/routes.php
  Registrations(array)
  Config(array)
  0Registrations/Config/routes.php
  Reservations(array)
  Config(array)
  0Reservations/Config/routes.php
  Roles(array)
  Model(array)
  0Roles/Model/DefaultRolePermission.php
  1Roles/Model/RolesAppModel.php
  2Roles/Model/Role.php
  Rooms(array)
  Model(array)
  0Rooms/Model/Space.php
  1Rooms/Model/RoomsAppModel.php
  2Rooms/Model/Room.php
  3Rooms/Model/RolesRoomsUser.php
  4Rooms/Model/RolesRoom.php
  5Rooms/Model/RoomsLanguage.php
  6Rooms/Model/RoomRole.php
  Config(array)
  0Rooms/Config/routes.php
  Behavior(array)
  0Rooms/Model/Behavior/DeleteRoomAssociationsBehavior.php
  1Rooms/Model/Behavior/RoomBehavior.php
  2Rooms/Model/Behavior/SaveRoomAssociationsBehavior.php
  SiteManager(array)
  Config(array)
  0SiteManager/Config/routes.php
  Plugin(array)
  0SiteManager/Utility/SiteSettingUtil.php
  1SiteManager/Utility/SiteSettingUtilFunc.php
  Model(array)
  0SiteManager/Model/SiteSetting.php
  1SiteManager/Model/SiteManagerAppModel.php
  Behavior(array)
  0SiteManager/Model/Behavior/IpAddressManagerBehavior.php
  1SiteManager/Model/Behavior/SiteSettingValidateBehavior.php
  2SiteManager/Model/Behavior/SiteManagerValidateBehavior.php
  3SiteManager/Model/Behavior/SiteManagerSaveBehavior.php
  4SiteManager/Model/Behavior/SystemManagerValidateBehavior.php
  5SiteManager/Model/Behavior/SystemManagerSaveBehavior.php
  SystemManager(array)
  Config(array)
  0SystemManager/Config/routes.php
  ThemeSettings(array)
  Behavior(array)
  0ThemeSettings/Model/Behavior/ThemeBehavior.php
  Topics(array)
  Behavior(array)
  0Topics/Model/Behavior/TopicsBehavior.php
  1Topics/Model/Behavior/TopicsBaseBehavior.php
  Upload(array)
  Behavior(array)
  0Upload/Model/Behavior/UploadBehavior.php
  UserAttributes(array)
  Config(array)
  0UserAttributes/Config/routes.php
  UserManager(array)
  Config(array)
  0UserManager/Config/routes.php
  UserRoles(array)
  Config(array)
  0UserRoles/Config/routes.php
  Users(array)
  Model(array)
  0Users/Model/User.php
  1Users/Model/UsersAppModel.php
  Behavior(array)
  0Users/Model/Behavior/AvatarBehavior.php
  1Users/Model/Behavior/DeleteUserBehavior.php
  2Users/Model/Behavior/ImportExportBehavior.php
  3Users/Model/Behavior/UserPermissionBehavior.php
  4Users/Model/Behavior/UsersValidationRuleBehavior.php
  5Users/Model/Behavior/SaveUserBehavior.php
  Config(array)
  0Users/Config/routes.php
  VisualCaptcha(array)
  Config(array)
  0VisualCaptcha/Config/routes.php
  Workflow(array)
  Component(array)
  0Workflow/Controller/Component/WorkflowComponent.php
  Behavior(array)
  0Workflow/Model/Behavior/WorkflowBehavior.php
  1Workflow/Model/Behavior/WorkflowCommentBehavior.php
  Wysiwyg(array)
  Config(array)
  0Wysiwyg/Config/routes.php
  Behavior(array)
  0Wysiwyg/Model/Behavior/WysiwygBehavior.php
  1Wysiwyg/Model/Behavior/PurifiableBehavior.php
====

2018年 12月7日(金)

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

master

Total Time: 11 ms Total Queries: 75 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 11 ms
Total Queries: 75 queries