PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 12 hours 42 minutes 12 seconds
Memory
Total
512MB
Used
13,33MB (2.6%)
Free
498,67MB
Keys
Current
10 164
Total (since start)
11 094
Evictions
0
Reclaimed
157
Expired Unfetched
0
Evicted Unfetched
0
Connections
Current
3 / 1 024 max
Total
68 181
Rejected
0
llm:0950f60d67fe0aec1ea838825242e5c3c552ac4054475e70eba0aa50a59daf40
Edit
```json
{
"queries": [
{
"query": "SELECT \"name\", \"rating_count\", \"avg_rating\" FROM \"beers\" WHERE \"avg_rating\" IS NOT NULL ORDER BY \"rating_count\" DESC LIMIT 20",
"description": "Top 20 most-reviewed beers with their average ratings."
},
{
"query": "SELECT \"continent\", COUNT(*) AS brewery_count FROM \"countries\" WHERE \"has_brewer\" = TRUE GROUP BY \"continent\" ORDER BY brewery_count DESC",
"description": "Number of countries with breweries by continent."
},
{
"query": "SELECT \"name\", \"alcohol_pct\", \"ibu\", \"avg_rating\" FROM \"beers\" WHERE \"alcohol_pct\" IS NOT NULL AND \"ibu\" IS NOT NULL ORDER BY \"alcohol_pct\" DESC LIMIT 15",
"description": "Highest alcohol content beers with IBU and ratings."
},
{
"query": "SELECT bs.\"name\" AS style, COUNT(*) AS beer_count, AVG(b.\"avg_rating\") AS avg_style_rating FROM \"beers\" b JOIN \"beer_styles\" bs ON b.\"style_id\" = bs.\"style_id\" WHERE b.\"avg_rating\" IS NOT NULL GROUP BY bs.\"name\" ORDER BY beer_count DESC LIMIT 15",
"description": "Most common beer styles with their average ratings."
},
{
"query": "SELECT \"name\", \"city\", \"rating_count\", \"avg_rating\" FROM \"places\" WHERE \"has_rare_beers\" = TRUE AND \"avg_rating\" IS NOT NULL ORDER BY \"rating_count\" DESC LIMIT 20",
"description": "Top-rated places offering rare beers, sorted by review count."
},
{
"query": "SELECT \"name\", \"beer_rating_count\", \"avg_beer_rating\" FROM \"users\" WHERE \"beer_rating_count\" > 0 ORDER BY \"beer_rating_count\" DESC LIMIT 20",
"description": "Most active beer reviewers with their average ratings."
},
{
"query": "SELECT br.\"name\" AS brewer, COUNT(b.\"beer_id\") AS beer_count, AVG(b.\"avg_rating\") AS avg_brewer_rating FROM \"brewers\" br JOIN \"beers\" b ON br.\"brewer_id\" = b.\"brewer_id\" WHERE b.\"avg_rating\" IS NOT NULL GROUP BY br.\"name\" ORDER BY beer_count DESC LIMIT 20",
"description": "Breweries with the most beers and their average ratings."
},
{
"query": "SELECT \"is_on_tap\", \"is_in_bottle\", COUNT(*) AS availability_count FROM \"availability\" GROUP BY \"is_on_tap\", \"is_in_bottle\" ORDER BY availability_count DESC",
"description": "Beer availability breakdown by tap and bottle options."
},
{
"query": "SELECT \"name\", \"avg_rating\", \"rating_count\" FROM \"beers\" WHERE \"is_seasonal\" = TRUE AND \"avg_rating\" IS NOT NULL ORDER BY \"avg_rating\" DESC LIMIT 20",
"description": "Highest-rated seasonal beers with review counts."
},
{
"query": "SELECT pt.\"name\" AS place_type, COUNT(*) AS place_count, AVG(p.\"avg_rating\") AS avg_type_rating FROM \"places\" p JOIN \"place_types\" pt ON p.\"type_id\" = pt.\"type_id\" WHERE p.\"avg_rating\" IS NOT NULL GROUP BY pt.\"name\" ORDER BY place_count DESC",
"description": "Distribution of places by type with average ratings."
}
]
}
```