Symfony Profiler

SELECT
  u0_.id AS id_0,
  u0_.public_id AS public_id_1,
  u0_.email AS email_2,
  u0_.pseudo AS pseudo_3,
  u0_.licence AS licence_4,
  u0_.id_dupr AS id_dupr_5,
  u0_.genre AS genre_6,
  u0_.nom AS nom_7,
  u0_.prenom AS prenom_8,
  u0_.date_de_naissance AS date_de_naissance_9,
  u0_.ville AS ville_10,
  u0_.description AS description_11,
  u0_.telephone AS telephone_12,
  u0_.instagram AS instagram_13,
  u0_.linkedin AS linkedin_14,
  u0_.tiktok AS tiktok_15,
  u0_.twitter AS twitter_16,
  u0_.facebook AS facebook_17,
  u0_.statut AS statut_18,
  u0_.roles AS roles_19,
  u0_.password AS password_20,
  u0_.indicateur AS indicateur_21,
  u0_.createur AS createur_22,
  u0_.stripe_account_id AS stripe_account_id_23,
  u0_.stripe_onboarding_complete AS stripe_onboarding_complete_24,
  u0_.stripe_account_created_at AS stripe_account_created_at_25,
  u0_.stripe_account_type AS stripe_account_type_26,
  u0_.is_admin AS is_admin_27,
  u0_.commission_defaut AS commission_defaut_28,
  u0_.dupr_user_token AS dupr_user_token_29,
  u0_.dupr_refresh_token AS dupr_refresh_token_30,
  u0_.dupr_token_expires_at AS dupr_token_expires_at_31,
  u0_.dupr_sso_connected_at AS dupr_sso_connected_at_32,
  u0_.dupr_rating_singles AS dupr_rating_singles_33,
  u0_.dupr_rating_doubles AS dupr_rating_doubles_34,
  u0_.dupr_ratings_updated_at AS dupr_ratings_updated_at_35,
  u0_.dupr_basic_entitlement AS dupr_basic_entitlement_36,
  u0_.dupr_entitlement_checked_at AS dupr_entitlement_checked_at_37,
  u0_.newsletter_consent AS newsletter_consent_38,
  u0_.newsletter_consent_date AS newsletter_consent_date_39,
  u0_.traitement_limite AS traitement_limite_40,
  u0_.traitement_limite_date AS traitement_limite_date_41,
  u0_.traitement_limite_motif AS traitement_limite_motif_42,
  u0_.pays_id AS pays_id_43,
  u0_.niveau_simple_id AS niveau_simple_id_44,
  u0_.niveau_double_id AS niveau_double_id_45,
  u0_.niveau_mixte_id AS niveau_mixte_id_46
FROM
  `user` u0_
WHERE
  u0_.public_id = ?

SELECT u0_.id AS id_0, u0_.public_id AS public_id_1, u0_.email AS email_2, u0_.pseudo AS pseudo_3, u0_.licence AS licence_4, u0_.id_dupr AS id_dupr_5, u0_.genre AS genre_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_de_naissance AS date_de_naissance_9, u0_.ville AS ville_10, u0_.description AS description_11, u0_.telephone AS telephone_12, u0_.instagram AS instagram_13, u0_.linkedin AS linkedin_14, u0_.tiktok AS tiktok_15, u0_.twitter AS twitter_16, u0_.facebook AS facebook_17, u0_.statut AS statut_18, u0_.roles AS roles_19, u0_.password AS password_20, u0_.indicateur AS indicateur_21, u0_.createur AS createur_22, u0_.stripe_account_id AS stripe_account_id_23, u0_.stripe_onboarding_complete AS stripe_onboarding_complete_24, u0_.stripe_account_created_at AS stripe_account_created_at_25, u0_.stripe_account_type AS stripe_account_type_26, u0_.is_admin AS is_admin_27, u0_.commission_defaut AS commission_defaut_28, u0_.dupr_user_token AS dupr_user_token_29, u0_.dupr_refresh_token AS dupr_refresh_token_30, u0_.dupr_token_expires_at AS dupr_token_expires_at_31, u0_.dupr_sso_connected_at AS dupr_sso_connected_at_32, u0_.dupr_rating_singles AS dupr_rating_singles_33, u0_.dupr_rating_doubles AS dupr_rating_doubles_34, u0_.dupr_ratings_updated_at AS dupr_ratings_updated_at_35, u0_.dupr_basic_entitlement AS dupr_basic_entitlement_36, u0_.dupr_entitlement_checked_at AS dupr_entitlement_checked_at_37, u0_.newsletter_consent AS newsletter_consent_38, u0_.newsletter_consent_date AS newsletter_consent_date_39, u0_.traitement_limite AS traitement_limite_40, u0_.traitement_limite_date AS traitement_limite_date_41, u0_.traitement_limite_motif AS traitement_limite_motif_42, u0_.pays_id AS pays_id_43, u0_.niveau_simple_id AS niveau_simple_id_44, u0_.niveau_double_id AS niveau_double_id_45, u0_.niveau_mixte_id AS niveau_mixte_id_46 FROM `user` u0_ WHERE u0_.public_id = 'b2e54b8e-342d-11f1-ae32-fa163e19c1c5';

