Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.finish AS finish_2,
  t0.user_id AS user_id_3,
  t0.customer_id AS customer_id_4
FROM
  customer_control t0
WHERE
  t0.user_id = ?
  AND t0.finish = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.finish AS finish_2, t0.user_id AS user_id_3, t0.customer_id AS customer_id_4 FROM customer_control t0 WHERE t0.user_id = 709 AND t0.finish = 0 LIMIT 1;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.specialCustomer AS specialCustomer_3,
  u0_.generatePasswordRecovery AS generatePasswordRecovery_4,
  u0_.additionalPercentage AS additionalPercentage_5,
  u0_.name AS name_6,
  u0_.firstName AS firstName_7,
  u0_.address AS address_8,
  u0_.postal AS postal_9,
  u0_.locality AS locality_10,
  u0_.country AS country_11,
  u0_.phoneNumber AS phoneNumber_12,
  u0_.directPhone AS directPhone_13,
  u0_.otherMail AS otherMail_14,
  u0_.companyName AS companyName_15,
  u0_.active AS active_16,
  u0_.gender AS gender_17,
  u0_.userSupplementsPurchaseDecisionMaker AS userSupplementsPurchaseDecisionMaker_18,
  u0_.password AS password_19,
  a1_.id AS id_20,
  a1_.generalCondition AS generalCondition_21,
  a1_.storeSize AS storeSize_22,
  a1_.idClientMercator AS idClientMercator_23,
  a1_.customerCategoryMercator AS customerCategoryMercator_24,
  a1_.mercatorBE AS mercatorBE_25,
  a1_.mercatorLU AS mercatorLU_26,
  a1_.salesAreaForFoodSupplements AS salesAreaForFoodSupplements_27,
  a1_.companyAddress AS companyAddress_28,
  a1_.companyTypePro AS companyTypePro_29,
  a1_.ibanrib AS ibanrib_30,
  a1_.companyPostal AS companyPostal_31,
  a1_.townAddressCompany AS townAddressCompany_32,
  a1_.companyCountry AS companyCountry_33,
  a1_.ribPdf AS ribPdf_34,
  a1_.companyRibValidate AS companyRibValidate_35,
  a1_.legalForm AS legalForm_36,
  a1_.sirenNumber AS sirenNumber_37,
  a1_.siretNumber AS siretNumber_38,
  a1_.tva AS tva_39,
  a1_.rcs AS rcs_40,
  a1_.companyWebsite AS companyWebsite_41,
  a1_.companyName AS companyName_42,
  a1_.accountantGender AS accountantGender_43,
  a1_.accountantFirstName AS accountantFirstName_44,
  a1_.accountantLastName AS accountantLastName_45,
  a1_.accountantPhone AS accountantPhone_46,
  a1_.accountantMobilePhone AS accountantMobilePhone_47,
  a1_.accountantSupplementsPurchaseDecisionMaker AS accountantSupplementsPurchaseDecisionMaker_48,
  a1_.accountantEmail AS accountantEmail_49,
  a1_.therapistGender AS therapistGender_50,
  a1_.therapistFirstName AS therapistFirstName_51,
  a1_.therapistLastName AS therapistLastName_52,
  a1_.therapistPhone AS therapistPhone_53,
  a1_.therapistMobilePhone AS therapistMobilePhone_54,
  a1_.therapistEmail AS therapistEmail_55,
  a1_.therapistSupplementsPurchaseDecisionMaker AS therapistSupplementsPurchaseDecisionMaker_56,
  a1_.ceoGender AS ceoGender_57,
  a1_.ceoFirstName AS ceoFirstName_58,
  a1_.ceoLastName AS ceoLastName_59,
  a1_.ceoPhone AS ceoPhone_60,
  a1_.ceoMobilePhone AS ceoMobilePhone_61,
  a1_.ceoEmail AS ceoEmail_62,
  a1_.ceoSupplementsPurchaseDecisionMaker AS ceoSupplementsPurchaseDecisionMaker_63,
  d2_.id AS id_64,
  d2_.companyName AS companyName_65,
  d2_.name AS name_66,
  d2_.firstName AS firstName_67,
  d2_.address AS address_68,
  d2_.postal AS postal_69,
  d2_.town AS town_70,
  d2_.country AS country_71,
  d2_.phoneNumber AS phoneNumber_72,
  d2_.monday AS monday_73,
  d2_.morningMonday AS morningMonday_74,
  d2_.morningMondayEnd AS morningMondayEnd_75,
  d2_.afternoonMonday AS afternoonMonday_76,
  d2_.afternoonMondayEnd AS afternoonMondayEnd_77,
  d2_.tuesday AS tuesday_78,
  d2_.morningTuesday AS morningTuesday_79,
  d2_.morningTuesdayEnd AS morningTuesdayEnd_80,
  d2_.afternoonTuesday AS afternoonTuesday_81,
  d2_.afternoonTuesdayEnd AS afternoonTuesdayEnd_82,
  d2_.wednesday AS wednesday_83,
  d2_.morningWednesday AS morningWednesday_84,
  d2_.morningWednesdayEnd AS morningWednesdayEnd_85,
  d2_.afternoonWednesday AS afternoonWednesday_86,
  d2_.afternoonWednesdayEnd AS afternoonWednesdayEnd_87,
  d2_.thursday AS thursday_88,
  d2_.morningThursday AS morningThursday_89,
  d2_.morningThursdayEnd AS morningThursdayEnd_90,
  d2_.afternoonThursday AS afternoonThursday_91,
  d2_.afternoonThursdayeEnd AS afternoonThursdayeEnd_92,
  d2_.friday AS friday_93,
  d2_.morningFriday AS morningFriday_94,
  d2_.morningFridayEnd AS morningFridayEnd_95,
  d2_.afternoonFriday AS afternoonFriday_96,
  d2_.afternoonFridayEnd AS afternoonFridayEnd_97,
  d2_.saturday AS saturday_98,
  d2_.morningSaturday AS morningSaturday_99,
  d2_.morningSaturdayEnd AS morningSaturdayEnd_100,
  d2_.afternoonSaturday AS afternoonSaturday_101,
  d2_.afternoonSaturdayEnd AS afternoonSaturdayEnd_102,
  d2_.sunday AS sunday_103,
  d2_.morningSunday AS morningSunday_104,
  d2_.morningSundayEnd AS morningSundayEnd_105,
  d2_.afternoonSunday AS afternoonSunday_106,
  d2_.afternoonSundayEnd AS afternoonSundayEnd_107,
  d2_.hourlyMonday AS hourlyMonday_108,
  d2_.hourlyMorningMonday AS hourlyMorningMonday_109,
  d2_.hourlyMorningMondayEnd AS hourlyMorningMondayEnd_110,
  d2_.hourlyTuesday AS hourlyTuesday_111,
  d2_.hourlyMorningTuesday AS hourlyMorningTuesday_112,
  d2_.hourlyMorningTuesdayEnd AS hourlyMorningTuesdayEnd_113,
  d2_.hourlyWednesday AS hourlyWednesday_114,
  d2_.hourlyMorningWednesday AS hourlyMorningWednesday_115,
  d2_.hourlyMorningWednesdayEnd AS hourlyMorningWednesdayEnd_116,
  d2_.hourlyThursday AS hourlyThursday_117,
  d2_.hourlyMorningThursday AS hourlyMorningThursday_118,
  d2_.hourlyMorningThursdayEnd AS hourlyMorningThursdayEnd_119,
  d2_.hourlyFriday AS hourlyFriday_120,
  d2_.hourlyMorningFriday AS hourlyMorningFriday_121,
  d2_.hourlyMorningFridayEnd AS hourlyMorningFridayEnd_122,
  d2_.hourlySaturday AS hourlySaturday_123,
  d2_.hourlyMorningSaturday AS hourlyMorningSaturday_124,
  d2_.hourlyMorningSaturdayEnd AS hourlyMorningSaturdayEnd_125,
  d2_.hourlySunday AS hourlySunday_126,
  d2_.hourlyMorningSunday AS hourlyMorningSunday_127,
  d2_.hourlyMorningSundayEnd AS hourlyMorningSundayEnd_128,
  t3_.id AS id_129,
  t3_.tvaNumber AS tvaNumber_130
