GET https://site.v5.nexus.alpha.se7enx.com/tags/view/Topics/HIIT

Query Metrics

53 Database Queries
18 Different statements
6.07 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 0.70 ms
SELECT ibexa_url_alias_ml0.id AS ibexa_url_alias_ml0_id, ibexa_url_alias_ml0.link AS ibexa_url_alias_ml0_link, ibexa_url_alias_ml0.is_alias AS ibexa_url_alias_ml0_is_alias, ibexa_url_alias_ml0.alias_redirects AS ibexa_url_alias_ml0_alias_redirects, ibexa_url_alias_ml0.is_original AS ibexa_url_alias_ml0_is_original, ibexa_url_alias_ml0.action AS ibexa_url_alias_ml0_action, ibexa_url_alias_ml0.action_type AS ibexa_url_alias_ml0_action_type, ibexa_url_alias_ml0.lang_mask AS ibexa_url_alias_ml0_lang_mask, ibexa_url_alias_ml0.text AS ibexa_url_alias_ml0_text, ibexa_url_alias_ml0.parent AS ibexa_url_alias_ml0_parent, ibexa_url_alias_ml0.text_md5 AS ibexa_url_alias_ml0_text_md5, ibexa_url_alias_ml1.id AS ibexa_url_alias_ml1_id, ibexa_url_alias_ml1.link AS ibexa_url_alias_ml1_link, ibexa_url_alias_ml1.is_alias AS ibexa_url_alias_ml1_is_alias, ibexa_url_alias_ml1.alias_redirects AS ibexa_url_alias_ml1_alias_redirects, ibexa_url_alias_ml1.is_original AS ibexa_url_alias_ml1_is_original, ibexa_url_alias_ml1.action AS ibexa_url_alias_ml1_action, ibexa_url_alias_ml1.action_type AS ibexa_url_alias_ml1_action_type, ibexa_url_alias_ml1.lang_mask AS ibexa_url_alias_ml1_lang_mask, ibexa_url_alias_ml1.text AS ibexa_url_alias_ml1_text, ibexa_url_alias_ml1.parent AS ibexa_url_alias_ml1_parent, ibexa_url_alias_ml1.text_md5 AS ibexa_url_alias_ml1_text_md5, ibexa_url_alias_ml2.id AS ibexa_url_alias_ml2_id, ibexa_url_alias_ml2.link AS ibexa_url_alias_ml2_link, ibexa_url_alias_ml2.is_alias AS ibexa_url_alias_ml2_is_alias, ibexa_url_alias_ml2.alias_redirects AS ibexa_url_alias_ml2_alias_redirects, ibexa_url_alias_ml2.is_original AS ibexa_url_alias_ml2_is_original, ibexa_url_alias_ml2.action AS ibexa_url_alias_ml2_action, ibexa_url_alias_ml2.action_type AS ibexa_url_alias_ml2_action_type, ibexa_url_alias_ml2.lang_mask AS ibexa_url_alias_ml2_lang_mask, ibexa_url_alias_ml2.text AS ibexa_url_alias_ml2_text, ibexa_url_alias_ml2.parent AS ibexa_url_alias_ml2_parent, ibexa_url_alias_ml2.text_md5 AS ibexa_url_alias_ml2_text_md5, ibexa_url_alias_ml3.id AS ibexa_url_alias_ml3_id, ibexa_url_alias_ml3.link AS ibexa_url_alias_ml3_link, ibexa_url_alias_ml3.is_alias AS ibexa_url_alias_ml3_is_alias, ibexa_url_alias_ml3.alias_redirects AS ibexa_url_alias_ml3_alias_redirects, ibexa_url_alias_ml3.is_original AS ibexa_url_alias_ml3_is_original, ibexa_url_alias_ml3.action AS ibexa_url_alias_ml3_action, ibexa_url_alias_ml3.action_type AS ibexa_url_alias_ml3_action_type, ibexa_url_alias_ml3.lang_mask AS ibexa_url_alias_ml3_lang_mask, ibexa_url_alias_ml3.text AS ibexa_url_alias_ml3_text, ibexa_url_alias_ml3.parent AS ibexa_url_alias_ml3_parent, ibexa_url_alias_ml3.text_md5 AS ibexa_url_alias_ml3_text_md5, u.id AS id, u.link AS link, u.is_alias AS is_alias, u.alias_redirects AS alias_redirects, u.is_original AS is_original, u.action AS action, u.action_type AS action_type, u.lang_mask AS lang_mask, u.text AS text, u.parent AS parent, u.text_md5 AS text_md5 FROM "ibexa_url_alias_ml" ibexa_url_alias_ml0, "ibexa_url_alias_ml" ibexa_url_alias_ml1, "ibexa_url_alias_ml" ibexa_url_alias_ml2, "ibexa_url_alias_ml" ibexa_url_alias_ml3, "ibexa_url_alias_ml" u WHERE (ibexa_url_alias_ml0.text_md5 = ?) AND (ibexa_url_alias_ml0.parent = ?) AND (ibexa_url_alias_ml1.text_md5 = ?) AND (ibexa_url_alias_ml1.parent = ibexa_url_alias_ml0.link) AND (ibexa_url_alias_ml2.text_md5 = ?) AND (ibexa_url_alias_ml2.parent = ibexa_url_alias_ml1.link) AND (ibexa_url_alias_ml3.text_md5 = ?) AND (ibexa_url_alias_ml3.parent = ibexa_url_alias_ml2.link) AND (u.text_md5 = ?) AND (u.parent = ibexa_url_alias_ml3.link) LIMIT 1
Parameters:
[
  "3198800cd0599581af4bdada7aabe886"
  0
  "d57ac45256849d9b13e2422d91580fb9"
  "1bda80f2be4d3658e0baa43fbe7ae8c1"
  "e329b27943961ccab9dc7a8ac2edb666"
  "71730a64b90f819bf786cbdf0b2817f3"
]
2 0.10 ms
SELECT eztags.id, eztags.parent_id, eztags.main_tag_id, eztags.depth, eztags.path_string, eztags.modified, eztags.remote_id, eztags.main_language_id, eztags.language_mask, eztags_keyword.keyword, eztags_keyword.locale FROM eztags LEFT JOIN eztags_keyword eztags_keyword ON (eztags_keyword.keyword_id = eztags.id) AND (eztags_keyword.status = ?) WHERE ((eztags_keyword.locale IN (?)) OR (((eztags.language_mask & 1) > 0) AND (eztags.main_language_id = (eztags_keyword.language_id & -2)))) AND (eztags_keyword.keyword = ?) AND (eztags.parent_id = ?)
Parameters:
[
  1
  "eng-GB"
  "Topics"
  0
]
3 0.11 ms
SELECT eztags.id, eztags.parent_id, eztags.main_tag_id, eztags.depth, eztags.path_string, eztags.modified, eztags.remote_id, eztags.main_language_id, eztags.language_mask, eztags_keyword.keyword, eztags_keyword.locale FROM eztags LEFT JOIN eztags_keyword eztags_keyword ON (eztags_keyword.keyword_id = eztags.id) AND (eztags_keyword.status = ?) WHERE ((eztags_keyword.locale IN (?)) OR (((eztags.language_mask & 1) > 0) AND (eztags.main_language_id = (eztags_keyword.language_id & -2)))) AND (eztags_keyword.keyword = ?) AND (eztags.parent_id = ?)
Parameters:
[
  1
  "eng-GB"
  "HIIT"
  7
]
4 0.11 ms
SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = ?) AND (rg.status = ?)
Parameters:
[
  "00000000-0000-0000-0000-000000000000"
  1
]
5 0.06 ms
SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = ?) AND (rg.status = ?)
Parameters:
[
  "00000000-0000-0000-0000-000000000000"
  1
]
6 0.05 ms
SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (parent_id = ?) AND (rg.status = ?) ORDER BY rgd.priority DESC
Parameters:
[
  1
  1
]
7 0.04 ms
SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = ?) AND (rg.status = ?)
Parameters:
[
  "00000000-0000-0000-0000-000000000000"
  1
]
8 0.06 ms
SELECT DISTINCT r.*, rd.*, l.uuid AS layout_uuid FROM nglayouts_rule r INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid) AND (l.status = ?) INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id) AND (r.status = rt.status) WHERE (r.rule_group_id = ?) AND (rd.enabled = ?) AND (rt.type = ?) AND (r.status = ?) AND (rt.value = ?) ORDER BY rd.priority DESC
Parameters:
[
  1
  1
  1
  "ibexa_semantic_path_info"
  1
  "/tags/view/Topics/HIIT"
]
9 0.04 ms
SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = ?) AND (rg.status = ?)
Parameters:
[
  "00000000-0000-0000-0000-000000000000"
  1
]
10 0.05 ms
SELECT DISTINCT r.*, rd.*, l.uuid AS layout_uuid FROM nglayouts_rule r INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid) AND (l.status = ?) INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id) AND (r.status = rt.status) WHERE (r.rule_group_id = ?) AND (rd.enabled = ?) AND (rt.type = ?) AND (r.status = ?) AND ((LENGTH(TRIM(rt.value)) > ?) AND (? LIKE TRIM(rt.value) || '%')) ORDER BY rd.priority DESC
Parameters:
[
  1
  1
  1
  "ibexa_semantic_path_info_prefix"
  1
  0
  "/tags/view/Topics/HIIT"
]
11 0.03 ms
SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = ?) AND (rg.status = ?)
Parameters:
[
  "00000000-0000-0000-0000-000000000000"
  1
]
12 0.05 ms
SELECT DISTINCT r.*, rd.*, l.uuid AS layout_uuid FROM nglayouts_rule r INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid) AND (l.status = ?) INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id) AND (r.status = rt.status) WHERE (r.rule_group_id = ?) AND (rd.enabled = ?) AND (rt.type = ?) AND (r.status = ?) AND (rt.value = ?) ORDER BY rd.priority DESC
Parameters:
[
  1
  1
  1
  "request_uri"
  1
  "/tags/view/Topics/HIIT"
]
13 0.04 ms
SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = ?) AND (rg.status = ?)
Parameters:
[
  "00000000-0000-0000-0000-000000000000"
  1
]
14 0.05 ms
SELECT DISTINCT r.*, rd.*, l.uuid AS layout_uuid FROM nglayouts_rule r INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid) AND (l.status = ?) INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id) AND (r.status = rt.status) WHERE (r.rule_group_id = ?) AND (rd.enabled = ?) AND (rt.type = ?) AND (r.status = ?) AND ((LENGTH(TRIM(rt.value)) > ?) AND (? LIKE TRIM(rt.value) || '%')) ORDER BY rd.priority DESC
Parameters:
[
  1
  1
  1
  "request_uri_prefix"
  1
  0
  "/tags/view/Topics/HIIT"
]
15 0.03 ms
SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = ?) AND (rg.status = ?)
Parameters:
[
  "00000000-0000-0000-0000-000000000000"
  1
]
16 0.05 ms
SELECT DISTINCT r.*, rd.*, l.uuid AS layout_uuid FROM nglayouts_rule r INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid) AND (l.status = ?) INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id) AND (r.status = rt.status) WHERE (r.rule_group_id = ?) AND (rd.enabled = ?) AND (rt.type = ?) AND (r.status = ?) AND (rt.value = ?) ORDER BY rd.priority DESC
Parameters:
[
  1
  1
  1
  "path_info"
  1
  "/tags/view/Topics/HIIT"
]
17 0.03 ms
SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = ?) AND (rg.status = ?)
Parameters:
[
  "00000000-0000-0000-0000-000000000000"
  1
]
18 0.07 ms
SELECT DISTINCT r.*, rd.*, l.uuid AS layout_uuid FROM nglayouts_rule r INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid) AND (l.status = ?) INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id) AND (r.status = rt.status) WHERE (r.rule_group_id = ?) AND (rd.enabled = ?) AND (rt.type = ?) AND (r.status = ?) AND ((LENGTH(TRIM(rt.value)) > ?) AND (? LIKE TRIM(rt.value) || '%')) ORDER BY rd.priority DESC
Parameters:
[
  1
  1
  1
  "path_info_prefix"
  1
  0
  "/tags/view/Topics/HIIT"
]
19 0.06 ms
SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.id = ?) AND (rg.status = ?)
Parameters:
[
  1
  1
]
20 0.07 ms
SELECT DISTINCT c.*, cr.rule_id, r.uuid AS rule_uuid FROM nglayouts_rule_condition c INNER JOIN nglayouts_rule_condition_rule cr ON (cr.condition_id = c.id) AND (cr.condition_status = c.status) INNER JOIN nglayouts_rule r ON (r.id = cr.rule_id) AND (r.status = cr.rule_status) WHERE (cr.rule_id = ?) AND (c.status = ?) ORDER BY c.id ASC
Parameters:
[
  27
  1
]
21 0.05 ms
SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = ?) AND (rg.status = ?)
Parameters:
[
  "00000000-0000-0000-0000-000000000000"
  1
]
22 0.06 ms
SELECT DISTINCT r.*, rd.*, l.uuid AS layout_uuid FROM nglayouts_rule r INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid) AND (l.status = ?) INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id) AND (r.status = rt.status) WHERE (r.rule_group_id = ?) AND (rd.enabled = ?) AND (rt.type = ?) AND (r.status = ?) AND (rt.value = ?) ORDER BY rd.priority DESC
Parameters:
[
  1
  1
  1
  "route"
  1
  "netgen_tags.tag.url"
]
23 0.03 ms
SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = ?) AND (rg.status = ?)
Parameters:
[
  "00000000-0000-0000-0000-000000000000"
  1
]
24 0.05 ms
SELECT DISTINCT r.*, rd.*, l.uuid AS layout_uuid FROM nglayouts_rule r INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid) AND (l.status = ?) INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id) AND (r.status = rt.status) WHERE (r.rule_group_id = ?) AND (rd.enabled = ?) AND (rt.type = ?) AND (r.status = ?) AND ((LENGTH(TRIM(rt.value)) > ?) AND (? LIKE TRIM(rt.value) || '%')) ORDER BY rd.priority DESC
Parameters:
[
  1
  1
  1
  "route_prefix"
  1
  0
  "netgen_tags.tag.url"
]
25 0.08 ms
SELECT DISTINCT l.*, lt.* FROM nglayouts_layout l INNER JOIN nglayouts_layout_translation lt ON (lt.layout_id = l.id) AND (lt.status = l.status) WHERE (l.uuid = ?) AND (l.status = ?)
Parameters:
[
  "1d969451-6743-5ac1-85b8-6cc0f9ef7084"
  1
]
26 0.14 ms
SELECT DISTINCT z.*, l.uuid as layout_uuid FROM nglayouts_zone z INNER JOIN nglayouts_layout l ON (l.id = z.layout_id) AND (l.status = z.status) WHERE (z.layout_id = ?) AND (z.status = ?) ORDER BY z.identifier ASC
Parameters:
[
  19
  1
]
27 0.07 ms
SELECT DISTINCT z.*, l.uuid as layout_uuid FROM nglayouts_zone z INNER JOIN nglayouts_layout l ON (l.id = z.layout_id) AND (l.status = z.status) WHERE (z.identifier = ?) AND (l.uuid = ?) AND (l.status = ?)
Parameters:
[
  "header"
  "fd0aa7af-77a8-5a03-bf10-80018f5db1dc"
  1
]
28 0.06 ms
SELECT DISTINCT z.*, l.uuid as layout_uuid FROM nglayouts_zone z INNER JOIN nglayouts_layout l ON (l.id = z.layout_id) AND (l.status = z.status) WHERE (z.identifier = ?) AND (l.uuid = ?) AND (l.status = ?)
Parameters:
[
  "header"
  "fd0aa7af-77a8-5a03-bf10-80018f5db1dc"
  1
]
29 0.08 ms
SELECT DISTINCT b.*, bt.*, l.uuid as layout_uuid FROM nglayouts_block b INNER JOIN nglayouts_block_translation bt ON (bt.block_id = b.id) AND (bt.status = b.status) INNER JOIN nglayouts_layout l ON (l.id = b.layout_id) AND (l.status = b.status) WHERE (b.id = ?) AND (b.status = ?)
Parameters:
[
  8
  1
]
30 0.34 ms
SELECT DISTINCT b.*, bt.*, l.uuid as layout_uuid FROM nglayouts_block b INNER JOIN nglayouts_block_translation bt ON (bt.block_id = b.id) AND (bt.status = b.status) INNER JOIN nglayouts_layout l ON (l.id = b.layout_id) AND (l.status = b.status) WHERE (b.parent_id = ?) AND (b.status = ?) ORDER BY b.placeholder ASC, b.position ASC
Parameters:
[
  8
  1
]
31 0.12 ms
SELECT DISTINCT c.*, ct.*, bc.* FROM nglayouts_collection c INNER JOIN nglayouts_collection_translation ct ON (ct.collection_id = c.id) AND (ct.status = c.status) INNER JOIN nglayouts_block_collection bc ON (c.id = bc.collection_id) AND (c.status = bc.collection_status) WHERE (bc.block_id = ?) AND (bc.block_status = ?) ORDER BY bc.identifier ASC
Parameters:
[
  13
  1
]
32 0.11 ms
SELECT DISTINCT c.*, ct.*, bc.* FROM nglayouts_collection c INNER JOIN nglayouts_collection_translation ct ON (ct.collection_id = c.id) AND (ct.status = c.status) INNER JOIN nglayouts_block_collection bc ON (c.id = bc.collection_id) AND (c.status = bc.collection_status) WHERE (bc.block_id = ?) AND (bc.block_status = ?) ORDER BY bc.identifier ASC
Parameters:
[
  475
  1
]
33 0.39 ms
SELECT DISTINCT b.*, bt.*, l.uuid as layout_uuid FROM nglayouts_block b INNER JOIN nglayouts_block_translation bt ON (bt.block_id = b.id) AND (bt.status = b.status) INNER JOIN nglayouts_layout l ON (l.id = b.layout_id) AND (l.status = b.status) WHERE (b.parent_id = ?) AND (b.placeholder = ?) AND (b.status = ?) ORDER BY b.placeholder ASC, b.position ASC
Parameters:
[
  475
  "main"
  1
]
34 0.08 ms
SELECT DISTINCT c.*, ct.*, bc.* FROM nglayouts_collection c INNER JOIN nglayouts_collection_translation ct ON (ct.collection_id = c.id) AND (ct.status = c.status) INNER JOIN nglayouts_block_collection bc ON (c.id = bc.collection_id) AND (c.status = bc.collection_status) WHERE (bc.block_id = ?) AND (bc.block_status = ?) ORDER BY bc.identifier ASC
Parameters:
[
  477
  1
]
35 0.12 ms
SELECT DISTINCT z.*, l.uuid as layout_uuid FROM nglayouts_zone z INNER JOIN nglayouts_layout l ON (l.id = z.layout_id) AND (l.status = z.status) WHERE (z.identifier = ?) AND (l.uuid = ?) AND (l.status = ?)
Parameters:
[
  "post_header"
  "1d969451-6743-5ac1-85b8-6cc0f9ef7084"
  1
]
36 0.05 ms
SELECT DISTINCT b.*, bt.*, l.uuid as layout_uuid FROM nglayouts_block b INNER JOIN nglayouts_block_translation bt ON (bt.block_id = b.id) AND (bt.status = b.status) INNER JOIN nglayouts_layout l ON (l.id = b.layout_id) AND (l.status = b.status) WHERE (b.id = ?) AND (b.status = ?)
Parameters:
[
  283
  1
]
37 0.31 ms
SELECT DISTINCT b.*, bt.*, l.uuid as layout_uuid FROM nglayouts_block b INNER JOIN nglayouts_block_translation bt ON (bt.block_id = b.id) AND (bt.status = b.status) INNER JOIN nglayouts_layout l ON (l.id = b.layout_id) AND (l.status = b.status) WHERE (b.parent_id = ?) AND (b.status = ?) ORDER BY b.placeholder ASC, b.position ASC
Parameters:
[
  283
  1
]
38 0.07 ms
SELECT DISTINCT z.*, l.uuid as layout_uuid FROM nglayouts_zone z INNER JOIN nglayouts_layout l ON (l.id = z.layout_id) AND (l.status = z.status) WHERE (z.identifier = ?) AND (l.uuid = ?) AND (l.status = ?)
Parameters:
[
  "main"
  "1d969451-6743-5ac1-85b8-6cc0f9ef7084"
  1
]
39 0.06 ms
SELECT DISTINCT b.*, bt.*, l.uuid as layout_uuid FROM nglayouts_block b INNER JOIN nglayouts_block_translation bt ON (bt.block_id = b.id) AND (bt.status = b.status) INNER JOIN nglayouts_layout l ON (l.id = b.layout_id) AND (l.status = b.status) WHERE (b.id = ?) AND (b.status = ?)
Parameters:
[
  284
  1
]
40 0.28 ms
SELECT DISTINCT b.*, bt.*, l.uuid as layout_uuid FROM nglayouts_block b INNER JOIN nglayouts_block_translation bt ON (bt.block_id = b.id) AND (bt.status = b.status) INNER JOIN nglayouts_layout l ON (l.id = b.layout_id) AND (l.status = b.status) WHERE (b.parent_id = ?) AND (b.status = ?) ORDER BY b.placeholder ASC, b.position ASC
Parameters:
[
  284
  1
]
41 0.06 ms
SELECT DISTINCT c.*, ct.*, bc.* FROM nglayouts_collection c INNER JOIN nglayouts_collection_translation ct ON (ct.collection_id = c.id) AND (ct.status = c.status) INNER JOIN nglayouts_block_collection bc ON (c.id = bc.collection_id) AND (c.status = bc.collection_status) WHERE (bc.block_id = ?) AND (bc.block_status = ?) ORDER BY bc.identifier ASC
Parameters:
[
  288
  1
]
42 0.18 ms
SELECT COUNT( DISTINCT c.id ) FROM ibexa_content c INNER JOIN ibexa_content_version v ON c.id = v.contentobject_id WHERE (((1 = 1) AND ((c.id IN (SELECT t1.id FROM ibexa_content t1 INNER JOIN eztags_attribute_link t2 ON (t2.objectattribute_version = t1.current_version) AND (t2.object_id = t1.id) WHERE t2.keyword_id IN (?))) AND ((c.section_id IN (?)) OR ((c.content_type_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (c.section_id IN (?)))))) AND (c.status = 1) AND (v.status = 1)) AND ((c.language_mask & ?) > ?)
Parameters:
[
  23
  1
  "100"
  "103"
  "104"
  "105"
  "106"
  "107"
  "108"
  "111"
  "113"
  "118"
  "119"
  "120"
  "37"
  "41"
  "42"
  "49"
  "50"
  "51"
  "80"
  "81"
  "95"
  "97"
  3
  3
  0
]
43 0.13 ms
SELECT COUNT( DISTINCT c.id ) FROM ibexa_content c INNER JOIN ibexa_content_version v ON c.id = v.contentobject_id WHERE (((1 = 1) AND ((c.id IN (SELECT t1.id FROM ibexa_content t1 INNER JOIN eztags_attribute_link t2 ON (t2.objectattribute_version = t1.current_version) AND (t2.object_id = t1.id) WHERE t2.keyword_id IN (?))) AND ((c.section_id IN (?)) OR ((c.content_type_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (c.section_id IN (?)))))) AND (c.status = 1) AND (v.status = 1)) AND ((c.language_mask & ?) > ?)
Parameters:
[
  23
  1
  "100"
  "103"
  "104"
  "105"
  "106"
  "107"
  "108"
  "111"
  "113"
  "118"
  "119"
  "120"
  "37"
  "41"
  "42"
  "49"
  "50"
  "51"
  "80"
  "81"
  "95"
  "97"
  3
  3
  0
]
44 0.17 ms
SELECT DISTINCT c.*, main_tree.main_node_id AS main_tree_main_node_id, c.modified AS "sort_column_0" FROM ibexa_content c INNER JOIN ibexa_content_version v ON c.id = v.contentobject_id LEFT JOIN ibexa_content_tree main_tree ON (main_tree.contentobject_id = c.id) AND (main_tree.main_node_id = main_tree.node_id) WHERE (((1 = 1) AND ((c.id IN (SELECT t1.id FROM ibexa_content t1 INNER JOIN eztags_attribute_link t2 ON (t2.objectattribute_version = t1.current_version) AND (t2.object_id = t1.id) WHERE t2.keyword_id IN (?))) AND ((c.section_id IN (?)) OR ((c.content_type_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (c.section_id IN (?)))))) AND (c.status = 1) AND (v.status = 1)) AND ((c.language_mask & ?) > ?) ORDER BY "sort_column_0" DESC LIMIT 6
Parameters:
[
  23
  1
  "100"
  "103"
  "104"
  "105"
  "106"
  "107"
  "108"
  "111"
  "113"
  "118"
  "119"
  "120"
  "37"
  "41"
  "42"
  "49"
  "50"
  "51"
  "80"
  "81"
  "95"
  "97"
  3
  3
  0
]
45 0.16 ms
SELECT t.*, c.language_mask, c.initial_language_id, c.published AS "sort_column_0" FROM ibexa_content_tree t INNER JOIN ibexa_content c ON t.contentobject_id = c.id INNER JOIN ibexa_content_version v ON c.id = v.contentobject_id WHERE ((1 = 1) AND ((t.parent_node_id IN (?)) AND ((t.is_hidden = ?) AND (t.is_invisible = ?) AND (c.is_hidden = ?)) AND (c.content_type_id IN (?)) AND ((c.section_id IN (?)) OR ((c.content_type_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (c.section_id IN (?)))))) AND (c.status = ?) AND (v.status = ?) AND (t.depth <> ?) AND ((c.language_mask & ?) > ?) ORDER BY "sort_column_0" DESC LIMIT 1
Parameters:
[
  365
  0
  0
  0
  81
  1
  "100"
  "103"
  "104"
  "105"
  "106"
  "107"
  "108"
  "111"
  "113"
  "118"
  "119"
  "120"
  "37"
  "41"
  "42"
  "49"
  "50"
  "51"
  "80"
  "81"
  "95"
  "97"
  3
  1
  1
  0
  3
  0
]
46 0.12 ms
SELECT DISTINCT z.*, l.uuid as layout_uuid FROM nglayouts_zone z INNER JOIN nglayouts_layout l ON (l.id = z.layout_id) AND (l.status = z.status) WHERE (z.identifier = ?) AND (l.uuid = ?) AND (l.status = ?)
Parameters:
[
  "pre_footer"
  "1d969451-6743-5ac1-85b8-6cc0f9ef7084"
  1
]
47 0.08 ms
SELECT DISTINCT b.*, bt.*, l.uuid as layout_uuid FROM nglayouts_block b INNER JOIN nglayouts_block_translation bt ON (bt.block_id = b.id) AND (bt.status = b.status) INNER JOIN nglayouts_layout l ON (l.id = b.layout_id) AND (l.status = b.status) WHERE (b.id = ?) AND (b.status = ?)
Parameters:
[
  285
  1
]
48 0.32 ms
SELECT DISTINCT b.*, bt.*, l.uuid as layout_uuid FROM nglayouts_block b INNER JOIN nglayouts_block_translation bt ON (bt.block_id = b.id) AND (bt.status = b.status) INNER JOIN nglayouts_layout l ON (l.id = b.layout_id) AND (l.status = b.status) WHERE (b.parent_id = ?) AND (b.status = ?) ORDER BY b.placeholder ASC, b.position ASC
Parameters:
[
  285
  1
]
49 0.06 ms
SELECT DISTINCT z.*, l.uuid as layout_uuid FROM nglayouts_zone z INNER JOIN nglayouts_layout l ON (l.id = z.layout_id) AND (l.status = z.status) WHERE (z.identifier = ?) AND (l.uuid = ?) AND (l.status = ?)
Parameters:
[
  "footer"
  "fd0aa7af-77a8-5a03-bf10-80018f5db1dc"
  1
]
50 0.06 ms
SELECT DISTINCT z.*, l.uuid as layout_uuid FROM nglayouts_zone z INNER JOIN nglayouts_layout l ON (l.id = z.layout_id) AND (l.status = z.status) WHERE (z.identifier = ?) AND (l.uuid = ?) AND (l.status = ?)
Parameters:
[
  "footer"
  "fd0aa7af-77a8-5a03-bf10-80018f5db1dc"
  1
]
51 0.05 ms
SELECT DISTINCT b.*, bt.*, l.uuid as layout_uuid FROM nglayouts_block b INNER JOIN nglayouts_block_translation bt ON (bt.block_id = b.id) AND (bt.status = b.status) INNER JOIN nglayouts_layout l ON (l.id = b.layout_id) AND (l.status = b.status) WHERE (b.id = ?) AND (b.status = ?)
Parameters:
[
  12
  1
]
52 0.27 ms
SELECT DISTINCT b.*, bt.*, l.uuid as layout_uuid FROM nglayouts_block b INNER JOIN nglayouts_block_translation bt ON (bt.block_id = b.id) AND (bt.status = b.status) INNER JOIN nglayouts_layout l ON (l.id = b.layout_id) AND (l.status = b.status) WHERE (b.parent_id = ?) AND (b.status = ?) ORDER BY b.placeholder ASC, b.position ASC
Parameters:
[
  12
  1
]
53 0.07 ms
SELECT DISTINCT c.*, ct.*, bc.* FROM nglayouts_collection c INNER JOIN nglayouts_collection_translation ct ON (ct.collection_id = c.id) AND (ct.status = c.status) INNER JOIN nglayouts_block_collection bc ON (c.id = bc.collection_id) AND (c.status = bc.collection_status) WHERE (bc.block_id = ?) AND (bc.block_status = ?) ORDER BY bc.identifier ASC
Parameters:
[
  14
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
ibexa_default doctrine.orm.ibexa_default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects

ibexa_default entity manager

Class Amount of managed objects

Entities Mapping

default entity manager

No loaded entities.

ibexa_default entity manager

No loaded entities.