Query Metrics
68
Database Queries
7
Different statements
28.80 ms
Query time
1
Invalid entities
Grouped Statements
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 |
|
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. |