Is there a way to access data from different tables more efficiently than using foreach loops? Specifically, in this example I am trying to retrieve specific data for a service from one table, but other important data is in another table. So, the way it works now is that for every service it goes through whole another table with data trying to find an instance (or row) with the same URL as current service and if it finds it takes from that row the required information.

I believe that there is a better way to get the row that I need more quickly based on the instance id or even the URL but could not figure out how to approach it better. So, the question is if there is a method (function) like find(), for example or something like that to help with this issue.

In the following screenshot the highlighted foreach is the one i would like to replace with the some find function or something. Of course, if there is a better or faster solution, I would appreciate any suggestions.