Symfony Profiler

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

Query Metrics

SELECT c0_.id AS id_0, c0_.guid AS guid_1, c0_.code AS code_2, c0_.name AS name_3, c0_.months AS months_4, c0_.hours AS hours_5, c0_.status AS status_6, c0_.fee AS fee_7, c0_.eligibility AS eligibility_8, c0_.book AS book_9, c0_.file AS file_10, c0_.file_type AS file_type_11, c0_.old_id AS old_id_12, c0_.syllabus AS syllabus_13, c0_.description AS description_14, c0_.online_test AS online_test_15, c0_.page_body AS page_body_16, c0_.title AS title_17, c0_.keywords AS keywords_18, c0_.is_public AS is_public_19, c0_.job_opportunities AS job_opportunities_20 FROM course c0_ WHERE c0_.status = ? ORDER BY c0_.name ASC

[
  "a"
]

SELECT
  c0_.id AS id_0,
  c0_.guid AS guid_1,
  c0_.code AS code_2,
  c0_.name AS name_3,
  c0_.months AS months_4,
  c0_.hours AS hours_5,
  c0_.status AS status_6,
  c0_.fee AS fee_7,
  c0_.eligibility AS eligibility_8,
  c0_.book AS book_9,
  c0_.file AS file_10,
  c0_.file_type AS file_type_11,
  c0_.old_id AS old_id_12,
  c0_.syllabus AS syllabus_13,
  c0_.description AS description_14,
  c0_.online_test AS online_test_15,
  c0_.page_body AS page_body_16,
  c0_.title AS title_17,
  c0_.keywords AS keywords_18,
  c0_.is_public AS is_public_19,
  c0_.job_opportunities AS job_opportunities_20
FROM
  course c0_
WHERE
  c0_.status = ?
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.guid AS guid_1, c0_.code AS code_2, c0_.name AS name_3, c0_.months AS months_4, c0_.hours AS hours_5, c0_.status AS status_6, c0_.fee AS fee_7, c0_.eligibility AS eligibility_8, c0_.book AS book_9, c0_.file AS file_10, c0_.file_type AS file_type_11, c0_.old_id AS old_id_12, c0_.syllabus AS syllabus_13, c0_.description AS description_14, c0_.online_test AS online_test_15, c0_.page_body AS page_body_16, c0_.title AS title_17, c0_.keywords AS keywords_18, c0_.is_public AS is_public_19, c0_.job_opportunities AS job_opportunities_20 FROM course c0_ WHERE c0_.status = 'a' ORDER BY c0_.name ASC;

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.url AS url_7, t0.target AS target_8, t0.is_home AS is_home_9, t0.rank AS rank_10, t0.is_published AS is_published_11, t0.old_id AS old_id_12, t0.menu_id AS menu_id_13 FROM page t0 WHERE t0.menu_id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.body AS body_4,
  t0.keywords AS keywords_5,
  t0.description AS description_6,
  t0.url AS url_7,
  t0.target AS target_8,
  t0.is_home AS is_home_9,
  t0.rank AS rank_10,
  t0.is_published AS is_published_11,
  t0.old_id AS old_id_12,
  t0.menu_id AS menu_id_13
FROM
  page t0
WHERE
  t0.menu_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.url AS url_7, t0.target AS target_8, t0.is_home AS is_home_9, t0.rank AS rank_10, t0.is_published AS is_published_11, t0.old_id AS old_id_12, t0.menu_id AS menu_id_13 FROM page t0 WHERE t0.menu_id = 1;

SELECT c0_.id AS id_0, c0_.guid AS guid_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.course_id AS course_id_4, c0_.country_id AS country_id_5 FROM course_country c0_ INNER JOIN country c1_ ON c0_.country_id = c1_.id INNER JOIN course c2_ ON c0_.course_id = c2_.id WHERE c1_.is_active = ? AND c2_.status = ? AND c2_.is_public = ? ORDER BY c1_.name ASC

[
  1
  "a"
  1
]

SELECT
  c0_.id AS id_0,
  c0_.guid AS guid_1,
  c0_.created_at AS created_at_2,
  c0_.updated_at AS updated_at_3,
  c0_.course_id AS course_id_4,
  c0_.country_id AS country_id_5
FROM
  course_country c0_
  INNER JOIN country c1_ ON c0_.country_id = c1_.id
  INNER JOIN course c2_ ON c0_.course_id = c2_.id
WHERE
  c1_.is_active = ?
  AND c2_.status = ?
  AND c2_.is_public = ?
ORDER BY
  c1_.name ASC

SELECT c0_.id AS id_0, c0_.guid AS guid_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.course_id AS course_id_4, c0_.country_id AS country_id_5 FROM course_country c0_ INNER JOIN country c1_ ON c0_.country_id = c1_.id INNER JOIN course c2_ ON c0_.course_id = c2_.id WHERE c1_.is_active = 1 AND c2_.status = 'a' AND c2_.is_public = 1 ORDER BY c1_.name ASC;

SELECT t0.id AS id_1, t0.name AS name_2, t0.location AS location_3, t0.rank AS rank_4, t0.old_id AS old_id_5 FROM menu t0 WHERE t0.location = ? ORDER BY t0.rank ASC

[
  "top"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.location AS location_3,
  t0.rank AS rank_4,
  t0.old_id AS old_id_5
FROM
  menu t0
WHERE
  t0.location = ?
ORDER BY
  t0.rank ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.location AS location_3, t0.rank AS rank_4, t0.old_id AS old_id_5 FROM menu t0 WHERE t0.location = 'top' ORDER BY t0.rank ASC;