684 ₴
ТАТ. (стимульний матеріал та інструкція).
684.0
Ромни
Знайдено 10 445 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 2994
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 9100,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 15.14 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 ["romny","\/romny","romny\/","\/romny\/"] · 4.74 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.34 msSHOW TABLES · 0.56 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) [178595602,178573870,178568002,178567963,178562689,178560520,178528015,178527970,178500505,178480747,178480726,178458655,178437640,178432311,178422613,178413479,178365525,178271229,178261113,178257999,178256787,178253979,178241589,178240773,178200276,178177665,178177104,178176072,178144467,178129761,178123506,178123485,178112547,178101861,178080282,178076886,178075032,178073178,178071411,178071252,178069623,178063371,178061703,178050330,178044060,178043787,178037793,178037040,178034679,178030764] · 85.13 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 [178030764,178034679,178037040,178037793,178043787,178044060,178050330,178061703,178063371,178069623,178071252,178071411,178073178,178075032,178076886,178080282,178101861,178112547,178123485,178123506,178129761,178144467,178176072,178177104,178177665,178200276,178240773,178241589,178253979,178256787,178257999,178261113,178271229,178365525,178413479,178422613,178432311,178437640,178458655,178480726,178480747,178500505,178527970,178528015,178560520,178562689,178567963,178568002,178573870,178595602] · 2.49 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.61 ms