Query Metrics
4
Database Queries
4
Different statements
1.07 ms
Query time
0
Invalid entities
13
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.34 ms (31.42%) |
1 |
SELECT t1.id AS id_2, t1.old_id AS old_id_3, t1.name AS name_4, t1.name_en AS name_en_5, t1.description AS description_6, t1.description_en AS description_en_7, t1.photo AS photo_8, t1.video AS video_9, t1.price AS price_10, t1.discount_percentage AS discount_percentage_11, t1.min_amount AS min_amount_12, t1.hit AS hit_13, t1.display AS display_14, t1.created_at AS created_at_15, t1.updated_at AS updated_at_16, t1.type FROM shop_item_tasting_set t0 INNER JOIN shop_item t1 ON t0.id = t1.id WHERE t1.display = ? ORDER BY t1.name ASC
Parameters:
[
1
]
|
|
0.29 ms (26.85%) |
1 |
SELECT s0_.id AS id_0, s0_.link AS link_1, s0_.title AS title_2, s0_.title_en AS title_en_3, s0_.description AS description_4, s0_.description_en AS description_en_5, s0_.keywords AS keywords_6, s0_.keywords_en AS keywords_en_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9 FROM static_meta s0_ WHERE s0_.link = '/collection/topping'
Parameters:
[] |
|
0.24 ms (21.99%) |
1 |
SELECT r0_.id AS id_0, r0_.link_from AS link_from_1, r0_.link_to AS link_to_2, r0_.code AS code_3, r0_.created_at AS created_at_4, r0_.updated_at AS updated_at_5 FROM redirect r0_ WHERE r0_.link_from = '/collection/topping'
Parameters:
[] |
|
0.21 ms (19.74%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.photo AS photo_4, t0.description AS description_5, t0.description_en AS description_en_6, t0.price AS price_7, t0.display AS display_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM shop_item_cake_topping t0 WHERE t0.display = ? ORDER BY t0.name ASC
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\ShopItemCakeTopping | 6 |
| App\Entity\ShopItemCakeCategory | 6 |
| App\Entity\ShopItem | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Redirect | No errors. |
| App\Entity\ShopItemTastingSet | No errors. |
| App\Entity\ShopItem | No errors. |
| App\Entity\ShopItemPhoto | No errors. |
| App\Entity\OrderShopItem | No errors. |
| App\Entity\OtherShopItem | No errors. |
| App\Entity\ShopItemCakeTopping | No errors. |
| App\Entity\ShopItemCakeCategory | No errors. |
| App\Entity\ShopCategory | No errors. |
| App\Entity\ShopItemCakeSubCategory | No errors. |
| App\Entity\StaticMeta | No errors. |
| App\Entity\ShopItemCake | No errors. |