Query Metrics
10
Database Queries
9
Different statements
44.88 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 7.75 ms |
update bolt_content SET status = 'published', published_at = :now WHERE status = 'timed' AND published_at < :now
Parameters:
[ ":now" => Carbon\Carbon {#2769 : "2025-12-08 23:54:16" } ] |
| 2 | 2.72 ms |
update bolt_content SET status = 'held', depublished_at = :now WHERE status = 'published' AND depublished_at < :now
Parameters:
[ ":now" => Carbon\Carbon {#2769 : "2025-12-08 23:54:16" } ] |
| 3 | 6.56 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, t9.profile_id AS profile_id_22, t0.user_id AS user_id_23, t24.id AS id_25, t24.display_name AS display_name_26, t24.username AS username_27, t24.email AS email_28, t24.password AS password_29, t24.roles AS roles_30, t24.lastseen_at AS lastseen_at_31, t24.last_ip AS last_ip_32, t24.locale AS locale_33, t24.backend_theme AS backend_theme_34, t24.status AS status_35, t24.avatar AS avatar_36, t24.profile_id AS profile_id_37 FROM bolt_content t0 LEFT JOIN bolt_user t9 ON t0.author_id = t9.id LEFT JOIN bolt_user t24 ON t0.user_id = t24.id WHERE t0.content_type = ? AND t0.id = ? LIMIT 1
Parameters:
[ "homepage" 1 ] |
| 4 | 2.17 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, t9.profile_id AS profile_id_22, t0.user_id AS user_id_23, t24.id AS id_25, t24.display_name AS display_name_26, t24.username AS username_27, t24.email AS email_28, t24.password AS password_29, t24.roles AS roles_30, t24.lastseen_at AS lastseen_at_31, t24.last_ip AS last_ip_32, t24.locale AS locale_33, t24.backend_theme AS backend_theme_34, t24.status AS status_35, t24.avatar AS avatar_36, t24.profile_id AS profile_id_37 FROM bolt_content t0 LEFT JOIN bolt_user t9 ON t0.author_id = t9.id LEFT JOIN bolt_user t24 ON t0.user_id = t24.id WHERE t0.id IN (?)
Parameters:
[
[
68
]
]
|
| 5 | 3.22 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, t7.user_id AS user_id_15, t0.parent_id AS parent_id_16, t0.type FROM bolt_field t0 INNER JOIN bolt_content t7 ON t0.content_id = t7.id WHERE t0.content_id IN (?) AND t0.type IN ('generic', 'select', 'block', 'checkbox', 'collection', 'data', 'date', 'email', 'embed', 'file', 'filelist', 'hidden', 'html', 'image', 'imagelist', 'markdown', 'number', 'set', 'slug', 'templateselect', 'text', 'textarea')
Parameters:
[
[
1
68
]
]
|
| 6 | 1.97 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, t7.user_id AS user_id_15, t0.parent_id AS parent_id_16, 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', 'block', 'checkbox', 'collection', 'data', 'date', 'email', 'embed', 'file', 'filelist', 'hidden', 'html', 'image', 'imagelist', 'markdown', 'number', 'set', 'slug', 'templateselect', 'text', 'textarea') ORDER BY t0.sortorder ASC
Parameters:
[
1
]
|
| 7 | 6.21 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', 'block', 'checkbox', 'collection', 'data', 'date', 'email', 'embed', 'file', 'filelist', 'hidden', 'html', 'image', 'imagelist', 'markdown', 'number', 'set', 'slug', 'templateselect', 'text', 'textarea') ORDER BY b0_.sortorder ASC
Parameters:
[
693
]
|
| 8 | 1.59 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, t7.user_id AS user_id_15, t0.parent_id AS parent_id_16, 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', 'block', 'checkbox', 'collection', 'data', 'date', 'email', 'embed', 'file', 'filelist', 'hidden', 'html', 'image', 'imagelist', 'markdown', 'number', 'set', 'slug', 'templateselect', 'text', 'textarea') ORDER BY t0.sortorder ASC
Parameters:
[
68
]
|
| 9 | 4.47 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 IN (?)
Parameters:
[
[
1
]
]
|
| 10 | 8.23 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:
[
832
]
|
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\User | No errors. |
| Bolt\Entity\Content | No errors. |
| Bolt\Entity\Relation | No errors. |
| Bolt\Entity\Taxonomy | No errors. |
| Bolt\Entity\Media | No errors. |
| Bolt\Entity\Field | No errors. |
| Bolt\Entity\UserAuthToken | No errors. |
| Bolt\Entity\Field\SelectField | No errors. |
| Bolt\Entity\Field\BlockField | No errors. |
| Bolt\Entity\Field\CheckboxField | No errors. |
| Bolt\Entity\Field\CollectionField | No errors. |
| Bolt\Entity\Field\DataField | No errors. |
| Bolt\Entity\Field\DateField | No errors. |
| Bolt\Entity\Field\EmailField | No errors. |
| Bolt\Entity\Field\EmbedField | No errors. |
| Bolt\Entity\Field\FileField | No errors. |
| Bolt\Entity\Field\FilelistField | No errors. |
| Bolt\Entity\Field\HiddenField | No errors. |
| Bolt\Entity\Field\HtmlField | No errors. |
| Bolt\Entity\Field\ImageField | No errors. |
| Bolt\Entity\Field\ImagelistField | No errors. |
| Bolt\Entity\Field\MarkdownField | No errors. |
| Bolt\Entity\Field\NumberField | No errors. |
| Bolt\Entity\Field\SetField | No errors. |
| Bolt\Entity\Field\SlugField | No errors. |
| Bolt\Entity\Field\TemplateselectField | No errors. |
| Bolt\Entity\Field\TextField | No errors. |
| Bolt\Entity\Field\TextareaField | No errors. |
| Bolt\Entity\FieldTranslation | No errors. |