Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 4
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• JMS Serializer 0 + 0
• Configuration

Log Messages

[
  "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#1376
    +count: 2
    -severity: E_USER_DEPRECATED
    trace: {
      /home/azima24/htdocs/azima24.com/vendor/symfony/config/Definition/ArrayNode.php:248 {
        Symfony\Component\Config\Definition\ArrayNode->finalizeValue(mixed $value): mixed …
        ›     $deprecation = $child->getDeprecation($name, $this->getPath());
        ›     trigger_deprecation($deprecation['package'], $deprecation['version'], $deprecation['message']);
        › }
      }
      /home/azima24/htdocs/azima24.com/vendor/symfony/config/Definition/BaseNode.php:421 {
        › 
        › $value = $this->finalizeValue($value);
        › 
      }
    }
  }
]

{
  /home/azima24/htdocs/azima24.com/vendor/symfony/config/Definition/ArrayNode.php:248 {
    Symfony\Component\Config\Definition\ArrayNode->finalizeValue(mixed $value): mixed …
    ›     $deprecation = $child->getDeprecation($name, $this->getPath());
    ›     trigger_deprecation($deprecation['package'], $deprecation['version'], $deprecation['message']);
    › }
  }
  /home/azima24/htdocs/azima24.com/vendor/symfony/config/Definition/BaseNode.php:421 {
    › 
    › $value = $this->finalizeValue($value);
    › 
  }
}

[
  "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#1407
    +count: 1
    -severity: E_USER_DEPRECATED
    trace: {
      /home/azima24/htdocs/azima24.com/vendor/symfony/dependency-injection/Compiler/ResolveReferencesToAliasesPass.php:67 {
        Symfony\Component\DependencyInjection\Compiler\ResolveReferencesToAliasesPass->getDefinitionId(string $id, ContainerBuilder $container): string …
        ›     $deprecation = $alias->getDeprecation($id);
        ›     trigger_deprecation($deprecation['package'], $deprecation['version'], rtrim($deprecation['message'], '. ').'. It is being referenced by the "%s" '.($container->hasDefinition($this->currentId) ? 'service.' : 'alias.'), $this->currentId);
        › }
      }
      /home/azima24/htdocs/azima24.com/vendor/symfony/dependency-injection/Compiler/ResolveReferencesToAliasesPass.php:50 {
        › 
        › $defId = $this->getDefinitionId($id = (string) $value, $this->container);
        › 
      }
    }
  }
]

{
  /home/azima24/htdocs/azima24.com/vendor/symfony/dependency-injection/Compiler/ResolveReferencesToAliasesPass.php:67 {
    Symfony\Component\DependencyInjection\Compiler\ResolveReferencesToAliasesPass->getDefinitionId(string $id, ContainerBuilder $container): string …
    ›     $deprecation = $alias->getDeprecation($id);
    ›     trigger_deprecation($deprecation['package'], $deprecation['version'], rtrim($deprecation['message'], '. ').'. It is being referenced by the "%s" '.($container->hasDefinition($this->currentId) ? 'service.' : 'alias.'), $this->currentId);
    › }
  }
  /home/azima24/htdocs/azima24.com/vendor/symfony/dependency-injection/Compiler/ResolveReferencesToAliasesPass.php:50 {
    › 
    › $defId = $this->getDefinitionId($id = (string) $value, $this->container);
    › 
  }
}

"api_shopsales"

[
  "route" => "api_shopsales"
  "route_parameters" => [
    "_route" => "api_shopsales"
    "_controller" => "App\Controller\ShopController::shopsales"
    "idsales" => "4"
  ]
  "request_uri" => "https://azima24.com/api/shopsales/4?searchName=sandra"
  "method" => "GET"
]

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

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

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

"kernel.request"

"Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"

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

"kernel.request"

"Symfony\UX\Turbo\Request\RequestListener::__invoke"

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\Turbo\Request\RequestListener::__invoke"
]

"kernel.request"

"Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"

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

"kernel.request"

"Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"

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

"kernel.request"

"Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"

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

"kernel.request"

"Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

"kernel.request"

"Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"

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

"kernel.request"

"Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"

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

"kernel.request"

"Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"

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

