Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Emails
• JMS Serializer 0 + 0
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = ? LIMIT 1

[
  "M_DEF_Q"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3
FROM
  configuration t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = 'M_DEF_Q' LIMIT 1;

SELECT t0.id AS id_1, t0.display AS display_2, t0.separate AS separate_3, t0.template AS template_4, t0.disposition AS disposition_5, t0.nbr_parts_survey AS nbr_parts_survey_6, t0.nbr_parts_survey_block AS nbr_parts_survey_block_7, t0.nbr_parts_survey_home AS nbr_parts_survey_home_8, t0.extra_display AS extra_display_9, t0.block_display AS block_display_10, t0.home_display AS home_display_11, t0.footer_display AS footer_display_12, t0.playable_block AS playable_block_13, t0.playable_home AS playable_home_14, t0.display_good_responses AS display_good_responses_15, t0.group_good_responses AS group_good_responses_16, t0.questionnaire_id AS questionnaire_id_17 FROM front t0 WHERE t0.questionnaire_id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.display AS display_2,
  t0.separate AS separate_3,
  t0.template AS template_4,
  t0.disposition AS disposition_5,
  t0.nbr_parts_survey AS nbr_parts_survey_6,
  t0.nbr_parts_survey_block AS nbr_parts_survey_block_7,
  t0.nbr_parts_survey_home AS nbr_parts_survey_home_8,
  t0.extra_display AS extra_display_9,
  t0.block_display AS block_display_10,
  t0.home_display AS home_display_11,
  t0.footer_display AS footer_display_12,
  t0.playable_block AS playable_block_13,
  t0.playable_home AS playable_home_14,
  t0.display_good_responses AS display_good_responses_15,
  t0.group_good_responses AS group_good_responses_16,
  t0.questionnaire_id AS questionnaire_id_17
FROM
  front t0
WHERE
  t0.questionnaire_id = ?

SELECT t0.id AS id_1, t0.display AS display_2, t0.separate AS separate_3, t0.template AS template_4, t0.disposition AS disposition_5, t0.nbr_parts_survey AS nbr_parts_survey_6, t0.nbr_parts_survey_block AS nbr_parts_survey_block_7, t0.nbr_parts_survey_home AS nbr_parts_survey_home_8, t0.extra_display AS extra_display_9, t0.block_display AS block_display_10, t0.home_display AS home_display_11, t0.footer_display AS footer_display_12, t0.playable_block AS playable_block_13, t0.playable_home AS playable_home_14, t0.display_good_responses AS display_good_responses_15, t0.group_good_responses AS group_good_responses_16, t0.questionnaire_id AS questionnaire_id_17 FROM front t0 WHERE t0.questionnaire_id = 1;

SELECT t0.id AS id_1, t0.participants AS participants_2, t0.ip_test AS ip_test_3, t0.questionnaire_id AS questionnaire_id_4 FROM participants t0 WHERE t0.questionnaire_id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.participants AS participants_2,
  t0.ip_test AS ip_test_3,
  t0.questionnaire_id AS questionnaire_id_4
FROM
  participants t0
WHERE
  t0.questionnaire_id = ?

SELECT t0.id AS id_1, t0.participants AS participants_2, t0.ip_test AS ip_test_3, t0.questionnaire_id AS questionnaire_id_4 FROM participants t0 WHERE t0.questionnaire_id = 1;

SELECT COUNT(q0_.id) AS sclr_0 FROM questions q0_ WHERE q0_.questionnaire_id = ?

[
  1
]

SELECT
  COUNT(q0_.id) AS sclr_0
FROM
  questions q0_
WHERE
  q0_.questionnaire_id = ?

SELECT COUNT(q0_.id) AS sclr_0 FROM questions q0_ WHERE q0_.questionnaire_id = 1;

SELECT t0.id AS id_1, t0.url AS url_2 FROM image t0 WHERE t0.id = ?

[
  12
]

SELECT
  t0.id AS id_1,
  t0.url AS url_2
FROM
  image t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.url AS url_2 FROM image t0 WHERE t0.id = 12;

SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.link_rewrite AS link_rewrite_5, t0.description AS description_6, t0.legend AS legend_7 FROM questionnaire_content t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.meta_title AS meta_title_3,
  t0.meta_description AS meta_description_4,
  t0.link_rewrite AS link_rewrite_5,
  t0.description AS description_6,
  t0.legend AS legend_7
FROM
  questionnaire_content t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.link_rewrite AS link_rewrite_5, t0.description AS description_6, t0.legend AS legend_7 FROM questionnaire_content t0 WHERE t0.id = 1;

SELECT q0_.id AS id_0, q0_.q_type AS q_type_1, q0_.q_connect AS q_connect_2, q0_.treatment AS treatment_3, q0_.active AS active_4, q0_.position AS position_5, q0_.sharing AS sharing_6, q0_.date_start AS date_start_7, q0_.date_end AS date_end_8, q0_.recalcul AS recalcul_9, q0_.only_image AS only_image_10, q0_.only_once AS only_once_11, q0_.deleted AS deleted_12, q0_.auto_start AS auto_start_13, q0_.list AS list_14, q0_.block AS block_15, q0_.modal_box AS modal_box_16, q0_.image_id AS image_id_17, q0_.rule_id AS rule_id_18, q0_.content_id AS content_id_19, q0_.truefalse_id AS truefalse_id_20, q0_.result_id AS result_id_21, q0_.config_win_id AS config_win_id_22 FROM questionnaires q0_ WHERE q0_.q_type IN ('C', 'Q', 'S', 'T') AND q0_.active = ? AND q0_.list = ? AND q0_.treatment = ? ORDER BY q0_.q_type ASC, q0_.position ASC

[
  1
  1
  1
]

SELECT
  q0_.id AS id_0,
  q0_.q_type AS q_type_1,
  q0_.q_connect AS q_connect_2,
  q0_.treatment AS treatment_3,
  q0_.active AS active_4,
  q0_.position AS position_5,
  q0_.sharing AS sharing_6,
  q0_.date_start AS date_start_7,
  q0_.date_end AS date_end_8,
  q0_.recalcul AS recalcul_9,
  q0_.only_image AS only_image_10,
  q0_.only_once AS only_once_11,
  q0_.deleted AS deleted_12,
  q0_.auto_start AS auto_start_13,
  q0_.list AS list_14,
  q0_.block AS block_15,
  q0_.modal_box AS modal_box_16,
  q0_.image_id AS image_id_17,
  q0_.rule_id AS rule_id_18,
  q0_.content_id AS content_id_19,
  q0_.truefalse_id AS truefalse_id_20,
  q0_.result_id AS result_id_21,
  q0_.config_win_id AS config_win_id_22
FROM
  questionnaires q0_
WHERE
  q0_.q_type IN ('C', 'Q', 'S', 'T')
  AND q0_.active = ?
  AND q0_.list = ?
  AND q0_.treatment = ?
ORDER BY
  q0_.q_type ASC,
  q0_.position ASC

SELECT q0_.id AS id_0, q0_.q_type AS q_type_1, q0_.q_connect AS q_connect_2, q0_.treatment AS treatment_3, q0_.active AS active_4, q0_.position AS position_5, q0_.sharing AS sharing_6, q0_.date_start AS date_start_7, q0_.date_end AS date_end_8, q0_.recalcul AS recalcul_9, q0_.only_image AS only_image_10, q0_.only_once AS only_once_11, q0_.deleted AS deleted_12, q0_.auto_start AS auto_start_13, q0_.list AS list_14, q0_.block AS block_15, q0_.modal_box AS modal_box_16, q0_.image_id AS image_id_17, q0_.rule_id AS rule_id_18, q0_.content_id AS content_id_19, q0_.truefalse_id AS truefalse_id_20, q0_.result_id AS result_id_21, q0_.config_win_id AS config_win_id_22 FROM questionnaires q0_ WHERE q0_.q_type IN ('C', 'Q', 'S', 'T') AND q0_.active = 1 AND q0_.list = 1 AND q0_.treatment = 1 ORDER BY q0_.q_type ASC, q0_.position ASC;