Query Metrics
2
Database Queries
2
Different statements
1.53 ms
Query time
0
Invalid entities
19
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.75 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.is_visible AS is_visible_4, c0_.sort_order AS sort_order_5, c0_.created_at AS created_at_6 FROM category c0_ WHERE c0_.is_visible = ? ORDER BY c0_.name ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
| 2 | 0.79 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.price AS price_4, p0_.is_visible AS is_visible_5, p0_.cover_image AS cover_image_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, c1_.id AS id_9, c1_.name AS name_10, c1_.slug AS slug_11, c1_.description AS description_12, c1_.is_visible AS is_visible_13, c1_.sort_order AS sort_order_14, c1_.created_at AS created_at_15, p0_.category_id AS category_id_16 FROM product p0_ LEFT JOIN category c1_ ON p0_.category_id = c1_.id WHERE p0_.is_visible = ? ORDER BY c1_.name ASC, p0_.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\Product | 16 |
| App\Entity\Category | 3 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Category | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\ProductOptionGroup | No errors. |