Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.label AS label_2, t0.canonical AS canonical_3, t0.chapter AS chapter_4, t0.refImg AS refImg_5, t0.explaination AS explaination_6, t0.updated AS updated_7, t0.topic_id AS topic_id_8, t9.care AS care_10, t9.question_id AS question_id_11, t9.user_id AS user_id_12, t13.good AS good_14, t13.wrong AS wrong_15, t13.total AS total_16, t13.question_id AS question_id_17, t13.user_id AS user_id_18 FROM question t0 LEFT JOIN focus t9 ON t9.question_id = t0.id LEFT JOIN follow t13 ON t13.question_id = t0.id WHERE t0.topic_id = ?

[
  92
]

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.canonical AS canonical_3,
  t0.chapter AS chapter_4,
  t0.refImg AS refImg_5,
  t0.explaination AS explaination_6,
  t0.updated AS updated_7,
  t0.topic_id AS topic_id_8,
  t9.care AS care_10,
  t9.question_id AS question_id_11,
  t9.user_id AS user_id_12,
  t13.good AS good_14,
  t13.wrong AS wrong_15,
  t13.total AS total_16,
  t13.question_id AS question_id_17,
  t13.user_id AS user_id_18
FROM
  question t0
  LEFT JOIN focus t9 ON t9.question_id = t0.id
  LEFT JOIN follow t13 ON t13.question_id = t0.id
WHERE
  t0.topic_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.canonical AS canonical_3, t0.chapter AS chapter_4, t0.refImg AS refImg_5, t0.explaination AS explaination_6, t0.updated AS updated_7, t0.topic_id AS topic_id_8, t9.care AS care_10, t9.question_id AS question_id_11, t9.user_id AS user_id_12, t13.good AS good_14, t13.wrong AS wrong_15, t13.total AS total_16, t13.question_id AS question_id_17, t13.user_id AS user_id_18 FROM question t0 LEFT JOIN focus t9 ON t9.question_id = t0.id LEFT JOIN follow t13 ON t13.question_id = t0.id WHERE t0.topic_id = 92;

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.public AS public_2, s0_.updated AS updated_3, s0_.source_id AS source_id_4 FROM subject s0_ INNER JOIN source s1_ ON s0_.source_id = s1_.id INNER JOIN topic t2_ ON s0_.id = t2_.subject_id LEFT JOIN subject_user s4_ ON s0_.id = s4_.subject_id LEFT JOIN fos_user f3_ ON f3_.id = s4_.user_id WHERE s1_.id = ? AND (s0_.public = 1 OR (s0_.public = 0 AND f3_.id = ?))

[
  "4"
  null
]

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.public AS public_2,
  s0_.updated AS updated_3,
  s0_.source_id AS source_id_4
FROM
  subject s0_
  INNER JOIN source s1_ ON s0_.source_id = s1_.id
  INNER JOIN topic t2_ ON s0_.id = t2_.subject_id
  LEFT JOIN subject_user s4_ ON s0_.id = s4_.subject_id
  LEFT JOIN fos_user f3_ ON f3_.id = s4_.user_id
WHERE
  s1_.id = ?
  AND (
    s0_.public = 1
    OR (
      s0_.public = 0
      AND f3_.id = ?
    )
  )

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.public AS public_2, s0_.updated AS updated_3, s0_.source_id AS source_id_4 FROM subject s0_ INNER JOIN source s1_ ON s0_.source_id = s1_.id INNER JOIN topic t2_ ON s0_.id = t2_.subject_id LEFT JOIN subject_user s4_ ON s0_.id = s4_.subject_id LEFT JOIN fos_user f3_ ON f3_.id = s4_.user_id WHERE s1_.id = '4' AND (s0_.public = 1 OR (s0_.public = 0 AND f3_.id = NULL));

SELECT t0.id AS id_1, t0.name AS name_2, t0.public AS public_3, t0.updated AS updated_4, t0.sortBy AS sortBy_5 FROM source t0 WHERE t0.id = ? ORDER BY t0.sortBy ASC LIMIT 1

[
  "4"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.public AS public_3,
  t0.updated AS updated_4,
  t0.sortBy AS sortBy_5
FROM
  source t0
WHERE
  t0.id = ?
ORDER BY
  t0.sortBy ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.public AS public_3, t0.updated AS updated_4, t0.sortBy AS sortBy_5 FROM source t0 WHERE t0.id = '4' ORDER BY t0.sortBy ASC LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.updated AS updated_3, t0.subject_id AS subject_id_4 FROM topic t0 WHERE t0.subject_id = ?

[
  17
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.updated AS updated_3,
  t0.subject_id AS subject_id_4
FROM
  topic t0
WHERE
  t0.subject_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.updated AS updated_3, t0.subject_id AS subject_id_4 FROM topic t0 WHERE t0.subject_id = 17;