GET https://backoffice.normandieimages.net/backoffice/fonds-d-aide/inscriptions/projet?id=595

Response
200 OK
Browse referrer URL
IP
2a01:cb06:b05:5500:c877:2810:d5c8:295b
Profiled on
Token
999672

Query Metrics

14 Database Queries
13 Different statements
12.21 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
1.39 ms
(11.35%) 		1 
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
]
View formatted query    View runnable query    Explain query    View query backtrace

fa connection

Time▼ Count Info
1.88 ms
(15.37%) 		1 
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
]
View formatted query    View runnable query    Explain query    View query backtrace
1.43 ms
(11.74%) 		2 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.civilite AS civilite_4, t0.adresse AS adresse_5, t0.code_postal AS code_postal_6, t0.ville AS ville_7, t0.pays AS pays_8, t0.indicatif_telephone AS indicatif_telephone_9, t0.telephone AS telephone_10, t0.courriel AS courriel_11, t0.ordre AS ordre_12, t0.production_ordre AS production_ordre_13, t0.production_id AS production_id_14 FROM producteur t0 WHERE t0.production_id = ?
Parameters: 
[
  459
]
View formatted query    View runnable query    Explain query    View query backtrace
1.34 ms
(11.01%) 		1 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.22 ms
(9.99%) 		1 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nature AS nature_3, t0.siret AS siret_4, t0.recup_tva AS recup_tva_5, t0.nom_gerant AS nom_gerant_6, t0.prenom_gerant AS prenom_gerant_7, t0.indicatif_telephone_gerant AS indicatif_telephone_gerant_8, t0.telephone_gerant AS telephone_gerant_9, t0.email_gerant AS email_gerant_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.adresse_bureau AS adresse_bureau_14, t0.code_postale_bureau AS code_postale_bureau_15, t0.ville_bureau AS ville_bureau_16, t0.prenom_personne_chargee AS prenom_personne_chargee_17, t0.nom_personne_chargee AS nom_personne_chargee_18, t0.indicatif_telephone_personne_chargee AS indicatif_telephone_personne_chargee_19, t0.telephone_personne_chargee AS telephone_personne_chargee_20, t0.courriel_personne_chargee AS courriel_personne_chargee_21, t0.civilite_gerant AS civilite_gerant_22, t0.civilite_personne_chargee AS civilite_personne_chargee_23, t0.fonction_personne_chargee AS fonction_personne_chargee_24, t0.pays AS pays_25, t0.pays_bureau AS pays_bureau_26, t0.id_fk_fm AS id_fk_fm_27, t0.regionale AS regionale_28, t0.ordre AS ordre_29, t0.liste_producteurs AS liste_producteurs_30, t0.participation AS participation_31, t0.deleguee AS deleguee_32, t0.executive AS executive_33, t0.soutien AS soutien_34, t0.projet_id AS projet_id_35 FROM production t0 WHERE t0.projet_id = ?
Parameters: 
[
  595
]
View formatted query    View runnable query    Explain query    View query backtrace
0.74 ms
(6.04%) 		1 
SELECT p0_.id AS id_0, p0_.lib_fr AS lib_fr_1, p0_.lib_en AS lib_en_2 FROM pays p0_
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.69 ms
(5.68%) 		1 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.actif AS actif_3, t0.annee AS annee_4, t0.session_1 AS session_1_5, t0.session_2 AS session_2_6, t0.session_3 AS session_3_7, t0.ordre AS ordre_8, t0.soutien_type AS soutien_type_9, t0.soutien_montant_min AS soutien_montant_min_10, t0.soutien_montant_max AS soutien_montant_max_11, t0.libelle_formulaire AS libelle_formulaire_12, t0.entretien_prealable_by AS entretien_prealable_by_13 FROM fonds_aide t0 WHERE t0.id = ?
Parameters: 
[
  27
]
View formatted query    View runnable query    Explain query    View query backtrace
0.69 ms
(5.67%) 		1 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.preselection AS preselection_5, t0.pleniere AS pleniere_6, t0.numerus_clausus AS numerus_clausus_7, t0.annee_attribution_aide AS annee_attribution_aide_8, t0.session_active AS session_active_9, t0.blocage_numerus_clausus AS blocage_numerus_clausus_10, t0.pleniere_lieu AS pleniere_lieu_11, t0.nbr_new_save AS nbr_new_save_12, t0.nbr_new_valide AS nbr_new_valide_13, t0.preselection_lecteurs_a AS preselection_lecteurs_a_14, t0.preselection_lecteurs_b AS preselection_lecteurs_b_15, t0.pleniere_lecteurs AS pleniere_lecteurs_16, t0.statut AS statut_17, t0.rdv_prealable AS rdv_prealable_18, t0.acces_formulaire AS acces_formulaire_19, t0.fonds_aide_id AS fonds_aide_id_20 FROM SESSION t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  462
]
View formatted query    View runnable query    Explain query    View query backtrace
0.64 ms
(5.28%) 		1 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.pseudonyme AS pseudonyme_4, t0.denomination AS denomination_5, t0.adresse AS adresse_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.indicatif_telephone AS indicatif_telephone_9, t0.telephone AS telephone_10, t0.courriel AS courriel_11, t0.type_personne AS type_personne_12, t0.pourcentage AS pourcentage_13, t0.date_naissance AS date_naissance_14, t0.lieu_naissance AS lieu_naissance_15, t0.civilite AS civilite_16, t0.nationalite AS nationalite_17, t0.pays AS pays_18, t0.id_fk_fm AS id_fk_fm_19, t0.projet_id AS projet_id_20 FROM auteur_realisateur t0 WHERE t0.projet_id = ?
Parameters: 
[
  595
]
View formatted query    View runnable query    Explain query    View query backtrace
0.60 ms
(4.90%) 		1 
SELECT t0.id AS id_1, t0.pays AS pays_2, t0.indicatif AS indicatif_3, t0.flag AS flag_4 FROM indicatif_tel t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.55 ms
(4.47%) 		1 
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.realisateur AS realisateur_3, t0.genre AS genre_4, t0.annee AS annee_5, t0.duree AS duree_6, t0.mot_de_passe AS mot_de_passe_7, t0.lien AS lien_8, t0.projet_id AS projet_id_9 FROM document_audio_visuels t0 WHERE t0.projet_id = ?
Parameters: 
[
  595
]
View formatted query    View runnable query    Explain query    View query backtrace
0.52 ms
(4.28%) 		1 
SELECT t0.id AS id_1, t0.fonds AS fonds_2, t0.date AS date_3, t0.soutenu AS soutenu_4, t0.projet_id AS projet_id_5, t0.fonds_aide_id AS fonds_aide_id_6 FROM projet_deja_presente_fa t0 WHERE t0.projet_id = ?
Parameters: 
[
  595
]
View formatted query    View runnable query    Explain query    View query backtrace
0.51 ms
(4.22%) 		1 
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.auteur_realisateur AS auteur_realisateur_3, t0.genre AS genre_4, t0.duree_envisagee AS duree_envisagee_5, t0.cout_previsionnel AS cout_previsionnel_6, t0.precision_autre AS precision_autre_7, t0.resume AS resume_8, t0.projet_id AS projet_id_9 FROM projet_presente t0 WHERE t0.projet_id = ?
Parameters: 
[
  595
]
View formatted query    View runnable query    Explain query    View query backtrace

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.
App\Entity\Fa\FondsAide No errors.
App\Entity\Fa\IndicatifTel No errors.
App\Entity\Fa\Pays No errors.
App\Entity\Fa\Producteur No errors.

faold entity manager

No loaded entities.

prei entity manager

No loaded entities.