Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

2.02 ms Query time

3 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	1.17 ms	SELECT t0.id AS id_1, t0.id_user AS id_user_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.email AS email_5, t0.type AS type_6, t0.gsm AS gsm_7, t0.username AS username_8, t0.gsm2 AS gsm2_9, t0.permission_appel AS permission_appel_10, t0.categorie AS categorie_11, t0.last_access AS last_access_12, t0.dateModif AS dateModif_13, t0.direction AS direction_14, t0.firstAccessSpeexx AS firstAccessSpeexx_15, t0.lastAccessSpeexx AS lastAccessSpeexx_16, t0.timePromo1 AS timePromo1_17, t0.profil AS profil_18, t0.testOral AS testOral_19, t0.poste AS poste_20, t0.password AS password_21, t0.noteOral AS noteOral_22, t0.date_permission_appel AS date_permission_appel_23, t0.raison_permission_appel AS raison_permission_appel_24, t0.priority AS priority_25, t0.creneau AS creneau_26, t0.fonction AS fonction_27, t0.qualification_webi AS qualification_webi_28, t0.id_projet AS id_projet_29 FROM apprenant t0 WHERE t0.id = ? Parameters: [`"80091"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.id_user AS id_user_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.email AS email_5, t0.type AS type_6, t0.gsm AS gsm_7, t0.username AS username_8, t0.gsm2 AS gsm2_9, t0.permission_appel AS permission_appel_10, t0.categorie AS categorie_11, t0.last_access AS last_access_12, t0.dateModif AS dateModif_13, t0.direction AS direction_14, t0.firstAccessSpeexx AS firstAccessSpeexx_15, t0.lastAccessSpeexx AS lastAccessSpeexx_16, t0.timePromo1 AS timePromo1_17, t0.profil AS profil_18, t0.testOral AS testOral_19, t0.poste AS poste_20, t0.password AS password_21, t0.noteOral AS noteOral_22, t0.date_permission_appel AS date_permission_appel_23, t0.raison_permission_appel AS raison_permission_appel_24, t0.priority AS priority_25, t0.creneau AS creneau_26, t0.fonction AS fonction_27, t0.qualification_webi AS qualification_webi_28, t0.id_projet AS id_projet_29 FROM apprenant t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.id_user AS id_user_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.email AS email_5, t0.type AS type_6, t0.gsm AS gsm_7, t0.username AS username_8, t0.gsm2 AS gsm2_9, t0.permission_appel AS permission_appel_10, t0.categorie AS categorie_11, t0.last_access AS last_access_12, t0.dateModif AS dateModif_13, t0.direction AS direction_14, t0.firstAccessSpeexx AS firstAccessSpeexx_15, t0.lastAccessSpeexx AS lastAccessSpeexx_16, t0.timePromo1 AS timePromo1_17, t0.profil AS profil_18, t0.testOral AS testOral_19, t0.poste AS poste_20, t0.password AS password_21, t0.noteOral AS noteOral_22, t0.date_permission_appel AS date_permission_appel_23, t0.raison_permission_appel AS raison_permission_appel_24, t0.priority AS priority_25, t0.creneau AS creneau_26, t0.fonction AS fonction_27, t0.qualification_webi AS qualification_webi_28, t0.id_projet AS id_projet_29 FROM apprenant t0 WHERE t0.id = '80091';
2	0.85 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.nom AS nom_3, t0.description AS description_4, t0.DateDebut AS DateDebut_5, t0.DateFin AS DateFin_6, t0.progression AS progression_7, t0.objectif AS objectif_8, t0.tentative AS tentative_9, t0.archive AS archive_10, t0.DateFinReelle AS DateFinReelle_11, t0.DateCreation AS DateCreation_12, t0.state AS state_13, t0.couche AS couche_14, t0.statut AS statut_15, t0.force_vip AS force_vip_16, t0.id_projet AS id_projet_17, t0.createur AS createur_18, t0.id_cours AS id_cours_19 FROM compagne t0 WHERE t0.id = ? Parameters: [`"784"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.nom AS nom_3, t0.description AS description_4, t0.DateDebut AS DateDebut_5, t0.DateFin AS DateFin_6, t0.progression AS progression_7, t0.objectif AS objectif_8, t0.tentative AS tentative_9, t0.archive AS archive_10, t0.DateFinReelle AS DateFinReelle_11, t0.DateCreation AS DateCreation_12, t0.state AS state_13, t0.couche AS couche_14, t0.statut AS statut_15, t0.force_vip AS force_vip_16, t0.id_projet AS id_projet_17, t0.createur AS createur_18, t0.id_cours AS id_cours_19 FROM compagne t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.type AS type_2, t0.nom AS nom_3, t0.description AS description_4, t0.DateDebut AS DateDebut_5, t0.DateFin AS DateFin_6, t0.progression AS progression_7, t0.objectif AS objectif_8, t0.tentative AS tentative_9, t0.archive AS archive_10, t0.DateFinReelle AS DateFinReelle_11, t0.DateCreation AS DateCreation_12, t0.state AS state_13, t0.couche AS couche_14, t0.statut AS statut_15, t0.force_vip AS force_vip_16, t0.id_projet AS id_projet_17, t0.createur AS createur_18, t0.id_cours AS id_cours_19 FROM compagne t0 WHERE t0.id = '784';

#▲

Time

Info

1.17 ms

SELECT t0.id AS id_1, t0.id_user AS id_user_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.email AS email_5, t0.type AS type_6, t0.gsm AS gsm_7, t0.username AS username_8, t0.gsm2 AS gsm2_9, t0.permission_appel AS permission_appel_10, t0.categorie AS categorie_11, t0.last_access AS last_access_12, t0.dateModif AS dateModif_13, t0.direction AS direction_14, t0.firstAccessSpeexx AS firstAccessSpeexx_15, t0.lastAccessSpeexx AS lastAccessSpeexx_16, t0.timePromo1 AS timePromo1_17, t0.profil AS profil_18, t0.testOral AS testOral_19, t0.poste AS poste_20, t0.password AS password_21, t0.noteOral AS noteOral_22, t0.date_permission_appel AS date_permission_appel_23, t0.raison_permission_appel AS raison_permission_appel_24, t0.priority AS priority_25, t0.creneau AS creneau_26, t0.fonction AS fonction_27, t0.qualification_webi AS qualification_webi_28, t0.id_projet AS id_projet_29 FROM apprenant t0 WHERE t0.id = ?

Parameters:

[
  "80091"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.id_user AS id_user_2,
  t0.firstname AS firstname_3,
  t0.lastname AS lastname_4,
  t0.email AS email_5,
  t0.type AS type_6,
  t0.gsm AS gsm_7,
  t0.username AS username_8,
  t0.gsm2 AS gsm2_9,
  t0.permission_appel AS permission_appel_10,
  t0.categorie AS categorie_11,
  t0.last_access AS last_access_12,
  t0.dateModif AS dateModif_13,
  t0.direction AS direction_14,
  t0.firstAccessSpeexx AS firstAccessSpeexx_15,
  t0.lastAccessSpeexx AS lastAccessSpeexx_16,
  t0.timePromo1 AS timePromo1_17,
  t0.profil AS profil_18,
  t0.testOral AS testOral_19,
  t0.poste AS poste_20,
  t0.password AS password_21,
  t0.noteOral AS noteOral_22,
  t0.date_permission_appel AS date_permission_appel_23,
  t0.raison_permission_appel AS raison_permission_appel_24,
  t0.priority AS priority_25,
  t0.creneau AS creneau_26,
  t0.fonction AS fonction_27,
  t0.qualification_webi AS qualification_webi_28,
  t0.id_projet AS id_projet_29
FROM
  apprenant t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.id_user AS id_user_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.email AS email_5, t0.type AS type_6, t0.gsm AS gsm_7, t0.username AS username_8, t0.gsm2 AS gsm2_9, t0.permission_appel AS permission_appel_10, t0.categorie AS categorie_11, t0.last_access AS last_access_12, t0.dateModif AS dateModif_13, t0.direction AS direction_14, t0.firstAccessSpeexx AS firstAccessSpeexx_15, t0.lastAccessSpeexx AS lastAccessSpeexx_16, t0.timePromo1 AS timePromo1_17, t0.profil AS profil_18, t0.testOral AS testOral_19, t0.poste AS poste_20, t0.password AS password_21, t0.noteOral AS noteOral_22, t0.date_permission_appel AS date_permission_appel_23, t0.raison_permission_appel AS raison_permission_appel_24, t0.priority AS priority_25, t0.creneau AS creneau_26, t0.fonction AS fonction_27, t0.qualification_webi AS qualification_webi_28, t0.id_projet AS id_projet_29 FROM apprenant t0 WHERE t0.id = '80091';

0.85 ms

SELECT t0.id AS id_1, t0.type AS type_2, t0.nom AS nom_3, t0.description AS description_4, t0.DateDebut AS DateDebut_5, t0.DateFin AS DateFin_6, t0.progression AS progression_7, t0.objectif AS objectif_8, t0.tentative AS tentative_9, t0.archive AS archive_10, t0.DateFinReelle AS DateFinReelle_11, t0.DateCreation AS DateCreation_12, t0.state AS state_13, t0.couche AS couche_14, t0.statut AS statut_15, t0.force_vip AS force_vip_16, t0.id_projet AS id_projet_17, t0.createur AS createur_18, t0.id_cours AS id_cours_19 FROM compagne t0 WHERE t0.id = ?

Parameters:

[
  "784"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.nom AS nom_3,
  t0.description AS description_4,
  t0.DateDebut AS DateDebut_5,
  t0.DateFin AS DateFin_6,
  t0.progression AS progression_7,
  t0.objectif AS objectif_8,
  t0.tentative AS tentative_9,
  t0.archive AS archive_10,
  t0.DateFinReelle AS DateFinReelle_11,
  t0.DateCreation AS DateCreation_12,
  t0.state AS state_13,
  t0.couche AS couche_14,
  t0.statut AS statut_15,
  t0.force_vip AS force_vip_16,
  t0.id_projet AS id_projet_17,
  t0.createur AS createur_18,
  t0.id_cours AS id_cours_19
FROM
  compagne t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.nom AS nom_3, t0.description AS description_4, t0.DateDebut AS DateDebut_5, t0.DateFin AS DateFin_6, t0.progression AS progression_7, t0.objectif AS objectif_8, t0.tentative AS tentative_9, t0.archive AS archive_10, t0.DateFinReelle AS DateFinReelle_11, t0.DateCreation AS DateCreation_12, t0.state AS state_13, t0.couche AS couche_14, t0.statut AS statut_15, t0.force_vip AS force_vip_16, t0.id_projet AS id_projet_17, t0.createur AS createur_18, t0.id_cours AS id_cours_19 FROM compagne t0 WHERE t0.id = '784';

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\Apprenant	No errors.
App\Entity\Projet	The mappings App\Entity\Projet#idChargeProjet and App\Entity\Utilisateur#projets are inconsistent with each other. The field App\Entity\Projet#courses is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Cours#projets does not contain the required 'mappedBy="courses"' attribute.
App\Entity\Appel	No errors.
App\Entity\Inscription	No errors.
App\Entity\Message	No errors.
App\Entity\Rdv	The mappings App\Entity\Rdv#agentRecepteur and App\Entity\Utilisateur#rdvs are inconsistent with each other.
App\Entity\Seance	No errors.
App\Entity\Tache	No errors.
App\Entity\Incident	No errors.
App\Entity\Compagne	No errors.
App\Entity\Utilisateur	No errors.
App\Entity\Cours	The field App\Entity\Cours#projets is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Projet#courses does not contain the required 'mappedBy="projets"' attribute.
App\Entity\CampagneCouche	No errors.
App\Entity\Priorite	No errors.
App\Entity\AppelSujet	No errors.

Symfony Profiler

http://ideodash.com/crm/historiser-appel-boucle/80091/784

Configuration Settings

Theme