Query Metrics
1
Database Queries
1
Different statements
0.82 ms
Query time
0
Invalid entities
138
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.82 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.promotor_id AS promotor_id_14, t0.localidad_id AS localidad_id_15, t0.provincia_id AS provincia_id_16, t0.tipoproyecto_id AS tipoproyecto_id_17, t18.id AS id_19, t18.nombre AS nombre_20, t18.objeto AS objeto_21, t18.situacion AS situacion_22, t18.tipo_proyecto AS tipo_proyecto_23, t18.portada AS portada_24, t18.logo AS logo_25, t18.created_at AS created_at_26, t18.azabache_proyecto_id AS azabache_proyecto_id_27 FROM azabache_proyecto t0 LEFT JOIN proyecto t18 ON t18.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 | 39 |
| App\Entity\gestion_proyectos\Proyecto | 39 |
| App\Entity\AzabachePromotor | 35 |
| App\Entity\TipoProyecto | 10 |
| App\Entity\Localidad | 9 |
| App\Entity\Provincia | 6 |
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\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. |