Symfony Profiler

SELECT
  a.id,
  c.branch_name,
  a.transaction_type,
  a.created_at,
  a.transaction_id,
  a.transaction_time,
  a.transaction_amount,
  a.short_code,
  (
    SELECT
      CASE WHEN a.msisdn LIKE '%****%' THEN a.msisdn ELSE (
        CONCAT(
          SUBSTRING(a.msisdn, 1, 6),
          '***',
          SUBSTRING(a.msisdn, 10, 3)
        )
      ) end as msisdn
  ) AS msisdn,
  CONCAT(
    a.first_name, ' ', a.middle_name,
    ' ', a.last_name
  ) as client,
  a.is_complete,
  a.is_used,
  a.used_at
FROM
  neema.mpesa_transaction a
  JOIN neema.mpesa_auth b ON b.till_number = a.short_code
  JOIN neema.branch c ON c.id = b.branch
WHERE
  a.transaction_id is not NULL
  AND cast(a.transaction_time as date) BETWEEN '2025-12-05'
  AND '2025-12-05'
  AND (
    c.id = 4
    or c.id = 37
  )
ORDER BY
  a.created_at desc OFFSET 0
ROWS
  FETCH NEXT 20
ROWS
  ONLY

SELECT a.id,c.branch_name,a.transaction_type,a.created_at,a.transaction_id,a.transaction_time,a.transaction_amount,a.short_code,
       (SELECT CASE WHEN a.msisdn LIKE '%****%' THEN a.msisdn ELSE (CONCAT(SUBSTRING(a.msisdn, 1, 6),'***',SUBSTRING(a.msisdn, 10, 3))) end as msisdn) AS msisdn,CONCAT(a.first_name,' ',a.middle_name,' ',a.last_name) as client,a.is_complete,a.is_used,a.used_at 
                    FROM neema.mpesa_transaction a 
                        JOIN neema.mpesa_auth b ON b.till_number = a.short_code
                        JOIN neema.branch c ON c.id = b.branch
                    WHERE a.transaction_id is not NULL   AND cast(a.transaction_time as date) BETWEEN '2025-12-05' AND '2025-12-05' AND (  c.id = 4 or  c.id =37) ORDER BY a.created_at desc OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY;

SELECT
  count(*) as total,
  SUM(a.transaction_amount) as amount
FROM
  neema.mpesa_transaction a
  JOIN neema.mpesa_auth b ON b.till_number = a.short_code
  JOIN neema.branch c ON c.id = b.branch
WHERE
  transaction_id is not NULL
  AND cast(a.transaction_time as date) BETWEEN '2025-12-05'
  AND '2025-12-05'
  AND (
    c.id = 4
    or c.id = 37
  )

SELECT count(*) as total, SUM(a.transaction_amount) as amount
                    FROM neema.mpesa_transaction a
                        JOIN neema.mpesa_auth b ON b.till_number = a.short_code
                        JOIN neema.branch c ON c.id = b.branch
                    WHERE transaction_id is not NULL   AND cast(a.transaction_time as date) BETWEEN '2025-12-05' AND '2025-12-05' AND (  c.id = 4 or  c.id =37);

SELECT
  t0.id AS id_1,
  t0.phone AS phone_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.created_at AS created_at_5,
  t0.is_active AS is_active_6,
  t0.branch_id AS branch_id_7,
  t0.system_user_id AS system_user_id_8
FROM
  [neema].[user] t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.roles AS roles_3, t0.password AS password_4, t0.created_at AS created_at_5, t0.is_active AS is_active_6, t0.branch_id AS branch_id_7, t0.system_user_id AS system_user_id_8 FROM [neema].[user] t0 WHERE t0.id = 1306;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.user_id AS user_id_3,
  t0.branch_id AS branch_id_4,
  t0.created_by AS created_by_5
FROM
  neema.user_branch t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3, t0.branch_id AS branch_id_4, t0.created_by AS created_by_5 FROM neema.user_branch t0 WHERE t0.user_id = 1306;