Symfony Profiler

SELECT 
  t0.id AS id_1, 
  t0.data_key AS data_key_2, 
  t0.data_value AS data_value_3 
FROM 
  cms_home_page t0 
WHERE 
  t0.data_key = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.data_key AS data_key_2, t0.data_value AS data_value_3 FROM cms_home_page t0 WHERE t0.data_key = 'CMSHomePage' LIMIT 1;

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 = ? 
LIMIT 
  1

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 = 229 LIMIT 1;

SELECT 
  t0_.id AS id_0, 
  t0_.title AS title_1, 
  t0_.company_name AS company_name_2, 
  t0_.text AS text_3, 
  t0_.profile_text AS profile_text_4, 
  t0_.profile_image_id AS profile_image_id_5, 
  t0_.main_image_id AS main_image_id_6 
FROM 
  testimony t0_

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.company_name AS company_name_2, t0_.text AS text_3, t0_.profile_text AS profile_text_4, t0_.profile_image_id AS profile_image_id_5, t0_.main_image_id AS main_image_id_6 FROM testimony t0_;

SELECT 
  p0_.id AS id_0, 
  p0_.title AS title_1, 
  p0_.url AS url_2, 
  p0_.display_order AS display_order_3, 
  p0_.on_sale AS on_sale_4, 
  p0_.category_id AS category_id_5 
FROM 
  product_sponsored_category p0_ 
