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/agency/routes/de'
                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/agency/routes/de') 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 ('4f0794e3-4cb8-4d3b-9735-c1a9d9572b01');

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/agency/contents') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  t0.id AS id_1,
  t0.media_type AS media_type_2,
  t0.local_media_url AS local_media_url_3,
  t0.insta_media_url AS insta_media_url_4
FROM
  instagram_feed t0

SELECT t0.id AS id_1, t0.media_type AS media_type_2, t0.local_media_url AS local_media_url_3, t0.insta_media_url AS insta_media_url_4 FROM instagram_feed t0;

SELECT
  t0.id AS id_1,
  t0.keyname AS keyname_2
FROM
  property_categories t0

SELECT t0.id AS id_1, t0.keyname AS keyname_2 FROM property_categories t0;

SELECT
  p0_.id AS id_0,
  p0_.locale AS locale_1,
  p0_.name AS name_2,
  p0_.category_id AS category_id_3
FROM
  property_categories_translation p0_
WHERE
  p0_.category_id = ?
  AND p0_.locale = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.name AS name_2, p0_.category_id AS category_id_3 FROM property_categories_translation p0_ WHERE p0_.category_id = 1 AND p0_.locale = 'de' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.locale AS locale_1,
  p0_.name AS name_2,
  p0_.category_id AS category_id_3
FROM
  property_categories_translation p0_
WHERE
  p0_.category_id = ?
  AND p0_.locale = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.name AS name_2, p0_.category_id AS category_id_3 FROM property_categories_translation p0_ WHERE p0_.category_id = 2 AND p0_.locale = 'de' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.locale AS locale_1,
  p0_.name AS name_2,
  p0_.category_id AS category_id_3
FROM
  property_categories_translation p0_
WHERE
  p0_.category_id = ?
  AND p0_.locale = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.name AS name_2, p0_.category_id AS category_id_3 FROM property_categories_translation p0_ WHERE p0_.category_id = 3 AND p0_.locale = 'de' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.locale AS locale_1,
  p0_.name AS name_2,
  p0_.category_id AS category_id_3
FROM
  property_categories_translation p0_
WHERE
  p0_.category_id = ?
  AND p0_.locale = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.name AS name_2, p0_.category_id AS category_id_3 FROM property_categories_translation p0_ WHERE p0_.category_id = 4 AND p0_.locale = 'de' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.locale AS locale_1,
  p0_.name AS name_2,
  p0_.category_id AS category_id_3
FROM
  property_categories_translation p0_
WHERE
  p0_.category_id = ?
  AND p0_.locale = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.name AS name_2, p0_.category_id AS category_id_3 FROM property_categories_translation p0_ WHERE p0_.category_id = 5 AND p0_.locale = 'de' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.locale AS locale_1,
  p0_.name AS name_2,
  p0_.category_id AS category_id_3
FROM
  property_categories_translation p0_
WHERE
  p0_.category_id = ?
  AND p0_.locale = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.name AS name_2, p0_.category_id AS category_id_3 FROM property_categories_translation p0_ WHERE p0_.category_id = 6 AND p0_.locale = 'de' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.locale AS locale_1,
  p0_.name AS name_2,
  p0_.category_id AS category_id_3
FROM
  property_categories_translation p0_
WHERE
  p0_.category_id = ?
  AND p0_.locale = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.name AS name_2, p0_.category_id AS category_id_3 FROM property_categories_translation p0_ WHERE p0_.category_id = 7 AND p0_.locale = 'de' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.locale AS locale_1,
  p0_.name AS name_2,
  p0_.category_id AS category_id_3
FROM
  property_categories_translation p0_
WHERE
  p0_.category_id = ?
  AND p0_.locale = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.name AS name_2, p0_.category_id AS category_id_3 FROM property_categories_translation p0_ WHERE p0_.category_id = 8 AND p0_.locale = 'de' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.locale AS locale_1,
  p0_.name AS name_2,
  p0_.category_id AS category_id_3
FROM
  property_categories_translation p0_
WHERE
  p0_.category_id = ?
  AND p0_.locale = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.name AS name_2, p0_.category_id AS category_id_3 FROM property_categories_translation p0_ WHERE p0_.category_id = 9 AND p0_.locale = 'de' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.locale AS locale_1,
  p0_.name AS name_2,
  p0_.category_id AS category_id_3
FROM
  property_categories_translation p0_
WHERE
  p0_.category_id = ?
  AND p0_.locale = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.name AS name_2, p0_.category_id AS category_id_3 FROM property_categories_translation p0_ WHERE p0_.category_id = 10 AND p0_.locale = 'de' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.public_key AS public_key_2,
  t0.secret_key AS secret_key_3
FROM
  captcha t0

SELECT t0.id AS id_1, t0.public_key AS public_key_2, t0.secret_key AS secret_key_3 FROM captcha t0;

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

SELECT * FROM phpcr_nodes
              WHERE path = '/cmf/agency'
                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/agency') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

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 ('11a3b525-3f08-4079-8014-daa33051039d');

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/snippets/settings/settings') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

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

SELECT * FROM phpcr_nodes
              WHERE path = '/cmf/snippets/settings'
                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/snippets/settings') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

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 ('213d50a7-3ccf-43fe-a891-e062f4fe2620');

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/snippets/theme/theme') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

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

SELECT * FROM phpcr_nodes
              WHERE path = '/cmf/snippets/theme'
                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/snippets/theme') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

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 ('5367eace-f641-4763-96a6-e2fe1734a238');