0.0006 | UPDATE sm_keywords_count SET cweek = cweek + 1,cday = cday + 1 WHERE id = 11053 |
0.0018 | SELECT * FROM top_search WHERE type = 0 ORDER BY id ASC |
0.0020 | SELECT id,keyword,cplayers,cleagues,cmatchs,cteams,cvideos,cpictures,cnews,ctotal,nodo,idkeyword FROM sm_keywords WHERE lang = 1 AND keyword = 'inter' |
0.0021 | SELECT id FROM sm_keywords_count WHERE id = '11053' AND type = 0 |
0.0707 | SELECT p.title,p.totalcomments,p.downloads,p.keywords,p.views,p.id,p.author_id FROM `rel_keywords_i` as rk INNER JOIN `pictures` as p ON p.id = rk.content_id WHERE p.banned = 0 and p.revised = 1 AND rk.keyword_id = 506 AND rk.content_type = 2 GROUP BY rk.content_id ORDER BY p.creation_date > '2024-03-29' DESC, p.karma DESC LIMIT 0, 6 |
0.0240 | SELECT p.title,p.totalcomments,p.downloads,p.keywords,p.views,p.id,p.author_id FROM `rel_keywords_i` as rk INNER JOIN `videos` as p ON p.id = rk.content_id WHERE rk.keyword_id = 506 AND rk.content_type = 3 GROUP BY rk.content_id ORDER BY p.creation_date > '2024-03-29' DESC, p.karma DESC LIMIT 0, 6 |
0.0245 | SELECT p.id,p.content_type,p.teaser,p.votes_up,p.totalcomments,p.keywords,p.votes_down,p.title,p.views,p.alias,p.video_content_id,p.picture_content_id,p.body,pic.author_id as pauthor_id,0 as vauthor_id,p.creation_date FROM `rel_keywords_i` as rk INNER JOIN `news` as p ON p.id = rk.content_id INNER JOIN `pictures` as pic ON p.picture_content_id = pic.id AND pic.banned = 0 and pic.revised = 1 WHERE rk.keyword_id = 506 AND rk.content_type = 4 ORDER BY p.creation_date > '2024-03-29' DESC, p.karma DESC LIMIT 0, 4 |
0.0020 | SELECT sm.*,k.points FROM sm_rel_keywords_282 k INNER JOIN sm_data_2 sm ON sm.id = k.content_id WHERE k.keyword_id = '11053' AND k.content_type = 2 ORDER BY sm.priority DESC LIMIT 0,10 |
0.0018 | SELECT sm.*,k.points FROM sm_rel_keywords_282 k INNER JOIN sm_data_3 sm ON sm.id = k.content_id WHERE k.keyword_id = '11053' AND k.content_type = 3 ORDER BY sm.priority DESC LIMIT 0,10 |
0.0018 | SELECT sm.*,k.points FROM sm_rel_keywords_282 k INNER JOIN sm_data_4 sm ON sm.id = k.content_id WHERE k.keyword_id = '11053' AND k.content_type = 4 ORDER BY sm.priority DESC LIMIT 0,10 |