SELECT
  c0_.id AS id_0,
  c0_.serie AS serie_1,
  c0_.rang AS rang_2,
  c0_.nationalite AS nationalite_3,
  c0_.nom AS nom_4,
  c0_.prenom AS prenom_5,
  c0_.licence AS licence_6,
  c0_.ligue AS ligue_7,
  c0_.club AS club_8,
  c0_.nombre_tournois AS nombre_tournois_9,
  c0_.total_points AS total_points_10,
  c0_.equivalence_plus50 AS equivalence_plus50_11,
  c0_.equivalence_autres AS equivalence_autres_12,
  c0_.import_id AS import_id_13
FROM
  classement_fft_joueur c0_
  INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id
WHERE
  c0_.licence IN (?, ?, ?, ?)
ORDER BY
  c1_.date_import DESC,
  c0_.total_points DESC

SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE c0_.licence IN ('3828681J', '3828681 J', '3828681j', '3828681 j') ORDER BY c1_.date_import DESC, c0_.total_points DESC;

SELECT
  t0.id AS id_1,
  t0.categorie AS categorie_2,
  t0.date_import AS date_import_3,
  t0.nom_fichier AS nom_fichier_4,
  t0.chemin_fichier AS chemin_fichier_5,
  t0.nombre_joueurs AS nombre_joueurs_6,
  t0.erreurs AS erreurs_7
FROM
  classement_fft_import t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.categorie AS categorie_2, t0.date_import AS date_import_3, t0.nom_fichier AS nom_fichier_4, t0.chemin_fichier AS chemin_fichier_5, t0.nombre_joueurs AS nombre_joueurs_6, t0.erreurs AS erreurs_7 FROM classement_fft_import t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.categorie AS categorie_2,
  t0.date_import AS date_import_3,
  t0.nom_fichier AS nom_fichier_4,
  t0.chemin_fichier AS chemin_fichier_5,
  t0.nombre_joueurs AS nombre_joueurs_6,
  t0.erreurs AS erreurs_7
FROM
  classement_fft_import t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.categorie AS categorie_2, t0.date_import AS date_import_3, t0.nom_fichier AS nom_fichier_4, t0.chemin_fichier AS chemin_fichier_5, t0.nombre_joueurs AS nombre_joueurs_6, t0.erreurs AS erreurs_7 FROM classement_fft_import t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.categorie AS categorie_2,
  t0.date_import AS date_import_3,
  t0.nom_fichier AS nom_fichier_4,
  t0.chemin_fichier AS chemin_fichier_5,
  t0.nombre_joueurs AS nombre_joueurs_6,
  t0.erreurs AS erreurs_7
FROM
  classement_fft_import t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.categorie AS categorie_2, t0.date_import AS date_import_3, t0.nom_fichier AS nom_fichier_4, t0.chemin_fichier AS chemin_fichier_5, t0.nombre_joueurs AS nombre_joueurs_6, t0.erreurs AS erreurs_7 FROM classement_fft_import t0 WHERE t0.id = 1;

