Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  scalp t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM scalp t0 WHERE t0.name = 'C1' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  scalp t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM scalp t0 WHERE t0.name = 'C2' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  scalp t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM scalp t0 WHERE t0.name = 'C3' LIMIT 1;

SELECT
  DISTINCT (m0_.monitoring_jahr) AS sclr_0
FROM
  meldungen m0_
WHERE
  m0_.freigegeben = 1
  AND m0_.entwurf = 0
  AND m0_.geloescht = 0
  AND (
    m0_.scalp_id = ?
    OR m0_.scalp_id = ?
    OR m0_.scalp_id = ?
  )
  AND m0_.gemeinde_id IN (
    SELECT
      g1_.id
    FROM
      gemeinden g1_,
      landkreise l2_
    WHERE
      g1_.landkreis_id = l2_.id
      AND l2_.bundesland_id IN (9)
  )
ORDER BY
  sclr_0 ASC

SELECT DISTINCT (m0_.monitoring_jahr) AS sclr_0 FROM meldungen m0_ WHERE m0_.freigegeben = 1 AND m0_.entwurf = 0 AND m0_.geloescht = 0 AND (m0_.scalp_id = 1 OR m0_.scalp_id = 2 OR m0_.scalp_id = NULL) AND m0_.gemeinde_id IN (SELECT g1_.id FROM gemeinden g1_, landkreise l2_ WHERE g1_.landkreis_id = l2_.id AND l2_.bundesland_id IN (9)) ORDER BY sclr_0 ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  scalp t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM scalp t0 WHERE t0.name = 'C1' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  scalp t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM scalp t0 WHERE t0.name = 'C2' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  scalp t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM scalp t0 WHERE t0.name = 'C3' LIMIT 1;

