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

Query Metrics

9 Database Queries
9 Different statements
16.27 ms Query time
4 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 1.95 ms
SELECT v0_.id AS id_0, v0_.titre AS titre_1, v0_.url_video AS url_video_2, v0_.url_image AS url_image_3, v0_.video_educative_patient AS video_educative_patient_4 FROM video v0_ ORDER BY v0_.id DESC LIMIT 1000
Parameters:
[]
2 4.14 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
Parameters:
[]
3 1.98 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"
]
4 0.83 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 DESC
Parameters:
[
  "international"
]
5 1.52 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.poste_fr AS poste_fr_4, t0.facebook AS facebook_5, t0.twitter AS twitter_6, t0.linkedin AS linkedin_7, t0.instagram AS instagram_8, t0.photo AS photo_9, t0.poste_en AS poste_en_10 FROM comite t0
Parameters:
[]
6 1.42 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:
[]
7 1.45 ms
SELECT t0.id AS id_1, t0.introduction AS introduction_2, t0.link AS link_3, t0.link2 AS link2_4, t0.text_btn2 AS text_btn2_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.status AS status_8, t0.image AS image_9, t0.label AS label_10, t0.language AS language_11 FROM slides t0 WHERE t0.language = ?
Parameters:
[
  "en"
]
8 1.37 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.categorie_memnbre_comite_id AS categorie_memnbre_comite_id_4 FROM member_comite t0
Parameters:
[]
9 1.62 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:
[
  "1"
]

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\Event No errors.
App\Entity\Slides No errors.
App\Entity\Video No errors.
App\Entity\Comite No errors.
App\Entity\MemberComiteCategorie No errors.
App\Entity\MemberComite 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\Seo No errors.