Query Metrics
17
Database Queries
14
Different statements
53.58 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.33 ms |
SELECT t0.id AS id_1, t0.password AS password_2, t0.email AS email_3, t0.nombre AS nombre_4, t0.apellidos AS apellidos_5, t0.permisos AS permisos_6, t0.fecha_creacion AS fecha_creacion_7, t0.usuario_creo AS usuario_creo_8, t0.fecha_actualizacion AS fecha_actualizacion_9, t0.usuario_actualizo AS usuario_actualizo_10, t0.ultima_conexion AS ultima_conexion_11 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
9
]
|
| 2 | 2.39 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.roles AS roles_4 FROM grupo t0 INNER JOIN user_grupo ON t0.id = user_grupo.grupo_id WHERE user_grupo.user_id = ?
Parameters:
[
9
]
|
| 3 | 2.74 ms |
SELECT t0.id AS id_1, t0.anio AS anio_2, t0.numero AS numero_3, t0.tipo_documento AS tipo_documento_4 FROM folio_documentos t0 WHERE t0.anio = ? AND t0.tipo_documento = ? LIMIT 1
Parameters:
[ 2025 "FISP" ] |
| 4 | 1.91 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.cargo AS cargo_3 FROM destinatario t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"47"
]
|
| 5 | 1.26 ms |
SELECT e0_.id AS id_0, e0_.nombre AS nombre_1, e0_.cargo AS cargo_2 FROM elabora e0_ WHERE e0_.id IN (?)
Parameters:
[
"6"
]
|
| 6 | 1.03 ms |
SELECT s0_.id AS id_0, s0_.nombre AS nombre_1 FROM seguimiento s0_ WHERE s0_.id IN (?)
Parameters:
[
"11"
]
|
| 7 | 0.99 ms |
SELECT e0_.id AS id_0, e0_.nombre AS nombre_1 FROM estado_fisico e0_ WHERE e0_.id IN (?)
Parameters:
[
"1"
]
|
| 8 | 7.79 ms |
SELECT NEXTVAL('documento_elaborado_firmado_sp_id_seq')
Parameters:
[] |
| 9 | 1.10 ms |
SELECT t0.id AS id_1, t0.anio AS anio_2, t0.numero AS numero_3, t0.tipo_documento AS tipo_documento_4 FROM folio_documentos t0 WHERE t0.anio = ? AND t0.tipo_documento = ? LIMIT 1
Parameters:
[ 2025 "FISP" ] |
| 10 | 0.92 ms |
SELECT NEXTVAL('bitacora_id_seq')
Parameters:
[] |
| 11 | 0.62 ms |
SELECT NEXTVAL('bitacora_id_seq')
Parameters:
[] |
| 12 | 0.47 ms |
"START TRANSACTION"
Parameters:
[] |
| 13 | 3.49 ms |
INSERT INTO documento_elaborado_firmado_sp (id, clave_archivo, numero_documento, fecha_elaboracion, asunto, fecha_documentacion, url, folio_interno, anio, se_envia_a_id, quien_elaboro_id, seguimiento_id, usuario_id, estado_fisico_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 49 null "SSA/SP/0321/2025" "2025-11-04" "COMPROBACION VALE PAGARE 3780 AA" "2025-12-04" ""C:\Users\Conta\OneDrive\Documentos\C.P. OSCAR BERNABE CORTEZ\2025\MEMOS PSIC ERIKA\SSA SP 0321 2025 VALE PAGARÉ 3780 AA 9,500.00.pdf"" 49 2025 47 6 11 9 1 ] |
| 14 | 1.20 ms |
INSERT INTO bitacora (id, entidad, fecha_movimiento, cambio, accion, observaciones, usuario, ip, entidad_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 2121 "App\Entity\Main\DocumentoElaboradoFirmadoSP" "2025-12-08 11:03:28" "[]" "CREACIÓN" null 9 "10.51.250.118" 49 ] |
| 15 | 20.30 ms |
INSERT INTO bitacora (id, entidad, fecha_movimiento, cambio, accion, observaciones, usuario, ip, entidad_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 2122 "App\Entity\Main\FolioDocumentos" "2025-12-08 11:03:28" "{"numero":{"anterior":49,"actual":50}}" "ACTUALIZACIÓN" null 9 "10.51.250.118" 4 ] |
| 16 | 1.04 ms |
UPDATE folio_documentos SET numero = ? WHERE id = ?
Parameters:
[ 50 4 ] |
| 17 | 3.00 ms |
"COMMIT"
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_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\Main\User | No errors. |
| App\Entity\Main\Grupo | No errors. |
| App\Entity\Main\FolioDocumentos | No errors. |
| App\Entity\Main\DocumentoElaboradoFirmadoSP | No errors. |
| App\Entity\Main\Elabora | No errors. |
| App\Entity\Main\Seguimiento | No errors. |
| App\Entity\Main\EstadoFisico | No errors. |
| App\Entity\Main\Destinatario | No errors. |
| App\Entity\Main\Bitacora | No errors. |