Laravel Enlighten

Search by lemma

Searches for entries given a specific substring for the lemma itself

Request

Method:	POST
Route:	api/idion/idion_mwe/multisearch
Example:	api/idion/idion_mwe/multisearch

Input	Value
lemma	{ "q": "αφήνω στον τόπο κάποιον" }

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:	141
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": 1,
                "variants": [
                    "αφήνω στον τόπο κάποιον"
                ],
                "description": null,
                "html_comment": null,
                "definitions": [
                    {
                        "id": 1,
                        "lemma_id": 1,
                        "definition": "σκοτώνω κάποιον",
                        "language": 1,
                        "definition_comment": "με δαρμό\/κρούση, με πυροβόλο όπλο",
                        "intensification": null,
                        "mitigation": null,
                        "languages": {
                            "id": 1,
                            "value": "Greek"
                        },
                        "style_tags": [],
                        "polarity_tags": [],
                        "emphasis_tags": [],
                        "idion_definition_translations": [
                            {
                                "id": 3179,
                                "language": {
                                    "id": 2,
                                    "value": "English"
                                },
                                "definition_id": 1,
                                "translation": "to knock someone off",
                                "definition_comment": "only by hitting"
                            },
                            {
                                "id": 3180,
                                "language": {
                                    "id": 2,
                                    "value": "English"
                                },
                                "definition_id": 1,
                                "translation": "to kill someone (outright)",
                                "definition_comment": "general"
                            },
                            {
                                "id": 3181,
                                "language": {
                                    "id": 3,
                                    "value": "French"
                                },
                                "definition_id": 1,
                                "translation": "assommer quelqu'un",
                                "definition_comment": "only by hitting"
                            },
                            {
                                "id": 3182,
                                "language": {
                                    "id": 3,
                                    "value": "French"
                                },
                                "definition_id": 1,
                                "translation": "abattre quelqu'un",
                                "definition_comment": "to kill someone using a gun"
                            },
                            {
                                "id": 3183,
                                "language": {
                                    "id": 3,
                                    "value": "French"
                                },
                                "definition_id": 1,
                                "translation": "tuer quelqu'un",
                                "definition_comment": "general"
                            }
                        ]
                    }
                ]
            }
        ]
    },
    "system": {
        "messages": [],
        "status": 200,
        "status_text": "OK",
        "errors": [],
        "error_code": 0
    }
}

Test Queries

Time: 1.32

select * from `idion_mwe` limit 1

Time: 0.86

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

Time: 0.85

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

Time: 0.62

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

Time: 0.63

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

Time: 0.61

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

Time: 0.65

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

Time: 0.59

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

Request Queries

Time: 0.72

select distinct `id` from `idion_mwe` where `hw` LIKE ?

Bindings

0:	%αφήνω στον τόπο κάποιον%

Time: 0.59

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

Time: 0.55

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

Time: 0.6

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

Time: 0.67

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

Time: 0.59

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

Time: 0.57

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

Time: 0.59

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

Time: 0.58

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

Time: 0.63

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

Time: 0.54

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

Time: 0.73

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

Time: 0.68

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

Time: 0.69

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

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
lemma	{ "q": "αφήνω στον τόπο κάποιον" }

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:	141
content-type:	application/json