Sobre Futboleroc
Todavía no ha escrito nada en este apartado.
Amigos 1813 Más amigos
  • JdMcrew
  • ticket
  • Squall
  • jvdgs24
  • colchonero
  • Adriantheboss
  • Robertin
  • ElMalvis
  • guasch
  • benzema9
  • currican10
  • AdRiAlCoRcOn
Grupos 44 Más grupos
Medallas listado de medallas
Comentarios 10154 Más comentarios
  • Para los que apostamos, muy factible un Ambos marcan, 2.5 goles y gana ManCity a cuota 3.10 hace 3 años en Arsenal - Manchester City
  • Vaya chaval, mírate la tabla de máximos goleadores, que Karim va segundo. hace 4 años en Real Betis - Real Madrid
  • Real Madrid vs todos, si ganamos esta liga será un auténtico milagro, si ayer pasaron cosas raras en el Campo Nuevo, otra vez, y ya van unas cuantas está temporada, hoy no será menos hace 4 años en Real Betis - Real Madrid
  • Pensábamos que con el VAR estas ayuditas iban a terminar, pero ahora es más descarado aún, tienen que hacer lo posible para que se decida en la última jornada y así darle emoción a este torneo, ya son muchas jornadas en las que le están dando vida a este VARcelona. hace 4 años en Barcelona - Real Sociedad
  • Totalmente de acuerdo, fatal que este equipo dependa de un chaval que es el unico que aporta algo de electricidad al equipo, porque todo lo demás está apagado, como no vengan revulsivos en invierno este año será lamentable. hace 5 años en Real Madrid - Real Valladolid
  • Sin comentarios... hace 9 años en Vamostenerife... ¡¡Vuelve!!
  • Te acabas de responder tu mismo amigo, aquí no avisan de nada ya tampoco. Encima los comentarios vuelan por aquí hace 9 años en Entrevista sobre césped a... Mesqueunclub
  • Fascinante como conociste RF amigo, no me lo esperaba JAJAJAJA. Antes conocía a mesque muy poco, lo veía comentar bastante y alguna vez le respondía, fijo a que alguna vez incluso hemos discutido aunque no me acuerde, pero viendo mi historial me la juego... Lo estoy empezando a conocer ahora y es buenisima persona, te lo dice uno de los ... hace 9 años en Entrevista sobre césped a... Mesqueunclub
  • a parte de conocer mas a fondo a un usuario, no?** hace 9 años en Mesqueunclub será el próximo entrevistado en 'Entrevistas sobre césped'.
  • En este tema siempre voy a estar de acuerdo con ticket y le voy a apoyar, me parece perfecto lo de las entrevistas, ya lo dije, pero lo que me parece fatal, incluso me atrevería a decir una falta de respeto, es censurar la opinión de un usuario en una entrevista suya, aquí todos tenemos nuestra vida fuera de la ... hace 9 años en Mesqueunclub será el próximo entrevistado en 'Entrevistas sobre césped'.
Actividad

Futboleroc todavía no tiene actividad

Equipos favoritos
Ligas favoritas
Estadísticas de Futboleroc
  • Comentarios creados: 10.154
  • Votos a favor: 3.346
  • Amigos: 1.813
  • Fotos subidas: 3.263
  • Videos subidos: 94
  • Usuario desde: 30 Abr 09 11:17
  • Último login: 21 Feb 21 13:05

  USO DE MEMORIA  
5,006,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Uprofile / Index )  0.6690
Total Execution Time  0.6704
  CADENA URL  
/usuario/Futboleroc
  GET DATOS  
