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

Grouped Statements

Show all queries

Time Count Info
1.11 ms
(24.72%)
1
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:
[]
0.94 ms
(20.83%)
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.70 ms
(15.59%)
1
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:
[]
0.69 ms
(15.37%)
1
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:
[]
0.64 ms
(14.21%)
1
SELECT a0_.hataPage AS hataPage_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
0.31 ms
(6.79%)
2
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1 AND d0_.varsayilan = 1
Parameters:
[]
0.11 ms
(2.49%)
1
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.