Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 1
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

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.apaterno AS apaterno_6, t0.amaterno AS amaterno_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10 FROM user t0 WHERE t0.id = ?

[
  5
]

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.apaterno AS apaterno_6,
  t0.amaterno AS amaterno_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.deleted_at AS deleted_at_10
FROM
  user 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.apaterno AS apaterno_6, t0.amaterno AS amaterno_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10 FROM user t0 WHERE t0.id = 5;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

SELECT id FROM ticket WHERE vehiculo_id = ? AND dateout IS NULL AND deleted_at IS NULL AND COALESCE(cancelado,0)=0

[
  "208"
]

SELECT
  id
FROM
  ticket
WHERE
  vehiculo_id = ?
  AND dateout IS NULL
  AND deleted_at IS NULL
  AND COALESCE(cancelado, 0)= 0

SELECT id FROM ticket WHERE vehiculo_id = '208' AND dateout IS NULL AND deleted_at IS NULL AND COALESCE(cancelado,0)=0;

SELECT COALESCE(v.saldo, 0) AS v_saldo,
                            v.cliente_proveedor_id,
                            v.acceso,
                            COALESCE(cp.saldo, 0) AS cp_saldo
                     FROM vehiculo v
                     LEFT JOIN cliente_proveedor cp ON v.cliente_proveedor_id = cp.id
                     WHERE v.id = ?
                       AND v.deleted_at IS NULL

[
  "208"
]

SELECT
  COALESCE(v.saldo, 0) AS v_saldo,
  v.cliente_proveedor_id,
  v.acceso,
  COALESCE(cp.saldo, 0) AS cp_saldo
FROM
  vehiculo v
  LEFT JOIN cliente_proveedor cp ON v.cliente_proveedor_id = cp.id
WHERE
  v.id = ?
  AND v.deleted_at IS NULL

SELECT COALESCE(v.saldo, 0) AS v_saldo,
                            v.cliente_proveedor_id,
                            v.acceso,
                            COALESCE(cp.saldo, 0) AS cp_saldo
                     FROM vehiculo v
                     LEFT JOIN cliente_proveedor cp ON v.cliente_proveedor_id = cp.id
                     WHERE v.id = '208'
                       AND v.deleted_at IS NULL;

SELECT MAX(COALESCE(d.fecha, d.created_at))
             FROM deposito d
             WHERE d.deleted_at IS NULL
               AND (d.vehiculo_id = ? OR (? IS NOT NULL AND d.cliente_proveedor_id = ?))

[
  208
  3
  3
]

SELECT
  MAX(
    COALESCE(d.fecha, d.created_at)
  )
FROM
  deposito d
WHERE
  d.deleted_at IS NULL
  AND (
    d.vehiculo_id = ?
    OR (
      ? IS NOT NULL
      AND d.cliente_proveedor_id = ?
    )
  )

SELECT MAX(COALESCE(d.fecha, d.created_at))
             FROM deposito d
             WHERE d.deleted_at IS NULL
               AND (d.vehiculo_id = 208 OR (3 IS NOT NULL AND d.cliente_proveedor_id = 3));

SELECT COUNT(t.id) FROM ticket t WHERE t.vehiculo_id = ? AND t.autorizado_con_adeudo = 1 AND t.deleted_at IS NULL AND COALESCE(t.cancelado, 0) = 0 AND t.datein > ?

[
  "208"
  "2026-02-02 00:00:00"
]

SELECT
  COUNT(t.id)
FROM
  ticket t
WHERE
  t.vehiculo_id = ?
  AND t.autorizado_con_adeudo = 1
  AND t.deleted_at IS NULL
  AND COALESCE(t.cancelado, 0) = 0
  AND t.datein > ?

SELECT COUNT(t.id) FROM ticket t WHERE t.vehiculo_id = '208' AND t.autorizado_con_adeudo = 1 AND t.deleted_at IS NULL AND COALESCE(t.cancelado, 0) = 0 AND t.datein > '2026-02-02 00:00:00';

"ROLLBACK"

[]

"ROLLBACK"

"ROLLBACK";