Error 500 Internal Server Error

GET https://apip.ocreationentreprise.com/visualiser-annonce-legale/181

Forwarded to ErrorController (339f08)

Query Metrics

8 Database Queries
8 Different statements
253.88 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 58.97 ms
SELECT t0.id AS id_1, t0.isactif AS isactif_2, t0.status_retrait AS status_retrait_3, t0.stat_suivie_depot AS stat_suivie_depot_4, t0.stat_suivie_quittance AS stat_suivie_quittance_5, t0.stat_suivie_saisie AS stat_suivie_saisie_6, t0.date_saisie AS date_saisie_7, t0.stat_suivie_rccm AS stat_suivie_rccm_8, t0.stat_suivie_dni AS stat_suivie_dni_9, t0.date_retrait AS date_retrait_10, t0.est_retire AS est_retire_11, t0.is_handicape AS is_handicape_12, t0.denomination_sociale AS denomination_sociale_13, t0.nom_commercial AS nom_commercial_14, t0.activite_sociale AS activite_sociale_15, t0.activite_complementaire AS activite_complementaire_16, t0.sigle AS sigle_17, t0.enseigne AS enseigne_18, t0.adresse_siege AS adresse_siege_19, t0.adresse_etablissement AS adresse_etablissement_20, t0.boite_postale AS boite_postale_21, t0.telephone AS telephone_22, t0.telephone2 AS telephone2_23, t0.email AS email_24, t0.en_activite AS en_activite_25, t0.nombre_action AS nombre_action_26, t0.date_debut AS date_debut_27, t0.nombre_salarie_prevu AS nombre_salarie_prevu_28, t0.valeur_nominale AS valeur_nominale_29, t0.capital_social AS capital_social_30, t0.apport_numeraire AS apport_numeraire_31, t0.apport_nature AS apport_nature_32, t0.document_collectes AS document_collectes_33, t0.statut AS statut_34, t0.statut_validation AS statut_validation_35, t0.date_creation AS date_creation_36, t0.date_validation AS date_validation_37, t0.date_delivrance AS date_delivrance_38, t0.numero_dossier AS numero_dossier_39, t0.rccm_siege AS rccm_siege_40, t0.code_fiscal AS code_fiscal_41, t0.ville AS ville_42, t0.motif AS motif_43, t0.soussigne AS soussigne_44, t0.fonction_soussigne AS fonction_soussigne_45, t0.telephone_promoteur AS telephone_promoteur_46, t0.email_promoteur AS email_promoteur_47, t0.statut_validation_chef_greffe AS statut_validation_chef_greffe_48, t0.date_validation_chef_greffe AS date_validation_chef_greffe_49, t0.duree AS duree_50, t0.is_modification AS is_modification_51, t0.is_aguipe AS is_aguipe_52, t0.is_sensibilisation AS is_sensibilisation_53, t0.date_quittance AS date_quittance_54, t0.is_submitted AS is_submitted_55, t0.stat_suivie_aguipe AS stat_suivie_aguipe_56, t0.is_radier AS is_radier_57, t0.is_create_banque AS is_create_banque_58, t0.is_compte_entreprise AS is_compte_entreprise_59, t0.is_signature_greffe AS is_signature_greffe_60, t0.apport_industrie AS apport_industrie_61, t0.is_paiement_en_ligne AS is_paiement_en_ligne_62, t0.coordonees_longitude AS coordonees_longitude_63, t0.chiffre_affaire_previsionnel AS chiffre_affaire_previsionnel_64, t0.coordonees_latitude AS coordonees_latitude_65, t0.type_secteur_activite_id AS type_secteur_activite_id_66, t0.secteur_activite_id AS secteur_activite_id_67, t0.forme_juridique_id AS forme_juridique_id_68, t0.pays_id AS pays_id_69, t0.region_id AS region_id_70, t0.prefecture_id AS prefecture_id_71, t0.sous_prefecture_id AS sous_prefecture_id_72, t0.quartier_id AS quartier_id_73, t0.utilisateur_id AS utilisateur_id_74, t0.type_dossier_id AS type_dossier_id_75, t0.type_operation_id AS type_operation_id_76, t0.service_juridique_id AS service_juridique_id_77, t0.user_depot_id AS user_depot_id_78, t0.user_retrait_id AS user_retrait_id_79, t0.user_caisse_id AS user_caisse_id_80, t0.utilisateur_rccm_delivre_id AS utilisateur_rccm_delivre_id_81, t0.user_validation_id AS user_validation_id_82, t0.moyen_de_sensibilisation_id AS moyen_de_sensibilisation_id_83, t84.id AS id_85, t84.doc AS doc_86, t84.date_radiation AS date_radiation_87, t84.created_at AS created_at_88, t84.updated_at AS updated_at_89, t84.dossier_demande_id AS dossier_demande_id_90, t84.user_id AS user_id_91, t84.type_formalite_id AS type_formalite_id_92, t84.motif_id AS motif_id_93, t0.banque_id AS banque_id_94, t95.id AS id_96, t95.code_banque AS code_banque_97, t95.code_agence AS code_agence_98, t95.rib_mandateur AS rib_mandateur_99, t95.bordereau AS bordereau_100, t95.created_at AS created_at_101, t95.updated_at AS updated_at_102, t95.dossier_demande_id AS dossier_demande_id_103, t95.banque_id AS banque_id_104, t95.user_banque_id AS user_banque_id_105, t0.type_creation_id AS type_creation_id_106, t107.id AS id_108, t107.objet AS objet_109, t107.caracteristique AS caracteristique_110, t107.activites AS activites_111, t107.associes AS associes_112, t107.dirigeant AS dirigeant_113, t107.transfert AS transfert_114, t107.fermeture AS fermeture_115, t107.dissolution AS dissolution_116, t107.nullite AS nullite_117, t107.autres AS autres_118, t107.sigle AS sigle_119, t107.enseigne AS enseigne_120, t107.capital AS capital_121, t107.activtes_exercees AS activtes_exercees_122, t107.activites_ajoutes AS activites_ajoutes_123, t107.activites_supprimees AS activites_supprimees_124, t107.activites_actualisees AS activites_actualisees_125, t107.siege AS siege_126, t107.dossier_id AS dossier_id_127, t107.forme_juridique_id AS forme_juridique_id_128, t107.author_id AS author_id_129 FROM dossier_demande t0 LEFT JOIN radiation t84 ON t84.dossier_demande_id = t0.id LEFT JOIN compte_entreprise t95 ON t95.dossier_demande_id = t0.id LEFT JOIN modification_rccm t107 ON t107.dossier_id = t0.id WHERE t0.id = ?
Parameters:
[
  "181"
]
2 25.84 ms
SELECT t0.id AS id_1, t0.objet AS objet_2, t0.adresse AS adresse_3, t0.identite AS identite_4, t0.adresse_acquereur AS adresse_acquereur_5, t0.num_rccm AS num_rccm_6, t0.date_fermeture AS date_fermeture_7, t0.autres_infos AS autres_infos_8, t0.modification_id AS modification_id_9 FROM modification_info_etablissement_rccm t0 WHERE t0.modification_id = ?
Parameters:
[
  7
]
3 37.21 ms
SELECT t0.id AS id_1, t0.num_rccm_formalite AS num_rccm_formalite_2, t0.num_rccm_entreprise AS num_rccm_entreprise_3, t0.date AS date_4, t0.date_obtention_nif AS date_obtention_nif_5, t0.statut AS statut_6, t0.is_retrait AS is_retrait_7, t0.dossier_demande_id AS dossier_demande_id_8, t0.type_formalite_id AS type_formalite_id_9 FROM rccm t0 WHERE t0.dossier_demande_id = ? LIMIT 1
Parameters:
[
  181
]
4 2.25 ms
SELECT g0_.id AS id_0, g0_.nom AS nom_1, g0_.prenom AS prenom_2, g0_.date_naisse_at AS date_naisse_at_3, g0_.lieu_naiss AS lieu_naiss_4, g0_.adresse AS adresse_5, g0_.profession AS profession_6, g0_.num_piece_identite AS num_piece_identite_7, g0_.telephone1 AS telephone1_8, g0_.telephone2 AS telephone2_9, g0_.email AS email_10, g0_.piece_id_path AS piece_id_path_11, g0_.deux_photo_path AS deux_photo_path_12, g0_.date_delivrance_piece AS date_delivrance_piece_13, g0_.datexpiration_piece AS datexpiration_piece_14, g0_.ville_delivrance_piece AS ville_delivrance_piece_15, g0_.duree_mandat AS duree_mandat_16, g0_.ville AS ville_17, g0_.apport_capital AS apport_capital_18, g0_.certificat_residence AS certificat_residence_19, g0_.apport_numeraire AS apport_numeraire_20, g0_.apport_nature AS apport_nature_21, g0_.apport_industrie AS apport_industrie_22, g0_.nationalite_id AS nationalite_id_23, g0_.situation_matrimoniale_id AS situation_matrimoniale_id_24, g0_.pieceidentite_id AS pieceidentite_id_25, g0_.region_id AS region_id_26, g0_.prefecture_id AS prefecture_id_27, g0_.sous_prefecture_id AS sous_prefecture_id_28, g0_.quartier_id AS quartier_id_29, g0_.genre_id AS genre_id_30, g0_.demande_dossier_id AS demande_dossier_id_31, g0_.fonction_id AS fonction_id_32, g0_.type_associe_id AS type_associe_id_33, g0_.civility_id AS civility_id_34, g0_.pays_naissance_id AS pays_naissance_id_35 FROM gerant g0_ INNER JOIN dossier_demande d1_ ON g0_.demande_dossier_id = d1_.id INNER JOIN fonction f2_ ON g0_.fonction_id = f2_.id WHERE d1_.id = ? AND f2_.code IN (?, ?)
Parameters:
[
  181
  "GR"
  "CG"
]
5 4.17 ms
SELECT t0.id AS id_1, t0.statut AS statut_2, t0.fonction_id AS fonction_id_3, t0.gerant_id AS gerant_id_4 FROM gerant_modification_rccm t0 WHERE t0.gerant_id = ?
Parameters:
[
  234
]
6 12.86 ms
SELECT g0_.id AS id_0, g0_.nom AS nom_1, g0_.prenom AS prenom_2, g0_.date_naisse_at AS date_naisse_at_3, g0_.lieu_naiss AS lieu_naiss_4, g0_.adresse AS adresse_5, g0_.profession AS profession_6, g0_.num_piece_identite AS num_piece_identite_7, g0_.telephone1 AS telephone1_8, g0_.telephone2 AS telephone2_9, g0_.email AS email_10, g0_.piece_id_path AS piece_id_path_11, g0_.deux_photo_path AS deux_photo_path_12, g0_.date_delivrance_piece AS date_delivrance_piece_13, g0_.datexpiration_piece AS datexpiration_piece_14, g0_.ville_delivrance_piece AS ville_delivrance_piece_15, g0_.duree_mandat AS duree_mandat_16, g0_.ville AS ville_17, g0_.apport_capital AS apport_capital_18, g0_.certificat_residence AS certificat_residence_19, g0_.apport_numeraire AS apport_numeraire_20, g0_.apport_nature AS apport_nature_21, g0_.apport_industrie AS apport_industrie_22, g0_.nationalite_id AS nationalite_id_23, g0_.situation_matrimoniale_id AS situation_matrimoniale_id_24, g0_.pieceidentite_id AS pieceidentite_id_25, g0_.region_id AS region_id_26, g0_.prefecture_id AS prefecture_id_27, g0_.sous_prefecture_id AS sous_prefecture_id_28, g0_.quartier_id AS quartier_id_29, g0_.genre_id AS genre_id_30, g0_.demande_dossier_id AS demande_dossier_id_31, g0_.fonction_id AS fonction_id_32, g0_.type_associe_id AS type_associe_id_33, g0_.civility_id AS civility_id_34, g0_.pays_naissance_id AS pays_naissance_id_35 FROM gerant g0_ INNER JOIN dossier_demande d1_ ON g0_.demande_dossier_id = d1_.id INNER JOIN fonction f2_ ON g0_.fonction_id = f2_.id WHERE d1_.id = ? AND f2_.code = ? LIMIT 1
Parameters:
[
  181
  "GR"
]
7 14.96 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.isactif AS isactif_3, t0.sigle AS sigle_4 FROM form_juridique t0 WHERE t0.id = ?
Parameters:
[
  5
]
8 97.64 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.isactif AS isactif_4 FROM type_dossier t0 WHERE t0.id = ?
Parameters:
[
  9
]

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\DossierDemande No errors.
App\Entity\TypeSecteurActivite No errors.
App\Entity\SecteurActivite No errors.
App\Entity\FormJuridique No errors.
App\Entity\Pays No errors.
App\Entity\Region No errors.
App\Entity\Prefecture No errors.
App\Entity\SousPrefecture No errors.
App\Entity\Quartier No errors.
App\Entity\Utilisateur No errors.
App\Entity\TypeDossier No errors.
App\Entity\TypeOperation No errors.
App\Entity\ServiceJuridique No errors.
App\Entity\MoyenDeSensibilisation No errors.
App\Entity\Radiation No errors.
App\Entity\TypeFormaliteRccm No errors.
App\Entity\MotifRadiation No errors.
App\Entity\Banque No errors.
App\Entity\CompteEntreprise No errors.
App\Entity\TypeCreation No errors.
App\Entity\ModificationRCCM No errors.
App\Entity\Gerant No errors.
App\Entity\Cnss No errors.
App\Entity\Paiement No errors.
App\Entity\Quittance No errors.
App\Entity\Aguipe No errors.
App\Entity\HistoriqueLettre No errors.
App\Entity\OriginePm No errors.
App\Entity\ActiviteAnterieure No errors.
App\Entity\PersonneEngageur No errors.
App\Entity\CollectionPieceJointe No errors.
App\Entity\DossierDemandeCommissionnaireAuCompte No errors.
App\Entity\Rccm No errors.
App\Entity\HistoriqueEchangeDni No errors.
App\Entity\NIF No errors.
App\Entity\RepartitionQuittance No errors.
App\Entity\DemandeModification No errors.
App\Entity\DocumentCollected No errors.
App\Entity\ModificationInfoEtablissementRCCM No errors.
App\Entity\Fonction No errors.
App\Entity\SituationMatrimoniale No errors.
App\Entity\PieceIdentite No errors.
App\Entity\Genre No errors.
App\Entity\TypeAssocie No errors.
App\Entity\Civilite No errors.
App\Entity\Conjoint No errors.
App\Entity\GerantModificationRCCM No errors.
App\Entity\Statut No errors.
App\Entity\StatutGerantAssocie No errors.
App\Entity\Tarification No errors.
App\Entity\PieceJointe No errors.
App\Entity\Menu No errors.
App\Entity\Reservation No errors.
App\Entity\PeriodeReservation No errors.
App\Entity\DetailReservation No errors.
App\Entity\ParametrageFormeJuridique No errors.
App\Entity\Circuit No errors.
App\Entity\Structure No errors.
App\Entity\Services No errors.
App\Entity\Role No errors.
App\Entity\UserGroupe No errors.
App\Entity\JournalisationSaisi No errors.
App\Entity\CessationActivite No errors.
App\Entity\ConsequencesEtablissement No errors.
App\Entity\Scission No errors.
App\Entity\Facture No errors.
App\Entity\ModePaiement No errors.
App\Entity\TypeOrigine No errors.
App\Entity\Document No errors.
App\Entity\CommissaireAuCompte No errors.
App\Entity\TypeFonctionCommissaire No errors.
App\Entity\MCommissaireAuCompte No errors.
App\Entity\TypeStructure No errors.
App\Entity\StatutTraitement No errors.
App\Entity\ResponsableApip No errors.
App\Entity\RegimeMatrimoniale No errors.
App\Entity\ModelPV No errors.
App\Entity\TypeStatutGerantAssocie No errors.
App\Entity\LibelleTarification No errors.
App\Entity\LabelMenu No errors.