2 150 $
Geon gns 300 motard
94600.0
Ніжин
Знайдено 14 874 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 2221
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 1700,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 3.87 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 ["nejin","\/nejin","nejin\/","\/nejin\/"] · 0.95 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.4 msSHOW TABLES · 1.32 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) [216365875,216358810,216357832,216357454,216357385,216353761,216353518,216351631,216350380,216344140,216343744,216343738,216341491,216340198,216339853,216337024,216336670,216332956,216332512,216328489,216327448,216326305,216324283,216321274,216320389,216314986,216314611,216314434,216312952,216312727,216312394,216310411,216309922,216298204,216297148,216294214,216293365,216287005,216286126,216283600,216283135,216282988,216279733,216275320,216274681,216274591,216273649,216273484,216271885,216269599] · 50.43 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 [216269599,216271885,216273484,216273649,216274591,216274681,216275320,216279733,216282988,216283135,216283600,216286126,216287005,216293365,216294214,216297148,216298204,216309922,216310411,216312394,216312727,216312952,216314434,216314611,216314986,216320389,216321274,216324283,216326305,216327448,216328489,216332512,216332956,216336670,216337024,216339853,216340198,216341491,216343738,216343744,216344140,216350380,216351631,216353518,216353761,216357385,216357454,216357832,216358810,216365875] · 23.6 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.01 ms