Symfony Profiler

SELECT
  YEAR(i0_.invoice_service_date) AS sclr_0,
  MONTH(i0_.invoice_service_date) AS sclr_1,
  SUM(
    i1_.invoice_procedure_price * i1_.invoice_procedure_quentity
  ) AS sclr_2
FROM
  invoice i0_
  INNER JOIN claim c2_ ON (c2_.claim_invoice_id = i0_.id)
  INNER JOIN invoice_procedure i1_ ON (
    i1_.invoice_procedure_invoice_id = i0_.id
  )
WHERE
  i0_.id LIKE ?
  AND i0_.invoice_service_date >= ?
GROUP BY
  sclr_0,
  sclr_1

SELECT YEAR(i0_.invoice_service_date) AS sclr_0, MONTH(i0_.invoice_service_date) AS sclr_1, SUM(i1_.invoice_procedure_price * i1_.invoice_procedure_quentity) AS sclr_2 FROM invoice i0_ INNER JOIN claim c2_ ON (c2_.claim_invoice_id = i0_.id) INNER JOIN invoice_procedure i1_ ON (i1_.invoice_procedure_invoice_id = i0_.id) WHERE i0_.id LIKE '%' AND i0_.invoice_service_date >= '2025-02-01' GROUP BY sclr_0, sclr_1;

select
  i2.`insurance_name` as insuranceName,
  round(
    sum(
      case when datediff(
        NOW(),
        coalesce(
          date(c.`claim_insert_date`),
          now()
        )
      ) BETWEEN 0
      AND 30 then
        ip2.`total_charges` + coalesce(b.`total`, 0) - coalesce(t.`total`, 0) - coalesce(a.`total`, 0)
      else
        0
      end
    ),
    2
  ) as 'current',
  round(
    sum(
      case when datediff(
        NOW(),
        coalesce(
          date(c.`claim_insert_date`),
          now()
        )
      ) BETWEEN 31
      AND 60 then
        ip2.`total_charges` + coalesce(b.`total`, 0) - coalesce(t.`total`, 0) - coalesce(a.`total`, 0)
      else
        0
      end
    ),
    2
  ) as 'field31to60',
  round(
    sum(
      case when datediff(
        NOW(),
        coalesce(
          date(c.`claim_insert_date`),
          now()
        )
      ) BETWEEN 61
      AND 90 then
        ip2.`total_charges` + coalesce(b.`total`, 0) - coalesce(t.`total`, 0) - coalesce(a.`total`, 0)
      else
        0
      end
    ),
    2
  ) as 'field61to90',
  round(
    sum(
      case when datediff(
        NOW(),
        coalesce(
          date(c.`claim_insert_date`),
          now()
        )
      ) BETWEEN 91
      AND 120 then
        ip2.`total_charges` + coalesce(b.`total`, 0) - coalesce(t.`total`, 0) - coalesce(a.`total`, 0)
      else
        0
      end
    ),
    2
  ) as 'field91to120',
  round(
    sum(
      case when datediff(
        NOW(),
        coalesce(
          date(c.`claim_insert_date`),
          now()
        )
      ) BETWEEN 121
      AND 150 then
        ip2.`total_charges` + coalesce(b.`total`, 0) - coalesce(t.`total`, 0) - coalesce(a.`total`, 0)
      else
        0
      end
    ),
    2
  ) as 'field121to150',
  round(
    sum(
      case when datediff(
        NOW(),
        coalesce(
          date(c.`claim_insert_date`),
          now()
        )
      ) BETWEEN 151
      AND 180 then
        ip2.`total_charges` + coalesce(b.`total`, 0) - coalesce(t.`total`, 0) - coalesce(a.`total`, 0)
      else
        0
      end
    ),
    2
  ) as 'field151to180',
  round(
    sum(
      case when datediff(
        NOW(),
        coalesce(
          date(c.`claim_insert_date`),
          now()
        )
      ) >= 181 then
        ip2.`total_charges` + coalesce(b.`total`, 0) - coalesce(a.`total`, 0) - coalesce(t.`total`, 0)
      else
        0
      end
    ),
    2
  ) as 'field181plus',
  round(
    sum(
      ip2.`total_charges` + coalesce(b.`total`, 0) - coalesce(t.`total`, 0) - coalesce(a.`total`, 0)
    ),
    2
  ) as total
