kjb15

kjb15

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

  USO DE MEMORIA  
4,041,032 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Uprofile / Index )  0.1528
Total Execution Time  0.1544
  CADENA URL  
/usuario/kjb15
  GET DATOS  
$_GET['/usuario/kjb15']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0005  SELECT * FROM (`fa_user`) WHERE `user_name` = 'kjb15'
0.0040  SELECT rf.friendId FROM rel_friends rf INNER JOIN fa_user u ON u.id = rf.friendId WHERE rf.userId = 165173 AND rf.status = 1 LIMIT 5000
0.0024  SELECT *,rf.id as idmsg FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = rf.uidsent WHERE rf.uidto = 165173 ORDER BY rf.id DESC LIMIT 0,10
0.0028  SELECT COUNT(DISTINCT c.`id`) AS num_total FROM comments as c WHERE c.`author_id` = 165173
0.0032  SELECT c.* FROM `comments` c WHERE c.`author_id` = 165173 AND c.`active`= 1 AND c.`lang` = 1 ORDER BY creation_date DESC LIMIT 0, 10
0.0027  SELECT dt.nameShow, dt.basealias, t.name FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 2401
0.0026  SELECT dt.nameShow, dt.basealias, t.name FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 2440
0.0099  SELECT dt.nameShow, dt.basealias, t.name FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 2399
0.0020  SELECT dt.nameShow, dt.basealias, t.name FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 2432
0.0019  SELECT id, alias, name, last_name, nick FROM dataplayers WHERE id IN (8954)
0.0018  SELECT id, year FROM leagues WHERE id IN (2401,2401,2401,2440,2440,2432,2432,2432,2432)
0.0020   SELECT c.id, c.league_id, dt1.nameShow AS team1_name, dt2.nameShow AS team2_name, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.extra FROM calendars2014 AS c INNER JOIN datateams AS dt1 ON c.datateam1=dt1.id INNER JOIN datateams AS dt2 ON c.datateam2=dt2.id WHERE c.id IN (27545,27546,16265,7042,7019)
0.0019  SELECT id, comment_id, comment, author_name, author_id, votes_up, COUNT(id) AS responses FROM comments WHERE comment_id IN (2158967,2158963,2158957,2158952,2158951,2158845,2158399,2151163,2151162,2151149) GROUP BY comment_id
0.0021  SELECT fap.*,u.* FROM fa_user_profile fap LEFT JOIN user_stats u ON fap.id = u.id WHERE fap.id = 165173
0.0021  SELECT * FROM `rel_goals` as rg INNER JOIN goals as g ON g.id = rg.goal_id WHERE rg.userId = 165173 ORDER BY g.class DESC, rg.datetime DESC LIMIT 100
0.0020  SELECT SUM(votes_up) AS up,SUM(votes_down) AS down FROM comments WHERE `author_id` = 165173
0.0019  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.0020  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 = 165173 ORDER BY l.year DESC,esl.points DESC LIMIT 3
0.0066  SELECT * FROM `g_totals` WHERE userId = 165173
0.0020  SELECT *,rf.id as idmsg FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = rf.uidsent WHERE rf.uidto = 165173 ORDER BY rf.id DESC LIMIT 0,3
0.0170  SELECT count(rf.id) as cuenta FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = 165173 WHERE 1 AND (rf.uidto = 165173) AND rf.del != 165173
0.0028  SELECT * FROM dreamteam_data dd WHERE dd.userId = 165173 ORDER BY profile DESC, creation_date DESC LIMIT 1
0.0162  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 = 47963
0.0118  SELECT COUNT(rd.id) as cuenta FROM dreamteam_data rd where userId = 165173
0.0024  SELECT name,id FROM dreamteam_data rd where userId = 165173 ORDER BY profile DESC, creation_date DESC LIMIT 3
0.0019  SELECT rf.friendId FROM rel_friends rf INNER JOIN fa_user u ON u.id = rf.friendId WHERE rf.userId = 165173 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 (165173,203170,49451,119887,3435,373859,335502,267514,305265,179943,252335,131601,215620,165011,316988,118539,120011,160965,99324) ORDER BY a.datetime DESC LIMIT 0,60
0.0018  SELECT a.*,fa.user_name FROM activity a INNER JOIN fa_user fa ON fa.id = a.userId WHERE userId = 165173 ORDER BY id DESC LIMIT 0,60
0.0019  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 = 165173 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 = 165173 GROUP BY rg.group_id ORDER BY rg.accuracy DESC LIMIT 4
0.0021  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 = 165173 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 = 165173 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=165173 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 = 165173 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 = 165173 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0018  SELECT COUNT(DISTINCT `id`) AS num_total FROM videos WHERE `author_id` = 165173
0.0018  SELECT COUNT(DISTINCT `id`) AS num_total FROM pictures WHERE `author_id` = 165173