FROM
  user u0_
  LEFT JOIN additional_company_information a1_ ON u0_.id = a1_.user_id
  LEFT JOIN delivery_address d2_ ON u0_.id = d2_.user_id
  LEFT JOIN tva t3_ ON u0_.id = t3_.client_id

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.specialCustomer AS specialCustomer_3, u0_.generatePasswordRecovery AS generatePasswordRecovery_4, u0_.additionalPercentage AS additionalPercentage_5, u0_.name AS name_6, u0_.firstName AS firstName_7, u0_.address AS address_8, u0_.postal AS postal_9, u0_.locality AS locality_10, u0_.country AS country_11, u0_.phoneNumber AS phoneNumber_12, u0_.directPhone AS directPhone_13, u0_.otherMail AS otherMail_14, u0_.companyName AS companyName_15, u0_.active AS active_16, u0_.gender AS gender_17, u0_.userSupplementsPurchaseDecisionMaker AS userSupplementsPurchaseDecisionMaker_18, u0_.password AS password_19, a1_.id AS id_20, a1_.generalCondition AS generalCondition_21, a1_.storeSize AS storeSize_22, a1_.idClientMercator AS idClientMercator_23, a1_.customerCategoryMercator AS customerCategoryMercator_24, a1_.mercatorBE AS mercatorBE_25, a1_.mercatorLU AS mercatorLU_26, a1_.salesAreaForFoodSupplements AS salesAreaForFoodSupplements_27, a1_.companyAddress AS companyAddress_28, a1_.companyTypePro AS companyTypePro_29, a1_.ibanrib AS ibanrib_30, a1_.companyPostal AS companyPostal_31, a1_.townAddressCompany AS townAddressCompany_32, a1_.companyCountry AS companyCountry_33, a1_.ribPdf AS ribPdf_34, a1_.companyRibValidate AS companyRibValidate_35, a1_.legalForm AS legalForm_36, a1_.sirenNumber AS sirenNumber_37, a1_.siretNumber AS siretNumber_38, a1_.tva AS tva_39, a1_.rcs AS rcs_40, a1_.companyWebsite AS companyWebsite_41, a1_.companyName AS companyName_42, a1_.accountantGender AS accountantGender_43, a1_.accountantFirstName AS accountantFirstName_44, a1_.accountantLastName AS accountantLastName_45, a1_.accountantPhone AS accountantPhone_46, a1_.accountantMobilePhone AS accountantMobilePhone_47, a1_.accountantSupplementsPurchaseDecisionMaker AS accountantSupplementsPurchaseDecisionMaker_48, a1_.accountantEmail AS accountantEmail_49, a1_.therapistGender AS therapistGender_50, a1_.therapistFirstName AS therapistFirstName_51, a1_.therapistLastName AS therapistLastName_52, a1_.therapistPhone AS therapistPhone_53, a1_.therapistMobilePhone AS therapistMobilePhone_54, a1_.therapistEmail AS therapistEmail_55, a1_.therapistSupplementsPurchaseDecisionMaker AS therapistSupplementsPurchaseDecisionMaker_56, a1_.ceoGender AS ceoGender_57, a1_.ceoFirstName AS ceoFirstName_58, a1_.ceoLastName AS ceoLastName_59, a1_.ceoPhone AS ceoPhone_60, a1_.ceoMobilePhone AS ceoMobilePhone_61, a1_.ceoEmail AS ceoEmail_62, a1_.ceoSupplementsPurchaseDecisionMaker AS ceoSupplementsPurchaseDecisionMaker_63, d2_.id AS id_64, d2_.companyName AS companyName_65, d2_.name AS name_66, d2_.firstName AS firstName_67, d2_.address AS address_68, d2_.postal AS postal_69, d2_.town AS town_70, d2_.country AS country_71, d2_.phoneNumber AS phoneNumber_72, d2_.monday AS monday_73, d2_.morningMonday AS morningMonday_74, d2_.morningMondayEnd AS morningMondayEnd_75, d2_.afternoonMonday AS afternoonMonday_76, d2_.afternoonMondayEnd AS afternoonMondayEnd_77, d2_.tuesday AS tuesday_78, d2_.morningTuesday AS morningTuesday_79, d2_.morningTuesdayEnd AS morningTuesdayEnd_80, d2_.afternoonTuesday AS afternoonTuesday_81, d2_.afternoonTuesdayEnd AS afternoonTuesdayEnd_82, d2_.wednesday AS wednesday_83, d2_.morningWednesday AS morningWednesday_84, d2_.morningWednesdayEnd AS morningWednesdayEnd_85, d2_.afternoonWednesday AS afternoonWednesday_86, d2_.afternoonWednesdayEnd AS afternoonWednesdayEnd_87, d2_.thursday AS thursday_88, d2_.morningThursday AS morningThursday_89, d2_.morningThursdayEnd AS morningThursdayEnd_90, d2_.afternoonThursday AS afternoonThursday_91, d2_.afternoonThursdayeEnd AS afternoonThursdayeEnd_92, d2_.friday AS friday_93, d2_.morningFriday AS morningFriday_94, d2_.morningFridayEnd AS morningFridayEnd_95, d2_.afternoonFriday AS afternoonFriday_96, d2_.afternoonFridayEnd AS afternoonFridayEnd_97, d2_.saturday AS saturday_98, d2_.morningSaturday AS morningSaturday_99, d2_.morningSaturdayEnd AS morningSaturdayEnd_100, d2_.afternoonSaturday AS afternoonSaturday_101, d2_.afternoonSaturdayEnd AS afternoonSaturdayEnd_102, d2_.sunday AS sunday_103, d2_.morningSunday AS morningSunday_104, d2_.morningSundayEnd AS morningSundayEnd_105, d2_.afternoonSunday AS afternoonSunday_106, d2_.afternoonSundayEnd AS afternoonSundayEnd_107, d2_.hourlyMonday AS hourlyMonday_108, d2_.hourlyMorningMonday AS hourlyMorningMonday_109, d2_.hourlyMorningMondayEnd AS hourlyMorningMondayEnd_110, d2_.hourlyTuesday AS hourlyTuesday_111, d2_.hourlyMorningTuesday AS hourlyMorningTuesday_112, d2_.hourlyMorningTuesdayEnd AS hourlyMorningTuesdayEnd_113, d2_.hourlyWednesday AS hourlyWednesday_114, d2_.hourlyMorningWednesday AS hourlyMorningWednesday_115, d2_.hourlyMorningWednesdayEnd AS hourlyMorningWednesdayEnd_116, d2_.hourlyThursday AS hourlyThursday_117, d2_.hourlyMorningThursday AS hourlyMorningThursday_118, d2_.hourlyMorningThursdayEnd AS hourlyMorningThursdayEnd_119, d2_.hourlyFriday AS hourlyFriday_120, d2_.hourlyMorningFriday AS hourlyMorningFriday_121, d2_.hourlyMorningFridayEnd AS hourlyMorningFridayEnd_122, d2_.hourlySaturday AS hourlySaturday_123, d2_.hourlyMorningSaturday AS hourlyMorningSaturday_124, d2_.hourlyMorningSaturdayEnd AS hourlyMorningSaturdayEnd_125, d2_.hourlySunday AS hourlySunday_126, d2_.hourlyMorningSunday AS hourlyMorningSunday_127, d2_.hourlyMorningSundayEnd AS hourlyMorningSundayEnd_128, t3_.id AS id_129, t3_.tvaNumber AS tvaNumber_130 FROM user u0_ LEFT JOIN additional_company_information a1_ ON u0_.id = a1_.user_id LEFT JOIN delivery_address d2_ ON u0_.id = d2_.user_id LEFT JOIN tva t3_ ON u0_.id = t3_.client_id;

