Symfony Profiler

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.placement AS placement_3, 
  t0.title AS title_4, 
  t0.description AS description_5, 
  t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, 
  t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, 
  t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, 
  t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, 
  t0.packing_fees_amount AS packing_fees_amount_10, 
  t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, 
  t0.meta_description AS meta_description_12, 
  t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, 
  t0.sub_category_id AS sub_category_id_14, 
  t0.image_id AS image_id_15, 
  t0.banner_id AS banner_id_16 
FROM 
  category t0 
WHERE 
  t0.name = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.name = 'ambassadeur' LIMIT 1;

SELECT 
  c0_.id AS id_0, 
  c0_.placement AS placement_1, 
  c0_.name AS name_2 
FROM 
  category c0_ 
WHERE 
  c0_.sub_category_id = ? 
  AND c0_.placement > 0 
ORDER BY 
  c0_.placement ASC

SELECT c0_.id AS id_0, c0_.placement AS placement_1, c0_.name AS name_2 FROM category c0_ WHERE c0_.sub_category_id = 343 AND c0_.placement > 0 ORDER BY c0_.placement ASC;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.placement AS placement_3, 
  t0.title AS title_4, 
  t0.description AS description_5, 
  t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, 
  t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, 
  t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, 
  t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, 
  t0.packing_fees_amount AS packing_fees_amount_10, 
  t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, 
  t0.meta_description AS meta_description_12, 
  t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, 
  t0.sub_category_id AS sub_category_id_14, 
  t0.image_id AS image_id_15, 
  t0.banner_id AS banner_id_16 
FROM 
  category t0 
WHERE 
  t0.sub_category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = 343;

SELECT 
  p0_.id AS id_0, 
  c1_.id AS id_1, 
  (
    SELECT 
      COUNT(*) 
    FROM 
      cart_product c2_ 
    WHERE 
      c2_.product_id = p0_.id
  ) AS sclr_2, 
  c3_.id AS id_3, 
  c3_.placement AS placement_4, 
  c3_.name AS name_5, 
  c4_.placement AS placement_6, 
  c4_.name AS name_7 
FROM 
  product p0_ 
  LEFT JOIN company c1_ ON p0_.company_id = c1_.id 
  LEFT JOIN category c3_ ON p0_.sub_category_id = c3_.id 
  LEFT JOIN category c4_ ON c3_.sub_category_id = c4_.id 
  LEFT JOIN pricing_product p6_ ON p0_.id = p6_.product_id 
  LEFT JOIN pricing p5_ ON p5_.id = p6_.pricing_id 
WHERE 
  (
    p0_.categories_id = ? 
    OR p0_.sub_category_id = ? 
    OR p0_.sub_category_id IN (?)
  ) 
  AND p0_.draft <> 1 
  AND p0_.main_image_id IS NOT NULL 
  AND p0_.available = 1 
  AND p0_.is_displayed_in_association_only = 0 
  AND c3_.placement > 0 
  AND c4_.placement > 0 
  AND p0_.is_hri = 0 
  AND p0_.is_consumer = 1 
  AND c1_.show_publicly = 1 
  AND p0_.qty_ready_to_ship > 0 
ORDER BY 
  p0_.creation_date DESC

SELECT p0_.id AS id_0, c1_.id AS id_1, (SELECT COUNT(*) FROM cart_product c2_ WHERE c2_.product_id = p0_.id) AS sclr_2, c3_.id AS id_3, c3_.placement AS placement_4, c3_.name AS name_5, c4_.placement AS placement_6, c4_.name AS name_7 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id LEFT JOIN category c3_ ON p0_.sub_category_id = c3_.id LEFT JOIN category c4_ ON c3_.sub_category_id = c4_.id LEFT JOIN pricing_product p6_ ON p0_.id = p6_.product_id LEFT JOIN pricing p5_ ON p5_.id = p6_.pricing_id WHERE (p0_.categories_id = 343 OR p0_.sub_category_id = 343 OR p0_.sub_category_id IN ()) AND p0_.draft <> 1 AND p0_.main_image_id IS NOT NULL AND p0_.available = 1 AND p0_.is_displayed_in_association_only = 0 AND c3_.placement > 0 AND c4_.placement > 0 AND p0_.is_hri = 0 AND p0_.is_consumer = 1 AND c1_.show_publicly = 1 AND p0_.qty_ready_to_ship > 0 ORDER BY p0_.creation_date DESC;

