450 $
Volkswagen touran фара права ліва ксенон led 1t1941752h 1t1941751h
19800.0
Дружба
Знайдено 679 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3642
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 450,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 0.91 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 ["drujba","\/drujba","drujba\/","\/drujba\/"] · 0.97 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.62 msSHOW TABLES · 1.52 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) [202439389,202431537,202396733,202204186,202174441,202119157,202069546,202053725,201970861,201935107,201834995,201767685,201758361,201720343,201485257,201420754,201350043,201096859,201096829,201062521,201026143,201024934,201023767,201016693,200760331,200667853,200559388,200558983,200538073,200363248,200261779,200253709,200217094,200073151,200055601,200038900,200038078,200037667,199962385,199722325,199162849,199157509,198859558,198859342,198856198,198855457,198638401,198610309,198450644,198349528] · 66.68 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 [198349528,198450644,198610309,198638401,198855457,198856198,198859342,198859558,199157509,199162849,199722325,199962385,200037667,200038078,200038900,200055601,200073151,200217094,200253709,200261779,200363248,200538073,200558983,200559388,200667853,200760331,201016693,201023767,201024934,201026143,201062521,201096829,201096859,201350043,201420754,201485257,201720343,201758361,201767685,201834995,201935107,201970861,202053725,202069546,202119157,202174441,202204186,202396733,202431537,202439389] · 1.03 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] · 0.68 ms