Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.email_canonical AS email_canonical_4,
  t0.username_canonical AS username_canonical_5,
  t0.password AS password_6,
  t0.salt AS salt_7,
  t0.roles AS roles_8,
  t0.enabled AS enabled_9,
  t0.last_login AS last_login_10,
  t0.locked AS locked_11,
  t0.updated_at AS updated_at_12,
  t0.created_at AS created_at_13,
  t0.password_requested_at AS password_requested_at_14,
  t0.confirmation_token AS confirmation_token_15,
  t16.id AS id_17,
  t16.vorname AS vorname_18,
  t16.nachname AS nachname_19,
  t16.strasse AS strasse_20,
  t16.hausnummer AS hausnummer_21,
  t16.plz AS plz_22,
  t16.ort AS ort_23,
  t16.email AS email_24,
  t16.telefonnummer AS telefonnummer_25,
  t16.handynummer AS handynummer_26,
  t16.geburtsdatum AS geburtsdatum_27,
  t16.kennziffer AS kennziffer_28,
  t16.examen AS examen_29,
  t16.export_erlaubt AS export_erlaubt_30,
  t16.anruf_erlaubt AS anruf_erlaubt_31,
  t16.logged_in AS logged_in_32,
  t16.sms_send_at AS sms_send_at_33,
  t16.sms_status_id AS sms_status_id_34,
  t16.notiz AS notiz_35,
  t16.verkaeufer AS verkaeufer_36,
  t16.kontoinhaber AS kontoinhaber_37,
  t16.kontonummer AS kontonummer_38,
  t16.bank AS bank_39,
  t16.blz AS blz_40,
  t16.iban AS iban_41,
  t16.bic AS bic_42,
  t16.betrag_strafe AS betrag_strafe_43,
  t16.strafe_bezahlt AS strafe_bezahlt_44,
  t16.sperrdatum AS sperrdatum_45,
  t16.created_at AS created_at_46,
  t16.pdf_need_update AS pdf_need_update_47,
  t16.klausurprotokollpflicht AS klausurprotokollpflicht_48,
  t16.pflicht_facebook_post AS pflicht_facebook_post_49,
  t16.notenpflicht AS notenpflicht_50,
  t16.kunde_englisch_kenntniss AS kunde_englisch_kenntniss_51,
  t16.kunde_wunsch_arbeitsort AS kunde_wunsch_arbeitsort_52,
  t16.user_id AS user_id_53,
  t16.bundesland_id AS bundesland_id_54,
  t55.id AS id_56,
  t55.name AS name_57,
  t55.anrede_rechnung AS anrede_rechnung_58,
  t55.user_id AS user_id_59
