Symfony Profiler

• Request / Response
• Performance
• Validator
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Messages
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.last_login_at AS last_login_at_8 FROM users t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.is_active AS is_active_6,
  t0.created_at AS created_at_7,
  t0.last_login_at AS last_login_at_8
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.last_login_at AS last_login_at_8 FROM users t0 WHERE t0.id = 1;

SELECT s0_.id AS id_0, s0_.url AS url_1, s0_.name AS name_2, s0_.description AS description_3, s0_.callback_api_key AS callback_api_key_4, s0_.entity_list_endpoint AS entity_list_endpoint_5, s0_.entity_detail_endpoint AS entity_detail_endpoint_6, s0_.check_entities_endpoint AS check_entities_endpoint_7, s0_.last_validated_at AS last_validated_at_8, s0_.is_active AS is_active_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.last_synced_at AS last_synced_at_12 FROM sources s0_ WHERE s0_.is_active = ? ORDER BY s0_.name ASC

[
  1
]

SELECT
  s0_.id AS id_0,
  s0_.url AS url_1,
  s0_.name AS name_2,
  s0_.description AS description_3,
  s0_.callback_api_key AS callback_api_key_4,
  s0_.entity_list_endpoint AS entity_list_endpoint_5,
  s0_.entity_detail_endpoint AS entity_detail_endpoint_6,
  s0_.check_entities_endpoint AS check_entities_endpoint_7,
  s0_.last_validated_at AS last_validated_at_8,
  s0_.is_active AS is_active_9,
  s0_.created_at AS created_at_10,
  s0_.updated_at AS updated_at_11,
  s0_.last_synced_at AS last_synced_at_12
FROM
  sources s0_
WHERE
  s0_.is_active = ?
ORDER BY
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.url AS url_1, s0_.name AS name_2, s0_.description AS description_3, s0_.callback_api_key AS callback_api_key_4, s0_.entity_list_endpoint AS entity_list_endpoint_5, s0_.entity_detail_endpoint AS entity_detail_endpoint_6, s0_.check_entities_endpoint AS check_entities_endpoint_7, s0_.last_validated_at AS last_validated_at_8, s0_.is_active AS is_active_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.last_synced_at AS last_synced_at_12 FROM sources s0_ WHERE s0_.is_active = 1 ORDER BY s0_.name ASC;

SELECT COUNT(c0_.id) AS sclr_0, SUM(CASE WHEN c0_.published = 1 AND c0_.deleted = 0 AND c0_.needs_sync = 0 THEN 1 ELSE 0 END) AS sclr_1, SUM(CASE WHEN c0_.deleted = 1 THEN 1 ELSE 0 END) AS sclr_2, SUM(CASE WHEN c0_.needs_sync = 1 THEN 1 ELSE 0 END) AS sclr_3, MAX(c0_.changed_at) AS sclr_4, MAX(c0_.cached_at) AS sclr_5 FROM cached_entities c0_ INNER JOIN sources s1_ ON c0_.source_id = s1_.id WHERE s1_.url = ?

[
  "https://vit-1648-v2-dig0061542-nestlehealthscience-vitaflo-allcountries.pantheonsite.io"
]

SELECT
  COUNT(c0_.id) AS sclr_0,
  SUM(
    CASE WHEN c0_.published = 1
    AND c0_.deleted = 0
    AND c0_.needs_sync = 0 THEN
      1
    ELSE
      0
    END
  ) AS sclr_1,
  SUM(
    CASE WHEN c0_.deleted = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_2,
  SUM(
    CASE WHEN c0_.needs_sync = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_3,
  MAX(c0_.changed_at) AS sclr_4,
  MAX(c0_.cached_at) AS sclr_5
FROM
  cached_entities c0_
  INNER JOIN sources s1_ ON c0_.source_id = s1_.id
WHERE
  s1_.url = ?

SELECT COUNT(c0_.id) AS sclr_0, SUM(CASE WHEN c0_.published = 1 AND c0_.deleted = 0 AND c0_.needs_sync = 0 THEN 1 ELSE 0 END) AS sclr_1, SUM(CASE WHEN c0_.deleted = 1 THEN 1 ELSE 0 END) AS sclr_2, SUM(CASE WHEN c0_.needs_sync = 1 THEN 1 ELSE 0 END) AS sclr_3, MAX(c0_.changed_at) AS sclr_4, MAX(c0_.cached_at) AS sclr_5 FROM cached_entities c0_ INNER JOIN sources s1_ ON c0_.source_id = s1_.id WHERE s1_.url = 'https://vit-1648-v2-dig0061542-nestlehealthscience-vitaflo-allcountries.pantheonsite.io';