Symfony Profiler

SELECT
  t0.id AS ID_1,
  t0.name AS NAME_2,
  t0.link AS LINK_3,
  t0.lvl AS LVL_4,
  t0.sort_order AS SORT_ORDER_5,
  t0.m_type AS M_TYPE_6,
  t0.lang AS LANG_7,
  t0.root_id AS ROOT_ID_8,
  t0.link_type AS LINK_TYPE_9,
  t0.link_type_data AS LINK_TYPE_DATA_10,
  t0.parent_id AS PARENT_ID_11,
  t0.visibility AS VISIBILITY_12,
  t0.isDeleted AS ISDELETED_13,
  t0.created_at AS CREATED_AT_14,
  t0.edited_at AS EDITED_AT_15,
  t0.m_page_id AS M_PAGE_ID_16,
  t0.parent_id2 AS PARENT_ID2_17
FROM
  cms_menu t0
WHERE
  t0.parent_id2 = ?
ORDER BY
  t0.sort_order ASC

SELECT t0.id AS ID_1, t0.name AS NAME_2, t0.link AS LINK_3, t0.lvl AS LVL_4, t0.sort_order AS SORT_ORDER_5, t0.m_type AS M_TYPE_6, t0.lang AS LANG_7, t0.root_id AS ROOT_ID_8, t0.link_type AS LINK_TYPE_9, t0.link_type_data AS LINK_TYPE_DATA_10, t0.parent_id AS PARENT_ID_11, t0.visibility AS VISIBILITY_12, t0.isDeleted AS ISDELETED_13, t0.created_at AS CREATED_AT_14, t0.edited_at AS EDITED_AT_15, t0.m_page_id AS M_PAGE_ID_16, t0.parent_id2 AS PARENT_ID2_17 FROM cms_menu t0 WHERE t0.parent_id2 = 1 ORDER BY t0.sort_order ASC;

SELECT
  t0.name AS NAME_1,
  t0.title AS TITLE_2,
  t0.menu_name AS MENU_NAME_3,
  t0.link_name AS LINK_NAME_4,
  t0.lvl AS LVL_5,
  t0.sort_order AS SORT_ORDER_6,
  t0.seo_id AS SEO_ID_7,
  t0.content AS CONTENT_8,
  t0.status AS STATUS_9,
  t0.lang AS LANG_10,
  t0.parent_id AS PARENT_ID_11,
  t0.config_data AS CONFIG_DATA_12,
  t0.layout AS LAYOUT_13,
  t0.redirect_url AS REDIRECT_URL_14,
  t0.redirect_window AS REDIRECT_WINDOW_15,
  t0.icon AS ICON_16,
  t0.teaser AS TEASER_17,
  t0.p_search AS P_SEARCH_18,
  t0.user_id AS USER_ID_19,
  t0.id AS ID_20,
  t0.visibility AS VISIBILITY_21,
  t0.isDeleted AS ISDELETED_22,
  t0.created_at AS CREATED_AT_23,
  t0.edited_at AS EDITED_AT_24,
  t0.parent_id AS PARENT_ID_25,
  t0.redirect_to_id AS REDIRECT_TO_ID_26
FROM
  cms_page t0
WHERE
  t0.id = ?

SELECT t0.name AS NAME_1, t0.title AS TITLE_2, t0.menu_name AS MENU_NAME_3, t0.link_name AS LINK_NAME_4, t0.lvl AS LVL_5, t0.sort_order AS SORT_ORDER_6, t0.seo_id AS SEO_ID_7, t0.content AS CONTENT_8, t0.status AS STATUS_9, t0.lang AS LANG_10, t0.parent_id AS PARENT_ID_11, t0.config_data AS CONFIG_DATA_12, t0.layout AS LAYOUT_13, t0.redirect_url AS REDIRECT_URL_14, t0.redirect_window AS REDIRECT_WINDOW_15, t0.icon AS ICON_16, t0.teaser AS TEASER_17, t0.p_search AS P_SEARCH_18, t0.user_id AS USER_ID_19, t0.id AS ID_20, t0.visibility AS VISIBILITY_21, t0.isDeleted AS ISDELETED_22, t0.created_at AS CREATED_AT_23, t0.edited_at AS EDITED_AT_24, t0.parent_id AS PARENT_ID_25, t0.redirect_to_id AS REDIRECT_TO_ID_26 FROM cms_page t0 WHERE t0.id = 41;

ALTER SESSION
SET
  NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,' NLS_SORT = 'XSLOVAK' NLS_LENGTH_SEMANTICS = 'CHAR'

ALTER SESSION SET NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,' NLS_SORT = 'XSLOVAK' NLS_LENGTH_SEMANTICS = 'CHAR';

