| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Config`.`nom`, `Config`.`valeur` FROM `slot4`.`configs` AS `Config` WHERE `nom` IN ('taille_min', 'taille_max', 'date_course') | 3 | 3 | 2 | maybe slow |
| SELECT `Config`.`nom`, `Config`.`valeur` FROM `slot4`.`configs` AS `Config` WHERE 1 = 1 | 135 | 135 | 1 | |
| SELECT `Input`.`id`, `Input`.`input` FROM `slot4`.`inputs` AS `Input` WHERE `nb` = 2 AND `step` = 1 AND `active` = '1' ORDER BY `ordre` ASC | 17 | 17 | 2 | maybe slow |
| SELECT `Parcours`.`id`, `Parcours`.`nom` FROM `slot4`.`parcours` AS `Parcours` WHERE `statut` = '1' AND `tarif_2` > 0 AND `slug` = 'GUADELOUPE-EXPERIENCE-Fin-novembre-2022' | 1 | 1 | 1 | |
| SELECT `Parcours`.`id`, `Parcours`.`nom`, `Parcours`.`tarif_normal`, `Parcours`.`type`, `Parcours`.`options`, `Parcours`.`questions`, `Parcours`.`assurance`, `Parcours`.`certificat`, `Parcours`.`slug`, `Parcours`.`agemin`, `Parcours`.`agemax`, `Parcours`.`demande_taille_haut`, `Parcours`.`repas`, `Parcours`.`handisport`, `Parcours`.`texte_requis_1`, `Parcours`.`texte_requis_2`, `Parcours`.`quota` FROM `slot4`.`parcours` AS `Parcours` WHERE `slug` = 'GUADELOUPE-EXPERIENCE-Fin-novembre-2022' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Federation`.`id`, `Federation`.`nom` FROM `slot4`.`federations` AS `Federation` WHERE `type` = 'cyclisme' ORDER BY `ordre` ASC, `id` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `Departement`.`id`, (CONCAT(`Departement`.`num`, ' - ', `Departement`.`nom`)) AS `Departement__numnom` FROM `slot4`.`departements` AS `Departement` WHERE 1 = 1 | 102 | 102 | 2 | |
| SELECT `Pays`.`id`, `Pays`.`nom` FROM `slot4`.`pays` AS `Pays` WHERE 1 = 1 | 239 | 239 | 2 | |
| SELECT `Pays`.`indicatif`, (CONCAT(`Pays`.`indicatif`, ' (', `Pays`.`nom`, ')')) AS `Pays__indicatif_titre` FROM `slot4`.`pays` AS `Pays` WHERE `indicatif` <> '' ORDER BY (`nom` = "France") DESC, `nom` ASC | 143 | 143 | 1 | |
| SELECT `Option`.`id`, (CONCAT(`Option`.`nom`, ' (', `Option`.`tarif`, '€)')) AS `Option__label` FROM `slot4`.`options` AS `Option` WHERE `liste` = 1 AND `statut` = '1' ORDER BY `ordre` ASC | 5 | 5 | 2 | maybe slow |
| SELECT `Option`.`id`, `Option`.`description` FROM `slot4`.`options` AS `Option` WHERE `liste` = 1 AND `statut` = '1' ORDER BY `ordre` ASC | 5 | 5 | 1 | maybe slow |
| SELECT `Question`.`id`, `Question`.`titre`, `Question`.`type`, `Question`.`choix`, `Question`.`ordre`, `Question`.`liste`, `Question`.`statut`, `Question`.`description` FROM `slot4`.`questions` AS `Question` WHERE `liste` = 1 ORDER BY `ordre` ASC | 5 | 5 | 2 | maybe slow |
| SELECT `QuestionParticipant`.`id`, `QuestionParticipant`.`question_id`, `QuestionParticipant`.`participant_id`, `QuestionParticipant`.`valeur` FROM `slot4`.`question_participants` AS `QuestionParticipant` WHERE `QuestionParticipant`.`question_id` IN (20, 21, 22, 23, 24) | 5 | 5 | 2 | maybe slow |
| SELECT `Choix`.`id`, `Choix`.`titre` FROM `slot4`.`choixes` AS `Choix` WHERE `Choix`.`parcours_id` = 42 AND `Choix`.`statut` = 1 AND quota > paiements ORDER BY `Choix`.`ordre` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `Config`.`nom`, `Config`.`valeur` FROM `slot4`.`configs` AS `Config` WHERE 1 = 1 | 135 | 135 | 1 | |
| SELECT `OptionVersion`.`id`, `OptionVersion`.`nom` FROM `slot4`.`option_versions` AS `OptionVersion` WHERE `option_id` = 62 AND paiements < quota AND `statut` = 1 ORDER BY `ordre` ASC, `nom` ASC | 0 | 0 | 4 | maybe slow |
| SELECT `OptionVersion`.`id`, `OptionVersion`.`nom` FROM `slot4`.`option_versions` AS `OptionVersion` WHERE `option_id` = 63 AND paiements < quota AND `statut` = 1 ORDER BY `ordre` ASC, `nom` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `OptionVersion`.`id`, `OptionVersion`.`nom` FROM `slot4`.`option_versions` AS `OptionVersion` WHERE `option_id` = 64 AND paiements < quota AND `statut` = 1 ORDER BY `ordre` ASC, `nom` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `OptionVersion`.`id`, `OptionVersion`.`nom` FROM `slot4`.`option_versions` AS `OptionVersion` WHERE `option_id` = 65 AND paiements < quota AND `statut` = 1 ORDER BY `ordre` ASC, `nom` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `OptionVersion`.`id`, `OptionVersion`.`nom` FROM `slot4`.`option_versions` AS `OptionVersion` WHERE `option_id` = 66 AND paiements < quota AND `statut` = 1 ORDER BY `ordre` ASC, `nom` ASC | 0 | 0 | 1 | maybe slow |
