Symfony Profiler

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
  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
FROM
  survey s0_
  LEFT JOIN translation_specific t1_ ON (
    t1_.fk IN (?)
    AND t1_.language_id = ?
    AND t1_.ref_id = s0_.id
  )
WHERE
  s0_.deleted_at IS NULL
  AND s0_.ref_suffix LIKE ?
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 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) WHERE s0_.deleted_at IS NULL AND s0_.ref_suffix LIKE 'whateva' ORDER BY s0_.position ASC;

SELECT
  v0_.id AS id_0,
  v0_.is_enable AS is_enable_1,
  v0_.is_display AS is_display_2,
  s1_.id AS id_3,
  o2_.id AS id_4,
  t3_.value_text AS value_text_5,
  t4_.value_text AS value_text_6,
  o5_.is_other AS is_other_7,
  o5_.id AS id_8,
  o5_.has_description AS has_description_9,
  o5_.has_file AS has_file_10,
  o5_.on_click_color_bg AS on_click_color_bg_11,
  o5_.on_click_color_text AS on_click_color_text_12,
  t6_.id AS id_13,
  t6_.ref_id AS ref_id_14,
  t6_.value_text AS value_text_15
FROM
  value_in_survey v0_
  LEFT JOIN option_in_survey o2_ ON v0_.option_in_survey_id = o2_.id
  LEFT JOIN option_value o5_ ON v0_.option_value_id = o5_.id
  LEFT JOIN `option` o7_ ON o5_.related_option_id = o7_.id
  LEFT JOIN survey s1_ ON o2_.survey_id = s1_.id
  LEFT JOIN translation_specific t6_ ON (
    t6_.fk IN (?)
    AND t6_.language_id = ?
    AND t6_.ref_id = o5_.id
  )
  LEFT JOIN translation_specific t3_ ON (
    t3_.fk IN (?)
    AND t3_.language_id = ?
    AND t3_.ref_id = o5_.id
  )
  LEFT JOIN translation_specific t4_ ON (
    t4_.fk IN (?)
    AND t4_.language_id = ?
    AND t4_.ref_id = o5_.id
  )
WHERE
  s1_.id = ?
  AND o5_.deleted_at IS NULL
  AND o2_.deleted_at IS NULL
  AND v0_.deleted_at IS NULL
  AND o2_.is_enable = ?
  AND o5_.is_enable = ?
  AND v0_.is_enable = ?
  AND o2_.is_display = ?
  AND v0_.is_display = ?
GROUP BY
  o2_.id,
  t6_.ref_id
ORDER BY
  v0_.position ASC

SELECT v0_.id AS id_0, v0_.is_enable AS is_enable_1, v0_.is_display AS is_display_2, s1_.id AS id_3, o2_.id AS id_4, t3_.value_text AS value_text_5, t4_.value_text AS value_text_6, o5_.is_other AS is_other_7, o5_.id AS id_8, o5_.has_description AS has_description_9, o5_.has_file AS has_file_10, o5_.on_click_color_bg AS on_click_color_bg_11, o5_.on_click_color_text AS on_click_color_text_12, t6_.id AS id_13, t6_.ref_id AS ref_id_14, t6_.value_text AS value_text_15 FROM value_in_survey v0_ LEFT JOIN option_in_survey o2_ ON v0_.option_in_survey_id = o2_.id LEFT JOIN option_value o5_ ON v0_.option_value_id = o5_.id LEFT JOIN `option` o7_ ON o5_.related_option_id = o7_.id LEFT JOIN survey s1_ ON o2_.survey_id = s1_.id LEFT JOIN translation_specific t6_ ON (t6_.fk IN ('option_value.label') AND t6_.language_id = 1 AND t6_.ref_id = o5_.id) LEFT JOIN translation_specific t3_ ON (t3_.fk IN ('option_value.checkbox_label') AND t3_.language_id = 1 AND t3_.ref_id = o5_.id) LEFT JOIN translation_specific t4_ ON (t4_.fk IN ('option_value.description') AND t4_.language_id = 1 AND t4_.ref_id = o5_.id) WHERE s1_.id = 20 AND o5_.deleted_at IS NULL AND o2_.deleted_at IS NULL AND v0_.deleted_at IS NULL AND o2_.is_enable = 1 AND o5_.is_enable = 1 AND v0_.is_enable = 1 AND o2_.is_display = 1 AND v0_.is_display = 1 GROUP BY o2_.id, t6_.ref_id ORDER BY v0_.position ASC;

