http://verguenza.pre-originales.servidortemporal.net/capitulos/vergueenza-t2/ep-1-yusuf

Query Metrics

31 Database Queries
27 Different statements
11.87 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.99 ms
(16.80%)
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 ( 4232 ) 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.28 ms
(10.79%)
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 ( 4232 ) 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
]
0.90 ms
(7.60%)
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
]
0.88 ms
(7.38%)
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 ( 4233 ) 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
]
0.70 ms
(5.91%)
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 ( 4233 ) 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
]
0.69 ms
(5.85%)
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
]
0.60 ms
(5.02%)
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.35 ms
(2.96%)
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.35 ms
(2.95%)
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.34 ms
(2.90%)
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
]
0.31 ms
(2.62%)
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.29 ms
(2.41%)
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.26 ms
(2.20%)
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
]
0.25 ms
(2.14%)
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.25 ms
(2.11%)
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.25 ms
(2.11%)
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
]
0.24 ms
(2.01%)
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.22 ms
(1.88%)
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.20 ms
(1.69%)
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.20 ms
(1.67%)
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.20 ms
(1.67%)
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.20 ms
(1.66%)
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
]
0.20 ms
(1.64%)
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.19 ms
(1.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 ( 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.18 ms
(1.54%)
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.17 ms
(1.43%)
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
]
0.17 ms
(1.42%)
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
]

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.