https://astp.tn/congre/19/12-%C3%A9me-congr%C3%A9s-de-l%27ASTP-:-LOMBALGIE/

Query Metrics

7 Database Queries
7 Different statements
4.57 ms Query time
4 Invalid entities

Queries

Group similar statements

# Time Info
1 2.10 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:
[
  "19"
]
2 0.64 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.carousel_congre_id AS carousel_congre_id_3, t0.carousel_congre_id AS carousel_congre_id_4 FROM carousel t0 WHERE t0.carousel_congre_id = ?
Parameters:
[
  "19"
]
3 0.28 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.evenement_congre_id AS evenement_congre_id_3 FROM attachment_congre t0 WHERE t0.id = ?
Parameters:
[
  19
]
4 0.64 ms
SELECT t0.id AS id_1, t0.etape_new_id AS etape_new_id_2, t0.time_etape AS time_etape_3, t0.titre_etape AS titre_etape_4, t0.description_etape AS description_etape_5, t0.posetion_etape AS posetion_etape_6, t0.etape_new_id AS etape_new_id_7 FROM etape t0 WHERE t0.etape_new_id = ?
Parameters:
[
  19
]
5 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.fonctionalite AS fonctionalite_4, t0.evenement_speaker_id AS evenement_speaker_id_5, t0.evenement_speaker_id AS evenement_speaker_id_6 FROM speakers t0 WHERE t0.evenement_speaker_id = ?
Parameters:
[
  "19"
]
6 0.21 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.evenement_sponsored_id AS evenement_sponsored_id_3, t0.evenement_sponsored_id AS evenement_sponsored_id_4 FROM sponsored t0 WHERE t0.evenement_sponsored_id = ?
Parameters:
[
  "19"
]
7 0.34 ms
SELECT t0.id AS id_1, t0.evenementprix_id AS evenementprix_id_2, t0.name AS name_3, t0.category AS category_4, t0.prix AS prix_5, t0.evenementprix_id AS evenementprix_id_6 FROM prix_variable_congre t0
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\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\PayementMethod
  • The association App\Entity\PayementMethod#evenementId refers to the inverse side field App\Entity\Congre#evenementIdCongre which does not exist.
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.
App\Entity\Carousel
  • The mappings App\Entity\Carousel#carouselCongre and App\Entity\Congre#carouselCongreAffiche are inconsistent with each other.