Query Metrics
83
Database Queries
13
Different statements
23.83 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
6.63 ms (27.80%) |
31 |
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:
[] |
|
4.64 ms (19.49%) |
1 |
SELECT h0_.seourl AS seourl_0, h0_.sayfabasligi AS sayfabasligi_1, h0_.anahtarkelimeler AS anahtarkelimeler_2, h0_.sayfaaciklamasi AS sayfaaciklamasi_3, h0_.adi AS adi_4, h0_.model AS model_5, h0_.aciklama AS aciklama_6, h0_.metin AS metin_7, h0_.resimler AS resimler_8, h0_.boyutlaruzunluk AS boyutlaruzunluk_9, h0_.boyutlargenislik AS boyutlargenislik_10, h0_.boyutlaryukseklik AS boyutlaryukseklik_11, h0_.elektrikbilesenleri AS elektrikbilesenleri_12, h0_.enerjiozellikleriyakittipimotorinminimum AS enerjiozellikleriyakittipimotorinminimum_13, h0_.enerjiozellikleriyakittipimotorinmaximum AS enerjiozellikleriyakittipimotorinmaximum_14, h0_.enerjiozellikleriyakittipimotorinortalama AS enerjiozellikleriyakittipimotorinortalama_15, h0_.enerjiozellikleriyakittipielektrikrezistans AS enerjiozellikleriyakittipielektrikrezistans_16, h0_.enerjiozellikleriyakittipilpgminimum AS enerjiozellikleriyakittipilpgminimum_17, h0_.enerjiozellikleriyakittipilpgmaximum AS enerjiozellikleriyakittipilpgmaximum_18, h0_.enerjiozellikleriyakittipilpgortalama AS enerjiozellikleriyakittipilpgortalama_19, h0_.enerjiozellikleriyakittipidogalgazminimum AS enerjiozellikleriyakittipidogalgazminimum_20, h0_.enerjiozellikleriyakittipidogalgazmaximum AS enerjiozellikleriyakittipidogalgazmaximum_21, h0_.enerjiozellikleriyakittipidogalgazortalama AS enerjiozellikleriyakittipidogalgazortalama_22, h0_.urunvideo AS urunvideo_23, h0_.dilgrup AS dilgrup_24, d1_.kisa AS kisa_25, k2_.adi AS adi_26, k2_.dilgrup AS dilgrup_27 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 = 26 GROUP BY h0_.dilgrup ORDER BY h0_.sira ASC
Parameters:
[] |
|
3.43 ms (14.41%) |
15 |
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:
[] |
|
2.96 ms (12.42%) |
13 |
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:
[] |
|
1.64 ms (6.87%) |
7 |
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.58 ms (6.63%) |
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:
[] |
|
0.75 ms (3.16%) |
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 = 10 AND d1_.id = 1 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.72 ms (3.03%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.is_verified AS is_verified_6, t0.adsoyad AS adsoyad_7, t0.unvan AS unvan_8, t0.password_token AS password_token_9, t0.yetkiler AS yetkiler_10, t0.is_password AS is_password_11 FROM user t0 WHERE t0.id = ?
Parameters:
[
4
]
|
|
0.51 ms (2.15%) |
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 = 3 AND d1_.id = 1 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.42 ms (1.78%) |
1 |
SELECT s0_.id AS id_0, m1_.alan AS alan_1, m1_.tip AS tip_2, m1_.tablo_adi AS tablo_adi_3, s0_.dilgrup AS dilgrup_4, s0_.kategori AS kategori_5, s0_.seo AS seo_6, s0_.ic_icerik AS ic_icerik_7 FROM sayfa s0_ INNER JOIN modul m1_ ON s0_.modul_id = m1_.id WHERE s0_.id = 26
Parameters:
[] |
|
0.20 ms (0.85%) |
1 |
SELECT a0_.site_yolu AS site_yolu_0 FROM ayarlar a0_ WHERE a0_.dil_id = 17
Parameters:
[] |
|
0.18 ms (0.77%) |
1 |
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[] |
|
0.15 ms (0.63%) |
1 |
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1 AND d0_.varsayilan = 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\User | No errors. |
| App\Entity\Sayfa | No errors. |
| App\Entity\Modul | No errors. |
| App\Entity\Hizmetler | No errors. |
| App\Entity\Kategori | No errors. |
| App\Entity\Dil | No errors. |
| App\Entity\Ayarlar | No errors. |