| 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 | 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 | 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 | 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 | 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 | 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 `News`.`id`, `News`.`title`, `News`.`subtitle`, `News`.`slug`, `News`.`excerpt`, `News`.`tinyexcerpt`, `News`.`newscontent`, `News`.`labelbutton`, `News`.`published`, `News`.`featured`, `News`.`datestartfeatured`, `News`.`dateendfeatured`, `News`.`imglist`, `News`.`imgdetail`, `News`.`documentlink`, `News`.`active`, `News`.`created`, `News`.`modified` FROM `ca6d5drx_commercialagents`.`news` AS `News` WHERE `News`.`active` = '1' AND `News`.`published` <= '2026-11-20 07:19:00' ORDER BY `News`.`published` DESC | 1 | 1 | 19 | maybe slow |
47 duplicate queries run.