CREATE TABLE `hhyp_short_video` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hsvn` varchar(255) DEFAULT '' COMMENT '短視頻編號',
  `type` tinyint(1) DEFAULT '0' COMMENT '類型：1. 視頻 2.圖文',
  `user_id` int(11) DEFAULT '0',
  `video_url` varchar(255) DEFAULT '',
  `img_url` json DEFAULT NULL,
  `content` text COMMENT '內(nèi)容',
  `market_goods_id` int(11) DEFAULT '0',
  `address_id` int(11) DEFAULT '0' COMMENT '地址ID',
  `lat` decimal(4,0) DEFAULT '0' COMMENT '緯度',
  `lng` decimal(4,0) DEFAULT '0' COMMENT '經(jīng)度',
  `ip` varchar(100) CHARACTER SET utf8 DEFAULT '' COMMENT 'IP',
  `channel` tinyint(1) DEFAULT '0' COMMENT '渠道',
  `read_count` int(11) DEFAULT '0' COMMENT '瀏覽數(shù)',
  `like_count` int(11) DEFAULT '0' COMMENT '點贊數(shù)',
  `collect_count` int(11) DEFAULT '0' COMMENT '收藏數(shù)',
  `comment_count` int(11) DEFAULT '0' COMMENT '評論數(shù)',
  `share_count` int(11) DEFAULT '0' COMMENT '分享數(shù)',
  `is_top` tinyint(1) DEFAULT '0' COMMENT '是否置頂：0.否 1.是',
  `status` int(11) DEFAULT '0' COMMENT '0. 審核中 10. 推薦  20. 下架',
  `hot_int` int(11) DEFAULT '1' COMMENT '熱度初始值',
  `gravity` int(11) DEFAULT '1' COMMENT '熱度重力衰減值',
  `audit_time` int(11) DEFAULT '0' COMMENT '審核時間',
  `remark` text,
  `create_time` int(11) DEFAULT '0' COMMENT '創(chuàng)建時間',
  `delete_time` int(11) DEFAULT '0',
  `update_time` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8mb4;

public static function getList($map, $page = 1, $size = 20)
    {
        // 數(shù)據(jù)指標權重配置
        $wcfg = [
            'like_weight' => 4,
            'collect_weight' => 3,
            'comment_weight' => 1
        ];
        $timeUnit = 3600;          // 單位小時
        $where[] = ['delete_time', '=', 0];
        $map = array_merge($where, $map);
        // 單位小時內(nèi)，點贊/收藏/評論越多熱度越高，發(fā)布越久熱度越低
        $alog = "(like_count*%s+collect_count*%s+comment_count*%s+hot_int)/pow((UNIX_TIMESTAMP(NOW())-create_time)/%s, gravity)";
        $hotIndex = sprintf($alog, $wcfg['like_weight'], $wcfg['collect_weight'], $wcfg['comment_weight'], $timeUnit);
        $field = ["id, hsvn,type,user_id,video_url,img_url,content,market_goods_id,
        like_count,collect_count,address_id,comment_count,share_count,create_time, $hotIndex as hot_index"];
        $list = self::field($field)
            ->json(['img_url'], true)
            ->with([
                'user' => function ($query) {
                    $query->withField('id, nickname, mobile, avatar');
                },
                'marketGoods' => function ($query) {
                    $query->withField('id, content,freight,user_id');
                },
                'address' => function ($query) {
                    $query->withField('id, mername');
                }
            ])
            ->where($map)
            ->page($page, $size)
            ->order("hot_index desc")
            ->select();
        return $list;
    }

CREATE TABLE `hhyp_user_attention` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用戶id',
  `comcemed_user_id` int(11) NOT NULL DEFAULT '0' COMMENT '關注的用戶id',
  `create_time` int(11) DEFAULT '0' COMMENT '創(chuàng)建時間',
  `status` smallint(3) NOT NULL DEFAULT '0' COMMENT '關注狀態(tài) 0未關注 1已關注',
  `update_time` int(11) DEFAULT '0' COMMENT '更新時間',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=352 DEFAULT CHARSET=utf8mb4;

// 關注鏈列表
    public static function grandadList($userIds = [], &$allList = [], &$level = 1)
    {
        $field = ["comcemed_user_id, count(*) as fans_count, {$level} as level"];
        $list = self::field($field)
            ->where('comcemed_user_id', 'in', function ($query) use ($userIds) {
                $query->table('hhyp_user_attention')
                    ->where('user_id', 'in', $userIds)
                    ->where('status', '=', 1)
                    ->field('comcemed_user_id');
            })
            ->where('status', '=', 1)
            ->group('comcemed_user_id')
            ->order('fans_count desc')
            ->limit(10)
            ->select()
            ->toArray();
        if ($list && $level < 4) {
            $level++;
            $comcemedUserIds = array_column($list, 'comcemed_user_id');
            $list = self::grandadList($comcemedUserIds, $list, $level);
        }
        $list = array_merge($allList, $list);
        return $list;
    }