100 $
Фара таурег 1/taureg 1 дорест
4400.0
Лебедин
Знайдено 3 764 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3470
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 1250,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.18 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 ["lebedin","\/lebedin","lebedin\/","\/lebedin\/"] · 3.09 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.42 msSHOW TABLES · 0.38 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) [209981348,209981021,209980487,209975648,209956292,209956271,209939576,209937098,209926604,209917484,209910509,209896769,209881973,209866685,209862971,209860301,209859632,209851433,209834420,209827574,209808248,209786873,209784737,209770829,209757035,209751419,209750438,209748314,209731604,209723882,209690243,209683295,209677142,209657598,209653044,209652609,209652408,209633670,209632917,209630943,209625153,209614378,209587195,209585800,209585764,209581528,209565751,209562877,209559928,209549860] · 46.7 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 [209549860,209559928,209562877,209565751,209581528,209585764,209585800,209587195,209614378,209625153,209630943,209632917,209633670,209652408,209652609,209653044,209657598,209677142,209683295,209690243,209723882,209731604,209748314,209750438,209751419,209757035,209770829,209784737,209786873,209808248,209827574,209834420,209851433,209859632,209860301,209862971,209866685,209881973,209896769,209910509,209917484,209926604,209937098,209939576,209956271,209956292,209975648,209980487,209981021,209981348] · 11.23 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.55 ms