GET https://demofft.tournoipickleball.fr/joueurs?page=46

Query Metrics

36 Database Queries
7 Different statements
99.83 ms Query time
0 Invalid entities
35 Managed entities

Queries

Group similar statements

# Time Info
1 3.11 ms
SELECT u0_.id AS id_0, u0_.public_id AS public_id_1, u0_.email AS email_2, u0_.pseudo AS pseudo_3, u0_.licence AS licence_4, u0_.id_dupr AS id_dupr_5, u0_.genre AS genre_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_de_naissance AS date_de_naissance_9, u0_.ville AS ville_10, u0_.description AS description_11, u0_.telephone AS telephone_12, u0_.instagram AS instagram_13, u0_.linkedin AS linkedin_14, u0_.tiktok AS tiktok_15, u0_.twitter AS twitter_16, u0_.facebook AS facebook_17, u0_.statut AS statut_18, u0_.roles AS roles_19, u0_.password AS password_20, u0_.indicateur AS indicateur_21, u0_.createur AS createur_22, u0_.stripe_account_id AS stripe_account_id_23, u0_.stripe_onboarding_complete AS stripe_onboarding_complete_24, u0_.stripe_account_created_at AS stripe_account_created_at_25, u0_.stripe_account_type AS stripe_account_type_26, u0_.is_admin AS is_admin_27, u0_.commission_defaut AS commission_defaut_28, u0_.dupr_user_token AS dupr_user_token_29, u0_.dupr_refresh_token AS dupr_refresh_token_30, u0_.dupr_token_expires_at AS dupr_token_expires_at_31, u0_.dupr_sso_connected_at AS dupr_sso_connected_at_32, u0_.dupr_rating_singles AS dupr_rating_singles_33, u0_.dupr_rating_doubles AS dupr_rating_doubles_34, u0_.dupr_ratings_updated_at AS dupr_ratings_updated_at_35, u0_.dupr_basic_entitlement AS dupr_basic_entitlement_36, u0_.dupr_entitlement_checked_at AS dupr_entitlement_checked_at_37, u0_.newsletter_consent AS newsletter_consent_38, u0_.newsletter_consent_date AS newsletter_consent_date_39, u0_.traitement_limite AS traitement_limite_40, u0_.traitement_limite_date AS traitement_limite_date_41, u0_.traitement_limite_motif AS traitement_limite_motif_42, u0_.pays_id AS pays_id_43, u0_.niveau_simple_id AS niveau_simple_id_44, u0_.niveau_double_id AS niveau_double_id_45, u0_.niveau_mixte_id AS niveau_mixte_id_46 FROM `user` u0_ WHERE u0_.traitement_limite = 0 LIMIT 10 OFFSET 450
Parameters:
[]
2 1.54 ms
SELECT COUNT(u0_.id) AS sclr_0 FROM `user` u0_ WHERE u0_.traitement_limite = 0
Parameters:
[]
3 1.24 ms
SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE c0_.licence IN (?, ?, ?, ?) ORDER BY c1_.date_import DESC, c0_.total_points DESC
Parameters:
[
  "4099627R"
  "4099627 R"
  "4099627r"
  "4099627 r"
]
4 0.36 ms
SELECT t0.id AS id_1, t0.categorie AS categorie_2, t0.date_import AS date_import_3, t0.nom_fichier AS nom_fichier_4, t0.chemin_fichier AS chemin_fichier_5, t0.nombre_joueurs AS nombre_joueurs_6, t0.erreurs AS erreurs_7 FROM classement_fft_import t0 WHERE t0.id = ?
Parameters:
[
  5
]
5 0.31 ms
SELECT t0.id AS id_1, t0.categorie AS categorie_2, t0.date_import AS date_import_3, t0.nom_fichier AS nom_fichier_4, t0.chemin_fichier AS chemin_fichier_5, t0.nombre_joueurs AS nombre_joueurs_6, t0.erreurs AS erreurs_7 FROM classement_fft_import t0 WHERE t0.id = ?
Parameters:
[
  3
]
6 0.28 ms
SELECT t0.id AS id_1, t0.categorie AS categorie_2, t0.date_import AS date_import_3, t0.nom_fichier AS nom_fichier_4, t0.chemin_fichier AS chemin_fichier_5, t0.nombre_joueurs AS nombre_joueurs_6, t0.erreurs AS erreurs_7 FROM classement_fft_import t0 WHERE t0.id = ?
Parameters:
[
  1
]
7 5.05 ms
SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE UPPER(TRIM(c0_.nom)) = ? AND UPPER(TRIM(c0_.prenom)) = ? ORDER BY c1_.date_import DESC, c0_.total_points DESC
Parameters:
[
  "CUGLIARI"
  "MATTEO"
]
8 0.83 ms
SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE c0_.licence IN (?, ?, ?, ?) ORDER BY c1_.date_import DESC, c0_.total_points DESC
Parameters:
[
  "4089117S"
  "4089117 S"
  "4089117s"
  "4089117 s"
]
9 5.20 ms
SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE UPPER(TRIM(c0_.nom)) = ? AND UPPER(TRIM(c0_.prenom)) = ? ORDER BY c1_.date_import DESC, c0_.total_points DESC
Parameters:
[
  "DYE"
  "JOSH"
]
10 0.77 ms
SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE c0_.licence IN (?, ?, ?, ?) ORDER BY c1_.date_import DESC, c0_.total_points DESC
Parameters:
[
  "4100972C"
  "4100972 C"
  "4100972c"
  "4100972 c"
]
11 5.04 ms
SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE UPPER(TRIM(c0_.nom)) = ? AND UPPER(TRIM(c0_.prenom)) = ? ORDER BY c1_.date_import DESC, c0_.total_points DESC
Parameters:
[
  "ENES DEBIK"
  "MUSTAFA"
]
12 1.16 ms
SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE c0_.licence IN (?, ?, ?, ?) ORDER BY c1_.date_import DESC, c0_.total_points DESC
Parameters:
[
  "4002151N"
  "4002151 N"
  "4002151n"
  "4002151 n"
]
13 8.80 ms
SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE UPPER(TRIM(c0_.nom)) = ? AND UPPER(TRIM(c0_.prenom)) = ? ORDER BY c1_.date_import DESC, c0_.total_points DESC
Parameters:
[
  "ZIJLMANS"
  "TIM"
]
14 1.19 ms
SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE c0_.licence IN (?, ?, ?, ?) ORDER BY c1_.date_import DESC, c0_.total_points DESC
Parameters:
[
  "4135840C"
  "4135840 C"
  "4135840c"
  "4135840 c"
]
15 10.31 ms
SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE UPPER(TRIM(c0_.nom)) = ? AND UPPER(TRIM(c0_.prenom)) = ? ORDER BY c1_.date_import DESC, c0_.total_points DESC
Parameters:
[
  "GERGO BAKO"
  "BÁLINT"
]
16 1.00 ms
SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE c0_.licence IN (?, ?, ?, ?) ORDER BY c1_.date_import DESC, c0_.total_points DESC
Parameters:
[
  "4100690W"
  "4100690 W"
  "4100690w"
  "4100690 w"
]
17 7.97 ms
SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE UPPER(TRIM(c0_.nom)) = ? AND UPPER(TRIM(c0_.prenom)) = ? ORDER BY c1_.date_import DESC, c0_.total_points DESC
Parameters:
[
  "LUCAS"
  "STEPHEN"
]
18 1.11 ms
SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE c0_.licence IN (?, ?, ?, ?) ORDER BY c1_.date_import DESC, c0_.total_points DESC
Parameters:
[
  "4135839B"
  "4135839 B"
  "4135839b"
  "4135839 b"
]
19 7.60 ms
SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE UPPER(TRIM(c0_.nom)) = ? AND UPPER(TRIM(c0_.prenom)) = ? ORDER BY c1_.date_import DESC, c0_.total_points DESC
Parameters:
[
  "KASZONI"
  "KRISZTIAN"
]
20 0.92 ms
SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE c0_.licence IN (?, ?, ?, ?) ORDER BY c1_.date_import DESC, c0_.total_points DESC
Parameters:
[
  "4140857F"
  "4140857 F"
  "4140857f"
  "4140857 f"
]
21 7.29 ms
SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE UPPER(TRIM(c0_.nom)) = ? AND UPPER(TRIM(c0_.prenom)) = ? ORDER BY c1_.date_import DESC, c0_.total_points DESC
Parameters:
[
  "GARCIA"
  "MAURO"
]
22 1.06 ms
SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE c0_.licence IN (?, ?, ?, ?) ORDER BY c1_.date_import DESC, c0_.total_points DESC
Parameters:
[
  "4004164B"
  "4004164 B"
  "4004164b"
  "4004164 b"
]
23 7.54 ms
SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE UPPER(TRIM(c0_.nom)) = ? AND UPPER(TRIM(c0_.prenom)) = ? ORDER BY c1_.date_import DESC, c0_.total_points DESC
Parameters:
[
  "CORFIELD"
  "TOM"
]
24 1.00 ms
SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE c0_.licence IN (?, ?, ?, ?) ORDER BY c1_.date_import DESC, c0_.total_points DESC
Parameters:
[
  "4089130F"
  "4089130 F"
  "4089130f"
  "4089130 f"
]
25 7.15 ms
SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE UPPER(TRIM(c0_.nom)) = ? AND UPPER(TRIM(c0_.prenom)) = ? ORDER BY c1_.date_import DESC, c0_.total_points DESC
Parameters:
[
  "THOMPSON"
  "TONY"
]
26 1.53 ms
SELECT u0_.id AS id_0, u0_.public_id AS public_id_1, u0_.email AS email_2, u0_.pseudo AS pseudo_3, u0_.licence AS licence_4, u0_.id_dupr AS id_dupr_5, u0_.genre AS genre_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_de_naissance AS date_de_naissance_9, u0_.ville AS ville_10, u0_.description AS description_11, u0_.telephone AS telephone_12, u0_.instagram AS instagram_13, u0_.linkedin AS linkedin_14, u0_.tiktok AS tiktok_15, u0_.twitter AS twitter_16, u0_.facebook AS facebook_17, u0_.statut AS statut_18, u0_.roles AS roles_19, u0_.password AS password_20, u0_.indicateur AS indicateur_21, u0_.createur AS createur_22, u0_.stripe_account_id AS stripe_account_id_23, u0_.stripe_onboarding_complete AS stripe_onboarding_complete_24, u0_.stripe_account_created_at AS stripe_account_created_at_25, u0_.stripe_account_type AS stripe_account_type_26, u0_.is_admin AS is_admin_27, u0_.commission_defaut AS commission_defaut_28, u0_.dupr_user_token AS dupr_user_token_29, u0_.dupr_refresh_token AS dupr_refresh_token_30, u0_.dupr_token_expires_at AS dupr_token_expires_at_31, u0_.dupr_sso_connected_at AS dupr_sso_connected_at_32, u0_.dupr_rating_singles AS dupr_rating_singles_33, u0_.dupr_rating_doubles AS dupr_rating_doubles_34, u0_.dupr_ratings_updated_at AS dupr_ratings_updated_at_35, u0_.dupr_basic_entitlement AS dupr_basic_entitlement_36, u0_.dupr_entitlement_checked_at AS dupr_entitlement_checked_at_37, u0_.newsletter_consent AS newsletter_consent_38, u0_.newsletter_consent_date AS newsletter_consent_date_39, u0_.traitement_limite AS traitement_limite_40, u0_.traitement_limite_date AS traitement_limite_date_41, u0_.traitement_limite_motif AS traitement_limite_motif_42, u0_.pays_id AS pays_id_43, u0_.niveau_simple_id AS niveau_simple_id_44, u0_.niveau_double_id AS niveau_double_id_45, u0_.niveau_mixte_id AS niveau_mixte_id_46 FROM `user` u0_ WHERE u0_.public_id = ?
Parameters:
[
  "b2e884f3-342d-11f1-ae32-fa163e19c1c5"
]
27 1.08 ms
SELECT u0_.id AS id_0, u0_.public_id AS public_id_1, u0_.email AS email_2, u0_.pseudo AS pseudo_3, u0_.licence AS licence_4, u0_.id_dupr AS id_dupr_5, u0_.genre AS genre_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_de_naissance AS date_de_naissance_9, u0_.ville AS ville_10, u0_.description AS description_11, u0_.telephone AS telephone_12, u0_.instagram AS instagram_13, u0_.linkedin AS linkedin_14, u0_.tiktok AS tiktok_15, u0_.twitter AS twitter_16, u0_.facebook AS facebook_17, u0_.statut AS statut_18, u0_.roles AS roles_19, u0_.password AS password_20, u0_.indicateur AS indicateur_21, u0_.createur AS createur_22, u0_.stripe_account_id AS stripe_account_id_23, u0_.stripe_onboarding_complete AS stripe_onboarding_complete_24, u0_.stripe_account_created_at AS stripe_account_created_at_25, u0_.stripe_account_type AS stripe_account_type_26, u0_.is_admin AS is_admin_27, u0_.commission_defaut AS commission_defaut_28, u0_.dupr_user_token AS dupr_user_token_29, u0_.dupr_refresh_token AS dupr_refresh_token_30, u0_.dupr_token_expires_at AS dupr_token_expires_at_31, u0_.dupr_sso_connected_at AS dupr_sso_connected_at_32, u0_.dupr_rating_singles AS dupr_rating_singles_33, u0_.dupr_rating_doubles AS dupr_rating_doubles_34, u0_.dupr_ratings_updated_at AS dupr_ratings_updated_at_35, u0_.dupr_basic_entitlement AS dupr_basic_entitlement_36, u0_.dupr_entitlement_checked_at AS dupr_entitlement_checked_at_37, u0_.newsletter_consent AS newsletter_consent_38, u0_.newsletter_consent_date AS newsletter_consent_date_39, u0_.traitement_limite AS traitement_limite_40, u0_.traitement_limite_date AS traitement_limite_date_41, u0_.traitement_limite_motif AS traitement_limite_motif_42, u0_.pays_id AS pays_id_43, u0_.niveau_simple_id AS niveau_simple_id_44, u0_.niveau_double_id AS niveau_double_id_45, u0_.niveau_mixte_id AS niveau_mixte_id_46 FROM `user` u0_ WHERE u0_.public_id = ?
Parameters:
[
  "b2e8860d-342d-11f1-ae32-fa163e19c1c5"
]
28 1.06 ms
SELECT u0_.id AS id_0, u0_.public_id AS public_id_1, u0_.email AS email_2, u0_.pseudo AS pseudo_3, u0_.licence AS licence_4, u0_.id_dupr AS id_dupr_5, u0_.genre AS genre_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_de_naissance AS date_de_naissance_9, u0_.ville AS ville_10, u0_.description AS description_11, u0_.telephone AS telephone_12, u0_.instagram AS instagram_13, u0_.linkedin AS linkedin_14, u0_.tiktok AS tiktok_15, u0_.twitter AS twitter_16, u0_.facebook AS facebook_17, u0_.statut AS statut_18, u0_.roles AS roles_19, u0_.password AS password_20, u0_.indicateur AS indicateur_21, u0_.createur AS createur_22, u0_.stripe_account_id AS stripe_account_id_23, u0_.stripe_onboarding_complete AS stripe_onboarding_complete_24, u0_.stripe_account_created_at AS stripe_account_created_at_25, u0_.stripe_account_type AS stripe_account_type_26, u0_.is_admin AS is_admin_27, u0_.commission_defaut AS commission_defaut_28, u0_.dupr_user_token AS dupr_user_token_29, u0_.dupr_refresh_token AS dupr_refresh_token_30, u0_.dupr_token_expires_at AS dupr_token_expires_at_31, u0_.dupr_sso_connected_at AS dupr_sso_connected_at_32, u0_.dupr_rating_singles AS dupr_rating_singles_33, u0_.dupr_rating_doubles AS dupr_rating_doubles_34, u0_.dupr_ratings_updated_at AS dupr_ratings_updated_at_35, u0_.dupr_basic_entitlement AS dupr_basic_entitlement_36, u0_.dupr_entitlement_checked_at AS dupr_entitlement_checked_at_37, u0_.newsletter_consent AS newsletter_consent_38, u0_.newsletter_consent_date AS newsletter_consent_date_39, u0_.traitement_limite AS traitement_limite_40, u0_.traitement_limite_date AS traitement_limite_date_41, u0_.traitement_limite_motif AS traitement_limite_motif_42, u0_.pays_id AS pays_id_43, u0_.niveau_simple_id AS niveau_simple_id_44, u0_.niveau_double_id AS niveau_double_id_45, u0_.niveau_mixte_id AS niveau_mixte_id_46 FROM `user` u0_ WHERE u0_.public_id = ?
Parameters:
[
  "b2e88741-342d-11f1-ae32-fa163e19c1c5"
]
29 1.06 ms
SELECT u0_.id AS id_0, u0_.public_id AS public_id_1, u0_.email AS email_2, u0_.pseudo AS pseudo_3, u0_.licence AS licence_4, u0_.id_dupr AS id_dupr_5, u0_.genre AS genre_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_de_naissance AS date_de_naissance_9, u0_.ville AS ville_10, u0_.description AS description_11, u0_.telephone AS telephone_12, u0_.instagram AS instagram_13, u0_.linkedin AS linkedin_14, u0_.tiktok AS tiktok_15, u0_.twitter AS twitter_16, u0_.facebook AS facebook_17, u0_.statut AS statut_18, u0_.roles AS roles_19, u0_.password AS password_20, u0_.indicateur AS indicateur_21, u0_.createur AS createur_22, u0_.stripe_account_id AS stripe_account_id_23, u0_.stripe_onboarding_complete AS stripe_onboarding_complete_24, u0_.stripe_account_created_at AS stripe_account_created_at_25, u0_.stripe_account_type AS stripe_account_type_26, u0_.is_admin AS is_admin_27, u0_.commission_defaut AS commission_defaut_28, u0_.dupr_user_token AS dupr_user_token_29, u0_.dupr_refresh_token AS dupr_refresh_token_30, u0_.dupr_token_expires_at AS dupr_token_expires_at_31, u0_.dupr_sso_connected_at AS dupr_sso_connected_at_32, u0_.dupr_rating_singles AS dupr_rating_singles_33, u0_.dupr_rating_doubles AS dupr_rating_doubles_34, u0_.dupr_ratings_updated_at AS dupr_ratings_updated_at_35, u0_.dupr_basic_entitlement AS dupr_basic_entitlement_36, u0_.dupr_entitlement_checked_at AS dupr_entitlement_checked_at_37, u0_.newsletter_consent AS newsletter_consent_38, u0_.newsletter_consent_date AS newsletter_consent_date_39, u0_.traitement_limite AS traitement_limite_40, u0_.traitement_limite_date AS traitement_limite_date_41, u0_.traitement_limite_motif AS traitement_limite_motif_42, u0_.pays_id AS pays_id_43, u0_.niveau_simple_id AS niveau_simple_id_44, u0_.niveau_double_id AS niveau_double_id_45, u0_.niveau_mixte_id AS niveau_mixte_id_46 FROM `user` u0_ WHERE u0_.public_id = ?
Parameters:
[
  "b2e88847-342d-11f1-ae32-fa163e19c1c5"
]
30 1.08 ms
SELECT u0_.id AS id_0, u0_.public_id AS public_id_1, u0_.email AS email_2, u0_.pseudo AS pseudo_3, u0_.licence AS licence_4, u0_.id_dupr AS id_dupr_5, u0_.genre AS genre_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_de_naissance AS date_de_naissance_9, u0_.ville AS ville_10, u0_.description AS description_11, u0_.telephone AS telephone_12, u0_.instagram AS instagram_13, u0_.linkedin AS linkedin_14, u0_.tiktok AS tiktok_15, u0_.twitter AS twitter_16, u0_.facebook AS facebook_17, u0_.statut AS statut_18, u0_.roles AS roles_19, u0_.password AS password_20, u0_.indicateur AS indicateur_21, u0_.createur AS createur_22, u0_.stripe_account_id AS stripe_account_id_23, u0_.stripe_onboarding_complete AS stripe_onboarding_complete_24, u0_.stripe_account_created_at AS stripe_account_created_at_25, u0_.stripe_account_type AS stripe_account_type_26, u0_.is_admin AS is_admin_27, u0_.commission_defaut AS commission_defaut_28, u0_.dupr_user_token AS dupr_user_token_29, u0_.dupr_refresh_token AS dupr_refresh_token_30, u0_.dupr_token_expires_at AS dupr_token_expires_at_31, u0_.dupr_sso_connected_at AS dupr_sso_connected_at_32, u0_.dupr_rating_singles AS dupr_rating_singles_33, u0_.dupr_rating_doubles AS dupr_rating_doubles_34, u0_.dupr_ratings_updated_at AS dupr_ratings_updated_at_35, u0_.dupr_basic_entitlement AS dupr_basic_entitlement_36, u0_.dupr_entitlement_checked_at AS dupr_entitlement_checked_at_37, u0_.newsletter_consent AS newsletter_consent_38, u0_.newsletter_consent_date AS newsletter_consent_date_39, u0_.traitement_limite AS traitement_limite_40, u0_.traitement_limite_date AS traitement_limite_date_41, u0_.traitement_limite_motif AS traitement_limite_motif_42, u0_.pays_id AS pays_id_43, u0_.niveau_simple_id AS niveau_simple_id_44, u0_.niveau_double_id AS niveau_double_id_45, u0_.niveau_mixte_id AS niveau_mixte_id_46 FROM `user` u0_ WHERE u0_.public_id = ?
Parameters:
[
  "b2e8893f-342d-11f1-ae32-fa163e19c1c5"
]
31 1.08 ms
SELECT u0_.id AS id_0, u0_.public_id AS public_id_1, u0_.email AS email_2, u0_.pseudo AS pseudo_3, u0_.licence AS licence_4, u0_.id_dupr AS id_dupr_5, u0_.genre AS genre_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_de_naissance AS date_de_naissance_9, u0_.ville AS ville_10, u0_.description AS description_11, u0_.telephone AS telephone_12, u0_.instagram AS instagram_13, u0_.linkedin AS linkedin_14, u0_.tiktok AS tiktok_15, u0_.twitter AS twitter_16, u0_.facebook AS facebook_17, u0_.statut AS statut_18, u0_.roles AS roles_19, u0_.password AS password_20, u0_.indicateur AS indicateur_21, u0_.createur AS createur_22, u0_.stripe_account_id AS stripe_account_id_23, u0_.stripe_onboarding_complete AS stripe_onboarding_complete_24, u0_.stripe_account_created_at AS stripe_account_created_at_25, u0_.stripe_account_type AS stripe_account_type_26, u0_.is_admin AS is_admin_27, u0_.commission_defaut AS commission_defaut_28, u0_.dupr_user_token AS dupr_user_token_29, u0_.dupr_refresh_token AS dupr_refresh_token_30, u0_.dupr_token_expires_at AS dupr_token_expires_at_31, u0_.dupr_sso_connected_at AS dupr_sso_connected_at_32, u0_.dupr_rating_singles AS dupr_rating_singles_33, u0_.dupr_rating_doubles AS dupr_rating_doubles_34, u0_.dupr_ratings_updated_at AS dupr_ratings_updated_at_35, u0_.dupr_basic_entitlement AS dupr_basic_entitlement_36, u0_.dupr_entitlement_checked_at AS dupr_entitlement_checked_at_37, u0_.newsletter_consent AS newsletter_consent_38, u0_.newsletter_consent_date AS newsletter_consent_date_39, u0_.traitement_limite AS traitement_limite_40, u0_.traitement_limite_date AS traitement_limite_date_41, u0_.traitement_limite_motif AS traitement_limite_motif_42, u0_.pays_id AS pays_id_43, u0_.niveau_simple_id AS niveau_simple_id_44, u0_.niveau_double_id AS niveau_double_id_45, u0_.niveau_mixte_id AS niveau_mixte_id_46 FROM `user` u0_ WHERE u0_.public_id = ?
Parameters:
[
  "b2e88f7c-342d-11f1-ae32-fa163e19c1c5"
]
32 1.08 ms
SELECT u0_.id AS id_0, u0_.public_id AS public_id_1, u0_.email AS email_2, u0_.pseudo AS pseudo_3, u0_.licence AS licence_4, u0_.id_dupr AS id_dupr_5, u0_.genre AS genre_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_de_naissance AS date_de_naissance_9, u0_.ville AS ville_10, u0_.description AS description_11, u0_.telephone AS telephone_12, u0_.instagram AS instagram_13, u0_.linkedin AS linkedin_14, u0_.tiktok AS tiktok_15, u0_.twitter AS twitter_16, u0_.facebook AS facebook_17, u0_.statut AS statut_18, u0_.roles AS roles_19, u0_.password AS password_20, u0_.indicateur AS indicateur_21, u0_.createur AS createur_22, u0_.stripe_account_id AS stripe_account_id_23, u0_.stripe_onboarding_complete AS stripe_onboarding_complete_24, u0_.stripe_account_created_at AS stripe_account_created_at_25, u0_.stripe_account_type AS stripe_account_type_26, u0_.is_admin AS is_admin_27, u0_.commission_defaut AS commission_defaut_28, u0_.dupr_user_token AS dupr_user_token_29, u0_.dupr_refresh_token AS dupr_refresh_token_30, u0_.dupr_token_expires_at AS dupr_token_expires_at_31, u0_.dupr_sso_connected_at AS dupr_sso_connected_at_32, u0_.dupr_rating_singles AS dupr_rating_singles_33, u0_.dupr_rating_doubles AS dupr_rating_doubles_34, u0_.dupr_ratings_updated_at AS dupr_ratings_updated_at_35, u0_.dupr_basic_entitlement AS dupr_basic_entitlement_36, u0_.dupr_entitlement_checked_at AS dupr_entitlement_checked_at_37, u0_.newsletter_consent AS newsletter_consent_38, u0_.newsletter_consent_date AS newsletter_consent_date_39, u0_.traitement_limite AS traitement_limite_40, u0_.traitement_limite_date AS traitement_limite_date_41, u0_.traitement_limite_motif AS traitement_limite_motif_42, u0_.pays_id AS pays_id_43, u0_.niveau_simple_id AS niveau_simple_id_44, u0_.niveau_double_id AS niveau_double_id_45, u0_.niveau_mixte_id AS niveau_mixte_id_46 FROM `user` u0_ WHERE u0_.public_id = ?
Parameters:
[
  "b2e8921c-342d-11f1-ae32-fa163e19c1c5"
]
33 1.07 ms
SELECT u0_.id AS id_0, u0_.public_id AS public_id_1, u0_.email AS email_2, u0_.pseudo AS pseudo_3, u0_.licence AS licence_4, u0_.id_dupr AS id_dupr_5, u0_.genre AS genre_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_de_naissance AS date_de_naissance_9, u0_.ville AS ville_10, u0_.description AS description_11, u0_.telephone AS telephone_12, u0_.instagram AS instagram_13, u0_.linkedin AS linkedin_14, u0_.tiktok AS tiktok_15, u0_.twitter AS twitter_16, u0_.facebook AS facebook_17, u0_.statut AS statut_18, u0_.roles AS roles_19, u0_.password AS password_20, u0_.indicateur AS indicateur_21, u0_.createur AS createur_22, u0_.stripe_account_id AS stripe_account_id_23, u0_.stripe_onboarding_complete AS stripe_onboarding_complete_24, u0_.stripe_account_created_at AS stripe_account_created_at_25, u0_.stripe_account_type AS stripe_account_type_26, u0_.is_admin AS is_admin_27, u0_.commission_defaut AS commission_defaut_28, u0_.dupr_user_token AS dupr_user_token_29, u0_.dupr_refresh_token AS dupr_refresh_token_30, u0_.dupr_token_expires_at AS dupr_token_expires_at_31, u0_.dupr_sso_connected_at AS dupr_sso_connected_at_32, u0_.dupr_rating_singles AS dupr_rating_singles_33, u0_.dupr_rating_doubles AS dupr_rating_doubles_34, u0_.dupr_ratings_updated_at AS dupr_ratings_updated_at_35, u0_.dupr_basic_entitlement AS dupr_basic_entitlement_36, u0_.dupr_entitlement_checked_at AS dupr_entitlement_checked_at_37, u0_.newsletter_consent AS newsletter_consent_38, u0_.newsletter_consent_date AS newsletter_consent_date_39, u0_.traitement_limite AS traitement_limite_40, u0_.traitement_limite_date AS traitement_limite_date_41, u0_.traitement_limite_motif AS traitement_limite_motif_42, u0_.pays_id AS pays_id_43, u0_.niveau_simple_id AS niveau_simple_id_44, u0_.niveau_double_id AS niveau_double_id_45, u0_.niveau_mixte_id AS niveau_mixte_id_46 FROM `user` u0_ WHERE u0_.public_id = ?
Parameters:
[
  "b2e8941e-342d-11f1-ae32-fa163e19c1c5"
]
34 1.00 ms
SELECT u0_.id AS id_0, u0_.public_id AS public_id_1, u0_.email AS email_2, u0_.pseudo AS pseudo_3, u0_.licence AS licence_4, u0_.id_dupr AS id_dupr_5, u0_.genre AS genre_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_de_naissance AS date_de_naissance_9, u0_.ville AS ville_10, u0_.description AS description_11, u0_.telephone AS telephone_12, u0_.instagram AS instagram_13, u0_.linkedin AS linkedin_14, u0_.tiktok AS tiktok_15, u0_.twitter AS twitter_16, u0_.facebook AS facebook_17, u0_.statut AS statut_18, u0_.roles AS roles_19, u0_.password AS password_20, u0_.indicateur AS indicateur_21, u0_.createur AS createur_22, u0_.stripe_account_id AS stripe_account_id_23, u0_.stripe_onboarding_complete AS stripe_onboarding_complete_24, u0_.stripe_account_created_at AS stripe_account_created_at_25, u0_.stripe_account_type AS stripe_account_type_26, u0_.is_admin AS is_admin_27, u0_.commission_defaut AS commission_defaut_28, u0_.dupr_user_token AS dupr_user_token_29, u0_.dupr_refresh_token AS dupr_refresh_token_30, u0_.dupr_token_expires_at AS dupr_token_expires_at_31, u0_.dupr_sso_connected_at AS dupr_sso_connected_at_32, u0_.dupr_rating_singles AS dupr_rating_singles_33, u0_.dupr_rating_doubles AS dupr_rating_doubles_34, u0_.dupr_ratings_updated_at AS dupr_ratings_updated_at_35, u0_.dupr_basic_entitlement AS dupr_basic_entitlement_36, u0_.dupr_entitlement_checked_at AS dupr_entitlement_checked_at_37, u0_.newsletter_consent AS newsletter_consent_38, u0_.newsletter_consent_date AS newsletter_consent_date_39, u0_.traitement_limite AS traitement_limite_40, u0_.traitement_limite_date AS traitement_limite_date_41, u0_.traitement_limite_motif AS traitement_limite_motif_42, u0_.pays_id AS pays_id_43, u0_.niveau_simple_id AS niveau_simple_id_44, u0_.niveau_double_id AS niveau_double_id_45, u0_.niveau_mixte_id AS niveau_mixte_id_46 FROM `user` u0_ WHERE u0_.public_id = ?
Parameters:
[
  "b2e89601-342d-11f1-ae32-fa163e19c1c5"
]
35 1.05 ms
SELECT u0_.id AS id_0, u0_.public_id AS public_id_1, u0_.email AS email_2, u0_.pseudo AS pseudo_3, u0_.licence AS licence_4, u0_.id_dupr AS id_dupr_5, u0_.genre AS genre_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_de_naissance AS date_de_naissance_9, u0_.ville AS ville_10, u0_.description AS description_11, u0_.telephone AS telephone_12, u0_.instagram AS instagram_13, u0_.linkedin AS linkedin_14, u0_.tiktok AS tiktok_15, u0_.twitter AS twitter_16, u0_.facebook AS facebook_17, u0_.statut AS statut_18, u0_.roles AS roles_19, u0_.password AS password_20, u0_.indicateur AS indicateur_21, u0_.createur AS createur_22, u0_.stripe_account_id AS stripe_account_id_23, u0_.stripe_onboarding_complete AS stripe_onboarding_complete_24, u0_.stripe_account_created_at AS stripe_account_created_at_25, u0_.stripe_account_type AS stripe_account_type_26, u0_.is_admin AS is_admin_27, u0_.commission_defaut AS commission_defaut_28, u0_.dupr_user_token AS dupr_user_token_29, u0_.dupr_refresh_token AS dupr_refresh_token_30, u0_.dupr_token_expires_at AS dupr_token_expires_at_31, u0_.dupr_sso_connected_at AS dupr_sso_connected_at_32, u0_.dupr_rating_singles AS dupr_rating_singles_33, u0_.dupr_rating_doubles AS dupr_rating_doubles_34, u0_.dupr_ratings_updated_at AS dupr_ratings_updated_at_35, u0_.dupr_basic_entitlement AS dupr_basic_entitlement_36, u0_.dupr_entitlement_checked_at AS dupr_entitlement_checked_at_37, u0_.newsletter_consent AS newsletter_consent_38, u0_.newsletter_consent_date AS newsletter_consent_date_39, u0_.traitement_limite AS traitement_limite_40, u0_.traitement_limite_date AS traitement_limite_date_41, u0_.traitement_limite_motif AS traitement_limite_motif_42, u0_.pays_id AS pays_id_43, u0_.niveau_simple_id AS niveau_simple_id_44, u0_.niveau_double_id AS niveau_double_id_45, u0_.niveau_mixte_id AS niveau_mixte_id_46 FROM `user` u0_ WHERE u0_.public_id = ?
Parameters:
[
  "b2e89c6c-342d-11f1-ae32-fa163e19c1c5"
]
36 0.89 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\ClassementFftJoueur 22
App\Entity\User 10
App\Entity\ClassementFftImport 3

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Pays No errors.
App\Entity\Niveau No errors.
App\Entity\UserSelection No errors.
App\Entity\Payment No errors.
App\Entity\ClassementFftJoueur No errors.
App\Entity\ClassementFftImport No errors.
App\Entity\Avis No errors.