https://www.bricappropiedades.cl/

Query Metrics

10 Database Queries
6 Different statements
5.77 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.08 ms
SELECT p0_.id AS id_0, p0_.titulo AS titulo_1, p0_.valor AS valor_2, p0_.numero_banios AS numero_banios_3, p0_.numero_dormitorios AS numero_dormitorios_4, t1_.tipo AS tipo_5 FROM propiedades p0_ INNER JOIN tipo_propiedad t1_ ON (p0_.id_tipoPropiedad = t1_.id) WHERE 1 = 1 AND p0_.propiedad_destacada = 1
Parameters:
[]
2 0.61 ms
SELECT p0_.id AS id_0, p0_.titulo AS titulo_1, p0_.valor AS valor_2, p0_.numero_banios AS numero_banios_3, p0_.numero_dormitorios AS numero_dormitorios_4, t1_.tipo AS tipo_5, p0_.uf AS uf_6 FROM propiedades p0_ INNER JOIN tipo_propiedad t1_ ON (p0_.id_tipoPropiedad = t1_.id) WHERE 1 = 1 AND p0_.propiedad_destacada = 1 LIMIT 6
Parameters:
[]
3 0.50 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.url AS url_3, t0.fecha_creacion AS fecha_creacion_4, t0.id_propiedad AS id_propiedad_5 FROM imagenes t0 WHERE t0.id_propiedad = ?
Parameters:
[
  2
]
4 0.46 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.url AS url_3, t0.fecha_creacion AS fecha_creacion_4, t0.id_propiedad AS id_propiedad_5 FROM imagenes t0 WHERE t0.id_propiedad = ?
Parameters:
[
  5
]
5 0.40 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.url AS url_3, t0.fecha_creacion AS fecha_creacion_4, t0.id_propiedad AS id_propiedad_5 FROM imagenes t0 WHERE t0.id_propiedad = ?
Parameters:
[
  7
]
6 0.53 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.url AS url_3, t0.fecha_creacion AS fecha_creacion_4, t0.id_propiedad AS id_propiedad_5 FROM imagenes t0 WHERE t0.id_propiedad = ?
Parameters:
[
  8
]
7 0.94 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.url AS url_3, t0.fecha_creacion AS fecha_creacion_4, t0.id_propiedad AS id_propiedad_5 FROM imagenes t0 WHERE t0.id_propiedad = ?
Parameters:
[
  35
]
8 0.44 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.orden AS orden_3 FROM regiones t0
Parameters:
[]
9 0.44 ms
SELECT t0.id AS id_1, t0.modalidad AS modalidad_2 FROM modalidad t0
Parameters:
[]
10 0.37 ms
SELECT t0.id AS id_1, t0.tipo AS tipo_2 FROM tipo_propiedad 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.

Entities Mapping

Class Mapping errors
App\Entity\Propiedades No errors.
App\Entity\TipoPropiedad No errors.
App\Entity\Imagenes No errors.
App\Entity\Regiones No errors.
App\Entity\Modalidad No errors.