Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.display_name AS display_name_5 FROM user t0 WHERE t0.id = ?

[
  8
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.display_name AS display_name_5
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.display_name AS display_name_5 FROM user t0 WHERE t0.id = 8;

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.display_name AS display_name_5 FROM user t0 ORDER BY t0.display_name ASC

[]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.display_name AS display_name_5
FROM
  user t0
ORDER BY
  t0.display_name ASC

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.display_name AS display_name_5 FROM user t0 ORDER BY t0.display_name ASC;

SELECT q0_.id AS id_0, q0_.reference_id AS reference_id_1, q0_.status AS status_2, q0_.author AS author_3, q0_.title AS title_4, q0_.place_of_issue AS place_of_issue_5, q0_.publisher AS publisher_6, q0_.year_of_issue AS year_of_issue_7, q0_.abbreviation AS abbreviation_8, q0_.created_at AS created_at_9, q0_.updated_at AS updated_at_10, q0_.deleted_at AS deleted_at_11, q1_.id AS id_12, q1_.type AS type_13, q1_.value AS value_14, q1_.created_at AS created_at_15, q1_.updated_at AS updated_at_16, q1_.deleted_at AS deleted_at_17, q0_.created_by_id AS created_by_id_18, q1_.quote_id AS quote_id_19 FROM quote q0_ LEFT JOIN quote_supplement q1_ ON q0_.id = q1_.quote_id AND (q1_.deleted_at IS NULL) WHERE (q0_.status >= ? AND q0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (q0_.deleted_at IS NULL) ORDER BY q0_.reference_id ASC

[
  10
  236
  261
  289
  311
  326
  151
  24
  154
  387
  139
  55
  201
  162
  17
]

SELECT
  q0_.id AS id_0,
  q0_.reference_id AS reference_id_1,
  q0_.status AS status_2,
  q0_.author AS author_3,
  q0_.title AS title_4,
  q0_.place_of_issue AS place_of_issue_5,
  q0_.publisher AS publisher_6,
  q0_.year_of_issue AS year_of_issue_7,
  q0_.abbreviation AS abbreviation_8,
  q0_.created_at AS created_at_9,
  q0_.updated_at AS updated_at_10,
  q0_.deleted_at AS deleted_at_11,
  q1_.id AS id_12,
  q1_.type AS type_13,
  q1_.value AS value_14,
  q1_.created_at AS created_at_15,
  q1_.updated_at AS updated_at_16,
  q1_.deleted_at AS deleted_at_17,
  q0_.created_by_id AS created_by_id_18,
  q1_.quote_id AS quote_id_19
FROM
  quote q0_
  LEFT JOIN quote_supplement q1_ ON q0_.id = q1_.quote_id
  AND (q1_.deleted_at IS NULL)
WHERE
  (
    q0_.status >= ?
    AND q0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  )
  AND (q0_.deleted_at IS NULL)
ORDER BY
  q0_.reference_id ASC

SELECT q0_.id AS id_0, q0_.reference_id AS reference_id_1, q0_.status AS status_2, q0_.author AS author_3, q0_.title AS title_4, q0_.place_of_issue AS place_of_issue_5, q0_.publisher AS publisher_6, q0_.year_of_issue AS year_of_issue_7, q0_.abbreviation AS abbreviation_8, q0_.created_at AS created_at_9, q0_.updated_at AS updated_at_10, q0_.deleted_at AS deleted_at_11, q1_.id AS id_12, q1_.type AS type_13, q1_.value AS value_14, q1_.created_at AS created_at_15, q1_.updated_at AS updated_at_16, q1_.deleted_at AS deleted_at_17, q0_.created_by_id AS created_by_id_18, q1_.quote_id AS quote_id_19 FROM quote q0_ LEFT JOIN quote_supplement q1_ ON q0_.id = q1_.quote_id AND (q1_.deleted_at IS NULL) WHERE (q0_.status >= 10 AND q0_.id IN (236, 261, 289, 311, 326, 151, 24, 154, 387, 139, 55, 201, 162, 17)) AND (q0_.deleted_at IS NULL) ORDER BY q0_.reference_id ASC;

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.path AS path_2, s0_.content AS content_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.e_tag AS e_tag_6 FROM sermon s0_ WHERE s0_.content LIKE ?

[
  "%QMNCJCEJ%"
]

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.path AS path_2,
  s0_.content AS content_3,
  s0_.created_at AS created_at_4,
  s0_.updated_at AS updated_at_5,
  s0_.e_tag AS e_tag_6
FROM
  sermon s0_
WHERE
  s0_.content LIKE ?

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.path AS path_2, s0_.content AS content_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.e_tag AS e_tag_6 FROM sermon s0_ WHERE s0_.content LIKE '%QMNCJCEJ%';