juanmamoreno96

juanmamoreno96

Usuario Inactivo
Este usuario se ha dado de baja
El usuario juanmamoreno96 se hada dado de baja puesto que su perfil no es accesible.

  USO DE MEMORIA  
3,919,752 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Uprofile / Index )  0.4976
Total Execution Time  0.4990
  CADENA URL  
/usuario/juanmamoreno96
  GET DATOS  
$_GET['/usuario/juanmamoreno96']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0004  SELECT * FROM (`fa_user`) WHERE `user_name` = 'juanmamoreno96'
0.0130  SELECT rf.friendId FROM rel_friends rf INNER JOIN fa_user u ON u.id = rf.friendId WHERE rf.userId = 149035 AND rf.status = 1 LIMIT 5000
0.0127  SELECT *,rf.id as idmsg FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = rf.uidsent WHERE rf.uidto = 149035 ORDER BY rf.id DESC LIMIT 0,10
0.0132  SELECT COUNT(DISTINCT c.`id`) AS num_total FROM comments as c WHERE c.`author_id` = 149035
0.0131  SELECT c.* FROM `comments` c WHERE c.`author_id` = 149035 AND c.`active`= 1 AND c.`lang` = 1 ORDER BY creation_date DESC LIMIT 0, 10
0.0134  SELECT fap.*,u.* FROM fa_user_profile fap LEFT JOIN user_stats u ON fap.id = u.id WHERE fap.id = 149035
0.0137  SELECT * FROM `rel_goals` as rg INNER JOIN goals as g ON g.id = rg.goal_id WHERE rg.userId = 149035 ORDER BY g.class DESC, rg.datetime DESC LIMIT 100
0.0131  SELECT SUM(votes_up) AS up,SUM(votes_down) AS down FROM comments WHERE `author_id` = 149035
0.0126  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.0171  SELECT * FROM `g_totals` WHERE userId = 149035
0.0129  SELECT *,rf.id as idmsg FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = rf.uidsent WHERE rf.uidto = 149035 ORDER BY rf.id DESC LIMIT 0,3
0.0295  SELECT count(rf.id) as cuenta FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = 149035 WHERE 1 AND (rf.uidto = 149035) AND rf.del != 149035
0.0132  SELECT * FROM dreamteam_data dd WHERE dd.userId = 149035 ORDER BY profile DESC, creation_date DESC LIMIT 1
0.0298  SELECT rel.pos,rel.team_number,rel.player_id,dp.alias,dp.id,dp.nick,dp.last_name,dp.name FROM rel_dreamteam rel INNER JOIN dreamteam_data dd ON dd.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE dd.id = 86163
0.0228  SELECT COUNT(rd.id) as cuenta FROM dreamteam_data rd where userId = 149035
0.0127  SELECT name,id FROM dreamteam_data rd where userId = 149035 ORDER BY profile DESC, creation_date DESC LIMIT 3
0.0125  SELECT rf.friendId FROM rel_friends rf INNER JOIN fa_user u ON u.id = rf.friendId WHERE rf.userId = 149035 AND rf.status = 1 ORDER BY u.last_activity DESC LIMIT 20
0.0125  SELECT a.*,fa.user_name FROM activity a INNER JOIN fa_user fa ON fa.id = a.userId WHERE userId IN (149035,420038,52091,214619,155018) ORDER BY a.datetime DESC LIMIT 0,60
0.0126  SELECT a.*,fa.user_name FROM activity a INNER JOIN fa_user fa ON fa.id = a.userId WHERE userId = 149035 ORDER BY id DESC LIMIT 0,60
0.0127  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 = 149035 ORDER BY rf.update_date DESC LIMIT 0,10
0.0125  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 = 149035 GROUP BY rg.group_id ORDER BY rg.accuracy DESC LIMIT 4
0.0130  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 = 149035 GROUP BY rg.user_id
0.0126  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 = 149035 AND rf.status = 1 ORDER BY status ASC, rf.accuracy DESC LIMIT 0,12
0.0129  SELECT COUNT(*) AS total FROM rel_friends WHERE userId=149035 AND status=1
0.0129  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 = 149035 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0128  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video WHERE 1 AND p.author_id = 149035 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0131  SELECT COUNT(DISTINCT `id`) AS num_total FROM videos WHERE `author_id` = 149035
0.0131  SELECT COUNT(DISTINCT `id`) AS num_total FROM pictures WHERE `author_id` = 149035