Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

7.45 ms Query time

1 Invalid entities

Queries

Group similar statements

default connection

#▲	Time	Info
1	6.26 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.api_key AS api_key_3, t0.is_active AS is_active_4 FROM tournament t0 WHERE t0.id = ? Parameters: [`"4"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.api_key AS api_key_3, t0.is_active AS is_active_4 FROM tournament t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.api_key AS api_key_3, t0.is_active AS is_active_4 FROM tournament t0 WHERE t0.id = '4';
2	1.19 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.external_id AS external_id_3, t0.state AS state_4, t0.tournament_id AS tournament_id_5 FROM competition t0 WHERE t0.id = ? Parameters: [`"8"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.external_id AS external_id_3, t0.state AS state_4, t0.tournament_id AS tournament_id_5 FROM competition t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.external_id AS external_id_3, t0.state AS state_4, t0.tournament_id AS tournament_id_5 FROM competition t0 WHERE t0.id = '8';

#▲

Time

Info

6.26 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.api_key AS api_key_3, t0.is_active AS is_active_4 FROM tournament t0 WHERE t0.id = ?

Parameters:

[
  "4"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.api_key AS api_key_3,
  t0.is_active AS is_active_4
FROM
  tournament t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.api_key AS api_key_3, t0.is_active AS is_active_4 FROM tournament t0 WHERE t0.id = '4';

1.19 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.external_id AS external_id_3, t0.state AS state_4, t0.tournament_id AS tournament_id_5 FROM competition t0 WHERE t0.id = ?

Parameters:

[
  "8"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.external_id AS external_id_3,
  t0.state AS state_4,
  t0.tournament_id AS tournament_id_5
FROM
  competition t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.external_id AS external_id_3, t0.state AS state_4, t0.tournament_id AS tournament_id_5 FROM competition t0 WHERE t0.id = '8';

replayer connection

No database queries were performed.

Database Connections

Name	Service
default	doctrine.dbal.default_connection
replayer	doctrine.dbal.replayer_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
replayer	doctrine.orm.replayer_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
App\Core\Entity\Competition	No errors.
App\Core\Entity\Tournament	No errors.
App\Core\Entity\Team	No errors.
App\Core\Entity\MatchFormat	The association App\Core\Entity\MatchFormat#template refers to the inverse side field App\Core\Entity\MatchFormat#id which is not defined as association. The association App\Core\Entity\MatchFormat#template refers to the inverse side field App\Core\Entity\MatchFormat#id which does not exist.

replayer entity manager

No loaded entities.