https://staging.maturin.ca/api/search/product/valid?term=grillons&url=api%2Fsearch%2Fproduct%2Fvalid

Method
GET
HTTP Status
200
IP
107.171.183.131
Profiled on
Token
371574

Query Metrics

21 Database Queries
5 Different statements
242.07 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 164.66 ms 
SELECT DISTINCT product.id, product.company_id, product.orig_name,

      IF (product.orig_name LIKE ?, 20, IF (product.orig_brand_name LIKE ?, 10, 0))
  		+ IF (product.orig_brand_name LIKE ?, 10, 0)
  		+ IF (company.name LIKE ?, 5, 0)
  		+ IF (tag.name LIKE ?, 5, 0)
  		AS weight,

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

      FROM product

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

      WHERE (
        product.orig_name LIKE ?
        OR product.orig_brand_name LIKE ?
        OR product.orig_description LIKE ?
        OR product.list_of_ingredients LIKE ?
        OR company.name LIKE ?
        OR tag.name LIKE ?
      ) AND (
        product.draft != 1
        AND product.available > 0
        AND product.is_hri = 0
        AND product.is_displayed_in_association_only = 0
        AND product.main_image_id IS NOT NULL
        AND company.show_publicly = 1
      ) AND
      (
        (
          product.qty_ready_to_ship > 0
          AND product.delivery_type = 0
        ) OR (
          product.delivery_type != 0
        )
      )

      ORDER BY ( `weight` + `total_cart` ) DESC
