Enlighten
main * cfe6df1

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: Sun, 01 Feb 2026 00:53:43 GMT
content-type: application/json
cache-control: no-cache, private 
{
    "data": [
        {
            "id": 1,
            "teleterm_searches": 8059,
            "inforterm_searches": 2876,
            "termterm_searches": 2314,
            "acouterm_searches": 930,
            "electerm_searches": 2269,
            "lexiterm_searches": 1246,
            "emcterm_searches": 845,
            "sensoterm_searches": 786,
            "chromoterm_searches": 420,
            "geoterm_searches": 393,
            "optoterm_searches": 301,
            "unitterm_searches": 225,
            "philotterm_searches": 150,
            "foraterm_searches": 138,
            "docuterm_searches": 108,
            "feminbase_searches": 46,
            "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,
            "feminbase_rows": 3143,
            "total_rows": 212911,
            "termmaster_games": 2239,
            "total_searches": 21152
        }
    ],
    "system": {
        "messages": [],
        "status": 200,
        "status_text": "OK",
        "errors": [],
        "error_code": 0
    },
    "metadata": {
        "request": [],
        "count": 1
    }
}

Time: 127.06

 
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`, `feminbase_searches`, `feminbase_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 `FEMINBASE_FEMINBASE`) as feminbase_rows, (SELECT COUNT(*) FROM `FEMINBASE_FEMINBASE`) as feminbase_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`) + (SELECT COUNT(*) FROM `FEMINBASE_FEMINBASE`) + (SELECT COUNT(*) FROM `FEMINBASE_FEMINBASE`) AS total_rows from `STATISTICS`

Time: 1.1

 
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