https://gunsmoke.gs-prod.fr/pdf/ndf?date_ndf=2025-04&id_projet=223&id_salarie=1825

Forwarded to
ErrorController (9ab831)
Method
GET
HTTP Status
500
IP
192.168.2.20
Profiled on
Token
22c1a2

Query Metrics

34 Database Queries
15 Different statements
20.79 ms Query time
0 Invalid entities

Queries

Group similar statements

admin connection

#▲ Time Info
1 0.62 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.id_role AS id_role_4, t0.password AS password_5, t0.id_tiers AS id_tiers_6, t0.date_crea AS date_crea_7, t0.user_crea AS user_crea_8, t0.date_modif AS date_modif_9, t0.user_modif AS user_modif_10, t0.password_requested_at AS password_requested_at_11, t0.token AS token_12, t0.avatar_user AS avatar_user_13, t0.theme_user AS theme_user_14, t0.is_active AS is_active_15, t0.tiers_id AS tiers_id_16 FROM user t0 WHERE t0.id = ?
Parameters: 
[
  15
]
View formatted query    View runnable query    Explain query

dev connection

#▲ Time Info
1 0.75 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.id_role AS id_role_4, t0.password AS password_5, t0.id_tiers AS id_tiers_6, t0.date_crea AS date_crea_7, t0.user_crea AS user_crea_8, t0.date_modif AS date_modif_9, t0.user_modif AS user_modif_10, t0.password_requested_at AS password_requested_at_11, t0.token AS token_12, t0.avatar_user AS avatar_user_13, t0.theme_user AS theme_user_14, t0.is_active AS is_active_15, t0.tiers_id AS tiers_id_16 FROM user t0 WHERE t0.id = ?
Parameters: 
[
  15
]
View formatted query    View runnable query    Explain query

gunsmoke connection

