Query Metrics
4
Database Queries
4
Different statements
164.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
125.39 ms (76.32%) |
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 552" ":YIL" => 2024 ":AY" => "EKİM" ":OGUN" => "ÖĞLE" ":TURU" => "NORMAL" ] |
|
18.59 ms (11.31%) |
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 (19773029,19773030,19773028,19773031,19773032,19773034,19773033,19773035,19773036,19773037,19773038,19773039,19773040,19773042,19773041,19773043,19773045,19773046,19773044,19773047,19773048,19773049,19773050,19773051,19773052,19773053,19773054,19773055,19773056,19773058,19773057,19773059,19773062,19773060,19773061,19773063,19773065,19773066,19773064,19773067,19773068,19773069,19773070,19773071,19773072,19773073,19773074,19773075,19773076,19773078,19773077,19773079,19773082,19773081,19773080,19773083,19773084,19773086,19773085,19773087,19773089,19773090,19773088,19773091,19773093,19773094,19773092,19773095,19773099,19773096,19773098,19773097,19773100,19773101,19773102,19773103,19773104,19773106,19773105,19773107,19773108,19773109,19773110,19773111,19773112,19773114,19773113,19773115,19773118,19773116,19773117,19773119,19773120,19773121,19773122,19773123,19773126,19773124,19773125,19773127,19773129,19773130,19773128,19773131,19773135,19773132,19773134,19773133,19773136,19773138,19773137,19773139,19773141,19773142,19773140,19773143,19773144,19773146,19773145,19773147,19773150,19773148,19773149,19773151)
Parameters:
[] |
|
15.61 ms (9.50%) |
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 173 001-000','152 0080 009 001-000','152 0010 015 001-000','152 0200 005 001-000','152 0010 011 001-000','152 0080 018 001-000','152 0030 002 001-000','152 0180 048 001-000','152 0010 133 001-000','152 0020 127 001-000','152 0080 009 001-000','152 0170 005 001-000','152 0010 004 001-000','152 0080 001 001-000','152 0040 104 001-000','152 0180 048 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 0090 058 001-000','152 0180 048 001-000','152 0010 011 001-000','152 0020 028 001-000','152 0080 018 001-000','152 0170 005 001-000','152 0010 016 001-000','152 0080 009 001-000','152 0020 162 001-000','152 0200 005 001-000','152 0020 111 001-000','152 0010 113 001-000','152 0100 041 001-000','152 0180 048 001-000','152 0040 033 001-000','152 0080 009 001-000','152 0010 084 001-000','152 0170 005 001-000','152 0010 016 001-000','152 0300 001 001-000','152 0080 001 001-000','152 0180 048 001-000','152 0010 011 001-000','152 0020 127 001-000','152 0080 009 001-000','152 0170 005 001-000','152 0010 002 001-000','152 0080 001 001-000','152 0040 085 001-000','152 0230 014 001-000','152 0020 111 001-000','152 0110 025 001-000','152 0010 084 001-000','152 0180 048 001-000','152 0010 002 001-000','152 0080 009 001-000','152 0020 170 001-000','152 0170 005 001-000','152 0020 069 001-000','152 0020 111 001-000','152 0010 113 001-000','152 0180 048 001-000','152 0040 026 001-000','152 0080 009 001-000','152 0010 085 001-000','152 0170 005 001-000','152 0180 051 001-000','152 0010 019 001-000','152 0080 001 001-000','152 0030 025 001-000','152 0010 011 001-000','152 0020 106 001-000','152 0080 009 001-000','152 0200 005 001-000','152 0010 016 001-000','152 0090 073 001-000','152 0020 110 001-000','152 0170 005 001-000','152 0010 002 001-000','152 0020 069 001-000','152 0020 111 001-000','152 0180 048 001-000','152 0010 004 001-000','152 0080 009 001-000','152 0020 162 001-000','152 0200 005 001-000','152 0020 111 001-000','152 0010 015 001-000','152 0100 041 001-000','152 0180 048 001-000','152 0010 133 001-000','152 0020 046 001-000','152 0080 009 001-000','152 0170 005 001-000','152 0080 001 001-000','152 0010 113 001-000','152 0020 110 001-000','152 0180 048 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 0080 018 001-000','152 0030 100 001-000','152 0180 048 001-000','152 0020 016 001-000','152 0080 009 001-000','152 0010 113 001-000','152 0200 005 001-000','152 0010 019 001-000','152 0080 018 001-000','152 0030 076 001-000','152 0170 005 001-000','152 0080 009 001-000','152 0010 085 001-000','152 0020 162 001-000','152 0170 005 001-000')
Parameters:
[] |
|
4.72 ms (2.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:
[
379
]
|
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. |