SQL SELECT query takes too long after updating the version
Have you tried the query without joining against a subselect?

SELECT 
  pd.meterclass, pd.meterscore, pd.rt_url, pd.imdbId, pd.title, pd.adult,
  pd.backdrop,pd.budget, pd.homepage, pd.plot, pd.poster, pd.release_date,
  pd.revenue, pd.runtime, pd.language, pd.tagline, pd.status, 
  pd.imdbRatings, pd.imdbVotes, mg.genre_id, cst.cast_id,  
  cst.character_name, cst.name, 
  cst.profile_path, crw.job, crw.name as crew_name, 
  crw`enter code here`.profile_path as crew_profile_path, crw.id as crew_id, 
  crw.credit_id as crew_credit_id 
FROM movie_data_primary pd
INNER JOIN movie_genre mg ON pd.cinestopId = mg.cinestopId 
INNER JOIN movie_cast cst ON cst.cinestopId  = pd.cinestopId 
INNER JOIN movie_crew crw ON crw.cinestopId = cst.cinestopId;
WHERE pd.cinestopId="8QRJTD"