https://www.5sur5sejour.com/Accueil5sur5/Boutique_Souvenirs

Method
GET
HTTP Status
200
IP
216.73.216.30
Profiled on
Token
42de89

Query Metrics

28 Database Queries
4 Different statements
74.29 ms Query time
2 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 3.74 ms 
SELECT t0_.id AS id_0, t0_.montantHT AS montantHT_1, t0_.montantTTC AS montantTTC_2, t0_.TVA AS TVA_3, t0_.poidsContenant AS poidsContenant_4, t0_.poidsProduit AS poidsProduit_5, t0_.poidsTotal AS poidsTotal_6, t0_.pochetteEnvoi AS pochetteEnvoi_7, t0_.descriptionCommande AS descriptionCommande_8, t0_.type AS type_9, t0_.sousTitre AS sousTitre_10, t0_.orderprod AS orderprod_11, t0_.idTypeProduit_id AS idTypeProduit_id_12 FROM typeproduitconditionnement t0_ INNER JOIN typeproduit t1_ ON t0_.idTypeProduit_id = t1_.id WHERE t1_.statut = ? ORDER BY t0_.orderprod ASC
Parameters: 
[
  "publier"
]
View formatted query    View runnable query    Explain query
2 2.82 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.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
3 2.59 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.id = ?
Parameters: 
[
  15
]
View formatted query    View runnable query    Explain query
4 2.62 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.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
5 2.96 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.idProduitConditionnement_id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
6 3.06 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: 
[
  1100
]
View formatted query    View runnable query    Explain query
7 2.60 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.id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
8 2.59 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.idProduitConditionnement_id = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
9 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: 
[
  1110
]
View formatted query    View runnable query    Explain query
10 2.64 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.id = ?
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query
11 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.idProduitConditionnement_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
12 2.69 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: 
[
  1073
]
View formatted query    View runnable query    Explain query
13 2.53 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.idProduitConditionnement_id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
14 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: 
[
  1078
]
View formatted query    View runnable query    Explain query
15 2.57 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.idProduitConditionnement_id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
16 2.60 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: 
[
  1079
]
View formatted query    View runnable query    Explain query
17 2.65 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.id = ?
Parameters: 
[
  18
]
View formatted query    View runnable query    Explain query
18 2.59 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.idProduitConditionnement_id = ?
Parameters: 
[
  9
]
View formatted query    View runnable query    Explain query
19 2.71 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
20 2.50 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.idProduitConditionnement_id = ?
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query
21 2.70 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.id = ?
Parameters: 
[
  17
]
View formatted query    View runnable query    Explain query
22 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.idProduitConditionnement_id = ?
Parameters: 
[
  8
]
View formatted query    View runnable query    Explain query
23 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: 
[
  1163
]
View formatted query    View runnable query    Explain query
24 2.61 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.id = ?
Parameters: 
[
  19
]
View formatted query    View runnable query    Explain query
25 2.49 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.idProduitConditionnement_id = ?
Parameters: 
[
  12
]
View formatted query    View runnable query    Explain query
26 2.43 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
27 2.52 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.idProduitConditionnement_id = ?
Parameters: 
[
  13
]
View formatted query    View runnable query    Explain query
28 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.idProduitConditionnement_id = ?
Parameters: 
[
  14
]
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\TypeProduitConditionnement No 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\TypeProduitPhoto No errors.
App\Entity\Produit No errors.
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\Reversement No errors.
App\Entity\Attachment No errors.
App\Entity\Position No errors.
App\Entity\Ref No errors.