SELECT 
  p0_.id AS id_0, 
  p0_.orig_name AS orig_name_1, 
  p0_.orig_brand_name AS orig_brand_name_2, 
  p0_.qty_left AS qty_left_3, 
  p0_.unit_amount AS unit_amount_4, 
  p0_.unit AS unit_5, 
  p0_.available AS available_6, 
  p0_.orig_description AS orig_description_7, 
  p0_.origin AS origin_8, 
  p0_.best_before AS best_before_9, 
  p0_.creation_date AS creation_date_10, 
  p0_.nutrition_fact AS nutrition_fact_11, 
  p0_.new_product AS new_product_12, 
  p0_.taxable AS taxable_13, 
  p0_.maturin_upc AS maturin_upc_14, 
  p0_.code_upc AS code_upc_15, 
  p0_.code1 AS code1_16, 
  p0_.code2 AS code2_17, 
  p0_.code3 AS code3_18, 
  p0_.code_box AS code_box_19, 
  p0_.aliments_du_quebec AS aliments_du_quebec_20, 
  p0_.minimum_in_storage AS minimum_in_storage_21, 
  p0_.limited_quantity AS limited_quantity_22, 
  p0_.aliments_du_quebec_certification AS aliments_du_quebec_certification_23, 
  p0_.delivery_type AS delivery_type_24, 
  p0_.delivery_pickup AS delivery_pickup_25, 
  p0_.draft AS draft_26, 
  p0_.delivery_mail AS delivery_mail_27, 
  p0_.advices AS advices_28, 
  p0_.recipes AS recipes_29, 
  p0_.solex_id AS solex_id_30, 
  p0_.list_of_ingredients AS list_of_ingredients_31, 
  p0_.qty_ready_to_ship AS qty_ready_to_ship_32, 
  p0_.expiration_date AS expiration_date_33, 
  p0_.is_consigned AS is_consigned_34, 
  p0_.consigned_cost AS consigned_cost_35, 
  p0_.is_fragile AS is_fragile_36, 
  p0_.qty_per_unit AS qty_per_unit_37, 
  p0_.validated_by_distributor AS validated_by_distributor_38, 
  p0_.delivery_note AS delivery_note_39, 
  p0_.is_just_in_time AS is_just_in_time_40, 
  p0_.reminder_low_quantity_sent AS reminder_low_quantity_sent_41, 
  p0_.has_multiple_products AS has_multiple_products_42, 
  p0_.has_free_maturin_shipping AS has_free_maturin_shipping_43, 
  p0_.action_when_expired AS action_when_expired_44, 
  p0_.is_subscribable AS is_subscribable_45, 
  p0_.is_box_of_products AS is_box_of_products_46, 
  p0_.is_only_subscribable AS is_only_subscribable_47, 
  p0_.just_in_time_delivery_date AS just_in_time_delivery_date_48, 
  p0_.free_maturin_shipping_if_lower_then AS free_maturin_shipping_if_lower_then_49, 
  p0_.is_only_subscribable_to_type AS is_only_subscribable_to_type_50, 
  p0_.quantity_warehouse AS quantity_warehouse_51, 
  p0_.quantity_warehouse_reserved AS quantity_warehouse_reserved_52, 
  p0_.quantity_on_hold AS quantity_on_hold_53, 
  p0_.parent_product_id AS parent_product_id_54, 
  p0_.fee_warehouse_packing_per_unit AS fee_warehouse_packing_per_unit_55, 
  p0_.fee_warehouse_handling_per_unit AS fee_warehouse_handling_per_unit_56, 
  p0_.is_displayed_in_association_only AS is_displayed_in_association_only_57, 
  p0_.is_hri AS is_hri_58, 
  p0_.puro_exclusion AS puro_exclusion_59, 
  p0_.contains_alcohol AS contains_alcohol_60, 
  p0_.is_consumer AS is_consumer_61, 
  p0_.product_colabor_price AS product_colabor_price_62, 
  p0_.is_prix_laureat AS is_prix_laureat_63, 
  p0_.cant_use_coupon AS cant_use_coupon_64, 
  p0_.seasonality AS seasonality_65, 
  p0_.seasonality_start AS seasonality_start_66, 
  p0_.seasonality_end AS seasonality_end_67, 
  p0_.quantity_max_prod AS quantity_max_prod_68, 
  p0_.product_delete AS product_delete_69, 
  p0_.order_frequency AS order_frequency_70, 
  p0_.portion_for_meal AS portion_for_meal_71, 
  p0_.categories_id AS categories_id_72, 
  p0_.conservation_id AS conservation_id_73, 
  p0_.main_image_id AS main_image_id_74, 
  p0_.company_id AS company_id_75, 
  p0_.region_id AS region_id_76, 
  p0_.nutrition_fact_image_id AS nutrition_fact_image_id_77, 
  p0_.sub_category_id AS sub_category_id_78, 
  p0_.corporative_id AS corporative_id_79 
FROM 
  product p0_ 
  LEFT JOIN company c1_ ON p0_.company_id = c1_.id 
WHERE 
  p0_.id = ?

