Skip to main content

Celebrate Sant Bartomeu at Villa Mercedes watching the fireworks

sant bartomeu 2023 fireworks

The evening of Sant Bartomeu is one of the most popular festive events in Ibiza, with live shows and glorious fireworks that light up San Antonio bay. Come and have dinner at Villa Mercedes and enjoy this fantastic display from the garden of the most beautiful villa on the promenade. It’s the local fiestas! Come celebrate with us!

The perfect place to have dinner and watch the fireworks on the evening of Sant Bartomeu 2023

If you’re looking for a special restaurant to have dinner in San Antonio on 24th August, book now a table at Villa Mercedes, a beautiful restaurant with garden opposite the marina in what used to be a holiday villa in the early 20th century. You won’t only find pleasant spots to enjoy the carefully prepared modern Mediterranean food, but also a great atmosphere, refreshing and original cocktails and live shows and DJ sessions. The perfect plan while you wait for the fabulous firework display for Sant Bartomeu, at midnight.

t noche sant bartomeu puerto Sant Bartomeu's fireworks. © Visit.santantoni.net

5 suggestions for your Sant Bartomeu dinner in San Antonio

For this festive day, nothing beats our fried empanadita de caviar (caviar patty) and a plate of oysters. These two starters are the perfect choice to set the mood for this festive night, wouldn’t you say? And if you’d like to stick to sea flavours, you can order the butterfly-cut anchovies marinated with garlic, parsley and lemon or the clams in green sauce.

For the main course, to celebrate San Antonio’s local fiestas, nothing better than the Josper-grilled crayfish with frita ibicenca and the creamy rice with red shrimp. But if you’d rather go for meat on Sant Bartomeu night, we recommend our lamb chops with frita ibicenca.

And for dessert, something to take us back to our happiest childhood summers: strawberries with cream and chocolate. Or what about our matcha cheesecake?

These suggestions are in honour of the traditional Sant Bartomeu fiestas, but you’ll find other delicious dishes on our menu for you to choose the food that most tempts you and enjoy a special dinner followed by the fireworks that mark the end of the local fiestas.

VM sant bartomeu dinner 1Lamb chops with frita ibicenca. © Luana Failla / VIlla Mercedes

The best cocktails to have before and after the Sant Bartomeu firework display

All our cocktails are perfect for gatherings and celebrations, but if you’re looking for suggestions for this special night, we recommend these cocktails with an Ibizan touch for you to raise a glass to the fiestas of Sant Bartomeu with a surprising mix.

  • Tanit’s Moon: this cocktail named after the Phoenician goddess if made with butterfly blue pea flower infused with G-vine, lime juice, syrup and orange.
  • Micaleta: made with Caleta coffee liquor, this Ibizan-style cocktail also has Mezcal Ojo de Dios, coffee and Liquor 43.
  • Ibiza Island Ice Tea: this delicious mocktail is prepared with black tea, lemon, syrup and mint.

VM sant bartomeu drinksCheers!. © Luana Failla / Villa Mercedes

Book early for Sant Bartomeu 2023

As it’s such an important day in the local fiestas of San Antonio, we recommend you book a table as soon as possible. You can book from our website, calling (+34) 971 348 543 or sending a message by  WhatsApp. Remember that the lighting of the firework display for Sant Bartomeu is one of the most anticipated moments in the fiestas and restaurants overlooking the bay are the first choice among residents and holidaymakers to dine with friends, partners or family. See you soon!

VM sant bartomeu dinner 2See you at  Villa Mercedes! © Angel Camarena / VM

Subscribe to our newsletter

10.993MBMemory Usage524msRequest Duration
Joomla! Version4.4.1
PHP Version8.0.22
Identityguest
Response200
Templateyootheme
Database
Server
mysql
Version
10.3.39-MariaDB-log
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:75 [ "TZ" => "Europe/Madrid" "PHPRC" => "/home/villamer/etc/php8.0" "PWD" => "***redacte...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743438206 "last" => 1743438206...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter
array:1 [ "language" => "en-GB" ]
  • afterLoad (909.41KB) (50.13ms)
  • afterInitialise (4.24MB) (198ms)
  • afterRoute (1.2MB) (51.41ms)
  • beforeRenderComponent com_content (177.16KB) (6.19ms)
  • Before Access::preloadComponents (all components) (122.3KB) (6.97ms)
  • After Access::preloadComponents (all components) (121.7KB) (712μs)
  • Before Access::preloadPermissions (com_content) (2.76KB) (16μs)
  • After Access::preloadPermissions (com_content) (14.27KB) (259μs)
  • Before Access::getAssetRules (id:150 name:com_content.article.39) (1.3KB) (14μs)
  • After Access::getAssetRules (id:150 name:com_content.article.39) (9.95KB) (682μs)
  • afterRenderComponent com_content (2.41MB) (137ms)
  • Before Access::getAssetRules (id:8 name:com_content) (119.16KB) (7.97ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (13μs)
  • afterDispatch (42.63KB) (2.27ms)
  • beforeRenderRawModule mod_yootheme_builder (Footer EN) (179.04KB) (12.47ms)
  • afterRenderRawModule mod_yootheme_builder (Footer EN) (209.26KB) (10.54ms)
  • beforeRenderModule mod_yootheme_builder (Footer EN) (720B) (7μs)
  • afterRenderModule mod_yootheme_builder (Footer EN) (2.7KB) (362μs)
  • beforeRenderRawModule mod_menu (Menu EN) (12.56KB) (174μs)
  • afterRenderRawModule mod_menu (Menu EN) (48.75KB) (3.88ms)
  • beforeRenderModule mod_menu (Menu EN) (704B) (5μs)
  • afterRenderModule mod_menu (Menu EN) (3.51KB) (190μs)
  • beforeRenderRawModule mod_custom (Bookings EN) (3.09KB) (22μs)
  • afterRenderRawModule mod_custom (Bookings EN) (70.35KB) (988μs)
  • beforeRenderModule mod_custom (Bookings EN) (720B) (5μs)
  • afterRenderModule mod_custom (Bookings EN) (2.53KB) (78μs)
  • beforeRenderRawModule mod_custom () (1.95KB) (547μs)
  • afterRenderRawModule mod_custom () (11.22KB) (1.66ms)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (2.66KB) (55μs)
  • beforeRenderRawModule mod_menu (Menu EN) (9.46KB) (2ms)
  • afterRenderRawModule mod_menu (Menu EN) (576B) (480μs)
  • beforeRenderModule mod_menu (Menu EN) (704B) (5μs)
  • afterRenderModule mod_menu (Menu EN) (5.17KB) (57μs)
  • beforeRenderRawModule mod_custom () (4.48KB) (90μs)
  • afterRenderRawModule mod_custom () (944B) (275μs)
  • beforeRenderModule mod_custom () (704B) (5μs)
  • afterRenderModule mod_custom () (1.24KB) (84μs)
  • beforeRenderRawModule mod_languages (Idiomas) (4.02KB) (18μs)
  • afterRenderRawModule mod_languages (Idiomas) (21.83KB) (6.1ms)
  • beforeRenderModule mod_languages (Idiomas) (720B) (8μs)
  • afterRenderModule mod_languages (Idiomas) (1.27KB) (136μs)
  • beforeRenderRawModule mod_menu (Menu EN mobile) (3.12KB) (273μs)
  • afterRenderRawModule mod_menu (Menu EN mobile) (2.91KB) (1.09ms)
  • beforeRenderModule mod_menu (Menu EN mobile) (720B) (5μs)
  • afterRenderModule mod_menu (Menu EN mobile) (1.27KB) (114μs)
  • beforeRenderRawModule mod_custom (Bookings EN - Mobile) (1.7KB) (20μs)
  • afterRenderRawModule mod_custom (Bookings EN - Mobile) (976B) (36μs)
  • beforeRenderModule mod_custom (Bookings EN - Mobile) (720B) (3μs)
  • afterRenderModule mod_custom (Bookings EN - Mobile) (1.27KB) (82μs)
  • beforeRenderRawModule mod_languages (Idiomas Mobile) (2.09KB) (18μs)
  • afterRenderRawModule mod_languages (Idiomas Mobile) (1.72KB) (403μs)
  • beforeRenderModule mod_languages (Idiomas Mobile) (720B) (4μs)
  • afterRenderModule mod_languages (Idiomas Mobile) (1.27KB) (86μs)
  • beforeRenderRawModule mod_custom () (3.53KB) (11μs)
  • afterRenderRawModule mod_custom () (896B) (367μs)
  • beforeRenderModule mod_custom () (704B) (5μs)
  • afterRenderModule mod_custom () (1.24KB) (83μs)
  • beforeRenderRawModule mod_custom () (10.62KB) (301μs)
  • afterRenderRawModule mod_custom () (896B) (158μs)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (2.51KB) (42μs)
  • beforeRenderRawModule mod_custom () (2.44KB) (1.05ms)
  • afterRenderRawModule mod_custom () (896B) (162μs)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (13.45KB) (44μs)
  • afterRender (631.29KB) (16.61ms)
  • 1 x afterInitialise (4.24MB) (37.78%)
    197.94ms
    1 x afterRenderComponent com_content (2.41MB) (26.1%)
    136.77ms
    1 x afterRoute (1.2MB) (9.81%)
    51.41ms
    1 x afterLoad (909.41KB) (9.57%)
    50.13ms
    1 x afterRender (631.29KB) (3.17%)
    16.61ms
    1 x beforeRenderRawModule mod_yootheme_builder (Footer EN) (179.04KB) (2.38%)
    12.47ms
    1 x afterRenderRawModule mod_yootheme_builder (Footer EN) (209.26KB) (2.01%)
    10.54ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (119.16KB) (1.52%)
    7.97ms
    1 x Before Access::preloadComponents (all components) (122.3KB) (1.33%)
    6.97ms
    1 x beforeRenderComponent com_content (177.16KB) (1.18%)
    6.19ms
    1 x afterRenderRawModule mod_languages (Idiomas) (21.83KB) (1.16%)
    6.10ms
    1 x afterRenderRawModule mod_menu (Menu EN) (48.75KB) (0.74%)
    3.88ms
    1 x afterDispatch (42.63KB) (0.43%)
    2.27ms
    1 x beforeRenderRawModule mod_menu (Menu EN) (9.46KB) (0.38%)
    2.00ms
    1 x afterRenderRawModule mod_custom () (11.22KB) (0.32%)
    1.66ms
    1 x afterRenderRawModule mod_menu (Menu EN mobile) (2.91KB) (0.21%)
    1.09ms
    1 x beforeRenderRawModule mod_custom () (2.44KB) (0.2%)
    1.05ms
    1 x afterRenderRawModule mod_custom (Bookings EN) (70.35KB) (0.19%)
    988μs
    1 x After Access::preloadComponents (all components) (121.7KB) (0.14%)
    712μs
    3 x afterRenderRawModule mod_custom () (896B) (0.13%)
    687μs
    1 x After Access::getAssetRules (id:150 name:com_content.article.39) (9.95KB) (0.13%)
    682μs
    1 x beforeRenderRawModule mod_custom () (1.95KB) (0.1%)
    547μs
    1 x afterRenderRawModule mod_menu (Menu EN) (576B) (0.09%)
    480μs
    1 x afterRenderRawModule mod_languages (Idiomas Mobile) (1.72KB) (0.08%)
    403μs
    1 x afterRenderModule mod_yootheme_builder (Footer EN) (2.7KB) (0.07%)
    362μs
    1 x beforeRenderRawModule mod_custom () (10.62KB) (0.06%)
    301μs
    1 x afterRenderRawModule mod_custom () (944B) (0.05%)
    275μs
    1 x beforeRenderRawModule mod_menu (Menu EN mobile) (3.12KB) (0.05%)
    273μs
    1 x After Access::preloadPermissions (com_content) (14.27KB) (0.05%)
    259μs
    1 x afterRenderModule mod_menu (Menu EN) (3.51KB) (0.04%)
    190μs
    1 x beforeRenderRawModule mod_menu (Menu EN) (12.56KB) (0.03%)
    174μs
    2 x afterRenderModule mod_custom () (1.24KB) (0.03%)
    167μs
    1 x afterRenderModule mod_languages (Idiomas) (1.27KB) (0.03%)
    136μs
    1 x afterRenderModule mod_menu (Menu EN mobile) (1.27KB) (0.02%)
    114μs
    1 x beforeRenderRawModule mod_custom () (4.48KB) (0.02%)
    90μs
    1 x afterRenderModule mod_languages (Idiomas Mobile) (1.27KB) (0.02%)
    86μs
    1 x afterRenderModule mod_custom (Bookings EN - Mobile) (1.27KB) (0.02%)
    82μs
    1 x afterRenderModule mod_custom (Bookings EN) (2.53KB) (0.01%)
    78μs
    1 x afterRenderModule mod_menu (Menu EN) (5.17KB) (0.01%)
    57μs
    1 x afterRenderModule mod_custom () (2.66KB) (0.01%)
    55μs
    1 x afterRenderModule mod_custom () (13.45KB) (0.01%)
    44μs
    1 x afterRenderModule mod_custom () (2.51KB) (0.01%)
    42μs
    1 x afterRenderRawModule mod_custom (Bookings EN - Mobile) (976B) (0.01%)
    36μs
    5 x beforeRenderModule mod_custom () (704B) (0%)
    24μs
    1 x beforeRenderRawModule mod_custom (Bookings EN) (3.09KB) (0%)
    22μs
    1 x beforeRenderRawModule mod_custom (Bookings EN - Mobile) (1.7KB) (0%)
    20μs
    1 x beforeRenderRawModule mod_languages (Idiomas) (4.02KB) (0%)
    18μs
    1 x beforeRenderRawModule mod_languages (Idiomas Mobile) (2.09KB) (0%)
    18μs
    1 x Before Access::preloadPermissions (com_content) (2.76KB) (0%)
    16μs
    1 x Before Access::getAssetRules (id:150 name:com_content.article.39) (1.3KB) (0%)
    14μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0%)
    13μs
    1 x beforeRenderRawModule mod_custom () (3.53KB) (0%)
    11μs
    2 x beforeRenderModule mod_menu (Menu EN) (704B) (0%)
    10μs
    1 x beforeRenderModule mod_languages (Idiomas) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_yootheme_builder (Footer EN) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_custom (Bookings EN) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Menu EN mobile) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_languages (Idiomas Mobile) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (Bookings EN - Mobile) (720B) (0%)
    3μs
