Query Metrics

50 Database Queries
16 Different statements
37.73 ms Query time
0 Invalid entities
15 Managed entities

Queries

Group similar statements

# Time Info
1 1.64 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.73 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 1.46 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.id = ?
Parameters:
[
  "56"
]
4 1.68 ms
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.position AS position_2, m0_.is_enabled AS is_enabled_3, m0_.del AS del_4, m0_.show_home AS show_home_5, m0_.image AS image_6, m0_.created_at AS created_at_7, m0_.updated_at AS updated_at_8, m0_.parent_category_id AS parent_category_id_9 FROM main_categories m0_ LEFT JOIN main_categories m1_ ON m0_.parent_category_id = m1_.id LEFT JOIN main_category_lang m2_ ON m0_.id = m2_.category_id LEFT JOIN main_category_images m3_ ON m0_.id = m3_.category_id WHERE m0_.del = 0 AND m0_.id = ? ORDER BY m0_.position ASC
Parameters:
[
  56
]
5 0.69 ms
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.position AS position_2, m0_.is_enabled AS is_enabled_3, m0_.del AS del_4, m0_.show_home AS show_home_5, m0_.image AS image_6, m0_.created_at AS created_at_7, m0_.updated_at AS updated_at_8, m0_.parent_category_id AS parent_category_id_9 FROM main_categories m0_ LEFT JOIN main_categories m1_ ON m0_.parent_category_id = m1_.id LEFT JOIN main_category_lang m2_ ON m0_.id = m2_.category_id LEFT JOIN main_category_images m3_ ON m0_.id = m3_.category_id WHERE m0_.del = 0 AND m1_.id = ? ORDER BY m0_.position ASC
Parameters:
[
  56
]
6 3.55 ms
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.sira AS sira_2, m0_.barcode AS barcode_3, m0_.product_code AS product_code_4, m0_.is_enabled AS is_enabled_5, m0_.del AS del_6, m0_.new_product AS new_product_7, m0_.show_home AS show_home_8, m0_.is_variant AS is_variant_9, m0_.avarage_rating AS avarage_rating_10, m0_.total_visited AS total_visited_11, m0_.position AS position_12, m0_.total_sales AS total_sales_13, m0_.audio_file AS audio_file_14, m0_.uuid AS uuid_15, m0_.length AS length_16, m0_.depth AS depth_17, m0_.height AS height_18, m0_.weight AS weight_19, m0_.product_material AS product_material_20, m0_.product_color AS product_color_21, m0_.product_suggestion AS product_suggestion_22, m0_.product_paint_type AS product_paint_type_23, m0_.delivery_time AS delivery_time_24, m0_.created_at AS created_at_25, m0_.updated_at AS updated_at_26, m0_.is_jewel_price AS is_jewel_price_27, m0_.brand_id AS brand_id_28, m0_.main_category_id AS main_category_id_29, m0_.blog_id AS blog_id_30 FROM main_products m0_ LEFT JOIN main_product_lang m1_ ON m0_.id = m1_.product_id LEFT JOIN sys_langs s2_ ON m1_.lang_id = s2_.id LEFT JOIN main_categories m3_ ON m0_.main_category_id = m3_.id LEFT JOIN main_product_other_categories m4_ ON m0_.id = m4_.product_id LEFT JOIN main_categories m5_ ON m4_.category_id = m5_.id LEFT JOIN main_product_pricing m6_ ON m0_.id = m6_.product_id LEFT JOIN main_product_variants m7_ ON m6_.product_variant_id = m7_.id WHERE m6_.id > 0 AND s2_.id = ? AND ((m3_.id IN (?) OR m5_.id IN (?))) AND m0_.is_enabled = 1 AND m0_.del = 0 AND ((m3_.id IN (?) OR m5_.id IN (?))) GROUP BY m0_.id, m1_.id, m6_.id, m4_.id ORDER BY MIN(m6_.sales_price) DESC
Parameters:
[
  1
  56
  56
  56
  56
]
7 1.87 ms
SELECT MIN(m0_.sales_price) AS sclr_0, MAX(m0_.sales_price) AS sclr_1, m1_.id AS id_2, m1_.code AS code_3, m1_.sira AS sira_4, m1_.barcode AS barcode_5, m1_.product_code AS product_code_6, m1_.is_enabled AS is_enabled_7, m1_.del AS del_8, m1_.new_product AS new_product_9, m1_.show_home AS show_home_10, m1_.is_variant AS is_variant_11, m1_.avarage_rating AS avarage_rating_12, m1_.total_visited AS total_visited_13, m1_.position AS position_14, m1_.total_sales AS total_sales_15, m1_.audio_file AS audio_file_16, m1_.uuid AS uuid_17, m1_.length AS length_18, m1_.depth AS depth_19, m1_.height AS height_20, m1_.weight AS weight_21, m1_.product_material AS product_material_22, m1_.product_color AS product_color_23, m1_.product_suggestion AS product_suggestion_24, m1_.product_paint_type AS product_paint_type_25, m1_.delivery_time AS delivery_time_26, m1_.created_at AS created_at_27, m1_.updated_at AS updated_at_28, m1_.is_jewel_price AS is_jewel_price_29, m2_.id AS id_30, m2_.name AS name_31, m2_.alias AS alias_32, m2_.description AS description_33, m2_.description_long AS description_long_34, m2_.description_cargo AS description_cargo_35, m2_.meta_title AS meta_title_36, m2_.meta_description AS meta_description_37, m2_.meta_keywords AS meta_keywords_38, m2_.short_description AS short_description_39, m0_.id AS id_40, m0_.original_price AS original_price_41, m0_.discount_rate AS discount_rate_42, m0_.sales_price AS sales_price_43, m0_.created_at AS created_at_44, m0_.updated_at AS updated_at_45, m3_.id AS id_46, m3_.stock AS stock_47, m3_.is_tracked AS is_tracked_48, m3_.is_default AS is_default_49, m3_.created_at AS created_at_50, m3_.updated_at AS updated_at_51 FROM main_products m1_ LEFT JOIN main_product_lang m2_ ON m1_.id = m2_.product_id LEFT JOIN sys_langs s4_ ON m2_.lang_id = s4_.id LEFT JOIN main_categories m5_ ON m1_.main_category_id = m5_.id LEFT JOIN main_product_other_categories m6_ ON m1_.id = m6_.product_id LEFT JOIN main_categories m7_ ON m6_.category_id = m7_.id LEFT JOIN main_product_pricing m0_ ON m1_.id = m0_.product_id LEFT JOIN main_product_variants m3_ ON m0_.product_variant_id = m3_.id WHERE m0_.id > 0 AND s4_.id = ? AND ((m5_.id IN (?) OR m7_.id IN (?))) AND m1_.is_enabled = 1 AND m1_.del = 0 AND ((m5_.id IN (?) OR m7_.id IN (?))) GROUP BY m1_.id, m2_.id, m0_.id, m6_.id ORDER BY MIN(m0_.sales_price) DESC
Parameters:
[
  1
  56
  56
  56
  56
]
8 0.86 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
]
9 0.45 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:
[]
10 0.39 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
]
11 0.64 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.meta_description AS meta_description_4, t0.meta_baslik AS meta_baslik_5, t0.meta_keywords AS meta_keywords_6, t0.description AS description_7, t0.category_id AS category_id_8, t0.lang_id AS lang_id_9 FROM main_category_lang t0 WHERE t0.lang_id = ? AND t0.category_id = ? LIMIT 1
Parameters:
[
  1
  56
]
12 0.90 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:
[]
13 0.97 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
]
14 0.39 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
]
15 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 IS NULL AND t0.is_enabled = ? LIMIT 1
Parameters:
[
  1
]
16 0.69 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
]
17 0.48 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.46 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
]
19 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
]
20 0.54 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.64 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.04 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
]
23 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
]
24 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
  52
  1
  52
]
25 0.44 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
]
26 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
  53
  1
  53
]
27 0.42 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
]
28 0.68 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
]
29 0.41 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
]
30 0.81 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
]
31 0.42 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
]
32 0.66 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
]
33 0.43 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
]
34 0.69 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
]
35 0.43 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
]
36 0.68 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
]
37 0.41 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
]
38 0.66 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
]
39 0.41 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
]
40 0.65 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
]
41 0.43 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
]
42 0.68 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
]
43 0.42 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
]
44 0.67 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
  56
  1
  56
]
45 0.42 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
]
46 0.87 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
]
47 0.41 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
]
48 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_.parent_category_id = ? ORDER BY m0_.position ASC
Parameters:
[
  0
  45
  1
  45
]
49 0.36 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
]
50 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_.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\Page\Page 8
App\Entity\Main\Product\Category 2
App\Entity\Main\Thema\Thema 1
App\Entity\System\Lang 1
App\Entity\Main\Product\CategoryLang 1
App\Entity\FirmaSiteAyar 1
App\Entity\Main\Setting\GlobalSetting 1