Sobre RotKeh
Héctor Adrian Ayala Zamora
Soy de Mexico, le voy al Cruz Azul, me encanto la pagina ya que me gustan mucho las estadisticas en el futbol... por eso me he agregado a su lista...
Amigos 18 Más amigos
  • petersinpan
  • jajaj
  • Ramirez99
  • fhita
  • xerezanah
  • rayo
  • ghitap
  • juanegro83
  • tioPencho
  • Angie
  • VALLEJANO
  • FIRICUNDINO
Grupos 3
Comentarios 0
RotKeh todavía no ha escrito ningún comentario
Actividad

RotKeh todavía no tiene actividad

Ligas favoritas
Estadísticas de RotKeh
  • Comentarios creados: 0
  • Votos a favor: 0
  • Amigos: 18
  • Fotos subidas: 0
  • Videos subidos: 0
  • Usuario desde: 15 May 09 16:27
  • Último login: 19 May 09 01:13

  USO DE MEMORIA  
3,948,128 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Uprofile / Index )  0.0995
Total Execution Time  0.1009
  CADENA URL  
/usuario/RotKeh
  GET DATOS  
$_GET['/usuario/RotKeh']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0003  SELECT * FROM (`fa_user`) WHERE `user_name` = 'RotKeh'
0.0023  SELECT rf.friendId FROM rel_friends rf INNER JOIN fa_user u ON u.id = rf.friendId WHERE rf.userId = 1079 AND rf.status = 1 LIMIT 5000
0.0020  SELECT *,rf.id as idmsg FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = rf.uidsent WHERE rf.uidto = 1079 ORDER BY rf.id DESC LIMIT 0,10
0.0018  SELECT COUNT(DISTINCT c.`id`) AS num_total FROM comments as c WHERE c.`author_id` = 1079
0.0018  SELECT c.* FROM `comments` c WHERE c.`author_id` = 1079 AND c.`active`= 1 AND c.`lang` = 1 ORDER BY creation_date DESC LIMIT 0, 10
0.0020  SELECT fap.*,u.* FROM fa_user_profile fap LEFT JOIN user_stats u ON fap.id = u.id WHERE fap.id = 1079
0.0020  SELECT * FROM `rel_goals` as rg INNER JOIN goals as g ON g.id = rg.goal_id WHERE rg.userId = 1079 ORDER BY g.class DESC, rg.datetime DESC LIMIT 100
0.0018  SELECT SUM(votes_up) AS up,SUM(votes_down) AS down FROM comments WHERE `author_id` = 1079
0.0086  SELECT dt.nameShow,dt.basealias, c.name,c.logo, c.alias, l.group_code, l.total_group, l.id, dt.id as idTeam FROM datateams as dt INNER JOIN teams as t ON t.teamId = dt.id INNER JOIN leagues as l ON l.id = t.league_id INNER JOIN categories as c ON c.id = l.categoryId WHERE 0 OR dt.id = 705 OR dt.id = 429 OR dt.id = 1563 GROUP BY dt.nameShow,l.year ORDER BY c.troncal DESC,c.main DESC,l.year DESC LIMIT 3
0.0027  SELECT l.id,l.year,t.id as teamId FROM leagues l INNER JOIN categories c ON l.categoryId = c.id INNER JOIN teams as t ON t.league_id = l.id WHERE c.alias = 'apertura_mexico' AND t.teamId = 705 AND l.group_code = 1 ORDER BY l.year DESC LIMIT 1
0.0026  SELECT l.id,l.year,t.id as teamId FROM leagues l INNER JOIN categories c ON l.categoryId = c.id INNER JOIN teams as t ON t.league_id = l.id WHERE c.alias = 'apertura_mexico' AND t.teamId = 705 AND l.group_code = 1 ORDER BY l.year DESC LIMIT 1
0.0026  SELECT l.id,l.year,t.id as teamId FROM leagues l INNER JOIN categories c ON l.categoryId = c.id INNER JOIN teams as t ON t.league_id = l.id WHERE c.alias = 'apertura_mexico' AND t.teamId = 705 AND l.group_code = 1 ORDER BY l.year DESC LIMIT 1
0.0019  SELECT l.group_code,l.total_group,c.name,c.alias, esl.points FROM editor_stats_leagues esl INNER JOIN leagues l ON l.id = esl.league_id INNER JOIN categories c ON c.id = l.categoryId WHERE esl.user_id = 1079 ORDER BY l.year DESC,esl.points DESC LIMIT 3
0.0055  SELECT * FROM `g_totals` WHERE userId = 1079
0.0019  SELECT *,rf.id as idmsg FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = rf.uidsent WHERE rf.uidto = 1079 ORDER BY rf.id DESC LIMIT 0,3
0.0109  SELECT count(rf.id) as cuenta FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = 1079 WHERE 1 AND (rf.uidto = 1079) AND rf.del != 1079
0.0019  SELECT * FROM dreamteam_data dd WHERE dd.userId = 1079 ORDER BY profile DESC, creation_date DESC LIMIT 1
0.0020  SELECT rf.friendId FROM rel_friends rf INNER JOIN fa_user u ON u.id = rf.friendId WHERE rf.userId = 1079 AND rf.status = 1 ORDER BY u.last_activity DESC LIMIT 20
0.0018  SELECT a.*,fa.user_name FROM activity a INNER JOIN fa_user fa ON fa.id = a.userId WHERE userId IN (1079,1054,1072,1049,1061,1073,35,1051,1070,1065,1076,1069,1078,1058,1062,1057,1060,1067,1059) ORDER BY a.datetime DESC LIMIT 0,60
0.0019  SELECT a.*,fa.user_name FROM activity a INNER JOIN fa_user fa ON fa.id = a.userId WHERE userId = 1079 ORDER BY id DESC LIMIT 0,60
0.0021  SELECT 1 as typew,u.user_name,u.id as user_id,rf.date,rf.message,rf.votes_up,rf.id as idmsg,rf.replies,rf.picture_id,rf.video_id,rf.new_id,rf.link_txt,rf.name_txt,u.user_name as wall_name FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = rf.uidsent WHERE rf.reply_msg = 0 AND rf.uidto = 1079 ORDER BY rf.update_date DESC LIMIT 0,10
0.0018  SELECT g.id,g.name,rg.status,g.alias,g.members FROM rel_groups rg INNER JOIN groups g ON g.id = rg.group_id WHERE rg.status = 1 AND rg.user_id = 1079 GROUP BY rg.group_id ORDER BY rg.accuracy DESC LIMIT 4
0.0020  SELECT count(g.id) as cuenta FROM rel_groups rg INNER JOIN groups g ON g.id = rg.group_id WHERE rg.status = 1 AND rg.user_id = 1079 GROUP BY rg.user_id
0.0018  SELECT u.user_name,rf.friendId,rf.status,u.id,u.changeA FROM rel_friends rf INNER JOIN fa_user u ON u.id = rf.friendId WHERE rf.userId = 1079 AND rf.status = 1 ORDER BY status ASC, rf.accuracy DESC LIMIT 0,12
0.0019  SELECT COUNT(*) AS total FROM rel_friends WHERE userId=1079 AND status=1
0.0019  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE 1 AND p.author_id = 1079 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0018  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video WHERE 1 AND p.author_id = 1079 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019  SELECT COUNT(DISTINCT `id`) AS num_total FROM videos WHERE `author_id` = 1079
0.0019  SELECT COUNT(DISTINCT `id`) AS num_total FROM pictures WHERE `author_id` = 1079