Query Metrics
30
Database Queries
19
Different statements
67,77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
7,18 ms (10,59%) |
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.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.code = ? LIMIT 1
Parameters:
[
"157506"
]
|
|
6,90 ms (10,18%) |
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_.blog_id AS blog_id_7, b0_.create_user_id AS create_user_id_8, b0_.update_user_id AS update_user_id_9, b0_.remove_user_id AS remove_user_id_10 FROM blog_bolum b0_ LEFT JOIN blog_bolum_dil b1_ ON b0_.id = b1_.blog_bolum_id LEFT JOIN blog_bolum_resim b2_ ON b0_.id = b2_.blog_bolum_id
Parameters:
[] |
|
5,83 ms (8,60%) |
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:
[] |
|
5,40 ms (7,97%) |
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:
[] |
|
4,97 ms (7,34%) |
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
]
|
|
4,82 ms (7,12%) |
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
]
|
|
4,31 ms (6,37%) |
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
]
|
|
3,42 ms (5,05%) |
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
]
|
|
3,35 ms (4,94%) |
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
]
|
|
3,34 ms (4,93%) |
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
]
|
|
3,21 ms (4,74%) |
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
]
|
|
3,00 ms (4,43%) |
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
]
|
|
2,59 ms (3,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
]
|
|
2,41 ms (3,56%) |
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
]
|
|
2,27 ms (3,34%) |
1 |
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[] |
|
1,90 ms (2,81%) |
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.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 = ? AND t0.del = ? ORDER BY t0.sira ASC
Parameters:
[ 1 0 ] |
|
1,22 ms (1,80%) |
1 |
SELECT t0.id AS id_1, t0.update_date AS update_date_2, t0.baslik AS baslik_3, t0.description AS description_4, t0.metin AS metin_5, t0.metin1 AS metin1_6, t0.metin2 AS metin2_7, t0.yontem1 AS yontem1_8, t0.yontem2 AS yontem2_9, t0.yontem_metin1 AS yontem_metin1_10, t0.yontem_metin2 AS yontem_metin2_11, t0.blog_bolum_id AS blog_bolum_id_12, t0.dil_id AS dil_id_13, t0.update_user_id AS update_user_id_14 FROM blog_bolum_dil t0 WHERE t0.blog_bolum_id = ?
Parameters:
[
1
]
|
|
1,22 ms (1,80%) |
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.resim AS resim_8, t0.blog_bolum_id AS blog_bolum_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_bolum_resim t0 WHERE t0.blog_bolum_id = ?
Parameters:
[
1
]
|
|
0,42 ms (0,63%) |
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\BlogBolum | No errors. |
| App\Entity\Blog | No errors. |
| App\Entity\User | No errors. |
| App\Entity\BlogBolumDil | No errors. |
| App\Entity\BlogBolumResim | 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\BlogDil | No errors. |
| App\Entity\BlogResim | 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. |