Query Metrics
17
Database Queries
14
Different statements
6.41 ms
Query time
8
Invalid entities
1202
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.22 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.terminosycondiciones AS terminosycondiciones_5, t0.suscripcion AS suscripcion_6, t0.persona_id AS persona_id_7, t0.rol_id AS rol_id_8 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
45
]
|
| 2 | 0.21 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3 FROM rol t0 WHERE t0.id = ?
Parameters:
[
7
]
|
| 3 | 0.53 ms |
SELECT t0.id AS id_1, t0.primernombre AS primernombre_2, t0.segundonombre AS segundonombre_3, t0.primerapellido AS primerapellido_4, t0.segundoapellido AS segundoapellido_5, t0.documento AS documento_6, t0.estado AS estado_7, t0.fechanacimiento AS fechanacimiento_8, t0.direccion AS direccion_9, t0.telefono AS telefono_10, t0.email AS email_11, t0.idintegracion AS idintegracion_12, t0.documentfile AS documentfile_13, t0.tipodocumento_id AS tipodocumento_id_14, t0.municipio_id AS municipio_id_15, t0.empresa_id AS empresa_id_16, t0.tipopago_id AS tipopago_id_17, t0.catalogoprecio_id AS catalogoprecio_id_18, t0.tipocliente_id AS tipocliente_id_19, t0.resptributaria_id AS resptributaria_id_20, t0.posicionfiscal_id AS posicionfiscal_id_21 FROM persona t0 WHERE t0.id = ?
Parameters:
[
"8291"
]
|
| 4 | 2.09 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.departamento_id AS departamento_id_4 FROM municipio t0 ORDER BY t0.nombre ASC
Parameters:
[] |
| 5 | 0.34 ms |
SELECT t0.id AS id_1, t0.numerocuenta AS numerocuenta_2, t0.anioexperiencia AS anioexperiencia_3, t0.tarjetaprofesional AS tarjetaprofesional_4, t0.validacion AS validacion_5, t0.persona_id AS persona_id_6, t0.profesion_id AS profesion_id_7, t0.banco_id AS banco_id_8, t0.tipocuenta_id AS tipocuenta_id_9, t0.comercial_id AS comercial_id_10, t0.estado_id AS estado_id_11, t0.tipofacturacion_id AS tipofacturacion_id_12, t0.razonsocialfacturacion_id AS razonsocialfacturacion_id_13, t0.catalogoventa_id AS catalogoventa_id_14 FROM profesionales t0 WHERE t0.persona_id = ?
Parameters:
[
8291
]
|
| 6 | 0.35 ms |
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.abreviatura AS abreviatura_3, t0.tipodocumentodian AS tipodocumentodian_4, t0.idodoo AS idodoo_5 FROM tipodocumento t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 7 | 0.21 ms |
SELECT t0_.id AS id_0, t0_.descripcion AS descripcion_1, t0_.abreviatura AS abreviatura_2, t0_.tipodocumentodian AS tipodocumentodian_3, t0_.idodoo AS idodoo_4 FROM tipodocumento t0_
Parameters:
[] |
| 8 | 0.38 ms |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.descripcion AS descripcion_2 FROM tipopago t0_
Parameters:
[] |
| 9 | 0.20 ms |
SELECT g0_.id AS id_0, g0_.nombre AS nombre_1 FROM grupo_listas_precios g0_
Parameters:
[] |
| 10 | 0.19 ms |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.descripcion AS descripcion_2 FROM tipocliente t0_
Parameters:
[] |
| 11 | 0.25 ms |
SELECT t0_.id AS id_0, t0_.descripcion AS descripcion_1, t0_.codigo AS codigo_2, t0_.codigoodoo AS codigoodoo_3 FROM tiporesponsabilidad t0_
Parameters:
[] |
| 12 | 0.18 ms |
SELECT r0_.id AS id_0, r0_.descripcion AS descripcion_1, r0_.codigo AS codigo_2, r0_.codigoodoo AS codigoodoo_3 FROM resptributaria r0_
Parameters:
[] |
| 13 | 0.38 ms |
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.etiqueta AS etiqueta_2, m0_.icono AS icono_3, m0_.ruta AS ruta_4, m0_.nivel AS nivel_5, m0_.posicion AS posicion_6, m0_.activo AS activo_7, m0_.fecha_creacion AS fecha_creacion_8, m0_.fecha_actualizacion AS fecha_actualizacion_9, m0_.padre_id AS padre_id_10 FROM menu_item m0_ LEFT JOIN menu_item_rol m2_ ON m0_.id = m2_.menu_item_id LEFT JOIN rol r1_ ON r1_.id = m2_.rol_id WHERE m0_.activo = ? AND m0_.nivel = 0 AND r1_.nombre IN (?) ORDER BY m0_.posicion ASC
Parameters:
[ 1 "ROLE_OPERATIVO" ] |
| 14 | 0.25 ms |
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.etiqueta AS etiqueta_2, m0_.icono AS icono_3, m0_.ruta AS ruta_4, m0_.nivel AS nivel_5, m0_.posicion AS posicion_6, m0_.activo AS activo_7, m0_.fecha_creacion AS fecha_creacion_8, m0_.fecha_actualizacion AS fecha_actualizacion_9, m0_.padre_id AS padre_id_10 FROM menu_item m0_ LEFT JOIN menu_item_rol m2_ ON m0_.id = m2_.menu_item_id LEFT JOIN rol r1_ ON r1_.id = m2_.rol_id WHERE m0_.padre_id = ? AND m0_.activo = ? AND r1_.nombre IN (?) ORDER BY m0_.posicion ASC
Parameters:
[ 241 1 "ROLE_OPERATIVO" ] |
| 15 | 0.21 ms |
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.etiqueta AS etiqueta_2, m0_.icono AS icono_3, m0_.ruta AS ruta_4, m0_.nivel AS nivel_5, m0_.posicion AS posicion_6, m0_.activo AS activo_7, m0_.fecha_creacion AS fecha_creacion_8, m0_.fecha_actualizacion AS fecha_actualizacion_9, m0_.padre_id AS padre_id_10 FROM menu_item m0_ LEFT JOIN menu_item_rol m2_ ON m0_.id = m2_.menu_item_id LEFT JOIN rol r1_ ON r1_.id = m2_.rol_id WHERE m0_.padre_id = ? AND m0_.activo = ? AND r1_.nombre IN (?) ORDER BY m0_.posicion ASC
Parameters:
[ 270 1 "ROLE_OPERATIVO" ] |
| 16 | 0.21 ms |
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.etiqueta AS etiqueta_2, m0_.icono AS icono_3, m0_.ruta AS ruta_4, m0_.nivel AS nivel_5, m0_.posicion AS posicion_6, m0_.activo AS activo_7, m0_.fecha_creacion AS fecha_creacion_8, m0_.fecha_actualizacion AS fecha_actualizacion_9, m0_.padre_id AS padre_id_10 FROM menu_item m0_ LEFT JOIN menu_item_rol m2_ ON m0_.id = m2_.menu_item_id LEFT JOIN rol r1_ ON r1_.id = m2_.rol_id WHERE m0_.padre_id = ? AND m0_.activo = ? AND r1_.nombre IN (?) ORDER BY m0_.posicion ASC
Parameters:
[ 276 1 "ROLE_OPERATIVO" ] |
| 17 | 0.21 ms |
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.etiqueta AS etiqueta_2, m0_.icono AS icono_3, m0_.ruta AS ruta_4, m0_.nivel AS nivel_5, m0_.posicion AS posicion_6, m0_.activo AS activo_7, m0_.fecha_creacion AS fecha_creacion_8, m0_.fecha_actualizacion AS fecha_actualizacion_9, m0_.padre_id AS padre_id_10 FROM menu_item m0_ LEFT JOIN menu_item_rol m2_ ON m0_.id = m2_.menu_item_id LEFT JOIN rol r1_ ON r1_.id = m2_.rol_id WHERE m0_.padre_id = ? AND m0_.activo = ? AND r1_.nombre IN (?) ORDER BY m0_.posicion ASC
Parameters:
[ 279 1 "ROLE_OPERATIVO" ] |
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Municipio | 1123 |
| App\Entity\Departamento | 33 |
| App\Entity\MenuItem | 11 |
| App\Entity\Tipocliente | 9 |
| App\Entity\Tipodocumento | 5 |
| App\Entity\GrupoListasPrecios | 5 |
| App\Entity\Tiporesponsabilidad | 5 |
| App\Entity\Resptributaria | 4 |
| App\Entity\Tipopago | 3 |
| App\Entity\Persona | 2 |
| App\Entity\User | 1 |
| App\Entity\Rol | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Persona |
|
| App\Entity\Rol | No errors. |
| App\Entity\Solicitudcobertura |
|
| App\Entity\Bloqueofactura | No errors. |
| App\Entity\QuiroPay | No errors. |
| App\Entity\Modulo | No errors. |
| App\Entity\Tipodocumento | No errors. |
| App\Entity\Municipio | No errors. |
| App\Entity\Empresa |
|
| App\Entity\Tipopago |
|
| App\Entity\GrupoListasPrecios | No errors. |
| App\Entity\Tipocliente | No errors. |
| App\Entity\Resptributaria | No errors. |
| App\Entity\Tiporesponsabilidad |
|
| App\Entity\Asistenteprofesional | No errors. |
| App\Entity\Profesionales |
|
| App\Entity\Servicio |
|
| App\Entity\Pedido |
|
| App\Entity\Departamento | No errors. |
| App\Entity\Entidad | No errors. |
| App\Entity\Profesion | No errors. |
| App\Entity\Bancos | No errors. |
| App\Entity\Tipocuenta | No errors. |
| App\Entity\Comercial | No errors. |
| App\Entity\Estadoprofesional | No errors. |
| App\Entity\Tipofacturacion | No errors. |
| App\Entity\Catalogoprecio | No errors. |
| App\Entity\TipoclienteProducto | No errors. |
| App\Entity\MenuItem | No errors. |