PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 8 hours 12 minutes 41 seconds
Memory
Total
512MB
Used
13,32MB (2.6%)
Free
498,68MB
Keys
Current
10 162
Total (since start)
11 092
Evictions
0
Reclaimed
157
Expired Unfetched
0
Evicted Unfetched
0
Connections
Current
2 / 1 024 max
Total
63 288
Rejected
0
llm:9a2dabda4937e902ca8fb07fb830de9d4c0b0da6a63cf2e3f1a0f11d9b29a776
Edit
```json
{
"queries": [
{
"query": "SELECT \"Champion\", \"Recognition\", \"Begin_reign\", \"End_reign\" FROM championsdataset ORDER BY \"Begin_reign\" DESC LIMIT 10",
"description": "Most recent boxing champions by reign start date."
},
{
"query": "SELECT \"Recognition\", COUNT(*) AS champion_count FROM championsdataset WHERE \"Recognition\" IS NOT NULL GROUP BY \"Recognition\" ORDER BY champion_count DESC",
"description": "Number of champions by recognition organization."
},
{
"query": "SELECT \"Champion\", \"Days\", \"Title_defenses\" FROM championsdataset WHERE \"Days\" IS NOT NULL ORDER BY \"Days\" DESC LIMIT 10",
"description": "Longest championship reigns by days held."
},
{
"query": "SELECT \"Champion\", \"Title_defenses\", \"Recognition\" FROM championsdataset WHERE \"Title_defenses\" IS NOT NULL ORDER BY \"Title_defenses\" DESC LIMIT 10",
"description": "Champions with the most title defenses."
},
{
"query": "SELECT \"Champion\", \"Recognition\", \"Additional_recognition\" FROM championsdataset WHERE \"Additional_recognition\" IS NOT NULL LIMIT 15",
"description": "Champions with additional recognition beyond their primary title."
},
{
"query": "SELECT \"Champion\", COUNT(*) AS reign_count FROM championsdataset GROUP BY \"Champion\" HAVING COUNT(*) > 1 ORDER BY reign_count DESC",
"description": "Champions who held titles multiple times, ranked by number of reigns."
},
{
"query": "SELECT \"Recognition\", AVG(CAST(\"Days\" AS INTEGER)) AS avg_days FROM championsdataset WHERE \"Days\" IS NOT NULL AND \"Days\" != '' GROUP BY \"Recognition\" ORDER BY avg_days DESC",
"description": "Average reign duration in days by recognition organization."
},
{
"query": "SELECT \"Champion\", \"Begin_reign\", \"End_reign\", \"Days\" FROM championsdataset WHERE \"Days\" IS NOT NULL ORDER BY \"Days\" ASC LIMIT 10",
"description": "Shortest championship reigns by days held."
}
]
}
```