| 1 |
2.20 ms |
SELECT t0.id AS id_1, t0.belegdatum AS belegdatum_2, t0.periodefibu AS periodefibu_3, t0.bnr AS bnr_4, t0.empfaenger AS empfaenger_5, t0.marktid AS marktid_6, t0.kgid AS kgid_7, t0.bruttobetrag AS bruttobetrag_8, t0.buchungstextfibu AS buchungstextfibu_9, t0.buchungstextbebu AS buchungstextbebu_10, t0.betriebskosten AS betriebskosten_11, t0.bezahlt_von AS bezahlt_von_12, t0.bezahlt_wie AS bezahlt_wie_13, t0.sollkontoprivat AS sollkontoprivat_14, t0.insteuer AS insteuer_15, t0.abgeglichen AS abgeglichen_16, t0.kabid AS kabid_17, t0.auslmwstsatz AS auslmwstsatz_18, t0.land AS land_19, t0.benutzerea AS benutzerea_20, t0.erstanlage AS erstanlage_21, t0.mwstkz_fk_id AS mwstkz_fk_id_22, t0.sollkonto_fk_id AS sollkonto_fk_id_23, t0.habenkonto_fk_id AS habenkonto_fk_id_24 FROM kosten t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.belegdatum AS belegdatum_2, t0.periodefibu AS periodefibu_3, t0.bnr AS bnr_4, t0.empfaenger AS empfaenger_5, t0.marktid AS marktid_6, t0.kgid AS kgid_7, t0.bruttobetrag AS bruttobetrag_8, t0.buchungstextfibu AS buchungstextfibu_9, t0.buchungstextbebu AS buchungstextbebu_10, t0.betriebskosten AS betriebskosten_11, t0.bezahlt_von AS bezahlt_von_12, t0.bezahlt_wie AS bezahlt_wie_13, t0.sollkontoprivat AS sollkontoprivat_14, t0.insteuer AS insteuer_15, t0.abgeglichen AS abgeglichen_16, t0.kabid AS kabid_17, t0.auslmwstsatz AS auslmwstsatz_18, t0.land AS land_19, t0.benutzerea AS benutzerea_20, t0.erstanlage AS erstanlage_21, t0.mwstkz_fk_id AS mwstkz_fk_id_22, t0.sollkonto_fk_id AS sollkonto_fk_id_23, t0.habenkonto_fk_id AS habenkonto_fk_id_24 FROM kosten t0 WHERE t0.id = '1297';
|
| 2 |
0.91 ms |
SELECT t0.id AS id_1, t0.mwstkz AS mwstkz_2, t0.mwstsatz AS mwstsatz_3, t0.land AS land_4 FROM sdmwst_saetze t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.mwstkz AS mwstkz_2, t0.mwstsatz AS mwstsatz_3, t0.land AS land_4 FROM sdmwst_saetze t0 WHERE t0.id = 1;
|
| 3 |
0.52 ms |
SELECT t0.id AS id_1, t0.kontotyp_fk_id AS kontotyp_fk_id_2, t0.aaknr_fk_id AS aaknr_fk_id_3, t0.knr AS knr_4, t0.knrbezeichnung AS knrbezeichnung_5, t0.bgr AS bgr_6, t0.anfangsbestand AS anfangsbestand_7, t0.fa_anfangsbestand AS fa_anfangsbestand_8, t0.datum_ab AS datum_ab_9, t0.kommissionsruecklage AS kommissionsruecklage_10, t0.in_bwa AS in_bwa_11, t0.budgetgruppe AS budgetgruppe_12, t0.kontotyp_fk_id AS kontotyp_fk_id_13, t0.aaknr_fk_id AS aaknr_fk_id_14 FROM sdkontenrahmen t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.kontotyp_fk_id AS kontotyp_fk_id_2, t0.aaknr_fk_id AS aaknr_fk_id_3, t0.knr AS knr_4, t0.knrbezeichnung AS knrbezeichnung_5, t0.bgr AS bgr_6, t0.anfangsbestand AS anfangsbestand_7, t0.fa_anfangsbestand AS fa_anfangsbestand_8, t0.datum_ab AS datum_ab_9, t0.kommissionsruecklage AS kommissionsruecklage_10, t0.in_bwa AS in_bwa_11, t0.budgetgruppe AS budgetgruppe_12, t0.kontotyp_fk_id AS kontotyp_fk_id_13, t0.aaknr_fk_id AS aaknr_fk_id_14 FROM sdkontenrahmen t0 WHERE t0.id = 8;
|
| 4 |
0.84 ms |
SELECT t0.id AS id_1, t0.kontotyp_fk_id AS kontotyp_fk_id_2, t0.aaknr_fk_id AS aaknr_fk_id_3, t0.knr AS knr_4, t0.knrbezeichnung AS knrbezeichnung_5, t0.bgr AS bgr_6, t0.anfangsbestand AS anfangsbestand_7, t0.fa_anfangsbestand AS fa_anfangsbestand_8, t0.datum_ab AS datum_ab_9, t0.kommissionsruecklage AS kommissionsruecklage_10, t0.in_bwa AS in_bwa_11, t0.budgetgruppe AS budgetgruppe_12, t0.kontotyp_fk_id AS kontotyp_fk_id_13, t0.aaknr_fk_id AS aaknr_fk_id_14 FROM sdkontenrahmen t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.kontotyp_fk_id AS kontotyp_fk_id_2, t0.aaknr_fk_id AS aaknr_fk_id_3, t0.knr AS knr_4, t0.knrbezeichnung AS knrbezeichnung_5, t0.bgr AS bgr_6, t0.anfangsbestand AS anfangsbestand_7, t0.fa_anfangsbestand AS fa_anfangsbestand_8, t0.datum_ab AS datum_ab_9, t0.kommissionsruecklage AS kommissionsruecklage_10, t0.in_bwa AS in_bwa_11, t0.budgetgruppe AS budgetgruppe_12, t0.kontotyp_fk_id AS kontotyp_fk_id_13, t0.aaknr_fk_id AS aaknr_fk_id_14 FROM sdkontenrahmen t0 WHERE t0.id = 15;
|
| 5 |
2.83 ms |
SELECT empfaenger FROM kosten GROUP BY empfaenger ORDER BY empfaenger
SELECT empfaenger FROM kosten GROUP BY empfaenger ORDER BY empfaenger;
|
| 6 |
0.54 ms |
SELECT t0.id AS id_1, t0.bnr AS bnr_2, t0.dateiname AS dateiname_3, t0.belegbez AS belegbez_4, t0.kostenid AS kostenid_5 FROM kosten_belege t0 WHERE t0.kostenid = ?
SELECT t0.id AS id_1, t0.bnr AS bnr_2, t0.dateiname AS dateiname_3, t0.belegbez AS belegbez_4, t0.kostenid AS kostenid_5 FROM kosten_belege t0 WHERE t0.kostenid = '1297';
|
| 7 |
0.50 ms |
SELECT s0_.id AS id_0, s0_.mwstkz AS mwstkz_1, s0_.mwstsatz AS mwstsatz_2, s0_.land AS land_3 FROM sdmwst_saetze s0_
SELECT s0_.id AS id_0, s0_.mwstkz AS mwstkz_1, s0_.mwstsatz AS mwstsatz_2, s0_.land AS land_3 FROM sdmwst_saetze s0_;
|
| 8 |
0.66 ms |
SELECT s0_.id AS id_0, s0_.kontotyp_fk_id AS kontotyp_fk_id_1, s0_.aaknr_fk_id AS aaknr_fk_id_2, s0_.knr AS knr_3, s0_.knrbezeichnung AS knrbezeichnung_4, s0_.bgr AS bgr_5, s0_.anfangsbestand AS anfangsbestand_6, s0_.fa_anfangsbestand AS fa_anfangsbestand_7, s0_.datum_ab AS datum_ab_8, s0_.kommissionsruecklage AS kommissionsruecklage_9, s0_.in_bwa AS in_bwa_10, s0_.budgetgruppe AS budgetgruppe_11, s0_.kontotyp_fk_id AS kontotyp_fk_id_12, s0_.aaknr_fk_id AS aaknr_fk_id_13 FROM sdkontenrahmen s0_ ORDER BY s0_.knr ASC
SELECT s0_.id AS id_0, s0_.kontotyp_fk_id AS kontotyp_fk_id_1, s0_.aaknr_fk_id AS aaknr_fk_id_2, s0_.knr AS knr_3, s0_.knrbezeichnung AS knrbezeichnung_4, s0_.bgr AS bgr_5, s0_.anfangsbestand AS anfangsbestand_6, s0_.fa_anfangsbestand AS fa_anfangsbestand_7, s0_.datum_ab AS datum_ab_8, s0_.kommissionsruecklage AS kommissionsruecklage_9, s0_.in_bwa AS in_bwa_10, s0_.budgetgruppe AS budgetgruppe_11, s0_.kontotyp_fk_id AS kontotyp_fk_id_12, s0_.aaknr_fk_id AS aaknr_fk_id_13 FROM sdkontenrahmen s0_ ORDER BY s0_.knr ASC;
|