Symfony Profiler

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      last_insert_9
    FROM
      (
        SELECT
          f0_.id AS id_0,
          f0_.theme_id AS theme_id_1,
          f0_.title AS title_2,
          f0_.path AS path_3,
          f0_.username AS username_4,
          f0_.created_at AS created_at_5,
          f0_.status AS status_6,
          f0_.theme_path AS theme_path_7,
          f0_.count AS count_8,
          f0_.last_insert AS last_insert_9
        FROM
          forum_topics_view f0_
        WHERE
          f0_.theme_path = ?
          AND f0_.status = 1
      ) dctrn_result_inner
    ORDER BY
      last_insert_9 DESC
  ) dctrn_result
LIMIT
  10

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, last_insert_9 FROM (SELECT f0_.id AS id_0, f0_.theme_id AS theme_id_1, f0_.title AS title_2, f0_.path AS path_3, f0_.username AS username_4, f0_.created_at AS created_at_5, f0_.status AS status_6, f0_.theme_path AS theme_path_7, f0_.count AS count_8, f0_.last_insert AS last_insert_9 FROM forum_topics_view f0_ WHERE f0_.theme_path = 'pocas-operacie' AND f0_.status = 1) dctrn_result_inner ORDER BY last_insert_9 DESC) dctrn_result LIMIT 10;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          f0_.id AS id_0,
          f0_.theme_id AS theme_id_1,
          f0_.title AS title_2,
          f0_.path AS path_3,
          f0_.username AS username_4,
          f0_.created_at AS created_at_5,
          f0_.status AS status_6,
          f0_.theme_path AS theme_path_7,
          f0_.count AS count_8,
          f0_.last_insert AS last_insert_9
        FROM
          forum_topics_view f0_
        WHERE
          f0_.theme_path = ?
          AND f0_.status = 1
        ORDER BY
          f0_.last_insert DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT f0_.id AS id_0, f0_.theme_id AS theme_id_1, f0_.title AS title_2, f0_.path AS path_3, f0_.username AS username_4, f0_.created_at AS created_at_5, f0_.status AS status_6, f0_.theme_path AS theme_path_7, f0_.count AS count_8, f0_.last_insert AS last_insert_9 FROM forum_topics_view f0_ WHERE f0_.theme_path = 'pocas-operacie' AND f0_.status = 1 ORDER BY f0_.last_insert DESC) dctrn_result) dctrn_table;

SELECT
  f0_.id AS id_0,
  f0_.theme_id AS theme_id_1,
  f0_.title AS title_2,
  f0_.path AS path_3,
  f0_.username AS username_4,
  f0_.created_at AS created_at_5,
  f0_.status AS status_6,
  f0_.theme_path AS theme_path_7,
  f0_.count AS count_8,
  f0_.last_insert AS last_insert_9
FROM
  forum_topics_view f0_
WHERE
  f0_.theme_path = ?
  AND f0_.status = 1
  AND f0_.id IN (?, ?)
ORDER BY
  f0_.last_insert DESC

SELECT f0_.id AS id_0, f0_.theme_id AS theme_id_1, f0_.title AS title_2, f0_.path AS path_3, f0_.username AS username_4, f0_.created_at AS created_at_5, f0_.status AS status_6, f0_.theme_path AS theme_path_7, f0_.count AS count_8, f0_.last_insert AS last_insert_9 FROM forum_topics_view f0_ WHERE f0_.theme_path = 'pocas-operacie' AND f0_.status = 1 AND f0_.id IN (9, 8) ORDER BY f0_.last_insert DESC;

SELECT
  f0_.id AS id_0,
  f0_.title AS title_1,
  f0_.path AS path_2,
  f0_.title_text AS title_text_3,
  f0_.count AS count_4,
  f0_.last_insert AS last_insert_5
FROM
  forum_themes_view f0_
WHERE
  f0_.path = ?

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.path AS path_2, f0_.title_text AS title_text_3, f0_.count AS count_4, f0_.last_insert AS last_insert_5 FROM forum_themes_view f0_ WHERE f0_.path = 'pocas-operacie';

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.status AS status_2
FROM
  forum_blacklist f0_
WHERE
  f0_.status = 1

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.status AS status_2 FROM forum_blacklist f0_ WHERE f0_.status = 1;

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;