1 100 ₴
Щеплення двохмассове на Ніссан кашкай
1100.0
Чигирин
Знайдено 1 530 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3372
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 450,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.45 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 ["chigirin","\/chigirin","chigirin\/","\/chigirin\/"] · 1.75 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.49 msSHOW TABLES · 0.56 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) [213840435,213823983,213821208,213820677,213814362,213770910,213763470,213754614,213724053,213665361,213663045,213658143,213651294,213624570,213562098,213557334,213519690,213456165,213443691,213442005,213439959,213394797,213393726,213381645,213377424,213375510,213288198,213248490,213235506,213229251,213223413,213169701,213127506,213125934,213102756,213080235,213036000,212983566,212956134,212914029,212896011,212873625,212799438,212732520,212717115,212700057,212685486,212668071,212658090,212648184] · 27.02 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 [212648184,212658090,212668071,212685486,212700057,212717115,212732520,212799438,212873625,212896011,212914029,212956134,212983566,213036000,213080235,213102756,213125934,213127506,213169701,213223413,213229251,213235506,213248490,213288198,213375510,213377424,213381645,213393726,213394797,213439959,213442005,213443691,213456165,213519690,213557334,213562098,213624570,213651294,213658143,213663045,213665361,213754614,213763470,213770910,213814362,213820677,213821208,213823983,213840435] · 16.61 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.64 ms