Query Metrics
6
Database Queries
6
Different statements
2.59 ms
Query time
0
Invalid entities
49
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.61 ms |
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"
]
|
| 2 | 0.32 ms |
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:
[
"2e6a314e-9afe-4300-842b-8a338ec1b111"
]
|
| 3 | 0.33 ms |
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:
[
"366179c8-88ca-11ee-940f-001a4aa86950"
]
|
| 4 | 0.80 ms |
SELECT s0_.username AS username_0, s0_.username_canonical AS username_canonical_1, s0_.email AS email_2, s0_.email_canonical AS email_canonical_3, s0_.enabled AS enabled_4, s0_.salt AS salt_5, s0_.password AS password_6, s0_.last_login AS last_login_7, s0_.confirmation_token AS confirmation_token_8, s0_.password_requested_at AS password_requested_at_9, s0_.roles AS roles_10, s0_.created_at AS created_at_11, s0_.updated_at AS updated_at_12, s0_.id AS id_13, s0_.nombre AS nombre_14, s0_.apellido AS apellido_15, s0_.documento_identidad AS documento_identidad_16, s0_.created_by AS created_by_17, s0_.updated_by AS updated_by_18 FROM sonata_user s0_ WHERE LOWER(s0_.roles) LIKE ? ORDER BY s0_.username ASC
Parameters:
[
"%ROLE_DOCTOR%"
]
|
| 5 | 0.28 ms |
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:
[
"deb5e33d-1e38-4546-b99c-0670e4b5bcef"
]
|
| 6 | 0.24 ms |
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:
[
"404e3b67-88cd-11ee-940f-001a4aa86950"
]
|
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 | 45 |
| App\Entity\Cita | 1 |
| App\Entity\Paciente | 1 |
| App\Entity\MotivoCita | 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\AnalisisPacienteResultado | No errors. |
| App\Entity\PresupuestoDetalle | No errors. |
| App\Entity\Prestacion | No errors. |
| App\Entity\Plan | No errors. |
| App\Entity\Cuota | No errors. |
| App\Entity\AnalisisCosto | No errors. |