Symfony Profiler

SELECT
  t0_.id AS id_0,
  t0_.status AS status_1,
  t0_.modality AS modality_2,
  t0_.image_key AS image_key_3,
  t0_.price_cents AS price_cents_4,
  t0_.currency AS currency_5,
  t0_.registration_email AS registration_email_6,
  t0_.registration_mode AS registration_mode_7,
  t0_.registration_url AS registration_url_8,
  t0_.video_url AS video_url_9,
  t0_.published_at AS published_at_10,
  t0_.created_at AS created_at_11,
  t0_.updated_at AS updated_at_12,
  t1_.id AS id_13,
  t1_.locale AS locale_14,
  t1_.title AS title_15,
  t1_.slug AS slug_16,
  t1_.subtitle AS subtitle_17,
  t1_.summary AS summary_18,
  t1_.description AS description_19,
  t1_.content_items AS content_items_20,
  t1_.learning_outcomes AS learning_outcomes_21,
  t1_.schedule AS schedule_22,
  t1_.registration_instructions AS registration_instructions_23,
  t2_.id AS id_24,
  t2_.name AS name_25,
  t2_.logo_key AS logo_key_26,
  t2_.city AS city_27,
  t2_.address AS address_28,
  t2_.maps_url AS maps_url_29,
  t2_.photo_key AS photo_key_30,
  t3_.id AS id_31,
  t3_.color AS color_32,
  t4_.id AS id_33,
  t5_.id AS id_34,
  t5_.role AS role_35,
  t5_.position AS position_36,
  t6_.id AS id_37,
  t6_.name AS name_38,
  t6_.photo_key AS photo_key_39,
  t6_.cv_url AS cv_url_40,
  t6_.linkedin_url AS linkedin_url_41,
  t6_.kind AS kind_42,
  t6_.detail_photo_key AS detail_photo_key_43,
  t7_.id AS id_44,
  t7_.locale AS locale_45,
  t7_.bio AS bio_46,
  t7_.curriculum AS curriculum_47,
  t0_.predominant_specialty_id AS predominant_specialty_id_48,
  t0_.institution_id AS institution_id_49,
  t1_.workshop_id AS workshop_id_50,
  t5_.workshop_id AS workshop_id_51,
  t5_.instructor_id AS instructor_id_52,
  t6_.profession_id AS profession_id_53,
  t7_.instructor_id AS instructor_id_54
FROM
  training_workshops t0_
  INNER JOIN training_workshop_translations t8_ ON t0_.id = t8_.workshop_id
  LEFT JOIN training_workshop_translations t1_ ON t0_.id = t1_.workshop_id
  LEFT JOIN training_institutions t2_ ON t0_.institution_id = t2_.id
  LEFT JOIN training_workshop_specialties t9_ ON t0_.id = t9_.workshop_id
  LEFT JOIN training_specialties t3_ ON t3_.id = t9_.specialty_id
  LEFT JOIN training_workshop_professional_profiles t10_ ON t0_.id = t10_.workshop_id
  LEFT JOIN training_professional_profiles t4_ ON t4_.id = t10_.professional_profile_id
  LEFT JOIN training_workshop_instructors t5_ ON t0_.id = t5_.workshop_id
  LEFT JOIN training_instructors t6_ ON t5_.instructor_id = t6_.id
  LEFT JOIN training_instructor_translations t7_ ON t6_.id = t7_.instructor_id
WHERE
  t0_.status = ?
  AND t8_.slug = ?
ORDER BY
  t5_.position ASC

