Symfony Profiler

SELECT
  *,
  false AS check_cuota,
  false AS disabledPago,
  saldo_capital AS monto_c,
  saldo_interes AS monto_i,
  0 AS abono_c,
  0 AS abono_i
FROM
  bnc_tabla_amortizacion a
WHERE
  a.prestamo_bancario = 13
  AND a.estado = 'INICIADO'
  AND a.etc In ('CT', 'NA')

SELECT *, 
                                        false AS check_cuota, 
                                        false AS disabledPago, 
                                        saldo_capital AS monto_c,
                                        saldo_interes AS monto_i,
                                        0 AS abono_c, 
                                        0 AS abono_i
                                    FROM bnc_tabla_amortizacion a
                                    WHERE a.prestamo_bancario = 13
                                        AND a.estado = 'INICIADO'
                                        AND a.etc In ( 'CT', 'NA');

WITH
  ParametroVC AS (
    SELECT
      CASE WHEN p.codigo = 'POR_DIA' THEN
        p.valor
      WHEN p.codigo = 'POR_MES' THEN
        CAST(p.valor * 30.417 AS UNSIGNED)
      WHEN p.codigo = 'POR_ANIO' THEN
        p.valor * 365
      END AS dias
    FROM
      f_parametro p
    WHERE
      p.tipo = 'VC'
    LIMIT
      1
  )
SELECT
  1 AS vencimiento_clave,
  e.tipo
FROM
  empleado e
WHERE
  e.id = 10
  AND e.password_change + INTERVAL (
    SELECT
      dias
    FROM
      ParametroVC
  ) DAY >= NOW();

WITH ParametroVC AS (
            SELECT 
                CASE 
                    WHEN p.codigo = 'POR_DIA' THEN p.valor
                    WHEN p.codigo = 'POR_MES' THEN CAST(p.valor * 30.417 AS UNSIGNED)
                    WHEN p.codigo = 'POR_ANIO' THEN p.valor * 365
                END AS dias
            FROM f_parametro p
            WHERE p.tipo = 'VC'
            LIMIT 1
        )
        SELECT 1 AS vencimiento_clave,
            e.tipo
        FROM empleado e
        WHERE 
            e.id = 10
            AND e.password_change + INTERVAL (SELECT dias FROM ParametroVC) DAY >= NOW();
    ;

SELECT
  *
FROM
  bnc_prestamo_bancario bnc
WHERE
  bnc.proveedor = 20
  AND bnc.estado = 'ACTIVO'
  AND bnc.estado_pago != 'PAGADO'

SELECT * 
                                    FROM bnc_prestamo_bancario bnc
                                    WHERE bnc.proveedor = 20
                                        AND bnc.estado = 'ACTIVO'
                                        AND bnc.estado_pago != 'PAGADO';

SELECT
  *,
  false AS check_cuota,
  false AS disabledPago,
  saldo_capital AS monto_c,
  saldo_interes AS monto_i,
  0 AS abono_c,
  0 AS abono_i
FROM
  bnc_tabla_amortizacion a
WHERE
  a.prestamo_bancario = 12
  AND a.estado = 'INICIADO'
  AND a.etc In ('CT', 'NA')

SELECT *, 
                                        false AS check_cuota, 
                                        false AS disabledPago, 
                                        saldo_capital AS monto_c,
                                        saldo_interes AS monto_i,
                                        0 AS abono_c, 
                                        0 AS abono_i
                                    FROM bnc_tabla_amortizacion a
                                    WHERE a.prestamo_bancario = 12
                                        AND a.estado = 'INICIADO'
                                        AND a.etc In ( 'CT', 'NA');

SELECT
  *,
  false AS check_cuota,
  false AS disabledPago,
  saldo_capital AS monto_c,
  saldo_interes AS monto_i,
  0 AS abono_c,
  0 AS abono_i
FROM
  bnc_tabla_amortizacion a
WHERE
  a.prestamo_bancario = 4
  AND a.estado = 'INICIADO'
  AND a.etc In ('CT', 'NA')

