0.0583 | SELECT p.id,p.creation_date as date,p.author_id, u.user_name,p.votes_up,p.totalcomments,p.votes_down,p.title,p.creation_date,p.content_type,p.teaser,p.views,p.alias,p.video_content_id,p.picture_content_id,v.code,v.title as vtitle,pic.id as pid,v.id as vid,pic.author_id as pauthor_id,v.author_id as vauthor_id
FROM `news` as p INNER JOIN fa_user_mini u ON u.id = p.author_id LEFT JOIN `pictures` as pic ON p.picture_content_id = pic.id AND pic.banned=0 LEFT JOIN `videos` as v ON p.video_content_id = v.id WHERE (v.id is not null or p.id is not null) AND 1 ORDER BY p.creation_date > '2024-04-12' DESC,p.totalcomments DESC LIMIT 12, 30 |
0.0023 | SELECT t.title, t.alias, rel.id_new FROM rel_news AS rel INNER JOIN topics AS t ON rel.id_content=t.id WHERE rel.type=5 AND rel.id_new IN (100503,100504,12530,53376,69004,54265,12088,18297,55483,55181,53239,32840,8991,73489,10221,31465,74678,54984,46923,39326,42254,8649,54632,55637,13855,23936,52688,53167,43229,11489) |
0.0696 | SELECT p.id,p.creation_date as date,p.author_id, u.user_name,p.votes_up,p.totalcomments,p.votes_down,p.title,p.content_type,p.teaser,p.views,p.alias,p.video_content_id,p.picture_content_id,LEFT(p.body,300) as body, pic.width,pic.height,v.code,v.title as vtitle,pic.id as pid,v.id as vid,pic.author_id as pauthor_id,v.author_id as vauthor_id
FROM `news` as p INNER JOIN fa_user_mini u ON u.id = p.author_id LEFT JOIN `pictures` as pic ON p.picture_content_id = pic.id AND pic.banned=0 LEFT JOIN `videos` as v ON p.video_content_id = v.id WHERE (v.id is not null or p.id is not null) AND 1 ORDER BY p.creation_date > '2024-04-12' DESC,p.totalcomments DESC LIMIT 0, 12 |
0.0060 | SELECT t.title, t.alias, rel.id_new FROM rel_news AS rel INNER JOIN topics AS t ON rel.id_content=t.id WHERE rel.type=5 AND rel.id_new IN (100483,100484,100485,100486,100495,100496,100497,100498,100499,100500,100501,100502) |
0.0019 | SELECT total FROM `totals` WHERE id = 8 |