| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `projects_pinoparty`.`eyw_aros` AS `Aro` INNER JOIN `projects_pinoparty`.`eyw_aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'Role' AND `Aro0`.`foreign_key` = 3 ORDER BY `Aro`.`lft` DESC | 2 | 2 | 106 | maybe slow |
| SELECT `Aro`.`lft`, `Aro`.`rght` FROM `projects_pinoparty`.`eyw_aros` AS `Aro` WHERE `Aro`.`id` = 3 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght` FROM `projects_pinoparty`.`eyw_aros` AS `Aro` WHERE 1 = 1 AND `Aro`.`lft` <= 2 AND `Aro`.`rght` >= 3609 ORDER BY `Aro`.`lft` asc | 2 | 2 | 0 | |
| SELECT `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete`, `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght`, `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `projects_pinoparty`.`eyw_aros_acos` AS `Permission` LEFT JOIN `projects_pinoparty`.`eyw_aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `projects_pinoparty`.`eyw_acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` IN (3, 4, 4, 3) AND `Permission`.`_create` = '1' AND `Permission`.`_read` = '1' AND `Permission`.`_update` = '1' AND `Permission`.`_delete` = '1' | 10 | 10 | 48 | maybe slow |
| SELECT `Aco`.`lft`, `Aco`.`rght` FROM `projects_pinoparty`.`eyw_acos` AS `Aco` WHERE `Aco`.`id` = 81 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `projects_pinoparty`.`eyw_acos` AS `Aco` WHERE 1 = 1 AND `Aco`.`lft` <= 142 AND `Aco`.`rght` >= 143 ORDER BY `Aco`.`lft` asc | 4 | 4 | 31 | maybe slow |
| SELECT `Aco`.`lft`, `Aco`.`rght` FROM `projects_pinoparty`.`eyw_acos` AS `Aco` WHERE `Aco`.`id` = 82 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `projects_pinoparty`.`eyw_acos` AS `Aco` WHERE 1 = 1 AND `Aco`.`lft` <= 144 AND `Aco`.`rght` >= 145 ORDER BY `Aco`.`lft` asc | 4 | 4 | 1 | maybe slow |
| SELECT `Aco`.`lft`, `Aco`.`rght` FROM `projects_pinoparty`.`eyw_acos` AS `Aco` WHERE `Aco`.`id` = 97 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `projects_pinoparty`.`eyw_acos` AS `Aco` WHERE 1 = 1 AND `Aco`.`lft` <= 174 AND `Aco`.`rght` >= 175 ORDER BY `Aco`.`lft` asc | 4 | 4 | 0 | |
| SELECT `Aco`.`lft`, `Aco`.`rght` FROM `projects_pinoparty`.`eyw_acos` AS `Aco` WHERE `Aco`.`id` = 158 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `projects_pinoparty`.`eyw_acos` AS `Aco` WHERE 1 = 1 AND `Aco`.`lft` <= 296 AND `Aco`.`rght` >= 297 ORDER BY `Aco`.`lft` asc | 4 | 4 | 0 | |
| SELECT `Aco`.`lft`, `Aco`.`rght` FROM `projects_pinoparty`.`eyw_acos` AS `Aco` WHERE `Aco`.`id` = 159 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `projects_pinoparty`.`eyw_acos` AS `Aco` WHERE 1 = 1 AND `Aco`.`lft` <= 298 AND `Aco`.`rght` >= 299 ORDER BY `Aco`.`lft` asc | 4 | 4 | 0 | |
| SELECT `Aco`.`lft`, `Aco`.`rght` FROM `projects_pinoparty`.`eyw_acos` AS `Aco` WHERE `Aco`.`id` = 160 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `projects_pinoparty`.`eyw_acos` AS `Aco` WHERE 1 = 1 AND `Aco`.`lft` <= 300 AND `Aco`.`rght` >= 301 ORDER BY `Aco`.`lft` asc | 4 | 4 | 1 | maybe slow |
| SELECT `Aco`.`lft`, `Aco`.`rght` FROM `projects_pinoparty`.`eyw_acos` AS `Aco` WHERE `Aco`.`id` = 161 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `projects_pinoparty`.`eyw_acos` AS `Aco` WHERE 1 = 1 AND `Aco`.`lft` <= 302 AND `Aco`.`rght` >= 303 ORDER BY `Aco`.`lft` asc | 4 | 4 | 1 | maybe slow |
| SELECT `Aco`.`lft`, `Aco`.`rght` FROM `projects_pinoparty`.`eyw_acos` AS `Aco` WHERE `Aco`.`id` = 163 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `projects_pinoparty`.`eyw_acos` AS `Aco` WHERE 1 = 1 AND `Aco`.`lft` <= 306 AND `Aco`.`rght` >= 307 ORDER BY `Aco`.`lft` asc | 4 | 4 | 0 | |
| SELECT `Aco`.`lft`, `Aco`.`rght` FROM `projects_pinoparty`.`eyw_acos` AS `Aco` WHERE `Aco`.`id` = 154 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `projects_pinoparty`.`eyw_acos` AS `Aco` WHERE 1 = 1 AND `Aco`.`lft` <= 288 AND `Aco`.`rght` >= 289 ORDER BY `Aco`.`lft` asc | 4 | 4 | 0 | |
| SELECT `Aco`.`lft`, `Aco`.`rght` FROM `projects_pinoparty`.`eyw_acos` AS `Aco` WHERE `Aco`.`id` = 155 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `projects_pinoparty`.`eyw_acos` AS `Aco` WHERE 1 = 1 AND `Aco`.`lft` <= 290 AND `Aco`.`rght` >= 291 ORDER BY `Aco`.`lft` asc | 4 | 4 | 0 | |
| SELECT `Usergroup`.`id`, `Usergroup`.`name`, `Usergroup`.`welcome_msg`, `Usergroup`.`deletable` FROM `projects_pinoparty`.`eyw_usergroups` AS `Usergroup` WHERE `Usergroup`.`id` = 1 LIMIT 1 | 1 | 1 | 16 | maybe slow |
| SELECT `CustomField`.`id`, `CustomField`.`model`, `CustomField`.`type`, `CustomField`.`name`, `CustomField`.`value`, `CustomField`.`notation`, `CustomField`.`required`, `CustomField`.`length`, `CustomField`.`tooltip`, `CustomField`.`visible`, `CustomField`.`order`, `CustomField`.`extra`, `CustomField`.`non_deletable`, `CustomField`.`user_edit`, `CustomField`.`default`, `CustomField`.`language`, `CustomFieldForeign`.`id`, `CustomFieldForeign`.`custom_field_id`, `CustomFieldForeign`.`foreign_key`, `CustomFieldForeign`.`visible` FROM `projects_pinoparty`.`eyw_custom_fields` AS `CustomField` JOIN `projects_pinoparty`.`eyw_custom_field_foreigns` AS `CustomFieldForeign` ON (`CustomFieldForeign`.`foreign_key` = 1 AND `CustomFieldForeign`.`custom_field_id` = `CustomField`.`id`) WHERE `CustomField`.`model` = 'Users.Usergroup' | 1 | 1 | 29 | maybe slow |
| SELECT `I18nModel`.`field`, `I18nModel`.`content`, `I18nModel`.`locale` FROM `projects_pinoparty`.`eyw_i18n` AS `I18nModel` WHERE `I18nModel`.`model` = 'CustomField' AND `I18nModel`.`foreign_key` = 28 AND `I18nModel`.`field` IN ('name', 'value', 'extra.list') | 0 | 0 | 9 | maybe slow |
| SELECT `I18nModel`.`field`, `I18nModel`.`content`, `I18nModel`.`locale` FROM `projects_pinoparty`.`eyw_i18n` AS `I18nModel` WHERE `I18nModel`.`model` = 'Usergroup' AND `I18nModel`.`foreign_key` = 1 AND `I18nModel`.`field` IN ('name', 'welcome_msg') | 2 | 2 | 10 | maybe slow |