Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

2.08 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
1.69 ms (81.02%)	1	SELECT t0.id AS id_1, t0.rayon AS rayon_2, t0.texte AS texte_3, t0.villes_id AS villes_id_4, t0.categories_id AS categories_id_5, t0.user_id AS user_id_6 FROM alertes t0 WHERE t0.user_id IS NULL Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.rayon AS rayon_2, t0.texte AS texte_3, t0.villes_id AS villes_id_4, t0.categories_id AS categories_id_5, t0.user_id AS user_id_6 FROM alertes t0 WHERE t0.user_id IS NULL SELECT t0.id AS id_1, t0.rayon AS rayon_2, t0.texte AS texte_3, t0.villes_id AS villes_id_4, t0.categories_id AS categories_id_5, t0.user_id AS user_id_6 FROM alertes t0 WHERE t0.user_id IS NULL;
0.40 ms (18.98%)	1	SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM categories t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM categories t0 SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM categories t0;

Time▼

Count

Info

1.69 ms
(81.02%)

SELECT t0.id AS id_1, t0.rayon AS rayon_2, t0.texte AS texte_3, t0.villes_id AS villes_id_4, t0.categories_id AS categories_id_5, t0.user_id AS user_id_6 FROM alertes t0 WHERE t0.user_id IS NULL

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.rayon AS rayon_2,
  t0.texte AS texte_3,
  t0.villes_id AS villes_id_4,
  t0.categories_id AS categories_id_5,
  t0.user_id AS user_id_6
FROM
  alertes t0
WHERE
  t0.user_id IS NULL

SELECT t0.id AS id_1, t0.rayon AS rayon_2, t0.texte AS texte_3, t0.villes_id AS villes_id_4, t0.categories_id AS categories_id_5, t0.user_id AS user_id_6 FROM alertes t0 WHERE t0.user_id IS NULL;

0.40 ms
(18.98%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM categories t0

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  categories t0

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM categories t0;

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\Categories	No errors.
App\Entity\Annonces	No errors.
App\Entity\Alertes	No errors.
App\Entity\NotesEnseignes	The mappings App\Entity\NotesEnseignes#Enseigne and App\Entity\User#notesEnseignes are inconsistent with each other.
App\Entity\Villes	No errors.
App\Entity\User	No errors.

Symfony Profiler

https://modixom.fr/index.php/detailAnonnce/45

Configuration Settings

Theme