GET https://advent.cheezpa.fr/produit/calendrier-avent-noel

Query Metrics

5 Database Queries
3 Different statements
10.02 ms Query time
0 Invalid entities
5 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
4.28 ms
(42.70%)
2
SELECT p0_.id AS id_0, p0_.label AS label_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.age_min AS age_min_4, p0_.age_max AS age_max_5, p0_.price_cents AS price_cents_6, p0_.pdf_filename AS pdf_filename_7, p0_.pdf_original_name AS pdf_original_name_8, p0_.is_active AS is_active_9, p0_.position AS position_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.product_id AS product_id_13 FROM product_variant p0_ WHERE p0_.product_id = ? AND p0_.is_active = 1 AND p0_.pdf_filename IS NOT NULL ORDER BY p0_.position ASC
Parameters:
[
  3
]
3.53 ms
(35.19%)
2
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.theme AS theme_3, p0_.tagline AS tagline_4, p0_.description AS description_5, p0_.seo_title AS seo_title_6, p0_.seo_description AS seo_description_7, p0_.is_active AS is_active_8, p0_.position AS position_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11 FROM product p0_ WHERE p0_.slug = ? AND p0_.is_active = 1
Parameters:
[
  "calendrier-avent-noel"
]
2.21 ms
(22.11%)
1
SELECT t0.id AS id_1, t0.label AS label_2, t0.start_month AS start_month_3, t0.start_day AS start_day_4, t0.end_month AS end_month_5, t0.end_day AS end_day_6, t0.discount_type AS discount_type_7, t0.discount_value AS discount_value_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10, t0.product_id AS product_id_11 FROM promotion_period t0 WHERE t0.product_id = ?
Parameters:
[
  3
]

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\ProductVariant 3
App\Entity\Product 1
App\Entity\PromotionPeriod 1

Entities Mapping

Class Mapping errors
App\Entity\Product No errors.
App\Entity\ProductVariant No errors.
App\Entity\PromotionPeriod No errors.