Symfony Profiler

SELECT
  c.id AS ezcontentclass_id,
  c.version AS ezcontentclass_version,
  c.serialized_name_list AS ezcontentclass_serialized_name_list,
  c.serialized_description_list AS ezcontentclass_serialized_description_list,
  c.identifier AS ezcontentclass_identifier,
  c.created AS ezcontentclass_created,
  c.modified AS ezcontentclass_modified,
  c.modifier_id AS ezcontentclass_modifier_id,
  c.creator_id AS ezcontentclass_creator_id,
  c.remote_id AS ezcontentclass_remote_id,
  c.url_alias_name AS ezcontentclass_url_alias_name,
  c.contentobject_name AS ezcontentclass_contentobject_name,
  c.is_container AS ezcontentclass_is_container,
  c.initial_language_id AS ezcontentclass_initial_language_id,
  c.always_available AS ezcontentclass_always_available,
  c.sort_field AS ezcontentclass_sort_field,
  c.sort_order AS ezcontentclass_sort_order,
  c.language_mask AS ezcontentclass_language_mask,
  a.id AS ezcontentclass_attribute_id,
  a.serialized_name_list AS ezcontentclass_attribute_serialized_name_list,
  a.serialized_description_list AS ezcontentclass_attribute_serialized_description_list,
  a.identifier AS ezcontentclass_attribute_identifier,
  a.category AS ezcontentclass_attribute_category,
  a.data_type_string AS ezcontentclass_attribute_data_type_string,
  a.can_translate AS ezcontentclass_attribute_can_translate,
  a.is_required AS ezcontentclass_attribute_is_required,
  a.is_information_collector AS ezcontentclass_attribute_is_information_collector,
  a.is_searchable AS ezcontentclass_attribute_is_searchable,
  a.is_thumbnail AS ezcontentclass_attribute_is_thumbnail,
  a.placement AS ezcontentclass_attribute_placement,
  a.data_float1 AS ezcontentclass_attribute_data_float1,
  a.data_float2 AS ezcontentclass_attribute_data_float2,
  a.data_float3 AS ezcontentclass_attribute_data_float3,
  a.data_float4 AS ezcontentclass_attribute_data_float4,
  a.data_int1 AS ezcontentclass_attribute_data_int1,
  a.data_int2 AS ezcontentclass_attribute_data_int2,
  a.data_int3 AS ezcontentclass_attribute_data_int3,
  a.data_int4 AS ezcontentclass_attribute_data_int4,
  a.data_text1 AS ezcontentclass_attribute_data_text1,
  a.data_text2 AS ezcontentclass_attribute_data_text2,
  a.data_text3 AS ezcontentclass_attribute_data_text3,
  a.data_text4 AS ezcontentclass_attribute_data_text4,
  a.data_text5 AS ezcontentclass_attribute_data_text5,
  a.serialized_data_text AS ezcontentclass_attribute_serialized_data_text,
  g.group_id AS ezcontentclass_classgroup_group_id,
  ml.name AS ezcontentclass_attribute_multilingual_name,
  ml.description AS ezcontentclass_attribute_multilingual_description,
  ml.language_id AS ezcontentclass_attribute_multilingual_language_id,
  ml.data_text AS ezcontentclass_attribute_multilingual_data_text,
  ml.data_json AS ezcontentclass_attribute_multilingual_data_json
FROM
  ezcontentclass c
  LEFT JOIN ezcontentclass_attribute a ON (c.id = a.contentclass_id)
  AND (c.version = a.version)
  LEFT JOIN ezcontentclass_classgroup g ON (c.id = g.contentclass_id)
  AND (
    c.version = g.contentclass_version
  )
  LEFT JOIN ezcontentclass_attribute_ml ml ON (
    a.id = ml.contentclass_attribute_id
  )
  AND (a.version = ml.version)
WHERE
  (c.identifier = :identifier)
  AND (c.version = :version)
ORDER BY
  a.placement ASC

