Symfony Profiler

SELECT
  q0_.id AS id_0,
  q0_.title_fr AS title_fr_1,
  q0_.title_mg AS title_mg_2,
  q0_.slug AS slug_3,
  q0_.description_fr AS description_fr_4,
  q0_.description_mg AS description_mg_5,
  q0_.glossary_fr AS glossary_fr_6,
  q0_.glossary_mg AS glossary_mg_7,
  q0_.active AS active_8,
  q0_.opens_at AS opens_at_9,
  q0_.closes_at AS closes_at_10,
  q0_.created_at AS created_at_11,
  q0_.updated_at AS updated_at_12
FROM
  questionnaire q0_
WHERE
  q0_.active = 1
ORDER BY
  q0_.created_at DESC
LIMIT
  1

SELECT q0_.id AS id_0, q0_.title_fr AS title_fr_1, q0_.title_mg AS title_mg_2, q0_.slug AS slug_3, q0_.description_fr AS description_fr_4, q0_.description_mg AS description_mg_5, q0_.glossary_fr AS glossary_fr_6, q0_.glossary_mg AS glossary_mg_7, q0_.active AS active_8, q0_.opens_at AS opens_at_9, q0_.closes_at AS closes_at_10, q0_.created_at AS created_at_11, q0_.updated_at AS updated_at_12 FROM questionnaire q0_ WHERE q0_.active = 1 ORDER BY q0_.created_at DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.title_fr AS title_fr_3,
  t0.title_mg AS title_mg_4,
  t0.description_fr AS description_fr_5,
  t0.description_mg AS description_mg_6,
  t0.position AS position_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.questionnaire_id AS questionnaire_id_10
FROM
  axe t0
WHERE
  t0.questionnaire_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.code AS code_2, t0.title_fr AS title_fr_3, t0.title_mg AS title_mg_4, t0.description_fr AS description_fr_5, t0.description_mg AS description_mg_6, t0.position AS position_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.questionnaire_id AS questionnaire_id_10 FROM axe t0 WHERE t0.questionnaire_id = 1 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.text_fr AS text_fr_3,
  t0.text_mg AS text_mg_4,
  t0.hint_fr AS hint_fr_5,
  t0.hint_mg AS hint_mg_6,
  t0.allow_other AS allow_other_7,
  t0.follow_fr AS follow_fr_8,
  t0.follow_mg AS follow_mg_9,
  t0.follow_on AS follow_on_10,
  t0.show_glossary AS show_glossary_11,
  t0.yes_label_fr AS yes_label_fr_12,
  t0.yes_label_mg AS yes_label_mg_13,
  t0.no_label_fr AS no_label_fr_14,
  t0.no_label_mg AS no_label_mg_15,
  t0.weight AS weight_16,
  t0.required AS required_17,
  t0.position AS position_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.axe_id AS axe_id_21,
  t0.sous_axe_id AS sous_axe_id_22
FROM
  question t0
WHERE
  t0.axe_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.text_fr AS text_fr_3, t0.text_mg AS text_mg_4, t0.hint_fr AS hint_fr_5, t0.hint_mg AS hint_mg_6, t0.allow_other AS allow_other_7, t0.follow_fr AS follow_fr_8, t0.follow_mg AS follow_mg_9, t0.follow_on AS follow_on_10, t0.show_glossary AS show_glossary_11, t0.yes_label_fr AS yes_label_fr_12, t0.yes_label_mg AS yes_label_mg_13, t0.no_label_fr AS no_label_fr_14, t0.no_label_mg AS no_label_mg_15, t0.weight AS weight_16, t0.required AS required_17, t0.position AS position_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.axe_id AS axe_id_21, t0.sous_axe_id AS sous_axe_id_22 FROM question t0 WHERE t0.axe_id = 1 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.text_fr AS text_fr_3,
  t0.text_mg AS text_mg_4,
  t0.hint_fr AS hint_fr_5,
  t0.hint_mg AS hint_mg_6,
  t0.allow_other AS allow_other_7,
  t0.follow_fr AS follow_fr_8,
  t0.follow_mg AS follow_mg_9,
  t0.follow_on AS follow_on_10,
  t0.show_glossary AS show_glossary_11,
  t0.yes_label_fr AS yes_label_fr_12,
  t0.yes_label_mg AS yes_label_mg_13,
  t0.no_label_fr AS no_label_fr_14,
  t0.no_label_mg AS no_label_mg_15,
  t0.weight AS weight_16,
  t0.required AS required_17,
  t0.position AS position_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.axe_id AS axe_id_21,
  t0.sous_axe_id AS sous_axe_id_22
FROM
  question t0
WHERE
  t0.axe_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.text_fr AS text_fr_3, t0.text_mg AS text_mg_4, t0.hint_fr AS hint_fr_5, t0.hint_mg AS hint_mg_6, t0.allow_other AS allow_other_7, t0.follow_fr AS follow_fr_8, t0.follow_mg AS follow_mg_9, t0.follow_on AS follow_on_10, t0.show_glossary AS show_glossary_11, t0.yes_label_fr AS yes_label_fr_12, t0.yes_label_mg AS yes_label_mg_13, t0.no_label_fr AS no_label_fr_14, t0.no_label_mg AS no_label_mg_15, t0.weight AS weight_16, t0.required AS required_17, t0.position AS position_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.axe_id AS axe_id_21, t0.sous_axe_id AS sous_axe_id_22 FROM question t0 WHERE t0.axe_id = 2 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.text_fr AS text_fr_3,
  t0.text_mg AS text_mg_4,
  t0.hint_fr AS hint_fr_5,
  t0.hint_mg AS hint_mg_6,
  t0.allow_other AS allow_other_7,
  t0.follow_fr AS follow_fr_8,
  t0.follow_mg AS follow_mg_9,
  t0.follow_on AS follow_on_10,
  t0.show_glossary AS show_glossary_11,
  t0.yes_label_fr AS yes_label_fr_12,
  t0.yes_label_mg AS yes_label_mg_13,
  t0.no_label_fr AS no_label_fr_14,
  t0.no_label_mg AS no_label_mg_15,
  t0.weight AS weight_16,
  t0.required AS required_17,
  t0.position AS position_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.axe_id AS axe_id_21,
  t0.sous_axe_id AS sous_axe_id_22
FROM
  question t0
WHERE
  t0.axe_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.text_fr AS text_fr_3, t0.text_mg AS text_mg_4, t0.hint_fr AS hint_fr_5, t0.hint_mg AS hint_mg_6, t0.allow_other AS allow_other_7, t0.follow_fr AS follow_fr_8, t0.follow_mg AS follow_mg_9, t0.follow_on AS follow_on_10, t0.show_glossary AS show_glossary_11, t0.yes_label_fr AS yes_label_fr_12, t0.yes_label_mg AS yes_label_mg_13, t0.no_label_fr AS no_label_fr_14, t0.no_label_mg AS no_label_mg_15, t0.weight AS weight_16, t0.required AS required_17, t0.position AS position_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.axe_id AS axe_id_21, t0.sous_axe_id AS sous_axe_id_22 FROM question t0 WHERE t0.axe_id = 3 ORDER BY t0.position ASC;

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  submission s0_
WHERE
  s0_.status <> ?

SELECT COUNT(s0_.id) AS sclr_0 FROM submission s0_ WHERE s0_.status <> 'draft';

SELECT
  COUNT(DISTINCT s0_.region_id) AS sclr_0
FROM
  submission s0_
WHERE
  s0_.status <> ?

SELECT COUNT(DISTINCT s0_.region_id) AS sclr_0 FROM submission s0_ WHERE s0_.status <> 'draft';