http://musteri.keyveni.com.tr/api/menu/?ay=10&ogun=1&turu=NORMAL&yil=2024

Method
GET
HTTP Status
200
IP
185.241.101.200
Profiled on
Token
bac4f6

Query Metrics

7 Database Queries
5 Different statements
195.31 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 5.14 ms 
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
Parameters: 
[
  290
]
View formatted query    View runnable query    Explain query
2 130.61 ms 
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
Parameters: 
[
  ":CARIKODU" => "120 03 450"
  ":YIL" => 2024
  ":AY" => "EKİM"
  ":OGUN" => "ÖĞLE"
  ":TURU" => "NORMAL"
]
View formatted query    View runnable query    Explain query
3 18.76 ms 
select A.ANA_ID, A.KAYIT_ID, A.RECETEKODU as RECKODU, R.RECETEADI as RECADI, R.CINSI, R.CINSI2
					from CATRECETEDATA R
					inner join PLANALTERNATIF A on R.RECETEKODU=A.RECETEKODU 
					where A.ANA_ID in (19764139,19764140,19764138,19764141,19764142,19764144,19764143,19764145,19764146,19764147,19764148,19764149,19764153,19764150,19764151,19764152,19764155,19764156,19764154,19764157,19764158,19764159,19764160,19764161,19764165,19764162,19764164,19764163,19764166,19764167,19764168,19764169,19764171,19764172,19764170,19764173,19764174,19764177,19764176,19764175,19764178,19764182,19764183,19764180,19764179,19764181,19764184,19764185,19764186,19764187,19764188,19764190,19764189,19764191,19764192,19764193,19764194,19764195,19764196,19764197,19764198,19764199,19764202,19764200,19764201,19764203,19764205,19764206,19764204,19764207,19764208,19764209,19764210,19764211,19764212,19764213,19764214,19764215,19764216,19764218,19764217,19764219,19764220,19764222,19764221,19764223,19764224,19764226,19764225,19764227,19764230,19764228,19764229,19764231,19764232,19764235,19764233,19764234,19764237,19764238,19764236,19764239,19764241,19764242,19764240,19764243,19764247,19764244,19764246,19764245,19764248,19764250,19764249,19764251,19764254,19764253,19764252,19764255,19764256,19764257,19764258,19764259,19764261,19764262,19764260,19764263)
Parameters: 
[]
View formatted query    View runnable query    Explain query
4 16.65 ms 
select U.recetekodu, U.uyumsuzrecetekodu, UR.receteadi
                    from uyumsuzreceteler U
                    inner join catrecetedata UR on UR.recetekodu = U.uyumsuzrecetekodu
                    where U.silindi is null
                        and U.recetekodu IN ('152 0020 106 001-000','152 0100 040 001-000','152 0010 113 001-000','152 0200 005 001-000','152 0010 002 001-000','152 0090 058 001-000','152 0030 086 001-000','152 0180 048 001-000','152 0010 012 001-000','152 0020 127 001-000','152 0080 009 001-000','152 0230 014 001-000','152 0180 051 001-000','152 0010 016 001-000','152 0020 218 001-000','152 0080 001 001-000','152 0060 033 001-000','152 0080 009 001-000','152 0010 085 001-000','152 0200 005 001-000','152 0010 002 001-000','152 0040 006 001-000','152 0080 048 001-000','152 0180 048 001-000','152 0180 051 001-000','152 0010 011 001-000','152 0090 058 001-000','152 0020 200 001-000','152 0010 016 001-000','152 0070 003 001-000','152 0080 009 001-000','152 0150 003 001-000','152 0020 107 001-000','152 0080 018 001-000','152 0010 015 001-000','152 0170 005 001-000','152 0010 075 001-000','152 0203 001 001-000','152 0080 009 001-000','152 0020 150 001-000','152 0010 016 001-000','152 0040 066 001-000','152 0020 117 001-000','152 0090 058 001-000','152 0030 007 001-000','152 0180 048 001-000','152 0010 011 001-000','152 0020 129 001-000','152 0080 009 001-000','152 0200 005 001-000','152 0010 002 001-000','152 0080 001 001-000','152 0040 085 001-000','152 0230 014 001-000','152 0010 004 001-000','152 0040 026 001-000','152 0080 009 001-000','152 0170 005 001-000','152 0010 012 001-000','152 0020 046 001-000','152 0080 044 001-000','152 0150 003 001-000','152 0080 018 001-000','152 0010 113 001-000','152 0030 076 001-000','152 0180 048 001-000','152 0060 034 001-000','152 0080 009 001-000','152 0010 015 001-000','152 0230 014 001-000','152 0010 019 001-000','152 0020 218 001-000','152 0080 001 001-000','152 0230 014 001-000','152 0010 011 001-000','152 0040 033 001-000','152 0080 009 001-000','152 0200 005 001-000','152 0010 016 001-000','152 0090 073 001-000','152 0041 010 001-000','152 0170 005 001-000','152 0010 002 001-000','152 0090 009 001-000','152 0030 011 001-000','152 0180 048 001-000','152 0010 004 001-000','152 0080 009 001-000','152 0020 150 001-000','152 0200 005 001-000','152 0020 111 001-000','152 0010 015 001-000','152 0100 041 001-000','152 0170 005 001-000','152 0010 029 001-000','152 0203 001 001-000','152 0070 005 001-000','152 0080 009 001-000','152 0040 056 001-000','152 0080 009 001-000','152 0010 113 001-000','152 0230 014 001-000','152 0060 033 001-000','152 0080 009 001-000','152 0010 084 001-000','152 0200 005 001-000','152 0180 051 001-000','152 0010 019 001-000','152 0090 058 001-000','152 0020 125 001-000','152 0010 004 001-000','152 0020 111 001-000','152 0110 025 001-000','152 0180 048 001-000','152 0080 001 001-000','152 0020 142 001-000','152 0010 113 001-000','152 0200 005 001-000','152 0010 004 001-000','152 0020 069 001-000','152 0020 111 001-000','152 0230 014 001-000','152 0060 034 001-000','152 0090 058 001-000','152 0010 085 001-000','152 0170 005 001-000')
Parameters: 
[]
View formatted query    View runnable query    Explain query
5 9.16 ms 
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
Parameters: 
[
  ":CARIKODU" => "120 03 450"
  ":YIL" => 2024
  ":AY" => "EKİM"
  ":OGUN" => "AKŞAM"
  ":TURU" => "MESAİ"
]
View formatted query    View runnable query    Explain query
6 5.29 ms 
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
Parameters: 
[
  ":CARIKODU" => "120 03 450"
  ":YIL" => 2024
  ":AY" => "EKİM"
  ":OGUN" => "GECE"
  ":TURU" => "MESAİ"
]
View formatted query    View runnable query    Explain query
7 9.69 ms 
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
Parameters: 
[
  ":CARIKODU" => "120 03 450"
]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\MusteriMenu No errors.
App\Entity\User No errors.
App\Entity\Cari No errors.