Symfony Profiler

SELECT
  COUNT(DISTINCT c.id)
FROM
  ezcontentobject c
  INNER JOIN ezcontentobject_version v ON c.id = v.contentobject_id
WHERE
  (
    (1 = 1)
    AND (
      (
        c.id IN (
          SELECT
            contentobject_id
          FROM
            ezcontentobject_tree
          WHERE
            parent_node_id IN (:dcValue1)
        )
      )
      AND (
        c.id IN (
          SELECT
            contentobject_id
          FROM
            ezcontentobject_tree subquery_location
          WHERE
            (subquery_location.is_hidden = 0)
            AND (
              subquery_location.is_invisible = 0
            )
        )
      )
      AND (
        c.contentclass_id IN (:dcValue2)
      )
      AND (
        c.id IN (
          SELECT
            contentobject_id
          FROM
            ezcontentobject_tree
          WHERE
            path_string LIKE :dcValue3
        )
      )
      AND (
        (
          c.section_id IN (:dcValue4)
        )
        OR (
          c.section_id IN (:dcValue5)
        )
        OR (
          c.section_id IN (:dcValue6)
        )
        OR (
          (
            c.contentclass_id IN (:dcValue7)
          )
          AND (
            c.id IN (
              SELECT
                contentobject_id
              FROM
                ezcontentobject_tree
              WHERE
                node_id IN (:dcValue8)
            )
          )
        )
      )
    )
  )
  AND (c.status = 1)
  AND (v.status = 1)

SELECT COUNT( DISTINCT c.id ) FROM ezcontentobject c INNER JOIN ezcontentobject_version v ON c.id = v.contentobject_id WHERE ((1 = 1) AND ((c.id IN (SELECT contentobject_id FROM ezcontentobject_tree WHERE parent_node_id IN (72))) AND (c.id IN (SELECT contentobject_id FROM ezcontentobject_tree subquery_location WHERE (subquery_location.is_hidden = 0) AND (subquery_location.is_invisible = 0))) AND (c.contentclass_id IN (61)) AND (c.id IN (SELECT contentobject_id FROM ezcontentobject_tree WHERE path_string LIKE '/1/2/42/72/%')) AND ((c.section_id IN ('1', '3', '6')) OR (c.section_id IN ('8')) OR (c.section_id IN ('9')) OR ((c.contentclass_id IN ('1')) AND (c.id IN (SELECT contentobject_id FROM ezcontentobject_tree WHERE node_id IN ('66'))))))) AND (c.status = 1) AND (v.status = 1);

SELECT
  DISTINCT c.*,
  main_tree.main_node_id AS main_tree_main_node_id
FROM
  ezcontentobject c
  INNER JOIN ezcontentobject_version v ON c.id = v.contentobject_id
  LEFT JOIN ezcontentobject_tree main_tree ON (
    main_tree.contentobject_id = c.id
  )
  AND (
    main_tree.main_node_id = main_tree.node_id
  )
WHERE
  (
    (1 = 1)
    AND (
      (
        c.id IN (
          SELECT
            contentobject_id
          FROM
            ezcontentobject_tree
          WHERE
            parent_node_id IN (:dcValue1)
        )
      )
      AND (
        c.id IN (
          SELECT
            contentobject_id
          FROM
            ezcontentobject_tree subquery_location
          WHERE
            (subquery_location.is_hidden = 0)
            AND (
              subquery_location.is_invisible = 0
            )
        )
      )
      AND (
        c.contentclass_id IN (:dcValue2)
      )
      AND (
        c.id IN (
          SELECT
            contentobject_id
          FROM
            ezcontentobject_tree
          WHERE
            path_string LIKE :dcValue3
        )
      )
      AND (
        (
          c.section_id IN (:dcValue4)
        )
        OR (
          c.section_id IN (:dcValue5)
        )
        OR (
          c.section_id IN (:dcValue6)
        )
        OR (
          (
            c.contentclass_id IN (:dcValue7)
          )
          AND (
            c.id IN (
              SELECT
                contentobject_id
              FROM
                ezcontentobject_tree
              WHERE
                node_id IN (:dcValue8)
            )
          )
        )
      )
    )
  )
  AND (c.status = 1)
  AND (v.status = 1)
LIMIT
  25

SELECT DISTINCT c.*, main_tree.main_node_id AS main_tree_main_node_id FROM ezcontentobject c INNER JOIN ezcontentobject_version v ON c.id = v.contentobject_id LEFT JOIN ezcontentobject_tree main_tree ON (main_tree.contentobject_id = c.id) AND (main_tree.main_node_id = main_tree.node_id) WHERE ((1 = 1) AND ((c.id IN (SELECT contentobject_id FROM ezcontentobject_tree WHERE parent_node_id IN (72))) AND (c.id IN (SELECT contentobject_id FROM ezcontentobject_tree subquery_location WHERE (subquery_location.is_hidden = 0) AND (subquery_location.is_invisible = 0))) AND (c.contentclass_id IN (61)) AND (c.id IN (SELECT contentobject_id FROM ezcontentobject_tree WHERE path_string LIKE '/1/2/42/72/%')) AND ((c.section_id IN ('1', '3', '6')) OR (c.section_id IN ('8')) OR (c.section_id IN ('9')) OR ((c.contentclass_id IN ('1')) AND (c.id IN (SELECT contentobject_id FROM ezcontentobject_tree WHERE node_id IN ('66'))))))) AND (c.status = 1) AND (v.status = 1) LIMIT 25;