数据统计概览
新CID总数 |
新续充总数 |
新CID续充率 |
0个 |
0个 |
0 |
CID数据列表
CID |
MCC |
公司名称 |
充值次数 |
充值详情 |
账户余额 |
账户状态 |
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-07-06 19:57:51 HTTP/2.0 GET : https://kpi.dyyseo.com/detail?username=%E6%9D%A8%E6%8B%93
- 运行时间 : 0.092312s [ 吞吐率:10.83req/s ] 内存消耗:3,976.02kb 文件加载:133
- 查询信息 : 5 queries
- 缓存信息 : 0 reads,0 writes
- CONNECT:[ UseTime:0.000859s ] mysql:host=127.0.0.1;port=3306;dbname=kpi_dyyseo_com;charset=utf8
- SHOW FULL COLUMNS FROM `ads` [ RunTime:0.002192s ]
- SELECT *,count(id) as ct FROM `ads` WHERE `username` = '杨拓' AND `charge_at` > '2024-01-01 00:00:00' AND `charge_at` < '2024-04-01 00:00:00' AND `cid` NOT IN (SELECT `cid` FROM `ads` WHERE `charge_at` < '2024-01-01 00:00:00') GROUP BY `cid` [ RunTime:0.013685s ]
- SELECT * FROM `ads` WHERE `username` = '杨拓' AND `charge_at` > '2024-01-01 00:00:00' AND `charge_at` < '2024-04-01 00:00:00' AND `cid` NOT IN (SELECT `cid` FROM `ads` WHERE `charge_at` < '2024-01-01 00:00:00') GROUP BY `cid` HAVING count(id)>=2 [ RunTime:0.013616s ]
- SHOW FULL COLUMNS FROM `account` [ RunTime:0.001580s ]
- SELECT DISTINCT `username` FROM `account` [ RunTime:0.000307s ]
0.093484s