Context. Gravitational lensing is a powerful tool for studying the distribution of mass in the Universe. Understanding the magnification bias effect in gravitational lensing and its impact on the flux of sub-millimetre galaxies (SMGs) is crucial for accurate interpretations of observational data. Aims. This study aims to investigate the magnification bias effect in the context of gravitational lensing and analyse the mass density profiles of different types of foreground lenses, including quasi-stellar objects (QSOs), galaxies, and galaxy clusters. The specific goals are to compare the lens types, assess the impact of angular resolution on the analysis, and determine the adequacy of theoretical mass density profiles in explaining the observed data. Methods. The magnification bias was estimated using the cross-correlation function between the positions of background SMGs and foreground lens samples. Stacking techniques were employed to enhance the signal at smaller angular separations, and the more precise positions from the WISE catalogue were utilised to improve positional accuracy. Four different theoretical mass density profiles were analysed to extract additional information. Results. The cross-correlation measurements revealed distinctive central excess and outer power-law profiles, with a lack of signal in the intermediate region. The lens types exhibited varying signal strengths, with QSOs producing the strongest signal and galaxy clusters showing weaker signals. The analysis of mass density profiles indicated limitations in the selected profiles’ ability to explain the observed data, highlighting the need for additional considerations. The lack of extended emission in the QSO sample suggested possible influences from close satellites along the line of sight in the other lens types. Conclusions. The study provides valuable insights into the magnification bias effect and mass density profiles in gravitational lensing. The results suggest the presence of isolated galactic halos and the importance of considering environmental factors and close satellites in future investigations. The derived masses and best-fit parameters contribute to our understanding of lensing systems and provide constraints on the nature of central galaxies. Notably, the intriguing lack of signal around 10 arcsec challenges current understanding and calls for further quantitative analysis and confirmation of the observed feature.