ORDER BY 
  p0_.display_order ASC

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.url AS url_2, p0_.display_order AS display_order_3, p0_.on_sale AS on_sale_4, p0_.category_id AS category_id_5 FROM product_sponsored_category p0_ ORDER BY p0_.display_order ASC;

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, 
  p1_.id AS id_5, 
  p1_.orig_name AS orig_name_6, 
  p1_.orig_brand_name AS orig_brand_name_7, 
  p1_.qty_left AS qty_left_8, 
  p1_.unit_amount AS unit_amount_9, 
  p1_.unit AS unit_10, 
  p1_.available AS available_11, 
  p1_.orig_description AS orig_description_12, 
  p1_.origin AS origin_13, 
  p1_.best_before AS best_before_14, 
  p1_.creation_date AS creation_date_15, 
  p1_.nutrition_fact AS nutrition_fact_16, 
  p1_.new_product AS new_product_17, 
  p1_.taxable AS taxable_18, 
  p1_.maturin_upc AS maturin_upc_19, 
  p1_.code_upc AS code_upc_20, 
  p1_.code1 AS code1_21, 
  p1_.code2 AS code2_22, 
  p1_.code3 AS code3_23, 
  p1_.code_box AS code_box_24, 
  p1_.aliments_du_quebec AS aliments_du_quebec_25, 
  p1_.minimum_in_storage AS minimum_in_storage_26, 
  p1_.limited_quantity AS limited_quantity_27, 
  p1_.aliments_du_quebec_certification AS aliments_du_quebec_certification_28, 
  p1_.delivery_type AS delivery_type_29, 
  p1_.delivery_pickup AS delivery_pickup_30, 
  p1_.draft AS draft_31, 
  p1_.delivery_mail AS delivery_mail_32, 
  p1_.advices AS advices_33, 
  p1_.recipes AS recipes_34, 
  p1_.solex_id AS solex_id_35, 
  p1_.list_of_ingredients AS list_of_ingredients_36, 
  p1_.qty_ready_to_ship AS qty_ready_to_ship_37, 
  p1_.expiration_date AS expiration_date_38, 
  p1_.is_consigned AS is_consigned_39, 
  p1_.consigned_cost AS consigned_cost_40, 
  p1_.is_fragile AS is_fragile_41, 
  p1_.qty_per_unit AS qty_per_unit_42, 
  p1_.validated_by_distributor AS validated_by_distributor_43, 
  p1_.delivery_note AS delivery_note_44, 
  p1_.is_just_in_time AS is_just_in_time_45, 
  p1_.reminder_low_quantity_sent AS reminder_low_quantity_sent_46, 
  p1_.has_multiple_products AS has_multiple_products_47, 
  p1_.has_free_maturin_shipping AS has_free_maturin_shipping_48, 
  p1_.action_when_expired AS action_when_expired_49, 
  p1_.is_subscribable AS is_subscribable_50, 
  p1_.is_box_of_products AS is_box_of_products_51, 
  p1_.is_only_subscribable AS is_only_subscribable_52, 
  p1_.just_in_time_delivery_date AS just_in_time_delivery_date_53, 
  p1_.free_maturin_shipping_if_lower_then AS free_maturin_shipping_if_lower_then_54, 
  p1_.is_only_subscribable_to_type AS is_only_subscribable_to_type_55, 
  p1_.quantity_warehouse AS quantity_warehouse_56, 
  p1_.quantity_warehouse_reserved AS quantity_warehouse_reserved_57, 
  p1_.quantity_on_hold AS quantity_on_hold_58, 
  p1_.parent_product_id AS parent_product_id_59, 
  p1_.fee_warehouse_packing_per_unit AS fee_warehouse_packing_per_unit_60, 
  p1_.fee_warehouse_handling_per_unit AS fee_warehouse_handling_per_unit_61, 
  p1_.is_displayed_in_association_only AS is_displayed_in_association_only_62, 
  p1_.is_hri AS is_hri_63, 
  p1_.puro_exclusion AS puro_exclusion_64, 
  p1_.contains_alcohol AS contains_alcohol_65, 
  p1_.is_consumer AS is_consumer_66, 
  p1_.product_colabor_price AS product_colabor_price_67, 
  p1_.is_prix_laureat AS is_prix_laureat_68, 
  p1_.cant_use_coupon AS cant_use_coupon_69, 
  p1_.seasonality AS seasonality_70, 
  p1_.seasonality_start AS seasonality_start_71, 
  p1_.seasonality_end AS seasonality_end_72, 
  p1_.quantity_max_prod AS quantity_max_prod_73, 
  p1_.product_delete AS product_delete_74, 
  p1_.order_frequency AS order_frequency_75, 
  p1_.portion_for_meal AS portion_for_meal_76, 
  p2_.id AS id_77, 
  p2_.title AS title_78, 
  p2_.url AS url_79, 
  p2_.display_order AS display_order_80, 
  p2_.on_sale AS on_sale_81, 
  c3_.id AS id_82, 
  c3_.name AS name_83, 
  c3_.website AS website_84, 
  c3_.description AS description_85, 
  c3_.speciality AS speciality_86, 
  c3_.average_delivery_time AS average_delivery_time_87, 
  c3_.taxe_tps AS taxe_tps_88, 
  c3_.taxe_tvx AS taxe_tvx_89, 
  c3_.company_number AS company_number_90, 
  c3_.number_of_sales AS number_of_sales_91, 
  c3_.total_sales_in_dollars AS total_sales_in_dollars_92, 
  c3_.date_created AS date_created_93, 
  c3_.custom_sale_conditions AS custom_sale_conditions_94, 
  c3_.conditions_shipping AS conditions_shipping_95, 
  c3_.conditions_return AS conditions_return_96, 
  c3_.conditions_cancel AS conditions_cancel_97, 
  c3_.terms_acceptance_date AS terms_acceptance_date_98, 
  c3_.terms_acceptance_ip AS terms_acceptance_ip_99, 
  c3_.solex_id AS solex_id_100, 
  c3_.store_made_by_maturin AS store_made_by_maturin_101, 
  c3_.terms_acceptance_finger_print AS terms_acceptance_finger_print_102, 
  c3_.inventory_last_update AS inventory_last_update_103, 
  c3_.show_publicly AS show_publicly_104, 
  c3_.custom_url AS custom_url_105, 
  c3_.is_allowed_to_schedule_cold_product AS is_allowed_to_schedule_cold_product_106, 
  c3_.reminder_stripe_verification_sent AS reminder_stripe_verification_sent_107, 
  c3_.export_colabor AS export_colabor_108, 
  p0_.product_id AS product_id_109, 
  p0_.custom_image_id AS custom_image_id_110, 
  p1_.categories_id AS categories_id_111, 
  p1_.conservation_id AS conservation_id_112, 
  p1_.main_image_id AS main_image_id_113, 
  p1_.company_id AS company_id_114, 
  p1_.region_id AS region_id_115, 
  p1_.nutrition_fact_image_id AS nutrition_fact_image_id_116, 
  p1_.sub_category_id AS sub_category_id_117, 
  p1_.corporative_id AS corporative_id_118, 
  p2_.category_id AS category_id_119, 
  c3_.image_id AS image_id_120, 
  c3_.banner_id AS banner_id_121, 
  c3_.main_location_id AS main_location_id_122, 
  c3_.recruiter_id AS recruiter_id_123, 
  c3_.in_group_of_user_id AS in_group_of_user_id_124 
