Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date AS date_3,
  t0.attendee_filter AS attendee_filter_4,
  t0.customer_exclusion AS customer_exclusion_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.customer_id AS customer_id_8,
  t9.id AS id_10,
  t9.title AS title_11,
  t9.slug AS slug_12,
  t9.header_text AS header_text_13,
  t9.footer_text AS footer_text_14,
  t9.email_subject AS email_subject_15,
  t9.email_body AS email_body_16,
  t9.is_active AS is_active_17,
  t9.created_at AS created_at_18,
  t9.updated_at AS updated_at_19,
  t9.project_id AS project_id_20
FROM
  project t0
  LEFT JOIN survey t9 ON t9.project_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.attendee_filter AS attendee_filter_4, t0.customer_exclusion AS customer_exclusion_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.customer_id AS customer_id_8, t9.id AS id_10, t9.title AS title_11, t9.slug AS slug_12, t9.header_text AS header_text_13, t9.footer_text AS footer_text_14, t9.email_subject AS email_subject_15, t9.email_body AS email_body_16, t9.is_active AS is_active_17, t9.created_at AS created_at_18, t9.updated_at AS updated_at_19, t9.project_id AS project_id_20 FROM project t0 LEFT JOIN survey t9 ON t9.project_id = t0.id WHERE t0.id = '1018';

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM customer t0 WHERE t0.id = 18;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  attendance a0_
WHERE
  a0_.project_id = ?
  AND a0_.status = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = 1018 AND a0_.status = 'to_mailout';

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  attendance a0_
WHERE
  a0_.project_id = ?
  AND a0_.status = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = 1018 AND a0_.status = 'mailout';

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  attendance a0_
WHERE
  a0_.project_id = ?
  AND a0_.status = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = 1018 AND a0_.status = 'confirmed';

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  attendance a0_
WHERE
  a0_.project_id = ?
  AND a0_.status = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = 1018 AND a0_.status = 'attended';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.exclusion AS exclusion_3,
  t0.customer_id AS customer_id_4
FROM
  topic t0
  INNER JOIN topic_project ON t0.id = topic_project.topic_id
WHERE
  topic_project.project_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.exclusion AS exclusion_3, t0.customer_id AS customer_id_4 FROM topic t0 INNER JOIN topic_project ON t0.id = topic_project.topic_id WHERE topic_project.project_id = 1018;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  attendance a0_
WHERE
  a0_.project_id = ?
  AND a0_.status = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = 1018 AND a0_.status = 'to_mailout';

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  attendance a0_
WHERE
  a0_.project_id = ?
  AND a0_.status = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = 1018 AND a0_.status = 'mailout';

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  attendance a0_
WHERE
  a0_.project_id = ?
  AND a0_.status = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = 1018 AND a0_.status = 'survey_completed';

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  attendance a0_
WHERE
  a0_.project_id = ?
  AND a0_.status = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = 1018 AND a0_.status = 'excluded';

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  attendance a0_
WHERE
  a0_.project_id = ?
  AND a0_.status = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = 1018 AND a0_.status = 'confirmed';

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  attendance a0_
WHERE
  a0_.project_id = ?
  AND a0_.status = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = 1018 AND a0_.status = 'cancelled';

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  attendance a0_
WHERE
  a0_.project_id = ?
  AND a0_.status = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = 1018 AND a0_.status = 'not_attended';

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  attendance a0_
WHERE
  a0_.project_id = ?
  AND a0_.status = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = 1018 AND a0_.status = 'attended';

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.type AS type_3,
  t0.position AS position_4,
  t0.required AS required_5,
  t0.match_pattern AS match_pattern_6,
  t0.match_type AS match_type_7,
  t0.has_other AS has_other_8,
  t0.other_match_type AS other_match_type_9,
  t0.survey_id AS survey_id_10
FROM
  survey_question t0
WHERE
  t0.survey_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.type AS type_3, t0.position AS position_4, t0.required AS required_5, t0.match_pattern AS match_pattern_6, t0.match_type AS match_type_7, t0.has_other AS has_other_8, t0.other_match_type AS other_match_type_9, t0.survey_id AS survey_id_10 FROM survey_question t0 WHERE t0.survey_id = 2 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.is_match AS is_match_2,
  t0.completed_at AS completed_at_3,
  t0.created_at AS created_at_4,
  t0.survey_id AS survey_id_5,
  t0.attendee_id AS attendee_id_6
