Symfony Profiler

SELECT 
  t0.id AS id_1, 
  t0.orig_name AS orig_name_2, 
  t0.orig_brand_name AS orig_brand_name_3, 
  t0.qty_left AS qty_left_4, 
  t0.unit_amount AS unit_amount_5, 
  t0.unit AS unit_6, 
  t0.available AS available_7, 
  t0.orig_description AS orig_description_8, 
  t0.origin AS origin_9, 
  t0.best_before AS best_before_10, 
  t0.creation_date AS creation_date_11, 
  t0.nutrition_fact AS nutrition_fact_12, 
  t0.new_product AS new_product_13, 
  t0.taxable AS taxable_14, 
  t0.maturin_upc AS maturin_upc_15, 
  t0.code_upc AS code_upc_16, 
  t0.code1 AS code1_17, 
  t0.code2 AS code2_18, 
  t0.code3 AS code3_19, 
  t0.code_box AS code_box_20, 
  t0.aliments_du_quebec AS aliments_du_quebec_21, 
  t0.minimum_in_storage AS minimum_in_storage_22, 
  t0.limited_quantity AS limited_quantity_23, 
  t0.aliments_du_quebec_certification AS aliments_du_quebec_certification_24, 
  t0.delivery_type AS delivery_type_25, 
  t0.delivery_pickup AS delivery_pickup_26, 
  t0.draft AS draft_27, 
  t0.delivery_mail AS delivery_mail_28, 
  t0.advices AS advices_29, 
  t0.recipes AS recipes_30, 
  t0.solex_id AS solex_id_31, 
  t0.list_of_ingredients AS list_of_ingredients_32, 
  t0.qty_ready_to_ship AS qty_ready_to_ship_33, 
  t0.expiration_date AS expiration_date_34, 
  t0.is_consigned AS is_consigned_35, 
  t0.consigned_cost AS consigned_cost_36, 
  t0.is_fragile AS is_fragile_37, 
  t0.qty_per_unit AS qty_per_unit_38, 
  t0.validated_by_distributor AS validated_by_distributor_39, 
  t0.delivery_note AS delivery_note_40, 
  t0.is_just_in_time AS is_just_in_time_41, 
  t0.reminder_low_quantity_sent AS reminder_low_quantity_sent_42, 
  t0.has_multiple_products AS has_multiple_products_43, 
  t0.has_free_maturin_shipping AS has_free_maturin_shipping_44, 
  t0.action_when_expired AS action_when_expired_45, 
  t0.is_subscribable AS is_subscribable_46, 
  t0.is_box_of_products AS is_box_of_products_47, 
  t0.is_only_subscribable AS is_only_subscribable_48, 
  t0.just_in_time_delivery_date AS just_in_time_delivery_date_49, 
  t0.free_maturin_shipping_if_lower_then AS free_maturin_shipping_if_lower_then_50, 
  t0.is_only_subscribable_to_type AS is_only_subscribable_to_type_51, 
  t0.quantity_warehouse AS quantity_warehouse_52, 
  t0.quantity_warehouse_reserved AS quantity_warehouse_reserved_53, 
  t0.quantity_on_hold AS quantity_on_hold_54, 
  t0.parent_product_id AS parent_product_id_55, 
  t0.fee_warehouse_packing_per_unit AS fee_warehouse_packing_per_unit_56, 
  t0.fee_warehouse_handling_per_unit AS fee_warehouse_handling_per_unit_57, 
  t0.is_displayed_in_association_only AS is_displayed_in_association_only_58, 
  t0.is_hri AS is_hri_59, 
  t0.puro_exclusion AS puro_exclusion_60, 
  t0.contains_alcohol AS contains_alcohol_61, 
  t0.is_consumer AS is_consumer_62, 
  t0.product_colabor_price AS product_colabor_price_63, 
  t0.is_prix_laureat AS is_prix_laureat_64, 
  t0.cant_use_coupon AS cant_use_coupon_65, 
  t0.seasonality AS seasonality_66, 
  t0.seasonality_start AS seasonality_start_67, 
  t0.seasonality_end AS seasonality_end_68, 
  t0.quantity_max_prod AS quantity_max_prod_69, 
  t0.product_delete AS product_delete_70, 
  t0.order_frequency AS order_frequency_71, 
  t0.portion_for_meal AS portion_for_meal_72, 
  t0.categories_id AS categories_id_73, 
  t0.conservation_id AS conservation_id_74, 
  t0.main_image_id AS main_image_id_75, 
  t0.company_id AS company_id_76, 
  t0.region_id AS region_id_77, 
  t0.nutrition_fact_image_id AS nutrition_fact_image_id_78, 
  t79.id AS id_80, 
  t79.price_to_company AS price_to_company_81, 
  t79.quantity AS quantity_82, 
  t79.product_id AS product_id_83, 
  t0.sub_category_id AS sub_category_id_84, 
  t0.corporative_id AS corporative_id_85 
