Query Metrics
67
Database Queries
56
Different statements
9.40 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.15 ms (12.24%) |
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:
[] |
0.42 ms (4.51%) |
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:
[] |
0.40 ms (4.21%) |
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.37 ms (3.98%) |
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.24 ms (2.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_.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.23 ms (2.43%) |
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.19 ms (2.03%) |
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.19 ms (2.00%) |
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.18 ms (1.90%) |
1 |
SELECT f0_.fiyat AS fiyat_0 FROM fiyat f0_ WHERE f0_.icerikId = 4 ORDER BY f0_.fiyat ASC
Parameters:
[] |
0.17 ms (1.84%) |
2 |
SELECT i0_.adi AS adi_0 FROM il i0_ WHERE i0_.id = 59
Parameters:
[] |
0.17 ms (1.84%) |
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.17 ms (1.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_.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 (1.84%) |
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.17 ms (1.83%) |
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.16 ms (1.75%) |
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.16 ms (1.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.16 ms (1.73%) |
1 |
SELECT f0_.fiyat AS fiyat_0 FROM fiyat f0_ WHERE f0_.icerikId = 3 ORDER BY f0_.fiyat ASC
Parameters:
[] |
0.16 ms (1.73%) |
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.16 ms (1.68%) |
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.16 ms (1.67%) |
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.16 ms (1.66%) |
1 |
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1 AND d0_.varsayilan = 1
Parameters:
[] |
0.15 ms (1.65%) |
1 |
SELECT f0_.fiyat AS fiyat_0 FROM fiyat f0_ WHERE f0_.icerikId = 2 ORDER BY f0_.fiyat ASC
Parameters:
[] |
0.15 ms (1.64%) |
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.15 ms (1.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_.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.15 ms (1.63%) |
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.15 ms (1.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.15 ms (1.56%) |
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.14 ms (1.54%) |
1 |
SELECT a0_.debug AS debug_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
0.14 ms (1.53%) |
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.14 ms (1.52%) |
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.14 ms (1.52%) |
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.14 ms (1.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_.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.14 ms (1.51%) |
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.13 ms (1.42%) |
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.13 ms (1.40%) |
1 |
SELECT a0_.title AS title_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
0.13 ms (1.39%) |
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.12 ms (1.32%) |
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.12 ms (1.31%) |
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.12 ms (1.31%) |
1 |
SELECT i0_.ilId AS ilId_0, i0_.adi AS adi_1 FROM ilce i0_ WHERE i0_.id = 726
Parameters:
[] |
0.11 ms (1.22%) |
1 |
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[] |
0.11 ms (1.17%) |
1 |
SELECT a0_.ozelHead AS ozelHead_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
0.11 ms (1.16%) |
1 |
SELECT s0_.ad AS ad_0, s0_.url AS url_1 FROM sosyal_ag s0_
Parameters:
[] |
0.10 ms (1.12%) |
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.10 ms (1.09%) |
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.09 ms (0.95%) |
1 |
SELECT a0_.keywords AS keywords_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
0.09 ms (0.94%) |
1 |
SELECT a0_.whatsapp AS whatsapp_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
0.09 ms (0.92%) |
1 |
SELECT a0_.popup AS popup_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
0.08 ms (0.89%) |
1 |
SELECT s0_.adi AS adi_0 FROM semt s0_ WHERE s0_.id = 2007
Parameters:
[] |
0.08 ms (0.88%) |
1 |
SELECT a0_.region AS region_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
0.08 ms (0.87%) |
1 |
SELECT a0_.placeName AS placeName_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
0.08 ms (0.85%) |
1 |
SELECT a0_.description AS description_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
0.08 ms (0.84%) |
1 |
SELECT a0_.siteYolu AS siteYolu_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
0.07 ms (0.79%) |
1 |
SELECT a0_.position AS position_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
0.07 ms (0.78%) |
1 |
SELECT a0_.slider AS slider_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
0.07 ms (0.77%) |
1 |
SELECT a0_.siteAdi AS siteAdi_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
0.07 ms (0.71%) |
1 |
SELECT i0_.adi AS adi_0 FROM ilce i0_ WHERE i0_.id = 726
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. |