https://astp.tn/evenement/4/Symposium-avec-paiment/

Query Metrics

5 Database Queries
5 Different statements
2.88 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 1.85 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.category AS category_3, t0.desplay AS desplay_4, t0.description AS description_5, t0.image_principale AS image_principale_6, t0.date_evenement AS date_evenement_7, t0.evenementevent_id AS evenementevent_id_8 FROM evenement_avenir t0 WHERE t0.category = ?
Parameters:
[
  "Symposium avec paiment"
]
2 0.33 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.category AS category_3, t0.desplay AS desplay_4, t0.description AS description_5, t0.image_principale AS image_principale_6, t0.date_evenement AS date_evenement_7, t0.evenementevent_id AS evenementevent_id_8 FROM evenement_avenir t0 WHERE t0.id = ?
Parameters:
[
  20
]
3 0.26 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.desplay = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  1
]
4 0.18 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.category AS category_3, t0.desplay AS desplay_4, t0.description AS description_5, t0.image_principale AS image_principale_6, t0.date_evenement AS date_evenement_7, t0.evenementevent_id AS evenementevent_id_8 FROM evenement_avenir t0 WHERE t0.desplay = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  1
]
5 0.26 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.evenement_id AS evenement_id_3, t0.evenement_id AS evenement_id_4 FROM attachment t0 WHERE t0.evenement_id = ?
Parameters:
[
  20
]

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\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\Attachment No errors.
App\Entity\PrixVariable No 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\Document 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.