Symfony Profiler

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_name AS short_name_3,
  t0.slug AS slug_4,
  t0.search_terms AS search_terms_5,
  t0.text AS text_6,
  t0.text_female AS text_female_7,
  t0.text_male AS text_male_8,
  t0.highlighted AS highlighted_9,
  t0.main_page_fragrance AS main_page_fragrance_10,
  t0.highlighted_in_search AS highlighted_in_search_11,
  t0.is_on_main_page AS is_on_main_page_12,
  t0.special AS special_13,
  t0.special_name AS special_name_14,
  t0.slogan AS slogan_15,
  t0.`lead` AS lead_16,
  t0.active AS active_17,
  t0.exclude_from_arukereso AS exclude_from_arukereso_18,
  t0.image_id AS image_id_19
FROM
  brand t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.slug AS slug_4, t0.search_terms AS search_terms_5, t0.text AS text_6, t0.text_female AS text_female_7, t0.text_male AS text_male_8, t0.highlighted AS highlighted_9, t0.main_page_fragrance AS main_page_fragrance_10, t0.highlighted_in_search AS highlighted_in_search_11, t0.is_on_main_page AS is_on_main_page_12, t0.special AS special_13, t0.special_name AS special_name_14, t0.slogan AS slogan_15, t0.`lead` AS lead_16, t0.active AS active_17, t0.exclude_from_arukereso AS exclude_from_arukereso_18, t0.image_id AS image_id_19 FROM brand t0 WHERE t0.slug = 'christian-dior' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.article_number AS article_number_2,
  t0.name AS name_3,
  t0.search_terms AS search_terms_4,
  t0.year AS year_5,
  t0.gender AS gender_6,
  t0.coming_soon AS coming_soon_7,
  t0.novelty AS novelty_8,
  t0.discount AS discount_9,
  t0.unavailable_soon AS unavailable_soon_10,
  t0.niche AS niche_11,
  t0.exclusive AS exclusive_12,
  t0.limited_edition AS limited_edition_13,
  t0.outlet AS outlet_14,
  t0.rarity AS rarity_15,
  t0.available_again AS available_again_16,
  t0.limited AS limited_17,
  t0.active AS active_18,
  t0.info_link AS info_link_19,
  t0.description AS description_20,
  t0.fragrance_description AS fragrance_description_21,
  t0.meta_description AS meta_description_22,
  t0.meta_keywords AS meta_keywords_23,
  t0.facebook_description AS facebook_description_24,
  t0.minimum_price AS minimum_price_25,
  t0.discounted_minimum_price AS discounted_minimum_price_26,
  t0.url AS url_27,
  t0.sold AS sold_28,
  t0.just_arrived AS just_arrived_29,
  t0.is_on_main_page AS is_on_main_page_30,
  t0.discount_order_date AS discount_order_date_31,
  t0.novelty_order_date AS novelty_order_date_32,
  t0.unavailable_soon_order_date AS unavailable_soon_order_date_33,
  t0.move_first_order_date AS move_first_order_date_34,
  t0.slogan AS slogan_35,
  t0.price_changed_at AS price_changed_at_36,
  t0.data_changed_at AS data_changed_at_37,
  t0.price_for_sort AS price_for_sort_38,
  t0.introduction_price AS introduction_price_39,
  t0.special AS special_40,
  t0.purchasable AS purchasable_41,
  t0.fix_priced AS fix_priced_42,
  t0.created_at AS created_at_43,
  t0.updated_at AS updated_at_44,
  t0.brand_id AS brand_id_45,
  t0.product_category_id AS product_category_id_46,
  t0.image_id AS image_id_47,
  t0.tester_image_id AS tester_image_id_48,
  t0.hover_image_id AS hover_image_id_49,
  t0.facebook_image_id AS facebook_image_id_50,
  t0.concentration_id AS concentration_id_51,
  t0.fragrance_family_id AS fragrance_family_id_52,
  t0.price_changer_id AS price_changer_id_53,
  t0.data_changer_id AS data_changer_id_54
FROM
  product t0
WHERE
  t0.brand_id = ?

