Symfony Profiler

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

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 = 1 LIMIT 1;

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

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 = 'USD' AND t0.is_enabled = 1 LIMIT 1;

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 = ?

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 = '55';

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

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 = 55 ORDER BY m0_.position ASC;

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

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 = 55 ORDER BY m0_.position ASC;

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

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 = 1 AND ((m3_.id IN (55) OR m5_.id IN (55))) AND m0_.is_enabled = 1 AND m0_.del = 0 AND ((m3_.id IN (55) OR m5_.id IN (55))) GROUP BY m0_.id, m1_.id, m6_.id, m4_.id ORDER BY MIN(m6_.sales_price) DESC;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.product_id AS product_id_5,
  t0.jewel_id AS jewel_id_6
FROM
  main_product_jewels t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = 13;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.product_id AS product_id_5,
  t0.jewel_id AS jewel_id_6
FROM
  main_product_jewels t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = 12;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.product_id AS product_id_5,
  t0.jewel_id AS jewel_id_6
FROM
  main_product_jewels t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = 11;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.product_id AS product_id_5,
  t0.jewel_id AS jewel_id_6
FROM
  main_product_jewels t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = 10;

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

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 = 1 AND ((m5_.id IN (55) OR m7_.id IN (55))) AND m1_.is_enabled = 1 AND m1_.del = 0 AND ((m5_.id IN (55) OR m7_.id IN (55))) GROUP BY m1_.id, m2_.id, m0_.id, m6_.id ORDER BY MIN(m0_.sales_price) DESC;

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

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 = 1 LIMIT 1;

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

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;

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

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 = 1 LIMIT 1;

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

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 = 1 AND t0.category_id = 55 LIMIT 1;

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

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;

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 = ?

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 = 1;