Квартираҳо

Ёфт шуд: 0

Биноҳои нав Бозори дуюмин Ҳуҷраҳо

Филтрҳо

Ёфтан

Ҳама Фурӯш Иҷора

Нарх

Масоҳат, м²

Таъмир

Бо мебел

Бозсозӣ

Чизе ёфт нашуд

Бозсозӣ

DEBUG · 8.2 ms · 2 MB · SQL 2 (2.5 ms) · PHP 8.2.35 · v1.2.0

1.23 ms

SELECT COUNT(*) FROM ads a WHERE a.status = 'active' AND a.category_id IN (?,?,?,?) AND a.city_id = ?

1.31 ms

SELECT a.id, a.user_id, a.company_id, a.category_id, a.city_id, a.deal_type, a.title, a.slug, a.price, a.currency, a.price_period, a.area, a.rooms, a.floor, a.floors_total, a.address, a.main_image, a.images_count, a.top_until, a.vip_until, a.urgent_until, a.raised_at, a.created_at, a.views, a.status FROM ads a WHERE a.status = 'active' AND a.category_id IN (?,?,?,?) AND a.city_id = ? ORDER BY a.sort_at DESC, a.id DESC LIMIT ? OFFSET ?