Symfony Profiler

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

Query Metrics

SELECT COUNT(*) FROM product t0 WHERE t0.category = ?

[
  "Useful Guide"
]

SELECT
  COUNT(*)
FROM
  product t0
WHERE
  t0.category = ?

SELECT COUNT(*) FROM product t0 WHERE t0.category = 'Useful Guide';

SELECT l0_.id AS id_0, l0_.language AS language_1, l0_.abbreviation AS abbreviation_2, l0_.icon AS icon_3, l0_.is_active AS is_active_4, l0_.linked_in_other AS linked_in_other_5, l0_.ranking AS ranking_6 FROM languages l0_ WHERE l0_.is_active = 1 ORDER BY l0_.ranking ASC

[]

SELECT
  l0_.id AS id_0,
  l0_.language AS language_1,
  l0_.abbreviation AS abbreviation_2,
  l0_.icon AS icon_3,
  l0_.is_active AS is_active_4,
  l0_.linked_in_other AS linked_in_other_5,
  l0_.ranking AS ranking_6
FROM
  languages l0_
WHERE
  l0_.is_active = 1
ORDER BY
  l0_.ranking ASC

SELECT l0_.id AS id_0, l0_.language AS language_1, l0_.abbreviation AS abbreviation_2, l0_.icon AS icon_3, l0_.is_active AS is_active_4, l0_.linked_in_other AS linked_in_other_5, l0_.ranking AS ranking_6 FROM languages l0_ WHERE l0_.is_active = 1 ORDER BY l0_.ranking ASC;

SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.is_active = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.language AS language_2,
  t0.abbreviation AS abbreviation_3,
  t0.icon AS icon_4,
  t0.is_active AS is_active_5,
  t0.linked_in_other AS linked_in_other_6,
  t0.ranking AS ranking_7
FROM
  languages t0
WHERE
  t0.is_active = ?

SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.is_active = 1;

SELECT t0.id AS id_1, t0.product AS product_2, t0.ranking AS ranking_3, t0.is_active AS is_active_4, t0.include_in_footer AS include_in_footer_5, t0.category AS category_6, t0.include_in_contact_form AS include_in_contact_form_7, t0.notes AS notes_8, t0.new_client_email AS new_client_email_9, t0.menu_icon AS menu_icon_10, t0.menu_icon_colour AS menu_icon_colour_11, t0.helpful_guide_topic AS helpful_guide_topic_12 FROM product t0 WHERE t0.id = ?

[
  2
]

SELECT
  t0.id AS id_1,
  t0.product AS product_2,
  t0.ranking AS ranking_3,
  t0.is_active AS is_active_4,
  t0.include_in_footer AS include_in_footer_5,
  t0.category AS category_6,
  t0.include_in_contact_form AS include_in_contact_form_7,
  t0.notes AS notes_8,
  t0.new_client_email AS new_client_email_9,
  t0.menu_icon AS menu_icon_10,
  t0.menu_icon_colour AS menu_icon_colour_11,
  t0.helpful_guide_topic AS helpful_guide_topic_12
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.product AS product_2, t0.ranking AS ranking_3, t0.is_active AS is_active_4, t0.include_in_footer AS include_in_footer_5, t0.category AS category_6, t0.include_in_contact_form AS include_in_contact_form_7, t0.notes AS notes_8, t0.new_client_email AS new_client_email_9, t0.menu_icon AS menu_icon_10, t0.menu_icon_colour AS menu_icon_colour_11, t0.helpful_guide_topic AS helpful_guide_topic_12 FROM product t0 WHERE t0.id = 2;

SELECT t0.id AS id_1, t0.photo AS photo_2, t0.title AS title_3, t0.link AS link_4, t0.category AS category_5, t0.static_page_name AS static_page_name_6, t0.ranking AS ranking_7, t0.rotate AS rotate_8, t0.product_id AS product_id_9 FROM cms_photo t0 WHERE t0.id = ?

[
  15
]

SELECT
  t0.id AS id_1,
  t0.photo AS photo_2,
  t0.title AS title_3,
  t0.link AS link_4,
  t0.category AS category_5,
  t0.static_page_name AS static_page_name_6,
  t0.ranking AS ranking_7,
  t0.rotate AS rotate_8,
  t0.product_id AS product_id_9
FROM
  cms_photo t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.photo AS photo_2, t0.title AS title_3, t0.link AS link_4, t0.category AS category_5, t0.static_page_name AS static_page_name_6, t0.ranking AS ranking_7, t0.rotate AS rotate_8, t0.product_id AS product_id_9 FROM cms_photo t0 WHERE t0.id = 15;

SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.abbreviation = ? LIMIT 1

[
  "en"
]

SELECT
  t0.id AS id_1,
  t0.language AS language_2,
  t0.abbreviation AS abbreviation_3,
  t0.icon AS icon_4,
  t0.is_active AS is_active_5,
  t0.linked_in_other AS linked_in_other_6,
  t0.ranking AS ranking_7
FROM
  languages t0
WHERE
  t0.abbreviation = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.abbreviation = 'en' LIMIT 1;