Query Metrics
100
Database Queries
70
Different statements
26.29 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.49 ms (5.67%) |
1 |
SELECT s0_.id AS id_0, s0_.adi AS adi_1, s0_.banner_durum AS banner_durum_2, s0_.banner_url AS banner_url_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_.tablo_adi AS tablo_adi_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 = 'Связь' AND d2_.id = 50 ORDER BY s0_.sira ASC
Parameters:
[] |
|
1.44 ms (5.47%) |
1 |
SELECT i0_.adres AS adres_0, i0_.telefon AS telefon_1, i0_.gsm AS gsm_2, i0_.fax AS fax_3, i0_.eposta AS eposta_4, i0_.harita AS harita_5, i0_.dilgrup AS dilgrup_6, k1_.dilgrup AS dilgrup_7, d2_.id AS id_8, s3_.dilgrup AS dilgrup_9 FROM iletisim i0_ LEFT JOIN kategori k1_ ON i0_.kategori_id = k1_.id INNER JOIN dil d2_ ON i0_.dil_id = d2_.id INNER JOIN sayfa s3_ ON i0_.sayfa_id = s3_.id WHERE s3_.id = '8' AND d2_.id = 50 ORDER BY i0_.sira ASC, i0_.id DESC
Parameters:
[] |
|
1.19 ms (4.53%) |
3 |
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:
[] |
|
1.01 ms (3.85%) |
2 |
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[] |
|
0.86 ms (3.27%) |
4 |
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 = 'Telefon'
Parameters:
[] |
|
0.79 ms (3.02%) |
1 |
SELECT k0_.link AS link_0, k0_.dilgrup AS dilgrup_1, k1_.dilgrup AS dilgrup_2, d2_.id AS id_3, s3_.dilgrup AS dilgrup_4 FROM katalog k0_ LEFT JOIN kategori k1_ ON k0_.kategori_id = k1_.id INNER JOIN sayfa s3_ ON k0_.sayfa_id = s3_.id INNER JOIN dil d2_ ON k0_.dil_id = d2_.id WHERE s3_.id = 26 AND d2_.id = 50 ORDER BY k0_.sira ASC, k0_.id DESC LIMIT 10
Parameters:
[] |
|
0.75 ms (2.85%) |
1 |
SELECT a0_.debug AS debug_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
|
0.74 ms (2.80%) |
1 |
SELECT f0_.adi AS adi_0, f0_.tip AS tip_1, f0_.veri AS veri_2, f0_.alan AS alan_3, f0_.zorunlu AS zorunlu_4, f0_.id AS id_5 FROM form f0_ WHERE f0_.id = 1
Parameters:
[] |
|
0.71 ms (2.71%) |
4 |
SELECT c0_.deger AS deger_0 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE d1_.id = 50 AND c0_.tr_id = 7
Parameters:
[] |
|
0.71 ms (2.71%) |
4 |
SELECT c0_.deger AS deger_0 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE d1_.id = 50 AND c0_.tr_id = 6
Parameters:
[] |
|
0.68 ms (2.58%) |
1 |
SELECT f0_.kurumsalaciklama AS kurumsalaciklama_0 FROM footermetin f0_ INNER JOIN dil d1_ ON f0_.dil_id = d1_.id WHERE d1_.id = 50
Parameters:
[] |
|
0.68 ms (2.57%) |
1 |
SELECT p0_.veri AS veri_0, p0_.link AS link_1, p0_.tip AS tip_2, p0_.dilgrup AS dilgrup_3 FROM popup p0_ INNER JOIN dil d1_ ON p0_.dil_id = d1_.id WHERE p0_.sayfa_id = 0 AND d1_.id = 50
Parameters:
[] |
|
0.64 ms (2.43%) |
1 |
SELECT s0_.ad AS ad_0, s0_.url AS url_1 FROM sosyal_ag s0_
Parameters:
[] |
|
0.64 ms (2.42%) |
3 |
SELECT s0_.id AS id_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 4 GROUP BY s0_.dil_id
Parameters:
[] |
|
0.58 ms (2.20%) |
3 |
SELECT c0_.deger AS deger_0 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE d1_.id = 50 AND c0_.tr_id = 1
Parameters:
[] |
|
0.53 ms (2.00%) |
3 |
SELECT s0_.id AS id_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 9 GROUP BY s0_.dil_id
Parameters:
[] |
|
0.48 ms (1.83%) |
2 |
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 = 'Ad Soyad'
Parameters:
[] |
|
0.44 ms (1.66%) |
2 |
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 = 'Mesaj'
Parameters:
[] |
|
0.44 ms (1.66%) |
2 |
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 = 'E-Posta'
Parameters:
[] |
|
0.42 ms (1.59%) |
2 |
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 = 'E-posta'
Parameters:
[] |
|
0.40 ms (1.54%) |
2 |
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 = 'Konu'
Parameters:
[] |
|
0.40 ms (1.53%) |
2 |
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 = 'Adres'
Parameters:
[] |
|
0.40 ms (1.52%) |
2 |
SELECT s0_.id AS id_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 8 GROUP BY s0_.dil_id
Parameters:
[] |
|
0.40 ms (1.51%) |
2 |
SELECT c0_.deger AS deger_0 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE d1_.id = 50 AND c0_.tr_id = 51
Parameters:
[] |
|
0.40 ms (1.50%) |
2 |
SELECT c0_.deger AS deger_0 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE d1_.id = 50 AND c0_.tr_id = 5
Parameters:
[] |
|
0.36 ms (1.35%) |
2 |
SELECT c0_.deger AS deger_0 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE d1_.id = 50 AND c0_.tr_id = 9
Parameters:
[] |
|
0.35 ms (1.34%) |
2 |
SELECT c0_.deger AS deger_0 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE d1_.id = 50 AND c0_.tr_id = 8
Parameters:
[] |
|
0.35 ms (1.32%) |
2 |
SELECT s0_.id AS id_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 10 GROUP BY s0_.dil_id
Parameters:
[] |
|
0.29 ms (1.12%) |
1 |
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1 AND d0_.varsayilan = 1
Parameters:
[] |
|
0.26 ms (1.00%) |
1 |
SELECT d0_.id AS id_0, d0_.kisa AS kisa_1, d0_.uzun AS uzun_2 FROM dil d0_ WHERE d0_.kisa = 'ru' AND d0_.aktif = 1 ORDER BY d0_.aktif DESC
Parameters:
[] |
|
0.25 ms (0.96%) |
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.24 ms (0.92%) |
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_.tablo_adi AS tablo_adi_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 = 50 AND s0_.menu = 1 ORDER BY s0_.sira ASC
Parameters:
[] |
|
0.24 ms (0.90%) |
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.23 ms (0.87%) |
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_.tablo_adi AS tablo_adi_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 = 50 AND s0_.dilgrup = 11 ORDER BY s0_.sira ASC
Parameters:
[] |
|
0.23 ms (0.86%) |
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_.tablo_adi AS tablo_adi_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 = 50 AND s0_.menu = 1 AND s0_.dilgrup = 9 ORDER BY s0_.sira ASC
Parameters:
[] |
|
0.22 ms (0.85%) |
1 |
SELECT k0_.dilgrup AS dilgrup_0, k0_.adi AS adi_1, k0_.seourl AS seourl_2, k0_.resim AS resim_3 FROM kategori k0_ INNER JOIN sayfa s1_ ON k0_.sayfa_id = s1_.id INNER JOIN dil d2_ ON k0_.dil_id = d2_.id WHERE s1_.id = 20 AND k0_.ustid = 0 AND d2_.id = 50 ORDER BY k0_.sira ASC LIMIT 99
Parameters:
[] |
|
0.21 ms (0.81%) |
1 |
SELECT i0_.telefon AS telefon_0 FROM iletisim i0_ INNER JOIN dil d1_ ON i0_.dil_id = d1_.id WHERE d1_.id = 50
Parameters:
[] |
|
0.21 ms (0.80%) |
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 = 'Takip Edin'
Parameters:
[] |
|
0.21 ms (0.80%) |
1 |
SELECT c0_.deger AS deger_0 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE d1_.id = 50 AND c0_.tr_id = 107
Parameters:
[] |
|
0.21 ms (0.80%) |
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 = 'Bize Ulaşın'
Parameters:
[] |
|
0.21 ms (0.80%) |
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 = 'Hızlı Menü'
Parameters:
[] |
|
0.21 ms (0.80%) |
1 |
SELECT c0_.deger AS deger_0 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE d1_.id = 50 AND c0_.tr_id = 2
Parameters:
[] |
|
0.21 ms (0.79%) |
1 |
SELECT k0_.dilgrup AS dilgrup_0, k0_.adi AS adi_1, k0_.seourl AS seourl_2 FROM kategori k0_ INNER JOIN sayfa s1_ ON k0_.sayfa_id = s1_.id INNER JOIN dil d2_ ON k0_.dil_id = d2_.id WHERE s1_.id = 20 AND k0_.ustid = 0 AND d2_.id = 50 ORDER BY k0_.sira ASC LIMIT 10
Parameters:
[] |
|
0.21 ms (0.78%) |
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 = 'Gönder'
Parameters:
[] |
|
0.21 ms (0.78%) |
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 = 'Sorun mu var, hemen sor!'
Parameters:
[] |
|
0.21 ms (0.78%) |
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 = 'Güvenlik kodunu giriniz.'
Parameters:
[] |
|
0.20 ms (0.77%) |
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 = 'Güvenlik Kodu'
Parameters:
[] |
|
0.20 ms (0.76%) |
1 |
SELECT a0_.site_adi AS site_adi_0 FROM ayarlar a0_ WHERE a0_.dil_id = 50
Parameters:
[] |
|
0.20 ms (0.75%) |
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.19 ms (0.71%) |
1 |
SELECT c0_.deger AS deger_0 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE d1_.id = 50 AND c0_.tr_id = 10
Parameters:
[] |
|
0.18 ms (0.70%) |
1 |
SELECT c0_.deger AS deger_0 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE d1_.id = 50 AND c0_.tr_id = 4
Parameters:
[] |
|
0.18 ms (0.69%) |
1 |
SELECT c0_.deger AS deger_0 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE d1_.id = 50 AND c0_.tr_id = 11
Parameters:
[] |
|
0.18 ms (0.69%) |
1 |
SELECT s0_.id AS id_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 11 GROUP BY s0_.dil_id
Parameters:
[] |
|
0.18 ms (0.69%) |
1 |
SELECT c0_.deger AS deger_0 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE d1_.id = 50 AND c0_.tr_id = 56
Parameters:
[] |
|
0.18 ms (0.68%) |
1 |
SELECT c0_.deger AS deger_0 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE d1_.id = 50 AND c0_.tr_id = 109
Parameters:
[] |
|
0.18 ms (0.68%) |
1 |
SELECT c0_.deger AS deger_0 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE d1_.id = 50 AND c0_.tr_id = 54
Parameters:
[] |
|
0.17 ms (0.67%) |
1 |
SELECT c0_.deger AS deger_0 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE d1_.id = 50 AND c0_.tr_id = 57
Parameters:
[] |
|
0.17 ms (0.66%) |
1 |
SELECT c0_.deger AS deger_0 FROM ceviri c0_ INNER JOIN dil d1_ ON c0_.dil_id = d1_.id WHERE d1_.id = 50 AND c0_.tr_id = 3
Parameters:
[] |
|
0.16 ms (0.62%) |
1 |
SELECT i0_.adres AS adres_0 FROM iletisim i0_ INNER JOIN dil d1_ ON i0_.dil_id = d1_.id WHERE d1_.id = 50
Parameters:
[] |
|
0.16 ms (0.62%) |
1 |
SELECT d0_.id AS id_0, d0_.kisa AS kisa_1, d0_.uzun AS uzun_2 FROM dil d0_ WHERE d0_.aktif = 1 ORDER BY d0_.aktif DESC
Parameters:
[] |
|
0.15 ms (0.59%) |
1 |
SELECT i0_.eposta AS eposta_0 FROM iletisim i0_ INNER JOIN dil d1_ ON i0_.dil_id = d1_.id WHERE d1_.id = 50
Parameters:
[] |
|
0.15 ms (0.58%) |
1 |
SELECT a0_.whatsapp AS whatsapp_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
|
0.15 ms (0.57%) |
1 |
SELECT i0_.gsm AS gsm_0 FROM iletisim i0_ INNER JOIN dil d1_ ON i0_.dil_id = d1_.id WHERE d1_.id = 50
Parameters:
[] |
|
0.14 ms (0.55%) |
1 |
SELECT a0_.position AS position_0 FROM ayarlar a0_ WHERE a0_.dil_id = 50
Parameters:
[] |
|
0.14 ms (0.54%) |
1 |
SELECT a0_.site_adi AS site_adi_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
|
0.14 ms (0.54%) |
1 |
SELECT s0_.banner_durum AS banner_durum_0, s0_.banner_url AS banner_url_1 FROM sayfa s0_ WHERE s0_.dilgrup = 4
Parameters:
[] |
|
0.14 ms (0.53%) |
1 |
SELECT a0_.region AS region_0 FROM ayarlar a0_ WHERE a0_.dil_id = 50
Parameters:
[] |
|
0.14 ms (0.53%) |
1 |
SELECT a0_.place_name AS place_name_0 FROM ayarlar a0_ WHERE a0_.dil_id = 50
Parameters:
[] |
|
0.14 ms (0.52%) |
1 |
SELECT a0_.site_yolu AS site_yolu_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
|
0.13 ms (0.51%) |
1 |
SELECT a0_.ozel_head AS ozel_head_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 |
|---|---|
| App\Entity\Dil | No errors. |
| App\Entity\Sayfa | No errors. |
| App\Entity\Modul | No errors. |
| App\Entity\Iletisim | No errors. |
| App\Entity\Kategori | No errors. |
| App\Entity\Ayarlar | No errors. |
| App\Entity\Ceviri | No errors. |
| App\Entity\Katalog | No errors. |
| App\Entity\Form | No errors. |
| App\Entity\Footermetin | No errors. |
| App\Entity\SosyalAg | No errors. |
| App\Entity\Popup | No errors. |