Casa Lote de un solo piso
La casa cuenta con :
Joomla! Version | 5.2.3 |
PHP Version | 8.2.18 |
Identity | guest |
Response | 200 |
Template | rt_ambrosia |
Database |
|
1 x afterRender (12.02MB) (55.1%) | 1.03s |
1 x afterRenderComponent com_osproperty (3.52MB) (24.98%) | 467ms |
1 x afterInitialise (2.63MB) (10.72%) | 200ms |
1 x afterRoute (800KB) (4.29%) | 80.10ms |
1 x afterLoad (356.76KB) (4.15%) | 77.49ms |
1 x beforeRenderComponent com_osproperty (87.04KB) (0.63%) | 11.75ms |
1 x afterDispatch (2.39KB) (0.02%) | 455μs |
SELECT @@SESSION.sql_mode;
580μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308CopySELECT `data`
FROM `josph_session`
WHERE `session_id` = ?
472μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250CopySELECT `session_id`
FROM `josph_session`
WHERE `session_id` = :session_id LIMIT 1
383μs1.3KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `josph_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
677μs944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `josph_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
1.08ms1.73KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `josph_viewlevels`
149μs656B/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `josph_usergroups` AS `a`
LEFT JOIN `josph_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest
309μs1.33KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `josph_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`
1.03ms3.98KBParams/libraries/src/Plugin/PluginHelper.php:294CopySELECT template
FROM josph_template_styles as s
WHERE s.client_id = 0 AND s.home = 1
299μs1.15KB/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31CopySELECT template
FROM josph_template_styles as s
WHERE s.client_id = 0 AND s.home = 1
138μs536B/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31CopySELECT extension, file, type
FROM josph_rokcommon_configs
ORDER BY priority
152μs640B/plugins/system/rokcommon/rokcommon.php:131CopySELECT `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 `josph_menu` AS `m`
LEFT JOIN `josph_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`
587μs3.42KBParams/libraries/src/Menu/SiteMenu.php:166CopySELECT `query`
FROM josph_osrs_urls
WHERE md5_key="e56fc6d822f2ecd72b8a1464181e2248"
285μs536B/components/com_osproperty/router.php:873CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `josph_template_styles` AS `s`
LEFT JOIN `josph_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
434μs896B/administrator/components/com_templates/src/Model/StyleModel.php:775CopySELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM josph_template_styles AS s
WHERE s.client_id = 0 AND s.template = 'rt_ambrosia'
ORDER BY s.id
299μs800B/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69CopySELECT *
FROM `josph_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
263μs1.59KB/libraries/src/Language/LanguageHelper.php:177CopySelect count(id) from josph_osrs_configuration where fieldname like 'integrate_membership'
351μs1.77KB/components/com_osproperty/helpers/libraries/libraries.php:28CopyUPDATE josph_osrs_configuration SET fieldvalue = '0' WHERE fieldname LIKE 'integrate_membership'
179μs48B/components/com_osproperty/helpers/libraries/libraries.php:31CopySelect * from josph_osrs_configuration
357μs8.58KB/components/com_osproperty/osproperty.php:68CopySelect * from josph_osrs_currencies where id = '13'
143μs768B/components/com_osproperty/osproperty.php:79CopySELECT lang_id, lang_code, title, `sef`
FROM josph_languages
WHERE published = 1 AND lang_code != "es-ES"
ORDER BY ordering
337μs704B/components/com_osproperty/helpers/helper.php:367CopySelect * from josph_osrs_configuration
314μs8.63KB/components/com_osproperty/helpers/helper.php:50CopySelect * from josph_osrs_currencies where id = '13'
120μs768B/components/com_osproperty/helpers/helper.php:61CopySELECT * FROM josph_osrs_configuration
351μs8.63KB/components/com_osproperty/osproperty.php:130CopySelect * from josph_osrs_themes where published = '1'
172μs1.63KB/components/com_osproperty/helpers/helper.php:4852CopySelect * from josph_osrs_properties where id = '199'
1.29ms11.84KB/components/com_osproperty/classes/listing.php:3455CopySelect fieldvalue from josph_osrs_configuration where fieldname like 'default_itemid'
590μs536B/components/com_osproperty/helpers/route.php:44CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from josph_osrs_properties as a inner join josph_osrs_agents as b on b.id = a.agent_id left join josph_osrs_company_agents as c on c.agent_id = b.id where a.id = '199'
496μs928B/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM josph_osrs_property_categories
WHERE pid="199"
235μs536B/components/com_osproperty/helpers/helper.php:3201CopySelect id from josph_menu where published = '1' and ((`link` like '%view=ldetails&id=199%') or (`link` like '%view=ldetails&id=199%')) and `access` IN (1,5)
432μs520B/components/com_osproperty/helpers/route.php:118CopySelect * from josph_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
709μs2.91KB/components/com_osproperty/helpers/route.php:125CopySelect a.* from josph_osrs_tags as a inner join josph_osrs_tag_xref as b on b.tag_id = a.id where b.pid = '199'
335μs688B/components/com_osproperty/classes/listing.php:3614CopySELECT category_id
FROM josph_osrs_property_categories
WHERE pid = "199"
266μs3.02KB/components/com_osproperty/classes/listing.php:3677CopySelect id, parent_id,category_name as category_name from josph_osrs_categories where id = '1'
253μs656B/components/com_osproperty/helpers/common.php:2231CopySelect id, parent_id,category_name as category_name from josph_osrs_categories where id = '0'
208μs640B/components/com_osproperty/helpers/common.php:2231CopySelect * from josph_osrs_categories where id = '1'
313μs1.59KB/components/com_osproperty/router.php:136CopySELECT COUNT(id)
FROM josph_osrs_urls
WHERE md5_key like "441d8555cc3d7669d85fb6a1eff558fd"
323μs536B/components/com_osproperty/router.php:844CopySelect * from josph_osrs_types where id = '1'
324μs928B/components/com_osproperty/classes/listing.php:3689CopySELECT id
FROM josph_menu
WHERE link LIKE "%index.php?option=com_osproperty%" and ( `link` LIKE "%ltype%" or `link` LIKE "%property_type%" or `link` LIKE "%type_id=1%" ) AND published = 1 and id in (123,124,125,126,127,123,124,125,126,127) AND `access` IN (1,5)
ORDER BY access
424μs600B/components/com_osproperty/helpers/route.php:462CopySelect count(id) from josph_menu where id = '123' and published = '1'
246μs536B/components/com_osproperty/helpers/route.php:612CopySELECT COUNT(id)
FROM josph_osrs_urls
WHERE md5_key like "d41d8cd98f00b204e9800998ecf8427e"
287μs536B/components/com_osproperty/router.php:844CopySELECT id
FROM josph_menu
WHERE link LIKE "%index.php?option=com_osproperty%" and ( `link` LIKE "%property_type%" or `link` LIKE "%199%" ) AND published = 1 and id in (123,124,125,126,127,123,124,125,126,127,123,124,125,126,127) AND `access` IN (1,5)
ORDER BY access
320μs520B/components/com_osproperty/helpers/route.php:462CopySelect count(id) from josph_menu where id = '123' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=199%') and `access` IN (1,5)
264μs536B/components/com_osproperty/helpers/route.php:598CopySelect * from josph_osrs_properties where id = '199'
1.16ms11.84KB/components/com_osproperty/router.php:357CopySELECT COUNT(id)
FROM josph_osrs_urls
WHERE md5_key like "e56fc6d822f2ecd72b8a1464181e2248"
282μs536B/components/com_osproperty/router.php:844CopyUpdate josph_osrs_properties set hits = '156' where id = '199'
380μs48B/components/com_osproperty/classes/listing.php:3718CopyInsert into josph_osrs_hit_statistic (id, pid, hit_date) values (NULL,'199','2025-04-03')
428μs-48B/components/com_osproperty/classes/listing.php:3723CopySelect image from josph_osrs_photos where pro_id = '199' order by ordering
471μs840B/components/com_osproperty/classes/listing.php:3747CopySelect * from josph_osrs_countries where id = '41'
383μs656B/components/com_osproperty/helpers/helper.php:1624CopySelect state_name from josph_osrs_states where id = '52'
246μs536B/components/com_osproperty/helpers/helper.php:1613Copyselect * from josph_osrs_categories where id = '1'
352μs1.59KB/components/com_osproperty/classes/listing.php:3778CopySELECT id, category_name as category_name
FROM josph_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from josph_osrs_property_categories where pid ="199")
520μs592B/components/com_osproperty/helpers/helper.php:3244CopySELECT id
FROM josph_menu
WHERE link LIKE "%index.php?option=com_osproperty%" and ( `link` LIKE "%category_listing%" or `link` LIKE "%lcategory%" ) AND published = 1 and id in (123,124,125,126,127,123,124,125,126,127,123,124,125,126,127,123,124,125,126,127) AND `access` IN (1,5)
ORDER BY access
410μs520B/components/com_osproperty/helpers/route.php:462Copyselect * from josph_osrs_types where id = '1'
302μs928B/components/com_osproperty/classes/listing.php:3783CopySelect a.* from josph_osrs_amenities as a inner join josph_osrs_property_amenities as b on b.amen_id = a.id where a.published = '1' and b.pro_id = '199' and a.category_id = '0' order by a.ordering
430μs816B/components/com_osproperty/classes/listing.php:3895CopySelect a.* from josph_osrs_amenities as a inner join josph_osrs_property_amenities as b on b.amen_id = a.id where a.published = '1' and b.pro_id = '199' and a.category_id = '1' order by a.ordering
373μs816B/components/com_osproperty/classes/listing.php:3895CopySelect a.* from josph_osrs_amenities as a inner join josph_osrs_property_amenities as b on b.amen_id = a.id where a.published = '1' and b.pro_id = '199' and a.category_id = '2' order by a.ordering
210μs816B/components/com_osproperty/classes/listing.php:3895CopySelect a.* from josph_osrs_amenities as a inner join josph_osrs_property_amenities as b on b.amen_id = a.id where a.published = '1' and b.pro_id = '199' and a.category_id = '3' order by a.ordering
223μs816B/components/com_osproperty/classes/listing.php:3895CopySelect a.* from josph_osrs_amenities as a inner join josph_osrs_property_amenities as b on b.amen_id = a.id where a.published = '1' and b.pro_id = '199' and a.category_id = '4' order by a.ordering
176μs816B/components/com_osproperty/classes/listing.php:3895CopySelect a.* from josph_osrs_amenities as a inner join josph_osrs_property_amenities as b on b.amen_id = a.id where a.published = '1' and b.pro_id = '199' and a.category_id = '5' order by a.ordering
157μs816B/components/com_osproperty/classes/listing.php:3895CopySelect a.* from josph_osrs_amenities as a inner join josph_osrs_property_amenities as b on b.amen_id = a.id where a.published = '1' and b.pro_id = '199' and a.category_id = '6' order by a.ordering
189μs816B/components/com_osproperty/classes/listing.php:3895CopySelect a.* from josph_osrs_amenities as a inner join josph_osrs_property_amenities as b on b.amen_id = a.id where a.published = '1' and b.pro_id = '199' and a.category_id = '7' order by a.ordering
153μs816B/components/com_osproperty/classes/listing.php:3895CopySelect a.* from josph_osrs_amenities as a inner join josph_osrs_property_amenities as b on b.amen_id = a.id where a.published = '1' and b.pro_id = '199' and a.category_id = '8' order by a.ordering
152μs816B/components/com_osproperty/classes/listing.php:3895CopySelect * from josph_osrs_fieldgroups where published = '1' and `access` IN (1,5) order by ordering
292μs3.73KB/components/com_osproperty/classes/listing.php:3966CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '1' and b.`access` IN (1,5) order by b.ordering
124μs11.56KB/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '2' and b.`access` IN (1,5) order by b.ordering
116μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '3' and b.`access` IN (1,5) order by b.ordering
94μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '4' and b.`access` IN (1,5) order by b.ordering
87μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '5' and b.`access` IN (1,5) order by b.ordering
82μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '6' and b.`access` IN (1,5) order by b.ordering
83μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '7' and b.`access` IN (1,5) order by b.ordering
85μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '8' and b.`access` IN (1,5) order by b.ordering
80μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '9' and b.`access` IN (1,5) order by b.ordering
80μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '10' and b.`access` IN (1,5) order by b.ordering
78μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '11' and b.`access` IN (1,5) order by b.ordering
107μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '12' and b.`access` IN (1,5) order by b.ordering
78μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '13' and b.`access` IN (1,5) order by b.ordering
80μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '14' and b.`access` IN (1,5) order by b.ordering
79μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '15' and b.`access` IN (1,5) order by b.ordering
77μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '16' and b.`access` IN (1,5) order by b.ordering
76μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '17' and b.`access` IN (1,5) order by b.ordering
64μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '18' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '19' and b.`access` IN (1,5) order by b.ordering
64μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '20' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '21' and b.`access` IN (1,5) order by b.ordering
66μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '22' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '23' and b.`access` IN (1,5) order by b.ordering
54μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '24' and b.`access` IN (1,5) order by b.ordering
49μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '25' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '26' and b.`access` IN (1,5) order by b.ordering
53μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '27' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '28' and b.`access` IN (1,5) order by b.ordering
61μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '29' and b.`access` IN (1,5) order by b.ordering
50μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '30' and b.`access` IN (1,5) order by b.ordering
54μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '31' and b.`access` IN (1,5) order by b.ordering
53μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '32' and b.`access` IN (1,5) order by b.ordering
49μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '33' and b.`access` IN (1,5) order by b.ordering
53μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '34' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '35' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '36' and b.`access` IN (1,5) order by b.ordering
50μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '37' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '38' and b.`access` IN (1,5) order by b.ordering
50μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '39' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '40' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '41' and b.`access` IN (1,5) order by b.ordering
75μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '42' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '43' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '44' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '45' and b.`access` IN (1,5) order by b.ordering
50μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '46' and b.`access` IN (1,5) order by b.ordering
53μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '47' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '48' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '49' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '50' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '51' and b.`access` IN (1,5) order by b.ordering
50μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '52' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '53' and b.`access` IN (1,5) order by b.ordering
49μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '54' and b.`access` IN (1,5) order by b.ordering
66μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '55' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '56' and b.`access` IN (1,5) order by b.ordering
53μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '57' and b.`access` IN (1,5) order by b.ordering
53μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '58' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '59' and b.`access` IN (1,5) order by b.ordering
53μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '60' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '61' and b.`access` IN (1,5) order by b.ordering
61μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '62' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '63' and b.`access` IN (1,5) order by b.ordering
53μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '64' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '65' and b.`access` IN (1,5) order by b.ordering
62μs8.56KB/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '66' and b.`access` IN (1,5) order by b.ordering
50μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '67' and b.`access` IN (1,5) order by b.ordering
53μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '68' and b.`access` IN (1,5) order by b.ordering
54μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '69' and b.`access` IN (1,5) order by b.ordering
53μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '70' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '71' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '72' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '73' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '74' and b.`access` IN (1,5) order by b.ordering
75μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '75' and b.`access` IN (1,5) order by b.ordering
50μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '76' and b.`access` IN (1,5) order by b.ordering
53μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '77' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '78' and b.`access` IN (1,5) order by b.ordering
53μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '79' and b.`access` IN (1,5) order by b.ordering
49μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '80' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '81' and b.`access` IN (1,5) order by b.ordering
53μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '82' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '83' and b.`access` IN (1,5) order by b.ordering
53μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '84' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '85' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '86' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '87' and b.`access` IN (1,5) order by b.ordering
72μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '88' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '89' and b.`access` IN (1,5) order by b.ordering
50μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '90' and b.`access` IN (1,5) order by b.ordering
50μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '91' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '92' and b.`access` IN (1,5) order by b.ordering
50μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '93' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '94' and b.`access` IN (1,5) order by b.ordering
66μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '95' and b.`access` IN (1,5) order by b.ordering
53μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '96' and b.`access` IN (1,5) order by b.ordering
49μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '97' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '98' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '99' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '100' and b.`access` IN (1,5) order by b.ordering
50μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '101' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '102' and b.`access` IN (1,5) order by b.ordering
50μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '103' and b.`access` IN (1,5) order by b.ordering
50μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '104' and b.`access` IN (1,5) order by b.ordering
50μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '105' and b.`access` IN (1,5) order by b.ordering
50μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '106' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '107' and b.`access` IN (1,5) order by b.ordering
63μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '108' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '109' and b.`access` IN (1,5) order by b.ordering
50μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '110' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '111' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '112' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '113' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '114' and b.`access` IN (1,5) order by b.ordering
55μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '115' and b.`access` IN (1,5) order by b.ordering
50μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '116' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '117' and b.`access` IN (1,5) order by b.ordering
50μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '118' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '119' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '120' and b.`access` IN (1,5) order by b.ordering
64μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '121' and b.`access` IN (1,5) order by b.ordering
54μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '122' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '123' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '124' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '125' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '126' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '127' and b.`access` IN (1,5) order by b.ordering
65μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '128' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '129' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '130' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '131' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '132' and b.`access` IN (1,5) order by b.ordering
53μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '133' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '134' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '135' and b.`access` IN (1,5) order by b.ordering
53μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '136' and b.`access` IN (1,5) order by b.ordering
54μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '137' and b.`access` IN (1,5) order by b.ordering
53μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '138' and b.`access` IN (1,5) order by b.ordering
53μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '139' and b.`access` IN (1,5) order by b.ordering
50μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '140' and b.`access` IN (1,5) order by b.ordering
78μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '141' and b.`access` IN (1,5) order by b.ordering
53μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '142' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '143' and b.`access` IN (1,5) order by b.ordering
50μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '144' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '145' and b.`access` IN (1,5) order by b.ordering
53μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '146' and b.`access` IN (1,5) order by b.ordering
53μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '147' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '148' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '149' and b.`access` IN (1,5) order by b.ordering
53μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '150' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '151' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '152' and b.`access` IN (1,5) order by b.ordering
49μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '153' and b.`access` IN (1,5) order by b.ordering
76μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '154' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '155' and b.`access` IN (1,5) order by b.ordering
50μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '156' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '157' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '158' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '159' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '160' and b.`access` IN (1,5) order by b.ordering
50μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '161' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '162' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '163' and b.`access` IN (1,5) order by b.ordering
54μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '164' and b.`access` IN (1,5) order by b.ordering
51μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '165' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '166' and b.`access` IN (1,5) order by b.ordering
87μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '167' and b.`access` IN (1,5) order by b.ordering
53μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '168' and b.`access` IN (1,5) order by b.ordering
52μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect b.id,b.field_type from josph_osrs_extra_fields as b WHERE b.published = '1' AND b.group_id = '169' and b.`access` IN (1,5) order by b.ordering
53μs576B/administrator/components/com_osproperty/helpers/extrafields.php:262CopySelect * from josph_osrs_agents where id = '2'
274μs3.06KB/components/com_osproperty/classes/listing.php:3993CopySelect count(id) from josph_osrs_properties where published = '1' and approved = '1' and agent_id = '2'
722μs536B/components/com_osproperty/classes/listing.php:4005CopySELECT category_id
FROM josph_osrs_property_categories
WHERE pid="199"
364μs536B/components/com_osproperty/helpers/helper.php:3201CopySELECT pr.*
, ci.city AS city_name
, st.state_name
, co.country_name
, ty.type_name, ty.id as type_id, ( 6371 * acos( cos( radians('5.648341') ) *
cos( radians( pr.lat_add ) ) * cos( radians( pr.long_add ) - radians('-73.513115') ) +
sin( radians('5.648341') ) * sin( radians( pr.lat_add ) ) ) )
AS distance
FROM josph_osrs_properties as pr
LEFT JOIN josph_osrs_cities AS ci ON ci.id = pr.city
LEFT JOIN josph_osrs_states AS st ON st.id = pr.state
LEFT JOIN josph_osrs_countries AS co ON co.id = pr.country
INNER JOIN josph_osrs_types AS ty ON ty.id = pr.pro_type
WHERE pr.approved = '1' and pr.published = '1'
AND pr.access IN (1,5)
AND pr.id <> '199' AND pr.state = '52' HAVING distance < '10' ORDER BY distance ASC, pr.isFeatured desc LIMIT 3
4.12ms12.06KB/components/com_osproperty/classes/listing.php:4111Copyselect image from josph_osrs_photos where pro_id = '192' order by ordering
1.06ms904B/components/com_osproperty/classes/listing.php:4118CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from josph_osrs_properties as a inner join josph_osrs_agents as b on b.id = a.agent_id left join josph_osrs_company_agents as c on c.agent_id = b.id where a.id = '192'
789μs928B/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM josph_osrs_property_categories
WHERE pid="192"
723μs536B/components/com_osproperty/helpers/helper.php:3201CopySelect id from josph_menu where published = '1' and ((`link` like '%view=ldetails&id=192%') or (`link` like '%view=ldetails&id=192%')) and `access` IN (1,5)
789μs520B/components/com_osproperty/helpers/route.php:118CopySelect * from josph_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
886μs2.91KB/components/com_osproperty/helpers/route.php:125Copyselect image from josph_osrs_photos where pro_id = '36' order by ordering
749μs1.01KB/components/com_osproperty/classes/listing.php:4118CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from josph_osrs_properties as a inner join josph_osrs_agents as b on b.id = a.agent_id left join josph_osrs_company_agents as c on c.agent_id = b.id where a.id = '36'
1.04ms928B/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM josph_osrs_property_categories
WHERE pid="36"
1.1ms536B/components/com_osproperty/helpers/helper.php:3201CopySelect id from josph_menu where published = '1' and ((`link` like '%view=ldetails&id=36%') or (`link` like '%view=ldetails&id=36%')) and `access` IN (1,5)
902μs520B/components/com_osproperty/helpers/route.php:118CopySelect * from josph_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
1.08ms2.91KB/components/com_osproperty/helpers/route.php:125Copyselect image from josph_osrs_photos where pro_id = '133' order by ordering
1.85ms968B/components/com_osproperty/classes/listing.php:4118CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from josph_osrs_properties as a inner join josph_osrs_agents as b on b.id = a.agent_id left join josph_osrs_company_agents as c on c.agent_id = b.id where a.id = '133'
528μs928B/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM josph_osrs_property_categories
WHERE pid="133"
1ms536B/components/com_osproperty/helpers/helper.php:3201CopySelect id from josph_menu where published = '1' and ((`link` like '%view=ldetails&id=133%') or (`link` like '%view=ldetails&id=133%')) and `access` IN (1,5)
614μs520B/components/com_osproperty/helpers/route.php:118CopySelect * from josph_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
1.05ms2.91KB/components/com_osproperty/helpers/route.php:125CopySELECT category_id
FROM josph_osrs_property_categories
WHERE pid="199"
441μs536B/components/com_osproperty/helpers/helper.php:3201CopySELECT pr.*
, ci.city AS city_name
, st.state_name
, co.country_name
, ty.type_name, ty.id as type_id
FROM josph_osrs_properties as pr
LEFT JOIN josph_osrs_cities AS ci ON ci.id = pr.city
LEFT JOIN josph_osrs_states AS st ON st.id = pr.state
LEFT JOIN josph_osrs_countries AS co ON co.id = pr.country
INNER JOIN josph_osrs_types AS ty ON ty.id = pr.pro_type
WHERE pr.approved = '1' and pr.published = '1'
AND pr.id <> '199'
AND pr.access IN (1,5)
AND pr.pro_type = '1' ORDER BY pr.isFeatured desc LIMIT 3
2.59ms12.03KB/components/com_osproperty/classes/listing.php:4172Copyselect image from josph_osrs_photos where pro_id = '1' order by ordering
805μs1.01KB/components/com_osproperty/classes/listing.php:4179CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from josph_osrs_properties as a inner join josph_osrs_agents as b on b.id = a.agent_id left join josph_osrs_company_agents as c on c.agent_id = b.id where a.id = '1'
444μs928B/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM josph_osrs_property_categories
WHERE pid="1"
254μs16.52KB/components/com_osproperty/helpers/helper.php:3201CopySelect id from josph_menu where published = '1' and ((`link` like '%view=ldetails&id=1%') or (`link` like '%view=ldetails&id=1%')) and `access` IN (1,5)
281μs520B/components/com_osproperty/helpers/route.php:118CopySelect * from josph_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
764μs2.91KB/components/com_osproperty/helpers/route.php:125Copyselect image from josph_osrs_photos where pro_id = '4' order by ordering
524μs840B/components/com_osproperty/classes/listing.php:4179CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from josph_osrs_properties as a inner join josph_osrs_agents as b on b.id = a.agent_id left join josph_osrs_company_agents as c on c.agent_id = b.id where a.id = '4'
694μs928B/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM josph_osrs_property_categories
WHERE pid="4"
519μs536B/components/com_osproperty/helpers/helper.php:3201CopySelect id from josph_menu where published = '1' and ((`link` like '%view=ldetails&id=4%') or (`link` like '%view=ldetails&id=4%')) and `access` IN (1,5)
772μs520B/components/com_osproperty/helpers/route.php:118CopySelect * from josph_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
780μs2.91KB/components/com_osproperty/helpers/route.php:125Copyselect image from josph_osrs_photos where pro_id = '9' order by ordering
673μs776B/components/com_osproperty/classes/listing.php:4179CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from josph_osrs_properties as a inner join josph_osrs_agents as b on b.id = a.agent_id left join josph_osrs_company_agents as c on c.agent_id = b.id where a.id = '9'
615μs928B/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM josph_osrs_property_categories
WHERE pid="9"
530μs536B/components/com_osproperty/helpers/helper.php:3201CopySelect id from josph_menu where published = '1' and ((`link` like '%view=ldetails&id=9%') or (`link` like '%view=ldetails&id=9%')) and `access` IN (1,5)
714μs520B/components/com_osproperty/helpers/route.php:118CopySelect * from josph_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
782μs2.91KB/components/com_osproperty/helpers/route.php:125CopySelect * from josph_osrs_themes where published = '1'
481μs1.63KB/components/com_osproperty/helpers/helper.php:4896CopySelect * from josph_osrs_themes where name like 'default'
482μs1.63KB/components/com_osproperty/classes/listing.html.php:991CopySelect city from josph_osrs_cities where id = '29640'
414μs536B/components/com_osproperty/helpers/helper.php:1577CopySelect state_code from josph_osrs_states where id = '52'
468μs536B/components/com_osproperty/helpers/helper.php:1592CopySelect * from josph_osrs_categories where id = '1'
529μs1.59KB/components/com_osproperty/router.php:136CopySELECT COUNT(id)
FROM josph_osrs_urls
WHERE md5_key like "441d8555cc3d7669d85fb6a1eff558fd"
526μs536B/components/com_osproperty/router.php:844CopySelect id,type_alias,type_name from josph_osrs_types where id = '1'
470μs656B/components/com_osproperty/router.php:471CopySELECT COUNT(id)
FROM josph_osrs_urls
WHERE md5_key like "72b8d844f195bd7c903ec47e600b0a38"
441μs536B/components/com_osproperty/router.php:844CopySelect id as value, currency_code as text from josph_osrs_currencies where id <> '13' and published = '1' order by currency_code
667μs576B/components/com_osproperty/classes/listing.html.php:1367CopySELECT id
FROM josph_menu
WHERE link LIKE "%index.php?option=com_osproperty%" and ( `link` LIKE "%lagents%" or `link` LIKE "%agent_layout%" or `link` LIKE "%agent_listing%" or `link` LIKE "%agent_details%" or `link` LIKE "%2%" ) AND published = 1 and id in (123,124,125,126,127,123,124,125,126,127,123,124,125,126,127,123,124,125,126,127,123,124,125,126,127,123,124,125,126,127,123,124,125,126,127,123,124,125,126,127,123,124,125,126,127,123,124,125,126,127,123,124,125,126,127) AND `access` IN (1,5)
ORDER BY access
904μs520B/components/com_osproperty/helpers/route.php:462CopySelect id, alias, name from josph_osrs_agents where id = '2'
400μs656B/components/com_osproperty/router.php:284CopySELECT COUNT(id)
FROM josph_osrs_urls
WHERE md5_key like "f7197262727d99fad392ad3cfc2d389f"
471μs536B/components/com_osproperty/router.php:844CopySelect * from josph_osrs_properties where id = '199'
1.27ms11.84KB/components/com_osproperty/router.php:357CopySELECT COUNT(id)
FROM josph_osrs_urls
WHERE md5_key like "e56fc6d822f2ecd72b8a1464181e2248"
740μs536B/components/com_osproperty/router.php:844CopySelect count(a.id)from josph_osrs_neighborhood as a inner join josph_osrs_neighborhoodname as b on b.id = a.neighbor_id where a.pid = '199'
391μs536B/components/com_osproperty/classes/listing.html.php:1968CopySelect count(id) from josph_menu where id = '124' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=192%') and `access` IN (1,5)
603μs536B/components/com_osproperty/helpers/route.php:598CopySelect * from josph_osrs_properties where id = '192'
1.14ms11.84KB/components/com_osproperty/router.php:357CopySELECT COUNT(id)
FROM josph_osrs_urls
WHERE md5_key like "7bea7d8e9b992048e745f7517d99132c"
648μs536B/components/com_osproperty/router.php:844CopySelect currency_symbol from josph_osrs_currencies where id = '13'
475μs536B/components/com_osproperty/helpers/common.php:1563CopySelect fieldvalue from josph_osrs_configuration where fieldname like 'general_currency_money_format'
563μs536B/components/com_osproperty/helpers/helper.php:7233CopySelect count(id) from josph_menu where id = '123' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=36%') and `access` IN (1,5)
512μs536B/components/com_osproperty/helpers/route.php:598CopySelect * from josph_osrs_properties where id = '36'
7.78ms11.84KB/components/com_osproperty/router.php:357CopySELECT COUNT(id)
FROM josph_osrs_urls
WHERE md5_key like "579de9bf05193f6ac56284d43431f7da"
485μs536B/components/com_osproperty/router.php:844CopySelect count(id) from josph_menu where id = '127' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=133%') and `access` IN (1,5)
477μs536B/components/com_osproperty/helpers/route.php:598CopySelect * from josph_osrs_properties where id = '133'
942μs11.84KB/components/com_osproperty/router.php:357CopySELECT COUNT(id)
FROM josph_osrs_urls
WHERE md5_key like "8e323be9523995d62203f08101e7b3db"
491μs536B/components/com_osproperty/router.php:844CopySelect count(id) from josph_menu where id = '123' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=1%') and `access` IN (1,5)
429μs536B/components/com_osproperty/helpers/route.php:598CopySelect * from josph_osrs_properties where id = '1'
893μs11.84KB/components/com_osproperty/router.php:357CopySELECT COUNT(id)
FROM josph_osrs_urls
WHERE md5_key like "0abc2b612a4b2c29d44a5d0c9a692b54"
499μs536B/components/com_osproperty/router.php:844CopySelect count(id) from josph_menu where id = '124' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=4%') and `access` IN (1,5)
474μs536B/components/com_osproperty/helpers/route.php:598CopySelect * from josph_osrs_properties where id = '4'
949μs11.84KB/components/com_osproperty/router.php:357CopySELECT COUNT(id)
FROM josph_osrs_urls
WHERE md5_key like "0bb627a601ed2cb36e639de3b77e9332"
494μs536B/components/com_osproperty/router.php:844CopySelect count(id) from josph_menu where id = '124' and published = '1' and (`link` like '%view=ldetails%' and `link` like '%id=9%') and `access` IN (1,5)
476μs536B/components/com_osproperty/helpers/route.php:598CopySelect * from josph_osrs_properties where id = '9'
905μs11.84KB/components/com_osproperty/router.php:357CopySELECT COUNT(id)
FROM josph_osrs_urls
WHERE md5_key like "3907a998149f436da4bf4f7e0ea88877"
414μs536B/components/com_osproperty/router.php:844CopySelect * from josph_osrs_photos where pro_id = '199' and image <> '' order by ordering limit 30
730μs1.05KB/components/com_osproperty/classes/listing.html.php:2117CopySelect type_icon from josph_osrs_types where id = '199'
438μs520B/components/com_osproperty/helpers/helper.php:6002CopySelect * from josph_osrs_themes where name like 'default'
448μs1.63KB/components/com_osproperty/classes/listing.html.php:2643CopySelect count(extension_id) from josph_extensions where `type` like 'plugin' and `element` like 'jcomments' and `folder` like 'osproperty' and enabled = '1'
590μs536B/components/com_osproperty/classes/listing.html.php:2768CopySelect a.id,a.keyword as keyword from josph_osrs_tags as a inner join josph_osrs_tag_xref as b on b.tag_id = a.id where a.published = '1' and b.pid = '199'
603μs624B/components/com_osproperty/classes/listing.html.php:2784CopySelect keyword from josph_osrs_tags where id = '181'
440μs536B/components/com_osproperty/router.php:422CopySELECT COUNT(id)
FROM josph_osrs_urls
WHERE md5_key like "4ef7627c5cac70572a121f98b30bd214"
501μs536B/components/com_osproperty/router.php:844CopySelect keyword from josph_osrs_tags where id = '180'
434μs536B/components/com_osproperty/router.php:422CopySELECT COUNT(id)
FROM josph_osrs_urls
WHERE md5_key like "d673de308257c8b5aa3457491e7dacb2"
468μs536B/components/com_osproperty/router.php:844CopySelect keyword from josph_osrs_tags where id = '202'
315μs536B/components/com_osproperty/router.php:422CopySELECT COUNT(id)
FROM josph_osrs_urls
WHERE md5_key like "a5f1a3b4c7aa3f5dcdb24801f5b97398"
536μs536B/components/com_osproperty/router.php:844CopySelect a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id from josph_osrs_properties as a inner join josph_osrs_agents as b on b.id = a.agent_id left join josph_osrs_company_agents as c on c.agent_id = b.id where a.id = '199'
343μs928B/components/com_osproperty/helpers/route.php:88CopySELECT category_id
FROM josph_osrs_property_categories
WHERE pid="199"
164μs536B/components/com_osproperty/helpers/helper.php:3201CopySelect id from josph_menu where published = '1' and ((`link` like '%view=ldetails&id=199%') or (`link` like '%view=ldetails&id=199%')) and `access` IN (1,5)
270μs520B/components/com_osproperty/helpers/route.php:118CopySelect * from josph_menu where published = '1' and `home` = '0' and `link` like '%view=ltype%' and `access` IN (1,5)
373μs2.91KB/components/com_osproperty/helpers/route.php:125CopySelect * from josph_osrs_themes where name like 'default'
449μs1.63KB/components/com_osproperty/classes/listing.html.php:2996CopySelect id,type_alias,type_name from josph_osrs_types where id = '1'
502μs656B/components/com_osproperty/router.php:471CopySELECT COUNT(id)
FROM josph_osrs_urls
WHERE md5_key like "72b8d844f195bd7c903ec47e600b0a38"
546μs536B/components/com_osproperty/router.php:844CopySELECT id, category_name as category_name
FROM josph_osrs_categories
WHERE 1 = 1 and `access` IN (1,5) and id in (Select category_id from josph_osrs_property_categories where pid ="199")
683μs592B/components/com_osproperty/helpers/helper.php:3244CopySELECT id
FROM josph_menu
WHERE link LIKE "%index.php?option=com_osproperty%" and ( `link` LIKE "%category_listing%" or `link` LIKE "%lcategory%" ) AND published = 1 and id in (123,124,125,126,127,123,124,125,126,127,123,124,125,126,127,123,124,125,126,127,123,124,125,126,127,123,124,125,126,127,123,124,125,126,127,123,124,125,126,127,123,124,125,126,127,123,124,125,126,127,123,124,125,126,127,123,124,125,126,127,123,124,125,126,127,123,124,125,126,127,123,124,125,126,127) AND `access` IN (1,5)
ORDER BY access
616μs520B/components/com_osproperty/helpers/route.php:462CopySelect * from josph_osrs_agents where id = '2'
277μs3.06KB/components/com_osproperty/templates/default/details.html.tpl.php:624CopySELECT s.id, e.extension_id, s.template AS name, s.title, s.params
FROM josph_template_styles AS s
LEFT JOIN josph_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 AND e.state = 0
ORDER BY s.id
1.25ms832B/libraries/gantry5/src/classes/Gantry/Admin/ThemeList.php:156CopySHOW FULL COLUMNS FROM `josph_extensions`
1.53ms1.58KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT *
FROM `josph_extensions`
WHERE `type` = 'template' AND `element` = 'rt_ambrosia' AND `client_id` = '0'
933μs2.53KB/libraries/src/Table/Table.php:780CopySELECT `a`.`menutype`,`a`.`title`
FROM `josph_menu_types` AS `a`
WHERE `a`.`client_id` = 0
712μs608B/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:138CopySELECT m.id, m.alias, m.path AS route, m.level, m.parent_id
FROM josph_menu AS m
WHERE m.menutype = 'mainmenu' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0
ORDER BY m.lft
1.23ms848B/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791CopySelect id, company_alias,company_name from josph_osrs_companies where id = '1'
570μs656B/components/com_osproperty/router.php:505CopySelect id, country_name from josph_osrs_countries where id = '41'
677μs592B/components/com_osproperty/router.php:519CopySelect count(id) from josph_menu where id = '123' and published = '1'
617μs536B/components/com_osproperty/helpers/route.php:612CopySelect id, company_alias,company_name from josph_osrs_companies where id = '1'
389μs656B/components/com_osproperty/router.php:505CopySelect id, country_name from josph_osrs_countries where id = '41'
443μs592B/components/com_osproperty/router.php:519CopySelect count(id) from josph_menu where id = '124' and published = '1'
444μs536B/components/com_osproperty/helpers/route.php:612CopySelect id, company_alias,company_name from josph_osrs_companies where id = '1'
450μs656B/components/com_osproperty/router.php:505CopySelect id, country_name from josph_osrs_countries where id = '41'
337μs592B/components/com_osproperty/router.php:519CopySelect count(id) from josph_menu where id = '125' and published = '1'
370μs536B/components/com_osproperty/helpers/route.php:612CopySelect id, company_alias,company_name from josph_osrs_companies where id = '1'
360μs656B/components/com_osproperty/router.php:505CopySelect id, country_name from josph_osrs_countries where id = '41'
474μs592B/components/com_osproperty/router.php:519CopySelect count(id) from josph_menu where id = '126' and published = '1'
347μs536B/components/com_osproperty/helpers/route.php:612CopySelect id, company_alias,company_name from josph_osrs_companies where id = '1'
528μs656B/components/com_osproperty/router.php:505CopySelect id, country_name from josph_osrs_countries where id = '41'
374μs592B/components/com_osproperty/router.php:519CopySelect count(id) from josph_menu where id = '127' and published = '1'
691μs536B/components/com_osproperty/helpers/route.php:612CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `josph_modules` AS `m`
LEFT JOIN `josph_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `josph_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.06ms1.88KBParams/libraries/src/Cache/Controller/CallbackController.php:51CopySELECT m.id, m.alias, m.path AS route, m.level, m.parent_id
FROM josph_menu AS m
WHERE m.menutype = 'ambrosia-theme' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0
ORDER BY m.lft
580μs784B/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `josph_modules` AS `m`
LEFT JOIN `josph_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `josph_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`
2.06ms1.88KBParams/libraries/src/Cache/Controller/CallbackController.php:51CopySELECT 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 `josph_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1
572μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465CopySELECT `session_id`
FROM `josph_session`
WHERE `session_id` = ?
467μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277CopyUPDATE `josph_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
724μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy