https://koycegizdetatil.com/

Query Metrics

67 Database Queries
56 Different statements
18.27 ms Query time
0 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Grouped Statements

Show all queries

Time Count Info
2.12 ms
(11.61%)
1
SELECT k0_.baslik AS baslik_0, k0_.metin AS metin_1, k0_.resim AS resim_2, k0_.dilgrup AS dilgrup_3, k0_.kategoriId AS kategoriId_4, d1_.id AS id_5, k0_.sayfaId AS sayfaId_6 FROM kurumsal k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.sayfaId = 14 AND d1_.id = 1 ORDER BY k0_.sira ASC, k0_.id DESC LIMIT 10
Parameters:
[]
1.27 ms
(6.97%)
9
SELECT v0_.id AS id_0, v0_.dilgrup AS dilgrup_1, v0_.adi AS adi_2, v0_.seourl AS seourl_3, v0_.ustid AS ustid_4 FROM villa_kategori v0_ INNER JOIN dil d1_ ON v0_.dil_id = d1_.id WHERE v0_.dilgrup = 0 AND d1_.id = 1 GROUP BY v0_.dilgrup ORDER BY v0_.sira ASC
Parameters:
[]
1.12 ms
(6.10%)
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_.tabloAdi AS tabloAdi_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.74 ms
(4.02%)
1
SELECT k0_.baslik AS baslik_0, k0_.metin AS metin_1, k0_.resim AS resim_2, k0_.dilgrup AS dilgrup_3, k0_.kategoriId AS kategoriId_4, d1_.id AS id_5, k0_.sayfaId AS sayfaId_6 FROM kurumsal k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.sayfaId = 12 AND d1_.id = 1 ORDER BY k0_.sira ASC, k0_.id DESC LIMIT 10
Parameters:
[]
0.65 ms
(3.56%)
1
SELECT f0_.fiyat AS fiyat_0 FROM fiyat f0_ WHERE f0_.icerikId = 4 ORDER BY f0_.fiyat ASC
Parameters:
[]
0.64 ms
(3.49%)
1
SELECT v0_.adi AS adi_0, v0_.ustid AS ustid_1, v0_.resim AS resim_2, v0_.dilgrup AS dilgrup_3, v0_.seourl AS seourl_4 FROM villa_kategori v0_ INNER JOIN dil d1_ ON v0_.dil_id = d1_.id WHERE v0_.ustid = 0 AND d1_.id = 1 ORDER BY v0_.sira ASC, v0_.id DESC
Parameters:
[]
0.59 ms
(3.21%)
1
SELECT v0_.adi AS adi_0, v0_.resimler AS resimler_1, v0_.kisi AS kisi_2, v0_.yatak AS yatak_3, v0_.banyo AS banyo_4, v0_.semt AS semt_5, v0_.ilce AS ilce_6, v0_.il AS il_7, v0_.kategoriId AS kategoriId_8, v0_.seo AS seo_9, v0_.dilgrup AS dilgrup_10 FROM villa v0_ INNER JOIN dil d1_ ON v0_.dil_id = d1_.id WHERE d1_.id = 1 AND v0_.durum = 1 ORDER BY v0_.id DESC LIMIT 12
Parameters:
[]
0.52 ms
(2.85%)
1
SELECT a0_.debug AS debug_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
0.52 ms
(2.82%)
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.51 ms
(2.78%)
1
SELECT k0_.baslik AS baslik_0, k0_.seourl AS seourl_1, k0_.dilgrup AS dilgrup_2, d1_.kisa AS kisa_3, k0_.kategoriId AS kategoriId_4, d1_.id AS id_5, k0_.sayfaId AS sayfaId_6 FROM kurumsal2 k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.sayfaId = 10 AND d1_.id = 1 ORDER BY k0_.sira ASC, k0_.id DESC LIMIT 10
Parameters:
[]
0.51 ms
(2.78%)
1
SELECT s0_.id AS id_0, s0_.adi AS adi_1, s0_.IlceId AS IlceId_2 FROM semt s0_ WHERE s0_.id IN (2007)
Parameters:
[]
0.49 ms
(2.69%)
3
SELECT v0_.id AS id_0, v0_.dilgrup AS dilgrup_1, v0_.adi AS adi_2, v0_.seourl AS seourl_3, v0_.ustid AS ustid_4 FROM villa_kategori v0_ INNER JOIN dil d1_ ON v0_.dil_id = d1_.id WHERE v0_.dilgrup = 1 AND d1_.id = 1 GROUP BY v0_.dilgrup ORDER BY v0_.sira ASC
Parameters:
[]
0.48 ms
(2.63%)
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.47 ms
(2.58%)
1
SELECT i0_.ilId AS ilId_0, i0_.adi AS adi_1 FROM ilce i0_ WHERE i0_.id = 726
Parameters:
[]
0.43 ms
(2.37%)
1
SELECT b0_.aciklama AS aciklama_0, b0_.dilgrup AS dilgrup_1, b0_.kategoriId AS kategoriId_2, d1_.id AS id_3, b0_.sayfaId AS sayfaId_4 FROM bossayfa b0_ INNER JOIN dil d1_ ON b0_.dil_id = d1_.id WHERE b0_.sayfaId = 16 AND d1_.id = 1 ORDER BY b0_.sira ASC, b0_.id DESC LIMIT 10
Parameters:
[]
0.43 ms
(2.35%)
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.35 ms
(1.91%)
1
SELECT s0_.ad AS ad_0, s0_.url AS url_1 FROM sosyal_ag s0_
Parameters:
[]
0.35 ms
(1.90%)
1
SELECT a0_.title AS title_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
0.34 ms
(1.84%)
2
SELECT i0_.adi AS adi_0 FROM il i0_ WHERE i0_.id = 59
Parameters:
[]
0.29 ms
(1.60%)
1
SELECT s0_.soru AS soru_0, s0_.cevap AS cevap_1, s0_.dilgrup AS dilgrup_2, s0_.kategoriId AS kategoriId_3, d1_.id AS id_4, s0_.sayfaId AS sayfaId_5 FROM sikcasorulansorular s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.sayfaId = 15 AND d1_.id = 1 ORDER BY s0_.sira ASC, s0_.id DESC LIMIT 10
Parameters:
[]
0.27 ms
(1.46%)
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.24 ms
(1.29%)
1
SELECT d0_.id AS id_0, d0_.kisa AS kisa_1, d0_.uzun AS uzun_2 FROM dil d0_ WHERE d0_.varsayilan = 1 AND d0_.aktif = 1 ORDER BY d0_.aktif DESC
Parameters:
[]
0.21 ms
(1.16%)
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_.tabloAdi AS tabloAdi_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 = 15 ORDER BY s0_.sira ASC
Parameters:
[]
0.20 ms
(1.12%)
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üm hakları saklıdır.'
Parameters:
[]
0.20 ms
(1.09%)
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.20 ms
(1.07%)
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_.tabloAdi AS tabloAdi_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 = 16 ORDER BY s0_.sira ASC
Parameters:
[]
0.19 ms
(1.06%)
1
SELECT v0_.semt AS semt_0 FROM villa v0_ INNER JOIN dil d1_ ON v0_.dil_id = d1_.id WHERE d1_.id = 1 ORDER BY v0_.id DESC
Parameters:
[]
0.19 ms
(1.03%)
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_.tabloAdi AS tabloAdi_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 = 13 ORDER BY s0_.sira ASC
Parameters:
[]
0.17 ms
(0.96%)
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_.tabloAdi AS tabloAdi_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 = 18 ORDER BY s0_.sira ASC
Parameters:
[]
0.17 ms
(0.95%)
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.17 ms
(0.94%)
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, nasıl yardımcı olabilirim?'
Parameters:
[]
0.17 ms
(0.93%)
1
SELECT b0_.aciklama AS aciklama_0, b0_.dilgrup AS dilgrup_1, b0_.kategoriId AS kategoriId_2, d1_.id AS id_3, b0_.sayfaId AS sayfaId_4 FROM bossayfa b0_ INNER JOIN dil d1_ ON b0_.dil_id = d1_.id WHERE b0_.sayfaId = 18 AND d1_.id = 1 ORDER BY b0_.sira ASC, b0_.id DESC LIMIT 10
Parameters:
[]
0.17 ms
(0.92%)
1
SELECT a0_.region AS region_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
0.17 ms
(0.91%)
1
SELECT f0_.fiyat AS fiyat_0 FROM fiyat f0_ WHERE f0_.icerikId = 3 ORDER BY f0_.fiyat ASC
Parameters:
[]
0.16 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_.tabloAdi AS tabloAdi_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:
[]
0.15 ms
(0.82%)
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.14 ms
(0.79%)
1
SELECT a0_.siteYolu AS siteYolu_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
0.14 ms
(0.79%)
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_.tabloAdi AS tabloAdi_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 = 14 ORDER BY s0_.sira ASC
Parameters:
[]
0.14 ms
(0.78%)
1
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1 AND d0_.varsayilan = 1
Parameters:
[]
0.14 ms
(0.78%)
1
SELECT k0_.baslik AS baslik_0, k0_.metin AS metin_1, k0_.resim AS resim_2, k0_.dilgrup AS dilgrup_3, k0_.kategoriId AS kategoriId_4, d1_.id AS id_5, k0_.sayfaId AS sayfaId_6 FROM kurumsal k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.sayfaId = 13 AND d1_.id = 1 ORDER BY k0_.sira ASC, k0_.id DESC LIMIT 10
Parameters:
[]
0.14 ms
(0.76%)
1
SELECT a0_.keywords AS keywords_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
0.14 ms
(0.76%)
1
SELECT a0_.whatsapp AS whatsapp_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
0.14 ms
(0.75%)
1
SELECT f0_.fiyat AS fiyat_0 FROM fiyat f0_ WHERE f0_.icerikId = 2 ORDER BY f0_.fiyat ASC
Parameters:
[]
0.14 ms
(0.74%)
1
SELECT v0_.adi AS adi_0, v0_.ustid AS ustid_1, v0_.resim AS resim_2, v0_.dilgrup AS dilgrup_3, v0_.seourl AS seourl_4 FROM villa_kategori v0_ INNER JOIN dil d1_ ON v0_.dil_id = d1_.id WHERE v0_.ustid = 1 AND d1_.id = 1 ORDER BY v0_.sira ASC, v0_.id DESC
Parameters:
[]
0.13 ms
(0.71%)
1
SELECT a0_.ozelHead AS ozelHead_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
0.12 ms
(0.68%)
1
SELECT a0_.slider AS slider_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
0.12 ms
(0.65%)
1
SELECT a0_.siteAdi AS siteAdi_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
0.12 ms
(0.65%)
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.11 ms
(0.62%)
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:
[]
0.11 ms
(0.61%)
1
SELECT a0_.placeName AS placeName_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
0.11 ms
(0.61%)
1
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
0.11 ms
(0.61%)
1
SELECT a0_.position AS position_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
0.11 ms
(0.60%)
1
SELECT a0_.popup AS popup_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
0.10 ms
(0.54%)
1
SELECT a0_.description AS description_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
0.09 ms
(0.49%)
1
SELECT i0_.adi AS adi_0 FROM ilce i0_ WHERE i0_.id = 726
Parameters:
[]
0.09 ms
(0.48%)
1
SELECT s0_.adi AS adi_0 FROM semt s0_ WHERE s0_.id = 2007
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
PanelBundle\Entity\Dil No errors.
PanelBundle\Entity\Ayarlar No errors.
PanelBundle\Entity\Sayfa No errors.
PanelBundle\Entity\Modul No errors.
PanelBundle\Entity\Kurumsal No errors.
PanelBundle\Entity\Sikcasorulansorular No errors.
PanelBundle\Entity\Iletisim No errors.
PanelBundle\Entity\VillaKategori No errors.
PanelBundle\Entity\Ceviri No errors.
PanelBundle\Entity\Kurumsal2 No errors.
PanelBundle\Entity\Bossayfa No errors.
PanelBundle\Entity\Slider No errors.
PanelBundle\Entity\Villa No errors.
PanelBundle\Entity\Semt No errors.
PanelBundle\Entity\Ilce No errors.
PanelBundle\Entity\Il No errors.
PanelBundle\Entity\Fiyat No errors.
PanelBundle\Entity\SosyalAg No errors.
PanelBundle\Entity\Footermetin No errors.