Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

2.13 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	1.02 ms	SELECT t0.id AS id_1, t0.nom AS nom_2, t0.president AS president_3, t0.user_id AS user_id_4 FROM province t0 WHERE t0.id = ? Parameters: [`"15"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nom AS nom_2, t0.president AS president_3, t0.user_id AS user_id_4 FROM province t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.nom AS nom_2, t0.president AS president_3, t0.user_id AS user_id_4 FROM province t0 WHERE t0.id = '15';
2	1.12 ms	SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.telephone AS telephone_4, t0.president AS president_5, t0.secretaire AS secretaire_6, t0.email AS email_7, t0.province_id AS province_id_8, t0.user_id AS user_id_9 FROM federation t0 WHERE t0.province_id = ? Parameters: [`15`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.telephone AS telephone_4, t0.president AS president_5, t0.secretaire AS secretaire_6, t0.email AS email_7, t0.province_id AS province_id_8, t0.user_id AS user_id_9 FROM federation t0 WHERE t0.province_id = ? SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.telephone AS telephone_4, t0.president AS president_5, t0.secretaire AS secretaire_6, t0.email AS email_7, t0.province_id AS province_id_8, t0.user_id AS user_id_9 FROM federation t0 WHERE t0.province_id = 15;

#▲

Time

Info

1.02 ms

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.president AS president_3, t0.user_id AS user_id_4 FROM province t0 WHERE t0.id = ?

Parameters:

[
  "15"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.president AS president_3,
  t0.user_id AS user_id_4
FROM
  province t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.president AS president_3, t0.user_id AS user_id_4 FROM province t0 WHERE t0.id = '15';

1.12 ms

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.telephone AS telephone_4, t0.president AS president_5, t0.secretaire AS secretaire_6, t0.email AS email_7, t0.province_id AS province_id_8, t0.user_id AS user_id_9 FROM federation t0 WHERE t0.province_id = ?

Parameters:

[
  15
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.adresse AS adresse_3,
  t0.telephone AS telephone_4,
  t0.president AS president_5,
  t0.secretaire AS secretaire_6,
  t0.email AS email_7,
  t0.province_id AS province_id_8,
  t0.user_id AS user_id_9
FROM
  federation t0
WHERE
  t0.province_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.telephone AS telephone_4, t0.president AS president_5, t0.secretaire AS secretaire_6, t0.email AS email_7, t0.province_id AS province_id_8, t0.user_id AS user_id_9 FROM federation t0 WHERE t0.province_id = 15;

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\Province	No errors.
App\Entity\User	The field App\Entity\User#province is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Province#user does not contain the required 'inversedBy="province"' attribute.
App\Entity\Federation	No errors.
App\Entity\Commune	No errors.
App\Entity\District	No errors.
App\Entity\Membre	No errors.
App\Entity\Demande	No errors.

Symfony Profiler

https://mlcapp.org/api/federation/province/15

Configuration Settings

Theme