Symfony Profiler

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

Log Messages

[
  "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#1505
    +count: 1
    -severity: E_USER_DEPRECATED
    trace: {
      /var/www/kinderhobby.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);
        › }
      }
      /var/www/kinderhobby.com/vendor/doctrine/deprecations/src/Deprecation.php:108 {
        › 
        ›     self::delegateTriggerToBackend($message, $backtrace, $link, $package);
        › }
      }
    }
  }
]

{
  /var/www/kinderhobby.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);
    › }
  }
  /var/www/kinderhobby.com/vendor/doctrine/deprecations/src/Deprecation.php:108 {
    › 
    ›     self::delegateTriggerToBackend($message, $backtrace, $link, $package);
    › }
  }
}

"app_home"

[
  "route" => "app_home"
  "route_parameters" => [
    "_route" => "app_home"
    "_controller" => "App\Controller\PageController::homepageAction"
  ]
  "request_uri" => "https://kinderhobby.com/"
  "method" => "GET"
]

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

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

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

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

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

[
  "exception" => ErrorException {#527
    #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: "/var/www/kinderhobby.com/vendor/doctrine/deprecations/src/Deprecation.php"
    #line: 208
    #severity: E_USER_DEPRECATED
    trace: {
      /var/www/kinderhobby.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);
        › }
      }
      /var/www/kinderhobby.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);
        › }
      }
      /var/www/kinderhobby.com/vendor/doctrine/dbal/src/Driver/AbstractMySQLDriver.php:75 {
        Doctrine\DBAL\Driver\AbstractMySQLDriver->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractMySQLPlatform …
        › 
        › Deprecation::trigger(
        ›     'doctrine/dbal',
      }
      /var/www/kinderhobby.com/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:32 {
        Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform …
        › {
        ›     return $this->wrappedDriver->getDatabasePlatform($versionProvider);
        › }
      }
      /var/www/kinderhobby.com/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:32 {
        Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform …
        › {
        ›     return $this->wrappedDriver->getDatabasePlatform($versionProvider);
        › }
      }
      /var/www/kinderhobby.com/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:32 {
        Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform …
        › {
        ›     return $this->wrappedDriver->getDatabasePlatform($versionProvider);
        › }
      }
      /var/www/kinderhobby.com/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'] ?? '',
      }
      /var/www/kinderhobby.com/var/cache/dev/ContainerSiIPYx5/App_KernelDevDebugContainer.php:827 {
        ContainerSiIPYx5\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, []);
        › }
      }
      /var/www/kinderhobby.com/var/cache/dev/ContainerSiIPYx5/App_KernelDevDebugContainer.php:846 {
        ContainerSiIPYx5\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);
        › 
      }
      /var/www/kinderhobby.com/var/cache/dev/ContainerSiIPYx5/App_KernelDevDebugContainer.php:838 {
        ContainerSiIPYx5\App_KernelDevDebugContainer::{closure:ContainerSiIPYx5\App_KernelDevDebugContainer::getDoctrine_Orm_DefaultEntityManagerService():838} …
        › 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); });
        › }
      }
      /var/www/kinderhobby.com/vendor/doctrine/orm/src/EntityManager.php:162 {
        Doctrine\ORM\EntityManager->getMetadataFactory(): ClassMetadataFactory …
        › {
        ›     return $this->metadataFactory;
        › }
      }
      /var/www/kinderhobby.com/vendor/doctrine/persistence/src/AbstractManagerRegistry.php:151 {
        Doctrine\Persistence\AbstractManagerRegistry->getManagerForClass(string $class): ObjectManager …
        › 
        › if (! $manager->getMetadataFactory()->isTransient($class)) {
        ›     return $manager;
      }
      /var/www/kinderhobby.com/vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepository.php:129 {
        Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->resolveRepository(): EntityRepository …
        › {
        ›     $manager = $this->registry->getManagerForClass($this->entityClass);
        › 
      }
      /var/www/kinderhobby.com/vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepository.php:52 {
        Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->createQueryBuilder(string $alias, ?string $indexBy = null): QueryBuilder …
        › {
        ›     return ($this->repository ??= $this->resolveRepository())
        ›         ->createQueryBuilder($alias, $indexBy);
      }
      /var/www/kinderhobby.com/src/Repository/ActivityRepository.php:22 {
        App\Repository\ActivityRepository->findByFilter(ActivityFilter $filter): array …
        › {
        ›     $qb = $this->createQueryBuilder('a');
        › 
      }
      /var/www/kinderhobby.com/src/Service/ActivityFilterProvider.php:54 {
        App\Service\ActivityFilterProvider->getActivitiesByFilter(array $categoryIds, array $types = [], ?DateTimeImmutable $dateFrom = null, ?DateTimeImmutable $dateTo = null): array …
        › 
        ›     return $this->activityRepository->findByFilter($filter);
        › }
      }
      /var/www/kinderhobby.com/src/Service/ActivityFilterProvider.php:21 {
        App\Service\ActivityFilterProvider->getHomepageActivities(): array …
        › {
        ›     return $this->getActivitiesByFilter([]);
        › }
      }
      /var/www/kinderhobby.com/src/Controller/PageController.php:24 {
        App\Controller\PageController->homepageAction(): Response …
        › {
        ›     $activities = $this->activityFilterProvider->getHomepageActivities();
        › 
      }
      /var/www/kinderhobby.com/vendor/symfony/http-kernel/HttpKernel.php:183 {
        Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
        › // call controller
        › $response = $controller(...$arguments);
        › 
      }
      /var/www/kinderhobby.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) {
      }
      /var/www/kinderhobby.com/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 {
      }
      /var/www/kinderhobby.com/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
        Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
        › {
        ›     $response = $this->kernel->handle($this->request);
        › 
      }
      /var/www/kinderhobby.com/vendor/autoload_runtime.php:32 {
        require_once …
        ›         ->getRunner($app)
        ›         ->run()
        › );
      }
      /var/www/kinderhobby.com/public/index.php:5 {
        › 
        › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
        › 
      }
    }
  }
]

