Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sort AS sort_3,
  t0.slug AS slug_4,
  t0.s1_code AS s1_code_5,
  t0.is_published AS is_published_6,
  t0.intro AS intro_7,
  t0.description AS description_8,
  t0.previous_id AS previous_id_9,
  t0.is_root AS is_root_10,
  t0.is_catalogue AS is_catalogue_11,
  t0.title AS title_12,
  t0.name_in_navigation AS name_in_navigation_13,
  t0.temp_products_count AS temp_products_count_14,
  t0.temp_price_min AS temp_price_min_15,
  t0.temp_price_max AS temp_price_max_16,
  t0.is_drop_down AS is_drop_down_17,
  t0.path_redirect AS path_redirect_18,
  t0.is_actual AS is_actual_19,
  t0.is_on_main AS is_on_main_20,
  t0.temp_file_list_name AS temp_file_list_name_21,
  t0.category_id AS category_id_22,
  t0.file_intro_id AS file_intro_id_23,
  t0.file_description_id AS file_description_id_24,
  t0.link_id AS link_id_25,
  t0.file_list_id AS file_list_id_26,
  t0.file_icon_id AS file_icon_id_27,
  t0.file_actual_id AS file_actual_id_28,
  t0.file_catalogue_id AS file_catalogue_id_29,
  t0.file_application_id AS file_application_id_30
FROM
  category t0
WHERE
  t0.is_on_main = ?
  AND t0.is_published = ?
  AND t0.is_catalogue = ?
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.sort AS sort_3, t0.slug AS slug_4, t0.s1_code AS s1_code_5, t0.is_published AS is_published_6, t0.intro AS intro_7, t0.description AS description_8, t0.previous_id AS previous_id_9, t0.is_root AS is_root_10, t0.is_catalogue AS is_catalogue_11, t0.title AS title_12, t0.name_in_navigation AS name_in_navigation_13, t0.temp_products_count AS temp_products_count_14, t0.temp_price_min AS temp_price_min_15, t0.temp_price_max AS temp_price_max_16, t0.is_drop_down AS is_drop_down_17, t0.path_redirect AS path_redirect_18, t0.is_actual AS is_actual_19, t0.is_on_main AS is_on_main_20, t0.temp_file_list_name AS temp_file_list_name_21, t0.category_id AS category_id_22, t0.file_intro_id AS file_intro_id_23, t0.file_description_id AS file_description_id_24, t0.link_id AS link_id_25, t0.file_list_id AS file_list_id_26, t0.file_icon_id AS file_icon_id_27, t0.file_actual_id AS file_actual_id_28, t0.file_catalogue_id AS file_catalogue_id_29, t0.file_application_id AS file_application_id_30 FROM category t0 WHERE t0.is_on_main = 1 AND t0.is_published = 1 AND t0.is_catalogue = 1 ORDER BY t0.sort ASC;