SELECT
  c0_.id AS id_0,
  c0_.serie AS serie_1,
  c0_.rang AS rang_2,
  c0_.nationalite AS nationalite_3,
  c0_.nom AS nom_4,
  c0_.prenom AS prenom_5,
  c0_.licence AS licence_6,
  c0_.ligue AS ligue_7,
  c0_.club AS club_8,
  c0_.nombre_tournois AS nombre_tournois_9,
  c0_.total_points AS total_points_10,
  c0_.equivalence_plus50 AS equivalence_plus50_11,
  c0_.equivalence_autres AS equivalence_autres_12,
  c0_.import_id AS import_id_13
FROM
  classement_fft_joueur c0_
  INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id
WHERE
  UPPER(
    TRIM(c0_.nom)
  ) = ?
  AND UPPER(
    TRIM(c0_.prenom)
  ) = ?
ORDER BY
  c1_.date_import DESC,
  c0_.total_points DESC

SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE UPPER(TRIM(c0_.nom)) = 'HAYET' AND UPPER(TRIM(c0_.prenom)) = 'CHRISTOPHER' ORDER BY c1_.date_import DESC, c0_.total_points DESC;

SELECT
  e0_.id AS id_0,
  e1_.id AS id_1,
  e1_.date_equipe AS date_equipe_2,
  e1_.nom AS nom_3,
  s2_.id AS id_4,
  s2_.nom AS nom_5,
  s2_.prix AS prix_6,
  s2_.metadata AS metadata_7,
  s2_.jour AS jour_8,
  e3_.id AS id_9,
  e3_.ordre_circuit AS ordre_circuit_10,
  e3_.is_master_final AS is_master_final_11,
  e3_.sur_invitation AS sur_invitation_12,
  e3_.points_assiduite AS points_assiduite_13,
  e3_.titre AS titre_14,
  e3_.description AS description_15,
  e3_.creation AS creation_16,
  e3_.termine AS termine_17,
  e3_.date_creation AS date_creation_18,
  e3_.encours AS encours_19,
  e3_.publier AS publier_20,
  e3_.inscriptions_ouvertes AS inscriptions_ouvertes_21,
  e3_.homologuer_fft AS homologuer_fft_22,
  e3_.demander_id_dupr AS demander_id_dupr_23,
  e3_.require_dupr_plus AS require_dupr_plus_24,
  e3_.require_dupr_verified AS require_dupr_verified_25,
  e3_.inscription_privee AS inscription_privee_26,
  e3_.code_pin_inscription AS code_pin_inscription_27,
  e3_.etat_actuel AS etat_actuel_28,
  e3_.commission_plateforme AS commission_plateforme_29,
  e0_.equipe_id AS equipe_id_30,
  e0_.user_id AS user_id_31,
  e0_.invitation_id AS invitation_id_32,
  e0_.evenement_id AS evenement_id_33,
  e0_.selection_id AS selection_id_34,
  e1_.selection_id AS selection_id_35,
  s2_.id_epreuve_id AS id_epreuve_id_36,
  s2_.id_age_id AS id_age_id_37,
  s2_.id_niveau_id AS id_niveau_id_38,
  s2_.id_forme_id AS id_forme_id_39,
  s2_.config_id AS config_id_40,
  s2_.evenement_id AS evenement_id_41,
  e3_.config_id AS config_id_42,
  e3_.organisateur_id AS organisateur_id_43,
  e3_.style_id AS style_id_44,
  e3_.circuit_id AS circuit_id_45
FROM
  equipe_user e0_
  INNER JOIN equipe e1_ ON e0_.equipe_id = e1_.id
  LEFT JOIN selection s2_ ON e1_.selection_id = s2_.id
  LEFT JOIN evenement e3_ ON s2_.evenement_id = e3_.id
WHERE
  e0_.user_id = ?