SELECT
  t0.id AS id_1,
  t0.generalCondition AS generalCondition_2,
  t0.storeSize AS storeSize_3,
  t0.idClientMercator AS idClientMercator_4,
  t0.customerCategoryMercator AS customerCategoryMercator_5,
  t0.mercatorBE AS mercatorBE_6,
  t0.mercatorLU AS mercatorLU_7,
  t0.salesAreaForFoodSupplements AS salesAreaForFoodSupplements_8,
  t0.companyAddress AS companyAddress_9,
  t0.companyTypePro AS companyTypePro_10,
  t0.ibanrib AS ibanrib_11,
  t0.companyPostal AS companyPostal_12,
  t0.townAddressCompany AS townAddressCompany_13,
  t0.companyCountry AS companyCountry_14,
  t0.ribPdf AS ribPdf_15,
  t0.companyRibValidate AS companyRibValidate_16,
  t0.legalForm AS legalForm_17,
  t0.sirenNumber AS sirenNumber_18,
  t0.siretNumber AS siretNumber_19,
  t0.tva AS tva_20,
  t0.rcs AS rcs_21,
  t0.companyWebsite AS companyWebsite_22,
  t0.companyName AS companyName_23,
  t0.accountantGender AS accountantGender_24,
  t0.accountantFirstName AS accountantFirstName_25,
  t0.accountantLastName AS accountantLastName_26,
  t0.accountantPhone AS accountantPhone_27,
  t0.accountantMobilePhone AS accountantMobilePhone_28,
  t0.accountantSupplementsPurchaseDecisionMaker AS accountantSupplementsPurchaseDecisionMaker_29,
  t0.accountantEmail AS accountantEmail_30,
  t0.therapistGender AS therapistGender_31,
  t0.therapistFirstName AS therapistFirstName_32,
  t0.therapistLastName AS therapistLastName_33,
  t0.therapistPhone AS therapistPhone_34,
  t0.therapistMobilePhone AS therapistMobilePhone_35,
  t0.therapistEmail AS therapistEmail_36,
  t0.therapistSupplementsPurchaseDecisionMaker AS therapistSupplementsPurchaseDecisionMaker_37,
  t0.ceoGender AS ceoGender_38,
  t0.ceoFirstName AS ceoFirstName_39,
  t0.ceoLastName AS ceoLastName_40,
  t0.ceoPhone AS ceoPhone_41,
  t0.ceoMobilePhone AS ceoMobilePhone_42,
  t0.ceoEmail AS ceoEmail_43,
  t0.ceoSupplementsPurchaseDecisionMaker AS ceoSupplementsPurchaseDecisionMaker_44,
  t0.user_id AS user_id_45,
  t46.id AS id_47,
  t46.email AS email_48,
  t46.roles AS roles_49,
  t46.specialCustomer AS specialCustomer_50,
  t46.generatePasswordRecovery AS generatePasswordRecovery_51,
  t46.additionalPercentage AS additionalPercentage_52,
  t46.name AS name_53,
  t46.firstName AS firstName_54,
  t46.address AS address_55,
  t46.postal AS postal_56,
  t46.locality AS locality_57,
  t46.country AS country_58,
  t46.phoneNumber AS phoneNumber_59,
  t46.directPhone AS directPhone_60,
  t46.otherMail AS otherMail_61,
  t46.companyName AS companyName_62,
  t46.active AS active_63,
  t46.gender AS gender_64,
  t46.userSupplementsPurchaseDecisionMaker AS userSupplementsPurchaseDecisionMaker_65,
  t46.password AS password_66
FROM
  additional_company_information t0
  LEFT JOIN user t46 ON t0.user_id = t46.id
WHERE
  t0.user_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.generalCondition AS generalCondition_2, t0.storeSize AS storeSize_3, t0.idClientMercator AS idClientMercator_4, t0.customerCategoryMercator AS customerCategoryMercator_5, t0.mercatorBE AS mercatorBE_6, t0.mercatorLU AS mercatorLU_7, t0.salesAreaForFoodSupplements AS salesAreaForFoodSupplements_8, t0.companyAddress AS companyAddress_9, t0.companyTypePro AS companyTypePro_10, t0.ibanrib AS ibanrib_11, t0.companyPostal AS companyPostal_12, t0.townAddressCompany AS townAddressCompany_13, t0.companyCountry AS companyCountry_14, t0.ribPdf AS ribPdf_15, t0.companyRibValidate AS companyRibValidate_16, t0.legalForm AS legalForm_17, t0.sirenNumber AS sirenNumber_18, t0.siretNumber AS siretNumber_19, t0.tva AS tva_20, t0.rcs AS rcs_21, t0.companyWebsite AS companyWebsite_22, t0.companyName AS companyName_23, t0.accountantGender AS accountantGender_24, t0.accountantFirstName AS accountantFirstName_25, t0.accountantLastName AS accountantLastName_26, t0.accountantPhone AS accountantPhone_27, t0.accountantMobilePhone AS accountantMobilePhone_28, t0.accountantSupplementsPurchaseDecisionMaker AS accountantSupplementsPurchaseDecisionMaker_29, t0.accountantEmail AS accountantEmail_30, t0.therapistGender AS therapistGender_31, t0.therapistFirstName AS therapistFirstName_32, t0.therapistLastName AS therapistLastName_33, t0.therapistPhone AS therapistPhone_34, t0.therapistMobilePhone AS therapistMobilePhone_35, t0.therapistEmail AS therapistEmail_36, t0.therapistSupplementsPurchaseDecisionMaker AS therapistSupplementsPurchaseDecisionMaker_37, t0.ceoGender AS ceoGender_38, t0.ceoFirstName AS ceoFirstName_39, t0.ceoLastName AS ceoLastName_40, t0.ceoPhone AS ceoPhone_41, t0.ceoMobilePhone AS ceoMobilePhone_42, t0.ceoEmail AS ceoEmail_43, t0.ceoSupplementsPurchaseDecisionMaker AS ceoSupplementsPurchaseDecisionMaker_44, t0.user_id AS user_id_45, t46.id AS id_47, t46.email AS email_48, t46.roles AS roles_49, t46.specialCustomer AS specialCustomer_50, t46.generatePasswordRecovery AS generatePasswordRecovery_51, t46.additionalPercentage AS additionalPercentage_52, t46.name AS name_53, t46.firstName AS firstName_54, t46.address AS address_55, t46.postal AS postal_56, t46.locality AS locality_57, t46.country AS country_58, t46.phoneNumber AS phoneNumber_59, t46.directPhone AS directPhone_60, t46.otherMail AS otherMail_61, t46.companyName AS companyName_62, t46.active AS active_63, t46.gender AS gender_64, t46.userSupplementsPurchaseDecisionMaker AS userSupplementsPurchaseDecisionMaker_65, t46.password AS password_66 FROM additional_company_information t0 LEFT JOIN user t46 ON t0.user_id = t46.id WHERE t0.user_id = 709 LIMIT 1;

