exec("CREATE TABLE IF NOT EXISTS `goods_views` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`goods_id` int(11) NOT NULL,
`viewed_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `uk_user_goods` (`user_id`, `goods_id`),
KEY `idx_user` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4");
$vStmt = db()->prepare('SELECT COUNT(*) FROM goods_views WHERE user_id = ?');
$vStmt->execute([(int)$u['id']]);
$viewCount = (int)$vStmt->fetchColumn();
} catch (Throwable $e) {}
// 我的收藏数（真实统计）
$favCount = 0;
try {
db()->exec("CREATE TABLE IF NOT EXISTS `favorites` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`goods_id` int(11) NOT NULL,
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`), UNIQUE KEY `uk_user_goods` (`user_id`, `goods_id`), KEY `idx_user` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4");
$favStmt = db()->prepare('SELECT COUNT(*) FROM favorites WHERE user_id = ?');
$favStmt->execute([(int)$u['id']]);
$favCount = (int)$favStmt->fetchColumn();
} catch (Throwable $e) {}
?>
我的 - 盼之账号
