Query Metrics
54
Database Queries
16
Different statements
21.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
10.85 ms (51.52%) |
36 |
SELECT t0.id AS id_1, t0.schulung_name AS schulung_name_2, t0.kurzbeschreibung AS kurzbeschreibung_3, t0.beschreibung AS beschreibung_4, t0.titelbild AS titelbild_5, t0.kursinhalt AS kursinhalt_6, t0.freigeben_ab AS freigeben_ab_7, t0.freigeben_bis AS freigeben_bis_8, t0.kontrollsiegel AS kontrollsiegel_9, t0.freigabe AS freigabe_10, t0.ersteller_user_id AS ersteller_user_id_11, t0.ersteller_firmen_id AS ersteller_firmen_id_12, t0.vorstellungslink AS vorstellungslink_13, t0.schulungsvideo AS schulungsvideo_14, t0.preis AS preis_15, t0.import_id AS import_id_16, t0.import_datum AS import_datum_17, t0.import_fehler AS import_fehler_18, t0.letzte_aenderung AS letzte_aenderung_19, t0.mwst AS mwst_20, t0.suchfilter AS suchfilter_21, t0.suchbegriffe AS suchbegriffe_22, t0.fremdanbieter_status AS fremdanbieter_status_23, t0.weclapp_artikel_id AS weclapp_artikel_id_24, t0.angelegt_am AS angelegt_am_25, t0.storno_in_tagen AS storno_in_tagen_26, t0.seminarreihe_startdatum AS seminarreihe_startdatum_27, t0.fremdlink_counter AS fremdlink_counter_28, t0.nur_celsisten AS nur_celsisten_29, t0.schulungsart_id AS schulungsart_id_30 FROM schulungen t0 WHERE t0.id = ?
Parameters:
[
199
]
|
|
2.89 ms (13.70%) |
1 |
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.session_id AS session_id_3, t0.datum AS datum_4, t0.schulung_id AS schulung_id_5 FROM user_favoriten t0 WHERE t0.session_id = ? AND t0.schulung_id = ? LIMIT 1
Parameters:
[ "opchjam1glofqifkatjogo985l" "729" ] |
|
1.39 ms (6.61%) |
2 |
SELECT t0.id AS id_1, t0.dozent AS dozent_2, t0.ort AS ort_3, t0.max_plaetze AS max_plaetze_4, t0.von AS von_5, t0.bis AS bis_6, t0.dauer AS dauer_7, t0.anmeldeschluss AS anmeldeschluss_8, t0.letzte_aenderung AS letzte_aenderung_9, t0.webtool AS webtool_10, t0.seminar_link AS seminar_link_11, t0.video_json AS video_json_12, t0.organizer_key AS organizer_key_13, t0.seminarreihe_schulungsart AS seminarreihe_schulungsart_14, t0.letzte_aenderung_termin AS letzte_aenderung_termin_15, t0.letzte_aenderung_schulungsort AS letzte_aenderung_schulungsort_16, t0.angelegt_am AS angelegt_am_17, t0.google_lat AS google_lat_18, t0.google_len AS google_len_19, t0.noch_plaetze_frei AS noch_plaetze_frei_20, t0.celseo_ics AS celseo_ics_21, t0.status AS status_22, t0.storniert_am AS storniert_am_23, t0.grund AS grund_24, t0.schulung_id AS schulung_id_25, t0.dozent_user_id AS dozent_user_id_26, t0.abrechnung_id AS abrechnung_id_27 FROM schulungs_termine t0 WHERE t0.schulung_id = ? ORDER BY t0.von ASC
Parameters:
[
729
]
|
|
1.19 ms (5.64%) |
1 |
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.session_id AS session_id_3, t0.username AS username_4, t0.kommentar AS kommentar_5, t0.datum AS datum_6, t0.schulung_id AS schulung_id_7 FROM schulung_kommentare t0 WHERE t0.schulung_id = ?
Parameters:
[
729
]
|
|
0.81 ms (3.85%) |
2 |
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.username AS username_3, t0.email AS email_4, t0.sterne AS sterne_5, t0.text AS text_6, t0.datum AS datum_7, t0.schulung_id AS schulung_id_8 FROM schulung_bewertungen t0 WHERE t0.schulung_id = ?
Parameters:
[
729
]
|
|
0.62 ms (2.95%) |
2 |
SELECT t0.id AS id_1, t0.dozent AS dozent_2, t0.ort AS ort_3, t0.max_plaetze AS max_plaetze_4, t0.von AS von_5, t0.bis AS bis_6, t0.dauer AS dauer_7, t0.anmeldeschluss AS anmeldeschluss_8, t0.letzte_aenderung AS letzte_aenderung_9, t0.webtool AS webtool_10, t0.seminar_link AS seminar_link_11, t0.video_json AS video_json_12, t0.organizer_key AS organizer_key_13, t0.seminarreihe_schulungsart AS seminarreihe_schulungsart_14, t0.letzte_aenderung_termin AS letzte_aenderung_termin_15, t0.letzte_aenderung_schulungsort AS letzte_aenderung_schulungsort_16, t0.angelegt_am AS angelegt_am_17, t0.google_lat AS google_lat_18, t0.google_len AS google_len_19, t0.noch_plaetze_frei AS noch_plaetze_frei_20, t0.celseo_ics AS celseo_ics_21, t0.status AS status_22, t0.storniert_am AS storniert_am_23, t0.grund AS grund_24, t0.schulung_id AS schulung_id_25, t0.dozent_user_id AS dozent_user_id_26, t0.abrechnung_id AS abrechnung_id_27 FROM schulungs_termine t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1678
]
|
|
0.51 ms (2.42%) |
1 |
SELECT t0.id AS id_1, t0.profil_art AS profil_art_2, t0.firmenname AS firmenname_3, t0.logo AS logo_4, t0.strasse AS strasse_5, t0.plz AS plz_6, t0.ort AS ort_7, t0.firmencode AS firmencode_8, t0.primarfarbe AS primarfarbe_9, t0.schriftfarbe AS schriftfarbe_10, t0.buttonfarbe AS buttonfarbe_11, t0.bild_startseite AS bild_startseite_12, t0.celseo_intranet_id AS celseo_intranet_id_13, t0.instagram AS instagram_14, t0.youtube AS youtube_15, t0.facebook AS facebook_16, t0.webseite AS webseite_17, t0.allgemeine_uploads_ordner AS allgemeine_uploads_ordner_18, t0.fremdanbieter AS fremdanbieter_19, t0.namen_sortieren AS namen_sortieren_20, t0.mailsperre AS mailsperre_21, t0.logo_klein AS logo_klein_22, t0.weclapp_kunden_id AS weclapp_kunden_id_23, t0.provision_vereinbarung AS provision_vereinbarung_24, t0.email_domains AS email_domains_25, t0.google_lat AS google_lat_26, t0.google_len AS google_len_27, t0.firmen_email AS firmen_email_28, t0.ansprechpartner_email AS ansprechpartner_email_29, t0.telefon AS telefon_30, t0.firmen_kurzwort AS firmen_kurzwort_31, t0.link_teilnahmebedingungen AS link_teilnahmebedingungen_32, t0.link_datenschutz AS link_datenschutz_33, t0.naechste_grundgebuehr AS naechste_grundgebuehr_34, t0.mitarbeiter_intern_menu_freigabe AS mitarbeiter_intern_menu_freigabe_35, t0.extra_contingent AS extra_contingent_36, t0.buchungen_email AS buchungen_email_37, t0.projekte_freigeschaltet_am AS projekte_freigeschaltet_am_38, t0.meldeportal_uuid AS meldeportal_uuid_39, t0.meldeportal_status AS meldeportal_status_40, t0.meldeportal_standorte AS meldeportal_standorte_41, t0.meldeportal_externe_ansprechpartner AS meldeportal_externe_ansprechpartner_42, t0.meldeportal_anonym_verhindern AS meldeportal_anonym_verhindern_43, t0.meldeportal_erinnerung AS meldeportal_erinnerung_44, t0.notdienst_letzte_eintraege AS notdienst_letzte_eintraege_45, t0.notdienst_filter AS notdienst_filter_46, t0.digiwerkstatt_berni_firmen_id AS digiwerkstatt_berni_firmen_id_47, t0.digiwerkstatt_berni_freigeschaltet AS digiwerkstatt_berni_freigeschaltet_48, t0.firma_boss_id AS firma_boss_id_49, t0.bild_desktop_id AS bild_desktop_id_50, t0.bild_mobile_id AS bild_mobile_id_51, t0.projekte_software_id AS projekte_software_id_52 FROM firmenprofil t0 WHERE t0.id IN (?)
Parameters:
[
34
]
|
|
0.45 ms (2.15%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.untergruppe AS untergruppe_3 FROM zielgruppe t0
Parameters:
[] |
|
0.44 ms (2.08%) |
1 |
SELECT t0.id AS id_1, t0.profil_art AS profil_art_2, t0.firmenname AS firmenname_3, t0.logo AS logo_4, t0.strasse AS strasse_5, t0.plz AS plz_6, t0.ort AS ort_7, t0.firmencode AS firmencode_8, t0.primarfarbe AS primarfarbe_9, t0.schriftfarbe AS schriftfarbe_10, t0.buttonfarbe AS buttonfarbe_11, t0.bild_startseite AS bild_startseite_12, t0.celseo_intranet_id AS celseo_intranet_id_13, t0.instagram AS instagram_14, t0.youtube AS youtube_15, t0.facebook AS facebook_16, t0.webseite AS webseite_17, t0.allgemeine_uploads_ordner AS allgemeine_uploads_ordner_18, t0.fremdanbieter AS fremdanbieter_19, t0.namen_sortieren AS namen_sortieren_20, t0.mailsperre AS mailsperre_21, t0.logo_klein AS logo_klein_22, t0.weclapp_kunden_id AS weclapp_kunden_id_23, t0.provision_vereinbarung AS provision_vereinbarung_24, t0.email_domains AS email_domains_25, t0.google_lat AS google_lat_26, t0.google_len AS google_len_27, t0.firmen_email AS firmen_email_28, t0.ansprechpartner_email AS ansprechpartner_email_29, t0.telefon AS telefon_30, t0.firmen_kurzwort AS firmen_kurzwort_31, t0.link_teilnahmebedingungen AS link_teilnahmebedingungen_32, t0.link_datenschutz AS link_datenschutz_33, t0.naechste_grundgebuehr AS naechste_grundgebuehr_34, t0.mitarbeiter_intern_menu_freigabe AS mitarbeiter_intern_menu_freigabe_35, t0.extra_contingent AS extra_contingent_36, t0.buchungen_email AS buchungen_email_37, t0.projekte_freigeschaltet_am AS projekte_freigeschaltet_am_38, t0.meldeportal_uuid AS meldeportal_uuid_39, t0.meldeportal_status AS meldeportal_status_40, t0.meldeportal_standorte AS meldeportal_standorte_41, t0.meldeportal_externe_ansprechpartner AS meldeportal_externe_ansprechpartner_42, t0.meldeportal_anonym_verhindern AS meldeportal_anonym_verhindern_43, t0.meldeportal_erinnerung AS meldeportal_erinnerung_44, t0.notdienst_letzte_eintraege AS notdienst_letzte_eintraege_45, t0.notdienst_filter AS notdienst_filter_46, t0.digiwerkstatt_berni_firmen_id AS digiwerkstatt_berni_firmen_id_47, t0.digiwerkstatt_berni_freigeschaltet AS digiwerkstatt_berni_freigeschaltet_48, t0.firma_boss_id AS firma_boss_id_49, t0.bild_desktop_id AS bild_desktop_id_50, t0.bild_mobile_id AS bild_mobile_id_51, t0.projekte_software_id AS projekte_software_id_52 FROM firmenprofil t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
16
]
|
|
0.40 ms (1.88%) |
1 |
SELECT t0.id AS id_1, t0.schulung_name AS schulung_name_2, t0.kurzbeschreibung AS kurzbeschreibung_3, t0.beschreibung AS beschreibung_4, t0.titelbild AS titelbild_5, t0.kursinhalt AS kursinhalt_6, t0.freigeben_ab AS freigeben_ab_7, t0.freigeben_bis AS freigeben_bis_8, t0.kontrollsiegel AS kontrollsiegel_9, t0.freigabe AS freigabe_10, t0.ersteller_user_id AS ersteller_user_id_11, t0.ersteller_firmen_id AS ersteller_firmen_id_12, t0.vorstellungslink AS vorstellungslink_13, t0.schulungsvideo AS schulungsvideo_14, t0.preis AS preis_15, t0.import_id AS import_id_16, t0.import_datum AS import_datum_17, t0.import_fehler AS import_fehler_18, t0.letzte_aenderung AS letzte_aenderung_19, t0.mwst AS mwst_20, t0.suchfilter AS suchfilter_21, t0.suchbegriffe AS suchbegriffe_22, t0.fremdanbieter_status AS fremdanbieter_status_23, t0.weclapp_artikel_id AS weclapp_artikel_id_24, t0.angelegt_am AS angelegt_am_25, t0.storno_in_tagen AS storno_in_tagen_26, t0.seminarreihe_startdatum AS seminarreihe_startdatum_27, t0.fremdlink_counter AS fremdlink_counter_28, t0.nur_celsisten AS nur_celsisten_29, t0.schulungsart_id AS schulungsart_id_30 FROM schulungen t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"729"
]
|
|
0.31 ms (1.47%) |
1 |
SELECT t0.id AS id_1, t0.schulung_name AS schulung_name_2, t0.kurzbeschreibung AS kurzbeschreibung_3, t0.beschreibung AS beschreibung_4, t0.titelbild AS titelbild_5, t0.kursinhalt AS kursinhalt_6, t0.freigeben_ab AS freigeben_ab_7, t0.freigeben_bis AS freigeben_bis_8, t0.kontrollsiegel AS kontrollsiegel_9, t0.freigabe AS freigabe_10, t0.ersteller_user_id AS ersteller_user_id_11, t0.ersteller_firmen_id AS ersteller_firmen_id_12, t0.vorstellungslink AS vorstellungslink_13, t0.schulungsvideo AS schulungsvideo_14, t0.preis AS preis_15, t0.import_id AS import_id_16, t0.import_datum AS import_datum_17, t0.import_fehler AS import_fehler_18, t0.letzte_aenderung AS letzte_aenderung_19, t0.mwst AS mwst_20, t0.suchfilter AS suchfilter_21, t0.suchbegriffe AS suchbegriffe_22, t0.fremdanbieter_status AS fremdanbieter_status_23, t0.weclapp_artikel_id AS weclapp_artikel_id_24, t0.angelegt_am AS angelegt_am_25, t0.storno_in_tagen AS storno_in_tagen_26, t0.seminarreihe_startdatum AS seminarreihe_startdatum_27, t0.fremdlink_counter AS fremdlink_counter_28, t0.nur_celsisten AS nur_celsisten_29, t0.schulungsart_id AS schulungsart_id_30 FROM schulungen t0 WHERE t0.id IN (?)
Parameters:
[
140
]
|
|
0.30 ms (1.42%) |
1 |
SELECT t0.id AS id_1, t0.vorname AS vorname_2, t0.nachname AS nachname_3, t0.profilbild AS profilbild_4, t0.telefon AS telefon_5, t0.mobil AS mobil_6, t0.newsletter AS newsletter_7, t0.plz AS plz_8, t0.ort AS ort_9, t0.strasse AS strasse_10, t0.firmenposition AS firmenposition_11, t0.aufgenommen_von AS aufgenommen_von_12, t0.aufgenommen_am AS aufgenommen_am_13, t0.mailversand AS mailversand_14, t0.email_anzeigen AS email_anzeigen_15, t0.google_lat AS google_lat_16, t0.google_len AS google_len_17, t0.geburtsdatum AS geburtsdatum_18, t0.celseo_support_freigabe AS celseo_support_freigabe_19, t0.user_id AS user_id_20, t0.anrede_id AS anrede_id_21 FROM user_profil t0 WHERE t0.user_id IN (?)
Parameters:
[
6
]
|
|
0.27 ms (1.30%) |
1 |
SELECT t0.id AS id_1, t0.suchbegriffe AS suchbegriffe_2, t0.loeschdatum AS loeschdatum_3, t0.nur_celsisten AS nur_celsisten_4, t0.schulung_id AS schulung_id_5 FROM schulungsfilterung t0
Parameters:
[] |
|
0.24 ms (1.15%) |
1 |
SELECT t0.id AS id_1, t0.schulung_id AS schulung_id_2, t0.user_id AS user_id_3 FROM schulung_beobachten t0 WHERE t0.schulung_id = ? AND t0.user_id IS NULL LIMIT 1
Parameters:
[
729
]
|
|
0.21 ms (0.97%) |
1 |
SELECT t0.id AS id_1, t0.thema AS thema_2, t0.untergruppe AS untergruppe_3 FROM konfigurator_themen t0
Parameters:
[] |
|
0.19 ms (0.89%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.reihenfolge AS reihenfolge_3, t0.untergruppe AS untergruppe_4 FROM schulungs_art t0
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\UserFavoriten | No errors. |
| App\Entity\Schulungen | No errors. |
| App\Entity\SchulungsArt | No errors. |
| App\Entity\SchulungsTermine | No errors. |
| App\Entity\SchulungZuweisen | No errors. |
| App\Entity\SchulungKommentare | No errors. |
| App\Entity\SchulungBewertungen | No errors. |
| App\Entity\SchulungWerbung | No errors. |
| App\Entity\Schulungsfilter | No errors. |
| App\Entity\Schulungsfilterung | No errors. |
| App\Entity\SchulungBeobachten | No errors. |
| App\Entity\User | No errors. |
| App\Entity\BhFremdschulungenAbrechnung | No errors. |
| App\Entity\BuchungenSeminare | No errors. |
| App\Entity\UploadProzess | No errors. |
| App\Entity\SchulungsTermineAenderung | No errors. |
| App\Entity\BuchungenSeminareTeilnehmerLogin | No errors. |
| App\Entity\SchulungsTermineStornierungen | No errors. |
| App\Entity\Firmenprofil | No errors. |
| App\Entity\FirmenprofilDesign | No errors. |
| App\Entity\FirmenProjekteMitgliederSoftware | No errors. |
| App\Entity\FirmenDateimanager | No errors. |
| App\Entity\FirmenMitgliederanfrage | No errors. |
| App\Entity\FirmenDokumente | No errors. |
| App\Entity\FirmenVideos | No errors. |
| App\Entity\FirmenDateien | No errors. |
| App\Entity\FirmenNews | No errors. |
| App\Entity\FirmenBlog | No errors. |
| App\Entity\Buchungen | No errors. |
| App\Entity\Gutscheincodes | No errors. |
| App\Entity\GotoOrganisatoren | No errors. |
| App\Entity\FirmenGruppen | No errors. |
| App\Entity\FirmenInterneSchulungen | No errors. |
| App\Entity\FirmenDokumenteRubriken | No errors. |
| App\Entity\BhFirmenWeclappRechnungen | No errors. |
| App\Entity\UserEmpfehlungen | No errors. |
| App\Entity\FirmenUmfragen | No errors. |
| App\Entity\FirmenProjekteKunden | No errors. |
| App\Entity\FirmenProjekte | No errors. |
| App\Entity\FirmenProjekteArbeitsstundenExport | No errors. |
| App\Entity\Meldeportal | No errors. |
| App\Entity\Notdienst | No errors. |
| App\Entity\NotdienstFarbe | No errors. |
| App\Entity\Zielgruppe | No errors. |
| App\Entity\KonfiguratorThemen | No errors. |
| App\Entity\UserProfil | No errors. |
| App\Entity\UserAnrede | No errors. |