SELECT e0_.id AS id_0, e1_.id AS id_1, e1_.date_equipe AS date_equipe_2, e1_.nom AS nom_3, s2_.id AS id_4, s2_.nom AS nom_5, s2_.prix AS prix_6, s2_.metadata AS metadata_7, s2_.jour AS jour_8, e3_.id AS id_9, e3_.ordre_circuit AS ordre_circuit_10, e3_.is_master_final AS is_master_final_11, e3_.sur_invitation AS sur_invitation_12, e3_.points_assiduite AS points_assiduite_13, e3_.titre AS titre_14, e3_.description AS description_15, e3_.creation AS creation_16, e3_.termine AS termine_17, e3_.date_creation AS date_creation_18, e3_.encours AS encours_19, e3_.publier AS publier_20, e3_.inscriptions_ouvertes AS inscriptions_ouvertes_21, e3_.homologuer_fft AS homologuer_fft_22, e3_.demander_id_dupr AS demander_id_dupr_23, e3_.require_dupr_plus AS require_dupr_plus_24, e3_.require_dupr_verified AS require_dupr_verified_25, e3_.inscription_privee AS inscription_privee_26, e3_.code_pin_inscription AS code_pin_inscription_27, e3_.etat_actuel AS etat_actuel_28, e3_.commission_plateforme AS commission_plateforme_29, e0_.equipe_id AS equipe_id_30, e0_.user_id AS user_id_31, e0_.invitation_id AS invitation_id_32, e0_.evenement_id AS evenement_id_33, e0_.selection_id AS selection_id_34, e1_.selection_id AS selection_id_35, s2_.id_epreuve_id AS id_epreuve_id_36, s2_.id_age_id AS id_age_id_37, s2_.id_niveau_id AS id_niveau_id_38, s2_.id_forme_id AS id_forme_id_39, s2_.config_id AS config_id_40, s2_.evenement_id AS evenement_id_41, e3_.config_id AS config_id_42, e3_.organisateur_id AS organisateur_id_43, e3_.style_id AS style_id_44, e3_.circuit_id AS circuit_id_45 FROM equipe_user e0_ INNER JOIN equipe e1_ ON e0_.equipe_id = e1_.id LEFT JOIN selection s2_ ON e1_.selection_id = s2_.id LEFT JOIN evenement e3_ ON s2_.evenement_id = e3_.id WHERE e0_.user_id = 6109;

SELECT
  e0_.id AS id_0,
  u1_.id AS id_1,
  u1_.public_id AS public_id_2,
  u1_.email AS email_3,
  u1_.pseudo AS pseudo_4,
  u1_.licence AS licence_5,
  u1_.id_dupr AS id_dupr_6,
  u1_.genre AS genre_7,
  u1_.nom AS nom_8,
  u1_.prenom AS prenom_9,
  u1_.date_de_naissance AS date_de_naissance_10,
  u1_.ville AS ville_11,
  u1_.description AS description_12,
  u1_.telephone AS telephone_13,
  u1_.instagram AS instagram_14,
  u1_.linkedin AS linkedin_15,
  u1_.tiktok AS tiktok_16,
  u1_.twitter AS twitter_17,
  u1_.facebook AS facebook_18,
  u1_.statut AS statut_19,
  u1_.roles AS roles_20,
  u1_.password AS password_21,
  u1_.indicateur AS indicateur_22,
  u1_.createur AS createur_23,
  u1_.stripe_account_id AS stripe_account_id_24,
  u1_.stripe_onboarding_complete AS stripe_onboarding_complete_25,
  u1_.stripe_account_created_at AS stripe_account_created_at_26,
  u1_.stripe_account_type AS stripe_account_type_27,
  u1_.is_admin AS is_admin_28,
  u1_.commission_defaut AS commission_defaut_29,
  u1_.dupr_user_token AS dupr_user_token_30,
  u1_.dupr_refresh_token AS dupr_refresh_token_31,
  u1_.dupr_token_expires_at AS dupr_token_expires_at_32,
  u1_.dupr_sso_connected_at AS dupr_sso_connected_at_33,
  u1_.dupr_rating_singles AS dupr_rating_singles_34,
  u1_.dupr_rating_doubles AS dupr_rating_doubles_35,
  u1_.dupr_ratings_updated_at AS dupr_ratings_updated_at_36,
  u1_.dupr_basic_entitlement AS dupr_basic_entitlement_37,
  u1_.dupr_entitlement_checked_at AS dupr_entitlement_checked_at_38,
  u1_.newsletter_consent AS newsletter_consent_39,
  u1_.newsletter_consent_date AS newsletter_consent_date_40,
  u1_.traitement_limite AS traitement_limite_41,
  u1_.traitement_limite_date AS traitement_limite_date_42,
  u1_.traitement_limite_motif AS traitement_limite_motif_43,
  e0_.equipe_id AS equipe_id_44,
  e0_.user_id AS user_id_45,
  e0_.invitation_id AS invitation_id_46,
  e0_.evenement_id AS evenement_id_47,
  e0_.selection_id AS selection_id_48,
  u1_.pays_id AS pays_id_49,
  u1_.niveau_simple_id AS niveau_simple_id_50,
  u1_.niveau_double_id AS niveau_double_id_51,
  u1_.niveau_mixte_id AS niveau_mixte_id_52
