Symfony Profiler

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

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)) = 'LEGENDRE' AND UPPER(TRIM(c0_.prenom)) = 'OLIVIER' ORDER BY c1_.date_import DESC, c0_.total_points DESC;

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 = ?

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 = '1c92804a-97d6-4656-a55e-782e240988e9';

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

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 ('4536748X', '4536748 X', '4536748x', '4536748 x') ORDER BY c1_.date_import DESC, c0_.total_points DESC;

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
  900

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 900;

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 = ?

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 = 3;

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  `user` u0_
WHERE
  u0_.traitement_limite = 0

SELECT COUNT(u0_.id) AS sclr_0 FROM `user` u0_ WHERE u0_.traitement_limite = 0;

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 = ?

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 = 'valide';