Query Metrics
16
Database Queries
4
Different statements
9.13 ms
Query time
0
Invalid entities
Grouped Statements
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. |