Symfony Profiler

select
  P.KAYIT_ID,
  P.CARIKODU,
  P.RECKODU,
  COALESCE(R.RECETEADI2, P.RECADI) as RECADI,
  coalesce(P.SEC, '0') as SEC,
  P.TARIH,
  P.ADET,
  R.CINSI,
  R.CINSI2,
  P.ORAN,
  SUM(
    COALESCE(
      s2.kalorimik * r2.miktarnet / IIF(
        s2.KALORIORAN = 0, 1, s2.KALORIORAN
      ),
      0
    )
  ) AS kalori
from
  PLANLISTMUS P
  left join CATRECETEDATA R on R.recetekodu = P.reckodu
  LEFT JOIN catrecmalzlist r2 ON r2.recetekodu = p.reckodu
  INNER JOIN stoklar s2 ON s2.stokkodu = r2.malzemekodu
where
  P.carikodu = :CARIKODU
  and P.YIL = :YIL
  and P.AY = :AY
  and P.OGUN = :OGUN
  and P.TURU = :TURU
GROUP BY
  KAYIT_ID,
  CARIKODU,
  RECKODU,
  RECADI,
  SEC,
  TARIH,
  ADET,
  CINSI,
  CINSI2,
  ORAN,
  R.SIRANO
ORDER BY
  P.tarih,
  R.SIRANO,
  P.reckodu

select P.KAYIT_ID, P.CARIKODU, P.RECKODU, COALESCE(R.RECETEADI2, P.RECADI) as RECADI,
                    coalesce(P.SEC, '0') as SEC, P.TARIH, P.ADET, R.CINSI, R.CINSI2, P.ORAN,
                    SUM(COALESCE(s2.kalorimik * r2.miktarnet / IIF(s2.KALORIORAN=0,1,s2.KALORIORAN),0)) AS kalori
                from PLANLISTMUS P
                left join CATRECETEDATA R on R.recetekodu = P.reckodu
                LEFT JOIN catrecmalzlist r2 ON r2.recetekodu = p.reckodu
                INNER JOIN stoklar s2 ON s2.stokkodu = r2.malzemekodu
                where
                    P.carikodu = :CARIKODU
                    and P.YIL = :YIL
                    and P.AY = :AY
                    and P.OGUN = :OGUN
                    and P.TURU = :TURU
                GROUP BY KAYIT_ID, CARIKODU, RECKODU, RECADI, SEC, TARIH, ADET, CINSI, CINSI2, ORAN, R.SIRANO
                ORDER BY P.tarih, R.SIRANO,  P.reckodu;

select
  CY.yemekgrubukodu as GRUPKODU,
  CY.GRUPADI,
  cast(CY.maxadet as integer) as MAXADET,
  0 as TOPLAM
from
  cari_yemekgruplari CY
where
  CY.carikodu = :CARIKODU
order by
  GRUPKODU

select CY.yemekgrubukodu as GRUPKODU, CY.GRUPADI, cast(CY.maxadet as integer) as MAXADET, 0 as TOPLAM
                from cari_yemekgruplari CY
                where CY.carikodu=:CARIKODU
                order by GRUPKODU;

SELECT
  t0.id AS ID_1,
  t0.KULLANICI_ADI AS KULLANICI_ADI_2,
  t0.roles AS ROLES_3,
  t0.sifre AS SIFRE_4,
  t0.modules AS MODULES_5,
  t0.modified_at AS MODIFIED_AT_6,
  t0.activation_key AS ACTIVATION_KEY_7,
  t0.alanlar AS ALANLAR_8,
  t0.cari_id AS CARI_ID_9,
  t10.cari_id AS CARI_ID_11,
  t10.FIRMAKODU AS FIRMAKODU_12,
  t10.FIRMAADI AS FIRMAADI_13,
  t10.unvan2 AS UNVAN2_14,
  t10.aktif AS AKTIF_15
FROM
  "MOBIL_KULLANICI" t0
  INNER JOIN "CARI_KART" t10 ON t0.cari_id = t10.cari_id
WHERE
  t0.id = ? ROWS 1 TO 9000000000000000000

SELECT t0.id AS ID_1, t0.KULLANICI_ADI AS KULLANICI_ADI_2, t0.roles AS ROLES_3, t0.sifre AS SIFRE_4, t0.modules AS MODULES_5, t0.modified_at AS MODIFIED_AT_6, t0.activation_key AS ACTIVATION_KEY_7, t0.alanlar AS ALANLAR_8, t0.cari_id AS CARI_ID_9, t10.cari_id AS CARI_ID_11, t10.FIRMAKODU AS FIRMAKODU_12, t10.FIRMAADI AS FIRMAADI_13, t10.unvan2 AS UNVAN2_14, t10.aktif AS AKTIF_15 FROM "MOBIL_KULLANICI" t0 INNER JOIN "CARI_KART" t10 ON t0.cari_id = t10.cari_id WHERE t0.id = 81 ROWS 1 TO 9000000000000000000;