Query Metrics
10
Database Queries
10
Different statements
92.66 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 8.40 ms |
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.fecha_inicio AS fecha_inicio_6, t0.fecha_final AS fecha_final_7, t0.fecha_limite_nuevo_participantes AS fecha_limite_nuevo_participantes_8, t0.horario AS horario_9, t0.numero_grup AS numero_grup_10, t0.inscripcion_cerrada AS inscripcion_cerrada_11, t0.uuid AS uuid_12, t0.__data AS __data_13, t0.__schema AS __schema_14, t0.__token AS __token_15, t0.solicitud_accion_formativa_id AS solicitud_accion_formativa_id_16 FROM grupo t0 WHERE t0.id = ?
Parameters:
[
125396
]
|
| 2 | 10.53 ms |
SELECT t0.id AS id_1, t0.id_externo AS id_externo_2, t0.uuid AS uuid_3, t0.__data AS __data_4, t0.__schema AS __schema_5, t0.__token AS __token_6, t0.formador_id AS formador_id_7, t0.grupo_id AS grupo_id_8 FROM imparte t0 WHERE t0.grupo_id = ?
Parameters:
[
125396
]
|
| 3 | 22.79 ms |
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.grupo_id AS grupo_id_10, t0.modalidad_id AS modalidad_id_11 FROM grupo_sesiones t0 WHERE t0.grupo_id = ?
Parameters:
[
125396
]
|
| 4 | 0.90 ms |
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
]
|
| 5 | 0.90 ms |
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:
[
196347
]
|
| 6 | 6.75 ms |
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:
[
18752
]
|
| 7 | 2.40 ms |
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:
[
4330
]
|
| 8 | 5.65 ms |
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:
[
3512
]
|
| 9 | 3.06 ms |
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.grupo_id AS grupo_id_10, t0.centro_formacion_id AS centro_formacion_id_11 FROM centro_formacion_acoge_grupo t0 WHERE t0.grupo_id = ?
Parameters:
[
125396
]
|
| 10 | 31.29 ms |
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:
[
530
]
|
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\Grupo | No errors. |
| App\Entity\SolicitudAccionFormativa | No errors. |
| App\Entity\Imparte | No errors. |
| App\Entity\ParticipantesGrupo | No errors. |
| App\Entity\GrupoSesiones | No errors. |
| App\Entity\CentroFormacionAcogeGrupo | No errors. |
| App\Entity\UsuarioHermes | No errors. |
| App\Entity\PropietarioContenido | No errors. |
| App\Entity\Formador | No errors. |
| App\Entity\Modalidad | No errors. |
| App\Entity\Curso | No errors. |
| App\Entity\Expediente | No errors. |
| App\Entity\Entidad | No errors. |
| App\Entity\EntidadColaboradora | No errors. |
| App\Entity\Convocatoria | No errors. |
| App\Entity\ExpedientePerteneAEntidad | No errors. |
| App\Entity\CentroFormacion | No errors. |
| App\Entity\Recurso | No errors. |
| App\Entity\EntidadColaboradoraPropietarioContenido | No errors. |
| App\Entity\Calendario | No errors. |
| App\Entity\Enlace | No errors. |
| App\Entity\Participante | No errors. |