Symfony Profiler

SELECT
  t0.id AS id_4,
  t0.email AS email_5,
  t0.roles AS roles_6,
  t0.password AS password_7,
  t0.token_password AS token_password_8,
  t0.token_activate AS token_activate_9,
  t0.nom AS nom_10,
  t0.prenom AS prenom_11,
  t0.created_at AS created_at_12,
  t0.the_statut_id AS the_statut_id_13,
  t0.mobile AS mobile_14,
  t0.reference AS reference_15,
  t0.the_type_id AS the_type_id_16,
  t0.the_role_principal_id AS the_role_principal_id_17,
  t0.photo AS photo_18,
  t0.updated_at AS updated_at_19,
  t0.discr,
  t2.tarif_horaire AS tarif_horaire_20,
  t2.client_id AS client_id_21,
  t3.client_id AS client_id_22,
  t3.bailleur_id AS bailleur_id_23
FROM
  user t0
  LEFT JOIN user_admin t1 ON t0.id = t1.id
  LEFT JOIN user_client t2 ON t0.id = t2.id
  LEFT JOIN user_bailleur t3 ON t0.id = t3.id
WHERE
  t0.id = ?

SELECT t0.id AS id_4, t0.email AS email_5, t0.roles AS roles_6, t0.password AS password_7, t0.token_password AS token_password_8, t0.token_activate AS token_activate_9, t0.nom AS nom_10, t0.prenom AS prenom_11, t0.created_at AS created_at_12, t0.the_statut_id AS the_statut_id_13, t0.mobile AS mobile_14, t0.reference AS reference_15, t0.the_type_id AS the_type_id_16, t0.the_role_principal_id AS the_role_principal_id_17, t0.photo AS photo_18, t0.updated_at AS updated_at_19, t0.discr, t2.tarif_horaire AS tarif_horaire_20, t2.client_id AS client_id_21, t3.client_id AS client_id_22, t3.bailleur_id AS bailleur_id_23 FROM user t0 LEFT JOIN user_admin t1 ON t0.id = t1.id LEFT JOIN user_client t2 ON t0.id = t2.id LEFT JOIN user_bailleur t3 ON t0.id = t3.id WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.raison_sociale AS raison_sociale_3,
  t0.siret AS siret_4,
  t0.reference_index AS reference_index_5,
  t0.telephone AS telephone_6,
  t0.logo AS logo_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.email AS email_10,
  t0.the_statut_id AS the_statut_id_11,
  t0.stripe_customer_id AS stripe_customer_id_12,
  t0.sous_domaine AS sous_domaine_13,
  t0.capital AS capital_14,
  t0.num_tva_intra AS num_tva_intra_15,
  t0.footer_devis AS footer_devis_16,
  t0.secteurs_id AS secteurs_id_17
FROM
  clients t0
ORDER BY
  t0.id DESC
LIMIT
  10

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.raison_sociale AS raison_sociale_3, t0.siret AS siret_4, t0.reference_index AS reference_index_5, t0.telephone AS telephone_6, t0.logo AS logo_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.email AS email_10, t0.the_statut_id AS the_statut_id_11, t0.stripe_customer_id AS stripe_customer_id_12, t0.sous_domaine AS sous_domaine_13, t0.capital AS capital_14, t0.num_tva_intra AS num_tva_intra_15, t0.footer_devis AS footer_devis_16, t0.secteurs_id AS secteurs_id_17 FROM clients t0 ORDER BY t0.id DESC LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.licence_nb AS licence_nb_2,
  t0.prix_licence_ht AS prix_licence_ht_3,
  t0.prix_licence_tva AS prix_licence_tva_4,
  t0.prix_licence_ttc AS prix_licence_ttc_5,
  t0.prix_total_ht AS prix_total_ht_6,
  t0.prix_total_tva AS prix_total_tva_7,
  t0.prix_total_ttc AS prix_total_ttc_8,
  t0.the_paiement_id AS the_paiement_id_9,
  t0.the_statut_id AS the_statut_id_10,
  t0.the_methode_id AS the_methode_id_11,
  t0.date_debut AS date_debut_12,
  t0.date_fin AS date_fin_13,
  t0.code_promo_reduction AS code_promo_reduction_14,
  t0.stripe_subscription_id AS stripe_subscription_id_15,
  t0.stripe_subscription_item_id AS stripe_subscription_item_id_16,
  t0.stripe_plan_id AS stripe_plan_id_17,
  t0.stripe_payment_method_id AS stripe_payment_method_id_18,
  t0.prix_final AS prix_final_19,
  t0.forfait_id AS forfait_id_20,
  t0.client_id AS client_id_21,
  t0.code_promo_id AS code_promo_id_22
