4 000 ₴
Продається дитяче ліжко
4000.0
Коростень
Знайдено 12 608 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 2150
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 9450,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.28 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name_ua, ''), NULLIF(c.name, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.url IN (?, ?, ?, ?) LIMIT 1 ["korosten","\/korosten","korosten\/","\/korosten\/"] · 1.92 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.73 msSHOW TABLES · 0.47 msSELECT p.id, p.category_id, p.city_id, p.region AS region_id, p.vendor AS vendor_id, p.name, p.description, p.name AS name_orig, p.price, p.currency, p.bargain, p.conditions, p.url, p.img, p.view AS views, p.data_post, p.data_edit, COALESCE(NULLIF(c.name_ua, ''), NULLIF(c.name, '')) AS city_name, c.url AS city_slug FROM `post` p LEFT JOIN `city` c ON c.id = p.city_id WHERE p.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND (1=1) [187868352,187867110,187861503,187855425,187850793,187847085,187847082,187845285,187845213,187842159,187841661,187834842,187833393,187831236,187826085,187824711,187813428,187806366,187804596,187803798,187792608,187792371,187791666,187783155,187779642,187778286,187777938,187771719,187769559,187766949,187766574,187764306,187756422,187752084,187751088,187747827,187747677,187742748,187741074,187738356,187737450,187734840,187733217,187723563,187723533,187723140,187722303,187714368,187687080,187682178] · 137.98 msSELECT v.post_id, v.attribute_id, v.value, COALESCE(NULLIF(a.name_ua, ''), NULLIF(a.name, '')) AS name FROM `attribute_value` v JOIN `attribute` a ON a.id = v.attribute_id WHERE v.post_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND v.value IS NOT NULL AND v.value <> '' ORDER BY a.id [187682178,187687080,187714368,187722303,187723140,187723533,187723563,187733217,187734840,187737450,187738356,187741074,187742748,187747677,187747827,187751088,187752084,187756422,187764306,187766574,187766949,187769559,187771719,187777938,187778286,187779642,187783155,187791666,187792371,187792608,187803798,187804596,187806366,187813428,187824711,187826085,187831236,187833393,187834842,187841661,187842159,187845213,187845285,187847082,187847085,187850793,187855425,187861503,187867110,187868352] · 7.83 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name_ua, ''), NULLIF(c.name, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.parent_id = ? LIMIT 3000 [5] · 1.66 ms