https://testadnjorgedotto.com/download_report/33600

Method
GET
HTTP Status
200
IP
200.61.165.14
Profiled on
Token
e91945

Query Metrics

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

Queries

Group similar statements

#▲ Time Info
1 0.28 ms 
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"
]
View formatted query    View runnable query    Explain query
2 0.17 ms 
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
]
View formatted query    View runnable query    Explain query
3 0.15 ms 
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
]
View formatted query    View runnable query    Explain query
4 0.17 ms 
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
]
View formatted query    View runnable query    Explain query
5 4.68 ms 
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
]
View formatted query    View runnable query    Explain query
6 0.30 ms 
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: 
[
  948542
]
View formatted query    View runnable query    Explain query
7 0.31 ms 
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: 
[
  948540
]
View formatted query    View runnable query    Explain query
8 0.29 ms 
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: 
[
  948544
]
View formatted query    View runnable query    Explain query
9 0.32 ms 
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: 
[
  948543
]
View formatted query    View runnable query    Explain query
10 0.36 ms 
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: 
[
  948541
]
View formatted query    View runnable query    Explain query
11 0.18 ms 
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: 
[
  86
]
View formatted query    View runnable query    Explain query
12 0.19 ms 
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: 
[
  208987
]
View formatted query    View runnable query    Explain query
13 4.15 ms 
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: 
[
  948549
]
View formatted query    View runnable query    Explain query
14 0.20 ms 
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: 
[
  87
]
View formatted query    View runnable query    Explain query
15 0.22 ms 
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: 
[
  208992
]
View formatted query    View runnable query    Explain query
16 1.54 ms 
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: 
[
  948556
]
View formatted query    View runnable query    Explain query
17 0.18 ms 
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: 
[
  112
]
View formatted query    View runnable query    Explain query
18 0.20 ms 
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: 
[
  208989
]
View formatted query    View runnable query    Explain query
19 0.49 ms 
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: 
[
  948552
]
View formatted query    View runnable query    Explain query
20 0.17 ms 
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: 
[
  88
]
View formatted query    View runnable query    Explain query
21 0.17 ms 
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: 
[
  208984
]
View formatted query    View runnable query    Explain query
22 0.30 ms 
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: 
[
  948546
]
View formatted query    View runnable query    Explain query
23 0.16 ms 
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: 
[
  113
]
View formatted query    View runnable query    Explain query
24 0.17 ms 
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: 
[
  208981
]
View formatted query    View runnable query    Explain query
25 0.37 ms 
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: 
[
  948537
]
View formatted query    View runnable query    Explain query
26 0.53 ms 
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: 
[
  948538
]
View formatted query    View runnable query    Explain query
27 0.19 ms 
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: 
[
  81
]
View formatted query    View runnable query    Explain query
28 0.19 ms 
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: 
[
  208990
]
View formatted query    View runnable query    Explain query
29 0.30 ms 
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: 
[
  948554
]
View formatted query    View runnable query    Explain query
30 0.32 ms 
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: 
[
  948553
]
View formatted query    View runnable query    Explain query
31 0.16 ms 
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: 
[
  110
]
View formatted query    View runnable query    Explain query
32 0.18 ms 
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: 
[
  208996
]
View formatted query    View runnable query    Explain query
33 0.29 ms 
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: 
[
  948561
]
View formatted query    View runnable query    Explain query
34 0.16 ms 
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: 
[
  111
]
View formatted query    View runnable query    Explain query
35 0.19 ms 
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: 
[
  208980
]
View formatted query    View runnable query    Explain query
36 0.34 ms 
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: 
[
  948535
]
View formatted query    View runnable query    Explain query
37 0.73 ms 
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: 
[
  948536
]
View formatted query    View runnable query    Explain query
38 0.18 ms 
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: 
[
  89
]
View formatted query    View runnable query    Explain query
39 0.18 ms 
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: 
[
  208994
]
View formatted query    View runnable query    Explain query
40 0.79 ms 
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: 
[
  948558
]
View formatted query    View runnable query    Explain query
41 0.17 ms 
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: 
[
  74
]
View formatted query    View runnable query    Explain query
42 0.18 ms 
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: 
[
  208995
]
View formatted query    View runnable query    Explain query
43 0.49 ms 
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: 
[
  948560
]
View formatted query    View runnable query    Explain query
44 0.33 ms 
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: 
[
  948559
]
View formatted query    View runnable query    Explain query
45 0.19 ms 
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: 
[
  76
]
View formatted query    View runnable query    Explain query
46 0.20 ms 
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: 
[
  208986
]
View formatted query    View runnable query    Explain query
47 0.35 ms 
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: 
[
  948548
]
View formatted query    View runnable query    Explain query
48 0.17 ms 
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: 
[
  75
]
View formatted query    View runnable query    Explain query
49 0.18 ms 
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: 
[
  208985
]
View formatted query    View runnable query    Explain query
50 0.78 ms 
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: 
[
  948547
]
View formatted query    View runnable query    Explain query
51 0.21 ms 
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: 
[
  77
]
View formatted query    View runnable query    Explain query
52 0.21 ms 
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: 
[
  208991
]
View formatted query    View runnable query    Explain query
53 0.60 ms 
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: 
[
  948555
]
View formatted query    View runnable query    Explain query
54 0.18 ms 
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: 
[
  78
]
View formatted query    View runnable query    Explain query
55 0.19 ms 
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: 
[
  208982
]
View formatted query    View runnable query    Explain query
56 0.31 ms 
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: 
[
  948539
]
View formatted query    View runnable query    Explain query
57 0.17 ms 
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: 
[
  79
]
View formatted query    View runnable query    Explain query
58 0.19 ms 
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: 
[
  208988
]
View formatted query    View runnable query    Explain query
59 1.08 ms 
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: 
[
  948550
]
View formatted query    View runnable query    Explain query
60 0.32 ms 
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: 
[
  948551
]
View formatted query    View runnable query    Explain query
61 0.18 ms 
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: 
[
  80
]
View formatted query    View runnable query    Explain query
62 0.21 ms 
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: 
[
  208993
]
View formatted query    View runnable query    Explain query
63 0.32 ms 
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: 
[
  948557
]
View formatted query    View runnable query    Explain query
64 0.17 ms 
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: 
[
  84
]
View formatted query    View runnable query    Explain query
65 0.18 ms 
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: 
[
  208979
]
View formatted query    View runnable query    Explain query
66 0.31 ms 
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: 
[
  948534
]
View formatted query    View runnable query    Explain query
67 0.19 ms 
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
]
View formatted query    View runnable query    Explain query
68 0.28 ms 
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
]
View formatted query    View runnable query    Explain query

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.