| 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 | |
| SELECT `Review`.`id`, `Review`.`header`, `Review`.`title`, `Review`.`content`, `Review`.`labelbutton`, `Review`.`targetUrl`, `Review`.`published`, `Review`.`featured`, `Review`.`datestartfeatured`, `Review`.`dateendfeatured`, `Review`.`imglist`, `Review`.`active`, `Review`.`created`, `Review`.`modified` FROM `ca6d5drx_commercialagents`.`reviews` AS `Review` WHERE `Review`.`active` = '1' AND `Review`.`published` <= '2026-11-20 07:18:59' ORDER BY `Review`.`published` DESC | 12 | 12 | 18 | maybe slow |
47 duplicate queries run.