GET https://demofft.tournoipickleball.fr/tournois

Query Metrics

53 Database Queries
12 Different statements
36.38 ms Query time
0 Invalid entities
37 Managed entities

Queries

Group similar statements

# Time Info
1 1.29 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM age t0
Parameters:
[]
2 1.98 ms
SELECT DISTINCT e0_.id AS id_0, e0_.ordre_circuit AS ordre_circuit_1, e0_.is_master_final AS is_master_final_2, e0_.sur_invitation AS sur_invitation_3, e0_.points_assiduite AS points_assiduite_4, e0_.titre AS titre_5, e0_.description AS description_6, e0_.creation AS creation_7, e0_.termine AS termine_8, e0_.date_creation AS date_creation_9, e0_.encours AS encours_10, e0_.publier AS publier_11, e0_.inscriptions_ouvertes AS inscriptions_ouvertes_12, e0_.homologuer_fft AS homologuer_fft_13, e0_.demander_id_dupr AS demander_id_dupr_14, e0_.require_dupr_plus AS require_dupr_plus_15, e0_.require_dupr_verified AS require_dupr_verified_16, e0_.inscription_privee AS inscription_privee_17, e0_.code_pin_inscription AS code_pin_inscription_18, e0_.etat_actuel AS etat_actuel_19, e0_.commission_plateforme AS commission_plateforme_20, e0_.config_id AS config_id_21, e0_.organisateur_id AS organisateur_id_22, e0_.style_id AS style_id_23, e0_.circuit_id AS circuit_id_24 FROM evenement e0_ INNER JOIN config c1_ ON e0_.config_id = c1_.id INNER JOIN style s2_ ON e0_.style_id = s2_.id LEFT JOIN selection s3_ ON c1_.id = s3_.config_id WHERE e0_.publier = ? AND s2_.nom <> ?
Parameters:
[
  1
  "Circuit"
]
3 0.75 ms
SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.fin_inscription AS fin_inscription_3, t0.nb_joueur AS nb_joueur_4, t0.date_fin AS date_fin_5, t0.adresse AS adresse_6, t0.complement AS complement_7, t0.cp AS cp_8, t0.ville AS ville_9, t0.pays AS pays_10, t0.map AS map_11, t0.nb_joueur_max AS nb_joueur_max_12, t0.nb_equipe_max AS nb_equipe_max_13, t0.terrain_interieur AS terrain_interieur_14, t0.terrain_exterieur AS terrain_exterieur_15, t0.type_balle AS type_balle_16, t0.nb_joueur_par_equipe AS nb_joueur_par_equipe_17, t0.montant_repas AS montant_repas_18, t0.devise AS devise_19, t0.nb_journee_previsionnel AS nb_journee_previsionnel_20, t0.prizepool AS prizepool_21, t0.nb_match_par_rencontre AS nb_match_par_rencontre_22, t0.datas_victoire AS datas_victoire_23, t0.points_victoire AS points_victoire_24, t0.points_defaite AS points_defaite_25, t0.points_nul AS points_nul_26, t0.categorie AS categorie_27, t28.id AS id_29, t28.ordre_circuit AS ordre_circuit_30, t28.is_master_final AS is_master_final_31, t28.sur_invitation AS sur_invitation_32, t28.points_assiduite AS points_assiduite_33, t28.titre AS titre_34, t28.description AS description_35, t28.creation AS creation_36, t28.termine AS termine_37, t28.date_creation AS date_creation_38, t28.encours AS encours_39, t28.publier AS publier_40, t28.inscriptions_ouvertes AS inscriptions_ouvertes_41, t28.homologuer_fft AS homologuer_fft_42, t28.demander_id_dupr AS demander_id_dupr_43, t28.require_dupr_plus AS require_dupr_plus_44, t28.require_dupr_verified AS require_dupr_verified_45, t28.inscription_privee AS inscription_privee_46, t28.code_pin_inscription AS code_pin_inscription_47, t28.etat_actuel AS etat_actuel_48, t28.commission_plateforme AS commission_plateforme_49, t28.config_id AS config_id_50, t28.organisateur_id AS organisateur_id_51, t28.style_id AS style_id_52, t28.circuit_id AS circuit_id_53 FROM config t0 LEFT JOIN evenement t28 ON t28.config_id = t0.id WHERE t0.id = ?
Parameters:
[
  3
]
4 0.53 ms
SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.fin_inscription AS fin_inscription_3, t0.nb_joueur AS nb_joueur_4, t0.date_fin AS date_fin_5, t0.adresse AS adresse_6, t0.complement AS complement_7, t0.cp AS cp_8, t0.ville AS ville_9, t0.pays AS pays_10, t0.map AS map_11, t0.nb_joueur_max AS nb_joueur_max_12, t0.nb_equipe_max AS nb_equipe_max_13, t0.terrain_interieur AS terrain_interieur_14, t0.terrain_exterieur AS terrain_exterieur_15, t0.type_balle AS type_balle_16, t0.nb_joueur_par_equipe AS nb_joueur_par_equipe_17, t0.montant_repas AS montant_repas_18, t0.devise AS devise_19, t0.nb_journee_previsionnel AS nb_journee_previsionnel_20, t0.prizepool AS prizepool_21, t0.nb_match_par_rencontre AS nb_match_par_rencontre_22, t0.datas_victoire AS datas_victoire_23, t0.points_victoire AS points_victoire_24, t0.points_defaite AS points_defaite_25, t0.points_nul AS points_nul_26, t0.categorie AS categorie_27, t28.id AS id_29, t28.ordre_circuit AS ordre_circuit_30, t28.is_master_final AS is_master_final_31, t28.sur_invitation AS sur_invitation_32, t28.points_assiduite AS points_assiduite_33, t28.titre AS titre_34, t28.description AS description_35, t28.creation AS creation_36, t28.termine AS termine_37, t28.date_creation AS date_creation_38, t28.encours AS encours_39, t28.publier AS publier_40, t28.inscriptions_ouvertes AS inscriptions_ouvertes_41, t28.homologuer_fft AS homologuer_fft_42, t28.demander_id_dupr AS demander_id_dupr_43, t28.require_dupr_plus AS require_dupr_plus_44, t28.require_dupr_verified AS require_dupr_verified_45, t28.inscription_privee AS inscription_privee_46, t28.code_pin_inscription AS code_pin_inscription_47, t28.etat_actuel AS etat_actuel_48, t28.commission_plateforme AS commission_plateforme_49, t28.config_id AS config_id_50, t28.organisateur_id AS organisateur_id_51, t28.style_id AS style_id_52, t28.circuit_id AS circuit_id_53 FROM config t0 LEFT JOIN evenement t28 ON t28.config_id = t0.id WHERE t0.id = ?
Parameters:
[
  11
]
5 0.47 ms
SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.fin_inscription AS fin_inscription_3, t0.nb_joueur AS nb_joueur_4, t0.date_fin AS date_fin_5, t0.adresse AS adresse_6, t0.complement AS complement_7, t0.cp AS cp_8, t0.ville AS ville_9, t0.pays AS pays_10, t0.map AS map_11, t0.nb_joueur_max AS nb_joueur_max_12, t0.nb_equipe_max AS nb_equipe_max_13, t0.terrain_interieur AS terrain_interieur_14, t0.terrain_exterieur AS terrain_exterieur_15, t0.type_balle AS type_balle_16, t0.nb_joueur_par_equipe AS nb_joueur_par_equipe_17, t0.montant_repas AS montant_repas_18, t0.devise AS devise_19, t0.nb_journee_previsionnel AS nb_journee_previsionnel_20, t0.prizepool AS prizepool_21, t0.nb_match_par_rencontre AS nb_match_par_rencontre_22, t0.datas_victoire AS datas_victoire_23, t0.points_victoire AS points_victoire_24, t0.points_defaite AS points_defaite_25, t0.points_nul AS points_nul_26, t0.categorie AS categorie_27, t28.id AS id_29, t28.ordre_circuit AS ordre_circuit_30, t28.is_master_final AS is_master_final_31, t28.sur_invitation AS sur_invitation_32, t28.points_assiduite AS points_assiduite_33, t28.titre AS titre_34, t28.description AS description_35, t28.creation AS creation_36, t28.termine AS termine_37, t28.date_creation AS date_creation_38, t28.encours AS encours_39, t28.publier AS publier_40, t28.inscriptions_ouvertes AS inscriptions_ouvertes_41, t28.homologuer_fft AS homologuer_fft_42, t28.demander_id_dupr AS demander_id_dupr_43, t28.require_dupr_plus AS require_dupr_plus_44, t28.require_dupr_verified AS require_dupr_verified_45, t28.inscription_privee AS inscription_privee_46, t28.code_pin_inscription AS code_pin_inscription_47, t28.etat_actuel AS etat_actuel_48, t28.commission_plateforme AS commission_plateforme_49, t28.config_id AS config_id_50, t28.organisateur_id AS organisateur_id_51, t28.style_id AS style_id_52, t28.circuit_id AS circuit_id_53 FROM config t0 LEFT JOIN evenement t28 ON t28.config_id = t0.id WHERE t0.id = ?
Parameters:
[
  12
]
6 0.46 ms
SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.fin_inscription AS fin_inscription_3, t0.nb_joueur AS nb_joueur_4, t0.date_fin AS date_fin_5, t0.adresse AS adresse_6, t0.complement AS complement_7, t0.cp AS cp_8, t0.ville AS ville_9, t0.pays AS pays_10, t0.map AS map_11, t0.nb_joueur_max AS nb_joueur_max_12, t0.nb_equipe_max AS nb_equipe_max_13, t0.terrain_interieur AS terrain_interieur_14, t0.terrain_exterieur AS terrain_exterieur_15, t0.type_balle AS type_balle_16, t0.nb_joueur_par_equipe AS nb_joueur_par_equipe_17, t0.montant_repas AS montant_repas_18, t0.devise AS devise_19, t0.nb_journee_previsionnel AS nb_journee_previsionnel_20, t0.prizepool AS prizepool_21, t0.nb_match_par_rencontre AS nb_match_par_rencontre_22, t0.datas_victoire AS datas_victoire_23, t0.points_victoire AS points_victoire_24, t0.points_defaite AS points_defaite_25, t0.points_nul AS points_nul_26, t0.categorie AS categorie_27, t28.id AS id_29, t28.ordre_circuit AS ordre_circuit_30, t28.is_master_final AS is_master_final_31, t28.sur_invitation AS sur_invitation_32, t28.points_assiduite AS points_assiduite_33, t28.titre AS titre_34, t28.description AS description_35, t28.creation AS creation_36, t28.termine AS termine_37, t28.date_creation AS date_creation_38, t28.encours AS encours_39, t28.publier AS publier_40, t28.inscriptions_ouvertes AS inscriptions_ouvertes_41, t28.homologuer_fft AS homologuer_fft_42, t28.demander_id_dupr AS demander_id_dupr_43, t28.require_dupr_plus AS require_dupr_plus_44, t28.require_dupr_verified AS require_dupr_verified_45, t28.inscription_privee AS inscription_privee_46, t28.code_pin_inscription AS code_pin_inscription_47, t28.etat_actuel AS etat_actuel_48, t28.commission_plateforme AS commission_plateforme_49, t28.config_id AS config_id_50, t28.organisateur_id AS organisateur_id_51, t28.style_id AS style_id_52, t28.circuit_id AS circuit_id_53 FROM config t0 LEFT JOIN evenement t28 ON t28.config_id = t0.id WHERE t0.id = ?
Parameters:
[
  13
]
7 0.46 ms
SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.fin_inscription AS fin_inscription_3, t0.nb_joueur AS nb_joueur_4, t0.date_fin AS date_fin_5, t0.adresse AS adresse_6, t0.complement AS complement_7, t0.cp AS cp_8, t0.ville AS ville_9, t0.pays AS pays_10, t0.map AS map_11, t0.nb_joueur_max AS nb_joueur_max_12, t0.nb_equipe_max AS nb_equipe_max_13, t0.terrain_interieur AS terrain_interieur_14, t0.terrain_exterieur AS terrain_exterieur_15, t0.type_balle AS type_balle_16, t0.nb_joueur_par_equipe AS nb_joueur_par_equipe_17, t0.montant_repas AS montant_repas_18, t0.devise AS devise_19, t0.nb_journee_previsionnel AS nb_journee_previsionnel_20, t0.prizepool AS prizepool_21, t0.nb_match_par_rencontre AS nb_match_par_rencontre_22, t0.datas_victoire AS datas_victoire_23, t0.points_victoire AS points_victoire_24, t0.points_defaite AS points_defaite_25, t0.points_nul AS points_nul_26, t0.categorie AS categorie_27, t28.id AS id_29, t28.ordre_circuit AS ordre_circuit_30, t28.is_master_final AS is_master_final_31, t28.sur_invitation AS sur_invitation_32, t28.points_assiduite AS points_assiduite_33, t28.titre AS titre_34, t28.description AS description_35, t28.creation AS creation_36, t28.termine AS termine_37, t28.date_creation AS date_creation_38, t28.encours AS encours_39, t28.publier AS publier_40, t28.inscriptions_ouvertes AS inscriptions_ouvertes_41, t28.homologuer_fft AS homologuer_fft_42, t28.demander_id_dupr AS demander_id_dupr_43, t28.require_dupr_plus AS require_dupr_plus_44, t28.require_dupr_verified AS require_dupr_verified_45, t28.inscription_privee AS inscription_privee_46, t28.code_pin_inscription AS code_pin_inscription_47, t28.etat_actuel AS etat_actuel_48, t28.commission_plateforme AS commission_plateforme_49, t28.config_id AS config_id_50, t28.organisateur_id AS organisateur_id_51, t28.style_id AS style_id_52, t28.circuit_id AS circuit_id_53 FROM config t0 LEFT JOIN evenement t28 ON t28.config_id = t0.id WHERE t0.id = ?
Parameters:
[
  15
]
8 0.47 ms
SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.fin_inscription AS fin_inscription_3, t0.nb_joueur AS nb_joueur_4, t0.date_fin AS date_fin_5, t0.adresse AS adresse_6, t0.complement AS complement_7, t0.cp AS cp_8, t0.ville AS ville_9, t0.pays AS pays_10, t0.map AS map_11, t0.nb_joueur_max AS nb_joueur_max_12, t0.nb_equipe_max AS nb_equipe_max_13, t0.terrain_interieur AS terrain_interieur_14, t0.terrain_exterieur AS terrain_exterieur_15, t0.type_balle AS type_balle_16, t0.nb_joueur_par_equipe AS nb_joueur_par_equipe_17, t0.montant_repas AS montant_repas_18, t0.devise AS devise_19, t0.nb_journee_previsionnel AS nb_journee_previsionnel_20, t0.prizepool AS prizepool_21, t0.nb_match_par_rencontre AS nb_match_par_rencontre_22, t0.datas_victoire AS datas_victoire_23, t0.points_victoire AS points_victoire_24, t0.points_defaite AS points_defaite_25, t0.points_nul AS points_nul_26, t0.categorie AS categorie_27, t28.id AS id_29, t28.ordre_circuit AS ordre_circuit_30, t28.is_master_final AS is_master_final_31, t28.sur_invitation AS sur_invitation_32, t28.points_assiduite AS points_assiduite_33, t28.titre AS titre_34, t28.description AS description_35, t28.creation AS creation_36, t28.termine AS termine_37, t28.date_creation AS date_creation_38, t28.encours AS encours_39, t28.publier AS publier_40, t28.inscriptions_ouvertes AS inscriptions_ouvertes_41, t28.homologuer_fft AS homologuer_fft_42, t28.demander_id_dupr AS demander_id_dupr_43, t28.require_dupr_plus AS require_dupr_plus_44, t28.require_dupr_verified AS require_dupr_verified_45, t28.inscription_privee AS inscription_privee_46, t28.code_pin_inscription AS code_pin_inscription_47, t28.etat_actuel AS etat_actuel_48, t28.commission_plateforme AS commission_plateforme_49, t28.config_id AS config_id_50, t28.organisateur_id AS organisateur_id_51, t28.style_id AS style_id_52, t28.circuit_id AS circuit_id_53 FROM config t0 LEFT JOIN evenement t28 ON t28.config_id = t0.id WHERE t0.id = ?
Parameters:
[
  16
]
9 0.48 ms
SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.fin_inscription AS fin_inscription_3, t0.nb_joueur AS nb_joueur_4, t0.date_fin AS date_fin_5, t0.adresse AS adresse_6, t0.complement AS complement_7, t0.cp AS cp_8, t0.ville AS ville_9, t0.pays AS pays_10, t0.map AS map_11, t0.nb_joueur_max AS nb_joueur_max_12, t0.nb_equipe_max AS nb_equipe_max_13, t0.terrain_interieur AS terrain_interieur_14, t0.terrain_exterieur AS terrain_exterieur_15, t0.type_balle AS type_balle_16, t0.nb_joueur_par_equipe AS nb_joueur_par_equipe_17, t0.montant_repas AS montant_repas_18, t0.devise AS devise_19, t0.nb_journee_previsionnel AS nb_journee_previsionnel_20, t0.prizepool AS prizepool_21, t0.nb_match_par_rencontre AS nb_match_par_rencontre_22, t0.datas_victoire AS datas_victoire_23, t0.points_victoire AS points_victoire_24, t0.points_defaite AS points_defaite_25, t0.points_nul AS points_nul_26, t0.categorie AS categorie_27, t28.id AS id_29, t28.ordre_circuit AS ordre_circuit_30, t28.is_master_final AS is_master_final_31, t28.sur_invitation AS sur_invitation_32, t28.points_assiduite AS points_assiduite_33, t28.titre AS titre_34, t28.description AS description_35, t28.creation AS creation_36, t28.termine AS termine_37, t28.date_creation AS date_creation_38, t28.encours AS encours_39, t28.publier AS publier_40, t28.inscriptions_ouvertes AS inscriptions_ouvertes_41, t28.homologuer_fft AS homologuer_fft_42, t28.demander_id_dupr AS demander_id_dupr_43, t28.require_dupr_plus AS require_dupr_plus_44, t28.require_dupr_verified AS require_dupr_verified_45, t28.inscription_privee AS inscription_privee_46, t28.code_pin_inscription AS code_pin_inscription_47, t28.etat_actuel AS etat_actuel_48, t28.commission_plateforme AS commission_plateforme_49, t28.config_id AS config_id_50, t28.organisateur_id AS organisateur_id_51, t28.style_id AS style_id_52, t28.circuit_id AS circuit_id_53 FROM config t0 LEFT JOIN evenement t28 ON t28.config_id = t0.id WHERE t0.id = ?
Parameters:
[
  18
]
10 0.47 ms
SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.fin_inscription AS fin_inscription_3, t0.nb_joueur AS nb_joueur_4, t0.date_fin AS date_fin_5, t0.adresse AS adresse_6, t0.complement AS complement_7, t0.cp AS cp_8, t0.ville AS ville_9, t0.pays AS pays_10, t0.map AS map_11, t0.nb_joueur_max AS nb_joueur_max_12, t0.nb_equipe_max AS nb_equipe_max_13, t0.terrain_interieur AS terrain_interieur_14, t0.terrain_exterieur AS terrain_exterieur_15, t0.type_balle AS type_balle_16, t0.nb_joueur_par_equipe AS nb_joueur_par_equipe_17, t0.montant_repas AS montant_repas_18, t0.devise AS devise_19, t0.nb_journee_previsionnel AS nb_journee_previsionnel_20, t0.prizepool AS prizepool_21, t0.nb_match_par_rencontre AS nb_match_par_rencontre_22, t0.datas_victoire AS datas_victoire_23, t0.points_victoire AS points_victoire_24, t0.points_defaite AS points_defaite_25, t0.points_nul AS points_nul_26, t0.categorie AS categorie_27, t28.id AS id_29, t28.ordre_circuit AS ordre_circuit_30, t28.is_master_final AS is_master_final_31, t28.sur_invitation AS sur_invitation_32, t28.points_assiduite AS points_assiduite_33, t28.titre AS titre_34, t28.description AS description_35, t28.creation AS creation_36, t28.termine AS termine_37, t28.date_creation AS date_creation_38, t28.encours AS encours_39, t28.publier AS publier_40, t28.inscriptions_ouvertes AS inscriptions_ouvertes_41, t28.homologuer_fft AS homologuer_fft_42, t28.demander_id_dupr AS demander_id_dupr_43, t28.require_dupr_plus AS require_dupr_plus_44, t28.require_dupr_verified AS require_dupr_verified_45, t28.inscription_privee AS inscription_privee_46, t28.code_pin_inscription AS code_pin_inscription_47, t28.etat_actuel AS etat_actuel_48, t28.commission_plateforme AS commission_plateforme_49, t28.config_id AS config_id_50, t28.organisateur_id AS organisateur_id_51, t28.style_id AS style_id_52, t28.circuit_id AS circuit_id_53 FROM config t0 LEFT JOIN evenement t28 ON t28.config_id = t0.id WHERE t0.id = ?
Parameters:
[
  21
]
11 0.47 ms
SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.fin_inscription AS fin_inscription_3, t0.nb_joueur AS nb_joueur_4, t0.date_fin AS date_fin_5, t0.adresse AS adresse_6, t0.complement AS complement_7, t0.cp AS cp_8, t0.ville AS ville_9, t0.pays AS pays_10, t0.map AS map_11, t0.nb_joueur_max AS nb_joueur_max_12, t0.nb_equipe_max AS nb_equipe_max_13, t0.terrain_interieur AS terrain_interieur_14, t0.terrain_exterieur AS terrain_exterieur_15, t0.type_balle AS type_balle_16, t0.nb_joueur_par_equipe AS nb_joueur_par_equipe_17, t0.montant_repas AS montant_repas_18, t0.devise AS devise_19, t0.nb_journee_previsionnel AS nb_journee_previsionnel_20, t0.prizepool AS prizepool_21, t0.nb_match_par_rencontre AS nb_match_par_rencontre_22, t0.datas_victoire AS datas_victoire_23, t0.points_victoire AS points_victoire_24, t0.points_defaite AS points_defaite_25, t0.points_nul AS points_nul_26, t0.categorie AS categorie_27, t28.id AS id_29, t28.ordre_circuit AS ordre_circuit_30, t28.is_master_final AS is_master_final_31, t28.sur_invitation AS sur_invitation_32, t28.points_assiduite AS points_assiduite_33, t28.titre AS titre_34, t28.description AS description_35, t28.creation AS creation_36, t28.termine AS termine_37, t28.date_creation AS date_creation_38, t28.encours AS encours_39, t28.publier AS publier_40, t28.inscriptions_ouvertes AS inscriptions_ouvertes_41, t28.homologuer_fft AS homologuer_fft_42, t28.demander_id_dupr AS demander_id_dupr_43, t28.require_dupr_plus AS require_dupr_plus_44, t28.require_dupr_verified AS require_dupr_verified_45, t28.inscription_privee AS inscription_privee_46, t28.code_pin_inscription AS code_pin_inscription_47, t28.etat_actuel AS etat_actuel_48, t28.commission_plateforme AS commission_plateforme_49, t28.config_id AS config_id_50, t28.organisateur_id AS organisateur_id_51, t28.style_id AS style_id_52, t28.circuit_id AS circuit_id_53 FROM config t0 LEFT JOIN evenement t28 ON t28.config_id = t0.id WHERE t0.id = ?
Parameters:
[
  23
]
12 0.47 ms
SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.fin_inscription AS fin_inscription_3, t0.nb_joueur AS nb_joueur_4, t0.date_fin AS date_fin_5, t0.adresse AS adresse_6, t0.complement AS complement_7, t0.cp AS cp_8, t0.ville AS ville_9, t0.pays AS pays_10, t0.map AS map_11, t0.nb_joueur_max AS nb_joueur_max_12, t0.nb_equipe_max AS nb_equipe_max_13, t0.terrain_interieur AS terrain_interieur_14, t0.terrain_exterieur AS terrain_exterieur_15, t0.type_balle AS type_balle_16, t0.nb_joueur_par_equipe AS nb_joueur_par_equipe_17, t0.montant_repas AS montant_repas_18, t0.devise AS devise_19, t0.nb_journee_previsionnel AS nb_journee_previsionnel_20, t0.prizepool AS prizepool_21, t0.nb_match_par_rencontre AS nb_match_par_rencontre_22, t0.datas_victoire AS datas_victoire_23, t0.points_victoire AS points_victoire_24, t0.points_defaite AS points_defaite_25, t0.points_nul AS points_nul_26, t0.categorie AS categorie_27, t28.id AS id_29, t28.ordre_circuit AS ordre_circuit_30, t28.is_master_final AS is_master_final_31, t28.sur_invitation AS sur_invitation_32, t28.points_assiduite AS points_assiduite_33, t28.titre AS titre_34, t28.description AS description_35, t28.creation AS creation_36, t28.termine AS termine_37, t28.date_creation AS date_creation_38, t28.encours AS encours_39, t28.publier AS publier_40, t28.inscriptions_ouvertes AS inscriptions_ouvertes_41, t28.homologuer_fft AS homologuer_fft_42, t28.demander_id_dupr AS demander_id_dupr_43, t28.require_dupr_plus AS require_dupr_plus_44, t28.require_dupr_verified AS require_dupr_verified_45, t28.inscription_privee AS inscription_privee_46, t28.code_pin_inscription AS code_pin_inscription_47, t28.etat_actuel AS etat_actuel_48, t28.commission_plateforme AS commission_plateforme_49, t28.config_id AS config_id_50, t28.organisateur_id AS organisateur_id_51, t28.style_id AS style_id_52, t28.circuit_id AS circuit_id_53 FROM config t0 LEFT JOIN evenement t28 ON t28.config_id = t0.id WHERE t0.id = ?
Parameters:
[
  24
]
13 0.51 ms
SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.fin_inscription AS fin_inscription_3, t0.nb_joueur AS nb_joueur_4, t0.date_fin AS date_fin_5, t0.adresse AS adresse_6, t0.complement AS complement_7, t0.cp AS cp_8, t0.ville AS ville_9, t0.pays AS pays_10, t0.map AS map_11, t0.nb_joueur_max AS nb_joueur_max_12, t0.nb_equipe_max AS nb_equipe_max_13, t0.terrain_interieur AS terrain_interieur_14, t0.terrain_exterieur AS terrain_exterieur_15, t0.type_balle AS type_balle_16, t0.nb_joueur_par_equipe AS nb_joueur_par_equipe_17, t0.montant_repas AS montant_repas_18, t0.devise AS devise_19, t0.nb_journee_previsionnel AS nb_journee_previsionnel_20, t0.prizepool AS prizepool_21, t0.nb_match_par_rencontre AS nb_match_par_rencontre_22, t0.datas_victoire AS datas_victoire_23, t0.points_victoire AS points_victoire_24, t0.points_defaite AS points_defaite_25, t0.points_nul AS points_nul_26, t0.categorie AS categorie_27, t28.id AS id_29, t28.ordre_circuit AS ordre_circuit_30, t28.is_master_final AS is_master_final_31, t28.sur_invitation AS sur_invitation_32, t28.points_assiduite AS points_assiduite_33, t28.titre AS titre_34, t28.description AS description_35, t28.creation AS creation_36, t28.termine AS termine_37, t28.date_creation AS date_creation_38, t28.encours AS encours_39, t28.publier AS publier_40, t28.inscriptions_ouvertes AS inscriptions_ouvertes_41, t28.homologuer_fft AS homologuer_fft_42, t28.demander_id_dupr AS demander_id_dupr_43, t28.require_dupr_plus AS require_dupr_plus_44, t28.require_dupr_verified AS require_dupr_verified_45, t28.inscription_privee AS inscription_privee_46, t28.code_pin_inscription AS code_pin_inscription_47, t28.etat_actuel AS etat_actuel_48, t28.commission_plateforme AS commission_plateforme_49, t28.config_id AS config_id_50, t28.organisateur_id AS organisateur_id_51, t28.style_id AS style_id_52, t28.circuit_id AS circuit_id_53 FROM config t0 LEFT JOIN evenement t28 ON t28.config_id = t0.id WHERE t0.id = ?
Parameters:
[
  25
]
14 0.49 ms
SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.fin_inscription AS fin_inscription_3, t0.nb_joueur AS nb_joueur_4, t0.date_fin AS date_fin_5, t0.adresse AS adresse_6, t0.complement AS complement_7, t0.cp AS cp_8, t0.ville AS ville_9, t0.pays AS pays_10, t0.map AS map_11, t0.nb_joueur_max AS nb_joueur_max_12, t0.nb_equipe_max AS nb_equipe_max_13, t0.terrain_interieur AS terrain_interieur_14, t0.terrain_exterieur AS terrain_exterieur_15, t0.type_balle AS type_balle_16, t0.nb_joueur_par_equipe AS nb_joueur_par_equipe_17, t0.montant_repas AS montant_repas_18, t0.devise AS devise_19, t0.nb_journee_previsionnel AS nb_journee_previsionnel_20, t0.prizepool AS prizepool_21, t0.nb_match_par_rencontre AS nb_match_par_rencontre_22, t0.datas_victoire AS datas_victoire_23, t0.points_victoire AS points_victoire_24, t0.points_defaite AS points_defaite_25, t0.points_nul AS points_nul_26, t0.categorie AS categorie_27, t28.id AS id_29, t28.ordre_circuit AS ordre_circuit_30, t28.is_master_final AS is_master_final_31, t28.sur_invitation AS sur_invitation_32, t28.points_assiduite AS points_assiduite_33, t28.titre AS titre_34, t28.description AS description_35, t28.creation AS creation_36, t28.termine AS termine_37, t28.date_creation AS date_creation_38, t28.encours AS encours_39, t28.publier AS publier_40, t28.inscriptions_ouvertes AS inscriptions_ouvertes_41, t28.homologuer_fft AS homologuer_fft_42, t28.demander_id_dupr AS demander_id_dupr_43, t28.require_dupr_plus AS require_dupr_plus_44, t28.require_dupr_verified AS require_dupr_verified_45, t28.inscription_privee AS inscription_privee_46, t28.code_pin_inscription AS code_pin_inscription_47, t28.etat_actuel AS etat_actuel_48, t28.commission_plateforme AS commission_plateforme_49, t28.config_id AS config_id_50, t28.organisateur_id AS organisateur_id_51, t28.style_id AS style_id_52, t28.circuit_id AS circuit_id_53 FROM config t0 LEFT JOIN evenement t28 ON t28.config_id = t0.id WHERE t0.id = ?
Parameters:
[
  28
]
15 0.62 ms
SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM evenement e0_ INNER JOIN config c1_ ON e0_.config_id = c1_.id INNER JOIN style s2_ ON e0_.style_id = s2_.id LEFT JOIN selection s3_ ON c1_.id = s3_.config_id WHERE e0_.encours = 1 AND e0_.publier = 1 AND s2_.nom <> ?
Parameters:
[
  "Circuit"
]
16 1.72 ms
SELECT COALESCE(SUM(
                CASE WHEN ep.is_simple = 1 THEN 1 ELSE 0.5 END
            ), 0) as total_teams
            FROM user_selection us
            JOIN selection s ON us.selection_id = s.id
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            JOIN epreuve ep ON s.id_epreuve_id = ep.id
            WHERE us.paye = 1
            AND e.id = ?
