Symfony Profiler

SELECT 
  count(p0_.id) AS sclr_0 
FROM 
  product p0_ 
WHERE 
  (
    p0_.categories_id IN (?) 
    OR p0_.sub_category_id IN (?)
  ) 
  AND p0_.draft <> 1 
  AND p0_.available = 1 
  AND p0_.main_image_id IS NOT NULL

SELECT count(p0_.id) AS sclr_0 FROM product p0_ WHERE (p0_.categories_id IN (355) OR p0_.sub_category_id IN (355, 0)) AND p0_.draft <> 1 AND p0_.available = 1 AND p0_.main_image_id IS NOT NULL;

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

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, 
  c1_.id AS id_72, 
  c1_.name AS name_73, 
  c1_.website AS website_74, 
  c1_.description AS description_75, 
  c1_.speciality AS speciality_76, 
  c1_.average_delivery_time AS average_delivery_time_77, 
  c1_.taxe_tps AS taxe_tps_78, 
  c1_.taxe_tvx AS taxe_tvx_79, 
  c1_.company_number AS company_number_80, 
  c1_.number_of_sales AS number_of_sales_81, 
  c1_.total_sales_in_dollars AS total_sales_in_dollars_82, 
  c1_.date_created AS date_created_83, 
  c1_.custom_sale_conditions AS custom_sale_conditions_84, 
  c1_.conditions_shipping AS conditions_shipping_85, 
  c1_.conditions_return AS conditions_return_86, 
  c1_.conditions_cancel AS conditions_cancel_87, 
  c1_.terms_acceptance_date AS terms_acceptance_date_88, 
  c1_.terms_acceptance_ip AS terms_acceptance_ip_89, 
  c1_.solex_id AS solex_id_90, 
  c1_.store_made_by_maturin AS store_made_by_maturin_91, 
  c1_.terms_acceptance_finger_print AS terms_acceptance_finger_print_92, 
  c1_.inventory_last_update AS inventory_last_update_93, 
  c1_.show_publicly AS show_publicly_94, 
  c1_.custom_url AS custom_url_95, 
  c1_.is_allowed_to_schedule_cold_product AS is_allowed_to_schedule_cold_product_96, 
  c1_.reminder_stripe_verification_sent AS reminder_stripe_verification_sent_97, 
  c1_.export_colabor AS export_colabor_98, 
  s2_.id AS id_99, 
  s2_.type AS type_100, 
  s2_.quantity_product AS quantity_product_101, 
  s2_.height AS height_102, 
  s2_.length AS length_103, 
  s2_.width AS width_104, 
  s2_.weight AS weight_105, 
  s2_.unit_weight AS unit_weight_106, 
  s2_.unit_dimension AS unit_dimension_107, 
  s2_.values_are_approximate AS values_are_approximate_108, 
  p0_.categories_id AS categories_id_109, 
  p0_.conservation_id AS conservation_id_110, 
  p0_.main_image_id AS main_image_id_111, 
  p0_.company_id AS company_id_112, 
  p0_.region_id AS region_id_113, 
  p0_.nutrition_fact_image_id AS nutrition_fact_image_id_114, 
  p0_.sub_category_id AS sub_category_id_115, 
  p0_.corporative_id AS corporative_id_116, 
  c1_.image_id AS image_id_117, 
  c1_.banner_id AS banner_id_118, 
  c1_.main_location_id AS main_location_id_119, 
  c1_.recruiter_id AS recruiter_id_120, 
  c1_.in_group_of_user_id AS in_group_of_user_id_121 
FROM 
  product p0_ 
  LEFT JOIN company c1_ ON p0_.company_id = c1_.id 
  LEFT JOIN storage_product s3_ ON p0_.id = s3_.product_id 
  LEFT JOIN storage s2_ ON s2_.id = s3_.storage_id 
  LEFT JOIN pricing_product p5_ ON p0_.id = p5_.product_id 
  LEFT JOIN pricing p4_ ON p4_.id = p5_.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_.delivery_type = 0 
  AND p0_.available = 1 
  AND c1_.show_publicly = 1 
  AND p0_.qty_ready_to_ship > 0 
  AND p0_.is_displayed_in_association_only = 0 
  AND p0_.is_consumer = 1 
GROUP BY 
  p0_.id 
ORDER BY 
  RAND() ASC 
