3 mouth-watering tables in Ibiza with a taste of the sea

Ibiza’s waters were always generous to the island, offering its people sea beds full of delicious fish and seafood. One of Ibiza’s greatest appeals is its many fish restaurants along the coast. In this article, we suggest 3 restaurants where you won’t be able to resist licking your fingers. Check them out and... enjoy your meal!

Cala Gracioneta

This is our first suggestion because we love this place and it’s the closest to Hostal La Torre, as it’s on the nearby beach of Cala Gracioneta. From its menu we recommend the delicious –and addictive– mussels in sauce, the coal-grilled clams, fish paella, black rice and the suquet de peix (fish stew). And after lunch (don’t forget dessert), you can take a nap on one of their sun loungers. Website

Cala Gracioneta's menu offers delicious fish and seafood dishes © Alba Haut/Cala Gracioneta

Port Balansat
This is one of the most popular restaurants among the Ibizan locals thanks to the quality of their rice dishes and fish. The grilled seafood, the bullit de peix (traditional fish stew with a rice dish) and the seafood and fish paella are its specialities. It’s on one of the sides of Port de Sant Miquel in the north of Ibiza. Website
the fish shack

You’ll love this beach bar if all you want is to enjoy the view of the city of Ibiza, eat a simple dish of sardines and don’t mind that there’s no menu. They only serve the day’s scarlet shrimps, fish and squid on the grill with Ibizan salad. It’s in Cap Martinet, past Sa Punta restaurant and they only take cash, no credit cards.

chiringuito Cuatro Latas The fish shack Fresh fish and Ibizan salad, in The Fish Shack. © NC/La Torre Ibiza

Cover Picture: Grilled octopus served in Cala Gracioneta (c) Alba Haut/Cala Gracioneta

Planning a getaway this winter?

Hostal La Torre Ibiza is open all year round. Check our rates for the off-peak season and take a break from your routine.

Tags: cala gracioneta, gastronomía, dónde comer,

WIFI
Restaurante
Belleza

Location & Contact

La Torre Ibiza
Cap negret nº 25
07820
San Antonio - Ibiza
LAT: 38.997
LNG: 1.286

(+34) 971342271

info@latorreibiza.com

General Policy

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1740801422,
                "last": 1740801422,
                "now": 1740801422
            },
            "token": "75A2meb87kBD56BwGzqvwK2sEtvt6ExB"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "en-GB"
        }
    }
}

Profile Information

Time

Memory

Time: 12.21 ms / 12.21 ms Memory: 1.788 MB / 2.16 MB Application: afterLoad

Time: 102.03 ms / 114.24 ms Memory: 9.414 MB / 11.57 MB Application: afterInitialise

Time: 17.41 ms / 131.65 ms Memory: 1.677 MB / 13.25 MB Application: afterRoute

Time: 10.50 ms / 142.14 ms Memory: 0.264 MB / 13.51 MB Application: beforeRenderComponent com_content

Time: 1.97 ms / 144.11 ms Memory: 0.185 MB / 13.70 MB Application: Before Access::preloadComponents (all components)

Time: 0.26 ms / 144.37 ms Memory: 0.057 MB / 13.75 MB Application: After Access::preloadComponents (all components)

Time: 0.02 ms / 144.40 ms Memory: 0.000 MB / 13.75 MB Application: Before Access::preloadPermissions (com_content)

Time: 0.66 ms / 145.06 ms Memory: 0.320 MB / 14.07 MB Application: After Access::preloadPermissions (com_content)

Time: 0.03 ms / 145.08 ms Memory: 0.000 MB / 14.05 MB Application: Before Access::getAssetRules (id:311 name:com_content.article.178)

Time: 0.36 ms / 145.44 ms Memory: 0.027 MB / 14.08 MB Application: After Access::getAssetRules (id:311 name:com_content.article.178)

Time: 31.44 ms / 176.88 ms Memory: 2.147 MB / 16.22 MB Application: afterRenderComponent com_content

Time: 1.60 ms / 178.48 ms Memory: 0.028 MB / 16.25 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Time: 0.05 ms / 178.53 ms Memory: 0.007 MB / 16.26 MB Application: After Access::getAssetRules (id:8 name:com_content)

Time: 9.54 ms / 188.07 ms Memory: 0.290 MB / 16.55 MB Application: afterDispatch

Time: 3.63 ms / 191.69 ms Memory: 0.282 MB / 16.83 MB Application: beforeRenderModule mod_widgetkit (Separador - Temporal)

