Symfony Profiler

SELECT
  p0_.id AS id_0,
  b1_.id AS id_1,
  b1_.name AS name_2,
  b1_.short_name AS short_name_3,
  COUNT(DISTINCT p2_.id) AS sclr_4,
  p2_.id AS id_5,
  b1_.highlighted AS highlighted_6
FROM
  product_packaging p0_
  INNER JOIN product p2_ ON p0_.product_id = p2_.id
  LEFT JOIN product_category p3_ ON p2_.product_category_id = p3_.id
  INNER JOIN brand b1_ ON p2_.brand_id = b1_.id
  LEFT JOIN fragrance_family f4_ ON p2_.fragrance_family_id = f4_.id
  LEFT JOIN concentration c5_ ON p2_.concentration_id = c5_.id
  LEFT JOIN hg_media_media h6_ ON p2_.image_id = h6_.id
  LEFT JOIN hg_media_folders h7_ ON h6_.folder_id = h7_.id
  LEFT JOIN hg_media_media h8_ ON p2_.hover_image_id = h8_.id
  LEFT JOIN hg_media_folders h9_ ON h8_.folder_id = h9_.id
WHERE
  p2_.active = 1
  AND p0_.active = 1
  AND (
    p0_.stock_limit = 0
    OR p0_.stock_limit_type = ?
    OR p0_.stock_limit_stock > 0
    OR p2_.coming_soon = 1
  )
  AND p3_.id IN (5)
GROUP BY
  b1_.id
ORDER BY
  IF(
    b1_.short_name IS NULL
    OR b1_.short_name = ?,
    b1_.name,
    b1_.short_name
  ) ASC

SELECT p0_.id AS id_0, b1_.id AS id_1, b1_.name AS name_2, b1_.short_name AS short_name_3, COUNT(DISTINCT p2_.id) AS sclr_4, p2_.id AS id_5, b1_.highlighted AS highlighted_6 FROM product_packaging p0_ INNER JOIN product p2_ ON p0_.product_id = p2_.id LEFT JOIN product_category p3_ ON p2_.product_category_id = p3_.id INNER JOIN brand b1_ ON p2_.brand_id = b1_.id LEFT JOIN fragrance_family f4_ ON p2_.fragrance_family_id = f4_.id LEFT JOIN concentration c5_ ON p2_.concentration_id = c5_.id LEFT JOIN hg_media_media h6_ ON p2_.image_id = h6_.id LEFT JOIN hg_media_folders h7_ ON h6_.folder_id = h7_.id LEFT JOIN hg_media_media h8_ ON p2_.hover_image_id = h8_.id LEFT JOIN hg_media_folders h9_ ON h8_.folder_id = h9_.id WHERE p2_.active = 1 AND p0_.active = 1 AND (p0_.stock_limit = 0 OR p0_.stock_limit_type = 'unavailable' OR p0_.stock_limit_stock > 0 OR p2_.coming_soon = 1) AND p3_.id IN (5) GROUP BY b1_.id ORDER BY IF(b1_.short_name IS NULL OR b1_.short_name = '', b1_.name, b1_.short_name) ASC;

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,
  p0_.product_id AS product_id_180,
  p1_.brand_id AS brand_id_181,
  p1_.product_category_id AS product_category_id_182,
  p1_.image_id AS image_id_183,
  p1_.tester_image_id AS tester_image_id_184,
  p1_.hover_image_id AS hover_image_id_185,
  p1_.facebook_image_id AS facebook_image_id_186,
  p1_.concentration_id AS concentration_id_187,
  p1_.fragrance_family_id AS fragrance_family_id_188,
  p1_.price_changer_id AS price_changer_id_189,
  p1_.data_changer_id AS data_changer_id_190,
  b3_.image_id AS image_id_191,
  h6_.folder_id AS folder_id_192,
  h7_.parent_id AS parent_id_193,
  h8_.folder_id AS folder_id_194,
  h9_.parent_id AS parent_id_195
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
  INNER JOIN main_menu_offer m10_ ON p0_.id = m10_.product_packaging_id
  AND (m10_.type = ?)
WHERE
  p1_.active = 1
  AND p0_.active = 1
  AND (
    p0_.stock_limit = 0
    OR p0_.stock_limit_type = ?
    OR p0_.stock_limit_stock > 0
  )
  AND (
    p1_.coming_soon IS NULL
    OR p1_.coming_soon <> 1
  )
ORDER BY
  RAND() ASC