SELECT *, 
                                        false AS check_cuota, 
                                        false AS disabledPago, 
                                        saldo_capital AS monto_c,
                                        saldo_interes AS monto_i,
                                        0 AS abono_c, 
                                        0 AS abono_i
                                    FROM bnc_tabla_amortizacion a
                                    WHERE a.prestamo_bancario = 4
                                        AND a.estado = 'INICIADO'
                                        AND a.etc In ( 'CT', 'NA');

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nombre AS nombre_5,
  t0.apellido AS apellido_6,
  t0.cedula AS cedula_7,
  t0.cuenta AS cuenta_8,
  t0.mas AS mas_9,
  t0.is_active AS is_active_10,
  t0.is_worker AS is_worker_11,
  t0.tipo AS tipo_12,
  t0.agencia AS agencia_13,
  t0.sujeto AS sujeto_14,
  t0.tid AS tid_15
FROM
  empleado t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.apellido AS apellido_6, t0.cedula AS cedula_7, t0.cuenta AS cuenta_8, t0.mas AS mas_9, t0.is_active AS is_active_10, t0.is_worker AS is_worker_11, t0.tipo AS tipo_12, t0.agencia AS agencia_13, t0.sujeto AS sujeto_14, t0.tid AS tid_15 FROM empleado t0 WHERE t0.id = 10;

SELECT
  *,
  false AS check_cuota,
  false AS disabledPago,
  saldo_capital AS monto_c,
  saldo_interes AS monto_i,
  0 AS abono_c,
  0 AS abono_i
FROM
  bnc_tabla_amortizacion a
WHERE
  a.prestamo_bancario = 1
  AND a.estado = 'INICIADO'
  AND a.etc In ('CT', 'NA')

SELECT *, 
                                        false AS check_cuota, 
                                        false AS disabledPago, 
                                        saldo_capital AS monto_c,
                                        saldo_interes AS monto_i,
                                        0 AS abono_c, 
                                        0 AS abono_i
                                    FROM bnc_tabla_amortizacion a
                                    WHERE a.prestamo_bancario = 1
                                        AND a.estado = 'INICIADO'
                                        AND a.etc In ( 'CT', 'NA');

SELECT
  FIND_IN_SET(?, tipo) as busqueda
FROM
  zt_rutas
WHERE
  ruta = ?

SELECT FIND_IN_SET(0, tipo) as busqueda FROM zt_rutas WHERE ruta = 'fn_bnc_pr_pag_info_pag_proveedor';

SELECT
  *,
  false AS check_cuota,
  false AS disabledPago,
  saldo_capital AS monto_c,
  saldo_interes AS monto_i,
  0 AS abono_c,
  0 AS abono_i
FROM
  bnc_tabla_amortizacion a
WHERE
  a.prestamo_bancario = 8
  AND a.estado = 'INICIADO'
  AND a.etc In ('CT', 'NA')

SELECT *, 
                                        false AS check_cuota, 
                                        false AS disabledPago, 
                                        saldo_capital AS monto_c,
                                        saldo_interes AS monto_i,
                                        0 AS abono_c, 
                                        0 AS abono_i
                                    FROM bnc_tabla_amortizacion a
                                    WHERE a.prestamo_bancario = 8
                                        AND a.estado = 'INICIADO'
                                        AND a.etc In ( 'CT', 'NA');

SELECT
  *,
  false AS check_cuota,
  false AS disabledPago,
  saldo_capital AS monto_c,
  saldo_interes AS monto_i,
  0 AS abono_c,
  0 AS abono_i
FROM
  bnc_tabla_amortizacion a
WHERE
  a.prestamo_bancario = 3
  AND a.estado = 'INICIADO'
  AND a.etc In ('CT', 'NA')

SELECT *, 
                                        false AS check_cuota, 
                                        false AS disabledPago, 
                                        saldo_capital AS monto_c,
                                        saldo_interes AS monto_i,
                                        0 AS abono_c, 
                                        0 AS abono_i
                                    FROM bnc_tabla_amortizacion a
                                    WHERE a.prestamo_bancario = 3
                                        AND a.estado = 'INICIADO'
                                        AND a.etc In ( 'CT', 'NA');