SELECT
  CASE WHEN (
    (
      (
        p0_.is_sale_admin IS NOT NULL
        AND 1 = p0_.is_sale_admin
      )
      OR (
        p0_.is_sale_admin IS NULL
        AND 1 = p0_.is_sale
      )
    )
    AND p0_.shop_count > 0
  ) THEN
    1
  ELSE
    0
  END AS sclr_0,
  CASE WHEN (
    p0_.is_sale_admin IS NOT NULL
    AND 1 = p0_.is_sale_admin
  )
  OR (
    p0_.is_sale_admin IS NULL
    AND 1 = p0_.is_sale
  ) THEN
    1
  ELSE
    0
  END AS sclr_1,
  CASE WHEN p0_.shop_count > 0 THEN
    1
  ELSE
    0
  END AS sclr_2,
  p0_.id AS id_3,
  p0_.is_published AS is_published_4,
  p0_.is_on_sale AS is_on_sale_5,
  p0_.name AS name_6,
  p0_.s1_code AS s1_code_7,
  p0_.description AS description_8,
  p0_.is_description_unique AS is_description_unique_9,
  p0_.product_code AS product_code_10,
  p0_.seo_name AS seo_name_11,
  p0_.seo_description AS seo_description_12,
  p0_.previous_id AS previous_id_13,
  p0_.created_at AS created_at_14,
  p0_.price_value AS price_value_15,
  p0_.price_value_client AS price_value_client_16,
  p0_.imported_at AS imported_at_17,
  p0_.set_categories_at AS set_categories_at_18,
  p0_.is_archives AS is_archives_19,
  p0_.temp_price_value AS temp_price_value_20,
  p0_.updated_at AS updated_at_21,
  p0_.is_api_image AS is_api_image_22,
  p0_.file_order AS file_order_23,
  p0_.slug AS slug_24,
  p0_.unit AS unit_25,
  p0_.replaced_s1_code AS replaced_s1_code_26,
  p0_.is_show_price AS is_show_price_27,
  p0_.is_service AS is_service_28,
  p0_.promo_description AS promo_description_29,
  p0_.s1_slug AS s1_slug_30,
  p0_.is_actual AS is_actual_31,
  p0_.ratio AS ratio_32,
  p0_.shop_count AS shop_count_33,
  p0_.is_sale AS is_sale_34,
  p0_.is_sale_admin AS is_sale_admin_35,
  p0_.direct_code AS direct_code_36,
  p0_.temp_product_code_duplicates AS temp_product_code_duplicates_37,
  b1_.id AS id_38,
  b1_.name AS name_39,
  b1_.is_published AS is_published_40,
  b1_.slug AS slug_41,
  b1_.description AS description_42,
  b1_.sort AS sort_43,
  b1_.intro AS intro_44,
  b1_.temp_products_count AS temp_products_count_45,
  b1_.is_drop_down AS is_drop_down_46,
  b1_.link_advertising AS link_advertising_47,
  b1_.link_catalogue AS link_catalogue_48,
  b1_.link_instruction AS link_instruction_49,
  b1_.link_certificate AS link_certificate_50,
  b1_.link_shop AS link_shop_51,
  b1_.description_corporate AS description_corporate_52,
  b1_.is_published_corporate AS is_published_corporate_53,
  b1_.heading AS heading_54,
  b1_.heading_corporate AS heading_corporate_55,
  b1_.is_show_catalogue AS is_show_catalogue_56,
  b1_.alias AS alias_57,
  b1_.categories_updated_at AS categories_updated_at_58,
  b1_.is_description_corporate_full_page AS is_description_corporate_full_page_59,
  b1_.is_description_full_page AS is_description_full_page_60,
  b1_.sort_corporate AS sort_corporate_61,
  b1_.is_original AS is_original_62,
  f2_.id AS id_63,
  f2_.name AS name_64,
  f2_.image_width AS image_width_65,
  f2_.image_height AS image_height_66,
  f2_.type AS type_67,
  f2_.bytes AS bytes_68,
  f2_.created_at AS created_at_69,
  f2_.is_tested AS is_tested_70,
  f2_.title AS title_71,
  f2_.description AS description_72,
  f2_.priority AS priority_73,
  f2_.filename_original AS filename_original_74,
  f2_.checked AS checked_75,
  p0_.brand_id AS brand_id_76,
  p0_.file_list_id AS file_list_id_77,
  p0_.currency_id AS currency_id_78,
  p0_.currency_client_id AS currency_client_id_79,
  p0_.country_id AS country_id_80,
  p0_.brand_series_id AS brand_series_id_81,
  p0_.model_id AS model_id_82,
  b1_.file_id AS file_id_83,
  b1_.country_id AS country_id_84,
  b1_.disk_folder_id AS disk_folder_id_85,
  f2_.file_display_id AS file_display_id_86,
  f2_.file_preview_id AS file_preview_id_87
FROM
  product p0_
  LEFT JOIN brand b1_ ON p0_.brand_id = b1_.id
  LEFT JOIN file f2_ ON p0_.file_list_id = f2_.id
WHERE
  p0_.is_archives = 0
  AND (
    b1_.id IS NULL
    OR b1_.is_published = 1
  )
  AND p0_.is_published = ?
  AND p0_.is_service = ?