LIMIT
  4

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, p0_.product_id AS product_id_180, p1_.brand_id AS brand_id_181, p1_.product_category_id AS product_category_id_182, p1_.image_id AS image_id_183, p1_.tester_image_id AS tester_image_id_184, p1_.hover_image_id AS hover_image_id_185, p1_.facebook_image_id AS facebook_image_id_186, p1_.concentration_id AS concentration_id_187, p1_.fragrance_family_id AS fragrance_family_id_188, p1_.price_changer_id AS price_changer_id_189, p1_.data_changer_id AS data_changer_id_190, b3_.image_id AS image_id_191, h6_.folder_id AS folder_id_192, h7_.parent_id AS parent_id_193, h8_.folder_id AS folder_id_194, h9_.parent_id AS parent_id_195 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 INNER JOIN main_menu_offer m10_ ON p0_.id = m10_.product_packaging_id AND (m10_.type = 'discount') WHERE p1_.active = 1 AND p0_.active = 1 AND (p0_.stock_limit = 0 OR p0_.stock_limit_type = 'unavailable' OR p0_.stock_limit_stock > 0) AND (p1_.coming_soon IS NULL OR p1_.coming_soon <> 1) ORDER BY RAND() ASC LIMIT 4;

SELECT
  h0_.id AS id_0,
  h0_.lft AS lft_1,
  h0_.lvl AS lvl_2,
  h0_.rgt AS rgt_3,
  h0_.deleted AS deleted_4,
  h0_.hidden_from_nav AS hidden_from_nav_5,
  h0_.ref_entity_name AS ref_entity_name_6,
  h0_.internal_name AS internal_name_7,
  h1_.id AS id_8,
  h1_.lang AS lang_9,
  h1_.online AS online_10,
  h1_.title AS title_11,
  h1_.slug AS slug_12,
  h1_.url AS url_13,
  h1_.weight AS weight_14,
  h1_.created AS created_15,
  h1_.updated AS updated_16,
  h2_.id AS id_17,
  h2_.type AS type_18,
  h2_.owner AS owner_19,
  h2_.created AS created_20,
  h2_.updated AS updated_21,
  h2_.ref_id AS ref_id_22,
  h2_.ref_entity_name AS ref_entity_name_23,
  h0_.parent_id AS parent_id_24,
  h1_.node_id AS node_id_25,
  h1_.public_node_version_id AS public_node_version_id_26,
  h2_.node_translation_id AS node_translation_id_27,
  h2_.origin_id AS origin_id_28
FROM
  hg_node_nodes h0_
  INNER JOIN hg_node_node_translations h1_ ON h0_.id = h1_.node_id
  LEFT JOIN hg_node_node_versions h2_ ON h1_.public_node_version_id = h2_.id
  AND (
    h1_.public_node_version_id = h2_.id
  )
WHERE
  h0_.deleted = 0
  AND h0_.internal_name = ?
  AND h1_.lang = ?
  AND h1_.online = 1
ORDER BY
  h1_.weight ASC,
  h1_.title ASC

