Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

2 Different statements

71.72 ms Query time

20 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
68.59 ms (95.63%)	1	SELECT t0.id AS id_1, t0.username_user AS username_user_2, t0.nom_user AS nom_user_3, t0.prenoms_user AS prenoms_user_4, t0.email_user AS email_user_5, t0.tel1_user AS tel1_user_6, t0.tel2_user AS tel2_user_7, t0.bp AS bp_8, t0.adresse_user AS adresse_user_9, t0.etat_user AS etat_user_10, t0.attempt_user AS attempt_user_11, t0.password_user AS password_user_12, t0.c_password_user AS c_password_user_13, t0.salt_user AS salt_user_14, t0.etat_connecte AS etat_connecte_15, t0.adresse_ip_user AS adresse_ip_user_16, t0.sexe_user AS sexe_user_17, t0.date_ajout_user AS date_ajout_user_18, t0.date_edit_user AS date_edit_user_19, t0.loss_password_url_user AS loss_password_url_user_20, t0.date_loss_password_user AS date_loss_password_user_21, t0.date_naissance AS date_naissance_22, t0.date_synchronisation AS date_synchronisation_23, t0.type_prod_user AS type_prod_user_24, t0.si_chef AS si_chef_25, t0.code_genere AS code_genere_26, t0.site_web AS site_web_27, t0.cni AS cni_28, t0.cout AS cout_29, t0.commission AS commission_30, t0.type_utilisateur AS type_utilisateur_31, t0.roles AS roles_32, t0.profil_id AS profil_id_33, t0.ville_id AS ville_id_34, t0.entrepot_id AS entrepot_id_35, t0.caisse_id AS caisse_id_36, t0.abonne_id AS abonne_id_37 FROM utilisateur t0 WHERE t0.username_user = ? LIMIT 1 Parameters: [`"k.akoni"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.username_user AS username_user_2, t0.nom_user AS nom_user_3, t0.prenoms_user AS prenoms_user_4, t0.email_user AS email_user_5, t0.tel1_user AS tel1_user_6, t0.tel2_user AS tel2_user_7, t0.bp AS bp_8, t0.adresse_user AS adresse_user_9, t0.etat_user AS etat_user_10, t0.attempt_user AS attempt_user_11, t0.password_user AS password_user_12, t0.c_password_user AS c_password_user_13, t0.salt_user AS salt_user_14, t0.etat_connecte AS etat_connecte_15, t0.adresse_ip_user AS adresse_ip_user_16, t0.sexe_user AS sexe_user_17, t0.date_ajout_user AS date_ajout_user_18, t0.date_edit_user AS date_edit_user_19, t0.loss_password_url_user AS loss_password_url_user_20, t0.date_loss_password_user AS date_loss_password_user_21, t0.date_naissance AS date_naissance_22, t0.date_synchronisation AS date_synchronisation_23, t0.type_prod_user AS type_prod_user_24, t0.si_chef AS si_chef_25, t0.code_genere AS code_genere_26, t0.site_web AS site_web_27, t0.cni AS cni_28, t0.cout AS cout_29, t0.commission AS commission_30, t0.type_utilisateur AS type_utilisateur_31, t0.roles AS roles_32, t0.profil_id AS profil_id_33, t0.ville_id AS ville_id_34, t0.entrepot_id AS entrepot_id_35, t0.caisse_id AS caisse_id_36, t0.abonne_id AS abonne_id_37 FROM utilisateur t0 WHERE t0.username_user = ? LIMIT 1 SELECT t0.id AS id_1, t0.username_user AS username_user_2, t0.nom_user AS nom_user_3, t0.prenoms_user AS prenoms_user_4, t0.email_user AS email_user_5, t0.tel1_user AS tel1_user_6, t0.tel2_user AS tel2_user_7, t0.bp AS bp_8, t0.adresse_user AS adresse_user_9, t0.etat_user AS etat_user_10, t0.attempt_user AS attempt_user_11, t0.password_user AS password_user_12, t0.c_password_user AS c_password_user_13, t0.salt_user AS salt_user_14, t0.etat_connecte AS etat_connecte_15, t0.adresse_ip_user AS adresse_ip_user_16, t0.sexe_user AS sexe_user_17, t0.date_ajout_user AS date_ajout_user_18, t0.date_edit_user AS date_edit_user_19, t0.loss_password_url_user AS loss_password_url_user_20, t0.date_loss_password_user AS date_loss_password_user_21, t0.date_naissance AS date_naissance_22, t0.date_synchronisation AS date_synchronisation_23, t0.type_prod_user AS type_prod_user_24, t0.si_chef AS si_chef_25, t0.code_genere AS code_genere_26, t0.site_web AS site_web_27, t0.cni AS cni_28, t0.cout AS cout_29, t0.commission AS commission_30, t0.type_utilisateur AS type_utilisateur_31, t0.roles AS roles_32, t0.profil_id AS profil_id_33, t0.ville_id AS ville_id_34, t0.entrepot_id AS entrepot_id_35, t0.caisse_id AS caisse_id_36, t0.abonne_id AS abonne_id_37 FROM utilisateur t0 WHERE t0.username_user = 'k.akoni' LIMIT 1;
3.13 ms (4.37%)	2	SELECT t0.refresh_token AS refresh_token_1, t0.username AS username_2, t0.valid AS valid_3, t0.id AS id_4 FROM refresh_tokens t0 WHERE t0.refresh_token = ? LIMIT 1 Parameters: [`"53c1a93d96a58682b9c5894a8dbf419a0eeea14cf135100c3e103946109bfc4d6566967fd20f63548dbc82df31f93b25ffd9dee57f1bfd5c5d39c9facbd2a4fa"`] View formatted query View runnable query Explain query SELECT t0.refresh_token AS refresh_token_1, t0.username AS username_2, t0.valid AS valid_3, t0.id AS id_4 FROM refresh_tokens t0 WHERE t0.refresh_token = ? LIMIT 1 SELECT t0.refresh_token AS refresh_token_1, t0.username AS username_2, t0.valid AS valid_3, t0.id AS id_4 FROM refresh_tokens t0 WHERE t0.refresh_token = '53c1a93d96a58682b9c5894a8dbf419a0eeea14cf135100c3e103946109bfc4d6566967fd20f63548dbc82df31f93b25ffd9dee57f1bfd5c5d39c9facbd2a4fa' LIMIT 1;

Time▼

Count

Info

68.59 ms
(95.63%)

SELECT t0.id AS id_1, t0.username_user AS username_user_2, t0.nom_user AS nom_user_3, t0.prenoms_user AS prenoms_user_4, t0.email_user AS email_user_5, t0.tel1_user AS tel1_user_6, t0.tel2_user AS tel2_user_7, t0.bp AS bp_8, t0.adresse_user AS adresse_user_9, t0.etat_user AS etat_user_10, t0.attempt_user AS attempt_user_11, t0.password_user AS password_user_12, t0.c_password_user AS c_password_user_13, t0.salt_user AS salt_user_14, t0.etat_connecte AS etat_connecte_15, t0.adresse_ip_user AS adresse_ip_user_16, t0.sexe_user AS sexe_user_17, t0.date_ajout_user AS date_ajout_user_18, t0.date_edit_user AS date_edit_user_19, t0.loss_password_url_user AS loss_password_url_user_20, t0.date_loss_password_user AS date_loss_password_user_21, t0.date_naissance AS date_naissance_22, t0.date_synchronisation AS date_synchronisation_23, t0.type_prod_user AS type_prod_user_24, t0.si_chef AS si_chef_25, t0.code_genere AS code_genere_26, t0.site_web AS site_web_27, t0.cni AS cni_28, t0.cout AS cout_29, t0.commission AS commission_30, t0.type_utilisateur AS type_utilisateur_31, t0.roles AS roles_32, t0.profil_id AS profil_id_33, t0.ville_id AS ville_id_34, t0.entrepot_id AS entrepot_id_35, t0.caisse_id AS caisse_id_36, t0.abonne_id AS abonne_id_37 FROM utilisateur t0 WHERE t0.username_user = ? LIMIT 1

Parameters:

[
  "k.akoni"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.username_user AS username_user_2,
  t0.nom_user AS nom_user_3,
  t0.prenoms_user AS prenoms_user_4,
  t0.email_user AS email_user_5,
  t0.tel1_user AS tel1_user_6,
  t0.tel2_user AS tel2_user_7,
  t0.bp AS bp_8,
  t0.adresse_user AS adresse_user_9,
  t0.etat_user AS etat_user_10,
  t0.attempt_user AS attempt_user_11,
  t0.password_user AS password_user_12,
  t0.c_password_user AS c_password_user_13,
  t0.salt_user AS salt_user_14,
  t0.etat_connecte AS etat_connecte_15,
  t0.adresse_ip_user AS adresse_ip_user_16,
  t0.sexe_user AS sexe_user_17,
  t0.date_ajout_user AS date_ajout_user_18,
  t0.date_edit_user AS date_edit_user_19,
  t0.loss_password_url_user AS loss_password_url_user_20,
  t0.date_loss_password_user AS date_loss_password_user_21,
  t0.date_naissance AS date_naissance_22,
  t0.date_synchronisation AS date_synchronisation_23,
  t0.type_prod_user AS type_prod_user_24,
  t0.si_chef AS si_chef_25,
  t0.code_genere AS code_genere_26,
  t0.site_web AS site_web_27,
  t0.cni AS cni_28,
  t0.cout AS cout_29,
  t0.commission AS commission_30,
  t0.type_utilisateur AS type_utilisateur_31,
  t0.roles AS roles_32,
  t0.profil_id AS profil_id_33,
  t0.ville_id AS ville_id_34,
  t0.entrepot_id AS entrepot_id_35,
  t0.caisse_id AS caisse_id_36,
  t0.abonne_id AS abonne_id_37
FROM
  utilisateur t0
WHERE
  t0.username_user = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username_user AS username_user_2, t0.nom_user AS nom_user_3, t0.prenoms_user AS prenoms_user_4, t0.email_user AS email_user_5, t0.tel1_user AS tel1_user_6, t0.tel2_user AS tel2_user_7, t0.bp AS bp_8, t0.adresse_user AS adresse_user_9, t0.etat_user AS etat_user_10, t0.attempt_user AS attempt_user_11, t0.password_user AS password_user_12, t0.c_password_user AS c_password_user_13, t0.salt_user AS salt_user_14, t0.etat_connecte AS etat_connecte_15, t0.adresse_ip_user AS adresse_ip_user_16, t0.sexe_user AS sexe_user_17, t0.date_ajout_user AS date_ajout_user_18, t0.date_edit_user AS date_edit_user_19, t0.loss_password_url_user AS loss_password_url_user_20, t0.date_loss_password_user AS date_loss_password_user_21, t0.date_naissance AS date_naissance_22, t0.date_synchronisation AS date_synchronisation_23, t0.type_prod_user AS type_prod_user_24, t0.si_chef AS si_chef_25, t0.code_genere AS code_genere_26, t0.site_web AS site_web_27, t0.cni AS cni_28, t0.cout AS cout_29, t0.commission AS commission_30, t0.type_utilisateur AS type_utilisateur_31, t0.roles AS roles_32, t0.profil_id AS profil_id_33, t0.ville_id AS ville_id_34, t0.entrepot_id AS entrepot_id_35, t0.caisse_id AS caisse_id_36, t0.abonne_id AS abonne_id_37 FROM utilisateur t0 WHERE t0.username_user = 'k.akoni' LIMIT 1;

3.13 ms
(4.37%)

SELECT t0.refresh_token AS refresh_token_1, t0.username AS username_2, t0.valid AS valid_3, t0.id AS id_4 FROM refresh_tokens t0 WHERE t0.refresh_token = ? LIMIT 1

Parameters:

[
  "53c1a93d96a58682b9c5894a8dbf419a0eeea14cf135100c3e103946109bfc4d6566967fd20f63548dbc82df31f93b25ffd9dee57f1bfd5c5d39c9facbd2a4fa"
]

View formatted query View runnable query Explain query

SELECT
  t0.refresh_token AS refresh_token_1,
  t0.username AS username_2,
  t0.valid AS valid_3,
  t0.id AS id_4
FROM
  refresh_tokens t0
WHERE
  t0.refresh_token = ?
LIMIT
  1

SELECT t0.refresh_token AS refresh_token_1, t0.username AS username_2, t0.valid AS valid_3, t0.id AS id_4 FROM refresh_tokens t0 WHERE t0.refresh_token = '53c1a93d96a58682b9c5894a8dbf419a0eeea14cf135100c3e103946109bfc4d6566967fd20f63548dbc82df31f93b25ffd9dee57f1bfd5c5d39c9facbd2a4fa' LIMIT 1;

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
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Entity\RefreshToken	No errors.
App\Entity\user\Utilisateur	The mappings App\Entity\user\Utilisateur#producteurs and App\Entity\prod\Producteur#utilisateur are inconsistent with each other. The mappings App\Entity\user\Utilisateur#inspectionremplis and App\Entity\inspection\InspectionRempli#utilisateur are inconsistent with each other. The mappings App\Entity\user\Utilisateur#fournisseurs and App\Entity\stock\Fournisseur#utilisateur are inconsistent with each other. The association App\Entity\user\Utilisateur#caisse refers to the inverse side field App\Entity\stock\Caisse#utilisateurs which does not exist. The association App\Entity\user\Utilisateur#abonne refers to the inverse side field App\Entity\user\Abonne#utilisateurs which does not exist. The mappings App\Entity\user\Utilisateur#evenements and App\Entity\prod\Evenement#utilisateur are inconsistent with each other.
App\Entity\user\Profil	The association App\Entity\user\Profil#abonne refers to the inverse side field App\Entity\user\Abonne#profils which does not exist.
App\Entity\stock\Ville	The mappings App\Entity\stock\Ville#zoneabonnes and App\Entity\stock\ZoneAbonne#ville are inconsistent with each other. The mappings App\Entity\stock\Ville#fichier and App\Entity\stock\Fichier#ville are inconsistent with each other.
App\Entity\stock\Entrepot	The association App\Entity\stock\Entrepot#abonne refers to the inverse side field App\Entity\user\Abonne#entrepots which does not exist.
App\Entity\stock\Caisse	The association App\Entity\stock\Caisse#abonne refers to the inverse side field App\Entity\user\Abonne#caisses which does not exist. The association App\Entity\stock\Caisse#partenaire refers to the inverse side field App\Entity\user\Partenaire#abonnes which does not exist.
App\Entity\user\Abonne	The association App\Entity\user\Abonne#template refers to the inverse side field App\Entity\cms\Template#abonnes which does not exist. The association App\Entity\user\Abonne#partenaire refers to the inverse side field App\Entity\user\Partenaire#abonnes which does not exist. The association App\Entity\user\Abonne#pays refers to the inverse side field App\Entity\stock\Pays#abonnes which does not exist.
App\Entity\user\Connexion	No errors.
App\Entity\stock\Commande	The mappings App\Entity\stock\Commande#infoLivrers and App\Entity\stock\InfoLivrer#commande are inconsistent with each other. The association App\Entity\stock\Commande#opportunite refers to the inverse side field App\Entity\stock\Opportunite#commandes which does not exist. The association App\Entity\stock\Commande#tableMange refers to the inverse side field App\Entity\stock\TableMange#commandes which does not exist. The association App\Entity\stock\Commande#abonne refers to the inverse side field App\Entity\user\Abonne#commandes which does not exist.
App\Entity\stock\Operation	The association App\Entity\stock\Operation#devise refers to the inverse side field App\Entity\stock\Devise#operations which does not exist. The association App\Entity\stock\Operation#produit refers to the inverse side field App\Entity\stock\Produit#operations which does not exist. The association App\Entity\stock\Operation#prestataire refers to the inverse side field App\Entity\stock\Prestataire#operations which does not exist. The association App\Entity\stock\Operation#fournisseur refers to the inverse side field App\Entity\stock\Fournisseur#operations which does not exist. The association App\Entity\stock\Operation#client refers to the inverse side field App\Entity\client\Client#operations which does not exist. The association App\Entity\stock\Operation#typeoperation refers to the inverse side field App\Entity\stock\TypeOperation#operationcaisses which does not exist. The association App\Entity\stock\Operation#plancomptable refers to the inverse side field App\Entity\stock\PlanComptable#operationcaisses which does not exist. The association App\Entity\stock\Operation#producteur refers to the inverse side field App\Entity\prod\Producteur#operations which does not exist. The association App\Entity\stock\Operation#abonne refers to the inverse side field App\Entity\user\Abonne#operations which does not exist. The association App\Entity\stock\Operation#partenaire refers to the inverse side field App\Entity\user\Partenaire#abonnes which does not exist. The association App\Entity\stock\Operation#tacheproduitetapecroissance refers to the inverse side field App\Entity\prod\TacheProduitEtapeCroissance#operations which does not exist. The association App\Entity\stock\Operation#activite refers to the inverse side field App\Entity\asso\Activite#operations which does not exist. The association App\Entity\stock\Operation#surfaceannee refers to the inverse side field App\Entity\prod\SurfaceAnnee#operations which does not exist.
App\Entity\stock\CommandeTmp	The association App\Entity\stock\CommandeTmp#fournisseur refers to the inverse side field App\Entity\stock\Fournisseur#commandetmps which does not exist. The association App\Entity\stock\CommandeTmp#abonne refers to the inverse side field App\Entity\user\Abonne#commandetmps which does not exist.
App\Entity\stock\Depassement	No errors.
App\Entity\prod\SurfaceAnnee	The association App\Entity\prod\SurfaceAnnee#surfaceannee refers to the inverse side field App\Entity\prod\SurfaceAnnee#surfaceannees which does not exist. The association App\Entity\prod\SurfaceAnnee#abonne refers to the inverse side field App\Entity\user\Abonne#surfaceannees which does not exist. The mappings App\Entity\prod\SurfaceAnnee#infolivrers and App\Entity\stock\InfoLivrer#surfaceannee are inconsistent with each other.
App\Entity\stock\SeTrouver	No errors.
App\Entity\prod\Producteur	The association App\Entity\prod\Producteur#utilisateur refers to the inverse side field App\Entity\user\Utilisateur#producteur which does not exist. The association App\Entity\prod\Producteur#village refers to the inverse side field App\Entity\stock\Village#producteur which does not exist. The association App\Entity\prod\Producteur#abonne refers to the inverse side field App\Entity\user\Abonne#producteurs which does not exist. The association App\Entity\prod\Producteur#agent refers to the inverse side field App\Entity\user\Utilisateur#producteur which does not exist.
App\Entity\inspection\InspectionRempli	The association App\Entity\inspection\InspectionRempli#inspection refers to the inverse side field App\Entity\inspection\Inspection#inspectionremplis which does not exist. The association App\Entity\inspection\InspectionRempli#evenement refers to the inverse side field App\Entity\prod\Evenement#inspectionremplis which does not exist. The association App\Entity\inspection\InspectionRempli#infolivrer refers to the inverse side field App\Entity\stock\InfoLivrer#inspectionremplis which does not exist. The association App\Entity\inspection\InspectionRempli#transformation refers to the inverse side field App\Entity\stock\Transformation#inspectionremplis which does not exist. The association App\Entity\inspection\InspectionRempli#surfaceabonne refers to the inverse side field App\Entity\prod\SurfaceAbonne#lignecommandes which does not exist. The association App\Entity\inspection\InspectionRempli#abonne refers to the inverse side field App\Entity\user\Abonne#inspectionremplis which does not exist. The association App\Entity\inspection\InspectionRempli#utilisateur refers to the inverse side field App\Entity\user\Utilisateur#inspectionrempli which does not exist. The association App\Entity\inspection\InspectionRempli#groupement refers to the inverse side field App\Entity\prod\Groupement#inspectionremplis which does not exist. The association App\Entity\inspection\InspectionRempli#programme refers to the inverse side field App\Entity\inspection\Programme#inspectionremplis which does not exist. The association App\Entity\inspection\InspectionRempli#fournisseur refers to the inverse side field App\Entity\stock\Fournisseur#inspectionremplis which does not exist.
App\Entity\stock\Fournisseur	The mappings App\Entity\stock\Fournisseur#commandeTmps and App\Entity\stock\CommandeTmp#fournisseur are inconsistent with each other. The association App\Entity\stock\Fournisseur#utilisateur refers to the inverse side field App\Entity\user\Utilisateur#producteur which does not exist. The association App\Entity\stock\Fournisseur#abonne refers to the inverse side field App\Entity\user\Abonne#fournisseurs which does not exist.
App\Entity\client\Client	The association App\Entity\client\Client#ville refers to the inverse side field App\Entity\stock\Ville#clients which does not exist. The association App\Entity\client\Client#abonne refers to the inverse side field App\Entity\user\Abonne#clients which does not exist. The association App\Entity\client\Client#caisse refers to the inverse side field App\Entity\stock\Caisse#clients which does not exist.
App\Entity\stock\InfoTraitement	The association App\Entity\stock\InfoTraitement#abonne refers to the inverse side field App\Entity\user\Abonne#infotraitements which does not exist.
App\Entity\stock\Transformation	The association App\Entity\stock\Transformation#infolivrer refers to the inverse side field App\Entity\stock\InfoLivrer#transformations which does not exist. The association App\Entity\stock\Transformation#produit refers to the inverse side field App\Entity\stock\Produit#transformations which does not exist. The association App\Entity\stock\Transformation#produitabonne refers to the inverse side field App\Entity\stock\ProduitAbonne#transformations which does not exist. The mappings App\Entity\stock\Transformation#transformationproduits and App\Entity\stock\TransformationProduit#transformation are inconsistent with each other. The association App\Entity\stock\Transformation#abonne refers to the inverse side field App\Entity\user\Abonne#transformations which does not exist. The association App\Entity\stock\Transformation#etapeprocessuses refers to the owning side field App\Entity\stock\EtapeProcessus#transformation which does not exist.
App\Entity\stock\ResultatTraitement	No errors.
App\Entity\prod\Evenement	The association App\Entity\prod\Evenement#utilisateur refers to the inverse side field App\Entity\user\Utilisateur#evenement which does not exist. The association App\Entity\prod\Evenement#images refers to the owning side field App\Entity\stock\Image#evenement which does not exist. The association App\Entity\prod\Evenement#producteurevenements refers to the owning side field App\Entity\prod\ProducteurEvenement#evenement which does not exist. The association App\Entity\prod\Evenement#abonne refers to the inverse side field App\Entity\user\Abonne#evenements which does not exist.
App\Entity\prod\ProducteurEvenement	The association App\Entity\prod\ProducteurEvenement#abonne refers to the inverse side field App\Entity\user\Abonne#producteurevenements which does not exist.
App\Entity\user\HistoriqueAction	The association App\Entity\user\HistoriqueAction#fournisseur refers to the inverse side field App\Entity\stock\Fournisseur#historiqueactions which does not exist. The association App\Entity\user\HistoriqueAction#abonne refers to the inverse side field App\Entity\user\Abonne#utilisateurs which does not exist.
App\Entity\user\HistoriqueActionUtilisateur	No errors.
App\Entity\track\Localisation	The association App\Entity\track\Localisation#surfaceabonne refers to the inverse side field App\Entity\prod\SurfaceAbonne#lignecommandes which does not exist. The association App\Entity\track\Localisation#commande refers to the inverse side field App\Entity\stock\Commande#localisations which does not exist. The association App\Entity\track\Localisation#entrepot refers to the inverse side field App\Entity\stock\Entrepot#localisations which does not exist. The association App\Entity\track\Localisation#abonne refers to the inverse side field App\Entity\user\Abonne#localisations which does not exist. The association App\Entity\track\Localisation#inspectionrempli refers to the inverse side field App\Entity\inspection\InspectionRempli#localisations which does not exist.

Symfony Profiler

https://test.coo.tg/token/refresh?public%2Ftoken%2Frefresh=

Configuration Settings

Theme