FROM
  abonnement t0
WHERE
  t0.the_statut_id = ?
ORDER BY
  t0.date_fin ASC
LIMIT
  10

SELECT t0.id AS id_1, t0.licence_nb AS licence_nb_2, t0.prix_licence_ht AS prix_licence_ht_3, t0.prix_licence_tva AS prix_licence_tva_4, t0.prix_licence_ttc AS prix_licence_ttc_5, t0.prix_total_ht AS prix_total_ht_6, t0.prix_total_tva AS prix_total_tva_7, t0.prix_total_ttc AS prix_total_ttc_8, t0.the_paiement_id AS the_paiement_id_9, t0.the_statut_id AS the_statut_id_10, t0.the_methode_id AS the_methode_id_11, t0.date_debut AS date_debut_12, t0.date_fin AS date_fin_13, t0.code_promo_reduction AS code_promo_reduction_14, t0.stripe_subscription_id AS stripe_subscription_id_15, t0.stripe_subscription_item_id AS stripe_subscription_item_id_16, t0.stripe_plan_id AS stripe_plan_id_17, t0.stripe_payment_method_id AS stripe_payment_method_id_18, t0.prix_final AS prix_final_19, t0.forfait_id AS forfait_id_20, t0.client_id AS client_id_21, t0.code_promo_id AS code_promo_id_22 FROM abonnement t0 WHERE t0.the_statut_id = 1 ORDER BY t0.date_fin ASC LIMIT 10;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  clients c0_
WHERE
  c0_.created_at BETWEEN ?
  AND ?

SELECT COUNT(c0_.id) AS sclr_0 FROM clients c0_ WHERE c0_.created_at BETWEEN '2025-02-01 00:00:00' AND '2025-03-01 00:00:00';

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  user u0_
  LEFT JOIN user_admin u1_ ON u0_.id = u1_.id
  LEFT JOIN user_client u2_ ON u0_.id = u2_.id
  LEFT JOIN user_bailleur u3_ ON u0_.id = u3_.id
WHERE
  u0_.created_at BETWEEN ?
  AND ?

SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ LEFT JOIN user_admin u1_ ON u0_.id = u1_.id LEFT JOIN user_client u2_ ON u0_.id = u2_.id LEFT JOIN user_bailleur u3_ ON u0_.id = u3_.id WHERE u0_.created_at BETWEEN '2025-02-01 00:00:00' AND '2025-03-01 00:00:00';

SELECT
  SUM(p0_.prix_ttc) AS sclr_0
FROM
  paiement p0_
WHERE
  p0_.date_paiement BETWEEN ?
  AND ?

SELECT SUM(p0_.prix_ttc) AS sclr_0 FROM paiement p0_ WHERE p0_.date_paiement BETWEEN '2025-02-01 00:00:00' AND '2025-03-01 00:00:00';

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  clients c0_
WHERE
  c0_.created_at BETWEEN ?
  AND ?