FROM
  fos_user t0
  LEFT JOIN kunde t16 ON t16.user_id = t0.id
  LEFT JOIN partner t55 ON t55.user_id = t0.id
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.username_canonical AS username_canonical_5, t0.password AS password_6, t0.salt AS salt_7, t0.roles AS roles_8, t0.enabled AS enabled_9, t0.last_login AS last_login_10, t0.locked AS locked_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.password_requested_at AS password_requested_at_14, t0.confirmation_token AS confirmation_token_15, t16.id AS id_17, t16.vorname AS vorname_18, t16.nachname AS nachname_19, t16.strasse AS strasse_20, t16.hausnummer AS hausnummer_21, t16.plz AS plz_22, t16.ort AS ort_23, t16.email AS email_24, t16.telefonnummer AS telefonnummer_25, t16.handynummer AS handynummer_26, t16.geburtsdatum AS geburtsdatum_27, t16.kennziffer AS kennziffer_28, t16.examen AS examen_29, t16.export_erlaubt AS export_erlaubt_30, t16.anruf_erlaubt AS anruf_erlaubt_31, t16.logged_in AS logged_in_32, t16.sms_send_at AS sms_send_at_33, t16.sms_status_id AS sms_status_id_34, t16.notiz AS notiz_35, t16.verkaeufer AS verkaeufer_36, t16.kontoinhaber AS kontoinhaber_37, t16.kontonummer AS kontonummer_38, t16.bank AS bank_39, t16.blz AS blz_40, t16.iban AS iban_41, t16.bic AS bic_42, t16.betrag_strafe AS betrag_strafe_43, t16.strafe_bezahlt AS strafe_bezahlt_44, t16.sperrdatum AS sperrdatum_45, t16.created_at AS created_at_46, t16.pdf_need_update AS pdf_need_update_47, t16.klausurprotokollpflicht AS klausurprotokollpflicht_48, t16.pflicht_facebook_post AS pflicht_facebook_post_49, t16.notenpflicht AS notenpflicht_50, t16.kunde_englisch_kenntniss AS kunde_englisch_kenntniss_51, t16.kunde_wunsch_arbeitsort AS kunde_wunsch_arbeitsort_52, t16.user_id AS user_id_53, t16.bundesland_id AS bundesland_id_54, t55.id AS id_56, t55.name AS name_57, t55.anrede_rechnung AS anrede_rechnung_58, t55.user_id AS user_id_59 FROM fos_user t0 LEFT JOIN kunde t16 ON t16.user_id = t0.id LEFT JOIN partner t55 ON t55.user_id = t0.id WHERE t0.email = 'petra.nikolai@web.de' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.vorname AS vorname_2,
  t0.nachname AS nachname_3,
  t0.strasse AS strasse_4,
  t0.hausnummer AS hausnummer_5,
  t0.plz AS plz_6,
  t0.ort AS ort_7,
  t0.email AS email_8,
  t0.telefonnummer AS telefonnummer_9,
  t0.handynummer AS handynummer_10,
  t0.geburtsdatum AS geburtsdatum_11,
  t0.kennziffer AS kennziffer_12,
  t0.examen AS examen_13,
  t0.export_erlaubt AS export_erlaubt_14,
  t0.anruf_erlaubt AS anruf_erlaubt_15,
  t0.logged_in AS logged_in_16,
  t0.sms_send_at AS sms_send_at_17,
  t0.sms_status_id AS sms_status_id_18,
  t0.notiz AS notiz_19,
  t0.verkaeufer AS verkaeufer_20,
  t0.kontoinhaber AS kontoinhaber_21,
  t0.kontonummer AS kontonummer_22,
  t0.bank AS bank_23,
  t0.blz AS blz_24,
  t0.iban AS iban_25,
  t0.bic AS bic_26,
  t0.betrag_strafe AS betrag_strafe_27,
  t0.strafe_bezahlt AS strafe_bezahlt_28,
  t0.sperrdatum AS sperrdatum_29,
  t0.created_at AS created_at_30,
  t0.pdf_need_update AS pdf_need_update_31,
  t0.klausurprotokollpflicht AS klausurprotokollpflicht_32,
  t0.pflicht_facebook_post AS pflicht_facebook_post_33,
  t0.notenpflicht AS notenpflicht_34,
  t0.kunde_englisch_kenntniss AS kunde_englisch_kenntniss_35,
  t0.kunde_wunsch_arbeitsort AS kunde_wunsch_arbeitsort_36,
  t0.user_id AS user_id_37,
  t38.id AS id_39,
  t38.anzahl_seiten AS anzahl_seiten_40,
  t38.path AS path_41,
  t38.size AS size_42,
  t38.mimeType AS mimeType_43,
  t38.created_at AS created_at_44,
  t38.updated_at AS updated_at_45,
  t38.kunde_id AS kunde_id_46,
  t47.id AS id_48,
  t47.zeitschrift AS zeitschrift_49,
  t47.typ AS typ_50,
  t47.online AS online_51,
  t47.datum_start AS datum_start_52,
  t47.datum_ende AS datum_ende_53,
  t47.vorzugspreis AS vorzugspreis_54,
  t47.bearbeitet AS bearbeitet_55,
  t47.zahlung_vierteljaehrlich AS zahlung_vierteljaehrlich_56,
  t47.created_at AS created_at_57,
  t47.ip AS ip_58,
  t47.abonummer AS abonummer_59,
  t47.anrede AS anrede_60,
  t47.titel AS titel_61,
  t47.firma AS firma_62,
  t47.vorname AS vorname_63,
  t47.nachname AS nachname_64,
  t47.strasse AS strasse_65,
  t47.hausnummer AS hausnummer_66,
  t47.strasse_voll AS strasse_voll_67,
  t47.plz AS plz_68,
  t47.ort AS ort_69,
  t47.telefon AS telefon_70,
  t47.fax AS fax_71,
  t47.email AS email_72,
  t47.geburtsdatum AS geburtsdatum_73,
  t47.sepa AS sepa_74,
  t47.sepa_vorname AS sepa_vorname_75,
  t47.sepa_nachname AS sepa_nachname_76,
  t47.sepa_strasse AS sepa_strasse_77,
  t47.sepa_hausnummer AS sepa_hausnummer_78,
  t47.sepa_plz AS sepa_plz_79,
  t47.sepa_ort AS sepa_ort_80,
  t47.sepa_telefon AS sepa_telefon_81,
  t47.sepa_fax AS sepa_fax_82,
  t47.sepa_email AS sepa_email_83,
  t47.sepa_geburtsdatum AS sepa_geburtsdatum_84,
  t47.sepa_bank AS sepa_bank_85,
  t47.sepa_bic AS sepa_bic_86,
  t47.sepa_iban AS sepa_iban_87,
  t47.sepa_kontoinhaber AS sepa_kontoinhaber_88,
  t47.kunde_id AS kunde_id_89,
  t47.gutschein_id AS gutschein_id_90,
  t0.bundesland_id AS bundesland_id_91
