Query Metrics
7
Database Queries
7
Different statements
7.88 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 4.05 ms |
SELECT t0.id AS id_1, t0.schulungsart AS schulungsart_2, t0.branche AS branche_3, t0.kategorie AS kategorie_4, t0.thema AS thema_5, t0.zielgruppe AS zielgruppe_6, t0.anbieter AS anbieter_7, t0.loeschdatum AS loeschdatum_8, t0.nur_celsisten AS nur_celsisten_9, t0.schulung_id AS schulung_id_10, t0.schulungsfilterung_id AS schulungsfilterung_id_11 FROM schulungsfilter t0
Parameters:
[] |
2 | 0.71 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 WHERE t0.id IN (?, ?, ?, ?)
Parameters:
[ 1 4 3 2 ] |
3 | 0.62 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.untergruppe AS untergruppe_3 FROM branchen t0 WHERE t0.id IN (?)
Parameters:
[
1
]
|
4 | 0.47 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.untergruppe AS untergruppe_3, t0.branche_id AS branche_id_4 FROM branchen_kategorien t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 7 1 2 3 4 5 6 0 ] |
5 | 0.35 ms |
SELECT t0.id AS id_1, t0.thema AS thema_2, t0.untergruppe AS untergruppe_3 FROM konfigurator_themen t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 12 9 13 19 23 17 7 8 11 1 16 2 15 18 4 20 21 22 0 3 5 10 14 ] |
6 | 0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.untergruppe AS untergruppe_3 FROM zielgruppe t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 8 1 7 3 4 6 5 10 2 0 ] |
7 | 1.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 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 14 34 35 171 364 7 15 8 16 ] |
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\Schulungsfilter | No errors. |
App\Entity\Schulungen | No errors. |
App\Entity\Schulungsfilterung | No errors. |
App\Entity\SchulungsArt | No errors. |
App\Entity\Branchen | No errors. |
App\Entity\BranchenKategorien | No errors. |
App\Entity\KonfiguratorThemen | No errors. |
App\Entity\Zielgruppe | 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. |