GET http://dev.novaespacio.com/home/1

Query Metrics

5 Database Queries
5 Different statements
16.90 ms Query time
0 Invalid entities
136 Managed entities

Queries

Group similar statements

# Time Info
1 3.75 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
Parameters:
[]
2 6.66 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_ INNER JOIN proyecto_casa_modelo_proyecto_condominio p2_ ON p0_.id = p2_.proyecto_casa_modelo_id INNER JOIN proyecto_condominio p1_ ON p1_.id = p2_.proyecto_condominio_id WHERE p1_.id = ? ORDER BY CASE WHEN p0_.condominio_principal_id = ? THEN 0 ELSE 1 END ASC
Parameters:
[
  1
  1
]
3 4.22 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.seccion_web = ? ORDER BY t0.casa_modelo_id ASC, t0.grupo ASC, t0.orden ASC
Parameters:
[
  "thumbs"
]
4 0.90 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:
[]
5 1.37 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:
[]

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 114
App\Entity\ProyectoCasaModelo 14
App\Entity\ProyectoCondominio 7
App\Entity\ProyectoCondominioDesarrollador 1