FROM
  kunde t0
  LEFT JOIN pdf_stempel t38 ON t38.kunde_id = t0.id
  LEFT JOIN abo t47 ON t47.kunde_id = t0.id
WHERE
  t0.email = ?
  AND t0.examen = ?
LIMIT
  2

SELECT t0.id AS id_1, t0.vorname AS vorname_2, t0.nachname AS nachname_3, t0.strasse AS strasse_4, t0.hausnummer AS hausnummer_5, t0.plz AS plz_6, t0.ort AS ort_7, t0.email AS email_8, t0.telefonnummer AS telefonnummer_9, t0.handynummer AS handynummer_10, t0.geburtsdatum AS geburtsdatum_11, t0.kennziffer AS kennziffer_12, t0.examen AS examen_13, t0.export_erlaubt AS export_erlaubt_14, t0.anruf_erlaubt AS anruf_erlaubt_15, t0.logged_in AS logged_in_16, t0.sms_send_at AS sms_send_at_17, t0.sms_status_id AS sms_status_id_18, t0.notiz AS notiz_19, t0.verkaeufer AS verkaeufer_20, t0.kontoinhaber AS kontoinhaber_21, t0.kontonummer AS kontonummer_22, t0.bank AS bank_23, t0.blz AS blz_24, t0.iban AS iban_25, t0.bic AS bic_26, t0.betrag_strafe AS betrag_strafe_27, t0.strafe_bezahlt AS strafe_bezahlt_28, t0.sperrdatum AS sperrdatum_29, t0.created_at AS created_at_30, t0.pdf_need_update AS pdf_need_update_31, t0.klausurprotokollpflicht AS klausurprotokollpflicht_32, t0.pflicht_facebook_post AS pflicht_facebook_post_33, t0.notenpflicht AS notenpflicht_34, t0.kunde_englisch_kenntniss AS kunde_englisch_kenntniss_35, t0.kunde_wunsch_arbeitsort AS kunde_wunsch_arbeitsort_36, t0.user_id AS user_id_37, t38.id AS id_39, t38.anzahl_seiten AS anzahl_seiten_40, t38.path AS path_41, t38.size AS size_42, t38.mimeType AS mimeType_43, t38.created_at AS created_at_44, t38.updated_at AS updated_at_45, t38.kunde_id AS kunde_id_46, t47.id AS id_48, t47.zeitschrift AS zeitschrift_49, t47.typ AS typ_50, t47.online AS online_51, t47.datum_start AS datum_start_52, t47.datum_ende AS datum_ende_53, t47.vorzugspreis AS vorzugspreis_54, t47.bearbeitet AS bearbeitet_55, t47.zahlung_vierteljaehrlich AS zahlung_vierteljaehrlich_56, t47.created_at AS created_at_57, t47.ip AS ip_58, t47.abonummer AS abonummer_59, t47.anrede AS anrede_60, t47.titel AS titel_61, t47.firma AS firma_62, t47.vorname AS vorname_63, t47.nachname AS nachname_64, t47.strasse AS strasse_65, t47.hausnummer AS hausnummer_66, t47.strasse_voll AS strasse_voll_67, t47.plz AS plz_68, t47.ort AS ort_69, t47.telefon AS telefon_70, t47.fax AS fax_71, t47.email AS email_72, t47.geburtsdatum AS geburtsdatum_73, t47.sepa AS sepa_74, t47.sepa_vorname AS sepa_vorname_75, t47.sepa_nachname AS sepa_nachname_76, t47.sepa_strasse AS sepa_strasse_77, t47.sepa_hausnummer AS sepa_hausnummer_78, t47.sepa_plz AS sepa_plz_79, t47.sepa_ort AS sepa_ort_80, t47.sepa_telefon AS sepa_telefon_81, t47.sepa_fax AS sepa_fax_82, t47.sepa_email AS sepa_email_83, t47.sepa_geburtsdatum AS sepa_geburtsdatum_84, t47.sepa_bank AS sepa_bank_85, t47.sepa_bic AS sepa_bic_86, t47.sepa_iban AS sepa_iban_87, t47.sepa_kontoinhaber AS sepa_kontoinhaber_88, t47.kunde_id AS kunde_id_89, t47.gutschein_id AS gutschein_id_90, t0.bundesland_id AS bundesland_id_91 FROM kunde t0 LEFT JOIN pdf_stempel t38 ON t38.kunde_id = t0.id LEFT JOIN abo t47 ON t47.kunde_id = t0.id WHERE t0.email = 'petra.nikolai@web.de' AND t0.examen = '1' LIMIT 2;

SELECT
  p0_.id AS id_0,
  p0_.bezeichnung AS bezeichnung_1,
  p0_.examen AS examen_2,
  p0_.wahlfach AS wahlfach_3,
  p0_.bestand AS bestand_4,
  p0_.anzahl_pruefer AS anzahl_pruefer_5,
  p0_.anzahl_kandidaten AS anzahl_kandidaten_6,
  p0_.kennziffer_parts AS kennziffer_parts_7,
  p0_.noten_options AS noten_options_8,
  p0_.wahlfach_noten_options AS wahlfach_noten_options_9,
  p0_.termine AS termine_10,
  p0_.import_url AS import_url_11
FROM
  pruefungsamt p0_
  INNER JOIN pruefungsamt_bundesland p2_ ON p0_.id = p2_.pruefungsamt_id
  INNER JOIN bundesland b1_ ON b1_.id = p2_.bundesland_id
WHERE
  b1_.id = ?
  AND p0_.examen = ?

SELECT p0_.id AS id_0, p0_.bezeichnung AS bezeichnung_1, p0_.examen AS examen_2, p0_.wahlfach AS wahlfach_3, p0_.bestand AS bestand_4, p0_.anzahl_pruefer AS anzahl_pruefer_5, p0_.anzahl_kandidaten AS anzahl_kandidaten_6, p0_.kennziffer_parts AS kennziffer_parts_7, p0_.noten_options AS noten_options_8, p0_.wahlfach_noten_options AS wahlfach_noten_options_9, p0_.termine AS termine_10, p0_.import_url AS import_url_11 FROM pruefungsamt p0_ INNER JOIN pruefungsamt_bundesland p2_ ON p0_.id = p2_.pruefungsamt_id INNER JOIN bundesland b1_ ON b1_.id = p2_.bundesland_id WHERE b1_.id = '2' AND p0_.examen = '1';

