Enlighten

Search by definition

Searches for entries given a specific substring for the definition

Request
Method: POST
Route: api/idion/idion_mwe/multisearch
Example: api/idion/idion_mwe/multisearch
Input Value
definition { "q": "predórgnavom" }
Request Headers
host: api.pomak.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: 40
content-type: application/json

Response
200 JSON
Response Headers
cache-control: no-cache, private
date: Sat, 17 Feb 2024 20:57:17 GMT
content-type: application/json
x-ratelimit-limit: 60
x-ratelimit-remaining: 59 
{
    "handler": "ApiResponse handler",
    "result": {
        "data": [
            {
                "id": 2560,
                "variants": [
                    "čéftom balíkoso"
                ],
                "description": null,
                "html_comment": null,
                "definitions": [
                    {
                        "id": 1734,
                        "lemma_id": 2560,
                        "definition": "predórgnavom",
                        "language": 10,
                        "definition_comment": null,
                        "intensification": null,
                        "mitigation": null,
                        "languages": {
                            "id": 10,
                            "value": "Pomak"
                        },
                        "style_tags": [],
                        "polarity_tags": [],
                        "emphasis_tags": [],
                        "idion_definition_translations": [
                            {
                                "id": 3075,
                                "language": {
                                    "id": 1,
                                    "value": "Greek"
                                },
                                "definition_id": 1734,
                                "translation": "υπενθυμίζω ξεχασμένα δεινά, ξαναφέρνω στην επιφάνεια κατευνασμένα πάθη",
                                "definition_comment": null
                            },
                            {
                                "id": 3076,
                                "language": {
                                    "id": 1,
                                    "value": "Greek"
                                },
                                "definition_id": 1734,
                                "translation": "ξύνω πληγές",
                                "definition_comment": "equivalent phrase"
                            },
                            {
                                "id": 3079,
                                "language": {
                                    "id": 2,
                                    "value": "English"
                                },
                                "definition_id": 1734,
                                "translation": "chisel wounds",
                                "definition_comment": "literal translation"
                            },
                            {
                                "id": 3080,
                                "language": {
                                    "id": 2,
                                    "value": "English"
                                },
                                "definition_id": 1734,
                                "translation": "go on hurting somebody",
                                "definition_comment": null
                            },
                            {
                                "id": 3081,
                                "language": {
                                    "id": 2,
                                    "value": "English"
                                },
                                "definition_id": 1734,
                                "translation": "open old wounds",
                                "definition_comment": "equivalent phrase"
                            },
                            {
                                "id": 3082,
                                "language": {
                                    "id": 4,
                                    "value": "Russian"
                                },
                                "definition_id": 1734,
                                "translation": "вызывать тяжёлые воспоминания, заставить вспомнить и вновь пережить",
                                "definition_comment": null
                            },
                            {
                                "id": 3083,
                                "language": {
                                    "id": 4,
                                    "value": "Russian"
                                },
                                "definition_id": 1734,
                                "translation": "бередить рану, растравлять рану, бередить душу",
                                "definition_comment": "equivalent phrase"
                            }
                        ]
                    }
                ]
            }
        ]
    },
    "system": {
        "messages": [],
        "status": 200,
        "status_text": "OK",
        "errors": [],
        "error_code": 0
    }
}

Time: 0.71

 
select * from `idion_definition` limit 1

Time: 0.83

 
select distinct `lemma_id` from `idion_definition` where `definition` LIKE ?
Bindings
0: %predórgnavom%

Time: 0.79

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

Time: 0.69

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

Time: 0.76

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

Time: 0.79

 
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 (1734)

Time: 0.77

 
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 (1734)

Time: 1.05

 
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 (1734)

Time: 0.75

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

Time: 1.13

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

Request
Method: POST
Route: api/idion/idion_mwe/multisearch
Example: api/idion/idion_mwe/multisearch
Input Value
definition { "q": "predórgnavom" }
Request Headers
host: api.pomak.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: 40
content-type: application/json