Query Metrics
31
Database Queries
18
Different statements
33,30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
9,26 ms (27,80%) |
1 |
SELECT b0_.id AS id_0, b0_.create_date AS create_date_1, b0_.update_date AS update_date_2, b0_.remove_date AS remove_date_3, b0_.del AS del_4, b0_.code AS code_5, b0_.sira AS sira_6, b0_.create_user_id AS create_user_id_7, b0_.update_user_id AS update_user_id_8, b0_.remove_user_id AS remove_user_id_9 FROM blog b0_ LEFT JOIN blog_dil b1_ ON b0_.id = b1_.blog_id LEFT JOIN blog_resim b2_ ON b0_.id = b2_.blog_id LEFT JOIN blog_bolum b3_ ON b0_.id = b3_.blog_id WHERE b0_.del = 0
Parameters:
[] |
|
5,37 ms (16,14%) |
2 |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.update_date AS update_date_3, t0.remove_date AS remove_date_4, t0.del AS del_5, t0.code AS code_6, t0.sira AS sira_7, t0.blog_id AS blog_id_8, t0.create_user_id AS create_user_id_9, t0.update_user_id AS update_user_id_10, t0.remove_user_id AS remove_user_id_11 FROM blog_bolum t0 WHERE t0.blog_id = ?
Parameters:
[
1
]
|
|
2,46 ms (7,38%) |
1 |
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[] |
|
2,10 ms (6,31%) |
4 |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.update_date AS update_date_3, t0.remove_date AS remove_date_4, t0.del AS del_5, t0.code AS code_6, t0.title AS title_7, t0.link AS link_8, t0.description AS description_9, t0.baslik AS baslik_10, t0.goster AS goster_11, t0.goster_footer AS goster_footer_12, t0.urunkategorileri_id AS urunkategorileri_id_13, t0.dil_id AS dil_id_14, t0.create_user_id AS create_user_id_15, t0.update_user_id AS update_user_id_16, t0.remove_user_id AS remove_user_id_17 FROM urun_kategorileri_dil t0 WHERE t0.urunkategorileri_id = ?
Parameters:
[
37
]
|
|
1,94 ms (5,82%) |
4 |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.update_date AS update_date_3, t0.remove_date AS remove_date_4, t0.baslik AS baslik_5, t0.metin AS metin_6, t0.goster_footer AS goster_footer_7, t0.uretimler_bolum_id AS uretimler_bolum_id_8, t0.dil_id AS dil_id_9, t0.create_user_id AS create_user_id_10, t0.update_user_id AS update_user_id_11, t0.remove_user_id AS remove_user_id_12 FROM uretimler_bolum_dil t0 WHERE t0.uretimler_bolum_id = ?
Parameters:
[
1
]
|
|
1,60 ms (4,80%) |
3 |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.update_date AS update_date_3, t0.remove_date AS remove_date_4, t0.del AS del_5, t0.code AS code_6, t0.baslik AS baslik_7, t0.email AS email_8, t0.adres AS adres_9, t0.harita AS harita_10, t0.create_user_id AS create_user_id_11, t0.update_user_id AS update_user_id_12, t0.remove_user_id AS remove_user_id_13 FROM adres t0 WHERE t0.del = ?
Parameters:
[
0
]
|
|
1,42 ms (4,26%) |
2 |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.update_date AS update_date_3, t0.remove_date AS remove_date_4, t0.del AS del_5, t0.code AS code_6, t0.sira AS sira_7, t0.resim AS resim_8, t0.blog_id AS blog_id_9, t0.create_user_id AS create_user_id_10, t0.update_user_id AS update_user_id_11, t0.remove_user_id AS remove_user_id_12 FROM blog_resim t0 WHERE t0.blog_id = ?
Parameters:
[
1
]
|
|
1,25 ms (3,74%) |
2 |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.update_date AS update_date_3, t0.remove_date AS remove_date_4, t0.del AS del_5, t0.code AS code_6, t0.tip AS tip_7, t0.link AS link_8, t0.create_user_id AS create_user_id_9, t0.update_user_id AS update_user_id_10, t0.remove_user_id AS remove_user_id_11 FROM sosyal_medya t0 WHERE t0.del = ?
Parameters:
[
0
]
|
|
1,19 ms (3,57%) |
2 |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.update_date AS update_date_3, t0.remove_date AS remove_date_4, t0.del AS del_5, t0.code AS code_6, t0.title AS title_7, t0.link AS link_8, t0.description AS description_9, t0.baslik AS baslik_10, t0.goster_footer AS goster_footer_11, t0.blog_id AS blog_id_12, t0.dil_id AS dil_id_13, t0.create_user_id AS create_user_id_14, t0.update_user_id AS update_user_id_15, t0.remove_user_id AS remove_user_id_16 FROM blog_dil t0 WHERE t0.blog_id = ?
Parameters:
[
1
]
|
|
1,16 ms (3,49%) |
2 |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.update_date AS update_date_3, t0.remove_date AS remove_date_4, t0.del AS del_5, t0.code AS code_6, t0.sira AS sira_7, t0.create_user_id AS create_user_id_8, t0.update_user_id AS update_user_id_9, t0.remove_user_id AS remove_user_id_10 FROM urun_kategorileri t0 WHERE t0.del = ? ORDER BY t0.sira ASC
Parameters:
[
0
]
|
|
0,86 ms (2,59%) |
1 |
SELECT s0_.id AS id_0, s0_.create_date AS create_date_1, s0_.update_date AS update_date_2, s0_.remove_date AS remove_date_3, s0_.del AS del_4, s0_.code AS code_5, s0_.sira AS sira_6, s0_.banner AS banner_7, s0_.create_user_id AS create_user_id_8, s0_.update_user_id AS update_user_id_9, s0_.remove_user_id AS remove_user_id_10 FROM sayfa_baslik s0_ INNER JOIN sayfa_baslik_dil s1_ ON s0_.id = s1_.sayfabaslik_id WHERE s0_.del = 0
Parameters:
[] |
|
0,86 ms (2,58%) |
1 |
SELECT u0_.id AS id_0, u0_.create_date AS create_date_1, u0_.update_date AS update_date_2, u0_.remove_date AS remove_date_3, u0_.del AS del_4, u0_.code AS code_5, u0_.sira AS sira_6, u0_.uretimler_id AS uretimler_id_7, u0_.create_user_id AS create_user_id_8, u0_.update_user_id AS update_user_id_9, u0_.remove_user_id AS remove_user_id_10 FROM uretimler_bolum u0_ INNER JOIN uretimler_bolum_dil u1_ ON u0_.id = u1_.uretimler_bolum_id WHERE u1_.goster_footer = 1
Parameters:
[] |
|
0,83 ms (2,50%) |
1 |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.update_date AS update_date_3, t0.remove_date AS remove_date_4, t0.del AS del_5, t0.code AS code_6, t0.sira AS sira_7, t0.baslik AS baslik_8, t0.kisa_baslik AS kisa_baslik_9, t0.create_user_id AS create_user_id_10, t0.update_user_id AS update_user_id_11, t0.remove_user_id AS remove_user_id_12 FROM dil t0 WHERE t0.del = ?
Parameters:
[
0
]
|
|
0,74 ms (2,21%) |
1 |
SELECT t0.id AS id_1, t0.update_date AS update_date_2, t0.del AS del_3, t0.analyticskodu AS analyticskodu_4, t0.favicon AS favicon_5, t0.referans AS referans_6, t0.video AS video_7, t0.update_user_id AS update_user_id_8 FROM ayarlar t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0,72 ms (2,15%) |
1 |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.update_date AS update_date_3, t0.remove_date AS remove_date_4, t0.del AS del_5, t0.code AS code_6, t0.title AS title_7, t0.link AS link_8, t0.description AS description_9, t0.baslik AS baslik_10, t0.goster AS goster_11, t0.goster_footer AS goster_footer_12, t0.urunkategorileri_id AS urunkategorileri_id_13, t0.dil_id AS dil_id_14, t0.create_user_id AS create_user_id_15, t0.update_user_id AS update_user_id_16, t0.remove_user_id AS remove_user_id_17 FROM urun_kategorileri_dil t0 WHERE t0.goster_footer = ?
Parameters:
[
1
]
|
|
0,61 ms (1,83%) |
1 |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.update_date AS update_date_3, t0.remove_date AS remove_date_4, t0.del AS del_5, t0.code AS code_6, t0.telefon AS telefon_7, t0.icon AS icon_8, t0.create_user_id AS create_user_id_9, t0.update_user_id AS update_user_id_10, t0.remove_user_id AS remove_user_id_11, t0.adres_id AS adres_id_12 FROM adres_telefon t0 WHERE t0.adres_id = ?
Parameters:
[
1
]
|
|
0,52 ms (1,56%) |
1 |
SELECT b0_.id AS id_0, b0_.create_date AS create_date_1, b0_.update_date AS update_date_2, b0_.remove_date AS remove_date_3, b0_.del AS del_4, b0_.code AS code_5, b0_.sira AS sira_6, b0_.create_user_id AS create_user_id_7, b0_.update_user_id AS update_user_id_8, b0_.remove_user_id AS remove_user_id_9 FROM blog b0_ INNER JOIN blog_dil b1_ ON b0_.id = b1_.blog_id WHERE b1_.goster_footer = 1
Parameters:
[] |
|
0,42 ms (1,26%) |
1 |
SELECT DATABASE()
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Blog | No errors. |
| App\Entity\BlogDil | No errors. |
| App\Entity\BlogResim | No errors. |
| App\Entity\BlogBolum | No errors. |
| App\Entity\User | No errors. |
| App\Entity\SayfaBaslik | No errors. |
| App\Entity\SayfaBaslikDil | No errors. |
| App\Entity\Ayarlar | No errors. |
| App\Entity\Dil | No errors. |
| App\Entity\Adres | No errors. |
| App\Entity\AdresTelefon | No errors. |
| App\Entity\UrunKategorileri | No errors. |
| App\Entity\UrunKategorileriDil | No errors. |
| App\Entity\UrunKategoriResim | No errors. |
| App\Entity\UrunGruplari | No errors. |
| App\Entity\SosyalMedya | No errors. |
| App\Entity\BlogBolumDil | No errors. |
| App\Entity\BlogBolumResim | No errors. |
| App\Entity\LogRecords | No errors. |
| App\Entity\TinyPng | No errors. |
| App\Entity\UrunGruplariDil | No errors. |
| App\Entity\UrunGruplariUrunler | No errors. |
| App\Entity\UretimlerBolum | No errors. |
| App\Entity\UretimlerBolumDil | No errors. |
| App\Entity\Uretimler | No errors. |
| App\Entity\UretimlerBolumResim | No errors. |
| App\Entity\LogActions | No errors. |
| App\Entity\UrunGruplariUrunlerDil | No errors. |
| App\Entity\UrunGruplariUrunlerResim | No errors. |
| App\Entity\UretimlerDil | No errors. |