https://futur.5sur5sejour.fr/Accueil5sur5/album/ALL

Method
GET
HTTP Status
200
IP
18.221.55.191
Profiled on
Token
33b384

Query Metrics

33 Database Queries
3 Different statements
86.70 ms Query time
6 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 3.41 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"
]
View formatted query    View runnable query    Explain query
2 2.91 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"
]
View formatted query    View runnable query    Explain query
3 3.27 ms 
SELECT t0.id AS id_1, t0.date AS date_2, t0.statut AS statut_3, t0.id_attachement AS id_attachement_4, t0.id_typep AS id_typep_5, t0.idProduitConditionnement_id AS idProduitConditionnement_id_6 FROM type_produit_photo t0 WHERE t0.id_typep = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
4 3.05 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: 
[
  1094
]
View formatted query    View runnable query    Explain query
5 2.49 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: 
[
  1095
]
View formatted query    View runnable query    Explain query
6 2.56 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: 
[
  1096
]
View formatted query    View runnable query    Explain query
7 2.61 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: 
[
  1097
]
View formatted query    View runnable query    Explain query
8 2.47 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: 
[
  1098
]
View formatted query    View runnable query    Explain query
9 2.47 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: 
[
  1099
]
View formatted query    View runnable query    Explain query
10 2.55 ms 
SELECT t0.id AS id_1, t0.date AS date_2, t0.statut AS statut_3, t0.id_attachement AS id_attachement_4, t0.id_typep AS id_typep_5, t0.idProduitConditionnement_id AS idProduitConditionnement_id_6 FROM type_produit_photo t0 WHERE t0.id_typep = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
11 2.50 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: 
[
  1106
]
View formatted query    View runnable query    Explain query
12 2.46 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: 
[
  1107
]
View formatted query    View runnable query    Explain query
13 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: 
[
  1108
]
View formatted query    View runnable query    Explain query
14 2.50 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: 
[
  1109
]
View formatted query    View runnable query    Explain query
15 2.60 ms 
SELECT t0.id AS id_1, t0.date AS date_2, t0.statut AS statut_3, t0.id_attachement AS id_attachement_4, t0.id_typep AS id_typep_5, t0.idProduitConditionnement_id AS idProduitConditionnement_id_6 FROM type_produit_photo t0 WHERE t0.id_typep = ?
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query
16 2.75 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: 
[
  1071
]
View formatted query    View runnable query    Explain query
17 2.48 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: 
[
  1072
]
View formatted query    View runnable query    Explain query
18 2.48 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: 
[
  1180
]
View formatted query    View runnable query    Explain query
19 2.65 ms 
SELECT t0.id AS id_1, t0.date AS date_2, t0.statut AS statut_3, t0.id_attachement AS id_attachement_4, t0.id_typep AS id_typep_5, t0.idProduitConditionnement_id AS idProduitConditionnement_id_6 FROM type_produit_photo t0 WHERE t0.id_typep = ?
Parameters: 
[
  15
]
View formatted query    View runnable query    Explain query
20 2.49 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: 
[
  1148
]
View formatted query    View runnable query    Explain query
21 2.56 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: 
[
  1149
]
View formatted query    View runnable query    Explain query
22 2.57 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: 
[
  1150
]
View formatted query    View runnable query    Explain query
23 2.55 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: 
[
  1151
]
View formatted query    View runnable query    Explain query
24 2.65 ms 
SELECT t0.id AS id_1, t0.date AS date_2, t0.statut AS statut_3, t0.id_attachement AS id_attachement_4, t0.id_typep AS id_typep_5, t0.idProduitConditionnement_id AS idProduitConditionnement_id_6 FROM type_produit_photo t0 WHERE t0.id_typep = ?
Parameters: 
[
  17
]
View formatted query    View runnable query    Explain query
25 2.55 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: 
[
  1160
]
View formatted query    View runnable query    Explain query
26 2.66 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: 
[
  1161
]
View formatted query    View runnable query    Explain query
27 2.57 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: 
[
  1162
]
View formatted query    View runnable query    Explain query
28 2.63 ms 
SELECT t0.id AS id_1, t0.date AS date_2, t0.statut AS statut_3, t0.id_attachement AS id_attachement_4, t0.id_typep AS id_typep_5, t0.idProduitConditionnement_id AS idProduitConditionnement_id_6 FROM type_produit_photo t0 WHERE t0.id_typep = ?
Parameters: 
[
  18
]
View formatted query    View runnable query    Explain query
29 2.79 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: 
[
  32906
]
View formatted query    View runnable query    Explain query
30 2.40 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: 
[
  1188
]
View formatted query    View runnable query    Explain query
31 2.57 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: 
[
  32904
]
View formatted query    View runnable query    Explain query
32 2.48 ms 
SELECT t0.id AS id_1, t0.date AS date_2, t0.statut AS statut_3, t0.id_attachement AS id_attachement_4, t0.id_typep AS id_typep_5, t0.idProduitConditionnement_id AS idProduitConditionnement_id_6 FROM type_produit_photo t0 WHERE t0.id_typep = ?
Parameters: 
[
  19
]
View formatted query    View runnable query    Explain query
33 2.52 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: 
[
  1081
]
View formatted query    View runnable query    Explain query

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
  • The field App\Entity\Typeproduit#attachements is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TypeProduitPhoto#idTypep does not contain the required 'inversedBy="attachements"' attribute.
  • The field App\Entity\Typeproduit#reversment is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Reversement#idTypeproduit does not contain the required 'inversedBy="reversment"' attribute.
  • The field App\Entity\Typeproduit#mesproduits is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Produit#type does not contain the required 'inversedBy="mesproduits"' attribute.