SELECT
  t0.id AS id_1,
  t0.vorname AS vorname_2,
  t0.nachname AS nachname_3,
  t0.strasse AS strasse_4,
  t0.hausnummer AS hausnummer_5,
  t0.plz AS plz_6,
  t0.ort AS ort_7,
  t0.email AS email_8,
  t0.telefonnummer AS telefonnummer_9,
  t0.handynummer AS handynummer_10,
  t0.geburtsdatum AS geburtsdatum_11,
  t0.kennziffer AS kennziffer_12,
  t0.examen AS examen_13,
  t0.export_erlaubt AS export_erlaubt_14,
  t0.anruf_erlaubt AS anruf_erlaubt_15,
  t0.logged_in AS logged_in_16,
  t0.sms_send_at AS sms_send_at_17,
  t0.sms_status_id AS sms_status_id_18,
  t0.notiz AS notiz_19,
  t0.verkaeufer AS verkaeufer_20,
  t0.kontoinhaber AS kontoinhaber_21,
  t0.kontonummer AS kontonummer_22,
  t0.bank AS bank_23,
  t0.blz AS blz_24,
  t0.iban AS iban_25,
  t0.bic AS bic_26,
  t0.betrag_strafe AS betrag_strafe_27,
  t0.strafe_bezahlt AS strafe_bezahlt_28,
  t0.sperrdatum AS sperrdatum_29,
  t0.created_at AS created_at_30,
  t0.pdf_need_update AS pdf_need_update_31,
  t0.klausurprotokollpflicht AS klausurprotokollpflicht_32,
  t0.pflicht_facebook_post AS pflicht_facebook_post_33,
  t0.notenpflicht AS notenpflicht_34,
  t0.kunde_englisch_kenntniss AS kunde_englisch_kenntniss_35,
  t0.kunde_wunsch_arbeitsort AS kunde_wunsch_arbeitsort_36,
  t0.user_id AS user_id_37,
  t38.id AS id_39,
  t38.anzahl_seiten AS anzahl_seiten_40,
  t38.path AS path_41,
  t38.size AS size_42,
  t38.mimeType AS mimeType_43,
  t38.created_at AS created_at_44,
  t38.updated_at AS updated_at_45,
  t38.kunde_id AS kunde_id_46,
  t47.id AS id_48,
  t47.zeitschrift AS zeitschrift_49,
  t47.typ AS typ_50,
  t47.online AS online_51,
  t47.datum_start AS datum_start_52,
  t47.datum_ende AS datum_ende_53,
  t47.vorzugspreis AS vorzugspreis_54,
  t47.bearbeitet AS bearbeitet_55,
  t47.zahlung_vierteljaehrlich AS zahlung_vierteljaehrlich_56,
  t47.created_at AS created_at_57,
  t47.ip AS ip_58,
  t47.abonummer AS abonummer_59,
  t47.anrede AS anrede_60,
  t47.titel AS titel_61,
  t47.firma AS firma_62,
  t47.vorname AS vorname_63,
  t47.nachname AS nachname_64,
  t47.strasse AS strasse_65,
  t47.hausnummer AS hausnummer_66,
  t47.strasse_voll AS strasse_voll_67,
  t47.plz AS plz_68,
  t47.ort AS ort_69,
  t47.telefon AS telefon_70,
  t47.fax AS fax_71,
  t47.email AS email_72,
  t47.geburtsdatum AS geburtsdatum_73,
  t47.sepa AS sepa_74,
  t47.sepa_vorname AS sepa_vorname_75,
  t47.sepa_nachname AS sepa_nachname_76,
  t47.sepa_strasse AS sepa_strasse_77,
  t47.sepa_hausnummer AS sepa_hausnummer_78,
  t47.sepa_plz AS sepa_plz_79,
  t47.sepa_ort AS sepa_ort_80,
  t47.sepa_telefon AS sepa_telefon_81,
  t47.sepa_fax AS sepa_fax_82,
  t47.sepa_email AS sepa_email_83,
  t47.sepa_geburtsdatum AS sepa_geburtsdatum_84,
  t47.sepa_bank AS sepa_bank_85,
  t47.sepa_bic AS sepa_bic_86,
  t47.sepa_iban AS sepa_iban_87,
  t47.sepa_kontoinhaber AS sepa_kontoinhaber_88,
  t47.kunde_id AS kunde_id_89,
  t47.gutschein_id AS gutschein_id_90,
  t0.bundesland_id AS bundesland_id_91
