Query Metrics
71
Database Queries
11
Different statements
36.61 ms
Query time
4
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
14.05 ms (38.38%) |
25 |
SELECT t0.id AS id_1, t0.impact_global AS impact_global_2, t0.impact_mp AS impact_mp_3, t0.impact_appro AS impact_appro_4, t0.impact_mise_en_forme AS impact_mise_en_forme_5, t0.impact_assemblage AS impact_assemblage_6, t0.impact_distribution AS impact_distribution_7, t0.source AS source_8, t0.incertitude AS incertitude_9, t0.version AS version_10, t0.created_at AS created_at_11, t0.date AS date_12, t0.bcmodele_id AS bcmodele_id_13 FROM bcfacteur t0 WHERE t0.id = ?
Parameters:
[
18
]
|
10.63 ms (29.04%) |
25 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.bctype_id AS bctype_id_3 FROM bcmodele t0 WHERE t0.id = ?
Parameters:
[
18
]
|
5.86 ms (16.01%) |
13 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.bcfamille_id AS bcfamille_id_3 FROM bctype t0 WHERE t0.id = ?
Parameters:
[
6
]
|
1.09 ms (2.99%) |
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:
[
"43"
]
|
0.97 ms (2.66%) |
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:
[
24
]
|
0.93 ms (2.54%) |
1 |
SELECT t0.id AS id_1, t0.country AS country_2, t0.coefficient AS coefficient_3, t0.incertitude AS incertitude_4, t0.source AS source_5, t0.type AS type_6 FROM bcmix t0 WHERE t0.id = ?
Parameters:
[
4
]
|
0.63 ms (1.73%) |
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:
[
43
]
|
0.63 ms (1.72%) |
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:
[
43
]
|
0.62 ms (1.69%) |
1 |
SELECT t0.id AS id_1, t0.plural_name AS plural_name_2, t0.singular_name AS singular_name_3 FROM bcfamille t0
Parameters:
[] |
0.60 ms (1.65%) |
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:
[
43
]
|
0.58 ms (1.58%) |
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:
[
43
]
|
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\Thematic | No errors. |
App\Entity\BCData | No errors. |
App\Entity\BCFacteur | No errors. |
App\Entity\BCMix | No errors. |
App\Entity\BCFamille | No errors. |
App\Entity\BCType | No errors. |
App\Entity\BCModele | No errors. |
App\Entity\PasswordHistory | No errors. |
App\Entity\EvaluationAnswer | No errors. |
App\Entity\EditEvaluationHistory | 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\SubThematic | No errors. |
App\Entity\Indicator | No errors. |