Extreme Delay in Sync time (Minutes long)

[Rurrea]

The degree of parallelism is high. 

My Order Table: 27K rows, 13 columns

Order Detail Table: 37K rows. 7 columns

Product Table: 42K rows, 11 columns

Other references in Order Table:

Customer Payments, deliveries, warranties, Furniture, and a few others

My Order table: has several virtual columns that may be the main issue, but when removed still extremely slow.

How can i resolve this? App is becoming unusable at this point.