Query Metrics
10
Database Queries
5
Different statements
187.16 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 5.18 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:
[
5
]
|
| 2 | 132.17 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 001-000 G091" ":YIL" => 2024 ":AY" => "TEMMUZ" ":OGUN" => "ÖĞLE" ":TURU" => "NORMAL" ] |
| 3 | 18.83 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 (19299668,19299669,19299667,19299670,19299671,19299672,19299673,19299674,19299675,19347391,19347392,19299677,19299676,19299678,19299680,19299681,19299679,19299682,19299683,19299684,19299685,19299686,19299688,19299689,19299690,19299687,19299691,19299692,19299693,19299694,19299695,19299696,19299697,19299698,19299699,19299702,19299701,19299700,19299704,19299705,19299703,19299706,19299707,19299708,19299709,19299710,19299711,19299713,19299712,19299714,19299715,19299716,19299717,19299718,19299722,19299719,19299721,19299720,19299723,19299724,19299725,19299726,19299730,19299728,19299729,19299727,19299731,19299732,19299734,19299733,19299735,19299736,19299737,19299738,19299739,19299740,19299741,19299742,19299744,19299743,19299745,19299746,19299747,19299748,19299749,19299750,19299751,19299753,19299752,19299754,19299755,19299756,19299757,19299758,19299759,19299760,19299761,19299762,19299764,19299765,19299763,19299766,19299770,19299767,19299769,19299768,19299771,19299772,19299773,19299774,19299777,19299775,19299776,19299778,19299781,19299779,19299780,19299782,19299783,19299784,19299785,19299786,19299787,19299789,19299790,19299788)
Parameters:
[] |
| 4 | 16.00 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 0020 012 001-000','152 0080 009 001-000','152 0010 015 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 0040 066 001-000','152 0020 117 001-000','152 0080 001 001-000','152 0030 007 001-000','152 0180 048 001-000','152 0060 034 001-000','152 0090 009 001-000','152 0010 085 001-000','152 0200 005 001-000','152 0010 019 001-000','152 0040 056 001-000','152 0080 009 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 028 001-000','152 0090 058 001-000','152 0200 005 001-000','152 0010 012 001-000','152 0203 001 001-000','152 0080 009 001-000','152 0020 114 001-000','152 0040 016 001-000','152 0090 009 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 0020 111 001-000','152 0040 027 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 0020 010 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 0080 018 001-000','152 0030 076 001-000','152 0170 005 001-000','152 0010 004 001-000','152 0020 046 001-000','152 0080 009 001-000','152 0230 014 001-000','152 0010 016 001-000','152 0020 107 001-000','152 0090 009 001-000','152 0180 048 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 0080 018 001-000','152 0020 115 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 0300 001 001-000','152 0090 058 001-000','152 0230 014 001-000','152 0020 106 001-000','152 0080 009 001-000','152 0010 085 001-000','152 0170 005 001-000','152 0180 051 001-000','152 0010 002 001-000','152 0020 111 001-000','152 0110 025 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 0080 045 001-000','152 0010 084 001-000','152 0041 010 001-000','152 0180 048 001-000','152 0010 016 001-000','152 0060 034 001-000','152 0090 009 001-000','152 0170 005 001-000','152 0010 004 001-000','152 0080 009 001-000','152 0150 003 001-000','152 0300 004 001-000')
Parameters:
[] |
| 5 | 9.52 ms |
update PLANLISTMUS SET RECKODU=?, RECADI=(select RECETEADI from CATRECETEDATA R where R.RECETEKODU=?), ORAN=? where KAYIT_ID=?
Parameters:
[ "152 0070 005 001-000" "152 0070 005 001-000" null 19299672 ] |
| 6 | 1.22 ms |
update PLANLISTMUS SET RECKODU=?, RECADI=(select RECETEADI from CATRECETEDATA R where R.RECETEKODU=?), ORAN=? where KAYIT_ID=?
Parameters:
[ "152 0060 033 001-000" "152 0060 033 001-000" null 19299680 ] |
| 7 | 1.02 ms |
update PLANLISTMUS SET RECKODU=?, RECADI=(select RECETEADI from CATRECETEDATA R where R.RECETEKODU=?), ORAN=? where KAYIT_ID=?
Parameters:
[ "152 0040 016 001-000" "152 0040 016 001-000" null 19299684 ] |
| 8 | 1.02 ms |
update PLANLISTMUS SET RECKODU=?, RECADI=(select RECETEADI from CATRECETEDATA R where R.RECETEKODU=?), ORAN=? where KAYIT_ID=?
Parameters:
[ "152 0110 025 001-000" "152 0110 025 001-000" null 19299704 ] |
| 9 | 1.04 ms |
update PLANLISTMUS SET RECKODU=?, RECADI=(select RECETEADI from CATRECETEDATA R where R.RECETEKODU=?), ORAN=? where KAYIT_ID=?
Parameters:
[ "152 0040 027 001-000" "152 0040 027 001-000" null 19299760 ] |
| 10 | 1.15 ms |
update PLANLISTMUS SET RECKODU=?, RECADI=(select RECETEADI from CATRECETEDATA R where R.RECETEKODU=?), ORAN=? where KAYIT_ID=?
Parameters:
[ "152 0100 041 001-000" "152 0100 041 001-000" null 19299780 ] |
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. |