https://testadnjorgedotto.com/upload/reports/by/clients?menuIndex=2&submenuIndex=-1

Query Metrics

1 Database Queries
1 Different statements
0.53 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.53 ms
(100.00%)
1
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.enabled AS enabled_6, t0.is_verified AS is_verified_7, t8.id AS id_9, t8.name AS name_10, t8.surname AS surname_11, t8.telephone_contact AS telephone_contact_12, t8.date_of_birth AS date_of_birth_13, t8.gender AS gender_14, t8.curreny_country AS curreny_country_15, t8.current_province AS current_province_16, t8.current_location AS current_location_17, t8.country_of_origin AS country_of_origin_18, t8.dni AS dni_19, t8.comments AS comments_20, t8.surgery AS surgery_21, t8.take_medications AS take_medications_22, t8.customer_appointments AS customer_appointments_23, t8.all_data AS all_data_24, t8.maternal_origin_id AS maternal_origin_id_25, t8.paternal_origin_id AS paternal_origin_id_26, t8.id_user_id AS id_user_id_27, t28.id AS id_29, t28.privder_id AS privder_id_30, t28.service_id AS service_id_31, t28.nombre AS nombre_32, t28.apellido AS apellido_33, t28.telefono AS telefono_34, t28.user_id AS user_id_35, t36.id AS id_37, t36.name AS name_38, t36.surname AS surname_39, t36.phone AS phone_40, t36.user_id AS user_id_41 FROM user t0 LEFT JOIN patient_history t8 ON t8.id_user_id = t0.id LEFT JOIN doctor t28 ON t28.user_id = t0.id LEFT JOIN nutritionist t36 ON t36.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  1
]

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\User No errors.
App\Entity\PatientHistory
  • The mappings App\Entity\PatientHistory#medicalReturns and App\Entity\MedicalReturn#patientId are inconsistent with each other.
App\Entity\AncestorsOrigin No errors.
App\Entity\Doctor No errors.
App\Entity\Nutritionist No errors.
App\Entity\Exams No errors.
App\Entity\Answer No errors.
App\Entity\AssignQuestionnaireToPatient No errors.
App\Entity\Medicine No errors.
App\Entity\PatientSurgery No errors.
App\Entity\Questionnaire No errors.
App\Entity\RecordfamilyAndPersonal No errors.
App\Entity\Report No errors.
App\Entity\ReportGenerator No errors.
App\Entity\ReportGeneratorSecond No errors.
App\Entity\Result No errors.
App\Entity\ResultReport No errors.
App\Entity\Section No errors.
App\Entity\Subsection No errors.
App\Entity\TurnosJorje No errors.