集会所施設予約 - 多摩ニュータウン　エステート聖ヶ丘３

集会所施設予約

2023年 5月

	21(日)	22(月)	23(火)	24(水)	25(木)	26(金)	27(土)

00:00	IT委員会	公文教室	大規模修繕実行委員会書道教室	公文書写公文書写公文書写	常磐会手芸サロン公文教室	大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会大規模修繕実行委員会	空手教室旧ブロック委員会お疲れ様会
01:00
02:00
03:00
04:00
05:00
06:00
07:00
08:00
09:00
10:00
11:00
12:00
13:00
14:00
15:00
16:00
17:00
18:00
19:00
20:00
21:00
22:00
23:00

パブリック

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgentc56d448636c064662b97d007ff357697
  time1734070266
  countdown10
  languageja
- setting(false)
- _Token(array)
  key464fa6fbe7dd7bd38803c6f2d0f5ea9354cdd152cc0e93634b9d3f3ba3fa9fbfe27d7d384fb66c14655c04759e09373d00e4478e937466d54d7774cc74b2f70e
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  464fa6fbe7dd7bd38803c6f2d0f5ea9354cdd152cc0e93634b9d3f3ba3fa9fbfe27d7d384fb66c14655c04759e09373d00e4478e937466d54d7774cc74b2f70e1734077466
- c56d448636c064662b97d007ff357697reservations(array)
  677/reservations/reservations/index?frame_id=677&style=weekly_by_location&year=2023&month=05&day=25
====
Request
+
Request

Cake Params
- pluginreservations
- controllerreservations
- actionindex
- named(empty)
- pass(empty)
- isAjax(false)
- _Token(array)
  key464fa6fbe7dd7bd38803c6f2d0f5ea9354cdd152cc0e93634b9d3f3ba3fa9fbfe27d7d384fb66c14655c04759e09373d00e4478e937466d54d7774cc74b2f70e
  unlockedFields(empty)
Post data

No post data.

Query string
- frame_id677
- styleweekly_by_location
- year2023
- month05
- day25
Cookie

To view Cookies, add CookieComponent to Controller

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

Sql Log

Sql Logs

master

