0.0008 | UPDATE sm_keywords_count SET cweek = cweek + 1,cday = cday + 1 WHERE id = 16989 |
0.0018 | SELECT * FROM top_search WHERE type = 0 ORDER BY id ASC |
0.0018 | SELECT id,keyword,cplayers,cleagues,cmatchs,cteams,cvideos,cpictures,cnews,ctotal,nodo,idkeyword FROM sm_keywords WHERE lang = 1 AND keyword = 'racing' |
0.0019 | SELECT id FROM sm_keywords_count WHERE id = '16989' AND type = 0 |
0.0472 | SELECT p.title,p.totalcomments,p.downloads,p.keywords,p.views,p.id,p.author_id FROM `rel_keywords_r` 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 = 229 AND rk.content_type = 2 GROUP BY rk.content_id ORDER BY p.creation_date > '2024-04-02' DESC, p.karma DESC LIMIT 0, 6 |
0.0295 | SELECT p.title,p.totalcomments,p.downloads,p.keywords,p.views,p.id,p.author_id FROM `rel_keywords_r` as rk INNER JOIN `videos` as p ON p.id = rk.content_id WHERE rk.keyword_id = 229 AND rk.content_type = 3 GROUP BY rk.content_id ORDER BY p.creation_date > '2024-04-02' DESC, p.karma DESC LIMIT 0, 6 |
0.0116 | 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_r` 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 = 229 AND rk.content_type = 4 ORDER BY p.creation_date > '2024-04-02' DESC, p.karma DESC LIMIT 0, 4 |
0.0020 | SELECT sm.*,k.points FROM sm_rel_keywords_92 k INNER JOIN sm_data_2 sm ON sm.id = k.content_id WHERE k.keyword_id = '16989' AND k.content_type = 2 ORDER BY sm.priority DESC LIMIT 0,10 |
0.0018 | SELECT sm.*,k.points FROM sm_rel_keywords_92 k INNER JOIN sm_data_3 sm ON sm.id = k.content_id WHERE k.keyword_id = '16989' AND k.content_type = 3 ORDER BY sm.priority DESC LIMIT 0,10 |
0.0019 | SELECT sm.*,k.points FROM sm_rel_keywords_92 k INNER JOIN sm_data_4 sm ON sm.id = k.content_id WHERE k.keyword_id = '16989' AND k.content_type = 4 ORDER BY sm.priority DESC LIMIT 0,10 |