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
#▲ | 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. |