Symfony Profiler

SELECT
  COUNT(*)
FROM
  ezcontentobject_tree t
  INNER JOIN ezcontentobject c ON t.contentobject_id = c.id
  INNER JOIN ezcontentobject_version v ON c.id = v.contentobject_id
WHERE
  (
    (1 = 1)
    AND (
      t.parent_node_id IN (:dcValue1)
    )
  )
  AND (c.status = :dcValue2)
  AND (v.status = :dcValue3)
  AND (t.depth <> :dcValue4)
  AND (
    (c.language_mask & :dcValue5) > :dcValue6
  )

SELECT COUNT(*) FROM ezcontentobject_tree t INNER JOIN ezcontentobject c ON t.contentobject_id = c.id INNER JOIN ezcontentobject_version v ON c.id = v.contentobject_id WHERE ((1 = 1) AND (t.parent_node_id IN (2))) AND (c.status = 1) AND (v.status = 1) AND (t.depth <> 0) AND ((c.language_mask & 3) > 0);

SELECT
  t.*,
  c.language_mask,
  c.initial_language_id,
  t.priority AS `sort_column_0`
FROM
  ezcontentobject_tree t
  INNER JOIN ezcontentobject c ON t.contentobject_id = c.id
  INNER JOIN ezcontentobject_version v ON c.id = v.contentobject_id
WHERE
  (
    (1 = 1)
    AND (
      t.parent_node_id IN (:dcValue1)
    )
  )
  AND (c.status = :dcValue2)
  AND (v.status = :dcValue3)
  AND (t.depth <> :dcValue4)
  AND (
    (c.language_mask & :dcValue5) > :dcValue6
  )
ORDER BY
  `sort_column_0` ASC
LIMIT
  11

SELECT t.*, c.language_mask, c.initial_language_id, t.priority AS `sort_column_0` FROM ezcontentobject_tree t INNER JOIN ezcontentobject c ON t.contentobject_id = c.id INNER JOIN ezcontentobject_version v ON c.id = v.contentobject_id WHERE ((1 = 1) AND (t.parent_node_id IN (2))) AND (c.status = 1) AND (v.status = 1) AND (t.depth <> 0) AND ((c.language_mask & 3) > 0) ORDER BY `sort_column_0` ASC LIMIT 11;

SELECT
  COUNT(*)
FROM
  ezcontentobject_tree t
  INNER JOIN ezcontentobject c ON t.contentobject_id = c.id
  INNER JOIN ezcontentobject_version v ON c.id = v.contentobject_id
WHERE
  (
    (1 = 1)
    AND (
      t.parent_node_id IN (:dcValue1)
    )
  )
  AND (c.status = :dcValue2)
  AND (v.status = :dcValue3)
  AND (t.depth <> :dcValue4)
  AND (
    (c.language_mask & :dcValue5) > :dcValue6
  )

SELECT COUNT(*) FROM ezcontentobject_tree t INNER JOIN ezcontentobject c ON t.contentobject_id = c.id INNER JOIN ezcontentobject_version v ON c.id = v.contentobject_id WHERE ((1 = 1) AND (t.parent_node_id IN (2))) AND (c.status = 1) AND (v.status = 1) AND (t.depth <> 0) AND ((c.language_mask & 3) > 0);

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 (:dcValue1)
      )
    )
    AND (c.status = 1)
    AND (v.status = 1)
  )
  AND (
    (c.language_mask & :language_mask) > :zero
  )

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 (54))) AND (c.status = 1) AND (v.status = 1)) AND ((c.language_mask & 3) > 0);

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 (:dcValue1)
      )
    )
    AND (c.status = 1)
    AND (v.status = 1)
  )
  AND (
    (c.language_mask & :language_mask) > :zero
  )
LIMIT
  2

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 (54))) AND (c.status = 1) AND (v.status = 1)) AND ((c.language_mask & 3) > 0) LIMIT 2;

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 (:dcValue1)
      )
    )
    AND (c.status = 1)
    AND (v.status = 1)
  )
  AND (
    (c.language_mask & :language_mask) > :zero
  )

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 (164))) AND (c.status = 1) AND (v.status = 1)) AND ((c.language_mask & 3) > 0);

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 (:dcValue1)
      )
    )
    AND (c.status = 1)
    AND (v.status = 1)
  )
  AND (
    (c.language_mask & :language_mask) > :zero
  )
