Symfony Profiler

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

Log Messages

"gallery"

[
  "route" => "gallery"
  "route_parameters" => [
    "_route" => "gallery"
    "_controller" => "App\Controller\GalleryController::index"
  ]
  "request_uri" => "https://photo-review.postcardsforfriends.org/"
  "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 {#795
    #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/voterev_photo_review/vendor/doctrine/deprecations/src/Deprecation.php"
    #line: 208
    #severity: E_USER_DEPRECATED
    trace: {
      /var/www/voterev_photo_review/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/voterev_photo_review/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/voterev_photo_review/vendor/doctrine/dbal/src/Driver/AbstractMySQLDriver.php:75 {
        Doctrine\DBAL\Driver\AbstractMySQLDriver->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractMySQLPlatform …
        › 
        › Deprecation::trigger(
        ›     'doctrine/dbal',
      }
      /var/www/voterev_photo_review/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/voterev_photo_review/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/voterev_photo_review/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/voterev_photo_review/vendor/doctrine/dbal/src/Connection.php:196 {
        Doctrine\DBAL\Connection->getDatabasePlatform(): AbstractPlatform …
        › 
        ›     $this->platform = $this->driver->getDatabasePlatform($versionProvider);
        › }
      }
      /var/www/voterev_photo_review/vendor/doctrine/orm/src/Mapping/ClassMetadataFactory.php:740 {
        Doctrine\ORM\Mapping\ClassMetadataFactory->getTargetPlatform(): AbstractPlatform …
        › if (! $this->targetPlatform) {
        ›     $this->targetPlatform = $this->em->getConnection()->getDatabasePlatform();
        › }
      }
      /var/www/voterev_photo_review/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()));
        › }
      }
      /var/www/voterev_photo_review/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);
        › }
      }
      /var/www/voterev_photo_review/vendor/doctrine/doctrine-bundle/src/Mapping/ClassMetadataFactory.php:23 {
        Doctrine\Bundle\DoctrineBundle\Mapping\ClassMetadataFactory->doLoadMetadata($class, $parent, $rootEntityFound, array $nonSuperclassParents): void …
        › {
        ›     parent::doLoadMetadata($class, $parent, $rootEntityFound, $nonSuperclassParents);
        › 
      }
      /var/www/voterev_photo_review/vendor/doctrine/persistence/src/Mapping/AbstractClassMetadataFactory.php:318 {
        Doctrine\Persistence\Mapping\AbstractClassMetadataFactory->loadMetadata(string $name): array …
        › 
        › $this->doLoadMetadata($class, $parent, $rootEntityFound, $visited);
        › 
      }
      /var/www/voterev_photo_review/vendor/doctrine/persistence/src/Mapping/AbstractClassMetadataFactory.php:187 {
        Doctrine\Persistence\Mapping\AbstractClassMetadataFactory->getMetadataFor(string $className): ClassMetadata …
        › } else {
        ›     $loadedMetadata = $this->loadMetadata($realClassName);
        ›     $classNames     = array_combine(
      }
      /var/www/voterev_photo_review/vendor/doctrine/orm/src/EntityManager.php:224 {
        Doctrine\ORM\EntityManager->getClassMetadata(string $className): ClassMetadata …
        › {
        ›     return $this->metadataFactory->getMetadataFor($className);
        › }
      }
      /var/www/voterev_photo_review/vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepository.php:139 {
        Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->resolveRepository(): EntityRepository …
        › /** @var ClassMetadata<T> $classMetadata */
        › $classMetadata = $manager->getClassMetadata($this->entityClass);
        › 
      }
      /var/www/voterev_photo_review/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/voterev_photo_review/src/Repository/PhotoRepository.php:106 {
        App\Repository\PhotoRepository->mostRecentUnreviewedDay(): ?string …
        › {
        ›     $r = $this->createQueryBuilder('p')
        ›         ->select('MAX(p.canvassDay)')
      }
      /var/www/voterev_photo_review/src/Controller/GalleryController.php:35 {
        App\Controller\GalleryController->index(Request $request, PhotoRepository $photos, PhotoCategoryRepository $categories): Response …
        › // Fresh load: default to the most recent day with unreviewed data.
        › $default = $photos->mostRecentUnreviewedDay() ?? ($photos->dayRange()['max'] ?? '');
        › $from = $default;
      }
      /var/www/voterev_photo_review/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/voterev_photo_review/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/voterev_photo_review/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/voterev_photo_review/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
        Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
        › {
        ›     $response = $this->kernel->handle($this->request);
        › 
      }
      /var/www/voterev_photo_review/vendor/autoload_runtime.php:29 {
        require_once …
        ›         ->getRunner($app)
        ›         ->run()
        › );
      }
      /var/www/voterev_photo_review/public/index.php:5 {
        › 
        › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
        › 
      }
    }
  }
]

