Error 404 Not Found

GET https://b2bnaturamedicatrix.com/llms/

Browse referrer URL
IP
74.7.227.131
Profiled on
Token
9c39cc

Exceptions

ResourceNotFoundException NotFoundHttpException

HTTP 404 Not Found

No route found for "GET https://b2bnaturamedicatrix.com/llms/" (from "https://www.b2bnaturamedicatrix.com")

Exceptions 2

Symfony\Component\HttpKernel\Exception\ NotFoundHttpException

in vendor/symfony/http-kernel/EventListener/RouterListener.php (line 127)
  2.             if ($referer = $request->headers->get('referer')) {
  3.                 $message .= sprintf(' (from "%s")', $referer);
  4.             }
  6.             throw new NotFoundHttpException($message, $e);
  7.         } catch (MethodNotAllowedException $e) {
  8.             $message = sprintf('No route found for "%s %s": Method Not Allowed (Allow: %s)', $request->getMethod(), $request->getUriForPath($request->getPathInfo()), implode(', ', $e->getAllowedMethods()));
  10.             throw new MethodNotAllowedHttpException($e->getAllowedMethods(), $message, $e);
  11.         }
in vendor/symfony/event-dispatcher/Debug/WrappedListener.php -> onKernelRequest (line 116)
  1.         $this->priority ??= $dispatcher->getListenerPriority($eventName, $this->listener);
  3.         $e = $this->stopwatch->start($this->name, 'event_listener');
  5.         try {
  6.             ($this->optimizedListener ?? $this->listener)($event, $eventName, $dispatcher);
  7.         } finally {
  8.             if ($e->isStarted()) {
  9.                 $e->stop();
  10.             }
  11.         }
in vendor/symfony/event-dispatcher/EventDispatcher.php -> __invoke (line 206)
  2.         foreach ($listeners as $listener) {
  3.             if ($stoppable && $event->isPropagationStopped()) {
  4.                 break;
  5.             }
  6.             $listener($event, $eventName, $this);
  7.         }
  8.     }
  10.     /**
  11.      * Sorts the internal list of listeners for the given event by priority.
in vendor/symfony/event-dispatcher/EventDispatcher.php -> callListeners (line 56)
  1.         } else {
  2.             $listeners = $this->getListeners($eventName);
  3.         }
  5.         if ($listeners) {
  6.             $this->callListeners($listeners, $eventName, $event);
  7.         }
  9.         return $event;
  10.     }
in vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php -> dispatch (line 127)
  1.         try {
  2.             $this->beforeDispatch($eventName, $event);
  3.             try {
  4.                 $e = $this->stopwatch->start($eventName, 'section');
  5.                 try {
  6.                     $this->dispatcher->dispatch($event, $eventName);
  7.                 } finally {
  8.                     if ($e->isStarted()) {
  9.                         $e->stop();
  10.                     }
  11.                 }
in vendor/symfony/http-kernel/HttpKernel.php -> dispatch (line 139)
  1.      */
  2.     private function handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response
  3.     {
  4.         // request
  5.         $event = new RequestEvent($this, $request, $type);
  6.         $this->dispatcher->dispatch($event, KernelEvents::REQUEST);
  8.         if ($event->hasResponse()) {
  9.             return $this->filterResponse($event->getResponse(), $request, $type);
  10.         }
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/home/bbnatud/www/b2b/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  3. use App\Kernel;
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  7. return function (array $context) {
  8.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  9. };

Symfony\Component\Routing\Exception\ ResourceNotFoundException

No routes found for "/llms".

in vendor/symfony/routing/Matcher/Dumper/CompiledUrlMatcherTrait.php (line 74)
  1.             if ($allowSchemes) {
  2.                 goto redirect_scheme;
  3.             }
  4.         }
  6.         throw new ResourceNotFoundException(sprintf('No routes found for "%s".', $pathinfo));
  7.     }
  9.     private function doMatch(string $pathinfo, array &$allow = [], array &$allowSchemes = []): array
  10.     {
  11.         $allow = $allowSchemes = [];
in vendor/symfony/routing/Matcher/UrlMatcher.php -> match (line 94)
  2.     public function matchRequest(Request $request): array
  3.     {
  4.         $this->request = $request;
  6.         $ret = $this->match($request->getPathInfo());
  8.         $this->request = null;
  10.         return $ret;
  11.     }
in vendor/symfony/routing/Router.php -> matchRequest (line 225)
  1.         if (!$matcher instanceof RequestMatcherInterface) {
  2.             // fallback to the default UrlMatcherInterface
  3.             return $matcher->match($request->getPathInfo());
  4.         }
  6.         return $matcher->matchRequest($request);
  7.     }
  9.     /**
  10.      * Gets the UrlMatcher or RequestMatcher instance associated with this Router.
  11.      */
