| 1 | SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `cake_sessions` AS `Session` WHERE `id` = '8ad262c165592ee3fd935965986070b2' LIMIT 1 | | 1 | 1 | 0 |
| 2 | SELECT DISTINCT `Category`.`id`, `Category`.`category`, `Listing`.`id` FROM `listings` AS `Listing` LEFT JOIN `users` AS `User` ON (`Listing`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Listing`.`category_id` = `Category`.`id`) LEFT JOIN `contracts` AS `Contract` ON (`Contract`.`listing_id` = `Listing`.`id`) WHERE `Listing`.`published` = 1 AND `Listing`.`expire_date_listing` >= '2026-03-13' AND `Listing`.`under_contract` = 0 AND `Listing`.`deleted` = 0 ORDER BY `Category`.`order` ASC | | 0 | 0 | 2 |
| 3 | SELECT `Category`.`id`, `Category`.`category`, `Category`.`order` FROM `categories` AS `Category` WHERE 1 = 1 ORDER BY `Category`.`order` ASC LIMIT 4307, 24 | | 0 | 0 | 1 |
| 4 | SELECT `Link`.`id`, `Link`.`nav_id`, `Link`.`parent_id`, `Link`.`title`, `Link`.`controller`, `Link`.`action`, `Link`.`params`, `Link`.`restricted`, `Link`.`new_window`, `Link`.`editable`, `Link`.`created`, `Link`.`modified`, `Link`.`position` FROM `links` AS `Link` WHERE `Link`.`nav_id` = 2 ORDER BY `Link`.`position` ASC | | 14 | 14 | 0 |
| 5 | SELECT `Link`.`id`, `Link`.`nav_id`, `Link`.`parent_id`, `Link`.`title`, `Link`.`controller`, `Link`.`action`, `Link`.`params`, `Link`.`restricted`, `Link`.`new_window`, `Link`.`editable`, `Link`.`created`, `Link`.`modified`, `Link`.`position` FROM `links` AS `Link` WHERE `Link`.`nav_id` = 1 ORDER BY `Link`.`position` ASC | | 28 | 28 | 0 |
