Symfony Profiler

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  attendee a0_
  LEFT JOIN attendance a1_ ON a0_.id = a1_.attendee_id
WHERE
  (
    a0_.age BETWEEN ?
    AND ?
  )
  AND (
    a0_.info_id NOT IN (?, ?, ?, ?, ?)
    OR a0_.info_id IS NULL
  )
  AND a0_.email LIKE ?
  AND (
    (
      a1_.project_id IS NULL
      OR a1_.project_id <> ?
    )
  )
  AND (
    a0_.id NOT IN (
      SELECT
        a0_.id
      FROM
        attendance a2_
      WHERE
        a2_.attendee_id = a0_.id
        AND a2_.project_id = ?
    )
  )
  AND (
    a0_.id NOT IN (
      SELECT
        a0_.id
      FROM
        attendance a3_
        LEFT JOIN project p4_ ON a3_.project_id = p4_.id
      WHERE
        (
          a3_.attendee_id = a0_.id
          AND a3_.status IN (?, ?)
        )
        AND p4_.customer_id = ?
        AND ABS(
          DATEDIFF(p4_.date, ?)
        ) < ?
    )
  )
  AND (
    a0_.id NOT IN (
      SELECT
        a0_.id
      FROM
        attendance a5_
        LEFT JOIN project p6_ ON a5_.project_id = p6_.id
        LEFT JOIN topic_project t8_ ON p6_.id = t8_.project_id
        LEFT JOIN topic t7_ ON t7_.id = t8_.topic_id
      WHERE
        (
          a5_.attendee_id = a0_.id
          AND a5_.status IN (?, ?)
        )
        AND t7_.id IN (?)
        AND ABS(
          DATEDIFF(p6_.date, ?)
        ) < t7_.exclusion
    )
  )
  AND NOT EXISTS (
    SELECT
      1
    FROM
      attendee_customer a9_
    WHERE
      a9_.attendee_id = a0_.id
      AND a9_.customer_id IN (?)
  )

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM attendee a0_ LEFT JOIN attendance a1_ ON a0_.id = a1_.attendee_id WHERE (a0_.age BETWEEN 18 AND 70) AND (a0_.info_id NOT IN (914, 916, 917, 1224, 1220) OR a0_.info_id IS NULL) AND a0_.email LIKE '%@%' AND ((a1_.project_id IS NULL OR a1_.project_id <> 1018)) AND (a0_.id NOT IN (SELECT a0_.id FROM attendance a2_ WHERE a2_.attendee_id = a0_.id AND a2_.project_id = 1018)) AND (a0_.id NOT IN (SELECT a0_.id FROM attendance a3_ LEFT JOIN project p4_ ON a3_.project_id = p4_.id WHERE (a3_.attendee_id = a0_.id AND a3_.status IN ('confirmed', 'attended')) AND p4_.customer_id = 18 AND ABS(DATEDIFF(p4_.date, '2026-07-01 00:00:00')) < 180)) AND (a0_.id NOT IN (SELECT a0_.id FROM attendance a5_ LEFT JOIN project p6_ ON a5_.project_id = p6_.id LEFT JOIN topic_project t8_ ON p6_.id = t8_.project_id LEFT JOIN topic t7_ ON t7_.id = t8_.topic_id WHERE (a5_.attendee_id = a0_.id AND a5_.status IN ('confirmed', 'attended')) AND t7_.id IN (10) AND ABS(DATEDIFF(p6_.date, '2026-07-01 00:00:00')) < t7_.exclusion)) AND NOT EXISTS (SELECT 1 FROM attendee_customer a9_ WHERE a9_.attendee_id = a0_.id AND a9_.customer_id IN (18));

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

SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.status IN ('confirmed', 'attended') AND a0_.attendee_id = 3;

SELECT
  DISTINCT a0_.id AS id_0
FROM
  attendee a0_
  LEFT JOIN attendance a1_ ON a0_.id = a1_.attendee_id
