Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.url AS url_7, t0.target AS target_8, t0.is_home AS is_home_9, t0.rank AS rank_10, t0.is_published AS is_published_11, t0.old_id AS old_id_12, t0.menu_id AS menu_id_13 FROM page t0 WHERE t0.is_home = ? LIMIT 1

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.body AS body_4,
  t0.keywords AS keywords_5,
  t0.description AS description_6,
  t0.url AS url_7,
  t0.target AS target_8,
  t0.is_home AS is_home_9,
  t0.rank AS rank_10,
  t0.is_published AS is_published_11,
  t0.old_id AS old_id_12,
  t0.menu_id AS menu_id_13
FROM
  page t0
WHERE
  t0.is_home = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.url AS url_7, t0.target AS target_8, t0.is_home AS is_home_9, t0.rank AS rank_10, t0.is_published AS is_published_11, t0.old_id AS old_id_12, t0.menu_id AS menu_id_13 FROM page t0 WHERE t0.is_home = 1 LIMIT 1;

SELECT COUNT(f0_.id) AS sclr_0 FROM franchise f0_ WHERE f0_.status IN (?, ?)

[
  "a"
  "e"
]

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  franchise f0_
WHERE
  f0_.status IN (?, ?)

SELECT COUNT(f0_.id) AS sclr_0 FROM franchise f0_ WHERE f0_.status IN ('a', 'e');

SELECT COUNT(s0_.id) AS sclr_0 FROM student s0_

[]

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  student s0_

SELECT COUNT(s0_.id) AS sclr_0 FROM student s0_;

SELECT s0_.name AS name_0, COUNT(f1_.id) AS sclr_1 FROM franchise f1_ INNER JOIN state s0_ ON f1_.state_id = s0_.id WHERE f1_.status = ? GROUP BY s0_.name

[
  "a"
]

SELECT
  s0_.name AS name_0,
  COUNT(f1_.id) AS sclr_1
FROM
  franchise f1_
  INNER JOIN state s0_ ON f1_.state_id = s0_.id
WHERE
  f1_.status = ?
GROUP BY
  s0_.name

SELECT s0_.name AS name_0, COUNT(f1_.id) AS sclr_1 FROM franchise f1_ INNER JOIN state s0_ ON f1_.state_id = s0_.id WHERE f1_.status = 'a' GROUP BY s0_.name;