ご利用者様の声
投稿日時 : 06/28
システム管理者
システム管理者
ご利用者様の声を紹介します。
To view Cookies, add CookieComponent to Controller
| Query | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|
| SELECT COUNT(*) AS `count` FROM `xs319443_midwife`.`pages` AS `Page` INNER JOIN `xs319443_midwife`.`rooms` AS `Room` ON (`Room`.`id` = `Page`.`room_id`) WHERE `Page`.`permalink` = 'blogs/blog_entries/view/29/af295c1bef352958723c60ba4429d18a' AND `Room`.`space_id` = 2 | 1 | 1 | 0 | |
| SELECT `Page`.`weight`, `Page`.`theme` FROM `xs319443_midwife`.`pages` AS `Page` WHERE `Page`.`id` = 4 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Frame`.`id`, `Frame`.`room_id`, `Frame`.`box_id`, `Frame`.`plugin_key`, `Frame`.`block_id`, `Frame`.`key`, `Frame`.`header_type`, `Frame`.`weight`, `Frame`.`is_deleted`, `Frame`.`default_action`, `Frame`.`default_setting_action`, `FramePublicLanguage`.`id`, `FramePublicLanguage`.`language_id`, `FramePublicLanguage`.`frame_id`, `FramePublicLanguage`.`is_public`, `FramesLanguage`.`id`, `FramesLanguage`.`language_id`, `FramesLanguage`.`frame_id`, `FramesLanguage`.`name`, `FramesLanguage`.`is_origin`, `FramesLanguage`.`is_translation`, `FramesLanguage`.`is_original_copy`, `Block`.`id`, `Block`.`room_id`, `Block`.`plugin_key`, `Block`.`key`, `Block`.`public_type`, `Block`.`publish_start`, `Block`.`publish_end`, `Block`.`content_count`, `BlocksLanguage`.`language_id`, `BlocksLanguage`.`block_id`, `BlocksLanguage`.`name`, `BlocksLanguage`.`is_origin`, `BlocksLanguage`.`is_translation`, `BlocksLanguage`.`is_original_copy` FROM `xs319443_midwife`.`frames` AS `Frame` INNER JOIN `xs319443_midwife`.`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 `xs319443_midwife`.`frames_languages` AS `FramesLanguage` ON (`FramesLanguage`.`frame_id` = `Frame`.`id` AND `FramesLanguage`.`language_id` = '2') LEFT JOIN `xs319443_midwife`.`blocks` AS `Block` ON (`Frame`.`block_id` = `Block`.`id`) LEFT JOIN `xs319443_midwife`.`blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND `BlocksLanguage`.`language_id` = '2') WHERE `Frame`.`id` = 39 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Box`.`id`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id` FROM `xs319443_midwife`.`boxes` AS `Box` WHERE `Box`.`id` = 16 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 `xs319443_midwife`.`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 `xs319443_midwife`.`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 `xs319443_midwife`.`pages_languages` AS `PagesLanguage` WHERE `PagesLanguage`.`page_id` = 4 AND `PagesLanguage`.`language_id` = 2 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PluginsRoom`.`plugin_key` FROM `xs319443_midwife`.`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 `xs319443_midwife`.`block_role_permissions` AS `BlockRolePermission` WHERE block_key = ('8b602d35e25f1a26ca602c3622a43bad') AND `roles_room_id` IS NULL | 0 | 0 | 0 | |
| SELECT `BlockSetting`.`block_key`, `BlockSetting`.`field_name`, `BlockSetting`.`value` FROM `xs319443_midwife`.`block_settings` AS `BlockSetting` WHERE `room_id` = 1 AND block_key = ('8b602d35e25f1a26ca602c3622a43bad') AND `field_name` IN ('use_workflow', 'use_comment_approval') | 2 | 2 | 0 | |
| SELECT `PageContainer`.`id`, `PageContainer`.`page_id`, `PageContainer`.`container_type`, `PageContainer`.`is_published`, `PageContainer`.`is_configured` FROM `xs319443_midwife`.`page_containers` AS `PageContainer` WHERE `PageContainer`.`page_id` = 4 | 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 `xs319443_midwife`.`boxes_page_containers` AS `BoxesPageContainer` INNER JOIN `xs319443_midwife`.`boxes` AS `Box` ON (`Box`.`id` = `BoxesPageContainer`.`box_id`) INNER JOIN `xs319443_midwife`.`rooms` AS `Room` ON (`Box`.`room_id` = `Room`.`id`) LEFT JOIN `xs319443_midwife`.`rooms_languages` AS `RoomsLanguage` ON (`RoomsLanguage`.`language_id` = '2' AND `Room`.`id` = `RoomsLanguage`.`room_id`) WHERE `BoxesPageContainer`.`page_container_id` IN (16, 17, 18, 19, 20) AND `BoxesPageContainer`.`is_published` = '1' ORDER BY `BoxesPageContainer`.`page_container_id` ASC, `BoxesPageContainer`.`weight` ASC | 5 | 5 | 0 | |
| SELECT `Frame`.`id`, `Frame`.`room_id`, `Frame`.`box_id`, `Frame`.`plugin_key`, `Frame`.`block_id`, `Frame`.`key`, `Frame`.`header_type`, `Frame`.`weight`, `Frame`.`is_deleted`, `Frame`.`default_action`, `Frame`.`default_setting_action`, `FramePublicLanguage`.`id`, `FramePublicLanguage`.`language_id`, `FramePublicLanguage`.`frame_id`, `FramePublicLanguage`.`is_public`, `FramesLanguage`.`id`, `FramesLanguage`.`language_id`, `FramesLanguage`.`frame_id`, `FramesLanguage`.`name`, `FramesLanguage`.`is_origin`, `FramesLanguage`.`is_translation`, `FramesLanguage`.`is_original_copy`, `Block`.`id`, `Block`.`room_id`, `Block`.`plugin_key`, `Block`.`key`, `Block`.`public_type`, `Block`.`publish_start`, `Block`.`publish_end`, `Block`.`content_count`, `BlocksLanguage`.`language_id`, `BlocksLanguage`.`block_id`, `BlocksLanguage`.`name`, `BlocksLanguage`.`is_origin`, `BlocksLanguage`.`is_translation`, `BlocksLanguage`.`is_original_copy` FROM `xs319443_midwife`.`frames` AS `Frame` INNER JOIN `xs319443_midwife`.`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 `xs319443_midwife`.`frames_languages` AS `FramesLanguage` ON (`FramesLanguage`.`frame_id` = `Frame`.`id` AND `FramesLanguage`.`language_id` = '2') LEFT JOIN `xs319443_midwife`.`blocks` AS `Block` ON (`Frame`.`block_id` = `Block`.`id`) LEFT JOIN `xs319443_midwife`.`blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND `BlocksLanguage`.`language_id` = '2') WHERE `Frame`.`box_id` IN (17, 18, 16, 19, 20) AND `Frame`.`is_deleted` = '0' ORDER BY `Frame`.`box_id` ASC, `Frame`.`is_deleted` ASC, `Frame`.`weight` ASC | 13 | 13 | 0 | |
| SELECT `Page`.`sort_key` FROM `xs319443_midwife`.`pages` AS `Page` WHERE `Page`.`id` = 4 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Page`.`id` FROM `xs319443_midwife`.`pages` AS `Page` WHERE 1 = 1 AND `Page`.`sort_key` IN ('~00000001', '~00000001-00000001') ORDER BY `Page`.`sort_key` asc | 2 | 2 | 0 | |
| SELECT `Page`.`theme` FROM `xs319443_midwife`.`pages` AS `Page` WHERE `id` IN (1, 4) AND `theme` IS NOT NULL ORDER BY `sort_key` desc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Category`.`id`, `Category`.`block_id`, `Category`.`key`, `CategoryOrder`.`id`, `CategoryOrder`.`category_key`, `CategoryOrder`.`block_key`, `CategoryOrder`.`weight`, `CategoriesLanguage`.`id`, `CategoriesLanguage`.`language_id`, `CategoriesLanguage`.`category_id`, `CategoriesLanguage`.`name` FROM `xs319443_midwife`.`categories` AS `Category` INNER JOIN `xs319443_midwife`.`category_orders` AS `CategoryOrder` ON (`CategoryOrder`.`category_key`=`Category`.`key`) LEFT JOIN `xs319443_midwife`.`categories_languages` AS `CategoriesLanguage` ON (`CategoriesLanguage`.`category_id` = `Category`.`id` AND `CategoriesLanguage`.`language_id` = 2) WHERE `Category`.`block_id` = 29 ORDER BY `CategoryOrder`.`weight` ASC | 0 | 0 | 0 | |
| SELECT `BlocksLanguage`.`name`, `Block`.`id` FROM `xs319443_midwife`.`blocks` AS `Block` LEFT JOIN `xs319443_midwife`.`rooms` AS `Room` ON (`Block`.`room_id` = `Room`.`id`) LEFT JOIN `xs319443_midwife`.`users` AS `TrackableCreator` ON (`Block`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `xs319443_midwife`.`users` AS `TrackableUpdater` ON (`Block`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `xs319443_midwife`.`plugins` AS `Plugin` ON (`Plugin`.`key` = `Block`.`plugin_key` AND `Plugin`.`language_id` = 2) LEFT JOIN `xs319443_midwife`.`blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND `BlocksLanguage`.`language_id` = 2) WHERE `Block`.`id` = 29 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Blog`.`id`, `Blog`.`block_id`, `Blog`.`language_id`, `Blog`.`name`, `Blog`.`key`, `Blog`.`is_origin`, `Blog`.`is_translation`, `Blog`.`is_original_copy`, `Blog`.`created_user`, `Blog`.`created`, `Blog`.`modified_user`, `Blog`.`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 `xs319443_midwife`.`blogs` AS `Blog` LEFT JOIN `xs319443_midwife`.`blocks` AS `Block` ON (`Blog`.`block_id` = `Block`.`id`) LEFT JOIN `xs319443_midwife`.`users` AS `TrackableCreator` ON (`Blog`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `xs319443_midwife`.`users` AS `TrackableUpdater` ON (`Blog`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `xs319443_midwife`.`blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND `BlocksLanguage`.`language_id` = 2) WHERE `Block`.`id` = 29 AND `Block`.`room_id` = 1 AND `Blog`.`language_id` = 2 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `BlockSetting`.`id`, `BlockSetting`.`plugin_key`, `BlockSetting`.`room_id`, `BlockSetting`.`block_key`, `BlockSetting`.`field_name`, `BlockSetting`.`value`, `BlockSetting`.`type` FROM `xs319443_midwife`.`block_settings` AS `BlockSetting` WHERE `room_id` = 1 | 17 | 17 | 0 | |
| SELECT `BlogFrameSetting`.`id`, `BlogFrameSetting`.`frame_key`, `BlogFrameSetting`.`articles_per_page`, `BlogFrameSetting`.`created_user`, `BlogFrameSetting`.`created`, `BlogFrameSetting`.`modified_user`, `BlogFrameSetting`.`modified` FROM `xs319443_midwife`.`blog_frame_settings` AS `BlogFrameSetting` WHERE `frame_key` = '682707a9618a4c489fda64df1e43b0d0' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `BlogEntry`.`id`, `BlogEntry`.`blog_key`, `BlogEntry`.`category_id`, `BlogEntry`.`block_id`, `BlogEntry`.`key`, `BlogEntry`.`status`, `BlogEntry`.`is_active`, `BlogEntry`.`is_latest`, `BlogEntry`.`language_id`, `BlogEntry`.`is_origin`, `BlogEntry`.`is_translation`, `BlogEntry`.`is_original_copy`, `BlogEntry`.`title`, `BlogEntry`.`title_icon`, `BlogEntry`.`body1`, `BlogEntry`.`body2`, `BlogEntry`.`public_type`, `BlogEntry`.`publish_start`, `BlogEntry`.`publish_end`, `BlogEntry`.`created_user`, `BlogEntry`.`created`, `BlogEntry`.`modified_user`, `BlogEntry`.`modified`, `Category`.`id`, `Category`.`block_id`, `Category`.`key`, `Category`.`created_user`, `Category`.`created`, `Category`.`modified_user`, `Category`.`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`, `CategoriesLanguage`.`id`, `CategoriesLanguage`.`language_id`, `CategoriesLanguage`.`category_id`, `CategoriesLanguage`.`name`, `CategoriesLanguage`.`is_origin`, `CategoriesLanguage`.`is_translation`, `Like`.`id`, `Like`.`plugin_key`, `Like`.`block_key`, `Like`.`content_key`, `Like`.`like_count`, `Like`.`unlike_count`, `Like`.`weight`, `Like`.`created_user`, `Like`.`created`, `Like`.`modified_user`, `Like`.`modified`, `LikesUser`.`id`, `LikesUser`.`like_id`, `LikesUser`.`user_id`, `LikesUser`.`session_key`, `LikesUser`.`is_liked`, `LikesUser`.`created_user`, `LikesUser`.`created`, `LikesUser`.`modified_user`, `LikesUser`.`modified` FROM `xs319443_midwife`.`blog_entries` AS `BlogEntry` LEFT JOIN `xs319443_midwife`.`categories` AS `Category` ON (`BlogEntry`.`category_id` = `Category`.`id`) LEFT JOIN `xs319443_midwife`.`blocks` AS `Block` ON (`BlogEntry`.`block_id` = `Block`.`id`) LEFT JOIN `xs319443_midwife`.`users` AS `TrackableCreator` ON (`BlogEntry`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `xs319443_midwife`.`users` AS `TrackableUpdater` ON (`BlogEntry`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `xs319443_midwife`.`categories_languages` AS `CategoriesLanguage` ON (`CategoriesLanguage`.`category_id` = `BlogEntry`.`category_id` AND `CategoriesLanguage`.`language_id` = 2) LEFT JOIN `xs319443_midwife`.`likes` AS `Like` ON (`Like`.`plugin_key` = 'blogs' AND `BlogEntry`.`key` = `Like`.`content_key`) LEFT JOIN `xs319443_midwife`.`likes_users` AS `LikesUser` ON (`Like`.`id` = `LikesUser`.`like_id` AND `LikesUser`.`session_key` = '8243d04ad3725e3a00196577ebac9cd6') WHERE `BlogEntry`.`block_id` = 29 AND `BlogEntry`.`language_id` = 2 AND ((`BlogEntry`.`is_active` = '1') AND (((`BlogEntry`.`public_type` = 1) OR (((`BlogEntry`.`public_type` = 2) AND (((`BlogEntry`.`publish_start` <= '2024-07-01 08:10:42') OR (`BlogEntry`.`publish_start` IS NULL))) AND (((`BlogEntry`.`publish_end` >= '2024-07-01 08:10:42') OR (`BlogEntry`.`publish_end` IS NULL)))))))) AND `BlogEntry`.`key` = 'af295c1bef352958723c60ba4429d18a' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Tag`.`id`, `Tag`.`block_id`, `Tag`.`model`, `Tag`.`key`, `Tag`.`language_id`, `Tag`.`is_origin`, `Tag`.`is_translation`, `Tag`.`is_original_copy`, `Tag`.`name`, `TagsContent`.`id`, `TagsContent`.`model`, `TagsContent`.`content_id`, `TagsContent`.`tag_id` FROM `xs319443_midwife`.`tags` AS `Tag` LEFT JOIN `xs319443_midwife`.`tags_contents` AS `TagsContent` ON (`Tag`.`id` = `TagsContent`.`tag_id`) WHERE `TagsContent`.`model` = 'BlogEntry' AND `TagsContent`.`content_id` = '1' | 0 | 0 | 0 | |
| SELECT `ContentComment`.`content_key`, count(content_key) as ContentComment__cnt FROM `xs319443_midwife`.`content_comments` AS `ContentComment` WHERE `block_key` = '8b602d35e25f1a26ca602c3622a43bad' AND `plugin_key` = 'blogs' AND content_key = ('af295c1bef352958723c60ba4429d18a') AND `ContentComment`.`status` = 1 GROUP BY content_key | 0 | 0 | 0 | |
| SELECT `ContentComment`.`id`, `ContentComment`.`block_key`, `ContentComment`.`plugin_key`, `ContentComment`.`content_key`, `ContentComment`.`status`, `ContentComment`.`comment`, `ContentComment`.`created_user`, `ContentComment`.`created`, `ContentComment`.`modified_user`, `ContentComment`.`modified`, (0) AS `ContentComment__cnt`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `xs319443_midwife`.`content_comments` AS `ContentComment` LEFT JOIN `xs319443_midwife`.`users` AS `TrackableCreator` ON (`ContentComment`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `xs319443_midwife`.`users` AS `TrackableUpdater` ON (`ContentComment`.`modified_user` = `TrackableUpdater`.`id`) WHERE `block_key` = '8b602d35e25f1a26ca602c3622a43bad' AND `plugin_key` = 'blogs' AND `content_key` = 'af295c1bef352958723c60ba4429d18a' AND `ContentComment`.`status` = 1 ORDER BY `ContentComment`.`created` desc LIMIT 5 | 0 | 0 | 0 | |
| SELECT `RoomRole`.`id`, `RoomRole`.`role_key`, `RoomRole`.`level`, `RoomRole`.`weight`, `RoomRole`.`created_user`, `RoomRole`.`created`, `RoomRole`.`modified_user`, `RoomRole`.`modified` FROM `xs319443_midwife`.`room_roles` AS `RoomRole` WHERE 1 = 1 | 5 | 5 | 0 | |
| SELECT `Role`.`id`, `Role`.`language_id`, `Role`.`is_origin`, `Role`.`is_translation`, `Role`.`is_original_copy`, `Role`.`key`, `Role`.`type`, `Role`.`name`, `Role`.`description`, `Role`.`is_system`, `Role`.`created_user`, `Role`.`created`, `Role`.`modified_user`, `Role`.`modified` FROM `xs319443_midwife`.`roles` AS `Role` WHERE `Role`.`type` = 2 AND `Role`.`language_id` = 2 | 5 | 5 | 0 | |
| SELECT `DefaultRolePermission`.*, `DefaultRolePermission`.`value` AS `default` FROM `xs319443_midwife`.`default_role_permissions` AS `DefaultRolePermission` WHERE `DefaultRolePermission`.`type` = 'room_role' AND `DefaultRolePermission`.`permission` = ('content_comment_creatable') | 5 | 5 | 0 | |
| SELECT `RolesRoom`.`role_key`, `RolesRoom`.`id` FROM `xs319443_midwife`.`roles_rooms` AS `RolesRoom` WHERE `RolesRoom`.`room_id` = 1 AND `RolesRoom`.`role_key` IN ('room_administrator', 'chief_editor', 'editor', 'general_user', 'visitor') | 5 | 5 | 0 | |
| SELECT `RoomRolePermission`.`id`, `RoomRolePermission`.`roles_room_id`, `RoomRolePermission`.`permission`, `RoomRolePermission`.`value`, `RoomRolePermission`.`created_user`, `RoomRolePermission`.`created`, `RoomRolePermission`.`modified_user`, `RoomRolePermission`.`modified`, `RolesRoom`.`id`, `RolesRoom`.`room_id`, `RolesRoom`.`role_key`, `RolesRoom`.`created_user`, `RolesRoom`.`created`, `RolesRoom`.`modified_user`, `RolesRoom`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `xs319443_midwife`.`room_role_permissions` AS `RoomRolePermission` LEFT JOIN `xs319443_midwife`.`roles_rooms` AS `RolesRoom` ON (`RoomRolePermission`.`roles_room_id` = `RolesRoom`.`id`) LEFT JOIN `xs319443_midwife`.`users` AS `TrackableCreator` ON (`RoomRolePermission`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `xs319443_midwife`.`users` AS `TrackableUpdater` ON (`RoomRolePermission`.`modified_user` = `TrackableUpdater`.`id`) WHERE `RoomRolePermission`.`roles_room_id` IN (2, 3, 4, 1, 5) AND `RoomRolePermission`.`permission` = ('content_comment_creatable') | 5 | 5 | 0 | |
| SELECT `BlockRolePermission`.`id`, `BlockRolePermission`.`roles_room_id`, `BlockRolePermission`.`block_key`, `BlockRolePermission`.`permission`, `BlockRolePermission`.`value`, `BlockRolePermission`.`created_user`, `BlockRolePermission`.`created`, `BlockRolePermission`.`modified_user`, `BlockRolePermission`.`modified`, `RolesRoom`.`id`, `RolesRoom`.`room_id`, `RolesRoom`.`role_key`, `RolesRoom`.`created_user`, `RolesRoom`.`created`, `RolesRoom`.`modified_user`, `RolesRoom`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `xs319443_midwife`.`block_role_permissions` AS `BlockRolePermission` LEFT JOIN `xs319443_midwife`.`roles_rooms` AS `RolesRoom` ON (`BlockRolePermission`.`roles_room_id` = `RolesRoom`.`id`) LEFT JOIN `xs319443_midwife`.`users` AS `TrackableCreator` ON (`BlockRolePermission`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `xs319443_midwife`.`users` AS `TrackableUpdater` ON (`BlockRolePermission`.`modified_user` = `TrackableUpdater`.`id`) WHERE `BlockRolePermission`.`roles_room_id` IN (2, 3, 4, 1, 5) AND `BlockRolePermission`.`block_key` = '8b602d35e25f1a26ca602c3622a43bad' AND `BlockRolePermission`.`permission` = ('content_comment_creatable') | 0 | 0 | 0 | |
| SELECT `Room`.`id`, `Room`.`page_id_top` FROM `xs319443_midwife`.`rooms` AS `Room` LEFT JOIN `xs319443_midwife`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `xs319443_midwife`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `xs319443_midwife`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `xs319443_midwife`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `xs319443_midwife`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `xs319443_midwife`.`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 | 5 | 5 | 0 | |
| SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`weight`, `Page`.`sort_key`, `Page`.`child_count`, `Page`.`permalink`, `PagesLanguage`.`page_id`, `PagesLanguage`.`name`, `MenuFramesPage`.`id`, `MenuFramesPage`.`page_id`, `MenuFramesPage`.`folder_type`, `MenuFramesPage`.`is_hidden` FROM `xs319443_midwife`.`pages` AS `Page` INNER JOIN `xs319443_midwife`.`rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) INNER JOIN `xs319443_midwife`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) INNER JOIN `xs319443_midwife`.`pages_languages` AS `PagesLanguage` ON (`Page`.`id` = PagesLanguage .page_id) LEFT JOIN `xs319443_midwife`.`menu_frames_pages` AS `MenuFramesPage` ON (`Page`.`id` = MenuFramesPage .page_id AND `MenuFramesPage`.`frame_key` = '98caaa072fc53e856d00dd803a246bc3') LEFT JOIN `xs319443_midwife`.`pages_languages` AS `OriginPagesLanguage` ON (`PagesLanguage`.`page_id` = `OriginPagesLanguage`.`page_id` AND `OriginPagesLanguage`.`language_id` = '2') WHERE `Page`.`room_id` IN (1, 6, 8, 12, 13) 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 | 6 | 6 | 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 `xs319443_midwife`.`menu_frame_settings` AS `MenuFrameSetting` WHERE `frame_key` = '98caaa072fc53e856d00dd803a246bc3' 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 `xs319443_midwife`.`rooms` AS `Room` INNER JOIN `xs319443_midwife`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) INNER JOIN `xs319443_midwife`.`rooms_languages` AS `RoomsLanguage` ON (`Room`.`id` = RoomsLanguage .room_id AND ((`RoomsLanguage`.`language_id` = '2') OR (`Space`.`is_m17n` = '0'))) LEFT JOIN `xs319443_midwife`.`menu_frames_rooms` AS `MenuFramesRoom` ON (`Room`.`id` = MenuFramesRoom .room_id AND `MenuFramesRoom`.`frame_key` = '98caaa072fc53e856d00dd803a246bc3') LEFT JOIN `xs319443_midwife`.`rooms_languages` AS `OriginRoomsLanguage` ON (`RoomsLanguage`.`room_id` = `OriginRoomsLanguage`.`room_id` AND `OriginRoomsLanguage`.`language_id` = '2') WHERE `Room`.`id` IN (1, 6, 8, 12, 13) 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 | 5 | 5 | 0 | |
| SELECT `PagesLanguage`.`page_id`, `PagesLanguage`.`language_id`, `PagesLanguage`.`name` FROM `xs319443_midwife`.`pages_languages` AS `PagesLanguage` LEFT JOIN `xs319443_midwife`.`pages` AS `Page` ON (`PagesLanguage`.`page_id` = `Page`.`id`) LEFT JOIN `xs319443_midwife`.`languages` AS `Language` ON (`PagesLanguage`.`language_id` = `Language`.`id`) LEFT JOIN `xs319443_midwife`.`users` AS `TrackableCreator` ON (`PagesLanguage`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `xs319443_midwife`.`users` AS `TrackableUpdater` ON (`PagesLanguage`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `xs319443_midwife`.`rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) LEFT JOIN `xs319443_midwife`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `xs319443_midwife`.`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, 6, 8, 12, 13) | 6 | 6 | 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`, `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 `xs319443_midwife`.`pages` AS `Page` LEFT JOIN `xs319443_midwife`.`rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) LEFT JOIN `xs319443_midwife`.`pages` AS `ParentPage` ON (`Page`.`parent_id` = `ParentPage`.`id`) LEFT JOIN `xs319443_midwife`.`users` AS `TrackableCreator` ON (`Page`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `xs319443_midwife`.`users` AS `TrackableUpdater` ON (`Page`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `xs319443_midwife`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) WHERE `Page`.`id` IN (1, 4, 6, 8, 12, 13) | 6 | 6 | 0 | |
| 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 `xs319443_midwife`.`pages` AS `ChildPage` WHERE `ChildPage`.`parent_id` IN (1, 4, 6, 8, 12, 13) | 5 | 5 | 0 | |
| SELECT `Page`.`sort_key` FROM `xs319443_midwife`.`pages` AS `Page` WHERE `Page`.`id` = 4 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 `xs319443_midwife`.`pages` AS `Page` WHERE 1 = 1 AND `Page`.`sort_key` IN ('~00000001', '~00000001-00000001') ORDER BY `Page`.`sort_key` asc | 2 | 2 | 0 | |
| SELECT COUNT(*) AS `count` FROM `xs319443_midwife`.`menu_frames_rooms` AS `MenuFramesRoom` WHERE `MenuFramesRoom`.`frame_key` = '98caaa072fc53e856d00dd803a246bc3' | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `xs319443_midwife`.`menu_frames_pages` AS `MenuFramesPage` WHERE `MenuFramesPage`.`frame_key` = '98caaa072fc53e856d00dd803a246bc3' | 1 | 1 | 0 | |
| SELECT `Page`.`id`, `Page`.`parent_id` FROM `xs319443_midwife`.`pages` AS `Page` LEFT JOIN `xs319443_midwife`.`rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) LEFT JOIN `xs319443_midwife`.`pages` AS `ParentPage` ON (`Page`.`parent_id` = `ParentPage`.`id`) LEFT JOIN `xs319443_midwife`.`users` AS `TrackableCreator` ON (`Page`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `xs319443_midwife`.`users` AS `TrackableUpdater` ON (`Page`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `xs319443_midwife`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `xs319443_midwife`.`pages_languages` AS `PagesLanguage` ON (`PagesLanguage`.`page_id` = `Page`.`id`) LEFT JOIN `xs319443_midwife`.`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, 6, 8, 12, 13) AND 1 = 1 ORDER BY `Page`.`sort_key` asc | 6 | 6 | 0 | |
| SELECT `Page`.`sort_key` FROM `xs319443_midwife`.`pages` AS `Page` WHERE `Page`.`id` = 4 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 `xs319443_midwife`.`pages` AS `Page` WHERE 1 = 1 AND `Page`.`sort_key` IN ('~00000001', '~00000001-00000001') ORDER BY `Page`.`sort_key` asc | 2 | 2 | 0 | |
| SELECT `Room`.`id`, `Room`.`page_id_top` FROM `xs319443_midwife`.`rooms` AS `Room` LEFT JOIN `xs319443_midwife`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `xs319443_midwife`.`rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `xs319443_midwife`.`users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `xs319443_midwife`.`users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `xs319443_midwife`.`roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `xs319443_midwife`.`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 | 5 | 5 | 0 | |
| SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`weight`, `Page`.`sort_key`, `Page`.`child_count`, `Page`.`permalink`, `PagesLanguage`.`page_id`, `PagesLanguage`.`name`, `MenuFramesPage`.`id`, `MenuFramesPage`.`page_id`, `MenuFramesPage`.`folder_type`, `MenuFramesPage`.`is_hidden` FROM `xs319443_midwife`.`pages` AS `Page` INNER JOIN `xs319443_midwife`.`rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) INNER JOIN `xs319443_midwife`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) INNER JOIN `xs319443_midwife`.`pages_languages` AS `PagesLanguage` ON (`Page`.`id` = PagesLanguage .page_id) LEFT JOIN `xs319443_midwife`.`menu_frames_pages` AS `MenuFramesPage` ON (`Page`.`id` = MenuFramesPage .page_id AND `MenuFramesPage`.`frame_key` = 'f81cac2284c2a9544008ca12a329bdb8') LEFT JOIN `xs319443_midwife`.`pages_languages` AS `OriginPagesLanguage` ON (`PagesLanguage`.`page_id` = `OriginPagesLanguage`.`page_id` AND `OriginPagesLanguage`.`language_id` = '2') WHERE `Page`.`room_id` IN (1, 6, 8, 12, 13) 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 | 6 | 6 | 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 `xs319443_midwife`.`menu_frame_settings` AS `MenuFrameSetting` WHERE `frame_key` = 'f81cac2284c2a9544008ca12a329bdb8' 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 `xs319443_midwife`.`rooms` AS `Room` INNER JOIN `xs319443_midwife`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) INNER JOIN `xs319443_midwife`.`rooms_languages` AS `RoomsLanguage` ON (`Room`.`id` = RoomsLanguage .room_id AND ((`RoomsLanguage`.`language_id` = '2') OR (`Space`.`is_m17n` = '0'))) LEFT JOIN `xs319443_midwife`.`menu_frames_rooms` AS `MenuFramesRoom` ON (`Room`.`id` = MenuFramesRoom .room_id AND `MenuFramesRoom`.`frame_key` = 'f81cac2284c2a9544008ca12a329bdb8') LEFT JOIN `xs319443_midwife`.`rooms_languages` AS `OriginRoomsLanguage` ON (`RoomsLanguage`.`room_id` = `OriginRoomsLanguage`.`room_id` AND `OriginRoomsLanguage`.`language_id` = '2') WHERE `Room`.`id` IN (1, 6, 8, 12, 13) 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 | 5 | 5 | 0 | |
| SELECT `Page`.`sort_key` FROM `xs319443_midwife`.`pages` AS `Page` WHERE `Page`.`id` = 4 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 `xs319443_midwife`.`pages` AS `Page` WHERE 1 = 1 AND `Page`.`sort_key` IN ('~00000001', '~00000001-00000001') ORDER BY `Page`.`sort_key` asc | 2 | 2 | 0 | |
| SELECT COUNT(*) AS `count` FROM `xs319443_midwife`.`menu_frames_rooms` AS `MenuFramesRoom` WHERE `MenuFramesRoom`.`frame_key` = 'f81cac2284c2a9544008ca12a329bdb8' | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `xs319443_midwife`.`menu_frames_pages` AS `MenuFramesPage` WHERE `MenuFramesPage`.`frame_key` = 'f81cac2284c2a9544008ca12a329bdb8' | 1 | 1 | 0 | |
| SELECT `Page`.`id`, `Page`.`parent_id` FROM `xs319443_midwife`.`pages` AS `Page` LEFT JOIN `xs319443_midwife`.`rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) LEFT JOIN `xs319443_midwife`.`pages` AS `ParentPage` ON (`Page`.`parent_id` = `ParentPage`.`id`) LEFT JOIN `xs319443_midwife`.`users` AS `TrackableCreator` ON (`Page`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `xs319443_midwife`.`users` AS `TrackableUpdater` ON (`Page`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `xs319443_midwife`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `xs319443_midwife`.`pages_languages` AS `PagesLanguage` ON (`PagesLanguage`.`page_id` = `Page`.`id`) LEFT JOIN `xs319443_midwife`.`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, 6, 8, 12, 13) AND 1 = 1 ORDER BY `Page`.`sort_key` asc | 6 | 6 | 0 | |
| SELECT `Page`.`sort_key` FROM `xs319443_midwife`.`pages` AS `Page` WHERE `Page`.`id` = 4 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 `xs319443_midwife`.`pages` AS `Page` WHERE 1 = 1 AND `Page`.`sort_key` IN ('~00000001', '~00000001-00000001') ORDER BY `Page`.`sort_key` asc | 2 | 2 | 0 | |
| SELECT `BlockRolePermission`.`id`, `BlockRolePermission`.`roles_room_id`, `BlockRolePermission`.`block_key`, `BlockRolePermission`.`permission`, `BlockRolePermission`.`value` FROM `xs319443_midwife`.`block_role_permissions` AS `BlockRolePermission` WHERE `block_key` = 'f14bd6fa897ce36cb77fb85e6916dade' 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 `xs319443_midwife`.`announcements` AS `Announcement` LEFT JOIN `xs319443_midwife`.`blocks` AS `Block` ON (`Announcement`.`block_id` = `Block`.`id`) LEFT JOIN `xs319443_midwife`.`users` AS `TrackableCreator` ON (`Announcement`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `xs319443_midwife`.`users` AS `TrackableUpdater` ON (`Announcement`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `xs319443_midwife`.`blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND `BlocksLanguage`.`language_id` = 2) WHERE `Block`.`id` = 12 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 0 |
9 duplicate queries run.
Peak Memory Use 10.10 MB
| Message | Memory use |
|---|---|
| Component initialization | 3.41 MB |
| Controller action start | 4.04 MB |
| Controller render start | 5.17 MB |
| Component initialization #2 | 6.15 MB |
| Controller action start #2 | 6.27 MB |
| Controller render start #2 | 6.64 MB |
| Component initialization #3 | 6.81 MB |
| Controller action start #3 | 6.85 MB |
| Controller render start #3 | 6.98 MB |
| Component initialization #4 | 7.15 MB |
| Controller action start #4 | 7.16 MB |
| Controller render start #4 | 7.41 MB |
| View render complete | 7.51 MB |
Total Request Time: 1152 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 514.71 | |
| Event: Controller.initialize | 9.40 | |
| Event: Controller.startup | 233.87 | |
| Controller action | 199.83 | |
| Event: Controller.beforeRender | 6.97 | |
| » Processing toolbar data | 5.96 | |
| Rendering View | 170.49 | |
| » Event: View.beforeRender | 0.48 | |
| » Rendering APP/Plugin/Blogs/View/BlogEntries/view.ctp | 49.27 | |
| » » Rendering APP/Plugin/Blogs/View/Elements/BlogEntries/edit_link.ctp | 0.31 | |
| » » Rendering APP/Plugin/Blogs/View/Elements/entry_meta_info.ctp | 5.33 | |
| » » Rendering APP/Plugin/Blogs/View/Elements/entry_footer.ctp | 0.28 | |
| » » Rendering APP/Plugin/ContentComments/View/Elements/index.ctp | 5.16 | |
| » » » Rendering APP/Plugin/NetCommons/View/Elements/paginator.ctp | 0.07 | |
| » Event: View.afterRender | 0.27 | |
| » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp | 0.10 | |
| » » Rendering APP/Plugin/Pages/View/Elements/page_main.ctp | 0.05 | |
| » Event: View.beforeLayout | 113.70 | |
| » » Rendering APP/Plugin/Pages/View/Elements/page_header.ctp | 78.33 | |
| » » » Rendering APP/Plugin/Boxes/View/Elements/render_boxes.ctp | 78.26 | |
| » » » » Rendering APP/Plugin/Frames/View/Elements/render_frames.ctp | 78.20 | |
| » » » » » Event: Controller.initialize #2 | 18.09 | |
| » » » » » Event: Controller.startup #2 | 0.14 | |
| » » » » » Controller action #2 | 39.20 | |
| » » » » » Event: Controller.beforeRender #2 | 18.46 | |
| » » » » » » Processing toolbar data #2 | 18.36 | |
| Rendering View #2 | 0.00 | |
| » » » » » » Event: View.beforeRender #2 | 0.05 | |
| » » » » » » Rendering APP/Plugin/Menus/View/Menus/index.ctp #2 | 0.95 | |
| » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/footer/index.ctp #3 | 0.75 | |
| » » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/footer/list_start.ctp | 0.12 | |
| » » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/footer/list.ctp | 0.05 | |
| » » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/footer/list_end.ctp | 0.02 | |
| » » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/footer/list_start.ctp #2 | 0.03 | |
| » » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/footer/list.ctp #2 | 0.03 | |
| » » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/footer/list_end.ctp #2 | 0.02 | |
| » » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/footer/list_start.ctp #3 | 0.03 | |
| » » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/footer/list.ctp #3 | 0.03 | |
| » » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/footer/list_end.ctp #3 | 0.02 | |
| » » » » » » Event: View.afterRender #2 | 0.18 | |
| » » » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #2 | 0.05 | |
| » » » » » » » Rendering APP/Plugin/Pages/View/Elements/page_main.ctp #2 | 0.03 | |
| » » » » » » Event: Controller.shutdown | 0.03 | |
| » » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #3 | 0.03 | |
| » » » Rendering APP/Plugin/Pages/View/Elements/page_footer.ctp | 35.25 | |
| » » » » Rendering APP/Plugin/Boxes/View/Elements/render_boxes.ctp #2 | 35.18 | |
| » » » » » Rendering APP/Plugin/Frames/View/Elements/render_frames.ctp #2 | 35.13 | |
| » » » » » » Event: Controller.initialize #3 | 0.87 | |
| » » » » » » Event: Controller.startup #3 | 0.13 | |
| » » » » » » Controller action #3 | 1.42 | |
| » » » » » » Event: Controller.beforeRender #3 | 4.78 | |
| » » » » » » » Processing toolbar data #3 | 4.72 | |
| Rendering View #3 | 0.00 | |
| » » » » » » » Event: View.beforeRender #3 | 0.03 | |
| » » » » » » » Rendering APP/Plugin/Menus/View/Menus/index.ctp #4 | 0.22 | |
| » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/topic_path/index.ctp #5 | 0.16 | |
| » » » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/topic_path/list.ctp #4 | 0.03 | |
| » » » » » » » Event: View.afterRender #3 | 0.17 | |
| » » » » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #4 | 0.04 | |
| » » » » » » » » Rendering APP/Plugin/Pages/View/Elements/page_main.ctp #3 | 0.03 | |
| » » » » » » » Event: Controller.shutdown #2 | 0.02 | |
| » » » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #5 | 0.03 | |
| » » » » » » » Event: Controller.initialize #4 | 0.32 | |
| » » » » » » » Event: Controller.startup #4 | 0.10 | |
| » » » » » » » Controller action #4 | 19.82 | |
| » » » » » » » Event: Controller.beforeRender #4 | 5.30 | |
| » » » » » » » » Processing toolbar data #4 | 5.21 | |
| Rendering View #4 | 0.00 | |
| » » » » » » » » Event: View.beforeRender #4 | 0.04 | |
| » » » » » » » » Rendering APP/Plugin/Announcements/View/Announcements/view.ctp #2 | 0.05 | |
| » » » » » » » » Event: View.afterRender #4 | 0.20 | |
| » » » » » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #6 | 0.05 | |
| » » » » » » » » » Rendering APP/Plugin/Pages/View/Elements/page_main.ctp #4 | 0.04 | |
| » » » » » » » » Event: Controller.shutdown #3 | 0.02 | |
| » » » » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #7 | 0.04 | |
| » » » » Rendering APP/Plugin/Pages/View/Layouts/default.ctp | 6.31 | |
| » » » » » Rendering APP/Plugin/NetCommons/View/Elements/common_favicon.ctp | 0.11 | |
| » » » » » Rendering APP/View/Themed/Original/Plugin/NetCommons/Elements/common_css.ctp | 0.27 | |
| » » » » » Rendering APP/Plugin/NetCommons/View/Elements/common_theme_css.ctp | 0.08 | |
| » » » » » Rendering APP/Plugin/NetCommons/View/Elements/common_js.ctp | 0.21 | |
| » » » » » Rendering APP/Plugin/Wysiwyg/View/Elements/mathjax_js.ctp | 0.08 | |
| » » » » » Rendering APP/Plugin/NetCommons/View/Elements/common_header.ctp | 5.14 | |
| » » » » » Rendering APP/Plugin/NetCommons/View/Elements/common_footer.ctp | 0.03 | |
| Event: View.afterLayout | 0.00 |
| Constant | Value |
|---|---|
| UPLOADS_ROOT | '/home/xs319443/midwife-egg.com/public_html/app/Uploads/' |
| CONFIG | '/home/xs319443/midwife-egg.com/public_html/app/Config/' |
| HTMLPURIFIER_PREFIX | '/home/xs319443/midwife-egg.com/public_html/vendors/ezyang/htmlpurifier/library' |
| NC3_VERSION | '3.3.7' |
| Constant | Value |
|---|---|
| APP | '/home/xs319443/midwife-egg.com/public_html/app/' |
| APP_DIR | 'app' |
| APPLIBS | '/home/xs319443/midwife-egg.com/public_html/app/Lib/' |
| CACHE | '/home/xs319443/midwife-egg.com/public_html/app/tmp/cache/' |
| CAKE | '/home/xs319443/midwife-egg.com/public_html/vendors/cakephp/cakephp/lib/Cake/' |
| CAKE_CORE_INCLUDE_PATH | '/home/xs319443/midwife-egg.com/public_html/vendors/cakephp/cakephp/lib' |
| CORE_PATH | '/home/xs319443/midwife-egg.com/public_html/vendors/cakephp/cakephp/lib/' |
| CAKE_VERSION | '2.10.24' |
| CSS | '/home/xs319443/midwife-egg.com/public_html/app/webroot/css/' |
| CSS_URL | 'css/' |
| DS | '/' |
| FULL_BASE_URL | 'https://midwife-egg.com' |
| IMAGES | '/home/xs319443/midwife-egg.com/public_html/app/webroot/img/' |
| IMAGES_URL | 'img/' |
| JS | '/home/xs319443/midwife-egg.com/public_html/app/webroot/js/' |
| JS_URL | 'js/' |
| LOGS | '/home/xs319443/midwife-egg.com/public_html/app/tmp/logs/' |
| ROOT | '/home/xs319443/midwife-egg.com/public_html' |
| TESTS | '/home/xs319443/midwife-egg.com/public_html/app/Test/' |
| TMP | '/home/xs319443/midwife-egg.com/public_html/app/tmp/' |
| VENDORS | '/home/xs319443/midwife-egg.com/public_html/vendors/' |
| WEBROOT_DIR | 'webroot' |
| WWW_ROOT | '/home/xs319443/midwife-egg.com/public_html/app/webroot/' |
| Environment Variable | Value |
|---|---|
| Php Version | '7.4.33' |
| User | 'xs319443' |
| Home | '/home/xs319443' |
| Script Name | '/app/webroot/index.php' |
| Request Uri | '/blogs/blog_entries/view/29/af295c1bef352958723c60ba4429d18a?frame_id=39' |
| Query String | 'frame_id=39' |
| Request Method | 'GET' |
| Server Protocol | 'HTTP/1.1' |
| Gateway Interface | 'CGI/1.1' |
| Redirect Query String | 'frame_id=39' |
| Redirect Url | '/app/webroot/blogs/blog_entries/view/29/af295c1bef352958723c60ba4429d18a' |
| Remote Port | '33898' |
| Script Filename | '/home/xs319443/midwife-egg.com/public_html/app/webroot/index.php' |
| Server Admin | 'webmaster@midwife-egg.com' |
| Context Document Root | '/home/xs319443/midwife-egg.com/public_html' |
| Context Prefix | '' |
| Request Scheme | 'https' |
| Document Root | '/home/xs319443/midwife-egg.com/public_html' |
| Remote Addr | '18.216.219.61' |
| Server Port | '443' |
| Server Addr | '162.43.101.45' |
| Server Name | 'midwife-egg.com' |
| Server Software | 'Apache' |
| Server Signature | '' |
| Path | '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin' |
| Http Cookie | 'fikker-61vm-nk2N=MgPGRI6oXLV7DSLWJk4y6wNi63F1ZE0E' |
| Http User Agent | 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' |
| Http Accept | '*/*' |
| Http Connection | 'close' |
| Http X File Type | 'normal' |
| Http X Ua Device | 'pc' |
| Http X Failure Cache Time | '0' |
| Http X Accel Expires | '60' |
| Http X Wp Access | '0' |
| Http X Php Fpm Version | '74' |
| Http X Server Address | '162.43.101.45' |
| Http X Real Ip | '18.216.219.61' |
| Http X Forwarded Ssl | 'on' |
| Http X Forwarded Port | '443' |
| Http X Forwarded Host | 'midwife-egg.com' |
| Http X Forwarded Proto | 'https' |
| Http X Forwarded For | '18.216.219.61' |
| Http Host | 'midwife-egg.com' |
| Ngx Cache Allcachemode | '1' |
| Ngx Cache Nocachemode | 'off' |
| Ngx Cache Staticmode | '1' |
| Ngx Cache Normalfile | '1' |
| Failurecachetime | '0' |
| Https | 'on' |
| Unique Id | 'ZoHl8mjBHDXEpH8LGx9HmQAAAaY' |
| Mef Proxy Addr | '162.43.101.45' |
| Redirect Status | '200' |
| Redirect Ngx Cache Allcachemode | '1' |
| Redirect Ngx Cache Nocachemode | 'off' |
| Redirect Ngx Cache Staticmode | '1' |
| Redirect Ngx Cache Normalfile | '1' |
| Redirect Failurecachetime | '0' |
| Redirect Https | 'on' |
| Redirect Unique Id | 'ZoHl8mjBHDXEpH8LGx9HmQAAAaY' |
| Redirect Mef Proxy Addr | '162.43.101.45' |
| Redirect Redirect Status | '200' |
| Redirect Redirect Ngx Cache Allcachemode | '1' |
| Redirect Redirect Ngx Cache Nocachemode | 'off' |
| Redirect Redirect Ngx Cache Staticmode | '1' |
| Redirect Redirect Ngx Cache Normalfile | '1' |
| Redirect Redirect Failurecachetime | '0' |
| Redirect Redirect Https | 'on' |
| Redirect Redirect Unique Id | 'ZoHl8mjBHDXEpH8LGx9HmQAAAaY' |
| Redirect Redirect Mef Proxy Addr | '162.43.101.45' |
| Fcgi Role | 'RESPONDER' |
| Php Self | '/app/webroot/index.php' |
| Request Time Float | (float) 1719789042.0101 |
| Request Time | (int) 1719789042 |