#▲ Time Info
1 0.79 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.id_role AS id_role_4, t0.password AS password_5, t0.id_tiers AS id_tiers_6, t0.date_crea AS date_crea_7, t0.user_crea AS user_crea_8, t0.date_modif AS date_modif_9, t0.user_modif AS user_modif_10, t0.password_requested_at AS password_requested_at_11, t0.token AS token_12, t0.avatar_user AS avatar_user_13, t0.theme_user AS theme_user_14, t0.is_active AS is_active_15, t0.tiers_id AS tiers_id_16 FROM user t0 WHERE t0.id = ?
Parameters: 
[
  15
]
View formatted query    View runnable query    Explain query
2 1.54 ms 
SELECT d0_.id AS id_0, d0_.type_document AS type_document_1, d0_.statut AS statut_2, d0_.reference AS reference_3, d0_.num_piece AS num_piece_4, d0_.date_crea AS date_crea_5, d0_.user_crea AS user_crea_6, d0_.date_modif AS date_modif_7, d0_.user_modif AS user_modif_8, d0_.montant_ht AS montant_ht_9, d0_.montant_tva AS montant_tva_10, d0_.date_envoi AS date_envoi_11, d0_.date_paiement AS date_paiement_12, d0_.contact AS contact_13, d0_.id_doc_origine AS id_doc_origine_14, d0_.commentaire AS commentaire_15, d0_.date_bdc AS date_bdc_16, d0_.lib_projet AS lib_projet_17, d0_.date_ndf AS date_ndf_18, d0_.libelle AS libelle_19, d0_.condition_reglement AS condition_reglement_20, d0_.projet_id AS projet_id_21, d0_.tiers_id AS tiers_id_22, d0_.adresse_id AS adresse_id_23, d0_.salarie_id AS salarie_id_24 FROM document d0_ LEFT JOIN projet p1_ ON d0_.projet_id = p1_.id WHERE d0_.projet_id = ? AND d0_.salarie_id = ? AND d0_.date_ndf LIKE ? ORDER BY d0_.date_crea ASC
Parameters: 
[
  "223"
  "1825"
  "2025-04%"
]
View formatted query    View runnable query    Explain query
3 0.54 ms 
SELECT t0.id AS id_1, t0.num_prod AS num_prod_2, t0.num_administratif AS num_administratif_3, t0.lib_projet AS lib_projet_4, t0.type_projet AS type_projet_5, t0.date_deb AS date_deb_6, t0.date_fin AS date_fin_7, t0.date_crea AS date_crea_8, t0.user_crea AS user_crea_9, t0.date_modif AS date_modif_10, t0.user_modif AS user_modif_11, t0.is_active AS is_active_12, t0.commentaire AS commentaire_13, t0.is_appel_offre AS is_appel_offre_14, t0.societe_id AS societe_id_15, t0.producteur_id AS producteur_id_16, t0.tiers_id AS tiers_id_17, t0.statut_id AS statut_id_18 FROM projet t0 WHERE t0.id = ?
Parameters: 
[
  223
]
View formatted query    View runnable query    Explain query
4 0.76 ms 
SELECT t0.id AS id_1, t0.nom_tiers AS nom_tiers_2, t0.prenom_tiers AS prenom_tiers_3, t0.tel_fixe_tiers AS tel_fixe_tiers_4, t0.tel_portable_tiers AS tel_portable_tiers_5, t0.email_tiers AS email_tiers_6, t0.commentaire_tiers AS commentaire_tiers_7, t0.date_crea AS date_crea_8, t0.user_crea AS user_crea_9, t0.date_modif AS date_modif_10, t0.user_modif AS user_modif_11, t0.is_active AS is_active_12, t0.id_type_tiers AS id_type_tiers_13, t14.id AS id_15, t14.email AS email_16, t14.roles AS roles_17, t14.id_role AS id_role_18, t14.password AS password_19, t14.id_tiers AS id_tiers_20, t14.date_crea AS date_crea_21, t14.user_crea AS user_crea_22, t14.date_modif AS date_modif_23, t14.user_modif AS user_modif_24, t14.password_requested_at AS password_requested_at_25, t14.token AS token_26, t14.avatar_user AS avatar_user_27, t14.theme_user AS theme_user_28, t14.is_active AS is_active_29, t14.tiers_id AS tiers_id_30, t0.info_salarie_id AS info_salarie_id_31 FROM tiers t0 LEFT JOIN user t14 ON t14.tiers_id = t0.id WHERE t0.id = ?
Parameters: 
[
  1825
]
View formatted query    View runnable query    Explain query
5 0.60 ms 
SELECT t0.id AS id_1, t0.classe_societe AS classe_societe_2, t0.lib_societe AS lib_societe_3, t0.type_societe AS type_societe_4, t0.sigle_societe AS sigle_societe_5, t0.nb_historique_projet AS nb_historique_projet_6, t0.date_crea AS date_crea_7, t0.user_crea AS user_crea_8, t0.date_modif AS date_modif_9, t0.user_modif AS user_modif_10, t0.is_active AS is_active_11, t0.num_tva AS num_tva_12, t0.condition_reglement AS condition_reglement_13 FROM societe t0 WHERE t0.id = ?
Parameters: 
[
  1029
]
View formatted query    View runnable query    Explain query
6 0.55 ms 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.montant_ht AS montant_ht_4, t0.taux_tva AS taux_tva_5, t0.montant_tva AS montant_tva_6, t0.date_crea AS date_crea_7, t0.user_crea AS user_crea_8, t0.date_modif AS date_modif_9, t0.user_modif AS user_modif_10, t0.qte AS qte_11, t0.puht AS puht_12, t0.document_id AS document_id_13 FROM document_ligne t0 WHERE t0.document_id = ?
Parameters: 
[
  3233
]
View formatted query    View runnable query    Explain query
7 0.41 ms 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.montant_ht AS montant_ht_4, t0.taux_tva AS taux_tva_5, t0.montant_tva AS montant_tva_6, t0.date_crea AS date_crea_7, t0.user_crea AS user_crea_8, t0.date_modif AS date_modif_9, t0.user_modif AS user_modif_10, t0.qte AS qte_11, t0.puht AS puht_12, t0.document_id AS document_id_13 FROM document_ligne t0 WHERE t0.document_id = ?
Parameters: 
[
  3237
]
View formatted query    View runnable query    Explain query
8 0.39 ms 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.montant_ht AS montant_ht_4, t0.taux_tva AS taux_tva_5, t0.montant_tva AS montant_tva_6, t0.date_crea AS date_crea_7, t0.user_crea AS user_crea_8, t0.date_modif AS date_modif_9, t0.user_modif AS user_modif_10, t0.qte AS qte_11, t0.puht AS puht_12, t0.document_id AS document_id_13 FROM document_ligne t0 WHERE t0.document_id = ?
Parameters: 
[
  3269
]
View formatted query    View runnable query    Explain query
9 0.37 ms 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.montant_ht AS montant_ht_4, t0.taux_tva AS taux_tva_5, t0.montant_tva AS montant_tva_6, t0.date_crea AS date_crea_7, t0.user_crea AS user_crea_8, t0.date_modif AS date_modif_9, t0.user_modif AS user_modif_10, t0.qte AS qte_11, t0.puht AS puht_12, t0.document_id AS document_id_13 FROM document_ligne t0 WHERE t0.document_id = ?
Parameters: 
[
  3363
]
View formatted query    View runnable query    Explain query
10 0.37 ms 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.montant_ht AS montant_ht_4, t0.taux_tva AS taux_tva_5, t0.montant_tva AS montant_tva_6, t0.date_crea AS date_crea_7, t0.user_crea AS user_crea_8, t0.date_modif AS date_modif_9, t0.user_modif AS user_modif_10, t0.qte AS qte_11, t0.puht AS puht_12, t0.document_id AS document_id_13 FROM document_ligne t0 WHERE t0.document_id = ?
Parameters: 
[
  3366
]
View formatted query    View runnable query    Explain query
11 0.38 ms 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.montant_ht AS montant_ht_4, t0.taux_tva AS taux_tva_5, t0.montant_tva AS montant_tva_6, t0.date_crea AS date_crea_7, t0.user_crea AS user_crea_8, t0.date_modif AS date_modif_9, t0.user_modif AS user_modif_10, t0.qte AS qte_11, t0.puht AS puht_12, t0.document_id AS document_id_13 FROM document_ligne t0 WHERE t0.document_id = ?
Parameters: 
[
  3367
]
View formatted query    View runnable query    Explain query
12 0.39 ms 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.montant_ht AS montant_ht_4, t0.taux_tva AS taux_tva_5, t0.montant_tva AS montant_tva_6, t0.date_crea AS date_crea_7, t0.user_crea AS user_crea_8, t0.date_modif AS date_modif_9, t0.user_modif AS user_modif_10, t0.qte AS qte_11, t0.puht AS puht_12, t0.document_id AS document_id_13 FROM document_ligne t0 WHERE t0.document_id = ?
Parameters: 
[
  3368
]
View formatted query    View runnable query    Explain query
13 0.38 ms 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.montant_ht AS montant_ht_4, t0.taux_tva AS taux_tva_5, t0.montant_tva AS montant_tva_6, t0.date_crea AS date_crea_7, t0.user_crea AS user_crea_8, t0.date_modif AS date_modif_9, t0.user_modif AS user_modif_10, t0.qte AS qte_11, t0.puht AS puht_12, t0.document_id AS document_id_13 FROM document_ligne t0 WHERE t0.document_id = ?
Parameters: 
[
  3369
]
View formatted query    View runnable query    Explain query
14 0.37 ms 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.montant_ht AS montant_ht_4, t0.taux_tva AS taux_tva_5, t0.montant_tva AS montant_tva_6, t0.date_crea AS date_crea_7, t0.user_crea AS user_crea_8, t0.date_modif AS date_modif_9, t0.user_modif AS user_modif_10, t0.qte AS qte_11, t0.puht AS puht_12, t0.document_id AS document_id_13 FROM document_ligne t0 WHERE t0.document_id = ?
Parameters: 
[
  3370
]
View formatted query    View runnable query    Explain query
15 0.38 ms 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.montant_ht AS montant_ht_4, t0.taux_tva AS taux_tva_5, t0.montant_tva AS montant_tva_6, t0.date_crea AS date_crea_7, t0.user_crea AS user_crea_8, t0.date_modif AS date_modif_9, t0.user_modif AS user_modif_10, t0.qte AS qte_11, t0.puht AS puht_12, t0.document_id AS document_id_13 FROM document_ligne t0 WHERE t0.document_id = ?
Parameters: 
[
  3371
]
View formatted query    View runnable query    Explain query
16 0.38 ms 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.montant_ht AS montant_ht_4, t0.taux_tva AS taux_tva_5, t0.montant_tva AS montant_tva_6, t0.date_crea AS date_crea_7, t0.user_crea AS user_crea_8, t0.date_modif AS date_modif_9, t0.user_modif AS user_modif_10, t0.qte AS qte_11, t0.puht AS puht_12, t0.document_id AS document_id_13 FROM document_ligne t0 WHERE t0.document_id = ?
Parameters: 
[
  3396
]
View formatted query    View runnable query    Explain query
17 0.40 ms 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.montant_ht AS montant_ht_4, t0.taux_tva AS taux_tva_5, t0.montant_tva AS montant_tva_6, t0.date_crea AS date_crea_7, t0.user_crea AS user_crea_8, t0.date_modif AS date_modif_9, t0.user_modif AS user_modif_10, t0.qte AS qte_11, t0.puht AS puht_12, t0.document_id AS document_id_13 FROM document_ligne t0 WHERE t0.document_id = ?
Parameters: 
[
  3397
]
View formatted query    View runnable query    Explain query
18 0.38 ms 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.montant_ht AS montant_ht_4, t0.taux_tva AS taux_tva_5, t0.montant_tva AS montant_tva_6, t0.date_crea AS date_crea_7, t0.user_crea AS user_crea_8, t0.date_modif AS date_modif_9, t0.user_modif AS user_modif_10, t0.qte AS qte_11, t0.puht AS puht_12, t0.document_id AS document_id_13 FROM document_ligne t0 WHERE t0.document_id = ?
Parameters: 
[
  3398
]
View formatted query    View runnable query    Explain query
19 0.40 ms 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.montant_ht AS montant_ht_4, t0.taux_tva AS taux_tva_5, t0.montant_tva AS montant_tva_6, t0.date_crea AS date_crea_7, t0.user_crea AS user_crea_8, t0.date_modif AS date_modif_9, t0.user_modif AS user_modif_10, t0.qte AS qte_11, t0.puht AS puht_12, t0.document_id AS document_id_13 FROM document_ligne t0 WHERE t0.document_id = ?
Parameters: 
[
  3402
]
View formatted query    View runnable query    Explain query

