Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

41 Database Queries

10 Different statements

58.56 ms Query time

0 Invalid entities

Queries

Group similar statements


update bolt_content SET status = "published", published_at = :now  WHERE status = "timed" AND published_at < :now
update bolt_content SET status = "held", depublished_at = :now WHERE status = "published" AND depublished_at < :now
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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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
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, t0.parent_id AS parent_id_6, t0.type FROM bolt_field t0 WHERE t0.content_id = ? AND t0.type IN ('generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor') ORDER BY t0.sortorder ASC
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, t12.id AS id_13, t12.useragent AS useragent_14, t12.validity AS validity_15, t12.user_id AS user_id_16 FROM bolt_user t0 LEFT JOIN bolt_user_auth_token t12 ON t12.user_id = t0.id WHERE t0.id IN (?)
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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor') ORDER BY b0_.sortorder ASC
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 = ?
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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = ? LIMIT 1
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 = ?
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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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
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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = ? LIMIT 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_.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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = ? LIMIT 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_.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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = ? LIMIT 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_.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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = ? LIMIT 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_.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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = ? LIMIT 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, t0.parent_id AS parent_id_6, t0.type FROM bolt_field t0 WHERE t0.content_id = ? AND t0.type IN ('generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor') ORDER BY t0.sortorder ASC
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, t0.parent_id AS parent_id_6, t0.type FROM bolt_field t0 WHERE t0.id = ? AND t0.type IN ('generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor')
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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor') ORDER BY b0_.sortorder ASC
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 = ?
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 = ?
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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = ? LIMIT 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_.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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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
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, t0.parent_id AS parent_id_6, t0.type FROM bolt_field t0 WHERE t0.content_id = ? AND t0.type IN ('generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor') ORDER BY t0.sortorder ASC
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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor') ORDER BY b0_.sortorder ASC
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 = ?
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 = ?
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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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
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, t0.parent_id AS parent_id_6, t0.type FROM bolt_field t0 WHERE t0.content_id = ? AND t0.type IN ('generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor') ORDER BY t0.sortorder ASC
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, t12.id AS id_13, t12.useragent AS useragent_14, t12.validity AS validity_15, t12.user_id AS user_id_16 FROM bolt_user t0 LEFT JOIN bolt_user_auth_token t12 ON t12.user_id = t0.id WHERE t0.id IN (?)
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 = ?
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 = ?
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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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
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, t0.parent_id AS parent_id_6, t0.type FROM bolt_field t0 WHERE t0.content_id = ? AND t0.type IN ('generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor') ORDER BY t0.sortorder ASC
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 = ?
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 = ?
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 = ?
SELECT t0.id AS id_1, t0.location AS location_2, t0.path AS path_3, t0.filename AS filename_4, t0.type AS type_5, t0.width AS width_6, t0.height AS height_7, t0.filesize AS filesize_8, t0.crop_x AS crop_x_9, t0.crop_y AS crop_y_10, t0.crop_zoom AS crop_zoom_11, t0.created_at AS created_at_12, t0.modified_at AS modified_at_13, t0.title AS title_14, t0.description AS description_15, t0.original_filename AS original_filename_16, t0.copyright AS copyright_17, t0.author_id AS author_id_18 FROM bolt_media t0 WHERE t0.id = ? LIMIT 1
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 = ?
SELECT t0.id AS id_1, t0.location AS location_2, t0.path AS path_3, t0.filename AS filename_4, t0.type AS type_5, t0.width AS width_6, t0.height AS height_7, t0.filesize AS filesize_8, t0.crop_x AS crop_x_9, t0.crop_y AS crop_y_10, t0.crop_zoom AS crop_zoom_11, t0.created_at AS created_at_12, t0.modified_at AS modified_at_13, t0.title AS title_14, t0.description AS description_15, t0.original_filename AS original_filename_16, t0.copyright AS copyright_17, t0.author_id AS author_id_18 FROM bolt_media t0 WHERE t0.id = ? LIMIT 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_.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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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
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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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

