Query Metrics
31
Database Queries
27
Different statements
30.59 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.88 ms (9.42%) |
2 |
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 ( 4198 ) 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 ] |
1.91 ms (6.23%) |
2 |
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 ( 4198 ) 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 ] |
1.79 ms (5.85%) |
2 |
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 ( 4199 ) 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 ] |
1.73 ms (5.65%) |
2 |
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 ( 4199 ) 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 ] |
1.28 ms (4.17%) |
1 |
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 ( 658 ) 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 ] |
1.23 ms (4.02%) |
1 |
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 ( 658 ) 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 ] |
1.15 ms (3.77%) |
1 |
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 ] |
1.12 ms (3.65%) |
1 |
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 ( 4165 ) 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 ] |
1.11 ms (3.64%) |
1 |
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 ] |
1.07 ms (3.51%) |
1 |
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 ] |
1.01 ms (3.29%) |
1 |
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 ( 658 ) 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 ] |
0.99 ms (3.25%) |
1 |
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 ] |
0.98 ms (3.19%) |
1 |
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 ] |
0.94 ms (3.07%) |
1 |
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 ] |
0.91 ms (2.98%) |
1 |
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 ( 1232 ) 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 ] |
0.91 ms (2.98%) |
1 |
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 ( 1232 ) 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 ] |
0.90 ms (2.96%) |
1 |
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 ] |
0.90 ms (2.94%) |
1 |
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 ] |
0.90 ms (2.93%) |
1 |
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 ( 1245 ) 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 ] |
0.89 ms (2.92%) |
1 |
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 ] |
0.87 ms (2.86%) |
1 |
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 ( 4165 ) 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 ] |
0.87 ms (2.86%) |
1 |
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 ( 1192 ) 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 ] |
0.87 ms (2.84%) |
1 |
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 ( 3679 ) 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 ] |
0.85 ms (2.79%) |
1 |
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 ] |
0.84 ms (2.76%) |
1 |
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 ] |
0.84 ms (2.75%) |
1 |
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 ( 8051 ) 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 ] |
0.83 ms (2.71%) |
1 |
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 ] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
No loaded entities.