Query Metrics
8
Database Queries
7
Different statements
14.42 ms
Query time
0
Invalid entities
Queries
#▲ | 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. |