FROM
  invoice i
  LEFT JOIN (
    select
      ip.invoice_procedure_invoice_id,
      sum(
        ip.`invoice_procedure_price` * ip.invoice_procedure_quentity
      ) as total_charges
    from
      invoice_procedure ip
    where
      ip.id like CONCAT(?, '%')
    group by
      ip.invoice_procedure_invoice_id
  ) as ip2 on ip2.invoice_procedure_invoice_id = i.id
  LEFT JOIN claim c ON (c.claim_invoice_id = i.id)
  LEFT JOIN (
    SELECT
      transaction.transaction_invoice_id,
      sum(transaction_amount) as total,
      max(transaction_insert_date) as TransactionInsertDate
    FROM
      transaction
    WHERE
      transaction_invoice_id LIKE CONCAT(?, '%')
      AND transaction_transaction_type_id IN (
        CONCAT(?, '-1'),
        CONCAT(?, '-8'),
        CONCAT(?, '-16'),
        CONCAT(?, '-32'),
        CONCAT(?, '-64'),
        CONCAT(?, '-256'),
        CONCAT(?, '-2048'),
        CONCAT(?, '-4096'),
        CONCAT(?, '-8192'),
        CONCAT(?, '-32768'),
        '3',
        '4',
        '9',
        '10',
        '11',
        '12',
        '15',
        '16',
        '17',
        '20',
        '21'
      )
    group by
      transaction_invoice_id
  ) t on t.transaction_invoice_id = i.`id`
  LEFT JOIN (
    SELECT
      transaction.transaction_invoice_id,
      sum(transaction_amount) as total,
      max(transaction_insert_date) as TransactionInsertDate
    FROM
      transaction
    WHERE
      transaction_invoice_id LIKE CONCAT(?, '%')
      AND transaction_transaction_type_id IN (
        CONCAT(?, '-128'),
        CONCAT(?, '-1024'),
        CONCAT(?, '-16384'),
        '13',
        '14',
        '5',
        '6',
        '7',
        '8',
        '18',
        '19'
      )
    group by
      transaction_invoice_id
  ) a on a.transaction_invoice_id = i.id
  LEFT JOIN (
    SELECT
      transaction.transaction_invoice_id,
      sum(transaction_amount) as total,
      max(transaction_insert_date) as TransactionInsertDate
    FROM
      transaction
    WHERE
      transaction_invoice_id LIKE CONCAT(?, '%')
      AND transaction_transaction_type_id IN ('2')
    group by
      transaction_invoice_id
  ) b on b.transaction_invoice_id = i.id
  LEFT JOIN patient_insurance p9_ ON (
    p9_.id = c.claim_patient_insurance_id
  )
  LEFT JOIN insurance i2 ON (
    i2.id = p9_.patient_insurance_insurance_id
  )
  LEFT JOIN medical_provider m ON (
    m.id = c.claim_billing_medical_provider_id
  )
  LEFT JOIN patient p ON (p.id = c.claim_patient_id)
WHERE
  i.id LIKE CONCAT(?, '%')
  and i2.id is not null
GROUP BY
  i2.id

select i2.`insurance_name` as insuranceName, 
        round(sum(case when datediff(NOW(),coalesce(date(c.`claim_insert_date`),now())) BETWEEN  0 AND 30 then  ip2.`total_charges` + coalesce(b.`total`,0)   - coalesce(t.`total`,0) - coalesce(a.`total`,0) else 0 end),2) as 'current',
        round(sum(case when datediff(NOW(),coalesce(date(c.`claim_insert_date`),now())) BETWEEN  31 AND 60 then ip2.`total_charges` + coalesce(b.`total`,0)  - coalesce(t.`total`,0) - coalesce(a.`total`,0) else 0 end),2) as 'field31to60',
        round(sum(case when datediff(NOW(),coalesce(date(c.`claim_insert_date`),now())) BETWEEN  61 AND 90 then ip2.`total_charges` + coalesce(b.`total`,0)  - coalesce(t.`total`,0) - coalesce(a.`total`,0) else 0 end),2) as 'field61to90',
        round(sum(case when datediff(NOW(),coalesce(date(c.`claim_insert_date`),now())) BETWEEN  91 AND 120 then ip2.`total_charges` + coalesce(b.`total`,0)  - coalesce(t.`total`,0) - coalesce(a.`total`,0) else 0 end),2) as 'field91to120',
        round(sum(case when datediff(NOW(),coalesce(date(c.`claim_insert_date`),now())) BETWEEN  121 AND 150 then ip2.`total_charges` + coalesce(b.`total`,0)  - coalesce(t.`total`,0) - coalesce(a.`total`,0) else 0 end),2) as 'field121to150',
        round(sum(case when datediff(NOW(),coalesce(date(c.`claim_insert_date`),now())) BETWEEN  151 AND 180 then ip2.`total_charges` + coalesce(b.`total`,0)  - coalesce(t.`total`,0) - coalesce(a.`total`,0) else 0 end),2) as 'field151to180',
        round(sum(case when datediff(NOW(),coalesce(date(c.`claim_insert_date`),now())) >=  181 then ip2.`total_charges` + coalesce(b.`total`,0)  - coalesce(a.`total`,0) - coalesce(t.`total`,0)  else 0 end),2) as 'field181plus',
        round(sum(ip2.`total_charges` + coalesce(b.`total`,0)  - coalesce(t.`total`,0) - coalesce(a.`total`,0)),2) as total
            FROM invoice i
            LEFT JOIN (
                select ip.invoice_procedure_invoice_id, sum(ip.`invoice_procedure_price`  * ip.invoice_procedure_quentity) as total_charges 
                from invoice_procedure ip  
                where ip.id like CONCAT(NULL, '%') 
                group by ip.invoice_procedure_invoice_id
            ) as ip2 on ip2.invoice_procedure_invoice_id = i.id
            LEFT JOIN claim c ON (c.claim_invoice_id = i.id)
            LEFT JOIN (
                SELECT transaction.transaction_invoice_id, sum(transaction_amount) as total, max(transaction_insert_date) as TransactionInsertDate 
                FROM transaction 
                WHERE transaction_invoice_id LIKE CONCAT(NULL, '%')
                AND transaction_transaction_type_id IN (
                    CONCAT(NULL, '-1'), CONCAT(NULL, '-8'), CONCAT(NULL, '-16'), CONCAT(NULL, '-32'), 
                    CONCAT(NULL, '-64'), CONCAT(NULL, '-256'), CONCAT(NULL, '-2048'), CONCAT(NULL, '-4096'), 
                    CONCAT(NULL, '-8192'), CONCAT(NULL, '-32768'), '3', '4', '9', '10', '11', '12', '15', '16', '17', '20', '21'
                ) 
                group by transaction_invoice_id
            ) t on t.transaction_invoice_id = i.`id`
            LEFT JOIN (
                SELECT transaction.transaction_invoice_id, sum(transaction_amount) as total, max(transaction_insert_date) as TransactionInsertDate 
                FROM transaction 
                WHERE transaction_invoice_id LIKE CONCAT(NULL, '%')
                AND transaction_transaction_type_id IN (
                    CONCAT(NULL, '-128'), CONCAT(NULL, '-1024'), CONCAT(NULL, '-16384'), '13', '14', '5', '6', '7', '8', '18', '19'
                ) 
                group by transaction_invoice_id
            ) a on a.transaction_invoice_id = i.id
            LEFT JOIN (
                SELECT transaction.transaction_invoice_id, sum(transaction_amount) as total, max(transaction_insert_date) as TransactionInsertDate 
                FROM transaction 
                WHERE transaction_invoice_id LIKE CONCAT(NULL, '%')
                AND transaction_transaction_type_id IN ('2') 
                group by transaction_invoice_id
            ) b on b.transaction_invoice_id = i.id
            LEFT JOIN patient_insurance p9_ ON (p9_.id = c.claim_patient_insurance_id)
            LEFT JOIN insurance i2 ON (i2.id = p9_.patient_insurance_insurance_id)
            LEFT JOIN medical_provider m ON (m.id = c.claim_billing_medical_provider_id)
            LEFT JOIN patient p ON (p.id = c.claim_patient_id)
            WHERE i.id LIKE CONCAT(NULL, '%') and i2.id is not null GROUP BY i2.id;