FROM 
  product_sponsored p0_ 
  LEFT JOIN product p1_ ON p0_.product_id = p1_.id 
  LEFT JOIN product_sponsored_category_product_sponsored p4_ ON p0_.id = p4_.product_sponsored_id 
  LEFT JOIN product_sponsored_category p2_ ON p2_.id = p4_.product_sponsored_category_id 
  LEFT JOIN company c3_ ON p1_.company_id = c3_.id 
WHERE 
  p0_.active = 1 
  AND p0_.from_date <= ? 
  AND p0_.to_date >= ? 
  AND p2_.id = ? 
  AND p1_.is_displayed_in_association_only = 0 
  AND p1_.draft <> 1 
  AND p1_.main_image_id IS NOT NULL 
  AND p1_.available > 0 
  AND c3_.show_publicly = 1 
  AND p1_.qty_ready_to_ship > 0 
  AND p1_.delivery_type = 0 
  AND p1_.delivery_mail = 1 
GROUP BY 
  p1_.id 
ORDER BY 
  RAND() ASC 
LIMIT 
  4

SELECT p0_.id AS id_0, p0_.from_date AS from_date_1, p0_.to_date AS to_date_2, p0_.active AS active_3, p0_.is_in_modal AS is_in_modal_4, p1_.id AS id_5, p1_.orig_name AS orig_name_6, p1_.orig_brand_name AS orig_brand_name_7, p1_.qty_left AS qty_left_8, p1_.unit_amount AS unit_amount_9, p1_.unit AS unit_10, p1_.available AS available_11, p1_.orig_description AS orig_description_12, p1_.origin AS origin_13, p1_.best_before AS best_before_14, p1_.creation_date AS creation_date_15, p1_.nutrition_fact AS nutrition_fact_16, p1_.new_product AS new_product_17, p1_.taxable AS taxable_18, p1_.maturin_upc AS maturin_upc_19, p1_.code_upc AS code_upc_20, p1_.code1 AS code1_21, p1_.code2 AS code2_22, p1_.code3 AS code3_23, p1_.code_box AS code_box_24, p1_.aliments_du_quebec AS aliments_du_quebec_25, p1_.minimum_in_storage AS minimum_in_storage_26, p1_.limited_quantity AS limited_quantity_27, p1_.aliments_du_quebec_certification AS aliments_du_quebec_certification_28, p1_.delivery_type AS delivery_type_29, p1_.delivery_pickup AS delivery_pickup_30, p1_.draft AS draft_31, p1_.delivery_mail AS delivery_mail_32, p1_.advices AS advices_33, p1_.recipes AS recipes_34, p1_.solex_id AS solex_id_35, p1_.list_of_ingredients AS list_of_ingredients_36, p1_.qty_ready_to_ship AS qty_ready_to_ship_37, p1_.expiration_date AS expiration_date_38, p1_.is_consigned AS is_consigned_39, p1_.consigned_cost AS consigned_cost_40, p1_.is_fragile AS is_fragile_41, p1_.qty_per_unit AS qty_per_unit_42, p1_.validated_by_distributor AS validated_by_distributor_43, p1_.delivery_note AS delivery_note_44, p1_.is_just_in_time AS is_just_in_time_45, p1_.reminder_low_quantity_sent AS reminder_low_quantity_sent_46, p1_.has_multiple_products AS has_multiple_products_47, p1_.has_free_maturin_shipping AS has_free_maturin_shipping_48, p1_.action_when_expired AS action_when_expired_49, p1_.is_subscribable AS is_subscribable_50, p1_.is_box_of_products AS is_box_of_products_51, p1_.is_only_subscribable AS is_only_subscribable_52, p1_.just_in_time_delivery_date AS just_in_time_delivery_date_53, p1_.free_maturin_shipping_if_lower_then AS free_maturin_shipping_if_lower_then_54, p1_.is_only_subscribable_to_type AS is_only_subscribable_to_type_55, p1_.quantity_warehouse AS quantity_warehouse_56, p1_.quantity_warehouse_reserved AS quantity_warehouse_reserved_57, p1_.quantity_on_hold AS quantity_on_hold_58, p1_.parent_product_id AS parent_product_id_59, p1_.fee_warehouse_packing_per_unit AS fee_warehouse_packing_per_unit_60, p1_.fee_warehouse_handling_per_unit AS fee_warehouse_handling_per_unit_61, p1_.is_displayed_in_association_only AS is_displayed_in_association_only_62, p1_.is_hri AS is_hri_63, p1_.puro_exclusion AS puro_exclusion_64, p1_.contains_alcohol AS contains_alcohol_65, p1_.is_consumer AS is_consumer_66, p1_.product_colabor_price AS product_colabor_price_67, p1_.is_prix_laureat AS is_prix_laureat_68, p1_.cant_use_coupon AS cant_use_coupon_69, p1_.seasonality AS seasonality_70, p1_.seasonality_start AS seasonality_start_71, p1_.seasonality_end AS seasonality_end_72, p1_.quantity_max_prod AS quantity_max_prod_73, p1_.product_delete AS product_delete_74, p1_.order_frequency AS order_frequency_75, p1_.portion_for_meal AS portion_for_meal_76, p2_.id AS id_77, p2_.title AS title_78, p2_.url AS url_79, p2_.display_order AS display_order_80, p2_.on_sale AS on_sale_81, c3_.id AS id_82, c3_.name AS name_83, c3_.website AS website_84, c3_.description AS description_85, c3_.speciality AS speciality_86, c3_.average_delivery_time AS average_delivery_time_87, c3_.taxe_tps AS taxe_tps_88, c3_.taxe_tvx AS taxe_tvx_89, c3_.company_number AS company_number_90, c3_.number_of_sales AS number_of_sales_91, c3_.total_sales_in_dollars AS total_sales_in_dollars_92, c3_.date_created AS date_created_93, c3_.custom_sale_conditions AS custom_sale_conditions_94, c3_.conditions_shipping AS conditions_shipping_95, c3_.conditions_return AS conditions_return_96, c3_.conditions_cancel AS conditions_cancel_97, c3_.terms_acceptance_date AS terms_acceptance_date_98, c3_.terms_acceptance_ip AS terms_acceptance_ip_99, c3_.solex_id AS solex_id_100, c3_.store_made_by_maturin AS store_made_by_maturin_101, c3_.terms_acceptance_finger_print AS terms_acceptance_finger_print_102, c3_.inventory_last_update AS inventory_last_update_103, c3_.show_publicly AS show_publicly_104, c3_.custom_url AS custom_url_105, c3_.is_allowed_to_schedule_cold_product AS is_allowed_to_schedule_cold_product_106, c3_.reminder_stripe_verification_sent AS reminder_stripe_verification_sent_107, c3_.export_colabor AS export_colabor_108, p0_.product_id AS product_id_109, p0_.custom_image_id AS custom_image_id_110, p1_.categories_id AS categories_id_111, p1_.conservation_id AS conservation_id_112, p1_.main_image_id AS main_image_id_113, p1_.company_id AS company_id_114, p1_.region_id AS region_id_115, p1_.nutrition_fact_image_id AS nutrition_fact_image_id_116, p1_.sub_category_id AS sub_category_id_117, p1_.corporative_id AS corporative_id_118, p2_.category_id AS category_id_119, c3_.image_id AS image_id_120, c3_.banner_id AS banner_id_121, c3_.main_location_id AS main_location_id_122, c3_.recruiter_id AS recruiter_id_123, c3_.in_group_of_user_id AS in_group_of_user_id_124 FROM product_sponsored p0_ LEFT JOIN product p1_ ON p0_.product_id = p1_.id LEFT JOIN product_sponsored_category_product_sponsored p4_ ON p0_.id = p4_.product_sponsored_id LEFT JOIN product_sponsored_category p2_ ON p2_.id = p4_.product_sponsored_category_id LEFT JOIN company c3_ ON p1_.company_id = c3_.id WHERE p0_.active = 1 AND p0_.from_date <= '2025-10-25 05:44:19' AND p0_.to_date >= '2025-10-25 05:44:19' AND p2_.id = 38 AND p1_.is_displayed_in_association_only = 0 AND p1_.draft <> 1 AND p1_.main_image_id IS NOT NULL AND p1_.available > 0 AND c3_.show_publicly = 1 AND p1_.qty_ready_to_ship > 0 AND p1_.delivery_type = 0 AND p1_.delivery_mail = 1 GROUP BY p1_.id ORDER BY RAND() ASC LIMIT 4;