SELECT
  r0_.id AS id_0,
  r0_.min AS min_1,
  r0_.max AS max_2,
  r0_.pourcentRebate AS pourcentRebate_3,
  r0_.status AS status_4,
  r0_.excluded_products AS excluded_products_5,
  r0_.specific_products AS specific_products_6
FROM
  rebate r0_
WHERE
  r0_.status = 1
  AND r0_.specific_products IS NULL
ORDER BY
  r0_.min DESC

SELECT r0_.id AS id_0, r0_.min AS min_1, r0_.max AS max_2, r0_.pourcentRebate AS pourcentRebate_3, r0_.status AS status_4, r0_.excluded_products AS excluded_products_5, r0_.specific_products AS specific_products_6 FROM rebate r0_ WHERE r0_.status = 1 AND r0_.specific_products IS NULL ORDER BY r0_.min DESC;

SELECT
  c0_.id AS id_0,
  c0_.finish AS finish_1,
  c0_.commandNumber AS commandNumber_2,
  c0_.quantity AS quantity_3,
  c0_.message AS message_4,
  SUM(c0_.quantity) AS sclr_5,
  c0_.commandNumber AS commandNumber_6,
  c0_.id AS id_7,
  p1_.id AS id_8,
  p1_.idProductOnMercator AS idProductOnMercator_9,
  p1_.nameFr AS nameFr_10,
  p1_.brand AS brand_11,
  p1_.price AS price_12,
  p1_.image AS image_13,
  p1_.reference AS reference_14,
  p1_.publicPrice AS publicPrice_15,
  p1_.publicPriceHtva AS publicPriceHtva_16,
  p1_.tvaBe AS tvaBe_17,
  p1_.tvaFr AS tvaFr_18,
  p1_.tvaLu AS tvaLu_19,
  p1_.cnk AS cnk_20,
  p1_.nut AS nut_21,
  p1_.ean AS ean_22,
  p1_.actionShock AS actionShock_23,
  a2_.discountPercent AS discountPercent_24,
  a2_.type AS type_25,
  SUM(c0_.quantity * p1_.price) AS sclr_26,
  SUM(c0_.quantity * p1_.publicPrice) AS sclr_27,
  s3_.id AS id_28,
  s3_.pourcentRebate AS pourcentRebate_29