FROM
  kunde t0
  LEFT JOIN pdf_stempel t38 ON t38.kunde_id = t0.id
  LEFT JOIN abo t47 ON t47.kunde_id = t0.id
WHERE
  t0.handynummer = ?
  AND t0.examen = ?
LIMIT
  2

SELECT t0.id AS id_1, t0.vorname AS vorname_2, t0.nachname AS nachname_3, t0.strasse AS strasse_4, t0.hausnummer AS hausnummer_5, t0.plz AS plz_6, t0.ort AS ort_7, t0.email AS email_8, t0.telefonnummer AS telefonnummer_9, t0.handynummer AS handynummer_10, t0.geburtsdatum AS geburtsdatum_11, t0.kennziffer AS kennziffer_12, t0.examen AS examen_13, t0.export_erlaubt AS export_erlaubt_14, t0.anruf_erlaubt AS anruf_erlaubt_15, t0.logged_in AS logged_in_16, t0.sms_send_at AS sms_send_at_17, t0.sms_status_id AS sms_status_id_18, t0.notiz AS notiz_19, t0.verkaeufer AS verkaeufer_20, t0.kontoinhaber AS kontoinhaber_21, t0.kontonummer AS kontonummer_22, t0.bank AS bank_23, t0.blz AS blz_24, t0.iban AS iban_25, t0.bic AS bic_26, t0.betrag_strafe AS betrag_strafe_27, t0.strafe_bezahlt AS strafe_bezahlt_28, t0.sperrdatum AS sperrdatum_29, t0.created_at AS created_at_30, t0.pdf_need_update AS pdf_need_update_31, t0.klausurprotokollpflicht AS klausurprotokollpflicht_32, t0.pflicht_facebook_post AS pflicht_facebook_post_33, t0.notenpflicht AS notenpflicht_34, t0.kunde_englisch_kenntniss AS kunde_englisch_kenntniss_35, t0.kunde_wunsch_arbeitsort AS kunde_wunsch_arbeitsort_36, t0.user_id AS user_id_37, t38.id AS id_39, t38.anzahl_seiten AS anzahl_seiten_40, t38.path AS path_41, t38.size AS size_42, t38.mimeType AS mimeType_43, t38.created_at AS created_at_44, t38.updated_at AS updated_at_45, t38.kunde_id AS kunde_id_46, t47.id AS id_48, t47.zeitschrift AS zeitschrift_49, t47.typ AS typ_50, t47.online AS online_51, t47.datum_start AS datum_start_52, t47.datum_ende AS datum_ende_53, t47.vorzugspreis AS vorzugspreis_54, t47.bearbeitet AS bearbeitet_55, t47.zahlung_vierteljaehrlich AS zahlung_vierteljaehrlich_56, t47.created_at AS created_at_57, t47.ip AS ip_58, t47.abonummer AS abonummer_59, t47.anrede AS anrede_60, t47.titel AS titel_61, t47.firma AS firma_62, t47.vorname AS vorname_63, t47.nachname AS nachname_64, t47.strasse AS strasse_65, t47.hausnummer AS hausnummer_66, t47.strasse_voll AS strasse_voll_67, t47.plz AS plz_68, t47.ort AS ort_69, t47.telefon AS telefon_70, t47.fax AS fax_71, t47.email AS email_72, t47.geburtsdatum AS geburtsdatum_73, t47.sepa AS sepa_74, t47.sepa_vorname AS sepa_vorname_75, t47.sepa_nachname AS sepa_nachname_76, t47.sepa_strasse AS sepa_strasse_77, t47.sepa_hausnummer AS sepa_hausnummer_78, t47.sepa_plz AS sepa_plz_79, t47.sepa_ort AS sepa_ort_80, t47.sepa_telefon AS sepa_telefon_81, t47.sepa_fax AS sepa_fax_82, t47.sepa_email AS sepa_email_83, t47.sepa_geburtsdatum AS sepa_geburtsdatum_84, t47.sepa_bank AS sepa_bank_85, t47.sepa_bic AS sepa_bic_86, t47.sepa_iban AS sepa_iban_87, t47.sepa_kontoinhaber AS sepa_kontoinhaber_88, t47.kunde_id AS kunde_id_89, t47.gutschein_id AS gutschein_id_90, t0.bundesland_id AS bundesland_id_91 FROM kunde t0 LEFT JOIN pdf_stempel t38 ON t38.kunde_id = t0.id LEFT JOIN abo t47 ON t47.kunde_id = t0.id WHERE t0.handynummer = '01702361617' AND t0.examen = '1' LIMIT 2;

