1 600 ₴
ПОЛУОСЬ правая передняя VW Tiguan 2009 г/в
1600.0
Подільськ
Знайдено 3 581 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6171
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 100,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 5.77 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 ["podolsk","\/podolsk","podolsk\/","\/podolsk\/"] · 18.97 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 39.41 msSHOW TABLES · 0.44 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) [218980001,218969453,218964752,218944424,218943104,218940818,218928251,218904866,218898182,218896361,218894597,218878043,218877533,218871806,218871341,218870810,218864249,218839637,218820143,218816318,218802350,218784446,218779787,218761295,218757959,218745116,218737958,218737382,218723531,218723159,218717543,218709548,218704691,218704025,218701550,218701547,218699204,218683370,218682950,218682824,218667611,218665664,218663912,218663765,218663312,218662217,218659751,218651405,218645780,218644853] · 24.73 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 [218644853,218645780,218651405,218659751,218662217,218663312,218663765,218663912,218665664,218667611,218682824,218682950,218683370,218699204,218701547,218701550,218704025,218704691,218709548,218717543,218723159,218723531,218737382,218737958,218745116,218757959,218761295,218779787,218784446,218802350,218816318,218820143,218839637,218864249,218870810,218871341,218871806,218877533,218878043,218894597,218896361,218898182,218904866,218928251,218940818,218943104,218944424,218964752,218969453,218980001] · 27.47 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.7 ms