FROM
  cart c0_
  LEFT JOIN products p1_ ON c0_.products_id = p1_.id
  LEFT JOIN special_discount s3_ ON p1_.id = s3_.product_id
  LEFT JOIN action_shock a2_ ON p1_.id = a2_.product_id
  AND (
    CURRENT_TIMESTAMP >= a2_.dateStart
    AND CURRENT_TIMESTAMP <= DATE_ADD(a2_.dateEnd, INTERVAL 1 DAY)
  )
WHERE
  c0_.user_id = ?
  AND c0_.finish = 0
GROUP BY
  p1_.id

SELECT c0_.id AS id_0, c0_.finish AS finish_1, c0_.commandNumber AS commandNumber_2, c0_.quantity AS quantity_3, c0_.message AS message_4, SUM(c0_.quantity) AS sclr_5, c0_.commandNumber AS commandNumber_6, c0_.id AS id_7, p1_.id AS id_8, p1_.idProductOnMercator AS idProductOnMercator_9, p1_.nameFr AS nameFr_10, p1_.brand AS brand_11, p1_.price AS price_12, p1_.image AS image_13, p1_.reference AS reference_14, p1_.publicPrice AS publicPrice_15, p1_.publicPriceHtva AS publicPriceHtva_16, p1_.tvaBe AS tvaBe_17, p1_.tvaFr AS tvaFr_18, p1_.tvaLu AS tvaLu_19, p1_.cnk AS cnk_20, p1_.nut AS nut_21, p1_.ean AS ean_22, p1_.actionShock AS actionShock_23, a2_.discountPercent AS discountPercent_24, a2_.type AS type_25, SUM(c0_.quantity * p1_.price) AS sclr_26, SUM(c0_.quantity * p1_.publicPrice) AS sclr_27, s3_.id AS id_28, s3_.pourcentRebate AS pourcentRebate_29 FROM cart c0_ LEFT JOIN products p1_ ON c0_.products_id = p1_.id LEFT JOIN special_discount s3_ ON p1_.id = s3_.product_id LEFT JOIN action_shock a2_ ON p1_.id = a2_.product_id AND (CURRENT_TIMESTAMP >= a2_.dateStart AND CURRENT_TIMESTAMP <= DATE_ADD(a2_.dateEnd, INTERVAL 1 DAY)) WHERE c0_.user_id = 709 AND c0_.finish = 0 GROUP BY p1_.id;