SELECT p0_.id AS id_0, p0_.orig_name AS orig_name_1, p0_.orig_brand_name AS orig_brand_name_2, p0_.qty_left AS qty_left_3, p0_.unit_amount AS unit_amount_4, p0_.unit AS unit_5, p0_.available AS available_6, p0_.orig_description AS orig_description_7, p0_.origin AS origin_8, p0_.best_before AS best_before_9, p0_.creation_date AS creation_date_10, p0_.nutrition_fact AS nutrition_fact_11, p0_.new_product AS new_product_12, p0_.taxable AS taxable_13, p0_.maturin_upc AS maturin_upc_14, p0_.code_upc AS code_upc_15, p0_.code1 AS code1_16, p0_.code2 AS code2_17, p0_.code3 AS code3_18, p0_.code_box AS code_box_19, p0_.aliments_du_quebec AS aliments_du_quebec_20, p0_.minimum_in_storage AS minimum_in_storage_21, p0_.limited_quantity AS limited_quantity_22, p0_.aliments_du_quebec_certification AS aliments_du_quebec_certification_23, p0_.delivery_type AS delivery_type_24, p0_.delivery_pickup AS delivery_pickup_25, p0_.draft AS draft_26, p0_.delivery_mail AS delivery_mail_27, p0_.advices AS advices_28, p0_.recipes AS recipes_29, p0_.solex_id AS solex_id_30, p0_.list_of_ingredients AS list_of_ingredients_31, p0_.qty_ready_to_ship AS qty_ready_to_ship_32, p0_.expiration_date AS expiration_date_33, p0_.is_consigned AS is_consigned_34, p0_.consigned_cost AS consigned_cost_35, p0_.is_fragile AS is_fragile_36, p0_.qty_per_unit AS qty_per_unit_37, p0_.validated_by_distributor AS validated_by_distributor_38, p0_.delivery_note AS delivery_note_39, p0_.is_just_in_time AS is_just_in_time_40, p0_.reminder_low_quantity_sent AS reminder_low_quantity_sent_41, p0_.has_multiple_products AS has_multiple_products_42, p0_.has_free_maturin_shipping AS has_free_maturin_shipping_43, p0_.action_when_expired AS action_when_expired_44, p0_.is_subscribable AS is_subscribable_45, p0_.is_box_of_products AS is_box_of_products_46, p0_.is_only_subscribable AS is_only_subscribable_47, p0_.just_in_time_delivery_date AS just_in_time_delivery_date_48, p0_.free_maturin_shipping_if_lower_then AS free_maturin_shipping_if_lower_then_49, p0_.is_only_subscribable_to_type AS is_only_subscribable_to_type_50, p0_.quantity_warehouse AS quantity_warehouse_51, p0_.quantity_warehouse_reserved AS quantity_warehouse_reserved_52, p0_.quantity_on_hold AS quantity_on_hold_53, p0_.parent_product_id AS parent_product_id_54, p0_.fee_warehouse_packing_per_unit AS fee_warehouse_packing_per_unit_55, p0_.fee_warehouse_handling_per_unit AS fee_warehouse_handling_per_unit_56, p0_.is_displayed_in_association_only AS is_displayed_in_association_only_57, p0_.is_hri AS is_hri_58, p0_.puro_exclusion AS puro_exclusion_59, p0_.contains_alcohol AS contains_alcohol_60, p0_.is_consumer AS is_consumer_61, p0_.product_colabor_price AS product_colabor_price_62, p0_.is_prix_laureat AS is_prix_laureat_63, p0_.cant_use_coupon AS cant_use_coupon_64, p0_.seasonality AS seasonality_65, p0_.seasonality_start AS seasonality_start_66, p0_.seasonality_end AS seasonality_end_67, p0_.quantity_max_prod AS quantity_max_prod_68, p0_.product_delete AS product_delete_69, p0_.order_frequency AS order_frequency_70, p0_.portion_for_meal AS portion_for_meal_71, p0_.categories_id AS categories_id_72, p0_.conservation_id AS conservation_id_73, p0_.main_image_id AS main_image_id_74, p0_.company_id AS company_id_75, p0_.region_id AS region_id_76, p0_.nutrition_fact_image_id AS nutrition_fact_image_id_77, p0_.sub_category_id AS sub_category_id_78, p0_.corporative_id AS corporative_id_79 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.id = 6735;

SELECT 
  t0.id AS id_1, 
  t0.price_to_company AS price_to_company_2, 
  t0.quantity AS quantity_3, 
  t0.product_id AS product_id_4 
FROM 
  product_deal t0 
WHERE 
  t0.product_id = ?

SELECT t0.id AS id_1, t0.price_to_company AS price_to_company_2, t0.quantity AS quantity_3, t0.product_id AS product_id_4 FROM product_deal t0 WHERE t0.product_id = 6735;

