GET https://autodiscover.donhuber.ch/fr/product

Query Metrics

20 Database Queries
4 Different statements
60.99 ms Query time
0 Invalid entities
62 Managed entities

Queries

Group similar statements

# Time Info
1 21.98 ms
SELECT p0_.id AS id_0, p0_.created AS created_1, p0_.updated AS updated_2, p0_.name AS name_3, p0_.alcohol_content AS alcohol_content_4, p0_.bottle_size AS bottle_size_5, p0_.image AS image_6, p0_.is_frontpage AS is_frontpage_7, p0_.slug AS slug_8, p0_.price AS price_9, p0_.status AS status_10, p0_.fact_sheet AS fact_sheet_11, p0_.factsheet_fr AS factsheet_fr_12, p0_.brand_id AS brand_id_13, p0_.country_id AS country_id_14, p0_.product_category_id AS product_category_id_15 FROM product p0_ ORDER BY p0_.id ASC
Parameters:
[]
2 4.00 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.packaging AS packaging_5, t0.is_good_for AS is_good_for_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?
Parameters:
[
  1
]
3 1.09 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.packaging AS packaging_5, t0.is_good_for AS is_good_for_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?
Parameters:
[
  2
]
4 4.17 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.packaging AS packaging_5, t0.is_good_for AS is_good_for_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?
Parameters:
[
  3
]
5 3.94 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.packaging AS packaging_5, t0.is_good_for AS is_good_for_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?
Parameters:
[
  4
]
6 0.74 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.packaging AS packaging_5, t0.is_good_for AS is_good_for_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?
Parameters:
[
  5
]
7 0.44 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.packaging AS packaging_5, t0.is_good_for AS is_good_for_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?
Parameters:
[
  6
]
8 0.52 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.packaging AS packaging_5, t0.is_good_for AS is_good_for_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?
Parameters:
[
  7
]
9 3.15 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.packaging AS packaging_5, t0.is_good_for AS is_good_for_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?
Parameters:
[
  8
]
10 2.91 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.packaging AS packaging_5, t0.is_good_for AS is_good_for_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?
Parameters:
[
  9
]
11 0.43 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.packaging AS packaging_5, t0.is_good_for AS is_good_for_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?
Parameters:
[
  10
]
12 0.29 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.packaging AS packaging_5, t0.is_good_for AS is_good_for_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?
Parameters:
[
  11
]
13 0.62 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.packaging AS packaging_5, t0.is_good_for AS is_good_for_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?
Parameters:
[
  12
]
14 2.19 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.packaging AS packaging_5, t0.is_good_for AS is_good_for_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?
Parameters:
[
  13
]
15 1.52 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.packaging AS packaging_5, t0.is_good_for AS is_good_for_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?
Parameters:
[
  14
]
16 0.54 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.packaging AS packaging_5, t0.is_good_for AS is_good_for_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?
Parameters:
[
  15
]
17 2.89 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.packaging AS packaging_5, t0.is_good_for AS is_good_for_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?
Parameters:
[
  16
]
18 8.20 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.packaging AS packaging_5, t0.is_good_for AS is_good_for_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?
Parameters:
[
  17
]
19 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product_category t0
Parameters:
[]
20 0.80 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.name AS name_4, t0.description AS description_5, t0.url AS url_6, t0.image AS image_7 FROM brand t0
Parameters:
[]

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\ProductTranslation 34
App\Entity\Product 17
App\Entity\ProductCategory 5
App\Entity\Brand 4
App\Entity\Country 2

Entities Mapping

Class Mapping errors
App\Entity\Product No errors.
App\Entity\Brand No errors.
App\Entity\Country No errors.
App\Entity\ProductCategory No errors.
App\Entity\Cocktail No errors.
App\Entity\ProductTranslation No errors.