https://www.urotunisia.com/seo/Front/16

Query Metrics

5 Database Queries
5 Different statements
9.06 ms Query time
4 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 4.97 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.label AS label_3, t0.label_en AS label_en_4, t0.type_congres AS type_congres_5, t0.partners AS partners_6, t0.lien_pdf AS lien_pdf_7, t0.date_debut AS date_debut_8, t0.date_fin AS date_fin_9, t0.date_soumission AS date_soumission_10, t0.date_notification AS date_notification_11, t0.date_poster AS date_poster_12, t0.prgrm_scientifique AS prgrm_scientifique_13, t0.sponsor AS sponsor_14, t0.speakers AS speakers_15, t0.mot_du_president AS mot_du_president_16, t0.info_general AS info_general_17, t0.registration AS registration_18, t0.lieu AS lieu_19, t0.inscription AS inscription_20 FROM congres t0 ORDER BY t0.id DESC
Parameters:
[]
2 1.51 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.titre AS titre_3, t0.image AS image_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.location AS location_7, t0.location_en AS location_en_8, t0.content AS content_9, t0.content_en AS content_en_10, t0.categorie AS categorie_11, t0.pdf AS pdf_12, t0.lien AS lien_13, t0.inscription AS inscription_14 FROM event t0 WHERE t0.categorie = ? ORDER BY t0.start_date ASC
Parameters:
[
  "national"
]
3 0.97 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.nom_president AS nom_president_3, t0.prenom_president AS prenom_president_4, t0.icone_svg AS icone_svg_5, t0.icone_fontawesome AS icone_fontawesome_6, t0.photo AS photo_7, t0.title AS title_8 FROM member_comite_categorie t0
Parameters:
[]
4 0.87 ms
SELECT YEAR(c0_.date_debut) AS sclr_0, c0_.id AS id_1, c0_.label AS label_2 FROM congres c0_ WHERE YEAR(c0_.date_debut) <= YEAR(CURRENT_DATE) ORDER BY YEAR(c0_.date_debut) DESC LIMIT 10
Parameters:
[]
5 0.74 ms
SELECT t0.id AS id_1, t0.page AS page_2, t0.title AS title_3, t0.titre AS titre_4, t0.metatitle AS metatitle_5, t0.metatitre AS metatitre_6, t0.metadescription AS metadescription_7, t0.metadescription_en AS metadescription_en_8 FROM seo t0 WHERE t0.id = ?
Parameters:
[
  "16"
]

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\Congres
  • The mappings App\Entity\Congres#abstractts and App\Entity\Abstractt#congres are inconsistent with each other.
  • The association App\Entity\Congres#presenceCongres refers to the owning side field App\Entity\PresenceCongres#congres which does not exist.
App\Entity\MemberComiteCategorie No errors.
App\Entity\Event No errors.
App\Entity\Abstractt
  • The association App\Entity\Abstractt#congres refers to the inverse side field App\Entity\Congres#congres which does not exist.
  • The association App\Entity\Abstractt#user refers to the inverse side field App\Entity\AbstractInscription#AbstractInscription which does not exist.
App\Entity\Reviewers No errors.
App\Entity\PresenceCongres
  • The association App\Entity\PresenceCongres#Inscription refers to the inverse side field App\Entity\Inscription#presenceCongres which does not exist.
App\Entity\Participation No errors.
App\Entity\PackCongres
  • The association App\Entity\PackCongres#commandes refers to the owning side field App\Entity\Commande#packCogres which does not exist.
App\Entity\MemberComite No errors.
App\Entity\Seo No errors.