POST https://backoffice.normandieimages.net/validation/document

Query Metrics

6 Database Queries
6 Different statements
5.67 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 1.14 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password AS reset_password_7, t0.reset_password_date AS reset_password_date_8, t0.auth_code AS auth_code_9 FROM user t0 WHERE t0.id = ?
Parameters:
[
  3
]

fa connection

# Time Info
1 1.27 ms
SELECT t0.id AS id_1, t0.motpassehash AS motpassehash_2, t0.mail_utilisateur AS mail_utilisateur_3, t0.token_date AS token_date_4, t0.titre AS titre_5, t0.duree AS duree_6, t0.format_tournage AS format_tournage_7, t0.format_definitif AS format_definitif_8, t0.genre AS genre_9, t0.synopsis AS synopsis_10, t0.adaptation_oeuvre AS adaptation_oeuvre_11, t0.deposant AS deposant_12, t0.type_aide_lm AS type_aide_lm_13, t0.type_soutien_num AS type_soutien_num_14, t0.mt_budget AS mt_budget_15, t0.liens_eligibilite AS liens_eligibilite_16, t0.date_preparation AS date_preparation_17, t0.date_tournage AS date_tournage_18, t0.date_diffusion AS date_diffusion_19, t0.casting_envisage AS casting_envisage_20, t0.lieux_tournage AS lieux_tournage_21, t0.nombre_jours_tournage AS nombre_jours_tournage_22, t0.nombre_jours_total AS nombre_jours_total_23, t0.droit_artistique_total_ht AS droit_artistique_total_ht_24, t0.droit_artistique_total_ht_normandie AS droit_artistique_total_ht_normandie_25, t0.personnel_total_ht AS personnel_total_ht_26, t0.personnel_total_ht_normandie AS personnel_total_ht_normandie_27, t0.interpretation_total_ht AS interpretation_total_ht_28, t0.interpretation_total_ht_normandie AS interpretation_total_ht_normandie_29, t0.charge_sociales_total_ht AS charge_sociales_total_ht_30, t0.charge_sociales_total_ht_normandie AS charge_sociales_total_ht_normandie_31, t0.deco_et_costumes_total_ht AS deco_et_costumes_total_ht_32, t0.deco_et_costumes_total_ht_normandie AS deco_et_costumes_total_ht_normandie_33, t0.transport_total_ht AS transport_total_ht_34, t0.transport_total_ht_normandie AS transport_total_ht_normandie_35, t0.moyen_technique_tournage_total_ht AS moyen_technique_tournage_total_ht_36, t0.pellicules_total_ht AS pellicules_total_ht_37, t0.moyen_technique_tournage_total_ht_normandie AS moyen_technique_tournage_total_ht_normandie_38, t0.pellicules_total_ht_normandie AS pellicules_total_ht_normandie_39, t0.assurance_et_frais_total_ht AS assurance_et_frais_total_ht_40, t0.assurance_et_frais_total_ht_normandie AS assurance_et_frais_total_ht_normandie_41, t0.total_partiel_total_ht AS total_partiel_total_ht_42, t0.total_partiel_total_ht_normandie AS total_partiel_total_ht_normandie_43, t0.total_general_total_ht AS total_general_total_ht_44, t0.total_general_total_ht_normandie AS total_general_total_ht_normandie_45, t0.financement_acquis AS financement_acquis_46, t0.financement_acquis_precision AS financement_acquis_precision_47, t0.depot_projet_collectivite AS depot_projet_collectivite_48, t0.depot_projet_collectivite_precision AS depot_projet_collectivite_precision_49, t0.projet_deja_presente_fonds_aide AS projet_deja_presente_fonds_aide_50, t0.projet_deja_presente_fonds_aide_date AS projet_deja_presente_fonds_aide_date_51, t0.projet_deja_presente_fonds_aide_type_aide AS projet_deja_presente_fonds_aide_type_aide_52, t0.genre_precision_autre AS genre_precision_autre_53, t0.adaptation_oeuvre_toa AS adaptation_oeuvre_toa_54, t0.adaptation_oeuvre_dacp AS adaptation_oeuvre_dacp_55, t0.adaptation_oeuvre_dfc AS adaptation_oeuvre_dfc_56, t0.montant_sollicite AS montant_sollicite_57, t0.montant_sollicite2 AS montant_sollicite2_58, t0.modified_at AS modified_at_59, t0.created_at AS created_at_60, t0.type_film AS type_film_61, t0.type_oeuvre AS type_oeuvre_62, t0.duree_episode AS duree_episode_63, t0.droit_artistiques_france AS droit_artistiques_france_64, t0.personnel_france AS personnel_france_65, t0.interpretation_france AS interpretation_france_66, t0.charge_sociale_france AS charge_sociale_france_67, t0.deco_et_costumes_france AS deco_et_costumes_france_68, t0.transport_france AS transport_france_69, t0.moyen_technique_france AS moyen_technique_france_70, t0.pellicules_france AS pellicules_france_71, t0.assurance_france AS assurance_france_72, t0.total_partiel_france AS total_partiel_france_73, t0.total_general_france AS total_general_france_74, t0.production_tv AS production_tv_75, t0.preachat_tv AS preachat_tv_76, t0.nombre_episode AS nombre_episode_77, t0.premier_film AS premier_film_78, t0.droit_artistique_cout_definitif AS droit_artistique_cout_definitif_79, t0.personnel_cout_definitif AS personnel_cout_definitif_80, t0.interpretation_cout_definitif AS interpretation_cout_definitif_81, t0.charge_sociales_cout_definitif AS charge_sociales_cout_definitif_82, t0.deco_et_costumes_cout_definitif AS deco_et_costumes_cout_definitif_83, t0.transport_cout_definitif AS transport_cout_definitif_84, t0.moyen_technique_cout_definitif AS moyen_technique_cout_definitif_85, t0.pellicules_cout_definitif AS pellicules_cout_definitif_86, t0.assurance_et_frais_cout_definitif AS assurance_et_frais_cout_definitif_87, t0.total_partiel_cout_definitif AS total_partiel_cout_definitif_88, t0.frais_generaux_cout_definitif AS frais_generaux_cout_definitif_89, t0.imprevus_cout_definitif AS imprevus_cout_definitif_90, t0.total_general_cout_definitif AS total_general_cout_definitif_91, t0.frais_generaux_total_ht AS frais_generaux_total_ht_92, t0.frais_generaux_depense_france AS frais_generaux_depense_france_93, t0.frais_generaux_normandie AS frais_generaux_normandie_94, t0.imprevus_depense_france AS imprevus_depense_france_95, t0.imprevus_normandie AS imprevus_normandie_96, t0.imprevus_total_ht AS imprevus_total_ht_97, t0.nombre_salarie_permanent AS nombre_salarie_permanent_98, t0.nombre_salarie_intermittent AS nombre_salarie_intermittent_99, t0.salarie_permenent_eqtemps AS salarie_permenent_eqtemps_100, t0.salarie_intermittentth AS salarie_intermittentth_101, t0.mt_total_programme_developpement AS mt_total_programme_developpement_102, t0.how_is_submitted AS how_is_submitted_103, t0.statut AS statut_104, t0.choix_img_diff_nouv_media AS choix_img_diff_nouv_media_105, t0.information_auteur AS information_auteur_106, t0.engagement_logo_region AS engagement_logo_region_107, t0.engagement_participation_region AS engagement_participation_region_108, t0.liste_realisateurs AS liste_realisateurs_109, t0.liste_scenaristes AS liste_scenaristes_110, t0.date_developpement AS date_developpement_111, t0.date_production AS date_production_112, t0.film_id_fk AS film_id_fk_113, t0.retrait AS retrait_114, t0.type_aide_doc AS type_aide_doc_115, t0.montant_aide_accordee AS montant_aide_accordee_116, t0.montant_aide_proposee AS montant_aide_proposee_117, t0.commission_lecture_date AS commission_lecture_date_118, t0.commission_lecture_lecteurs AS commission_lecture_lecteurs_119, t0.preselection_groupe AS preselection_groupe_120, t0.commission_lecture_avis AS commission_lecture_avis_121, t0.commission_pleniere_date AS commission_pleniere_date_122, t0.commission_pleniere_lecteurs AS commission_pleniere_lecteurs_123, t0.commission_pleniere_avis AS commission_pleniere_avis_124, t0.importation_date AS importation_date_125, t0.statut_complementaire AS statut_complementaire_126, t0.ordre_passage AS ordre_passage_127, t0.token_del AS token_del_128, t0.liste_productions_france AS liste_productions_france_129, t0.liste_productions_etrangeres AS liste_productions_etrangeres_130, t0.type_production AS type_production_131, t0.type_production_precision AS type_production_precision_132, t0.fabrication_envisagee AS fabrication_envisagee_133, t0.partenaires_envisages AS partenaires_envisages_134, t0.postes_tech_art_envisages AS postes_tech_art_envisages_135, t0.prod_deleguee_total_ht AS prod_deleguee_total_ht_136, t0.prod_deleguee_depense_france AS prod_deleguee_depense_france_137, t0.prod_deleguee_normandie AS prod_deleguee_normandie_138, t0.prod_deleguee_cout_definitif AS prod_deleguee_cout_definitif_139, t0.marge_total_ht AS marge_total_ht_140, t0.marge_depense_france AS marge_depense_france_141, t0.marge_normandie AS marge_normandie_142, t0.marge_cout_definitif AS marge_cout_definitif_143, t0.etape AS etape_144, t0.retire_abandon_motif AS retire_abandon_motif_145, t0.session_id AS session_id_146 FROM projet t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "595"
]
2 0.71 ms
SELECT t0.id AS id_1, t0.courrier_demande AS courrier_demande_2, t0.courrier_demande_updated_at AS courrier_demande_updated_at_3, t0.courrier_demande_validation AS courrier_demande_validation_4, t0.dossier_artistique AS dossier_artistique_5, t0.dossier_artistique_updated_at AS dossier_artistique_updated_at_6, t0.dossier_artistique_validation AS dossier_artistique_validation_7, t0.devis_previsionnel AS devis_previsionnel_8, t0.devis_previsionnel_updated_at AS devis_previsionnel_updated_at_9, t0.devis_previsionnel_validation AS devis_previsionnel_validation_10, t0.plan_financement AS plan_financement_11, t0.plan_financement_updated_at AS plan_financement_updated_at_12, t0.plan_financement_validation AS plan_financement_validation_13, t0.contrat AS contrat_14, t0.contrat_updated_at AS contrat_updated_at_15, t0.contrat_validation AS contrat_validation_16, t0.contrat_diffuseur AS contrat_diffuseur_17, t0.contrat_diffuseur_updated_at AS contrat_diffuseur_updated_at_18, t0.contrat_diffuseur_validation AS contrat_diffuseur_validation_19, t0.contrat_cession AS contrat_cession_20, t0.contrat_cession_updated_at AS contrat_cession_updated_at_21, t0.contrat_cession_validation AS contrat_cession_validation_22, t0.justificatif_diffusion AS justificatif_diffusion_23, t0.justificatif_diffusion_updated_at AS justificatif_diffusion_updated_at_24, t0.justificatif_diffusion_validation AS justificatif_diffusion_validation_25, t0.insee AS insee_26, t0.insee_updated_at AS insee_updated_at_27, t0.insee_validation AS insee_validation_28, t0.rib AS rib_29, t0.rib_updated_at AS rib_updated_at_30, t0.rib_validation AS rib_validation_31, t0.engagement AS engagement_32, t0.engagement_updated_at AS engagement_updated_at_33, t0.engagement_validation AS engagement_validation_34, t0.justificatif_eligibilite AS justificatif_eligibilite_35, t0.justificatif_eligibilite_updated_at AS justificatif_eligibilite_updated_at_36, t0.justificatif_eligibilite_validation AS justificatif_eligibilite_validation_37, t0.dossier_presentation AS dossier_presentation_38, t0.dossier_presentation_updated_at AS dossier_presentation_updated_at_39, t0.dossier_presentation_validation AS dossier_presentation_validation_40, t0.budget_previsionnel AS budget_previsionnel_41, t0.budget_previsionnel_updated_at AS budget_previsionnel_updated_at_42, t0.budget_previsionnel_validation AS budget_previsionnel_validation_43, t0.attestation_vigilance AS attestation_vigilance_44, t0.attestation_vigilance_updated_at AS attestation_vigilance_updated_at_45, t0.attestation_vigilance_validation AS attestation_vigilance_validation_46, t0.declaration_aide AS declaration_aide_47, t0.declaration_aide_updated_at AS declaration_aide_updated_at_48, t0.declaration_aide_validation AS declaration_aide_validation_49, t0.projet_id AS projet_id_50 FROM documents t0 WHERE t0.projet_id = ?
Parameters:
[
  595
]
3 0.37 ms
"START TRANSACTION"
Parameters:
[]
4 0.51 ms
UPDATE documents SET plan_financement_validation = ? WHERE id = ?
Parameters:
[
  1
  595
]
5 1.68 ms
"COMMIT"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection
fa doctrine.dbal.fa_connection
faold doctrine.dbal.faold_connection
prei doctrine.dbal.prei_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
fa doctrine.orm.fa_entity_manager
faold doctrine.orm.faold_entity_manager
prei doctrine.orm.prei_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\Main\User No errors.

fa entity manager

Class Mapping errors
App\Entity\Fa\Projet No errors.
App\Entity\Fa\Session No errors.
App\Entity\Fa\AuteurRealisateur No errors.
App\Entity\Fa\DocumentAudioVisuels No errors.
App\Entity\Fa\Production No errors.
App\Entity\Fa\ProjetPresente No errors.
App\Entity\Fa\ProjetDejaPresenteFA No errors.
App\Entity\Fa\Documents No errors.

faold entity manager

No loaded entities.

prei entity manager

No loaded entities.