Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.active AS active_3,
  t0.featured AS featured_4,
  t0.homepage_order AS homepage_order_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.icon_id AS icon_id_10
FROM
  category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.active AS active_3, t0.featured AS featured_4, t0.homepage_order AS homepage_order_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.icon_id AS icon_id_10 FROM category t0 WHERE t0.slug = 'cervezas' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.slug AS slug_1,
  s0_.active AS active_2,
  s0_.featured AS featured_3,
  s0_.homepage_order AS homepage_order_4,
  s0_.created_by AS created_by_5,
  s0_.updated_by AS updated_by_6,
  s0_.created_at AS created_at_7,
  s0_.updated_at AS updated_at_8,
  s0_.category_id AS category_id_9,
  s0_.icon_id AS icon_id_10
FROM
  subcategory s0_
WHERE
  s0_.slug = ?

SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.active AS active_2, s0_.featured AS featured_3, s0_.homepage_order AS homepage_order_4, s0_.created_by AS created_by_5, s0_.updated_by AS updated_by_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.category_id AS category_id_9, s0_.icon_id AS icon_id_10 FROM subcategory s0_ WHERE s0_.slug = 'tostadas';

SELECT
  p0_.id AS id_0,
  p0_.slug AS slug_1,
  p0_.is_draft AS is_draft_2,
  p0_.is_blocked AS is_blocked_3,
  p0_.is_sold_out AS is_sold_out_4,
  p0_.weight AS weight_5,
  p0_.width AS width_6,
  p0_.length AS length_7,
  p0_.height AS height_8,
  p0_.volumetric_weight AS volumetric_weight_9,
  p0_.units_per_box AS units_per_box_10,
  p0_.units_per_box_grouped AS units_per_box_grouped_11,
  p0_.hide_discount AS hide_discount_12,
  p0_.ean AS ean_13,
  p0_.purchase_order_number AS purchase_order_number_14,
  p0_.is_mandatory_product_features AS is_mandatory_product_features_15,
  p0_.is_mandatory_producer AS is_mandatory_producer_16,
  p0_.is_mandatory_triweer_list AS is_mandatory_triweer_list_17,
  p0_.is_mandatory_triweer_comments AS is_mandatory_triweer_comments_18,
  p0_.is_live_shopping AS is_live_shopping_19,
  p0_.has_blockchain_traceability AS has_blockchain_traceability_20,
  p0_.show_on_wall AS show_on_wall_21,
  p0_.allow_return AS allow_return_22,
  p0_.n_days_allowed_for_return AS n_days_allowed_for_return_23,
  p0_.send_notifications AS send_notifications_24,
  p0_.producer_purchase_order_number AS producer_purchase_order_number_25,
  p0_.limit_units_per_buyer AS limit_units_per_buyer_26,
  p0_.limit_units_to_sell AS limit_units_to_sell_27,
  p0_.coming_soon_date AS coming_soon_date_28,
  p0_.offer_launch_date AS offer_launch_date_29,
  p0_.countdown_date AS countdown_date_30,
  p0_.end_offer_date AS end_offer_date_31,
  p0_.shipping_date AS shipping_date_32,
  p0_.individual_shipping_duration AS individual_shipping_duration_33,
  p0_.shared_shipping_duration AS shared_shipping_duration_34,
  p0_.individual_package_format AS individual_package_format_35,
  p0_.n_hours_on_wall_after_end AS n_hours_on_wall_after_end_36,
  p0_.max_coins_to_spent AS max_coins_to_spent_37,
  p0_.original_price AS original_price_38,
  p0_.individual_price AS individual_price_39,
  p0_.individual_disabled AS individual_disabled_40,
  p0_.fake_users AS fake_users_41,
  p0_.additional_info AS additional_info_42,
  p0_.shipping_cost AS shipping_cost_43,
  p0_.holded_id AS holded_id_44,
  p0_.only_adults AS only_adults_45,
  p0_.amount_for_free_shipping AS amount_for_free_shipping_46,
  p0_.better_price AS better_price_47,
  p0_.meta_title AS meta_title_48,
  p0_.meta_description AS meta_description_49,
  p0_.show_price AS show_price_50,
  p0_.created_by AS created_by_51,
  p0_.updated_by AS updated_by_52,
  p0_.created_at AS created_at_53,
  p0_.updated_at AS updated_at_54,
  p0_.type_id AS type_id_55,
  p0_.iva_id AS iva_id_56,
  p0_.brand_id AS brand_id_57,
  p0_.producer_id AS producer_id_58,
  p0_.unit_measurement_id AS unit_measurement_id_59,
  p0_.product_unique_id AS product_unique_id_60,
  p0_.shipping_id AS shipping_id_61
