Sobre piratapopuz
Todavía no ha escrito nada en este apartado.
Amigos 11
  • monterommonterom
  • rockhell
  • olimpus
  • rafa2000
  • scapde
  • miforofavorito
  • celtavictorhenar
  • rojiblanco
  • malagaoviedones
  • gorkalaves96
  • j_aime_8
Grupos 0
piratapopuz aún no pertenece a ningún grupo
Comentarios 166 Más comentarios

piratapopuz todavía no tiene actividad

Equipos favoritos
piratapopuz todavía no tiene equipos favoritos.
Ligas favoritas
piratapopuz aún no ha decidido cuál es su liga preferida
Estadísticas de piratapopuz
  • Comentarios creados: 166
  • Votos a favor: 92
  • Amigos: 11
  • Fotos subidas: 0
  • Videos subidos: 0
  • Usuario desde: 01 Ene 13 23:46
  • Último login: 19 Jul 13 02:38

  USO DE MEMORIA  
4,049,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Uprofile / Index )  0.5521
Total Execution Time  0.5535
  CADENA URL  
/usuario/piratapopuz
  GET DATOS  
$_GET['/usuario/piratapopuz']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0004  SELECT * FROM (`fa_user`) WHERE `user_name` = 'piratapopuz'
0.0148  SELECT rf.friendId FROM rel_friends rf INNER JOIN fa_user u ON u.id = rf.friendId WHERE rf.userId = 428438 AND rf.status = 1 LIMIT 5000
0.0147  SELECT *,rf.id as idmsg FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = rf.uidsent WHERE rf.uidto = 428438 ORDER BY rf.id DESC LIMIT 0,10
0.0153  SELECT COUNT(DISTINCT c.`id`) AS num_total FROM comments as c WHERE c.`author_id` = 428438
0.0148  SELECT c.* FROM `comments` c WHERE c.`author_id` = 428438 AND c.`active`= 1 AND c.`lang` = 1 ORDER BY creation_date DESC LIMIT 0, 10
0.0148  SELECT dt.nameShow, dt.basealias, t.name FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 1905
0.0145  SELECT dt.nameShow, dt.basealias, t.name FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 2339
0.0145  SELECT id, alias, name, last_name, nick FROM dataplayers WHERE id IN (47357)
0.0144  SELECT id, year FROM leagues WHERE id IN (2339,2339,2339,2339,2339,2339,2339,2339,2339)
0.0145   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 calendars2013 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 (418237,418236,418234)
0.0154  SELECT id, comment_id, comment, author_name, author_id, votes_up, COUNT(id) AS responses FROM comments WHERE comment_id IN (2136837,2118324,2118322,2106203,2104977,2104974,2104972,2104970,2104005,2103806) GROUP BY comment_id
0.0148  SELECT fap.*,u.* FROM fa_user_profile fap LEFT JOIN user_stats u ON fap.id = u.id WHERE fap.id = 428438
0.0145  SELECT * FROM `rel_goals` as rg INNER JOIN goals as g ON g.id = rg.goal_id WHERE rg.userId = 428438 ORDER BY g.class DESC, rg.datetime DESC LIMIT 100
0.0146  SELECT SUM(votes_up) AS up,SUM(votes_down) AS down FROM comments WHERE `author_id` = 428438
0.0144  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.0180  SELECT * FROM `g_totals` WHERE userId = 428438
0.0146  SELECT *,rf.id as idmsg FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = rf.uidsent WHERE rf.uidto = 428438 ORDER BY rf.id DESC LIMIT 0,3
0.0245  SELECT count(rf.id) as cuenta FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = 428438 WHERE 1 AND (rf.uidto = 428438) AND rf.del != 428438
0.0147  SELECT * FROM dreamteam_data dd WHERE dd.userId = 428438 ORDER BY profile DESC, creation_date DESC LIMIT 1
0.0146  SELECT rf.friendId FROM rel_friends rf INNER JOIN fa_user u ON u.id = rf.friendId WHERE rf.userId = 428438 AND rf.status = 1 ORDER BY u.last_activity DESC LIMIT 20
0.0144  SELECT a.*,fa.user_name FROM activity a INNER JOIN fa_user fa ON fa.id = a.userId WHERE userId IN (428438,3435,835,277902,292455,131601,165817,450067,475435,466735,479322,470908) ORDER BY a.datetime DESC LIMIT 0,60
0.0145  SELECT a.*,fa.user_name FROM activity a INNER JOIN fa_user fa ON fa.id = a.userId WHERE userId = 428438 ORDER BY id DESC LIMIT 0,60
0.0146  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 = 428438 ORDER BY rf.update_date DESC LIMIT 0,10
0.0144  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 = 428438 GROUP BY rg.group_id ORDER BY rg.accuracy DESC LIMIT 4
0.0146  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 = 428438 GROUP BY rg.user_id
0.0145  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 = 428438 AND rf.status = 1 ORDER BY status ASC, rf.accuracy DESC LIMIT 0,12
0.0148  SELECT COUNT(*) AS total FROM rel_friends WHERE userId=428438 AND status=1
0.0146  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 = 428438 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0145  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video WHERE 1 AND p.author_id = 428438 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0145  SELECT COUNT(DISTINCT `id`) AS num_total FROM videos WHERE `author_id` = 428438
0.0145  SELECT COUNT(DISTINCT `id`) AS num_total FROM pictures WHERE `author_id` = 428438