Query Metrics
5
Database Queries
5
Different statements
4.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.77 ms (39.14%) |
1 |
SELECT p0_.id AS id_0, p0_.cantidad_pagada AS cantidad_pagada_1, p0_.id_pagos AS id_pagos_2, p0_.id_menu AS id_menu_3, p0_.id_cuenta AS id_cuenta_4 FROM contabilidad.pago_cuenta p0_ WHERE p0_.id IN (SELECT MIN(p1_.id) AS sclr_5 FROM contabilidad.pago_cuenta p1_ INNER JOIN comercio.cuenta c2_ ON p1_.id_cuenta = c2_.id WHERE c2_.id = ? GROUP BY p1_.id_pagos)
Parameters:
[
"3893"
]
|
|
1.10 ms (24.33%) |
1 |
SELECT t0.id AS id_1, t0.usuario AS usuario_2, t0.password AS password_3, t0.usuario_gmail AS usuario_gmail_4, t0.activo AS activo_5, t0.bloqueado AS bloqueado_6, t0.super_admin AS super_admin_7, t0.nueva_clave AS nueva_clave_8, t0.id_usuario_modificacion AS id_usuario_modificacion_9, t0.fecha_modificacion AS fecha_modificacion_10, t0.ip_modificacion AS ip_modificacion_11, t0.id_persona AS id_persona_12 FROM seguridades.usuario t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.78 ms (17.19%) |
1 |
SELECT t0.id AS id_1, t0.valor AS valor_2, t0.id_usuario_modificacion AS id_usuario_modificacion_3, t0.fecha_modificacion AS fecha_modificacion_4, t0.ip_modificacion AS ip_modificacion_5, t0.id_medio_pago AS id_medio_pago_6, t0.id_pagos AS id_pagos_7, t0.id_entidad_financiera AS id_entidad_financiera_8 FROM contabilidad.detalle_pagos t0 WHERE t0.id_pagos = ?
Parameters:
[
3821
]
|
|
0.44 ms (9.77%) |
1 |
SELECT t0.id AS id_1, t0.nombre_original AS nombre_original_2, t0.nombre_almacenado AS nombre_almacenado_3, t0.tamanio AS tamanio_4, t0.url AS url_5, t0.imagen AS imagen_6, t0.estado AS estado_7, t0.id_usuario_modificacion AS id_usuario_modificacion_8, t0.fecha_modificacion AS fecha_modificacion_9, t0.ip_modificacion AS ip_modificacion_10 FROM documentos.carga_documento t0 WHERE t0.id = ?
Parameters:
[
2790
]
|
|
0.43 ms (9.57%) |
1 |
SELECT t0.id AS id_1, t0.id_usuario_modificacion AS id_usuario_modificacion_2, t0.fecha_modificacion AS fecha_modificacion_3, t0.ip_modificacion AS ip_modificacion_4, t0.id_carga_documento AS id_carga_documento_5, t0.id_detalle_pagos AS id_detalle_pagos_6 FROM documentos.documentos_detalle_pagos t0 WHERE t0.id_detalle_pagos = ? LIMIT 1
Parameters:
[
4316
]
|
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\Seguridades\Usuario | No errors. |
| App\Entity\Persona\Persona | No errors. |
| App\Entity\Contabilidad\PagoCuenta | No errors. |
| App\Entity\Comercio\Cuenta | No errors. |
| App\Entity\Contabilidad\Pagos | No errors. |
| App\Entity\Producto\Menu | No errors. |
| App\Entity\Contabilidad\DetallePagos | No errors. |
| App\Entity\Catalogos\MedioPago | No errors. |
| App\Entity\Catalogos\EntidadFinanciera | No errors. |
| App\Entity\Documentos\DocumentosDetallePagos | No errors. |
| App\Entity\Documentos\CargaDocumento | No errors. |