GET https://gelbeeimershop.com/products/metylan-tg-power-granulat

Query Metrics

19 Database Queries
12 Different statements
17.12 ms Query time
4 Invalid entities
20 Managed entities

Queries

Group similar statements

# Time Info
1 2.77 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.description AS description_4, t0.price AS price_5, t0.slug AS slug_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9 FROM products t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "metylan-tg-power-granulat"
]
2 2.20 ms
SELECT t0.id AS id_1, t0.ref AS ref_2, t0.description AS description_3, t0.color_class AS color_class_4, t0.r_color AS r_color_5, t0.g_color AS g_color_6, t0.b_color AS b_color_7, t0.y AS y_8, t0.l AS l_9, t0.a AS a_10, t0.b AS b_11, t0.c AS c_12, t0.h AS h_13, t0.cmy_c AS cmy_c_14, t0.cmy_m AS cmy_m_15, t0.cmy_y AS cmy_y_16, t0.cmyk_c AS cmyk_c_17, t0.cmyk_m AS cmyk_m_18, t0.cmyk_y AS cmyk_y_19, t0.cmyk_k AS cmyk_k_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.deleted_at AS deleted_at_23, t0.color_catalogue_id AS color_catalogue_id_24 FROM colors t0 WHERE t0.id IS NULL LIMIT 1
Parameters:
[]
3 0.22 ms
"START TRANSACTION"
Parameters:
[]
4 0.37 ms
INSERT INTO carts (session_id, type, created_at, updated_at, deleted_at, customer_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[
  "40pfhpj81laajjb0d5rgk61jku"
  "wishlist"
  "2025-07-19 13:05:24"
  "2025-07-19 13:05:24"
  null
  null
]
5 0.66 ms
"COMMIT"
Parameters:
[]
6 0.25 ms
"START TRANSACTION"
Parameters:
[]
7 0.34 ms
INSERT INTO carts (session_id, type, created_at, updated_at, deleted_at, customer_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[
  "40pfhpj81laajjb0d5rgk61jku"
  "cart"
  "2025-07-19 13:05:24"
  "2025-07-19 13:05:24"
  null
  null
]
8 0.48 ms
"COMMIT"
Parameters:
[]
9 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.thumbnail AS thumbnail_4, t0.featured AS featured_5, t0.product_id AS product_id_6 FROM product_images t0 WHERE t0.product_id = ?
Parameters:
[
  897
]
10 5.68 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.metadata AS metadata_3, t0.price_adjustment AS price_adjustment_4, t0.product_id AS product_id_5, t0.option_id AS option_id_6 FROM product_option_values t0 WHERE t0.product_id = ?
Parameters:
[
  897
]
11 0.40 ms
SELECT t0.id AS id_1, t0.`key` AS key_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6 FROM `configurations` t0 WHERE t0.`key` = ? LIMIT 1
Parameters:
[
  "default_currency"
]
12 1.72 ms
SELECT t0.code AS code_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.format AS format_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9 FROM currencies t0 WHERE t0.code = ? AND t0.is_active = ? LIMIT 1
Parameters:
[
  "EUR"
  1
]
13 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.options AS options_4 FROM product_options t0 WHERE t0.id = ?
Parameters:
[
  4
]
14 0.27 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.attribute_id AS attribute_id_4 FROM product_attribute_values t0 WHERE t0.product_id = ?
Parameters:
[
  897
]
15 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM product_attributes t0 WHERE t0.id = ?
Parameters:
[
  22
]
16 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM product_attributes t0 WHERE t0.id = ?
Parameters:
[
  23
]
17 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM product_attributes t0 WHERE t0.id = ?
Parameters:
[
  25
]
18 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM product_attributes t0 WHERE t0.id = ?
Parameters:
[
  26
]
19 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM product_attributes 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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\ProductAttributeValue 5
App\Entity\ProductAttribute 5
App\Entity\ProductOptionValue 3
App\Entity\Cart 2
App\Entity\Product 1
App\Entity\ProductImage 1
App\Entity\ProductOption 1
App\Entity\Configuration 1
App\Entity\Currency 1

Entities Mapping

Class Mapping errors
App\Entity\Product No errors.
App\Entity\ProductAttributeValue
  • The mappings App\Entity\ProductAttributeValue#attribute and App\Entity\ProductAttribute#values are inconsistent with each other.
App\Entity\ProductOptionValue
  • The mappings App\Entity\ProductOptionValue#option and App\Entity\ProductOption#values are inconsistent with each other.
App\Entity\ProductImage No errors.
App\Entity\ProductCategory No errors.
App\Entity\ProductTag No errors.
App\Entity\Color No errors.
App\Entity\ColorCatalogue No errors.
App\Entity\Cart No errors.
App\Entity\CartItem No errors.
App\Entity\Address No errors.
App\Entity\Customer No errors.
App\Entity\ProductOption
  • The association App\Entity\ProductOption#values refers to the owning side field App\Entity\ProductOptionValue#productOption which does not exist.
App\Entity\Configuration No errors.
App\Entity\Currency No errors.
App\Entity\ProductAttribute
  • The association App\Entity\ProductAttribute#values refers to the owning side field App\Entity\ProductAttributeValue#productAttribute which does not exist.