- 公開情報
カレンダー
No post data.
To view Cookies, add CookieComponent to Controller
| Query | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|
| SELECT `SiteSetting`.`language_id`, `SiteSetting`.`key`, `SiteSetting`.`value` FROM `LAA0857082-chibagakudo`.`nc3_site_settings` AS `SiteSetting` WHERE ((`SiteSetting`.`key` LIKE 'App.site_name%') OR (`SiteSetting`.`key` LIKE 'Config.language%') OR (`SiteSetting`.`key` LIKE 'App.default_start_room%') OR (`SiteSetting`.`key` LIKE 'App.default_timezone%') OR (`SiteSetting`.`key` LIKE 'debug%') OR (`SiteSetting`.`key` LIKE 'App.close_site%') OR (`SiteSetting`.`key` LIKE 'ForgotPass.use_password_reissue%') OR (`SiteSetting`.`key` LIKE 'AutoRegist.use_automatic_register%') OR (`SiteSetting`.`key` LIKE 'Session%')) | 12 | 12 | 0 | |
| SELECT `Language`.`id`, `Language`.`code`, `Language`.`weight`, `Language`.`is_active`, `Language`.`created_user`, `Language`.`created`, `Language`.`modified_user`, `Language`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_languages` AS `Language` WHERE `is_active` = '1' ORDER BY `weight` asc | 1 | 1 | 0 | |
| SELECT `Language`.`id`, `Language`.`code`, `Language`.`weight`, `Language`.`is_active`, `Language`.`created_user`, `Language`.`created`, `Language`.`modified_user`, `Language`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_languages` AS `Language` WHERE `is_active` = '1' AND `code` = 'ja' ORDER BY `weight` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Plugin`.`id`, `Plugin`.`language_id`, `Plugin`.`is_origin`, `Plugin`.`is_translation`, `Plugin`.`is_original_copy`, `Plugin`.`key`, `Plugin`.`is_m17n`, `Plugin`.`name`, `Plugin`.`namespace`, `Plugin`.`weight`, `Plugin`.`type`, `Plugin`.`version`, `Plugin`.`commit_version`, `Plugin`.`commited`, `Plugin`.`default_action`, `Plugin`.`default_setting_action`, `Plugin`.`frame_add_action`, `Plugin`.`display_topics`, `Plugin`.`display_search`, `Plugin`.`serialize_data`, `Plugin`.`created_user`, `Plugin`.`created`, `Plugin`.`modified_user`, `Plugin`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_plugins` AS `Plugin` WHERE `key` = 'calendars' AND `language_id` = 2 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `SiteSetting`.`language_id`, `SiteSetting`.`key`, `SiteSetting`.`value` FROM `LAA0857082-chibagakudo`.`nc3_site_settings` AS `SiteSetting` WHERE `SiteSetting`.`key` LIKE 'Security.enable_allow_system_plugin_ips%' | 1 | 1 | 0 | |
| SELECT `Frame`.`id`, `Frame`.`room_id`, `Frame`.`box_id`, `Frame`.`plugin_key`, `Frame`.`block_id`, `Frame`.`key`, `Frame`.`header_type`, `Frame`.`weight`, `Frame`.`is_deleted`, `Frame`.`default_action`, `Frame`.`default_setting_action`, `Frame`.`created_user`, `Frame`.`created`, `Frame`.`modified_user`, `Frame`.`modified`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `Block`.`id`, `Block`.`room_id`, `Block`.`plugin_key`, `Block`.`key`, `Block`.`public_type`, `Block`.`publish_start`, `Block`.`publish_end`, `Block`.`content_count`, `Block`.`created_user`, `Block`.`created`, `Block`.`modified_user`, `Block`.`modified`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Plugin`.`id`, `Plugin`.`language_id`, `Plugin`.`is_origin`, `Plugin`.`is_translation`, `Plugin`.`is_original_copy`, `Plugin`.`key`, `Plugin`.`is_m17n`, `Plugin`.`name`, `Plugin`.`namespace`, `Plugin`.`weight`, `Plugin`.`type`, `Plugin`.`version`, `Plugin`.`commit_version`, `Plugin`.`commited`, `Plugin`.`default_action`, `Plugin`.`default_setting_action`, `Plugin`.`frame_add_action`, `Plugin`.`display_topics`, `Plugin`.`display_search`, `Plugin`.`serialize_data`, `Plugin`.`created_user`, `Plugin`.`created`, `Plugin`.`modified_user`, `Plugin`.`modified`, `FramePublicLanguage`.`id`, `FramePublicLanguage`.`language_id`, `FramePublicLanguage`.`frame_id`, `FramePublicLanguage`.`is_public`, `FramesLanguage`.`id`, `FramesLanguage`.`language_id`, `FramesLanguage`.`frame_id`, `FramesLanguage`.`name`, `FramesLanguage`.`is_origin`, `FramesLanguage`.`is_translation`, `FramesLanguage`.`is_original_copy`, `BlocksLanguage`.`language_id`, `BlocksLanguage`.`block_id`, `BlocksLanguage`.`name`, `BlocksLanguage`.`is_origin`, `BlocksLanguage`.`is_translation`, `BlocksLanguage`.`is_original_copy` FROM `LAA0857082-chibagakudo`.`nc3_frames` AS `Frame` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` ON (`Frame`.`box_id` = `Box`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks` AS `Block` ON (`Frame`.`block_id` = `Block`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Frame`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Frame`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Frame`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_plugins` AS `Plugin` ON (`Plugin`.`key` = `Frame`.`plugin_key` AND `Plugin`.`language_id` = 2) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frame_public_languages` AS `FramePublicLanguage` ON (`FramePublicLanguage`.`frame_id` = `Frame`.`id` AND `FramePublicLanguage`.`language_id` IN (0, 2) AND `FramePublicLanguage`.`is_public` = '1') LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frames_languages` AS `FramesLanguage` ON (`FramesLanguage`.`frame_id` = `Frame`.`id` AND ((`FramesLanguage`.`is_translation` = '0') OR (`FramesLanguage`.`language_id` = 2))) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND ((`BlocksLanguage`.`is_translation` = '0') OR (`BlocksLanguage`.`language_id` = 2))) WHERE `Frame`.`id` = 17 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `Space`.`id`, `Space`.`parent_id`, `Space`.`lft`, `Space`.`rght`, `Space`.`type`, `Space`.`plugin_key`, `Space`.`default_setting_action`, `Space`.`room_disk_size`, `Space`.`room_id_root`, `Space`.`page_id_top`, `Space`.`permalink`, `Space`.`is_m17n`, `Space`.`after_user_save_model`, `Space`.`created_user`, `Space`.`created`, `Space`.`modified_user`, `Space`.`modified`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Box`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Box`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Box`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Box`.`modified_user` = `TrackableUpdater`.`id`) WHERE `Box`.`id` = 150 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `BoxesPageContainer`.`id`, `BoxesPageContainer`.`page_container_id`, `BoxesPageContainer`.`page_id`, `BoxesPageContainer`.`container_type`, `BoxesPageContainer`.`box_id`, `BoxesPageContainer`.`is_published`, `BoxesPageContainer`.`weight`, `BoxesPageContainer`.`created_user`, `BoxesPageContainer`.`created`, `BoxesPageContainer`.`modified_user`, `BoxesPageContainer`.`modified`, `PageContainer`.`id`, `PageContainer`.`page_id`, `PageContainer`.`container_type`, `PageContainer`.`is_published`, `PageContainer`.`is_configured`, `PageContainer`.`created_user`, `PageContainer`.`created`, `PageContainer`.`modified_user`, `PageContainer`.`modified`, `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`permalink`, `Page`.`slug`, `Page`.`is_container_fluid`, `Page`.`theme`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `LAA0857082-chibagakudo`.`nc3_boxes_page_containers` AS `BoxesPageContainer` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_page_containers` AS `PageContainer` ON (`BoxesPageContainer`.`page_container_id` = `PageContainer`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` ON (`BoxesPageContainer`.`page_id` = `Page`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` ON (`BoxesPageContainer`.`box_id` = `Box`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`BoxesPageContainer`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`BoxesPageContainer`.`modified_user` = `TrackableUpdater`.`id`) WHERE `BoxesPageContainer`.`box_id` = 150 AND `BoxesPageContainer`.`page_id` = 15 AND `BoxesPageContainer`.`container_type` = 3 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Space`.`id`, `Space`.`room_id_root` FROM `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` WHERE 1 = 1 | 4 | 4 | 0 | |
| SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`permalink`, `Page`.`slug`, `Page`.`is_container_fluid`, `Page`.`theme`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE `Page`.`room_id` = 1 AND NOT (`Page`.`parent_id` IS NULL) ORDER BY `Page`.`lft` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `DefaultRolePermission`.`id`, `DefaultRolePermission`.`role_key`, `DefaultRolePermission`.`type`, `DefaultRolePermission`.`permission`, `DefaultRolePermission`.`value`, `DefaultRolePermission`.`fixed`, `DefaultRolePermission`.`created_user`, `DefaultRolePermission`.`created`, `DefaultRolePermission`.`modified_user`, `DefaultRolePermission`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_default_role_permissions` AS `DefaultRolePermission` WHERE `role_key` = 'visitor' | 16 | 16 | 0 | |
| SELECT `PluginsRoom`.`id`, `PluginsRoom`.`room_id`, `PluginsRoom`.`plugin_key`, `PluginsRoom`.`created_user`, `PluginsRoom`.`created`, `PluginsRoom`.`modified_user`, `PluginsRoom`.`modified`, `Plugin`.`id`, `Plugin`.`language_id`, `Plugin`.`is_origin`, `Plugin`.`is_translation`, `Plugin`.`is_original_copy`, `Plugin`.`key`, `Plugin`.`is_m17n`, `Plugin`.`name`, `Plugin`.`namespace`, `Plugin`.`weight`, `Plugin`.`type`, `Plugin`.`version`, `Plugin`.`commit_version`, `Plugin`.`commited`, `Plugin`.`default_action`, `Plugin`.`default_setting_action`, `Plugin`.`frame_add_action`, `Plugin`.`display_topics`, `Plugin`.`display_search`, `Plugin`.`serialize_data`, `Plugin`.`created_user`, `Plugin`.`created`, `Plugin`.`modified_user`, `Plugin`.`modified`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `LAA0857082-chibagakudo`.`nc3_plugins_rooms` AS `PluginsRoom` inner JOIN `LAA0857082-chibagakudo`.`nc3_plugins` AS `Plugin` ON (`PluginsRoom`.`plugin_key` = `Plugin`.`key` AND `Plugin`.`language_id` = 2) inner JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`PluginsRoom`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`PluginsRoom`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`PluginsRoom`.`modified_user` = `TrackableUpdater`.`id`) WHERE `Plugin`.`type` = 1 AND `Room`.`id` = 11 ORDER BY `PluginsRoom`.`id` ASC | 4 | 4 | 1 | maybe slow |
| SELECT `BlockSetting`.`field_name`, `BlockSetting`.`value` FROM `LAA0857082-chibagakudo`.`nc3_block_settings` AS `BlockSetting` WHERE `block_key` = '8219470cdd5c03712901243e3e449645' AND `field_name` IN ('use_workflow', 'use_comment_approval') | 1 | 1 | 0 | |
| SELECT `SiteSetting`.`language_id`, `SiteSetting`.`key`, `SiteSetting`.`value` FROM `LAA0857082-chibagakudo`.`nc3_site_settings` AS `SiteSetting` WHERE `SiteSetting`.`key` LIKE 'Security.enable_bad_ips%' | 1 | 1 | 0 | |
| SELECT `SiteSetting`.`language_id`, `SiteSetting`.`key`, `SiteSetting`.`value` FROM `LAA0857082-chibagakudo`.`nc3_site_settings` AS `SiteSetting` WHERE `SiteSetting`.`key` LIKE 'Security.deny_ip_move%' | 1 | 1 | 0 | |
| SELECT `Page`.`lft`, `Page`.`rght` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE `Page`.`id` = 15 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Page`.`id` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE 1 = 1 AND `Page`.`lft` <= 10 AND `Page`.`rght` >= 11 ORDER BY `Page`.`lft` asc | 2 | 2 | 0 | |
| SELECT `Page`.`theme` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE `id` IN (1, 15) AND `theme` IS NOT NULL ORDER BY `lft` desc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Room`.`lft`, `Room`.`rght` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` WHERE `Room`.`id` = 11 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Room`.`id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` WHERE 1 = 1 AND `Room`.`lft` <= 9 AND `Room`.`rght` >= 10 ORDER BY `Room`.`lft` asc | 3 | 3 | 0 | |
| SELECT `Room`.`theme` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` WHERE `id` IN (4, 1, 11) AND `theme` IS NOT NULL ORDER BY `lft` desc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Room`.`space_id`, `Room`.`id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` WHERE `space_id` = 1 | 1 | 1 | 0 | |
| SELECT `Room`.`space_id`, `Room`.`id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` WHERE `parent_id` = 4 | 3 | 3 | 0 | |
| SELECT `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `Space`.`id`, `Space`.`parent_id`, `Space`.`lft`, `Space`.`rght`, `Space`.`type`, `Space`.`plugin_key`, `Space`.`default_setting_action`, `Space`.`room_disk_size`, `Space`.`room_id_root`, `Space`.`page_id_top`, `Space`.`permalink`, `Space`.`is_m17n`, `Space`.`after_user_save_model`, `Space`.`created_user`, `Space`.`created`, `Space`.`modified_user`, `Space`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) WHERE `Room`.`parent_id` = 4 ORDER BY `Room`.`lft` ASC | 3 | 3 | 0 | |
| SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` IN (1, 2, 3) | 6 | 6 | 0 | |
| SELECT * FROM `LAA0857082-chibagakudo`.`nc3_roles_rooms` AS `RolesRoom` INNER JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoomsUser`.`user_id` IS NULL) WHERE `RolesRoom`.`room_id` IN (1, 2) | 0 | 0 | 0 | |
| SELECT `CalendarFrameSetting`.`id`, `CalendarFrameSetting`.`frame_key`, `CalendarFrameSetting`.`display_type`, `CalendarFrameSetting`.`start_pos`, `CalendarFrameSetting`.`display_count`, `CalendarFrameSetting`.`is_myroom`, `CalendarFrameSetting`.`is_select_room`, `CalendarFrameSetting`.`room_id`, `CalendarFrameSetting`.`timeline_base_time`, `CalendarFrameSetting`.`created_user`, `CalendarFrameSetting`.`created`, `CalendarFrameSetting`.`modified_user`, `CalendarFrameSetting`.`modified`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `Frame`.`id`, `Frame`.`room_id`, `Frame`.`box_id`, `Frame`.`plugin_key`, `Frame`.`block_id`, `Frame`.`key`, `Frame`.`header_type`, `Frame`.`weight`, `Frame`.`is_deleted`, `Frame`.`default_action`, `Frame`.`default_setting_action`, `Frame`.`created_user`, `Frame`.`created`, `Frame`.`modified_user`, `Frame`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `LAA0857082-chibagakudo`.`nc3_calendar_frame_settings` AS `CalendarFrameSetting` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`CalendarFrameSetting`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frames` AS `Frame` ON (`CalendarFrameSetting`.`frame_key` = `Frame`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`CalendarFrameSetting`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`CalendarFrameSetting`.`modified_user` = `TrackableUpdater`.`id`) WHERE `frame_key` = '1a59a3167e70d1248c021b20b4f2e34a' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `CalendarFrameSettingSelectRoom`.`id`, `CalendarFrameSettingSelectRoom`.`calendar_frame_setting_id`, `CalendarFrameSettingSelectRoom`.`room_id`, `CalendarFrameSettingSelectRoom`.`created_user`, `CalendarFrameSettingSelectRoom`.`created`, `CalendarFrameSettingSelectRoom`.`modified_user`, `CalendarFrameSettingSelectRoom`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_calendar_frame_setting_select_rooms` AS `CalendarFrameSettingSelectRoom` WHERE `CalendarFrameSettingSelectRoom`.`calendar_frame_setting_id` = (1) ORDER BY `id` ASC | 0 | 0 | 0 | |
| SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = 2 AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`lft` ASC | 6 | 6 | 0 | |
| SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` IN (1, 7, 9, 10, 11, 15) | 7 | 7 | 0 | |
| SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` IN (1, 7, 9, 10, 11, 15) | 5 | 5 | 0 | |
| SELECT `Room`.`id`, `Room`.`lft`, `Room`.`rght` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` WHERE `Room`.`id` IN (1, 1, 7, 9, 10, 11, 15) AND 1 = 1 ORDER BY `Room`.`lft` asc | 6 | 6 | 0 | |
| SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = 4 AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`lft` ASC | 2 | 2 | 0 | |
| SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` IN (13, 14) | 2 | 2 | 0 | |
| SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` IN (13, 14) | 0 | 0 | 0 | |
| SELECT `Room`.`id`, `Room`.`lft`, `Room`.`rght` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` WHERE `Room`.`id` IN (3, 13, 14) AND 1 = 1 ORDER BY `Room`.`lft` asc | 3 | 3 | 0 | |
| SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`lft` ASC | 6 | 6 | 0 | |
| SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` IN (1, 7, 9, 10, 11, 15) | 7 | 7 | 0 | |
| SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` IN (1, 7, 9, 10, 11, 15) | 5 | 5 | 0 | |
| SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`lft` ASC | 6 | 6 | 0 | |
| SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` IN (1, 7, 9, 10, 11, 15) | 7 | 7 | 0 | |
| SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` IN (1, 7, 9, 10, 11, 15) | 5 | 5 | 0 | |
| SELECT `RolesRoomsUser`.*, `RolesRoom`.*, `Room`.* FROM `LAA0857082-chibagakudo`.`nc3_roles_rooms_users` AS `RolesRoomsUser` INNER JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id) INNER JOIN `LAA0857082-chibagakudo`.`nc3_room_roles` AS `RoomRole` ON (`RoomRole`.`role_key` = RolesRoom .role_key) INNER JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`RolesRoom`.`room_id` = Room .id) INNER JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `User` ON (`RolesRoomsUser`.`user_id` = User .id) WHERE NOT (`Room`.`page_id_top` IS NULL) AND `RolesRoomsUser`.`user_id` IS NULL | 0 | 0 | 0 | |
| SELECT `Holiday`.`id`, `Holiday`.`key`, `Holiday`.`holiday_rrule_id`, `Holiday`.`language_id`, `Holiday`.`is_origin`, `Holiday`.`is_translation`, `Holiday`.`is_original_copy`, `Holiday`.`holiday`, `Holiday`.`title`, `Holiday`.`is_substitute`, `Holiday`.`created_user`, `Holiday`.`created`, `Holiday`.`modified_user`, `Holiday`.`modified`, `HolidayRrule`.`id`, `HolidayRrule`.`is_variable`, `HolidayRrule`.`month_day`, `HolidayRrule`.`week`, `HolidayRrule`.`day_of_the_week`, `HolidayRrule`.`can_substitute`, `HolidayRrule`.`start_year`, `HolidayRrule`.`end_year`, `HolidayRrule`.`rrule`, `HolidayRrule`.`created_user`, `HolidayRrule`.`created`, `HolidayRrule`.`modified_user`, `HolidayRrule`.`modified`, `Language`.`id`, `Language`.`code`, `Language`.`weight`, `Language`.`is_active`, `Language`.`created_user`, `Language`.`created`, `Language`.`modified_user`, `Language`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `LAA0857082-chibagakudo`.`nc3_holidays` AS `Holiday` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_holiday_rrules` AS `HolidayRrule` ON (`Holiday`.`holiday_rrule_id` = `HolidayRrule`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_languages` AS `Language` ON (`Holiday`.`language_id` = `Language`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Holiday`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Holiday`.`modified_user` = `TrackableUpdater`.`id`) WHERE `language_id` = 2 AND `holiday` >= '2018-11-01' AND `holiday` <= '2019-01-31' ORDER BY `holiday` ASC | 6 | 6 | 2 | maybe slow |
| SELECT `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` WHERE `Room`.`id` IN (1, 7, 9, 10, 11, 15) ORDER BY `Room`.`id` ASC | 6 | 6 | 0 | |
| SELECT `RoomsLanguages`.`id`, `RoomsLanguages`.`language_id`, `RoomsLanguages`.`is_origin`, `RoomsLanguages`.`is_translation`, `RoomsLanguages`.`is_original_copy`, `RoomsLanguages`.`room_id`, `RoomsLanguages`.`name`, `RoomsLanguages`.`created_user`, `RoomsLanguages`.`created`, `RoomsLanguages`.`modified_user`, `RoomsLanguages`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguages` WHERE `room_id` IN (1, 7, 9, 10, 11, 15) AND `language_id` = 2 | 6 | 6 | 0 | |
| SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = 2 AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`lft` ASC | 6 | 6 | 0 | |
| SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` IN (1, 7, 9, 10, 11, 15) | 7 | 7 | 0 | |
| SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` IN (1, 7, 9, 10, 11, 15) | 5 | 5 | 0 | |
| SELECT `Room`.`id`, `Room`.`lft`, `Room`.`rght` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` WHERE `Room`.`id` IN (1, 1, 7, 9, 10, 11, 15) AND 1 = 1 ORDER BY `Room`.`lft` asc | 6 | 6 | 0 | |
| SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = 4 AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`lft` ASC | 2 | 2 | 1 | maybe slow |
| SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` IN (13, 14) | 2 | 2 | 0 | |
| SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` IN (13, 14) | 0 | 0 | 0 | |
| SELECT `Room`.`id`, `Room`.`lft`, `Room`.`rght` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` WHERE `Room`.`id` IN (3, 13, 14) AND 1 = 1 ORDER BY `Room`.`lft` asc | 3 | 3 | 0 | |
| SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`lft` ASC | 6 | 6 | 0 | |
| SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` IN (1, 7, 9, 10, 11, 15) | 7 | 7 | 0 | |
| SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` IN (1, 7, 9, 10, 11, 15) | 5 | 5 | 2 | maybe slow |
| SELECT `CalendarEvent`.`id`, `CalendarEvent`.`calendar_rrule_id`, `CalendarEvent`.`key`, `CalendarEvent`.`room_id`, `CalendarEvent`.`language_id`, `CalendarEvent`.`is_origin`, `CalendarEvent`.`is_translation`, `CalendarEvent`.`is_original_copy`, `CalendarEvent`.`target_user`, `CalendarEvent`.`title`, `CalendarEvent`.`title_icon`, `CalendarEvent`.`location`, `CalendarEvent`.`contact`, `CalendarEvent`.`description`, `CalendarEvent`.`is_allday`, `CalendarEvent`.`start_date`, `CalendarEvent`.`start_time`, `CalendarEvent`.`dtstart`, `CalendarEvent`.`end_date`, `CalendarEvent`.`end_time`, `CalendarEvent`.`dtend`, `CalendarEvent`.`timezone_offset`, `CalendarEvent`.`status`, `CalendarEvent`.`is_active`, `CalendarEvent`.`is_latest`, `CalendarEvent`.`recurrence_event_id`, `CalendarEvent`.`exception_event_id`, `CalendarEvent`.`is_enable_mail`, `CalendarEvent`.`email_send_timing`, `CalendarEvent`.`created_user`, `CalendarEvent`.`created`, `CalendarEvent`.`modified_user`, `CalendarEvent`.`modified`, `CalendarRrule`.`id`, `CalendarRrule`.`calendar_id`, `CalendarRrule`.`key`, `CalendarRrule`.`name`, `CalendarRrule`.`rrule`, `CalendarRrule`.`icalendar_uid`, `CalendarRrule`.`icalendar_comp_name`, `CalendarRrule`.`room_id`, `CalendarRrule`.`created_user`, `CalendarRrule`.`created`, `CalendarRrule`.`modified_user`, `CalendarRrule`.`modified`, `Language`.`id`, `Language`.`code`, `Language`.`weight`, `Language`.`is_active`, `Language`.`created_user`, `Language`.`created`, `Language`.`modified_user`, `Language`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `LAA0857082-chibagakudo`.`nc3_calendar_events` AS `CalendarEvent` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_calendar_rrules` AS `CalendarRrule` ON (`CalendarEvent`.`calendar_rrule_id` = `CalendarRrule`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_languages` AS `Language` ON (`CalendarEvent`.`language_id` = `Language`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`CalendarEvent`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`CalendarEvent`.`modified_user` = `TrackableUpdater`.`id`) WHERE ((`CalendarEvent`.`is_active` = '1') OR (`CalendarEvent`.`is_latest` = '1')) AND ((`CalendarEvent`.`language_id` = 2) OR (`CalendarEvent`.`is_translation` = '0')) AND `CalendarEvent`.`dtstart` >= '20181031150000' AND `CalendarEvent`.`dtend` < '20190131150000' AND `CalendarEvent`.`room_id` IN (1, 7, 9, 10, 11, 15) ORDER BY `CalendarEvent`.`dtstart` ASC | 2 | 2 | 5 | maybe slow |
| SELECT `CalendarEventShareUser`.`id`, `CalendarEventShareUser`.`calendar_event_id`, `CalendarEventShareUser`.`share_user`, `CalendarEventShareUser`.`created_user`, `CalendarEventShareUser`.`created`, `CalendarEventShareUser`.`modified_user`, `CalendarEventShareUser`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_calendar_event_share_users` AS `CalendarEventShareUser` WHERE `CalendarEventShareUser`.`calendar_event_id` IN (21, 22) ORDER BY `id` ASC | 0 | 0 | 0 | |
| SELECT `CalendarEventContent`.`id`, `CalendarEventContent`.`model`, `CalendarEventContent`.`content_key`, `CalendarEventContent`.`calendar_event_id`, `CalendarEventContent`.`created_user`, `CalendarEventContent`.`created`, `CalendarEventContent`.`modified_user`, `CalendarEventContent`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_calendar_event_contents` AS `CalendarEventContent` WHERE `CalendarEventContent`.`calendar_event_id` IN (21, 22) ORDER BY `id` ASC | 0 | 0 | 0 | |
| SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`permalink`, `Page`.`slug`, `Page`.`is_container_fluid`, `Page`.`theme`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `ParentPage`.`id`, `ParentPage`.`room_id`, `ParentPage`.`root_id`, `ParentPage`.`parent_id`, `ParentPage`.`lft`, `ParentPage`.`rght`, `ParentPage`.`permalink`, `ParentPage`.`slug`, `ParentPage`.`is_container_fluid`, `ParentPage`.`theme`, `ParentPage`.`created_user`, `ParentPage`.`created`, `ParentPage`.`modified_user`, `ParentPage`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Space`.`id`, `Space`.`parent_id`, `Space`.`lft`, `Space`.`rght`, `Space`.`type`, `Space`.`plugin_key`, `Space`.`default_setting_action`, `Space`.`room_disk_size`, `Space`.`room_id_root`, `Space`.`page_id_top`, `Space`.`permalink`, `Space`.`is_m17n`, `Space`.`after_user_save_model`, `Space`.`created_user`, `Space`.`created`, `Space`.`modified_user`, `Space`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_pages` AS `ParentPage` ON (`Page`.`parent_id` = `ParentPage`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Page`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Page`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) WHERE `Page`.`permalink` = 'schedule' AND `Room`.`space_id` = 2 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PagesLanguage`.`id`, `PagesLanguage`.`language_id`, `PagesLanguage`.`is_origin`, `PagesLanguage`.`is_translation`, `PagesLanguage`.`page_id`, `PagesLanguage`.`name`, `PagesLanguage`.`meta_title`, `PagesLanguage`.`meta_description`, `PagesLanguage`.`meta_keywords`, `PagesLanguage`.`meta_robots`, `PagesLanguage`.`created_user`, `PagesLanguage`.`created`, `PagesLanguage`.`modified_user`, `PagesLanguage`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_pages_languages` AS `PagesLanguage` WHERE `PagesLanguage`.`page_id` = 15 AND `PagesLanguage`.`language_id` = 2 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PageContainer`.`id`, `PageContainer`.`page_id`, `PageContainer`.`container_type`, `PageContainer`.`is_published`, `PageContainer`.`is_configured`, `PageContainer`.`created_user`, `PageContainer`.`created`, `PageContainer`.`modified_user`, `PageContainer`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_page_containers` AS `PageContainer` WHERE `PageContainer`.`page_id` = 15 ORDER BY `container_type` asc | 5 | 5 | 0 | |
| SELECT `BoxesPageContainer`.`id`, `BoxesPageContainer`.`page_container_id`, `BoxesPageContainer`.`page_id`, `BoxesPageContainer`.`container_type`, `BoxesPageContainer`.`box_id`, `BoxesPageContainer`.`is_published`, `BoxesPageContainer`.`weight`, `BoxesPageContainer`.`created_user`, `BoxesPageContainer`.`created`, `BoxesPageContainer`.`modified_user`, `BoxesPageContainer`.`modified`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `RoomsLanguage`.`id`, `RoomsLanguage`.`name` FROM `LAA0857082-chibagakudo`.`nc3_boxes_page_containers` AS `BoxesPageContainer` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` ON (`BoxesPageContainer`.`box_id` = `Box`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`BoxesPageContainer`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`BoxesPageContainer`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Room`.`id` = `Box`.`room_id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` ON (`RoomsLanguage`.`room_id` = `Box`.`room_id` AND `RoomsLanguage`.`language_id` = 2) WHERE `BoxesPageContainer`.`page_container_id` = 71 AND `BoxesPageContainer`.`is_published` = '1' ORDER BY `BoxesPageContainer`.`weight` ASC | 1 | 1 | 0 | |
| SELECT `Frame`.`id`, `Frame`.`room_id`, `Frame`.`box_id`, `Frame`.`plugin_key`, `Frame`.`block_id`, `Frame`.`key`, `Frame`.`header_type`, `Frame`.`weight`, `Frame`.`is_deleted`, `Frame`.`default_action`, `Frame`.`default_setting_action`, `Frame`.`created_user`, `Frame`.`created`, `Frame`.`modified_user`, `Frame`.`modified`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `Block`.`id`, `Block`.`room_id`, `Block`.`plugin_key`, `Block`.`key`, `Block`.`public_type`, `Block`.`publish_start`, `Block`.`publish_end`, `Block`.`content_count`, `Block`.`created_user`, `Block`.`created`, `Block`.`modified_user`, `Block`.`modified`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Plugin`.`id`, `Plugin`.`language_id`, `Plugin`.`is_origin`, `Plugin`.`is_translation`, `Plugin`.`is_original_copy`, `Plugin`.`key`, `Plugin`.`is_m17n`, `Plugin`.`name`, `Plugin`.`namespace`, `Plugin`.`weight`, `Plugin`.`type`, `Plugin`.`version`, `Plugin`.`commit_version`, `Plugin`.`commited`, `Plugin`.`default_action`, `Plugin`.`default_setting_action`, `Plugin`.`frame_add_action`, `Plugin`.`display_topics`, `Plugin`.`display_search`, `Plugin`.`serialize_data`, `Plugin`.`created_user`, `Plugin`.`created`, `Plugin`.`modified_user`, `Plugin`.`modified`, `FramePublicLanguage`.`id`, `FramePublicLanguage`.`language_id`, `FramePublicLanguage`.`frame_id`, `FramePublicLanguage`.`is_public`, `FramesLanguage`.`id`, `FramesLanguage`.`language_id`, `FramesLanguage`.`frame_id`, `FramesLanguage`.`name`, `FramesLanguage`.`is_origin`, `FramesLanguage`.`is_translation`, `FramesLanguage`.`is_original_copy`, `BlocksLanguage`.`language_id`, `BlocksLanguage`.`block_id`, `BlocksLanguage`.`name`, `BlocksLanguage`.`is_origin`, `BlocksLanguage`.`is_translation`, `BlocksLanguage`.`is_original_copy` FROM `LAA0857082-chibagakudo`.`nc3_frames` AS `Frame` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` ON (`Frame`.`box_id` = `Box`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks` AS `Block` ON (`Frame`.`block_id` = `Block`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Frame`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Frame`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Frame`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_plugins` AS `Plugin` ON (`Plugin`.`key` = `Frame`.`plugin_key` AND `Plugin`.`language_id` = 2) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frame_public_languages` AS `FramePublicLanguage` ON (`FramePublicLanguage`.`frame_id` = `Frame`.`id` AND `FramePublicLanguage`.`language_id` IN (0, 2) AND `FramePublicLanguage`.`is_public` = '1') LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frames_languages` AS `FramesLanguage` ON (`FramesLanguage`.`frame_id` = `Frame`.`id` AND ((`FramesLanguage`.`is_translation` = '0') OR (`FramesLanguage`.`language_id` = 2))) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND ((`BlocksLanguage`.`is_translation` = '0') OR (`BlocksLanguage`.`language_id` = 2))) WHERE `Frame`.`is_deleted` = '0' AND `Frame`.`box_id` = 17 ORDER BY `Frame`.`weight` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `BoxesPageContainer`.`id`, `BoxesPageContainer`.`page_container_id`, `BoxesPageContainer`.`page_id`, `BoxesPageContainer`.`container_type`, `BoxesPageContainer`.`box_id`, `BoxesPageContainer`.`is_published`, `BoxesPageContainer`.`weight`, `BoxesPageContainer`.`created_user`, `BoxesPageContainer`.`created`, `BoxesPageContainer`.`modified_user`, `BoxesPageContainer`.`modified`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `RoomsLanguage`.`id`, `RoomsLanguage`.`name` FROM `LAA0857082-chibagakudo`.`nc3_boxes_page_containers` AS `BoxesPageContainer` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` ON (`BoxesPageContainer`.`box_id` = `Box`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`BoxesPageContainer`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`BoxesPageContainer`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Room`.`id` = `Box`.`room_id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` ON (`RoomsLanguage`.`room_id` = `Box`.`room_id` AND `RoomsLanguage`.`language_id` = 2) WHERE `BoxesPageContainer`.`page_container_id` = 72 AND `BoxesPageContainer`.`is_published` = '1' ORDER BY `BoxesPageContainer`.`weight` ASC | 1 | 1 | 0 | |
| SELECT `Frame`.`id`, `Frame`.`room_id`, `Frame`.`box_id`, `Frame`.`plugin_key`, `Frame`.`block_id`, `Frame`.`key`, `Frame`.`header_type`, `Frame`.`weight`, `Frame`.`is_deleted`, `Frame`.`default_action`, `Frame`.`default_setting_action`, `Frame`.`created_user`, `Frame`.`created`, `Frame`.`modified_user`, `Frame`.`modified`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `Block`.`id`, `Block`.`room_id`, `Block`.`plugin_key`, `Block`.`key`, `Block`.`public_type`, `Block`.`publish_start`, `Block`.`publish_end`, `Block`.`content_count`, `Block`.`created_user`, `Block`.`created`, `Block`.`modified_user`, `Block`.`modified`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Plugin`.`id`, `Plugin`.`language_id`, `Plugin`.`is_origin`, `Plugin`.`is_translation`, `Plugin`.`is_original_copy`, `Plugin`.`key`, `Plugin`.`is_m17n`, `Plugin`.`name`, `Plugin`.`namespace`, `Plugin`.`weight`, `Plugin`.`type`, `Plugin`.`version`, `Plugin`.`commit_version`, `Plugin`.`commited`, `Plugin`.`default_action`, `Plugin`.`default_setting_action`, `Plugin`.`frame_add_action`, `Plugin`.`display_topics`, `Plugin`.`display_search`, `Plugin`.`serialize_data`, `Plugin`.`created_user`, `Plugin`.`created`, `Plugin`.`modified_user`, `Plugin`.`modified`, `FramePublicLanguage`.`id`, `FramePublicLanguage`.`language_id`, `FramePublicLanguage`.`frame_id`, `FramePublicLanguage`.`is_public`, `FramesLanguage`.`id`, `FramesLanguage`.`language_id`, `FramesLanguage`.`frame_id`, `FramesLanguage`.`name`, `FramesLanguage`.`is_origin`, `FramesLanguage`.`is_translation`, `FramesLanguage`.`is_original_copy`, `BlocksLanguage`.`language_id`, `BlocksLanguage`.`block_id`, `BlocksLanguage`.`name`, `BlocksLanguage`.`is_origin`, `BlocksLanguage`.`is_translation`, `BlocksLanguage`.`is_original_copy` FROM `LAA0857082-chibagakudo`.`nc3_frames` AS `Frame` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` ON (`Frame`.`box_id` = `Box`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks` AS `Block` ON (`Frame`.`block_id` = `Block`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Frame`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Frame`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Frame`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_plugins` AS `Plugin` ON (`Plugin`.`key` = `Frame`.`plugin_key` AND `Plugin`.`language_id` = 2) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frame_public_languages` AS `FramePublicLanguage` ON (`FramePublicLanguage`.`frame_id` = `Frame`.`id` AND `FramePublicLanguage`.`language_id` IN (0, 2) AND `FramePublicLanguage`.`is_public` = '1') LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frames_languages` AS `FramesLanguage` ON (`FramesLanguage`.`frame_id` = `Frame`.`id` AND ((`FramesLanguage`.`is_translation` = '0') OR (`FramesLanguage`.`language_id` = 2))) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND ((`BlocksLanguage`.`is_translation` = '0') OR (`BlocksLanguage`.`language_id` = 2))) WHERE `Frame`.`is_deleted` = '0' AND `Frame`.`box_id` = 18 ORDER BY `Frame`.`weight` ASC | 1 | 1 | 1 | |
| SELECT `BoxesPageContainer`.`id`, `BoxesPageContainer`.`page_container_id`, `BoxesPageContainer`.`page_id`, `BoxesPageContainer`.`container_type`, `BoxesPageContainer`.`box_id`, `BoxesPageContainer`.`is_published`, `BoxesPageContainer`.`weight`, `BoxesPageContainer`.`created_user`, `BoxesPageContainer`.`created`, `BoxesPageContainer`.`modified_user`, `BoxesPageContainer`.`modified`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `RoomsLanguage`.`id`, `RoomsLanguage`.`name` FROM `LAA0857082-chibagakudo`.`nc3_boxes_page_containers` AS `BoxesPageContainer` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` ON (`BoxesPageContainer`.`box_id` = `Box`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`BoxesPageContainer`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`BoxesPageContainer`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Room`.`id` = `Box`.`room_id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` ON (`RoomsLanguage`.`room_id` = `Box`.`room_id` AND `RoomsLanguage`.`language_id` = 2) WHERE `BoxesPageContainer`.`page_container_id` = 73 AND `BoxesPageContainer`.`is_published` = '1' ORDER BY `BoxesPageContainer`.`weight` ASC | 1 | 1 | 0 | |
| SELECT `Frame`.`id`, `Frame`.`room_id`, `Frame`.`box_id`, `Frame`.`plugin_key`, `Frame`.`block_id`, `Frame`.`key`, `Frame`.`header_type`, `Frame`.`weight`, `Frame`.`is_deleted`, `Frame`.`default_action`, `Frame`.`default_setting_action`, `Frame`.`created_user`, `Frame`.`created`, `Frame`.`modified_user`, `Frame`.`modified`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `Block`.`id`, `Block`.`room_id`, `Block`.`plugin_key`, `Block`.`key`, `Block`.`public_type`, `Block`.`publish_start`, `Block`.`publish_end`, `Block`.`content_count`, `Block`.`created_user`, `Block`.`created`, `Block`.`modified_user`, `Block`.`modified`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Plugin`.`id`, `Plugin`.`language_id`, `Plugin`.`is_origin`, `Plugin`.`is_translation`, `Plugin`.`is_original_copy`, `Plugin`.`key`, `Plugin`.`is_m17n`, `Plugin`.`name`, `Plugin`.`namespace`, `Plugin`.`weight`, `Plugin`.`type`, `Plugin`.`version`, `Plugin`.`commit_version`, `Plugin`.`commited`, `Plugin`.`default_action`, `Plugin`.`default_setting_action`, `Plugin`.`frame_add_action`, `Plugin`.`display_topics`, `Plugin`.`display_search`, `Plugin`.`serialize_data`, `Plugin`.`created_user`, `Plugin`.`created`, `Plugin`.`modified_user`, `Plugin`.`modified`, `FramePublicLanguage`.`id`, `FramePublicLanguage`.`language_id`, `FramePublicLanguage`.`frame_id`, `FramePublicLanguage`.`is_public`, `FramesLanguage`.`id`, `FramesLanguage`.`language_id`, `FramesLanguage`.`frame_id`, `FramesLanguage`.`name`, `FramesLanguage`.`is_origin`, `FramesLanguage`.`is_translation`, `FramesLanguage`.`is_original_copy`, `BlocksLanguage`.`language_id`, `BlocksLanguage`.`block_id`, `BlocksLanguage`.`name`, `BlocksLanguage`.`is_origin`, `BlocksLanguage`.`is_translation`, `BlocksLanguage`.`is_original_copy` FROM `LAA0857082-chibagakudo`.`nc3_frames` AS `Frame` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` ON (`Frame`.`box_id` = `Box`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks` AS `Block` ON (`Frame`.`block_id` = `Block`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Frame`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Frame`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Frame`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_plugins` AS `Plugin` ON (`Plugin`.`key` = `Frame`.`plugin_key` AND `Plugin`.`language_id` = 2) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frame_public_languages` AS `FramePublicLanguage` ON (`FramePublicLanguage`.`frame_id` = `Frame`.`id` AND `FramePublicLanguage`.`language_id` IN (0, 2) AND `FramePublicLanguage`.`is_public` = '1') LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frames_languages` AS `FramesLanguage` ON (`FramesLanguage`.`frame_id` = `Frame`.`id` AND ((`FramesLanguage`.`is_translation` = '0') OR (`FramesLanguage`.`language_id` = 2))) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND ((`BlocksLanguage`.`is_translation` = '0') OR (`BlocksLanguage`.`language_id` = 2))) WHERE `Frame`.`is_deleted` = '0' AND `Frame`.`box_id` = 150 ORDER BY `Frame`.`weight` ASC | 1 | 1 | 1 | |
| SELECT `BoxesPageContainer`.`id`, `BoxesPageContainer`.`page_container_id`, `BoxesPageContainer`.`page_id`, `BoxesPageContainer`.`container_type`, `BoxesPageContainer`.`box_id`, `BoxesPageContainer`.`is_published`, `BoxesPageContainer`.`weight`, `BoxesPageContainer`.`created_user`, `BoxesPageContainer`.`created`, `BoxesPageContainer`.`modified_user`, `BoxesPageContainer`.`modified`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `RoomsLanguage`.`id`, `RoomsLanguage`.`name` FROM `LAA0857082-chibagakudo`.`nc3_boxes_page_containers` AS `BoxesPageContainer` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` ON (`BoxesPageContainer`.`box_id` = `Box`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`BoxesPageContainer`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`BoxesPageContainer`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Room`.`id` = `Box`.`room_id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` ON (`RoomsLanguage`.`room_id` = `Box`.`room_id` AND `RoomsLanguage`.`language_id` = 2) WHERE `BoxesPageContainer`.`page_container_id` = 74 AND `BoxesPageContainer`.`is_published` = '1' ORDER BY `BoxesPageContainer`.`weight` ASC | 1 | 1 | 1 | |
| SELECT `Frame`.`id`, `Frame`.`room_id`, `Frame`.`box_id`, `Frame`.`plugin_key`, `Frame`.`block_id`, `Frame`.`key`, `Frame`.`header_type`, `Frame`.`weight`, `Frame`.`is_deleted`, `Frame`.`default_action`, `Frame`.`default_setting_action`, `Frame`.`created_user`, `Frame`.`created`, `Frame`.`modified_user`, `Frame`.`modified`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `Block`.`id`, `Block`.`room_id`, `Block`.`plugin_key`, `Block`.`key`, `Block`.`public_type`, `Block`.`publish_start`, `Block`.`publish_end`, `Block`.`content_count`, `Block`.`created_user`, `Block`.`created`, `Block`.`modified_user`, `Block`.`modified`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Plugin`.`id`, `Plugin`.`language_id`, `Plugin`.`is_origin`, `Plugin`.`is_translation`, `Plugin`.`is_original_copy`, `Plugin`.`key`, `Plugin`.`is_m17n`, `Plugin`.`name`, `Plugin`.`namespace`, `Plugin`.`weight`, `Plugin`.`type`, `Plugin`.`version`, `Plugin`.`commit_version`, `Plugin`.`commited`, `Plugin`.`default_action`, `Plugin`.`default_setting_action`, `Plugin`.`frame_add_action`, `Plugin`.`display_topics`, `Plugin`.`display_search`, `Plugin`.`serialize_data`, `Plugin`.`created_user`, `Plugin`.`created`, `Plugin`.`modified_user`, `Plugin`.`modified`, `FramePublicLanguage`.`id`, `FramePublicLanguage`.`language_id`, `FramePublicLanguage`.`frame_id`, `FramePublicLanguage`.`is_public`, `FramesLanguage`.`id`, `FramesLanguage`.`language_id`, `FramesLanguage`.`frame_id`, `FramesLanguage`.`name`, `FramesLanguage`.`is_origin`, `FramesLanguage`.`is_translation`, `FramesLanguage`.`is_original_copy`, `BlocksLanguage`.`language_id`, `BlocksLanguage`.`block_id`, `BlocksLanguage`.`name`, `BlocksLanguage`.`is_origin`, `BlocksLanguage`.`is_translation`, `BlocksLanguage`.`is_original_copy` FROM `LAA0857082-chibagakudo`.`nc3_frames` AS `Frame` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` ON (`Frame`.`box_id` = `Box`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks` AS `Block` ON (`Frame`.`block_id` = `Block`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Frame`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Frame`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Frame`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_plugins` AS `Plugin` ON (`Plugin`.`key` = `Frame`.`plugin_key` AND `Plugin`.`language_id` = 2) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frame_public_languages` AS `FramePublicLanguage` ON (`FramePublicLanguage`.`frame_id` = `Frame`.`id` AND `FramePublicLanguage`.`language_id` IN (0, 2) AND `FramePublicLanguage`.`is_public` = '1') LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frames_languages` AS `FramesLanguage` ON (`FramesLanguage`.`frame_id` = `Frame`.`id` AND ((`FramesLanguage`.`is_translation` = '0') OR (`FramesLanguage`.`language_id` = 2))) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND ((`BlocksLanguage`.`is_translation` = '0') OR (`BlocksLanguage`.`language_id` = 2))) WHERE `Frame`.`is_deleted` = '0' AND `Frame`.`box_id` = 19 ORDER BY `Frame`.`weight` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `BoxesPageContainer`.`id`, `BoxesPageContainer`.`page_container_id`, `BoxesPageContainer`.`page_id`, `BoxesPageContainer`.`container_type`, `BoxesPageContainer`.`box_id`, `BoxesPageContainer`.`is_published`, `BoxesPageContainer`.`weight`, `BoxesPageContainer`.`created_user`, `BoxesPageContainer`.`created`, `BoxesPageContainer`.`modified_user`, `BoxesPageContainer`.`modified`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `RoomsLanguage`.`id`, `RoomsLanguage`.`name` FROM `LAA0857082-chibagakudo`.`nc3_boxes_page_containers` AS `BoxesPageContainer` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` ON (`BoxesPageContainer`.`box_id` = `Box`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`BoxesPageContainer`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`BoxesPageContainer`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Room`.`id` = `Box`.`room_id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` ON (`RoomsLanguage`.`room_id` = `Box`.`room_id` AND `RoomsLanguage`.`language_id` = 2) WHERE `BoxesPageContainer`.`page_container_id` = 75 AND `BoxesPageContainer`.`is_published` = '1' ORDER BY `BoxesPageContainer`.`weight` ASC | 1 | 1 | 0 | |
| SELECT `Frame`.`id`, `Frame`.`room_id`, `Frame`.`box_id`, `Frame`.`plugin_key`, `Frame`.`block_id`, `Frame`.`key`, `Frame`.`header_type`, `Frame`.`weight`, `Frame`.`is_deleted`, `Frame`.`default_action`, `Frame`.`default_setting_action`, `Frame`.`created_user`, `Frame`.`created`, `Frame`.`modified_user`, `Frame`.`modified`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `Block`.`id`, `Block`.`room_id`, `Block`.`plugin_key`, `Block`.`key`, `Block`.`public_type`, `Block`.`publish_start`, `Block`.`publish_end`, `Block`.`content_count`, `Block`.`created_user`, `Block`.`created`, `Block`.`modified_user`, `Block`.`modified`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Plugin`.`id`, `Plugin`.`language_id`, `Plugin`.`is_origin`, `Plugin`.`is_translation`, `Plugin`.`is_original_copy`, `Plugin`.`key`, `Plugin`.`is_m17n`, `Plugin`.`name`, `Plugin`.`namespace`, `Plugin`.`weight`, `Plugin`.`type`, `Plugin`.`version`, `Plugin`.`commit_version`, `Plugin`.`commited`, `Plugin`.`default_action`, `Plugin`.`default_setting_action`, `Plugin`.`frame_add_action`, `Plugin`.`display_topics`, `Plugin`.`display_search`, `Plugin`.`serialize_data`, `Plugin`.`created_user`, `Plugin`.`created`, `Plugin`.`modified_user`, `Plugin`.`modified`, `FramePublicLanguage`.`id`, `FramePublicLanguage`.`language_id`, `FramePublicLanguage`.`frame_id`, `FramePublicLanguage`.`is_public`, `FramesLanguage`.`id`, `FramesLanguage`.`language_id`, `FramesLanguage`.`frame_id`, `FramesLanguage`.`name`, `FramesLanguage`.`is_origin`, `FramesLanguage`.`is_translation`, `FramesLanguage`.`is_original_copy`, `BlocksLanguage`.`language_id`, `BlocksLanguage`.`block_id`, `BlocksLanguage`.`name`, `BlocksLanguage`.`is_origin`, `BlocksLanguage`.`is_translation`, `BlocksLanguage`.`is_original_copy` FROM `LAA0857082-chibagakudo`.`nc3_frames` AS `Frame` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` ON (`Frame`.`box_id` = `Box`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks` AS `Block` ON (`Frame`.`block_id` = `Block`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Frame`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Frame`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Frame`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_plugins` AS `Plugin` ON (`Plugin`.`key` = `Frame`.`plugin_key` AND `Plugin`.`language_id` = 2) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frame_public_languages` AS `FramePublicLanguage` ON (`FramePublicLanguage`.`frame_id` = `Frame`.`id` AND `FramePublicLanguage`.`language_id` IN (0, 2) AND `FramePublicLanguage`.`is_public` = '1') LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frames_languages` AS `FramesLanguage` ON (`FramesLanguage`.`frame_id` = `Frame`.`id` AND ((`FramesLanguage`.`is_translation` = '0') OR (`FramesLanguage`.`language_id` = 2))) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND ((`BlocksLanguage`.`is_translation` = '0') OR (`BlocksLanguage`.`language_id` = 2))) WHERE `Frame`.`is_deleted` = '0' AND `Frame`.`box_id` = 20 ORDER BY `Frame`.`weight` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `SiteSetting`.`language_id`, `SiteSetting`.`key`, `SiteSetting`.`value` FROM `LAA0857082-chibagakudo`.`nc3_site_settings` AS `SiteSetting` WHERE `SiteSetting`.`key` LIKE 'Meta.description%' | 2 | 2 | 0 | |
| SELECT `SiteSetting`.`language_id`, `SiteSetting`.`key`, `SiteSetting`.`value` FROM `LAA0857082-chibagakudo`.`nc3_site_settings` AS `SiteSetting` WHERE `SiteSetting`.`key` LIKE 'Meta.keywords%' | 2 | 2 | 0 | |
| SELECT `SiteSetting`.`language_id`, `SiteSetting`.`key`, `SiteSetting`.`value` FROM `LAA0857082-chibagakudo`.`nc3_site_settings` AS `SiteSetting` WHERE `SiteSetting`.`key` LIKE 'Meta.robots%' | 1 | 1 | 0 | |
| SELECT `SiteSetting`.`language_id`, `SiteSetting`.`key`, `SiteSetting`.`value` FROM `LAA0857082-chibagakudo`.`nc3_site_settings` AS `SiteSetting` WHERE `SiteSetting`.`key` LIKE 'Meta.copyright%' | 2 | 2 | 0 | |
| SELECT `SiteSetting`.`language_id`, `SiteSetting`.`key`, `SiteSetting`.`value` FROM `LAA0857082-chibagakudo`.`nc3_site_settings` AS `SiteSetting` WHERE `SiteSetting`.`key` LIKE 'Meta.author%' | 2 | 2 | 0 | |
| SELECT `Plugin`.`id`, `Plugin`.`language_id`, `Plugin`.`is_origin`, `Plugin`.`is_translation`, `Plugin`.`is_original_copy`, `Plugin`.`key`, `Plugin`.`is_m17n`, `Plugin`.`name`, `Plugin`.`namespace`, `Plugin`.`weight`, `Plugin`.`type`, `Plugin`.`version`, `Plugin`.`commit_version`, `Plugin`.`commited`, `Plugin`.`default_action`, `Plugin`.`default_setting_action`, `Plugin`.`frame_add_action`, `Plugin`.`display_topics`, `Plugin`.`display_search`, `Plugin`.`serialize_data`, `Plugin`.`created_user`, `Plugin`.`created`, `Plugin`.`modified_user`, `Plugin`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_plugins` AS `Plugin` WHERE `key` = 'menus' AND `language_id` = 2 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Frame`.`id`, `Frame`.`room_id`, `Frame`.`box_id`, `Frame`.`plugin_key`, `Frame`.`block_id`, `Frame`.`key`, `Frame`.`header_type`, `Frame`.`weight`, `Frame`.`is_deleted`, `Frame`.`default_action`, `Frame`.`default_setting_action`, `Frame`.`created_user`, `Frame`.`created`, `Frame`.`modified_user`, `Frame`.`modified`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `Block`.`id`, `Block`.`room_id`, `Block`.`plugin_key`, `Block`.`key`, `Block`.`public_type`, `Block`.`publish_start`, `Block`.`publish_end`, `Block`.`content_count`, `Block`.`created_user`, `Block`.`created`, `Block`.`modified_user`, `Block`.`modified`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Plugin`.`id`, `Plugin`.`language_id`, `Plugin`.`is_origin`, `Plugin`.`is_translation`, `Plugin`.`is_original_copy`, `Plugin`.`key`, `Plugin`.`is_m17n`, `Plugin`.`name`, `Plugin`.`namespace`, `Plugin`.`weight`, `Plugin`.`type`, `Plugin`.`version`, `Plugin`.`commit_version`, `Plugin`.`commited`, `Plugin`.`default_action`, `Plugin`.`default_setting_action`, `Plugin`.`frame_add_action`, `Plugin`.`display_topics`, `Plugin`.`display_search`, `Plugin`.`serialize_data`, `Plugin`.`created_user`, `Plugin`.`created`, `Plugin`.`modified_user`, `Plugin`.`modified`, `FramePublicLanguage`.`id`, `FramePublicLanguage`.`language_id`, `FramePublicLanguage`.`frame_id`, `FramePublicLanguage`.`is_public`, `FramesLanguage`.`id`, `FramesLanguage`.`language_id`, `FramesLanguage`.`frame_id`, `FramesLanguage`.`name`, `FramesLanguage`.`is_origin`, `FramesLanguage`.`is_translation`, `FramesLanguage`.`is_original_copy`, `BlocksLanguage`.`language_id`, `BlocksLanguage`.`block_id`, `BlocksLanguage`.`name`, `BlocksLanguage`.`is_origin`, `BlocksLanguage`.`is_translation`, `BlocksLanguage`.`is_original_copy` FROM `LAA0857082-chibagakudo`.`nc3_frames` AS `Frame` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` ON (`Frame`.`box_id` = `Box`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks` AS `Block` ON (`Frame`.`block_id` = `Block`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Frame`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Frame`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Frame`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_plugins` AS `Plugin` ON (`Plugin`.`key` = `Frame`.`plugin_key` AND `Plugin`.`language_id` = 2) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frame_public_languages` AS `FramePublicLanguage` ON (`FramePublicLanguage`.`frame_id` = `Frame`.`id` AND `FramePublicLanguage`.`language_id` IN (0, 2) AND `FramePublicLanguage`.`is_public` = '1') LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frames_languages` AS `FramesLanguage` ON (`FramesLanguage`.`frame_id` = `Frame`.`id` AND ((`FramesLanguage`.`is_translation` = '0') OR (`FramesLanguage`.`language_id` = 2))) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND ((`BlocksLanguage`.`is_translation` = '0') OR (`BlocksLanguage`.`language_id` = 2))) WHERE `Frame`.`id` = 2 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `Space`.`id`, `Space`.`parent_id`, `Space`.`lft`, `Space`.`rght`, `Space`.`type`, `Space`.`plugin_key`, `Space`.`default_setting_action`, `Space`.`room_disk_size`, `Space`.`room_id_root`, `Space`.`page_id_top`, `Space`.`permalink`, `Space`.`is_m17n`, `Space`.`after_user_save_model`, `Space`.`created_user`, `Space`.`created`, `Space`.`modified_user`, `Space`.`modified`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Box`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Box`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Box`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Box`.`modified_user` = `TrackableUpdater`.`id`) WHERE `Box`.`id` = 18 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Page`.`lft`, `Page`.`rght` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE `Page`.`id` = 15 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Page`.`id` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE 1 = 1 AND `Page`.`lft` <= 10 AND `Page`.`rght` >= 11 ORDER BY `Page`.`lft` asc | 2 | 2 | 0 | |
| SELECT `Page`.`theme` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE `id` IN (1, 15) AND `theme` IS NOT NULL ORDER BY `lft` desc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Room`.*, `RolesRoom`.*, `RolesRoomsUser`.*, `Room`.`id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`lft` ASC | 6 | 6 | 0 | |
| SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` IN (1, 7, 9, 10, 11, 15) | 7 | 7 | 0 | |
| SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` IN (1, 7, 9, 10, 11, 15) | 5 | 5 | 0 | |
| SELECT `Page`.*, `PagesLanguage`.*, `MenuFramesPage`.* FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` INNER JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) INNER JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) INNER JOIN `LAA0857082-chibagakudo`.`nc3_pages_languages` AS `PagesLanguage` ON (`Page`.`id` = PagesLanguage .page_id) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_menu_frames_pages` AS `MenuFramesPage` ON (`Page`.`id` = MenuFramesPage .page_id AND `MenuFramesPage`.`frame_key` = 'frame_2') LEFT JOIN `LAA0857082-chibagakudo`.`nc3_pages_languages` AS `OriginPagesLanguage` ON (`PagesLanguage`.`page_id` = `OriginPagesLanguage`.`page_id` AND `OriginPagesLanguage`.`language_id` = '2') WHERE `Page`.`room_id` IN (1, 7, 9, 10, 11, 15) AND ((`PagesLanguage`.`language_id` = 2) OR (((`Space`.`is_m17n` = '0') AND (((`PagesLanguage`.`id` = `OriginPagesLanguage`.`id`) OR (`OriginPagesLanguage`.`id` IS NULL)))))) AND `Page`.`id` = PagesLanguage .page_id ORDER BY `Page`.`lft` asc | 7 | 7 | 0 | |
| SELECT `MenuFrameSetting`.`id`, `MenuFrameSetting`.`frame_key`, `MenuFrameSetting`.`display_type`, `MenuFrameSetting`.`is_private_room_hidden`, `MenuFrameSetting`.`created_user`, `MenuFrameSetting`.`created`, `MenuFrameSetting`.`modified_user`, `MenuFrameSetting`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_menu_frame_settings` AS `MenuFrameSetting` WHERE `frame_key` = 'frame_2' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Room`.*, `RoomsLanguage`.*, `MenuFramesRoom`.* FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` INNER JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) INNER JOIN `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` ON (`Room`.`id` = RoomsLanguage .room_id AND ((`RoomsLanguage`.`language_id` = '2') OR (`Space`.`is_m17n` = '0'))) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_menu_frames_rooms` AS `MenuFramesRoom` ON (`Room`.`id` = MenuFramesRoom .room_id AND `MenuFramesRoom`.`frame_key` = 'frame_2') LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `OriginRoomsLanguage` ON (`RoomsLanguage`.`room_id` = `OriginRoomsLanguage`.`room_id` AND `OriginRoomsLanguage`.`language_id` = '2') WHERE `Room`.`id` IN (1, 7, 9, 10, 11, 15) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`id` = RoomsLanguage .room_id AND ((`RoomsLanguage`.`language_id` = 2) OR (((`Space`.`is_m17n` = '0') AND (((`RoomsLanguage`.`id` = `OriginRoomsLanguage`.`id`) OR (`OriginRoomsLanguage`.`id` IS NULL)))))) ORDER BY `Room`.`lft` asc | 6 | 6 | 0 | |
| SELECT `PagesLanguage`.`id`, `PagesLanguage`.`language_id`, `PagesLanguage`.`is_origin`, `PagesLanguage`.`is_translation`, `PagesLanguage`.`page_id`, `PagesLanguage`.`name`, `PagesLanguage`.`meta_title`, `PagesLanguage`.`meta_description`, `PagesLanguage`.`meta_keywords`, `PagesLanguage`.`meta_robots`, `PagesLanguage`.`created_user`, `PagesLanguage`.`created`, `PagesLanguage`.`modified_user`, `PagesLanguage`.`modified`, `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`permalink`, `Page`.`slug`, `Page`.`is_container_fluid`, `Page`.`theme`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified`, `Language`.`id`, `Language`.`code`, `Language`.`weight`, `Language`.`is_active`, `Language`.`created_user`, `Language`.`created`, `Language`.`modified_user`, `Language`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `Space`.`id`, `Space`.`parent_id`, `Space`.`lft`, `Space`.`rght`, `Space`.`type`, `Space`.`plugin_key`, `Space`.`default_setting_action`, `Space`.`room_disk_size`, `Space`.`room_id_root`, `Space`.`page_id_top`, `Space`.`permalink`, `Space`.`is_m17n`, `Space`.`after_user_save_model`, `Space`.`created_user`, `Space`.`created`, `Space`.`modified_user`, `Space`.`modified`, `OriginPagesLanguage`.`id`, `OriginPagesLanguage`.`language_id`, `OriginPagesLanguage`.`is_origin`, `OriginPagesLanguage`.`is_translation`, `OriginPagesLanguage`.`page_id`, `OriginPagesLanguage`.`name`, `OriginPagesLanguage`.`meta_title`, `OriginPagesLanguage`.`meta_description`, `OriginPagesLanguage`.`meta_keywords`, `OriginPagesLanguage`.`meta_robots`, `OriginPagesLanguage`.`created_user`, `OriginPagesLanguage`.`created`, `OriginPagesLanguage`.`modified_user`, `OriginPagesLanguage`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_pages_languages` AS `PagesLanguage` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` ON (`PagesLanguage`.`page_id` = `Page`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_languages` AS `Language` ON (`PagesLanguage`.`language_id` = `Language`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`PagesLanguage`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`PagesLanguage`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_pages_languages` AS `OriginPagesLanguage` ON (`PagesLanguage`.`page_id` = `OriginPagesLanguage`.`page_id` AND `OriginPagesLanguage`.`language_id` = 2) WHERE ((`PagesLanguage`.`language_id` = 2) OR (((`Space`.`is_m17n` = '0') AND (((`PagesLanguage`.`id` = `OriginPagesLanguage`.`id`) OR (`OriginPagesLanguage`.`id` IS NULL)))))) AND `Page`.`room_id` IN (1, 7, 9, 10, 11, 15) | 7 | 7 | 1 | maybe slow |
| SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`permalink`, `Page`.`slug`, `Page`.`is_container_fluid`, `Page`.`theme`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `ParentPage`.`id`, `ParentPage`.`room_id`, `ParentPage`.`root_id`, `ParentPage`.`parent_id`, `ParentPage`.`lft`, `ParentPage`.`rght`, `ParentPage`.`permalink`, `ParentPage`.`slug`, `ParentPage`.`is_container_fluid`, `ParentPage`.`theme`, `ParentPage`.`created_user`, `ParentPage`.`created`, `ParentPage`.`modified_user`, `ParentPage`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Space`.`id`, `Space`.`parent_id`, `Space`.`lft`, `Space`.`rght`, `Space`.`type`, `Space`.`plugin_key`, `Space`.`default_setting_action`, `Space`.`room_disk_size`, `Space`.`room_id_root`, `Space`.`page_id_top`, `Space`.`permalink`, `Space`.`is_m17n`, `Space`.`after_user_save_model`, `Space`.`created_user`, `Space`.`created`, `Space`.`modified_user`, `Space`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_pages` AS `ParentPage` ON (`Page`.`parent_id` = `ParentPage`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Page`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Page`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) WHERE `Page`.`id` IN (1, 4, 7, 13, 14, 15, 19) | 7 | 7 | 1 | maybe slow |
| SELECT `ChildPage`.`id`, `ChildPage`.`room_id`, `ChildPage`.`root_id`, `ChildPage`.`parent_id`, `ChildPage`.`lft`, `ChildPage`.`rght`, `ChildPage`.`permalink`, `ChildPage`.`slug`, `ChildPage`.`is_container_fluid`, `ChildPage`.`theme`, `ChildPage`.`created_user`, `ChildPage`.`created`, `ChildPage`.`modified_user`, `ChildPage`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `ChildPage` WHERE `ChildPage`.`parent_id` IN (7, 19, 13, 14, 15, 1, 4) | 6 | 6 | 0 | |
| SELECT `PageContainer`.`id`, `PageContainer`.`page_id`, `PageContainer`.`container_type`, `PageContainer`.`is_published`, `PageContainer`.`is_configured`, `PageContainer`.`created_user`, `PageContainer`.`created`, `PageContainer`.`modified_user`, `PageContainer`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_page_containers` AS `PageContainer` WHERE `PageContainer`.`page_id` IN (7, 19, 13, 14, 15, 1, 4) | 35 | 35 | 0 | |
| SELECT `Page`.`lft`, `Page`.`rght` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE `Page`.`id` = 15 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`permalink`, `Page`.`slug`, `Page`.`is_container_fluid`, `Page`.`theme`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE 1 = 1 AND `Page`.`lft` <= 10 AND `Page`.`rght` >= 11 ORDER BY `Page`.`lft` asc | 2 | 2 | 0 | |
| SELECT COUNT(*) AS `count` FROM `LAA0857082-chibagakudo`.`nc3_menu_frames_rooms` AS `MenuFramesRoom` WHERE `MenuFramesRoom`.`frame_key` = 'frame_2' | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `LAA0857082-chibagakudo`.`nc3_menu_frames_pages` AS `MenuFramesPage` WHERE `MenuFramesPage`.`frame_key` = 'frame_2' | 1 | 1 | 0 | |
| SELECT `Page`.`id`, `Page`.`lft`, `Page`.`rght` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_pages` AS `ParentPage` ON (`Page`.`parent_id` = `ParentPage`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Page`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Page`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_pages_languages` AS `PagesLanguage` ON (`PagesLanguage`.`page_id` = `Page`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_pages_languages` AS `OriginPagesLanguage` ON (`PagesLanguage`.`page_id` = `OriginPagesLanguage`.`page_id` AND `OriginPagesLanguage`.`language_id` = 2) WHERE ((`PagesLanguage`.`language_id` = 2) OR (((`Space`.`is_m17n` = '0') AND (((`PagesLanguage`.`id` = `OriginPagesLanguage`.`id`) OR (`OriginPagesLanguage`.`id` IS NULL)))))) AND `PagesLanguage`.`page_id` = `Page`.`id` AND `Page`.`room_id` IN (1, 7, 9, 10, 11, 15) AND 1 = 1 ORDER BY `Page`.`lft` asc | 7 | 7 | 0 | |
| SELECT `Page`.`lft`, `Page`.`rght` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE `Page`.`id` = 15 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`permalink`, `Page`.`slug`, `Page`.`is_container_fluid`, `Page`.`theme`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE 1 = 1 AND `Page`.`lft` <= 10 AND `Page`.`rght` >= 11 ORDER BY `Page`.`lft` asc | 2 | 2 | 0 |
25 duplicate queries run.
Peak Memory Use 21.80 MB
| Message | Memory use |
|---|---|
| Component initialization | 5.06 MB |
| Controller action start | 9.01 MB |
| Controller render start | 11.78 MB |
| Component initialization #2 | 14.43 MB |
| Controller action start #2 | 14.63 MB |
| Controller render start #2 | 15.08 MB |
| View render complete | 15.33 MB |
Total Request Time: 815 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 78.68 | |
| Event: Controller.initialize | 125.10 | |
| Event: Controller.startup | 5.01 | |
| Controller action | 106.43 | |
| Event: Controller.beforeRender | 72.46 | |
| » Processing toolbar data | 39.70 | |
| Rendering View | 321.37 | |
| » Event: View.beforeRender | 0.63 | |
| » Rendering APP/Plugin/Calendars/View/Calendars/daily.ctp | 229.24 | |
| » » Rendering APP/Plugin/Calendars/View/Elements/scripts.ctp | 0.52 | |
| » » Rendering APP/Plugin/Calendars/View/Elements/Calendars/calendar_tabs.ctp | 6.55 | |
| » » Rendering APP/Plugin/NetCommons/View/Elements/load_datetimepicker.ctp | 0.52 | |
| » » Rendering APP/Plugin/Calendars/View/Elements/Calendars/daily_tabs.ctp | 109.60 | |
| » » Rendering APP/Plugin/Calendars/View/Elements/Calendars/daily_list.ctp | 8.63 | |
| » Event: View.afterRender | 1.62 | |
| » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp | 1.00 | |
| » » Rendering APP/Plugin/Pages/View/Elements/page_main.ctp | 0.34 | |
| » Event: View.beforeLayout | 76.51 | |
| » » Rendering APP/Plugin/Pages/View/Elements/page_major.ctp | 76.28 | |
| » » » Rendering APP/Plugin/Boxes/View/Elements/render_boxes.ctp | 75.97 | |
| » » » » Rendering APP/Plugin/Frames/View/Elements/render_frames.ctp | 75.74 | |
| » » » » » Event: Controller.initialize #2 | 14.60 | |
| » » » » » Event: Controller.startup #2 | 0.61 | |
| » » » » » Controller action #2 | 22.82 | |
| » » » » » Event: Controller.beforeRender #2 | 27.77 | |
| » » » » » » Processing toolbar data #2 | 27.44 | |
| Rendering View #2 | 0.00 | |
| » » » » » » Event: View.beforeRender #2 | 0.34 | |
| » » » » » » Rendering APP/Plugin/Menus/View/Menus/index.ctp | 3.25 | |
| » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/major/index.ctp #2 | 3.00 | |
| » » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/major/list.ctp | 0.23 | |
| » » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/major/list.ctp #2 | 0.20 | |
| » » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/major/list.ctp #3 | 0.20 | |
| » » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/major/list.ctp #4 | 0.20 | |
| » » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/major/list.ctp #5 | 0.21 | |
| » » » » » » Event: View.afterRender #2 | 1.15 | |
| » » » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #2 | 0.41 | |
| » » » » » » » Rendering APP/Plugin/Pages/View/Elements/page_main.ctp #2 | 0.34 | |
| » » » » » » Event: Controller.shutdown | 0.06 | |
| » » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #3 | 0.28 | |
| » » Rendering APP/Plugin/Pages/View/Layouts/default.ctp | 8.79 | |
| » » » Rendering APP/Plugin/NetCommons/View/Elements/common_css.ctp | 0.65 | |
| » » » Rendering APP/Plugin/NetCommons/View/Elements/common_theme_css.ctp | 0.30 | |
| » » » Rendering APP/Plugin/NetCommons/View/Elements/common_js.ctp | 0.61 | |
| » » » Rendering APP/Plugin/Wysiwyg/View/Elements/mathjax_js.ctp | 0.32 | |
| » » » Rendering APP/Plugin/NetCommons/View/Elements/common_header.ctp | 5.12 | |
| » » » Rendering APP/Plugin/NetCommons/View/Elements/common_footer.ctp | 0.15 | |
| Event: View.afterLayout | 0.00 |
| Constant | Value |
|---|---|
| CONFIG | /home/users/2/hiho.jp-chibagakudo/web/app/Config/ |
| HTMLPURIFIER_PREFIX | /home/users/2/hiho.jp-chibagakudo/web/vendors/ezyang/htmlpurifier/library |
| Constant | Value |
|---|---|
| APP | /home/users/2/hiho.jp-chibagakudo/web/app/ |
| APP_DIR | app |
| APPLIBS | /home/users/2/hiho.jp-chibagakudo/web/app/Lib/ |
| CACHE | /home/users/2/hiho.jp-chibagakudo/web/app/tmp/cache/ |
| CAKE | /home/users/2/hiho.jp-chibagakudo/web/vendors/cakephp/cakephp/lib/Cake/ |
| CAKE_CORE_INCLUDE_PATH | /home/users/2/hiho.jp-chibagakudo/web/vendors/cakephp/cakephp/lib |
| CORE_PATH | /home/users/2/hiho.jp-chibagakudo/web/vendors/cakephp/cakephp/lib/ |
| CAKE_VERSION | 2.10.5 |
| CSS | /home/users/2/hiho.jp-chibagakudo/web/app/webroot/css/ |
| CSS_URL | css/ |
| DS | / |
| FULL_BASE_URL | http://chibagakudo.hiho.jp |
| IMAGES | /home/users/2/hiho.jp-chibagakudo/web/app/webroot/img/ |
| IMAGES_URL | img/ |
| JS | /home/users/2/hiho.jp-chibagakudo/web/app/webroot/js/ |
| JS_URL | js/ |
| LOGS | /home/users/2/hiho.jp-chibagakudo/web/app/tmp/logs/ |
| ROOT | /home/users/2/hiho.jp-chibagakudo/web |
| TESTS | /home/users/2/hiho.jp-chibagakudo/web/app/Test/ |
| TMP | /home/users/2/hiho.jp-chibagakudo/web/app/tmp/ |
| VENDORS | /home/users/2/hiho.jp-chibagakudo/web/vendors/ |
| WEBROOT_DIR | webroot |
| WWW_ROOT | /home/users/2/hiho.jp-chibagakudo/web/app/webroot/ |
| Environment Variable | Value |
|---|---|
| Php Version | 7.1.5 |
| Redirect Redirect Unique Id | XBEzGp0HalUAAB-f2oMAAABM |
| Redirect Redirect Mef Proxy Addr | 172.19.45.93 |
| Redirect Redirect Nss Sdb Use Cache | YES |
| Redirect Redirect Status | 200 |
| Redirect Unique Id | XBEzGp0HalUAAB-f2oMAAABM |
| Redirect Mef Proxy Addr | 172.19.45.93 |
| Redirect Nss Sdb Use Cache | YES |
| Redirect Status | 200 |
| Unique Id | XBEzGp0HalUAAB-f2oMAAABM |
| Mef Proxy Addr | 172.19.45.93 |
| Nss Sdb Use Cache | YES |
| Http Host | chibagakudo.hiho.jp |
| Http X Forwarded Host | chibagakudo.hiho.jp |
| Http X Forwarded For | 54.164.198.240 |
| Http X Forwarded Proto | http |
| Http User Agent | CCBot/2.0 (https://commoncrawl.org/faq/) |
| Http Accept | text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 |
| Http Accept Encoding | gzip |
| Path | /sbin:/usr/sbin:/bin:/usr/bin |
| Server Signature | |
| Server Software | Apache |
| Server Name | chibagakudo.hiho.jp |
| Server Addr | 172.19.46.85 |
| Server Port | 80 |
| Remote Addr | 54.164.198.240 |
| Document Root | /home/users/2/hiho.jp-chibagakudo/web |
| Request Scheme | http |
| Context Prefix | |
| Context Document Root | /home/users/2/hiho.jp-chibagakudo/web |
| Server Admin | https://lolipop.jp/support/ |
| Script Filename | /home/users/2/hiho.jp-chibagakudo/web/app/webroot/index.php |
| Remote Port | 50582 |
| Redirect Query String | year=2018&month=12&day=7&style=daily&tab=list&frame_id=17 |
| Redirect Url | /app/webroot/calendars/calendars/index |
| Gateway Interface | CGI/1.1 |
| Server Protocol | HTTP/1.1 |
| Request Method | GET |
| Query String | year=2018&month=12&day=7&style=daily&tab=list&frame_id=17 |
| Request Uri | /calendars/calendars/index?year=2018&month=12&day=7&style=daily&tab=list&frame_id=17 |
| Script Name | /app/webroot/index.php |
| Php Self | /app/webroot/index.php |
| Request Time Float | 1544631066.993 |
| Request Time | 1544631066 |