Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.parent_id AS parent_id_1,
  p0_.web_id AS web_id_2,
  p0_.lang AS lang_3,
  p0_.url AS url_4,
  p0_.path AS path_5,
  p0_.canonical_url AS canonical_url_6,
  p0_.title AS title_7,
  p0_.meta_description AS meta_description_8,
  p0_.nodes AS nodes_9,
  p0_.level AS level_10,
  p0_.type AS type_11,
  p0_.position AS position_12,
  p0_.has_subpage AS has_subpage_13,
  p0_.has_sidebar AS has_sidebar_14,
  p0_.og_title AS og_title_15,
  p0_.og_description AS og_description_16,
  p0_.og_site_name AS og_site_name_17,
  p0_.og_url AS og_url_18,
  p0_.og_img AS og_img_19,
  p0_.tw_title AS tw_title_20,
  p0_.tw_description AS tw_description_21,
  p0_.tw_image AS tw_image_22,
  p0_.tw_card AS tw_card_23,
  p0_.tw_alt_image AS tw_alt_image_24,
  p0_.status AS status_25,
  p0_.created_at AS created_at_26,
  p0_.updated_at AS updated_at_27,
  p0_.created_by AS created_by_28
FROM
  pages p0_
WHERE
  p0_.path = ?
  AND p0_.status = 1
  AND (
    p0_.web_id = ?
    OR p0_.web_id LIKE ?
  )

SELECT p0_.id AS id_0, p0_.parent_id AS parent_id_1, p0_.web_id AS web_id_2, p0_.lang AS lang_3, p0_.url AS url_4, p0_.path AS path_5, p0_.canonical_url AS canonical_url_6, p0_.title AS title_7, p0_.meta_description AS meta_description_8, p0_.nodes AS nodes_9, p0_.level AS level_10, p0_.type AS type_11, p0_.position AS position_12, p0_.has_subpage AS has_subpage_13, p0_.has_sidebar AS has_sidebar_14, p0_.og_title AS og_title_15, p0_.og_description AS og_description_16, p0_.og_site_name AS og_site_name_17, p0_.og_url AS og_url_18, p0_.og_img AS og_img_19, p0_.tw_title AS tw_title_20, p0_.tw_description AS tw_description_21, p0_.tw_image AS tw_image_22, p0_.tw_card AS tw_card_23, p0_.tw_alt_image AS tw_alt_image_24, p0_.status AS status_25, p0_.created_at AS created_at_26, p0_.updated_at AS updated_at_27, p0_.created_by AS created_by_28 FROM pages p0_ WHERE p0_.path = 'media/' AND p0_.status = 1 AND (p0_.web_id = '%2%' OR p0_.web_id LIKE '%2%');

SELECT
  t0.id AS id_1,
  t0.page_id AS page_id_2,
  t0.content AS content_3,
  t0.has_gallery AS has_gallery_4,
  t0.page_id AS page_id_5
FROM
  pages_content t0
WHERE
  t0.page_id = ?

