GET http://dev.novaespacio.com/houses/8

Query Metrics

10 Database Queries
8 Different statements
7.57 ms Query time
0 Invalid entities
47 Managed entities

Queries

Group similar statements

# Time Info
1 0.52 ms
SELECT t0.id AS id_1, t0.modelo AS modelo_2, t0.area_construida AS area_construida_3, t0.descripcion AS descripcion_4, t0.area_total AS area_total_5, t0.nro_pisos AS nro_pisos_6, t0.nro_dormitorios AS nro_dormitorios_7, t0.nro_banos AS nro_banos_8, t0.nro_terrazas AS nro_terrazas_9, t0.nro_balcones AS nro_balcones_10, t0.titulo AS titulo_11, t0.descripcion_cool AS descripcion_cool_12, t0.codigo_modelo AS codigo_modelo_13, t0.views AS views_14, t0.condominio_principal_id AS condominio_principal_id_15 FROM proyecto_casa_modelo t0 WHERE t0.id = ?
Parameters:
[
  "8"
]
2 0.46 ms
SELECT t0.id AS id_1, t0.modelo AS modelo_2, t0.area_construida AS area_construida_3, t0.descripcion AS descripcion_4, t0.area_total AS area_total_5, t0.nro_pisos AS nro_pisos_6, t0.nro_dormitorios AS nro_dormitorios_7, t0.nro_banos AS nro_banos_8, t0.nro_terrazas AS nro_terrazas_9, t0.nro_balcones AS nro_balcones_10, t0.titulo AS titulo_11, t0.descripcion_cool AS descripcion_cool_12, t0.codigo_modelo AS codigo_modelo_13, t0.views AS views_14, t0.condominio_principal_id AS condominio_principal_id_15 FROM proyecto_casa_modelo t0
Parameters:
[]
3 1.14 ms
SELECT t0.id AS id_1, t0.titulo AS titulo_2, t0.archivo AS archivo_3, t0.tipo AS tipo_4, t0.orden AS orden_5, t0.seccion_web AS seccion_web_6, t0.grupo AS grupo_7, t0.casa_modelo_id AS casa_modelo_id_8 FROM proyecto_casa_modelo_archivo t0 WHERE t0.casa_modelo_id = ? ORDER BY t0.grupo ASC, t0.orden ASC
Parameters:
[
  8
]
4 0.97 ms
SELECT t0.id AS id_1, t0.nivel AS nivel_2, t0.titulo AS titulo_3, t0.nro_dormitorios AS nro_dormitorios_4, t0.area_total AS area_total_5, t0.nro_banos AS nro_banos_6, t0.nro_terrazas AS nro_terrazas_7, t0.nro_balcones AS nro_balcones_8, t0.descripcion AS descripcion_9, t0.imagen_planta AS imagen_planta_10, t0.casa_modelo_id AS casa_modelo_id_11 FROM proyecto_casa_modelo_piso t0 WHERE t0.casa_modelo_id = ?
Parameters:
[
  8
]
5 0.30 ms
SELECT p0_.id AS id_0, p0_.modelo AS modelo_1, p0_.area_construida AS area_construida_2, p0_.descripcion AS descripcion_3, p0_.area_total AS area_total_4, p0_.nro_pisos AS nro_pisos_5, p0_.nro_dormitorios AS nro_dormitorios_6, p0_.nro_banos AS nro_banos_7, p0_.nro_terrazas AS nro_terrazas_8, p0_.nro_balcones AS nro_balcones_9, p0_.titulo AS titulo_10, p0_.descripcion_cool AS descripcion_cool_11, p0_.codigo_modelo AS codigo_modelo_12, p0_.views AS views_13, p0_.condominio_principal_id AS condominio_principal_id_14 FROM proyecto_casa_modelo p0_
Parameters:
[]
6 0.42 ms
SELECT t0.id AS id_1, t0.condominio AS condominio_2, t0.nro_lotes AS nro_lotes_3, t0.direccion_google AS direccion_google_4, t0.long_lat_google AS long_lat_google_5, t0.codigo_condominio AS codigo_condominio_6, t0.desarrollador_id AS desarrollador_id_7 FROM proyecto_condominio t0 WHERE t0.id = ?
Parameters:
[
  3
]
7 0.56 ms
SELECT t0.id AS id_1, t0.condominio AS condominio_2, t0.nro_lotes AS nro_lotes_3, t0.direccion_google AS direccion_google_4, t0.long_lat_google AS long_lat_google_5, t0.codigo_condominio AS codigo_condominio_6, t0.desarrollador_id AS desarrollador_id_7 FROM proyecto_condominio t0 WHERE t0.id = ?
Parameters:
[
  1
]
8 1.21 ms
SELECT t0.id AS id_1, t0.condominio AS condominio_2, t0.nro_lotes AS nro_lotes_3, t0.direccion_google AS direccion_google_4, t0.long_lat_google AS long_lat_google_5, t0.codigo_condominio AS codigo_condominio_6, t0.desarrollador_id AS desarrollador_id_7 FROM proyecto_condominio t0 WHERE t0.id = ?
Parameters:
[
  5
]
9 0.44 ms
SELECT t0.id AS id_1, t0.modelo AS modelo_2, t0.area_construida AS area_construida_3, t0.descripcion AS descripcion_4, t0.area_total AS area_total_5, t0.nro_pisos AS nro_pisos_6, t0.nro_dormitorios AS nro_dormitorios_7, t0.nro_banos AS nro_banos_8, t0.nro_terrazas AS nro_terrazas_9, t0.nro_balcones AS nro_balcones_10, t0.titulo AS titulo_11, t0.descripcion_cool AS descripcion_cool_12, t0.codigo_modelo AS codigo_modelo_13, t0.views AS views_14, t0.condominio_principal_id AS condominio_principal_id_15 FROM proyecto_casa_modelo t0 ORDER BY t0.condominio_principal_id ASC, t0.area_total DESC
Parameters:
[]
10 1.56 ms
SELECT t0.id AS id_1, t0.condominio AS condominio_2, t0.nro_lotes AS nro_lotes_3, t0.direccion_google AS direccion_google_4, t0.long_lat_google AS long_lat_google_5, t0.codigo_condominio AS codigo_condominio_6, t0.desarrollador_id AS desarrollador_id_7 FROM proyecto_condominio t0 INNER JOIN proyecto_casa_modelo_proyecto_condominio ON t0.id = proyecto_casa_modelo_proyecto_condominio.proyecto_condominio_id WHERE proyecto_casa_modelo_proyecto_condominio.proyecto_casa_modelo_id = ?
Parameters:
[
  8
]

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\ProyectoCasaModeloArchivo 26
App\Entity\ProyectoCasaModelo 14
App\Entity\ProyectoCondominio 5
App\Entity\ProyectoCasaModeloPiso 1
App\Entity\ProyectoCondominioDesarrollador 1