0.0005 |
SELECT
COUNT(DISTINCT c.`id`) AS num
FROM comments AS c
WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0
AND c.comment_id!=0
AND c.lang = '1'
AND c.`new_content_id` = '85954'
|
0.0023 | SELECT n.*,rn.*,u.user_name,u.user_name as media_username,p.title as ptitle,p.width,p.height,v.code,v.title as vtitle,p.id as pid,v.id as vid,p.author_id as pauthor_id,v.author_id as vauthor_id, v.url as video_url, v.type AS vtype FROM `news` n INNER JOIN fa_user u ON u.id = n.author_id INNER JOIN `rel_news` as rn ON n.id = rn.id_new LEFT JOIN `pictures` as p ON n.picture_content_id = p.id AND p.banned=0 LEFT JOIN `videos` as v ON n.video_content_id = v.id WHERE n.alias = 'gomis-espera-poder-firmar-newcastle-semana' AND n.content_type != 2 |
0.0018 | SELECT user_name FROM `fa_user` WHERE id = 198916 |
0.0020 | SELECT * FROM rel_news WHERE id_new = 85954 ORDER BY (type = 5) DESC,(type = 4) DESC, (type = 3) DESC,(type = 1) DESC |
0.0018 | SELECT title as name,alias FROM topics WHERE id =4 |
0.0017 | SELECT user_name FROM fa_user WHERE id =473260 |
0.0021 | SELECT u.user_name,u.id FROM rel_votes v INNER JOIN fa_user u ON v.userId = u.id WHERE v.contentId = 85954 AND v.contentType = 4 ORDER BY v.datetime ASC |
0.0019 | SELECT alias
FROM `news` as p WHERE author_id = 473260 AND id < 85954 ORDER by p.id DESC LIMIT 1 |
0.0019 | SELECT alias
FROM `news` as p WHERE author_id = 473260 AND id > 85954 ORDER BY p.id ASC LIMIT 1 |
0.0019 | SELECT dp.id AS player_id, dp.nick AS player_name, dp.role AS player_role, dp.alias AS player_alias, odt.id AS origin_team_id, odt.nameShow AS origin_team_name, odt.basealias AS origin_team_alias, dtd.id AS dest_team_id, dtd.nameShow AS dest_team_name, dtd.basealias AS dest_team_alias FROM rel_budgets AS rb INNER JOIN dataplayers AS dp ON rb.player_id=dp.id LEFT JOIN datateams AS odt ON rb.origin_team_id=odt.id LEFT JOIN datateams AS dtd ON rb.destination_team_id=dtd.id WHERE rb.new_id=85954 |
0.0046 | SELECT DISTINCT n.id, n.title, n.alias, n.revised FROM news AS n INNER JOIN rel_budgets AS rb ON n.id=rb.new_id WHERE rb.pub_date>NOW()-INTERVAL 4 MONTH AND rb.new_id!=85954 AND (rb.player_id IN (712) OR rb.origin_team_id IN (1796) OR rb.destination_team_id IN (1796)) ORDER BY rb.player_id IN (712) DESC, rb.official_budget ASC, rb.pub_date DESC LIMIT 3 |
0.0018 | SELECT id_content FROM rel_news WHERE id_new = '85954' AND type = '5' |
0.0021 | SELECT l.id,c.`name` as name,l.group_code,l.total_group,c.CountryCode,c.`alias` as alias FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE l.status = 1 AND l.links = 2 AND l.year = 2024 AND c.listed = 1 AND l.tables = 1 AND l.group_code > 0 AND c.troncal = 1 AND l.game = 1 AND c.class < 5 ORDER BY c.coefficient DESC, c.name ASC ,l.group_code ASC |
0.0019 | SELECT * FROM topics ORDER BY priority ASC |