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

Response
200 OK
IP
216.73.217.2
Profiled on
Token
73d997

Query Metrics

29 Database Queries
6 Different statements
115.22 ms Query time
0 Invalid entities
18 Managed entities

Queries

Group similar statements

#▲ Time Info
1 7.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_.traitement_limite = 0 LIMIT 10 OFFSET 880
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2 2.82 ms 
SELECT COUNT(u0_.id) AS sclr_0 FROM `user` u0_ WHERE u0_.traitement_limite = 0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3 10.48 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: 
[
  "STAROPOLI"
  "NANNETTE"
]
View formatted query    View runnable query    Explain query    View query backtrace
4 1.28 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: 
[
  "4847866U"
  "4847866 U"
  "4847866u"
  "4847866 u"
]
View formatted query    View runnable query    Explain query    View query backtrace
5 9.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 UPPER(TRIM(c0_.nom)) = ? AND UPPER(TRIM(c0_.prenom)) = ? ORDER BY c1_.date_import DESC, c0_.total_points DESC
Parameters: 
[
  "HOWES"
  "WENDY"
]
View formatted query    View runnable query    Explain query    View query backtrace
6 1.43 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: 
[
  "4847550A"
  "4847550 A"
  "4847550a"
  "4847550 a"
]
View formatted query    View runnable query    Explain query    View query backtrace
7 8.86 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: 
[
  "BACH"
  "ELLEN"
]
View formatted query    View runnable query    Explain query    View query backtrace
8 1.03 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: 
[
  "4114905X"
  "4114905 X"
  "4114905x"
  "4114905 x"
]
View formatted query    View runnable query    Explain query    View query backtrace
9 10.47 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: 
[
  "KAUR"
  "RUBY"
]
View formatted query    View runnable query    Explain query    View query backtrace
10 9.10 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: 
[
  "JOHNS"
  "LYNN"
]
View formatted query    View runnable query    Explain query    View query backtrace
11 1.47 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: 
[
  "4498758D"
  "4498758 D"
  "4498758d"
  "4498758 d"
]
View formatted query    View runnable query    Explain query    View query backtrace
12 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: 
[
  "DUBOIS"
  "DANIEL"
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.96 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: 
[
  "4498725T"
  "4498725 T"
  "4498725t"
  "4498725 t"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 8.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: 
[
  "PILLONEL"
  "JOSIANE"
]
View formatted query    View runnable query    Explain query    View query backtrace
15 7.42 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: 
[
  "SEVESTRE"
  "NICOLAS"
]
View formatted query    View runnable query    Explain query    View query backtrace
16 7.49 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: 
[
  "SEVESTRE +1"
  "NICOLAS"
]
View formatted query    View runnable query    Explain query    View query backtrace
17 1.01 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: 
[
  "4850862A"
  "4850862 A"
  "4850862a"
  "4850862 a"
]
View formatted query    View runnable query    Explain query    View query backtrace
18 8.28 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: 
[
  "GUARDIA"
  "MICHAEL"
]
View formatted query    View runnable query    Explain query    View query backtrace
19 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: 
[
  "2bdce389-2cf4-4a9d-a5c0-4f2bc3bf5b6d"
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.99 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: 
[
  "c163bc25-cfb5-43e9-99ce-7ddac55f959a"
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.87 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: 
[
  "104b87f4-a736-48ea-9ea6-91d33fff34a8"
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.94 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: 
[
  "a2081428-bf09-4187-be54-60c0e3ac408a"
]
View formatted query    View runnable query    Explain query    View query backtrace
23 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: 
[
  "3a4426c3-6bf9-4775-bef4-ea2446b53265"
]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.95 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: 
[
  "f1ae88eb-d853-4f55-9471-23dd7161fc4d"
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.84 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: 
[
  "8008e82d-97b9-4de2-bc1e-631ac1f97463"
]
View formatted query    View runnable query    Explain query    View query backtrace
26 0.87 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: 
[
  "8c1e33a9-5a97-4e66-b581-98c4777354dc"
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.80 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: 
[
  "8e7bb69e-e118-45a7-97f0-7a917263987c"
]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.98 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: 
[
  "89610ab6-bf97-4695-8af8-61dc10b46660"
]
View formatted query    View runnable query    Explain query    View query backtrace
29 1.39 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"
]
View formatted query    View runnable query    Explain query    View query backtrace

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 10
App\Entity\Pays 4
App\Entity\Niveau 4

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.