Symfony Profiler

Query Metrics

114 Database Queries

36 Different statements

134.56 ms Query time

0 Invalid entities

Grouped Statements

Time▼	Count	Info
26.55 ms (19.73%)	5	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 Parameters: [`"discount" "unavailable"`] View formatted query View runnable query Explain query 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;
20.96 ms (15.57%)	21	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 Parameters: [`"homepage" "hu"`] View formatted query View runnable query Explain query 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;
14.68 ms (10.91%)	7	SELECT COUNT(p0_.id) AS sclr_0, FORMAT(AVG(p0_.rating), 2) AS sclr_1 FROM product_rating p0_ WHERE p0_.product_id = ? Parameters: [`47332`] View formatted query View runnable query Explain query SELECT COUNT(p0_.id) AS sclr_0, FORMAT( AVG(p0_.rating), 2 ) AS sclr_1 FROM product_rating p0_ WHERE p0_.product_id = ? SELECT COUNT(p0_.id) AS sclr_0, FORMAT(AVG(p0_.rating), 2) AS sclr_1 FROM product_rating p0_ WHERE p0_.product_id = 47332;
10.09 ms (7.50%)	7	SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_in_euros AS price_in_euros_4, t0.article_number AS article_number_5, t0.total_ml AS total_ml_6, t0.tester AS tester_7, t0.cellofan AS cellofan_8, t0.unboxed AS unboxed_9, t0.hit AS hit_10, t0.fragrance_sample AS fragrance_sample_11, t0.is_on_main_page AS is_on_main_page_12, t0.limited AS limited_13, t0.reloaded AS reloaded_14, t0.discount_hidden AS discount_hidden_15, t0.discount_order_date AS discount_order_date_16, t0.limit_order_date AS limit_order_date_17, t0.novelty_order_date AS novelty_order_date_18, t0.unavailable_soon_order_date AS unavailable_soon_order_date_19, t0.move_first_order_date AS move_first_order_date_20, t0.extra_discount AS extra_discount_21, t0.stock AS stock_22, t0.active AS active_23, t0.available AS available_24, t0.send_to_emag AS send_to_emag_25, t0.emag_visible AS emag_visible_26, t0.bb_visible AS bb_visible_27, t0.sent_to_tharanis AS sent_to_tharanis_28, t0.available_totally AS available_totally_29, t0.ean AS ean_30, t0.position AS position_31, t0.discount AS discount_32, t0.discount_price AS discount_price_33, t0.discount_price_in_euros AS discount_price_in_euros_34, t0.discount_stock AS discount_stock_35, t0.discount_constant AS discount_constant_36, t0.stock_limit AS stock_limit_37, t0.stock_limit_type AS stock_limit_type_38, t0.stock_limit_stock AS stock_limit_stock_39, t0.outlet AS outlet_40, t0.sold AS sold_41, t0.fix_priced AS fix_priced_42, t0.discount_note AS discount_note_43, t0.stock_limit_note AS stock_limit_note_44, t0.arukereso_marketplace_disabled AS arukereso_marketplace_disabled_45, t0.mini_perfume AS mini_perfume_46, t0.minimum_priced AS minimum_priced_47, t0.arukereso_appearance AS arukereso_appearance_48, t0.pepita_appearance AS pepita_appearance_49, t0.refiller AS refiller_50, t0.best_price AS best_price_51, t0.product_id AS product_id_52 FROM product_packaging t0 WHERE t0.product_id = ? ORDER BY t0.position ASC Parameters: [`47332`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_in_euros AS price_in_euros_4, t0.article_number AS article_number_5, t0.total_ml AS total_ml_6, t0.tester AS tester_7, t0.cellofan AS cellofan_8, t0.unboxed AS unboxed_9, t0.hit AS hit_10, t0.fragrance_sample AS fragrance_sample_11, t0.is_on_main_page AS is_on_main_page_12, t0.limited AS limited_13, t0.reloaded AS reloaded_14, t0.discount_hidden AS discount_hidden_15, t0.discount_order_date AS discount_order_date_16, t0.limit_order_date AS limit_order_date_17, t0.novelty_order_date AS novelty_order_date_18, t0.unavailable_soon_order_date AS unavailable_soon_order_date_19, t0.move_first_order_date AS move_first_order_date_20, t0.extra_discount AS extra_discount_21, t0.stock AS stock_22, t0.active AS active_23, t0.available AS available_24, t0.send_to_emag AS send_to_emag_25, t0.emag_visible AS emag_visible_26, t0.bb_visible AS bb_visible_27, t0.sent_to_tharanis AS sent_to_tharanis_28, t0.available_totally AS available_totally_29, t0.ean AS ean_30, t0.position AS position_31, t0.discount AS discount_32, t0.discount_price AS discount_price_33, t0.discount_price_in_euros AS discount_price_in_euros_34, t0.discount_stock AS discount_stock_35, t0.discount_constant AS discount_constant_36, t0.stock_limit AS stock_limit_37, t0.stock_limit_type AS stock_limit_type_38, t0.stock_limit_stock AS stock_limit_stock_39, t0.outlet AS outlet_40, t0.sold AS sold_41, t0.fix_priced AS fix_priced_42, t0.discount_note AS discount_note_43, t0.stock_limit_note AS stock_limit_note_44, t0.arukereso_marketplace_disabled AS arukereso_marketplace_disabled_45, t0.mini_perfume AS mini_perfume_46, t0.minimum_priced AS minimum_priced_47, t0.arukereso_appearance AS arukereso_appearance_48, t0.pepita_appearance AS pepita_appearance_49, t0.refiller AS refiller_50, t0.best_price AS best_price_51, t0.product_id AS product_id_52 FROM product_packaging t0 WHERE t0.product_id = ? ORDER BY t0.position ASC SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_in_euros AS price_in_euros_4, t0.article_number AS article_number_5, t0.total_ml AS total_ml_6, t0.tester AS tester_7, t0.cellofan AS cellofan_8, t0.unboxed AS unboxed_9, t0.hit AS hit_10, t0.fragrance_sample AS fragrance_sample_11, t0.is_on_main_page AS is_on_main_page_12, t0.limited AS limited_13, t0.reloaded AS reloaded_14, t0.discount_hidden AS discount_hidden_15, t0.discount_order_date AS discount_order_date_16, t0.limit_order_date AS limit_order_date_17, t0.novelty_order_date AS novelty_order_date_18, t0.unavailable_soon_order_date AS unavailable_soon_order_date_19, t0.move_first_order_date AS move_first_order_date_20, t0.extra_discount AS extra_discount_21, t0.stock AS stock_22, t0.active AS active_23, t0.available AS available_24, t0.send_to_emag AS send_to_emag_25, t0.emag_visible AS emag_visible_26, t0.bb_visible AS bb_visible_27, t0.sent_to_tharanis AS sent_to_tharanis_28, t0.available_totally AS available_totally_29, t0.ean AS ean_30, t0.position AS position_31, t0.discount AS discount_32, t0.discount_price AS discount_price_33, t0.discount_price_in_euros AS discount_price_in_euros_34, t0.discount_stock AS discount_stock_35, t0.discount_constant AS discount_constant_36, t0.stock_limit AS stock_limit_37, t0.stock_limit_type AS stock_limit_type_38, t0.stock_limit_stock AS stock_limit_stock_39, t0.outlet AS outlet_40, t0.sold AS sold_41, t0.fix_priced AS fix_priced_42, t0.discount_note AS discount_note_43, t0.stock_limit_note AS stock_limit_note_44, t0.arukereso_marketplace_disabled AS arukereso_marketplace_disabled_45, t0.mini_perfume AS mini_perfume_46, t0.minimum_priced AS minimum_priced_47, t0.arukereso_appearance AS arukereso_appearance_48, t0.pepita_appearance AS pepita_appearance_49, t0.refiller AS refiller_50, t0.best_price AS best_price_51, t0.product_id AS product_id_52 FROM product_packaging t0 WHERE t0.product_id = 47332 ORDER BY t0.position ASC;
8.11 ms (6.03%)	6	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.id = ? Parameters: [`47332`] View formatted query View runnable query Explain query 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.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.id = 47332;
7.35 ms (5.47%)	6	SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_in_euros AS price_in_euros_4, t0.article_number AS article_number_5, t0.total_ml AS total_ml_6, t0.tester AS tester_7, t0.cellofan AS cellofan_8, t0.unboxed AS unboxed_9, t0.hit AS hit_10, t0.fragrance_sample AS fragrance_sample_11, t0.is_on_main_page AS is_on_main_page_12, t0.limited AS limited_13, t0.reloaded AS reloaded_14, t0.discount_hidden AS discount_hidden_15, t0.discount_order_date AS discount_order_date_16, t0.limit_order_date AS limit_order_date_17, t0.novelty_order_date AS novelty_order_date_18, t0.unavailable_soon_order_date AS unavailable_soon_order_date_19, t0.move_first_order_date AS move_first_order_date_20, t0.extra_discount AS extra_discount_21, t0.stock AS stock_22, t0.active AS active_23, t0.available AS available_24, t0.send_to_emag AS send_to_emag_25, t0.emag_visible AS emag_visible_26, t0.bb_visible AS bb_visible_27, t0.sent_to_tharanis AS sent_to_tharanis_28, t0.available_totally AS available_totally_29, t0.ean AS ean_30, t0.position AS position_31, t0.discount AS discount_32, t0.discount_price AS discount_price_33, t0.discount_price_in_euros AS discount_price_in_euros_34, t0.discount_stock AS discount_stock_35, t0.discount_constant AS discount_constant_36, t0.stock_limit AS stock_limit_37, t0.stock_limit_type AS stock_limit_type_38, t0.stock_limit_stock AS stock_limit_stock_39, t0.outlet AS outlet_40, t0.sold AS sold_41, t0.fix_priced AS fix_priced_42, t0.discount_note AS discount_note_43, t0.stock_limit_note AS stock_limit_note_44, t0.arukereso_marketplace_disabled AS arukereso_marketplace_disabled_45, t0.mini_perfume AS mini_perfume_46, t0.minimum_priced AS minimum_priced_47, t0.arukereso_appearance AS arukereso_appearance_48, t0.pepita_appearance AS pepita_appearance_49, t0.refiller AS refiller_50, t0.best_price AS best_price_51, t0.product_id AS product_id_52 FROM product_packaging t0 WHERE t0.id = ? Parameters: [`16201`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_in_euros AS price_in_euros_4, t0.article_number AS article_number_5, t0.total_ml AS total_ml_6, t0.tester AS tester_7, t0.cellofan AS cellofan_8, t0.unboxed AS unboxed_9, t0.hit AS hit_10, t0.fragrance_sample AS fragrance_sample_11, t0.is_on_main_page AS is_on_main_page_12, t0.limited AS limited_13, t0.reloaded AS reloaded_14, t0.discount_hidden AS discount_hidden_15, t0.discount_order_date AS discount_order_date_16, t0.limit_order_date AS limit_order_date_17, t0.novelty_order_date AS novelty_order_date_18, t0.unavailable_soon_order_date AS unavailable_soon_order_date_19, t0.move_first_order_date AS move_first_order_date_20, t0.extra_discount AS extra_discount_21, t0.stock AS stock_22, t0.active AS active_23, t0.available AS available_24, t0.send_to_emag AS send_to_emag_25, t0.emag_visible AS emag_visible_26, t0.bb_visible AS bb_visible_27, t0.sent_to_tharanis AS sent_to_tharanis_28, t0.available_totally AS available_totally_29, t0.ean AS ean_30, t0.position AS position_31, t0.discount AS discount_32, t0.discount_price AS discount_price_33, t0.discount_price_in_euros AS discount_price_in_euros_34, t0.discount_stock AS discount_stock_35, t0.discount_constant AS discount_constant_36, t0.stock_limit AS stock_limit_37, t0.stock_limit_type AS stock_limit_type_38, t0.stock_limit_stock AS stock_limit_stock_39, t0.outlet AS outlet_40, t0.sold AS sold_41, t0.fix_priced AS fix_priced_42, t0.discount_note AS discount_note_43, t0.stock_limit_note AS stock_limit_note_44, t0.arukereso_marketplace_disabled AS arukereso_marketplace_disabled_45, t0.mini_perfume AS mini_perfume_46, t0.minimum_priced AS minimum_priced_47, t0.arukereso_appearance AS arukereso_appearance_48, t0.pepita_appearance AS pepita_appearance_49, t0.refiller AS refiller_50, t0.best_price AS best_price_51, t0.product_id AS product_id_52 FROM product_packaging t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_in_euros AS price_in_euros_4, t0.article_number AS article_number_5, t0.total_ml AS total_ml_6, t0.tester AS tester_7, t0.cellofan AS cellofan_8, t0.unboxed AS unboxed_9, t0.hit AS hit_10, t0.fragrance_sample AS fragrance_sample_11, t0.is_on_main_page AS is_on_main_page_12, t0.limited AS limited_13, t0.reloaded AS reloaded_14, t0.discount_hidden AS discount_hidden_15, t0.discount_order_date AS discount_order_date_16, t0.limit_order_date AS limit_order_date_17, t0.novelty_order_date AS novelty_order_date_18, t0.unavailable_soon_order_date AS unavailable_soon_order_date_19, t0.move_first_order_date AS move_first_order_date_20, t0.extra_discount AS extra_discount_21, t0.stock AS stock_22, t0.active AS active_23, t0.available AS available_24, t0.send_to_emag AS send_to_emag_25, t0.emag_visible AS emag_visible_26, t0.bb_visible AS bb_visible_27, t0.sent_to_tharanis AS sent_to_tharanis_28, t0.available_totally AS available_totally_29, t0.ean AS ean_30, t0.position AS position_31, t0.discount AS discount_32, t0.discount_price AS discount_price_33, t0.discount_price_in_euros AS discount_price_in_euros_34, t0.discount_stock AS discount_stock_35, t0.discount_constant AS discount_constant_36, t0.stock_limit AS stock_limit_37, t0.stock_limit_type AS stock_limit_type_38, t0.stock_limit_stock AS stock_limit_stock_39, t0.outlet AS outlet_40, t0.sold AS sold_41, t0.fix_priced AS fix_priced_42, t0.discount_note AS discount_note_43, t0.stock_limit_note AS stock_limit_note_44, t0.arukereso_marketplace_disabled AS arukereso_marketplace_disabled_45, t0.mini_perfume AS mini_perfume_46, t0.minimum_priced AS minimum_priced_47, t0.arukereso_appearance AS arukereso_appearance_48, t0.pepita_appearance AS pepita_appearance_49, t0.refiller AS refiller_50, t0.best_price AS best_price_51, t0.product_id AS product_id_52 FROM product_packaging t0 WHERE t0.id = 16201;
4.95 ms (3.68%)	7	SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.location AS location_3, t0.content_type AS content_type_4, t0.metadata AS metadata_5, t0.filesize AS filesize_6, t0.url AS url_7, t0.original_filename AS original_filename_8, t0.deleted AS deleted_9, t0.removed_from_file_system AS removed_from_file_system_10, t0.protected AS protected_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.folder_id AS folder_id_14 FROM hg_media_media t0 WHERE t0.id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.location AS location_3, t0.content_type AS content_type_4, t0.metadata AS metadata_5, t0.filesize AS filesize_6, t0.url AS url_7, t0.original_filename AS original_filename_8, t0.deleted AS deleted_9, t0.removed_from_file_system AS removed_from_file_system_10, t0.protected AS protected_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.folder_id AS folder_id_14 FROM hg_media_media t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.location AS location_3, t0.content_type AS content_type_4, t0.metadata AS metadata_5, t0.filesize AS filesize_6, t0.url AS url_7, t0.original_filename AS original_filename_8, t0.deleted AS deleted_9, t0.removed_from_file_system AS removed_from_file_system_10, t0.protected AS protected_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.folder_id AS folder_id_14 FROM hg_media_media t0 WHERE t0.id = 9;
4.79 ms (3.56%)	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 Parameters: [`"top10" 1`] View formatted query View runnable query Explain query 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 = 'top10' AND t0.active = 1 LIMIT 1;
4.08 ms (3.03%)	10	SELECT t0.id AS id_1, t0.title AS title_2, t0.page_title AS page_title_3 FROM app_topten_pages t0 WHERE t0.id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.page_title AS page_title_3 FROM app_topten_pages t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.title AS title_2, t0.page_title AS page_title_3 FROM app_topten_pages t0 WHERE t0.id = 8;
4.00 ms (2.98%)	1	SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.short_name AS short_name_2, b0_.slug AS slug_3, b0_.search_terms AS search_terms_4, b0_.text AS text_5, b0_.text_female AS text_female_6, b0_.text_male AS text_male_7, b0_.highlighted AS highlighted_8, b0_.main_page_fragrance AS main_page_fragrance_9, b0_.highlighted_in_search AS highlighted_in_search_10, b0_.is_on_main_page AS is_on_main_page_11, b0_.special AS special_12, b0_.special_name AS special_name_13, b0_.slogan AS slogan_14, b0_.`lead` AS lead_15, b0_.active AS active_16, b0_.exclude_from_arukereso AS exclude_from_arukereso_17, b0_.image_id AS image_id_18 FROM brand b0_ WHERE b0_.active = 1 ORDER BY b0_.name ASC Parameters: [] View formatted query View runnable query Explain query SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.short_name AS short_name_2, b0_.slug AS slug_3, b0_.search_terms AS search_terms_4, b0_.text AS text_5, b0_.text_female AS text_female_6, b0_.text_male AS text_male_7, b0_.highlighted AS highlighted_8, b0_.main_page_fragrance AS main_page_fragrance_9, b0_.highlighted_in_search AS highlighted_in_search_10, b0_.is_on_main_page AS is_on_main_page_11, b0_.special AS special_12, b0_.special_name AS special_name_13, b0_.slogan AS slogan_14, b0_.`lead` AS lead_15, b0_.active AS active_16, b0_.exclude_from_arukereso AS exclude_from_arukereso_17, b0_.image_id AS image_id_18 FROM brand b0_ WHERE b0_.active = 1 ORDER BY b0_.name ASC SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.short_name AS short_name_2, b0_.slug AS slug_3, b0_.search_terms AS search_terms_4, b0_.text AS text_5, b0_.text_female AS text_female_6, b0_.text_male AS text_male_7, b0_.highlighted AS highlighted_8, b0_.main_page_fragrance AS main_page_fragrance_9, b0_.highlighted_in_search AS highlighted_in_search_10, b0_.is_on_main_page AS is_on_main_page_11, b0_.special AS special_12, b0_.special_name AS special_name_13, b0_.slogan AS slogan_14, b0_.`lead` AS lead_15, b0_.active AS active_16, b0_.exclude_from_arukereso AS exclude_from_arukereso_17, b0_.image_id AS image_id_18 FROM brand b0_ WHERE b0_.active = 1 ORDER BY b0_.name ASC;
3.61 ms (2.68%)	10	SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.content AS content_4, t0.priority AS priority_5, t0.active AS active_6, t0.highlighted AS highlighted_7, t0.new_badge AS new_badge_8, t0.red_letters AS red_letters_9, t0.strong_letters AS strong_letters_10, t0.label AS label_11, t0.position AS position_12 FROM main_menu_item_entity t0 WHERE t0.code = ? LIMIT 1 Parameters: [`"female"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.content AS content_4, t0.priority AS priority_5, t0.active AS active_6, t0.highlighted AS highlighted_7, t0.new_badge AS new_badge_8, t0.red_letters AS red_letters_9, t0.strong_letters AS strong_letters_10, t0.label AS label_11, t0.position AS position_12 FROM main_menu_item_entity t0 WHERE t0.code = ? LIMIT 1 SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.content AS content_4, t0.priority AS priority_5, t0.active AS active_6, t0.highlighted AS highlighted_7, t0.new_badge AS new_badge_8, t0.red_letters AS red_letters_9, t0.strong_letters AS strong_letters_10, t0.label AS label_11, t0.position AS position_12 FROM main_menu_item_entity t0 WHERE t0.code = 'female' LIMIT 1;
2.55 ms (1.90%)	3	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.id = ? Parameters: [`447`] View formatted query View runnable query Explain query 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.id = ? 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.id = 447;
2.51 ms (1.87%)	3	SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.place AS place_2, p0_.url AS url_3, p0_.start_time AS start_time_4, p0_.end_time AS end_time_5, p0_.priority AS priority_6, p0_.new_window AS new_window_7, p0_.image_alt AS image_alt_8, p0_.image_title AS image_title_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, h1_.id AS id_12, h1_.uuid AS uuid_13, h1_.location AS location_14, h1_.content_type AS content_type_15, h1_.metadata AS metadata_16, h1_.filesize AS filesize_17, h1_.url AS url_18, h1_.original_filename AS original_filename_19, h1_.deleted AS deleted_20, h1_.removed_from_file_system AS removed_from_file_system_21, h1_.protected AS protected_22, h1_.created_at AS created_at_23, h1_.updated_at AS updated_at_24, h2_.id AS id_25, h2_.uuid AS uuid_26, h2_.location AS location_27, h2_.content_type AS content_type_28, h2_.metadata AS metadata_29, h2_.filesize AS filesize_30, h2_.url AS url_31, h2_.original_filename AS original_filename_32, h2_.deleted AS deleted_33, h2_.removed_from_file_system AS removed_from_file_system_34, h2_.protected AS protected_35, h2_.created_at AS created_at_36, h2_.updated_at AS updated_at_37, p0_.image_id AS image_id_38, p0_.hover_image_id AS hover_image_id_39, h1_.folder_id AS folder_id_40, h2_.folder_id AS folder_id_41 FROM placed_banner p0_ LEFT JOIN hg_media_media h1_ ON p0_.image_id = h1_.id LEFT JOIN hg_media_media h2_ ON p0_.hover_image_id = h2_.id WHERE p0_.place = ? AND (p0_.start_time IS NULL OR p0_.start_time <= ?) AND (p0_.end_time IS NULL OR p0_.end_time >= ?) Parameters: [`"vegtelen1" "2026-01-31 01:44:12" "2026-01-31 01:44:12"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.place AS place_2, p0_.url AS url_3, p0_.start_time AS start_time_4, p0_.end_time AS end_time_5, p0_.priority AS priority_6, p0_.new_window AS new_window_7, p0_.image_alt AS image_alt_8, p0_.image_title AS image_title_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, h1_.id AS id_12, h1_.uuid AS uuid_13, h1_.location AS location_14, h1_.content_type AS content_type_15, h1_.metadata AS metadata_16, h1_.filesize AS filesize_17, h1_.url AS url_18, h1_.original_filename AS original_filename_19, h1_.deleted AS deleted_20, h1_.removed_from_file_system AS removed_from_file_system_21, h1_.protected AS protected_22, h1_.created_at AS created_at_23, h1_.updated_at AS updated_at_24, h2_.id AS id_25, h2_.uuid AS uuid_26, h2_.location AS location_27, h2_.content_type AS content_type_28, h2_.metadata AS metadata_29, h2_.filesize AS filesize_30, h2_.url AS url_31, h2_.original_filename AS original_filename_32, h2_.deleted AS deleted_33, h2_.removed_from_file_system AS removed_from_file_system_34, h2_.protected AS protected_35, h2_.created_at AS created_at_36, h2_.updated_at AS updated_at_37, p0_.image_id AS image_id_38, p0_.hover_image_id AS hover_image_id_39, h1_.folder_id AS folder_id_40, h2_.folder_id AS folder_id_41 FROM placed_banner p0_ LEFT JOIN hg_media_media h1_ ON p0_.image_id = h1_.id LEFT JOIN hg_media_media h2_ ON p0_.hover_image_id = h2_.id WHERE p0_.place = ? AND ( p0_.start_time IS NULL OR p0_.start_time <= ? ) AND ( p0_.end_time IS NULL OR p0_.end_time >= ? ) SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.place AS place_2, p0_.url AS url_3, p0_.start_time AS start_time_4, p0_.end_time AS end_time_5, p0_.priority AS priority_6, p0_.new_window AS new_window_7, p0_.image_alt AS image_alt_8, p0_.image_title AS image_title_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, h1_.id AS id_12, h1_.uuid AS uuid_13, h1_.location AS location_14, h1_.content_type AS content_type_15, h1_.metadata AS metadata_16, h1_.filesize AS filesize_17, h1_.url AS url_18, h1_.original_filename AS original_filename_19, h1_.deleted AS deleted_20, h1_.removed_from_file_system AS removed_from_file_system_21, h1_.protected AS protected_22, h1_.created_at AS created_at_23, h1_.updated_at AS updated_at_24, h2_.id AS id_25, h2_.uuid AS uuid_26, h2_.location AS location_27, h2_.content_type AS content_type_28, h2_.metadata AS metadata_29, h2_.filesize AS filesize_30, h2_.url AS url_31, h2_.original_filename AS original_filename_32, h2_.deleted AS deleted_33, h2_.removed_from_file_system AS removed_from_file_system_34, h2_.protected AS protected_35, h2_.created_at AS created_at_36, h2_.updated_at AS updated_at_37, p0_.image_id AS image_id_38, p0_.hover_image_id AS hover_image_id_39, h1_.folder_id AS folder_id_40, h2_.folder_id AS folder_id_41 FROM placed_banner p0_ LEFT JOIN hg_media_media h1_ ON p0_.image_id = h1_.id LEFT JOIN hg_media_media h2_ ON p0_.hover_image_id = h2_.id WHERE p0_.place = 'vegtelen1' AND (p0_.start_time IS NULL OR p0_.start_time <= '2026-01-31 01:44:12') AND (p0_.end_time IS NULL OR p0_.end_time >= '2026-01-31 01:44:12');
2.42 ms (1.80%)	1	SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.display_from AS display_from_2, p0_.display_to AS display_to_3, p0_.link AS link_4, p0_.only_homepage AS only_homepage_5, p0_.new_window AS new_window_6, p0_.mobile AS mobile_7, p0_.only_exit AS only_exit_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10, h1_.id AS id_11, h1_.uuid AS uuid_12, h1_.location AS location_13, h1_.content_type AS content_type_14, h1_.metadata AS metadata_15, h1_.filesize AS filesize_16, h1_.url AS url_17, h1_.original_filename AS original_filename_18, h1_.deleted AS deleted_19, h1_.removed_from_file_system AS removed_from_file_system_20, h1_.protected AS protected_21, h1_.created_at AS created_at_22, h1_.updated_at AS updated_at_23, p0_.image_id AS image_id_24, h1_.folder_id AS folder_id_25 FROM popup p0_ LEFT JOIN hg_media_media h1_ ON p0_.image_id = h1_.id WHERE (p0_.display_from IS NULL OR p0_.display_from <= ?) AND (p0_.display_to IS NULL OR p0_.display_to >= ?) AND p0_.only_homepage = 0 AND (p0_.only_exit = 0 OR p0_.only_exit IS NULL) ORDER BY RAND() ASC LIMIT 1 Parameters: [`"2026-01-31 01:44:12" "2026-01-31 01:44:12"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.display_from AS display_from_2, p0_.display_to AS display_to_3, p0_.link AS link_4, p0_.only_homepage AS only_homepage_5, p0_.new_window AS new_window_6, p0_.mobile AS mobile_7, p0_.only_exit AS only_exit_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10, h1_.id AS id_11, h1_.uuid AS uuid_12, h1_.location AS location_13, h1_.content_type AS content_type_14, h1_.metadata AS metadata_15, h1_.filesize AS filesize_16, h1_.url AS url_17, h1_.original_filename AS original_filename_18, h1_.deleted AS deleted_19, h1_.removed_from_file_system AS removed_from_file_system_20, h1_.protected AS protected_21, h1_.created_at AS created_at_22, h1_.updated_at AS updated_at_23, p0_.image_id AS image_id_24, h1_.folder_id AS folder_id_25 FROM popup p0_ LEFT JOIN hg_media_media h1_ ON p0_.image_id = h1_.id WHERE ( p0_.display_from IS NULL OR p0_.display_from <= ? ) AND ( p0_.display_to IS NULL OR p0_.display_to >= ? ) AND p0_.only_homepage = 0 AND ( p0_.only_exit = 0 OR p0_.only_exit IS NULL ) ORDER BY RAND() ASC LIMIT 1 SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.display_from AS display_from_2, p0_.display_to AS display_to_3, p0_.link AS link_4, p0_.only_homepage AS only_homepage_5, p0_.new_window AS new_window_6, p0_.mobile AS mobile_7, p0_.only_exit AS only_exit_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10, h1_.id AS id_11, h1_.uuid AS uuid_12, h1_.location AS location_13, h1_.content_type AS content_type_14, h1_.metadata AS metadata_15, h1_.filesize AS filesize_16, h1_.url AS url_17, h1_.original_filename AS original_filename_18, h1_.deleted AS deleted_19, h1_.removed_from_file_system AS removed_from_file_system_20, h1_.protected AS protected_21, h1_.created_at AS created_at_22, h1_.updated_at AS updated_at_23, p0_.image_id AS image_id_24, h1_.folder_id AS folder_id_25 FROM popup p0_ LEFT JOIN hg_media_media h1_ ON p0_.image_id = h1_.id WHERE (p0_.display_from IS NULL OR p0_.display_from <= '2026-01-31 01:44:12') AND (p0_.display_to IS NULL OR p0_.display_to >= '2026-01-31 01:44:12') AND p0_.only_homepage = 0 AND (p0_.only_exit = 0 OR p0_.only_exit IS NULL) ORDER BY RAND() ASC LIMIT 1;
1.77 ms (1.32%)	1	SELECT h0_.id AS id_0, h0_.lang AS lang_1, h0_.online AS online_2, h0_.title AS title_3, h0_.slug AS slug_4, h0_.url AS url_5, h0_.weight AS weight_6, h0_.created AS created_7, h0_.updated AS updated_8, h1_.id AS id_9, h1_.type AS type_10, h1_.owner AS owner_11, h1_.created AS created_12, h1_.updated AS updated_13, h1_.ref_id AS ref_id_14, h1_.ref_entity_name AS ref_entity_name_15, h0_.node_id AS node_id_16, h0_.public_node_version_id AS public_node_version_id_17, h1_.node_translation_id AS node_translation_id_18, h1_.origin_id AS origin_id_19 FROM hg_node_node_translations h0_ INNER JOIN hg_node_nodes h2_ ON h0_.node_id = h2_.id AND (h0_.node_id = h2_.id) LEFT JOIN hg_node_node_versions h1_ ON h0_.public_node_version_id = h1_.id AND (h0_.public_node_version_id = h1_.id) WHERE h2_.deleted = 0 AND h0_.lang = ? AND h0_.url = ? ORDER BY h0_.online DESC Parameters: [`"hu" "top10/niche/ferfi"`] View formatted query View runnable query Explain query SELECT h0_.id AS id_0, h0_.lang AS lang_1, h0_.online AS online_2, h0_.title AS title_3, h0_.slug AS slug_4, h0_.url AS url_5, h0_.weight AS weight_6, h0_.created AS created_7, h0_.updated AS updated_8, h1_.id AS id_9, h1_.type AS type_10, h1_.owner AS owner_11, h1_.created AS created_12, h1_.updated AS updated_13, h1_.ref_id AS ref_id_14, h1_.ref_entity_name AS ref_entity_name_15, h0_.node_id AS node_id_16, h0_.public_node_version_id AS public_node_version_id_17, h1_.node_translation_id AS node_translation_id_18, h1_.origin_id AS origin_id_19 FROM hg_node_node_translations h0_ INNER JOIN hg_node_nodes h2_ ON h0_.node_id = h2_.id AND (h0_.node_id = h2_.id) LEFT JOIN hg_node_node_versions h1_ ON h0_.public_node_version_id = h1_.id AND ( h0_.public_node_version_id = h1_.id ) WHERE h2_.deleted = 0 AND h0_.lang = ? AND h0_.url = ? ORDER BY h0_.online DESC SELECT h0_.id AS id_0, h0_.lang AS lang_1, h0_.online AS online_2, h0_.title AS title_3, h0_.slug AS slug_4, h0_.url AS url_5, h0_.weight AS weight_6, h0_.created AS created_7, h0_.updated AS updated_8, h1_.id AS id_9, h1_.type AS type_10, h1_.owner AS owner_11, h1_.created AS created_12, h1_.updated AS updated_13, h1_.ref_id AS ref_id_14, h1_.ref_entity_name AS ref_entity_name_15, h0_.node_id AS node_id_16, h0_.public_node_version_id AS public_node_version_id_17, h1_.node_translation_id AS node_translation_id_18, h1_.origin_id AS origin_id_19 FROM hg_node_node_translations h0_ INNER JOIN hg_node_nodes h2_ ON h0_.node_id = h2_.id AND (h0_.node_id = h2_.id) LEFT JOIN hg_node_node_versions h1_ ON h0_.public_node_version_id = h1_.id AND (h0_.public_node_version_id = h1_.id) WHERE h2_.deleted = 0 AND h0_.lang = 'hu' AND h0_.url = 'top10/niche/ferfi' ORDER BY h0_.online DESC;
1.56 ms (1.16%)	4	SELECT t0.show_title AS show_title_1, t0.excluded_from_sitemap AS excluded_from_sitemap_2, t0.id AS id_3, t0.title AS title_4, t0.page_title AS page_title_5 FROM app_content_pages t0 WHERE t0.id = ? Parameters: [`29`] View formatted query View runnable query Explain query SELECT t0.show_title AS show_title_1, t0.excluded_from_sitemap AS excluded_from_sitemap_2, t0.id AS id_3, t0.title AS title_4, t0.page_title AS page_title_5 FROM app_content_pages t0 WHERE t0.id = ? SELECT t0.show_title AS show_title_1, t0.excluded_from_sitemap AS excluded_from_sitemap_2, t0.id AS id_3, t0.title AS title_4, t0.page_title AS page_title_5 FROM app_content_pages t0 WHERE t0.id = 29;
1.47 ms (1.09%)	1	SELECT o.id AS acl_id, o.object_identifier, o.parent_object_identity_id, o.entries_inheriting, c.class_type, e.id AS ace_id, e.object_identity_id, e.field_name, e.ace_order, e.mask, e.granting, e.granting_strategy, e.audit_success, e.audit_failure, s.username, s.identifier AS security_identifier FROM acl_object_identities o INNER JOIN acl_classes c ON c.id = o.class_id LEFT JOIN acl_entries e ON ( e.class_id = o.class_id AND (e.object_identity_id = o.id OR e.object_identity_id IS NULL) ) LEFT JOIN acl_security_identities s ON ( s.id = e.security_identity_id ) WHERE (o.id =817) Parameters: [] View formatted query View runnable query Explain query SELECT o.id AS acl_id, o.object_identifier, o.parent_object_identity_id, o.entries_inheriting, c.class_type, e.id AS ace_id, e.object_identity_id, e.field_name, e.ace_order, e.mask, e.granting, e.granting_strategy, e.audit_success, e.audit_failure, s.username, s.identifier AS security_identifier FROM acl_object_identities o INNER JOIN acl_classes c ON c.id = o.class_id LEFT JOIN acl_entries e ON ( e.class_id = o.class_id AND ( e.object_identity_id = o.id OR e.object_identity_id IS NULL ) ) LEFT JOIN acl_security_identities s ON (s.id = e.security_identity_id) WHERE (o.id = 817) SELECT o.id AS acl_id, o.object_identifier, o.parent_object_identity_id, o.entries_inheriting, c.class_type, e.id AS ace_id, e.object_identity_id, e.field_name, e.ace_order, e.mask, e.granting, e.granting_strategy, e.audit_success, e.audit_failure, s.username, s.identifier AS security_identifier FROM acl_object_identities o INNER JOIN acl_classes c ON c.id = o.class_id LEFT JOIN acl_entries e ON ( e.class_id = o.class_id AND (e.object_identity_id = o.id OR e.object_identity_id IS NULL) ) LEFT JOIN acl_security_identities s ON ( s.id = e.security_identity_id ) WHERE (o.id =817);
1.34 ms (0.99%)	1	SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.short_name AS short_name_2, b0_.slug AS slug_3, b0_.search_terms AS search_terms_4, b0_.text AS text_5, b0_.text_female AS text_female_6, b0_.text_male AS text_male_7, b0_.highlighted AS highlighted_8, b0_.main_page_fragrance AS main_page_fragrance_9, b0_.highlighted_in_search AS highlighted_in_search_10, b0_.is_on_main_page AS is_on_main_page_11, b0_.special AS special_12, b0_.special_name AS special_name_13, b0_.slogan AS slogan_14, b0_.`lead` AS lead_15, b0_.active AS active_16, b0_.exclude_from_arukereso AS exclude_from_arukereso_17, b0_.image_id AS image_id_18 FROM brand b0_ WHERE b0_.active = 1 AND b0_.is_on_main_page = 1 ORDER BY IF(b0_.short_name IS NULL OR b0_.short_name = ?, b0_.name, b0_.short_name) ASC Parameters: [`""`] View formatted query View runnable query Explain query SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.short_name AS short_name_2, b0_.slug AS slug_3, b0_.search_terms AS search_terms_4, b0_.text AS text_5, b0_.text_female AS text_female_6, b0_.text_male AS text_male_7, b0_.highlighted AS highlighted_8, b0_.main_page_fragrance AS main_page_fragrance_9, b0_.highlighted_in_search AS highlighted_in_search_10, b0_.is_on_main_page AS is_on_main_page_11, b0_.special AS special_12, b0_.special_name AS special_name_13, b0_.slogan AS slogan_14, b0_.`lead` AS lead_15, b0_.active AS active_16, b0_.exclude_from_arukereso AS exclude_from_arukereso_17, b0_.image_id AS image_id_18 FROM brand b0_ WHERE b0_.active = 1 AND b0_.is_on_main_page = 1 ORDER BY IF( b0_.short_name IS NULL OR b0_.short_name = ?, b0_.name, b0_.short_name ) ASC SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.short_name AS short_name_2, b0_.slug AS slug_3, b0_.search_terms AS search_terms_4, b0_.text AS text_5, b0_.text_female AS text_female_6, b0_.text_male AS text_male_7, b0_.highlighted AS highlighted_8, b0_.main_page_fragrance AS main_page_fragrance_9, b0_.highlighted_in_search AS highlighted_in_search_10, b0_.is_on_main_page AS is_on_main_page_11, b0_.special AS special_12, b0_.special_name AS special_name_13, b0_.slogan AS slogan_14, b0_.`lead` AS lead_15, b0_.active AS active_16, b0_.exclude_from_arukereso AS exclude_from_arukereso_17, b0_.image_id AS image_id_18 FROM brand b0_ WHERE b0_.active = 1 AND b0_.is_on_main_page = 1 ORDER BY IF(b0_.short_name IS NULL OR b0_.short_name = '', b0_.name, b0_.short_name) ASC;
1.32 ms (0.98%)	1	SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.meta_author AS meta_author_4, t0.meta_robots AS meta_robots_5, t0.og_type AS og_type_6, t0.og_title AS og_title_7, t0.og_description AS og_description_8, t0.extra_metadata AS extra_metadata_9, t0.ref_id AS ref_id_10, t0.ref_entity_name AS ref_entity_name_11, t0.og_url AS og_url_12, t0.og_article_author AS og_article_author_13, t0.og_article_publisher AS og_article_publisher_14, t0.og_article_section AS og_article_section_15, t0.twitter_title AS twitter_title_16, t0.twitter_description AS twitter_description_17, t0.twitter_site AS twitter_site_18, t0.twitter_creator AS twitter_creator_19, t0.og_image_id AS og_image_id_20, t0.twitter_image_id AS twitter_image_id_21 FROM hg_seo_seo t0 WHERE t0.ref_id = ? AND t0.ref_entity_name = ? LIMIT 1 Parameters: [`8 "App\Entity\Pages\ToptenPage"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.meta_author AS meta_author_4, t0.meta_robots AS meta_robots_5, t0.og_type AS og_type_6, t0.og_title AS og_title_7, t0.og_description AS og_description_8, t0.extra_metadata AS extra_metadata_9, t0.ref_id AS ref_id_10, t0.ref_entity_name AS ref_entity_name_11, t0.og_url AS og_url_12, t0.og_article_author AS og_article_author_13, t0.og_article_publisher AS og_article_publisher_14, t0.og_article_section AS og_article_section_15, t0.twitter_title AS twitter_title_16, t0.twitter_description AS twitter_description_17, t0.twitter_site AS twitter_site_18, t0.twitter_creator AS twitter_creator_19, t0.og_image_id AS og_image_id_20, t0.twitter_image_id AS twitter_image_id_21 FROM hg_seo_seo t0 WHERE t0.ref_id = ? AND t0.ref_entity_name = ? LIMIT 1 SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.meta_author AS meta_author_4, t0.meta_robots AS meta_robots_5, t0.og_type AS og_type_6, t0.og_title AS og_title_7, t0.og_description AS og_description_8, t0.extra_metadata AS extra_metadata_9, t0.ref_id AS ref_id_10, t0.ref_entity_name AS ref_entity_name_11, t0.og_url AS og_url_12, t0.og_article_author AS og_article_author_13, t0.og_article_publisher AS og_article_publisher_14, t0.og_article_section AS og_article_section_15, t0.twitter_title AS twitter_title_16, t0.twitter_description AS twitter_description_17, t0.twitter_site AS twitter_site_18, t0.twitter_creator AS twitter_creator_19, t0.og_image_id AS og_image_id_20, t0.twitter_image_id AS twitter_image_id_21 FROM hg_seo_seo t0 WHERE t0.ref_id = 8 AND t0.ref_entity_name = 'App\\Entity\\Pages\\ToptenPage' LIMIT 1;
1.22 ms (0.91%)	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 Parameters: [] View formatted query View runnable query Explain query 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;
1.14 ms (0.85%)	1	SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.short_name AS short_name_2, b0_.slug AS slug_3, b0_.search_terms AS search_terms_4, b0_.text AS text_5, b0_.text_female AS text_female_6, b0_.text_male AS text_male_7, b0_.highlighted AS highlighted_8, b0_.main_page_fragrance AS main_page_fragrance_9, b0_.highlighted_in_search AS highlighted_in_search_10, b0_.is_on_main_page AS is_on_main_page_11, b0_.special AS special_12, b0_.special_name AS special_name_13, b0_.slogan AS slogan_14, b0_.`lead` AS lead_15, b0_.active AS active_16, b0_.exclude_from_arukereso AS exclude_from_arukereso_17, b0_.image_id AS image_id_18 FROM brand b0_ WHERE b0_.active = 1 AND b0_.main_page_fragrance = 1 ORDER BY IF(b0_.short_name IS NULL OR b0_.short_name = ?, b0_.name, b0_.short_name) ASC LIMIT 30 Parameters: [`""`] View formatted query View runnable query Explain query SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.short_name AS short_name_2, b0_.slug AS slug_3, b0_.search_terms AS search_terms_4, b0_.text AS text_5, b0_.text_female AS text_female_6, b0_.text_male AS text_male_7, b0_.highlighted AS highlighted_8, b0_.main_page_fragrance AS main_page_fragrance_9, b0_.highlighted_in_search AS highlighted_in_search_10, b0_.is_on_main_page AS is_on_main_page_11, b0_.special AS special_12, b0_.special_name AS special_name_13, b0_.slogan AS slogan_14, b0_.`lead` AS lead_15, b0_.active AS active_16, b0_.exclude_from_arukereso AS exclude_from_arukereso_17, b0_.image_id AS image_id_18 FROM brand b0_ WHERE b0_.active = 1 AND b0_.main_page_fragrance = 1 ORDER BY IF( b0_.short_name IS NULL OR b0_.short_name = ?, b0_.name, b0_.short_name ) ASC LIMIT 30 SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.short_name AS short_name_2, b0_.slug AS slug_3, b0_.search_terms AS search_terms_4, b0_.text AS text_5, b0_.text_female AS text_female_6, b0_.text_male AS text_male_7, b0_.highlighted AS highlighted_8, b0_.main_page_fragrance AS main_page_fragrance_9, b0_.highlighted_in_search AS highlighted_in_search_10, b0_.is_on_main_page AS is_on_main_page_11, b0_.special AS special_12, b0_.special_name AS special_name_13, b0_.slogan AS slogan_14, b0_.`lead` AS lead_15, b0_.active AS active_16, b0_.exclude_from_arukereso AS exclude_from_arukereso_17, b0_.image_id AS image_id_18 FROM brand b0_ WHERE b0_.active = 1 AND b0_.main_page_fragrance = 1 ORDER BY IF(b0_.short_name IS NULL OR b0_.short_name = '', b0_.name, b0_.short_name) ASC LIMIT 30;
1.08 ms (0.80%)	1	SELECT a.ancestor_id FROM acl_object_identities o INNER JOIN acl_classes c ON c.id = o.class_id INNER JOIN acl_object_identity_ancestors a ON a.object_identity_id = o.id WHERE ((o.object_identifier IN ('93') AND c.class_type = 'Hgabka\\NodeBundle\\Entity\\Node')) Parameters: [] View formatted query View runnable query Explain query SELECT a.ancestor_id FROM acl_object_identities o INNER JOIN acl_classes c ON c.id = o.class_id INNER JOIN acl_object_identity_ancestors a ON a.object_identity_id = o.id WHERE ( ( o.object_identifier IN ('93') AND c.class_type = 'Hgabka\\NodeBundle\\Entity\\Node' ) ) SELECT a.ancestor_id FROM acl_object_identities o INNER JOIN acl_classes c ON c.id = o.class_id INNER JOIN acl_object_identity_ancestors a ON a.object_identity_id = o.id WHERE ((o.object_identifier IN ('93') AND c.class_type = 'Hgabka\\NodeBundle\\Entity\\Node'));
1.00 ms (0.74%)	2	SELECT t0.id AS id_1, t0.page_id AS page_id_2, t0.page_entityname AS page_entityname_3, t0.context AS context_4, t0.sequencenumber AS sequencenumber_5, t0.page_part_id AS page_part_id_6, t0.page_part_entityname AS page_part_entityname_7, t0.created AS created_8, t0.updated AS updated_9 FROM hg_page_part_page_part_refs t0 WHERE t0.page_id = ? AND t0.page_entityname = ? AND t0.context = ? ORDER BY t0.sequencenumber ASC Parameters: [`8 "App\Entity\Pages\ToptenPage" "topten_lead"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.page_id AS page_id_2, t0.page_entityname AS page_entityname_3, t0.context AS context_4, t0.sequencenumber AS sequencenumber_5, t0.page_part_id AS page_part_id_6, t0.page_part_entityname AS page_part_entityname_7, t0.created AS created_8, t0.updated AS updated_9 FROM hg_page_part_page_part_refs t0 WHERE t0.page_id = ? AND t0.page_entityname = ? AND t0.context = ? ORDER BY t0.sequencenumber ASC SELECT t0.id AS id_1, t0.page_id AS page_id_2, t0.page_entityname AS page_entityname_3, t0.context AS context_4, t0.sequencenumber AS sequencenumber_5, t0.page_part_id AS page_part_id_6, t0.page_part_entityname AS page_part_entityname_7, t0.created AS created_8, t0.updated AS updated_9 FROM hg_page_part_page_part_refs t0 WHERE t0.page_id = 8 AND t0.page_entityname = 'App\\Entity\\Pages\\ToptenPage' AND t0.context = 'topten_lead' ORDER BY t0.sequencenumber ASC;
0.75 ms (0.56%)	1	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 Parameters: [] View formatted query View runnable query Explain query 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;
0.64 ms (0.47%)	1	SELECT t0.id AS id_1, t0.page_id AS page_id_2, t0.page_entity_name AS page_entity_name_3, t0.page_template AS page_template_4 FROM hg_page_part_page_template_configuration t0 WHERE t0.page_id = ? AND t0.page_entity_name = ? LIMIT 1 Parameters: [`8 "App\Entity\Pages\ToptenPage"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.page_id AS page_id_2, t0.page_entity_name AS page_entity_name_3, t0.page_template AS page_template_4 FROM hg_page_part_page_template_configuration t0 WHERE t0.page_id = ? AND t0.page_entity_name = ? LIMIT 1 SELECT t0.id AS id_1, t0.page_id AS page_id_2, t0.page_entity_name AS page_entity_name_3, t0.page_template AS page_template_4 FROM hg_page_part_page_template_configuration t0 WHERE t0.page_id = 8 AND t0.page_entity_name = 'App\\Entity\\Pages\\ToptenPage' LIMIT 1;
0.59 ms (0.44%)	1	SELECT t0_.id AS id_0, t0_.slogan AS slogan_1, t0_.fejjegy AS fejjegy_2, t0_.szivjegy AS szivjegy_3, t0_.alapjegy AS alapjegy_4, t0_.iranyillat AS iranyillat_5, t0_.karakter AS karakter_6, t0_.description AS description_7, t0_.gender AS gender_8, t0_.type AS type_9, t0_.position AS position_10, t0_.product_packaging_id AS product_packaging_id_11 FROM top_ten t0_ WHERE t0_.gender = ? AND t0_.type = ? ORDER BY t0_.position ASC Parameters: [`"f" "niche"`] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.slogan AS slogan_1, t0_.fejjegy AS fejjegy_2, t0_.szivjegy AS szivjegy_3, t0_.alapjegy AS alapjegy_4, t0_.iranyillat AS iranyillat_5, t0_.karakter AS karakter_6, t0_.description AS description_7, t0_.gender AS gender_8, t0_.type AS type_9, t0_.position AS position_10, t0_.product_packaging_id AS product_packaging_id_11 FROM top_ten t0_ WHERE t0_.gender = ? AND t0_.type = ? ORDER BY t0_.position ASC SELECT t0_.id AS id_0, t0_.slogan AS slogan_1, t0_.fejjegy AS fejjegy_2, t0_.szivjegy AS szivjegy_3, t0_.alapjegy AS alapjegy_4, t0_.iranyillat AS iranyillat_5, t0_.karakter AS karakter_6, t0_.description AS description_7, t0_.gender AS gender_8, t0_.type AS type_9, t0_.position AS position_10, t0_.product_packaging_id AS product_packaging_id_11 FROM top_ten t0_ WHERE t0_.gender = 'f' AND t0_.type = 'niche' ORDER BY t0_.position ASC;
0.57 ms (0.42%)	1	SELECT t0.id AS id_1, t0.title AS title_2, t0.page_title AS page_title_3 FROM app_home_pages t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.page_title AS page_title_3 FROM app_home_pages t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.title AS title_2, t0.page_title AS page_title_3 FROM app_home_pages t0 WHERE t0.id = 1;
0.49 ms (0.36%)	1	SELECT t0.id AS id_1, t0.title AS title_2, t0.page_title AS page_title_3 FROM app_contact_pages t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.page_title AS page_title_3 FROM app_contact_pages t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.title AS title_2, t0.page_title AS page_title_3 FROM app_contact_pages t0 WHERE t0.id = 1;
0.49 ms (0.36%)	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.gift_set = ? LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query 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.gift_set = ? 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.gift_set = 1 LIMIT 1;
0.42 ms (0.31%)	1	SELECT t0.id AS id_1, t0.title AS title_2, t0.page_title AS page_title_3, t0.image_id AS image_id_4 FROM app_blog_pages t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.page_title AS page_title_3, t0.image_id AS image_id_4 FROM app_blog_pages t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.title AS title_2, t0.page_title AS page_title_3, t0.image_id AS image_id_4 FROM app_blog_pages t0 WHERE t0.id = 1;
0.40 ms (0.30%)	1	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
0.37 ms (0.27%)	1	SELECT t0.gender AS gender_1, t0.type AS type_2, t0.id AS id_3 FROM app_topten_page_parts t0 WHERE t0.id IN (?) Parameters: [`8`] View formatted query View runnable query Explain query SELECT t0.gender AS gender_1, t0.type AS type_2, t0.id AS id_3 FROM app_topten_page_parts t0 WHERE t0.id IN (?) SELECT t0.gender AS gender_1, t0.type AS type_2, t0.id AS id_3 FROM app_topten_page_parts t0 WHERE t0.id IN (8);
0.36 ms (0.27%)	1	SELECT t0.id AS id_1, t0.title AS title_2, t0.page_title AS page_title_3 FROM app_brand_pages t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.page_title AS page_title_3 FROM app_brand_pages t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.title AS title_2, t0.page_title AS page_title_3 FROM app_brand_pages t0 WHERE t0.id = 1;
0.32 ms (0.24%)	1	SELECT t0.title AS title_1, t0.remote_url AS remote_url_2, t0.id AS id_3 FROM app_topten_link_page_parts t0 WHERE t0.id IN (?) Parameters: [`14`] View formatted query View runnable query Explain query SELECT t0.title AS title_1, t0.remote_url AS remote_url_2, t0.id AS id_3 FROM app_topten_link_page_parts t0 WHERE t0.id IN (?) SELECT t0.title AS title_1, t0.remote_url AS remote_url_2, t0.id AS id_3 FROM app_topten_link_page_parts t0 WHERE t0.id IN (14);
0.32 ms (0.24%)	1	SELECT t0.id AS id_1, t0.title AS title_2, t0.page_title AS page_title_3 FROM app_favorites_pages t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.page_title AS page_title_3 FROM app_favorites_pages t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.title AS title_2, t0.page_title AS page_title_3 FROM app_favorites_pages t0 WHERE t0.id = 1;
0.29 ms (0.21%)	1	SELECT t0.remote_url AS remote_url_1, t0.id AS id_2, t0.title AS title_3, t0.page_title AS page_title_4 FROM app_folder_pages t0 WHERE t0.id = ? Parameters: [`12`] View formatted query View runnable query Explain query SELECT t0.remote_url AS remote_url_1, t0.id AS id_2, t0.title AS title_3, t0.page_title AS page_title_4 FROM app_folder_pages t0 WHERE t0.id = ? SELECT t0.remote_url AS remote_url_1, t0.id AS id_2, t0.title AS title_3, t0.page_title AS page_title_4 FROM app_folder_pages t0 WHERE t0.id = 12;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\FragranceSample	No errors.
App\Entity\GuaranteedPresent	No errors.
App\Entity\ProductCategory	No errors.
App\Entity\FrequentlyAskedQuestion	No errors.
App\Entity\TopTen	No errors.
Hgabka\MediaBundle\Entity\Folder	No errors.
Hgabka\PagePartBundle\Entity\PageTemplateConfiguration	No errors.
Hgabka\SettingsBundle\Entity\Redirect	No errors.
App\Entity\Brand	No errors.
Hgabka\MediaBundle\Entity\Media	No errors.
Hgabka\NodeBundle\Entity\NodeTranslation	No errors.
Hgabka\NodeBundle\Entity\Node	No errors.
Hgabka\NodeBundle\Entity\NodeVersion	No errors.
App\Entity\Pages\ToptenPage	No errors.
Hgabka\SeoBundle\Entity\Seo	No errors.
Hgabka\MediaBundle\Entity\MediaTranslation	No errors.
App\Entity\Pages\HomePage	No errors.
App\Entity\PlacedBanner	No errors.
App\Entity\Pages\ContentPage	No errors.
App\Entity\Pages\ContactPage	No errors.
App\Entity\Pages\FavoritesPage	No errors.
App\Entity\MainMenuItemEntity	No errors.
App\Entity\ProductPackaging	No errors.
App\Entity\Product	No errors.
App\Entity\FragranceFamily	No errors.
App\Entity\Concentration	No errors.
App\Entity\MainMenuOffer	No errors.
App\Entity\User	No errors.
App\Entity\Label	No errors.
App\Entity\AvailableSubscription	No errors.
App\Entity\TharanisLog	No errors.
App\Entity\OrderItem	No errors.
App\Entity\ProductConnection	No errors.
App\Entity\ProductExtraImage	No errors.
App\Entity\ComingSoonSubscription	No errors.
App\Entity\ProductRating	No errors.
App\Entity\FragranceKind	No errors.
App\Entity\ExtraDiscount	No errors.
Hgabka\MediaBundle\Entity\FolderTranslation	No errors.
App\Entity\Pages\BrandPage	No errors.
App\Entity\Pages\FolderPage	No errors.
Hgabka\PagePartBundle\Entity\PagePartRef	No errors.
App\Entity\PageParts\ToptenPagePart	No errors.
App\Entity\PageParts\ToptenLinkPagePart	No errors.
App\Entity\Pages\BlogPage	No errors.
App\Entity\Popup	No errors.

Symfony Profiler

GET https://www.parfum.harmatgabor.eu/top10/niche/ferfi

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping