Query Metrics

4 Database Queries
4 Different statements
6.23 ms Query time
3 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 1.99 ms
SELECT DISTINCT p0_.id AS id_0, p0_.evenementautre_id AS sclr_1 FROM payement_method p0_ LEFT JOIN evenement_avenir e1_ ON p0_.evenementautre_id = e1_.id ORDER BY p0_.evenementautre_id ASC LIMIT 20 OFFSET 1440
Parameters:
[]
2 2.85 ms
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 evenement_avenir e1_ ON p0_.evenementautre_id = e1_.id WHERE p0_.id IN (?) ORDER BY p0_.evenementautre_id ASC
Parameters:
[
  [
    2388
    2389
    2390
    2391
    2392
    2393
    2394
    2395
    2396
    2397
    2398
    2399
    2400
    2401
    2402
    2403
    2404
    2405
    2406
    2407
  ]
]
3 0.90 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM payement_method p0_ LEFT JOIN evenement_avenir e1_ ON p0_.evenementautre_id = e1_.id
Parameters:
[]
4 0.48 ms
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:
[
  23
]

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