| 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 | 23 | 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 | 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 `Delegate`.`id`, `Delegate`.`name`, `Delegate`.`lastname`, `Delegate`.`birthdate`, `Delegate`.`city`, `Delegate`.`birthcity`, `Delegate`.`gender`, `Delegate`.`profile`, `Delegate`.`picture`, `Delegate`.`largePic`, `Delegate`.`email`, `Delegate`.`pec`, `Delegate`.`mobile`, `Delegate`.`facebook_link`, `Delegate`.`linkedin_link`, `Delegate`.`association_id`, `Delegate`.`figure_id`, `Delegate`.`site_type_id`, `Delegate`.`active`, `Delegate`.`created`, `Delegate`.`modified`, `Delegate`.`position`, `Delegate`.`codfisc`, `Delegate`.`whatsapp`, `Delegate`.`slug`, `Association`.`id`, `Association`.`description`, `Association`.`active`, `Association`.`created`, `Association`.`modified`, `Figure`.`id`, `Figure`.`description`, `Figure`.`codicione_type`, `Figure`.`active`, `Figure`.`created`, `Figure`.`modified`, `SiteType`.`id`, `SiteType`.`description`, `SiteType`.`active`, `SiteType`.`created`, `SiteType`.`modified` FROM `ca6d5drx_commercialagents`.`delegates` AS `Delegate` LEFT JOIN `ca6d5drx_commercialagents`.`associations` AS `Association` ON (`Delegate`.`association_id` = `Association`.`id`) LEFT JOIN `ca6d5drx_commercialagents`.`figures` AS `Figure` ON (`Delegate`.`figure_id` = `Figure`.`id`) LEFT JOIN `ca6d5drx_commercialagents`.`site_types` AS `SiteType` ON (`Delegate`.`site_type_id` = `SiteType`.`id`) WHERE `Delegate`.`slug` = 'cesare-zanetti' AND `Delegate`.`site_type_id` = 1 LIMIT 1 | 1 | 1 | 2 | maybe slow |
47 duplicate queries run.