sql	time
SELECT id_celeb, image,nameceleb,curscore as currentscore, prevScore1 as previousscore, ROUND(avgScore,2) as avescore FROM r_Celeb WHERE nameceleb LIKE '%%' ORDER BY avescore DESC LIMIT 0,10	0.169010162354
SELECT id_celeb, image,nameceleb,curscore as currentscore, prevScore1 as previousscore, ROUND(avgScore,2) as avescore FROM r_Celeb WHERE nameceleb LIKE '%%' ORDER BY currentscore DESC LIMIT 0,10	0.168220996857
SELECT id_celeb, image,nameceleb,CAST((curscore-prevScore1) AS SIGNED) 'diff' FROM r_Celeb WHERE nameceleb LIKE '%%' ORDER BY diff DESC LIMIT 0,10	0.16814494133
select * from r_UserGameScore ORDER BY score DESC LIMIT 0,10	0.16811299324
SELECT t3.id_player as id_player, t3.playername, t3.score as score FROM r_UserGameScore t3 INNER JOIN (SELECT t1.id_game,max(t1.score) as score FROM r_UserGameScore as t1, controls as t2 WHERE t1.id_game=t2.game_id AND t2.stop>NOW() GROUP BY t1.id_game) t4 ON (t3.id_game=t4.id_game AND t3.score=t4.score) ORDER BY t3.score DESC	0.168354988098
select ugws.score,ugws.id_player,p.playername from r_UserGameWeekScore ugws join usergame ug on ugws.id_usergame=ug.id_usergame join players p on p.id_player=ug.id_player where date(adddate('2010-09-05', 0)) = ugws.weekdate order by score desc LIMIT 0,10 ;	0.167792081833

---

Controller : stats
Event : Go
View : toptable2
View : toptable2
View : horizontal
View : toptable2
View : toptable2
View : horizontal
View : toptable2
View : toptable2
View : horizontal
View : vertical
View : statspage
  script : include/prototype-1.6.0.2.js
  script : include/ajaxDropdown.js
  script : scripts/gameselect.css
  script : scripts/main.css
View : vertical
View : header_public
  script : scripts/main.css
  script : scripts/header_public.css
  script : scripts/main.js
View : Tmaster
View : footer
  script : scripts/gameselect.css
  script : include/chat.js
  script : include/ProtoChart.js
  script : include/trade.js
  script : include/ajaxdropdownB.js
  script : test/ajaxr.js
  script : include/footer2.css
  script : _ajdd.addTarget('txtCelebFooter', 'celebs', {dir: 1});
View : table