https://www.ozstar.rvyazilim.net/admin/multi-content/26/getir Return to referer URL

Query Metrics

83 Database Queries
13 Different statements
23.83 ms Query time
0 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Grouped Statements

Show all queries

Time Count Info
6.63 ms
(27.80%)
31
SELECT k0_.id AS id_0, k0_.dilgrup AS dilgrup_1, k0_.adi AS adi_2, k0_.seourl AS seourl_3, k0_.ustid AS ustid_4 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.dilgrup = 0 AND d1_.id = 1 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[]
4.64 ms
(19.49%)
1
SELECT h0_.seourl AS seourl_0, h0_.sayfabasligi AS sayfabasligi_1, h0_.anahtarkelimeler AS anahtarkelimeler_2, h0_.sayfaaciklamasi AS sayfaaciklamasi_3, h0_.adi AS adi_4, h0_.model AS model_5, h0_.aciklama AS aciklama_6, h0_.metin AS metin_7, h0_.resimler AS resimler_8, h0_.boyutlaruzunluk AS boyutlaruzunluk_9, h0_.boyutlargenislik AS boyutlargenislik_10, h0_.boyutlaryukseklik AS boyutlaryukseklik_11, h0_.elektrikbilesenleri AS elektrikbilesenleri_12, h0_.enerjiozellikleriyakittipimotorinminimum AS enerjiozellikleriyakittipimotorinminimum_13, h0_.enerjiozellikleriyakittipimotorinmaximum AS enerjiozellikleriyakittipimotorinmaximum_14, h0_.enerjiozellikleriyakittipimotorinortalama AS enerjiozellikleriyakittipimotorinortalama_15, h0_.enerjiozellikleriyakittipielektrikrezistans AS enerjiozellikleriyakittipielektrikrezistans_16, h0_.enerjiozellikleriyakittipilpgminimum AS enerjiozellikleriyakittipilpgminimum_17, h0_.enerjiozellikleriyakittipilpgmaximum AS enerjiozellikleriyakittipilpgmaximum_18, h0_.enerjiozellikleriyakittipilpgortalama AS enerjiozellikleriyakittipilpgortalama_19, h0_.enerjiozellikleriyakittipidogalgazminimum AS enerjiozellikleriyakittipidogalgazminimum_20, h0_.enerjiozellikleriyakittipidogalgazmaximum AS enerjiozellikleriyakittipidogalgazmaximum_21, h0_.enerjiozellikleriyakittipidogalgazortalama AS enerjiozellikleriyakittipidogalgazortalama_22, h0_.urunvideo AS urunvideo_23, h0_.dilgrup AS dilgrup_24, d1_.kisa AS kisa_25, k2_.adi AS adi_26, k2_.dilgrup AS dilgrup_27 FROM hizmetler h0_ LEFT JOIN kategori k2_ ON h0_.kategori_id = k2_.id INNER JOIN sayfa s3_ ON h0_.sayfa_id = s3_.id INNER JOIN dil d1_ ON h0_.dil_id = d1_.id WHERE s3_.id = 26 GROUP BY h0_.dilgrup ORDER BY h0_.sira ASC
Parameters:
[]
3.43 ms
(14.41%)
15
SELECT k0_.id AS id_0, k0_.dilgrup AS dilgrup_1, k0_.adi AS adi_2, k0_.seourl AS seourl_3, k0_.ustid AS ustid_4 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.dilgrup = 1 AND d1_.id = 1 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[]
2.96 ms
(12.42%)
13
SELECT k0_.id AS id_0, k0_.dilgrup AS dilgrup_1, k0_.adi AS adi_2, k0_.seourl AS seourl_3, k0_.ustid AS ustid_4 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.dilgrup = 7 AND d1_.id = 1 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[]
1.64 ms
(6.87%)
7
SELECT k0_.id AS id_0, k0_.dilgrup AS dilgrup_1, k0_.adi AS adi_2, k0_.seourl AS seourl_3, k0_.ustid AS ustid_4 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.dilgrup = 2 AND d1_.id = 1 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[]
1.58 ms
(6.63%)
6
SELECT k0_.id AS id_0, k0_.dilgrup AS dilgrup_1, k0_.adi AS adi_2, k0_.seourl AS seourl_3, k0_.ustid AS ustid_4 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.dilgrup = 9 AND d1_.id = 1 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[]
0.75 ms
(3.16%)
3
SELECT k0_.id AS id_0, k0_.dilgrup AS dilgrup_1, k0_.adi AS adi_2, k0_.seourl AS seourl_3, k0_.ustid AS ustid_4 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.dilgrup = 10 AND d1_.id = 1 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[]
0.72 ms
(3.03%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.is_verified AS is_verified_6, t0.adsoyad AS adsoyad_7, t0.unvan AS unvan_8, t0.password_token AS password_token_9, t0.yetkiler AS yetkiler_10, t0.is_password AS is_password_11 FROM user t0 WHERE t0.id = ?
Parameters:
[
  4
]
0.51 ms
(2.15%)
2
SELECT k0_.id AS id_0, k0_.dilgrup AS dilgrup_1, k0_.adi AS adi_2, k0_.seourl AS seourl_3, k0_.ustid AS ustid_4 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.dilgrup = 3 AND d1_.id = 1 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[]
0.42 ms
(1.78%)
1
SELECT s0_.id AS id_0, m1_.alan AS alan_1, m1_.tip AS tip_2, m1_.tablo_adi AS tablo_adi_3, s0_.dilgrup AS dilgrup_4, s0_.kategori AS kategori_5, s0_.seo AS seo_6, s0_.ic_icerik AS ic_icerik_7 FROM sayfa s0_ INNER JOIN modul m1_ ON s0_.modul_id = m1_.id WHERE s0_.id = 26
Parameters:
[]
0.20 ms
(0.85%)
1
SELECT a0_.site_yolu AS site_yolu_0 FROM ayarlar a0_ WHERE a0_.dil_id = 17
Parameters:
[]
0.18 ms
(0.77%)
1
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
0.15 ms
(0.63%)
1
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1 AND d0_.varsayilan = 1
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

0 Hits
0 Misses
0 Puts

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Sayfa No errors.
App\Entity\Modul No errors.
App\Entity\Hizmetler No errors.
App\Entity\Kategori No errors.
App\Entity\Dil No errors.
App\Entity\Ayarlar No errors.