SQL关联查询消耗662ms
select count(*) from p_video_circle_relation a
left join p_video_info b
on a.video_id = b.work_id
where a.circle_id = 212307047;
最先想到的是表没有创建索引
mysql> desc p_video_circle_relation;
+-------------+------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| video_id | bigint(20) | YES | MUL | NULL | |
| circle_id | bigint(20) | YES | MUL | NULL | |
+-------------+------------+------+-----+---------+----------------+
3 rows in set
mysql> desc p_video_info;
+---------------+---------------+------+-----+---------+