Time: 5.23 ms / 196.93 ms Memory: 0.273 MB / 17.10 MB Application: afterRenderModule mod_widgetkit (Separador - Temporal)

Time: 0.08 ms / 197.01 ms Memory: 0.001 MB / 17.11 MB Application: beforeRenderModule mod_custom (Location & Contact)

Time: 0.51 ms / 197.52 ms Memory: 0.007 MB / 17.11 MB Application: afterRenderModule mod_custom (Location & Contact)

Time: 0.03 ms / 197.55 ms Memory: 0.000 MB / 17.11 MB Application: beforeRenderModule mod_pie (Pie)

Time: 1.29 ms / 198.84 ms Memory: 0.083 MB / 17.20 MB Application: beforeRenderModule mod_menu (Policy)

Time: 2.01 ms / 200.85 ms Memory: 0.156 MB / 17.35 MB Application: afterRenderModule mod_menu (Policy)

Time: 0.30 ms / 201.15 ms Memory: 0.015 MB / 17.37 MB Application: beforeRenderModule mod_mailchimpsignup (Newsletter)

Time: 1.23 ms / 202.38 ms Memory: 0.049 MB / 17.42 MB Application: afterRenderModule mod_mailchimpsignup (Newsletter)

Time: 0.30 ms / 202.68 ms Memory: 0.013 MB / 17.43 MB Application: beforeRenderModule mod_custom (Pie 4)

Time: 0.18 ms / 202.86 ms Memory: 0.003 MB / 17.43 MB Application: afterRenderModule mod_custom (Pie 4)

Time: 0.05 ms / 202.91 ms Memory: 0.000 MB / 17.39 MB Application: afterRenderModule mod_pie (Pie)

Time: 1.73 ms / 204.63 ms Memory: 0.091 MB / 17.49 MB Application: beforeRenderModule mod_custom (Reservas Toolbar R)

Time: 0.28 ms / 204.92 ms Memory: 0.061 MB / 17.55 MB Application: beforeRenderModule mod_falang (Idiomas)

Time: 5.32 ms / 210.23 ms Memory: 0.178 MB / 17.72 MB Application: afterRenderModule mod_falang (Idiomas)

Time: 1.39 ms / 211.62 ms Memory: 0.000 MB / 17.70 MB Application: afterRenderModule mod_custom (Reservas Toolbar R)

Time: 0.38 ms / 212.00 ms Memory: 0.000 MB / 17.70 MB Application: beforeRenderModule mod_custom (Logo)

Time: 0.16 ms / 212.17 ms Memory: 0.003 MB / 17.70 MB Application: afterRenderModule mod_custom (Logo)

Time: 0.29 ms / 212.46 ms Memory: 0.003 MB / 17.70 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 1.74 ms / 214.20 ms Memory: 0.083 MB / 17.79 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 3.31 ms / 217.51 ms Memory: 0.215 MB / 18.00 MB Application: beforeRenderModule mod_custom (Logo small)

Time: 0.20 ms / 217.71 ms Memory: 0.003 MB / 18.00 MB Application: afterRenderModule mod_custom (Logo small)

Time: 1.32 ms / 219.03 ms Memory: 0.000 MB / 18.00 MB Application: beforeRenderModule mod_neobookings (Neobookings Tracker)

Time: 0.20 ms / 219.23 ms Memory: 0.011 MB / 18.01 MB Application: afterRenderModule mod_neobookings (Neobookings Tracker)

Time: 0.38 ms / 219.61 ms Memory: 0.002 MB / 18.02 MB Application: beforeRenderModule mod_menu (Menu offcanvas)

Time: 0.88 ms / 220.49 ms Memory: 0.006 MB / 18.02 MB Application: afterRenderModule mod_menu (Menu offcanvas)

Time: 0.03 ms / 220.52 ms Memory: 0.000 MB / 18.02 MB Application: beforeRenderModule mod_falang (Idiomas mobile)

Time: 2.73 ms / 223.25 ms Memory: 0.009 MB / 18.03 MB Application: afterRenderModule mod_falang (Idiomas mobile)

Time: 6.75 ms / 230.00 ms Memory: 0.340 MB / 18.37 MB Application: afterRender

Database queries total: 9.76 ms

Memory Usage

Database Queries

16 Queries Logged 9.76 ms

Query Time: 0.30 ms Query memory: 0.023 MB Memory before query: 3.882 MB Rows returned: 0

