| Query | Error | Affected | Num. rows | Took (ms) | Actions |
|---|
| DESCRIBE `users` | | 27 | 27 | 1 | |
| DESCRIBE `households` | | 5 | 5 | 0 | |
| DESCRIBE `attendances` | | 6 | 6 | 0 | |
| DESCRIBE `schools` | | 11 | 11 | 0 | |
| 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 `rankforusers` | | 8 | 8 | 0 | |
| DESCRIBE `ranks` | | 10 | 10 | 0 | |
| DESCRIBE `tests` | | 7 | 7 | 0 | |
| DESCRIBE `testregistrations` | | 13 | 13 | 0 | |
| DESCRIBE `bills` | | 15 | 15 | 1 | maybe slow |
| DESCRIBE `eventregistrations` | | 6 | 6 | 0 | |
| DESCRIBE `usermemberships` | | 10 | 10 | 0 | |
| DESCRIBE `smtps` | | 7 | 7 | 0 | |
| DESCRIBE `schoolmembers` | | 7 | 7 | 0 | |
| DESCRIBE `campaigns` | | 12 | 12 | 1 | maybe slow |
| DESCRIBE `templates` | | 11 | 11 | 0 | |
| DESCRIBE `mailinglists` | | 8 | 8 | 0 | |
| DESCRIBE `queues` | | 14 | 14 | 1 | maybe slow |
| DESCRIBE `recipients` | | 7 | 7 | 0 | |
| DESCRIBE `trials` | | 11 | 11 | 0 | |
| SELECT COUNT(*) AS `count` FROM `users` AS `User` LEFT JOIN `households` AS `Household` ON (`User`.`household_id` = `Household`.`id`) WHERE 1 = 1 | | 1 | 1 | 0 | |
| SELECT `User`.`id`, `User`.`group_id`, `User`.`username`, `User`.`role`, `User`.`password`, `User`.`email`, `User`.`phone`, `User`.`active`, `User`.`first_name`, `User`.`last_name`, `User`.`country`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`zip_code`, `User`.`created`, `User`.`modified`, `User`.`about_me`, `User`.`household_id`, `User`.`is_head`, `User`.`birthdate`, `User`.`activated`, `User`.`school_id`, `User`.`name`, `User`.`uniform_size`, `User`.`barcode`, `User`.`photo`, `Household`.`id`, `Household`.`name`, `Household`.`payment_token`, `Household`.`payment_type`, `Household`.`school_id` FROM `users` AS `User` LEFT JOIN `households` AS `Household` ON (`User`.`household_id` = `Household`.`id`) WHERE 1 = 1 LIMIT 120, 20 | | 7 | 7 | 1 | maybe slow |
| SELECT `Household`.`id`, `Household`.`name`, `Household`.`payment_token`, `Household`.`payment_type`, `Household`.`school_id` FROM `households` AS `Household` WHERE `Household`.`id` = 76 | | 1 | 1 | 0 | |
| SELECT `User`.`id`, `User`.`group_id`, `User`.`username`, `User`.`role`, `User`.`password`, `User`.`email`, `User`.`phone`, `User`.`active`, `User`.`first_name`, `User`.`last_name`, `User`.`country`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`zip_code`, `User`.`created`, `User`.`modified`, `User`.`about_me`, `User`.`household_id`, `User`.`is_head`, `User`.`birthdate`, `User`.`activated`, `User`.`school_id`, `User`.`name`, `User`.`uniform_size`, `User`.`barcode`, `User`.`photo` FROM `users` AS `User` WHERE `User`.`household_id` = (76) | | 2 | 2 | 0 | |
| SELECT `Household`.`id`, `Household`.`name`, `Household`.`payment_token`, `Household`.`payment_type`, `Household`.`school_id` FROM `households` AS `Household` WHERE `Household`.`id` = 77 | | 1 | 1 | 0 | |
| SELECT `User`.`id`, `User`.`group_id`, `User`.`username`, `User`.`role`, `User`.`password`, `User`.`email`, `User`.`phone`, `User`.`active`, `User`.`first_name`, `User`.`last_name`, `User`.`country`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`zip_code`, `User`.`created`, `User`.`modified`, `User`.`about_me`, `User`.`household_id`, `User`.`is_head`, `User`.`birthdate`, `User`.`activated`, `User`.`school_id`, `User`.`name`, `User`.`uniform_size`, `User`.`barcode`, `User`.`photo` FROM `users` AS `User` WHERE `User`.`household_id` = (77) | | 2 | 2 | 0 | |
| SELECT `Household`.`id`, `Household`.`name`, `Household`.`payment_token`, `Household`.`payment_type`, `Household`.`school_id` FROM `households` AS `Household` WHERE `Household`.`id` = 78 | | 1 | 1 | 0 | |
| SELECT `User`.`id`, `User`.`group_id`, `User`.`username`, `User`.`role`, `User`.`password`, `User`.`email`, `User`.`phone`, `User`.`active`, `User`.`first_name`, `User`.`last_name`, `User`.`country`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`zip_code`, `User`.`created`, `User`.`modified`, `User`.`about_me`, `User`.`household_id`, `User`.`is_head`, `User`.`birthdate`, `User`.`activated`, `User`.`school_id`, `User`.`name`, `User`.`uniform_size`, `User`.`barcode`, `User`.`photo` FROM `users` AS `User` WHERE `User`.`household_id` = (78) | | 2 | 2 | 0 | |
| SELECT `Household`.`id`, `Household`.`name`, `Household`.`payment_token`, `Household`.`payment_type`, `Household`.`school_id` FROM `households` AS `Household` WHERE `Household`.`id` = 79 | | 1 | 1 | 0 | |
| SELECT `User`.`id`, `User`.`group_id`, `User`.`username`, `User`.`role`, `User`.`password`, `User`.`email`, `User`.`phone`, `User`.`active`, `User`.`first_name`, `User`.`last_name`, `User`.`country`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`zip_code`, `User`.`created`, `User`.`modified`, `User`.`about_me`, `User`.`household_id`, `User`.`is_head`, `User`.`birthdate`, `User`.`activated`, `User`.`school_id`, `User`.`name`, `User`.`uniform_size`, `User`.`barcode`, `User`.`photo` FROM `users` AS `User` WHERE `User`.`household_id` = (79) | | 2 | 2 | 0 | |
| SELECT `Household`.`id`, `Household`.`name`, `Household`.`payment_token`, `Household`.`payment_type`, `Household`.`school_id` FROM `households` AS `Household` WHERE `Household`.`id` = 80 | | 1 | 1 | 0 | |
| SELECT `User`.`id`, `User`.`group_id`, `User`.`username`, `User`.`role`, `User`.`password`, `User`.`email`, `User`.`phone`, `User`.`active`, `User`.`first_name`, `User`.`last_name`, `User`.`country`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`zip_code`, `User`.`created`, `User`.`modified`, `User`.`about_me`, `User`.`household_id`, `User`.`is_head`, `User`.`birthdate`, `User`.`activated`, `User`.`school_id`, `User`.`name`, `User`.`uniform_size`, `User`.`barcode`, `User`.`photo` FROM `users` AS `User` WHERE `User`.`household_id` = (80) | | 2 | 2 | 0 | |
| SELECT `Household`.`id`, `Household`.`name`, `Household`.`payment_token`, `Household`.`payment_type`, `Household`.`school_id` FROM `households` AS `Household` WHERE `Household`.`id` = 81 | | 1 | 1 | 0 | |
| SELECT `User`.`id`, `User`.`group_id`, `User`.`username`, `User`.`role`, `User`.`password`, `User`.`email`, `User`.`phone`, `User`.`active`, `User`.`first_name`, `User`.`last_name`, `User`.`country`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`zip_code`, `User`.`created`, `User`.`modified`, `User`.`about_me`, `User`.`household_id`, `User`.`is_head`, `User`.`birthdate`, `User`.`activated`, `User`.`school_id`, `User`.`name`, `User`.`uniform_size`, `User`.`barcode`, `User`.`photo` FROM `users` AS `User` WHERE `User`.`household_id` = (81) | | 2 | 2 | 0 | |
| SELECT `Household`.`id`, `Household`.`name`, `Household`.`payment_token`, `Household`.`payment_type`, `Household`.`school_id` FROM `households` AS `Household` WHERE `Household`.`id` = 0 | | 0 | 0 | 0 | |
| SELECT `Attendance`.`id`, `Attendance`.`created`, `Attendance`.`modified`, `Attendance`.`user_id`, `Attendance`.`program_id`, `Attendance`.`school_id` FROM `attendances` AS `Attendance` WHERE `Attendance`.`user_id` IN (1000, 1001, 1002, 1003, 1004, 1005, 1006) | | 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`.`user_id` IN (1000, 1001, 1002, 1003, 1004, 1005, 1006) | | 0 | 0 | 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`.`user_id` IN (1000, 1001, 1002, 1003, 1004, 1005, 1006) | | 1 | 1 | 0 | |
| SELECT `User`.`id`, `User`.`group_id`, `User`.`username`, `User`.`role`, `User`.`password`, `User`.`email`, `User`.`phone`, `User`.`active`, `User`.`first_name`, `User`.`last_name`, `User`.`country`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`zip_code`, `User`.`created`, `User`.`modified`, `User`.`about_me`, `User`.`household_id`, `User`.`is_head`, `User`.`birthdate`, `User`.`activated`, `User`.`school_id`, `User`.`name`, `User`.`uniform_size`, `User`.`barcode`, `User`.`photo` FROM `users` AS `User` WHERE `User`.`id` = 1002 | | 1 | 1 | 0 | |
| SELECT `Rank`.`id`, `Rank`.`rank_name`, `Rank`.`time`, `Rank`.`at_rank`, `Rank`.`min_att`, `Rank`.`fee`, `Rank`.`created`, `Rank`.`modified`, `Rank`.`program_id`, `Rank`.`sort_id` FROM `ranks` AS `Rank` WHERE `Rank`.`id` = 1 | | 1 | 1 | 0 | |
| 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`.`id` = 1 | | 1 | 1 | 0 | |
| 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` FROM `schools` AS `School` WHERE `School`.`id` = 1 | | 1 | 1 | 0 | |
| 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`.`user_id` IN (1000, 1001, 1002, 1003, 1004, 1005, 1006) | | 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`.`user_id` IN (1000, 1001, 1002, 1003, 1004, 1005, 1006) | | 0 | 0 | 0 | |
| SELECT `Usermembership`.`id`, `Usermembership`.`start_date`, `Usermembership`.`end_date`, `Usermembership`.`created`, `Usermembership`.`modified`, `Usermembership`.`status`, `Usermembership`.`user_id`, `Usermembership`.`program_id`, `Usermembership`.`school_id`, `Usermembership`.`total_due` FROM `usermemberships` AS `Usermembership` WHERE `Usermembership`.`user_id` IN (1000, 1001, 1002, 1003, 1004, 1005, 1006) | | 3 | 3 | 0 | |
| SELECT `User`.`id`, `User`.`group_id`, `User`.`username`, `User`.`role`, `User`.`password`, `User`.`email`, `User`.`phone`, `User`.`active`, `User`.`first_name`, `User`.`last_name`, `User`.`country`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`zip_code`, `User`.`created`, `User`.`modified`, `User`.`about_me`, `User`.`household_id`, `User`.`is_head`, `User`.`birthdate`, `User`.`activated`, `User`.`school_id`, `User`.`name`, `User`.`uniform_size`, `User`.`barcode`, `User`.`photo` FROM `users` AS `User` WHERE `User`.`id` = 1001 | | 1 | 1 | 0 | |
| SELECT `User`.`id`, `User`.`group_id`, `User`.`username`, `User`.`role`, `User`.`password`, `User`.`email`, `User`.`phone`, `User`.`active`, `User`.`first_name`, `User`.`last_name`, `User`.`country`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`zip_code`, `User`.`created`, `User`.`modified`, `User`.`about_me`, `User`.`household_id`, `User`.`is_head`, `User`.`birthdate`, `User`.`activated`, `User`.`school_id`, `User`.`name`, `User`.`uniform_size`, `User`.`barcode`, `User`.`photo` FROM `users` AS `User` WHERE `User`.`id` = 1002 | | 1 | 1 | 0 | |
| SELECT `User`.`id`, `User`.`group_id`, `User`.`username`, `User`.`role`, `User`.`password`, `User`.`email`, `User`.`phone`, `User`.`active`, `User`.`first_name`, `User`.`last_name`, `User`.`country`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`zip_code`, `User`.`created`, `User`.`modified`, `User`.`about_me`, `User`.`household_id`, `User`.`is_head`, `User`.`birthdate`, `User`.`activated`, `User`.`school_id`, `User`.`name`, `User`.`uniform_size`, `User`.`barcode`, `User`.`photo` FROM `users` AS `User` WHERE `User`.`id` = 1002 | | 1 | 1 | 0 | |
| 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`.`id` = 1 | | 1 | 1 | 0 | |
| 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`.`id` = 1 | | 1 | 1 | 0 | |
| 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`.`id` = 1 | | 1 | 1 | 0 | |
| 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` FROM `schools` AS `School` WHERE `School`.`id` = 1 | | 1 | 1 | 0 | |
| 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` FROM `schools` AS `School` WHERE `School`.`id` = 1 | | 1 | 1 | 0 | |
| 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` FROM `schools` AS `School` WHERE `School`.`id` = 1 | | 1 | 1 | 0 | |
| 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`.`usermembership_id` IN (99, 101, 120) | | 6 | 6 | 0 | |
| 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`.`user_id` IN (1000, 1001, 1002, 1003, 1004, 1005, 1006) | | 6 | 6 | 0 | |
| SELECT `Eventregistration`.`id`, `Eventregistration`.`created`, `Eventregistration`.`modified`, `Eventregistration`.`user_id`, `Eventregistration`.`event_id`, `Eventregistration`.`school_id` FROM `eventregistrations` AS `Eventregistration` WHERE `Eventregistration`.`id` = 0 | | 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`.`id` = 0 | | 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`.`id` = 0 | | 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`.`id` = 0 | | 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`.`id` = 0 | | 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`.`id` = 0 | | 0 | 0 | 0 | |
| SELECT `Usermembership`.`id`, `Usermembership`.`start_date`, `Usermembership`.`end_date`, `Usermembership`.`created`, `Usermembership`.`modified`, `Usermembership`.`status`, `Usermembership`.`user_id`, `Usermembership`.`program_id`, `Usermembership`.`school_id`, `Usermembership`.`total_due` FROM `usermemberships` AS `Usermembership` WHERE `Usermembership`.`id` = 120 | | 1 | 1 | 0 | |
| SELECT `Usermembership`.`id`, `Usermembership`.`start_date`, `Usermembership`.`end_date`, `Usermembership`.`created`, `Usermembership`.`modified`, `Usermembership`.`status`, `Usermembership`.`user_id`, `Usermembership`.`program_id`, `Usermembership`.`school_id`, `Usermembership`.`total_due` FROM `usermemberships` AS `Usermembership` WHERE `Usermembership`.`id` = 120 | | 1 | 1 | 0 | |
| SELECT `Usermembership`.`id`, `Usermembership`.`start_date`, `Usermembership`.`end_date`, `Usermembership`.`created`, `Usermembership`.`modified`, `Usermembership`.`status`, `Usermembership`.`user_id`, `Usermembership`.`program_id`, `Usermembership`.`school_id`, `Usermembership`.`total_due` FROM `usermemberships` AS `Usermembership` WHERE `Usermembership`.`id` = 120 | | 1 | 1 | 0 | |
| SELECT `Usermembership`.`id`, `Usermembership`.`start_date`, `Usermembership`.`end_date`, `Usermembership`.`created`, `Usermembership`.`modified`, `Usermembership`.`status`, `Usermembership`.`user_id`, `Usermembership`.`program_id`, `Usermembership`.`school_id`, `Usermembership`.`total_due` FROM `usermemberships` AS `Usermembership` WHERE `Usermembership`.`id` = 120 | | 1 | 1 | 0 | |
| SELECT `Usermembership`.`id`, `Usermembership`.`start_date`, `Usermembership`.`end_date`, `Usermembership`.`created`, `Usermembership`.`modified`, `Usermembership`.`status`, `Usermembership`.`user_id`, `Usermembership`.`program_id`, `Usermembership`.`school_id`, `Usermembership`.`total_due` FROM `usermemberships` AS `Usermembership` WHERE `Usermembership`.`id` = 120 | | 1 | 1 | 0 | |
| SELECT `Usermembership`.`id`, `Usermembership`.`start_date`, `Usermembership`.`end_date`, `Usermembership`.`created`, `Usermembership`.`modified`, `Usermembership`.`status`, `Usermembership`.`user_id`, `Usermembership`.`program_id`, `Usermembership`.`school_id`, `Usermembership`.`total_due` FROM `usermemberships` AS `Usermembership` WHERE `Usermembership`.`id` = 120 | | 1 | 1 | 0 | |
| 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`.`id` = 0 | | 0 | 0 | 0 | |
| 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`.`id` = 0 | | 0 | 0 | 0 | |
| 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`.`id` = 0 | | 0 | 0 | 0 | |
| 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`.`id` = 0 | | 0 | 0 | 0 | |
| 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`.`id` = 0 | | 0 | 0 | 0 | |
| 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`.`id` = 0 | | 0 | 0 | 0 | |
| SELECT `User`.`id`, `User`.`group_id`, `User`.`username`, `User`.`role`, `User`.`password`, `User`.`email`, `User`.`phone`, `User`.`active`, `User`.`first_name`, `User`.`last_name`, `User`.`country`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`zip_code`, `User`.`created`, `User`.`modified`, `User`.`about_me`, `User`.`household_id`, `User`.`is_head`, `User`.`birthdate`, `User`.`activated`, `User`.`school_id`, `User`.`name`, `User`.`uniform_size`, `User`.`barcode`, `User`.`photo` FROM `users` AS `User` WHERE `User`.`id` = 1002 | | 1 | 1 | 0 | |
| SELECT `User`.`id`, `User`.`group_id`, `User`.`username`, `User`.`role`, `User`.`password`, `User`.`email`, `User`.`phone`, `User`.`active`, `User`.`first_name`, `User`.`last_name`, `User`.`country`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`zip_code`, `User`.`created`, `User`.`modified`, `User`.`about_me`, `User`.`household_id`, `User`.`is_head`, `User`.`birthdate`, `User`.`activated`, `User`.`school_id`, `User`.`name`, `User`.`uniform_size`, `User`.`barcode`, `User`.`photo` FROM `users` AS `User` WHERE `User`.`id` = 1002 | | 1 | 1 | 0 | |
| SELECT `User`.`id`, `User`.`group_id`, `User`.`username`, `User`.`role`, `User`.`password`, `User`.`email`, `User`.`phone`, `User`.`active`, `User`.`first_name`, `User`.`last_name`, `User`.`country`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`zip_code`, `User`.`created`, `User`.`modified`, `User`.`about_me`, `User`.`household_id`, `User`.`is_head`, `User`.`birthdate`, `User`.`activated`, `User`.`school_id`, `User`.`name`, `User`.`uniform_size`, `User`.`barcode`, `User`.`photo` FROM `users` AS `User` WHERE `User`.`id` = 1002 | | 1 | 1 | 0 | |
| SELECT `User`.`id`, `User`.`group_id`, `User`.`username`, `User`.`role`, `User`.`password`, `User`.`email`, `User`.`phone`, `User`.`active`, `User`.`first_name`, `User`.`last_name`, `User`.`country`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`zip_code`, `User`.`created`, `User`.`modified`, `User`.`about_me`, `User`.`household_id`, `User`.`is_head`, `User`.`birthdate`, `User`.`activated`, `User`.`school_id`, `User`.`name`, `User`.`uniform_size`, `User`.`barcode`, `User`.`photo` FROM `users` AS `User` WHERE `User`.`id` = 1002 | | 1 | 1 | 0 | |
| SELECT `User`.`id`, `User`.`group_id`, `User`.`username`, `User`.`role`, `User`.`password`, `User`.`email`, `User`.`phone`, `User`.`active`, `User`.`first_name`, `User`.`last_name`, `User`.`country`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`zip_code`, `User`.`created`, `User`.`modified`, `User`.`about_me`, `User`.`household_id`, `User`.`is_head`, `User`.`birthdate`, `User`.`activated`, `User`.`school_id`, `User`.`name`, `User`.`uniform_size`, `User`.`barcode`, `User`.`photo` FROM `users` AS `User` WHERE `User`.`id` = 1002 | | 1 | 1 | 0 | |
| SELECT `User`.`id`, `User`.`group_id`, `User`.`username`, `User`.`role`, `User`.`password`, `User`.`email`, `User`.`phone`, `User`.`active`, `User`.`first_name`, `User`.`last_name`, `User`.`country`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`zip_code`, `User`.`created`, `User`.`modified`, `User`.`about_me`, `User`.`household_id`, `User`.`is_head`, `User`.`birthdate`, `User`.`activated`, `User`.`school_id`, `User`.`name`, `User`.`uniform_size`, `User`.`barcode`, `User`.`photo` FROM `users` AS `User` WHERE `User`.`id` = 1002 | | 1 | 1 | 0 | |
| 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` FROM `schools` AS `School` WHERE `School`.`id` = 1 | | 1 | 1 | 0 | |
| 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` FROM `schools` AS `School` WHERE `School`.`id` = 1 | | 1 | 1 | 0 | |
| 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` FROM `schools` AS `School` WHERE `School`.`id` = 1 | | 1 | 1 | 0 | |
| 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` FROM `schools` AS `School` WHERE `School`.`id` = 1 | | 1 | 1 | 0 | |
| 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` FROM `schools` AS `School` WHERE `School`.`id` = 1 | | 1 | 1 | 0 | |
| 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` FROM `schools` AS `School` WHERE `School`.`id` = 1 | | 1 | 1 | 0 | |