Parameters:
[
  28
]
17 0.71 ms
SELECT COUNT(DISTINCT s.jour) as nb_jours
            FROM selection s
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            WHERE e.id = ?
            AND s.jour IS NOT NULL
Parameters:
[
  28
]
18 0.61 ms
SELECT DISTINCT s.jour
            FROM selection s
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            WHERE e.id = ?
            AND s.jour IS NOT NULL
            ORDER BY s.jour ASC
Parameters:
[
  28
]
19 0.81 ms
SELECT s.jour, COALESCE(SUM(
                CASE WHEN ep.is_simple = 1 THEN 1 ELSE 0.5 END
            ), 0) as total_teams
            FROM user_selection us
            JOIN selection s ON us.selection_id = s.id
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            JOIN epreuve ep ON s.id_epreuve_id = ep.id
            WHERE us.paye = 1
            AND e.id = ?
            AND s.jour IS NOT NULL
            GROUP BY s.jour
Parameters:
[
  28
]
20 0.46 ms
SELECT AVG(a0_.note) AS sclr_0 FROM avis a0_ WHERE a0_.evenement_id = ? AND a0_.statut = ?
Parameters:
[
  28
  "valide"
]
21 0.40 ms
SELECT COUNT(a0_.id) AS sclr_0 FROM avis a0_ WHERE a0_.evenement_id = ? AND a0_.statut = ?
Parameters:
[
  28
  "valide"
]
22 0.70 ms
SELECT COALESCE(SUM(
                CASE WHEN ep.is_simple = 1 THEN 1 ELSE 0.5 END
            ), 0) as total_teams
            FROM user_selection us
            JOIN selection s ON us.selection_id = s.id
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            JOIN epreuve ep ON s.id_epreuve_id = ep.id
            WHERE us.paye = 1
            AND e.id = ?