SELECT t0_.id AS id_0, t0_.status AS status_1, t0_.modality AS modality_2, t0_.image_key AS image_key_3, t0_.price_cents AS price_cents_4, t0_.currency AS currency_5, t0_.registration_email AS registration_email_6, t0_.registration_mode AS registration_mode_7, t0_.registration_url AS registration_url_8, t0_.video_url AS video_url_9, t0_.published_at AS published_at_10, t0_.created_at AS created_at_11, t0_.updated_at AS updated_at_12, t1_.id AS id_13, t1_.locale AS locale_14, t1_.title AS title_15, t1_.slug AS slug_16, t1_.subtitle AS subtitle_17, t1_.summary AS summary_18, t1_.description AS description_19, t1_.content_items AS content_items_20, t1_.learning_outcomes AS learning_outcomes_21, t1_.schedule AS schedule_22, t1_.registration_instructions AS registration_instructions_23, t2_.id AS id_24, t2_.name AS name_25, t2_.logo_key AS logo_key_26, t2_.city AS city_27, t2_.address AS address_28, t2_.maps_url AS maps_url_29, t2_.photo_key AS photo_key_30, t3_.id AS id_31, t3_.color AS color_32, t4_.id AS id_33, t5_.id AS id_34, t5_.role AS role_35, t5_.position AS position_36, t6_.id AS id_37, t6_.name AS name_38, t6_.photo_key AS photo_key_39, t6_.cv_url AS cv_url_40, t6_.linkedin_url AS linkedin_url_41, t6_.kind AS kind_42, t6_.detail_photo_key AS detail_photo_key_43, t7_.id AS id_44, t7_.locale AS locale_45, t7_.bio AS bio_46, t7_.curriculum AS curriculum_47, t0_.predominant_specialty_id AS predominant_specialty_id_48, t0_.institution_id AS institution_id_49, t1_.workshop_id AS workshop_id_50, t5_.workshop_id AS workshop_id_51, t5_.instructor_id AS instructor_id_52, t6_.profession_id AS profession_id_53, t7_.instructor_id AS instructor_id_54 FROM training_workshops t0_ INNER JOIN training_workshop_translations t8_ ON t0_.id = t8_.workshop_id LEFT JOIN training_workshop_translations t1_ ON t0_.id = t1_.workshop_id LEFT JOIN training_institutions t2_ ON t0_.institution_id = t2_.id LEFT JOIN training_workshop_specialties t9_ ON t0_.id = t9_.workshop_id LEFT JOIN training_specialties t3_ ON t3_.id = t9_.specialty_id LEFT JOIN training_workshop_professional_profiles t10_ ON t0_.id = t10_.workshop_id LEFT JOIN training_professional_profiles t4_ ON t4_.id = t10_.professional_profile_id LEFT JOIN training_workshop_instructors t5_ ON t0_.id = t5_.workshop_id LEFT JOIN training_instructors t6_ ON t5_.instructor_id = t6_.id LEFT JOIN training_instructor_translations t7_ ON t6_.id = t7_.instructor_id WHERE t0_.status = 'published' AND t8_.slug = 'comprehensive-digital-workflow-in-restorative-dentistry' ORDER BY t5_.position ASC;

SELECT
  t0.id AS id_1,
  t0.image_key AS image_key_2,
  t0.texts AS texts_3
FROM
  training_registration_settings t0
LIMIT
  1

SELECT t0.id AS id_1, t0.image_key AS image_key_2, t0.texts AS texts_3 FROM training_registration_settings t0 LIMIT 1;

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 = 0x01A0FA48831178C4930D1A4AF0BA36DF;

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 = 0x01A0FA48831D7A1C8DB0B819961C6ECD;

SELECT
  t0.id AS id_1
FROM
  shared_professions t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1 FROM shared_professions t0 WHERE t0.id = 0x01A0FA487FE9767CA222A26AD6B3BD7B;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.name AS name_3,
  t0.profession_id AS profession_id_4
FROM
  shared_profession_translations t0
WHERE
  t0.profession_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.profession_id AS profession_id_4 FROM shared_profession_translations t0 WHERE t0.profession_id = 0x01A0FA487FE9767CA222A26AD6B3BD7B;

