https://koycegizdetatil.com/%5C%22%22.$sql_surl.%22sql_tbl=%22.urlencode%28$row%5B%22Name%22%5D%29.%22%5C%22

Query Metrics

8 Database Queries
7 Different statements
4.50 ms Query time
0 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

# Time Info
1 0.94 ms
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:
[]
2 1.11 ms
SELECT s0_.id AS id_0, s0_.adi AS adi_1, s0_.bannerDurum AS bannerDurum_2, s0_.bannerUrl AS bannerUrl_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_.tabloAdi AS tabloAdi_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 = '\\\"\".$sql_surl.\"sql_tbl=\".urlencode($row[\"Name\"]).\"\\\"' AND d2_.id = 1 ORDER BY s0_.sira ASC
Parameters:
[]
3 0.70 ms
SELECT v0_.dilgrup AS dilgrup_0, v0_.adi AS adi_1, v0_.seourl AS seourl_2, v0_.sayfabasligi AS sayfabasligi_3, v0_.anahtarkelimeler AS anahtarkelimeler_4, v0_.sayfaaciklamasi AS sayfaaciklamasi_5, v0_.ustid AS ustid_6, v0_.resim AS resim_7 FROM villa_kategori v0_ INNER JOIN dil d1_ ON v0_.dil_id = d1_.id WHERE v0_.seourl = '\\\"\".$sql_surl.\"sql_tbl=\".urlencode($row[\"Name\"]).\"\\\"' AND v0_.ustid = 0 AND d1_.id = 1 ORDER BY v0_.sira ASC
Parameters:
[]
4 0.69 ms
SELECT v0_.id AS id_0, v0_.adi AS adi_1, v0_.title AS title_2, v0_.seo AS seo_3, v0_.keywords AS keywords_4, v0_.description AS description_5, v0_.metin AS metin_6, v0_.girisTarihi AS girisTarihi_7, v0_.cikisTarihi AS cikisTarihi_8, v0_.depozito AS depozito_9, v0_.temizlik AS temizlik_10, v0_.havuzbahceBakim AS havuzbahceBakim_11, v0_.konum AS konum_12, v0_.kisi AS kisi_13, v0_.yatak AS yatak_14, v0_.banyo AS banyo_15, v0_.dilgrup AS dilgrup_16, v0_.kategoriId AS kategoriId_17, v0_.resimler AS resimler_18, v0_.durum AS durum_19, v0_.ozellikler AS ozellikler_20, v0_.yasaklar AS yasaklar_21, v0_.il AS il_22, v0_.ilce AS ilce_23, v0_.semt AS semt_24 FROM villa v0_ INNER JOIN dil d1_ ON v0_.dil_id = d1_.id WHERE v0_.seo = '\\\"\".$sql_surl.\"sql_tbl=\".urlencode($row[\"Name\"]).\"\\\"' AND d1_.id = 1 ORDER BY v0_.id DESC
Parameters:
[]
5 0.17 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1 AND d0_.varsayilan = 1
Parameters:
[]
6 0.64 ms
SELECT a0_.hataPage AS hataPage_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
7 0.13 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1 AND d0_.varsayilan = 1
Parameters:
[]
8 0.11 ms
SELECT a0_.siteYolu AS siteYolu_0 FROM ayarlar a0_ WHERE a0_.dil_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
PanelBundle\Entity\Dil No errors.
PanelBundle\Entity\Sayfa No errors.
PanelBundle\Entity\Modul No errors.
PanelBundle\Entity\VillaKategori No errors.
PanelBundle\Entity\Villa No errors.
PanelBundle\Entity\Ayarlar No errors.
PanelBundle\Entity\Ceviri No errors.
PanelBundle\Entity\Kategori No errors.
PanelBundle\Entity\Yasak No errors.
PanelBundle\Entity\Ozellik No errors.
PanelBundle\Entity\Slider No errors.
PanelBundle\Entity\Kurumsal No errors.
PanelBundle\Entity\Iletisim No errors.
PanelBundle\Entity\Hizmetler No errors.
PanelBundle\Entity\Referanslar No errors.
PanelBundle\Entity\Ekip No errors.
PanelBundle\Entity\Haberler No errors.
PanelBundle\Entity\Footermetin No errors.
PanelBundle\Entity\Kurumsal2 No errors.
PanelBundle\Entity\Sikcasorulansorular No errors.
PanelBundle\Entity\Bossayfa No errors.
PanelBundle\Entity\Bankalar No errors.