Symfony Profiler

SELECT
  1
FROM
  phpcr_workspaces
WHERE
  name = ?

SELECT 1 FROM phpcr_workspaces WHERE name = 'default_live';

SELECT
  prefix,
  uri
FROM
  phpcr_namespaces

SELECT prefix, uri FROM phpcr_namespaces;

SELECT
  *
FROM
  phpcr_nodes
WHERE
  path = ?
  AND workspace_name = ?
ORDER BY
  depth,
  sort_order ASC

SELECT * FROM phpcr_nodes
              WHERE path = '/cmf/sudcms/routes/en'
                AND workspace_name = 'default_live'
              ORDER BY depth, sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/sudcms/routes/en') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  phpcr_type_nodes.name AS node_name,
  phpcr_type_nodes.is_abstract AS node_abstract,
  phpcr_type_nodes.is_mixin AS node_mixin,
  phpcr_type_nodes.queryable AS node_queryable,
  phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
  phpcr_type_nodes.primary_item AS node_primary_item_name,
  phpcr_type_nodes.supertypes AS declared_super_type_names,
  phpcr_type_props.name AS property_name,
  phpcr_type_props.auto_created AS property_auto_created,
  phpcr_type_props.mandatory AS property_mandatory,
  phpcr_type_props.protected AS property_protected,
  phpcr_type_props.on_parent_version AS property_on_parent_version,
  phpcr_type_props.required_type AS property_required_type,
  phpcr_type_props.multiple AS property_multiple,
  phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
  phpcr_type_props.query_orderable AS property_query_orderable,
  phpcr_type_props.default_value as property_default_value,
  phpcr_type_childs.name AS child_name,
  phpcr_type_childs.auto_created AS child_auto_created,
  phpcr_type_childs.mandatory AS child_mandatory,
  phpcr_type_childs.protected AS child_protected,
  phpcr_type_childs.on_parent_version AS child_on_parent_version,
  phpcr_type_childs.default_type AS child_default_type,
  phpcr_type_childs.primary_types AS child_primary_types
FROM
  phpcr_type_nodes
  LEFT JOIN phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
  LEFT JOIN phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id

SELECT
phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,
phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,
phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,
phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,
phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,
phpcr_type_props.on_parent_version AS property_on_parent_version,
phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,
phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,
phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,
phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,
phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,
phpcr_type_childs.primary_types AS child_primary_types
FROM
phpcr_type_nodes
LEFT JOIN
phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
LEFT JOIN
phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id
;

SELECT
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND identifier IN (?)

SELECT id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
            FROM phpcr_nodes WHERE workspace_name = 'default_live' AND identifier IN ('80d5df40-b6bb-4a49-a75d-c20919ef9fbd');

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/sudcms/contents') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  t0.id AS id_1,
  t0.animation_menu AS animation_menu_2,
  t0.type_menu AS type_menu_3,
  t0.activate_click_parent_page_menu AS activate_click_parent_page_menu_4,
  t0.nb_child_in_menu AS nb_child_in_menu_5,
  t0.display_logo_desktop AS display_logo_desktop_6,
  t0.display_logo_mobile AS display_logo_mobile_7,
  t0.display_name AS display_name_8,
  t0.display_social_media_in_navbar AS display_social_media_in_navbar_9,
  t0.created AS created_10,
  t0.changed AS changed_11,
  t0.navbar_background_color_id AS navbar_background_color_id_12,
  t0.background_color_id AS background_color_id_13,
  t0.second_background_color_id AS second_background_color_id_14,
  t0.third_background_color_id AS third_background_color_id_15,
  t0.divider_color_id AS divider_color_id_16,
  t0.text_color_id AS text_color_id_17,
  t0.second_text_color_id AS second_text_color_id_18,
  t0.text_background_hover_color_id AS text_background_hover_color_id_19,
  t0.second_text_background_hover_color_id AS second_text_background_hover_color_id_20,
  t0.text_hover_color_id AS text_hover_color_id_21,
  t0.second_text_hover_color_id AS second_text_hover_color_id_22,
  t0.burger_open_color_id AS burger_open_color_id_23,
  t0.burger_close_color_id AS burger_close_color_id_24,
  t0.social_media_color_id AS social_media_color_id_25,
  t0.social_media_color_hover_id AS social_media_color_hover_id_26,
  t0.social_media_color_background_id AS social_media_color_background_id_27,
  t0.image_id AS image_id_28,
  t0.idUsersCreator AS idUsersCreator_29,
  t0.idUsersChanger AS idUsersChanger_30