Parameters:
[
  12
]
23 0.44 ms
SELECT COUNT(DISTINCT s.jour) as nb_jours
            FROM selection s
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            WHERE e.id = ?
            AND s.jour IS NOT NULL
Parameters:
[
  12
]
24 0.49 ms
SELECT DISTINCT s.jour
            FROM selection s
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            WHERE e.id = ?
            AND s.jour IS NOT NULL
            ORDER BY s.jour ASC
Parameters:
[
  12
]
25 0.66 ms
SELECT s.jour, COALESCE(SUM(
                CASE WHEN ep.is_simple = 1 THEN 1 ELSE 0.5 END
            ), 0) as total_teams
            FROM user_selection us
            JOIN selection s ON us.selection_id = s.id
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            JOIN epreuve ep ON s.id_epreuve_id = ep.id
            WHERE us.paye = 1
            AND e.id = ?
            AND s.jour IS NOT NULL
            GROUP BY s.jour
Parameters:
[
  12
]
26 0.36 ms
SELECT AVG(a0_.note) AS sclr_0 FROM avis a0_ WHERE a0_.evenement_id = ? AND a0_.statut = ?
Parameters:
[
  12
  "valide"
]
27 0.34 ms
SELECT COUNT(a0_.id) AS sclr_0 FROM avis a0_ WHERE a0_.evenement_id = ? AND a0_.statut = ?
Parameters:
[
  12
  "valide"
]
28 0.74 ms
SELECT t0.id AS id_1, t0.ordre_circuit AS ordre_circuit_2, t0.is_master_final AS is_master_final_3, t0.sur_invitation AS sur_invitation_4, t0.points_assiduite AS points_assiduite_5, t0.titre AS titre_6, t0.description AS description_7, t0.creation AS creation_8, t0.termine AS termine_9, t0.date_creation AS date_creation_10, t0.encours AS encours_11, t0.publier AS publier_12, t0.inscriptions_ouvertes AS inscriptions_ouvertes_13, t0.homologuer_fft AS homologuer_fft_14, t0.demander_id_dupr AS demander_id_dupr_15, t0.require_dupr_plus AS require_dupr_plus_16, t0.require_dupr_verified AS require_dupr_verified_17, t0.inscription_privee AS inscription_privee_18, t0.code_pin_inscription AS code_pin_inscription_19, t0.etat_actuel AS etat_actuel_20, t0.commission_plateforme AS commission_plateforme_21, t0.config_id AS config_id_22, t0.organisateur_id AS organisateur_id_23, t0.style_id AS style_id_24, t0.circuit_id AS circuit_id_25 FROM evenement t0 WHERE t0.id = ?
Parameters:
[
  22
]
29 1.42 ms
SELECT COALESCE(SUM(
                CASE WHEN ep.is_simple = 1 THEN 1 ELSE 0.5 END
            ), 0) as total_teams
            FROM user_selection us
            JOIN selection s ON us.selection_id = s.id
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            JOIN epreuve ep ON s.id_epreuve_id = ep.id
            WHERE us.paye = 1
            AND e.id = ?
