Query Metrics

25 Database Queries
14 Different statements
43.56 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
28.79 ms
(66.10%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.nombre AS nombre_1 FROM accion_formativa a0_ ORDER BY a0_.nombre ASC
Parameters:
[]
5.66 ms
(12.99%)
11
SELECT t0.id AS id_1, t0.estadogr AS estadogr_2, t0.estadoej AS estadoej_3, t0.nombre AS nombre_4, t0.alumnos_certificables_totales AS alumnos_certificables_totales_5, t0.alumnos_certificables_finalizados AS alumnos_certificables_finalizados_6, t0.alumnos_iniciados AS alumnos_iniciados_7, t0.alumnos_certificacion_total AS alumnos_certificacion_total_8, t0.fecha_inicio AS fecha_inicio_9, t0.fecha_fin AS fecha_fin_10, t0.fact AS fact_11, t0.abandonos AS abandonos_12, t0.accion_formativa_id AS accion_formativa_id_13, t0.cliente_id AS cliente_id_14 FROM grupo t0 WHERE t0.accion_formativa_id = ?
Parameters:
[
  3060
]
1.71 ms
(3.91%)
1
SELECT DISTINCT c0_.id AS id_0, c0_.nombre AS nombre_1 FROM convocatoria c0_ ORDER BY c0_.nombre ASC
Parameters:
[]
1.63 ms
(3.74%)
1
SELECT DISTINCT e0_.id AS id_0, e0_.nombre AS nombre_1 FROM expediente e0_ ORDER BY e0_.nombre ASC
Parameters:
[]
1.01 ms
(2.32%)
2
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.ano AS ano_3, t0.concepto_contable AS concepto_contable_4, t0.serie_facturacion AS serie_facturacion_5, t0.tipo_impuesto AS tipo_impuesto_6, t0.pasividad_impuesto AS pasividad_impuesto_7, t0.numero_factura AS numero_factura_8, t0.num_cuenta AS num_cuenta_9, t0.direccion AS direccion_10, t0.codigo_postal AS codigo_postal_11, t0.telefono AS telefono_12, t0.email AS email_13, t0.datos_pago AS datos_pago_14, t0.municipio AS municipio_15, t0.provincia AS provincia_16, t0.codigo_nombre AS codigo_nombre_17, t0.tipo_banco AS tipo_banco_18, t0.cif AS cif_19, t0.conexion AS conexion_20, t0.expediente_id AS expediente_id_21 FROM beneficiario t0 WHERE t0.id = ?
Parameters:
[
  54
]
0.77 ms
(1.76%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.tipo_gasto AS tipo_gasto_3, t0.tipo_alumno AS tipo_alumno_4, t0.tipo_precio AS tipo_precio_5, t0.precio AS precio_6, t0.concepto_factura AS concepto_factura_7, t0.observaciones_factura AS observaciones_factura_8, t0.centro_coste AS centro_coste_9, t0.proyecto AS proyecto_10, t0.modalidad AS modalidad_11, t0.proveedor_id AS proveedor_id_12, t0.expediente_id AS expediente_id_13, t0.cliente_id AS cliente_id_14 FROM expediente_cliente t0 WHERE t0.expediente_id = ?
Parameters:
[
  186
]
0.75 ms
(1.72%)
1
SELECT t0.id AS id_1, t0.horas_telematicas AS horas_telematicas_2, t0.horas_presenciales AS horas_presenciales_3, t0.nombre AS nombre_4, t0.horas_practicas AS horas_practicas_5, t0.numero AS numero_6, t0.codigo AS codigo_7, t0.expediente_id AS expediente_id_8 FROM accion_formativa t0 WHERE t0.expediente_id = ?
Parameters:
[
  186
]
0.69 ms
(1.59%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.concepto_contable AS concepto_contable_3, t0.convocatoria_id AS convocatoria_id_4 FROM expediente t0 WHERE t0.id = ?
Parameters:
[
  "186"
]
0.52 ms
(1.18%)
1
SELECT DISTINCT c0_.id AS id_0, c0_.nombre AS nombre_1 FROM cliente c0_ ORDER BY c0_.nombre ASC
Parameters:
[]
0.45 ms
(1.04%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.theme AS theme_3, t0.roles AS roles_4, t0.password AS password_5 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "yovana.perez@postal3.es"
]
0.44 ms
(1.00%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.concepto_contable AS concepto_contable_3, t0.import AS import_4, t0.read_client AS read_client_5, t0.concepto_convocatoria AS concepto_convocatoria_6, t0.centro_coste_convocatoria AS centro_coste_convocatoria_7 FROM convocatoria t0 WHERE t0.id = ?
Parameters:
[
  400
]
0.43 ms
(0.98%)
1
SELECT DISTINCT b0_.id AS id_0, b0_.nombre AS nombre_1 FROM beneficiario b0_ ORDER BY b0_.nombre ASC
Parameters:
[]
0.42 ms
(0.97%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.direccion AS direccion_3, t0.codigo_postal AS codigo_postal_4, t0.telefono AS telefono_5, t0.email AS email_6, t0.codigo AS codigo_7, t0.provincia AS provincia_8, t0.municipio AS municipio_9, t0.internal AS internal_10 FROM cliente t0 WHERE t0.id = ?
Parameters:
[
  21
]
0.30 ms
(0.70%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.value AS value_3, t0.exist_validate AS exist_validate_4 FROM tipo_gasto t0
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection
sqlserver doctrine.dbal.sqlserver_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\User No errors.
App\Entity\Expediente No errors.
App\Entity\Convocatoria No errors.
App\Entity\Beneficiario No errors.
App\Entity\Cliente No errors.
App\Entity\TipoGasto No errors.
App\Entity\RelacionProveedorGasto No errors.
App\Entity\AccionFormativa No errors.
App\Entity\ExpedienteCliente No errors.
App\Entity\Grupo
  • The mappings App\Entity\Grupo#cliente and App\Entity\Cliente#grupos are inconsistent with each other.
App\Entity\CuentasContables No errors.
App\Entity\CuentaGestionImpuestos No errors.
App\Entity\ConceptoContable No errors.