Query Metrics
3
Database Queries
3
Different statements
3.08 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.30 ms |
update bolt_content SET status = 'published', published_at = :now WHERE status = 'timed' AND published_at < :now
Parameters:
[ ":now" => Carbon\Carbon {#1738 : "2024-10-28 22:19:15" } ] |
2 | 0.71 ms |
update bolt_content SET status = 'held', depublished_at = :now WHERE status = 'published' AND depublished_at < :now
Parameters:
[ ":now" => Carbon\Carbon {#1738 : "2024-10-28 22:19:15" } ] |
3 | 1.07 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_ LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id AND b1_.type IN ('generic', 'select', 'checkbox', 'number', 'date', 'html', 'image', 'set', 'file', 'hidden', 'collection', 'markdown', 'embed', 'data', 'filelist', 'textarea', 'templateselect', 'text', 'block', 'slug', 'imagelist', 'email', 'article', 'redactor') LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id WHERE b0_.content_type = ? AND ((CAST(JSON_UNQUOTE(JSON_EXTRACT(b2_.value, '$[0]')) AS CHAR) = ? AND b1_.parent_id IS NULL AND b1_.name = ?) AND b0_.status = ?) ORDER BY b0_.published_at DESC LIMIT 1
Parameters:
[ "blocks" "search-teaser" "slug" "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.
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\FieldTranslation | No errors. |
Bolt\Entity\Field\SelectField | No errors. |
Bolt\Entity\Field\CheckboxField | No errors. |
Bolt\Entity\Field\NumberField | No errors. |
Bolt\Entity\Field\DateField | No errors. |
Bolt\Entity\Field\HtmlField | No errors. |
Bolt\Entity\Field\ImageField | No errors. |
Bolt\Entity\Field\SetField | No errors. |
Bolt\Entity\Field\FileField | No errors. |
Bolt\Entity\Field\HiddenField | No errors. |
Bolt\Entity\Field\CollectionField | No errors. |
Bolt\Entity\Field\MarkdownField | No errors. |
Bolt\Entity\Field\EmbedField | No errors. |
Bolt\Entity\Field\DataField | No errors. |
Bolt\Entity\Field\FilelistField | No errors. |
Bolt\Entity\Field\TextareaField | No errors. |
Bolt\Entity\Field\TemplateselectField | No errors. |
Bolt\Entity\Field\TextField | No errors. |
Bolt\Entity\Field\BlockField | No errors. |
Bolt\Entity\Field\SlugField | No errors. |
Bolt\Entity\Field\ImagelistField | No errors. |
Bolt\Entity\Field\EmailField | No errors. |
Bolt\Article\Entity\ArticleField | No errors. |
Bolt\Redactor\Entity\RedactorField | No errors. |