Parameters:
[
  21
]
30 0.72 ms
SELECT COUNT(DISTINCT s.jour) as nb_jours
            FROM selection s
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            WHERE e.id = ?
            AND s.jour IS NOT NULL
Parameters:
[
  21
]
31 0.68 ms
SELECT DISTINCT s.jour
            FROM selection s
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            WHERE e.id = ?
            AND s.jour IS NOT NULL
            ORDER BY s.jour ASC
Parameters:
[
  21
]
32 1.65 ms
SELECT s.jour, COALESCE(SUM(
                CASE WHEN ep.is_simple = 1 THEN 1 ELSE 0.5 END
            ), 0) as total_teams
            FROM user_selection us
            JOIN selection s ON us.selection_id = s.id
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            JOIN epreuve ep ON s.id_epreuve_id = ep.id
            WHERE us.paye = 1
            AND e.id = ?
            AND s.jour IS NOT NULL
            GROUP BY s.jour
Parameters:
[
  21
]
33 0.43 ms
SELECT AVG(a0_.note) AS sclr_0 FROM avis a0_ WHERE a0_.evenement_id = ? AND a0_.statut = ?
Parameters:
[
  21
  "valide"
]
34 0.35 ms
SELECT COUNT(a0_.id) AS sclr_0 FROM avis a0_ WHERE a0_.evenement_id = ? AND a0_.statut = ?
Parameters:
[
  21
  "valide"
]
35 0.83 ms
SELECT COALESCE(SUM(
                CASE WHEN ep.is_simple = 1 THEN 1 ELSE 0.5 END
            ), 0) as total_teams
            FROM user_selection us
            JOIN selection s ON us.selection_id = s.id
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            JOIN epreuve ep ON s.id_epreuve_id = ep.id
            WHERE us.paye = 1
            AND e.id = ?
