新浪微博如何获取我关注的人的微博的？-PHP-Tutorial-php.cn

新浪微博如何获取我关注的人的微博的？

WBOY

Freigeben： 2016-06-06 20:50:12

Original

1285 Leute haben es durchsucht

比如，我本身已经关注了a,b,c

那sql可能这样的

<code class="lang-php">$db->select('select * from posts where authorid in (a,b,c) order by timestamp desc limit N');
</code>

Nach dem Login kopieren

但是，假如我关注了1000个人呢？10000个呢？

使用redis如何操作呢?

记事狗微博是这么干的

<code class="lang-sql">SELECT tid FROM jishigou_topic   WHERE 1  AND  uid IN('1','2') AND `type` IN('first','forward','both')   AND `dateline`>1366483026    ORDER BY `dateline` DESC   LIMIT 1000   

REPLACE INTO jishigou_cache_7 SET `key`='1-topic-myhome--0',`dateline`='1369075026',`val`='YToyOntzOjQ6ImRhdGEiO2E6Mjp7czo0OiJsaXN0IjthOjE6e2k6MDthOjQ6e2k6MDtzOjE6IjQiO2k6MTtzOjE6IjMiO2k6MjtzOjE6IjIiO2k6MztzOjE6IjEiO319czo1OiJjb3VudCI7aTo0O31zOjQ6ImxpZmUiO2k6NjAwO30='

SELECT * FROM jishigou_topic WHERE `tid` IN ('4','3','2','1') 
</code>

Nach dem Login kopieren

回复内容：

比如，我本身已经关注了a,b,c

那sql可能这样的

<code class="lang-php">$db->select('select * from posts where authorid in (a,b,c) order by timestamp desc limit N');
</code>

Nach dem Login kopieren

但是，假如我关注了1000个人呢？10000个呢？

使用redis如何操作呢?

记事狗微博是这么干的

<code class="lang-sql">SELECT tid FROM jishigou_topic   WHERE 1  AND  uid IN('1','2') AND `type` IN('first','forward','both')   AND `dateline`>1366483026    ORDER BY `dateline` DESC   LIMIT 1000   

REPLACE INTO jishigou_cache_7 SET `key`='1-topic-myhome--0',`dateline`='1369075026',`val`='YToyOntzOjQ6ImRhdGEiO2E6Mjp7czo0OiJsaXN0IjthOjE6e2k6MDthOjQ6e2k6MDtzOjE6IjQiO2k6MTtzOjE6IjMiO2k6MjtzOjE6IjIiO2k6MztzOjE6IjEiO319czo1OiJjb3VudCI7aTo0O31zOjQ6ImxpZmUiO2k6NjAwO30='

SELECT * FROM jishigou_topic WHERE `tid` IN ('4','3','2','1') 
</code>

Nach dem Login kopieren

YY一下如果是我，并且是用redis，我会如何解决这个问题。