FROM 
  product t0 
  LEFT JOIN product_deal t79 ON t79.product_id = t0.id 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.orig_name AS orig_name_2, t0.orig_brand_name AS orig_brand_name_3, t0.qty_left AS qty_left_4, t0.unit_amount AS unit_amount_5, t0.unit AS unit_6, t0.available AS available_7, t0.orig_description AS orig_description_8, t0.origin AS origin_9, t0.best_before AS best_before_10, t0.creation_date AS creation_date_11, t0.nutrition_fact AS nutrition_fact_12, t0.new_product AS new_product_13, t0.taxable AS taxable_14, t0.maturin_upc AS maturin_upc_15, t0.code_upc AS code_upc_16, t0.code1 AS code1_17, t0.code2 AS code2_18, t0.code3 AS code3_19, t0.code_box AS code_box_20, t0.aliments_du_quebec AS aliments_du_quebec_21, t0.minimum_in_storage AS minimum_in_storage_22, t0.limited_quantity AS limited_quantity_23, t0.aliments_du_quebec_certification AS aliments_du_quebec_certification_24, t0.delivery_type AS delivery_type_25, t0.delivery_pickup AS delivery_pickup_26, t0.draft AS draft_27, t0.delivery_mail AS delivery_mail_28, t0.advices AS advices_29, t0.recipes AS recipes_30, t0.solex_id AS solex_id_31, t0.list_of_ingredients AS list_of_ingredients_32, t0.qty_ready_to_ship AS qty_ready_to_ship_33, t0.expiration_date AS expiration_date_34, t0.is_consigned AS is_consigned_35, t0.consigned_cost AS consigned_cost_36, t0.is_fragile AS is_fragile_37, t0.qty_per_unit AS qty_per_unit_38, t0.validated_by_distributor AS validated_by_distributor_39, t0.delivery_note AS delivery_note_40, t0.is_just_in_time AS is_just_in_time_41, t0.reminder_low_quantity_sent AS reminder_low_quantity_sent_42, t0.has_multiple_products AS has_multiple_products_43, t0.has_free_maturin_shipping AS has_free_maturin_shipping_44, t0.action_when_expired AS action_when_expired_45, t0.is_subscribable AS is_subscribable_46, t0.is_box_of_products AS is_box_of_products_47, t0.is_only_subscribable AS is_only_subscribable_48, t0.just_in_time_delivery_date AS just_in_time_delivery_date_49, t0.free_maturin_shipping_if_lower_then AS free_maturin_shipping_if_lower_then_50, t0.is_only_subscribable_to_type AS is_only_subscribable_to_type_51, t0.quantity_warehouse AS quantity_warehouse_52, t0.quantity_warehouse_reserved AS quantity_warehouse_reserved_53, t0.quantity_on_hold AS quantity_on_hold_54, t0.parent_product_id AS parent_product_id_55, t0.fee_warehouse_packing_per_unit AS fee_warehouse_packing_per_unit_56, t0.fee_warehouse_handling_per_unit AS fee_warehouse_handling_per_unit_57, t0.is_displayed_in_association_only AS is_displayed_in_association_only_58, t0.is_hri AS is_hri_59, t0.puro_exclusion AS puro_exclusion_60, t0.contains_alcohol AS contains_alcohol_61, t0.is_consumer AS is_consumer_62, t0.product_colabor_price AS product_colabor_price_63, t0.is_prix_laureat AS is_prix_laureat_64, t0.cant_use_coupon AS cant_use_coupon_65, t0.seasonality AS seasonality_66, t0.seasonality_start AS seasonality_start_67, t0.seasonality_end AS seasonality_end_68, t0.quantity_max_prod AS quantity_max_prod_69, t0.product_delete AS product_delete_70, t0.order_frequency AS order_frequency_71, t0.portion_for_meal AS portion_for_meal_72, t0.categories_id AS categories_id_73, t0.conservation_id AS conservation_id_74, t0.main_image_id AS main_image_id_75, t0.company_id AS company_id_76, t0.region_id AS region_id_77, t0.nutrition_fact_image_id AS nutrition_fact_image_id_78, t79.id AS id_80, t79.price_to_company AS price_to_company_81, t79.quantity AS quantity_82, t79.product_id AS product_id_83, t0.sub_category_id AS sub_category_id_84, t0.corporative_id AS corporative_id_85 FROM product t0 LEFT JOIN product_deal t79 ON t79.product_id = t0.id WHERE t0.id = '6784';

