GET http://www.vriendenvanhetoverbosch.nl/news?year=2020

Query Metrics

27 Database Queries
11 Different statements
8.14 ms Query time
0 Invalid entities
106 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.51 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_5 FROM (SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ?) dctrn_result_inner ORDER BY published_at_5 DESC) dctrn_result LIMIT 1
Parameters:
[
  "news"
  "published"
]
2 0.21 ms
SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8, b0_.author_id AS author_id_9 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ? AND b0_.id IN (?) ORDER BY b0_.published_at DESC
Parameters:
[
  "news"
  "published"
  299
]
3 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sortorder AS sortorder_3, t0.version AS version_4, t0.content_id AS content_id_5, t6.id AS id_7, t6.content_type AS content_type_8, t6.status AS status_9, t6.created_at AS created_at_10, t6.modified_at AS modified_at_11, t6.published_at AS published_at_12, t6.depublished_at AS depublished_at_13, t6.title AS title_14, t6.list_format AS list_format_15, t6.author_id AS author_id_16, t0.parent_id AS parent_id_17, t0.type FROM bolt_field t0 INNER JOIN bolt_content t6 ON t0.content_id = t6.id WHERE t0.content_id = ? AND t0.type IN ('generic', 'select', 'email', 'set', 'templateselect', 'embed', 'markdown', 'checkbox', 'filelist', 'imagelist', 'date', 'file', 'number', 'html', 'data', 'image', 'hidden', 'textarea', 'slug', 'text', 'block', 'collection', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  299
]
4 0.16 ms
SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.lastseen_at AS lastseen_at_7, t0.last_ip AS last_ip_8, t0.locale AS locale_9, t0.backend_theme AS backend_theme_10, t0.status AS status_11, t0.avatar AS avatar_12, t0.about AS about_13 FROM bolt_user t0 WHERE t0.id IN (?)
Parameters:
[
  1
]
5 0.16 ms
SELECT t0.id AS id_1, t0.useragent AS useragent_2, t0.validity AS validity_3, t0.user_id AS user_id_4 FROM bolt_user_auth_token t0 WHERE t0.user_id = ?
Parameters:
[
  1
]
6 0.45 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ? ORDER BY b0_.published_at DESC) dctrn_result) dctrn_table
Parameters:
[
  "news"
  "published"
]
7 0.45 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_5 FROM (SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ?) dctrn_result_inner ORDER BY published_at_5 DESC) dctrn_result LIMIT 15
Parameters:
[
  "news"
  "published"
]
8 0.32 ms
SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8, b0_.author_id AS author_id_9 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ? AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY b0_.published_at DESC
Parameters:
[
  "news"
  "published"
  299
  298
  297
  296
  295
  294
  293
  292
  291
  290
  289
  288
  287
  286
  285
]
9 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sortorder AS sortorder_3, t0.version AS version_4, t0.content_id AS content_id_5, t6.id AS id_7, t6.content_type AS content_type_8, t6.status AS status_9, t6.created_at AS created_at_10, t6.modified_at AS modified_at_11, t6.published_at AS published_at_12, t6.depublished_at AS depublished_at_13, t6.title AS title_14, t6.list_format AS list_format_15, t6.author_id AS author_id_16, t0.parent_id AS parent_id_17, t0.type FROM bolt_field t0 INNER JOIN bolt_content t6 ON t0.content_id = t6.id WHERE t0.content_id = ? AND t0.type IN ('generic', 'select', 'email', 'set', 'templateselect', 'embed', 'markdown', 'checkbox', 'filelist', 'imagelist', 'date', 'file', 'number', 'html', 'data', 'image', 'hidden', 'textarea', 'slug', 'text', 'block', 'collection', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  298
]
10 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sortorder AS sortorder_3, t0.version AS version_4, t0.content_id AS content_id_5, t6.id AS id_7, t6.content_type AS content_type_8, t6.status AS status_9, t6.created_at AS created_at_10, t6.modified_at AS modified_at_11, t6.published_at AS published_at_12, t6.depublished_at AS depublished_at_13, t6.title AS title_14, t6.list_format AS list_format_15, t6.author_id AS author_id_16, t0.parent_id AS parent_id_17, t0.type FROM bolt_field t0 INNER JOIN bolt_content t6 ON t0.content_id = t6.id WHERE t0.content_id = ? AND t0.type IN ('generic', 'select', 'email', 'set', 'templateselect', 'embed', 'markdown', 'checkbox', 'filelist', 'imagelist', 'date', 'file', 'number', 'html', 'data', 'image', 'hidden', 'textarea', 'slug', 'text', 'block', 'collection', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  297
]
11 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sortorder AS sortorder_3, t0.version AS version_4, t0.content_id AS content_id_5, t6.id AS id_7, t6.content_type AS content_type_8, t6.status AS status_9, t6.created_at AS created_at_10, t6.modified_at AS modified_at_11, t6.published_at AS published_at_12, t6.depublished_at AS depublished_at_13, t6.title AS title_14, t6.list_format AS list_format_15, t6.author_id AS author_id_16, t0.parent_id AS parent_id_17, t0.type FROM bolt_field t0 INNER JOIN bolt_content t6 ON t0.content_id = t6.id WHERE t0.content_id = ? AND t0.type IN ('generic', 'select', 'email', 'set', 'templateselect', 'embed', 'markdown', 'checkbox', 'filelist', 'imagelist', 'date', 'file', 'number', 'html', 'data', 'image', 'hidden', 'textarea', 'slug', 'text', 'block', 'collection', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  296
]
12 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sortorder AS sortorder_3, t0.version AS version_4, t0.content_id AS content_id_5, t6.id AS id_7, t6.content_type AS content_type_8, t6.status AS status_9, t6.created_at AS created_at_10, t6.modified_at AS modified_at_11, t6.published_at AS published_at_12, t6.depublished_at AS depublished_at_13, t6.title AS title_14, t6.list_format AS list_format_15, t6.author_id AS author_id_16, t0.parent_id AS parent_id_17, t0.type FROM bolt_field t0 INNER JOIN bolt_content t6 ON t0.content_id = t6.id WHERE t0.content_id = ? AND t0.type IN ('generic', 'select', 'email', 'set', 'templateselect', 'embed', 'markdown', 'checkbox', 'filelist', 'imagelist', 'date', 'file', 'number', 'html', 'data', 'image', 'hidden', 'textarea', 'slug', 'text', 'block', 'collection', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  295
]
13 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sortorder AS sortorder_3, t0.version AS version_4, t0.content_id AS content_id_5, t6.id AS id_7, t6.content_type AS content_type_8, t6.status AS status_9, t6.created_at AS created_at_10, t6.modified_at AS modified_at_11, t6.published_at AS published_at_12, t6.depublished_at AS depublished_at_13, t6.title AS title_14, t6.list_format AS list_format_15, t6.author_id AS author_id_16, t0.parent_id AS parent_id_17, t0.type FROM bolt_field t0 INNER JOIN bolt_content t6 ON t0.content_id = t6.id WHERE t0.content_id = ? AND t0.type IN ('generic', 'select', 'email', 'set', 'templateselect', 'embed', 'markdown', 'checkbox', 'filelist', 'imagelist', 'date', 'file', 'number', 'html', 'data', 'image', 'hidden', 'textarea', 'slug', 'text', 'block', 'collection', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  294
]
14 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sortorder AS sortorder_3, t0.version AS version_4, t0.content_id AS content_id_5, t6.id AS id_7, t6.content_type AS content_type_8, t6.status AS status_9, t6.created_at AS created_at_10, t6.modified_at AS modified_at_11, t6.published_at AS published_at_12, t6.depublished_at AS depublished_at_13, t6.title AS title_14, t6.list_format AS list_format_15, t6.author_id AS author_id_16, t0.parent_id AS parent_id_17, t0.type FROM bolt_field t0 INNER JOIN bolt_content t6 ON t0.content_id = t6.id WHERE t0.content_id = ? AND t0.type IN ('generic', 'select', 'email', 'set', 'templateselect', 'embed', 'markdown', 'checkbox', 'filelist', 'imagelist', 'date', 'file', 'number', 'html', 'data', 'image', 'hidden', 'textarea', 'slug', 'text', 'block', 'collection', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  293
]
15 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sortorder AS sortorder_3, t0.version AS version_4, t0.content_id AS content_id_5, t6.id AS id_7, t6.content_type AS content_type_8, t6.status AS status_9, t6.created_at AS created_at_10, t6.modified_at AS modified_at_11, t6.published_at AS published_at_12, t6.depublished_at AS depublished_at_13, t6.title AS title_14, t6.list_format AS list_format_15, t6.author_id AS author_id_16, t0.parent_id AS parent_id_17, t0.type FROM bolt_field t0 INNER JOIN bolt_content t6 ON t0.content_id = t6.id WHERE t0.content_id = ? AND t0.type IN ('generic', 'select', 'email', 'set', 'templateselect', 'embed', 'markdown', 'checkbox', 'filelist', 'imagelist', 'date', 'file', 'number', 'html', 'data', 'image', 'hidden', 'textarea', 'slug', 'text', 'block', 'collection', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  292
]
16 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sortorder AS sortorder_3, t0.version AS version_4, t0.content_id AS content_id_5, t6.id AS id_7, t6.content_type AS content_type_8, t6.status AS status_9, t6.created_at AS created_at_10, t6.modified_at AS modified_at_11, t6.published_at AS published_at_12, t6.depublished_at AS depublished_at_13, t6.title AS title_14, t6.list_format AS list_format_15, t6.author_id AS author_id_16, t0.parent_id AS parent_id_17, t0.type FROM bolt_field t0 INNER JOIN bolt_content t6 ON t0.content_id = t6.id WHERE t0.content_id = ? AND t0.type IN ('generic', 'select', 'email', 'set', 'templateselect', 'embed', 'markdown', 'checkbox', 'filelist', 'imagelist', 'date', 'file', 'number', 'html', 'data', 'image', 'hidden', 'textarea', 'slug', 'text', 'block', 'collection', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  291
]
17 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sortorder AS sortorder_3, t0.version AS version_4, t0.content_id AS content_id_5, t6.id AS id_7, t6.content_type AS content_type_8, t6.status AS status_9, t6.created_at AS created_at_10, t6.modified_at AS modified_at_11, t6.published_at AS published_at_12, t6.depublished_at AS depublished_at_13, t6.title AS title_14, t6.list_format AS list_format_15, t6.author_id AS author_id_16, t0.parent_id AS parent_id_17, t0.type FROM bolt_field t0 INNER JOIN bolt_content t6 ON t0.content_id = t6.id WHERE t0.content_id = ? AND t0.type IN ('generic', 'select', 'email', 'set', 'templateselect', 'embed', 'markdown', 'checkbox', 'filelist', 'imagelist', 'date', 'file', 'number', 'html', 'data', 'image', 'hidden', 'textarea', 'slug', 'text', 'block', 'collection', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  290
]
18 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sortorder AS sortorder_3, t0.version AS version_4, t0.content_id AS content_id_5, t6.id AS id_7, t6.content_type AS content_type_8, t6.status AS status_9, t6.created_at AS created_at_10, t6.modified_at AS modified_at_11, t6.published_at AS published_at_12, t6.depublished_at AS depublished_at_13, t6.title AS title_14, t6.list_format AS list_format_15, t6.author_id AS author_id_16, t0.parent_id AS parent_id_17, t0.type FROM bolt_field t0 INNER JOIN bolt_content t6 ON t0.content_id = t6.id WHERE t0.content_id = ? AND t0.type IN ('generic', 'select', 'email', 'set', 'templateselect', 'embed', 'markdown', 'checkbox', 'filelist', 'imagelist', 'date', 'file', 'number', 'html', 'data', 'image', 'hidden', 'textarea', 'slug', 'text', 'block', 'collection', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  289
]
19 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sortorder AS sortorder_3, t0.version AS version_4, t0.content_id AS content_id_5, t6.id AS id_7, t6.content_type AS content_type_8, t6.status AS status_9, t6.created_at AS created_at_10, t6.modified_at AS modified_at_11, t6.published_at AS published_at_12, t6.depublished_at AS depublished_at_13, t6.title AS title_14, t6.list_format AS list_format_15, t6.author_id AS author_id_16, t0.parent_id AS parent_id_17, t0.type FROM bolt_field t0 INNER JOIN bolt_content t6 ON t0.content_id = t6.id WHERE t0.content_id = ? AND t0.type IN ('generic', 'select', 'email', 'set', 'templateselect', 'embed', 'markdown', 'checkbox', 'filelist', 'imagelist', 'date', 'file', 'number', 'html', 'data', 'image', 'hidden', 'textarea', 'slug', 'text', 'block', 'collection', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  288
]
20 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sortorder AS sortorder_3, t0.version AS version_4, t0.content_id AS content_id_5, t6.id AS id_7, t6.content_type AS content_type_8, t6.status AS status_9, t6.created_at AS created_at_10, t6.modified_at AS modified_at_11, t6.published_at AS published_at_12, t6.depublished_at AS depublished_at_13, t6.title AS title_14, t6.list_format AS list_format_15, t6.author_id AS author_id_16, t0.parent_id AS parent_id_17, t0.type FROM bolt_field t0 INNER JOIN bolt_content t6 ON t0.content_id = t6.id WHERE t0.content_id = ? AND t0.type IN ('generic', 'select', 'email', 'set', 'templateselect', 'embed', 'markdown', 'checkbox', 'filelist', 'imagelist', 'date', 'file', 'number', 'html', 'data', 'image', 'hidden', 'textarea', 'slug', 'text', 'block', 'collection', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  287
]
21 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sortorder AS sortorder_3, t0.version AS version_4, t0.content_id AS content_id_5, t6.id AS id_7, t6.content_type AS content_type_8, t6.status AS status_9, t6.created_at AS created_at_10, t6.modified_at AS modified_at_11, t6.published_at AS published_at_12, t6.depublished_at AS depublished_at_13, t6.title AS title_14, t6.list_format AS list_format_15, t6.author_id AS author_id_16, t0.parent_id AS parent_id_17, t0.type FROM bolt_field t0 INNER JOIN bolt_content t6 ON t0.content_id = t6.id WHERE t0.content_id = ? AND t0.type IN ('generic', 'select', 'email', 'set', 'templateselect', 'embed', 'markdown', 'checkbox', 'filelist', 'imagelist', 'date', 'file', 'number', 'html', 'data', 'image', 'hidden', 'textarea', 'slug', 'text', 'block', 'collection', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  286
]
22 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sortorder AS sortorder_3, t0.version AS version_4, t0.content_id AS content_id_5, t6.id AS id_7, t6.content_type AS content_type_8, t6.status AS status_9, t6.created_at AS created_at_10, t6.modified_at AS modified_at_11, t6.published_at AS published_at_12, t6.depublished_at AS depublished_at_13, t6.title AS title_14, t6.list_format AS list_format_15, t6.author_id AS author_id_16, t0.parent_id AS parent_id_17, t0.type FROM bolt_field t0 INNER JOIN bolt_content t6 ON t0.content_id = t6.id WHERE t0.content_id = ? AND t0.type IN ('generic', 'select', 'email', 'set', 'templateselect', 'embed', 'markdown', 'checkbox', 'filelist', 'imagelist', 'date', 'file', 'number', 'html', 'data', 'image', 'hidden', 'textarea', 'slug', 'text', 'block', 'collection', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  285
]
23 0.37 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ? ORDER BY b0_.published_at DESC) dctrn_result) dctrn_table
Parameters:
[
  "news"
  "published"
]
24 0.38 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_5 FROM (SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8 FROM bolt_content b0_ WHERE b0_.content_type = ? AND ((b0_.published_at >= ? AND b0_.published_at <= ?) AND b0_.status = ?)) dctrn_result_inner ORDER BY published_at_5 DESC) dctrn_result LIMIT 1
Parameters:
[
  "news"
  "2020-01-01 00:00"
  "2020-12-31 00:00"
  "published"
]
25 0.33 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8 FROM bolt_content b0_ WHERE b0_.content_type = ? AND ((b0_.published_at >= ? AND b0_.published_at <= ?) AND b0_.status = ?) ORDER BY b0_.published_at DESC) dctrn_result) dctrn_table
Parameters:
[
  "news"
  "2020-01-01 00:00"
  "2020-12-31 00:00"
  "published"
]
26 0.37 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_5 FROM (SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8 FROM bolt_content b0_ WHERE b0_.content_type = ? AND ((b0_.published_at >= ? AND b0_.published_at <= ?) AND b0_.status = ?)) dctrn_result_inner ORDER BY published_at_5 DESC) dctrn_result LIMIT 20
Parameters:
[
  "news"
  "2020-01-01 00:00"
  "2020-12-31 00:00"
  "published"
]
27 0.29 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8 FROM bolt_content b0_ WHERE b0_.content_type = ? AND ((b0_.published_at >= ? AND b0_.published_at <= ?) AND b0_.status = ?) ORDER BY b0_.published_at DESC) dctrn_result) dctrn_table
Parameters:
[
  "news"
  "2020-01-01 00:00"
  "2020-12-31 00:00"
  "published"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
Bolt\Entity\Field 90
Bolt\Entity\Content 15
Bolt\Entity\User 1