SELECT
  m0_.id AS id_0,
  m0_.individuumsbezeichnung AS individuumsbezeichnung_1,
  m0_.luchs_alter AS luchs_alter_2,
  m0_.luchs_alter_sonst AS luchs_alter_sonst_3,
  m0_.ort_bemerkung AS ort_bemerkung_4,
  m0_.freigegeben AS freigegeben_5,
  m0_.tieranzahl_gesamt AS tieranzahl_gesamt_6,
  m0_.tieranzahl_jungtiere AS tieranzahl_jungtiere_7,
  m0_.tieranzahl_jungtiere_c1 AS tieranzahl_jungtiere_c1_8,
  m0_.admin_ist_melder AS admin_ist_melder_9,
  m0_.meldungsnummer AS meldungsnummer_10,
  m0_.ereignis_uhrzeit_unbekannt_schaetzung_von AS ereignis_uhrzeit_unbekannt_schaetzung_von_11,
  m0_.ereignis_uhrzeit_unbekannt_schaetzung_bis AS ereignis_uhrzeit_unbekannt_schaetzung_bis_12,
  m0_.ort_verifiziert_durch AS ort_verifiziert_durch_13,
  m0_.koordinaten_ungenau_radius AS koordinaten_ungenau_radius_14,
  m0_.melder_anrede AS melder_anrede_15,
  m0_.melder_vorname AS melder_vorname_16,
  m0_.melder_nachname AS melder_nachname_17,
  m0_.melder_strasse AS melder_strasse_18,
  m0_.melder_hausnummer AS melder_hausnummer_19,
  m0_.melder_plz AS melder_plz_20,
  m0_.melder_ort AS melder_ort_21,
  m0_.melder_email AS melder_email_22,
  m0_.melder_telefon AS melder_telefon_23,
  m0_.melder_ist_jaeger AS melder_ist_jaeger_24,
  m0_.ereignis_datum_bekannt AS ereignis_datum_bekannt_25,
  m0_.ereignis_uhrzeit_bekannt AS ereignis_uhrzeit_bekannt_26,
  m0_.ereignis_datum AS ereignis_datum_27,
  m0_.ereignis_uhrzeit AS ereignis_uhrzeit_28,
  m0_.protokolliert_am_datum AS protokolliert_am_datum_29,
  m0_.protokolliert_am_uhrzeit AS protokolliert_am_uhrzeit_30,
  m0_.laengengrad AS laengengrad_31,
  m0_.breitengrad AS breitengrad_32,
  m0_.koordinaten_ungenau AS koordinaten_ungenau_33,
  m0_.geloescht AS geloescht_34,
  m0_.entwurf AS entwurf_35,
  m0_.berater_ist_melder AS berater_ist_melder_36,
  m0_.genetikprobe AS genetikprobe_37,
  m0_.ort_bekannt AS ort_bekannt_38,
  m0_.ort_verifiziert AS ort_verifiziert_39,
  m0_.ort AS ort_40,
  m0_.reproduktionsnachweis AS reproduktionsnachweis_41,
  m0_.revier AS revier_42,
  m0_.monitoring_jahr AS monitoring_jahr_43,
  m0_.monitoring_quartal AS monitoring_quartal_44,
  m0_.datensatz_abgeschlossen AS datensatz_abgeschlossen_45,
  m0_.eugrid10 AS eugrid10_46,
  m0_.bemerkung_admin AS bemerkung_admin_47,
  m0_.meldungstypen AS meldungstypen_48,
  m0_.in_karte_darstellen AS in_karte_darstellen_49,
  m0_.geschlecht AS geschlecht_50,
  m0_.genetik_bemerkung AS genetik_bemerkung_51,
  m0_.beobachter_anrede AS beobachter_anrede_52,
  m0_.beobachter_vorname AS beobachter_vorname_53,
  m0_.beobachter_nachname AS beobachter_nachname_54,
  m0_.beobachter_strasse AS beobachter_strasse_55,
  m0_.beobachter_hausnummer AS beobachter_hausnummer_56,
  m0_.beobachter_plz AS beobachter_plz_57,
  m0_.beobachter_ort AS beobachter_ort_58,
  m0_.beobachter_telefon AS beobachter_telefon_59,
  m0_.beobachter_email AS beobachter_email_60,
  m0_.beobachter_bemerkung AS beobachter_bemerkung_61,
  m0_.melder_ist_beobachter AS melder_ist_beobachter_62,
  m0_.beobachter_ist_jaeger AS beobachter_ist_jaeger_63,
  m0_.vorkommenstatus AS vorkommenstatus_64,
  m0_.melder_id AS melder_id_65,
  m0_.berater_id AS berater_id_66,
  m0_.gemeinde_id AS gemeinde_id_67,
  m0_.scalp_id AS scalp_id_68,
  m0_.vorkommen_id AS vorkommen_id_69
FROM
  meldungen m0_
WHERE
  m0_.freigegeben = 1
  AND m0_.entwurf = 0
  AND m0_.geloescht = 0
  AND m0_.monitoring_jahr = ?
  AND (
    m0_.scalp_id = ?
    OR m0_.scalp_id = ?
    OR m0_.scalp_id = ?
  )
  AND m0_.gemeinde_id IN (
    SELECT
      g1_.id
    FROM
      gemeinden g1_,
      landkreise l2_
    WHERE
      g1_.landkreis_id = l2_.id
      AND l2_.bundesland_id IN (9)
  )

SELECT m0_.id AS id_0, m0_.individuumsbezeichnung AS individuumsbezeichnung_1, m0_.luchs_alter AS luchs_alter_2, m0_.luchs_alter_sonst AS luchs_alter_sonst_3, m0_.ort_bemerkung AS ort_bemerkung_4, m0_.freigegeben AS freigegeben_5, m0_.tieranzahl_gesamt AS tieranzahl_gesamt_6, m0_.tieranzahl_jungtiere AS tieranzahl_jungtiere_7, m0_.tieranzahl_jungtiere_c1 AS tieranzahl_jungtiere_c1_8, m0_.admin_ist_melder AS admin_ist_melder_9, m0_.meldungsnummer AS meldungsnummer_10, m0_.ereignis_uhrzeit_unbekannt_schaetzung_von AS ereignis_uhrzeit_unbekannt_schaetzung_von_11, m0_.ereignis_uhrzeit_unbekannt_schaetzung_bis AS ereignis_uhrzeit_unbekannt_schaetzung_bis_12, m0_.ort_verifiziert_durch AS ort_verifiziert_durch_13, m0_.koordinaten_ungenau_radius AS koordinaten_ungenau_radius_14, m0_.melder_anrede AS melder_anrede_15, m0_.melder_vorname AS melder_vorname_16, m0_.melder_nachname AS melder_nachname_17, m0_.melder_strasse AS melder_strasse_18, m0_.melder_hausnummer AS melder_hausnummer_19, m0_.melder_plz AS melder_plz_20, m0_.melder_ort AS melder_ort_21, m0_.melder_email AS melder_email_22, m0_.melder_telefon AS melder_telefon_23, m0_.melder_ist_jaeger AS melder_ist_jaeger_24, m0_.ereignis_datum_bekannt AS ereignis_datum_bekannt_25, m0_.ereignis_uhrzeit_bekannt AS ereignis_uhrzeit_bekannt_26, m0_.ereignis_datum AS ereignis_datum_27, m0_.ereignis_uhrzeit AS ereignis_uhrzeit_28, m0_.protokolliert_am_datum AS protokolliert_am_datum_29, m0_.protokolliert_am_uhrzeit AS protokolliert_am_uhrzeit_30, m0_.laengengrad AS laengengrad_31, m0_.breitengrad AS breitengrad_32, m0_.koordinaten_ungenau AS koordinaten_ungenau_33, m0_.geloescht AS geloescht_34, m0_.entwurf AS entwurf_35, m0_.berater_ist_melder AS berater_ist_melder_36, m0_.genetikprobe AS genetikprobe_37, m0_.ort_bekannt AS ort_bekannt_38, m0_.ort_verifiziert AS ort_verifiziert_39, m0_.ort AS ort_40, m0_.reproduktionsnachweis AS reproduktionsnachweis_41, m0_.revier AS revier_42, m0_.monitoring_jahr AS monitoring_jahr_43, m0_.monitoring_quartal AS monitoring_quartal_44, m0_.datensatz_abgeschlossen AS datensatz_abgeschlossen_45, m0_.eugrid10 AS eugrid10_46, m0_.bemerkung_admin AS bemerkung_admin_47, m0_.meldungstypen AS meldungstypen_48, m0_.in_karte_darstellen AS in_karte_darstellen_49, m0_.geschlecht AS geschlecht_50, m0_.genetik_bemerkung AS genetik_bemerkung_51, m0_.beobachter_anrede AS beobachter_anrede_52, m0_.beobachter_vorname AS beobachter_vorname_53, m0_.beobachter_nachname AS beobachter_nachname_54, m0_.beobachter_strasse AS beobachter_strasse_55, m0_.beobachter_hausnummer AS beobachter_hausnummer_56, m0_.beobachter_plz AS beobachter_plz_57, m0_.beobachter_ort AS beobachter_ort_58, m0_.beobachter_telefon AS beobachter_telefon_59, m0_.beobachter_email AS beobachter_email_60, m0_.beobachter_bemerkung AS beobachter_bemerkung_61, m0_.melder_ist_beobachter AS melder_ist_beobachter_62, m0_.beobachter_ist_jaeger AS beobachter_ist_jaeger_63, m0_.vorkommenstatus AS vorkommenstatus_64, m0_.melder_id AS melder_id_65, m0_.berater_id AS berater_id_66, m0_.gemeinde_id AS gemeinde_id_67, m0_.scalp_id AS scalp_id_68, m0_.vorkommen_id AS vorkommen_id_69 FROM meldungen m0_ WHERE m0_.freigegeben = 1 AND m0_.entwurf = 0 AND m0_.geloescht = 0 AND m0_.monitoring_jahr = 2025 AND (m0_.scalp_id = 1 OR m0_.scalp_id = 2 OR m0_.scalp_id = NULL) AND m0_.gemeinde_id IN (SELECT g1_.id FROM gemeinden g1_, landkreise l2_ WHERE g1_.landkreis_id = l2_.id AND l2_.bundesland_id IN (9));