SELECT h0_.id AS id_0, h0_.lft AS lft_1, h0_.lvl AS lvl_2, h0_.rgt AS rgt_3, h0_.deleted AS deleted_4, h0_.hidden_from_nav AS hidden_from_nav_5, h0_.ref_entity_name AS ref_entity_name_6, h0_.internal_name AS internal_name_7, h1_.id AS id_8, h1_.lang AS lang_9, h1_.online AS online_10, h1_.title AS title_11, h1_.slug AS slug_12, h1_.url AS url_13, h1_.weight AS weight_14, h1_.created AS created_15, h1_.updated AS updated_16, h2_.id AS id_17, h2_.type AS type_18, h2_.owner AS owner_19, h2_.created AS created_20, h2_.updated AS updated_21, h2_.ref_id AS ref_id_22, h2_.ref_entity_name AS ref_entity_name_23, h0_.parent_id AS parent_id_24, h1_.node_id AS node_id_25, h1_.public_node_version_id AS public_node_version_id_26, h2_.node_translation_id AS node_translation_id_27, h2_.origin_id AS origin_id_28 FROM hg_node_nodes h0_ INNER JOIN hg_node_node_translations h1_ ON h0_.id = h1_.node_id LEFT JOIN hg_node_node_versions h2_ ON h1_.public_node_version_id = h2_.id AND (h1_.public_node_version_id = h2_.id) WHERE h0_.deleted = 0 AND h0_.internal_name = 'homepage' AND h1_.lang = 'hu' AND h1_.online = 1 ORDER BY h1_.weight ASC, h1_.title ASC;

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

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      CONCAT(b0_.name, ?, p1_.name) AS sclr_0,
      p2_.id AS id_1,
      p2_.name AS name_2,
      p2_.price AS price_3,
      p2_.price_in_euros AS price_in_euros_4,
      p2_.article_number AS article_number_5,
      p2_.total_ml AS total_ml_6,
      p2_.tester AS tester_7,
      p2_.cellofan AS cellofan_8,
      p2_.unboxed AS unboxed_9,
      p2_.hit AS hit_10,
      p2_.fragrance_sample AS fragrance_sample_11,
      p2_.is_on_main_page AS is_on_main_page_12,
      p2_.limited AS limited_13,
      p2_.reloaded AS reloaded_14,
      p2_.discount_hidden AS discount_hidden_15,
      p2_.discount_order_date AS discount_order_date_16,
      p2_.limit_order_date AS limit_order_date_17,
      p2_.novelty_order_date AS novelty_order_date_18,
      p2_.unavailable_soon_order_date AS unavailable_soon_order_date_19,
      p2_.move_first_order_date AS move_first_order_date_20,
      p2_.extra_discount AS extra_discount_21,
      p2_.stock AS stock_22,
      p2_.active AS active_23,
      p2_.available AS available_24,
      p2_.send_to_emag AS send_to_emag_25,
      p2_.emag_visible AS emag_visible_26,
      p2_.bb_visible AS bb_visible_27,
      p2_.sent_to_tharanis AS sent_to_tharanis_28,
      p2_.available_totally AS available_totally_29,
      p2_.ean AS ean_30,
      p2_.position AS position_31,
      p2_.discount AS discount_32,
      p2_.discount_price AS discount_price_33,
      p2_.discount_price_in_euros AS discount_price_in_euros_34,
      p2_.discount_stock AS discount_stock_35,
      p2_.discount_constant AS discount_constant_36,
      p2_.stock_limit AS stock_limit_37,
      p2_.stock_limit_type AS stock_limit_type_38,
      p2_.stock_limit_stock AS stock_limit_stock_39,
      p2_.outlet AS outlet_40,
      p2_.sold AS sold_41,
      p2_.fix_priced AS fix_priced_42,
      p2_.discount_note AS discount_note_43,
      p2_.stock_limit_note AS stock_limit_note_44,
      p2_.arukereso_marketplace_disabled AS arukereso_marketplace_disabled_45,
      p2_.mini_perfume AS mini_perfume_46,
      p2_.minimum_priced AS minimum_priced_47,
      p2_.arukereso_appearance AS arukereso_appearance_48,
      p2_.pepita_appearance AS pepita_appearance_49,
      p2_.refiller AS refiller_50,
      p2_.best_price AS best_price_51,
      p1_.id AS id_52,
      p1_.article_number AS article_number_53,
      p1_.name AS name_54,
      p1_.search_terms AS search_terms_55,
      p1_.year AS year_56,
      p1_.gender AS gender_57,
      p1_.coming_soon AS coming_soon_58,
      p1_.novelty AS novelty_59,
      p1_.discount AS discount_60,
      p1_.unavailable_soon AS unavailable_soon_61,
      p1_.niche AS niche_62,
      p1_.exclusive AS exclusive_63,
      p1_.limited_edition AS limited_edition_64,
      p1_.outlet AS outlet_65,
      p1_.rarity AS rarity_66,
      p1_.available_again AS available_again_67,
      p1_.limited AS limited_68,
      p1_.active AS active_69,
      p1_.info_link AS info_link_70,
      p1_.description AS description_71,
      p1_.fragrance_description AS fragrance_description_72,
      p1_.meta_description AS meta_description_73,
      p1_.meta_keywords AS meta_keywords_74,
      p1_.facebook_description AS facebook_description_75,
      p1_.minimum_price AS minimum_price_76,
      p1_.discounted_minimum_price AS discounted_minimum_price_77,
      p1_.url AS url_78,
      p1_.sold AS sold_79,
      p1_.just_arrived AS just_arrived_80,
      p1_.is_on_main_page AS is_on_main_page_81,
      p1_.discount_order_date AS discount_order_date_82,
      p1_.novelty_order_date AS novelty_order_date_83,
      p1_.unavailable_soon_order_date AS unavailable_soon_order_date_84,
      p1_.move_first_order_date AS move_first_order_date_85,
      p1_.slogan AS slogan_86,
      p1_.price_changed_at AS price_changed_at_87,
      p1_.data_changed_at AS data_changed_at_88,
      p1_.price_for_sort AS price_for_sort_89,
      p1_.introduction_price AS introduction_price_90,
      p1_.special AS special_91,
      p1_.purchasable AS purchasable_92,
      p1_.fix_priced AS fix_priced_93,
      p1_.created_at AS created_at_94,
      p1_.updated_at AS updated_at_95,
      p3_.id AS id_96,
      p3_.name AS name_97,
      p3_.code AS code_98,
      p3_.cosmetics AS cosmetics_99,
      p3_.taska AS taska_100,
      p3_.gift_set AS gift_set_101,
      p3_.hidden AS hidden_102,
      p3_.single_name AS single_name_103,
      p3_.plural_name AS plural_name_104,
      p3_.position AS position_105,
      p3_.`lead` AS lead_106,
      p3_.seo_description AS seo_description_107,
      p3_.title AS title_108,
      b0_.id AS id_109,
      b0_.name AS name_110,
      b0_.short_name AS short_name_111,
      b0_.slug AS slug_112,
      b0_.search_terms AS search_terms_113,
      b0_.text AS text_114,
      b0_.text_female AS text_female_115,
      b0_.text_male AS text_male_116,
      b0_.highlighted AS highlighted_117,
      b0_.main_page_fragrance AS main_page_fragrance_118,
      b0_.highlighted_in_search AS highlighted_in_search_119,
      b0_.is_on_main_page AS is_on_main_page_120,
      b0_.special AS special_121,
      b0_.special_name AS special_name_122,
      b0_.slogan AS slogan_123,
      b0_.`lead` AS lead_124,
      b0_.active AS active_125,
      b0_.exclude_from_arukereso AS exclude_from_arukereso_126,
      f4_.id AS id_127,
      f4_.name AS name_128,
      c5_.id AS id_129,
      c5_.shortening AS shortening_130,
      c5_.description AS description_131,
      c5_.full_name AS full_name_132,
      c5_.short_name AS short_name_133,
      c5_.position AS position_134,
      h6_.id AS id_135,
      h6_.uuid AS uuid_136,
      h6_.location AS location_137,
      h6_.content_type AS content_type_138,
      h6_.metadata AS metadata_139,
      h6_.filesize AS filesize_140,
      h6_.url AS url_141,
      h6_.original_filename AS original_filename_142,
      h6_.deleted AS deleted_143,
      h6_.removed_from_file_system AS removed_from_file_system_144,
      h6_.protected AS protected_145,
      h6_.created_at AS created_at_146,
      h6_.updated_at AS updated_at_147,
      h7_.id AS id_148,
      h7_.rel AS rel_149,
      h7_.internal_name AS internal_name_150,
      h7_.lft AS lft_151,
      h7_.lvl AS lvl_152,
      h7_.rgt AS rgt_153,
      h7_.deleted AS deleted_154,
      h7_.internal AS internal_155,
      h7_.created_at AS created_at_156,
      h7_.updated_at AS updated_at_157,
      h8_.id AS id_158,
      h8_.uuid AS uuid_159,
      h8_.location AS location_160,
      h8_.content_type AS content_type_161,
      h8_.metadata AS metadata_162,
      h8_.filesize AS filesize_163,
      h8_.url AS url_164,
      h8_.original_filename AS original_filename_165,
      h8_.deleted AS deleted_166,
      h8_.removed_from_file_system AS removed_from_file_system_167,
      h8_.protected AS protected_168,
      h8_.created_at AS created_at_169,
      h8_.updated_at AS updated_at_170,
      h9_.id AS id_171,
      h9_.rel AS rel_172,
      h9_.internal_name AS internal_name_173,
      h9_.lft AS lft_174,
      h9_.lvl AS lvl_175,
      h9_.rgt AS rgt_176,
      h9_.deleted AS deleted_177,
      h9_.internal AS internal_178,
      h9_.created_at AS created_at_179,
      h9_.updated_at AS updated_at_180
    FROM
      product_packaging p2_
      INNER JOIN product p1_ ON p2_.product_id = p1_.id
      LEFT JOIN product_category p3_ ON p1_.product_category_id = p3_.id
      INNER JOIN brand b0_ ON p1_.brand_id = b0_.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 p2_.active = 1
      AND (
        p2_.stock_limit = 0
        OR p2_.stock_limit_type = ?
        OR p2_.stock_limit_stock > 0
        OR p1_.coming_soon = 1
      )
      AND b0_.id IN (19)
      AND p3_.id IN (5)
    GROUP BY
      p1_.id
    ORDER BY
      p1_.coming_soon ASC,
      p1_.purchasable DESC,
      p2_.move_first_order_date DESC,
      p1_.move_first_order_date DESC,
      p1_.updated_at DESC,
      sclr_0 ASC
  ) dctrn_table