App\Entity\User
  • The field App\Entity\User#mescommandes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Commande#idUser does not contain the required 'inversedBy="mescommandes"' attribute.
  • The field App\Entity\User#etablismentuser is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Etablisment#user does not contain the required 'inversedBy="etablismentuser"' attribute.
  • The field App\Entity\User#mesblogs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Blog#iduser does not contain the required 'inversedBy="mesblogs"' attribute.
  • The field App\Entity\User#mesSejourAcc is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Sejour#idAcommp does not contain the required 'inversedBy="mesSejourAcc"' attribute.
  • The field App\Entity\User#mesSejourPart is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Sejour#idPartenaire does not contain the required 'inversedBy="mesSejourPart"' attribute.
App\Entity\TypeProduitPhoto No errors.
App\Entity\Reversement No errors.
App\Entity\Produit No errors.
App\Entity\TypeProduitConditionnement No errors.
App\Entity\Adress No errors.
App\Entity\Ref No errors.
App\Entity\Commande
  • The field App\Entity\Commande#commandesProduits is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ComandeProduit#idComande does not contain the required 'inversedBy="commandesProduits"' attribute.
App\Entity\Etablisment No errors.
App\Entity\Blog
  • The field App\Entity\Blog#mesattachments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\BlogAttachement#idblog does not contain the required 'inversedBy="mesattachments"' attribute.
App\Entity\Sejour
  • The field App\Entity\Sejour#produits is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Produit#idsjour does not contain the required 'inversedBy="produits"' attribute.
  • The field App\Entity\Sejour#commandes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Commande#idSejour does not contain the required 'inversedBy="commandes"' attribute.
  • The field App\Entity\Sejour#cartes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Cart#idsejour does not contain the required 'inversedBy="cartes"' attribute.
  • The field App\Entity\Sejour#attachements is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SejourAttachment#idSejour does not contain the required 'inversedBy="attachements"' attribute.
  • The field App\Entity\Sejour#jourdescripdate is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Jourdescripdate#idsejour does not contain the required 'inversedBy="jourdescripdate"' attribute.
  • The field App\Entity\Sejour#parentSejour is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ParentSejour#idSejour does not contain the required 'inversedBy="parentSejour"' attribute.
App\Entity\Comptebancaire No errors.
App\Entity\SejourAttachment No errors.
App\Entity\Panier 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\Typeref No errors.
App\Entity\Promotions No errors.
App\Entity\ComandeProduit No errors.
App\Entity\CommandeNumerique No errors.
App\Entity\BlogAttachement No errors.
App\Entity\Cart
  • The field App\Entity\Cart#positions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Position#idcart does not contain the required 'inversedBy="positions"' attribute.
App\Entity\Jourdescripdate No errors.
App\Entity\ParentSejour No errors.
App\Entity\PromoSejour No errors.
App\Entity\AttachementEtiquette No errors.
App\Entity\Position No errors.