FROM
  sudcms_website_settings_menu t0
LIMIT
  1

SELECT t0.id AS id_1, t0.animation_menu AS animation_menu_2, t0.type_menu AS type_menu_3, t0.activate_click_parent_page_menu AS activate_click_parent_page_menu_4, t0.nb_child_in_menu AS nb_child_in_menu_5, t0.display_logo_desktop AS display_logo_desktop_6, t0.display_logo_mobile AS display_logo_mobile_7, t0.display_name AS display_name_8, t0.display_social_media_in_navbar AS display_social_media_in_navbar_9, t0.created AS created_10, t0.changed AS changed_11, t0.navbar_background_color_id AS navbar_background_color_id_12, t0.background_color_id AS background_color_id_13, t0.second_background_color_id AS second_background_color_id_14, t0.third_background_color_id AS third_background_color_id_15, t0.divider_color_id AS divider_color_id_16, t0.text_color_id AS text_color_id_17, t0.second_text_color_id AS second_text_color_id_18, t0.text_background_hover_color_id AS text_background_hover_color_id_19, t0.second_text_background_hover_color_id AS second_text_background_hover_color_id_20, t0.text_hover_color_id AS text_hover_color_id_21, t0.second_text_hover_color_id AS second_text_hover_color_id_22, t0.burger_open_color_id AS burger_open_color_id_23, t0.burger_close_color_id AS burger_close_color_id_24, t0.social_media_color_id AS social_media_color_id_25, t0.social_media_color_hover_id AS social_media_color_hover_id_26, t0.social_media_color_background_id AS social_media_color_background_id_27, t0.image_id AS image_id_28, t0.idUsersCreator AS idUsersCreator_29, t0.idUsersChanger AS idUsersChanger_30 FROM sudcms_website_settings_menu t0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.shape AS shape_2,
  t0.radius AS radius_3,
  t0.title_align AS title_align_4,
  t0.list_style_ul_level1 AS list_style_ul_level1_5,
  t0.list_style_ul_level2 AS list_style_ul_level2_6,
  t0.list_style_ul_level3 AS list_style_ul_level3_7,
  t0.list_style_ol_level1 AS list_style_ol_level1_8,
  t0.list_style_ol_level2 AS list_style_ol_level2_9,
  t0.list_style_ol_level3 AS list_style_ol_level3_10,
  t0.created AS created_11,
  t0.changed AS changed_12,
  t0.title_font_id AS title_font_id_13,
  t0.sub_title_font_id AS sub_title_font_id_14,
  t0.paragraph_font_id AS paragraph_font_id_15,
  t0.idUsersCreator AS idUsersCreator_16,
  t0.idUsersChanger AS idUsersChanger_17
FROM
  sudcms_website_settings_blocks t0
LIMIT
  1

SELECT t0.id AS id_1, t0.shape AS shape_2, t0.radius AS radius_3, t0.title_align AS title_align_4, t0.list_style_ul_level1 AS list_style_ul_level1_5, t0.list_style_ul_level2 AS list_style_ul_level2_6, t0.list_style_ul_level3 AS list_style_ul_level3_7, t0.list_style_ol_level1 AS list_style_ol_level1_8, t0.list_style_ol_level2 AS list_style_ol_level2_9, t0.list_style_ol_level3 AS list_style_ol_level3_10, t0.created AS created_11, t0.changed AS changed_12, t0.title_font_id AS title_font_id_13, t0.sub_title_font_id AS sub_title_font_id_14, t0.paragraph_font_id AS paragraph_font_id_15, t0.idUsersCreator AS idUsersCreator_16, t0.idUsersChanger AS idUsersChanger_17 FROM sudcms_website_settings_blocks t0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.hexadecimal_color AS hexadecimal_color_3,
  t0.created AS created_4,
  t0.changed AS changed_5,
  t0.idUsersCreator AS idUsersCreator_6,
  t0.idUsersChanger AS idUsersChanger_7
FROM
  sudcms_website_settings_colors t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.hexadecimal_color AS hexadecimal_color_3, t0.created AS created_4, t0.changed AS changed_5, t0.idUsersCreator AS idUsersCreator_6, t0.idUsersChanger AS idUsersChanger_7 FROM sudcms_website_settings_colors t0;