SELECT c.id AS ezcontentclass_id, c.version AS ezcontentclass_version, c.serialized_name_list AS ezcontentclass_serialized_name_list, c.serialized_description_list AS ezcontentclass_serialized_description_list, c.identifier AS ezcontentclass_identifier, c.created AS ezcontentclass_created, c.modified AS ezcontentclass_modified, c.modifier_id AS ezcontentclass_modifier_id, c.creator_id AS ezcontentclass_creator_id, c.remote_id AS ezcontentclass_remote_id, c.url_alias_name AS ezcontentclass_url_alias_name, c.contentobject_name AS ezcontentclass_contentobject_name, c.is_container AS ezcontentclass_is_container, c.initial_language_id AS ezcontentclass_initial_language_id, c.always_available AS ezcontentclass_always_available, c.sort_field AS ezcontentclass_sort_field, c.sort_order AS ezcontentclass_sort_order, c.language_mask AS ezcontentclass_language_mask, a.id AS ezcontentclass_attribute_id, a.serialized_name_list AS ezcontentclass_attribute_serialized_name_list, a.serialized_description_list AS ezcontentclass_attribute_serialized_description_list, a.identifier AS ezcontentclass_attribute_identifier, a.category AS ezcontentclass_attribute_category, a.data_type_string AS ezcontentclass_attribute_data_type_string, a.can_translate AS ezcontentclass_attribute_can_translate, a.is_required AS ezcontentclass_attribute_is_required, a.is_information_collector AS ezcontentclass_attribute_is_information_collector, a.is_searchable AS ezcontentclass_attribute_is_searchable, a.is_thumbnail AS ezcontentclass_attribute_is_thumbnail, a.placement AS ezcontentclass_attribute_placement, a.data_float1 AS ezcontentclass_attribute_data_float1, a.data_float2 AS ezcontentclass_attribute_data_float2, a.data_float3 AS ezcontentclass_attribute_data_float3, a.data_float4 AS ezcontentclass_attribute_data_float4, a.data_int1 AS ezcontentclass_attribute_data_int1, a.data_int2 AS ezcontentclass_attribute_data_int2, a.data_int3 AS ezcontentclass_attribute_data_int3, a.data_int4 AS ezcontentclass_attribute_data_int4, a.data_text1 AS ezcontentclass_attribute_data_text1, a.data_text2 AS ezcontentclass_attribute_data_text2, a.data_text3 AS ezcontentclass_attribute_data_text3, a.data_text4 AS ezcontentclass_attribute_data_text4, a.data_text5 AS ezcontentclass_attribute_data_text5, a.serialized_data_text AS ezcontentclass_attribute_serialized_data_text, g.group_id AS ezcontentclass_classgroup_group_id, ml.name AS ezcontentclass_attribute_multilingual_name, ml.description AS ezcontentclass_attribute_multilingual_description, ml.language_id AS ezcontentclass_attribute_multilingual_language_id, ml.data_text AS ezcontentclass_attribute_multilingual_data_text, ml.data_json AS ezcontentclass_attribute_multilingual_data_json FROM ezcontentclass c LEFT JOIN ezcontentclass_attribute a ON (c.id = a.contentclass_id) AND (c.version = a.version) LEFT JOIN ezcontentclass_classgroup g ON (c.id = g.contentclass_id) AND (c.version = g.contentclass_version) LEFT JOIN ezcontentclass_attribute_ml ml ON (a.id = ml.contentclass_attribute_id) AND (a.version = ml.version) WHERE (c.identifier = 'ses_productcatalog') AND (c.version = 0) ORDER BY a.placement ASC;

SELECT
  id,
  locale,
  name,
  disabled
FROM
  ezcontent_language
WHERE
  locale IN (:locale)

SELECT id, locale, name, disabled FROM ezcontent_language WHERE locale IN ('ger-DE', 'eng-GB');

SELECT
  t.*,
  c.language_mask,
  c.initial_language_id
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 = 0)
      AND (
        (c.language_mask & 7) > 0
      )
      AND (t.path_string LIKE :dcValue1)
    )
    AND (
      (1 = 1)
      AND (
        (
          c.section_id IN (:dcValue2)
        )
        OR (
          c.section_id IN (:dcValue3)
        )
      )
    )
  )
  AND (c.status = :dcValue4)
  AND (v.status = :dcValue5)
  AND (t.depth <> :dcValue6)
  AND (
    (c.language_mask & :dcValue7) > :dcValue8
  )
LIMIT
  25

