Planifications d'examens
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SHOW FULL COLUMNS FROM `gaelexports` | 6 | 6 | 50 | |
| 2 | SHOW FULL COLUMNS FROM `countries_ciep` | 5 | 5 | 14 | |
| 3 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb4_unicode_ci'; | 1 | 1 | 33 | |
| 4 | SHOW FULL COLUMNS FROM `mothertongues` | 3 | 3 | 7 | |
| 5 | SHOW FULL COLUMNS FROM `nationalities_ciep` | 3 | 3 | 9 | |
| 6 | SHOW FULL COLUMNS FROM `examcenters` | 27 | 27 | 22 | |
| 7 | SHOW FULL COLUMNS FROM `examcenters_ciep` | 4 | 4 | 10 | |
| 8 | SHOW FULL COLUMNS FROM `users` | 46 | 46 | 16 | |
| 9 | SHOW FULL COLUMNS FROM `titles` | 2 | 2 | 12 | |
| 10 | SHOW FULL COLUMNS FROM `countries` | 2 | 2 | 14 | |
| 11 | SHOW FULL COLUMNS FROM `languages` | 4 | 4 | 14 | |
| 12 | SHOW FULL COLUMNS FROM `user_accreditations` | 10 | 10 | 5 | |
| 13 | SHOW FULL COLUMNS FROM `user_contracts` | 5 | 5 | 13 | |
| 14 | SHOW FULL COLUMNS FROM `accreditation_infos` | 19 | 19 | 50 | |
| 15 | SHOW FULL COLUMNS FROM `experts` | 6 | 6 | 1 | |
| 16 | SHOW FULL COLUMNS FROM `expertdataestimations` | 9 | 9 | 22 | |
| 17 | SHOW FULL COLUMNS FROM `delfsessions` | 17 | 17 | 23 | |
| 18 | SHOW FULL COLUMNS FROM `sessionstatuses` | 2 | 2 | 15 | |
| 19 | SHOW FULL COLUMNS FROM `groups` | 6 | 6 | 25 | |
| 20 | SHOW FULL COLUMNS FROM `permissions` | 2 | 2 | 12 | |
| 21 | SHOW FULL COLUMNS FROM `groups_permissions` | 3 | 3 | 5 | |
| 22 | SHOW FULL COLUMNS FROM `groups_examcenters` | 3 | 3 | 15 | |
| 23 | SHOW FULL COLUMNS FROM `messages` | 10 | 10 | 11 | |
| 24 | SHOW FULL COLUMNS FROM `polls` | 6 | 6 | 15 | |
| 25 | SHOW FULL COLUMNS FROM `users_groups` | 3 | 3 | 23 | |
| 26 | SHOW FULL COLUMNS FROM `messages_users` | 6 | 6 | 17 | |
| 27 | SHOW FULL COLUMNS FROM `polls_users` | 4 | 4 | 15 | |
| 28 | SHOW FULL COLUMNS FROM `messages_groups` | 3 | 3 | 9 | |
| 29 | SHOW FULL COLUMNS FROM `templates` | 7 | 7 | 14 | |
| 30 | SHOW FULL COLUMNS FROM `correctorratingstatuses` | 2 | 2 | 60 | |
| 31 | SHOW FULL COLUMNS FROM `exams` | 13 | 13 | 17 | |
| 32 | SHOW FULL COLUMNS FROM `diplomas` | 11 | 11 | 17 | |
| 33 | SHOW FULL COLUMNS FROM `diplomaparts` | 6 | 6 | 26 | |
| 34 | SHOW FULL COLUMNS FROM `diplomapartnames` | 2 | 2 | 13 | |
| 35 | SHOW FULL COLUMNS FROM `exammodes` | 4 | 4 | 20 | |
| 36 | SHOW FULL COLUMNS FROM `examregistrations` | 54 | 54 | 34 | |
| 37 | SHOW FULL COLUMNS FROM `candidates` | 37 | 37 | 20 | |
| 38 | SHOW FULL COLUMNS FROM `sexes_ciep` | 2 | 2 | 22 | |
| 39 | SHOW FULL COLUMNS FROM `domains` | 3 | 3 | 2 | |
| 40 | SHOW FULL COLUMNS FROM `examdays` | 6 | 6 | 10 | |
| 41 | SHOW FULL COLUMNS FROM `examdayparts` | 2 | 2 | 6 | |
| 42 | SHOW FULL COLUMNS FROM `expertregistrations` | 8 | 8 | 14 | |
| 43 | SHOW FULL COLUMNS FROM `expertinvitations` | 4 | 4 | 11 | |
| 44 | SHOW FULL COLUMNS FROM `expertinvitations_experts` | 3 | 3 | 10 | |
| 45 | SHOW FULL COLUMNS FROM `supervisorregistrations` | 7 | 7 | 10 | |
| 46 | SHOW FULL COLUMNS FROM `supervisorinvitations` | 4 | 4 | 17 | |
| 47 | SHOW FULL COLUMNS FROM `supervisors` | 6 | 6 | 11 | |
| 48 | SHOW FULL COLUMNS FROM `supervisorinvitations_supervisors` | 3 | 3 | 20 | |
| 49 | SHOW FULL COLUMNS FROM `supervisorregistrations_examdays` | 3 | 3 | 21 | |
| 50 | SHOW FULL COLUMNS FROM `expertregistrations_examdays` | 3 | 3 | 16 | |
| 51 | SHOW FULL COLUMNS FROM `payment_options` | 3 | 3 | 25 | |
| 52 | SHOW FULL COLUMNS FROM `partitions` | 10 | 10 | 19 | |
| 53 | SHOW FULL COLUMNS FROM `schools` | 21 | 21 | 19 | |
| 54 | SHOW FULL COLUMNS FROM `roombookings` | 9 | 9 | 30 | |
| 55 | SHOW FULL COLUMNS FROM `rooms` | 5 | 5 | 11 | |
| 56 | SHOW FULL COLUMNS FROM `buildings` | 14 | 14 | 9 | |
| 57 | SHOW FULL COLUMNS FROM `roomtypes` | 2 | 2 | 2 | |
| 58 | SHOW FULL COLUMNS FROM `partitions_roombookings` | 4 | 4 | 22 | |
| 59 | SHOW FULL COLUMNS FROM `educations` | 4 | 4 | 15 | |
| 60 | SHOW FULL COLUMNS FROM `educationabroads` | 2 | 2 | 5 | |
| 61 | SHOW FULL COLUMNS FROM `results` | 32 | 32 | 62 | |
| 62 | SHOW FULL COLUMNS FROM `recourses` | 11 | 11 | 14 | |
| 63 | SHOW FULL COLUMNS FROM `assignments_oral_candidates` | 5 | 5 | 1 | |
| 64 | SHOW FULL COLUMNS FROM `assignments_oral` | 9 | 9 | 21 | |
| 65 | SHOW FULL COLUMNS FROM `assignments` | 8 | 8 | 10 | |
| 66 | SHOW FULL COLUMNS FROM `assignments_written` | 6 | 6 | 1 | |
| 67 | SHOW FULL COLUMNS FROM `assignments_written_candidates` | 3 | 3 | 10 | |
| 68 | SHOW FULL COLUMNS FROM `assignments_written_supervisors` | 3 | 3 | 10 | |
| 69 | SHOW FULL COLUMNS FROM `assignments_preparation` | 10 | 10 | 15 | |
| 70 | SHOW FULL COLUMNS FROM `assignments_preparation_candidates` | 7 | 7 | 2 | |
| 71 | SHOW FULL COLUMNS FROM `assignments_preparation_supervisors` | 3 | 3 | 14 | |
| 72 | SHOW FULL COLUMNS FROM `experts_diplomas` | 3 | 3 | 2 | |
| 73 | SHOW FULL COLUMNS FROM `experts_exammodes` | 3 | 3 | 2 | |
| 74 | SHOW FULL COLUMNS FROM `importedexamregistrations` | 55 | 55 | 12 | |
| 75 | SHOW FULL COLUMNS FROM `onlineexamregistrations` | 65 | 65 | 26 | |
| 76 | SHOW FULL COLUMNS FROM `correctiondays` | 5 | 5 | 7 | |
| 77 | SHOW FULL COLUMNS FROM `correctorregistrations` | 8 | 8 | 13 | |
| 78 | SHOW FULL COLUMNS FROM `correctorinvitations` | 3 | 3 | 13 | |
| 79 | SHOW FULL COLUMNS FROM `correctors` | 8 | 8 | 1 | |
| 80 | SHOW FULL COLUMNS FROM `correctorestimations` | 16 | 16 | 17 | |
| 81 | SHOW FULL COLUMNS FROM `ratings` | 2 | 2 | 8 | |
| 82 | SHOW FULL COLUMNS FROM `correctordataestimations` | 10 | 10 | 21 | |
| 83 | SHOW FULL COLUMNS FROM `correctorestimatestatuses` | 5 | 5 | 11 | |
| 84 | SHOW FULL COLUMNS FROM `groupbossestimatelevels` | 6 | 6 | 3 | |
| 85 | SHOW FULL COLUMNS FROM `correctors_diplomas` | 3 | 3 | 2 | |
| 86 | SHOW FULL COLUMNS FROM `correctors_exammodes` | 3 | 3 | 16 | |
| 87 | SHOW FULL COLUMNS FROM `correctorinvitations_correctors` | 3 | 3 | 17 | |
| 88 | SHOW FULL COLUMNS FROM `correction_exammodes` | 2 | 2 | 9 | |
| 89 | SHOW FULL COLUMNS FROM `absencereasons` | 2 | 2 | 9 | |
| 90 | SHOW FULL COLUMNS FROM `correctorregistrations_correctiondays` | 3 | 3 | 6 | |
| 91 | SHOW FULL COLUMNS FROM `expertsimpleestimations` | 12 | 12 | 8 | |
| 92 | SHOW FULL COLUMNS FROM `expertsimpleestimations_examcenters` | 3 | 3 | 9 | |
| 93 | SHOW FULL COLUMNS FROM `expertdetailestimations` | 34 | 34 | 8 | |
| 94 | SHOW FULL COLUMNS FROM `expertdetailestimations_examcenters` | 3 | 3 | 7 | |
| 95 | SHOW FULL COLUMNS FROM `externalparticipants` | 46 | 46 | 7 | |
| 96 | SHOW FULL COLUMNS FROM `externalparticipanteducations` | 2 | 2 | 2 | |
| 97 | SHOW FULL COLUMNS FROM `seminardates` | 21 | 21 | 9 | |
| 98 | SHOW FULL COLUMNS FROM `seminars` | 31 | 31 | 11 | |
| 99 | SHOW FULL COLUMNS FROM `seminars_diplomas` | 3 | 3 | 2 | |
| 100 | SHOW FULL COLUMNS FROM `seminardays` | 7 | 7 | 9 | |
| 101 | SHOW FULL COLUMNS FROM `seminardays_leaders` | 3 | 3 | 7 | |
| 102 | SHOW FULL COLUMNS FROM `onlineseminarregistrations` | 37 | 37 | 6 | |
| 103 | SHOW FULL COLUMNS FROM `seminars_leaders` | 3 | 3 | 12 | |
| 104 | SHOW FULL COLUMNS FROM `seminars_users` | 17 | 17 | 2 | |
| 105 | SHOW FULL COLUMNS FROM `emails` | 6 | 6 | 7 | |
| 106 | SHOW FULL COLUMNS FROM `user_accreditations_emails` | 3 | 3 | 4 | |
| 107 | SHOW FULL COLUMNS FROM `gaelexportsuccesses` | 14 | 14 | 7 | |
| 108 | SELECT * FROM `translations` WHERE 1 | 2573 | 2573 | 70 |