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_20200429001253/page_20201230072921' AND `Room`.`space_id` = 2 | 1 | 1 | 1 | |
SELECT `Page`.`weight` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE `Page`.`id` = 4 LIMIT 1 | 1 | 1 | 0 | |
SELECT `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_20200429001253/page_20201230072921' 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` = 163 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` = 163 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 | 1 | maybe slow |
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` = 163 | 5 | 5 | 3 | maybe slow |
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 (811, 812, 813, 814, 815) 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, 1358, 19, 45) AND `Frame`.`is_deleted` = '0' ORDER BY `Frame`.`box_id` ASC, `Frame`.`is_deleted` ASC, `Frame`.`weight` ASC | 74 | 74 | 8 | maybe slow |
SELECT `Page`.`sort_key` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE `Page`.`id` = 163 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Page`.`id` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE 1 = 1 AND `Page`.`sort_key` IN ('~00000001', '~00000001-00000006', '~00000001-00000006-00000001') ORDER BY `Page`.`sort_key` asc | 3 | 3 | 0 | |
SELECT `Page`.`theme` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE `id` IN (1, 21, 163) 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_20200429001253/page_20201230072921' AND `Room`.`space_id` = '2' | 1 | 1 | 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` = '7afb96c2c5fde6c50f9bc34326423853' 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` = 219 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 | 489 | 489 | 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` = '12c11155ee53dac74b7dae275a54d376' 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` = 218 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '588184994bbdc759f58b7bb543aa5bff' 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` = 217 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '100873b65c9c9c9efee6c0cc51e10f45' 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` = 216 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '5783c3919af1b5dfad636929db80dfe4' 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` = 215 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '8ded0904ebdf99f1724e4f6f9fc652d7' 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` = 214 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '3e0b012b681f9878d3aaa60d59c2fe17' 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` = 213 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '37c783ffd17d2c6d77b11a4f25cbed90' 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` = 212 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '616904736f473308d00c88479d9581a1' 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` = 211 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '57bc2db88e5b02d1852a2cc95f082d2f' 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` = 210 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '3ebd10ddfdb4c919605ef5ec14b4d754' 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` = 209 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = 'aa19a76915cd35756e5ec0c5bd8a9385' AND `roles_room_id` IS NULL | 0 | 0 | 1 | maybe slow |
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` = 208 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = 'b1e3d83a85b09e79da966ee7fa86e481' AND `roles_room_id` IS NULL | 0 | 0 | 1 | maybe slow |
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` = 205 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '90da3ab457f5964e0d00b8123745a963' 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` = 204 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = 'b2e7883706ee98ab818835be9d2c1294' 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` = 203 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '4d65b870e4df66e7f07ec4eb8bc57a84' 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` = 202 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '47c6c2ded5f0881058a2c896c5651edf' 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` = 201 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '121a98c271e7000d2ba1f86ea430aaca' 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` = 200 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = 'b7fd1fd4d85dcd9af982af558e0754ac' 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` = 199 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '50e194816ed609b205ba1858aac98fe9' 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` = 198 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '7870115668409d76810c96a6d7334a56' 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` = 197 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '1addc4660c06e4f9dfcae55a853285eb' 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` = 196 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '6294b66614f0245431816c682a93a11e' 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` = 195 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = 'e5557283bb3dcf5f4f6917a722ebe95b' 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` = 194 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '4713390daf0605c19be729b60c9110e2' 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` = 193 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '13b207b97b8a4edb196ceee42f22309b' 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` = 192 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '7bb3cac97e96ddf8361a119c557ad0a9' AND `roles_room_id` IS NULL | 0 | 0 | 1 | maybe slow |
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` = 191 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '6afa24de7a64950c9c0c4911d64cab6b' 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` = 190 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = 'f763ad227eea58121ecd9b84007ddc31' 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` = 189 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '9e63e628609ae0f4ce18741454689c32' 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` = 188 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '4ae695386e287764c7a2beca3c3bb6e1' 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` = 187 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '26ca7583113419a3ea9611186572cbea' 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` = 186 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = 'b6367b558bfca108109aceb50af983c0' 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` = 185 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '7f538877c20a28feaeb49325365000fd' 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` = 184 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '4239dd56de16c23116f36f7a740032b3' 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` = 183 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '2a701ef9ce1e823e8cb55879a5292fe0' 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` = 182 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '12b58c2aa1c3a06de372bb8dbd35e04b' 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` = 181 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '3236078e36a6eb0229e19ef657233461' AND `roles_room_id` IS NULL | 0 | 0 | 2 | maybe slow |
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` = 180 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '9e78221a2d4fbc9eb932883dba3dfb92' 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` = 179 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '1c9b40b8a2c3a192ef21962bb5f87498' AND `roles_room_id` IS NULL | 0 | 0 | 1 | maybe slow |
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` = 178 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '219ebbb0220073b48ad0f972983af87e' AND `roles_room_id` IS NULL | 0 | 0 | 1 | maybe slow |
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` = 177 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = 'f2bed08ef441be4b9e30376697e8d2c8' 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` = 176 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '27cbb92b7e390746587fab41793a4f6e' 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` = 175 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = 'fc06cf33d90828200398277eeecf7e6e' 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` = 174 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '29afb989e3f4189635496b6e008f9114' 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` = 173 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = 'df6716d27d89bd704d7ee6587d079868' 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` = 172 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = 'caf9ff79ead13318c87acba793ba3cb9' 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` = 171 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = 'b3643a2cca3648f8dfbfeb16fed9e73e' 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` = 170 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '3d6622cbd7b0f68945ffe180e95bac89' 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` = 169 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '1b6c4fbe346a00539abb0230a2a2b511' 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` = 168 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '730547212b36d7c70b8ac42af255d1fc' 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` = 167 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = 'dfc3795873a4c844f69767e113f709a3' 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` = 166 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = 'f0e7f7dd868112b53fbf0222b9d64b64' AND `roles_room_id` IS NULL | 0 | 0 | 1 | maybe slow |
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` = 165 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = 'bc16dc1a55ff4db615bd6643b99ed1ce' AND `roles_room_id` IS NULL | 0 | 0 | 1 | maybe slow |
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` = 164 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = 'bd859267fbb55b03763e8aacf5dcb44f' 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` = 163 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = 'e923147b3b328d93e823293a70541f1c' AND `roles_room_id` IS NULL | 0 | 0 | 1 | maybe slow |
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` = 162 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '8e2687a28781f124a98b3fb03e8ec67f' 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` = 161 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '2073f136a2bff908b6696634b93868ad' 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` = 160 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = 'ee296979a97552f8872345ec2a3b8d01' 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` = 159 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '361c2def279391c61f89ea8b8844082f' 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` = 158 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '4b3065a10dd866f3ee059ce11874be37' 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` = 157 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = 'f1ee1426791af9695a07b77dc6ecc755' 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` = 156 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '0dde42329794d505e63b54e5de483198' 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` = 155 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '7241c0d10051343368084efc6a2d5e7f' 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` = 154 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '53ffa3e56df9b51ae6a5f08b6a179528' 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` = 153 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '4d01c1932f531a08827dcb9d1530cb47' 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` = 152 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '0d035355af241fbb20edb4246db3e8ea' 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` = 151 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = 'a6ca3b9b029c8e04d59de6c9a496b84b' 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` = 150 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '06ad577d61ee107df074be512c069da1' 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` = 149 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '1a2ff36edff0c02137afb7520b5d584c' 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` = 148 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = 'afbe1062b15873bc5c885ccf0e3974f2' AND `roles_room_id` IS NULL | 0 | 0 | 1 | maybe slow |
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` = 147 AND `Block`.`room_id` = 1 AND `Announcement`.`language_id` = 2 AND `Announcement`.`is_active` = '1' LIMIT 1 | 1 | 1 | 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` = '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 | 31 | 31 | 2 | maybe slow |
SELECT `MenuFrameSetting`.`id`, `MenuFrameSetting`.`frame_key`, `MenuFrameSetting`.`display_type`, `MenuFrameSetting`.`is_private_room_hidden`, `MenuFrameSetting`.`created_user`, `MenuFrameSetting`.`created`, `MenuFrameSetting`.`modified_user`, `MenuFrameSetting`.`modified` FROM `hijiri3_hijirigaoka`.`menu_frame_settings` AS `MenuFrameSetting` WHERE `frame_key` = '29b46e9c15a12b52ecfa412c120234e8' LIMIT 1 | 1 | 1 | 1 | |
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) | 31 | 31 | 2 | maybe slow |
SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`weight`, `Page`.`sort_key`, `Page`.`child_count`, `Page`.`permalink`, `Page`.`slug`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Space`.`id`, `Space`.`permalink` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` LEFT JOIN `hijiri3_hijirigaoka`.`rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`pages` AS `ParentPage` ON (`Page`.`parent_id` = `ParentPage`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`Page`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`Page`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) WHERE `Page`.`id` IN (1, 4, 8, 9, 12, 13, 21, 158, 162, 163, 179, 198, 201, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 227, 251, 252, 279, 288, 289, 328, 329) | 31 | 31 | 1 | |
SELECT `ChildPage`.`id`, `ChildPage`.`room_id`, `ChildPage`.`root_id`, `ChildPage`.`parent_id`, `ChildPage`.`lft`, `ChildPage`.`rght`, `ChildPage`.`weight`, `ChildPage`.`sort_key`, `ChildPage`.`child_count`, `ChildPage`.`permalink`, `ChildPage`.`slug`, `ChildPage`.`is_container_fluid`, `ChildPage`.`theme`, `ChildPage`.`created_user`, `ChildPage`.`created`, `ChildPage`.`modified_user`, `ChildPage`.`modified` FROM `hijiri3_hijirigaoka`.`pages` AS `ChildPage` WHERE `ChildPage`.`parent_id` IN (1, 4, 8, 9, 12, 13, 21, 158, 162, 163, 179, 198, 201, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 227, 251, 252, 279, 288, 289, 328, 329) | 30 | 30 | 2 | maybe slow |
SELECT `Page`.`sort_key` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE `Page`.`id` = 163 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-00000006', '~00000001-00000006-00000001') ORDER BY `Page`.`sort_key` asc | 3 | 3 | 1 | maybe slow |
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 | 31 | 31 | 2 | maybe slow |
SELECT `Page`.`sort_key` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE `Page`.`id` = 163 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-00000006', '~00000001-00000006-00000001') ORDER BY `Page`.`sort_key` asc | 3 | 3 | 1 | maybe slow |
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 | 31 | 31 | 1 | |
SELECT `MenuFrameSetting`.`id`, `MenuFrameSetting`.`frame_key`, `MenuFrameSetting`.`display_type`, `MenuFrameSetting`.`is_private_room_hidden`, `MenuFrameSetting`.`created_user`, `MenuFrameSetting`.`created`, `MenuFrameSetting`.`modified_user`, `MenuFrameSetting`.`modified` FROM `hijiri3_hijirigaoka`.`menu_frame_settings` AS `MenuFrameSetting` WHERE `frame_key` = '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 | 1 | |
SELECT `Page`.`sort_key` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE `Page`.`id` = 163 LIMIT 1 | 1 | 1 | 1 | |
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-00000006', '~00000001-00000006-00000001') ORDER BY `Page`.`sort_key` asc | 3 | 3 | 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 | 31 | 31 | 1 | |
SELECT `Page`.`sort_key` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE `Page`.`id` = 163 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-00000006', '~00000001-00000006-00000001') ORDER BY `Page`.`sort_key` asc | 3 | 3 | 1 | maybe slow |
10 duplicate queries run.