Planifications d'examens
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | 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 | 9 | |
| 2 | SELECT `Group`.`id`, `Group`.`name`, `Group`.`level`, `Group`.`redirect`, `Group`.`perm_type`, `GroupsInfo`.`id`, `GroupsInfo`.`group_id`, `GroupsInfo`.`info_id` FROM `groups` AS `Group` JOIN `groups_infos` AS `GroupsInfo` ON (`GroupsInfo`.`info_id` IN (288, 236, 287, 286, 285) AND `GroupsInfo`.`group_id` = `Group`.`id`) | 78 | 78 | 3 | |
| 3 | 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`, `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`.`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 | 2 | |
| 4 | 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`, `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`, `MessagesUser`.`id`, `MessagesUser`.`message_id`, `MessagesUser`.`user_id`, `MessagesUser`.`read`, `MessagesUser`.`deleted` 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 | 1 | |
| 5 | 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 | 0 | |
| 6 | 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 | 1 | 1 | 11 | |
| 7 | 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`, `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 | |
| 8 | SELECT * FROM `translations` WHERE 1 | 2567 | 2567 | 20 |