Symfony Profiler

SELECT
  c0_.code AS code_0,
  c0_.is_default AS is_default_1,
  c0_.is_active AS is_active_2,
  c0_.decimal_places AS decimal_places_3,
  e1_.id AS id_4,
  e1_.exchange_rate AS exchange_rate_5,
  e1_.last_automatic_update AS last_automatic_update_6,
  e1_.created_at AS created_at_7,
  e1_.updated_at AS updated_at_8,
  e2_.id AS id_9,
  e2_.exchange_rate AS exchange_rate_10,
  e2_.last_automatic_update AS last_automatic_update_11,
  e2_.created_at AS created_at_12,
  e2_.updated_at AS updated_at_13,
  e1_.currency_from_id AS currency_from_id_14,
  e1_.currency_to_id AS currency_to_id_15,
  e2_.currency_from_id AS currency_from_id_16,
  e2_.currency_to_id AS currency_to_id_17
FROM
  currency c0_
  LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id
  LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id
WHERE
  c0_.is_default = ?

SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, c0_.decimal_places AS decimal_places_3, e1_.id AS id_4, e1_.exchange_rate AS exchange_rate_5, e1_.last_automatic_update AS last_automatic_update_6, e1_.created_at AS created_at_7, e1_.updated_at AS updated_at_8, e2_.id AS id_9, e2_.exchange_rate AS exchange_rate_10, e2_.last_automatic_update AS last_automatic_update_11, e2_.created_at AS created_at_12, e2_.updated_at AS updated_at_13, e1_.currency_from_id AS currency_from_id_14, e1_.currency_to_id AS currency_to_id_15, e2_.currency_from_id AS currency_from_id_16, e2_.currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id WHERE c0_.is_default = 1;

SELECT
  c0_.id AS id_0,
  c0_.session_id AS session_id_1,
  c0_.status AS status_2,
  c0_.last_activity_at AS last_activity_at_3,
  c0_.email AS email_4,
  c0_.firstname AS firstname_5,
  c0_.lastname AS lastname_6,
  c0_.telephone AS telephone_7,
  c0_.company_name AS company_name_8,
  c0_.cin AS cin_9,
  c0_.vat_id AS vat_id_10,
  c0_.pickup_point_id AS pickup_point_id_11,
  c0_.pickup_point_name AS pickup_point_name_12,
  c0_.note AS note_13,
  c0_.newsletter_consent AS newsletter_consent_14,
  c0_.gdpr_consent AS gdpr_consent_15,
  c0_.payment_method AS payment_method_16,
  c0_.tracking_heureka_opt_out AS tracking_heureka_opt_out_17,
  c0_.tracking_zbozi_opt_in AS tracking_zbozi_opt_in_18,
  c0_.created_at AS created_at_19,
  c0_.updated_at AS updated_at_20,
  c0_.address_street AS address_street_21,
  c0_.address_descriptive_number AS address_descriptive_number_22,
  c0_.address_city AS address_city_23,
  c0_.address_country AS address_country_24,
  c0_.address_zip_code AS address_zip_code_25,
  c0_.invoice_street AS invoice_street_26,
  c0_.invoice_descriptive_number AS invoice_descriptive_number_27,
  c0_.invoice_city AS invoice_city_28,
  c0_.invoice_country AS invoice_country_29,
  c0_.invoice_zip_code AS invoice_zip_code_30,
  c1_.id AS id_31,
  c1_.quantity AS quantity_32,
  c1_.is_gift AS is_gift_33,
  c1_.created_at AS created_at_34,
  c1_.updated_at AS updated_at_35,
  p2_.id AS id_36,
  p2_.public_id AS public_id_37,
  p2_.code AS code_38,
  p2_.is_default AS is_default_39,
  p2_.weight_modification AS weight_modification_40,
  p2_.price_modification_amount AS price_modification_amount_41,
  p2_.price_modification_currency AS price_modification_currency_42,
  p2_.stock_stock AS stock_stock_43,
  p2_.stock_reserved AS stock_reserved_44,
  p3_.id AS id_45,
  p3_.public_id AS public_id_46,
  p3_.name AS name_47,
  p3_.description AS description_48,
  p3_.short_description AS short_description_49,
  p3_.code AS code_50,
  p3_.ean AS ean_51,
  p3_.unit AS unit_52,
  p3_.active AS active_53,
  p3_.can_be_bought AS can_be_bought_54,
  p3_.searchable AS searchable_55,
  p3_.show_price AS show_price_56,
  p3_.in_stock_text AS in_stock_text_57,
  p3_.out_of_stock_text AS out_of_stock_text_58,
  p3_.filter_parameter_value_ids AS filter_parameter_value_ids_59,
  p3_.filter_variant_value_ids AS filter_variant_value_ids_60,
  p3_.search_vector_cs AS search_vector_cs_61,
  p3_.search_vector_en AS search_vector_en_62,
  p3_.seo_title AS seo_title_63,
  p3_.seo_description AS seo_description_64,
  p3_.seo_url AS seo_url_65,
  p3_.stock_stock AS stock_stock_66,
  p3_.stock_reserved AS stock_reserved_67,
  p3_.logistic_weight AS logistic_weight_68,
  p3_.logistic_size_width AS logistic_size_width_69,
  p3_.logistic_size_height AS logistic_size_height_70,
  p3_.logistic_size_length AS logistic_size_length_71,
  p3_.price_amount AS price_amount_72,
  p3_.price_currency AS price_currency_73,
  p3_.purchase_price_amount AS purchase_price_amount_74,
  p3_.purchase_price_currency AS purchase_price_currency_75,
  c0_.customer_id AS customer_id_76,
  c0_.shipping_method_id AS shipping_method_id_77,
  c0_.discount_code_id AS discount_code_id_78,
  c1_.cart_id AS cart_id_79,
  c1_.product_variant_id AS product_variant_id_80,
  p2_.product_id AS product_id_81,
  p3_.vat_id AS vat_id_82,
  p3_.main_category_id AS main_category_id_83
