| # | 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-06-02 15:57:10" | 4.28 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 = 039;active039; THEN 0 ELSE 1 END ASC, `published_at` DESC | "properties_listings", 1, [array(4)], "2026-06-02 15:57:10" | 0.32 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 = 039;active039; THEN 0 ELSE 1 END ASC, `published_at` DESC LIMIT %i OFFSET %i | "properties_listings", 1, [array(4)], "2026-06-02 15:57:10", 12, 0 | 0.46 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(2)] | 0.38 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(2)] | 0.4 ms | OK |
| 6 | SELECT id, parent_id FROM properties_categories WHERE is_active = 1 | none | 0.79 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(2)] | 0.38 ms | OK |
| 8 | SELECT id, parent_id FROM properties_locations WHERE is_active = 1 | none | 0.82 ms | OK |
| 9 | SELECT DISTINCT filter_id AS k, filter_id AS v FROM properties_listing_filters WHERE listing_id IN %in | [array(2)] | 0.68 ms | OK |
| 10 | SELECT DISTINCT rooms AS k, rooms AS v FROM properties_listings WHERE id IN %in AND rooms IS NOT NULL | [array(2)] | 0.4 ms | OK |
| 11 | SELECT DISTINCT category_id AS k, category_id AS v FROM properties_listings WHERE is_active = 1 AND status IN (039;active039;,039;reserved039;,039;sold039;,039;rented039;) AND published_at <= %s AND published_at IS NOT NULL AND category_id IS NOT NULL | "2026-06-02 15:57:10" | 0.34 ms | OK |
| 12 | SELECT DISTINCT location_id AS k, location_id AS v FROM properties_listings WHERE is_active = 1 AND status IN (039;active039;,039;reserved039;,039;sold039;,039;rented039;) AND published_at <= %s AND published_at IS NOT NULL AND location_id IS NOT NULL | "2026-06-02 15:57:10" | 0.27 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 (039;active039;,039;reserved039;,039;sold039;,039;rented039;) AND published_at <= %s AND published_at IS NOT NULL | "2026-06-02 15:57:10" | 0.29 ms | OK |
| 14 | SELECT id, parent_id FROM properties_categories WHERE is_active = 1 | none | 0.24 ms | OK |
| 15 | SELECT id, parent_id FROM properties_locations WHERE is_active = 1 | none | 0.21 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.63 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.46 ms | OK |
| 18 | SELECT * FROM %n WHERE `is_active` = %i ORDER BY `sort_order` ASC, `name` ASC | "properties_locations", 1 | 0.29 ms | OK |
| 19 | SELECT * FROM %n WHERE `is_active` = %i AND `type` = %s LIMIT %i | "properties_locations", 1, "country", 1 | 0.46 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.84 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.41 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.31 ms | OK |
| 23 | SELECT k, v FROM settings | none | 0.9 ms | OK |
| 24 | SELECT * FROM %n WHERE `deleted_at` IS NULL AND `id` = %i LIMIT %i | "properties_categories", 28, 1 | 0.37 ms | OK |
| 25 | SELECT * FROM %n WHERE `deleted_at` IS NULL AND `id` = %i LIMIT %i | "properties_categories", 39, 1 | 0.25 ms | OK |