WHERE
  (
    a0_.age BETWEEN ?
    AND ?
  )
  AND (
    a0_.info_id NOT IN (?, ?, ?, ?, ?)
    OR a0_.info_id IS NULL
  )
  AND a0_.email LIKE ?
  AND (
    (
      a1_.project_id IS NULL
      OR a1_.project_id <> ?
    )
  )
  AND (
    a0_.id NOT IN (
      SELECT
        a0_.id
      FROM
        attendance a2_
      WHERE
        a2_.attendee_id = a0_.id
        AND a2_.project_id = ?
    )
  )
  AND (
    a0_.id NOT IN (
      SELECT
        a0_.id
      FROM
        attendance a3_
        LEFT JOIN project p4_ ON a3_.project_id = p4_.id
      WHERE
        (
          a3_.attendee_id = a0_.id
          AND a3_.status IN (?, ?)
        )
        AND p4_.customer_id = ?
        AND ABS(
          DATEDIFF(p4_.date, ?)
        ) < ?
    )
  )
  AND (
    a0_.id NOT IN (
      SELECT
        a0_.id
      FROM
        attendance a5_
        LEFT JOIN project p6_ ON a5_.project_id = p6_.id
        LEFT JOIN topic_project t8_ ON p6_.id = t8_.project_id
        LEFT JOIN topic t7_ ON t7_.id = t8_.topic_id
      WHERE
        (
          a5_.attendee_id = a0_.id
          AND a5_.status IN (?, ?)
        )
        AND t7_.id IN (?)
        AND ABS(
          DATEDIFF(p6_.date, ?)
        ) < t7_.exclusion
    )
  )
  AND NOT EXISTS (
    SELECT
      1
    FROM
      attendee_customer a9_
    WHERE
      a9_.attendee_id = a0_.id
      AND a9_.customer_id IN (?)
  )
LIMIT
  20

SELECT DISTINCT a0_.id AS id_0 FROM attendee a0_ LEFT JOIN attendance a1_ ON a0_.id = a1_.attendee_id WHERE (a0_.age BETWEEN 18 AND 70) AND (a0_.info_id NOT IN (914, 916, 917, 1224, 1220) OR a0_.info_id IS NULL) AND a0_.email LIKE '%@%' AND ((a1_.project_id IS NULL OR a1_.project_id <> 1018)) AND (a0_.id NOT IN (SELECT a0_.id FROM attendance a2_ WHERE a2_.attendee_id = a0_.id AND a2_.project_id = 1018)) AND (a0_.id NOT IN (SELECT a0_.id FROM attendance a3_ LEFT JOIN project p4_ ON a3_.project_id = p4_.id WHERE (a3_.attendee_id = a0_.id AND a3_.status IN ('confirmed', 'attended')) AND p4_.customer_id = 18 AND ABS(DATEDIFF(p4_.date, '2026-07-01 00:00:00')) < 180)) AND (a0_.id NOT IN (SELECT a0_.id FROM attendance a5_ LEFT JOIN project p6_ ON a5_.project_id = p6_.id LEFT JOIN topic_project t8_ ON p6_.id = t8_.project_id LEFT JOIN topic t7_ ON t7_.id = t8_.topic_id WHERE (a5_.attendee_id = a0_.id AND a5_.status IN ('confirmed', 'attended')) AND t7_.id IN (10) AND ABS(DATEDIFF(p6_.date, '2026-07-01 00:00:00')) < t7_.exclusion)) AND NOT EXISTS (SELECT 1 FROM attendee_customer a9_ WHERE a9_.attendee_id = a0_.id AND a9_.customer_id IN (18)) LIMIT 20;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  attendance a0_
  LEFT JOIN project p1_ ON a0_.project_id = p1_.id
WHERE
  a0_.attendee_id = ?
  AND p1_.customer_id = ?
  AND a0_.status IN (?, ?)

SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ LEFT JOIN project p1_ ON a0_.project_id = p1_.id WHERE a0_.attendee_id = 3 AND p1_.customer_id = 18 AND a0_.status IN ('confirmed', 'attended');

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.prefix AS prefix_2,
  s0_.full_name AS full_name_3,
  s0_.position AS position_4,
  s0_.discr AS discr_5
FROM
  `set` s0_
