Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.31 ms Query time

2 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.31 ms

SELECT s0_.codeservices AS codeservices_0, s0_.libe AS libe_1, s0_.description AS description_2, s0_.image AS image_3, s0_.featured AS featured_4, s0_.slug AS slug_5 FROM services s0_ WHERE s0_.slug = ? OR s0_.codeservices = ?

Parameters:

[
  "service-de-location-d-espaces-evenementiel"
  "service-de-location-d-espaces-evenementiel"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.codeservices AS codeservices_0,
  s0_.libe AS libe_1,
  s0_.description AS description_2,
  s0_.image AS image_3,
  s0_.featured AS featured_4,
  s0_.slug AS slug_5
FROM
  services s0_
WHERE
  s0_.slug = ?
  OR s0_.codeservices = ?

SELECT s0_.codeservices AS codeservices_0, s0_.libe AS libe_1, s0_.description AS description_2, s0_.image AS image_3, s0_.featured AS featured_4, s0_.slug AS slug_5 FROM services s0_ WHERE s0_.slug = 'service-de-location-d-espaces-evenementiel' OR s0_.codeservices = 'service-de-location-d-espaces-evenementiel';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 200)
7	App\Repository\ServicesRepository->findServiceBySlugOrCodeFamille (line 193)
8	App\Controller\AccueilController->autresServices (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Services	The association App\Entity\Services#tables refers to the owning side field App\Entity\Table#codeservices which is not defined as association, but as field. The association App\Entity\Services#tables refers to the owning side field App\Entity\Table#codeservices which does not exist.
App\Entity\PrixAAppliquer	No errors.
App\Entity\Table	The field 'App\Entity\Table#codeservices' has the property type 'App\Entity\Services' that differs from the metadata field type 'string' returned by the 'string' DBAL type.

Symfony Profiler

GET https://complexehotelierlabonte.com/services/service-de-location-d-espaces-evenementiel

Configuration Settings

Theme