Sobre rotxin
Todavía no ha escrito nada en este apartado.
Amigos 1
  • rojiblanco
Grupos 2
Comentarios 250 Más comentarios
  • Y el árbitro para qué está? hace 6 años
  • 100000 euros, jeje hace 6 años
  • Son lo únicos que no quieren video arbitraje.17 goles en fuero de juego en la temporada pasada, incluídas las dos supercopas. Aparte del gol de hoy...Es increíble. No te gustan los arbitrajes? Habla con Florentino y que permita los videos, que es el único que dice que no y, manda leches, el único al que le hacen caso. hace 6 años
  • Cuando le haga falta hace 6 años en Real Madrid - Sevilla
  • Gil Manzano?No hay color hoy, hace 7 años en Real Madrid - Valencia
  • UNZUE CAGONCIO.ERES UN COME DE ESASPAPANATAS, COMO LLORABAS POR VOLVER A OSASUNA A LLEVARTE LA PASTA.LLEGARA UN BOBALAN QUE TE TRAERA DE ENTRENATUTO A PAMPLONA, ESE AÑO CAMBIARE EL ABONO A DETRAS DE BANQUILLOS PARA RECORDARTE COMO TE REIAS HOY DE TU GENTE, LA QUE TE HA DADO DE COMER DESDE QUE TENÍAS PAÑALES hace 7 años en Barcelona - Osasuna
  • Más fácil lo tendrían estos de segunda división con el poder de Florentino, Tebas y el PP hace 7 años en Barcelona - Osasuna
  • ESPERO QUE SE QUEDE EN EL BARSA Y LE VAYA TODO LO MAL POSIBLE.DIOS QUIERA SEA EL PRIMER CESADO DEL BARSA DE LOS ULTIMOS DIEZ AÑOS hace 7 años en Barcelona - Osasuna
  • SE RÍE EL SUB IMB MAL DE UNZUE.NO RECUERDO COMO VOLVIÓ A OSASUNA ARRASTRANDO EL CULO NO HACE MUCHO.YA LLEGARÁ POR SAN FERMÍN hace 7 años en Barcelona - Osasuna
  • Cosas que pasan, haber cuando investigan las victorias del Madrid y los "errores" arbitrales cuando menos "raros" que se producen a su favor en ya casi todas las jornadas (no en un partido, no), en todas las jornadas, hace 7 años
Actividad

rotxin todavía no tiene actividad

Ligas favoritas
Estadísticas de rotxin
  • Comentarios creados: 250
  • Votos a favor: 83
  • Amigos: 1
  • Fotos subidas: 0
  • Videos subidos: 0
  • Usuario desde: 09 Sep 12 20:53
  • Último login: 08 Sep 15 22:00

  USO DE MEMORIA  
4,080,816 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Uprofile / Index )  0.1316
Total Execution Time  0.1330
  CADENA URL  
/usuario/rotxin
  GET DATOS  
$_GET['/usuario/rotxin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0004  SELECT * FROM (`fa_user`) WHERE `user_name` = 'rotxin'
0.0019  SELECT rf.friendId FROM rel_friends rf INNER JOIN fa_user u ON u.id = rf.friendId WHERE rf.userId = 366148 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 = 366148 ORDER BY rf.id DESC LIMIT 0,10
0.0025  SELECT COUNT(DISTINCT c.`id`) AS num_total FROM comments as c WHERE c.`author_id` = 366148
0.0022  SELECT c.* FROM `comments` c WHERE c.`author_id` = 366148 AND c.`active`= 1 AND c.`lang` = 1 ORDER BY creation_date DESC LIMIT 0, 10
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 = 30626
0.0018  SELECT id, year FROM leagues WHERE id IN (30626,30626,30626,30626,30626,30626)
0.0018   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 calendars2017 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 (96597,96576,96559)
0.0020  SELECT id, comment_id, comment, author_name, author_id, votes_up, COUNT(id) AS responses FROM comments WHERE comment_id IN (17727011,16878762,16878355,15559682,15306370,15261385,15260962,15260872,15260790,14867471) 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 = 366148
0.0019  SELECT * FROM `rel_goals` as rg INNER JOIN goals as g ON g.id = rg.goal_id WHERE rg.userId = 366148 ORDER BY g.class DESC, rg.datetime DESC LIMIT 100
0.0021  SELECT SUM(votes_up) AS up,SUM(votes_down) AS down FROM comments WHERE `author_id` = 366148
0.0094  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 OR dt.id = 429 OR dt.id = 1887 OR dt.id = 1563 GROUP BY dt.nameShow,l.year ORDER BY c.troncal DESC,c.main DESC,l.year DESC LIMIT 3
0.0024  SELECT l.id,l.year,t.id as teamId FROM leagues l INNER JOIN categories c ON l.categoryId = c.id INNER JOIN teams as t ON t.league_id = l.id WHERE c.alias = 'primera' AND t.teamId = 1887 AND l.group_code = 1 ORDER BY l.year DESC LIMIT 1
0.0021  SELECT l.id,l.year,t.id as teamId FROM leagues l INNER JOIN categories c ON l.categoryId = c.id INNER JOIN teams as t ON t.league_id = l.id WHERE c.alias = 'primera' AND t.teamId = 1887 AND l.group_code = 1 ORDER BY l.year DESC LIMIT 1
0.0020  SELECT l.id,l.year,t.id as teamId FROM leagues l INNER JOIN categories c ON l.categoryId = c.id INNER JOIN teams as t ON t.league_id = l.id WHERE c.alias = 'primera' AND t.teamId = 1887 AND l.group_code = 1 ORDER BY l.year DESC LIMIT 1
0.0058  SELECT * FROM `g_totals` WHERE userId = 366148
0.0019  SELECT *,rf.id as idmsg FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = rf.uidsent WHERE rf.uidto = 366148 ORDER BY rf.id DESC LIMIT 0,3
0.0110  SELECT count(rf.id) as cuenta FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = 366148 WHERE 1 AND (rf.uidto = 366148) AND rf.del != 366148
0.0020  SELECT * FROM dreamteam_data dd WHERE dd.userId = 366148 ORDER BY profile DESC, creation_date DESC LIMIT 1
0.0113  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 = 80156
0.0111  SELECT COUNT(rd.id) as cuenta FROM dreamteam_data rd where userId = 366148
0.0019  SELECT name,id FROM dreamteam_data rd where userId = 366148 ORDER BY profile DESC, creation_date DESC LIMIT 3
0.0018  SELECT rf.friendId FROM rel_friends rf INNER JOIN fa_user u ON u.id = rf.friendId WHERE rf.userId = 366148 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 (366148,3435) 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 = 366148 ORDER BY id DESC LIMIT 0,60
0.0020  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 = 366148 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 = 366148 GROUP BY rg.group_id ORDER BY rg.accuracy DESC LIMIT 4
0.0018  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 = 366148 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 = 366148 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=366148 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 = 366148 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 = 366148 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` = 366148
0.0018  SELECT COUNT(DISTINCT `id`) AS num_total FROM pictures WHERE `author_id` = 366148