Query Metrics
8
Database Queries
8
Different statements
34.40 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.65 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:
[
"194"
]
|
| 2 | 13.71 ms |
SELECT t0.id AS id_1, t0.date_action AS date_action_2, t0.statut AS statut_3, t0.beneficiaire AS beneficiaire_4, t0.adresse_siege AS adresse_siege_5, t0.num_rccm AS num_rccm_6, t0.radiation_id AS radiation_id_7 FROM cessation_activite t0 WHERE t0.radiation_id = ?
Parameters:
[
9
]
|
| 3 | 0.97 ms |
SELECT t0.id AS id_1, t0.date_scission AS date_scission_2, t0.nom AS nom_3, t0.adresse_siege AS adresse_siege_4, t0.num_rccm AS num_rccm_5, t0.statut AS statut_6, t0.radiation_id AS radiation_id_7 FROM scission t0 WHERE t0.radiation_id = ?
Parameters:
[
9
]
|
| 4 | 6.28 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:
[
194
]
|
| 5 | 1.01 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:
[ 194 "GR" "CG" ] |
| 6 | 4.56 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:
[ 194 "GR" ] |
| 7 | 4.44 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:
[
3
]
|
| 8 | 1.78 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.