Query Metrics

16 Database Queries
5 Different statements
8.64 ms Query time
5 Invalid entities
131 Managed entities

Grouped Statements

Show all queries

Time Count Info
4.15 ms
(47.97%)
12
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.display_name AS display_name_4 FROM settings t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
  "EMAIL"
]
1.38 ms
(16.03%)
1
SELECT t0.id AS id_1, t0.variant_code AS variant_code_2, t0.size AS size_3, t0.system_magazine AS system_magazine_4, t0.own_magazine AS own_magazine_5, t0.delivery_magazine AS delivery_magazine_6, t0.delivery_magazine_date AS delivery_magazine_date_7, t0.color_hex AS color_hex_8, t0.url AS url_9, t0.in_week_magazine AS in_week_magazine_10, t0.material AS material_11, t0.delivery_magazine_label AS delivery_magazine_label_12, t0.product_id AS product_id_13, t0.variant_color_id AS variant_color_id_14, t0.main_image_id AS main_image_id_15 FROM product_variant t0 WHERE t0.id = ?
Parameters:
[
  24005
]
1.38 ms
(15.98%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.seo_title AS seo_title_4, t0.seo_description AS seo_description_5, t0.left_side AS left_side_6, t0.right_side AS right_side_7, t0.level AS level_8, t0.active AS active_9, t0.url AS url_10, t0.visible_in_horizontal_menu AS visible_in_horizontal_menu_11, t0.visible_in_footer AS visible_in_footer_12, t0.short_description AS short_description_13, t0.parent_id AS parent_id_14, t0.price_factor_id AS price_factor_id_15 FROM category t0 WHERE t0.active = ? ORDER BY t0.left_side ASC
Parameters:
[
  1
]
1.30 ms
(15.01%)
1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.seo_title AS seo_title_3, c0_.seo_description AS seo_description_4, c0_.left_side AS left_side_5, c0_.right_side AS right_side_6, c0_.level AS level_7, c0_.active AS active_8, c0_.url AS url_9, c0_.visible_in_horizontal_menu AS visible_in_horizontal_menu_10, c0_.visible_in_footer AS visible_in_footer_11, c0_.short_description AS short_description_12, c0_.parent_id AS parent_id_13, c0_.price_factor_id AS price_factor_id_14 FROM category c0_ WHERE c0_.level >= 1 AND c0_.level <= 3 AND c0_.active = 1 AND c0_.visible_in_horizontal_menu = 1 ORDER BY c0_.left_side ASC
Parameters:
[]
0.43 ms
(5.01%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_code AS product_code_3, t0.description AS description_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.url AS url_7, t0.weight AS weight_8, t0.min_amount AS min_amount_9, t0.price_netto AS price_netto_10, t0.vat AS vat_11, t0.promotional_price AS promotional_price_12, t0.homepage AS homepage_13, t0.recommended AS recommended_14, t0.new AS new_15, t0.active AS active_16, t0.calculator AS calculator_17, t0.supplier_product_id AS supplier_product_id_18, t0.bestseller AS bestseller_19, t0.final_price AS final_price_20, t0.is_visible_in_uncategorized AS is_visible_in_uncategorized_21, t0.supplier_id AS supplier_id_22, t0.main_category_id AS main_category_id_23, t0.price_factor_id AS price_factor_id_24, t0.handling_cost_id AS handling_cost_id_25, t0.main_product_variant_file_id AS main_product_variant_file_id_26, t0.canonical_variant_id AS canonical_variant_id_27 FROM product t0 WHERE t0.id = ?
Parameters:
[
  13217
]

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\Category 115
App\Entity\Settings 9
App\Entity\ProductVariant 1
App\Entity\Product 1
App\Entity\ProductColor 1
App\Entity\Supplier 1
App\Entity\MarkingPriceListHandlingCost 1
App\Entity\ProductVariantFile 1
App\Entity\PriceFactor 1

Entities Mapping

Class Mapping errors
App\Entity\ProductVariant No errors.
App\Entity\Product
  • The field 'App\Entity\Product#finalPrice' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The association App\Entity\Product#supplier refers to the inverse side field App\Entity\Supplier#products which does not exist.
App\Entity\ProductColor No errors.
App\Entity\ProductVariantFile No errors.
App\Entity\Settings No errors.
App\Entity\Supplier No errors.
App\Entity\Category No errors.
App\Entity\PriceFactor No errors.
App\Entity\MarkingPriceListHandlingCost
  • The association App\Entity\MarkingPriceListHandlingCost#supplier refers to the inverse side field App\Entity\Supplier#markingPriceListHandlingCosts which does not exist.
App\Entity\ProductLocations No errors.
App\Entity\PriceLog No errors.
App\Entity\Reviews No errors.
App\Entity\File No errors.
App\Entity\MarkingPriceList
  • The association App\Entity\MarkingPriceList#supplier refers to the inverse side field App\Entity\Supplier#markingPriceLists which does not exist.
App\Entity\PriceFactorItem No errors.
App\Entity\ProductLocationsTechnique
  • The association App\Entity\ProductLocationsTechnique#technique refers to the inverse side field App\Entity\MarkingTechnique#productLocationsTechniques which does not exist.
App\Entity\ProductLocationFile No errors.
App\Entity\MarkingPriceListType No errors.
App\Entity\MarkingTechnique
  • The association App\Entity\MarkingTechnique#supplier refers to the inverse side field App\Entity\Supplier#markingTechniques which does not exist.
App\Entity\MarkingPriceListCost No errors.
App\Entity\MarkingPriceListExtraCost No errors.
App\Entity\MarkingDescription No errors.