villoria87

villoria87

Usuario Inactivo
Este usuario está baneado
El usuario villoria87 está baneado por lo tanto su perfil no es accesible.

  USO DE MEMORIA  
3,893,232 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Uprofile / Index )  0.3800
Total Execution Time  0.3814
  CADENA URL  
/usuario/villoria87
  GET DATOS  
$_GET['/usuario/villoria87']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0005  SELECT * FROM (`fa_user`) WHERE `user_name` = 'villoria87'
0.0682  SELECT rf.friendId FROM rel_friends rf INNER JOIN fa_user u ON u.id = rf.friendId WHERE rf.userId = 1566039 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 = 1566039 ORDER BY rf.id DESC LIMIT 0,10
0.0104  SELECT COUNT(DISTINCT c.`id`) AS num_total FROM comments as c WHERE c.`author_id` = 1566039
0.0178  SELECT c.* FROM `comments` c WHERE c.`author_id` = 1566039 AND c.`active`= 1 AND c.`lang` = 1 ORDER BY creation_date DESC LIMIT 0, 10
0.0022  SELECT fap.*,u.* FROM fa_user_profile fap LEFT JOIN user_stats u ON fap.id = u.id WHERE fap.id = 1566039
0.0104  SELECT * FROM `rel_goals` as rg INNER JOIN goals as g ON g.id = rg.goal_id WHERE rg.userId = 1566039 ORDER BY g.class DESC, rg.datetime DESC LIMIT 100
0.0044  SELECT SUM(votes_up) AS up,SUM(votes_down) AS down FROM comments WHERE `author_id` = 1566039
0.0026  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.0092  SELECT * FROM `g_totals` WHERE userId = 1566039
0.0151  SELECT *,rf.id as idmsg FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = rf.uidsent WHERE rf.uidto = 1566039 ORDER BY rf.id DESC LIMIT 0,3
0.0159  SELECT count(rf.id) as cuenta FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = 1566039 WHERE 1 AND (rf.uidto = 1566039) AND rf.del != 1566039
0.0600  SELECT * FROM dreamteam_data dd WHERE dd.userId = 1566039 ORDER BY profile DESC, creation_date DESC LIMIT 1
0.0245  SELECT rf.friendId FROM rel_friends rf INNER JOIN fa_user u ON u.id = rf.friendId WHERE rf.userId = 1566039 AND rf.status = 1 ORDER BY u.last_activity DESC LIMIT 20
0.0062  SELECT a.*,fa.user_name FROM activity a INNER JOIN fa_user fa ON fa.id = a.userId WHERE userId IN (1566039,2684659,946360,235713,1286295,1843566,2057050,26432,725487,919382,1566039,2350566,1094773,2391413,2515016,2570190,1918657,2722099,2808160,934461,2697219) ORDER BY a.datetime DESC LIMIT 0,60
0.0036  SELECT a.*,fa.user_name FROM activity a INNER JOIN fa_user fa ON fa.id = a.userId WHERE userId = 1566039 ORDER BY id DESC LIMIT 0,60
0.0150  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 = 1566039 ORDER BY rf.update_date DESC LIMIT 0,10
0.0121  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 = 1566039 GROUP BY rg.group_id ORDER BY rg.accuracy DESC LIMIT 4
0.0068  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 = 1566039 GROUP BY rg.user_id
0.0062  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 = 1566039 AND rf.status = 1 ORDER BY status ASC, rf.accuracy DESC LIMIT 0,12
0.0195  SELECT COUNT(*) AS total FROM rel_friends WHERE userId=1566039 AND status=1
0.0038  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 = 1566039 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0082  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video WHERE 1 AND p.author_id = 1566039 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0230  SELECT COUNT(DISTINCT `id`) AS num_total FROM videos WHERE `author_id` = 1566039
0.0230  SELECT COUNT(DISTINCT `id`) AS num_total FROM pictures WHERE `author_id` = 1566039