Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.is_draft AS is_draft_3,
  t0.is_blocked AS is_blocked_4,
  t0.is_sold_out AS is_sold_out_5,
  t0.weight AS weight_6,
  t0.width AS width_7,
  t0.length AS length_8,
  t0.height AS height_9,
  t0.volumetric_weight AS volumetric_weight_10,
  t0.units_per_box AS units_per_box_11,
  t0.units_per_box_grouped AS units_per_box_grouped_12,
  t0.hide_discount AS hide_discount_13,
  t0.ean AS ean_14,
  t0.purchase_order_number AS purchase_order_number_15,
  t0.is_mandatory_product_features AS is_mandatory_product_features_16,
  t0.is_mandatory_producer AS is_mandatory_producer_17,
  t0.is_mandatory_triweer_list AS is_mandatory_triweer_list_18,
  t0.is_mandatory_triweer_comments AS is_mandatory_triweer_comments_19,
  t0.is_live_shopping AS is_live_shopping_20,
  t0.has_blockchain_traceability AS has_blockchain_traceability_21,
  t0.show_on_wall AS show_on_wall_22,
  t0.allow_return AS allow_return_23,
  t0.n_days_allowed_for_return AS n_days_allowed_for_return_24,
  t0.send_notifications AS send_notifications_25,
  t0.producer_purchase_order_number AS producer_purchase_order_number_26,
  t0.limit_units_per_buyer AS limit_units_per_buyer_27,
  t0.limit_units_to_sell AS limit_units_to_sell_28,
  t0.coming_soon_date AS coming_soon_date_29,
  t0.offer_launch_date AS offer_launch_date_30,
  t0.countdown_date AS countdown_date_31,
  t0.end_offer_date AS end_offer_date_32,
  t0.shipping_date AS shipping_date_33,
  t0.individual_shipping_duration AS individual_shipping_duration_34,
  t0.shared_shipping_duration AS shared_shipping_duration_35,
  t0.individual_package_format AS individual_package_format_36,
  t0.n_hours_on_wall_after_end AS n_hours_on_wall_after_end_37,
  t0.max_coins_to_spent AS max_coins_to_spent_38,
  t0.original_price AS original_price_39,
  t0.individual_price AS individual_price_40,
  t0.individual_disabled AS individual_disabled_41,
  t0.fake_users AS fake_users_42,
  t0.additional_info AS additional_info_43,
  t0.shipping_cost AS shipping_cost_44,
  t0.holded_id AS holded_id_45,
  t0.only_adults AS only_adults_46,
  t0.amount_for_free_shipping AS amount_for_free_shipping_47,
  t0.better_price AS better_price_48,
  t0.meta_title AS meta_title_49,
  t0.meta_description AS meta_description_50,
  t0.show_price AS show_price_51,
  t0.created_by AS created_by_52,
  t0.updated_by AS updated_by_53,
  t0.created_at AS created_at_54,
  t0.updated_at AS updated_at_55,
  t0.type_id AS type_id_56,
  t0.iva_id AS iva_id_57,
  t0.brand_id AS brand_id_58,
  t0.producer_id AS producer_id_59,
  t0.unit_measurement_id AS unit_measurement_id_60,
  t0.product_unique_id AS product_unique_id_61,
  t0.shipping_id AS shipping_id_62
