I set recursive = -1 in Model, but actually it got reset to 1 because I have two contains in find(). So the solution I figured out was commenting contains, and adding additional “find all” against these two tables after. However, I am not sure why Deep associations (in Dbosource.php) took so long. I didn’t see the slow queries when it did deep associations though. Is it bug?
@raul338, it returns less than 10k records, and the sql execution is about 20 microseconds.