SELECT 
  t0.id AS id_1, 
  t0.date_created AS date_created_2, 
  t0.stripe_token AS stripe_token_3, 
  t0.stripe_response AS stripe_response_4, 
  t0.is_paid AS is_paid_5, 
  t0.solex_order_id AS solex_order_id_6, 
  t0.date_payment AS date_payment_7, 
  t0.shipping_estimation_raw AS shipping_estimation_raw_8, 
  t0.shipping_maturin_cost AS shipping_maturin_cost_9, 
  t0.shipping_maturin_carrier_name AS shipping_maturin_carrier_name_10, 
  t0.shipping_maturin_service_name AS shipping_maturin_service_name_11, 
  t0.shipping_maturin_estimated_date AS shipping_maturin_estimated_date_12, 
  t0.picking_and_packing_fee AS picking_and_packing_fee_13, 
  t0.payment_fee AS payment_fee_14, 
  t0.maturin_fee AS maturin_fee_15, 
  t0.taxes_products AS taxes_products_16, 
  t0.taxes_maturin AS taxes_maturin_17, 
  t0.taxes_shipping_maturin AS taxes_shipping_maturin_18, 
  t0.taxes_shipping_company AS taxes_shipping_company_19, 
  t0.taxes_packing AS taxes_packing_20, 
  t0.shipping_maturin_service_id AS shipping_maturin_service_id_21, 
  t0.solex_order_raw AS solex_order_raw_22, 
  t0.maturin_tracking_info AS maturin_tracking_info_23, 
  t0.order_no AS order_no_24, 
  t0.is_on_hold AS is_on_hold_25, 
  t0.just_in_time_email_sent AS just_in_time_email_sent_26, 
  t0.reminder_sent AS reminder_sent_27, 
  t0.raw_distributor_billing AS raw_distributor_billing_28, 
  t0.taxes_products_calculations AS taxes_products_calculations_29, 
  t0.taxes_shipping_maturin_calculations AS taxes_shipping_maturin_calculations_30, 
  t0.taxes_shipping_company_calculations AS taxes_shipping_company_calculations_31, 
  t0.taxes_packing_calculations AS taxes_packing_calculations_32, 
  t0.amount_saved_by_coupon AS amount_saved_by_coupon_33, 
  t0.shipping_signature_required AS shipping_signature_required_34, 
  t0.signature_mandatory AS signature_mandatory_35, 
  t0.extra_priority_points AS extra_priority_points_36, 
  t0.warehouse_group_id AS warehouse_group_id_37, 
  t0.is_refunded AS is_refunded_38, 
  t0.refund_stripe_response AS refund_stripe_response_39, 
  t0.note_from_buyer AS note_from_buyer_40, 
  t0.is_bulk_order AS is_bulk_order_41, 
  t0.track_link AS track_link_42, 
  t0.track_pod_status_id AS track_pod_status_id_43, 
  t0.delivery_choice_date AS delivery_choice_date_44, 
  t0.pre_order AS pre_order_45, 
  t0.pre_order_now AS pre_order_now_46, 
  t0.shipping_address_id AS shipping_address_id_47, 
  t0.user_id AS user_id_48, 
  t0.used_coupon_id AS used_coupon_id_49, 
  t0.logistic_invoice_id AS logistic_invoice_id_50, 
  t0.send_with_subscription_id AS send_with_subscription_id_51, 
  t0.from_subscription_id AS from_subscription_id_52 
FROM 
  cart t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.stripe_token AS stripe_token_3, t0.stripe_response AS stripe_response_4, t0.is_paid AS is_paid_5, t0.solex_order_id AS solex_order_id_6, t0.date_payment AS date_payment_7, t0.shipping_estimation_raw AS shipping_estimation_raw_8, t0.shipping_maturin_cost AS shipping_maturin_cost_9, t0.shipping_maturin_carrier_name AS shipping_maturin_carrier_name_10, t0.shipping_maturin_service_name AS shipping_maturin_service_name_11, t0.shipping_maturin_estimated_date AS shipping_maturin_estimated_date_12, t0.picking_and_packing_fee AS picking_and_packing_fee_13, t0.payment_fee AS payment_fee_14, t0.maturin_fee AS maturin_fee_15, t0.taxes_products AS taxes_products_16, t0.taxes_maturin AS taxes_maturin_17, t0.taxes_shipping_maturin AS taxes_shipping_maturin_18, t0.taxes_shipping_company AS taxes_shipping_company_19, t0.taxes_packing AS taxes_packing_20, t0.shipping_maturin_service_id AS shipping_maturin_service_id_21, t0.solex_order_raw AS solex_order_raw_22, t0.maturin_tracking_info AS maturin_tracking_info_23, t0.order_no AS order_no_24, t0.is_on_hold AS is_on_hold_25, t0.just_in_time_email_sent AS just_in_time_email_sent_26, t0.reminder_sent AS reminder_sent_27, t0.raw_distributor_billing AS raw_distributor_billing_28, t0.taxes_products_calculations AS taxes_products_calculations_29, t0.taxes_shipping_maturin_calculations AS taxes_shipping_maturin_calculations_30, t0.taxes_shipping_company_calculations AS taxes_shipping_company_calculations_31, t0.taxes_packing_calculations AS taxes_packing_calculations_32, t0.amount_saved_by_coupon AS amount_saved_by_coupon_33, t0.shipping_signature_required AS shipping_signature_required_34, t0.signature_mandatory AS signature_mandatory_35, t0.extra_priority_points AS extra_priority_points_36, t0.warehouse_group_id AS warehouse_group_id_37, t0.is_refunded AS is_refunded_38, t0.refund_stripe_response AS refund_stripe_response_39, t0.note_from_buyer AS note_from_buyer_40, t0.is_bulk_order AS is_bulk_order_41, t0.track_link AS track_link_42, t0.track_pod_status_id AS track_pod_status_id_43, t0.delivery_choice_date AS delivery_choice_date_44, t0.pre_order AS pre_order_45, t0.pre_order_now AS pre_order_now_46, t0.shipping_address_id AS shipping_address_id_47, t0.user_id AS user_id_48, t0.used_coupon_id AS used_coupon_id_49, t0.logistic_invoice_id AS logistic_invoice_id_50, t0.send_with_subscription_id AS send_with_subscription_id_51, t0.from_subscription_id AS from_subscription_id_52 FROM cart t0 WHERE t0.id = 16910330;

