Used Equipment
Under construction
Under construction
To view Cookies, add CookieComponent to Controller
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `pages` | 22 | 22 | 1 | |
| 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` = 'used-equipment' 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` = 25 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` > 18 AND `Page`.`rght` < 19 ORDER BY `Page`.`lft` ASC | 0 | 0 | 1 | |
| 15 | SELECT `Page`.`lft`, `Page`.`rght` FROM `pages` AS `Page` WHERE `Page`.`id` = 25 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` <= 18 AND `Page`.`rght` >= 19 ORDER BY `Page`.`lft` asc | 1 | 1 | 0 |
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | query |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | Setting | ALL | 13 | 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 | |||||
| 1 | SIMPLE | GroupsPage | ALL | 63 | Using where; Using temporary; Using filesort | 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` > 18 AND `Page`.`rght` < 19 ORDER BY `Page`.`lft` ASC |
Current Memory Use 14.89 MB
Peak Memory Use 14.97 MB
Total Request Time: 2.144987 (seconds)
| Message | Time in seconds | Graph |
|---|---|---|
| Component initialization and startup | 0.085890 | |
| Controller Action | 0.061570 | |
| Render Controller Action | 0.425350 | |
| Rendering View | 0.424070 | |
| Rendering APP/plugins/content/views/pages/display.ctp | 0.066710 | |
| Rendering APP/views/themed/default/layouts/default.ctp | 0.348280 | |
| Rendering APP/plugins/navigation/views/elements/menu.ctp | 0.221730 | |
| Component initialization and startup #2 | 0.005990 | |
| Controller Action #2 | 0.000000 | |
| Rendering APP/plugins/navigation/views/elements/menu.ctp #2 | 0.103920 | |
| Component initialization and startup #3 | 0.005750 | |
| Controller Action #3 | 0.000000 |
There were no log entries made this request
There were no log entries made this request