60 ₴
Кепка для дівчинки Cropp
60.0
Звенигородка
Знайдено 4 907 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3360
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 3550,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.47 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 ["zvenigorodka","\/zvenigorodka","zvenigorodka\/","\/zvenigorodka\/"] · 1.02 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.67 msSHOW TABLES · 1.08 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) [189085299,189085263,189085161,189039921,189029922,189013557,189007593,188953731,188935830,188918226,188912571,188890137,188888589,188880681,188867259,188864388,188815329,188787936,188766852,188766714,188762367,188746206,188711658,188666301,188666025,188621565,188621328,188618112,188613966,188549265,188548554,188537973,188535201,188522043,188492769,188479038,188471874,188471772,188462853,188459970,188445735,188368218,188360157,188350185,188319489,188311566,188303151,188296920,188296572,188292300] · 69.34 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 [188292300,188296572,188296920,188303151,188311566,188319489,188350185,188360157,188368218,188445735,188459970,188462853,188471772,188471874,188479038,188492769,188522043,188535201,188537973,188548554,188549265,188613966,188618112,188621328,188621565,188666025,188666301,188711658,188746206,188762367,188766714,188766852,188787936,188815329,188864388,188867259,188880681,188888589,188890137,188912571,188918226,188935830,188953731,189007593,189013557,189029922,189039921,189085161,189085263,189085299] · 1.7 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.92 ms