in vendor/symfony/http-kernel/EventListener/RouterListener.php -> matchRequest (line 105)
  2.         // add attributes based on the request (routing)
  3.         try {
  4.             // matching a request is more powerful than matching a URL path + context, so try that first
  5.             if ($this->matcher instanceof RequestMatcherInterface) {
  6.                 $parameters = $this->matcher->matchRequest($request);
  7.             } else {
  8.                 $parameters = $this->matcher->match($request->getPathInfo());
  9.             }
  11.             $this->logger?->info('Matched route "{route}".', [
in vendor/symfony/event-dispatcher/Debug/WrappedListener.php -> onKernelRequest (line 116)
  1.         $this->priority ??= $dispatcher->getListenerPriority($eventName, $this->listener);
  3.         $e = $this->stopwatch->start($this->name, 'event_listener');
  5.         try {
  6.             ($this->optimizedListener ?? $this->listener)($event, $eventName, $dispatcher);
  7.         } finally {
  8.             if ($e->isStarted()) {
  9.                 $e->stop();
  10.             }
  11.         }
in vendor/symfony/event-dispatcher/EventDispatcher.php -> __invoke (line 206)
  2.         foreach ($listeners as $listener) {
  3.             if ($stoppable && $event->isPropagationStopped()) {
  4.                 break;
  5.             }
  6.             $listener($event, $eventName, $this);
  7.         }
  8.     }
  10.     /**
  11.      * Sorts the internal list of listeners for the given event by priority.
in vendor/symfony/event-dispatcher/EventDispatcher.php -> callListeners (line 56)
  1.         } else {
  2.             $listeners = $this->getListeners($eventName);
  3.         }
  5.         if ($listeners) {
  6.             $this->callListeners($listeners, $eventName, $event);
  7.         }
  9.         return $event;
  10.     }
in vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php -> dispatch (line 127)
  1.         try {
  2.             $this->beforeDispatch($eventName, $event);
  3.             try {
  4.                 $e = $this->stopwatch->start($eventName, 'section');
  5.                 try {
  6.                     $this->dispatcher->dispatch($event, $eventName);
  7.                 } finally {
  8.                     if ($e->isStarted()) {
  9.                         $e->stop();
  10.                     }
  11.                 }
in vendor/symfony/http-kernel/HttpKernel.php -> dispatch (line 139)
  1.      */
  2.     private function handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response
  3.     {
  4.         // request
  5.         $event = new RequestEvent($this, $request, $type);
  6.         $this->dispatcher->dispatch($event, KernelEvents::REQUEST);
  8.         if ($event->hasResponse()) {
  9.             return $this->filterResponse($event->getResponse(), $request, $type);
  10.         }
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/home/bbnatud/www/b2b/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  3. use App\Kernel;
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  7. return function (array $context) {
  8.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  9. };

Logs

Level Channel Message
DEBUG 15:47:33 php Warning: Zend OPcache API is restricted by "restrict_api" configuration directive 
{
    "exception": {
        "severity": 2,
        "file": "/home/bbnatud/www/b2b/vendor/symfony/error-handler/DebugClassLoader.php",
        "line": 293,
        "trace": [
            {
                "file": "/home/bbnatud/www/b2b/vendor/symfony/stopwatch/StopwatchEvent.php",
                "line": 94,
                "function": "loadClass",
                "class": "Symfony\\Component\\ErrorHandler\\DebugClassLoader",
                "type": "->"
            }
        ],
        "count": 297
    }
}
INFO 15:47:33 request Matched route "_profiler". 
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "9c39cc"
    },
    "request_uri": "https://b2bnaturamedicatrix.com/_profiler/9c39cc",
    "method": "GET"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelRequest"
}
INFO 15:47:33 deprecation Deprecated: Creation of dynamic property App\Service\RetrieveClients::$requestStack is deprecated 
{
    "exception": {}
}
DEBUG 15:47:33 php Warning: Zend OPcache API is restricted by "restrict_api" configuration directive 
{
    "exception": {
        "severity": 2,
        "file": "/home/bbnatud/www/b2b/vendor/symfony/error-handler/DebugClassLoader.php",
        "line": 293,
        "trace": [
            {
                "file": "/home/bbnatud/www/b2b/vendor/symfony/stopwatch/StopwatchEvent.php",
                "line": 94,
                "function": "loadClass",
                "class": "Symfony\\Component\\ErrorHandler\\DebugClassLoader",
                "type": "->"
            }
        ],
        "count": 297
    }
}
DEBUG 15:47:33 php Warning: Zend OPcache API is restricted by "restrict_api" configuration directive 
{
    "exception": {
        "severity": 2,
        "file": "/home/bbnatud/www/b2b/vendor/symfony/error-handler/DebugClassLoader.php",
        "line": 293,
        "trace": [
            {
                "file": "/home/bbnatud/www/b2b/vendor/symfony/stopwatch/StopwatchEvent.php",
                "line": 94,
                "function": "loadClass",
                "class": "Symfony\\Component\\ErrorHandler\\DebugClassLoader",
                "type": "->"
            }
        ],
        "count": 297
    }
}
INFO 15:47:33 doctrine Connecting with parameters {params} 
{
    "params": {
        "driver": "pdo_mysql",
        "host": "bbnatudpro.mysql.db",
        "port": 3306,
        "user": "bbnatudpro",
        "password": "<redacted>",
        "driverOptions": [],
        "defaultTableOptions": [],
        "dbname": "bbnatudpro",
        "serverVersion": "mariadb-10.6.7",
        "charset": "utf8mb4"
    }
}
DEBUG 15:47:33 doctrine Executing query: 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"
}
DEBUG 15:47:33 doctrine Executing query: 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"
}
DEBUG 15:47:33 doctrine Executing statement: 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 (parameters: {params}, types: {types}) 
{
    "sql": "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",
    "params": {
        "1": "naturamedicatrix"
    },
    "types": {
        "1": 2
    }
}
DEBUG 15:47:33 doctrine Executing query: 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 
{
    "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_.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"
}
DEBUG 15:47:33 doctrine Executing statement: 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 (parameters: {params}, types: {types}) 
{
    "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
    }
}
DEBUG 15:47:33 event Notified event "kernel.controller" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelController"
}
DEBUG 15:47:33 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 15:47:33 event Notified event "kernel.controller" to listener "App\EventSubscriber\TwigEventSubscriber::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "App\\EventSubscriber\\TwigEventSubscriber::onKernelController"
}
DEBUG 15:47:33 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 15:47:33 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsGrantedAttributeListener::onKernelControllerArguments"
}
DEBUG 15:47:33 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelControllerArguments"
}
DEBUG 15:47:33 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelRequest"
}
DEBUG 15:47:33 doctrine Executing query: 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"
}
DEBUG 15:47:33 doctrine Executing query: 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"
}
DEBUG 15:47:33 doctrine Executing statement: 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 (parameters: {params}, types: {types}) 
{
    "sql": "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",
    "params": {
        "1": "naturamedicatrix"
    },
    "types": {
        "1": 2
    }
}
DEBUG 15:47:33 doctrine Executing query: 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 
{
    "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_.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"
}
DEBUG 15:47:33 doctrine Executing statement: 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 (parameters: {params}, types: {types}) 
{
    "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
    }
}
DEBUG 15:47:33 event Notified event "kernel.controller" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelController"
}
DEBUG 15:47:33 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 15:47:33 event Notified event "kernel.controller" to listener "App\EventSubscriber\TwigEventSubscriber::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "App\\EventSubscriber\\TwigEventSubscriber::onKernelController"
}
DEBUG 15:47:33 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 15:47:33 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsGrantedAttributeListener::onKernelControllerArguments"
}
DEBUG 15:47:33 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelControllerArguments"
}
DEBUG 15:47:33 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}
DEBUG 15:47:33 event Notified event "kernel.response" to listener "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\Security\\Http\\Firewall\\ContextListener::onKernelResponse"
}
DEBUG 15:47:33 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ResponseListener::onKernelResponse"
}
DEBUG 15:47:33 event Notified event "kernel.response" to listener "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\WebLink\\EventListener\\AddLinkHeaderListener::onKernelResponse"
}
DEBUG 15:47:33 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelResponse"
}
DEBUG 15:47:33 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelResponse"
}
DEBUG 15:47:33 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ProfilerListener::onKernelResponse"
}
DEBUG 15:47:33 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::removeCspHeader"
}
DEBUG 15:47:33 event Notified event "kernel.response" to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Bundle\\WebProfilerBundle\\EventListener\\WebDebugToolbarListener::onKernelResponse"
}
DEBUG 15:47:33 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DisallowRobotsIndexingListener::onResponse"
}
DEBUG 15:47:33 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelResponse"
}
DEBUG 15:47:33 event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest". 
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelFinishRequest"
}
DEBUG 15:47:33 event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest". 
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelFinishRequest"
}
DEBUG 15:47:33 event Notified event "kernel.finish_request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest". 
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelFinishRequest"
}
DEBUG 15:47:33 event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest". 
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelFinishRequest"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
DEBUG 15:47:33 event Notified event "kernel.request" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelRequest"
}
DEBUG 15:47:33 doctrine Executing query: 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"
}
DEBUG 15:47:33 doctrine Executing query: 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"
}
DEBUG 15:47:33 doctrine Executing statement: 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 (parameters: {params}, types: {types}) 
{
    "sql": "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",
    "params": {
        "1": "naturamedicatrix"
    },
    "types": {
        "1": 2
    }
}
DEBUG 15:47:33 doctrine Executing query: 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 
{
    "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_.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"
}
DEBUG 15:47:34 doctrine Executing statement: 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 (parameters: {params}, types: {types}) 
{
    "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
    }
}
DEBUG 15:47:34 event Notified event "kernel.controller" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelController"
}
DEBUG 15:47:34 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 15:47:34 event Notified event "kernel.controller" to listener "App\EventSubscriber\TwigEventSubscriber::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "App\\EventSubscriber\\TwigEventSubscriber::onKernelController"
}
DEBUG 15:47:34 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 15:47:34 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsGrantedAttributeListener::onKernelControllerArguments"
}
DEBUG 15:47:34 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelControllerArguments"
}
DEBUG 15:47:34 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}
DEBUG 15:47:34 event Notified event "kernel.response" to listener "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\Security\\Http\\Firewall\\ContextListener::onKernelResponse"
}
DEBUG 15:47:34 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ResponseListener::onKernelResponse"
}
DEBUG 15:47:34 event Notified event "kernel.response" to listener "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\WebLink\\EventListener\\AddLinkHeaderListener::onKernelResponse"
}
DEBUG 15:47:34 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelResponse"
}
DEBUG 15:47:34 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelResponse"
}
DEBUG 15:47:34 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ProfilerListener::onKernelResponse"
}
DEBUG 15:47:34 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::removeCspHeader"
}
DEBUG 15:47:34 event Notified event "kernel.response" to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Bundle\\WebProfilerBundle\\EventListener\\WebDebugToolbarListener::onKernelResponse"
}
DEBUG 15:47:34 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DisallowRobotsIndexingListener::onResponse"
}
DEBUG 15:47:34 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelResponse"
}
DEBUG 15:47:34 event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest". 
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelFinishRequest"
}
DEBUG 15:47:34 event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest". 
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelFinishRequest"
}
DEBUG 15:47:34 event Notified event "kernel.finish_request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest". 
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelFinishRequest"
}
DEBUG 15:47:34 event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest". 
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelFinishRequest"
}
DEBUG 15:47:34 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 15:47:34 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 15:47:34 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 15:47:34 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 15:47:34 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 15:47:34 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 15:47:34 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 15:47:34 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
DEBUG 15:47:34 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
DEBUG 15:47:34 event Notified event "kernel.request" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelRequest"
}
DEBUG 15:47:34 doctrine Executing query: 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"
}
DEBUG 15:47:34 doctrine Executing query: 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"
}
DEBUG 15:47:34 doctrine Executing statement: 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 (parameters: {params}, types: {types}) 
{
    "sql": "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",
    "params": {
        "1": "naturamedicatrix"
    },
    "types": {
        "1": 2
    }
}
DEBUG 15:47:34 doctrine Executing query: 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 
{
    "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_.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"
}
DEBUG 15:47:34 doctrine Executing statement: 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 (parameters: {params}, types: {types}) 
{
    "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
    }
}
DEBUG 15:47:34 event Notified event "kernel.controller" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelController"
}
DEBUG 15:47:34 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 15:47:34 event Notified event "kernel.controller" to listener "App\EventSubscriber\TwigEventSubscriber::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "App\\EventSubscriber\\TwigEventSubscriber::onKernelController"
}
DEBUG 15:47:34 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 15:47:34 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsGrantedAttributeListener::onKernelControllerArguments"
}
DEBUG 15:47:34 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelControllerArguments"
}
DEBUG 15:47:34 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}

