https://conforcat.release4.prometeoinnovations.com/ca/courses/grupo/126221

Query Metrics

10 Database Queries
10 Different statements
36.45 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.79 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:
[
  126221
]
2 3.83 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:
[
  126221
]
3 10.86 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:
[
  126221
]
4 1.95 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 2.10 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:
[
  194374
]
6 3.44 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:
[
  9430
]
7 3.24 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:
[
  4711
]
8 0.78 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 2.57 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:
[
  126221
]
10 4.88 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.