| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|
| 1 | DESCRIBE `aros` | | 7 | 7 | 15 |
| 2 | DESCRIBE `acos` | | 7 | 7 | 18 |
| 3 | DESCRIBE `aros_acos` | | 7 | 7 | 15 |
| 4 | DESCRIBE `job_offers` | | 11 | 11 | 15 |
| 5 | DESCRIBE `job_requests` | | 17 | 17 | 15 |
| 6 | 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 |
| 7 | 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` = 'JobOffers') 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 | 1 |
| 8 | 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 (46, 44, 1) ORDER BY `Aco`.`lft` desc | | 2 | 2 | 0 |
| 9 | SELECT `JobOffer`.`id`, `JobOffer`.`title`, `JobOffer`.`descritpion`, `JobOffer`.`image`, `JobOffer`.`meta_title`, `JobOffer`.`meta_desc`, `JobOffer`.`meta_key`, `JobOffer`.`slug`, `JobOffer`.`published`, `JobOffer`.`created`, `JobOffer`.`modified` FROM `job_offers` AS `JobOffer` WHERE `JobOffer`.`id` = 3 LIMIT 1 | | 1 | 1 | 1 |
| 10 | SELECT `JobRequest`.`id`, `JobRequest`.`job_offer_id`, `JobRequest`.`fname`, `JobRequest`.`lname`, `JobRequest`.`email`, `JobRequest`.`tel`, `JobRequest`.`mob`, `JobRequest`.`street1`, `JobRequest`.`street2`, `JobRequest`.`street3`, `JobRequest`.`city`, `JobRequest`.`zip`, `JobRequest`.`country`, `JobRequest`.`cv`, `JobRequest`.`comments`, `JobRequest`.`archieved`, `JobRequest`.`created` FROM `job_requests` AS `JobRequest` WHERE `JobRequest`.`job_offer_id` = (3) | | 0 | 0 | 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` = 'JobOffers') 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 `JobRequest`.`id`, `JobRequest`.`job_offer_id`, `JobRequest`.`fname`, `JobRequest`.`lname`, `JobRequest`.`email`, `JobRequest`.`tel`, `JobRequest`.`mob`, `JobRequest`.`street1`, `JobRequest`.`street2`, `JobRequest`.`street3`, `JobRequest`.`city`, `JobRequest`.`zip`, `JobRequest`.`country`, `JobRequest`.`cv`, `JobRequest`.`comments`, `JobRequest`.`archieved`, `JobRequest`.`created` FROM `job_requests` AS `JobRequest` WHERE `JobRequest`.`job_offer_id` = (3)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | JobRequest | ALL | | | | | 12 | Using where |