SELECT t0.id AS id_1, t0.article_number AS article_number_2, t0.name AS name_3, t0.search_terms AS search_terms_4, t0.year AS year_5, t0.gender AS gender_6, t0.coming_soon AS coming_soon_7, t0.novelty AS novelty_8, t0.discount AS discount_9, t0.unavailable_soon AS unavailable_soon_10, t0.niche AS niche_11, t0.exclusive AS exclusive_12, t0.limited_edition AS limited_edition_13, t0.outlet AS outlet_14, t0.rarity AS rarity_15, t0.available_again AS available_again_16, t0.limited AS limited_17, t0.active AS active_18, t0.info_link AS info_link_19, t0.description AS description_20, t0.fragrance_description AS fragrance_description_21, t0.meta_description AS meta_description_22, t0.meta_keywords AS meta_keywords_23, t0.facebook_description AS facebook_description_24, t0.minimum_price AS minimum_price_25, t0.discounted_minimum_price AS discounted_minimum_price_26, t0.url AS url_27, t0.sold AS sold_28, t0.just_arrived AS just_arrived_29, t0.is_on_main_page AS is_on_main_page_30, t0.discount_order_date AS discount_order_date_31, t0.novelty_order_date AS novelty_order_date_32, t0.unavailable_soon_order_date AS unavailable_soon_order_date_33, t0.move_first_order_date AS move_first_order_date_34, t0.slogan AS slogan_35, t0.price_changed_at AS price_changed_at_36, t0.data_changed_at AS data_changed_at_37, t0.price_for_sort AS price_for_sort_38, t0.introduction_price AS introduction_price_39, t0.special AS special_40, t0.purchasable AS purchasable_41, t0.fix_priced AS fix_priced_42, t0.created_at AS created_at_43, t0.updated_at AS updated_at_44, t0.brand_id AS brand_id_45, t0.product_category_id AS product_category_id_46, t0.image_id AS image_id_47, t0.tester_image_id AS tester_image_id_48, t0.hover_image_id AS hover_image_id_49, t0.facebook_image_id AS facebook_image_id_50, t0.concentration_id AS concentration_id_51, t0.fragrance_family_id AS fragrance_family_id_52, t0.price_changer_id AS price_changer_id_53, t0.data_changer_id AS data_changer_id_54 FROM product t0 WHERE t0.brand_id = 22;

SELECT
  t0.id AS id_1,
  t0.shortening AS shortening_2,
  t0.description AS description_3,
  t0.full_name AS full_name_4,
  t0.short_name AS short_name_5,
  t0.position AS position_6
FROM
  concentration t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.shortening AS shortening_2, t0.description AS description_3, t0.full_name AS full_name_4, t0.short_name AS short_name_5, t0.position AS position_6 FROM concentration t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.shortening AS shortening_2,
  t0.description AS description_3,
  t0.full_name AS full_name_4,
  t0.short_name AS short_name_5,
  t0.position AS position_6
FROM
  concentration t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.shortening AS shortening_2, t0.description AS description_3, t0.full_name AS full_name_4, t0.short_name AS short_name_5, t0.position AS position_6 FROM concentration t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.shortening AS shortening_2,
  t0.description AS description_3,
  t0.full_name AS full_name_4,
  t0.short_name AS short_name_5,
  t0.position AS position_6
FROM
  concentration t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.shortening AS shortening_2, t0.description AS description_3, t0.full_name AS full_name_4, t0.short_name AS short_name_5, t0.position AS position_6 FROM concentration t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.shortening AS shortening_2,
  t0.description AS description_3,
  t0.full_name AS full_name_4,
  t0.short_name AS short_name_5,
  t0.position AS position_6
FROM
  concentration t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.shortening AS shortening_2, t0.description AS description_3, t0.full_name AS full_name_4, t0.short_name AS short_name_5, t0.position AS position_6 FROM concentration t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.shortening AS shortening_2,
  t0.description AS description_3,
  t0.full_name AS full_name_4,
  t0.short_name AS short_name_5,
  t0.position AS position_6
FROM
  concentration t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.shortening AS shortening_2, t0.description AS description_3, t0.full_name AS full_name_4, t0.short_name AS short_name_5, t0.position AS position_6 FROM concentration t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.shortening AS shortening_2,
  t0.description AS description_3,
  t0.full_name AS full_name_4,
  t0.short_name AS short_name_5,
  t0.position AS position_6
FROM
  concentration t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.shortening AS shortening_2, t0.description AS description_3, t0.full_name AS full_name_4, t0.short_name AS short_name_5, t0.position AS position_6 FROM concentration t0 WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.domain AS domain_2,
  t0.origin AS origin_3,
  t0.target AS target_4,
  t0.permanent AS permanent_5
