Query Metrics
6
Database Queries
6
Different statements
2.44 ms
Query time
0
Invalid entities
18
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.54 ms (22.02%) |
1 |
SELECT count(DISTINCT c0_.id) AS sclr_0 FROM cuota c0_ LEFT JOIN contrato c1_ ON c0_.contrato_id = c1_.id WHERE c1_.id = ?
Parameters:
[
"b5703e0a-2cba-4d58-ac6c-86786c4aecbd"
]
|
|
0.49 ms (20.02%) |
1 |
SELECT c0_.id AS id_0, c0_.numero AS numero_1, c0_.monto AS monto_2, c0_.fecha_vencimiento AS fecha_vencimiento_3, c0_.fecha_cobro AS fecha_cobro_4, c0_.revision AS revision_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.created_by AS created_by_8, c0_.updated_by AS updated_by_9, c0_.contrato_id AS contrato_id_10 FROM cuota c0_ LEFT JOIN contrato c1_ ON c0_.contrato_id = c1_.id WHERE c1_.id = ? AND c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY c0_.numero ASC, c0_.id ASC
Parameters:
[ "b5703e0a-2cba-4d58-ac6c-86786c4aecbd" "ac4e9b16-f8cc-4648-921f-fb695e44cf54" "89f22fbc-ab29-4435-b28d-ce8d7692feb1" "a5cff9de-13a9-4b48-a6c5-b89774a899a4" "47b2babd-b607-4a11-8bc8-50b9cd73bc49" "7b6519cf-6ce8-4b7a-8dc9-c8df90443d89" "60ccf385-bb17-49aa-8fa1-6e9a691560a8" "8731838b-2897-4600-abeb-a90a85be2a24" "c7d73a6f-772c-442a-954c-9f99184d971e" "131f3e16-16a5-4c81-a5c8-71e9dca223c9" "3a17848d-5292-498a-8cb8-4721b4cafb6c" "a89d59bd-0c39-4a65-9532-7228692859e4" "bfa52eaf-651b-40d4-9ba6-0e3a61bd179f" ] |
|
0.47 ms (19.32%) |
1 |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14, t0.nombre AS nombre_15, t0.apellido AS apellido_16, t0.documento_identidad AS documento_identidad_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19 FROM sonata_user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"de2e1078-7e3c-4caf-912a-c255c832bf9c"
]
|
|
0.35 ms (14.23%) |
1 |
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.fecha_inicio AS fecha_inicio_3, t0.fecha_fin AS fecha_fin_4, t0.estado AS estado_5, t0.monto_total AS monto_total_6, t0.monto_cuota AS monto_cuota_7, t0.cantidad_cuotas AS cantidad_cuotas_8, t0.fecha_firma_contrato AS fecha_firma_contrato_9, t0.monto_cuota_adherente AS monto_cuota_adherente_10, t0.monto_cuota_menor_edad AS monto_cuota_menor_edad_11, t0.revision AS revision_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.paciente_id AS paciente_id_17, t0.plan_id AS plan_id_18 FROM contrato t0 WHERE t0.id = ?
Parameters:
[
"b5703e0a-2cba-4d58-ac6c-86786c4aecbd"
]
|
|
0.35 ms (14.20%) |
1 |
SELECT DISTINCT c0_.id AS id_0, c0_.numero AS numero_1, c0_.id AS id_2 FROM cuota c0_ LEFT JOIN contrato c1_ ON c0_.contrato_id = c1_.id WHERE c1_.id = ? ORDER BY c0_.numero ASC, c0_.id ASC LIMIT 25
Parameters:
[
"b5703e0a-2cba-4d58-ac6c-86786c4aecbd"
]
|
|
0.25 ms (10.21%) |
1 |
SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.revision AS revision_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.contrato_id AS contrato_id_8, t0.adherente_id AS adherente_id_9 FROM contrato_adherente t0 WHERE t0.contrato_id = ?
Parameters:
[
"b5703e0a-2cba-4d58-ac6c-86786c4aecbd"
]
|
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\Cuota | 12 |
| App\Entity\Paciente | 2 |
| App\Entity\SonataUserUser | 1 |
| App\Entity\Contrato | 1 |
| App\Entity\Plan | 1 |
| App\Entity\ContratoAdherente | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| Sonata\UserBundle\Entity\BaseUser | No errors. |
| App\Entity\SonataUserUser | No errors. |
| App\Entity\Cita | No errors. |
| App\Entity\AnalisisPaciente | No errors. |
| App\Entity\Contrato | No errors. |
| App\Entity\Paciente | No errors. |
| App\Entity\Plan | No errors. |
| App\Entity\Cuota | No errors. |
| App\Entity\ContratoAdherente | No errors. |