SELECT `data`

  FROM `hkurw_session`

  WHERE `session_id` = '90669141b0a271f7da48acd191a2d5bb'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hkurw_session	const	PRIMARY	PRIMARY	194	const	1

Profile

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.19 ms After last query: 0.85 ms Query memory: 0.020 MB Memory before query: 4.040 MB Rows returned: 0

SELECT `session_id`

  FROM `hkurw_session`

  WHERE `session_id` = '90669141b0a271f7da48acd191a2d5bb' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hkurw_session	const	PRIMARY	PRIMARY	194	const	1	Using index

Profile

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 3.79 ms After last query: 0.06 ms Query memory: 0.004 MB Memory before query: 4.045 MB

INSERT INTO `hkurw_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('90669141b0a271f7da48acd191a2d5bb', 1, 1740801422, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `hkurw_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('90669141b0a271f7da48acd191a2d5bb', 1, 1740801422, 0, '', 0)

Profile

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init for update	0.01 ms
Update	0.07 ms
Waiting for query cache lock	0.01 ms
Update	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	3.55 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.54 ms After last query: 1.86 ms Query memory: 0.025 MB Memory before query: 4.259 MB Rows returned: 48

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `hkurw_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hkurw_extensions	ref	extension	extension	62	const	49	Using index condition; Using where

Profile

Status	Duration
Starting	0.02 ms
Checking permissions	0.00 ms
Opening tables	0.17 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.16 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.22 ms After last query: 1.57 ms Query memory: 0.021 MB Memory before query: 4.458 MB Rows returned: 5

SELECT id, rules

  FROM `hkurw_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hkurw_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5

Profile

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.68 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 4.469 MB Rows returned: 2

SELECT b.id

  FROM hkurw_usergroups AS a

  LEFT JOIN hkurw_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	10	Using where; Using index

Profile

Status	Duration
Starting	0.14 ms
Checking permissions	0.01 ms
Opening tables	0.21 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.85 ms After last query: 0.48 ms Query memory: 0.070 MB Memory before query: 4.538 MB Rows returned: 116

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM hkurw_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hkurw_extensions	ref	extension	extension	62	const	147	Using index condition; Using where; Using filesort

Profile

Status	Duration
Starting	0.04 ms
Checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.57 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.31 ms After last query: 8.24 ms Query memory: 0.021 MB Memory before query: 5.775 MB Rows returned: 1

SELECT `value`

  FROM `hkurw_admintools_storage`

  WHERE `key` = 'cparams'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hkurw_admintools_storage	const	PRIMARY	PRIMARY	767	const	1

Profile

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
11	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/models/storage.php:99
10	AdmintoolsModelStorage->load()	JROOT/administrator/components/com_admintools/models/storage.php:49
9	AdmintoolsModelStorage->getValue()	JROOT/plugins/system/admintools/admintools/main.php:284
8	plgSystemAdmintools->workaroundIP()	JROOT/plugins/system/admintools/admintools/main.php:87
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.36 ms After last query: 1.20 ms Query memory: 0.022 MB Memory before query: 5.896 MB Rows returned: 2

SELECT *

  FROM hkurw_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hkurw_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where; Using filesort

Profile

Status	Duration
Starting	0.02 ms
Checking permissions	0.00 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.00 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.08 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
10	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/admintools/admintools/main.php:492
9	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:442
8	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:96
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.21 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 5.905 MB Rows returned: 0

SELECT *

  FROM `hkurw_admintools_wafexceptions`

  WHERE NOT(`option` LIKE 'com_%')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.03 ms
Checking permissions	0.00 ms
Opening tables	0.04 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
10	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:521
9	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:442
8	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:96
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.27 ms After last query: 4.62 ms Query memory: 0.059 MB Memory before query: 6.814 MB Rows returned: 1

SELECT params 
  FROM hkurw_extensions 
  WHERE element = 'cookiespolicynotificationbar' 
  AND folder = 'system'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hkurw_extensions	ref	element_clientid,element_folder_clientid	element_folder_clientid	604	const,const	1	Using index condition

Profile

Status	Duration
Starting	0.02 ms
Checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
8	JDatabaseDriver->loadObject()	JROOT/plugins/system/cookiespolicynotificationbar/cookiespolicynotificationbar.php:213
7	plgSystemCookiesPolicyNotificationBar->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.19 ms After last query: 0.17 ms Query memory: 0.020 MB Memory before query: 6.901 MB Rows returned: 1

