Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 2
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 1
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT s0_.code AS code_0, s0_.text AS text_1, s0_.trailer AS trailer_2, s0_.thumbnail AS thumbnail_3, s0_.duration AS duration_4, s0_.order_by AS order_by_5, c1_.id AS id_6, c1_.display_order AS display_order_7, c1_.code AS code_8, c1_.slug AS slug_9, c1_.category AS category_10, c1_.title AS title_11, c1_.teacher AS teacher_12, c1_.description AS description_13, c1_.description_additional AS description_additional_14, c1_.description_mycourses AS description_mycourses_15, c1_.alert AS alert_16, c1_.slide_id AS slide_id_17, c1_.price AS price_18, c1_.price_discounted AS price_discounted_19, c1_.media_source AS media_source_20, c1_.enabled AS enabled_21, c1_.hidden AS hidden_22 FROM slides s0_ LEFT JOIN courses c1_ ON (c1_.slide_id = s0_.id) LEFT JOIN course_types c2_ ON c1_.course_type_id = c2_.id WHERE s0_.enabled = 1 AND c2_.name = ? ORDER BY s0_.order_by ASC

[
  "public"
]

SELECT
  s0_.code AS code_0,
  s0_.text AS text_1,
  s0_.trailer AS trailer_2,
  s0_.thumbnail AS thumbnail_3,
  s0_.duration AS duration_4,
  s0_.order_by AS order_by_5,
  c1_.id AS id_6,
  c1_.display_order AS display_order_7,
  c1_.code AS code_8,
  c1_.slug AS slug_9,
  c1_.category AS category_10,
  c1_.title AS title_11,
  c1_.teacher AS teacher_12,
  c1_.description AS description_13,
  c1_.description_additional AS description_additional_14,
  c1_.description_mycourses AS description_mycourses_15,
  c1_.alert AS alert_16,
  c1_.slide_id AS slide_id_17,
  c1_.price AS price_18,
  c1_.price_discounted AS price_discounted_19,
  c1_.media_source AS media_source_20,
  c1_.enabled AS enabled_21,
  c1_.hidden AS hidden_22
FROM
  slides s0_
  LEFT JOIN courses c1_ ON (c1_.slide_id = s0_.id)
  LEFT JOIN course_types c2_ ON c1_.course_type_id = c2_.id
WHERE
  s0_.enabled = 1
  AND c2_.name = ?
ORDER BY
  s0_.order_by ASC

SELECT s0_.code AS code_0, s0_.text AS text_1, s0_.trailer AS trailer_2, s0_.thumbnail AS thumbnail_3, s0_.duration AS duration_4, s0_.order_by AS order_by_5, c1_.id AS id_6, c1_.display_order AS display_order_7, c1_.code AS code_8, c1_.slug AS slug_9, c1_.category AS category_10, c1_.title AS title_11, c1_.teacher AS teacher_12, c1_.description AS description_13, c1_.description_additional AS description_additional_14, c1_.description_mycourses AS description_mycourses_15, c1_.alert AS alert_16, c1_.slide_id AS slide_id_17, c1_.price AS price_18, c1_.price_discounted AS price_discounted_19, c1_.media_source AS media_source_20, c1_.enabled AS enabled_21, c1_.hidden AS hidden_22 FROM slides s0_ LEFT JOIN courses c1_ ON (c1_.slide_id = s0_.id) LEFT JOIN course_types c2_ ON c1_.course_type_id = c2_.id WHERE s0_.enabled = 1 AND c2_.name = 'public' ORDER BY s0_.order_by ASC;

SELECT s0_.code AS code_0, s0_.text AS text_1, s0_.trailer AS trailer_2, s0_.thumbnail AS thumbnail_3, s0_.duration AS duration_4, s0_.order_by AS order_by_5, e1_.id AS id_6, e1_.slug AS slug_7, e1_.title AS title_8, e1_.status AS status_9, e1_.slide_id AS slide_id_10 FROM slides s0_ LEFT JOIN events e1_ ON (e1_.slide_id = s0_.id) WHERE s0_.enabled = 1 AND e1_.status = ? ORDER BY s0_.order_by ASC

[
  "active"
]

SELECT
  s0_.code AS code_0,
  s0_.text AS text_1,
  s0_.trailer AS trailer_2,
  s0_.thumbnail AS thumbnail_3,
  s0_.duration AS duration_4,
  s0_.order_by AS order_by_5,
  e1_.id AS id_6,
  e1_.slug AS slug_7,
  e1_.title AS title_8,
  e1_.status AS status_9,
  e1_.slide_id AS slide_id_10
FROM
  slides s0_
  LEFT JOIN events e1_ ON (e1_.slide_id = s0_.id)
WHERE
  s0_.enabled = 1
  AND e1_.status = ?
ORDER BY
  s0_.order_by ASC

SELECT s0_.code AS code_0, s0_.text AS text_1, s0_.trailer AS trailer_2, s0_.thumbnail AS thumbnail_3, s0_.duration AS duration_4, s0_.order_by AS order_by_5, e1_.id AS id_6, e1_.slug AS slug_7, e1_.title AS title_8, e1_.status AS status_9, e1_.slide_id AS slide_id_10 FROM slides s0_ LEFT JOIN events e1_ ON (e1_.slide_id = s0_.id) WHERE s0_.enabled = 1 AND e1_.status = 'active' ORDER BY s0_.order_by ASC;