Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.created_at AS created_at_1,
  s0_.is_enable AS is_enable_2,
  s0_.is_display AS is_display_3,
  s0_.ref_suffix AS ref_suffix_4,
  s0_.bg_color AS bg_color_5,
  s0_.position AS position_6,
  s0_.survey_color AS survey_color_7,
  t1_.id AS id_8,
  t1_.ref_id AS ref_id_9,
  t1_.value_text AS value_text_10,
  t2_.id AS id_11,
  t2_.ref_id AS ref_id_12,
  t2_.value_text AS value_text_13,
  m3_.id AS id_14,
  m3_.file AS file_15,
  m3_.path AS path_16,
  m3_.title AS title_17,
  m3_.extension AS extension_18
FROM
  survey s0_
  LEFT JOIN translation_specific t1_ ON (
    t1_.fk IN (?)
    AND t1_.language_id = ?
    AND t1_.ref_id = s0_.id
  )
  LEFT JOIN translation_specific t2_ ON (
    t2_.fk IN (?)
    AND t2_.language_id = ?
    AND t2_.ref_id = s0_.id
  )
  LEFT JOIN translation_specific t4_ ON (
    t4_.fk IN (?)
    AND t4_.ref_id = s0_.id
    AND t4_.language_id = ?
  )
  LEFT JOIN media m3_ ON (
    m3_.origin = ?
    AND m3_.id_origin = t4_.id
  )
WHERE
  s0_.deleted_at IS NULL
  AND s0_.is_enable = ?
  AND m3_.deleted_at IS NULL
ORDER BY
  s0_.position ASC

SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.is_enable AS is_enable_2, s0_.is_display AS is_display_3, s0_.ref_suffix AS ref_suffix_4, s0_.bg_color AS bg_color_5, s0_.position AS position_6, s0_.survey_color AS survey_color_7, t1_.id AS id_8, t1_.ref_id AS ref_id_9, t1_.value_text AS value_text_10, t2_.id AS id_11, t2_.ref_id AS ref_id_12, t2_.value_text AS value_text_13, m3_.id AS id_14, m3_.file AS file_15, m3_.path AS path_16, m3_.title AS title_17, m3_.extension AS extension_18 FROM survey s0_ LEFT JOIN translation_specific t1_ ON (t1_.fk IN ('survey.label') AND t1_.language_id = 1 AND t1_.ref_id = s0_.id) LEFT JOIN translation_specific t2_ ON (t2_.fk IN ('survey.description') AND t2_.language_id = 1 AND t2_.ref_id = s0_.id) LEFT JOIN translation_specific t4_ ON (t4_.fk IN ('survey.vignette_form_request') AND t4_.ref_id = s0_.id AND t4_.language_id = 1) LEFT JOIN media m3_ ON (m3_.origin = 'App\\Entity\\TranslationSpecific' AND m3_.id_origin = t4_.id) WHERE s0_.deleted_at IS NULL AND s0_.is_enable = 1 AND m3_.deleted_at IS NULL ORDER BY s0_.position ASC;

SELECT
  t0_.id AS id_0,
  t0_.fk AS fk_1,
  t0_.ref_id AS ref_id_2,
  t0_.value_text AS value_text_3,
  t0_.language_id AS language_id_4
FROM
  translation_specific t0_
  LEFT JOIN languages l1_ ON t0_.language_id = l1_.id
WHERE
  t0_.fk IN (?, ?)
  AND t0_.ref_id = ?

SELECT t0_.id AS id_0, t0_.fk AS fk_1, t0_.ref_id AS ref_id_2, t0_.value_text AS value_text_3, t0_.language_id AS language_id_4 FROM translation_specific t0_ LEFT JOIN languages l1_ ON t0_.language_id = l1_.id WHERE t0_.fk IN ('page_content.pdfGuide', 'page_content.bannerPc') AND t0_.ref_id = '1';

SELECT
  t0_.id AS id_0,
  t0_.fk AS fk_1,
  t0_.ref_id AS ref_id_2,
  t0_.value_text AS value_text_3
FROM
  translation_specific t0_
  LEFT JOIN languages l1_ ON t0_.language_id = l1_.id
