Symfony Profiler

SELECT
  t0_.id AS id_0,
  t0_.status AS status_1,
  t0_.modality AS modality_2,
  t0_.level AS level_3,
  t0_.image_key AS image_key_4,
  t0_.price_cents AS price_cents_5,
  t0_.currency AS currency_6,
  t0_.duration_hours AS duration_hours_7,
  t0_.published_at AS published_at_8,
  t0_.created_at AS created_at_9,
  t0_.updated_at AS updated_at_10,
  t1_.id AS id_11,
  t1_.locale AS locale_12,
  t1_.title AS title_13,
  t1_.slug AS slug_14,
  t1_.summary AS summary_15,
  t1_.content AS content_16,
  t2_.id AS id_17,
  t2_.name AS name_18,
  t2_.logo_key AS logo_key_19,
  t3_.id AS id_20,
  t4_.id AS id_21,
  t4_.name AS name_22,
  t4_.photo_key AS photo_key_23,
  t5_.id AS id_24,
  t5_.locale AS locale_25,
  t5_.bio AS bio_26,
  t0_.institution_id AS institution_id_27,
  t1_.course_id AS course_id_28,
  t4_.profession_id AS profession_id_29,
  t5_.instructor_id AS instructor_id_30
FROM
  training_courses t0_
  INNER JOIN training_course_translations t1_ ON t0_.id = t1_.course_id
  LEFT JOIN training_institutions t2_ ON t0_.institution_id = t2_.id
  LEFT JOIN training_course_specialties t6_ ON t0_.id = t6_.course_id
  LEFT JOIN training_specialties t3_ ON t3_.id = t6_.specialty_id
  LEFT JOIN training_course_instructors t7_ ON t0_.id = t7_.course_id
  LEFT JOIN training_instructors t4_ ON t4_.id = t7_.instructor_id
  LEFT JOIN training_instructor_translations t5_ ON t4_.id = t5_.instructor_id
WHERE
  t0_.status = ?
  AND t1_.slug = ?

SELECT t0_.id AS id_0, t0_.status AS status_1, t0_.modality AS modality_2, t0_.level AS level_3, t0_.image_key AS image_key_4, t0_.price_cents AS price_cents_5, t0_.currency AS currency_6, t0_.duration_hours AS duration_hours_7, t0_.published_at AS published_at_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, t1_.id AS id_11, t1_.locale AS locale_12, t1_.title AS title_13, t1_.slug AS slug_14, t1_.summary AS summary_15, t1_.content AS content_16, t2_.id AS id_17, t2_.name AS name_18, t2_.logo_key AS logo_key_19, t3_.id AS id_20, t4_.id AS id_21, t4_.name AS name_22, t4_.photo_key AS photo_key_23, t5_.id AS id_24, t5_.locale AS locale_25, t5_.bio AS bio_26, t0_.institution_id AS institution_id_27, t1_.course_id AS course_id_28, t4_.profession_id AS profession_id_29, t5_.instructor_id AS instructor_id_30 FROM training_courses t0_ INNER JOIN training_course_translations t1_ ON t0_.id = t1_.course_id LEFT JOIN training_institutions t2_ ON t0_.institution_id = t2_.id LEFT JOIN training_course_specialties t6_ ON t0_.id = t6_.course_id LEFT JOIN training_specialties t3_ ON t3_.id = t6_.specialty_id LEFT JOIN training_course_instructors t7_ ON t0_.id = t7_.course_id LEFT JOIN training_instructors t4_ ON t4_.id = t7_.instructor_id LEFT JOIN training_instructor_translations t5_ ON t4_.id = t5_.instructor_id WHERE t0_.status = 'published' AND t1_.slug = 'oral-surgery-for-beginners';

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.name AS name_3,
  t0.specialty_id AS specialty_id_4
FROM
  training_specialty_translations t0
WHERE
  t0.specialty_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.specialty_id AS specialty_id_4 FROM training_specialty_translations t0 WHERE t0.specialty_id = 0x01A05FB6CC2C7473A90144EBBE5ABA7A;