SELECT
  t0.id AS id_1,
  t0.texts AS texts_2,
  t0.contact_email AS contact_email_3,
  t0.contact_phone AS contact_phone_4
FROM
  content_footer_settings t0
LIMIT
  1

SELECT t0.id AS id_1, t0.texts AS texts_2, t0.contact_email AS contact_email_3, t0.contact_phone AS contact_phone_4 FROM content_footer_settings t0 LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.texts AS texts_1,
  c0_.position AS position_2,
  c1_.id AS id_3,
  c1_.texts AS texts_4,
  c1_.position AS position_5,
  c1_.destination AS destination_6,
  c1_.route_name AS route_name_7,
  c1_.external_url AS external_url_8,
  c1_.fragment AS fragment_9,
  c0_.footer_id AS footer_id_10,
  c1_.column_id AS column_id_11
FROM
  content_footer_columns c0_
  LEFT JOIN content_footer_links c1_ ON c0_.id = c1_.column_id
ORDER BY
  c0_.position ASC,
  c1_.position ASC

SELECT c0_.id AS id_0, c0_.texts AS texts_1, c0_.position AS position_2, c1_.id AS id_3, c1_.texts AS texts_4, c1_.position AS position_5, c1_.destination AS destination_6, c1_.route_name AS route_name_7, c1_.external_url AS external_url_8, c1_.fragment AS fragment_9, c0_.footer_id AS footer_id_10, c1_.column_id AS column_id_11 FROM content_footer_columns c0_ LEFT JOIN content_footer_links c1_ ON c0_.id = c1_.column_id ORDER BY c0_.position ASC, c1_.position ASC;

SELECT
  t0.id AS id_1,
  t0.icon_key AS icon_key_2,
  t0.url AS url_3,
  t0.label AS label_4,
  t0.position AS position_5,
  t0.footer_id AS footer_id_6
FROM
  content_footer_social_links t0
WHERE
  t0.footer_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.icon_key AS icon_key_2, t0.url AS url_3, t0.label AS label_4, t0.position AS position_5, t0.footer_id AS footer_id_6 FROM content_footer_social_links t0 WHERE t0.footer_id = 0x01A0FA48859677E0B601C7073FA368E8 ORDER BY t0.position ASC;

SELECT
  c0_.id AS id_0,
  c0_.document_key AS document_key_1,
  c0_.is_active AS is_active_2,
  c0_.texts AS texts_3
FROM
  content_legal_documents c0_
WHERE
  c0_.document_key = ?
  AND c0_.is_active = 1

SELECT c0_.id AS id_0, c0_.document_key AS document_key_1, c0_.is_active AS is_active_2, c0_.texts AS texts_3 FROM content_legal_documents c0_ WHERE c0_.document_key = 'legal_notice' AND c0_.is_active = 1;

SELECT
  c0_.id AS id_0,
  c0_.document_key AS document_key_1,
  c0_.is_active AS is_active_2,
  c0_.texts AS texts_3
FROM
  content_legal_documents c0_
WHERE
  c0_.document_key = ?
  AND c0_.is_active = 1

SELECT c0_.id AS id_0, c0_.document_key AS document_key_1, c0_.is_active AS is_active_2, c0_.texts AS texts_3 FROM content_legal_documents c0_ WHERE c0_.document_key = 'privacy_policy' AND c0_.is_active = 1;

SELECT
  c0_.id AS id_0,
  c0_.document_key AS document_key_1,
  c0_.is_active AS is_active_2,
  c0_.texts AS texts_3
FROM
  content_legal_documents c0_
WHERE
  c0_.document_key = ?
  AND c0_.is_active = 1

SELECT c0_.id AS id_0, c0_.document_key AS document_key_1, c0_.is_active AS is_active_2, c0_.texts AS texts_3 FROM content_legal_documents c0_ WHERE c0_.document_key = 'cookies_policy' AND c0_.is_active = 1;