Symfony Profiler

SELECT
  ibexa_url_alias_ml0.id AS ibexa_url_alias_ml0_id,
  ibexa_url_alias_ml0.link AS ibexa_url_alias_ml0_link,
  ibexa_url_alias_ml0.is_alias AS ibexa_url_alias_ml0_is_alias,
  ibexa_url_alias_ml0.alias_redirects AS ibexa_url_alias_ml0_alias_redirects,
  ibexa_url_alias_ml0.is_original AS ibexa_url_alias_ml0_is_original,
  ibexa_url_alias_ml0.action AS ibexa_url_alias_ml0_action,
  ibexa_url_alias_ml0.action_type AS ibexa_url_alias_ml0_action_type,
  ibexa_url_alias_ml0.lang_mask AS ibexa_url_alias_ml0_lang_mask,
  ibexa_url_alias_ml0.text AS ibexa_url_alias_ml0_text,
  ibexa_url_alias_ml0.parent AS ibexa_url_alias_ml0_parent,
  ibexa_url_alias_ml0.text_md5 AS ibexa_url_alias_ml0_text_md5,
  u.id AS id,
  u.link AS link,
  u.is_alias AS is_alias,
  u.alias_redirects AS alias_redirects,
  u.is_original AS is_original,
  u.action AS action,
  u.action_type AS action_type,
  u.lang_mask AS lang_mask,
  u.text AS text,
  u.parent AS parent,
  u.text_md5 AS text_md5
FROM
  "ibexa_url_alias_ml" ibexa_url_alias_ml0,
  "ibexa_url_alias_ml" u
WHERE
  (ibexa_url_alias_ml0.text_md5 = ?)
  AND (ibexa_url_alias_ml0.parent = ?)
  AND (u.text_md5 = ?)
  AND (
    u.parent = ibexa_url_alias_ml0.link
  )
LIMIT
  1

SELECT ibexa_url_alias_ml0.id AS ibexa_url_alias_ml0_id, ibexa_url_alias_ml0.link AS ibexa_url_alias_ml0_link, ibexa_url_alias_ml0.is_alias AS ibexa_url_alias_ml0_is_alias, ibexa_url_alias_ml0.alias_redirects AS ibexa_url_alias_ml0_alias_redirects, ibexa_url_alias_ml0.is_original AS ibexa_url_alias_ml0_is_original, ibexa_url_alias_ml0.action AS ibexa_url_alias_ml0_action, ibexa_url_alias_ml0.action_type AS ibexa_url_alias_ml0_action_type, ibexa_url_alias_ml0.lang_mask AS ibexa_url_alias_ml0_lang_mask, ibexa_url_alias_ml0.text AS ibexa_url_alias_ml0_text, ibexa_url_alias_ml0.parent AS ibexa_url_alias_ml0_parent, ibexa_url_alias_ml0.text_md5 AS ibexa_url_alias_ml0_text_md5, u.id AS id, u.link AS link, u.is_alias AS is_alias, u.alias_redirects AS alias_redirects, u.is_original AS is_original, u.action AS action, u.action_type AS action_type, u.lang_mask AS lang_mask, u.text AS text, u.parent AS parent, u.text_md5 AS text_md5 FROM "ibexa_url_alias_ml" ibexa_url_alias_ml0, "ibexa_url_alias_ml" u WHERE (ibexa_url_alias_ml0.text_md5 = '6a06cba411ad9ea54ff4dd07fc9bd8ba') AND (ibexa_url_alias_ml0.parent = 0) AND (u.text_md5 = '03f2197d47a602c679c5f667e3482855') AND (u.parent = ibexa_url_alias_ml0.link) LIMIT 1;

SELECT
  action,
  lang_mask,
  text
FROM
  "ibexa_url_alias_ml"
WHERE
  (
    (parent = ?)
    AND (action = ?)
    AND (id = ?)
  )
  OR (
    (parent = ?)
    AND (action = ?)
    AND (id = ?)
  )

SELECT action, lang_mask, text FROM "ibexa_url_alias_ml" WHERE ((parent = 0) AND (action = 'eznode:386') AND (id = 247)) OR ((parent = 247) AND (action = 'eznode:405') AND (id = 266));

SELECT
  id,
  locale,
  name,
  disabled
FROM
  ibexa_content_language
WHERE
  id IN (?, ?)

SELECT id, locale, name, disabled FROM ibexa_content_language WHERE id IN (2, 4);

SELECT
  t.*
FROM
  ibexa_content_tree t
WHERE
  t.node_id = ?

SELECT t.* FROM ibexa_content_tree t WHERE t.node_id = 405;

SELECT
  t.*
FROM
  ibexa_content_tree t
  LEFT JOIN ibexa_content c ON t.contentobject_id = c.id
WHERE
  (
    (
      (c.language_mask & 3) > 0
    )
    OR (t.node_id = t.parent_node_id)
  )
  AND (t.node_id = ?)