45 statements were executed, 9 of which were duplicates, 36 unique18.84ms426.64KB
  • SELECT @@SESSION.sql_mode;82μs1.59KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?200μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 1116μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)4.54ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `jos_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 179μs4.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`59μs1.11KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `jos_usergroups` AS `a` LEFT JOIN `jos_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest45μs1.67KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `jos_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`132μs56.3KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `jos_languages` WHERE `published` = 1 ORDER BY `ordering` ASC87μs3.92KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT params FROM jos_extensions WHERE element = 'cookiespolicynotificationbar' AND folder = 'system'66μs40.85KB/plugins/system/cookiespolicynotificationbar/cookiespolicynotificationbar.php:213Copy
  • SELECT `enabled` FROM `jos_extensions` WHERE `type` = 'plugin' AND `element` = 'cache' AND `folder` = 'system'38μs872B/plugins/system/cookiespolicynotificationbar/cookiespolicynotificationbar.php:2571Copy
  • SELECT `element`,`name`,`client_id`,`extension_id` FROM `jos_extensions` WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 148μs1.38KB/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT id,template FROM jos_template_styles WHERE client_id=0 AND home=152μs944B/administrator/components/com_widgetkit/widgetkit.php:28Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system'41μs872B/plugins/system/yooessentials/helper.php:152Copy
  • 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 `jos_menu` AS `m` LEFT JOIN `jos_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`667μs28.86KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • 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 `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray1,:preparedArray2)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`486μs6.03KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `jos_template_styles` AS `s` LEFT JOIN `jos_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` = 174μs19.97KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 145μs872B/plugins/system/yooessentials/modules/core-joomla/src/Database.php:54Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_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)126μs10.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 067μs6.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`475μs10.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '39'2.76ms48B/libraries/src/Table/Table.php:1325Copy
  • 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 `jos_content` AS `a` INNER JOIN `jos_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jos_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jos_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jos_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jos_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)427μs25.44KBParams/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 `jos_categories` AS `s` INNER JOIN `jos_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`359μs6.09KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `jos_contentitem_tag_map` AS `m` INNER JOIN `jos_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)302μs5.73KBParams/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 `jos_categories` AS `s` INNER JOIN `jos_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`174μs6.09KBParams/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 jos_fields AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id LEFT JOIN jos_fields_groups AS g ON g.id = a.group_id LEFT JOIN `jos_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 ASC1.08ms6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • 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 `jos_categories` AS `s` INNER JOIN `jos_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`100μs6.09KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1166μs120.85KB/templates/yootheme/packages/platform-joomla/src/Storage.php:30Copy
  • SELECT extension_id FROM jos_extensions WHERE type='plugin' AND element = 'cookiespolicynotificationbar' AND folder='system'64μs872B/plugins/system/cookiespolicynotificationbar/cookiespolicynotificationbar.php:756Copy
  • SELECT extension_id FROM jos_extensions WHERE type='plugin' AND element = 'cookiespolicynotificationbar' AND folder='system'70μs0B/plugins/system/cookiespolicynotificationbar/cookiespolicynotificationbar.php:757Copy
  • SELECT `language`,`id` FROM `jos_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 034μs1.02KB/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `jos_content` WHERE `id` = :id138μs12.64KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `jos_content` WHERE `id` = :id56μs1.64KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `jos_content` AS `c` INNER JOIN `jos_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `jos_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `jos_content` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `jos_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-03-31 16:23:26') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-03-31 16:23:26') AND c2.state = 1457μs1.84KBParams/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 `jos_categories` AS `s` INNER JOIN `jos_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`479μs6.09KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `jos_modules` AS `m` LEFT JOIN `jos_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `jos_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`603μs3.28KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • 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 jos_fields AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id LEFT JOIN jos_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) 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 (:preparedArray5,:preparedArray6) ORDER BY a.ordering ASC743μs6KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `c2`.`language`,`c2`.`id` FROM `jos_menu` AS `c` INNER JOIN `jos_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `jos_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `jos_menu` AS `c2` ON `a2`.`id` = `c2`.`id` WHERE `c`.`id` = :id221μs1.78KBParams/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 `jos_scheduler_tasks` AS `a` WHERE `a`.`state` = 1174μs1.71KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `alias` FROM `jos_content` WHERE `id` = :id111μs1.64KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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 `jos_categories` AS `s` INNER JOIN `jos_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`112μs6.09KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `jos_content` WHERE `id` = :id39μs1.64KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?129μs1.64KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?2.52ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy