Query Metrics
1
Database Queries
1
Different statements
9.62 ms
Query time
1
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
9.62 ms (100.00%) |
1 |
SELECT s0_.label AS label_0, s0_.slug AS slug_1, s0_.type AS type_2, r1_.charvalue AS charvalue_3, r1_.numvalue AS numvalue_4, COUNT(DISTINCT r2_.id) AS sclr_5 FROM real_estate_search_facet r1_ INNER JOIN search_facet s0_ ON r1_.facet_id = s0_.id INNER JOIN real_estate r2_ ON r1_.real_estate_id = r2_.id WHERE s0_.active = true GROUP BY s0_.label, s0_.slug, r1_.charvalue, r1_.numvalue, s0_.order, s0_.type ORDER BY s0_.order ASC, r1_.numvalue ASC, r1_.charvalue ASC
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 |
|---|
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\RealEstateSearchFacet |
|
| App\Entity\SearchFacet | No errors. |
| App\Entity\RealEstate | No errors. |