https://www.oyunminderi.rvyazilim.net/tr/koleksiyon

Query Metrics

52 Database Queries
43 Different statements
12.76 ms Query time
0 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

# Time Info
1 0.35 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
2 0.29 ms
SELECT d0_.id AS id_0, d0_.kisa AS kisa_1, d0_.uzun AS uzun_2 FROM dil d0_ WHERE d0_.kisa = 'tr' AND d0_.aktif = 1 ORDER BY d0_.aktif DESC
Parameters:
[]
3 0.54 ms
SELECT s0_.id AS id_0, s0_.adi AS adi_1, s0_.banner_durum AS banner_durum_2, s0_.banner_url AS banner_url_3, s0_.title AS title_4, s0_.keywords AS keywords_5, s0_.description AS description_6, s0_.dilgrup AS dilgrup_7, s0_.seo AS seo_8, s0_.kategori AS kategori_9, s0_.tek_veri AS tek_veri_10, s0_.ic_icerik AS ic_icerik_11, m1_.tablo_adi AS tablo_adi_12, m1_.alan AS alan_13, s0_.description AS description_14, m1_.adi AS adi_15 FROM sayfa s0_ INNER JOIN dil d2_ ON s0_.dil_id = d2_.id INNER JOIN modul m1_ ON s0_.modul_id = m1_.id WHERE s0_.seo = 'koleksiyon' AND d2_.id = 1 ORDER BY s0_.sira ASC
Parameters:
[]
4 0.26 ms
SELECT s0_.id AS id_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 9 GROUP BY s0_.dil_id
Parameters:
[]
5 0.47 ms
SELECT k0_.dilgrup AS dilgrup_0, k0_.adi AS adi_1, k0_.seourl AS seourl_2, k0_.title AS title_3, k0_.keywords AS keywords_4, k0_.description AS description_5, k0_.ustid AS ustid_6, k0_.resim AS resim_7, s1_.dilgrup AS dilgrup_8 FROM kategori k0_ INNER JOIN dil d2_ ON k0_.dil_id = d2_.id INNER JOIN sayfa s1_ ON k0_.sayfa_id = s1_.id WHERE s1_.id = '20' AND k0_.ustid = 0 AND d2_.id = 1 ORDER BY k0_.sira ASC
Parameters:
[]
6 0.32 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1 AND d0_.varsayilan = 1
Parameters:
[]
7 0.32 ms
SELECT a0_.debug AS debug_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
8 0.17 ms
SELECT a0_.site_adi AS site_adi_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
9 0.14 ms
SELECT a0_.position AS position_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
10 0.13 ms
SELECT a0_.place_name AS place_name_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
11 0.15 ms
SELECT a0_.region AS region_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
12 0.15 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
13 0.14 ms
SELECT a0_.site_yolu AS site_yolu_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
14 0.14 ms
SELECT s0_.banner_durum AS banner_durum_0, s0_.banner_url AS banner_url_1 FROM sayfa s0_ WHERE s0_.dilgrup = 9
Parameters:
[]
15 0.33 ms
SELECT i0_.telefon AS telefon_0 FROM iletisim i0_ INNER JOIN dil d1_ ON i0_.dil_id = d1_.id WHERE d1_.id = 1
Parameters:
[]
16 0.15 ms
SELECT i0_.eposta AS eposta_0 FROM iletisim i0_ INNER JOIN dil d1_ ON i0_.dil_id = d1_.id WHERE d1_.id = 1
Parameters:
[]
17 0.15 ms
SELECT d0_.id AS id_0, d0_.kisa AS kisa_1, d0_.uzun AS uzun_2 FROM dil d0_ WHERE d0_.aktif = 1 ORDER BY d0_.aktif DESC
Parameters:
[]
18 0.31 ms
SELECT c0_.deger AS deger_0, c0_.id AS id_1 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE c0_.deger = 'Anasayfa'
Parameters:
[]
19 0.26 ms
SELECT s0_.id AS id_0, s0_.adi AS adi_1, s0_.dilgrup AS dilgrup_2, s0_.seo AS seo_3, s0_.kategori AS kategori_4, s0_.tek_veri AS tek_veri_5, s0_.ic_icerik AS ic_icerik_6, m1_.tablo_adi AS tablo_adi_7, m1_.alan AS alan_8 FROM sayfa s0_ INNER JOIN dil d2_ ON s0_.dil_id = d2_.id INNER JOIN modul m1_ ON s0_.modul_id = m1_.id WHERE d2_.id = 1 AND s0_.menu = 1 ORDER BY s0_.sira ASC
Parameters:
[]
20 0.18 ms
SELECT s0_.id AS id_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 8 GROUP BY s0_.dil_id
Parameters:
[]
21 0.18 ms
SELECT s0_.id AS id_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 9 GROUP BY s0_.dil_id
Parameters:
[]
22 0.24 ms
SELECT k0_.dilgrup AS dilgrup_0, k0_.adi AS adi_1, k0_.seourl AS seourl_2 FROM kategori k0_ INNER JOIN sayfa s1_ ON k0_.sayfa_id = s1_.id INNER JOIN dil d2_ ON k0_.dil_id = d2_.id WHERE s1_.id = 20 AND k0_.ustid = 0 AND d2_.id = 1 ORDER BY k0_.sira ASC LIMIT 10
Parameters:
[]
23 0.17 ms
SELECT s0_.id AS id_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 10 GROUP BY s0_.dil_id
Parameters:
[]
24 0.22 ms
SELECT s0_.id AS id_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 4 GROUP BY s0_.dil_id
Parameters:
[]
25 0.26 ms
SELECT s0_.id AS id_0, s0_.adi AS adi_1, s0_.dilgrup AS dilgrup_2, s0_.seo AS seo_3, s0_.kategori AS kategori_4, s0_.tek_veri AS tek_veri_5, s0_.ic_icerik AS ic_icerik_6, m1_.tablo_adi AS tablo_adi_7, m1_.alan AS alan_8, s0_.description AS description_9 FROM sayfa s0_ INNER JOIN dil d2_ ON s0_.dil_id = d2_.id INNER JOIN modul m1_ ON s0_.modul_id = m1_.id WHERE d2_.id = 1 AND s0_.dilgrup = 11 ORDER BY s0_.sira ASC
Parameters:
[]
26 0.18 ms
SELECT s0_.id AS id_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 11 GROUP BY s0_.dil_id
Parameters:
[]
27 0.43 ms
SELECT k0_.link AS link_0, k0_.dilgrup AS dilgrup_1, k1_.dilgrup AS dilgrup_2, d2_.id AS id_3, s3_.dilgrup AS dilgrup_4 FROM katalog k0_ LEFT JOIN kategori k1_ ON k0_.kategori_id = k1_.id INNER JOIN sayfa s3_ ON k0_.sayfa_id = s3_.id INNER JOIN dil d2_ ON k0_.dil_id = d2_.id WHERE s3_.id = 26 AND d2_.id = 1 ORDER BY k0_.sira ASC, k0_.id DESC LIMIT 10
Parameters:
[]
28 0.49 ms
SELECT c0_.deger AS deger_0, c0_.id AS id_1 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE c0_.deger = 'Anasayfa'
Parameters:
[]
29 0.31 ms
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:
[]
30 0.39 ms
SELECT c0_.deger AS deger_0, c0_.id AS id_1 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE c0_.deger = 'Telefon'
Parameters:
[]
31 0.24 ms
SELECT c0_.deger AS deger_0, c0_.id AS id_1 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE c0_.deger = 'E-Posta'
Parameters:
[]
32 0.22 ms
SELECT c0_.deger AS deger_0, c0_.id AS id_1 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE c0_.deger = 'Adres'
Parameters:
[]
33 0.18 ms
SELECT i0_.adres AS adres_0 FROM iletisim i0_ INNER JOIN dil d1_ ON i0_.dil_id = d1_.id WHERE d1_.id = 1
Parameters:
[]
34 0.27 ms
SELECT f0_.kurumsalaciklama AS kurumsalaciklama_0 FROM footermetin f0_ INNER JOIN dil d1_ ON f0_.dil_id = d1_.id WHERE d1_.id = 1
Parameters:
[]
35 0.24 ms
SELECT c0_.deger AS deger_0, c0_.id AS id_1 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE c0_.deger = 'Hızlı Menü'
Parameters:
[]
36 0.22 ms
SELECT c0_.deger AS deger_0, c0_.id AS id_1 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE c0_.deger = 'Anasayfa'
Parameters:
[]
37 0.22 ms
SELECT s0_.id AS id_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 8 GROUP BY s0_.dil_id
Parameters:
[]
38 0.19 ms
SELECT s0_.id AS id_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 9 GROUP BY s0_.dil_id
Parameters:
[]
39 0.19 ms
SELECT s0_.id AS id_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 10 GROUP BY s0_.dil_id
Parameters:
[]
40 0.20 ms
SELECT s0_.id AS id_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 4 GROUP BY s0_.dil_id
Parameters:
[]
41 0.28 ms
SELECT s0_.id AS id_0, s0_.adi AS adi_1, s0_.dilgrup AS dilgrup_2, s0_.seo AS seo_3, s0_.kategori AS kategori_4, s0_.tek_veri AS tek_veri_5, s0_.ic_icerik AS ic_icerik_6, m1_.tablo_adi AS tablo_adi_7, m1_.alan AS alan_8 FROM sayfa s0_ INNER JOIN dil d2_ ON s0_.dil_id = d2_.id INNER JOIN modul m1_ ON s0_.modul_id = m1_.id WHERE d2_.id = 1 AND s0_.menu = 1 AND s0_.dilgrup = 9 ORDER BY s0_.sira ASC
Parameters:
[]
42 0.18 ms
SELECT s0_.id AS id_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 9 GROUP BY s0_.dil_id
Parameters:
[]
43 0.22 ms
SELECT k0_.dilgrup AS dilgrup_0, k0_.adi AS adi_1, k0_.seourl AS seourl_2, k0_.resim AS resim_3 FROM kategori k0_ INNER JOIN sayfa s1_ ON k0_.sayfa_id = s1_.id INNER JOIN dil d2_ ON k0_.dil_id = d2_.id WHERE s1_.id = 20 AND k0_.ustid = 0 AND d2_.id = 1 ORDER BY k0_.sira ASC LIMIT 99
Parameters:
[]
44 0.23 ms
SELECT c0_.deger AS deger_0, c0_.id AS id_1 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE c0_.deger = 'Takip Edin'
Parameters:
[]
45 0.22 ms
SELECT s0_.ad AS ad_0, s0_.url AS url_1 FROM sosyal_ag s0_
Parameters:
[]
46 0.25 ms
SELECT c0_.deger AS deger_0, c0_.id AS id_1 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE c0_.deger = 'Tüm hakları saklıdır.'
Parameters:
[]
47 0.40 ms
SELECT p0_.veri AS veri_0, p0_.link AS link_1, p0_.tip AS tip_2, p0_.dilgrup AS dilgrup_3 FROM popup p0_ INNER JOIN dil d1_ ON p0_.dil_id = d1_.id WHERE p0_.sayfa_id = 0 AND d1_.id = 1
Parameters:
[]
48 0.26 ms
SELECT c0_.deger AS deger_0, c0_.id AS id_1 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE c0_.deger = 'Lütfen zorunlu alanları doldurunuz.'
Parameters:
[]
49 0.23 ms
SELECT c0_.deger AS deger_0, c0_.id AS id_1 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE c0_.deger = 'Mail adresiniz geçersiz veya boş bırakılmış.'
Parameters:
[]
50 0.17 ms
SELECT a0_.ozel_head AS ozel_head_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
51 0.14 ms
SELECT a0_.whatsapp AS whatsapp_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
52 0.16 ms
SELECT i0_.gsm AS gsm_0 FROM iletisim i0_ INNER JOIN dil d1_ ON i0_.dil_id = d1_.id WHERE d1_.id = 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\Dil No errors.
App\Entity\Sayfa No errors.
App\Entity\Modul No errors.
App\Entity\Kategori No errors.
App\Entity\Ayarlar No errors.
App\Entity\Iletisim No errors.
App\Entity\Ceviri No errors.
App\Entity\Katalog No errors.
App\Entity\Footermetin No errors.
App\Entity\SosyalAg No errors.
App\Entity\Popup No errors.