FROM
  hg_settings_redirect t0

SELECT t0.id AS id_1, t0.domain AS domain_2, t0.origin AS origin_3, t0.target AS target_4, t0.permanent AS permanent_5 FROM hg_settings_redirect t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.cosmetics AS cosmetics_4,
  t0.taska AS taska_5,
  t0.gift_set AS gift_set_6,
  t0.hidden AS hidden_7,
  t0.single_name AS single_name_8,
  t0.plural_name AS plural_name_9,
  t0.position AS position_10,
  t0.`lead` AS lead_11,
  t0.seo_description AS seo_description_12,
  t0.title AS title_13
FROM
  product_category t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.cosmetics AS cosmetics_4, t0.taska AS taska_5, t0.gift_set AS gift_set_6, t0.hidden AS hidden_7, t0.single_name AS single_name_8, t0.plural_name AS plural_name_9, t0.position AS position_10, t0.`lead` AS lead_11, t0.seo_description AS seo_description_12, t0.title AS title_13 FROM product_category t0 WHERE t0.code = 'christian-dior' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_name AS short_name_3,
  t0.slug AS slug_4,
  t0.search_terms AS search_terms_5,
  t0.text AS text_6,
  t0.text_female AS text_female_7,
  t0.text_male AS text_male_8,
  t0.highlighted AS highlighted_9,
  t0.main_page_fragrance AS main_page_fragrance_10,
  t0.highlighted_in_search AS highlighted_in_search_11,
  t0.is_on_main_page AS is_on_main_page_12,
  t0.special AS special_13,
  t0.special_name AS special_name_14,
  t0.slogan AS slogan_15,
  t0.`lead` AS lead_16,
  t0.active AS active_17,
  t0.exclude_from_arukereso AS exclude_from_arukereso_18,
  t0.image_id AS image_id_19
FROM
  brand t0
WHERE
  t0.slug = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.slug AS slug_4, t0.search_terms AS search_terms_5, t0.text AS text_6, t0.text_female AS text_female_7, t0.text_male AS text_male_8, t0.highlighted AS highlighted_9, t0.main_page_fragrance AS main_page_fragrance_10, t0.highlighted_in_search AS highlighted_in_search_11, t0.is_on_main_page AS is_on_main_page_12, t0.special AS special_13, t0.special_name AS special_name_14, t0.slogan AS slogan_15, t0.`lead` AS lead_16, t0.active AS active_17, t0.exclude_from_arukereso AS exclude_from_arukereso_18, t0.image_id AS image_id_19 FROM brand t0 WHERE t0.slug = 'christian-dior' AND t0.active = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.route_name AS route_name_2,
  t0.gender AS gender_3,
  t0.title AS title_4,
  t0.html_title AS html_title_5,
  t0.`lead` AS lead_6,
  t0.seo_description AS seo_description_7,
  t0.seo_keywords AS seo_keywords_8,
  t0.description AS description_9,
  t0.hide_title AS hide_title_10,
  t0.banner_start_date AS banner_start_date_11,
  t0.banner_end_date AS banner_end_date_12,
  t0.banner_link AS banner_link_13,
  t0.banner_link_opens_in_new_window AS banner_link_opens_in_new_window_14,
  t0.banner_position AS banner_position_15,
  t0.default_sort AS default_sort_16,
  t0.default_listing AS default_listing_17,
  t0.banner_id AS banner_id_18,
  t0.banner_mobile_id AS banner_mobile_id_19
FROM
  product_lister_route_entity t0
WHERE
  t0.route_name = ?
  AND t0.gender = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.route_name AS route_name_2, t0.gender AS gender_3, t0.title AS title_4, t0.html_title AS html_title_5, t0.`lead` AS lead_6, t0.seo_description AS seo_description_7, t0.seo_keywords AS seo_keywords_8, t0.description AS description_9, t0.hide_title AS hide_title_10, t0.banner_start_date AS banner_start_date_11, t0.banner_end_date AS banner_end_date_12, t0.banner_link AS banner_link_13, t0.banner_link_opens_in_new_window AS banner_link_opens_in_new_window_14, t0.banner_position AS banner_position_15, t0.default_sort AS default_sort_16, t0.default_listing AS default_listing_17, t0.banner_id AS banner_id_18, t0.banner_mobile_id AS banner_mobile_id_19 FROM product_lister_route_entity t0 WHERE t0.route_name = 'brand_gender' AND t0.gender = 'f' LIMIT 1;