Stack Traces 2

[2/2] NotFoundHttpException 
Symfony\Component\HttpKernel\Exception\NotFoundHttpException:
No route found for "GET https://b2bnaturamedicatrix.com/llms/" (from "https://www.b2bnaturamedicatrix.com")

  at vendor/symfony/http-kernel/EventListener/RouterListener.php:127
  at Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest(object(RequestEvent), 'kernel.request', object(TraceableEventDispatcher))
     (vendor/symfony/event-dispatcher/Debug/WrappedListener.php:116)
  at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke(object(RequestEvent), 'kernel.request', object(TraceableEventDispatcher))
     (vendor/symfony/event-dispatcher/EventDispatcher.php:206)
  at Symfony\Component\EventDispatcher\EventDispatcher->callListeners(array(object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener)), 'kernel.request', object(RequestEvent))
     (vendor/symfony/event-dispatcher/EventDispatcher.php:56)
  at Symfony\Component\EventDispatcher\EventDispatcher->dispatch(object(RequestEvent), 'kernel.request')
     (vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:127)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch(object(RequestEvent), 'kernel.request')
     (vendor/symfony/http-kernel/HttpKernel.php:139)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:184)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/home/bbnatud/www/b2b/vendor/autoload_runtime.php')
     (public/index.php:5)
