Error 500 Internal Server Error

GET https://responsable.bilbea.fr/pdf/sensibilisation/19/15

Query Metrics

10 Database Queries
10 Different statements
9.65 ms Query time
4 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.73 ms
(28.26%)
1
SELECT t0.id AS id_1, t0.choice AS choice_2, t0.comment AS comment_3, t0.evaluation_id AS evaluation_id_4, t0.question_id AS question_id_5 FROM evaluation_answer t0 WHERE t0.evaluation_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  159
  160
  161
  162
  163
  164
  165
  169
  170
  171
  181
  182
  184
]
2.11 ms
(21.88%)
1
SELECT t0.id AS id_1, t0.short_name AS short_name_2, t0.question AS question_3, t0.description AS description_4, t0.sub_thematic_id AS sub_thematic_id_5 FROM question t0 WHERE t0.sub_thematic_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  17
  18
  19
  20
  21
  22
  23
  24
  25
  26
  27
  28
  29
  30
  31
  32
  33
  34
  35
  36
  37
]
0.87 ms
(9.05%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.enter_program AS enter_program_3, t0.updated_at AS updated_at_4, t0.logo AS logo_5, t0.label_nr AS label_nr_6, t0.bilan_carbone AS bilan_carbone_7, t0.audit_nr AS audit_nr_8, t0.training AS training_9, t0.accompanist_id AS accompanist_id_10, t0.last_updator_id AS last_updator_id_11 FROM company t0 WHERE t0.id = ?
Parameters:
[
  "19"
]
0.68 ms
(7.05%)
1
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.user_id AS user_id_3, t0.evaluation_id AS evaluation_id_4 FROM edit_evaluation_history t0 WHERE t0.evaluation_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  159
  160
  161
  162
  163
  164
  165
  169
  170
  171
  181
  182
  184
]
0.67 ms
(6.91%)
1
SELECT t0.id AS id_1, t0.company_id AS company_id_2, t0.thematic_id AS thematic_id_3, t0.questionnaire_id AS questionnaire_id_4, t5.id AS id_6, t5.name AS name_7, t5.thematic_id AS thematic_id_8 FROM company_questionnaire t0 INNER JOIN questionnaire t5 ON t0.questionnaire_id = t5.id WHERE t0.company_id IN (?)
Parameters:
[
  19
]
0.58 ms
(6.01%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.questionnaire_id AS questionnaire_id_3 FROM sub_thematic t0 WHERE t0.questionnaire_id IN (?, ?, ?, ?)
Parameters:
[
  4
  5
  6
  7
]
0.57 ms
(5.86%)
1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.company_id AS company_id_3, t0.questionnaire_id AS questionnaire_id_4, t0.author_id AS author_id_5 FROM evaluation t0 WHERE t0.company_id IN (?)
Parameters:
[
  19
]
0.52 ms
(5.44%)
1
SELECT t0.id AS id_1, t0.depreciation AS depreciation_2, t0.consommation AS consommation_3, t0.quantity_new AS quantity_new_4, t0.quantity_occasion AS quantity_occasion_5, t0.comment AS comment_6, t0.facteur_id AS facteur_id_7, t0.bccompany_id AS bccompany_id_8, t0.mix_id AS mix_id_9 FROM bcdata t0 WHERE t0.bccompany_id IN (?)
Parameters:
[
  20
]
0.48 ms
(5.01%)
1
SELECT t0.id AS id_1, t0.started_at AS started_at_2, t0.end_at AS end_at_3, t0.active AS active_4, t0.company_id AS company_id_5 FROM membership t0 WHERE t0.company_id IN (?)
Parameters:
[
  19
]
0.44 ms
(4.53%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.type AS type_4, t0.company_id AS company_id_5, t0.base_id AS base_id_6 FROM bccompany t0 WHERE t0.company_id IN (?)
Parameters:
[
  19
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Company
  • The mappings App\Entity\Company#objectives and App\Entity\Objective#company are inconsistent with each other.
App\Entity\Accompanist No errors.
App\Entity\User No errors.
App\Entity\CompanyMember
  • The association App\Entity\CompanyMember#evaluations refers to the owning side field App\Entity\Evaluation#companyMember which does not exist.
App\Entity\Evaluation No errors.
App\Entity\Objective
  • The association App\Entity\Objective#company refers to the inverse side field App\Entity\Company#actions which does not exist.
App\Entity\CompanyQuestionnaire
  • The association App\Entity\CompanyQuestionnaire#thematic refers to the inverse side field App\Entity\Thematic#companyQuestionnaires which does not exist.
App\Entity\CompanyIndicatorThematic No errors.
App\Entity\Membership No errors.
App\Entity\BCCompany No errors.
App\Entity\CompanyLabelNR No errors.
App\Entity\CompanyAuditNR No errors.
App\Entity\Questionnaire No errors.
App\Entity\EvaluationAnswer No errors.
App\Entity\EditEvaluationHistory No errors.
App\Entity\Question No errors.
App\Entity\Thematic No errors.
App\Entity\SubThematic No errors.
App\Entity\BCData No errors.
App\Entity\BCFacteur No errors.
App\Entity\BCMix No errors.