WHERE
  (
    s0_.id IN (?, ?, ?, ?, ?)
  )
  AND s0_.discr IN ('info')

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.prefix AS prefix_2, s0_.full_name AS full_name_3, s0_.position AS position_4, s0_.discr AS discr_5 FROM `set` s0_ WHERE (s0_.id IN ('914', '916', '917', '1224', '1220')) AND s0_.discr IN ('info');

SELECT
  a0_.id AS id_0,
  a0_.firstname AS firstname_1,
  a0_.lastname AS lastname_2,
  a0_.dob AS dob_3,
  a0_.balcony AS balcony_4,
  a0_.zip AS zip_5,
  a0_.city AS city_6,
  a0_.phone_mobile AS phone_mobile_7,
  a0_.phone_landline AS phone_landline_8,
  a0_.email AS email_9,
  a0_.english AS english_10,
  a0_.profession AS profession_11,
  a0_.garden AS garden_12,
  a0_.illness AS illness_13,
  a0_.visual_aid AS visual_aid_14,
  a0_.hearing_aid AS hearing_aid_15,
  a0_.smoking AS smoking_16,
  a0_.rolling_tobacco AS rolling_tobacco_17,
  a0_.darning_tobacco AS darning_tobacco_18,
  a0_.tablet AS tablet_19,
  a0_.hobbies AS hobbies_20,
  a0_.special_remarks AS special_remarks_21,
  a0_.internal_comment AS internal_comment_22,
  a0_.age AS age_23,
  a0_.bank_other AS bank_other_24,
  a0_.smartphone_other_brand AS smartphone_other_brand_25,
  a0_.smartphone_other_model AS smartphone_other_model_26,
  a0_.coffee_machines_other AS coffee_machines_other_27,
  a0_.kitchen_appliances_big_other AS kitchen_appliances_big_other_28,
  a0_.kitchen_appliances_small_other AS kitchen_appliances_small_other_29,
  a0_.pets_other AS pets_other_30,
  a0_.blocked AS blocked_31,
  a0_.form_submitted_at AS form_submitted_at_32,
  a0_.created_at AS created_at_33,
  a0_.updated_at AS updated_at_34,
  a0_.answer_id AS answer_id_35,
  a0_.token AS token_36,
  a0_.approved AS approved_37,
  a0_.email_confirmation_sent_at AS email_confirmation_sent_at_38,
  a0_.email_confirmed_at AS email_confirmed_at_39,
  a0_.family_status_id AS family_status_id_40,
  a0_.degree_id AS degree_id_41,
  a0_.state_id AS state_id_42,
  a0_.income_id AS income_id_43,
  a0_.living_situation_id AS living_situation_id_44,
  a0_.gender_id AS gender_id_45,
  a0_.sector_id AS sector_id_46,
  a0_.info_id AS info_id_47,
  a0_.cigarettes_id AS cigarettes_id_48,
  a0_.cigarettes_second_id AS cigarettes_second_id_49,
  a0_.e_cigarettes_id AS e_cigarettes_id_50,
  a0_.smartphone_id AS smartphone_id_51
FROM
  attendee a0_
  LEFT JOIN attendance a1_ ON a0_.id = a1_.attendee_id
