Query Metrics
2
Database Queries
2
Different statements
2.09 ms
Query time
0
Invalid entities
8
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.63 ms |
SELECT p0_.id AS id_0, p0_.key_name AS key_name_1, p0_.name AS name_2, p0_.value AS value_3, p0_.sort AS sort_4, p0_.data AS data_5, p0_.product_id AS product_id_6 FROM product_info p0_ INNER JOIN products p1_ ON p0_.product_id = p1_.id WHERE p0_.id IN (SELECT p2_.id FROM product_info p2_ INNER JOIN products p3_ ON p2_.product_id = p3_.id WHERE p3_.id = ?) ORDER BY p0_.id DESC LIMIT 30
Parameters:
[
"29132"
]
|
| 2 | 0.46 ms |
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product_info p0_ INNER JOIN products p1_ ON p0_.product_id = p1_.id WHERE p0_.id IN (SELECT p2_.id FROM product_info p2_ INNER JOIN products p3_ ON p2_.product_id = p3_.id WHERE p3_.id = ?)
Parameters:
[
"29132"
]
|
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\ProductInfo | 7 |
| App\Entity\Products | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\ProductInfo | No errors. |
| App\Entity\Products | No errors. |