SELECT 
  t0.id AS id_1, 
  t0.date_created AS date_created_2, 
  t0.quantity AS quantity_3, 
  t0.is_shipped AS is_shipped_4, 
  t0.price_paid_shipping AS price_paid_shipping_5, 
  t0.price_paid_product AS price_paid_product_6, 
  t0.has_combined_shipping AS has_combined_shipping_7, 
  t0.pricings_used AS pricings_used_8, 
  t0.carrier_name AS carrier_name_9, 
  t0.carrier_trackings AS carrier_trackings_10, 
  t0.for_invoicing_only AS for_invoicing_only_11, 
  t0.is_recurring_one_time_only AS is_recurring_one_time_only_12, 
  t0.recurring_frequency AS recurring_frequency_13, 
  t0.overwrite_subscription AS overwrite_subscription_14, 
  t0.qty_missing_in_shipment AS qty_missing_in_shipment_15, 
  t0.cart_id AS cart_id_16, 
  t0.product_id AS product_id_17, 
  t0.pricing_id AS pricing_id_18, 
  t0.company_delivery_method_id AS company_delivery_method_id_19, 
  t0.custom_order_id AS custom_order_id_20, 
  t0.maturin_order_id AS maturin_order_id_21, 
  t0.invoicing_cart_id AS invoicing_cart_id_22, 
  t0.added_when_being_in_association_id AS added_when_being_in_association_id_23 
FROM 
  cart_product t0 
WHERE 
  t0.cart_id = ?

SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.quantity AS quantity_3, t0.is_shipped AS is_shipped_4, t0.price_paid_shipping AS price_paid_shipping_5, t0.price_paid_product AS price_paid_product_6, t0.has_combined_shipping AS has_combined_shipping_7, t0.pricings_used AS pricings_used_8, t0.carrier_name AS carrier_name_9, t0.carrier_trackings AS carrier_trackings_10, t0.for_invoicing_only AS for_invoicing_only_11, t0.is_recurring_one_time_only AS is_recurring_one_time_only_12, t0.recurring_frequency AS recurring_frequency_13, t0.overwrite_subscription AS overwrite_subscription_14, t0.qty_missing_in_shipment AS qty_missing_in_shipment_15, t0.cart_id AS cart_id_16, t0.product_id AS product_id_17, t0.pricing_id AS pricing_id_18, t0.company_delivery_method_id AS company_delivery_method_id_19, t0.custom_order_id AS custom_order_id_20, t0.maturin_order_id AS maturin_order_id_21, t0.invoicing_cart_id AS invoicing_cart_id_22, t0.added_when_being_in_association_id AS added_when_being_in_association_id_23 FROM cart_product t0 WHERE t0.cart_id = 16910330;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO cart_product (
  date_created, quantity, is_shipped, 
  price_paid_shipping, price_paid_product, 
  has_combined_shipping, pricings_used, 
  carrier_name, carrier_trackings, 
  for_invoicing_only, is_recurring_one_time_only, 
  recurring_frequency, overwrite_subscription, 
  qty_missing_in_shipment, cart_id, 
  product_id, pricing_id, company_delivery_method_id, 
  custom_order_id, maturin_order_id, 
  invoicing_cart_id, added_when_being_in_association_id
) 
VALUES 
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
    ?, ?, ?, ?, ?, ?
  )

INSERT INTO cart_product (date_created, quantity, is_shipped, price_paid_shipping, price_paid_product, has_combined_shipping, pricings_used, carrier_name, carrier_trackings, for_invoicing_only, is_recurring_one_time_only, recurring_frequency, overwrite_subscription, qty_missing_in_shipment, cart_id, product_id, pricing_id, company_delivery_method_id, custom_order_id, maturin_order_id, invoicing_cart_id, added_when_being_in_association_id) VALUES ('2025-11-04 00:39:36', 1, 0, NULL, NULL, 0, 'a:0:{}', NULL, NULL, 0, 0, NULL, 0, 0, 16910330, 6784, NULL, NULL, NULL, NULL, NULL, NULL);

"COMMIT"

"COMMIT";

