0.0049 | 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.id DESC LIMIT 12, 30 |
0.0022 | 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 (100484,100483,100482,100481,100480,100479,100478,100477,100476,100475,100474,100473,100472,100471,100470,100469,100468,100467,100466,100465,100464,100463,100462,100461,100460,100459,100458,100457,100456,100455) |
0.0024 | 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.id DESC LIMIT 0, 12 |
0.0021 | 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 (100504,100503,100502,100501,100500,100499,100498,100497,100496,100495,100486,100485) |
0.0019 | SELECT total FROM `totals` WHERE id = 8 |