https://testadnjorgedotto.com/download_report/33600

Query Metrics

68 Database Queries
7 Different statements
28.80 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
21.32 ms
(74.04%)
28
SELECT t0.id AS id_1, t0.gene AS gene_2, t0.marker AS marker_3, t0.genotype AS genotype_4, t0.answers AS answers_5, t0.bibliography AS bibliography_6, t0.note AS note_7, t0.result_subsection_id AS result_subsection_id_8 FROM result_marker t0 WHERE t0.result_subsection_id = ?
Parameters:
[
  948545
]
3.39 ms
(11.77%)
18
SELECT t0.id AS id_1, t0.markers_found AS markers_found_2, t0.bibliography AS bibliography_3, t0.answers AS answers_4, t0.aditional_text AS aditional_text_5, t0.gen AS gen_6, t0.genotype AS genotype_7, t0.note AS note_8, t0.position AS position_9, t0.subsection_id AS subsection_id_10, t11.id AS id_12, t11.title AS title_13, t11.is_automatic AS is_automatic_14, t11.markers AS markers_15, t11.bibliography AS bibliography_16, t0.result_section_id AS result_section_id_17 FROM result_subsection t0 LEFT JOIN subsection t11 ON t0.subsection_id = t11.id WHERE t0.result_section_id = ?
Parameters:
[
  208983
]
3.17 ms
(11.02%)
18
SELECT t0.id AS id_1, t0.title AS title_2, t0.path AS path_3, t0.update_at AS update_at_4 FROM section t0 WHERE t0.id = ?
Parameters:
[
  85
]
0.28 ms
(0.98%)
1
SELECT t0.id AS id_1, t0.client AS client_2, t0.show_logo_jd AS show_logo_jd_3, t0.path AS path_4, t0.update_at AS update_at_5, t0.update_create AS update_create_6, t0.column_in_txt AS column_in_txt_7, t0.status AS status_8, t0.report_generator_second_id AS report_generator_second_id_9, t0.report_logo_id AS report_logo_id_10, t0.patient_id_id AS patient_id_id_11 FROM result_report t0 WHERE t0.id = ?
Parameters:
[
  "33600"
]
0.28 ms
(0.96%)
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
]
0.19 ms
(0.65%)
1
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.date_last_modified AS date_last_modified_3, t0.report_id AS report_id_4, t0.report_generator_id AS report_generator_id_5 FROM report_generator_second t0 WHERE t0.id = ?
Parameters:
[
  8720
]
0.17 ms
(0.58%)
1
SELECT t0.id AS id_1, t0.note AS note_2, t0.order_number AS order_number_3, t0.section_id AS section_id_4, t0.result_report_id AS result_report_id_5 FROM result_section t0 WHERE t0.result_report_id = ?
Parameters:
[
  33600
]

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\ResultReport No errors.
App\Entity\ReportGeneratorSecond No errors.
App\Entity\ReportLogo No errors.
App\Entity\PatientHistory
  • The mappings App\Entity\PatientHistory#medicalReturns and App\Entity\MedicalReturn#patientId are inconsistent with each other.
App\Entity\ResultSection No errors.
App\Entity\Section No errors.
App\Entity\ResultSubsection No errors.
App\Entity\SectionReport No errors.
App\Entity\SectionSubsectionItem No errors.
App\Entity\Subsection No errors.
App\Entity\ResultMarker No errors.
App\Entity\NotFoundProcess No errors.
App\Entity\Answer No errors.
App\Entity\Report No errors.
App\Entity\ReportGenerator No errors.
App\Entity\User No errors.
App\Entity\AncestorsOrigin No errors.
App\Entity\Doctor No errors.
App\Entity\Nutritionist No errors.
App\Entity\Exams No errors.