# graph-4.0

**Repository Path**: fengqi0705/graph-4.0

## Basic Information

- **Project Name**: graph-4.0
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 1
- **Created**: 2026-07-23
- **Last Updated**: 2026-07-27

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

1、面试准备：Transformer架构
    1.1 为什么会出现：NLP->RNN->LSTM,注意力机制
    1.2 编码器和解码器架构：Seq2Seq
        编码器
        解码器
    1.3 核心组件
        自注意力机制：QKV
        多头注意力
        位置编码
        前馈神经网络FFN+残差连接+层归一化

{
    "id":1,
    "text":"小米12S Ultra 骁龙8+旗舰处理器 徕卡光学镜头 2K超视感屏 120Hz高刷 67W快充 12GB+256GB 冷杉绿 5G手机",
    "Comments":[],
    "entities":[
        {
            "id":236,
            "label":"品牌","start_offset":0,"end_offset":2
        },
        {"id":237,"label":"商品","start_offset":0,"end_offset":11},
        {"id":238,"label":"运行内存","start_offset":50,"end_offset":54},
        {"id":239,"label":"机身内存","start_offset":55,"end_offset":60},
        {"id":240,"label":"版本","start_offset":50,"end_offset":60},
        {"id":241,"label":"颜色","start_offset":61,"end_offset":64},
        {"id":242,"label":"品类","start_offset":67,"end_offset":69}],
        "relations":[
            {"id":18,"from_id":237,"to_id":241,"type":"颜色"},
            {"id":19,"from_id":237,"to_id":242,"type":"品类"},
            {"id":20,"from_id":237,"to_id":236,"type":"品牌"},
            {"id":21,"from_id":237,"to_id":238,"type":"运行内存"},
            {"id":22,"from_id":237,"to_id":239,"type":"机身内存"},
            {"id":23,"from_id":237,"to_id":240,"type":"版本"}
        ]
    }
       

{
    "content": "购买客户尊享会员服务免||换|保7天无理由退货质量问题15天换新下单享3年质保认准官方旗舰店买得放心,用得更加安心!正连官方正品全国联保", 
    "result_list": [], 
    "prompt": "尺码"
    }
{
    "content": "小米【国家补贴】REDMI Turbo4 Pro 新品上市 小米手机 小米5G手机红米turbo 7550mAh长续航电池 白色 12GB+256GB", 
    "result_list": [
        {
            "text": "小米", 
            "start": 0, 
            "end": 2}, 
        {
            "text": "REDMI", 
            "start": 8, 
            "end": 13
        }, 
        {
            "text": "小米", 
            "start": 30, 
            "end": 32
        }, 
        {
            "text": "小米", 
            "start": 35, 
            "end": 37
        }, 
        {
            "text": "红米", 
            "start": 41, 
            "end": 43
        }
    ], 
    "prompt": "品牌"}


select sku_info.id as sku_id, sku_info.sku_name, spu_info.spu_name, bc3.name category3_name, bc2.name category2_name,bc1.name category1_name,bt.tm_name trademark_name
from sku_info 
left join spu_info on sku_info.spu_id=spu_info.id 
left join base_category3 bc3 on spu_info.category3_id = bc3.id 
left join base_category2 bc2 on bc3.category2_id=bc2.id
left join base_category1 bc1 on bc2.category1_id=bc1.id
left join base_trademark bt on spu_info.tm_id=bt.id