SELECT
  MIN(p0_.discount_price / p0_.price) AS sclr_0
FROM
  product_packaging p0_
  INNER JOIN product p1_ ON p0_.product_id = p1_.id
  LEFT JOIN product_category p2_ ON p1_.product_category_id = p2_.id
  INNER JOIN brand b3_ ON p1_.brand_id = b3_.id
  LEFT JOIN fragrance_family f4_ ON p1_.fragrance_family_id = f4_.id
  LEFT JOIN concentration c5_ ON p1_.concentration_id = c5_.id
  LEFT JOIN hg_media_media h6_ ON p1_.image_id = h6_.id
  LEFT JOIN hg_media_folders h7_ ON h6_.folder_id = h7_.id
  LEFT JOIN hg_media_media h8_ ON p1_.hover_image_id = h8_.id
  LEFT JOIN hg_media_folders h9_ ON h8_.folder_id = h9_.id
WHERE
  p1_.active = 1
  AND p0_.active = 1
  AND (
    p0_.stock_limit = 0
    OR p0_.stock_limit_stock > 0
  )
  AND p0_.available = 1
  AND (
    p1_.coming_soon IS NULL
    OR p1_.coming_soon <> 1
  )
  AND b3_.id = ?
  AND p0_.discount = 1
  AND (
    p0_.discount_stock > 0
    OR p0_.discount_constant = 1
  )
ORDER BY
  b3_.name ASC,
  p1_.id ASC,
  p0_.position ASC

SELECT MIN(p0_.discount_price / p0_.price) AS sclr_0 FROM product_packaging p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id LEFT JOIN product_category p2_ ON p1_.product_category_id = p2_.id INNER JOIN brand b3_ ON p1_.brand_id = b3_.id LEFT JOIN fragrance_family f4_ ON p1_.fragrance_family_id = f4_.id LEFT JOIN concentration c5_ ON p1_.concentration_id = c5_.id LEFT JOIN hg_media_media h6_ ON p1_.image_id = h6_.id LEFT JOIN hg_media_folders h7_ ON h6_.folder_id = h7_.id LEFT JOIN hg_media_media h8_ ON p1_.hover_image_id = h8_.id LEFT JOIN hg_media_folders h9_ ON h8_.folder_id = h9_.id WHERE p1_.active = 1 AND p0_.active = 1 AND (p0_.stock_limit = 0 OR p0_.stock_limit_stock > 0) AND p0_.available = 1 AND (p1_.coming_soon IS NULL OR p1_.coming_soon <> 1) AND b3_.id = 22 AND p0_.discount = 1 AND (p0_.discount_stock > 0 OR p0_.discount_constant = 1) ORDER BY b3_.name ASC, p1_.id ASC, p0_.position ASC;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  product_packaging p0_
  INNER JOIN product p1_ ON p0_.product_id = p1_.id
  LEFT JOIN product_category p2_ ON p1_.product_category_id = p2_.id
  INNER JOIN brand b3_ ON p1_.brand_id = b3_.id
  LEFT JOIN fragrance_family f4_ ON p1_.fragrance_family_id = f4_.id
  LEFT JOIN concentration c5_ ON p1_.concentration_id = c5_.id
  LEFT JOIN hg_media_media h6_ ON p1_.image_id = h6_.id
  LEFT JOIN hg_media_folders h7_ ON h6_.folder_id = h7_.id
  LEFT JOIN hg_media_media h8_ ON p1_.hover_image_id = h8_.id
  LEFT JOIN hg_media_folders h9_ ON h8_.folder_id = h9_.id
WHERE
  p1_.active = 1
  AND p0_.active = 1
  AND (
    p0_.stock_limit = 0
    OR p0_.stock_limit_stock > 0
  )
  AND p0_.available = 1
  AND (
    p1_.coming_soon IS NULL
    OR p1_.coming_soon <> 1
  )
  AND b3_.id = ?
ORDER BY
  b3_.name ASC,
  p1_.id ASC,
  p0_.position ASC