FROM
  equipe_user e0_
  INNER JOIN `user` u1_ ON e0_.user_id = u1_.id
WHERE
  e0_.equipe_id IN (?, ?, ?)

SELECT e0_.id AS id_0, u1_.id AS id_1, u1_.public_id AS public_id_2, u1_.email AS email_3, u1_.pseudo AS pseudo_4, u1_.licence AS licence_5, u1_.id_dupr AS id_dupr_6, u1_.genre AS genre_7, u1_.nom AS nom_8, u1_.prenom AS prenom_9, u1_.date_de_naissance AS date_de_naissance_10, u1_.ville AS ville_11, u1_.description AS description_12, u1_.telephone AS telephone_13, u1_.instagram AS instagram_14, u1_.linkedin AS linkedin_15, u1_.tiktok AS tiktok_16, u1_.twitter AS twitter_17, u1_.facebook AS facebook_18, u1_.statut AS statut_19, u1_.roles AS roles_20, u1_.password AS password_21, u1_.indicateur AS indicateur_22, u1_.createur AS createur_23, u1_.stripe_account_id AS stripe_account_id_24, u1_.stripe_onboarding_complete AS stripe_onboarding_complete_25, u1_.stripe_account_created_at AS stripe_account_created_at_26, u1_.stripe_account_type AS stripe_account_type_27, u1_.is_admin AS is_admin_28, u1_.commission_defaut AS commission_defaut_29, u1_.dupr_user_token AS dupr_user_token_30, u1_.dupr_refresh_token AS dupr_refresh_token_31, u1_.dupr_token_expires_at AS dupr_token_expires_at_32, u1_.dupr_sso_connected_at AS dupr_sso_connected_at_33, u1_.dupr_rating_singles AS dupr_rating_singles_34, u1_.dupr_rating_doubles AS dupr_rating_doubles_35, u1_.dupr_ratings_updated_at AS dupr_ratings_updated_at_36, u1_.dupr_basic_entitlement AS dupr_basic_entitlement_37, u1_.dupr_entitlement_checked_at AS dupr_entitlement_checked_at_38, u1_.newsletter_consent AS newsletter_consent_39, u1_.newsletter_consent_date AS newsletter_consent_date_40, u1_.traitement_limite AS traitement_limite_41, u1_.traitement_limite_date AS traitement_limite_date_42, u1_.traitement_limite_motif AS traitement_limite_motif_43, e0_.equipe_id AS equipe_id_44, e0_.user_id AS user_id_45, e0_.invitation_id AS invitation_id_46, e0_.evenement_id AS evenement_id_47, e0_.selection_id AS selection_id_48, u1_.pays_id AS pays_id_49, u1_.niveau_simple_id AS niveau_simple_id_50, u1_.niveau_double_id AS niveau_double_id_51, u1_.niveau_mixte_id AS niveau_mixte_id_52 FROM equipe_user e0_ INNER JOIN `user` u1_ ON e0_.user_id = u1_.id WHERE e0_.equipe_id IN (243, 346, 379);

SELECT
  g0_.id AS id_0,
  g0_.heure_debut AS heure_debut_1,
  g0_.heure_fin AS heure_fin_2,
  g0_.ordre AS ordre_3,
  g0_.position_terrain AS position_terrain_4,
  g0_.modifie_manuellement AS modifie_manuellement_5,
  g0_.date_modification AS date_modification_6,
  g0_.score AS score_7,
  g0_.commentaire AS commentaire_8,
  g0_.poule_id AS poule_id_9,
  g0_.terrain_id AS terrain_id_10,
  g0_.equipe1_id AS equipe1_id_11,
  g0_.equipe2_id AS equipe2_id_12,
  g0_.etat_id AS etat_id_13,
  g0_.evenement_id AS evenement_id_14,
  g0_.selection_id AS selection_id_15
