Symfony Profiler

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

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;

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 = 'kiralama-sozlesmesi' 
  AND d2_.id = 1 
ORDER BY 
  s0_.sira ASC

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 = 'kiralama-sozlesmesi' AND d2_.id = 1 ORDER BY s0_.sira ASC;

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 = 'kiralama-sozlesmesi' 
  AND v0_.ustid = 0 
  AND d1_.id = 1 
ORDER BY 
  v0_.sira ASC

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 = 'kiralama-sozlesmesi' AND v0_.ustid = 0 AND d1_.id = 1 ORDER BY v0_.sira ASC;

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 = 'kiralama-sozlesmesi' 
  AND d1_.id = 1 
ORDER BY 
  v0_.id DESC

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 = 'kiralama-sozlesmesi' AND d1_.id = 1 ORDER BY v0_.id DESC;

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

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;

SELECT 
  d0_.id AS id_0 
FROM 
  dil d0_ 
WHERE 
  d0_.aktif = 1 
  AND d0_.varsayilan = 1

SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1 AND d0_.varsayilan = 1;

SELECT 
  a0_.debug AS debug_0 
FROM 
  ayarlar a0_ 
WHERE 
  a0_.dil_id = 1

SELECT a0_.debug AS debug_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1;

SELECT 
  a0_.title AS title_0 
FROM 
  ayarlar a0_ 
WHERE 
  a0_.dil_id = 1

SELECT a0_.title AS title_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1;

SELECT 
  a0_.position AS position_0 
FROM 
  ayarlar a0_ 
WHERE 
  a0_.dil_id = 1

SELECT a0_.position AS position_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1;

SELECT 
  a0_.placeName AS placeName_0 
FROM 
  ayarlar a0_ 
WHERE 
  a0_.dil_id = 1

SELECT a0_.placeName AS placeName_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1;

SELECT 
  a0_.region AS region_0 
FROM 
  ayarlar a0_ 
WHERE 
  a0_.dil_id = 1

SELECT a0_.region AS region_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1;

SELECT 
  a0_.siteAdi AS siteAdi_0 
FROM 
  ayarlar a0_ 
WHERE 
  a0_.dil_id = 1

SELECT a0_.siteAdi AS siteAdi_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1;

SELECT 
  d0_.id AS id_0 
FROM 
  dil d0_ 
WHERE 
  d0_.aktif = 1

SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1;

SELECT 
  a0_.siteYolu AS siteYolu_0 
FROM 
  ayarlar a0_ 
WHERE 
  a0_.dil_id = 1

SELECT a0_.siteYolu AS siteYolu_0 FROM ayarlar a0_ WHERE a0_.dil_id = 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

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;

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

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;

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

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;

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

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;

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

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;

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

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;

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

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;

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

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;

SELECT 
  i0_.telefon AS telefon_0 
FROM 
  iletisim i0_ 
  INNER JOIN dil d1_ ON i0_.dil_id = d1_.id 
WHERE 
  d1_.id = 1

SELECT i0_.telefon AS telefon_0 FROM iletisim i0_ INNER JOIN dil d1_ ON i0_.dil_id = d1_.id WHERE d1_.id = 1;

SELECT 
  i0_.eposta AS eposta_0 
FROM 
  iletisim i0_ 
  INNER JOIN dil d1_ ON i0_.dil_id = d1_.id 
WHERE 
  d1_.id = 1

SELECT i0_.eposta AS eposta_0 FROM iletisim i0_ INNER JOIN dil d1_ ON i0_.dil_id = d1_.id WHERE d1_.id = 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

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;

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

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;

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'

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';

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

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;

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

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;

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

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;

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

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;

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

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;

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

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;

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

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;

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

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;

SELECT 
  s0_.popup AS popup_0 
FROM 
  sayfa s0_ 
WHERE 
  s0_.dilgrup = 14

SELECT s0_.popup AS popup_0 FROM sayfa s0_ WHERE s0_.dilgrup = 14;

SELECT 
  i0_.adres AS adres_0 
FROM 
  iletisim i0_ 
  INNER JOIN dil d1_ ON i0_.dil_id = d1_.id 
WHERE 
  d1_.id = 1

SELECT i0_.adres AS adres_0 FROM iletisim i0_ INNER JOIN dil d1_ ON i0_.dil_id = d1_.id WHERE d1_.id = 1;

SELECT 
  s0_.ad AS ad_0, 
  s0_.url AS url_1 
FROM 
  sosyal_ag s0_

SELECT s0_.ad AS ad_0, s0_.url AS url_1 FROM sosyal_ag s0_;

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

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;

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