Symfony Profiler

[
  "exception" => Doctrine\DBAL\Exception\TableNotFoundException {#817
    #message: "An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'winejobr.job_offer' doesn't exist"
    #code: 1146
    #file: "/var/www/html/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php"
    #line: 51
    -previous: Doctrine\DBAL\Driver\PDO\Exception {#814 …}
    -query: Doctrine\DBAL\Query {#815 …}
    trace: {
      /var/www/html/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:51 {
        Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
        › 1051,
        › 1146 => new TableNotFoundException($exception, $query),
        › 1216,
      }
      /var/www/html/vendor/doctrine/dbal/src/Connection.php:1460 {
        Doctrine\DBAL\Connection->handleDriverException(Exception $driverException, ?Query $query): DriverException …
        › $this->exceptionConverter ??= $this->driver->getExceptionConverter();
        › $exception                  = $this->exceptionConverter->convert($driverException, $query);
        › 
        arguments: {
          $exception: Doctrine\DBAL\Driver\PDO\Exception {#814 …}
          $query: Doctrine\DBAL\Query {#815 …}
        }
      }
      /var/www/html/vendor/doctrine/dbal/src/Connection.php:1396 {
        Doctrine\DBAL\Connection->convertExceptionDuringQuery(Exception $e, string $sql, array $params = [], array $types = []): DriverException …
        › ): DriverException {
        ›     return $this->handleDriverException($e, new Query($sql, $params, $types));
        › }
        arguments: {
          $driverException: Doctrine\DBAL\Driver\PDO\Exception {#814 …}
          $query: Doctrine\DBAL\Query {#815 …}
        }
      }
      /var/www/html/vendor/doctrine/dbal/src/Connection.php:809 {
        Doctrine\DBAL\Connection->executeQuery(string $sql, array $params = [], array $types = [], ?QueryCacheProfile $qcp = null): Result …
        › } catch (Driver\Exception $e) {
        ›     throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);
        › }
        arguments: {
          $e: Doctrine\DBAL\Driver\PDO\Exception {#814 …}
          $sql: "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.contract_type AS contract_type_4, t0.company_name AS company_name_5, t0.location AS location_6, t0.salary AS salary_7, t0.education_level AS education_level_8, t0.min_experience AS min_experience_9, t0.advantages AS advantages_10 FROM job_offer t0 ORDER BY t0.id DESC LIMIT 5"
          $params: []
          $types: []
        }
      }
      /var/www/html/vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:963 {
        Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll(array $criteria = [], ?array $orderBy = null, ?int $limit = null, ?int $offset = null): array …
        › [$params, $types] = $this->expandParameters($criteria);
        › $stmt             = $this->conn->executeQuery($sql, $params, $types);
        › 
        arguments: {
          $sql: "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.contract_type AS contract_type_4, t0.company_name AS company_name_5, t0.location AS location_6, t0.salary AS salary_7, t0.education_level AS education_level_8, t0.min_experience AS min_experience_9, t0.advantages AS advantages_10 FROM job_offer t0 ORDER BY t0.id DESC LIMIT 5"
          $params: []
          $types: []
        }
      }
      /var/www/html/vendor/doctrine/orm/src/EntityRepository.php:110 {
        Doctrine\ORM\EntityRepository->findBy(array $criteria, ?array $orderBy = null, ?int $limit = null, ?int $offset = null): array …
        › 
        ›     return $persister->loadAll($criteria, $orderBy, $limit, $offset);
        › }
        arguments: {
          $criteria: []
          $orderBy: [ …1]
          $limit: 5
          $offset: null
        }
      }
      /var/www/html/vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepositoryProxy.php:73 {
        Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy(array $criteria, ?array $orderBy = null, ?int $limit = null, ?int $offset = null): array …
        ›     return ($this->repository ??= $this->resolveRepository())
        ›         ->findBy($criteria, $orderBy, $limit, $offset);
        › }
        arguments: {
          $criteria: []
          $orderBy: [ …1]
          $limit: 5
          $offset: null
        }
      }
      /var/www/html/src/Controller/HomeController.php:16 {
        App\Controller\HomeController->index(JobOfferRepository $jobOfferRepository): Response …
        › // On récupère les 5 dernières annonces postées
        › $latestJobs = $jobOfferRepository->findBy([], ['id' => 'DESC'], 5);
        › 
        arguments: {
          $criteria: []
          $orderBy: [ …1]
          $limit: 5
        }
      }
      /var/www/html/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);
        › 
        arguments: {
          $jobOfferRepository: App\Repository\JobOfferRepository {#682 …}
        }
      }
      /var/www/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) {
        arguments: {
          $request: Symfony\Component\HttpFoundation\Request {#2 …}
          $type: 1
        }
      }
      /var/www/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 {
        arguments: {
          $request: Symfony\Component\HttpFoundation\Request {#2 …}
          $type: 1
          $catch: true
        }
      }
      /var/www/html/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
        Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
        › {
        ›     $response = $this->kernel->handle($this->request);
        › 
        arguments: {
          $request: Symfony\Component\HttpFoundation\Request {#2 …}
        }
      }
      /var/www/html/vendor/autoload_runtime.php:32 {
        require_once …
        ›         ->getRunner($app)
        ›         ->run()
        › );
      }
      /var/www/html/public/index.php:5 {
        › 
        › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
        › 
        arguments: {
          "/var/www/html/vendor/autoload_runtime.php"
        }
      }
    }
  }
]

{
  /var/www/html/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:51 {
    Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
    › 1051,
    › 1146 => new TableNotFoundException($exception, $query),
    › 1216,
  }
  /var/www/html/vendor/doctrine/dbal/src/Connection.php:1460 {
    Doctrine\DBAL\Connection->handleDriverException(Exception $driverException, ?Query $query): DriverException …
    › $this->exceptionConverter ??= $this->driver->getExceptionConverter();
    › $exception                  = $this->exceptionConverter->convert($driverException, $query);
    › 
    arguments: {
      $exception: Doctrine\DBAL\Driver\PDO\Exception {#814 …}
      $query: Doctrine\DBAL\Query {#815 …}
    }
  }
  /var/www/html/vendor/doctrine/dbal/src/Connection.php:1396 {
    Doctrine\DBAL\Connection->convertExceptionDuringQuery(Exception $e, string $sql, array $params = [], array $types = []): DriverException …
    › ): DriverException {
    ›     return $this->handleDriverException($e, new Query($sql, $params, $types));
    › }
    arguments: {
      $driverException: Doctrine\DBAL\Driver\PDO\Exception {#814 …}
      $query: Doctrine\DBAL\Query {#815 …}
    }
  }
  /var/www/html/vendor/doctrine/dbal/src/Connection.php:809 {
    Doctrine\DBAL\Connection->executeQuery(string $sql, array $params = [], array $types = [], ?QueryCacheProfile $qcp = null): Result …
    › } catch (Driver\Exception $e) {
    ›     throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);
    › }
    arguments: {
      $e: Doctrine\DBAL\Driver\PDO\Exception {#814 …}
      $sql: "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.contract_type AS contract_type_4, t0.company_name AS company_name_5, t0.location AS location_6, t0.salary AS salary_7, t0.education_level AS education_level_8, t0.min_experience AS min_experience_9, t0.advantages AS advantages_10 FROM job_offer t0 ORDER BY t0.id DESC LIMIT 5"
      $params: []
      $types: []
    }
  }
  /var/www/html/vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:963 {
    Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll(array $criteria = [], ?array $orderBy = null, ?int $limit = null, ?int $offset = null): array …
    › [$params, $types] = $this->expandParameters($criteria);
    › $stmt             = $this->conn->executeQuery($sql, $params, $types);
    › 
    arguments: {
      $sql: "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.contract_type AS contract_type_4, t0.company_name AS company_name_5, t0.location AS location_6, t0.salary AS salary_7, t0.education_level AS education_level_8, t0.min_experience AS min_experience_9, t0.advantages AS advantages_10 FROM job_offer t0 ORDER BY t0.id DESC LIMIT 5"
      $params: []
      $types: []
    }
  }
  /var/www/html/vendor/doctrine/orm/src/EntityRepository.php:110 {
    Doctrine\ORM\EntityRepository->findBy(array $criteria, ?array $orderBy = null, ?int $limit = null, ?int $offset = null): array …
    › 
    ›     return $persister->loadAll($criteria, $orderBy, $limit, $offset);
    › }
    arguments: {
      $criteria: []
      $orderBy: [ …1]
      $limit: 5
      $offset: null
    }
  }
  /var/www/html/vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepositoryProxy.php:73 {
    Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy(array $criteria, ?array $orderBy = null, ?int $limit = null, ?int $offset = null): array …
    ›     return ($this->repository ??= $this->resolveRepository())
    ›         ->findBy($criteria, $orderBy, $limit, $offset);
    › }
    arguments: {
      $criteria: []
      $orderBy: [ …1]
      $limit: 5
      $offset: null
    }
  }
  /var/www/html/src/Controller/HomeController.php:16 {
    App\Controller\HomeController->index(JobOfferRepository $jobOfferRepository): Response …
    › // On récupère les 5 dernières annonces postées
    › $latestJobs = $jobOfferRepository->findBy([], ['id' => 'DESC'], 5);
    › 
    arguments: {
      $criteria: []
      $orderBy: [ …1]
      $limit: 5
    }
  }
  /var/www/html/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);
    › 
    arguments: {
      $jobOfferRepository: App\Repository\JobOfferRepository {#682 …}
    }
  }
  /var/www/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) {
    arguments: {
      $request: Symfony\Component\HttpFoundation\Request {#2 …}
      $type: 1
    }
  }
  /var/www/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 {
    arguments: {
      $request: Symfony\Component\HttpFoundation\Request {#2 …}
      $type: 1
      $catch: true
    }
  }
  /var/www/html/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
    Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
    › {
    ›     $response = $this->kernel->handle($this->request);
    › 
    arguments: {
      $request: Symfony\Component\HttpFoundation\Request {#2 …}
    }
  }
  /var/www/html/vendor/autoload_runtime.php:32 {
    require_once …
    ›         ->getRunner($app)
    ›         ->run()
    › );
  }
  /var/www/html/public/index.php:5 {
    › 
    › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
    › 
    arguments: {
      "/var/www/html/vendor/autoload_runtime.php"
    }
  }
}