No acceleration when pressing the accelerator, there is no power and the tachometer goes over 3000

Did you overheat this engine?

Get a code reader and plug it in. The check engine light might not be working.
autozone etc. can check the codes for free.

You will need to have the fuel pressure monitored under a load with a special tool and also drive it for a while and see if the check engine light comes on, if it does have the system scanned and diagnose the codes received.

Toyota had a recall on the accelerator pedals/ cables.

2005 BUICK LESABRE TACHOMETER DOES NOT REGISTER WHEN ENGINE IS RUNNING. SOMETIMES IT BARELY MOVES, THEN GOES BACK TO 0
SAME CAR HAD SPEEDOMETER QUIT, REPLACED WITH NEW SENSOR, DROVE ABOUT 1300 MILES AND IT QUIT AGAIN. CLEANED THE SENSOR, WORKS OK NOW.

i had a 2001 aurora with the same exact problem. lucky for me a drunk driver smashed into it with a plow truck and it tumbled down a cliff into a river while it was parked and they gave me 12k for the car that i paid 8900 for .
i beilive its and ignition problem

Your problem is difficult to diagnose in part because of limited info to go on. I have a couple of questions and some possible solutions. First of all, I'm making an assumption since you speak of second gear, that you have a manual transmission. Secondly, the spedo measures transmission output and translates to speed on your instrument panel. It sounds as if the tachometer is racing up rather than the spedo. The fact that it does good in a lower gear than a higher ratio indicates possibly that your clutch is slipping during acceleration. If you can clarify a few things perhaps I can be of more assistance with your problem. #1 Is it manual shift? #2 Is it possible that your tachometer is going up and not the speedometer?

could be a brake light switch fault,be interested to know what they found.....vw specialist for 28 years, let me know what they find please

Check that transmission fluid if its an automatic, should be full and clean, if manual trans clutch probably slipping

Drive slower and easier. about 1 or 2 BELOW THE SPEED LIMIT DON'T PASS ANYONE . When you accelerate accelerate nice and easy watch the tachometer try to keep it below 3000 rpm all the way up to your cruise speed nice and easy don't worry about the guy behind you . Brake easy if you are coming to a light take your foot off and coast and try to time the light so its green when you get there. then EASY EASY on the gas keep it under 3000 RPMS all the time you are accelerating.
No special oil no special spark plugs or fancy air filters just factory parts whren you tune up every 3 or 4 years and change your oil about every 3 or 4 years yes 3 or 4 years it wont hurt it a bit just remember to always check the oil and add if it gets 1/2 Qt low. change the fuel filter EVERY EVERY 15,000 MILES fuel injection professional pressure cleaning once a year Air filter when it is dirty, please dont believe all those gimicks out there I have a car we change the oil about every 4 years and it has 350,000 miles no engine work yet runs every day passes emsssions every year no repairs needed fuel filters once a year or 15,000 miles