Laravel Enlighten

Search by multiple criteria

An example for multiple criteria

Request

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

Input	Value
lemma	{ "q": "čéftom balíkoso" }
definition	{ "q": "predórgnavom" }
translation	{ "q": "υπενθυμίζω ξεχασμένα δεινά, ξαναφέρνω στην επιφάνεια κατευνασμένα πάθη" }

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

Response

200 JSON

Response Headers

cache-control:	no-cache, private
date:	Sat, 17 Feb 2024 20:57:18 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
    }
}

Test Queries

Time: 0.69

select * from `idion_mwe` limit 1

Time: 0.73

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

Time: 0.61

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

Time: 0.74

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.68

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: 0.67

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.64

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

Time: 0.64

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

Time: 0.73

select * from `idion_definition` limit 1

Time: 0.56

select * from `idion_definition_translation` limit 1

Time: 0.72

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

Request Queries

Time: 0.8

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

Bindings

0:	%čéftom balíkoso%

Time: 0.63

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

Time: 0.52

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

Time: 0.4

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

Time: 0.83

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.54

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

Time: 0.51

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

Time: 0.52

select distinct `lemma_id` from `idion_definition` where `definition` LIKE ?

Bindings

0:	%predórgnavom%

Time: 0.54

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:	%υπενθυμίζω ξεχασμένα δεινά, ξαναφέρνω στην επιφάνεια κατευνασμένα πάθη%

Time: 0.43

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

Time: 0.51

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

Time: 0.48

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

Time: 0.39

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.42

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: 0.51

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.44

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

Time: 0.4

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
lemma	{ "q": "čéftom balíkoso" }
definition	{ "q": "predórgnavom" }
translation	{ "q": "υπενθυμίζω ξεχασμένα δεινά, ξαναφέρνω στην επιφάνεια κατευνασμένα πάθη" }

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