Query Metrics

8 Database Queries
6 Different statements
8.77 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.93 ms
SELECT i0_.id AS id_0, i0_.src AS src_1, i0_.alt AS alt_2, i0_.titre AS titre_3, i0_.description AS description_4, i0_.rang AS rang_5, i0_.slide AS slide_6, i0_.link AS link_7, i0_.date AS date_8, s1_.id AS id_9, s1_.nom AS nom_10, s1_.typebusiness AS typebusiness_11, s1_.description AS description_12, s1_.helpdashboard AS helpdashboard_13, s1_.link AS link_14, s1_.date AS date_15, s1_.nbvente AS nbvente_16, s1_.rang AS rang_17, s1_.src AS src_18, s1_.alt AS alt_19, i0_.souscategorie_id AS souscategorie_id_20, i0_.user_id AS user_id_21, s1_.user_id AS user_id_22, s1_.categorie_id AS categorie_id_23 FROM imgslide i0_ LEFT JOIN souscategorie s1_ ON i0_.souscategorie_id = s1_.id WHERE i0_.slide = 1 ORDER BY i0_.rang ASC
Parameters:
[]
2 1.62 ms
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.description AS description_2, c0_.date AS date_3, c0_.rang AS rang_4, c0_.src AS src_5, c0_.alt AS alt_6, s1_.id AS id_7, s1_.nom AS nom_8, s1_.typebusiness AS typebusiness_9, s1_.description AS description_10, s1_.helpdashboard AS helpdashboard_11, s1_.link AS link_12, s1_.date AS date_13, s1_.nbvente AS nbvente_14, s1_.rang AS rang_15, s1_.src AS src_16, s1_.alt AS alt_17, c0_.user_id AS user_id_18, s1_.user_id AS user_id_19, s1_.categorie_id AS categorie_id_20 FROM categorie c0_ LEFT JOIN souscategorie s1_ ON c0_.id = s1_.categorie_id ORDER BY c0_.rang ASC
Parameters:
[]
3 2.13 ms
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.description AS description_2, c0_.date AS date_3, c0_.rang AS rang_4, c0_.src AS src_5, c0_.alt AS alt_6, s1_.id AS id_7, s1_.nom AS nom_8, s1_.typebusiness AS typebusiness_9, s1_.description AS description_10, s1_.helpdashboard AS helpdashboard_11, s1_.link AS link_12, s1_.date AS date_13, s1_.nbvente AS nbvente_14, s1_.rang AS rang_15, s1_.src AS src_16, s1_.alt AS alt_17, c0_.user_id AS user_id_18, s1_.user_id AS user_id_19, s1_.categorie_id AS categorie_id_20 FROM categorie c0_ LEFT JOIN souscategorie s1_ ON c0_.id = s1_.categorie_id ORDER BY c0_.rang ASC
Parameters:
[]
4 0.85 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.date AS date_4, t0.transaction AS transaction_5, t0.valide AS valide_6, t0.lut AS lut_7, t0.depot AS depot_8, t0.retrait AS retrait_9, t0.timestamp AS timestamp_10, t0.user_id AS user_id_11, t0.auteur_id AS auteur_id_12, t0.billet_id AS billet_id_13, t0.service_id AS service_id_14 FROM notification t0 WHERE t0.user_id IS NULL AND t0.lut = ? ORDER BY t0.date DESC
Parameters:
[
  "false"
]
5 1.08 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.rang AS rang_4, t0.src AS src_5, t0.alt AS alt_6, t0.position AS position_7, t0.date AS date_8, t0.user_id AS user_id_9 FROM typearticle t0 WHERE t0.position = ? ORDER BY t0.rang ASC
Parameters:
[
  "interface"
]
6 0.35 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.date AS date_4, t0.rang AS rang_5, t0.src AS src_6, t0.alt AS alt_7, t0.user_id AS user_id_8 FROM categorie t0 WHERE t0.rang = ? LIMIT 1
Parameters:
[
  2
]
7 1.07 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.typebusiness AS typebusiness_3, t0.description AS description_4, t0.helpdashboard AS helpdashboard_5, t0.link AS link_6, t0.date AS date_7, t0.nbvente AS nbvente_8, t0.rang AS rang_9, t0.src AS src_10, t0.alt AS alt_11, t0.user_id AS user_id_12, t0.categorie_id AS categorie_id_13 FROM souscategorie t0 WHERE t0.categorie_id = ? ORDER BY t0.rang ASC
Parameters:
[
  1
]
8 0.74 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.typebusiness AS typebusiness_3, t0.description AS description_4, t0.helpdashboard AS helpdashboard_5, t0.link AS link_6, t0.date AS date_7, t0.nbvente AS nbvente_8, t0.rang AS rang_9, t0.src AS src_10, t0.alt AS alt_11, t0.user_id AS user_id_12, t0.categorie_id AS categorie_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\Users\User\Imgslide No 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\Service\Service No errors.
App\Entity\Produit\Produit\Produit No errors.
App\Entity\Produit\Produit\Caracteristique No errors.
App\Entity\Users\User\Notification No errors.
App\Entity\Users\User\Billet No errors.
App\Entity\Produit\Service\Typearticle No errors.