SELECT t0.id AS id_1, t0.page_id AS page_id_2, t0.content AS content_3, t0.has_gallery AS has_gallery_4, t0.page_id AS page_id_5 FROM pages_content t0 WHERE t0.page_id = 21;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.parent_id AS parent_id_1,
          p0_.web_id AS web_id_2,
          p0_.lang AS lang_3,
          p0_.url AS url_4,
          p0_.path AS path_5,
          p0_.canonical_url AS canonical_url_6,
          p0_.title AS title_7,
          p0_.meta_description AS meta_description_8,
          p0_.nodes AS nodes_9,
          p0_.level AS level_10,
          p0_.type AS type_11,
          p0_.position AS position_12,
          p0_.has_subpage AS has_subpage_13,
          p0_.og_title AS og_title_14,
          p0_.og_description AS og_description_15,
          p0_.og_site_name AS og_site_name_16,
          p0_.og_url AS og_url_17,
          p0_.og_img AS og_img_18,
          p0_.tw_title AS tw_title_19,
          p0_.tw_description AS tw_description_20,
          p0_.tw_image AS tw_image_21,
          p0_.tw_card AS tw_card_22,
          p0_.tw_alt_image AS tw_alt_image_23,
          p0_.status AS status_24,
          p0_.created_at AS created_at_25,
          p0_.updated_at AS updated_at_26,
          p0_.created_by AS created_by_27
        FROM
          pages p0_
        WHERE
          p0_.type IN (5, 6)
          AND p0_.status = 1
        ORDER BY
          p0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.parent_id AS parent_id_1, p0_.web_id AS web_id_2, p0_.lang AS lang_3, p0_.url AS url_4, p0_.path AS path_5, p0_.canonical_url AS canonical_url_6, p0_.title AS title_7, p0_.meta_description AS meta_description_8, p0_.nodes AS nodes_9, p0_.level AS level_10, p0_.type AS type_11, p0_.position AS position_12, p0_.has_subpage AS has_subpage_13, p0_.og_title AS og_title_14, p0_.og_description AS og_description_15, p0_.og_site_name AS og_site_name_16, p0_.og_url AS og_url_17, p0_.og_img AS og_img_18, p0_.tw_title AS tw_title_19, p0_.tw_description AS tw_description_20, p0_.tw_image AS tw_image_21, p0_.tw_card AS tw_card_22, p0_.tw_alt_image AS tw_alt_image_23, p0_.status AS status_24, p0_.created_at AS created_at_25, p0_.updated_at AS updated_at_26, p0_.created_by AS created_by_27 FROM pages p0_ WHERE p0_.type IN (5, 6) AND p0_.status = 1 ORDER BY p0_.created_at DESC) dctrn_result) dctrn_table;

SELECT
  p0_.id AS id_0,
  p0_.parent_id AS parent_id_1,
  p0_.web_id AS web_id_2,
  p0_.lang AS lang_3,
  p0_.url AS url_4,
  p0_.path AS path_5,
  p0_.canonical_url AS canonical_url_6,
  p0_.title AS title_7,
  p0_.meta_description AS meta_description_8,
  p0_.nodes AS nodes_9,
  p0_.level AS level_10,
  p0_.type AS type_11,
  p0_.position AS position_12,
  p0_.has_subpage AS has_subpage_13,
  p0_.has_sidebar AS has_sidebar_14,
  p0_.og_title AS og_title_15,
  p0_.og_description AS og_description_16,
  p0_.og_site_name AS og_site_name_17,
  p0_.og_url AS og_url_18,
  p0_.og_img AS og_img_19,
  p0_.tw_title AS tw_title_20,
  p0_.tw_description AS tw_description_21,
  p0_.tw_image AS tw_image_22,
  p0_.tw_card AS tw_card_23,
  p0_.tw_alt_image AS tw_alt_image_24,
  p0_.status AS status_25,
  p0_.created_at AS created_at_26,
  p0_.updated_at AS updated_at_27,
  p0_.created_by AS created_by_28
FROM
  pages p0_
WHERE
  p0_.lang = ?
  AND p0_.level = 1
  AND p0_.status = 1
  AND (
    p0_.web_id = ?
    OR p0_.web_id LIKE ?
  )
ORDER BY
  p0_.position ASC

SELECT p0_.id AS id_0, p0_.parent_id AS parent_id_1, p0_.web_id AS web_id_2, p0_.lang AS lang_3, p0_.url AS url_4, p0_.path AS path_5, p0_.canonical_url AS canonical_url_6, p0_.title AS title_7, p0_.meta_description AS meta_description_8, p0_.nodes AS nodes_9, p0_.level AS level_10, p0_.type AS type_11, p0_.position AS position_12, p0_.has_subpage AS has_subpage_13, p0_.has_sidebar AS has_sidebar_14, p0_.og_title AS og_title_15, p0_.og_description AS og_description_16, p0_.og_site_name AS og_site_name_17, p0_.og_url AS og_url_18, p0_.og_img AS og_img_19, p0_.tw_title AS tw_title_20, p0_.tw_description AS tw_description_21, p0_.tw_image AS tw_image_22, p0_.tw_card AS tw_card_23, p0_.tw_alt_image AS tw_alt_image_24, p0_.status AS status_25, p0_.created_at AS created_at_26, p0_.updated_at AS updated_at_27, p0_.created_by AS created_by_28 FROM pages p0_ WHERE p0_.lang = 'sk' AND p0_.level = 1 AND p0_.status = 1 AND (p0_.web_id = '%2%' OR p0_.web_id LIKE '%2%') ORDER BY p0_.position ASC;

SELECT
  p0_.id AS id_0,
  p0_.parent_id AS parent_id_1,
  p0_.web_id AS web_id_2,
  p0_.lang AS lang_3,
  p0_.url AS url_4,
  p0_.path AS path_5,
  p0_.canonical_url AS canonical_url_6,
  p0_.title AS title_7,
  p0_.meta_description AS meta_description_8,
  p0_.nodes AS nodes_9,
  p0_.level AS level_10,
  p0_.type AS type_11,
  p0_.position AS position_12,
  p0_.has_subpage AS has_subpage_13,
  p0_.has_sidebar AS has_sidebar_14,
  p0_.og_title AS og_title_15,
  p0_.og_description AS og_description_16,
  p0_.og_site_name AS og_site_name_17,
  p0_.og_url AS og_url_18,
  p0_.og_img AS og_img_19,
  p0_.tw_title AS tw_title_20,
  p0_.tw_description AS tw_description_21,
  p0_.tw_image AS tw_image_22,
  p0_.tw_card AS tw_card_23,
  p0_.tw_alt_image AS tw_alt_image_24,
  p0_.status AS status_25,
  p0_.created_at AS created_at_26,
  p0_.updated_at AS updated_at_27,
  p0_.created_by AS created_by_28
FROM
  pages p0_
WHERE
  p0_.lang = ?
  AND p0_.level >= 2
  AND p0_.status = 1
  AND (
    p0_.web_id = ?
    OR p0_.web_id LIKE ?
  )
ORDER BY
  p0_.position ASC

SELECT p0_.id AS id_0, p0_.parent_id AS parent_id_1, p0_.web_id AS web_id_2, p0_.lang AS lang_3, p0_.url AS url_4, p0_.path AS path_5, p0_.canonical_url AS canonical_url_6, p0_.title AS title_7, p0_.meta_description AS meta_description_8, p0_.nodes AS nodes_9, p0_.level AS level_10, p0_.type AS type_11, p0_.position AS position_12, p0_.has_subpage AS has_subpage_13, p0_.has_sidebar AS has_sidebar_14, p0_.og_title AS og_title_15, p0_.og_description AS og_description_16, p0_.og_site_name AS og_site_name_17, p0_.og_url AS og_url_18, p0_.og_img AS og_img_19, p0_.tw_title AS tw_title_20, p0_.tw_description AS tw_description_21, p0_.tw_image AS tw_image_22, p0_.tw_card AS tw_card_23, p0_.tw_alt_image AS tw_alt_image_24, p0_.status AS status_25, p0_.created_at AS created_at_26, p0_.updated_at AS updated_at_27, p0_.created_by AS created_by_28 FROM pages p0_ WHERE p0_.lang = 'sk' AND p0_.level >= 2 AND p0_.status = 1 AND (p0_.web_id = '%2%' OR p0_.web_id LIKE '%2%') ORDER BY p0_.position ASC;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      created_at_25
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.parent_id AS parent_id_1,
          p0_.web_id AS web_id_2,
          p0_.lang AS lang_3,
          p0_.url AS url_4,
          p0_.path AS path_5,
          p0_.canonical_url AS canonical_url_6,
          p0_.title AS title_7,
          p0_.meta_description AS meta_description_8,
          p0_.nodes AS nodes_9,
          p0_.level AS level_10,
          p0_.type AS type_11,
          p0_.position AS position_12,
          p0_.has_subpage AS has_subpage_13,
          p0_.og_title AS og_title_14,
          p0_.og_description AS og_description_15,
          p0_.og_site_name AS og_site_name_16,
          p0_.og_url AS og_url_17,
          p0_.og_img AS og_img_18,
          p0_.tw_title AS tw_title_19,
          p0_.tw_description AS tw_description_20,
          p0_.tw_image AS tw_image_21,
          p0_.tw_card AS tw_card_22,
          p0_.tw_alt_image AS tw_alt_image_23,
          p0_.status AS status_24,
          p0_.created_at AS created_at_25,
          p0_.updated_at AS updated_at_26,
          p0_.created_by AS created_by_27
        FROM
          pages p0_
        WHERE
          p0_.type IN (5, 6)
          AND p0_.status = 1
      ) dctrn_result_inner
    ORDER BY
      created_at_25 DESC
  ) dctrn_result
