Query Metrics

6 Database Queries
4 Different statements
1.55 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.66 ms
update bolt_content SET status = 'published', published_at = :now  WHERE status = 'timed' AND published_at < :now
Parameters:
[
  ":now" => Carbon\Carbon {#2538
    __toString(): "2024-07-04 01:41:10"
  }
]
2 0.24 ms
update bolt_content SET status = 'held', depublished_at = :now WHERE status = 'published' AND depublished_at < :now
Parameters:
[
  ":now" => Carbon\Carbon {#2538
    __toString(): "2024-07-04 01:41:10"
  }
]
3 0.10 ms
SELECT JSON_EXTRACT('{"jsonfunctionalitytest":["succes"]}', '$.jsonfunctionalitytest') as value
Parameters:
[]
4 0.27 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_ INNER JOIN bolt_field b1_ ON b0_.id = b1_.content_id AND b1_.type IN ('generic', 'select', 'hidden', 'filelist', 'textarea', 'data', 'number', 'checkbox', 'file', 'date', 'html', 'block', 'collection', 'slug', 'markdown', 'imagelist', 'image', 'embed', 'set', 'text', 'templateselect', 'email', 'article', 'redactor') INNER JOIN bolt_field b2_ ON (b1_.id = b2_.id) AND b2_.type IN ('slug') INNER JOIN bolt_field_translation b3_ ON b1_.id = b3_.translatable_id WHERE JSON_EXTRACT(b3_.value, '$[0]') = ? AND b0_.content_type = ? LIMIT 1
Parameters:
[
  "404-not-found"
  "blocks"
]
5 0.07 ms
SELECT JSON_EXTRACT('{"jsonfunctionalitytest":["succes"]}', '$.jsonfunctionalitytest') as value
Parameters:
[]
6 0.20 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_ INNER JOIN bolt_field b1_ ON b0_.id = b1_.content_id AND b1_.type IN ('generic', 'select', 'hidden', 'filelist', 'textarea', 'data', 'number', 'checkbox', 'file', 'date', 'html', 'block', 'collection', 'slug', 'markdown', 'imagelist', 'image', 'embed', 'set', 'text', 'templateselect', 'email', 'article', 'redactor') INNER JOIN bolt_field b2_ ON (b1_.id = b2_.id) AND b2_.type IN ('slug') INNER JOIN bolt_field_translation b3_ ON b1_.id = b3_.translatable_id WHERE JSON_EXTRACT(b3_.value, '$[0]') = ? AND b0_.content_type = ? LIMIT 1
Parameters:
[
  "page_404.html.twig"
  "helpers"
]

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\SlugField No errors.
Bolt\Entity\FieldTranslation No errors.
Bolt\Entity\Field\SelectField No errors.
Bolt\Entity\Field\HiddenField No errors.
Bolt\Entity\Field\FilelistField No errors.
Bolt\Entity\Field\TextareaField No errors.
Bolt\Entity\Field\DataField No errors.
Bolt\Entity\Field\NumberField No errors.
Bolt\Entity\Field\CheckboxField No errors.
Bolt\Entity\Field\FileField No errors.
Bolt\Entity\Field\DateField No errors.
Bolt\Entity\Field\HtmlField No errors.
Bolt\Entity\Field\BlockField No errors.
Bolt\Entity\Field\CollectionField No errors.
Bolt\Entity\Field\MarkdownField No errors.
Bolt\Entity\Field\ImagelistField No errors.
Bolt\Entity\Field\ImageField No errors.
Bolt\Entity\Field\EmbedField No errors.
Bolt\Entity\Field\SetField No errors.
Bolt\Entity\Field\TextField No errors.
Bolt\Entity\Field\TemplateselectField No errors.
Bolt\Entity\Field\EmailField No errors.
Bolt\Article\Entity\ArticleField No errors.
Bolt\Redactor\Entity\RedactorField No errors.
Bolt\Entity\UserAuthToken No errors.