Query Metrics
10
Database Queries
10
Different statements
19.23 ms
Query time
8
Invalid entities
1161
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.21 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.22 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.26 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 | 0.32 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.32 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.31 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.53 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_ WHERE t0_.id IN (?)
Parameters:
[
"1"
]
|
| 8 | 0.31 ms |
"START TRANSACTION"
Parameters:
[] |
| 9 | 15.89 ms |
UPDATE persona SET primernombre = ? WHERE id = ?
Parameters:
[ "ALEJANDRO" 8291 ] |
| 10 | 0.85 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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Municipio | 1123 |
| App\Entity\Departamento | 33 |
| App\Entity\Persona | 2 |
| App\Entity\User | 1 |
| App\Entity\Rol | 1 |
| App\Entity\Tipodocumento | 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. |