SELECT t.*, c.language_mask, c.initial_language_id 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 = 0) AND ((c.language_mask & 7) > 0) AND (t.path_string LIKE '/1/2/%')) AND ((1 = 1) AND ((c.section_id IN ('9', '6', '10', '3', '12', '11', '1')) OR (c.section_id IN ('8'))))) AND (c.status = 1) AND (v.status = 1) AND (t.depth <> 0) AND ((c.language_mask & 7) > 0) LIMIT 25;

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.is_invisible = :dcValue1)
      AND (
        c.contentclass_id IN (:dcValue2)
      )
      AND (
        (c.language_mask & 7) > 0
      )
      AND (t.depth <= :dcValue3)
      AND (
        (
          c.section_id IN (:dcValue4)
        )
        OR (
          c.section_id IN (:dcValue5)
        )
      )
    )
  )
  AND (c.status = :dcValue6)
  AND (v.status = :dcValue7)
  AND (t.depth <> :dcValue8)
  AND (
    (c.language_mask & :dcValue9) > :dcValue10
  )

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.is_invisible = 0) AND (c.contentclass_id IN (42, 1, 43, 48, 45, 47, 46, 56, 57)) AND ((c.language_mask & 7) > 0) AND (t.depth <= 2) AND ((c.section_id IN ('9', '6', '10', '3', '12', '11', '1')) OR (c.section_id IN ('8'))))) AND (c.status = 1) AND (v.status = 1) AND (t.depth <> 0) AND ((c.language_mask & 7) > 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.is_invisible = :dcValue1)
      AND (
        c.contentclass_id IN (:dcValue2)
      )
      AND (
        (c.language_mask & 7) > 0
      )
      AND (t.depth <= :dcValue3)
      AND (
        (
          c.section_id IN (:dcValue4)
        )
        OR (
          c.section_id IN (:dcValue5)
        )
      )
    )
  )
  AND (c.status = :dcValue6)
  AND (v.status = :dcValue7)
  AND (t.depth <> :dcValue8)
  AND (
    (c.language_mask & :dcValue9) > :dcValue10
  )
ORDER BY
  `sort_column_0` ASC
LIMIT
  25

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.is_invisible = 0) AND (c.contentclass_id IN (42, 1, 43, 48, 45, 47, 46, 56, 57)) AND ((c.language_mask & 7) > 0) AND (t.depth <= 2) AND ((c.section_id IN ('9', '6', '10', '3', '12', '11', '1')) OR (c.section_id IN ('8'))))) AND (c.status = 1) AND (v.status = 1) AND (t.depth <> 0) AND ((c.language_mask & 7) > 0) ORDER BY `sort_column_0` ASC LIMIT 25;

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.is_invisible = :dcValue1)
      AND (
        c.contentclass_id IN (:dcValue2)
      )
      AND (
        (c.language_mask & 7) > 0
      )
      AND (t.path_string LIKE :dcValue3)
      AND (t.depth <= :dcValue4)
      AND (
        (
          c.section_id IN (:dcValue5)
        )
        OR (
          c.section_id IN (:dcValue6)
        )
      )
    )
  )
  AND (c.status = :dcValue7)
  AND (v.status = :dcValue8)
  AND (t.depth <> :dcValue9)
  AND (
    (c.language_mask & :dcValue10) > :dcValue11
  )

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.is_invisible = 0) AND (c.contentclass_id IN (42, 1, 43, 48, 45, 47, 46, 56, 57)) AND ((c.language_mask & 7) > 0) AND (t.path_string LIKE '/1/2/102/%') AND (t.depth <= 3) AND ((c.section_id IN ('9', '6', '10', '3', '12', '11', '1')) OR (c.section_id IN ('8'))))) AND (c.status = 1) AND (v.status = 1) AND (t.depth <> 0) AND ((c.language_mask & 7) > 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.is_invisible = :dcValue1)
      AND (
        c.contentclass_id IN (:dcValue2)
      )
      AND (
        (c.language_mask & 7) > 0
      )
      AND (t.path_string LIKE :dcValue3)
      AND (t.depth <= :dcValue4)
      AND (
        (
          c.section_id IN (:dcValue5)
        )
        OR (
          c.section_id IN (:dcValue6)
        )
      )
    )
  )
  AND (c.status = :dcValue7)
  AND (v.status = :dcValue8)
  AND (t.depth <> :dcValue9)
  AND (
    (c.language_mask & :dcValue10) > :dcValue11
  )
