| 1 |
4.47 ms |
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject`.`id` IN ( SELECT `contentobject_id` FROM `ezcontentobject_attribute` WHERE ( `ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version` AND ( `contentclassattribute_id` IN ( '4', '6', '116', '146', '413' ) AND `sort_key_string` = :placeholder2 ) AND (`ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`) > :placeholder3 ) ) AND `ezcontentobject`.`contentclass_id` IN ( 1 ) AND `ezcontentobject_tree`.`parent_node_id` IN ( 4748 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder4 AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder5 AND ezcontentobject_version.status = :placeholder6 AND `ezcontentobject_tree`.`depth` <> :placeholder7
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => "bloques"
":placeholder3" => 0
":placeholder4" => 0
":placeholder5" => 1
":placeholder6" => 1
":placeholder7" => 0
]
SELECT
COUNT(*) count
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject`.`id` IN (
SELECT
`contentobject_id`
FROM
`ezcontentobject_attribute`
WHERE
(
`ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version`
AND (
`contentclassattribute_id` IN ('4', '6', '116', '146', '413')
AND `sort_key_string` = : placeholder2
)
AND (
`ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`
) > : placeholder3
)
)
AND `ezcontentobject`.`contentclass_id` IN (1)
AND `ezcontentobject_tree`.`parent_node_id` IN (4748)
AND `ezcontentobject_tree`.`is_invisible` = : placeholder4
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder5
AND ezcontentobject_version.status = : placeholder6
AND `ezcontentobject_tree`.`depth` <> : placeholder7
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject`.`id` IN ( SELECT `contentobject_id` FROM `ezcontentobject_attribute` WHERE ( `ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version` AND ( `contentclassattribute_id` IN ( '4', '6', '116', '146', '413' ) AND `sort_key_string` = :placeholder2 ) AND (`ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`) > :placeholder3 ) ) AND `ezcontentobject`.`contentclass_id` IN ( 1 ) AND `ezcontentobject_tree`.`parent_node_id` IN ( 4748 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder4 AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder5 AND ezcontentobject_version.status = :placeholder6 AND `ezcontentobject_tree`.`depth` <> :placeholder7;
|
| 2 |
1.68 ms |
SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject`.`id` IN ( SELECT `contentobject_id` FROM `ezcontentobject_attribute` WHERE ( `ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version` AND ( `contentclassattribute_id` IN ( '4', '6', '116', '146', '413' ) AND `sort_key_string` = :placeholder2 ) AND (`ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`) > :placeholder3 ) ) AND `ezcontentobject`.`contentclass_id` IN ( 1 ) AND `ezcontentobject_tree`.`parent_node_id` IN ( 4748 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder4 AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder5 AND ezcontentobject_version.status = :placeholder6 AND `ezcontentobject_tree`.`depth` <> :placeholder7 LIMIT 25
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => "bloques"
":placeholder3" => 0
":placeholder4" => 0
":placeholder5" => 1
":placeholder6" => 1
":placeholder7" => 0
]
SELECT
ezcontentobject_tree.*,
`ezcontentobject`.`language_mask`,
`ezcontentobject`.`initial_language_id`
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject`.`id` IN (
SELECT
`contentobject_id`
FROM
`ezcontentobject_attribute`
WHERE
(
`ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version`
AND (
`contentclassattribute_id` IN ('4', '6', '116', '146', '413')
AND `sort_key_string` = : placeholder2
)
AND (
`ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`
) > : placeholder3
)
)
AND `ezcontentobject`.`contentclass_id` IN (1)
AND `ezcontentobject_tree`.`parent_node_id` IN (4748)
AND `ezcontentobject_tree`.`is_invisible` = : placeholder4
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder5
AND ezcontentobject_version.status = : placeholder6
AND `ezcontentobject_tree`.`depth` <> : placeholder7
LIMIT
25
SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject`.`id` IN ( SELECT `contentobject_id` FROM `ezcontentobject_attribute` WHERE ( `ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version` AND ( `contentclassattribute_id` IN ( '4', '6', '116', '146', '413' ) AND `sort_key_string` = :placeholder2 ) AND (`ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`) > :placeholder3 ) ) AND `ezcontentobject`.`contentclass_id` IN ( 1 ) AND `ezcontentobject_tree`.`parent_node_id` IN ( 4748 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder4 AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder5 AND ezcontentobject_version.status = :placeholder6 AND `ezcontentobject_tree`.`depth` <> :placeholder7 LIMIT 25;
|
| 3 |
1.14 ms |
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`parent_node_id` IN ( 4749 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND (`ezcontentobject`.`language_mask` & 7) > 0 AND NOT ( `ezcontentobject`.`contentclass_id` IN ( 1 ) ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => 0
":placeholder3" => 1
":placeholder4" => 1
":placeholder5" => 0
]
SELECT
COUNT(*) count
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject_tree`.`parent_node_id` IN (4749)
AND `ezcontentobject_tree`.`is_invisible` = : placeholder2
AND (
`ezcontentobject`.`language_mask` & 7
) > 0
AND NOT (
`ezcontentobject`.`contentclass_id` IN (1)
)
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder3
AND ezcontentobject_version.status = : placeholder4
AND `ezcontentobject_tree`.`depth` <> : placeholder5
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`parent_node_id` IN ( 4749 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND (`ezcontentobject`.`language_mask` & 7) > 0 AND NOT ( `ezcontentobject`.`contentclass_id` IN ( 1 ) ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5;
|
| 4 |
1.26 ms |
SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id`, `ezcontentobject_tree`.`priority` `sort_column_0` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`parent_node_id` IN ( 4749 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND (`ezcontentobject`.`language_mask` & 7) > 0 AND NOT ( `ezcontentobject`.`contentclass_id` IN ( 1 ) ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5 ORDER BY `sort_column_0` ASC LIMIT 25
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => 0
":placeholder3" => 1
":placeholder4" => 1
":placeholder5" => 0
]
SELECT
ezcontentobject_tree.*,
`ezcontentobject`.`language_mask`,
`ezcontentobject`.`initial_language_id`,
`ezcontentobject_tree`.`priority` `sort_column_0`
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject_tree`.`parent_node_id` IN (4749)
AND `ezcontentobject_tree`.`is_invisible` = : placeholder2
AND (
`ezcontentobject`.`language_mask` & 7
) > 0
AND NOT (
`ezcontentobject`.`contentclass_id` IN (1)
)
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder3
AND ezcontentobject_version.status = : placeholder4
AND `ezcontentobject_tree`.`depth` <> : placeholder5
ORDER BY
`sort_column_0` ASC
LIMIT
25
SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id`, `ezcontentobject_tree`.`priority` `sort_column_0` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`parent_node_id` IN ( 4749 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND (`ezcontentobject`.`language_mask` & 7) > 0 AND NOT ( `ezcontentobject`.`contentclass_id` IN ( 1 ) ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5 ORDER BY `sort_column_0` ASC LIMIT 25;
|
| 5 |
1.21 ms |
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 18 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 2701 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => 0
":placeholder3" => 1
":placeholder4" => 1
":placeholder5" => 0
]
SELECT
COUNT(*) count
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject_tree`.`is_invisible` = : placeholder2
AND `ezcontentobject`.`contentclass_id` IN (18)
AND (
`ezcontentobject`.`language_mask` & 7
) > 0
AND `ezcontentobject_tree`.`parent_node_id` IN (2701)
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder3
AND ezcontentobject_version.status = : placeholder4
AND `ezcontentobject_tree`.`depth` <> : placeholder5
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 18 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 2701 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5;
|
| 6 |
1.20 ms |
SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id`, `ezcontentobject_tree`.`priority` `sort_column_0` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 18 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 2701 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5 ORDER BY `sort_column_0` ASC LIMIT 25
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => 0
":placeholder3" => 1
":placeholder4" => 1
":placeholder5" => 0
]
SELECT
ezcontentobject_tree.*,
`ezcontentobject`.`language_mask`,
`ezcontentobject`.`initial_language_id`,
`ezcontentobject_tree`.`priority` `sort_column_0`
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject_tree`.`is_invisible` = : placeholder2
AND `ezcontentobject`.`contentclass_id` IN (18)
AND (
`ezcontentobject`.`language_mask` & 7
) > 0
AND `ezcontentobject_tree`.`parent_node_id` IN (2701)
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder3
AND ezcontentobject_version.status = : placeholder4
AND `ezcontentobject_tree`.`depth` <> : placeholder5
ORDER BY
`sort_column_0` ASC
LIMIT
25
SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id`, `ezcontentobject_tree`.`priority` `sort_column_0` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 18 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 2701 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5 ORDER BY `sort_column_0` ASC LIMIT 25;
|
| 7 |
0.93 ms |
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 19 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 2782 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => 0
":placeholder3" => 1
":placeholder4" => 1
":placeholder5" => 0
]
SELECT
COUNT(*) count
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject_tree`.`is_invisible` = : placeholder2
AND `ezcontentobject`.`contentclass_id` IN (19)
AND (
`ezcontentobject`.`language_mask` & 7
) > 0
AND `ezcontentobject_tree`.`parent_node_id` IN (2782)
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder3
AND ezcontentobject_version.status = : placeholder4
AND `ezcontentobject_tree`.`depth` <> : placeholder5
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 19 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 2782 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5;
|
| 8 |
0.92 ms |
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 19 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 4687 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => 0
":placeholder3" => 1
":placeholder4" => 1
":placeholder5" => 0
]
SELECT
COUNT(*) count
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject_tree`.`is_invisible` = : placeholder2
AND `ezcontentobject`.`contentclass_id` IN (19)
AND (
`ezcontentobject`.`language_mask` & 7
) > 0
AND `ezcontentobject_tree`.`parent_node_id` IN (4687)
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder3
AND ezcontentobject_version.status = : placeholder4
AND `ezcontentobject_tree`.`depth` <> : placeholder5
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 19 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 4687 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5;
|
| 9 |
0.83 ms |
SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id`, `ezcontentobject_tree`.`priority` `sort_column_0` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 19 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 4687 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5 ORDER BY `sort_column_0` ASC LIMIT 25
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => 0
":placeholder3" => 1
":placeholder4" => 1
":placeholder5" => 0
]
SELECT
ezcontentobject_tree.*,
`ezcontentobject`.`language_mask`,
`ezcontentobject`.`initial_language_id`,
`ezcontentobject_tree`.`priority` `sort_column_0`
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject_tree`.`is_invisible` = : placeholder2
AND `ezcontentobject`.`contentclass_id` IN (19)
AND (
`ezcontentobject`.`language_mask` & 7
) > 0
AND `ezcontentobject_tree`.`parent_node_id` IN (4687)
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder3
AND ezcontentobject_version.status = : placeholder4
AND `ezcontentobject_tree`.`depth` <> : placeholder5
ORDER BY
`sort_column_0` ASC
LIMIT
25
SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id`, `ezcontentobject_tree`.`priority` `sort_column_0` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 19 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 4687 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5 ORDER BY `sort_column_0` ASC LIMIT 25;
|
| 10 |
0.79 ms |
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 19 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 4561 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => 0
":placeholder3" => 1
":placeholder4" => 1
":placeholder5" => 0
]
SELECT
COUNT(*) count
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject_tree`.`is_invisible` = : placeholder2
AND `ezcontentobject`.`contentclass_id` IN (19)
AND (
`ezcontentobject`.`language_mask` & 7
) > 0
AND `ezcontentobject_tree`.`parent_node_id` IN (4561)
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder3
AND ezcontentobject_version.status = : placeholder4
AND `ezcontentobject_tree`.`depth` <> : placeholder5
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 19 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 4561 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5;
|
| 11 |
0.78 ms |
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 19 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 4675 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => 0
":placeholder3" => 1
":placeholder4" => 1
":placeholder5" => 0
]
SELECT
COUNT(*) count
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject_tree`.`is_invisible` = : placeholder2
AND `ezcontentobject`.`contentclass_id` IN (19)
AND (
`ezcontentobject`.`language_mask` & 7
) > 0
AND `ezcontentobject_tree`.`parent_node_id` IN (4675)
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder3
AND ezcontentobject_version.status = : placeholder4
AND `ezcontentobject_tree`.`depth` <> : placeholder5
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 19 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 4675 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5;
|
| 12 |
0.78 ms |
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 19 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 4709 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => 0
":placeholder3" => 1
":placeholder4" => 1
":placeholder5" => 0
]
SELECT
COUNT(*) count
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject_tree`.`is_invisible` = : placeholder2
AND `ezcontentobject`.`contentclass_id` IN (19)
AND (
`ezcontentobject`.`language_mask` & 7
) > 0
AND `ezcontentobject_tree`.`parent_node_id` IN (4709)
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder3
AND ezcontentobject_version.status = : placeholder4
AND `ezcontentobject_tree`.`depth` <> : placeholder5
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 19 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 4709 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5;
|
| 13 |
1.11 ms |
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject`.`id` IN ( SELECT `contentobject_id` FROM `ezcontentobject_attribute` WHERE ( `ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version` AND ( `contentclassattribute_id` IN ( '4', '6', '116', '146', '413' ) AND `sort_key_string` = :placeholder2 ) AND (`ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`) > :placeholder3 ) ) AND `ezcontentobject`.`contentclass_id` IN ( 1 ) AND `ezcontentobject_tree`.`parent_node_id` IN ( 4748 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder4 AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder5 AND ezcontentobject_version.status = :placeholder6 AND `ezcontentobject_tree`.`depth` <> :placeholder7
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => "bloques"
":placeholder3" => 0
":placeholder4" => 0
":placeholder5" => 1
":placeholder6" => 1
":placeholder7" => 0
]
SELECT
COUNT(*) count
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject`.`id` IN (
SELECT
`contentobject_id`
FROM
`ezcontentobject_attribute`
WHERE
(
`ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version`
AND (
`contentclassattribute_id` IN ('4', '6', '116', '146', '413')
AND `sort_key_string` = : placeholder2
)
AND (
`ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`
) > : placeholder3
)
)
AND `ezcontentobject`.`contentclass_id` IN (1)
AND `ezcontentobject_tree`.`parent_node_id` IN (4748)
AND `ezcontentobject_tree`.`is_invisible` = : placeholder4
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder5
AND ezcontentobject_version.status = : placeholder6
AND `ezcontentobject_tree`.`depth` <> : placeholder7
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject`.`id` IN ( SELECT `contentobject_id` FROM `ezcontentobject_attribute` WHERE ( `ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version` AND ( `contentclassattribute_id` IN ( '4', '6', '116', '146', '413' ) AND `sort_key_string` = :placeholder2 ) AND (`ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`) > :placeholder3 ) ) AND `ezcontentobject`.`contentclass_id` IN ( 1 ) AND `ezcontentobject_tree`.`parent_node_id` IN ( 4748 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder4 AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder5 AND ezcontentobject_version.status = :placeholder6 AND `ezcontentobject_tree`.`depth` <> :placeholder7;
|
| 14 |
0.97 ms |
SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject`.`id` IN ( SELECT `contentobject_id` FROM `ezcontentobject_attribute` WHERE ( `ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version` AND ( `contentclassattribute_id` IN ( '4', '6', '116', '146', '413' ) AND `sort_key_string` = :placeholder2 ) AND (`ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`) > :placeholder3 ) ) AND `ezcontentobject`.`contentclass_id` IN ( 1 ) AND `ezcontentobject_tree`.`parent_node_id` IN ( 4748 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder4 AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder5 AND ezcontentobject_version.status = :placeholder6 AND `ezcontentobject_tree`.`depth` <> :placeholder7 LIMIT 25
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => "bloques"
":placeholder3" => 0
":placeholder4" => 0
":placeholder5" => 1
":placeholder6" => 1
":placeholder7" => 0
]
SELECT
ezcontentobject_tree.*,
`ezcontentobject`.`language_mask`,
`ezcontentobject`.`initial_language_id`
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject`.`id` IN (
SELECT
`contentobject_id`
FROM
`ezcontentobject_attribute`
WHERE
(
`ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version`
AND (
`contentclassattribute_id` IN ('4', '6', '116', '146', '413')
AND `sort_key_string` = : placeholder2
)
AND (
`ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`
) > : placeholder3
)
)
AND `ezcontentobject`.`contentclass_id` IN (1)
AND `ezcontentobject_tree`.`parent_node_id` IN (4748)
AND `ezcontentobject_tree`.`is_invisible` = : placeholder4
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder5
AND ezcontentobject_version.status = : placeholder6
AND `ezcontentobject_tree`.`depth` <> : placeholder7
LIMIT
25
SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject`.`id` IN ( SELECT `contentobject_id` FROM `ezcontentobject_attribute` WHERE ( `ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version` AND ( `contentclassattribute_id` IN ( '4', '6', '116', '146', '413' ) AND `sort_key_string` = :placeholder2 ) AND (`ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`) > :placeholder3 ) ) AND `ezcontentobject`.`contentclass_id` IN ( 1 ) AND `ezcontentobject_tree`.`parent_node_id` IN ( 4748 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder4 AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder5 AND ezcontentobject_version.status = :placeholder6 AND `ezcontentobject_tree`.`depth` <> :placeholder7 LIMIT 25;
|
| 15 |
0.80 ms |
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`parent_node_id` IN ( 4749 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND (`ezcontentobject`.`language_mask` & 7) > 0 AND NOT ( `ezcontentobject`.`contentclass_id` IN ( 1 ) ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => 0
":placeholder3" => 1
":placeholder4" => 1
":placeholder5" => 0
]
SELECT
COUNT(*) count
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject_tree`.`parent_node_id` IN (4749)
AND `ezcontentobject_tree`.`is_invisible` = : placeholder2
AND (
`ezcontentobject`.`language_mask` & 7
) > 0
AND NOT (
`ezcontentobject`.`contentclass_id` IN (1)
)
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder3
AND ezcontentobject_version.status = : placeholder4
AND `ezcontentobject_tree`.`depth` <> : placeholder5
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`parent_node_id` IN ( 4749 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND (`ezcontentobject`.`language_mask` & 7) > 0 AND NOT ( `ezcontentobject`.`contentclass_id` IN ( 1 ) ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5;
|
| 16 |
0.91 ms |
SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id`, `ezcontentobject_tree`.`priority` `sort_column_0` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`parent_node_id` IN ( 4749 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND (`ezcontentobject`.`language_mask` & 7) > 0 AND NOT ( `ezcontentobject`.`contentclass_id` IN ( 1 ) ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5 ORDER BY `sort_column_0` ASC LIMIT 25
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => 0
":placeholder3" => 1
":placeholder4" => 1
":placeholder5" => 0
]
SELECT
ezcontentobject_tree.*,
`ezcontentobject`.`language_mask`,
`ezcontentobject`.`initial_language_id`,
`ezcontentobject_tree`.`priority` `sort_column_0`
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject_tree`.`parent_node_id` IN (4749)
AND `ezcontentobject_tree`.`is_invisible` = : placeholder2
AND (
`ezcontentobject`.`language_mask` & 7
) > 0
AND NOT (
`ezcontentobject`.`contentclass_id` IN (1)
)
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder3
AND ezcontentobject_version.status = : placeholder4
AND `ezcontentobject_tree`.`depth` <> : placeholder5
ORDER BY
`sort_column_0` ASC
LIMIT
25
SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id`, `ezcontentobject_tree`.`priority` `sort_column_0` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`parent_node_id` IN ( 4749 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND (`ezcontentobject`.`language_mask` & 7) > 0 AND NOT ( `ezcontentobject`.`contentclass_id` IN ( 1 ) ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5 ORDER BY `sort_column_0` ASC LIMIT 25;
|
| 17 |
1.01 ms |
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject`.`id` IN ( SELECT `contentobject_id` FROM `ezcontentobject_attribute` WHERE ( `ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version` AND ( `contentclassattribute_id` IN ( '4', '6', '116', '146', '413' ) AND `sort_key_string` = :placeholder2 ) AND (`ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`) > :placeholder3 ) ) AND `ezcontentobject`.`contentclass_id` IN ( 1 ) AND `ezcontentobject_tree`.`parent_node_id` IN ( 2701 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder4 AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder5 AND ezcontentobject_version.status = :placeholder6 AND `ezcontentobject_tree`.`depth` <> :placeholder7
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => "footer"
":placeholder3" => 0
":placeholder4" => 0
":placeholder5" => 1
":placeholder6" => 1
":placeholder7" => 0
]
SELECT
COUNT(*) count
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject`.`id` IN (
SELECT
`contentobject_id`
FROM
`ezcontentobject_attribute`
WHERE
(
`ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version`
AND (
`contentclassattribute_id` IN ('4', '6', '116', '146', '413')
AND `sort_key_string` = : placeholder2
)
AND (
`ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`
) > : placeholder3
)
)
AND `ezcontentobject`.`contentclass_id` IN (1)
AND `ezcontentobject_tree`.`parent_node_id` IN (2701)
AND `ezcontentobject_tree`.`is_invisible` = : placeholder4
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder5
AND ezcontentobject_version.status = : placeholder6
AND `ezcontentobject_tree`.`depth` <> : placeholder7
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject`.`id` IN ( SELECT `contentobject_id` FROM `ezcontentobject_attribute` WHERE ( `ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version` AND ( `contentclassattribute_id` IN ( '4', '6', '116', '146', '413' ) AND `sort_key_string` = :placeholder2 ) AND (`ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`) > :placeholder3 ) ) AND `ezcontentobject`.`contentclass_id` IN ( 1 ) AND `ezcontentobject_tree`.`parent_node_id` IN ( 2701 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder4 AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder5 AND ezcontentobject_version.status = :placeholder6 AND `ezcontentobject_tree`.`depth` <> :placeholder7;
|
| 18 |
0.91 ms |
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject`.`id` IN ( SELECT `contentobject_id` FROM `ezcontentobject_attribute` WHERE ( `ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version` AND ( `contentclassattribute_id` IN ( '4', '6', '116', '146', '413' ) AND `sort_key_string` = :placeholder2 ) AND (`ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`) > :placeholder3 ) ) AND `ezcontentobject`.`contentclass_id` IN ( 1 ) AND `ezcontentobject_tree`.`parent_node_id` IN ( 240 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder4 AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder5 AND ezcontentobject_version.status = :placeholder6 AND `ezcontentobject_tree`.`depth` <> :placeholder7
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => "footer"
":placeholder3" => 0
":placeholder4" => 0
":placeholder5" => 1
":placeholder6" => 1
":placeholder7" => 0
]
SELECT
COUNT(*) count
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject`.`id` IN (
SELECT
`contentobject_id`
FROM
`ezcontentobject_attribute`
WHERE
(
`ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version`
AND (
`contentclassattribute_id` IN ('4', '6', '116', '146', '413')
AND `sort_key_string` = : placeholder2
)
AND (
`ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`
) > : placeholder3
)
)
AND `ezcontentobject`.`contentclass_id` IN (1)
AND `ezcontentobject_tree`.`parent_node_id` IN (240)
AND `ezcontentobject_tree`.`is_invisible` = : placeholder4
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder5
AND ezcontentobject_version.status = : placeholder6
AND `ezcontentobject_tree`.`depth` <> : placeholder7
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject`.`id` IN ( SELECT `contentobject_id` FROM `ezcontentobject_attribute` WHERE ( `ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version` AND ( `contentclassattribute_id` IN ( '4', '6', '116', '146', '413' ) AND `sort_key_string` = :placeholder2 ) AND (`ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`) > :placeholder3 ) ) AND `ezcontentobject`.`contentclass_id` IN ( 1 ) AND `ezcontentobject_tree`.`parent_node_id` IN ( 240 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder4 AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder5 AND ezcontentobject_version.status = :placeholder6 AND `ezcontentobject_tree`.`depth` <> :placeholder7;
|
| 19 |
0.85 ms |
SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject`.`id` IN ( SELECT `contentobject_id` FROM `ezcontentobject_attribute` WHERE ( `ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version` AND ( `contentclassattribute_id` IN ( '4', '6', '116', '146', '413' ) AND `sort_key_string` = :placeholder2 ) AND (`ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`) > :placeholder3 ) ) AND `ezcontentobject`.`contentclass_id` IN ( 1 ) AND `ezcontentobject_tree`.`parent_node_id` IN ( 240 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder4 AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder5 AND ezcontentobject_version.status = :placeholder6 AND `ezcontentobject_tree`.`depth` <> :placeholder7 LIMIT 25
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => "footer"
":placeholder3" => 0
":placeholder4" => 0
":placeholder5" => 1
":placeholder6" => 1
":placeholder7" => 0
]
SELECT
ezcontentobject_tree.*,
`ezcontentobject`.`language_mask`,
`ezcontentobject`.`initial_language_id`
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject`.`id` IN (
SELECT
`contentobject_id`
FROM
`ezcontentobject_attribute`
WHERE
(
`ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version`
AND (
`contentclassattribute_id` IN ('4', '6', '116', '146', '413')
AND `sort_key_string` = : placeholder2
)
AND (
`ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`
) > : placeholder3
)
)
AND `ezcontentobject`.`contentclass_id` IN (1)
AND `ezcontentobject_tree`.`parent_node_id` IN (240)
AND `ezcontentobject_tree`.`is_invisible` = : placeholder4
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder5
AND ezcontentobject_version.status = : placeholder6
AND `ezcontentobject_tree`.`depth` <> : placeholder7
LIMIT
25
SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject`.`id` IN ( SELECT `contentobject_id` FROM `ezcontentobject_attribute` WHERE ( `ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version` AND ( `contentclassattribute_id` IN ( '4', '6', '116', '146', '413' ) AND `sort_key_string` = :placeholder2 ) AND (`ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`) > :placeholder3 ) ) AND `ezcontentobject`.`contentclass_id` IN ( 1 ) AND `ezcontentobject_tree`.`parent_node_id` IN ( 240 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder4 AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder5 AND ezcontentobject_version.status = :placeholder6 AND `ezcontentobject_tree`.`depth` <> :placeholder7 LIMIT 25;
|
| 20 |
0.83 ms |
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 29 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 242 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => 0
":placeholder3" => 1
":placeholder4" => 1
":placeholder5" => 0
]
SELECT
COUNT(*) count
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject_tree`.`is_invisible` = : placeholder2
AND `ezcontentobject`.`contentclass_id` IN (29)
AND (
`ezcontentobject`.`language_mask` & 7
) > 0
AND `ezcontentobject_tree`.`parent_node_id` IN (242)
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder3
AND ezcontentobject_version.status = : placeholder4
AND `ezcontentobject_tree`.`depth` <> : placeholder5
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 29 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 242 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5;
|
| 21 |
0.84 ms |
SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id`, `ezcontentobject_tree`.`priority` `sort_column_0` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 29 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 242 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5 ORDER BY `sort_column_0` ASC LIMIT 25
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => 0
":placeholder3" => 1
":placeholder4" => 1
":placeholder5" => 0
]
SELECT
ezcontentobject_tree.*,
`ezcontentobject`.`language_mask`,
`ezcontentobject`.`initial_language_id`,
`ezcontentobject_tree`.`priority` `sort_column_0`
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject_tree`.`is_invisible` = : placeholder2
AND `ezcontentobject`.`contentclass_id` IN (29)
AND (
`ezcontentobject`.`language_mask` & 7
) > 0
AND `ezcontentobject_tree`.`parent_node_id` IN (242)
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder3
AND ezcontentobject_version.status = : placeholder4
AND `ezcontentobject_tree`.`depth` <> : placeholder5
ORDER BY
`sort_column_0` ASC
LIMIT
25
SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id`, `ezcontentobject_tree`.`priority` `sort_column_0` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 29 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 242 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5 ORDER BY `sort_column_0` ASC LIMIT 25;
|
| 22 |
0.84 ms |
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 30 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 476 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => 0
":placeholder3" => 1
":placeholder4" => 1
":placeholder5" => 0
]
SELECT
COUNT(*) count
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject_tree`.`is_invisible` = : placeholder2
AND `ezcontentobject`.`contentclass_id` IN (30)
AND (
`ezcontentobject`.`language_mask` & 7
) > 0
AND `ezcontentobject_tree`.`parent_node_id` IN (476)
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder3
AND ezcontentobject_version.status = : placeholder4
AND `ezcontentobject_tree`.`depth` <> : placeholder5
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 30 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 476 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5;
|
| 23 |
0.82 ms |
SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id`, `ezcontentobject_tree`.`priority` `sort_column_0` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 30 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 476 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5 ORDER BY `sort_column_0` ASC LIMIT 25
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => 0
":placeholder3" => 1
":placeholder4" => 1
":placeholder5" => 0
]
SELECT
ezcontentobject_tree.*,
`ezcontentobject`.`language_mask`,
`ezcontentobject`.`initial_language_id`,
`ezcontentobject_tree`.`priority` `sort_column_0`
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject_tree`.`is_invisible` = : placeholder2
AND `ezcontentobject`.`contentclass_id` IN (30)
AND (
`ezcontentobject`.`language_mask` & 7
) > 0
AND `ezcontentobject_tree`.`parent_node_id` IN (476)
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder3
AND ezcontentobject_version.status = : placeholder4
AND `ezcontentobject_tree`.`depth` <> : placeholder5
ORDER BY
`sort_column_0` ASC
LIMIT
25
SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id`, `ezcontentobject_tree`.`priority` `sort_column_0` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 30 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 476 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5 ORDER BY `sort_column_0` ASC LIMIT 25;
|
| 24 |
0.91 ms |
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 30 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 4703 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => 0
":placeholder3" => 1
":placeholder4" => 1
":placeholder5" => 0
]
SELECT
COUNT(*) count
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject_tree`.`is_invisible` = : placeholder2
AND `ezcontentobject`.`contentclass_id` IN (30)
AND (
`ezcontentobject`.`language_mask` & 7
) > 0
AND `ezcontentobject_tree`.`parent_node_id` IN (4703)
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder3
AND ezcontentobject_version.status = : placeholder4
AND `ezcontentobject_tree`.`depth` <> : placeholder5
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 30 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 4703 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5;
|
| 25 |
0.91 ms |
SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id`, `ezcontentobject_tree`.`priority` `sort_column_0` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 30 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 4703 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5 ORDER BY `sort_column_0` ASC LIMIT 25
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => 0
":placeholder3" => 1
":placeholder4" => 1
":placeholder5" => 0
]
SELECT
ezcontentobject_tree.*,
`ezcontentobject`.`language_mask`,
`ezcontentobject`.`initial_language_id`,
`ezcontentobject_tree`.`priority` `sort_column_0`
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject_tree`.`is_invisible` = : placeholder2
AND `ezcontentobject`.`contentclass_id` IN (30)
AND (
`ezcontentobject`.`language_mask` & 7
) > 0
AND `ezcontentobject_tree`.`parent_node_id` IN (4703)
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder3
AND ezcontentobject_version.status = : placeholder4
AND `ezcontentobject_tree`.`depth` <> : placeholder5
ORDER BY
`sort_column_0` ASC
LIMIT
25
SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id`, `ezcontentobject_tree`.`priority` `sort_column_0` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 30 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 4703 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5 ORDER BY `sort_column_0` ASC LIMIT 25;
|
| 26 |
1.42 ms |
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 30 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 5250 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => 0
":placeholder3" => 1
":placeholder4" => 1
":placeholder5" => 0
]
SELECT
COUNT(*) count
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject_tree`.`is_invisible` = : placeholder2
AND `ezcontentobject`.`contentclass_id` IN (30)
AND (
`ezcontentobject`.`language_mask` & 7
) > 0
AND `ezcontentobject_tree`.`parent_node_id` IN (5250)
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder3
AND ezcontentobject_version.status = : placeholder4
AND `ezcontentobject_tree`.`depth` <> : placeholder5
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 30 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 5250 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5;
|
| 27 |
0.95 ms |
SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id`, `ezcontentobject_tree`.`priority` `sort_column_0` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 30 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 5250 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5 ORDER BY `sort_column_0` ASC LIMIT 25
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => 0
":placeholder3" => 1
":placeholder4" => 1
":placeholder5" => 0
]
SELECT
ezcontentobject_tree.*,
`ezcontentobject`.`language_mask`,
`ezcontentobject`.`initial_language_id`,
`ezcontentobject_tree`.`priority` `sort_column_0`
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject_tree`.`is_invisible` = : placeholder2
AND `ezcontentobject`.`contentclass_id` IN (30)
AND (
`ezcontentobject`.`language_mask` & 7
) > 0
AND `ezcontentobject_tree`.`parent_node_id` IN (5250)
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder3
AND ezcontentobject_version.status = : placeholder4
AND `ezcontentobject_tree`.`depth` <> : placeholder5
ORDER BY
`sort_column_0` ASC
LIMIT
25
SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id`, `ezcontentobject_tree`.`priority` `sort_column_0` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 30 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 5250 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5 ORDER BY `sort_column_0` ASC LIMIT 25;
|
| 28 |
0.94 ms |
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 30 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 5245 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => 0
":placeholder3" => 1
":placeholder4" => 1
":placeholder5" => 0
]
SELECT
COUNT(*) count
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject_tree`.`is_invisible` = : placeholder2
AND `ezcontentobject`.`contentclass_id` IN (30)
AND (
`ezcontentobject`.`language_mask` & 7
) > 0
AND `ezcontentobject_tree`.`parent_node_id` IN (5245)
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder3
AND ezcontentobject_version.status = : placeholder4
AND `ezcontentobject_tree`.`depth` <> : placeholder5
SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 30 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 5245 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5;
|
| 29 |
1.07 ms |
SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id`, `ezcontentobject_tree`.`priority` `sort_column_0` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 30 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 5245 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5 ORDER BY `sort_column_0` ASC LIMIT 25
Parameters: [▼
":placeholder1" => "1"
":placeholder2" => 0
":placeholder3" => 1
":placeholder4" => 1
":placeholder5" => 0
]
SELECT
ezcontentobject_tree.*,
`ezcontentobject`.`language_mask`,
`ezcontentobject`.`initial_language_id`,
`ezcontentobject_tree`.`priority` `sort_column_0`
FROM
`ezcontentobject_tree`
INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id
INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id
WHERE
(
: placeholder1
AND (
`ezcontentobject_tree`.`is_invisible` = : placeholder2
AND `ezcontentobject`.`contentclass_id` IN (30)
AND (
`ezcontentobject`.`language_mask` & 7
) > 0
AND `ezcontentobject_tree`.`parent_node_id` IN (5245)
AND `ezcontentobject`.`section_id` IN ('1', '3')
)
)
AND ezcontentobject.status = : placeholder3
AND ezcontentobject_version.status = : placeholder4
AND `ezcontentobject_tree`.`depth` <> : placeholder5
ORDER BY
`sort_column_0` ASC
LIMIT
25
SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id`, `ezcontentobject_tree`.`priority` `sort_column_0` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 30 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 5245 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5 ORDER BY `sort_column_0` ASC LIMIT 25;
|