{
  /var/www/voterev_photo_review/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/voterev_photo_review/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/voterev_photo_review/vendor/doctrine/dbal/src/Driver/AbstractMySQLDriver.php:75 {
    Doctrine\DBAL\Driver\AbstractMySQLDriver->getDatabasePlatform(ServerVersionProvider $versionProvider): AbstractMySQLPlatform …
    › 
    › Deprecation::trigger(
    ›     'doctrine/dbal',
  }
  /var/www/voterev_photo_review/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/voterev_photo_review/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/voterev_photo_review/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/voterev_photo_review/vendor/doctrine/dbal/src/Connection.php:196 {
    Doctrine\DBAL\Connection->getDatabasePlatform(): AbstractPlatform …
    › 
    ›     $this->platform = $this->driver->getDatabasePlatform($versionProvider);
    › }
  }
  /var/www/voterev_photo_review/vendor/doctrine/orm/src/Mapping/ClassMetadataFactory.php:740 {
    Doctrine\ORM\Mapping\ClassMetadataFactory->getTargetPlatform(): AbstractPlatform …
    › if (! $this->targetPlatform) {
    ›     $this->targetPlatform = $this->em->getConnection()->getDatabasePlatform();
    › }
  }
  /var/www/voterev_photo_review/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()));
    › }
  }
  /var/www/voterev_photo_review/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);
    › }
  }
  /var/www/voterev_photo_review/vendor/doctrine/doctrine-bundle/src/Mapping/ClassMetadataFactory.php:23 {
    Doctrine\Bundle\DoctrineBundle\Mapping\ClassMetadataFactory->doLoadMetadata($class, $parent, $rootEntityFound, array $nonSuperclassParents): void …
    › {
    ›     parent::doLoadMetadata($class, $parent, $rootEntityFound, $nonSuperclassParents);
    › 
  }
  /var/www/voterev_photo_review/vendor/doctrine/persistence/src/Mapping/AbstractClassMetadataFactory.php:318 {
    Doctrine\Persistence\Mapping\AbstractClassMetadataFactory->loadMetadata(string $name): array …
    › 
    › $this->doLoadMetadata($class, $parent, $rootEntityFound, $visited);
    › 
  }
  /var/www/voterev_photo_review/vendor/doctrine/persistence/src/Mapping/AbstractClassMetadataFactory.php:187 {
    Doctrine\Persistence\Mapping\AbstractClassMetadataFactory->getMetadataFor(string $className): ClassMetadata …
    › } else {
    ›     $loadedMetadata = $this->loadMetadata($realClassName);
    ›     $classNames     = array_combine(
  }
  /var/www/voterev_photo_review/vendor/doctrine/orm/src/EntityManager.php:224 {
    Doctrine\ORM\EntityManager->getClassMetadata(string $className): ClassMetadata …
    › {
    ›     return $this->metadataFactory->getMetadataFor($className);
    › }
  }
  /var/www/voterev_photo_review/vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepository.php:139 {
    Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->resolveRepository(): EntityRepository …
    › /** @var ClassMetadata<T> $classMetadata */
    › $classMetadata = $manager->getClassMetadata($this->entityClass);
    › 
  }
  /var/www/voterev_photo_review/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/voterev_photo_review/src/Repository/PhotoRepository.php:106 {
    App\Repository\PhotoRepository->mostRecentUnreviewedDay(): ?string …
    › {
    ›     $r = $this->createQueryBuilder('p')
    ›         ->select('MAX(p.canvassDay)')
  }
  /var/www/voterev_photo_review/src/Controller/GalleryController.php:35 {
    App\Controller\GalleryController->index(Request $request, PhotoRepository $photos, PhotoCategoryRepository $categories): Response …
    › // Fresh load: default to the most recent day with unreviewed data.
    › $default = $photos->mostRecentUnreviewedDay() ?? ($photos->dayRange()['max'] ?? '');
    › $from = $default;
  }
  /var/www/voterev_photo_review/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/voterev_photo_review/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/voterev_photo_review/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/voterev_photo_review/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
    Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
    › {
    ›     $response = $this->kernel->handle($this->request);
    › 
  }
  /var/www/voterev_photo_review/vendor/autoload_runtime.php:29 {
    require_once …
    ›         ->getRunner($app)
    ›         ->run()
    › );
  }
  /var/www/voterev_photo_review/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" => "plouser"
  "password" => "<redacted>"
  "driverOptions" => []
  "defaultTableOptions" => []
  "dbname" => "voterev_photo_review"
  "serverVersion" => "8.0"
  "charset" => "utf8mb4"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "plouser"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "voterev_photo_review"
    "serverVersion" => "8.0"
    "charset" => "utf8mb4"
  ]
]