Total Time: 204 ms
Total Queries: 384 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	2	2	1	maybe slow
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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	1	maybe slow
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	2	2	1	maybe slow
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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	1	maybe slow
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	2	maybe slow
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	1	maybe slow
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	1	maybe slow
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	1	maybe slow
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	2	2	1	maybe slow
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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	2	2	2
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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	2	2	1	maybe slow
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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	1	maybe slow
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	1	maybe slow
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	1	maybe slow
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	2	2	1	maybe slow
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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	2	2	1	maybe slow
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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	3	maybe slow
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	2	2	1	maybe slow
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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	1	maybe slow
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	4	maybe slow
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	2	2	1	maybe slow
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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1)	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 `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1)	0	0	0
SELECT `Room`.`id`, `Room`.`page_id_top` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`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	1	1	1
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 `hijiri3_hijirigaoka`.`pages` AS `Page` INNER JOIN `hijiri3_hijirigaoka`.`rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) INNER JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) INNER JOIN `hijiri3_hijirigaoka`.`pages_languages` AS `PagesLanguage` ON (`Page`.`id` = PagesLanguage .page_id) LEFT JOIN `hijiri3_hijirigaoka`.`menu_frames_pages` AS `MenuFramesPage` ON (`Page`.`id` = MenuFramesPage .page_id AND `MenuFramesPage`.`frame_key` = 'd8a46090c60cc5f3fa3f56198e0e2998') LEFT JOIN `hijiri3_hijirigaoka`.`pages_languages` AS `OriginPagesLanguage` ON (`PagesLanguage`.`page_id` = `OriginPagesLanguage`.`page_id` AND `OriginPagesLanguage`.`language_id` = '2') WHERE `Page`.`room_id` = (1) 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	31	31	2	maybe slow
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 `hijiri3_hijirigaoka`.`menu_frame_settings` AS `MenuFrameSetting` WHERE `frame_key` = 'd8a46090c60cc5f3fa3f56198e0e2998' LIMIT 1	1	1	1
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 `hijiri3_hijirigaoka`.`rooms` AS `Room` INNER JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) INNER JOIN `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` ON (`Room`.`id` = RoomsLanguage .room_id AND ((`RoomsLanguage`.`language_id` = '2') OR (`Space`.`is_m17n` = '0'))) LEFT JOIN `hijiri3_hijirigaoka`.`menu_frames_rooms` AS `MenuFramesRoom` ON (`Room`.`id` = MenuFramesRoom .room_id AND `MenuFramesRoom`.`frame_key` = 'd8a46090c60cc5f3fa3f56198e0e2998') LEFT JOIN `hijiri3_hijirigaoka`.`rooms_languages` AS `OriginRoomsLanguage` ON (`RoomsLanguage`.`room_id` = `OriginRoomsLanguage`.`room_id` AND `OriginRoomsLanguage`.`language_id` = '2') WHERE `Room`.`id` = (1) 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	1	1	1
SELECT `PagesLanguage`.`page_id`, `PagesLanguage`.`language_id`, `PagesLanguage`.`name` FROM `hijiri3_hijirigaoka`.`pages_languages` AS `PagesLanguage` LEFT JOIN `hijiri3_hijirigaoka`.`pages` AS `Page` ON (`PagesLanguage`.`page_id` = `Page`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`languages` AS `Language` ON (`PagesLanguage`.`language_id` = `Language`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`PagesLanguage`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`PagesLanguage`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`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` = (1)	31	31	2	maybe slow
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 `hijiri3_hijirigaoka`.`pages` AS `Page` LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`pages` AS `ParentPage` ON (`Page`.`parent_id` = `ParentPage`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Page`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Page`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) WHERE `Page`.`id` IN (1, 4, 8, 9, 12, 13, 21, 158, 162, 163, 179, 198, 201, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 227, 251, 252, 279, 288, 289, 328, 329)	31	31	2	maybe slow
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 `hijiri3_hijirigaoka`.`pages` AS `ChildPage` WHERE `ChildPage`.`parent_id` IN (1, 4, 8, 9, 12, 13, 21, 158, 162, 163, 179, 198, 201, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 227, 251, 252, 279, 288, 289, 328, 329)	30	30	2	maybe slow
SELECT `Page`.`sort_key` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE `Page`.`id` = 198 LIMIT 1	1	1	1
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 `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE 1 = 1 AND `Page`.`sort_key` IN ('~00000001', '~00000001-00000009') ORDER BY `Page`.`sort_key` asc	2	2	1	maybe slow
SELECT COUNT(*) AS `count` FROM `hijiri3_hijirigaoka`.`menu_frames_rooms` AS `MenuFramesRoom` WHERE `MenuFramesRoom`.`frame_key` = 'd8a46090c60cc5f3fa3f56198e0e2998'	1	1	1
SELECT COUNT(*) AS `count` FROM `hijiri3_hijirigaoka`.`menu_frames_pages` AS `MenuFramesPage` WHERE `MenuFramesPage`.`frame_key` = 'd8a46090c60cc5f3fa3f56198e0e2998'	1	1	0
SELECT `Page`.`id`, `Page`.`parent_id` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`pages` AS `ParentPage` ON (`Page`.`parent_id` = `ParentPage`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Page`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Page`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`pages_languages` AS `PagesLanguage` ON (`PagesLanguage`.`page_id` = `Page`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`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` = (1) AND 1 = 1 ORDER BY `Page`.`sort_key` asc	31	31	2	maybe slow
SELECT `Page`.`sort_key` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE `Page`.`id` = 198 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 `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE 1 = 1 AND `Page`.`sort_key` IN ('~00000001', '~00000001-00000009') ORDER BY `Page`.`sort_key` asc	2	2	1	maybe slow

185 duplicate queries run.

Query Explain:

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

====

Timer

Memory

Peak Memory Use 30.99 MB

Message	Memory use
Component initialization	3.17 MB
Controller action start	3.90 MB
Controller render start	15.50 MB
Component initialization #2	16.54 MB
Controller action start #2	16.65 MB
Controller render start #2	17.10 MB
View render complete	17.35 MB

Timers

Total Request Time: 5801 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	27.40
Event: Controller.initialize	17.78
Event: Controller.startup	3.89
Controller action	4967.24
Event: Controller.beforeRender	65.97
» Processing toolbar data	64.48
Rendering View	490.39
» Event: View.beforeRender	0.76
» Rendering APP/Plugin/Reservations/View/Reservations/weekly_by_location.ctp	378.11
» » Rendering APP/Plugin/Reservations/View/Elements/scripts.ctp	0.32
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/common_tabs.ctp	1.16
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/tabs_by_location.ctp	0.20
» » Rendering APP/Plugin/NetCommons/View/Elements/load_datetimepicker.ctp	0.57
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/dropdown_category.ctp	0.92
» » » Rendering APP/Plugin/Categories/View/Elements/dropdown_toggle_category.ctp	0.45
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/dropdown_location.ctp	0.33
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/weekly_timeline_element.ctp	357.85
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/weekly_timeline_element.ctp #2	0.37
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/weekly_timeline_element.ctp #3	0.29
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/weekly_timeline_element.ctp #4	0.29
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/weekly_timeline_element.ctp #5	0.31
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/weekly_timeline_element.ctp #6	0.30
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/weekly_timeline_element.ctp #7	0.30
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/weekly_timeline_element.ctp #8	0.29
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/weekly_timeline_element.ctp #9	0.31
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/weekly_timeline_element.ctp #10	0.30
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/weekly_timeline_element.ctp #11	0.30
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/weekly_timeline_element.ctp #12	0.30
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/weekly_timeline_element.ctp #13	0.30
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/weekly_timeline_element.ctp #14	0.30
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/weekly_timeline_element.ctp #15	0.29
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/weekly_timeline_element.ctp #16	0.30
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/weekly_timeline_element.ctp #17	0.28
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/weekly_timeline_element.ctp #18	0.28
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/weekly_timeline_element.ctp #19	0.27
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/weekly_timeline_element.ctp #20	0.28
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/weekly_timeline_element.ctp #21	0.29
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/weekly_timeline_element.ctp #22	0.28
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/weekly_timeline_element.ctp #23	0.30
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/weekly_timeline_element.ctp #24	0.28
» Event: View.afterRender	1.24
» » Rendering APP/Plugin/Frames/View/Elements/frame.ctp	0.37
» » Rendering APP/Plugin/Pages/View/Elements/page_main.ctp	0.26
» Event: View.beforeLayout	104.19
» » Rendering APP/Plugin/Pages/View/Elements/page_header.ctp	103.81
» » » Rendering APP/Plugin/Boxes/View/Elements/render_boxes.ctp	103.52
» » » » Rendering APP/Plugin/Frames/View/Elements/render_frames.ctp	103.27
» » » » » Event: Controller.initialize #2	6.63
» » » » » Event: Controller.startup #2	0.48
» » » » » Controller action #2	24.54
» » » » » Event: Controller.beforeRender #2	66.12
» » » » » » Processing toolbar data #2	65.83
Rendering View #2	0.00
» » » » » » Event: View.beforeRender #2	0.12
» » » » » » Rendering APP/Plugin/Menus/View/Menus/index.ctp	1.33
» » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/topic_path/index.ctp #2	0.86
» » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/topic_path/list.ctp	0.12
» » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/topic_path/list.ctp #2	0.07
» » » » » » Event: View.afterRender #2	0.55
» » » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #2	0.13
» » » » » » » Rendering APP/Plugin/Pages/View/Elements/page_main.ctp #2	0.10
» » » » » » Event: Controller.shutdown	0.08
» » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #3	0.11
» » Rendering APP/Plugin/Pages/View/Layouts/default.ctp	4.69
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_favicon.ctp	0.30
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_css.ctp	0.81
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_theme_css.ctp	0.27
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_js.ctp	0.75
» » » Rendering APP/Plugin/Wysiwyg/View/Elements/mathjax_js.ctp	0.20
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_header.ctp	1.08
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_footer.ctp	0.09
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- meta(array)
  0(array)
  namedescription
  content多摩ニュータウン・エステート聖ヶ丘-3団地は、多摩ニュータウン第４住区にあり、旧公団が1984年に建設した団地です。多摩市聖ヶ丘3丁目51番、52番にあり、標高120mの高台で緑に囲まれています。車に会わず遊歩道を歩いて小学校、中学校に通えます。
  1(array)
  namekeywords
  content聖ヶ丘,聖ヶ丘3丁目,ひじり,hijiri,多摩ニュータウン,永山,3丁目,団地,多摩センター,エステート
  2(array)
  namerobots
  contentindex,follow
  3(array)
  namecopyright
  contentCopyright © 2020
  4(array)
  nameauthor
  content多摩ニュータウンエステート聖ヶ丘３管理組合
- pageTitle集会所施設予約 - 多摩ニュータウン　エステート聖ヶ丘３
- modal(null)
- page(array)
  Page(array)
  id198
  room_id1
  root_id1
  parent_id1
  weight9
  sort_key~00000001-00000009
  child_count0
  permalinkpage_20210629025737
  slugpage_20210629025737
  is_container_fluid(false)
  theme(null)
  full_permalinkpage_20210629025737
  PagesLanguage(array)
  id202
  language_id2
  page_id198
  name集会所施設予約
  meta_title(null)
  meta_description(null)
  meta_keywords(null)
  meta_robots(null)
  PageContainer(array)
  986(array)
  id986
  page_id198
  container_type1
  is_published(true)
  is_configured(true)
  Box(array)
  1603(array)
  BoxesPageContainer(array)
  id3425
  page_container_id986
  page_id198
  container_type1
  box_id1603
  is_published(true)
  weight4
  Box(array)
  id1603
  container_id(null)
  type4
  space_id2
  room_id1
  page_id198
  container_type1
  weight(null)
  Room(array)
  id1
  space_id2
  page_id_top4
  parent_id4
  weight1
  sort_key~00000001-00000001
  child_count0
  active(true)
  in_draft(false)
  default_role_keyvisitor
  need_approval(true)
  default_participation(true)
  page_layout_permitted(true)
  themeDefaultGreen
  RoomsLanguage(array)
  id1
  nameパブリック
  Frame(array)
  676(array)
  id676
  language_id2
  frame_id676
  name
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  room_id1
  box_id1603
  plugin_keymenus
  block_id(null)
  keyd8a46090c60cc5f3fa3f56198e0e2998
  header_typenone
  weight1
  is_deleted(false)
  default_action
  default_setting_action
  Frame(array)
  id676
  room_id1
  box_id1603
  plugin_keymenus
  block_id(null)
  keyd8a46090c60cc5f3fa3f56198e0e2998
  header_typenone
  weight1
  is_deleted(false)
  default_action
  default_setting_action
  FramePublicLanguage(array)
  id674
  language_id0
  frame_id676
  is_public(true)
  FramesLanguage(array)
  id674
  language_id2
  frame_id676
  name
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  Block(array)
  id(null)
  room_id(null)
  plugin_key(null)
  key(null)
  public_type(null)
  publish_start(null)
  publish_end(null)
  content_count(null)
  BlocksLanguage(array)
  language_id(null)
  block_id(null)
  name(null)
  is_origin(null)
  is_translation(null)
  is_original_copy(null)
  987(array)
  id987
  page_id198
  container_type2
  is_published(false)
  is_configured(true)
  Box(array)
  18(array)
  BoxesPageContainer(array)
  id3414
  page_container_id987
  page_id198
  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_count0
  active(true)
  in_draft(false)
  default_role_keyvisitor
  need_approval(true)
  default_participation(true)
  page_layout_permitted(true)
  themeDefaultGreen
  RoomsLanguage(array)
  id1
  nameパブリック
  988(array)
  id988
  page_id198
  container_type3
  is_published(true)
  is_configured(false)
  Box(array)
  1605(array)
  BoxesPageContainer(array)
  id3429
  page_container_id988
  page_id198
  container_type3
  box_id1605
  is_published(true)
  weight1
  Box(array)
  id1605
  container_id(null)
  type4
  space_id2
  room_id1
  page_id198
  container_type3
  weight(null)
  Room(array)
  id1
  space_id2
  page_id_top4
  parent_id4
  weight1
  sort_key~00000001-00000001
  child_count0
  active(true)
  in_draft(false)
  default_role_keyvisitor
  need_approval(true)
  default_participation(true)
  page_layout_permitted(true)
  themeDefaultGreen
  RoomsLanguage(array)
  id1
  nameパブリック
  Frame(array)
  715(array)
  id715
  language_id2
  frame_id715
  name
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  room_id1
  box_id1605
  plugin_keyannouncements
  block_id317
  keybedaefe681e39a14adcd217d4b1be4a7
  header_typenone
  weight1
  is_deleted(false)
  default_action
  default_setting_action
  Frame(array)
  id715
  room_id1
  box_id1605
  plugin_keyannouncements
  block_id317
  keybedaefe681e39a14adcd217d4b1be4a7
  header_typenone
  weight1
  is_deleted(false)
  default_action
  default_setting_action
  FramePublicLanguage(array)
  id713
  language_id0
  frame_id715
  is_public(true)
  FramesLanguage(array)
  id713
  language_id2
  frame_id715
  name
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  Block(array)
  id317
  room_id1
  plugin_keyannouncements
  keyf0ae4c06caceb3fcf3605651a9242603
  public_type1
  publish_start(null)
  publish_end(null)
  content_count0
  BlocksLanguage(array)
  language_id2
  block_id317
  name本ページでは集会所施設の空き状況の確認・予約ができます。ログインコード取得者はログインすると予約ができます。集会所予約説明書.pdf ログインコードを取得していない方は、集会所窓口に行き「会議室利用申込書」に必要事項を記載し集会所窓口へ提出してください。（従
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  677(array)
  id677
  language_id2
  frame_id677
  name集会所施設予約
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  room_id1
  box_id1605
  plugin_keyreservations
  block_id277
  key30cea661986ef6b9c058172fa18a4683
  header_typedefault
  weight2
  is_deleted(false)
  default_action
  default_setting_action
  Frame(array)
  id677
  room_id1
  box_id1605
  plugin_keyreservations
  block_id277
  key30cea661986ef6b9c058172fa18a4683
  header_typedefault
  weight2
  is_deleted(false)
  default_action
  default_setting_action
  FramePublicLanguage(array)
  id675
  language_id0
  frame_id677
  is_public(true)
  FramesLanguage(array)
  id675
  language_id2
  frame_id677
  name集会所施設予約
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  Block(array)
  id277
  room_id1
  plugin_keyreservations
  key497baae68f535cd79f72f6a4fdfe1c66
  public_type1
  publish_start(null)
  publish_end(null)
  content_count0
  BlocksLanguage(array)
  language_id(null)
  block_id(null)
  name(null)
  is_origin(null)
  is_translation(null)
  is_original_copy(null)
  989(array)
  id989
  page_id198
  container_type4
  is_published(false)
  is_configured(true)
  Box(array)
  19(array)
  BoxesPageContainer(array)
  id3415
  page_container_id989
  page_id198
  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_count0
  active(true)
  in_draft(false)
  default_role_keyvisitor
  need_approval(true)
  default_participation(true)
  page_layout_permitted(true)
  themeDefaultGreen
  RoomsLanguage(array)
  id1
  nameパブリック
  990(array)
  id990
  page_id198
  container_type5
  is_published(true)
  is_configured(true)
  Box(array)
  45(array)
  BoxesPageContainer(array)
  id3424
  page_container_id990
  page_id198
  container_type5
  box_id45
  is_published(true)
  weight3
  Box(array)
  id45
  container_id(null)
  type3
  space_id2
  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_count0
  active(true)
  in_draft(false)
  default_role_keyvisitor
  need_approval(true)
  default_participation(true)
  page_layout_permitted(true)
  themeDefaultGreen
  RoomsLanguage(array)
  id1
  nameパブリック
- frameId677
- languageId2
- vars(array)
  frame_key30cea661986ef6b9c058172fa18a4683
  returnUrl/reservations/reservations/index?frame_id=677&style=weekly_by_location&year=2023&month=05&day=25
  styleweekly_by_location
  location_key4ac901d3c60a74e924613b75b83d7a2f
  ReservationFrameSetting(array)
  id4
  frame_key30cea661986ef6b9c058172fa18a4683
  display_type1
  location_key4ac901d3c60a74e924613b75b83d7a2f
  category_id(null)
  display_timeframe(false)
  display_start_time_type0
  start_pos0
  display_count0
  is_myroom(false)
  is_select_room(false)
  room_id1
  timeline_base_time8
  display_interval(null)
  created_user1
  created2021-06-29 06:06:57
  modified_user103
  modified2021-08-07 21:51:19
  today(array)
  year2024
  month12
  day13
  hour11
  min11
  sec06
  year2023
  month5
  day25
  week(null)
  dayOfTheWeek5
  mInfo(array)
  yearOfPrevMonth2023
  prevMonth4
  daysInPrevMonth30
  yearOfNextMonth2023
  nextMonth6
  daysInNextMonth30
  year2023
  month5
  wdayOf1stDay1
  daysInMonth31
  wdayOfLastDay3
  numOfWeek5
  holidays(array)
  0(array)
  Holiday(array)
  id555
  keyholiday_278
  holiday_rrule_id16
  language_id2
  is_origin(true)
  is_translation(true)
  is_original_copy(false)
  holiday2023-04-29
  title昭和の日
  is_substitute0
  created_user0
  created2020-02-29 08:00:54
  modified_user0
  modified2020-02-29 08:00:54
  HolidayRrule(array)
  id16
  is_variable(false)
  month_day2007-04-29
  week0
  day_of_the_week
  can_substitute(true)
  start_year2007
  end_year2033
  rruleFREQ=YEARLY;INTERVAL=1;BYMONTH=4;UNTIL=20330428T150000
  created_user0
  created2020-02-29 08:00:53
  modified_user0
  modified2020-02-29 08:00:53
  input_month_day(array)
  month04
  day29
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  TrackableCreator(array)
  id(null)
  handlename(null)
  TrackableUpdater(array)
  id(null)
  handlename(null)
  1(array)
  Holiday(array)
  id699
  keyholiday_350
  holiday_rrule_id18
  language_id2
  is_origin(true)
  is_translation(true)
  is_original_copy(false)
  holiday2023-05-03
  title憲法記念日
  is_substitute0
  created_user0
  created2020-02-29 08:00:54
  modified_user0
  modified2020-02-29 08:00:54
  HolidayRrule(array)
  id18
  is_variable(false)
  month_day1974-05-03
  week0
  day_of_the_week
  can_substitute(true)
  start_year1974
  end_year2033
  rruleFREQ=YEARLY;INTERVAL=1;BYMONTH=5;UNTIL=20330502T150000
  created_user0
  created2020-02-29 08:00:53
  modified_user0
  modified2020-02-29 08:00:53
  input_month_day(array)
  month05
  day03
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  TrackableCreator(array)
  id(null)
  handlename(null)
  TrackableUpdater(array)
  id(null)
  handlename(null)
  2(array)
  Holiday(array)
  id759
  keyholiday_380
  holiday_rrule_id19
  language_id2
  is_origin(true)
  is_translation(true)
  is_original_copy(false)
  holiday2023-05-04
  titleみどりの日
  is_substitute0
  created_user0
  created2020-02-29 08:00:54
  modified_user0
  modified2020-02-29 08:00:54
  HolidayRrule(array)
  id19
  is_variable(false)
  month_day2007-05-04
  week0
  day_of_the_week
  can_substitute(true)
  start_year2007
  end_year2033
  rruleFREQ=YEARLY;INTERVAL=1;BYMONTH=5;UNTIL=20330503T150000
  created_user0
  created2020-02-29 08:00:53
  modified_user0
  modified2020-02-29 08:00:53
  input_month_day(array)
  month05
  day04
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  TrackableCreator(array)
  id(null)
  handlename(null)
  TrackableUpdater(array)
  id(null)
  handlename(null)
  3(array)
  Holiday(array)
  id905
  keyholiday_453
  holiday_rrule_id21
  language_id2
  is_origin(true)
  is_translation(true)
  is_original_copy(false)
  holiday2023-05-05
  titleこどもの日
  is_substitute0
  created_user0
  created2020-02-29 08:00:54
  modified_user0
  modified2020-02-29 08:00:54
  HolidayRrule(array)
  id21
  is_variable(false)
  month_day1974-05-05
  week0
  day_of_the_week
  can_substitute(true)
  start_year1974
  end_year2033
  rruleFREQ=YEARLY;INTERVAL=1;BYMONTH=5;UNTIL=20330504T150000
  created_user0
  created2020-02-29 08:00:53
  modified_user0
  modified2020-02-29 08:00:53
  input_month_day(array)
  month05
  day05
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  TrackableCreator(array)
  id(null)
  handlename(null)
  TrackableUpdater(array)
  id(null)
  handlename(null)
  parentIdType(array)
  public1
  private2
  member3
  roomSpaceMaps(array)
  12
  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)
  created2020-02-29 08:00:42
  modified_user(null)
  modified2020-02-29 08:00:42
  exposeRoomOptions(array)
  1パブリック
  myself(null)
  spaceNameOfRooms(array)
  1public
  6group
  135group
  allRoomNames(array)
  1パブリック
  6居住者サイト
  135管理組合文書原本
  plans(array)
  0(array)
  ReservationEvent(array)
  id3040
  reservation_rrule_id1127
  key697911f4ef2b433cf97467d11ada6882
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user103
  title空手教室
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230401
  start_time000000
  dtstart20230401000000
  end_date20230401
  end_time023000
  dtend20230401023000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user103
  created2023-04-24 10:57:43
  modified_user103
  modified2023-04-24 10:57:43
  ReservationRrule(array)
  id1127
  reservation_id1
  keyc1af182d00159d0c891e57cc853ecea8
  name
  rrule
  ireservation_uid20230401T000000Z-644660a7ee1a9@
  ireservation_comp_namereservation
  room_id0
  created_user103
  created2023-04-24 10:57:43
  modified_user103
  modified2023-04-24 10:57:43
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id103
  handlenamem.ando
  TrackableUpdater(array)
  id103
  handlenamem.ando
  ReservationEventShareUser(empty)
  1(array)
  ReservationEvent(array)
  id2651
  reservation_rrule_id1037
  keyed0106aff38b2929c762924c6a483a05
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user156
  titleブロック委員会　植栽担当引継ぎ
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230401
  start_time090000
  dtstart20230401090000
  end_date20230401
  end_time100000
  dtend20230401100000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user156
  created2023-03-19 09:40:08
  modified_user156
  modified2023-03-19 09:40:08
  ReservationRrule(array)
  id1037
  reservation_id1
  key380a8cbb355cd6c20df90ee82f178051
  name
  rrule
  ireservation_uid20230401T090000Z-6416d878d5098@
  ireservation_comp_namereservation
  room_id0
  created_user156
  created2023-03-19 09:40:08
  modified_user156
  modified2023-03-19 09:40:08
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id156
  handlenamey.yamahata
  TrackableUpdater(array)
  id156
  handlenamey.yamahata
  ReservationEventShareUser(empty)
  2(array)
  ReservationEvent(array)
  id2011
  reservation_rrule_id621
  key88cf4d65a23742e35ea8cd4446975de1
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user107
  title緑化委員会
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230401
  start_time100000
  dtstart20230401100000
  end_date20230401
  end_time120000
  dtend20230401120000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user107
  created2022-06-06 03:43:09
  modified_user107
  modified2022-06-06 03:43:09
  ReservationRrule(array)
  id621
  reservation_id1
  keyb4f5c5f56c8eadac4e07271296b6fb0e
  name
  rrule
  ireservation_uid20230401T100000Z-629d77cd238f9@
  ireservation_comp_namereservation
  room_id0
  created_user107
  created2022-06-06 03:43:09
  modified_user107
  modified2022-06-06 03:43:09
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id107
  handlenamehosogai
  TrackableUpdater(array)
  id107
  handlenamehosogai
  ReservationEventShareUser(empty)
  3(array)
  ReservationEvent(array)
  id2913
  reservation_rrule_id1071
  key2b8a64ff495768b45ee4bba7a53cdbf6
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user147
  title理事会打合せ
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230402
  start_time053000
  dtstart20230402053000
  end_date20230402
  end_time063000
  dtend20230402063000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user147
  created2023-04-02 04:47:33
  modified_user147
  modified2023-04-02 04:47:33
  ReservationRrule(array)
  id1071
  reservation_id1
  key84183ee1080434ffb654767b82bedc73
  name
  rrule
  ireservation_uid20230402T053000Z-642908e5ac84c@
  ireservation_comp_namereservation
  room_id0
  created_user147
  created2023-04-02 04:47:33
  modified_user147
  modified2023-04-02 04:47:33
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id147
  handlenamehiroyoshi.morita
  TrackableUpdater(array)
  id147
  handlenamehiroyoshi.morita
  ReservationEventShareUser(empty)
  4(array)
  ReservationEvent(array)
  id1785
  reservation_rrule_id534
  key5a201ea32d6b3b84b2b21126a49c618b
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user34
  titleライフサポート委員会
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230403
  start_time050000
  dtstart20230403050000
  end_date20230403
  end_time060000
  dtend20230403060000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user34
  created2022-05-09 02:10:03
  modified_user34
  modified2022-05-09 02:11:55
  ReservationRrule(array)
  id534
  reservation_id1
  key7012d5be5f7805ea6116b43623d07b0d
  name
  rruleFREQ=MONTHLY;INTERVAL=1;BYDAY=1MO;UNTIL=20230531T150000
  ireservation_uid20220606T050000Z-627877fb52cf7@
  ireservation_comp_namereservation
  room_id0
  created_user34
  created2022-05-09 02:10:03
  modified_user34
  modified2022-05-09 02:11:54
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id34
  handlenamek.koizumi
  TrackableUpdater(array)
  id34
  handlenamek.koizumi
  ReservationEventShareUser(empty)
  5(array)
  ReservationEvent(array)
  id1347
  reservation_rrule_id414
  keya8f8a555bb5f640d54c875453a4dd709
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user34
  title公文教室
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230403
  start_time060000
  dtstart20230403060000
  end_date20230403
  end_time100000
  dtend20230403100000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user34
  created2022-04-01 04:48:07
  modified_user34
  modified2022-04-01 04:48:07
  ReservationRrule(array)
  id414
  reservation_id1
  key790b02475e374a2838653acd26e35597
  name
  rruleFREQ=WEEKLY;INTERVAL=1;BYDAY=MO;UNTIL=20230531T150000
  ireservation_uid20220606T060000Z-6246840738565@
  ireservation_comp_namereservation
  room_id0
  created_user34
  created2022-04-01 04:48:07
  modified_user34
  modified2022-04-01 04:48:07
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id34
  handlenamek.koizumi
  TrackableUpdater(array)
  id34
  handlenamek.koizumi
  ReservationEventShareUser(empty)
  6(array)
  ReservationEvent(array)
  id2871
  reservation_rrule_id1061
  keyd878d7a39284e87db13d7bbfcb58f907
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user34
  title書道教室
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230404
  start_time020000
  dtstart20230404020000
  end_date20230404
  end_time040000
  dtend20230404040000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user34
  created2023-03-28 05:45:57
  modified_user34
  modified2023-03-28 05:45:57
  ReservationRrule(array)
  id1061
  reservation_id1
  key222942fc4ac2c5b61b04531e514e9528
  name
  rruleFREQ=MONTHLY;INTERVAL=1;BYDAY=1TU;UNTIL=20240531T150000
  ireservation_uid20230404T020000Z-64227f152792b@
  ireservation_comp_namereservation
  room_id0
  created_user34
  created2023-03-28 05:45:57
  modified_user34
  modified2023-03-28 05:45:57
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id34
  handlenamek.koizumi
  TrackableUpdater(array)
  id34
  handlenamek.koizumi
  ReservationEventShareUser(empty)
  7(array)
  ReservationEvent(array)
  id2923
  reservation_rrule_id1081
  keycf46c88ced175425c50be0b881b2644a
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user73
  title大規模修繕準備委員会
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230404
  start_time050000
  dtstart20230404050000
  end_date20230404
  end_time070000
  dtend20230404070000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user73
  created2023-04-04 00:58:45
  modified_user73
  modified2023-04-04 00:58:45
  ReservationRrule(array)
  id1081
  reservation_id1
  key9f6926e86ceb30161f64a13e62796006
  name
  rrule
  ireservation_uid20230404T050000Z-642b7645eb856@
  ireservation_comp_namereservation
  room_id0
  created_user73
  created2023-04-04 00:58:45
  modified_user73
  modified2023-04-04 00:58:45
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id73
  handlenamesuzuishi
  TrackableUpdater(array)
  id73
  handlenamesuzuishi
  ReservationEventShareUser(empty)
  8(array)
  ReservationEvent(array)
  id1243
  reservation_rrule_id412
  keyc2aa1507944de17973e22f0fcfd2c56b
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user34
  title公文書写
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230405
  start_time053000
  dtstart20230405053000
  end_date20230405
  end_time100000
  dtend20230405100000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(false)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user34
  created2022-04-01 04:44:13
  modified_user34
  modified2022-04-01 04:44:13
  ReservationRrule(array)
  id412
  reservation_id1
  keye491c387266c29ffd56c45e5dd865c1f
  name
  rruleFREQ=WEEKLY;INTERVAL=1;BYDAY=WE;UNTIL=20230531T150000
  ireservation_uid20220601T053000Z-6246831d0738c@
  ireservation_comp_namereservation
  room_id0
  created_user34
  created2022-04-01 04:44:13
  modified_user34
  modified2022-04-01 04:44:13
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id34
  handlenamek.koizumi
  TrackableUpdater(array)
  id34
  handlenamek.koizumi
  ReservationEventShareUser(empty)
  9(array)
  ReservationEvent(array)
  id2360
  reservation_rrule_id818
  keyc2aa1507944de17973e22f0fcfd2c56b
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user34
  title公文書写
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230405
  start_time053000
  dtstart20230405053000
  end_date20230405
  end_time100000
  dtend20230405100000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(false)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user34
  created2022-04-01 04:44:13
  modified_user34
  modified2022-10-05 05:29:37
  ReservationRrule(array)
  id818
  reservation_id1
  keye491c387266c29ffd56c45e5dd865c1f
  name
  rruleFREQ=WEEKLY;INTERVAL=1;BYDAY=WE;UNTIL=20230531T150000
  ireservation_uid20220601T053000Z-6246831d0738c@
  ireservation_comp_namereservation
  room_id0
  created_user34
  created2022-04-01 04:44:13
  modified_user34
  modified2022-10-05 05:29:35
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id34
  handlenamek.koizumi
  TrackableUpdater(array)
  id34
  handlenamek.koizumi
  ReservationEventShareUser(empty)
  10(array)
  ReservationEvent(array)
  id2412
  reservation_rrule_id819
  keyc2aa1507944de17973e22f0fcfd2c56b
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user34
  title公文書写
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230405
  start_time053000
  dtstart20230405053000
  end_date20230405
  end_time100000
  dtend20230405100000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user34
  created2022-04-01 04:44:13
  modified_user34
  modified2022-10-05 05:30:10
  ReservationRrule(array)
  id819
  reservation_id1
  keye491c387266c29ffd56c45e5dd865c1f
  name
  rruleFREQ=WEEKLY;INTERVAL=1;BYDAY=WE;UNTIL=20230531T150000
  ireservation_uid20220601T053000Z-6246831d0738c@
  ireservation_comp_namereservation
  room_id0
  created_user34
  created2022-04-01 04:44:13
  modified_user34
  modified2022-10-05 05:30:08
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id34
  handlenamek.koizumi
  TrackableUpdater(array)
  id34
  handlenamek.koizumi
  ReservationEventShareUser(empty)
  11(array)
  ReservationEvent(array)
  id1296
  reservation_rrule_id413
  key4f2b213960aaa841588d6491b2b054ca
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user34
  title公文教室
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230406
  start_time060000
  dtstart20230406060000
  end_date20230406
  end_time100000
  dtend20230406100000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user34
  created2022-04-01 04:45:16
  modified_user34
  modified2022-04-01 04:45:16
  ReservationRrule(array)
  id413
  reservation_id1
  key2957b445cde1e97ffc073a92702842ed
  name
  rruleFREQ=WEEKLY;INTERVAL=1;BYDAY=TH;UNTIL=20230531T150000
  ireservation_uid20220602T060000Z-6246835c7e70f@
  ireservation_comp_namereservation
  room_id0
  created_user34
  created2022-04-01 04:45:16
  modified_user34
  modified2022-04-01 04:45:16
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id34
  handlenamek.koizumi
  TrackableUpdater(array)
  id34
  handlenamek.koizumi
  ReservationEventShareUser(empty)
  12(array)
  ReservationEvent(array)
  id2916
  reservation_rrule_id1074
  key618273cd141f11bc9087ca589553adc1
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user34
  title大規模修繕準備委員会
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230407
  start_time040000
  dtstart20230407040000
  end_date20230407
  end_time083000
  dtend20230407083000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user34
  created2023-04-03 02:45:31
  modified_user34
  modified2023-04-03 02:45:31
  ReservationRrule(array)
  id1074
  reservation_id1
  key6f7bcf4f8dfbb855413fc1a265f34f91
  name
  rrule
  ireservation_uid20230407T040000Z-642a3dcb38e94@
  ireservation_comp_namereservation
  room_id0
  created_user34
  created2023-04-03 02:45:31
  modified_user34
  modified2023-04-03 02:45:31
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id34
  handlenamek.koizumi
  TrackableUpdater(array)
  id34
  handlenamek.koizumi
  ReservationEventShareUser(empty)
  13(array)
  ReservationEvent(array)
  id2915
  reservation_rrule_id1073
  keyf2ca4878677dbf1ab921a25e65263b76
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user160
  title駐車場担当理事と新理事引き継ぎ
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230407
  start_time090000
  dtstart20230407090000
  end_date20230407
  end_time113000
  dtend20230407113000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user160
  created2023-04-02 09:52:06
  modified_user160
  modified2023-04-02 09:52:06
  ReservationRrule(array)
  id1073
  reservation_id1
  key561e163485402fae57096ef15debd16b
  name
  rrule
  ireservation_uid20230407T090000Z-642950468c967@
  ireservation_comp_namereservation
  room_id0
  created_user160
  created2023-04-02 09:52:06
  modified_user160
  modified2023-04-02 09:52:06
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id160
  handlenamey.matsuura
  TrackableUpdater(array)
  id160
  handlenamey.matsuura
  ReservationEventShareUser(empty)
  14(array)
  ReservationEvent(array)
  id3041
  reservation_rrule_id1128
  keyaba219f3bf26284ccd6c2a7cc37d5b56
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user103
  title空手教室
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230408
  start_time000000
  dtstart20230408000000
  end_date20230408
  end_time023000
  dtend20230408023000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user103
  created2023-04-24 10:59:07
  modified_user103
  modified2023-04-24 10:59:07
  ReservationRrule(array)
  id1128
  reservation_id1
  keydfafa59d66e5c8d218664b21aae7489d
  name
  rrule
  ireservation_uid20230408T000000Z-644660fb39913@
  ireservation_comp_namereservation
  room_id0
  created_user103
  created2023-04-24 10:59:07
  modified_user103
  modified2023-04-24 10:59:07
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id103
  handlenamem.ando
  TrackableUpdater(array)
  id103
  handlenamem.ando
  ReservationEventShareUser(empty)
  15(array)
  ReservationEvent(array)
  id1826
  reservation_rrule_id566
  keye0d6237fd261460692705b5fafd1f18b
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user107
  title防災委員会
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230408
  start_time100000
  dtstart20230408100000
  end_date20230408
  end_time120000
  dtend20230408120000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user107
  created2022-05-27 00:18:38
  modified_user107
  modified2022-05-27 00:18:38
  ReservationRrule(array)
  id566
  reservation_id1
  key83c59e25da11627ee7e55bc74f6563aa
  name
  rrule
  ireservation_uid20230408T100000Z-629018de85279@
  ireservation_comp_namereservation
  room_id0
  created_user107
  created2022-05-27 00:18:38
  modified_user107
  modified2022-05-27 00:18:38
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id107
  handlenamehosogai
  TrackableUpdater(array)
  id107
  handlenamehosogai
  ReservationEventShareUser(empty)
  16(array)
  ReservationEvent(array)
  id2308
  reservation_rrule_id809
  key786b78fa7b19679471c7d6f96a1be369
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user159
  title理事会
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230409
  start_time050000
  dtstart20230409050000
  end_date20230409
  end_time090000
  dtend20230409090000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user159
  created2022-10-02 03:02:29
  modified_user159
  modified2022-10-02 03:02:29
  ReservationRrule(array)
  id809
  reservation_id1
  keyd7b42d4714577b8a92b606a9b9fde404
  name
  rruleFREQ=MONTHLY;INTERVAL=1;BYDAY=2SU;UNTIL=20230430T150000
  ireservation_uid20221113T050000Z-6338ff458dfd1@
  ireservation_comp_namereservation
  room_id0
  created_user159
  created2022-10-02 03:02:29
  modified_user159
  modified2022-10-02 03:02:29
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id159
  handlenamet.ishida
  TrackableUpdater(array)
  id159
  handlenamet.ishida
  ReservationEventShareUser(empty)
  17(array)
  ReservationEvent(array)
  id1113
  reservation_rrule_id381
  keyb3b57a7250e51a20c7ac3ee8c24e44cb
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user34
  titleパッチワーク
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230410
  start_time010000
  dtstart20230410010000
  end_date20230410
  end_time060000
  dtend20230410060000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user34
  created2022-04-01 00:35:56
  modified_user34
  modified2022-04-01 00:35:56
  ReservationRrule(array)
  id381
  reservation_id1
  keyf4c728d5203ffb8862c7bc6e169dc75a
  name
  rruleFREQ=MONTHLY;INTERVAL=1;BYDAY=2MO;COUNT=12
  ireservation_uid20220509T010000Z-624648ecb65e1@
  ireservation_comp_namereservation
  room_id0
  created_user34
  created2022-04-01 00:35:56
  modified_user34
  modified2022-04-01 00:35:56
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id34
  handlenamek.koizumi
  TrackableUpdater(array)
  id34
  handlenamek.koizumi
  ReservationEventShareUser(empty)
  18(array)
  ReservationEvent(array)
  id1348
  reservation_rrule_id414
  key574842cac7e2604001209471bedbf693
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user34
  title公文教室
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230410
  start_time060000
  dtstart20230410060000
  end_date20230410
  end_time100000
  dtend20230410100000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user34
  created2022-04-01 04:48:07
  modified_user34
  modified2022-04-01 04:48:07
  ReservationRrule(array)
  id414
  reservation_id1
  key790b02475e374a2838653acd26e35597
  name
  rruleFREQ=WEEKLY;INTERVAL=1;BYDAY=MO;UNTIL=20230531T150000
  ireservation_uid20220606T060000Z-6246840738565@
  ireservation_comp_namereservation
  room_id0
  created_user34
  created2022-04-01 04:48:07
  modified_user34
  modified2022-04-01 04:48:07
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id34
  handlenamek.koizumi
  TrackableUpdater(array)
  id34
  handlenamek.koizumi
  ReservationEventShareUser(empty)
  19(array)
  ReservationEvent(array)
  id2917
  reservation_rrule_id1075
  keyee733b182ab857e62b7eae64c92577a7
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user73
  title大規模修繕準備委員会
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230411
  start_time040000
  dtstart20230411040000
  end_date20230411
  end_time080000
  dtend20230411080000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user73
  created2023-04-03 04:16:21
  modified_user73
  modified2023-04-03 04:16:21
  ReservationRrule(array)
  id1075
  reservation_id1
  key664bc90bcc46ffb1939b1134eb677303
  name
  rrule
  ireservation_uid20230411T040000Z-642a5315cfc44@
  ireservation_comp_namereservation
  room_id0
  created_user73
  created2023-04-03 04:16:21
  modified_user73
  modified2023-04-03 04:16:21
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id73
  handlenamesuzuishi
  TrackableUpdater(array)
  id73
  handlenamesuzuishi
  ReservationEventShareUser(empty)
  20(array)
  ReservationEvent(array)
  id2655
  reservation_rrule_id1041
  key5df5dd82bc076fdd7e08fdd210fd790f
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user107
  title会計委員会
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230412
  start_time010000
  dtstart20230412010000
  end_date20230412
  end_time040000
  dtend20230412040000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user107
  created2023-03-22 11:36:32
  modified_user107
  modified2023-03-22 11:36:32
  ReservationRrule(array)
  id1041
  reservation_id1
  key0af12ec33ba7a8dc6abfa572de98f259
  name
  rrule
  ireservation_uid20230412T010000Z-641ae84012689@
  ireservation_comp_namereservation
  room_id0
  created_user107
  created2023-03-22 11:36:32
  modified_user107
  modified2023-03-22 11:36:32
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id107
  handlenamehosogai
  TrackableUpdater(array)
  id107
  handlenamehosogai
  ReservationEventShareUser(empty)
  21(array)
  ReservationEvent(array)
  id1244
  reservation_rrule_id412
  keye1fe506767318172b30d9c035037094e
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user34
  title公文書写
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230412
  start_time053000
  dtstart20230412053000
  end_date20230412
  end_time100000
  dtend20230412100000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(false)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user34
  created2022-04-01 04:44:13
  modified_user34
  modified2022-04-01 04:44:13
  ReservationRrule(array)
  id412
  reservation_id1
  keye491c387266c29ffd56c45e5dd865c1f
  name
  rruleFREQ=WEEKLY;INTERVAL=1;BYDAY=WE;UNTIL=20230531T150000
  ireservation_uid20220601T053000Z-6246831d0738c@
  ireservation_comp_namereservation
  room_id0
  created_user34
  created2022-04-01 04:44:13
  modified_user34
  modified2022-04-01 04:44:13
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id34
  handlenamek.koizumi
  TrackableUpdater(array)
  id34
  handlenamek.koizumi
  ReservationEventShareUser(empty)
  22(array)
  ReservationEvent(array)
  id2361
  reservation_rrule_id818
  keye1fe506767318172b30d9c035037094e
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user34
  title公文書写
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230412
  start_time053000
  dtstart20230412053000
  end_date20230412
  end_time100000
  dtend20230412100000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(false)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user34
  created2022-04-01 04:44:13
  modified_user34
  modified2022-10-05 05:29:37
  ReservationRrule(array)
  id818
  reservation_id1
  keye491c387266c29ffd56c45e5dd865c1f
  name
  rruleFREQ=WEEKLY;INTERVAL=1;BYDAY=WE;UNTIL=20230531T150000
  ireservation_uid20220601T053000Z-6246831d0738c@
  ireservation_comp_namereservation
  room_id0
  created_user34
  created2022-04-01 04:44:13
  modified_user34
  modified2022-10-05 05:29:35
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id34
  handlenamek.koizumi
  TrackableUpdater(array)
  id34
  handlenamek.koizumi
  ReservationEventShareUser(empty)
  23(array)
  ReservationEvent(array)
  id2413
  reservation_rrule_id819
  keye1fe506767318172b30d9c035037094e
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user34
  title公文書写
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230412
  start_time053000
  dtstart20230412053000
  end_date20230412
  end_time100000
  dtend20230412100000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user34
  created2022-04-01 04:44:13
  modified_user34
  modified2022-10-05 05:30:10
  ReservationRrule(array)
  id819
  reservation_id1
  keye491c387266c29ffd56c45e5dd865c1f
  name
  rruleFREQ=WEEKLY;INTERVAL=1;BYDAY=WE;UNTIL=20230531T150000
  ireservation_uid20220601T053000Z-6246831d0738c@
  ireservation_comp_namereservation
  room_id0
  created_user34
  created2022-04-01 04:44:13
  modified_user34
  modified2022-10-05 05:30:08
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id34
  handlenamek.koizumi
  TrackableUpdater(array)
  id34
  handlenamek.koizumi
  ReservationEventShareUser(empty)
  24(array)
  ReservationEvent(array)
  id2931
  reservation_rrule_id1089
  key527b8c225c7f9a79ec666aab6752f563
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user162
  title理事会打ち合わせ
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230412
  start_time100000
  dtstart20230412100000
  end_date20230412
  end_time120000
  dtend20230412120000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user162
  created2023-04-09 05:33:27
  modified_user162
  modified2023-04-09 05:33:27
  ReservationRrule(array)
  id1089
  reservation_id1
  key1633047557f754c3b7cad4cded9d499d
  name
  rrule
  ireservation_uid20230412T100000Z-64324e27e29ac@
  ireservation_comp_namereservation
  room_id0
  created_user162
  created2023-04-09 05:33:27
  modified_user162
  modified2023-04-09 05:33:27
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id162
  handlenameh.kosugi
  TrackableUpdater(array)
  id162
  handlenameh.kosugi
  ReservationEventShareUser(empty)
  25(array)
  ReservationEvent(array)
  id2954
  reservation_rrule_id1101
  key55bb7535ed8b27245cafa8613bb982b4
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user34
  title常磐会誕生会
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230413
  start_time010000
  dtstart20230413010000
  end_date20230413
  end_time040000
  dtend20230413040000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user34
  created2023-04-13 00:37:56
  modified_user34
  modified2023-04-13 00:37:56
  ReservationRrule(array)
  id1101
  reservation_id1
  key7666ea21545beba99ff72907535a8fc7
  name
  rruleFREQ=MONTHLY;INTERVAL=1;BYDAY=2TH;UNTIL=20240331T150000
  ireservation_uid20230413T040000Z-64227c5eaacfb#94bd0e6de94f9b1c0db546accf0e344f@
  ireservation_comp_namereservation
  room_id0
  created_user34
  created2023-04-13 00:37:56
  modified_user34
  modified2023-04-13 00:37:56
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id34
  handlenamek.koizumi
  TrackableUpdater(array)
  id34
  handlenamek.koizumi
  ReservationEventShareUser(empty)
  26(array)
  ReservationEvent(array)
  id1297
  reservation_rrule_id413
  keyb46eb14c3b8986918681fe81ab5632fe
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user34
  title公文教室
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230413
  start_time060000
  dtstart20230413060000
  end_date20230413
  end_time100000
  dtend20230413100000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user34
  created2022-04-01 04:45:16
  modified_user34
  modified2022-04-01 04:45:16
  ReservationRrule(array)
  id413
  reservation_id1
  key2957b445cde1e97ffc073a92702842ed
  name
  rruleFREQ=WEEKLY;INTERVAL=1;BYDAY=TH;UNTIL=20230531T150000
  ireservation_uid20220602T060000Z-6246835c7e70f@
  ireservation_comp_namereservation
  room_id0
  created_user34
  created2022-04-01 04:45:16
  modified_user34
  modified2022-04-01 04:45:16
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id34
  handlenamek.koizumi
  TrackableUpdater(array)
  id34
  handlenamek.koizumi
  ReservationEventShareUser(empty)
  27(array)
  ReservationEvent(array)
  id2941
  reservation_rrule_id1099
  key70257c3e045e4afbb762c13f7a7615a8
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user107
  title臨時緑化委員会
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230413
  start_time103000
  dtstart20230413103000
  end_date20230413
  end_time120000
  dtend20230413120000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user107
  created2023-04-12 08:49:48
  modified_user107
  modified2023-04-12 08:49:48
  ReservationRrule(array)
  id1099
  reservation_id1
  key1719c92f97dae4abe09effc03e3ba5f9
  name
  rrule
  ireservation_uid20230413T103000Z-643670ac1c76d@
  ireservation_comp_namereservation
  room_id0
  created_user107
  created2023-04-12 08:49:48
  modified_user107
  modified2023-04-12 08:49:48
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id107
  handlenamehosogai
  TrackableUpdater(array)
  id107
  handlenamehosogai
  ReservationEventShareUser(empty)
  28(array)
  ReservationEvent(array)
  id3042
  reservation_rrule_id1129
  key33ce8b7342622a7e8de7c3fd7386763d
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user103
  title空手教室
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230415
  start_time000000
  dtstart20230415000000
  end_date20230415
  end_time023000
  dtend20230415023000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user103
  created2023-04-24 11:00:31
  modified_user103
  modified2023-04-24 11:00:31
  ReservationRrule(array)
  id1129
  reservation_id1
  key68e1f787a66287b84e70fb1b6a3abc98
  name
  rrule
  ireservation_uid20230415T000000Z-6446614f234ca@
  ireservation_comp_namereservation
  room_id0
  created_user103
  created2023-04-24 11:00:31
  modified_user103
  modified2023-04-24 11:00:31
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id103
  handlenamem.ando
  TrackableUpdater(array)
  id103
  handlenamem.ando
  ReservationEventShareUser(empty)
  29(array)
  ReservationEvent(array)
  id2922
  reservation_rrule_id1080
  key962c1ed2d7788cfe320d8d36058763af
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user8
  title次年度ブロック委員会
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230415
  start_time040000
  dtstart20230415040000
  end_date20230415
  end_time060000
  dtend20230415060000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user8
  created2023-04-03 13:33:50
  modified_user8
  modified2023-04-03 13:35:05
  ReservationRrule(array)
  id1080
  reservation_id1
  keya99173e16c71dcf08fd388fcd96d3500
  name
  rrule
  ireservation_uid20230415T040000Z-642ad5be89adf@
  ireservation_comp_namereservation
  room_id0
  created_user8
  created2023-04-03 13:33:50
  modified_user8
  modified2023-04-03 13:35:05
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id8
  handlenamearai.k
  TrackableUpdater(array)
  id8
  handlenamearai.k
  ReservationEventShareUser(empty)
  30(array)
  ReservationEvent(array)
  id1461
  reservation_rrule_id435
  key194c1d7e97ee57148d61f0e00c105810
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user103
  titleパソコン相談会
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230416
  start_time003000
  dtstart20230416003000
  end_date20230416
  end_time020000
  dtend20230416020000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user103
  created2022-04-07 20:57:00
  modified_user103
  modified2022-04-07 20:57:00
  ReservationRrule(array)
  id435
  reservation_id1
  key046dd64d9b2d46e503781c06641d4801
  name
  rruleFREQ=MONTHLY;INTERVAL=1;BYDAY=3SU;COUNT=11
  ireservation_uid20220619T003000Z-624f501c38b17@
  ireservation_comp_namereservation
  room_id0
  created_user103
  created2022-04-07 20:57:00
  modified_user103
  modified2022-04-07 20:57:00
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id103
  handlenamem.ando
  TrackableUpdater(array)
  id103
  handlenamem.ando
  ReservationEventShareUser(empty)
  31(array)
  ReservationEvent(array)
  id1496
  reservation_rrule_id438
  key9c2245a88bf00be679708eaa83784cde
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user103
  titleIT委員会
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230416
  start_time020000
  dtstart20230416020000
  end_date20230416
  end_time030000
  dtend20230416030000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user103
  created2022-04-07 21:04:37
  modified_user103
  modified2022-04-07 21:04:38
  ReservationRrule(array)
  id438
  reservation_id1
  keyaae5ac999c291c46df8ddb8090d83318
  name
  rruleFREQ=MONTHLY;INTERVAL=1;BYDAY=3SU;COUNT=12
  ireservation_uid20220619T020000Z-624f50730fcd5#46999fd5fb5e85fe3201c873d8346567@
  ireservation_comp_namereservation
  room_id0
  created_user103
  created2022-04-07 21:04:37
  modified_user103
  modified2022-04-07 21:04:37
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id103
  handlenamem.ando
  TrackableUpdater(array)
  id103
  handlenamem.ando
  ReservationEventShareUser(empty)
  32(array)
  ReservationEvent(array)
  id2933
  reservation_rrule_id1091
  key876d13598da206ad8a2e5f85ae7bf2d7
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user162
  title臨時理事会
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230416
  start_time050000
  dtstart20230416050000
  end_date20230416
  end_time090000
  dtend20230416090000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user162
  created2023-04-09 07:09:58
  modified_user162
  modified2023-04-09 07:09:58
  ReservationRrule(array)
  id1091
  reservation_id1
  keyee8e7503a1bd51d595d1a22410501bd4
  name
  rrule
  ireservation_uid20230416T050000Z-643264c6aeb1e@
  ireservation_comp_namereservation
  room_id0
  created_user162
  created2023-04-09 07:09:58
  modified_user162
  modified2023-04-09 07:09:58
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id162
  handlenameh.kosugi
  TrackableUpdater(array)
  id162
  handlenameh.kosugi
  ReservationEventShareUser(empty)
  33(array)
  ReservationEvent(array)
  id2974
  reservation_rrule_id1110
  key92cec5640f5d749f7de2619d111a4505
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user73
  title大規模修繕準備委員会
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230417
  start_time003000
  dtstart20230417003000
  end_date20230417
  end_time060000
  dtend20230417060000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user73
  created2023-04-12 03:44:44
  modified_user73
  modified2023-04-16 09:20:14
  ReservationRrule(array)
  id1110
  reservation_id1
  keyed61fd959c9311797f9cd34c2d27e45e
  name
  rrule
  ireservation_uid20230417T003000Z-6436292c56a35@
  ireservation_comp_namereservation
  room_id0
  created_user73
  created2023-04-12 03:44:44
  modified_user73
  modified2023-04-16 09:20:14
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id73
  handlenamesuzuishi
  TrackableUpdater(array)
  id73
  handlenamesuzuishi
  ReservationEventShareUser(empty)
  34(array)
  ReservationEvent(array)
  id1349
  reservation_rrule_id414
  keyc520aa241ab9ced30fd6000cad121e3b
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user34
  title公文教室
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230417
  start_time060000
  dtstart20230417060000
  end_date20230417
  end_time100000
  dtend20230417100000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user34
  created2022-04-01 04:48:07
  modified_user34
  modified2022-04-01 04:48:07
  ReservationRrule(array)
  id414
  reservation_id1
  key790b02475e374a2838653acd26e35597
  name
  rruleFREQ=WEEKLY;INTERVAL=1;BYDAY=MO;UNTIL=20230531T150000
  ireservation_uid20220606T060000Z-6246840738565@
  ireservation_comp_namereservation
  room_id0
  created_user34
  created2022-04-01 04:48:07
  modified_user34
  modified2022-04-01 04:48:07
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id34
  handlenamek.koizumi
  TrackableUpdater(array)
  id34
  handlenamek.koizumi
  ReservationEventShareUser(empty)
  35(array)
  ReservationEvent(array)
  id2563
  reservation_rrule_id952
  key95747811d8a1fbe26a60390c608dcc67
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user107
  titleお楽しみ映画会
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230418
  start_time040000
  dtstart20230418040000
  end_date20230418
  end_time080000
  dtend20230418080000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user107
  created2023-01-08 09:11:03
  modified_user107
  modified2023-01-08 09:11:03
  ReservationRrule(array)
  id952
  reservation_id1
  key24ca6488df38c960b31b1ba78e6ea25f
  name
  rrule
  ireservation_uid20230418T040000Z-63ba88a77d5ab@
  ireservation_comp_namereservation
  room_id0
  created_user107
  created2023-01-08 09:11:03
  modified_user107
  modified2023-01-08 09:11:03
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id107
  handlenamehosogai
  TrackableUpdater(array)
  id107
  handlenamehosogai
  ReservationEventShareUser(empty)
  36(array)
  ReservationEvent(array)
  id1198
  reservation_rrule_id411
  keyf232bfe11e311b73f68b6526a253e669
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user34
  titleつくしんぼ文庫
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230419
  start_time010000
  dtstart20230419010000
  end_date20230419
  end_time040000
  dtend20230419040000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(true)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user34
  created2022-04-01 04:41:50
  modified_user34
  modified2022-04-01 04:41:50
  ReservationRrule(array)
  id411
  reservation_id1
  key6127b6facd0c65065b5d6dccb0654e17
  name
  rruleFREQ=MONTHLY;INTERVAL=1;BYDAY=3WE;COUNT=12
  ireservation_uid20220518T010000Z-6246828e6556c@
  ireservation_comp_namereservation
  room_id0
  created_user34
  created2022-04-01 04:41:50
  modified_user34
  modified2022-04-01 04:41:50
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id34
  handlenamek.koizumi
  TrackableUpdater(array)
  id34
  handlenamek.koizumi
  ReservationEventShareUser(empty)
  37(array)
  ReservationEvent(array)
  id1245
  reservation_rrule_id412
  keydffa745df1e9ff130688916868cfc88a
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user34
  title公文書写
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230419
  start_time053000
  dtstart20230419053000
  end_date20230419
  end_time100000
  dtend20230419100000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(false)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user34
  created2022-04-01 04:44:13
  modified_user34
  modified2022-04-01 04:44:13
  ReservationRrule(array)
  id412
  reservation_id1
  keye491c387266c29ffd56c45e5dd865c1f
  name
  rruleFREQ=WEEKLY;INTERVAL=1;BYDAY=WE;UNTIL=20230531T150000
  ireservation_uid20220601T053000Z-6246831d0738c@
  ireservation_comp_namereservation
  room_id0
  created_user34
  created2022-04-01 04:44:13
  modified_user34
  modified2022-04-01 04:44:13
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33
  openText毎日 09:00 - 22:00 (UTC+09:00) アジア／東京
  TrackableCreator(array)
  id34
  handlenamek.koizumi
  TrackableUpdater(array)
  id34
  handlenamek.koizumi
  ReservationEventShareUser(empty)
  38(array)
  ReservationEvent(array)
  id2362
  reservation_rrule_id818
  keydffa745df1e9ff130688916868cfc88a
  room_id0
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  target_user34
  title公文書写
  title_icon
  location
  contact
  description
  is_allday(false)
  start_date20230419
  start_time053000
  dtstart20230419053000
  end_date20230419
  end_time100000
  dtend20230419100000
  timezone_offset0.0
  timezoneAsia/Tokyo
  location_key4ac901d3c60a74e924613b75b83d7a2f
  status1
  is_active(true)
  is_latest(false)
  recurrence_event_id0
  exception_event_id0
  is_enable_mail(false)
  email_send_timing5
  calendar_key(null)
  created_user34
  created2022-04-01 04:44:13
  modified_user34
  modified2022-10-05 05:29:37
  ReservationRrule(array)
  id818
  reservation_id1
  keye491c387266c29ffd56c45e5dd865c1f
  name
  rruleFREQ=WEEKLY;INTERVAL=1;BYDAY=WE;UNTIL=20230531T150000
  ireservation_uid20220601T053000Z-6246831d0738c@
  ireservation_comp_namereservation
  room_id0
  created_user34
  created2022-04-01 04:44:13
  modified_user34
  modified2022-10-05 05:29:35
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2020-02-29 08:00:35
  modified_user(null)
  modified2020-02-29 08:00:35
  ReservationLocation(array)
  id4
  key4ac901d3c60a74e924613b75b83d7a2f
  language_id2
  is_translation(false)
  is_origin(true)
  is_original_copy(false)
  category_id(null)
  location_name洋室
  detail
  add_authority(false)
  time_tableSun|Mon|Tue|Wed|Thu|Fri|Sat
  start_time2022-03-04 00:00:00
  end_time2022-03-04 13:00:00
  timezoneAsia/Tokyo
  use_private(true)
  use_auth_flag(false)
  use_all_rooms(true)
  use_workflow(false)
  weight0
  contact(null)
  created_user(null)
  created2021-06-23 21:43:05
  modified_user103
  modified2022-03-04 20:27:33

2023年 5月

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

master

Total Time: 204 ms Total Queries: 384 queries

Query Explain:

Memory

Timers

Logs

View Variables

Total Time: 204 ms
Total Queries: 384 queries