Query Metrics
285
Database Queries
37
Different statements
63.04 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
12.14 ms (19.26%) |
76 |
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[] |
|
9.70 ms (15.38%) |
48 |
SELECT k0_.id AS id_0, k0_.dilgrup AS dilgrup_1, k0_.adi AS adi_2, k0_.seourl AS seourl_3, k0_.ustid AS ustid_4 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.dilgrup = 0 AND d1_.id = 1 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[] |
|
6.88 ms (10.92%) |
35 |
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:
[] |
|
4.20 ms (6.66%) |
25 |
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 6 AND d1_.id = 1
Parameters:
[] |
|
3.08 ms (4.88%) |
13 |
SELECT a0_.site_yolu AS site_yolu_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
|
3.07 ms (4.86%) |
13 |
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1 AND d0_.varsayilan = 1
Parameters:
[] |
|
2.74 ms (4.34%) |
1 |
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:
[] |
|
2.57 ms (4.07%) |
1 |
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 = 20 ORDER BY h0_.sira ASC
Parameters:
[] |
|
2.02 ms (3.21%) |
11 |
SELECT k0_.id AS id_0, k0_.dilgrup AS dilgrup_1, k0_.adi AS adi_2, k0_.seourl AS seourl_3, k0_.ustid AS ustid_4 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.dilgrup = 2 AND d1_.id = 1 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[] |
|
1.73 ms (2.75%) |
9 |
SELECT k0_.id AS id_0, k0_.dilgrup AS dilgrup_1, k0_.adi AS adi_2, k0_.seourl AS seourl_3, k0_.ustid AS ustid_4 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.dilgrup = 11 AND d1_.id = 1 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[] |
|
1.70 ms (2.70%) |
9 |
SELECT s0_.seo AS seo_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.dilgrup = 7 AND d1_.id = 1
Parameters:
[] |
|
1.49 ms (2.37%) |
1 |
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:
[] |
|
1.31 ms (2.08%) |
1 |
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 haberler 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 = 22 ORDER BY h0_.sira ASC
Parameters:
[] |
|
1.18 ms (1.87%) |
5 |
SELECT k0_.id AS id_0, k0_.dilgrup AS dilgrup_1, k0_.adi AS adi_2, k0_.seourl AS seourl_3, k0_.ustid AS ustid_4 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.dilgrup = 9 AND d1_.id = 1 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[] |
|
1.05 ms (1.67%) |
5 |
SELECT k0_.id AS id_0, k0_.dilgrup AS dilgrup_1, k0_.adi AS adi_2, k0_.seourl AS seourl_3, k0_.ustid AS ustid_4 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.dilgrup = 5 AND d1_.id = 1 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.87 ms (1.38%) |
4 |
SELECT k0_.id AS id_0, k0_.dilgrup AS dilgrup_1, k0_.adi AS adi_2, k0_.seourl AS seourl_3, k0_.ustid AS ustid_4 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.dilgrup = 4 AND d1_.id = 1 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.77 ms (1.22%) |
1 |
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 = 21 ORDER BY h0_.sira ASC
Parameters:
[] |
|
0.70 ms (1.10%) |
3 |
SELECT k0_.id AS id_0, k0_.dilgrup AS dilgrup_1, k0_.adi AS adi_2, k0_.seourl AS seourl_3, k0_.ustid AS ustid_4 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.dilgrup = 7 AND d1_.id = 1 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.62 ms (0.99%) |
3 |
SELECT k0_.id AS id_0, k0_.dilgrup AS dilgrup_1, k0_.adi AS adi_2, k0_.seourl AS seourl_3, k0_.ustid AS ustid_4 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.dilgrup = 13 AND d1_.id = 1 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.53 ms (0.84%) |
2 |
SELECT k0_.id AS id_0, k0_.dilgrup AS dilgrup_1, k0_.adi AS adi_2, k0_.seourl AS seourl_3, k0_.ustid AS ustid_4 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.dilgrup = 8 AND d1_.id = 1 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.47 ms (0.75%) |
2 |
SELECT k0_.id AS id_0, k0_.dilgrup AS dilgrup_1, k0_.adi AS adi_2, k0_.seourl AS seourl_3, k0_.ustid AS ustid_4 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.dilgrup = 12 AND d1_.id = 1 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.46 ms (0.73%) |
2 |
SELECT k0_.id AS id_0, k0_.dilgrup AS dilgrup_1, k0_.adi AS adi_2, k0_.seourl AS seourl_3, k0_.ustid AS ustid_4 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.dilgrup = 6 AND d1_.id = 1 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.44 ms (0.69%) |
1 |
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:
[] |
|
0.30 ms (0.47%) |
1 |
SELECT k0_.dilgrup AS dilgrup_0, k0_.seourl AS seourl_1, d1_.kisa AS kisa_2, k0_.ustid AS ustid_3 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.ustid = 1 AND d1_.id = 1 ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.28 ms (0.44%) |
1 |
SELECT k0_.dilgrup AS dilgrup_0, k0_.seourl AS seourl_1, d1_.kisa AS kisa_2, k0_.ustid AS ustid_3 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.ustid = 2 AND d1_.id = 1 ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.28 ms (0.44%) |
1 |
SELECT k0_.id AS id_0, k0_.dilgrup AS dilgrup_1, k0_.adi AS adi_2, k0_.seourl AS seourl_3, k0_.ustid AS ustid_4 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.dilgrup = 1 AND d1_.id = 1 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.27 ms (0.43%) |
1 |
SELECT k0_.dilgrup AS dilgrup_0, k0_.seourl AS seourl_1, d1_.kisa AS kisa_2, k0_.ustid AS ustid_3 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.ustid = 3 AND d1_.id = 1 ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.25 ms (0.40%) |
1 |
SELECT k0_.dilgrup AS dilgrup_0, k0_.seourl AS seourl_1, d1_.kisa AS kisa_2, k0_.ustid AS ustid_3 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.ustid = 12 AND d1_.id = 1 ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.25 ms (0.39%) |
1 |
SELECT k0_.dilgrup AS dilgrup_0, k0_.seourl AS seourl_1, d1_.kisa AS kisa_2, k0_.ustid AS ustid_3 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.ustid = 11 AND d1_.id = 1 ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.25 ms (0.39%) |
1 |
SELECT k0_.dilgrup AS dilgrup_0, k0_.seourl AS seourl_1, d1_.kisa AS kisa_2, k0_.ustid AS ustid_3 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.ustid = 5 AND d1_.id = 1 ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.24 ms (0.38%) |
1 |
SELECT k0_.dilgrup AS dilgrup_0, k0_.seourl AS seourl_1, d1_.kisa AS kisa_2, k0_.ustid AS ustid_3 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.ustid = 4 AND d1_.id = 1 ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.24 ms (0.38%) |
1 |
SELECT k0_.id AS id_0, k0_.dilgrup AS dilgrup_1, k0_.adi AS adi_2, k0_.seourl AS seourl_3, k0_.ustid AS ustid_4 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.dilgrup = 3 AND d1_.id = 1 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.23 ms (0.36%) |
1 |
SELECT k0_.dilgrup AS dilgrup_0, k0_.seourl AS seourl_1, d1_.kisa AS kisa_2, k0_.ustid AS ustid_3 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.ustid = 13 AND d1_.id = 1 ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.20 ms (0.31%) |
1 |
SELECT k0_.dilgrup AS dilgrup_0, k0_.seourl AS seourl_1, d1_.kisa AS kisa_2, k0_.ustid AS ustid_3 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.ustid = 8 AND d1_.id = 1 ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.19 ms (0.30%) |
1 |
SELECT k0_.dilgrup AS dilgrup_0, k0_.seourl AS seourl_1, d1_.kisa AS kisa_2, k0_.ustid AS ustid_3 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.ustid = 6 AND d1_.id = 1 ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.19 ms (0.29%) |
1 |
SELECT k0_.dilgrup AS dilgrup_0, k0_.seourl AS seourl_1, d1_.kisa AS kisa_2, k0_.ustid AS ustid_3 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.ustid = 7 AND d1_.id = 1 ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.18 ms (0.29%) |
1 |
SELECT k0_.dilgrup AS dilgrup_0, k0_.seourl AS seourl_1, d1_.kisa AS kisa_2, k0_.ustid AS ustid_3 FROM kategori k0_ INNER JOIN dil d1_ ON k0_.dil_id = d1_.id WHERE k0_.ustid = 9 AND d1_.id = 1 ORDER BY k0_.sira ASC
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. |
| App\Entity\Haberler | No errors. |