SELECT 
  p0_.id AS id_0, 
  p0_.orig_name AS orig_name_1, 
  p0_.orig_brand_name AS orig_brand_name_2, 
  p0_.qty_left AS qty_left_3, 
  p0_.unit_amount AS unit_amount_4, 
  p0_.unit AS unit_5, 
  p0_.available AS available_6, 
  p0_.orig_description AS orig_description_7, 
  p0_.origin AS origin_8, 
  p0_.best_before AS best_before_9, 
  p0_.creation_date AS creation_date_10, 
  p0_.nutrition_fact AS nutrition_fact_11, 
  p0_.new_product AS new_product_12, 
  p0_.taxable AS taxable_13, 
  p0_.maturin_upc AS maturin_upc_14, 
  p0_.code_upc AS code_upc_15, 
  p0_.code1 AS code1_16, 
  p0_.code2 AS code2_17, 
  p0_.code3 AS code3_18, 
  p0_.code_box AS code_box_19, 
  p0_.aliments_du_quebec AS aliments_du_quebec_20, 
  p0_.minimum_in_storage AS minimum_in_storage_21, 
  p0_.limited_quantity AS limited_quantity_22, 
  p0_.aliments_du_quebec_certification AS aliments_du_quebec_certification_23, 
  p0_.delivery_type AS delivery_type_24, 
  p0_.delivery_pickup AS delivery_pickup_25, 
  p0_.draft AS draft_26, 
  p0_.delivery_mail AS delivery_mail_27, 
  p0_.advices AS advices_28, 
  p0_.recipes AS recipes_29, 
  p0_.solex_id AS solex_id_30, 
  p0_.list_of_ingredients AS list_of_ingredients_31, 
  p0_.qty_ready_to_ship AS qty_ready_to_ship_32, 
  p0_.expiration_date AS expiration_date_33, 
  p0_.is_consigned AS is_consigned_34, 
  p0_.consigned_cost AS consigned_cost_35, 
  p0_.is_fragile AS is_fragile_36, 
  p0_.qty_per_unit AS qty_per_unit_37, 
  p0_.validated_by_distributor AS validated_by_distributor_38, 
  p0_.delivery_note AS delivery_note_39, 
  p0_.is_just_in_time AS is_just_in_time_40, 
  p0_.reminder_low_quantity_sent AS reminder_low_quantity_sent_41, 
  p0_.has_multiple_products AS has_multiple_products_42, 
  p0_.has_free_maturin_shipping AS has_free_maturin_shipping_43, 
  p0_.action_when_expired AS action_when_expired_44, 
  p0_.is_subscribable AS is_subscribable_45, 
  p0_.is_box_of_products AS is_box_of_products_46, 
  p0_.is_only_subscribable AS is_only_subscribable_47, 
  p0_.just_in_time_delivery_date AS just_in_time_delivery_date_48, 
  p0_.free_maturin_shipping_if_lower_then AS free_maturin_shipping_if_lower_then_49, 
  p0_.is_only_subscribable_to_type AS is_only_subscribable_to_type_50, 
  p0_.quantity_warehouse AS quantity_warehouse_51, 
  p0_.quantity_warehouse_reserved AS quantity_warehouse_reserved_52, 
  p0_.quantity_on_hold AS quantity_on_hold_53, 
  p0_.parent_product_id AS parent_product_id_54, 
  p0_.fee_warehouse_packing_per_unit AS fee_warehouse_packing_per_unit_55, 
  p0_.fee_warehouse_handling_per_unit AS fee_warehouse_handling_per_unit_56, 
  p0_.is_displayed_in_association_only AS is_displayed_in_association_only_57, 
  p0_.is_hri AS is_hri_58, 
  p0_.puro_exclusion AS puro_exclusion_59, 
  p0_.contains_alcohol AS contains_alcohol_60, 
  p0_.is_consumer AS is_consumer_61, 
  p0_.product_colabor_price AS product_colabor_price_62, 
  p0_.is_prix_laureat AS is_prix_laureat_63, 
  p0_.cant_use_coupon AS cant_use_coupon_64, 
  p0_.seasonality AS seasonality_65, 
  p0_.seasonality_start AS seasonality_start_66, 
  p0_.seasonality_end AS seasonality_end_67, 
  p0_.quantity_max_prod AS quantity_max_prod_68, 
  p0_.product_delete AS product_delete_69, 
  p0_.order_frequency AS order_frequency_70, 
  p0_.portion_for_meal AS portion_for_meal_71, 
  p0_.categories_id AS categories_id_72, 
  p0_.conservation_id AS conservation_id_73, 
  p0_.main_image_id AS main_image_id_74, 
  p0_.company_id AS company_id_75, 
  p0_.region_id AS region_id_76, 
  p0_.nutrition_fact_image_id AS nutrition_fact_image_id_77, 
  p0_.sub_category_id AS sub_category_id_78, 
  p0_.corporative_id AS corporative_id_79 
FROM 
  product p0_ 
  LEFT JOIN company c1_ ON p0_.company_id = c1_.id 
WHERE 
  p0_.id = ?

SELECT p0_.id AS id_0, p0_.orig_name AS orig_name_1, p0_.orig_brand_name AS orig_brand_name_2, p0_.qty_left AS qty_left_3, p0_.unit_amount AS unit_amount_4, p0_.unit AS unit_5, p0_.available AS available_6, p0_.orig_description AS orig_description_7, p0_.origin AS origin_8, p0_.best_before AS best_before_9, p0_.creation_date AS creation_date_10, p0_.nutrition_fact AS nutrition_fact_11, p0_.new_product AS new_product_12, p0_.taxable AS taxable_13, p0_.maturin_upc AS maturin_upc_14, p0_.code_upc AS code_upc_15, p0_.code1 AS code1_16, p0_.code2 AS code2_17, p0_.code3 AS code3_18, p0_.code_box AS code_box_19, p0_.aliments_du_quebec AS aliments_du_quebec_20, p0_.minimum_in_storage AS minimum_in_storage_21, p0_.limited_quantity AS limited_quantity_22, p0_.aliments_du_quebec_certification AS aliments_du_quebec_certification_23, p0_.delivery_type AS delivery_type_24, p0_.delivery_pickup AS delivery_pickup_25, p0_.draft AS draft_26, p0_.delivery_mail AS delivery_mail_27, p0_.advices AS advices_28, p0_.recipes AS recipes_29, p0_.solex_id AS solex_id_30, p0_.list_of_ingredients AS list_of_ingredients_31, p0_.qty_ready_to_ship AS qty_ready_to_ship_32, p0_.expiration_date AS expiration_date_33, p0_.is_consigned AS is_consigned_34, p0_.consigned_cost AS consigned_cost_35, p0_.is_fragile AS is_fragile_36, p0_.qty_per_unit AS qty_per_unit_37, p0_.validated_by_distributor AS validated_by_distributor_38, p0_.delivery_note AS delivery_note_39, p0_.is_just_in_time AS is_just_in_time_40, p0_.reminder_low_quantity_sent AS reminder_low_quantity_sent_41, p0_.has_multiple_products AS has_multiple_products_42, p0_.has_free_maturin_shipping AS has_free_maturin_shipping_43, p0_.action_when_expired AS action_when_expired_44, p0_.is_subscribable AS is_subscribable_45, p0_.is_box_of_products AS is_box_of_products_46, p0_.is_only_subscribable AS is_only_subscribable_47, p0_.just_in_time_delivery_date AS just_in_time_delivery_date_48, p0_.free_maturin_shipping_if_lower_then AS free_maturin_shipping_if_lower_then_49, p0_.is_only_subscribable_to_type AS is_only_subscribable_to_type_50, p0_.quantity_warehouse AS quantity_warehouse_51, p0_.quantity_warehouse_reserved AS quantity_warehouse_reserved_52, p0_.quantity_on_hold AS quantity_on_hold_53, p0_.parent_product_id AS parent_product_id_54, p0_.fee_warehouse_packing_per_unit AS fee_warehouse_packing_per_unit_55, p0_.fee_warehouse_handling_per_unit AS fee_warehouse_handling_per_unit_56, p0_.is_displayed_in_association_only AS is_displayed_in_association_only_57, p0_.is_hri AS is_hri_58, p0_.puro_exclusion AS puro_exclusion_59, p0_.contains_alcohol AS contains_alcohol_60, p0_.is_consumer AS is_consumer_61, p0_.product_colabor_price AS product_colabor_price_62, p0_.is_prix_laureat AS is_prix_laureat_63, p0_.cant_use_coupon AS cant_use_coupon_64, p0_.seasonality AS seasonality_65, p0_.seasonality_start AS seasonality_start_66, p0_.seasonality_end AS seasonality_end_67, p0_.quantity_max_prod AS quantity_max_prod_68, p0_.product_delete AS product_delete_69, p0_.order_frequency AS order_frequency_70, p0_.portion_for_meal AS portion_for_meal_71, p0_.categories_id AS categories_id_72, p0_.conservation_id AS conservation_id_73, p0_.main_image_id AS main_image_id_74, p0_.company_id AS company_id_75, p0_.region_id AS region_id_76, p0_.nutrition_fact_image_id AS nutrition_fact_image_id_77, p0_.sub_category_id AS sub_category_id_78, p0_.corporative_id AS corporative_id_79 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.id = 6736;

