Exceptions
Exceptions 2
Symfony\Component\HttpKernel\Exception\ NotFoundHttpException
if ($referer = $request->headers->get('referer')) {$message .= sprintf(' (from "%s")', $referer);}throw new NotFoundHttpException($message, $e);} catch (MethodNotAllowedException $e) {$message = sprintf('No route found for "%s %s": Method Not Allowed (Allow: %s)', $request->getMethod(), $request->getUriForPath($request->getPathInfo()), implode(', ', $e->getAllowedMethods()));throw new MethodNotAllowedHttpException($e->getAllowedMethods(), $message, $e);}
in
vendor/symfony/event-dispatcher/Debug/WrappedListener.php
->
onKernelRequest
(line 116)
$this->priority ??= $dispatcher->getListenerPriority($eventName, $this->listener);$e = $this->stopwatch->start($this->name, 'event_listener');try {($this->optimizedListener ?? $this->listener)($event, $eventName, $dispatcher);} finally {if ($e->isStarted()) {$e->stop();}}
in
vendor/symfony/event-dispatcher/EventDispatcher.php
->
__invoke
(line 206)
foreach ($listeners as $listener) {if ($stoppable && $event->isPropagationStopped()) {break;}$listener($event, $eventName, $this);}}/*** Sorts the internal list of listeners for the given event by priority.
in
vendor/symfony/event-dispatcher/EventDispatcher.php
->
callListeners
(line 56)
} else {$listeners = $this->getListeners($eventName);}if ($listeners) {$this->callListeners($listeners, $eventName, $event);}return $event;}
in
vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php
->
dispatch
(line 127)
try {$this->beforeDispatch($eventName, $event);try {$e = $this->stopwatch->start($eventName, 'section');try {$this->dispatcher->dispatch($event, $eventName);} finally {if ($e->isStarted()) {$e->stop();}}
in
vendor/symfony/http-kernel/HttpKernel.php
->
dispatch
(line 139)
*/private function handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response{// request$event = new RequestEvent($this, $request, $type);$this->dispatcher->dispatch($event, KernelEvents::REQUEST);if ($event->hasResponse()) {return $this->filterResponse($event->getResponse(), $request, $type);}
in
vendor/symfony/http-kernel/HttpKernel.php
->
handleRaw
(line 74)
{$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());$this->requestStack->push($request);try {return $this->handleRaw($request, $type);} catch (\Throwable $e) {if ($e instanceof \Error && !$this->handleAllThrowables) {throw $e;}
in
vendor/symfony/http-kernel/Kernel.php
->
handle
(line 184)
$this->boot();++$this->requestStackSize;$this->resetServices = true;try {return $this->getHttpKernel()->handle($request, $type, $catch);} finally {--$this->requestStackSize;}}
in
vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php
->
handle
(line 35)
$this->request = $request;}public function run(): int{$response = $this->kernel->handle($this->request);$response->send();if ($this->kernel instanceof TerminableInterface) {$this->kernel->terminate($this->request, $response);}
in
vendor/autoload_runtime.php
->
run
(line 29)
$app = $app(...$args);exit($runtime->getRunner($app)->run());
<?phpuse App\Kernel;require_once dirname(__DIR__).'/vendor/autoload_runtime.php';return function (array $context) {return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);};
Symfony\Component\Routing\Exception\ ResourceNotFoundException
if ($allowSchemes) {goto redirect_scheme;}}throw new ResourceNotFoundException(sprintf('No routes found for "%s".', $pathinfo));}private function doMatch(string $pathinfo, array &$allow = [], array &$allowSchemes = []): array{$allow = $allowSchemes = [];
in
vendor/symfony/routing/Matcher/UrlMatcher.php
->
match
(line 94)
public function matchRequest(Request $request): array{$this->request = $request;$ret = $this->match($request->getPathInfo());$this->request = null;return $ret;}
in
vendor/symfony/routing/Router.php
->
matchRequest
(line 225)
if (!$matcher instanceof RequestMatcherInterface) {// fallback to the default UrlMatcherInterfacereturn $matcher->match($request->getPathInfo());}return $matcher->matchRequest($request);}/*** Gets the UrlMatcher or RequestMatcher instance associated with this Router.*/
in
vendor/symfony/http-kernel/EventListener/RouterListener.php
->
matchRequest
(line 105)
// add attributes based on the request (routing)try {// matching a request is more powerful than matching a URL path + context, so try that firstif ($this->matcher instanceof RequestMatcherInterface) {$parameters = $this->matcher->matchRequest($request);} else {$parameters = $this->matcher->match($request->getPathInfo());}$this->logger?->info('Matched route "{route}".', [
in
vendor/symfony/event-dispatcher/Debug/WrappedListener.php
->
onKernelRequest
(line 116)
$this->priority ??= $dispatcher->getListenerPriority($eventName, $this->listener);$e = $this->stopwatch->start($this->name, 'event_listener');try {($this->optimizedListener ?? $this->listener)($event, $eventName, $dispatcher);} finally {if ($e->isStarted()) {$e->stop();}}
in
vendor/symfony/event-dispatcher/EventDispatcher.php
->
__invoke
(line 206)
foreach ($listeners as $listener) {if ($stoppable && $event->isPropagationStopped()) {break;}$listener($event, $eventName, $this);}}/*** Sorts the internal list of listeners for the given event by priority.
in
vendor/symfony/event-dispatcher/EventDispatcher.php
->
callListeners
(line 56)
} else {$listeners = $this->getListeners($eventName);}if ($listeners) {$this->callListeners($listeners, $eventName, $event);}return $event;}
in
vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php
->
dispatch
(line 127)
try {$this->beforeDispatch($eventName, $event);try {$e = $this->stopwatch->start($eventName, 'section');try {$this->dispatcher->dispatch($event, $eventName);} finally {if ($e->isStarted()) {$e->stop();}}
in
vendor/symfony/http-kernel/HttpKernel.php
->
dispatch
(line 139)
*/private function handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response{// request$event = new RequestEvent($this, $request, $type);$this->dispatcher->dispatch($event, KernelEvents::REQUEST);if ($event->hasResponse()) {return $this->filterResponse($event->getResponse(), $request, $type);}
in
vendor/symfony/http-kernel/HttpKernel.php
->
handleRaw
(line 74)
{$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());$this->requestStack->push($request);try {return $this->handleRaw($request, $type);} catch (\Throwable $e) {if ($e instanceof \Error && !$this->handleAllThrowables) {throw $e;}
in
vendor/symfony/http-kernel/Kernel.php
->
handle
(line 184)
$this->boot();++$this->requestStackSize;$this->resetServices = true;try {return $this->getHttpKernel()->handle($request, $type, $catch);} finally {--$this->requestStackSize;}}
in
vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php
->
handle
(line 35)
$this->request = $request;}public function run(): int{$response = $this->kernel->handle($this->request);$response->send();if ($this->kernel instanceof TerminableInterface) {$this->kernel->terminate($this->request, $response);}
in
vendor/autoload_runtime.php
->
run
(line 29)
$app = $app(...$args);exit($runtime->getRunner($app)->run());
<?phpuse App\Kernel;require_once dirname(__DIR__).'/vendor/autoload_runtime.php';return function (array $context) {return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);};
Logs
| Level | Channel | Message |
|---|---|---|
| DEBUG 18:20:08 | 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 18:20:08 | request |
Matched route "_profiler". {
"route": "_profiler",
"route_parameters": {
"_route": "_profiler",
"_controller": "web_profiler.controller.profiler::panelAction",
"token": "5cf9ac"
},
"request_uri": "https://b2bnaturamedicatrix.com/_profiler/5cf9ac",
"method": "GET"
}
|
| DEBUG 18:20:08 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
|
| DEBUG 18:20:08 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
|
| DEBUG 18:20:08 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
|
| DEBUG 18:20:08 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
|
| DEBUG 18:20:08 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
|
| DEBUG 18:20:08 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
|
| DEBUG 18:20:08 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
|
| DEBUG 18:20:08 | event |
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". {
"event": "kernel.request",
"listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
|
| DEBUG 18:20:08 | event |
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
|
| DEBUG 18:20:08 | event |
Notified event "kernel.request" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest". {
"event": "kernel.request",
"listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelRequest"
}
|
| INFO 18:20:08 | deprecation |
Deprecated: Creation of dynamic property App\Service\RetrieveClients::$requestStack is deprecated {
"exception": {}
}
|
| DEBUG 18:20:08 | 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 18:20:08 | 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 18:20:08 | 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 18:20:08 | 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 18:20:08 | 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 18:20:08 | 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 18:20:08 | 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 18:20:08 | 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 18:20:08 | event |
Notified event "kernel.controller" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController". {
"event": "kernel.controller",
"listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelController"
}
|
| DEBUG 18:20:08 | event |
Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". {
"event": "kernel.controller",
"listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
|
| DEBUG 18:20:08 | event |
Notified event "kernel.controller" to listener "App\EventSubscriber\TwigEventSubscriber::onKernelController". {
"event": "kernel.controller",
"listener": "App\\EventSubscriber\\TwigEventSubscriber::onKernelController"
}
|
| DEBUG 18:20:08 | event |
Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". {
"event": "kernel.controller",
"listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
|
| DEBUG 18:20:08 | 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 18:20:08 | 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 18:20:08 | 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 18:20:08 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
|
| DEBUG 18:20:08 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
|
| DEBUG 18:20:08 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
|
| DEBUG 18:20:08 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
|
| DEBUG 18:20:08 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
|
| DEBUG 18:20:08 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
|
| DEBUG 18:20:08 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
|
| DEBUG 18:20:08 | event |
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". {
"event": "kernel.request",
"listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
|
| DEBUG 18:20:08 | event |
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
|
| DEBUG 18:20:08 | event |
Notified event "kernel.request" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest". {
"event": "kernel.request",
"listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelRequest"
}
|
| DEBUG 18:20:08 | 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 18:20:08 | 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 18:20:08 | 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 18:20:08 | 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 18:20:09 | 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 18:20:09 | event |
Notified event "kernel.controller" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController". {
"event": "kernel.controller",
"listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelController"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". {
"event": "kernel.controller",
"listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.controller" to listener "App\EventSubscriber\TwigEventSubscriber::onKernelController". {
"event": "kernel.controller",
"listener": "App\\EventSubscriber\\TwigEventSubscriber::onKernelController"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". {
"event": "kernel.controller",
"listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
|
| DEBUG 18:20:09 | 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 18:20:09 | 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 18:20:09 | 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 18:20:09 | 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 18:20:09 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse". {
"event": "kernel.response",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\ResponseListener::onKernelResponse"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.response" to listener "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse". {
"event": "kernel.response",
"listener": "Symfony\\Component\\WebLink\\EventListener\\AddLinkHeaderListener::onKernelResponse"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse". {
"event": "kernel.response",
"listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelResponse"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse". {
"event": "kernel.response",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelResponse"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse". {
"event": "kernel.response",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\ProfilerListener::onKernelResponse"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader". {
"event": "kernel.response",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::removeCspHeader"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.response" to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse". {
"event": "kernel.response",
"listener": "Symfony\\Bundle\\WebProfilerBundle\\EventListener\\WebDebugToolbarListener::onKernelResponse"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse". {
"event": "kernel.response",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\DisallowRobotsIndexingListener::onResponse"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse". {
"event": "kernel.response",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelResponse"
}
|
| DEBUG 18:20:09 | 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 18:20:09 | 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 18:20:09 | 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 18:20:09 | 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 18:20:09 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". {
"event": "kernel.request",
"listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.request" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest". {
"event": "kernel.request",
"listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelRequest"
}
|
| DEBUG 18:20:09 | 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 18:20:09 | 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 18:20:09 | 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 18:20:09 | 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 18:20:09 | 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 18:20:09 | event |
Notified event "kernel.controller" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController". {
"event": "kernel.controller",
"listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelController"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". {
"event": "kernel.controller",
"listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.controller" to listener "App\EventSubscriber\TwigEventSubscriber::onKernelController". {
"event": "kernel.controller",
"listener": "App\\EventSubscriber\\TwigEventSubscriber::onKernelController"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". {
"event": "kernel.controller",
"listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
|
| DEBUG 18:20:09 | 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 18:20:09 | 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 18:20:09 | 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 18:20:09 | 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 18:20:09 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse". {
"event": "kernel.response",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\ResponseListener::onKernelResponse"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.response" to listener "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse". {
"event": "kernel.response",
"listener": "Symfony\\Component\\WebLink\\EventListener\\AddLinkHeaderListener::onKernelResponse"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse". {
"event": "kernel.response",
"listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelResponse"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse". {
"event": "kernel.response",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelResponse"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse". {
"event": "kernel.response",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\ProfilerListener::onKernelResponse"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader". {
"event": "kernel.response",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::removeCspHeader"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.response" to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse". {
"event": "kernel.response",
"listener": "Symfony\\Bundle\\WebProfilerBundle\\EventListener\\WebDebugToolbarListener::onKernelResponse"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse". {
"event": "kernel.response",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\DisallowRobotsIndexingListener::onResponse"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse". {
"event": "kernel.response",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelResponse"
}
|
| DEBUG 18:20:09 | 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 18:20:09 | 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 18:20:09 | 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 18:20:09 | 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 18:20:09 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". {
"event": "kernel.request",
"listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.request" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest". {
"event": "kernel.request",
"listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelRequest"
}
|
| DEBUG 18:20:09 | 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 18:20:09 | 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 18:20:09 | 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 18:20:09 | 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 18:20:09 | 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 18:20:09 | event |
Notified event "kernel.controller" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController". {
"event": "kernel.controller",
"listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelController"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". {
"event": "kernel.controller",
"listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.controller" to listener "App\EventSubscriber\TwigEventSubscriber::onKernelController". {
"event": "kernel.controller",
"listener": "App\\EventSubscriber\\TwigEventSubscriber::onKernelController"
}
|
| DEBUG 18:20:09 | event |
Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". {
"event": "kernel.controller",
"listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
|
| DEBUG 18:20:09 | 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 18:20:09 | 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 18:20:09 | 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)
|