WHERE
  l1_.id = ?
  AND t0_.fk IN (?, ?, ?, ?)
  AND t0_.ref_id = ?

SELECT t0_.id AS id_0, t0_.fk AS fk_1, t0_.ref_id AS ref_id_2, t0_.value_text AS value_text_3 FROM translation_specific t0_ LEFT JOIN languages l1_ ON t0_.language_id = l1_.id WHERE l1_.id = 1 AND t0_.fk IN ('page_content.textIssueDescription', 'page_content.linkConditions', 'page_content.textFileDescription', 'page_content.lastPageText') AND t0_.ref_id = '1';

SELECT
  m0_.id AS id_0,
  m0_.origin AS origin_1,
  m0_.id_origin AS id_origin_2,
  m0_.file AS file_3,
  m0_.title AS title_4,
  m0_.extension AS extension_5,
  m0_.taille AS taille_6,
  m0_.deleted_at AS deleted_at_7,
  m0_.type_media AS type_media_8,
  m0_.position AS position_9,
  m0_.path AS path_10,
  l1_.id AS id_11
FROM
  media m0_
  LEFT JOIN translation_specific t2_ ON (t2_.id = m0_.id_origin)
  LEFT JOIN languages l1_ ON t2_.language_id = l1_.id
WHERE
  (
    m0_.origin = ?
    AND m0_.id_origin IN (?)
    AND t2_.language_id = ?
  )
  OR (
    m0_.origin = ?
    AND m0_.id_origin IN (?)
    AND t2_.language_id = ?
  )
  OR (
    m0_.origin = ?
    AND m0_.id_origin IN (?)
    AND t2_.language_id = ?
  )
  OR (
    m0_.origin = ?
    AND m0_.id_origin IN (?)
    AND t2_.language_id = ?
  )

SELECT m0_.id AS id_0, m0_.origin AS origin_1, m0_.id_origin AS id_origin_2, m0_.file AS file_3, m0_.title AS title_4, m0_.extension AS extension_5, m0_.taille AS taille_6, m0_.deleted_at AS deleted_at_7, m0_.type_media AS type_media_8, m0_.position AS position_9, m0_.path AS path_10, l1_.id AS id_11 FROM media m0_ LEFT JOIN translation_specific t2_ ON (t2_.id = m0_.id_origin) LEFT JOIN languages l1_ ON t2_.language_id = l1_.id WHERE (m0_.origin = 'App\\Entity\\TranslationSpecific' AND m0_.id_origin IN (855) AND t2_.language_id = 1) OR (m0_.origin = 'App\\Entity\\TranslationSpecific' AND m0_.id_origin IN (856) AND t2_.language_id = 1) OR (m0_.origin = 'App\\Entity\\TranslationSpecific' AND m0_.id_origin IN (857) AND t2_.language_id = 1) OR (m0_.origin = 'App\\Entity\\TranslationSpecific' AND m0_.id_origin IN (858) AND t2_.language_id = 1);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.is_default AS is_default_4,
  t0.label AS label_5,
  t0.flag_image AS flag_image_6,
  t0.is_off AS is_off_7,
  t0.is_enable AS is_enable_8,
  t0.code_local AS code_local_9
FROM
  languages t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_default AS is_default_4, t0.label AS label_5, t0.flag_image AS flag_image_6, t0.is_off AS is_off_7, t0.is_enable AS is_enable_8, t0.code_local AS code_local_9 FROM languages t0 WHERE t0.code = 'fr' LIMIT 1;

SELECT
  l0_.id AS id_0,
  l0_.is_off AS is_off_1,
  l0_.label AS label_2,
  l0_.flag_image AS flag_image_3,
  l0_.code AS code_4,
  l0_.name AS name_5
FROM
  languages l0_
WHERE
  l0_.is_enable = ?

SELECT l0_.id AS id_0, l0_.is_off AS is_off_1, l0_.label AS label_2, l0_.flag_image AS flag_image_3, l0_.code AS code_4, l0_.name AS name_5 FROM languages l0_ WHERE l0_.is_enable = 1;