640 ₴
Комбінезон Colambia
640.0
Гожули
Знайдено 928 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6437
}
}
]
}
},
"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 · 1.58 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 ["gojuly","\/gojuly","gojuly\/","\/gojuly\/"] · 1.07 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.37 msSHOW TABLES · 1.44 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) [212006478,211968537,211920582,211867182,211816956,211801908,211799988,211779708,211748169,211744590,211736787,211724154,211642956,211622061,211573038,211535529,211496013,211480599,211447137,211417998,211277742,211276764,211256394,211199454,211170588,211139145,211114842,211057808,211055602,211015612,210995850,210971564,210951890,210934794,210934000,210913714,210873090,210867196,210830946,210818776,210813848,210795664,210792724,210689014,210671418,210667844,210644070,210561011,210364787,210356246] · 72.19 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 [210356246,210364787,210561011,210644070,210667844,210671418,210689014,210792724,210795664,210813848,210818776,210830946,210867196,210873090,210913714,210934000,210934794,210951890,210971564,210995850,211015612,211055602,211057808,211114842,211139145,211170588,211199454,211256394,211276764,211277742,211417998,211447137,211480599,211496013,211535529,211573038,211622061,211642956,211724154,211736787,211744590,211748169,211779708,211799988,211801908,211816956,211867182,211920582,211968537,212006478] · 12.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.parent_id = ? LIMIT 3000 [5] · 0.72 ms