Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.color AS color_2
FROM
  training_specialties t0

SELECT t0.id AS id_1, t0.color AS color_2 FROM training_specialties t0;

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

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

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

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,
  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 = 0x01A0FA4883227D5E8F2D8B507CD10E7E;

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,
  t4_.color AS color_34,
  t0_.predominant_specialty_id AS predominant_specialty_id_35,
  t0_.institution_id AS institution_id_36,
  t1_.workshop_id AS workshop_id_37
FROM
  training_workshops t0_
  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 t5_ ON t0_.id = t5_.workshop_id
  LEFT JOIN training_specialties t3_ ON t3_.id = t5_.specialty_id
  LEFT JOIN training_specialties t4_ ON t0_.predominant_specialty_id = t4_.id
WHERE
  t0_.status = ?
  AND t3_.id = ?
ORDER BY
  t0_.published_at DESC

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, t4_.color AS color_34, t0_.predominant_specialty_id AS predominant_specialty_id_35, t0_.institution_id AS institution_id_36, t1_.workshop_id AS workshop_id_37 FROM training_workshops t0_ 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 t5_ ON t0_.id = t5_.workshop_id LEFT JOIN training_specialties t3_ ON t3_.id = t5_.specialty_id LEFT JOIN training_specialties t4_ ON t0_.predominant_specialty_id = t4_.id WHERE t0_.status = 'published' AND t3_.id = 0x01A0FA4883227D5E8F2D8B507CD10E7E ORDER BY t0_.published_at DESC;

SELECT
  t0_.id AS id_0,
  t0_.color AS color_1,
  t1_.id AS id_2,
  t1_.locale AS locale_3,
  t1_.name AS name_4,
  t1_.specialty_id AS specialty_id_5
FROM
  training_specialties t0_
  LEFT JOIN training_specialty_translations t1_ ON t0_.id = t1_.specialty_id

SELECT t0_.id AS id_0, t0_.color AS color_1, t1_.id AS id_2, t1_.locale AS locale_3, t1_.name AS name_4, t1_.specialty_id AS specialty_id_5 FROM training_specialties t0_ LEFT JOIN training_specialty_translations t1_ ON t0_.id = t1_.specialty_id;

SELECT
  DISTINCT t0_.city AS city_0
FROM
  training_workshops t1_
  INNER JOIN training_institutions t0_ ON t1_.institution_id = t0_.id
WHERE
  t1_.status = ?
  AND t0_.city IS NOT NULL
  AND t0_.city <> ''
ORDER BY
  city_0 ASC

SELECT DISTINCT t0_.city AS city_0 FROM training_workshops t1_ INNER JOIN training_institutions t0_ ON t1_.institution_id = t0_.id WHERE t1_.status = 'published' AND t0_.city IS NOT NULL AND t0_.city <> '' ORDER BY city_0 ASC;

SELECT
  t0.id AS id_1,
  t0.image_key AS image_key_2,
  t0.icon_key AS icon_key_3,
  t0.texts AS texts_4
FROM
  training_formations_page_settings t0
LIMIT
  1

SELECT t0.id AS id_1, t0.image_key AS image_key_2, t0.icon_key AS icon_key_3, t0.texts AS texts_4 FROM training_formations_page_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 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;