2 100 $
ВАЗ / Lada 2107
92400.0
Рокитне
Знайдено 5 987 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3505
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 5550,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 5.19 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 ["rokitnoe","\/rokitnoe","rokitnoe\/","\/rokitnoe\/"] · 0.98 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.97 msSHOW TABLES · 1.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) [172134808,172077115,172076647,172050583,172049638,172048129,172046422,172045123,172041913,172030375,172022788,172022287,172022104,172011985,171980473,171957259,171955237,171932875,171902338,171901858,171878818,171878500,171870313,171868708,171857230,171842242,171832366,171826309,171811714,171798433,171764698,171758305,171727039,171722383,171698686,171667900,171664027,171658102,171636430,171626662,171623638,171564016,171540235,171516292,171452890,171441307,171396361,171391339,171389170,171380053] · 104.08 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 [171380053,171389170,171391339,171396361,171441307,171452890,171516292,171540235,171564016,171623638,171626662,171636430,171658102,171664027,171667900,171698686,171722383,171727039,171758305,171764698,171798433,171811714,171826309,171832366,171842242,171857230,171868708,171870313,171878500,171878818,171901858,171902338,171932875,171955237,171957259,171980473,172011985,172022104,172022287,172022788,172030375,172041913,172045123,172046422,172048129,172049638,172050583,172076647,172077115,172134808] · 0.98 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] · 2.18 ms