POST https://sitdg.capacitacioninformatica.com/vehiculo/registrar_ticket

Query Metrics

6 Database Queries
6 Different statements
1.71 ms Query time
1 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 0.42 ms
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 = ?
Parameters:
[
  5
]
2 0.11 ms
"START TRANSACTION"
Parameters:
[]
3 0.37 ms
SELECT id FROM ticket WHERE vehiculo_id = ? AND dateout IS NULL AND deleted_at IS NULL AND COALESCE(cancelado,0)=0
Parameters:
[
  "481"
]
4 0.30 ms
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
Parameters:
[
  "481"
]
5 0.34 ms
INSERT INTO ticket (vehiculo_id, datein, conductor_id, procedencia, pesoin, pesoout, pesoneto, cancelado, created_at, usuario_crea_id, oficial_registra_id, autorizado_con_adeudo) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "481"
  "2026-03-16 10:25:29"
  null
  null
  0
  0
  0
  0
  "2026-03-16 10:25:29"
  5
  5
  0
]
6 0.17 ms
"COMMIT"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection
remote doctrine.dbal.remote_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
remote doctrine.orm.remote_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\User No errors.
App\Entity\Ticket
  • The mappings App\Entity\Ticket#oficialRegistra and App\Entity\User#tickets are inconsistent with each other.

remote entity manager

No loaded entities.