Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception 1
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 4
• Debug
• Messages
• E-mails
• Notifications
• Serializer
• Configuration

Query Metrics

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  159
  160
  161
  162
  163
  164
  165
  169
  170
  171
  181
  182
  184
]

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

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 (159, 160, 161, 162, 163, 164, 165, 169, 170, 171, 181, 182, 184);

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 = ?

[
  "19"
]

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 = ?

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 = '19';

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  17
  18
  19
  20
  21
  22
  23
  24
  25
  26
  27
  28
  29
  30
  31
  32
  33
  34
  35
  36
  37
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?
  )

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 (17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37);

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 (?)

[
  19
]

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 (?)

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 (19);

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 (?)

[
  19
]

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 (?)

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 (19);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  159
  160
  161
  162
  163
  164
  165
  169
  170
  171
  181
  182
  184
]

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

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 (159, 160, 161, 162, 163, 164, 165, 169, 170, 171, 181, 182, 184);

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 (?)

[
  20
]

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 (?)

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 (20);

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 (?)

[
  19
]

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 (?)

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 (19);

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 (?, ?, ?, ?)

[
  4
  5
  6
  7
]

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 (?, ?, ?, ?)

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 (4, 5, 6, 7);

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 (?)

[
  19
]

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 (?)

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 (19);