FROM
  cart c0_
  LEFT JOIN cart_item c1_ ON c0_.id = c1_.cart_id
  LEFT JOIN product_variant p2_ ON c1_.product_variant_id = p2_.id
  LEFT JOIN product p3_ ON p2_.product_id = p3_.id
WHERE
  c0_.session_id = ?
  AND c0_.status = ?
ORDER BY
  c1_.id ASC

SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.status AS status_2, c0_.last_activity_at AS last_activity_at_3, c0_.email AS email_4, c0_.firstname AS firstname_5, c0_.lastname AS lastname_6, c0_.telephone AS telephone_7, c0_.company_name AS company_name_8, c0_.cin AS cin_9, c0_.vat_id AS vat_id_10, c0_.pickup_point_id AS pickup_point_id_11, c0_.pickup_point_name AS pickup_point_name_12, c0_.note AS note_13, c0_.newsletter_consent AS newsletter_consent_14, c0_.gdpr_consent AS gdpr_consent_15, c0_.payment_method AS payment_method_16, c0_.tracking_heureka_opt_out AS tracking_heureka_opt_out_17, c0_.tracking_zbozi_opt_in AS tracking_zbozi_opt_in_18, c0_.created_at AS created_at_19, c0_.updated_at AS updated_at_20, c0_.address_street AS address_street_21, c0_.address_descriptive_number AS address_descriptive_number_22, c0_.address_city AS address_city_23, c0_.address_country AS address_country_24, c0_.address_zip_code AS address_zip_code_25, c0_.invoice_street AS invoice_street_26, c0_.invoice_descriptive_number AS invoice_descriptive_number_27, c0_.invoice_city AS invoice_city_28, c0_.invoice_country AS invoice_country_29, c0_.invoice_zip_code AS invoice_zip_code_30, c1_.id AS id_31, c1_.quantity AS quantity_32, c1_.is_gift AS is_gift_33, c1_.created_at AS created_at_34, c1_.updated_at AS updated_at_35, p2_.id AS id_36, p2_.public_id AS public_id_37, p2_.code AS code_38, p2_.is_default AS is_default_39, p2_.weight_modification AS weight_modification_40, p2_.price_modification_amount AS price_modification_amount_41, p2_.price_modification_currency AS price_modification_currency_42, p2_.stock_stock AS stock_stock_43, p2_.stock_reserved AS stock_reserved_44, p3_.id AS id_45, p3_.public_id AS public_id_46, p3_.name AS name_47, p3_.description AS description_48, p3_.short_description AS short_description_49, p3_.code AS code_50, p3_.ean AS ean_51, p3_.unit AS unit_52, p3_.active AS active_53, p3_.can_be_bought AS can_be_bought_54, p3_.searchable AS searchable_55, p3_.show_price AS show_price_56, p3_.in_stock_text AS in_stock_text_57, p3_.out_of_stock_text AS out_of_stock_text_58, p3_.filter_parameter_value_ids AS filter_parameter_value_ids_59, p3_.filter_variant_value_ids AS filter_variant_value_ids_60, p3_.search_vector_cs AS search_vector_cs_61, p3_.search_vector_en AS search_vector_en_62, p3_.seo_title AS seo_title_63, p3_.seo_description AS seo_description_64, p3_.seo_url AS seo_url_65, p3_.stock_stock AS stock_stock_66, p3_.stock_reserved AS stock_reserved_67, p3_.logistic_weight AS logistic_weight_68, p3_.logistic_size_width AS logistic_size_width_69, p3_.logistic_size_height AS logistic_size_height_70, p3_.logistic_size_length AS logistic_size_length_71, p3_.price_amount AS price_amount_72, p3_.price_currency AS price_currency_73, p3_.purchase_price_amount AS purchase_price_amount_74, p3_.purchase_price_currency AS purchase_price_currency_75, c0_.customer_id AS customer_id_76, c0_.shipping_method_id AS shipping_method_id_77, c0_.discount_code_id AS discount_code_id_78, c1_.cart_id AS cart_id_79, c1_.product_variant_id AS product_variant_id_80, p2_.product_id AS product_id_81, p3_.vat_id AS vat_id_82, p3_.main_category_id AS main_category_id_83 FROM cart c0_ LEFT JOIN cart_item c1_ ON c0_.id = c1_.cart_id LEFT JOIN product_variant p2_ ON c1_.product_variant_id = p2_.id LEFT JOIN product p3_ ON p2_.product_id = p3_.id WHERE c0_.session_id = '7019f3ea50acfce488e312594475ecb6' AND c0_.status = 'active' ORDER BY c1_.id ASC;