SELECT
  t0.entity_id AS ENTITY_ID_1,
  t0.sort_order AS SORT_ORDER_2,
  t0.j_place AS J_PLACE_3,
  t0.j_params AS J_PARAMS_4,
  t0.id AS ID_5,
  t0.visibility AS VISIBILITY_6,
  t0.isDeleted AS ISDELETED_7,
  t0.created_at AS CREATED_AT_8,
  t0.edited_at AS EDITED_AT_9,
  t0.block_id AS BLOCK_ID_10,
  t0.entity_id AS ENTITY_ID_11,
  t0.joint_entity
FROM
  cms_block_joint t0
WHERE
  t0.entity_id = ?
  AND t0.joint_entity IN ('page')
ORDER BY
  t0.sort_order ASC,
  t0.j_place ASC

SELECT t0.entity_id AS ENTITY_ID_1, t0.sort_order AS SORT_ORDER_2, t0.j_place AS J_PLACE_3, t0.j_params AS J_PARAMS_4, t0.id AS ID_5, t0.visibility AS VISIBILITY_6, t0.isDeleted AS ISDELETED_7, t0.created_at AS CREATED_AT_8, t0.edited_at AS EDITED_AT_9, t0.block_id AS BLOCK_ID_10, t0.entity_id AS ENTITY_ID_11, t0.joint_entity FROM cms_block_joint t0 WHERE t0.entity_id = 5 AND t0.joint_entity IN ('page') ORDER BY t0.sort_order ASC, t0.j_place ASC;

SELECT
  t0.id AS ID_1,
  t0.name AS NAME_2,
  t0.link AS LINK_3,
  t0.lvl AS LVL_4,
  t0.sort_order AS SORT_ORDER_5,
  t0.m_type AS M_TYPE_6,
  t0.lang AS LANG_7,
  t0.root_id AS ROOT_ID_8,
  t0.link_type AS LINK_TYPE_9,
  t0.link_type_data AS LINK_TYPE_DATA_10,
  t0.parent_id AS PARENT_ID_11,
  t0.visibility AS VISIBILITY_12,
  t0.isDeleted AS ISDELETED_13,
  t0.created_at AS CREATED_AT_14,
  t0.edited_at AS EDITED_AT_15,
  t0.m_page_id AS M_PAGE_ID_16,
  t0.parent_id2 AS PARENT_ID2_17
FROM
  cms_menu t0
WHERE
  t0.root_id IS NULL
ORDER BY
  t0.created_at ASC,
  t0.id ASC

SELECT t0.id AS ID_1, t0.name AS NAME_2, t0.link AS LINK_3, t0.lvl AS LVL_4, t0.sort_order AS SORT_ORDER_5, t0.m_type AS M_TYPE_6, t0.lang AS LANG_7, t0.root_id AS ROOT_ID_8, t0.link_type AS LINK_TYPE_9, t0.link_type_data AS LINK_TYPE_DATA_10, t0.parent_id AS PARENT_ID_11, t0.visibility AS VISIBILITY_12, t0.isDeleted AS ISDELETED_13, t0.created_at AS CREATED_AT_14, t0.edited_at AS EDITED_AT_15, t0.m_page_id AS M_PAGE_ID_16, t0.parent_id2 AS PARENT_ID2_17 FROM cms_menu t0 WHERE t0.root_id IS NULL ORDER BY t0.created_at ASC, t0.id ASC;

SELECT
  a.*
FROM
  (
    SELECT
      t0.name AS NAME_1,
      t0.title AS TITLE_2,
      t0.menu_name AS MENU_NAME_3,
      t0.link_name AS LINK_NAME_4,
      t0.lvl AS LVL_5,
      t0.sort_order AS SORT_ORDER_6,
      t0.seo_id AS SEO_ID_7,
      t0.content AS CONTENT_8,
      t0.status AS STATUS_9,
      t0.lang AS LANG_10,
      t0.parent_id AS PARENT_ID_11,
      t0.config_data AS CONFIG_DATA_12,
      t0.layout AS LAYOUT_13,
      t0.redirect_url AS REDIRECT_URL_14,
      t0.redirect_window AS REDIRECT_WINDOW_15,
      t0.icon AS ICON_16,
      t0.teaser AS TEASER_17,
      t0.p_search AS P_SEARCH_18,
      t0.user_id AS USER_ID_19,
      t0.id AS ID_20,
      t0.visibility AS VISIBILITY_21,
      t0.isDeleted AS ISDELETED_22,
      t0.created_at AS CREATED_AT_23,
      t0.edited_at AS EDITED_AT_24,
      t0.parent_id AS PARENT_ID_25,
      t0.redirect_to_id AS REDIRECT_TO_ID_26
    FROM
      cms_page t0
    WHERE
      t0.seo_id = ?
  ) a
WHERE
  ROWNUM <= 1

