| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|
| 1 | DESCRIBE `pages` | | 22 | 22 | 2 |
| 2 | DESCRIBE `users` | | 19 | 19 | 1 |
| 3 | DESCRIBE `groups` | | 9 | 9 | 1 |
| 4 | DESCRIBE `page_history` | | 8 | 8 | 1 |
| 5 | DESCRIBE `groups_pages` | | 3 | 3 | 1 |
| 6 | DESCRIBE `sitemap` | | 15 | 15 | 1 |
| 7 | DESCRIBE `settings` | | 10 | 10 | 1 |
| 8 | SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`options`, `Setting`.`type`, `Setting`.`default`, `Setting`.`created`, `Setting`.`created_by`, `Setting`.`modified`, `Setting`.`modified_by`, `CreatedUser`.`id`, `CreatedUser`.`email`, `CreatedUser`.`password`, `CreatedUser`.`first_name`, `CreatedUser`.`last_name`, `CreatedUser`.`display_name`, `CreatedUser`.`image`, `CreatedUser`.`slug`, `CreatedUser`.`gender`, `CreatedUser`.`date_of_birth`, `CreatedUser`.`group_id`, `CreatedUser`.`confirmation_code`, `CreatedUser`.`reset_code`, `CreatedUser`.`confirmed`, `CreatedUser`.`active`, `CreatedUser`.`created`, `CreatedUser`.`created_by`, `CreatedUser`.`modified`, `CreatedUser`.`modified_by`, `ModifiedUser`.`id`, `ModifiedUser`.`email`, `ModifiedUser`.`password`, `ModifiedUser`.`first_name`, `ModifiedUser`.`last_name`, `ModifiedUser`.`display_name`, `ModifiedUser`.`image`, `ModifiedUser`.`slug`, `ModifiedUser`.`gender`, `ModifiedUser`.`date_of_birth`, `ModifiedUser`.`group_id`, `ModifiedUser`.`confirmation_code`, `ModifiedUser`.`reset_code`, `ModifiedUser`.`confirmed`, `ModifiedUser`.`active`, `ModifiedUser`.`created`, `ModifiedUser`.`created_by`, `ModifiedUser`.`modified`, `ModifiedUser`.`modified_by` FROM `settings` AS `Setting` LEFT JOIN `users` AS `CreatedUser` ON (`Setting`.`created_by` = `CreatedUser`.`id`) LEFT JOIN `users` AS `ModifiedUser` ON (`Setting`.`modified_by` = `ModifiedUser`.`id`) WHERE 1 = 1 | | 13 | 13 | 1 |
| 9 | DESCRIBE `locales` | | 4 | 4 | 1 |
| 10 | SELECT `Locale`.`id`, `Locale`.`name`, `Locale`.`locale`, `Locale`.`default` FROM `locales` AS `Locale` WHERE 1 = 1 ORDER BY `Locale`.`default` DESC | | 1 | 1 | 0 |
| 11 | SELECT `Group`.`id` FROM `groups` AS `Group` WHERE `Group`.`slug` = 'guest' LIMIT 1 | | 1 | 1 | 0 |
| 12 | SELECT `Page`.`id`, `Page`.`title`, `Page`.`filename`, `Page`.`filename_locked`, `Page`.`slug`, `Page`.`content`, `Page`.`meta_keywords`, `Page`.`meta_description`, `Page`.`parent_id`, `Page`.`show_title`, `Page`.`show_box`, `Page`.`show_related`, `Page`.`show_subpages`, `Page`.`lft`, `Page`.`rght`, `Page`.`active`, `Page`.`layout`, `Page`.`theme`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `pages` AS `Page` WHERE `Page`.`slug` = 'home' ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 |
| 13 | SELECT `Group`.`id`, `Group`.`name`, `Group`.`slug`, `Group`.`active`, `Group`.`parent_id`, `Group`.`created`, `Group`.`created_by`, `Group`.`modified`, `Group`.`modified_by`, `GroupsPage`.`id`, `GroupsPage`.`group_id`, `GroupsPage`.`page_id` FROM `groups` AS `Group` JOIN `groups_pages` AS `GroupsPage` ON (`GroupsPage`.`page_id` = 1 AND `GroupsPage`.`group_id` = `Group`.`id`) WHERE 1 = 1 | | 3 | 3 | 0 |
| 14 | SELECT `Page`.`id`, `Page`.`title`, `Page`.`filename`, `Page`.`filename_locked`, `Page`.`slug`, `Page`.`content`, `Page`.`meta_keywords`, `Page`.`meta_description`, `Page`.`parent_id`, `Page`.`show_title`, `Page`.`show_box`, `Page`.`show_related`, `Page`.`show_subpages`, `Page`.`lft`, `Page`.`rght`, `Page`.`active`, `Page`.`layout`, `Page`.`theme`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `GroupsPage`.`id`, `GroupsPage`.`group_id`, `GroupsPage`.`page_id` FROM `pages` AS `Page` INNER JOIN `groups_pages` AS `GroupsPage` ON (`GroupsPage`.`group_id` = 3 AND `GroupsPage`.`page_id` = `Page`.`id`) WHERE `Page`.`lft` > 3 AND `Page`.`rght` < 22 ORDER BY `Page`.`lft` ASC | | 1 | 1 | 1 |
| 15 | SELECT `Page`.`lft`, `Page`.`rght` FROM `pages` AS `Page` WHERE `Page`.`id` = 1 ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 |
| 16 | SELECT `Page`.`id`, `Page`.`title`, `Page`.`filename`, `Page`.`filename_locked`, `Page`.`slug`, `Page`.`content`, `Page`.`meta_keywords`, `Page`.`meta_description`, `Page`.`parent_id`, `Page`.`show_title`, `Page`.`show_box`, `Page`.`show_related`, `Page`.`show_subpages`, `Page`.`lft`, `Page`.`rght`, `Page`.`active`, `Page`.`layout`, `Page`.`theme`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `pages` AS `Page` WHERE 1 = 1 AND `Page`.`lft` <= 3 AND `Page`.`rght` >= 22 ORDER BY `Page`.`lft` asc | | 1 | 1 | 0 |