| 1 | DESCRIBE `teams` | | 9 | 9 | 3 |
| 2 | DESCRIBE `players` | | 11 | 11 | 2 |
| 3 | DESCRIBE `mister_roles` | | 4 | 4 | 2 |
| 4 | DESCRIBE `misters` | | 8 | 8 | 2 |
| 5 | SELECT `Player`.`id`, `Player`.`user_id`, `Player`.`team_id`, `Player`.`nome`, `Player`.`cognome`, `Player`.`ruolo`, `Player`.`nascita`, `Player`.`luogo`, `Player`.`imgpath`, `Player`.`url`, `Player`.`note`, `Team`.`id`, `Team`.`order`, `Team`.`name`, `Team`.`url`, `Team`.`calendario`, `Team`.`gallery`, `Team`.`forum`, `Team`.`risultati`, `Team`.`foto` FROM `players` AS `Player` LEFT JOIN `teams` AS `Team` ON (`Player`.`team_id` = `Team`.`id`) WHERE `team_id` = 41 AND `ruolo` != 'Allenatore' ORDER BY `cognome` ASC | | 24 | 24 | 1 |
| 6 | SELECT `Player`.`id`, `Player`.`user_id`, `Player`.`team_id`, `Player`.`nome`, `Player`.`cognome`, `Player`.`ruolo`, `Player`.`nascita`, `Player`.`luogo`, `Player`.`imgpath`, `Player`.`url`, `Player`.`note`, `Team`.`id`, `Team`.`order`, `Team`.`name`, `Team`.`url`, `Team`.`calendario`, `Team`.`gallery`, `Team`.`forum`, `Team`.`risultati`, `Team`.`foto` FROM `players` AS `Player` LEFT JOIN `teams` AS `Team` ON (`Player`.`team_id` = `Team`.`id`) WHERE `team_id` = 41 AND `ruolo` = 'Allenatore' ORDER BY `Player`.`id` ASC | | 2 | 2 | 1 |
| 7 | SELECT `Team`.`id`, `Team`.`order`, `Team`.`name`, `Team`.`url`, `Team`.`calendario`, `Team`.`gallery`, `Team`.`forum`, `Team`.`risultati`, `Team`.`foto` FROM `teams` AS `Team` WHERE `Team`.`id` = 41 ORDER BY `Team`.`order` ASC LIMIT 1 | | 1 | 1 | 0 |
| 8 | SELECT `Player`.`id`, `Player`.`team_id` FROM `players` AS `Player` WHERE `Player`.`team_id` = (41) | | 26 | 26 | 0 |
| 9 | SELECT `MisterRole`.`id`, `MisterRole`.`mister_id`, `MisterRole`.`team_id`, `MisterRole`.`role` FROM `mister_roles` AS `MisterRole` WHERE `MisterRole`.`team_id` = (41) ORDER BY `MisterRole`.`role` ASC | | 2 | 2 | 1 |