SELECT COUNT(p0_.id) AS sclr_0 FROM product_packaging p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id LEFT JOIN product_category p2_ ON p1_.product_category_id = p2_.id INNER JOIN brand b3_ ON p1_.brand_id = b3_.id LEFT JOIN fragrance_family f4_ ON p1_.fragrance_family_id = f4_.id LEFT JOIN concentration c5_ ON p1_.concentration_id = c5_.id LEFT JOIN hg_media_media h6_ ON p1_.image_id = h6_.id LEFT JOIN hg_media_folders h7_ ON h6_.folder_id = h7_.id LEFT JOIN hg_media_media h8_ ON p1_.hover_image_id = h8_.id LEFT JOIN hg_media_folders h9_ ON h8_.folder_id = h9_.id WHERE p1_.active = 1 AND p0_.active = 1 AND (p0_.stock_limit = 0 OR p0_.stock_limit_stock > 0) AND p0_.available = 1 AND (p1_.coming_soon IS NULL OR p1_.coming_soon <> 1) AND b3_.id = 22 ORDER BY b3_.name ASC, p1_.id ASC, p0_.position ASC;

SELECT
  h0_.id AS id_0,
  h0_.meta_title AS meta_title_1,
  h0_.meta_description AS meta_description_2,
  h0_.meta_author AS meta_author_3,
  h0_.meta_robots AS meta_robots_4,
  h0_.og_type AS og_type_5,
  h0_.og_title AS og_title_6,
  h0_.og_description AS og_description_7,
  h0_.extra_metadata AS extra_metadata_8,
  h0_.ref_id AS ref_id_9,
  h0_.ref_entity_name AS ref_entity_name_10,
  h0_.og_url AS og_url_11,
  h0_.og_article_author AS og_article_author_12,
  h0_.og_article_publisher AS og_article_publisher_13,
  h0_.og_article_section AS og_article_section_14,
  h0_.twitter_title AS twitter_title_15,
  h0_.twitter_description AS twitter_description_16,
  h0_.twitter_site AS twitter_site_17,
  h0_.twitter_creator AS twitter_creator_18,
  h0_.og_image_id AS og_image_id_19,
  h0_.twitter_image_id AS twitter_image_id_20
FROM
  hg_seo_seo h0_
WHERE
  h0_.ref_id IS NULL
  AND h0_.ref_entity_name IS NULL
ORDER BY
  h0_.id DESC
LIMIT
  1

