Query Metrics

19 Database Queries
5 Different statements
8.66 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
3.43 ms
(39.64%)
15
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.type AS type_5, t0.password AS password_6, t0.phone AS phone_7 FROM connexion_user t0 WHERE t0.id = ?
Parameters:
[
  513
]
2.19 ms
(25.35%)
1
SELECT p0_.id AS id_0, p0_.url AS url_1, p0_.phone AS phone_2, p0_.nom AS nom_3, p0_.prenom AS prenom_4, p0_.email AS email_5, p0_.file AS file_6, p0_.montant AS montant_7, p0_.order_number AS order_number_8, p0_.date_ad AS date_ad_9, p0_.supp AS supp_10, p0_.pai AS pai_11, p0_.total AS total_12, p0_.accomp AS accomp_13, p0_.pourcentage AS pourcentage_14, p0_.surplace AS surplace_15, p0_.virement AS virement_16, p0_.ordernumberid AS ordernumberid_17, p0_.adhesion AS adhesion_18, p0_.id_user_id AS id_user_id_19, p0_.evenement_id_id AS evenement_id_id_20, p0_.evenementautre_id AS evenementautre_id_21 FROM payement_method p0_ LEFT JOIN congre c1_ ON p0_.evenement_id_id = c1_.id WHERE p0_.id IN (?) ORDER BY p0_.evenement_id_id ASC
Parameters:
[
  [
    1073
    1074
    1075
    1076
    1077
    1078
    1079
    1080
    1081
    1082
    1083
    1084
    1085
    1086
    1087
    1088
    1089
    1090
    1091
    1092
  ]
]
1.74 ms
(20.12%)
1
SELECT DISTINCT p0_.id AS id_0, p0_.evenement_id_id AS sclr_1 FROM payement_method p0_ LEFT JOIN congre c1_ ON p0_.evenement_id_id = c1_.id ORDER BY p0_.evenement_id_id ASC LIMIT 20 OFFSET 1660
Parameters:
[]
0.87 ms
(10.01%)
1
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM payement_method p0_ LEFT JOIN congre c1_ ON p0_.evenement_id_id = c1_.id
Parameters:
[]
0.42 ms
(4.88%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.category AS category_3, t0.description AS description_4, t0.url_maps AS url_maps_5, t0.image_principale AS image_principale_6, t0.desplay AS desplay_7, t0.user_id AS user_id_8, t0.date_evenement AS date_evenement_9, t0.evenementcongre_id AS evenementcongre_id_10 FROM congre t0 WHERE t0.id = ?
Parameters:
[
  19
]

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\PayementMethod
  • The association App\Entity\PayementMethod#evenementId refers to the inverse side field App\Entity\Congre#evenementIdCongre which does not exist.
App\Entity\Congre
  • The mappings App\Entity\Congre#venementIdCongre and App\Entity\AttachmentCongre#evenementCongre are inconsistent with each other.
  • The mappings App\Entity\Congre#carouselCongreAffiche and App\Entity\PayementMethod#evenementId are inconsistent with each other.
App\Entity\ConnexionUser No errors.
App\Entity\EvenementAVenir No errors.
App\Entity\Event
  • The association App\Entity\Event#newevenet refers to the inverse side field App\Entity\Document#newdocument which does not exist.
App\Entity\AttachmentCongre No errors.
App\Entity\PrixVariableCongre No errors.
App\Entity\Etape No errors.
App\Entity\Speakers No errors.
App\Entity\Sponsored No errors.
App\Entity\Document No errors.