$_GET['/usuario/Futboleroc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0005  SELECT * FROM (`fa_user`) WHERE `user_name` = 'Futboleroc'
0.0363  SELECT rf.friendId FROM rel_friends rf INNER JOIN fa_user u ON u.id = rf.friendId WHERE rf.userId = 828 AND rf.status = 1 LIMIT 5000
0.0128  SELECT *,rf.id as idmsg FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = rf.uidsent WHERE rf.uidto = 828 ORDER BY rf.id DESC LIMIT 0,10
0.0406  SELECT COUNT(DISTINCT c.`id`) AS num_total FROM comments as c WHERE c.`author_id` = 828
0.0247  SELECT c.* FROM `comments` c WHERE c.`author_id` = 828 AND c.`active`= 1 AND c.`lang` = 1 ORDER BY creation_date DESC LIMIT 0, 10
0.0128  SELECT dt.nameShow, dt.basealias, t.name FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 57338
0.0127  SELECT dt.nameShow, dt.basealias, t.name FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 49844
0.0126  SELECT dt.nameShow, dt.basealias, t.name FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 43542
0.0126  SELECT id, title, alias FROM news WHERE id IN (98157,97862,97862,97778,97778)
0.0126  SELECT id, year FROM leagues WHERE id IN (57338,49844,49844,49844,43542)
0.0125   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 calendars2021 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 (72473)
0.0126   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 calendars2020 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 (46554,46553)
0.0125   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 calendars2019 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 (103728)
0.0138  SELECT id, comment_id, comment, author_name, author_id, votes_up, COUNT(id) AS responses FROM comments WHERE comment_id IN (31142295,28337536,28336728,28336580,23213732,5211507,4705256,4650964,4581526,4580976) GROUP BY comment_id
0.0127  SELECT fap.*,u.* FROM fa_user_profile fap LEFT JOIN user_stats u ON fap.id = u.id WHERE fap.id = 828
0.0129  SELECT * FROM `rel_goals` as rg INNER JOIN goals as g ON g.id = rg.goal_id WHERE rg.userId = 828 ORDER BY g.class DESC, rg.datetime DESC LIMIT 100
0.0243  SELECT SUM(votes_up) AS up,SUM(votes_down) AS down FROM comments WHERE `author_id` = 828
0.0210  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 = 2107 GROUP BY dt.nameShow,l.year ORDER BY c.troncal DESC,c.main DESC,l.year DESC LIMIT 1
0.0129  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 = 2107 AND l.group_code = 1 ORDER BY l.year DESC LIMIT 1
0.0128  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 = 828 ORDER BY l.year DESC,esl.points DESC LIMIT 3
0.0160  SELECT * FROM `g_totals` WHERE userId = 828
0.0128  SELECT *,rf.id as idmsg FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = rf.uidsent WHERE rf.uidto = 828 ORDER BY rf.id DESC LIMIT 0,3
0.0225  SELECT count(rf.id) as cuenta FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = 828 WHERE 1 AND (rf.uidto = 828) AND rf.del != 828
0.0312  SELECT * FROM dreamteam_data dd WHERE dd.userId = 828 ORDER BY profile DESC, creation_date DESC LIMIT 1
0.0126  SELECT rf.friendId FROM rel_friends rf INNER JOIN fa_user u ON u.id = rf.friendId WHERE rf.userId = 828 AND rf.status = 1 ORDER BY u.last_activity DESC LIMIT 20
0.0126  SELECT a.*,fa.user_name FROM activity a INNER JOIN fa_user fa ON fa.id = a.userId WHERE userId IN (828,19599,230992,1830,1827,9662,2531,26439,207854,171809,143889,19229,162183,82230,5020,203170,3310,2262,1654,5514,39338) ORDER BY a.datetime DESC LIMIT 0,60
0.0127  SELECT a.*,fa.user_name FROM activity a INNER JOIN fa_user fa ON fa.id = a.userId WHERE userId = 828 ORDER BY id DESC LIMIT 0,60
0.0130  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 = 828 ORDER BY rf.update_date DESC LIMIT 0,10
0.0131  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 = 828 GROUP BY rg.group_id ORDER BY rg.accuracy DESC LIMIT 4
0.0138  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 = 828 GROUP BY rg.user_id
0.0132  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 = 828 AND rf.status = 1 ORDER BY status ASC, rf.accuracy DESC LIMIT 0,12
0.0131  SELECT COUNT(*) AS total FROM rel_friends WHERE userId=828 AND status=1
0.0131  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 = 828 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video WHERE 1 AND p.author_id = 828 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0140  SELECT COUNT(DISTINCT `id`) AS num_total FROM videos WHERE `author_id` = 828
0.0140  SELECT COUNT(DISTINCT `id`) AS num_total FROM pictures WHERE `author_id` = 828