SELECT COUNT(c0_.id) AS sclr_0 FROM clients c0_ WHERE c0_.created_at BETWEEN '2025-03-01 00:00:00' AND '2025-04-01 00:00:00';

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  user u0_
  LEFT JOIN user_admin u1_ ON u0_.id = u1_.id
  LEFT JOIN user_client u2_ ON u0_.id = u2_.id
  LEFT JOIN user_bailleur u3_ ON u0_.id = u3_.id
WHERE
  u0_.created_at BETWEEN ?
  AND ?

SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ LEFT JOIN user_admin u1_ ON u0_.id = u1_.id LEFT JOIN user_client u2_ ON u0_.id = u2_.id LEFT JOIN user_bailleur u3_ ON u0_.id = u3_.id WHERE u0_.created_at BETWEEN '2025-03-01 00:00:00' AND '2025-04-01 00:00:00';

SELECT
  SUM(p0_.prix_ttc) AS sclr_0
FROM
  paiement p0_
WHERE
  p0_.date_paiement BETWEEN ?
  AND ?

SELECT SUM(p0_.prix_ttc) AS sclr_0 FROM paiement p0_ WHERE p0_.date_paiement BETWEEN '2025-03-01 00:00:00' AND '2025-04-01 00:00:00';

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  clients c0_
WHERE
  c0_.created_at BETWEEN ?
  AND ?

SELECT COUNT(c0_.id) AS sclr_0 FROM clients c0_ WHERE c0_.created_at BETWEEN '2025-04-01 00:00:00' AND '2025-05-01 00:00:00';

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  user u0_
  LEFT JOIN user_admin u1_ ON u0_.id = u1_.id
  LEFT JOIN user_client u2_ ON u0_.id = u2_.id
  LEFT JOIN user_bailleur u3_ ON u0_.id = u3_.id
WHERE
  u0_.created_at BETWEEN ?
  AND ?

SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ LEFT JOIN user_admin u1_ ON u0_.id = u1_.id LEFT JOIN user_client u2_ ON u0_.id = u2_.id LEFT JOIN user_bailleur u3_ ON u0_.id = u3_.id WHERE u0_.created_at BETWEEN '2025-04-01 00:00:00' AND '2025-05-01 00:00:00';

SELECT
  SUM(p0_.prix_ttc) AS sclr_0
FROM
  paiement p0_
WHERE
  p0_.date_paiement BETWEEN ?
  AND ?

SELECT SUM(p0_.prix_ttc) AS sclr_0 FROM paiement p0_ WHERE p0_.date_paiement BETWEEN '2025-04-01 00:00:00' AND '2025-05-01 00:00:00';

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  clients c0_
WHERE
  c0_.created_at BETWEEN ?
  AND ?

SELECT COUNT(c0_.id) AS sclr_0 FROM clients c0_ WHERE c0_.created_at BETWEEN '2025-05-01 00:00:00' AND '2025-06-01 00:00:00';

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  user u0_
  LEFT JOIN user_admin u1_ ON u0_.id = u1_.id
  LEFT JOIN user_client u2_ ON u0_.id = u2_.id
  LEFT JOIN user_bailleur u3_ ON u0_.id = u3_.id
WHERE
  u0_.created_at BETWEEN ?
  AND ?

SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ LEFT JOIN user_admin u1_ ON u0_.id = u1_.id LEFT JOIN user_client u2_ ON u0_.id = u2_.id LEFT JOIN user_bailleur u3_ ON u0_.id = u3_.id WHERE u0_.created_at BETWEEN '2025-05-01 00:00:00' AND '2025-06-01 00:00:00';

SELECT
  SUM(p0_.prix_ttc) AS sclr_0
FROM
  paiement p0_
WHERE
  p0_.date_paiement BETWEEN ?
  AND ?

SELECT SUM(p0_.prix_ttc) AS sclr_0 FROM paiement p0_ WHERE p0_.date_paiement BETWEEN '2025-05-01 00:00:00' AND '2025-06-01 00:00:00';

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  clients c0_
WHERE
  c0_.created_at BETWEEN ?
  AND ?