WHERE
  (
    a0_.age BETWEEN ?
    AND ?
  )
  AND (
    a0_.info_id NOT IN (?, ?, ?, ?, ?)
    OR a0_.info_id IS NULL
  )
  AND a0_.email LIKE ?
  AND (
    (
      a1_.project_id IS NULL
      OR a1_.project_id <> ?
    )
  )
  AND (
    a0_.id NOT IN (
      SELECT
        a0_.id
      FROM
        attendance a2_
      WHERE
        a2_.attendee_id = a0_.id
        AND a2_.project_id = ?
    )
  )
  AND (
    a0_.id NOT IN (
      SELECT
        a0_.id
      FROM
        attendance a3_
        LEFT JOIN project p4_ ON a3_.project_id = p4_.id
      WHERE
        (
          a3_.attendee_id = a0_.id
          AND a3_.status IN (?, ?)
        )
        AND p4_.customer_id = ?
        AND ABS(
          DATEDIFF(p4_.date, ?)
        ) < ?
    )
  )
  AND (
    a0_.id NOT IN (
      SELECT
        a0_.id
      FROM
        attendance a5_
        LEFT JOIN project p6_ ON a5_.project_id = p6_.id
        LEFT JOIN topic_project t8_ ON p6_.id = t8_.project_id
        LEFT JOIN topic t7_ ON t7_.id = t8_.topic_id
      WHERE
        (
          a5_.attendee_id = a0_.id
          AND a5_.status IN (?, ?)
        )
        AND t7_.id IN (?)
        AND ABS(
          DATEDIFF(p6_.date, ?)
        ) < t7_.exclusion
    )
  )
  AND NOT EXISTS (
    SELECT
      1
    FROM
      attendee_customer a9_
    WHERE
      a9_.attendee_id = a0_.id
      AND a9_.customer_id IN (?)
  )
  AND a0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

SELECT a0_.id AS id_0, a0_.firstname AS firstname_1, a0_.lastname AS lastname_2, a0_.dob AS dob_3, a0_.balcony AS balcony_4, a0_.zip AS zip_5, a0_.city AS city_6, a0_.phone_mobile AS phone_mobile_7, a0_.phone_landline AS phone_landline_8, a0_.email AS email_9, a0_.english AS english_10, a0_.profession AS profession_11, a0_.garden AS garden_12, a0_.illness AS illness_13, a0_.visual_aid AS visual_aid_14, a0_.hearing_aid AS hearing_aid_15, a0_.smoking AS smoking_16, a0_.rolling_tobacco AS rolling_tobacco_17, a0_.darning_tobacco AS darning_tobacco_18, a0_.tablet AS tablet_19, a0_.hobbies AS hobbies_20, a0_.special_remarks AS special_remarks_21, a0_.internal_comment AS internal_comment_22, a0_.age AS age_23, a0_.bank_other AS bank_other_24, a0_.smartphone_other_brand AS smartphone_other_brand_25, a0_.smartphone_other_model AS smartphone_other_model_26, a0_.coffee_machines_other AS coffee_machines_other_27, a0_.kitchen_appliances_big_other AS kitchen_appliances_big_other_28, a0_.kitchen_appliances_small_other AS kitchen_appliances_small_other_29, a0_.pets_other AS pets_other_30, a0_.blocked AS blocked_31, a0_.form_submitted_at AS form_submitted_at_32, a0_.created_at AS created_at_33, a0_.updated_at AS updated_at_34, a0_.answer_id AS answer_id_35, a0_.token AS token_36, a0_.approved AS approved_37, a0_.email_confirmation_sent_at AS email_confirmation_sent_at_38, a0_.email_confirmed_at AS email_confirmed_at_39, a0_.family_status_id AS family_status_id_40, a0_.degree_id AS degree_id_41, a0_.state_id AS state_id_42, a0_.income_id AS income_id_43, a0_.living_situation_id AS living_situation_id_44, a0_.gender_id AS gender_id_45, a0_.sector_id AS sector_id_46, a0_.info_id AS info_id_47, a0_.cigarettes_id AS cigarettes_id_48, a0_.cigarettes_second_id AS cigarettes_second_id_49, a0_.e_cigarettes_id AS e_cigarettes_id_50, a0_.smartphone_id AS smartphone_id_51 FROM attendee a0_ LEFT JOIN attendance a1_ ON a0_.id = a1_.attendee_id WHERE (a0_.age BETWEEN 18 AND 70) AND (a0_.info_id NOT IN (914, 916, 917, 1224, 1220) OR a0_.info_id IS NULL) AND a0_.email LIKE '%@%' AND ((a1_.project_id IS NULL OR a1_.project_id <> 1018)) AND (a0_.id NOT IN (SELECT a0_.id FROM attendance a2_ WHERE a2_.attendee_id = a0_.id AND a2_.project_id = 1018)) AND (a0_.id NOT IN (SELECT a0_.id FROM attendance a3_ LEFT JOIN project p4_ ON a3_.project_id = p4_.id WHERE (a3_.attendee_id = a0_.id AND a3_.status IN ('confirmed', 'attended')) AND p4_.customer_id = 18 AND ABS(DATEDIFF(p4_.date, '2026-07-01 00:00:00')) < 180)) AND (a0_.id NOT IN (SELECT a0_.id FROM attendance a5_ LEFT JOIN project p6_ ON a5_.project_id = p6_.id LEFT JOIN topic_project t8_ ON p6_.id = t8_.project_id LEFT JOIN topic t7_ ON t7_.id = t8_.topic_id WHERE (a5_.attendee_id = a0_.id AND a5_.status IN ('confirmed', 'attended')) AND t7_.id IN (10) AND ABS(DATEDIFF(p6_.date, '2026-07-01 00:00:00')) < t7_.exclusion)) AND NOT EXISTS (SELECT 1 FROM attendee_customer a9_ WHERE a9_.attendee_id = a0_.id AND a9_.customer_id IN (18)) AND a0_.id IN (3, 5, 7, 8, 9, 12, 13, 14, 15, 16, 17, 20, 21, 22, 24, 25, 27, 29, 31, 32);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_german AS name_german_3,
  t0.control AS control_4,
  t0.sort_alphabetically AS sort_alphabetically_5,
  t0.is_base AS is_base_6,
  t0.position AS position_7,
  t0.required_in_form AS required_in_form_8
