0.0951 | 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.cover = 1 DESC,p.pub_date DESC LIMIT 12, 30 |
0.0030 | 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 (99190,99179,99177,99169,99166,99146,99127,99102,99095,99084,99081,99077,98989,98903,98861,98793,98777,98775,98774,98736,98732,98729,98713,98708,98709,98704,98699,98696,98697,98689) |
0.0528 | 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.cover = 1 DESC,p.pub_date DESC LIMIT 0, 12 |
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 (99629,99628,99630,99632,99631,99562,99542,99239,99211,99201,99200,99199) |
0.0019 | SELECT total FROM `totals` WHERE id = 8 |