GET https://media.alpha.se7enx.com/content/search

Response
200 OK
IP
216.73.216.41
Profiled on
Token
ce9667

Query Metrics

48 Database Queries
13 Different statements
57.78 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

#▲ Time Info
1 2.39 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
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.79 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
]
View formatted query    View runnable query    Explain query    View query backtrace
3 1.86 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
]
View formatted query    View runnable query    Explain query    View query backtrace
4 1.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
]
View formatted query    View runnable query    Explain query    View query backtrace
5 1.88 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
  "/content/search"
]
View formatted query    View runnable query    Explain query    View query backtrace
6 1.01 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
]
View formatted query    View runnable query    Explain query    View query backtrace
7 1.58 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 ((CHAR_LENGTH(TRIM(rt.value)) > ?) AND (? LIKE CONCAT(TRIM(rt.value), '%'))) ORDER BY rd.priority DESC
Parameters: 
[
  1
  1
  1
  "ibexa_semantic_path_info_prefix"
  1
  0
  "/content/search"
]
View formatted query    View runnable query    Explain query    View query backtrace
8 1.07 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
]
View formatted query    View runnable query    Explain query    View query backtrace
9 1.91 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
  "/content/search"
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.45 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
]
View formatted query    View runnable query    Explain query    View query backtrace
11 1.14 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 ((CHAR_LENGTH(TRIM(rt.value)) > ?) AND (? LIKE CONCAT(TRIM(rt.value), '%'))) ORDER BY rd.priority DESC
Parameters: 
[
  1
  1
  1
  "request_uri_prefix"
  1
  0
  "/content/search"
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.29 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
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.94 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
  "/content/search"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 1.67 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
]
View formatted query    View runnable query    Explain query    View query backtrace
15 2.32 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 ((CHAR_LENGTH(TRIM(rt.value)) > ?) AND (? LIKE CONCAT(TRIM(rt.value), '%'))) ORDER BY rd.priority DESC
Parameters: 
[
  1
  1
  1
  "path_info_prefix"
  1
  0
  "/content/search"
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.39 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
]
View formatted query    View runnable query    Explain query    View query backtrace
17 1.86 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
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.44 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
]
View formatted query    View runnable query    Explain query    View query backtrace
19 1.22 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
  "ngsite_content_search"
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.48 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
]
View formatted query    View runnable query    Explain query    View query backtrace
21 2.19 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 ((CHAR_LENGTH(TRIM(rt.value)) > ?) AND (? LIKE CONCAT(TRIM(rt.value), '%'))) ORDER BY rd.priority DESC
Parameters: 
[
  1
  1
  1
  "route_prefix"
  1
  0
  "ngsite_content_search"
]
View formatted query    View runnable query    Explain query    View query backtrace
22 1.39 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
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.93 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
]
View formatted query    View runnable query    Explain query    View query backtrace
24 1.00 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
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.45 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
]
View formatted query    View runnable query    Explain query    View query backtrace
26 0.50 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
]
View formatted query    View runnable query    Explain query    View query backtrace
27 2.63 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
]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.98 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: 
[
  "fd0aa7af-77a8-5a03-bf10-80018f5db1dc"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
29 0.78 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
]
View formatted query    View runnable query    Explain query    View query backtrace
30 1.04 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
]
View formatted query    View runnable query    Explain query    View query backtrace
31 2.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.placeholder = ?) AND (b.status = ?) ORDER BY b.placeholder ASC, b.position ASC
Parameters: 
[
  475
  "main"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
32 0.92 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
]
View formatted query    View runnable query    Explain query    View query backtrace
33 0.67 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
]
View formatted query    View runnable query    Explain query    View query backtrace
34 0.43 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
]
View formatted query    View runnable query    Explain query    View query backtrace
35 2.33 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
]
View formatted query    View runnable query    Explain query    View query backtrace
36 1.28 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
]
View formatted query    View runnable query    Explain query    View query backtrace
37 0.96 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
]
View formatted query    View runnable query    Explain query    View query backtrace
38 1.94 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
]
View formatted query    View runnable query    Explain query    View query backtrace
39 0.97 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
]
View formatted query    View runnable query    Explain query    View query backtrace
40 1.00 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
]
View formatted query    View runnable query    Explain query    View query backtrace
41 0.78 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
]
View formatted query    View runnable query    Explain query    View query backtrace
42 1.09 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
]
View formatted query    View runnable query    Explain query    View query backtrace
43 1.20 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
]
View formatted query    View runnable query    Explain query    View query backtrace
44 1.00 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
]
View formatted query    View runnable query    Explain query    View query backtrace
45 0.48 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
]
View formatted query    View runnable query    Explain query    View query backtrace
46 0.49 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
]
View formatted query    View runnable query    Explain query    View query backtrace
47 2.55 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
]
View formatted query    View runnable query    Explain query    View query backtrace
48 0.71 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
]
View formatted query    View runnable query    Explain query    View query backtrace

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.