https://cms-bolt.jumo.idp.lu/tags/humor

Query Metrics

67 Database Queries
12 Different statements
13.98 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.41 ms
update bolt_content SET status = 'published', published_at = :now  WHERE status = 'timed' AND published_at < :now
Parameters:
[
  ":now" => Carbon\Carbon {#1805
    __toString(): "2024-11-14 04:20:01"
  }
]
2 0.75 ms
update bolt_content SET status = 'held', depublished_at = :now WHERE status = 'published' AND depublished_at < :now
Parameters:
[
  ":now" => Carbon\Carbon {#1805
    __toString(): "2024-11-14 04:20:01"
  }
]
3 3.24 ms
SELECT DISTINCT id_0 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, b1_.id AS id_7, b1_.display_name AS display_name_8, b1_.username AS username_9, b1_.email AS email_10, b1_.password AS password_11, b1_.roles AS roles_12, b1_.lastseen_at AS lastseen_at_13, b1_.last_ip AS last_ip_14, b1_.locale AS locale_15, b1_.backend_theme AS backend_theme_16, b1_.status AS status_17, b1_.avatar AS avatar_18, b2_.id AS id_19, b2_.type AS type_20, b2_.slug AS slug_21, b2_.name AS name_22, b2_.sortorder AS sortorder_23 FROM bolt_content b0_ INNER JOIN bolt_user b1_ ON b0_.author_id = b1_.id INNER JOIN bolt_taxonomy_content b3_ ON b0_.id = b3_.content_id INNER JOIN bolt_taxonomy b2_ ON b2_.id = b3_.taxonomy_id WHERE b2_.type = ? AND b2_.slug = ? AND b0_.status = ?) dctrn_result LIMIT 6
Parameters:
[
  "tags"
  "humor"
  "published"
]
4 0.69 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, b1_.id AS id_7, b1_.display_name AS display_name_8, b1_.username AS username_9, b1_.email AS email_10, b1_.password AS password_11, b1_.roles AS roles_12, b1_.lastseen_at AS lastseen_at_13, b1_.last_ip AS last_ip_14, b1_.locale AS locale_15, b1_.backend_theme AS backend_theme_16, b1_.status AS status_17, b1_.avatar AS avatar_18, b2_.id AS id_19, b2_.type AS type_20, b2_.slug AS slug_21, b2_.name AS name_22, b2_.sortorder AS sortorder_23, b0_.author_id AS author_id_24 FROM bolt_content b0_ INNER JOIN bolt_user b1_ ON b0_.author_id = b1_.id INNER JOIN bolt_taxonomy_content b3_ ON b0_.id = b3_.content_id INNER JOIN bolt_taxonomy b2_ ON b2_.id = b3_.taxonomy_id WHERE b2_.type = ? AND b2_.slug = ? AND b0_.status = ? AND b0_.id IN (?)
Parameters:
[
  "tags"
  "humor"
  "published"
  [
    31
  ]
]
5 0.19 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, t0.parent_id AS parent_id_15, 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', 'embed', 'imagelist', 'slug', 'filelist', 'markdown', 'set', 'number', 'textarea', 'file', 'image', 'data', 'html', 'collection', 'email', 'block', 'date', 'text', 'checkbox', 'templateselect', 'hidden', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  31
]
6 0.15 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 = ?
Parameters:
[
  6
]
7 0.10 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:
[
  42
]
8 0.07 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:
[
  108
]
9 0.14 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:
[
  157
]
10 0.10 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:
[
  370
]
11 1.92 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 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, b1_.id AS id_7, b1_.display_name AS display_name_8, b1_.username AS username_9, b1_.email AS email_10, b1_.password AS password_11, b1_.roles AS roles_12, b1_.lastseen_at AS lastseen_at_13, b1_.last_ip AS last_ip_14, b1_.locale AS locale_15, b1_.backend_theme AS backend_theme_16, b1_.status AS status_17, b1_.avatar AS avatar_18, b2_.id AS id_19, b2_.type AS type_20, b2_.slug AS slug_21, b2_.name AS name_22, b2_.sortorder AS sortorder_23 FROM bolt_content b0_ INNER JOIN bolt_user b1_ ON b0_.author_id = b1_.id INNER JOIN bolt_taxonomy_content b3_ ON b0_.id = b3_.content_id INNER JOIN bolt_taxonomy b2_ ON b2_.id = b3_.taxonomy_id WHERE b2_.type = ? AND b2_.slug = ? AND b0_.status = ?) dctrn_result) dctrn_table
Parameters:
[
  "tags"
  "humor"
  "published"
]
12 0.12 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 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 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ? ORDER BY b0_.published_at DESC) dctrn_result) dctrn_table
Parameters:
[
  "pages"
  "published"
]
13 0.08 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_5 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 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ?) dctrn_result_inner ORDER BY published_at_5 DESC) dctrn_result LIMIT 3
Parameters:
[
  "pages"
  "published"
]
14 0.11 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_ WHERE b0_.content_type = ? AND b0_.status = ? AND b0_.id IN (?) ORDER BY b0_.published_at DESC
Parameters:
[
  "pages"
  "published"
  [
    4
    5
    9
  ]
]
15 0.10 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, t0.parent_id AS parent_id_15, 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', 'embed', 'imagelist', 'slug', 'filelist', 'markdown', 'set', 'number', 'textarea', 'file', 'image', 'data', 'html', 'collection', 'email', 'block', 'date', 'text', 'checkbox', 'templateselect', 'hidden', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  4
]
16 0.22 ms
SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.lastseen_at AS lastseen_at_7, t0.last_ip AS last_ip_8, t0.locale AS locale_9, t0.backend_theme AS backend_theme_10, t0.status AS status_11, t0.avatar AS avatar_12, t13.id AS id_14, t13.useragent AS useragent_15, t13.validity AS validity_16, t13.user_id AS user_id_17 FROM bolt_user t0 LEFT JOIN bolt_user_auth_token t13 ON t13.user_id = t0.id WHERE t0.id IN (?)
Parameters:
[
  [
    1
  ]
]
17 0.16 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, t0.parent_id AS parent_id_15, 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', 'embed', 'imagelist', 'slug', 'filelist', 'markdown', 'set', 'number', 'textarea', 'file', 'image', 'data', 'html', 'collection', 'email', 'block', 'date', 'text', 'checkbox', 'templateselect', 'hidden', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  5
]
18 0.18 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, t0.parent_id AS parent_id_15, 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', 'embed', 'imagelist', 'slug', 'filelist', 'markdown', 'set', 'number', 'textarea', 'file', 'image', 'data', 'html', 'collection', 'email', 'block', 'date', 'text', 'checkbox', 'templateselect', 'hidden', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  9
]
19 0.10 ms
SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.lastseen_at AS lastseen_at_7, t0.last_ip AS last_ip_8, t0.locale AS locale_9, t0.backend_theme AS backend_theme_10, t0.status AS status_11, t0.avatar AS avatar_12, t13.id AS id_14, t13.useragent AS useragent_15, t13.validity AS validity_16, t13.user_id AS user_id_17 FROM bolt_user t0 LEFT JOIN bolt_user_auth_token t13 ON t13.user_id = t0.id WHERE t0.id IN (?)
Parameters:
[
  [
    3
  ]
]
20 0.14 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:
[
  130
]
21 0.08 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:
[
  131
]
22 0.07 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:
[
  135
]
23 0.15 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 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 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ? ORDER BY b0_.published_at DESC) dctrn_result) dctrn_table
Parameters:
[
  "entries"
  "published"
]
24 0.07 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_5 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 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ?) dctrn_result_inner ORDER BY published_at_5 DESC) dctrn_result LIMIT 3
Parameters:
[
  "entries"
  "published"
]
25 0.11 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_ WHERE b0_.content_type = ? AND b0_.status = ? AND b0_.id IN (?) ORDER BY b0_.published_at DESC
Parameters:
[
  "entries"
  "published"
  [
    22
    25
    26
  ]
]
26 0.08 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, t0.parent_id AS parent_id_15, 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', 'embed', 'imagelist', 'slug', 'filelist', 'markdown', 'set', 'number', 'textarea', 'file', 'image', 'data', 'html', 'collection', 'email', 'block', 'date', 'text', 'checkbox', 'templateselect', 'hidden', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  22
]
27 0.09 ms
SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.lastseen_at AS lastseen_at_7, t0.last_ip AS last_ip_8, t0.locale AS locale_9, t0.backend_theme AS backend_theme_10, t0.status AS status_11, t0.avatar AS avatar_12, t13.id AS id_14, t13.useragent AS useragent_15, t13.validity AS validity_16, t13.user_id AS user_id_17 FROM bolt_user t0 LEFT JOIN bolt_user_auth_token t13 ON t13.user_id = t0.id WHERE t0.id IN (?)
Parameters:
[
  [
    2
  ]
]
28 0.07 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, t0.parent_id AS parent_id_15, 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', 'embed', 'imagelist', 'slug', 'filelist', 'markdown', 'set', 'number', 'textarea', 'file', 'image', 'data', 'html', 'collection', 'email', 'block', 'date', 'text', 'checkbox', 'templateselect', 'hidden', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  25
]
29 0.15 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, t0.parent_id AS parent_id_15, 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', 'embed', 'imagelist', 'slug', 'filelist', 'markdown', 'set', 'number', 'textarea', 'file', 'image', 'data', 'html', 'collection', 'email', 'block', 'date', 'text', 'checkbox', 'templateselect', 'hidden', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  26
]
30 0.07 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:
[
  148
]
31 0.07 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:
[
  151
]
32 0.07 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:
[
  152
]
33 0.14 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 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 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ? ORDER BY b0_.published_at DESC) dctrn_result) dctrn_table
Parameters:
[
  "people"
  "published"
]
34 0.07 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_5 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 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ?) dctrn_result_inner ORDER BY published_at_5 DESC) dctrn_result LIMIT 3
Parameters:
[
  "people"
  "published"
]
35 0.10 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_ WHERE b0_.content_type = ? AND b0_.status = ? AND b0_.id IN (?) ORDER BY b0_.published_at DESC
Parameters:
[
  "people"
  "published"
  [
    52
    55
    67
  ]
]
36 0.08 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, t0.parent_id AS parent_id_15, 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', 'embed', 'imagelist', 'slug', 'filelist', 'markdown', 'set', 'number', 'textarea', 'file', 'image', 'data', 'html', 'collection', 'email', 'block', 'date', 'text', 'checkbox', 'templateselect', 'hidden', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  52
]
37 0.09 ms
SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.lastseen_at AS lastseen_at_7, t0.last_ip AS last_ip_8, t0.locale AS locale_9, t0.backend_theme AS backend_theme_10, t0.status AS status_11, t0.avatar AS avatar_12, t13.id AS id_14, t13.useragent AS useragent_15, t13.validity AS validity_16, t13.user_id AS user_id_17 FROM bolt_user t0 LEFT JOIN bolt_user_auth_token t13 ON t13.user_id = t0.id WHERE t0.id IN (?)
Parameters:
[
  [
    5
  ]
]
38 0.08 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, t0.parent_id AS parent_id_15, 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', 'embed', 'imagelist', 'slug', 'filelist', 'markdown', 'set', 'number', 'textarea', 'file', 'image', 'data', 'html', 'collection', 'email', 'block', 'date', 'text', 'checkbox', 'templateselect', 'hidden', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  55
]
39 0.08 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, t0.parent_id AS parent_id_15, 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', 'embed', 'imagelist', 'slug', 'filelist', 'markdown', 'set', 'number', 'textarea', 'file', 'image', 'data', 'html', 'collection', 'email', 'block', 'date', 'text', 'checkbox', 'templateselect', 'hidden', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  67
]
40 0.08 ms
SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.lastseen_at AS lastseen_at_7, t0.last_ip AS last_ip_8, t0.locale AS locale_9, t0.backend_theme AS backend_theme_10, t0.status AS status_11, t0.avatar AS avatar_12, t13.id AS id_14, t13.useragent AS useragent_15, t13.validity AS validity_16, t13.user_id AS user_id_17 FROM bolt_user t0 LEFT JOIN bolt_user_auth_token t13 ON t13.user_id = t0.id WHERE t0.id IN (?)
Parameters:
[
  [
    4
  ]
]
41 0.14 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:
[
  178
]
42 0.07 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:
[
  181
]
43 0.08 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:
[
  193
]
44 0.07 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 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 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ? ORDER BY b0_.published_at DESC) dctrn_result) dctrn_table
Parameters:
[
  "products"
  "published"
]
45 0.06 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_5 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 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ?) dctrn_result_inner ORDER BY published_at_5 DESC) dctrn_result LIMIT 3
Parameters:
[
  "products"
  "published"
]
46 0.10 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_ WHERE b0_.content_type = ? AND b0_.status = ? AND b0_.id IN (?) ORDER BY b0_.published_at DESC
Parameters:
[
  "products"
  "published"
  [
    89
    100
    102
  ]
]
47 0.08 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, t0.parent_id AS parent_id_15, 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', 'embed', 'imagelist', 'slug', 'filelist', 'markdown', 'set', 'number', 'textarea', 'file', 'image', 'data', 'html', 'collection', 'email', 'block', 'date', 'text', 'checkbox', 'templateselect', 'hidden', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  89
]
48 0.08 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, t0.parent_id AS parent_id_15, 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', 'embed', 'imagelist', 'slug', 'filelist', 'markdown', 'set', 'number', 'textarea', 'file', 'image', 'data', 'html', 'collection', 'email', 'block', 'date', 'text', 'checkbox', 'templateselect', 'hidden', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  100
]
49 0.15 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, t0.parent_id AS parent_id_15, 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', 'embed', 'imagelist', 'slug', 'filelist', 'markdown', 'set', 'number', 'textarea', 'file', 'image', 'data', 'html', 'collection', 'email', 'block', 'date', 'text', 'checkbox', 'templateselect', 'hidden', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  102
]
50 0.09 ms
SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.lastseen_at AS lastseen_at_7, t0.last_ip AS last_ip_8, t0.locale AS locale_9, t0.backend_theme AS backend_theme_10, t0.status AS status_11, t0.avatar AS avatar_12, t13.id AS id_14, t13.useragent AS useragent_15, t13.validity AS validity_16, t13.user_id AS user_id_17 FROM bolt_user t0 LEFT JOIN bolt_user_auth_token t13 ON t13.user_id = t0.id WHERE t0.id IN (?)
Parameters:
[
  [
    7
  ]
]
51 0.07 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:
[
  215
]
52 0.07 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:
[
  226
]
53 0.08 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:
[
  228
]
54 0.07 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 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 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ? ORDER BY b0_.published_at DESC) dctrn_result) dctrn_table
Parameters:
[
  "news"
  "published"
]
55 0.06 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_5 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 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ?) dctrn_result_inner ORDER BY published_at_5 DESC) dctrn_result LIMIT 3
Parameters:
[
  "news"
  "published"
]
56 0.10 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_ WHERE b0_.content_type = ? AND b0_.status = ? AND b0_.id IN (?) ORDER BY b0_.published_at DESC
Parameters:
[
  "news"
  "published"
  [
    106
    105
    104
  ]
]
57 0.08 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, t0.parent_id AS parent_id_15, 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', 'embed', 'imagelist', 'slug', 'filelist', 'markdown', 'set', 'number', 'textarea', 'file', 'image', 'data', 'html', 'collection', 'email', 'block', 'date', 'text', 'checkbox', 'templateselect', 'hidden', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  106
]
58 0.07 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, t0.parent_id AS parent_id_15, 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', 'embed', 'imagelist', 'slug', 'filelist', 'markdown', 'set', 'number', 'textarea', 'file', 'image', 'data', 'html', 'collection', 'email', 'block', 'date', 'text', 'checkbox', 'templateselect', 'hidden', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  105
]
59 0.08 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, t0.parent_id AS parent_id_15, 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', 'embed', 'imagelist', 'slug', 'filelist', 'markdown', 'set', 'number', 'textarea', 'file', 'image', 'data', 'html', 'collection', 'email', 'block', 'date', 'text', 'checkbox', 'templateselect', 'hidden', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  104
]
60 0.10 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:
[
  702
]
61 0.07 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:
[
  697
]
62 0.06 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:
[
  693
]
63 0.08 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 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 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ? ORDER BY b0_.published_at DESC) dctrn_result) dctrn_table
Parameters:
[
  "jobs"
  "published"
]
64 0.06 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_5 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 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ?) dctrn_result_inner ORDER BY published_at_5 DESC) dctrn_result LIMIT 3
Parameters:
[
  "jobs"
  "published"
]
65 0.10 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_ WHERE b0_.content_type = ? AND b0_.status = ? AND b0_.id IN (?) ORDER BY b0_.published_at DESC
Parameters:
[
  "jobs"
  "published"
  [
    107
  ]
]
66 0.08 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, t0.parent_id AS parent_id_15, 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', 'embed', 'imagelist', 'slug', 'filelist', 'markdown', 'set', 'number', 'textarea', 'file', 'image', 'data', 'html', 'collection', 'email', 'block', 'date', 'text', 'checkbox', 'templateselect', 'hidden', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  107
]
67 0.08 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:
[
  707
]

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