Query Metrics
10
Database Queries
10
Different statements
9.95 ms
Query time
4
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.93 ms |
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"
]
|
2 | 0.63 ms |
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
]
|
3 | 2.87 ms |
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 ] |
4 | 0.65 ms |
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 ] |
5 | 0.64 ms |
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
]
|
6 | 0.54 ms |
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 ] |
7 | 2.01 ms |
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 ] |
8 | 0.53 ms |
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
]
|
9 | 0.50 ms |
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
]
|
10 | 0.64 ms |
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
]
|
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 |
|
App\Entity\Accompanist | No errors. |
App\Entity\User | No errors. |
App\Entity\CompanyMember |
|
App\Entity\Evaluation | No errors. |
App\Entity\Objective |
|
App\Entity\CompanyQuestionnaire |
|
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. |
App\Entity\PasswordHistory | No errors. |
App\Entity\Action | No errors. |
App\Entity\CompanyIndicator | No errors. |
App\Entity\LabelNR | No errors. |
App\Entity\CompanyLabelNRAxe | No errors. |
App\Entity\CompanyAuditNRAxe | No errors. |
App\Entity\Indicator | No errors. |
App\Entity\BCModele | No errors. |