"SELECT MAX(p0_.canvass_day) AS sclr_0 FROM photos p0_ WHERE p0_.exclude = 0 AND p0_.reviewed = 0"

[
  "sql" => "SELECT MAX(p0_.canvass_day) AS sclr_0 FROM photos p0_ WHERE p0_.exclude = 0 AND p0_.reviewed = 0"
]

"SELECT MIN(p0_.canvass_day) AS sclr_0, MAX(p0_.canvass_day) AS sclr_1 FROM photos p0_ WHERE p0_.exclude = 0"

[
  "sql" => "SELECT MIN(p0_.canvass_day) AS sclr_0, MAX(p0_.canvass_day) AS sclr_1 FROM photos p0_ WHERE p0_.exclude = 0"
]

"SELECT p0_.id AS id_0, p0_.photo_id AS photo_id_1, p0_.cropped_object_path AS cropped_object_path_2, p0_.original_object_path AS original_object_path_3, p0_.canvass_day AS canvass_day_4, p0_.date_source AS date_source_5, p0_.canvasser_name AS canvasser_name_6, p0_.exclude AS exclude_7, p0_.reviewed AS reviewed_8, p0_.gcs_time_created AS gcs_time_created_9, p0_.canvasser_email AS canvasser_email_10, p0_.canvasser_id AS canvasser_id_11, p0_.event_time AS event_time_12, p0_.site_name AS site_name_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.last_synced_at AS last_synced_at_16 FROM photos p0_ WHERE p0_.exclude = 0 AND p0_.canvass_day >= ? AND p0_.canvass_day <= ? ORDER BY p0_.canvass_day DESC, p0_.canvasser_name ASC, p0_.photo_id ASC LIMIT 100"

[
  1 => "2026-08-05"
  2 => "2026-08-05"
]

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

