Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.95 ms Query time

2 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.95 ms

SELECT t0.id AS id_1, t0.prename AS prename_2, t0.lastname AS lastname_3, t0.street AS street_4, t0.housenr AS housenr_5, t0.postal AS postal_6, t0.city AS city_7, t0.email AS email_8, t0.phone AS phone_9, t0.require_cash AS require_cash_10, t0.require_prepaid AS require_prepaid_11, t0.payment_id AS payment_id_12 FROM customer t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.prename AS prename_2,
  t0.lastname AS lastname_3,
  t0.street AS street_4,
  t0.housenr AS housenr_5,
  t0.postal AS postal_6,
  t0.city AS city_7,
  t0.email AS email_8,
  t0.phone AS phone_9,
  t0.require_cash AS require_cash_10,
  t0.require_prepaid AS require_prepaid_11,
  t0.payment_id AS payment_id_12
FROM
  customer t0

SELECT t0.id AS id_1, t0.prename AS prename_2, t0.lastname AS lastname_3, t0.street AS street_4, t0.housenr AS housenr_5, t0.postal AS postal_6, t0.city AS city_7, t0.email AS email_8, t0.phone AS phone_9, t0.require_cash AS require_cash_10, t0.require_prepaid AS require_prepaid_11, t0.payment_id AS payment_id_12 FROM customer t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 21)
6	App\Controller\CustomerController->index (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	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\Customer	The association App\Entity\Customer#appointments refers to the owning side field App\Entity\Appointments#customer_id which does not exist.
App\Entity\Payment	No errors.
App\Entity\Appointments	The mappings App\Entity\Appointments#customer and App\Entity\Customer#appointments are inconsistent with each other. The mappings App\Entity\Appointments#location and App\Entity\Location#appointments are inconsistent with each other.
App\Entity\Order	No errors.

Symfony Profiler

GET https://projects.cuetime.de/customer

Configuration Settings

Theme