370 ₴
Кросівки дитячі 24 розмір
370.0
Товсте
Знайдено 369 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 7017
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 300,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 6.34 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 ["tolstoe","\/tolstoe","tolstoe\/","\/tolstoe\/"] · 13.07 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 4.51 msSHOW TABLES · 1.47 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) [186088788,186041205,185982135,185365725,185026122,184534366,184198776,184174380,183713610,183408129,183188280,183003672,182972598,182214823,182047501,182020471,182020462,182005903,181497376,181140295,180861694,180785956,179846089,179520262,179468599,179388895,179276530,179188162,178830730,178662754,178273050,178081479,177649003,177586144,177481027,177155327,177113599,177063583,176990341,176879158,176610549,176336757,175991121,175866990,175707046,175542224,175377147,175224277,174983449,174391870] · 154.44 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 [174391870,174983449,175224277,175377147,175542224,175707046,175866990,175991121,176336757,176610549,176879158,176990341,177063583,177113599,177155327,177481027,177586144,177649003,178081479,178273050,178662754,178830730,179188162,179276530,179388895,179468599,179520262,179846089,180785956,180861694,181140295,181497376,182005903,182020462,182020471,182047501,182214823,182972598,183003672,183188280,183408129,183713610,184174380,184198776,184534366,185026122,185365725,185982135,186041205,186088788] · 1.46 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] · 3.07 ms