899 $
Spark SP 200R-27 ni
2 000 км 39556.0
Товсте
Знайдено 369 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 7017
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 150,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 6.39 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 ["tolstoe","\/tolstoe","tolstoe\/","\/tolstoe\/"] · 0.96 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.68 msSHOW TABLES · 0.76 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) [207621925,207584557,207564706,207520120,207505954,207289156,206879111,205837922,205781687,205745876,205706519,205581413,205203374,204935258,204930338,204753335,204672518,204573728,204542657,204493268,204432575,204252522,204101850,203960565,203914911,203896176,203890497,203841807,203757663,203709791,203709440,203443940,203388461,203383019,203314526,203265470,203019034,202944047,202884712,202811887,202773481,202703590,202530337,201893423,201859381,201752143,201684281,201671807,201652507,201622147] · 28.67 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 [201622147,201652507,201671807,201684281,201752143,201859381,201893423,202530337,202703590,202773481,202811887,202884712,202944047,203019034,203265470,203314526,203383019,203388461,203443940,203709440,203709791,203757663,203841807,203890497,203896176,203914911,203960565,204101850,204252522,204432575,204493268,204542657,204573728,204672518,204753335,204930338,204935258,205203374,205581413,205706519,205745876,205781687,205837922,206879111,207289156,207505954,207520120,207564706,207584557,207621925] · 3.27 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.95 ms