MTL - Resurrection, Fortunately, I Can Wear the Heavens - Chapter 219 comminicate

Perhaps it is the choice of fate. As a senior otaku, Qian Lingfeng got the “steel shell system”. However, when he swept the world with the system, became a local rich man, made all kinds of beautiful women, opened a harem, and realized the ultimate fantasy of thousands of otaku, he found that things seemed far from simple!
When the end comes, biochemical zombies suddenly come down, fierce beasts are in power, bloodthirsty zerg roam to kill the world, and human lives are comparable to dirt. Where will weak human beings go in this world? Is humanity going to be extinct? Or … can an otaku save the fate of the human race?

- Description from Novelupdates

Being able to see into people's past has no real appeal for the teenager this story is about, letting him use it only as amusement and to show off when he was drunk.Never watch into someone's past beyond a superficial level.Never try to find out more than you should.NEVER. EVER. LOOK. INTO. THE. FUTURE.But everything changed the moment he was forced to look into the future, was forced to investigate a murder, and was forced to make the acquaintance of the victim's twin brother('s fists).The more time passed, the more it appeared that the primary reason for this murder wasn't a local problem, but a global one.This single, marred corpse was the beginning of a threat that would shake the world.(MC looses a screw when he enters the prison)BL, first-person view; MC is shuo (perhaps even a reversible couple); love interest falls in love first; both MC and ML are straight, mutual bending, Enemies to Lovers

“My name is Zeon, and my weapon is the entire desert.”

The Earth underwent terraforming. As a result, the oceans evaporated, and the land transformed into sand.

On the desertified Earth, Zeon became the sole Sand Mage.

The world named him the Sand Ghost.

Sen, the last and most powerful dragon left roaming the skies causing chaos and destruction across the land. When all hope is lost the human race call upon their last hope, a powerful witch. Unable to destroy the dragon the witch uses the last of her power to cast a spell. Sen has not been defeated but has now been reborn as a human.