Query Metrics

41 Database Queries
24 Different statements
57,45 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 11,71 ms
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
]
2 1,54 ms
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:
[]
3 2,37 ms
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:
[]
4 6,99 ms
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"
]
5 2,87 ms
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"
]
6 1,04 ms
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
]
7 1,01 ms
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
]
8 2,17 ms
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
]
9 0,78 ms
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
]
10 1,08 ms
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
]
11 1,00 ms
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
]
12 0,71 ms
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
]
13 0,68 ms
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
]
14 0,59 ms
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
]
15 0,98 ms
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
]
16 2,51 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
17 0,43 ms
SELECT DATABASE()
Parameters:
[]
18 2,08 ms
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
]
19 2,66 ms
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
]
20 0,71 ms
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
]
21 0,61 ms
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:
[
  2
]
22 0,56 ms
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:
[
  3
]
23 0,54 ms
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:
[
  4
]
24 0,62 ms
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
]
25 0,59 ms
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:
[
  36
]
26 0,57 ms
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:
[
  38
]
27 0,58 ms
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:
[
  39
]
28 0,48 ms
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:
[
  2
]
29 0,59 ms
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:
[
  2
]
30 0,46 ms
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:
[
  3
]
31 0,56 ms
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:
[
  3
]
32 0,63 ms
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
]
33 0,70 ms
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
]
34 0,54 ms
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
]
35 0,57 ms
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
]
36 0,56 ms
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
]
37 0,70 ms
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:
[]
38 1,24 ms
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:
[]
39 1,11 ms
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
]
40 0,73 ms
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
]
41 0,62 ms
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:
[
  2
]

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.