500 ₴
BOSCH - F01M101349 ТНВД Плунжерная пара 1.3 дизель
500.0
Нікополь
Знайдено 9 913 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 2131
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 9550,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 5.17 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 ["nikopol","\/nikopol","nikopol\/","\/nikopol\/"] · 0.48 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 1.71 msSHOW TABLES · 9.3 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) [169999411,169998004,169991755,169989217,169922455,169938715,169938502,169935904,169917766,169916155,169914934,169909657,169889716,169887574,169879942,169801585,169797958,169791160,169786789,169780036,169771744,169763287,169759633,169754008,169746583,169738972,169729678,169718944,169703407,169703398,169701157,169699009,169688095,169679734,169661221,169661173,169660960,169658353,169652833,169651654,169651558,169651426,169651408,169651279,169649239,169642081,169637434,169586827,169586218,169580902] · 122.51 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 [169580902,169586218,169586827,169637434,169642081,169649239,169651279,169651408,169651426,169651558,169651654,169652833,169658353,169660960,169661173,169661221,169679734,169688095,169699009,169701157,169703398,169703407,169718944,169729678,169738972,169746583,169754008,169759633,169763287,169771744,169780036,169786789,169791160,169797958,169801585,169879942,169887574,169889716,169909657,169914934,169916155,169917766,169935904,169938502,169938715,169989217,169991755,169998004,169999411] · 2.92 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