At OSP Home search our purpose is to help people find great local businesses like dentists, hair stylists and mechanics. Go Explore!
Joomla! Version | 5.2.4 |
PHP Version | 8.1.2-1ubuntu2.22 |
Identity | guest |
Response | 200 |
Template | osphomesearch4 |
Database |
|
1 x afterRenderComponent com_osproperty (6.99MB) (93.24%) | 1.67s |
1 x beforeRenderRawModule mod_footer (Copyright) (232.32KB) (1.71%) | 30.69ms |
1 x afterInitialise (1.65MB) (1.66%) | 29.85ms |
1 x afterRoute (56.22KB) (1.03%) | 18.45ms |
1 x afterRenderRawModule mod_login (Login Form) (100KB) (0.98%) | 17.61ms |
1 x afterRender (336.63KB) (0.42%) | 7.60ms |
1 x afterLoad (86.74KB) (0.28%) | 5.06ms |
1 x afterRenderRawModule mod_menu (mainmenu) (71.88KB) (0.16%) | 2.90ms |
1 x afterRenderRawModule mod_footer (Copyright) (13.67KB) (0.08%) | 1.36ms |
1 x beforeRenderRawModule mod_menu (mainmenu) (36.65KB) (0.07%) | 1.20ms |
1 x beforeRenderComponent com_osproperty (81.2KB) (0.05%) | 943μs |
1 x afterDispatch (2.95KB) (0.05%) | 905μs |
1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (6.82KB) (0.04%) | 730μs |
1 x afterRenderRawModule mod_custom (Stay Connected) (3.9KB) (0.03%) | 582μs |
1 x afterRenderModule mod_footer (Copyright) (4.13KB) (0.02%) | 391μs |
1 x afterRenderModule mod_login (Login Form) (5.5KB) (0.02%) | 338μs |
1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.36KB) (0.01%) | 216μs |
1 x afterRenderModule mod_custom (Stay Connected) (4.42KB) (0.01%) | 134μs |
1 x afterRenderModule mod_menu (mainmenu) (6.76KB) (0.01%) | 131μs |
1 x beforeRenderRawModule mod_login (Login Form) (256B) (0.01%) | 120μs |
1 x afterRenderModule mod_custom (About OSP Home Search) (3.05KB) (0.01%) | 117μs |
1 x afterRenderModule mod_custom (Contact us) (2.8KB) (0.01%) | 115μs |
1 x beforeRenderRawModule mod_custom (Stay Connected) (696B) (0.01%) | 111μs |
1 x afterRenderRawModule mod_custom (Contact us) (992B) (0.01%) | 106μs |
1 x afterRenderRawModule mod_custom (About OSP Home Search) (928B) (0.01%) | 95μs |
1 x beforeRenderRawModule mod_custom (Contact us) (488B) (0.01%) | 92μs |
1 x beforeRenderRawModule mod_custom (About OSP Home Search) (472B) (0%) | 76μs |
1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (784B) (0%) | 64μs |
1 x beforeRenderModule mod_login (Login Form) (720B) (0%) | 24μs |
1 x beforeRenderModule mod_menu (mainmenu) (704B) (0%) | 15μs |
1 x beforeRenderModule mod_footer (Copyright) (720B) (0%) | 14μs |
1 x beforeRenderModule mod_custom (Stay Connected) (720B) (0%) | 13μs |
1 x beforeRenderModule mod_custom (About OSP Home Search) (720B) (0%) | 13μs |
1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%) | 13μs |
1 x beforeRenderModule mod_custom (Contact us) (720B) (0%) | 11μs |
SELECT @@SESSION.sql_mode;
257μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308CopySELECT `data`
FROM `sra_session`
WHERE `session_id` = ?
372μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250CopySELECT `session_id`
FROM `sra_session`
WHERE `session_id` = :session_id LIMIT 1
314μs1.61KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `sra_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
3.15ms944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `sra_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
760μs2.23KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `sra_viewlevels`
342μs976B/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `sra_usergroups` AS `a`
LEFT JOIN `sra_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest
501μs1.64KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `sra_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`
1.63ms4.3KBParams/libraries/src/Plugin/PluginHelper.php:294CopySELECT *
FROM `sra_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
380μs3.47KB/libraries/src/Language/LanguageHelper.php:177CopySELECT *
FROM sra_menu
WHERE alias ='all-listing' AND published=1
459μs4.09KB/plugins/system/t4/src/t4/MVC/Router/T4.php:352CopySELECT `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 `sra_menu` AS `m`
LEFT JOIN `sra_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`
659μs4.63KBParams/libraries/src/Menu/SiteMenu.php:166CopySELECT `query`
FROM sra_osrs_urls
WHERE md5_key="ef8ea8553842060e66ab2da12736babf"
11.42ms856B/components/com_osproperty/router.php:897CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `sra_template_styles` AS `s`
LEFT JOIN `sra_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` = 1
575μs1.2KB/administrator/components/com_templates/src/Model/StyleModel.php:775CopySelect count(id) from sra_osrs_configuration where fieldname like 'integrate_membership'
472μs856B/components/com_osproperty/helpers/libraries/libraries.php:28CopyUPDATE sra_osrs_configuration SET fieldvalue = '0' WHERE fieldname LIKE 'integrate_membership'
455μs48B/components/com_osproperty/helpers/libraries/libraries.php:31CopySelect * from sra_osrs_configuration
1.42ms8.89KB/components/com_osproperty/osproperty.php:69CopySelect * from sra_osrs_currencies where id = '57'
311μs3.56KB/components/com_osproperty/osproperty.php:80CopySELECT lang_id, lang_code, title, `sef`
FROM sra_languages
WHERE published = 1 AND lang_code != "en-GB"
ORDER BY ordering
384μs1008B/components/com_osproperty/helpers/helper.php:367CopySelect * from sra_osrs_configuration
1.45ms8.94KB/components/com_osproperty/helpers/helper.php:50CopySelect * from sra_osrs_currencies where id = '57'
289μs1.06KB/components/com_osproperty/helpers/helper.php:61CopySELECT * FROM sra_osrs_configuration
1.36ms8.94KB/components/com_osproperty/osproperty.php:131CopySelect * from sra_osrs_themes where published = '1'
355μs2.25KB/components/com_osproperty/helpers/helper.php:4877CopySelect count(id) from sra_osrs_property_listing_layout where id = '129'
332μs856B/components/com_osproperty/classes/listing.html.php:719CopySelect * from sra_osrs_currencies where id = '57'
295μs1.06KB/components/com_osproperty/helpers/helper.php:3068CopySELECT count(id)
FROM sra_osrs_states
WHERE country_id = "194" and published = "1"
931μs856B/components/com_osproperty/helpers/helper.php:2990CopySelect count(distinct a.id) from sra_osrs_properties as a INNER JOIN sra_osrs_agents as c on c.id = a.agent_id LEFT JOIN sra_osrs_types as d on d.id = a.pro_type INNER JOIN sra_osrs_countries as e on e.id = a.country LEFT JOIN sra_osrs_property_categories as g on g.pid = a.id WHERE 1=1 and a.access IN (1,5) 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-08-14 01:59:01' 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-08-14 01:59:01' or a.publish_down = '0000-00-00'))
84.81ms856B/components/com_osproperty/classes/listing.php:2958CopySelect 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 sra_osrs_properties as a INNER JOIN sra_osrs_agents as c on c.id = a.agent_id LEFT JOIN sra_osrs_types as d on d.id = a.pro_type LEFT JOIN sra_osrs_countries as e on e.id = a.country LEFT JOIN sra_osrs_property_categories as g on g.pid = a.id WHERE 1=1 and a.access IN (1,5) 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-08-14 01:59:01' 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-08-14 01:59:01' or a.publish_down = '0000-00-00')) GROUP BY a.id ORDER BY a.id desc LIMIT 20
435ms80.67KB/components/com_osproperty/classes/listing.php:3130CopySelect * from sra_osrs_extra_fields where published = '1' and `access` IN (1,5) and show_on_list = '1' order by ordering
571μs4.05KB/components/com_osproperty/helpers/common.php:3876CopySelect count(id) from sra_osrs_properties where pro_alias like '14802-arrowhead-dr' and id <> '4774'
562μs856B/components/com_osproperty/helpers/helper.php:2016CopySelect count(id) from sra_osrs_properties where pro_alias like '14802-arrowhead-dr' and id <> '4774'
473μs856B/components/com_osproperty/helpers/helper.php:2016CopySELECT id, category_name as category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4774")
529μs912B/components/com_osproperty/helpers/helper.php:3264CopySelect fieldvalue from sra_osrs_configuration where fieldname like 'default_itemid'
359μs856B/components/com_osproperty/helpers/route.php:44CopySELECT id
FROM sra_menu
WHERE link LIKE "%index.php?option=com_osproperty%" and ( `link` LIKE "%category_listing%" or `link` LIKE "%lcategory%" ) AND published = 1 and id in (129,136,137,138) AND `access` IN (1,5)
ORDER BY access
422μs11.82KB/components/com_osproperty/helpers/route.php:462CopySelect * from sra_osrs_categories where id = '1'
318μs2.22KB/components/com_osproperty/router.php:136CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "010d356373450186a10df4b73d78e503"
11.84ms856B/components/com_osproperty/router.php:868CopySELECT category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4774")
638μs856B/components/com_osproperty/helpers/helper.php:3242CopySELECT *
FROM sra_osrs_property_open
WHERE pid='4774' and end_to > '2025-08-14 01:59:02'
ORDER BY start_from
346μs1008B/components/com_osproperty/classes/listing.php:3172CopySelect * from sra_osrs_comments where pro_id = '4774' and published = '1' order by created_on desc
418μs2.27KB/components/com_osproperty/classes/listing.php:3195CopySelect pro_type from sra_osrs_properties where id = '4774'
318μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '107' and type_id = '1'
352μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4774' and field_id = '107'
455μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4774'
316μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '108' and type_id = '1'
345μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4774' and field_id = '108'
462μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4774'
315μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '105' and type_id = '1'
334μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect `value_date` from sra_osrs_property_field_value where pro_id = '4774' and field_id = '105'
417μs856B/administrator/components/com_osproperty/helpers/extrafields.php:2196CopySelect pro_type from sra_osrs_properties where id = '4774'
296μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '106' and type_id = '1'
338μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect a.* from sra_osrs_extra_field_options as a inner join sra_osrs_property_field_opt_value as b on b.oid = a.id where b.pid = '4774' and b.fid = '106'
429μs1008B/administrator/components/com_osproperty/helpers/extrafields.php:2298Copyselect count(id) from sra_osrs_photos where pro_id = '4774'
340μs856B/components/com_osproperty/classes/listing.php:3226Copyselect image from sra_osrs_photos where pro_id = '4774' order by ordering limit 1
388μs856B/components/com_osproperty/classes/listing.php:3230CopySelect * from sra_osrs_photos where pro_id = '4774'
371μs1.2KB/components/com_osproperty/classes/listing.php:3251CopySelect state_name from sra_osrs_states where id = '44'
301μs856B/components/com_osproperty/helpers/helper.php:1633CopySelect * from sra_osrs_countries where id = '194'
285μs976B/components/com_osproperty/helpers/helper.php:1644CopySelect count(id) from sra_osrs_comments where pro_id = '4774'
290μs856B/components/com_osproperty/classes/listing.php:3298CopySelect count(id) from sra_osrs_properties where pro_alias like '8001-shining-flor-ln' and id <> '4773'
494μs856B/components/com_osproperty/helpers/helper.php:2016CopySelect count(id) from sra_osrs_properties where pro_alias like '8001-shining-flor-ln' and id <> '4773'
443μs856B/components/com_osproperty/helpers/helper.php:2016CopySELECT id, category_name as category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4773")
475μs912B/components/com_osproperty/helpers/helper.php:3264CopySELECT id
FROM sra_menu
WHERE link LIKE "%index.php?option=com_osproperty%" and ( `link` LIKE "%category_listing%" or `link` LIKE "%lcategory%" ) AND published = 1 and id in (129,136,137,138,129,136,137,138) AND `access` IN (1,5)
ORDER BY access
377μs840B/components/com_osproperty/helpers/route.php:462CopySELECT category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4773")
439μs856B/components/com_osproperty/helpers/helper.php:3242CopySELECT *
FROM sra_osrs_property_open
WHERE pid='4773' and end_to > '2025-08-14 01:59:02'
ORDER BY start_from
317μs1008B/components/com_osproperty/classes/listing.php:3172CopySelect * from sra_osrs_comments where pro_id = '4773' and published = '1' order by created_on desc
433μs2.27KB/components/com_osproperty/classes/listing.php:3195CopySelect pro_type from sra_osrs_properties where id = '4773'
305μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '107' and type_id = '1'
345μs8.84KB/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4773' and field_id = '107'
514μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4773'
297μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '108' and type_id = '1'
335μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4773' and field_id = '108'
452μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4773'
296μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '105' and type_id = '1'
337μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect `value_date` from sra_osrs_property_field_value where pro_id = '4773' and field_id = '105'
479μs856B/administrator/components/com_osproperty/helpers/extrafields.php:2196CopySelect pro_type from sra_osrs_properties where id = '4773'
294μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '106' and type_id = '1'
351μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect a.* from sra_osrs_extra_field_options as a inner join sra_osrs_property_field_opt_value as b on b.oid = a.id where b.pid = '4773' and b.fid = '106'
439μs1008B/administrator/components/com_osproperty/helpers/extrafields.php:2298Copyselect count(id) from sra_osrs_photos where pro_id = '4773'
333μs856B/components/com_osproperty/classes/listing.php:3226Copyselect image from sra_osrs_photos where pro_id = '4773' order by ordering limit 1
373μs856B/components/com_osproperty/classes/listing.php:3230CopySelect * from sra_osrs_photos where pro_id = '4773'
455μs1.17KB/components/com_osproperty/classes/listing.php:3251CopySelect count(id) from sra_osrs_comments where pro_id = '4773'
283μs856B/components/com_osproperty/classes/listing.php:3298CopySelect count(id) from sra_osrs_properties where pro_alias like '2413-blue-sky-ln' and id <> '4772'
457μs856B/components/com_osproperty/helpers/helper.php:2016CopySelect count(id) from sra_osrs_properties where pro_alias like '2413-blue-sky-ln' and id <> '4772'
472μs856B/components/com_osproperty/helpers/helper.php:2016CopySELECT id, category_name as category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4772")
495μs912B/components/com_osproperty/helpers/helper.php:3264CopySELECT id
FROM sra_menu
WHERE link LIKE "%index.php?option=com_osproperty%" and ( `link` LIKE "%category_listing%" or `link` LIKE "%lcategory%" ) AND published = 1 and id in (129,136,137,138,129,136,137,138,129,136,137,138) AND `access` IN (1,5)
ORDER BY access
428μs840B/components/com_osproperty/helpers/route.php:462CopySELECT category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4772")
465μs856B/components/com_osproperty/helpers/helper.php:3242CopySELECT *
FROM sra_osrs_property_open
WHERE pid='4772' and end_to > '2025-08-14 01:59:02'
ORDER BY start_from
326μs1008B/components/com_osproperty/classes/listing.php:3172CopySelect * from sra_osrs_comments where pro_id = '4772' and published = '1' order by created_on desc
332μs2.27KB/components/com_osproperty/classes/listing.php:3195CopySelect pro_type from sra_osrs_properties where id = '4772'
304μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '107' and type_id = '1'
334μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4772' and field_id = '107'
469μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4772'
303μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '108' and type_id = '1'
334μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4772' and field_id = '108'
499μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4772'
302μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '105' and type_id = '1'
364μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect `value_date` from sra_osrs_property_field_value where pro_id = '4772' and field_id = '105'
426μs856B/administrator/components/com_osproperty/helpers/extrafields.php:2196CopySelect pro_type from sra_osrs_properties where id = '4772'
335μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '106' and type_id = '1'
337μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect a.* from sra_osrs_extra_field_options as a inner join sra_osrs_property_field_opt_value as b on b.oid = a.id where b.pid = '4772' and b.fid = '106'
445μs1008B/administrator/components/com_osproperty/helpers/extrafields.php:2298Copyselect count(id) from sra_osrs_photos where pro_id = '4772'
371μs856B/components/com_osproperty/classes/listing.php:3226Copyselect image from sra_osrs_photos where pro_id = '4772' order by ordering limit 1
474μs856B/components/com_osproperty/classes/listing.php:3230CopySelect * from sra_osrs_photos where pro_id = '4772'
387μs1.2KB/components/com_osproperty/classes/listing.php:3251CopySelect count(id) from sra_osrs_comments where pro_id = '4772'
299μs856B/components/com_osproperty/classes/listing.php:3298CopySelect count(id) from sra_osrs_properties where pro_alias like '4503-credo-ln-134' and id <> '4771'
576μs856B/components/com_osproperty/helpers/helper.php:2016CopySelect count(id) from sra_osrs_properties where pro_alias like '4503-credo-ln-134' and id <> '4771'
538μs856B/components/com_osproperty/helpers/helper.php:2016CopySELECT id, category_name as category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4771")
545μs912B/components/com_osproperty/helpers/helper.php:3264CopySELECT id
FROM sra_menu
WHERE link LIKE "%index.php?option=com_osproperty%" and ( `link` LIKE "%category_listing%" or `link` LIKE "%lcategory%" ) AND published = 1 and id in (129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138) AND `access` IN (1,5)
ORDER BY access
394μs840B/components/com_osproperty/helpers/route.php:462CopySELECT category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4771")
452μs856B/components/com_osproperty/helpers/helper.php:3242CopySELECT *
FROM sra_osrs_property_open
WHERE pid='4771' and end_to > '2025-08-14 01:59:02'
ORDER BY start_from
320μs1008B/components/com_osproperty/classes/listing.php:3172CopySelect * from sra_osrs_comments where pro_id = '4771' and published = '1' order by created_on desc
334μs2.27KB/components/com_osproperty/classes/listing.php:3195CopySelect pro_type from sra_osrs_properties where id = '4771'
362μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '107' and type_id = '4'
350μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4771' and field_id = '107'
469μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4771'
302μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '108' and type_id = '4'
338μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4771' and field_id = '108'
448μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4771'
357μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '105' and type_id = '4'
371μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect `value_date` from sra_osrs_property_field_value where pro_id = '4771' and field_id = '105'
425μs856B/administrator/components/com_osproperty/helpers/extrafields.php:2196CopySelect pro_type from sra_osrs_properties where id = '4771'
299μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '106' and type_id = '4'
331μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect a.* from sra_osrs_extra_field_options as a inner join sra_osrs_property_field_opt_value as b on b.oid = a.id where b.pid = '4771' and b.fid = '106'
446μs1008B/administrator/components/com_osproperty/helpers/extrafields.php:2298Copyselect count(id) from sra_osrs_photos where pro_id = '4771'
378μs856B/components/com_osproperty/classes/listing.php:3226Copyselect image from sra_osrs_photos where pro_id = '4771' order by ordering limit 1
386μs856B/components/com_osproperty/classes/listing.php:3230CopySelect * from sra_osrs_photos where pro_id = '4771'
388μs1.2KB/components/com_osproperty/classes/listing.php:3251CopySelect count(id) from sra_osrs_comments where pro_id = '4771'
288μs856B/components/com_osproperty/classes/listing.php:3298CopySelect count(id) from sra_osrs_properties where pro_alias like '8007-shining-flor-ln' and id <> '4770'
454μs856B/components/com_osproperty/helpers/helper.php:2016CopySelect count(id) from sra_osrs_properties where pro_alias like '8007-shining-flor-ln' and id <> '4770'
504μs856B/components/com_osproperty/helpers/helper.php:2016CopySELECT id, category_name as category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4770")
475μs912B/components/com_osproperty/helpers/helper.php:3264CopySELECT id
FROM sra_menu
WHERE link LIKE "%index.php?option=com_osproperty%" and ( `link` LIKE "%category_listing%" or `link` LIKE "%lcategory%" ) AND published = 1 and id in (129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138) AND `access` IN (1,5)
ORDER BY access
378μs16.82KB/components/com_osproperty/helpers/route.php:462CopySELECT category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4770")
459μs856B/components/com_osproperty/helpers/helper.php:3242CopySELECT *
FROM sra_osrs_property_open
WHERE pid='4770' and end_to > '2025-08-14 01:59:02'
ORDER BY start_from
425μs1008B/components/com_osproperty/classes/listing.php:3172CopySelect * from sra_osrs_comments where pro_id = '4770' and published = '1' order by created_on desc
373μs2.27KB/components/com_osproperty/classes/listing.php:3195CopySelect pro_type from sra_osrs_properties where id = '4770'
308μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '107' and type_id = '1'
350μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4770' and field_id = '107'
460μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4770'
405μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '108' and type_id = '1'
422μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4770' and field_id = '108'
544μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4770'
304μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '105' and type_id = '1'
331μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect `value_date` from sra_osrs_property_field_value where pro_id = '4770' and field_id = '105'
422μs856B/administrator/components/com_osproperty/helpers/extrafields.php:2196CopySelect pro_type from sra_osrs_properties where id = '4770'
271μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '106' and type_id = '1'
376μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect a.* from sra_osrs_extra_field_options as a inner join sra_osrs_property_field_opt_value as b on b.oid = a.id where b.pid = '4770' and b.fid = '106'
468μs1008B/administrator/components/com_osproperty/helpers/extrafields.php:2298Copyselect count(id) from sra_osrs_photos where pro_id = '4770'
345μs856B/components/com_osproperty/classes/listing.php:3226Copyselect image from sra_osrs_photos where pro_id = '4770' order by ordering limit 1
445μs856B/components/com_osproperty/classes/listing.php:3230CopySelect * from sra_osrs_photos where pro_id = '4770'
360μs1.17KB/components/com_osproperty/classes/listing.php:3251CopySelect count(id) from sra_osrs_comments where pro_id = '4770'
279μs856B/components/com_osproperty/classes/listing.php:3298CopySelect count(id) from sra_osrs_properties where pro_alias like '201-prodigal-way' and id <> '4769'
474μs856B/components/com_osproperty/helpers/helper.php:2016CopySelect count(id) from sra_osrs_properties where pro_alias like '201-prodigal-way' and id <> '4769'
455μs856B/components/com_osproperty/helpers/helper.php:2016CopySELECT id, category_name as category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4769")
512μs912B/components/com_osproperty/helpers/helper.php:3264CopySELECT id
FROM sra_menu
WHERE link LIKE "%index.php?option=com_osproperty%" and ( `link` LIKE "%category_listing%" or `link` LIKE "%lcategory%" ) AND published = 1 and id in (129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138) AND `access` IN (1,5)
ORDER BY access
377μs840B/components/com_osproperty/helpers/route.php:462CopySELECT category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4769")
415μs856B/components/com_osproperty/helpers/helper.php:3242CopySELECT *
FROM sra_osrs_property_open
WHERE pid='4769' and end_to > '2025-08-14 01:59:02'
ORDER BY start_from
313μs1008B/components/com_osproperty/classes/listing.php:3172CopySelect * from sra_osrs_comments where pro_id = '4769' and published = '1' order by created_on desc
325μs2.27KB/components/com_osproperty/classes/listing.php:3195CopySelect pro_type from sra_osrs_properties where id = '4769'
307μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '107' and type_id = '1'
314μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4769' and field_id = '107'
459μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4769'
332μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '108' and type_id = '1'
335μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4769' and field_id = '108'
482μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4769'
295μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '105' and type_id = '1'
323μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect `value_date` from sra_osrs_property_field_value where pro_id = '4769' and field_id = '105'
404μs856B/administrator/components/com_osproperty/helpers/extrafields.php:2196CopySelect pro_type from sra_osrs_properties where id = '4769'
271μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '106' and type_id = '1'
362μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect a.* from sra_osrs_extra_field_options as a inner join sra_osrs_property_field_opt_value as b on b.oid = a.id where b.pid = '4769' and b.fid = '106'
445μs1008B/administrator/components/com_osproperty/helpers/extrafields.php:2298Copyselect count(id) from sra_osrs_photos where pro_id = '4769'
311μs856B/components/com_osproperty/classes/listing.php:3226Copyselect image from sra_osrs_photos where pro_id = '4769' order by ordering limit 1
343μs856B/components/com_osproperty/classes/listing.php:3230CopySelect * from sra_osrs_photos where pro_id = '4769'
331μs1.08KB/components/com_osproperty/classes/listing.php:3251CopySelect count(id) from sra_osrs_comments where pro_id = '4769'
272μs856B/components/com_osproperty/classes/listing.php:3298CopySelect count(id) from sra_osrs_properties where pro_alias like '167-sycamore-pines' and id <> '4768'
505μs856B/components/com_osproperty/helpers/helper.php:2016CopySelect count(id) from sra_osrs_properties where pro_alias like '167-sycamore-pines' and id <> '4768'
446μs856B/components/com_osproperty/helpers/helper.php:2016CopySELECT id, category_name as category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4768")
469μs912B/components/com_osproperty/helpers/helper.php:3264CopySELECT id
FROM sra_menu
WHERE link LIKE "%index.php?option=com_osproperty%" and ( `link` LIKE "%category_listing%" or `link` LIKE "%lcategory%" ) AND published = 1 and id in (129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138) AND `access` IN (1,5)
ORDER BY access
397μs840B/components/com_osproperty/helpers/route.php:462CopySELECT category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4768")
415μs856B/components/com_osproperty/helpers/helper.php:3242CopySELECT *
FROM sra_osrs_property_open
WHERE pid='4768' and end_to > '2025-08-14 01:59:02'
ORDER BY start_from
310μs1008B/components/com_osproperty/classes/listing.php:3172CopySelect * from sra_osrs_comments where pro_id = '4768' and published = '1' order by created_on desc
322μs2.27KB/components/com_osproperty/classes/listing.php:3195CopySelect pro_type from sra_osrs_properties where id = '4768'
291μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '107' and type_id = '1'
311μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4768' and field_id = '107'
444μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4768'
284μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '108' and type_id = '1'
305μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4768' and field_id = '108'
453μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4768'
299μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '105' and type_id = '1'
306μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect `value_date` from sra_osrs_property_field_value where pro_id = '4768' and field_id = '105'
407μs856B/administrator/components/com_osproperty/helpers/extrafields.php:2196CopySelect pro_type from sra_osrs_properties where id = '4768'
271μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '106' and type_id = '1'
305μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect a.* from sra_osrs_extra_field_options as a inner join sra_osrs_property_field_opt_value as b on b.oid = a.id where b.pid = '4768' and b.fid = '106'
557μs1008B/administrator/components/com_osproperty/helpers/extrafields.php:2298Copyselect count(id) from sra_osrs_photos where pro_id = '4768'
343μs856B/components/com_osproperty/classes/listing.php:3226Copyselect image from sra_osrs_photos where pro_id = '4768' order by ordering limit 1
350μs856B/components/com_osproperty/classes/listing.php:3230CopySelect * from sra_osrs_photos where pro_id = '4768'
330μs1.08KB/components/com_osproperty/classes/listing.php:3251CopySelect count(id) from sra_osrs_comments where pro_id = '4768'
278μs856B/components/com_osproperty/classes/listing.php:3298CopySelect count(id) from sra_osrs_properties where pro_alias like '113-sycamore-pines' and id <> '4767'
519μs856B/components/com_osproperty/helpers/helper.php:2016CopySelect count(id) from sra_osrs_properties where pro_alias like '113-sycamore-pines' and id <> '4767'
434μs856B/components/com_osproperty/helpers/helper.php:2016CopySELECT id, category_name as category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4767")
496μs912B/components/com_osproperty/helpers/helper.php:3264CopySELECT id
FROM sra_menu
WHERE link LIKE "%index.php?option=com_osproperty%" and ( `link` LIKE "%category_listing%" or `link` LIKE "%lcategory%" ) AND published = 1 and id in (129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138) AND `access` IN (1,5)
ORDER BY access
381μs840B/components/com_osproperty/helpers/route.php:462CopySELECT category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4767")
412μs856B/components/com_osproperty/helpers/helper.php:3242CopySELECT *
FROM sra_osrs_property_open
WHERE pid='4767' and end_to > '2025-08-14 01:59:02'
ORDER BY start_from
357μs1008B/components/com_osproperty/classes/listing.php:3172CopySelect * from sra_osrs_comments where pro_id = '4767' and published = '1' order by created_on desc
659μs2.27KB/components/com_osproperty/classes/listing.php:3195CopySelect pro_type from sra_osrs_properties where id = '4767'
281μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '107' and type_id = '1'
372μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4767' and field_id = '107'
451μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4767'
286μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '108' and type_id = '1'
352μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4767' and field_id = '108'
437μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4767'
266μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '105' and type_id = '1'
346μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect `value_date` from sra_osrs_property_field_value where pro_id = '4767' and field_id = '105'
402μs856B/administrator/components/com_osproperty/helpers/extrafields.php:2196CopySelect pro_type from sra_osrs_properties where id = '4767'
265μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '106' and type_id = '1'
302μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect a.* from sra_osrs_extra_field_options as a inner join sra_osrs_property_field_opt_value as b on b.oid = a.id where b.pid = '4767' and b.fid = '106'
441μs1008B/administrator/components/com_osproperty/helpers/extrafields.php:2298Copyselect count(id) from sra_osrs_photos where pro_id = '4767'
307μs856B/components/com_osproperty/classes/listing.php:3226Copyselect image from sra_osrs_photos where pro_id = '4767' order by ordering limit 1
324μs856B/components/com_osproperty/classes/listing.php:3230CopySelect * from sra_osrs_photos where pro_id = '4767'
330μs1.08KB/components/com_osproperty/classes/listing.php:3251CopySelect count(id) from sra_osrs_comments where pro_id = '4767'
275μs856B/components/com_osproperty/classes/listing.php:3298CopySelect count(id) from sra_osrs_properties where pro_alias like '109-tyrah-ln' and id <> '4766'
481μs856B/components/com_osproperty/helpers/helper.php:2016CopySelect count(id) from sra_osrs_properties where pro_alias like '109-tyrah-ln' and id <> '4766'
409μs856B/components/com_osproperty/helpers/helper.php:2016CopySELECT id, category_name as category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4766")
454μs912B/components/com_osproperty/helpers/helper.php:3264CopySELECT id
FROM sra_menu
WHERE link LIKE "%index.php?option=com_osproperty%" and ( `link` LIKE "%category_listing%" or `link` LIKE "%lcategory%" ) AND published = 1 and id in (129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138) AND `access` IN (1,5)
ORDER BY access
367μs840B/components/com_osproperty/helpers/route.php:462CopySELECT category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4766")
415μs856B/components/com_osproperty/helpers/helper.php:3242CopySELECT *
FROM sra_osrs_property_open
WHERE pid='4766' and end_to > '2025-08-14 01:59:02'
ORDER BY start_from
306μs1008B/components/com_osproperty/classes/listing.php:3172CopySelect * from sra_osrs_comments where pro_id = '4766' and published = '1' order by created_on desc
323μs2.27KB/components/com_osproperty/classes/listing.php:3195CopySelect pro_type from sra_osrs_properties where id = '4766'
293μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '107' and type_id = '1'
314μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4766' and field_id = '107'
466μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4766'
256μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '108' and type_id = '1'
316μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4766' and field_id = '108'
536μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4766'
288μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '105' and type_id = '1'
309μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect `value_date` from sra_osrs_property_field_value where pro_id = '4766' and field_id = '105'
410μs856B/administrator/components/com_osproperty/helpers/extrafields.php:2196CopySelect pro_type from sra_osrs_properties where id = '4766'
284μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '106' and type_id = '1'
304μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect a.* from sra_osrs_extra_field_options as a inner join sra_osrs_property_field_opt_value as b on b.oid = a.id where b.pid = '4766' and b.fid = '106'
492μs1008B/administrator/components/com_osproperty/helpers/extrafields.php:2298Copyselect count(id) from sra_osrs_photos where pro_id = '4766'
328μs856B/components/com_osproperty/classes/listing.php:3226Copyselect image from sra_osrs_photos where pro_id = '4766' order by ordering limit 1
363μs856B/components/com_osproperty/classes/listing.php:3230CopySelect * from sra_osrs_photos where pro_id = '4766'
364μs1.2KB/components/com_osproperty/classes/listing.php:3251CopySelect count(id) from sra_osrs_comments where pro_id = '4766'
299μs856B/components/com_osproperty/classes/listing.php:3298CopySelect count(id) from sra_osrs_properties where pro_alias like '27-stillmeadow-dr' and id <> '4765'
507μs856B/components/com_osproperty/helpers/helper.php:2016CopySelect count(id) from sra_osrs_properties where pro_alias like '27-stillmeadow-dr' and id <> '4765'
457μs856B/components/com_osproperty/helpers/helper.php:2016CopySELECT id, category_name as category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4765")
451μs912B/components/com_osproperty/helpers/helper.php:3264CopySELECT id
FROM sra_menu
WHERE link LIKE "%index.php?option=com_osproperty%" and ( `link` LIKE "%category_listing%" or `link` LIKE "%lcategory%" ) AND published = 1 and id in (129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138) AND `access` IN (1,5)
ORDER BY access
366μs840B/components/com_osproperty/helpers/route.php:462CopySELECT category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4765")
414μs856B/components/com_osproperty/helpers/helper.php:3242CopySELECT *
FROM sra_osrs_property_open
WHERE pid='4765' and end_to > '2025-08-14 01:59:02'
ORDER BY start_from
302μs1008B/components/com_osproperty/classes/listing.php:3172CopySelect * from sra_osrs_comments where pro_id = '4765' and published = '1' order by created_on desc
353μs2.27KB/components/com_osproperty/classes/listing.php:3195CopySelect pro_type from sra_osrs_properties where id = '4765'
285μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '107' and type_id = '1'
304μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4765' and field_id = '107'
443μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4765'
287μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '108' and type_id = '1'
323μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4765' and field_id = '108'
816μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4765'
429μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '105' and type_id = '1'
449μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect `value_date` from sra_osrs_property_field_value where pro_id = '4765' and field_id = '105'
551μs856B/administrator/components/com_osproperty/helpers/extrafields.php:2196CopySelect pro_type from sra_osrs_properties where id = '4765'
410μs32.84KB/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '106' and type_id = '1'
364μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect a.* from sra_osrs_extra_field_options as a inner join sra_osrs_property_field_opt_value as b on b.oid = a.id where b.pid = '4765' and b.fid = '106'
463μs1008B/administrator/components/com_osproperty/helpers/extrafields.php:2298Copyselect count(id) from sra_osrs_photos where pro_id = '4765'
349μs856B/components/com_osproperty/classes/listing.php:3226Copyselect image from sra_osrs_photos where pro_id = '4765' order by ordering limit 1
417μs856B/components/com_osproperty/classes/listing.php:3230CopySelect * from sra_osrs_photos where pro_id = '4765'
408μs1.2KB/components/com_osproperty/classes/listing.php:3251CopySelect count(id) from sra_osrs_comments where pro_id = '4765'
292μs856B/components/com_osproperty/classes/listing.php:3298CopySelect count(id) from sra_osrs_properties where pro_alias like '188-world-of-tennis-sq' and id <> '4764'
494μs856B/components/com_osproperty/helpers/helper.php:2016CopySelect count(id) from sra_osrs_properties where pro_alias like '188-world-of-tennis-sq' and id <> '4764'
447μs856B/components/com_osproperty/helpers/helper.php:2016CopySELECT id, category_name as category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4764")
518μs912B/components/com_osproperty/helpers/helper.php:3264CopySELECT id
FROM sra_menu
WHERE link LIKE "%index.php?option=com_osproperty%" and ( `link` LIKE "%category_listing%" or `link` LIKE "%lcategory%" ) AND published = 1 and id in (129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138) AND `access` IN (1,5)
ORDER BY access
409μs840B/components/com_osproperty/helpers/route.php:462CopySELECT category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4764")
457μs856B/components/com_osproperty/helpers/helper.php:3242CopySELECT *
FROM sra_osrs_property_open
WHERE pid='4764' and end_to > '2025-08-14 01:59:02'
ORDER BY start_from
314μs1008B/components/com_osproperty/classes/listing.php:3172CopySelect * from sra_osrs_comments where pro_id = '4764' and published = '1' order by created_on desc
340μs2.27KB/components/com_osproperty/classes/listing.php:3195CopySelect pro_type from sra_osrs_properties where id = '4764'
309μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '107' and type_id = '1'
380μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4764' and field_id = '107'
666μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4764'
301μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '108' and type_id = '1'
340μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4764' and field_id = '108'
495μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4764'
304μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '105' and type_id = '1'
339μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect `value_date` from sra_osrs_property_field_value where pro_id = '4764' and field_id = '105'
409μs856B/administrator/components/com_osproperty/helpers/extrafields.php:2196CopySelect pro_type from sra_osrs_properties where id = '4764'
315μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '106' and type_id = '1'
338μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect a.* from sra_osrs_extra_field_options as a inner join sra_osrs_property_field_opt_value as b on b.oid = a.id where b.pid = '4764' and b.fid = '106'
452μs1008B/administrator/components/com_osproperty/helpers/extrafields.php:2298Copyselect count(id) from sra_osrs_photos where pro_id = '4764'
353μs856B/components/com_osproperty/classes/listing.php:3226Copyselect image from sra_osrs_photos where pro_id = '4764' order by ordering limit 1
405μs856B/components/com_osproperty/classes/listing.php:3230CopySelect * from sra_osrs_photos where pro_id = '4764'
398μs1.2KB/components/com_osproperty/classes/listing.php:3251CopySelect count(id) from sra_osrs_comments where pro_id = '4764'
298μs856B/components/com_osproperty/classes/listing.php:3298CopySelect count(id) from sra_osrs_properties where pro_alias like '1206-e-13th-st' and id <> '4763'
523μs856B/components/com_osproperty/helpers/helper.php:2016CopySelect count(id) from sra_osrs_properties where pro_alias like '1206-e-13th-st' and id <> '4763'
451μs856B/components/com_osproperty/helpers/helper.php:2016CopySELECT id, category_name as category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4763")
554μs912B/components/com_osproperty/helpers/helper.php:3264CopySELECT id
FROM sra_menu
WHERE link LIKE "%index.php?option=com_osproperty%" and ( `link` LIKE "%category_listing%" or `link` LIKE "%lcategory%" ) AND published = 1 and id in (129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138) AND `access` IN (1,5)
ORDER BY access
413μs840B/components/com_osproperty/helpers/route.php:462CopySELECT category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4763")
454μs856B/components/com_osproperty/helpers/helper.php:3242CopySELECT *
FROM sra_osrs_property_open
WHERE pid='4763' and end_to > '2025-08-14 01:59:02'
ORDER BY start_from
328μs1008B/components/com_osproperty/classes/listing.php:3172CopySelect * from sra_osrs_comments where pro_id = '4763' and published = '1' order by created_on desc
329μs2.27KB/components/com_osproperty/classes/listing.php:3195CopySelect pro_type from sra_osrs_properties where id = '4763'
301μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '107' and type_id = '1'
334μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4763' and field_id = '107'
469μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4763'
306μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '108' and type_id = '1'
337μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4763' and field_id = '108'
453μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4763'
302μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '105' and type_id = '1'
334μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect `value_date` from sra_osrs_property_field_value where pro_id = '4763' and field_id = '105'
413μs856B/administrator/components/com_osproperty/helpers/extrafields.php:2196CopySelect pro_type from sra_osrs_properties where id = '4763'
299μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '106' and type_id = '1'
337μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect a.* from sra_osrs_extra_field_options as a inner join sra_osrs_property_field_opt_value as b on b.oid = a.id where b.pid = '4763' and b.fid = '106'
474μs1008B/administrator/components/com_osproperty/helpers/extrafields.php:2298Copyselect count(id) from sra_osrs_photos where pro_id = '4763'
340μs856B/components/com_osproperty/classes/listing.php:3226Copyselect image from sra_osrs_photos where pro_id = '4763' order by ordering limit 1
386μs856B/components/com_osproperty/classes/listing.php:3230CopySelect * from sra_osrs_photos where pro_id = '4763'
382μs1.2KB/components/com_osproperty/classes/listing.php:3251CopySelect count(id) from sra_osrs_comments where pro_id = '4763'
287μs856B/components/com_osproperty/classes/listing.php:3298CopySelect count(id) from sra_osrs_properties where pro_alias like '5800-taylorcrest-dr' and id <> '4762'
508μs856B/components/com_osproperty/helpers/helper.php:2016CopySelect count(id) from sra_osrs_properties where pro_alias like '5800-taylorcrest-dr' and id <> '4762'
451μs856B/components/com_osproperty/helpers/helper.php:2016CopySELECT id, category_name as category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4762")
564μs912B/components/com_osproperty/helpers/helper.php:3264CopySELECT id
FROM sra_menu
WHERE link LIKE "%index.php?option=com_osproperty%" and ( `link` LIKE "%category_listing%" or `link` LIKE "%lcategory%" ) AND published = 1 and id in (129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138) AND `access` IN (1,5)
ORDER BY access
424μs840B/components/com_osproperty/helpers/route.php:462CopySELECT category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4762")
445μs856B/components/com_osproperty/helpers/helper.php:3242CopySELECT *
FROM sra_osrs_property_open
WHERE pid='4762' and end_to > '2025-08-14 01:59:02'
ORDER BY start_from
319μs1008B/components/com_osproperty/classes/listing.php:3172CopySelect * from sra_osrs_comments where pro_id = '4762' and published = '1' order by created_on desc
337μs2.27KB/components/com_osproperty/classes/listing.php:3195CopySelect pro_type from sra_osrs_properties where id = '4762'
366μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '107' and type_id = '4'
342μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4762' and field_id = '107'
478μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4762'
298μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '108' and type_id = '4'
336μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4762' and field_id = '108'
454μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4762'
357μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '105' and type_id = '4'
340μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect `value_date` from sra_osrs_property_field_value where pro_id = '4762' and field_id = '105'
450μs856B/administrator/components/com_osproperty/helpers/extrafields.php:2196CopySelect pro_type from sra_osrs_properties where id = '4762'
303μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '106' and type_id = '4'
343μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect a.* from sra_osrs_extra_field_options as a inner join sra_osrs_property_field_opt_value as b on b.oid = a.id where b.pid = '4762' and b.fid = '106'
461μs1008B/administrator/components/com_osproperty/helpers/extrafields.php:2298Copyselect count(id) from sra_osrs_photos where pro_id = '4762'
527μs856B/components/com_osproperty/classes/listing.php:3226Copyselect image from sra_osrs_photos where pro_id = '4762' order by ordering limit 1
409μs856B/components/com_osproperty/classes/listing.php:3230CopySelect * from sra_osrs_photos where pro_id = '4762'
387μs1.2KB/components/com_osproperty/classes/listing.php:3251CopySelect count(id) from sra_osrs_comments where pro_id = '4762'
285μs856B/components/com_osproperty/classes/listing.php:3298CopySelect count(id) from sra_osrs_properties where pro_alias like '225-jates-field-bnd' and id <> '4761'
512μs856B/components/com_osproperty/helpers/helper.php:2016CopySelect count(id) from sra_osrs_properties where pro_alias like '225-jates-field-bnd' and id <> '4761'
513μs856B/components/com_osproperty/helpers/helper.php:2016CopySELECT id, category_name as category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4761")
527μs912B/components/com_osproperty/helpers/helper.php:3264CopySELECT id
FROM sra_menu
WHERE link LIKE "%index.php?option=com_osproperty%" and ( `link` LIKE "%category_listing%" or `link` LIKE "%lcategory%" ) AND published = 1 and id in (129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138) AND `access` IN (1,5)
ORDER BY access
417μs840B/components/com_osproperty/helpers/route.php:462CopySELECT category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4761")
446μs856B/components/com_osproperty/helpers/helper.php:3242CopySELECT *
FROM sra_osrs_property_open
WHERE pid='4761' and end_to > '2025-08-14 01:59:02'
ORDER BY start_from
327μs1008B/components/com_osproperty/classes/listing.php:3172CopySelect * from sra_osrs_comments where pro_id = '4761' and published = '1' order by created_on desc
388μs2.27KB/components/com_osproperty/classes/listing.php:3195CopySelect pro_type from sra_osrs_properties where id = '4761'
341μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '107' and type_id = '1'
341μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4761' and field_id = '107'
471μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4761'
300μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '108' and type_id = '1'
336μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4761' and field_id = '108'
513μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4761'
300μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '105' and type_id = '1'
338μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect `value_date` from sra_osrs_property_field_value where pro_id = '4761' and field_id = '105'
405μs856B/administrator/components/com_osproperty/helpers/extrafields.php:2196CopySelect pro_type from sra_osrs_properties where id = '4761'
298μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '106' and type_id = '1'
331μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect a.* from sra_osrs_extra_field_options as a inner join sra_osrs_property_field_opt_value as b on b.oid = a.id where b.pid = '4761' and b.fid = '106'
499μs1008B/administrator/components/com_osproperty/helpers/extrafields.php:2298Copyselect count(id) from sra_osrs_photos where pro_id = '4761'
342μs856B/components/com_osproperty/classes/listing.php:3226Copyselect image from sra_osrs_photos where pro_id = '4761' order by ordering limit 1
397μs856B/components/com_osproperty/classes/listing.php:3230CopySelect * from sra_osrs_photos where pro_id = '4761'
382μs1.2KB/components/com_osproperty/classes/listing.php:3251CopySelect count(id) from sra_osrs_comments where pro_id = '4761'
288μs856B/components/com_osproperty/classes/listing.php:3298CopySelect count(id) from sra_osrs_properties where pro_alias like '12106-waterford-run-way' and id <> '4760'
507μs856B/components/com_osproperty/helpers/helper.php:2016CopySelect count(id) from sra_osrs_properties where pro_alias like '12106-waterford-run-way' and id <> '4760'
442μs856B/components/com_osproperty/helpers/helper.php:2016CopySELECT id, category_name as category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4760")
503μs912B/components/com_osproperty/helpers/helper.php:3264CopySELECT id
FROM sra_menu
WHERE link LIKE "%index.php?option=com_osproperty%" and ( `link` LIKE "%category_listing%" or `link` LIKE "%lcategory%" ) AND published = 1 and id in (129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138) AND `access` IN (1,5)
ORDER BY access
412μs840B/components/com_osproperty/helpers/route.php:462CopySELECT category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4760")
502μs856B/components/com_osproperty/helpers/helper.php:3242CopySELECT *
FROM sra_osrs_property_open
WHERE pid='4760' and end_to > '2025-08-14 01:59:02'
ORDER BY start_from
321μs1008B/components/com_osproperty/classes/listing.php:3172CopySelect * from sra_osrs_comments where pro_id = '4760' and published = '1' order by created_on desc
327μs2.27KB/components/com_osproperty/classes/listing.php:3195CopySelect pro_type from sra_osrs_properties where id = '4760'
295μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '107' and type_id = '1'
339μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4760' and field_id = '107'
470μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4760'
299μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '108' and type_id = '1'
375μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4760' and field_id = '108'
457μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4760'
293μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '105' and type_id = '1'
338μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect `value_date` from sra_osrs_property_field_value where pro_id = '4760' and field_id = '105'
454μs856B/administrator/components/com_osproperty/helpers/extrafields.php:2196CopySelect pro_type from sra_osrs_properties where id = '4760'
295μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '106' and type_id = '1'
381μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect a.* from sra_osrs_extra_field_options as a inner join sra_osrs_property_field_opt_value as b on b.oid = a.id where b.pid = '4760' and b.fid = '106'
444μs1008B/administrator/components/com_osproperty/helpers/extrafields.php:2298Copyselect count(id) from sra_osrs_photos where pro_id = '4760'
636μs856B/components/com_osproperty/classes/listing.php:3226Copyselect image from sra_osrs_photos where pro_id = '4760' order by ordering limit 1
391μs856B/components/com_osproperty/classes/listing.php:3230CopySelect * from sra_osrs_photos where pro_id = '4760'
382μs1.2KB/components/com_osproperty/classes/listing.php:3251CopySelect count(id) from sra_osrs_comments where pro_id = '4760'
334μs856B/components/com_osproperty/classes/listing.php:3298CopySelect count(id) from sra_osrs_properties where pro_alias like '240-mccrae-dr' and id <> '4759'
465μs856B/components/com_osproperty/helpers/helper.php:2016CopySelect count(id) from sra_osrs_properties where pro_alias like '240-mccrae-dr' and id <> '4759'
445μs856B/components/com_osproperty/helpers/helper.php:2016CopySELECT id, category_name as category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4759")
480μs912B/components/com_osproperty/helpers/helper.php:3264CopySELECT id
FROM sra_menu
WHERE link LIKE "%index.php?option=com_osproperty%" and ( `link` LIKE "%category_listing%" or `link` LIKE "%lcategory%" ) AND published = 1 and id in (129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138) AND `access` IN (1,5)
ORDER BY access
406μs840B/components/com_osproperty/helpers/route.php:462CopySELECT category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4759")
710μs856B/components/com_osproperty/helpers/helper.php:3242CopySELECT *
FROM sra_osrs_property_open
WHERE pid='4759' and end_to > '2025-08-14 01:59:02'
ORDER BY start_from
322μs1008B/components/com_osproperty/classes/listing.php:3172CopySelect * from sra_osrs_comments where pro_id = '4759' and published = '1' order by created_on desc
344μs2.27KB/components/com_osproperty/classes/listing.php:3195CopySelect pro_type from sra_osrs_properties where id = '4759'
296μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '107' and type_id = '4'
334μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4759' and field_id = '107'
497μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4759'
299μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '108' and type_id = '4'
331μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4759' and field_id = '108'
450μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4759'
298μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '105' and type_id = '4'
333μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect `value_date` from sra_osrs_property_field_value where pro_id = '4759' and field_id = '105'
411μs856B/administrator/components/com_osproperty/helpers/extrafields.php:2196CopySelect pro_type from sra_osrs_properties where id = '4759'
292μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '106' and type_id = '4'
333μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect a.* from sra_osrs_extra_field_options as a inner join sra_osrs_property_field_opt_value as b on b.oid = a.id where b.pid = '4759' and b.fid = '106'
439μs1008B/administrator/components/com_osproperty/helpers/extrafields.php:2298Copyselect count(id) from sra_osrs_photos where pro_id = '4759'
350μs856B/components/com_osproperty/classes/listing.php:3226Copyselect image from sra_osrs_photos where pro_id = '4759' order by ordering limit 1
375μs856B/components/com_osproperty/classes/listing.php:3230CopySelect * from sra_osrs_photos where pro_id = '4759'
421μs1.2KB/components/com_osproperty/classes/listing.php:3251CopySelect count(id) from sra_osrs_comments where pro_id = '4759'
287μs856B/components/com_osproperty/classes/listing.php:3298CopySelect count(id) from sra_osrs_properties where pro_alias like '8013-doe-meadow-dr' and id <> '4758'
473μs856B/components/com_osproperty/helpers/helper.php:2016CopySelect count(id) from sra_osrs_properties where pro_alias like '8013-doe-meadow-dr' and id <> '4758'
451μs856B/components/com_osproperty/helpers/helper.php:2016CopySELECT id, category_name as category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4758")
469μs912B/components/com_osproperty/helpers/helper.php:3264CopySELECT id
FROM sra_menu
WHERE link LIKE "%index.php?option=com_osproperty%" and ( `link` LIKE "%category_listing%" or `link` LIKE "%lcategory%" ) AND published = 1 and id in (129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138) AND `access` IN (1,5)
ORDER BY access
438μs840B/components/com_osproperty/helpers/route.php:462CopySELECT category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4758")
451μs856B/components/com_osproperty/helpers/helper.php:3242CopySELECT *
FROM sra_osrs_property_open
WHERE pid='4758' and end_to > '2025-08-14 01:59:02'
ORDER BY start_from
321μs1008B/components/com_osproperty/classes/listing.php:3172CopySelect * from sra_osrs_comments where pro_id = '4758' and published = '1' order by created_on desc
334μs2.27KB/components/com_osproperty/classes/listing.php:3195CopySelect pro_type from sra_osrs_properties where id = '4758'
327μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '107' and type_id = '1'
416μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4758' and field_id = '107'
670μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4758'
296μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '108' and type_id = '1'
340μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4758' and field_id = '108'
452μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4758'
298μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '105' and type_id = '1'
339μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect `value_date` from sra_osrs_property_field_value where pro_id = '4758' and field_id = '105'
416μs856B/administrator/components/com_osproperty/helpers/extrafields.php:2196CopySelect pro_type from sra_osrs_properties where id = '4758'
294μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '106' and type_id = '1'
332μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect a.* from sra_osrs_extra_field_options as a inner join sra_osrs_property_field_opt_value as b on b.oid = a.id where b.pid = '4758' and b.fid = '106'
446μs1008B/administrator/components/com_osproperty/helpers/extrafields.php:2298Copyselect count(id) from sra_osrs_photos where pro_id = '4758'
343μs856B/components/com_osproperty/classes/listing.php:3226Copyselect image from sra_osrs_photos where pro_id = '4758' order by ordering limit 1
446μs856B/components/com_osproperty/classes/listing.php:3230CopySelect * from sra_osrs_photos where pro_id = '4758'
397μs1.2KB/components/com_osproperty/classes/listing.php:3251CopySelect count(id) from sra_osrs_comments where pro_id = '4758'
291μs856B/components/com_osproperty/classes/listing.php:3298CopySelect count(id) from sra_osrs_properties where pro_alias like '115-lafayette-st' and id <> '4757'
550μs856B/components/com_osproperty/helpers/helper.php:2016CopySelect count(id) from sra_osrs_properties where pro_alias like '115-lafayette-st' and id <> '4757'
433μs856B/components/com_osproperty/helpers/helper.php:2016CopySELECT id, category_name as category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4757")
591μs912B/components/com_osproperty/helpers/helper.php:3264CopySELECT id
FROM sra_menu
WHERE link LIKE "%index.php?option=com_osproperty%" and ( `link` LIKE "%category_listing%" or `link` LIKE "%lcategory%" ) AND published = 1 and id in (129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138) AND `access` IN (1,5)
ORDER BY access
456μs840B/components/com_osproperty/helpers/route.php:462CopySELECT category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4757")
497μs856B/components/com_osproperty/helpers/helper.php:3242CopySELECT *
FROM sra_osrs_property_open
WHERE pid='4757' and end_to > '2025-08-14 01:59:02'
ORDER BY start_from
362μs1008B/components/com_osproperty/classes/listing.php:3172CopySelect * from sra_osrs_comments where pro_id = '4757' and published = '1' order by created_on desc
415μs2.27KB/components/com_osproperty/classes/listing.php:3195CopySelect pro_type from sra_osrs_properties where id = '4757'
389μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '107' and type_id = '1'
356μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4757' and field_id = '107'
493μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4757'
297μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '108' and type_id = '1'
348μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4757' and field_id = '108'
452μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4757'
308μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '105' and type_id = '1'
458μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect `value_date` from sra_osrs_property_field_value where pro_id = '4757' and field_id = '105'
424μs856B/administrator/components/com_osproperty/helpers/extrafields.php:2196CopySelect pro_type from sra_osrs_properties where id = '4757'
299μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '106' and type_id = '1'
330μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect a.* from sra_osrs_extra_field_options as a inner join sra_osrs_property_field_opt_value as b on b.oid = a.id where b.pid = '4757' and b.fid = '106'
485μs1008B/administrator/components/com_osproperty/helpers/extrafields.php:2298Copyselect count(id) from sra_osrs_photos where pro_id = '4757'
346μs856B/components/com_osproperty/classes/listing.php:3226Copyselect image from sra_osrs_photos where pro_id = '4757' order by ordering limit 1
388μs856B/components/com_osproperty/classes/listing.php:3230CopySelect * from sra_osrs_photos where pro_id = '4757'
386μs1.2KB/components/com_osproperty/classes/listing.php:3251CopySelect count(id) from sra_osrs_comments where pro_id = '4757'
311μs856B/components/com_osproperty/classes/listing.php:3298CopySelect count(id) from sra_osrs_properties where pro_alias like '12166-metric-blvd-3011' and id <> '4756'
497μs856B/components/com_osproperty/helpers/helper.php:2016CopySelect count(id) from sra_osrs_properties where pro_alias like '12166-metric-blvd-3011' and id <> '4756'
475μs856B/components/com_osproperty/helpers/helper.php:2016CopySELECT id, category_name as category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4756")
523μs912B/components/com_osproperty/helpers/helper.php:3264CopySELECT id
FROM sra_menu
WHERE link LIKE "%index.php?option=com_osproperty%" and ( `link` LIKE "%category_listing%" or `link` LIKE "%lcategory%" ) AND published = 1 and id in (129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138) AND `access` IN (1,5)
ORDER BY access
451μs840B/components/com_osproperty/helpers/route.php:462CopySELECT category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4756")
530μs856B/components/com_osproperty/helpers/helper.php:3242CopySELECT *
FROM sra_osrs_property_open
WHERE pid='4756' and end_to > '2025-08-14 01:59:02'
ORDER BY start_from
327μs1008B/components/com_osproperty/classes/listing.php:3172CopySelect * from sra_osrs_comments where pro_id = '4756' and published = '1' order by created_on desc
339μs2.27KB/components/com_osproperty/classes/listing.php:3195CopySelect pro_type from sra_osrs_properties where id = '4756'
308μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '107' and type_id = '1'
342μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4756' and field_id = '107'
470μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4756'
300μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '108' and type_id = '1'
336μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4756' and field_id = '108'
535μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4756'
299μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '105' and type_id = '1'
371μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect `value_date` from sra_osrs_property_field_value where pro_id = '4756' and field_id = '105'
465μs856B/administrator/components/com_osproperty/helpers/extrafields.php:2196CopySelect pro_type from sra_osrs_properties where id = '4756'
305μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '106' and type_id = '1'
384μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect a.* from sra_osrs_extra_field_options as a inner join sra_osrs_property_field_opt_value as b on b.oid = a.id where b.pid = '4756' and b.fid = '106'
455μs1008B/administrator/components/com_osproperty/helpers/extrafields.php:2298Copyselect count(id) from sra_osrs_photos where pro_id = '4756'
369μs856B/components/com_osproperty/classes/listing.php:3226Copyselect image from sra_osrs_photos where pro_id = '4756' order by ordering limit 1
400μs856B/components/com_osproperty/classes/listing.php:3230CopySelect * from sra_osrs_photos where pro_id = '4756'
394μs1.2KB/components/com_osproperty/classes/listing.php:3251CopySelect count(id) from sra_osrs_comments where pro_id = '4756'
321μs856B/components/com_osproperty/classes/listing.php:3298CopySelect count(id) from sra_osrs_properties where pro_alias like '510-drakes-cv' and id <> '4755'
511μs856B/components/com_osproperty/helpers/helper.php:2016CopySelect count(id) from sra_osrs_properties where pro_alias like '510-drakes-cv' and id <> '4755'
455μs856B/components/com_osproperty/helpers/helper.php:2016CopySELECT id, category_name as category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4755")
521μs912B/components/com_osproperty/helpers/helper.php:3264CopySELECT id
FROM sra_menu
WHERE link LIKE "%index.php?option=com_osproperty%" and ( `link` LIKE "%category_listing%" or `link` LIKE "%lcategory%" ) AND published = 1 and id in (129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138,129,136,137,138) AND `access` IN (1,5)
ORDER BY access
449μs840B/components/com_osproperty/helpers/route.php:462CopySELECT category_name
FROM sra_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from sra_osrs_property_categories where pid ="4755")
521μs856B/components/com_osproperty/helpers/helper.php:3242CopySELECT *
FROM sra_osrs_property_open
WHERE pid='4755' and end_to > '2025-08-14 01:59:02'
ORDER BY start_from
344μs1008B/components/com_osproperty/classes/listing.php:3172CopySelect * from sra_osrs_comments where pro_id = '4755' and published = '1' order by created_on desc
347μs2.27KB/components/com_osproperty/classes/listing.php:3195CopySelect pro_type from sra_osrs_properties where id = '4755'
317μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '107' and type_id = '1'
390μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4755' and field_id = '107'
478μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4755'
298μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '108' and type_id = '1'
362μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect * from sra_osrs_property_field_value where pro_id = '4755' and field_id = '108'
453μs1.19KB/administrator/components/com_osproperty/helpers/extrafields.php:2217CopySelect pro_type from sra_osrs_properties where id = '4755'
298μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '105' and type_id = '1'
336μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect `value_date` from sra_osrs_property_field_value where pro_id = '4755' and field_id = '105'
448μs856B/administrator/components/com_osproperty/helpers/extrafields.php:2196CopySelect pro_type from sra_osrs_properties where id = '4755'
293μs856B/components/com_osproperty/helpers/helper.php:6007CopySelect count(id) from sra_osrs_extra_field_types where fid = '106' and type_id = '1'
327μs856B/components/com_osproperty/helpers/helper.php:6010CopySelect a.* from sra_osrs_extra_field_options as a inner join sra_osrs_property_field_opt_value as b on b.oid = a.id where b.pid = '4755' and b.fid = '106'
437μs1008B/administrator/components/com_osproperty/helpers/extrafields.php:2298Copyselect count(id) from sra_osrs_photos where pro_id = '4755'
347μs856B/components/com_osproperty/classes/listing.php:3226Copyselect image from sra_osrs_photos where pro_id = '4755' order by ordering limit 1
392μs856B/components/com_osproperty/classes/listing.php:3230CopySelect * from sra_osrs_photos where pro_id = '4755'
381μs1.2KB/components/com_osproperty/classes/listing.php:3251CopySelect count(id) from sra_osrs_comments where pro_id = '4755'
283μs856B/components/com_osproperty/classes/listing.php:3298CopySelect id as value,type_name as text from sra_osrs_types where published = '1' order by ordering
372μs992B/components/com_osproperty/classes/listing.php:3343CopySelect * from sra_osrs_categories where published = '1' order by ordering
379μs2.22KB/components/com_osproperty/helpers/helper.php:3131CopySelect id as value,state_name as text, state_name from sra_osrs_states where published = 1 and country_id = '194' order by state_name
1.02ms1.44KB/components/com_osproperty/helpers/common.php:206CopySelect a.id as value, a.name as text from sra_osrs_agents as a inner join sra_users as b on b.id = a.user_id where a.published = '1' order by a.name
633μs896B/components/com_osproperty/classes/listing.php:3418CopySelect * from sra_osrs_themes where published = '1'
429μs2.25KB/components/com_osproperty/helpers/helper.php:4921CopySelect * from sra_osrs_themes where name like 'default'
366μs2.25KB/components/com_osproperty/classes/listing.html.php:853CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from sra_osrs_properties as a inner join sra_osrs_agents as b on b.id = a.agent_id left join sra_osrs_company_agents as c on c.agent_id = b.id where a.id = '4774'
440μs1.22KB/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM sra_osrs_property_categories
WHERE pid="4774"
310μs856B/components/com_osproperty/helpers/helper.php:3221CopySelect id from sra_menu where published = '1' and ((`link` like '%view=ldetails&id=4774%') or (`link` like '%view=ldetails&id=4774%')) and `access` IN (1,5)
419μs840B/components/com_osproperty/helpers/route.php:118CopySelect * from sra_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
668μs4.09KB/components/com_osproperty/helpers/route.php:125CopySelect count(id) from sra_menu where id = '129' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=4774%') and `access` IN (1,5)
297μs856B/components/com_osproperty/helpers/route.php:599CopySelect * from sra_osrs_properties where id = '4774'
636μs23.09KB/components/com_osproperty/router.php:376CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "0dda787b90f7027e018aae9004fd9f7d"
11.55ms856B/components/com_osproperty/router.php:868CopySelect currency_symbol from sra_osrs_currencies where id = '57'
283μs856B/components/com_osproperty/helpers/common.php:1563CopySelect fieldvalue from sra_osrs_configuration where fieldname like 'general_currency_money_format'
351μs856B/components/com_osproperty/helpers/helper.php:7278CopySelect id, pro_alias, pro_name from sra_osrs_properties where id = '4774'
361μs976B/components/com_osproperty/router.php:784CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "88449e607c7a7517bbafe2beb7f90276"
12.3ms856B/components/com_osproperty/router.php:868CopySelect city from sra_osrs_cities where id = '25353'
288μs856B/components/com_osproperty/helpers/helper.php:1597CopySelect state_code from sra_osrs_states where id = '44'
365μs856B/components/com_osproperty/helpers/helper.php:1612CopySelect id, alias, name from sra_osrs_agents where id = '2'
275μs64.95KB/components/com_osproperty/router.php:284CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "0f9ed798b189ddc71a864a22bb49468b"
12.43ms856B/components/com_osproperty/router.php:868CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from sra_osrs_properties as a inner join sra_osrs_agents as b on b.id = a.agent_id left join sra_osrs_company_agents as c on c.agent_id = b.id where a.id = '4773'
463μs1.22KB/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM sra_osrs_property_categories
WHERE pid="4773"
335μs856B/components/com_osproperty/helpers/helper.php:3221CopySelect id from sra_menu where published = '1' and ((`link` like '%view=ldetails&id=4773%') or (`link` like '%view=ldetails&id=4773%')) and `access` IN (1,5)
540μs840B/components/com_osproperty/helpers/route.php:118CopySelect * from sra_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
631μs4.09KB/components/com_osproperty/helpers/route.php:125CopySelect count(id) from sra_menu where id = '129' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=4773%') and `access` IN (1,5)
394μs856B/components/com_osproperty/helpers/route.php:599CopySelect * from sra_osrs_properties where id = '4773'
726μs23.09KB/components/com_osproperty/router.php:376CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "31ee05bc6f06f390c75175f77d349c08"
11.13ms856B/components/com_osproperty/router.php:868CopySelect id, pro_alias, pro_name from sra_osrs_properties where id = '4773'
304μs976B/components/com_osproperty/router.php:784CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "42d87eb63957b377f8fe9ae2f83de5d5"
11.08ms856B/components/com_osproperty/router.php:868CopySelect city from sra_osrs_cities where id = '0'
267μs840B/components/com_osproperty/helpers/helper.php:1597CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from sra_osrs_properties as a inner join sra_osrs_agents as b on b.id = a.agent_id left join sra_osrs_company_agents as c on c.agent_id = b.id where a.id = '4772'
416μs1.22KB/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM sra_osrs_property_categories
WHERE pid="4772"
325μs856B/components/com_osproperty/helpers/helper.php:3221CopySelect id from sra_menu where published = '1' and ((`link` like '%view=ldetails&id=4772%') or (`link` like '%view=ldetails&id=4772%')) and `access` IN (1,5)
439μs840B/components/com_osproperty/helpers/route.php:118CopySelect * from sra_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
943μs4.09KB/components/com_osproperty/helpers/route.php:125CopySelect count(id) from sra_menu where id = '129' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=4772%') and `access` IN (1,5)
297μs856B/components/com_osproperty/helpers/route.php:599CopySelect * from sra_osrs_properties where id = '4772'
677μs23.09KB/components/com_osproperty/router.php:376CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "7293d87243ea1533c0a745782e6179bd"
11.29ms856B/components/com_osproperty/router.php:868CopySelect id, pro_alias, pro_name from sra_osrs_properties where id = '4772'
295μs976B/components/com_osproperty/router.php:784CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "8d09e29fac247c1486fc713b024a3c5f"
11.4ms856B/components/com_osproperty/router.php:868CopySelect city from sra_osrs_cities where id = '25386'
411μs856B/components/com_osproperty/helpers/helper.php:1597CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from sra_osrs_properties as a inner join sra_osrs_agents as b on b.id = a.agent_id left join sra_osrs_company_agents as c on c.agent_id = b.id where a.id = '4771'
578μs1.22KB/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM sra_osrs_property_categories
WHERE pid="4771"
451μs856B/components/com_osproperty/helpers/helper.php:3221CopySelect id from sra_menu where published = '1' and ((`link` like '%view=ldetails&id=4771%') or (`link` like '%view=ldetails&id=4771%')) and `access` IN (1,5)
482μs840B/components/com_osproperty/helpers/route.php:118CopySelect * from sra_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
615μs4.09KB/components/com_osproperty/helpers/route.php:125CopySelect count(id) from sra_menu where id = '129' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=4771%') and `access` IN (1,5)
308μs856B/components/com_osproperty/helpers/route.php:599CopySelect * from sra_osrs_properties where id = '4771'
648μs23.09KB/components/com_osproperty/router.php:376CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "9a3a3b9f18bcdeef8f89dc0d41c9714f"
11.01ms856B/components/com_osproperty/router.php:868CopySelect id, pro_alias, pro_name from sra_osrs_properties where id = '4771'
309μs976B/components/com_osproperty/router.php:784CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "c034208504d14c7c017d4cfdf4e5f399"
11.14ms856B/components/com_osproperty/router.php:868CopySelect city from sra_osrs_cities where id = '24677'
367μs856B/components/com_osproperty/helpers/helper.php:1597CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from sra_osrs_properties as a inner join sra_osrs_agents as b on b.id = a.agent_id left join sra_osrs_company_agents as c on c.agent_id = b.id where a.id = '4770'
412μs1.22KB/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM sra_osrs_property_categories
WHERE pid="4770"
319μs856B/components/com_osproperty/helpers/helper.php:3221CopySelect id from sra_menu where published = '1' and ((`link` like '%view=ldetails&id=4770%') or (`link` like '%view=ldetails&id=4770%')) and `access` IN (1,5)
460μs840B/components/com_osproperty/helpers/route.php:118CopySelect * from sra_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
604μs4.09KB/components/com_osproperty/helpers/route.php:125CopySelect count(id) from sra_menu where id = '129' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=4770%') and `access` IN (1,5)
362μs856B/components/com_osproperty/helpers/route.php:599CopySelect * from sra_osrs_properties where id = '4770'
611μs23.09KB/components/com_osproperty/router.php:376CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "0ad8895c7fdbb7e037e9e875bdbfe196"
11.39ms856B/components/com_osproperty/router.php:868CopySelect id, pro_alias, pro_name from sra_osrs_properties where id = '4770'
652μs976B/components/com_osproperty/router.php:784CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "2184cea83e615f05cfba8590a693bd8d"
11.47ms856B/components/com_osproperty/router.php:868CopySelect city from sra_osrs_cities where id = '0'
272μs840B/components/com_osproperty/helpers/helper.php:1597CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from sra_osrs_properties as a inner join sra_osrs_agents as b on b.id = a.agent_id left join sra_osrs_company_agents as c on c.agent_id = b.id where a.id = '4769'
410μs1.22KB/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM sra_osrs_property_categories
WHERE pid="4769"
321μs856B/components/com_osproperty/helpers/helper.php:3221CopySelect id from sra_menu where published = '1' and ((`link` like '%view=ldetails&id=4769%') or (`link` like '%view=ldetails&id=4769%')) and `access` IN (1,5)
400μs840B/components/com_osproperty/helpers/route.php:118CopySelect * from sra_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
600μs4.09KB/components/com_osproperty/helpers/route.php:125CopySelect count(id) from sra_menu where id = '129' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=4769%') and `access` IN (1,5)
321μs856B/components/com_osproperty/helpers/route.php:599CopySelect * from sra_osrs_properties where id = '4769'
686μs23.09KB/components/com_osproperty/router.php:376CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "57fa1f59a813b9f2a79070ddfe39eada"
10.99ms856B/components/com_osproperty/router.php:868CopySelect id, pro_alias, pro_name from sra_osrs_properties where id = '4769'
293μs976B/components/com_osproperty/router.php:784CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "0d32a87cb524f311565b7f23a39d2458"
12.23ms856B/components/com_osproperty/router.php:868CopySelect city from sra_osrs_cities where id = '25316'
348μs856B/components/com_osproperty/helpers/helper.php:1597CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from sra_osrs_properties as a inner join sra_osrs_agents as b on b.id = a.agent_id left join sra_osrs_company_agents as c on c.agent_id = b.id where a.id = '4768'
538μs1.22KB/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM sra_osrs_property_categories
WHERE pid="4768"
469μs856B/components/com_osproperty/helpers/helper.php:3221CopySelect id from sra_menu where published = '1' and ((`link` like '%view=ldetails&id=4768%') or (`link` like '%view=ldetails&id=4768%')) and `access` IN (1,5)
536μs840B/components/com_osproperty/helpers/route.php:118CopySelect * from sra_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
755μs4.09KB/components/com_osproperty/helpers/route.php:125CopySelect count(id) from sra_menu where id = '129' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=4768%') and `access` IN (1,5)
386μs856B/components/com_osproperty/helpers/route.php:599CopySelect * from sra_osrs_properties where id = '4768'
700μs23.09KB/components/com_osproperty/router.php:376CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "29ec08771bba8482d30ebed03752bad0"
14.87ms856B/components/com_osproperty/router.php:868CopySelect id, pro_alias, pro_name from sra_osrs_properties where id = '4768'
455μs976B/components/com_osproperty/router.php:784CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "1880200dfd8387392dbb9e7098666848"
11.01ms856B/components/com_osproperty/router.php:868CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from sra_osrs_properties as a inner join sra_osrs_agents as b on b.id = a.agent_id left join sra_osrs_company_agents as c on c.agent_id = b.id where a.id = '4767'
467μs1.22KB/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM sra_osrs_property_categories
WHERE pid="4767"
355μs856B/components/com_osproperty/helpers/helper.php:3221CopySelect id from sra_menu where published = '1' and ((`link` like '%view=ldetails&id=4767%') or (`link` like '%view=ldetails&id=4767%')) and `access` IN (1,5)
475μs840B/components/com_osproperty/helpers/route.php:118CopySelect * from sra_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
621μs4.09KB/components/com_osproperty/helpers/route.php:125CopySelect count(id) from sra_menu where id = '129' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=4767%') and `access` IN (1,5)
295μs856B/components/com_osproperty/helpers/route.php:599CopySelect * from sra_osrs_properties where id = '4767'
753μs23.09KB/components/com_osproperty/router.php:376CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "07a5f295adb0188814438141052fa7a3"
10.94ms856B/components/com_osproperty/router.php:868CopySelect id, pro_alias, pro_name from sra_osrs_properties where id = '4767'
306μs976B/components/com_osproperty/router.php:784CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "7e57f8d7e468d18bc2f242eda5a330b4"
11.11ms856B/components/com_osproperty/router.php:868CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from sra_osrs_properties as a inner join sra_osrs_agents as b on b.id = a.agent_id left join sra_osrs_company_agents as c on c.agent_id = b.id where a.id = '4766'
449μs1.22KB/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM sra_osrs_property_categories
WHERE pid="4766"
420μs856B/components/com_osproperty/helpers/helper.php:3221CopySelect id from sra_menu where published = '1' and ((`link` like '%view=ldetails&id=4766%') or (`link` like '%view=ldetails&id=4766%')) and `access` IN (1,5)
420μs840B/components/com_osproperty/helpers/route.php:118CopySelect * from sra_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
604μs4.09KB/components/com_osproperty/helpers/route.php:125CopySelect count(id) from sra_menu where id = '129' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=4766%') and `access` IN (1,5)
312μs856B/components/com_osproperty/helpers/route.php:599CopySelect * from sra_osrs_properties where id = '4766'
660μs23.09KB/components/com_osproperty/router.php:376CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "233c2824e5cab9dd9e9103e0ae15d778"
11.03ms856B/components/com_osproperty/router.php:868CopySelect id, pro_alias, pro_name from sra_osrs_properties where id = '4766'
349μs976B/components/com_osproperty/router.php:784CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "0617e9e47b56cbc002db4ccbb629a115"
11.22ms856B/components/com_osproperty/router.php:868CopySelect city from sra_osrs_cities where id = '24701'
355μs856B/components/com_osproperty/helpers/helper.php:1597CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from sra_osrs_properties as a inner join sra_osrs_agents as b on b.id = a.agent_id left join sra_osrs_company_agents as c on c.agent_id = b.id where a.id = '4765'
419μs1.22KB/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM sra_osrs_property_categories
WHERE pid="4765"
318μs856B/components/com_osproperty/helpers/helper.php:3221CopySelect id from sra_menu where published = '1' and ((`link` like '%view=ldetails&id=4765%') or (`link` like '%view=ldetails&id=4765%')) and `access` IN (1,5)
463μs840B/components/com_osproperty/helpers/route.php:118CopySelect * from sra_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
665μs4.09KB/components/com_osproperty/helpers/route.php:125CopySelect count(id) from sra_menu where id = '129' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=4765%') and `access` IN (1,5)
322μs856B/components/com_osproperty/helpers/route.php:599CopySelect * from sra_osrs_properties where id = '4765'
624μs23.09KB/components/com_osproperty/router.php:376CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "ae80acef1ca06e71d1cabbe00325fc8c"
11.74ms856B/components/com_osproperty/router.php:868CopySelect id, pro_alias, pro_name from sra_osrs_properties where id = '4765'
334μs976B/components/com_osproperty/router.php:784CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "7bb553f13c4b51c7e35c2194c066a8d7"
11.55ms856B/components/com_osproperty/router.php:868CopySelect city from sra_osrs_cities where id = '0'
469μs840B/components/com_osproperty/helpers/helper.php:1597CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from sra_osrs_properties as a inner join sra_osrs_agents as b on b.id = a.agent_id left join sra_osrs_company_agents as c on c.agent_id = b.id where a.id = '4764'
483μs1.22KB/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM sra_osrs_property_categories
WHERE pid="4764"
363μs856B/components/com_osproperty/helpers/helper.php:3221CopySelect id from sra_menu where published = '1' and ((`link` like '%view=ldetails&id=4764%') or (`link` like '%view=ldetails&id=4764%')) and `access` IN (1,5)
457μs840B/components/com_osproperty/helpers/route.php:118CopySelect * from sra_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
610μs4.09KB/components/com_osproperty/helpers/route.php:125CopySelect count(id) from sra_menu where id = '129' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=4764%') and `access` IN (1,5)
292μs856B/components/com_osproperty/helpers/route.php:599CopySelect * from sra_osrs_properties where id = '4764'
623μs23.09KB/components/com_osproperty/router.php:376CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "3a217eb0b3e10714663d238a2b80759a"
10.89ms856B/components/com_osproperty/router.php:868CopySelect id, pro_alias, pro_name from sra_osrs_properties where id = '4764'
306μs976B/components/com_osproperty/router.php:784CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "1908a0d13a92dc1a3ca91ce1e42eeb90"
11.09ms856B/components/com_osproperty/router.php:868CopySelect city from sra_osrs_cities where id = '0'
275μs840B/components/com_osproperty/helpers/helper.php:1597CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from sra_osrs_properties as a inner join sra_osrs_agents as b on b.id = a.agent_id left join sra_osrs_company_agents as c on c.agent_id = b.id where a.id = '4763'
444μs1.22KB/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM sra_osrs_property_categories
WHERE pid="4763"
323μs856B/components/com_osproperty/helpers/helper.php:3221CopySelect id from sra_menu where published = '1' and ((`link` like '%view=ldetails&id=4763%') or (`link` like '%view=ldetails&id=4763%')) and `access` IN (1,5)
414μs840B/components/com_osproperty/helpers/route.php:118CopySelect * from sra_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
681μs4.09KB/components/com_osproperty/helpers/route.php:125CopySelect count(id) from sra_menu where id = '129' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=4763%') and `access` IN (1,5)
299μs856B/components/com_osproperty/helpers/route.php:599CopySelect * from sra_osrs_properties where id = '4763'
617μs23.09KB/components/com_osproperty/router.php:376CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "74833fb5510ee3946bb8d3ba71d43272"
11.41ms856B/components/com_osproperty/router.php:868CopySelect id, pro_alias, pro_name from sra_osrs_properties where id = '4763'
317μs976B/components/com_osproperty/router.php:784CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "d868ebf3e940f22a2e28fb0e526335d2"
11.44ms856B/components/com_osproperty/router.php:868CopySelect city from sra_osrs_cities where id = '25120'
278μs856B/components/com_osproperty/helpers/helper.php:1597CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from sra_osrs_properties as a inner join sra_osrs_agents as b on b.id = a.agent_id left join sra_osrs_company_agents as c on c.agent_id = b.id where a.id = '4762'
488μs1.22KB/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM sra_osrs_property_categories
WHERE pid="4762"
326μs856B/components/com_osproperty/helpers/helper.php:3221CopySelect id from sra_menu where published = '1' and ((`link` like '%view=ldetails&id=4762%') or (`link` like '%view=ldetails&id=4762%')) and `access` IN (1,5)
409μs840B/components/com_osproperty/helpers/route.php:118CopySelect * from sra_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
634μs4.09KB/components/com_osproperty/helpers/route.php:125CopySelect count(id) from sra_menu where id = '129' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=4762%') and `access` IN (1,5)
294μs856B/components/com_osproperty/helpers/route.php:599CopySelect * from sra_osrs_properties where id = '4762'
769μs23.09KB/components/com_osproperty/router.php:376CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "68989a1dcc8338deaf7943a21f3aa7e6"
12.8ms856B/components/com_osproperty/router.php:868CopySelect id, pro_alias, pro_name from sra_osrs_properties where id = '4762'
353μs976B/components/com_osproperty/router.php:784CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "8e472f1537ab250f537375bf807fdd8a"
12.19ms856B/components/com_osproperty/router.php:868CopySelect city from sra_osrs_cities where id = '24677'
315μs856B/components/com_osproperty/helpers/helper.php:1597CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from sra_osrs_properties as a inner join sra_osrs_agents as b on b.id = a.agent_id left join sra_osrs_company_agents as c on c.agent_id = b.id where a.id = '4761'
479μs1.22KB/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM sra_osrs_property_categories
WHERE pid="4761"
358μs856B/components/com_osproperty/helpers/helper.php:3221CopySelect id from sra_menu where published = '1' and ((`link` like '%view=ldetails&id=4761%') or (`link` like '%view=ldetails&id=4761%')) and `access` IN (1,5)
455μs840B/components/com_osproperty/helpers/route.php:118CopySelect * from sra_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
779μs4.09KB/components/com_osproperty/helpers/route.php:125CopySelect count(id) from sra_menu where id = '129' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=4761%') and `access` IN (1,5)
370μs856B/components/com_osproperty/helpers/route.php:599CopySelect * from sra_osrs_properties where id = '4761'
889μs23.09KB/components/com_osproperty/router.php:376CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "c1fe5babeb7482a28daacb114d9f2514"
11.67ms856B/components/com_osproperty/router.php:868CopySelect id, pro_alias, pro_name from sra_osrs_properties where id = '4761'
316μs976B/components/com_osproperty/router.php:784CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "67ec503fcc0991df96a92fd8a3072ef8"
11.47ms856B/components/com_osproperty/router.php:868CopySelect city from sra_osrs_cities where id = '25369'
308μs856B/components/com_osproperty/helpers/helper.php:1597CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from sra_osrs_properties as a inner join sra_osrs_agents as b on b.id = a.agent_id left join sra_osrs_company_agents as c on c.agent_id = b.id where a.id = '4760'
481μs1.22KB/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM sra_osrs_property_categories
WHERE pid="4760"
371μs856B/components/com_osproperty/helpers/helper.php:3221CopySelect id from sra_menu where published = '1' and ((`link` like '%view=ldetails&id=4760%') or (`link` like '%view=ldetails&id=4760%')) and `access` IN (1,5)
453μs840B/components/com_osproperty/helpers/route.php:118CopySelect * from sra_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
727μs4.09KB/components/com_osproperty/helpers/route.php:125CopySelect count(id) from sra_menu where id = '129' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=4760%') and `access` IN (1,5)
313μs856B/components/com_osproperty/helpers/route.php:599CopySelect * from sra_osrs_properties where id = '4760'
729μs23.09KB/components/com_osproperty/router.php:376CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "75727dcbdb87f556df62041e71fb6651"
11.47ms856B/components/com_osproperty/router.php:868CopySelect id, pro_alias, pro_name from sra_osrs_properties where id = '4760'
363μs976B/components/com_osproperty/router.php:784CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "8c10372488d456468cd2e09aed784b8d"
12.93ms856B/components/com_osproperty/router.php:868CopySelect city from sra_osrs_cities where id = '25426'
471μs856B/components/com_osproperty/helpers/helper.php:1597CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from sra_osrs_properties as a inner join sra_osrs_agents as b on b.id = a.agent_id left join sra_osrs_company_agents as c on c.agent_id = b.id where a.id = '4759'
701μs1.22KB/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM sra_osrs_property_categories
WHERE pid="4759"
382μs856B/components/com_osproperty/helpers/helper.php:3221CopySelect id from sra_menu where published = '1' and ((`link` like '%view=ldetails&id=4759%') or (`link` like '%view=ldetails&id=4759%')) and `access` IN (1,5)
495μs840B/components/com_osproperty/helpers/route.php:118CopySelect * from sra_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
696μs4.09KB/components/com_osproperty/helpers/route.php:125CopySelect count(id) from sra_menu where id = '129' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=4759%') and `access` IN (1,5)
328μs856B/components/com_osproperty/helpers/route.php:599CopySelect * from sra_osrs_properties where id = '4759'
1ms23.09KB/components/com_osproperty/router.php:376CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "9ac566bceb9f9eee171e3558c3d0b3c7"
11.77ms856B/components/com_osproperty/router.php:868CopySelect id, pro_alias, pro_name from sra_osrs_properties where id = '4759'
469μs976B/components/com_osproperty/router.php:784CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "897c6afec8a080419b6cb472fc55817e"
12.52ms856B/components/com_osproperty/router.php:868CopySelect city from sra_osrs_cities where id = '25369'
341μs856B/components/com_osproperty/helpers/helper.php:1597CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from sra_osrs_properties as a inner join sra_osrs_agents as b on b.id = a.agent_id left join sra_osrs_company_agents as c on c.agent_id = b.id where a.id = '4758'
508μs1.22KB/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM sra_osrs_property_categories
WHERE pid="4758"
624μs856B/components/com_osproperty/helpers/helper.php:3221CopySelect id from sra_menu where published = '1' and ((`link` like '%view=ldetails&id=4758%') or (`link` like '%view=ldetails&id=4758%')) and `access` IN (1,5)
455μs840B/components/com_osproperty/helpers/route.php:118CopySelect * from sra_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
696μs4.09KB/components/com_osproperty/helpers/route.php:125CopySelect count(id) from sra_menu where id = '129' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=4758%') and `access` IN (1,5)
314μs856B/components/com_osproperty/helpers/route.php:599CopySelect * from sra_osrs_properties where id = '4758'
974μs23.09KB/components/com_osproperty/router.php:376CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "a85a64255019a1d90371dac120f513f7"
12.37ms856B/components/com_osproperty/router.php:868CopySelect id, pro_alias, pro_name from sra_osrs_properties where id = '4758'
371μs976B/components/com_osproperty/router.php:784CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "76d8bf5a1c12ef72c07c05b675357b4b"
11.54ms856B/components/com_osproperty/router.php:868CopySelect city from sra_osrs_cities where id = '24677'
291μs856B/components/com_osproperty/helpers/helper.php:1597CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from sra_osrs_properties as a inner join sra_osrs_agents as b on b.id = a.agent_id left join sra_osrs_company_agents as c on c.agent_id = b.id where a.id = '4757'
447μs1.22KB/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM sra_osrs_property_categories
WHERE pid="4757"
349μs856B/components/com_osproperty/helpers/helper.php:3221CopySelect id from sra_menu where published = '1' and ((`link` like '%view=ldetails&id=4757%') or (`link` like '%view=ldetails&id=4757%')) and `access` IN (1,5)
434μs840B/components/com_osproperty/helpers/route.php:118CopySelect * from sra_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
722μs4.09KB/components/com_osproperty/helpers/route.php:125CopySelect count(id) from sra_menu where id = '129' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=4757%') and `access` IN (1,5)
305μs856B/components/com_osproperty/helpers/route.php:599CopySelect * from sra_osrs_properties where id = '4757'
660μs23.09KB/components/com_osproperty/router.php:376CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "97d3244e6357c42de9b03b643f0861b1"
11.88ms856B/components/com_osproperty/router.php:868CopySelect id, pro_alias, pro_name from sra_osrs_properties where id = '4757'
316μs976B/components/com_osproperty/router.php:784CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "164651f16f7e43a01908ed8d8a5ee384"
11.92ms856B/components/com_osproperty/router.php:868CopySelect city from sra_osrs_cities where id = '25120'
271μs856B/components/com_osproperty/helpers/helper.php:1597CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from sra_osrs_properties as a inner join sra_osrs_agents as b on b.id = a.agent_id left join sra_osrs_company_agents as c on c.agent_id = b.id where a.id = '4756'
442μs1.22KB/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM sra_osrs_property_categories
WHERE pid="4756"
401μs856B/components/com_osproperty/helpers/helper.php:3221CopySelect id from sra_menu where published = '1' and ((`link` like '%view=ldetails&id=4756%') or (`link` like '%view=ldetails&id=4756%')) and `access` IN (1,5)
597μs840B/components/com_osproperty/helpers/route.php:118CopySelect * from sra_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
610μs4.09KB/components/com_osproperty/helpers/route.php:125CopySelect count(id) from sra_menu where id = '129' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=4756%') and `access` IN (1,5)
309μs856B/components/com_osproperty/helpers/route.php:599CopySelect * from sra_osrs_properties where id = '4756'
639μs23.09KB/components/com_osproperty/router.php:376CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "6d002e9ea4af8d95989c2b892c83c9b9"
11.56ms856B/components/com_osproperty/router.php:868CopySelect id, pro_alias, pro_name from sra_osrs_properties where id = '4756'
321μs976B/components/com_osproperty/router.php:784CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "0179ecb9e2277e4cb2fe2adf27184009"
11.74ms856B/components/com_osproperty/router.php:868CopySelect city from sra_osrs_cities where id = '24677'
324μs856B/components/com_osproperty/helpers/helper.php:1597CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from sra_osrs_properties as a inner join sra_osrs_agents as b on b.id = a.agent_id left join sra_osrs_company_agents as c on c.agent_id = b.id where a.id = '4755'
485μs1.22KB/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM sra_osrs_property_categories
WHERE pid="4755"
416μs856B/components/com_osproperty/helpers/helper.php:3221CopySelect id from sra_menu where published = '1' and ((`link` like '%view=ldetails&id=4755%') or (`link` like '%view=ldetails&id=4755%')) and `access` IN (1,5)
433μs840B/components/com_osproperty/helpers/route.php:118CopySelect * from sra_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
622μs4.09KB/components/com_osproperty/helpers/route.php:125CopySelect count(id) from sra_menu where id = '129' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=4755%') and `access` IN (1,5)
301μs856B/components/com_osproperty/helpers/route.php:599CopySelect * from sra_osrs_properties where id = '4755'
716μs23.09KB/components/com_osproperty/router.php:376CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "e2f1ac15d158e4f6fda77fb1da2cb552"
12.81ms856B/components/com_osproperty/router.php:868CopySelect id, pro_alias, pro_name from sra_osrs_properties where id = '4755'
444μs976B/components/com_osproperty/router.php:784CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "6b4bdb6c683c089bf85fb3d1aa4b8661"
12.3ms856B/components/com_osproperty/router.php:868CopySelect city from sra_osrs_cities where id = '25386'
369μs856B/components/com_osproperty/helpers/helper.php:1597CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "a4295bcb96178a806351207b1e66196c"
11.97ms856B/components/com_osproperty/router.php:868CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "fb1b29031c6d0269c0d5acf7a17f549a"
11.77ms856B/components/com_osproperty/router.php:868CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "2557200ee60cdffbde53be787e0139f6"
12.03ms856B/components/com_osproperty/router.php:868CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "293b56b4d2e797c84dfe44d39f904db0"
11.92ms856B/components/com_osproperty/router.php:868CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "7a52212043fab9e7f82cf8f258170e18"
11.46ms856B/components/com_osproperty/router.php:868CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "80b10b2ff1b19319fcf0a9e2084712a0"
11.86ms856B/components/com_osproperty/router.php:868CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "2379bce33b24a7a6b068b850aa7a0a95"
12.1ms856B/components/com_osproperty/router.php:868CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "7dda0202e4da010ccbab58ec5dee9a3b"
12.22ms856B/components/com_osproperty/router.php:868CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "ef8ea8553842060e66ab2da12736babf"
11.54ms856B/components/com_osproperty/router.php:868CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "b7ed85f68b78b0307822d970c0d29932"
11.76ms856B/components/com_osproperty/router.php:868CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `sra_modules` AS `m`
LEFT JOIN `sra_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `sra_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.67ms2.25KBParams/libraries/src/Cache/Controller/CallbackController.php:51CopySELECT COUNT(id)
FROM sra_osrs_urls
WHERE md5_key like "ef8ea8553842060e66ab2da12736babf"
13.44ms856B/components/com_osproperty/router.php:868CopySELECT 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 `sra_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1
602μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517CopySELECT `session_id`
FROM `sra_session`
WHERE `session_id` = ?
430μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277CopyUPDATE `sra_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
3.57ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy