165 ₴
Датчик давления масла (1-о контактный)
165.0
Марганець
Знайдено 2 570 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3137
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 1700,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 0.93 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 ["marganec","\/marganec","marganec\/","\/marganec\/"] · 2.2 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.68 msSHOW TABLES · 0.66 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) [193905152,193891715,193889933,193883210,193853960,193821662,193821506,193791695,193779257,193772909,193764251,193756106,193753502,193752599,193701506,193652831,193625132,193609034,193539220,193529875,193503769,193480204,193479427,193463290,193448806,193448800,193420942,193403227,193395226,193382899,193365295,193350617,193340879,193339829,193331869,193300585,193220275,193056019,193055717,193016758,192970039,192969958,192944209,192896452,192896431,192875110,192812944,192806911,192792838,192792247] · 63.15 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 [192792247,192792838,192806911,192812944,192875110,192896431,192896452,192944209,192969958,192970039,193016758,193055717,193056019,193220275,193300585,193331869,193339829,193340879,193350617,193365295,193382899,193395226,193403227,193420942,193448800,193448806,193463290,193479427,193480204,193503769,193529875,193539220,193609034,193625132,193652831,193701506,193752599,193753502,193756106,193764251,193772909,193779257,193791695,193821506,193821662,193853960,193883210,193889933,193891715,193905152] · 1.29 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.27 ms