SELECT
  t0.id AS id_1,
  t0.server_node AS server_node_2,
  t0.breadcrumb AS breadcrumb_3,
  t0.fancybox_duration AS fancybox_duration_4,
  t0.fancybox_show_progress AS fancybox_show_progress_5,
  t0.fancybox_show_dots AS fancybox_show_dots_6,
  t0.created AS created_7,
  t0.changed AS changed_8,
  t0.background_color_id AS background_color_id_9,
  t0.default_image_id AS default_image_id_10,
  t0.idUsersCreator AS idUsersCreator_11,
  t0.idUsersChanger AS idUsersChanger_12
FROM
  sudcms_website_settings_general t0
LIMIT
  1

SELECT t0.id AS id_1, t0.server_node AS server_node_2, t0.breadcrumb AS breadcrumb_3, t0.fancybox_duration AS fancybox_duration_4, t0.fancybox_show_progress AS fancybox_show_progress_5, t0.fancybox_show_dots AS fancybox_show_dots_6, t0.created AS created_7, t0.changed AS changed_8, t0.background_color_id AS background_color_id_9, t0.default_image_id AS default_image_id_10, t0.idUsersCreator AS idUsersCreator_11, t0.idUsersChanger AS idUsersChanger_12 FROM sudcms_website_settings_general t0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.google_api_font_family AS google_api_font_family_2,
  t0.created AS created_3,
  t0.changed AS changed_4,
  t0.idUsersCreator AS idUsersCreator_5,
  t0.idUsersChanger AS idUsersChanger_6
FROM
  sudcms_website_settings_fonts t0

SELECT t0.id AS id_1, t0.google_api_font_family AS google_api_font_family_2, t0.created AS created_3, t0.changed AS changed_4, t0.idUsersCreator AS idUsersCreator_5, t0.idUsersChanger AS idUsersChanger_6 FROM sudcms_website_settings_fonts t0;

SELECT
  t0.id AS id_1,
  t0.css_class AS css_class_2,
  t0.font_family AS font_family_3,
  t0.font_style AS font_style_4,
  t0.font_weight AS font_weight_5,
  t0.created AS created_6,
  t0.changed AS changed_7,
  t0.font_id AS font_id_8,
  t0.idUsersCreator AS idUsersCreator_9,
  t0.idUsersChanger AS idUsersChanger_10
FROM
  sudcms_website_settings_fonts_properties t0

SELECT t0.id AS id_1, t0.css_class AS css_class_2, t0.font_family AS font_family_3, t0.font_style AS font_style_4, t0.font_weight AS font_weight_5, t0.created AS created_6, t0.changed AS changed_7, t0.font_id AS font_id_8, t0.idUsersCreator AS idUsersCreator_9, t0.idUsersChanger AS idUsersChanger_10 FROM sudcms_website_settings_fonts_properties t0;

SELECT
  *
FROM
  phpcr_nodes
WHERE
  path = ?
  AND workspace_name = ?
ORDER BY
  depth,
  sort_order ASC

SELECT * FROM phpcr_nodes
              WHERE path = '/cmf/sudcms'
                AND workspace_name = 'default_live'
              ORDER BY depth, sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/sudcms') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  t0.id AS id_1,
  t0.duration AS duration_2,
  t0.timezone AS timezone_3,
  t0.created AS created_4,
  t0.changed AS changed_5,
  t0.idUsersCreator AS idUsersCreator_6,
  t0.idUsersChanger AS idUsersChanger_7
FROM
  sudcms_flash_info_settings t0
LIMIT
  1

SELECT t0.id AS id_1, t0.duration AS duration_2, t0.timezone AS timezone_3, t0.created AS created_4, t0.changed AS changed_5, t0.idUsersCreator AS idUsersCreator_6, t0.idUsersChanger AS idUsersChanger_7 FROM sudcms_flash_info_settings t0 LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.text AS text_1,
  s0_.start_date AS start_date_2,
  s0_.end_date AS end_date_3,
  s0_.is_active AS is_active_4,
  s0_.type AS type_5,
  s0_.locale AS locale_6,
  s0_.created AS created_7,
  s0_.changed AS changed_8,
  s0_.idUsersCreator AS idUsersCreator_9,
  s0_.idUsersChanger AS idUsersChanger_10
FROM
  sudcms_flash_info s0_
WHERE
  (
    s0_.start_date <= ?
    OR s0_.start_date IS NULL
  )
  AND (
    s0_.end_date >= ?
    OR s0_.end_date IS NULL
  )
  AND s0_.is_active = ?
  AND s0_.locale = ?

