GET https://backend.rentparis.agence-otaku.fr/api/search-facets

Query Metrics

1 Database Queries
1 Different statements
9.62 ms Query time
1 Invalid entities
0 Managed entities

Grouped Statements

Show all queries

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
  • The field 'App\Entity\RealEstateSearchFacet#numvalue' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
App\Entity\SearchFacet No errors.
App\Entity\RealEstate No errors.