Symfony Profiler

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 = 393) ORDER BY rd.priority DESC;

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 = 409) AND (content_version = 2);

SELECT
  *
FROM
  ibexa_content_tree t
WHERE
  t.contentobject_id = ?

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

SELECT
  c.id AS content_type_id,
  c.status AS content_type_status,
  c.serialized_name_list AS content_type_serialized_name_list,
  c.serialized_description_list AS content_type_serialized_description_list,
  c.identifier AS content_type_identifier,
  c.created AS content_type_created,
  c.modified AS content_type_modified,
  c.modifier_id AS content_type_modifier_id,
  c.creator_id AS content_type_creator_id,
  c.remote_id AS content_type_remote_id,
  c.url_alias_name AS content_type_url_alias_name,
  c.contentobject_name AS content_type_contentobject_name,
  c.is_container AS content_type_is_container,
  c.initial_language_id AS content_type_initial_language_id,
  c.always_available AS content_type_always_available,
  c.sort_field AS content_type_sort_field,
  c.sort_order AS content_type_sort_order,
  c.language_mask AS content_type_language_mask,
  a.id AS content_type_field_definition_id,
  a.serialized_name_list AS content_type_field_definition_serialized_name_list,
  a.serialized_description_list AS content_type_field_definition_serialized_description_list,
  a.identifier AS content_type_field_definition_identifier,
  a.category AS content_type_field_definition_category,
  a.data_type_string AS content_type_field_definition_data_type_string,
  a.can_translate AS content_type_field_definition_can_translate,
  a.is_required AS content_type_field_definition_is_required,
  a.is_information_collector AS content_type_field_definition_is_information_collector,
  a.is_searchable AS content_type_field_definition_is_searchable,
  a.is_thumbnail AS content_type_field_definition_is_thumbnail,
  a.placement AS content_type_field_definition_placement,
  a.data_float1 AS content_type_field_definition_data_float1,
  a.data_float2 AS content_type_field_definition_data_float2,
  a.data_float3 AS content_type_field_definition_data_float3,
  a.data_float4 AS content_type_field_definition_data_float4,
  a.data_int1 AS content_type_field_definition_data_int1,
  a.data_int2 AS content_type_field_definition_data_int2,
  a.data_int3 AS content_type_field_definition_data_int3,
  a.data_int4 AS content_type_field_definition_data_int4,
  a.data_text1 AS content_type_field_definition_data_text1,
  a.data_text2 AS content_type_field_definition_data_text2,
  a.data_text3 AS content_type_field_definition_data_text3,
  a.data_text4 AS content_type_field_definition_data_text4,
  a.data_text5 AS content_type_field_definition_data_text5,
  a.serialized_data_text AS content_type_field_definition_serialized_data_text,
  g.group_id AS content_type_group_assignment_group_id,
  ml.name AS content_type_field_definition_multilingual_name,
  ml.description AS content_type_field_definition_multilingual_description,
  ml.language_id AS content_type_field_definition_multilingual_language_id,
  ml.data_text AS content_type_field_definition_multilingual_data_text,
  ml.data_json AS content_type_field_definition_multilingual_data_json
FROM
  ibexa_content_type c
  LEFT JOIN ibexa_content_type_field_definition a ON (c.id = a.content_type_id)
  AND (c.status = a.status)
  LEFT JOIN ibexa_content_type_group_assignment g ON (c.id = g.content_type_id)
  AND (c.status = g.content_type_status)
  LEFT JOIN ibexa_content_type_field_definition_ml ml ON (
    a.id = ml.content_type_field_definition_id
  )
  AND (a.status = ml.status)
WHERE
  (c.id = ?)
  AND (c.status = ?)
ORDER BY
  a.placement ASC

SELECT c.id AS content_type_id, c.status AS content_type_status, c.serialized_name_list AS content_type_serialized_name_list, c.serialized_description_list AS content_type_serialized_description_list, c.identifier AS content_type_identifier, c.created AS content_type_created, c.modified AS content_type_modified, c.modifier_id AS content_type_modifier_id, c.creator_id AS content_type_creator_id, c.remote_id AS content_type_remote_id, c.url_alias_name AS content_type_url_alias_name, c.contentobject_name AS content_type_contentobject_name, c.is_container AS content_type_is_container, c.initial_language_id AS content_type_initial_language_id, c.always_available AS content_type_always_available, c.sort_field AS content_type_sort_field, c.sort_order AS content_type_sort_order, c.language_mask AS content_type_language_mask, a.id AS content_type_field_definition_id, a.serialized_name_list AS content_type_field_definition_serialized_name_list, a.serialized_description_list AS content_type_field_definition_serialized_description_list, a.identifier AS content_type_field_definition_identifier, a.category AS content_type_field_definition_category, a.data_type_string AS content_type_field_definition_data_type_string, a.can_translate AS content_type_field_definition_can_translate, a.is_required AS content_type_field_definition_is_required, a.is_information_collector AS content_type_field_definition_is_information_collector, a.is_searchable AS content_type_field_definition_is_searchable, a.is_thumbnail AS content_type_field_definition_is_thumbnail, a.placement AS content_type_field_definition_placement, a.data_float1 AS content_type_field_definition_data_float1, a.data_float2 AS content_type_field_definition_data_float2, a.data_float3 AS content_type_field_definition_data_float3, a.data_float4 AS content_type_field_definition_data_float4, a.data_int1 AS content_type_field_definition_data_int1, a.data_int2 AS content_type_field_definition_data_int2, a.data_int3 AS content_type_field_definition_data_int3, a.data_int4 AS content_type_field_definition_data_int4, a.data_text1 AS content_type_field_definition_data_text1, a.data_text2 AS content_type_field_definition_data_text2, a.data_text3 AS content_type_field_definition_data_text3, a.data_text4 AS content_type_field_definition_data_text4, a.data_text5 AS content_type_field_definition_data_text5, a.serialized_data_text AS content_type_field_definition_serialized_data_text, g.group_id AS content_type_group_assignment_group_id, ml.name AS content_type_field_definition_multilingual_name, ml.description AS content_type_field_definition_multilingual_description, ml.language_id AS content_type_field_definition_multilingual_language_id, ml.data_text AS content_type_field_definition_multilingual_data_text, ml.data_json AS content_type_field_definition_multilingual_data_json FROM ibexa_content_type c LEFT JOIN ibexa_content_type_field_definition a ON (c.id = a.content_type_id) AND (c.status = a.status) LEFT JOIN ibexa_content_type_group_assignment g ON (c.id = g.content_type_id) AND (c.status = g.content_type_status) LEFT JOIN ibexa_content_type_field_definition_ml ml ON (a.id = ml.content_type_field_definition_id) AND (a.status = ml.status) WHERE (c.id = 50) AND (c.status = 0) ORDER BY a.placement ASC;

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

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

SELECT
  parent,
  lang_mask,
  text
FROM
  `ibexa_url_alias_ml`
WHERE
  id = ?

SELECT parent, lang_mask, text FROM `ibexa_url_alias_ml` WHERE id = 248;

SELECT
  DISTINCT identifier
FROM
  `sckenhancedselection`
WHERE
  (contentobject_attribute_id = ?)
  AND (
    contentobject_attribute_version = ?
  )

SELECT DISTINCT identifier FROM `sckenhancedselection` WHERE (contentobject_attribute_id = 5469) AND (contentobject_attribute_version = 8);

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 (409)) 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
  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.contentobject_id AS content_version_contentobject_id,
  v.initial_language_id AS content_version_initial_language_id,
  v.language_mask AS content_version_language_mask,
  t.main_node_id AS content_tree_main_node_id,
  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
FROM
  ibexa_content_version v
  INNER JOIN ibexa_content c ON c.id = v.contentobject_id
  LEFT JOIN ibexa_content_tree t ON (
    t.contentobject_id = v.contentobject_id
  )
  AND (t.main_node_id = t.node_id)
WHERE
  (v.contentobject_id = ?)
  AND (v.version = c.current_version)

SELECT 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.contentobject_id AS content_version_contentobject_id, v.initial_language_id AS content_version_initial_language_id, v.language_mask AS content_version_language_mask, t.main_node_id AS content_tree_main_node_id, 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 FROM ibexa_content_version v INNER JOIN ibexa_content c ON c.id = v.contentobject_id LEFT JOIN ibexa_content_tree t ON (t.contentobject_id = v.contentobject_id) AND (t.main_node_id = t.node_id) WHERE (v.contentobject_id = 427) AND (v.version = c.current_version);

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` = 5784) AND (`version` = 18);