LIMIT
  6
OFFSET
  6

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_25 FROM (SELECT p0_.id AS id_0, p0_.parent_id AS parent_id_1, p0_.web_id AS web_id_2, p0_.lang AS lang_3, p0_.url AS url_4, p0_.path AS path_5, p0_.canonical_url AS canonical_url_6, p0_.title AS title_7, p0_.meta_description AS meta_description_8, p0_.nodes AS nodes_9, p0_.level AS level_10, p0_.type AS type_11, p0_.position AS position_12, p0_.has_subpage AS has_subpage_13, p0_.og_title AS og_title_14, p0_.og_description AS og_description_15, p0_.og_site_name AS og_site_name_16, p0_.og_url AS og_url_17, p0_.og_img AS og_img_18, p0_.tw_title AS tw_title_19, p0_.tw_description AS tw_description_20, p0_.tw_image AS tw_image_21, p0_.tw_card AS tw_card_22, p0_.tw_alt_image AS tw_alt_image_23, p0_.status AS status_24, p0_.created_at AS created_at_25, p0_.updated_at AS updated_at_26, p0_.created_by AS created_by_27 FROM pages p0_ WHERE p0_.type IN (5, 6) AND p0_.status = 1) dctrn_result_inner ORDER BY created_at_25 DESC) dctrn_result LIMIT 6 OFFSET 6;

SELECT
  p0_.id AS id_0,
  p0_.parent_id AS parent_id_1,
  p0_.web_id AS web_id_2,
  p0_.lang AS lang_3,
  p0_.url AS url_4,
  p0_.path AS path_5,
  p0_.canonical_url AS canonical_url_6,
  p0_.title AS title_7,
  p0_.meta_description AS meta_description_8,
  p0_.nodes AS nodes_9,
  p0_.level AS level_10,
  p0_.type AS type_11,
  p0_.position AS position_12,
  p0_.has_subpage AS has_subpage_13,
  p0_.og_title AS og_title_14,
  p0_.og_description AS og_description_15,
  p0_.og_site_name AS og_site_name_16,
  p0_.og_url AS og_url_17,
  p0_.og_img AS og_img_18,
  p0_.tw_title AS tw_title_19,
  p0_.tw_description AS tw_description_20,
  p0_.tw_image AS tw_image_21,
  p0_.tw_card AS tw_card_22,
  p0_.tw_alt_image AS tw_alt_image_23,
  p0_.status AS status_24,
  p0_.created_at AS created_at_25,
  p0_.updated_at AS updated_at_26,
  p0_.created_by AS created_by_27
FROM
  pages p0_
WHERE
  p0_.type IN (5, 6)
  AND p0_.status = 1
  AND p0_.id IN (?, ?, ?, ?, ?, ?)
ORDER BY
  p0_.created_at DESC

SELECT p0_.id AS id_0, p0_.parent_id AS parent_id_1, p0_.web_id AS web_id_2, p0_.lang AS lang_3, p0_.url AS url_4, p0_.path AS path_5, p0_.canonical_url AS canonical_url_6, p0_.title AS title_7, p0_.meta_description AS meta_description_8, p0_.nodes AS nodes_9, p0_.level AS level_10, p0_.type AS type_11, p0_.position AS position_12, p0_.has_subpage AS has_subpage_13, p0_.og_title AS og_title_14, p0_.og_description AS og_description_15, p0_.og_site_name AS og_site_name_16, p0_.og_url AS og_url_17, p0_.og_img AS og_img_18, p0_.tw_title AS tw_title_19, p0_.tw_description AS tw_description_20, p0_.tw_image AS tw_image_21, p0_.tw_card AS tw_card_22, p0_.tw_alt_image AS tw_alt_image_23, p0_.status AS status_24, p0_.created_at AS created_at_25, p0_.updated_at AS updated_at_26, p0_.created_by AS created_by_27 FROM pages p0_ WHERE p0_.type IN (5, 6) AND p0_.status = 1 AND p0_.id IN (38, 37, 39, 35, 40, 41) ORDER BY p0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.media_id AS media_id_2,
  t0.name AS name_3,
  t0.short_text AS short_text_4,
  t0.content AS content_5,
  t0.url AS url_6,
  t0.title_image AS title_image_7,
  t0.media_id AS media_id_8
