233 $
ГБЦ Головка блока цилиндров Нова VW Polo Golf Caddy Beetle Skoda Audi 1.9TDI Гарантія 1 рік 908703
10252.0
Кременець
Знайдено 7 992 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3483
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 900,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 3.46 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 ["kremenec","\/kremenec","kremenec\/","\/kremenec\/"] · 1.63 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 12.11 msSHOW TABLES · 1.86 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) [214988832,214988301,214987083,214985691,214978125,214976943,214959291,214959051,214957317,214957308,214955007,214938546,214937469,214937289,214935291,214935099,214935078,214935051,214933377,214932684,214931874,214914942,214913898,214907548,214907234,214891616,214906860,214902576,214901544,214901174,214900992,214900288,214899706,214899094,214897712,214897046,214893582,214891648,214887456,214881640,214878322,214875140,214874034,214861923,214839177,214836228,214829364,214829067,214825752,214818216] · 27.71 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 [214818216,214825752,214829067,214829364,214836228,214839177,214861923,214874034,214875140,214878322,214881640,214887456,214891648,214893582,214897046,214897712,214899094,214899706,214900288,214900992,214901174,214901544,214902576,214906860,214907234,214907548,214913898,214914942,214931874,214932684,214933377,214935051,214935078,214935099,214935291,214937289,214937469,214938546,214955007,214957308,214957317,214959051,214959291,214976943,214978125,214985691,214987083,214988301,214988832] · 11.04 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.06 ms