GET https://www.parfum.harmatgabor.eu/termek/packagingAvailable/10170

Query Metrics

5 Database Queries
5 Different statements
6.95 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.33 ms
SELECT DATABASE()
Parameters:
[]
2 0.79 ms
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:
[]
3 2.86 ms
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:
[
  "10170"
]
4 1.44 ms
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:
[
  8170
]
5 1.54 ms
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:
[
  114
]

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.