| Query | Error | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Route`.`url`, `Route`.`prefix`, `Route`.`plugin`, `Route`.`controller`, `Route`.`action`, `Route`.`values`, `Route`.`pass`, `Route`.`rules`, `Route`.`force_backend`, `Route`.`force_frontend`, `Route`.`theme_id`, `Theme`.`id`, `Theme`.`name` FROM `core_routes` AS `Route` LEFT JOIN `core_themes` AS `Theme` ON (`Route`.`theme_id` = `Theme`.`id`) WHERE `Route`.`active` = 1 ORDER BY `Route`.`ordering` ASC | | 14 | 14 | 0 | Explain |
| SELECT `Theme`.`id`, `Theme`.`name`, `Theme`.`description`, `Theme`.`author`, `Theme`.`url`, `Theme`.`update_url`, `Theme`.`licence`, `Theme`.`active`, `Theme`.`core`, `Theme`.`created`, `Theme`.`modified` FROM `core_themes` AS `Theme` WHERE `Theme`.`active` = 1 LIMIT 1 | | 1 | 1 | 0 | Explain |
| SELECT `User`.`id`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`active`, `User`.`created`, `User`.`modified` FROM `core_users` AS `User` WHERE `User`.`id` = 1 LIMIT 1 | | 1 | 1 | 0 | Explain |
| SELECT `Content`.`id`, `Content`.`title`, `Content`.`slug`, `Content`.`introduction`, `Content`.`body`, `Content`.`locked`, `Content`.`locked_since`, `Content`.`locked_by`, `Content`.`ordering`, `Content`.`group_id`, `Content`.`views`, `Content`.`active`, `Content`.`start`, `Content`.`end`, `Content`.`created`, `Content`.`modified`, `Content`.`layout_id`, `Content`.`created_by`, `Content`.`modified_by`, `Content`.`category_id`, `Author`.`id`, `Author`.`username`, `Editor`.`id`, `Editor`.`username`, `Category`.`id`, `Category`.`title`, `Group`.`id`, `Group`.`name`, `Locker`.`id`, `Locker`.`username`, `Layout`.`id`, `Layout`.`content_id`, `Layout`.`name`, `Layout`.`css`, `Layout`.`html`, `Layout`.`php`, `Layout`.`locked`, `Layout`.`locked_by`, `Layout`.`locked_since`, `Layout`.`content_count`, `Layout`.`active`, `Layout`.`created`, `Layout`.`modified`, `ContentConfig`.`id`, `ContentConfig`.`content_id`, `ContentConfig`.`author_alias`, `ContentConfig`.`keywords`, `ContentConfig`.`description`, `Feature`.`id`, `Frontpage`.`id` FROM `cms_contents` AS `Content` LEFT JOIN `core_users` AS `Author` ON (`Content`.`created_by` = `Author`.`id`) LEFT JOIN `core_users` AS `Editor` ON (`Content`.`modified_by` = `Editor`.`id`) LEFT JOIN `cms_categories` AS `Category` ON (`Content`.`category_id` = `Category`.`id`) LEFT JOIN `core_groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `core_users` AS `Locker` ON (`Content`.`locked_by` = `Locker`.`id`) LEFT JOIN `cms_content_layouts` AS `Layout` ON (`Content`.`layout_id` = `Layout`.`id`) LEFT JOIN `cms_content_configs` AS `ContentConfig` ON (`ContentConfig`.`content_id` = `Content`.`id`) LEFT JOIN `cms_features` AS `Feature` ON (`Feature`.`content_id` = `Content`.`id`) LEFT JOIN `cms_frontpages` AS `Frontpage` ON (`Frontpage`.`content_id` = `Content`.`id`) WHERE `Content`.`slug` = 'home' AND `Content`.`active` = 1 ORDER BY `Content`.`category_id` ASC, `Content`.`ordering` ASC LIMIT 1 | | 1 | 1 | 1 | Explain |
| SELECT COUNT(*) AS `count` FROM `cms_contents` AS `Content` WHERE `Content`.`id` = 3 | | 1 | 1 | 0 | Explain |
| SELECT COUNT(*) AS `count` FROM `cms_contents` AS `Content` WHERE `Content`.`id` = 3 | | 1 | 1 | 0 | Explain |
| UPDATE `cms_contents` SET `id` = 3, `views` = 1090 WHERE `cms_contents`.`id` = 3 | | 1 | | 141 | maybe slow |
| SELECT `Content`.`category_id` FROM `cms_contents` AS `Content` WHERE `Content`.`id` = 3 ORDER BY `Content`.`category_id` ASC, `Content`.`ordering` ASC LIMIT 1 | | 1 | 1 | 0 | Explain |
| SELECT COUNT(*) AS `count` FROM `cms_contents` AS `Content` WHERE `Content`.`category_id` = 0 | | 1 | 1 | 0 | Explain |
| UPDATE `cms_categories` AS `Category` LEFT JOIN `cms_categories` AS `Parent` ON (`Category`.`parent_id` = `Parent`.`id`) LEFT JOIN `core_users` AS `Locker` ON (`Category`.`locked_by` = `Locker`.`id`) LEFT JOIN `core_groups` AS `Group` ON (`Category`.`group_id` = `Group`.`id`) SET `Category`.`content_count` = 7 WHERE `Category`.`id` = 0 | | 0 | | 0 | |
| SELECT `Content`.`layout_id` FROM `cms_contents` AS `Content` WHERE `Content`.`id` = 3 ORDER BY `Content`.`category_id` ASC, `Content`.`ordering` ASC LIMIT 1 | | 1 | 1 | 0 | Explain |
| SELECT COUNT(*) AS `count` FROM `cms_contents` AS `Content` WHERE `Content`.`layout_id` = 3 | | 1 | 1 | 0 | Explain |
| UPDATE `cms_content_layouts` AS `Layout` SET `Layout`.`content_count` = 9 WHERE `Layout`.`id` = 3 | | 0 | | 0 | |
| SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`type`, `Menu`.`active`, `MenuItem`.`id`, `MenuItem`.`name`, `MenuItem`.`link`, `MenuItem`.`prefix`, `MenuItem`.`plugin`, `MenuItem`.`controller`, `MenuItem`.`action`, `MenuItem`.`params`, `MenuItem`.`force_backend`, `MenuItem`.`force_frontend`, `MenuItem`.`class`, `MenuItem`.`active`, `MenuItem`.`menu_id`, `MenuItem`.`parent_id`, `MenuItem`.`lft`, `MenuItem`.`rght`, `MenuItem`.`group_id` FROM `core_menu_items` AS `MenuItem` LEFT JOIN `core_menus` AS `Menu` ON (`MenuItem`.`menu_id` = `Menu`.`id`) LEFT JOIN `core_groups` AS `Group` ON (`MenuItem`.`group_id` = `Group`.`id`) WHERE `Menu`.`type` = 'main_menu' AND `Menu`.`active` = 1 AND `MenuItem`.`active` = 1 ORDER BY `MenuItem`.`menu_id` ASC, `MenuItem`.`lft` ASC | | 5 | 5 | 0 | Explain |
| SELECT `Module`.`id`, `Module`.`name`, `Module`.`content`, `Module`.`module`, `Module`.`config`, `Module`.`show_heading`, `Position`.`id`, `Position`.`name`, `Theme`.`id`, `Theme`.`name`, `Group`.`id`, `Group`.`name` FROM `core_modules` AS `Module` LEFT JOIN `core_module_positions` AS `Position` ON (`Module`.`position_id` = `Position`.`id`) LEFT JOIN `core_themes` AS `Theme` ON (`Module`.`theme_id` = `Theme`.`id`) LEFT JOIN `core_groups` AS `Group` ON (`Module`.`group_id` = `Group`.`id`) WHERE `Position`.`name` = 'right' AND `Module`.`admin` = 0 AND `Module`.`active` = 1 ORDER BY `Module`.`position_id` ASC, `Module`.`ordering` ASC | | 1 | 1 | 0 | Explain |
| SELECT `Route`.`id`, `Route`.`name`, `Route`.`url`, `CoreModulesRoute`.`id`, `CoreModulesRoute`.`module_id`, `CoreModulesRoute`.`route_id` FROM `core_routes` AS `Route` JOIN `core_modules_routes` AS `CoreModulesRoute` ON (`CoreModulesRoute`.`module_id` = 11 AND `CoreModulesRoute`.`route_id` = `Route`.`id`) | | 0 | 0 | 0 | Explain |
| SELECT `Module`.`id`, `Module`.`name`, `Module`.`content`, `Module`.`module`, `Module`.`config`, `Module`.`show_heading`, `Position`.`id`, `Position`.`name`, `Theme`.`id`, `Theme`.`name`, `Group`.`id`, `Group`.`name` FROM `core_modules` AS `Module` LEFT JOIN `core_module_positions` AS `Position` ON (`Module`.`position_id` = `Position`.`id`) LEFT JOIN `core_themes` AS `Theme` ON (`Module`.`theme_id` = `Theme`.`id`) LEFT JOIN `core_groups` AS `Group` ON (`Module`.`group_id` = `Group`.`id`) WHERE `Position`.`name` = 'search' AND `Module`.`admin` = 0 AND `Module`.`active` = 1 ORDER BY `Module`.`position_id` ASC, `Module`.`ordering` ASC | | 1 | 1 | 0 | Explain |
| SELECT `Route`.`id`, `Route`.`name`, `Route`.`url`, `CoreModulesRoute`.`id`, `CoreModulesRoute`.`module_id`, `CoreModulesRoute`.`route_id` FROM `core_routes` AS `Route` JOIN `core_modules_routes` AS `CoreModulesRoute` ON (`CoreModulesRoute`.`module_id` = 5 AND `CoreModulesRoute`.`route_id` = `Route`.`id`) | | 0 | 0 | 0 | Explain |
| SELECT `Module`.`id`, `Module`.`name`, `Module`.`content`, `Module`.`module`, `Module`.`config`, `Module`.`show_heading`, `Position`.`id`, `Position`.`name`, `Theme`.`id`, `Theme`.`name`, `Group`.`id`, `Group`.`name` FROM `core_modules` AS `Module` LEFT JOIN `core_module_positions` AS `Position` ON (`Module`.`position_id` = `Position`.`id`) LEFT JOIN `core_themes` AS `Theme` ON (`Module`.`theme_id` = `Theme`.`id`) LEFT JOIN `core_groups` AS `Group` ON (`Module`.`group_id` = `Group`.`id`) WHERE `Position`.`name` = 'bottom' AND `Module`.`admin` = 0 AND `Module`.`active` = 1 ORDER BY `Module`.`position_id` ASC, `Module`.`ordering` ASC | | 0 | 0 | 0 | Explain |
