0.0632 | 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.content_type=2 DESC, p.creation_date DESC LIMIT 12, 30 |
0.0103 | 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 (99886,99877,99865,99862,99861,99859,99855,99854,99850,99848,99834,99829,99830,99792,99787,99782,99747,99746,99739,99728,99725,99724,99721,99719,99706,99690,99691,99686,99575,99569) |
0.0607 | 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.content_type=2 DESC, p.creation_date DESC LIMIT 0, 12 |
0.0051 | 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 (99982,99975,99943,99932,99924,99925,99923,99922,99912,99911,99890,99889) |
0.0018 | SELECT total FROM `totals` WHERE id = 8 |