530 ₴
Дитяча куртка RESERVED 6-7 років
530.0
Трускавець
Знайдено 11 652 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3198
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 2700,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 95.91 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\/"] · 3.74 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 3.55 msSHOW TABLES · 24.85 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) [210652372,210640062,210639810,210637890,210636126,210635754,210630678,210630656,210630556,210629034,210626958,210626456,210624842,210624586,210624442,210623662,210620864,210608687,210599582,210578147,210577061,210565706,210564965,210558812,210546389,210545366,210540656,210537776,210534479,210526562,210525998,210524873,210521726,210506456,210504587,210503501,210495896,210492263,210491207,210490811,210490328,210489788,210487715,210481814,210481787,210480008,210475679,210475148,210473174,210466904] · 99.86 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 [210466904,210473174,210475148,210475679,210480008,210481787,210481814,210487715,210489788,210490328,210490811,210491207,210492263,210495896,210503501,210504587,210506456,210521726,210524873,210525998,210526562,210534479,210537776,210540656,210545366,210546389,210558812,210564965,210565706,210577061,210578147,210599582,210608687,210620864,210623662,210624442,210624586,210624842,210626456,210626958,210629034,210630556,210630656,210630678,210635754,210636126,210637890,210639810,210640062,210652372] · 151.39 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] · 5.37 ms