Query Metrics
6
Database Queries
6
Different statements
2.80 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.94 ms (33.70%) |
1 |
SELECT k0_.dilgrup AS dilgrup_0, k0_.adi AS adi_1, k0_.seourl AS seourl_2, k0_.title AS title_3, k0_.keywords AS keywords_4, k0_.description AS description_5, k0_.ustid AS ustid_6, k0_.resim AS resim_7, s1_.dilgrup AS dilgrup_8, k0_.id AS id_9 FROM kategori k0_ INNER JOIN sayfa s1_ ON k0_.sayfa_id = s1_.id INNER JOIN dil d2_ ON k0_.dil_id = d2_.id WHERE k0_.seourl = 'nitrobion' AND d2_.id = 1 ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.79 ms (28.34%) |
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_.metin AS metin_5, h0_.resimler AS resimler_6, h0_.dilgrup AS dilgrup_7, k1_.dilgrup AS dilgrup_8, d2_.id AS id_9, s3_.dilgrup AS dilgrup_10 FROM hizmetler h0_ LEFT JOIN kategori k1_ ON h0_.kategori_id = k1_.id INNER JOIN sayfa s3_ ON h0_.sayfa_id = s3_.id INNER JOIN dil d2_ ON h0_.dil_id = d2_.id WHERE k1_.id = 5 AND h0_.seourl = 'nitrobion' AND d2_.id = 1 ORDER BY h0_.sira ASC, h0_.id DESC
Parameters:
[] |
|
0.38 ms (13.40%) |
1 |
SELECT s0_.id AS id_0, s0_.adi AS adi_1, s0_.banner_durum AS banner_durum_2, s0_.banner_url AS banner_url_3, s0_.title AS title_4, s0_.keywords AS keywords_5, s0_.description AS description_6, s0_.dilgrup AS dilgrup_7, s0_.seo AS seo_8, s0_.kategori AS kategori_9, s0_.tek_veri AS tek_veri_10, s0_.ic_icerik AS ic_icerik_11, m1_.tablo_adi AS tablo_adi_12, m1_.alan AS alan_13, s0_.description AS description_14, m1_.adi AS adi_15 FROM sayfa s0_ INNER JOIN dil d2_ ON s0_.dil_id = d2_.id INNER JOIN modul m1_ ON s0_.modul_id = m1_.id WHERE s0_.seo = 'urunler' AND d2_.id = 1 ORDER BY s0_.sira ASC
Parameters:
[] |
|
0.26 ms (9.33%) |
1 |
SELECT k0_.dilgrup AS dilgrup_0, k0_.adi AS adi_1, k0_.seourl AS seourl_2, k0_.title AS title_3, k0_.keywords AS keywords_4, k0_.description AS description_5, k0_.ustid AS ustid_6, k0_.resim AS resim_7, s1_.dilgrup AS dilgrup_8, k0_.id AS id_9 FROM kategori k0_ INNER JOIN sayfa s1_ ON k0_.sayfa_id = s1_.id INNER JOIN dil d2_ ON k0_.dil_id = d2_.id WHERE k0_.seourl = 'makro-element-icerikli-yaprak-gubreleri' AND d2_.id = 1 ORDER BY k0_.sira ASC
Parameters:
[] |
|
0.22 ms (7.93%) |
1 |
SELECT d0_.id AS id_0 FROM dil d0_ WHERE d0_.aktif = 1
Parameters:
[] |
|
0.20 ms (7.29%) |
1 |
SELECT d0_.id AS id_0, d0_.kisa AS kisa_1, d0_.uzun AS uzun_2 FROM dil d0_ WHERE d0_.aktif = 1 AND d0_.varsayilan = 1 ORDER BY d0_.id 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\Sayfa | No errors. |
| App\Entity\Modul | No errors. |
| App\Entity\Kategori | No errors. |
| App\Entity\Hizmetler | No errors. |