SELECT
  s0_.id AS id_0,
  s0_.public_id AS public_id_1,
  s0_.title AS title_2,
  s0_.slug AS slug_3,
  s0_.content AS content_4,
  s0_.show_contact_form AS show_contact_form_5,
  s0_.active AS active_6,
  s0_.created_at AS created_at_7,
  s0_.updated_at AS updated_at_8,
  s0_.seo_title AS seo_title_9,
  s0_.seo_description AS seo_description_10,
  s0_.seo_url AS seo_url_11
FROM
  static_page s0_
WHERE
  s0_.active = true
ORDER BY
  s0_.created_at ASC

SELECT s0_.id AS id_0, s0_.public_id AS public_id_1, s0_.title AS title_2, s0_.slug AS slug_3, s0_.content AS content_4, s0_.show_contact_form AS show_contact_form_5, s0_.active AS active_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.seo_title AS seo_title_9, s0_.seo_description AS seo_description_10, s0_.seo_url AS seo_url_11 FROM static_page s0_ WHERE s0_.active = true ORDER BY s0_.created_at ASC;

SELECT
  c0_.code AS code_0,
  c0_.is_default AS is_default_1,
  c0_.is_active AS is_active_2,
  c0_.decimal_places AS decimal_places_3,
  e1_.id AS id_4,
  e1_.exchange_rate AS exchange_rate_5,
  e1_.last_automatic_update AS last_automatic_update_6,
  e1_.created_at AS created_at_7,
  e1_.updated_at AS updated_at_8,
  e2_.id AS id_9,
  e2_.exchange_rate AS exchange_rate_10,
  e2_.last_automatic_update AS last_automatic_update_11,
  e2_.created_at AS created_at_12,
  e2_.updated_at AS updated_at_13,
  e1_.currency_from_id AS currency_from_id_14,
  e1_.currency_to_id AS currency_to_id_15,
  e2_.currency_from_id AS currency_from_id_16,
  e2_.currency_to_id AS currency_to_id_17
