Query Metrics
96
Database Queries
74
Different statements
49.67 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
7.74 ms (15.58%) |
1 |
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 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 = 20 AND d1_.id = 1 ORDER BY h0_.sira ASC, h0_.id DESC LIMIT 10
Parameters:
[] |
|
6.93 ms (13.95%) |
1 |
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 = 19 AND d1_.id = 1 ORDER BY h0_.sira ASC, h0_.id DESC LIMIT 10
Parameters:
[] |
|
1.69 ms (3.40%) |
1 |
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:
[] |
|
1.48 ms (2.98%) |
1 |
SELECT i0_.adres AS adres_0, i0_.telefon AS telefon_1, i0_.gsm AS gsm_2, i0_.telefon2 AS telefon2_3, i0_.telefon3 AS telefon3_4, i0_.telefon4 AS telefon4_5, i0_.telefon5 AS telefon5_6, i0_.fax AS fax_7, i0_.eposta AS eposta_8, i0_.harita AS harita_9, i0_.dilgrup AS dilgrup_10, k1_.dilgrup AS dilgrup_11, d2_.id AS id_12, s3_.dilgrup AS dilgrup_13 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:
[] |
|
1.32 ms (2.65%) |
2 |
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[] |
|
1.25 ms (2.51%) |
1 |
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:
[] |
|
1.16 ms (2.34%) |
1 |
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:
[] |
|
1.12 ms (2.25%) |
1 |
SELECT g0_.baslik AS baslik_0, g0_.resim AS resim_1, g0_.dilgrup AS dilgrup_2, k1_.dilgrup AS dilgrup_3, d2_.id AS id_4, s3_.dilgrup AS dilgrup_5 FROM gal g0_ LEFT JOIN kategori k1_ ON g0_.kategori_id = k1_.id INNER JOIN sayfa s3_ ON g0_.sayfa_id = s3_.id INNER JOIN dil d2_ ON g0_.dil_id = d2_.id WHERE s3_.id = 21 AND d2_.id = 1 ORDER BY g0_.sira ASC, g0_.id DESC LIMIT 10
Parameters:
[] |
|
1.08 ms (2.18%) |
1 |
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 = 18 AND d2_.id = 1 ORDER BY k0_.sira ASC, k0_.id DESC LIMIT 10
Parameters:
[] |
|
0.86 ms (1.73%) |
1 |
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:
[] |
|
0.85 ms (1.72%) |
3 |
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:
[] |
|
0.82 ms (1.65%) |
1 |
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:
[] |
|
0.80 ms (1.60%) |
3 |
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:
[] |
|
0.79 ms (1.58%) |
3 |
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:
[] |
|
0.75 ms (1.51%) |
3 |
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:
[] |
|
0.73 ms (1.46%) |
3 |
SELECT s0_.id AS id_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 6 GROUP BY s0_.dil_id
Parameters:
[] |
|
0.71 ms (1.44%) |
3 |
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:
[] |
|
0.70 ms (1.41%) |
3 |
SELECT s0_.id AS id_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 7 GROUP BY s0_.dil_id
Parameters:
[] |
|
0.69 ms (1.38%) |
3 |
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:
[] |
|
0.67 ms (1.35%) |
3 |
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:
[] |
|
0.62 ms (1.25%) |
1 |
SELECT s0_.ad AS ad_0, s0_.url AS url_1 FROM sosyal_ag s0_
Parameters:
[] |
|
0.56 ms (1.13%) |
2 |
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:
[] |
|
0.55 ms (1.10%) |
1 |
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ürkçe'
Parameters:
[] |
|
0.54 ms (1.08%) |
2 |
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:
[] |
|
0.48 ms (0.96%) |
2 |
SELECT s0_.id AS id_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 12 GROUP BY s0_.dil_id
Parameters:
[] |
|
0.46 ms (0.92%) |
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_.metin AS metin_5, h0_.resimler AS resimler_6, h0_.dilgrup AS dilgrup_7, k1_.dilgrup AS dilgrup_8, d2_.id AS id_9, s3_.dilgrup AS dilgrup_10 FROM hizmetler 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 = 24 AND d2_.id = 1 ORDER BY h0_.sira ASC, h0_.id DESC LIMIT 10
Parameters:
[] |
|
0.44 ms (0.89%) |
1 |
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 = 'İngilizce'
Parameters:
[] |
|
0.42 ms (0.85%) |
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_.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 = 23 AND d2_.id = 1 ORDER BY h0_.sira ASC, h0_.id DESC LIMIT 10
Parameters:
[] |
|
0.42 ms (0.85%) |
1 |
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 = 12 ORDER BY s0_.sira ASC
Parameters:
[] |
|
0.42 ms (0.84%) |
1 |
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:
[] |
|
0.41 ms (0.83%) |
1 |
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 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 = 24 AND d1_.id = 1 ORDER BY h0_.sira ASC, h0_.id DESC LIMIT 10
Parameters:
[] |
|
0.41 ms (0.82%) |
1 |
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 = 23 AND d1_.id = 1 ORDER BY h0_.sira ASC, h0_.id DESC LIMIT 10
Parameters:
[] |
|
0.41 ms (0.82%) |
1 |
SELECT i0_.telefon AS telefon_0 FROM iletisim i0_ INNER JOIN dil d1_ ON i0_.dil_id = d1_.id WHERE d1_.id = 1
Parameters:
[] |
|
0.39 ms (0.78%) |
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_.metin AS metin_5, h0_.resimler AS resimler_6, h0_.dilgrup AS dilgrup_7, k1_.dilgrup AS dilgrup_8, d2_.id AS id_9, s3_.dilgrup AS dilgrup_10 FROM hizmetler 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 = 25 AND d2_.id = 1 ORDER BY h0_.sira ASC, h0_.id DESC LIMIT 10
Parameters:
[] |
|
0.39 ms (0.78%) |
1 |
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 = 10 ORDER BY s0_.sira ASC
Parameters:
[] |
|
0.37 ms (0.74%) |
1 |
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 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 = 25 AND d1_.id = 1 ORDER BY h0_.sira ASC, h0_.id DESC LIMIT 10
Parameters:
[] |
|
0.36 ms (0.73%) |
1 |
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:
[] |
|
0.36 ms (0.73%) |
1 |
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:
[] |
|
0.35 ms (0.71%) |
1 |
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:
[] |
|
0.35 ms (0.71%) |
1 |
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_.id NOT IN (1) ORDER BY d0_.aktif DESC
Parameters:
[] |
|
0.35 ms (0.71%) |
1 |
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:
[] |
|
0.35 ms (0.70%) |
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_.metin AS metin_5, h0_.resimler AS resimler_6, h0_.dilgrup AS dilgrup_7, k1_.dilgrup AS dilgrup_8, d2_.id AS id_9, s3_.dilgrup AS dilgrup_10 FROM hizmetler 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:
[] |
|
0.33 ms (0.67%) |
1 |
SELECT g0_.baslik AS baslik_0, g0_.resim AS resim_1, g0_.dilgrup AS dilgrup_2, k1_.dilgrup AS dilgrup_3, d2_.id AS id_4, s3_.dilgrup AS dilgrup_5 FROM gal g0_ LEFT JOIN kategori k1_ ON g0_.kategori_id = k1_.id INNER JOIN sayfa s3_ ON g0_.sayfa_id = s3_.id INNER JOIN dil d2_ ON g0_.dil_id = d2_.id WHERE s3_.id = 22 AND d2_.id = 1 ORDER BY g0_.sira ASC, g0_.id DESC LIMIT 10
Parameters:
[] |
|
0.33 ms (0.66%) |
1 |
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 = 8 ORDER BY s0_.sira ASC
Parameters:
[] |
|
0.32 ms (0.64%) |
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_.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 = 19 AND d2_.id = 1 ORDER BY h0_.sira ASC, h0_.id DESC LIMIT 10
Parameters:
[] |
|
0.32 ms (0.64%) |
1 |
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 = 26 AND d2_.id = 1 ORDER BY k0_.sira ASC, k0_.id DESC LIMIT 10
Parameters:
[] |
|
0.32 ms (0.64%) |
1 |
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 = 9 ORDER BY s0_.sira ASC
Parameters:
[] |
|
0.32 ms (0.64%) |
1 |
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:
[] |
|
0.32 ms (0.64%) |
1 |
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1 AND d0_.varsayilan = 1
Parameters:
[] |
|
0.31 ms (0.62%) |
1 |
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 = 27 AND d2_.id = 1 ORDER BY k0_.sira ASC, k0_.id DESC LIMIT 10
Parameters:
[] |
|
0.30 ms (0.61%) |
1 |
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:
[] |
|
0.30 ms (0.60%) |
1 |
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:
[] |
|
0.30 ms (0.60%) |
1 |
SELECT a0_.slider AS slider_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
|
0.30 ms (0.60%) |
1 |
SELECT a0_.site_adi AS site_adi_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
|
0.29 ms (0.59%) |
1 |
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 = 7 ORDER BY s0_.sira ASC
Parameters:
[] |
|
0.28 ms (0.56%) |
1 |
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:
[] |
|
0.28 ms (0.56%) |
1 |
SELECT s0_.dilgrup AS dilgrup_0 FROM sayfa s0_ WHERE s0_.footer = 1
Parameters:
[] |
|
0.27 ms (0.54%) |
1 |
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 = 6 ORDER BY s0_.sira ASC
Parameters:
[] |
|
0.26 ms (0.53%) |
1 |
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:
[] |
|
0.25 ms (0.51%) |
1 |
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:
[] |
|
0.23 ms (0.46%) |
1 |
SELECT a0_.position AS position_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
|
0.22 ms (0.44%) |
1 |
SELECT i0_.eposta AS eposta_0 FROM iletisim i0_ INNER JOIN dil d1_ ON i0_.dil_id = d1_.id WHERE d1_.id = 1
Parameters:
[] |
|
0.22 ms (0.44%) |
1 |
SELECT a0_.place_name AS place_name_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
|
0.21 ms (0.43%) |
1 |
SELECT f0_.kurumsalaciklama AS kurumsalaciklama_0 FROM footermetin f0_ INNER JOIN dil d1_ ON f0_.dil_id = d1_.id WHERE d1_.id = 1
Parameters:
[] |
|
0.21 ms (0.42%) |
1 |
SELECT a0_.ozel_head AS ozel_head_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
|
0.20 ms (0.41%) |
1 |
SELECT i0_.adres AS adres_0 FROM iletisim i0_ INNER JOIN dil d1_ ON i0_.dil_id = d1_.id WHERE d1_.id = 1
Parameters:
[] |
|
0.20 ms (0.41%) |
1 |
SELECT a0_.whatsapp AS whatsapp_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
|
0.19 ms (0.38%) |
1 |
SELECT a0_.title AS title_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
|
0.18 ms (0.37%) |
1 |
SELECT a0_.region AS region_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
|
0.18 ms (0.37%) |
1 |
SELECT a0_.description AS description_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
|
0.18 ms (0.36%) |
1 |
SELECT a0_.keywords AS keywords_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
|
0.18 ms (0.36%) |
1 |
SELECT a0_.debug AS debug_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
|
0.17 ms (0.35%) |
1 |
SELECT a0_.site_yolu AS site_yolu_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
|
0.17 ms (0.34%) |
1 |
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\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\Haberler | No errors. |
| App\Entity\Kategori | No errors. |
| App\Entity\Hizmetler | No errors. |
| App\Entity\Kurumsal | No errors. |
| App\Entity\Gal | No errors. |
| App\Entity\Iletisim | No errors. |
| App\Entity\Footermetin | No errors. |
| App\Entity\Popup | No errors. |