lMingyul

關鍵詞：代碼解釋，舉個例子：{代碼片段}

@Aspect
@Slf4j
@Component
public class LogAspect {

    public final static String TRACE_LOG_ID = "traceId";

    /**
     * 切面表達式  此次切面為 service 的實現類
     */
    @Pointcut("execution(* org.lmingyu.projects.cs.*.service.*.impl.*.*(..))")
    public void logPointcut() {

    }

    /**
     * 打印日誌
     *
     * @param pjp 入參 traceId 從第一個參數獲取
     * @return 結果
     * @throws Throwable 異常
     */
    @Around("logPointcut()")
    public Object doAround(ProceedingJoinPoint pjp) throws Throwable {
        String traceId = MDC.get(TRACE_LOG_ID);
        if (StringUtils.isBlank(traceId)) {
            if (pjp.getArgs().length > 0 && pjp.getArgs()[0] instanceof BaseReq) {
                BaseReq req = (BaseReq) pjp.getArgs()[0];
                if (StringUtils.isNotBlank(req.getTraceId())) {
                    traceId = req.getTraceId();
                }
            }
            if (StringUtils.isNotBlank(traceId)) {
                MDC.put(TRACE_LOG_ID, traceId);
            } else {
                MDC.put(TRACE_LOG_ID, UUID.randomUUID().toString());
            }
        }

        long startTime = System.currentTimeMillis();
        // 打印請求參數
        log.info("入參:{}", JSON.toJSONString(pjp.getArgs()));

        Object result = pjp.proceed();
        // 打印出參
        log.info("耗時{}ms,出參:{}", System.currentTimeMillis() - startTime, JSON.toJSONString(result));
        return result;
    }

}

# 告訴 ChatGPT 用什麼語言，語言版本號，加上給我完成的代碼
關鍵詞：請用 python3.7 編寫一個貪吃蛇遊戲，給我完整的代碼

關鍵詞： `修復 BUG：{代碼片段}`

關鍵詞： `優化代碼：{代碼片段}`

關鍵詞：SQL 優化：{SQL 片段}

-- 優化前 sql
SELECT COUNT(*) AS 'order_count',
SUM(amount) AS 'total_sales',
SUM(amount) / COUNT(*) AS'avg_sales_per_order'
FROM sales
WHERE user_id = 123
AND created_at BETWEENDATE_SUB(NOW(),INTERVAL 7 DAY) AND NOW();

--- 優化後 sql
SET @start_date = DATE_SUB(NOW(), INTERVAL 7 DAY);

SELECT 
  COUNT(*) AS 'order_count',
  SUM(amount) AS 'total_sales',
  SUM(amount) / COUNT(*) AS 'avg_sales_per_order'
FROM sales
WHERE 
  user_id = 123 AND 
  created_at BETWEEN @start_date AND NOW();

關鍵詞：生成對應的單元測試用例 {代碼片段}