http://malow.dev-stage.ovh/oferta/meble-warsztatowe

Query Metrics

157 Database Queries
23 Different statements
77.46 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
14.65 ms
(18.92%)
46
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:
[
  444
]
8.97 ms
(11.58%)
2
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_ LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id AND b1_.type IN ('generic', 'select', 'date', 'hidden', 'html', 'image', 'number', 'email', 'set', 'imagelist', 'templateselect', 'embed', 'data', 'filelist', 'block', 'slug', 'markdown', 'checkbox', 'text', 'collection', 'file', 'textarea', 'article', 'ckeditor', 'redactor') LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id WHERE b0_.content_type = ? AND ((CAST(JSON_UNQUOTE(JSON_EXTRACT(b2_.value, '$[0]')) AS CHAR) = ? AND b1_.parent_id IS NULL AND b1_.name = ?) AND b0_.status = ?) ORDER BY b0_.published_at DESC) dctrn_result) dctrn_table
Parameters:
[
  "blog"
  "true"
  "visible_pl"
  "published"
]
6.73 ms
(8.69%)
1
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, b1_.id AS id_7, b1_.value AS value_8, b1_.locale AS locale_9, b2_.id AS id_10, b2_.name AS name_11, b2_.sortorder AS sortorder_12, b2_.version AS version_13, b2_.type AS type_14 FROM bolt_content b0_ LEFT JOIN bolt_field b2_ ON b0_.id = b2_.content_id AND b2_.type IN ('generic', 'select', 'date', 'hidden', 'html', 'image', 'number', 'email', 'set', 'imagelist', 'templateselect', 'embed', 'data', 'filelist', 'block', 'slug', 'markdown', 'checkbox', 'text', 'collection', 'file', 'textarea', 'article', 'ckeditor', 'redactor') LEFT JOIN bolt_field_translation b1_ ON b2_.id = b1_.translatable_id WHERE b0_.content_type = ? AND ((CAST(JSON_UNQUOTE(JSON_EXTRACT(b1_.value, '$[0]')) AS CHAR) = ? AND b2_.parent_id IS NULL AND b2_.name = ?) AND b0_.status = ?) ORDER BY b2_.sortorder ASC) dctrn_result_inner ORDER BY published_at_5 DESC) dctrn_result LIMIT 1
Parameters:
[
  "blog"
  "true"
  "visible_pl"
  "published"
]
6.21 ms
(8.02%)
9
SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.author_id AS author_id_7 FROM bolt_content b0_ INNER JOIN bolt_field b1_ ON b0_.id = b1_.content_id AND b1_.type IN ('generic', 'select', 'date', 'hidden', 'html', 'image', 'number', 'email', 'set', 'imagelist', 'templateselect', 'embed', 'data', 'filelist', 'block', 'slug', 'markdown', 'checkbox', 'text', 'collection', 'file', 'textarea', 'article', 'ckeditor', '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 CAST(JSON_UNQUOTE(JSON_EXTRACT(b3_.value, '$[0]')) AS CHAR) = ? LIMIT 1
Parameters:
[
  "meble-warsztatowe"
]
5.73 ms
(7.40%)
25
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.bolt_media_id AS bolt_media_id_3 FROM bolt_app_storage_media t0 WHERE t0.id = ?
Parameters:
[
  56175
]
4.68 ms
(6.05%)
7
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', 'date', 'hidden', 'html', 'image', 'number', 'email', 'set', 'imagelist', 'templateselect', 'embed', 'data', 'filelist', 'block', 'slug', 'markdown', 'checkbox', 'text', 'collection', 'file', 'textarea', 'article', 'ckeditor', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
  10
]
4.18 ms
(5.40%)
12
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.sortorder AS sortorder_2, b0_.version AS version_3, b0_.type AS type_4, b0_.content_id AS content_id_5, b0_.parent_id AS parent_id_6 FROM bolt_field b0_ WHERE (b0_.parent_id = ?) AND b0_.type IN ('generic', 'select', 'date', 'hidden', 'html', 'image', 'number', 'email', 'set', 'imagelist', 'templateselect', 'embed', 'data', 'filelist', 'block', 'slug', 'markdown', 'checkbox', 'text', 'collection', 'file', 'textarea', 'article', 'ckeditor', 'redactor') ORDER BY b0_.sortorder ASC
Parameters:
[
  6915
]
4.06 ms
(5.24%)
14
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.image_id AS image_id_5, t0.translatable_id AS translatable_id_6 FROM bolt_catalog_certificate_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
3.53 ms
(4.55%)
11
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.id = ? AND t0.type IN ('generic', 'select', 'date', 'hidden', 'html', 'image', 'number', 'email', 'set', 'imagelist', 'templateselect', 'embed', 'data', 'filelist', 'block', 'slug', 'markdown', 'checkbox', 'text', 'collection', 'file', 'textarea', 'article', 'ckeditor', 'redactor')
Parameters:
[
  6918
]
2.73 ms
(3.53%)
2
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_ LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id AND b1_.type IN ('generic', 'select', 'date', 'hidden', 'html', 'image', 'number', 'email', 'set', 'imagelist', 'templateselect', 'embed', 'data', 'filelist', 'block', 'slug', 'markdown', 'checkbox', 'text', 'collection', 'file', 'textarea', 'article', 'ckeditor', 'redactor') LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id WHERE b0_.content_type = ? AND ((CAST(JSON_UNQUOTE(JSON_EXTRACT(b2_.value, '$[0]')) AS CHAR) = ? AND b1_.parent_id IS NULL AND b1_.name = ?) AND b0_.status = ?) AND b0_.id IN (?) ORDER BY b0_.published_at DESC
Parameters:
[
  "aktualnosci"
  "true"
  "visible_pl"
  "published"
  [
    316
    315
  ]
]
2.05 ms
(2.65%)
1
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, b1_.id AS id_7, b1_.value AS value_8, b1_.locale AS locale_9, b2_.id AS id_10, b2_.name AS name_11, b2_.sortorder AS sortorder_12, b2_.version AS version_13, b2_.type AS type_14 FROM bolt_content b0_ LEFT JOIN bolt_field b2_ ON b0_.id = b2_.content_id AND b2_.type IN ('generic', 'select', 'date', 'hidden', 'html', 'image', 'number', 'email', 'set', 'imagelist', 'templateselect', 'embed', 'data', 'filelist', 'block', 'slug', 'markdown', 'checkbox', 'text', 'collection', 'file', 'textarea', 'article', 'ckeditor', 'redactor') LEFT JOIN bolt_field_translation b1_ ON b2_.id = b1_.translatable_id WHERE b0_.content_type = ? AND ((CAST(JSON_UNQUOTE(JSON_EXTRACT(b1_.value, '$[0]')) AS CHAR) = ? AND b2_.parent_id IS NULL AND b2_.name = ?) AND b0_.status = ?) ORDER BY b2_.sortorder ASC) dctrn_result_inner ORDER BY published_at_5 DESC) dctrn_result LIMIT 2
Parameters:
[
  "aktualnosci"
  "true"
  "visible_pl"
  "published"
]
1.98 ms
(2.56%)
2
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:
[
  1
]
1.85 ms
(2.38%)
6
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM bolt_catalog_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  22
]
1.67 ms
(2.16%)
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', 'select', 'date', 'hidden', 'html', 'image', 'number', 'email', 'set', 'imagelist', 'templateselect', 'embed', 'data', 'filelist', 'block', 'slug', 'markdown', 'checkbox', 'text', 'collection', 'file', 'textarea', 'article', 'ckeditor', '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 CAST(JSON_UNQUOTE(JSON_EXTRACT(b3_.value, '$[0]')) AS CHAR) = ? AND b0_.content_type = ? LIMIT 1
Parameters:
[
  "meble-warsztatowe"
  "oferta"
]
1.52 ms
(1.96%)
4
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 = ? ORDER BY b0_.published_at DESC LIMIT 1
Parameters:
[
  "footer"
  "published"
]
1.26 ms
(1.62%)
1
SELECT b0_.id AS id_0, b0_.slug AS slug_1, b0_.import_value AS import_value_2, b0_.sort AS sort_3, b0_.image_id AS image_id_4, b0_.main_parent_id AS main_parent_id_5 FROM bolt_catalog_category b0_ INNER JOIN bolt_catalog_category_category b1_ ON b0_.id = b1_.child_id INNER JOIN bolt_catalog_category b2_ ON b1_.parent_id = b2_.id INNER JOIN bolt_catalog_family_category b3_ ON b0_.id = b3_.category_id INNER JOIN bolt_catalog_family b4_ ON b3_.family_id = b4_.id INNER JOIN bolt_catalog_product b5_ ON b4_.id = b5_.family_id WHERE b2_.slug = ? AND b5_.configurable = 1
Parameters:
[
  "meble-warsztatowe"
]
1.24 ms
(1.60%)
2
update bolt_content SET status = 'held', depublished_at = :now WHERE status = 'published' AND depublished_at < :now
Parameters:
[
  ":now" => Carbon\Carbon {#29474
    __toString(): "2026-01-14 12:54:04"
  }
]
1.16 ms
(1.50%)
4
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_catalog_family_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  41
]
1.01 ms
(1.31%)
1
SELECT b0_.id AS id_0, b0_.slug AS slug_1, b0_.import_value AS import_value_2, b1_.id AS id_3, b1_.sort AS sort_4, b2_.id AS id_5, b2_.slug AS slug_6, b2_.import_value AS import_value_7, b2_.sort AS sort_8, b0_.image_id AS image_id_9, b0_.main_category_id AS main_category_id_10, b0_.main_product_id AS main_product_id_11, b1_.family_id AS family_id_12, b1_.category_id AS category_id_13, b2_.image_id AS image_id_14, b2_.main_parent_id AS main_parent_id_15 FROM bolt_catalog_family b0_ INNER JOIN bolt_catalog_family_category b1_ ON b0_.id = b1_.family_id INNER JOIN bolt_catalog_category b2_ ON b1_.category_id = b2_.id INNER JOIN bolt_catalog_category_category b3_ ON b2_.id = b3_.child_id INNER JOIN bolt_catalog_category b4_ ON b3_.parent_id = b4_.id INNER JOIN bolt_catalog_product b5_ ON b0_.id = b5_.family_id WHERE b4_.slug = ? AND b5_.configurable = 1
Parameters:
[
  "meble-warsztatowe"
]
0.96 ms
(1.24%)
2
update bolt_content SET status = 'published', published_at = :now  WHERE status = 'timed' AND published_at < :now
Parameters:
[
  ":now" => Carbon\Carbon {#29474
    __toString(): "2026-01-14 12:54:04"
  }
]
0.68 ms
(0.88%)
2
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 FROM bolt_user t0 WHERE t0.id IN (?)
Parameters:
[
  [
    1
  ]
]
0.33 ms
(0.42%)
1
SELECT t0.id AS id_1, t0.import_value AS import_value_2, t0.sort AS sort_3, t0.show_on_product_page AS show_on_product_page_4 FROM bolt_catalog_certificate t0 WHERE t0.show_on_product_page = ?
Parameters:
[
  1
]
0.26 ms
(0.33%)
1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.import_value AS import_value_3, t0.sort AS sort_4, t0.image_id AS image_id_5, t0.main_parent_id AS main_parent_id_6 FROM bolt_catalog_category t0 WHERE t0.id = ?
Parameters:
[
  21
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
Bolt\Entity\Content No errors.
Bolt\Entity\Taxonomy No errors.
Bolt\Entity\Media No errors.
Bolt\Entity\Relation No errors.
Bolt\Entity\User No errors.
Bolt\Entity\Field No errors.
Bolt\Entity\Field\SlugField No errors.
Bolt\Entity\FieldTranslation No errors.
Bolt\Entity\Field\SelectField No errors.
Bolt\Entity\Field\DateField No errors.
Bolt\Entity\Field\HiddenField No errors.
Bolt\Entity\Field\HtmlField No errors.
Bolt\Entity\Field\ImageField No errors.
Bolt\Entity\Field\NumberField No errors.
Bolt\Entity\Field\EmailField No errors.
Bolt\Entity\Field\SetField No errors.
Bolt\Entity\Field\ImagelistField No errors.
Bolt\Entity\Field\TemplateselectField No errors.
Bolt\Entity\Field\EmbedField No errors.
Bolt\Entity\Field\DataField No errors.
Bolt\Entity\Field\FilelistField No errors.
Bolt\Entity\Field\BlockField No errors.
Bolt\Entity\Field\MarkdownField No errors.
Bolt\Entity\Field\CheckboxField No errors.
Bolt\Entity\Field\TextField No errors.
Bolt\Entity\Field\CollectionField No errors.
Bolt\Entity\Field\FileField No errors.
Bolt\Entity\Field\TextareaField No errors.
Bolt\Article\Entity\ArticleField No errors.
App\CKEditor\Entity\CkeditorField No errors.
Bolt\Redactor\Entity\RedactorField No errors.
Bolt\Entity\UserAuthToken No errors.
App\Entity\Catalog\Product\Category No errors.
App\Entity\Catalog\Product\CategoryCategory No errors.
App\Entity\Catalog\Product\FamilyCategory No errors.
App\Entity\Catalog\Product\Family No errors.
App\Entity\Catalog\Product\Product
  • The field App\Entity\Catalog\Product\Product#parentRelatedProducts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Catalog\Product\Product#relatedProducts does not contain the required 'inversedBy="parentRelatedProducts"' attribute.
  • The mappings App\Entity\Catalog\Product\Product#relatedParentProducts and App\Entity\Catalog\Product\RelatedProduct#products are inconsistent with each other.
App\Entity\Storage\Media No errors.
App\Entity\Catalog\Product\CategoryAttribute No errors.
App\Entity\Catalog\Product\CategoryTranslation No errors.
App\Entity\Catalog\Product\FamilyAttribute No errors.
App\Entity\Catalog\Product\FamilyTranslation No errors.
App\Entity\Catalog\Product\AttributeValue No errors.
App\Entity\Catalog\Product\ColorableElement No errors.
App\Entity\Catalog\Product\Certificate No errors.
App\Entity\Catalog\Product\ColorableElementType No errors.
App\Entity\Catalog\Product\RelatedProduct
  • The association App\Entity\Catalog\Product\RelatedProduct#products refers to the inverse side field App\Entity\Catalog\Product\Product#relatedProducts1 which does not exist.
App\Entity\Catalog\Product\Discount No errors.
App\Entity\Catalog\Product\ProductTranslation No errors.
App\Entity\Storage\MediaTranslation No errors.
App\Entity\Catalog\Product\CategoryAttributeTranslation No errors.
App\Entity\Catalog\Product\CertificateTranslation No errors.