Symfony Profiler

SELECT
  f0_.id AS id_0,
  f0_.active AS active_1,
  f0_.deleted_at AS deleted_at_2,
  f1_.id AS id_3,
  f1_.active AS active_4,
  f1_.deleted_at AS deleted_at_5,
  f1_.faq_group_id AS faq_group_id_6
FROM
  faq_group f0_
  LEFT JOIN faq f1_ ON f0_.id = f1_.faq_group_id
WHERE
  (
    f0_.active = ?
    AND f1_.active = ?
    AND (
      EXISTS (
        SELECT
          1
        FROM
          faq_country f2_
        WHERE
          f2_.faq_id = f1_.id
          AND f2_.country_id IN (?)
      )
      OR (
        SELECT
          COUNT(*)
        FROM
          faq_country f2_
        WHERE
          f2_.faq_id = f1_.id
      ) = 0
    )
  )
  AND (f0_.deleted_at IS NULL)
ORDER BY
  f0_.id DESC

SELECT f0_.id AS id_0, f0_.active AS active_1, f0_.deleted_at AS deleted_at_2, f1_.id AS id_3, f1_.active AS active_4, f1_.deleted_at AS deleted_at_5, f1_.faq_group_id AS faq_group_id_6 FROM faq_group f0_ LEFT JOIN faq f1_ ON f0_.id = f1_.faq_group_id WHERE (f0_.active = 1 AND f1_.active = 1 AND (EXISTS (SELECT 1 FROM faq_country f2_ WHERE f2_.faq_id = f1_.id AND f2_.country_id IN (1)) OR (SELECT COUNT(*) FROM faq_country f2_ WHERE f2_.faq_id = f1_.id) = 0)) AND (f0_.deleted_at IS NULL) ORDER BY f0_.id DESC;

SELECT
  p0_.id AS id_0,
  p0_.deleted_at AS deleted_at_1,
  p1_.id AS id_2,
  p1_.content AS content_3,
  p1_.locale AS locale_4,
  p0_.page_id AS page_id_5,
  p0_.country_id AS country_id_6,
  p1_.translatable_id AS translatable_id_7
FROM
  page_data p0_
  LEFT JOIN page_data_translation p1_ ON p0_.id = p1_.translatable_id
WHERE
  (
    p0_.page_id = ?
    AND p0_.country_id = ?
    AND p1_.locale = ?
  )
  AND (p0_.deleted_at IS NULL)
LIMIT
  1

SELECT p0_.id AS id_0, p0_.deleted_at AS deleted_at_1, p1_.id AS id_2, p1_.content AS content_3, p1_.locale AS locale_4, p0_.page_id AS page_id_5, p0_.country_id AS country_id_6, p1_.translatable_id AS translatable_id_7 FROM page_data p0_ LEFT JOIN page_data_translation p1_ ON p0_.id = p1_.translatable_id WHERE (p0_.page_id = 14 AND p0_.country_id = 1 AND p1_.locale = 'en') AND (p0_.deleted_at IS NULL) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.question AS question_2,
  t0.answer AS answer_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  faq_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM faq_translation t0 WHERE t0.translatable_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  faq_group_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM faq_group_translation t0 WHERE t0.translatable_id = 1;

SELECT
  m0_.id AS id_0,
  m0_.deleted_at AS deleted_at_1,
  m0_.country_id AS country_id_2,
  m0_.template_id AS template_id_3,
  m0_.page_id AS page_id_4
FROM
  meta_data m0_
  LEFT JOIN meta_data_translation m1_ ON m0_.id = m1_.translatable_id
WHERE
  (
    m0_.page_id = ?
    AND m0_.country_id = ?
    AND m1_.locale = ?
  )
  AND (m0_.deleted_at IS NULL)
LIMIT
  1

SELECT m0_.id AS id_0, m0_.deleted_at AS deleted_at_1, m0_.country_id AS country_id_2, m0_.template_id AS template_id_3, m0_.page_id AS page_id_4 FROM meta_data m0_ LEFT JOIN meta_data_translation m1_ ON m0_.id = m1_.translatable_id WHERE (m0_.page_id = 14 AND m0_.country_id = 1 AND m1_.locale = 'en') AND (m0_.deleted_at IS NULL) LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.code AS code_1,
  p0_.active AS active_2,
  p0_.created_at AS created_at_3,
  p0_.updated_at AS updated_at_4,
  p0_.name AS name_5,
  p0_.deleted_at AS deleted_at_6,
  p0_.materialized_path AS materialized_path_7,
  p0_.template_id AS template_id_8
FROM
  page p0_
WHERE
  (
    p0_.code = ?
    AND p0_.active = ?
  )
  AND (p0_.deleted_at IS NULL)

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.active AS active_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.name AS name_5, p0_.deleted_at AS deleted_at_6, p0_.materialized_path AS materialized_path_7, p0_.template_id AS template_id_8 FROM page p0_ WHERE (p0_.code = 'privacy_and_security' AND p0_.active = 1) AND (p0_.deleted_at IS NULL);

SELECT
  c0_.id AS id_0,
  c0_.slug AS slug_1,
  c0_.locales AS locales_2,
  c0_.active AS active_3,
  c0_.code AS code_4,
  c0_.deleted_at AS deleted_at_5,
  c0_.currency_id AS currency_id_6
FROM
  country c0_
WHERE
  (c0_.slug = ?)
  AND (c0_.deleted_at IS NULL)

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.locales AS locales_2, c0_.active AS active_3, c0_.code AS code_4, c0_.deleted_at AS deleted_at_5, c0_.currency_id AS currency_id_6 FROM country c0_ WHERE (c0_.slug = 'RU') AND (c0_.deleted_at IS NULL);

SELECT
  m0_.id AS id_0,
  m0_.deleted_at AS deleted_at_1,
  m0_.country_id AS country_id_2,
  m0_.template_id AS template_id_3,
  m0_.page_id AS page_id_4
FROM
  meta_data m0_
  LEFT JOIN meta_data_translation m1_ ON m0_.id = m1_.translatable_id
WHERE
  (
    m0_.template_id = ?
    AND m0_.country_id = ?
    AND m1_.locale = ?
  )
  AND (m0_.deleted_at IS NULL)
LIMIT
  1

SELECT m0_.id AS id_0, m0_.deleted_at AS deleted_at_1, m0_.country_id AS country_id_2, m0_.template_id AS template_id_3, m0_.page_id AS page_id_4 FROM meta_data m0_ LEFT JOIN meta_data_translation m1_ ON m0_.id = m1_.translatable_id WHERE (m0_.template_id = 6 AND m0_.country_id = 1 AND m1_.locale = 'en') AND (m0_.deleted_at IS NULL) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.sign AS sign_3,
  t0.active AS active_4,
  t0.deleted_at AS deleted_at_5
FROM
  currency t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.code AS code_2, t0.sign AS sign_3, t0.active AS active_4, t0.deleted_at AS deleted_at_5 FROM currency t0 WHERE t0.id = 1 AND ((t0.deleted_at IS NULL));

SELECT
  c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.sign AS sign_2,
  c0_.active AS active_3,
  c0_.deleted_at AS deleted_at_4
FROM
  currency c0_
  LEFT JOIN country c1_ ON c0_.id = c1_.currency_id
  AND (c1_.deleted_at IS NULL)
WHERE
  (c1_.id = ?)
  AND (c0_.deleted_at IS NULL)
LIMIT
  1

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ LEFT JOIN country c1_ ON c0_.id = c1_.currency_id AND (c1_.deleted_at IS NULL) WHERE (c1_.id = 1) AND (c0_.deleted_at IS NULL) LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.slug AS slug_1,
  c0_.locales AS locales_2,
  c0_.active AS active_3,
  c0_.code AS code_4,
  c0_.deleted_at AS deleted_at_5,
  c0_.currency_id AS currency_id_6
FROM
  country c0_
WHERE
  (c0_.active = ?)
  AND (c0_.deleted_at IS NULL)

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.locales AS locales_2, c0_.active AS active_3, c0_.code AS code_4, c0_.deleted_at AS deleted_at_5, c0_.currency_id AS currency_id_6 FROM country c0_ WHERE (c0_.active = 1) AND (c0_.deleted_at IS NULL);