FROM
  product p0_
  LEFT JOIN product_price_scale p1_ ON p0_.id = p1_.product_id
  LEFT JOIN product_translation p2_ ON p0_.id = p2_.translatable_id
  INNER JOIN product_subcategory p4_ ON p0_.id = p4_.product_id
  INNER JOIN subcategory s3_ ON s3_.id = p4_.subcategory_id
WHERE
  p0_.show_on_wall = true
  AND p0_.is_draft = false
  AND p0_.is_blocked = false
  AND p0_.is_sold_out = false
  AND (
    (
      ? BETWEEN p0_.offer_launch_date
      AND p0_.end_offer_date
    )
  )
  AND s3_.id IN (?)
ORDER BY
  p0_.end_offer_date ASC

SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.is_draft AS is_draft_2, p0_.is_blocked AS is_blocked_3, p0_.is_sold_out AS is_sold_out_4, p0_.weight AS weight_5, p0_.width AS width_6, p0_.length AS length_7, p0_.height AS height_8, p0_.volumetric_weight AS volumetric_weight_9, p0_.units_per_box AS units_per_box_10, p0_.units_per_box_grouped AS units_per_box_grouped_11, p0_.hide_discount AS hide_discount_12, p0_.ean AS ean_13, p0_.purchase_order_number AS purchase_order_number_14, p0_.is_mandatory_product_features AS is_mandatory_product_features_15, p0_.is_mandatory_producer AS is_mandatory_producer_16, p0_.is_mandatory_triweer_list AS is_mandatory_triweer_list_17, p0_.is_mandatory_triweer_comments AS is_mandatory_triweer_comments_18, p0_.is_live_shopping AS is_live_shopping_19, p0_.has_blockchain_traceability AS has_blockchain_traceability_20, p0_.show_on_wall AS show_on_wall_21, p0_.allow_return AS allow_return_22, p0_.n_days_allowed_for_return AS n_days_allowed_for_return_23, p0_.send_notifications AS send_notifications_24, p0_.producer_purchase_order_number AS producer_purchase_order_number_25, p0_.limit_units_per_buyer AS limit_units_per_buyer_26, p0_.limit_units_to_sell AS limit_units_to_sell_27, p0_.coming_soon_date AS coming_soon_date_28, p0_.offer_launch_date AS offer_launch_date_29, p0_.countdown_date AS countdown_date_30, p0_.end_offer_date AS end_offer_date_31, p0_.shipping_date AS shipping_date_32, p0_.individual_shipping_duration AS individual_shipping_duration_33, p0_.shared_shipping_duration AS shared_shipping_duration_34, p0_.individual_package_format AS individual_package_format_35, p0_.n_hours_on_wall_after_end AS n_hours_on_wall_after_end_36, p0_.max_coins_to_spent AS max_coins_to_spent_37, p0_.original_price AS original_price_38, p0_.individual_price AS individual_price_39, p0_.individual_disabled AS individual_disabled_40, p0_.fake_users AS fake_users_41, p0_.additional_info AS additional_info_42, p0_.shipping_cost AS shipping_cost_43, p0_.holded_id AS holded_id_44, p0_.only_adults AS only_adults_45, p0_.amount_for_free_shipping AS amount_for_free_shipping_46, p0_.better_price AS better_price_47, p0_.meta_title AS meta_title_48, p0_.meta_description AS meta_description_49, p0_.show_price AS show_price_50, p0_.created_by AS created_by_51, p0_.updated_by AS updated_by_52, p0_.created_at AS created_at_53, p0_.updated_at AS updated_at_54, p0_.type_id AS type_id_55, p0_.iva_id AS iva_id_56, p0_.brand_id AS brand_id_57, p0_.producer_id AS producer_id_58, p0_.unit_measurement_id AS unit_measurement_id_59, p0_.product_unique_id AS product_unique_id_60, p0_.shipping_id AS shipping_id_61 FROM product p0_ LEFT JOIN product_price_scale p1_ ON p0_.id = p1_.product_id LEFT JOIN product_translation p2_ ON p0_.id = p2_.translatable_id INNER JOIN product_subcategory p4_ ON p0_.id = p4_.product_id INNER JOIN subcategory s3_ ON s3_.id = p4_.subcategory_id WHERE p0_.show_on_wall = true AND p0_.is_draft = false AND p0_.is_blocked = false AND p0_.is_sold_out = false AND (('2024-12-29 05:09:39' BETWEEN p0_.offer_launch_date AND p0_.end_offer_date)) AND s3_.id IN (4) ORDER BY p0_.end_offer_date ASC;

SELECT
  c0_.id AS id_0,
  c0_.slug AS slug_1,
  c0_.active AS active_2,
  c0_.featured AS featured_3,
  c0_.homepage_order AS homepage_order_4,
  c0_.created_by AS created_by_5,
  c0_.updated_by AS updated_by_6,
  c0_.created_at AS created_at_7,
  c0_.updated_at AS updated_at_8,
  s1_.id AS id_9,
  s1_.slug AS slug_10,
  s1_.active AS active_11,
  s1_.featured AS featured_12,
  s1_.homepage_order AS homepage_order_13,
  s1_.created_by AS created_by_14,
  s1_.updated_by AS updated_by_15,
  s1_.created_at AS created_at_16,
  s1_.updated_at AS updated_at_17,
  c0_.icon_id AS icon_id_18,
  s1_.category_id AS category_id_19,
  s1_.icon_id AS icon_id_20
FROM
  category c2_
  LEFT JOIN category_translation c3_ ON c2_.id = c3_.translatable_id,
  category c0_
  LEFT JOIN subcategory s1_ ON c0_.id = s1_.category_id
WHERE
  c0_.active = true
  AND (
    s1_.active = true
    OR s1_.id IS NULL
  )
ORDER BY
  c0_.homepage_order ASC,
  s1_.homepage_order ASC

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.active AS active_2, c0_.featured AS featured_3, c0_.homepage_order AS homepage_order_4, c0_.created_by AS created_by_5, c0_.updated_by AS updated_by_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, s1_.id AS id_9, s1_.slug AS slug_10, s1_.active AS active_11, s1_.featured AS featured_12, s1_.homepage_order AS homepage_order_13, s1_.created_by AS created_by_14, s1_.updated_by AS updated_by_15, s1_.created_at AS created_at_16, s1_.updated_at AS updated_at_17, c0_.icon_id AS icon_id_18, s1_.category_id AS category_id_19, s1_.icon_id AS icon_id_20 FROM category c2_ LEFT JOIN category_translation c3_ ON c2_.id = c3_.translatable_id, category c0_ LEFT JOIN subcategory s1_ ON c0_.id = s1_.category_id WHERE c0_.active = true AND (s1_.active = true OR s1_.id IS NULL) ORDER BY c0_.homepage_order ASC, s1_.homepage_order ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  category_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM category_translation t0 WHERE t0.translatable_id = 32;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  category_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM category_translation t0 WHERE t0.translatable_id = 25;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  subcategory_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM subcategory_translation t0 WHERE t0.translatable_id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  subcategory_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM subcategory_translation t0 WHERE t0.translatable_id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  subcategory_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM subcategory_translation t0 WHERE t0.translatable_id = 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  category_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM category_translation t0 WHERE t0.translatable_id = 22;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  category_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM category_translation t0 WHERE t0.translatable_id = 30;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  subcategory_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM subcategory_translation t0 WHERE t0.translatable_id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  subcategory_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM subcategory_translation t0 WHERE t0.translatable_id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  category_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM category_translation t0 WHERE t0.translatable_id = 27;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  subcategory_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM subcategory_translation t0 WHERE t0.translatable_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  category_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM category_translation t0 WHERE t0.translatable_id = 29;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  category_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM category_translation t0 WHERE t0.translatable_id = 26;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  category_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM category_translation t0 WHERE t0.translatable_id = 20;

SELECT
  o0_.id AS id_0,
  o0_.save_card AS save_card_1,
  o0_.shipping_cost AS shipping_cost_2,
  o0_.final_shipping_cost AS final_shipping_cost_3,
  o0_.shipping_address AS shipping_address_4,
  o0_.shared_address_order_id AS shared_address_order_id_5,
  o0_.shipping_postal_code AS shipping_postal_code_6,
  o0_.shipping_city AS shipping_city_7,
  o0_.shipping_country AS shipping_country_8,
  o0_.billing_address AS billing_address_9,
  o0_.billing_postal_code AS billing_postal_code_10,
  o0_.billing_city AS billing_city_11,
  o0_.billing_country AS billing_country_12,
  o0_.billing_country_iso_code2 AS billing_country_iso_code2_13,
  o0_.total_amount AS total_amount_14,
  o0_.holded_id AS holded_id_15,
  o0_.phone AS phone_16,
  o0_.need_bill AS need_bill_17,
  o0_.cif AS cif_18,
  o0_.shipping_province AS shipping_province_19,
  o0_.shipping_country_iso AS shipping_country_iso_20,
  o0_.delivery_method AS delivery_method_21,
  o0_.created_by AS created_by_22,
  o0_.updated_by AS updated_by_23,
  o0_.created_at AS created_at_24,
  o0_.updated_at AS updated_at_25,
  o1_.id AS id_26,
  o1_.quantity AS quantity_27,
  o1_.original_price AS original_price_28,
  o1_.final_price AS final_price_29,
  o1_.iva_percentage AS iva_percentage_30,
  o1_.buy_not_enought AS buy_not_enought_31,
  o1_.better_price AS better_price_32,
  o1_.is_individual_purchase AS is_individual_purchase_33,
  o1_.created_by AS created_by_34,
  o1_.updated_by AS updated_by_35,
  o1_.created_at AS created_at_36,
  o1_.updated_at AS updated_at_37,
  p2_.id AS id_38,
  p2_.slug AS slug_39,
  p2_.is_draft AS is_draft_40,
  p2_.is_blocked AS is_blocked_41,
  p2_.is_sold_out AS is_sold_out_42,
  p2_.weight AS weight_43,
  p2_.width AS width_44,
  p2_.length AS length_45,
  p2_.height AS height_46,
  p2_.volumetric_weight AS volumetric_weight_47,
  p2_.units_per_box AS units_per_box_48,
  p2_.units_per_box_grouped AS units_per_box_grouped_49,
  p2_.hide_discount AS hide_discount_50,
  p2_.ean AS ean_51,
  p2_.purchase_order_number AS purchase_order_number_52,
  p2_.is_mandatory_product_features AS is_mandatory_product_features_53,
  p2_.is_mandatory_producer AS is_mandatory_producer_54,
  p2_.is_mandatory_triweer_list AS is_mandatory_triweer_list_55,
  p2_.is_mandatory_triweer_comments AS is_mandatory_triweer_comments_56,
  p2_.is_live_shopping AS is_live_shopping_57,
  p2_.has_blockchain_traceability AS has_blockchain_traceability_58,
  p2_.show_on_wall AS show_on_wall_59,
  p2_.allow_return AS allow_return_60,
  p2_.n_days_allowed_for_return AS n_days_allowed_for_return_61,
  p2_.send_notifications AS send_notifications_62,
  p2_.producer_purchase_order_number AS producer_purchase_order_number_63,
  p2_.limit_units_per_buyer AS limit_units_per_buyer_64,
  p2_.limit_units_to_sell AS limit_units_to_sell_65,
  p2_.coming_soon_date AS coming_soon_date_66,
  p2_.offer_launch_date AS offer_launch_date_67,
  p2_.countdown_date AS countdown_date_68,
  p2_.end_offer_date AS end_offer_date_69,
  p2_.shipping_date AS shipping_date_70,
  p2_.individual_shipping_duration AS individual_shipping_duration_71,
  p2_.shared_shipping_duration AS shared_shipping_duration_72,
  p2_.individual_package_format AS individual_package_format_73,
  p2_.n_hours_on_wall_after_end AS n_hours_on_wall_after_end_74,
  p2_.max_coins_to_spent AS max_coins_to_spent_75,
  p2_.original_price AS original_price_76,
  p2_.individual_price AS individual_price_77,
  p2_.individual_disabled AS individual_disabled_78,
  p2_.fake_users AS fake_users_79,
  p2_.additional_info AS additional_info_80,
  p2_.shipping_cost AS shipping_cost_81,
  p2_.holded_id AS holded_id_82,
  p2_.only_adults AS only_adults_83,
  p2_.amount_for_free_shipping AS amount_for_free_shipping_84,
  p2_.better_price AS better_price_85,
  p2_.meta_title AS meta_title_86,
  p2_.meta_description AS meta_description_87,
  p2_.show_price AS show_price_88,
  p2_.created_by AS created_by_89,
  p2_.updated_by AS updated_by_90,
  p2_.created_at AS created_at_91,
  p2_.updated_at AS updated_at_92,
  b3_.id AS id_93,
  b3_.name AS name_94,
  b3_.is_corporate AS is_corporate_95,
  b3_.corporate_contact_name AS corporate_contact_name_96,
  b3_.corporate_contact_email AS corporate_contact_email_97,
  b3_.corporate_name AS corporate_name_98,
  b3_.corporate_vat_number AS corporate_vat_number_99,
  b3_.whitelisted_domains AS whitelisted_domains_100,
  b3_.description AS description_101,
  b3_.members_can_invite AS members_can_invite_102,
  b3_.free_shipping AS free_shipping_103,
  b3_.open_group AS open_group_104,
  b3_.created_by AS created_by_105,
  b3_.updated_by AS updated_by_106,
  b3_.created_at AS created_at_107,
  b3_.updated_at AS updated_at_108,
  m4_.id AS id_109,
  m4_.filename AS filename_110,
  m4_.size AS size_111,
  m4_.mimetype AS mimetype_112,
  m4_.original_name AS original_name_113,
  m4_.position AS position_114,
  m4_.directory AS directory_115,
  m4_.active AS active_116,
  m4_.created_at AS created_at_117,
  m4_.updated_at AS updated_at_118,
  m4_.created_by AS created_by_119,
  m4_.updated_by AS updated_by_120
FROM
  "order" o0_
  INNER JOIN order_detail o1_ ON o0_.id = o1_.header_id
  INNER JOIN product p2_ ON o1_.product_id = p2_.id
  INNER JOIN buying_group b3_ ON o0_.buying_group_id = b3_.id
  INNER JOIN media m4_ ON b3_.image_id = m4_.id
  INNER JOIN order_status o5_ ON o0_.status_id = o5_.id
WHERE
  p2_.is_draft = false
  AND p2_.is_blocked = false
  AND p2_.end_offer_date >= ?
  AND (
    o5_.key = ?
    OR o5_.key = ?
  )
  AND (
    (
      p2_.end_offer_date < ?
      AND (
        p2_.end_offer_date + (1 || ' HOUR'): :interval
      ) > ?
    )
    OR p2_.is_sold_out = false
  )

SELECT o0_.id AS id_0, o0_.save_card AS save_card_1, o0_.shipping_cost AS shipping_cost_2, o0_.final_shipping_cost AS final_shipping_cost_3, o0_.shipping_address AS shipping_address_4, o0_.shared_address_order_id AS shared_address_order_id_5, o0_.shipping_postal_code AS shipping_postal_code_6, o0_.shipping_city AS shipping_city_7, o0_.shipping_country AS shipping_country_8, o0_.billing_address AS billing_address_9, o0_.billing_postal_code AS billing_postal_code_10, o0_.billing_city AS billing_city_11, o0_.billing_country AS billing_country_12, o0_.billing_country_iso_code2 AS billing_country_iso_code2_13, o0_.total_amount AS total_amount_14, o0_.holded_id AS holded_id_15, o0_.phone AS phone_16, o0_.need_bill AS need_bill_17, o0_.cif AS cif_18, o0_.shipping_province AS shipping_province_19, o0_.shipping_country_iso AS shipping_country_iso_20, o0_.delivery_method AS delivery_method_21, o0_.created_by AS created_by_22, o0_.updated_by AS updated_by_23, o0_.created_at AS created_at_24, o0_.updated_at AS updated_at_25, o1_.id AS id_26, o1_.quantity AS quantity_27, o1_.original_price AS original_price_28, o1_.final_price AS final_price_29, o1_.iva_percentage AS iva_percentage_30, o1_.buy_not_enought AS buy_not_enought_31, o1_.better_price AS better_price_32, o1_.is_individual_purchase AS is_individual_purchase_33, o1_.created_by AS created_by_34, o1_.updated_by AS updated_by_35, o1_.created_at AS created_at_36, o1_.updated_at AS updated_at_37, p2_.id AS id_38, p2_.slug AS slug_39, p2_.is_draft AS is_draft_40, p2_.is_blocked AS is_blocked_41, p2_.is_sold_out AS is_sold_out_42, p2_.weight AS weight_43, p2_.width AS width_44, p2_.length AS length_45, p2_.height AS height_46, p2_.volumetric_weight AS volumetric_weight_47, p2_.units_per_box AS units_per_box_48, p2_.units_per_box_grouped AS units_per_box_grouped_49, p2_.hide_discount AS hide_discount_50, p2_.ean AS ean_51, p2_.purchase_order_number AS purchase_order_number_52, p2_.is_mandatory_product_features AS is_mandatory_product_features_53, p2_.is_mandatory_producer AS is_mandatory_producer_54, p2_.is_mandatory_triweer_list AS is_mandatory_triweer_list_55, p2_.is_mandatory_triweer_comments AS is_mandatory_triweer_comments_56, p2_.is_live_shopping AS is_live_shopping_57, p2_.has_blockchain_traceability AS has_blockchain_traceability_58, p2_.show_on_wall AS show_on_wall_59, p2_.allow_return AS allow_return_60, p2_.n_days_allowed_for_return AS n_days_allowed_for_return_61, p2_.send_notifications AS send_notifications_62, p2_.producer_purchase_order_number AS producer_purchase_order_number_63, p2_.limit_units_per_buyer AS limit_units_per_buyer_64, p2_.limit_units_to_sell AS limit_units_to_sell_65, p2_.coming_soon_date AS coming_soon_date_66, p2_.offer_launch_date AS offer_launch_date_67, p2_.countdown_date AS countdown_date_68, p2_.end_offer_date AS end_offer_date_69, p2_.shipping_date AS shipping_date_70, p2_.individual_shipping_duration AS individual_shipping_duration_71, p2_.shared_shipping_duration AS shared_shipping_duration_72, p2_.individual_package_format AS individual_package_format_73, p2_.n_hours_on_wall_after_end AS n_hours_on_wall_after_end_74, p2_.max_coins_to_spent AS max_coins_to_spent_75, p2_.original_price AS original_price_76, p2_.individual_price AS individual_price_77, p2_.individual_disabled AS individual_disabled_78, p2_.fake_users AS fake_users_79, p2_.additional_info AS additional_info_80, p2_.shipping_cost AS shipping_cost_81, p2_.holded_id AS holded_id_82, p2_.only_adults AS only_adults_83, p2_.amount_for_free_shipping AS amount_for_free_shipping_84, p2_.better_price AS better_price_85, p2_.meta_title AS meta_title_86, p2_.meta_description AS meta_description_87, p2_.show_price AS show_price_88, p2_.created_by AS created_by_89, p2_.updated_by AS updated_by_90, p2_.created_at AS created_at_91, p2_.updated_at AS updated_at_92, b3_.id AS id_93, b3_.name AS name_94, b3_.is_corporate AS is_corporate_95, b3_.corporate_contact_name AS corporate_contact_name_96, b3_.corporate_contact_email AS corporate_contact_email_97, b3_.corporate_name AS corporate_name_98, b3_.corporate_vat_number AS corporate_vat_number_99, b3_.whitelisted_domains AS whitelisted_domains_100, b3_.description AS description_101, b3_.members_can_invite AS members_can_invite_102, b3_.free_shipping AS free_shipping_103, b3_.open_group AS open_group_104, b3_.created_by AS created_by_105, b3_.updated_by AS updated_by_106, b3_.created_at AS created_at_107, b3_.updated_at AS updated_at_108, m4_.id AS id_109, m4_.filename AS filename_110, m4_.size AS size_111, m4_.mimetype AS mimetype_112, m4_.original_name AS original_name_113, m4_.position AS position_114, m4_.directory AS directory_115, m4_.active AS active_116, m4_.created_at AS created_at_117, m4_.updated_at AS updated_at_118, m4_.created_by AS created_by_119, m4_.updated_by AS updated_by_120 FROM "order" o0_ INNER JOIN order_detail o1_ ON o0_.id = o1_.header_id INNER JOIN product p2_ ON o1_.product_id = p2_.id INNER JOIN buying_group b3_ ON o0_.buying_group_id = b3_.id INNER JOIN media m4_ ON b3_.image_id = m4_.id INNER JOIN order_status o5_ ON o0_.status_id = o5_.id WHERE p2_.is_draft = false AND p2_.is_blocked = false AND p2_.end_offer_date >= '2024-12-29 05:09:39' AND (o5_.key = 'MONEY_WITHHELD' OR o5_.key = 'BANK_TRANSFER') AND ((p2_.end_offer_date < '2024-12-29 05:09:39' AND (p2_.end_offer_date + (1 || ' HOUR')::interval) > '2024-12-29 05:09:39') OR p2_.is_sold_out = false);

