Symfony Profiler

• Request / Response
• Performance
• Validator
• Exception
• Logs 3
• Events
• Routing
• Cache
• Security
• Twig
• HTTP Client
• Doctrine
• Messages
• Emails
• Serializer
• GraphQL 1
• Redis
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.password AS password_3, t0.avatar AS avatar_4, t0.full_path_avatar AS full_path_avatar_5, t0.email AS email_6, t0.name AS name_7 FROM administration_user t0 WHERE t0.email = ? LIMIT 1

[
  "[email protected]"
]

SELECT
  t0.id AS id_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.avatar AS avatar_4,
  t0.full_path_avatar AS full_path_avatar_5,
  t0.email AS email_6,
  t0.name AS name_7
FROM
  administration_user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.password AS password_3, t0.avatar AS avatar_4, t0.full_path_avatar AS full_path_avatar_5, t0.email AS email_6, t0.name AS name_7 FROM administration_user t0 WHERE t0.email = '[email protected]' LIMIT 1;

SELECT t0.id AS id_1, t0.bundle_id AS bundle_id_2, t0.platform AS platform_3, t0.name AS name_4, t0.project_id AS project_id_5 FROM administration_application t0 WHERE t0.id IN (?)

[
  "c30db438-3e6b-42f2-8983-e7faecfba38c"
]

SELECT
  t0.id AS id_1,
  t0.bundle_id AS bundle_id_2,
  t0.platform AS platform_3,
  t0.name AS name_4,
  t0.project_id AS project_id_5
FROM
  administration_application t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.bundle_id AS bundle_id_2, t0.platform AS platform_3, t0.name AS name_4, t0.project_id AS project_id_5 FROM administration_application t0 WHERE t0.id IN ('c30db438-3e6b-42f2-8983-e7faecfba38c');

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM campaign c0_ WHERE c0_.project_id = ?

[
  "cce0d658-3d37-4eb3-936c-cc6cad514074"
]

SELECT
  COUNT(DISTINCT c0_.id) AS sclr_0
FROM
  campaign c0_
WHERE
  c0_.project_id = ?

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM campaign c0_ WHERE c0_.project_id = 'cce0d658-3d37-4eb3-936c-cc6cad514074';

SELECT DISTINCT id_0, MIN(sclr_9) AS dctrn_minrownum FROM (SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.state AS state_2, c0_.name AS name_3, c0_.triggering AS triggering_4, c0_.targeting AS targeting_5, c0_.content AS content_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, ROW_NUMBER() OVER(ORDER BY c0_.id ASC) AS sclr_9 FROM campaign c0_ WHERE c0_.project_id = ?) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 6

[
  "cce0d658-3d37-4eb3-936c-cc6cad514074"
]

SELECT
  DISTINCT id_0,
  MIN(sclr_9) AS dctrn_minrownum
FROM
  (
    SELECT
      c0_.id AS id_0,
      c0_.type AS type_1,
      c0_.state AS state_2,
      c0_.name AS name_3,
      c0_.triggering AS triggering_4,
      c0_.targeting AS targeting_5,
      c0_.content AS content_6,
      c0_.created_at AS created_at_7,
      c0_.updated_at AS updated_at_8,
      ROW_NUMBER() OVER(
        ORDER BY
          c0_.id ASC
      ) AS sclr_9
    FROM
      campaign c0_
    WHERE
      c0_.project_id = ?
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  6

SELECT DISTINCT id_0, MIN(sclr_9) AS dctrn_minrownum FROM (SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.state AS state_2, c0_.name AS name_3, c0_.triggering AS triggering_4, c0_.targeting AS targeting_5, c0_.content AS content_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, ROW_NUMBER() OVER(ORDER BY c0_.id ASC) AS sclr_9 FROM campaign c0_ WHERE c0_.project_id = 'cce0d658-3d37-4eb3-936c-cc6cad514074') dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 6;

SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.state AS state_2, c0_.name AS name_3, c0_.triggering AS triggering_4, c0_.targeting AS targeting_5, c0_.content AS content_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.project_id AS project_id_9 FROM campaign c0_ WHERE c0_.project_id = ? AND c0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY c0_.id ASC

[
  "cce0d658-3d37-4eb3-936c-cc6cad514074"
  "18779279-4d83-40eb-a246-42c3ab9dfa12"
  "1a5e027c-c308-4487-80e8-100a6064de44"
  "60a149b5-279d-473a-ad42-0eecf5a63e85"
  "72e54ca4-b9e8-4c8c-adbf-85fb44a3a7a0"
  "ca6ed913-053d-4b2e-a289-75c6b5d4b8b4"
  "caab32aa-19ce-434c-aa36-7460021cb935"
]

SELECT
  c0_.id AS id_0,
  c0_.type AS type_1,
  c0_.state AS state_2,
  c0_.name AS name_3,
  c0_.triggering AS triggering_4,
  c0_.targeting AS targeting_5,
  c0_.content AS content_6,
  c0_.created_at AS created_at_7,
  c0_.updated_at AS updated_at_8,
  c0_.project_id AS project_id_9
FROM
  campaign c0_
WHERE
  c0_.project_id = ?
  AND c0_.id IN (?, ?, ?, ?, ?, ?)
ORDER BY
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.state AS state_2, c0_.name AS name_3, c0_.triggering AS triggering_4, c0_.targeting AS targeting_5, c0_.content AS content_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.project_id AS project_id_9 FROM campaign c0_ WHERE c0_.project_id = 'cce0d658-3d37-4eb3-936c-cc6cad514074' AND c0_.id IN ('18779279-4d83-40eb-a246-42c3ab9dfa12', '1a5e027c-c308-4487-80e8-100a6064de44', '60a149b5-279d-473a-ad42-0eecf5a63e85', '72e54ca4-b9e8-4c8c-adbf-85fb44a3a7a0', 'ca6ed913-053d-4b2e-a289-75c6b5d4b8b4', 'caab32aa-19ce-434c-aa36-7460021cb935') ORDER BY c0_.id ASC;