Symfony Profiler

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
  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
  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
  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 z.*,
  l.uuid as layout_uuid
FROM
  nglayouts_zone z
  INNER JOIN nglayouts_layout l ON (l.id = z.layout_id)
  AND (l.status = z.status)
WHERE
  (z.identifier = ?)
  AND (l.uuid = ?)
  AND (l.status = ?)

SELECT DISTINCT z.*, l.uuid as layout_uuid FROM nglayouts_zone z INNER JOIN nglayouts_layout l ON (l.id = z.layout_id) AND (l.status = z.status) WHERE (z.identifier = 'header') AND (l.uuid = 'fd0aa7af-77a8-5a03-bf10-80018f5db1dc') AND (l.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 (
    (
      CHAR_LENGTH(
        TRIM(rt.value)
      ) > ?
    )
    AND (
      ? LIKE CONCAT(
        TRIM(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_semantic_path_info_prefix') AND (r.status = 1) AND ((CHAR_LENGTH(TRIM(rt.value)) > 0) AND ('/karriere' LIKE CONCAT(TRIM(rt.value), '%'))) ORDER BY rd.priority DESC;

SELECT
  DISTINCT q.*,
  qt.*,
  c.uuid as collection_uuid
FROM
  nglayouts_collection_query q
  INNER JOIN nglayouts_collection_query_translation qt ON (qt.query_id = q.id)
  AND (qt.status = q.status)
  INNER JOIN nglayouts_collection c ON (c.id = q.collection_id)
  AND (c.status = q.status)
WHERE
  (q.collection_id = ?)
  AND (q.status = ?)

SELECT DISTINCT q.*, qt.*, c.uuid as collection_uuid FROM nglayouts_collection_query q INNER JOIN nglayouts_collection_query_translation qt ON (qt.query_id = q.id) AND (qt.status = q.status) INNER JOIN nglayouts_collection c ON (c.id = q.collection_id) AND (c.status = q.status) WHERE (q.collection_id = 111) AND (q.status = 1);

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.id = ?)
  AND (b.status = ?)

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.id = 8) AND (b.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 = 31) AND (c.status = 1) ORDER BY c.id ASC;

SELECT
  COUNT(t.node_id)
FROM
  ibexa_content_tree t
  INNER JOIN ibexa_content c ON t.contentobject_id = c.id
  INNER JOIN ibexa_content_version v ON c.id = v.contentobject_id
WHERE
  (
    (1 = 1)
    AND (
      (t.path_string LIKE ?)
      AND (t.is_invisible = ?)
      AND (
        NOT (
          t.node_id IN (?)
        )
      )
      AND (t.node_id = t.main_node_id)
      AND (t.depth = ?)
      AND (
        NOT (
          t.node_id IN (?)
        )
      )
      AND (
        (
          c.section_id IN (?)
        )
        OR (
          (
            c.content_type_id IN (
              ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
              ?, ?, ?, ?, ?, ?
            )
          )
          AND (
            c.section_id IN (?)
          )
        )
      )
    )
  )
  AND (c.status = ?)
  AND (v.status = ?)
  AND (t.depth <> ?)
  AND (
    (c.language_mask & ?) > ?
  )

SELECT COUNT(t.node_id) FROM ibexa_content_tree t INNER JOIN ibexa_content c ON t.contentobject_id = c.id INNER JOIN ibexa_content_version v ON c.id = v.contentobject_id WHERE ((1 = 1) AND ((t.path_string LIKE '/1/2/386/393/399/%') AND (t.is_invisible = 0) AND (NOT (t.node_id IN (399))) AND (t.node_id = t.main_node_id) AND (t.depth = 5) AND (NOT (t.node_id IN (393))) AND ((c.section_id IN (1)) OR ((c.content_type_id IN ('100', '103', '104', '105', '106', '107', '108', '111', '113', '118', '119', '120', '37', '41', '42', '49', '50', '51', '80', '81', '95', '97')) AND (c.section_id IN (3)))))) AND (c.status = 1) AND (v.status = 1) AND (t.depth <> 0) AND ((c.language_mask & 5) > 0);

SELECT
  DISTINCT s.*,
  c.uuid AS collection_uuid
FROM
  nglayouts_collection_slot s
  INNER JOIN nglayouts_collection c ON (c.id = s.collection_id)
  AND (c.status = s.status)
WHERE
  (s.collection_id = ?)
  AND (s.status = ?)
ORDER BY
  s.position ASC

SELECT DISTINCT s.*, c.uuid AS collection_uuid FROM nglayouts_collection_slot s INNER JOIN nglayouts_collection c ON (c.id = s.collection_id) AND (c.status = s.status) WHERE (s.collection_id = 111) AND (s.status = 1) ORDER BY s.position ASC;

SELECT
  t.*,
  c.language_mask,
  c.initial_language_id,
  c.published AS `sort_column_0`
FROM
  ibexa_content_tree t
  INNER JOIN ibexa_content c ON t.contentobject_id = c.id
  INNER JOIN ibexa_content_version v ON c.id = v.contentobject_id
WHERE
  (
    (1 = 1)
    AND (
      (t.path_string LIKE ?)
      AND (t.is_invisible = ?)
      AND (
        NOT (
          t.node_id IN (?)
        )
      )
      AND (t.node_id = t.main_node_id)
      AND (t.depth = ?)
      AND (
        NOT (
          t.node_id IN (?)
        )
      )
      AND (
        (
          c.section_id IN (?)
        )
        OR (
          (
            c.content_type_id IN (
              ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
              ?, ?, ?, ?, ?, ?
            )
          )
          AND (
            c.section_id IN (?)
          )
        )
      )
    )
  )
  AND (c.status = ?)
  AND (v.status = ?)
  AND (t.depth <> ?)
  AND (
    (c.language_mask & ?) > ?
  )
ORDER BY
  `sort_column_0` DESC
LIMIT
  200

SELECT t.*, c.language_mask, c.initial_language_id, c.published AS `sort_column_0` FROM ibexa_content_tree t INNER JOIN ibexa_content c ON t.contentobject_id = c.id INNER JOIN ibexa_content_version v ON c.id = v.contentobject_id WHERE ((1 = 1) AND ((t.path_string LIKE '/1/2/386/393/399/%') AND (t.is_invisible = 0) AND (NOT (t.node_id IN (399))) AND (t.node_id = t.main_node_id) AND (t.depth = 5) AND (NOT (t.node_id IN (393))) AND ((c.section_id IN (1)) OR ((c.content_type_id IN ('100', '103', '104', '105', '106', '107', '108', '111', '113', '118', '119', '120', '37', '41', '42', '49', '50', '51', '80', '81', '95', '97')) AND (c.section_id IN (3)))))) AND (c.status = 1) AND (v.status = 1) AND (t.depth <> 0) AND ((c.language_mask & 5) > 0) ORDER BY `sort_column_0` DESC LIMIT 200;

SELECT
  DISTINCT l.*,
  lt.*
FROM
  nglayouts_layout l
  INNER JOIN nglayouts_layout_translation lt ON (lt.layout_id = l.id)
  AND (lt.status = l.status)
WHERE
  (l.uuid = ?)
  AND (l.status = ?)

SELECT DISTINCT l.*, lt.* FROM nglayouts_layout l INNER JOIN nglayouts_layout_translation lt ON (lt.layout_id = l.id) AND (lt.status = l.status) WHERE (l.uuid = 'eabac01c-d00a-493c-9bb5-4e0e9c0f7fec') AND (l.status = 1);