Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• 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.birth_date AS birth_date_5, t0.death_date AS death_date_6, t0.old_tag_id AS old_tag_id_7, t0.image_path AS image_path_8, t0.is_translator AS is_translator_9, t0.created_by_id AS created_by_id_10, t11.id AS id_12, t11.quote_translation_count AS quote_translation_count_13, t11.book_translation_count AS book_translation_count_14, t11.total_votes_received AS total_votes_received_15, t11.positive_votes_received AS positive_votes_received_16, t11.average_rating AS average_rating_17, t11.first_translation_date AS first_translation_date_18, t11.last_translation_date AS last_translation_date_19, t11.last_calculated_at AS last_calculated_at_20, t11.translator_id AS translator_id_21 FROM author t0 LEFT JOIN translator_statistics t11 ON t11.translator_id = t0.id WHERE t0.id = ?

[
  "45"
]

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.birth_date AS birth_date_5,
  t0.death_date AS death_date_6,
  t0.old_tag_id AS old_tag_id_7,
  t0.image_path AS image_path_8,
  t0.is_translator AS is_translator_9,
  t0.created_by_id AS created_by_id_10,
  t11.id AS id_12,
  t11.quote_translation_count AS quote_translation_count_13,
  t11.book_translation_count AS book_translation_count_14,
  t11.total_votes_received AS total_votes_received_15,
  t11.positive_votes_received AS positive_votes_received_16,
  t11.average_rating AS average_rating_17,
  t11.first_translation_date AS first_translation_date_18,
  t11.last_translation_date AS last_translation_date_19,
  t11.last_calculated_at AS last_calculated_at_20,
  t11.translator_id AS translator_id_21
FROM
  author t0
  LEFT JOIN translator_statistics t11 ON t11.translator_id = t0.id
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.birth_date AS birth_date_5, t0.death_date AS death_date_6, t0.old_tag_id AS old_tag_id_7, t0.image_path AS image_path_8, t0.is_translator AS is_translator_9, t0.created_by_id AS created_by_id_10, t11.id AS id_12, t11.quote_translation_count AS quote_translation_count_13, t11.book_translation_count AS book_translation_count_14, t11.total_votes_received AS total_votes_received_15, t11.positive_votes_received AS positive_votes_received_16, t11.average_rating AS average_rating_17, t11.first_translation_date AS first_translation_date_18, t11.last_translation_date AS last_translation_date_19, t11.last_calculated_at AS last_calculated_at_20, t11.translator_id AS translator_id_21 FROM author t0 LEFT JOIN translator_statistics t11 ON t11.translator_id = t0.id WHERE t0.id = '45';

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.native_name AS native_name_4 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,
  t0.native_name AS native_name_4
FROM
  language t0
WHERE
  t0.code = ?
LIMIT
  1

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

SELECT b0_.id AS id_0, b0_.created_at AS created_at_1, b0_.updated_at AS updated_at_2, b0_.deleted_at AS deleted_at_3, b0_.author_id AS author_id_4, b0_.created_by_id AS created_by_id_5 FROM book b0_ WHERE b0_.author_id = ? AND b0_.deleted_at IS NULL ORDER BY b0_.created_at DESC

[
  45
]

SELECT
  b0_.id AS id_0,
  b0_.created_at AS created_at_1,
  b0_.updated_at AS updated_at_2,
  b0_.deleted_at AS deleted_at_3,
  b0_.author_id AS author_id_4,
  b0_.created_by_id AS created_by_id_5
FROM
  book b0_
WHERE
  b0_.author_id = ?
  AND b0_.deleted_at IS NULL
ORDER BY
  b0_.created_at DESC

SELECT b0_.id AS id_0, b0_.created_at AS created_at_1, b0_.updated_at AS updated_at_2, b0_.deleted_at AS deleted_at_3, b0_.author_id AS author_id_4, b0_.created_by_id AS created_by_id_5 FROM book b0_ WHERE b0_.author_id = 45 AND b0_.deleted_at IS NULL ORDER BY b0_.created_at DESC;

SELECT COUNT(q0_.id) AS sclr_0 FROM quote q0_ WHERE q0_.author_id = ? AND q0_.deleted_at IS NULL

[
  45
]

SELECT
  COUNT(q0_.id) AS sclr_0
FROM
  quote q0_
WHERE
  q0_.author_id = ?
  AND q0_.deleted_at IS NULL

SELECT COUNT(q0_.id) AS sclr_0 FROM quote q0_ WHERE q0_.author_id = 45 AND q0_.deleted_at IS NULL;

SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2, l0_.native_name AS native_name_3 FROM language l0_ INNER JOIN quote_translation q1_ ON (q1_.language_id = l0_.id) INNER JOIN quote q2_ ON q1_.quote_id = q2_.id WHERE q2_.deleted_at IS NULL GROUP BY l0_.id ORDER BY l0_.name ASC

[]

SELECT
  l0_.id AS id_0,
  l0_.code AS code_1,
  l0_.name AS name_2,
  l0_.native_name AS native_name_3
FROM
  language l0_
  INNER JOIN quote_translation q1_ ON (q1_.language_id = l0_.id)
  INNER JOIN quote q2_ ON q1_.quote_id = q2_.id
WHERE
  q2_.deleted_at IS NULL
GROUP BY
  l0_.id
ORDER BY
  l0_.name ASC

SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2, l0_.native_name AS native_name_3 FROM language l0_ INNER JOIN quote_translation q1_ ON (q1_.language_id = l0_.id) INNER JOIN quote q2_ ON q1_.quote_id = q2_.id WHERE q2_.deleted_at IS NULL GROUP BY l0_.id ORDER BY l0_.name ASC;

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 = ?

[
  45
]

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 = 45;