Query Metrics

51 Database Queries
17 Different statements
37.08 ms Query time
0 Invalid entities
28 Managed entities

Queries

Group similar statements

# Time Info
1 1.94 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.symbol AS symbol_3, t0.short_title AS short_title_4, t0.code AS code_5, t0.tcmb_code AS tcmb_code_6, t0.currency_number AS currency_number_7, t0.exchange_rate AS exchange_rate_8, t0.is_default AS is_default_9, t0.is_enabled AS is_enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM sys_currencies t0 WHERE t0.short_title IS NULL AND t0.is_enabled = ? LIMIT 1
Parameters:
[
  1
]
2 0.76 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.symbol AS symbol_3, t0.short_title AS short_title_4, t0.code AS code_5, t0.tcmb_code AS tcmb_code_6, t0.currency_number AS currency_number_7, t0.exchange_rate AS exchange_rate_8, t0.is_default AS is_default_9, t0.is_enabled AS is_enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM sys_currencies t0 WHERE t0.short_title = ? AND t0.is_enabled = ? LIMIT 1
Parameters:
[
  "USD"
  1
]
3 0.83 ms
SELECT t0.id AS id_1, t0.alias AS alias_2, t0.page_id AS page_id_3, t0.section_id AS section_id_4 FROM main_page_sections t0 WHERE t0.section_id IS NULL
Parameters:
[]
4 0.74 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.filesize AS filesize_3, t0.del AS del_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM main_product_catalogs t0 WHERE t0.del = ?
Parameters:
[
  0
]
5 0.50 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.filesize AS filesize_3, t0.del AS del_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM main_product_catalogs t0 WHERE t0.del = ?
Parameters:
[
  0
]
6 0.94 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.del AS del_5, t0.is_enabled AS is_enabled_6, t0.private AS private_7, t0.show_home AS show_home_8, t0.all_products AS all_products_9, t0.start_date AS start_date_10, t0.end_date AS end_date_11, t0.min_price AS min_price_12, t0.buy_by AS buy_by_13, t0.pay_by AS pay_by_14, t0.th_order AS th_order_15, t0.percent_discount AS percent_discount_16, t0.discount_amount AS discount_amount_17, t0.free_shipping AS free_shipping_18, t0.campaign_type_id AS campaign_type_id_19 FROM main_campaign t0 WHERE t0.del = ? AND t0.show_home = ?
Parameters:
[
  0
  1
]
7 0.79 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.position AS position_3, t0.is_enabled AS is_enabled_4, t0.del AS del_5, t0.show_home AS show_home_6, t0.image AS image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_category_id AS parent_category_id_10 FROM main_categories t0 WHERE t0.del = ? AND t0.show_home = ?
Parameters:
[
  0
  1
]
8 0.73 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.file_name AS file_name_5 FROM main_pop_up t0 ORDER BY t0.position ASC
Parameters:
[]
9 0.70 ms
SELECT t0.id AS id_1, t0.is_enabled AS is_enabled_2, t0.name AS name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM main_thema t0 WHERE t0.is_enabled = ? LIMIT 1
Parameters:
[
  1
]
10 0.63 ms
SELECT t0.id AS id_1, t0.alias AS alias_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM main_pages t0
Parameters:
[]
11 0.90 ms
SELECT t0.id AS id_1, t0.system_mail AS system_mail_2, t0.system_phone AS system_phone_3, t0.system_instagram AS system_instagram_4, t0.system_linkedin AS system_linkedin_5, t0.system_youtube AS system_youtube_6, t0.system_pinterest AS system_pinterest_7, t0.google_analystic_code AS google_analystic_code_8, t0.monthly_order_target AS monthly_order_target_9, t0.yearly_order_target AS yearly_order_target_10, t0.logo AS logo_11, t0.logo_sabit_menu AS logo_sabit_menu_12, t0.logo_footer AS logo_footer_13, t0.favicon AS favicon_14, t0.free_shipping_limit AS free_shipping_limit_15, t0.cargo_price AS cargo_price_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18 FROM main_setting_global_settings t0 WHERE t0.id = ?
Parameters:
[
  1
]
12 0.82 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_slogan AS meta_slogan_3, t0.meta_description AS meta_description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.glabal_setting_id AS glabal_setting_id_7, t0.lang_id AS lang_id_8 FROM main_setting_global_setting_langs t0 WHERE t0.glabal_setting_id = ?
Parameters:
[
  1
]
13 0.63 ms
SELECT t0.id AS id_1, t0.short_title AS short_title_2, t0.name AS name_3, t0.is_default AS is_default_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sys_langs t0 WHERE t0.id = ?
Parameters:
[
  1
]
14 0.63 ms
SELECT t0.id AS id_1, t0.short_title AS short_title_2, t0.name AS name_3, t0.is_default AS is_default_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sys_langs t0 WHERE t0.is_default = ? LIMIT 1
Parameters:
[
  1
]
15 1.36 ms
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = ? AND m1_.lang_id = ? AND m3_.id IS NULL AND m0_.is_enabled = 1 ORDER BY m0_.position ASC
Parameters:
[
  0
  1
]
16 0.68 ms
SELECT t0.id AS id_1, t0.baslama_tarihi AS baslama_tarihi_2, t0.bitis_tarihi AS bitis_tarihi_3, t0.alan_adi AS alan_adi_4, t0.tip_alias AS tip_alias_5, t0.tema_id AS tema_id_6, t0.abone_paket_id AS abone_paket_id_7 FROM firma_site_ayar t0 LIMIT 1
Parameters:
[]
17 0.64 ms
SELECT t0.id AS id_1, t0.is_enabled AS is_enabled_2, t0.name AS name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM main_thema t0 WHERE t0.is_enabled = ? LIMIT 1
Parameters:
[
  1
]
18 0.71 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.symbol AS symbol_3, t0.short_title AS short_title_4, t0.code AS code_5, t0.tcmb_code AS tcmb_code_6, t0.currency_number AS currency_number_7, t0.exchange_rate AS exchange_rate_8, t0.is_default AS is_default_9, t0.is_enabled AS is_enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM sys_currencies t0 WHERE t0.short_title IS NULL AND t0.is_enabled = ? LIMIT 1
Parameters:
[
  1
]
19 0.65 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.symbol AS symbol_3, t0.short_title AS short_title_4, t0.code AS code_5, t0.tcmb_code AS tcmb_code_6, t0.currency_number AS currency_number_7, t0.exchange_rate AS exchange_rate_8, t0.is_default AS is_default_9, t0.is_enabled AS is_enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM sys_currencies t0 WHERE t0.short_title = ? AND t0.is_enabled = ? LIMIT 1
Parameters:
[
  "USD"
  1
]
20 0.65 ms
SELECT t0.id AS id_1, t0.is_enabled AS is_enabled_2, t0.name AS name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM main_thema t0 WHERE t0.is_enabled = ? LIMIT 1
Parameters:
[
  1
]
21 0.62 ms
SELECT t0.id AS id_1, t0.short_title AS short_title_2, t0.name AS name_3, t0.is_default AS is_default_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sys_langs t0 WHERE t0.is_default = ? LIMIT 1
Parameters:
[
  1
]
22 1.10 ms
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = ? AND m1_.lang_id = ? AND m3_.id IS NULL AND m0_.is_enabled = 1 ORDER BY m0_.position ASC
Parameters:
[
  0
  1
]
23 0.55 ms
SELECT t0.id AS id_1, t0.is_enabled AS is_enabled_2, t0.name AS name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM main_thema t0 WHERE t0.is_enabled = ? LIMIT 1
Parameters:
[
  1
]
24 0.53 ms
SELECT t0.id AS id_1, t0.short_title AS short_title_2, t0.name AS name_3, t0.is_default AS is_default_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sys_langs t0 WHERE t0.is_default = ? LIMIT 1
Parameters:
[
  1
]
25 1.03 ms
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = ? AND m3_.id = ? AND m1_.lang_id = ? AND m0_.is_enabled = 1 AND m0_.parent_category_id = ? ORDER BY m0_.position ASC
Parameters:
[
  0
  45
  1
  45
]
26 0.60 ms
SELECT t0.id AS id_1, t0.short_title AS short_title_2, t0.name AS name_3, t0.is_default AS is_default_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sys_langs t0 WHERE t0.is_default = ? LIMIT 1
Parameters:
[
  1
]
27 0.77 ms
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = ? AND m3_.id = ? AND m1_.lang_id = ? AND m0_.is_enabled = 1 AND m0_.parent_category_id = ? ORDER BY m0_.position ASC
Parameters:
[
  0
  52
  1
  52
]
28 0.49 ms
SELECT t0.id AS id_1, t0.short_title AS short_title_2, t0.name AS name_3, t0.is_default AS is_default_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sys_langs t0 WHERE t0.is_default = ? LIMIT 1
Parameters:
[
  1
]
29 0.80 ms
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = ? AND m3_.id = ? AND m1_.lang_id = ? AND m0_.is_enabled = 1 AND m0_.parent_category_id = ? ORDER BY m0_.position ASC
Parameters:
[
  0
  53
  1
  53
]
30 0.51 ms
SELECT t0.id AS id_1, t0.short_title AS short_title_2, t0.name AS name_3, t0.is_default AS is_default_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sys_langs t0 WHERE t0.is_default = ? LIMIT 1
Parameters:
[
  1
]
31 0.80 ms
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = ? AND m3_.id = ? AND m1_.lang_id = ? AND m0_.is_enabled = 1 AND m0_.parent_category_id = ? ORDER BY m0_.position ASC
Parameters:
[
  0
  55
  1
  55
]
32 0.48 ms
SELECT t0.id AS id_1, t0.short_title AS short_title_2, t0.name AS name_3, t0.is_default AS is_default_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sys_langs t0 WHERE t0.is_default = ? LIMIT 1
Parameters:
[
  1
]
33 0.90 ms
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = ? AND m3_.id = ? AND m1_.lang_id = ? AND m0_.is_enabled = 1 AND m0_.parent_category_id = ? ORDER BY m0_.position ASC
Parameters:
[
  0
  54
  1
  54
]
34 0.51 ms
SELECT t0.id AS id_1, t0.short_title AS short_title_2, t0.name AS name_3, t0.is_default AS is_default_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sys_langs t0 WHERE t0.is_default = ? LIMIT 1
Parameters:
[
  1
]
35 0.76 ms
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = ? AND m3_.id = ? AND m1_.lang_id = ? AND m0_.is_enabled = 1 AND m0_.parent_category_id = ? ORDER BY m0_.position ASC
Parameters:
[
  0
  46
  1
  46
]
36 0.48 ms
SELECT t0.id AS id_1, t0.short_title AS short_title_2, t0.name AS name_3, t0.is_default AS is_default_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sys_langs t0 WHERE t0.is_default = ? LIMIT 1
Parameters:
[
  1
]
37 0.77 ms
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = ? AND m3_.id = ? AND m1_.lang_id = ? AND m0_.is_enabled = 1 AND m0_.parent_category_id = ? ORDER BY m0_.position ASC
Parameters:
[
  0
  47
  1
  47
]
38 0.55 ms
SELECT t0.id AS id_1, t0.short_title AS short_title_2, t0.name AS name_3, t0.is_default AS is_default_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sys_langs t0 WHERE t0.is_default = ? LIMIT 1
Parameters:
[
  1
]
39 0.80 ms
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = ? AND m3_.id = ? AND m1_.lang_id = ? AND m0_.is_enabled = 1 AND m0_.parent_category_id = ? ORDER BY m0_.position ASC
Parameters:
[
  0
  48
  1
  48
]
40 0.47 ms
SELECT t0.id AS id_1, t0.short_title AS short_title_2, t0.name AS name_3, t0.is_default AS is_default_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sys_langs t0 WHERE t0.is_default = ? LIMIT 1
Parameters:
[
  1
]
41 0.72 ms
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = ? AND m3_.id = ? AND m1_.lang_id = ? AND m0_.is_enabled = 1 AND m0_.parent_category_id = ? ORDER BY m0_.position ASC
Parameters:
[
  0
  49
  1
  49
]
42 0.49 ms
SELECT t0.id AS id_1, t0.short_title AS short_title_2, t0.name AS name_3, t0.is_default AS is_default_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sys_langs t0 WHERE t0.is_default = ? LIMIT 1
Parameters:
[
  1
]
43 0.74 ms
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = ? AND m3_.id = ? AND m1_.lang_id = ? AND m0_.is_enabled = 1 AND m0_.parent_category_id = ? ORDER BY m0_.position ASC
Parameters:
[
  0
  50
  1
  50
]
44 0.47 ms
SELECT t0.id AS id_1, t0.short_title AS short_title_2, t0.name AS name_3, t0.is_default AS is_default_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sys_langs t0 WHERE t0.is_default = ? LIMIT 1
Parameters:
[
  1
]
45 0.71 ms
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = ? AND m3_.id = ? AND m1_.lang_id = ? AND m0_.is_enabled = 1 AND m0_.parent_category_id = ? ORDER BY m0_.position ASC
Parameters:
[
  0
  51
  1
  51
]
46 0.49 ms
SELECT t0.id AS id_1, t0.short_title AS short_title_2, t0.name AS name_3, t0.is_default AS is_default_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sys_langs t0 WHERE t0.is_default = ? LIMIT 1
Parameters:
[
  1
]
47 0.92 ms
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = ? AND m1_.lang_id = ? AND m3_.id IS NULL AND m0_.is_enabled = 1 ORDER BY m0_.position ASC
Parameters:
[
  0
  1
]
48 0.49 ms
SELECT t0.id AS id_1, t0.short_title AS short_title_2, t0.name AS name_3, t0.is_default AS is_default_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sys_langs t0 WHERE t0.is_default = ? LIMIT 1
Parameters:
[
  1
]
49 0.91 ms
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = ? AND m3_.id = ? AND m1_.lang_id = ? AND m0_.parent_category_id = ? ORDER BY m0_.position ASC
Parameters:
[
  0
  45
  1
  45
]
50 0.50 ms
SELECT t0.id AS id_1, t0.short_title AS short_title_2, t0.name AS name_3, t0.is_default AS is_default_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sys_langs t0 WHERE t0.is_default = ? LIMIT 1
Parameters:
[
  1
]
51 0.90 ms
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = ? AND m3_.id = ? AND m1_.lang_id = ? AND m0_.parent_category_id = ? ORDER BY m0_.position ASC
Parameters:
[
  0
  54
  1
  54
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Main\Product\Category 10
App\Entity\Main\Page\Page 8
App\Entity\Main\Page\PageSection 4
App\Entity\Main\PopUp\PopUp 1
App\Entity\Main\Thema\Thema 1
App\Entity\Main\Setting\GlobalSetting 1
App\Entity\Main\Setting\GlobalSettingLang 1
App\Entity\System\Lang 1
App\Entity\FirmaSiteAyar 1

Entities Mapping

Class Mapping errors
App\Entity\System\Currency No errors.
App\Entity\Main\Page\PageSection No errors.
App\Entity\Main\Page\Page No errors.
App\Entity\Main\Page\PageSectionLang No errors.
App\Entity\Main\Page\PageSectionImage No errors.
App\Entity\Main\Product\ProductCatalog No errors.
App\Entity\Main\Campaign\Campaign No errors.
App\Entity\Main\Campaign\CampaignType No errors.
App\Entity\Main\Product\Category No errors.
App\Entity\Main\Product\CategoryImages No errors.
App\Entity\Main\Product\CategoryLang No errors.
App\Entity\Main\Product\Product No errors.
App\Entity\Main\Product\ProductOtherCategory No errors.
App\Entity\Main\Tax\TaxRateCategory No errors.
App\Entity\Main\PopUp\PopUp No errors.
App\Entity\Main\PopUp\PopUpLang No errors.
App\Entity\Main\Thema\Thema No errors.
App\Entity\Main\Page\PageLang No errors.
App\Entity\Main\Setting\GlobalSetting No errors.
App\Entity\Main\Setting\GlobalSettingLang No errors.
App\Entity\System\Lang No errors.
App\Entity\Main\Banner\BannerLang No errors.
App\Entity\Main\Blog\BlogLang No errors.
App\Entity\Main\Campaign\CampaignLang No errors.
App\Entity\Main\Product\ProductLang No errors.
App\Entity\Main\Faq\FaqLang No errors.
App\Entity\Main\Product\VariantLang No errors.
App\Entity\Main\Product\VariantValueLang No errors.
App\Entity\Main\StaticText\StaticTextLang No errors.
App\Entity\Main\Video\VideoLang No errors.
App\Entity\Main\Instagram\InstagramLang No errors.
App\Entity\FirmaSiteAyar No errors.
App\Entity\Tema No errors.
App\Entity\AbonePaket No errors.