200 ₴
Швейна машинка "Чайка-2"
200.0
Фастів
Знайдено 11 589 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 2168
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 2450,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.01 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 ["fastov","\/fastov","fastov\/","\/fastov\/"] · 0.37 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.15 msSHOW TABLES · 0.5 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) [213662832,213662298,213658959,213633336,213628914,213624993,213623826,213623181,213618219,213617430,213611001,213608028,213607758,213607059,213605736,213602598,213601401,213600495,213589875,213588027,213587994,213586920,213586710,213584979,213562086,213554679,213554643,213552858,213551955,213549450,213549294,213548949,213548289,213548151,213541665,213541257,213540564,213540153,213539847,213539751,213539055,213538971,213536661,213536292,213534699,213530016,213528243,213528063,213528051,213524991] · 105.49 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 [213524991,213528051,213528063,213528243,213530016,213534699,213536292,213536661,213538971,213539055,213539751,213539847,213540153,213540564,213541257,213541665,213548151,213548289,213548949,213549294,213549450,213551955,213552858,213554643,213554679,213562086,213584979,213586710,213586920,213587994,213588027,213589875,213600495,213601401,213602598,213605736,213607059,213607758,213608028,213611001,213617430,213618219,213623181,213623826,213624993,213628914,213633336,213658959,213662298,213662832] · 26.64 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.05 ms