| Query | Error | Affected | Num. rows | Took (ms) | Actions |
|---|
| DESCRIBE `plugins` | | 4 | 4 | 1 | maybe slow |
| SELECT `Plugin`.`id`, `Plugin`.`name` FROM `plugins` AS `Plugin` WHERE `active` = 1 | | 11 | 11 | 0 | Explain |
| DESCRIBE `pages_settings` | | 9 | 9 | 1 | maybe slow |
| SELECT `PagesSetting`.`id`, `PagesSetting`.`name`, `PagesSetting`.`value`, `PagesSetting`.`description`, `PagesSetting`.`category`, `PagesSetting`.`input_type`, `PagesSetting`.`allow_markup`, `PagesSetting`.`super_admin`, `PagesSetting`.`options` FROM `pages_settings` AS `PagesSetting` WHERE 1 = 1 | | 17 | 17 | 0 | Explain |
| DESCRIBE `site_settings` | | 11 | 11 | 1 | maybe slow |
| SELECT `SiteSetting`.`id`, `SiteSetting`.`name`, `SiteSetting`.`value`, `SiteSetting`.`description`, `SiteSetting`.`category`, `SiteSetting`.`input_type`, `SiteSetting`.`allow_markup`, `SiteSetting`.`created_by_user_id`, `SiteSetting`.`modified_by_user_id`, `SiteSetting`.`super_admin`, `SiteSetting`.`options` FROM `site_settings` AS `SiteSetting` WHERE 1 = 1 | | 27 | 27 | 0 | Explain |
| DESCRIBE `users_settings` | | 9 | 9 | 1 | maybe slow |
| SELECT `UsersSetting`.`id`, `UsersSetting`.`name`, `UsersSetting`.`value`, `UsersSetting`.`description`, `UsersSetting`.`category`, `UsersSetting`.`input_type`, `UsersSetting`.`allow_markup`, `UsersSetting`.`super_admin`, `UsersSetting`.`options` FROM `users_settings` AS `UsersSetting` WHERE 1 = 1 | | 2 | 2 | 0 | Explain |
| DESCRIBE `email_forms_settings` | | 9 | 9 | 1 | maybe slow |
| SELECT `EmailFormsSetting`.`id`, `EmailFormsSetting`.`name`, `EmailFormsSetting`.`value`, `EmailFormsSetting`.`description`, `EmailFormsSetting`.`category`, `EmailFormsSetting`.`input_type`, `EmailFormsSetting`.`allow_markup`, `EmailFormsSetting`.`super_admin`, `EmailFormsSetting`.`options` FROM `email_forms_settings` AS `EmailFormsSetting` WHERE 1 = 1 | | 3 | 3 | 0 | Explain |
| DESCRIBE `navigation_settings` | | 9 | 9 | 1 | maybe slow |
| SELECT `NavigationSetting`.`id`, `NavigationSetting`.`name`, `NavigationSetting`.`value`, `NavigationSetting`.`description`, `NavigationSetting`.`category`, `NavigationSetting`.`input_type`, `NavigationSetting`.`allow_markup`, `NavigationSetting`.`super_admin`, `NavigationSetting`.`options` FROM `navigation_settings` AS `NavigationSetting` WHERE 1 = 1 | | 2 | 2 | 0 | Explain |
| DESCRIBE `prototype_settings` | | 9 | 9 | 1 | maybe slow |
| SELECT `PrototypeSetting`.`id`, `PrototypeSetting`.`name`, `PrototypeSetting`.`value`, `PrototypeSetting`.`description`, `PrototypeSetting`.`category`, `PrototypeSetting`.`input_type`, `PrototypeSetting`.`allow_markup`, `PrototypeSetting`.`super_admin`, `PrototypeSetting`.`options` FROM `prototype_settings` AS `PrototypeSetting` WHERE 1 = 1 | | 3 | 3 | 0 | Explain |
| DESCRIBE `blog_settings` | | 8 | 8 | 1 | maybe slow |
| SELECT `BlogSetting`.`id`, `BlogSetting`.`name`, `BlogSetting`.`value`, `BlogSetting`.`description`, `BlogSetting`.`category`, `BlogSetting`.`input_type`, `BlogSetting`.`super_admin`, `BlogSetting`.`options` FROM `blog_settings` AS `BlogSetting` WHERE 1 = 1 | | 12 | 12 | 0 | Explain |
| DESCRIBE `email_forms` | | 19 | 19 | 1 | maybe slow |
| DESCRIBE `email_form_fields` | | 11 | 11 | 1 | maybe slow |
| DESCRIBE `logs` | | 9 | 9 | 1 | maybe slow |
| DESCRIBE `users` | | 21 | 21 | 1 | |
| DESCRIBE `countries` | | 3 | 3 | 0 | |
| DESCRIBE `login_tokens` | | 7 | 7 | 1 | maybe slow |
| DESCRIBE `extra_fields` | | 6 | 6 | 1 | maybe slow |
| DESCRIBE `groups` | | 7 | 7 | 1 | maybe slow |
| DESCRIBE `permissions` | | 7 | 7 | 1 | maybe slow |
| DESCRIBE `groups_permissions` | | 3 | 3 | 0 | |
| DESCRIBE `groups_users` | | 3 | 3 | 0 | |
| SELECT `EmailForm`.`id`, `EmailForm`.`slug` FROM `email_forms` AS `EmailForm` WHERE 1 = 1 | | 3 | 3 | 0 | Explain |
| DESCRIBE `prototype_instances` | | 15 | 15 | 1 | maybe slow |
| DESCRIBE `uploader_attachments` | | 18 | 18 | 1 | maybe slow |
| DESCRIBE `prototype_categories` | | 11 | 11 | 1 | maybe slow |
| DESCRIBE `prototype_items` | | 13 | 13 | 1 | maybe slow |
| DESCRIBE `prototype_item_fields` | | 6 | 6 | 1 | maybe slow |
| DESCRIBE `prototype_category_fields` | | 6 | 6 | 1 | maybe slow |
| SELECT `PrototypeInstance`.`id`, `PrototypeInstance`.`slug` FROM `prototype_instances` AS `PrototypeInstance` WHERE 1 = 1 | | 5 | 5 | 0 | Explain |
| SELECT `PrototypeCategory`.`id`, `PrototypeCategory`.`slug` FROM `prototype_categories` AS `PrototypeCategory` WHERE 1 = 1 ORDER BY `PrototypeCategory`.`rank` ASC, `PrototypeCategory`.`name` ASC | | 9 | 9 | 0 | Explain |
| DESCRIBE `nav_items` | | 13 | 13 | 1 | maybe slow |
| DESCRIBE `nav_lists` | | 9 | 9 | 1 | maybe slow |
| SELECT `NavItem`.`id`, `NavItem`.`created`, `NavItem`.`modified`, `NavItem`.`name`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id`, `NavItem`.`url`, `NavItem`.`target_page`, `NavItem`.`rank`, `NavItem`.`created_by_user_id`, `NavItem`.`modified_by_user_id`, `NavList`.`id`, `NavList`.`created`, `NavList`.`modified`, `NavList`.`name`, `NavList`.`rank`, `NavList`.`comments`, `NavList`.`created_by_user_id`, `NavList`.`modified_by_user_id`, `NavList`.`sitemap` FROM `nav_items` AS `NavItem` LEFT JOIN `nav_lists` AS `NavList` ON (`NavItem`.`nav_list_id` = `NavList`.`id`) WHERE `nav_list_id` = 1 ORDER BY `NavItem`.`lft` ASC | | 11 | 11 | 0 | Explain |
| SELECT `PrototypeInstance`.`id`, `PrototypeInstance`.`name`, `PrototypeInstance`.`description`, `PrototypeInstance`.`rank`, `PrototypeInstance`.`slug`, `PrototypeInstance`.`created`, `PrototypeInstance`.`modified`, `PrototypeInstance`.`use_tags`, `PrototypeInstance`.`use_categories`, `PrototypeInstance`.`public`, `PrototypeInstance`.`rss_feed`, `PrototypeInstance`.`rss_order`, `PrototypeInstance`.`rss_name`, `PrototypeInstance`.`rss_amount`, `PrototypeInstance`.`footer_text` FROM `prototype_instances` AS `PrototypeInstance` WHERE `PrototypeInstance`.`slug` = 'buy-a-book' LIMIT 1 | | 1 | 1 | 0 | Explain |
| SELECT `ExtraField`.`id`, `ExtraField`.`foreign_key`, `ExtraField`.`key`, `ExtraField`.`val`, `ExtraField`.`type`, `ExtraField`.`foreign_model` FROM `extra_fields` AS `ExtraField` WHERE `ExtraField`.`foreign_model` = 'PrototypeInstance' AND `ExtraField`.`foreign_key` = (5) | | 17 | 17 | 0 | Explain |
| SELECT `PrototypeItemField`.`id`, `PrototypeItemField`.`name` FROM `prototype_item_fields` AS `PrototypeItemField` WHERE 1 = 1 | | 7 | 7 | 0 | Explain |
| SELECT `PrototypeItem`.`id`, `PrototypeItem`.`name`, `PrototypeItem`.`description`, `PrototypeItem`.`rank`, `PrototypeItem`.`created`, `PrototypeItem`.`modified`, `PrototypeItem`.`slug`, `PrototypeItem`.`prototype_instance_id`, `PrototypeItem`.`prototype_category_id`, `PrototypeItem`.`published`, `PrototypeItem`.`begin_publishing`, `PrototypeItem`.`end_publishing`, `PrototypeItem`.`featured`, `Image`.`id`, `Image`.`created`, `Image`.`modified`, `Image`.`foreign_model`, `Image`.`foreign_key`, `Image`.`rank`, `Image`.`filename`, `Image`.`caption`, `Image`.`type`, `Image`.`size`, `Image`.`group`, `Image`.`path`, `Image`.`thumbname`, `Image`.`begin_publishing`, `Image`.`end_publishing`, `Image`.`published`, `Image`.`created_by_user_id`, `Image`.`modified_by_user_id`, `Document`.`id`, `Document`.`created`, `Document`.`modified`, `Document`.`foreign_model`, `Document`.`foreign_key`, `Document`.`rank`, `Document`.`filename`, `Document`.`caption`, `Document`.`type`, `Document`.`size`, `Document`.`group`, `Document`.`path`, `Document`.`thumbname`, `Document`.`begin_publishing`, `Document`.`end_publishing`, `Document`.`published`, `Document`.`created_by_user_id`, `Document`.`modified_by_user_id` FROM `prototype_items` AS `PrototypeItem` LEFT JOIN `uploader_attachments` AS `Image` ON (`Image`.`foreign_key` = `PrototypeItem`.`id` AND `Image`.`foreign_model` = 'Prototype.PrototypeItem' AND `Image`.`group` = 'image') LEFT JOIN `uploader_attachments` AS `Document` ON (`Document`.`foreign_key` = `PrototypeItem`.`id` AND `Document`.`foreign_model` = 'Prototype.PrototypeItem' AND `Document`.`group` = 'document') WHERE `PrototypeItem`.`slug` = 'hiking-trails-2-south-central-vancouver-island-and-the-gulf-island' AND `PrototypeItem`.`prototype_instance_id` = 5 AND `PrototypeItem`.`published` = 1 AND `PrototypeItem`.`begin_publishing` <= '2012-02-07 13:28:45' AND ((`PrototypeItem`.`end_publishing` IS NULL) OR (`PrototypeItem`.`end_publishing` > '2012-02-07 13:28:45')) ORDER BY `PrototypeItem`.`rank` ASC, `PrototypeItem`.`rank` ASC, `PrototypeItem`.`name` ASC LIMIT 1 | | 1 | 1 | 2 | maybe slowExplain |
| SELECT `Gallery`.`id`, `Gallery`.`created`, `Gallery`.`modified`, `Gallery`.`foreign_model`, `Gallery`.`foreign_key`, `Gallery`.`rank`, `Gallery`.`filename`, `Gallery`.`caption`, `Gallery`.`type`, `Gallery`.`size`, `Gallery`.`group`, `Gallery`.`path`, `Gallery`.`thumbname`, `Gallery`.`begin_publishing`, `Gallery`.`end_publishing`, `Gallery`.`published`, `Gallery`.`created_by_user_id`, `Gallery`.`modified_by_user_id` FROM `uploader_attachments` AS `Gallery` WHERE `Gallery`.`foreign_model` = 'Prototype.PrototypeItem' AND `Gallery`.`group` = 'gallery' AND `Gallery`.`foreign_key` = (57) ORDER BY `Gallery`.`rank` ASC | | 2 | 2 | 1 | maybe slowExplain |
| SELECT `Repository`.`id`, `Repository`.`created`, `Repository`.`modified`, `Repository`.`foreign_model`, `Repository`.`foreign_key`, `Repository`.`rank`, `Repository`.`filename`, `Repository`.`caption`, `Repository`.`type`, `Repository`.`size`, `Repository`.`group`, `Repository`.`path`, `Repository`.`thumbname`, `Repository`.`begin_publishing`, `Repository`.`end_publishing`, `Repository`.`published`, `Repository`.`created_by_user_id`, `Repository`.`modified_by_user_id` FROM `uploader_attachments` AS `Repository` WHERE `Repository`.`foreign_model` = 'Prototype.PrototypeItem' AND `Repository`.`group` = 'repository' AND `Repository`.`foreign_key` = (57) ORDER BY `Repository`.`rank` ASC | | 0 | 0 | 0 | Explain |
| SELECT `ExtraField`.`id`, `ExtraField`.`foreign_key`, `ExtraField`.`key`, `ExtraField`.`val`, `ExtraField`.`type`, `ExtraField`.`foreign_model` FROM `extra_fields` AS `ExtraField` WHERE `ExtraField`.`foreign_model` = 'PrototypeItem' AND `ExtraField`.`foreign_key` = (57) | | 2 | 2 | 0 | Explain |
| DESCRIBE `pages` | | 26 | 26 | 1 | |
| SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`title`, `Page`.`content`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`status`, `Page`.`begin_publishing`, `Page`.`end_publishing`, `Page`.`layout`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`full_page`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`plugin`, `Page`.`exclude_sitemap`, `Page`.`created_by_user_id`, `Page`.`modified_by_user_id` FROM `pages` AS `Page` WHERE `controller` = 'prototype_items' AND `action` = 'view' LIMIT 1 | | 0 | 0 | 0 | Explain |
| SELECT `PrototypeInstance`.`id`, `PrototypeInstance`.`name`, `PrototypeInstance`.`description`, `PrototypeInstance`.`rank`, `PrototypeInstance`.`slug`, `PrototypeInstance`.`created`, `PrototypeInstance`.`modified`, `PrototypeInstance`.`use_tags`, `PrototypeInstance`.`use_categories`, `PrototypeInstance`.`public`, `PrototypeInstance`.`rss_feed`, `PrototypeInstance`.`rss_order`, `PrototypeInstance`.`rss_name`, `PrototypeInstance`.`rss_amount`, `PrototypeInstance`.`footer_text` FROM `prototype_instances` AS `PrototypeInstance` WHERE 1 = 1 | | 5 | 5 | 0 | Explain |
| SELECT `ExtraField`.`id`, `ExtraField`.`foreign_key`, `ExtraField`.`key`, `ExtraField`.`val`, `ExtraField`.`type`, `ExtraField`.`foreign_model` FROM `extra_fields` AS `ExtraField` WHERE `ExtraField`.`foreign_model` = 'PrototypeInstance' AND `ExtraField`.`foreign_key` IN (1, 2, 3, 5, 6) | | 78 | 78 | 1 | Explain |
| SELECT `ExtraField`.`id`, `ExtraField`.`foreign_key` FROM `extra_fields` AS `ExtraField` WHERE `ExtraField`.`key` = 'load as slideshow' AND `ExtraField`.`val` = '1' AND `ExtraField`.`foreign_model` = 'PrototypeItem' | | 1 | 1 | 0 | Explain |
| SELECT `PrototypeItem`.`id`, `PrototypeItem`.`name`, `PrototypeItem`.`description`, `PrototypeItem`.`rank`, `PrototypeItem`.`created`, `PrototypeItem`.`modified`, `PrototypeItem`.`slug`, `PrototypeItem`.`prototype_instance_id`, `PrototypeItem`.`prototype_category_id`, `PrototypeItem`.`published`, `PrototypeItem`.`begin_publishing`, `PrototypeItem`.`end_publishing`, `PrototypeItem`.`featured`, `PrototypeInstance`.`id`, `PrototypeInstance`.`name`, `PrototypeInstance`.`description`, `PrototypeInstance`.`rank`, `PrototypeInstance`.`slug`, `PrototypeInstance`.`created`, `PrototypeInstance`.`modified`, `PrototypeInstance`.`use_tags`, `PrototypeInstance`.`use_categories`, `PrototypeInstance`.`public`, `PrototypeInstance`.`rss_feed`, `PrototypeInstance`.`rss_order`, `PrototypeInstance`.`rss_name`, `PrototypeInstance`.`rss_amount`, `PrototypeInstance`.`footer_text` FROM `prototype_items` AS `PrototypeItem` LEFT JOIN `prototype_instances` AS `PrototypeInstance` ON (`PrototypeItem`.`prototype_instance_id` = `PrototypeInstance`.`id`) WHERE `PrototypeItem`.`id` = (59) AND `PrototypeItem`.`published` = 1 AND `PrototypeItem`.`begin_publishing` <= '2012-02-07 13:28:45' AND ((`PrototypeItem`.`end_publishing` IS NULL) OR (`PrototypeItem`.`end_publishing` > '2012-02-07 13:28:45')) ORDER BY `PrototypeItem`.`rank` ASC, `PrototypeItem`.`rank` ASC, `PrototypeItem`.`name` ASC | | 1 | 1 | 0 | Explain |
| SELECT `Gallery`.`id`, `Gallery`.`created`, `Gallery`.`modified`, `Gallery`.`foreign_model`, `Gallery`.`foreign_key`, `Gallery`.`rank`, `Gallery`.`filename`, `Gallery`.`caption`, `Gallery`.`type`, `Gallery`.`size`, `Gallery`.`group`, `Gallery`.`path`, `Gallery`.`thumbname`, `Gallery`.`begin_publishing`, `Gallery`.`end_publishing`, `Gallery`.`published`, `Gallery`.`created_by_user_id`, `Gallery`.`modified_by_user_id` FROM `uploader_attachments` AS `Gallery` WHERE `Gallery`.`foreign_model` = 'Prototype.PrototypeItem' AND `Gallery`.`group` = 'gallery' AND `Gallery`.`foreign_key` = (59) ORDER BY `Gallery`.`rank` ASC | | 19 | 19 | 1 | maybe slowExplain |
| SELECT `ExtraField`.`id`, `ExtraField`.`foreign_key`, `ExtraField`.`key`, `ExtraField`.`val`, `ExtraField`.`type`, `ExtraField`.`foreign_model` FROM `extra_fields` AS `ExtraField` WHERE `ExtraField`.`foreign_model` = 'PrototypeItem' AND `ExtraField`.`foreign_key` = (59) | | 2 | 2 | 0 | Explain |
| SELECT `NavList`.`id` FROM `nav_lists` AS `NavList` WHERE `NavList`.`name` = 'Books Navigation' LIMIT 1 | | 1 | 1 | 1 | Explain |
| SELECT `NavItem`.`id`, `NavItem`.`created`, `NavItem`.`modified`, `NavItem`.`name`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id`, `NavItem`.`url`, `NavItem`.`target_page`, `NavItem`.`rank`, `NavItem`.`created_by_user_id`, `NavItem`.`modified_by_user_id`, `NavList`.`id`, `NavList`.`created`, `NavList`.`modified`, `NavList`.`name`, `NavList`.`rank`, `NavList`.`comments`, `NavList`.`created_by_user_id`, `NavList`.`modified_by_user_id`, `NavList`.`sitemap` FROM `nav_items` AS `NavItem` LEFT JOIN `nav_lists` AS `NavList` ON (`NavItem`.`nav_list_id` = `NavList`.`id`) WHERE `NavItem`.`nav_list_id` = 3 ORDER BY `NavItem`.`lft` ASC | | 3 | 3 | 0 | Explain |
| SELECT `NavList`.`id` FROM `nav_lists` AS `NavList` WHERE `NavList`.`name` = 'Sub Navigation' LIMIT 1 | | 1 | 1 | 0 | Explain |
| SELECT `NavItem`.`id`, `NavItem`.`created`, `NavItem`.`modified`, `NavItem`.`name`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id`, `NavItem`.`url`, `NavItem`.`target_page`, `NavItem`.`rank`, `NavItem`.`created_by_user_id`, `NavItem`.`modified_by_user_id`, `NavList`.`id`, `NavList`.`created`, `NavList`.`modified`, `NavList`.`name`, `NavList`.`rank`, `NavList`.`comments`, `NavList`.`created_by_user_id`, `NavList`.`modified_by_user_id`, `NavList`.`sitemap` FROM `nav_items` AS `NavItem` LEFT JOIN `nav_lists` AS `NavList` ON (`NavItem`.`nav_list_id` = `NavList`.`id`) WHERE `NavItem`.`nav_list_id` = 2 ORDER BY `NavItem`.`lft` ASC | | 3 | 3 | 0 | Explain |
| SELECT `NavItem`.`id`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id` FROM `nav_items` AS `NavItem` WHERE `NavItem`.`id` = 1 ORDER BY `NavItem`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 | Explain |
| SELECT `NavItem`.`id`, `NavItem`.`created`, `NavItem`.`modified`, `NavItem`.`name`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id`, `NavItem`.`url`, `NavItem`.`target_page`, `NavItem`.`rank`, `NavItem`.`created_by_user_id`, `NavItem`.`modified_by_user_id` FROM `nav_items` AS `NavItem` WHERE `NavItem`.`id` IS NULL ORDER BY `NavItem`.`lft` ASC LIMIT 1 | | 0 | 0 | 0 | Explain |
| SELECT `NavItem`.`id`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id` FROM `nav_items` AS `NavItem` WHERE `NavItem`.`id` = 2 ORDER BY `NavItem`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 | Explain |
| SELECT `NavItem`.`id`, `NavItem`.`created`, `NavItem`.`modified`, `NavItem`.`name`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id`, `NavItem`.`url`, `NavItem`.`target_page`, `NavItem`.`rank`, `NavItem`.`created_by_user_id`, `NavItem`.`modified_by_user_id` FROM `nav_items` AS `NavItem` WHERE `NavItem`.`id` IS NULL ORDER BY `NavItem`.`lft` ASC LIMIT 1 | | 0 | 0 | 0 | Explain |
| SELECT `NavItem`.`id`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id` FROM `nav_items` AS `NavItem` WHERE `NavItem`.`id` = 3 ORDER BY `NavItem`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 | Explain |
| SELECT `NavItem`.`id`, `NavItem`.`created`, `NavItem`.`modified`, `NavItem`.`name`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id`, `NavItem`.`url`, `NavItem`.`target_page`, `NavItem`.`rank`, `NavItem`.`created_by_user_id`, `NavItem`.`modified_by_user_id` FROM `nav_items` AS `NavItem` WHERE `NavItem`.`id` IS NULL ORDER BY `NavItem`.`lft` ASC LIMIT 1 | | 0 | 0 | 0 | Explain |
| SELECT `NavItem`.`id`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id` FROM `nav_items` AS `NavItem` WHERE `NavItem`.`id` = 4 ORDER BY `NavItem`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 | Explain |
| SELECT `NavItem`.`id`, `NavItem`.`created`, `NavItem`.`modified`, `NavItem`.`name`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id`, `NavItem`.`url`, `NavItem`.`target_page`, `NavItem`.`rank`, `NavItem`.`created_by_user_id`, `NavItem`.`modified_by_user_id` FROM `nav_items` AS `NavItem` WHERE `NavItem`.`id` IS NULL ORDER BY `NavItem`.`lft` ASC LIMIT 1 | | 0 | 0 | 0 | Explain |
| SELECT `NavItem`.`id`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id` FROM `nav_items` AS `NavItem` WHERE `NavItem`.`id` = 5 ORDER BY `NavItem`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 | Explain |
| SELECT `NavItem`.`id`, `NavItem`.`created`, `NavItem`.`modified`, `NavItem`.`name`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id`, `NavItem`.`url`, `NavItem`.`target_page`, `NavItem`.`rank`, `NavItem`.`created_by_user_id`, `NavItem`.`modified_by_user_id` FROM `nav_items` AS `NavItem` WHERE `NavItem`.`id` IS NULL ORDER BY `NavItem`.`lft` ASC LIMIT 1 | | 0 | 0 | 0 | Explain |
| SELECT `NavItem`.`id`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id` FROM `nav_items` AS `NavItem` WHERE `NavItem`.`id` = 6 ORDER BY `NavItem`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 | Explain |
| SELECT `NavItem`.`id`, `NavItem`.`created`, `NavItem`.`modified`, `NavItem`.`name`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id`, `NavItem`.`url`, `NavItem`.`target_page`, `NavItem`.`rank`, `NavItem`.`created_by_user_id`, `NavItem`.`modified_by_user_id` FROM `nav_items` AS `NavItem` WHERE `NavItem`.`id` IS NULL ORDER BY `NavItem`.`lft` ASC LIMIT 1 | | 0 | 0 | 0 | Explain |
| SELECT `NavItem`.`id`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id` FROM `nav_items` AS `NavItem` WHERE `NavItem`.`id` = 7 ORDER BY `NavItem`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 | Explain |
| SELECT `NavItem`.`id`, `NavItem`.`created`, `NavItem`.`modified`, `NavItem`.`name`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id`, `NavItem`.`url`, `NavItem`.`target_page`, `NavItem`.`rank`, `NavItem`.`created_by_user_id`, `NavItem`.`modified_by_user_id` FROM `nav_items` AS `NavItem` WHERE `NavItem`.`id` IS NULL ORDER BY `NavItem`.`lft` ASC LIMIT 1 | | 0 | 0 | 0 | Explain |
| SELECT `NavItem`.`id`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id` FROM `nav_items` AS `NavItem` WHERE `NavItem`.`id` = 8 ORDER BY `NavItem`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 | Explain |
| SELECT `NavItem`.`id`, `NavItem`.`created`, `NavItem`.`modified`, `NavItem`.`name`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id`, `NavItem`.`url`, `NavItem`.`target_page`, `NavItem`.`rank`, `NavItem`.`created_by_user_id`, `NavItem`.`modified_by_user_id` FROM `nav_items` AS `NavItem` WHERE `NavItem`.`id` IS NULL ORDER BY `NavItem`.`lft` ASC LIMIT 1 | | 0 | 0 | 0 | Explain |
| SELECT `NavItem`.`id`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id` FROM `nav_items` AS `NavItem` WHERE `NavItem`.`id` = 9 ORDER BY `NavItem`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 | Explain |
| SELECT `NavItem`.`id`, `NavItem`.`created`, `NavItem`.`modified`, `NavItem`.`name`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id`, `NavItem`.`url`, `NavItem`.`target_page`, `NavItem`.`rank`, `NavItem`.`created_by_user_id`, `NavItem`.`modified_by_user_id` FROM `nav_items` AS `NavItem` WHERE `NavItem`.`id` IS NULL ORDER BY `NavItem`.`lft` ASC LIMIT 1 | | 0 | 0 | 0 | Explain |
| SELECT `NavItem`.`id`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id` FROM `nav_items` AS `NavItem` WHERE `NavItem`.`id` = 20 ORDER BY `NavItem`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 | Explain |
| SELECT `NavItem`.`id`, `NavItem`.`created`, `NavItem`.`modified`, `NavItem`.`name`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id`, `NavItem`.`url`, `NavItem`.`target_page`, `NavItem`.`rank`, `NavItem`.`created_by_user_id`, `NavItem`.`modified_by_user_id` FROM `nav_items` AS `NavItem` WHERE `NavItem`.`id` IS NULL ORDER BY `NavItem`.`lft` ASC LIMIT 1 | | 0 | 0 | 0 | Explain |
| SELECT `NavItem`.`id`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id` FROM `nav_items` AS `NavItem` WHERE `NavItem`.`id` = 21 ORDER BY `NavItem`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 | Explain |
| SELECT `NavItem`.`id`, `NavItem`.`created`, `NavItem`.`modified`, `NavItem`.`name`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id`, `NavItem`.`url`, `NavItem`.`target_page`, `NavItem`.`rank`, `NavItem`.`created_by_user_id`, `NavItem`.`modified_by_user_id` FROM `nav_items` AS `NavItem` WHERE `NavItem`.`id` IS NULL ORDER BY `NavItem`.`lft` ASC LIMIT 1 | | 0 | 0 | 0 | Explain |