| 1 | SELECT `ClickhouseIntegration`.`id`, `ClickhouseIntegration`.`name`, `ClickhouseIntegration`.`tag`, `ClickhouseIntegration`.`clickhouse_settings_id`, `ClickhouseIntegration`.`active`, `ClickhouseSettings`.`id`, `ClickhouseSettings`.`host`, `ClickhouseSettings`.`name`, `ClickhouseSettings`.`username`, `ClickhouseSettings`.`password`, `ClickhouseSettings`.`database`, `ClickhouseSettings`.`active`, `ClickhouseSettings`.`port`, `ClickhouseSettings`.`readonly` FROM `UTM`.`clickhouse_integration` AS `ClickhouseIntegration` LEFT JOIN `UTM`.`clickhouse_settings` AS `ClickhouseSettings` ON (`ClickhouseIntegration`.`clickhouse_settings_id` = `ClickhouseSettings`.`id`) WHERE `tag` = 'metrics' AND `ClickhouseIntegration`.`active` = '1' AND `ClickhouseSettings`.`active` = '1' LIMIT 1 | | 1 | 1 | 0 |
| 2 | SELECT `SystemSettings`.`setting_key`, `SystemSettings`.`setting_value`, `SystemSettings`.`setting_description` FROM `UTM`.`cake_system_settings` AS `SystemSettings` WHERE 1 = 1 | | 38 | 38 | 0 |
| 3 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `UTM`.`aco` AS `Aco` WHERE 1 = 1 | | 604 | 604 | 1 |
| 4 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght` FROM `UTM`.`aro` AS `Aro` WHERE `model` = 'Group' | | 10 | 10 | 0 |
| 5 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght`, `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete` FROM `UTM`.`aco` AS `Aco` JOIN `UTM`.`aros_acos` AS `Permission` ON (`Permission`.`aro_id` IN (2, 32, 38, 60, 65, 72, 73, 79, 84, 87) AND `Permission`.`aco_id` = `Aco`.`id`) | | 2053 | 2053 | 5 |
| 6 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght` FROM `UTM`.`aro` AS `Aro` WHERE `model` = 'User' | | 22 | 22 | 0 |
| 7 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght`, `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete` FROM `UTM`.`aco` AS `Aco` JOIN `UTM`.`aros_acos` AS `Permission` ON (`Permission`.`aro_id` IN (14, 37, 61, 62, 63, 64, 66, 67, 68, 70, 71, 74, 76, 77, 78, 80, 81, 82, 83, 85, 86, 88) AND `Permission`.`aco_id` = `Aco`.`id`) | | 133 | 133 | 1 |
| 8 | SELECT `Setting`.`setting_key`, `Setting`.`setting_value`, `Setting`.`created`, `Setting`.`modified` FROM `UTM`.`cake_settings` AS `Setting` WHERE `setting_key` = 'dfe2db74975e0aa9f6fdd4d61dedcb7328502456' LIMIT 1 | | 1 | 1 | 0 |
| 8 | Total | | 2862 | 2862 | 7 |