300 ₴
Молоковідсмоктувач ручний
147 000 км 300.0
Броди
Знайдено 6 863 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3179
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 2250,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 6.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 ["brody","\/brody","brody\/","\/brody\/"] · 2.42 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 1.83 msSHOW TABLES · 1.21 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) [206805523,206804035,206800347,206797989,206797405,206796847,206791598,206124017,206094803,206092697,206090264,206088260,206086979,206054156,206036294,206027333,206015804,206001251,205989980,205971557,205960871,205959968,205947344,205919810,205917344,205910198,205902974,205899431,205891157,205886831,205865108,205864301,205861145,205860965,205860686,205856249,205846505,205846238,205846046,205845683,205840541,205837307,205824056,205817399,205817069,205817024,205815539,205807445,205806332,205798517] · 32.45 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 [205798517,205806332,205807445,205815539,205817024,205817069,205817399,205824056,205837307,205840541,205845683,205846046,205846238,205846505,205856249,205860686,205860965,205861145,205864301,205865108,205886831,205891157,205899431,205902974,205910198,205917344,205919810,205947344,205959968,205960871,205971557,205989980,206001251,206015804,206027333,206036294,206054156,206086979,206088260,206090264,206092697,206094803,206124017,206791598,206796847,206797405,206797989,206800347,206804035,206805523] · 16.96 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.74 ms