SELECT
  o0_.id AS id_0,
  o0_.created_at AS created_at_1,
  o0_.is_enable AS is_enable_2,
  o0_.is_display AS is_display_3,
  c1_.id AS id_4,
  t2_.value_text AS value_text_5,
  t3_.value_text AS value_text_6,
  t4_.value_text AS value_text_7,
  o5_.type AS type_8,
  o5_.id AS id_9,
  o0_.deleted_at AS deleted_at_10,
  GROUP_CONCAT(
    CONCAT(
      COALESCE(t6_.value_text, ''),
      '=>',
      COALESCE(t7_.value_text, ''),
      '=>',
      c1_.id
    ) SEPARATOR '*****'
  ) AS sclr_11,
  GROUP_CONCAT(v8_.id SEPARATOR ',') AS sclr_12
FROM
  option_in_survey o0_
  LEFT JOIN survey s9_ ON o0_.survey_id = s9_.id
  LEFT JOIN `option` o5_ ON o0_.related_option_id = o5_.id
  LEFT JOIN translation_specific t4_ ON (
    t4_.fk IN (?)
    AND t4_.language_id = ?
    AND t4_.ref_id = o5_.id
  )
  LEFT JOIN translation_specific t2_ ON (
    t2_.fk IN (?)
    AND t2_.language_id = ?
    AND t2_.ref_id = s9_.id
  )
  LEFT JOIN conditionned_option c1_ ON o0_.id = c1_.result_option_in_survey_id
  LEFT JOIN option_in_survey o10_ ON c1_.result_option_in_survey_id = o10_.id
  AND (
    o10_.id = c1_.result_option_in_survey_id
    AND c1_.option_in_survey_id = o0_.id
  )
  LEFT JOIN `option` o11_ ON o10_.related_option_id = o11_.id
  LEFT JOIN translation_specific t3_ ON (
    t3_.fk IN (?)
    AND t3_.language_id = ?
    AND t3_.ref_id = o0_.id
  )
  LEFT JOIN value_in_survey v8_ ON c1_.choosen_value_in_survey_id = v8_.id
  AND (
    v8_.id = c1_.choosen_value_in_survey_id
  )
  LEFT JOIN option_value o12_ ON v8_.option_value_id = o12_.id
  LEFT JOIN translation_specific t6_ ON (
    t6_.fk IN (?)
    AND t6_.language_id = ?
    AND t6_.ref_id = o12_.id
  )
  LEFT JOIN option_in_survey o13_ ON c1_.option_in_survey_id = o13_.id
  LEFT JOIN `option` o14_ ON o13_.related_option_id = o14_.id
  LEFT JOIN translation_specific t7_ ON (
    t7_.fk IN (?)
    AND t7_.language_id = ?
    AND t7_.ref_id = o14_.id
  )
WHERE
  o0_.deleted_at IS NULL
  AND s9_.id = ?
  AND s9_.deleted_at IS NULL
  AND o0_.is_enable = ?
  AND o0_.is_display = ?
GROUP BY
  o0_.id

SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.is_enable AS is_enable_2, o0_.is_display AS is_display_3, c1_.id AS id_4, t2_.value_text AS value_text_5, t3_.value_text AS value_text_6, t4_.value_text AS value_text_7, o5_.type AS type_8, o5_.id AS id_9, o0_.deleted_at AS deleted_at_10, GROUP_CONCAT(CONCAT(COALESCE(t6_.value_text, ''), '=>', COALESCE(t7_.value_text, ''), '=>', c1_.id) SEPARATOR '*****') AS sclr_11, GROUP_CONCAT(v8_.id SEPARATOR ',') AS sclr_12 FROM option_in_survey o0_ LEFT JOIN survey s9_ ON o0_.survey_id = s9_.id LEFT JOIN `option` o5_ ON o0_.related_option_id = o5_.id LEFT JOIN translation_specific t4_ ON (t4_.fk IN ('option.label') AND t4_.language_id = 1 AND t4_.ref_id = o5_.id) LEFT JOIN translation_specific t2_ ON (t2_.fk IN ('survey.label') AND t2_.language_id = 1 AND t2_.ref_id = s9_.id) LEFT JOIN conditionned_option c1_ ON o0_.id = c1_.result_option_in_survey_id LEFT JOIN option_in_survey o10_ ON c1_.result_option_in_survey_id = o10_.id AND (o10_.id = c1_.result_option_in_survey_id AND c1_.option_in_survey_id = o0_.id) LEFT JOIN `option` o11_ ON o10_.related_option_id = o11_.id LEFT JOIN translation_specific t3_ ON (t3_.fk IN ('option.label') AND t3_.language_id = 1 AND t3_.ref_id = o0_.id) LEFT JOIN value_in_survey v8_ ON c1_.choosen_value_in_survey_id = v8_.id AND (v8_.id = c1_.choosen_value_in_survey_id) LEFT JOIN option_value o12_ ON v8_.option_value_id = o12_.id LEFT JOIN translation_specific t6_ ON (t6_.fk IN ('option_value.label') AND t6_.language_id = 1 AND t6_.ref_id = o12_.id) LEFT JOIN option_in_survey o13_ ON c1_.option_in_survey_id = o13_.id LEFT JOIN `option` o14_ ON o13_.related_option_id = o14_.id LEFT JOIN translation_specific t7_ ON (t7_.fk IN ('option.label') AND t7_.language_id = 1 AND t7_.ref_id = o14_.id) WHERE o0_.deleted_at IS NULL AND s9_.id = 20 AND s9_.deleted_at IS NULL AND o0_.is_enable = 1 AND o0_.is_display = 1 GROUP BY o0_.id;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.company AS company_3,
  t0.telephone AS telephone_4,
  t0.is_other_value AS is_other_value_5,
  t0.email AS email_6,
  t0.reference AS reference_7,
  t0.description_form AS description_form_8,
  t0.request_num AS request_num_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.language_id AS language_id_12,
  t0.request_status_id AS request_status_id_13,
  t0.survey_id AS survey_id_14,
  t0.support_user_id AS support_user_id_15
FROM
  request_form t0
WHERE
  t0.survey_id = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.company AS company_3, t0.telephone AS telephone_4, t0.is_other_value AS is_other_value_5, t0.email AS email_6, t0.reference AS reference_7, t0.description_form AS description_form_8, t0.request_num AS request_num_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.language_id AS language_id_12, t0.request_status_id AS request_status_id_13, t0.survey_id AS survey_id_14, t0.support_user_id AS support_user_id_15 FROM request_form t0 WHERE t0.survey_id = 20 ORDER BY t0.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.is_enable AS is_enable_2,
  t0.deleted_at AS deleted_at_3,
  t0.is_display AS is_display_4,
  t0.ref_suffix AS ref_suffix_5,
  t0.bg_color AS bg_color_6,
  t0.position AS position_7,
  t0.survey_color AS survey_color_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  survey t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_enable AS is_enable_2, t0.deleted_at AS deleted_at_3, t0.is_display AS is_display_4, t0.ref_suffix AS ref_suffix_5, t0.bg_color AS bg_color_6, t0.position AS position_7, t0.survey_color AS survey_color_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM survey t0 WHERE t0.id = 20 LIMIT 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
  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
  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
  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;