SELECT 
  t0.id AS id_1, 
  t0.orig_name AS orig_name_2, 
  t0.orig_brand_name AS orig_brand_name_3, 
  t0.qty_left AS qty_left_4, 
  t0.unit_amount AS unit_amount_5, 
  t0.unit AS unit_6, 
  t0.available AS available_7, 
  t0.orig_description AS orig_description_8, 
  t0.origin AS origin_9, 
  t0.best_before AS best_before_10, 
  t0.creation_date AS creation_date_11, 
  t0.nutrition_fact AS nutrition_fact_12, 
  t0.new_product AS new_product_13, 
  t0.taxable AS taxable_14, 
  t0.maturin_upc AS maturin_upc_15, 
  t0.code_upc AS code_upc_16, 
  t0.code1 AS code1_17, 
  t0.code2 AS code2_18, 
  t0.code3 AS code3_19, 
  t0.code_box AS code_box_20, 
  t0.aliments_du_quebec AS aliments_du_quebec_21, 
  t0.minimum_in_storage AS minimum_in_storage_22, 
  t0.limited_quantity AS limited_quantity_23, 
  t0.aliments_du_quebec_certification AS aliments_du_quebec_certification_24, 
  t0.delivery_type AS delivery_type_25, 
  t0.delivery_pickup AS delivery_pickup_26, 
  t0.draft AS draft_27, 
  t0.delivery_mail AS delivery_mail_28, 
  t0.advices AS advices_29, 
  t0.recipes AS recipes_30, 
  t0.solex_id AS solex_id_31, 
  t0.list_of_ingredients AS list_of_ingredients_32, 
  t0.qty_ready_to_ship AS qty_ready_to_ship_33, 
  t0.expiration_date AS expiration_date_34, 
  t0.is_consigned AS is_consigned_35, 
  t0.consigned_cost AS consigned_cost_36, 
  t0.is_fragile AS is_fragile_37, 
  t0.qty_per_unit AS qty_per_unit_38, 
  t0.validated_by_distributor AS validated_by_distributor_39, 
  t0.delivery_note AS delivery_note_40, 
  t0.is_just_in_time AS is_just_in_time_41, 
  t0.reminder_low_quantity_sent AS reminder_low_quantity_sent_42, 
  t0.has_multiple_products AS has_multiple_products_43, 
  t0.has_free_maturin_shipping AS has_free_maturin_shipping_44, 
  t0.action_when_expired AS action_when_expired_45, 
  t0.is_subscribable AS is_subscribable_46, 
  t0.is_box_of_products AS is_box_of_products_47, 
  t0.is_only_subscribable AS is_only_subscribable_48, 
  t0.just_in_time_delivery_date AS just_in_time_delivery_date_49, 
  t0.free_maturin_shipping_if_lower_then AS free_maturin_shipping_if_lower_then_50, 
  t0.is_only_subscribable_to_type AS is_only_subscribable_to_type_51, 
  t0.quantity_warehouse AS quantity_warehouse_52, 
  t0.quantity_warehouse_reserved AS quantity_warehouse_reserved_53, 
  t0.quantity_on_hold AS quantity_on_hold_54, 
  t0.parent_product_id AS parent_product_id_55, 
  t0.fee_warehouse_packing_per_unit AS fee_warehouse_packing_per_unit_56, 
  t0.fee_warehouse_handling_per_unit AS fee_warehouse_handling_per_unit_57, 
  t0.is_displayed_in_association_only AS is_displayed_in_association_only_58, 
  t0.is_hri AS is_hri_59, 
  t0.puro_exclusion AS puro_exclusion_60, 
  t0.contains_alcohol AS contains_alcohol_61, 
  t0.is_consumer AS is_consumer_62, 
  t0.product_colabor_price AS product_colabor_price_63, 
  t0.is_prix_laureat AS is_prix_laureat_64, 
  t0.cant_use_coupon AS cant_use_coupon_65, 
  t0.seasonality AS seasonality_66, 
  t0.seasonality_start AS seasonality_start_67, 
  t0.seasonality_end AS seasonality_end_68, 
  t0.quantity_max_prod AS quantity_max_prod_69, 
  t0.product_delete AS product_delete_70, 
  t0.order_frequency AS order_frequency_71, 
  t0.portion_for_meal AS portion_for_meal_72, 
  t0.categories_id AS categories_id_73, 
  t0.conservation_id AS conservation_id_74, 
  t0.main_image_id AS main_image_id_75, 
  t0.company_id AS company_id_76, 
  t0.region_id AS region_id_77, 
  t0.nutrition_fact_image_id AS nutrition_fact_image_id_78, 
  t79.id AS id_80, 
  t79.price_to_company AS price_to_company_81, 
  t79.quantity AS quantity_82, 
  t79.product_id AS product_id_83, 
  t0.sub_category_id AS sub_category_id_84, 
  t0.corporative_id AS corporative_id_85 
