Query Metrics

7 Database Queries
7 Different statements
7.82 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.65 ms
(33.89%)
1
SELECT j0_.id AS id_0, j0_.caratula AS caratula_1, j0_.numero AS numero_2, j0_.siniestro AS siniestro_3, j0_.poliza AS poliza_4, j0_.monto AS monto_5, j0_.fecha_derivacion AS fecha_derivacion_6, j0_.fecha_notificacion AS fecha_notificacion_7, j0_.vencimiento AS vencimiento_8, j0_.contacto AS contacto_9, j0_.fec_siniestro AS fec_siniestro_10, j0_.etapa2 AS etapa2_11, j0_.mediacion_inicio AS mediacion_inicio_12, j0_.mediacion_final AS mediacion_final_13, j0_.responsabilidad AS responsabilidad_14, j0_.create_at AS create_at_15, j0_.update_at AS update_at_16, j0_.compania_id AS compania_id_17, j0_.juzgado_id AS juzgado_id_18, j0_.abogado_id AS abogado_id_19, j0_.provincia_id AS provincia_id_20, j0_.etapa_id AS etapa_id_21, j0_.create_by_id AS create_by_id_22, j0_.update_by_id AS update_by_id_23 FROM juicio j0_ WHERE j0_.caratula LIKE ?
Parameters:
[
  "%Sánchez Jonathan%"
]
1.56 ms
(19.92%)
1
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:
[
  "Agustina"
]
0.97 ms
(12.47%)
1
SELECT p0_.id AS id_0, p0_.nombre AS nombre_1 FROM provincia p0_
Parameters:
[]
0.91 ms
(11.66%)
1
SELECT j0_.id AS id_0, j0_.nombre AS nombre_1, j0_.color AS color_2, j0_.campos AS campos_3 FROM juicio_etapa j0_
Parameters:
[]
0.75 ms
(9.58%)
1
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:
[
  9
]
0.53 ms
(6.77%)
1
SELECT u0_.id AS id_0, u0_.nick AS nick_1, u0_.password AS password_2, u0_.nombre AS nombre_3, u0_.dni AS dni_4, u0_.created_at AS created_at_5, u0_.updated_at AS updated_at_6, u0_.direccion AS direccion_7, u0_.telefono AS telefono_8, u0_.localidad AS localidad_9, u0_.visible AS visible_10, u0_.create_at AS create_at_11, u0_.update_at AS update_at_12, u0_.created_by_id AS created_by_id_13, u0_.updated_by_id AS updated_by_id_14, u0_.create_by_id AS create_by_id_15, u0_.update_by_id AS update_by_id_16 FROM usuario u0_
Parameters:
[]
0.45 ms
(5.72%)
1
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_
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\Provincia No errors.
App\Entity\JuicioEtapa No errors.
App\Entity\Juzgado No errors.
App\Entity\Informe No errors.