[1/2] ResourceNotFoundException 
Symfony\Component\Routing\Exception\ResourceNotFoundException:
No routes found for "/llms".

  at vendor/symfony/routing/Matcher/Dumper/CompiledUrlMatcherTrait.php:74
  at Symfony\Component\Routing\Matcher\CompiledUrlMatcher->match('/llms')
     (vendor/symfony/routing/Matcher/UrlMatcher.php:94)
  at Symfony\Component\Routing\Matcher\UrlMatcher->matchRequest(object(Request))
     (vendor/symfony/routing/Router.php:225)
  at Symfony\Component\Routing\Router->matchRequest(object(Request))
     (vendor/symfony/http-kernel/EventListener/RouterListener.php:105)
  at Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest(object(RequestEvent), 'kernel.request', object(TraceableEventDispatcher))
     (vendor/symfony/event-dispatcher/Debug/WrappedListener.php:116)
  at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke(object(RequestEvent), 'kernel.request', object(TraceableEventDispatcher))
     (vendor/symfony/event-dispatcher/EventDispatcher.php:206)
  at Symfony\Component\EventDispatcher\EventDispatcher->callListeners(array(object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener)), 'kernel.request', object(RequestEvent))
     (vendor/symfony/event-dispatcher/EventDispatcher.php:56)
  at Symfony\Component\EventDispatcher\EventDispatcher->dispatch(object(RequestEvent), 'kernel.request')
     (vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:127)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch(object(RequestEvent), 'kernel.request')
     (vendor/symfony/http-kernel/HttpKernel.php:139)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:184)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/home/bbnatud/www/b2b/vendor/autoload_runtime.php')
     (public/index.php:5)