Query Metrics
41
Database Queries
24
Different statements
57,45 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
11,71 ms (20,38%) |
1 |
SELECT t0.id AS id_1, t0.baslik AS baslik_2, t0.create_date AS create_date_3, t0.update_date AS update_date_4, t0.remove_date AS remove_date_5, t0.del AS del_6, t0.sira AS sira_7, t0.code AS code_8, t0.dil_id AS dil_id_9, t0.slider_id AS slider_id_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 slider_dil t0 WHERE t0.del = ?
Parameters:
[
0
]
|
6,99 ms (12,17%) |
1 |
SELECT a0_.title AS title_0, a0_.description AS description_1 FROM anasayfa_dil a0_ INNER JOIN dil d1_ ON a0_.dil_id = d1_.id WHERE d1_.kisa_baslik = ?
Parameters:
[
"en"
]
|
3,81 ms (6,63%) |
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.resim AS resim_7, t0.sira AS sira_8, t0.anasayfa_bolum_id AS anasayfa_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 anasayfa_bolum_resim t0 WHERE t0.anasayfa_bolum_id = ?
Parameters:
[
1
]
|
3,02 ms (5,26%) |
3 |
SELECT t0.id AS id_1, t0.update_date AS update_date_2, t0.code AS code_3, t0.anasayfa_id AS anasayfa_id_4, t0.update_user_id AS update_user_id_5 FROM anasayfa_bolum t0 WHERE t0.id = ?
Parameters:
[
1
]
|
2,88 ms (5,02%) |
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.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
]
|
2,87 ms (4,99%) |
1 |
SELECT a0_.id AS id_0, a0_.update_date AS update_date_1, a0_.baslik AS baslik_2, a0_.alt_baslik AS alt_baslik_3, a0_.metin AS metin_4, a0_.anasayfa_bolum_id AS anasayfa_bolum_id_5, a0_.dil_id AS dil_id_6, a0_.update_user_id AS update_user_id_7 FROM anasayfa_bolum_dil a0_ INNER JOIN dil d1_ ON a0_.dil_id = d1_.id WHERE d1_.kisa_baslik = ?
Parameters:
[
"en"
]
|
2,51 ms (4,36%) |
1 |
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[] |
2,42 ms (4,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.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,37 ms (4,13%) |
1 |
SELECT s0_.sira AS sira_0, s1_.baslik AS baslik_1, s0_.resim AS resim_2 FROM slider_dil s1_ INNER JOIN slider s0_ ON s1_.slider_id = s0_.id WHERE s1_.del = 0 ORDER BY s0_.sira ASC
Parameters:
[] |
2,36 ms (4,11%) |
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,17 ms (3,77%) |
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.urunkategorileri_id AS urunkategorileri_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_kategori_resim t0 WHERE t0.del = ? ORDER BY t0.sira ASC
Parameters:
[
0
]
|
2,16 ms (3,76%) |
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.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,67 ms (2,91%) |
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,54 ms (2,69%) |
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_ LEFT JOIN uretimler_bolum_dil u1_ ON u0_.id = u1_.uretimler_bolum_id WHERE u0_.del = 0
Parameters:
[] |
1,36 ms (2,36%) |
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,24 ms (2,15%) |
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,11 ms (1,94%) |
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,08 ms (1,87%) |
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 = ?
Parameters:
[
1
]
|
1,00 ms (1,74%) |
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,78 ms (1,36%) |
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.urunkategorileri_id AS urunkategorileri_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_kategori_resim t0 WHERE t0.del = ? ORDER BY t0.sira DESC
Parameters:
[
0
]
|
0,71 ms (1,24%) |
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,70 ms (1,23%) |
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,56 ms (0,98%) |
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,43 ms (0,75%) |
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\Slider | No errors. |
App\Entity\SliderDil | No errors. |
App\Entity\Dil | No errors. |
App\Entity\User | No errors. |
App\Entity\UretimlerBolum | No errors. |
App\Entity\UretimlerBolumDil | No errors. |
App\Entity\Uretimler | No errors. |
App\Entity\UretimlerBolumResim | No errors. |
App\Entity\AnasayfaDil | No errors. |
App\Entity\AnasayfaBolumDil | No errors. |
App\Entity\AnasayfaBolum | 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\Ayarlar | No errors. |
App\Entity\SosyalMedya | No errors. |
App\Entity\LogRecords | No errors. |
App\Entity\TinyPng | No errors. |
App\Entity\UretimlerDil | No errors. |
App\Entity\Anasayfa | No errors. |
App\Entity\AnasayfaBolumResim | No errors. |
App\Entity\UrunGruplariDil | No errors. |
App\Entity\UrunGruplariUrunler | No errors. |
App\Entity\Blog | No errors. |
App\Entity\BlogDil | No errors. |
App\Entity\BlogBolum | No errors. |
App\Entity\BlogResim | No errors. |