Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

2.02 ms Query time

6 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
1.17 ms (57.97%)	1	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 (42.03%)	1	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▼

Count

Info

1.17 ms
(57.97%)

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
(42.03%)

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.
App\Entity\Communication	The mappings App\Entity\Communication#chargeProjet and App\Entity\Utilisateur#communications are inconsistent with each other.
App\Entity\Evolution	No errors.
App\Entity\StatProjet	No errors.
App\Entity\Client	No errors.
App\Entity\CustomStatProjet	No errors.
App\Entity\Formation	No errors.
App\Entity\AppelStatut	No errors.
App\Entity\Actualite	No errors.
App\Entity\Demande	The mappings App\Entity\Demande#developpeur and App\Entity\Utilisateur#demandes are inconsistent with each other. The mappings App\Entity\Demande#departement and App\Entity\Departement#demandes are inconsistent with each other.
App\Entity\Suivi	No errors.
App\Entity\UcmCdr	No errors.
App\Entity\Departement	The association App\Entity\Departement#demandes refers to the owning side field App\Entity\Demande#id_departement which does not exist.

Symfony Profiler

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

Configuration Settings

Theme