Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Page`.`weight` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE `Page`.`id` = 4 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` = 4 AND `PagesLanguage`.`language_id` = 2 LIMIT 1 | 1 | 1 | 0 | |
SELECT `PluginsRoom`.`plugin_key` FROM `hijiri3_hijirigaoka`.`plugins_rooms` AS `PluginsRoom` WHERE `room_id` = 1 | 22 | 22 | 0 | |
SELECT `BlockRolePermission`.`id`, `BlockRolePermission`.`roles_room_id`, `BlockRolePermission`.`block_key`, `BlockRolePermission`.`permission`, `BlockRolePermission`.`value` FROM `hijiri3_hijirigaoka`.`block_role_permissions` AS `BlockRolePermission` WHERE `block_key` IS NULL AND `roles_room_id` IS NULL | 0 | 0 | 0 | |
SELECT `BlockSetting`.`block_key`, `BlockSetting`.`field_name`, `BlockSetting`.`value` FROM `hijiri3_hijirigaoka`.`block_settings` AS `BlockSetting` WHERE `room_id` = 1 AND `block_key` IS NULL AND `field_name` IN ('use_workflow', 'use_comment_approval') | 0 | 0 | 0 | |
SELECT `PageContainer`.`id`, `PageContainer`.`page_id`, `PageContainer`.`container_type`, `PageContainer`.`is_published`, `PageContainer`.`is_configured` FROM `hijiri3_hijirigaoka`.`page_containers` AS `PageContainer` WHERE `PageContainer`.`page_id` = 4 | 5 | 5 | 4 | 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 (16, 17, 18, 19, 20) AND `BoxesPageContainer`.`is_published` = '1' ORDER BY `BoxesPageContainer`.`page_container_id` ASC, `BoxesPageContainer`.`weight` ASC | 6 | 6 | 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 (51, 18, 24, 16, 19, 54) AND `Frame`.`is_deleted` = '0' ORDER BY `Frame`.`box_id` ASC, `Frame`.`is_deleted` ASC, `Frame`.`weight` ASC | 91 | 91 | 5 | maybe slow |
SELECT `Page`.`sort_key` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE `Page`.`id` = 4 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Page`.`id` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE 1 = 1 AND `Page`.`sort_key` IN ('~00000001', '~00000001-00000001') ORDER BY `Page`.`sort_key` asc | 2 | 2 | 0 | |
SELECT `Page`.`theme` FROM `hijiri3_hijirigaoka`.`pages` AS `Page` WHERE `id` IN (1, 4) AND `theme` IS NOT NULL ORDER BY `sort_key` desc LIMIT 1 | 1 | 1 | 0 | |
SELECT `MailSetting`.`id`, `MailSetting`.`plugin_key`, `MailSetting`.`block_key`, `MailSetting`.`is_mail_send`, `MailSetting`.`is_mail_send_approval`, `MailSetting`.`reply_to`, `MailSetting`.`created_user`, `MailSetting`.`created`, `MailSetting`.`modified_user`, `MailSetting`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `hijiri3_hijirigaoka`.`mail_settings` AS `MailSetting` LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`MailSetting`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`MailSetting`.`modified_user` = `TrackableUpdater`.`id`) WHERE `plugin_key` = 'auth' AND `block_key` IS NULL LIMIT 1 | 1 | 1 | 1 | |
SELECT `MailSettingFixedPhrase`.`id`, `MailSettingFixedPhrase`.`mail_setting_id`, `MailSettingFixedPhrase`.`language_id`, `MailSettingFixedPhrase`.`is_origin`, `MailSettingFixedPhrase`.`is_translation`, `MailSettingFixedPhrase`.`is_original_copy`, `MailSettingFixedPhrase`.`plugin_key`, `MailSettingFixedPhrase`.`block_key`, `MailSettingFixedPhrase`.`type_key`, `MailSettingFixedPhrase`.`mail_fixed_phrase_subject`, `MailSettingFixedPhrase`.`mail_fixed_phrase_body`, `MailSettingFixedPhrase`.`created_user`, `MailSettingFixedPhrase`.`created`, `MailSettingFixedPhrase`.`modified_user`, `MailSettingFixedPhrase`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `hijiri3_hijirigaoka`.`mail_setting_fixed_phrases` AS `MailSettingFixedPhrase` LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`MailSettingFixedPhrase`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`MailSettingFixedPhrase`.`modified_user` = `TrackableUpdater`.`id`) WHERE `plugin_key` = 'auth' AND `block_key` IS NULL AND `language_id` = 2 AND `type_key` = 'auth' LIMIT 1 | 0 | 0 | 0 | |
SELECT `MailSettingFixedPhrase`.`id`, `MailSettingFixedPhrase`.`mail_setting_id`, `MailSettingFixedPhrase`.`language_id`, `MailSettingFixedPhrase`.`is_origin`, `MailSettingFixedPhrase`.`is_translation`, `MailSettingFixedPhrase`.`is_original_copy`, `MailSettingFixedPhrase`.`plugin_key`, `MailSettingFixedPhrase`.`block_key`, `MailSettingFixedPhrase`.`type_key`, `MailSettingFixedPhrase`.`mail_fixed_phrase_subject`, `MailSettingFixedPhrase`.`mail_fixed_phrase_body`, `MailSettingFixedPhrase`.`created_user`, `MailSettingFixedPhrase`.`created`, `MailSettingFixedPhrase`.`modified_user`, `MailSettingFixedPhrase`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `hijiri3_hijirigaoka`.`mail_setting_fixed_phrases` AS `MailSettingFixedPhrase` LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableCreator` ON (`MailSettingFixedPhrase`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `hijiri3_hijirigaoka`.`users` AS `TrackableUpdater` ON (`MailSettingFixedPhrase`.`modified_user` = `TrackableUpdater`.`id`) WHERE `language_id` = 2 AND `plugin_key` IS NULL AND `block_key` IS NULL AND `type_key` = 'auth' LIMIT 1 | 0 | 0 | 0 | |