Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 17
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT t0.email AS email_1, t0.password AS password_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.user_data AS user_data_5, t0.is_active AS is_active_6, t0.archived_at AS archived_at_7, t0.is_system AS is_system_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.external_id AS external_id_12 FROM person t0 WHERE t0.id = ?

[
  "1f0f505a-b71d-6782-9267-7dcdb55ef7cb"
]

SELECT
  t0.email AS email_1,
  t0.password AS password_2,
  t0.firstname AS firstname_3,
  t0.lastname AS lastname_4,
  t0.user_data AS user_data_5,
  t0.is_active AS is_active_6,
  t0.archived_at AS archived_at_7,
  t0.is_system AS is_system_8,
  t0.id AS id_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.external_id AS external_id_12
FROM
  person t0
WHERE
  t0.id = ?

SELECT t0.email AS email_1, t0.password AS password_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.user_data AS user_data_5, t0.is_active AS is_active_6, t0.archived_at AS archived_at_7, t0.is_system AS is_system_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.external_id AS external_id_12 FROM person t0 WHERE t0.id = '1f0f505a-b71d-6782-9267-7dcdb55ef7cb';

SELECT t0.created_at AS created_at_3, t0.id AS id_4, t0.person_id AS person_id_5, t0.type, t1.role AS role_6, t2.role AS role_7, t2.company_id AS company_id_8 FROM account t0 LEFT JOIN admin_account t1 ON t0.id = t1.id LEFT JOIN respondent_account t2 ON t0.id = t2.id WHERE t0.id = ?

[
  "1f0f505a-b71d-6782-9267-7dcdb55ef7cb"
]

SELECT
  t0.created_at AS created_at_3,
  t0.id AS id_4,
  t0.person_id AS person_id_5,
  t0.type,
  t1.role AS role_6,
  t2.role AS role_7,
  t2.company_id AS company_id_8
FROM
  account t0
  LEFT JOIN admin_account t1 ON t0.id = t1.id
  LEFT JOIN respondent_account t2 ON t0.id = t2.id
WHERE
  t0.id = ?

SELECT t0.created_at AS created_at_3, t0.id AS id_4, t0.person_id AS person_id_5, t0.type, t1.role AS role_6, t2.role AS role_7, t2.company_id AS company_id_8 FROM account t0 LEFT JOIN admin_account t1 ON t0.id = t1.id LEFT JOIN respondent_account t2 ON t0.id = t2.id WHERE t0.id = '1f0f505a-b71d-6782-9267-7dcdb55ef7cb';

SELECT t0.name AS name_1, t0.market_coverage_rate AS market_coverage_rate_2, t0.code AS code_3, t0.sector AS sector_4, t0.status AS status_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.external_id AS external_id_8 FROM equipment t0 WHERE t0.id = ?

[
  "1f0f53e3-1527-6126-a6dd-4bcbc431f64b"
]

SELECT
  t0.name AS name_1,
  t0.market_coverage_rate AS market_coverage_rate_2,
  t0.code AS code_3,
  t0.sector AS sector_4,
  t0.status AS status_5,
  t0.id AS id_6,
  t0.created_at AS created_at_7,
  t0.external_id AS external_id_8
FROM
  equipment t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.market_coverage_rate AS market_coverage_rate_2, t0.code AS code_3, t0.sector AS sector_4, t0.status AS status_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.external_id AS external_id_8 FROM equipment t0 WHERE t0.id = '1f0f53e3-1527-6126-a6dd-4bcbc431f64b';

SELECT c0_.dimension_code AS dimension_code_0, c0_.dimension_name AS dimension_name_1, c0_.specification_label AS specification_label_2, SUM(c0_.value) AS sclr_3, COUNT(DISTINCT c0_.company_id) AS sclr_4 FROM campaign_snapshot_entry c0_ INNER JOIN campaign_snapshot c1_ ON c0_.snapshot_id = c1_.id INNER JOIN campaign c2_ ON c1_.campaign_id = c2_.id INNER JOIN campaign_template c3_ ON c2_.template_id = c3_.id WHERE c3_.equipment_id IN (?) AND c1_.version = (SELECT MAX(c4_.version) AS sclr_5 FROM campaign_snapshot c4_ WHERE c4_.campaign_id = c1_.campaign_id) AND (c2_.end_date >= ? AND c2_.end_date <= ?) GROUP BY c0_.dimension_code, c0_.dimension_name, c0_.specification_label ORDER BY c0_.dimension_name ASC, c0_.dimension_code ASC, c0_.specification_label ASC

[
  Symfony\Component\Uid\UuidV6 {#1224
    __toString(): "1f0f53e3-1527-6126-a6dd-4bcbc431f64b"
  }
  "2017-01-01 00:00:00"
  "2017-12-31 00:00:00"
]

SELECT
  c0_.dimension_code AS dimension_code_0,
  c0_.dimension_name AS dimension_name_1,
  c0_.specification_label AS specification_label_2,
  SUM(c0_.value) AS sclr_3,
  COUNT(DISTINCT c0_.company_id) AS sclr_4
FROM
  campaign_snapshot_entry c0_
  INNER JOIN campaign_snapshot c1_ ON c0_.snapshot_id = c1_.id
  INNER JOIN campaign c2_ ON c1_.campaign_id = c2_.id
  INNER JOIN campaign_template c3_ ON c2_.template_id = c3_.id
WHERE
  c3_.equipment_id IN (?)
  AND c1_.version = (
    SELECT
      MAX(c4_.version) AS sclr_5
    FROM
      campaign_snapshot c4_
    WHERE
      c4_.campaign_id = c1_.campaign_id
  )
  AND (
    c2_.end_date >= ?
    AND c2_.end_date <= ?
  )
GROUP BY
  c0_.dimension_code,
  c0_.dimension_name,
  c0_.specification_label
ORDER BY
  c0_.dimension_name ASC,
  c0_.dimension_code ASC,
  c0_.specification_label ASC

SELECT c0_.dimension_code AS dimension_code_0, c0_.dimension_name AS dimension_name_1, c0_.specification_label AS specification_label_2, SUM(c0_.value) AS sclr_3, COUNT(DISTINCT c0_.company_id) AS sclr_4 FROM campaign_snapshot_entry c0_ INNER JOIN campaign_snapshot c1_ ON c0_.snapshot_id = c1_.id INNER JOIN campaign c2_ ON c1_.campaign_id = c2_.id INNER JOIN campaign_template c3_ ON c2_.template_id = c3_.id WHERE c3_.equipment_id IN ('1f0f53e3-1527-6126-a6dd-4bcbc431f64b') AND c1_.version = (SELECT MAX(c4_.version) AS sclr_5 FROM campaign_snapshot c4_ WHERE c4_.campaign_id = c1_.campaign_id) AND (c2_.end_date >= '2017-01-01 00:00:00' AND c2_.end_date <= '2017-12-31 00:00:00') GROUP BY c0_.dimension_code, c0_.dimension_name, c0_.specification_label ORDER BY c0_.dimension_name ASC, c0_.dimension_code ASC, c0_.specification_label ASC;