FROM
  currency c0_
  LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id
  LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id
ORDER BY
  c0_.is_default DESC,
  c0_.code ASC

SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, c0_.decimal_places AS decimal_places_3, e1_.id AS id_4, e1_.exchange_rate AS exchange_rate_5, e1_.last_automatic_update AS last_automatic_update_6, e1_.created_at AS created_at_7, e1_.updated_at AS updated_at_8, e2_.id AS id_9, e2_.exchange_rate AS exchange_rate_10, e2_.last_automatic_update AS last_automatic_update_11, e2_.created_at AS created_at_12, e2_.updated_at AS updated_at_13, e1_.currency_from_id AS currency_from_id_14, e1_.currency_to_id AS currency_to_id_15, e2_.currency_from_id AS currency_from_id_16, e2_.currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id ORDER BY c0_.is_default DESC, c0_.code ASC;

SELECT
  g0_.id AS id_0,
  g0_.name AS name_1,
  g0_.active AS active_2,
  g0_.created_at AS created_at_3,
  g0_.updated_at AS updated_at_4,
  g0_.threshold_amount AS threshold_amount_5,
  g0_.threshold_currency AS threshold_currency_6,
  p1_.id AS id_7,
  p1_.public_id AS public_id_8,
  p1_.code AS code_9,
  p1_.is_default AS is_default_10,
  p1_.weight_modification AS weight_modification_11,
  p1_.price_modification_amount AS price_modification_amount_12,
  p1_.price_modification_currency AS price_modification_currency_13,
  p1_.stock_stock AS stock_stock_14,
  p1_.stock_reserved AS stock_reserved_15,
  p2_.id AS id_16,
  p2_.public_id AS public_id_17,
  p2_.name AS name_18,
  p2_.description AS description_19,
  p2_.short_description AS short_description_20,
  p2_.code AS code_21,
  p2_.ean AS ean_22,
  p2_.unit AS unit_23,
  p2_.active AS active_24,
  p2_.can_be_bought AS can_be_bought_25,
  p2_.searchable AS searchable_26,
  p2_.show_price AS show_price_27,
  p2_.in_stock_text AS in_stock_text_28,
  p2_.out_of_stock_text AS out_of_stock_text_29,
  p2_.filter_parameter_value_ids AS filter_parameter_value_ids_30,
  p2_.filter_variant_value_ids AS filter_variant_value_ids_31,
  p2_.search_vector_cs AS search_vector_cs_32,
  p2_.search_vector_en AS search_vector_en_33,
  p2_.seo_title AS seo_title_34,
  p2_.seo_description AS seo_description_35,
  p2_.seo_url AS seo_url_36,
  p2_.stock_stock AS stock_stock_37,
  p2_.stock_reserved AS stock_reserved_38,
  p2_.logistic_weight AS logistic_weight_39,
  p2_.logistic_size_width AS logistic_size_width_40,
  p2_.logistic_size_height AS logistic_size_height_41,
  p2_.logistic_size_length AS logistic_size_length_42,
  p2_.price_amount AS price_amount_43,
  p2_.price_currency AS price_currency_44,
  p2_.purchase_price_amount AS purchase_price_amount_45,
  p2_.purchase_price_currency AS purchase_price_currency_46,
  g0_.product_variant_id AS product_variant_id_47,
  p1_.product_id AS product_id_48,
  p2_.vat_id AS vat_id_49,
  p2_.main_category_id AS main_category_id_50
FROM
  gift g0_
  INNER JOIN product_variant p1_ ON g0_.product_variant_id = p1_.id
  INNER JOIN product p2_ ON p1_.product_id = p2_.id
WHERE
  g0_.active = ?
ORDER BY
  g0_.threshold_amount ASC

SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.active AS active_2, g0_.created_at AS created_at_3, g0_.updated_at AS updated_at_4, g0_.threshold_amount AS threshold_amount_5, g0_.threshold_currency AS threshold_currency_6, p1_.id AS id_7, p1_.public_id AS public_id_8, p1_.code AS code_9, p1_.is_default AS is_default_10, p1_.weight_modification AS weight_modification_11, p1_.price_modification_amount AS price_modification_amount_12, p1_.price_modification_currency AS price_modification_currency_13, p1_.stock_stock AS stock_stock_14, p1_.stock_reserved AS stock_reserved_15, p2_.id AS id_16, p2_.public_id AS public_id_17, p2_.name AS name_18, p2_.description AS description_19, p2_.short_description AS short_description_20, p2_.code AS code_21, p2_.ean AS ean_22, p2_.unit AS unit_23, p2_.active AS active_24, p2_.can_be_bought AS can_be_bought_25, p2_.searchable AS searchable_26, p2_.show_price AS show_price_27, p2_.in_stock_text AS in_stock_text_28, p2_.out_of_stock_text AS out_of_stock_text_29, p2_.filter_parameter_value_ids AS filter_parameter_value_ids_30, p2_.filter_variant_value_ids AS filter_variant_value_ids_31, p2_.search_vector_cs AS search_vector_cs_32, p2_.search_vector_en AS search_vector_en_33, p2_.seo_title AS seo_title_34, p2_.seo_description AS seo_description_35, p2_.seo_url AS seo_url_36, p2_.stock_stock AS stock_stock_37, p2_.stock_reserved AS stock_reserved_38, p2_.logistic_weight AS logistic_weight_39, p2_.logistic_size_width AS logistic_size_width_40, p2_.logistic_size_height AS logistic_size_height_41, p2_.logistic_size_length AS logistic_size_length_42, p2_.price_amount AS price_amount_43, p2_.price_currency AS price_currency_44, p2_.purchase_price_amount AS purchase_price_amount_45, p2_.purchase_price_currency AS purchase_price_currency_46, g0_.product_variant_id AS product_variant_id_47, p1_.product_id AS product_id_48, p2_.vat_id AS vat_id_49, p2_.main_category_id AS main_category_id_50 FROM gift g0_ INNER JOIN product_variant p1_ ON g0_.product_variant_id = p1_.id INNER JOIN product p2_ ON p1_.product_id = p2_.id WHERE g0_.active = 1 ORDER BY g0_.threshold_amount ASC;

SELECT
  c0_.id AS id_0,
  c0_.public_id AS public_id_1,
  c0_.name AS name_2,
  c0_.slug AS slug_3,
  c0_.description AS description_4,
  c0_.lft AS lft_5,
  c0_.lvl AS lvl_6,
  c0_.rgt AS rgt_7,
  c0_.position AS position_8,
  c0_.seo_title AS seo_title_9,
  c0_.seo_description AS seo_description_10,
  c0_.seo_url AS seo_url_11
FROM
  category c0_
ORDER BY
  c0_.tree_root ASC,
  c0_.lft ASC

SELECT c0_.id AS id_0, c0_.public_id AS public_id_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.lft AS lft_5, c0_.lvl AS lvl_6, c0_.rgt AS rgt_7, c0_.position AS position_8, c0_.seo_title AS seo_title_9, c0_.seo_description AS seo_description_10, c0_.seo_url AS seo_url_11 FROM category c0_ ORDER BY c0_.tree_root ASC, c0_.lft ASC;

SELECT
  s0_.id AS id_0,
  s0_.range_from AS range_from_1,
  s0_.range_to AS range_to_2,
  s0_.created_at AS created_at_3,
  s0_.updated_at AS updated_at_4,
  s0_.price_amount AS price_amount_5,
  s0_.price_currency AS price_currency_6,
  s0_.shipping_method_id AS shipping_method_id_7,
  s0_.country_id AS country_id_8
FROM
  shipping_method_fee s0_
  INNER JOIN shipping_method s1_ ON s0_.shipping_method_id = s1_.id
WHERE
  s1_.is_active = true
  AND s1_.carrier IS NOT NULL
  AND s0_.price_amount = 0
  AND s0_.range_from IS NOT NULL
ORDER BY
  s0_.range_from ASC
LIMIT
  1

