203.74 ms
(35.94%)
|
407 |
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
Parameters: [
355
[
355
false
]
]
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;
|
106.97 ms
(18.87%)
|
4 |
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
Parameters: [
35
35
[
29
88
210
211
212
]
]
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;
|
31.98 ms
(5.64%)
|
1 |
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 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;
|
29.81 ms
(5.26%)
|
59 |
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 = ?
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 = 4926;
|
24.92 ms
(4.40%)
|
108 |
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 = 4926;
|
24.23 ms
(4.27%)
|
1 |
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 = ?
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 = ?
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 = 6499 AND t0.available = 1;
|
20.19 ms
(3.56%)
|
86 |
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 = 173;
|
20.07 ms
(3.54%)
|
31 |
SELECT t0.id AS id_1, t0.orig_name AS orig_name_2, t0.orig_brand_name AS orig_brand_name_3, t0.qty_left AS qty_left_4, t0.unit_amount AS unit_amount_5, t0.unit AS unit_6, t0.available AS available_7, t0.orig_description AS orig_description_8, t0.origin AS origin_9, t0.best_before AS best_before_10, t0.creation_date AS creation_date_11, t0.nutrition_fact AS nutrition_fact_12, t0.new_product AS new_product_13, t0.taxable AS taxable_14, t0.maturin_upc AS maturin_upc_15, t0.code_upc AS code_upc_16, t0.code1 AS code1_17, t0.code2 AS code2_18, t0.code3 AS code3_19, t0.code_box AS code_box_20, t0.aliments_du_quebec AS aliments_du_quebec_21, t0.minimum_in_storage AS minimum_in_storage_22, t0.limited_quantity AS limited_quantity_23, t0.aliments_du_quebec_certification AS aliments_du_quebec_certification_24, t0.delivery_type AS delivery_type_25, t0.delivery_pickup AS delivery_pickup_26, t0.draft AS draft_27, t0.delivery_mail AS delivery_mail_28, t0.advices AS advices_29, t0.recipes AS recipes_30, t0.solex_id AS solex_id_31, t0.list_of_ingredients AS list_of_ingredients_32, t0.qty_ready_to_ship AS qty_ready_to_ship_33, t0.expiration_date AS expiration_date_34, t0.is_consigned AS is_consigned_35, t0.consigned_cost AS consigned_cost_36, t0.is_fragile AS is_fragile_37, t0.qty_per_unit AS qty_per_unit_38, t0.validated_by_distributor AS validated_by_distributor_39, t0.delivery_note AS delivery_note_40, t0.is_just_in_time AS is_just_in_time_41, t0.reminder_low_quantity_sent AS reminder_low_quantity_sent_42, t0.has_multiple_products AS has_multiple_products_43, t0.has_free_maturin_shipping AS has_free_maturin_shipping_44, t0.action_when_expired AS action_when_expired_45, t0.is_subscribable AS is_subscribable_46, t0.is_box_of_products AS is_box_of_products_47, t0.is_only_subscribable AS is_only_subscribable_48, t0.just_in_time_delivery_date AS just_in_time_delivery_date_49, t0.free_maturin_shipping_if_lower_then AS free_maturin_shipping_if_lower_then_50, t0.is_only_subscribable_to_type AS is_only_subscribable_to_type_51, t0.quantity_warehouse AS quantity_warehouse_52, t0.quantity_warehouse_reserved AS quantity_warehouse_reserved_53, t0.quantity_on_hold AS quantity_on_hold_54, t0.parent_product_id AS parent_product_id_55, t0.fee_warehouse_packing_per_unit AS fee_warehouse_packing_per_unit_56, t0.fee_warehouse_handling_per_unit AS fee_warehouse_handling_per_unit_57, t0.is_displayed_in_association_only AS is_displayed_in_association_only_58, t0.is_hri AS is_hri_59, t0.puro_exclusion AS puro_exclusion_60, t0.contains_alcohol AS contains_alcohol_61, t0.is_consumer AS is_consumer_62, t0.product_colabor_price AS product_colabor_price_63, t0.is_prix_laureat AS is_prix_laureat_64, t0.cant_use_coupon AS cant_use_coupon_65, t0.seasonality AS seasonality_66, t0.seasonality_start AS seasonality_start_67, t0.seasonality_end AS seasonality_end_68, t0.quantity_max_prod AS quantity_max_prod_69, t0.product_delete AS product_delete_70, t0.order_frequency AS order_frequency_71, t0.portion_for_meal AS portion_for_meal_72, t0.categories_id AS categories_id_73, t0.conservation_id AS conservation_id_74, t0.main_image_id AS main_image_id_75, t0.company_id AS company_id_76, t0.region_id AS region_id_77, t0.nutrition_fact_image_id AS nutrition_fact_image_id_78, t79.id AS id_80, t79.price_to_company AS price_to_company_81, t79.quantity AS quantity_82, t79.product_id AS product_id_83, t0.sub_category_id AS sub_category_id_84, t0.corporative_id AS corporative_id_85 FROM product t0 LEFT JOIN product_deal t79 ON t79.product_id = t0.id INNER JOIN pricing_product ON t0.id = pricing_product.product_id WHERE pricing_product.pricing_id = ?
SELECT
t0.id AS id_1,
t0.orig_name AS orig_name_2,
t0.orig_brand_name AS orig_brand_name_3,
t0.qty_left AS qty_left_4,
t0.unit_amount AS unit_amount_5,
t0.unit AS unit_6,
t0.available AS available_7,
t0.orig_description AS orig_description_8,
t0.origin AS origin_9,
t0.best_before AS best_before_10,
t0.creation_date AS creation_date_11,
t0.nutrition_fact AS nutrition_fact_12,
t0.new_product AS new_product_13,
t0.taxable AS taxable_14,
t0.maturin_upc AS maturin_upc_15,
t0.code_upc AS code_upc_16,
t0.code1 AS code1_17,
t0.code2 AS code2_18,
t0.code3 AS code3_19,
t0.code_box AS code_box_20,
t0.aliments_du_quebec AS aliments_du_quebec_21,
t0.minimum_in_storage AS minimum_in_storage_22,
t0.limited_quantity AS limited_quantity_23,
t0.aliments_du_quebec_certification AS aliments_du_quebec_certification_24,
t0.delivery_type AS delivery_type_25,
t0.delivery_pickup AS delivery_pickup_26,
t0.draft AS draft_27,
t0.delivery_mail AS delivery_mail_28,
t0.advices AS advices_29,
t0.recipes AS recipes_30,
t0.solex_id AS solex_id_31,
t0.list_of_ingredients AS list_of_ingredients_32,
t0.qty_ready_to_ship AS qty_ready_to_ship_33,
t0.expiration_date AS expiration_date_34,
t0.is_consigned AS is_consigned_35,
t0.consigned_cost AS consigned_cost_36,
t0.is_fragile AS is_fragile_37,
t0.qty_per_unit AS qty_per_unit_38,
t0.validated_by_distributor AS validated_by_distributor_39,
t0.delivery_note AS delivery_note_40,
t0.is_just_in_time AS is_just_in_time_41,
t0.reminder_low_quantity_sent AS reminder_low_quantity_sent_42,
t0.has_multiple_products AS has_multiple_products_43,
t0.has_free_maturin_shipping AS has_free_maturin_shipping_44,
t0.action_when_expired AS action_when_expired_45,
t0.is_subscribable AS is_subscribable_46,
t0.is_box_of_products AS is_box_of_products_47,
t0.is_only_subscribable AS is_only_subscribable_48,
t0.just_in_time_delivery_date AS just_in_time_delivery_date_49,
t0.free_maturin_shipping_if_lower_then AS free_maturin_shipping_if_lower_then_50,
t0.is_only_subscribable_to_type AS is_only_subscribable_to_type_51,
t0.quantity_warehouse AS quantity_warehouse_52,
t0.quantity_warehouse_reserved AS quantity_warehouse_reserved_53,
t0.quantity_on_hold AS quantity_on_hold_54,
t0.parent_product_id AS parent_product_id_55,
t0.fee_warehouse_packing_per_unit AS fee_warehouse_packing_per_unit_56,
t0.fee_warehouse_handling_per_unit AS fee_warehouse_handling_per_unit_57,
t0.is_displayed_in_association_only AS is_displayed_in_association_only_58,
t0.is_hri AS is_hri_59,
t0.puro_exclusion AS puro_exclusion_60,
t0.contains_alcohol AS contains_alcohol_61,
t0.is_consumer AS is_consumer_62,
t0.product_colabor_price AS product_colabor_price_63,
t0.is_prix_laureat AS is_prix_laureat_64,
t0.cant_use_coupon AS cant_use_coupon_65,
t0.seasonality AS seasonality_66,
t0.seasonality_start AS seasonality_start_67,
t0.seasonality_end AS seasonality_end_68,
t0.quantity_max_prod AS quantity_max_prod_69,
t0.product_delete AS product_delete_70,
t0.order_frequency AS order_frequency_71,
t0.portion_for_meal AS portion_for_meal_72,
t0.categories_id AS categories_id_73,
t0.conservation_id AS conservation_id_74,
t0.main_image_id AS main_image_id_75,
t0.company_id AS company_id_76,
t0.region_id AS region_id_77,
t0.nutrition_fact_image_id AS nutrition_fact_image_id_78,
t79.id AS id_80,
t79.price_to_company AS price_to_company_81,
t79.quantity AS quantity_82,
t79.product_id AS product_id_83,
t0.sub_category_id AS sub_category_id_84,
t0.corporative_id AS corporative_id_85
FROM
product t0
LEFT JOIN product_deal t79 ON t79.product_id = t0.id
INNER JOIN pricing_product ON t0.id = pricing_product.product_id
WHERE
pricing_product.pricing_id = ?
SELECT t0.id AS id_1, t0.orig_name AS orig_name_2, t0.orig_brand_name AS orig_brand_name_3, t0.qty_left AS qty_left_4, t0.unit_amount AS unit_amount_5, t0.unit AS unit_6, t0.available AS available_7, t0.orig_description AS orig_description_8, t0.origin AS origin_9, t0.best_before AS best_before_10, t0.creation_date AS creation_date_11, t0.nutrition_fact AS nutrition_fact_12, t0.new_product AS new_product_13, t0.taxable AS taxable_14, t0.maturin_upc AS maturin_upc_15, t0.code_upc AS code_upc_16, t0.code1 AS code1_17, t0.code2 AS code2_18, t0.code3 AS code3_19, t0.code_box AS code_box_20, t0.aliments_du_quebec AS aliments_du_quebec_21, t0.minimum_in_storage AS minimum_in_storage_22, t0.limited_quantity AS limited_quantity_23, t0.aliments_du_quebec_certification AS aliments_du_quebec_certification_24, t0.delivery_type AS delivery_type_25, t0.delivery_pickup AS delivery_pickup_26, t0.draft AS draft_27, t0.delivery_mail AS delivery_mail_28, t0.advices AS advices_29, t0.recipes AS recipes_30, t0.solex_id AS solex_id_31, t0.list_of_ingredients AS list_of_ingredients_32, t0.qty_ready_to_ship AS qty_ready_to_ship_33, t0.expiration_date AS expiration_date_34, t0.is_consigned AS is_consigned_35, t0.consigned_cost AS consigned_cost_36, t0.is_fragile AS is_fragile_37, t0.qty_per_unit AS qty_per_unit_38, t0.validated_by_distributor AS validated_by_distributor_39, t0.delivery_note AS delivery_note_40, t0.is_just_in_time AS is_just_in_time_41, t0.reminder_low_quantity_sent AS reminder_low_quantity_sent_42, t0.has_multiple_products AS has_multiple_products_43, t0.has_free_maturin_shipping AS has_free_maturin_shipping_44, t0.action_when_expired AS action_when_expired_45, t0.is_subscribable AS is_subscribable_46, t0.is_box_of_products AS is_box_of_products_47, t0.is_only_subscribable AS is_only_subscribable_48, t0.just_in_time_delivery_date AS just_in_time_delivery_date_49, t0.free_maturin_shipping_if_lower_then AS free_maturin_shipping_if_lower_then_50, t0.is_only_subscribable_to_type AS is_only_subscribable_to_type_51, t0.quantity_warehouse AS quantity_warehouse_52, t0.quantity_warehouse_reserved AS quantity_warehouse_reserved_53, t0.quantity_on_hold AS quantity_on_hold_54, t0.parent_product_id AS parent_product_id_55, t0.fee_warehouse_packing_per_unit AS fee_warehouse_packing_per_unit_56, t0.fee_warehouse_handling_per_unit AS fee_warehouse_handling_per_unit_57, t0.is_displayed_in_association_only AS is_displayed_in_association_only_58, t0.is_hri AS is_hri_59, t0.puro_exclusion AS puro_exclusion_60, t0.contains_alcohol AS contains_alcohol_61, t0.is_consumer AS is_consumer_62, t0.product_colabor_price AS product_colabor_price_63, t0.is_prix_laureat AS is_prix_laureat_64, t0.cant_use_coupon AS cant_use_coupon_65, t0.seasonality AS seasonality_66, t0.seasonality_start AS seasonality_start_67, t0.seasonality_end AS seasonality_end_68, t0.quantity_max_prod AS quantity_max_prod_69, t0.product_delete AS product_delete_70, t0.order_frequency AS order_frequency_71, t0.portion_for_meal AS portion_for_meal_72, t0.categories_id AS categories_id_73, t0.conservation_id AS conservation_id_74, t0.main_image_id AS main_image_id_75, t0.company_id AS company_id_76, t0.region_id AS region_id_77, t0.nutrition_fact_image_id AS nutrition_fact_image_id_78, t79.id AS id_80, t79.price_to_company AS price_to_company_81, t79.quantity AS quantity_82, t79.product_id AS product_id_83, t0.sub_category_id AS sub_category_id_84, t0.corporative_id AS corporative_id_85 FROM product t0 LEFT JOIN product_deal t79 ON t79.product_id = t0.id INNER JOIN pricing_product ON t0.id = pricing_product.product_id WHERE pricing_product.pricing_id = 27134;
|
15.11 ms
(2.66%)
|
1 |
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
Parameters: [
173
173
[
85
174
175
176
336
337
338
340
345
346
]
]
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 = 173 OR p0_.sub_category_id = 173 OR p0_.sub_category_id IN (85, 174, 175, 176, 336, 337, 338, 340, 345, 346)) 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;
|
10.60 ms
(1.87%)
|
2 |
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
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
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;
|
9.90 ms
(1.75%)
|
31 |
SELECT t0.id AS id_1, t0.price AS price_2, t0.currency AS currency_3, t0.quantity AS quantity_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.is_adiscount AS is_adiscount_7, t0.storage_id AS storage_id_8, t0.discount_product_id AS discount_product_id_9 FROM pricing t0 INNER JOIN pricing_product ON t0.id = pricing_product.pricing_id WHERE pricing_product.product_id = ?
SELECT t0.id AS id_1, t0.price AS price_2, t0.currency AS currency_3, t0.quantity AS quantity_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.is_adiscount AS is_adiscount_7, t0.storage_id AS storage_id_8, t0.discount_product_id AS discount_product_id_9 FROM pricing t0 INNER JOIN pricing_product ON t0.id = pricing_product.pricing_id WHERE pricing_product.product_id = 6499;
|
9.11 ms
(1.61%)
|
28 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.acronym AS acronym_3, t0.category AS category_4 FROM certification t0 INNER JOIN certification_product ON t0.id = certification_product.certification_id WHERE certification_product.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.acronym AS acronym_3, t0.category AS category_4 FROM certification t0 INNER JOIN certification_product ON t0.id = certification_product.certification_id WHERE certification_product.product_id = 6499;
|
8.83 ms
(1.56%)
|
29 |
SELECT t0.id AS id_1, t0.price AS price_2, t0.currency AS currency_3, t0.quantity AS quantity_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.is_adiscount AS is_adiscount_7, t0.storage_id AS storage_id_8, t0.discount_product_id AS discount_product_id_9 FROM pricing t0 WHERE t0.discount_product_id = ?
SELECT t0.id AS id_1, t0.price AS price_2, t0.currency AS currency_3, t0.quantity AS quantity_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.is_adiscount AS is_adiscount_7, t0.storage_id AS storage_id_8, t0.discount_product_id AS discount_product_id_9 FROM pricing t0 WHERE t0.discount_product_id = 6499;
|
7.98 ms
(1.41%)
|
12 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.website AS website_3, t0.description AS description_4, t0.speciality AS speciality_5, t0.average_delivery_time AS average_delivery_time_6, t0.taxe_tps AS taxe_tps_7, t0.taxe_tvx AS taxe_tvx_8, t0.company_number AS company_number_9, t0.number_of_sales AS number_of_sales_10, t0.total_sales_in_dollars AS total_sales_in_dollars_11, t0.date_created AS date_created_12, t0.custom_sale_conditions AS custom_sale_conditions_13, t0.conditions_shipping AS conditions_shipping_14, t0.conditions_return AS conditions_return_15, t0.conditions_cancel AS conditions_cancel_16, t0.terms_acceptance_date AS terms_acceptance_date_17, t0.terms_acceptance_ip AS terms_acceptance_ip_18, t0.solex_id AS solex_id_19, t0.store_made_by_maturin AS store_made_by_maturin_20, t0.terms_acceptance_finger_print AS terms_acceptance_finger_print_21, t0.inventory_last_update AS inventory_last_update_22, t0.show_publicly AS show_publicly_23, t0.custom_url AS custom_url_24, t0.is_allowed_to_schedule_cold_product AS is_allowed_to_schedule_cold_product_25, t0.reminder_stripe_verification_sent AS reminder_stripe_verification_sent_26, t0.export_colabor AS export_colabor_27, t0.image_id AS image_id_28, t0.banner_id AS banner_id_29, t0.main_location_id AS main_location_id_30, t31.id AS id_32, t31.country AS country_33, t31.currency AS currency_34, t31.account_number AS account_number_35, t31.account_transit AS account_transit_36, t31.account_institution AS account_institution_37, t31.account_other AS account_other_38, t31.company_owners AS company_owners_39, t31.legal_city AS legal_city_40, t31.legal_civic_number AS legal_civic_number_41, t31.legal_street_name AS legal_street_name_42, t31.legal_zip_code AS legal_zip_code_43, t31.legal_province AS legal_province_44, t31.legal_company_name AS legal_company_name_45, t31.legal_tax_id AS legal_tax_id_46, t31.legal_account_owner_dob AS legal_account_owner_dob_47, t31.legal_account_owner_first_name AS legal_account_owner_first_name_48, t31.legal_account_owner_last_name AS legal_account_owner_last_name_49, t31.legal_account_owner_city AS legal_account_owner_city_50, t31.legal_account_owner_civic_number AS legal_account_owner_civic_number_51, t31.legal_account_owner_street_name AS legal_account_owner_street_name_52, t31.legal_account_owner_zip_code AS legal_account_owner_zip_code_53, t31.legal_account_owner_id AS legal_account_owner_id_54, t31.legal_account_owner_last4ssn AS legal_account_owner_last4ssn_55, t31.legal_account_owner_company_type AS legal_account_owner_company_type_56, t31.stripe_tosaccepted_date AS stripe_tosaccepted_date_57, t31.stripe_ip AS stripe_ip_58, t31.legal_account_owner_province AS legal_account_owner_province_59, t31.minimum_allowed AS minimum_allowed_60, t31.stripe_account_id AS stripe_account_id_61, t31.stripe_account_verified AS stripe_account_verified_62, t31.company_id AS company_id_63, t31.legal_account_owner_photo_id_id AS legal_account_owner_photo_id_id_64, t31.legal_account_owner_photo_recto_id_id AS legal_account_owner_photo_recto_id_id_65, t66.id AS id_67, t66.delivery_mail AS delivery_mail_68, t66.delivery_type AS delivery_type_69, t66.minimum_in_storage AS minimum_in_storage_70, t66.delivery_pick_up AS delivery_pick_up_71, t66.action_for_expired_product AS action_for_expired_product_72, t66.company_id AS company_id_73, t66.conservation_id AS conservation_id_74, t0.recruiter_id AS recruiter_id_75, t0.in_group_of_user_id AS in_group_of_user_id_76 FROM company t0 LEFT JOIN company_deposit t31 ON t31.company_id = t0.id LEFT JOIN company_default_shipping t66 ON t66.company_id = t0.id WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.name AS name_2,
t0.website AS website_3,
t0.description AS description_4,
t0.speciality AS speciality_5,
t0.average_delivery_time AS average_delivery_time_6,
t0.taxe_tps AS taxe_tps_7,
t0.taxe_tvx AS taxe_tvx_8,
t0.company_number AS company_number_9,
t0.number_of_sales AS number_of_sales_10,
t0.total_sales_in_dollars AS total_sales_in_dollars_11,
t0.date_created AS date_created_12,
t0.custom_sale_conditions AS custom_sale_conditions_13,
t0.conditions_shipping AS conditions_shipping_14,
t0.conditions_return AS conditions_return_15,
t0.conditions_cancel AS conditions_cancel_16,
t0.terms_acceptance_date AS terms_acceptance_date_17,
t0.terms_acceptance_ip AS terms_acceptance_ip_18,
t0.solex_id AS solex_id_19,
t0.store_made_by_maturin AS store_made_by_maturin_20,
t0.terms_acceptance_finger_print AS terms_acceptance_finger_print_21,
t0.inventory_last_update AS inventory_last_update_22,
t0.show_publicly AS show_publicly_23,
t0.custom_url AS custom_url_24,
t0.is_allowed_to_schedule_cold_product AS is_allowed_to_schedule_cold_product_25,
t0.reminder_stripe_verification_sent AS reminder_stripe_verification_sent_26,
t0.export_colabor AS export_colabor_27,
t0.image_id AS image_id_28,
t0.banner_id AS banner_id_29,
t0.main_location_id AS main_location_id_30,
t31.id AS id_32,
t31.country AS country_33,
t31.currency AS currency_34,
t31.account_number AS account_number_35,
t31.account_transit AS account_transit_36,
t31.account_institution AS account_institution_37,
t31.account_other AS account_other_38,
t31.company_owners AS company_owners_39,
t31.legal_city AS legal_city_40,
t31.legal_civic_number AS legal_civic_number_41,
t31.legal_street_name AS legal_street_name_42,
t31.legal_zip_code AS legal_zip_code_43,
t31.legal_province AS legal_province_44,
t31.legal_company_name AS legal_company_name_45,
t31.legal_tax_id AS legal_tax_id_46,
t31.legal_account_owner_dob AS legal_account_owner_dob_47,
t31.legal_account_owner_first_name AS legal_account_owner_first_name_48,
t31.legal_account_owner_last_name AS legal_account_owner_last_name_49,
t31.legal_account_owner_city AS legal_account_owner_city_50,
t31.legal_account_owner_civic_number AS legal_account_owner_civic_number_51,
t31.legal_account_owner_street_name AS legal_account_owner_street_name_52,
t31.legal_account_owner_zip_code AS legal_account_owner_zip_code_53,
t31.legal_account_owner_id AS legal_account_owner_id_54,
t31.legal_account_owner_last4ssn AS legal_account_owner_last4ssn_55,
t31.legal_account_owner_company_type AS legal_account_owner_company_type_56,
t31.stripe_tosaccepted_date AS stripe_tosaccepted_date_57,
t31.stripe_ip AS stripe_ip_58,
t31.legal_account_owner_province AS legal_account_owner_province_59,
t31.minimum_allowed AS minimum_allowed_60,
t31.stripe_account_id AS stripe_account_id_61,
t31.stripe_account_verified AS stripe_account_verified_62,
t31.company_id AS company_id_63,
t31.legal_account_owner_photo_id_id AS legal_account_owner_photo_id_id_64,
t31.legal_account_owner_photo_recto_id_id AS legal_account_owner_photo_recto_id_id_65,
t66.id AS id_67,
t66.delivery_mail AS delivery_mail_68,
t66.delivery_type AS delivery_type_69,
t66.minimum_in_storage AS minimum_in_storage_70,
t66.delivery_pick_up AS delivery_pick_up_71,
t66.action_for_expired_product AS action_for_expired_product_72,
t66.company_id AS company_id_73,
t66.conservation_id AS conservation_id_74,
t0.recruiter_id AS recruiter_id_75,
t0.in_group_of_user_id AS in_group_of_user_id_76
FROM
company t0
LEFT JOIN company_deposit t31 ON t31.company_id = t0.id
LEFT JOIN company_default_shipping t66 ON t66.company_id = t0.id
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.website AS website_3, t0.description AS description_4, t0.speciality AS speciality_5, t0.average_delivery_time AS average_delivery_time_6, t0.taxe_tps AS taxe_tps_7, t0.taxe_tvx AS taxe_tvx_8, t0.company_number AS company_number_9, t0.number_of_sales AS number_of_sales_10, t0.total_sales_in_dollars AS total_sales_in_dollars_11, t0.date_created AS date_created_12, t0.custom_sale_conditions AS custom_sale_conditions_13, t0.conditions_shipping AS conditions_shipping_14, t0.conditions_return AS conditions_return_15, t0.conditions_cancel AS conditions_cancel_16, t0.terms_acceptance_date AS terms_acceptance_date_17, t0.terms_acceptance_ip AS terms_acceptance_ip_18, t0.solex_id AS solex_id_19, t0.store_made_by_maturin AS store_made_by_maturin_20, t0.terms_acceptance_finger_print AS terms_acceptance_finger_print_21, t0.inventory_last_update AS inventory_last_update_22, t0.show_publicly AS show_publicly_23, t0.custom_url AS custom_url_24, t0.is_allowed_to_schedule_cold_product AS is_allowed_to_schedule_cold_product_25, t0.reminder_stripe_verification_sent AS reminder_stripe_verification_sent_26, t0.export_colabor AS export_colabor_27, t0.image_id AS image_id_28, t0.banner_id AS banner_id_29, t0.main_location_id AS main_location_id_30, t31.id AS id_32, t31.country AS country_33, t31.currency AS currency_34, t31.account_number AS account_number_35, t31.account_transit AS account_transit_36, t31.account_institution AS account_institution_37, t31.account_other AS account_other_38, t31.company_owners AS company_owners_39, t31.legal_city AS legal_city_40, t31.legal_civic_number AS legal_civic_number_41, t31.legal_street_name AS legal_street_name_42, t31.legal_zip_code AS legal_zip_code_43, t31.legal_province AS legal_province_44, t31.legal_company_name AS legal_company_name_45, t31.legal_tax_id AS legal_tax_id_46, t31.legal_account_owner_dob AS legal_account_owner_dob_47, t31.legal_account_owner_first_name AS legal_account_owner_first_name_48, t31.legal_account_owner_last_name AS legal_account_owner_last_name_49, t31.legal_account_owner_city AS legal_account_owner_city_50, t31.legal_account_owner_civic_number AS legal_account_owner_civic_number_51, t31.legal_account_owner_street_name AS legal_account_owner_street_name_52, t31.legal_account_owner_zip_code AS legal_account_owner_zip_code_53, t31.legal_account_owner_id AS legal_account_owner_id_54, t31.legal_account_owner_last4ssn AS legal_account_owner_last4ssn_55, t31.legal_account_owner_company_type AS legal_account_owner_company_type_56, t31.stripe_tosaccepted_date AS stripe_tosaccepted_date_57, t31.stripe_ip AS stripe_ip_58, t31.legal_account_owner_province AS legal_account_owner_province_59, t31.minimum_allowed AS minimum_allowed_60, t31.stripe_account_id AS stripe_account_id_61, t31.stripe_account_verified AS stripe_account_verified_62, t31.company_id AS company_id_63, t31.legal_account_owner_photo_id_id AS legal_account_owner_photo_id_id_64, t31.legal_account_owner_photo_recto_id_id AS legal_account_owner_photo_recto_id_id_65, t66.id AS id_67, t66.delivery_mail AS delivery_mail_68, t66.delivery_type AS delivery_type_69, t66.minimum_in_storage AS minimum_in_storage_70, t66.delivery_pick_up AS delivery_pick_up_71, t66.action_for_expired_product AS action_for_expired_product_72, t66.company_id AS company_id_73, t66.conservation_id AS conservation_id_74, t0.recruiter_id AS recruiter_id_75, t0.in_group_of_user_id AS in_group_of_user_id_76 FROM company t0 LEFT JOIN company_deposit t31 ON t31.company_id = t0.id LEFT JOIN company_default_shipping t66 ON t66.company_id = t0.id WHERE t0.id = 663;
|
7.89 ms
(1.39%)
|
23 |
SELECT t0.id AS id_1, t0.country AS country_2, t0.currency AS currency_3, t0.account_number AS account_number_4, t0.account_transit AS account_transit_5, t0.account_institution AS account_institution_6, t0.account_other AS account_other_7, t0.company_owners AS company_owners_8, t0.legal_city AS legal_city_9, t0.legal_civic_number AS legal_civic_number_10, t0.legal_street_name AS legal_street_name_11, t0.legal_zip_code AS legal_zip_code_12, t0.legal_province AS legal_province_13, t0.legal_company_name AS legal_company_name_14, t0.legal_tax_id AS legal_tax_id_15, t0.legal_account_owner_dob AS legal_account_owner_dob_16, t0.legal_account_owner_first_name AS legal_account_owner_first_name_17, t0.legal_account_owner_last_name AS legal_account_owner_last_name_18, t0.legal_account_owner_city AS legal_account_owner_city_19, t0.legal_account_owner_civic_number AS legal_account_owner_civic_number_20, t0.legal_account_owner_street_name AS legal_account_owner_street_name_21, t0.legal_account_owner_zip_code AS legal_account_owner_zip_code_22, t0.legal_account_owner_id AS legal_account_owner_id_23, t0.legal_account_owner_last4ssn AS legal_account_owner_last4ssn_24, t0.legal_account_owner_company_type AS legal_account_owner_company_type_25, t0.stripe_tosaccepted_date AS stripe_tosaccepted_date_26, t0.stripe_ip AS stripe_ip_27, t0.legal_account_owner_province AS legal_account_owner_province_28, t0.minimum_allowed AS minimum_allowed_29, t0.stripe_account_id AS stripe_account_id_30, t0.stripe_account_verified AS stripe_account_verified_31, t0.company_id AS company_id_32, t0.legal_account_owner_photo_id_id AS legal_account_owner_photo_id_id_33, t0.legal_account_owner_photo_recto_id_id AS legal_account_owner_photo_recto_id_id_34 FROM company_deposit t0 WHERE t0.company_id = ?
SELECT t0.id AS id_1, t0.country AS country_2, t0.currency AS currency_3, t0.account_number AS account_number_4, t0.account_transit AS account_transit_5, t0.account_institution AS account_institution_6, t0.account_other AS account_other_7, t0.company_owners AS company_owners_8, t0.legal_city AS legal_city_9, t0.legal_civic_number AS legal_civic_number_10, t0.legal_street_name AS legal_street_name_11, t0.legal_zip_code AS legal_zip_code_12, t0.legal_province AS legal_province_13, t0.legal_company_name AS legal_company_name_14, t0.legal_tax_id AS legal_tax_id_15, t0.legal_account_owner_dob AS legal_account_owner_dob_16, t0.legal_account_owner_first_name AS legal_account_owner_first_name_17, t0.legal_account_owner_last_name AS legal_account_owner_last_name_18, t0.legal_account_owner_city AS legal_account_owner_city_19, t0.legal_account_owner_civic_number AS legal_account_owner_civic_number_20, t0.legal_account_owner_street_name AS legal_account_owner_street_name_21, t0.legal_account_owner_zip_code AS legal_account_owner_zip_code_22, t0.legal_account_owner_id AS legal_account_owner_id_23, t0.legal_account_owner_last4ssn AS legal_account_owner_last4ssn_24, t0.legal_account_owner_company_type AS legal_account_owner_company_type_25, t0.stripe_tosaccepted_date AS stripe_tosaccepted_date_26, t0.stripe_ip AS stripe_ip_27, t0.legal_account_owner_province AS legal_account_owner_province_28, t0.minimum_allowed AS minimum_allowed_29, t0.stripe_account_id AS stripe_account_id_30, t0.stripe_account_verified AS stripe_account_verified_31, t0.company_id AS company_id_32, t0.legal_account_owner_photo_id_id AS legal_account_owner_photo_id_id_33, t0.legal_account_owner_photo_recto_id_id AS legal_account_owner_photo_recto_id_id_34 FROM company_deposit t0 WHERE t0.company_id = 675;
|
7.52 ms
(1.33%)
|
26 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.quantity_product AS quantity_product_3, t0.height AS height_4, t0.length AS length_5, t0.width AS width_6, t0.weight AS weight_7, t0.unit_weight AS unit_weight_8, t0.unit_dimension AS unit_dimension_9, t0.values_are_approximate AS values_are_approximate_10 FROM storage t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.quantity_product AS quantity_product_3, t0.height AS height_4, t0.length AS length_5, t0.width AS width_6, t0.weight AS weight_7, t0.unit_weight AS unit_weight_8, t0.unit_dimension AS unit_dimension_9, t0.values_are_approximate AS values_are_approximate_10 FROM storage t0 WHERE t0.id = 15082;
|
6.25 ms
(1.10%)
|
23 |
SELECT t0.id AS id_1, t0.delivery_mail AS delivery_mail_2, t0.delivery_type AS delivery_type_3, t0.minimum_in_storage AS minimum_in_storage_4, t0.delivery_pick_up AS delivery_pick_up_5, t0.action_for_expired_product AS action_for_expired_product_6, t0.company_id AS company_id_7, t0.conservation_id AS conservation_id_8 FROM company_default_shipping t0 WHERE t0.company_id = ?
SELECT t0.id AS id_1, t0.delivery_mail AS delivery_mail_2, t0.delivery_type AS delivery_type_3, t0.minimum_in_storage AS minimum_in_storage_4, t0.delivery_pick_up AS delivery_pick_up_5, t0.action_for_expired_product AS action_for_expired_product_6, t0.company_id AS company_id_7, t0.conservation_id AS conservation_id_8 FROM company_default_shipping t0 WHERE t0.company_id = 675;
|
5.05 ms
(0.89%)
|
7 |
SELECT t0.id AS id_1, t0.orig_name AS orig_name_2, t0.orig_brand_name AS orig_brand_name_3, t0.qty_left AS qty_left_4, t0.unit_amount AS unit_amount_5, t0.unit AS unit_6, t0.available AS available_7, t0.orig_description AS orig_description_8, t0.origin AS origin_9, t0.best_before AS best_before_10, t0.creation_date AS creation_date_11, t0.nutrition_fact AS nutrition_fact_12, t0.new_product AS new_product_13, t0.taxable AS taxable_14, t0.maturin_upc AS maturin_upc_15, t0.code_upc AS code_upc_16, t0.code1 AS code1_17, t0.code2 AS code2_18, t0.code3 AS code3_19, t0.code_box AS code_box_20, t0.aliments_du_quebec AS aliments_du_quebec_21, t0.minimum_in_storage AS minimum_in_storage_22, t0.limited_quantity AS limited_quantity_23, t0.aliments_du_quebec_certification AS aliments_du_quebec_certification_24, t0.delivery_type AS delivery_type_25, t0.delivery_pickup AS delivery_pickup_26, t0.draft AS draft_27, t0.delivery_mail AS delivery_mail_28, t0.advices AS advices_29, t0.recipes AS recipes_30, t0.solex_id AS solex_id_31, t0.list_of_ingredients AS list_of_ingredients_32, t0.qty_ready_to_ship AS qty_ready_to_ship_33, t0.expiration_date AS expiration_date_34, t0.is_consigned AS is_consigned_35, t0.consigned_cost AS consigned_cost_36, t0.is_fragile AS is_fragile_37, t0.qty_per_unit AS qty_per_unit_38, t0.validated_by_distributor AS validated_by_distributor_39, t0.delivery_note AS delivery_note_40, t0.is_just_in_time AS is_just_in_time_41, t0.reminder_low_quantity_sent AS reminder_low_quantity_sent_42, t0.has_multiple_products AS has_multiple_products_43, t0.has_free_maturin_shipping AS has_free_maturin_shipping_44, t0.action_when_expired AS action_when_expired_45, t0.is_subscribable AS is_subscribable_46, t0.is_box_of_products AS is_box_of_products_47, t0.is_only_subscribable AS is_only_subscribable_48, t0.just_in_time_delivery_date AS just_in_time_delivery_date_49, t0.free_maturin_shipping_if_lower_then AS free_maturin_shipping_if_lower_then_50, t0.is_only_subscribable_to_type AS is_only_subscribable_to_type_51, t0.quantity_warehouse AS quantity_warehouse_52, t0.quantity_warehouse_reserved AS quantity_warehouse_reserved_53, t0.quantity_on_hold AS quantity_on_hold_54, t0.parent_product_id AS parent_product_id_55, t0.fee_warehouse_packing_per_unit AS fee_warehouse_packing_per_unit_56, t0.fee_warehouse_handling_per_unit AS fee_warehouse_handling_per_unit_57, t0.is_displayed_in_association_only AS is_displayed_in_association_only_58, t0.is_hri AS is_hri_59, t0.puro_exclusion AS puro_exclusion_60, t0.contains_alcohol AS contains_alcohol_61, t0.is_consumer AS is_consumer_62, t0.product_colabor_price AS product_colabor_price_63, t0.is_prix_laureat AS is_prix_laureat_64, t0.cant_use_coupon AS cant_use_coupon_65, t0.seasonality AS seasonality_66, t0.seasonality_start AS seasonality_start_67, t0.seasonality_end AS seasonality_end_68, t0.quantity_max_prod AS quantity_max_prod_69, t0.product_delete AS product_delete_70, t0.order_frequency AS order_frequency_71, t0.portion_for_meal AS portion_for_meal_72, t0.categories_id AS categories_id_73, t0.conservation_id AS conservation_id_74, t0.main_image_id AS main_image_id_75, t0.company_id AS company_id_76, t0.region_id AS region_id_77, t0.nutrition_fact_image_id AS nutrition_fact_image_id_78, t79.id AS id_80, t79.price_to_company AS price_to_company_81, t79.quantity AS quantity_82, t79.product_id AS product_id_83, t0.sub_category_id AS sub_category_id_84, t0.corporative_id AS corporative_id_85 FROM product t0 LEFT JOIN product_deal t79 ON t79.product_id = t0.id WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.orig_name AS orig_name_2,
t0.orig_brand_name AS orig_brand_name_3,
t0.qty_left AS qty_left_4,
t0.unit_amount AS unit_amount_5,
t0.unit AS unit_6,
t0.available AS available_7,
t0.orig_description AS orig_description_8,
t0.origin AS origin_9,
t0.best_before AS best_before_10,
t0.creation_date AS creation_date_11,
t0.nutrition_fact AS nutrition_fact_12,
t0.new_product AS new_product_13,
t0.taxable AS taxable_14,
t0.maturin_upc AS maturin_upc_15,
t0.code_upc AS code_upc_16,
t0.code1 AS code1_17,
t0.code2 AS code2_18,
t0.code3 AS code3_19,
t0.code_box AS code_box_20,
t0.aliments_du_quebec AS aliments_du_quebec_21,
t0.minimum_in_storage AS minimum_in_storage_22,
t0.limited_quantity AS limited_quantity_23,
t0.aliments_du_quebec_certification AS aliments_du_quebec_certification_24,
t0.delivery_type AS delivery_type_25,
t0.delivery_pickup AS delivery_pickup_26,
t0.draft AS draft_27,
t0.delivery_mail AS delivery_mail_28,
t0.advices AS advices_29,
t0.recipes AS recipes_30,
t0.solex_id AS solex_id_31,
t0.list_of_ingredients AS list_of_ingredients_32,
t0.qty_ready_to_ship AS qty_ready_to_ship_33,
t0.expiration_date AS expiration_date_34,
t0.is_consigned AS is_consigned_35,
t0.consigned_cost AS consigned_cost_36,
t0.is_fragile AS is_fragile_37,
t0.qty_per_unit AS qty_per_unit_38,
t0.validated_by_distributor AS validated_by_distributor_39,
t0.delivery_note AS delivery_note_40,
t0.is_just_in_time AS is_just_in_time_41,
t0.reminder_low_quantity_sent AS reminder_low_quantity_sent_42,
t0.has_multiple_products AS has_multiple_products_43,
t0.has_free_maturin_shipping AS has_free_maturin_shipping_44,
t0.action_when_expired AS action_when_expired_45,
t0.is_subscribable AS is_subscribable_46,
t0.is_box_of_products AS is_box_of_products_47,
t0.is_only_subscribable AS is_only_subscribable_48,
t0.just_in_time_delivery_date AS just_in_time_delivery_date_49,
t0.free_maturin_shipping_if_lower_then AS free_maturin_shipping_if_lower_then_50,
t0.is_only_subscribable_to_type AS is_only_subscribable_to_type_51,
t0.quantity_warehouse AS quantity_warehouse_52,
t0.quantity_warehouse_reserved AS quantity_warehouse_reserved_53,
t0.quantity_on_hold AS quantity_on_hold_54,
t0.parent_product_id AS parent_product_id_55,
t0.fee_warehouse_packing_per_unit AS fee_warehouse_packing_per_unit_56,
t0.fee_warehouse_handling_per_unit AS fee_warehouse_handling_per_unit_57,
t0.is_displayed_in_association_only AS is_displayed_in_association_only_58,
t0.is_hri AS is_hri_59,
t0.puro_exclusion AS puro_exclusion_60,
t0.contains_alcohol AS contains_alcohol_61,
t0.is_consumer AS is_consumer_62,
t0.product_colabor_price AS product_colabor_price_63,
t0.is_prix_laureat AS is_prix_laureat_64,
t0.cant_use_coupon AS cant_use_coupon_65,
t0.seasonality AS seasonality_66,
t0.seasonality_start AS seasonality_start_67,
t0.seasonality_end AS seasonality_end_68,
t0.quantity_max_prod AS quantity_max_prod_69,
t0.product_delete AS product_delete_70,
t0.order_frequency AS order_frequency_71,
t0.portion_for_meal AS portion_for_meal_72,
t0.categories_id AS categories_id_73,
t0.conservation_id AS conservation_id_74,
t0.main_image_id AS main_image_id_75,
t0.company_id AS company_id_76,
t0.region_id AS region_id_77,
t0.nutrition_fact_image_id AS nutrition_fact_image_id_78,
t79.id AS id_80,
t79.price_to_company AS price_to_company_81,
t79.quantity AS quantity_82,
t79.product_id AS product_id_83,
t0.sub_category_id AS sub_category_id_84,
t0.corporative_id AS corporative_id_85
FROM
product t0
LEFT JOIN product_deal t79 ON t79.product_id = t0.id
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.orig_name AS orig_name_2, t0.orig_brand_name AS orig_brand_name_3, t0.qty_left AS qty_left_4, t0.unit_amount AS unit_amount_5, t0.unit AS unit_6, t0.available AS available_7, t0.orig_description AS orig_description_8, t0.origin AS origin_9, t0.best_before AS best_before_10, t0.creation_date AS creation_date_11, t0.nutrition_fact AS nutrition_fact_12, t0.new_product AS new_product_13, t0.taxable AS taxable_14, t0.maturin_upc AS maturin_upc_15, t0.code_upc AS code_upc_16, t0.code1 AS code1_17, t0.code2 AS code2_18, t0.code3 AS code3_19, t0.code_box AS code_box_20, t0.aliments_du_quebec AS aliments_du_quebec_21, t0.minimum_in_storage AS minimum_in_storage_22, t0.limited_quantity AS limited_quantity_23, t0.aliments_du_quebec_certification AS aliments_du_quebec_certification_24, t0.delivery_type AS delivery_type_25, t0.delivery_pickup AS delivery_pickup_26, t0.draft AS draft_27, t0.delivery_mail AS delivery_mail_28, t0.advices AS advices_29, t0.recipes AS recipes_30, t0.solex_id AS solex_id_31, t0.list_of_ingredients AS list_of_ingredients_32, t0.qty_ready_to_ship AS qty_ready_to_ship_33, t0.expiration_date AS expiration_date_34, t0.is_consigned AS is_consigned_35, t0.consigned_cost AS consigned_cost_36, t0.is_fragile AS is_fragile_37, t0.qty_per_unit AS qty_per_unit_38, t0.validated_by_distributor AS validated_by_distributor_39, t0.delivery_note AS delivery_note_40, t0.is_just_in_time AS is_just_in_time_41, t0.reminder_low_quantity_sent AS reminder_low_quantity_sent_42, t0.has_multiple_products AS has_multiple_products_43, t0.has_free_maturin_shipping AS has_free_maturin_shipping_44, t0.action_when_expired AS action_when_expired_45, t0.is_subscribable AS is_subscribable_46, t0.is_box_of_products AS is_box_of_products_47, t0.is_only_subscribable AS is_only_subscribable_48, t0.just_in_time_delivery_date AS just_in_time_delivery_date_49, t0.free_maturin_shipping_if_lower_then AS free_maturin_shipping_if_lower_then_50, t0.is_only_subscribable_to_type AS is_only_subscribable_to_type_51, t0.quantity_warehouse AS quantity_warehouse_52, t0.quantity_warehouse_reserved AS quantity_warehouse_reserved_53, t0.quantity_on_hold AS quantity_on_hold_54, t0.parent_product_id AS parent_product_id_55, t0.fee_warehouse_packing_per_unit AS fee_warehouse_packing_per_unit_56, t0.fee_warehouse_handling_per_unit AS fee_warehouse_handling_per_unit_57, t0.is_displayed_in_association_only AS is_displayed_in_association_only_58, t0.is_hri AS is_hri_59, t0.puro_exclusion AS puro_exclusion_60, t0.contains_alcohol AS contains_alcohol_61, t0.is_consumer AS is_consumer_62, t0.product_colabor_price AS product_colabor_price_63, t0.is_prix_laureat AS is_prix_laureat_64, t0.cant_use_coupon AS cant_use_coupon_65, t0.seasonality AS seasonality_66, t0.seasonality_start AS seasonality_start_67, t0.seasonality_end AS seasonality_end_68, t0.quantity_max_prod AS quantity_max_prod_69, t0.product_delete AS product_delete_70, t0.order_frequency AS order_frequency_71, t0.portion_for_meal AS portion_for_meal_72, t0.categories_id AS categories_id_73, t0.conservation_id AS conservation_id_74, t0.main_image_id AS main_image_id_75, t0.company_id AS company_id_76, t0.region_id AS region_id_77, t0.nutrition_fact_image_id AS nutrition_fact_image_id_78, t79.id AS id_80, t79.price_to_company AS price_to_company_81, t79.quantity AS quantity_82, t79.product_id AS product_id_83, t0.sub_category_id AS sub_category_id_84, t0.corporative_id AS corporative_id_85 FROM product t0 LEFT JOIN product_deal t79 ON t79.product_id = t0.id WHERE t0.id = '6499';
|
2.98 ms
(0.53%)
|
11 |
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 = 173 AND c0_.placement > 0 ORDER BY c0_.placement ASC;
|
2.87 ms
(0.51%)
|
11 |
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.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.id = 174;
|
2.62 ms
(0.46%)
|
4 |
SELECT p0_.id AS id_0, p0_.from_date AS from_date_1, p0_.to_date AS to_date_2, p0_.active AS active_3, p0_.is_in_modal AS is_in_modal_4, p0_.product_id AS product_id_5, p0_.custom_image_id AS custom_image_id_6 FROM product_sponsored p0_ WHERE p0_.active = 1 AND p0_.from_date <= ? AND p0_.to_date >= ? AND p0_.is_in_modal = 1 ORDER BY RAND() ASC LIMIT 15
Parameters: [
"2025-07-29 15:49:36"
"2025-07-29 15:49:36"
]
SELECT p0_.id AS id_0, p0_.from_date AS from_date_1, p0_.to_date AS to_date_2, p0_.active AS active_3, p0_.is_in_modal AS is_in_modal_4, p0_.product_id AS product_id_5, p0_.custom_image_id AS custom_image_id_6 FROM product_sponsored p0_ WHERE p0_.active = 1 AND p0_.from_date <= '2025-07-29 15:49:36' AND p0_.to_date >= '2025-07-29 15:49:36' AND p0_.is_in_modal = 1 ORDER BY RAND() ASC LIMIT 15;
|
1.21 ms
(0.21%)
|
2 |
SELECT te.id AS id, te.description AS description, te.display_order AS display_order, te.image AS image, te.category AS category, te.filename AS filename, te.mime AS mime, te.weight AS weight, te.height AS height, te.width AS width, te.folder AS folder, te.creation_date AS creation_date, te.last_updated AS last_updated, te.user_id AS user_id FROM image te JOIN image_product t ON t.image_id = te.id WHERE t.product_id = ? ORDER BY display_order ASC
SELECT te.id AS id, te.description AS description, te.display_order AS display_order, te.image AS image, te.category AS category, te.filename AS filename, te.mime AS mime, te.weight AS weight, te.height AS height, te.width AS width, te.folder AS folder, te.creation_date AS creation_date, te.last_updated AS last_updated, te.user_id AS user_id FROM image te JOIN image_product t ON t.image_id = te.id WHERE t.product_id = 6499 ORDER BY display_order ASC;
|
1.13 ms
(0.20%)
|
4 |
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.id = ? 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.id = 35 LIMIT 1;
|
0.80 ms
(0.14%)
|
1 |
SELECT c0_.id AS id_0, c0_.date_created AS date_created_1, c0_.quantity AS quantity_2, c0_.is_shipped AS is_shipped_3, c0_.price_paid_shipping AS price_paid_shipping_4, c0_.price_paid_product AS price_paid_product_5, c0_.has_combined_shipping AS has_combined_shipping_6, c0_.pricings_used AS pricings_used_7, c0_.carrier_name AS carrier_name_8, c0_.carrier_trackings AS carrier_trackings_9, c0_.for_invoicing_only AS for_invoicing_only_10, c0_.is_recurring_one_time_only AS is_recurring_one_time_only_11, c0_.recurring_frequency AS recurring_frequency_12, c0_.overwrite_subscription AS overwrite_subscription_13, c0_.qty_missing_in_shipment AS qty_missing_in_shipment_14, c0_.cart_id AS cart_id_15, c0_.product_id AS product_id_16, c0_.pricing_id AS pricing_id_17, c0_.company_delivery_method_id AS company_delivery_method_id_18, c0_.custom_order_id AS custom_order_id_19, c0_.maturin_order_id AS maturin_order_id_20, c0_.invoicing_cart_id AS invoicing_cart_id_21, c0_.added_when_being_in_association_id AS added_when_being_in_association_id_22 FROM cart_product c0_ INNER JOIN cart c1_ ON c0_.cart_id = c1_.id LEFT JOIN product p2_ ON c0_.product_id = p2_.id LEFT JOIN product p3_ ON c0_.product_id = p3_.id LEFT JOIN company c4_ ON p3_.company_id = c4_.id WHERE c0_.product_id = ? AND c1_.is_paid = 1 AND c1_.date_payment >= ? AND p3_.draft <> 1 AND p3_.main_image_id IS NOT NULL AND p3_.delivery_type = 0 AND p3_.available = 1 AND p3_.qty_ready_to_ship > 0 AND c4_.show_publicly = 1 ORDER BY RAND() ASC LIMIT 10
Parameters: [
6499
"2025-04-20 15:49:35"
]
SELECT c0_.id AS id_0, c0_.date_created AS date_created_1, c0_.quantity AS quantity_2, c0_.is_shipped AS is_shipped_3, c0_.price_paid_shipping AS price_paid_shipping_4, c0_.price_paid_product AS price_paid_product_5, c0_.has_combined_shipping AS has_combined_shipping_6, c0_.pricings_used AS pricings_used_7, c0_.carrier_name AS carrier_name_8, c0_.carrier_trackings AS carrier_trackings_9, c0_.for_invoicing_only AS for_invoicing_only_10, c0_.is_recurring_one_time_only AS is_recurring_one_time_only_11, c0_.recurring_frequency AS recurring_frequency_12, c0_.overwrite_subscription AS overwrite_subscription_13, c0_.qty_missing_in_shipment AS qty_missing_in_shipment_14, c0_.cart_id AS cart_id_15, c0_.product_id AS product_id_16, c0_.pricing_id AS pricing_id_17, c0_.company_delivery_method_id AS company_delivery_method_id_18, c0_.custom_order_id AS custom_order_id_19, c0_.maturin_order_id AS maturin_order_id_20, c0_.invoicing_cart_id AS invoicing_cart_id_21, c0_.added_when_being_in_association_id AS added_when_being_in_association_id_22 FROM cart_product c0_ INNER JOIN cart c1_ ON c0_.cart_id = c1_.id LEFT JOIN product p2_ ON c0_.product_id = p2_.id LEFT JOIN product p3_ ON c0_.product_id = p3_.id LEFT JOIN company c4_ ON p3_.company_id = c4_.id WHERE c0_.product_id = 6499 AND c1_.is_paid = 1 AND c1_.date_payment >= '2025-04-20 15:49:35' AND p3_.draft <> 1 AND p3_.main_image_id IS NOT NULL AND p3_.delivery_type = 0 AND p3_.available = 1 AND p3_.qty_ready_to_ship > 0 AND c4_.show_publicly = 1 ORDER BY RAND() ASC LIMIT 10;
|
0.70 ms
(0.12%)
|
1 |
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.categories_id = ? ORDER BY t0.qty_ready_to_ship DESC
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.categories_id = ?
ORDER BY
t0.qty_ready_to_ship DESC
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.categories_id = 174 ORDER BY t0.qty_ready_to_ship DESC;
|
0.66 ms
(0.12%)
|
2 |
SELECT t0.id AS id_1, t0.average_days AS average_days_2, t0.first_item AS first_item_3, t0.additional_item AS additional_item_4, t0.service_id AS service_id_5, t0.valid AS valid_6, t0.free_above_atotal_of AS free_above_atotal_of_7, t0.fixed_price AS fixed_price_8, t0.pickup_schedule AS pickup_schedule_9, t0.pickup_address AS pickup_address_10, t0.is_apickup AS is_apickup_11, t0.pickup_location_id AS pickup_location_id_12, t0.with_packing AS with_packing_13, t0.product_id AS product_id_14, t0.company_default_shipping_id AS company_default_shipping_id_15 FROM delivery_method t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.average_days AS average_days_2, t0.first_item AS first_item_3, t0.additional_item AS additional_item_4, t0.service_id AS service_id_5, t0.valid AS valid_6, t0.free_above_atotal_of AS free_above_atotal_of_7, t0.fixed_price AS fixed_price_8, t0.pickup_schedule AS pickup_schedule_9, t0.pickup_address AS pickup_address_10, t0.is_apickup AS is_apickup_11, t0.pickup_location_id AS pickup_location_id_12, t0.with_packing AS with_packing_13, t0.product_id AS product_id_14, t0.company_default_shipping_id AS company_default_shipping_id_15 FROM delivery_method t0 WHERE t0.product_id = 2722;
|
0.62 ms
(0.11%)
|
1 |
SELECT t0.id AS id_1, t0.url AS url_2, t0.lang AS lang_3, t0.javascript AS javascript_4, t0.stylesheet AS stylesheet_5, t0.template AS template_6, t0.content AS content_7, t0.main_content AS main_content_8, t0.meta_title AS meta_title_9, t0.meta_description AS meta_description_10 FROM omelo_page t0 WHERE t0.template = ?
Parameters: [
"footer.html.twig"
]
SELECT t0.id AS id_1, t0.url AS url_2, t0.lang AS lang_3, t0.javascript AS javascript_4, t0.stylesheet AS stylesheet_5, t0.template AS template_6, t0.content AS content_7, t0.main_content AS main_content_8, t0.meta_title AS meta_title_9, t0.meta_description AS meta_description_10 FROM omelo_page t0 WHERE t0.template = 'footer.html.twig';
|
0.56 ms
(0.10%)
|
2 |
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.price_to_company AS price_to_company_3, t0.quantity AS quantity_4, t0.product_id AS product_id_5, t0.product_representing_box_id AS product_representing_box_id_6 FROM product_in_box t0 WHERE t0.product_representing_box_id = ?
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.price_to_company AS price_to_company_3, t0.quantity AS quantity_4, t0.product_id AS product_id_5, t0.product_representing_box_id AS product_representing_box_id_6 FROM product_in_box t0 WHERE t0.product_representing_box_id = 7750;
|
0.52 ms
(0.09%)
|
1 |
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.stripe_token AS stripe_token_3, t0.stripe_response AS stripe_response_4, t0.is_paid AS is_paid_5, t0.solex_order_id AS solex_order_id_6, t0.date_payment AS date_payment_7, t0.shipping_estimation_raw AS shipping_estimation_raw_8, t0.shipping_maturin_cost AS shipping_maturin_cost_9, t0.shipping_maturin_carrier_name AS shipping_maturin_carrier_name_10, t0.shipping_maturin_service_name AS shipping_maturin_service_name_11, t0.shipping_maturin_estimated_date AS shipping_maturin_estimated_date_12, t0.picking_and_packing_fee AS picking_and_packing_fee_13, t0.payment_fee AS payment_fee_14, t0.maturin_fee AS maturin_fee_15, t0.taxes_products AS taxes_products_16, t0.taxes_maturin AS taxes_maturin_17, t0.taxes_shipping_maturin AS taxes_shipping_maturin_18, t0.taxes_shipping_company AS taxes_shipping_company_19, t0.taxes_packing AS taxes_packing_20, t0.shipping_maturin_service_id AS shipping_maturin_service_id_21, t0.solex_order_raw AS solex_order_raw_22, t0.maturin_tracking_info AS maturin_tracking_info_23, t0.order_no AS order_no_24, t0.is_on_hold AS is_on_hold_25, t0.just_in_time_email_sent AS just_in_time_email_sent_26, t0.reminder_sent AS reminder_sent_27, t0.raw_distributor_billing AS raw_distributor_billing_28, t0.taxes_products_calculations AS taxes_products_calculations_29, t0.taxes_shipping_maturin_calculations AS taxes_shipping_maturin_calculations_30, t0.taxes_shipping_company_calculations AS taxes_shipping_company_calculations_31, t0.taxes_packing_calculations AS taxes_packing_calculations_32, t0.amount_saved_by_coupon AS amount_saved_by_coupon_33, t0.shipping_signature_required AS shipping_signature_required_34, t0.signature_mandatory AS signature_mandatory_35, t0.extra_priority_points AS extra_priority_points_36, t0.warehouse_group_id AS warehouse_group_id_37, t0.is_refunded AS is_refunded_38, t0.refund_stripe_response AS refund_stripe_response_39, t0.note_from_buyer AS note_from_buyer_40, t0.is_bulk_order AS is_bulk_order_41, t0.track_link AS track_link_42, t0.track_pod_status_id AS track_pod_status_id_43, t0.delivery_choice_date AS delivery_choice_date_44, t0.pre_order AS pre_order_45, t0.pre_order_now AS pre_order_now_46, t0.shipping_address_id AS shipping_address_id_47, t0.user_id AS user_id_48, t0.used_coupon_id AS used_coupon_id_49, t0.logistic_invoice_id AS logistic_invoice_id_50, t0.send_with_subscription_id AS send_with_subscription_id_51, t0.from_subscription_id AS from_subscription_id_52 FROM cart t0 WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.date_created AS date_created_2,
t0.stripe_token AS stripe_token_3,
t0.stripe_response AS stripe_response_4,
t0.is_paid AS is_paid_5,
t0.solex_order_id AS solex_order_id_6,
t0.date_payment AS date_payment_7,
t0.shipping_estimation_raw AS shipping_estimation_raw_8,
t0.shipping_maturin_cost AS shipping_maturin_cost_9,
t0.shipping_maturin_carrier_name AS shipping_maturin_carrier_name_10,
t0.shipping_maturin_service_name AS shipping_maturin_service_name_11,
t0.shipping_maturin_estimated_date AS shipping_maturin_estimated_date_12,
t0.picking_and_packing_fee AS picking_and_packing_fee_13,
t0.payment_fee AS payment_fee_14,
t0.maturin_fee AS maturin_fee_15,
t0.taxes_products AS taxes_products_16,
t0.taxes_maturin AS taxes_maturin_17,
t0.taxes_shipping_maturin AS taxes_shipping_maturin_18,
t0.taxes_shipping_company AS taxes_shipping_company_19,
t0.taxes_packing AS taxes_packing_20,
t0.shipping_maturin_service_id AS shipping_maturin_service_id_21,
t0.solex_order_raw AS solex_order_raw_22,
t0.maturin_tracking_info AS maturin_tracking_info_23,
t0.order_no AS order_no_24,
t0.is_on_hold AS is_on_hold_25,
t0.just_in_time_email_sent AS just_in_time_email_sent_26,
t0.reminder_sent AS reminder_sent_27,
t0.raw_distributor_billing AS raw_distributor_billing_28,
t0.taxes_products_calculations AS taxes_products_calculations_29,
t0.taxes_shipping_maturin_calculations AS taxes_shipping_maturin_calculations_30,
t0.taxes_shipping_company_calculations AS taxes_shipping_company_calculations_31,
t0.taxes_packing_calculations AS taxes_packing_calculations_32,
t0.amount_saved_by_coupon AS amount_saved_by_coupon_33,
t0.shipping_signature_required AS shipping_signature_required_34,
t0.signature_mandatory AS signature_mandatory_35,
t0.extra_priority_points AS extra_priority_points_36,
t0.warehouse_group_id AS warehouse_group_id_37,
t0.is_refunded AS is_refunded_38,
t0.refund_stripe_response AS refund_stripe_response_39,
t0.note_from_buyer AS note_from_buyer_40,
t0.is_bulk_order AS is_bulk_order_41,
t0.track_link AS track_link_42,
t0.track_pod_status_id AS track_pod_status_id_43,
t0.delivery_choice_date AS delivery_choice_date_44,
t0.pre_order AS pre_order_45,
t0.pre_order_now AS pre_order_now_46,
t0.shipping_address_id AS shipping_address_id_47,
t0.user_id AS user_id_48,
t0.used_coupon_id AS used_coupon_id_49,
t0.logistic_invoice_id AS logistic_invoice_id_50,
t0.send_with_subscription_id AS send_with_subscription_id_51,
t0.from_subscription_id AS from_subscription_id_52
FROM
cart t0
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.stripe_token AS stripe_token_3, t0.stripe_response AS stripe_response_4, t0.is_paid AS is_paid_5, t0.solex_order_id AS solex_order_id_6, t0.date_payment AS date_payment_7, t0.shipping_estimation_raw AS shipping_estimation_raw_8, t0.shipping_maturin_cost AS shipping_maturin_cost_9, t0.shipping_maturin_carrier_name AS shipping_maturin_carrier_name_10, t0.shipping_maturin_service_name AS shipping_maturin_service_name_11, t0.shipping_maturin_estimated_date AS shipping_maturin_estimated_date_12, t0.picking_and_packing_fee AS picking_and_packing_fee_13, t0.payment_fee AS payment_fee_14, t0.maturin_fee AS maturin_fee_15, t0.taxes_products AS taxes_products_16, t0.taxes_maturin AS taxes_maturin_17, t0.taxes_shipping_maturin AS taxes_shipping_maturin_18, t0.taxes_shipping_company AS taxes_shipping_company_19, t0.taxes_packing AS taxes_packing_20, t0.shipping_maturin_service_id AS shipping_maturin_service_id_21, t0.solex_order_raw AS solex_order_raw_22, t0.maturin_tracking_info AS maturin_tracking_info_23, t0.order_no AS order_no_24, t0.is_on_hold AS is_on_hold_25, t0.just_in_time_email_sent AS just_in_time_email_sent_26, t0.reminder_sent AS reminder_sent_27, t0.raw_distributor_billing AS raw_distributor_billing_28, t0.taxes_products_calculations AS taxes_products_calculations_29, t0.taxes_shipping_maturin_calculations AS taxes_shipping_maturin_calculations_30, t0.taxes_shipping_company_calculations AS taxes_shipping_company_calculations_31, t0.taxes_packing_calculations AS taxes_packing_calculations_32, t0.amount_saved_by_coupon AS amount_saved_by_coupon_33, t0.shipping_signature_required AS shipping_signature_required_34, t0.signature_mandatory AS signature_mandatory_35, t0.extra_priority_points AS extra_priority_points_36, t0.warehouse_group_id AS warehouse_group_id_37, t0.is_refunded AS is_refunded_38, t0.refund_stripe_response AS refund_stripe_response_39, t0.note_from_buyer AS note_from_buyer_40, t0.is_bulk_order AS is_bulk_order_41, t0.track_link AS track_link_42, t0.track_pod_status_id AS track_pod_status_id_43, t0.delivery_choice_date AS delivery_choice_date_44, t0.pre_order AS pre_order_45, t0.pre_order_now AS pre_order_now_46, t0.shipping_address_id AS shipping_address_id_47, t0.user_id AS user_id_48, t0.used_coupon_id AS used_coupon_id_49, t0.logistic_invoice_id AS logistic_invoice_id_50, t0.send_with_subscription_id AS send_with_subscription_id_51, t0.from_subscription_id AS from_subscription_id_52 FROM cart t0 WHERE t0.id = 15927523;
|
0.51 ms
(0.09%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.delay AS delay_4, t0.monday AS monday_5, t0.tuesday AS tuesday_6, t0.wednesday AS wednesday_7, t0.thursday AS thursday_8, t0.friday AS friday_9, t0.saturday AS saturday_10, t0.sunday AS sunday_11, t0.is_fallback AS is_fallback_12, t0.dry_allowed AS dry_allowed_13, t0.refrigerated_allowed AS refrigerated_allowed_14, t0.frozen_allowed AS frozen_allowed_15, t0.delivery_price AS delivery_price_16 FROM delivery_route t0 WHERE t0.type = ? LIMIT 1
Parameters: [
"purolator frais"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.delay AS delay_4, t0.monday AS monday_5, t0.tuesday AS tuesday_6, t0.wednesday AS wednesday_7, t0.thursday AS thursday_8, t0.friday AS friday_9, t0.saturday AS saturday_10, t0.sunday AS sunday_11, t0.is_fallback AS is_fallback_12, t0.dry_allowed AS dry_allowed_13, t0.refrigerated_allowed AS refrigerated_allowed_14, t0.frozen_allowed AS frozen_allowed_15, t0.delivery_price AS delivery_price_16 FROM delivery_route t0 WHERE t0.type = 'purolator frais' LIMIT 1;
|
0.48 ms
(0.08%)
|
1 |
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';
|
0.46 ms
(0.08%)
|
1 |
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.quantity AS quantity_3, t0.is_shipped AS is_shipped_4, t0.price_paid_shipping AS price_paid_shipping_5, t0.price_paid_product AS price_paid_product_6, t0.has_combined_shipping AS has_combined_shipping_7, t0.pricings_used AS pricings_used_8, t0.carrier_name AS carrier_name_9, t0.carrier_trackings AS carrier_trackings_10, t0.for_invoicing_only AS for_invoicing_only_11, t0.is_recurring_one_time_only AS is_recurring_one_time_only_12, t0.recurring_frequency AS recurring_frequency_13, t0.overwrite_subscription AS overwrite_subscription_14, t0.qty_missing_in_shipment AS qty_missing_in_shipment_15, t0.cart_id AS cart_id_16, t0.product_id AS product_id_17, t0.pricing_id AS pricing_id_18, t0.company_delivery_method_id AS company_delivery_method_id_19, t0.custom_order_id AS custom_order_id_20, t0.maturin_order_id AS maturin_order_id_21, t0.invoicing_cart_id AS invoicing_cart_id_22, t0.added_when_being_in_association_id AS added_when_being_in_association_id_23 FROM cart_product t0 WHERE t0.cart_id = ?
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.quantity AS quantity_3, t0.is_shipped AS is_shipped_4, t0.price_paid_shipping AS price_paid_shipping_5, t0.price_paid_product AS price_paid_product_6, t0.has_combined_shipping AS has_combined_shipping_7, t0.pricings_used AS pricings_used_8, t0.carrier_name AS carrier_name_9, t0.carrier_trackings AS carrier_trackings_10, t0.for_invoicing_only AS for_invoicing_only_11, t0.is_recurring_one_time_only AS is_recurring_one_time_only_12, t0.recurring_frequency AS recurring_frequency_13, t0.overwrite_subscription AS overwrite_subscription_14, t0.qty_missing_in_shipment AS qty_missing_in_shipment_15, t0.cart_id AS cart_id_16, t0.product_id AS product_id_17, t0.pricing_id AS pricing_id_18, t0.company_delivery_method_id AS company_delivery_method_id_19, t0.custom_order_id AS custom_order_id_20, t0.maturin_order_id AS maturin_order_id_21, t0.invoicing_cart_id AS invoicing_cart_id_22, t0.added_when_being_in_association_id AS added_when_being_in_association_id_23 FROM cart_product t0 WHERE t0.cart_id = 15927523;
|
0.37 ms
(0.07%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM suggested_group t0 INNER JOIN suggested_group_product ON t0.id = suggested_group_product.suggested_group_id WHERE suggested_group_product.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM suggested_group t0 INNER JOIN suggested_group_product ON t0.id = suggested_group_product.suggested_group_id WHERE suggested_group_product.product_id = 6499;
|
0.21 ms
(0.04%)
|
1 |
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;
|