お問い合せ
当団地へ入居ご希望の方向けに、具体的な生活情報など可能な範囲でお答えします。
※販売・勧誘目的のお問い合せは受け付けておりません。
※居住者の方の意見・要望は本ページではなく『要望書』を管理組合窓口に提出してください。
以下の項目を入力して[決定]ボタンを押してください。
*印の項目は必須入力項目です。
お問い合せ
当団地へ入居ご希望の方向けに、具体的な生活情報など可能な範囲でお答えします。
※販売・勧誘目的のお問い合せは受け付けておりません。
※居住者の方の意見・要望は本ページではなく『要望書』を管理組合窓口に提出してください。
以下の項目を入力して[決定]ボタンを押してください。
*印の項目は必須入力項目です。
No post data.
No querystring data.
To view Cookies, add CookieComponent to Controller
| Query | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|
| SELECT COUNT(*) AS `count` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` INNER JOIN `hijiri3_hijirigaoka`.`rooms` AS `Room` ON (`Room`.`id` = `Page`.`room_id`) WHERE `Page`.`permalink` = 'page_20200422002638' AND `Room`.`space_id` = 2 | 1 | 1 | 0 | |
| SELECT `Page`.`weight` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE `Page`.`id` = 4 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Page`.`id`, `Page`.`room_id`, `PagesLanguage`.`language_id` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` LEFT JOIN `hijiri3_hijirigaoka`.`pages_languages` AS `PagesLanguage` ON (`PagesLanguage`.`page_id` = `Page`.`id`) INNER JOIN `hijiri3_hijirigaoka`.`rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) WHERE `Page`.`permalink` = 'page_20200422002638' AND `Room`.`space_id` = '2' | 1 | 1 | 0 | |
| SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`weight`, `Page`.`sort_key`, `Page`.`child_count`, `Page`.`permalink`, `Page`.`slug`, `Page`.`is_container_fluid`, `Page`.`theme` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE `Page`.`id` = 12 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`active`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` WHERE `id` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name` FROM `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` WHERE `room_id` = 1 AND `language_id` = 2 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PagesLanguage`.`id`, `PagesLanguage`.`language_id`, `PagesLanguage`.`page_id`, `PagesLanguage`.`name`, `PagesLanguage`.`meta_title`, `PagesLanguage`.`meta_description`, `PagesLanguage`.`meta_keywords`, `PagesLanguage`.`meta_robots` FROM `hijiri3_hijirigaoka`.`pages_languages` AS `PagesLanguage` WHERE `PagesLanguage`.`page_id` = 12 AND `PagesLanguage`.`language_id` = 2 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PluginsRoom`.`plugin_key` FROM `hijiri3_hijirigaoka`.`plugins_rooms` AS `PluginsRoom` WHERE `room_id` = 1 | 22 | 22 | 0 | |
| SELECT `BlockRolePermission`.`id`, `BlockRolePermission`.`roles_room_id`, `BlockRolePermission`.`block_key`, `BlockRolePermission`.`permission`, `BlockRolePermission`.`value` FROM `hijiri3_hijirigaoka`.`block_role_permissions` AS `BlockRolePermission` WHERE `block_key` IS NULL AND `roles_room_id` IS NULL | 0 | 0 | 0 | |
| SELECT `BlockSetting`.`block_key`, `BlockSetting`.`field_name`, `BlockSetting`.`value` FROM `hijiri3_hijirigaoka`.`block_settings` AS `BlockSetting` WHERE `room_id` = 1 AND `block_key` IS NULL AND `field_name` IN ('use_workflow', 'use_comment_approval') | 0 | 0 | 0 | |
| SELECT `PageContainer`.`id`, `PageContainer`.`page_id`, `PageContainer`.`container_type`, `PageContainer`.`is_published`, `PageContainer`.`is_configured` FROM `hijiri3_hijirigaoka`.`page_containers` AS `PageContainer` WHERE `PageContainer`.`page_id` = 12 | 5 | 5 | 0 | |
| SELECT `BoxesPageContainer`.`id`, `BoxesPageContainer`.`page_container_id`, `BoxesPageContainer`.`page_id`, `BoxesPageContainer`.`container_type`, `BoxesPageContainer`.`box_id`, `BoxesPageContainer`.`is_published`, `BoxesPageContainer`.`weight`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`weight`, `Room`.`sort_key`, `Room`.`child_count`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `RoomsLanguage`.`id`, `RoomsLanguage`.`name` FROM `hijiri3_hijirigaoka`.`boxes_page_containers` AS `BoxesPageContainer` INNER JOIN `hijiri3_hijirigaoka`.`boxes` AS `Box` ON (`Box`.`id` = `BoxesPageContainer`.`box_id`) INNER JOIN `hijiri3_hijirigaoka`.`rooms` AS `Room` ON (`Box`.`room_id` = `Room`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` ON (`RoomsLanguage`.`language_id` = '2' AND `Room`.`id` = `RoomsLanguage`.`room_id`) WHERE `BoxesPageContainer`.`page_container_id` IN (56, 57, 58, 59, 60) AND `BoxesPageContainer`.`is_published` = '1' ORDER BY `BoxesPageContainer`.`page_container_id` ASC, `BoxesPageContainer`.`weight` ASC | 5 | 5 | 1 | maybe slow |
| SELECT `Frame`.`id`, `Frame`.`room_id`, `Frame`.`box_id`, `Frame`.`plugin_key`, `Frame`.`block_id`, `Frame`.`key`, `Frame`.`header_type`, `Frame`.`weight`, `Frame`.`is_deleted`, `Frame`.`default_action`, `Frame`.`default_setting_action`, `FramePublicLanguage`.`id`, `FramePublicLanguage`.`language_id`, `FramePublicLanguage`.`frame_id`, `FramePublicLanguage`.`is_public`, `FramesLanguage`.`id`, `FramesLanguage`.`language_id`, `FramesLanguage`.`frame_id`, `FramesLanguage`.`name`, `FramesLanguage`.`is_origin`, `FramesLanguage`.`is_translation`, `FramesLanguage`.`is_original_copy`, `Block`.`id`, `Block`.`room_id`, `Block`.`plugin_key`, `Block`.`key`, `Block`.`public_type`, `Block`.`publish_start`, `Block`.`publish_end`, `Block`.`content_count`, `BlocksLanguage`.`language_id`, `BlocksLanguage`.`block_id`, `BlocksLanguage`.`name`, `BlocksLanguage`.`is_origin`, `BlocksLanguage`.`is_translation`, `BlocksLanguage`.`is_original_copy` FROM `hijiri3_hijirigaoka`.`frames` AS `Frame` INNER JOIN `hijiri3_hijirigaoka`.`frame_public_languages` AS `FramePublicLanguage` ON (`FramePublicLanguage`.`frame_id` = `Frame`.`id` AND `FramePublicLanguage`.`language_id` IN ('0', '2') AND `FramePublicLanguage`.`is_public` = '1') INNER JOIN `hijiri3_hijirigaoka`.`frames_languages` AS `FramesLanguage` ON (`FramesLanguage`.`frame_id` = `Frame`.`id` AND `FramesLanguage`.`language_id` = '2') LEFT JOIN `hijiri3_hijirigaoka`.`blocks` AS `Block` ON (`Frame`.`block_id` = `Block`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND `BlocksLanguage`.`language_id` = '2') WHERE `Frame`.`box_id` IN (17, 18, 107, 19, 45) AND `Frame`.`is_deleted` = '0' ORDER BY `Frame`.`box_id` ASC, `Frame`.`is_deleted` ASC, `Frame`.`weight` ASC | 5 | 5 | 1 | maybe slow |
| SELECT `Page`.`sort_key` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE `Page`.`id` = 12 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Page`.`id` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE 1 = 1 AND `Page`.`sort_key` IN ('~00000001', '~00000001-00000004') ORDER BY `Page`.`sort_key` asc | 2 | 2 | 0 | |
| SELECT `Page`.`theme` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE `id` IN (1, 12) AND `theme` IS NOT NULL ORDER BY `sort_key` desc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Page`.`id`, `Page`.`room_id`, `PagesLanguage`.`language_id` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` LEFT JOIN `hijiri3_hijirigaoka`.`pages_languages` AS `PagesLanguage` ON (`PagesLanguage`.`page_id` = `Page`.`id`) INNER JOIN `hijiri3_hijirigaoka`.`rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) WHERE `Page`.`permalink` = 'page_20200422002638' AND `Room`.`space_id` = '2' | 1 | 1 | 0 | |
| SELECT `BlockRolePermission`.`id`, `BlockRolePermission`.`roles_room_id`, `BlockRolePermission`.`block_key`, `BlockRolePermission`.`permission`, `BlockRolePermission`.`value` FROM `hijiri3_hijirigaoka`.`block_role_permissions` AS `BlockRolePermission` WHERE `block_key` = '11cb00565cdf3fe9ead5599ae1ddda60' AND `roles_room_id` IS NULL | 0 | 0 | 0 | |
| SELECT `Announcement`.`id`, `Announcement`.`language_id`, `Announcement`.`block_id`, `Announcement`.`key`, `Announcement`.`status`, `Announcement`.`is_active`, `Announcement`.`is_latest`, `Announcement`.`is_origin`, `Announcement`.`is_translation`, `Announcement`.`is_original_copy`, `Announcement`.`content`, `Announcement`.`created_user`, `Announcement`.`created`, `Announcement`.`modified_user`, `Announcement`.`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`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `BlocksLanguage`.`language_id`, `BlocksLanguage`.`block_id`, `BlocksLanguage`.`name`, `BlocksLanguage`.`is_origin`, `BlocksLanguage`.`is_translation`, `BlocksLanguage`.`is_original_copy` FROM `hijiri3_hijirigaoka`.`announcements` AS `Announcement` LEFT JOIN `hijiri3_hijirigaoka`.`blocks` AS `Block` ON (`Announcement`.`block_id` = `Block`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Announcement`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Announcement`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND `BlocksLanguage`.`language_id` = 2) WHERE `Block`.`id` = 34 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `BlockSetting`.`id`, `BlockSetting`.`plugin_key`, `BlockSetting`.`room_id`, `BlockSetting`.`block_key`, `BlockSetting`.`field_name`, `BlockSetting`.`value`, `BlockSetting`.`type` FROM `hijiri3_hijirigaoka`.`block_settings` AS `BlockSetting` WHERE `room_id` = 1 | 376 | 376 | 1 | |
| SELECT `BlockRolePermission`.`id`, `BlockRolePermission`.`roles_room_id`, `BlockRolePermission`.`block_key`, `BlockRolePermission`.`permission`, `BlockRolePermission`.`value` FROM `hijiri3_hijirigaoka`.`block_role_permissions` AS `BlockRolePermission` WHERE `block_key` = '7184bb0507150b6a25bdc1ec7bb58d79' AND `roles_room_id` IS NULL | 0 | 0 | 0 | |
| SELECT `Registration`.`id`, `Registration`.`key`, `Registration`.`language_id`, `Registration`.`is_origin`, `Registration`.`is_translation`, `Registration`.`is_original_copy`, `Registration`.`is_active`, `Registration`.`is_latest`, `Registration`.`block_id`, `Registration`.`status`, `Registration`.`title`, `Registration`.`title_icon`, `Registration`.`sub_title`, `Registration`.`answer_timing`, `Registration`.`answer_start_period`, `Registration`.`answer_end_period`, `Registration`.`is_no_member_allow`, `Registration`.`is_anonymity`, `Registration`.`is_key_pass_use`, `Registration`.`is_repeat_allow`, `Registration`.`is_total_show`, `Registration`.`total_show_timing`, `Registration`.`total_show_start_period`, `Registration`.`total_comment`, `Registration`.`is_image_authentication`, `Registration`.`thanks_content`, `Registration`.`is_open_mail_send`, `Registration`.`open_mail_subject`, `Registration`.`open_mail_body`, `Registration`.`is_answer_mail_send`, `Registration`.`reply_to`, `Registration`.`is_regist_user_send`, `Registration`.`registration_mail_subject`, `Registration`.`registration_mail_body`, `Registration`.`is_page_random`, `Registration`.`is_limit_number`, `Registration`.`limit_number`, `Registration`.`import_key`, `Registration`.`export_key`, `Registration`.`created_user`, `Registration`.`created`, `Registration`.`modified_user`, `Registration`.`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`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `hijiri3_hijirigaoka`.`registrations` AS `Registration` LEFT JOIN `hijiri3_hijirigaoka`.`blocks` AS `Block` ON (`Registration`.`block_id` = `Block`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Registration`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Registration`.`modified_user` = `TrackableUpdater`.`id`) WHERE `Registration`.`language_id` = 2 AND `Registration`.`is_active` = '1' AND `Registration`.`block_id` = 33 LIMIT 1 | 1 | 1 | 3 | maybe slow |
| SELECT `RegistrationPage`.`id`, `RegistrationPage`.`key`, `RegistrationPage`.`language_id`, `RegistrationPage`.`is_origin`, `RegistrationPage`.`is_translation`, `RegistrationPage`.`is_original_copy`, `RegistrationPage`.`registration_id`, `RegistrationPage`.`page_title`, `RegistrationPage`.`route_number`, `RegistrationPage`.`page_sequence`, `RegistrationPage`.`created_user`, `RegistrationPage`.`created`, `RegistrationPage`.`modified_user`, `RegistrationPage`.`modified` FROM `hijiri3_hijirigaoka`.`registration_pages` AS `RegistrationPage` WHERE `RegistrationPage`.`registration_id` = (21) ORDER BY `page_sequence` ASC | 1 | 1 | 0 | |
| SELECT `AuthorizationKey`.`id`, `AuthorizationKey`.`model`, `AuthorizationKey`.`content_id`, `AuthorizationKey`.`additional_id`, `AuthorizationKey`.`authorization_key`, `AuthorizationKey`.`created_user`, `AuthorizationKey`.`created`, `AuthorizationKey`.`modified_user`, `AuthorizationKey`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `hijiri3_hijirigaoka`.`authorization_keys` AS `AuthorizationKey` LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`AuthorizationKey`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`AuthorizationKey`.`modified_user` = `TrackableUpdater`.`id`) WHERE `AuthorizationKey`.`model` = 'Registration' AND `AuthorizationKey`.`content_id` = 21 AND `AuthorizationKey`.`additional_id` IS NULL LIMIT 1 | 0 | 0 | 0 | |
| SELECT `RegistrationPage`.`id`, `RegistrationPage`.`key`, `RegistrationPage`.`registration_id` FROM `hijiri3_hijirigaoka`.`registration_pages` AS `RegistrationPage` WHERE `id` = 21 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Registration`.`id`, `Registration`.`key`, `Registration`.`is_active`, `Registration`.`is_latest` FROM `hijiri3_hijirigaoka`.`registrations` AS `Registration` WHERE `id` = 21 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Registration`.`id` FROM `hijiri3_hijirigaoka`.`registrations` AS `Registration` WHERE `key` = 'a55a5862445187953f9d72ea6d4818df' AND `is_latest` = '1' | 1 | 1 | 0 | |
| SELECT `RegistrationPage`.`id` FROM `hijiri3_hijirigaoka`.`registration_pages` AS `RegistrationPage` WHERE registration_id = (21) AND `key` = 'c5fd358c838486784fb21f8211d1189a' | 1 | 1 | 0 | |
| SELECT `RegistrationQuestion`.`id`, `RegistrationQuestion`.`key`, `RegistrationQuestion`.`language_id`, `RegistrationQuestion`.`is_origin`, `RegistrationQuestion`.`is_translation`, `RegistrationQuestion`.`is_original_copy`, `RegistrationQuestion`.`question_sequence`, `RegistrationQuestion`.`question_value`, `RegistrationQuestion`.`question_type`, `RegistrationQuestion`.`description`, `RegistrationQuestion`.`is_require`, `RegistrationQuestion`.`question_type_option`, `RegistrationQuestion`.`is_choice_random`, `RegistrationQuestion`.`is_choice_horizon`, `RegistrationQuestion`.`is_skip`, `RegistrationQuestion`.`is_jump`, `RegistrationQuestion`.`is_range`, `RegistrationQuestion`.`min`, `RegistrationQuestion`.`max`, `RegistrationQuestion`.`is_result_display`, `RegistrationQuestion`.`result_display_type`, `RegistrationQuestion`.`registration_page_id`, `RegistrationQuestion`.`created_user`, `RegistrationQuestion`.`created`, `RegistrationQuestion`.`modified_user`, `RegistrationQuestion`.`modified`, `RegistrationPage`.`id`, `RegistrationPage`.`key`, `RegistrationPage`.`language_id`, `RegistrationPage`.`is_origin`, `RegistrationPage`.`is_translation`, `RegistrationPage`.`is_original_copy`, `RegistrationPage`.`registration_id`, `RegistrationPage`.`page_title`, `RegistrationPage`.`route_number`, `RegistrationPage`.`page_sequence`, `RegistrationPage`.`created_user`, `RegistrationPage`.`created`, `RegistrationPage`.`modified_user`, `RegistrationPage`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `hijiri3_hijirigaoka`.`registration_questions` AS `RegistrationQuestion` LEFT JOIN `hijiri3_hijirigaoka`.`registration_pages` AS `RegistrationPage` ON (`RegistrationQuestion`.`registration_page_id` = `RegistrationPage`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`RegistrationQuestion`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`RegistrationQuestion`.`modified_user` = `TrackableUpdater`.`id`) WHERE registration_page_id = (21) AND ((`RegistrationQuestion`.`language_id` = 2) OR (`RegistrationQuestion`.`is_translation` = '0')) ORDER BY `question_sequence` asc | 4 | 4 | 2 | maybe slow |
| SELECT `RegistrationChoice`.`id`, `RegistrationChoice`.`key`, `RegistrationChoice`.`language_id`, `RegistrationChoice`.`is_origin`, `RegistrationChoice`.`is_translation`, `RegistrationChoice`.`is_original_copy`, `RegistrationChoice`.`matrix_type`, `RegistrationChoice`.`other_choice_type`, `RegistrationChoice`.`choice_sequence`, `RegistrationChoice`.`choice_label`, `RegistrationChoice`.`choice_value`, `RegistrationChoice`.`skip_page_sequence`, `RegistrationChoice`.`jump_route_number`, `RegistrationChoice`.`graph_color`, `RegistrationChoice`.`registration_question_id`, `RegistrationChoice`.`created_user`, `RegistrationChoice`.`created`, `RegistrationChoice`.`modified_user`, `RegistrationChoice`.`modified` FROM `hijiri3_hijirigaoka`.`registration_choices` AS `RegistrationChoice` WHERE `RegistrationChoice`.`registration_question_id` IN (85, 86, 87, 88) | 0 | 0 | 0 | |
| SELECT COUNT(*) AS `count` FROM `hijiri3_hijirigaoka`.`registration_answer_summaries` AS `RegistrationAnswerSummary` WHERE `registration_key` = 'a55a5862445187953f9d72ea6d4818df' AND `answer_status` = 2 AND `test_status` = 0 | 1 | 1 | 0 | |
| SELECT `AuthorizationKey`.`id`, `AuthorizationKey`.`model`, `AuthorizationKey`.`content_id`, `AuthorizationKey`.`additional_id`, `AuthorizationKey`.`authorization_key`, `AuthorizationKey`.`created_user`, `AuthorizationKey`.`created`, `AuthorizationKey`.`modified_user`, `AuthorizationKey`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `hijiri3_hijirigaoka`.`authorization_keys` AS `AuthorizationKey` LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`AuthorizationKey`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`AuthorizationKey`.`modified_user` = `TrackableUpdater`.`id`) WHERE `AuthorizationKey`.`model` = 'Registration' AND `AuthorizationKey`.`content_id` = 0 AND `AuthorizationKey`.`additional_id` IS NULL LIMIT 1 | 0 | 0 | 1 | maybe slow |
| SELECT `BlockRolePermission`.`id`, `BlockRolePermission`.`roles_room_id`, `BlockRolePermission`.`block_key`, `BlockRolePermission`.`permission`, `BlockRolePermission`.`value` FROM `hijiri3_hijirigaoka`.`block_role_permissions` AS `BlockRolePermission` WHERE `block_key` = '88c0fad06667a1dcc80da1361cf5b202' AND `roles_room_id` IS NULL | 0 | 0 | 0 | |
| SELECT `Announcement`.`id`, `Announcement`.`language_id`, `Announcement`.`block_id`, `Announcement`.`key`, `Announcement`.`status`, `Announcement`.`is_active`, `Announcement`.`is_latest`, `Announcement`.`is_origin`, `Announcement`.`is_translation`, `Announcement`.`is_original_copy`, `Announcement`.`content`, `Announcement`.`created_user`, `Announcement`.`created`, `Announcement`.`modified_user`, `Announcement`.`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`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `BlocksLanguage`.`language_id`, `BlocksLanguage`.`block_id`, `BlocksLanguage`.`name`, `BlocksLanguage`.`is_origin`, `BlocksLanguage`.`is_translation`, `BlocksLanguage`.`is_original_copy` FROM `hijiri3_hijirigaoka`.`announcements` AS `Announcement` LEFT JOIN `hijiri3_hijirigaoka`.`blocks` AS `Block` ON (`Announcement`.`block_id` = `Block`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Announcement`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Announcement`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND `BlocksLanguage`.`language_id` = 2) WHERE `Block`.`id` = 41 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Room`.`id`, `Room`.`page_id_top` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 1 | |
| SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`weight`, `Page`.`sort_key`, `Page`.`child_count`, `Page`.`permalink`, `PagesLanguage`.`page_id`, `PagesLanguage`.`name`, `MenuFramesPage`.`id`, `MenuFramesPage`.`page_id`, `MenuFramesPage`.`folder_type`, `MenuFramesPage`.`is_hidden` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` INNER JOIN `hijiri3_hijirigaoka`.`rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) INNER JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) INNER JOIN `hijiri3_hijirigaoka`.`pages_languages` AS `PagesLanguage` ON (`Page`.`id` = PagesLanguage .page_id) LEFT JOIN `hijiri3_hijirigaoka`.`menu_frames_pages` AS `MenuFramesPage` ON (`Page`.`id` = MenuFramesPage .page_id AND `MenuFramesPage`.`frame_key` = '29b46e9c15a12b52ecfa412c120234e8') LEFT JOIN `hijiri3_hijirigaoka`.`pages_languages` AS `OriginPagesLanguage` ON (`PagesLanguage`.`page_id` = `OriginPagesLanguage`.`page_id` AND `OriginPagesLanguage`.`language_id` = '2') WHERE `Page`.`room_id` = (1) AND ((`PagesLanguage`.`language_id` = '2') OR (((`Space`.`is_m17n` = '0') AND (((`PagesLanguage`.`id` = `OriginPagesLanguage`.`id`) OR (`OriginPagesLanguage`.`id` IS NULL)))))) AND `Page`.`id` = PagesLanguage .page_id ORDER BY `Page`.`sort_key` asc | 29 | 29 | 1 | |
| SELECT `MenuFrameSetting`.`id`, `MenuFrameSetting`.`frame_key`, `MenuFrameSetting`.`display_type`, `MenuFrameSetting`.`is_private_room_hidden`, `MenuFrameSetting`.`created_user`, `MenuFrameSetting`.`created`, `MenuFrameSetting`.`modified_user`, `MenuFrameSetting`.`modified` FROM `hijiri3_hijirigaoka`.`menu_frame_settings` AS `MenuFrameSetting` WHERE `frame_key` = '29b46e9c15a12b52ecfa412c120234e8' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `MenuFramesRoom`.`id`, `MenuFramesRoom`.`room_id`, `MenuFramesRoom`.`is_hidden` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` INNER JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) INNER JOIN `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` ON (`Room`.`id` = RoomsLanguage .room_id AND ((`RoomsLanguage`.`language_id` = '2') OR (`Space`.`is_m17n` = '0'))) LEFT JOIN `hijiri3_hijirigaoka`.`menu_frames_rooms` AS `MenuFramesRoom` ON (`Room`.`id` = MenuFramesRoom .room_id AND `MenuFramesRoom`.`frame_key` = '29b46e9c15a12b52ecfa412c120234e8') LEFT JOIN `hijiri3_hijirigaoka`.`rooms_languages` AS `OriginRoomsLanguage` ON (`RoomsLanguage`.`room_id` = `OriginRoomsLanguage`.`room_id` AND `OriginRoomsLanguage`.`language_id` = '2') WHERE `Room`.`id` = (1) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`id` = RoomsLanguage .room_id AND ((`RoomsLanguage`.`language_id` = 2) OR (((`Space`.`is_m17n` = '0') AND (((`RoomsLanguage`.`id` = `OriginRoomsLanguage`.`id`) OR (`OriginRoomsLanguage`.`id` IS NULL)))))) ORDER BY `Room`.`sort_key` asc | 1 | 1 | 1 | |
| SELECT `PagesLanguage`.`page_id`, `PagesLanguage`.`language_id`, `PagesLanguage`.`name` FROM `hijiri3_hijirigaoka`.`pages_languages` AS `PagesLanguage` LEFT JOIN `hijiri3_hijirigaoka`.`pages` AS `Page` ON (`PagesLanguage`.`page_id` = `Page`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`languages` AS `Language` ON (`PagesLanguage`.`language_id` = `Language`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`PagesLanguage`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`PagesLanguage`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`pages_languages` AS `OriginPagesLanguage` ON (`PagesLanguage`.`page_id` = `OriginPagesLanguage`.`page_id` AND `OriginPagesLanguage`.`language_id` = 2) WHERE ((`PagesLanguage`.`language_id` = 2) OR (((`Space`.`is_m17n` = '0') AND (((`PagesLanguage`.`id` = `OriginPagesLanguage`.`id`) OR (`OriginPagesLanguage`.`id` IS NULL)))))) AND `Page`.`room_id` = (1) | 29 | 29 | 1 | |
| SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`weight`, `Page`.`sort_key`, `Page`.`child_count`, `Page`.`permalink`, `Page`.`slug`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Space`.`id`, `Space`.`permalink` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`pages` AS `ParentPage` ON (`Page`.`parent_id` = `ParentPage`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Page`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Page`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) WHERE `Page`.`id` IN (1, 4, 8, 9, 12, 13, 21, 158, 162, 163, 179, 198, 201, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 227, 251, 252, 279, 288, 289) | 29 | 29 | 1 | |
| SELECT `ChildPage`.`id`, `ChildPage`.`room_id`, `ChildPage`.`root_id`, `ChildPage`.`parent_id`, `ChildPage`.`lft`, `ChildPage`.`rght`, `ChildPage`.`weight`, `ChildPage`.`sort_key`, `ChildPage`.`child_count`, `ChildPage`.`permalink`, `ChildPage`.`slug`, `ChildPage`.`is_container_fluid`, `ChildPage`.`theme`, `ChildPage`.`created_user`, `ChildPage`.`created`, `ChildPage`.`modified_user`, `ChildPage`.`modified` FROM `hijiri3_hijirigaoka`.`pages` AS `ChildPage` WHERE `ChildPage`.`parent_id` IN (1, 4, 8, 9, 12, 13, 21, 158, 162, 163, 179, 198, 201, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 227, 251, 252, 279, 288, 289) | 28 | 28 | 1 | |
| SELECT `Page`.`sort_key` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE `Page`.`id` = 12 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`weight`, `Page`.`sort_key`, `Page`.`child_count`, `Page`.`permalink`, `Page`.`slug`, `Page`.`is_container_fluid`, `Page`.`theme`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE 1 = 1 AND `Page`.`sort_key` IN ('~00000001', '~00000001-00000004') ORDER BY `Page`.`sort_key` asc | 2 | 2 | 0 | |
| SELECT COUNT(*) AS `count` FROM `hijiri3_hijirigaoka`.`menu_frames_rooms` AS `MenuFramesRoom` WHERE `MenuFramesRoom`.`frame_key` = '29b46e9c15a12b52ecfa412c120234e8' | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `hijiri3_hijirigaoka`.`menu_frames_pages` AS `MenuFramesPage` WHERE `MenuFramesPage`.`frame_key` = '29b46e9c15a12b52ecfa412c120234e8' | 1 | 1 | 0 | |
| SELECT `Page`.`id`, `Page`.`parent_id` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`pages` AS `ParentPage` ON (`Page`.`parent_id` = `ParentPage`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Page`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Page`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`pages_languages` AS `PagesLanguage` ON (`PagesLanguage`.`page_id` = `Page`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`pages_languages` AS `OriginPagesLanguage` ON (`PagesLanguage`.`page_id` = `OriginPagesLanguage`.`page_id` AND `OriginPagesLanguage`.`language_id` = 2) WHERE ((`PagesLanguage`.`language_id` = 2) OR (((`Space`.`is_m17n` = '0') AND (((`PagesLanguage`.`id` = `OriginPagesLanguage`.`id`) OR (`OriginPagesLanguage`.`id` IS NULL)))))) AND `PagesLanguage`.`page_id` = `Page`.`id` AND `Page`.`room_id` = (1) AND 1 = 1 ORDER BY `Page`.`sort_key` asc | 29 | 29 | 1 | |
| SELECT `Page`.`sort_key` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE `Page`.`id` = 12 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`weight`, `Page`.`sort_key`, `Page`.`child_count`, `Page`.`permalink`, `Page`.`slug`, `Page`.`is_container_fluid`, `Page`.`theme`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE 1 = 1 AND `Page`.`sort_key` IN ('~00000001', '~00000001-00000004') ORDER BY `Page`.`sort_key` asc | 2 | 2 | 0 | |
| SELECT `Room`.`id`, `Room`.`page_id_top` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `hijiri3_hijirigaoka`.`roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`sort_key` ASC | 1 | 1 | 1 | |
| SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`weight`, `Page`.`sort_key`, `Page`.`child_count`, `Page`.`permalink`, `PagesLanguage`.`page_id`, `PagesLanguage`.`name`, `MenuFramesPage`.`id`, `MenuFramesPage`.`page_id`, `MenuFramesPage`.`folder_type`, `MenuFramesPage`.`is_hidden` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` INNER JOIN `hijiri3_hijirigaoka`.`rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) INNER JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) INNER JOIN `hijiri3_hijirigaoka`.`pages_languages` AS `PagesLanguage` ON (`Page`.`id` = PagesLanguage .page_id) LEFT JOIN `hijiri3_hijirigaoka`.`menu_frames_pages` AS `MenuFramesPage` ON (`Page`.`id` = MenuFramesPage .page_id AND `MenuFramesPage`.`frame_key` = '46fab914d6e8b3cc82880a3ec1d1d5c7') LEFT JOIN `hijiri3_hijirigaoka`.`pages_languages` AS `OriginPagesLanguage` ON (`PagesLanguage`.`page_id` = `OriginPagesLanguage`.`page_id` AND `OriginPagesLanguage`.`language_id` = '2') WHERE `Page`.`room_id` = (1) AND ((`PagesLanguage`.`language_id` = 2) OR (((`Space`.`is_m17n` = '0') AND (((`PagesLanguage`.`id` = `OriginPagesLanguage`.`id`) OR (`OriginPagesLanguage`.`id` IS NULL)))))) AND `Page`.`id` = PagesLanguage .page_id ORDER BY `Page`.`sort_key` asc | 29 | 29 | 1 | |
| SELECT `MenuFrameSetting`.`id`, `MenuFrameSetting`.`frame_key`, `MenuFrameSetting`.`display_type`, `MenuFrameSetting`.`is_private_room_hidden`, `MenuFrameSetting`.`created_user`, `MenuFrameSetting`.`created`, `MenuFrameSetting`.`modified_user`, `MenuFrameSetting`.`modified` FROM `hijiri3_hijirigaoka`.`menu_frame_settings` AS `MenuFrameSetting` WHERE `frame_key` = '46fab914d6e8b3cc82880a3ec1d1d5c7' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `MenuFramesRoom`.`id`, `MenuFramesRoom`.`room_id`, `MenuFramesRoom`.`is_hidden` FROM `hijiri3_hijirigaoka`.`rooms` AS `Room` INNER JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) INNER JOIN `hijiri3_hijirigaoka`.`rooms_languages` AS `RoomsLanguage` ON (`Room`.`id` = RoomsLanguage .room_id AND ((`RoomsLanguage`.`language_id` = '2') OR (`Space`.`is_m17n` = '0'))) LEFT JOIN `hijiri3_hijirigaoka`.`menu_frames_rooms` AS `MenuFramesRoom` ON (`Room`.`id` = MenuFramesRoom .room_id AND `MenuFramesRoom`.`frame_key` = '46fab914d6e8b3cc82880a3ec1d1d5c7') LEFT JOIN `hijiri3_hijirigaoka`.`rooms_languages` AS `OriginRoomsLanguage` ON (`RoomsLanguage`.`room_id` = `OriginRoomsLanguage`.`room_id` AND `OriginRoomsLanguage`.`language_id` = '2') WHERE `Room`.`id` = (1) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`id` = RoomsLanguage .room_id AND ((`RoomsLanguage`.`language_id` = 2) OR (((`Space`.`is_m17n` = '0') AND (((`RoomsLanguage`.`id` = `OriginRoomsLanguage`.`id`) OR (`OriginRoomsLanguage`.`id` IS NULL)))))) ORDER BY `Room`.`sort_key` asc | 1 | 1 | 0 | |
| SELECT `Page`.`sort_key` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE `Page`.`id` = 12 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`weight`, `Page`.`sort_key`, `Page`.`child_count`, `Page`.`permalink`, `Page`.`slug`, `Page`.`is_container_fluid`, `Page`.`theme`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE 1 = 1 AND `Page`.`sort_key` IN ('~00000001', '~00000001-00000004') ORDER BY `Page`.`sort_key` asc | 2 | 2 | 0 | |
| SELECT COUNT(*) AS `count` FROM `hijiri3_hijirigaoka`.`menu_frames_rooms` AS `MenuFramesRoom` WHERE `MenuFramesRoom`.`frame_key` = '46fab914d6e8b3cc82880a3ec1d1d5c7' | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `hijiri3_hijirigaoka`.`menu_frames_pages` AS `MenuFramesPage` WHERE `MenuFramesPage`.`frame_key` = '46fab914d6e8b3cc82880a3ec1d1d5c7' | 1 | 1 | 0 | |
| SELECT `Page`.`id`, `Page`.`parent_id` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`pages` AS `ParentPage` ON (`Page`.`parent_id` = `ParentPage`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Page`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Page`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`pages_languages` AS `PagesLanguage` ON (`PagesLanguage`.`page_id` = `Page`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`pages_languages` AS `OriginPagesLanguage` ON (`PagesLanguage`.`page_id` = `OriginPagesLanguage`.`page_id` AND `OriginPagesLanguage`.`language_id` = 2) WHERE ((`PagesLanguage`.`language_id` = 2) OR (((`Space`.`is_m17n` = '0') AND (((`PagesLanguage`.`id` = `OriginPagesLanguage`.`id`) OR (`OriginPagesLanguage`.`id` IS NULL)))))) AND `PagesLanguage`.`page_id` = `Page`.`id` AND `Page`.`room_id` = (1) AND 1 = 1 ORDER BY `Page`.`sort_key` asc | 29 | 29 | 2 | maybe slow |
| SELECT `Page`.`sort_key` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE `Page`.`id` = 12 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`weight`, `Page`.`sort_key`, `Page`.`child_count`, `Page`.`permalink`, `Page`.`slug`, `Page`.`is_container_fluid`, `Page`.`theme`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE 1 = 1 AND `Page`.`sort_key` IN ('~00000001', '~00000001-00000004') ORDER BY `Page`.`sort_key` asc | 2 | 2 | 0 |
10 duplicate queries run.
Peak Memory Use 83.69 MB
| Message | Memory use |
|---|---|
| Component initialization | 3.35 MB |
| Controller action start | 3.62 MB |
| Controller render start | 13.70 MB |
| Component initialization #2 | 14.21 MB |
| Controller action start #2 | 14.25 MB |
| Controller render start #2 | 25.40 MB |
| Component initialization #3 | 25.61 MB |
| Controller action start #3 | 26.17 MB |
| Controller render start #3 | 36.32 MB |
| Component initialization #4 | 36.91 MB |
| Controller action start #4 | 36.92 MB |
| Controller render start #4 | 47.02 MB |
| Component initialization #5 | 47.18 MB |
| Controller action start #5 | 47.34 MB |
| Controller render start #5 | 57.79 MB |
| Component initialization #6 | 57.95 MB |
| Controller action start #6 | 58.02 MB |
| Controller render start #6 | 68.15 MB |
| View render complete | 68.25 MB |
Total Request Time: 599 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 75.05 | |
| Event: Controller.initialize | 11.72 | |
| Event: Controller.startup | 1.16 | |
| Controller action | 1.91 | |
| Event: Controller.beforeRender | 41.06 | |
| » Processing toolbar data | 39.71 | |
| Rendering View | 378.62 | |
| » Event: View.beforeRender | 0.61 | |
| » Rendering APP/Plugin/Pages/View/Pages/index.ctp | 174.66 | |
| » » Rendering APP/Plugin/Boxes/View/Elements/render_boxes.ctp | 174.29 | |
| » » » Rendering APP/Plugin/Frames/View/Elements/render_frames.ctp | 173.96 | |
| » » » » Event: Controller.initialize #2 | 1.37 | |
| » » » » Event: Controller.startup #2 | 0.54 | |
| » » » » Controller action #2 | 25.39 | |
| » » » » Event: Controller.beforeRender #2 | 43.35 | |
| » » » » » Processing toolbar data #2 | 43.04 | |
| Rendering View #2 | 0.00 | |
| » » » » » Event: View.beforeRender #2 | 0.30 | |
| » » » » » Rendering APP/Plugin/Announcements/View/Announcements/view.ctp | 0.12 | |
| » » » » » Event: View.afterRender | 0.61 | |
| » » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp | 0.15 | |
| » » » » » » Rendering APP/Plugin/Pages/View/Elements/page_main.ctp | 0.12 | |
| » » » » » Event: Controller.shutdown | 0.08 | |
| » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #2 | 0.09 | |
| » » » » » Event: Controller.initialize #3 | 32.13 | |
| » » » » » Event: Controller.startup #3 | 1.41 | |
| » » » » » Controller action #3 | 4.22 | |
| » » » » » Event: Controller.beforeRender #3 | 47.82 | |
| » » » » » » Processing toolbar data #3 | 47.51 | |
| Rendering View #3 | 0.00 | |
| » » » » » » Event: View.beforeRender #3 | 0.32 | |
| » » » » » » Rendering APP/Plugin/Registrations/View/RegistrationAnswers/view.ctp #2 | 9.60 | |
| » » » » » » » Rendering APP/Plugin/Registrations/View/Elements/scripts.ctp | 2.84 | |
| » » » » » » » Rendering APP/Plugin/Registrations/View/Elements/Answers/answer_header.ctp | 0.36 | |
| » » » » » » » Rendering APP/Plugin/Registrations/View/Elements/Answers/answer_test_mode_header.ctp | 0.12 | |
| » » » » » » » Rendering APP/Plugin/NetCommons/View/Elements/required.ctp | 0.11 | |
| » » » » » » » Rendering APP/Plugin/NetCommons/View/Elements/required.ctp #2 | 0.08 | |
| » » » » » » » Rendering APP/Plugin/NetCommons/View/Elements/required.ctp #3 | 0.08 | |
| » » » » » » Event: View.afterRender #2 | 0.59 | |
| » » » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #3 | 0.15 | |
| » » » » » » » Rendering APP/Plugin/Pages/View/Elements/page_main.ctp #2 | 0.10 | |
| » » » » » » Event: Controller.shutdown #2 | 0.08 | |
| » » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #4 | 0.09 | |
| » » » Event: View.afterRender #3 | 0.27 | |
| » » » » Rendering APP/Plugin/Pages/View/Elements/page_main.ctp #3 | 0.10 | |
| » » » Event: View.beforeLayout | 198.27 | |
| » » » » Rendering APP/Plugin/Pages/View/Elements/page_header.ctp | 198.01 | |
| » » » » » Rendering APP/Plugin/Boxes/View/Elements/render_boxes.ctp #2 | 197.83 | |
| » » » » » » Rendering APP/Plugin/Frames/View/Elements/render_frames.ctp #2 | 197.66 | |
| » » » » » » » Event: Controller.initialize #4 | 1.46 | |
| » » » » » » » Event: Controller.startup #4 | 0.41 | |
| » » » » » » » Controller action #4 | 2.39 | |
| » » » » » » » Event: Controller.beforeRender #4 | 53.67 | |
| » » » » » » » » Processing toolbar data #4 | 53.37 | |
| Rendering View #4 | 0.00 | |
| » » » » » » » » Event: View.beforeRender #4 | 0.14 | |
| » » » » » » » » Rendering APP/Plugin/Announcements/View/Announcements/view.ctp #3 | 0.09 | |
| » » » » » » » » Event: View.afterRender #4 | 0.58 | |
| » » » » » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #5 | 0.14 | |
| » » » » » » » » » Rendering APP/Plugin/Pages/View/Elements/page_main.ctp #4 | 0.10 | |
| » » » » » » » » Event: Controller.shutdown #3 | 0.07 | |
| » » » » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #6 | 0.09 | |
| » » » » » » » » Event: Controller.initialize #5 | 7.38 | |
| » » » » » » » » Event: Controller.startup #5 | 0.45 | |
| » » » » » » » » Controller action #5 | 18.12 | |
| » » » » » » » » Event: Controller.beforeRender #5 | 45.76 | |
| » » » » » » » » » Processing toolbar data #5 | 45.43 | |
| Rendering View #5 | 0.00 | |
| » » » » » » » » » Event: View.beforeRender #5 | 0.14 | |
| » » » » » » » » » Rendering APP/Plugin/Menus/View/Menus/index.ctp #2 | 0.10 | |
| » » » » » » » » » Event: View.afterRender #5 | 0.63 | |
| » » » » » » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #7 | 0.15 | |
| » » » » » » » » » » Rendering APP/Plugin/Pages/View/Elements/page_main.ctp #5 | 0.12 | |
| » » » » » » » » » Event: Controller.shutdown #4 | 0.07 | |
| » » » » » » » » » Event: Controller.initialize #6 | 4.60 | |
| » » » » » » » » » Event: Controller.startup #6 | 0.47 | |
| » » » » » » » » » Controller action #6 | 8.60 | |
| » » » » » » » » » Event: Controller.beforeRender #6 | 42.68 | |
| » » » » » » » » » » Processing toolbar data #6 | 42.34 | |
| Rendering View #6 | 0.00 | |
| » » » » » » » » » » Event: View.beforeRender #6 | 0.12 | |
| » » » » » » » » » » Rendering APP/Plugin/Menus/View/Menus/index.ctp #3 | 1.42 | |
| » » » » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/topic_path/index.ctp #4 | 0.93 | |
| » » » » » » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/topic_path/list.ctp | 0.14 | |
| » » » » » » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/topic_path/list.ctp #2 | 0.06 | |
| » » » » » » » » » » Event: View.afterRender #6 | 0.62 | |
| » » » » » » » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #8 | 0.14 | |
| » » » » » » » » » » » Rendering APP/Plugin/Pages/View/Elements/page_main.ctp #6 | 0.12 | |
| » » » » » » » » » » Event: Controller.shutdown #5 | 0.07 | |
| » » » » » » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #9 | 0.09 | |
| » » » » » » Rendering APP/Plugin/Pages/View/Layouts/default.ctp | 3.97 | |
| » » » » » » » Rendering APP/Plugin/NetCommons/View/Elements/common_favicon.ctp | 0.24 | |
| » » » » » » » Rendering APP/Plugin/NetCommons/View/Elements/common_css.ctp | 0.80 | |
| » » » » » » » Rendering APP/Plugin/NetCommons/View/Elements/common_theme_css.ctp | 0.25 | |
| » » » » » » » Rendering APP/Plugin/NetCommons/View/Elements/common_js.ctp | 0.70 | |
| » » » » » » » Rendering APP/Plugin/Wysiwyg/View/Elements/mathjax_js.ctp | 0.22 | |
| » » » » » » » Rendering APP/Plugin/NetCommons/View/Elements/common_header.ctp | 0.58 | |
| » » » » » » » Rendering APP/Plugin/NetCommons/View/Elements/common_footer.ctp | 0.10 | |
| Event: View.afterLayout | 0.00 |
| Constant | Value |
|---|---|
| UPLOADS_ROOT | '/home/hijiri3/www/nc3/app/Uploads/' |
| CONFIG | '/home/hijiri3/www/nc3/app/Config/' |
| HTMLPURIFIER_PREFIX | '/home/hijiri3/www/nc3/vendors/ezyang/htmlpurifier/library' |
| NC3_VERSION | '3.3.4' |
| Constant | Value |
|---|---|
| APP | '/home/hijiri3/www/nc3/app/' |
| APP_DIR | 'app' |
| APPLIBS | '/home/hijiri3/www/nc3/app/Lib/' |
| CACHE | '/home/hijiri3/www/nc3/app/tmp/cache/' |
| CAKE | '/home/hijiri3/www/nc3/vendors/cakephp/cakephp/lib/Cake/' |
| CAKE_CORE_INCLUDE_PATH | '/home/hijiri3/www/nc3/vendors/cakephp/cakephp/lib' |
| CORE_PATH | '/home/hijiri3/www/nc3/vendors/cakephp/cakephp/lib/' |
| CAKE_VERSION | '2.10.24' |
| CSS | '/home/hijiri3/www/nc3/app/webroot/css/' |
| CSS_URL | 'css/' |
| DS | '/' |
| FULL_BASE_URL | 'http://hijirigaoka.org' |
| IMAGES | '/home/hijiri3/www/nc3/app/webroot/img/' |
| IMAGES_URL | 'img/' |
| JS | '/home/hijiri3/www/nc3/app/webroot/js/' |
| JS_URL | 'js/' |
| LOGS | '/home/hijiri3/www/nc3/app/tmp/logs/' |
| ROOT | '/home/hijiri3/www/nc3' |
| TESTS | '/home/hijiri3/www/nc3/app/Test/' |
| TMP | '/home/hijiri3/www/nc3/app/tmp/' |
| VENDORS | '/home/hijiri3/www/nc3/vendors/' |
| WEBROOT_DIR | 'webroot' |
| WWW_ROOT | '/home/hijiri3/www/nc3/app/webroot/' |
| Environment Variable | Value |
|---|---|
| Php Version | '7.4.33' |
| Redirect Redirect Status | '200' |
| Redirect Status | '200' |
| Http Host | 'hijirigaoka.org' |
| Http X Real Ip | '3.231.217.107' |
| Http Listen Ipaddr | '49.212.198.171' |
| Http User Agent | 'CCBot/2.0 (https://commoncrawl.org/faq/)' |
| Http Accept | 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8' |
| Http Accept Language | 'en-US,en;q=0.5' |
| Http If Modified Since | 'Wed, 30 Nov 2022 03:57:38 GMT' |
| Http Accept Encoding | 'br,gzip' |
| Path | '/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin' |
| Server Signature | '' |
| Server Software | 'Apache' |
| Server Name | 'hijirigaoka.org' |
| Server Addr | '100.64.0.17' |
| Server Port | '80' |
| Remote Host | 'ec2-3-231-217-107.compute-1.amazonaws.com' |
| Remote Addr | '3.231.217.107' |
| Document Root | '/home/hijiri3/www/nc3' |
| Request Scheme | 'http' |
| Context Prefix | '' |
| Context Document Root | '/home/hijiri3/www/nc3' |
| Server Admin | '[no address given]' |
| Script Filename | '/home/hijiri3/www/nc3/app/webroot/index.php' |
| Remote Port | '0' |
| Redirect Url | '/app/webroot/page_20200422002638' |
| Gateway Interface | 'CGI/1.1' |
| Server Protocol | 'HTTP/1.1' |
| Request Method | 'GET' |
| Query String | '' |
| Request Uri | '/page_20200422002638' |
| Script Name | '/app/webroot/index.php' |
| Php Self | '/app/webroot/index.php' |
| Request Time Float | (float) 1685622021.1308 |
| Request Time | (int) 1685622021 |
| Argc | (int) 0 |