Retrieve usage statistics
Returns statistics for all searches performed for the database
Request
| Method: | GET |
| Route: | api/statistics |
| Example: | api/statistics |
Request Headers
| host: | localhost:8000 |
| accept: | application/json |
| user-agent: | Symfony |
| content-type: | application/json |
| accept-charset: | ISO-8859-1,utf-8;q=0.7,*;q=0.7 |
| content-length: | 2 |
| accept-language: | en-us,en;q=0.5 |
Response
200
JSON
Response Headers
| date: | Tue, 14 Oct 2025 08:48:10 GMT |
| content-type: | application/json |
| cache-control: | no-cache, private |
{
"data": [
{
"id": 1,
"teleterm_searches": 7935,
"inforterm_searches": 2801,
"termterm_searches": 2240,
"acouterm_searches": 856,
"electerm_searches": 2195,
"lexiterm_searches": 1172,
"emcterm_searches": 771,
"sensoterm_searches": 711,
"chromoterm_searches": 346,
"geoterm_searches": 319,
"optoterm_searches": 227,
"unitterm_searches": 151,
"philotterm_searches": 76,
"foraterm_searches": 64,
"docuterm_searches": 34,
"teleterm_rows": 130625,
"inforterm_rows": 7256,
"termterm_rows": 3651,
"acouterm_rows": 10594,
"electerm_rows": 21518,
"lexiterm_rows": 16626,
"emcterm_rows": 4141,
"sensoterm_rows": 286,
"chromoterm_rows": 158,
"geoterm_rows": 1440,
"optoterm_rows": 1271,
"unitterm_rows": 657,
"philotterm_rows": 443,
"foraterm_rows": 6297,
"docuterm_rows": 1662,
"total_rows": 206625,
"termmaster_games": 2215,
"total_searches": 19898
}
],
"system": {
"messages": [],
"status": 200,
"status_text": "OK",
"errors": [],
"error_code": 0
},
"metadata": {
"request": [],
"count": 1
}
}Time: 161.79
select `id`, `teleterm_searches`, `inforterm_searches`, `termterm_searches`, `acouterm_searches`, `electerm_searches`, `lexiterm_searches`, `emcterm_searches`, `sensoterm_searches`, `chromoterm_searches`, `geoterm_searches`, `optoterm_searches`, `unitterm_searches`, `philotterm_searches`, `foraterm_searches`, `docuterm_searches`, (SELECT COUNT(*) FROM `TELETERM_TELETERM`) as teleterm_rows, (SELECT COUNT(*) FROM `INFORTERM_INFORTERM`) as inforterm_rows, (SELECT COUNT(*) FROM `TERMTERM_TERMTERM`) as termterm_rows, (SELECT COUNT(*) FROM `ACOUTERM_ACOUTERM`) as acouterm_rows, (SELECT COUNT(*) FROM `ELECTERM_ELECTERM`) as electerm_rows, (SELECT COUNT(*) FROM `LEXITERM_LEXITERM`) as lexiterm_rows, (SELECT COUNT(*) FROM `EMCTERM_EMCTERM`) as emcterm_rows, (SELECT COUNT(*) FROM `SENSOTERM_SENSOTERM`) as sensoterm_rows, (SELECT COUNT(*) FROM `CHROMOTERM_CHROMOTERM`) as chromoterm_rows, (SELECT COUNT(*) FROM `GEOTERM_GEOTERM`) as geoterm_rows, (SELECT COUNT(*) FROM `OPTOTERM_OPTOTERM`) as optoterm_rows, (SELECT COUNT(*) FROM `UNITTERM_UNITTERM`) as unitterm_rows, (SELECT COUNT(*) FROM `PHILOTTERM_PHILOTTERM`) as philotterm_rows, (SELECT COUNT(*) FROM `FORATERM_FORATERM`) as foraterm_rows, (SELECT COUNT(*) FROM `DOCUTERM_DOCUTERM`) as docuterm_rows, (SELECT COUNT(*) FROM `TELETERM_TELETERM`) + (SELECT COUNT(*) FROM `INFORTERM_INFORTERM`) + (SELECT COUNT(*) FROM `TERMTERM_TERMTERM`) + (SELECT COUNT(*) FROM `ACOUTERM_ACOUTERM`) + (SELECT COUNT(*) FROM `ELECTERM_ELECTERM`) + (SELECT COUNT(*) FROM `LEXITERM_LEXITERM`) + (SELECT COUNT(*) FROM `EMCTERM_EMCTERM`) + (SELECT COUNT(*) FROM `SENSOTERM_SENSOTERM`) + (SELECT COUNT(*) FROM `CHROMOTERM_CHROMOTERM`) + (SELECT COUNT(*) FROM `GEOTERM_GEOTERM`) + (SELECT COUNT(*) FROM `OPTOTERM_OPTOTERM`) + (SELECT COUNT(*) FROM `UNITTERM_UNITTERM`) + (SELECT COUNT(*) FROM `PHILOTTERM_PHILOTTERM`) + (SELECT COUNT(*) FROM `FORATERM_FORATERM`) + (SELECT COUNT(*) FROM `DOCUTERM_DOCUTERM`) AS total_rows from `STATISTICS`Time: 3.02
select * from `GAME_STATISTICS` where `GAME_STATISTICS`.`id` = ? limit 1
Bindings
| 0: | 1 |
Request
| Method: | GET |
| Route: | api/statistics |
| Example: | api/statistics |
Request Headers
| host: | localhost:8000 |
| accept: | application/json |
| user-agent: | Symfony |
| content-type: | application/json |
| accept-charset: | ISO-8859-1,utf-8;q=0.7,*;q=0.7 |
| content-length: | 2 |
| accept-language: | en-us,en;q=0.5 |