Query Metrics
99
Database Queries
26
Different statements
28.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.83 ms (16.87%) |
16 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.help AS help_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM bolt_catalog_attribute_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
5
]
|
|
4.36 ms (15.24%) |
19 |
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_catalog_attribute_value_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
51
]
|
|
3.85 ms (13.46%) |
16 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.model_name AS model_name_3, t0.description AS description_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM bolt_catalog_product_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
388
]
|
|
3.21 ms (11.21%) |
19 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.available_in_configurator AS available_in_configurator_3, t0.sort AS sort_4, t0.value_type AS value_type_5, t0.import_value AS import_value_6 FROM bolt_catalog_attribute t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
2.91 ms (10.19%) |
2 |
"COMMIT"
Parameters:
[] |
|
1.16 ms (4.04%) |
2 |
update bolt_content SET status = 'held', depublished_at = :now WHERE status = 'published' AND depublished_at < :now
Parameters:
[ ":now" => Carbon\Carbon {#3920 : "2026-10-03 05:20:53" } ] |
|
0.90 ms (3.15%) |
2 |
update bolt_content SET status = 'published', published_at = :now WHERE status = 'timed' AND published_at < :now
Parameters:
[ ":now" => Carbon\Carbon {#3920 : "2026-10-03 05:20:53" } ] |
|
0.74 ms (2.58%) |
2 |
SELECT COUNT(b0_.id) AS sclr_0 FROM bolt_catalog_configuration b0_ WHERE b0_.created_at >= ? AND b0_.created_at <= ?
Parameters:
[ "2026-10-01" "2026-10-31" ] |
|
0.63 ms (2.20%) |
1 |
SELECT b0_.element_type_id AS sclr_0 FROM bolt_catalog_color_variant b0_ INNER JOIN bolt_catalog_base_element_type b1_ ON b0_.element_type_id = b1_.id INNER JOIN bolt_catalog_product_base_element_type b3_ ON b1_.id = b3_.base_element_type_id INNER JOIN bolt_catalog_product b2_ ON b2_.id = b3_.product_id INNER JOIN bolt_catalog_colorable_element b4_ ON b0_.colorable_element_id = b4_.id WHERE b4_.product_id = ? AND b0_.element_type_id IS NOT NULL AND b2_.id = ? AND b0_.related_product_id IS NULL GROUP BY b0_.element_type_id
Parameters:
[ 388 388 ] |
|
0.59 ms (2.05%) |
2 |
SELECT b0_.id AS id_0, b0_.human_id AS human_id_1, b0_.session_id AS session_id_2, b0_.family_id AS family_id_3, b0_.draft AS draft_4, b0_.data AS data_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7, b0_.saved_at AS saved_at_8, b0_.product_id AS product_id_9, b0_.amount AS amount_10, b0_.deleted_at AS deleted_at_11, b0_.related_product_id AS related_product_id_12, b0_.unit_price AS unit_price_13 FROM bolt_catalog_configuration b0_ WHERE b0_.id = ? LIMIT 1
Parameters:
[
b"òû)›híB\e»ºË*WtŒ\x04"
]
|
|
0.56 ms (1.96%) |
2 |
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:
[
13
]
|
|
0.48 ms (1.69%) |
1 |
SELECT b0_.id AS id_0, b0_.human_id AS human_id_1, b0_.session_id AS session_id_2, b0_.family_id AS family_id_3, b0_.draft AS draft_4, b0_.data AS data_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7, b0_.saved_at AS saved_at_8, b0_.product_id AS product_id_9, b0_.amount AS amount_10, b0_.deleted_at AS deleted_at_11, b0_.related_product_id AS related_product_id_12, b0_.unit_price AS unit_price_13 FROM bolt_catalog_configuration b0_ WHERE b0_.deleted_at IS NULL AND b0_.session_id = ? AND b0_.draft = 1 AND b0_.family_id = ? ORDER BY b0_.created_at DESC LIMIT 1
Parameters:
[ "0df58b95465696109e3bdb2bbbfd86e7" 31 ] |
|
0.47 ms (1.65%) |
1 |
UPDATE bolt_catalog_configuration SET data = ?, updated_at = ? WHERE id = ?
Parameters:
[ "{"id":"f2fb299b-68ed-421b-bbba-cb2a57748c04","human_id":"26.30.1179","family_id":31,"product_id":388,"amount":1,"unit_price":0,"attributes":[],"color_variants":[],"draft":true}" "2026-10-03 07:20:53" b"òû)›híB\e»ºË*WtŒ\x04" ] |
|
0.44 ms (1.55%) |
1 |
SELECT t0.id AS id_1, t0.import_value AS import_value_2, t0.value AS value_3, t0.value_key AS value_key_4, t0.attribute_id AS attribute_id_5 FROM bolt_catalog_attribute_value t0 INNER JOIN bolt_catalog_product_attribute_value ON t0.id = bolt_catalog_product_attribute_value.attribute_value_id WHERE bolt_catalog_product_attribute_value.product_id = ?
Parameters:
[
388
]
|
|
0.41 ms (1.42%) |
1 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.import_value AS import_value_3, t0.bestseller AS bestseller_4, t0.image_id AS image_id_5, t0.main_category_id AS main_category_id_6, t0.main_product_id AS main_product_id_7 FROM bolt_catalog_family t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"szafy-gospodarcze-msau"
]
|
|
0.38 ms (1.33%) |
1 |
SELECT t0.id AS id_1, t0.sort AS sort_2, t0.family_id AS family_id_3, t0.category_id AS category_id_4 FROM bolt_catalog_family_category t0 WHERE t0.family_id = ?
Parameters:
[
31
]
|
|
0.36 ms (1.27%) |
1 |
SELECT b0_.id AS id_0, b0_.start_date AS start_date_1, b0_.end_date AS end_date_2, b0_.amount AS amount_3, b0_.with_related_products AS with_related_products_4, b0_.price AS price_5, b0_.product_id AS product_id_6 FROM bolt_catalog_discount b0_ WHERE b0_.product_id = ? AND ((b0_.start_date IS NULL OR b0_.start_date <= ?)) AND b0_.end_date > ? ORDER BY b0_.end_date ASC LIMIT 1
Parameters:
[ 388 "2026-10-03 07:20:53" "2026-10-03 07:20:53" ] |
|
0.35 ms (1.21%) |
1 |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.updated_at AS updated_at_3, t0.bolt_media_id AS bolt_media_id_4 FROM bolt_app_storage_media t0 WHERE t0.id = ?
Parameters:
[
54938
]
|
|
0.34 ms (1.18%) |
1 |
SELECT t0.id AS id_1, t0.price AS price_2, t0.code AS code_3, t0.slug AS slug_4, t0.configurable AS configurable_5, t0.active AS active_6, t0.deleted_at AS deleted_at_7, t0.images_updated_at AS images_updated_at_8, t0.family_id AS family_id_9, t0.image_id AS image_id_10 FROM bolt_catalog_product t0 WHERE t0.family_id = ?
Parameters:
[
31
]
|
|
0.31 ms (1.09%) |
1 |
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:
[
8
]
|
|
0.31 ms (1.08%) |
1 |
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:
[
31
]
|
|
0.27 ms (0.95%) |
2 |
"START TRANSACTION"
Parameters:
[] |
|
0.27 ms (0.93%) |
1 |
UPDATE bolt_catalog_configuration SET updated_at = ? WHERE id = ?
Parameters:
[ "2026-10-03 07:20:53" b"òû)›híB\e»ºË*WtŒ\x04" ] |
|
0.26 ms (0.90%) |
1 |
SELECT b0_.id AS id_0, b0_.import_value AS import_value_1, b0_.main AS main_2, b0_.sort AS sort_3 FROM bolt_catalog_base_element_type b0_ WHERE b0_.id IN (?) ORDER BY b0_.sort ASC
Parameters:
[
[
1
2
]
]
|
|
0.24 ms (0.83%) |
1 |
SELECT t0.id AS id_1, t0.price AS price_2, t0.code AS code_3, t0.slug AS slug_4, t0.configurable AS configurable_5, t0.active AS active_6, t0.deleted_at AS deleted_at_7, t0.images_updated_at AS images_updated_at_8, t0.family_id AS family_id_9, t0.image_id AS image_id_10 FROM bolt_catalog_product t0 WHERE t0.code IS NULL LIMIT 1
Parameters:
[] |
|
0.00 ms (0.00%) |
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, t0.type AS type_5 FROM bolt_catalog_certificate t0 INNER JOIN bolt_catalog_certificate_product ON t0.id = bolt_catalog_certificate_product.certificate_id WHERE bolt_catalog_certificate_product.product_id = ?
Parameters:
[
388
]
|
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. |
| App\Entity\Catalog\Product\Family | No errors. |
| App\Entity\Storage\Media | No errors. |
| App\Entity\Catalog\Product\Category | No errors. |
| App\Entity\Catalog\Product\Product | No errors. |
| App\Entity\Catalog\Product\FamilyCategory | No errors. |
| App\Entity\Catalog\Product\FamilyAttribute | No errors. |
| App\Entity\Catalog\Product\Attribute | No errors. |
| App\Entity\Catalog\Product\FamilyTranslation | No errors. |
| Bolt\Entity\Field | No errors. |
| App\Entity\Storage\MediaTranslation | No errors. |
| App\Entity\Catalog\Product\Color | No errors. |
| App\Entity\Catalog\Product\AttributeValue | No errors. |
| App\Entity\Catalog\Product\Discount | No errors. |
| App\Entity\Catalog\Product\ColorableElement | No errors. |
| App\Entity\Catalog\Product\RelatedProduct | No errors. |
| App\Entity\Catalog\Product\CategoryAttribute | No errors. |
| App\Entity\Catalog\Product\CategoryCategory | No errors. |
| App\Entity\Catalog\Product\CategoryTranslation | No errors. |
| App\Entity\Catalog\Product\Certificate | No errors. |
| App\Entity\Catalog\Product\ColorableElementType | No errors. |
| App\Entity\Catalog\Product\BaseElementType | No errors. |
| App\Entity\Catalog\Product\ProductTranslation | No errors. |
| App\Entity\Catalog\Configuration | No errors. |
| App\Entity\DistributorContact | No errors. |
| App\Entity\Catalog\Product\ColorVariant | No errors. |
| App\Entity\Catalog\Product\BaseElementTypeTranslation | No errors. |
| App\Entity\Catalog\Product\AttributeValueTranslation | No errors. |
| App\Entity\Catalog\Product\AttributeTranslation | No errors. |
| Bolt\Entity\UserAuthToken | No errors. |
| App\Entity\Catalog\Product\FamilyAttributeTranslation | No errors. |
| Bolt\Entity\FieldTranslation | No errors. |
| App\Entity\Catalog\Product\ColorTranslation | No errors. |
| App\Entity\Catalog\Product\BaseElement | No errors. |
| App\Entity\Catalog\Product\ColorableElementTranslation | No errors. |
| App\Entity\Catalog\Product\CategoryAttributeTranslation | No errors. |
| App\Entity\Catalog\Product\CertificateTranslation | No errors. |
| App\Entity\Catalog\Product\ColorableElementTypeTranslation | No errors. |
| App\Entity\Distributor | No errors. |