FROM 
  product t0 
  LEFT JOIN product_deal t79 ON t79.product_id = t0.id 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.orig_name AS orig_name_2, t0.orig_brand_name AS orig_brand_name_3, t0.qty_left AS qty_left_4, t0.unit_amount AS unit_amount_5, t0.unit AS unit_6, t0.available AS available_7, t0.orig_description AS orig_description_8, t0.origin AS origin_9, t0.best_before AS best_before_10, t0.creation_date AS creation_date_11, t0.nutrition_fact AS nutrition_fact_12, t0.new_product AS new_product_13, t0.taxable AS taxable_14, t0.maturin_upc AS maturin_upc_15, t0.code_upc AS code_upc_16, t0.code1 AS code1_17, t0.code2 AS code2_18, t0.code3 AS code3_19, t0.code_box AS code_box_20, t0.aliments_du_quebec AS aliments_du_quebec_21, t0.minimum_in_storage AS minimum_in_storage_22, t0.limited_quantity AS limited_quantity_23, t0.aliments_du_quebec_certification AS aliments_du_quebec_certification_24, t0.delivery_type AS delivery_type_25, t0.delivery_pickup AS delivery_pickup_26, t0.draft AS draft_27, t0.delivery_mail AS delivery_mail_28, t0.advices AS advices_29, t0.recipes AS recipes_30, t0.solex_id AS solex_id_31, t0.list_of_ingredients AS list_of_ingredients_32, t0.qty_ready_to_ship AS qty_ready_to_ship_33, t0.expiration_date AS expiration_date_34, t0.is_consigned AS is_consigned_35, t0.consigned_cost AS consigned_cost_36, t0.is_fragile AS is_fragile_37, t0.qty_per_unit AS qty_per_unit_38, t0.validated_by_distributor AS validated_by_distributor_39, t0.delivery_note AS delivery_note_40, t0.is_just_in_time AS is_just_in_time_41, t0.reminder_low_quantity_sent AS reminder_low_quantity_sent_42, t0.has_multiple_products AS has_multiple_products_43, t0.has_free_maturin_shipping AS has_free_maturin_shipping_44, t0.action_when_expired AS action_when_expired_45, t0.is_subscribable AS is_subscribable_46, t0.is_box_of_products AS is_box_of_products_47, t0.is_only_subscribable AS is_only_subscribable_48, t0.just_in_time_delivery_date AS just_in_time_delivery_date_49, t0.free_maturin_shipping_if_lower_then AS free_maturin_shipping_if_lower_then_50, t0.is_only_subscribable_to_type AS is_only_subscribable_to_type_51, t0.quantity_warehouse AS quantity_warehouse_52, t0.quantity_warehouse_reserved AS quantity_warehouse_reserved_53, t0.quantity_on_hold AS quantity_on_hold_54, t0.parent_product_id AS parent_product_id_55, t0.fee_warehouse_packing_per_unit AS fee_warehouse_packing_per_unit_56, t0.fee_warehouse_handling_per_unit AS fee_warehouse_handling_per_unit_57, t0.is_displayed_in_association_only AS is_displayed_in_association_only_58, t0.is_hri AS is_hri_59, t0.puro_exclusion AS puro_exclusion_60, t0.contains_alcohol AS contains_alcohol_61, t0.is_consumer AS is_consumer_62, t0.product_colabor_price AS product_colabor_price_63, t0.is_prix_laureat AS is_prix_laureat_64, t0.cant_use_coupon AS cant_use_coupon_65, t0.seasonality AS seasonality_66, t0.seasonality_start AS seasonality_start_67, t0.seasonality_end AS seasonality_end_68, t0.quantity_max_prod AS quantity_max_prod_69, t0.product_delete AS product_delete_70, t0.order_frequency AS order_frequency_71, t0.portion_for_meal AS portion_for_meal_72, t0.categories_id AS categories_id_73, t0.conservation_id AS conservation_id_74, t0.main_image_id AS main_image_id_75, t0.company_id AS company_id_76, t0.region_id AS region_id_77, t0.nutrition_fact_image_id AS nutrition_fact_image_id_78, t79.id AS id_80, t79.price_to_company AS price_to_company_81, t79.quantity AS quantity_82, t79.product_id AS product_id_83, t0.sub_category_id AS sub_category_id_84, t0.corporative_id AS corporative_id_85 FROM product t0 LEFT JOIN product_deal t79 ON t79.product_id = t0.id WHERE t0.id = 1663;

SELECT 
  t0.id AS id_1, 
  t0.price AS price_2, 
  t0.currency AS currency_3, 
  t0.quantity AS quantity_4, 
  t0.start_date AS start_date_5, 
  t0.end_date AS end_date_6, 
  t0.is_adiscount AS is_adiscount_7, 
  t0.storage_id AS storage_id_8, 
  t0.discount_product_id AS discount_product_id_9 
FROM 
  pricing t0 
WHERE 
  t0.discount_product_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.currency AS currency_3, t0.quantity AS quantity_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.is_adiscount AS is_adiscount_7, t0.storage_id AS storage_id_8, t0.discount_product_id AS discount_product_id_9 FROM pricing t0 WHERE t0.discount_product_id = 1663;

SELECT 
  t0.id AS id_1, 
  t0.price AS price_2, 
  t0.currency AS currency_3, 
  t0.quantity AS quantity_4, 
  t0.start_date AS start_date_5, 
  t0.end_date AS end_date_6, 
  t0.is_adiscount AS is_adiscount_7, 
  t0.storage_id AS storage_id_8, 
  t0.discount_product_id AS discount_product_id_9 
FROM 
  pricing t0 
  INNER JOIN pricing_product ON t0.id = pricing_product.pricing_id 
WHERE 
  pricing_product.product_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.currency AS currency_3, t0.quantity AS quantity_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.is_adiscount AS is_adiscount_7, t0.storage_id AS storage_id_8, t0.discount_product_id AS discount_product_id_9 FROM pricing t0 INNER JOIN pricing_product ON t0.id = pricing_product.pricing_id WHERE pricing_product.product_id = 1663;