SELECT 
  p0_.id AS id_0, 
  p0_.from_date AS from_date_1, 
  p0_.to_date AS to_date_2, 
  p0_.active AS active_3, 
  p0_.is_in_modal AS is_in_modal_4, 
  p1_.id AS id_5, 
  p1_.orig_name AS orig_name_6, 
  p1_.orig_brand_name AS orig_brand_name_7, 
  p1_.qty_left AS qty_left_8, 
  p1_.unit_amount AS unit_amount_9, 
  p1_.unit AS unit_10, 
  p1_.available AS available_11, 
  p1_.orig_description AS orig_description_12, 
  p1_.origin AS origin_13, 
  p1_.best_before AS best_before_14, 
  p1_.creation_date AS creation_date_15, 
  p1_.nutrition_fact AS nutrition_fact_16, 
  p1_.new_product AS new_product_17, 
  p1_.taxable AS taxable_18, 
  p1_.maturin_upc AS maturin_upc_19, 
  p1_.code_upc AS code_upc_20, 
  p1_.code1 AS code1_21, 
  p1_.code2 AS code2_22, 
  p1_.code3 AS code3_23, 
  p1_.code_box AS code_box_24, 
  p1_.aliments_du_quebec AS aliments_du_quebec_25, 
  p1_.minimum_in_storage AS minimum_in_storage_26, 
  p1_.limited_quantity AS limited_quantity_27, 
  p1_.aliments_du_quebec_certification AS aliments_du_quebec_certification_28, 
  p1_.delivery_type AS delivery_type_29, 
  p1_.delivery_pickup AS delivery_pickup_30, 
  p1_.draft AS draft_31, 
  p1_.delivery_mail AS delivery_mail_32, 
  p1_.advices AS advices_33, 
  p1_.recipes AS recipes_34, 
  p1_.solex_id AS solex_id_35, 
  p1_.list_of_ingredients AS list_of_ingredients_36, 
  p1_.qty_ready_to_ship AS qty_ready_to_ship_37, 
  p1_.expiration_date AS expiration_date_38, 
  p1_.is_consigned AS is_consigned_39, 
  p1_.consigned_cost AS consigned_cost_40, 
  p1_.is_fragile AS is_fragile_41, 
  p1_.qty_per_unit AS qty_per_unit_42, 
  p1_.validated_by_distributor AS validated_by_distributor_43, 
  p1_.delivery_note AS delivery_note_44, 
  p1_.is_just_in_time AS is_just_in_time_45, 
  p1_.reminder_low_quantity_sent AS reminder_low_quantity_sent_46, 
  p1_.has_multiple_products AS has_multiple_products_47, 
  p1_.has_free_maturin_shipping AS has_free_maturin_shipping_48, 
  p1_.action_when_expired AS action_when_expired_49, 
  p1_.is_subscribable AS is_subscribable_50, 
  p1_.is_box_of_products AS is_box_of_products_51, 
  p1_.is_only_subscribable AS is_only_subscribable_52, 
  p1_.just_in_time_delivery_date AS just_in_time_delivery_date_53, 
  p1_.free_maturin_shipping_if_lower_then AS free_maturin_shipping_if_lower_then_54, 
  p1_.is_only_subscribable_to_type AS is_only_subscribable_to_type_55, 
  p1_.quantity_warehouse AS quantity_warehouse_56, 
  p1_.quantity_warehouse_reserved AS quantity_warehouse_reserved_57, 
  p1_.quantity_on_hold AS quantity_on_hold_58, 
  p1_.parent_product_id AS parent_product_id_59, 
  p1_.fee_warehouse_packing_per_unit AS fee_warehouse_packing_per_unit_60, 
  p1_.fee_warehouse_handling_per_unit AS fee_warehouse_handling_per_unit_61, 
  p1_.is_displayed_in_association_only AS is_displayed_in_association_only_62, 
  p1_.is_hri AS is_hri_63, 
  p1_.puro_exclusion AS puro_exclusion_64, 
  p1_.contains_alcohol AS contains_alcohol_65, 
  p1_.is_consumer AS is_consumer_66, 
  p1_.product_colabor_price AS product_colabor_price_67, 
  p1_.is_prix_laureat AS is_prix_laureat_68, 
  p1_.cant_use_coupon AS cant_use_coupon_69, 
  p1_.seasonality AS seasonality_70, 
  p1_.seasonality_start AS seasonality_start_71, 
  p1_.seasonality_end AS seasonality_end_72, 
  p1_.quantity_max_prod AS quantity_max_prod_73, 
  p1_.product_delete AS product_delete_74, 
  p1_.order_frequency AS order_frequency_75, 
  p1_.portion_for_meal AS portion_for_meal_76, 
  p2_.id AS id_77, 
  p2_.title AS title_78, 
  p2_.url AS url_79, 
  p2_.display_order AS display_order_80, 
  p2_.on_sale AS on_sale_81, 
  c3_.id AS id_82, 
  c3_.name AS name_83, 
  c3_.website AS website_84, 
  c3_.description AS description_85, 
  c3_.speciality AS speciality_86, 
  c3_.average_delivery_time AS average_delivery_time_87, 
  c3_.taxe_tps AS taxe_tps_88, 
  c3_.taxe_tvx AS taxe_tvx_89, 
  c3_.company_number AS company_number_90, 
  c3_.number_of_sales AS number_of_sales_91, 
  c3_.total_sales_in_dollars AS total_sales_in_dollars_92, 
  c3_.date_created AS date_created_93, 
  c3_.custom_sale_conditions AS custom_sale_conditions_94, 
  c3_.conditions_shipping AS conditions_shipping_95, 
  c3_.conditions_return AS conditions_return_96, 
  c3_.conditions_cancel AS conditions_cancel_97, 
  c3_.terms_acceptance_date AS terms_acceptance_date_98, 
  c3_.terms_acceptance_ip AS terms_acceptance_ip_99, 
  c3_.solex_id AS solex_id_100, 
  c3_.store_made_by_maturin AS store_made_by_maturin_101, 
  c3_.terms_acceptance_finger_print AS terms_acceptance_finger_print_102, 
  c3_.inventory_last_update AS inventory_last_update_103, 
  c3_.show_publicly AS show_publicly_104, 
  c3_.custom_url AS custom_url_105, 
  c3_.is_allowed_to_schedule_cold_product AS is_allowed_to_schedule_cold_product_106, 
  c3_.reminder_stripe_verification_sent AS reminder_stripe_verification_sent_107, 
  c3_.export_colabor AS export_colabor_108, 
  p0_.product_id AS product_id_109, 
  p0_.custom_image_id AS custom_image_id_110, 
  p1_.categories_id AS categories_id_111, 
  p1_.conservation_id AS conservation_id_112, 
  p1_.main_image_id AS main_image_id_113, 
  p1_.company_id AS company_id_114, 
  p1_.region_id AS region_id_115, 
  p1_.nutrition_fact_image_id AS nutrition_fact_image_id_116, 
  p1_.sub_category_id AS sub_category_id_117, 
  p1_.corporative_id AS corporative_id_118, 
  p2_.category_id AS category_id_119, 
  c3_.image_id AS image_id_120, 
  c3_.banner_id AS banner_id_121, 
  c3_.main_location_id AS main_location_id_122, 
  c3_.recruiter_id AS recruiter_id_123, 
  c3_.in_group_of_user_id AS in_group_of_user_id_124 