SELECT
  t0.id AS id_1,
  t0.finish AS finish_2,
  t0.commandNumber AS commandNumber_3,
  t0.quantity AS quantity_4,
  t0.message AS message_5,
  t0.user_id AS user_id_6,
  t0.products_id AS products_id_7,
  t8.id AS id_9,
  t8.nameFr AS nameFr_10,
  t8.nameBe AS nameBe_11,
  t8.description AS description_12,
  t8.price AS price_13,
  t8.pricePharmacy AS pricePharmacy_14,
  t8.capacity AS capacity_15,
  t8.quantity AS quantity_16,
  t8.useCouncil AS useCouncil_17,
  t8.contraindication AS contraindication_18,
  t8.ingredient AS ingredient_19,
  t8.nutritionChart AS nutritionChart_20,
  t8.image AS image_21,
  t8.status AS status_22,
  t8.tools AS tools_23,
  t8.publicPrice AS publicPrice_24,
  t8.publicPriceHtva AS publicPriceHtva_25,
  t8.consumptionTime AS consumptionTime_26,
  t8.brand AS brand_27,
  t8.idOnNaturaSite AS idOnNaturaSite_28,
  t8.idProductFeatureOnNatura AS idProductFeatureOnNatura_29,
  t8.idProductOnMercator AS idProductOnMercator_30,
  t8.reference AS reference_31,
  t8.idStockAvailables AS idStockAvailables_32,
  t8.cnk AS cnk_33,
  t8.nut AS nut_34,
  t8.ean AS ean_35,
  t8.eanImage AS eanImage_36,
  t8.eanImageBase64 AS eanImageBase64_37,
  t8.tvaBe AS tvaBe_38,
  t8.tvaFr AS tvaFr_39,
  t8.tvaLu AS tvaLu_40,
  t8.saleFr AS saleFr_41,
  t8.saleBe AS saleBe_42,
  t8.saleLux AS saleLux_43,
  t8.actionShock AS actionShock_44
FROM
  cart t0
  LEFT JOIN products t8 ON t0.products_id = t8.id
WHERE
  t0.finish = ?
  AND t0.user_id = ?

SELECT t0.id AS id_1, t0.finish AS finish_2, t0.commandNumber AS commandNumber_3, t0.quantity AS quantity_4, t0.message AS message_5, t0.user_id AS user_id_6, t0.products_id AS products_id_7, t8.id AS id_9, t8.nameFr AS nameFr_10, t8.nameBe AS nameBe_11, t8.description AS description_12, t8.price AS price_13, t8.pricePharmacy AS pricePharmacy_14, t8.capacity AS capacity_15, t8.quantity AS quantity_16, t8.useCouncil AS useCouncil_17, t8.contraindication AS contraindication_18, t8.ingredient AS ingredient_19, t8.nutritionChart AS nutritionChart_20, t8.image AS image_21, t8.status AS status_22, t8.tools AS tools_23, t8.publicPrice AS publicPrice_24, t8.publicPriceHtva AS publicPriceHtva_25, t8.consumptionTime AS consumptionTime_26, t8.brand AS brand_27, t8.idOnNaturaSite AS idOnNaturaSite_28, t8.idProductFeatureOnNatura AS idProductFeatureOnNatura_29, t8.idProductOnMercator AS idProductOnMercator_30, t8.reference AS reference_31, t8.idStockAvailables AS idStockAvailables_32, t8.cnk AS cnk_33, t8.nut AS nut_34, t8.ean AS ean_35, t8.eanImage AS eanImage_36, t8.eanImageBase64 AS eanImageBase64_37, t8.tvaBe AS tvaBe_38, t8.tvaFr AS tvaFr_39, t8.tvaLu AS tvaLu_40, t8.saleFr AS saleFr_41, t8.saleBe AS saleBe_42, t8.saleLux AS saleLux_43, t8.actionShock AS actionShock_44 FROM cart t0 LEFT JOIN products t8 ON t0.products_id = t8.id WHERE t0.finish = 0 AND t0.user_id = 709;

SELECT
  t0.id AS id_1,
  t0.dateStart AS dateStart_2,
  t0.dateEnd AS dateEnd_3,
  t0.numberJoker AS numberJoker_4,
  t0.user_id AS user_id_5
FROM
  joker t0
