https://www.sozgurme.rvyazilim.net/

Query Metrics

56 Database Queries
47 Different statements
54.58 ms Query time
0 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

# Time Info
1 0.79 ms
SELECT d0_.id AS id_0, d0_.kisa AS kisa_1, d0_.uzun AS uzun_2 FROM dil d0_ WHERE d0_.aktif = 1 AND d0_.varsayilan = 1 ORDER BY d0_.id ASC
Parameters:
[]
2 0.29 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1 AND d0_.varsayilan = 1
Parameters:
[]
3 0.80 ms
SELECT a0_.slider AS slider_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
4 10.14 ms
SELECT s0_.resim AS resim_0, s0_.aciklama AS aciklama_1, s0_.baslik AS baslik_2 FROM slider s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE d1_.id = 1 ORDER BY s0_.sira ASC
Parameters:
[]
5 0.29 ms
SELECT a0_.debug AS debug_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
6 1.92 ms
SELECT s0_.ad AS ad_0, s0_.url AS url_1 FROM sosyal_ag s0_
Parameters:
[]
7 6.40 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:
[]
8 0.24 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
9 0.17 ms
SELECT a0_.site_yolu AS site_yolu_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
10 2.58 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:
[]
11 0.42 ms
SELECT s0_.id AS id_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 3 GROUP BY s0_.dil_id
Parameters:
[]
12 4.97 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 = 19 AND k0_.ustid = 0 AND d2_.id = 1 ORDER BY k0_.sira ASC LIMIT 10
Parameters:
[]
13 0.21 ms
SELECT s0_.id AS id_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 5 GROUP BY s0_.dil_id
Parameters:
[]
14 0.21 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:
[]
15 3.99 ms
SELECT h0_.adi AS adi_0, h0_.seourl AS seourl_1, h0_.dilgrup AS dilgrup_2, d1_.kisa AS kisa_3, k2_.dilgrup AS dilgrup_4, d1_.id AS id_5, s3_.dilgrup AS dilgrup_6 FROM haberler 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 = 20 AND d1_.id = 1 ORDER BY h0_.sira ASC, h0_.id DESC LIMIT 10
Parameters:
[]
16 0.28 ms
SELECT s0_.id AS id_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 1 GROUP BY s0_.dil_id
Parameters:
[]
17 0.21 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 ORDER BY s0_.sira ASC
Parameters:
[]
18 0.15 ms
SELECT s0_.id AS id_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 3 GROUP BY s0_.dil_id
Parameters:
[]
19 0.29 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 = 3 ORDER BY s0_.sira ASC
Parameters:
[]
20 0.24 ms
SELECT s0_.id AS id_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 3 GROUP BY s0_.dil_id
Parameters:
[]
21 0.26 ms
SELECT k0_.adi AS adi_0, k0_.ustid AS ustid_1, k0_.resim AS resim_2, k0_.dilgrup AS dilgrup_3, k0_.seourl AS seourl_4 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id INNER JOIN sayfa s2_ ON k0_.sayfa_id = s2_.id WHERE s2_.id = 19 AND d1_.id = 1 ORDER BY k0_.sira ASC, k0_.id DESC LIMIT 10
Parameters:
[]
22 0.24 ms
SELECT s0_.id AS id_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 5 GROUP BY s0_.dil_id
Parameters:
[]
23 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, 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 = 5 ORDER BY s0_.sira ASC
Parameters:
[]
24 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 = 5 GROUP BY s0_.dil_id
Parameters:
[]
25 3.18 ms
SELECT k0_.baslik AS baslik_0, k0_.metin AS metin_1, k0_.resim AS resim_2, k0_.dilgrup AS dilgrup_3, k1_.dilgrup AS dilgrup_4, d2_.id AS id_5, s3_.dilgrup AS dilgrup_6 FROM kurumsal 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 = 21 AND d2_.id = 1 ORDER BY k0_.sira ASC, k0_.id DESC LIMIT 10
Parameters:
[]
26 0.40 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:
[]
27 0.25 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 = 4 ORDER BY s0_.sira ASC
Parameters:
[]
28 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 = 4 GROUP BY s0_.dil_id
Parameters:
[]
29 0.27 ms
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_.metin AS metin_5, h0_.tarih AS tarih_6, h0_.resimler AS resimler_7, h0_.dilgrup AS dilgrup_8, k1_.dilgrup AS dilgrup_9, d2_.id AS id_10, s3_.dilgrup AS dilgrup_11 FROM haberler h0_ LEFT JOIN kategori k1_ ON h0_.kategori_id = k1_.id INNER JOIN sayfa s3_ ON h0_.sayfa_id = s3_.id INNER JOIN dil d2_ ON h0_.dil_id = d2_.id WHERE s3_.id = 20 AND d2_.id = 1 ORDER BY h0_.sira ASC, h0_.id DESC LIMIT 10
Parameters:
[]
30 0.21 ms
SELECT s0_.id AS id_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 1 GROUP BY s0_.dil_id
Parameters:
[]
31 0.25 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 = 1 ORDER BY s0_.sira ASC
Parameters:
[]
32 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 = 1 GROUP BY s0_.dil_id
Parameters:
[]
33 3.60 ms
SELECT i0_.adres AS adres_0, i0_.telefon AS telefon_1, i0_.gsm AS gsm_2, i0_.fax AS fax_3, i0_.eposta AS eposta_4, i0_.harita AS harita_5, i0_.dilgrup AS dilgrup_6, k1_.dilgrup AS dilgrup_7, d2_.id AS id_8, s3_.dilgrup AS dilgrup_9 FROM iletisim i0_ LEFT JOIN kategori k1_ ON i0_.kategori_id = k1_.id INNER JOIN sayfa s3_ ON i0_.sayfa_id = s3_.id INNER JOIN dil d2_ ON i0_.dil_id = d2_.id WHERE s3_.id = 8 AND d2_.id = 1 ORDER BY i0_.sira ASC, i0_.id DESC LIMIT 10
Parameters:
[]
34 0.15 ms
SELECT s0_.id AS id_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 2 GROUP BY s0_.dil_id
Parameters:
[]
35 0.25 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 = 2 ORDER BY s0_.sira ASC
Parameters:
[]
36 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 = 2 GROUP BY s0_.dil_id
Parameters:
[]
37 3.63 ms
SELECT f0_.kurumsalaciklama AS kurumsalaciklama_0, f0_.dilgrup AS dilgrup_1, k1_.dilgrup AS dilgrup_2, d2_.id AS id_3, s3_.dilgrup AS dilgrup_4 FROM footermetin f0_ LEFT JOIN kategori k1_ ON f0_.kategori_id = k1_.id INNER JOIN sayfa s3_ ON f0_.sayfa_id = s3_.id INNER JOIN dil d2_ ON f0_.dil_id = d2_.id WHERE s3_.id = 11 AND d2_.id = 1 ORDER BY f0_.sira ASC, f0_.id DESC LIMIT 10
Parameters:
[]
38 0.17 ms
SELECT s0_.dilgrup AS dilgrup_0 FROM sayfa s0_ WHERE s0_.footer = 1
Parameters:
[]
39 0.16 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:
[]
40 0.20 ms
SELECT a0_.site_adi AS site_adi_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
41 0.16 ms
SELECT a0_.title AS title_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
42 0.14 ms
SELECT a0_.keywords AS keywords_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
43 0.16 ms
SELECT a0_.description AS description_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
44 0.15 ms
SELECT a0_.position AS position_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
45 0.20 ms
SELECT a0_.place_name AS place_name_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
46 0.14 ms
SELECT a0_.region AS region_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
47 0.20 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:
[]
48 0.18 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:
[]
49 0.16 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:
[]
50 3.25 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:
[]
51 0.17 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:
[]
52 0.14 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:
[]
53 0.21 ms
SELECT a0_.ozel_head AS ozel_head_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
54 0.17 ms
SELECT a0_.whatsapp AS whatsapp_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
55 0.19 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:
[]
56 0.19 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 = 'Merhaba, bilgi almak istiyorum.'
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\Ayarlar No errors.
App\Entity\Slider No errors.
App\Entity\SosyalAg No errors.
App\Entity\Sayfa No errors.
App\Entity\Modul No errors.
App\Entity\Ceviri No errors.
App\Entity\Kategori No errors.
App\Entity\Haberler No errors.
App\Entity\Kurumsal No errors.
App\Entity\Iletisim No errors.
App\Entity\Footermetin No errors.
App\Entity\Popup No errors.