Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 11
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine 2
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Data Tables
• VichUploader
• Geocoder
• Elastica
• Configuration

Query Metrics

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?

[
  "8"
  "de"
  "App\Entity\CourseMainCategory"
]

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '8' AND e0_.locale = 'de' AND e0_.object_class = 'App\\Entity\\CourseMainCategory';

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.icon AS icon_4, c0_.active AS active_5, c0_.sort_order AS sort_order_6, c1_.id AS id_7, c1_.name AS name_8, c1_.slug AS slug_9, c1_.description AS description_10, c1_.active AS active_11, c1_.sort_order AS sort_order_12, c2_.id AS id_13, c2_.name AS name_14, c2_.slug AS slug_15, c2_.description AS description_16, c2_.icon AS icon_17, c2_.active AS active_18, c2_.sort_order AS sort_order_19, c1_.main_category_id AS main_category_id_20, c2_.sub_category_id AS sub_category_id_21 FROM course_main_category c0_ LEFT JOIN course_sub_category c1_ ON c0_.id = c1_.main_category_id AND (c1_.active = ?) LEFT JOIN course_topic c2_ ON c1_.id = c2_.sub_category_id AND (c2_.active = ?) WHERE c0_.active = ? ORDER BY c0_.sort_order ASC, c0_.name ASC, c1_.sort_order ASC, c1_.name ASC, c2_.sort_order ASC, c2_.name ASC

[
  1
  1
  1
]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.description AS description_3,
  c0_.icon AS icon_4,
  c0_.active AS active_5,
  c0_.sort_order AS sort_order_6,
  c1_.id AS id_7,
  c1_.name AS name_8,
  c1_.slug AS slug_9,
  c1_.description AS description_10,
  c1_.active AS active_11,
  c1_.sort_order AS sort_order_12,
  c2_.id AS id_13,
  c2_.name AS name_14,
  c2_.slug AS slug_15,
  c2_.description AS description_16,
  c2_.icon AS icon_17,
  c2_.active AS active_18,
  c2_.sort_order AS sort_order_19,
  c1_.main_category_id AS main_category_id_20,
  c2_.sub_category_id AS sub_category_id_21
FROM
  course_main_category c0_
  LEFT JOIN course_sub_category c1_ ON c0_.id = c1_.main_category_id
  AND (c1_.active = ?)
  LEFT JOIN course_topic c2_ ON c1_.id = c2_.sub_category_id
  AND (c2_.active = ?)
WHERE
  c0_.active = ?
ORDER BY
  c0_.sort_order ASC,
  c0_.name ASC,
  c1_.sort_order ASC,
  c1_.name ASC,
  c2_.sort_order ASC,
  c2_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.icon AS icon_4, c0_.active AS active_5, c0_.sort_order AS sort_order_6, c1_.id AS id_7, c1_.name AS name_8, c1_.slug AS slug_9, c1_.description AS description_10, c1_.active AS active_11, c1_.sort_order AS sort_order_12, c2_.id AS id_13, c2_.name AS name_14, c2_.slug AS slug_15, c2_.description AS description_16, c2_.icon AS icon_17, c2_.active AS active_18, c2_.sort_order AS sort_order_19, c1_.main_category_id AS main_category_id_20, c2_.sub_category_id AS sub_category_id_21 FROM course_main_category c0_ LEFT JOIN course_sub_category c1_ ON c0_.id = c1_.main_category_id AND (c1_.active = 1) LEFT JOIN course_topic c2_ ON c1_.id = c2_.sub_category_id AND (c2_.active = 1) WHERE c0_.active = 1 ORDER BY c0_.sort_order ASC, c0_.name ASC, c1_.sort_order ASC, c1_.name ASC, c2_.sort_order ASC, c2_.name ASC;

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.external_link AS external_link_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.user_id AS user_id_7, t0.company_id AS company_id_8, t0.course_main_image_library_id AS course_main_image_library_id_9, t0.main_category_id AS main_category_id_10, t0.sub_category_id AS sub_category_id_11, t0.topic_id AS topic_id_12 FROM my_course t0 ORDER BY t0.created_at DESC LIMIT 8

[]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.external_link AS external_link_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.user_id AS user_id_7,
  t0.company_id AS company_id_8,
  t0.course_main_image_library_id AS course_main_image_library_id_9,
  t0.main_category_id AS main_category_id_10,
  t0.sub_category_id AS sub_category_id_11,
  t0.topic_id AS topic_id_12
FROM
  my_course t0
ORDER BY
  t0.created_at DESC
LIMIT
  8

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.external_link AS external_link_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.user_id AS user_id_7, t0.company_id AS company_id_8, t0.course_main_image_library_id AS course_main_image_library_id_9, t0.main_category_id AS main_category_id_10, t0.sub_category_id AS sub_category_id_11, t0.topic_id AS topic_id_12 FROM my_course t0 ORDER BY t0.created_at DESC LIMIT 8;