Договірна
Танцы для взрослых Измаил
0.0
Ізмаїл
Знайдено 12 011 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 2190
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 8300,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.63 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 ["izmail","\/izmail","izmail\/","\/izmail\/"] · 1.09 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 2.51 msSHOW TABLES · 0.49 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) [191952136,191947927,191907127,191861470,191853124,191825563,191825299,191821792,191821705,191821351,191812825,191810284,191797507,191797099,191793856,191788642,191770411,191767957,191764864,191758405,191758288,191755240,191753401,191750041,191747554,191743063,191742256,191741434,191741245,191740276,191740126,191731201,191729779,191729560,191729182,191728930,191728165,191728162,191727256,191726710,191726413,191726293,191726272,191725885,191725723,191725537,191724499,191720167,191715997,191711662] · 84.45 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 [191711662,191715997,191720167,191724499,191725537,191725723,191725885,191726272,191726293,191726413,191726710,191727256,191728162,191728165,191728930,191729182,191729560,191729779,191731201,191740126,191740276,191741245,191741434,191742256,191743063,191747554,191750041,191753401,191755240,191758288,191758405,191764864,191767957,191770411,191788642,191793856,191797099,191797507,191810284,191812825,191821351,191821705,191821792,191825299,191825563,191853124,191861470,191907127,191947927,191952136] · 1.32 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