FROM
  game_match g0_
WHERE
  (
    g0_.equipe1_id IN (?, ?, ?)
    OR g0_.equipe2_id IN (?, ?, ?)
  )
  AND g0_.score IS NOT NULL
  AND g0_.score <> ''
ORDER BY
  g0_.heure_debut ASC

SELECT g0_.id AS id_0, g0_.heure_debut AS heure_debut_1, g0_.heure_fin AS heure_fin_2, g0_.ordre AS ordre_3, g0_.position_terrain AS position_terrain_4, g0_.modifie_manuellement AS modifie_manuellement_5, g0_.date_modification AS date_modification_6, g0_.score AS score_7, g0_.commentaire AS commentaire_8, g0_.poule_id AS poule_id_9, g0_.terrain_id AS terrain_id_10, g0_.equipe1_id AS equipe1_id_11, g0_.equipe2_id AS equipe2_id_12, g0_.etat_id AS etat_id_13, g0_.evenement_id AS evenement_id_14, g0_.selection_id AS selection_id_15 FROM game_match g0_ WHERE (g0_.equipe1_id IN (243, 346, 379) OR g0_.equipe2_id IN (243, 346, 379)) AND g0_.score IS NOT NULL AND g0_.score <> '' ORDER BY g0_.heure_debut ASC;

SELECT
  m0_.id AS id_0,
  m0_.heure_debut AS heure_debut_1,
  m0_.heure_fin AS heure_fin_2,
  m0_.ordre AS ordre_3,
  m0_.score AS score_4,
  m0_.date_modification AS date_modification_5,
  m0_.commentaire AS commentaire_6,
  m0_.termine AS termine_7,
  m0_.match_precedent1 AS match_precedent1_8,
  m0_.match_precedent2 AS match_precedent2_9,
  m0_.position_match_precedent1 AS position_match_precedent1_10,
  m0_.position_match_precedent2 AS position_match_precedent2_11,
  m0_.round_name AS round_name_12,
  m0_.round_number AS round_number_13,
  m0_.bracket_type AS bracket_type_14,
  m0_.playoff_id AS playoff_id_15,
  m0_.equipe1_id AS equipe1_id_16,
  m0_.equipe2_id AS equipe2_id_17,
  m0_.terrain_id AS terrain_id_18
FROM
  match_eliminatoire m0_
WHERE
  (
    m0_.equipe1_id IN (?, ?, ?)
    OR m0_.equipe2_id IN (?, ?, ?)
  )
  AND m0_.score IS NOT NULL
  AND m0_.score <> ''
ORDER BY
  m0_.heure_debut ASC

SELECT m0_.id AS id_0, m0_.heure_debut AS heure_debut_1, m0_.heure_fin AS heure_fin_2, m0_.ordre AS ordre_3, m0_.score AS score_4, m0_.date_modification AS date_modification_5, m0_.commentaire AS commentaire_6, m0_.termine AS termine_7, m0_.match_precedent1 AS match_precedent1_8, m0_.match_precedent2 AS match_precedent2_9, m0_.position_match_precedent1 AS position_match_precedent1_10, m0_.position_match_precedent2 AS position_match_precedent2_11, m0_.round_name AS round_name_12, m0_.round_number AS round_number_13, m0_.bracket_type AS bracket_type_14, m0_.playoff_id AS playoff_id_15, m0_.equipe1_id AS equipe1_id_16, m0_.equipe2_id AS equipe2_id_17, m0_.terrain_id AS terrain_id_18 FROM match_eliminatoire m0_ WHERE (m0_.equipe1_id IN (243, 346, 379) OR m0_.equipe2_id IN (243, 346, 379)) AND m0_.score IS NOT NULL AND m0_.score <> '' ORDER BY m0_.heure_debut ASC;