FROM
  product t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.is_draft AS is_draft_3, t0.is_blocked AS is_blocked_4, t0.is_sold_out AS is_sold_out_5, t0.weight AS weight_6, t0.width AS width_7, t0.length AS length_8, t0.height AS height_9, t0.volumetric_weight AS volumetric_weight_10, t0.units_per_box AS units_per_box_11, t0.units_per_box_grouped AS units_per_box_grouped_12, t0.hide_discount AS hide_discount_13, t0.ean AS ean_14, t0.purchase_order_number AS purchase_order_number_15, t0.is_mandatory_product_features AS is_mandatory_product_features_16, t0.is_mandatory_producer AS is_mandatory_producer_17, t0.is_mandatory_triweer_list AS is_mandatory_triweer_list_18, t0.is_mandatory_triweer_comments AS is_mandatory_triweer_comments_19, t0.is_live_shopping AS is_live_shopping_20, t0.has_blockchain_traceability AS has_blockchain_traceability_21, t0.show_on_wall AS show_on_wall_22, t0.allow_return AS allow_return_23, t0.n_days_allowed_for_return AS n_days_allowed_for_return_24, t0.send_notifications AS send_notifications_25, t0.producer_purchase_order_number AS producer_purchase_order_number_26, t0.limit_units_per_buyer AS limit_units_per_buyer_27, t0.limit_units_to_sell AS limit_units_to_sell_28, t0.coming_soon_date AS coming_soon_date_29, t0.offer_launch_date AS offer_launch_date_30, t0.countdown_date AS countdown_date_31, t0.end_offer_date AS end_offer_date_32, t0.shipping_date AS shipping_date_33, t0.individual_shipping_duration AS individual_shipping_duration_34, t0.shared_shipping_duration AS shared_shipping_duration_35, t0.individual_package_format AS individual_package_format_36, t0.n_hours_on_wall_after_end AS n_hours_on_wall_after_end_37, t0.max_coins_to_spent AS max_coins_to_spent_38, t0.original_price AS original_price_39, t0.individual_price AS individual_price_40, t0.individual_disabled AS individual_disabled_41, t0.fake_users AS fake_users_42, t0.additional_info AS additional_info_43, t0.shipping_cost AS shipping_cost_44, t0.holded_id AS holded_id_45, t0.only_adults AS only_adults_46, t0.amount_for_free_shipping AS amount_for_free_shipping_47, t0.better_price AS better_price_48, t0.meta_title AS meta_title_49, t0.meta_description AS meta_description_50, t0.show_price AS show_price_51, t0.created_by AS created_by_52, t0.updated_by AS updated_by_53, t0.created_at AS created_at_54, t0.updated_at AS updated_at_55, t0.type_id AS type_id_56, t0.iva_id AS iva_id_57, t0.brand_id AS brand_id_58, t0.producer_id AS producer_id_59, t0.unit_measurement_id AS unit_measurement_id_60, t0.product_unique_id AS product_unique_id_61, t0.shipping_id AS shipping_id_62 FROM product t0 WHERE t0.slug = 'cigala-bundle-6-cajas-vta-agrupada-2-cajas' LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.key AS key_1,
  b0_.created_by AS created_by_2,
  b0_.updated_by AS updated_by_3,
  b0_.created_at AS created_at_4,
  b0_.updated_at AS updated_at_5
FROM
  banner b0_
WHERE
  b0_.key = ?

SELECT b0_.id AS id_0, b0_.key AS key_1, b0_.created_by AS created_by_2, b0_.updated_by AS updated_by_3, b0_.created_at AS created_at_4, b0_.updated_at AS updated_at_5 FROM banner b0_ WHERE b0_.key = 'footer_banner';

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.nickname AS nickname_2,
  u0_.roles AS roles_3,
  u0_.password AS password_4,
  u0_.email AS email_5,
  u0_.is_on_boarding AS is_on_boarding_6,
  u0_.accepted_communications AS accepted_communications_7,
  u0_.accepted_policies AS accepted_policies_8,
  u0_.is_active AS is_active_9,
  u0_.legal_age AS legal_age_10,
  u0_.is_notifications_active AS is_notifications_active_11,
  u0_.is_verified AS is_verified_12,
  u0_.name AS name_13,
  u0_.surname AS surname_14,
  u0_.cif AS cif_15,
  u0_.phone AS phone_16,
  u0_.cpostal AS cpostal_17,
  u0_.sex AS sex_18,
  u0_.holded_id AS holded_id_19,
  u0_.notification_whatsapp AS notification_whatsapp_20,
  u0_.email_token AS email_token_21,
  u0_.email_token_expires_at AS email_token_expires_at_22,
  u0_.birthday AS birthday_23,
  u0_.bank_transfer_active AS bank_transfer_active_24,
  u0_.created_by AS created_by_25,
  u0_.updated_by AS updated_by_26,
  u0_.created_at AS created_at_27,
  u0_.updated_at AS updated_at_28,
  CASE WHEN f1_.id IS NULL THEN 0 ELSE 1 END AS sclr_29,
  u0_.avatar_id AS avatar_id_30,
  u0_.share_favourite_products_type_id AS share_favourite_products_type_id_31,
  u0_.share_shopping_type_id AS share_shopping_type_id_32,
  u0_.language_id AS language_id_33,
  u0_.payment_method_id AS payment_method_id_34
FROM
  "user" u0_
  INNER JOIN user_product u3_ ON u0_.id = u3_.user_id
  INNER JOIN product p2_ ON p2_.id = u3_.product_id
  INNER JOIN share_type s4_ ON u0_.share_favourite_products_type_id = s4_.id
  LEFT JOIN friend_triweer f1_ ON u0_.id = f1_.main_user_id
  AND (
    f1_.share_favourite_products = true
    AND s4_.key = ?
    AND f1_.friend_user_id = ?
  )
WHERE
  p2_.id = ?
  AND (
    s4_.key = ?
    OR s4_.key = ?
  )
ORDER BY
  sclr_29 ASC

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.nickname AS nickname_2, u0_.roles AS roles_3, u0_.password AS password_4, u0_.email AS email_5, u0_.is_on_boarding AS is_on_boarding_6, u0_.accepted_communications AS accepted_communications_7, u0_.accepted_policies AS accepted_policies_8, u0_.is_active AS is_active_9, u0_.legal_age AS legal_age_10, u0_.is_notifications_active AS is_notifications_active_11, u0_.is_verified AS is_verified_12, u0_.name AS name_13, u0_.surname AS surname_14, u0_.cif AS cif_15, u0_.phone AS phone_16, u0_.cpostal AS cpostal_17, u0_.sex AS sex_18, u0_.holded_id AS holded_id_19, u0_.notification_whatsapp AS notification_whatsapp_20, u0_.email_token AS email_token_21, u0_.email_token_expires_at AS email_token_expires_at_22, u0_.birthday AS birthday_23, u0_.bank_transfer_active AS bank_transfer_active_24, u0_.created_by AS created_by_25, u0_.updated_by AS updated_by_26, u0_.created_at AS created_at_27, u0_.updated_at AS updated_at_28, CASE WHEN f1_.id IS NULL THEN 0 ELSE 1 END AS sclr_29, u0_.avatar_id AS avatar_id_30, u0_.share_favourite_products_type_id AS share_favourite_products_type_id_31, u0_.share_shopping_type_id AS share_shopping_type_id_32, u0_.language_id AS language_id_33, u0_.payment_method_id AS payment_method_id_34 FROM "user" u0_ INNER JOIN user_product u3_ ON u0_.id = u3_.user_id INNER JOIN product p2_ ON p2_.id = u3_.product_id INNER JOIN share_type s4_ ON u0_.share_favourite_products_type_id = s4_.id LEFT JOIN friend_triweer f1_ ON u0_.id = f1_.main_user_id AND (f1_.share_favourite_products = true AND s4_.key = 'FRIENDS' AND f1_.friend_user_id = -1) WHERE p2_.id = 310 AND (s4_.key = 'ALL' OR s4_.key = 'FRIENDS') ORDER BY sclr_29 ASC;

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.nickname AS nickname_2,
  u0_.roles AS roles_3,
  u0_.password AS password_4,
  u0_.email AS email_5,
  u0_.is_on_boarding AS is_on_boarding_6,
  u0_.accepted_communications AS accepted_communications_7,
  u0_.accepted_policies AS accepted_policies_8,
  u0_.is_active AS is_active_9,
  u0_.legal_age AS legal_age_10,
  u0_.is_notifications_active AS is_notifications_active_11,
  u0_.is_verified AS is_verified_12,
  u0_.name AS name_13,
  u0_.surname AS surname_14,
  u0_.cif AS cif_15,
  u0_.phone AS phone_16,
  u0_.cpostal AS cpostal_17,
  u0_.sex AS sex_18,
  u0_.holded_id AS holded_id_19,
  u0_.notification_whatsapp AS notification_whatsapp_20,
  u0_.email_token AS email_token_21,
  u0_.email_token_expires_at AS email_token_expires_at_22,
  u0_.birthday AS birthday_23,
  u0_.bank_transfer_active AS bank_transfer_active_24,
  u0_.created_by AS created_by_25,
  u0_.updated_by AS updated_by_26,
  u0_.created_at AS created_at_27,
  u0_.updated_at AS updated_at_28,
  CASE WHEN f1_.id IS NULL THEN 0 ELSE 1 END AS sclr_29,
  u0_.avatar_id AS avatar_id_30,
  u0_.share_favourite_products_type_id AS share_favourite_products_type_id_31,
  u0_.share_shopping_type_id AS share_shopping_type_id_32,
  u0_.language_id AS language_id_33,
  u0_.payment_method_id AS payment_method_id_34
FROM
  "user" u0_
  INNER JOIN share_type s2_ ON u0_.share_shopping_type_id = s2_.id
  INNER JOIN "order" o3_ ON u0_.id = o3_.buyer_id
  INNER JOIN order_status o4_ ON o3_.status_id = o4_.id
  INNER JOIN order_detail o5_ ON o3_.id = o5_.header_id
  LEFT JOIN friend_triweer f1_ ON u0_.id = f1_.main_user_id
  AND (
    f1_.share_shopping = true
    AND s2_.key = ?
    AND f1_.friend_user_id = ?
  )
WHERE
  o5_.product_id = ?
  AND (
    s2_.key = ?
    OR s2_.key = ?
  )
  AND o4_.key NOT IN (?, ?)
ORDER BY
  sclr_29 ASC

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.nickname AS nickname_2, u0_.roles AS roles_3, u0_.password AS password_4, u0_.email AS email_5, u0_.is_on_boarding AS is_on_boarding_6, u0_.accepted_communications AS accepted_communications_7, u0_.accepted_policies AS accepted_policies_8, u0_.is_active AS is_active_9, u0_.legal_age AS legal_age_10, u0_.is_notifications_active AS is_notifications_active_11, u0_.is_verified AS is_verified_12, u0_.name AS name_13, u0_.surname AS surname_14, u0_.cif AS cif_15, u0_.phone AS phone_16, u0_.cpostal AS cpostal_17, u0_.sex AS sex_18, u0_.holded_id AS holded_id_19, u0_.notification_whatsapp AS notification_whatsapp_20, u0_.email_token AS email_token_21, u0_.email_token_expires_at AS email_token_expires_at_22, u0_.birthday AS birthday_23, u0_.bank_transfer_active AS bank_transfer_active_24, u0_.created_by AS created_by_25, u0_.updated_by AS updated_by_26, u0_.created_at AS created_at_27, u0_.updated_at AS updated_at_28, CASE WHEN f1_.id IS NULL THEN 0 ELSE 1 END AS sclr_29, u0_.avatar_id AS avatar_id_30, u0_.share_favourite_products_type_id AS share_favourite_products_type_id_31, u0_.share_shopping_type_id AS share_shopping_type_id_32, u0_.language_id AS language_id_33, u0_.payment_method_id AS payment_method_id_34 FROM "user" u0_ INNER JOIN share_type s2_ ON u0_.share_shopping_type_id = s2_.id INNER JOIN "order" o3_ ON u0_.id = o3_.buyer_id INNER JOIN order_status o4_ ON o3_.status_id = o4_.id INNER JOIN order_detail o5_ ON o3_.id = o5_.header_id LEFT JOIN friend_triweer f1_ ON u0_.id = f1_.main_user_id AND (f1_.share_shopping = true AND s2_.key = 'FRIENDS' AND f1_.friend_user_id = -1) WHERE o5_.product_id = 310 AND (s2_.key = 'ALL' OR s2_.key = 'FRIENDS') AND o4_.key NOT IN ('PENDING_PAYMENT', 'CANCELED') ORDER BY sclr_29 ASC;

SELECT
  t0.id AS id_1,
  t0.save_card AS save_card_2,
  t0.is_billing_address_same_as_shipping AS is_billing_address_same_as_shipping_3,
  t0.delivery_method AS delivery_method_4,
  t0.use_coins AS use_coins_5,
  t0.payment_method AS payment_method_6,
  t0.phone AS phone_7,
  t0.need_bill AS need_bill_8,
  t0.cif AS cif_9,
  t0.buy_not_enought AS buy_not_enought_10,
  t0.better_price AS better_price_11,
  t0.is_individual_purchase AS is_individual_purchase_12,
  t0.created_by AS created_by_13,
  t0.updated_by AS updated_by_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.buyer_id AS buyer_id_17,
  t0.card_id AS card_id_18,
  t0.shipping_address_entity_id AS shipping_address_entity_id_19,
  t0.buying_group_entity_id AS buying_group_entity_id_20,
  t0.shared_shipping_address_entity_id AS shared_shipping_address_entity_id_21,
  t0.billing_address_entity_id AS billing_address_entity_id_22
FROM
  shopping_cart t0
WHERE
  t0.buyer_id = ?

SELECT t0.id AS id_1, t0.save_card AS save_card_2, t0.is_billing_address_same_as_shipping AS is_billing_address_same_as_shipping_3, t0.delivery_method AS delivery_method_4, t0.use_coins AS use_coins_5, t0.payment_method AS payment_method_6, t0.phone AS phone_7, t0.need_bill AS need_bill_8, t0.cif AS cif_9, t0.buy_not_enought AS buy_not_enought_10, t0.better_price AS better_price_11, t0.is_individual_purchase AS is_individual_purchase_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.buyer_id AS buyer_id_17, t0.card_id AS card_id_18, t0.shipping_address_entity_id AS shipping_address_entity_id_19, t0.buying_group_entity_id AS buying_group_entity_id_20, t0.shared_shipping_address_entity_id AS shared_shipping_address_entity_id_21, t0.billing_address_entity_id AS billing_address_entity_id_22 FROM shopping_cart t0 WHERE t0.buyer_id = 3;

SELECT
  t0.id AS id_1,
  t0.save_card AS save_card_2,
  t0.is_billing_address_same_as_shipping AS is_billing_address_same_as_shipping_3,
  t0.delivery_method AS delivery_method_4,
  t0.use_coins AS use_coins_5,
  t0.payment_method AS payment_method_6,
  t0.phone AS phone_7,
  t0.need_bill AS need_bill_8,
  t0.cif AS cif_9,
  t0.buy_not_enought AS buy_not_enought_10,
  t0.better_price AS better_price_11,
  t0.is_individual_purchase AS is_individual_purchase_12,
  t0.created_by AS created_by_13,
  t0.updated_by AS updated_by_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.buyer_id AS buyer_id_17,
  t0.card_id AS card_id_18,
  t0.shipping_address_entity_id AS shipping_address_entity_id_19,
  t0.buying_group_entity_id AS buying_group_entity_id_20,
  t0.shared_shipping_address_entity_id AS shared_shipping_address_entity_id_21,
  t0.billing_address_entity_id AS billing_address_entity_id_22
FROM
  shopping_cart t0
WHERE
  t0.buyer_id = ?