{
  /var/www/kinderhobby.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);
    › }
  }
  /var/www/kinderhobby.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);
    › }
  }
  /var/www/kinderhobby.com/vendor/doctrine/dbal/src/Driver/AbstractMySQLDriver.php:75 {
    Doctrine\DBAL\Driver\AbstractMySQLDriver->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractMySQLPlatform …
    › 
    › Deprecation::trigger(
    ›     'doctrine/dbal',
  }
  /var/www/kinderhobby.com/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:32 {
    Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform …
    › {
    ›     return $this->wrappedDriver->getDatabasePlatform($versionProvider);
    › }
  }
  /var/www/kinderhobby.com/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:32 {
    Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform …
    › {
    ›     return $this->wrappedDriver->getDatabasePlatform($versionProvider);
    › }
  }
  /var/www/kinderhobby.com/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:32 {
    Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractPlatform …
    › {
    ›     return $this->wrappedDriver->getDatabasePlatform($versionProvider);
    › }
  }
  /var/www/kinderhobby.com/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'] ?? '',
  }
  /var/www/kinderhobby.com/var/cache/dev/ContainerSiIPYx5/App_KernelDevDebugContainer.php:827 {
    ContainerSiIPYx5\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, []);
    › }
  }
  /var/www/kinderhobby.com/var/cache/dev/ContainerSiIPYx5/App_KernelDevDebugContainer.php:846 {
    ContainerSiIPYx5\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);
    › 
  }
  /var/www/kinderhobby.com/var/cache/dev/ContainerSiIPYx5/App_KernelDevDebugContainer.php:838 {
    ContainerSiIPYx5\App_KernelDevDebugContainer::{closure:ContainerSiIPYx5\App_KernelDevDebugContainer::getDoctrine_Orm_DefaultEntityManagerService():838} …
    › 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); });
    › }
  }
  /var/www/kinderhobby.com/vendor/doctrine/orm/src/EntityManager.php:162 {
    Doctrine\ORM\EntityManager->getMetadataFactory(): ClassMetadataFactory …
    › {
    ›     return $this->metadataFactory;
    › }
  }
  /var/www/kinderhobby.com/vendor/doctrine/persistence/src/AbstractManagerRegistry.php:151 {
    Doctrine\Persistence\AbstractManagerRegistry->getManagerForClass(string $class): ObjectManager …
    › 
    › if (! $manager->getMetadataFactory()->isTransient($class)) {
    ›     return $manager;
  }
  /var/www/kinderhobby.com/vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepository.php:129 {
    Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->resolveRepository(): EntityRepository …
    › {
    ›     $manager = $this->registry->getManagerForClass($this->entityClass);
    › 
  }
  /var/www/kinderhobby.com/vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepository.php:52 {
    Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->createQueryBuilder(string $alias, ?string $indexBy = null): QueryBuilder …
    › {
    ›     return ($this->repository ??= $this->resolveRepository())
    ›         ->createQueryBuilder($alias, $indexBy);
  }
  /var/www/kinderhobby.com/src/Repository/ActivityRepository.php:22 {
    App\Repository\ActivityRepository->findByFilter(ActivityFilter $filter): array …
    › {
    ›     $qb = $this->createQueryBuilder('a');
    › 
  }
  /var/www/kinderhobby.com/src/Service/ActivityFilterProvider.php:54 {
    App\Service\ActivityFilterProvider->getActivitiesByFilter(array $categoryIds, array $types = [], ?DateTimeImmutable $dateFrom = null, ?DateTimeImmutable $dateTo = null): array …
    › 
    ›     return $this->activityRepository->findByFilter($filter);
    › }
  }
  /var/www/kinderhobby.com/src/Service/ActivityFilterProvider.php:21 {
    App\Service\ActivityFilterProvider->getHomepageActivities(): array …
    › {
    ›     return $this->getActivitiesByFilter([]);
    › }
  }
  /var/www/kinderhobby.com/src/Controller/PageController.php:24 {
    App\Controller\PageController->homepageAction(): Response …
    › {
    ›     $activities = $this->activityFilterProvider->getHomepageActivities();
    › 
  }
  /var/www/kinderhobby.com/vendor/symfony/http-kernel/HttpKernel.php:183 {
    Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
    › // call controller
    › $response = $controller(...$arguments);
    › 
  }
  /var/www/kinderhobby.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) {
  }
  /var/www/kinderhobby.com/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 {
  }
  /var/www/kinderhobby.com/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
    Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
    › {
    ›     $response = $this->kernel->handle($this->request);
    › 
  }
  /var/www/kinderhobby.com/vendor/autoload_runtime.php:32 {
    require_once …
    ›         ->getRunner($app)
    ›         ->run()
    › );
  }
  /var/www/kinderhobby.com/public/index.php:5 {
    › 
    › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
    › 
  }
}

[
  "driver" => "pdo_mysql"
  "idle_connection_ttl" => 600
  "host" => "127.0.0.1"
  "port" => 3306
  "user" => "mysql"
  "password" => "<redacted>"
  "driverOptions" => []
  "defaultTableOptions" => [
    "collation" => "utf8mb4_unicode_ci"
  ]
  "dbname" => "kinder-hobby"
  "charset" => "utf8mb4"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "mysql"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "kinder-hobby"
    "charset" => "utf8mb4"
  ]
]

"SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.description AS description_3, a0_.type AS type_4, a0_.latitude AS latitude_5, a0_.longitude AS longitude_6, a0_.street AS street_7, a0_.city AS city_8, a0_.postcode AS postcode_9, a0_.country AS country_10, a0_.google_place_id AS google_place_id_11, a0_.url AS url_12, a0_.phone_number AS phone_number_13, a0_.rating AS rating_14, a0_.reviews_count AS reviews_count_15, a0_.image AS image_16, a0_.order_id AS order_id_17, a0_.start_date AS start_date_18, a0_.start_time AS start_time_19, a0_.end_date AS end_date_20, a0_.end_time AS end_time_21, a0_.repeat_rule AS repeat_rule_22, a0_.google_place_data AS google_place_data_23, a0_.original_url AS original_url_24, a0_.imported_from AS imported_from_25, a0_.is_enabled AS is_enabled_26, a0_.approved_at AS approved_at_27, a0_.schedule_raw AS schedule_raw_28, a0_.images AS images_29, a0_.age_min AS age_min_30, a0_.age_max AS age_max_31, a0_.created_at AS created_at_32, a0_.updated_at AS updated_at_33, a0_.category_id AS category_id_34, a0_.approved_by_id AS approved_by_id_35, a0_.user_id AS user_id_36 FROM activity a0_ ORDER BY a0_.order_id ASC LIMIT 20"

[
  "sql" => "SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.description AS description_3, a0_.type AS type_4, a0_.latitude AS latitude_5, a0_.longitude AS longitude_6, a0_.street AS street_7, a0_.city AS city_8, a0_.postcode AS postcode_9, a0_.country AS country_10, a0_.google_place_id AS google_place_id_11, a0_.url AS url_12, a0_.phone_number AS phone_number_13, a0_.rating AS rating_14, a0_.reviews_count AS reviews_count_15, a0_.image AS image_16, a0_.order_id AS order_id_17, a0_.start_date AS start_date_18, a0_.start_time AS start_time_19, a0_.end_date AS end_date_20, a0_.end_time AS end_time_21, a0_.repeat_rule AS repeat_rule_22, a0_.google_place_data AS google_place_data_23, a0_.original_url AS original_url_24, a0_.imported_from AS imported_from_25, a0_.is_enabled AS is_enabled_26, a0_.approved_at AS approved_at_27, a0_.schedule_raw AS schedule_raw_28, a0_.images AS images_29, a0_.age_min AS age_min_30, a0_.age_max AS age_max_31, a0_.created_at AS created_at_32, a0_.updated_at AS updated_at_33, a0_.category_id AS category_id_34, a0_.approved_by_id AS approved_by_id_35, a0_.user_id AS user_id_36 FROM activity a0_ ORDER BY a0_.order_id ASC LIMIT 20"
]

"SELECT c0_.id AS id_0, c0_.icon AS icon_1, c0_.activity_count AS activity_count_2, c0_.name_de AS name_de_3, c0_.name_en AS name_en_4, c0_.name_tr AS name_tr_5, c0_.name_ru AS name_ru_6, c0_.name_uk AS name_uk_7, c0_.slug AS slug_8, c0_.google_types AS google_types_9, c0_.is_enabled AS is_enabled_10, c0_.order_id AS order_id_11, c0_.created_at AS created_at_12, c0_.updated_at AS updated_at_13, c1_.id AS id_14, c1_.icon AS icon_15, c1_.activity_count AS activity_count_16, c1_.name_de AS name_de_17, c1_.name_en AS name_en_18, c1_.name_tr AS name_tr_19, c1_.name_ru AS name_ru_20, c1_.name_uk AS name_uk_21, c1_.slug AS slug_22, c1_.google_types AS google_types_23, c1_.is_enabled AS is_enabled_24, c1_.order_id AS order_id_25, c1_.created_at AS created_at_26, c1_.updated_at AS updated_at_27, c0_.parent_id AS parent_id_28, c0_.user_id AS user_id_29, c1_.parent_id AS parent_id_30, c1_.user_id AS user_id_31 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id WHERE c0_.parent_id IS NULL AND c0_.is_enabled = 1 AND (c1_.is_enabled = 1 OR c1_.id IS NULL) ORDER BY c0_.order_id ASC, c1_.order_id ASC"

[
  "sql" => "SELECT c0_.id AS id_0, c0_.icon AS icon_1, c0_.activity_count AS activity_count_2, c0_.name_de AS name_de_3, c0_.name_en AS name_en_4, c0_.name_tr AS name_tr_5, c0_.name_ru AS name_ru_6, c0_.name_uk AS name_uk_7, c0_.slug AS slug_8, c0_.google_types AS google_types_9, c0_.is_enabled AS is_enabled_10, c0_.order_id AS order_id_11, c0_.created_at AS created_at_12, c0_.updated_at AS updated_at_13, c1_.id AS id_14, c1_.icon AS icon_15, c1_.activity_count AS activity_count_16, c1_.name_de AS name_de_17, c1_.name_en AS name_en_18, c1_.name_tr AS name_tr_19, c1_.name_ru AS name_ru_20, c1_.name_uk AS name_uk_21, c1_.slug AS slug_22, c1_.google_types AS google_types_23, c1_.is_enabled AS is_enabled_24, c1_.order_id AS order_id_25, c1_.created_at AS created_at_26, c1_.updated_at AS updated_at_27, c0_.parent_id AS parent_id_28, c0_.user_id AS user_id_29, c1_.parent_id AS parent_id_30, c1_.user_id AS user_id_31 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id WHERE c0_.parent_id IS NULL AND c0_.is_enabled = 1 AND (c1_.is_enabled = 1 OR c1_.id IS NULL) ORDER BY c0_.order_id ASC, c1_.order_id ASC"
]