Parameters:
[
  23
]
36 0.54 ms
SELECT COUNT(DISTINCT s.jour) as nb_jours
            FROM selection s
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            WHERE e.id = ?
            AND s.jour IS NOT NULL
Parameters:
[
  23
]
37 0.77 ms
SELECT DISTINCT s.jour
            FROM selection s
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            WHERE e.id = ?
            AND s.jour IS NOT NULL
            ORDER BY s.jour ASC
Parameters:
[
  23
]
38 1.31 ms
SELECT s.jour, COALESCE(SUM(
                CASE WHEN ep.is_simple = 1 THEN 1 ELSE 0.5 END
            ), 0) as total_teams
            FROM user_selection us
            JOIN selection s ON us.selection_id = s.id
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            JOIN epreuve ep ON s.id_epreuve_id = ep.id
            WHERE us.paye = 1
            AND e.id = ?
            AND s.jour IS NOT NULL
            GROUP BY s.jour
Parameters:
[
  23
]
39 0.69 ms
SELECT AVG(a0_.note) AS sclr_0 FROM avis a0_ WHERE a0_.evenement_id = ? AND a0_.statut = ?
Parameters:
[
  23
  "valide"
]
40 0.44 ms
SELECT COUNT(a0_.id) AS sclr_0 FROM avis a0_ WHERE a0_.evenement_id = ? AND a0_.statut = ?
Parameters:
[
  23
  "valide"
]
41 1.13 ms
SELECT COALESCE(SUM(
                CASE WHEN ep.is_simple = 1 THEN 1 ELSE 0.5 END
            ), 0) as total_teams
            FROM user_selection us
            JOIN selection s ON us.selection_id = s.id
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            JOIN epreuve ep ON s.id_epreuve_id = ep.id
            WHERE us.paye = 1
            AND e.id = ?
