400 ₴
дитячі кросівки для хлопчика adidas duramo spider-man 19 розмір
400.0
Васильков
Найдено 14 774 объявления
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3084
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 2550,
"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, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.url IN (?, ?, ?, ?) LIMIT 1 ["vasilkov","\/vasilkov","vasilkov\/","\/vasilkov\/"] · 1.83 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 1.51 msSHOW TABLES · 0.48 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, ''), NULLIF(c.name_ua, '')) 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) [214723971,214723641,214723593,214721907,214701429,214717026,214713357,214712565,214712550,214710636,214710021,214709268,214707501,214705902,214705080,214699614,214696632,214693644,214692672,214691166,214690281,214676718,214686189,214684155,214674060,214673070,214678983,214666143,214675248,214671732,214671306,214666581,214650054,214662159,214658529,214658454,214654152,214653945,214650201,214649691,214649403,214615515,214613802,214613517,214636986,214634418,214621953,214604814,214604145,214603644] · 15.03 msSELECT v.post_id, v.attribute_id, v.value, COALESCE(NULLIF(a.name, ''), NULLIF(a.name_ua, '')) 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 [214621953,214634418,214636986,214649403,214649691,214650201,214653945,214654152,214658454,214658529,214662159,214666581,214671306,214671732,214675248,214678983,214684155,214686189,214690281,214691166,214692672,214693644,214696632,214699614,214705080,214705902,214707501,214709268,214710021,214710636,214712550,214712565,214713357,214717026,214721907,214723593,214723641,214723971] · 7.05 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.parent_id = ? LIMIT 3000 [5] · 0.69 ms