Sobre EfeseristaCT
Juan José Jerez Carrasco
Yo soy del Efesé, del Madrid y de la roja. TONINO SELECCIÓN Y VIVA YO.
Amigos 21 Más amigos
  • granadacf
  • deusyvillu
  • padock
  • franciscolorca
  • JVJ2
  • manu
  • victorhs
  • Davis
  • Europeista
  • lorkino18
  • kisko
  • csanam
Comentarios 12 Más comentarios
  • Eres un CRACK. Quedate en Cartagena, porfa. hace 13 años en Rubén
  • Mucho ánimo, Pascal!!!!!!!!!!!! !! Quedate en el Efesé.Siempre Efesé !!!! hace 13 años en P. Cygan
  • Casas ya no es del Éfese. hace 13 años en Casas
  • No te vayas nunca del efesé, porfa !!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!! !!!! hace 13 años en Txiki
  • Eres un gran central, Chus !!! hace 13 años en Chus Herrero
  • Pablo eres el mejor !!!!!!!!!!!!!!!!!! !! hace 13 años en Pablo Ruiz
  • Ánimo Xavier!! Ke t vaya OK en el Athletic. hace 13 años en Etxeita
  • Ánimo, que eres un crack!! Ojalá tengas + oportunidades hace 13 años en Héctor Yuste
  • Muxo ánimo, crack!! ¿Que te ha pasado con JIM? hace 13 años en Tonino
  • Eres un crack!! Gracias por este medio año en el Efesé. No te retires y sigue, por favor. hace 13 años
Actividad

EfeseristaCT todavía no tiene actividad

Equipos favoritos
EfeseristaCT todavía no tiene equipos favoritos.
Ligas favoritas
EfeseristaCT aún no ha decidido cuál es su liga preferida
Estadísticas de EfeseristaCT
  • Comentarios creados: 12
  • Votos a favor: 1
  • Amigos: 21
  • Fotos subidas: 3
  • Videos subidos: 0
  • Usuario desde: 11 Jun 10 20:56
  • Último login: 30 Jun 10 22:26

  USO DE MEMORIA  
4,130,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Uprofile / Index )  0.5223
Total Execution Time  0.5237
  CADENA URL  
/usuario/EfeseristaCT
  GET DATOS  
$_GET['/usuario/EfeseristaCT']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0004  SELECT * FROM (`fa_user`) WHERE `user_name` = 'EfeseristaCT'
0.0025  SELECT rf.friendId FROM rel_friends rf INNER JOIN fa_user u ON u.id = rf.friendId WHERE rf.userId = 22751 AND rf.status = 1 LIMIT 5000
0.0019  SELECT *,rf.id as idmsg FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = rf.uidsent WHERE rf.uidto = 22751 ORDER BY rf.id DESC LIMIT 0,10
0.0018  SELECT COUNT(DISTINCT c.`id`) AS num_total FROM comments as c WHERE c.`author_id` = 22751
0.0019  SELECT c.* FROM `comments` c WHERE c.`author_id` = 22751 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 = 812
0.0021  SELECT dt.nameShow, dt.basealias, t.name FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 894
0.0018  SELECT dt.nameShow, dt.basealias, t.name FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 812
0.0019  SELECT id, alias, name, last_name, nick FROM dataplayers WHERE id IN (29731,30384,29733,29734,29736,29748,29955,29741,29745,49252)
0.0020  SELECT id, comment_id, comment, author_name, author_id, votes_up, COUNT(id) AS responses FROM comments WHERE comment_id IN (361886,361883,361876,361874,361872,361870,361868,361860,361849,361838) 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 = 22751
0.0019  SELECT * FROM `rel_goals` as rg INNER JOIN goals as g ON g.id = rg.goal_id WHERE rg.userId = 22751 ORDER BY g.class DESC, rg.datetime DESC LIMIT 100
0.0018  SELECT SUM(votes_up) AS up,SUM(votes_down) AS down FROM comments WHERE `author_id` = 22751
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 OR dt.id = 1052 GROUP BY dt.nameShow,l.year ORDER BY c.troncal DESC,c.main DESC,l.year DESC LIMIT 1
0.0055  SELECT * FROM `g_totals` WHERE userId = 22751
0.0019  SELECT *,rf.id as idmsg FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = rf.uidsent WHERE rf.uidto = 22751 ORDER BY rf.id DESC LIMIT 0,3
0.0109  SELECT count(rf.id) as cuenta FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = 22751 WHERE 1 AND (rf.uidto = 22751) AND rf.del != 22751
0.0020  SELECT * FROM dreamteam_data dd WHERE dd.userId = 22751 ORDER BY profile DESC, creation_date DESC LIMIT 1
0.0114  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 = 8894
0.0108  SELECT COUNT(rd.id) as cuenta FROM dreamteam_data rd where userId = 22751
0.0021  SELECT name,id FROM dreamteam_data rd where userId = 22751 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 = 22751 AND rf.status = 1 ORDER BY u.last_activity DESC LIMIT 20
0.0019  SELECT a.*,fa.user_name FROM activity a INNER JOIN fa_user fa ON fa.id = a.userId WHERE userId IN (22751,3310,2021,6,1768,5024,4624,4728,9740,3711,7029,12903,1570,18395,2400,4578,5389,843,16891,2712,14950) 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 = 22751 ORDER BY id DESC LIMIT 0,60
0.0027  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 = 22751 ORDER BY rf.update_date DESC LIMIT 0,10
0.0028  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 = 22751 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 = 22751 GROUP BY rg.user_id
0.0019  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 = 22751 AND rf.status = 1 ORDER BY status ASC, rf.accuracy DESC LIMIT 0,12
0.0066  SELECT COUNT(*) AS total FROM rel_friends WHERE userId=22751 AND status=1
0.0018  SELECT min(l.year) as min_year,max(l.year) as max_year,c.main,cou.Name,c.top,c.status,c.cat,c.ctype,c.CountryCode, c.class, c.main,c.coefficient, l.year,c.logo, l.id , c.name, c.alias,lp.c_playing,lp.c_recent,lp.c_played,lp.c_pending,lp.c_past,lp.c_future FROM (leagues l INNER JOIN categories c ON l.categoryId = c.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode LEFT JOIN leagues_play lp ON lp.categoryId = c.id AND lp.ini_date = '2024-04-29 16:30:00') WHERE l.group_code = 1 AND l.end_date > NOW() - INTERVAL 2 MONTH AND l.status = 1 group by l.categoryId ORDER BY c.coefficient DESC, c.name DESC LIMIT 200
0.0019  SELECT * FROM totals order by id ASC
0.1882  SELECT l.id,cat.alias,cat.name,l.total_group,l.group_code FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2009 as c ON c.league_id = l.id AND l.current_round = c.round WHERE l.status = 1 AND c.r1 < 95 AND c.r2 < 95 AND c.shedule > '2024/04/29 13:33' AND c.shedule < '2024/04/29 16:53' GROUP BY l.id ORDER BY cat.coefficient DESC,l.group_code ASC LIMIT 21
0.0021  SELECT l.id,cat.alias,cat.name,l.total_group,l.group_code FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId WHERE l.status = 1 AND l.group_code = 1 ORDER BY l.year DESC,cat.coefficient DESC,l.group_code ASC LIMIT 21
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 = 22751 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 = 22751 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` = 22751
0.0018  SELECT COUNT(DISTINCT `id`) AS num_total FROM pictures WHERE `author_id` = 22751