Query Metrics
3
Database Queries
3
Different statements
1.73 ms
Query time
0
Invalid entities
3
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.71 ms (41.09%) |
1 |
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM prim_disability_subcategory_3 p0_ LEFT JOIN prim_disability_subcategory_3_detail p1_ ON p0_.id = p1_.subcategory_3_id LEFT JOIN prim_disability_subcategory_2 p2_ ON p0_.subcategory_2_id = p2_.id LEFT JOIN prim_disability_subcategory_2_detail p3_ ON p2_.id = p3_.subcategory_2_id LEFT JOIN prim_disability_subcategory_1 p4_ ON p2_.subcategory_1_id = p4_.id LEFT JOIN prim_disability_subcategory_1_detail p5_ ON p4_.id = p5_.subcategory_1_id LEFT JOIN prim_disability_category p6_ ON p4_.category_id = p6_.id LEFT JOIN prim_disability_category_detail p7_ ON p6_.id = p7_.category_id WHERE 1 = 1
Parameters:
[] |
|
0.55 ms (31.57%) |
1 |
SELECT DISTINCT p0_.id AS id_0 FROM prim_disability_subcategory_3 p0_ LEFT JOIN prim_disability_subcategory_3_detail p1_ ON p0_.id = p1_.subcategory_3_id LEFT JOIN prim_disability_subcategory_2 p2_ ON p0_.subcategory_2_id = p2_.id LEFT JOIN prim_disability_subcategory_2_detail p3_ ON p2_.id = p3_.subcategory_2_id LEFT JOIN prim_disability_subcategory_1 p4_ ON p2_.subcategory_1_id = p4_.id LEFT JOIN prim_disability_subcategory_1_detail p5_ ON p4_.id = p5_.subcategory_1_id LEFT JOIN prim_disability_category p6_ ON p4_.category_id = p6_.id LEFT JOIN prim_disability_category_detail p7_ ON p6_.id = p7_.category_id WHERE 1 = 1 LIMIT 15
Parameters:
[] |
|
0.47 ms (27.35%) |
1 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.slug AS slug_3 FROM prim_language t0
Parameters:
[] |
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\Language | 3 |