ORDER BY
  sclr_0 DESC,
  sclr_2 DESC,
  sclr_1 DESC,
  p0_.is_actual DESC,
  p0_.is_show_price DESC,
  p0_.is_on_sale DESC,
  p0_.file_list_id DESC
LIMIT
  5

SELECT CASE WHEN (((p0_.is_sale_admin IS NOT NULL AND 1 = p0_.is_sale_admin) OR (p0_.is_sale_admin IS NULL AND 1 = p0_.is_sale)) AND p0_.shop_count > 0) THEN 1 ELSE 0 END AS sclr_0, CASE WHEN (p0_.is_sale_admin IS NOT NULL AND 1 = p0_.is_sale_admin) OR (p0_.is_sale_admin IS NULL AND 1 = p0_.is_sale) THEN 1 ELSE 0 END AS sclr_1, CASE WHEN p0_.shop_count > 0 THEN 1 ELSE 0 END AS sclr_2, p0_.id AS id_3, p0_.is_published AS is_published_4, p0_.is_on_sale AS is_on_sale_5, p0_.name AS name_6, p0_.s1_code AS s1_code_7, p0_.description AS description_8, p0_.is_description_unique AS is_description_unique_9, p0_.product_code AS product_code_10, p0_.seo_name AS seo_name_11, p0_.seo_description AS seo_description_12, p0_.previous_id AS previous_id_13, p0_.created_at AS created_at_14, p0_.price_value AS price_value_15, p0_.price_value_client AS price_value_client_16, p0_.imported_at AS imported_at_17, p0_.set_categories_at AS set_categories_at_18, p0_.is_archives AS is_archives_19, p0_.temp_price_value AS temp_price_value_20, p0_.updated_at AS updated_at_21, p0_.is_api_image AS is_api_image_22, p0_.file_order AS file_order_23, p0_.slug AS slug_24, p0_.unit AS unit_25, p0_.replaced_s1_code AS replaced_s1_code_26, p0_.is_show_price AS is_show_price_27, p0_.is_service AS is_service_28, p0_.promo_description AS promo_description_29, p0_.s1_slug AS s1_slug_30, p0_.is_actual AS is_actual_31, p0_.ratio AS ratio_32, p0_.shop_count AS shop_count_33, p0_.is_sale AS is_sale_34, p0_.is_sale_admin AS is_sale_admin_35, p0_.direct_code AS direct_code_36, p0_.temp_product_code_duplicates AS temp_product_code_duplicates_37, b1_.id AS id_38, b1_.name AS name_39, b1_.is_published AS is_published_40, b1_.slug AS slug_41, b1_.description AS description_42, b1_.sort AS sort_43, b1_.intro AS intro_44, b1_.temp_products_count AS temp_products_count_45, b1_.is_drop_down AS is_drop_down_46, b1_.link_advertising AS link_advertising_47, b1_.link_catalogue AS link_catalogue_48, b1_.link_instruction AS link_instruction_49, b1_.link_certificate AS link_certificate_50, b1_.link_shop AS link_shop_51, b1_.description_corporate AS description_corporate_52, b1_.is_published_corporate AS is_published_corporate_53, b1_.heading AS heading_54, b1_.heading_corporate AS heading_corporate_55, b1_.is_show_catalogue AS is_show_catalogue_56, b1_.alias AS alias_57, b1_.categories_updated_at AS categories_updated_at_58, b1_.is_description_corporate_full_page AS is_description_corporate_full_page_59, b1_.is_description_full_page AS is_description_full_page_60, b1_.sort_corporate AS sort_corporate_61, b1_.is_original AS is_original_62, f2_.id AS id_63, f2_.name AS name_64, f2_.image_width AS image_width_65, f2_.image_height AS image_height_66, f2_.type AS type_67, f2_.bytes AS bytes_68, f2_.created_at AS created_at_69, f2_.is_tested AS is_tested_70, f2_.title AS title_71, f2_.description AS description_72, f2_.priority AS priority_73, f2_.filename_original AS filename_original_74, f2_.checked AS checked_75, p0_.brand_id AS brand_id_76, p0_.file_list_id AS file_list_id_77, p0_.currency_id AS currency_id_78, p0_.currency_client_id AS currency_client_id_79, p0_.country_id AS country_id_80, p0_.brand_series_id AS brand_series_id_81, p0_.model_id AS model_id_82, b1_.file_id AS file_id_83, b1_.country_id AS country_id_84, b1_.disk_folder_id AS disk_folder_id_85, f2_.file_display_id AS file_display_id_86, f2_.file_preview_id AS file_preview_id_87 FROM product p0_ LEFT JOIN brand b1_ ON p0_.brand_id = b1_.id LEFT JOIN file f2_ ON p0_.file_list_id = f2_.id WHERE p0_.is_archives = 0 AND (b1_.id IS NULL OR b1_.is_published = 1) AND p0_.is_published = 1 AND p0_.is_service = 0 ORDER BY sclr_0 DESC, sclr_2 DESC, sclr_1 DESC, p0_.is_actual DESC, p0_.is_show_price DESC, p0_.is_on_sale DESC, p0_.file_list_id DESC LIMIT 5;

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
  LEFT JOIN brand b1_ ON p0_.brand_id = b1_.id
  LEFT JOIN file f2_ ON p0_.file_list_id = f2_.id