SELECT t0.id AS id_1, t0.save_card AS save_card_2, t0.is_billing_address_same_as_shipping AS is_billing_address_same_as_shipping_3, t0.delivery_method AS delivery_method_4, t0.use_coins AS use_coins_5, t0.payment_method AS payment_method_6, t0.phone AS phone_7, t0.need_bill AS need_bill_8, t0.cif AS cif_9, t0.buy_not_enought AS buy_not_enought_10, t0.better_price AS better_price_11, t0.is_individual_purchase AS is_individual_purchase_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.buyer_id AS buyer_id_17, t0.card_id AS card_id_18, t0.shipping_address_entity_id AS shipping_address_entity_id_19, t0.buying_group_entity_id AS buying_group_entity_id_20, t0.shared_shipping_address_entity_id AS shared_shipping_address_entity_id_21, t0.billing_address_entity_id AS billing_address_entity_id_22 FROM shopping_cart t0 WHERE t0.buyer_id = 4;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.nickname AS nickname_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.email AS email_6,
  t0.is_on_boarding AS is_on_boarding_7,
  t0.accepted_communications AS accepted_communications_8,
  t0.accepted_policies AS accepted_policies_9,
  t0.is_active AS is_active_10,
  t0.legal_age AS legal_age_11,
  t0.is_notifications_active AS is_notifications_active_12,
  t0.is_verified AS is_verified_13,
  t0.name AS name_14,
  t0.surname AS surname_15,
  t0.cif AS cif_16,
  t0.phone AS phone_17,
  t0.cpostal AS cpostal_18,
  t0.sex AS sex_19,
  t0.holded_id AS holded_id_20,
  t0.notification_whatsapp AS notification_whatsapp_21,
  t0.email_token AS email_token_22,
  t0.email_token_expires_at AS email_token_expires_at_23,
  t0.birthday AS birthday_24,
  t0.bank_transfer_active AS bank_transfer_active_25,
  t0.created_by AS created_by_26,
  t0.updated_by AS updated_by_27,
  t0.created_at AS created_at_28,
  t0.updated_at AS updated_at_29,
  t0.avatar_id AS avatar_id_30,
  t31.id AS id_32,
  t31.save_card AS save_card_33,
  t31.is_billing_address_same_as_shipping AS is_billing_address_same_as_shipping_34,
  t31.delivery_method AS delivery_method_35,
  t31.use_coins AS use_coins_36,
  t31.payment_method AS payment_method_37,
  t31.phone AS phone_38,
  t31.need_bill AS need_bill_39,
  t31.cif AS cif_40,
  t31.buy_not_enought AS buy_not_enought_41,
  t31.better_price AS better_price_42,
  t31.is_individual_purchase AS is_individual_purchase_43,
  t31.created_by AS created_by_44,
  t31.updated_by AS updated_by_45,
  t31.created_at AS created_at_46,
  t31.updated_at AS updated_at_47,
  t31.buyer_id AS buyer_id_48,
  t31.card_id AS card_id_49,
  t31.shipping_address_entity_id AS shipping_address_entity_id_50,
  t31.buying_group_entity_id AS buying_group_entity_id_51,
  t31.shared_shipping_address_entity_id AS shared_shipping_address_entity_id_52,
  t31.billing_address_entity_id AS billing_address_entity_id_53,
  t0.share_favourite_products_type_id AS share_favourite_products_type_id_54,
  t0.share_shopping_type_id AS share_shopping_type_id_55,
  t0.language_id AS language_id_56,
  t0.payment_method_id AS payment_method_id_57
FROM
  "user" t0
  LEFT JOIN shopping_cart t31 ON t31.buyer_id = t0.id
  INNER JOIN faketriweers_product ON t0.id = faketriweers_product.product_id
WHERE
  faketriweers_product.fake_triweer_id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.nickname AS nickname_3, t0.roles AS roles_4, t0.password AS password_5, t0.email AS email_6, t0.is_on_boarding AS is_on_boarding_7, t0.accepted_communications AS accepted_communications_8, t0.accepted_policies AS accepted_policies_9, t0.is_active AS is_active_10, t0.legal_age AS legal_age_11, t0.is_notifications_active AS is_notifications_active_12, t0.is_verified AS is_verified_13, t0.name AS name_14, t0.surname AS surname_15, t0.cif AS cif_16, t0.phone AS phone_17, t0.cpostal AS cpostal_18, t0.sex AS sex_19, t0.holded_id AS holded_id_20, t0.notification_whatsapp AS notification_whatsapp_21, t0.email_token AS email_token_22, t0.email_token_expires_at AS email_token_expires_at_23, t0.birthday AS birthday_24, t0.bank_transfer_active AS bank_transfer_active_25, t0.created_by AS created_by_26, t0.updated_by AS updated_by_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.avatar_id AS avatar_id_30, t31.id AS id_32, t31.save_card AS save_card_33, t31.is_billing_address_same_as_shipping AS is_billing_address_same_as_shipping_34, t31.delivery_method AS delivery_method_35, t31.use_coins AS use_coins_36, t31.payment_method AS payment_method_37, t31.phone AS phone_38, t31.need_bill AS need_bill_39, t31.cif AS cif_40, t31.buy_not_enought AS buy_not_enought_41, t31.better_price AS better_price_42, t31.is_individual_purchase AS is_individual_purchase_43, t31.created_by AS created_by_44, t31.updated_by AS updated_by_45, t31.created_at AS created_at_46, t31.updated_at AS updated_at_47, t31.buyer_id AS buyer_id_48, t31.card_id AS card_id_49, t31.shipping_address_entity_id AS shipping_address_entity_id_50, t31.buying_group_entity_id AS buying_group_entity_id_51, t31.shared_shipping_address_entity_id AS shared_shipping_address_entity_id_52, t31.billing_address_entity_id AS billing_address_entity_id_53, t0.share_favourite_products_type_id AS share_favourite_products_type_id_54, t0.share_shopping_type_id AS share_shopping_type_id_55, t0.language_id AS language_id_56, t0.payment_method_id AS payment_method_id_57 FROM "user" t0 LEFT JOIN shopping_cart t31 ON t31.buyer_id = t0.id INNER JOIN faketriweers_product ON t0.id = faketriweers_product.product_id WHERE faketriweers_product.fake_triweer_id = 310;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.additional_info AS additional_info_3,
  t0.product_features AS product_features_4,
  t0.how_it_works AS how_it_works_5,
  t0.cart_units_message AS cart_units_message_6,
  t0.shared_package_format AS shared_package_format_7,
  t0.locale AS locale_8,
  t0.translatable_id AS translatable_id_9
FROM
  product_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.additional_info AS additional_info_3, t0.product_features AS product_features_4, t0.how_it_works AS how_it_works_5, t0.cart_units_message AS cart_units_message_6, t0.shared_package_format AS shared_package_format_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM product_translation t0 WHERE t0.translatable_id = 310;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.hidden_on_cover AS hidden_on_cover_3,
  t0.created_by AS created_by_4,
  t0.updated_by AS updated_by_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.logo_id AS logo_id_8
FROM
  brand t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.hidden_on_cover AS hidden_on_cover_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.logo_id AS logo_id_8 FROM brand t0 WHERE t0.id = 110;

SELECT
  t0.id AS id_1,
  t0.features AS features_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  brand_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.features AS features_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM brand_translation t0 WHERE t0.translatable_id = 110;

SELECT
  t0.id AS id_1,
  t0.rating AS rating_2,
  t0.visible AS visible_3,
  t0.created_by AS created_by_4,
  t0.updated_by AS updated_by_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.user_id AS user_id_8,
  t0.product_id AS product_id_9
FROM
  review t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.rating AS rating_2, t0.visible AS visible_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.user_id AS user_id_8, t0.product_id AS product_id_9 FROM review t0 WHERE t0.product_id = 310;

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_.meta_title AS meta_title_55,
  p0_.type_id AS type_id_56,
  p0_.iva_id AS iva_id_57,
  p0_.brand_id AS brand_id_58,
  p0_.producer_id AS producer_id_59,
  p0_.unit_measurement_id AS unit_measurement_id_60,
  p0_.product_unique_id AS product_unique_id_61,
  p0_.shipping_id AS shipping_id_62
FROM
  product p0_
WHERE
  p0_.slug = ?

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_.meta_title AS meta_title_55, p0_.type_id AS type_id_56, p0_.iva_id AS iva_id_57, p0_.brand_id AS brand_id_58, p0_.producer_id AS producer_id_59, p0_.unit_measurement_id AS unit_measurement_id_60, p0_.product_unique_id AS product_unique_id_61, p0_.shipping_id AS shipping_id_62 FROM product p0_ WHERE p0_.slug = 'cigala-bundle-6-cajas-vta-agrupada-2-cajas';

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_.meta_description AS meta_description_55,
  p0_.type_id AS type_id_56,
  p0_.iva_id AS iva_id_57,
  p0_.brand_id AS brand_id_58,
  p0_.producer_id AS producer_id_59,
  p0_.unit_measurement_id AS unit_measurement_id_60,
  p0_.product_unique_id AS product_unique_id_61,
  p0_.shipping_id AS shipping_id_62
FROM
  product p0_
WHERE
  p0_.slug = ?