Query Metrics
6
Database Queries
6
Different statements
2.32 ms
Query time
0
Invalid entities
7
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.55 ms (23.62%) |
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:
[
"7878d3b0-2e2b-47c6-b70d-01315b3ea86e"
]
|
|
0.43 ms (18.53%) |
1 |
SELECT t0.id AS id_1, t0.inicio AS inicio_2, t0.fin AS fin_3, t0.estado AS estado_4, t0.reagendada AS reagendada_5, t0.revision AS revision_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.doctor_id AS doctor_id_11, t0.paciente_id AS paciente_id_12, t0.motivo_cita_id AS motivo_cita_id_13, t14.id AS id_15, t14.peso AS peso_16, t14.estatura AS estatura_17, t14.temperatura AS temperatura_18, t14.presion AS presion_19, t14.comentarios AS comentarios_20, t14.receta AS receta_21, t14.indicaciones AS indicaciones_22, t14.estudios AS estudios_23, t14.revision AS revision_24, t14.created_at AS created_at_25, t14.updated_at AS updated_at_26, t14.created_by AS created_by_27, t14.updated_by AS updated_by_28, t14.cita_id AS cita_id_29, t0.presupuesto_id AS presupuesto_id_30 FROM cita t0 LEFT JOIN consulta t14 ON t14.cita_id = t0.id WHERE t0.id = ?
Parameters:
[
"b25cd13c-db55-4afe-9210-efacf6e78f03"
]
|
|
0.37 ms (15.74%) |
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 = ?
Parameters:
[
"f2d78fae-ba21-4986-8c7c-27a7c176d9d7"
]
|
|
0.33 ms (14.39%) |
1 |
SELECT t0.id AS id_1, t0.revision AS revision_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.paciente_id AS paciente_id_7 FROM presupuesto t0 WHERE t0.id = ?
Parameters:
[
"5ae2fd84-0070-42fe-a9e2-4a913fba916e"
]
|
|
0.33 ms (14.23%) |
1 |
SELECT t0.id AS id_1, t0.ci AS ci_2, t0.nombre AS nombre_3, t0.apellido AS apellido_4, t0.telefono AS telefono_5, t0.celular AS celular_6, t0.email AS email_7, t0.codigo AS codigo_8, t0.sexo AS sexo_9, t0.grupo_sanguineo AS grupo_sanguineo_10, t0.direccion AS direccion_11, t0.alergias AS alergias_12, t0.informacion_adicional AS informacion_adicional_13, t0.fecha_nacimiento AS fecha_nacimiento_14, t0.como_llego AS como_llego_15, t0.revision AS revision_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.created_by AS created_by_19, t0.updated_by AS updated_by_20, t0.tipo_cliente_id AS tipo_cliente_id_21, t0.titular_id AS titular_id_22 FROM paciente t0 WHERE t0.id = ?
Parameters:
[
"b980f67d-9880-46c7-8075-cdecd89d7e66"
]
|
|
0.31 ms (13.50%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.costo AS costo_3, t0.activo AS activo_4, t0.tipo_cita AS tipo_cita_5, t0.revision AS revision_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM motivo_cita t0 WHERE t0.id = ?
Parameters:
[
"e3a3b33d-841f-4251-8823-cf52404b50c1"
]
|
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\SonataUserUser | 2 |
| App\Entity\Cita | 1 |
| App\Entity\Paciente | 1 |
| App\Entity\MotivoCita | 1 |
| App\Entity\Presupuesto | 1 |
| App\Entity\TipoCliente | 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\Paciente | No errors. |
| App\Entity\MotivoCita | No errors. |
| App\Entity\Consulta | No errors. |
| App\Entity\Presupuesto | No errors. |
| App\Entity\CitaPrestacion | No errors. |
| App\Entity\TipoCliente | No errors. |
| App\Entity\Vacuna | No errors. |
| App\Entity\Antecedente | No errors. |
| App\Entity\Contrato | No errors. |
| App\Entity\ContratoAdherente | No errors. |
| App\Entity\PresupuestoDetalle | No errors. |