| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|
| 1 | DESCRIBE `aros` | | 7 | 7 | 17 |
| 2 | DESCRIBE `acos` | | 7 | 7 | 17 |
| 3 | DESCRIBE `aros_acos` | | 7 | 7 | 17 |
| 4 | DESCRIBE `activities` | | 13 | 13 | 17 |
| 5 | DESCRIBE `animations` | | 5 | 5 | 16 |
| 6 | DESCRIBE `animation_frames` | | 6 | 6 | 16 |
| 7 | DESCRIBE `animation_frame_attachments` | | 7 | 7 | 17 |
| 8 | DESCRIBE `animation_frame_links` | | 5 | 5 | 17 |
| 9 | DESCRIBE `post_categories` | | 10 | 10 | 17 |
| 10 | DESCRIBE `posts` | | 11 | 11 | 17 |
| 11 | DESCRIBE `tags` | | 7 | 7 | 17 |
| 12 | DESCRIBE `projects` | | 19 | 19 | 18 |
| 13 | DESCRIBE `project_images` | | 5 | 5 | 16 |
| 14 | DESCRIBE `materials` | | 3 | 3 | 16 |
| 15 | DESCRIBE `materials_projects` | | 2 | 2 | 16 |
| 16 | DESCRIBE `sectors` | | 3 | 3 | 31 |
| 17 | DESCRIBE `projects_sectors` | | 2 | 2 | 19 |
| 18 | DESCRIBE `activities_projects` | | 2 | 2 | 18 |
| 19 | DESCRIBE `projects_tags` | | 2 | 2 | 19 |
| 20 | DESCRIBE `activities_tags` | | 2 | 2 | 25 |
| 21 | DESCRIBE `posts_tags` | | 2 | 2 | 17 |
| 22 | DESCRIBE `catalogs` | | 9 | 9 | 16 |
| 23 | DESCRIBE `products` | | 11 | 11 | 16 |
| 24 | DESCRIBE `product_images` | | 4 | 4 | 17 |
| 25 | DESCRIBE `products_tags` | | 2 | 2 | 16 |
| 26 | DESCRIBE `job_offers` | | 11 | 11 | 19 |
| 27 | DESCRIBE `job_requests` | | 17 | 17 | 17 |
| 28 | DESCRIBE `refs` | | 6 | 6 | 17 |
| 29 | 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 |
| 30 | 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` = 'Sitemap') LEFT JOIN `acos` AS `Aco2` ON (`Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`alias` = 'index') 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 | 70 |
| 31 | 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 (225, 224, 1) ORDER BY `Aco`.`lft` desc | | 3 | 3 | 1 |
| 32 | SELECT `Activity`.`id`, `Activity`.`title`, `Activity`.`slug`, `Activity`.`modified` FROM `activities` AS `Activity` WHERE 1 = 1 | | 3 | 3 | 0 |
| 33 | SELECT `Project`.`id`, `Project`.`title`, `Project`.`slug`, `Project`.`modified` FROM `projects` AS `Project` WHERE 1 = 1 | | 11 | 11 | 1 |
| 34 | SELECT `Post`.`id`, `Post`.`title`, `Post`.`slug`, `Post`.`modified` FROM `posts` AS `Post` WHERE 1 = 1 | | 3 | 3 | 1 |
| 35 | SELECT `PostCategory`.`id`, `PostCategory`.`name`, `PostCategory`.`slug`, `PostCategory`.`modified` FROM `post_categories` AS `PostCategory` WHERE 1 = 1 | | 2 | 2 | 0 |
| 36 | SELECT `Catalog`.`id`, `Catalog`.`title`, `Catalog`.`modified` FROM `catalogs` AS `Catalog` WHERE 1 = 1 | | 3 | 3 | 1 |
| 37 | SELECT `Product`.`id`, `Product`.`title`, `Product`.`modified` FROM `products` AS `Product` WHERE 1 = 1 | | 9 | 9 | 0 |
| 38 | SELECT `JobOffer`.`id`, `JobOffer`.`title`, `JobOffer`.`slug`, `JobOffer`.`modified` FROM `job_offers` AS `JobOffer` WHERE 1 = 1 | | 3 | 3 | 3 |
| 39 | SELECT `Sector`.`id`, `Sector`.`name` FROM `sectors` AS `Sector` WHERE 1 = 1 | | 7 | 7 | 0 |
| 40 | SELECT `Material`.`id`, `Material`.`name` FROM `materials` AS `Material` WHERE 1 = 1 | | 5 | 5 | 0 |
| 41 | SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`slug` FROM `tags` AS `Tag` WHERE 1 = 1 | | 24 | 24 | 0 |
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` = 'Sitemap') LEFT JOIN `acos` AS `Aco2` ON (`Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`alias` = 'index') 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 (225, 224, 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`.`slug`, `Project`.`modified` FROM `projects` AS `Project` WHERE 1 = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | Project | ALL | | | | | 11 | |
Query: SELECT `Post`.`id`, `Post`.`title`, `Post`.`slug`, `Post`.`modified` FROM `posts` AS `Post` WHERE 1 = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | Post | ALL | | | | | 3 | |
Query: SELECT `Catalog`.`id`, `Catalog`.`title`, `Catalog`.`modified` FROM `catalogs` AS `Catalog` WHERE 1 = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | Catalog | ALL | | | | | 3 | |