123 ₴
Шапка для хлопчика
123.0
Шостка
Знайдено 17 553 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 2203
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 2150,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.99 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 ["shostka","\/shostka","shostka\/","\/shostka\/"] · 0.45 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.17 msSHOW TABLES · 1.81 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) [216764341,216754480,216753853,216753079,216741448,216740467,216738295,216736648,216734875,216734425,216733876,216727528,216726331,216725140,216721765,216721651,216720697,216715297,216714850,216713848,216713740,216712684,216708064,216707038,216705313,216704695,216703618,216703120,216700195,216699007,216698689,216697609,216695554,216695545,216685105,216681292,216675685,216675529,216675313,216674566,216673258,216669421,216669253,216668599,216668491,216667981,216667408,216667099,216663022,216662794] · 33.76 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 [216662794,216663022,216667099,216667408,216667981,216668491,216668599,216669253,216669421,216673258,216674566,216675313,216675529,216675685,216681292,216685105,216695545,216695554,216697609,216698689,216699007,216700195,216703120,216703618,216704695,216705313,216707038,216708064,216712684,216713740,216713848,216714850,216715297,216720697,216721651,216721765,216725140,216726331,216727528,216733876,216734425,216734875,216736648,216738295,216740467,216741448,216753079,216753853,216754480,216764341] · 30.79 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] · 4.07 ms