FROM
  media_content t0
WHERE
  t0.media_id = ?

SELECT t0.id AS id_1, t0.media_id AS media_id_2, t0.name AS name_3, t0.short_text AS short_text_4, t0.content AS content_5, t0.url AS url_6, t0.title_image AS title_image_7, t0.media_id AS media_id_8 FROM media_content t0 WHERE t0.media_id = 38;

SELECT
  t0.id AS id_1,
  t0.media_id AS media_id_2,
  t0.name AS name_3,
  t0.short_text AS short_text_4,
  t0.content AS content_5,
  t0.url AS url_6,
  t0.title_image AS title_image_7,
  t0.media_id AS media_id_8
FROM
  media_content t0
WHERE
  t0.media_id = ?

SELECT t0.id AS id_1, t0.media_id AS media_id_2, t0.name AS name_3, t0.short_text AS short_text_4, t0.content AS content_5, t0.url AS url_6, t0.title_image AS title_image_7, t0.media_id AS media_id_8 FROM media_content t0 WHERE t0.media_id = 37;

SELECT
  t0.id AS id_1,
  t0.media_id AS media_id_2,
  t0.name AS name_3,
  t0.short_text AS short_text_4,
  t0.content AS content_5,
  t0.url AS url_6,
  t0.title_image AS title_image_7,
  t0.media_id AS media_id_8
FROM
  media_content t0
WHERE
  t0.media_id = ?

SELECT t0.id AS id_1, t0.media_id AS media_id_2, t0.name AS name_3, t0.short_text AS short_text_4, t0.content AS content_5, t0.url AS url_6, t0.title_image AS title_image_7, t0.media_id AS media_id_8 FROM media_content t0 WHERE t0.media_id = 39;

SELECT
  t0.id AS id_1,
  t0.media_id AS media_id_2,
  t0.name AS name_3,
  t0.short_text AS short_text_4,
  t0.content AS content_5,
  t0.url AS url_6,
  t0.title_image AS title_image_7,
  t0.media_id AS media_id_8
FROM
  media_content t0
WHERE
  t0.media_id = ?

SELECT t0.id AS id_1, t0.media_id AS media_id_2, t0.name AS name_3, t0.short_text AS short_text_4, t0.content AS content_5, t0.url AS url_6, t0.title_image AS title_image_7, t0.media_id AS media_id_8 FROM media_content t0 WHERE t0.media_id = 35;

SELECT
  t0.id AS id_1,
  t0.media_id AS media_id_2,
  t0.name AS name_3,
  t0.short_text AS short_text_4,
  t0.content AS content_5,
  t0.url AS url_6,
  t0.title_image AS title_image_7,
  t0.media_id AS media_id_8
FROM
  media_content t0
WHERE
  t0.media_id = ?

SELECT t0.id AS id_1, t0.media_id AS media_id_2, t0.name AS name_3, t0.short_text AS short_text_4, t0.content AS content_5, t0.url AS url_6, t0.title_image AS title_image_7, t0.media_id AS media_id_8 FROM media_content t0 WHERE t0.media_id = 40;

SELECT
  t0.id AS id_1,
  t0.media_id AS media_id_2,
  t0.name AS name_3,
  t0.short_text AS short_text_4,
  t0.content AS content_5,
  t0.url AS url_6,
  t0.title_image AS title_image_7,
  t0.media_id AS media_id_8
FROM
  media_content t0
WHERE
  t0.media_id = ?

SELECT t0.id AS id_1, t0.media_id AS media_id_2, t0.name AS name_3, t0.short_text AS short_text_4, t0.content AS content_5, t0.url AS url_6, t0.title_image AS title_image_7, t0.media_id AS media_id_8 FROM media_content t0 WHERE t0.media_id = 41;