Symfony Profiler

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
  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
  b0_.id AS id_0,
  b0_.brandName AS brandName_1,
  b0_.rebateLow AS rebateLow_2,
  b0_.rebateHeigh AS rebateHeigh_3,
  b0_.active AS active_4
FROM
  brand_discount b0_
WHERE
  b0_.active = 1
  AND LOWER(b0_.brandName) = ?
LIMIT
  1

SELECT b0_.id AS id_0, b0_.brandName AS brandName_1, b0_.rebateLow AS rebateLow_2, b0_.rebateHeigh AS rebateHeigh_3, b0_.active AS active_4 FROM brand_discount b0_ WHERE b0_.active = 1 AND LOWER(b0_.brandName) = 'naturamedicatrix' 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_.resetToken AS resetToken_5,
  u0_.resetTokenExpiresAt AS resetTokenExpiresAt_6,
  u0_.additionalPercentage AS additionalPercentage_7,
  u0_.name AS name_8,
  u0_.firstName AS firstName_9,
  u0_.address AS address_10,
  u0_.postal AS postal_11,
  u0_.locality AS locality_12,
  u0_.country AS country_13,
  u0_.phoneNumber AS phoneNumber_14,
  u0_.directPhone AS directPhone_15,
  u0_.otherMail AS otherMail_16,
  u0_.companyName AS companyName_17,
  u0_.active AS active_18,
  u0_.gender AS gender_19,
  u0_.userSupplementsPurchaseDecisionMaker AS userSupplementsPurchaseDecisionMaker_20,
  u0_.password AS password_21,
  a1_.id AS id_22,
  a1_.generalCondition AS generalCondition_23,
  a1_.storeSize AS storeSize_24,
  a1_.idClientMercator AS idClientMercator_25,
  a1_.customerCategoryMercator AS customerCategoryMercator_26,
  a1_.mercatorBE AS mercatorBE_27,
  a1_.mercatorLU AS mercatorLU_28,
  a1_.salesAreaForFoodSupplements AS salesAreaForFoodSupplements_29,
  a1_.companyAddress AS companyAddress_30,
  a1_.companyTypePro AS companyTypePro_31,
  a1_.ibanrib AS ibanrib_32,
  a1_.companyPostal AS companyPostal_33,
  a1_.townAddressCompany AS townAddressCompany_34,
  a1_.companyCountry AS companyCountry_35,
  a1_.ribPdf AS ribPdf_36,
  a1_.companyRibValidate AS companyRibValidate_37,
  a1_.legalForm AS legalForm_38,
  a1_.sirenNumber AS sirenNumber_39,
  a1_.siretNumber AS siretNumber_40,
  a1_.tva AS tva_41,
  a1_.rcs AS rcs_42,
  a1_.companyWebsite AS companyWebsite_43,
  a1_.companyName AS companyName_44,
  a1_.accountantGender AS accountantGender_45,
  a1_.accountantFirstName AS accountantFirstName_46,
  a1_.accountantLastName AS accountantLastName_47,
  a1_.accountantPhone AS accountantPhone_48,
  a1_.accountantMobilePhone AS accountantMobilePhone_49,
  a1_.accountantSupplementsPurchaseDecisionMaker AS accountantSupplementsPurchaseDecisionMaker_50,
  a1_.accountantEmail AS accountantEmail_51,
  a1_.therapistGender AS therapistGender_52,
  a1_.therapistFirstName AS therapistFirstName_53,
  a1_.therapistLastName AS therapistLastName_54,
  a1_.therapistPhone AS therapistPhone_55,
  a1_.therapistMobilePhone AS therapistMobilePhone_56,
  a1_.therapistEmail AS therapistEmail_57,
  a1_.therapistSupplementsPurchaseDecisionMaker AS therapistSupplementsPurchaseDecisionMaker_58,
  a1_.ceoGender AS ceoGender_59,
  a1_.ceoFirstName AS ceoFirstName_60,
  a1_.ceoLastName AS ceoLastName_61,
  a1_.ceoPhone AS ceoPhone_62,
  a1_.ceoMobilePhone AS ceoMobilePhone_63,
  a1_.ceoEmail AS ceoEmail_64,
  a1_.ceoSupplementsPurchaseDecisionMaker AS ceoSupplementsPurchaseDecisionMaker_65,
  d2_.id AS id_66,
  d2_.companyName AS companyName_67,
  d2_.name AS name_68,
  d2_.firstName AS firstName_69,
  d2_.address AS address_70,
  d2_.postal AS postal_71,
  d2_.town AS town_72,
  d2_.country AS country_73,
  d2_.phoneNumber AS phoneNumber_74,
  d2_.monday AS monday_75,
  d2_.morningMonday AS morningMonday_76,
  d2_.morningMondayEnd AS morningMondayEnd_77,
  d2_.afternoonMonday AS afternoonMonday_78,
  d2_.afternoonMondayEnd AS afternoonMondayEnd_79,
  d2_.tuesday AS tuesday_80,
  d2_.morningTuesday AS morningTuesday_81,
  d2_.morningTuesdayEnd AS morningTuesdayEnd_82,
  d2_.afternoonTuesday AS afternoonTuesday_83,
  d2_.afternoonTuesdayEnd AS afternoonTuesdayEnd_84,
  d2_.wednesday AS wednesday_85,
  d2_.morningWednesday AS morningWednesday_86,
  d2_.morningWednesdayEnd AS morningWednesdayEnd_87,
  d2_.afternoonWednesday AS afternoonWednesday_88,
  d2_.afternoonWednesdayEnd AS afternoonWednesdayEnd_89,
  d2_.thursday AS thursday_90,
  d2_.morningThursday AS morningThursday_91,
  d2_.morningThursdayEnd AS morningThursdayEnd_92,
  d2_.afternoonThursday AS afternoonThursday_93,
  d2_.afternoonThursdayeEnd AS afternoonThursdayeEnd_94,
  d2_.friday AS friday_95,
  d2_.morningFriday AS morningFriday_96,
  d2_.morningFridayEnd AS morningFridayEnd_97,
  d2_.afternoonFriday AS afternoonFriday_98,
  d2_.afternoonFridayEnd AS afternoonFridayEnd_99,
  d2_.saturday AS saturday_100,
  d2_.morningSaturday AS morningSaturday_101,
  d2_.morningSaturdayEnd AS morningSaturdayEnd_102,
  d2_.afternoonSaturday AS afternoonSaturday_103,
  d2_.afternoonSaturdayEnd AS afternoonSaturdayEnd_104,
  d2_.sunday AS sunday_105,
  d2_.morningSunday AS morningSunday_106,
  d2_.morningSundayEnd AS morningSundayEnd_107,
  d2_.afternoonSunday AS afternoonSunday_108,
  d2_.afternoonSundayEnd AS afternoonSundayEnd_109,
  d2_.hourlyMonday AS hourlyMonday_110,
  d2_.hourlyMorningMonday AS hourlyMorningMonday_111,
  d2_.hourlyMorningMondayEnd AS hourlyMorningMondayEnd_112,
  d2_.hourlyTuesday AS hourlyTuesday_113,
  d2_.hourlyMorningTuesday AS hourlyMorningTuesday_114,
  d2_.hourlyMorningTuesdayEnd AS hourlyMorningTuesdayEnd_115,
  d2_.hourlyWednesday AS hourlyWednesday_116,
  d2_.hourlyMorningWednesday AS hourlyMorningWednesday_117,
  d2_.hourlyMorningWednesdayEnd AS hourlyMorningWednesdayEnd_118,
  d2_.hourlyThursday AS hourlyThursday_119,
  d2_.hourlyMorningThursday AS hourlyMorningThursday_120,
  d2_.hourlyMorningThursdayEnd AS hourlyMorningThursdayEnd_121,
  d2_.hourlyFriday AS hourlyFriday_122,
  d2_.hourlyMorningFriday AS hourlyMorningFriday_123,
  d2_.hourlyMorningFridayEnd AS hourlyMorningFridayEnd_124,
  d2_.hourlySaturday AS hourlySaturday_125,
  d2_.hourlyMorningSaturday AS hourlyMorningSaturday_126,
  d2_.hourlyMorningSaturdayEnd AS hourlyMorningSaturdayEnd_127,
  d2_.hourlySunday AS hourlySunday_128,
  d2_.hourlyMorningSunday AS hourlyMorningSunday_129,
  d2_.hourlyMorningSundayEnd AS hourlyMorningSundayEnd_130,
  t3_.id AS id_131,
  t3_.tvaNumber AS tvaNumber_132
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_.resetToken AS resetToken_5, u0_.resetTokenExpiresAt AS resetTokenExpiresAt_6, u0_.additionalPercentage AS additionalPercentage_7, u0_.name AS name_8, u0_.firstName AS firstName_9, u0_.address AS address_10, u0_.postal AS postal_11, u0_.locality AS locality_12, u0_.country AS country_13, u0_.phoneNumber AS phoneNumber_14, u0_.directPhone AS directPhone_15, u0_.otherMail AS otherMail_16, u0_.companyName AS companyName_17, u0_.active AS active_18, u0_.gender AS gender_19, u0_.userSupplementsPurchaseDecisionMaker AS userSupplementsPurchaseDecisionMaker_20, u0_.password AS password_21, a1_.id AS id_22, a1_.generalCondition AS generalCondition_23, a1_.storeSize AS storeSize_24, a1_.idClientMercator AS idClientMercator_25, a1_.customerCategoryMercator AS customerCategoryMercator_26, a1_.mercatorBE AS mercatorBE_27, a1_.mercatorLU AS mercatorLU_28, a1_.salesAreaForFoodSupplements AS salesAreaForFoodSupplements_29, a1_.companyAddress AS companyAddress_30, a1_.companyTypePro AS companyTypePro_31, a1_.ibanrib AS ibanrib_32, a1_.companyPostal AS companyPostal_33, a1_.townAddressCompany AS townAddressCompany_34, a1_.companyCountry AS companyCountry_35, a1_.ribPdf AS ribPdf_36, a1_.companyRibValidate AS companyRibValidate_37, a1_.legalForm AS legalForm_38, a1_.sirenNumber AS sirenNumber_39, a1_.siretNumber AS siretNumber_40, a1_.tva AS tva_41, a1_.rcs AS rcs_42, a1_.companyWebsite AS companyWebsite_43, a1_.companyName AS companyName_44, a1_.accountantGender AS accountantGender_45, a1_.accountantFirstName AS accountantFirstName_46, a1_.accountantLastName AS accountantLastName_47, a1_.accountantPhone AS accountantPhone_48, a1_.accountantMobilePhone AS accountantMobilePhone_49, a1_.accountantSupplementsPurchaseDecisionMaker AS accountantSupplementsPurchaseDecisionMaker_50, a1_.accountantEmail AS accountantEmail_51, a1_.therapistGender AS therapistGender_52, a1_.therapistFirstName AS therapistFirstName_53, a1_.therapistLastName AS therapistLastName_54, a1_.therapistPhone AS therapistPhone_55, a1_.therapistMobilePhone AS therapistMobilePhone_56, a1_.therapistEmail AS therapistEmail_57, a1_.therapistSupplementsPurchaseDecisionMaker AS therapistSupplementsPurchaseDecisionMaker_58, a1_.ceoGender AS ceoGender_59, a1_.ceoFirstName AS ceoFirstName_60, a1_.ceoLastName AS ceoLastName_61, a1_.ceoPhone AS ceoPhone_62, a1_.ceoMobilePhone AS ceoMobilePhone_63, a1_.ceoEmail AS ceoEmail_64, a1_.ceoSupplementsPurchaseDecisionMaker AS ceoSupplementsPurchaseDecisionMaker_65, d2_.id AS id_66, d2_.companyName AS companyName_67, d2_.name AS name_68, d2_.firstName AS firstName_69, d2_.address AS address_70, d2_.postal AS postal_71, d2_.town AS town_72, d2_.country AS country_73, d2_.phoneNumber AS phoneNumber_74, d2_.monday AS monday_75, d2_.morningMonday AS morningMonday_76, d2_.morningMondayEnd AS morningMondayEnd_77, d2_.afternoonMonday AS afternoonMonday_78, d2_.afternoonMondayEnd AS afternoonMondayEnd_79, d2_.tuesday AS tuesday_80, d2_.morningTuesday AS morningTuesday_81, d2_.morningTuesdayEnd AS morningTuesdayEnd_82, d2_.afternoonTuesday AS afternoonTuesday_83, d2_.afternoonTuesdayEnd AS afternoonTuesdayEnd_84, d2_.wednesday AS wednesday_85, d2_.morningWednesday AS morningWednesday_86, d2_.morningWednesdayEnd AS morningWednesdayEnd_87, d2_.afternoonWednesday AS afternoonWednesday_88, d2_.afternoonWednesdayEnd AS afternoonWednesdayEnd_89, d2_.thursday AS thursday_90, d2_.morningThursday AS morningThursday_91, d2_.morningThursdayEnd AS morningThursdayEnd_92, d2_.afternoonThursday AS afternoonThursday_93, d2_.afternoonThursdayeEnd AS afternoonThursdayeEnd_94, d2_.friday AS friday_95, d2_.morningFriday AS morningFriday_96, d2_.morningFridayEnd AS morningFridayEnd_97, d2_.afternoonFriday AS afternoonFriday_98, d2_.afternoonFridayEnd AS afternoonFridayEnd_99, d2_.saturday AS saturday_100, d2_.morningSaturday AS morningSaturday_101, d2_.morningSaturdayEnd AS morningSaturdayEnd_102, d2_.afternoonSaturday AS afternoonSaturday_103, d2_.afternoonSaturdayEnd AS afternoonSaturdayEnd_104, d2_.sunday AS sunday_105, d2_.morningSunday AS morningSunday_106, d2_.morningSundayEnd AS morningSundayEnd_107, d2_.afternoonSunday AS afternoonSunday_108, d2_.afternoonSundayEnd AS afternoonSundayEnd_109, d2_.hourlyMonday AS hourlyMonday_110, d2_.hourlyMorningMonday AS hourlyMorningMonday_111, d2_.hourlyMorningMondayEnd AS hourlyMorningMondayEnd_112, d2_.hourlyTuesday AS hourlyTuesday_113, d2_.hourlyMorningTuesday AS hourlyMorningTuesday_114, d2_.hourlyMorningTuesdayEnd AS hourlyMorningTuesdayEnd_115, d2_.hourlyWednesday AS hourlyWednesday_116, d2_.hourlyMorningWednesday AS hourlyMorningWednesday_117, d2_.hourlyMorningWednesdayEnd AS hourlyMorningWednesdayEnd_118, d2_.hourlyThursday AS hourlyThursday_119, d2_.hourlyMorningThursday AS hourlyMorningThursday_120, d2_.hourlyMorningThursdayEnd AS hourlyMorningThursdayEnd_121, d2_.hourlyFriday AS hourlyFriday_122, d2_.hourlyMorningFriday AS hourlyMorningFriday_123, d2_.hourlyMorningFridayEnd AS hourlyMorningFridayEnd_124, d2_.hourlySaturday AS hourlySaturday_125, d2_.hourlyMorningSaturday AS hourlyMorningSaturday_126, d2_.hourlyMorningSaturdayEnd AS hourlyMorningSaturdayEnd_127, d2_.hourlySunday AS hourlySunday_128, d2_.hourlyMorningSunday AS hourlyMorningSunday_129, d2_.hourlyMorningSundayEnd AS hourlyMorningSundayEnd_130, t3_.id AS id_131, t3_.tvaNumber AS tvaNumber_132 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.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 IS NULL
  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 IS NULL AND t0.finish = 0 LIMIT 1;