Query Metrics
14
Database Queries
12
Different statements
2.81 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.59 ms (21.14%) |
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:
[
2
]
|
|
0.30 ms (10.69%) |
2 |
SELECT s0_.adi AS adi_0, s0_.dilgrup AS dilgrup_1, s0_.id AS id_2 FROM sayfa s0_ GROUP BY s0_.dilgrup ORDER BY s0_.sira ASC
Parameters:
[] |
|
0.29 ms (10.32%) |
1 |
SELECT s0_.id AS id_0, s0_.adi AS adi_1, m1_.alan AS alan_2, m1_.tip AS tip_3, m1_.bosluk AS bosluk_4, m1_.coklu_dil AS coklu_dil_5, m1_.tablo_adi AS tablo_adi_6, s0_.dilgrup AS dilgrup_7, s0_.kategori AS kategori_8, s0_.ic_icerik AS ic_icerik_9 FROM sayfa s0_ INNER JOIN modul m1_ ON s0_.modul_id = m1_.id WHERE s0_.id = 19
Parameters:
[] |
|
0.25 ms (8.73%) |
1 |
SELECT f0_.id AS id_0 FROM form_kayit f0_ WHERE f0_.okuma = 0
Parameters:
[] |
|
0.24 ms (8.58%) |
2 |
SELECT b0_.id AS id_0, b0_.baslik AS baslik_1, b0_.metin AS metin_2, b0_.okuma AS okuma_3, b0_.tarih AS tarih_4 FROM bildirim b0_ ORDER BY b0_.okuma ASC
Parameters:
[] |
|
0.23 ms (8.18%) |
1 |
SELECT k0_.id AS id_0, k0_.dilgrup AS dilgrup_1, k0_.adi AS adi_2 FROM kategori k0_ INNER JOIN sayfa s1_ ON k0_.sayfa_id = s1_.id WHERE s1_.id = 19 AND k0_.ustid = 0 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.17 ms (5.91%) |
1 |
SELECT s0_.id AS id_0, s0_.adi AS adi_1, s0_.dilgrup AS dilgrup_2 FROM sayfa s0_ WHERE s0_.kategori = 1 GROUP BY s0_.dilgrup ORDER BY s0_.sira ASC
Parameters:
[] |
|
0.16 ms (5.74%) |
1 |
SELECT d0_.id AS id_0, d0_.kisa AS kisa_1 FROM dil d0_ WHERE d0_.aktif = 1 ORDER BY d0_.id ASC
Parameters:
[] |
|
0.15 ms (5.48%) |
1 |
SELECT b0_.id AS id_0 FROM bildirim b0_ WHERE b0_.okuma = 0
Parameters:
[] |
|
0.15 ms (5.23%) |
1 |
SELECT a0_.site_yolu AS site_yolu_0 FROM ayarlar a0_ WHERE a0_.dil_id = 1
Parameters:
[] |
|
0.15 ms (5.19%) |
1 |
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1 AND d0_.varsayilan = 1
Parameters:
[] |
|
0.14 ms (4.81%) |
1 |
SELECT a0_.site_adi AS site_adi_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\User | No errors. |
| App\Entity\Sayfa | No errors. |
| App\Entity\Modul | No errors. |
| App\Entity\Dil | No errors. |
| App\Entity\Kategori | No errors. |
| App\Entity\FormKayit | No errors. |
| App\Entity\Bildirim | No errors. |
| App\Entity\Ayarlar | No errors. |