Symfony Profiler

SELECT
  u0_.id AS id_0,
  u0_.status AS status_1,
  u0_.user_type AS user_type_2,
  u0_.email AS email_3,
  u0_.pending_email AS pending_email_4,
  u0_.phone_number AS phone_number_5,
  u0_.first_name AS first_name_6,
  u0_.last_name AS last_name_7,
  u0_.language AS language_8,
  u0_.blocked_until AS blocked_until_9,
  u0_.block_scope AS block_scope_10,
  u0_.message_violation_blocked_at AS message_violation_blocked_at_11,
  u0_.message_violation_block_reason AS message_violation_block_reason_12,
  u0_.message_violation_count AS message_violation_count_13,
  u0_.created_at AS created_at_14,
  u0_.updated_at AS updated_at_15,
  u0_.last_login_at AS last_login_at_16,
  u0_.last_activity_at AS last_activity_at_17,
  u0_.previous_activity_at AS previous_activity_at_18,
  u0_.returned_at AS returned_at_19,
  u0_.last_activity AS last_activity_20,
  u0_.deleted_at AS deleted_at_21,
  u0_.credentials_changed_at AS credentials_changed_at_22,
  a1_.password AS password_23,
  u0_.role AS role_24
FROM
  administrator a1_
  INNER JOIN user u0_ ON a1_.id = u0_.id
WHERE
  u0_.id = ?

SELECT u0_.id AS id_0, u0_.status AS status_1, u0_.user_type AS user_type_2, u0_.email AS email_3, u0_.pending_email AS pending_email_4, u0_.phone_number AS phone_number_5, u0_.first_name AS first_name_6, u0_.last_name AS last_name_7, u0_.language AS language_8, u0_.blocked_until AS blocked_until_9, u0_.block_scope AS block_scope_10, u0_.message_violation_blocked_at AS message_violation_blocked_at_11, u0_.message_violation_block_reason AS message_violation_block_reason_12, u0_.message_violation_count AS message_violation_count_13, u0_.created_at AS created_at_14, u0_.updated_at AS updated_at_15, u0_.last_login_at AS last_login_at_16, u0_.last_activity_at AS last_activity_at_17, u0_.previous_activity_at AS previous_activity_at_18, u0_.returned_at AS returned_at_19, u0_.last_activity AS last_activity_20, u0_.deleted_at AS deleted_at_21, u0_.credentials_changed_at AS credentials_changed_at_22, a1_.password AS password_23, u0_.role AS role_24 FROM administrator a1_ INNER JOIN user u0_ ON a1_.id = u0_.id WHERE u0_.id = '2676760';

SELECT
  t0.permission AS permission_1,
  t0.services_enabled AS services_enabled_2,
  t0.reported_at AS reported_at_3,
  t0.id AS id_4
FROM
  user_location_permission t0
WHERE
  t0.id = ?

SELECT t0.permission AS permission_1, t0.services_enabled AS services_enabled_2, t0.reported_at AS reported_at_3, t0.id AS id_4 FROM user_location_permission t0 WHERE t0.id = 2676760;

SELECT
  t0.value AS value_1,
  t0.changed_at AS changed_at_2,
  t0.id AS id_3
FROM
  payment_balance t0
WHERE
  t0.id = ?

SELECT t0.value AS value_1, t0.changed_at AS changed_at_2, t0.id AS id_3 FROM payment_balance t0 WHERE t0.id = 2676760;

SELECT
  t0.code AS code_1,
  t0.is_enabled AS is_enabled_2,
  t0.duration_days_per_referred_user AS duration_days_per_referred_user_3,
  t0.referred_by_ended_at AS referred_by_ended_at_4,
  t0.referred_by_commission_percent AS referred_by_commission_percent_5,
  t0.agency_joined_at AS agency_joined_at_6,
  t0.referral_activity_commission_percent AS referral_activity_commission_percent_7,
  t0.referral_new_campaign_commission_percent AS referral_new_campaign_commission_percent_8,
  t0.reward_block_reason AS reward_block_reason_9,
  t0.referral_tail_commission_percent AS referral_tail_commission_percent_10,
  t0.referral_tail_duration_days AS referral_tail_duration_days_11,
  t0.balance AS balance_12,
  t0.id AS id_13,
  t0.referred_by_id AS referred_by_id_14
FROM
  referral t0
WHERE
  t0.id = ?

SELECT t0.code AS code_1, t0.is_enabled AS is_enabled_2, t0.duration_days_per_referred_user AS duration_days_per_referred_user_3, t0.referred_by_ended_at AS referred_by_ended_at_4, t0.referred_by_commission_percent AS referred_by_commission_percent_5, t0.agency_joined_at AS agency_joined_at_6, t0.referral_activity_commission_percent AS referral_activity_commission_percent_7, t0.referral_new_campaign_commission_percent AS referral_new_campaign_commission_percent_8, t0.reward_block_reason AS reward_block_reason_9, t0.referral_tail_commission_percent AS referral_tail_commission_percent_10, t0.referral_tail_duration_days AS referral_tail_duration_days_11, t0.balance AS balance_12, t0.id AS id_13, t0.referred_by_id AS referred_by_id_14 FROM referral t0 WHERE t0.id = 2676760;

