Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• Configuration

Log Messages

"dossiers_liste"

[
  "route" => "dossiers_liste"
  "route_parameters" => [
    "_route" => "dossiers_liste"
    "_controller" => "App\Controller\ActualitesListeController::dossiers"
  ]
  "request_uri" => "https://yusiip.cm/dossiers"
  "method" => "GET"
]

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

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

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

[
  "exception" => ErrorException {#781
    #message: "User Deprecated: Support for MySQL < 8 is deprecated and will be removed in DBAL 5 (AbstractMySQLDriver.php:75 called by AbstractDriverMiddleware.php:32, https://github.com/doctrine/dbal/pull/6343, package doctrine/dbal)"
    #code: 0
    #file: "/home/u811502893/domains/yusiip.cm/public_html/vendor/doctrine/deprecations/src/Deprecation.php"
    #line: 208
    #severity: E_USER_DEPRECATED
    trace: {
      /home/u811502893/domains/yusiip.cm/public_html/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/u811502893/domains/yusiip.cm/public_html/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/u811502893/domains/yusiip.cm/public_html/vendor/doctrine/dbal/src/Driver/AbstractMySQLDriver.php:75 {
        Doctrine\DBAL\Driver\AbstractMySQLDriver->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractMySQLPlatform …
        › 
        › Deprecation::trigger(
        ›     'doctrine/dbal',
      }
      /home/u811502893/domains/yusiip.cm/public_html/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:32 {
        Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform …
        › {
        ›     return $this->wrappedDriver->getDatabasePlatform($versionProvider);
        › }
      }
      /home/u811502893/domains/yusiip.cm/public_html/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:32 {
        Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform …
        › {
        ›     return $this->wrappedDriver->getDatabasePlatform($versionProvider);
        › }
      }
      /home/u811502893/domains/yusiip.cm/public_html/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:32 {
        Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform …
        › {
        ›     return $this->wrappedDriver->getDatabasePlatform($versionProvider);
        › }
      }
      /home/u811502893/domains/yusiip.cm/public_html/vendor/doctrine/doctrine-bundle/src/ConnectionFactory.php:127 {
        Doctrine\Bundle\DoctrineBundle\ConnectionFactory->createConnection(array $params, ?Configuration $config = null, ?EventManager $eventManager = null, array $mappingTypes = []) …
        › /** @phpstan-ignore arguments.count (DBAL < 4.x doesn't accept an argument) */
        › $platform = $driver->getDatabasePlatform(
        ›     ...(class_exists(StaticServerVersionProvider::class)
      }
      /home/u811502893/domains/yusiip.cm/public_html/var/cache/dev/ContainerMuEQb9a/App_KernelDevDebugContainer.php:848 {
        ContainerMuEQb9a\App_KernelDevDebugContainer::getDoctrine_Dbal_DefaultConnectionService($container) …
        › 
        ›     return $container->services['doctrine.dbal.default_connection'] = (new \Doctrine\Bundle\DoctrineBundle\ConnectionFactory($container->parameters['doctrine.dbal.connection_factory.types'], new \Doctrine\DBAL\Tools\DsnParser(['db2' => 'ibm_db2', 'mssql' => 'pdo_sqlsrv', 'mysql' => 'pdo_mysql', 'mysql2' => 'pdo_mysql', 'postgres' => 'pdo_pgsql', 'postgresql' => 'pdo_pgsql', 'pgsql' => 'pdo_pgsql', 'sqlite' => 'pdo_sqlite', 'sqlite3' => 'pdo_sqlite'])))->createConnection(['url' => $container->getEnv('resolve:DATABASE_URL'), 'use_savepoints' => true, 'driver' => 'pdo_mysql', 'idle_connection_ttl' => 600, 'host' => 'localhost', 'port' => NULL, 'user' => 'root', 'password' => NULL, 'driverOptions' => [], 'defaultTableOptions' => []], $a, NULL, []);
        › }
      }
      /home/u811502893/domains/yusiip.cm/public_html/var/cache/dev/ContainerMuEQb9a/App_KernelDevDebugContainer.php:867 {
        ContainerMuEQb9a\App_KernelDevDebugContainer::getDoctrine_Orm_DefaultEntityManagerService($container, $lazyLoad = true) …
        › 
        › $instance = ($lazyLoad->__construct(($container->services['doctrine.dbal.default_connection'] ?? self::getDoctrine_Dbal_DefaultConnectionService($container)), ($container->privates['doctrine.orm.default_configuration'] ?? self::getDoctrine_Orm_DefaultConfigurationService($container)), ($container->privates['doctrine.dbal.default_connection.event_manager'] ?? self::getDoctrine_Dbal_DefaultConnection_EventManagerService($container))) && false ?: $lazyLoad);
        › 
      }
      /home/u811502893/domains/yusiip.cm/public_html/var/cache/dev/ContainerMuEQb9a/App_KernelDevDebugContainer.php:859 {
        ContainerMuEQb9a\App_KernelDevDebugContainer::ContainerMuEQb9a\{closure} …
        › if (true === $lazyLoad) {
        ›     return $container->services['doctrine.orm.default_entity_manager'] = $container->createProxy('EntityManagerGhost614a58f', static fn () => \EntityManagerGhost614a58f::createLazyGhost(static fn ($proxy) => self::getDoctrine_Orm_DefaultEntityManagerService($container, $proxy)));
        › }
      }
      /home/u811502893/domains/yusiip.cm/public_html/vendor/symfony/var-exporter/Internal/LazyObjectState.php:60 {
        Symfony\Component\VarExporter\Internal\LazyObjectState->initialize($instance, $propertyName, $writeScope) …
        › 
        ›     ($this->initializer)($instance);
        › } catch (\Throwable $e) {
      }
      /home/u811502893/domains/yusiip.cm/public_html/vendor/symfony/var-exporter/LazyGhostTrait.php:153 {
        ContainerMuEQb9a\EntityManagerGhost614a58f->__get&($name): mixed …
        › 
        › if ($property?->isInitialized($this) ?? LazyObjectState::STATUS_UNINITIALIZED_PARTIAL !== $state->initialize($this, $name, $writeScope ?? $scope)) {
        ›     goto get_in_scope;
      }
      /home/u811502893/domains/yusiip.cm/public_html/vendor/doctrine/orm/src/EntityManager.php:162 {
        Doctrine\ORM\EntityManager->getMetadataFactory(): ClassMetadataFactory …
        › {
        ›     return $this->metadataFactory;
        › }
      }
      /home/u811502893/domains/yusiip.cm/public_html/vendor/doctrine/persistence/src/AbstractManagerRegistry.php:151 {
        Doctrine\Persistence\AbstractManagerRegistry->getManagerForClass(string $class): ObjectManager …
        › 
        › if (! $manager->getMetadataFactory()->isTransient($class)) {
        ›     return $manager;
      }
      /home/u811502893/domains/yusiip.cm/public_html/vendor/symfony/doctrine-bridge/ArgumentResolver/EntityValueResolver.php:95 {
        Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->getManager(?string $name, string $class): ObjectManager …
        › if (null === $name) {
        ›     return $this->registry->getManagerForClass($class);
        › }
      }
      /home/u811502893/domains/yusiip.cm/public_html/vendor/symfony/doctrine-bridge/ArgumentResolver/EntityValueResolver.php:59 {
        Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve(Request $request, ArgumentMetadata $argument): array …
        › 
        › if (!$manager = $this->getManager($options->objectManager, $options->class)) {
        ›     return [];
      }
      /home/u811502893/domains/yusiip.cm/public_html/vendor/symfony/http-kernel/Controller/ArgumentResolver/TraceableValueResolver.php:37 {
        Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve(Request $request, ArgumentMetadata $argument): iterable …
        › 
        › yield from $this->inner->resolve($request, $argument);
        › 
      }
      /home/u811502893/domains/yusiip.cm/public_html/vendor/symfony/http-kernel/Controller/ArgumentResolver.php:91 {
        Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments(Request $request, callable $controller, ?ReflectionFunctionAbstract $reflector = null): array …
        › $count = 0;
        › foreach ($resolver->resolve($request, $metadata) as $argument) {
        ›     ++$count;
      }
      /home/u811502893/domains/yusiip.cm/public_html/vendor/symfony/http-kernel/Controller/TraceableArgumentResolver.php:33 {
        Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments(Request $request, callable $controller, ?ReflectionFunctionAbstract $reflector = null): array …
        › try {
        ›     return $this->resolver->getArguments($request, $controller, $reflector);
        › } finally {
      }
      /home/u811502893/domains/yusiip.cm/public_html/vendor/symfony/http-kernel/HttpKernel.php:175 {
        Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
        › // controller arguments
        › $arguments = $this->argumentResolver->getArguments($request, $controller, $event->getControllerReflector());
        › 
      }
      /home/u811502893/domains/yusiip.cm/public_html/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/u811502893/domains/yusiip.cm/public_html/vendor/symfony/http-kernel/Kernel.php:193 {
        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/u811502893/domains/yusiip.cm/public_html/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
        Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
        › {
        ›     $response = $this->kernel->handle($this->request);
        › 
      }
      /home/u811502893/domains/yusiip.cm/public_html/vendor/autoload_runtime.php:32 {
        require_once …
        ›         ->getRunner($app)
        ›         ->run()
        › );
      }
      /home/u811502893/domains/yusiip.cm/public_html/public/index.php:5 {
        › 
        › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
        › 
      }
    }
  }
]

{
  /home/u811502893/domains/yusiip.cm/public_html/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/u811502893/domains/yusiip.cm/public_html/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/u811502893/domains/yusiip.cm/public_html/vendor/doctrine/dbal/src/Driver/AbstractMySQLDriver.php:75 {
    Doctrine\DBAL\Driver\AbstractMySQLDriver->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractMySQLPlatform …
    › 
    › Deprecation::trigger(
    ›     'doctrine/dbal',
  }
  /home/u811502893/domains/yusiip.cm/public_html/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:32 {
    Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform …
    › {
    ›     return $this->wrappedDriver->getDatabasePlatform($versionProvider);
    › }
  }
  /home/u811502893/domains/yusiip.cm/public_html/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:32 {
    Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform …
    › {
    ›     return $this->wrappedDriver->getDatabasePlatform($versionProvider);
    › }
  }
  /home/u811502893/domains/yusiip.cm/public_html/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:32 {
    Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform …
    › {
    ›     return $this->wrappedDriver->getDatabasePlatform($versionProvider);
    › }
  }
  /home/u811502893/domains/yusiip.cm/public_html/vendor/doctrine/doctrine-bundle/src/ConnectionFactory.php:127 {
    Doctrine\Bundle\DoctrineBundle\ConnectionFactory->createConnection(array $params, ?Configuration $config = null, ?EventManager $eventManager = null, array $mappingTypes = []) …
    › /** @phpstan-ignore arguments.count (DBAL < 4.x doesn't accept an argument) */
    › $platform = $driver->getDatabasePlatform(
    ›     ...(class_exists(StaticServerVersionProvider::class)
  }
  /home/u811502893/domains/yusiip.cm/public_html/var/cache/dev/ContainerMuEQb9a/App_KernelDevDebugContainer.php:848 {
    ContainerMuEQb9a\App_KernelDevDebugContainer::getDoctrine_Dbal_DefaultConnectionService($container) …
    › 
    ›     return $container->services['doctrine.dbal.default_connection'] = (new \Doctrine\Bundle\DoctrineBundle\ConnectionFactory($container->parameters['doctrine.dbal.connection_factory.types'], new \Doctrine\DBAL\Tools\DsnParser(['db2' => 'ibm_db2', 'mssql' => 'pdo_sqlsrv', 'mysql' => 'pdo_mysql', 'mysql2' => 'pdo_mysql', 'postgres' => 'pdo_pgsql', 'postgresql' => 'pdo_pgsql', 'pgsql' => 'pdo_pgsql', 'sqlite' => 'pdo_sqlite', 'sqlite3' => 'pdo_sqlite'])))->createConnection(['url' => $container->getEnv('resolve:DATABASE_URL'), 'use_savepoints' => true, 'driver' => 'pdo_mysql', 'idle_connection_ttl' => 600, 'host' => 'localhost', 'port' => NULL, 'user' => 'root', 'password' => NULL, 'driverOptions' => [], 'defaultTableOptions' => []], $a, NULL, []);
    › }
  }
  /home/u811502893/domains/yusiip.cm/public_html/var/cache/dev/ContainerMuEQb9a/App_KernelDevDebugContainer.php:867 {
    ContainerMuEQb9a\App_KernelDevDebugContainer::getDoctrine_Orm_DefaultEntityManagerService($container, $lazyLoad = true) …
    › 
    › $instance = ($lazyLoad->__construct(($container->services['doctrine.dbal.default_connection'] ?? self::getDoctrine_Dbal_DefaultConnectionService($container)), ($container->privates['doctrine.orm.default_configuration'] ?? self::getDoctrine_Orm_DefaultConfigurationService($container)), ($container->privates['doctrine.dbal.default_connection.event_manager'] ?? self::getDoctrine_Dbal_DefaultConnection_EventManagerService($container))) && false ?: $lazyLoad);
    › 
  }
  /home/u811502893/domains/yusiip.cm/public_html/var/cache/dev/ContainerMuEQb9a/App_KernelDevDebugContainer.php:859 {
    ContainerMuEQb9a\App_KernelDevDebugContainer::ContainerMuEQb9a\{closure} …
    › if (true === $lazyLoad) {
    ›     return $container->services['doctrine.orm.default_entity_manager'] = $container->createProxy('EntityManagerGhost614a58f', static fn () => \EntityManagerGhost614a58f::createLazyGhost(static fn ($proxy) => self::getDoctrine_Orm_DefaultEntityManagerService($container, $proxy)));
    › }
  }
  /home/u811502893/domains/yusiip.cm/public_html/vendor/symfony/var-exporter/Internal/LazyObjectState.php:60 {
    Symfony\Component\VarExporter\Internal\LazyObjectState->initialize($instance, $propertyName, $writeScope) …
    › 
    ›     ($this->initializer)($instance);
    › } catch (\Throwable $e) {
  }
  /home/u811502893/domains/yusiip.cm/public_html/vendor/symfony/var-exporter/LazyGhostTrait.php:153 {
    ContainerMuEQb9a\EntityManagerGhost614a58f->__get&($name): mixed …
    › 
    › if ($property?->isInitialized($this) ?? LazyObjectState::STATUS_UNINITIALIZED_PARTIAL !== $state->initialize($this, $name, $writeScope ?? $scope)) {
    ›     goto get_in_scope;
  }
  /home/u811502893/domains/yusiip.cm/public_html/vendor/doctrine/orm/src/EntityManager.php:162 {
    Doctrine\ORM\EntityManager->getMetadataFactory(): ClassMetadataFactory …
    › {
    ›     return $this->metadataFactory;
    › }
  }
  /home/u811502893/domains/yusiip.cm/public_html/vendor/doctrine/persistence/src/AbstractManagerRegistry.php:151 {
    Doctrine\Persistence\AbstractManagerRegistry->getManagerForClass(string $class): ObjectManager …
    › 
    › if (! $manager->getMetadataFactory()->isTransient($class)) {
    ›     return $manager;
  }
  /home/u811502893/domains/yusiip.cm/public_html/vendor/symfony/doctrine-bridge/ArgumentResolver/EntityValueResolver.php:95 {
    Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->getManager(?string $name, string $class): ObjectManager …
    › if (null === $name) {
    ›     return $this->registry->getManagerForClass($class);
    › }
  }
  /home/u811502893/domains/yusiip.cm/public_html/vendor/symfony/doctrine-bridge/ArgumentResolver/EntityValueResolver.php:59 {
    Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve(Request $request, ArgumentMetadata $argument): array …
    › 
    › if (!$manager = $this->getManager($options->objectManager, $options->class)) {
    ›     return [];
  }
  /home/u811502893/domains/yusiip.cm/public_html/vendor/symfony/http-kernel/Controller/ArgumentResolver/TraceableValueResolver.php:37 {
    Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve(Request $request, ArgumentMetadata $argument): iterable …
    › 
    › yield from $this->inner->resolve($request, $argument);
    › 
  }
  /home/u811502893/domains/yusiip.cm/public_html/vendor/symfony/http-kernel/Controller/ArgumentResolver.php:91 {
    Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments(Request $request, callable $controller, ?ReflectionFunctionAbstract $reflector = null): array …
    › $count = 0;
    › foreach ($resolver->resolve($request, $metadata) as $argument) {
    ›     ++$count;
  }
  /home/u811502893/domains/yusiip.cm/public_html/vendor/symfony/http-kernel/Controller/TraceableArgumentResolver.php:33 {
    Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments(Request $request, callable $controller, ?ReflectionFunctionAbstract $reflector = null): array …
    › try {
    ›     return $this->resolver->getArguments($request, $controller, $reflector);
    › } finally {
  }
  /home/u811502893/domains/yusiip.cm/public_html/vendor/symfony/http-kernel/HttpKernel.php:175 {
    Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
    › // controller arguments
    › $arguments = $this->argumentResolver->getArguments($request, $controller, $event->getControllerReflector());
    › 
  }
  /home/u811502893/domains/yusiip.cm/public_html/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/u811502893/domains/yusiip.cm/public_html/vendor/symfony/http-kernel/Kernel.php:193 {
    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/u811502893/domains/yusiip.cm/public_html/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
    Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
    › {
    ›     $response = $this->kernel->handle($this->request);
    › 
  }
  /home/u811502893/domains/yusiip.cm/public_html/vendor/autoload_runtime.php:32 {
    require_once …
    ›         ->getRunner($app)
    ›         ->run()
    › );
  }
  /home/u811502893/domains/yusiip.cm/public_html/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" => "u811502893_yusiip"
  "password" => "<redacted>"
  "driverOptions" => []
  "defaultTableOptions" => [
    "collation" => "utf8mb4_unicode_ci"
  ]
  "dbname" => "u811502893_yusiip"
  "charset" => "utf8mb4"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "u811502893_yusiip"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "u811502893_yusiip"
    "charset" => "utf8mb4"
  ]
]

"SELECT s0_.id AS id_0, s0_.libelle AS libelle_1, s0_.created_at AS created_at_2, s0_.thematique_id AS thematique_id_3 FROM sous_thematique s0_ INNER JOIN thematique t1_ ON s0_.thematique_id = t1_.id WHERE t1_.libelle = ? ORDER BY s0_.libelle ASC"

[
  1 => "Urbanisme"
]

[
  1 => Doctrine\DBAL\ParameterType {#980
    +name: "STRING"
  }
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.libelle AS libelle_1, s0_.created_at AS created_at_2, s0_.thematique_id AS thematique_id_3 FROM sous_thematique s0_ INNER JOIN thematique t1_ ON s0_.thematique_id = t1_.id WHERE t1_.libelle = ? ORDER BY s0_.libelle ASC"
  "params" => [
    1 => "Urbanisme"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#980
      +name: "STRING"
    }
  ]
]

"SELECT s0_.id AS id_0, s0_.libelle AS libelle_1, s0_.created_at AS created_at_2, s0_.thematique_id AS thematique_id_3 FROM sous_thematique s0_ INNER JOIN thematique t1_ ON s0_.thematique_id = t1_.id WHERE t1_.libelle = ? ORDER BY s0_.libelle ASC"

[
  1 => "Aménagement"
]

[
  1 => Doctrine\DBAL\ParameterType {#980
    +name: "STRING"
  }
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.libelle AS libelle_1, s0_.created_at AS created_at_2, s0_.thematique_id AS thematique_id_3 FROM sous_thematique s0_ INNER JOIN thematique t1_ ON s0_.thematique_id = t1_.id WHERE t1_.libelle = ? ORDER BY s0_.libelle ASC"
  "params" => [
    1 => "Aménagement"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#980
      +name: "STRING"
    }
  ]
]

"SELECT s0_.id AS id_0, s0_.libelle AS libelle_1, s0_.created_at AS created_at_2, s0_.thematique_id AS thematique_id_3 FROM sous_thematique s0_ INNER JOIN thematique t1_ ON s0_.thematique_id = t1_.id WHERE t1_.libelle = ? ORDER BY s0_.libelle ASC"

[
  1 => "Environnement"
]

[
  1 => Doctrine\DBAL\ParameterType {#980
    +name: "STRING"
  }
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.libelle AS libelle_1, s0_.created_at AS created_at_2, s0_.thematique_id AS thematique_id_3 FROM sous_thematique s0_ INNER JOIN thematique t1_ ON s0_.thematique_id = t1_.id WHERE t1_.libelle = ? ORDER BY s0_.libelle ASC"
  "params" => [
    1 => "Environnement"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#980
      +name: "STRING"
    }
  ]
]

"SELECT s0_.id AS id_0, s0_.libelle AS libelle_1, s0_.created_at AS created_at_2, s0_.thematique_id AS thematique_id_3 FROM sous_thematique s0_ INNER JOIN thematique t1_ ON s0_.thematique_id = t1_.id WHERE t1_.libelle = ? ORDER BY s0_.libelle ASC"

[
  1 => "Institution"
]

[
  1 => Doctrine\DBAL\ParameterType {#980
    +name: "STRING"
  }
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.libelle AS libelle_1, s0_.created_at AS created_at_2, s0_.thematique_id AS thematique_id_3 FROM sous_thematique s0_ INNER JOIN thematique t1_ ON s0_.thematique_id = t1_.id WHERE t1_.libelle = ? ORDER BY s0_.libelle ASC"
  "params" => [
    1 => "Institution"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#980
      +name: "STRING"
    }
  ]
]

"SELECT t0.id AS id_1, t0.titre AS titre_2, t0.titre_en AS titre_en_3, t0.contenu AS contenu_4, t0.contenu_en AS contenu_en_5, t0.image AS image_6, t0.legende AS legende_7, t0.legende_en AS legende_en_8, t0.created_at AS created_at_9, t0.thematique_id AS thematique_id_10 FROM problemes t0 WHERE t0.thematique_id = ? ORDER BY t0.created_at DESC LIMIT 3"

[
  1 => 1
]

[
  1 => Doctrine\DBAL\ParameterType {#1082
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.titre AS titre_2, t0.titre_en AS titre_en_3, t0.contenu AS contenu_4, t0.contenu_en AS contenu_en_5, t0.image AS image_6, t0.legende AS legende_7, t0.legende_en AS legende_en_8, t0.created_at AS created_at_9, t0.thematique_id AS thematique_id_10 FROM problemes t0 WHERE t0.thematique_id = ? ORDER BY t0.created_at DESC LIMIT 3"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1082
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.titre AS titre_2, t0.titre_en AS titre_en_3, t0.contenu AS contenu_4, t0.contenu_en AS contenu_en_5, t0.image AS image_6, t0.legende AS legende_7, t0.legende_en AS legende_en_8, t0.created_at AS created_at_9, t0.thematique_id AS thematique_id_10 FROM problemes t0 WHERE t0.thematique_id = ? ORDER BY t0.created_at DESC LIMIT 3"

[
  1 => 2
]

[
  1 => Doctrine\DBAL\ParameterType {#1082
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.titre AS titre_2, t0.titre_en AS titre_en_3, t0.contenu AS contenu_4, t0.contenu_en AS contenu_en_5, t0.image AS image_6, t0.legende AS legende_7, t0.legende_en AS legende_en_8, t0.created_at AS created_at_9, t0.thematique_id AS thematique_id_10 FROM problemes t0 WHERE t0.thematique_id = ? ORDER BY t0.created_at DESC LIMIT 3"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1082
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.titre AS titre_2, t0.titre_en AS titre_en_3, t0.contenu AS contenu_4, t0.contenu_en AS contenu_en_5, t0.image AS image_6, t0.legende AS legende_7, t0.legende_en AS legende_en_8, t0.created_at AS created_at_9, t0.thematique_id AS thematique_id_10 FROM problemes t0 WHERE t0.thematique_id = ? ORDER BY t0.created_at DESC LIMIT 3"

[
  1 => 3
]

[
  1 => Doctrine\DBAL\ParameterType {#1082
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.titre AS titre_2, t0.titre_en AS titre_en_3, t0.contenu AS contenu_4, t0.contenu_en AS contenu_en_5, t0.image AS image_6, t0.legende AS legende_7, t0.legende_en AS legende_en_8, t0.created_at AS created_at_9, t0.thematique_id AS thematique_id_10 FROM problemes t0 WHERE t0.thematique_id = ? ORDER BY t0.created_at DESC LIMIT 3"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1082
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.description AS description_4, t0.created_at AS created_at_5 FROM dossier_redaction t0 ORDER BY t0.id DESC"

[
  "sql" => "SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.description AS description_4, t0.created_at AS created_at_5 FROM dossier_redaction t0 ORDER BY t0.id DESC"
]

"SELECT COUNT(v0_.id) AS sclr_0 FROM visiteur v0_ WHERE v0_.last_seen_at >= ?"

[
  1 => "2026-11-12 14:52:53"
]

[
  1 => Doctrine\DBAL\ParameterType {#980
    +name: "STRING"
  }
]

[
  "sql" => "SELECT COUNT(v0_.id) AS sclr_0 FROM visiteur v0_ WHERE v0_.last_seen_at >= ?"
  "params" => [
    1 => "2026-11-12 14:52:53"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#980
      +name: "STRING"
    }
  ]
]

"SELECT COUNT(v0_.id) AS sclr_0 FROM visiteur v0_ WHERE v0_.first_seen_at >= ?"

[
  1 => "2026-11-12 00:00:00"
]

[
  1 => Doctrine\DBAL\ParameterType {#980
    +name: "STRING"
  }
]

[
  "sql" => "SELECT COUNT(v0_.id) AS sclr_0 FROM visiteur v0_ WHERE v0_.first_seen_at >= ?"
  "params" => [
    1 => "2026-11-12 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#980
      +name: "STRING"
    }
  ]
]

"SELECT COUNT(v0_.id) AS sclr_0 FROM visiteur v0_ WHERE v0_.first_seen_at >= ?"

[
  1 => "2026-11-01 00:00:00"
]

[
  1 => Doctrine\DBAL\ParameterType {#980
    +name: "STRING"
  }
]

[
  "sql" => "SELECT COUNT(v0_.id) AS sclr_0 FROM visiteur v0_ WHERE v0_.first_seen_at >= ?"
  "params" => [
    1 => "2026-11-01 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#980
      +name: "STRING"
    }
  ]
]

"SELECT COUNT(v0_.id) AS sclr_0 FROM visiteur v0_ WHERE v0_.first_seen_at >= ?"

[
  1 => "2026-01-01 00:00:00"
]

[
  1 => Doctrine\DBAL\ParameterType {#980
    +name: "STRING"
  }
]

[
  "sql" => "SELECT COUNT(v0_.id) AS sclr_0 FROM visiteur v0_ WHERE v0_.first_seen_at >= ?"
  "params" => [
    1 => "2026-01-01 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#980
      +name: "STRING"
    }
  ]
]

"SELECT COUNT(v0_.id) AS sclr_0 FROM visiteur v0_"

[
  "sql" => "SELECT COUNT(v0_.id) AS sclr_0 FROM visiteur v0_"
]