SELECT
  c0_.id AS id_0,
  c0_.crm_practice_name AS crm_practice_name_1,
  c0_.crm_practice_npi AS crm_practice_npi_2,
  c0_.crm_practice_acronym AS crm_practice_acronym_3,
  c0_.crm_practice_req AS crm_practice_req_4,
  c0_.crm_practice_active AS crm_practice_active_5
FROM
  crmpractice c0_
WHERE
  c0_.crm_practice_active = 0
ORDER BY
  c0_.crm_practice_name ASC

SELECT c0_.id AS id_0, c0_.crm_practice_name AS crm_practice_name_1, c0_.crm_practice_npi AS crm_practice_npi_2, c0_.crm_practice_acronym AS crm_practice_acronym_3, c0_.crm_practice_req AS crm_practice_req_4, c0_.crm_practice_active AS crm_practice_active_5 FROM crmpractice c0_ WHERE c0_.crm_practice_active = 0 ORDER BY c0_.crm_practice_name ASC;

SELECT
  t0.id AS id_1,
  t0.setting AS setting_2,
  t0.slug AS slug_3
FROM
  settings t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting AS setting_2, t0.slug AS slug_3 FROM settings t0 WHERE t0.slug = 'setting' LIMIT 1;

SELECT
  t0.enabled AS enabled_1,
  t0.salt AS salt_2,
  t0.password AS password_3,
  t0.last_login AS last_login_4,
  t0.confirmation_token AS confirmation_token_5,
  t0.password_requested_at AS password_requested_at_6,
  t0.id AS id_7,
  t0.first_name AS first_name_8,
  t0.last_name AS last_name_9,
  t0.user_type AS user_type_10,
  t0.roles AS roles_11,
  t0.email AS email_12,
  t0.email_canonical AS email_canonical_13,
  t0.username AS username_14,
  t0.username_canonical AS username_canonical_15,
  t0.distributor_id AS distributor_id_16,
  t0.crm_repo_id AS crm_repo_id_17,
  t0.practice_id AS practice_id_18,
  t0.provider_id AS provider_id_19
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.enabled AS enabled_1, t0.salt AS salt_2, t0.password AS password_3, t0.last_login AS last_login_4, t0.confirmation_token AS confirmation_token_5, t0.password_requested_at AS password_requested_at_6, t0.id AS id_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.user_type AS user_type_10, t0.roles AS roles_11, t0.email AS email_12, t0.email_canonical AS email_canonical_13, t0.username AS username_14, t0.username_canonical AS username_canonical_15, t0.distributor_id AS distributor_id_16, t0.crm_repo_id AS crm_repo_id_17, t0.practice_id AS practice_id_18, t0.provider_id AS provider_id_19 FROM user t0 WHERE t0.id = 2;