https://www.sip-projects-services.com/detailsCoach/7

Query Metrics

17 Database Queries
16 Different statements
8.58 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.76 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.adresse AS adresse_5, t0.phone AS phone_6, t0.options AS options_7, t0.logo AS logo_8, t0.nom AS nom_9, t0.prenom AS prenom_10, t0.phone1 AS phone1_11, t0.fb AS fb_12, t0.linkedin AS linkedin_13, t0.biographie AS biographie_14, t0.cv AS cv_15, t0.poste AS poste_16, t0.pays AS pays_17, t0.type AS type_18, t0.responsable AS responsable_19, t0.siteweb AS siteweb_20, t0.github AS github_21, t0.twitter AS twitter_22, t0.vue AS vue_23, t0.date AS date_24, t0.vu AS vu_25, t0.ipadress AS ipadress_26, t0.is_active AS is_active_27, t0.nomsociete AS nomsociete_28, t0.adressesociete AS adressesociete_29, t0.matricule AS matricule_30 FROM user t0 WHERE t0.id = ?
Parameters:
[
  "7"
]
2 0.96 ms
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"%"
]
3 0.33 ms
SELECT *  FROM `video` LIMIT 4;
Parameters:
[]
4 1.25 ms
SELECT *  FROM `formation` LIMIT 3;
Parameters:
[]
5 0.28 ms
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:
[]
6 0.26 ms
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:
[]
7 1.19 ms
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
Parameters:
[]
8 0.27 ms
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:
[]
9 0.29 ms
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:
[]
10 0.32 ms
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
]
11 0.29 ms
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
]
12 0.39 ms
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
]
13 0.27 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3 FROM sponsors t0
Parameters:
[]
14 0.26 ms
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:
[]
15 0.32 ms
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:
[]
16 0.84 ms
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"%"
]
17 0.31 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3 FROM categorie_elearning 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\User No errors.
App\Entity\Diplome No errors.
App\Entity\Certificat No errors.
App\Entity\Experience No errors.
App\Entity\Formation No errors.
App\Entity\InscritSession No errors.
App\Entity\Messageinscrit No errors.
App\Entity\Reclamation No errors.
App\Entity\Evaluation No errors.
App\Entity\Evenement No errors.
App\Entity\VirtualClassroom No errors.
App\Entity\Reponsereclamation
  • The mappings App\Entity\Reponsereclamation#expediteur and App\Entity\User#reponsereclamations are inconsistent with each other.
App\Entity\Offresinscrit No errors.
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\Trace No errors.
App\Entity\EmailStudent 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\QuizReponse No errors.
App\Entity\Quiz No errors.
App\Entity\PDFAccessLog No errors.
App\Entity\ChatSession No errors.
App\Entity\Service No errors.
App\Entity\Banniere No errors.
App\Entity\Planification No errors.
App\Entity\Section No errors.
App\Entity\Offres 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\Voucher No errors.
App\Entity\CategorieElearning No errors.