GET https://preprod.tournoipickleball.fr/partnership-request/tournament/3/players?category=4

Query Metrics

42 Database Queries
6 Different statements
30.98 ms Query time
4 Invalid entities
73 Managed entities

Queries

Group similar statements

# Time Info
1 0.88 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.creation AS creation_4, t0.termine AS termine_5, t0.date_creation AS date_creation_6, t0.encours AS encours_7, t0.publier AS publier_8, t0.homologuer_fft AS homologuer_fft_9, t0.demander_id_dupr AS demander_id_dupr_10, t0.etat_actuel AS etat_actuel_11, t0.config_id AS config_id_12, t0.organisateur_id AS organisateur_id_13, t0.style_id AS style_id_14 FROM evenement t0 WHERE t0.id = ?
Parameters:
[
  3
]
2 1.37 ms
SELECT u0_.id AS id_0, u0_.stripe_session_id AS stripe_session_id_1, u0_.stripe_payment_intent_id AS stripe_payment_intent_id_2, u0_.paye AS paye_3, u0_.date_paiement AS date_paiement_4, u0_.code_promo_utilise AS code_promo_utilise_5, u0_.montant_paye AS montant_paye_6, u0_.joueurs_selectionnes AS joueurs_selectionnes_7, u0_.date_selection_joueurs AS date_selection_joueurs_8, u0_.selection_joueurs_complete AS selection_joueurs_complete_9, u0_.metadata AS metadata_10, u0_.repas AS repas_11, u0_.nb_repas AS nb_repas_12, u0_.user_id AS user_id_13, u0_.selection_id AS selection_id_14, u0_.payment_id AS payment_id_15 FROM user_selection u0_ INNER JOIN `user` u1_ ON u0_.user_id = u1_.id INNER JOIN selection s2_ ON u0_.selection_id = s2_.id WHERE s2_.config_id = ? AND u0_.paye = ? AND s2_.id = ?
Parameters:
[
  3
  1
  4
]
3 1.01 ms
SELECT e0_.id AS id_0, e0_.date_equipe AS date_equipe_1, e0_.nom AS nom_2, e0_.selection_id AS selection_id_3 FROM equipe e0_ INNER JOIN equipe_user e1_ ON e0_.id = e1_.equipe_id WHERE e1_.user_id = ? AND e0_.selection_id = ? LIMIT 1
Parameters:
[
  5940
  4
]
4 0.67 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.licence AS licence_4, t0.id_dupr AS id_dupr_5, t0.genre AS genre_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.date_de_naissance AS date_de_naissance_9, t0.ville AS ville_10, t0.description AS description_11, t0.telephone AS telephone_12, t0.instagram AS instagram_13, t0.linkedin AS linkedin_14, t0.tiktok AS tiktok_15, t0.twitter AS twitter_16, t0.facebook AS facebook_17, t0.statut AS statut_18, t0.roles AS roles_19, t0.password AS password_20, t0.indicateur AS indicateur_21, t0.createur AS createur_22, t0.pays_id AS pays_id_23, t0.niveau_simple_id AS niveau_simple_id_24, t0.niveau_double_id AS niveau_double_id_25, t0.niveau_mixte_id AS niveau_mixte_id_26 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  5940
]
5 0.54 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prix AS prix_3, t0.metadata AS metadata_4, t0.jour AS jour_5, t0.id_epreuve_id AS id_epreuve_id_6, t0.id_age_id AS id_age_id_7, t0.id_niveau_id AS id_niveau_id_8, t0.id_forme_id AS id_forme_id_9, t0.config_id AS config_id_10, t0.evenement_id AS evenement_id_11 FROM selection t0 WHERE t0.id = ?
Parameters:
[
  4
]
6 0.76 ms
SELECT e0_.id AS id_0, e0_.date_equipe AS date_equipe_1, e0_.nom AS nom_2, e0_.selection_id AS selection_id_3 FROM equipe e0_ INNER JOIN equipe_user e1_ ON e0_.id = e1_.equipe_id WHERE e1_.user_id = ? AND e0_.selection_id = ? LIMIT 1
Parameters:
[
  5941
  4
]
7 0.60 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.licence AS licence_4, t0.id_dupr AS id_dupr_5, t0.genre AS genre_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.date_de_naissance AS date_de_naissance_9, t0.ville AS ville_10, t0.description AS description_11, t0.telephone AS telephone_12, t0.instagram AS instagram_13, t0.linkedin AS linkedin_14, t0.tiktok AS tiktok_15, t0.twitter AS twitter_16, t0.facebook AS facebook_17, t0.statut AS statut_18, t0.roles AS roles_19, t0.password AS password_20, t0.indicateur AS indicateur_21, t0.createur AS createur_22, t0.pays_id AS pays_id_23, t0.niveau_simple_id AS niveau_simple_id_24, t0.niveau_double_id AS niveau_double_id_25, t0.niveau_mixte_id AS niveau_mixte_id_26 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  5941
]
8 0.79 ms
SELECT e0_.id AS id_0, e0_.date_equipe AS date_equipe_1, e0_.nom AS nom_2, e0_.selection_id AS selection_id_3 FROM equipe e0_ INNER JOIN equipe_user e1_ ON e0_.id = e1_.equipe_id WHERE e1_.user_id = ? AND e0_.selection_id = ? LIMIT 1
Parameters:
[
  5942
  4
]
9 0.57 ms
SELECT t0.id AS id_1, t0.equipe_id AS equipe_id_2, t0.user_id AS user_id_3, t0.invitation_id AS invitation_id_4, t0.evenement_id AS evenement_id_5, t0.selection_id AS selection_id_6 FROM equipe_user t0 WHERE t0.equipe_id = ?
Parameters:
[
  31
]
10 0.59 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.licence AS licence_4, t0.id_dupr AS id_dupr_5, t0.genre AS genre_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.date_de_naissance AS date_de_naissance_9, t0.ville AS ville_10, t0.description AS description_11, t0.telephone AS telephone_12, t0.instagram AS instagram_13, t0.linkedin AS linkedin_14, t0.tiktok AS tiktok_15, t0.twitter AS twitter_16, t0.facebook AS facebook_17, t0.statut AS statut_18, t0.roles AS roles_19, t0.password AS password_20, t0.indicateur AS indicateur_21, t0.createur AS createur_22, t0.pays_id AS pays_id_23, t0.niveau_simple_id AS niveau_simple_id_24, t0.niveau_double_id AS niveau_double_id_25, t0.niveau_mixte_id AS niveau_mixte_id_26 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  5952
]
11 0.59 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.licence AS licence_4, t0.id_dupr AS id_dupr_5, t0.genre AS genre_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.date_de_naissance AS date_de_naissance_9, t0.ville AS ville_10, t0.description AS description_11, t0.telephone AS telephone_12, t0.instagram AS instagram_13, t0.linkedin AS linkedin_14, t0.tiktok AS tiktok_15, t0.twitter AS twitter_16, t0.facebook AS facebook_17, t0.statut AS statut_18, t0.roles AS roles_19, t0.password AS password_20, t0.indicateur AS indicateur_21, t0.createur AS createur_22, t0.pays_id AS pays_id_23, t0.niveau_simple_id AS niveau_simple_id_24, t0.niveau_double_id AS niveau_double_id_25, t0.niveau_mixte_id AS niveau_mixte_id_26 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  5942
]
12 0.82 ms
SELECT e0_.id AS id_0, e0_.date_equipe AS date_equipe_1, e0_.nom AS nom_2, e0_.selection_id AS selection_id_3 FROM equipe e0_ INNER JOIN equipe_user e1_ ON e0_.id = e1_.equipe_id WHERE e1_.user_id = ? AND e0_.selection_id = ? LIMIT 1
Parameters:
[
  5952
  4
]
13 0.71 ms
SELECT e0_.id AS id_0, e0_.date_equipe AS date_equipe_1, e0_.nom AS nom_2, e0_.selection_id AS selection_id_3 FROM equipe e0_ INNER JOIN equipe_user e1_ ON e0_.id = e1_.equipe_id WHERE e1_.user_id = ? AND e0_.selection_id = ? LIMIT 1
Parameters:
[
  5913
  4
]
14 0.67 ms
SELECT t0.id AS id_1, t0.equipe_id AS equipe_id_2, t0.user_id AS user_id_3, t0.invitation_id AS invitation_id_4, t0.evenement_id AS evenement_id_5, t0.selection_id AS selection_id_6 FROM equipe_user t0 WHERE t0.equipe_id = ?
Parameters:
[
  30
]
15 0.84 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.licence AS licence_4, t0.id_dupr AS id_dupr_5, t0.genre AS genre_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.date_de_naissance AS date_de_naissance_9, t0.ville AS ville_10, t0.description AS description_11, t0.telephone AS telephone_12, t0.instagram AS instagram_13, t0.linkedin AS linkedin_14, t0.tiktok AS tiktok_15, t0.twitter AS twitter_16, t0.facebook AS facebook_17, t0.statut AS statut_18, t0.roles AS roles_19, t0.password AS password_20, t0.indicateur AS indicateur_21, t0.createur AS createur_22, t0.pays_id AS pays_id_23, t0.niveau_simple_id AS niveau_simple_id_24, t0.niveau_double_id AS niveau_double_id_25, t0.niveau_mixte_id AS niveau_mixte_id_26 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  5915
]
16 0.77 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.licence AS licence_4, t0.id_dupr AS id_dupr_5, t0.genre AS genre_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.date_de_naissance AS date_de_naissance_9, t0.ville AS ville_10, t0.description AS description_11, t0.telephone AS telephone_12, t0.instagram AS instagram_13, t0.linkedin AS linkedin_14, t0.tiktok AS tiktok_15, t0.twitter AS twitter_16, t0.facebook AS facebook_17, t0.statut AS statut_18, t0.roles AS roles_19, t0.password AS password_20, t0.indicateur AS indicateur_21, t0.createur AS createur_22, t0.pays_id AS pays_id_23, t0.niveau_simple_id AS niveau_simple_id_24, t0.niveau_double_id AS niveau_double_id_25, t0.niveau_mixte_id AS niveau_mixte_id_26 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  5913
]
17 0.76 ms
SELECT e0_.id AS id_0, e0_.date_equipe AS date_equipe_1, e0_.nom AS nom_2, e0_.selection_id AS selection_id_3 FROM equipe e0_ INNER JOIN equipe_user e1_ ON e0_.id = e1_.equipe_id WHERE e1_.user_id = ? AND e0_.selection_id = ? LIMIT 1
Parameters:
[
  5903
  4
]
18 0.71 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.licence AS licence_4, t0.id_dupr AS id_dupr_5, t0.genre AS genre_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.date_de_naissance AS date_de_naissance_9, t0.ville AS ville_10, t0.description AS description_11, t0.telephone AS telephone_12, t0.instagram AS instagram_13, t0.linkedin AS linkedin_14, t0.tiktok AS tiktok_15, t0.twitter AS twitter_16, t0.facebook AS facebook_17, t0.statut AS statut_18, t0.roles AS roles_19, t0.password AS password_20, t0.indicateur AS indicateur_21, t0.createur AS createur_22, t0.pays_id AS pays_id_23, t0.niveau_simple_id AS niveau_simple_id_24, t0.niveau_double_id AS niveau_double_id_25, t0.niveau_mixte_id AS niveau_mixte_id_26 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  5903
]
19 0.77 ms
SELECT e0_.id AS id_0, e0_.date_equipe AS date_equipe_1, e0_.nom AS nom_2, e0_.selection_id AS selection_id_3 FROM equipe e0_ INNER JOIN equipe_user e1_ ON e0_.id = e1_.equipe_id WHERE e1_.user_id = ? AND e0_.selection_id = ? LIMIT 1
Parameters:
[
  5915
  4
]
20 0.81 ms
SELECT e0_.id AS id_0, e0_.date_equipe AS date_equipe_1, e0_.nom AS nom_2, e0_.selection_id AS selection_id_3 FROM equipe e0_ INNER JOIN equipe_user e1_ ON e0_.id = e1_.equipe_id WHERE e1_.user_id = ? AND e0_.selection_id = ? LIMIT 1
Parameters:
[
  5925
  4
]
21 0.80 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.licence AS licence_4, t0.id_dupr AS id_dupr_5, t0.genre AS genre_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.date_de_naissance AS date_de_naissance_9, t0.ville AS ville_10, t0.description AS description_11, t0.telephone AS telephone_12, t0.instagram AS instagram_13, t0.linkedin AS linkedin_14, t0.tiktok AS tiktok_15, t0.twitter AS twitter_16, t0.facebook AS facebook_17, t0.statut AS statut_18, t0.roles AS roles_19, t0.password AS password_20, t0.indicateur AS indicateur_21, t0.createur AS createur_22, t0.pays_id AS pays_id_23, t0.niveau_simple_id AS niveau_simple_id_24, t0.niveau_double_id AS niveau_double_id_25, t0.niveau_mixte_id AS niveau_mixte_id_26 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  5925
]
22 0.76 ms
SELECT e0_.id AS id_0, e0_.date_equipe AS date_equipe_1, e0_.nom AS nom_2, e0_.selection_id AS selection_id_3 FROM equipe e0_ INNER JOIN equipe_user e1_ ON e0_.id = e1_.equipe_id WHERE e1_.user_id = ? AND e0_.selection_id = ? LIMIT 1
Parameters:
[
  5951
  4
]
23 0.84 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.licence AS licence_4, t0.id_dupr AS id_dupr_5, t0.genre AS genre_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.date_de_naissance AS date_de_naissance_9, t0.ville AS ville_10, t0.description AS description_11, t0.telephone AS telephone_12, t0.instagram AS instagram_13, t0.linkedin AS linkedin_14, t0.tiktok AS tiktok_15, t0.twitter AS twitter_16, t0.facebook AS facebook_17, t0.statut AS statut_18, t0.roles AS roles_19, t0.password AS password_20, t0.indicateur AS indicateur_21, t0.createur AS createur_22, t0.pays_id AS pays_id_23, t0.niveau_simple_id AS niveau_simple_id_24, t0.niveau_double_id AS niveau_double_id_25, t0.niveau_mixte_id AS niveau_mixte_id_26 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  5951
]
24 0.62 ms
SELECT e0_.id AS id_0, e0_.date_equipe AS date_equipe_1, e0_.nom AS nom_2, e0_.selection_id AS selection_id_3 FROM equipe e0_ INNER JOIN equipe_user e1_ ON e0_.id = e1_.equipe_id WHERE e1_.user_id = ? AND e0_.selection_id = ? LIMIT 1
Parameters:
[
  5953
  4
]
25 0.86 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.licence AS licence_4, t0.id_dupr AS id_dupr_5, t0.genre AS genre_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.date_de_naissance AS date_de_naissance_9, t0.ville AS ville_10, t0.description AS description_11, t0.telephone AS telephone_12, t0.instagram AS instagram_13, t0.linkedin AS linkedin_14, t0.tiktok AS tiktok_15, t0.twitter AS twitter_16, t0.facebook AS facebook_17, t0.statut AS statut_18, t0.roles AS roles_19, t0.password AS password_20, t0.indicateur AS indicateur_21, t0.createur AS createur_22, t0.pays_id AS pays_id_23, t0.niveau_simple_id AS niveau_simple_id_24, t0.niveau_double_id AS niveau_double_id_25, t0.niveau_mixte_id AS niveau_mixte_id_26 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  5953
]
26 0.74 ms
SELECT e0_.id AS id_0, e0_.date_equipe AS date_equipe_1, e0_.nom AS nom_2, e0_.selection_id AS selection_id_3 FROM equipe e0_ INNER JOIN equipe_user e1_ ON e0_.id = e1_.equipe_id WHERE e1_.user_id = ? AND e0_.selection_id = ? LIMIT 1
Parameters:
[
  1
  4
]
27 0.52 ms
SELECT t0.id AS id_1, t0.equipe_id AS equipe_id_2, t0.user_id AS user_id_3, t0.invitation_id AS invitation_id_4, t0.evenement_id AS evenement_id_5, t0.selection_id AS selection_id_6 FROM equipe_user t0 WHERE t0.equipe_id = ?
Parameters:
[
  29
]
28 0.58 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.licence AS licence_4, t0.id_dupr AS id_dupr_5, t0.genre AS genre_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.date_de_naissance AS date_de_naissance_9, t0.ville AS ville_10, t0.description AS description_11, t0.telephone AS telephone_12, t0.instagram AS instagram_13, t0.linkedin AS linkedin_14, t0.tiktok AS tiktok_15, t0.twitter AS twitter_16, t0.facebook AS facebook_17, t0.statut AS statut_18, t0.roles AS roles_19, t0.password AS password_20, t0.indicateur AS indicateur_21, t0.createur AS createur_22, t0.pays_id AS pays_id_23, t0.niveau_simple_id AS niveau_simple_id_24, t0.niveau_double_id AS niveau_double_id_25, t0.niveau_mixte_id AS niveau_mixte_id_26 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  5896
]
29 0.64 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.licence AS licence_4, t0.id_dupr AS id_dupr_5, t0.genre AS genre_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.date_de_naissance AS date_de_naissance_9, t0.ville AS ville_10, t0.description AS description_11, t0.telephone AS telephone_12, t0.instagram AS instagram_13, t0.linkedin AS linkedin_14, t0.tiktok AS tiktok_15, t0.twitter AS twitter_16, t0.facebook AS facebook_17, t0.statut AS statut_18, t0.roles AS roles_19, t0.password AS password_20, t0.indicateur AS indicateur_21, t0.createur AS createur_22, t0.pays_id AS pays_id_23, t0.niveau_simple_id AS niveau_simple_id_24, t0.niveau_double_id AS niveau_double_id_25, t0.niveau_mixte_id AS niveau_mixte_id_26 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  1
]
30 0.67 ms
SELECT e0_.id AS id_0, e0_.date_equipe AS date_equipe_1, e0_.nom AS nom_2, e0_.selection_id AS selection_id_3 FROM equipe e0_ INNER JOIN equipe_user e1_ ON e0_.id = e1_.equipe_id WHERE e1_.user_id = ? AND e0_.selection_id = ? LIMIT 1
Parameters:
[
  5896
  4
]
31 0.60 ms
SELECT e0_.id AS id_0, e0_.date_equipe AS date_equipe_1, e0_.nom AS nom_2, e0_.selection_id AS selection_id_3 FROM equipe e0_ INNER JOIN equipe_user e1_ ON e0_.id = e1_.equipe_id WHERE e1_.user_id = ? AND e0_.selection_id = ? LIMIT 1
Parameters:
[
  5954
  4
]
32 0.57 ms
SELECT t0.id AS id_1, t0.equipe_id AS equipe_id_2, t0.user_id AS user_id_3, t0.invitation_id AS invitation_id_4, t0.evenement_id AS evenement_id_5, t0.selection_id AS selection_id_6 FROM equipe_user t0 WHERE t0.equipe_id = ?
Parameters:
[
  32
]
33 0.78 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.licence AS licence_4, t0.id_dupr AS id_dupr_5, t0.genre AS genre_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.date_de_naissance AS date_de_naissance_9, t0.ville AS ville_10, t0.description AS description_11, t0.telephone AS telephone_12, t0.instagram AS instagram_13, t0.linkedin AS linkedin_14, t0.tiktok AS tiktok_15, t0.twitter AS twitter_16, t0.facebook AS facebook_17, t0.statut AS statut_18, t0.roles AS roles_19, t0.password AS password_20, t0.indicateur AS indicateur_21, t0.createur AS createur_22, t0.pays_id AS pays_id_23, t0.niveau_simple_id AS niveau_simple_id_24, t0.niveau_double_id AS niveau_double_id_25, t0.niveau_mixte_id AS niveau_mixte_id_26 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  5955
]
34 0.67 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.licence AS licence_4, t0.id_dupr AS id_dupr_5, t0.genre AS genre_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.date_de_naissance AS date_de_naissance_9, t0.ville AS ville_10, t0.description AS description_11, t0.telephone AS telephone_12, t0.instagram AS instagram_13, t0.linkedin AS linkedin_14, t0.tiktok AS tiktok_15, t0.twitter AS twitter_16, t0.facebook AS facebook_17, t0.statut AS statut_18, t0.roles AS roles_19, t0.password AS password_20, t0.indicateur AS indicateur_21, t0.createur AS createur_22, t0.pays_id AS pays_id_23, t0.niveau_simple_id AS niveau_simple_id_24, t0.niveau_double_id AS niveau_double_id_25, t0.niveau_mixte_id AS niveau_mixte_id_26 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  5954
]
35 0.79 ms
SELECT e0_.id AS id_0, e0_.date_equipe AS date_equipe_1, e0_.nom AS nom_2, e0_.selection_id AS selection_id_3 FROM equipe e0_ INNER JOIN equipe_user e1_ ON e0_.id = e1_.equipe_id WHERE e1_.user_id = ? AND e0_.selection_id = ? LIMIT 1
Parameters:
[
  5955
  4
]
36 0.70 ms
SELECT e0_.id AS id_0, e0_.date_equipe AS date_equipe_1, e0_.nom AS nom_2, e0_.selection_id AS selection_id_3 FROM equipe e0_ INNER JOIN equipe_user e1_ ON e0_.id = e1_.equipe_id WHERE e1_.user_id = ? AND e0_.selection_id = ? LIMIT 1
Parameters:
[
  5939
  4
]
37 0.66 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.licence AS licence_4, t0.id_dupr AS id_dupr_5, t0.genre AS genre_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.date_de_naissance AS date_de_naissance_9, t0.ville AS ville_10, t0.description AS description_11, t0.telephone AS telephone_12, t0.instagram AS instagram_13, t0.linkedin AS linkedin_14, t0.tiktok AS tiktok_15, t0.twitter AS twitter_16, t0.facebook AS facebook_17, t0.statut AS statut_18, t0.roles AS roles_19, t0.password AS password_20, t0.indicateur AS indicateur_21, t0.createur AS createur_22, t0.pays_id AS pays_id_23, t0.niveau_simple_id AS niveau_simple_id_24, t0.niveau_double_id AS niveau_double_id_25, t0.niveau_mixte_id AS niveau_mixte_id_26 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  5939
]
38 0.66 ms
SELECT e0_.id AS id_0, e0_.date_equipe AS date_equipe_1, e0_.nom AS nom_2, e0_.selection_id AS selection_id_3 FROM equipe e0_ INNER JOIN equipe_user e1_ ON e0_.id = e1_.equipe_id WHERE e1_.user_id = ? AND e0_.selection_id = ? LIMIT 1
Parameters:
[
  5924
  4
]
39 0.79 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.licence AS licence_4, t0.id_dupr AS id_dupr_5, t0.genre AS genre_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.date_de_naissance AS date_de_naissance_9, t0.ville AS ville_10, t0.description AS description_11, t0.telephone AS telephone_12, t0.instagram AS instagram_13, t0.linkedin AS linkedin_14, t0.tiktok AS tiktok_15, t0.twitter AS twitter_16, t0.facebook AS facebook_17, t0.statut AS statut_18, t0.roles AS roles_19, t0.password AS password_20, t0.indicateur AS indicateur_21, t0.createur AS createur_22, t0.pays_id AS pays_id_23, t0.niveau_simple_id AS niveau_simple_id_24, t0.niveau_double_id AS niveau_double_id_25, t0.niveau_mixte_id AS niveau_mixte_id_26 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  5924
]
40 0.67 ms
SELECT e0_.id AS id_0, e0_.date_equipe AS date_equipe_1, e0_.nom AS nom_2, e0_.selection_id AS selection_id_3 FROM equipe e0_ INNER JOIN equipe_user e1_ ON e0_.id = e1_.equipe_id WHERE e1_.user_id = ? AND e0_.selection_id = ? LIMIT 1
Parameters:
[
  5945
  4
]
41 0.69 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.licence AS licence_4, t0.id_dupr AS id_dupr_5, t0.genre AS genre_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.date_de_naissance AS date_de_naissance_9, t0.ville AS ville_10, t0.description AS description_11, t0.telephone AS telephone_12, t0.instagram AS instagram_13, t0.linkedin AS linkedin_14, t0.tiktok AS tiktok_15, t0.twitter AS twitter_16, t0.facebook AS facebook_17, t0.statut AS statut_18, t0.roles AS roles_19, t0.password AS password_20, t0.indicateur AS indicateur_21, t0.createur AS createur_22, t0.pays_id AS pays_id_23, t0.niveau_simple_id AS niveau_simple_id_24, t0.niveau_double_id AS niveau_double_id_25, t0.niveau_mixte_id AS niveau_mixte_id_26 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  5945
]
42 1.15 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.licence AS licence_4, t0.id_dupr AS id_dupr_5, t0.genre AS genre_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.date_de_naissance AS date_de_naissance_9, t0.ville AS ville_10, t0.description AS description_11, t0.telephone AS telephone_12, t0.instagram AS instagram_13, t0.linkedin AS linkedin_14, t0.tiktok AS tiktok_15, t0.twitter AS twitter_16, t0.facebook AS facebook_17, t0.statut AS statut_18, t0.roles AS roles_19, t0.password AS password_20, t0.indicateur AS indicateur_21, t0.createur AS createur_22, t0.pays_id AS pays_id_23, t0.niveau_simple_id AS niveau_simple_id_24, t0.niveau_double_id AS niveau_double_id_25, t0.niveau_mixte_id AS niveau_mixte_id_26 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  5748
]

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\User 18
App\Entity\UserSelection 17
App\Entity\Payment 17
App\Entity\EquipeUser 8
App\Entity\Equipe 4
App\Entity\Niveau 3
App\Entity\Evenement 1
App\Entity\Config 1
App\Entity\Style 1
App\Entity\Selection 1
App\Entity\Epreuve 1
App\Entity\Age 1

Entities Mapping

Class Mapping errors
App\Entity\Evenement No errors.
App\Entity\Config No errors.
App\Entity\User No errors.
App\Entity\Style No errors.
App\Entity\Photo No errors.
App\Entity\EvenementInformation No errors.
App\Entity\Playoff
  • The field App\Entity\Playoff#participants is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PlayoffParticipant#playoff does not contain the required 'inversedBy="participants"' attribute.
App\Entity\UserSelection
  • The field 'App\Entity\UserSelection#montantPaye' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Selection
  • The field 'App\Entity\Selection#prix' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Payment
  • The field 'App\Entity\Payment#montantTotal' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Payment#montantEpreuves' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Payment#montantRepas' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Payment#montantReduction' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Equipe No errors.
App\Entity\EquipeUser No errors.
App\Entity\Pays No errors.
App\Entity\Niveau No errors.
App\Entity\Epreuve No errors.
App\Entity\Age No errors.
App\Entity\Forme No errors.
App\Entity\Invitation No errors.