Query Metrics
13
Database Queries
13
Different statements
3.08 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.68 ms (22.08%) |
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:
[
3
]
|
|
0.38 ms (12.24%) |
1 |
SELECT k0_.id AS id_0, k0_.dilgrup AS dilgrup_1, k0_.seourl AS seourl_2, k0_.title AS title_3, k0_.description AS description_4, k0_.keywords AS keywords_5, k0_.ustid AS ustid_6 FROM kategori k0_ WHERE k0_.dilgrup = 2
Parameters:
[] |
|
0.23 ms (7.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 = 0 AND d1_.id = 17 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.23 ms (7.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 = 0 AND d1_.id = 1 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.22 ms (7.25%) |
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 = 0 AND d1_.id = 50 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.21 ms (6.75%) |
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 = 0 AND d1_.id = 25 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.19 ms (6.27%) |
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 = 0 AND d1_.id = 4 GROUP BY k0_.dilgrup ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.18 ms (5.95%) |
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.17 ms (5.46%) |
1 |
SELECT s0_.dilgrup AS dilgrup_0 FROM sayfa s0_ INNER JOIN dil d1_ ON s0_.dil_id = d1_.id WHERE s0_.id = 26 GROUP BY s0_.dil_id
Parameters:
[] |
|
0.16 ms (5.06%) |
1 |
SELECT a0_.site_yolu AS site_yolu_0 FROM ayarlar a0_ WHERE a0_.dil_id = 17
Parameters:
[] |
|
0.15 ms (4.80%) |
1 |
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1 AND d0_.varsayilan = 1
Parameters:
[] |
|
0.15 ms (4.72%) |
1 |
SELECT s0_.seo AS seo_0 FROM sayfa s0_ WHERE s0_.dilgrup = 3 ORDER BY s0_.dil_id ASC
Parameters:
[] |
|
0.14 ms (4.61%) |
1 |
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\User | No errors. |
| App\Entity\Kategori | No errors. |
| App\Entity\Dil | No errors. |
| App\Entity\Sayfa | No errors. |
| App\Entity\Ayarlar | No errors. |