[
  "sql" => "SELECT p0_.id AS id_0, p0_.photo_id AS photo_id_1, p0_.cropped_object_path AS cropped_object_path_2, p0_.original_object_path AS original_object_path_3, p0_.canvass_day AS canvass_day_4, p0_.date_source AS date_source_5, p0_.canvasser_name AS canvasser_name_6, p0_.exclude AS exclude_7, p0_.reviewed AS reviewed_8, p0_.gcs_time_created AS gcs_time_created_9, p0_.canvasser_email AS canvasser_email_10, p0_.canvasser_id AS canvasser_id_11, p0_.event_time AS event_time_12, p0_.site_name AS site_name_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.last_synced_at AS last_synced_at_16 FROM photos p0_ WHERE p0_.exclude = 0 AND p0_.canvass_day >= ? AND p0_.canvass_day <= ? ORDER BY p0_.canvass_day DESC, p0_.canvasser_name ASC, p0_.photo_id ASC LIMIT 100"
  "params" => [
    1 => "2026-08-05"
    2 => "2026-08-05"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#981
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#981}
  ]
]

"SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.photo_id AS photo_id_1, p0_.cropped_object_path AS cropped_object_path_2, p0_.original_object_path AS original_object_path_3, p0_.canvass_day AS canvass_day_4, p0_.date_source AS date_source_5, p0_.canvasser_name AS canvasser_name_6, p0_.exclude AS exclude_7, p0_.reviewed AS reviewed_8, p0_.gcs_time_created AS gcs_time_created_9, p0_.canvasser_email AS canvasser_email_10, p0_.canvasser_id AS canvasser_id_11, p0_.event_time AS event_time_12, p0_.site_name AS site_name_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.last_synced_at AS last_synced_at_16 FROM photos p0_ WHERE p0_.exclude = 0 AND p0_.canvass_day >= ? AND p0_.canvass_day <= ? ORDER BY p0_.canvass_day DESC, p0_.canvasser_name ASC, p0_.photo_id ASC) dctrn_result) dctrn_table"

[
  1 => "2026-08-05"
  2 => "2026-08-05"
]

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

[
  "sql" => "SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.photo_id AS photo_id_1, p0_.cropped_object_path AS cropped_object_path_2, p0_.original_object_path AS original_object_path_3, p0_.canvass_day AS canvass_day_4, p0_.date_source AS date_source_5, p0_.canvasser_name AS canvasser_name_6, p0_.exclude AS exclude_7, p0_.reviewed AS reviewed_8, p0_.gcs_time_created AS gcs_time_created_9, p0_.canvasser_email AS canvasser_email_10, p0_.canvasser_id AS canvasser_id_11, p0_.event_time AS event_time_12, p0_.site_name AS site_name_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.last_synced_at AS last_synced_at_16 FROM photos p0_ WHERE p0_.exclude = 0 AND p0_.canvass_day >= ? AND p0_.canvass_day <= ? ORDER BY p0_.canvass_day DESC, p0_.canvasser_name ASC, p0_.photo_id ASC) dctrn_result) dctrn_table"
  "params" => [
    1 => "2026-08-05"
    2 => "2026-08-05"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#981
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#981}
  ]
]

"SELECT p0_.photo_id AS photo_id_0, p0_.category AS category_1 FROM photo_category p0_ ORDER BY p0_.category ASC"

[
  "sql" => "SELECT p0_.photo_id AS photo_id_0, p0_.category AS category_1 FROM photo_category p0_ ORDER BY p0_.category ASC"
]

"SELECT DISTINCT p0_.canvasser_name AS canvasser_name_0 FROM photos p0_ WHERE p0_.exclude = 0 AND p0_.canvasser_name IS NOT NULL ORDER BY p0_.canvasser_name ASC"

[
  "sql" => "SELECT DISTINCT p0_.canvasser_name AS canvasser_name_0 FROM photos p0_ WHERE p0_.exclude = 0 AND p0_.canvasser_name IS NOT NULL ORDER BY p0_.canvasser_name ASC"
]

"SELECT MIN(p0_.canvass_day) AS sclr_0, MAX(p0_.canvass_day) AS sclr_1 FROM photos p0_ WHERE p0_.exclude = 0"

[
  "sql" => "SELECT MIN(p0_.canvass_day) AS sclr_0, MAX(p0_.canvass_day) AS sclr_1 FROM photos p0_ WHERE p0_.exclude = 0"
]