ORDER BY
  `sort_column_0` ASC
LIMIT
  25

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.is_invisible = 0) AND (c.contentclass_id IN (42, 1, 43, 48, 45, 47, 46, 56, 57)) AND ((c.language_mask & 7) > 0) AND (t.path_string LIKE '/1/2/102/%') AND (t.depth <= 3) AND ((c.section_id IN ('9', '6', '10', '3', '12', '11', '1')) OR (c.section_id IN ('8'))))) AND (c.status = 1) AND (v.status = 1) AND (t.depth <> 0) AND ((c.language_mask & 7) > 0) ORDER BY `sort_column_0` ASC LIMIT 25;

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

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.is_invisible = :dcValue1)
      AND (
        c.contentclass_id IN (:dcValue2)
      )
      AND (
        (c.language_mask & 7) > 0
      )
      AND (t.path_string LIKE :dcValue3)
      AND (t.depth <= :dcValue4)
      AND (
        (
          c.section_id IN (:dcValue5)
        )
        OR (
          c.section_id IN (:dcValue6)
        )
      )
    )
  )
  AND (c.status = :dcValue7)
  AND (v.status = :dcValue8)
  AND (t.depth <> :dcValue9)
  AND (
    (c.language_mask & :dcValue10) > :dcValue11
  )

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.is_invisible = 0) AND (c.contentclass_id IN (42, 1, 43, 48, 45, 47, 46, 56, 57)) AND ((c.language_mask & 7) > 0) AND (t.path_string LIKE '/1/2/146/%') AND (t.depth <= 3) AND ((c.section_id IN ('9', '6', '10', '3', '12', '11', '1')) OR (c.section_id IN ('8'))))) AND (c.status = 1) AND (v.status = 1) AND (t.depth <> 0) AND ((c.language_mask & 7) > 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.is_invisible = :dcValue1)
      AND (
        c.contentclass_id IN (:dcValue2)
      )
      AND (
        (c.language_mask & 7) > 0
      )
      AND (t.path_string LIKE :dcValue3)
      AND (t.depth <= :dcValue4)
      AND (
        (
          c.section_id IN (:dcValue5)
        )
        OR (
          c.section_id IN (:dcValue6)
        )
      )
    )
  )
  AND (c.status = :dcValue7)
  AND (v.status = :dcValue8)
  AND (t.depth <> :dcValue9)
  AND (
    (c.language_mask & :dcValue10) > :dcValue11
  )
ORDER BY
  `sort_column_0` ASC
LIMIT
  25

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.is_invisible = 0) AND (c.contentclass_id IN (42, 1, 43, 48, 45, 47, 46, 56, 57)) AND ((c.language_mask & 7) > 0) AND (t.path_string LIKE '/1/2/146/%') AND (t.depth <= 3) AND ((c.section_id IN ('9', '6', '10', '3', '12', '11', '1')) OR (c.section_id IN ('8'))))) AND (c.status = 1) AND (v.status = 1) AND (t.depth <> 0) AND ((c.language_mask & 7) > 0) ORDER BY `sort_column_0` ASC LIMIT 25;

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.is_invisible = :dcValue1)
      AND (
        c.contentclass_id IN (:dcValue2)
      )
      AND (
        (c.language_mask & 7) > 0
      )
      AND (t.path_string LIKE :dcValue3)
      AND (t.depth <= :dcValue4)
      AND (
        (
          c.section_id IN (:dcValue5)
        )
        OR (
          c.section_id IN (:dcValue6)
        )
      )
    )
  )
  AND (c.status = :dcValue7)
  AND (v.status = :dcValue8)
  AND (t.depth <> :dcValue9)
  AND (
    (c.language_mask & :dcValue10) > :dcValue11
  )

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.is_invisible = 0) AND (c.contentclass_id IN (42, 1, 43, 48, 45, 47, 46, 56, 57)) AND ((c.language_mask & 7) > 0) AND (t.path_string LIKE '/1/2/413/%') AND (t.depth <= 3) AND ((c.section_id IN ('9', '6', '10', '3', '12', '11', '1')) OR (c.section_id IN ('8'))))) AND (c.status = 1) AND (v.status = 1) AND (t.depth <> 0) AND ((c.language_mask & 7) > 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.is_invisible = :dcValue1)
      AND (
        c.contentclass_id IN (:dcValue2)
      )
      AND (
        (c.language_mask & 7) > 0
      )
      AND (t.path_string LIKE :dcValue3)
      AND (t.depth <= :dcValue4)
      AND (
        (
          c.section_id IN (:dcValue5)
        )
        OR (
          c.section_id IN (:dcValue6)
        )
      )
    )
  )
  AND (c.status = :dcValue7)
  AND (v.status = :dcValue8)
  AND (t.depth <> :dcValue9)
  AND (
    (c.language_mask & :dcValue10) > :dcValue11
  )
