6 800 ₴
Акумулятор Powermat VRLA AGM 12V 100Ah
6800.0
Трускавець
Знайдено 11 694 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3198
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 6350,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2 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 ["truskavec","\/truskavec","truskavec\/","\/truskavec\/"] · 2.16 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 1.34 msSHOW TABLES · 0.93 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) [198064105,198062771,198061369,198058707,198051587,198051585,198051583,198051581,198051579,198051577,198050943,198049389,198043799,198042451,198035056,198026191,198024760,198016051,198016031,198015585,198015565,198011665,198005509,198004870,197999215,197998939,197997544,197996731,197995234,197990674,197989467,197986431,197983189,197979172,197976484,197969167,197967427,197965642,197958247,197957971,197956432,197954194,197950276,197940112,197938969,197937457,197935231,197930488,197928577,197928397] · 46.46 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 [197928397,197928577,197930488,197935231,197937457,197938969,197940112,197950276,197954194,197956432,197957971,197958247,197965642,197967427,197969167,197976484,197979172,197983189,197986431,197989467,197990674,197995234,197996731,197997544,197998939,197999215,198004870,198005509,198011665,198015565,198015585,198016031,198016051,198024760,198026191,198035056,198042451,198043799,198049389,198050943,198051577,198051579,198051581,198051583,198051585,198051587,198058707,198061369,198062771,198064105] · 0.94 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] · 0.66 ms