https://bicdpb.sharelab.ma/

Query Metrics

10 Database Queries
9 Different statements
44.88 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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
    __toString(): "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
    __toString(): "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.