https://bricappropiedades.cl/ventas

Query Metrics

9 Database Queries
4 Different statements
5.86 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.90 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) INNER JOIN modalidad m2_ ON (p0_.id_modalidad = m2_.id) LEFT JOIN regiones r3_ ON (p0_.id_region = r3_.id) LEFT JOIN comunas c4_ ON (p0_.id_comuna = c4_.id) WHERE 1 = 1 AND m2_.id = ?
Parameters:
[
  3
]
2 1.17 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) INNER JOIN modalidad m2_ ON (p0_.id_modalidad = m2_.id) LEFT JOIN regiones r3_ ON (p0_.id_region = r3_.id) LEFT JOIN comunas c4_ ON (p0_.id_comuna = c4_.id) WHERE 1 = 1 AND m2_.id = ? LIMIT 6
Parameters:
[
  3
]
3 1.04 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:
[
  13
]
4 0.60 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:
[
  14
]
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:
[
  16
]
6 0.55 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:
[
  21
]
7 0.45 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:
[
  23
]
8 0.44 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:
[
  24
]
9 0.30 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.orden AS orden_3 FROM regiones 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\Modalidad No errors.
App\Entity\Regiones No errors.
App\Entity\Comunas No errors.
App\Entity\Imagenes No errors.