Symfony Profiler

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
  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
  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
  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",
  "url"
FROM
  ibexa_url
WHERE
  id IN (?)

SELECT "id", "url" FROM ibexa_url WHERE id IN (362);

SELECT
  DISTINCT b.*,
  bt.*,
  l.uuid as layout_uuid
FROM
  nglayouts_block b
  INNER JOIN nglayouts_block_translation bt ON (bt.block_id = b.id)
  AND (bt.status = b.status)
  INNER JOIN nglayouts_layout l ON (l.id = b.layout_id)
  AND (l.status = b.status)
WHERE
  (b.parent_id = ?)
  AND (b.status = ?)
ORDER BY
  b.placeholder ASC,
  b.position ASC

SELECT DISTINCT b.*, bt.*, l.uuid as layout_uuid FROM nglayouts_block b INNER JOIN nglayouts_block_translation bt ON (bt.block_id = b.id) AND (bt.status = b.status) INNER JOIN nglayouts_layout l ON (l.id = b.layout_id) AND (l.status = b.status) WHERE (b.parent_id = 8) AND (b.status = 1) ORDER BY b.placeholder ASC, b.position ASC;

SELECT
  "filename",
  "mime_type",
  "original_filename",
  "download_count"
FROM
  "ibexa_binary_file"
WHERE
  ("contentobject_attribute_id" = ?)
  AND ("version" = ?)

SELECT "filename", "mime_type", "original_filename", "download_count" FROM "ibexa_binary_file" WHERE ("contentobject_attribute_id" = 4899) AND ("version" = 12);

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 = 8)
  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 = 8) 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 (434)) AND (a.language_code IN ('eng-GB'));

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 c.*,
  ct.*,
  bc.*
FROM
  nglayouts_collection c
  INNER JOIN nglayouts_collection_translation ct ON (ct.collection_id = c.id)
  AND (ct.status = c.status)
  INNER JOIN nglayouts_block_collection bc ON (c.id = bc.collection_id)
  AND (c.status = bc.collection_status)
WHERE
  (bc.block_id = ?)
  AND (bc.block_status = ?)
ORDER BY
  bc.identifier ASC

SELECT DISTINCT c.*, ct.*, bc.* FROM nglayouts_collection c INNER JOIN nglayouts_collection_translation ct ON (ct.collection_id = c.id) AND (ct.status = c.status) INNER JOIN nglayouts_block_collection bc ON (c.id = bc.collection_id) AND (c.status = bc.collection_status) WHERE (bc.block_id = 13) AND (bc.block_status = 1) ORDER BY bc.identifier ASC;

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 = 12)
  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 = 12) 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 (428)) AND (a.language_code IN ('eng-GB'));