Enlighten

Search by translation

Searches for entries given a specific substring for the translation

Request
Method: POST
Route: api/idion/idion_mwe/multisearch
Example: api/idion/idion_mwe/multisearch
Input Value
translation { "q": "to hush, to remain silent" }
Request Headers
host: api.greek.idion.athenarc.gr
user-agent: Symfony
accept: application/json
accept-language: en-us,en;q=0.5
accept-charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
content-length: 49
content-type: application/json

Response
200 JSON
Response Headers
cache-control: no-cache, private
date: Sat, 17 Feb 2024 20:58:07 GMT
content-type: application/json
x-ratelimit-limit: 60
x-ratelimit-remaining: 59 
{
    "handler": "ApiResponse handler",
    "result": {
        "data": [
            {
                "id": 229,
                "variants": [
                    "δε βγάζω κιχ"
                ],
                "description": null,
                "html_comment": null,
                "definitions": [
                    {
                        "id": 223,
                        "lemma_id": 229,
                        "definition": "σωπαίνω",
                        "language": 1,
                        "definition_comment": null,
                        "intensification": null,
                        "mitigation": null,
                        "languages": {
                            "id": 1,
                            "value": "Greek"
                        },
                        "style_tags": [],
                        "polarity_tags": [],
                        "emphasis_tags": [],
                        "idion_definition_translations": [
                            {
                                "id": 1,
                                "language": {
                                    "id": 2,
                                    "value": "English"
                                },
                                "definition_id": 223,
                                "translation": "to hush, to remain silent",
                                "definition_comment": null
                            },
                            {
                                "id": 1152,
                                "language": {
                                    "id": 3,
                                    "value": "French"
                                },
                                "definition_id": 223,
                                "translation": "ne dire mot",
                                "definition_comment": null
                            },
                            {
                                "id": 1153,
                                "language": {
                                    "id": 3,
                                    "value": "French"
                                },
                                "definition_id": 223,
                                "translation": "se taire",
                                "definition_comment": null
                            },
                            {
                                "id": 1154,
                                "language": {
                                    "id": 3,
                                    "value": "French"
                                },
                                "definition_id": 223,
                                "translation": "la boucler",
                                "definition_comment": null
                            },
                            {
                                "id": 1636,
                                "language": {
                                    "id": 2,
                                    "value": "English"
                                },
                                "definition_id": 223,
                                "translation": "to not hear a peep",
                                "definition_comment": null
                            },
                            {
                                "id": 1637,
                                "language": {
                                    "id": 2,
                                    "value": "English"
                                },
                                "definition_id": 223,
                                "translation": "to not make a sound",
                                "definition_comment": null
                            }
                        ]
                    }
                ]
            }
        ]
    },
    "system": {
        "messages": [],
        "status": 200,
        "status_text": "OK",
        "errors": [],
        "error_code": 0
    }
}

Time: 0.61

 
select * from `idion_definition_translation` limit 1

Time: 0.67

 
select * from `language` where `language`.`id` in (2)

Time: 0.73

 
select distinct `lemma_id` as `id` from `idion_definition` where exists (select * from `idion_definition_translation` where `idion_definition_translation`.`definition_id` = idion_definition.id and `idion_definition_translation`.`translation` like ?)
Bindings
0: %to hush, to remain silent%

Time: 0.62

 
select * from `idion_mwe` where `idion_mwe`.`id` in (229)

Time: 0.57

 
select * from `idion_definition` where `idion_definition`.`lemma_id` in (229)

Time: 0.57

 
select * from `language` where `language`.`id` in (1)

Time: 0.59

 
select `style_tag`.*, `definition_has_style`.`definition_id` as `pivot_definition_id`, `definition_has_style`.`style_id` as `pivot_style_id` from `style_tag` inner join `definition_has_style` on `style_tag`.`id` = `definition_has_style`.`style_id` where `definition_has_style`.`definition_id` in (223)

Time: 1.02

 
select `polarity_tag`.*, `definition_has_polarity`.`definition_id` as `pivot_definition_id`, `definition_has_polarity`.`polarity_id` as `pivot_polarity_id` from `polarity_tag` inner join `definition_has_polarity` on `polarity_tag`.`id` = `definition_has_polarity`.`polarity_id` where `definition_has_polarity`.`definition_id` in (223)

Time: 0.87

 
select `emphasis_tag`.*, `definition_has_emphasis`.`definition_id` as `pivot_definition_id`, `definition_has_emphasis`.`emphasis_id` as `pivot_emphasis_id` from `emphasis_tag` inner join `definition_has_emphasis` on `emphasis_tag`.`id` = `definition_has_emphasis`.`emphasis_id` where `definition_has_emphasis`.`definition_id` in (223)

Time: 0.59

 
select * from `idion_definition_translation` where `idion_definition_translation`.`definition_id` in (223)

Time: 0.67

 
select * from `language` where `language`.`id` in (2, 3)

Request
Method: POST
Route: api/idion/idion_mwe/multisearch
Example: api/idion/idion_mwe/multisearch
Input Value
translation { "q": "to hush, to remain silent" }
Request Headers
host: api.greek.idion.athenarc.gr
user-agent: Symfony
accept: application/json
accept-language: en-us,en;q=0.5
accept-charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
content-length: 49
content-type: application/json