Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 16
• Events
• Routing
• Cache
• Translation 18
• 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.facebook_id AS facebook_id_3, t0.name AS name_4, t0.roles AS roles_5, t0.password AS password_6, t0.google_id AS google_id_7, t0.google_refresh_token AS google_refresh_token_8, t0.created_at AS created_at_9, t0.publicbooks AS publicbooks_10 FROM user t0 WHERE t0.id = ?

[
  19
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.facebook_id AS facebook_id_3,
  t0.name AS name_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.google_id AS google_id_7,
  t0.google_refresh_token AS google_refresh_token_8,
  t0.created_at AS created_at_9,
  t0.publicbooks AS publicbooks_10
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.facebook_id AS facebook_id_3, t0.name AS name_4, t0.roles AS roles_5, t0.password AS password_6, t0.google_id AS google_id_7, t0.google_refresh_token AS google_refresh_token_8, t0.created_at AS created_at_9, t0.publicbooks AS publicbooks_10 FROM user t0 WHERE t0.id = 19;

SELECT t0.id AS id_1, t0.email AS email_2, t0.facebook_id AS facebook_id_3, t0.name AS name_4, t0.roles AS roles_5, t0.password AS password_6, t0.google_id AS google_id_7, t0.google_refresh_token AS google_refresh_token_8, t0.created_at AS created_at_9, t0.publicbooks AS publicbooks_10 FROM user t0 WHERE t0.publicbooks = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.facebook_id AS facebook_id_3,
  t0.name AS name_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.google_id AS google_id_7,
  t0.google_refresh_token AS google_refresh_token_8,
  t0.created_at AS created_at_9,
  t0.publicbooks AS publicbooks_10
FROM
  user t0
WHERE
  t0.publicbooks = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.facebook_id AS facebook_id_3, t0.name AS name_4, t0.roles AS roles_5, t0.password AS password_6, t0.google_id AS google_id_7, t0.google_refresh_token AS google_refresh_token_8, t0.created_at AS created_at_9, t0.publicbooks AS publicbooks_10 FROM user t0 WHERE t0.publicbooks = 1;

SELECT COUNT(*) FROM book t0

[]

SELECT
  COUNT(*)
FROM
  book t0

SELECT COUNT(*) FROM book t0;

SELECT DISTINCT b0_.author AS author_0 FROM book b0_ WHERE b0_.author IS NOT NULL ORDER BY b0_.author ASC

[]

SELECT
  DISTINCT b0_.author AS author_0
FROM
  book b0_
WHERE
  b0_.author IS NOT NULL
ORDER BY
  b0_.author ASC

SELECT DISTINCT b0_.author AS author_0 FROM book b0_ WHERE b0_.author IS NOT NULL ORDER BY b0_.author ASC;

SELECT b0_.subjects AS subjects_0 FROM book b0_ WHERE b0_.subjects IS NOT NULL

[]

SELECT
  b0_.subjects AS subjects_0
FROM
  book b0_
WHERE
  b0_.subjects IS NOT NULL

SELECT b0_.subjects AS subjects_0 FROM book b0_ WHERE b0_.subjects IS NOT NULL;

SELECT DISTINCT b0_.language AS language_0 FROM book b0_ WHERE b0_.language IS NOT NULL ORDER BY b0_.language ASC

[]

SELECT
  DISTINCT b0_.language AS language_0
FROM
  book b0_
WHERE
  b0_.language IS NOT NULL
ORDER BY
  b0_.language ASC

SELECT DISTINCT b0_.language AS language_0 FROM book b0_ WHERE b0_.language IS NOT NULL ORDER BY b0_.language ASC;

SELECT u0_.id AS id_0, u0_.added_at AS added_at_1, u0_.notes AS notes_2, u0_.bookread AS bookread_3, b1_.isbn AS isbn_4, b1_.title AS title_5, b1_.author AS author_6, b1_.description AS description_7, b1_.image AS image_8, b1_.subjects AS subjects_9, b1_.pages AS pages_10, b1_.publishedyear AS publishedyear_11, b1_.binding AS binding_12, b1_.language AS language_13, b1_.author_lastname AS author_lastname_14, u0_.user_id AS user_id_15, u0_.book_isbn AS book_isbn_16 FROM user_book u0_ INNER JOIN book b1_ ON u0_.book_isbn = b1_.isbn WHERE u0_.user_id = ? ORDER BY b1_.author ASC

[
  19
]

SELECT
  u0_.id AS id_0,
  u0_.added_at AS added_at_1,
  u0_.notes AS notes_2,
  u0_.bookread AS bookread_3,
  b1_.isbn AS isbn_4,
  b1_.title AS title_5,
  b1_.author AS author_6,
  b1_.description AS description_7,
  b1_.image AS image_8,
  b1_.subjects AS subjects_9,
  b1_.pages AS pages_10,
  b1_.publishedyear AS publishedyear_11,
  b1_.binding AS binding_12,
  b1_.language AS language_13,
  b1_.author_lastname AS author_lastname_14,
  u0_.user_id AS user_id_15,
  u0_.book_isbn AS book_isbn_16
FROM
  user_book u0_
  INNER JOIN book b1_ ON u0_.book_isbn = b1_.isbn
WHERE
  u0_.user_id = ?
ORDER BY
  b1_.author ASC

SELECT u0_.id AS id_0, u0_.added_at AS added_at_1, u0_.notes AS notes_2, u0_.bookread AS bookread_3, b1_.isbn AS isbn_4, b1_.title AS title_5, b1_.author AS author_6, b1_.description AS description_7, b1_.image AS image_8, b1_.subjects AS subjects_9, b1_.pages AS pages_10, b1_.publishedyear AS publishedyear_11, b1_.binding AS binding_12, b1_.language AS language_13, b1_.author_lastname AS author_lastname_14, u0_.user_id AS user_id_15, u0_.book_isbn AS book_isbn_16 FROM user_book u0_ INNER JOIN book b1_ ON u0_.book_isbn = b1_.isbn WHERE u0_.user_id = 19 ORDER BY b1_.author ASC;

SELECT COUNT(*) FROM book t0

[]

SELECT
  COUNT(*)
FROM
  book t0

SELECT COUNT(*) FROM book t0;