SELECT
  *,
  false AS check_cuota,
  false AS disabledPago,
  saldo_capital AS monto_c,
  saldo_interes AS monto_i,
  0 AS abono_c,
  0 AS abono_i
FROM
  bnc_tabla_amortizacion a
WHERE
  a.prestamo_bancario = 6
  AND a.estado = 'INICIADO'
  AND a.etc In ('CT', 'NA')

SELECT *, 
                                        false AS check_cuota, 
                                        false AS disabledPago, 
                                        saldo_capital AS monto_c,
                                        saldo_interes AS monto_i,
                                        0 AS abono_c, 
                                        0 AS abono_i
                                    FROM bnc_tabla_amortizacion a
                                    WHERE a.prestamo_bancario = 6
                                        AND a.estado = 'INICIADO'
                                        AND a.etc In ( 'CT', 'NA');

SELECT
  *,
  false AS check_cuota,
  false AS disabledPago,
  saldo_capital AS monto_c,
  saldo_interes AS monto_i,
  0 AS abono_c,
  0 AS abono_i
FROM
  bnc_tabla_amortizacion a
WHERE
  a.prestamo_bancario = 2
  AND a.estado = 'INICIADO'
  AND a.etc In ('CT', 'NA')

SELECT *, 
                                        false AS check_cuota, 
                                        false AS disabledPago, 
                                        saldo_capital AS monto_c,
                                        saldo_interes AS monto_i,
                                        0 AS abono_c, 
                                        0 AS abono_i
                                    FROM bnc_tabla_amortizacion a
                                    WHERE a.prestamo_bancario = 2
                                        AND a.estado = 'INICIADO'
                                        AND a.etc In ( 'CT', 'NA');

SELECT
  *,
  false AS check_cuota,
  false AS disabledPago,
  saldo_capital AS monto_c,
  saldo_interes AS monto_i,
  0 AS abono_c,
  0 AS abono_i
FROM
  bnc_tabla_amortizacion a
WHERE
  a.prestamo_bancario = 9
  AND a.estado = 'INICIADO'
  AND a.etc In ('CT', 'NA')

SELECT *, 
                                        false AS check_cuota, 
                                        false AS disabledPago, 
                                        saldo_capital AS monto_c,
                                        saldo_interes AS monto_i,
                                        0 AS abono_c, 
                                        0 AS abono_i
                                    FROM bnc_tabla_amortizacion a
                                    WHERE a.prestamo_bancario = 9
                                        AND a.estado = 'INICIADO'
                                        AND a.etc In ( 'CT', 'NA');

SELECT
  *,
  false AS check_cuota,
  false AS disabledPago,
  saldo_capital AS monto_c,
  saldo_interes AS monto_i,
  0 AS abono_c,
  0 AS abono_i
FROM
  bnc_tabla_amortizacion a
WHERE
  a.prestamo_bancario = 7
  AND a.estado = 'INICIADO'
  AND a.etc In ('CT', 'NA')

SELECT *, 
                                        false AS check_cuota, 
                                        false AS disabledPago, 
                                        saldo_capital AS monto_c,
                                        saldo_interes AS monto_i,
                                        0 AS abono_c, 
                                        0 AS abono_i
                                    FROM bnc_tabla_amortizacion a
                                    WHERE a.prestamo_bancario = 7
                                        AND a.estado = 'INICIADO'
                                        AND a.etc In ( 'CT', 'NA');

SELECT
  *,
  false AS check_cuota,
  false AS disabledPago,
  saldo_capital AS monto_c,
  saldo_interes AS monto_i,
  0 AS abono_c,
  0 AS abono_i
FROM
  bnc_tabla_amortizacion a
WHERE
  a.prestamo_bancario = 10
  AND a.estado = 'INICIADO'
  AND a.etc In ('CT', 'NA')

SELECT *, 
                                        false AS check_cuota, 
                                        false AS disabledPago, 
                                        saldo_capital AS monto_c,
                                        saldo_interes AS monto_i,
                                        0 AS abono_c, 
                                        0 AS abono_i
                                    FROM bnc_tabla_amortizacion a
                                    WHERE a.prestamo_bancario = 10
                                        AND a.estado = 'INICIADO'
                                        AND a.etc In ( 'CT', 'NA');