Parameters:
[
  25
]
42 0.78 ms
SELECT COUNT(DISTINCT s.jour) as nb_jours
            FROM selection s
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            WHERE e.id = ?
            AND s.jour IS NOT NULL
Parameters:
[
  25
]
43 0.50 ms
SELECT DISTINCT s.jour
            FROM selection s
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            WHERE e.id = ?
            AND s.jour IS NOT NULL
            ORDER BY s.jour ASC
Parameters:
[
  25
]
44 1.15 ms
SELECT s.jour, COALESCE(SUM(
                CASE WHEN ep.is_simple = 1 THEN 1 ELSE 0.5 END
            ), 0) as total_teams
            FROM user_selection us
            JOIN selection s ON us.selection_id = s.id
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            JOIN epreuve ep ON s.id_epreuve_id = ep.id
            WHERE us.paye = 1
            AND e.id = ?
            AND s.jour IS NOT NULL
            GROUP BY s.jour
Parameters:
[
  25
]
45 0.44 ms
SELECT AVG(a0_.note) AS sclr_0 FROM avis a0_ WHERE a0_.evenement_id = ? AND a0_.statut = ?
Parameters:
[
  25
  "valide"
]
46 0.37 ms
SELECT COUNT(a0_.id) AS sclr_0 FROM avis a0_ WHERE a0_.evenement_id = ? AND a0_.statut = ?
Parameters:
[
  25
  "valide"
]
47 0.84 ms
SELECT COALESCE(SUM(
                CASE WHEN ep.is_simple = 1 THEN 1 ELSE 0.5 END
            ), 0) as total_teams
            FROM user_selection us
            JOIN selection s ON us.selection_id = s.id
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            JOIN epreuve ep ON s.id_epreuve_id = ep.id
            WHERE us.paye = 1
            AND e.id = ?
