Query Metrics

14 Database Queries
3 Different statements
7.32 ms Query time
4 Invalid entities
16 Managed entities

Queries

Group similar statements

# Time Info
1 1.80 ms
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:
[
  17738
]
2 0.60 ms
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"
]
3 0.33 ms
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:
[
  "LANDLINE_PHONE"
]
4 0.40 ms
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:
[
  "MOBILE_PHONE"
]
5 0.37 ms
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:
[
  "FAX_PHONE"
]
6 0.44 ms
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:
[
  4947
]
7 0.54 ms
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:
[
  "INFO_DATE_FROM"
]
8 0.35 ms
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:
[
  "INFO_DATE_TO"
]
9 0.56 ms
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:
[
  "LANDLINE_PHONE"
]
10 0.42 ms
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:
[
  "MOBILE_PHONE"
]
11 0.41 ms
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"
]
12 0.34 ms
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:
[
  "INFO_TEXT"
]
13 0.40 ms
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:
[
  "INFO_COLOR_TEXT"
]
14 0.37 ms
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:
[
  "INFO_COLOR_BG"
]

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