SELECT h0_.id AS id_0, h0_.meta_title AS meta_title_1, h0_.meta_description AS meta_description_2, h0_.meta_author AS meta_author_3, h0_.meta_robots AS meta_robots_4, h0_.og_type AS og_type_5, h0_.og_title AS og_title_6, h0_.og_description AS og_description_7, h0_.extra_metadata AS extra_metadata_8, h0_.ref_id AS ref_id_9, h0_.ref_entity_name AS ref_entity_name_10, h0_.og_url AS og_url_11, h0_.og_article_author AS og_article_author_12, h0_.og_article_publisher AS og_article_publisher_13, h0_.og_article_section AS og_article_section_14, h0_.twitter_title AS twitter_title_15, h0_.twitter_description AS twitter_description_16, h0_.twitter_site AS twitter_site_17, h0_.twitter_creator AS twitter_creator_18, h0_.og_image_id AS og_image_id_19, h0_.twitter_image_id AS twitter_image_id_20 FROM hg_seo_seo h0_ WHERE h0_.ref_id IS NULL AND h0_.ref_entity_name IS NULL ORDER BY h0_.id DESC LIMIT 1;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      coming_soon_57,
      purchasable_91,
      sold_78,
      id_51,
      position_30
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.name AS name_1,
          p0_.price AS price_2,
          p0_.price_in_euros AS price_in_euros_3,
          p0_.article_number AS article_number_4,
          p0_.total_ml AS total_ml_5,
          p0_.tester AS tester_6,
          p0_.cellofan AS cellofan_7,
          p0_.unboxed AS unboxed_8,
          p0_.hit AS hit_9,
          p0_.fragrance_sample AS fragrance_sample_10,
          p0_.is_on_main_page AS is_on_main_page_11,
          p0_.limited AS limited_12,
          p0_.reloaded AS reloaded_13,
          p0_.discount_hidden AS discount_hidden_14,
          p0_.discount_order_date AS discount_order_date_15,
          p0_.limit_order_date AS limit_order_date_16,
          p0_.novelty_order_date AS novelty_order_date_17,
          p0_.unavailable_soon_order_date AS unavailable_soon_order_date_18,
          p0_.move_first_order_date AS move_first_order_date_19,
          p0_.extra_discount AS extra_discount_20,
          p0_.stock AS stock_21,
          p0_.active AS active_22,
          p0_.available AS available_23,
          p0_.send_to_emag AS send_to_emag_24,
          p0_.emag_visible AS emag_visible_25,
          p0_.bb_visible AS bb_visible_26,
          p0_.sent_to_tharanis AS sent_to_tharanis_27,
          p0_.available_totally AS available_totally_28,
          p0_.ean AS ean_29,
          p0_.position AS position_30,
          p0_.discount AS discount_31,
          p0_.discount_price AS discount_price_32,
          p0_.discount_price_in_euros AS discount_price_in_euros_33,
          p0_.discount_stock AS discount_stock_34,
          p0_.discount_constant AS discount_constant_35,
          p0_.stock_limit AS stock_limit_36,
          p0_.stock_limit_type AS stock_limit_type_37,
          p0_.stock_limit_stock AS stock_limit_stock_38,
          p0_.outlet AS outlet_39,
          p0_.sold AS sold_40,
          p0_.fix_priced AS fix_priced_41,
          p0_.discount_note AS discount_note_42,
          p0_.stock_limit_note AS stock_limit_note_43,
          p0_.arukereso_marketplace_disabled AS arukereso_marketplace_disabled_44,
          p0_.mini_perfume AS mini_perfume_45,
          p0_.minimum_priced AS minimum_priced_46,
          p0_.arukereso_appearance AS arukereso_appearance_47,
          p0_.pepita_appearance AS pepita_appearance_48,
          p0_.refiller AS refiller_49,
          p0_.best_price AS best_price_50,
          p1_.id AS id_51,
          p1_.article_number AS article_number_52,
          p1_.name AS name_53,
          p1_.search_terms AS search_terms_54,
          p1_.year AS year_55,
          p1_.gender AS gender_56,
          p1_.coming_soon AS coming_soon_57,
          p1_.novelty AS novelty_58,
          p1_.discount AS discount_59,
          p1_.unavailable_soon AS unavailable_soon_60,
          p1_.niche AS niche_61,
          p1_.exclusive AS exclusive_62,
          p1_.limited_edition AS limited_edition_63,
          p1_.outlet AS outlet_64,
          p1_.rarity AS rarity_65,
          p1_.available_again AS available_again_66,
          p1_.limited AS limited_67,
          p1_.active AS active_68,
          p1_.info_link AS info_link_69,
          p1_.description AS description_70,
          p1_.fragrance_description AS fragrance_description_71,
          p1_.meta_description AS meta_description_72,
          p1_.meta_keywords AS meta_keywords_73,
          p1_.facebook_description AS facebook_description_74,
          p1_.minimum_price AS minimum_price_75,
          p1_.discounted_minimum_price AS discounted_minimum_price_76,
          p1_.url AS url_77,
          p1_.sold AS sold_78,
          p1_.just_arrived AS just_arrived_79,
          p1_.is_on_main_page AS is_on_main_page_80,
          p1_.discount_order_date AS discount_order_date_81,
          p1_.novelty_order_date AS novelty_order_date_82,
          p1_.unavailable_soon_order_date AS unavailable_soon_order_date_83,
          p1_.move_first_order_date AS move_first_order_date_84,
          p1_.slogan AS slogan_85,
          p1_.price_changed_at AS price_changed_at_86,
          p1_.data_changed_at AS data_changed_at_87,
          p1_.price_for_sort AS price_for_sort_88,
          p1_.introduction_price AS introduction_price_89,
          p1_.special AS special_90,
          p1_.purchasable AS purchasable_91,
          p1_.fix_priced AS fix_priced_92,
          p1_.created_at AS created_at_93,
          p1_.updated_at AS updated_at_94,
          p2_.id AS id_95,
          p2_.name AS name_96,
          p2_.code AS code_97,
          p2_.cosmetics AS cosmetics_98,
          p2_.taska AS taska_99,
          p2_.gift_set AS gift_set_100,
          p2_.hidden AS hidden_101,
          p2_.single_name AS single_name_102,
          p2_.plural_name AS plural_name_103,
          p2_.position AS position_104,
          p2_.`lead` AS lead_105,
          p2_.seo_description AS seo_description_106,
          p2_.title AS title_107,
          b3_.id AS id_108,
          b3_.name AS name_109,
          b3_.short_name AS short_name_110,
          b3_.slug AS slug_111,
          b3_.search_terms AS search_terms_112,
          b3_.text AS text_113,
          b3_.text_female AS text_female_114,
          b3_.text_male AS text_male_115,
          b3_.highlighted AS highlighted_116,
          b3_.main_page_fragrance AS main_page_fragrance_117,
          b3_.highlighted_in_search AS highlighted_in_search_118,
          b3_.is_on_main_page AS is_on_main_page_119,
          b3_.special AS special_120,
          b3_.special_name AS special_name_121,
          b3_.slogan AS slogan_122,
          b3_.`lead` AS lead_123,
          b3_.active AS active_124,
          b3_.exclude_from_arukereso AS exclude_from_arukereso_125,
          f4_.id AS id_126,
          f4_.name AS name_127,
          c5_.id AS id_128,
          c5_.shortening AS shortening_129,
          c5_.description AS description_130,
          c5_.full_name AS full_name_131,
          c5_.short_name AS short_name_132,
          c5_.position AS position_133,
          h6_.id AS id_134,
          h6_.uuid AS uuid_135,
          h6_.location AS location_136,
          h6_.content_type AS content_type_137,
          h6_.metadata AS metadata_138,
          h6_.filesize AS filesize_139,
          h6_.url AS url_140,
          h6_.original_filename AS original_filename_141,
          h6_.deleted AS deleted_142,
          h6_.removed_from_file_system AS removed_from_file_system_143,
          h6_.protected AS protected_144,
          h6_.created_at AS created_at_145,
          h6_.updated_at AS updated_at_146,
          h7_.id AS id_147,
          h7_.rel AS rel_148,
          h7_.internal_name AS internal_name_149,
          h7_.lft AS lft_150,
          h7_.lvl AS lvl_151,
          h7_.rgt AS rgt_152,
          h7_.deleted AS deleted_153,
          h7_.internal AS internal_154,
          h7_.created_at AS created_at_155,
          h7_.updated_at AS updated_at_156,
          h8_.id AS id_157,
          h8_.uuid AS uuid_158,
          h8_.location AS location_159,
          h8_.content_type AS content_type_160,
          h8_.metadata AS metadata_161,
          h8_.filesize AS filesize_162,
          h8_.url AS url_163,
          h8_.original_filename AS original_filename_164,
          h8_.deleted AS deleted_165,
          h8_.removed_from_file_system AS removed_from_file_system_166,
          h8_.protected AS protected_167,
          h8_.created_at AS created_at_168,
          h8_.updated_at AS updated_at_169,
          h9_.id AS id_170,
          h9_.rel AS rel_171,
          h9_.internal_name AS internal_name_172,
          h9_.lft AS lft_173,
          h9_.lvl AS lvl_174,
          h9_.rgt AS rgt_175,
          h9_.deleted AS deleted_176,
          h9_.internal AS internal_177,
          h9_.created_at AS created_at_178,
          h9_.updated_at AS updated_at_179
        FROM
          product_packaging p0_
          INNER JOIN product p1_ ON p0_.product_id = p1_.id
          LEFT JOIN product_category p2_ ON p1_.product_category_id = p2_.id
          INNER JOIN brand b3_ ON p1_.brand_id = b3_.id
          LEFT JOIN fragrance_family f4_ ON p1_.fragrance_family_id = f4_.id
          LEFT JOIN concentration c5_ ON p1_.concentration_id = c5_.id
          LEFT JOIN hg_media_media h6_ ON p1_.image_id = h6_.id
          LEFT JOIN hg_media_folders h7_ ON h6_.folder_id = h7_.id
          LEFT JOIN hg_media_media h8_ ON p1_.hover_image_id = h8_.id
          LEFT JOIN hg_media_folders h9_ ON h8_.folder_id = h9_.id
        WHERE
          p1_.active = 1
          AND p0_.active = 1
          AND (
            p0_.stock_limit = 0
            OR p0_.stock_limit_type = ?
            OR p0_.stock_limit_stock > 0
            OR p1_.coming_soon = 1
          )
          AND p1_.gender IN ('f')
          AND b3_.id IN (22)
        GROUP BY
          p1_.id
      ) dctrn_result_inner
    ORDER BY
      coming_soon_57 ASC,
      purchasable_91 DESC,
      sold_78 DESC,
      id_51 ASC,
      position_30 ASC
  ) dctrn_result
LIMIT
  20