230 ₴
Дитячі утеплені гумові чоботи для хлопчика Realpaks SD-2/2 29-30 Оливкові
230.0
Ізмаїл
Знайдено 11 971 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 2190
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 3350,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 5.77 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 ["izmail","\/izmail","izmail\/","\/izmail\/"] · 0.45 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.29 msSHOW TABLES · 0.4 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) [210312338,210310844,210310835,210310709,210310706,210310613,210310607,210310574,210306518,210305807,210304871,210304856,210303170,210300101,210300095,210299312,210298610,210292793,210286553,210285536,210279476,210278936,210274664,210274418,210273935,210273671,210267974,210266936,210266378,210265673,210265559,210260204,210256298,210256244,210245780,210240965,210240569,210231782,210230624,210230498,210230288,210229478,210228761,210221744,210217208,210196652,210195080,210194591,210186140,210182033] · 38.09 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 [210182033,210186140,210194591,210195080,210196652,210217208,210221744,210228761,210229478,210230288,210230498,210230624,210231782,210240569,210240965,210245780,210256244,210256298,210260204,210265559,210265673,210266378,210266936,210267974,210273671,210273935,210274418,210274664,210278936,210279476,210285536,210286553,210292793,210298610,210299312,210300095,210300101,210303170,210304856,210304871,210305807,210306518,210310574,210310607,210310613,210310706,210310709,210310835,210310844,210312338] · 31.68 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.69 ms