SELECT 
  t0.id AS id_1, 
  t0.price_to_company AS price_to_company_2, 
  t0.quantity AS quantity_3, 
  t0.product_id AS product_id_4 
FROM 
  product_deal t0 
WHERE 
  t0.product_id = ?

SELECT t0.id AS id_1, t0.price_to_company AS price_to_company_2, t0.quantity AS quantity_3, t0.product_id AS product_id_4 FROM product_deal t0 WHERE t0.product_id = 6736;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.province AS province_3, 
  t0.country AS country_4 
FROM 
  region t0 
WHERE 
  t0.province = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.province AS province_3, t0.country AS country_4 FROM region t0 WHERE t0.province = 'Qc';

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.display_order AS display_order_3, 
  t0.maturin_fees_pc AS maturin_fees_pc_4, 
  t0.packing_fees_amount AS packing_fees_amount_5, 
  t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_6 
FROM 
  conservation t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.display_order AS display_order_3, t0.maturin_fees_pc AS maturin_fees_pc_4, t0.packing_fees_amount AS packing_fees_amount_5, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_6 FROM conservation t0;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO cart (
  date_created, stripe_token, stripe_response, 
  is_paid, solex_order_id, date_payment, 
  shipping_estimation_raw, shipping_maturin_cost, 
  shipping_maturin_carrier_name, 
  shipping_maturin_service_name, 
  shipping_maturin_estimated_date, 
  picking_and_packing_fee, payment_fee, 
  maturin_fee, taxes_products, taxes_maturin, 
  taxes_shipping_maturin, taxes_shipping_company, 
  taxes_packing, shipping_maturin_service_id, 
  solex_order_raw, maturin_tracking_info, 
  order_no, is_on_hold, just_in_time_email_sent, 
  reminder_sent, raw_distributor_billing, 
  taxes_products_calculations, taxes_shipping_maturin_calculations, 
  taxes_shipping_company_calculations, 
  taxes_packing_calculations, amount_saved_by_coupon, 
  shipping_signature_required, signature_mandatory, 
  extra_priority_points, warehouse_group_id, 
  is_refunded, refund_stripe_response, 
  note_from_buyer, is_bulk_order, 
  track_link, track_pod_status_id, 
  delivery_choice_date, pre_order, 
  pre_order_now, shipping_address_id, 
  user_id, used_coupon_id, logistic_invoice_id, 
  send_with_subscription_id, from_subscription_id
) 
VALUES 
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
    ?, ?, ?, ?, ?
  )

