Query Metrics
8
Database Queries
5
Different statements
22.49 ms
Query time
0
Invalid entities
29
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.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_.id AS id_13, p0_.created AS created_14, p0_.updated AS updated_15, p0_.name AS name_16, p0_.alcohol_content AS alcohol_content_17, p0_.bottle_size AS bottle_size_18, p0_.image AS image_19, p0_.is_frontpage AS is_frontpage_20, p0_.slug AS slug_21, p0_.price AS price_22, p0_.status AS status_23, p0_.fact_sheet AS fact_sheet_24, p0_.factsheet_fr AS factsheet_fr_25, p0_.brand_id AS brand_id_26, p0_.country_id AS country_id_27, p0_.product_category_id AS product_category_id_28 FROM product p0_ WHERE p0_.is_frontpage = ? ORDER BY p0_.id ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
| 2 | 3.53 ms |
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.updated AS updated_2, c0_.name AS name_3, c0_.image AS image_4, c0_.slug AS slug_5, c0_.is_frontpage AS is_frontpage_6, c0_.id AS id_7, c0_.created AS created_8, c0_.updated AS updated_9, c0_.name AS name_10, c0_.image AS image_11, c0_.slug AS slug_12, c0_.is_frontpage AS is_frontpage_13, c0_.product_id AS product_id_14 FROM cocktail c0_ WHERE c0_.is_frontpage = ? ORDER BY c0_.id ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
| 3 | 1.12 ms |
SELECT a0_.id AS id_0, a0_.created AS created_1, a0_.updated AS updated_2, a0_.title AS title_3, a0_.slug AS slug_4, a0_.description_de AS description_de_5, a0_.description_fr AS description_fr_6, a0_.image AS image_7, a0_.is_frontpage AS is_frontpage_8, a0_.id AS id_9, a0_.created AS created_10, a0_.updated AS updated_11, a0_.title AS title_12, a0_.slug AS slug_13, a0_.description_de AS description_de_14, a0_.description_fr AS description_fr_15, a0_.image AS image_16, a0_.is_frontpage AS is_frontpage_17 FROM album a0_ WHERE a0_.is_frontpage = ? ORDER BY a0_.id ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
| 4 | 3.00 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:
[]
|
||||||||||||||||||||||||||||||
| 5 | 3.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:
[
1
]
|
||||||||||||||||||||||||||||||
| 6 | 1.78 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
]
|
||||||||||||||||||||||||||||||
| 7 | 6.88 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
]
|
||||||||||||||||||||||||||||||
| 8 | 0.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:
[
4
]
|
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 | 8 |
| App\Entity\Product | 6 |
| App\Entity\Cocktail | 6 |
| App\Entity\Brand | 4 |
| App\Entity\ProductCategory | 3 |
| App\Entity\Country | 1 |
| App\Entity\Album | 1 |
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. |
| App\Entity\Album | No errors. |
| App\Entity\Media | No errors. |