Query Metrics
1
Database Queries
1
Different statements
0.90 ms
Query time
0
Invalid entities
315
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.90 ms (100.00%) |
1 |
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.emplazamiento AS emplazamiento_3, t0.descripcion AS descripcion_4, t0.tecindustria AS tecindustria_5, t0.tecsevillana AS tecsevillana_6, t0.tecgerencia AS tecgerencia_7, t0.expgerencia AS expgerencia_8, t0.expindustria AS expindustria_9, t0.expsevillana AS expsevillana_10, t0.fechacomienzo AS fechacomienzo_11, t0.fechaestimada AS fechaestimada_12, t0.acabado AS acabado_13, t0.confidencial AS confidencial_14, t0.contrato_archivo AS contrato_archivo_15, t0.contrato_fecha_inicio AS contrato_fecha_inicio_16, t0.contrato_fecha_fin AS contrato_fecha_fin_17, t0.promotor_id AS promotor_id_18, t0.localidad_id AS localidad_id_19, t0.provincia_id AS provincia_id_20, t0.tipoproyecto_id AS tipoproyecto_id_21, t22.id AS id_23, t22.nombre AS nombre_24, t22.objeto AS objeto_25, t22.situacion AS situacion_26, t22.tipo_proyecto AS tipo_proyecto_27, t22.portada AS portada_28, t22.logo AS logo_29, t22.created_at AS created_at_30, t22.azabache_proyecto_id AS azabache_proyecto_id_31 FROM azabache_proyecto t0 LEFT JOIN proyecto t22 ON t22.azabache_proyecto_id = t0.id WHERE t0.acabado = ? ORDER BY t0.numero DESC
Parameters:
[
0
]
|
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\AzabacheProyecto | 161 |
| App\Entity\AzabachePromotor | 112 |
| App\Entity\TipoProyecto | 18 |
| App\Entity\Localidad | 11 |
| App\Entity\Provincia | 8 |
| App\Entity\gestion_proyectos\Proyecto | 5 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\AzabacheProyecto | No errors. |
| App\Entity\AzabachePromotor | No errors. |
| App\Entity\Localidad | No errors. |
| App\Entity\Provincia | No errors. |
| App\Entity\TipoProyecto | No errors. |
| App\Entity\gestion_proyectos\Proyecto | No errors. |
| App\Entity\AzabacheEstado | No errors. |
| App\Entity\AzabacheNota | No errors. |
| App\Entity\AzabacheIncidencia | No errors. |
| App\Entity\AzabacheAviso | No errors. |
| App\Entity\AzabacheComunicacion | No errors. |
| App\Entity\AzabacheAgente | No errors. |
| App\Entity\AzabacheSeguimiento | No errors. |
| App\Entity\AzabacheDocumento | No errors. |
| App\Entity\Tiempos | No errors. |
| App\Entity\ProyectoNivel | No errors. |
| App\Entity\Evento | No errors. |
| App\Entity\User | No errors. |
| App\Entity\gestion_proyectos\Capitulo | No errors. |
| App\Entity\gestion_proyectos\Agente | No errors. |
| App\Entity\gestion_proyectos\Plano | No errors. |
| App\Entity\gestion_proyectos\Incidencia | No errors. |