Query Metrics
425
Database Queries
4
Different statements
116.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
106.08 ms (91.05%) |
422 |
SELECT t0.id AS id_1, t0.aufklaerungsgespraech_at AS aufklaerungsgespraech_at_2, t0.bisherige_therapie_allo_loco AS bisherige_therapie_allo_loco_3, t0.initialbehandlung AS initialbehandlung_4, t0.koffer_damm_klammer_nr AS koffer_damm_klammer_nr_5, t0.laengenbestimmung_bemerkung AS laengenbestimmung_bemerkung_6, t0.koronales_drittel AS koronales_drittel_7, t0.mittleres_drittel AS mittleres_drittel_8, t0.apikales_drittel AS apikales_drittel_9, t0.aufbereitungstechnik_bemerkungen AS aufbereitungstechnik_bemerkungen_10, t0.is_desinfektionsmittel_naocl AS is_desinfektionsmittel_naocl_11, t0.is_desinfektionsmittel_chx AS is_desinfektionsmittel_chx_12, t0.is_desinfektionsmittel_chelator AS is_desinfektionsmittel_chelator_13, t0.komp_at AS komp_at_14, t0.komp_symptome AS komp_symptome_15, t0.komp_therapie AS komp_therapie_16, t0.wkf_date AS wkf_date_17, t0.wkf_sealer AS wkf_sealer_18, t0.wkf_bemerkungen AS wkf_bemerkungen_19, t0.is_userfilled AS is_userfilled_20, t0.therapie_id AS therapie_id_21, t0.komp_kanal_id AS komp_kanal_id_22, t0.komp_art_id AS komp_art_id_23, t0.wkf_fuelltechnik_id AS wkf_fuelltechnik_id_24 FROM endo_therapie_bogen t0 WHERE t0.therapie_id = ?
Parameters:
[
b"_╦gìhU\x11¯£S┤.ÖjCþ"
]
|
||||||||||||||||||||||
|
8.24 ms (7.08%) |
1 |
SELECT t0.id AS id_1, t0.public AS public_2, t0.titel AS titel_3, t0.counter AS counter_4, t0.is_bewertet AS is_bewertet_5, t0.bewertung_gesehen AS bewertung_gesehen_6, t0.behandlung_von AS behandlung_von_7, t0.behandlung_bis AS behandlung_bis_8, t0.public_at AS public_at_9, t0.abgeschlossen_at AS abgeschlossen_at_10, t0.archiviert AS archiviert_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15, t0.user_id AS user_id_16, t0.fall_art_id AS fall_art_id_17, t18.id AS id_19, t18.befund_med AS befund_med_20, t18.befund_allg AS befund_allg_21, t18.befund_interoral AS befund_interoral_22, t18.kiefer_zaehne_fehlend AS kiefer_zaehne_fehlend_23, t18.kiefer_zaehne_amalgam AS kiefer_zaehne_amalgam_24, t18.kiefer_zaehne_komposit AS kiefer_zaehne_komposit_25, t18.kiefer_zaehne_krone AS kiefer_zaehne_krone_26, t18.kiefer_zaehne_karioes AS kiefer_zaehne_karioes_27, t18.kiefer_zaehne_wurzel AS kiefer_zaehne_wurzel_28, t18.kiefer_fuellungsuebergaenge AS kiefer_fuellungsuebergaenge_29, t18.kiefer_pusentleerung AS kiefer_pusentleerung_30, t18.kiefer_roetung_gingiva AS kiefer_roetung_gingiva_31, t18.kiefer_plaqueindex AS kiefer_plaqueindex_32, t18.kiefer_zahnlockerung AS kiefer_zahnlockerung_33, t18.kiefer_furkationsbefall AS kiefer_furkationsbefall_34, t18.kiefer_sulcusblutungsindex AS kiefer_sulcusblutungsindex_35, t18.kiefer_sondierungsbefund AS kiefer_sondierungsbefund_36, t18.fall_id AS fall_id_37, t38.id AS id_39, t38.bewertung AS bewertung_40, t38.punkte AS punkte_41, t38.created_at AS created_at_42, t38.updated_at AS updated_at_43, t38.created_by AS created_by_44, t38.updated_by AS updated_by_45, t38.fall_id AS fall_id_46, t38.user_id AS user_id_47, t48.id AS id_49, t48.description AS description_50, t48.fall_id AS fall_id_51, t52.id AS id_53, t52.name AS name_54, t52.alter_bei_vorstellung AS alter_bei_vorstellung_55, t52.geburtsdatum AS geburtsdatum_56, t52.behandlung_von AS behandlung_von_57, t52.behandlung_bis AS behandlung_bis_58, t52.vorname AS vorname_59, t52.fall_id AS fall_id_60, t61.id AS id_62, t61.kanaele AS kanaele_63, t61.created_at AS created_at_64, t61.updated_at AS updated_at_65, t61.created_by AS created_by_66, t61.updated_by AS updated_by_67, t61.fall_id AS fall_id_68, t69.id AS id_70, t69.datum AS datum_71, t69.spezielle_anamnese AS spezielle_anamnese_72, t69.allg_anamnese AS allg_anamnese_73, t69.erhaltungstherapie AS erhaltungstherapie_74, t69.diagnose AS diagnose_75, t69.created_at AS created_at_76, t69.updated_at AS updated_at_77, t69.created_by AS created_by_78, t69.updated_by AS updated_by_79, t69.fall_id AS fall_id_80, t81.id AS id_82, t81.datum AS datum_83, t81.zahn AS zahn_84, t81.beschwerden_seit AS beschwerden_seit_85, t81.art_der_beschwerden AS art_der_beschwerden_86, t81.schwellung_extraoral AS schwellung_extraoral_87, t81.sensibilitaetstest_art AS sensibilitaetstest_art_88, t81.sensibilitaetstest_ergebnis AS sensibilitaetstest_ergebnis_89, t81.perkussion AS perkussion_90, t81.sondierungstiefe_vestibulaer_m AS sondierungstiefe_vestibulaer_m_91, t81.sondierungstiefe_vestibulaer_f AS sondierungstiefe_vestibulaer_f_92, t81.sondierungstiefe_vestibulaer_d AS sondierungstiefe_vestibulaer_d_93, t81.sondierungstiefe_oral_m AS sondierungstiefe_oral_m_94, t81.sondierungstiefe_oral_f AS sondierungstiefe_oral_f_95, t81.sondierungstiefe_oral_d AS sondierungstiefe_oral_d_96, t81.created_at AS created_at_97, t81.updated_at AS updated_at_98, t81.created_by AS created_by_99, t81.updated_by AS updated_by_100, t81.umschlagfalte_id AS umschlagfalte_id_101, t81.lockerung_id AS lockerung_id_102, t81.fall_id AS fall_id_103, t104.id AS id_105, t104.datum AS datum_106, t104.has_allergie AS has_allergie_107, t104.text_allergie AS text_allergie_108, t104.has_asthma AS has_asthma_109, t104.text_asthma AS text_asthma_110, t104.has_anfallsleiden AS has_anfallsleiden_111, t104.text_anfallsleiden AS text_anfallsleiden_112, t104.has_depression AS has_depression_113, t104.text_depression AS text_depression_114, t104.has_diabetes AS has_diabetes_115, t104.text_diabetes AS text_diabetes_116, t104.has_blutgerinnung AS has_blutgerinnung_117, t104.text_blutgerinnung AS text_blutgerinnung_118, t104.has_bluterkrankung AS has_bluterkrankung_119, t104.text_bluterkrankung AS text_bluterkrankung_120, t104.has_herzkreislauf AS has_herzkreislauf_121, t104.text_herzkreislauf AS text_herzkreislauf_122, t104.has_herzinsuffizienz AS has_herzinsuffizienz_123, t104.text_herzinsuffizienz AS text_herzinsuffizienz_124, t104.has_koronare_herzkrankheit AS has_koronare_herzkrankheit_125, t104.text_koronare_herzkrankheit AS text_koronare_herzkrankheit_126, t104.has_herzinfarkt AS has_herzinfarkt_127, t104.text_herzinfarkt AS text_herzinfarkt_128, t104.has_herzrhythmusstoerung AS has_herzrhythmusstoerung_129, t104.text_herzrhythmusstoerung AS text_herzrhythmusstoerung_130, t104.has_herzschrittmacher AS has_herzschrittmacher_131, t104.text_herzschrittmacher AS text_herzschrittmacher_132, t104.has_herzklappenfehler AS has_herzklappenfehler_133, t104.text_herzklappenfehler AS text_herzklappenfehler_134, t104.has_erhoehter_blutdruck AS has_erhoehter_blutdruck_135, t104.text_erhoehter_blutdruck AS text_erhoehter_blutdruck_136, t104.has_niedriger_blutdruck AS has_niedriger_blutdruck_137, t104.text_niedriger_blutdruck AS text_niedriger_blutdruck_138, t104.has_erhoehte_blutfettwerte AS has_erhoehte_blutfettwerte_139, t104.text_erhoehte_blutfettwerte AS text_erhoehte_blutfettwerte_140, t104.has_schlaganfall AS has_schlaganfall_141, t104.text_schlaganfall AS text_schlaganfall_142, t104.has_infektionskrankheiten AS has_infektionskrankheiten_143, t104.text_infektionskrankheiten AS text_infektionskrankheiten_144, t104.has_hepatitis AS has_hepatitis_145, t104.text_hepatitis AS text_hepatitis_146, t104.has_tuberkulose AS has_tuberkulose_147, t104.text_tuberkulose AS text_tuberkulose_148, t104.has_hiv AS has_hiv_149, t104.text_hiv AS text_hiv_150, t104.has_atemwegserkrankungen AS has_atemwegserkrankungen_151, t104.text_atemwegserkrankungen AS text_atemwegserkrankungen_152, t104.has_glaukom AS has_glaukom_153, t104.text_glaukom AS text_glaukom_154, t104.has_lebererkrankungen AS has_lebererkrankungen_155, t104.text_lebererkrankungen AS text_lebererkrankungen_156, t104.has_magen_darm_erkrankungen AS has_magen_darm_erkrankungen_157, t104.text_magen_darm_erkrankungen AS text_magen_darm_erkrankungen_158, t104.has_nierenerkrankungen AS has_nierenerkrankungen_159, t104.text_nierenerkrankungen AS text_nierenerkrankungen_160, t104.has_chronische_niereninsuffiznenz AS has_chronische_niereninsuffiznenz_161, t104.text_chronische_niereninsuffizienz AS text_chronische_niereninsuffizienz_162, t104.has_dialyse AS has_dialyse_163, t104.text_dialyse AS text_dialyse_164, t104.has_osteoporose AS has_osteoporose_165, t104.text_osteoporose AS text_osteoporose_166, t104.has_gelenkrheuma AS has_gelenkrheuma_167, t104.text_gelenkrheuma AS text_gelenkrheuma_168, t104.has_schilddruesenfehlfunktion AS has_schilddruesenfehlfunktion_169, t104.text_schilddruesenfehlfunktion AS text_schilddruesenfehlfunktion_170, t104.has_tumorernkranungen AS has_tumorernkranungen_171, t104.text_tumorerkrankungen AS text_tumorerkrankungen_172, t104.has_fruehere_stationaere_behandlung AS has_fruehere_stationaere_behandlung_173, t104.text_fruehere_stationaere_behandlung AS text_fruehere_stationaere_behandlung_174, t104.has_schwangerschaft AS has_schwangerschaft_175, t104.text_schwangerschaft AS text_schwangerschaft_176, t104.has_zwischenfaelle_beim_zahnarzt AS has_zwischenfaelle_beim_zahnarzt_177, t104.text_zwischenfaelle_beim_zahnarzt AS text_zwischenfaelle_beim_zahnarzt_178, t104.is_zufrieden AS is_zufrieden_179, t104.is_kobehandlung AS is_kobehandlung_180, t104.is_zaehne_gewandert AS is_zaehne_gewandert_181, t104.is_mundgeruch AS is_mundgeruch_182, t104.is_locker_zaehne AS is_locker_zaehne_183, t104.is_parodontosebehandlung AS is_parodontosebehandlung_184, t104.is_blutendes_zahnfleisch AS is_blutendes_zahnfleisch_185, t104.is_zahnseide AS is_zahnseide_186, t104.is_raucher AS is_raucher_187, t104.rauchen_typ AS rauchen_typ_188, t104.rauchen_art AS rauchen_art_189, t104.rauchen_seit AS rauchen_seit_190, t104.rauchen_menge AS rauchen_menge_191, t104.rauchen_ende AS rauchen_ende_192, t104.medikamente AS medikamente_193, t104.is_kopfschmerzen AS is_kopfschmerzen_194, t104.has_covid19 AS has_covid19_195, t104.text_covid19 AS text_covid19_196, t104.created_at AS created_at_197, t104.updated_at AS updated_at_198, t104.created_by AS created_by_199, t104.updated_by AS updated_by_200, t104.fall_id AS fall_id_201 FROM fall t0 LEFT JOIN fall_befund t18 ON t18.fall_id = t0.id LEFT JOIN fall_bewertung t38 ON t38.fall_id = t0.id LEFT JOIN fall_epikrise t48 ON t48.fall_id = t0.id LEFT JOIN fall_patient t52 ON t52.fall_id = t0.id LEFT JOIN endo_therapie t61 ON t61.fall_id = t0.id LEFT JOIN anamnese_prothetik t69 ON t69.fall_id = t0.id LEFT JOIN anamnese_endo t81 ON t81.fall_id = t0.id LEFT JOIN anamnese_paro t104 ON t104.fall_id = t0.id
Parameters:
[]
|
||||||||||||||||||||||
|
1.33 ms (1.14%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.laufzeit AS laufzeit_4, t0.nachlaufzeit AS nachlaufzeit_5, t0.strasse AS strasse_6, t0.hausnummer AS hausnummer_7, t0.plz AS plz_8, t0.ort AS ort_9, t0.telefon AS telefon_10, t0.fax AS fax_11, t0.email AS email_12, t0.ansprechpartner AS ansprechpartner_13, t0.semester AS semester_14, t0.user_pro_semester AS user_pro_semester_15, t0.is_public AS is_public_16, t0.is_default AS is_default_17, t0.export AS export_18, t0.is_activated AS is_activated_19, t0.kundennummer AS kundennummer_20, t0.studierende AS studierende_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.created_by AS created_by_24, t0.updated_by AS updated_by_25, t26.id AS id_27, t26.kontoinhaber AS kontoinhaber_28, t26.bank AS bank_29, t26.iban AS iban_30, t26.bic AS bic_31, t26.created_at AS created_at_32, t26.updated_at AS updated_at_33, t26.organisation_id AS organisation_id_34 FROM organisationen t0 LEFT JOIN organisationen_payment t26 ON t26.organisation_id = t0.id
Parameters:
[]
|
||||||||||||||||||||||
|
0.85 ms (0.73%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.role AS role_3, t0.password AS password_4, t0.email AS email_5, t0.is_active AS is_active_6, t0.confirmed AS confirmed_7, t0.activated AS activated_8, t0.beginn AS beginn_9, t0.ende AS ende_10, t0.export AS export_11, t0.kundennummer AS kundennummer_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.organisation_id AS organisation_id_17, t18.id AS id_19, t18.name AS name_20, t18.description AS description_21, t18.laufzeit AS laufzeit_22, t18.nachlaufzeit AS nachlaufzeit_23, t18.strasse AS strasse_24, t18.hausnummer AS hausnummer_25, t18.plz AS plz_26, t18.ort AS ort_27, t18.telefon AS telefon_28, t18.fax AS fax_29, t18.email AS email_30, t18.ansprechpartner AS ansprechpartner_31, t18.semester AS semester_32, t18.user_pro_semester AS user_pro_semester_33, t18.is_public AS is_public_34, t18.is_default AS is_default_35, t18.export AS export_36, t18.is_activated AS is_activated_37, t18.kundennummer AS kundennummer_38, t18.studierende AS studierende_39, t18.created_at AS created_at_40, t18.updated_at AS updated_at_41, t18.created_by AS created_by_42, t18.updated_by AS updated_by_43, t0.semester_id AS semester_id_44, t45.id AS id_46, t45.kontoinhaber AS kontoinhaber_47, t45.bank AS bank_48, t45.iban AS iban_49, t45.bic AS bic_50, t45.user_id AS user_id_51, t52.id AS id_53, t52.vorname AS vorname_54, t52.nachname AS nachname_55, t52.anschrift AS anschrift_56, t52.plz AS plz_57, t52.ort AS ort_58, t52.telefon AS telefon_59, t52.fax AS fax_60, t52.anrede AS anrede_61, t52.user_id AS user_id_62, t0.locale_id AS locale_id_63 FROM user t0 INNER JOIN organisationen t18 ON t0.organisation_id = t18.id LEFT JOIN user_payment t45 ON t45.user_id = t0.id LEFT JOIN user_profile t52 ON t52.user_id = t0.id
Parameters:
[]
|
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.