Need changes /features in my website. PHP/Laravel/MySQL.

Hi, I need changes / features in my small social networking website : [login to view URL], which has been developed using Laravel / MySQL. Following is the first list of features. Once the project is finished, I have a second list of features/edits, so I am looking for a healthy relationship instead of a one-off project. Here is the list of important features : 1) When I scale the database, the homepage becomes slow. I guess, this is due to : Because we are fetching all the posts and then running an algorithm on it. Instead, I want it changed like : a cache of top posts should be pre-calculated (every 30 seconds) and we will just fetch it... or, something else, to make it faster. 2) Same needs to be done on the back-end also. As the database is growing, the front-end and back-end both are becoming slower. 3) A POST section on dashboard that should take user to post article page, something like Facebook has on its homepage. 4) Import existing blog posts from user's blogs on POST article needs to be implemented. 5) Change the code so that for posts with no cover images : [login to view URL] image does not show. 6) Location specific updates (based on user's location-thru IP or browser) for the events, meetups and jobs on his homepage. Location Based Updates on the homepage (e.g., if the user is from Chandigarh, the event or other updates he receives are from Chandigarh). This feature is applicable both if the user is logged in, or NOT logged in (based on the IP). Hence, the updates shown are only from user's city or within ~100km of user's city or geolocation. 7) User dashboard not populating on a https connection, some other errors are also there. Here are the list of trivial features : 1) Design and Create a sign up page for the website that needs to have dynamic text and images defined by me at the back-end and based on the URL, the text and images will change. Upon signing up on that particular page, user would have joined a particular group automatically, for which that page is. 2) Custom HELP Section needs to be implemented like FaceBook or any other very good help sections. The existing help section needs to redirect to new help. I should be able to edit and arrange the posts from backend. 3) Move one section/div from the profile to homepage & fix the APIs there. 4) A small Tip needs to be shown when user is clicking the groups he is posting a post in. 5) Show the first-time user some tips on where he can do what <- A small guide as to where what things lie. 6) A tip while signing up that you can click on the arrow button to see sub-groups, if a user selects a group (which has sub-groups) <- only once. 7) Show the first-time user some tips on where he can do what <- A small guide as to where what things lie. I have partial code for these below mentioned features. Needs to be checked, tested and implemented (either from scratch or using the existing code): 1) Implement username functionality in the profiles, like facebook's @ . Back-end option needs to be provided where I can blacklist some usernames. 2) Implement @ functionality to tag people in updates, messages and corresponding notifications. 3) Following a post needs to be implemented. 4) Two pages need to be coded (user activity on the website AND member of groups). 5) Froala editor needs to be implemented on POST pages. Needs to work flawlessly according to current flow. Needs to be mobile optimised and some features of that editor needs to be tuned/disabled. Full screen needs to auto-enable when a user clicks on that. OTHER ABSOLUTELY IMPORTANT THINGS : 1) An expert knowledge of GIT is required. You are supposed to work on every new feature on a different branch on its own. 2) You should have a public development server of your own, where you will host the project and I can test the changes at my convenience. 3) Everything needs to be developed from a mobile-first perspective, rather than a desktop-first perspective.