Query Metrics

9 Database Queries
8 Different statements
21.17 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
10.37 ms
(49.01%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.breve AS breve_3, t0.keyword AS keyword_4, t0.link AS link_5, t0.nomcompte AS nomcompte_6, t0.numcompte AS numcompte_7, t0.description AS description_8, t0.rang AS rang_9, t0.date AS date_10, t0.typearticle AS typearticle_11, t0.type_id AS type_id_12, t0.user_id AS user_id_13, t0.imgservice_id AS imgservice_id_14, t0.produit_id AS produit_id_15 FROM service t0 WHERE t0.id = ?
Parameters:
[
  "3"
]
2.74 ms
(12.94%)
2
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
]
2.13 ms
(10.04%)
1
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:
[]
1.68 ms
(7.92%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.link AS link_4, t0.typearticle AS typearticle_5, t0.date AS date_6, t0.rang AS rang_7, t0.breve AS breve_8, t0.user_id AS user_id_9, t0.service_id AS service_id_10, t0.imgevenement_id AS imgevenement_id_11 FROM evenement t0 WHERE t0.service_id = ?
Parameters:
[
  3
]
1.19 ms
(5.61%)
1
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"
]
1.18 ms
(5.58%)
1
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"
]
1.00 ms
(4.73%)
1
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
]
0.88 ms
(4.16%)
1
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 = ?
Parameters:
[
  "presentation"
]

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\Service\Service No errors.
App\Entity\Produit\Service\Typearticle No errors.
App\Entity\Users\User\User No errors.
App\Entity\Produit\Service\Imgservice No errors.
App\Entity\Produit\Produit\Produit No errors.
App\Entity\Produit\Service\Evenement No errors.
App\Entity\Produit\Service\Imgevenement No errors.
App\Entity\Produit\Produit\Categorie No errors.
App\Entity\Produit\Produit\Souscategorie No errors.
App\Entity\Produit\Produit\Caracteristique No errors.
App\Entity\Users\User\Notification No errors.
App\Entity\Users\User\Billet No errors.