MySQL and PHP IDE Unique Feature [closed]

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 11 years ago.

I have been searching the internet, and couldn't find what I'm looking for but it's quite unique and it could easily get lost in the search results.

I'm looking at getting a PHP IDE, but it has to have MySQL integration. However, not just any integration. I've seen the "explorer" type integrations where you can browse your database remotely. I'd really like something that let's your run the PHP script on your page AND execute the MySQL queries. As part of the execution it'd be nice after it ran those queries to capture them all so you could see execution time, number of results, etc. It would also be fun if it was able to analyze your queries to make sure it was running indexes properly.

Sure it'd be fun to run all the queries one by one (not), but it would help give me an idea of how efficient my site is running. I think tha开发者_如何学运维t www.enginsite.com has something similar and www.nusphere.com did, too. I just wasn't sure if it was exactly what I was looking for.

I don't think this is out there and could be a pipe dream, but if it's out there, I wanna know.

---

Try either netbeans or eclipse. Both have mysql integration and netbeans has an excellent debugger allowing you to step through queries.

Toad sql is a very good mysql tool for testing sql.

As far as integrating the two are concerned you could always use firebug with firefox to test the speed your pages load.