https://www.agribiosol.com/sitemap.xml

Query Metrics

285 Database Queries
37 Different statements
58.38 ms Query time
0 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Grouped Statements

Show all queries

Time Count Info
12.08 ms
(20.70%)
76
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[]
10.22 ms
(17.50%)
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.31 ms
(10.80%)
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.72 ms
(8.08%)
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:
[]
2.48 ms
(4.25%)
13
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1 AND d0_.varsayilan = 1
Parameters:
[]
2.39 ms
(4.09%)
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:
[]
2.28 ms
(3.90%)
13
SELECT a0_.site_yolu AS site_yolu_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[]
2.04 ms
(3.50%)
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.79 ms
(3.06%)
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.40 ms
(2.40%)
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:
[]
1.33 ms
(2.28%)
6
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.29 ms
(2.21%)
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:
[]
1.06 ms
(1.82%)
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:
[]
0.95 ms
(1.62%)
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:
[]
0.93 ms
(1.59%)
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 = 5 AND d1_.id = 1 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[]
0.89 ms
(1.52%)
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.84 ms
(1.44%)
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.71 ms
(1.22%)
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.70 ms
(1.19%)
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.43 ms
(0.74%)
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.43 ms
(0.74%)
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.32 ms
(0.55%)
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.29 ms
(0.49%)
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.23 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 = 1 AND d1_.id = 1 ORDER BY k0_.sira ASC
Parameters:
[]
0.21 ms
(0.37%)
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.21 ms
(0.35%)
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.32%)
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.18 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 = 2 AND d1_.id = 1 ORDER BY k0_.sira ASC
Parameters:
[]
0.17 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 = 3 AND d1_.id = 1 ORDER BY k0_.sira ASC
Parameters:
[]
0.17 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 = 12 AND d1_.id = 1 ORDER BY k0_.sira ASC
Parameters:
[]
0.17 ms
(0.30%)
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.17 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 = 5 AND d1_.id = 1 ORDER BY k0_.sira ASC
Parameters:
[]
0.17 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 = 6 AND d1_.id = 1 ORDER BY k0_.sira ASC
Parameters:
[]
0.16 ms
(0.28%)
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.16 ms
(0.27%)
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.16 ms
(0.27%)
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.15 ms
(0.26%)
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.