Query Metrics
4
Database Queries
4
Different statements
182.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
145.24 ms (79.55%) |
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 588" ":YIL" => 2025 ":AY" => "ŞUBAT" ":OGUN" => "ÖĞLE" ":TURU" => "NORMAL" ] |
|
17.72 ms (9.70%) |
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 (20334817,20334818,20334816,20334819,20334820,20334822,20334821,20334823,20334824,20334825,20334826,20334827,20334828,20334829,20334832,20334830,20334831,20334834,20334835,20334833,20334836,20334839,20334837,20334838,20334840,20334841,20334842,20334843,20334844,20334845,20334847,20334846,20334848,20334850,20334849,20334851,20334852,20334853,20334855,20334854,20334856,20334858,20334859,20334860,20334857,20334862,20334863,20334861,20334864,20334865,20334866,20334867,20334868,20334871,20334870,20334869,20334873,20334872,20334874,20334876,20334877,20334878,20334875,20334879,20334880,20334881,20334882,20334883,20334884,20334885,20334886,20334887,20334890,20334888,20334891,20334889,20334892,20334893,20334894,20334895,20334897,20334898,20334896,20334899,20334901,20334902,20334900,20334903,20334906,20334907,20334904,20334905,20334908,20334909,20334910,20334911,20334912,20334914,20334913,20334915,20334918,20334916,20334919,20334917,20334922,20334920,20334921,20334923,20334924,20334925,20334928,20334926,20334927,20334929,20334931,20334930,20334932)
Parameters:
[] |
|
14.77 ms (8.09%) |
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 0021 001 001-000','152 0090 015 001-000','152 0010 015 001-000','152 0170 005 001-000','152 0010 012 001-000','152 0080 001 001-000','152 0040 085 001-000','152 0120 008 001-000','152 0010 016 001-000','152 0020 012 001-000','152 0080 009 001-000','152 0120 008 001-000','152 0010 011 001-000','152 0020 016 001-000','152 0130 004 001-000','152 0080 009 001-000','152 0150 003 001-000','152 0020 017 001-000','152 0090 015 001-000','152 0010 015 001-000','152 0200 232 001-000','152 0100 040 001-000','152 0010 085 001-000','152 0070 001 001-000','152 0120 008 001-000','152 0010 019 001-000','152 0040 027 001-000','152 0090 058 001-000','152 0150 003 001-000','152 0010 029 001-000','152 0080 009 001-000','152 0020 105 001-000','152 0200 005 001-000','152 0020 216 001-000','152 0010 042 001-000','152 0090 056 001-000','152 0200 021 001-000','152 0010 011 001-000','152 0090 058 001-000','152 0040 104 001-000','152 0120 008 001-000','152 0040 114 001-000','152 0080 009 001-000','152 0150 003 001-000','152 0010 084 001-000','152 0040 016 001-000','152 0090 058 001-000','152 0010 113 001-000','152 0170 005 001-000','152 0010 011 001-000','152 0070 003 001-000','152 0080 009 001-000','152 0200 021 001-000','152 0010 128 001-000','152 0040 007 001-000','152 0020 117 001-000','152 0090 058 001-000','152 0030 007 001-000','152 0170 005 001-000','152 0040 033 001-000','152 0080 009 001-000','152 0150 003 001-000','152 0010 015 001-000','152 0010 013 001-000','152 0040 018 001-000','152 0090 009 001-000','152 0200 021 001-000','152 0010 016 001-000','152 0110 025 001-000','152 0090 058 001-000','152 0180 048 001-000','152 0010 011 001-000','152 0203 001 001-000','152 0020 016 001-000','152 0130 004 001-000','152 0080 009 001-000','152 0010 019 001-000','152 0040 144 001-000','152 0080 001 001-000','152 0120 008 001-000','152 0021 010 001-000','152 0090 058 001-000','152 0010 085 001-000','152 0170 005 001-000','152 0040 014 001-000','152 0080 009 001-000','152 0010 113 001-000','152 0120 008 001-000','152 0080 001 001-000','152 0150 003 001-000','152 0010 015 001-000','152 0020 162 001-000','152 0010 042 001-000','152 0040 003 001-000','152 0090 056 001-000','152 0200 232 001-000','152 0010 030 001-000','152 0090 058 001-000','152 0020 200 001-000','152 0200 005 001-000','152 0020 037 001-000','152 0080 018 001-000','152 0150 003 001-000','152 0010 015 001-000','152 0020 111 001-000','152 0010 085 001-000','152 0100 041 001-000','152 0170 005 001-000','152 0010 004 001-000','152 0040 026 001-000','152 0130 004 001-000','152 0080 009 001-000','152 0180 048 001-000','152 0010 019 001-000','152 0090 058 001-000','152 0020 125 001-000','152 0120 008 001-000')
Parameters:
[] |
|
4.85 ms (2.66%) |
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:
[
402
]
|
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. |