SELECT
  o0_.id AS id_0,
  o0_.description AS description_1,
  o0_.key AS key_2,
  o0_.value AS value_3,
  o0_.created_by AS created_by_4,
  o0_.updated_by AS updated_by_5,
  o0_.created_at AS created_at_6,
  o0_.updated_at AS updated_at_7
FROM
  option o0_
WHERE
  o0_.key = ?

SELECT o0_.id AS id_0, o0_.description AS description_1, o0_.key AS key_2, o0_.value AS value_3, o0_.created_by AS created_by_4, o0_.updated_by AS updated_by_5, o0_.created_at AS created_at_6, o0_.updated_at AS updated_at_7 FROM option o0_ WHERE o0_.key = 'meta_title_default';

SELECT
  o0_.id AS id_0,
  o0_.description AS description_1,
  o0_.key AS key_2,
  o0_.value AS value_3,
  o0_.created_by AS created_by_4,
  o0_.updated_by AS updated_by_5,
  o0_.created_at AS created_at_6,
  o0_.updated_at AS updated_at_7
FROM
  option o0_
WHERE
  o0_.key = ?

SELECT o0_.id AS id_0, o0_.description AS description_1, o0_.key AS key_2, o0_.value AS value_3, o0_.created_by AS created_by_4, o0_.updated_by AS updated_by_5, o0_.created_at AS created_at_6, o0_.updated_at AS updated_at_7 FROM option o0_ WHERE o0_.key = 'meta_description_default';

SELECT
  c0_.id AS id_0,
  c0_.slug AS slug_1,
  c0_.active AS active_2,
  c0_.featured AS featured_3,
  c0_.homepage_order AS homepage_order_4,
  c0_.created_by AS created_by_5,
  c0_.updated_by AS updated_by_6,
  c0_.created_at AS created_at_7,
  c0_.updated_at AS updated_at_8,
  c0_.icon_id AS icon_id_9
FROM
  category c0_
  LEFT JOIN category_translation c1_ ON c0_.id = c1_.translatable_id
WHERE
  c0_.active = true
ORDER BY
  c0_.homepage_order ASC

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.active AS active_2, c0_.featured AS featured_3, c0_.homepage_order AS homepage_order_4, c0_.created_by AS created_by_5, c0_.updated_by AS updated_by_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.icon_id AS icon_id_9 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.translatable_id WHERE c0_.active = true ORDER BY c0_.homepage_order ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  category_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM category_translation t0 WHERE t0.translatable_id = 23;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  category_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM category_translation t0 WHERE t0.translatable_id = 28;