Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

16.65 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
14.06 ms (84.44%)	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 = ? Parameters: [`"aeatulsj19icq8nh9me0lfoh9q"`] View formatted query View runnable query Explain query 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 = 'aeatulsj19icq8nh9me0lfoh9q';
2.59 ms (15.56%)	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 Parameters: [] View formatted query View runnable query Explain query 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;

Time▼

Count

Info

14.06 ms
(84.44%)

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:

[
  "aeatulsj19icq8nh9me0lfoh9q"
]

View formatted query View runnable query Explain query

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

2.59 ms
(15.56%)

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:

[]

View formatted query View runnable query Explain query

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;

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\Firmenprofil	No errors.
App\Entity\User	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\BhFremdschulungenAbrechnung	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.

Symfony Profiler

https://demo.handwerkxcampus.de/user/gast_favoriten

Configuration Settings

Theme