Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Exception
• Logs 7
• Events
• Routing
• Cache
• Security
• Twig
• HTTP Client
• Doctrine
• Serializer
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.username AS username_7, t0.is_active AS is_active_8 FROM "user" t0 WHERE t0.username = ? LIMIT 1

[
  "varicap"
]

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.roles AS roles_6,
  t0.username AS username_7,
  t0.is_active AS is_active_8
FROM
  "user" t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.username AS username_7, t0.is_active AS is_active_8 FROM "user" t0 WHERE t0.username = 'varicap' LIMIT 1;

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.identifiant AS identifiant_3, c0_.name AS name_4, c0_.slug AS slug_5, c0_.started_at AS started_at_6, c0_.ended_at AS ended_at_7, s1_.id AS id_8, s1_.created_at AS created_at_9, s1_.updated_at AS updated_at_10, s1_.identifiant AS identifiant_11, s1_.name AS name_12, s1_.slug AS slug_13, c0_.site_id AS site_id_14 FROM campaign c0_ INNER JOIN site s1_ ON c0_.site_id = s1_.id WHERE c0_.id IN (SELECT c2_.id FROM campaign c2_ INNER JOIN site s3_ ON c2_.site_id = s3_.id WHERE s3_.identifiant = ? AND c2_.started_at <= ? AND c2_.ended_at >= ?) ORDER BY c0_.id ASC LIMIT 128

[
  "2"
  "2022-08-02"
  "2022-08-02"
]

SELECT
  c0_.id AS id_0,
  c0_.created_at AS created_at_1,
  c0_.updated_at AS updated_at_2,
  c0_.identifiant AS identifiant_3,
  c0_.name AS name_4,
  c0_.slug AS slug_5,
  c0_.started_at AS started_at_6,
  c0_.ended_at AS ended_at_7,
  s1_.id AS id_8,
  s1_.created_at AS created_at_9,
  s1_.updated_at AS updated_at_10,
  s1_.identifiant AS identifiant_11,
  s1_.name AS name_12,
  s1_.slug AS slug_13,
  c0_.site_id AS site_id_14
FROM
  campaign c0_
  INNER JOIN site s1_ ON c0_.site_id = s1_.id
WHERE
  c0_.id IN (
    SELECT
      c2_.id
    FROM
      campaign c2_
      INNER JOIN site s3_ ON c2_.site_id = s3_.id
    WHERE
      s3_.identifiant = ?
      AND c2_.started_at <= ?
      AND c2_.ended_at >= ?
  )
ORDER BY
  c0_.id ASC
LIMIT
  128

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.identifiant AS identifiant_3, c0_.name AS name_4, c0_.slug AS slug_5, c0_.started_at AS started_at_6, c0_.ended_at AS ended_at_7, s1_.id AS id_8, s1_.created_at AS created_at_9, s1_.updated_at AS updated_at_10, s1_.identifiant AS identifiant_11, s1_.name AS name_12, s1_.slug AS slug_13, c0_.site_id AS site_id_14 FROM campaign c0_ INNER JOIN site s1_ ON c0_.site_id = s1_.id WHERE c0_.id IN (SELECT c2_.id FROM campaign c2_ INNER JOIN site s3_ ON c2_.site_id = s3_.id WHERE s3_.identifiant = '2' AND c2_.started_at <= '2022-08-02' AND c2_.ended_at >= '2022-08-02') ORDER BY c0_.id ASC LIMIT 128;