LIMIT
  2

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 (164))) AND (c.status = 1) AND (v.status = 1)) AND ((c.language_mask & 3) > 0) LIMIT 2;

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 (:dcValue1)
      )
    )
    AND (c.status = 1)
    AND (v.status = 1)
  )
  AND (
    (c.language_mask & :language_mask) > :zero
  )

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 (165))) AND (c.status = 1) AND (v.status = 1)) AND ((c.language_mask & 3) > 0);

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 (:dcValue1)
      )
    )
    AND (c.status = 1)
    AND (v.status = 1)
  )
  AND (
    (c.language_mask & :language_mask) > :zero
  )
LIMIT
  2

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 (165))) AND (c.status = 1) AND (v.status = 1)) AND ((c.language_mask & 3) > 0) LIMIT 2;

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 (:dcValue1)
      )
    )
    AND (c.status = 1)
    AND (v.status = 1)
  )
  AND (
    (c.language_mask & :language_mask) > :zero
  )

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 (168))) AND (c.status = 1) AND (v.status = 1)) AND ((c.language_mask & 3) > 0);

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 (:dcValue1)
      )
    )
    AND (c.status = 1)
    AND (v.status = 1)
  )
  AND (
    (c.language_mask & :language_mask) > :zero
  )
LIMIT
  2

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 (168))) AND (c.status = 1) AND (v.status = 1)) AND ((c.language_mask & 3) > 0) LIMIT 2;

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 (:dcValue1)
      )
    )
    AND (c.status = 1)
    AND (v.status = 1)
  )
  AND (
    (c.language_mask & :language_mask) > :zero
  )

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 (169))) AND (c.status = 1) AND (v.status = 1)) AND ((c.language_mask & 3) > 0);

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 (:dcValue1)
      )
    )
    AND (c.status = 1)
    AND (v.status = 1)
  )
  AND (
    (c.language_mask & :language_mask) > :zero
  )
LIMIT
  2

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 (169))) AND (c.status = 1) AND (v.status = 1)) AND ((c.language_mask & 3) > 0) LIMIT 2;

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 (:dcValue1)
      )
    )
    AND (c.status = 1)
    AND (v.status = 1)
  )
  AND (
    (c.language_mask & :language_mask) > :zero
  )

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 (170))) AND (c.status = 1) AND (v.status = 1)) AND ((c.language_mask & 3) > 0);

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 (:dcValue1)
      )
    )
    AND (c.status = 1)
    AND (v.status = 1)
  )
  AND (
    (c.language_mask & :language_mask) > :zero
  )
LIMIT
  2

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 (170))) AND (c.status = 1) AND (v.status = 1)) AND ((c.language_mask & 3) > 0) LIMIT 2;

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 (:dcValue1)
      )
    )
    AND (c.status = 1)
    AND (v.status = 1)
  )
  AND (
    (c.language_mask & :language_mask) > :zero
  )

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 (172))) AND (c.status = 1) AND (v.status = 1)) AND ((c.language_mask & 3) > 0);

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 (:dcValue1)
      )
    )
    AND (c.status = 1)
    AND (v.status = 1)
  )
  AND (
    (c.language_mask & :language_mask) > :zero
  )
LIMIT
  2

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 (172))) AND (c.status = 1) AND (v.status = 1)) AND ((c.language_mask & 3) > 0) LIMIT 2;

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 (:dcValue1)
      )
    )
    AND (c.status = 1)
    AND (v.status = 1)
  )
  AND (
    (c.language_mask & :language_mask) > :zero
  )

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 (173))) AND (c.status = 1) AND (v.status = 1)) AND ((c.language_mask & 3) > 0);

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 (:dcValue1)
      )
    )
    AND (c.status = 1)
    AND (v.status = 1)
  )
  AND (
    (c.language_mask & :language_mask) > :zero
  )
LIMIT
  2

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 (173))) AND (c.status = 1) AND (v.status = 1)) AND ((c.language_mask & 3) > 0) LIMIT 2;

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 (:dcValue1)
      )
    )
    AND (c.status = 1)
    AND (v.status = 1)
  )
  AND (
    (c.language_mask & :language_mask) > :zero
  )

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 (175))) AND (c.status = 1) AND (v.status = 1)) AND ((c.language_mask & 3) > 0);

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 (:dcValue1)
      )
    )
    AND (c.status = 1)
    AND (v.status = 1)
  )
  AND (
    (c.language_mask & :language_mask) > :zero
  )
LIMIT
  2

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 (175))) AND (c.status = 1) AND (v.status = 1)) AND ((c.language_mask & 3) > 0) LIMIT 2;