Mechanistic insights on heterogeneous photocatalysis for the synthesis of high-value added compounds