FROM
  attribute t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_german AS name_german_3, t0.control AS control_4, t0.sort_alphabetically AS sort_alphabetically_5, t0.is_base AS is_base_6, t0.position AS position_7, t0.required_in_form AS required_in_form_8 FROM attribute t0 WHERE t0.name = 'age' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.date AS date_2,
  p0_.attendee_filter AS attendee_filter_3,
  p0_.customer_exclusion AS customer_exclusion_4,
  p0_.created_at AS created_at_5,
  p0_.updated_at AS updated_at_6,
  p0_.customer_id AS customer_id_7
FROM
  project p0_
WHERE
  p0_.id IN (?)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.date AS date_2, p0_.attendee_filter AS attendee_filter_3, p0_.customer_exclusion AS customer_exclusion_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.customer_id AS customer_id_7 FROM project p0_ WHERE p0_.id IN ('1018');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.prefix AS prefix_3,
  t0.full_name AS full_name_4,
  t0.position AS position_5,
  t0.discr
FROM
  `set` t0
WHERE
  t0.id = ?
  AND t0.discr IN ('gender')

SELECT t0.id AS id_1, t0.name AS name_2, t0.prefix AS prefix_3, t0.full_name AS full_name_4, t0.position AS position_5, t0.discr FROM `set` t0 WHERE t0.id = 912 AND t0.discr IN ('gender');

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
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_german AS name_german_3,
  t0.control AS control_4,
  t0.sort_alphabetically AS sort_alphabetically_5,
  t0.is_base AS is_base_6,
  t0.position AS position_7,
  t0.required_in_form AS required_in_form_8
FROM
  attribute t0
WHERE
  (
    (
      (
        (
          t0.name != ?
          AND t0.name != ?
        )
        AND t0.name != ?
      )
      AND t0.name != ?
    )
    AND t0.name != ?
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_german AS name_german_3, t0.control AS control_4, t0.sort_alphabetically AS sort_alphabetically_5, t0.is_base AS is_base_6, t0.position AS position_7, t0.required_in_form AS required_in_form_8 FROM attribute t0 WHERE ((((t0.name != 'dob' AND t0.name != 'car') AND t0.name != 'carDrive') AND t0.name != 'carType') AND t0.name != 'children');

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.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.prefix AS prefix_3,
  t0.full_name AS full_name_4,
  t0.position AS position_5,
  t0.discr
FROM
  `set` t0
WHERE
  t0.id = ?
  AND t0.discr IN ('info')

SELECT t0.id AS id_1, t0.name AS name_2, t0.prefix AS prefix_3, t0.full_name AS full_name_4, t0.position AS position_5, t0.discr FROM `set` t0 WHERE t0.id = 915 AND t0.discr IN ('info');