Symfony Profiler

[
  "route" => "accueil"
  "route_parameters" => [
    "_route" => "accueil"
    "_controller" => "App\Controller\AccueilController::index"
  ]
  "request_uri" => "https://b2bnaturamedicatrix.com/"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 1
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "bbnatudpro.mysql.db"
    "port" => null
    "user" => "bbnatudpro"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "bbnatudpro"
    "serverVersion" => "8.0.32"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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"
]

[
  "sql" => "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"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.brandName AS brandName_2, t0.rebateLow AS rebateLow_3, t0.rebateHeigh AS rebateHeigh_4, t0.active AS active_5 FROM brand_discount t0 WHERE t0.active = ? AND t0.brandName = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => "NaturaMedicatrix"
  ]
  "types" => [
    1 => 5
    2 => 2
  ]
]

[
  "sql" => "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"
]

[
  "sql" => "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"
  "params" => [
    1 => 0
  ]
  "types" => [
    1 => 5
  ]
]

[
  "event" => "kernel.controller"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "App\EventSubscriber\TwigEventSubscriber::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]