WHERE
  p0_.is_archives = 0
  AND (
    b1_.id IS NULL
    OR b1_.is_published = 1
  )
  AND p0_.is_published = ?
  AND p0_.is_service = ?
ORDER BY
  p0_.id ASC

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN brand b1_ ON p0_.brand_id = b1_.id LEFT JOIN file f2_ ON p0_.file_list_id = f2_.id WHERE p0_.is_archives = 0 AND (b1_.id IS NULL OR b1_.is_published = 1) AND p0_.is_published = 1 AND p0_.is_service = 0 ORDER BY p0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.symbol AS symbol_4,
  t0.is_main AS is_main_5,
  t0.is_published AS is_published_6,
  t0.fix_value AS fix_value_7
FROM
  currency t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.symbol AS symbol_4, t0.is_main AS is_main_5, t0.is_published AS is_published_6, t0.fix_value AS fix_value_7 FROM currency t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.symbol AS symbol_4,
  t0.is_main AS is_main_5,
  t0.is_published AS is_published_6,
  t0.fix_value AS fix_value_7
FROM
  currency t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.symbol AS symbol_4, t0.is_main AS is_main_5, t0.is_published AS is_published_6, t0.fix_value AS fix_value_7 FROM currency t0 WHERE t0.id = 3;

SELECT
  CASE WHEN (
    (
      (
        p0_.is_sale_admin IS NOT NULL
        AND 1 = p0_.is_sale_admin
      )
      OR (
        p0_.is_sale_admin IS NULL
        AND 1 = p0_.is_sale
      )
    )
    AND p0_.shop_count > 0
  ) THEN
    1
  ELSE
    0
  END AS sclr_0,
  CASE WHEN (
    p0_.is_sale_admin IS NOT NULL
    AND 1 = p0_.is_sale_admin
  )
  OR (
    p0_.is_sale_admin IS NULL
    AND 1 = p0_.is_sale
  ) THEN
    1
  ELSE
    0
  END AS sclr_1,
  CASE WHEN p0_.shop_count > 0 THEN
    1
  ELSE
    0
  END AS sclr_2,
  p0_.id AS id_3,
  p0_.is_published AS is_published_4,
  p0_.is_on_sale AS is_on_sale_5,
  p0_.name AS name_6,
  p0_.s1_code AS s1_code_7,
  p0_.description AS description_8,
  p0_.is_description_unique AS is_description_unique_9,
  p0_.product_code AS product_code_10,
  p0_.seo_name AS seo_name_11,
  p0_.seo_description AS seo_description_12,
  p0_.previous_id AS previous_id_13,
  p0_.created_at AS created_at_14,
  p0_.price_value AS price_value_15,
  p0_.price_value_client AS price_value_client_16,
  p0_.imported_at AS imported_at_17,
  p0_.set_categories_at AS set_categories_at_18,
  p0_.is_archives AS is_archives_19,
  p0_.temp_price_value AS temp_price_value_20,
  p0_.updated_at AS updated_at_21,
  p0_.is_api_image AS is_api_image_22,
  p0_.file_order AS file_order_23,
  p0_.slug AS slug_24,
  p0_.unit AS unit_25,
  p0_.replaced_s1_code AS replaced_s1_code_26,
  p0_.is_show_price AS is_show_price_27,
  p0_.is_service AS is_service_28,
  p0_.promo_description AS promo_description_29,
  p0_.s1_slug AS s1_slug_30,
  p0_.is_actual AS is_actual_31,
  p0_.ratio AS ratio_32,
  p0_.shop_count AS shop_count_33,
  p0_.is_sale AS is_sale_34,
  p0_.is_sale_admin AS is_sale_admin_35,
  p0_.direct_code AS direct_code_36,
  p0_.temp_product_code_duplicates AS temp_product_code_duplicates_37,
  b1_.id AS id_38,
  b1_.name AS name_39,
  b1_.is_published AS is_published_40,
  b1_.slug AS slug_41,
  b1_.description AS description_42,
  b1_.sort AS sort_43,
  b1_.intro AS intro_44,
  b1_.temp_products_count AS temp_products_count_45,
  b1_.is_drop_down AS is_drop_down_46,
  b1_.link_advertising AS link_advertising_47,
  b1_.link_catalogue AS link_catalogue_48,
  b1_.link_instruction AS link_instruction_49,
  b1_.link_certificate AS link_certificate_50,
  b1_.link_shop AS link_shop_51,
  b1_.description_corporate AS description_corporate_52,
  b1_.is_published_corporate AS is_published_corporate_53,
  b1_.heading AS heading_54,
  b1_.heading_corporate AS heading_corporate_55,
  b1_.is_show_catalogue AS is_show_catalogue_56,
  b1_.alias AS alias_57,
  b1_.categories_updated_at AS categories_updated_at_58,
  b1_.is_description_corporate_full_page AS is_description_corporate_full_page_59,
  b1_.is_description_full_page AS is_description_full_page_60,
  b1_.sort_corporate AS sort_corporate_61,
  b1_.is_original AS is_original_62,
  f2_.id AS id_63,
  f2_.name AS name_64,
  f2_.image_width AS image_width_65,
  f2_.image_height AS image_height_66,
  f2_.type AS type_67,
  f2_.bytes AS bytes_68,
  f2_.created_at AS created_at_69,
  f2_.is_tested AS is_tested_70,
  f2_.title AS title_71,
  f2_.description AS description_72,
  f2_.priority AS priority_73,
  f2_.filename_original AS filename_original_74,
  f2_.checked AS checked_75,
  p0_.brand_id AS brand_id_76,
  p0_.file_list_id AS file_list_id_77,
  p0_.currency_id AS currency_id_78,
  p0_.currency_client_id AS currency_client_id_79,
  p0_.country_id AS country_id_80,
  p0_.brand_series_id AS brand_series_id_81,
  p0_.model_id AS model_id_82,
  b1_.file_id AS file_id_83,
  b1_.country_id AS country_id_84,
  b1_.disk_folder_id AS disk_folder_id_85,
  f2_.file_display_id AS file_display_id_86,
  f2_.file_preview_id AS file_preview_id_87
