Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.belegnr AS belegnr_2,
  t0.belegdat AS belegdat_3,
  t0.nlid AS nlid_4,
  t0.adrcode AS adrcode_5,
  t0.plzkunde AS plzkunde_6,
  t0.vortext AS vortext_7,
  t0.marktid AS marktid_8,
  t0.internetbnr AS internetbnr_9,
  t0.nachtext AS nachtext_10,
  t0.zahlungsart AS zahlungsart_11,
  t0.bezahltam AS bezahltam_12,
  t0.gedruckt AS gedruckt_13,
  t0.kabid AS kabid_14,
  t0.fiktiv AS fiktiv_15,
  t0.lastuser AS lastuser_16,
  t0.lastchange AS lastchange_17
FROM
  kassenbeleg t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.belegnr AS belegnr_2, t0.belegdat AS belegdat_3, t0.nlid AS nlid_4, t0.adrcode AS adrcode_5, t0.plzkunde AS plzkunde_6, t0.vortext AS vortext_7, t0.marktid AS marktid_8, t0.internetbnr AS internetbnr_9, t0.nachtext AS nachtext_10, t0.zahlungsart AS zahlungsart_11, t0.bezahltam AS bezahltam_12, t0.gedruckt AS gedruckt_13, t0.kabid AS kabid_14, t0.fiktiv AS fiktiv_15, t0.lastuser AS lastuser_16, t0.lastchange AS lastchange_17 FROM kassenbeleg t0 WHERE t0.id = 14754;

SELECT
  ROUND(
    SUM(
      (menge * epbrutto)+(
        (menge * epbrutto) * aufabschlagproz
      )
    ),
    2
  ) AS belegumme
FROM
  kassenbeleg_positionen
WHERE
  kassenbeleg_positionen.belegnr = ?

SELECT ROUND(SUM((menge * epbrutto)+((menge * epbrutto) * aufabschlagproz)), 2) AS belegumme
                FROM kassenbeleg_positionen
                WHERE kassenbeleg_positionen.belegnr = 7419;

SELECT
  SUM(
    (
      kassenbeleg_positionen.menge * kassenbeleg_positionen.epbrutto
    ) + (
      (
        kassenbeleg_positionen.menge * kassenbeleg_positionen.epbrutto
      ) * kassenbeleg_positionen.aufabschlagproz
    )
  ) AS tagessumme
FROM
  kassenbeleg
  LEFT JOIN kassenbeleg_positionen ON kassenbeleg.belegnr = kassenbeleg_positionen.belegnr
WHERE
  kassenbeleg.belegdat >= ?
  AND kassenbeleg.belegdat < ?

SELECT SUM(
                    (kassenbeleg_positionen.menge * kassenbeleg_positionen.epbrutto) +
                    ((kassenbeleg_positionen.menge * kassenbeleg_positionen.epbrutto) * 
                    kassenbeleg_positionen.aufabschlagproz)
                    ) AS tagessumme
                FROM kassenbeleg 
                LEFT JOIN kassenbeleg_positionen
                    ON kassenbeleg.belegnr = kassenbeleg_positionen.belegnr
                WHERE kassenbeleg.belegdat >= '2026.09.02 00:00:00'
                  AND kassenbeleg.belegdat <  '2026.09.03 00:00:00';

SELECT
  CONCAT(
    LEFT(sdzahlungsarten.zahlungsart, 1),
    kassenbeleg.belegnr
  ) AS beleg
FROM
  kassenbeleg
  LEFT JOIN sdzahlungsarten on kassenbeleg.zahlungsart = sdzahlungsarten.id
WHERE
  belegdat >= ?
  AND belegdat < ?
ORDER BY
  belegnr ASC

SELECT CONCAT( 
                           LEFT(sdzahlungsarten.zahlungsart, 1),
                           kassenbeleg.belegnr) AS beleg
                FROM kassenbeleg LEFT JOIN sdzahlungsarten
                    on kassenbeleg.zahlungsart = sdzahlungsarten.id
                WHERE belegdat >= '2026-09-02 00:00:00'
                  AND belegdat <  '2026-09-03 00:00:00' 
                ORDER BY belegnr ASC;

SELECT
  SUM(
    (
      kassenbeleg_positionen.menge * kassenbeleg_positionen.epbrutto
    ) + (
      (
        kassenbeleg_positionen.menge * kassenbeleg_positionen.epbrutto
      ) * kassenbeleg_positionen.aufabschlagproz
    )
  ) AS monatssumme
FROM
  kassenbeleg
  LEFT JOIN kassenbeleg_positionen ON kassenbeleg.belegnr = kassenbeleg_positionen.belegnr
WHERE
  kassenbeleg.belegdat >= ?
  AND kassenbeleg.belegdat < ?

SELECT SUM(
                    (kassenbeleg_positionen.menge * kassenbeleg_positionen.epbrutto) +
                    ((kassenbeleg_positionen.menge * kassenbeleg_positionen.epbrutto) *
                    kassenbeleg_positionen.aufabschlagproz)
                    ) AS monatssumme
                FROM kassenbeleg
                LEFT JOIN kassenbeleg_positionen
                    ON kassenbeleg.belegnr = kassenbeleg_positionen.belegnr
                WHERE kassenbeleg.belegdat >= '2026-09-01 00:00:00'
                AND kassenbeleg.belegdat < '2026-10-01 00:00:00';