"kernel.request"

"Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"

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

"kernel.request"

"Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"

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

"kernel.controller"

"Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"

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

"kernel.controller"

"Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"

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

"kernel.controller_arguments"

"Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"

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

"kernel.controller_arguments"

"Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"

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

"kernel.controller_arguments"

"Container8WxT2PW\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"

[
  "event" => "kernel.controller_arguments"
  "listener" => "Container8WxT2PW\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

"kernel.controller_arguments"

"Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"

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

[
  "exception" => ErrorException {#747
    #message: "User Deprecated: Support for MariaDB < 10.4 is deprecated and will be removed in DBAL 4. Consider upgrading to a more recent version of MariaDB. (AbstractMySQLDriver.php:66 called by AbstractDriverMiddleware.php:68, https://github.com/doctrine/dbal/pull/6110, package doctrine/dbal)"
    #code: 0
    #file: "/home/azima24/htdocs/azima24.com/vendor/doctrine/deprecations/src/Deprecation.php"
    #line: 208
    #severity: E_USER_DEPRECATED
    trace: {
      /home/azima24/htdocs/azima24.com/vendor/doctrine/deprecations/src/Deprecation.php:208 {
        Doctrine\Deprecations\Deprecation::delegateTriggerToBackend(string $message, array $backtrace, string $link, string $package): void …
        › 
        ›     @trigger_error($message, E_USER_DEPRECATED);
        › }
      }
      /home/azima24/htdocs/azima24.com/vendor/doctrine/deprecations/src/Deprecation.php:108 {
        Doctrine\Deprecations\Deprecation::trigger(string $package, string $link, string $message, ...$args): void …
        › 
        ›     self::delegateTriggerToBackend($message, $backtrace, $link, $package);
        › }
      }
      /home/azima24/htdocs/azima24.com/vendor/doctrine/dbal/src/Driver/AbstractMySQLDriver.php:66 {
        Doctrine\DBAL\Driver\AbstractMySQLDriver->createDatabasePlatformForVersion($version) …
        › 
        › Deprecation::trigger(
        ›     'doctrine/dbal',
      }
      /home/azima24/htdocs/azima24.com/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:68 {
        Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->createDatabasePlatformForVersion($version) …
        › if ($this->wrappedDriver instanceof VersionAwarePlatformDriver) {
        ›     return $this->wrappedDriver->createDatabasePlatformForVersion($version);
        › }
      }
      /home/azima24/htdocs/azima24.com/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:68 {
        Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->createDatabasePlatformForVersion($version) …
        › if ($this->wrappedDriver instanceof VersionAwarePlatformDriver) {
        ›     return $this->wrappedDriver->createDatabasePlatformForVersion($version);
        › }
      }
      /home/azima24/htdocs/azima24.com/vendor/doctrine/dbal/src/Connection.php:421 {
        Doctrine\DBAL\Connection->detectDatabasePlatform(): AbstractPlatform …
        › 
        ›     return $this->_driver->createDatabasePlatformForVersion($version);
        › }
      }
      /home/azima24/htdocs/azima24.com/vendor/doctrine/dbal/src/Connection.php:323 {
        Doctrine\DBAL\Connection->getDatabasePlatform() …
        › if ($this->platform === null) {
        ›     $this->platform = $this->detectDatabasePlatform();
        ›     $this->platform->setEventManager($this->_eventManager);
      }
      /home/azima24/htdocs/azima24.com/vendor/doctrine/orm/src/Mapping/ClassMetadataFactory.php:740 {
        Doctrine\ORM\Mapping\ClassMetadataFactory->getTargetPlatform(): AbstractPlatform …
        › if (! $this->targetPlatform) {
        ›     $this->targetPlatform = $this->em->getConnection()->getDatabasePlatform();
        › }
      }
      /home/azima24/htdocs/azima24.com/vendor/doctrine/orm/src/Mapping/ClassMetadataFactory.php:550 {
        Doctrine\ORM\Mapping\ClassMetadataFactory->completeIdGeneratorMapping(ClassMetadata $class): void …
        › if ($idGenType === ClassMetadata::GENERATOR_TYPE_AUTO) {
        ›     $class->setIdGeneratorType($this->determineIdGeneratorStrategy($this->getTargetPlatform()));
        › }
      }
      /home/azima24/htdocs/azima24.com/vendor/doctrine/orm/src/Mapping/ClassMetadataFactory.php:178 {
        Doctrine\ORM\Mapping\ClassMetadataFactory->doLoadMetadata(ClassMetadata $class, ?ClassMetadata $parent, bool $rootEntityFound, array $nonSuperclassParents): void …
        › } else {
        ›     $this->completeIdGeneratorMapping($class);
        › }
      }
      /home/azima24/htdocs/azima24.com/vendor/doctrine/doctrine-bundle/src/Mapping/ClassMetadataFactory.php:20 {
        Doctrine\Bundle\DoctrineBundle\Mapping\ClassMetadataFactory->doLoadMetadata($class, $parent, $rootEntityFound, array $nonSuperclassParents): void …
        › {
        ›     parent::doLoadMetadata($class, $parent, $rootEntityFound, $nonSuperclassParents);
        › 
      }
      /home/azima24/htdocs/azima24.com/vendor/doctrine/persistence/src/Persistence/Mapping/AbstractClassMetadataFactory.php:318 {
        Doctrine\Persistence\Mapping\AbstractClassMetadataFactory->loadMetadata(string $name): array …
        › 
        › $this->doLoadMetadata($class, $parent, $rootEntityFound, $visited);
        › 
      }
      /home/azima24/htdocs/azima24.com/vendor/doctrine/persistence/src/Persistence/Mapping/AbstractClassMetadataFactory.php:187 {
        Doctrine\Persistence\Mapping\AbstractClassMetadataFactory->getMetadataFor(string $className): ClassMetadata …
        › } else {
        ›     $loadedMetadata = $this->loadMetadata($realClassName);
        ›     $classNames     = array_combine(
      }
      /home/azima24/htdocs/azima24.com/vendor/doctrine/orm/src/EntityManager.php:224 {
        Doctrine\ORM\EntityManager->getClassMetadata(string $className): ClassMetadata …
        › {
        ›     return $this->metadataFactory->getMetadataFor($className);
        › }
      }
      /home/azima24/htdocs/azima24.com/vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepositoryProxy.php:134 {
        Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->resolveRepository(): EntityRepository …
        › /** @var ClassMetadata<T> $classMetadata */
        › $classMetadata = $manager->getClassMetadata($this->entityClass);
        › 
      }
      /home/azima24/htdocs/azima24.com/vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepositoryProxy.php:47 {
        Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->createQueryBuilder(string $alias, ?string $indexBy = null): QueryBuilder …
        › {
        ›     return ($this->repository ??= $this->resolveRepository())
        ›         ->createQueryBuilder($alias, $indexBy);
      }
      /home/azima24/htdocs/azima24.com/src/Repository/ShopRepository.php:26 {
        App\Repository\ShopRepository->findsales(int $idsales, ?int $limit = null, ?int $offset = null, ?string $searchName = null): array …
        › $qb = $this
        ›     ->createQueryBuilder('s')
        ›     ->leftJoin('s.SalesMen', 'w')
      }
      /home/azima24/htdocs/azima24.com/src/Controller/ShopController.php:157 {
        App\Controller\ShopController->shopsales(Request $request, ShopRepository $shopRepository, ShopSalesmanRepository $shopSalesmanRepository, int $idsales): JsonResponse …
        › if ($isSearching) {
        ›     $shops1 = $shopRepository->findsales($idsales, null, null, $searchName);
        ›     // $shops2 = $shopSalesmanRepository->findshopbysalesman($idsales, null, null, $searchName);
      }
      /home/azima24/htdocs/azima24.com/vendor/symfony/http-kernel/HttpKernel.php:181 {
        Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
        › // call controller
        › $response = $controller(...$arguments);
        › 
      }
      /home/azima24/htdocs/azima24.com/vendor/symfony/http-kernel/HttpKernel.php:76 {
        Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
        › try {
        ›     return $response = $this->handleRaw($request, $type);
        › } catch (\Throwable $e) {
      }
      /home/azima24/htdocs/azima24.com/vendor/symfony/http-kernel/Kernel.php:197 {
        Symfony\Component\HttpKernel\Kernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
        › try {
        ›     return $this->getHttpKernel()->handle($request, $type, $catch);
        › } finally {
      }
      /home/azima24/htdocs/azima24.com/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
        Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
        › {
        ›     $response = $this->kernel->handle($this->request);
        › 
      }
      /home/azima24/htdocs/azima24.com/vendor/autoload_runtime.php:29 {
        require_once …
        ›         ->getRunner($app)
        ›         ->run()
        › );
      }
      /home/azima24/htdocs/azima24.com/public/index.php:5 {
        › 
        › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
        › 
      }
    }
  }
]

{
  /home/azima24/htdocs/azima24.com/vendor/doctrine/deprecations/src/Deprecation.php:208 {
    Doctrine\Deprecations\Deprecation::delegateTriggerToBackend(string $message, array $backtrace, string $link, string $package): void …
    › 
    ›     @trigger_error($message, E_USER_DEPRECATED);
    › }
  }
  /home/azima24/htdocs/azima24.com/vendor/doctrine/deprecations/src/Deprecation.php:108 {
    Doctrine\Deprecations\Deprecation::trigger(string $package, string $link, string $message, ...$args): void …
    › 
    ›     self::delegateTriggerToBackend($message, $backtrace, $link, $package);
    › }
  }
  /home/azima24/htdocs/azima24.com/vendor/doctrine/dbal/src/Driver/AbstractMySQLDriver.php:66 {
    Doctrine\DBAL\Driver\AbstractMySQLDriver->createDatabasePlatformForVersion($version) …
    › 
    › Deprecation::trigger(
    ›     'doctrine/dbal',
  }
  /home/azima24/htdocs/azima24.com/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:68 {
    Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->createDatabasePlatformForVersion($version) …
    › if ($this->wrappedDriver instanceof VersionAwarePlatformDriver) {
    ›     return $this->wrappedDriver->createDatabasePlatformForVersion($version);
    › }
  }
  /home/azima24/htdocs/azima24.com/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:68 {
    Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->createDatabasePlatformForVersion($version) …
    › if ($this->wrappedDriver instanceof VersionAwarePlatformDriver) {
    ›     return $this->wrappedDriver->createDatabasePlatformForVersion($version);
    › }
  }
  /home/azima24/htdocs/azima24.com/vendor/doctrine/dbal/src/Connection.php:421 {
    Doctrine\DBAL\Connection->detectDatabasePlatform(): AbstractPlatform …
    › 
    ›     return $this->_driver->createDatabasePlatformForVersion($version);
    › }
  }
  /home/azima24/htdocs/azima24.com/vendor/doctrine/dbal/src/Connection.php:323 {
    Doctrine\DBAL\Connection->getDatabasePlatform() …
    › if ($this->platform === null) {
    ›     $this->platform = $this->detectDatabasePlatform();
    ›     $this->platform->setEventManager($this->_eventManager);
  }
  /home/azima24/htdocs/azima24.com/vendor/doctrine/orm/src/Mapping/ClassMetadataFactory.php:740 {
    Doctrine\ORM\Mapping\ClassMetadataFactory->getTargetPlatform(): AbstractPlatform …
    › if (! $this->targetPlatform) {
    ›     $this->targetPlatform = $this->em->getConnection()->getDatabasePlatform();
    › }
  }
  /home/azima24/htdocs/azima24.com/vendor/doctrine/orm/src/Mapping/ClassMetadataFactory.php:550 {
    Doctrine\ORM\Mapping\ClassMetadataFactory->completeIdGeneratorMapping(ClassMetadata $class): void …
    › if ($idGenType === ClassMetadata::GENERATOR_TYPE_AUTO) {
    ›     $class->setIdGeneratorType($this->determineIdGeneratorStrategy($this->getTargetPlatform()));
    › }
  }
  /home/azima24/htdocs/azima24.com/vendor/doctrine/orm/src/Mapping/ClassMetadataFactory.php:178 {
    Doctrine\ORM\Mapping\ClassMetadataFactory->doLoadMetadata(ClassMetadata $class, ?ClassMetadata $parent, bool $rootEntityFound, array $nonSuperclassParents): void …
    › } else {
    ›     $this->completeIdGeneratorMapping($class);
    › }
  }
  /home/azima24/htdocs/azima24.com/vendor/doctrine/doctrine-bundle/src/Mapping/ClassMetadataFactory.php:20 {
    Doctrine\Bundle\DoctrineBundle\Mapping\ClassMetadataFactory->doLoadMetadata($class, $parent, $rootEntityFound, array $nonSuperclassParents): void …
    › {
    ›     parent::doLoadMetadata($class, $parent, $rootEntityFound, $nonSuperclassParents);
    › 
  }
  /home/azima24/htdocs/azima24.com/vendor/doctrine/persistence/src/Persistence/Mapping/AbstractClassMetadataFactory.php:318 {
    Doctrine\Persistence\Mapping\AbstractClassMetadataFactory->loadMetadata(string $name): array …
    › 
    › $this->doLoadMetadata($class, $parent, $rootEntityFound, $visited);
    › 
  }
  /home/azima24/htdocs/azima24.com/vendor/doctrine/persistence/src/Persistence/Mapping/AbstractClassMetadataFactory.php:187 {
    Doctrine\Persistence\Mapping\AbstractClassMetadataFactory->getMetadataFor(string $className): ClassMetadata …
    › } else {
    ›     $loadedMetadata = $this->loadMetadata($realClassName);
    ›     $classNames     = array_combine(
  }
  /home/azima24/htdocs/azima24.com/vendor/doctrine/orm/src/EntityManager.php:224 {
    Doctrine\ORM\EntityManager->getClassMetadata(string $className): ClassMetadata …
    › {
    ›     return $this->metadataFactory->getMetadataFor($className);
    › }
  }
  /home/azima24/htdocs/azima24.com/vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepositoryProxy.php:134 {
    Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->resolveRepository(): EntityRepository …
    › /** @var ClassMetadata<T> $classMetadata */
    › $classMetadata = $manager->getClassMetadata($this->entityClass);
    › 
  }
  /home/azima24/htdocs/azima24.com/vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepositoryProxy.php:47 {
    Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->createQueryBuilder(string $alias, ?string $indexBy = null): QueryBuilder …
    › {
    ›     return ($this->repository ??= $this->resolveRepository())
    ›         ->createQueryBuilder($alias, $indexBy);
  }
  /home/azima24/htdocs/azima24.com/src/Repository/ShopRepository.php:26 {
    App\Repository\ShopRepository->findsales(int $idsales, ?int $limit = null, ?int $offset = null, ?string $searchName = null): array …
    › $qb = $this
    ›     ->createQueryBuilder('s')
    ›     ->leftJoin('s.SalesMen', 'w')
  }
  /home/azima24/htdocs/azima24.com/src/Controller/ShopController.php:157 {
    App\Controller\ShopController->shopsales(Request $request, ShopRepository $shopRepository, ShopSalesmanRepository $shopSalesmanRepository, int $idsales): JsonResponse …
    › if ($isSearching) {
    ›     $shops1 = $shopRepository->findsales($idsales, null, null, $searchName);
    ›     // $shops2 = $shopSalesmanRepository->findshopbysalesman($idsales, null, null, $searchName);
  }
  /home/azima24/htdocs/azima24.com/vendor/symfony/http-kernel/HttpKernel.php:181 {
    Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
    › // call controller
    › $response = $controller(...$arguments);
    › 
  }
  /home/azima24/htdocs/azima24.com/vendor/symfony/http-kernel/HttpKernel.php:76 {
    Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
    › try {
    ›     return $response = $this->handleRaw($request, $type);
    › } catch (\Throwable $e) {
  }
  /home/azima24/htdocs/azima24.com/vendor/symfony/http-kernel/Kernel.php:197 {
    Symfony\Component\HttpKernel\Kernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
    › try {
    ›     return $this->getHttpKernel()->handle($request, $type, $catch);
    › } finally {
  }
  /home/azima24/htdocs/azima24.com/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
    Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
    › {
    ›     $response = $this->kernel->handle($this->request);
    › 
  }
  /home/azima24/htdocs/azima24.com/vendor/autoload_runtime.php:29 {
    require_once …
    ›         ->getRunner($app)
    ›         ->run()
    › );
  }
  /home/azima24/htdocs/azima24.com/public/index.php:5 {
    › 
    › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
    › 
  }
}

[
  "use_savepoints" => true
  "driver" => "pdo_mysql"
  "idle_connection_ttl" => 600
  "host" => "127.0.0.1"
  "port" => 3306
  "user" => "azima"
  "password" => "<redacted>"
  "driverOptions" => []
  "defaultTableOptions" => []
  "dbname" => "azima"
  "serverVersion" => "8.11.2-MariaDB"
  "charset" => "utf8mb4"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "azima"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "azima"
    "serverVersion" => "8.11.2-MariaDB"
    "charset" => "utf8mb4"
  ]
]

"SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM shop s0_ WHERE s0_.sales_men_id = ? AND (s0_.shop_name LIKE ? OR s0_.section LIKE ?)"

[
  1 => 4
  2 => "%sandra%"
  3 => "%sandra%"
]

[
  1 => 1
  2 => 2
  3 => 2
]

[
  "sql" => "SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM shop s0_ WHERE s0_.sales_men_id = ? AND (s0_.shop_name LIKE ? OR s0_.section LIKE ?)"
  "params" => [
    1 => 4
    2 => "%sandra%"
    3 => "%sandra%"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

"SELECT s0_.id AS id_0, s0_.section AS section_1, s0_.location AS location_2, s0_.shop_name AS shop_name_3, s0_.phone AS phone_4, s0_.credit_limit AS credit_limit_5, s0_.credit_days AS credit_days_6, s0_.name_manager_shop AS name_manager_shop_7, s0_.longitude AS longitude_8, s0_.latitude AS latitude_9, s1_.id AS id_10, s1_.name AS name_11, s1_.contact AS contact_12, s1_.address AS address_13, s1_.can_sell_cash AS can_sell_cash_14, s1_.is_cashvan AS is_cashvan_15, c2_.id AS id_16, c2_.city_name AS city_name_17 FROM shop s0_ LEFT JOIN sales_men s1_ ON s0_.sales_men_id = s1_.id LEFT JOIN city c2_ ON s0_.city_id = c2_.id WHERE s0_.sales_men_id = ? AND (s0_.shop_name LIKE ? OR s0_.section LIKE ?)"

[
  1 => 4
  2 => "%sandra%"
  3 => "%sandra%"
]

[
  1 => 1
  2 => 2
  3 => 2
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.section AS section_1, s0_.location AS location_2, s0_.shop_name AS shop_name_3, s0_.phone AS phone_4, s0_.credit_limit AS credit_limit_5, s0_.credit_days AS credit_days_6, s0_.name_manager_shop AS name_manager_shop_7, s0_.longitude AS longitude_8, s0_.latitude AS latitude_9, s1_.id AS id_10, s1_.name AS name_11, s1_.contact AS contact_12, s1_.address AS address_13, s1_.can_sell_cash AS can_sell_cash_14, s1_.is_cashvan AS is_cashvan_15, c2_.id AS id_16, c2_.city_name AS city_name_17 FROM shop s0_ LEFT JOIN sales_men s1_ ON s0_.sales_men_id = s1_.id LEFT JOIN city c2_ ON s0_.city_id = c2_.id WHERE s0_.sales_men_id = ? AND (s0_.shop_name LIKE ? OR s0_.section LIKE ?)"
  "params" => [
    1 => 4
    2 => "%sandra%"
    3 => "%sandra%"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

"kernel.response"

"Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

"kernel.response"

"Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"

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

"kernel.response"

"Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"

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

"kernel.response"

"Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"

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

"kernel.response"

"Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"

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

"kernel.response"

"Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"

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

"kernel.response"

"Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"

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

"kernel.response"

"Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"

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

"kernel.response"

"Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"

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

"kernel.response"

"Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"

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

"kernel.response"

"Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"

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

"kernel.finish_request"

"Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"

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

"kernel.finish_request"

"Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"

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

"kernel.finish_request"

"Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"

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

"kernel.finish_request"

"Symfony\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

"kernel.finish_request"

"Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"

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