FROM
  product p0_
  LEFT JOIN brand b1_ ON p0_.brand_id = b1_.id
  LEFT JOIN file f2_ ON p0_.file_list_id = f2_.id
WHERE
  p0_.is_archives = 0
  AND (
    b1_.id IS NULL
    OR b1_.is_published = 1
  )
  AND p0_.is_published = ?
  AND p0_.is_on_sale = ?
  AND p0_.is_service = ?
  AND p0_.shop_count > 0
  AND (
    p0_.is_sale_admin = ?
    OR (
      p0_.is_sale = ?
      AND p0_.is_sale_admin IS NULL
    )
  )
ORDER BY
  sclr_0 DESC,
  sclr_2 DESC,
  sclr_1 DESC,
  p0_.is_actual DESC,
  p0_.is_show_price DESC,
  p0_.is_on_sale DESC,
  p0_.file_list_id DESC
LIMIT
  50

SELECT CASE WHEN (((p0_.is_sale_admin IS NOT NULL AND 1 = p0_.is_sale_admin) OR (p0_.is_sale_admin IS NULL AND 1 = p0_.is_sale)) AND p0_.shop_count > 0) THEN 1 ELSE 0 END AS sclr_0, CASE WHEN (p0_.is_sale_admin IS NOT NULL AND 1 = p0_.is_sale_admin) OR (p0_.is_sale_admin IS NULL AND 1 = p0_.is_sale) THEN 1 ELSE 0 END AS sclr_1, CASE WHEN p0_.shop_count > 0 THEN 1 ELSE 0 END AS sclr_2, p0_.id AS id_3, p0_.is_published AS is_published_4, p0_.is_on_sale AS is_on_sale_5, p0_.name AS name_6, p0_.s1_code AS s1_code_7, p0_.description AS description_8, p0_.is_description_unique AS is_description_unique_9, p0_.product_code AS product_code_10, p0_.seo_name AS seo_name_11, p0_.seo_description AS seo_description_12, p0_.previous_id AS previous_id_13, p0_.created_at AS created_at_14, p0_.price_value AS price_value_15, p0_.price_value_client AS price_value_client_16, p0_.imported_at AS imported_at_17, p0_.set_categories_at AS set_categories_at_18, p0_.is_archives AS is_archives_19, p0_.temp_price_value AS temp_price_value_20, p0_.updated_at AS updated_at_21, p0_.is_api_image AS is_api_image_22, p0_.file_order AS file_order_23, p0_.slug AS slug_24, p0_.unit AS unit_25, p0_.replaced_s1_code AS replaced_s1_code_26, p0_.is_show_price AS is_show_price_27, p0_.is_service AS is_service_28, p0_.promo_description AS promo_description_29, p0_.s1_slug AS s1_slug_30, p0_.is_actual AS is_actual_31, p0_.ratio AS ratio_32, p0_.shop_count AS shop_count_33, p0_.is_sale AS is_sale_34, p0_.is_sale_admin AS is_sale_admin_35, p0_.direct_code AS direct_code_36, p0_.temp_product_code_duplicates AS temp_product_code_duplicates_37, b1_.id AS id_38, b1_.name AS name_39, b1_.is_published AS is_published_40, b1_.slug AS slug_41, b1_.description AS description_42, b1_.sort AS sort_43, b1_.intro AS intro_44, b1_.temp_products_count AS temp_products_count_45, b1_.is_drop_down AS is_drop_down_46, b1_.link_advertising AS link_advertising_47, b1_.link_catalogue AS link_catalogue_48, b1_.link_instruction AS link_instruction_49, b1_.link_certificate AS link_certificate_50, b1_.link_shop AS link_shop_51, b1_.description_corporate AS description_corporate_52, b1_.is_published_corporate AS is_published_corporate_53, b1_.heading AS heading_54, b1_.heading_corporate AS heading_corporate_55, b1_.is_show_catalogue AS is_show_catalogue_56, b1_.alias AS alias_57, b1_.categories_updated_at AS categories_updated_at_58, b1_.is_description_corporate_full_page AS is_description_corporate_full_page_59, b1_.is_description_full_page AS is_description_full_page_60, b1_.sort_corporate AS sort_corporate_61, b1_.is_original AS is_original_62, f2_.id AS id_63, f2_.name AS name_64, f2_.image_width AS image_width_65, f2_.image_height AS image_height_66, f2_.type AS type_67, f2_.bytes AS bytes_68, f2_.created_at AS created_at_69, f2_.is_tested AS is_tested_70, f2_.title AS title_71, f2_.description AS description_72, f2_.priority AS priority_73, f2_.filename_original AS filename_original_74, f2_.checked AS checked_75, p0_.brand_id AS brand_id_76, p0_.file_list_id AS file_list_id_77, p0_.currency_id AS currency_id_78, p0_.currency_client_id AS currency_client_id_79, p0_.country_id AS country_id_80, p0_.brand_series_id AS brand_series_id_81, p0_.model_id AS model_id_82, b1_.file_id AS file_id_83, b1_.country_id AS country_id_84, b1_.disk_folder_id AS disk_folder_id_85, f2_.file_display_id AS file_display_id_86, f2_.file_preview_id AS file_preview_id_87 FROM product p0_ LEFT JOIN brand b1_ ON p0_.brand_id = b1_.id LEFT JOIN file f2_ ON p0_.file_list_id = f2_.id WHERE p0_.is_archives = 0 AND (b1_.id IS NULL OR b1_.is_published = 1) AND p0_.is_published = 1 AND p0_.is_on_sale = 1 AND p0_.is_service = 0 AND p0_.shop_count > 0 AND (p0_.is_sale_admin = 1 OR (p0_.is_sale = 1 AND p0_.is_sale_admin IS NULL)) ORDER BY sclr_0 DESC, sclr_2 DESC, sclr_1 DESC, p0_.is_actual DESC, p0_.is_show_price DESC, p0_.is_on_sale DESC, p0_.file_list_id DESC LIMIT 50;

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
  LEFT JOIN brand b1_ ON p0_.brand_id = b1_.id
  LEFT JOIN file f2_ ON p0_.file_list_id = f2_.id