SELECT
  anchor_user.id AS anchor_id,
  COALESCE(
    NULLIF(
      TRIM(
        CONCAT(
          COALESCE(anchor_user.first_name, ''),
          ' ',
          COALESCE(anchor_user.last_name, '')
        )
      ),
      ''
    ),
    ''
  ) AS username,
  anchor_user.email AS email,
  anchor_user.status AS status,
  anchor_user.blocked_until AS blocked_until,
  anchor_user.language AS language,
  anchor_user.deleted_at AS deleted_at,
  CASE WHEN anchor_user.role = ? THEN
    'sponsor'
  ELSE
    'creator'
  END AS account_type,
  anchor_user.created_at AS created_at,
  NULL AS profile_url,
  anchor_user.last_login_at AS last_login_at,
  anchor_user.last_activity_at AS last_activity_at,
  anchor_user.last_activity AS last_activity,
  anchor_user.user_type AS user_type,
  NULL AS matched_creator_ids
FROM
  user anchor_user
  LEFT JOIN creator listable_creator ON listable_creator.id = anchor_user.id
  AND (
    listable_creator.user_id IS NULL
    OR listable_creator.user_id = listable_creator.id
  )
  LEFT JOIN sponsor listable_sponsor ON listable_sponsor.id = anchor_user.id
  AND listable_sponsor.has_creator_account = 1
WHERE
  (
    (
      anchor_user.role = ?
      AND listable_creator.id IS NOT NULL
    )
    OR (
      anchor_user.role = ?
      AND listable_sponsor.id IS NOT NULL
    )
  )
  AND (
    anchor_user.deleted_at IS NULL
    OR anchor_user.deleted_at > ?
  )
  AND (
    anchor_user.email IS NOT NULL
    AND anchor_user.email != ''
  )
  AND anchor_user.id < ?
ORDER BY
  anchor_user.id DESC
LIMIT
  101

SELECT
        anchor_user.id AS anchor_id,
    COALESCE(
        NULLIF(TRIM(CONCAT(COALESCE(anchor_user.first_name, ''), ' ', COALESCE(anchor_user.last_name, ''))), ''),
        ''
    ) AS username,
    anchor_user.email AS email,
    anchor_user.status AS status,
    anchor_user.blocked_until AS blocked_until,
    anchor_user.language AS language,
    anchor_user.deleted_at AS deleted_at,
    CASE
        WHEN anchor_user.role = 'ROLE_SPONSOR' THEN 'sponsor'
        ELSE 'creator'
    END AS account_type,
    anchor_user.created_at AS created_at,
    NULL AS profile_url,
    anchor_user.last_login_at AS last_login_at,
    anchor_user.last_activity_at AS last_activity_at,
    anchor_user.last_activity AS last_activity,
    anchor_user.user_type AS user_type,
    NULL AS matched_creator_ids
FROM user anchor_user
    LEFT JOIN creator listable_creator
        ON listable_creator.id = anchor_user.id
       AND (listable_creator.user_id IS NULL OR listable_creator.user_id = listable_creator.id)
    LEFT JOIN sponsor listable_sponsor
        ON listable_sponsor.id = anchor_user.id
       AND listable_sponsor.has_creator_account = 1
WHERE     (
        (anchor_user.role = 'ROLE_CREATOR' AND listable_creator.id IS NOT NULL)
        OR (anchor_user.role = 'ROLE_SPONSOR' AND listable_sponsor.id IS NOT NULL)
    )
  AND (anchor_user.deleted_at IS NULL OR anchor_user.deleted_at > '2026-09-18 01:39:47')
  AND (anchor_user.email IS NOT NULL AND anchor_user.email != '')
  
  AND anchor_user.id < 256509
ORDER BY anchor_user.id DESC
LIMIT 101;

SELECT
  c.owner_user_id,
  c.profile_picture_url
FROM
  creator c
WHERE
  c.owner_user_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  (c.id = c.owner_user_id) DESC,
  c.id ASC

SELECT c.owner_user_id, c.profile_picture_url
FROM creator c
WHERE c.owner_user_id IN (256506, 256504, 256503, 256498, 256497, 256494, 256491, 256490, 256488, 256487, 256486, 256485, 256484, 256483, 256477, 256475, 256474, 256471, 256470, 256469, 256467, 256466, 256458, 256457, 256455, 256454, 256453, 256452, 256446, 256443, 256442, 256439, 256438, 256437, 256433, 256432, 256429, 256427, 256423, 256418, 256415, 256414, 256413, 256412, 256410, 256405, 256403, 256401, 256400, 256398, 256395, 256391, 256389, 256388, 256383, 256382, 256377, 256375, 256374, 256373, 256372, 256371, 256365, 256363, 256362, 256361, 256359, 256355, 256354, 256353, 256352, 256351, 256347, 256346, 256341, 256340, 256339, 256335, 256332, 256331, 256327, 256325, 256324, 256323, 256321, 256320, 256319, 256316, 256315, 256314, 256310, 256308, 256306, 256304, 256300, 256298, 256297, 256294, 256293, 256289, 256288)
ORDER BY (c.id = c.owner_user_id) DESC, c.id ASC;