Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 28
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 10
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Blocks 0
• Configuration

Query Metrics

SELECT d0_.id AS id_0, d0_.membre_communaute_local1 AS membre_communaute_local1_1, d0_.membre_communaute_local2 AS membre_communaute_local2_2, d0_.membre_organisation_communautaire1 AS membre_organisation_communautaire1_3, d0_.membre_organisation_communautaire2 AS membre_organisation_communautaire2_4, d0_.membre_operateur1 AS membre_operateur1_5, d0_.membre_operateur2 AS membre_operateur2_6, d0_.membre_autorite1 AS membre_autorite1_7, d0_.membre_autorite2 AS membre_autorite2_8, d0_.membre_fonds_national1 AS membre_fonds_national1_9, d0_.membre_fonds_national2 AS membre_fonds_national2_10, d0_.membre_direction1 AS membre_direction1_11, d0_.membre_direction2 AS membre_direction2_12, d0_.nom AS nom_13, d0_.date_creation AS date_creation_14, d0_.created_at AS created_at_15, d0_.updated_at AS updated_at_16, d0_.deleted_at AS deleted_at_17, d0_.operateur_id AS operateur_id_18, d0_.user_id AS user_id_19 FROM dot d0_ ORDER BY d0_.id DESC

[]

SELECT
  d0_.id AS id_0,
  d0_.membre_communaute_local1 AS membre_communaute_local1_1,
  d0_.membre_communaute_local2 AS membre_communaute_local2_2,
  d0_.membre_organisation_communautaire1 AS membre_organisation_communautaire1_3,
  d0_.membre_organisation_communautaire2 AS membre_organisation_communautaire2_4,
  d0_.membre_operateur1 AS membre_operateur1_5,
  d0_.membre_operateur2 AS membre_operateur2_6,
  d0_.membre_autorite1 AS membre_autorite1_7,
  d0_.membre_autorite2 AS membre_autorite2_8,
  d0_.membre_fonds_national1 AS membre_fonds_national1_9,
  d0_.membre_fonds_national2 AS membre_fonds_national2_10,
  d0_.membre_direction1 AS membre_direction1_11,
  d0_.membre_direction2 AS membre_direction2_12,
  d0_.nom AS nom_13,
  d0_.date_creation AS date_creation_14,
  d0_.created_at AS created_at_15,
  d0_.updated_at AS updated_at_16,
  d0_.deleted_at AS deleted_at_17,
  d0_.operateur_id AS operateur_id_18,
  d0_.user_id AS user_id_19
FROM
  dot d0_
ORDER BY
  d0_.id DESC

SELECT d0_.id AS id_0, d0_.membre_communaute_local1 AS membre_communaute_local1_1, d0_.membre_communaute_local2 AS membre_communaute_local2_2, d0_.membre_organisation_communautaire1 AS membre_organisation_communautaire1_3, d0_.membre_organisation_communautaire2 AS membre_organisation_communautaire2_4, d0_.membre_operateur1 AS membre_operateur1_5, d0_.membre_operateur2 AS membre_operateur2_6, d0_.membre_autorite1 AS membre_autorite1_7, d0_.membre_autorite2 AS membre_autorite2_8, d0_.membre_fonds_national1 AS membre_fonds_national1_9, d0_.membre_fonds_national2 AS membre_fonds_national2_10, d0_.membre_direction1 AS membre_direction1_11, d0_.membre_direction2 AS membre_direction2_12, d0_.nom AS nom_13, d0_.date_creation AS date_creation_14, d0_.created_at AS created_at_15, d0_.updated_at AS updated_at_16, d0_.deleted_at AS deleted_at_17, d0_.operateur_id AS operateur_id_18, d0_.user_id AS user_id_19 FROM dot d0_ ORDER BY d0_.id DESC;

SELECT COUNT(DISTINCT d0_.id) AS sclr_0 FROM dot d0_ INNER JOIN operateur o1_ ON d0_.operateur_id = o1_.id WHERE d0_.id NOT IN (SELECT DISTINCT d2_.id FROM dot d2_ INNER JOIN operateur o3_ ON d2_.operateur_id = o3_.id INNER JOIN information_financiere i4_ ON o3_.id = i4_.operateur_id WHERE SUBSTRING(i4_.date_info FROM 1 FOR 4) = ?)

[
  "2024"
]

SELECT
  COUNT(DISTINCT d0_.id) AS sclr_0
FROM
  dot d0_
  INNER JOIN operateur o1_ ON d0_.operateur_id = o1_.id
WHERE
  d0_.id NOT IN (
    SELECT
      DISTINCT d2_.id
    FROM
      dot d2_
      INNER JOIN operateur o3_ ON d2_.operateur_id = o3_.id
      INNER JOIN information_financiere i4_ ON o3_.id = i4_.operateur_id
    WHERE
      SUBSTRING(
        i4_.date_info
        FROM
          1 FOR 4
      ) = ?
  )

SELECT COUNT(DISTINCT d0_.id) AS sclr_0 FROM dot d0_ INNER JOIN operateur o1_ ON d0_.operateur_id = o1_.id WHERE d0_.id NOT IN (SELECT DISTINCT d2_.id FROM dot d2_ INNER JOIN operateur o3_ ON d2_.operateur_id = o3_.id INNER JOIN information_financiere i4_ ON o3_.id = i4_.operateur_id WHERE SUBSTRING(i4_.date_info FROM 1 FOR 4) = '2024');

SELECT COUNT(DISTINCT d0_.id) AS sclr_0 FROM dot d0_ INNER JOIN operateur o1_ ON d0_.operateur_id = o1_.id INNER JOIN information_financiere i2_ ON o1_.id = i2_.operateur_id WHERE SUBSTRING(i2_.date_info FROM 1 FOR 4) = ?

[
  "2024"
]

SELECT
  COUNT(DISTINCT d0_.id) AS sclr_0
FROM
  dot d0_
  INNER JOIN operateur o1_ ON d0_.operateur_id = o1_.id
  INNER JOIN information_financiere i2_ ON o1_.id = i2_.operateur_id
WHERE
  SUBSTRING(
    i2_.date_info
    FROM
      1 FOR 4
  ) = ?

SELECT COUNT(DISTINCT d0_.id) AS sclr_0 FROM dot d0_ INNER JOIN operateur o1_ ON d0_.operateur_id = o1_.id INNER JOIN information_financiere i2_ ON o1_.id = i2_.operateur_id WHERE SUBSTRING(i2_.date_info FROM 1 FOR 4) = '2024';

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.unite AS unite_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.user_id AS user_id_8 FROM filiere t0

[]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.unite AS unite_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.user_id AS user_id_8
FROM
  filiere t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.unite AS unite_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.user_id AS user_id_8 FROM filiere t0;

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.user_id AS user_id_7 FROM categorie t0

[]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.user_id AS user_id_7
FROM
  categorie t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.user_id AS user_id_7 FROM categorie t0;