https://demo.handwerkxcampus.de/user/produkt/details/termine/195

Query Metrics

16 Database Queries
4 Different statements
9.13 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
4.26 ms
(46.63%)
7
SELECT t0.id AS id_1, t0.datum_seminarangaben AS datum_seminarangaben_2, t0.datum_terminangaben AS datum_terminangaben_3, t0.anzahl_teilnehmer AS anzahl_teilnehmer_4, t0.preis_teilnehmer AS preis_teilnehmer_5, t0.mwst AS mwst_6, t0.bemerkung AS bemerkung_7, t0.schulungsname AS schulungsname_8, t0.schulungszeit AS schulungszeit_9, t0.stornieren_bis_datum AS stornieren_bis_datum_10, t0.buchung_id AS buchung_id_11, t0.termin_id AS termin_id_12 FROM buchungen_seminare t0 WHERE t0.termin_id IN (?)
Parameters:
[
  1436
]
3.05 ms
(33.37%)
7
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:
[
  1436
]
0.96 ms
(10.46%)
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:
[
  "195"
]
0.87 ms
(9.53%)
1
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:
[
  195
]

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\Schulungen No errors.
App\Entity\SchulungsArt No errors.
App\Entity\SchulungsTermine No errors.
App\Entity\SchulungZuweisen No errors.
App\Entity\UserFavoriten 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\Buchungen No errors.