FROM
  survey_response t0
WHERE
  t0.survey_id = ?

SELECT t0.id AS id_1, t0.is_match AS is_match_2, t0.completed_at AS completed_at_3, t0.created_at AS created_at_4, t0.survey_id AS survey_id_5, t0.attendee_id AS attendee_id_6 FROM survey_response t0 WHERE t0.survey_id = 2;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  attendance a0_
WHERE
  a0_.project_id = ?
  AND a0_.status = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = 1018 AND a0_.status = 'to_mailout';

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  attendance a0_
WHERE
  a0_.project_id = ?
  AND a0_.status = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = 1018 AND a0_.status = 'survey_completed';

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  attendance a0_
WHERE
  a0_.project_id = ?
  AND a0_.status = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = 1018 AND a0_.status = 'mailout';

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  attendance a0_
WHERE
  a0_.project_id = ?
  AND a0_.status = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = 1018 AND a0_.status = 'confirmed';

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  attendance a0_
WHERE
  a0_.project_id = ?
  AND a0_.status = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = 1018 AND a0_.status = 'attended';

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  attendance a0_
WHERE
  a0_.project_id = ?
  AND a0_.status = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = 1018 AND a0_.status = 'not_attended';

SELECT
  a0_.id AS id_0,
  a0_.status AS status_1,
  a0_.mailout_at AS mailout_at_2,
  a0_.confirmed_at AS confirmed_at_3,
  a0_.cancelled_at AS cancelled_at_4,
  a1_.id AS id_5,
  a1_.firstname AS firstname_6,
  a1_.lastname AS lastname_7,
  a1_.dob AS dob_8,
  a1_.balcony AS balcony_9,
  a1_.zip AS zip_10,
  a1_.city AS city_11,
  a1_.phone_mobile AS phone_mobile_12,
  a1_.phone_landline AS phone_landline_13,
  a1_.email AS email_14,
  a1_.english AS english_15,
  a1_.profession AS profession_16,
  a1_.garden AS garden_17,
  a1_.illness AS illness_18,
  a1_.visual_aid AS visual_aid_19,
  a1_.hearing_aid AS hearing_aid_20,
  a1_.smoking AS smoking_21,
  a1_.rolling_tobacco AS rolling_tobacco_22,
  a1_.darning_tobacco AS darning_tobacco_23,
  a1_.tablet AS tablet_24,
  a1_.hobbies AS hobbies_25,
  a1_.special_remarks AS special_remarks_26,
  a1_.internal_comment AS internal_comment_27,
  a1_.age AS age_28,
  a1_.bank_other AS bank_other_29,
  a1_.smartphone_other_brand AS smartphone_other_brand_30,
  a1_.smartphone_other_model AS smartphone_other_model_31,
  a1_.coffee_machines_other AS coffee_machines_other_32,
  a1_.kitchen_appliances_big_other AS kitchen_appliances_big_other_33,
  a1_.kitchen_appliances_small_other AS kitchen_appliances_small_other_34,
  a1_.pets_other AS pets_other_35,
  a1_.blocked AS blocked_36,
  a1_.form_submitted_at AS form_submitted_at_37,
  a1_.created_at AS created_at_38,
  a1_.updated_at AS updated_at_39,
  a1_.answer_id AS answer_id_40,
  a1_.token AS token_41,
  a1_.approved AS approved_42,
  a1_.email_confirmation_sent_at AS email_confirmation_sent_at_43,
  a1_.email_confirmed_at AS email_confirmed_at_44,
  a0_.project_id AS project_id_45,
  a0_.attendee_id AS attendee_id_46,
  a0_.invitation_group_id AS invitation_group_id_47,
  a1_.family_status_id AS family_status_id_48,
  a1_.degree_id AS degree_id_49,
  a1_.state_id AS state_id_50,
  a1_.income_id AS income_id_51,
  a1_.living_situation_id AS living_situation_id_52,
  a1_.gender_id AS gender_id_53,
  a1_.sector_id AS sector_id_54,
  a1_.info_id AS info_id_55,
  a1_.cigarettes_id AS cigarettes_id_56,
  a1_.cigarettes_second_id AS cigarettes_second_id_57,
  a1_.e_cigarettes_id AS e_cigarettes_id_58,
  a1_.smartphone_id AS smartphone_id_59
FROM
  attendance a0_
  LEFT JOIN attendee a1_ ON a0_.attendee_id = a1_.id
