Query Metrics
11
Database Queries
11
Different statements
83.85 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 15.05 ms |
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 = ?
Parameters:
[
"5h2i296gag8hhe8v1lrgbeq5rk"
]
|
| 2 | 0.89 ms |
SELECT s0_.id AS id_0, s0_.aktiv AS aktiv_1, s0_.von AS von_2, s0_.bis AS bis_3, s0_.schulung_id AS schulung_id_4 FROM schulung_werbung s0_ INNER JOIN schulungen s1_ ON s0_.schulung_id = s1_.id WHERE s1_.freigabe = 1 AND s0_.aktiv = 1 AND s0_.von <= ? AND s0_.bis >= ? ORDER BY RAND() ASC LIMIT 3
Parameters:
[ "2025-01-18 00:21:04" "2025-01-18 00:21:04" ] |
| 3 | 5.66 ms |
SELECT s0_.id AS id_0, s0_.dozent AS dozent_1, s0_.ort AS ort_2, s0_.max_plaetze AS max_plaetze_3, s0_.von AS von_4, s0_.bis AS bis_5, s0_.dauer AS dauer_6, s0_.anmeldeschluss AS anmeldeschluss_7, s0_.letzte_aenderung AS letzte_aenderung_8, s0_.webtool AS webtool_9, s0_.seminar_link AS seminar_link_10, s0_.video_json AS video_json_11, s0_.organizer_key AS organizer_key_12, s0_.seminarreihe_schulungsart AS seminarreihe_schulungsart_13, s0_.letzte_aenderung_termin AS letzte_aenderung_termin_14, s0_.letzte_aenderung_schulungsort AS letzte_aenderung_schulungsort_15, s0_.angelegt_am AS angelegt_am_16, s0_.google_lat AS google_lat_17, s0_.google_len AS google_len_18, s0_.noch_plaetze_frei AS noch_plaetze_frei_19, s0_.celseo_ics AS celseo_ics_20, s0_.status AS status_21, s0_.storniert_am AS storniert_am_22, s0_.grund AS grund_23, s0_.schulung_id AS schulung_id_24, s0_.dozent_user_id AS dozent_user_id_25, s0_.abrechnung_id AS abrechnung_id_26 FROM schulungs_termine s0_ INNER JOIN schulungen s1_ ON s0_.schulung_id = s1_.id WHERE s1_.freigabe = 1 AND s1_.nur_celsisten <= 0 AND s0_.seminarreihe_schulungsart <> 1 AND s0_.von >= ? AND (s0_.anmeldeschluss IS NULL OR s0_.anmeldeschluss >= ?) ORDER BY s0_.von ASC LIMIT 10
Parameters:
[ "2025-01-18 00:21:04" "2025-01-18 00:21:04" ] |
| 4 | 55.70 ms |
SELECT t0.id AS id_1, t0.roles AS roles_2, t0.password AS password_3, t0.email AS email_4, t0.freigeschaltet AS freigeschaltet_5, t0.guid AS guid_6, t0.angelegt_am AS angelegt_am_7, t0.letzter_login AS letzter_login_8, t0.neue_roles AS neue_roles_9, t0.google_id AS google_id_10, t0.google_email AS google_email_11, t0.facebook_id AS facebook_id_12, t0.facebook_email AS facebook_email_13, t0.apple_id AS apple_id_14, t0.apple_email AS apple_email_15, t0.instagram_id AS instagram_id_16, t0.instagram_email AS instagram_email_17, t0.celseo_intranet_id AS celseo_intranet_id_18, t0.aenderungsindex AS aenderungsindex_19, t0.aenderung AS aenderung_20, t0.zwei_faktor AS zwei_faktor_21, t0.einstellungen AS einstellungen_22, t0.weclapp_kunden_id AS weclapp_kunden_id_23, t0.provisorischer_mitarbeiter AS provisorischer_mitarbeiter_24, t0.campus_update AS campus_update_25, t0.digiwerkstatt_berni_uuid AS digiwerkstatt_berni_uuid_26, t27.id AS id_28, t27.vorname AS vorname_29, t27.nachname AS nachname_30, t27.profilbild AS profilbild_31, t27.telefon AS telefon_32, t27.mobil AS mobil_33, t27.newsletter AS newsletter_34, t27.plz AS plz_35, t27.ort AS ort_36, t27.strasse AS strasse_37, t27.firmenposition AS firmenposition_38, t27.aufgenommen_von AS aufgenommen_von_39, t27.aufgenommen_am AS aufgenommen_am_40, t27.mailversand AS mailversand_41, t27.email_anzeigen AS email_anzeigen_42, t27.google_lat AS google_lat_43, t27.google_len AS google_len_44, t27.geburtsdatum AS geburtsdatum_45, t27.celseo_support_freigabe AS celseo_support_freigabe_46, t27.user_id AS user_id_47, t27.anrede_id AS anrede_id_48, t0.firmen_profil_boss_id AS firmen_profil_boss_id_49, t0.firmen_profil_id AS firmen_profil_id_50, t51.id AS id_52, t51.beschreibung AS beschreibung_53, t51.telefon AS telefon_54, t51.email AS email_55, t51.facebook AS facebook_56, t51.instagram AS instagram_57, t51.youtube AS youtube_58, t51.vorstellungsvideo AS vorstellungsvideo_59, t51.user_id AS user_id_60 FROM user t0 LEFT JOIN user_profil t27 ON t27.user_id = t0.id LEFT JOIN dozent t51 ON t51.user_id = t0.id
Parameters:
[] |
| 5 | 0.78 ms |
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:
[] |
| 6 | 0.48 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.untergruppe AS untergruppe_3 FROM zielgruppe t0
Parameters:
[] |
| 7 | 2.43 ms |
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
Parameters:
[] |
| 8 | 0.98 ms |
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.titel AS titel_3, t0.text AS text_4, t0.datum AS datum_5, t0.aktiv AS aktiv_6, t0.titelbild AS titelbild_7, t0.quote AS quote_8, t0.text2 AS text2_9, t0.kurzbeschreibung AS kurzbeschreibung_10, t0.firma_id AS firma_id_11 FROM firmen_blog t0 WHERE t0.aktiv = ? ORDER BY t0.datum DESC LIMIT 10
Parameters:
[
1
]
|
| 9 | 0.71 ms |
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:
[
729
]
|
| 10 | 0.60 ms |
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
]
|
| 11 | 0.58 ms |
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
]
|
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\SchulungWerbung | No errors. |
| App\Entity\SchulungsTermine | 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\UserProfil | No errors. |
| App\Entity\UserAnrede | No errors. |
| App\Entity\Firmenprofil | No errors. |
| App\Entity\Dozent | No errors. |
| App\Entity\UserNotification | No errors. |
| App\Entity\UserRolesGekauft | No errors. |
| App\Entity\Buchungen | No errors. |
| App\Entity\BuchungenSeminareTeilnehmer | No errors. |
| App\Entity\UserEinstellungenFilter | No errors. |
| App\Entity\FirebaseNotification | No errors. |
| App\Entity\FirmenInterneSchulungenZertifikat | No errors. |
| App\Entity\UserEmpfehlungen | No errors. |
| App\Entity\StatistikSuchbegriffe | No errors. |
| App\Entity\SchulungBeobachten | No errors. |
| App\Entity\Notdienst | No errors. |
| App\Entity\StatistikCelsi | No errors. |
| App\Entity\SchulungsArt | No errors. |
| App\Entity\Zielgruppe | 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\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\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\NotdienstFarbe | No errors. |
| App\Entity\FirmenBlogAnhang | No errors. |
| App\Entity\SchulungZuweisen | No errors. |
| App\Entity\SchulungKommentare | No errors. |
| App\Entity\SchulungBewertungen | No errors. |
| App\Entity\Schulungsfilter | No errors. |
| App\Entity\Schulungsfilterung | No errors. |