1 750 ₴
Водонепроникні демісезонні дитячі черевики Н&М 28
1750.0
Старый Самбор
Найдено 2 493 объявления
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3197
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 0,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.91 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.url IN (?, ?, ?, ?) LIMIT 1 ["staryy-sambor","\/staryy-sambor","staryy-sambor\/","\/staryy-sambor\/"] · 0.8 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.32 msSHOW TABLES · 6.37 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, ''), NULLIF(c.name_ua, '')) 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) [220021790,219986850,219942678,219813318,219812450,219717554,219694410,219685306,219682570,219627170,219585142,219574471,219551899,219529213,219463750,219415804,219366334,219353950,219324907,219312511,219196427,219156848,219155906,219115220,219103628,218996567,218981972,218965721,218939321,218937623,218934575,218909024,218801753,218764241,218766659,218757953,218730719,218721830,218716634,218654321,218651003,218625611,218621339,218614433,218595137,218588537,218532443,218531753,218486282,218483093] · 60.15 msSELECT v.post_id, v.attribute_id, v.value, COALESCE(NULLIF(a.name, ''), NULLIF(a.name_ua, '')) 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 [218483093,218486282,218531753,218532443,218588537,218595137,218614433,218621339,218625611,218651003,218716634,218721830,218730719,218757953,218766659,218801753,218909024,218934575,218937623,218939321,218965721,218981972,218996567,219103628,219115220,219155906,219156848,219196427,219312511,219324907,219353950,219366334,219415804,219463750,219529213,219551899,219574471,219585142,219627170,219682570,219685306,219694410,219717554,219812450,219813318,219942678,219986850,220021790] · 17.44 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.parent_id = ? LIMIT 3000 [5] · 10.67 ms