| # | SQL | Args | Time | Status |
|---|
| 1 | SELECT * FROM %n WHERE `deleted_at` IS NULL AND `is_active` = %i AND `status` IN %in AND `published_at` <= %s AND `published_at` IS NOT NULL | "properties_listings", 1, [array(4)], "2026-11-06 15:11:51" | 3.06 ms | OK |
| 2 | SELECT COUNT(*) AS aggregate FROM %n WHERE `deleted_at` IS NULL AND `is_active` = %i AND `status` IN %in AND `published_at` <= %s AND `published_at` IS NOT NULL ORDER BY CASE WHEN status = 'active' THEN 0 ELSE 1 END ASC, `published_at` DESC | "properties_listings", 1, [array(4)], "2026-11-06 15:11:51" | 0.31 ms | OK |
| 3 | SELECT * FROM %n WHERE `deleted_at` IS NULL AND `is_active` = %i AND `status` IN %in AND `published_at` <= %s AND `published_at` IS NOT NULL ORDER BY CASE WHEN status = 'active' THEN 0 ELSE 1 END ASC, `published_at` DESC LIMIT %i OFFSET %i | "properties_listings", 1, [array(4)], "2026-11-06 15:11:51", 12, 0 | 0.5 ms | OK |
| 4 | SELECT DISTINCT transaction_type AS k, transaction_type AS v FROM properties_listings WHERE id IN %in AND transaction_type IS NOT NULL | [array(1)] | 0.35 ms | OK |
| 5 | SELECT DISTINCT category_id AS k, category_id AS v FROM properties_listings WHERE id IN %in AND category_id IS NOT NULL | [array(1)] | 0.23 ms | OK |
| 6 | SELECT id, parent_id FROM properties_categories WHERE is_active = 1 | none | 1.11 ms | OK |
| 7 | SELECT DISTINCT location_id AS k, location_id AS v FROM properties_listings WHERE id IN %in AND location_id IS NOT NULL | [array(1)] | 0.22 ms | OK |
| 8 | SELECT id, parent_id FROM properties_locations WHERE is_active = 1 | none | 0.73 ms | OK |
| 9 | SELECT DISTINCT filter_id AS k, filter_id AS v FROM properties_listing_filters WHERE listing_id IN %in | [array(1)] | 0.78 ms | OK |
| 10 | SELECT DISTINCT rooms AS k, rooms AS v FROM properties_listings WHERE id IN %in AND rooms IS NOT NULL | [array(1)] | 0.26 ms | OK |
| 11 | SELECT DISTINCT category_id AS k, category_id AS v FROM properties_listings WHERE is_active = 1 AND status IN ('active','reserved','sold','rented') AND published_at <= %s AND published_at IS NOT NULL AND category_id IS NOT NULL | "2026-11-06 15:11:51" | 0.61 ms | OK |
| 12 | SELECT DISTINCT location_id AS k, location_id AS v FROM properties_listings WHERE is_active = 1 AND status IN ('active','reserved','sold','rented') AND published_at <= %s AND published_at IS NOT NULL AND location_id IS NOT NULL | "2026-11-06 15:11:51" | 0.41 ms | OK |
| 13 | SELECT DISTINCT f.filter_id AS k, f.filter_id AS v FROM properties_listing_filters f JOIN properties_listings l ON l.id = f.listing_id WHERE l.is_active = 1 AND status IN ('active','reserved','sold','rented') AND published_at <= %s AND published_at IS NOT NULL | "2026-11-06 15:11:51" | 0.29 ms | OK |
| 14 | SELECT id, parent_id FROM properties_categories WHERE is_active = 1 | none | 0.26 ms | OK |
| 15 | SELECT id, parent_id FROM properties_locations WHERE is_active = 1 | none | 0.19 ms | OK |
| 16 | SELECT * FROM %n WHERE `deleted_at` IS NULL AND `is_active` = %i AND `parent_id` IS NULL ORDER BY `sort_order` ASC, `title` ASC | "properties_categories", 1 | 0.69 ms | OK |
| 17 | SELECT * FROM %n WHERE `deleted_at` IS NULL AND `is_active` = %i ORDER BY `sort_order` ASC, `title` ASC | "properties_categories", 1 | 0.47 ms | OK |
| 18 | SELECT * FROM %n WHERE `is_active` = %i ORDER BY `sort_order` ASC, `name` ASC | "properties_locations", 1 | 0.26 ms | OK |
| 19 | SELECT * FROM %n WHERE `is_active` = %i AND `type` = %s LIMIT %i | "properties_locations", 1, "country", 1 | 0.37 ms | OK |
| 20 | SELECT * FROM %n WHERE `is_active` = %i AND `parent_id` IS NULL ORDER BY `sort_order` ASC, `title` ASC | "properties_filters", 1 | 0.96 ms | OK |
| 21 | SELECT * FROM %n WHERE `is_active` = %i AND `parent_id` = %i ORDER BY `sort_order` ASC, `title` ASC | "properties_filters", 1, 38 | 0.34 ms | OK |
| 22 | SELECT * FROM %n WHERE `is_active` = %i AND `parent_id` = %i ORDER BY `sort_order` ASC, `title` ASC | "properties_filters", 1, 45 | 0.34 ms | OK |
| 23 | SELECT k, v FROM settings | none | 1.18 ms | OK |
Predaj