Symfony Profiler

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

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;

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 = ?

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 = 'jkrvu685n0vsougcqt84eqinbj';

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

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 >= '2025-09-17 01:39:54' AND (s0_.anmeldeschluss IS NULL OR s0_.anmeldeschluss >= '2025-09-17 01:39:54') ORDER BY s0_.von ASC LIMIT 10;

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

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;

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

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 = 1 ORDER BY t0.datum DESC LIMIT 10;

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

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;

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

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 <= '2025-09-17 01:39:54' AND s0_.bis >= '2025-09-17 01:39:54' ORDER BY RAND() ASC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.untergruppe AS untergruppe_3
FROM
  zielgruppe t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.untergruppe AS untergruppe_3 FROM zielgruppe t0;