Query Metrics

73 Database Queries
20 Different statements
10.92 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 0.53 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
]
2 0.10 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
]
3 0.12 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
]
4 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
]
5 0.12 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_location"
  1
  275
]
6 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
]
7 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_content"
  1
  288
]
8 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
]
9 0.13 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 IN (?, ?, ?, ?, ?)) ORDER BY rd.priority DESC
Parameters:
[
  1
  1
  1
  "ibexa_subtree"
  1
  1
  2
  385
  167
  275
]
10 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.id = ?) AND (rg.status = ?)
Parameters:
[
  1
  1
]
11 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.id = ?) AND (rg.status = ?)
Parameters:
[
  1
  1
]
12 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
]
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.id = ?) AND (rg.status = ?)
Parameters:
[
  1
  1
]
14 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:
[
  21
  1
]
15 0.06 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:
[
  23
  1
]
16 0.05 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:
[
  24
  1
]
17 0.06 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:
[
  25
  1
]
18 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
]
19 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_children"
  1
  167
]
20 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
]
21 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
  "/fitness/effective-training-techniques-high-intensity-interval-training-hiit"
]
22 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
]
23 0.09 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
  "/fitness/effective-training-techniques-high-intensity-interval-training-hiit"
]
24 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
]
25 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
  "request_uri"
  1
  "/fitness/effective-training-techniques-high-intensity-interval-training-hiit"
]
26 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
]
27 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
  "request_uri_prefix"
  1
  0
  "/fitness/effective-training-techniques-high-intensity-interval-training-hiit"
]
28 0.14 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
]
29 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
  "path_info"
  1
  "/fitness/effective-training-techniques-high-intensity-interval-training-hiit"
]
30 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
]
31 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
  "/fitness/effective-training-techniques-high-intensity-interval-training-hiit"
]
32 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
]
33 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
]
34 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
]
35 0.08 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
  "ibexa.url.alias"
]
36 0.10 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
]
37 0.10 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
  "ibexa.url.alias"
]
38 0.07 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:
[
  "84f28edc-38d2-524d-a1e1-d720de5942ba"
  1
]
39 0.17 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:
[
  21
  1
]
40 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
]
41 0.05 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
]
42 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
]
43 0.42 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
]
44 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
]
45 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
]
46 0.35 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
]
47 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:
[
  477
  1
]
48 0.09 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"
  "84f28edc-38d2-524d-a1e1-d720de5942ba"
  1
]
49 0.04 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:
[
  296
  1
]
50 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:
[
  296
  1
]
51 0.09 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"
  "84f28edc-38d2-524d-a1e1-d720de5942ba"
  1
]
52 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:
[
  297
  1
]
53 0.24 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:
[
  297
  1
]
54 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:
[
  300
  1
]
55 2.34 ms
SELECT COUNT(t.node_id) 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.path_string LIKE ?) AND (NOT (t.node_id IN (?))) AND (t.node_id = t.main_node_id) AND (t.is_invisible = ?) AND (c.content_type_id IN (?)) 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 = ?) AND (v.status = ?) AND (t.depth <> ?) AND ((c.language_mask & ?) > ?)
Parameters:
[
  "/1/2/385/%"
  385
  0
  102
  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
  1
  1
  0
  3
  0
]
56 0.28 ms
SELECT t.*, c.language_mask, c.initial_language_id 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.path_string LIKE ?) AND (NOT (t.node_id IN (?))) AND (t.node_id = t.main_node_id) AND (t.is_invisible = ?) AND (c.content_type_id IN (?)) 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 = ?) AND (v.status = ?) AND (t.depth <> ?) AND ((c.language_mask & ?) > ?) LIMIT 1
Parameters:
[
  "/1/2/385/%"
  385
  0
  102
  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
  1
  1
  0
  3
  0
]
57 0.42 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 25
Parameters:
[
  275
  0
  0
  0
  81
  97
  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
]
58 0.24 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"
  "d14c8271-5a0c-5f1d-a1e6-df4d0b77e638"
  1
]
59 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:
[
  "main"
  "d14c8271-5a0c-5f1d-a1e6-df4d0b77e638"
  1
]
60 0.10 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:
[
  78
  1
]
61 0.30 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:
[
  78
  1
]
62 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:
[
  79
  1
]
63 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.placeholder = ?) AND (b.status = ?) ORDER BY b.placeholder ASC, b.position ASC
Parameters:
[
  79
  "main"
  1
]
64 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:
[
  80
  1
]
65 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:
[
  81
  1
]
66 0.12 ms
SELECT DISTINCT q.*, qt.*, c.uuid as collection_uuid FROM nglayouts_collection_query q INNER JOIN nglayouts_collection_query_translation qt ON (qt.query_id = q.id) AND (qt.status = q.status) INNER JOIN nglayouts_collection c ON (c.id = q.collection_id) AND (c.status = q.status) WHERE (q.collection_id = ?) AND (q.status = ?)
Parameters:
[
  18
  1
]
67 0.17 ms
SELECT DISTINCT i.*, c.uuid AS collection_uuid FROM nglayouts_collection_item i INNER JOIN nglayouts_collection c ON (c.id = i.collection_id) AND (c.status = i.status) WHERE (i.collection_id = ?) AND (i.status = ?) ORDER BY i.position ASC
Parameters:
[
  18
  1
]
68 0.14 ms
SELECT DISTINCT s.*, c.uuid AS collection_uuid FROM nglayouts_collection_slot s INNER JOIN nglayouts_collection c ON (c.id = s.collection_id) AND (c.status = s.status) WHERE (s.collection_id = ?) AND (s.status = ?) ORDER BY s.position ASC
Parameters:
[
  18
  1
]
69 0.23 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
]
70 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
]
71 0.07 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
]
72 0.36 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
]
73 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:
[
  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

Class Mapping errors
Netgen\InformationCollection\Doctrine\Entity\EzInfoCollection No errors.
Netgen\InformationCollection\Doctrine\Entity\EzInfoCollectionAttribute No errors.

ibexa_default entity manager

No loaded entities.