http://musteri.keyveni.com.tr/api/menu/save Return to referer URL

Method
POST
HTTP Status
200
IP
31.223.35.155
Profiled on
Token
1e70bb

Query Metrics

6 Database Queries
5 Different statements
167.42 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 4.80 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: 
[
  469
]
View formatted query    View runnable query    Explain query
2 116.55 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 700"
  ":YIL" => 2026
  ":AY" => "NİSAN"
  ":OGUN" => "ÖĞLE"
  ":TURU" => "NORMAL"
]
View formatted query    View runnable query    Explain query
3 23.14 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 (21732508,21732509,21732510,21744305,21732511,21732512,21732513,21744306,21732514,21744307,21732515,21732516,21732517,21732518,21744308,21732519,21732520,21732521,21732522,21744309,21732523,21732524,21732526,21732525,21744310,21732527,21732528,21732530,21732529,21744311,21732531,21732532,21732533,21744312,21732535,21744313,21732534,21732536,21732538,21732537,21744314,21732539,21732540,21732541,21732542,21744315,21732543,21732544,21732545,21732546,21744316,21732547,21732549,21732550,21732548,21732551,21732552,21732553,21732554,21732555,21744317,21732558,21732556,21732557,21744318,21732559,21732562,21732561,21732560,21744319,21732563,21732564,21732565,21732566,21744320,21732567,21732569,21732570,21732568,21744321,21732571,21732572,21732573,21732574,21744322,21732575,21732576,21732577,21732578,21732579,21732580,21732581,21732582,21744323,21732583,21732586,21732584,21732585,21744324,21732587,21732588,21732589,21744325,21732590,21732591,21744326,21732592,21732594,21732593,21744327,21732595,21732596,21732597,21732598,21744328,21732599,21732600,21732602,21732601,21744329,21732603,21732606,21732604,21732605,21744330,21732607,21732608,21732609,21732610,21744331,21732611,21732613,21732612,21732614,21744332,21732615,21732616,21732617,21744333,21732618,21744334,21732619,21732622,21732621,21732620,21744335,21732623,21732624,21732625,21732626,21744336,21732627)
Parameters: 
[]
View formatted query    View runnable query    Explain query
4 19.04 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 0010 004 001-000','152 0020 149 001-000','152 0080 009 001-000','152 0120 008 001-000','152 0180 048 001-000','152 0010 012 001-000','152 0020 016 001-000','152 0130 004 001-000','152 0080 009 001-000','152 0120 008 001-000','152 0230 014 001-000','152 0010 004 001-000','152 0020 116 001-000','152 0090 058 001-000','152 0120 008 001-000','152 0170 005 001-000','152 0010 042 001-000','152 0020 035 001-000','152 0080 007 001-000','152 0120 008 001-000','152 0170 008 001-000','152 0010 012 001-000','152 0090 009 001-000','152 0020 200 001-000','152 0120 008 001-000','152 0200 005 001-000','152 0010 019 001-000','152 0040 026 001-000','152 0080 018 001-000','152 0120 008 001-000','152 0180 048 001-000','152 0010 012 001-000','152 0070 003 001-000','152 0130 004 001-000','152 0080 009 001-000','152 0120 008 001-000','152 0230 014 001-000','152 0010 011 001-000','152 0090 058 001-000','152 0030 076 001-000','152 0120 008 001-000','152 0200 232 001-000','152 0010 128 001-000','152 0021 003 001-000','152 0080 009 001-000','152 0120 008 001-000','152 0200 005 001-000','152 0010 016 001-000','152 0020 107 001-000','152 0090 058 001-000','152 0120 008 001-000','152 0170 005 001-000','152 0020 006 001-000','152 0090 058 001-000','152 0010 015 001-000','152 0120 008 001-000','152 0010 029 001-000','152 0020 016 001-000','152 0090 058 001-000','152 0120 007 001-000','152 0120 008 001-000','152 0080 018 001-000','152 0010 113 001-000','152 0030 086 001-000','152 0120 008 001-000','152 0200 005 001-000','152 0080 009 001-000','152 0020 114 001-000','152 0010 085 001-000','152 0120 008 001-000','152 0230 014 001-000','152 0010 002 001-000','152 0020 123 001-000','152 0090 058 001-000','152 0120 008 001-000','152 0200 232 001-000','152 0020 016 001-000','152 0080 009 001-000','152 0010 015 001-000','152 0120 008 001-000','152 0170 005 001-000','152 0010 004 001-000','152 0300 001 001-000','152 0080 018 001-000','152 0120 008 001-000','152 0180 048 001-000','152 0010 016 001-000','152 0020 116 001-000','152 0090 061 001-000','152 0120 008 001-000','152 0010 042 001-000','152 0020 127 001-000','152 0080 053 001-000','152 0120 008 001-000','152 0200 005 001-000','152 0090 058 001-000','152 0010 015 001-000','152 0020 200 001-000','152 0120 008 001-000','152 0230 014 001-000','152 0010 012 001-000','152 0070 003 001-000','152 0130 004 001-000','152 0080 009 001-000','152 0150 015 001-000','152 0120 008 001-000','152 0010 011 001-000','152 0080 018 001-000','152 0030 025 001-000','152 0120 008 001-000','152 0170 005 001-000','152 0010 016 001-000','152 0060 034 001-000','152 0080 009 001-000','152 0120 008 001-000','152 0200 232 001-000','152 0010 128 001-000','152 0020 111 001-000','152 0100 041 001-000','152 0120 008 001-000','152 0180 048 001-000','152 0080 045 001-000','152 0010 015 001-000','152 0020 162 001-000','152 0120 008 001-000','152 0170 005 001-000','152 0010 012 001-000','152 0060 034 001-000','152 0080 037 001-000','152 0120 008 001-000','152 0200 005 001-000','152 0090 058 001-000','152 0010 113 001-000','152 0030 034 001-000','152 0120 008 001-000','152 0180 048 001-000','152 0010 042 001-000','152 0020 016 001-000','152 0130 004 001-000','152 0080 009 001-000','152 0120 008 001-000','152 0230 014 001-000','152 0010 002 001-000','152 0020 111 001-000','152 0110 025 001-000','152 0120 008 001-000','152 0180 048 001-000','152 0010 029 001-000','152 0020 127 001-000','152 0080 009 001-000','152 0120 008 001-000','152 0200 232 001-000')
Parameters: 
[]
View formatted query    View runnable query    Explain query
5 2.68 ms 
update PLANLISTMUS SET RECKODU=?,
				RECADI=(select RECETEADI from CATRECETEDATA R where R.RECETEKODU=?),
				ORAN=?
				where KAYIT_ID=?
Parameters: 
[
  "152 0080 018 001-000"
  "152 0080 018 001-000"
  null
  21732538
]
View formatted query    View runnable query    Explain query
6 1.21 ms 
update PLANLISTMUS SET RECKODU=?,
				RECADI=(select RECETEADI from CATRECETEDATA R where R.RECETEKODU=?),
				ORAN=?
				where KAYIT_ID=?
Parameters: 
[
  "152 0030 035 001-000"
  "152 0030 035 001-000"
  null
  21732537
]
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\User No errors.
App\Entity\Cari No errors.
App\Entity\MusteriMenu No errors.