SELECT 
  t0.id AS id_1, 
  t0.type AS type_2, 
  t0.quantity_product AS quantity_product_3, 
  t0.height AS height_4, 
  t0.length AS length_5, 
  t0.width AS width_6, 
  t0.weight AS weight_7, 
  t0.unit_weight AS unit_weight_8, 
  t0.unit_dimension AS unit_dimension_9, 
  t0.values_are_approximate AS values_are_approximate_10 
FROM 
  storage t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.quantity_product AS quantity_product_3, t0.height AS height_4, t0.length AS length_5, t0.width AS width_6, t0.weight AS weight_7, t0.unit_weight AS unit_weight_8, t0.unit_dimension AS unit_dimension_9, t0.values_are_approximate AS values_are_approximate_10 FROM storage t0 WHERE t0.id = 5221;

SELECT 
  t0.id AS id_1, 
  t0.orig_name AS orig_name_2, 
  t0.orig_brand_name AS orig_brand_name_3, 
  t0.qty_left AS qty_left_4, 
  t0.unit_amount AS unit_amount_5, 
  t0.unit AS unit_6, 
  t0.available AS available_7, 
  t0.orig_description AS orig_description_8, 
  t0.origin AS origin_9, 
  t0.best_before AS best_before_10, 
  t0.creation_date AS creation_date_11, 
  t0.nutrition_fact AS nutrition_fact_12, 
  t0.new_product AS new_product_13, 
  t0.taxable AS taxable_14, 
  t0.maturin_upc AS maturin_upc_15, 
  t0.code_upc AS code_upc_16, 
  t0.code1 AS code1_17, 
  t0.code2 AS code2_18, 
  t0.code3 AS code3_19, 
  t0.code_box AS code_box_20, 
  t0.aliments_du_quebec AS aliments_du_quebec_21, 
  t0.minimum_in_storage AS minimum_in_storage_22, 
  t0.limited_quantity AS limited_quantity_23, 
  t0.aliments_du_quebec_certification AS aliments_du_quebec_certification_24, 
  t0.delivery_type AS delivery_type_25, 
  t0.delivery_pickup AS delivery_pickup_26, 
  t0.draft AS draft_27, 
  t0.delivery_mail AS delivery_mail_28, 
  t0.advices AS advices_29, 
  t0.recipes AS recipes_30, 
  t0.solex_id AS solex_id_31, 
  t0.list_of_ingredients AS list_of_ingredients_32, 
  t0.qty_ready_to_ship AS qty_ready_to_ship_33, 
  t0.expiration_date AS expiration_date_34, 
  t0.is_consigned AS is_consigned_35, 
  t0.consigned_cost AS consigned_cost_36, 
  t0.is_fragile AS is_fragile_37, 
  t0.qty_per_unit AS qty_per_unit_38, 
  t0.validated_by_distributor AS validated_by_distributor_39, 
  t0.delivery_note AS delivery_note_40, 
  t0.is_just_in_time AS is_just_in_time_41, 
  t0.reminder_low_quantity_sent AS reminder_low_quantity_sent_42, 
  t0.has_multiple_products AS has_multiple_products_43, 
  t0.has_free_maturin_shipping AS has_free_maturin_shipping_44, 
  t0.action_when_expired AS action_when_expired_45, 
  t0.is_subscribable AS is_subscribable_46, 
  t0.is_box_of_products AS is_box_of_products_47, 
  t0.is_only_subscribable AS is_only_subscribable_48, 
  t0.just_in_time_delivery_date AS just_in_time_delivery_date_49, 
  t0.free_maturin_shipping_if_lower_then AS free_maturin_shipping_if_lower_then_50, 
  t0.is_only_subscribable_to_type AS is_only_subscribable_to_type_51, 
  t0.quantity_warehouse AS quantity_warehouse_52, 
  t0.quantity_warehouse_reserved AS quantity_warehouse_reserved_53, 
  t0.quantity_on_hold AS quantity_on_hold_54, 
  t0.parent_product_id AS parent_product_id_55, 
  t0.fee_warehouse_packing_per_unit AS fee_warehouse_packing_per_unit_56, 
  t0.fee_warehouse_handling_per_unit AS fee_warehouse_handling_per_unit_57, 
  t0.is_displayed_in_association_only AS is_displayed_in_association_only_58, 
  t0.is_hri AS is_hri_59, 
  t0.puro_exclusion AS puro_exclusion_60, 
  t0.contains_alcohol AS contains_alcohol_61, 
  t0.is_consumer AS is_consumer_62, 
  t0.product_colabor_price AS product_colabor_price_63, 
  t0.is_prix_laureat AS is_prix_laureat_64, 
  t0.cant_use_coupon AS cant_use_coupon_65, 
  t0.seasonality AS seasonality_66, 
  t0.seasonality_start AS seasonality_start_67, 
  t0.seasonality_end AS seasonality_end_68, 
  t0.quantity_max_prod AS quantity_max_prod_69, 
  t0.product_delete AS product_delete_70, 
  t0.order_frequency AS order_frequency_71, 
  t0.portion_for_meal AS portion_for_meal_72, 
  t0.categories_id AS categories_id_73, 
  t0.conservation_id AS conservation_id_74, 
  t0.main_image_id AS main_image_id_75, 
  t0.company_id AS company_id_76, 
  t0.region_id AS region_id_77, 
  t0.nutrition_fact_image_id AS nutrition_fact_image_id_78, 
  t79.id AS id_80, 
  t79.price_to_company AS price_to_company_81, 
  t79.quantity AS quantity_82, 
  t79.product_id AS product_id_83, 
  t0.sub_category_id AS sub_category_id_84, 
  t0.corporative_id AS corporative_id_85 
