Query Metrics
39
Database Queries
7
Different statements
120.79 ms
Query time
0
Invalid entities
34
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 4.66 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 710
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 2 | 1.33 ms |
SELECT COUNT(u0_.id) AS sclr_0 FROM `user` u0_ WHERE u0_.traitement_limite = 0
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 3 | 1.33 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:
[ "4316891X" "4316891 X" "4316891x" "4316891 x" ]
|
||||||||||||||||||||||||||||||
| 4 | 0.64 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.58 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.38 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 | 8.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:
[ "CHEVALLIER" "CYRIL" ]
|
||||||||||||||||||||||||||||||
| 8 | 1.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 c0_.licence IN (?, ?, ?, ?) ORDER BY c1_.date_import DESC, c0_.total_points DESC
Parameters:
[ "3771695T" "3771695 T" "3771695t" "3771695 t" ]
|
||||||||||||||||||||||||||||||
| 9 | 8.65 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:
[ "CHLIEH" "MATINE" ]
|
||||||||||||||||||||||||||||||
| 10 | 0.72 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:
[ "4788313M" "4788313 M" "4788313m" "4788313 m" ]
|
||||||||||||||||||||||||||||||
| 11 | 8.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:
[ "ABBOTT" "MEGAN" ]
|
||||||||||||||||||||||||||||||
| 12 | 1.14 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:
[ "3665220J" "3665220 J" "3665220j" "3665220 j" ]
|
||||||||||||||||||||||||||||||
| 13 | 11.91 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:
[ "MEEUS" "BART" ]
|
||||||||||||||||||||||||||||||
| 14 | 1.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 c0_.licence IN (?, ?, ?, ?) ORDER BY c1_.date_import DESC, c0_.total_points DESC
Parameters:
[ "4788635M" "4788635 M" "4788635m" "4788635 m" ]
|
||||||||||||||||||||||||||||||
| 15 | 10.44 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:
[ "SEMO" "YANIV" ]
|
||||||||||||||||||||||||||||||
| 16 | 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:
[ "6829363V" "6829363 V" "6829363v" "6829363 v" ]
|
||||||||||||||||||||||||||||||
| 17 | 8.17 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:
[ "SPY" "SANDRINE" ]
|
||||||||||||||||||||||||||||||
| 18 | 1.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 c0_.licence IN (?, ?, ?, ?) ORDER BY c1_.date_import DESC, c0_.total_points DESC
Parameters:
[ "4791808L" "4791808 L" "4791808l" "4791808 l" ]
|
||||||||||||||||||||||||||||||
| 19 | 8.32 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:
[ "SAVARD" "AUDREY" ]
|
||||||||||||||||||||||||||||||
| 20 | 0.88 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:
[ "4791819Y" "4791819 Y" "4791819y" "4791819 y" ]
|
||||||||||||||||||||||||||||||
| 21 | 7.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 UPPER(TRIM(c0_.nom)) = ? AND UPPER(TRIM(c0_.prenom)) = ? ORDER BY c1_.date_import DESC, c0_.total_points DESC
Parameters:
[ "SAVARD" "ELLIOT" ]
|
||||||||||||||||||||||||||||||
| 22 | 1.02 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:
[ "5691946X" "5691946 X" "5691946x" "5691946 x" ]
|
||||||||||||||||||||||||||||||
| 23 | 0.59 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:
[
6
]
|
||||||||||||||||||||||||||||||
| 24 | 0.70 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:
[
4
]
|
||||||||||||||||||||||||||||||
| 25 | 0.72 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:
[
2
]
|
||||||||||||||||||||||||||||||
| 26 | 8.07 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:
[ "VERNAZ" "VALENTINE" ]
|
||||||||||||||||||||||||||||||
| 27 | 1.23 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:
[ "4459936F" "4459936 F" "4459936f" "4459936 f" ]
|
||||||||||||||||||||||||||||||
| 28 | 7.90 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:
[ "DUQUESNE" "MORGAN" ]
|
||||||||||||||||||||||||||||||
| 29 | 1.29 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:
[
"9c2c16c6-f64c-4a6f-9eb9-421765c424c8"
]
|
||||||||||||||||||||||||||||||
| 30 | 1.09 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:
[
"3c38e7cb-a89f-41d7-8aae-e0341b23f296"
]
|
||||||||||||||||||||||||||||||
| 31 | 1.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_.public_id = ?
Parameters:
[
"91e7aea2-7854-486f-a8d5-c11bb4332b3c"
]
|
||||||||||||||||||||||||||||||
| 32 | 1.34 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:
[
"389243f9-2bb0-470d-a344-35a01a3651d5"
]
|
||||||||||||||||||||||||||||||
| 33 | 1.37 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:
[
"36c6b9d6-6aed-4e18-b090-90dc7abff5a0"
]
|
||||||||||||||||||||||||||||||
| 34 | 1.41 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:
[
"f8ad6be4-4054-4135-aca5-d49bd9e6799b"
]
|
||||||||||||||||||||||||||||||
| 35 | 1.12 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:
[
"11df6981-9ae7-4cd8-a6d4-87c30b4e0331"
]
|
||||||||||||||||||||||||||||||
| 36 | 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:
[
"785f62bf-7f46-4dee-9776-ad26116c3b86"
]
|
||||||||||||||||||||||||||||||
| 37 | 1.12 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:
[
"c238ee73-4d82-468e-8238-9920973ebd28"
]
|
||||||||||||||||||||||||||||||
| 38 | 1.09 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:
[
"5aa9ce0f-3ba2-4dc5-b153-91089918c7e4"
]
|
||||||||||||||||||||||||||||||
| 39 | 0.97 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\User | 10 |
| App\Entity\ClassementFftJoueur | 9 |
| App\Entity\ClassementFftImport | 6 |
| App\Entity\Pays | 5 |
| 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. |