GET https://backoffice.normandieimages.net/backoffice/fonds-d-aide/inscriptions/pdf/projet?Fa=prodcm&projetID=717&type=lecteur

Response
200 OK
Browse referrer URL
IP
194.214.7.48
Profiled on
Token
81b1eb

Query Metrics

8 Database Queries
8 Different statements
11.42 ms Query time
0 Invalid entities
9 Managed entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
1.27 ms
(11.15%) 		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: 
[
  8
]
View formatted query    View runnable query    Explain query    View query backtrace

fa connection

Time▼ Count Info
4.78 ms
(41.89%) 		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: 
[
  717
]
View formatted query    View runnable query    Explain query    View query backtrace
1.82 ms
(15.92%) 		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: 
[
  717
]
View formatted query    View runnable query    Explain query    View query backtrace
1.16 ms
(10.19%) 		1 
SELECT t0.id AS id_1, t0.projet_film_id AS projet_film_id_2, t0.motpassehash AS motpassehash_3, t0.mail_utilisateur AS mail_utilisateur_4, t0.token_date AS token_date_5, t0.titre AS titre_6, t0.duree AS duree_7, t0.format_tournage AS format_tournage_8, t0.format_definitif AS format_definitif_9, t0.genre AS genre_10, t0.synopsis AS synopsis_11, t0.adaptation_oeuvre AS adaptation_oeuvre_12, t0.deposant AS deposant_13, t0.type_aide_lm AS type_aide_lm_14, t0.type_soutien_num AS type_soutien_num_15, t0.mt_budget AS mt_budget_16, t0.liens_eligibilite AS liens_eligibilite_17, t0.date_preparation AS date_preparation_18, t0.date_tournage AS date_tournage_19, t0.date_diffusion AS date_diffusion_20, t0.casting_envisage AS casting_envisage_21, t0.lieux_tournage AS lieux_tournage_22, t0.nombre_jours_tournage AS nombre_jours_tournage_23, t0.nombre_jours_total AS nombre_jours_total_24, t0.droit_artistique_total_ht AS droit_artistique_total_ht_25, t0.droit_artistique_total_ht_normandie AS droit_artistique_total_ht_normandie_26, t0.personnel_total_ht AS personnel_total_ht_27, t0.personnel_total_ht_normandie AS personnel_total_ht_normandie_28, t0.interpretation_total_ht AS interpretation_total_ht_29, t0.interpretation_total_ht_normandie AS interpretation_total_ht_normandie_30, t0.charge_sociales_total_ht AS charge_sociales_total_ht_31, t0.charge_sociales_total_ht_normandie AS charge_sociales_total_ht_normandie_32, t0.deco_et_costumes_total_ht AS deco_et_costumes_total_ht_33, t0.deco_et_costumes_total_ht_normandie AS deco_et_costumes_total_ht_normandie_34, t0.transport_total_ht AS transport_total_ht_35, t0.transport_total_ht_normandie AS transport_total_ht_normandie_36, t0.moyen_technique_tournage_total_ht AS moyen_technique_tournage_total_ht_37, t0.pellicules_total_ht AS pellicules_total_ht_38, t0.moyen_technique_tournage_total_ht_normandie AS moyen_technique_tournage_total_ht_normandie_39, t0.pellicules_total_ht_normandie AS pellicules_total_ht_normandie_40, t0.assurance_et_frais_total_ht AS assurance_et_frais_total_ht_41, t0.assurance_et_frais_total_ht_normandie AS assurance_et_frais_total_ht_normandie_42, t0.total_partiel_total_ht AS total_partiel_total_ht_43, t0.total_partiel_total_ht_normandie AS total_partiel_total_ht_normandie_44, t0.total_general_total_ht AS total_general_total_ht_45, t0.total_general_total_ht_normandie AS total_general_total_ht_normandie_46, t0.financement_acquis AS financement_acquis_47, t0.financement_acquis_precision AS financement_acquis_precision_48, t0.depot_projet_collectivite AS depot_projet_collectivite_49, t0.depot_projet_collectivite_precision AS depot_projet_collectivite_precision_50, t0.projet_deja_presente_fonds_aide AS projet_deja_presente_fonds_aide_51, t0.projet_deja_presente_fonds_aide_date AS projet_deja_presente_fonds_aide_date_52, t0.projet_deja_presente_fonds_aide_type_aide AS projet_deja_presente_fonds_aide_type_aide_53, t0.genre_precision_autre AS genre_precision_autre_54, t0.adaptation_oeuvre_toa AS adaptation_oeuvre_toa_55, t0.adaptation_oeuvre_dacp AS adaptation_oeuvre_dacp_56, t0.adaptation_oeuvre_dfc AS adaptation_oeuvre_dfc_57, t0.montant_sollicite AS montant_sollicite_58, t0.montant_sollicite2 AS montant_sollicite2_59, t0.modified_at AS modified_at_60, t0.created_at AS created_at_61, t0.type_film AS type_film_62, t0.type_oeuvre AS type_oeuvre_63, t0.duree_episode AS duree_episode_64, t0.droit_artistiques_france AS droit_artistiques_france_65, t0.personnel_france AS personnel_france_66, t0.interpretation_france AS interpretation_france_67, t0.charge_sociale_france AS charge_sociale_france_68, t0.deco_et_costumes_france AS deco_et_costumes_france_69, t0.transport_france AS transport_france_70, t0.moyen_technique_france AS moyen_technique_france_71, t0.pellicules_france AS pellicules_france_72, t0.assurance_france AS assurance_france_73, t0.total_partiel_france AS total_partiel_france_74, t0.total_general_france AS total_general_france_75, t0.production_tv AS production_tv_76, t0.preachat_tv AS preachat_tv_77, t0.nombre_episode AS nombre_episode_78, t0.premier_film AS premier_film_79, t0.droit_artistique_cout_definitif AS droit_artistique_cout_definitif_80, t0.personnel_cout_definitif AS personnel_cout_definitif_81, t0.interpretation_cout_definitif AS interpretation_cout_definitif_82, t0.charge_sociales_cout_definitif AS charge_sociales_cout_definitif_83, t0.deco_et_costumes_cout_definitif AS deco_et_costumes_cout_definitif_84, t0.transport_cout_definitif AS transport_cout_definitif_85, t0.moyen_technique_cout_definitif AS moyen_technique_cout_definitif_86, t0.pellicules_cout_definitif AS pellicules_cout_definitif_87, t0.assurance_et_frais_cout_definitif AS assurance_et_frais_cout_definitif_88, t0.total_partiel_cout_definitif AS total_partiel_cout_definitif_89, t0.frais_generaux_cout_definitif AS frais_generaux_cout_definitif_90, t0.imprevus_cout_definitif AS imprevus_cout_definitif_91, t0.total_general_cout_definitif AS total_general_cout_definitif_92, t0.frais_generaux_total_ht AS frais_generaux_total_ht_93, t0.frais_generaux_depense_france AS frais_generaux_depense_france_94, t0.frais_generaux_normandie AS frais_generaux_normandie_95, t0.imprevus_depense_france AS imprevus_depense_france_96, t0.imprevus_normandie AS imprevus_normandie_97, t0.imprevus_total_ht AS imprevus_total_ht_98, t0.nombre_salarie_permanent AS nombre_salarie_permanent_99, t0.nombre_salarie_intermittent AS nombre_salarie_intermittent_100, t0.salarie_permenent_eqtemps AS salarie_permenent_eqtemps_101, t0.salarie_intermittentth AS salarie_intermittentth_102, t0.mt_total_programme_developpement AS mt_total_programme_developpement_103, t0.how_is_submitted AS how_is_submitted_104, t0.statut AS statut_105, t0.choix_img_diff_nouv_media AS choix_img_diff_nouv_media_106, t0.information_auteur AS information_auteur_107, t0.engagement_logo_region AS engagement_logo_region_108, t0.engagement_participation_region AS engagement_participation_region_109, t0.liste_realisateurs AS liste_realisateurs_110, t0.liste_scenaristes AS liste_scenaristes_111, t0.date_developpement AS date_developpement_112, t0.date_production AS date_production_113, t0.film_id_fk AS film_id_fk_114, t0.retrait AS retrait_115, t0.type_aide_doc AS type_aide_doc_116, t0.montant_aide_accordee AS montant_aide_accordee_117, t0.montant_aide_proposee AS montant_aide_proposee_118, t0.commission_lecture_date AS commission_lecture_date_119, t0.commission_lecture_lecteurs AS commission_lecture_lecteurs_120, t0.preselection_groupe AS preselection_groupe_121, t0.commission_lecture_avis AS commission_lecture_avis_122, t0.commission_pleniere_date AS commission_pleniere_date_123, t0.commission_pleniere_lecteurs AS commission_pleniere_lecteurs_124, t0.commission_pleniere_avis AS commission_pleniere_avis_125, t0.importation_date AS importation_date_126, t0.statut_complementaire AS statut_complementaire_127, t0.ordre_passage AS ordre_passage_128, t0.token_del AS token_del_129, t0.liste_productions_france AS liste_productions_france_130, t0.liste_productions_etrangeres AS liste_productions_etrangeres_131, t0.type_production AS type_production_132, t0.type_production_precision AS type_production_precision_133, t0.fabrication_envisagee AS fabrication_envisagee_134, t0.partenaires_envisages AS partenaires_envisages_135, t0.postes_tech_art_envisages AS postes_tech_art_envisages_136, t0.prod_deleguee_total_ht AS prod_deleguee_total_ht_137, t0.prod_deleguee_depense_france AS prod_deleguee_depense_france_138, t0.prod_deleguee_normandie AS prod_deleguee_normandie_139, t0.prod_deleguee_cout_definitif AS prod_deleguee_cout_definitif_140, t0.marge_total_ht AS marge_total_ht_141, t0.marge_depense_france AS marge_depense_france_142, t0.marge_normandie AS marge_normandie_143, t0.marge_cout_definitif AS marge_cout_definitif_144, t0.etape AS etape_145, t0.retire_abandon_motif AS retire_abandon_motif_146, t0.session_id AS session_id_147 FROM projet t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "717"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.08 ms
(9.49%) 		1 
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: 
[
  593
]
View formatted query    View runnable query    Explain query    View query backtrace
0.50 ms
(4.39%) 		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 = ?
Parameters: 
[
  459
]
View formatted query    View runnable query    Explain query    View query backtrace
0.41 ms
(3.62%) 		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 = ? LIMIT 1
Parameters: 
[
  26
]
View formatted query    View runnable query    Explain query    View query backtrace
0.38 ms
(3.36%) 		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: 
[
  717
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection
admin doctrine.dbal.admin_connection
fa doctrine.dbal.fa_connection
faold doctrine.dbal.faold_connection
prei doctrine.dbal.prei_connection
contacts doctrine.dbal.contacts_connection
projets doctrine.dbal.projets_connection
bilans doctrine.dbal.bilans_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
admin doctrine.orm.admin_entity_manager
fa doctrine.orm.fa_entity_manager
faold doctrine.orm.faold_entity_manager
prei doctrine.orm.prei_entity_manager
contacts doctrine.orm.contacts_entity_manager
projets doctrine.orm.projets_entity_manager
bilans doctrine.orm.bilans_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Main\User 1

admin entity manager

Class Amount of managed objects

fa entity manager

Class Amount of managed objects
App\Entity\Fa\AuteurRealisateur 2
App\Entity\Fa\Projet 1
App\Entity\Fa\Session 1
App\Entity\Fa\FondsAide 1
App\Entity\Fa\Production 1
App\Entity\Fa\Producteur 1
App\Entity\Fa\DocumentAudioVisuels 1

faold entity manager

Class Amount of managed objects

prei entity manager

Class Amount of managed objects

contacts entity manager

Class Amount of managed objects

projets entity manager

Class Amount of managed objects

bilans entity manager

Class Amount of managed objects

Entities Mapping

default entity manager

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

admin entity manager

No loaded entities.

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\Producteur No errors.

faold entity manager

No loaded entities.

prei entity manager

No loaded entities.

contacts entity manager

No loaded entities.

projets entity manager

No loaded entities.

bilans entity manager

No loaded entities.