Redirect 302 redirect from GET @homepage_product_factsheet_download (11c8f1)

GET https://autodiscover.donhuber.ch/fr/product/mari-mayans-ibz40-premiun-dry-gin

Query Metrics

12 Database Queries
8 Different statements
46.25 ms Query time
0 Invalid entities
28 Managed entities

Grouped Statements

Show all queries

Time Count Info
20.20 ms
(43.68%)
5
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
]
12.92 ms
(27.94%)
1
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_ WHERE p0_.id < ? ORDER BY p0_.id DESC LIMIT 1
Parameters:
[
  5
]
5.72 ms
(12.36%)
1
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_ WHERE p0_.id > ? ORDER BY p0_.id ASC LIMIT 1
Parameters:
[
  5
]
2.84 ms
(6.13%)
1
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_ INNER JOIN product_category p1_ ON p0_.product_category_id = p1_.id WHERE p1_.id = ? AND p0_.id <> ? ORDER BY p0_.id DESC LIMIT 4
Parameters:
[
  4
  5
]
1.96 ms
(4.24%)
1
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.name AS name_4, t0.alcohol_content AS alcohol_content_5, t0.bottle_size AS bottle_size_6, t0.image AS image_7, t0.is_frontpage AS is_frontpage_8, t0.slug AS slug_9, t0.price AS price_10, t0.status AS status_11, t0.fact_sheet AS fact_sheet_12, t0.factsheet_fr AS factsheet_fr_13, t0.brand_id AS brand_id_14, t0.country_id AS country_id_15, t0.product_category_id AS product_category_id_16 FROM product t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "mari-mayans-ibz40-premiun-dry-gin"
]
1.15 ms
(2.49%)
1
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.name AS name_4, t0.image AS image_5, t0.slug AS slug_6, t0.is_frontpage AS is_frontpage_7, t0.product_id AS product_id_8 FROM cocktail t0 WHERE t0.product_id = ?
Parameters:
[
  5
]
0.92 ms
(2.00%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM product_category t0 WHERE t0.id = ?
Parameters:
[
  4
]
0.53 ms
(1.15%)
1
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 WHERE t0.id = ?
Parameters:
[
  1
]

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 10
App\Entity\Product 6
App\Entity\Brand 4
App\Entity\Cocktail 4
App\Entity\Country 2
App\Entity\ProductCategory 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.
App\Entity\CocktailTranslation No errors.