Symfony Profiler

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;

SELECT 
  DISTINCT product.id, 
  product.company_id, 
  product.orig_name, 
  product.creation_date, 
  IF (
    product.orig_name LIKE ?, 
    20, 
    IF (
      product.orig_brand_name LIKE ?, 10, 
      0
    )
  ) + IF (
    product.orig_brand_name LIKE ?, 10, 
    0
  ) + IF (company.name LIKE ?, 5, 0) + IF (tag.name LIKE ?, 5, 0) AS weight, 
  (
    (
      (
        SELECT 
          COUNT(cart_product.id) 
        FROM 
          cart_product 
        WHERE 
          cart_product.product_id = product.id
      ) + 1
    ) / 100
  ) as total_cart 
FROM 
  product 
  LEFT JOIN company ON company.id = product.company_id 
  LEFT JOIN tag_product ON tag_product.product_id = product.id 
  LEFT JOIN tag ON tag.id = tag_product.tag_id 
  LEFT JOIN pricing_product ON pricing_product.product_id = product.id 
  LEFT JOIN pricing ON pricing.id = pricing_product.pricing_id 
WHERE 
  (
    product.orig_name LIKE ? 
    OR product.orig_brand_name LIKE ? 
    OR product.orig_description LIKE ? 
    OR product.list_of_ingredients LIKE ? 
    OR company.name LIKE ? 
    OR tag.name LIKE ?
  ) 
  AND (
    product.draft != 1 
    AND product.available > 0 
    AND product.is_hri = 0 
    AND product.is_displayed_in_association_only = 0 
    AND product.main_image_id IS NOT NULL 
    AND company.show_publicly = 1
  ) 
  AND (
    (
      product.qty_ready_to_ship > 0 
      AND product.delivery_type = 0
    ) 
    OR (product.delivery_type != 0)
  ) 
ORDER BY 
  (`weight` + `total_cart`) DESC

SELECT DISTINCT product.id, product.company_id, product.orig_name, product.creation_date,

      IF (product.orig_name LIKE '%Bio%viva%', 20, IF (product.orig_brand_name LIKE '%Bio%viva%', 10, 0))
  		+ IF (product.orig_brand_name LIKE '%Bio%viva%', 10, 0)
  		+ IF (company.name LIKE '%Bio%viva%', 5, 0)
  		+ IF (tag.name LIKE '%Bio%viva%', 5, 0)
  		AS weight,

      ( ( (SELECT COUNT(cart_product.id) FROM cart_product WHERE cart_product.product_id = product.id) + 1 ) / 100 ) as total_cart

      FROM product

      LEFT JOIN company ON company.id = product.company_id
      LEFT JOIN tag_product ON tag_product.product_id = product.id
      LEFT JOIN tag ON tag.id = tag_product.tag_id
      LEFT JOIN pricing_product ON pricing_product.product_id = product.id
      LEFT JOIN pricing ON pricing.id = pricing_product.pricing_id

      WHERE (
        product.orig_name LIKE '%Bio%viva%'
        OR product.orig_brand_name LIKE '%Bio%viva%'
        OR product.orig_description LIKE '%Bio%viva%'
        OR product.list_of_ingredients LIKE '%Bio%viva%'
        OR company.name LIKE '%Bio%viva%'
        OR tag.name LIKE '%Bio%viva%'
      ) AND (
        product.draft != 1
        AND product.available > 0
        AND product.is_hri = 0
        AND product.is_displayed_in_association_only = 0
        AND product.main_image_id IS NOT NULL
        AND company.show_publicly = 1
      ) AND
      (
        (
          product.qty_ready_to_ship > 0
          AND product.delivery_type = 0
        ) OR (
          product.delivery_type != 0
        )
      )
      
        ORDER BY ( `weight` + `total_cart` ) 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 = '6514';

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 = 6514;

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 = '6517';

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 = 6517;

SELECT 
  DISTINCT product.id, 
  product.company_id, 
  product.orig_name, 
  product.creation_date, 
  IF (
    product.orig_name LIKE ?, 
    20, 
    IF (
      product.orig_brand_name LIKE ?, 10, 
      0
    )
  ) + IF (
    product.orig_brand_name LIKE ?, 10, 
    0
  ) + IF (company.name LIKE ?, 5, 0) + IF (tag.name LIKE ?, 5, 0) AS weight, 
  (
    (
      (
        SELECT 
          COUNT(cart_product.id) 
        FROM 
          cart_product 
        WHERE 
          cart_product.product_id = product.id
      ) + 1
    ) / 100
  ) as total_cart 
FROM 
  product 
  LEFT JOIN company ON company.id = product.company_id 
  LEFT JOIN tag_product ON tag_product.product_id = product.id 
  LEFT JOIN tag ON tag.id = tag_product.tag_id 
  LEFT JOIN pricing_product ON pricing_product.product_id = product.id 
  LEFT JOIN pricing ON pricing.id = pricing_product.pricing_id 
WHERE 
  (
    product.orig_name LIKE ? 
    OR product.orig_brand_name LIKE ? 
    OR product.orig_description LIKE ? 
    OR product.list_of_ingredients LIKE ? 
    OR company.name LIKE ? 
    OR tag.name LIKE ?
  ) 
  AND (
    product.draft != 1 
    AND product.available > 0 
    AND product.is_hri = 0 
    AND product.is_displayed_in_association_only = 0 
    AND product.main_image_id IS NOT NULL 
    AND company.show_publicly = 1
  ) 
  AND (
    (
      product.qty_ready_to_ship > 0 
      AND product.delivery_type = 0
    ) 
    OR (product.delivery_type != 0)
  ) 
ORDER BY 
  (`weight` + `total_cart`) DESC

SELECT DISTINCT product.id, product.company_id, product.orig_name, product.creation_date,

      IF (product.orig_name LIKE '%Bio%viva%', 20, IF (product.orig_brand_name LIKE '%Bio%viva%', 10, 0))
  		+ IF (product.orig_brand_name LIKE '%Bio%viva%', 10, 0)
  		+ IF (company.name LIKE '%Bio%viva%', 5, 0)
  		+ IF (tag.name LIKE '%Bio%viva%', 5, 0)
  		AS weight,

      ( ( (SELECT COUNT(cart_product.id) FROM cart_product WHERE cart_product.product_id = product.id) + 1 ) / 100 ) as total_cart

      FROM product

      LEFT JOIN company ON company.id = product.company_id
      LEFT JOIN tag_product ON tag_product.product_id = product.id
      LEFT JOIN tag ON tag.id = tag_product.tag_id
      LEFT JOIN pricing_product ON pricing_product.product_id = product.id
      LEFT JOIN pricing ON pricing.id = pricing_product.pricing_id

      WHERE (
        product.orig_name LIKE '%Bio%viva%'
        OR product.orig_brand_name LIKE '%Bio%viva%'
        OR product.orig_description LIKE '%Bio%viva%'
        OR product.list_of_ingredients LIKE '%Bio%viva%'
        OR company.name LIKE '%Bio%viva%'
        OR tag.name LIKE '%Bio%viva%'
      ) AND (
        product.draft != 1
        AND product.available > 0
        AND product.is_hri = 0
        AND product.is_displayed_in_association_only = 0
        AND product.main_image_id IS NOT NULL
        AND company.show_publicly = 1
      ) AND
      (
        (
          product.qty_ready_to_ship > 0
          AND product.delivery_type = 0
        ) OR (
          product.delivery_type != 0
        )
      )
      
        ORDER BY ( `weight` + `total_cart` ) 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 = '6514';

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 = '6517';