SELECT t.* FROM ibexa_content_tree t LEFT JOIN ibexa_content c ON t.contentobject_id = c.id WHERE (((c.language_mask & 3) > 0) OR (t.node_id = t.parent_node_id)) AND (t.node_id = 405);

SELECT
  c.id AS content_id,
  c.content_type_id AS content_content_type_id,
  c.section_id AS content_section_id,
  c.owner_id AS content_owner_id,
  c.remote_id AS content_remote_id,
  c.current_version AS content_current_version,
  c.initial_language_id AS content_initial_language_id,
  c.modified AS content_modified,
  c.published AS content_published,
  c.status AS content_status,
  c.name AS content_name,
  c.language_mask AS content_language_mask,
  c.is_hidden AS content_is_hidden,
  v.id AS content_version_id,
  v.version AS content_version_version,
  v.modified AS content_version_modified,
  v.creator_id AS content_version_creator_id,
  v.created AS content_version_created,
  v.status AS content_version_status,
  v.language_mask AS content_version_language_mask,
  v.initial_language_id AS content_version_initial_language_id,
  a.id AS content_field_id,
  a.content_type_field_definition_id AS content_field_content_type_field_definition_id,
  a.data_type_string AS content_field_data_type_string,
  a.language_code AS content_field_language_code,
  a.language_id AS content_field_language_id,
  a.data_float AS content_field_data_float,
  a.data_int AS content_field_data_int,
  a.data_text AS content_field_data_text,
  a.sort_key_int AS content_field_sort_key_int,
  a.sort_key_string AS content_field_sort_key_string,
  t.main_node_id AS content_tree_main_node_id
FROM
  ibexa_content c
  INNER JOIN ibexa_content_version v ON (c.id = v.contentobject_id)
  AND (v.version = 2)
  LEFT JOIN ibexa_content_tree t ON (c.id = t.contentobject_id)
  AND (t.node_id = t.main_node_id)
  INNER JOIN ibexa_content_field a ON (
    v.contentobject_id = a.contentobject_id
  )
  AND (v.version = a.version)
WHERE
  (
    c.id IN (?)
  )
  AND (
    a.language_code IN (?)
  )

SELECT c.id AS content_id, c.content_type_id AS content_content_type_id, c.section_id AS content_section_id, c.owner_id AS content_owner_id, c.remote_id AS content_remote_id, c.current_version AS content_current_version, c.initial_language_id AS content_initial_language_id, c.modified AS content_modified, c.published AS content_published, c.status AS content_status, c.name AS content_name, c.language_mask AS content_language_mask, c.is_hidden AS content_is_hidden, v.id AS content_version_id, v.version AS content_version_version, v.modified AS content_version_modified, v.creator_id AS content_version_creator_id, v.created AS content_version_created, v.status AS content_version_status, v.language_mask AS content_version_language_mask, v.initial_language_id AS content_version_initial_language_id, a.id AS content_field_id, a.content_type_field_definition_id AS content_field_content_type_field_definition_id, a.data_type_string AS content_field_data_type_string, a.language_code AS content_field_language_code, a.language_id AS content_field_language_id, a.data_float AS content_field_data_float, a.data_int AS content_field_data_int, a.data_text AS content_field_data_text, a.sort_key_int AS content_field_sort_key_int, a.sort_key_string AS content_field_sort_key_string, t.main_node_id AS content_tree_main_node_id FROM ibexa_content c INNER JOIN ibexa_content_version v ON (c.id = v.contentobject_id) AND (v.version = 2) LEFT JOIN ibexa_content_tree t ON (c.id = t.contentobject_id) AND (t.node_id = t.main_node_id) INNER JOIN ibexa_content_field a ON (v.contentobject_id = a.contentobject_id) AND (v.version = a.version) WHERE (c.id IN (421)) AND (a.language_code IN ('eng-GB'));

SELECT
  contentobject_id AS content_name_contentobject_id,
  content_version AS content_name_content_version,
  name AS content_name_name,
  content_translation AS content_name_content_translation
FROM
  ibexa_content_name
WHERE
  (contentobject_id = ?)
  AND (content_version = ?)

SELECT contentobject_id AS content_name_contentobject_id, content_version AS content_name_content_version, name AS content_name_name, content_translation AS content_name_content_translation FROM ibexa_content_name WHERE (contentobject_id = 421) AND (content_version = 2);

SELECT
  id,
  locale,
  name,
  disabled
FROM
  ibexa_content_language

SELECT id, locale, name, disabled FROM ibexa_content_language;

SELECT
  DISTINCT t.id AS eztags_id,
  t.parent_id AS eztags_parent_id,
  t.main_tag_id AS eztags_main_tag_id,
  t.keyword AS eztags_keyword,
  t.depth AS eztags_depth,
  t.path_string AS eztags_path_string,
  t.modified AS eztags_modified,
  t.remote_id AS eztags_remote_id,
  t.main_language_id AS eztags_main_language_id,
  t.language_mask AS eztags_language_mask,
  k.keyword AS eztags_keyword_keyword,
  k.locale AS eztags_keyword_locale,
  tal.priority AS eztags_attribute_link_priority
