https://www.greenexgeo.rvyazilim.net/sitemap.xml

Query Metrics

78 Database Queries
15 Different statements
17.49 ms Query time
0 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

# Time Info
1 0.90 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1 AND d0_.varsayilan = 1
Parameters:
[]
2 0.89 ms
SELECT a0_.site_yolu AS site_yolu_0 FROM ayarlar a0_ WHERE a0_.dil_id = 17
Parameters:
[]
3 0.18 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
4 0.20 ms
SELECT d0_.kisa AS kisa_0 FROM dil d0_ WHERE d0_.aktif = 1 ORDER BY d0_.id ASC
Parameters:
[]
5 1.44 ms
SELECT d0_.kisa AS kisa_0, s1_.seo AS seo_1 FROM sayfa s1_ INNER JOIN dil d0_ ON s1_.dil_id = d0_.id INNER JOIN modul m2_ ON s1_.modul_id = m2_.id WHERE s1_.menu = 1 ORDER BY s1_.sira ASC
Parameters:
[]
6 0.17 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
7 0.15 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
8 0.15 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
9 0.15 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
10 0.15 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
11 0.15 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
12 0.15 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
13 0.14 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
14 0.13 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
15 0.12 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
16 0.12 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
17 0.15 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
18 0.15 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
19 0.15 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
20 0.16 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
21 1.04 ms
SELECT d0_.id AS id_0, s1_.dilgrup AS dilgrup_1, k2_.dilgrup AS dilgrup_2, k2_.seourl AS seourl_3, d0_.kisa AS kisa_4 FROM kategori k2_ INNER JOIN sayfa s1_ ON k2_.sayfa_id = s1_.id INNER JOIN dil d0_ ON k2_.dil_id = d0_.id WHERE k2_.ustid = 0 ORDER BY k2_.sira ASC
Parameters:
[]
22 0.38 ms
SELECT s0_.id AS id_0, d1_.kisa AS kisa_1, s0_.seo AS seo_2, s0_.kategori AS kategori_3, s0_.tek_veri AS tek_veri_4, s0_.ic_icerik AS ic_icerik_5, m2_.tablo_adi AS tablo_adi_6, s0_.dilgrup AS dilgrup_7 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id INNER JOIN modul m2_ ON s0_.modul_id = m2_.id WHERE s0_.menu = 1 GROUP BY s0_.dilgrup ORDER BY s0_.sira ASC
Parameters:
[]
23 1.19 ms
SELECT h0_.seourl AS seourl_0, h0_.dilgrup AS dilgrup_1, d1_.kisa AS kisa_2, k2_.dilgrup AS dilgrup_3, d1_.id AS id_4, s3_.dilgrup AS dilgrup_5 FROM hizmetler h0_ LEFT JOIN kategori k2_ ON h0_.kategori_id = k2_.id INNER JOIN sayfa s3_ ON h0_.sayfa_id = s3_.id INNER JOIN dil d1_ ON h0_.dil_id = d1_.id WHERE s3_.id = 25 ORDER BY h0_.sira ASC
Parameters:
[]
24 0.26 ms
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 4 AND d1_.id = 1
Parameters:
[]
25 0.17 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
26 0.20 ms
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 4 AND d1_.id = 50
Parameters:
[]
27 0.18 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
28 0.21 ms
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 4 AND d1_.id = 17
Parameters:
[]
29 0.17 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
30 0.19 ms
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 4 AND d1_.id = 1
Parameters:
[]
31 0.21 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
32 0.16 ms
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 4 AND d1_.id = 50
Parameters:
[]
33 0.13 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
34 0.16 ms
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 4 AND d1_.id = 17
Parameters:
[]
35 0.13 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
36 0.15 ms
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 4 AND d1_.id = 1
Parameters:
[]
37 0.16 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
38 0.18 ms
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 4 AND d1_.id = 50
Parameters:
[]
39 0.16 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
40 0.15 ms
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 4 AND d1_.id = 17
Parameters:
[]
41 0.16 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
42 0.19 ms
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 4 AND d1_.id = 1
Parameters:
[]
43 0.12 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
44 0.17 ms
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 4 AND d1_.id = 50
Parameters:
[]
45 0.12 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
46 0.15 ms
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 4 AND d1_.id = 17
Parameters:
[]
47 0.12 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
48 0.15 ms
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 4 AND d1_.id = 1
Parameters:
[]
49 0.12 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
50 0.14 ms
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 4 AND d1_.id = 50
Parameters:
[]
51 0.12 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
52 0.14 ms
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 4 AND d1_.id = 17
Parameters:
[]
53 0.14 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
54 0.14 ms
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 4 AND d1_.id = 1
Parameters:
[]
55 0.11 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
56 0.19 ms
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 4 AND d1_.id = 50
Parameters:
[]
57 0.17 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
58 0.15 ms
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 4 AND d1_.id = 17
Parameters:
[]
59 0.17 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
60 0.37 ms
SELECT h0_.seourl AS seourl_0, h0_.dilgrup AS dilgrup_1, d1_.kisa AS kisa_2, k2_.dilgrup AS dilgrup_3, d1_.id AS id_4, s3_.dilgrup AS dilgrup_5 FROM hizmetler h0_ LEFT JOIN kategori k2_ ON h0_.kategori_id = k2_.id INNER JOIN sayfa s3_ ON h0_.sayfa_id = s3_.id INNER JOIN dil d1_ ON h0_.dil_id = d1_.id WHERE s3_.id = 28 ORDER BY h0_.sira ASC
Parameters:
[]
61 0.18 ms
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 5 AND d1_.id = 1
Parameters:
[]
62 0.15 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
63 0.22 ms
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 5 AND d1_.id = 17
Parameters:
[]
64 0.19 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
65 0.23 ms
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 5 AND d1_.id = 50
Parameters:
[]
66 0.18 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
67 0.16 ms
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 5 AND d1_.id = 1
Parameters:
[]
68 0.19 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
69 0.21 ms
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 5 AND d1_.id = 17
Parameters:
[]
70 0.13 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
71 0.15 ms
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 5 AND d1_.id = 50
Parameters:
[]
72 0.13 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
73 0.15 ms
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 5 AND d1_.id = 1
Parameters:
[]
74 0.13 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
75 0.15 ms
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 5 AND d1_.id = 17
Parameters:
[]
76 0.15 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
77 0.16 ms
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 5 AND d1_.id = 50
Parameters:
[]
78 0.11 ms
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 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\Ayarlar No errors.
App\Entity\Sayfa No errors.
App\Entity\Modul No errors.
App\Entity\Kategori No errors.
App\Entity\Hizmetler No errors.