Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

55.57 ms Query time

4 Invalid entities

0 Managed entities

Time▼	Count	Info
27.84 ms (50.10%)	2	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
27.73 ms (49.90%)	1	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"takadoc"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'takadoc' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;

Time▼

Count

Info

27.84 ms
(50.10%)

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DATABASE()

SELECT DATABASE();

27.73 ms
(49.90%)

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME

Parameters:

[
  "takadoc"
]

View formatted query View runnable query Explain query

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'takadoc'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

Class	Amount of managed objects

Class	Mapping errors
App\Entity\Session	No errors.
App\Entity\OrderLine	No errors.
App\Entity\Coach	No errors.
App\Entity\Ressource	No errors.
App\Entity\CircuitExercise	No errors.
App\Entity\Order	No errors.
App\Entity\CustomerMeteoModel	No errors.
App\Entity\BillRef	No errors.
App\Entity\DiagSetup	No errors.
App\Entity\Exercise	No errors.
App\Entity\TCAMeteo	The mappings App\Entity\TCAMeteo#customer and App\Entity\Customer#evaluationTCAs are inconsistent with each other.
App\Entity\Element	No errors.
App\Entity\Group	The association App\Entity\Group#coach refers to the inverse side field App\Entity\Coach#groups which does not exist.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\TCAMeteoCategorisedAnswer	No errors.
App\Entity\Booking	No errors.
App\Entity\CircuitElement	No errors.
App\Entity\Category	No errors.
App\Entity\StatTag	No errors.
App\Entity\User	No errors.
App\Entity\DiagnosticSet	No errors.
App\Entity\Notification	No errors.
App\Entity\ElementFile	No errors.
App\Entity\Customer	The association App\Entity\Customer#evaluationTCAs refers to the owning side field App\Entity\TCAMeteo#user which does not exist.
App\Entity\Diagnostic	No errors.
App\Entity\Subscription	The association App\Entity\Subscription#customer refers to the inverse side field App\Entity\Customer#subscriptions which does not exist.
Vich\UploaderBundle\Entity\File	No errors.