| 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 | 42 | maybe slow |
| 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 | 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 | 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 | 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 | 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 | 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 `Program`.`id`, `Program`.`progNum`, `Program`.`progOrder`, `Program`.`picture`, `Program`.`largePic`, `Program`.`progTitle`, `Program`.`progSubtitle`, `Program`.`description`, `Program`.`slug`, `Program`.`bgColor`, `Program`.`textColor`, `Program`.`site_type_id`, `Program`.`active`, `Program`.`created`, `Program`.`modified`, `SiteType`.`id`, `SiteType`.`description`, `SiteType`.`active`, `SiteType`.`created`, `SiteType`.`modified` FROM `ca6d5drx_commercialagents`.`programs` AS `Program` LEFT JOIN `ca6d5drx_commercialagents`.`site_types` AS `SiteType` ON (`Program`.`site_type_id` = `SiteType`.`id`) WHERE `Program`.`slug` = 'punto-1' AND `Program`.`site_type_id` = 1 LIMIT 1 | 1 | 1 | 1 | |
47 duplicate queries run.