Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

6.53 ms Query time

4 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	6.53 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.created_at AS created_at_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.adresse AS adresse_9, t0.telephone AS telephone_10, t0.facebook AS facebook_11, t0.instagram AS instagram_12, t0.linkedin AS linkedin_13, t0.twitter AS twitter_14, t0.siteperso AS siteperso_15, t0.id_google AS id_google_16, t0.slug AS slug_17, t0.image AS image_18, t0.avarar_google AS avarar_google_19, t0.type AS type_20, t0.psedo AS psedo_21, t0.credits AS credits_22, t0.validation AS validation_23, t0.domaine AS domaine_24, t0.agence_id AS agence_id_25, t0.hotel_id AS hotel_id_26 FROM user t0 WHERE t0.id = ? Parameters: [`"index7.html"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.created_at AS created_at_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.adresse AS adresse_9, t0.telephone AS telephone_10, t0.facebook AS facebook_11, t0.instagram AS instagram_12, t0.linkedin AS linkedin_13, t0.twitter AS twitter_14, t0.siteperso AS siteperso_15, t0.id_google AS id_google_16, t0.slug AS slug_17, t0.image AS image_18, t0.avarar_google AS avarar_google_19, t0.type AS type_20, t0.psedo AS psedo_21, t0.credits AS credits_22, t0.validation AS validation_23, t0.domaine AS domaine_24, t0.agence_id AS agence_id_25, t0.hotel_id AS hotel_id_26 FROM user t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.created_at AS created_at_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.adresse AS adresse_9, t0.telephone AS telephone_10, t0.facebook AS facebook_11, t0.instagram AS instagram_12, t0.linkedin AS linkedin_13, t0.twitter AS twitter_14, t0.siteperso AS siteperso_15, t0.id_google AS id_google_16, t0.slug AS slug_17, t0.image AS image_18, t0.avarar_google AS avarar_google_19, t0.type AS type_20, t0.psedo AS psedo_21, t0.credits AS credits_22, t0.validation AS validation_23, t0.domaine AS domaine_24, t0.agence_id AS agence_id_25, t0.hotel_id AS hotel_id_26 FROM user t0 WHERE t0.id = 'index7.html';

#▲

Time

Info

6.53 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.created_at AS created_at_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.adresse AS adresse_9, t0.telephone AS telephone_10, t0.facebook AS facebook_11, t0.instagram AS instagram_12, t0.linkedin AS linkedin_13, t0.twitter AS twitter_14, t0.siteperso AS siteperso_15, t0.id_google AS id_google_16, t0.slug AS slug_17, t0.image AS image_18, t0.avarar_google AS avarar_google_19, t0.type AS type_20, t0.psedo AS psedo_21, t0.credits AS credits_22, t0.validation AS validation_23, t0.domaine AS domaine_24, t0.agence_id AS agence_id_25, t0.hotel_id AS hotel_id_26 FROM user t0 WHERE t0.id = ?

Parameters:

[
  "index7.html"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.created_at AS created_at_6,
  t0.nom AS nom_7,
  t0.prenom AS prenom_8,
  t0.adresse AS adresse_9,
  t0.telephone AS telephone_10,
  t0.facebook AS facebook_11,
  t0.instagram AS instagram_12,
  t0.linkedin AS linkedin_13,
  t0.twitter AS twitter_14,
  t0.siteperso AS siteperso_15,
  t0.id_google AS id_google_16,
  t0.slug AS slug_17,
  t0.image AS image_18,
  t0.avarar_google AS avarar_google_19,
  t0.type AS type_20,
  t0.psedo AS psedo_21,
  t0.credits AS credits_22,
  t0.validation AS validation_23,
  t0.domaine AS domaine_24,
  t0.agence_id AS agence_id_25,
  t0.hotel_id AS hotel_id_26
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.created_at AS created_at_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.adresse AS adresse_9, t0.telephone AS telephone_10, t0.facebook AS facebook_11, t0.instagram AS instagram_12, t0.linkedin AS linkedin_13, t0.twitter AS twitter_14, t0.siteperso AS siteperso_15, t0.id_google AS id_google_16, t0.slug AS slug_17, t0.image AS image_18, t0.avarar_google AS avarar_google_19, t0.type AS type_20, t0.psedo AS psedo_21, t0.credits AS credits_22, t0.validation AS validation_23, t0.domaine AS domaine_24, t0.agence_id AS agence_id_25, t0.hotel_id AS hotel_id_26 FROM user t0 WHERE t0.id = 'index7.html';

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\Agences	No errors.
App\Entity\Hotels	No errors.
App\Entity\Articles	No errors.
App\Entity\Annonces	No errors.
App\Entity\Images	No errors.
App\Entity\Messages	The mappings App\Entity\Messages#recipient and App\Entity\User#messages are inconsistent with each other.
App\Entity\PostLike	No errors.
App\Entity\Resetemail	No errors.
App\Entity\Visiteurs	No errors.
App\Entity\Event	The mappings App\Entity\Event#intervenant and App\Entity\User#events are inconsistent with each other.
App\Entity\Reservations	No errors.
App\Entity\Factures	No errors.
App\Entity\Wallet	No errors.
App\Entity\Transactions	No errors.
App\Entity\Alertes	No errors.
App\Entity\CommentairesLocataires	The mappings App\Entity\CommentairesLocataires#locataire and App\Entity\User#commentairesLocataires are inconsistent with each other.
App\Entity\CommentairesLogements	No errors.
App\Entity\CommentairesProprietaires	The mappings App\Entity\CommentairesProprietaires#proprietaire and App\Entity\User#commentairesProprietaires are inconsistent with each other.
App\Entity\Recherche	No errors.
App\Entity\Contact	No errors.
App\Entity\Franchises	No errors.
App\Entity\VillesFrance	No errors.

Symfony Profiler

http://immolier.com/profil/profil/profil/index7.html

Configuration Settings

Theme