#▲	Time	Info
1	0.69 ms	update bolt_content SET status = "published", published_at = :now WHERE status = "timed" AND published_at < :now Parameters: [`":now" => Carbon\Carbon {#1604 __toString(): "2024-11-21 07:56:16" }`] View formatted query View runnable query update bolt_content SET status = "published", published_at = :now WHERE status = "timed" AND published_at < :now update bolt_content SET status = "published", published_at = :now WHERE status = "timed" AND published_at < :now;
2	0.40 ms	update bolt_content SET status = "held", depublished_at = :now WHERE status = "published" AND depublished_at < :now Parameters: [`":now" => Carbon\Carbon {#1604 __toString(): "2024-11-21 07:56:16" }`] View formatted query View runnable query update bolt_content SET status = "held", depublished_at = :now WHERE status = "published" AND depublished_at < :now update bolt_content SET status = "held", depublished_at = :now WHERE status = "published" AND depublished_at < :now;
3	2.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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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: [`"cashr" "rayons"`] View formatted query View runnable query Explain query 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = 'cashr' AND b0_.content_type = 'rayons' LIMIT 1;
4	0.64 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, t0.parent_id AS parent_id_6, t0.type FROM bolt_field t0 WHERE t0.content_id = ? AND t0.type IN ('generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor') ORDER BY t0.sortorder ASC Parameters: [`35`] View formatted query View runnable query Explain query 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, t0.parent_id AS parent_id_6, t0.type FROM bolt_field t0 WHERE t0.content_id = ? AND t0.type IN ( 'generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor' ) ORDER BY t0.sortorder ASC 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, t0.parent_id AS parent_id_6, t0.type FROM bolt_field t0 WHERE t0.content_id = 35 AND t0.type IN ('generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor') ORDER BY t0.sortorder ASC;
5	0.60 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, t12.id AS id_13, t12.useragent AS useragent_14, t12.validity AS validity_15, t12.user_id AS user_id_16 FROM bolt_user t0 LEFT JOIN bolt_user_auth_token t12 ON t12.user_id = t0.id WHERE t0.id IN (?) Parameters: [`[ 2 ]`] View formatted query View runnable query Explain query 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, t12.id AS id_13, t12.useragent AS useragent_14, t12.validity AS validity_15, t12.user_id AS user_id_16 FROM bolt_user t0 LEFT JOIN bolt_user_auth_token t12 ON t12.user_id = t0.id WHERE t0.id IN (?) 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, t12.id AS id_13, t12.useragent AS useragent_14, t12.validity AS validity_15, t12.user_id AS user_id_16 FROM bolt_user t0 LEFT JOIN bolt_user_auth_token t12 ON t12.user_id = t0.id WHERE t0.id IN (2);
6	0.47 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor') ORDER BY b0_.sortorder ASC Parameters: [`876`] View formatted query View runnable query Explain query 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor' ) ORDER BY b0_.sortorder ASC 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 = 876) AND b0_.type IN ('generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor') ORDER BY b0_.sortorder ASC;
7	0.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: [`884`] View formatted query View runnable query Explain query 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 = ? 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 = 884;
8	0.82 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = ? LIMIT 1 Parameters: [`"cashr"`] View formatted query View runnable query Explain query 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = ? LIMIT 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_.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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = 'cashr' LIMIT 1;
9	0.24 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: [`880`] View formatted query View runnable query Explain query 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 = ? 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 = 880;
10	1.15 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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: [`"nos-rayons" "pages"`] View formatted query View runnable query Explain query 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = 'nos-rayons' AND b0_.content_type = 'pages' LIMIT 1;
11	0.88 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = ? LIMIT 1 Parameters: [`"epicerie"`] View formatted query View runnable query Explain query 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = ? LIMIT 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_.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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = 'epicerie' LIMIT 1;
12	0.76 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = ? LIMIT 1 Parameters: [`"charcuterie-cremerie"`] View formatted query View runnable query Explain query 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = ? LIMIT 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_.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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = 'charcuterie-cremerie' LIMIT 1;
13	0.95 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = ? LIMIT 1 Parameters: [`"produits-surgeles"`] View formatted query View runnable query Explain query 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = ? LIMIT 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_.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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = 'produits-surgeles' LIMIT 1;
14	1.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_ INNER JOIN bolt_field b1_ ON b0_.id = b1_.content_id AND b1_.type IN ('generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = ? LIMIT 1 Parameters: [`"produits-frais"`] View formatted query View runnable query Explain query 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = ? LIMIT 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_.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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = 'produits-frais' LIMIT 1;
15	0.60 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = ? LIMIT 1 Parameters: [`"boiss"`] View formatted query View runnable query Explain query 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = ? LIMIT 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_.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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = 'boiss' LIMIT 1;
16	5.27 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, t0.parent_id AS parent_id_6, t0.type FROM bolt_field t0 WHERE t0.content_id = ? AND t0.type IN ('generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor') ORDER BY t0.sortorder ASC Parameters: [`34`] View formatted query View runnable query Explain query 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, t0.parent_id AS parent_id_6, t0.type FROM bolt_field t0 WHERE t0.content_id = ? AND t0.type IN ( 'generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor' ) ORDER BY t0.sortorder ASC 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, t0.parent_id AS parent_id_6, t0.type FROM bolt_field t0 WHERE t0.content_id = 34 AND t0.type IN ('generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor') ORDER BY t0.sortorder ASC;
17	0.50 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, t0.parent_id AS parent_id_6, t0.type FROM bolt_field t0 WHERE t0.id = ? AND t0.type IN ('generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor') Parameters: [`866`] View formatted query View runnable query Explain query 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, t0.parent_id AS parent_id_6, t0.type FROM bolt_field t0 WHERE t0.id = ? AND t0.type IN ( 'generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor' ) 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, t0.parent_id AS parent_id_6, t0.type FROM bolt_field t0 WHERE t0.id = 866 AND t0.type IN ('generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor');
18	0.49 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor') ORDER BY b0_.sortorder ASC Parameters: [`866`] View formatted query View runnable query Explain query 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor' ) ORDER BY b0_.sortorder ASC 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 = 866) AND b0_.type IN ('generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor') ORDER BY b0_.sortorder ASC;
19	0.35 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: [`870`] View formatted query View runnable query Explain query 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 = ? 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 = 870;
20	0.38 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: [`874`] View formatted query View runnable query Explain query 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 = ? 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 = 874;
21	1.21 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = ? LIMIT 1 Parameters: [`"boucherie"`] View formatted query View runnable query Explain query 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = ? LIMIT 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_.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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = 'boucherie' LIMIT 1;
22	1.49 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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: [`"cave" "rayons"`] View formatted query View runnable query Explain query 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = 'cave' AND b0_.content_type = 'rayons' LIMIT 1;
23	14.85 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, t0.parent_id AS parent_id_6, t0.type FROM bolt_field t0 WHERE t0.content_id = ? AND t0.type IN ('generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor') ORDER BY t0.sortorder ASC Parameters: [`36`] View formatted query View runnable query Explain query 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, t0.parent_id AS parent_id_6, t0.type FROM bolt_field t0 WHERE t0.content_id = ? AND t0.type IN ( 'generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor' ) ORDER BY t0.sortorder ASC 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, t0.parent_id AS parent_id_6, t0.type FROM bolt_field t0 WHERE t0.content_id = 36 AND t0.type IN ('generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor') ORDER BY t0.sortorder ASC;
24	0.65 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor') ORDER BY b0_.sortorder ASC Parameters: [`891`] View formatted query View runnable query Explain query 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor' ) ORDER BY b0_.sortorder ASC 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 = 891) AND b0_.type IN ('generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor') ORDER BY b0_.sortorder ASC;
25	0.48 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: [`895`] View formatted query View runnable query Explain query 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 = ? 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 = 895;
26	0.46 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: [`899`] View formatted query View runnable query Explain query 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 = ? 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 = 899;
27	0.83 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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: [`"a-propos" "pages"`] View formatted query View runnable query Explain query 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = 'a-propos' AND b0_.content_type = 'pages' LIMIT 1;
28	0.55 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, t0.parent_id AS parent_id_6, t0.type FROM bolt_field t0 WHERE t0.content_id = ? AND t0.type IN ('generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor') ORDER BY t0.sortorder ASC Parameters: [`17`] View formatted query View runnable query Explain query 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, t0.parent_id AS parent_id_6, t0.type FROM bolt_field t0 WHERE t0.content_id = ? AND t0.type IN ( 'generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor' ) ORDER BY t0.sortorder ASC 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, t0.parent_id AS parent_id_6, t0.type FROM bolt_field t0 WHERE t0.content_id = 17 AND t0.type IN ('generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor') ORDER BY t0.sortorder ASC;
29	0.48 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, t12.id AS id_13, t12.useragent AS useragent_14, t12.validity AS validity_15, t12.user_id AS user_id_16 FROM bolt_user t0 LEFT JOIN bolt_user_auth_token t12 ON t12.user_id = t0.id WHERE t0.id IN (?) Parameters: [`[ 1 ]`] View formatted query View runnable query Explain query 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, t12.id AS id_13, t12.useragent AS useragent_14, t12.validity AS validity_15, t12.user_id AS user_id_16 FROM bolt_user t0 LEFT JOIN bolt_user_auth_token t12 ON t12.user_id = t0.id WHERE t0.id IN (?) 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, t12.id AS id_13, t12.useragent AS useragent_14, t12.validity AS validity_15, t12.user_id AS user_id_16 FROM bolt_user t0 LEFT JOIN bolt_user_auth_token t12 ON t12.user_id = t0.id WHERE t0.id IN (1);
30	0.39 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: [`99`] View formatted query View runnable query Explain query 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 = ? 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 = 99;
31	0.37 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: [`95`] View formatted query View runnable query Explain query 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 = ? 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 = 95;
32	0.77 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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: [`"contact" "pages"`] View formatted query View runnable query Explain query 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = 'contact' AND b0_.content_type = 'pages' LIMIT 1;
33	0.50 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, t0.parent_id AS parent_id_6, t0.type FROM bolt_field t0 WHERE t0.content_id = ? AND t0.type IN ('generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor') ORDER BY t0.sortorder ASC Parameters: [`5`] View formatted query View runnable query Explain query 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, t0.parent_id AS parent_id_6, t0.type FROM bolt_field t0 WHERE t0.content_id = ? AND t0.type IN ( 'generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor' ) ORDER BY t0.sortorder ASC 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, t0.parent_id AS parent_id_6, t0.type FROM bolt_field t0 WHERE t0.content_id = 5 AND t0.type IN ('generic', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', 'article', 'redactor') ORDER BY t0.sortorder ASC;
34	6.46 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: [`26`] View formatted query View runnable query Explain query 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 = ? 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 = 26;
35	0.59 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: [`22`] View formatted query View runnable query Explain query 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 = ? 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 = 22;
36	0.39 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: [`878`] View formatted query View runnable query Explain query 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 = ? 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 = 878;
37	0.52 ms	SELECT t0.id AS id_1, t0.location AS location_2, t0.path AS path_3, t0.filename AS filename_4, t0.type AS type_5, t0.width AS width_6, t0.height AS height_7, t0.filesize AS filesize_8, t0.crop_x AS crop_x_9, t0.crop_y AS crop_y_10, t0.crop_zoom AS crop_zoom_11, t0.created_at AS created_at_12, t0.modified_at AS modified_at_13, t0.title AS title_14, t0.description AS description_15, t0.original_filename AS original_filename_16, t0.copyright AS copyright_17, t0.author_id AS author_id_18 FROM bolt_media t0 WHERE t0.id = ? LIMIT 1 Parameters: [`55`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.location AS location_2, t0.path AS path_3, t0.filename AS filename_4, t0.type AS type_5, t0.width AS width_6, t0.height AS height_7, t0.filesize AS filesize_8, t0.crop_x AS crop_x_9, t0.crop_y AS crop_y_10, t0.crop_zoom AS crop_zoom_11, t0.created_at AS created_at_12, t0.modified_at AS modified_at_13, t0.title AS title_14, t0.description AS description_15, t0.original_filename AS original_filename_16, t0.copyright AS copyright_17, t0.author_id AS author_id_18 FROM bolt_media t0 WHERE t0.id = ? LIMIT 1 SELECT t0.id AS id_1, t0.location AS location_2, t0.path AS path_3, t0.filename AS filename_4, t0.type AS type_5, t0.width AS width_6, t0.height AS height_7, t0.filesize AS filesize_8, t0.crop_x AS crop_x_9, t0.crop_y AS crop_y_10, t0.crop_zoom AS crop_zoom_11, t0.created_at AS created_at_12, t0.modified_at AS modified_at_13, t0.title AS title_14, t0.description AS description_15, t0.original_filename AS original_filename_16, t0.copyright AS copyright_17, t0.author_id AS author_id_18 FROM bolt_media t0 WHERE t0.id = 55 LIMIT 1;
38	0.34 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: [`877`] View formatted query View runnable query Explain query 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 = ? 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 = 877;
39	0.33 ms	SELECT t0.id AS id_1, t0.location AS location_2, t0.path AS path_3, t0.filename AS filename_4, t0.type AS type_5, t0.width AS width_6, t0.height AS height_7, t0.filesize AS filesize_8, t0.crop_x AS crop_x_9, t0.crop_y AS crop_y_10, t0.crop_zoom AS crop_zoom_11, t0.created_at AS created_at_12, t0.modified_at AS modified_at_13, t0.title AS title_14, t0.description AS description_15, t0.original_filename AS original_filename_16, t0.copyright AS copyright_17, t0.author_id AS author_id_18 FROM bolt_media t0 WHERE t0.id = ? LIMIT 1 Parameters: [`54`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.location AS location_2, t0.path AS path_3, t0.filename AS filename_4, t0.type AS type_5, t0.width AS width_6, t0.height AS height_7, t0.filesize AS filesize_8, t0.crop_x AS crop_x_9, t0.crop_y AS crop_y_10, t0.crop_zoom AS crop_zoom_11, t0.created_at AS created_at_12, t0.modified_at AS modified_at_13, t0.title AS title_14, t0.description AS description_15, t0.original_filename AS original_filename_16, t0.copyright AS copyright_17, t0.author_id AS author_id_18 FROM bolt_media t0 WHERE t0.id = ? LIMIT 1 SELECT t0.id AS id_1, t0.location AS location_2, t0.path AS path_3, t0.filename AS filename_4, t0.type AS type_5, t0.width AS width_6, t0.height AS height_7, t0.filesize AS filesize_8, t0.crop_x AS crop_x_9, t0.crop_y AS crop_y_10, t0.crop_zoom AS crop_zoom_11, t0.created_at AS created_at_12, t0.modified_at AS modified_at_13, t0.title AS title_14, t0.description AS description_15, t0.original_filename AS original_filename_16, t0.copyright AS copyright_17, t0.author_id AS author_id_18 FROM bolt_media t0 WHERE t0.id = 54 LIMIT 1;
40	0.97 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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: [`"a-propos" "pages"`] View formatted query View runnable query Explain query 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = 'a-propos' AND b0_.content_type = 'pages' LIMIT 1;
41	7.15 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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: [`"contact" "pages"`] View formatted query View runnable query Explain query 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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 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', 'checkbox', 'number', 'file', 'email', 'data', 'set', 'select', 'date', 'textarea', 'embed', 'imagelist', 'templateselect', 'filelist', 'image', 'markdown', 'slug', 'hidden', 'text', 'block', 'collection', 'html', '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]') = 'contact' AND b0_.content_type = 'pages' LIMIT 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\Field\SlugField	No errors.
Bolt\Entity\FieldTranslation	No errors.
Bolt\Entity\Field\CheckboxField	No errors.
Bolt\Entity\Field\NumberField	No errors.
Bolt\Entity\Field\FileField	No errors.
Bolt\Entity\Field\EmailField	No errors.
Bolt\Entity\Field\DataField	No errors.
Bolt\Entity\Field\SetField	No errors.
Bolt\Entity\Field\SelectField	No errors.
Bolt\Entity\Field\DateField	No errors.
Bolt\Entity\Field\TextareaField	No errors.
Bolt\Entity\Field\EmbedField	No errors.
Bolt\Entity\Field\ImagelistField	No errors.
Bolt\Entity\Field\TemplateselectField	No errors.
Bolt\Entity\Field\FilelistField	No errors.
Bolt\Entity\Field\ImageField	No errors.
Bolt\Entity\Field\MarkdownField	No errors.
Bolt\Entity\Field\HiddenField	No errors.
Bolt\Entity\Field\TextField	No errors.
Bolt\Entity\Field\BlockField	No errors.
Bolt\Entity\Field\CollectionField	No errors.
Bolt\Entity\Field\HtmlField	No errors.
Bolt\Article\Entity\ArticleField	No errors.
Bolt\Redactor\Entity\RedactorField	No errors.
Bolt\Entity\UserAuthToken	No errors.

Symfony Profiler

https://primantilles.com/rayon/cashr

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping