Comentarios de julianpoveda
Equipos favoritos
Todavía no tienes equipos favoritos, podrás añadirlos editando tu perfil, una vez los tengas agregados podrás seguir la información de tus equipos.
Ligas favoritas
¿No tienes ninguna liga preferida? Añade tus ligas preferidas y siempre estarás informado.
Estadísticas de julianpoveda
  • Comentarios creados: 2
  • Votos a favor: 0
  • Fotos subidas: 0
  • Videos subidos: 0
  • Usuario desde: 27 Abr 14 18:37
  • Último login: 27 Abr 14 18:39

  USO DE MEMORIA  
4,081,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Commentlist / Index )  0.0580
Total Execution Time  0.0594
  CADENA URL  
/miscomentarios/julianpoveda
  GET DATOS  
$_GET['/miscomentarios/julianpoveda']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0004  SELECT * FROM (`fa_user`) WHERE `user_name` = 'julianpoveda'
0.0029  SELECT fap.*,u.* FROM fa_user_profile fap LEFT JOIN user_stats u ON fap.id = u.id WHERE fap.id = 604571
0.0035  SELECT rf.friendId FROM rel_friends rf INNER JOIN fa_user u ON u.id = rf.friendId WHERE rf.userId = 604571 AND rf.status=1 ORDER BY rf.accuracy DESC LIMIT 1000
0.0020  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 GROUP BY dt.nameShow,l.year ORDER BY c.troncal DESC,c.main DESC,l.year DESC LIMIT 0
0.0024  SELECT SUM(votes_up) AS up,SUM(votes_down) AS down FROM comments WHERE `author_id` = 604571
0.0021  SELECT u.id,u.email,u.user_name FROM invitations i INNER JOIN fa_user u ON u.email = i.mail_friend WHERE i.userId = 604571
0.0025  SELECT u.id,u.email,u.user_name FROM invitations i INNER JOIN fa_user u ON u.email = i.mail_friend INNER JOIN rel_friends rf ON rf.friendId = u.id AND rf.userId = 604571 AND rf.status = 1 WHERE i.userId = 604571
0.0022  SELECT count(rf.id) as cuenta FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = 604571 WHERE 1 AND (rf.uidto = 604571) AND rf.del != 604571
0.0020  SELECT count(rf.friendId) as cuenta FROM rel_friends rf INNER JOIN fa_user u ON u.id = rf.friendId WHERE rf.status = 1 AND rf.userId = 604571
0.0018  SELECT COUNT(DISTINCT c.`id`) AS num_total FROM comments as c WHERE c.`author_id` = 604571
0.0018  SELECT COUNT(DISTINCT `id`) AS num_total FROM videos WHERE `author_id` = 604571
0.0018  SELECT COUNT(DISTINCT `id`) AS num_total FROM pictures WHERE `author_id` = 604571
0.0018  SELECT c.* FROM `comments` c WHERE c.`author_id` = 604571 AND c.`active`= 1 AND c.`lang` = 1 ORDER BY creation_date DESC LIMIT 0, 20
0.0020  SELECT id, alias, name, last_name, nick FROM dataplayers WHERE id IN (16967,101801)
0.0018  SELECT id, comment_id, comment, author_name, author_id, votes_up, COUNT(id) AS responses FROM comments WHERE comment_id IN (2770854,2767072) GROUP BY comment_id
0.0018  SELECT COUNT(*) AS total FROM rel_friends WHERE userId=604571 AND status=1