SELECT COUNT(c0_.id) AS sclr_0 FROM clients c0_ WHERE c0_.created_at BETWEEN '2025-06-01 00:00:00' AND '2025-07-01 00:00:00';

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  user u0_
  LEFT JOIN user_admin u1_ ON u0_.id = u1_.id
  LEFT JOIN user_client u2_ ON u0_.id = u2_.id
  LEFT JOIN user_bailleur u3_ ON u0_.id = u3_.id
WHERE
  u0_.created_at BETWEEN ?
  AND ?

SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ LEFT JOIN user_admin u1_ ON u0_.id = u1_.id LEFT JOIN user_client u2_ ON u0_.id = u2_.id LEFT JOIN user_bailleur u3_ ON u0_.id = u3_.id WHERE u0_.created_at BETWEEN '2025-06-01 00:00:00' AND '2025-07-01 00:00:00';

SELECT
  SUM(p0_.prix_ttc) AS sclr_0
FROM
  paiement p0_
WHERE
  p0_.date_paiement BETWEEN ?
  AND ?

SELECT SUM(p0_.prix_ttc) AS sclr_0 FROM paiement p0_ WHERE p0_.date_paiement BETWEEN '2025-06-01 00:00:00' AND '2025-07-01 00:00:00';

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  clients c0_
WHERE
  c0_.created_at BETWEEN ?
  AND ?

SELECT COUNT(c0_.id) AS sclr_0 FROM clients c0_ WHERE c0_.created_at BETWEEN '2025-07-01 00:00:00' AND '2025-08-01 00:00:00';

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  user u0_
  LEFT JOIN user_admin u1_ ON u0_.id = u1_.id
  LEFT JOIN user_client u2_ ON u0_.id = u2_.id
  LEFT JOIN user_bailleur u3_ ON u0_.id = u3_.id
WHERE
  u0_.created_at BETWEEN ?
  AND ?

SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ LEFT JOIN user_admin u1_ ON u0_.id = u1_.id LEFT JOIN user_client u2_ ON u0_.id = u2_.id LEFT JOIN user_bailleur u3_ ON u0_.id = u3_.id WHERE u0_.created_at BETWEEN '2025-07-01 00:00:00' AND '2025-08-01 00:00:00';

SELECT
  SUM(p0_.prix_ttc) AS sclr_0
FROM
  paiement p0_
WHERE
  p0_.date_paiement BETWEEN ?
  AND ?

SELECT SUM(p0_.prix_ttc) AS sclr_0 FROM paiement p0_ WHERE p0_.date_paiement BETWEEN '2025-07-01 00:00:00' AND '2025-08-01 00:00:00';

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  clients c0_
WHERE
  c0_.created_at BETWEEN ?
  AND ?

SELECT COUNT(c0_.id) AS sclr_0 FROM clients c0_ WHERE c0_.created_at BETWEEN '2025-08-01 00:00:00' AND '2025-09-01 00:00:00';

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  user u0_
  LEFT JOIN user_admin u1_ ON u0_.id = u1_.id
  LEFT JOIN user_client u2_ ON u0_.id = u2_.id
  LEFT JOIN user_bailleur u3_ ON u0_.id = u3_.id
WHERE
  u0_.created_at BETWEEN ?
  AND ?

SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ LEFT JOIN user_admin u1_ ON u0_.id = u1_.id LEFT JOIN user_client u2_ ON u0_.id = u2_.id LEFT JOIN user_bailleur u3_ ON u0_.id = u3_.id WHERE u0_.created_at BETWEEN '2025-08-01 00:00:00' AND '2025-09-01 00:00:00';

SELECT
  SUM(p0_.prix_ttc) AS sclr_0
FROM
  paiement p0_
WHERE
  p0_.date_paiement BETWEEN ?
  AND ?

SELECT SUM(p0_.prix_ttc) AS sclr_0 FROM paiement p0_ WHERE p0_.date_paiement BETWEEN '2025-08-01 00:00:00' AND '2025-09-01 00:00:00';

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  clients c0_
WHERE
  c0_.created_at BETWEEN ?
  AND ?

