350 ₴
Аккумулятор GDLITE GD-645 (6V 4.0Ah)
350.0
Марганець
Знайдено 2 573 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3137
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 2250,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.5 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\/"] · 0.69 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.29 msSHOW TABLES · 2.7 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) [178953826,178908430,178907062,178907059,178900546,178873705,178806835,178767340,178741117,178712728,178658749,178604941,178538536,178411783,178381635,178375320,178349115,178330083,178290678,178272825,178272021,178225440,178124109,178074894,178043943,178000629,177965895,177949551,177921138,177826587,177780412,177618280,177616621,177575182,177575134,177564610,177558097,177526501,177509002,177502735,177461259,177439233,177334975,177263279,177262421,177250903,177232155,177202927,177202923,176936296] · 109.07 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 [176936296,177202923,177202927,177232155,177250903,177262421,177263279,177334975,177439233,177461259,177502735,177509002,177526501,177558097,177564610,177575134,177575182,177616621,177618280,177780412,177826587,177921138,177949551,177965895,178000629,178043943,178074894,178124109,178225440,178272021,178272825,178290678,178330083,178349115,178375320,178381635,178411783,178538536,178604941,178658749,178712728,178741117,178767340,178806835,178873705,178900546,178907059,178907062,178908430,178953826] · 0.99 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] · 0.7 ms