Symfony Profiler

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

Log Messages

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

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

[
  "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#144
    +count: 39
    -severity: E_WARNING
    trace: {
      /home/baddalg/drilleedo/vendor/symfony/error-handler/DebugClassLoader.php:303 {
        Symfony\Component\ErrorHandler\DebugClassLoader->loadClass(string $class): void …
        ›     // no-op
        › } elseif (\function_exists('opcache_is_script_cached') && @opcache_is_script_cached($file)) {
        ›     include $file;
      }
      /home/baddalg/drilleedo/vendor/symfony/debug-bundle/DebugBundle.php:35 {
        › // will buffer it, and release it at the end of the script.
        › VarDumper::setHandler(function ($var, ?string $label = null) use ($container) {
        ›     $dumper = $container->get('data_collector.dump');
      }
    }
  }
]

{
  /home/baddalg/drilleedo/vendor/symfony/error-handler/DebugClassLoader.php:303 {
    Symfony\Component\ErrorHandler\DebugClassLoader->loadClass(string $class): void …
    ›     // no-op
    › } elseif (\function_exists('opcache_is_script_cached') && @opcache_is_script_cached($file)) {
    ›     include $file;
  }
  /home/baddalg/drilleedo/vendor/symfony/debug-bundle/DebugBundle.php:35 {
    › // will buffer it, and release it at the end of the script.
    › VarDumper::setHandler(function ($var, ?string $label = null) use ($container) {
    ›     $dumper = $container->get('data_collector.dump');
  }
}

"professionals_list"

[
  "route" => "professionals_list"
  "route_parameters" => [
    "_route" => "professionals_list"
    "_controller" => "App\Controller\HomeController::professionals"
  ]
  "request_uri" => "https://drilleedo.softsquareit.com/professionals?page=2"
  "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 {#601
    #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/baddalg/drilleedo/vendor/doctrine/deprecations/src/Deprecation.php"
    #line: 208
    #severity: E_USER_DEPRECATED
    trace: {
      /home/baddalg/drilleedo/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/baddalg/drilleedo/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/baddalg/drilleedo/vendor/doctrine/dbal/src/Driver/AbstractMySQLDriver.php:75 {
        Doctrine\DBAL\Driver\AbstractMySQLDriver->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractMySQLPlatform …
        › 
        › Deprecation::trigger(
        ›     'doctrine/dbal',
      }
      /home/baddalg/drilleedo/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:32 {
        Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform …
        › {
        ›     return $this->wrappedDriver->getDatabasePlatform($versionProvider);
        › }
      }
      /home/baddalg/drilleedo/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:32 {
        Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform …
        › {
        ›     return $this->wrappedDriver->getDatabasePlatform($versionProvider);
        › }
      }
      /home/baddalg/drilleedo/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:32 {
        Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform …
        › {
        ›     return $this->wrappedDriver->getDatabasePlatform($versionProvider);
        › }
      }
      /home/baddalg/drilleedo/vendor/doctrine/doctrine-bundle/src/ConnectionFactory.php:102 {
        Doctrine\Bundle\DoctrineBundle\ConnectionFactory->createConnection(array $params, ?Configuration $config = null, array $mappingTypes = []): Connection …
        › $driver     = $connection->getDriver();
        › $platform   = $driver->getDatabasePlatform(new StaticServerVersionProvider(
        ›     $params['serverVersion'] ?? $params['primary']['serverVersion'] ?? '',
      }
      /home/baddalg/drilleedo/var/cache/dev/ContainerKLONzVj/App_KernelDevDebugContainer.php:794 {
        ContainerKLONzVj\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'), 'driver' => 'pdo_mysql', 'idle_connection_ttl' => 600, 'host' => 'localhost', 'port' => NULL, 'user' => 'root', 'password' => NULL, 'driverOptions' => [], 'defaultTableOptions' => []], $a, []);
        › }
      }
      /home/baddalg/drilleedo/var/cache/dev/ContainerKLONzVj/App_KernelDevDebugContainer.php:813 {
        ContainerKLONzVj\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/baddalg/drilleedo/var/cache/dev/ContainerKLONzVj/App_KernelDevDebugContainer.php:805 {
        ContainerKLONzVj\App_KernelDevDebugContainer::{closure:ContainerKLONzVj\App_KernelDevDebugContainer::getDoctrine_Orm_DefaultEntityManagerService():805} …
        › if (true === $lazyLoad) {
        ›     return $container->services['doctrine.orm.default_entity_manager'] = new \ReflectionClass('Doctrine\ORM\EntityManager')->newLazyGhost(static function ($proxy) use ($container) { self::getDoctrine_Orm_DefaultEntityManagerService($container, $proxy); });
        › }
      }
      /home/baddalg/drilleedo/vendor/doctrine/orm/src/EntityManager.php:162 {
        Doctrine\ORM\EntityManager->getMetadataFactory(): ClassMetadataFactory …
        › {
        ›     return $this->metadataFactory;
        › }
      }
      /home/baddalg/drilleedo/vendor/doctrine/persistence/src/Persistence/AbstractManagerRegistry.php:149 {
        Doctrine\Persistence\AbstractManagerRegistry->getManagerForClass(string $class): ObjectManager …
        › 
        › if (! $manager->getMetadataFactory()->isTransient($class)) {
        ›     return $manager;
      }
      /home/baddalg/drilleedo/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/baddalg/drilleedo/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/baddalg/drilleedo/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/baddalg/drilleedo/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/baddalg/drilleedo/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/baddalg/drilleedo/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/baddalg/drilleedo/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/baddalg/drilleedo/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/baddalg/drilleedo/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
        Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
        › {
        ›     $response = $this->kernel->handle($this->request);
        › 
      }
      /home/baddalg/drilleedo/vendor/autoload_runtime.php:32 {
        require_once …
        ›         ->getRunner($app)
        ›         ->run()
        › );
      }
      /home/baddalg/drilleedo/public/index.php:5 {
        › 
        › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
        › 
      }
    }
  }
]

{
  /home/baddalg/drilleedo/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/baddalg/drilleedo/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/baddalg/drilleedo/vendor/doctrine/dbal/src/Driver/AbstractMySQLDriver.php:75 {
    Doctrine\DBAL\Driver\AbstractMySQLDriver->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractMySQLPlatform …
    › 
    › Deprecation::trigger(
    ›     'doctrine/dbal',
  }
  /home/baddalg/drilleedo/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:32 {
    Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform …
    › {
    ›     return $this->wrappedDriver->getDatabasePlatform($versionProvider);
    › }
  }
  /home/baddalg/drilleedo/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:32 {
    Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform …
    › {
    ›     return $this->wrappedDriver->getDatabasePlatform($versionProvider);
    › }
  }
  /home/baddalg/drilleedo/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:32 {
    Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform …
    › {
    ›     return $this->wrappedDriver->getDatabasePlatform($versionProvider);
    › }
  }
  /home/baddalg/drilleedo/vendor/doctrine/doctrine-bundle/src/ConnectionFactory.php:102 {
    Doctrine\Bundle\DoctrineBundle\ConnectionFactory->createConnection(array $params, ?Configuration $config = null, array $mappingTypes = []): Connection …
    › $driver     = $connection->getDriver();
    › $platform   = $driver->getDatabasePlatform(new StaticServerVersionProvider(
    ›     $params['serverVersion'] ?? $params['primary']['serverVersion'] ?? '',
  }
  /home/baddalg/drilleedo/var/cache/dev/ContainerKLONzVj/App_KernelDevDebugContainer.php:794 {
    ContainerKLONzVj\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'), 'driver' => 'pdo_mysql', 'idle_connection_ttl' => 600, 'host' => 'localhost', 'port' => NULL, 'user' => 'root', 'password' => NULL, 'driverOptions' => [], 'defaultTableOptions' => []], $a, []);
    › }
  }
  /home/baddalg/drilleedo/var/cache/dev/ContainerKLONzVj/App_KernelDevDebugContainer.php:813 {
    ContainerKLONzVj\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/baddalg/drilleedo/var/cache/dev/ContainerKLONzVj/App_KernelDevDebugContainer.php:805 {
    ContainerKLONzVj\App_KernelDevDebugContainer::{closure:ContainerKLONzVj\App_KernelDevDebugContainer::getDoctrine_Orm_DefaultEntityManagerService():805} …
    › if (true === $lazyLoad) {
    ›     return $container->services['doctrine.orm.default_entity_manager'] = new \ReflectionClass('Doctrine\ORM\EntityManager')->newLazyGhost(static function ($proxy) use ($container) { self::getDoctrine_Orm_DefaultEntityManagerService($container, $proxy); });
    › }
  }
  /home/baddalg/drilleedo/vendor/doctrine/orm/src/EntityManager.php:162 {
    Doctrine\ORM\EntityManager->getMetadataFactory(): ClassMetadataFactory …
    › {
    ›     return $this->metadataFactory;
    › }
  }
  /home/baddalg/drilleedo/vendor/doctrine/persistence/src/Persistence/AbstractManagerRegistry.php:149 {
    Doctrine\Persistence\AbstractManagerRegistry->getManagerForClass(string $class): ObjectManager …
    › 
    › if (! $manager->getMetadataFactory()->isTransient($class)) {
    ›     return $manager;
  }
  /home/baddalg/drilleedo/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/baddalg/drilleedo/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/baddalg/drilleedo/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/baddalg/drilleedo/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/baddalg/drilleedo/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/baddalg/drilleedo/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/baddalg/drilleedo/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/baddalg/drilleedo/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/baddalg/drilleedo/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
    Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
    › {
    ›     $response = $this->kernel->handle($this->request);
    › 
  }
  /home/baddalg/drilleedo/vendor/autoload_runtime.php:32 {
    require_once …
    ›         ->getRunner($app)
    ›         ->run()
    › );
  }
  /home/baddalg/drilleedo/public/index.php:5 {
    › 
    › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
    › 
  }
}

[
  "driver" => "pdo_mysql"
  "idle_connection_ttl" => 600
  "host" => "baddalgprod.mysql.db"
  "port" => 3306
  "user" => "baddalgprod"
  "password" => "<redacted>"
  "driverOptions" => []
  "defaultTableOptions" => [
    "collation" => "utf8mb4_unicode_ci"
  ]
  "dbname" => "baddalgprod"
  "charset" => "utf8mb4"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "baddalgprod.mysql.db"
    "port" => 3306
    "user" => "baddalgprod"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "baddalgprod"
    "charset" => "utf8mb4"
  ]
]

"SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, b1_.company_name AS company_name_3, b1_.trade_name AS trade_name_4, b1_.licence_num AS licence_num_5, b1_.company_num AS company_num_6, b1_.logo AS logo_7, b1_.banner AS banner_8, b1_.phone_num AS phone_num_9, b1_.about AS about_10, b1_.why_choose_us AS why_choose_us_11, b1_.services AS services_12, p2_.city AS city_13, p2_.exp_years AS exp_years_14, u0_.type AS type_15 FROM professional p2_ INNER JOIN business b1_ ON p2_.id = b1_.id INNER JOIN `user` u0_ ON p2_.id = u0_.id ORDER BY u0_.id DESC) dctrn_result) dctrn_table"

[
  "sql" => "SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, b1_.company_name AS company_name_3, b1_.trade_name AS trade_name_4, b1_.licence_num AS licence_num_5, b1_.company_num AS company_num_6, b1_.logo AS logo_7, b1_.banner AS banner_8, b1_.phone_num AS phone_num_9, b1_.about AS about_10, b1_.why_choose_us AS why_choose_us_11, b1_.services AS services_12, p2_.city AS city_13, p2_.exp_years AS exp_years_14, u0_.type AS type_15 FROM professional p2_ INNER JOIN business b1_ ON p2_.id = b1_.id INNER JOIN `user` u0_ ON p2_.id = u0_.id ORDER BY u0_.id DESC) dctrn_result) dctrn_table"
]

"SELECT t0.id AS id_1, t0.name AS name_2, t0.parent_id AS parent_id_3 FROM category t0 ORDER BY t0.name ASC"

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.parent_id AS parent_id_3 FROM category t0 ORDER BY t0.name ASC"
]

"SELECT DISTINCT p0_.city AS city_0 FROM professional p0_ INNER JOIN business b1_ ON p0_.id = b1_.id INNER JOIN `user` u2_ ON p0_.id = u2_.id WHERE p0_.city IS NOT NULL ORDER BY p0_.city ASC"

[
  "sql" => "SELECT DISTINCT p0_.city AS city_0 FROM professional p0_ INNER JOIN business b1_ ON p0_.id = b1_.id INNER JOIN `user` u2_ ON p0_.id = u2_.id WHERE p0_.city IS NOT NULL ORDER BY p0_.city ASC"
]

"SELECT p0_.category_id AS sclr_0, COUNT(u1_.id) AS sclr_1 FROM professional p0_ INNER JOIN business b2_ ON p0_.id = b2_.id INNER JOIN `user` u1_ ON p0_.id = u1_.id GROUP BY p0_.category_id"

[
  "sql" => "SELECT p0_.category_id AS sclr_0, COUNT(u1_.id) AS sclr_1 FROM professional p0_ INNER JOIN business b2_ ON p0_.id = b2_.id INNER JOIN `user` u1_ ON p0_.id = u1_.id GROUP BY p0_.category_id"
]

"SELECT p0_.city AS city_0, COUNT(u1_.id) AS sclr_1 FROM professional p0_ INNER JOIN business b2_ ON p0_.id = b2_.id INNER JOIN `user` u1_ ON p0_.id = u1_.id WHERE p0_.city IS NOT NULL GROUP BY p0_.city"

[
  "sql" => "SELECT p0_.city AS city_0, COUNT(u1_.id) AS sclr_1 FROM professional p0_ INNER JOIN business b2_ ON p0_.id = b2_.id INNER JOIN `user` u1_ ON p0_.id = u1_.id WHERE p0_.city IS NOT NULL GROUP BY p0_.city"
]

"SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, b1_.company_name AS company_name_3, b1_.trade_name AS trade_name_4, b1_.licence_num AS licence_num_5, b1_.company_num AS company_num_6, b1_.logo AS logo_7, b1_.banner AS banner_8, b1_.phone_num AS phone_num_9, b1_.about AS about_10, b1_.why_choose_us AS why_choose_us_11, b1_.services AS services_12, p2_.city AS city_13, p2_.exp_years AS exp_years_14, u0_.type AS type_15 FROM professional p2_ INNER JOIN business b1_ ON p2_.id = b1_.id INNER JOIN `user` u0_ ON p2_.id = u0_.id) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 6 OFFSET 6"

[
  "sql" => "SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, b1_.company_name AS company_name_3, b1_.trade_name AS trade_name_4, b1_.licence_num AS licence_num_5, b1_.company_num AS company_num_6, b1_.logo AS logo_7, b1_.banner AS banner_8, b1_.phone_num AS phone_num_9, b1_.about AS about_10, b1_.why_choose_us AS why_choose_us_11, b1_.services AS services_12, p2_.city AS city_13, p2_.exp_years AS exp_years_14, u0_.type AS type_15 FROM professional p2_ INNER JOIN business b1_ ON p2_.id = b1_.id INNER JOIN `user` u0_ ON p2_.id = u0_.id) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 6 OFFSET 6"
]

"SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, b1_.company_name AS company_name_3, b1_.trade_name AS trade_name_4, b1_.licence_num AS licence_num_5, b1_.company_num AS company_num_6, b1_.logo AS logo_7, b1_.banner AS banner_8, b1_.phone_num AS phone_num_9, b1_.about AS about_10, b1_.why_choose_us AS why_choose_us_11, b1_.services AS services_12, p2_.city AS city_13, p2_.exp_years AS exp_years_14, u0_.type AS type_15, u0_.personal_infos_id AS personal_infos_id_16, b1_.primary_contact_id AS primary_contact_id_17, b1_.entrepreneur_type_id AS entrepreneur_type_id_18, p2_.category_id AS category_id_19 FROM professional p2_ INNER JOIN business b1_ ON p2_.id = b1_.id INNER JOIN `user` u0_ ON p2_.id = u0_.id WHERE u0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY u0_.id DESC"

[
  1 => 16
  2 => 15
  3 => 14
  4 => 13
  5 => 12
  6 => 11
]

[
  1 => Doctrine\DBAL\ParameterType {#1340
    +name: "INTEGER"
  }
  2 => Doctrine\DBAL\ParameterType {#1340}
  3 => Doctrine\DBAL\ParameterType {#1340}
  4 => Doctrine\DBAL\ParameterType {#1340}
  5 => Doctrine\DBAL\ParameterType {#1340}
  6 => Doctrine\DBAL\ParameterType {#1340}
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, b1_.company_name AS company_name_3, b1_.trade_name AS trade_name_4, b1_.licence_num AS licence_num_5, b1_.company_num AS company_num_6, b1_.logo AS logo_7, b1_.banner AS banner_8, b1_.phone_num AS phone_num_9, b1_.about AS about_10, b1_.why_choose_us AS why_choose_us_11, b1_.services AS services_12, p2_.city AS city_13, p2_.exp_years AS exp_years_14, u0_.type AS type_15, u0_.personal_infos_id AS personal_infos_id_16, b1_.primary_contact_id AS primary_contact_id_17, b1_.entrepreneur_type_id AS entrepreneur_type_id_18, p2_.category_id AS category_id_19 FROM professional p2_ INNER JOIN business b1_ ON p2_.id = b1_.id INNER JOIN `user` u0_ ON p2_.id = u0_.id WHERE u0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY u0_.id DESC"
  "params" => [
    1 => 16
    2 => 15
    3 => 14
    4 => 13
    5 => 12
    6 => 11
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1340
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1340}
    3 => Doctrine\DBAL\ParameterType {#1340}
    4 => Doctrine\DBAL\ParameterType {#1340}
    5 => Doctrine\DBAL\ParameterType {#1340}
    6 => Doctrine\DBAL\ParameterType {#1340}
  ]
]

"SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.phone AS phone_4, t0.email AS email_5 FROM primary_contact t0 WHERE t0.id = ?"

[
  1 => 15
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.phone AS phone_4, t0.email AS email_5 FROM primary_contact t0 WHERE t0.id = ?"
  "params" => [
    1 => 15
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1340
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.phone AS phone_4, t0.email AS email_5 FROM primary_contact t0 WHERE t0.id = ?"

[
  1 => 14
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.phone AS phone_4, t0.email AS email_5 FROM primary_contact t0 WHERE t0.id = ?"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1340
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.phone AS phone_4, t0.email AS email_5 FROM primary_contact t0 WHERE t0.id = ?"

[
  1 => 13
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.phone AS phone_4, t0.email AS email_5 FROM primary_contact t0 WHERE t0.id = ?"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1340
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.phone AS phone_4, t0.email AS email_5 FROM primary_contact t0 WHERE t0.id = ?"

[
  1 => 12
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.phone AS phone_4, t0.email AS email_5 FROM primary_contact t0 WHERE t0.id = ?"
  "params" => [
    1 => 12
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1340
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.phone AS phone_4, t0.email AS email_5 FROM primary_contact t0 WHERE t0.id = ?"

[
  1 => 11
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.phone AS phone_4, t0.email AS email_5 FROM primary_contact t0 WHERE t0.id = ?"
  "params" => [
    1 => 11
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1340
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.phone AS phone_4, t0.email AS email_5 FROM primary_contact t0 WHERE t0.id = ?"

[
  1 => 10
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.phone AS phone_4, t0.email AS email_5 FROM primary_contact t0 WHERE t0.id = ?"
  "params" => [
    1 => 10
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1340
      +name: "INTEGER"
    }
  ]
]