Query Metrics
17
Database Queries
16
Different statements
9.83 ms
Query time
2
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.75 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:
[
"5453"
]
|
| 2 | 1.07 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.29 ms |
SELECT * FROM `video` LIMIT 4;
Parameters:
[] |
| 4 | 1.67 ms |
SELECT * FROM `formation` LIMIT 3;
Parameters:
[] |
| 5 | 0.33 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.32 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.92 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.33 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.27 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.28 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.35 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.33 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.87 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.24 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.