SELECT s0_.id AS id_0, s0_.text AS text_1, s0_.start_date AS start_date_2, s0_.end_date AS end_date_3, s0_.is_active AS is_active_4, s0_.type AS type_5, s0_.locale AS locale_6, s0_.created AS created_7, s0_.changed AS changed_8, s0_.idUsersCreator AS idUsersCreator_9, s0_.idUsersChanger AS idUsersChanger_10 FROM sudcms_flash_info s0_ WHERE (s0_.start_date <= '2025-06-16 01:13:15' OR s0_.start_date IS NULL) AND (s0_.end_date >= '2025-06-16 01:13:15' OR s0_.end_date IS NULL) AND s0_.is_active = 1 AND s0_.locale = 'en';

SELECT
  phpcr_type_nodes.name AS node_name,
  phpcr_type_nodes.is_abstract AS node_abstract,
  phpcr_type_nodes.is_mixin AS node_mixin,
  phpcr_type_nodes.queryable AS node_queryable,
  phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
  phpcr_type_nodes.primary_item AS node_primary_item_name,
  phpcr_type_nodes.supertypes AS declared_super_type_names,
  phpcr_type_props.name AS property_name,
  phpcr_type_props.auto_created AS property_auto_created,
  phpcr_type_props.mandatory AS property_mandatory,
  phpcr_type_props.protected AS property_protected,
  phpcr_type_props.on_parent_version AS property_on_parent_version,
  phpcr_type_props.required_type AS property_required_type,
  phpcr_type_props.multiple AS property_multiple,
  phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
  phpcr_type_props.query_orderable AS property_query_orderable,
  phpcr_type_props.default_value as property_default_value,
  phpcr_type_childs.name AS child_name,
  phpcr_type_childs.auto_created AS child_auto_created,
  phpcr_type_childs.mandatory AS child_mandatory,
  phpcr_type_childs.protected AS child_protected,
  phpcr_type_childs.on_parent_version AS child_on_parent_version,
  phpcr_type_childs.default_type AS child_default_type,
  phpcr_type_childs.primary_types AS child_primary_types
FROM
  phpcr_type_nodes
  LEFT JOIN phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
  LEFT JOIN phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id

SELECT
phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,
phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,
phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,
phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,
phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,
phpcr_type_props.on_parent_version AS property_on_parent_version,
phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,
phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,
phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,
phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,
phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,
phpcr_type_childs.primary_types AS child_primary_types
FROM
phpcr_type_nodes
LEFT JOIN
phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
LEFT JOIN
phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id
;

SELECT
  phpcr_type_nodes.name AS node_name,
  phpcr_type_nodes.is_abstract AS node_abstract,
  phpcr_type_nodes.is_mixin AS node_mixin,
  phpcr_type_nodes.queryable AS node_queryable,
  phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
  phpcr_type_nodes.primary_item AS node_primary_item_name,
  phpcr_type_nodes.supertypes AS declared_super_type_names,
  phpcr_type_props.name AS property_name,
  phpcr_type_props.auto_created AS property_auto_created,
  phpcr_type_props.mandatory AS property_mandatory,
  phpcr_type_props.protected AS property_protected,
  phpcr_type_props.on_parent_version AS property_on_parent_version,
  phpcr_type_props.required_type AS property_required_type,
  phpcr_type_props.multiple AS property_multiple,
  phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
  phpcr_type_props.query_orderable AS property_query_orderable,
  phpcr_type_props.default_value as property_default_value,
  phpcr_type_childs.name AS child_name,
  phpcr_type_childs.auto_created AS child_auto_created,
  phpcr_type_childs.mandatory AS child_mandatory,
  phpcr_type_childs.protected AS child_protected,
  phpcr_type_childs.on_parent_version AS child_on_parent_version,
  phpcr_type_childs.default_type AS child_default_type,
  phpcr_type_childs.primary_types AS child_primary_types
FROM
  phpcr_type_nodes
  LEFT JOIN phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
  LEFT JOIN phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id

SELECT
phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,
phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,
phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,
phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,
phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,
phpcr_type_props.on_parent_version AS property_on_parent_version,
phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,
phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,
phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,
phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,
phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,
phpcr_type_childs.primary_types AS child_primary_types
FROM
phpcr_type_nodes
LEFT JOIN
phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
LEFT JOIN
phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id
;