Parameters: 
[
  1 => "%grillons%"
  2 => "%grillons%"
  3 => "%grillons%"
  4 => "%grillons%"
  5 => "%grillons%"
  6 => "%grillons%"
  7 => "%grillons%"
  8 => "%grillons%"
  9 => "%grillons%"
  10 => "%grillons%"
  11 => "%grillons%"
]
View formatted query    View runnable query    Explain query
2 4.54 ms 
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: 
[
  "830"
]
View formatted query    View runnable query    Explain query
3 18.06 ms 
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: 
[
  830
]
View formatted query    View runnable query    Explain query
4 7.41 ms 
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: 
[
  "187"
]
View formatted query    View runnable query    Explain query
5 3.91 ms 
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: 
[
  187
]
View formatted query    View runnable query    Explain query
6 3.34 ms 
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: 
[
  "828"
]
View formatted query    View runnable query    Explain query
7 1.15 ms 
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: 
[
  828
]
View formatted query    View runnable query    Explain query
8 6.40 ms 
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: 
[
  "829"
]
View formatted query    View runnable query    Explain query
9 3.32 ms 
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: 
[
  829
]
View formatted query    View runnable query    Explain query
10 3.90 ms 
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: 
[
  "1793"
]
View formatted query    View runnable query    Explain query
11 0.49 ms 
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: 
[
  1793
]
View formatted query    View runnable query    Explain query
12 0.63 ms 
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: 
[
  "2820"
]
View formatted query    View runnable query    Explain query
13 0.25 ms 
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: 
[
  2820
]
View formatted query    View runnable query    Explain query
14 0.63 ms 
SELECT t0.id AS id_1, t0.orig_name AS orig_name_2, t0.orig_brand_name AS orig_brand_name_3, t0.qty_left AS qty_left_4, t0.unit_amount AS unit_amount_5, t0.unit AS unit_6, t0.available AS available_7, t0.orig_description AS orig_description_8, t0.origin AS origin_9, t0.best_before AS best_before_10, t0.creation_date AS creation_date_11, t0.nutrition_fact AS nutrition_fact_12, t0.new_product AS new_product_13, t0.taxable AS taxable_14, t0.maturin_upc AS maturin_upc_15, t0.code_upc AS code_upc_16, t0.code1 AS code1_17, t0.code2 AS code2_18, t0.code3 AS code3_19, t0.code_box AS code_box_20, t0.aliments_du_quebec AS aliments_du_quebec_21, t0.minimum_in_storage AS minimum_in_storage_22, t0.limited_quantity AS limited_quantity_23, t0.aliments_du_quebec_certification AS aliments_du_quebec_certification_24, t0.delivery_type AS delivery_type_25, t0.delivery_pickup AS delivery_pickup_26, t0.draft AS draft_27, t0.delivery_mail AS delivery_mail_28, t0.advices AS advices_29, t0.recipes AS recipes_30, t0.solex_id AS solex_id_31, t0.list_of_ingredients AS list_of_ingredients_32, t0.qty_ready_to_ship AS qty_ready_to_ship_33, t0.expiration_date AS expiration_date_34, t0.is_consigned AS is_consigned_35, t0.consigned_cost AS consigned_cost_36, t0.is_fragile AS is_fragile_37, t0.qty_per_unit AS qty_per_unit_38, t0.validated_by_distributor AS validated_by_distributor_39, t0.delivery_note AS delivery_note_40, t0.is_just_in_time AS is_just_in_time_41, t0.reminder_low_quantity_sent AS reminder_low_quantity_sent_42, t0.has_multiple_products AS has_multiple_products_43, t0.has_free_maturin_shipping AS has_free_maturin_shipping_44, t0.action_when_expired AS action_when_expired_45, t0.is_subscribable AS is_subscribable_46, t0.is_box_of_products AS is_box_of_products_47, t0.is_only_subscribable AS is_only_subscribable_48, t0.just_in_time_delivery_date AS just_in_time_delivery_date_49, t0.free_maturin_shipping_if_lower_then AS free_maturin_shipping_if_lower_then_50, t0.is_only_subscribable_to_type AS is_only_subscribable_to_type_51, t0.quantity_warehouse AS quantity_warehouse_52, t0.quantity_warehouse_reserved AS quantity_warehouse_reserved_53, t0.quantity_on_hold AS quantity_on_hold_54, t0.parent_product_id AS parent_product_id_55, t0.fee_warehouse_packing_per_unit AS fee_warehouse_packing_per_unit_56, t0.fee_warehouse_handling_per_unit AS fee_warehouse_handling_per_unit_57, t0.is_displayed_in_association_only AS is_displayed_in_association_only_58, t0.is_hri AS is_hri_59, t0.puro_exclusion AS puro_exclusion_60, t0.contains_alcohol AS contains_alcohol_61, t0.is_consumer AS is_consumer_62, t0.product_colabor_price AS product_colabor_price_63, t0.is_prix_laureat AS is_prix_laureat_64, t0.cant_use_coupon AS cant_use_coupon_65, t0.seasonality AS seasonality_66, t0.seasonality_start AS seasonality_start_67, t0.seasonality_end AS seasonality_end_68, t0.quantity_max_prod AS quantity_max_prod_69, t0.product_delete AS product_delete_70, t0.order_frequency AS order_frequency_71, t0.portion_for_meal AS portion_for_meal_72, t0.categories_id AS categories_id_73, t0.conservation_id AS conservation_id_74, t0.main_image_id AS main_image_id_75, t0.company_id AS company_id_76, t0.region_id AS region_id_77, t0.nutrition_fact_image_id AS nutrition_fact_image_id_78, t79.id AS id_80, t79.price_to_company AS price_to_company_81, t79.quantity AS quantity_82, t79.product_id AS product_id_83, t0.sub_category_id AS sub_category_id_84, t0.corporative_id AS corporative_id_85 FROM product t0 LEFT JOIN product_deal t79 ON t79.product_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters: 
[
  830
]
View formatted query    View runnable query    Explain query
15 3.56 ms 
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: 
[
  54
]
View formatted query    View runnable query    Explain query
16 5.58 ms 
SELECT t0.id AS id_1, t0.orig_name AS orig_name_2, t0.orig_brand_name AS orig_brand_name_3, t0.qty_left AS qty_left_4, t0.unit_amount AS unit_amount_5, t0.unit AS unit_6, t0.available AS available_7, t0.orig_description AS orig_description_8, t0.origin AS origin_9, t0.best_before AS best_before_10, t0.creation_date AS creation_date_11, t0.nutrition_fact AS nutrition_fact_12, t0.new_product AS new_product_13, t0.taxable AS taxable_14, t0.maturin_upc AS maturin_upc_15, t0.code_upc AS code_upc_16, t0.code1 AS code1_17, t0.code2 AS code2_18, t0.code3 AS code3_19, t0.code_box AS code_box_20, t0.aliments_du_quebec AS aliments_du_quebec_21, t0.minimum_in_storage AS minimum_in_storage_22, t0.limited_quantity AS limited_quantity_23, t0.aliments_du_quebec_certification AS aliments_du_quebec_certification_24, t0.delivery_type AS delivery_type_25, t0.delivery_pickup AS delivery_pickup_26, t0.draft AS draft_27, t0.delivery_mail AS delivery_mail_28, t0.advices AS advices_29, t0.recipes AS recipes_30, t0.solex_id AS solex_id_31, t0.list_of_ingredients AS list_of_ingredients_32, t0.qty_ready_to_ship AS qty_ready_to_ship_33, t0.expiration_date AS expiration_date_34, t0.is_consigned AS is_consigned_35, t0.consigned_cost AS consigned_cost_36, t0.is_fragile AS is_fragile_37, t0.qty_per_unit AS qty_per_unit_38, t0.validated_by_distributor AS validated_by_distributor_39, t0.delivery_note AS delivery_note_40, t0.is_just_in_time AS is_just_in_time_41, t0.reminder_low_quantity_sent AS reminder_low_quantity_sent_42, t0.has_multiple_products AS has_multiple_products_43, t0.has_free_maturin_shipping AS has_free_maturin_shipping_44, t0.action_when_expired AS action_when_expired_45, t0.is_subscribable AS is_subscribable_46, t0.is_box_of_products AS is_box_of_products_47, t0.is_only_subscribable AS is_only_subscribable_48, t0.just_in_time_delivery_date AS just_in_time_delivery_date_49, t0.free_maturin_shipping_if_lower_then AS free_maturin_shipping_if_lower_then_50, t0.is_only_subscribable_to_type AS is_only_subscribable_to_type_51, t0.quantity_warehouse AS quantity_warehouse_52, t0.quantity_warehouse_reserved AS quantity_warehouse_reserved_53, t0.quantity_on_hold AS quantity_on_hold_54, t0.parent_product_id AS parent_product_id_55, t0.fee_warehouse_packing_per_unit AS fee_warehouse_packing_per_unit_56, t0.fee_warehouse_handling_per_unit AS fee_warehouse_handling_per_unit_57, t0.is_displayed_in_association_only AS is_displayed_in_association_only_58, t0.is_hri AS is_hri_59, t0.puro_exclusion AS puro_exclusion_60, t0.contains_alcohol AS contains_alcohol_61, t0.is_consumer AS is_consumer_62, t0.product_colabor_price AS product_colabor_price_63, t0.is_prix_laureat AS is_prix_laureat_64, t0.cant_use_coupon AS cant_use_coupon_65, t0.seasonality AS seasonality_66, t0.seasonality_start AS seasonality_start_67, t0.seasonality_end AS seasonality_end_68, t0.quantity_max_prod AS quantity_max_prod_69, t0.product_delete AS product_delete_70, t0.order_frequency AS order_frequency_71, t0.portion_for_meal AS portion_for_meal_72, t0.categories_id AS categories_id_73, t0.conservation_id AS conservation_id_74, t0.main_image_id AS main_image_id_75, t0.company_id AS company_id_76, t0.region_id AS region_id_77, t0.nutrition_fact_image_id AS nutrition_fact_image_id_78, t79.id AS id_80, t79.price_to_company AS price_to_company_81, t79.quantity AS quantity_82, t79.product_id AS product_id_83, t0.sub_category_id AS sub_category_id_84, t0.corporative_id AS corporative_id_85 FROM product t0 LEFT JOIN product_deal t79 ON t79.product_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters: 
[
  187
]
View formatted query    View runnable query    Explain query
17 8.61 ms 
SELECT t0.id AS id_1, t0.orig_name AS orig_name_2, t0.orig_brand_name AS orig_brand_name_3, t0.qty_left AS qty_left_4, t0.unit_amount AS unit_amount_5, t0.unit AS unit_6, t0.available AS available_7, t0.orig_description AS orig_description_8, t0.origin AS origin_9, t0.best_before AS best_before_10, t0.creation_date AS creation_date_11, t0.nutrition_fact AS nutrition_fact_12, t0.new_product AS new_product_13, t0.taxable AS taxable_14, t0.maturin_upc AS maturin_upc_15, t0.code_upc AS code_upc_16, t0.code1 AS code1_17, t0.code2 AS code2_18, t0.code3 AS code3_19, t0.code_box AS code_box_20, t0.aliments_du_quebec AS aliments_du_quebec_21, t0.minimum_in_storage AS minimum_in_storage_22, t0.limited_quantity AS limited_quantity_23, t0.aliments_du_quebec_certification AS aliments_du_quebec_certification_24, t0.delivery_type AS delivery_type_25, t0.delivery_pickup AS delivery_pickup_26, t0.draft AS draft_27, t0.delivery_mail AS delivery_mail_28, t0.advices AS advices_29, t0.recipes AS recipes_30, t0.solex_id AS solex_id_31, t0.list_of_ingredients AS list_of_ingredients_32, t0.qty_ready_to_ship AS qty_ready_to_ship_33, t0.expiration_date AS expiration_date_34, t0.is_consigned AS is_consigned_35, t0.consigned_cost AS consigned_cost_36, t0.is_fragile AS is_fragile_37, t0.qty_per_unit AS qty_per_unit_38, t0.validated_by_distributor AS validated_by_distributor_39, t0.delivery_note AS delivery_note_40, t0.is_just_in_time AS is_just_in_time_41, t0.reminder_low_quantity_sent AS reminder_low_quantity_sent_42, t0.has_multiple_products AS has_multiple_products_43, t0.has_free_maturin_shipping AS has_free_maturin_shipping_44, t0.action_when_expired AS action_when_expired_45, t0.is_subscribable AS is_subscribable_46, t0.is_box_of_products AS is_box_of_products_47, t0.is_only_subscribable AS is_only_subscribable_48, t0.just_in_time_delivery_date AS just_in_time_delivery_date_49, t0.free_maturin_shipping_if_lower_then AS free_maturin_shipping_if_lower_then_50, t0.is_only_subscribable_to_type AS is_only_subscribable_to_type_51, t0.quantity_warehouse AS quantity_warehouse_52, t0.quantity_warehouse_reserved AS quantity_warehouse_reserved_53, t0.quantity_on_hold AS quantity_on_hold_54, t0.parent_product_id AS parent_product_id_55, t0.fee_warehouse_packing_per_unit AS fee_warehouse_packing_per_unit_56, t0.fee_warehouse_handling_per_unit AS fee_warehouse_handling_per_unit_57, t0.is_displayed_in_association_only AS is_displayed_in_association_only_58, t0.is_hri AS is_hri_59, t0.puro_exclusion AS puro_exclusion_60, t0.contains_alcohol AS contains_alcohol_61, t0.is_consumer AS is_consumer_62, t0.product_colabor_price AS product_colabor_price_63, t0.is_prix_laureat AS is_prix_laureat_64, t0.cant_use_coupon AS cant_use_coupon_65, t0.seasonality AS seasonality_66, t0.seasonality_start AS seasonality_start_67, t0.seasonality_end AS seasonality_end_68, t0.quantity_max_prod AS quantity_max_prod_69, t0.product_delete AS product_delete_70, t0.order_frequency AS order_frequency_71, t0.portion_for_meal AS portion_for_meal_72, t0.categories_id AS categories_id_73, t0.conservation_id AS conservation_id_74, t0.main_image_id AS main_image_id_75, t0.company_id AS company_id_76, t0.region_id AS region_id_77, t0.nutrition_fact_image_id AS nutrition_fact_image_id_78, t79.id AS id_80, t79.price_to_company AS price_to_company_81, t79.quantity AS quantity_82, t79.product_id AS product_id_83, t0.sub_category_id AS sub_category_id_84, t0.corporative_id AS corporative_id_85 FROM product t0 LEFT JOIN product_deal t79 ON t79.product_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters: 
[
  828
]
View formatted query    View runnable query    Explain query
18 3.95 ms 
SELECT t0.id AS id_1, t0.orig_name AS orig_name_2, t0.orig_brand_name AS orig_brand_name_3, t0.qty_left AS qty_left_4, t0.unit_amount AS unit_amount_5, t0.unit AS unit_6, t0.available AS available_7, t0.orig_description AS orig_description_8, t0.origin AS origin_9, t0.best_before AS best_before_10, t0.creation_date AS creation_date_11, t0.nutrition_fact AS nutrition_fact_12, t0.new_product AS new_product_13, t0.taxable AS taxable_14, t0.maturin_upc AS maturin_upc_15, t0.code_upc AS code_upc_16, t0.code1 AS code1_17, t0.code2 AS code2_18, t0.code3 AS code3_19, t0.code_box AS code_box_20, t0.aliments_du_quebec AS aliments_du_quebec_21, t0.minimum_in_storage AS minimum_in_storage_22, t0.limited_quantity AS limited_quantity_23, t0.aliments_du_quebec_certification AS aliments_du_quebec_certification_24, t0.delivery_type AS delivery_type_25, t0.delivery_pickup AS delivery_pickup_26, t0.draft AS draft_27, t0.delivery_mail AS delivery_mail_28, t0.advices AS advices_29, t0.recipes AS recipes_30, t0.solex_id AS solex_id_31, t0.list_of_ingredients AS list_of_ingredients_32, t0.qty_ready_to_ship AS qty_ready_to_ship_33, t0.expiration_date AS expiration_date_34, t0.is_consigned AS is_consigned_35, t0.consigned_cost AS consigned_cost_36, t0.is_fragile AS is_fragile_37, t0.qty_per_unit AS qty_per_unit_38, t0.validated_by_distributor AS validated_by_distributor_39, t0.delivery_note AS delivery_note_40, t0.is_just_in_time AS is_just_in_time_41, t0.reminder_low_quantity_sent AS reminder_low_quantity_sent_42, t0.has_multiple_products AS has_multiple_products_43, t0.has_free_maturin_shipping AS has_free_maturin_shipping_44, t0.action_when_expired AS action_when_expired_45, t0.is_subscribable AS is_subscribable_46, t0.is_box_of_products AS is_box_of_products_47, t0.is_only_subscribable AS is_only_subscribable_48, t0.just_in_time_delivery_date AS just_in_time_delivery_date_49, t0.free_maturin_shipping_if_lower_then AS free_maturin_shipping_if_lower_then_50, t0.is_only_subscribable_to_type AS is_only_subscribable_to_type_51, t0.quantity_warehouse AS quantity_warehouse_52, t0.quantity_warehouse_reserved AS quantity_warehouse_reserved_53, t0.quantity_on_hold AS quantity_on_hold_54, t0.parent_product_id AS parent_product_id_55, t0.fee_warehouse_packing_per_unit AS fee_warehouse_packing_per_unit_56, t0.fee_warehouse_handling_per_unit AS fee_warehouse_handling_per_unit_57, t0.is_displayed_in_association_only AS is_displayed_in_association_only_58, t0.is_hri AS is_hri_59, t0.puro_exclusion AS puro_exclusion_60, t0.contains_alcohol AS contains_alcohol_61, t0.is_consumer AS is_consumer_62, t0.product_colabor_price AS product_colabor_price_63, t0.is_prix_laureat AS is_prix_laureat_64, t0.cant_use_coupon AS cant_use_coupon_65, t0.seasonality AS seasonality_66, t0.seasonality_start AS seasonality_start_67, t0.seasonality_end AS seasonality_end_68, t0.quantity_max_prod AS quantity_max_prod_69, t0.product_delete AS product_delete_70, t0.order_frequency AS order_frequency_71, t0.portion_for_meal AS portion_for_meal_72, t0.categories_id AS categories_id_73, t0.conservation_id AS conservation_id_74, t0.main_image_id AS main_image_id_75, t0.company_id AS company_id_76, t0.region_id AS region_id_77, t0.nutrition_fact_image_id AS nutrition_fact_image_id_78, t79.id AS id_80, t79.price_to_company AS price_to_company_81, t79.quantity AS quantity_82, t79.product_id AS product_id_83, t0.sub_category_id AS sub_category_id_84, t0.corporative_id AS corporative_id_85 FROM product t0 LEFT JOIN product_deal t79 ON t79.product_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters: 
[
  829
]
View formatted query    View runnable query    Explain query
19 0.59 ms 
SELECT t0.id AS id_1, t0.orig_name AS orig_name_2, t0.orig_brand_name AS orig_brand_name_3, t0.qty_left AS qty_left_4, t0.unit_amount AS unit_amount_5, t0.unit AS unit_6, t0.available AS available_7, t0.orig_description AS orig_description_8, t0.origin AS origin_9, t0.best_before AS best_before_10, t0.creation_date AS creation_date_11, t0.nutrition_fact AS nutrition_fact_12, t0.new_product AS new_product_13, t0.taxable AS taxable_14, t0.maturin_upc AS maturin_upc_15, t0.code_upc AS code_upc_16, t0.code1 AS code1_17, t0.code2 AS code2_18, t0.code3 AS code3_19, t0.code_box AS code_box_20, t0.aliments_du_quebec AS aliments_du_quebec_21, t0.minimum_in_storage AS minimum_in_storage_22, t0.limited_quantity AS limited_quantity_23, t0.aliments_du_quebec_certification AS aliments_du_quebec_certification_24, t0.delivery_type AS delivery_type_25, t0.delivery_pickup AS delivery_pickup_26, t0.draft AS draft_27, t0.delivery_mail AS delivery_mail_28, t0.advices AS advices_29, t0.recipes AS recipes_30, t0.solex_id AS solex_id_31, t0.list_of_ingredients AS list_of_ingredients_32, t0.qty_ready_to_ship AS qty_ready_to_ship_33, t0.expiration_date AS expiration_date_34, t0.is_consigned AS is_consigned_35, t0.consigned_cost AS consigned_cost_36, t0.is_fragile AS is_fragile_37, t0.qty_per_unit AS qty_per_unit_38, t0.validated_by_distributor AS validated_by_distributor_39, t0.delivery_note AS delivery_note_40, t0.is_just_in_time AS is_just_in_time_41, t0.reminder_low_quantity_sent AS reminder_low_quantity_sent_42, t0.has_multiple_products AS has_multiple_products_43, t0.has_free_maturin_shipping AS has_free_maturin_shipping_44, t0.action_when_expired AS action_when_expired_45, t0.is_subscribable AS is_subscribable_46, t0.is_box_of_products AS is_box_of_products_47, t0.is_only_subscribable AS is_only_subscribable_48, t0.just_in_time_delivery_date AS just_in_time_delivery_date_49, t0.free_maturin_shipping_if_lower_then AS free_maturin_shipping_if_lower_then_50, t0.is_only_subscribable_to_type AS is_only_subscribable_to_type_51, t0.quantity_warehouse AS quantity_warehouse_52, t0.quantity_warehouse_reserved AS quantity_warehouse_reserved_53, t0.quantity_on_hold AS quantity_on_hold_54, t0.parent_product_id AS parent_product_id_55, t0.fee_warehouse_packing_per_unit AS fee_warehouse_packing_per_unit_56, t0.fee_warehouse_handling_per_unit AS fee_warehouse_handling_per_unit_57, t0.is_displayed_in_association_only AS is_displayed_in_association_only_58, t0.is_hri AS is_hri_59, t0.puro_exclusion AS puro_exclusion_60, t0.contains_alcohol AS contains_alcohol_61, t0.is_consumer AS is_consumer_62, t0.product_colabor_price AS product_colabor_price_63, t0.is_prix_laureat AS is_prix_laureat_64, t0.cant_use_coupon AS cant_use_coupon_65, t0.seasonality AS seasonality_66, t0.seasonality_start AS seasonality_start_67, t0.seasonality_end AS seasonality_end_68, t0.quantity_max_prod AS quantity_max_prod_69, t0.product_delete AS product_delete_70, t0.order_frequency AS order_frequency_71, t0.portion_for_meal AS portion_for_meal_72, t0.categories_id AS categories_id_73, t0.conservation_id AS conservation_id_74, t0.main_image_id AS main_image_id_75, t0.company_id AS company_id_76, t0.region_id AS region_id_77, t0.nutrition_fact_image_id AS nutrition_fact_image_id_78, t79.id AS id_80, t79.price_to_company AS price_to_company_81, t79.quantity AS quantity_82, t79.product_id AS product_id_83, t0.sub_category_id AS sub_category_id_84, t0.corporative_id AS corporative_id_85 FROM product t0 LEFT JOIN product_deal t79 ON t79.product_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters: 
[
  1793
]
View formatted query    View runnable query    Explain query
20 0.62 ms 
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: 
[
  228
]
View formatted query    View runnable query    Explain query
21 0.48 ms 
SELECT t0.id AS id_1, t0.orig_name AS orig_name_2, t0.orig_brand_name AS orig_brand_name_3, t0.qty_left AS qty_left_4, t0.unit_amount AS unit_amount_5, t0.unit AS unit_6, t0.available AS available_7, t0.orig_description AS orig_description_8, t0.origin AS origin_9, t0.best_before AS best_before_10, t0.creation_date AS creation_date_11, t0.nutrition_fact AS nutrition_fact_12, t0.new_product AS new_product_13, t0.taxable AS taxable_14, t0.maturin_upc AS maturin_upc_15, t0.code_upc AS code_upc_16, t0.code1 AS code1_17, t0.code2 AS code2_18, t0.code3 AS code3_19, t0.code_box AS code_box_20, t0.aliments_du_quebec AS aliments_du_quebec_21, t0.minimum_in_storage AS minimum_in_storage_22, t0.limited_quantity AS limited_quantity_23, t0.aliments_du_quebec_certification AS aliments_du_quebec_certification_24, t0.delivery_type AS delivery_type_25, t0.delivery_pickup AS delivery_pickup_26, t0.draft AS draft_27, t0.delivery_mail AS delivery_mail_28, t0.advices AS advices_29, t0.recipes AS recipes_30, t0.solex_id AS solex_id_31, t0.list_of_ingredients AS list_of_ingredients_32, t0.qty_ready_to_ship AS qty_ready_to_ship_33, t0.expiration_date AS expiration_date_34, t0.is_consigned AS is_consigned_35, t0.consigned_cost AS consigned_cost_36, t0.is_fragile AS is_fragile_37, t0.qty_per_unit AS qty_per_unit_38, t0.validated_by_distributor AS validated_by_distributor_39, t0.delivery_note AS delivery_note_40, t0.is_just_in_time AS is_just_in_time_41, t0.reminder_low_quantity_sent AS reminder_low_quantity_sent_42, t0.has_multiple_products AS has_multiple_products_43, t0.has_free_maturin_shipping AS has_free_maturin_shipping_44, t0.action_when_expired AS action_when_expired_45, t0.is_subscribable AS is_subscribable_46, t0.is_box_of_products AS is_box_of_products_47, t0.is_only_subscribable AS is_only_subscribable_48, t0.just_in_time_delivery_date AS just_in_time_delivery_date_49, t0.free_maturin_shipping_if_lower_then AS free_maturin_shipping_if_lower_then_50, t0.is_only_subscribable_to_type AS is_only_subscribable_to_type_51, t0.quantity_warehouse AS quantity_warehouse_52, t0.quantity_warehouse_reserved AS quantity_warehouse_reserved_53, t0.quantity_on_hold AS quantity_on_hold_54, t0.parent_product_id AS parent_product_id_55, t0.fee_warehouse_packing_per_unit AS fee_warehouse_packing_per_unit_56, t0.fee_warehouse_handling_per_unit AS fee_warehouse_handling_per_unit_57, t0.is_displayed_in_association_only AS is_displayed_in_association_only_58, t0.is_hri AS is_hri_59, t0.puro_exclusion AS puro_exclusion_60, t0.contains_alcohol AS contains_alcohol_61, t0.is_consumer AS is_consumer_62, t0.product_colabor_price AS product_colabor_price_63, t0.is_prix_laureat AS is_prix_laureat_64, t0.cant_use_coupon AS cant_use_coupon_65, t0.seasonality AS seasonality_66, t0.seasonality_start AS seasonality_start_67, t0.seasonality_end AS seasonality_end_68, t0.quantity_max_prod AS quantity_max_prod_69, t0.product_delete AS product_delete_70, t0.order_frequency AS order_frequency_71, t0.portion_for_meal AS portion_for_meal_72, t0.categories_id AS categories_id_73, t0.conservation_id AS conservation_id_74, t0.main_image_id AS main_image_id_75, t0.company_id AS company_id_76, t0.region_id AS region_id_77, t0.nutrition_fact_image_id AS nutrition_fact_image_id_78, t79.id AS id_80, t79.price_to_company AS price_to_company_81, t79.quantity AS quantity_82, t79.product_id AS product_id_83, t0.sub_category_id AS sub_category_id_84, t0.corporative_id AS corporative_id_85 FROM product t0 LEFT JOIN product_deal t79 ON t79.product_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters: 
[
  2820
]
View formatted query    View runnable query    Explain query

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\Notification No errors.
App\Entity\Message No errors.
App\Entity\Product No errors.
App\Entity\Cart No errors.
App\Entity\Image 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\CompanyDeposit No errors.
App\Entity\CompanyDefaultShipping No errors.
App\Entity\CompanyPayment No errors.
App\Entity\CompanySubscription No errors.
App\Entity\FinancialLog No errors.
App\Entity\ProductReplenishment No errors.
App\Entity\CustomOrder No errors.
App\Entity\MaturinOrder No errors.
App\Entity\Invoice No errors.
App\Entity\InvoiceService No errors.
App\Entity\CompanyAssociation No errors.
App\Entity\Variable No errors.