CHECK-IN 23-Jun-25
⇌
CHECK-OUT 24-Jun-25
CHECK-IN 23-Jun-25
⇌
CHECK-OUT 24-Jun-25

Prime Secluded Location!
A Luxury Resort in Cabo San Lucas

Discover paradise high above the sea in a dramatic destination that gives you seclusion, but is still close to the best of the Baja. Ignite your imagination with spectacular views of Land's End.

A Paradise of Elegance

Hacienda Encantada brings you the finest Los Cabos luxury experience offering an optional All Inclusive stay, pairing exquisite suites and private villas with superior service, traditional Mexican architecture and breathtaking landscapes.

THE STAY

We offer a variety of accommodations to suit every need. Choose from our spacious Hacienda Suites, comfortable Studios, or luxurious Villas & Residences. Each option blends authentic hacienda-style charm with modern amenities, ensuring a perfect stay for all our guests.

Encanto Studios

Explore

 

Villas & Residences

Explore

 

Hacienda Suites

Explore

 

EXPERIENCE

Amenities

Guaranteed fun for the little ones! A specially designed space where kids can play, explore, and enjoy exciting adventures. With supervised activities, water games, and plenty of surprises!

❮ ❯

DINING

Dine Out All Inclusive Plan

Learn More

 

GATHERINGS

Weddings

Explore

 

Meet & Celebrate

Explore

 

WELLNESS

Milagro Spa

At Milagro Spa, we guide you to reconnect with your inner self and harmonize mind, body, and soul. Let nature’s wisdom heal you.

❮ ❯

Specials & Packages

Springtime Enchantment

 

Learn More

 

Invalid email address.

BE THE FIRST

Sign up and receive the latest information and updates from Hacienda Encantada Resort


