Comentarios de adria_282961
Equipos favoritos
Todavía no tienes equipos favoritos, podrás añadirlos editando tu perfil, una vez los tengas agregados podrás seguir la información de tus equipos.
Ligas favoritas
¿No tienes ninguna liga preferida? Añade tus ligas preferidas y siempre estarás informado.
Estadísticas de adria_282961
  • Comentarios creados: 6
  • Votos a favor: 0
  • Fotos subidas: 0
  • Videos subidos: 0
  • Usuario desde: 01 Abr 20 12:16

  USO DE MEMORIA  
4,136,784 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Commentlist / Index )  0.3764
Total Execution Time  0.3784
  CADENA URL  
/miscomentarios/adria_282961
  GET DATOS  
$_GET['/miscomentarios/adria_282961']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0007  SELECT * FROM (`fa_user`) WHERE `user_name` = 'adria_282961'
0.0148  SELECT fap.*,u.* FROM fa_user_profile fap LEFT JOIN user_stats u ON fap.id = u.id WHERE fap.id = 3195211
0.0146  SELECT rf.friendId FROM rel_friends rf INNER JOIN fa_user u ON u.id = rf.friendId WHERE rf.userId = 3195211 AND rf.status=1 ORDER BY rf.accuracy DESC LIMIT 1000
0.0145  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.0145  SELECT SUM(votes_up) AS up,SUM(votes_down) AS down FROM comments WHERE `author_id` = 3195211
0.0145  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 = 3195211
0.0145  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 = 3195211 AND rf.status = 1 WHERE i.userId = 3195211
0.0146  SELECT count(rf.id) as cuenta FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = 3195211 WHERE 1 AND (rf.uidto = 3195211) AND rf.del != 3195211
0.0145  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 = 3195211
0.0145  SELECT COUNT(DISTINCT c.`id`) AS num_total FROM comments as c WHERE c.`author_id` = 3195211
0.0145  SELECT COUNT(DISTINCT `id`) AS num_total FROM videos WHERE `author_id` = 3195211
0.0146  SELECT COUNT(DISTINCT `id`) AS num_total FROM pictures WHERE `author_id` = 3195211
0.0145  SELECT c.* FROM `comments` c WHERE c.`author_id` = 3195211 AND c.`active`= 1 AND c.`lang` = 1 ORDER BY creation_date DESC LIMIT 0, 20
0.0145  SELECT id, year FROM leagues WHERE id IN (67669,64539,64539,64539,64539,58928)
0.0146   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 calendars2023 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 (49369)
0.0147   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 calendars2022 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 (254826,254792,254732)
0.0181   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 (142732)
0.0145  SELECT id, comment_id, comment, author_name, author_id, votes_up, COUNT(id) AS responses FROM comments WHERE comment_id IN (45015733,38768437,38292437,38292422,36995051,32133339) GROUP BY comment_id
0.0145  SELECT COUNT(*) AS total FROM rel_friends WHERE userId=3195211 AND status=1