SELECT
  t0.id AS id_1,
  t0.nummer AS nummer_2,
  t0.name AS name_3,
  t0.landkreis_id AS landkreis_id_4,
  t5.id AS id_6,
  t5.lkn AS lkn_7,
  t5.name AS name_8,
  t5.bundesland_id AS bundesland_id_9,
  t5.bezirk_id AS bezirk_id_10
FROM
  gemeinden t0
  LEFT JOIN landkreise t5 ON t0.landkreis_id = t5.id
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.nummer AS nummer_2, t0.name AS name_3, t0.landkreis_id AS landkreis_id_4, t5.id AS id_6, t5.lkn AS lkn_7, t5.name AS name_8, t5.bundesland_id AS bundesland_id_9, t5.bezirk_id AS bezirk_id_10 FROM gemeinden t0 LEFT JOIN landkreise t5 ON t0.landkreis_id = t5.id WHERE t0.id IN (22950);

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  bundeslaender t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.name AS name_2 FROM bundeslaender t0 WHERE t0.id IN (9);

SELECT
  m.id,
  COUNT(sichtung.id),
  COUNT(spur.id),
  COUNT(fotofallenbild.id),
  COUNT(haarfund.id),
  COUNT(ruf.id),
  COUNT(lebendfang.id),
  COUNT(kot.id),
  COUNT(markierstelle.id),
  COUNT(totfund.id),
  COUNT(wildtierrisse.id),
  COUNT(sonstiges.id)
FROM
  meldungen m
  LEFT JOIN sichtung ON sichtung.meldung_id = m.id
  LEFT JOIN spur ON spur.meldung_id = m.id
  LEFT JOIN fotofallenbild ON fotofallenbild.meldung_id = m.id
  LEFT JOIN haarfund ON haarfund.meldung_id = m.id
  LEFT JOIN ruf ON ruf.meldung_id = m.id
  LEFT JOIN lebendfang ON lebendfang.meldung_id = m.id
  LEFT JOIN kot ON kot.meldung_id = m.id
  LEFT JOIN markierstelle ON markierstelle.meldung_id = m.id
  LEFT JOIN totfund ON totfund.meldung_id = m.id
  LEFT JOIN wildtierrisse ON wildtierrisse.meldung_id = m.id
  LEFT JOIN sonstiges ON sonstiges.meldung_id = m.id
WHERE
  m.id IN (0, 99277)
GROUP BY
  m.id

SELECT m.id, COUNT(sichtung.id), COUNT(spur.id), COUNT(fotofallenbild.id), COUNT(haarfund.id), COUNT(ruf.id), COUNT(lebendfang.id), COUNT(kot.id), COUNT(markierstelle.id), COUNT(totfund.id), COUNT(wildtierrisse.id), COUNT(sonstiges.id) FROM meldungen m  LEFT JOIN sichtung ON sichtung.meldung_id = m.id  LEFT JOIN spur ON spur.meldung_id = m.id  LEFT JOIN fotofallenbild ON fotofallenbild.meldung_id = m.id  LEFT JOIN haarfund ON haarfund.meldung_id = m.id  LEFT JOIN ruf ON ruf.meldung_id = m.id  LEFT JOIN lebendfang ON lebendfang.meldung_id = m.id  LEFT JOIN kot ON kot.meldung_id = m.id  LEFT JOIN markierstelle ON markierstelle.meldung_id = m.id  LEFT JOIN totfund ON totfund.meldung_id = m.id  LEFT JOIN wildtierrisse ON wildtierrisse.meldung_id = m.id  LEFT JOIN sonstiges ON sonstiges.meldung_id = m.id WHERE m.id IN (0,99277) GROUP BY m.id;