FROM 
  product_sponsored p0_ 
  LEFT JOIN product p1_ ON p0_.product_id = p1_.id 
  LEFT JOIN product_sponsored_category_product_sponsored p4_ ON p0_.id = p4_.product_sponsored_id 
  LEFT JOIN product_sponsored_category p2_ ON p2_.id = p4_.product_sponsored_category_id 
  LEFT JOIN company c3_ ON p1_.company_id = c3_.id 
WHERE 
  p0_.active = 1 
  AND p0_.from_date <= ? 
  AND p0_.to_date >= ? 
  AND p2_.id = ? 
  AND p1_.is_displayed_in_association_only = 0 
  AND p1_.draft <> 1 
  AND p1_.main_image_id IS NOT NULL 
  AND p1_.available > 0 
  AND c3_.show_publicly = 1 
  AND p1_.qty_ready_to_ship > 0 
  AND p1_.delivery_type = 0 
  AND p1_.delivery_mail = 1 
GROUP BY 
  p1_.id 
ORDER BY 
  RAND() ASC 
LIMIT 
  4

SELECT p0_.id AS id_0, p0_.from_date AS from_date_1, p0_.to_date AS to_date_2, p0_.active AS active_3, p0_.is_in_modal AS is_in_modal_4, p1_.id AS id_5, p1_.orig_name AS orig_name_6, p1_.orig_brand_name AS orig_brand_name_7, p1_.qty_left AS qty_left_8, p1_.unit_amount AS unit_amount_9, p1_.unit AS unit_10, p1_.available AS available_11, p1_.orig_description AS orig_description_12, p1_.origin AS origin_13, p1_.best_before AS best_before_14, p1_.creation_date AS creation_date_15, p1_.nutrition_fact AS nutrition_fact_16, p1_.new_product AS new_product_17, p1_.taxable AS taxable_18, p1_.maturin_upc AS maturin_upc_19, p1_.code_upc AS code_upc_20, p1_.code1 AS code1_21, p1_.code2 AS code2_22, p1_.code3 AS code3_23, p1_.code_box AS code_box_24, p1_.aliments_du_quebec AS aliments_du_quebec_25, p1_.minimum_in_storage AS minimum_in_storage_26, p1_.limited_quantity AS limited_quantity_27, p1_.aliments_du_quebec_certification AS aliments_du_quebec_certification_28, p1_.delivery_type AS delivery_type_29, p1_.delivery_pickup AS delivery_pickup_30, p1_.draft AS draft_31, p1_.delivery_mail AS delivery_mail_32, p1_.advices AS advices_33, p1_.recipes AS recipes_34, p1_.solex_id AS solex_id_35, p1_.list_of_ingredients AS list_of_ingredients_36, p1_.qty_ready_to_ship AS qty_ready_to_ship_37, p1_.expiration_date AS expiration_date_38, p1_.is_consigned AS is_consigned_39, p1_.consigned_cost AS consigned_cost_40, p1_.is_fragile AS is_fragile_41, p1_.qty_per_unit AS qty_per_unit_42, p1_.validated_by_distributor AS validated_by_distributor_43, p1_.delivery_note AS delivery_note_44, p1_.is_just_in_time AS is_just_in_time_45, p1_.reminder_low_quantity_sent AS reminder_low_quantity_sent_46, p1_.has_multiple_products AS has_multiple_products_47, p1_.has_free_maturin_shipping AS has_free_maturin_shipping_48, p1_.action_when_expired AS action_when_expired_49, p1_.is_subscribable AS is_subscribable_50, p1_.is_box_of_products AS is_box_of_products_51, p1_.is_only_subscribable AS is_only_subscribable_52, p1_.just_in_time_delivery_date AS just_in_time_delivery_date_53, p1_.free_maturin_shipping_if_lower_then AS free_maturin_shipping_if_lower_then_54, p1_.is_only_subscribable_to_type AS is_only_subscribable_to_type_55, p1_.quantity_warehouse AS quantity_warehouse_56, p1_.quantity_warehouse_reserved AS quantity_warehouse_reserved_57, p1_.quantity_on_hold AS quantity_on_hold_58, p1_.parent_product_id AS parent_product_id_59, p1_.fee_warehouse_packing_per_unit AS fee_warehouse_packing_per_unit_60, p1_.fee_warehouse_handling_per_unit AS fee_warehouse_handling_per_unit_61, p1_.is_displayed_in_association_only AS is_displayed_in_association_only_62, p1_.is_hri AS is_hri_63, p1_.puro_exclusion AS puro_exclusion_64, p1_.contains_alcohol AS contains_alcohol_65, p1_.is_consumer AS is_consumer_66, p1_.product_colabor_price AS product_colabor_price_67, p1_.is_prix_laureat AS is_prix_laureat_68, p1_.cant_use_coupon AS cant_use_coupon_69, p1_.seasonality AS seasonality_70, p1_.seasonality_start AS seasonality_start_71, p1_.seasonality_end AS seasonality_end_72, p1_.quantity_max_prod AS quantity_max_prod_73, p1_.product_delete AS product_delete_74, p1_.order_frequency AS order_frequency_75, p1_.portion_for_meal AS portion_for_meal_76, p2_.id AS id_77, p2_.title AS title_78, p2_.url AS url_79, p2_.display_order AS display_order_80, p2_.on_sale AS on_sale_81, c3_.id AS id_82, c3_.name AS name_83, c3_.website AS website_84, c3_.description AS description_85, c3_.speciality AS speciality_86, c3_.average_delivery_time AS average_delivery_time_87, c3_.taxe_tps AS taxe_tps_88, c3_.taxe_tvx AS taxe_tvx_89, c3_.company_number AS company_number_90, c3_.number_of_sales AS number_of_sales_91, c3_.total_sales_in_dollars AS total_sales_in_dollars_92, c3_.date_created AS date_created_93, c3_.custom_sale_conditions AS custom_sale_conditions_94, c3_.conditions_shipping AS conditions_shipping_95, c3_.conditions_return AS conditions_return_96, c3_.conditions_cancel AS conditions_cancel_97, c3_.terms_acceptance_date AS terms_acceptance_date_98, c3_.terms_acceptance_ip AS terms_acceptance_ip_99, c3_.solex_id AS solex_id_100, c3_.store_made_by_maturin AS store_made_by_maturin_101, c3_.terms_acceptance_finger_print AS terms_acceptance_finger_print_102, c3_.inventory_last_update AS inventory_last_update_103, c3_.show_publicly AS show_publicly_104, c3_.custom_url AS custom_url_105, c3_.is_allowed_to_schedule_cold_product AS is_allowed_to_schedule_cold_product_106, c3_.reminder_stripe_verification_sent AS reminder_stripe_verification_sent_107, c3_.export_colabor AS export_colabor_108, p0_.product_id AS product_id_109, p0_.custom_image_id AS custom_image_id_110, p1_.categories_id AS categories_id_111, p1_.conservation_id AS conservation_id_112, p1_.main_image_id AS main_image_id_113, p1_.company_id AS company_id_114, p1_.region_id AS region_id_115, p1_.nutrition_fact_image_id AS nutrition_fact_image_id_116, p1_.sub_category_id AS sub_category_id_117, p1_.corporative_id AS corporative_id_118, p2_.category_id AS category_id_119, c3_.image_id AS image_id_120, c3_.banner_id AS banner_id_121, c3_.main_location_id AS main_location_id_122, c3_.recruiter_id AS recruiter_id_123, c3_.in_group_of_user_id AS in_group_of_user_id_124 FROM product_sponsored p0_ LEFT JOIN product p1_ ON p0_.product_id = p1_.id LEFT JOIN product_sponsored_category_product_sponsored p4_ ON p0_.id = p4_.product_sponsored_id LEFT JOIN product_sponsored_category p2_ ON p2_.id = p4_.product_sponsored_category_id LEFT JOIN company c3_ ON p1_.company_id = c3_.id WHERE p0_.active = 1 AND p0_.from_date <= '2025-10-25 05:44:19' AND p0_.to_date >= '2025-10-25 05:44:19' AND p2_.id = 40 AND p1_.is_displayed_in_association_only = 0 AND p1_.draft <> 1 AND p1_.main_image_id IS NOT NULL AND p1_.available > 0 AND c3_.show_publicly = 1 AND p1_.qty_ready_to_ship > 0 AND p1_.delivery_type = 0 AND p1_.delivery_mail = 1 GROUP BY p1_.id ORDER BY RAND() ASC LIMIT 4;