Symfony Profiler

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.placeholder = ?)
  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 = 475) AND (b.placeholder = 'main') AND (b.status = 1) ORDER BY b.placeholder ASC, b.position 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 = ?)
  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
  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 (
        c.content_type_id IN (?)
      )
      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/385/%') AND (t.is_invisible = 0) AND (NOT (t.node_id IN (385))) AND (t.node_id = t.main_node_id) AND (c.content_type_id IN (93)) AND (NOT (t.node_id IN (385))) 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 & 3) > 0);

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 (t.node_id = t.main_node_id)
      AND (
        c.content_type_id IN (?, ?, ?, ?)
      )
      AND (
        c.id IN (
          SELECT
            t1.id
          FROM
            ibexa_content t1
            INNER JOIN eztags_attribute_link t2 ON (
              t2.objectattribute_version = t1.current_version
            )
            AND (t2.object_id = t1.id)
          WHERE
            t2.keyword_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/385/%') AND (t.is_invisible = 0) AND (t.node_id = t.main_node_id) AND (c.content_type_id IN (44, 95, 45, 93)) AND (c.id IN (SELECT t1.id FROM ibexa_content t1 INNER JOIN eztags_attribute_link t2 ON (t2.objectattribute_version = t1.current_version) AND (t2.object_id = t1.id) WHERE t2.keyword_id IN (8))) 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 & 3) > 0);

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

SELECT DISTINCT i.*, c.uuid AS collection_uuid FROM nglayouts_collection_item i INNER JOIN nglayouts_collection c ON (c.id = i.collection_id) AND (c.status = i.status) WHERE (i.collection_id = 91) AND (i.status = 1) ORDER BY i.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 = ?)
  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 = 91) AND (s.status = 1) ORDER BY s.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 = ?)
  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 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 = 91) AND (q.status = 1);

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 (
        c.content_type_id IN (?, ?, ?)
      )
      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/385/167/%') AND (t.is_invisible = 0) AND (NOT (t.node_id IN (167))) AND (t.node_id = t.main_node_id) AND (t.depth = 4) AND (c.content_type_id IN (44, 95, 45)) AND (NOT (t.node_id IN (385))) 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 & 3) > 0);

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);