Query Metrics
64
Database Queries
14
Different statements
34.66 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.58 ms |
update bolt_content SET status = 'published', published_at = :now WHERE status = 'timed' AND published_at < :now
Parameters:
[ ":now" => Carbon\Carbon {#1975 : "2025-12-08 23:20:31" } ] |
| 2 | 0.40 ms |
update bolt_content SET status = 'held', depublished_at = :now WHERE status = 'published' AND depublished_at < :now
Parameters:
[ ":now" => Carbon\Carbon {#1975 : "2025-12-08 23:20:31" } ] |
| 3 | 0.61 ms |
SELECT t0.id AS id_1, t0.content_type AS content_type_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.modified_at AS modified_at_5, t0.published_at AS published_at_6, t0.depublished_at AS depublished_at_7, t0.author_id AS author_id_8, t9.id AS id_10, t9.display_name AS display_name_11, t9.username AS username_12, t9.email AS email_13, t9.password AS password_14, t9.roles AS roles_15, t9.lastseen_at AS lastseen_at_16, t9.last_ip AS last_ip_17, t9.locale AS locale_18, t9.backend_theme AS backend_theme_19, t9.status AS status_20, t9.avatar AS avatar_21 FROM bolt_content t0 LEFT JOIN bolt_user t9 ON t0.author_id = t9.id WHERE t0.content_type = ? AND t0.id = ? LIMIT 1
Parameters:
[ "homepage" 1 ] |
| 4 | 0.62 ms |
SELECT t0.id AS id_1, t0.content_type AS content_type_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.modified_at AS modified_at_5, t0.published_at AS published_at_6, t0.depublished_at AS depublished_at_7, t0.author_id AS author_id_8, t9.id AS id_10, t9.display_name AS display_name_11, t9.username AS username_12, t9.email AS email_13, t9.password AS password_14, t9.roles AS roles_15, t9.lastseen_at AS lastseen_at_16, t9.last_ip AS last_ip_17, t9.locale AS locale_18, t9.backend_theme AS backend_theme_19, t9.status AS status_20, t9.avatar AS avatar_21 FROM bolt_content t0 LEFT JOIN bolt_user t9 ON t0.author_id = t9.id WHERE t0.content_type = ? LIMIT 1
Parameters:
[
"homepage"
]
|
| 5 | 0.79 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, t7.id AS id_6, t7.content_type AS content_type_8, t7.status AS status_9, t7.created_at AS created_at_10, t7.modified_at AS modified_at_11, t7.published_at AS published_at_12, t7.depublished_at AS depublished_at_13, t7.author_id AS author_id_14, t0.parent_id AS parent_id_15, t0.type FROM bolt_field t0 INNER JOIN bolt_content t7 ON t0.content_id = t7.id WHERE t0.content_id = ? AND t0.type IN ('generic', 'select', 'set', 'templateselect', 'block', 'textarea', 'filelist', 'hidden', 'email', 'date', 'embed', 'text', 'checkbox', 'image', 'markdown', 'file', 'collection', 'imagelist', 'slug', 'number', 'data', 'html', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
5
]
|
| 6 | 0.45 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
]
|
| 7 | 0.56 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_.author_id AS author_id_7 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ? ORDER BY b0_.published_at DESC LIMIT 1
Parameters:
[ "settings" "published" ] |
| 8 | 1.01 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, t7.id AS id_6, t7.content_type AS content_type_8, t7.status AS status_9, t7.created_at AS created_at_10, t7.modified_at AS modified_at_11, t7.published_at AS published_at_12, t7.depublished_at AS depublished_at_13, t7.author_id AS author_id_14, t0.parent_id AS parent_id_15, t0.type FROM bolt_field t0 INNER JOIN bolt_content t7 ON t0.content_id = t7.id WHERE t0.content_id = ? AND t0.type IN ('generic', 'select', 'set', 'templateselect', 'block', 'textarea', 'filelist', 'hidden', 'email', 'date', 'embed', 'text', 'checkbox', 'image', 'markdown', 'file', 'collection', 'imagelist', 'slug', 'number', 'data', 'html', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
3
]
|
| 9 | 0.45 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
12
]
|
| 10 | 0.46 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
13
]
|
| 11 | 0.45 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
15
]
|
| 12 | 0.43 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
19
]
|
| 13 | 0.45 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
20
]
|
| 14 | 0.45 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
21
]
|
| 15 | 0.44 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
22
]
|
| 16 | 0.44 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
23
]
|
| 17 | 0.45 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
24
]
|
| 18 | 0.47 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
25
]
|
| 19 | 0.49 ms |
SELECT t0.id AS id_1, t0.location AS location_2, t0.path AS path_3, t0.filename AS filename_4, t0.type AS type_5, t0.width AS width_6, t0.height AS height_7, t0.filesize AS filesize_8, t0.crop_x AS crop_x_9, t0.crop_y AS crop_y_10, t0.crop_zoom AS crop_zoom_11, t0.created_at AS created_at_12, t0.modified_at AS modified_at_13, t0.title AS title_14, t0.description AS description_15, t0.original_filename AS original_filename_16, t0.copyright AS copyright_17, t0.author_id AS author_id_18 FROM bolt_media t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
7
]
|
| 20 | 0.44 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
53
]
|
| 21 | 0.44 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
52
]
|
| 22 | 0.43 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
51
]
|
| 23 | 0.55 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_.author_id AS author_id_7 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ? ORDER BY b0_.published_at DESC LIMIT 1
Parameters:
[ "projektbeschreibung" "published" ] |
| 24 | 0.87 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, t7.id AS id_6, t7.content_type AS content_type_8, t7.status AS status_9, t7.created_at AS created_at_10, t7.modified_at AS modified_at_11, t7.published_at AS published_at_12, t7.depublished_at AS depublished_at_13, t7.author_id AS author_id_14, t0.parent_id AS parent_id_15, t0.type FROM bolt_field t0 INNER JOIN bolt_content t7 ON t0.content_id = t7.id WHERE t0.content_id = ? AND t0.type IN ('generic', 'select', 'set', 'templateselect', 'block', 'textarea', 'filelist', 'hidden', 'email', 'date', 'embed', 'text', 'checkbox', 'image', 'markdown', 'file', 'collection', 'imagelist', 'slug', 'number', 'data', 'html', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
4
]
|
| 25 | 0.51 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, t7.id AS id_6, t7.content_type AS content_type_8, t7.status AS status_9, t7.created_at AS created_at_10, t7.modified_at AS modified_at_11, t7.published_at AS published_at_12, t7.depublished_at AS depublished_at_13, t7.author_id AS author_id_14, t0.parent_id AS parent_id_15, t0.type FROM bolt_field t0 INNER JOIN bolt_content t7 ON t0.content_id = t7.id WHERE t0.id = ? AND t0.type IN ('generic', 'select', 'set', 'templateselect', 'block', 'textarea', 'filelist', 'hidden', 'email', 'date', 'embed', 'text', 'checkbox', 'image', 'markdown', 'file', 'collection', 'imagelist', 'slug', 'number', 'data', 'html', 'article', 'redactor')
Parameters:
[
365
]
|
| 26 | 0.60 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, t7.id AS id_6, t7.content_type AS content_type_8, t7.status AS status_9, t7.created_at AS created_at_10, t7.modified_at AS modified_at_11, t7.published_at AS published_at_12, t7.depublished_at AS depublished_at_13, t7.author_id AS author_id_14, t0.parent_id AS parent_id_15, t0.type FROM bolt_field t0 INNER JOIN bolt_content t7 ON t0.content_id = t7.id WHERE t0.id = ? AND t0.type IN ('generic', 'select', 'set', 'templateselect', 'block', 'textarea', 'filelist', 'hidden', 'email', 'date', 'embed', 'text', 'checkbox', 'image', 'markdown', 'file', 'collection', 'imagelist', 'slug', 'number', 'data', 'html', 'article', 'redactor')
Parameters:
[
366
]
|
| 27 | 0.52 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, t7.id AS id_6, t7.content_type AS content_type_8, t7.status AS status_9, t7.created_at AS created_at_10, t7.modified_at AS modified_at_11, t7.published_at AS published_at_12, t7.depublished_at AS depublished_at_13, t7.author_id AS author_id_14, t0.parent_id AS parent_id_15, t0.type FROM bolt_field t0 INNER JOIN bolt_content t7 ON t0.content_id = t7.id WHERE t0.id = ? AND t0.type IN ('generic', 'select', 'set', 'templateselect', 'block', 'textarea', 'filelist', 'hidden', 'email', 'date', 'embed', 'text', 'checkbox', 'image', 'markdown', 'file', 'collection', 'imagelist', 'slug', 'number', 'data', 'html', 'article', 'redactor')
Parameters:
[
367
]
|
| 28 | 0.61 ms |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.sortorder AS sortorder_2, b0_.version AS version_3, b0_.type AS type_4, b0_.content_id AS content_id_5, b0_.parent_id AS parent_id_6 FROM bolt_field b0_ WHERE (b0_.parent_id = ?) AND b0_.type IN ('generic', 'select', 'set', 'templateselect', 'block', 'textarea', 'filelist', 'hidden', 'email', 'date', 'embed', 'text', 'checkbox', 'image', 'markdown', 'file', 'collection', 'imagelist', 'slug', 'number', 'data', 'html', 'article', 'redactor') ORDER BY b0_.sortorder ASC
Parameters:
[
71
]
|
| 29 | 0.62 ms |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.sortorder AS sortorder_2, b0_.version AS version_3, b0_.type AS type_4, b0_.content_id AS content_id_5, b0_.parent_id AS parent_id_6 FROM bolt_field b0_ WHERE (b0_.parent_id = ?) AND b0_.type IN ('generic', 'select', 'set', 'templateselect', 'block', 'textarea', 'filelist', 'hidden', 'email', 'date', 'embed', 'text', 'checkbox', 'image', 'markdown', 'file', 'collection', 'imagelist', 'slug', 'number', 'data', 'html', 'article', 'redactor') ORDER BY b0_.sortorder ASC
Parameters:
[
365
]
|
| 30 | 0.57 ms |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.sortorder AS sortorder_2, b0_.version AS version_3, b0_.type AS type_4, b0_.content_id AS content_id_5, b0_.parent_id AS parent_id_6 FROM bolt_field b0_ WHERE (b0_.parent_id = ?) AND b0_.type IN ('generic', 'select', 'set', 'templateselect', 'block', 'textarea', 'filelist', 'hidden', 'email', 'date', 'embed', 'text', 'checkbox', 'image', 'markdown', 'file', 'collection', 'imagelist', 'slug', 'number', 'data', 'html', 'article', 'redactor') ORDER BY b0_.sortorder ASC
Parameters:
[
366
]
|
| 31 | 0.54 ms |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.sortorder AS sortorder_2, b0_.version AS version_3, b0_.type AS type_4, b0_.content_id AS content_id_5, b0_.parent_id AS parent_id_6 FROM bolt_field b0_ WHERE (b0_.parent_id = ?) AND b0_.type IN ('generic', 'select', 'set', 'templateselect', 'block', 'textarea', 'filelist', 'hidden', 'email', 'date', 'embed', 'text', 'checkbox', 'image', 'markdown', 'file', 'collection', 'imagelist', 'slug', 'number', 'data', 'html', 'article', 'redactor') ORDER BY b0_.sortorder ASC
Parameters:
[
367
]
|
| 32 | 0.37 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
48
]
|
| 33 | 0.46 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
47
]
|
| 34 | 0.42 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
46
]
|
| 35 | 0.45 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
362
]
|
| 36 | 0.39 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
359
]
|
| 37 | 0.42 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
356
]
|
| 38 | 0.41 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
363
]
|
| 39 | 0.39 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
360
]
|
| 40 | 0.40 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
357
]
|
| 41 | 0.38 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
364
]
|
| 42 | 0.40 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
361
]
|
| 43 | 0.39 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
358
]
|
| 44 | 0.89 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 FROM bolt_content b0_ LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id AND b1_.type IN ('generic', 'select', 'set', 'templateselect', 'block', 'textarea', 'filelist', 'hidden', 'email', 'date', 'embed', 'text', 'checkbox', 'image', 'markdown', 'file', 'collection', 'imagelist', 'slug', 'number', 'data', 'html', 'article', 'redactor') LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id WHERE b0_.content_type = ? AND b0_.status = ? AND b1_.name = ? ORDER BY LOWER(b2_.value) ASC) dctrn_result) dctrn_table
Parameters:
[ "gemeinden" "published" "title" ] |
| 45 | 1.97 ms |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, LOWER(value_8) 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, b1_.name AS name_7, b2_.value AS value_8, b1_.type AS type_9 FROM bolt_content b0_ LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id AND b1_.type IN ('generic', 'select', 'set', 'templateselect', 'block', 'textarea', 'filelist', 'hidden', 'email', 'date', 'embed', 'text', 'checkbox', 'image', 'markdown', 'file', 'collection', 'imagelist', 'slug', 'number', 'data', 'html', 'article', 'redactor') LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id WHERE b0_.content_type = ? AND b0_.status = ? AND b1_.name = ? ORDER BY b1_.sortorder ASC) dctrn_result_inner ORDER BY LOWER(value_8) ASC) dctrn_result LIMIT 1000
Parameters:
[ "gemeinden" "published" "title" ] |
| 46 | 1.45 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_.author_id AS author_id_7 FROM bolt_content b0_ LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id AND b1_.type IN ('generic', 'select', 'set', 'templateselect', 'block', 'textarea', 'filelist', 'hidden', 'email', 'date', 'embed', 'text', 'checkbox', 'image', 'markdown', 'file', 'collection', 'imagelist', 'slug', 'number', 'data', 'html', 'article', 'redactor') LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id WHERE b0_.content_type = ? AND b0_.status = ? AND b1_.name = ? AND b0_.id IN (?) ORDER BY LOWER(b2_.value) ASC
Parameters:
[ "gemeinden" "published" "title" [ 11 12 13 ] ] |
| 47 | 0.71 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, t7.id AS id_6, t7.content_type AS content_type_8, t7.status AS status_9, t7.created_at AS created_at_10, t7.modified_at AS modified_at_11, t7.published_at AS published_at_12, t7.depublished_at AS depublished_at_13, t7.author_id AS author_id_14, t0.parent_id AS parent_id_15, t0.type FROM bolt_field t0 INNER JOIN bolt_content t7 ON t0.content_id = t7.id WHERE t0.content_id = ? AND t0.type IN ('generic', 'select', 'set', 'templateselect', 'block', 'textarea', 'filelist', 'hidden', 'email', 'date', 'embed', 'text', 'checkbox', 'image', 'markdown', 'file', 'collection', 'imagelist', 'slug', 'number', 'data', 'html', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
11
]
|
| 48 | 0.67 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, t7.id AS id_6, t7.content_type AS content_type_8, t7.status AS status_9, t7.created_at AS created_at_10, t7.modified_at AS modified_at_11, t7.published_at AS published_at_12, t7.depublished_at AS depublished_at_13, t7.author_id AS author_id_14, t0.parent_id AS parent_id_15, t0.type FROM bolt_field t0 INNER JOIN bolt_content t7 ON t0.content_id = t7.id WHERE t0.content_id = ? AND t0.type IN ('generic', 'select', 'set', 'templateselect', 'block', 'textarea', 'filelist', 'hidden', 'email', 'date', 'embed', 'text', 'checkbox', 'image', 'markdown', 'file', 'collection', 'imagelist', 'slug', 'number', 'data', 'html', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
12
]
|
| 49 | 0.70 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, t7.id AS id_6, t7.content_type AS content_type_8, t7.status AS status_9, t7.created_at AS created_at_10, t7.modified_at AS modified_at_11, t7.published_at AS published_at_12, t7.depublished_at AS depublished_at_13, t7.author_id AS author_id_14, t0.parent_id AS parent_id_15, t0.type FROM bolt_field t0 INNER JOIN bolt_content t7 ON t0.content_id = t7.id WHERE t0.content_id = ? AND t0.type IN ('generic', 'select', 'set', 'templateselect', 'block', 'textarea', 'filelist', 'hidden', 'email', 'date', 'embed', 'text', 'checkbox', 'image', 'markdown', 'file', 'collection', 'imagelist', 'slug', 'number', 'data', 'html', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
13
]
|
| 50 | 0.43 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
117
]
|
| 51 | 0.48 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
122
]
|
| 52 | 0.43 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
124
]
|
| 53 | 0.44 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
129
]
|
| 54 | 0.43 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
131
]
|
| 55 | 0.44 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
136
]
|
| 56 | 0.54 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_.author_id AS author_id_7 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ? ORDER BY b0_.published_at DESC LIMIT 1
Parameters:
[ "settings" "published" ] |
| 57 | 0.44 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
14
]
|
| 58 | 0.44 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
28
]
|
| 59 | 0.42 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
29
]
|
| 60 | 0.44 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
30
]
|
| 61 | 0.46 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
31
]
|
| 62 | 0.42 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
32
]
|
| 63 | 0.43 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
26
]
|
| 64 | 0.42 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
27
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| Bolt\Entity\Content | No errors. |
| Bolt\Entity\Taxonomy | No errors. |
| Bolt\Entity\Media | No errors. |
| Bolt\Entity\Relation | No errors. |
| Bolt\Entity\User | No errors. |
| Bolt\Entity\Field | No errors. |
| Bolt\Entity\Field\SelectField | No errors. |
| Bolt\Entity\Field\SetField | No errors. |
| Bolt\Entity\Field\TemplateselectField | No errors. |
| Bolt\Entity\Field\BlockField | No errors. |
| Bolt\Entity\Field\TextareaField | No errors. |
| Bolt\Entity\Field\FilelistField | No errors. |
| Bolt\Entity\Field\HiddenField | No errors. |
| Bolt\Entity\Field\EmailField | No errors. |
| Bolt\Entity\Field\DateField | No errors. |
| Bolt\Entity\Field\EmbedField | No errors. |
| Bolt\Entity\Field\TextField | No errors. |
| Bolt\Entity\Field\CheckboxField | No errors. |
| Bolt\Entity\Field\ImageField | No errors. |
| Bolt\Entity\Field\MarkdownField | No errors. |
| Bolt\Entity\Field\FileField | No errors. |
| Bolt\Entity\Field\CollectionField | No errors. |
| Bolt\Entity\Field\ImagelistField | No errors. |
| Bolt\Entity\Field\SlugField | No errors. |
| Bolt\Entity\Field\NumberField | No errors. |
| Bolt\Entity\Field\DataField | No errors. |
| Bolt\Entity\Field\HtmlField | No errors. |
| Bolt\Article\Entity\ArticleField | No errors. |
| Bolt\Redactor\Entity\RedactorField | No errors. |
| Bolt\Entity\FieldTranslation | No errors. |
| Bolt\Entity\UserAuthToken | No errors. |