ORDER BY
  `sort_column_0` ASC
LIMIT
  25

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.is_invisible = 0) AND (c.contentclass_id IN (42, 1, 43, 48, 45, 47, 46, 56, 57)) AND ((c.language_mask & 7) > 0) AND (t.path_string LIKE '/1/2/413/%') AND (t.depth <= 3) AND ((c.section_id IN ('9', '6', '10', '3', '12', '11', '1')) OR (c.section_id IN ('8'))))) AND (c.status = 1) AND (v.status = 1) AND (t.depth <> 0) AND ((c.language_mask & 7) > 0) ORDER BY `sort_column_0` ASC LIMIT 25;

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.is_invisible = :dcValue1)
      AND (
        c.contentclass_id IN (:dcValue2)
      )
      AND (
        (c.language_mask & 7) > 0
      )
      AND (t.path_string LIKE :dcValue3)
      AND (t.depth <= :dcValue4)
      AND (
        (
          c.section_id IN (:dcValue5)
        )
        OR (
          c.section_id IN (:dcValue6)
        )
      )
    )
  )
  AND (c.status = :dcValue7)
  AND (v.status = :dcValue8)
  AND (t.depth <> :dcValue9)
  AND (
    (c.language_mask & :dcValue10) > :dcValue11
  )

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.is_invisible = 0) AND (c.contentclass_id IN (42, 1, 43, 48, 45, 47, 46, 56, 57)) AND ((c.language_mask & 7) > 0) AND (t.path_string LIKE '/1/2/413/63/%') AND (t.depth <= 4) AND ((c.section_id IN ('9', '6', '10', '3', '12', '11', '1')) OR (c.section_id IN ('8'))))) AND (c.status = 1) AND (v.status = 1) AND (t.depth <> 0) AND ((c.language_mask & 7) > 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.is_invisible = :dcValue1)
      AND (
        c.contentclass_id IN (:dcValue2)
      )
      AND (
        (c.language_mask & 7) > 0
      )
      AND (t.path_string LIKE :dcValue3)
      AND (t.depth <= :dcValue4)
      AND (
        (
          c.section_id IN (:dcValue5)
        )
        OR (
          c.section_id IN (:dcValue6)
        )
      )
    )
  )
  AND (c.status = :dcValue7)
  AND (v.status = :dcValue8)
  AND (t.depth <> :dcValue9)
  AND (
    (c.language_mask & :dcValue10) > :dcValue11
  )
ORDER BY
  `sort_column_0` ASC
LIMIT
  25

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.is_invisible = 0) AND (c.contentclass_id IN (42, 1, 43, 48, 45, 47, 46, 56, 57)) AND ((c.language_mask & 7) > 0) AND (t.path_string LIKE '/1/2/413/63/%') AND (t.depth <= 4) AND ((c.section_id IN ('9', '6', '10', '3', '12', '11', '1')) OR (c.section_id IN ('8'))))) AND (c.status = 1) AND (v.status = 1) AND (t.depth <> 0) AND ((c.language_mask & 7) > 0) ORDER BY `sort_column_0` ASC LIMIT 25;

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.is_invisible = :dcValue1)
      AND (
        c.contentclass_id IN (:dcValue2)
      )
      AND (
        (c.language_mask & 7) > 0
      )
      AND (t.path_string LIKE :dcValue3)
      AND (t.depth <= :dcValue4)
      AND (
        (
          c.section_id IN (:dcValue5)
        )
        OR (
          c.section_id IN (:dcValue6)
        )
      )
    )
  )
  AND (c.status = :dcValue7)
  AND (v.status = :dcValue8)
  AND (t.depth <> :dcValue9)
  AND (
    (c.language_mask & :dcValue10) > :dcValue11
  )

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.is_invisible = 0) AND (c.contentclass_id IN (42, 1, 43, 48, 45, 47, 46, 56, 57)) AND ((c.language_mask & 7) > 0) AND (t.path_string LIKE '/1/2/413/469/%') AND (t.depth <= 4) AND ((c.section_id IN ('9', '6', '10', '3', '12', '11', '1')) OR (c.section_id IN ('8'))))) AND (c.status = 1) AND (v.status = 1) AND (t.depth <> 0) AND ((c.language_mask & 7) > 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.is_invisible = :dcValue1)
      AND (
        c.contentclass_id IN (:dcValue2)
      )
      AND (
        (c.language_mask & 7) > 0
      )
      AND (t.path_string LIKE :dcValue3)
      AND (t.depth <= :dcValue4)
      AND (
        (
          c.section_id IN (:dcValue5)
        )
        OR (
          c.section_id IN (:dcValue6)
        )
      )
    )
  )
  AND (c.status = :dcValue7)
  AND (v.status = :dcValue8)
  AND (t.depth <> :dcValue9)
  AND (
    (c.language_mask & :dcValue10) > :dcValue11
  )
