Query Metrics
17
Database Queries
9
Different statements
6.43 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.92 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.modif AS modif_88, t84.created_at AS created_at_89, t84.updated_at AS updated_at_90, t84.dossier_demande_id AS dossier_demande_id_91, t84.user_id AS user_id_92, t84.type_formalite_id AS type_formalite_id_93, t84.motif_id AS motif_id_94, t0.banque_id AS banque_id_95, t96.id AS id_97, t96.code_banque AS code_banque_98, t96.code_agence AS code_agence_99, t96.rib_mandateur AS rib_mandateur_100, t96.bordereau AS bordereau_101, t96.created_at AS created_at_102, t96.updated_at AS updated_at_103, t96.dossier_demande_id AS dossier_demande_id_104, t96.banque_id AS banque_id_105, t96.user_banque_id AS user_banque_id_106, t0.type_creation_id AS type_creation_id_107, t108.id AS id_109, t108.objet AS objet_110, t108.caracteristique AS caracteristique_111, t108.activites AS activites_112, t108.associes AS associes_113, t108.dirigeant AS dirigeant_114, t108.transfert AS transfert_115, t108.fermeture AS fermeture_116, t108.dissolution AS dissolution_117, t108.nullite AS nullite_118, t108.autres AS autres_119, t108.sigle AS sigle_120, t108.enseigne AS enseigne_121, t108.capital AS capital_122, t108.activtes_exercees AS activtes_exercees_123, t108.activites_ajoutes AS activites_ajoutes_124, t108.activites_supprimees AS activites_supprimees_125, t108.activites_actualisees AS activites_actualisees_126, t108.siege AS siege_127, t108.dossier_id AS dossier_id_128, t108.forme_juridique_id AS forme_juridique_id_129, t108.author_id AS author_id_130 FROM dossier_demande t0 LEFT JOIN radiation t84 ON t84.dossier_demande_id = t0.id LEFT JOIN compte_entreprise t96 ON t96.dossier_demande_id = t0.id LEFT JOIN modification_rccm t108 ON t108.dossier_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
"231"
]
|
2 | 0.54 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.actif AS actif_4, t0.secteur AS secteur_5, t0.type_secteur_activite_id AS type_secteur_activite_id_6 FROM secteur_activite t0 WHERE t0.id = ?
Parameters:
[
492
]
|
3 | 0.42 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.document_id AS document_id_5, t0.fonction_id AS fonction_id_6, t0.representant_id AS representant_id_7, t0.dossier_demande_id AS dossier_demande_id_8 FROM collection_piece_jointe t0 WHERE t0.dossier_demande_id = ?
Parameters:
[
231
]
|
4 | 0.57 ms |
SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, f1_.id AS id_2, f1_.libelle AS libelle_3, f1_.isactif AS isactif_4, f1_.sigle AS sigle_5, d2_.id AS id_6, d2_.libelle AS libelle_7, d2_.code AS code_8, p0_.type_operation_id AS type_operation_id_9, p0_.forme_juridique_id AS forme_juridique_id_10, p0_.document_id AS document_id_11, p0_.fonction_id AS fonction_id_12 FROM `piece_jointe` p0_ LEFT JOIN form_juridique f1_ ON p0_.forme_juridique_id = f1_.id LEFT JOIN document d2_ ON p0_.document_id = d2_.id WHERE f1_.id = ? AND p0_.is_active IN (?) AND p0_.fonction_id IS NULL
Parameters:
[ 4 1 ] |
5 | 0.40 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.document_id AS document_id_5, t0.fonction_id AS fonction_id_6, t0.representant_id AS representant_id_7, t0.dossier_demande_id AS dossier_demande_id_8 FROM collection_piece_jointe t0 WHERE t0.dossier_demande_id = ? AND t0.document_id = ? LIMIT 1
Parameters:
[ 231 4 ] |
6 | 0.29 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.document_id AS document_id_5, t0.fonction_id AS fonction_id_6, t0.representant_id AS representant_id_7, t0.dossier_demande_id AS dossier_demande_id_8 FROM collection_piece_jointe t0 WHERE t0.dossier_demande_id = ? AND t0.document_id = ? LIMIT 1
Parameters:
[ 231 5 ] |
7 | 0.16 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.document_id AS document_id_5, t0.fonction_id AS fonction_id_6, t0.representant_id AS representant_id_7, t0.dossier_demande_id AS dossier_demande_id_8 FROM collection_piece_jointe t0 WHERE t0.dossier_demande_id = ? AND t0.document_id = ? LIMIT 1
Parameters:
[ 231 8 ] |
8 | 0.15 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.document_id AS document_id_5, t0.fonction_id AS fonction_id_6, t0.representant_id AS representant_id_7, t0.dossier_demande_id AS dossier_demande_id_8 FROM collection_piece_jointe t0 WHERE t0.dossier_demande_id = ? AND t0.document_id = ? LIMIT 1
Parameters:
[ 231 9 ] |
9 | 0.15 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.document_id AS document_id_5, t0.fonction_id AS fonction_id_6, t0.representant_id AS representant_id_7, t0.dossier_demande_id AS dossier_demande_id_8 FROM collection_piece_jointe t0 WHERE t0.dossier_demande_id = ? AND t0.document_id = ? LIMIT 1
Parameters:
[ 231 18 ] |
10 | 0.44 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_.nom_pere AS nom_pere_23, g0_.prenom_pere AS prenom_pere_24, g0_.nom_mere AS nom_mere_25, g0_.prenom_mere AS prenom_mere_26, g0_.pourcentage_participation AS pourcentage_participation_27, g0_.date_debut_relation AS date_debut_relation_28, g0_.quarti AS quarti_29, g0_.nationalite_id AS nationalite_id_30, g0_.situation_matrimoniale_id AS situation_matrimoniale_id_31, g0_.pieceidentite_id AS pieceidentite_id_32, g0_.region_id AS region_id_33, g0_.prefecture_id AS prefecture_id_34, g0_.sous_prefecture_id AS sous_prefecture_id_35, g0_.quartier_id AS quartier_id_36, g0_.genre_id AS genre_id_37, g0_.demande_dossier_id AS demande_dossier_id_38, g0_.fonction_id AS fonction_id_39, g0_.type_associe_id AS type_associe_id_40, g0_.civility_id AS civility_id_41, g0_.pays_naissance_id AS pays_naissance_id_42 FROM gerant g0_ INNER JOIN dossier_demande d1_ ON g0_.demande_dossier_id = d1_.id WHERE d1_.id = ?
Parameters:
[
231
]
|
11 | 0.28 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:
[
292
]
|
12 | 0.18 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:
[
293
]
|
13 | 0.54 ms |
SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, f1_.id AS id_2, f1_.libelle AS libelle_3, f1_.isactif AS isactif_4, f1_.sigle AS sigle_5, f2_.id AS id_6, f2_.code AS code_7, f2_.libelle AS libelle_8, f2_.description AS description_9, f2_.actif AS actif_10, d3_.id AS id_11, d3_.libelle AS libelle_12, d3_.code AS code_13, p0_.type_operation_id AS type_operation_id_14, p0_.forme_juridique_id AS forme_juridique_id_15, p0_.document_id AS document_id_16, p0_.fonction_id AS fonction_id_17 FROM `piece_jointe` p0_ INNER JOIN form_juridique f1_ ON p0_.forme_juridique_id = f1_.id INNER JOIN fonction f2_ ON p0_.fonction_id = f2_.id INNER JOIN document d3_ ON p0_.document_id = d3_.id WHERE f1_.id = ? AND f2_.id = ?
Parameters:
[ 4 1 ] |
14 | 0.37 ms |
SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, f1_.id AS id_2, f1_.libelle AS libelle_3, f1_.isactif AS isactif_4, f1_.sigle AS sigle_5, f2_.id AS id_6, f2_.code AS code_7, f2_.libelle AS libelle_8, f2_.description AS description_9, f2_.actif AS actif_10, d3_.id AS id_11, d3_.libelle AS libelle_12, d3_.code AS code_13, p0_.type_operation_id AS type_operation_id_14, p0_.forme_juridique_id AS forme_juridique_id_15, p0_.document_id AS document_id_16, p0_.fonction_id AS fonction_id_17 FROM `piece_jointe` p0_ INNER JOIN form_juridique f1_ ON p0_.forme_juridique_id = f1_.id INNER JOIN fonction f2_ ON p0_.fonction_id = f2_.id INNER JOIN document d3_ ON p0_.document_id = d3_.id WHERE f1_.id = ? AND f2_.id = ?
Parameters:
[ 4 14 ] |
15 | 0.37 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.document_id AS document_id_5, t0.fonction_id AS fonction_id_6, t0.representant_id AS representant_id_7, t0.dossier_demande_id AS dossier_demande_id_8 FROM collection_piece_jointe t0 WHERE t0.dossier_demande_id = ? AND t0.document_id = ? AND t0.representant_id = ? LIMIT 1
Parameters:
[ 231 1 292 ] |
16 | 0.31 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.document_id AS document_id_5, t0.fonction_id AS fonction_id_6, t0.representant_id AS representant_id_7, t0.dossier_demande_id AS dossier_demande_id_8 FROM collection_piece_jointe t0 WHERE t0.dossier_demande_id = ? AND t0.document_id = ? AND t0.representant_id = ? LIMIT 1
Parameters:
[ 231 3 292 ] |
17 | 0.34 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.document_id AS document_id_5, t0.fonction_id AS fonction_id_6, t0.representant_id AS representant_id_7, t0.dossier_demande_id AS dossier_demande_id_8 FROM collection_piece_jointe t0 WHERE t0.dossier_demande_id = ? AND t0.document_id = ? AND t0.representant_id = ? LIMIT 1
Parameters:
[ 231 16 292 ] |
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.