| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Config`.`nom`, `Config`.`valeur` FROM `demo`.`configs` AS `Config` WHERE `nom` IN ('taille_min', 'taille_max', 'date_course') | 3 | 3 | 11 | maybe slow |
| SELECT `Config`.`nom`, `Config`.`valeur` FROM `demo`.`configs` AS `Config` WHERE 1 = 1 | 144 | 144 | 11 | maybe slow |
| SELECT `Input`.`id`, `Input`.`input` FROM `demo`.`inputs` AS `Input` WHERE `nb` = 1 AND `step` = 1 AND `active` = '1' ORDER BY `ordre` ASC | 16 | 16 | 11 | maybe slow |
| SELECT `Parcours`.`id`, `Parcours`.`nom` FROM `demo`.`parcours` AS `Parcours` WHERE `statut` = '1' AND `slug` = 'Les-copains-CYFAC' | 1 | 1 | 11 | maybe slow |
| 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`, `Parcours`.`texte_etape_1` FROM `demo`.`parcours` AS `Parcours` WHERE `slug` = 'Les-copains-CYFAC' LIMIT 1 | 1 | 1 | 11 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `demo`.`participants` AS `Participant` LEFT JOIN `demo`.`federations` AS `Federation` ON (`Participant`.`federation_id` = `Federation`.`id`) LEFT JOIN `demo`.`parcours` AS `Parcours` ON (`Participant`.`parcours_id` = `Parcours`.`id`) LEFT JOIN `demo`.`pays` AS `Pays` ON (`Participant`.`pays_id` = `Pays`.`id`) LEFT JOIN `demo`.`departements` AS `Departement` ON (`Participant`.`departement_id` = `Departement`.`id`) LEFT JOIN `demo`.`equipes` AS `Equipe` ON (`Participant`.`equipe_id` = `Equipe`.`id`) LEFT JOIN `demo`.`choixes` AS `Choix` ON (`Participant`.`choix_id` = `Choix`.`id`) WHERE 1 = 1 | 1 | 1 | 14 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `demo`.`participants` AS `Participant` LEFT JOIN `demo`.`federations` AS `Federation` ON (`Participant`.`federation_id` = `Federation`.`id`) LEFT JOIN `demo`.`parcours` AS `Parcours` ON (`Participant`.`parcours_id` = `Parcours`.`id`) LEFT JOIN `demo`.`pays` AS `Pays` ON (`Participant`.`pays_id` = `Pays`.`id`) LEFT JOIN `demo`.`departements` AS `Departement` ON (`Participant`.`departement_id` = `Departement`.`id`) LEFT JOIN `demo`.`equipes` AS `Equipe` ON (`Participant`.`equipe_id` = `Equipe`.`id`) LEFT JOIN `demo`.`choixes` AS `Choix` ON (`Participant`.`choix_id` = `Choix`.`id`) WHERE `paiement` = '1' AND `Parcours`.`id` = 1 | 1 | 1 | 11 | maybe slow |
| SELECT `Departement`.`id`, (CONCAT(`Departement`.`num`, ' - ', `Departement`.`nom`)) AS `Departement__numnom` FROM `demo`.`departements` AS `Departement` WHERE 1 = 1 | 102 | 102 | 11 | maybe slow |
| SELECT `Pays`.`id`, `Pays`.`nom` FROM `demo`.`pays` AS `Pays` WHERE 1 = 1 ORDER BY (`nom` = "France") DESC, `nom` ASC | 239 | 239 | 12 | maybe slow |
| SELECT `Pays`.`indicatif`, (CONCAT(`Pays`.`indicatif`, ' (', `Pays`.`nom`, ')')) AS `Pays__indicatif_titre` FROM `demo`.`pays` AS `Pays` WHERE `indicatif` <> '' ORDER BY (`nom` = "France") DESC, `nom` ASC | 143 | 143 | 11 | maybe slow |
| SELECT `Federation`.`id`, `Federation`.`nom` FROM `demo`.`federations` AS `Federation` WHERE ((`Federation`.`parcours_id` = 0) OR (`Federation`.`parcours_id` = 1)) ORDER BY `Federation`.`ordre` ASC, `Federation`.`id` ASC | 2 | 2 | 11 | maybe slow |
| SELECT `Choix`.`id`, `Choix`.`titre` FROM `demo`.`choixes` AS `Choix` WHERE `Choix`.`parcours_id` = 1 AND `Choix`.`statut` = 1 AND quota > paiements ORDER BY `Choix`.`ordre` ASC | 1 | 1 | 11 | maybe slow |
| SELECT `Config`.`nom`, `Config`.`valeur` FROM `demo`.`configs` AS `Config` WHERE 1 = 1 | 144 | 144 | 11 | maybe slow |
