Query Metrics

8 Database Queries
7 Different statements
14.42 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.30 ms
SELECT s0_.id AS id_0, s0_.nom AS nom_1, s0_.typebusiness AS typebusiness_2, s0_.description AS description_3, s0_.helpdashboard AS helpdashboard_4, s0_.link AS link_5, s0_.date AS date_6, s0_.nbvente AS nbvente_7, s0_.rang AS rang_8, s0_.src AS src_9, s0_.alt AS alt_10, p1_.id AS id_11, p1_.nom AS nom_12, p1_.contenu AS contenu_13, p1_.rapport AS rapport_14, p1_.date AS date_15, p1_.rang AS rang_16, p1_.nbvote AS nbvote_17, p1_.totalnote AS totalnote_18, p1_.nblike AS nblike_19, p1_.nbvente AS nbvente_20, p1_.choixauteur AS choixauteur_21, p1_.newprise AS newprise_22, p1_.prixrenew AS prixrenew_23, p1_.prixtransfert AS prixtransfert_24, p1_.lastprise AS lastprise_25, p1_.difference AS difference_26, p1_.prixlivraison AS prixlivraison_27, s0_.user_id AS user_id_28, s0_.categorie_id AS categorie_id_29, p1_.user_id AS user_id_30, p1_.imgproduit_id AS imgproduit_id_31, p1_.souscategorie_id AS souscategorie_id_32, p1_.cataloguechantier_id AS cataloguechantier_id_33 FROM souscategorie s0_ LEFT JOIN produit p1_ ON s0_.id = p1_.souscategorie_id WHERE s0_.typebusiness LIKE ? OR s0_.typebusiness LIKE ? ORDER BY s0_.rang ASC
Parameters:
[
  "%programme%"
  "%business%"
]
2 1.21 ms
SELECT t0.id AS id_1, t0.minimum AS minimum_2, t0.maximum AS maximum_3, t0.nom AS nom_4, t0.typeoperation AS typeoperation_5, t0.description AS description_6, t0.date AS date_7, t0.rang AS rang_8, t0.src AS src_9, t0.alt AS alt_10, t0.user_id AS user_id_11 FROM categorieinvestisseur t0 WHERE t0.typeoperation = ? ORDER BY t0.rang ASC
Parameters:
[
  "donnation"
]
3 3.01 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 1.70 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 2.33 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 1.46 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.42 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.99 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\Produit\Produit\Souscategorie No errors.
App\Entity\Produit\Produit\Produit No errors.
App\Entity\Users\User\User No errors.
App\Entity\Produit\Produit\Categorie No errors.
App\Entity\Produit\Produit\Imgproduit No errors.
App\Entity\Produit\Produit\Cataloguechantier No errors.
App\Entity\Produit\Produit\Caracteristique No errors.
App\Entity\Produit\Produit\Caracteristiqueproduit No errors.
App\Entity\Produit\Produit\Coutlivraison No errors.
App\Entity\Produit\Service\Service No errors.
App\Entity\Tresorerie\Investisseur\Categorieinvestisseur No errors.
App\Entity\Users\User\Notification No errors.
App\Entity\Users\User\Billet No errors.
App\Entity\Produit\Service\Typearticle No errors.