Error 500 Internal Server Error

GET https://preprod.evolis-ie.com/offres-immobilier/vente/local-commercial/le-pontet-84130/local-commercial-a-vendre-le-pontet-84130-1361941-0vc

IP
216.73.216.51
Profiled on
Token
6027fd
Forwarded to ErrorController (1b4607)

Query Metrics

25 Database Queries
23 Different statements
120.38 ms Query time
4 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
103.24 ms
(85.76%) 		1 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.recherche AS recherche_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5 FROM localisations t0 ORDER BY t0.libelle ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3.31 ms
(2.75%) 		1 
SELECT t0.id AS id_1, t0.ref_interne AS ref_interne_2, t0.adresse AS adresse_3, t0.cp AS cp_4, t0.ville AS ville_5, t0.photo1 AS photo1_6, t0.descriptif AS descriptif_7, t0.accroche AS accroche_8, t0.condifi AS condifi_9, t0.prestimm AS prestimm_10, t0.equipement AS equipement_11, t0.dispo AS dispo_12, t0.desserte AS desserte_13, t0.nom_consultant AS nom_consultant_14, t0.tel_consultant AS tel_consultant_15, t0.tel_port_consultant AS tel_port_consultant_16, t0.mail_consultant AS mail_consultant_17, t0.divisible AS divisible_18, t0.date_modif AS date_modif_19, t0.url_virtuelle AS url_virtuelle_20, t0.dpe_chiffre AS dpe_chiffre_21, t0.dpe_lettre AS dpe_lettre_22, t0.ges_chiffre AS ges_chiffre_23, t0.ges_lettre AS ges_lettre_24, t0.surface_div AS surface_div_25, t0.surface_totale AS surface_totale_26, t0.latitude AS latitude_27, t0.longitude AS longitude_28, t0.prix_vente_global AS prix_vente_global_29, t0.loyer_global AS loyer_global_30, t0.honos_pourcent AS honos_pourcent_31, t0.honos_montant AS honos_montant_32, t0.photo2 AS photo2_33, t0.photo3 AS photo3_34, t0.photo4 AS photo4_35, t0.photo5 AS photo5_36, t0.photo6 AS photo6_37, t0.photo7 AS photo7_38, t0.photo8 AS photo8_39, t0.photo9 AS photo9_40, t0.photo10 AS photo10_41, t0.photo11 AS photo11_42, t0.photo12 AS photo12_43, t0.photo13 AS photo13_44, t0.photo14 AS photo14_45, t0.photo15 AS photo15_46, t0.plan1 AS plan1_47, t0.plan2 AS plan2_48, t0.plan3 AS plan3_49, t0.plan4 AS plan4_50, t0.plan5 AS plan5_51, t0.plan6 AS plan6_52, t0.plan7 AS plan7_53, t0.plan8 AS plan8_54, t0.plan9 AS plan9_55, t0.plan10 AS plan10_56, t0.plan11 AS plan11_57, t0.plan12 AS plan12_58, t0.plan13 AS plan13_59, t0.plan14 AS plan14_60, t0.plan15 AS plan15_61, t0.slug_ville_cp AS slug_ville_cp_62, t0.slug_ville AS slug_ville_63, t0.slug_type AS slug_type_64, t0.slug_nature AS slug_nature_65, t0.slug_nature_second AS slug_nature_second_66, t0.slug_detail_url AS slug_detail_url_67, t0.directe AS directe_68, t0.archive AS archive_69, t0.loyer_mcarre AS loyer_mcarre_70, t0.prix_mcarre AS prix_mcarre_71, t0.detail_surfaces AS detail_surfaces_72, t0.departement AS departement_73, t0.departement_slug AS departement_slug_74, t0.departement_libelle AS departement_libelle_75, t0.import AS import_76, t0.price_min AS price_min_77, t0.price_max AS price_max_78, t0.price_max_uom AS price_max_uom_79, t0.price_average AS price_average_80, t0.price_uom_text AS price_uom_text_81, t0.price_gross_rent_price AS price_gross_rent_price_82, t0.price_gross_rent_price_text AS price_gross_rent_price_text_83, t0.nature_id AS nature_id_84, t0.type_id AS type_id_85, t0.agence_id AS agence_id_86, t0.page_index_id AS page_index_id_87 FROM offres t0 WHERE t0.slug_detail_url = ? LIMIT 1
Parameters: 
[
  "local-commercial-a-vendre-le-pontet-84130-1361941-0vc"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.15 ms
(1.79%) 		1 
SELECT o0_.id AS id_0, o0_.ref_interne AS ref_interne_1, o0_.adresse AS adresse_2, o0_.cp AS cp_3, o0_.ville AS ville_4, o0_.photo1 AS photo1_5, o0_.descriptif AS descriptif_6, o0_.accroche AS accroche_7, o0_.condifi AS condifi_8, o0_.prestimm AS prestimm_9, o0_.equipement AS equipement_10, o0_.dispo AS dispo_11, o0_.desserte AS desserte_12, o0_.nom_consultant AS nom_consultant_13, o0_.tel_consultant AS tel_consultant_14, o0_.tel_port_consultant AS tel_port_consultant_15, o0_.mail_consultant AS mail_consultant_16, o0_.divisible AS divisible_17, o0_.date_modif AS date_modif_18, o0_.url_virtuelle AS url_virtuelle_19, o0_.dpe_chiffre AS dpe_chiffre_20, o0_.dpe_lettre AS dpe_lettre_21, o0_.ges_chiffre AS ges_chiffre_22, o0_.ges_lettre AS ges_lettre_23, o0_.surface_div AS surface_div_24, o0_.surface_totale AS surface_totale_25, o0_.latitude AS latitude_26, o0_.longitude AS longitude_27, o0_.prix_vente_global AS prix_vente_global_28, o0_.loyer_global AS loyer_global_29, o0_.honos_pourcent AS honos_pourcent_30, o0_.honos_montant AS honos_montant_31, o0_.photo2 AS photo2_32, o0_.photo3 AS photo3_33, o0_.photo4 AS photo4_34, o0_.photo5 AS photo5_35, o0_.photo6 AS photo6_36, o0_.photo7 AS photo7_37, o0_.photo8 AS photo8_38, o0_.photo9 AS photo9_39, o0_.photo10 AS photo10_40, o0_.photo11 AS photo11_41, o0_.photo12 AS photo12_42, o0_.photo13 AS photo13_43, o0_.photo14 AS photo14_44, o0_.photo15 AS photo15_45, o0_.plan1 AS plan1_46, o0_.plan2 AS plan2_47, o0_.plan3 AS plan3_48, o0_.plan4 AS plan4_49, o0_.plan5 AS plan5_50, o0_.plan6 AS plan6_51, o0_.plan7 AS plan7_52, o0_.plan8 AS plan8_53, o0_.plan9 AS plan9_54, o0_.plan10 AS plan10_55, o0_.plan11 AS plan11_56, o0_.plan12 AS plan12_57, o0_.plan13 AS plan13_58, o0_.plan14 AS plan14_59, o0_.plan15 AS plan15_60, o0_.slug_ville_cp AS slug_ville_cp_61, o0_.slug_ville AS slug_ville_62, o0_.slug_type AS slug_type_63, o0_.slug_nature AS slug_nature_64, o0_.slug_nature_second AS slug_nature_second_65, o0_.slug_detail_url AS slug_detail_url_66, o0_.directe AS directe_67, o0_.archive AS archive_68, o0_.loyer_mcarre AS loyer_mcarre_69, o0_.prix_mcarre AS prix_mcarre_70, o0_.detail_surfaces AS detail_surfaces_71, o0_.departement AS departement_72, o0_.departement_slug AS departement_slug_73, o0_.departement_libelle AS departement_libelle_74, o0_.import AS import_75, o0_.price_min AS price_min_76, o0_.price_max AS price_max_77, o0_.price_max_uom AS price_max_uom_78, o0_.price_average AS price_average_79, o0_.price_uom_text AS price_uom_text_80, o0_.price_gross_rent_price AS price_gross_rent_price_81, o0_.price_gross_rent_price_text AS price_gross_rent_price_text_82, o0_.nature_id AS nature_id_83, o0_.type_id AS type_id_84, o0_.agence_id AS agence_id_85, o0_.page_index_id AS page_index_id_86 FROM offres o0_ WHERE o0_.nature_id = ? AND o0_.type_id = ? AND ((o0_.surface_totale >= ? AND o0_.surface_totale <= ?) OR (o0_.surface_div >= ? AND o0_.surface_div <= ?) AND o0_.directe = 1) AND ((o0_.prix_vente_global >= ? AND o0_.prix_vente_global <= ?)) AND o0_.cp LIKE ? AND o0_.directe = ?
Parameters: 
[
  2
  2
  853.6
  1387.1
  853.6
  1387.1
  0
  100000000
  "84%"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
1.37 ms
(1.14%) 		2 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.seo_url AS seo_url_3, t0.seo_titre AS seo_titre_4, t0.seo_desc AS seo_desc_5, t0.titre AS titre_6, t0.contenu_un AS contenu_un_7, t0.contenu_deux AS contenu_deux_8, t0.date_maj AS date_maj_9, t0.image AS image_10, t0.citation AS citation_11, t0.image_citation AS image_citation_12, t0.afficher_bloc_contact AS afficher_bloc_contact_13, t0.nature_offre AS nature_offre_14, t0.type_offre AS type_offre_15, t0.smin_offre AS smin_offre_16, t0.smax_offre AS smax_offre_17, t0.afficher_carrousel_offre AS afficher_carrousel_offre_18, t0.afficher_carrousel_crit AS afficher_carrousel_crit_19, t0.titre_offre AS titre_offre_20, t0.afficher_bouton_offre AS afficher_bouton_offre_21, t0.libelle_bouton_offre AS libelle_bouton_offre_22, t0.title_bouton_offre AS title_bouton_offre_23, t0.url_offre AS url_offre_24, t0.afficher_bloc_actus AS afficher_bloc_actus_25, t0.og_title AS og_title_26, t0.og_desc AS og_desc_27, t0.og_image AS og_image_28, t0.page_mere_id AS page_mere_id_29 FROM pages t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
1.34 ms
(1.11%) 		2 
SELECT t0_.id AS id_0, t0_.libelle AS libelle_1, t0_.description AS description_2, t0_.image AS image_3, t0_.courant AS courant_4, t0_.dirname AS dirname_5, t0_.color_prime AS color_prime_6, t0_.color_second AS color_second_7, t0_.color_third AS color_third_8, t0_.date_maj AS date_maj_9, t0_.text_color_prime AS text_color_prime_10, t0_.text_color_second AS text_color_second_11, t0_.color_seperateur AS color_seperateur_12 FROM template t0_ WHERE t0_.courant = ? LIMIT 1
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
1.33 ms
(1.10%) 		1 
SELECT t0.id AS id_1, t0.societe AS societe_2, t0.adresse AS adresse_3, t0.cp AS cp_4, t0.ville AS ville_5, t0.secteur AS secteur_6, t0.picto AS picto_7, t0.date_maj AS date_maj_8, t0.email AS email_9, t0.tel AS tel_10, t0.ordre AS ordre_11, t0.presentation AS presentation_12, t0.logiciel_type AS logiciel_type_13, t0.logiciel_id AS logiciel_id_14, t0.email_demande AS email_demande_15, t0.slug AS slug_16, t0.titre AS titre_17, t0.image AS image_18, t0.title AS title_19, t0.meta_desc AS meta_desc_20, t0.titre_og AS titre_og_21, t0.desc_og AS desc_og_22, t0.image_og AS image_og_23, t0.calendy AS calendy_24 FROM agence t0 ORDER BY t0.ordre ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.64 ms
(0.53%) 		1 
SELECT t0.id AS id_1, t0.nb_lignes AS nb_lignes_2, t0.libelle AS libelle_3, t0.afficher_pagination AS afficher_pagination_4, t0.url_liste AS url_liste_5, t0.url_detail AS url_detail_6, t0.h1_liste AS h1_liste_7, t0.afficher_bloc_contact AS afficher_bloc_contact_8, t0.afficher_bloc_contact_detail AS afficher_bloc_contact_detail_9, t0.seo_title AS seo_title_10, t0.seo_desc AS seo_desc_11, t0.image_bg AS image_bg_12, t0.date_maj AS date_maj_13, t0.afficher_unite_loyer AS afficher_unite_loyer_14, t0.afficher_loyer AS afficher_loyer_15, t0.afficher_prix AS afficher_prix_16, t0.afficher_unite_prix AS afficher_unite_prix_17, t0.slider_surface_max AS slider_surface_max_18, t0.afficher_tri AS afficher_tri_19, t0.afficher_favoris AS afficher_favoris_20, t0.button_contact AS button_contact_21 FROM offres_config t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.55 ms
(0.46%) 		1 
SELECT t0.id AS id_1, t0.societe AS societe_2, t0.adresse AS adresse_3, t0.cp AS cp_4, t0.ville AS ville_5, t0.email AS email_6, t0.tel AS tel_7, t0.fax AS fax_8, t0.description AS description_9, t0.image AS image_10, t0.date_maj AS date_maj_11, t0.twitter AS twitter_12, t0.linkedin AS linkedin_13, t0.facebook AS facebook_14, t0.contact_titre AS contact_titre_15, t0.contact_span AS contact_span_16, t0.contact_texte AS contact_texte_17, t0.favico AS favico_18, t0.cle_google_map AS cle_google_map_19, t0.puce_google_map AS puce_google_map_20, t0.contact_fond AS contact_fond_21, t0.google_analytics AS google_analytics_22, t0.insta AS insta_23 FROM infos t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.50 ms
(0.42%) 		1 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.tel AS tel_5, t0.fax AS fax_6, t0.image AS image_7, t0.update_at AS update_at_8, t0.lien1 AS lien1_9, t0.lien2 AS lien2_10, t0.fonction AS fonction_11, t0.equipe_id AS equipe_id_12 FROM collaborateurs t0 WHERE t0.email = ? LIMIT 1
Parameters: 
[
  "laurent.poisson@evolis-ie.com"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.48 ms
(0.40%) 		1 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.photo AS photo_3, t0.update_at AS update_at_4, t0.type_offre_id AS type_offre_id_5 FROM offres_photos t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.48 ms
(0.40%) 		1 
SELECT t0.id AS id_1, t0.nb_lignes AS nb_lignes_2, t0.libelle AS libelle_3, t0.afficher_pagination AS afficher_pagination_4, t0.afficher_actus_similaires AS afficher_actus_similaires_5, t0.url_liste AS url_liste_6, t0.url_detail AS url_detail_7, t0.h1_liste AS h1_liste_8, t0.afficher_bloc_contact AS afficher_bloc_contact_9, t0.titre_actu_similaire AS titre_actu_similaire_10, t0.afficher_bloc_contact_detail AS afficher_bloc_contact_detail_11, t0.seo_title AS seo_title_12, t0.seo_desc AS seo_desc_13, t0.image_bg AS image_bg_14, t0.date_maj AS date_maj_15 FROM actus_config t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.44 ms
(0.37%) 		1 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.actif AS actif_3, t0.image AS image_4, t0.updated_at AS updated_at_5, t0.svg AS svg_6, t0.svg_header AS svg_header_7, t0.template_id AS template_id_8 FROM favoris_config t0 WHERE t0.actif = ? LIMIT 1
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.44 ms
(0.37%) 		1 
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.accroche AS accroche_3, t0.btn_libelle AS btn_libelle_4, t0.btn_lien AS btn_lien_5, t0.btn_title AS btn_title_6, t0.bloc_un_nom AS bloc_un_nom_7, t0.bloc_un_lien AS bloc_un_lien_8, t0.bloc_un_title AS bloc_un_title_9, t0.bloc_deux_nom AS bloc_deux_nom_10, t0.bloc_deux_lien AS bloc_deux_lien_11, t0.bloc_deux_title AS bloc_deux_title_12, t0.bloc_trois_nom AS bloc_trois_nom_13, t0.bloc_trois_lien AS bloc_trois_lien_14, t0.bloc_trois_title AS bloc_trois_title_15 FROM menu_mega t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.44 ms
(0.37%) 		1 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.image AS image_4, t0.actif AS actif_5, t0.date_maj AS date_maj_6, t0.nb AS nb_7 FROM secteur_config t0 WHERE t0.actif = ? LIMIT 1
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.43 ms
(0.36%) 		1 
SELECT t0.id AS id_1, t0.bloc_un_nom AS bloc_un_nom_2, t0.bloc_deux_nom AS bloc_deux_nom_3, t0.bloc_trois_nom AS bloc_trois_nom_4 FROM footer t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.43 ms
(0.36%) 		1 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.libelle_second AS libelle_second_3, t0.slug AS slug_4, t0.slug_second AS slug_second_5 FROM offres_type t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
0.42 ms
(0.35%) 		1 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.libelle_second AS libelle_second_3, t0.libelle_third AS libelle_third_4, t0.slug AS slug_5, t0.slug_second AS slug_second_6, t0.slug_third AS slug_third_7 FROM offres_nature t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
0.42 ms
(0.35%) 		1 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.ordre AS ordre_3, t0.title AS title_4, t0.url AS url_5, t0.targert AS targert_6, t0.type AS type_7 FROM menu t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.41 ms
(0.34%) 		1 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.actif AS actif_3 FROM partage_config t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.40 ms
(0.34%) 		1 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.libelle_second AS libelle_second_3, t0.libelle_third AS libelle_third_4, t0.slug AS slug_5, t0.slug_second AS slug_second_6, t0.slug_third AS slug_third_7 FROM offres_nature t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.40 ms
(0.33%) 		1 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.libelle_second AS libelle_second_3, t0.slug AS slug_4, t0.slug_second AS slug_second_5 FROM offres_type t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.39 ms
(0.32%) 		1 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image AS image_3, t0.date_maj AS date_maj_4, t0.actif AS actif_5, t0.cle_api AS cle_api_6, t0.puce_map AS puce_map_7, t0.styles AS styles_8 FROM maps t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.37 ms
(0.31%) 		1 
SELECT t0.id AS id_1, t0.affichage AS affichage_2, t0.choix_affichage_carte AS choix_affichage_carte_3, t0.choix_affichage_mixte AS choix_affichage_mixte_4, t0.choix_affichage_liste AS choix_affichage_liste_5 FROM type_affichage t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace

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\Infos No errors.
App\Entity\Agence No errors.
App\Entity\ActusConfig No errors.
App\Entity\OffresConfig No errors.
App\Entity\OffresPhotos No errors.
App\Entity\OffresNature No errors.
App\Entity\OffresType No errors.
App\Entity\Localisations No errors.
App\Entity\Pages
  • The association App\Entity\Pages#localisationOffre refers to the inverse side field App\Entity\Localisations#actuses which does not exist.
App\Entity\Template No errors.
App\Entity\Menu No errors.
App\Entity\MenuMega No errors.
App\Entity\Footer No errors.
App\Entity\SecteurConfig No errors.
App\Entity\FavorisConfig No errors.
App\Entity\PartageConfig No errors.
App\Entity\Maps No errors.
App\Entity\TypeAffichage No errors.
App\Entity\Offres No errors.
App\Entity\TriConfig No errors.
App\Entity\Collaborateurs No errors.
App\Entity\Secteur No errors.
App\Entity\BlocNoResult No errors.
App\Entity\PageIndex No errors.
App\Entity\Surfaces No errors.
App\Entity\Renseignements No errors.
App\Entity\Equipe No errors.
App\Entity\AlerteMail No errors.
App\Entity\Actus
  • The association App\Entity\Actus#localisationOffre refers to the inverse side field App\Entity\Localisations#actuses which does not exist.
App\Entity\Carriere No errors.
App\Entity\MenuLink No errors.
App\Entity\FooterLink No errors.
App\Entity\Slider No errors.
App\Entity\Utilisateur No errors.
App\Entity\PageEquipe
  • The association App\Entity\PageEquipe#localisationOffre refers to the inverse side field App\Entity\Localisations#actuses which does not exist.
App\Entity\User No errors.
App\Entity\ActusStatut No errors.
App\Entity\ActusCategorie No errors.
App\Entity\MenuMegaDeux No errors.
App\Entity\FooterBig No errors.
App\Entity\Config No errors.
App\Entity\ImportType No errors.
App\Entity\ImportConfig No errors.
App\Entity\PageImplantation
  • The association App\Entity\PageImplantation#localisationOffre refers to the inverse side field App\Entity\Localisations#actuses which does not exist.
App\Entity\Content No errors.
App\Entity\Test No errors.
App\Entity\PageCarriere No errors.
Vich\UploaderBundle\Entity\File No errors.