• Micromicro 2017/18/19

• Giocatori
• Allenatori
• Link utili
(default) 11 queries took 17 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `teams`993
2DESCRIBE `players`11112
3DESCRIBE `mister_roles`442
4DESCRIBE `misters`882
5DESCRIBE `menus`992
6DESCRIBE `sponsors`442
7SELECT `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` = 64 AND `ruolo` != 'Allenatore' ORDER BY `cognome` ASC 001
8SELECT `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` = 64 AND `ruolo` = 'Allenatore' ORDER BY `Player`.`id` ASC 001
9SELECT `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` = 64 ORDER BY `Team`.`order` ASC LIMIT 1111
10SELECT `Player`.`id`, `Player`.`team_id` FROM `players` AS `Player` WHERE `Player`.`team_id` = (64) 001
11SELECT `MisterRole`.`id`, `MisterRole`.`mister_id`, `MisterRole`.`team_id`, `MisterRole`.`role` FROM `mister_roles` AS `MisterRole` WHERE `MisterRole`.`team_id` = (64) ORDER BY `MisterRole`.`role` ASC 000
(phpbb3) 1 query took 4 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `phpbb_users`76764