Comentarios de javidiego10

‹ Primero ... ... página 1 2 3 4 5 6 7 > ... Último ›

Estadísticas de javidiego10
  • Comentarios creados: 122
  • Votos a favor: 37
  • Amigos: 202
  • Fotos subidas: 60
  • Videos subidos: 0
  • Usuario desde: 01 Dic 13 18:35
  • Último login: 29 Ene 14 21:56

  USO DE MEMORIA  
4,413,384 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Commentlist / Index )  0.0872
Total Execution Time  0.0886
  CADENA URL  
/miscomentarios/javidiego10
  GET DATOS  
$_GET['/miscomentarios/javidiego10']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0005  SELECT * FROM (`fa_user`) WHERE `user_name` = 'javidiego10'
0.0020  SELECT fap.*,u.* FROM fa_user_profile fap LEFT JOIN user_stats u ON fap.id = u.id WHERE fap.id = 538825
0.0065  SELECT rf.friendId FROM rel_friends rf INNER JOIN fa_user u ON u.id = rf.friendId WHERE rf.userId = 538825 AND rf.status=1 ORDER BY rf.accuracy DESC LIMIT 1000
0.0121  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 OR dt.id = 11825 GROUP BY dt.nameShow,l.year ORDER BY c.troncal DESC,c.main DESC,l.year DESC LIMIT 2
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 = 2107 AND l.group_code = 1 ORDER BY l.year DESC LIMIT 1
0.0019  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 = 'segunda_division_rfef' AND t.teamId = 11825 AND l.group_code = 5 ORDER BY l.year DESC LIMIT 1
0.0022  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 = 538825 ORDER BY l.year DESC,esl.points DESC LIMIT 3
0.0023  SELECT SUM(votes_up) AS up,SUM(votes_down) AS down FROM comments WHERE `author_id` = 538825
0.0018  SELECT u.id,u.email,u.user_name FROM invitations i INNER JOIN fa_user u ON u.email = i.mail_friend WHERE i.userId = 538825
0.0018  SELECT u.id,u.email,u.user_name FROM invitations i INNER JOIN fa_user u ON u.email = i.mail_friend INNER JOIN rel_friends rf ON rf.friendId = u.id AND rf.userId = 538825 AND rf.status = 1 WHERE i.userId = 538825
0.0045  SELECT count(rf.id) as cuenta FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = 538825 WHERE 1 AND (rf.uidto = 538825) AND rf.del != 538825
0.0019  SELECT count(rf.friendId) as cuenta FROM rel_friends rf INNER JOIN fa_user u ON u.id = rf.friendId WHERE rf.status = 1 AND rf.userId = 538825
0.0018  SELECT COUNT(DISTINCT c.`id`) AS num_total FROM comments as c WHERE c.`author_id` = 538825
0.0018  SELECT COUNT(DISTINCT `id`) AS num_total FROM videos WHERE `author_id` = 538825
0.0021  SELECT COUNT(DISTINCT `id`) AS num_total FROM pictures WHERE `author_id` = 538825
0.0017  SELECT c.* FROM `comments` c WHERE c.`author_id` = 538825 AND c.`active`= 1 AND c.`lang` = 1 ORDER BY creation_date DESC LIMIT 0, 20
0.0019  SELECT id, title FROM pictures WHERE id IN (722759)
0.0020  SELECT id, title, alias FROM news WHERE id IN (90287,90206,90219,90126,90028,90018,89896,89741)
0.0019  SELECT id, year FROM leagues WHERE id IN (4231,3803,3361,2467,2401,2735,2735,2735,2434,2434,2401)
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 calendars2015 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 (86575,20073)
0.0022   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 (148992,52038,27609,143350,28169,28162,27581)
0.0018  SELECT id, comment_id, comment, author_name, author_id, votes_up, COUNT(id) AS responses FROM comments WHERE comment_id IN (3170932,3121821,2508420,2493401,2493375,2475721,2467048,2462420,2462378,2455214,2455158,2445290,2444929,2444088,2444067,2443230,2441325,2438618,2438585,2432382) GROUP BY comment_id
0.0018  SELECT COUNT(*) AS total FROM rel_friends WHERE userId=538825 AND status=1