Query Metrics
15
Database Queries
15
Different statements
32.27 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.15 ms |
SELECT t0.id AS id_1, t0.nick AS nick_2, t0.password AS password_3, t0.nombre AS nombre_4, t0.dni AS dni_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.direccion AS direccion_8, t0.telefono AS telefono_9, t0.localidad AS localidad_10, t0.visible AS visible_11, t0.create_at AS create_at_12, t0.update_at AS update_at_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.create_by_id AS create_by_id_16, t0.update_by_id AS update_by_id_17 FROM usuario t0 WHERE t0.nick = ? LIMIT 1
Parameters:
[
"gonzalo"
]
|
| 2 | 1.00 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.negro AS negro_4, t0.create_at AS create_at_5, t0.update_at AS update_at_6, t0.supervisor_id AS supervisor_id_7, t0.create_by_id AS create_by_id_8, t0.update_by_id AS update_by_id_9 FROM usuario_nivel t0 INNER JOIN usuario_usuario_nivel ON t0.id = usuario_usuario_nivel.usuario_nivel_id WHERE usuario_usuario_nivel.usuario_id = ?
Parameters:
[
10
]
|
| 3 | 0.54 ms |
SELECT t0.id AS id_1, t0.caratula AS caratula_2, t0.numero AS numero_3, t0.siniestro AS siniestro_4, t0.poliza AS poliza_5, t0.monto AS monto_6, t0.fecha_derivacion AS fecha_derivacion_7, t0.fecha_notificacion AS fecha_notificacion_8, t0.vencimiento AS vencimiento_9, t0.contacto AS contacto_10, t0.fec_siniestro AS fec_siniestro_11, t0.mediacion_inicio AS mediacion_inicio_12, t0.mediacion_final AS mediacion_final_13, t0.responsabilidad AS responsabilidad_14, t0.create_at AS create_at_15, t0.update_at AS update_at_16, t0.compania_id AS compania_id_17, t0.juzgado_id AS juzgado_id_18, t0.abogado_id AS abogado_id_19, t0.provincia_id AS provincia_id_20, t0.etapa_id AS etapa_id_21, t0.create_by_id AS create_by_id_22, t0.update_by_id AS update_by_id_23 FROM juicio t0 WHERE t0.id = ?
Parameters:
[
"1127"
]
|
| 4 | 0.49 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.color AS color_3, t0.campos AS campos_4, t0.orden AS orden_5 FROM juicio_etapa t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 5 | 0.56 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.archivo AS archivo_3, t0.cuil AS cuil_4, t0.contacto AS contacto_5, t0.mail AS mail_6, t0.direccion AS direccion_7, t0.telefono AS telefono_8, t0.create_at AS create_at_9, t0.update_at AS update_at_10, t0.create_by_id AS create_by_id_11, t0.update_by_id AS update_by_id_12 FROM cliente t0 WHERE t0.id = ?
Parameters:
[
9
]
|
| 6 | 0.51 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM provincia t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 7 | 0.81 ms |
SELECT j0_.id AS id_0, j0_.nombre AS nombre_1, j0_.color AS color_2, j0_.campos AS campos_3, j0_.orden AS orden_4 FROM juicio_etapa j0_ WHERE j0_.id IN (?)
Parameters:
[
"1"
]
|
| 8 | 0.83 ms |
SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.archivo AS archivo_2, c0_.cuil AS cuil_3, c0_.contacto AS contacto_4, c0_.mail AS mail_5, c0_.direccion AS direccion_6, c0_.telefono AS telefono_7, c0_.create_at AS create_at_8, c0_.update_at AS update_at_9, c0_.create_by_id AS create_by_id_10, c0_.update_by_id AS update_by_id_11 FROM cliente c0_ WHERE c0_.id IN (?)
Parameters:
[
"9"
]
|
| 9 | 0.78 ms |
SELECT p0_.id AS id_0, p0_.nombre AS nombre_1 FROM provincia p0_ WHERE p0_.id IN (?)
Parameters:
[
"1"
]
|
| 10 | 0.62 ms |
"START TRANSACTION"
Parameters:
[] |
| 11 | 4.87 ms |
UPDATE juicio SET numero = ?, update_at = ?, update_by_id = ? WHERE id = ?
Parameters:
[ "3834/25" "2025-10-28 16:24:22" 10 1127 ] |
| 12 | 3.31 ms |
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.detalle AS detalle_3, t0.create_at AS create_at_4, t0.update_at AS update_at_5, t0.juicio_id AS juicio_id_6, t0.historia_tipo_id AS historia_tipo_id_7, t0.create_by_id AS create_by_id_8, t0.update_by_id AS update_by_id_9 FROM historia t0 WHERE t0.juicio_id = ? ORDER BY t0.fecha DESC
Parameters:
[
1127
]
|
| 13 | 1.89 ms |
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.nombre AS nombre_3, t0.detalle AS detalle_4, t0.estado AS estado_5, t0.fecha_aviso AS fecha_aviso_6, t0.periodico AS periodico_7, t0.per_fecha_limite AS per_fecha_limite_8, t0.cumplido_at AS cumplido_at_9, t0.create_at AS create_at_10, t0.update_at AS update_at_11, t0.tipo_id AS tipo_id_12, t0.juicio_id AS juicio_id_13, t0.provincia_id AS provincia_id_14, t0.principal_id AS principal_id_15, t0.cumplido_by_id AS cumplido_by_id_16, t0.create_by_id AS create_by_id_17, t0.update_by_id AS update_by_id_18 FROM evento t0 WHERE t0.juicio_id = ?
Parameters:
[
1127
]
|
| 14 | 12.36 ms |
INSERT INTO testigo (createdAt, detalle, objeto, obejto_id, usuario_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-10-28 16:24:22" "Modifico: {"\u0000*\u0000createAt":"05.08.2025 13:34:59","\u0000*\u0000createBy":"ID=9","\u0000*\u0000updateAt":"28.10.2025 16:24:22","\u0000*\u0000updateBy":"ID=10","id":1127,"compania":"ID=9","caratula":"RISSO PATRON BRAIAN JOSE C\/MARTINEZ ALDO GUSTAVO Y OTROS S\/DA\u00d1OS Y PERJUICIOS","numero":"3834\/25","juzgado":null,"siniestro":"201020","poliza":null,"monto":null,"fechaDerivacion":null,"fechaNotificacion":null,"vencimiento":null,"abogado":null,"historias":[7384],"provincia":"ID=1","contacto":null,"fecSiniestro":null,"etapa":"ID=1","mediacionInicio":"08.08.2025 00:00:00","mediacionFinal":null,"responsabilidad":null,"eventos":[]}" "Juicio" 1127 10 ] |
| 15 | 2.55 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\Base | No errors. |
| App\Entity\Usuario | No errors. |
| App\Entity\UsuarioNivel | No errors. |
| App\Entity\Juicio | No errors. |
| App\Entity\Evento | No errors. |
| App\Entity\Cliente | No errors. |
| App\Entity\Juzgado | No errors. |
| App\Entity\Provincia | No errors. |
| App\Entity\JuicioEtapa | No errors. |
| App\Entity\Historia | No errors. |
| App\Entity\Informe | No errors. |
| App\Entity\HistoriaTipo | No errors. |
| App\Entity\Archivo | No errors. |
| App\Entity\EventoTipo | No errors. |
| App\Entity\Testigo | No errors. |