SELECT COUNT(c0_.id) AS sclr_0 FROM clients c0_ WHERE c0_.created_at BETWEEN '2025-09-01 00:00:00' AND '2025-10-01 00:00:00';

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  user u0_
  LEFT JOIN user_admin u1_ ON u0_.id = u1_.id
  LEFT JOIN user_client u2_ ON u0_.id = u2_.id
  LEFT JOIN user_bailleur u3_ ON u0_.id = u3_.id
WHERE
  u0_.created_at BETWEEN ?
  AND ?

SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ LEFT JOIN user_admin u1_ ON u0_.id = u1_.id LEFT JOIN user_client u2_ ON u0_.id = u2_.id LEFT JOIN user_bailleur u3_ ON u0_.id = u3_.id WHERE u0_.created_at BETWEEN '2025-09-01 00:00:00' AND '2025-10-01 00:00:00';

SELECT
  SUM(p0_.prix_ttc) AS sclr_0
FROM
  paiement p0_
WHERE
  p0_.date_paiement BETWEEN ?
  AND ?

SELECT SUM(p0_.prix_ttc) AS sclr_0 FROM paiement p0_ WHERE p0_.date_paiement BETWEEN '2025-09-01 00:00:00' AND '2025-10-01 00:00:00';

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  clients c0_
WHERE
  c0_.created_at BETWEEN ?
  AND ?

SELECT COUNT(c0_.id) AS sclr_0 FROM clients c0_ WHERE c0_.created_at BETWEEN '2025-10-01 00:00:00' AND '2025-11-01 00:00:00';

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  user u0_
  LEFT JOIN user_admin u1_ ON u0_.id = u1_.id
  LEFT JOIN user_client u2_ ON u0_.id = u2_.id
  LEFT JOIN user_bailleur u3_ ON u0_.id = u3_.id
WHERE
  u0_.created_at BETWEEN ?
  AND ?

SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ LEFT JOIN user_admin u1_ ON u0_.id = u1_.id LEFT JOIN user_client u2_ ON u0_.id = u2_.id LEFT JOIN user_bailleur u3_ ON u0_.id = u3_.id WHERE u0_.created_at BETWEEN '2025-10-01 00:00:00' AND '2025-11-01 00:00:00';

SELECT
  SUM(p0_.prix_ttc) AS sclr_0
FROM
  paiement p0_
WHERE
  p0_.date_paiement BETWEEN ?
  AND ?

SELECT SUM(p0_.prix_ttc) AS sclr_0 FROM paiement p0_ WHERE p0_.date_paiement BETWEEN '2025-10-01 00:00:00' AND '2025-11-01 00:00:00';

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  clients c0_
WHERE
  c0_.created_at BETWEEN ?
  AND ?

SELECT COUNT(c0_.id) AS sclr_0 FROM clients c0_ WHERE c0_.created_at BETWEEN '2025-11-01 00:00:00' AND '2025-12-01 00:00:00';

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  user u0_
  LEFT JOIN user_admin u1_ ON u0_.id = u1_.id
  LEFT JOIN user_client u2_ ON u0_.id = u2_.id
  LEFT JOIN user_bailleur u3_ ON u0_.id = u3_.id
WHERE
  u0_.created_at BETWEEN ?
  AND ?

SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ LEFT JOIN user_admin u1_ ON u0_.id = u1_.id LEFT JOIN user_client u2_ ON u0_.id = u2_.id LEFT JOIN user_bailleur u3_ ON u0_.id = u3_.id WHERE u0_.created_at BETWEEN '2025-11-01 00:00:00' AND '2025-12-01 00:00:00';

SELECT
  SUM(p0_.prix_ttc) AS sclr_0
FROM
  paiement p0_
WHERE
  p0_.date_paiement BETWEEN ?
  AND ?