Log in

View Full Version : Show Quries Exce'd


Steve123
07-08-2003, 06:52 AM
Hey Guys,

I have search the forums for a hack that shows what sql quries were exce when the page was loaded..

-i wasn't suscessful

I was wondering if anyone knows how to do this? as i am trying to reduce the number of quries on my forum (mainly forumhome).

I know there is hack out there that will do this for me, but i would still like to see what is getting exec'd as i have alot of my own hacks installed.

I know there is ways to do it like auditing the MySQL Server log, or goin thought all the $query's in the .php file. I am just asking here first before i go to thoes extreams.

Thanks in Advanced
/Steve

Xenon
07-08-2003, 08:44 AM
you don't need a hack for it.

just add $debug=1; into your config.php and then add &showqueries=1&explain=1 behind the url :)

Steve123
07-08-2003, 08:51 AM
lol ++++ hey..

Dident even know about that...

feel embarresed actually.. lol :S
*hopes it wasent in the FAQ or manual* haha

will give it a go
thanks