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

Method
GET
HTTP Status
200
IP
78.174.220.128
Profiled on
Token
ee8d44

Query Metrics

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

Grouped Statements

Show all queries

Time▼ Count Info
151.73 ms
(75.63%) 		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 001-000 S209"
  ":YIL" => 2024
  ":AY" => "TEMMUZ"
  ":OGUN" => "ÖĞLE"
  ":TURU" => "NORMAL"
]
View formatted query    View runnable query    Explain query
19.15 ms
(9.55%) 		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 (19300289,19300287,19300288,19300290,19300291,19300292,19300293,19300294,19300295,19300297,19300296,19300298,19300300,19300301,19300299,19300302,19300303,19300305,19300304,19300306,19300308,19300309,19300310,19300307,19300311,19300312,19300313,19300314,19300315,19300316,19300317,19300318,19300322,19300320,19300321,19300319,19300325,19300324,19300323,19300326,19300327,19300328,19300329,19300330,19300331,19300332,19300333,19300334,19300335,19300336,19300337,19300338,19300342,19300339,19300341,19300340,19300343,19300344,19300345,19300346,19300350,19300348,19300349,19300347,19300351,19349449,19349450,19300352,19300354,19300353,19300355,19300356,19300357,19300358,19300359,19300360,19300361,19300362,19300364,19300363,19300365,19300366,19300367,19300368,19300369,19300370,19300371,19300372,19300373,19300374,19300375,19300376,19300377,19300378,19300379,19300381,19300380,19300382,19300385,19300383,19300384,19300386,19300390,19300387,19300389,19300388,19300391,19300392,19300393,19300394,19300397,19300395,19300396,19300398,19300401,19300399,19300400,19300402,19300403,19300404,19300405,19300406,19300407,19300408,19300409,19300410)
Parameters: 
[]
View formatted query    View runnable query    Explain query
15.38 ms
(7.66%) 		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 0020 111 001-000','152 0010 015 001-000','152 0100 041 001-000','152 0200 005 001-000','152 0010 004 001-000','152 0021 025 001-000','152 0100 040 001-000','152 0170 005 001-000','152 0010 011 001-000','152 0080 001 001-000','152 0030 076 001-000','152 0180 048 001-000','152 0060 034 001-000','152 0080 007 001-000','152 0010 085 001-000','152 0200 005 001-000','152 0010 019 001-000','152 0080 009 001-000','152 0020 166 001-000','152 0230 014 001-000','152 0020 127 001-000','152 0090 009 001-000','152 0150 003 001-000','152 0010 113 001-000','152 0010 004 001-000','152 0040 018 001-000','152 0080 018 001-000','152 0180 048 001-000','152 0010 011 001-000','152 0020 107 001-000','152 0090 058 001-000','152 0200 005 001-000','152 0203 001 001-000','152 0020 037 001-000','152 0080 009 001-000','152 0010 113 001-000','152 0020 111 001-000','152 0110 025 001-000','152 0010 015 001-000','152 0230 014 001-000','152 0010 011 001-000','152 0020 016 001-000','152 0080 009 001-000','152 0150 003 001-000','152 0010 016 001-000','152 0300 001 001-000','152 0080 018 001-000','152 0180 048 001-000','152 0010 004 001-000','152 0060 033 001-000','152 0080 009 001-000','152 0170 005 001-000','152 0180 051 001-000','152 0010 019 001-000','152 0080 001 001-000','152 0020 125 001-000','152 0010 004 001-000','152 0040 003 001-000','152 0090 058 001-000','152 0200 005 001-000','152 0203 001 001-000','152 0070 005 001-000','152 0080 009 001-000','152 0010 015 001-000','152 0010 002 001-000','152 0040 066 001-000','152 0020 117 001-000','152 0080 018 001-000','152 0030 007 001-000','152 0170 005 001-000','152 0010 004 001-000','152 0021 025 001-000','152 0090 058 001-000','152 0230 014 001-000','152 0010 016 001-000','152 0020 107 001-000','152 0080 008 001-000','152 0150 003 001-000','152 0021 001 001-000','152 0010 075 001-000','152 0090 015 001-000','152 0150 003 001-000','152 0010 042 001-000','152 0020 037 001-000','152 0080 009 001-000','152 0200 005 001-000','152 0010 011 001-000','152 0040 003 001-000','152 0080 018 001-000','152 0170 005 001-000','152 0010 016 001-000','152 0070 015 001-000','152 0080 009 001-000','152 0200 005 001-000','152 0010 004 001-000','152 0090 058 001-000','152 0020 200 001-000','152 0230 014 001-000','152 0080 009 001-000','152 0010 085 001-000','152 0020 162 001-000','152 0170 005 001-000','152 0180 051 001-000','152 0010 002 001-000','152 0080 001 001-000','152 0030 002 001-000','152 0010 004 001-000','152 0021 003 001-000','152 0080 009 001-000','152 0180 048 001-000','152 0090 056 001-000','152 0010 015 001-000','152 0040 114 001-000','152 0230 014 001-000','152 0020 111 001-000','152 0010 084 001-000','152 0100 041 001-000','152 0180 048 001-000','152 0010 016 001-000','152 0020 127 001-000','152 0090 009 001-000','152 0170 005 001-000','152 0010 004 001-000','152 0020 069 001-000','152 0020 111 001-000','152 0230 014 001-000')
Parameters: 
[]
View formatted query    View runnable query    Explain query
9.52 ms
(4.74%) 		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 001-000 S209"
]
View formatted query    View runnable query    Explain query
4.84 ms
(2.41%) 		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: 
[
  18
]
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.