| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed`, `UserGroup`.`id`, `UserGroup`.`name`, `UserGroup`.`alias_name`, `UserGroup`.`allowRegistration`, `UserGroup`.`created`, `UserGroup`.`modified` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` LEFT JOIN `ca6d5drx_commercialagents`.`user_groups` AS `UserGroup` ON (`UserGroupPermission`.`user_group_id` = `UserGroup`.`id`) WHERE `UserGroupPermission`.`user_group_id` = 3 AND `UserGroupPermission`.`allowed` = 1 | 48 | 48 | 2 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
| SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed` FROM `ca6d5drx_commercialagents`.`user_group_permissions` AS `UserGroupPermission` WHERE `UserGroupPermission`.`user_group_id` = (3) | 95 | 95 | 1 | |
47 duplicate queries run.