6 350 $
Nissan Leaf
279400.0
Хотин
Знайдено 2 926 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3553
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 2200,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.97 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 ["hotin","\/hotin","hotin\/","\/hotin\/"] · 2 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 1.11 msSHOW TABLES · 0.75 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) [183732269,183713247,183695262,183689298,183678879,183547953,183531141,183509736,183498567,183446367,183445380,183432690,183414468,183414462,183403566,183402147,183339603,183337820,183331109,183328238,183318166,183316315,183301230,183292986,183288219,183282927,183279328,183258146,183257952,183255755,183250132,183242433,183197502,183197352,183197346,183195522,183195033,183192747,183176145,183164526,183155397,183154344,183153816,183153174,183151674,183151617,183106290,183091050,183089964,183071301] · 40.1 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 [183071301,183089964,183091050,183106290,183151617,183151674,183153174,183153816,183154344,183155397,183164526,183176145,183192747,183195033,183195522,183197346,183197352,183197502,183242433,183250132,183255755,183257952,183258146,183279328,183282927,183288219,183292986,183301230,183316315,183318166,183328238,183331109,183337820,183339603,183402147,183403566,183414462,183414468,183432690,183445380,183446367,183498567,183509736,183531141,183547953,183678879,183689298,183695262,183713247,183732269] · 2.09 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.83 ms