FROM
  eztags t
  INNER JOIN eztags_attribute_link tal ON t.id = tal.keyword_id
  INNER JOIN eztags_keyword k ON t.id = k.keyword_id
WHERE
  (tal.objectattribute_id = ?)
  AND (tal.objectattribute_version = ?)
ORDER BY
  tal.priority ASC

SELECT DISTINCT t.id AS eztags_id, t.parent_id AS eztags_parent_id, t.main_tag_id AS eztags_main_tag_id, t.keyword AS eztags_keyword, t.depth AS eztags_depth, t.path_string AS eztags_path_string, t.modified AS eztags_modified, t.remote_id AS eztags_remote_id, t.main_language_id AS eztags_main_language_id, t.language_mask AS eztags_language_mask, k.keyword AS eztags_keyword_keyword, k.locale AS eztags_keyword_locale, tal.priority AS eztags_attribute_link_priority FROM eztags t INNER JOIN eztags_attribute_link tal ON t.id = tal.keyword_id INNER JOIN eztags_keyword k ON t.id = k.keyword_id WHERE (tal.objectattribute_id = 4815) AND (tal.objectattribute_version = 2) ORDER BY tal.priority ASC;

SELECT
  *
FROM
  ibexa_content_tree t
WHERE
  t.contentobject_id = ?

SELECT * FROM ibexa_content_tree t WHERE t.contentobject_id = 421;

SELECT
  DISTINCT rg.*,
  rgd.*
FROM
  nglayouts_rule_group rg
  INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id
WHERE
  (rg.uuid = ?)
  AND (rg.status = ?)

SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = '00000000-0000-0000-0000-000000000000') AND (rg.status = 1);

SELECT
  DISTINCT rg.*,
  rgd.*
FROM
  nglayouts_rule_group rg
  INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id
WHERE
  (rg.uuid = ?)
  AND (rg.status = ?)

SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = '00000000-0000-0000-0000-000000000000') AND (rg.status = 1);

SELECT
  DISTINCT rg.*,
  rgd.*
FROM
  nglayouts_rule_group rg
  INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id
WHERE
  (parent_id = ?)
  AND (rg.status = ?)
ORDER BY
  rgd.priority DESC

SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (parent_id = 1) AND (rg.status = 1) ORDER BY rgd.priority DESC;

SELECT
  DISTINCT rg.*,
  rgd.*
FROM
  nglayouts_rule_group rg
  INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id
WHERE
  (rg.uuid = ?)
  AND (rg.status = ?)

SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = '00000000-0000-0000-0000-000000000000') AND (rg.status = 1);

SELECT
  DISTINCT r.*,
  rd.*,
  l.uuid AS layout_uuid
FROM
  nglayouts_rule r
  INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id
  LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid)
  AND (l.status = ?)
  INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id)
  AND (r.status = rt.status)
WHERE
  (r.rule_group_id = ?)
  AND (rd.enabled = ?)
  AND (rt.type = ?)
  AND (r.status = ?)
  AND (rt.value = ?)
ORDER BY
  rd.priority DESC

SELECT DISTINCT r.*, rd.*, l.uuid AS layout_uuid FROM nglayouts_rule r INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid) AND (l.status = 1) INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id) AND (r.status = rt.status) WHERE (r.rule_group_id = 1) AND (rd.enabled = 1) AND (rt.type = 'ibexa_location') AND (r.status = 1) AND (rt.value = 405) ORDER BY rd.priority DESC;

SELECT
  DISTINCT rg.*,
  rgd.*
FROM
  nglayouts_rule_group rg
  INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id
WHERE
  (rg.id = ?)
  AND (rg.status = ?)

SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.id = 1) AND (rg.status = 1);

SELECT
  DISTINCT c.*,
  cr.rule_id,
  r.uuid AS rule_uuid
FROM
  nglayouts_rule_condition c
  INNER JOIN nglayouts_rule_condition_rule cr ON (cr.condition_id = c.id)
  AND (cr.condition_status = c.status)
  INNER JOIN nglayouts_rule r ON (r.id = cr.rule_id)
  AND (r.status = cr.rule_status)
WHERE
  (cr.rule_id = ?)
  AND (c.status = ?)
ORDER BY
  c.id ASC

SELECT DISTINCT c.*, cr.rule_id, r.uuid AS rule_uuid FROM nglayouts_rule_condition c INNER JOIN nglayouts_rule_condition_rule cr ON (cr.condition_id = c.id) AND (cr.condition_status = c.status) INNER JOIN nglayouts_rule r ON (r.id = cr.rule_id) AND (r.status = cr.rule_status) WHERE (cr.rule_id = 32) AND (c.status = 1) ORDER BY c.id ASC;

SELECT
  DISTINCT rg.*,
  rgd.*
FROM
  nglayouts_rule_group rg
  INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id
WHERE
  (rg.uuid = ?)
  AND (rg.status = ?)

SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = '00000000-0000-0000-0000-000000000000') AND (rg.status = 1);