Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

9.18 ms Query time

4 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	9.18 ms	SELECT t0.id AS id_1, t0.superficie AS superficie_2, t0.adresse AS adresse_3, t0.prix AS prix_4, t0.description AS description_5, t0.titre AS titre_6, t0.longitude AS longitude_7, t0.latitude AS latitude_8, t0.codepostale AS codepostale_9, t0.image AS image_10, t0.slug AS slug_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.dpe AS dpe_14, t0.ges AS ges_15, t0.honoraires AS honoraires_16, t0.ville_slug AS ville_slug_17, t0.ville_code_postal AS ville_code_postal_18, t0.piece AS piece_19, t0.ville AS ville_20, t0.codepostal AS codepostal_21, t0.transaction AS transaction_22, t0.etat AS etat_23, t0.logement AS logement_24, t0.chauffage AS chauffage_25, t0.pieces AS pieces_26, t0.chambres AS chambres_27, t0.charges AS charges_28, t0.quantite AS quantite_29, t0.chambre AS chambre_30, t0.salledebain AS salledebain_31, t0.garage AS garage_32, t0.psedo AS psedo_33, t0.domaine AS domaine_34, t0.user_id AS user_id_35, t0.villes_france_id AS villes_france_id_36, t0.agence_id AS agence_id_37, t0.ville_annonce_id AS ville_annonce_id_38, t0.hotel_id AS hotel_id_39 FROM annonces t0 WHERE t0.slug = ? LIMIT 1 Parameters: [`"page-blog-single.html"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.superficie AS superficie_2, t0.adresse AS adresse_3, t0.prix AS prix_4, t0.description AS description_5, t0.titre AS titre_6, t0.longitude AS longitude_7, t0.latitude AS latitude_8, t0.codepostale AS codepostale_9, t0.image AS image_10, t0.slug AS slug_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.dpe AS dpe_14, t0.ges AS ges_15, t0.honoraires AS honoraires_16, t0.ville_slug AS ville_slug_17, t0.ville_code_postal AS ville_code_postal_18, t0.piece AS piece_19, t0.ville AS ville_20, t0.codepostal AS codepostal_21, t0.transaction AS transaction_22, t0.etat AS etat_23, t0.logement AS logement_24, t0.chauffage AS chauffage_25, t0.pieces AS pieces_26, t0.chambres AS chambres_27, t0.charges AS charges_28, t0.quantite AS quantite_29, t0.chambre AS chambre_30, t0.salledebain AS salledebain_31, t0.garage AS garage_32, t0.psedo AS psedo_33, t0.domaine AS domaine_34, t0.user_id AS user_id_35, t0.villes_france_id AS villes_france_id_36, t0.agence_id AS agence_id_37, t0.ville_annonce_id AS ville_annonce_id_38, t0.hotel_id AS hotel_id_39 FROM annonces t0 WHERE t0.slug = ? LIMIT 1 SELECT t0.id AS id_1, t0.superficie AS superficie_2, t0.adresse AS adresse_3, t0.prix AS prix_4, t0.description AS description_5, t0.titre AS titre_6, t0.longitude AS longitude_7, t0.latitude AS latitude_8, t0.codepostale AS codepostale_9, t0.image AS image_10, t0.slug AS slug_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.dpe AS dpe_14, t0.ges AS ges_15, t0.honoraires AS honoraires_16, t0.ville_slug AS ville_slug_17, t0.ville_code_postal AS ville_code_postal_18, t0.piece AS piece_19, t0.ville AS ville_20, t0.codepostal AS codepostal_21, t0.transaction AS transaction_22, t0.etat AS etat_23, t0.logement AS logement_24, t0.chauffage AS chauffage_25, t0.pieces AS pieces_26, t0.chambres AS chambres_27, t0.charges AS charges_28, t0.quantite AS quantite_29, t0.chambre AS chambre_30, t0.salledebain AS salledebain_31, t0.garage AS garage_32, t0.psedo AS psedo_33, t0.domaine AS domaine_34, t0.user_id AS user_id_35, t0.villes_france_id AS villes_france_id_36, t0.agence_id AS agence_id_37, t0.ville_annonce_id AS ville_annonce_id_38, t0.hotel_id AS hotel_id_39 FROM annonces t0 WHERE t0.slug = 'page-blog-single.html' LIMIT 1;

#▲

Time

Info

9.18 ms

SELECT t0.id AS id_1, t0.superficie AS superficie_2, t0.adresse AS adresse_3, t0.prix AS prix_4, t0.description AS description_5, t0.titre AS titre_6, t0.longitude AS longitude_7, t0.latitude AS latitude_8, t0.codepostale AS codepostale_9, t0.image AS image_10, t0.slug AS slug_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.dpe AS dpe_14, t0.ges AS ges_15, t0.honoraires AS honoraires_16, t0.ville_slug AS ville_slug_17, t0.ville_code_postal AS ville_code_postal_18, t0.piece AS piece_19, t0.ville AS ville_20, t0.codepostal AS codepostal_21, t0.transaction AS transaction_22, t0.etat AS etat_23, t0.logement AS logement_24, t0.chauffage AS chauffage_25, t0.pieces AS pieces_26, t0.chambres AS chambres_27, t0.charges AS charges_28, t0.quantite AS quantite_29, t0.chambre AS chambre_30, t0.salledebain AS salledebain_31, t0.garage AS garage_32, t0.psedo AS psedo_33, t0.domaine AS domaine_34, t0.user_id AS user_id_35, t0.villes_france_id AS villes_france_id_36, t0.agence_id AS agence_id_37, t0.ville_annonce_id AS ville_annonce_id_38, t0.hotel_id AS hotel_id_39 FROM annonces t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "page-blog-single.html"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.superficie AS superficie_2,
  t0.adresse AS adresse_3,
  t0.prix AS prix_4,
  t0.description AS description_5,
  t0.titre AS titre_6,
  t0.longitude AS longitude_7,
  t0.latitude AS latitude_8,
  t0.codepostale AS codepostale_9,
  t0.image AS image_10,
  t0.slug AS slug_11,
  t0.updated_at AS updated_at_12,
  t0.created_at AS created_at_13,
  t0.dpe AS dpe_14,
  t0.ges AS ges_15,
  t0.honoraires AS honoraires_16,
  t0.ville_slug AS ville_slug_17,
  t0.ville_code_postal AS ville_code_postal_18,
  t0.piece AS piece_19,
  t0.ville AS ville_20,
  t0.codepostal AS codepostal_21,
  t0.transaction AS transaction_22,
  t0.etat AS etat_23,
  t0.logement AS logement_24,
  t0.chauffage AS chauffage_25,
  t0.pieces AS pieces_26,
  t0.chambres AS chambres_27,
  t0.charges AS charges_28,
  t0.quantite AS quantite_29,
  t0.chambre AS chambre_30,
  t0.salledebain AS salledebain_31,
  t0.garage AS garage_32,
  t0.psedo AS psedo_33,
  t0.domaine AS domaine_34,
  t0.user_id AS user_id_35,
  t0.villes_france_id AS villes_france_id_36,
  t0.agence_id AS agence_id_37,
  t0.ville_annonce_id AS ville_annonce_id_38,
  t0.hotel_id AS hotel_id_39
FROM
  annonces t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.superficie AS superficie_2, t0.adresse AS adresse_3, t0.prix AS prix_4, t0.description AS description_5, t0.titre AS titre_6, t0.longitude AS longitude_7, t0.latitude AS latitude_8, t0.codepostale AS codepostale_9, t0.image AS image_10, t0.slug AS slug_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.dpe AS dpe_14, t0.ges AS ges_15, t0.honoraires AS honoraires_16, t0.ville_slug AS ville_slug_17, t0.ville_code_postal AS ville_code_postal_18, t0.piece AS piece_19, t0.ville AS ville_20, t0.codepostal AS codepostal_21, t0.transaction AS transaction_22, t0.etat AS etat_23, t0.logement AS logement_24, t0.chauffage AS chauffage_25, t0.pieces AS pieces_26, t0.chambres AS chambres_27, t0.charges AS charges_28, t0.quantite AS quantite_29, t0.chambre AS chambre_30, t0.salledebain AS salledebain_31, t0.garage AS garage_32, t0.psedo AS psedo_33, t0.domaine AS domaine_34, t0.user_id AS user_id_35, t0.villes_france_id AS villes_france_id_36, t0.agence_id AS agence_id_37, t0.ville_annonce_id AS ville_annonce_id_38, t0.hotel_id AS hotel_id_39 FROM annonces t0 WHERE t0.slug = 'page-blog-single.html' 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
App\Entity\Annonces	No errors.
App\Entity\User	No errors.
App\Entity\VillesFrance	No errors.
App\Entity\Agences	No errors.
App\Entity\Hotels	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\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\Equipements	No errors.
App\Entity\CommentairesLogements	No errors.
App\Entity\PostLike	No errors.
App\Entity\Articles	No errors.
App\Entity\Resetemail	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\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.

Symfony Profiler

http://immolier.com/logement/page-blog-single.html

Configuration Settings

Theme