LIMIT 
  10

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, c1_.id AS id_72, c1_.name AS name_73, c1_.website AS website_74, c1_.description AS description_75, c1_.speciality AS speciality_76, c1_.average_delivery_time AS average_delivery_time_77, c1_.taxe_tps AS taxe_tps_78, c1_.taxe_tvx AS taxe_tvx_79, c1_.company_number AS company_number_80, c1_.number_of_sales AS number_of_sales_81, c1_.total_sales_in_dollars AS total_sales_in_dollars_82, c1_.date_created AS date_created_83, c1_.custom_sale_conditions AS custom_sale_conditions_84, c1_.conditions_shipping AS conditions_shipping_85, c1_.conditions_return AS conditions_return_86, c1_.conditions_cancel AS conditions_cancel_87, c1_.terms_acceptance_date AS terms_acceptance_date_88, c1_.terms_acceptance_ip AS terms_acceptance_ip_89, c1_.solex_id AS solex_id_90, c1_.store_made_by_maturin AS store_made_by_maturin_91, c1_.terms_acceptance_finger_print AS terms_acceptance_finger_print_92, c1_.inventory_last_update AS inventory_last_update_93, c1_.show_publicly AS show_publicly_94, c1_.custom_url AS custom_url_95, c1_.is_allowed_to_schedule_cold_product AS is_allowed_to_schedule_cold_product_96, c1_.reminder_stripe_verification_sent AS reminder_stripe_verification_sent_97, c1_.export_colabor AS export_colabor_98, s2_.id AS id_99, s2_.type AS type_100, s2_.quantity_product AS quantity_product_101, s2_.height AS height_102, s2_.length AS length_103, s2_.width AS width_104, s2_.weight AS weight_105, s2_.unit_weight AS unit_weight_106, s2_.unit_dimension AS unit_dimension_107, s2_.values_are_approximate AS values_are_approximate_108, p0_.categories_id AS categories_id_109, p0_.conservation_id AS conservation_id_110, p0_.main_image_id AS main_image_id_111, p0_.company_id AS company_id_112, p0_.region_id AS region_id_113, p0_.nutrition_fact_image_id AS nutrition_fact_image_id_114, p0_.sub_category_id AS sub_category_id_115, p0_.corporative_id AS corporative_id_116, c1_.image_id AS image_id_117, c1_.banner_id AS banner_id_118, c1_.main_location_id AS main_location_id_119, c1_.recruiter_id AS recruiter_id_120, c1_.in_group_of_user_id AS in_group_of_user_id_121 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id LEFT JOIN storage_product s3_ ON p0_.id = s3_.product_id LEFT JOIN storage s2_ ON s2_.id = s3_.storage_id LEFT JOIN pricing_product p5_ ON p0_.id = p5_.product_id LEFT JOIN pricing p4_ ON p4_.id = p5_.pricing_id WHERE (p0_.categories_id = 35 OR p0_.sub_category_id = 35 OR p0_.sub_category_id IN (29, 88, 210, 211, 212)) AND p0_.draft <> 1 AND p0_.main_image_id IS NOT NULL AND p0_.delivery_type = 0 AND p0_.available = 1 AND c1_.show_publicly = 1 AND p0_.qty_ready_to_ship > 0 AND p0_.is_displayed_in_association_only = 0 AND p0_.is_consumer = 1 GROUP BY p0_.id ORDER BY RAND() ASC LIMIT 10;

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 
  c3_.placement ASC

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 = 168 OR p0_.sub_category_id = 168 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 c3_.placement ASC;

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

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_.draft <> 1 
  AND p0_.available = 1 
  AND p0_.main_image_id IS NOT NULL 
  AND c1_.show_publicly = 1 
  AND p0_.qty_ready_to_ship > 1 
  AND p0_.is_displayed_in_association_only <> 1 
  AND p0_.is_consumer = 1 
ORDER BY 
  RAND() ASC 
LIMIT 
  20

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_.draft <> 1 AND p0_.available = 1 AND p0_.main_image_id IS NOT NULL AND c1_.show_publicly = 1 AND p0_.qty_ready_to_ship > 1 AND p0_.is_displayed_in_association_only <> 1 AND p0_.is_consumer = 1 ORDER BY RAND() ASC LIMIT 20;

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

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.parent_product_id = ? 
  AND t0.available = ?