| Query | Error | Affected | Num. rows | Took (ms) | Actions |
|---|
| DESCRIBE `schools` | | 11 | 11 | 1 | maybe slow |
| DESCRIBE `calendars` | | 4 | 4 | 0 | |
| DESCRIBE `events` | | 19 | 19 | 1 | maybe slow |
| DESCRIBE `recurrence_rules` | | 5 | 5 | 0 | |
| DESCRIBE `schedules` | | 14 | 14 | 1 | maybe slow |
| DESCRIBE `programs` | | 8 | 8 | 0 | |
| DESCRIBE `rooms` | | 5 | 5 | 0 | |
| DESCRIBE `attendances` | | 6 | 6 | 0 | |
| DESCRIBE `users` | | 27 | 27 | 1 | |
| DESCRIBE `households` | | 5 | 5 | 0 | |
| DESCRIBE `eventregistrations` | | 6 | 6 | 1 | maybe slow |
| DESCRIBE `bills` | | 15 | 15 | 1 | maybe slow |
| DESCRIBE `usermemberships` | | 10 | 10 | 1 | maybe slow |
| DESCRIBE `testregistrations` | | 13 | 13 | 1 | maybe slow |
| DESCRIBE `tests` | | 7 | 7 | 1 | maybe slow |
| DESCRIBE `rankforusers` | | 8 | 8 | 1 | maybe slow |
| DESCRIBE `ranks` | | 10 | 10 | 1 | maybe slow |
| DESCRIBE `trials` | | 11 | 11 | 1 | maybe slow |
| DESCRIBE `smtps` | | 7 | 7 | 1 | maybe slow |
| DESCRIBE `schoolmembers` | | 7 | 7 | 1 | maybe slow |
| DESCRIBE `campaigns` | | 12 | 12 | 1 | maybe slow |
| DESCRIBE `templates` | | 11 | 11 | 1 | maybe slow |
| DESCRIBE `mailinglists` | | 8 | 8 | 1 | maybe slow |
| DESCRIBE `queues` | | 14 | 14 | 1 | maybe slow |
| DESCRIBE `recipients` | | 7 | 7 | 1 | maybe slow |
| SELECT `School`.`id`, `School`.`school_name`, `School`.`about`, `School`.`status`, `School`.`created`, `School`.`modified`, `School`.`address`, `School`.`city`, `School`.`state`, `School`.`zip_code`, `School`.`phone`, `Calendar`.`id`, `Calendar`.`title`, `Calendar`.`notes`, `Calendar`.`school_id`, `Smtp`.`id`, `Smtp`.`port`, `Smtp`.`timeout`, `Smtp`.`host`, `Smtp`.`username`, `Smtp`.`password`, `Smtp`.`school_id` FROM `schools` AS `School` LEFT JOIN `calendars` AS `Calendar` ON (`Calendar`.`school_id` = `School`.`id`) LEFT JOIN `smtps` AS `Smtp` ON (`Smtp`.`school_id` = `School`.`id`) WHERE `School`.`id` = 2 LIMIT 1 | | 1 | 1 | 1 | |
| SELECT `Attendance`.`id`, `Attendance`.`created`, `Attendance`.`modified`, `Attendance`.`user_id`, `Attendance`.`program_id`, `Attendance`.`school_id` FROM `attendances` AS `Attendance` WHERE `Attendance`.`school_id` = (2) | | 0 | 0 | 0 | |
| SELECT `Eventregistration`.`id`, `Eventregistration`.`created`, `Eventregistration`.`modified`, `Eventregistration`.`user_id`, `Eventregistration`.`event_id`, `Eventregistration`.`school_id` FROM `eventregistrations` AS `Eventregistration` WHERE `Eventregistration`.`school_id` = (2) | | 0 | 0 | 0 | |
| SELECT `Event`.`id`, `Event`.`title`, `Event`.`description`, `Event`.`date`, `Event`.`time`, `Event`.`fee`, `Event`.`created`, `Event`.`modified`, `Event`.`school_id`, `Event`.`calendar_id`, `Event`.`start_date`, `Event`.`end_date`, `Event`.`summary`, `Event`.`recurring`, `Event`.`time_zone`, `Event`.`all_day`, `Event`.`status`, `Event`.`active`, `Event`.`color` FROM `events` AS `Event` WHERE `Event`.`school_id` = (2) | | 3 | 3 | 1 | maybe slow |
| SELECT `Program`.`id`, `Program`.`title`, `Program`.`description`, `Program`.`use_rank`, `Program`.`created`, `Program`.`modified`, `Program`.`room_id`, `Program`.`school_id` FROM `programs` AS `Program` WHERE `Program`.`school_id` = (2) | | 1 | 1 | 0 | |
| SELECT `Rankforuser`.`id`, `Rankforuser`.`created`, `Rankforuser`.`modified`, `Rankforuser`.`user_id`, `Rankforuser`.`rank_id`, `Rankforuser`.`program_id`, `Rankforuser`.`school_id`, `Rankforuser`.`current_rank` FROM `rankforusers` AS `Rankforuser` WHERE `Rankforuser`.`school_id` = (2) | | 0 | 0 | 0 | |
| SELECT `Room`.`id`, `Room`.`title`, `Room`.`created`, `Room`.`modified`, `Room`.`school_id` FROM `rooms` AS `Room` WHERE `Room`.`school_id` = (2) | | 1 | 1 | 5 | maybe slow |
| SELECT `Schedule`.`id`, `Schedule`.`title`, `Schedule`.`description`, `Schedule`.`start_date`, `Schedule`.`end_date`, `Schedule`.`recurring`, `Schedule`.`created`, `Schedule`.`modified`, `Schedule`.`program_id`, `Schedule`.`school_id`, `Schedule`.`calendar_id`, `Schedule`.`time_zone`, `Schedule`.`all_day`, `Schedule`.`color` FROM `schedules` AS `Schedule` WHERE `Schedule`.`school_id` = (2) | | 0 | 0 | 1 | maybe slow |
| SELECT `Schoolmember`.`id`, `Schoolmember`.`role`, `Schoolmember`.`created`, `Schoolmember`.`modified`, `Schoolmember`.`user_id`, `Schoolmember`.`school_id`, `Schoolmember`.`title` FROM `schoolmembers` AS `Schoolmember` WHERE `Schoolmember`.`school_id` = (2) | | 1 | 1 | 0 | |
| SELECT `Campaign`.`id`, `Campaign`.`title`, `Campaign`.`subject`, `Campaign`.`send_date`, `Campaign`.`created`, `Campaign`.`modified`, `Campaign`.`school_id`, `Campaign`.`campaign_type`, `Campaign`.`template_id`, `Campaign`.`mailinglist_id`, `Campaign`.`users_id`, `Campaign`.`recipient_count` FROM `campaigns` AS `Campaign` WHERE `Campaign`.`school_id` = (2) | | 1 | 1 | 8 | maybe slow |
| SELECT `Template`.`id`, `Template`.`title`, `Template`.`description`, `Template`.`size`, `Template`.`orientation`, `Template`.`body`, `Template`.`created`, `Template`.`modified`, `Template`.`school_id`, `Template`.`category`, `Template`.`system` FROM `templates` AS `Template` WHERE `Template`.`school_id` = (2) | | 1 | 1 | 6 | maybe slow |
| SELECT `Testregistration`.`id`, `Testregistration`.`rank_name`, `Testregistration`.`created`, `Testregistration`.`modified`, `Testregistration`.`test_id`, `Testregistration`.`user_id`, `Testregistration`.`school_id`, `Testregistration`.`first_name`, `Testregistration`.`last_name`, `Testregistration`.`old_rank_id`, `Testregistration`.`rank_id`, `Testregistration`.`program_id`, `Testregistration`.`status` FROM `testregistrations` AS `Testregistration` WHERE `Testregistration`.`school_id` = (2) | | 0 | 0 | 1 | maybe slow |
| SELECT `Test`.`id`, `Test`.`title`, `Test`.`test_date`, `Test`.`created`, `Test`.`modified`, `Test`.`program_id`, `Test`.`school_id` FROM `tests` AS `Test` WHERE `Test`.`school_id` = (2) | | 0 | 0 | 0 | |
| SELECT `Trial`.`id`, `Trial`.`date`, `Trial`.`reminder`, `Trial`.`reminder_date`, `Trial`.`message`, `Trial`.`created`, `Trial`.`modified`, `Trial`.`template_id`, `Trial`.`staff_id`, `Trial`.`user_id`, `Trial`.`school_id` FROM `trials` AS `Trial` WHERE `Trial`.`school_id` = (2) | | 1 | 1 | 0 | |
| SELECT `mailinglist`.`id`, `mailinglist`.`title`, `mailinglist`.`description`, `mailinglist`.`recipients`, `mailinglist`.`created`, `mailinglist`.`modified`, `mailinglist`.`school_id`, `mailinglist`.`recipient_count` FROM `mailinglists` AS `mailinglist` WHERE `mailinglist`.`school_id` = (2) | | 1 | 1 | 10 | maybe slow |
| SELECT `Bill`.`id`, `Bill`.`due_date`, `Bill`.`description`, `Bill`.`auto_pay`, `Bill`.`amount`, `Bill`.`amount_paid`, `Bill`.`payment_type`, `Bill`.`payment_date`, `Bill`.`payment_status`, `Bill`.`created`, `Bill`.`user_id`, `Bill`.`school_id`, `Bill`.`eventregistration_id`, `Bill`.`testregistration_id`, `Bill`.`usermembership_id` FROM `bills` AS `Bill` WHERE `Bill`.`school_id` = (2) | | 0 | 0 | 1 | maybe slow |