SELECT s0_.id AS id_0, s0_.range_from AS range_from_1, s0_.range_to AS range_to_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4, s0_.price_amount AS price_amount_5, s0_.price_currency AS price_currency_6, s0_.shipping_method_id AS shipping_method_id_7, s0_.country_id AS country_id_8 FROM shipping_method_fee s0_ INNER JOIN shipping_method s1_ ON s0_.shipping_method_id = s1_.id WHERE s1_.is_active = true AND s1_.carrier IS NOT NULL AND s0_.price_amount = 0 AND s0_.range_from IS NOT NULL ORDER BY s0_.range_from ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.is_main AS is_main_2,
  t0.position AS position_3,
  t0.product_id AS product_id_4,
  t0.file_id AS file_id_5
FROM
  product_image t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.is_main AS is_main_2, t0.position AS position_3, t0.product_id AS product_id_4, t0.file_id AS file_id_5 FROM product_image t0 WHERE t0.product_id = '7a79ea94-236b-4062-a3b5-5a047d63c05f';

SELECT
  e0_.id AS id_0,
  e0_.exchange_rate AS exchange_rate_1,
  e0_.last_automatic_update AS last_automatic_update_2,
  e0_.created_at AS created_at_3,
  e0_.updated_at AS updated_at_4,
  e0_.currency_from_id AS currency_from_id_5,
  e0_.currency_to_id AS currency_to_id_6
FROM
  exchange_rate e0_

SELECT e0_.id AS id_0, e0_.exchange_rate AS exchange_rate_1, e0_.last_automatic_update AS last_automatic_update_2, e0_.created_at AS created_at_3, e0_.updated_at AS updated_at_4, e0_.currency_from_id AS currency_from_id_5, e0_.currency_to_id AS currency_to_id_6 FROM exchange_rate e0_;

SELECT
  c0_.id AS id_0,
  c0_.position AS position_1,
  c0_.title AS title_2,
  c0_.content AS content_3,
  c0_.link_url AS link_url_4,
  c0_.link_label AS link_label_5,
  c0_.is_active AS is_active_6,
  f1_.id AS id_7,
  f1_.size AS size_8,
  f1_.mime_type AS mime_type_9,
  f1_.name AS name_10,
  c0_.image_id AS image_id_11
FROM
  cart_sidebar_block c0_
  LEFT JOIN file f1_ ON c0_.image_id = f1_.id
WHERE
  c0_.is_active = true
ORDER BY
  c0_.position ASC,
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.position AS position_1, c0_.title AS title_2, c0_.content AS content_3, c0_.link_url AS link_url_4, c0_.link_label AS link_label_5, c0_.is_active AS is_active_6, f1_.id AS id_7, f1_.size AS size_8, f1_.mime_type AS mime_type_9, f1_.name AS name_10, c0_.image_id AS image_id_11 FROM cart_sidebar_block c0_ LEFT JOIN file f1_ ON c0_.image_id = f1_.id WHERE c0_.is_active = true ORDER BY c0_.position ASC, c0_.id ASC;

SELECT
  n0_.id AS id_0,
  n0_.active AS active_1,
  n0_.content AS content_2,
  n0_.notice_position AS notice_position_3,
  n0_.show_from AS show_from_4,
  n0_.show_to AS show_to_5,
  n0_.background_color AS background_color_6,
  n0_.text_color AS text_color_7,
  n0_.button_background_color AS button_background_color_8,
  n0_.button_hover_background_color AS button_hover_background_color_9,
  n0_.button_text_color AS button_text_color_10,
  n0_.notice_type AS notice_type_11
FROM
  notice n0_
WHERE
  n0_.notice_type IN ('infobar')

SELECT n0_.id AS id_0, n0_.active AS active_1, n0_.content AS content_2, n0_.notice_position AS notice_position_3, n0_.show_from AS show_from_4, n0_.show_to AS show_to_5, n0_.background_color AS background_color_6, n0_.text_color AS text_color_7, n0_.button_background_color AS button_background_color_8, n0_.button_hover_background_color AS button_hover_background_color_9, n0_.button_text_color AS button_text_color_10, n0_.notice_type AS notice_type_11 FROM notice n0_ WHERE n0_.notice_type IN ('infobar');