WHERE
  p0_.is_archives = 0
  AND (
    b1_.id IS NULL
    OR b1_.is_published = 1
  )
  AND p0_.is_published = ?
  AND p0_.is_on_sale = ?
  AND p0_.is_service = ?
  AND p0_.shop_count > 0
  AND (
    p0_.is_sale_admin = ?
    OR (
      p0_.is_sale = ?
      AND p0_.is_sale_admin IS NULL
    )
  )
ORDER BY
  p0_.id ASC

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN brand b1_ ON p0_.brand_id = b1_.id LEFT JOIN file f2_ ON p0_.file_list_id = f2_.id WHERE p0_.is_archives = 0 AND (b1_.id IS NULL OR b1_.is_published = 1) AND p0_.is_published = 1 AND p0_.is_on_sale = 1 AND p0_.is_service = 0 AND p0_.shop_count > 0 AND (p0_.is_sale_admin = 1 OR (p0_.is_sale = 1 AND p0_.is_sale_admin IS NULL)) ORDER BY p0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.session_id AS session_id_2,
  t0.created_at AS created_at_3,
  t0.product_id AS product_id_4,
  t0.user_id AS user_id_5
FROM
  wish_product t0
WHERE
  t0.session_id = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.created_at AS created_at_3, t0.product_id AS product_id_4, t0.user_id AS user_id_5 FROM wish_product t0 WHERE t0.session_id = 'ad833bff-9534-415b-83b5-feefa18ae513' ORDER BY t0.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.h1 AS h1_5
FROM
  page_tag t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.description AS description_4, t0.h1 AS h1_5 FROM page_tag t0 WHERE t0.url = '/' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_default AS is_default_3,
  t0.is_published AS is_published_4,
  t0.sort AS sort_5,
  t0.price AS price_6,
  t0.is_address AS is_address_7,
  t0.is_time AS is_time_8,
  t0.description AS description_9,
  t0.comment AS comment_10,
  t0.code AS code_11,
  t0.price_comment AS price_comment_12,
  t0.use_auto_payment AS use_auto_payment_13,
  t0.default_city AS default_city_14,
  t0.price_min AS price_min_15,
  t0.shop_id AS shop_id_16
FROM
  delivery t0
WHERE
  t0.is_published = ?
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_default AS is_default_3, t0.is_published AS is_published_4, t0.sort AS sort_5, t0.price AS price_6, t0.is_address AS is_address_7, t0.is_time AS is_time_8, t0.description AS description_9, t0.comment AS comment_10, t0.code AS code_11, t0.price_comment AS price_comment_12, t0.use_auto_payment AS use_auto_payment_13, t0.default_city AS default_city_14, t0.price_min AS price_min_15, t0.shop_id AS shop_id_16 FROM delivery t0 WHERE t0.is_published = 1 ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_published AS is_published_4,
  t0.sort AS sort_5,
  t0.map_latitude AS map_latitude_6,
  t0.map_longitude AS map_longitude_7,
  t0.slug_short AS slug_short_8,
  t0.is_default AS is_default_9,
  t0.email AS email_10,
  t0.phone_number AS phone_number_11,
  t0.html_map AS html_map_12,
  t0.html_link AS html_link_13,
  t0.is_storage AS is_storage_14,
  t0.heading AS heading_15,
  t0.working_hours AS working_hours_16,
  t0.address AS address_17,
  t0.is_availability AS is_availability_18,
  t0.is_corporate AS is_corporate_19,
  t0.address_short AS address_short_20,
  t0.is_main AS is_main_21,
  t0.code AS code_22,
  t0.shop_id AS shop_id_23,
  t0.region_shop_id AS region_shop_id_24
