Planifications d'examens
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SHOW FULL COLUMNS FROM `infos` | 13 | 13 | 1 | |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb4_unicode_ci'; | 1 | 1 | 0 | |
| 3 | SHOW FULL COLUMNS FROM `groups` | 6 | 6 | 1 | |
| 4 | SHOW FULL COLUMNS FROM `permissions` | 2 | 2 | 1 | |
| 5 | SHOW FULL COLUMNS FROM `examcenters` | 27 | 27 | 1 | |
| 6 | SHOW FULL COLUMNS FROM `examcenters_ciep` | 4 | 4 | 1 | |
| 7 | SHOW FULL COLUMNS FROM `users` | 44 | 44 | 1 | |
| 8 | SHOW FULL COLUMNS FROM `titles` | 2 | 2 | 1 | |
| 9 | SHOW FULL COLUMNS FROM `countries` | 2 | 2 | 0 | |
| 10 | SHOW FULL COLUMNS FROM `languages` | 4 | 4 | 0 | |
| 11 | SHOW FULL COLUMNS FROM `user_accreditations` | 10 | 10 | 0 | |
| 12 | SHOW FULL COLUMNS FROM `user_contracts` | 5 | 5 | 0 | |
| 13 | SHOW FULL COLUMNS FROM `accreditation_infos` | 19 | 19 | 1 | |
| 14 | SHOW FULL COLUMNS FROM `experts` | 6 | 6 | 0 | |
| 15 | SHOW FULL COLUMNS FROM `expertdataestimations` | 9 | 9 | 1 | |
| 16 | SHOW FULL COLUMNS FROM `delfsessions` | 17 | 17 | 1 | |
| 17 | SHOW FULL COLUMNS FROM `sessionstatuses` | 2 | 2 | 1 | |
| 18 | SHOW FULL COLUMNS FROM `messages` | 10 | 10 | 1 | |
| 19 | SHOW FULL COLUMNS FROM `polls` | 6 | 6 | 0 | |
| 20 | SHOW FULL COLUMNS FROM `users_groups` | 3 | 3 | 0 | |
| 21 | SHOW FULL COLUMNS FROM `messages_users` | 6 | 6 | 1 | |
| 22 | SHOW FULL COLUMNS FROM `polls_users` | 4 | 4 | 0 | |
| 23 | SHOW FULL COLUMNS FROM `groups_permissions` | 3 | 3 | 1 | |
| 24 | SHOW FULL COLUMNS FROM `groups_examcenters` | 3 | 3 | 1 | |
| 25 | SHOW FULL COLUMNS FROM `messages_groups` | 3 | 3 | 0 | |
| 26 | SHOW FULL COLUMNS FROM `templates` | 7 | 7 | 1 | |
| 27 | SHOW FULL COLUMNS FROM `correctorratingstatuses` | 2 | 2 | 0 | |
| 28 | SHOW FULL COLUMNS FROM `exams` | 12 | 12 | 1 | |
| 29 | SHOW FULL COLUMNS FROM `diplomas` | 11 | 11 | 1 | |
| 30 | SHOW FULL COLUMNS FROM `diplomaparts` | 6 | 6 | 1 | |
| 31 | SHOW FULL COLUMNS FROM `diplomapartnames` | 2 | 2 | 1 | |
| 32 | SHOW FULL COLUMNS FROM `exammodes` | 4 | 4 | 0 | |
| 33 | SHOW FULL COLUMNS FROM `examregistrations` | 54 | 54 | 1 | |
| 34 | SHOW FULL COLUMNS FROM `candidates` | 37 | 37 | 1 | |
| 35 | SHOW FULL COLUMNS FROM `nationalities_ciep` | 3 | 3 | 0 | |
| 36 | SHOW FULL COLUMNS FROM `mothertongues` | 3 | 3 | 0 | |
| 37 | SHOW FULL COLUMNS FROM `countries_ciep` | 5 | 5 | 0 | |
| 38 | SHOW FULL COLUMNS FROM `sexes_ciep` | 2 | 2 | 1 | |
| 39 | SHOW FULL COLUMNS FROM `domains` | 3 | 3 | 0 | |
| 40 | SHOW FULL COLUMNS FROM `examdays` | 6 | 6 | 1 | |
| 41 | SHOW FULL COLUMNS FROM `examdayparts` | 2 | 2 | 1 | |
| 42 | SHOW FULL COLUMNS FROM `expertregistrations` | 8 | 8 | 0 | |
| 43 | SHOW FULL COLUMNS FROM `expertinvitations` | 4 | 4 | 1 | |
| 44 | SHOW FULL COLUMNS FROM `expertinvitations_experts` | 3 | 3 | 1 | |
| 45 | SHOW FULL COLUMNS FROM `supervisorregistrations` | 7 | 7 | 0 | |
| 46 | SHOW FULL COLUMNS FROM `supervisorinvitations` | 4 | 4 | 0 | |
| 47 | SHOW FULL COLUMNS FROM `supervisors` | 6 | 6 | 1 | |
| 48 | SHOW FULL COLUMNS FROM `supervisorinvitations_supervisors` | 3 | 3 | 1 | |
| 49 | SHOW FULL COLUMNS FROM `supervisorregistrations_examdays` | 3 | 3 | 1 | |
| 50 | SHOW FULL COLUMNS FROM `expertregistrations_examdays` | 3 | 3 | 0 | |
| 51 | SHOW FULL COLUMNS FROM `payment_options` | 3 | 3 | 0 | |
| 52 | SHOW FULL COLUMNS FROM `partitions` | 10 | 10 | 1 | |
| 53 | SHOW FULL COLUMNS FROM `schools` | 21 | 21 | 1 | |
| 54 | SHOW FULL COLUMNS FROM `roombookings` | 9 | 9 | 1 | |
| 55 | SHOW FULL COLUMNS FROM `rooms` | 5 | 5 | 0 | |
| 56 | SHOW FULL COLUMNS FROM `buildings` | 14 | 14 | 1 | |
| 57 | SHOW FULL COLUMNS FROM `roomtypes` | 2 | 2 | 1 | |
| 58 | SHOW FULL COLUMNS FROM `partitions_roombookings` | 4 | 4 | 1 | |
| 59 | SHOW FULL COLUMNS FROM `educations` | 4 | 4 | 1 | |
| 60 | SHOW FULL COLUMNS FROM `educationabroads` | 2 | 2 | 0 | |
| 61 | SHOW FULL COLUMNS FROM `results` | 26 | 26 | 1 | |
| 62 | SHOW FULL COLUMNS FROM `recourses` | 11 | 11 | 1 | |
| 63 | SHOW FULL COLUMNS FROM `assignments_oral_candidates` | 5 | 5 | 1 | |
| 64 | SHOW FULL COLUMNS FROM `assignments_oral` | 9 | 9 | 1 | |
| 65 | SHOW FULL COLUMNS FROM `assignments` | 8 | 8 | 1 | |
| 66 | SHOW FULL COLUMNS FROM `assignments_written` | 6 | 6 | 1 | |
| 67 | SHOW FULL COLUMNS FROM `assignments_written_candidates` | 3 | 3 | 0 | |
| 68 | SHOW FULL COLUMNS FROM `assignments_written_supervisors` | 3 | 3 | 1 | |
| 69 | SHOW FULL COLUMNS FROM `assignments_preparation` | 10 | 10 | 1 | |
| 70 | SHOW FULL COLUMNS FROM `assignments_preparation_candidates` | 7 | 7 | 1 | |
| 71 | SHOW FULL COLUMNS FROM `assignments_preparation_supervisors` | 3 | 3 | 1 | |
| 72 | SHOW FULL COLUMNS FROM `experts_diplomas` | 3 | 3 | 0 | |
| 73 | SHOW FULL COLUMNS FROM `experts_exammodes` | 3 | 3 | 0 | |
| 74 | SHOW FULL COLUMNS FROM `importedexamregistrations` | 55 | 55 | 1 | |
| 75 | SHOW FULL COLUMNS FROM `onlineexamregistrations` | 64 | 64 | 1 | |
| 76 | SHOW FULL COLUMNS FROM `correctiondays` | 5 | 5 | 1 | |
| 77 | SHOW FULL COLUMNS FROM `correctorregistrations` | 8 | 8 | 1 | |
| 78 | SHOW FULL COLUMNS FROM `correctorinvitations` | 3 | 3 | 1 | |
| 79 | SHOW FULL COLUMNS FROM `correctors` | 8 | 8 | 1 | |
| 80 | SHOW FULL COLUMNS FROM `correctorestimations` | 16 | 16 | 1 | |
| 81 | SHOW FULL COLUMNS FROM `ratings` | 2 | 2 | 1 | |
| 82 | SHOW FULL COLUMNS FROM `correctordataestimations` | 10 | 10 | 1 | |
| 83 | SHOW FULL COLUMNS FROM `correctorestimatestatuses` | 5 | 5 | 0 | |
| 84 | SHOW FULL COLUMNS FROM `groupbossestimatelevels` | 6 | 6 | 1 | |
| 85 | SHOW FULL COLUMNS FROM `correctors_diplomas` | 3 | 3 | 1 | |
| 86 | SHOW FULL COLUMNS FROM `correctors_exammodes` | 3 | 3 | 1 | |
| 87 | SHOW FULL COLUMNS FROM `correctorinvitations_correctors` | 3 | 3 | 1 | |
| 88 | SHOW FULL COLUMNS FROM `correction_exammodes` | 2 | 2 | 0 | |
| 89 | SHOW FULL COLUMNS FROM `absencereasons` | 2 | 2 | 1 | |
| 90 | SHOW FULL COLUMNS FROM `correctorregistrations_correctiondays` | 3 | 3 | 0 | |
| 91 | SHOW FULL COLUMNS FROM `expertsimpleestimations` | 12 | 12 | 1 | |
| 92 | SHOW FULL COLUMNS FROM `expertsimpleestimations_examcenters` | 3 | 3 | 1 | |
| 93 | SHOW FULL COLUMNS FROM `expertdetailestimations` | 34 | 34 | 1 | |
| 94 | SHOW FULL COLUMNS FROM `expertdetailestimations_examcenters` | 3 | 3 | 0 | |
| 95 | SHOW FULL COLUMNS FROM `externalparticipants` | 46 | 46 | 1 | |
| 96 | SHOW FULL COLUMNS FROM `externalparticipanteducations` | 2 | 2 | 0 | |
| 97 | SHOW FULL COLUMNS FROM `seminardates` | 21 | 21 | 1 | |
| 98 | SHOW FULL COLUMNS FROM `seminars` | 31 | 31 | 1 | |
| 99 | SHOW FULL COLUMNS FROM `seminars_diplomas` | 3 | 3 | 1 | |
| 100 | SHOW FULL COLUMNS FROM `seminardays` | 7 | 7 | 1 | |
| 101 | SHOW FULL COLUMNS FROM `seminardays_leaders` | 3 | 3 | 1 | |
| 102 | SHOW FULL COLUMNS FROM `onlineseminarregistrations` | 37 | 37 | 1 | |
| 103 | SHOW FULL COLUMNS FROM `seminars_leaders` | 3 | 3 | 1 | |
| 104 | SHOW FULL COLUMNS FROM `seminars_users` | 17 | 17 | 1 | |
| 105 | SHOW FULL COLUMNS FROM `emails` | 6 | 6 | 1 | |
| 106 | SHOW FULL COLUMNS FROM `user_accreditations_emails` | 3 | 3 | 1 | |
| 107 | SHOW FULL COLUMNS FROM `groups_infos` | 3 | 3 | 1 | |
| 108 | SHOW FULL COLUMNS FROM `documents` | 10 | 10 | 1 | |
| 109 | SHOW FULL COLUMNS FROM `folders` | 5 | 5 | 1 | |
| 110 | SHOW FULL COLUMNS FROM `groups_documents` | 3 | 3 | 1 | |
| 111 | SHOW FULL COLUMNS FROM `gaelexports` | 6 | 6 | 1 | |
| 112 | SHOW FULL COLUMNS FROM `gaelexportsuccesses` | 14 | 14 | 1 | |
| 113 | SELECT DISTINCT `Info`.`id`, `Info`.`number`, `Info`.`title_deu`, `Info`.`title_fre`, `Info`.`title_ita`, `Info`.`title_eng`, `Info`.`text_deu`, `Info`.`text_fre`, `Info`.`text_ita`, `Info`.`text_eng`, `Info`.`user_id`, `Info`.`date` FROM `infos` AS `Info` WHERE `Info`.`archived` = '0' ORDER BY `Info`.`number` DESC LIMIT 5 | 5 | 5 | 5 | |
| 114 | SELECT `Group`.`id`, `Group`.`name`, `Group`.`level`, `Group`.`redirect`, `Group`.`perm_type`, `Group`.`active`, `GroupsInfo`.`id`, `GroupsInfo`.`group_id`, `GroupsInfo`.`info_id` FROM `groups` AS `Group` JOIN `groups_infos` AS `GroupsInfo` ON (`GroupsInfo`.`info_id` IN (315, 310, 313, 309, 308) AND `GroupsInfo`.`group_id` = `Group`.`id`) | 172 | 172 | 4 | |
| 115 | SELECT `User`.`id`, `User`.`title_id`, `User`.`prename`, `User`.`name`, `User`.`address`, `User`.`address2`, `User`.`postalcode`, `User`.`city`, `User`.`country_id`, `User`.`nationality_ciep`, `User`.`business_name`, `User`.`business_address`, `User`.`business_postalcode`, `User`.`interested_delfdalf`, `User`.`interested_evalling`, `User`.`interested_newsletter`, `User`.`tel_private`, `User`.`tel_work`, `User`.`tel_mobile`, `User`.`email`, `User`.`email2`, `User`.`forward_email`, `User`.`birthday`, `User`.`language_id`, `User`.`examcenter_id`, `User`.`username`, `User`.`passwd`, `User`.`password`, `User`.`comments`, `User`.`active`, `User`.`work_contract_signed`, `User`.`last_visit`, `User`.`deleted`, `User`.`ignore_accreditation`, `User`.`accreditation_mail_counter`, `User`.`accred_count_delf`, `User`.`accred_count_dalf`, `User`.`profile_pic`, `User`.`unique_code`, `User`.`locale`, `User`.`sms_service`, `User`.`two_fa_key`, `User`.`two_fa_status`, `User`.`random_string`, `Title`.`id`, `Title`.`code`, `Country`.`id`, `Country`.`name`, `Language`.`id`, `Language`.`code`, `Language`.`name`, `Language`.`active`, `Examcenter`.`id`, `Examcenter`.`name`, `Examcenter`.`name_in_german`, `Examcenter`.`abbreviation`, `Examcenter`.`address`, `Examcenter`.`address2`, `Examcenter`.`postalcode`, `Examcenter`.`city`, `Examcenter`.`city_in_french`, `Examcenter`.`email`, `Examcenter`.`email_from`, `Examcenter`.`phone`, `Examcenter`.`fax`, `Examcenter`.`examcenter_ciep`, `Examcenter`.`executive_id`, `Examcenter`.`administration_id`, `Examcenter`.`jurypresident_id`, `Examcenter`.`active`, `Examcenter`.`contract_signed`, `Examcenter`.`notes`, `Examcenter`.`is_correctioncenter`, `Examcenter`.`candidate_ciep_id_counter`, `Examcenter`.`paymentinformation`, `Examcenter`.`logiciel_db_name`, `Examcenter`.`url_contact_info`, `Examcenter`.`gael_intitule`, `Examcenter`.`gael_etablissement` FROM `users` AS `User` LEFT JOIN `titles` AS `Title` ON (`User`.`title_id` = `Title`.`id`) LEFT JOIN `countries` AS `Country` ON (`User`.`country_id` = `Country`.`id`) LEFT JOIN `languages` AS `Language` ON (`User`.`language_id` = `Language`.`id`) LEFT JOIN `examcenters` AS `Examcenter` ON (`User`.`examcenter_id` = `Examcenter`.`id`) WHERE `User`.`id` = '' LIMIT 1 | 0 | 0 | 1 | |
| 116 | SELECT `Message`.`id`, `Message`.`user_id`, `Message`.`main_message`, `Message`.`is_thread`, `Message`.`subject`, `Message`.`message_text`, `Message`.`time_sent`, `Message`.`last_message_date`, `Message`.`deleted`, `Message`.`category`, `User`.`id`, `User`.`title_id`, `User`.`prename`, `User`.`name`, `User`.`address`, `User`.`address2`, `User`.`postalcode`, `User`.`city`, `User`.`country_id`, `User`.`nationality_ciep`, `User`.`business_name`, `User`.`business_address`, `User`.`business_postalcode`, `User`.`interested_delfdalf`, `User`.`interested_evalling`, `User`.`interested_newsletter`, `User`.`tel_private`, `User`.`tel_work`, `User`.`tel_mobile`, `User`.`email`, `User`.`email2`, `User`.`forward_email`, `User`.`birthday`, `User`.`language_id`, `User`.`examcenter_id`, `User`.`username`, `User`.`passwd`, `User`.`password`, `User`.`comments`, `User`.`active`, `User`.`work_contract_signed`, `User`.`last_visit`, `User`.`deleted`, `User`.`ignore_accreditation`, `User`.`accreditation_mail_counter`, `User`.`accred_count_delf`, `User`.`accred_count_dalf`, `User`.`profile_pic`, `User`.`unique_code`, `User`.`locale`, `User`.`sms_service`, `User`.`two_fa_key`, `User`.`two_fa_status`, `User`.`random_string`, `MessagesUser`.`id`, `MessagesUser`.`message_id`, `MessagesUser`.`user_id`, `MessagesUser`.`read`, `MessagesUser`.`deleted`, `MessagesUser`.`is_cc` FROM `messages` AS `Message` LEFT JOIN `users` AS `User` ON (`Message`.`user_id` = `User`.`id`) LEFT JOIN `messages_users` AS `MessagesUser` ON (`MessagesUser`.`message_id` = `Message`.`id`) WHERE `MessagesUser`.`user_id` = '' AND `MessagesUser`.`deleted` <> '1' AND `MessagesUser`.`read` <> '1' ORDER BY `Message`.`time_sent` DESC LIMIT 5 | 0 | 0 | 4 | |
| 117 | SELECT COUNT(*) AS `count` FROM `messages` AS `Message` LEFT JOIN `messages_users` AS `MessagesUser` ON (`MessagesUser`.`message_id` = `Message`.`id`) WHERE `MessagesUser`.`user_id` = '' AND `MessagesUser`.`deleted` <> '1' AND `MessagesUser`.`read` <> '1' | 1 | 1 | 1 | |
| 118 | SELECT DISTINCT `Document`.*, `User`.*, `User`.`id` FROM `documents` AS `Document` LEFT JOIN `users` AS `User` ON (`Document`.`user_id` = `User`.`id`) LEFT JOIN `groups_documents` AS `GroupsDocument` ON (`GroupsDocument`.`document_id` = `Document`.`id`) WHERE `GroupsDocument`.`group_id` IS NULL AND `Document`.`approved` = '1' ORDER BY `Document`.`upload_time` DESC LIMIT 8 | 6 | 6 | 27 | |
| 119 | SELECT `Poll`.`id`, `Poll`.`linkid`, `Poll`.`title`, `Poll`.`owner_id`, `Poll`.`created`, `Poll`.`deleted`, `Owner`.`id`, `Owner`.`title_id`, `Owner`.`prename`, `Owner`.`name`, `Owner`.`address`, `Owner`.`address2`, `Owner`.`postalcode`, `Owner`.`city`, `Owner`.`country_id`, `Owner`.`nationality_ciep`, `Owner`.`business_name`, `Owner`.`business_address`, `Owner`.`business_postalcode`, `Owner`.`interested_delfdalf`, `Owner`.`interested_evalling`, `Owner`.`interested_newsletter`, `Owner`.`tel_private`, `Owner`.`tel_work`, `Owner`.`tel_mobile`, `Owner`.`email`, `Owner`.`email2`, `Owner`.`forward_email`, `Owner`.`birthday`, `Owner`.`language_id`, `Owner`.`examcenter_id`, `Owner`.`username`, `Owner`.`passwd`, `Owner`.`password`, `Owner`.`comments`, `Owner`.`active`, `Owner`.`work_contract_signed`, `Owner`.`last_visit`, `Owner`.`deleted`, `Owner`.`ignore_accreditation`, `Owner`.`accreditation_mail_counter`, `Owner`.`accred_count_delf`, `Owner`.`accred_count_dalf`, `Owner`.`profile_pic`, `Owner`.`unique_code`, `Owner`.`locale`, `Owner`.`sms_service`, `Owner`.`two_fa_key`, `Owner`.`two_fa_status`, `Owner`.`random_string`, `PollsUser`.`id`, `PollsUser`.`poll_id`, `PollsUser`.`user_id`, `PollsUser`.`confirmed` FROM `polls` AS `Poll` LEFT JOIN `users` AS `Owner` ON (`Poll`.`owner_id` = `Owner`.`id`) LEFT JOIN `polls_users` AS `PollsUser` ON (`PollsUser`.`poll_id` = `Poll`.`id`) WHERE `PollsUser`.`user_id` = '' AND `Poll`.`deleted` <> 1 AND `PollsUser`.`confirmed` <> 1 ORDER BY `Poll`.`id` ASC | 0 | 0 | 1 | |
| 120 | SELECT * FROM `translations` WHERE 1 | 2573 | 2573 | 1 |