Query Metrics

12 Database Queries
10 Different statements
7.01 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.55 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.helpdashboard AS helpdashboard_4, t0.link AS link_5, t0.date AS date_6, t0.nbvente AS nbvente_7, t0.rang AS rang_8, t0.src AS src_9, t0.alt AS alt_10, t0.user_id AS user_id_11, t0.categorie_id AS categorie_id_12, t0.cataloguechantier_id AS cataloguechantier_id_13 FROM souscategorie t0 WHERE t0.id = ?
Parameters:
[
  "6"
]
2 1.92 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contenu AS contenu_3, t0.rapport AS rapport_4, t0.rang AS rang_5, t0.choixauteur AS choixauteur_6, t0.date AS date_7, t0.nblike AS nblike_8, t0.nbvente AS nbvente_9, t0.newprise AS newprise_10, t0.lastprise AS lastprise_11, t0.difference AS difference_12, t0.prixlivraison AS prixlivraison_13, t0.nbvote AS nbvote_14, t0.totalnote AS totalnote_15, t0.user_id AS user_id_16, t0.imgproduit_id AS imgproduit_id_17, t0.souscategorie_id AS souscategorie_id_18 FROM produit t0 WHERE t0.souscategorie_id = ? ORDER BY t0.date ASC
Parameters:
[
  6
]
3 0.46 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.typeservice AS typeservice_3, t0.description AS description_4, t0.date AS date_5, t0.rang AS rang_6, t0.src AS src_7, t0.alt AS alt_8, t0.user_id AS user_id_9 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
  2
]
4 0.59 ms
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.typeservice AS typeservice_2, c0_.description AS description_3, c0_.date AS date_4, c0_.rang AS rang_5, c0_.src AS src_6, c0_.alt AS alt_7, c0_.user_id AS user_id_8 FROM categorie c0_ WHERE c0_.typeservice LIKE ? OR c0_.typeservice LIKE ? ORDER BY c0_.rang ASC LIMIT 2
Parameters:
[
  "%continue%"
  "%diplomante%"
]
5 0.50 ms
SELECT c0_.id AS id_0, c0_.src AS src_1, c0_.alt AS alt_2, c0_.nom AS nom_3, c0_.description AS description_4, c0_.rang AS rang_5, a1_.id AS id_6, a1_.nom AS nom_7, a1_.description AS description_8, a1_.rang AS rang_9, a1_.siteweb AS siteweb_10, a1_.src AS src_11, a1_.alt AS alt_12, a1_.categorieappli_id AS categorieappli_id_13 FROM categorieappli c0_ LEFT JOIN application a1_ ON c0_.id = a1_.categorieappli_id ORDER BY c0_.rang ASC
Parameters:
[]
6 0.36 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.helpdashboard AS helpdashboard_4, t0.link AS link_5, t0.date AS date_6, t0.nbvente AS nbvente_7, t0.rang AS rang_8, t0.src AS src_9, t0.alt AS alt_10, t0.user_id AS user_id_11, t0.categorie_id AS categorie_id_12, t0.cataloguechantier_id AS cataloguechantier_id_13 FROM souscategorie t0 WHERE t0.categorie_id = ?
Parameters:
[
  1
]
7 0.41 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.helpdashboard AS helpdashboard_4, t0.link AS link_5, t0.date AS date_6, t0.nbvente AS nbvente_7, t0.rang AS rang_8, t0.src AS src_9, t0.alt AS alt_10, t0.user_id AS user_id_11, t0.categorie_id AS categorie_id_12, t0.cataloguechantier_id AS cataloguechantier_id_13 FROM souscategorie t0 WHERE t0.categorie_id = ?
Parameters:
[
  2
]
8 0.29 ms
SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.description AS description_2, a0_.rang AS rang_3, a0_.siteweb AS siteweb_4, a0_.src AS src_5, a0_.alt AS alt_6, c1_.id AS id_7, c1_.src AS src_8, c1_.alt AS alt_9, c1_.nom AS nom_10, c1_.description AS description_11, c1_.rang AS rang_12, a0_.categorieappli_id AS categorieappli_id_13 FROM application a0_ LEFT JOIN categorieappli c1_ ON a0_.categorieappli_id = c1_.id ORDER BY a0_.rang ASC
Parameters:
[]
9 0.50 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.breve AS breve_4, t0.keyword AS keyword_5, t0.link AS link_6, t0.nomcompte AS nomcompte_7, t0.numcompte AS numcompte_8, t0.rang AS rang_9, t0.principal AS principal_10, t0.date AS date_11, t0.typearticle AS typearticle_12, t0.date_event AS date_event_13, t0.user_id AS user_id_14, t0.souscategorie_id AS souscategorie_id_15, t0.imgservice_id AS imgservice_id_16, t0.type_id AS type_id_17 FROM service t0 WHERE t0.typearticle = ? ORDER BY t0.rang ASC LIMIT 1
Parameters:
[
  "aproposinstitut"
]
10 0.50 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "logosm"
]
11 0.58 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.helpdashboard AS helpdashboard_4, t0.link AS link_5, t0.date AS date_6, t0.nbvente AS nbvente_7, t0.rang AS rang_8, t0.src AS src_9, t0.alt AS alt_10, t0.user_id AS user_id_11, t0.categorie_id AS categorie_id_12, t0.cataloguechantier_id AS cataloguechantier_id_13 FROM souscategorie t0 WHERE t0.categorie_id = ? ORDER BY t0.rang ASC
Parameters:
[
  1
]
12 0.36 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.helpdashboard AS helpdashboard_4, t0.link AS link_5, t0.date AS date_6, t0.nbvente AS nbvente_7, t0.rang AS rang_8, t0.src AS src_9, t0.alt AS alt_10, t0.user_id AS user_id_11, t0.categorie_id AS categorie_id_12, t0.cataloguechantier_id AS cataloguechantier_id_13 FROM souscategorie t0 WHERE t0.categorie_id = ? ORDER BY t0.rang ASC
Parameters:
[
  2
]

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\Produit\Produit\Souscategorie No errors.
App\Entity\Users\User\User No errors.
App\Entity\Produit\Produit\Categorie No errors.
App\Entity\Produit\Produit\Cataloguechantier No errors.
App\Entity\Produit\Produit\Produit No errors.
App\Entity\Produit\Produit\Caracteristique No errors.
App\Entity\Produit\Produit\Imgproduit No errors.
App\Entity\Produit\Produit\Coutlivraison No errors.
App\Entity\Produit\Produit\Caracteristiqueproduit No errors.
App\Entity\Produit\Service\Categorieappli No errors.
App\Entity\Produit\Service\Application No errors.
App\Entity\Produit\Service\Service No errors.
App\Entity\Produit\Service\Imgservice No errors.
App\Entity\Produit\Service\Typearticle No errors.
App\Entity\Produit\Service\Evenement No errors.
App\Entity\Produit\Service\Commentaireblog No errors.
App\Entity\Produit\Service\Ressourcearticle No errors.
App\Entity\Users\Adminuser\Parametreadmin No errors.