Query Metrics
9
Database Queries
6
Different statements
23.32 ms
Query time
6
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 2.90 ms |
SELECT t0.id AS id_1, t0.labeleType AS labeleType_2, t0.caracteristiques AS caracteristiques_3, t0.delais AS delais_4, t0.tarifs AS tarifs_5, t0.traif AS traif_6, t0.fraisDePort AS fraisDePort_7, t0.date AS date_8, t0.description AS description_9, t0.plusDescription AS plusDescription_10, t0.MontantHt AS MontantHt_11, t0.MontantTTC AS MontantTTC_12, t0.PoindsEnGrContenant AS PoindsEnGrContenant_13, t0.PoidsEnGrProduit AS PoidsEnGrProduit_14, t0.PoidsTotalEnGrHorsPochette AS PoidsTotalEnGrHorsPochette_15, t0.PochetteEnvoi AS PochetteEnvoi_16, t0.statut AS statut_17, t0.reversement AS reversement_18, t0.iduser AS iduser_19 FROM typeproduit t0 WHERE t0.statut = ?
Parameters:
[
"publier"
]
|
2 | 2.48 ms |
SELECT t0.id AS id_1, t0.libiller AS libiller_2, t0.code AS code_3, t0.typeref AS typeref_4 FROM ref t0 WHERE t0.libiller = ? LIMIT 1
Parameters:
[
"mise en avant"
]
|
3 | 2.60 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.dateCreation AS dateCreation_3, t0.user AS user_4, t0.slide1 AS slide1_5, t0.slide2 AS slide2_6, t0.slide3 AS slide3_7, t0.statut AS statut_8 FROM site t0 WHERE t0.statut = ? LIMIT 1
Parameters:
[
9
]
|
4 | 2.63 ms |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.date AS date_2, b0_.description AS description_3, b0_.categorie AS categorie_4, b0_.statut AS statut_5, b0_.iduser AS iduser_6 FROM blog b0_ INNER JOIN ref r1_ ON b0_.statut = r1_.id WHERE r1_.libiller <> ? ORDER BY b0_.date DESC
Parameters:
[
"archivé"
]
|
5 | 2.87 ms |
SELECT t0.id AS id_1, t0.labeleType AS labeleType_2, t0.caracteristiques AS caracteristiques_3, t0.delais AS delais_4, t0.tarifs AS tarifs_5, t0.traif AS traif_6, t0.fraisDePort AS fraisDePort_7, t0.date AS date_8, t0.description AS description_9, t0.plusDescription AS plusDescription_10, t0.MontantHt AS MontantHt_11, t0.MontantTTC AS MontantTTC_12, t0.PoindsEnGrContenant AS PoindsEnGrContenant_13, t0.PoidsEnGrProduit AS PoidsEnGrProduit_14, t0.PoidsTotalEnGrHorsPochette AS PoidsTotalEnGrHorsPochette_15, t0.PochetteEnvoi AS PochetteEnvoi_16, t0.statut AS statut_17, t0.reversement AS reversement_18, t0.iduser AS iduser_19 FROM typeproduit t0 WHERE t0.statut = ?
Parameters:
[
"publier"
]
|
6 | 2.50 ms |
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.description AS description_3, t0.image AS image_4 FROM slide t0 WHERE t0.id = ?
Parameters:
[
1
]
|
7 | 2.51 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.date AS date_3, t0.idblog AS idblog_4, t0.descreption AS descreption_5, t0.idposition AS idposition_6, t0.idref AS idref_7, t0.iduser AS iduser_8 FROM attachment t0 WHERE t0.id = ?
Parameters:
[
267
]
|
8 | 2.42 ms |
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.description AS description_3, t0.image AS image_4 FROM slide t0 WHERE t0.id = ?
Parameters:
[
2
]
|
9 | 2.41 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.date AS date_3, t0.idblog AS idblog_4, t0.descreption AS descreption_5, t0.idposition AS idposition_6, t0.idref AS idref_7, t0.iduser AS iduser_8 FROM attachment t0 WHERE t0.id = ?
Parameters:
[
268
]
|
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\Typeproduit |
|
App\Entity\User |
|
App\Entity\TypeProduitPhoto | No errors. |
App\Entity\Reversement | No errors. |
App\Entity\Produit | No errors. |
App\Entity\TypeProduitConditionnement | No errors. |
App\Entity\Ref | No errors. |
App\Entity\Typeref | No errors. |
App\Entity\Panier | No errors. |
App\Entity\Promotions | No errors. |
App\Entity\Site | No errors. |
App\Entity\Slide | No errors. |
App\Entity\Blog |
|
App\Entity\Adress | No errors. |
App\Entity\Commande |
|
App\Entity\Etablisment | No errors. |
App\Entity\Sejour |
|
App\Entity\Comptebancaire | No errors. |
App\Entity\SejourAttachment | No errors. |
App\Entity\Etiquette | No errors. |
App\Entity\CommentaireEtiquette | No errors. |
App\Entity\Fonctions | No errors. |
App\Entity\LogPromotions | No errors. |
App\Entity\PromoParents | No errors. |
App\Entity\Photonsumeriques | No errors. |
App\Entity\Attachment | No errors. |
App\Entity\PanierProduit | No errors. |
App\Entity\PromoSejour | No errors. |
App\Entity\BlogAttachement | No errors. |
App\Entity\ComandeProduit | No errors. |
App\Entity\CommandeNumerique | No errors. |
App\Entity\Cart |
|
App\Entity\Jourdescripdate | No errors. |
App\Entity\ParentSejour | No errors. |
App\Entity\AttachementEtiquette | No errors. |
App\Entity\Position | No errors. |