INSERT INTO cart (date_created, stripe_token, stripe_response, is_paid, solex_order_id, date_payment, shipping_estimation_raw, shipping_maturin_cost, shipping_maturin_carrier_name, shipping_maturin_service_name, shipping_maturin_estimated_date, picking_and_packing_fee, payment_fee, maturin_fee, taxes_products, taxes_maturin, taxes_shipping_maturin, taxes_shipping_company, taxes_packing, shipping_maturin_service_id, solex_order_raw, maturin_tracking_info, order_no, is_on_hold, just_in_time_email_sent, reminder_sent, raw_distributor_billing, taxes_products_calculations, taxes_shipping_maturin_calculations, taxes_shipping_company_calculations, taxes_packing_calculations, amount_saved_by_coupon, shipping_signature_required, signature_mandatory, extra_priority_points, warehouse_group_id, is_refunded, refund_stripe_response, note_from_buyer, is_bulk_order, track_link, track_pod_status_id, delivery_choice_date, pre_order, pre_order_now, shipping_address_id, user_id, used_coupon_id, logistic_invoice_id, send_with_subscription_id, from_subscription_id) VALUES ('2025-07-26 09:29:57', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 'a:0:{}', NULL, 0, 0, 0, 'N;', 'a:0:{}', 'a:0:{}', 'a:0:{}', 'a:0:{}', 0, 0, 0, 0, NULL, 0, 'N;', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

"COMMIT"

"COMMIT";

SELECT 
  c0_.id AS id_0, 
  c0_.name AS name_1, 
  c0_.placement AS placement_2, 
  c0_.title AS title_3, 
  c0_.description AS description_4, 
  c0_.tier1maturin_fees_pc AS tier1maturin_fees_pc_5, 
  c0_.tier2maturin_fees_pc AS tier2maturin_fees_pc_6, 
  c0_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_7, 
  c0_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_8, 
  c0_.packing_fees_amount AS packing_fees_amount_9, 
  c0_.packing_supplies_fees_amount AS packing_supplies_fees_amount_10, 
  c0_.meta_description AS meta_description_11, 
  c0_.is_displayed_for_buyer AS is_displayed_for_buyer_12, 
  c1_.id AS id_13, 
  c1_.name AS name_14, 
  c1_.placement AS placement_15, 
  c1_.title AS title_16, 
  c1_.description AS description_17, 
  c1_.tier1maturin_fees_pc AS tier1maturin_fees_pc_18, 
  c1_.tier2maturin_fees_pc AS tier2maturin_fees_pc_19, 
  c1_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_20, 
  c1_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_21, 
  c1_.packing_fees_amount AS packing_fees_amount_22, 
  c1_.packing_supplies_fees_amount AS packing_supplies_fees_amount_23, 
  c1_.meta_description AS meta_description_24, 
  c1_.is_displayed_for_buyer AS is_displayed_for_buyer_25, 
  c2_.id AS id_26, 
  c2_.name AS name_27, 
  c2_.placement AS placement_28, 
  c2_.title AS title_29, 
  c2_.description AS description_30, 
  c2_.tier1maturin_fees_pc AS tier1maturin_fees_pc_31, 
  c2_.tier2maturin_fees_pc AS tier2maturin_fees_pc_32, 
  c2_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_33, 
  c2_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_34, 
  c2_.packing_fees_amount AS packing_fees_amount_35, 
  c2_.packing_supplies_fees_amount AS packing_supplies_fees_amount_36, 
  c2_.meta_description AS meta_description_37, 
  c2_.is_displayed_for_buyer AS is_displayed_for_buyer_38, 
  c3_.id AS id_39, 
  c3_.name AS name_40, 
  c3_.placement AS placement_41, 
  c3_.title AS title_42, 
  c3_.description AS description_43, 
  c3_.tier1maturin_fees_pc AS tier1maturin_fees_pc_44, 
  c3_.tier2maturin_fees_pc AS tier2maturin_fees_pc_45, 
  c3_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_46, 
  c3_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_47, 
  c3_.packing_fees_amount AS packing_fees_amount_48, 
  c3_.packing_supplies_fees_amount AS packing_supplies_fees_amount_49, 
  c3_.meta_description AS meta_description_50, 
  c3_.is_displayed_for_buyer AS is_displayed_for_buyer_51, 
  c4_.id AS id_52, 
  c4_.name AS name_53, 
  c4_.placement AS placement_54, 
  c4_.title AS title_55, 
  c4_.description AS description_56, 
  c4_.tier1maturin_fees_pc AS tier1maturin_fees_pc_57, 
  c4_.tier2maturin_fees_pc AS tier2maturin_fees_pc_58, 
  c4_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_59, 
  c4_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_60, 
  c4_.packing_fees_amount AS packing_fees_amount_61, 
  c4_.packing_supplies_fees_amount AS packing_supplies_fees_amount_62, 
  c4_.meta_description AS meta_description_63, 
  c4_.is_displayed_for_buyer AS is_displayed_for_buyer_64, 
  c5_.id AS id_65, 
  c5_.name AS name_66, 
  c5_.placement AS placement_67, 
  c5_.title AS title_68, 
  c5_.description AS description_69, 
  c5_.tier1maturin_fees_pc AS tier1maturin_fees_pc_70, 
  c5_.tier2maturin_fees_pc AS tier2maturin_fees_pc_71, 
  c5_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_72, 
  c5_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_73, 
  c5_.packing_fees_amount AS packing_fees_amount_74, 
  c5_.packing_supplies_fees_amount AS packing_supplies_fees_amount_75, 
  c5_.meta_description AS meta_description_76, 
  c5_.is_displayed_for_buyer AS is_displayed_for_buyer_77, 
  c6_.id AS id_78, 
  c6_.name AS name_79, 
  c6_.placement AS placement_80, 
  c6_.title AS title_81, 
  c6_.description AS description_82, 
  c6_.tier1maturin_fees_pc AS tier1maturin_fees_pc_83, 
  c6_.tier2maturin_fees_pc AS tier2maturin_fees_pc_84, 
  c6_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_85, 
  c6_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_86, 
  c6_.packing_fees_amount AS packing_fees_amount_87, 
  c6_.packing_supplies_fees_amount AS packing_supplies_fees_amount_88, 
  c6_.meta_description AS meta_description_89, 
  c6_.is_displayed_for_buyer AS is_displayed_for_buyer_90, 
  c7_.id AS id_91, 
  c7_.name AS name_92, 
  c7_.placement AS placement_93, 
  c7_.title AS title_94, 
  c7_.description AS description_95, 
  c7_.tier1maturin_fees_pc AS tier1maturin_fees_pc_96, 
  c7_.tier2maturin_fees_pc AS tier2maturin_fees_pc_97, 
  c7_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_98, 
  c7_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_99, 
  c7_.packing_fees_amount AS packing_fees_amount_100, 
  c7_.packing_supplies_fees_amount AS packing_supplies_fees_amount_101, 
  c7_.meta_description AS meta_description_102, 
  c7_.is_displayed_for_buyer AS is_displayed_for_buyer_103, 
  c8_.id AS id_104, 
  c8_.name AS name_105, 
  c8_.placement AS placement_106, 
  c8_.title AS title_107, 
  c8_.description AS description_108, 
  c8_.tier1maturin_fees_pc AS tier1maturin_fees_pc_109, 
  c8_.tier2maturin_fees_pc AS tier2maturin_fees_pc_110, 
  c8_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_111, 
  c8_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_112, 
  c8_.packing_fees_amount AS packing_fees_amount_113, 
  c8_.packing_supplies_fees_amount AS packing_supplies_fees_amount_114, 
  c8_.meta_description AS meta_description_115, 
  c8_.is_displayed_for_buyer AS is_displayed_for_buyer_116, 
  c9_.id AS id_117, 
  c9_.name AS name_118, 
  c9_.placement AS placement_119, 
  c9_.title AS title_120, 
  c9_.description AS description_121, 
  c9_.tier1maturin_fees_pc AS tier1maturin_fees_pc_122, 
  c9_.tier2maturin_fees_pc AS tier2maturin_fees_pc_123, 
  c9_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_124, 
  c9_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_125, 
  c9_.packing_fees_amount AS packing_fees_amount_126, 
  c9_.packing_supplies_fees_amount AS packing_supplies_fees_amount_127, 
  c9_.meta_description AS meta_description_128, 
  c9_.is_displayed_for_buyer AS is_displayed_for_buyer_129, 
  c10_.id AS id_130, 
  c10_.name AS name_131, 
  c10_.placement AS placement_132, 
  c10_.title AS title_133, 
  c10_.description AS description_134, 
  c10_.tier1maturin_fees_pc AS tier1maturin_fees_pc_135, 
  c10_.tier2maturin_fees_pc AS tier2maturin_fees_pc_136, 
  c10_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_137, 
  c10_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_138, 
  c10_.packing_fees_amount AS packing_fees_amount_139, 
  c10_.packing_supplies_fees_amount AS packing_supplies_fees_amount_140, 
  c10_.meta_description AS meta_description_141, 
  c10_.is_displayed_for_buyer AS is_displayed_for_buyer_142, 
  c11_.id AS id_143, 
  c11_.name AS name_144, 
  c11_.placement AS placement_145, 
  c11_.title AS title_146, 
  c11_.description AS description_147, 
  c11_.tier1maturin_fees_pc AS tier1maturin_fees_pc_148, 
  c11_.tier2maturin_fees_pc AS tier2maturin_fees_pc_149, 
  c11_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_150, 
  c11_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_151, 
  c11_.packing_fees_amount AS packing_fees_amount_152, 
  c11_.packing_supplies_fees_amount AS packing_supplies_fees_amount_153, 
  c11_.meta_description AS meta_description_154, 
  c11_.is_displayed_for_buyer AS is_displayed_for_buyer_155, 
  c12_.id AS id_156, 
  c12_.name AS name_157, 
  c12_.placement AS placement_158, 
  c12_.title AS title_159, 
  c12_.description AS description_160, 
  c12_.tier1maturin_fees_pc AS tier1maturin_fees_pc_161, 
  c12_.tier2maturin_fees_pc AS tier2maturin_fees_pc_162, 
  c12_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_163, 
  c12_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_164, 
  c12_.packing_fees_amount AS packing_fees_amount_165, 
  c12_.packing_supplies_fees_amount AS packing_supplies_fees_amount_166, 
  c12_.meta_description AS meta_description_167, 
  c12_.is_displayed_for_buyer AS is_displayed_for_buyer_168, 
  c13_.id AS id_169, 
  c13_.name AS name_170, 
  c13_.placement AS placement_171, 
  c13_.title AS title_172, 
  c13_.description AS description_173, 
  c13_.tier1maturin_fees_pc AS tier1maturin_fees_pc_174, 
  c13_.tier2maturin_fees_pc AS tier2maturin_fees_pc_175, 
  c13_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_176, 
  c13_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_177, 
  c13_.packing_fees_amount AS packing_fees_amount_178, 
  c13_.packing_supplies_fees_amount AS packing_supplies_fees_amount_179, 
  c13_.meta_description AS meta_description_180, 
  c13_.is_displayed_for_buyer AS is_displayed_for_buyer_181, 
  c14_.id AS id_182, 
  c14_.name AS name_183, 
  c14_.placement AS placement_184, 
  c14_.title AS title_185, 
  c14_.description AS description_186, 
  c14_.tier1maturin_fees_pc AS tier1maturin_fees_pc_187, 
  c14_.tier2maturin_fees_pc AS tier2maturin_fees_pc_188, 
  c14_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_189, 
  c14_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_190, 
  c14_.packing_fees_amount AS packing_fees_amount_191, 
  c14_.packing_supplies_fees_amount AS packing_supplies_fees_amount_192, 
  c14_.meta_description AS meta_description_193, 
  c14_.is_displayed_for_buyer AS is_displayed_for_buyer_194, 
  c15_.id AS id_195, 
  c15_.name AS name_196, 
  c15_.placement AS placement_197, 
  c15_.title AS title_198, 
  c15_.description AS description_199, 
  c15_.tier1maturin_fees_pc AS tier1maturin_fees_pc_200, 
  c15_.tier2maturin_fees_pc AS tier2maturin_fees_pc_201, 
  c15_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_202, 
  c15_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_203, 
  c15_.packing_fees_amount AS packing_fees_amount_204, 
  c15_.packing_supplies_fees_amount AS packing_supplies_fees_amount_205, 
  c15_.meta_description AS meta_description_206, 
  c15_.is_displayed_for_buyer AS is_displayed_for_buyer_207, 
  c16_.id AS id_208, 
  c16_.name AS name_209, 
  c16_.placement AS placement_210, 
  c16_.title AS title_211, 
  c16_.description AS description_212, 
  c16_.tier1maturin_fees_pc AS tier1maturin_fees_pc_213, 
  c16_.tier2maturin_fees_pc AS tier2maturin_fees_pc_214, 
  c16_.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_215, 
  c16_.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_216, 
  c16_.packing_fees_amount AS packing_fees_amount_217, 
  c16_.packing_supplies_fees_amount AS packing_supplies_fees_amount_218, 
  c16_.meta_description AS meta_description_219, 
  c16_.is_displayed_for_buyer AS is_displayed_for_buyer_220, 
  c0_.sub_category_id AS sub_category_id_221, 
  c0_.image_id AS image_id_222, 
  c0_.banner_id AS banner_id_223, 
  c1_.sub_category_id AS sub_category_id_224, 
  c1_.image_id AS image_id_225, 
  c1_.banner_id AS banner_id_226, 
  c2_.sub_category_id AS sub_category_id_227, 
  c2_.image_id AS image_id_228, 
  c2_.banner_id AS banner_id_229, 
  c3_.sub_category_id AS sub_category_id_230, 
  c3_.image_id AS image_id_231, 
  c3_.banner_id AS banner_id_232, 
  c4_.sub_category_id AS sub_category_id_233, 
  c4_.image_id AS image_id_234, 
  c4_.banner_id AS banner_id_235, 
  c5_.sub_category_id AS sub_category_id_236, 
  c5_.image_id AS image_id_237, 
  c5_.banner_id AS banner_id_238, 
  c6_.sub_category_id AS sub_category_id_239, 
  c6_.image_id AS image_id_240, 
  c6_.banner_id AS banner_id_241, 
  c7_.sub_category_id AS sub_category_id_242, 
  c7_.image_id AS image_id_243, 
  c7_.banner_id AS banner_id_244, 
  c8_.sub_category_id AS sub_category_id_245, 
  c8_.image_id AS image_id_246, 
  c8_.banner_id AS banner_id_247, 
  c9_.sub_category_id AS sub_category_id_248, 
  c9_.image_id AS image_id_249, 
  c9_.banner_id AS banner_id_250, 
  c10_.sub_category_id AS sub_category_id_251, 
  c10_.image_id AS image_id_252, 
  c10_.banner_id AS banner_id_253, 
  c11_.sub_category_id AS sub_category_id_254, 
  c11_.image_id AS image_id_255, 
  c11_.banner_id AS banner_id_256, 
  c12_.sub_category_id AS sub_category_id_257, 
  c12_.image_id AS image_id_258, 
  c12_.banner_id AS banner_id_259, 
  c13_.sub_category_id AS sub_category_id_260, 
  c13_.image_id AS image_id_261, 
  c13_.banner_id AS banner_id_262, 
  c14_.sub_category_id AS sub_category_id_263, 
  c14_.image_id AS image_id_264, 
  c14_.banner_id AS banner_id_265, 
  c15_.sub_category_id AS sub_category_id_266, 
  c15_.image_id AS image_id_267, 
  c15_.banner_id AS banner_id_268, 
  c16_.sub_category_id AS sub_category_id_269, 
  c16_.image_id AS image_id_270, 
  c16_.banner_id AS banner_id_271 
FROM 
  category c0_ 
  LEFT JOIN category c1_ ON c0_.sub_category_id = c1_.id 
  LEFT JOIN category c2_ ON c1_.sub_category_id = c2_.id 
  LEFT JOIN category c3_ ON c2_.sub_category_id = c3_.id 
  LEFT JOIN category c4_ ON c3_.sub_category_id = c4_.id 
  LEFT JOIN category c5_ ON c1_.id = c5_.sub_category_id 
  LEFT JOIN category c6_ ON c5_.id = c6_.sub_category_id 
  LEFT JOIN category c7_ ON c6_.id = c7_.sub_category_id 
  LEFT JOIN category c8_ ON c7_.id = c8_.sub_category_id 
  LEFT JOIN category c9_ ON c8_.id = c9_.sub_category_id 
  LEFT JOIN category c10_ ON c0_.id = c10_.sub_category_id 
  LEFT JOIN category c11_ ON c10_.id = c11_.sub_category_id 
  LEFT JOIN category c12_ ON c11_.id = c12_.sub_category_id 
  LEFT JOIN category c13_ ON c12_.id = c13_.sub_category_id 
  LEFT JOIN category c14_ ON c13_.id = c14_.sub_category_id 
  LEFT JOIN category c15_ ON c14_.id = c15_.sub_category_id 
  LEFT JOIN category c16_ ON c10_.sub_category_id = c16_.id 
WHERE 
  c0_.sub_category_id IS NULL 
ORDER BY 
  c0_.placement ASC