ORDER BY
  `sort_column_0` ASC
LIMIT
  25

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.is_invisible = 0) AND (c.contentclass_id IN (42, 1, 43, 48, 45, 47, 46, 56, 57)) AND ((c.language_mask & 7) > 0) AND (t.path_string LIKE '/1/2/413/469/%') AND (t.depth <= 4) AND ((c.section_id IN ('9', '6', '10', '3', '12', '11', '1')) OR (c.section_id IN ('8'))))) AND (c.status = 1) AND (v.status = 1) AND (t.depth <> 0) AND ((c.language_mask & 7) > 0) ORDER BY `sort_column_0` ASC LIMIT 25;

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.is_invisible = :dcValue1)
      AND (
        c.contentclass_id IN (:dcValue2)
      )
      AND (
        (c.language_mask & 7) > 0
      )
      AND (t.path_string LIKE :dcValue3)
      AND (t.depth <= :dcValue4)
      AND (
        (
          c.section_id IN (:dcValue5)
        )
        OR (
          c.section_id IN (:dcValue6)
        )
      )
    )
  )
  AND (c.status = :dcValue7)
  AND (v.status = :dcValue8)
  AND (t.depth <> :dcValue9)
  AND (
    (c.language_mask & :dcValue10) > :dcValue11
  )

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.is_invisible = 0) AND (c.contentclass_id IN (42, 1, 43, 48, 45, 47, 46, 56, 57)) AND ((c.language_mask & 7) > 0) AND (t.path_string LIKE '/1/2/413/61/%') AND (t.depth <= 4) AND ((c.section_id IN ('9', '6', '10', '3', '12', '11', '1')) OR (c.section_id IN ('8'))))) AND (c.status = 1) AND (v.status = 1) AND (t.depth <> 0) AND ((c.language_mask & 7) > 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.is_invisible = :dcValue1)
      AND (
        c.contentclass_id IN (:dcValue2)
      )
      AND (
        (c.language_mask & 7) > 0
      )
      AND (t.path_string LIKE :dcValue3)
      AND (t.depth <= :dcValue4)
      AND (
        (
          c.section_id IN (:dcValue5)
        )
        OR (
          c.section_id IN (:dcValue6)
        )
      )
    )
  )
  AND (c.status = :dcValue7)
  AND (v.status = :dcValue8)
  AND (t.depth <> :dcValue9)
  AND (
    (c.language_mask & :dcValue10) > :dcValue11
  )
ORDER BY
  `sort_column_0` ASC
LIMIT
  25

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.is_invisible = 0) AND (c.contentclass_id IN (42, 1, 43, 48, 45, 47, 46, 56, 57)) AND ((c.language_mask & 7) > 0) AND (t.path_string LIKE '/1/2/413/61/%') AND (t.depth <= 4) AND ((c.section_id IN ('9', '6', '10', '3', '12', '11', '1')) OR (c.section_id IN ('8'))))) AND (c.status = 1) AND (v.status = 1) AND (t.depth <> 0) AND ((c.language_mask & 7) > 0) ORDER BY `sort_column_0` ASC LIMIT 25;