Symfony Profiler

• Request / Response
• Performance
• Exception
• Logs 3
• Events
• Routing
• Cache
• Security
• Twig
• HTTP Client
• Doctrine
• Migrations
• Emails
• Vite
• Configuration

Query Metrics

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();

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 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
  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 b.id,b.banco, b.tipo,b.numero,s.ssri as nombre
                                FROM banco_cta b, sujeto s
                                WHERE b.tipo in ('A','C') 
                                AND b.etd = 1
                                AND b.banco = s.id

[]

SELECT
  b.id,
  b.banco,
  b.tipo,
  b.numero,
  s.ssri as nombre
FROM
  banco_cta b,
  sujeto s
WHERE
  b.tipo in ('A', 'C')
  AND b.etd = 1
  AND b.banco = s.id

SELECT b.id,b.banco, b.tipo,b.numero,s.ssri as nombre
                                FROM banco_cta b, sujeto s
                                WHERE b.tipo in ('A','C') 
                                AND b.etd = 1
                                AND b.banco = s.id;

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

[
  0
  "fn_bnc_pr_buscar_prestamo"
]

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_buscar_prestamo';