WHERE
  t0.user_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.dateStart AS dateStart_2, t0.dateEnd AS dateEnd_3, t0.numberJoker AS numberJoker_4, t0.user_id AS user_id_5 FROM joker t0 WHERE t0.user_id = 709 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.finish AS finish_2,
  t0.commandNumber AS commandNumber_3,
  t0.quantity AS quantity_4,
  t0.message AS message_5,
  t0.user_id AS user_id_6,
  t0.products_id AS products_id_7,
  t8.id AS id_9,
  t8.nameFr AS nameFr_10,
  t8.nameBe AS nameBe_11,
  t8.description AS description_12,
  t8.price AS price_13,
  t8.pricePharmacy AS pricePharmacy_14,
  t8.capacity AS capacity_15,
  t8.quantity AS quantity_16,
  t8.useCouncil AS useCouncil_17,
  t8.contraindication AS contraindication_18,
  t8.ingredient AS ingredient_19,
  t8.nutritionChart AS nutritionChart_20,
  t8.image AS image_21,
  t8.status AS status_22,
  t8.tools AS tools_23,
  t8.publicPrice AS publicPrice_24,
  t8.publicPriceHtva AS publicPriceHtva_25,
  t8.consumptionTime AS consumptionTime_26,
  t8.brand AS brand_27,
  t8.idOnNaturaSite AS idOnNaturaSite_28,
  t8.idProductFeatureOnNatura AS idProductFeatureOnNatura_29,
  t8.idProductOnMercator AS idProductOnMercator_30,
  t8.reference AS reference_31,
  t8.idStockAvailables AS idStockAvailables_32,
  t8.cnk AS cnk_33,
  t8.nut AS nut_34,
  t8.ean AS ean_35,
  t8.eanImage AS eanImage_36,
  t8.eanImageBase64 AS eanImageBase64_37,
  t8.tvaBe AS tvaBe_38,
  t8.tvaFr AS tvaFr_39,
  t8.tvaLu AS tvaLu_40,
  t8.saleFr AS saleFr_41,
  t8.saleBe AS saleBe_42,
  t8.saleLux AS saleLux_43,
  t8.actionShock AS actionShock_44
FROM
  cart t0
  LEFT JOIN products t8 ON t0.products_id = t8.id
WHERE
  t0.user_id = ?
  AND t0.finish = ?

SELECT t0.id AS id_1, t0.finish AS finish_2, t0.commandNumber AS commandNumber_3, t0.quantity AS quantity_4, t0.message AS message_5, t0.user_id AS user_id_6, t0.products_id AS products_id_7, t8.id AS id_9, t8.nameFr AS nameFr_10, t8.nameBe AS nameBe_11, t8.description AS description_12, t8.price AS price_13, t8.pricePharmacy AS pricePharmacy_14, t8.capacity AS capacity_15, t8.quantity AS quantity_16, t8.useCouncil AS useCouncil_17, t8.contraindication AS contraindication_18, t8.ingredient AS ingredient_19, t8.nutritionChart AS nutritionChart_20, t8.image AS image_21, t8.status AS status_22, t8.tools AS tools_23, t8.publicPrice AS publicPrice_24, t8.publicPriceHtva AS publicPriceHtva_25, t8.consumptionTime AS consumptionTime_26, t8.brand AS brand_27, t8.idOnNaturaSite AS idOnNaturaSite_28, t8.idProductFeatureOnNatura AS idProductFeatureOnNatura_29, t8.idProductOnMercator AS idProductOnMercator_30, t8.reference AS reference_31, t8.idStockAvailables AS idStockAvailables_32, t8.cnk AS cnk_33, t8.nut AS nut_34, t8.ean AS ean_35, t8.eanImage AS eanImage_36, t8.eanImageBase64 AS eanImageBase64_37, t8.tvaBe AS tvaBe_38, t8.tvaFr AS tvaFr_39, t8.tvaLu AS tvaLu_40, t8.saleFr AS saleFr_41, t8.saleBe AS saleBe_42, t8.saleLux AS saleLux_43, t8.actionShock AS actionShock_44 FROM cart t0 LEFT JOIN products t8 ON t0.products_id = t8.id WHERE t0.user_id = 709 AND t0.finish = 0;

SELECT
  t0.id AS id_1,
  t0.francoDelivery AS francoDelivery_2,
  t0.costDelivery AS costDelivery_3,
  t0.numberJoker AS numberJoker_4,
  t0.actionShock AS actionShock_5,
  t0.pourcentSpecialCustomer AS pourcentSpecialCustomer_6
FROM
  config_site t0

SELECT t0.id AS id_1, t0.francoDelivery AS francoDelivery_2, t0.costDelivery AS costDelivery_3, t0.numberJoker AS numberJoker_4, t0.actionShock AS actionShock_5, t0.pourcentSpecialCustomer AS pourcentSpecialCustomer_6 FROM config_site t0;