Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

6.13 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼	Count	Info
3.33 ms (0.00%)	1	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: [`"9"`] 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 = '9';
2.81 ms (0.00%)	1	SELECT c0_.id AS id_0, c0_.team1_name AS team1_name_1, c0_.team2_name AS team2_name_2, c0_.starts_at AS starts_at_3, c0_.is_launched AS is_launched_4, c0_.table_id AS table_id_5, c0_.competition_id AS competition_id_6, c0_.team1 AS team1_7, c0_.team2 AS team2_8, c0_.match_format_id AS match_format_id_9 FROM competition_match c0_ INNER JOIN competition c1_ ON c0_.competition_id = c1_.id WHERE c0_.is_launched = 1 AND c1_.tournament_id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.team1_name AS team1_name_1, c0_.team2_name AS team2_name_2, c0_.starts_at AS starts_at_3, c0_.is_launched AS is_launched_4, c0_.table_id AS table_id_5, c0_.competition_id AS competition_id_6, c0_.team1 AS team1_7, c0_.team2 AS team2_8, c0_.match_format_id AS match_format_id_9 FROM competition_match c0_ INNER JOIN competition c1_ ON c0_.competition_id = c1_.id WHERE c0_.is_launched = 1 AND c1_.tournament_id = ? SELECT c0_.id AS id_0, c0_.team1_name AS team1_name_1, c0_.team2_name AS team2_name_2, c0_.starts_at AS starts_at_3, c0_.is_launched AS is_launched_4, c0_.table_id AS table_id_5, c0_.competition_id AS competition_id_6, c0_.team1 AS team1_7, c0_.team2 AS team2_8, c0_.match_format_id AS match_format_id_9 FROM competition_match c0_ INNER JOIN competition c1_ ON c0_.competition_id = c1_.id WHERE c0_.is_launched = 1 AND c1_.tournament_id = 9;

Time▼

Count

Info

3.33 ms
(0.00%)

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:

[
  "9"
]

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 = '9';

2.81 ms
(0.00%)

SELECT c0_.id AS id_0, c0_.team1_name AS team1_name_1, c0_.team2_name AS team2_name_2, c0_.starts_at AS starts_at_3, c0_.is_launched AS is_launched_4, c0_.table_id AS table_id_5, c0_.competition_id AS competition_id_6, c0_.team1 AS team1_7, c0_.team2 AS team2_8, c0_.match_format_id AS match_format_id_9 FROM competition_match c0_ INNER JOIN competition c1_ ON c0_.competition_id = c1_.id WHERE c0_.is_launched = 1 AND c1_.tournament_id = ?

Parameters:

[
  9
]

View formatted query View runnable query Explain query

SELECT
  c0_.id AS id_0,
  c0_.team1_name AS team1_name_1,
  c0_.team2_name AS team2_name_2,
  c0_.starts_at AS starts_at_3,
  c0_.is_launched AS is_launched_4,
  c0_.table_id AS table_id_5,
  c0_.competition_id AS competition_id_6,
  c0_.team1 AS team1_7,
  c0_.team2 AS team2_8,
  c0_.match_format_id AS match_format_id_9
FROM
  competition_match c0_
  INNER JOIN competition c1_ ON c0_.competition_id = c1_.id
WHERE
  c0_.is_launched = 1
  AND c1_.tournament_id = ?

SELECT c0_.id AS id_0, c0_.team1_name AS team1_name_1, c0_.team2_name AS team2_name_2, c0_.starts_at AS starts_at_3, c0_.is_launched AS is_launched_4, c0_.table_id AS table_id_5, c0_.competition_id AS competition_id_6, c0_.team1 AS team1_7, c0_.team2 AS team2_8, c0_.match_format_id AS match_format_id_9 FROM competition_match c0_ INNER JOIN competition c1_ ON c0_.competition_id = c1_.id WHERE c0_.is_launched = 1 AND c1_.tournament_id = 9;

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\Tournament	No errors.
App\Core\Entity\CompetitionMatch	The field App\Core\Entity\CompetitionMatch#results is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Core\Entity\Result#match does not contain the required 'inversedBy="results"' attribute.
App\Core\Entity\Competition	No errors.
App\Core\Entity\Table	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.