SELECT
  SUM(
    (
      kassenbeleg_positionen.menge * kassenbeleg_positionen.epbrutto
    ) + (
      (
        kassenbeleg_positionen.menge * kassenbeleg_positionen.epbrutto
      ) * kassenbeleg_positionen.aufabschlagproz
    )
  ) AS monatssumme
FROM
  kassenbeleg
  LEFT JOIN kassenbeleg_positionen ON kassenbeleg.belegnr = kassenbeleg_positionen.belegnr
WHERE
  kassenbeleg.belegdat >= ?
  AND kassenbeleg.belegdat < ?

SELECT SUM(
                    (kassenbeleg_positionen.menge * kassenbeleg_positionen.epbrutto) +
                    ((kassenbeleg_positionen.menge * kassenbeleg_positionen.epbrutto) *
                    kassenbeleg_positionen.aufabschlagproz)
                    ) AS monatssumme
                FROM kassenbeleg
                LEFT JOIN kassenbeleg_positionen
                    ON kassenbeleg.belegnr = kassenbeleg_positionen.belegnr
                WHERE kassenbeleg.belegdat >= '2026-01-01 00:00:00'
                AND kassenbeleg.belegdat < '2027-01-01 00:00:00';

SELECT
  t0.id AS id_1,
  t0.anrede AS anrede_2,
  t0.akadtitel AS akadtitel_3,
  t0.nachname AS nachname_4,
  t0.vorname AS vorname_5,
  t0.firmenname AS firmenname_6,
  t0.taetigkeit AS taetigkeit_7,
  t0.abteilung AS abteilung_8,
  t0.adresszusatz AS adresszusatz_9,
  t0.strasse AS strasse_10,
  t0.plz AS plz_11,
  t0.ort AS ort_12,
  t0.bundesland AS bundesland_13,
  t0.land AS land_14,
  t0.kundennummer AS kundennummer_15,
  t0.adresstyp AS adresstyp_16,
  t0.geburtsdatum AS geburtsdatum_17,
  t0.privatdienstl AS privatdienstl_18,
  t0.notizen AS notizen_19,
  t0.internetbesteller AS internetbesteller_20,
  t0.eigeneadresse AS eigeneadresse_21,
  t0.lastuser AS lastuser_22,
  t0.lastchange AS lastchange_23
FROM
  sdadressen t0
ORDER BY
  t0.nachname ASC,
  t0.vorname ASC

SELECT t0.id AS id_1, t0.anrede AS anrede_2, t0.akadtitel AS akadtitel_3, t0.nachname AS nachname_4, t0.vorname AS vorname_5, t0.firmenname AS firmenname_6, t0.taetigkeit AS taetigkeit_7, t0.abteilung AS abteilung_8, t0.adresszusatz AS adresszusatz_9, t0.strasse AS strasse_10, t0.plz AS plz_11, t0.ort AS ort_12, t0.bundesland AS bundesland_13, t0.land AS land_14, t0.kundennummer AS kundennummer_15, t0.adresstyp AS adresstyp_16, t0.geburtsdatum AS geburtsdatum_17, t0.privatdienstl AS privatdienstl_18, t0.notizen AS notizen_19, t0.internetbesteller AS internetbesteller_20, t0.eigeneadresse AS eigeneadresse_21, t0.lastuser AS lastuser_22, t0.lastchange AS lastchange_23 FROM sdadressen t0 ORDER BY t0.nachname ASC, t0.vorname ASC;

SELECT
  t0.id AS id_1,
  t0.niederlassung AS niederlassung_2,
  t0.standard AS standard_3
FROM
  sdniederlassungen t0
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.niederlassung AS niederlassung_2, t0.standard AS standard_3 FROM sdniederlassungen t0 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.vontag AS vontag_2,
  t0.bistag AS bistag_3,
  t0.ort AS ort_4,
  t0.anlass AS anlass_5,
  t0.entfernung AS entfernung_6,
  t0.bemerkung AS bemerkung_7,
  t0.veranstalter AS veranstalter_8,
  t0.status AS status_9,
  t0.lastuser AS lastuser_10,
  t0.lastchange AS lastchange_11
FROM
  maerkte t0
ORDER BY
  t0.vontag DESC

SELECT t0.id AS id_1, t0.vontag AS vontag_2, t0.bistag AS bistag_3, t0.ort AS ort_4, t0.anlass AS anlass_5, t0.entfernung AS entfernung_6, t0.bemerkung AS bemerkung_7, t0.veranstalter AS veranstalter_8, t0.status AS status_9, t0.lastuser AS lastuser_10, t0.lastchange AS lastchange_11 FROM maerkte t0 ORDER BY t0.vontag DESC;

SELECT
  t0.id AS id_1,
  t0.zahlungsart AS zahlungsart_2,
  t0.standard AS standard_3
FROM
  sdzahlungsarten t0
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.zahlungsart AS zahlungsart_2, t0.standard AS standard_3 FROM sdzahlungsarten t0 ORDER BY t0.id ASC;