Query Metrics
5
Database Queries
3
Different statements
10.02 ms
Query time
0
Invalid entities
5
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.50 ms |
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 | 1.03 ms |
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"
]
|
||||||||||||||||||||||||||||||||
| 3 | 3.31 ms |
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
]
|
||||||||||||||||||||||||||||||||
| 4 | 0.97 ms |
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
]
|
||||||||||||||||||||||||||||||||
| 5 | 2.21 ms |
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. |