Query Metrics
2
Database Queries
2
Different statements
0.73 ms
Query time
0
Invalid entities
5
Managed entities
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.position AS position_6, t0.level AS level_7, t0.need_customer_image AS need_customer_image_8, t0.is_gift_card_category AS is_gift_card_category_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.id = ?
Parameters:
[
37
]
|
||||||||||||||||||||||||||
2 | 0.33 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.short_description AS short_description_4, p0_.price AS price_5, p0_.is_gift_card AS is_gift_card_6 FROM product p0_ INNER JOIN category_product c2_ ON p0_.id = c2_.product_id INNER JOIN category c1_ ON c1_.id = c2_.category_id WHERE c1_.id = ? ORDER BY p0_.id DESC LIMIT 100
Parameters:
[
37
]
|
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\Product | 4 |
App\Entity\Category | 1 |
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Category | No errors. |
App\Entity\Product | No errors. |
App\Entity\Shop | No errors. |
App\Entity\ProductVisibility | No errors. |