Parameters:
[
  13
]
48 0.47 ms
SELECT COUNT(DISTINCT s.jour) as nb_jours
            FROM selection s
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            WHERE e.id = ?
            AND s.jour IS NOT NULL
Parameters:
[
  13
]
49 0.50 ms
SELECT DISTINCT s.jour
            FROM selection s
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            WHERE e.id = ?
            AND s.jour IS NOT NULL
            ORDER BY s.jour ASC
Parameters:
[
  13
]
50 0.85 ms
SELECT s.jour, COALESCE(SUM(
                CASE WHEN ep.is_simple = 1 THEN 1 ELSE 0.5 END
            ), 0) as total_teams
            FROM user_selection us
            JOIN selection s ON us.selection_id = s.id
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            JOIN epreuve ep ON s.id_epreuve_id = ep.id
            WHERE us.paye = 1
            AND e.id = ?
            AND s.jour IS NOT NULL
            GROUP BY s.jour
Parameters:
[
  13
]
51 0.33 ms
SELECT AVG(a0_.note) AS sclr_0 FROM avis a0_ WHERE a0_.evenement_id = ? AND a0_.statut = ?
Parameters:
[
  13
  "valide"
]
52 0.29 ms
SELECT COUNT(a0_.id) AS sclr_0 FROM avis a0_ WHERE a0_.evenement_id = ? AND a0_.statut = ?
Parameters:
[
  13
  "valide"
]
53 0.54 ms
SELECT COUNT(a0_.id) AS sclr_0, AVG(a0_.note_plateforme) AS sclr_1, SUM(CASE WHEN a0_.note_plateforme >= 4 THEN 1 ELSE 0 END) AS sclr_2 FROM avis a0_ WHERE a0_.note_plateforme IS NOT NULL AND a0_.statut_plateforme = ?
Parameters:
[
  "valide"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Evenement 13
App\Entity\Config 13
App\Entity\User 6
App\Entity\Age 3
App\Entity\Style 2

Entities Mapping

Class Mapping errors
App\Entity\Age No errors.
App\Entity\Selection No errors.
App\Entity\Evenement No errors.
App\Entity\Config No errors.
App\Entity\Style No errors.
App\Entity\User No errors.
App\Entity\Photo No errors.
App\Entity\EvenementInformation No errors.
App\Entity\Playoff No errors.
App\Entity\Avis No errors.
App\Entity\Promo No errors.
App\Entity\Contact No errors.
App\Entity\UserSelection No errors.