GET https://pdtdev.devsti.cl/registropublico

Query Metrics

4 Database Queries
4 Different statements
11.95 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
4.13 ms
(34.56%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.contacto AS contacto_3, t0.rut AS rut_4, t0.dv AS dv_5 FROM ps_gen_empresa t0
Parameters:
[]
3.89 ms
(32.56%)
1
SELECT t0.id AS id_1, t0.sucursal AS sucursal_2, t0.region AS region_3, t0.pais AS pais_4, t0.canal_venta AS canal_venta_5, t0.estado AS estado_6, t0.direccion AS direccion_7, t0.zona AS zona_8 FROM ps_gen_sucursal t0 WHERE t0.estado = ? ORDER BY t0.sucursal ASC
Parameters:
[
  "A"
]
2.47 ms
(20.65%)
1
SELECT u0_.email AS email_0 FROM user u0_ WHERE u0_.roles LIKE ?
Parameters:
[
  "%ROLE_PDT_ADMIN%"
]
1.46 ms
(12.24%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.tipo AS tipo_3, t0.descripcion AS descripcion_4 FROM ps_rol t0
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\PsGenEmpresa No errors.
App\Entity\PsEppEntrega No errors.
App\Entity\PsRol No errors.
App\Entity\PsPdtFirmante No errors.
App\Entity\User
  • The association App\Entity\User#psPdtControlEnCalientes refers to the owning side field App\Entity\PsPdtControlEnCaliente#id_usuario_control_final which does not exist.
App\Entity\PsGenSucursal
  • The association App\Entity\PsGenSucursal#impartir_cursos refers to the owning side field App\Entity\PsIrlImpartirCurso#sucursal_id which does not exist.
App\Entity\PsEppUsuarioSucursal No errors.
App\Entity\PsOdcObservacion
  • The association App\Entity\PsOdcObservacion#id_usuario refers to the inverse side field App\Entity\User#psOdcObservacion which does not exist.
  • If association App\Entity\PsOdcObservacion#id_trabajador is many-to-one, then the inversed side App\Entity\PsTrabajador#psOdcObservacion has to be one-to-many.
App\Entity\PsIrlImpartirCurso No errors.
App\Entity\PsIrlTrabajador No errors.