POST https://bdc.concept-erp.info/recherche

Query Metrics

15 Database Queries
4 Different statements
315.63 ms Query time
0 Invalid entities
33 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.63 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.enabled AS enabled_6, t0.salt AS salt_7, t0.last_login AS last_login_8 FROM user t0 WHERE t0.id = ?
Parameters:
[
  42
]
2 311.10 ms
SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.contenu AS contenu_2, p0_.exemple AS exemple_3, p0_.date AS date_4, p0_.date_modif AS date_modif_5, p0_.statut AS statut_6, m1_.id AS id_7, m1_.mot AS mot_8, p0_.categorie_id AS categorie_id_9, p0_.auteur_id AS auteur_id_10, p0_.user_modif_id AS user_modif_id_11 FROM page p0_ LEFT JOIN page_mot_cle p2_ ON p0_.id = p2_.page_id LEFT JOIN mot_cle m1_ ON m1_.id = p2_.mot_cle_id WHERE (p0_.statut LIKE ? AND p0_.titre LIKE ?) OR p0_.contenu LIKE ? OR m1_.mot LIKE ? ORDER BY p0_.titre ASC
Parameters:
[
  "Active"
  "%compteur%"
  "%compteur%"
  "%compteur%"
]
3 0.53 ms
SELECT t0.id AS id_1, t0.experience AS experience_2, t0.description AS description_3, t0.niveau AS niveau_4, t0.favori AS favori_5, t0.categorie_mere_id AS categorie_mere_id_6 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
  16
]
4 0.29 ms
SELECT t0.id AS id_1, t0.extension AS extension_2, t0.nom AS nom_3, t0.uuid AS uuid_4, t0.page_id AS page_id_5 FROM fichier_page t0 WHERE t0.page_id = ?
Parameters:
[
  327
]
5 0.20 ms
SELECT t0.id AS id_1, t0.experience AS experience_2, t0.description AS description_3, t0.niveau AS niveau_4, t0.favori AS favori_5, t0.categorie_mere_id AS categorie_mere_id_6 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
  7
]
6 0.36 ms
SELECT t0.id AS id_1, t0.extension AS extension_2, t0.nom AS nom_3, t0.uuid AS uuid_4, t0.page_id AS page_id_5 FROM fichier_page t0 WHERE t0.page_id = ?
Parameters:
[
  7
]
7 0.33 ms
SELECT t0.id AS id_1, t0.experience AS experience_2, t0.description AS description_3, t0.niveau AS niveau_4, t0.favori AS favori_5, t0.categorie_mere_id AS categorie_mere_id_6 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
  11
]
8 0.27 ms
SELECT t0.id AS id_1, t0.extension AS extension_2, t0.nom AS nom_3, t0.uuid AS uuid_4, t0.page_id AS page_id_5 FROM fichier_page t0 WHERE t0.page_id = ?
Parameters:
[
  276
]
9 0.35 ms
SELECT t0.id AS id_1, t0.experience AS experience_2, t0.description AS description_3, t0.niveau AS niveau_4, t0.favori AS favori_5, t0.categorie_mere_id AS categorie_mere_id_6 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
  17
]
10 0.28 ms
SELECT t0.id AS id_1, t0.extension AS extension_2, t0.nom AS nom_3, t0.uuid AS uuid_4, t0.page_id AS page_id_5 FROM fichier_page t0 WHERE t0.page_id = ?
Parameters:
[
  191
]
11 0.27 ms
SELECT t0.id AS id_1, t0.experience AS experience_2, t0.description AS description_3, t0.niveau AS niveau_4, t0.favori AS favori_5, t0.categorie_mere_id AS categorie_mere_id_6 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
  12
]
12 0.30 ms
SELECT t0.id AS id_1, t0.extension AS extension_2, t0.nom AS nom_3, t0.uuid AS uuid_4, t0.page_id AS page_id_5 FROM fichier_page t0 WHERE t0.page_id = ?
Parameters:
[
  74
]
13 0.25 ms
SELECT t0.id AS id_1, t0.extension AS extension_2, t0.nom AS nom_3, t0.uuid AS uuid_4, t0.page_id AS page_id_5 FROM fichier_page t0 WHERE t0.page_id = ?
Parameters:
[
  56
]
14 0.24 ms
SELECT t0.id AS id_1, t0.experience AS experience_2, t0.description AS description_3, t0.niveau AS niveau_4, t0.favori AS favori_5, t0.categorie_mere_id AS categorie_mere_id_6 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
  2
]
15 0.23 ms
SELECT t0.id AS id_1, t0.extension AS extension_2, t0.nom AS nom_3, t0.uuid AS uuid_4, t0.page_id AS page_id_5 FROM fichier_page t0 WHERE t0.page_id = ?
Parameters:
[
  352
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\MotCle 12
App\Entity\Categorie 8
App\Entity\Page 7
App\Entity\User 4
App\Entity\FichierPage 2

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Page No errors.
App\Entity\MotCle No errors.
App\Entity\Categorie No errors.
App\Entity\FichierPage No errors.