WHERE
  a0_.project_id = ?
ORDER BY
  a0_.id DESC

SELECT a0_.id AS id_0, a0_.status AS status_1, a0_.mailout_at AS mailout_at_2, a0_.confirmed_at AS confirmed_at_3, a0_.cancelled_at AS cancelled_at_4, a1_.id AS id_5, a1_.firstname AS firstname_6, a1_.lastname AS lastname_7, a1_.dob AS dob_8, a1_.balcony AS balcony_9, a1_.zip AS zip_10, a1_.city AS city_11, a1_.phone_mobile AS phone_mobile_12, a1_.phone_landline AS phone_landline_13, a1_.email AS email_14, a1_.english AS english_15, a1_.profession AS profession_16, a1_.garden AS garden_17, a1_.illness AS illness_18, a1_.visual_aid AS visual_aid_19, a1_.hearing_aid AS hearing_aid_20, a1_.smoking AS smoking_21, a1_.rolling_tobacco AS rolling_tobacco_22, a1_.darning_tobacco AS darning_tobacco_23, a1_.tablet AS tablet_24, a1_.hobbies AS hobbies_25, a1_.special_remarks AS special_remarks_26, a1_.internal_comment AS internal_comment_27, a1_.age AS age_28, a1_.bank_other AS bank_other_29, a1_.smartphone_other_brand AS smartphone_other_brand_30, a1_.smartphone_other_model AS smartphone_other_model_31, a1_.coffee_machines_other AS coffee_machines_other_32, a1_.kitchen_appliances_big_other AS kitchen_appliances_big_other_33, a1_.kitchen_appliances_small_other AS kitchen_appliances_small_other_34, a1_.pets_other AS pets_other_35, a1_.blocked AS blocked_36, a1_.form_submitted_at AS form_submitted_at_37, a1_.created_at AS created_at_38, a1_.updated_at AS updated_at_39, a1_.answer_id AS answer_id_40, a1_.token AS token_41, a1_.approved AS approved_42, a1_.email_confirmation_sent_at AS email_confirmation_sent_at_43, a1_.email_confirmed_at AS email_confirmed_at_44, a0_.project_id AS project_id_45, a0_.attendee_id AS attendee_id_46, a0_.invitation_group_id AS invitation_group_id_47, a1_.family_status_id AS family_status_id_48, a1_.degree_id AS degree_id_49, a1_.state_id AS state_id_50, a1_.income_id AS income_id_51, a1_.living_situation_id AS living_situation_id_52, a1_.gender_id AS gender_id_53, a1_.sector_id AS sector_id_54, a1_.info_id AS info_id_55, a1_.cigarettes_id AS cigarettes_id_56, a1_.cigarettes_second_id AS cigarettes_second_id_57, a1_.e_cigarettes_id AS e_cigarettes_id_58, a1_.smartphone_id AS smartphone_id_59 FROM attendance a0_ LEFT JOIN attendee a1_ ON a0_.attendee_id = a1_.id WHERE a0_.project_id = 1018 ORDER BY a0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.original_filename AS original_filename_2,
  t0.storage_path AS storage_path_3,
  t0.mime_type AS mime_type_4,
  t0.document_type AS document_type_5,
  t0.uploaded_at AS uploaded_at_6,
  t0.project_id AS project_id_7
FROM
  project_document t0
WHERE
  t0.project_id = ?
ORDER BY
  t0.uploaded_at DESC

SELECT t0.id AS id_1, t0.original_filename AS original_filename_2, t0.storage_path AS storage_path_3, t0.mime_type AS mime_type_4, t0.document_type AS document_type_5, t0.uploaded_at AS uploaded_at_6, t0.project_id AS project_id_7 FROM project_document t0 WHERE t0.project_id = 1018 ORDER BY t0.uploaded_at DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date AS date_3,
  t0.start_time AS start_time_4,
  t0.end_time AS end_time_5,
  t0.zoom_link AS zoom_link_6,
  t0.capacity AS capacity_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.project_id AS project_id_10
FROM
  invitation_group t0
WHERE
  t0.project_id = ?
ORDER BY
  t0.date ASC,
  t0.start_time ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.start_time AS start_time_4, t0.end_time AS end_time_5, t0.zoom_link AS zoom_link_6, t0.capacity AS capacity_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.project_id AS project_id_10 FROM invitation_group t0 WHERE t0.project_id = 1018 ORDER BY t0.date ASC, t0.start_time ASC;