Sidebar

Main Menu

  • slide-1.jpg
  • slide-2.jpg
  • slide-3.jpg
  • xslide-2.jpg
  • xslide-3.jpg

For Rentals

Butlers Choice is here to find the right rental property for you. With a range of options in the Hermanus area you sure to find something you need.

Search

For Owners

If you have a property that you would like us to manage, Our team can handle the bookings and the property maintenance.

Contact Us

For Sellers

For If you have an AirBnB listing, or would like us to manage the meet and greet, hold the keys and keep the place neat and tidy.

Contact Us

Sandbaai

Sandbaai

Category properties

Explorer by Categories

Welcome to Butlers Choice

Hermanus Holiday Home Rentals A selection of quality self-catering holiday homes in and around Hermanus, selected personally for your specific needs to assure you of a hasselfree and wonderful holiday you deserve.

J! InfoRequestSessionProfileQueries106
9.009MBMemory Usage601msRequest Duration
Joomla! Version4.4.7
PHP Version8.2.27
Identityguest
Response200
Templateosprealhomes
Database
Server
mysql
Version
5.7.44-cll-lve
Collation
utf8_general_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
array:1 [ "viewtypecookie" => 1 ]
$_SERVER
array:50 [ "CONTEXT_DOCUMENT_ROOT" => "/home/butlersc/public_html" "CONTEXT_PREFIX" => "" "DOC...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743902838 "last" => 1743902838...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_webauthn
array:1 [ "returnUrl" => "https://butlerschoice.co.za/index.php/14-sandbaai" ]
  • afterLoad (713.28KB) (58.54ms)
  • afterInitialise (2.24MB) (135ms)
  • afterRoute (326.32KB) (31.33ms)
  • beforeRenderComponent com_osproperty (83.72KB) (7.63ms)
  • afterRenderComponent com_osproperty (1.41MB) (256ms)
  • afterDispatch (2.2KB) (219μs)
  • beforeRenderModule mod_custom (Footer Menu) (251.07KB) (17.14ms)
  • afterRenderRawModule mod_custom (Footer Menu) (5.6KB) (2.33ms)
  • beforeRenderModule mod_custom (Footer Menu) (720B) (10μs)
  • afterRenderModule mod_custom (Footer Menu) (120.69KB) (2.84ms)
  • beforeRenderModule mod_custom (Copyright) (584B) (76μs)
  • afterRenderRawModule mod_custom (Copyright) (976B) (93μs)
  • beforeRenderModule mod_custom (Copyright) (720B) (6μs)
  • afterRenderModule mod_custom (Copyright) (2KB) (87μs)
  • beforeRenderModule mod_ospropertyrandom (Latest Properties) (3.73KB) (54μs)
  • afterRenderRawModule mod_ospropertyrandom (Latest Properties) (161.41KB) (12.52ms)
  • beforeRenderModule mod_ospropertyrandom (Latest Properties) (736B) (14μs)
  • afterRenderModule mod_ospropertyrandom (Latest Properties) (2.45KB) (260μs)
  • beforeRenderModule mod_custom (Search by Area) (3.35KB) (75μs)
  • afterRenderRawModule mod_custom (Search by Area) (1.02KB) (111μs)
  • beforeRenderModule mod_custom (Search by Area) (720B) (6μs)
  • afterRenderModule mod_custom (Search by Area) (1.69KB) (147μs)
  • beforeRenderModule mod_custom (Contact Us) (408B) (48μs)
  • afterRenderRawModule mod_custom (Contact Us) (976B) (84μs)
  • beforeRenderModule mod_custom (Contact Us) (720B) (5μs)
  • afterRenderModule mod_custom (Contact Us) (1.75KB) (121μs)
  • beforeRenderModule mod_custom (About Butlers Choice) (408B) (46μs)
  • afterRenderRawModule mod_custom (About Butlers Choice) (1.02KB) (78μs)
  • beforeRenderModule mod_custom (About Butlers Choice) (720B) (6μs)
  • afterRenderModule mod_custom (About Butlers Choice) (1.69KB) (119μs)
  • beforeRenderModule mod_custom (Afristay Valued Member) (176B) (22μs)
  • afterRenderRawModule mod_custom (Afristay Valued Member) (1KB) (75μs)
  • beforeRenderModule mod_custom (Afristay Valued Member) (720B) (5μs)
  • afterRenderModule mod_custom (Afristay Valued Member) (3.08KB) (115μs)
  • beforeRenderModule mod_custom (Home Parralax) (1.65KB) (43μs)
  • afterRenderRawModule mod_custom (Home Parralax) (976B) (76μs)
  • beforeRenderModule mod_custom (Home Parralax) (720B) (5μs)
  • afterRenderModule mod_custom (Home Parralax) (1.69KB) (115μs)
  • beforeRenderModule mod_oscategorymenu (Explorer by Categories) (312B) (49μs)
  • afterRenderRawModule mod_oscategorymenu (Explorer by Categories) (407.16KB) (17.37ms)
  • beforeRenderModule mod_oscategorymenu (Explorer by Categories) (736B) (14μs)
  • afterRenderModule mod_oscategorymenu (Explorer by Categories) (1.83KB) (213μs)
  • beforeRenderModule mod_custom (Property Management ) (680B) (70μs)
  • afterRenderRawModule mod_custom (Property Management ) (1.02KB) (109μs)
  • beforeRenderModule mod_custom (Property Management ) (720B) (6μs)
  • afterRenderModule mod_custom (Property Management ) (1.69KB) (124μs)
  • beforeRenderModule mod_custom (For Owners) (888B) (47μs)
  • afterRenderRawModule mod_custom (For Owners) (1.02KB) (102μs)
  • beforeRenderModule mod_custom (For Owners) (720B) (6μs)
  • afterRenderModule mod_custom (For Owners) (1.69KB) (120μs)
  • beforeRenderModule mod_custom (For Rentals) (408B) (45μs)
  • afterRenderRawModule mod_custom (For Rentals) (912B) (88μs)
  • beforeRenderModule mod_custom (For Rentals) (720B) (6μs)
  • afterRenderModule mod_custom (For Rentals) (1.69KB) (116μs)
  • beforeRenderModule mod_djimageslider (FP Image Slider) (10.35KB) (71μs)
  • afterRenderRawModule mod_djimageslider (FP Image Slider) (35.79KB) (4.95ms)
  • beforeRenderModule mod_djimageslider (FP Image Slider) (720B) (8μs)
  • afterRenderModule mod_djimageslider (FP Image Slider) (1.63KB) (132μs)
  • beforeRenderModule mod_menu (Main Menu) (7.66KB) (59μs)
  • afterRenderRawModule mod_menu (Main Menu) (242.63KB) (18.04ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (20μs)
  • afterRenderModule mod_menu (Main Menu) (2.06KB) (243μs)
  • beforeRenderModule mod_jt_login (JT Login) (1.21KB) (122μs)
  • afterRenderRawModule mod_jt_login (JT Login) (84.3KB) (13.84ms)
  • beforeRenderModule mod_jt_login (JT Login) (720B) (12μs)
  • afterRenderModule mod_jt_login (JT Login) (4.12KB) (159μs)
  • beforeRenderModule mod_custom (Top Contact) (2.73KB) (65μs)
  • afterRenderRawModule mod_custom (Top Contact) (976B) (97μs)
  • beforeRenderModule mod_custom (Top Contact) (720B) (5μs)
  • afterRenderModule mod_custom (Top Contact) (1.63KB) (100μs)
  • afterRender (179.15KB) (19.03ms)
  • 1 x afterRenderComponent com_osproperty (1.41MB) (42.5%)
    255.59ms
    1 x afterInitialise (2.24MB) (22.43%)
    134.93ms
    1 x afterLoad (713.28KB) (9.73%)
    58.54ms
    1 x afterRoute (326.32KB) (5.21%)
    31.33ms
    1 x afterRender (179.15KB) (3.16%)
    19.03ms
    1 x afterRenderRawModule mod_menu (Main Menu) (242.63KB) (3%)
    18.04ms
    1 x afterRenderRawModule mod_oscategorymenu (Explorer by Categories) (407.16KB) (2.89%)
    17.37ms
    1 x beforeRenderModule mod_custom (Footer Menu) (251.07KB) (2.85%)
    17.14ms
    1 x afterRenderRawModule mod_jt_login (JT Login) (84.3KB) (2.3%)
    13.84ms
    1 x afterRenderRawModule mod_ospropertyrandom (Latest Properties) (161.41KB) (2.08%)
    12.52ms
    1 x beforeRenderComponent com_osproperty (83.72KB) (1.27%)
    7.63ms
    1 x afterRenderRawModule mod_djimageslider (FP Image Slider) (35.79KB) (0.82%)
    4.95ms
    1 x afterRenderModule mod_custom (Footer Menu) (120.69KB) (0.47%)
    2.84ms
    1 x afterRenderRawModule mod_custom (Footer Menu) (5.6KB) (0.39%)
    2.33ms
    1 x afterRenderModule mod_ospropertyrandom (Latest Properties) (2.45KB) (0.04%)
    260μs
    1 x afterRenderModule mod_menu (Main Menu) (2.06KB) (0.04%)
    243μs
    1 x afterDispatch (2.2KB) (0.04%)
    219μs
    1 x afterRenderModule mod_oscategorymenu (Explorer by Categories) (1.83KB) (0.04%)
    213μs
    1 x afterRenderModule mod_jt_login (JT Login) (4.12KB) (0.03%)
    159μs
    1 x afterRenderModule mod_custom (Search by Area) (1.69KB) (0.02%)
    147μs
    1 x afterRenderModule mod_djimageslider (FP Image Slider) (1.63KB) (0.02%)
    132μs
    1 x afterRenderModule mod_custom (Property Management ) (1.69KB) (0.02%)
    124μs
    1 x beforeRenderModule mod_jt_login (JT Login) (1.21KB) (0.02%)
    122μs
    1 x afterRenderModule mod_custom (Contact Us) (1.75KB) (0.02%)
    121μs
    1 x afterRenderModule mod_custom (For Owners) (1.69KB) (0.02%)
    120μs
    1 x afterRenderModule mod_custom (About Butlers Choice) (1.69KB) (0.02%)
    119μs
    1 x afterRenderModule mod_custom (For Rentals) (1.69KB) (0.02%)
    116μs
    1 x afterRenderModule mod_custom (Afristay Valued Member) (3.08KB) (0.02%)
    115μs
    1 x afterRenderModule mod_custom (Home Parralax) (1.69KB) (0.02%)
    115μs
    1 x afterRenderRawModule mod_custom (Search by Area) (1.02KB) (0.02%)
    111μs
    1 x afterRenderRawModule mod_custom (Property Management ) (1.02KB) (0.02%)
    109μs
    1 x afterRenderRawModule mod_custom (For Owners) (1.02KB) (0.02%)
    102μs
    1 x afterRenderModule mod_custom (Top Contact) (1.63KB) (0.02%)
    100μs
    1 x afterRenderRawModule mod_custom (Top Contact) (976B) (0.02%)
    97μs
    1 x afterRenderRawModule mod_custom (Copyright) (976B) (0.02%)
    93μs
    1 x afterRenderRawModule mod_custom (For Rentals) (912B) (0.01%)
    88μs
    1 x afterRenderModule mod_custom (Copyright) (2KB) (0.01%)
    87μs
    1 x afterRenderRawModule mod_custom (Contact Us) (976B) (0.01%)
    84μs
    1 x afterRenderRawModule mod_custom (About Butlers Choice) (1.02KB) (0.01%)
    78μs
    1 x beforeRenderModule mod_custom (Copyright) (584B) (0.01%)
    76μs
    1 x afterRenderRawModule mod_custom (Home Parralax) (976B) (0.01%)
    76μs
    1 x beforeRenderModule mod_custom (Search by Area) (3.35KB) (0.01%)
    75μs
    1 x afterRenderRawModule mod_custom (Afristay Valued Member) (1KB) (0.01%)
    75μs
    1 x beforeRenderModule mod_djimageslider (FP Image Slider) (10.35KB) (0.01%)
    71μs
    1 x beforeRenderModule mod_custom (Property Management ) (680B) (0.01%)
    70μs
    1 x beforeRenderModule mod_custom (Top Contact) (2.73KB) (0.01%)
    65μs
    1 x beforeRenderModule mod_menu (Main Menu) (7.66KB) (0.01%)
    59μs
    1 x beforeRenderModule mod_ospropertyrandom (Latest Properties) (3.73KB) (0.01%)
    54μs
    1 x beforeRenderModule mod_oscategorymenu (Explorer by Categories) (312B) (0.01%)
    49μs
    1 x beforeRenderModule mod_custom (Contact Us) (408B) (0.01%)
    48μs
    1 x beforeRenderModule mod_custom (For Owners) (888B) (0.01%)
    47μs
    1 x beforeRenderModule mod_custom (About Butlers Choice) (408B) (0.01%)
    46μs
    1 x beforeRenderModule mod_custom (For Rentals) (408B) (0.01%)
    45μs
    1 x beforeRenderModule mod_custom (Home Parralax) (1.65KB) (0.01%)
    43μs
    1 x beforeRenderModule mod_custom (Afristay Valued Member) (176B) (0%)
    22μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
    20μs
    1 x beforeRenderModule mod_ospropertyrandom (Latest Properties) (736B) (0%)
    14μs
    1 x beforeRenderModule mod_oscategorymenu (Explorer by Categories) (736B) (0%)
    14μs
    1 x beforeRenderModule mod_jt_login (JT Login) (720B) (0%)
    12μs
    1 x beforeRenderModule mod_custom (Footer Menu) (720B) (0%)
    10μs
    1 x beforeRenderModule mod_djimageslider (FP Image Slider) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_custom (Copyright) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (Search by Area) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (About Butlers Choice) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (Property Management ) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (For Owners) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (For Rentals) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (Contact Us) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (Afristay Valued Member) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (Home Parralax) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (Top Contact) (720B) (0%)
    5μs
106 statements were executed, 16 of which were duplicates, 90 unique34.03ms191.16KB
UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4Duplicates 5Duplicates 6
  • SELECT @@SESSION.sql_mode;144μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `bcj4_session` WHERE `session_id` = ?175μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `bcj4_session` WHERE `session_id` = :session_id LIMIT 1209μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `bcj4_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.25ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `bcj4_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1651μs1.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `bcj4_viewlevels`127μs704B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `bcj4_usergroups` AS `a` LEFT JOIN `bcj4_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest238μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `bcj4_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`2.88ms3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `bcj4_languages` WHERE `published` = 1 ORDER BY `ordering` ASC192μs2.22KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM bcj4_menu WHERE alias ='14-sandbaai' AND published=1211μs2.83KB/plugins/system/t4/src/t4/MVC/Router/T4.php:352Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `bcj4_menu` AS `m` LEFT JOIN `bcj4_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`677μs3.39KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `query` FROM bcj4_osrs_urls WHERE md5_key="764aca7e6179cd54bb0f6b20041d36d5"166μs536B/components/com_osproperty/router.php:897Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `bcj4_template_styles` AS `s` LEFT JOIN `bcj4_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id` WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1416μs848B/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • Select count(id) from bcj4_osrs_configuration where fieldname like 'integrate_membership'303μs536B/components/com_osproperty/helpers/libraries/libraries.php:28Copy
  • UPDATE bcj4_osrs_configuration SET fieldvalue = '0' WHERE fieldname LIKE 'integrate_membership'149μs48B/components/com_osproperty/helpers/libraries/libraries.php:31Copy
  • Select * from bcj4_osrs_configuration633μs8.58KB/components/com_osproperty/osproperty.php:69Copy
  • Select * from bcj4_osrs_currencies where id = '49'167μs2KB/components/com_osproperty/osproperty.php:80Copy
  • SELECT lang_id, lang_code, title, `sef` FROM bcj4_languages WHERE published = 1 AND lang_code != "en-GB" ORDER BY ordering239μs688B/components/com_osproperty/helpers/helper.php:367Copy
  • Select * from bcj4_osrs_configuration496μs8.63KB/components/com_osproperty/helpers/helper.php:50Copy
  • Select * from bcj4_osrs_currencies where id = '49'133μs768B/components/com_osproperty/helpers/helper.php:61Copy
  • SELECT * FROM bcj4_osrs_configuration434μs8.63KB/components/com_osproperty/osproperty.php:131Copy
  • Select * from bcj4_osrs_themes where published = '1'202μs1.63KB/components/com_osproperty/helpers/helper.php:4877Copy
  • Select count(id) from bcj4_osrs_categories where id = '14' and published = '1' and `access` IN (1,5)143μs536B/components/com_osproperty/classes/category.php:121Copy
  • Select * from bcj4_osrs_categories where id = '14' and published = '1' and `access` IN (1,5)182μs1.59KB/components/com_osproperty/classes/category.php:126Copy
  • Select * from bcj4_osrs_categories where id = '14'157μs1.59KB/components/com_osproperty/router.php:136Copy
  • SELECT COUNT(id) FROM bcj4_osrs_urls WHERE md5_key like "764aca7e6179cd54bb0f6b20041d36d5"160μs536B/components/com_osproperty/router.php:868Copy
  • select * from bcj4_osrs_categories where published = '1' and parent_id = '14' and `access` IN (1,5) order by ordering252μs1.58KB/components/com_osproperty/classes/category.php:147Copy
  • Select * from bcj4_osrs_currencies where id = '49'148μs768B/components/com_osproperty/helpers/helper.php:3068Copy
  • SELECT count(id) FROM bcj4_osrs_states WHERE country_id = "167" and published = "1"185μs536B/components/com_osproperty/helpers/helper.php:2990Copy
  • SELECT id FROM bcj4_osrs_states WHERE country_id = "167" and published = "1"189μs536B/components/com_osproperty/helpers/helper.php:3008Copy
  • Select count(distinct a.id) from bcj4_osrs_properties as a INNER JOIN bcj4_osrs_agents as c on c.id = a.agent_id LEFT JOIN bcj4_osrs_types as d on d.id = a.pro_type INNER JOIN bcj4_osrs_countries as e on e.id = a.country LEFT JOIN bcj4_osrs_property_categories as g on g.pid = a.id WHERE 1=1 and a.access IN (1,5) AND a.country = '167' AND a.state = '60' AND ( g.category_id = '14') and a.published = '1' and a.approved = '1' AND ((a.publish_up is null or a.publish_up = '0000-00-00 00:00:00' or a.publish_up <= '2025-04-06 01:27:18' or a.publish_up = '0000-00-00') AND (a.publish_down is null or a.publish_down = '0000-00-00 00:00:00' or a.publish_down >= '2025-04-06 01:27:18' or a.publish_down = '0000-00-00'))422μs536B/components/com_osproperty/classes/listing.php:2958Copy
  • SELECT id FROM bcj4_osrs_states WHERE country_id = "167" and published = "1"209μs536B/components/com_osproperty/helpers/helper.php:3008Copy
  • Select a.*,c.name as agent_name,c.photo as agent_photo, c.mobile as agent_mobile, c.phone as agent_phone,c.email as agent_email, c.optin,d.id as typeid,d.type_name as type_name,e.country_name from bcj4_osrs_properties as a INNER JOIN bcj4_osrs_agents as c on c.id = a.agent_id LEFT JOIN bcj4_osrs_types as d on d.id = a.pro_type LEFT JOIN bcj4_osrs_countries as e on e.id = a.country LEFT JOIN bcj4_osrs_property_categories as g on g.pid = a.id WHERE 1=1 and a.access IN (1,5) AND a.country = '167' AND a.state = '60' AND ( g.category_id = '14') and a.published = '1' and a.approved = '1' AND ((a.publish_up is null or a.publish_up = '0000-00-00 00:00:00' or a.publish_up <= '2025-04-06 01:27:18' or a.publish_up = '0000-00-00') AND (a.publish_down is null or a.publish_down = '0000-00-00 00:00:00' or a.publish_down >= '2025-04-06 01:27:18' or a.publish_down = '0000-00-00')) GROUP BY a.id ORDER BY a.isFeatured desc LIMIT 201.67ms14.64KB/components/com_osproperty/classes/listing.php:3130Copy
  • Select id as value,type_name as text from bcj4_osrs_types where published = '1' order by ordering182μs592B/components/com_osproperty/classes/listing.php:3343Copy
  • Select * from bcj4_osrs_categories where published = '1' order by ordering315μs1.7KB/components/com_osproperty/helpers/helper.php:3131Copy
  • Select id as value,state_name as text, state_name from bcj4_osrs_states where published = 1 and country_id = '167' and id in (Select state from bcj4_osrs_properties where approved = '1' and published = '1') order by state_name752μs656B/components/com_osproperty/helpers/common.php:206Copy
  • SELECT id FROM bcj4_osrs_states WHERE country_id = "167" and published = "1"188μs536B/components/com_osproperty/helpers/helper.php:3008Copy
  • Select id as value, city as text, city from bcj4_osrs_cities where published = '1' and id in (Select city from bcj4_osrs_properties where approved = '1' and published = '1') and state_id = '60' order by city641μs672B/components/com_osproperty/helpers/common.php:259Copy
  • Select a.id as value, a.name as text from bcj4_osrs_agents as a inner join bcj4_users as b on b.id = a.user_id where a.published = '1' order by a.name337μs640B/components/com_osproperty/classes/listing.php:3418Copy
  • Select * from bcj4_osrs_themes where published = '1'165μs1.63KB/components/com_osproperty/helpers/helper.php:4921Copy
  • Select * from bcj4_osrs_themes where name like 'theme3'152μs1.63KB/components/com_osproperty/classes/listing.html.php:853Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `bcj4_modules` AS `m` LEFT JOIN `bcj4_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `bcj4_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) ORDER BY `m`.`position`,`m`.`ordering`1.45ms2.06KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT p.*, s.state_name, c.country_name,ty.id as typeid, ty.type_name as type_name FROM bcj4_osrs_properties AS p INNER JOIN bcj4_osrs_types AS ty ON ty.id = p.pro_type LEFT JOIN bcj4_osrs_states AS s ON s.id = p.state INNER JOIN bcj4_osrs_countries AS c ON c.id = p.country INNER JOIN bcj4_osrs_agents as ag ON p.agent_id = ag.id WHERE p.published = '1' AND p.approved = '1' AND ((p.publish_up is null or p.publish_up = '0000-00-00 00:00:00' or p.publish_up <= '2025-04-06 01:27:18' or p.publish_up = '0000-00-00') AND (p.publish_down is null or p.publish_down = '0000-00-00 00:00:00' or p.publish_down >= '2025-04-06 01:27:18' or p.publish_down = '0000-00-00')) and p.access IN (1,5) ORDER BY p.created desc limit 11.2ms12KB/modules/mod_ospropertyrandom/helper.php:267Copy
  • SELECT image FROM bcj4_osrs_photos WHERE pro_id = 90 order by ordering266μs904B/modules/mod_ospropertyrandom/helper.php:275Copy
  • SELECT id, category_name as category_name FROM bcj4_osrs_categories WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from bcj4_osrs_property_categories where pid ="90")279μs592B/components/com_osproperty/helpers/helper.php:3264Copy
  • Select fieldvalue from bcj4_osrs_configuration where fieldname like 'default_itemid'172μs536B/components/com_osproperty/helpers/route.php:44Copy
  • SELECT id FROM bcj4_menu WHERE link LIKE "%index.php?option=com_osproperty%" and ( `link` LIKE "%category_listing%" or `link` LIKE "%lcategory%" ) AND published = 1 and id in (168,448,161,166) AND `access` IN (1,5) ORDER BY access230μs536B/components/com_osproperty/helpers/route.php:462Copy
  • Select * from bcj4_osrs_categories where id = '13'165μs1.59KB/components/com_osproperty/router.php:136Copy
  • SELECT COUNT(id) FROM bcj4_osrs_urls WHERE md5_key like "3e107bdd06a3befd3d9ac7e4aefa4486"129μs536B/components/com_osproperty/router.php:868Copy
  • Select a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from bcj4_osrs_properties as a inner join bcj4_osrs_agents as b on b.id = a.agent_id left join bcj4_osrs_company_agents as c on c.agent_id = b.id where a.id = '90'245μs928B/components/com_osproperty/helpers/route.php:88Copy
  • SELECT category_id FROM bcj4_osrs_property_categories WHERE pid="90"126μs536B/components/com_osproperty/helpers/helper.php:3221Copy
  • Select id from bcj4_menu where published = '1' and ((`link` like '%view=ldetails&id=90%') or (`link` like '%view=ldetails&ampid=90%')) and `access` IN (1,5)320μs520B/components/com_osproperty/helpers/route.php:118Copy
  • Select * from bcj4_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)342μs2.83KB/components/com_osproperty/helpers/route.php:125Copy
  • Select * from bcj4_menu where published = '1' and `home` = '0' and `link` like '%view=lcity%' and `link` like '%id=0%' and `access` IN (1,5)345μs2.83KB/components/com_osproperty/helpers/route.php:130Copy
  • Select * from bcj4_menu where published = '1' and (`link` like 'view=lcategory' or `link` like 'task=category_listing')274μs2.83KB/components/com_osproperty/helpers/route.php:332Copy
  • Select count(id) from bcj4_menu where id = '0' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=90%') and `access` IN (1,5)108μs536B/components/com_osproperty/helpers/route.php:599Copy
  • Select * from bcj4_osrs_properties where id = '90'606μs11.88KB/components/com_osproperty/router.php:376Copy
  • SELECT COUNT(id) FROM bcj4_osrs_urls WHERE md5_key like "9d1d383e7e642ce66303f1e0a3d6d37d"102μs536B/components/com_osproperty/router.php:868Copy
  • SELECT id FROM bcj4_menu WHERE link LIKE "%index.php?option=com_osproperty%" and ( `link` LIKE "%category_listing%" or `link` LIKE "%lcategory%" ) AND published = 1 and id in (168,448,161,166,168,448,161,166,168,448,161,166) AND `access` IN (1,5) ORDER BY access335μs536B/components/com_osproperty/helpers/route.php:462Copy
  • SELECT *, id AS category_id, category_name FROM bcj4_osrs_categories WHERE published = '1' AND parent_id = 0 and `access` IN (1,5) ORDER BY ordering ASC416μs1.77KB/modules/mod_oscategorymenu/helper.php:35Copy
  • Select * from bcj4_osrs_categories where id = '12'152μs1.59KB/components/com_osproperty/router.php:136Copy
  • SELECT COUNT(id) FROM bcj4_osrs_urls WHERE md5_key like "5eb89e6fc22e7cb43a102c811c671c64"131μs536B/components/com_osproperty/router.php:868Copy
  • Select count(id) from bcj4_osrs_properties where approved = '1' and published = '1' and id in ( Select pid from bcj4_osrs_property_categories where category_id = '12')383μs536B/modules/mod_oscategorymenu/helper.php:46Copy
  • Select * from bcj4_osrs_categories where parent_id = '12'151μs1.58KB/modules/mod_oscategorymenu/helper.php:50Copy
  • SELECT *, id AS category_id, category_name FROM bcj4_osrs_categories WHERE published = '1' AND parent_id = 12 and `access` IN (1,5) ORDER BY ordering ASC203μs12.64KB/modules/mod_oscategorymenu/helper.php:35Copy
  • Select count(id) from bcj4_osrs_properties where approved = '1' and published = '1' and id in ( Select pid from bcj4_osrs_property_categories where category_id = '13')633μs536B/modules/mod_oscategorymenu/helper.php:46Copy
  • Select * from bcj4_osrs_categories where parent_id = '13'135μs1.58KB/modules/mod_oscategorymenu/helper.php:50Copy
  • SELECT *, id AS category_id, category_name FROM bcj4_osrs_categories WHERE published = '1' AND parent_id = 13 and `access` IN (1,5) ORDER BY ordering ASC198μs1.64KB/modules/mod_oscategorymenu/helper.php:35Copy
  • Select * from bcj4_osrs_categories where id = '14'134μs1.59KB/components/com_osproperty/router.php:136Copy
  • SELECT COUNT(id) FROM bcj4_osrs_urls WHERE md5_key like "764aca7e6179cd54bb0f6b20041d36d5"125μs536B/components/com_osproperty/router.php:868Copy
  • Select count(id) from bcj4_osrs_properties where approved = '1' and published = '1' and id in ( Select pid from bcj4_osrs_property_categories where category_id = '14')257μs536B/modules/mod_oscategorymenu/helper.php:46Copy
  • Select * from bcj4_osrs_categories where parent_id = '14'143μs1.58KB/modules/mod_oscategorymenu/helper.php:50Copy
  • SELECT *, id AS category_id, category_name FROM bcj4_osrs_categories WHERE published = '1' AND parent_id = 14 and `access` IN (1,5) ORDER BY ordering ASC212μs1.64KB/modules/mod_oscategorymenu/helper.php:35Copy
  • Select * from bcj4_osrs_categories where id = '15'161μs1.59KB/components/com_osproperty/router.php:136Copy
  • SELECT COUNT(id) FROM bcj4_osrs_urls WHERE md5_key like "a153f902be001c3e6d04ac30c290e475"118μs536B/components/com_osproperty/router.php:868Copy
  • Select count(id) from bcj4_osrs_properties where approved = '1' and published = '1' and id in ( Select pid from bcj4_osrs_property_categories where category_id = '15')377μs536B/modules/mod_oscategorymenu/helper.php:46Copy
  • Select * from bcj4_osrs_categories where parent_id = '15'135μs1.58KB/modules/mod_oscategorymenu/helper.php:50Copy
  • SELECT *, id AS category_id, category_name FROM bcj4_osrs_categories WHERE published = '1' AND parent_id = 15 and `access` IN (1,5) ORDER BY ordering ASC191μs1.64KB/modules/mod_oscategorymenu/helper.php:35Copy
  • Select * from bcj4_osrs_categories where id = '16'133μs1.59KB/components/com_osproperty/router.php:136Copy
  • SELECT COUNT(id) FROM bcj4_osrs_urls WHERE md5_key like "b6174e00753cb2f67be7ee156051adf2"123μs536B/components/com_osproperty/router.php:868Copy
  • Select count(id) from bcj4_osrs_properties where approved = '1' and published = '1' and id in ( Select pid from bcj4_osrs_property_categories where category_id = '16')734μs536B/modules/mod_oscategorymenu/helper.php:46Copy
  • Select * from bcj4_osrs_categories where parent_id = '16'137μs1.58KB/modules/mod_oscategorymenu/helper.php:50Copy
  • SELECT *, id AS category_id, category_name FROM bcj4_osrs_categories WHERE published = '1' AND parent_id = 16 and `access` IN (1,5) ORDER BY ordering ASC224μs1.64KB/modules/mod_oscategorymenu/helper.php:35Copy
  • Select * from bcj4_osrs_categories where id = '17'125μs1.59KB/components/com_osproperty/router.php:136Copy
  • SELECT COUNT(id) FROM bcj4_osrs_urls WHERE md5_key like "5f1ca4531f21b1ee26dc696da95e44e9"117μs536B/components/com_osproperty/router.php:868Copy
  • Select count(id) from bcj4_osrs_properties where approved = '1' and published = '1' and id in ( Select pid from bcj4_osrs_property_categories where category_id = '17')298μs536B/modules/mod_oscategorymenu/helper.php:46Copy
  • Select * from bcj4_osrs_categories where parent_id = '17'152μs1.58KB/modules/mod_oscategorymenu/helper.php:50Copy
  • SELECT *, id AS category_id, category_name FROM bcj4_osrs_categories WHERE published = '1' AND parent_id = 17 and `access` IN (1,5) ORDER BY ordering ASC197μs1.64KB/modules/mod_oscategorymenu/helper.php:35Copy
  • Select * from bcj4_osrs_categories where id = '18'149μs1.59KB/components/com_osproperty/router.php:136Copy
  • SELECT COUNT(id) FROM bcj4_osrs_urls WHERE md5_key like "3fc082601891c02b5a7ede9395d4ddd6"115μs536B/components/com_osproperty/router.php:868Copy
  • Select count(id) from bcj4_osrs_properties where approved = '1' and published = '1' and id in ( Select pid from bcj4_osrs_property_categories where category_id = '18')240μs536B/modules/mod_oscategorymenu/helper.php:46Copy
  • Select * from bcj4_osrs_categories where parent_id = '18'146μs1.58KB/modules/mod_oscategorymenu/helper.php:50Copy
  • SELECT *, id AS category_id, category_name FROM bcj4_osrs_categories WHERE published = '1' AND parent_id = 18 and `access` IN (1,5) ORDER BY ordering ASC220μs1.64KB/modules/mod_oscategorymenu/helper.php:35Copy
  • Select * from bcj4_osrs_categories where id = '19'150μs1.59KB/components/com_osproperty/router.php:136Copy
  • SELECT COUNT(id) FROM bcj4_osrs_urls WHERE md5_key like "5196ba856fccc28dc4b9c8f7eb41bc47"140μs536B/components/com_osproperty/router.php:868Copy
  • Select count(id) from bcj4_osrs_properties where approved = '1' and published = '1' and id in ( Select pid from bcj4_osrs_property_categories where category_id = '19')206μs536B/modules/mod_oscategorymenu/helper.php:46Copy
  • Select * from bcj4_osrs_categories where parent_id = '19'125μs1.58KB/modules/mod_oscategorymenu/helper.php:50Copy
  • SELECT *, id AS category_id, category_name FROM bcj4_osrs_categories WHERE published = '1' AND parent_id = 19 and `access` IN (1,5) ORDER BY ordering ASC216μs1.64KB/modules/mod_oscategorymenu/helper.php:35Copy
  • SELECT manifest_cache FROM bcj4_extensions WHERE element='mod_djimageslider' LIMIT 1292μs536B/modules/mod_djimageslider/mod_djimageslider.php:97Copy
  • Select id, country_name from bcj4_osrs_countries where id = '167'107μs592B/components/com_osproperty/router.php:543Copy
  • Select count(id) from bcj4_menu where id = '168' and published = '1'112μs536B/components/com_osproperty/helpers/route.php:613Copy
  • Select * from bcj4_osrs_categories where id = '14'254μs1.59KB/components/com_osproperty/router.php:136Copy
  • SELECT COUNT(id) FROM bcj4_osrs_urls WHERE md5_key like "764aca7e6179cd54bb0f6b20041d36d5"164μs536B/components/com_osproperty/router.php:868Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `bcj4_scheduler_tasks` AS `a` WHERE `a`.`state` = 1230μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `bcj4_session` WHERE `session_id` = ?175μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `bcj4_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.26ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy