Ouvrages de métallerie et de serrurerie
Métiers : Réalisations - Ouvrage à façon
Matériel utilisé : Métal, Aluminium
Mot clé : Travail du métal
Création d'un escalier sur mesure
To view Cookies, add CookieComponent to Controller
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `aros` | 7 | 7 | 15 | |
| 2 | DESCRIBE `acos` | 7 | 7 | 15 | |
| 3 | DESCRIBE `aros_acos` | 7 | 7 | 15 | |
| 4 | DESCRIBE `projects` | 19 | 19 | 15 | |
| 5 | DESCRIBE `project_images` | 5 | 5 | 15 | |
| 6 | DESCRIBE `activities` | 13 | 13 | 15 | |
| 7 | DESCRIBE `animations` | 5 | 5 | 15 | |
| 8 | DESCRIBE `animation_frames` | 6 | 6 | 15 | |
| 9 | DESCRIBE `animation_frame_attachments` | 7 | 7 | 15 | |
| 10 | DESCRIBE `animation_frame_links` | 5 | 5 | 15 | |
| 11 | DESCRIBE `post_categories` | 10 | 10 | 15 | |
| 12 | DESCRIBE `posts` | 11 | 11 | 15 | |
| 13 | DESCRIBE `tags` | 7 | 7 | 14 | |
| 14 | DESCRIBE `activities_tags` | 2 | 2 | 14 | |
| 15 | DESCRIBE `posts_tags` | 2 | 2 | 14 | |
| 16 | DESCRIBE `projects_tags` | 2 | 2 | 15 | |
| 17 | DESCRIBE `activities_projects` | 2 | 2 | 15 | |
| 18 | DESCRIBE `materials` | 3 | 3 | 14 | |
| 19 | DESCRIBE `materials_projects` | 2 | 2 | 14 | |
| 20 | DESCRIBE `sectors` | 3 | 3 | 14 | |
| 21 | DESCRIBE `projects_sectors` | 2 | 2 | 27 | |
| 22 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `aros` AS `Aro` LEFT JOIN `aros` AS `Aro0` ON (`Aro0`.`alias` = 'ROOT') WHERE `Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght` ORDER BY `Aro`.`lft` DESC | 1 | 1 | 0 | |
| 23 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `acos` AS `Aco` LEFT JOIN `acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') LEFT JOIN `acos` AS `Aco1` ON (`Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`alias` = 'Projects') LEFT JOIN `acos` AS `Aco2` ON (`Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`alias` = 'view') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco2`.`lft` AND `Aco`.`rght` >= `Aco2`.`rght`)) ORDER BY `Aco`.`lft` DESC | 3 | 3 | 73 | |
| 24 | SELECT `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete`, `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght`, `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `aros_acos` AS `Permission` LEFT JOIN `aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 1 AND `Permission`.`aco_id` IN (96, 94, 1) ORDER BY `Aco`.`lft` desc | 2 | 2 | 1 | |
| 25 | SELECT `Project`.`id`, `Project`.`title`, `Project`.`intro`, `Project`.`description`, `Project`.`video`, `Project`.`maitre_ouvrage`, `Project`.`maitre_oeuvre`, `Project`.`lieu`, `Project`.`date`, `Project`.`activite`, `Project`.`savoir_faire`, `MainProjectImage`.`id`, `MainProjectImage`.`title`, `MainProjectImage`.`image` FROM `projects` AS `Project` LEFT JOIN `project_images` AS `MainProjectImage` ON (`Project`.`main_project_image_id` = `MainProjectImage`.`id`) WHERE `Project`.`id` = 21 LIMIT 1 | 1 | 1 | 2 | |
| 26 | SELECT `ProjectImage`.`id`, `ProjectImage`.`project_id`, `ProjectImage`.`title`, `ProjectImage`.`image` FROM `project_images` AS `ProjectImage` WHERE `ProjectImage`.`project_id` = (21) | 4 | 4 | 1 | |
| 27 | SELECT `Project`.`id`, `Project`.`title`, `Project`.`slug` FROM `projects` AS `Project` LEFT JOIN `project_images` AS `MainProjectImage` ON (`Project`.`main_project_image_id` = `MainProjectImage`.`id`) WHERE `Project`.`id` < 21 ORDER BY `Project`.`id` DESC LIMIT 1 | 1 | 1 | 1 | |
| 28 | SELECT `Project`.`id`, `Project`.`title`, `Project`.`slug` FROM `projects` AS `Project` LEFT JOIN `project_images` AS `MainProjectImage` ON (`Project`.`main_project_image_id` = `MainProjectImage`.`id`) WHERE `Project`.`id` >= 20 AND `Project`.`id` != 21 ORDER BY `Project`.`id` ASC LIMIT 2 | 2 | 2 | 1 |
Query: SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `acos` AS `Aco` LEFT JOIN `acos` AS `Aco0` ON (`Aco0`.`alias` = 'ROOT') LEFT JOIN `acos` AS `Aco1` ON (`Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`alias` = 'Projects') LEFT JOIN `acos` AS `Aco2` ON (`Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`alias` = 'view') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco2`.`lft` AND `Aco`.`rght` >= `Aco2`.`rght`)) ORDER BY `Aco`.`lft` DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | Aco | ALL | 236 | Using temporary; Using filesort | ||||
| 1 | SIMPLE | Aco0 | ALL | 236 | |||||
| 1 | SIMPLE | Aco1 | ALL | 236 | |||||
| 1 | SIMPLE | Aco2 | ALL | 236 | Using where |
Query: SELECT `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete`, `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght`, `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `aros_acos` AS `Permission` LEFT JOIN `aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 1 AND `Permission`.`aco_id` IN (96, 94, 1) ORDER BY `Aco`.`lft` desc
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | Permission | ALL | 51 | Using where; Using temporary; Using filesort | ||||
| 1 | SIMPLE | Aro | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | Aco | eq_ref | PRIMARY | PRIMARY | 4 | 608880_cfparis.Permission.aco_id | 1 |
Query: SELECT `Project`.`id`, `Project`.`title`, `Project`.`intro`, `Project`.`description`, `Project`.`video`, `Project`.`maitre_ouvrage`, `Project`.`maitre_oeuvre`, `Project`.`lieu`, `Project`.`date`, `Project`.`activite`, `Project`.`savoir_faire`, `MainProjectImage`.`id`, `MainProjectImage`.`title`, `MainProjectImage`.`image` FROM `projects` AS `Project` LEFT JOIN `project_images` AS `MainProjectImage` ON (`Project`.`main_project_image_id` = `MainProjectImage`.`id`) WHERE `Project`.`id` = 21 LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | Project | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | MainProjectImage | const | PRIMARY | PRIMARY | 4 | const | 1 |
Query: SELECT `ProjectImage`.`id`, `ProjectImage`.`project_id`, `ProjectImage`.`title`, `ProjectImage`.`image` FROM `project_images` AS `ProjectImage` WHERE `ProjectImage`.`project_id` = (21)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | ProjectImage | ALL | 62 | Using where |
Query: SELECT `Project`.`id`, `Project`.`title`, `Project`.`slug` FROM `projects` AS `Project` LEFT JOIN `project_images` AS `MainProjectImage` ON (`Project`.`main_project_image_id` = `MainProjectImage`.`id`) WHERE `Project`.`id` >= 20 AND `Project`.`id` != 21 ORDER BY `Project`.`id` ASC LIMIT 2
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | Project | range | PRIMARY | PRIMARY | 4 | 5 | Using where | |
| 1 | SIMPLE | MainProjectImage | eq_ref | PRIMARY | PRIMARY | 4 | 608880_cfparis.Project.main_project_image_id | 1 | Using index |
Peak Memory Use 18.17 MB
| Message | Memory use |
|---|---|
| Component intitailization | 12.92 MB |
| Controller action start | 12.99 MB |
| Controller render start | 14.40 MB |
| View render complete | 17.74 MB |
Total Request Time: 4791 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived) | 3737.56 | |
| Component initialization and startup | 187.81 | |
| Controller action | 41.48 | |
| Render Controller Action | 388.51 | |
| » Rendering View | 387.07 | |
| » » Rendering APP/views/projects/view.ctp | 287.50 | |
| » » Rendering APP/views/layouts/default.ctp | 96.81 | |
| » » » Rendering APP/views/elements/projects/sort.ctp | 19.55 | |
| » » » Rendering APP/views/elements/contact_btn.ctp | 5.58 | |
| » » » Rendering APP/views/elements/menus/top2.ctp | 8.68 | |
| » » » Rendering APP/views/elements/breadcrumbs.ctp | 5.99 | |
| » » » Rendering APP/views/elements/login_button.ctp | 6.62 | |
| » » » Rendering APP/views/elements/search.ctp | 9.47 | |
| » » » Rendering APP/views/elements/menus/bottom.ctp | 8.81 |
There were no log entries made this request
There were no log entries made this request