SELECT
  t0.id AS id_1,
  t0.numero AS numero_2,
  t0.score_equipe1 AS score_equipe1_3,
  t0.score_equipe2 AS score_equipe2_4,
  t0.match_eliminatoire_id AS match_eliminatoire_id_5
FROM
  set_eliminatoire t0
WHERE
  t0.match_eliminatoire_id = ?
ORDER BY
  t0.numero ASC

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.score_equipe1 AS score_equipe1_3, t0.score_equipe2 AS score_equipe2_4, t0.match_eliminatoire_id AS match_eliminatoire_id_5 FROM set_eliminatoire t0 WHERE t0.match_eliminatoire_id = 373 ORDER BY t0.numero ASC;

SELECT
  t0.id AS id_1,
  t0.numero AS numero_2,
  t0.score_equipe1 AS score_equipe1_3,
  t0.score_equipe2 AS score_equipe2_4,
  t0.match_eliminatoire_id AS match_eliminatoire_id_5
FROM
  set_eliminatoire t0
WHERE
  t0.match_eliminatoire_id = ?
ORDER BY
  t0.numero ASC

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.score_equipe1 AS score_equipe1_3, t0.score_equipe2 AS score_equipe2_4, t0.match_eliminatoire_id AS match_eliminatoire_id_5 FROM set_eliminatoire t0 WHERE t0.match_eliminatoire_id = 380 ORDER BY t0.numero ASC;

SELECT
  t0.id AS id_1,
  t0.numero AS numero_2,
  t0.score_equipe1 AS score_equipe1_3,
  t0.score_equipe2 AS score_equipe2_4,
  t0.match_eliminatoire_id AS match_eliminatoire_id_5
FROM
  set_eliminatoire t0
WHERE
  t0.match_eliminatoire_id = ?
ORDER BY
  t0.numero ASC

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.score_equipe1 AS score_equipe1_3, t0.score_equipe2 AS score_equipe2_4, t0.match_eliminatoire_id AS match_eliminatoire_id_5 FROM set_eliminatoire t0 WHERE t0.match_eliminatoire_id = 387 ORDER BY t0.numero ASC;

SELECT
  t0.id AS id_1,
  t0.numero AS numero_2,
  t0.score_equipe1 AS score_equipe1_3,
  t0.score_equipe2 AS score_equipe2_4,
  t0.match_eliminatoire_id AS match_eliminatoire_id_5
FROM
  set_eliminatoire t0
WHERE
  t0.match_eliminatoire_id = ?
ORDER BY
  t0.numero ASC

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.score_equipe1 AS score_equipe1_3, t0.score_equipe2 AS score_equipe2_4, t0.match_eliminatoire_id AS match_eliminatoire_id_5 FROM set_eliminatoire t0 WHERE t0.match_eliminatoire_id = 389 ORDER BY t0.numero ASC;

SELECT
  t0.id AS id_1,
  t0.numero AS numero_2,
  t0.score_equipe1 AS score_equipe1_3,
  t0.score_equipe2 AS score_equipe2_4,
  t0.match_eliminatoire_id AS match_eliminatoire_id_5
FROM
  set_eliminatoire t0
WHERE
  t0.match_eliminatoire_id = ?
ORDER BY
  t0.numero ASC

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.score_equipe1 AS score_equipe1_3, t0.score_equipe2 AS score_equipe2_4, t0.match_eliminatoire_id AS match_eliminatoire_id_5 FROM set_eliminatoire t0 WHERE t0.match_eliminatoire_id = 412 ORDER BY t0.numero ASC;

SELECT
  t0.id AS id_1,
  t0.numero AS numero_2,
  t0.score_equipe1 AS score_equipe1_3,
  t0.score_equipe2 AS score_equipe2_4,
  t0.match_eliminatoire_id AS match_eliminatoire_id_5
FROM
  set_eliminatoire t0
WHERE
  t0.match_eliminatoire_id = ?
ORDER BY
  t0.numero ASC

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.score_equipe1 AS score_equipe1_3, t0.score_equipe2 AS score_equipe2_4, t0.match_eliminatoire_id AS match_eliminatoire_id_5 FROM set_eliminatoire t0 WHERE t0.match_eliminatoire_id = 419 ORDER BY t0.numero ASC;