Query Metrics
53
Database Queries
12
Different statements
36.38 ms
Query time
0
Invalid entities
37
Managed entities
Queries
| #▲ | 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. |