https://preprod.fusacq.com/vente-entreprise-import-export-de-materiel-pour-le-secteur-vinicole,71312_fr_

Forwarded to
ErrorController (e9b588)
Method
GET
HTTP Status
500
IP
47.128.43.223
Profiled on
Token
5446df

Query Metrics

2 Database Queries
2 Different statements
21.94 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 10.96 ms 
SELECT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.titre_annonce AS titre_annonce_1, a0_.date_parution_initiale AS date_parution_initiale_2, a0_.date_parution AS date_parution_3, a0_.login_utilisateur AS login_utilisateur_4, a0_.date_parution_elite AS date_parution_elite_5, a0_.ca_n AS ca_n_6, a0_.id_pays AS id_pays_7, a0_.id_region AS id_region_8, a0_.zone_geographique AS zone_geographique_9, a0_.id_departement AS id_departement_10, a0_.statuts AS statuts_11, a0_.id_secteur_activite AS id_secteur_activite_12, a0_.mode_annonce AS mode_annonce_13, a0_.id_raison_cession AS id_raison_cession_14, a0_.date_creation_societe AS date_creation_societe_15, a0_.type_cession AS type_cession_16, a0_.description_activite AS description_activite_17, a0_.possession_brevets AS possession_brevets_18, a0_.possession_marques AS possession_marques_19, a0_.travail_export AS travail_export_20, a0_.raison_cession AS raison_cession_21, a0_.annee_n AS annee_n_22, a0_.ca_nmoinsdeux AS ca_nmoinsdeux_23, a0_.ca_nmoinsun AS ca_nmoinsun_24, a0_.ca_nplusun AS ca_nplusun_25, a0_.marge_brute_nmoinsdeux AS marge_brute_nmoinsdeux_26, a0_.marge_brute_nmoinsun AS marge_brute_nmoinsun_27, a0_.marge_brute_n AS marge_brute_n_28, a0_.marge_brute_nplusun AS marge_brute_nplusun_29, a0_.EBE_nmoinsdeux AS EBE_nmoinsdeux_30, a0_.EBE_nmoinsun AS EBE_nmoinsun_31, a0_.EBE_n AS EBE_n_32, a0_.EBE_nplusun AS EBE_nplusun_33, a0_.resultat_exploitation_nmoinsdeux AS resultat_exploitation_nmoinsdeux_34, a0_.resultat_exploitation_nmoinsun AS resultat_exploitation_nmoinsun_35, a0_.resultat_exploitation_n AS resultat_exploitation_n_36, a0_.resultat_exploitation_nplusun AS resultat_exploitation_nplusun_37, a0_.resultat_net_nmoinsdeux AS resultat_net_nmoinsdeux_38, a0_.resultat_net_nmoinsun AS resultat_net_nmoinsun_39, a0_.resultat_net_n AS resultat_net_n_40, a0_.resultat_net_nplusun AS resultat_net_nplusun_41, a0_.nb_personnes_nmoinsdeux AS nb_personnes_nmoinsdeux_42, a0_.nb_personnes_nmoinsun AS nb_personnes_nmoinsun_43, a0_.nb_personnes_n AS nb_personnes_n_44, a0_.nb_personnes_nplusun AS nb_personnes_nplusun_45, a0_.fonds_propres AS fonds_propres_46, a0_.dettes_financieres AS dettes_financieres_47, a0_.tresorerie_nette AS tresorerie_nette_48, a0_.points_forts AS points_forts_49, a0_.points_faibles AS points_faibles_50, a0_.positionnement_marche AS positionnement_marche_51, a0_.concurrence AS concurrence_52, a0_.prix_cession AS prix_cession_53, a0_.redressement_judiciaire AS redressement_judiciaire_54, a0_.apport_fp_min AS apport_fp_min_55, a0_.recherche_active AS recherche_active_56, a0_.immobilier_dans_prix_cession AS immobilier_dans_prix_cession_57, a0_.elements_complementaires AS elements_complementaires_58, a0_.profil_repreneur_checkbox AS profil_repreneur_checkbox_59, a0_.profil_repreneur_recherche AS profil_repreneur_recherche_60, a0_.nom_contact AS nom_contact_61, a0_.email AS email_62, a0_.telephone AS telephone_63, a0_.commentaires AS commentaires_64, a0_.endettement_net_n AS endettement_net_n_65, a0_.id_langue AS id_langue_66, a0_.indicatif_telephone AS indicatif_telephone_67, a0_.date_fin_publique_elite AS date_fin_publique_elite_68 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.id_annonce_vendeur = 71312
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 10.98 ms 
SELECT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.titre_annonce AS titre_annonce_1, a0_.date_parution_initiale AS date_parution_initiale_2, a0_.date_parution AS date_parution_3, a0_.login_utilisateur AS login_utilisateur_4, a0_.date_parution_elite AS date_parution_elite_5, a0_.ca_n AS ca_n_6, a0_.id_pays AS id_pays_7, a0_.id_region AS id_region_8, a0_.zone_geographique AS zone_geographique_9, a0_.id_departement AS id_departement_10, a0_.statuts AS statuts_11, a0_.id_secteur_activite AS id_secteur_activite_12, a0_.mode_annonce AS mode_annonce_13, a0_.id_raison_cession AS id_raison_cession_14, a0_.date_creation_societe AS date_creation_societe_15, a0_.type_cession AS type_cession_16, a0_.description_activite AS description_activite_17, a0_.possession_brevets AS possession_brevets_18, a0_.possession_marques AS possession_marques_19, a0_.travail_export AS travail_export_20, a0_.raison_cession AS raison_cession_21, a0_.annee_n AS annee_n_22, a0_.ca_nmoinsdeux AS ca_nmoinsdeux_23, a0_.ca_nmoinsun AS ca_nmoinsun_24, a0_.ca_nplusun AS ca_nplusun_25, a0_.marge_brute_nmoinsdeux AS marge_brute_nmoinsdeux_26, a0_.marge_brute_nmoinsun AS marge_brute_nmoinsun_27, a0_.marge_brute_n AS marge_brute_n_28, a0_.marge_brute_nplusun AS marge_brute_nplusun_29, a0_.EBE_nmoinsdeux AS EBE_nmoinsdeux_30, a0_.EBE_nmoinsun AS EBE_nmoinsun_31, a0_.EBE_n AS EBE_n_32, a0_.EBE_nplusun AS EBE_nplusun_33, a0_.resultat_exploitation_nmoinsdeux AS resultat_exploitation_nmoinsdeux_34, a0_.resultat_exploitation_nmoinsun AS resultat_exploitation_nmoinsun_35, a0_.resultat_exploitation_n AS resultat_exploitation_n_36, a0_.resultat_exploitation_nplusun AS resultat_exploitation_nplusun_37, a0_.resultat_net_nmoinsdeux AS resultat_net_nmoinsdeux_38, a0_.resultat_net_nmoinsun AS resultat_net_nmoinsun_39, a0_.resultat_net_n AS resultat_net_n_40, a0_.resultat_net_nplusun AS resultat_net_nplusun_41, a0_.nb_personnes_nmoinsdeux AS nb_personnes_nmoinsdeux_42, a0_.nb_personnes_nmoinsun AS nb_personnes_nmoinsun_43, a0_.nb_personnes_n AS nb_personnes_n_44, a0_.nb_personnes_nplusun AS nb_personnes_nplusun_45, a0_.fonds_propres AS fonds_propres_46, a0_.dettes_financieres AS dettes_financieres_47, a0_.tresorerie_nette AS tresorerie_nette_48, a0_.points_forts AS points_forts_49, a0_.points_faibles AS points_faibles_50, a0_.positionnement_marche AS positionnement_marche_51, a0_.concurrence AS concurrence_52, a0_.prix_cession AS prix_cession_53, a0_.redressement_judiciaire AS redressement_judiciaire_54, a0_.apport_fp_min AS apport_fp_min_55, a0_.recherche_active AS recherche_active_56, a0_.immobilier_dans_prix_cession AS immobilier_dans_prix_cession_57, a0_.elements_complementaires AS elements_complementaires_58, a0_.profil_repreneur_checkbox AS profil_repreneur_checkbox_59, a0_.profil_repreneur_recherche AS profil_repreneur_recherche_60, a0_.nom_contact AS nom_contact_61, a0_.email AS email_62, a0_.telephone AS telephone_63, a0_.commentaires AS commentaires_64, a0_.endettement_net_n AS endettement_net_n_65, a0_.id_langue AS id_langue_66, a0_.indicatif_telephone AS indicatif_telephone_67, a0_.date_fin_publique_elite AS date_fin_publique_elite_68 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND a0_.tpe_pme = 'oui' AND a0_.id_annonce_vendeur = 71312
Parameters: 
[]
View formatted query    View runnable query    Explain query

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\AnnoncesVendeur No errors.