FROM 
  product t0 
  LEFT JOIN product_deal t79 ON t79.product_id = t0.id 
  INNER JOIN pricing_product ON t0.id = pricing_product.product_id 
WHERE 
  pricing_product.pricing_id = ?

SELECT t0.id AS id_1, t0.orig_name AS orig_name_2, t0.orig_brand_name AS orig_brand_name_3, t0.qty_left AS qty_left_4, t0.unit_amount AS unit_amount_5, t0.unit AS unit_6, t0.available AS available_7, t0.orig_description AS orig_description_8, t0.origin AS origin_9, t0.best_before AS best_before_10, t0.creation_date AS creation_date_11, t0.nutrition_fact AS nutrition_fact_12, t0.new_product AS new_product_13, t0.taxable AS taxable_14, t0.maturin_upc AS maturin_upc_15, t0.code_upc AS code_upc_16, t0.code1 AS code1_17, t0.code2 AS code2_18, t0.code3 AS code3_19, t0.code_box AS code_box_20, t0.aliments_du_quebec AS aliments_du_quebec_21, t0.minimum_in_storage AS minimum_in_storage_22, t0.limited_quantity AS limited_quantity_23, t0.aliments_du_quebec_certification AS aliments_du_quebec_certification_24, t0.delivery_type AS delivery_type_25, t0.delivery_pickup AS delivery_pickup_26, t0.draft AS draft_27, t0.delivery_mail AS delivery_mail_28, t0.advices AS advices_29, t0.recipes AS recipes_30, t0.solex_id AS solex_id_31, t0.list_of_ingredients AS list_of_ingredients_32, t0.qty_ready_to_ship AS qty_ready_to_ship_33, t0.expiration_date AS expiration_date_34, t0.is_consigned AS is_consigned_35, t0.consigned_cost AS consigned_cost_36, t0.is_fragile AS is_fragile_37, t0.qty_per_unit AS qty_per_unit_38, t0.validated_by_distributor AS validated_by_distributor_39, t0.delivery_note AS delivery_note_40, t0.is_just_in_time AS is_just_in_time_41, t0.reminder_low_quantity_sent AS reminder_low_quantity_sent_42, t0.has_multiple_products AS has_multiple_products_43, t0.has_free_maturin_shipping AS has_free_maturin_shipping_44, t0.action_when_expired AS action_when_expired_45, t0.is_subscribable AS is_subscribable_46, t0.is_box_of_products AS is_box_of_products_47, t0.is_only_subscribable AS is_only_subscribable_48, t0.just_in_time_delivery_date AS just_in_time_delivery_date_49, t0.free_maturin_shipping_if_lower_then AS free_maturin_shipping_if_lower_then_50, t0.is_only_subscribable_to_type AS is_only_subscribable_to_type_51, t0.quantity_warehouse AS quantity_warehouse_52, t0.quantity_warehouse_reserved AS quantity_warehouse_reserved_53, t0.quantity_on_hold AS quantity_on_hold_54, t0.parent_product_id AS parent_product_id_55, t0.fee_warehouse_packing_per_unit AS fee_warehouse_packing_per_unit_56, t0.fee_warehouse_handling_per_unit AS fee_warehouse_handling_per_unit_57, t0.is_displayed_in_association_only AS is_displayed_in_association_only_58, t0.is_hri AS is_hri_59, t0.puro_exclusion AS puro_exclusion_60, t0.contains_alcohol AS contains_alcohol_61, t0.is_consumer AS is_consumer_62, t0.product_colabor_price AS product_colabor_price_63, t0.is_prix_laureat AS is_prix_laureat_64, t0.cant_use_coupon AS cant_use_coupon_65, t0.seasonality AS seasonality_66, t0.seasonality_start AS seasonality_start_67, t0.seasonality_end AS seasonality_end_68, t0.quantity_max_prod AS quantity_max_prod_69, t0.product_delete AS product_delete_70, t0.order_frequency AS order_frequency_71, t0.portion_for_meal AS portion_for_meal_72, t0.categories_id AS categories_id_73, t0.conservation_id AS conservation_id_74, t0.main_image_id AS main_image_id_75, t0.company_id AS company_id_76, t0.region_id AS region_id_77, t0.nutrition_fact_image_id AS nutrition_fact_image_id_78, t79.id AS id_80, t79.price_to_company AS price_to_company_81, t79.quantity AS quantity_82, t79.product_id AS product_id_83, t0.sub_category_id AS sub_category_id_84, t0.corporative_id AS corporative_id_85 FROM product t0 LEFT JOIN product_deal t79 ON t79.product_id = t0.id INNER JOIN pricing_product ON t0.id = pricing_product.product_id WHERE pricing_product.pricing_id = 30771;