https://sip-academy.com/

Query Metrics

20 Database Queries
18 Different statements
33.78 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
8.62 ms
(25.53%)
3
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.prix AS prix_3, t0.description AS description_4, t0.contenu AS contenu_5, t0.affiche AS affiche_6, t0.duree AS duree_7, t0.slug AS slug_8, t0.texttt AS texttt_9, t0.totalinscrit AS totalinscrit_10, t0.nblike AS nblike_11, t0.nbavis AS nbavis_12, t0.niveau AS niveau_13, t0.categorie AS categorie_14, t0.nbheure AS nbheure_15, t0.desccourt AS desccourt_16, t0.photofront AS photofront_17, t0.is_populaire AS is_populaire_18, t0.planification_id AS planification_id_19, t0.formateur_id AS formateur_id_20 FROM formation t0 INNER JOIN offres_formation ON t0.id = offres_formation.formation_id WHERE offres_formation.offres_id = ?
Parameters:
[
  1
]
8.03 ms
(23.78%)
1
SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.date AS date_2, a0_.image AS image_3, a0_.imagedetails AS imagedetails_4, a0_.description AS description_5, a0_.desccourt AS desccourt_6, a0_.nbvue AS nbvue_7, a0_.nbcommentaire AS nbcommentaire_8, a0_.slug AS slug_9, a0_.type AS type_10 FROM actualite a0_ WHERE a0_.type IN (?, ?) ORDER BY a0_.id DESC
Parameters:
[
  "externe"
  "mixte"
]
3.06 ms
(9.07%)
1
SELECT e0_.id AS id_0, e0_.image AS image_1, e0_.titre AS titre_2, e0_.descriptionshort AS descriptionshort_3, e0_.description AS description_4, e0_.adresse AS adresse_5, e0_.starttime AS starttime_6, e0_.endtime AS endtime_7, e0_.date AS date_8, e0_.imgdetail AS imgdetail_9, e0_.mode AS mode_10, e0_.slug AS slug_11, e0_.liendrive AS liendrive_12, e0_.type AS type_13, e0_.prixpromo AS prixpromo_14, e0_.certeficatvierge AS certeficatvierge_15, e0_.is_archive AS is_archive_16, e0_.imgprog AS imgprog_17, e0_.liengithub AS liengithub_18, e0_.lienprog AS lienprog_19, e0_.discord AS discord_20, e0_.formation_id AS formation_id_21, e0_.formateur_id AS formateur_id_22 FROM evenement e0_ WHERE e0_.type = ? AND e0_.is_archive = ? AND e0_.endtime >= ? ORDER BY e0_.id DESC
Parameters:
[
  "Ordinaire"
  0
  "2026-06-02 18:26:50"
]
2.39 ms
(7.07%)
1
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.adresse AS adresse_4, u0_.phone AS phone_5, u0_.options AS options_6, u0_.logo AS logo_7, u0_.nom AS nom_8, u0_.prenom AS prenom_9, u0_.phone1 AS phone1_10, u0_.fb AS fb_11, u0_.linkedin AS linkedin_12, u0_.biographie AS biographie_13, u0_.cv AS cv_14, u0_.poste AS poste_15, u0_.pays AS pays_16, u0_.type AS type_17, u0_.responsable AS responsable_18, u0_.siteweb AS siteweb_19, u0_.github AS github_20, u0_.twitter AS twitter_21, u0_.vue AS vue_22, u0_.date AS date_23, u0_.vu AS vu_24, u0_.ipadress AS ipadress_25, u0_.is_active AS is_active_26, u0_.nomsociete AS nomsociete_27, u0_.adressesociete AS adressesociete_28, u0_.matricule AS matricule_29 FROM user u0_ WHERE u0_.roles LIKE ?
Parameters:
[
  "%"ROLE_COACH"%"
]
1.48 ms
(4.39%)
1
SELECT t0.id AS id_1, t0.etoile AS etoile_2, t0.commentaire AS commentaire_3, t0.description AS description_4, t0.image AS image_5, t0.profession AS profession_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.poste AS poste_9, t0.pays AS pays_10 FROM temoignage t0
Parameters:
[]
1.47 ms
(4.36%)
1
SELECT t0.id AS id_1, t0.formation AS formation_2, t0.inscrit AS inscrit_3, t0.formateur AS formateur_4, t0.pays AS pays_5 FROM statistique t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
1.20 ms
(3.54%)
1
SELECT *  FROM `formation` LIMIT 3;
Parameters:
[]
0.90 ms
(2.68%)
1
SELECT t0.id AS id_1, t0.service AS service_2, t0.descservice AS descservice_3, t0.descteam AS descteam_4, t0.logo AS logo_5, t0.lienfb AS lienfb_6, t0.lieninsta AS lieninsta_7, t0.lienyoutube AS lienyoutube_8, t0.lienlikedin AS lienlikedin_9, t0.contact AS contact_10, t0.map AS map_11, t0.icon AS icon_12, t0.description1 AS description1_13, t0.description2 AS description2_14, t0.temoinage AS temoinage_15, t0.texttemoigbage AS texttemoigbage_16, t0.liengit AS liengit_17, t0.footer1 AS footer1_18, t0.footer2 AS footer2_19, t0.titrestat AS titrestat_20, t0.descstat AS descstat_21, t0.descsousstat AS descsousstat_22, t0.adresse AS adresse_23, t0.numero AS numero_24, t0.imageapropos AS imageapropos_25, t0.favicon AS favicon_26, t0.nbrformation AS nbrformation_27, t0.formateurs AS formateurs_28, t0.membres AS membres_29, t0.pays AS pays_30, t0.logofooter AS logofooter_31, t0.nbmessage AS nbmessage_32, t0.whatsapp AS whatsapp_33, t0.tva AS tva_34, t0.nbip AS nbip_35 FROM setting t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
0.77 ms
(2.29%)
1
SELECT * FROM `video` ORDER BY id DESC LIMIT 4
Parameters:
[]
0.77 ms
(2.27%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.prix AS prix_3, t0.option1 AS option1_4, t0.option2 AS option2_5, t0.option3 AS option3_6, t0.option4 AS option4_7, t0.option5 AS option5_8, t0.duree AS duree_9, t0.dateexp AS dateexp_10, t0.affiche AS affiche_11, t0.description AS description_12, t0.slug AS slug_13, t0.imagefront AS imagefront_14, t0.valeurreduction AS valeurreduction_15 FROM offres t0
Parameters:
[]
0.75 ms
(2.23%)
1
SELECT t0.id AS id_1, t0.howitworks AS howitworks_2, t0.description AS description_3, t0.numero AS numero_4, t0.nom AS nom_5, t0.paragraphe AS paragraphe_6, t0.image AS image_7 FROM service t0
Parameters:
[]
0.73 ms
(2.16%)
1
SELECT f0_.id AS id_0, f0_.titre AS titre_1, f0_.prix AS prix_2, f0_.description AS description_3, f0_.contenu AS contenu_4, f0_.affiche AS affiche_5, f0_.duree AS duree_6, f0_.slug AS slug_7, f0_.texttt AS texttt_8, f0_.totalinscrit AS totalinscrit_9, f0_.nblike AS nblike_10, f0_.nbavis AS nbavis_11, f0_.niveau AS niveau_12, f0_.categorie AS categorie_13, f0_.nbheure AS nbheure_14, f0_.desccourt AS desccourt_15, f0_.photofront AS photofront_16, f0_.is_populaire AS is_populaire_17, f0_.planification_id AS planification_id_18, f0_.formateur_id AS formateur_id_19 FROM formation f0_ WHERE f0_.is_populaire = ? ORDER BY f0_.id DESC LIMIT 3
Parameters:
[
  1
]
0.72 ms
(2.12%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3 FROM sponsors t0
Parameters:
[]
0.71 ms
(2.09%)
1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3 FROM categorie_elearning t0
Parameters:
[]
0.63 ms
(1.86%)
1
SELECT t0.id AS id_1, t0.image1 AS image1_2, t0.date AS date_3, t0.description AS description_4, t0.titre AS titre_5 FROM gallery t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
0.60 ms
(1.78%)
1
SELECT t0.id AS id_1, t0.image AS image_2, t0.titre AS titre_3, t0.description AS description_4, t0.lienboutou AS lienboutou_5, t0.date AS date_6 FROM banniere t0
Parameters:
[]
0.49 ms
(1.46%)
1
SELECT t0.id AS id_1, t0.nomprenom AS nomprenom_2, t0.proffesion AS proffesion_3, t0.image AS image_4 FROM team t0
Parameters:
[]
0.45 ms
(1.32%)
1
SELECT t0.id AS id_1, t0.image AS image_2, t0.nom AS nom_3, t0.adresse AS adresse_4 FROM partners 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\Actualite No errors.
App\Entity\Trace No errors.
App\Entity\Evenement No errors.
App\Entity\Formation No errors.
App\Entity\User No errors.
App\Entity\InscritSession No errors.
App\Entity\Reglement No errors.
App\Entity\VirtualClassroom No errors.
App\Entity\Reclamation No errors.
App\Entity\Evaluation No errors.
App\Entity\Utilisation No errors.
App\Entity\EmailSession No errors.
App\Entity\EmailStudent No errors.
App\Entity\NotificationSession No errors.
App\Entity\LotCoupon No errors.
App\Entity\Service No errors.
App\Entity\Banniere No errors.
App\Entity\Team No errors.
App\Entity\Temoignage No errors.
App\Entity\Gallery No errors.
App\Entity\Statistique No errors.
App\Entity\Setting No errors.
App\Entity\Sponsors No errors.
App\Entity\Partners No errors.
App\Entity\Planification No errors.
App\Entity\Section No errors.
App\Entity\Offres No errors.
App\Entity\Offresinscrit No errors.
App\Entity\Voucher No errors.
App\Entity\Diplome No errors.
App\Entity\Certificat No errors.
App\Entity\Experience No errors.
App\Entity\Messageinscrit No errors.
App\Entity\Reponsereclamation
  • The mappings App\Entity\Reponsereclamation#expediteur and App\Entity\User#reponsereclamations are inconsistent with each other.
App\Entity\Reponsemessage
  • The mappings App\Entity\Reponsemessage#expediteur and App\Entity\User#reponsemessages are inconsistent with each other.
App\Entity\Demmandeformation No errors.
App\Entity\Demandeprofil No errors.
App\Entity\ReponseDemandeFormation No errors.
App\Entity\Emailsadmin No errors.
App\Entity\TacheAssistant No errors.
App\Entity\Signature No errors.
App\Entity\Ipadresse No errors.
App\Entity\FormationElearning No errors.
App\Entity\Commande No errors.
App\Entity\EvaluationElearning No errors.
App\Entity\CommentElearning No errors.
App\Entity\ChatFormation No errors.
App\Entity\Coupon No errors.
App\Entity\CategorieElearning No errors.