Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.64 ms
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 DESC LIMIT 20
Parameters:
[]
2 2.43 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 congre c1_ ON p0_.evenement_id_id = c1_.id WHERE p0_.id IN (?) ORDER BY p0_.evenement_id_id DESC
Parameters:
[
  [
    1942
    1941
    1940
    1939
    1938
    1937
    1936
    1935
    1934
    1933
    1932
    1931
    1930
    1929
    1928
    1927
    1926
    1925
    1924
    1923
  ]
]
3 1.17 ms
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM payement_method p0_ LEFT JOIN congre c1_ ON p0_.evenement_id_id = c1_.id
Parameters:
[]
4 0.45 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:
[
  22
]

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.