SELECT a.* FROM (SELECT t0.name AS NAME_1, t0.title AS TITLE_2, t0.menu_name AS MENU_NAME_3, t0.link_name AS LINK_NAME_4, t0.lvl AS LVL_5, t0.sort_order AS SORT_ORDER_6, t0.seo_id AS SEO_ID_7, t0.content AS CONTENT_8, t0.status AS STATUS_9, t0.lang AS LANG_10, t0.parent_id AS PARENT_ID_11, t0.config_data AS CONFIG_DATA_12, t0.layout AS LAYOUT_13, t0.redirect_url AS REDIRECT_URL_14, t0.redirect_window AS REDIRECT_WINDOW_15, t0.icon AS ICON_16, t0.teaser AS TEASER_17, t0.p_search AS P_SEARCH_18, t0.user_id AS USER_ID_19, t0.id AS ID_20, t0.visibility AS VISIBILITY_21, t0.isDeleted AS ISDELETED_22, t0.created_at AS CREATED_AT_23, t0.edited_at AS EDITED_AT_24, t0.parent_id AS PARENT_ID_25, t0.redirect_to_id AS REDIRECT_TO_ID_26 FROM cms_page t0 WHERE t0.seo_id = 'homepage') a WHERE ROWNUM <= 1;

SELECT
  t0.name AS NAME_1,
  t0.perex AS PEREX_2,
  t0.content AS CONTENT_3,
  t0.lang AS LANG_4,
  t0.module AS MODULE_5,
  t0.action AS ACTION_6,
  t0.params AS PARAMS_7,
  t0.type AS TYPE_8,
  t0.sort_order AS SORT_ORDER_9,
  t0.description AS DESCRIPTION_10,
  t0.id AS ID_11,
  t0.visibility AS VISIBILITY_12,
  t0.isDeleted AS ISDELETED_13,
  t0.created_at AS CREATED_AT_14,
  t0.edited_at AS EDITED_AT_15
FROM
  cms_block t0
WHERE
  t0.id = ?

SELECT t0.name AS NAME_1, t0.perex AS PEREX_2, t0.content AS CONTENT_3, t0.lang AS LANG_4, t0.module AS MODULE_5, t0.action AS ACTION_6, t0.params AS PARAMS_7, t0.type AS TYPE_8, t0.sort_order AS SORT_ORDER_9, t0.description AS DESCRIPTION_10, t0.id AS ID_11, t0.visibility AS VISIBILITY_12, t0.isDeleted AS ISDELETED_13, t0.created_at AS CREATED_AT_14, t0.edited_at AS EDITED_AT_15 FROM cms_block t0 WHERE t0.id = 1;

SELECT
  t0.entity_id AS ENTITY_ID_1,
  t0.m_value AS M_VALUE_2,
  t0.m_userId AS M_USERID_3,
  t0.id AS ID_4,
  t0.visibility AS VISIBILITY_5,
  t0.isDeleted AS ISDELETED_6,
  t0.created_at AS CREATED_AT_7,
  t0.edited_at AS EDITED_AT_8,
  t0.pattern_id AS PATTERN_ID_9,
  t0.entity_id AS ENTITY_ID_10,
  t0.tag_entity
FROM
  cms_metatag t0
WHERE
  t0.entity_id = ?
  AND t0.tag_entity IN ('page')

SELECT t0.entity_id AS ENTITY_ID_1, t0.m_value AS M_VALUE_2, t0.m_userId AS M_USERID_3, t0.id AS ID_4, t0.visibility AS VISIBILITY_5, t0.isDeleted AS ISDELETED_6, t0.created_at AS CREATED_AT_7, t0.edited_at AS EDITED_AT_8, t0.pattern_id AS PATTERN_ID_9, t0.entity_id AS ENTITY_ID_10, t0.tag_entity FROM cms_metatag t0 WHERE t0.entity_id = 5 AND t0.tag_entity IN ('page');

SELECT
  c0_.code AS CODE_0,
  c0_.name AS NAME_1,
  c0_.value AS VALUE_2,
  c0_.o_params AS O_PARAMS_3,
  c0_.id AS ID_4,
  c0_.visibility AS VISIBILITY_5,
  c0_.isDeleted AS ISDELETED_6,
  c0_.created_at AS CREATED_AT_7,
  c0_.edited_at AS EDITED_AT_8
FROM
  cms_option c0_
WHERE
  c0_.code IS NOT NULL
  AND c0_.visibility = ?

SELECT c0_.code AS CODE_0, c0_.name AS NAME_1, c0_.value AS VALUE_2, c0_.o_params AS O_PARAMS_3, c0_.id AS ID_4, c0_.visibility AS VISIBILITY_5, c0_.isDeleted AS ISDELETED_6, c0_.created_at AS CREATED_AT_7, c0_.edited_at AS EDITED_AT_8 FROM cms_option c0_ WHERE c0_.code IS NOT NULL AND c0_.visibility = 1;