Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2237 Database Queries

23 Different statements

1165.14 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
609.52 ms (52.31%)	1101	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 = ? Parameters: [`7739`] View formatted query View runnable query Explain query 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 = 7739;
266.30 ms (22.86%)	428	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 ]`] View formatted query View runnable query Explain query SELECT count(p0_.id) AS sclr_0 FROM product p0_ WHERE ( p0_.categories_id IN (?) OR p0_.sub_category_id IN (?) ) AND p0_.draft <> 1 AND p0_.available = 1 AND p0_.main_image_id IS NOT NULL SELECT count(p0_.id) AS sclr_0 FROM product p0_ WHERE (p0_.categories_id IN (355) OR p0_.sub_category_id IN (355, 0)) AND p0_.draft <> 1 AND p0_.available = 1 AND p0_.main_image_id IS NOT NULL;
130.42 ms (11.19%)	515	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 = ? Parameters: [`7739`] View formatted query View runnable query Explain query 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 = 7739;
40.63 ms (3.49%)	21	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: [`45 45 [ 80 ]`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, c1_.id AS id_1, ( SELECT COUNT() FROM cart_product c2_ WHERE c2_.product_id = p0_.id ) AS sclr_2, c3_.id AS id_3, c3_.placement AS placement_4, c3_.name AS name_5, c4_.placement AS placement_6, c4_.name AS name_7 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id LEFT JOIN category c3_ ON p0_.sub_category_id = c3_.id LEFT JOIN category c4_ ON c3_.sub_category_id = c4_.id LEFT JOIN pricing_product p6_ ON p0_.id = p6_.product_id LEFT JOIN pricing p5_ ON p5_.id = p6_.pricing_id WHERE ( p0_.categories_id = ? OR p0_.sub_category_id = ? OR p0_.sub_category_id IN (?) ) AND p0_.draft <> 1 AND p0_.main_image_id IS NOT NULL AND p0_.available = 1 AND p0_.is_displayed_in_association_only = 0 AND c3_.placement > 0 AND c4_.placement > 0 AND p0_.is_hri = 0 AND p0_.is_consumer = 1 AND c1_.show_publicly = 1 AND p0_.qty_ready_to_ship > 0 ORDER BY c3_.placement ASC SELECT p0_.id AS id_0, c1_.id AS id_1, (SELECT COUNT(*) FROM cart_product c2_ WHERE c2_.product_id = p0_.id) AS sclr_2, c3_.id AS id_3, c3_.placement AS placement_4, c3_.name AS name_5, c4_.placement AS placement_6, c4_.name AS name_7 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id LEFT JOIN category c3_ ON p0_.sub_category_id = c3_.id LEFT JOIN category c4_ ON c3_.sub_category_id = c4_.id LEFT JOIN pricing_product p6_ ON p0_.id = p6_.product_id LEFT JOIN pricing p5_ ON p5_.id = p6_.pricing_id WHERE (p0_.categories_id = 45 OR p0_.sub_category_id = 45 OR p0_.sub_category_id IN (80)) 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;
27.90 ms (2.39%)	3	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 Parameters: [] View formatted query View runnable query Explain query 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;
25.74 ms (2.21%)	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 p0_.creation_date DESC Parameters: [`33 33 [ 45 81 82 83 84 86 313 315 317 320 324 339 ]`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, c1_.id AS id_1, ( SELECT COUNT() FROM cart_product c2_ WHERE c2_.product_id = p0_.id ) AS sclr_2, c3_.id AS id_3, c3_.placement AS placement_4, c3_.name AS name_5, c4_.placement AS placement_6, c4_.name AS name_7 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id LEFT JOIN category c3_ ON p0_.sub_category_id = c3_.id LEFT JOIN category c4_ ON c3_.sub_category_id = c4_.id LEFT JOIN pricing_product p6_ ON p0_.id = p6_.product_id LEFT JOIN pricing p5_ ON p5_.id = p6_.pricing_id WHERE ( p0_.categories_id = ? OR p0_.sub_category_id = ? OR p0_.sub_category_id IN (?) ) AND p0_.draft <> 1 AND p0_.main_image_id IS NOT NULL AND p0_.available = 1 AND p0_.is_displayed_in_association_only = 0 AND c3_.placement > 0 AND c4_.placement > 0 AND p0_.is_hri = 0 AND p0_.is_consumer = 1 AND c1_.show_publicly = 1 AND p0_.qty_ready_to_ship > 0 ORDER BY p0_.creation_date DESC SELECT p0_.id AS id_0, c1_.id AS id_1, (SELECT COUNT(*) FROM cart_product c2_ WHERE c2_.product_id = p0_.id) AS sclr_2, c3_.id AS id_3, c3_.placement AS placement_4, c3_.name AS name_5, c4_.placement AS placement_6, c4_.name AS name_7 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id LEFT JOIN category c3_ ON p0_.sub_category_id = c3_.id LEFT JOIN category c4_ ON c3_.sub_category_id = c4_.id LEFT JOIN pricing_product p6_ ON p0_.id = p6_.product_id LEFT JOIN pricing p5_ ON p5_.id = p6_.pricing_id WHERE (p0_.categories_id = 33 OR p0_.sub_category_id = 33 OR p0_.sub_category_id IN (45, 81, 82, 83, 84, 86, 313, 315, 317, 320, 324, 339)) AND p0_.draft <> 1 AND p0_.main_image_id IS NOT NULL AND p0_.available = 1 AND p0_.is_displayed_in_association_only = 0 AND c3_.placement > 0 AND c4_.placement > 0 AND p0_.is_hri = 0 AND p0_.is_consumer = 1 AND c1_.show_publicly = 1 AND p0_.qty_ready_to_ship > 0 ORDER BY p0_.creation_date DESC;
15.27 ms (1.31%)	24	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 = ? Parameters: [`26516`] View formatted query View runnable query Explain query 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 = 26516;
7.62 ms (0.65%)	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 = ? Parameters: [`262`] View formatted query View runnable query Explain query 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 = 262;
7.55 ms (0.65%)	24	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 = ? Parameters: [`1849`] View formatted query View runnable query Explain query 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 = 1849;
7.26 ms (0.62%)	24	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 = ? Parameters: [`1849`] View formatted query View runnable query Explain query 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 = 1849;
7.24 ms (0.62%)	24	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 = ? Parameters: [`1849`] View formatted query View runnable query Explain query 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 = 1849;
6.09 ms (0.52%)	23	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 = ? Parameters: [`33`] View formatted query View runnable query Explain query 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 = 33;
5.41 ms (0.46%)	24	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 = ? Parameters: [`5782`] View formatted query View runnable query Explain query 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 = 5782;
2.26 ms (0.19%)	1	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
1.19 ms (0.10%)	2	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-09-23 04:04:54" "2025-09-23 04:04:54"`] View formatted query View runnable query Explain query 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 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-09-23 04:04:54' AND p0_.to_date >= '2025-09-23 04:04:54' AND p0_.is_in_modal = 1 ORDER BY RAND() ASC LIMIT 15;
0.91 ms (0.08%)	3	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 = ? Parameters: [`1489`] View formatted query View runnable query Explain query 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 = 1489;
0.90 ms (0.08%)	1	INSERT INTO cart (date_created, stripe_token, stripe_response, is_paid, solex_order_id, date_payment, shipping_estimation_raw, shipping_maturin_cost, shipping_maturin_carrier_name, shipping_maturin_service_name, shipping_maturin_estimated_date, picking_and_packing_fee, payment_fee, maturin_fee, taxes_products, taxes_maturin, taxes_shipping_maturin, taxes_shipping_company, taxes_packing, shipping_maturin_service_id, solex_order_raw, maturin_tracking_info, order_no, is_on_hold, just_in_time_email_sent, reminder_sent, raw_distributor_billing, taxes_products_calculations, taxes_shipping_maturin_calculations, taxes_shipping_company_calculations, taxes_packing_calculations, amount_saved_by_coupon, shipping_signature_required, signature_mandatory, extra_priority_points, warehouse_group_id, is_refunded, refund_stripe_response, note_from_buyer, is_bulk_order, track_link, track_pod_status_id, delivery_choice_date, pre_order, pre_order_now, shipping_address_id, user_id, used_coupon_id, logistic_invoice_id, send_with_subscription_id, from_subscription_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [1 => "2025-09-23 04:04:53" 2 => null 3 => null 4 => 0 5 => null 6 => null 7 => null 8 => null 9 => null 10 => null 11 => null 12 => 0 13 => 0 14 => 0 15 => 0 16 => 0 17 => 0 18 => 0 19 => 0 20 => null 21 => null 22 => "a:0:{}" 23 => null 24 => 0 25 => 0 26 => 0 27 => "N;" 28 => "a:0:{}" 29 => "a:0:{}" 30 => "a:0:{}" 31 => "a:0:{}" 32 => 0 33 => 0 34 => 0 35 => 0 36 => null 37 => 0 38 => "N;" 39 => null 40 => 0 41 => null 42 => null 43 => null 44 => null 45 => null 46 => null 47 => null 48 => null 49 => null 50 => null 51 => null] View formatted query View runnable query Explain query INSERT INTO cart ( date_created, stripe_token, stripe_response, is_paid, solex_order_id, date_payment, shipping_estimation_raw, shipping_maturin_cost, shipping_maturin_carrier_name, shipping_maturin_service_name, shipping_maturin_estimated_date, picking_and_packing_fee, payment_fee, maturin_fee, taxes_products, taxes_maturin, taxes_shipping_maturin, taxes_shipping_company, taxes_packing, shipping_maturin_service_id, solex_order_raw, maturin_tracking_info, order_no, is_on_hold, just_in_time_email_sent, reminder_sent, raw_distributor_billing, taxes_products_calculations, taxes_shipping_maturin_calculations, taxes_shipping_company_calculations, taxes_packing_calculations, amount_saved_by_coupon, shipping_signature_required, signature_mandatory, extra_priority_points, warehouse_group_id, is_refunded, refund_stripe_response, note_from_buyer, is_bulk_order, track_link, track_pod_status_id, delivery_choice_date, pre_order, pre_order_now, shipping_address_id, user_id, used_coupon_id, logistic_invoice_id, send_with_subscription_id, from_subscription_id ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) INSERT INTO cart (date_created, stripe_token, stripe_response, is_paid, solex_order_id, date_payment, shipping_estimation_raw, shipping_maturin_cost, shipping_maturin_carrier_name, shipping_maturin_service_name, shipping_maturin_estimated_date, picking_and_packing_fee, payment_fee, maturin_fee, taxes_products, taxes_maturin, taxes_shipping_maturin, taxes_shipping_company, taxes_packing, shipping_maturin_service_id, solex_order_raw, maturin_tracking_info, order_no, is_on_hold, just_in_time_email_sent, reminder_sent, raw_distributor_billing, taxes_products_calculations, taxes_shipping_maturin_calculations, taxes_shipping_company_calculations, taxes_packing_calculations, amount_saved_by_coupon, shipping_signature_required, signature_mandatory, extra_priority_points, warehouse_group_id, is_refunded, refund_stripe_response, note_from_buyer, is_bulk_order, track_link, track_pod_status_id, delivery_choice_date, pre_order, pre_order_now, shipping_address_id, user_id, used_coupon_id, logistic_invoice_id, send_with_subscription_id, from_subscription_id) VALUES ('2025-09-23 04:04:53', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 'a:0:{}', NULL, 0, 0, 0, 'N;', 'a:0:{}', 'a:0:{}', 'a:0:{}', 'a:0:{}', 0, 0, 0, 0, NULL, 0, 'N;', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
0.86 ms (0.07%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"epicerie"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.name = 'epicerie' LIMIT 1;
0.64 ms (0.05%)	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"`] View formatted query View runnable query Explain query 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 = ? 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.47 ms (0.04%)	1	SELECT c0_.id AS id_0, c0_.placement AS placement_1, c0_.name AS name_2 FROM category c0_ WHERE c0_.sub_category_id = ? AND c0_.placement > 0 ORDER BY c0_.placement ASC Parameters: [`33`] View formatted query View runnable query Explain query 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 = 33 AND c0_.placement > 0 ORDER BY c0_.placement ASC;
0.35 ms (0.03%)	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 = ? Parameters: [`"Qc"`] View formatted query View runnable query Explain query 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.32 ms (0.03%)	1	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
0.27 ms (0.02%)	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 Parameters: [] View formatted query View runnable query Explain query 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;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Product	No errors.
App\Entity\Image	No errors.
App\Entity\Notification	No errors.
App\Entity\Message	No errors.
App\Entity\Cart	No errors.
App\Entity\Category	No errors.
App\Entity\Conservation	No errors.
App\Entity\Tag	No errors.
App\Entity\Ingredient	No errors.
App\Entity\Storage	No errors.
App\Entity\Pricing	No errors.
App\Entity\Certification	No errors.
App\Entity\Company	No errors.
App\Entity\DeliveryLocation	No errors.
App\Entity\DeliveryMethod	No errors.
App\Entity\CompanyLocation	No errors.
App\Entity\Region	No errors.
App\Entity\UserViewedProduct	No errors.
App\Entity\CartProduct	No errors.
App\Entity\ProductReplenishmentItem	No errors.
App\Entity\UserFavorite	No errors.
App\Entity\ProductDeal	No errors.
App\Entity\Badge	No errors.
App\Entity\Diet	No errors.
App\Entity\SuggestedGroup	No errors.
App\Entity\Subscription	No errors.
App\Entity\ProductInBox	No errors.
App\Entity\ProductReplacementScript	No errors.
App\Entity\Corporative	No errors.
App\Entity\City	No errors.
App\Entity\FinancialLog	No errors.
App\Entity\CustomOrder	No errors.
App\Entity\MaturinOrder	No errors.
App\Entity\RecurringOrder	No errors.
App\Entity\UserShippingLocation	No errors.
App\Entity\CartCoupon	No errors.
App\Entity\Invoice	No errors.
App\Entity\CompanyAssociation	No errors.
App\Entity\CompanyDeposit	No errors.
App\Entity\CompanyDefaultShipping	No errors.
App\Entity\CompanyPayment	No errors.
App\Entity\CompanySubscription	No errors.
App\Entity\ProductReplenishment	No errors.
App\Entity\InvoiceService	No errors.
App\Entity\Variable	No errors.
App\Entity\OmeloPage	No errors.
App\Entity\ProductSponsored	No errors.

Symfony Profiler

https://staging.maturin.ca/categorie/epicerie?id=2099&order=desc&page=15&producerUrl=miel-morand&productName=miel-de-trefle-500g&sorting=date&url=produit%2Fmiel-morand%2Fmiel-de-trefle-500g%2F2099%2F

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping