Query Metrics
141
Database Queries
22
Different statements
94,56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
33,32 ms (35,24%) |
52 |
SELECT t0.id AS id_1, t0.update_date AS update_date_2, t0.del AS del_3, t0.code AS code_4, t0.baslik AS baslik_5, t0.link AS link_6, t0.baslik2 AS baslik2_7, t0.boyut AS boyut_8, t0.agirlik AS agirlik_9, t0.renk_kod1 AS renk_kod1_10, t0.renk_ad1 AS renk_ad1_11, t0.renk_kod2 AS renk_kod2_12, t0.renk_ad2 AS renk_ad2_13, t0.renk_kod3 AS renk_kod3_14, t0.renk_ad3 AS renk_ad3_15, t0.renk_kod4 AS renk_kod4_16, t0.renk_ad4 AS renk_ad4_17, t0.renk_kod5 AS renk_kod5_18, t0.renk_ad5 AS renk_ad5_19, t0.renk_kod6 AS renk_kod6_20, t0.renk_ad6 AS renk_ad6_21, t0.materyal AS materyal_22, t0.metin AS metin_23, t0.urungruplari_urunler_id AS urungruplari_urunler_id_24, t0.dil_id AS dil_id_25, t0.update_user_id AS update_user_id_26 FROM urun_gruplari_urunler_dil t0 WHERE t0.urungruplari_urunler_id = ?
Parameters:
[
204
]
|
|
29,48 ms (31,18%) |
52 |
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.urungruplari_urunler_id AS urungruplari_urunler_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 urun_gruplari_urunler_resim t0 WHERE t0.urungruplari_urunler_id = ?
Parameters:
[
204
]
|
|
2,47 ms (2,61%) |
1 |
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[] |
|
2,42 ms (2,55%) |
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,38 ms (2,52%) |
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.sira AS sira_7, t0.urungruplari_id AS urungruplari_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 urun_gruplari_urunler t0 WHERE t0.urungruplari_id = ?
Parameters:
[
25
]
|
|
2,35 ms (2,49%) |
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
]
|
|
2,19 ms (2,32%) |
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_.urungruplari_id AS urungruplari_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 urun_gruplari_urunler u0_ INNER JOIN urun_gruplari_urunler_dil u1_ ON u0_.id = u1_.urungruplari_urunler_id WHERE u0_.del = 0 ORDER BY u1_.baslik ASC
Parameters:
[] |
|
2,13 ms (2,26%) |
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
Parameters:
[] |
|
2,09 ms (2,21%) |
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.sira AS sira_7, t0.banner AS banner_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.urunkategorileri_id AS urunkategorileri_id_12 FROM urun_gruplari t0 WHERE t0.urunkategorileri_id = ?
Parameters:
[
37
]
|
|
1,89 ms (2,00%) |
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,81 ms (1,91%) |
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_.create_user_id AS create_user_id_7, u0_.update_user_id AS update_user_id_8, u0_.remove_user_id AS remove_user_id_9 FROM urun_kategorileri u0_ INNER JOIN urun_kategorileri_dil u1_ ON u0_.id = u1_.urunkategorileri_id INNER JOIN urun_gruplari u2_ ON u0_.id = u2_.urunkategorileri_id WHERE u0_.del = 0 AND u1_.del = 0 AND u2_.del = 0
Parameters:
[] |
|
1,57 ms (1,66%) |
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,52 ms (1,61%) |
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:
[] |
|
1,42 ms (1,50%) |
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:
[] |
|
1,29 ms (1,36%) |
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:
[] |
|
1,23 ms (1,30%) |
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,15 ms (1,21%) |
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
]
|
|
1,07 ms (1,13%) |
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
]
|
|
1,02 ms (1,08%) |
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,72 ms (0,76%) |
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.baslik AS baslik_7, t0.title AS title_8, t0.sayfa AS sayfa_9, t0.sayfabaslik_id AS sayfabaslik_id_10, t0.dil_id AS dil_id_11, t0.create_user_id AS create_user_id_12, t0.update_user_id AS update_user_id_13, t0.remove_user_id AS remove_user_id_14 FROM sayfa_baslik_dil t0 WHERE t0.sayfabaslik_id = ?
Parameters:
[
1
]
|
|
0,60 ms (0,64%) |
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,45 ms (0,48%) |
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\Ayarlar | No errors. |
| App\Entity\User | No errors. |
| App\Entity\UrunGruplariUrunler | No errors. |
| App\Entity\SayfaBaslik | No errors. |
| App\Entity\SayfaBaslikDil | No errors. |
| App\Entity\UrunGruplariUrunlerDil | No errors. |
| App\Entity\UrunGruplari | No errors. |
| App\Entity\UrunGruplariUrunlerResim | No errors. |
| App\Entity\UrunKategorileri | No errors. |
| App\Entity\UrunKategorileriDil | No errors. |
| App\Entity\UrunKategoriResim | No errors. |
| App\Entity\Dil | No errors. |
| App\Entity\Adres | No errors. |
| App\Entity\AdresTelefon | No errors. |
| App\Entity\SosyalMedya | No errors. |
| App\Entity\LogRecords | No errors. |
| App\Entity\TinyPng | No errors. |
| App\Entity\UrunGruplariDil | No errors. |
| App\Entity\UretimlerBolum | No errors. |
| App\Entity\UretimlerBolumDil | No errors. |
| App\Entity\Uretimler | No errors. |
| App\Entity\UretimlerBolumResim | No errors. |
| App\Entity\Blog | No errors. |
| App\Entity\BlogDil | No errors. |
| App\Entity\BlogBolum | No errors. |
| App\Entity\BlogResim | No errors. |
| App\Entity\LogActions | No errors. |
| App\Entity\UretimlerDil | No errors. |
| App\Entity\BlogBolumDil | No errors. |
| App\Entity\BlogBolumResim | No errors. |