SELECT
  t0.id AS id_1,
  t0.typ AS typ_2,
  t0.datum AS datum_3,
  t0.betrag AS betrag_4
FROM
  gebuehr t0
  INNER JOIN pruefungsamt_gebuehr ON t0.id = pruefungsamt_gebuehr.gebuehr_id
WHERE
  pruefungsamt_gebuehr.pruefungsamt_id = ?
ORDER BY
  t0.typ ASC,
  t0.datum DESC

SELECT t0.id AS id_1, t0.typ AS typ_2, t0.datum AS datum_3, t0.betrag AS betrag_4 FROM gebuehr t0 INNER JOIN pruefungsamt_gebuehr ON t0.id = pruefungsamt_gebuehr.gebuehr_id WHERE pruefungsamt_gebuehr.pruefungsamt_id = 3 ORDER BY t0.typ ASC, t0.datum DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.kuerzel AS kuerzel_3,
  t0.slug AS slug_4
FROM
  bundesland t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.kuerzel AS kuerzel_3, t0.slug AS slug_4 FROM bundesland t0 WHERE t0.id = '2';

SELECT
  k0_.id AS id_0,
  k0_.name AS name_1,
  k0_.sortierung AS sortierung_2
FROM
  kenntnis k0_

SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.sortierung AS sortierung_2 FROM kenntnis k0_;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.kuerzel AS kuerzel_3,
  t0.slug AS slug_4
FROM
  bundesland t0
WHERE
  t0.name = ?
LIMIT
  2

SELECT t0.id AS id_1, t0.name AS name_2, t0.kuerzel AS kuerzel_3, t0.slug AS slug_4 FROM bundesland t0 WHERE t0.name = 'Bayern' LIMIT 2;

SELECT
  k0_.id AS id_0,
  k0_.name AS name_1,
  k0_.sortierung AS sortierung_2
FROM
  kenntnis k0_
WHERE
  k0_.id IN (?)

SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.sortierung AS sortierung_2 FROM kenntnis k0_ WHERE k0_.id IN ('19');