Query Metrics
6
Database Queries
6
Different statements
5.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.15 ms (19.97%) |
1 |
SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.updated_at AS updated_at_3, t0.created_at AS created_at_4, t0.id_externo AS id_externo_5, t0.horas_aula_virtual AS horas_aula_virtual_6, t0.horas_presenciales AS horas_presenciales_7, t0.horas_teleformacion AS horas_teleformacion_8, t0.uuid AS uuid_9, t0.__data AS __data_10, t0.__schema AS __schema_11, t0.__token AS __token_12, t0.curso_id AS curso_id_13, t0.expediente_id AS expediente_id_14, t0.modalidad_id AS modalidad_id_15 FROM solicitud_accion_formativa t0 WHERE t0.id = ?
Parameters:
[
197500
]
|
|
1.09 ms (18.89%) |
1 |
SELECT t0.id AS id_1, t0.id_externo AS id_externo_2, t0.foto AS foto_3, t0.razon_social AS razon_social_4, t0.nombre_comercial AS nombre_comercial_5, t0.identificador AS identificador_6, t0.nss AS nss_7, t0.descripcion AS descripcion_8, t0.correo AS correo_9, t0.rrss AS rrss_10, t0.web AS web_11, t0.contacto_nombre AS contacto_nombre_12, t0.contacto_apellidos AS contacto_apellidos_13, t0.info_public AS info_public_14, t0.info_profile_public AS info_profile_public_15, t0.direccion AS direccion_16, t0.numero AS numero_17, t0.escalera AS escalera_18, t0.piso AS piso_19, t0.planta AS planta_20, t0.puerta AS puerta_21, t0.cp AS cp_22, t0.poblacion AS poblacion_23, t0.provincia AS provincia_24, t0.telefonos AS telefonos_25, t0.pais AS pais_26, t0.imagenes AS imagenes_27, t0.activo AS activo_28, t0.deleted_at AS deleted_at_29, t0.updated_at AS updated_at_30, t0.created_at AS created_at_31, t0.uuid AS uuid_32, t0.__data AS __data_33, t0.__schema AS __schema_34, t0.__token AS __token_35, t0.configuracion_citas AS configuracion_citas_36, t0.beneficiaria_subvencion AS beneficiaria_subvencion_37, t0.type FROM entidad t0 WHERE t0.id = ? AND t0.type IN ('entidad_colaboradora')
Parameters:
[
297
]
|
|
1.03 ms (17.80%) |
1 |
SELECT t0.id AS id_1, t0.id_externo AS id_externo_2, t0.nombre AS nombre_3, t0.descripcion AS descripcion_4, t0.area AS area_5, t0.familia AS familia_6, t0.url_programa AS url_programa_7, t0.deleted_at AS deleted_at_8, t0.updated_at AS updated_at_9, t0.created_at AS created_at_10, t0.uuid AS uuid_11, t0.__data AS __data_12, t0.__schema AS __schema_13, t0.__token AS __token_14, t0.entidad_colaboradora_id AS entidad_colaboradora_id_15 FROM curso t0 WHERE t0.id = ?
Parameters:
[
27933
]
|
|
0.91 ms (15.78%) |
1 |
SELECT t0.id AS id_1, t0.id_externo AS id_externo_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.expediente AS expediente_6, t0.fecha_solicitud AS fecha_solicitud_7, t0.uuid AS uuid_8, t0.__data AS __data_9, t0.__schema AS __schema_10, t0.__token AS __token_11, t0.convocatoria_id AS convocatoria_id_12, t0.expediente_pertene_aentidad_id AS expediente_pertene_aentidad_id_13 FROM expediente t0 WHERE t0.id = ?
Parameters:
[
4728
]
|
|
0.81 ms (14.06%) |
1 |
SELECT t0.id AS id_1, t0.id_externo AS id_externo_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.nombre AS nombre_6, t0.uuid AS uuid_7, t0.__data AS __data_8, t0.__schema AS __schema_9, t0.__token AS __token_10 FROM modalidad t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.78 ms (13.50%) |
1 |
SELECT t0.id AS id_1, t0.id_externo AS id_externo_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.uuid AS uuid_6, t0.__data AS __data_7, t0.__schema AS __schema_8, t0.__token AS __token_9, t0.entidad_colaboradora_id AS entidad_colaboradora_id_10 FROM expediente_pertenece_a_entidad t0 WHERE t0.id = ?
Parameters:
[
3232
]
|
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\BaseEntity | No errors. |
| App\Entity\SolicitudAccionFormativa | No errors. |
| App\Entity\Curso | No errors. |
| App\Entity\Expediente | No errors. |
| App\Entity\Modalidad | No errors. |
| App\Entity\Grupo | No errors. |
| App\Entity\UsuarioHermes | No errors. |
| App\Entity\Entidad | No errors. |
| App\Entity\EntidadColaboradora | No errors. |
| App\Entity\GrupoSesiones | No errors. |
| App\Entity\Convocatoria | No errors. |
| App\Entity\ExpedientePerteneAEntidad | No errors. |
| App\Entity\Recurso | No errors. |
| App\Entity\PropietarioContenido | No errors. |
| App\Entity\EntidadColaboradoraPropietarioContenido | No errors. |
| App\Entity\Calendario | No errors. |
| App\Entity\Enlace | No errors. |
| App\Entity\Formador | No errors. |
| App\Entity\Participante | No errors. |