default connection

#▲ Time Info
1 0.28 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 0.83 ms 
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters: 
[
  "gsprod_admin"
]
View formatted query    View runnable query    Explain query
3 0.20 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
4 0.67 ms 
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters: 
[
  "gsprod_admin"
]
View formatted query    View runnable query    Explain query
5 0.20 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
6 1.23 ms 
SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
            ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters: 
[
  "gsprod_admin"
  "doctrine_migration_versions"
]
View formatted query    View runnable query    Explain query
7 0.22 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
8 3.01 ms 
SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'gsprod_admin' */ ORDER BY k.ORDINAL_POSITION
Parameters: 
[
  "gsprod_admin"
  "doctrine_migration_versions"
]
View formatted query    View runnable query    Explain query
9 1.57 ms 
SELECT       c.COLUMN_NAME        AS field,
       c.COLUMN_TYPE       AS TYPE,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS COMMENT,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS COLLATION
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters: 
[
  "gsprod_admin"
  "gsprod_admin"
  "doctrine_migration_versions"
]
View formatted query    View runnable query    Explain query
10 0.22 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
11 0.60 ms 
SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
Parameters: 
[
  "gsprod_admin"
  "doctrine_migration_versions"
]
View formatted query    View runnable query    Explain query
12 0.30 ms 
SELECT * FROM doctrine_migration_versions
Parameters: 
[]
View formatted query    View runnable query    Explain query
13 0.30 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection
admin doctrine.dbal.admin_connection
dev doctrine.dbal.dev_connection
gunsmoke doctrine.dbal.gunsmoke_connection
foodandcurious doctrine.dbal.foodandcurious_connection
butterjam doctrine.dbal.butterjam_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
admin doctrine.orm.admin_entity_manager
dev doctrine.orm.dev_entity_manager
gunsmoke doctrine.orm.gunsmoke_entity_manager
foodandcurious doctrine.orm.foodandcurious_entity_manager
butterjam doctrine.orm.butterjam_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

No loaded entities.

admin entity manager

Class Mapping errors
App\Entity\User No errors.
App\Entity\Tiers No errors.
App\Entity\Adresse No errors.
App\Entity\InfoSalarie No errors.
App\Entity\Societe No errors.
App\Entity\Projet No errors.
App\Entity\Contrat No errors.
App\Entity\Document No errors.

dev entity manager

Class Mapping errors
App\Entity\User No errors.
App\Entity\Tiers No errors.
App\Entity\Adresse No errors.
App\Entity\InfoSalarie No errors.
App\Entity\Societe No errors.
App\Entity\Projet No errors.
App\Entity\Contrat No errors.
App\Entity\Document No errors.

gunsmoke entity manager

Class Mapping errors
App\Entity\User No errors.
App\Entity\Tiers No errors.
App\Entity\Document No errors.
App\Entity\Projet No errors.
App\Entity\Societe No errors.
App\Entity\Adresse No errors.
App\Entity\DocumentLigne No errors.
App\Entity\LdvStatutProjet No errors.
App\Entity\InfoSalarie No errors.
App\Entity\Contrat No errors.

foodandcurious entity manager

No loaded entities.

butterjam entity manager

No loaded entities.