Query Metrics

8 Database Queries
5 Different statements
8.34 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.56 ms
(42.68%)
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_ WHERE p0_.id IN (?) ORDER BY p0_.supp DESC
Parameters:
[
  [
    1609
    1621
    1600
    1647
    1727
    1605
    1619
    1611
    1584
    1481
    1503
    1590
    1578
    1604
    1581
    1670
    1536
    245
    262
    240
  ]
]
2.22 ms
(26.56%)
1
SELECT DISTINCT p0_.id AS id_0, p0_.supp AS supp_1 FROM payement_method p0_ ORDER BY p0_.supp DESC LIMIT 20
Parameters:
[]
0.99 ms
(11.87%)
2
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:
[
  21
]
0.84 ms
(10.06%)
3
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:
[
  161
]
0.74 ms
(8.83%)
1
SELECT count(p0_.id) AS sclr_0 FROM payement_method p0_
Parameters:
[]

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\ConnexionUser No errors.
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\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.