650 ₴
Додаткові фари з лампами
650.0
Новий Буг
Знайдено 1 914 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3406
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 1400,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.65 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 ["novyy-bug","\/novyy-bug","novyy-bug\/","\/novyy-bug\/"] · 0.96 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.77 msSHOW TABLES · 0.83 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) [187603089,187582512,187581258,187487043,187485207,187472865,187471737,187463979,187372611,187342838,187340484,187309623,187293735,187284867,187237392,187219809,187216839,187213668,187205328,187184256,187124931,187118769,187097403,187088967,187081296,187072470,187051695,187045530,187038969,187032222,186872856,186857112,186807069,186780990,186774657,186652218,186621717,186613368,186580284,186511827,186497997,186359097,186322338,186292692,186292689,186219452,186212750,186210230,186131172,186103738] · 27.01 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 [186103738,186131172,186210230,186212750,186219452,186292689,186292692,186322338,186359097,186497997,186511827,186580284,186613368,186621717,186652218,186774657,186780990,186807069,186857112,186872856,187032222,187038969,187045530,187051695,187072470,187081296,187088967,187097403,187118769,187124931,187184256,187205328,187213668,187216839,187219809,187237392,187284867,187293735,187309623,187340484,187342838,187372611,187463979,187471737,187472865,187485207,187487043,187581258,187582512,187603089] · 1.35 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] · 1.12 ms