J! InfoRequestSessionProfileQueries59
Settings4.022MBMemory Usage62.6msRequest Duration
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
Joomla! Version5.3.0
PHP Version8.2.28
Identityguest
Response200
Templatepaginas
Database
Server
mysql
Version
10.6.22-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
array:2 [ "sa" => "X" "ved" => "2ahUKEwiB44z53aCNAxXKKwYAHZLVDvkQyK4DegUIAxD7Aw" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:56 [ "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin" "USER" => "mexicogr" ...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1750641750 "last" => 1750641750...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter
array:1 [ "language" => "en-GB" ]
  • afterLoad (89.91KB) (1.1ms)
  • afterInitialise (1.66MB) (17.82ms)
  • afterRoute (161.05KB) (2.97ms)
  • beforeRenderComponent com_content (49.62KB) (1.26ms)
  • Before Access::preloadComponents (all components) (39.18KB) (726μs)
  • After Access::preloadComponents (all components) (127.26KB) (795μs)
  • Before Access::preloadPermissions (com_content) (424B) (19μs)
  • After Access::preloadPermissions (com_content) (3.44KB) (457μs)
  • Before Access::getAssetRules (id:115 name:com_content.article.1) (104B) (16μs)
  • After Access::getAssetRules (id:115 name:com_content.article.1) (16.3KB) (123μs)
  • afterRenderComponent com_content (307.63KB) (11.09ms)
  • Before Access::getAssetRules (id:8 name:com_content) (27.77KB) (1.15ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.28KB) (11μs)
  • afterDispatch (39.75KB) (1.42ms)
  • beforeRenderRawModule mod_custom (Footer Ingles) (88KB) (1.45ms)
  • afterRenderRawModule mod_custom (Footer Ingles) (4.27KB) (367μs)
  • beforeRenderModule mod_custom (Footer Ingles) (720B) (6μs)
  • afterRenderModule mod_custom (Footer Ingles) (7.99KB) (129μs)
  • beforeRenderRawModule mod_custom (toTop) (1.21KB) (20μs)
  • afterRenderRawModule mod_custom (toTop) (976B) (41μs)
  • beforeRenderModule mod_custom (toTop) (704B) (3μs)
  • afterRenderModule mod_custom (toTop) (3.21KB) (36μs)
  • beforeRenderRawModule mod_custom (Instagram) (3.3KB) (74μs)
  • afterRenderRawModule mod_custom (Instagram) (992B) (36μs)
  • beforeRenderModule mod_custom (Instagram) (720B) (2μs)
  • afterRenderModule mod_custom (Instagram) (2.9KB) (34μs)
  • beforeRenderRawModule mod_rsform (SignUp) (1.18KB) (14μs)
  • afterRenderRawModule mod_rsform (SignUp) (477.73KB) (7.55ms)
  • beforeRenderModule mod_rsform (SignUp) (704B) (6μs)
  • afterRenderModule mod_rsform (SignUp) (5.4KB) (63μs)
  • beforeRenderRawModule mod_custom (Offers) (1008B) (49μs)
  • afterRenderRawModule mod_custom (Offers) (928B) (53μs)
  • beforeRenderModule mod_custom (Offers) (704B) (3μs)
  • afterRenderModule mod_custom (Offers) (6.52KB) (36μs)
  • beforeRenderRawModule mod_custom (Booking Widget Ingles) (848B) (33μs)
  • afterRenderRawModule mod_custom (Booking Widget Ingles) (928B) (33μs)
  • beforeRenderModule mod_custom (Booking Widget Ingles) (720B) (3μs)
  • afterRenderModule mod_custom (Booking Widget Ingles) (4.04KB) (31μs)
  • beforeRenderRawModule mod_custom (Slider - Home) (864B) (41μs)
  • afterRenderRawModule mod_custom (Slider - Home) (992B) (31μs)
  • beforeRenderModule mod_custom (Slider - Home) (720B) (3μs)
  • afterRenderModule mod_custom (Slider - Home) (3.23KB) (31μs)
  • beforeRenderRawModule mod_custom (Menu Ingles) (864B) (30μs)
  • afterRenderRawModule mod_custom (Menu Ingles) (928B) (37μs)
  • beforeRenderModule mod_custom (Menu Ingles) (720B) (2μs)
  • afterRenderModule mod_custom (Menu Ingles) (18.79KB) (49μs)
  • beforeRenderRawModule mod_custom (Menu Mobile Ingles) (1.21KB) (15μs)
  • afterRenderRawModule mod_custom (Menu Mobile Ingles) (928B) (34μs)
  • beforeRenderModule mod_custom (Menu Mobile Ingles) (720B) (3μs)
  • afterRenderModule mod_custom (Menu Mobile Ingles) (14.79KB) (29μs)
  • beforeRenderRawModule mod_languages (Idiomas) (10.95KB) (21μs)
  • afterRenderRawModule mod_languages (Idiomas) (22.41KB) (1.1ms)
  • beforeRenderModule mod_languages (Idiomas) (704B) (6μs)
  • afterRenderModule mod_languages (Idiomas) (3.29KB) (50μs)
  • afterRender (271.87KB) (11.73ms)
  • 1 x afterInitialise (1.66MB) (28.46%)
    17.82ms
    1 x afterRender (271.87KB) (18.73%)
    11.73ms
    1 x afterRenderComponent com_content (307.63KB) (17.72%)
    11.09ms
    1 x afterRenderRawModule mod_rsform (SignUp) (477.73KB) (12.06%)
    7.55ms
    1 x afterRoute (161.05KB) (4.75%)
    2.97ms
    1 x beforeRenderRawModule mod_custom (Footer Ingles) (88KB) (2.32%)
    1.45ms
    1 x afterDispatch (39.75KB) (2.26%)
    1.42ms
    1 x beforeRenderComponent com_content (49.62KB) (2.01%)
    1.26ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (27.77KB) (1.84%)
    1.15ms
    1 x afterRenderRawModule mod_languages (Idiomas) (22.41KB) (1.76%)
    1.10ms
    1 x afterLoad (89.91KB) (1.75%)
    1.10ms
    1 x After Access::preloadComponents (all components) (127.26KB) (1.27%)
    795μs
    1 x Before Access::preloadComponents (all components) (39.18KB) (1.16%)
    726μs
    1 x After Access::preloadPermissions (com_content) (3.44KB) (0.73%)
    457μs
    1 x afterRenderRawModule mod_custom (Footer Ingles) (4.27KB) (0.59%)
    367μs
    1 x afterRenderModule mod_custom (Footer Ingles) (7.99KB) (0.21%)
    129μs
    1 x After Access::getAssetRules (id:115 name:com_content.article.1) (16.3KB) (0.2%)
    123μs
    1 x beforeRenderRawModule mod_custom (Instagram) (3.3KB) (0.12%)
    74μs
    1 x afterRenderModule mod_rsform (SignUp) (5.4KB) (0.1%)
    63μs
    1 x afterRenderRawModule mod_custom (Offers) (928B) (0.08%)
    53μs
    1 x afterRenderModule mod_languages (Idiomas) (3.29KB) (0.08%)
    50μs
    1 x beforeRenderRawModule mod_custom (Offers) (1008B) (0.08%)
    49μs
    1 x afterRenderModule mod_custom (Menu Ingles) (18.79KB) (0.08%)
    49μs
    1 x afterRenderRawModule mod_custom (toTop) (976B) (0.07%)
    41μs
    1 x beforeRenderRawModule mod_custom (Slider - Home) (864B) (0.07%)
    41μs
    1 x afterRenderRawModule mod_custom (Menu Ingles) (928B) (0.06%)
    37μs
    1 x afterRenderModule mod_custom (toTop) (3.21KB) (0.06%)
    36μs
    1 x afterRenderRawModule mod_custom (Instagram) (992B) (0.06%)
    36μs
    1 x afterRenderModule mod_custom (Offers) (6.52KB) (0.06%)
    36μs
    1 x afterRenderModule mod_custom (Instagram) (2.9KB) (0.05%)
    34μs
    1 x afterRenderRawModule mod_custom (Menu Mobile Ingles) (928B) (0.05%)
    34μs
    1 x beforeRenderRawModule mod_custom (Booking Widget Ingles) (848B) (0.05%)
    33μs
    1 x afterRenderRawModule mod_custom (Booking Widget Ingles) (928B) (0.05%)
    33μs
    1 x afterRenderModule mod_custom (Booking Widget Ingles) (4.04KB) (0.05%)
    31μs
    1 x afterRenderRawModule mod_custom (Slider - Home) (992B) (0.05%)
    31μs
    1 x afterRenderModule mod_custom (Slider - Home) (3.23KB) (0.05%)
    31μs
    1 x beforeRenderRawModule mod_custom (Menu Ingles) (864B) (0.05%)
    30μs
    1 x afterRenderModule mod_custom (Menu Mobile Ingles) (14.79KB) (0.05%)
    29μs
    1 x beforeRenderRawModule mod_languages (Idiomas) (10.95KB) (0.03%)
    21μs
    1 x beforeRenderRawModule mod_custom (toTop) (1.21KB) (0.03%)
    20μs
    1 x Before Access::preloadPermissions (com_content) (424B) (0.03%)
    19μs
    1 x Before Access::getAssetRules (id:115 name:com_content.article.1) (104B) (0.03%)
    16μs
    1 x beforeRenderRawModule mod_custom (Menu Mobile Ingles) (1.21KB) (0.02%)
    15μs
    1 x beforeRenderRawModule mod_rsform (SignUp) (1.18KB) (0.02%)
    14μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.28KB) (0.02%)
    11μs
    1 x beforeRenderModule mod_custom (Footer Ingles) (720B) (0.01%)
    6μs
    1 x beforeRenderModule mod_rsform (SignUp) (704B) (0.01%)
    6μs
    1 x beforeRenderModule mod_languages (Idiomas) (704B) (0.01%)
    6μs
    1 x beforeRenderModule mod_custom (Offers) (704B) (0%)
    3μs
    1 x beforeRenderModule mod_custom (Booking Widget Ingles) (720B) (0%)
    3μs
    1 x beforeRenderModule mod_custom (Slider - Home) (720B) (0%)
    3μs
    1 x beforeRenderModule mod_custom (Menu Mobile Ingles) (720B) (0%)
    3μs
    1 x beforeRenderModule mod_custom (toTop) (704B) (0%)
    3μs
    1 x beforeRenderModule mod_custom (Instagram) (720B) (0%)
    2μs
    1 x beforeRenderModule mod_custom (Menu Ingles) (720B) (0%)
    2μs
59 statements were executed, 9 of which were duplicates, 50 unique12.24ms203.61KB
UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4
  • SELECT @@SESSION.sql_mode;93μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `ftq8n_session` WHERE `session_id` = ?160μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `ftq8n_session` WHERE `session_id` = :session_id LIMIT 180μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `ftq8n_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)494μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `ftq8n_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1319μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `ftq8n_viewlevels`91μs656B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `ftq8n_usergroups` AS `a` LEFT JOIN `ftq8n_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest132μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `ftq8n_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`607μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `value` FROM `ftq8n_admintools_storage` WHERE `key` = 'cparams'112μs1.15KB/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT * FROM `ftq8n_languages` WHERE `published` = 1 ORDER BY `ordering` ASC149μs1.61KB/libraries/src/Language/LanguageHelper.php:179Copy
  • SELECT `option`,`view`,`query` FROM `ftq8n_admintools_wafexceptions`65μs640B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `ftq8n_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'152μs536B/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT `element`,`name`,`client_id`,`extension_id` FROM `ftq8n_extensions` WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1138μs784B/libraries/src/Language/LanguageHelper.php:252Copy
  • SELECT `params` FROM `ftq8n_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'134μs536B/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM `ftq8n_admintools_ipautoban`77μs656B/plugins/system/admintools/src/Utility/Cache.php:126Copy
  • SELECT `ip` FROM `ftq8n_admintools_ipblock`84μs1.13KB/plugins/system/admintools/src/Utility/Cache.php:136Copy
  • SELECT * FROM `ftq8n_admintools_storage` WHERE `key` LIKE 'timestamp_%'91μs1.83KB/plugins/system/admintools/src/Feature/Base.php:253Copy
  • SELECT `source`,`dest`,`keepurlparams` FROM `ftq8n_admintools_redirects` WHERE `published` = 1 ORDER BY `ordering` ASC86μs640B/plugins/system/admintools/src/Utility/Cache.php:162Copy
  • SELECT * FROM ftq8n_rsform_config88μs1.19KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • UPDATE ftq8n_rsform_config SET `SettingValue`='1750641750' WHERE `SettingName`='deleteafter.last_run'316μs48B/administrator/components/com_rsform/helpers/config.php:92Copy
  • SELECT `FormId`,`DeleteSubmissionsAfter` FROM `ftq8n_rsform_forms` WHERE `DeleteSubmissionsAfter` > '0'87μs528B/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:53Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `ftq8n_menu` AS `m` LEFT JOIN `ftq8n_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`471μs36.05KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `option`,`view`,`task`,`query`,`query_type`,`query_content`,`verb`,`application` FROM `ftq8n_admintools_wafblacklists` WHERE `enabled` = 1118μs976B/plugins/system/admintools/src/Utility/Cache.php:182Copy
  • SELECT `alias`,`catid` FROM ftq8n_content WHERE `id` = :key106μs1.37KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `ftq8n_template_styles` AS `s` LEFT JOIN `ftq8n_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` = 1198μs832B/administrator/components/com_templates/src/Model/StyleModel.php:718Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `ftq8n_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41)429μs7.56KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `ftq8n_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0252μs2.23KBParams/libraries/src/Access/Access.php:301Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `ftq8n_content` AS `a` INNER JOIN `ftq8n_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `ftq8n_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `ftq8n_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `ftq8n_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `ftq8n_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0 AND `a`.`language` IN (:preparedArray1,:preparedArray2)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray3,:preparedArray4)360μs22.23KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `ftq8n_categories` AS `s` INNER JOIN `ftq8n_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`329μs3.97KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `ftq8n_contentitem_tag_map` AS `m` INNER JOIN `ftq8n_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2)228μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `ftq8n_categories` AS `s` INNER JOIN `ftq8n_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`307μs3.97KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM ftq8n_fields AS a LEFT JOIN `ftq8n_languages` AS l ON l.lang_code = a.language LEFT JOIN ftq8n_users AS uc ON uc.id=a.checked_out LEFT JOIN ftq8n_viewlevels AS ag ON ag.id = a.access LEFT JOIN ftq8n_users AS ua ON ua.id = a.created_user_id LEFT JOIN ftq8n_fields_groups AS g ON g.id = a.group_id LEFT JOIN `ftq8n_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2)) AND `a`.`access` IN (:preparedArray3,:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray7,:preparedArray8) ORDER BY a.ordering ASC771μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `language`,`id` FROM `ftq8n_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0169μs3.11KB/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias`,`catid` FROM ftq8n_content WHERE `id` = :key95μs1.37KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT `alias`,`catid` FROM ftq8n_content WHERE `id` = :key78μs1.37KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `ftq8n_content` AS `c` INNER JOIN `ftq8n_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `ftq8n_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `ftq8n_content` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `ftq8n_categories` AS `ca` ON `c2`.`catid` = `ca`.`id` AND `ca`.`extension` = :extension2 WHERE `c`.`id` = :id AND c2.access IN (1,5) AND c2.language != 'en-GB' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-06-23 01:22:30') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-06-23 01:22:30') AND c2.state = 1291μs1.48KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `ftq8n_categories` AS `s` INNER JOIN `ftq8n_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`287μs3.97KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `ftq8n_modules` AS `m` LEFT JOIN `ftq8n_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `ftq8n_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) AND `m`.`language` IN (:preparedArray3,:preparedArray4) ORDER BY `m`.`position`,`m`.`ordering`582μs34KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT * FROM `ftq8n_rsform_forms` WHERE `FormId`='1'343μs10.41KB/administrator/components/com_rsform/helpers/rsform.php:3635Copy
  • SELECT `Lang` FROM ftq8n_rsform_forms WHERE `FormId` = '1'69μs536B/administrator/components/com_rsform/helpers/rsform.php:2956Copy
  • SELECT `ComponentId` FROM `ftq8n_rsform_components` WHERE `ComponentTypeId` IN (6) AND `FormId` = '1' AND `Published` = '1'136μs520B/administrator/components/com_rsform/helpers/rsform.php:1715Copy
  • SELECT `ComponentId` FROM `ftq8n_rsform_components` WHERE `ComponentTypeId` IN (411) AND `FormId` = '1' AND `Published` = '1'146μs520B/administrator/components/com_rsform/helpers/rsform.php:1715Copy
  • SELECT `ComponentId` FROM `ftq8n_rsform_components` WHERE `ComponentTypeId` IN (355) AND `FormId` = '1' AND `Published` = '1'99μs520B/administrator/components/com_rsform/helpers/rsform.php:1715Copy
  • SELECT `p`.`PropertyValue` AS `name`,`c`.`ComponentId`,`c`.`ComponentTypeId`,`ct`.`ComponentTypeName`,`c`.`Order` FROM `ftq8n_rsform_properties` AS `p` LEFT JOIN `ftq8n_rsform_components` AS `c` ON (`c`.`ComponentId` = `p`.`ComponentId`) LEFT JOIN `ftq8n_rsform_component_types` AS `ct` ON (`ct`.`ComponentTypeId` = `c`.`ComponentTypeId`) WHERE `c`.`FormId` = '1' AND `p`.`PropertyName` = 'NAME' AND `c`.`Published` = '1' ORDER BY `c`.`Order` ASC279μs832B/administrator/components/com_rsform/helpers/rsform.php:2655Copy
  • SELECT `PropertyName`,`PropertyValue`,`ComponentId` FROM `ftq8n_rsform_properties` WHERE `ComponentId` IN (2,3,8,9,42)201μs1.25KB/administrator/components/com_rsform/helpers/rsform.php:740Copy
  • SELECT `FormId` FROM `ftq8n_rsform_components` WHERE `ComponentId`='2'65μs536B/administrator/components/com_rsform/helpers/rsform.php:755Copy
  • SELECT `ComponentId` FROM `ftq8n_rsform_components` WHERE `ComponentTypeId` IN (41) AND `FormId` = '1' AND `Published` = '1'117μs520B/administrator/components/com_rsform/helpers/rsform.php:1715Copy
  • SELECT `ComponentId` FROM `ftq8n_rsform_components` WHERE `ComponentTypeId` IN (2423) AND `FormId` = '1' AND `Published` = '1'140μs536B/administrator/components/com_rsform/helpers/rsform.php:1715Copy
  • SELECT `ComponentId` FROM `ftq8n_rsform_components` WHERE `ComponentTypeId` IN (9) AND `FormId` = '1' AND `Published` = '1'94μs520B/administrator/components/com_rsform/helpers/rsform.php:1715Copy
  • SELECT `p`.`PropertyValue` AS `ComponentName`,`p`.`ComponentId` FROM `ftq8n_rsform_components` AS `c` LEFT JOIN `ftq8n_rsform_properties` AS `p` ON (`c`.`ComponentId`=`p`.`ComponentId`) WHERE `c`.`FormId`='1' AND `p`.`PropertyName`='NAME' AND `c`.`Published` = '1' ORDER BY `c`.`Order` ASC239μs656B/administrator/components/com_rsform/helpers/conditions.php:38Copy
  • SELECT * FROM `ftq8n_rsform_conditions` WHERE `form_id` = '1' AND `lang_code` = 'en-GB' ORDER BY `ordering` ASC125μs912B/administrator/components/com_rsform/helpers/conditions.php:84Copy
  • SELECT * FROM `ftq8n_rsform_calculations` WHERE `formId` = '1' ORDER BY `ordering`86μs752B/administrator/components/com_rsform/helpers/rsform.php:3602Copy
  • SELECT `c2`.`language`,`c2`.`id` FROM `ftq8n_menu` AS `c` INNER JOIN `ftq8n_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `ftq8n_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `ftq8n_menu` AS `c2` ON `a2`.`id` = `c2`.`id` WHERE `c`.`id` = :id197μs1.41KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `ftq8n_scheduler_tasks` AS `a` WHERE `a`.`state` = 1124μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT * FROM `ftq8n_schemaorg` WHERE `itemId` = :itemId AND `context` = :context117μs1.55KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:406Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `ftq8n_content` AS `a` INNER JOIN `ftq8n_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `ftq8n_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `ftq8n_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `ftq8n_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `ftq8n_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0 AND `a`.`language` IN (:preparedArray1,:preparedArray2)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray3,:preparedArray4)346μs22.23KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `value` FROM `ftq8n_admintools_storage` WHERE `key` = 'criticalfiles'95μs536B/plugins/system/admintools/src/Feature/CriticalFilesMonitoring.php:188Copy
  • SELECT `session_id` FROM `ftq8n_session` WHERE `session_id` = ?97μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `ftq8n_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?494μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy