Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.author_id AS author_id_5, t0.created_by_id AS created_by_id_6 FROM book t0 WHERE t0.id = ?

[
  "3"
]

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.author_id AS author_id_5,
  t0.created_by_id AS created_by_id_6
FROM
  book t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.author_id AS author_id_5, t0.created_by_id AS created_by_id_6 FROM book t0 WHERE t0.id = '3';

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM language t0 WHERE t0.code = ? LIMIT 1

[
  "en"
]

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3
FROM
  language t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM language t0 WHERE t0.code = 'en' LIMIT 1;

SELECT q0_.id AS id_0, q0_.sort_order AS sort_order_1, q0_.type AS type_2, q0_.created_at AS created_at_3, q0_.updated_at AS updated_at_4, q0_.deleted_at AS deleted_at_5, q0_.author_id AS author_id_6, q0_.book_id AS book_id_7, q0_.parent_quote_id AS parent_quote_id_8, q0_.created_by_id AS created_by_id_9 FROM quote q0_ WHERE q0_.book_id = ? AND q0_.parent_quote_id IS NULL AND q0_.deleted_at IS NULL ORDER BY q0_.sort_order ASC

[
  3
]

SELECT
  q0_.id AS id_0,
  q0_.sort_order AS sort_order_1,
  q0_.type AS type_2,
  q0_.created_at AS created_at_3,
  q0_.updated_at AS updated_at_4,
  q0_.deleted_at AS deleted_at_5,
  q0_.author_id AS author_id_6,
  q0_.book_id AS book_id_7,
  q0_.parent_quote_id AS parent_quote_id_8,
  q0_.created_by_id AS created_by_id_9
FROM
  quote q0_
WHERE
  q0_.book_id = ?
  AND q0_.parent_quote_id IS NULL
  AND q0_.deleted_at IS NULL
ORDER BY
  q0_.sort_order ASC

SELECT q0_.id AS id_0, q0_.sort_order AS sort_order_1, q0_.type AS type_2, q0_.created_at AS created_at_3, q0_.updated_at AS updated_at_4, q0_.deleted_at AS deleted_at_5, q0_.author_id AS author_id_6, q0_.book_id AS book_id_7, q0_.parent_quote_id AS parent_quote_id_8, q0_.created_by_id AS created_by_id_9 FROM quote q0_ WHERE q0_.book_id = 3 AND q0_.parent_quote_id IS NULL AND q0_.deleted_at IS NULL ORDER BY q0_.sort_order ASC;

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.book_id AS book_id_4, t0.language_id AS language_id_5 FROM book_translation t0 WHERE t0.book_id = ?

[
  3
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.book_id AS book_id_4,
  t0.language_id AS language_id_5
FROM
  book_translation t0
WHERE
  t0.book_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.book_id AS book_id_4, t0.language_id AS language_id_5 FROM book_translation t0 WHERE t0.book_id = 3;

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.created_by_id AS created_by_id_5 FROM author t0 WHERE t0.id = ?

[
  6
]

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.created_by_id AS created_by_id_5
FROM
  author t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.created_by_id AS created_by_id_5 FROM author t0 WHERE t0.id = 6;

SELECT t0.id AS id_1, t0.name AS name_2, t0.biography AS biography_3, t0.author_id AS author_id_4, t0.language_id AS language_id_5 FROM author_translation t0 WHERE t0.author_id = ?

[
  6
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.biography AS biography_3,
  t0.author_id AS author_id_4,
  t0.language_id AS language_id_5
FROM
  author_translation t0
WHERE
  t0.author_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.biography AS biography_3, t0.author_id AS author_id_4, t0.language_id AS language_id_5 FROM author_translation t0 WHERE t0.author_id = 6;

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM language t0 WHERE t0.id = ?

[
  6
]

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3
FROM
  language t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM language t0 WHERE t0.id = 6;

SELECT t0.id AS id_1, t0.content AS content_2, t0.title AS title_3, t0.quote_id AS quote_id_4, t0.language_id AS language_id_5 FROM quote_translation t0 WHERE t0.quote_id = ?

[
  3
]

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.title AS title_3,
  t0.quote_id AS quote_id_4,
  t0.language_id AS language_id_5
FROM
  quote_translation t0
WHERE
  t0.quote_id = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.title AS title_3, t0.quote_id AS quote_id_4, t0.language_id AS language_id_5 FROM quote_translation t0 WHERE t0.quote_id = 3;

SELECT t0.id AS id_1, t0.content AS content_2, t0.title AS title_3, t0.quote_id AS quote_id_4, t0.language_id AS language_id_5 FROM quote_translation t0 WHERE t0.quote_id = ?

[
  6
]

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.title AS title_3,
  t0.quote_id AS quote_id_4,
  t0.language_id AS language_id_5
FROM
  quote_translation t0
WHERE
  t0.quote_id = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.title AS title_3, t0.quote_id AS quote_id_4, t0.language_id AS language_id_5 FROM quote_translation t0 WHERE t0.quote_id = 6;