[TOC] # 查询常用 ```sql // 日期 FROM_UNIXTIME(createtime,"%Y-%m-%d %H:%i:%s") SELECT *,FROM_UNIXTIME(createtime,"%Y-%m-%d %H:%i:%s") from fa_shopro_user_wallet_log where type='agent_award' order by id desc ``` # shopro问题排查 ``` SELECT *,FROM_UNIXTIME(createtime,"%Y-%m-%d %H:%i:%s") from fa_shopro_user_wallet_log where type='agent_award' order by id desc ```