3 800 $
Toyota Camry
167200.0
Ізмаїл
Знайдено 11 982 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 2190
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 5700,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 13.83 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.55 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.34 msSHOW TABLES · 0.46 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) [202211902,202211890,202210867,202203853,202203724,202203697,202191574,202184053,202184005,202183288,202182190,202177516,202174501,202173997,202164757,202163095,202157596,202151725,202145548,202145005,202144483,202138342,202137631,202137574,202134844,202127518,202127506,202127476,202127386,202127284,202127269,202127248,202127152,202123027,202120231,202069069,202065802,202063235,202062315,202059979,202056269,202055843,202053337,202051811,202051059,202050316,202038745,202037998,202037905,202033636] · 35.48 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 [202033636,202037905,202037998,202038745,202050316,202051059,202051811,202053337,202055843,202056269,202059979,202062315,202063235,202065802,202069069,202120231,202123027,202127152,202127248,202127269,202127284,202127386,202127476,202127506,202127518,202134844,202137574,202137631,202138342,202144483,202145005,202145548,202151725,202157596,202163095,202164757,202173997,202174501,202177516,202182190,202183288,202184005,202184053,202191574,202203697,202203724,202203853,202210867,202211890,202211902] · 2.58 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.13 ms