日 | 月 | 火 | 水 | 木 | 金 | 土 | |
31(日) | |||||||
21(日) | |||||||
集会所施設予約
日 | 月 | 火 | 水 | 木 | 金 | 土 | |
31(日) | |||||||
21(日) | |||||||
No post data.
To view Cookies, add CookieComponent to Controller
Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 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 | 4 | maybe slow |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 1 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 1 | maybe slow |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 1 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 1 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 1 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 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 | 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 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 1 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 1 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 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 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 1 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 1 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 1 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 1 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 1 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 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 | 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 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 1 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 1 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 1 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 1 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 1 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 1 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 1 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 1 | maybe slow |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 1 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 1 | maybe slow |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 1 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 0 | |
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` = (1) | 2 | 2 | 0 | |
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`weight`, `ChildRoom`.`sort_key`, `ChildRoom`.`child_count`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `hijiri3_hijirigaoka`.`rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` = (1) | 0 | 0 | 0 | |
SELECT `Room`.`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 | 0 | |
SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`weight`, `Page`.`sort_key`, `Page`.`child_count`, `Page`.`permalink`, `PagesLanguage`.`page_id`, `PagesLanguage`.`name`, `MenuFramesPage`.`id`, `MenuFramesPage`.`page_id`, `MenuFramesPage`.`folder_type`, `MenuFramesPage`.`is_hidden` FROM `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 | 1 | |
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 |
185 duplicate queries run.
Peak Memory Use 23.81 MB
Message | Memory use |
---|---|
Component initialization | 3.18 MB |
Controller action start | 3.97 MB |
Controller render start | 15.24 MB |
Component initialization #2 | 16.24 MB |
Controller action start #2 | 16.34 MB |
Controller render start #2 | 16.78 MB |
View render complete | 17.03 MB |
Total Request Time: 4468 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 28.64 | |
Event: Controller.initialize | 16.47 | |
Event: Controller.startup | 3.51 | |
Controller action | 3860.03 | |
Event: Controller.beforeRender | 21.73 | |
» Processing toolbar data | 20.28 | |
Rendering View | 348.01 | |
» Event: View.beforeRender | 0.73 | |
» Rendering APP/Plugin/Reservations/View/Reservations/monthly_by_location.ctp | 283.10 | |
» » Rendering APP/Plugin/Reservations/View/Elements/scripts.ctp | 0.34 | |
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/common_tabs.ctp | 1.24 | |
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/tabs_by_location.ctp | 0.22 | |
» » Rendering APP/Plugin/NetCommons/View/Elements/load_datetimepicker.ctp | 0.56 | |
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/dropdown_category.ctp | 1.25 | |
» » » Rendering APP/Plugin/Categories/View/Elements/dropdown_toggle_category.ctp | 0.46 | |
» » Rendering APP/Plugin/Reservations/View/Elements/Reservations/dropdown_location.ctp | 0.37 | |
» Event: View.afterRender | 1.33 | |
» » Rendering APP/Plugin/Frames/View/Elements/frame.ctp | 0.47 | |
» » Rendering APP/Plugin/Pages/View/Elements/page_main.ctp | 0.26 | |
» Event: View.beforeLayout | 54.64 | |
» » Rendering APP/Plugin/Pages/View/Elements/page_header.ctp | 54.35 | |
» » » Rendering APP/Plugin/Boxes/View/Elements/render_boxes.ctp | 54.13 | |
» » » » Rendering APP/Plugin/Frames/View/Elements/render_frames.ctp | 53.92 | |
» » » » » Event: Controller.initialize #2 | 6.35 | |
» » » » » Event: Controller.startup #2 | 0.41 | |
» » » » » Controller action #2 | 17.53 | |
» » » » » Event: Controller.beforeRender #2 | 24.66 | |
» » » » » » Processing toolbar data #2 | 24.39 | |
Rendering View #2 | 0.00 | |
» » » » » » Event: View.beforeRender #2 | 0.12 | |
» » » » » » Rendering APP/Plugin/Menus/View/Menus/index.ctp | 1.30 | |
» » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/topic_path/index.ctp #2 | 0.83 | |
» » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/topic_path/list.ctp | 0.13 | |
» » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/topic_path/list.ctp #2 | 0.06 | |
» » » » » » Event: View.afterRender #2 | 0.55 | |
» » » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #2 | 0.13 | |
» » » » » » » Rendering APP/Plugin/Pages/View/Elements/page_main.ctp #2 | 0.10 | |
» » » » » » Event: Controller.shutdown | 0.07 | |
» » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #3 | 0.11 | |
» » Rendering APP/Plugin/Pages/View/Layouts/default.ctp | 6.95 | |
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_favicon.ctp | 0.24 | |
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_css.ctp | 0.78 | |
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_theme_css.ctp | 0.22 | |
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_js.ctp | 0.65 | |
» » » Rendering APP/Plugin/Wysiwyg/View/Elements/mathjax_js.ctp | 0.20 | |
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_header.ctp | 3.74 | |
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_footer.ctp | 0.08 | |
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 | 'http://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 Status | '200' |
Redirect Status | '200' |
Http Host | 'hijirigaoka.org' |
Http X Real Ip | '18.118.2.15' |
Http Listen Ipaddr | '49.212.198.171' |
Http Accept | '*/*' |
Http User Agent | 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' |
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 | '80' |
Remote Host | 'ec2-18-118-2-15.us-east-2.compute.amazonaws.com' |
Remote Addr | '18.118.2.15' |
Document Root | '/home/hijiri3/www/nc3' |
Request Scheme | 'http' |
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/' |
Redirect Query String | 'year=2021&month=11&day=26&location_key=4ac901d3c60a74e924613b75b83d7a2f&style=monthly_by_location&frame_id=677' |
Gateway Interface | 'CGI/1.1' |
Server Protocol | 'HTTP/1.1' |
Request Method | 'GET' |
Query String | 'year=2021&month=11&day=26&location_key=4ac901d3c60a74e924613b75b83d7a2f&style=monthly_by_location&frame_id=677' |
Request Uri | '/reservations/reservations/index/?year=2021&month=11&day=26&location_key=4ac901d3c60a74e924613b75b83d7a2f&style=monthly_by_location&frame_id=677' |
Script Name | '/app/webroot/index.php' |
Php Self | '/app/webroot/index.php' |
Request Time Float | (float) 1713854204.3839 |
Request Time | (int) 1713854204 |
Argc | (int) 1 |