https://acc.primefinancedisputes.org/search?search=2025

Query Metrics

16 Database Queries
10 Different statements
65.03 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
58.91 ms
(90.59%)
1
SELECT b0_.id AS id_0, b1_.id AS id_1, b1_.name AS name_2, b1_.sortorder AS sortorder_3, b1_.version AS version_4, b1_.type AS type_5 FROM bolt_content b0_ INNER JOIN bolt_field b1_ ON b0_.id = b1_.content_id AND b1_.type IN ('generic', 'select', 'date', 'number', 'html', 'image', 'set', 'file', 'hidden', 'collection', 'checkbox', 'markdown', 'embed', 'data', 'filelist', 'textarea', 'templateselect', 'text', 'block', 'slug', 'imagelist', 'email', 'article', 'redactor') INNER JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id WHERE CAST(JSON_UNQUOTE(JSON_EXTRACT(b2_.value, '$[0]')) AS CHAR) LIKE ? ORDER BY b1_.sortorder ASC
Parameters:
[
  "%2025%"
]
1.82 ms
(2.80%)
7
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:
[
  251
]
1.00 ms
(1.54%)
1
update bolt_content SET status = 'published', published_at = :now  WHERE status = 'timed' AND published_at < :now
Parameters:
[
  ":now" => Carbon\Carbon {#1738
    __toString(): "2024-10-28 20:22:59"
  }
]
0.95 ms
(1.46%)
1
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', 'date', 'number', 'html', 'image', 'set', 'file', 'hidden', 'collection', 'checkbox', '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"
]
0.53 ms
(0.82%)
1
update bolt_content SET status = 'held', depublished_at = :now WHERE status = 'published' AND depublished_at < :now
Parameters:
[
  ":now" => Carbon\Carbon {#1738
    __toString(): "2024-10-28 20:22:59"
  }
]
0.44 ms
(0.67%)
1
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, modified_at_4 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, b0_.title AS title_7, b0_.list_format AS list_format_8, b1_.id AS id_9, b1_.display_name AS display_name_10, b1_.username AS username_11, b1_.email AS email_12, b1_.password AS password_13, b1_.roles AS roles_14, b1_.lastseen_at AS lastseen_at_15, b1_.last_ip AS last_ip_16, b1_.locale AS locale_17, b1_.backend_theme AS backend_theme_18, b1_.status AS status_19, b1_.avatar AS avatar_20, b1_.about AS about_21 FROM bolt_content b0_ LEFT JOIN bolt_user b1_ ON b0_.author_id = b1_.id WHERE b0_.status = ? AND b0_.content_type IN (?) AND b0_.id IN (?)) dctrn_result_inner ORDER BY modified_at_4 DESC) dctrn_result LIMIT 10
Parameters:
[
  "published"
  [
    "pages"
    "news"
    "judicial"
    "experts"
    "archive"
  ]
  [
    31
  ]
]
0.40 ms
(0.62%)
1
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.title AS title_14, t7.list_format AS list_format_15, t7.author_id AS author_id_16, t0.parent_id AS parent_id_17, 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', 'date', 'number', 'html', 'image', 'set', 'file', 'hidden', 'collection', 'checkbox', 'markdown', 'embed', 'data', 'filelist', 'textarea', 'templateselect', 'text', 'block', 'slug', 'imagelist', 'email', 'article', 'redactor')
Parameters:
[
  [
    31
  ]
]
0.34 ms
(0.52%)
1
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.title AS title_14, t7.list_format AS list_format_15, t7.author_id AS author_id_16, t0.parent_id AS parent_id_17, 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', 'date', 'number', 'html', 'image', 'set', 'file', 'hidden', 'collection', 'checkbox', 'markdown', 'embed', 'data', 'filelist', 'textarea', 'templateselect', 'text', 'block', 'slug', 'imagelist', 'email', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  31
]
0.33 ms
(0.50%)
1
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, b1_.id AS id_9, b1_.display_name AS display_name_10, b1_.username AS username_11, b1_.email AS email_12, b1_.password AS password_13, b1_.roles AS roles_14, b1_.lastseen_at AS lastseen_at_15, b1_.last_ip AS last_ip_16, b1_.locale AS locale_17, b1_.backend_theme AS backend_theme_18, b1_.status AS status_19, b1_.avatar AS avatar_20, b1_.about AS about_21, b0_.author_id AS author_id_22 FROM bolt_content b0_ LEFT JOIN bolt_user b1_ ON b0_.author_id = b1_.id WHERE b0_.status = ? AND b0_.content_type IN (?) AND b0_.id IN (?) AND b0_.id IN (?) ORDER BY b0_.modified_at DESC
Parameters:
[
  "published"
  [
    "pages"
    "news"
    "judicial"
    "experts"
    "archive"
  ]
  [
    31
  ]
  [
    31
  ]
]
0.30 ms
(0.47%)
1
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
  ]
]

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\DateField No errors.
Bolt\Entity\Field\NumberField 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\CheckboxField 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.
Bolt\Entity\UserAuthToken No errors.