http://musteri.keyveni.com.tr/api/menu/excel?ay=3&canEdit=true&ogun=1&turu=NORMAL&yil=2025

Method
GET
HTTP Status
200
IP
88.233.58.77
Profiled on
Token
be53d4

Query Metrics

4 Database Queries
4 Different statements
258.80 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
219.59 ms
(84.85%) 		1 
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 431"
  ":YIL" => 2025
  ":AY" => "MART"
  ":OGUN" => "ÖĞLE"
  ":TURU" => "NORMAL"
]
View formatted query    View runnable query    Explain query
18.93 ms
(7.32%) 		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 (19994309,19994310,19994311,19994312,19994315,19994316,19994314,19994317,19994319,19994320,19994321,19994322,19994324,19994325,19994326,19994327,19994328,19994332,19994330,19994329,19994331,19994334,19994335,19994336,19994337,19994342,19994343,19994340,19994341,19994345,19994346,19994347,19994348,19994352,19994350,19994351,19994353,19994355,19994356,19994357,19994358,19994362,19994361,19994360,19994363,19994367,19994365,19994366,19994368,19994370,19994371,19994373,19994372,20032172,20032173,20032174,20032175,20032179,20032178,20032177,20032180,20032182,20032184,20032183,20032185,20032187,20032189,20032188,20032190,20032194,20032195,20032193,20032196,20032198,20032199,20032200,20032201,20032204,20032205,20032203,20032206,20032210,20032208,20032209,20032211,20032213,20032215,20032214,20032216,20032218,20032219,20032220,20032221,20032224,20032225,20032223,20032226,20032229,20032230,20032231,20032228,20032235,20032233,20032234,20032236,20032238,20032239,20032240,20032241,20037388,20037385,20037386,20037387,20037390,20037391,20037392,20037393,20037397,20037398,20037395,20037396,20041990,20041991,20041992,20041993)
Parameters: 
[]
View formatted query    View runnable query    Explain query
15.45 ms
(5.97%) 		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 0010 011 001-000','152 0020 035 001-000','152 0080 007 001-000','152 0200 005 001-000','152 0020 127 001-000','152 0090 056 001-000','152 0010 015 001-000','152 0230 014 001-000','152 0010 011 001-000','152 0110 025 001-000','152 0060 067 001-000','152 0180 048 001-000','152 0010 002 001-000','152 0021 010 001-000','152 0100 040 001-000','152 0200 021 001-000','152 0010 004 001-000','152 0040 066 001-000','152 0080 009 001-000','152 0030 007 001-000','152 0170 005 001-000','152 0010 016 001-000','152 0020 016 001-000','152 0080 009 001-000','152 0200 232 001-000','152 0080 048 001-000','152 0150 003 001-000','152 0010 085 001-000','152 0040 085 001-000','152 0010 016 001-000','152 0020 106 001-000','152 0090 058 001-000','152 0200 232 001-000','152 0090 056 001-000','152 0010 084 001-000','152 0070 001 001-000','152 0230 014 001-000','152 0010 004 001-000','152 0040 026 001-000','152 0080 018 001-000','152 0180 048 001-000','152 0080 009 001-000','152 0020 126 001-000','152 0010 084 001-000','152 0200 232 001-000','152 0020 111 001-000','152 0010 015 001-000','152 0100 041 001-000','152 0180 048 001-000','152 0021 003 001-000','152 0090 058 001-000','152 0010 085 001-000','152 0200 232 001-000','152 0010 047 001-000','152 0040 027 001-000','152 0080 009 001-000','152 0150 003 001-000','152 0090 058 001-000','152 0020 114 001-000','152 0010 015 001-000','152 0230 014 001-000','152 0010 030 001-000','152 0080 018 001-000','152 0030 053 001-000','152 0200 005 001-000','152 0010 002 001-000','152 0090 058 001-000','152 0070 001 001-000','152 0180 048 001-000','152 0020 033 001-000','152 0080 009 001-000','152 0010 085 001-000','152 0200 005 001-000','152 0010 016 001-000','152 0060 018 001-000','152 0080 045 001-000','152 0200 232 001-000','152 0021 003 001-000','152 0080 009 001-000','152 0010 113 001-000','152 0230 014 001-000','152 0090 015 001-000','152 0010 085 001-000','152 0020 166 001-000','152 0180 048 001-000','152 0010 016 001-000','152 0080 009 001-000','152 0020 150 001-000','152 0200 232 001-000','152 0010 011 001-000','152 0070 003 001-000','152 0080 018 001-000','152 0180 048 001-000','152 0020 034 001-000','152 0090 058 001-000','152 0010 084 001-000','152 0200 232 001-000','152 0020 129 001-000','152 0080 009 001-000','152 0150 003 001-000','152 0010 113 001-000','152 0060 066 001-000','152 0010 084 001-000','152 0100 041 001-000','152 0180 048 001-000','152 0010 012 001-000','152 0021 003 001-000','152 0090 058 001-000','152 0230 014 001-000','152 0090 047 001-000','152 0010 113 001-000','152 0020 192 001-000','152 0200 005 001-000','152 0010 002 001-000','152 0020 218 001-000','152 0080 009 001-000','152 0180 048 001-000','152 0080 009 001-000','152 0150 003 001-000','152 0010 015 001-000','152 0030 076 001-000','152 0010 019 001-000','152 0040 056 001-000','152 0080 018 001-000','152 0180 048 001-000')
Parameters: 
[]
View formatted query    View runnable query    Explain query
4.83 ms
(1.87%) 		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: 
[
  270
]
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.