FROM
  shop t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_published AS is_published_4, t0.sort AS sort_5, t0.map_latitude AS map_latitude_6, t0.map_longitude AS map_longitude_7, t0.slug_short AS slug_short_8, t0.is_default AS is_default_9, t0.email AS email_10, t0.phone_number AS phone_number_11, t0.html_map AS html_map_12, t0.html_link AS html_link_13, t0.is_storage AS is_storage_14, t0.heading AS heading_15, t0.working_hours AS working_hours_16, t0.address AS address_17, t0.is_availability AS is_availability_18, t0.is_corporate AS is_corporate_19, t0.address_short AS address_short_20, t0.is_main AS is_main_21, t0.code AS code_22, t0.shop_id AS shop_id_23, t0.region_shop_id AS region_shop_id_24 FROM shop t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_published AS is_published_4,
  t0.sort AS sort_5,
  t0.map_latitude AS map_latitude_6,
  t0.map_longitude AS map_longitude_7,
  t0.slug_short AS slug_short_8,
  t0.is_default AS is_default_9,
  t0.email AS email_10,
  t0.phone_number AS phone_number_11,
  t0.html_map AS html_map_12,
  t0.html_link AS html_link_13,
  t0.is_storage AS is_storage_14,
  t0.heading AS heading_15,
  t0.working_hours AS working_hours_16,
  t0.address AS address_17,
  t0.is_availability AS is_availability_18,
  t0.is_corporate AS is_corporate_19,
  t0.address_short AS address_short_20,
  t0.is_main AS is_main_21,
  t0.code AS code_22,
  t0.shop_id AS shop_id_23,
  t0.region_shop_id AS region_shop_id_24
FROM
  shop t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_published AS is_published_4, t0.sort AS sort_5, t0.map_latitude AS map_latitude_6, t0.map_longitude AS map_longitude_7, t0.slug_short AS slug_short_8, t0.is_default AS is_default_9, t0.email AS email_10, t0.phone_number AS phone_number_11, t0.html_map AS html_map_12, t0.html_link AS html_link_13, t0.is_storage AS is_storage_14, t0.heading AS heading_15, t0.working_hours AS working_hours_16, t0.address AS address_17, t0.is_availability AS is_availability_18, t0.is_corporate AS is_corporate_19, t0.address_short AS address_short_20, t0.is_main AS is_main_21, t0.code AS code_22, t0.shop_id AS shop_id_23, t0.region_shop_id AS region_shop_id_24 FROM shop t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_published AS is_published_4,
  t0.sort AS sort_5,
  t0.map_latitude AS map_latitude_6,
  t0.map_longitude AS map_longitude_7,
  t0.slug_short AS slug_short_8,
  t0.is_default AS is_default_9,
  t0.email AS email_10,
  t0.phone_number AS phone_number_11,
  t0.html_map AS html_map_12,
  t0.html_link AS html_link_13,
  t0.is_storage AS is_storage_14,
  t0.heading AS heading_15,
  t0.working_hours AS working_hours_16,
  t0.address AS address_17,
  t0.is_availability AS is_availability_18,
  t0.is_corporate AS is_corporate_19,
  t0.address_short AS address_short_20,
  t0.is_main AS is_main_21,
  t0.code AS code_22,
  t0.shop_id AS shop_id_23,
  t0.region_shop_id AS region_shop_id_24
FROM
  shop t0
WHERE
  t0.id = ?