Query | Error | Affected | Num. rows | Took (ms) | Actions |
---|
SHOW FULL COLUMNS FROM `aros` | | 7 | 7 | 1 | maybe slow |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | | 1 | 1 | 1 | |
SHOW FULL COLUMNS FROM `acos` | | 7 | 7 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `aros_acos` | | 9 | 9 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `complaints` | | 35 | 35 | 1 | |
SHOW FULL COLUMNS FROM `users` | | 23 | 23 | 1 | |
SHOW FULL COLUMNS FROM `countries` | | 9 | 9 | 0 | |
SHOW FULL COLUMNS FROM `focal_points` | | 8 | 8 | 0 | |
SHOW FULL COLUMNS FROM `regions` | | 2 | 2 | 0 | |
SHOW FULL COLUMNS FROM `complaints_regions` | | 3 | 3 | 0 | |
SHOW FULL COLUMNS FROM `regions_users` | | 3 | 3 | 0 | |
SHOW FULL COLUMNS FROM `focal_points_regions` | | 3 | 3 | 0 | |
SHOW FULL COLUMNS FROM `focal_points_users` | | 3 | 3 | 0 | |
SHOW FULL COLUMNS FROM `complaints_focal_points` | | 3 | 3 | 0 | |
SHOW FULL COLUMNS FROM `towns` | | 3 | 3 | 0 | |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | | 1 | 1 | 0 | |
SHOW FULL COLUMNS FROM `sectors` | | 2 | 2 | 0 | |
SHOW FULL COLUMNS FROM `sectors_locales` | | 4 | 4 | 0 | |
SHOW FULL COLUMNS FROM `roles` | | 3 | 3 | 0 | |
SHOW FULL COLUMNS FROM `comments` | | 7 | 7 | 0 | |
SHOW FULL COLUMNS FROM `attachments` | | 8 | 8 | 0 | |
SHOW FULL COLUMNS FROM `location_types` | | 4 | 4 | 0 | |
SHOW FULL COLUMNS FROM `locations` | | 4 | 4 | 0 | |
SHOW FULL COLUMNS FROM `location_types_locales` | | 4 | 4 | 0 | |
SHOW FULL COLUMNS FROM `ntb_types` | | 10 | 10 | 0 | |
SHOW FULL COLUMNS FROM `ntb_types_locales` | | 5 | 5 | 0 | |
SHOW FULL COLUMNS FROM `statuses` | | 7 | 7 | 0 | |
SHOW FULL COLUMNS FROM `statuses_locales` | | 4 | 4 | 0 | |
SHOW FULL COLUMNS FROM `ntm_codes` | | 5 | 5 | 0 | |
SHOW FULL COLUMNS FROM `complaints_locales` | | 4 | 4 | 0 | |
SHOW FULL COLUMNS FROM `sms` | | 13 | 13 | 0 | |
SHOW FULL COLUMNS FROM `tariff_codes` | | 6 | 6 | 0 | |
SHOW FULL COLUMNS FROM `complaints_tariff_codes` | | 3 | 3 | 0 | |
SHOW FULL COLUMNS FROM `tariff_codes_locales` | | 4 | 4 | 0 | |
SHOW FULL COLUMNS FROM `emails` | | 4 | 4 | 0 | |
SHOW FULL COLUMNS FROM `notifications` | | 8 | 8 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `notifications_regions` | | 3 | 3 | 0 | |
SHOW FULL COLUMNS FROM `countries_notifications` | | 3 | 3 | 0 | |
SELECT `Notification`.`id`, `Notification`.`region_id`, `Notification`.`country_id`, `Notification`.`title`, `Notification`.`description`, `Notification`.`filename`, `Notification`.`created`, `Notification`.`modified` FROM `notifications` AS `Notification` WHERE 1 = 1 ORDER BY `Notification`.`created` DESC, `Notification`.`title` ASC LIMIT 5 | | 5 | 5 | 0 | |
SELECT `Attachment`.`id`, `Attachment`.`class`, `Attachment`.`foreign_key`, `Attachment`.`description`, `Attachment`.`original_file`, `Attachment`.`saved_file`, `Attachment`.`created`, `Attachment`.`modified` FROM `attachments` AS `Attachment` WHERE `Attachment`.`class` = 'Notification' AND `Attachment`.`foreign_key` IN ('55117a49-26c0-4974-9fd9-df16c5bdc882', '551179fc-23d0-4149-950c-dd9fc5bdc882', '551178c6-6ef4-4144-bf09-dc9bc5bdc882', '54d4e89e-c0bc-4e5f-b4ab-1c38c5bdc882', '54d245ce-125c-40c3-9f0e-4c68c5bdc882') | | 5 | 5 | 0 | |
SELECT `Region`.`id`, `Region`.`name`, `NotificationsRegion`.`id`, `NotificationsRegion`.`notification_id`, `NotificationsRegion`.`region_id` FROM `regions` AS `Region` JOIN `notifications_regions` AS `NotificationsRegion` ON (`NotificationsRegion`.`notification_id` IN ('55117a49-26c0-4974-9fd9-df16c5bdc882', '551179fc-23d0-4149-950c-dd9fc5bdc882', '551178c6-6ef4-4144-bf09-dc9bc5bdc882', '54d4e89e-c0bc-4e5f-b4ab-1c38c5bdc882', '54d245ce-125c-40c3-9f0e-4c68c5bdc882') AND `NotificationsRegion`.`region_id` = `Region`.`id`) | | 10 | 10 | 0 | |
SELECT `Country`.`id`, `Country`.`name`, `Country`.`short_name`, `Country`.`fre_name`, `Country`.`fre_short_name`, `Country`.`por_name`, `Country`.`por_short_name`, `Country`.`currency`, `Country`.`member`, `CountriesNotification`.`id`, `CountriesNotification`.`country_id`, `CountriesNotification`.`notification_id` FROM `countries` AS `Country` JOIN `countries_notifications` AS `CountriesNotification` ON (`CountriesNotification`.`notification_id` IN ('55117a49-26c0-4974-9fd9-df16c5bdc882', '551179fc-23d0-4149-950c-dd9fc5bdc882', '551178c6-6ef4-4144-bf09-dc9bc5bdc882', '54d4e89e-c0bc-4e5f-b4ab-1c38c5bdc882', '54d245ce-125c-40c3-9f0e-4c68c5bdc882') AND `CountriesNotification`.`country_id` = `Country`.`id`) | | 1 | 1 | 0 | |
SELECT (sum(if(`Status`.`nonactionable` = 0, 1, 0))) AS `Complaint__total`, (sum(if(`Status`.`resolved` = 1, 1, 0))) AS `Complaint__resolved`, (sum(if(`Status`.`resolved` = 0 AND `Status`.`nonactionable` = 0, 1, 0))) AS `Complaint__progress` FROM `complaints` AS `Complaint` LEFT JOIN `statuses` AS `Status` ON (`Complaint`.`status_id` = `Status`.`id`) WHERE `Status`.`default` = 0 AND `Status`.`rejected` = 0 ORDER BY `Complaint`.`modified` DESC LIMIT 1 | | 1 | 1 | 0 | |