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

Method
GET
HTTP Status
200
IP
85.105.82.173
Profiled on
Token
d84766

Query Metrics

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

Grouped Statements

Show all queries

Time▼ Count Info
175.68 ms
(74.24%) 		3 
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 488"
  ":YIL" => 2024
  ":AY" => "ARALIK"
  ":OGUN" => "ÖĞLE"
  ":TURU" => "NORMAL"
]
View formatted query    View runnable query    Explain query
24.49 ms
(10.35%) 		1 
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 (20079445,20079442,20079444,20079443,20079447,20079446,20079448,20079449,20079450,20079452,20079455,20079451,20079453,20079456,20079454,20079457,20079461,20079458,20079459,20079460,20079462,20079466,20079464,20079463,20079465,20079467,20079471,20079469,20079468,20079470,20079472,20079473,20079474,20079475,20079476,20079477,20079478,20079479,20079481,20079480,20079482,20079483,20079484,20079489,20079487,20079485,20079486,20079488,20079490,20079494,20079491,20079492,20079493,20079497,20079500,20079495,20079498,20079496,20079499,20079503,20079501,20079502,20079504,20079505,20079507,20079508,20079506,20079509,20079510,20079511,20079512,20079513,20079516,20079515,20079517,20079518,20079514,20079519,20079524,20079520,20079522,20079523,20079525,20079521,20079530,20079526,20079533,20079531,20079532,20079528,20079527,20079529,20079539,20079535,20079538,20079536,20079534,20079537,20079541,20079540,20079542,20079543,20079544,20079549,20079545,20079546,20079548,20079547,20079551,20079550,20079552,20079553,20079555,20079554,20079557,20079558,20079556,20079563,20079564,20079561,20079559,20079562,20079560,20079568,20079565,20079571,20079566,20079567,20079569,20079570,20079573,20079572,20079574,20079575,20079576,20079577,20079578,20079579,20079580,20079581,20079583,20079584,20079582,20079586,20079585,20079588,20079587,20079589,20079590,20079591,20079592,20079593,20079594,20079596,20079595,20079597,20079599,20079598,20079600,20079601,20079602)
Parameters: 
[]
View formatted query    View runnable query    Explain query
21.76 ms
(9.19%) 		1 
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 0180 051 001-000','152 0010 011 001-000','152 0090 058 001-000','152 0040 085 001-000','152 0010 011 001-000','152 0270 097 001-000','152 0020 012 001-000','152 0080 009 001-000','152 0170 005 001-000','152 0010 012 001-000','152 0203 001 001-000','152 0270 097 001-000','152 0070 003 001-000','152 0130 004 001-000','152 0080 009 001-000','152 0010 016 001-000','152 0270 097 001-000','152 0300 001 001-000','152 0080 001 001-000','152 0120 004 001-000','152 0010 000 001-000','152 0270 097 001-000','152 0090 058 001-000','152 0020 115 001-000','152 0200 232 001-000','152 0010 055 001-000','152 0270 097 001-000','152 0040 021 001-000','152 0080 009 001-000','152 0170 005 001-000','152 0010 002 001-000','152 0020 035 001-000','152 0090 058 001-000','152 0200 005 001-000','152 0010 004 001-000','152 0020 006 001-000','152 0080 009 001-000','152 0230 014 001-000','152 0010 016 001-000','152 0270 097 001-000','152 0020 010 001-000','152 0080 009 001-000','152 0170 005 001-000','152 0270 097 001-000','152 0090 007 001-000','152 0010 084 001-000','152 0020 150 001-000','152 0230 014 001-000','152 0010 019 001-000','152 0270 097 001-000','152 0090 058 001-000','152 0020 131 001-000','152 0200 232 001-000','152 0010 002 001-000','152 0203 001 001-000','152 0270 097 001-000','152 0020 016 001-000','152 0130 004 001-000','152 0080 009 001-000','152 0010 011 001-000','152 0270 097 001-000','152 0040 003 001-000','152 0080 045 001-000','152 0120 004 001-000','152 0020 106 001-000','152 0080 009 001-000','152 0010 085 001-000','152 0200 005 001-000','152 0010 002 001-000','152 0040 003 001-000','152 0080 018 001-000','152 0150 003 001-000','152 0010 016 001-000','152 0270 097 001-000','152 0020 028 001-000','152 0080 009 001-000','152 0130 042 001-000','152 0200 021 001-000','152 0180 051 001-000','152 0270 097 001-000','152 0060 034 001-000','152 0090 007 001-000','152 0090 058 001-000','152 0010 085 001-000','152 0180 052 001-000','152 0010 011 001-000','152 0270 097 001-000','152 0040 066 001-000','152 0020 117 001-000','152 0080 009 001-000','152 0030 007 001-000','152 0170 005 001-000','152 0270 097 001-000','152 0070 003 001-000','152 0130 004 001-000','152 0080 009 001-000','152 0010 089 001-000','152 0200 005 001-000','152 0010 004 001-000','152 0270 097 001-000','152 0020 218 001-000','152 0090 058 001-000','152 0120 008 001-000','152 0010 011 001-000','152 0270 097 001-000','152 0090 058 001-000','152 0020 114 001-000','152 0200 021 001-000','152 0010 016 001-000','152 0090 058 001-000','152 0040 085 001-000','152 0230 014 001-000','152 0010 011 001-000','152 0270 097 001-000','152 0090 058 001-000','152 0120 004 001-000','152 0030 002 001-000','152 0203 001 001-000','152 0270 097 001-000','152 0020 016 001-000','152 0130 004 001-000','152 0080 009 001-000','152 0010 015 001-000','152 0180 051 001-000','152 0010 016 001-000','152 0270 097 001-000','152 0020 069 001-000','152 0060 066 001-000','152 0120 071 001-000','152 0120 072 001-000','152 0010 004 001-000','152 0270 097 001-000','152 0060 035 001-000','152 0080 009 001-000','152 0150 003 001-000','152 0130 068 001-000','152 0270 097 001-000','152 0010 074 001-000','152 0020 116 001-000','152 0080 019 001-000','152 0120 071 001-000','152 0120 072 001-000','152 1014 001 001-000','152 0010 011 001-000','152 0270 097 001-000','152 0090 058 001-000','152 0020 114 001-000','152 0200 232 001-000','152 0010 004 001-000','152 0020 218 001-000','152 0080 009 001-000','152 0230 014 001-000','152 0010 004 001-000','152 0080 009 001-000','152 0030 100 001-000','152 0170 005 001-000','152 0010 011 001-000','152 0270 097 001-000','152 0080 009 001-000','152 0020 177 001-000','152 0200 005 001-000')
Parameters: 
[]
View formatted query    View runnable query    Explain query
9.90 ms
(4.18%) 		1 
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 488"
]
View formatted query    View runnable query    Explain query
4.79 ms
(2.03%) 		1 
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: 
[
  342
]
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.