SELECT `enabled`

  FROM `hkurw_extensions`

  WHERE `type` = 'plugin' 
  AND `element` = 'cache' 
  AND `folder` = 'system'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hkurw_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.02 ms
Checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cookiespolicynotificationbar/cookiespolicynotificationbar.php:2571
8	plgSystemCookiesPolicyNotificationBar->isPageCachePluginEnabled()	JROOT/plugins/system/cookiespolicynotificationbar/cookiespolicynotificationbar.php:228
7	plgSystemCookiesPolicyNotificationBar->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.21 ms After last query: 1.92 ms Query memory: 0.021 MB Memory before query: 7.107 MB Rows returned: 4

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `hkurw_extensions`

  WHERE `type` = 'language' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hkurw_extensions	ref	extension	extension	62	const	4	Using index condition; Using where

Profile

Status	Duration
Starting	0.02 ms
Checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.50 ms After last query: 7.16 ms Query memory: 0.022 MB Memory before query: 7.677 MB Rows returned: 1

SHOW VARIABLES LIKE "collation_database"

Explain

EXPLAIN not possible on query: SHOW VARIABLES LIKE "collation_database"

Profile

Status	Duration
Starting	0.04 ms
Opening tables	0.04 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.27 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Removing tmp table	0.01 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/database/driver/mysqli.php:342
11	JDatabaseDriverMysqli->getCollation()	JROOT/plugins/system/admintools/feature/utf8mb4.php:28
10	AtsystemFeatureUtf8mb4->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:680
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:124
8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.58 ms After last query: 5.98 ms Query memory: 0.025 MB Memory before query: 8.588 MB Rows returned: 1

SELECT id,template 
  FROM hkurw_template_styles 
  WHERE client_id=0 
  AND home=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hkurw_template_styles	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

Profile

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.27 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/widgetkit.php:23
16	plgSystemWidgetkit->{closure}()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Container.php:240
15	YOOtheme\Framework\Container->offsetGet()	JROOT/administrator/components/com_widgetkit/src/Application.php:49
14	YOOtheme\Widgetkit\Application->YOOtheme\Widgetkit\{closure}()	Same as call in the line below.
13	call_user_func_array()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Event/EventDispatcher.php:113
12	YOOtheme\Framework\Event\EventDispatcher->trigger()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Application.php:149
11	YOOtheme\Framework\Application->boot()	JROOT/administrator/components/com_widgetkit/widgetkit.php:91
10	include JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/administrator/components/com_widgetkit/widgetkit-app.php:6
9	include JROOT/administrator/components/com_widgetkit/widgetkit-app.php	JROOT/plugins/system/widgetkit/widgetkit.php:9
8	plgSystemWidgetkit->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.56 ms After last query: 2.28 ms Query memory: 0.050 MB Memory before query: 8.923 MB Rows returned: 25

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, 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,e.element as component

  FROM hkurw_menu AS m

  LEFT JOIN hkurw_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	91	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	latorrei_2025.m.component_id	1	Using where

Profile

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.24 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

16 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1 × SELECT `data` 
  FROM `hkurw_session`

1 × SELECT `session_id` 
  FROM `hkurw_session`

1 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `hkurw_extensions`

1 × SELECT id, rules 
  FROM `hkurw_viewlevels

1 × SELECT b.id 
  FROM hkurw_usergroups AS a 
  LEFT JOIN hkurw_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM hkurw_extensions

1 × SELECT `value` 
  FROM `hkurw_admintools_storage`

```
1 × SELECT * 
  FROM hkurw_languages
```

1 × SELECT * 
  FROM `hkurw_admintools_wafexceptions`

1 × SELECT params 
  FROM hkurw_extensions

1 × SELECT `enabled` 
  FROM `hkurw_extensions`

1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `hkurw_extensions`

1 × SELECT id,template 
  FROM hkurw_template_styles

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, 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,e.element as component 
  FROM hkurw_menu AS m 
  LEFT JOIN hkurw_extensions AS e 
  ON m.component_id = e.extension_id

OTHER Tables:

1 × INSERT INTO `hkurw_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('90669141b0a271f7da48acd191a2d5bb', 1, 1740801422, 0, '', 0

1 × SHOW VARIABLES LIKE "collation_database

3 mouth-watering tables in Ibiza with a taste of the sea

Cala Gracioneta

Port Balansat

the fish shack

WIFI

Restaurante

Belleza

Location & Contact

General Policy

Newsletter

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

16 Queries Logged 9.76 ms

16 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: