| 5(日) | 6(月) | 7(火) | 8(水) | 9(木) | 10(金) | 11(土) | |
洋室 | 11:00 - 13:00 書道教室 | 10:00 - 12:00 防災キャラバン | |||||
和室 | 13:00 - 15:00 52-4西ブロック | ||||||
テラス | 10:00 - 11:00 柿取り大会 | ||||||
★試験用 |
- パブリック
集会所施設予約
No post data.
To view Cookies, add CookieComponent to Controller
| Query | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|
| SELECT COUNT(*) AS `count` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` INNER JOIN `hijiri3_hijirigaoka`.`rooms` AS `Room` ON (`Room`.`id` = `Page`.`room_id`) WHERE `Page`.`permalink` = 'reservations/reservations/index' AND `Room`.`space_id` = 2 | 1 | 1 | 1 | |
| SELECT `Page`.`weight` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE `Page`.`id` = 4 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Frame`.`id`, `Frame`.`room_id`, `Frame`.`box_id`, `Frame`.`plugin_key`, `Frame`.`block_id`, `Frame`.`key`, `Frame`.`header_type`, `Frame`.`weight`, `Frame`.`is_deleted`, `Frame`.`default_action`, `Frame`.`default_setting_action`, `FramePublicLanguage`.`id`, `FramePublicLanguage`.`language_id`, `FramePublicLanguage`.`frame_id`, `FramePublicLanguage`.`is_public`, `FramesLanguage`.`id`, `FramesLanguage`.`language_id`, `FramesLanguage`.`frame_id`, `FramesLanguage`.`name`, `FramesLanguage`.`is_origin`, `FramesLanguage`.`is_translation`, `FramesLanguage`.`is_original_copy`, `Block`.`id`, `Block`.`room_id`, `Block`.`plugin_key`, `Block`.`key`, `Block`.`public_type`, `Block`.`publish_start`, `Block`.`publish_end`, `Block`.`content_count`, `BlocksLanguage`.`language_id`, `BlocksLanguage`.`block_id`, `BlocksLanguage`.`name`, `BlocksLanguage`.`is_origin`, `BlocksLanguage`.`is_translation`, `BlocksLanguage`.`is_original_copy` FROM `hijiri3_hijirigaoka`.`frames` AS `Frame` INNER JOIN `hijiri3_hijirigaoka`.`frame_public_languages` AS `FramePublicLanguage` ON (`FramePublicLanguage`.`frame_id` = `Frame`.`id` AND `FramePublicLanguage`.`language_id` IN ('0', '2') AND `FramePublicLanguage`.`is_public` = '1') INNER JOIN `hijiri3_hijirigaoka`.`frames_languages` AS `FramesLanguage` ON (`FramesLanguage`.`frame_id` = `Frame`.`id` AND `FramesLanguage`.`language_id` = '2') LEFT JOIN `hijiri3_hijirigaoka`.`blocks` AS `Block` ON (`Frame`.`block_id` = `Block`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND `BlocksLanguage`.`language_id` = '2') WHERE `Frame`.`id` = 677 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Box`.`id`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id` FROM `hijiri3_hijirigaoka`.`boxes` AS `Box` WHERE `Box`.`id` = 1605 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`weight`, `Page`.`sort_key`, `Page`.`child_count`, `Page`.`permalink`, `Page`.`slug`, `Page`.`is_container_fluid`, `Page`.`theme` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE `Page`.`id` = 198 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`active`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` WHERE `id` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `room_id` = 1 AND `language_id` = 2 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PagesLanguage`.`id`, `PagesLanguage`.`language_id`, `PagesLanguage`.`page_id`, `PagesLanguage`.`name`, `PagesLanguage`.`meta_title`, `PagesLanguage`.`meta_description`, `PagesLanguage`.`meta_keywords`, `PagesLanguage`.`meta_robots` FROM `hijiri3_hijirigaoka`.`pages_languages` AS `PagesLanguage` WHERE `PagesLanguage`.`page_id` = 198 AND `PagesLanguage`.`language_id` = 2 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PluginsRoom`.`plugin_key` FROM `hijiri3_hijirigaoka`.`plugins_rooms` AS `PluginsRoom` WHERE `room_id` = 1 | 22 | 22 | 0 | |
| SELECT `BlockRolePermission`.`id`, `BlockRolePermission`.`roles_room_id`, `BlockRolePermission`.`block_key`, `BlockRolePermission`.`permission`, `BlockRolePermission`.`value` FROM `hijiri3_hijirigaoka`.`block_role_permissions` AS `BlockRolePermission` WHERE block_key = ('497baae68f535cd79f72f6a4fdfe1c66') AND `roles_room_id` IS NULL | 0 | 0 | 0 | |
| SELECT `BlockSetting`.`block_key`, `BlockSetting`.`field_name`, `BlockSetting`.`value` FROM `hijiri3_hijirigaoka`.`block_settings` AS `BlockSetting` WHERE `room_id` = 1 AND block_key = ('497baae68f535cd79f72f6a4fdfe1c66') AND `field_name` IN ('use_workflow', 'use_comment_approval') | 0 | 0 | 0 | |
| SELECT `PageContainer`.`id`, `PageContainer`.`page_id`, `PageContainer`.`container_type`, `PageContainer`.`is_published`, `PageContainer`.`is_configured` FROM `hijiri3_hijirigaoka`.`page_containers` AS `PageContainer` WHERE `PageContainer`.`page_id` = 198 | 5 | 5 | 0 | |
| SELECT `BoxesPageContainer`.`id`, `BoxesPageContainer`.`page_container_id`, `BoxesPageContainer`.`page_id`, `BoxesPageContainer`.`container_type`, `BoxesPageContainer`.`box_id`, `BoxesPageContainer`.`is_published`, `BoxesPageContainer`.`weight`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`weight`, `Room`.`sort_key`, `Room`.`child_count`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `RoomsLanguage`.`id`, `RoomsLanguage`.`name` FROM `hijiri3_hijirigaoka`.`boxes_page_containers` AS `BoxesPageContainer` INNER JOIN `hijiri3_hijirigaoka`.`boxes` AS `Box` ON (`Box`.`id` = `BoxesPageContainer`.`box_id`) INNER JOIN `hijiri3_hijirigaoka`.`rooms` AS `Room` ON (`Box`.`room_id` = `Room`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` ON (`RoomsLanguage`.`language_id` = '2' AND `Room`.`id` = `RoomsLanguage`.`room_id`) WHERE `BoxesPageContainer`.`page_container_id` IN (986, 987, 988, 989, 990) AND `BoxesPageContainer`.`is_published` = '1' ORDER BY `BoxesPageContainer`.`page_container_id` ASC, `BoxesPageContainer`.`weight` ASC | 5 | 5 | 1 | maybe slow |
| SELECT `Frame`.`id`, `Frame`.`room_id`, `Frame`.`box_id`, `Frame`.`plugin_key`, `Frame`.`block_id`, `Frame`.`key`, `Frame`.`header_type`, `Frame`.`weight`, `Frame`.`is_deleted`, `Frame`.`default_action`, `Frame`.`default_setting_action`, `FramePublicLanguage`.`id`, `FramePublicLanguage`.`language_id`, `FramePublicLanguage`.`frame_id`, `FramePublicLanguage`.`is_public`, `FramesLanguage`.`id`, `FramesLanguage`.`language_id`, `FramesLanguage`.`frame_id`, `FramesLanguage`.`name`, `FramesLanguage`.`is_origin`, `FramesLanguage`.`is_translation`, `FramesLanguage`.`is_original_copy`, `Block`.`id`, `Block`.`room_id`, `Block`.`plugin_key`, `Block`.`key`, `Block`.`public_type`, `Block`.`publish_start`, `Block`.`publish_end`, `Block`.`content_count`, `BlocksLanguage`.`language_id`, `BlocksLanguage`.`block_id`, `BlocksLanguage`.`name`, `BlocksLanguage`.`is_origin`, `BlocksLanguage`.`is_translation`, `BlocksLanguage`.`is_original_copy` FROM `hijiri3_hijirigaoka`.`frames` AS `Frame` INNER JOIN `hijiri3_hijirigaoka`.`frame_public_languages` AS `FramePublicLanguage` ON (`FramePublicLanguage`.`frame_id` = `Frame`.`id` AND `FramePublicLanguage`.`language_id` IN ('0', '2') AND `FramePublicLanguage`.`is_public` = '1') INNER JOIN `hijiri3_hijirigaoka`.`frames_languages` AS `FramesLanguage` ON (`FramesLanguage`.`frame_id` = `Frame`.`id` AND `FramesLanguage`.`language_id` = '2') LEFT JOIN `hijiri3_hijirigaoka`.`blocks` AS `Block` ON (`Frame`.`block_id` = `Block`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND `BlocksLanguage`.`language_id` = '2') WHERE `Frame`.`box_id` IN (1603, 18, 1605, 19, 45) AND `Frame`.`is_deleted` = '0' ORDER BY `Frame`.`box_id` ASC, `Frame`.`is_deleted` ASC, `Frame`.`weight` ASC | 3 | 3 | 1 | maybe slow |
| SELECT `Page`.`sort_key` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE `Page`.`id` = 198 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Page`.`id` 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 | 0 | |
| SELECT `Page`.`theme` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE `id` IN (1, 198) AND `theme` IS NOT NULL ORDER BY `sort_key` desc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Block`.`id`, `Block`.`room_id`, `Block`.`plugin_key`, `Block`.`key`, `Block`.`public_type`, `Block`.`publish_start`, `Block`.`publish_end`, `Block`.`content_count`, `Block`.`created_user`, `Block`.`created`, `Block`.`modified_user`, `Block`.`modified` FROM `hijiri3_hijirigaoka`.`blocks` AS `Block` WHERE `room_id` = 1 AND `plugin_key` = 'reservations' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Category`.`id`, `Category`.`block_id`, `Category`.`key`, `CategoryOrder`.`id`, `CategoryOrder`.`category_key`, `CategoryOrder`.`block_key`, `CategoryOrder`.`weight`, `CategoriesLanguage`.`id`, `CategoriesLanguage`.`language_id`, `CategoriesLanguage`.`category_id`, `CategoriesLanguage`.`name` FROM `hijiri3_hijirigaoka`.`categories` AS `Category` INNER JOIN `hijiri3_hijirigaoka`.`category_orders` AS `CategoryOrder` ON (`CategoryOrder`.`category_key`=`Category`.`key`) LEFT JOIN `hijiri3_hijirigaoka`.`categories_languages` AS `CategoriesLanguage` ON (`CategoriesLanguage`.`category_id` = `Category`.`id` AND `CategoriesLanguage`.`language_id` = 2) WHERE `Category`.`block_id` = 277 ORDER BY `CategoryOrder`.`weight` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `ReservationFrameSetting`.`id`, `ReservationFrameSetting`.`frame_key`, `ReservationFrameSetting`.`display_type`, `ReservationFrameSetting`.`location_key`, `ReservationFrameSetting`.`category_id`, `ReservationFrameSetting`.`display_timeframe`, `ReservationFrameSetting`.`display_start_time_type`, `ReservationFrameSetting`.`start_pos`, `ReservationFrameSetting`.`display_count`, `ReservationFrameSetting`.`is_myroom`, `ReservationFrameSetting`.`is_select_room`, `ReservationFrameSetting`.`room_id`, `ReservationFrameSetting`.`timeline_base_time`, `ReservationFrameSetting`.`display_interval`, `ReservationFrameSetting`.`created_user`, `ReservationFrameSetting`.`created`, `ReservationFrameSetting`.`modified_user`, `ReservationFrameSetting`.`modified` FROM `hijiri3_hijirigaoka`.`reservation_frame_settings` AS `ReservationFrameSetting` WHERE `frame_key` = '30cea661986ef6b9c058172fa18a4683' LIMIT 1 | 1 | 1 | 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`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`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`.`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 `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 `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 `ReservationLocationsRoom`.`id`, `ReservationLocationsRoom`.`reservation_location_key`, `ReservationLocationsRoom`.`room_id`, `ReservationLocationsRoom`.`created_user`, `ReservationLocationsRoom`.`created`, `ReservationLocationsRoom`.`modified_user`, `ReservationLocationsRoom`.`modified`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`weight`, `Room`.`sort_key`, `Room`.`child_count`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `hijiri3_hijirigaoka`.`reservation_locations_rooms` AS `ReservationLocationsRoom` LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `Room` ON (`ReservationLocationsRoom`.`room_id` = `Room`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`ReservationLocationsRoom`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`ReservationLocationsRoom`.`modified_user` = `TrackableUpdater`.`id`) WHERE room_id = (1) | 0 | 0 | 0 | |
| SELECT `ReservationLocation`.`id`, `ReservationLocation`.`key`, `ReservationLocation`.`language_id`, `ReservationLocation`.`is_translation`, `ReservationLocation`.`is_origin`, `ReservationLocation`.`is_original_copy`, `ReservationLocation`.`category_id`, `ReservationLocation`.`location_name`, `ReservationLocation`.`detail`, `ReservationLocation`.`add_authority`, `ReservationLocation`.`time_table`, `ReservationLocation`.`start_time`, `ReservationLocation`.`end_time`, `ReservationLocation`.`timezone`, `ReservationLocation`.`use_private`, `ReservationLocation`.`use_auth_flag`, `ReservationLocation`.`use_all_rooms`, `ReservationLocation`.`use_workflow`, `ReservationLocation`.`weight`, `ReservationLocation`.`contact`, `ReservationLocation`.`created_user`, `ReservationLocation`.`created`, `ReservationLocation`.`modified_user`, `ReservationLocation`.`modified`, `Language`.`id`, `Language`.`code`, `Language`.`weight`, `Language`.`is_active`, `Language`.`created_user`, `Language`.`created`, `Language`.`modified_user`, `Language`.`modified`, `Category`.`id`, `Category`.`block_id`, `Category`.`key`, `Category`.`created_user`, `Category`.`created`, `Category`.`modified_user`, `Category`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `hijiri3_hijirigaoka`.`reservation_locations` AS `ReservationLocation` LEFT JOIN `hijiri3_hijirigaoka`.`languages` AS `Language` ON (`ReservationLocation`.`language_id` = `Language`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`categories` AS `Category` ON (`ReservationLocation`.`category_id` = `Category`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`ReservationLocation`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`ReservationLocation`.`modified_user` = `TrackableUpdater`.`id`) WHERE `language_id` = 2 AND ((`use_all_rooms` = '1') OR (`ReservationLocation`.`key` IS NULL)) AND `category_id` IS NULL ORDER BY `ReservationLocation`.`weight` ASC | 4 | 4 | 1 | maybe slow |
| SELECT `Room`.`space_id`, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` WHERE `space_id` = 1 | 1 | 1 | 0 | |
| SELECT `Room`.`space_id`, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` WHERE `parent_id` = 4 | 3 | 3 | 0 | |
| SELECT `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`weight`, `Room`.`sort_key`, `Room`.`child_count`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `Space`.`id`, `Space`.`parent_id`, `Space`.`lft`, `Space`.`rght`, `Space`.`type`, `Space`.`plugin_key`, `Space`.`default_setting_action`, `Space`.`room_disk_size`, `Space`.`room_id_root`, `Space`.`page_id_top`, `Space`.`permalink`, `Space`.`is_m17n`, `Space`.`after_user_save_model`, `Space`.`created_user`, `Space`.`created`, `Space`.`modified_user`, `Space`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `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`) WHERE `Room`.`parent_id` = 4 ORDER BY `Room`.`sort_key` ASC | 3 | 3 | 1 | maybe slow |
| SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` IN (1, 2, 3) | 6 | 6 | 0 | |
| SELECT * FROM `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` INNER JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoomsUser`.`user_id` IS NULL) WHERE `RolesRoom`.`room_id` IN (1, 2) | 0 | 0 | 0 | |
| SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `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`.`parent_id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` WHERE `Room`.`id` IN (1, 1) AND 1 = 1 ORDER BY `Room`.`sort_key` asc | 1 | 1 | 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` = 4 AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 2 | 2 | 1 | maybe slow |
| SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` IN (6, 135) | 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` IN (6, 135) | 0 | 0 | 0 | |
| SELECT `Room`.`id`, `Room`.`parent_id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` WHERE `Room`.`id` IN (3, 6, 135) AND 1 = 1 ORDER BY `Room`.`sort_key` asc | 3 | 3 | 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 `RolesRoomsUser`.`id`, `RolesRoomsUser`.`roles_room_id`, `RolesRoomsUser`.`user_id`, `RolesRoomsUser`.`room_id`, `RolesRoomsUser`.`access_count`, `RolesRoomsUser`.`last_accessed`, `RolesRoom`.`id`, `RolesRoom`.`room_id`, `RolesRoom`.`role_key`, `Room`.* FROM `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` INNER JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id) INNER JOIN `hijiri3_hijirigaoka`.`room_roles` AS `RoomRole` ON (`RoomRole`.`role_key` = RolesRoom .role_key) INNER JOIN `hijiri3_hijirigaoka`.`rooms` AS `Room` ON (`RolesRoom`.`room_id` = Room .id) INNER JOIN `hijiri3_hijirigaoka`.`users` AS `User` ON (`RolesRoomsUser`.`user_id` = User .id) WHERE NOT (`Room`.`page_id_top` IS NULL) AND `RolesRoomsUser`.`user_id` IS NULL AND `RolesRoomsUser`.`room_id` = (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 `ReservationLocationReservable`.`location_key`, `ReservationLocationReservable`.`value`, `ReservationLocationReservable`.`room_id`, `ReservationLocationReservable`.`role_key` FROM `hijiri3_hijirigaoka`.`reservation_location_reservable` AS `ReservationLocationReservable` WHERE `ReservationLocationReservable`.`value` = '1' AND ((`ReservationLocationReservable`.`room_id` = (1)) OR (`ReservationLocationReservable`.`room_id` IS NULL)) | 16 | 16 | 0 | |
| SELECT `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`weight`, `Room`.`sort_key`, `Room`.`child_count`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` WHERE `Room`.`id` = (1) ORDER BY `Room`.`id` ASC | 1 | 1 | 1 | |
| SELECT `RoomsLanguages`.`id`, `RoomsLanguages`.`language_id`, `RoomsLanguages`.`is_origin`, `RoomsLanguages`.`is_translation`, `RoomsLanguages`.`is_original_copy`, `RoomsLanguages`.`room_id`, `RoomsLanguages`.`name`, `RoomsLanguages`.`created_user`, `RoomsLanguages`.`created`, `RoomsLanguages`.`modified_user`, `RoomsLanguages`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguages` WHERE room_id = (1) AND `language_id` = 2 | 1 | 1 | 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 | 2 | maybe slow |
| SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `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`.`parent_id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` WHERE `Room`.`id` IN (1, 1) AND 1 = 1 ORDER BY `Room`.`sort_key` asc | 1 | 1 | 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` = 4 AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 2 | 2 | 1 | maybe slow |
| SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` IN (6, 135) | 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` IN (6, 135) | 0 | 0 | 0 | |
| SELECT `Room`.`id`, `Room`.`parent_id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` WHERE `Room`.`id` IN (3, 6, 135) AND 1 = 1 ORDER BY `Room`.`sort_key` asc | 3 | 3 | 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 `ReservationEvent`.`id`, `ReservationEvent`.`reservation_rrule_id`, `ReservationEvent`.`key`, `ReservationEvent`.`room_id`, `ReservationEvent`.`language_id`, `ReservationEvent`.`is_origin`, `ReservationEvent`.`is_translation`, `ReservationEvent`.`is_original_copy`, `ReservationEvent`.`target_user`, `ReservationEvent`.`title`, `ReservationEvent`.`title_icon`, `ReservationEvent`.`location`, `ReservationEvent`.`contact`, `ReservationEvent`.`description`, `ReservationEvent`.`is_allday`, `ReservationEvent`.`start_date`, `ReservationEvent`.`start_time`, `ReservationEvent`.`dtstart`, `ReservationEvent`.`end_date`, `ReservationEvent`.`end_time`, `ReservationEvent`.`dtend`, `ReservationEvent`.`timezone_offset`, `ReservationEvent`.`timezone`, `ReservationEvent`.`location_key`, `ReservationEvent`.`status`, `ReservationEvent`.`is_active`, `ReservationEvent`.`is_latest`, `ReservationEvent`.`recurrence_event_id`, `ReservationEvent`.`exception_event_id`, `ReservationEvent`.`is_enable_mail`, `ReservationEvent`.`email_send_timing`, `ReservationEvent`.`calendar_key`, `ReservationEvent`.`created_user`, `ReservationEvent`.`created`, `ReservationEvent`.`modified_user`, `ReservationEvent`.`modified`, `ReservationRrule`.`id`, `ReservationRrule`.`reservation_id`, `ReservationRrule`.`key`, `ReservationRrule`.`name`, `ReservationRrule`.`rrule`, `ReservationRrule`.`ireservation_uid`, `ReservationRrule`.`ireservation_comp_name`, `ReservationRrule`.`room_id`, `ReservationRrule`.`created_user`, `ReservationRrule`.`created`, `ReservationRrule`.`modified_user`, `ReservationRrule`.`modified`, `Language`.`id`, `Language`.`code`, `Language`.`weight`, `Language`.`is_active`, `Language`.`created_user`, `Language`.`created`, `Language`.`modified_user`, `Language`.`modified`, `ReservationLocation`.`id`, `ReservationLocation`.`key`, `ReservationLocation`.`language_id`, `ReservationLocation`.`is_translation`, `ReservationLocation`.`is_origin`, `ReservationLocation`.`is_original_copy`, `ReservationLocation`.`category_id`, `ReservationLocation`.`location_name`, `ReservationLocation`.`detail`, `ReservationLocation`.`add_authority`, `ReservationLocation`.`time_table`, `ReservationLocation`.`start_time`, `ReservationLocation`.`end_time`, `ReservationLocation`.`timezone`, `ReservationLocation`.`use_private`, `ReservationLocation`.`use_auth_flag`, `ReservationLocation`.`use_all_rooms`, `ReservationLocation`.`use_workflow`, `ReservationLocation`.`weight`, `ReservationLocation`.`contact`, `ReservationLocation`.`created_user`, `ReservationLocation`.`created`, `ReservationLocation`.`modified_user`, `ReservationLocation`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `hijiri3_hijirigaoka`.`reservation_events` AS `ReservationEvent` LEFT JOIN `hijiri3_hijirigaoka`.`reservation_rrules` AS `ReservationRrule` ON (`ReservationEvent`.`reservation_rrule_id` = `ReservationRrule`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`languages` AS `Language` ON (`ReservationEvent`.`language_id` = `Language`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`reservation_locations` AS `ReservationLocation` ON (`ReservationEvent`.`location_key` = `ReservationLocation`.`key` AND `ReservationEvent`.`language_id` = `ReservationLocation`.`language_id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`ReservationEvent`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`ReservationEvent`.`modified_user` = `TrackableUpdater`.`id`) WHERE ((((`ReservationEvent`.`language_id` = 2) OR (`ReservationEvent`.`is_translation` = '0'))) AND (((`ReservationEvent`.`is_active` = '1') OR (((`ReservationEvent`.`is_latest` = '1') AND (((`ReservationEvent`.`status` = 2) OR (`ReservationEvent`.`created_user` IS NULL)))))))) AND ((`ReservationEvent`.`language_id` = 2) OR (`ReservationEvent`.`is_translation` = '0')) AND `ReservationEvent`.`dtstart` >= '20250831150000' AND `ReservationEvent`.`dtend` < '20251130150000' ORDER BY `ReservationEvent`.`dtstart` ASC | 181 | 181 | 18 | maybe slow |
| SELECT `ReservationEventShareUser`.`id`, `ReservationEventShareUser`.`reservation_event_id`, `ReservationEventShareUser`.`share_user`, `ReservationEventShareUser`.`created_user`, `ReservationEventShareUser`.`created`, `ReservationEventShareUser`.`modified_user`, `ReservationEventShareUser`.`modified` FROM `hijiri3_hijirigaoka`.`reservation_event_share_users` AS `ReservationEventShareUser` WHERE `ReservationEventShareUser`.`reservation_event_id` IN (5988, 6074, 6348, 6036, 6339, 5940, 6340, 6341, 6345, 6293, 6352, 5989, 6353, 6349, 6037, 5878, 5890, 5750, 5941, 6358, 6140, 6357, 5990, 6085, 6359, 6350, 6038, 5902, 5914, 5942, 6360, 6287, 6356, 6354, 5844, 6120, 6326, 5991, 6327, 6288, 6289, 6328, 6351, 6039, 6097, 6347, 5943, 6329, 6290, 6162, 5862, 6362, 6330, 5992, 6331, 6365, 6332, 6382, 6040, 6333, 5944, 6334, 6379, 6294, 6335, 6363, 6366, 6336, 5993, 6075, 6337, 6383, 6041, 5879, 5891, 5751, 5945, 6338, 6392, 6344, 6141, 6388, 6389, 6462, 6384, 6042, 5903, 5915, 5946, 6387, 5845, 6463, 6323, 6121, 5995, 6086, 6385, 6043, 6098, 6376, 5947, 6163, 5863, 6490, 5996, 6390, 6496, 6386, 6044, 5948, 6500, 6295, 6493, 6501, 6076, 6470, 6045, 6380, 6497, 5949, 6511, 6512, 6509, 6142, 6459, 5811, 5998, 6542, 6471, 6046, 5880, 5892, 5752, 5950, 6543, 6464, 6465, 6513, 6489, 5846, 6435, 6122, 6436, 6437, 5999, 6087, 6439, 6440, 6441, 6469, 6047, 5904, 5916, 5951, 6442, 6514, 6164, 6460, 5864, 6491, 6510, 6443, 6447, 6468, 6444, 6445, 6448, 6048, 6099, 6377, 5952, 6367, 6370, 6373, 6378, 6371, 6374, 6369, 6368, 6372, 6375) ORDER BY `id` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `ReservationLocation`.`id`, `ReservationLocation`.`key`, `ReservationLocation`.`language_id`, `ReservationLocation`.`is_translation`, `ReservationLocation`.`is_origin`, `ReservationLocation`.`is_original_copy`, `ReservationLocation`.`category_id`, `ReservationLocation`.`location_name`, `ReservationLocation`.`detail`, `ReservationLocation`.`add_authority`, `ReservationLocation`.`time_table`, `ReservationLocation`.`start_time`, `ReservationLocation`.`end_time`, `ReservationLocation`.`timezone`, `ReservationLocation`.`use_private`, `ReservationLocation`.`use_auth_flag`, `ReservationLocation`.`use_all_rooms`, `ReservationLocation`.`use_workflow`, `ReservationLocation`.`weight`, `ReservationLocation`.`contact`, `ReservationLocation`.`created_user`, `ReservationLocation`.`created`, `ReservationLocation`.`modified_user`, `ReservationLocation`.`modified`, `Language`.`id`, `Language`.`code`, `Language`.`weight`, `Language`.`is_active`, `Language`.`created_user`, `Language`.`created`, `Language`.`modified_user`, `Language`.`modified`, `Category`.`id`, `Category`.`block_id`, `Category`.`key`, `Category`.`created_user`, `Category`.`created`, `Category`.`modified_user`, `Category`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `hijiri3_hijirigaoka`.`reservation_locations` AS `ReservationLocation` LEFT JOIN `hijiri3_hijirigaoka`.`languages` AS `Language` ON (`ReservationLocation`.`language_id` = `Language`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`categories` AS `Category` ON (`ReservationLocation`.`category_id` = `Category`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`ReservationLocation`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`ReservationLocation`.`modified_user` = `TrackableUpdater`.`id`) WHERE `ReservationLocation`.`key` = '4ac901d3c60a74e924613b75b83d7a2f' LIMIT 1 | 1 | 1 | 1 | |
| 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 | 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`.*, `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 `ReservationLocation`.`id`, `ReservationLocation`.`key`, `ReservationLocation`.`language_id`, `ReservationLocation`.`is_translation`, `ReservationLocation`.`is_origin`, `ReservationLocation`.`is_original_copy`, `ReservationLocation`.`category_id`, `ReservationLocation`.`location_name`, `ReservationLocation`.`detail`, `ReservationLocation`.`add_authority`, `ReservationLocation`.`time_table`, `ReservationLocation`.`start_time`, `ReservationLocation`.`end_time`, `ReservationLocation`.`timezone`, `ReservationLocation`.`use_private`, `ReservationLocation`.`use_auth_flag`, `ReservationLocation`.`use_all_rooms`, `ReservationLocation`.`use_workflow`, `ReservationLocation`.`weight`, `ReservationLocation`.`contact`, `ReservationLocation`.`created_user`, `ReservationLocation`.`created`, `ReservationLocation`.`modified_user`, `ReservationLocation`.`modified`, `Language`.`id`, `Language`.`code`, `Language`.`weight`, `Language`.`is_active`, `Language`.`created_user`, `Language`.`created`, `Language`.`modified_user`, `Language`.`modified`, `Category`.`id`, `Category`.`block_id`, `Category`.`key`, `Category`.`created_user`, `Category`.`created`, `Category`.`modified_user`, `Category`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `hijiri3_hijirigaoka`.`reservation_locations` AS `ReservationLocation` LEFT JOIN `hijiri3_hijirigaoka`.`languages` AS `Language` ON (`ReservationLocation`.`language_id` = `Language`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`categories` AS `Category` ON (`ReservationLocation`.`category_id` = `Category`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`ReservationLocation`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`ReservationLocation`.`modified_user` = `TrackableUpdater`.`id`) WHERE `ReservationLocation`.`key` = 'bb53200d7964697a191d785d6b99469b' LIMIT 1 | 1 | 1 | 1 | |
| 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 `ReservationLocation`.`id`, `ReservationLocation`.`key`, `ReservationLocation`.`language_id`, `ReservationLocation`.`is_translation`, `ReservationLocation`.`is_origin`, `ReservationLocation`.`is_original_copy`, `ReservationLocation`.`category_id`, `ReservationLocation`.`location_name`, `ReservationLocation`.`detail`, `ReservationLocation`.`add_authority`, `ReservationLocation`.`time_table`, `ReservationLocation`.`start_time`, `ReservationLocation`.`end_time`, `ReservationLocation`.`timezone`, `ReservationLocation`.`use_private`, `ReservationLocation`.`use_auth_flag`, `ReservationLocation`.`use_all_rooms`, `ReservationLocation`.`use_workflow`, `ReservationLocation`.`weight`, `ReservationLocation`.`contact`, `ReservationLocation`.`created_user`, `ReservationLocation`.`created`, `ReservationLocation`.`modified_user`, `ReservationLocation`.`modified`, `Language`.`id`, `Language`.`code`, `Language`.`weight`, `Language`.`is_active`, `Language`.`created_user`, `Language`.`created`, `Language`.`modified_user`, `Language`.`modified`, `Category`.`id`, `Category`.`block_id`, `Category`.`key`, `Category`.`created_user`, `Category`.`created`, `Category`.`modified_user`, `Category`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `hijiri3_hijirigaoka`.`reservation_locations` AS `ReservationLocation` LEFT JOIN `hijiri3_hijirigaoka`.`languages` AS `Language` ON (`ReservationLocation`.`language_id` = `Language`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`categories` AS `Category` ON (`ReservationLocation`.`category_id` = `Category`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`ReservationLocation`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`ReservationLocation`.`modified_user` = `TrackableUpdater`.`id`) WHERE `ReservationLocation`.`key` = '3936bbb557d96cc5122c3941deded1d9' LIMIT 1 | 1 | 1 | 1 | |
| 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 | 0 | |
| SELECT `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `MenuFramesRoom`.`id`, `MenuFramesRoom`.`room_id`, `MenuFramesRoom`.`is_hidden` FROM `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 | 1 | |
| 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 | 1 | |
| 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 | 1 | |
| 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 | 0 | |
| SELECT COUNT(*) AS `count` FROM `hijiri3_hijirigaoka`.`menu_frames_rooms` AS `MenuFramesRoom` WHERE `MenuFramesRoom`.`frame_key` = 'd8a46090c60cc5f3fa3f56198e0e2998' | 1 | 1 | 0 | |
| 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 | 1 | |
| 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 | 0 |
75 duplicate queries run.
Peak Memory Use 27.97 MB
| Message | Memory use |
|---|---|
| Component initialization | 3.57 MB |
| Controller action start | 4.02 MB |
| Controller render start | 15.34 MB |
| Component initialization #2 | 16.18 MB |
| Controller action start #2 | 16.29 MB |
| Controller render start #2 | 16.75 MB |
| View render complete | 16.96 MB |
Total Request Time: 4985 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 42.82 | |
| Event: Controller.initialize | 17.55 | |
| Event: Controller.startup | 4.02 | |
| Controller action | 4408.56 | |
| Event: Controller.beforeRender | 61.72 | |
| » Processing toolbar data | 60.24 | |
| Rendering View | 288.77 | |
| » Event: View.beforeRender | 0.78 | |
| » Rendering APP/Plugin/Reservations/View/Reservations/weekly_by_category.ctp | 189.05 | |
| » » Rendering APP/Plugin/Reservations/View/Elements/scripts.ctp | 0.32 | |
| » » Rendering APP/Plugin/Reservations/View/Elements/Reservations/common_tabs.ctp | 0.64 | |
| » » Rendering APP/Plugin/Reservations/View/Elements/Reservations/tabs_by_category.ctp | 0.23 | |
| » » Rendering APP/Plugin/NetCommons/View/Elements/load_datetimepicker.ctp | 0.53 | |
| » » Rendering APP/Plugin/Reservations/View/Elements/Reservations/dropdown_category.ctp | 1.00 | |
| » » » Rendering APP/Plugin/Categories/View/Elements/dropdown_toggle_category.ctp | 0.46 | |
| » Event: View.afterRender | 0.98 | |
| » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp | 0.28 | |
| » » Rendering APP/Plugin/Pages/View/Elements/page_main.ctp | 0.19 | |
| » Event: View.beforeLayout | 92.25 | |
| » » Rendering APP/Plugin/Pages/View/Elements/page_header.ctp | 91.97 | |
| » » » Rendering APP/Plugin/Boxes/View/Elements/render_boxes.ctp | 91.75 | |
| » » » » Rendering APP/Plugin/Frames/View/Elements/render_frames.ctp | 91.54 | |
| » » » » » Event: Controller.initialize #2 | 5.89 | |
| » » » » » Event: Controller.startup #2 | 0.50 | |
| » » » » » Controller action #2 | 16.85 | |
| » » » » » Event: Controller.beforeRender #2 | 63.27 | |
| » » » » » » Processing toolbar data #2 | 62.95 | |
| Rendering View #2 | 0.00 | |
| » » » » » » Event: View.beforeRender #2 | 0.13 | |
| » » » » » » Rendering APP/Plugin/Menus/View/Menus/index.ctp | 1.27 | |
| » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/topic_path/index.ctp #2 | 0.81 | |
| » » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/topic_path/list.ctp | 0.11 | |
| » » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/topic_path/list.ctp #2 | 0.06 | |
| » » » » » » Event: View.afterRender #2 | 0.56 | |
| » » » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #2 | 0.14 | |
| » » » » » » » Rendering APP/Plugin/Pages/View/Elements/page_main.ctp #2 | 0.10 | |
| » » » » » » Event: Controller.shutdown | 0.07 | |
| » » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #3 | 0.10 | |
| » » Rendering APP/Plugin/Pages/View/Layouts/default.ctp | 4.38 | |
| » » » Rendering APP/Plugin/NetCommons/View/Elements/common_favicon.ctp | 0.25 | |
| » » » Rendering APP/Plugin/NetCommons/View/Elements/common_css.ctp | 0.80 | |
| » » » Rendering APP/Plugin/NetCommons/View/Elements/common_theme_css.ctp | 0.22 | |
| » » » Rendering APP/Plugin/NetCommons/View/Elements/common_js.ctp | 0.67 | |
| » » » Rendering APP/Plugin/Wysiwyg/View/Elements/mathjax_js.ctp | 0.20 | |
| » » » Rendering APP/Plugin/NetCommons/View/Elements/common_header.ctp | 1.10 | |
| » » » Rendering APP/Plugin/NetCommons/View/Elements/common_footer.ctp | 0.09 | |
| Event: View.afterLayout | 0.00 |
| Constant | Value |
|---|---|
| UPLOADS_ROOT | '/home/hijiri3/www/nc3/app/Uploads/' |
| CONFIG | '/home/hijiri3/www/nc3/app/Config/' |
| HTMLPURIFIER_PREFIX | '/home/hijiri3/www/nc3/vendors/ezyang/htmlpurifier/library' |
| NC3_VERSION | '3.3.4' |
| Constant | Value |
|---|---|
| APP | '/home/hijiri3/www/nc3/app/' |
| APP_DIR | 'app' |
| APPLIBS | '/home/hijiri3/www/nc3/app/Lib/' |
| CACHE | '/home/hijiri3/www/nc3/app/tmp/cache/' |
| CAKE | '/home/hijiri3/www/nc3/vendors/cakephp/cakephp/lib/Cake/' |
| CAKE_CORE_INCLUDE_PATH | '/home/hijiri3/www/nc3/vendors/cakephp/cakephp/lib' |
| CORE_PATH | '/home/hijiri3/www/nc3/vendors/cakephp/cakephp/lib/' |
| CAKE_VERSION | '2.10.24' |
| CSS | '/home/hijiri3/www/nc3/app/webroot/css/' |
| CSS_URL | 'css/' |
| DS | '/' |
| FULL_BASE_URL | 'https://hijirigaoka.org' |
| IMAGES | '/home/hijiri3/www/nc3/app/webroot/img/' |
| IMAGES_URL | 'img/' |
| JS | '/home/hijiri3/www/nc3/app/webroot/js/' |
| JS_URL | 'js/' |
| LOGS | '/home/hijiri3/www/nc3/app/tmp/logs/' |
| ROOT | '/home/hijiri3/www/nc3' |
| TESTS | '/home/hijiri3/www/nc3/app/Test/' |
| TMP | '/home/hijiri3/www/nc3/app/tmp/' |
| VENDORS | '/home/hijiri3/www/nc3/vendors/' |
| WEBROOT_DIR | 'webroot' |
| WWW_ROOT | '/home/hijiri3/www/nc3/app/webroot/' |
| Environment Variable | Value |
|---|---|
| Php Version | '7.4.33' |
| Redirect Redirect Https | 'on' |
| Redirect Redirect Status | '200' |
| Redirect Https | 'on' |
| Redirect Status | '200' |
| Https | 'on' |
| Http Host | 'hijirigaoka.org' |
| Http X Real Ip | '18.97.14.85' |
| Http Listen Ipaddr | '49.212.198.171' |
| Http User Agent | 'CCBot/2.0 (https://commoncrawl.org/faq/)' |
| Http Accept | 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8' |
| Http Accept Language | 'en-US,en;q=0.5' |
| Http Accept Encoding | 'br,gzip' |
| Path | '/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin' |
| Server Signature | '' |
| Server Software | 'Apache' |
| Server Name | 'hijirigaoka.org' |
| Server Addr | '100.64.0.17' |
| Server Port | '443' |
| Remote Host | '18-97-14-85.crawl.commoncrawl.org' |
| Remote Addr | '18.97.14.85' |
| Document Root | '/home/hijiri3/www/nc3' |
| Request Scheme | 'https' |
| Context Prefix | '' |
| Context Document Root | '/home/hijiri3/www/nc3' |
| Server Admin | '[no address given]' |
| Script Filename | '/home/hijiri3/www/nc3/app/webroot/index.php' |
| Remote Port | '0' |
| Redirect Url | '/app/webroot/reservations/reservations/index/category_id:' |
| Redirect Query String | 'frame_id=677&style=weekly_by_category&year=2025&month=10&day=08' |
| Gateway Interface | 'CGI/1.1' |
| Server Protocol | 'HTTP/1.1' |
| Request Method | 'GET' |
| Query String | 'frame_id=677&style=weekly_by_category&year=2025&month=10&day=08' |
| Request Uri | '/reservations/reservations/index/category_id:?frame_id=677&style=weekly_by_category&year=2025&month=10&day=08' |
| Script Name | '/app/webroot/index.php' |
| Php Self | '/app/webroot/index.php' |
| Request Time Float | (float) 1762778898.0556 |
| Request Time | (int) 1762778898 |
| Argc | (int) 1 |