Seaside

Tours, weekends and day trips include properties representing

the excellence of food and wine tourism in Sicily.

grafsoste4 Whether a charming historic hotel or a new wine resort, on the seaside or in the countryside inland, or a Michelin

awarded-chef restaurant and winery, each provides a unique experience.

Their unmatched hospitality offers the demanding traveler a rewarding taste of local food and wine,

rich in Sicilian tradition and innovation.

Short break in less known Sicilian places ... our favourites

We have selected small boutique hotels, masserie, farmhouses, awarder wineries and others less known, Michelin star restaurants and local trattorie, small private museums, beaches, routes and footpaths to suggest you brief escapes from everyday life.

________________________________________________

Sleeping in an art room

Itnerary for two or more

where Castel di Tusa
when spring, summer, autumn
how recommended as self-drive itinerary

________________________________________________

Wine Cellars and Pristine Seaside

Itinerary for two or more
where Menfi
when from april to october
how recommended as self-drive itinerary
Read More

_________________________________________________

The Coast facing Africa

Itinerary for two or more
where Agrigento
when summer
how recommended as self-drive itinerary

Read More
________________________________________________

Eco-luxury in Favignana

Itinerary for two or more
where Favignana
when from May to September

Read More
________________________________________________

Favignana 'Les Pieds dans l'Eau'

Itinerary for two or more
where Favignana
when from May to September

Read More

________________________________________________

Session

Profile Information

Time

Memory

Time: 0.1 ms / 0.1 ms Memory: 0.379 MB / 0.38 MB Application: afterLoad

Time: 84.0 ms / 84.1 ms Memory: 5.063 MB / 5.44 MB Application: afterInitialise

Time: 45.0 ms / 129.1 ms Memory: 0.292 MB / 5.73 MB Application: afterRoute

Time: 27.1 ms / 156.2 ms Memory: 1.140 MB / 6.87 MB Application: beforeRenderModule mod_slideshowck (Slide_weekend_enogastronomico)

Time: 8.9 ms / 165.1 ms Memory: 0.156 MB / 7.03 MB Application: afterRenderModule mod_slideshowck (Slide_weekend_enogastronomico)

Time: 38.4 ms / 203.5 ms Memory: 0.510 MB / 7.54 MB Application: afterDispatch

Time: 11.3 ms / 214.8 ms Memory: 0.079 MB / 7.62 MB Application: beforeRenderModule mod_custom (Footer4 english)

Time: 2.1 ms / 216.9 ms Memory: 0.014 MB / 7.63 MB Application: afterRenderModule mod_custom (Footer4 english)

Time: 0.1 ms / 217.1 ms Memory: 0.000 MB / 7.63 MB Application: beforeRenderModule mod_custom (Footer3_eng)

Time: 0.4 ms / 217.4 ms Memory: 0.007 MB / 7.64 MB Application: afterRenderModule mod_custom (Footer3_eng)

Time: 0.1 ms / 217.5 ms Memory: 0.000 MB / 7.64 MB Application: beforeRenderModule mod_custom (Footer2_eng)

Time: 0.4 ms / 217.9 ms Memory: 0.055 MB / 7.69 MB Application: beforeRenderModule mod_rokajaxsearch (RokAjaxSearch)

Time: 1.6 ms / 219.4 ms Memory: 0.021 MB / 7.71 MB Application: afterRenderModule mod_rokajaxsearch (RokAjaxSearch)

Time: 0.3 ms / 219.7 ms Memory: 0.000 MB / 7.66 MB Application: afterRenderModule mod_custom (Footer2_eng)

Time: 0.2 ms / 219.9 ms Memory: 0.006 MB / 7.67 MB Application: beforeRenderModule mod_menu (Short breaks)

Time: 17.3 ms / 237.2 ms Memory: 0.133 MB / 7.80 MB Application: afterRenderModule mod_menu (Short breaks)

Time: 0.1 ms / 237.3 ms Memory: 0.000 MB / 7.79 MB Application: beforeRenderModule mod_custom (Descrizione Soste eng)

Time: 0.4 ms / 237.7 ms Memory: 0.007 MB / 7.80 MB Application: afterRenderModule mod_custom (Descrizione Soste eng)

Time: 0.1 ms / 237.8 ms Memory: 0.000 MB / 7.80 MB Application: beforeRenderModule mod_menu (horizontal-menu)

Time: 18.7 ms / 256.6 ms Memory: 0.160 MB / 7.96 MB Application: afterRenderModule mod_menu (horizontal-menu)

Time: 0.2 ms / 256.8 ms Memory: 0.000 MB / 7.95 MB Application: beforeRenderModule mod_languages (barra_lingua)

Time: 6.3 ms / 263.1 ms Memory: 0.172 MB / 8.12 MB Application: afterRenderModule mod_languages (barra_lingua)

Time: 29.6 ms / 292.6 ms Memory: 0.666 MB / 8.79 MB Application: afterRender

Database queries total: 54.0 ms

Memory Usage

Database Queries

35 Queries Logged 54.0 ms

8 duplicate found!

6 duplicates: #10 #11 #28 #29 #33 #34

2 duplicates: #26 #32

Query Time: 0.89 ms Query memory: 0.015 MB Memory before query: 0.833 MB Rows returned: 0
```
SELECT `data`

  FROM `bqdw4_session`

  WHERE `session_id` = 'qrqiq12hsi579m38b6ua9at2q1'
```
Explain
EXPLAIN not possible on query: SELECT `data` FROM `bqdw4_session` WHERE `session_id` = 'qrqiq12hsi579m38b6ua9at2q1'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/session/storage/database.php:44
JROOT/libraries/joomla/session/session.php:651
JROOT/libraries/joomla/session/session.php:589
JROOT/libraries/cms/application/cms.php:739
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.25 ms After last query: 0.96 ms Query memory: 0.008 MB Memory before query: 0.888 MB
```
DELETE 

  FROM `bqdw4_session`

  WHERE `time` < '1675777209'
```
Explain
EXPLAIN not possible on query: DELETE FROM `bqdw4_session` WHERE `time` < '1675777209'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:756
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.18 ms After last query: 0.12 ms Query memory: 0.012 MB Memory before query: 0.900 MB Rows returned: 0
```
SELECT `session_id`

  FROM `bqdw4_session`

  WHERE `session_id` = 'qrqiq12hsi579m38b6ua9at2q1' 
  LIMIT 0, 1
```
Explain
EXPLAIN not possible on query: SELECT `session_id` FROM `bqdw4_session` WHERE `session_id` = 'qrqiq12hsi579m38b6ua9at2q1' LIMIT 0, 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:176
JROOT/libraries/cms/application/cms.php:765
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.29 ms After last query: 0.11 ms Query memory: 0.009 MB Memory before query: 0.912 MB
```
INSERT INTO `bqdw4_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('qrqiq12hsi579m38b6ua9at2q1', 0, '1675778109')
```
Explain
EXPLAIN not possible on query: INSERT INTO `bqdw4_session` (`session_id`, `client_id`, `time`) VALUES ('qrqiq12hsi579m38b6ua9at2q1', 0, '1675778109')
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:208
JROOT/libraries/cms/application/cms.php:765
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.85 ms After last query: 1.85 ms Query memory: 0.018 MB Memory before query: 0.990 MB Rows returned: 35
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM bqdw4_extensions

  WHERE `type` = 'component'
```
Explain
EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled FROM bqdw4_extensions WHERE `type` = 'component'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/cms/component/helper.php:435
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:120
JROOT/libraries/cms/application/site.php:584
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.37 ms After last query: 0.79 ms Query memory: 0.014 MB Memory before query: 1.050 MB Rows returned: 2
```
SELECT b.id

  FROM bqdw4_usergroups AS a

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

  WHERE a.id = 9
```
Explain
EXPLAIN not possible on query: SELECT b.id FROM bqdw4_usergroups AS a LEFT JOIN bqdw4_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 9
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:332
JROOT/libraries/joomla/access/access.php:401
JROOT/libraries/joomla/user/user.php:453
JROOT/libraries/cms/plugin/helper.php:296
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.86 ms After last query: 0.17 ms Query memory: 0.013 MB Memory before query: 1.070 MB Rows returned: 4
```
SELECT id, rules

  FROM `bqdw4_viewlevels`
```
Explain
EXPLAIN not possible on query: SELECT id, rules FROM `bqdw4_viewlevels`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:418
JROOT/libraries/joomla/user/user.php:453
JROOT/libraries/cms/plugin/helper.php:296
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.89 ms After last query: 0.20 ms Query memory: 0.015 MB Memory before query: 1.088 MB Rows returned: 69
```
SELECT folder AS type, element AS name, params

  FROM bqdw4_extensions

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

  ORDER BY ordering
```
Explain
EXPLAIN not possible on query: SELECT folder AS type, element AS name, params FROM bqdw4_extensions WHERE enabled = 1 AND type ='plugin' AND state IN (0,1) AND access IN (1,1,5) ORDER BY ordering
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/plugin/helper.php:310
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 4.45 ms After last query: 8.26 ms Query memory: 0.018 MB Memory before query: 1.407 MB Rows returned: 2
```
SELECT *

  FROM bqdw4_languages

  WHERE published=1

  ORDER BY ordering ASC
```
Explain
EXPLAIN not possible on query: SELECT * FROM bqdw4_languages WHERE published=1 ORDER BY ordering ASC
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/language/helper.php:164
JROOT/plugins/system/languagefilter/languagefilter.php:62
JROOT/plugins/system/languagedomains/languagedomains.php:56
JROOT/libraries/cms/plugin/helper.php:255
JROOT/libraries/cms/plugin/helper.php:170
JROOT/libraries/cms/application/cms.php:653
JROOT/libraries/cms/application/site.php:663
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[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.24 ms Query memory: 0.015 MB Memory before query: 1.432 MB Rows returned: 3
Duplicate queries: #11 #28 #29 #33 #34
```
SELECT a.element AS element

  FROM bqdw4_extensions AS a

  WHERE a.type = 'language' 
  AND a.client_id = 0 
  AND a.enabled = 1
```
Explain
EXPLAIN not possible on query: SELECT a.element AS element FROM bqdw4_extensions AS a WHERE a.type = 'language' AND a.client_id = 0 AND a.enabled = 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_languages/helpers/multilangstatus.php:94
JROOT/plugins/system/languagefilter/languagefilter.php:73
JROOT/plugins/system/languagedomains/languagedomains.php:56
JROOT/libraries/cms/plugin/helper.php:255
JROOT/libraries/cms/plugin/helper.php:170
JROOT/libraries/cms/application/cms.php:653
JROOT/libraries/cms/application/site.php:663
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.73 ms After last query: 0.13 ms Query memory: 0.015 MB Memory before query: 1.446 MB Rows returned: 3
Duplicate queries: #10 #28 #29 #33 #34
```
SELECT a.element AS element

  FROM bqdw4_extensions AS a

  WHERE a.type = 'language' 
  AND a.client_id = 0 
  AND a.enabled = 1
```
Explain
EXPLAIN not possible on query: SELECT a.element AS element FROM bqdw4_extensions AS a WHERE a.type = 'language' AND a.client_id = 0 AND a.enabled = 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_languages/helpers/multilangstatus.php:94
JROOT/plugins/system/languagefilter/languagefilter.php:73
JROOT/plugins/system/languagedomains/languagedomains.php:56
JROOT/libraries/cms/plugin/helper.php:255
JROOT/libraries/cms/plugin/helper.php:170
JROOT/libraries/cms/application/cms.php:653
JROOT/libraries/cms/application/site.php:663
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 2.07 ms After last query: 17.36 ms Query memory: 0.077 MB Memory before query: 1.898 MB Rows returned: 306
```
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 bqdw4_menu AS m

  LEFT JOIN bqdw4_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
EXPLAIN not possible on query: 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 bqdw4_menu AS m LEFT JOIN bqdw4_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
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/menu/site.php:45
JROOT/libraries/cms/menu/menu.php:64
JROOT/libraries/cms/menu/menu.php:118
JROOT/libraries/cms/application/cms.php:424
JROOT/libraries/cms/application/site.php:272
JROOT/libraries/cms/router/site.php:57
JROOT/libraries/cms/router/router.php:196
JROOT/libraries/cms/application/cms.php:520
JROOT/libraries/cms/application/site.php:407
JROOT/plugins/system/languagefilter/languagefilter.php:100
JROOT/plugins/system/languagedomains/languagedomains.php:190
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:654
JROOT/libraries/cms/application/site.php:663
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.07 ms After last query: 29.67 ms Query memory: 0.024 MB Memory before query: 5.497 MB Rows returned: 1
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM bqdw4_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled FROM bqdw4_extensions WHERE `type` = 'library' AND `element` = 'joomla'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/cms/library/helper.php:156
JROOT/libraries/cms/library/helper.php:47
JROOT/libraries/cms/library/helper.php:90
JROOT/libraries/cms/version/version.php:189
JROOT/libraries/joomla/factory.php:736
JROOT/libraries/joomla/factory.php:216
JROOT/plugins/system/remoteimage/remoteimage.php:66
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.83 ms After last query: 0.32 ms Query memory: 0.018 MB Memory before query: 5.504 MB
```
UPDATE `bqdw4_extensions`

  SET `params` = '{\"mediaversion\":\"c904cfd60b0bb8473280ef52ff9efd3a\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
EXPLAIN not possible on query: UPDATE `bqdw4_extensions` SET `params` = '{\"mediaversion\":\"c904cfd60b0bb8473280ef52ff9efd3a\"}' WHERE `type` = 'library' AND `element` = 'joomla'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/library/helper.php:119
JROOT/libraries/cms/version/version.php:240
JROOT/libraries/cms/version/version.php:199
JROOT/libraries/joomla/factory.php:736
JROOT/libraries/joomla/factory.php:216
JROOT/plugins/system/remoteimage/remoteimage.php:66
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 8.20 ms After last query: 16.90 ms Query memory: 0.018 MB Memory before query: 5.471 MB Rows returned: 4
```
SELECT id, home, template, s.params

  FROM bqdw4_template_styles as s

  LEFT JOIN bqdw4_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1
```
Explain
EXPLAIN not possible on query: SELECT id, home, template, s.params FROM bqdw4_template_styles as s LEFT JOIN bqdw4_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id WHERE s.client_id = 0 AND e.enabled = 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/site.php:484
JROOT/plugins/system/languagedomains/languagedomains.php:926
JROOT/plugins/system/languagedomains/languagedomains.php:230
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.86 ms After last query: 21.65 ms Query memory: 0.024 MB Memory before query: 5.964 MB Rows returned: 1
```
SELECT a.rules

  FROM bqdw4_assets AS a

  WHERE (a.id = 1)

  GROUP BY a.id, a.rules, a.lft
```
Explain
EXPLAIN not possible on query: SELECT a.rules FROM bqdw4_assets AS a WHERE (a.id = 1) GROUP BY a.id, a.rules, a.lft
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/user/user.php:384
JROOT/components/com_content/models/article.php:55
JROOT/libraries/legacy/model/legacy.php:439
JROOT/components/com_content/models/article.php:75
JROOT/libraries/legacy/view/legacy.php:401
JROOT/components/com_content/views/article/view.html.php:42
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.81 ms After last query: 0.51 ms Query memory: 0.025 MB Memory before query: 5.998 MB Rows returned: 2
```
SELECT b.rules

  FROM bqdw4_assets AS a

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

  WHERE (a.name = 'com_content')

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft
```
Explain
EXPLAIN not possible on query: SELECT b.rules FROM bqdw4_assets AS a LEFT JOIN bqdw4_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/access/access.php:107
JROOT/libraries/joomla/user/user.php:393
JROOT/components/com_content/models/article.php:55
JROOT/libraries/legacy/model/legacy.php:439
JROOT/components/com_content/models/article.php:75
JROOT/libraries/legacy/view/legacy.php:401
JROOT/components/com_content/views/article/view.html.php:42
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.89 ms After last query: 0.38 ms Query memory: 0.035 MB Memory before query: 6.035 MB Rows returned: 1
```
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as 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, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM bqdw4_content AS a

  LEFT JOIN bqdw4_categories AS c 
  on c.id = a.catid

  LEFT JOIN bqdw4_users AS u 
  on u.id = a.created_by

  LEFT JOIN bqdw4_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN bqdw4_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM bqdw4_categories AS cat JOIN bqdw4_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published <= 0 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE a.language in ('en-GB','*') 
  AND a.id = 124 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-02-07 13:55:09') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-02-07 13:55:09') 
  AND (a.state = 1 OR a.state =2)
```
Explain
EXPLAIN not possible on query: SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as 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, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count FROM bqdw4_content AS a LEFT JOIN bqdw4_categories AS c on c.id = a.catid LEFT JOIN bqdw4_users AS u on u.id = a.created_by LEFT JOIN bqdw4_categories as parent ON parent.id = c.parent_id LEFT JOIN bqdw4_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM bqdw4_categories AS cat JOIN bqdw4_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE a.language in ('en-GB','*') AND a.id = 124 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-02-07 13:55:09') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-02-07 13:55:09') AND (a.state = 1 OR a.state =2)
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_content/models/article.php:159
JROOT/libraries/legacy/view/legacy.php:401
JROOT/components/com_content/views/article/view.html.php:42
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.49 ms After last query: 1.07 ms Query memory: 0.028 MB Memory before query: 6.147 MB Rows returned: 10
```
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 bqdw4_categories as c

  LEFT JOIN bqdw4_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM bqdw4_categories AS cat JOIN bqdw4_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=31 
  AND badcats.id is null

  GROUP BY 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

  ORDER BY c.lft
```
Explain
EXPLAIN not possible on query: 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 bqdw4_categories as c LEFT JOIN bqdw4_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM bqdw4_categories AS cat JOIN bqdw4_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND s.id=31 AND badcats.id is null GROUP BY 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 ORDER BY c.lft
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/legacy/categories/categories.php:292
JROOT/libraries/legacy/categories/categories.php:184
JROOT/components/com_content/helpers/route.php:44
JROOT/components/com_content/views/article/view.html.php:71
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.85 ms After last query: 2.30 ms Query memory: 0.024 MB Memory before query: 6.307 MB Rows returned: 0
```
SELECT `m`.`tag_id`,`t`.*

  FROM `bqdw4_contentitem_tag_map` AS m 

  INNER JOIN `bqdw4_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 124 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)
```
Explain
EXPLAIN not possible on query: SELECT `m`.`tag_id`,`t`.* FROM `bqdw4_contentitem_tag_map` AS m INNER JOIN `bqdw4_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 124 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/helper/tags.php:426
JROOT/components/com_content/views/article/view.html.php:155
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 2.83 ms After last query: 8.41 ms Query memory: 0.028 MB Memory before query: 6.766 MB Rows returned: 11
```
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM bqdw4_modules AS m

  LEFT JOIN bqdw4_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN bqdw4_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.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-02-07 13:55:09') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-02-07 13:55:09') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 272 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering
```
Explain
EXPLAIN not possible on query: SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM bqdw4_modules AS m LEFT JOIN bqdw4_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN bqdw4_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.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-02-07 13:55:09') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-02-07 13:55:09') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 272 OR mm.menuid <= 0) AND m.language IN ('en-GB','*') ORDER BY m.position, m.ordering
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/module/helper.php:407
JROOT/libraries/cms/module/helper.php:350
JROOT/libraries/cms/module/helper.php:84
JROOT/plugins/content/loadmodule/loadmodule.php:137
JROOT/plugins/content/loadmodule/loadmodule.php:78
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/components/com_content/views/article/view.html.php:160
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.26 ms After last query: 14.02 ms Query memory: 0.028 MB Memory before query: 7.010 MB Rows returned: 30
```
SHOW FULL COLUMNS 
  FROM `bqdw4_content`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `bqdw4_content`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:241
JROOT/libraries/joomla/table/table.php:162
JROOT/libraries/legacy/table/content.php:31
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_content/models/article.php:264
JROOT/components/com_content/views/article/view.html.php:176
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.18 ms After last query: 1.26 ms Query memory: 0.026 MB Memory before query: 7.138 MB Rows returned: 1
```
SELECT *

  FROM bqdw4_content

  WHERE `id` = '124'
```
Explain
EXPLAIN not possible on query: SELECT * FROM bqdw4_content WHERE `id` = '124'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:728
JROOT/components/com_content/models/article.php:265
JROOT/components/com_content/views/article/view.html.php:176
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.34 ms After last query: 0.23 ms Query memory: 0.016 MB Memory before query: 7.161 MB
```
UPDATE bqdw4_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '124'
```
Explain
EXPLAIN not possible on query: UPDATE bqdw4_content SET `hits` = (`hits` + 1) WHERE `id` = '124'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:1239
JROOT/components/com_content/models/article.php:266
JROOT/components/com_content/views/article/view.html.php:176
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 4.10 ms After last query: 17.19 ms Query memory: 0.016 MB Memory before query: 7.378 MB Rows returned: 4
```
SELECT language,id

  FROM `bqdw4_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0
```
Explain
EXPLAIN not possible on query: SELECT language,id FROM `bqdw4_menu` WHERE home = 1 AND published = 1 AND client_id = 0
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_languages/helpers/multilangstatus.php:115
JROOT/plugins/system/languagefilter/languagefilter.php:611
JROOT/plugins/system/languagedomains/languagedomains.php:250
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.51 ms After last query: 1.15 ms Query memory: 0.018 MB Memory before query: 7.409 MB Rows returned: 2
Duplicate queries: #32
```
SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`

  FROM `bqdw4_content` AS `c`

  INNER JOIN `bqdw4_associations` AS `a` 
  ON a.id = c.id 
  AND a.context='com_content.item'

  INNER JOIN `bqdw4_associations` AS `a2` 
  ON a.key = a2.key

  INNER JOIN `bqdw4_content` AS `c2` 
  ON a2.id = c2.`id`

  INNER JOIN `bqdw4_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

  WHERE c.id = 124
```
Explain
EXPLAIN not possible on query: SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid` FROM `bqdw4_content` AS `c` INNER JOIN `bqdw4_associations` AS `a` ON a.id = c.id AND a.context='com_content.item' INNER JOIN `bqdw4_associations` AS `a2` ON a.key = a2.key INNER JOIN `bqdw4_content` AS `c2` ON a2.id = c2.`id` INNER JOIN `bqdw4_categories` AS `ca` ON `c2`.`catid` = ca.id AND ca.extension = 'com_content' WHERE c.id = 124
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/languagedomains/rewrite-32/associations.php:83
JROOT/components/com_content/helpers/association.php:46
JROOT/plugins/system/languagefilter/languagefilter.php:642
JROOT/plugins/system/languagedomains/languagedomains.php:250
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.46 ms After last query: 0.31 ms Query memory: 0.028 MB Memory before query: 7.429 MB Rows returned: 10
```
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 bqdw4_categories as c

  LEFT JOIN bqdw4_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM bqdw4_categories AS cat JOIN bqdw4_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=11 
  AND badcats.id is null

  GROUP BY 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

  ORDER BY c.lft
```
Explain
EXPLAIN not possible on query: 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 bqdw4_categories as c LEFT JOIN bqdw4_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM bqdw4_categories AS cat JOIN bqdw4_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND s.id=11 AND badcats.id is null GROUP BY 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 ORDER BY c.lft
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/legacy/categories/categories.php:292
JROOT/libraries/legacy/categories/categories.php:184
JROOT/components/com_content/helpers/route.php:44
JROOT/components/com_content/helpers/association.php:52
JROOT/plugins/system/languagefilter/languagefilter.php:642
JROOT/plugins/system/languagedomains/languagedomains.php:250
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.09 ms After last query: 1.71 ms Query memory: 0.016 MB Memory before query: 7.520 MB Rows returned: 3
Duplicate queries: #10 #11 #29 #33 #34
```
SELECT a.element AS element

  FROM bqdw4_extensions AS a

  WHERE a.type = 'language' 
  AND a.client_id = 0 
  AND a.enabled = 1
```
Explain
EXPLAIN not possible on query: SELECT a.element AS element FROM bqdw4_extensions AS a WHERE a.type = 'language' AND a.client_id = 0 AND a.enabled = 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_languages/helpers/multilangstatus.php:94
JROOT/plugins/system/languagefilter/languagefilter.php:651
JROOT/plugins/system/languagedomains/languagedomains.php:250
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.27 ms After last query: 0.45 ms Query memory: 0.016 MB Memory before query: 7.537 MB Rows returned: 3
Duplicate queries: #10 #11 #28 #33 #34
```
SELECT a.element AS element

  FROM bqdw4_extensions AS a

  WHERE a.type = 'language' 
  AND a.client_id = 0 
  AND a.enabled = 1
```
Explain
EXPLAIN not possible on query: SELECT a.element AS element FROM bqdw4_extensions AS a WHERE a.type = 'language' AND a.client_id = 0 AND a.enabled = 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_languages/helpers/multilangstatus.php:94
JROOT/plugins/system/languagefilter/languagefilter.php:651
JROOT/plugins/system/languagedomains/languagedomains.php:250
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 7.35 ms After last query: 4.75 ms Query memory: 0.013 MB Memory before query: 7.606 MB Rows returned: 1
```
SELECT version_id 
  FROM bqdw4_schemas 
  WHERE extension_id = 700;
```
Explain
EXPLAIN not possible on query: SELECT version_id FROM bqdw4_schemas WHERE extension_id = 700;
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/smoothtop/smoothtop.php:88
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1049
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.41 ms After last query: 43.78 ms Query memory: 0.019 MB Memory before query: 7.991 MB Rows returned: 2
```
SELECT m2.language, m2.id

  FROM bqdw4_menu as m

  INNER JOIN bqdw4_associations as a 
  ON a.id=m.id 
  AND a.context='com_menus.item'

  INNER JOIN bqdw4_associations as a2 
  ON a.key=a2.key

  INNER JOIN bqdw4_menu as m2 
  ON a2.id=m2.id

  WHERE m.id=272
```
Explain
EXPLAIN not possible on query: SELECT m2.language, m2.id FROM bqdw4_menu as m INNER JOIN bqdw4_associations as a ON a.id=m.id AND a.context='com_menus.item' INNER JOIN bqdw4_associations as a2 ON a.key=a2.key INNER JOIN bqdw4_menu as m2 ON a2.id=m2.id WHERE m.id=272
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_menus/helpers/menus.php:283
JROOT/modules/mod_languages/helper.php:63
JROOT/modules/mod_languages/mod_languages.php:18
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.42 ms After last query: 0.34 ms Query memory: 0.021 MB Memory before query: 8.012 MB Rows returned: 2
Duplicate queries: #26
```
SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`

  FROM `bqdw4_content` AS `c`

  INNER JOIN `bqdw4_associations` AS `a` 
  ON a.id = c.id 
  AND a.context='com_content.item'

  INNER JOIN `bqdw4_associations` AS `a2` 
  ON a.key = a2.key

  INNER JOIN `bqdw4_content` AS `c2` 
  ON a2.id = c2.`id`

  INNER JOIN `bqdw4_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

  WHERE c.id = 124
```
Explain
EXPLAIN not possible on query: SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid` FROM `bqdw4_content` AS `c` INNER JOIN `bqdw4_associations` AS `a` ON a.id = c.id AND a.context='com_content.item' INNER JOIN `bqdw4_associations` AS `a2` ON a.key = a2.key INNER JOIN `bqdw4_content` AS `c2` ON a2.id = c2.`id` INNER JOIN `bqdw4_categories` AS `ca` ON `c2`.`catid` = ca.id AND ca.extension = 'com_content' WHERE c.id = 124
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/languagedomains/rewrite-32/associations.php:83
JROOT/components/com_content/helpers/association.php:46
JROOT/modules/mod_languages/helper.php:72
JROOT/modules/mod_languages/mod_languages.php:18
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.25 ms After last query: 0.21 ms Query memory: 0.019 MB Memory before query: 8.029 MB Rows returned: 3
Duplicate queries: #10 #11 #28 #29 #34
```
SELECT a.element AS element

  FROM bqdw4_extensions AS a

  WHERE a.type = 'language' 
  AND a.client_id = 0 
  AND a.enabled = 1
```
Explain
EXPLAIN not possible on query: SELECT a.element AS element FROM bqdw4_extensions AS a WHERE a.type = 'language' AND a.client_id = 0 AND a.enabled = 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_languages/helpers/multilangstatus.php:94
JROOT/modules/mod_languages/helper.php:82
JROOT/modules/mod_languages/mod_languages.php:18
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.20 ms After last query: 0.16 ms Query memory: 0.019 MB Memory before query: 8.048 MB Rows returned: 3
Duplicate queries: #10 #11 #28 #29 #33
```
SELECT a.element AS element

  FROM bqdw4_extensions AS a

  WHERE a.type = 'language' 
  AND a.client_id = 0 
  AND a.enabled = 1
```
Explain
EXPLAIN not possible on query: SELECT a.element AS element FROM bqdw4_extensions AS a WHERE a.type = 'language' AND a.client_id = 0 AND a.enabled = 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_languages/helpers/multilangstatus.php:94
JROOT/modules/mod_languages/helper.php:82
JROOT/modules/mod_languages/mod_languages.php:18
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 3.81 ms After last query: 22.89 ms Query memory: 0.021 MB Memory before query: 8.616 MB Rows returned: 136
```
SELECT * 
  FROM bqdw4_acymailing_config
```
Explain
EXPLAIN not possible on query: SELECT * FROM bqdw4_acymailing_config
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
JROOT/administrator/components/com_acymailing/helpers/helper.php:468
JROOT/administrator/components/com_acymailing/helpers/helper.php:1236
JROOT/plugins/system/regacymailing/regacymailing.php:139
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1065
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

6 × SELECT a.element AS element 
  FROM bqdw4_extensions AS a

2 × 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 bqdw4_categories as c 
  LEFT JOIN bqdw4_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt) 
  LEFT JOIN  (SELECT cat.id as id 
  FROM bqdw4_categories AS cat JOIN bqdw4_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

2 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid` 
  FROM `bqdw4_content` AS `c` 
  INNER JOIN `bqdw4_associations` AS `a` 
  ON a.id = c.id 
  AND a.context='com_content.item' 
  INNER JOIN `bqdw4_associations` AS `a2` 
  ON a.key = a2.key 
  INNER JOIN `bqdw4_content` AS `c2` 
  ON a2.id = c2.`id` 
  INNER JOIN `bqdw4_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

2 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM bqdw4_extensions

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM bqdw4_modules AS m 
  LEFT JOIN bqdw4_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN bqdw4_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `bqdw4_contentitem_tag_map` AS m  
  INNER JOIN `bqdw4_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT * 
  FROM bqdw4_acymailing_confi

```
1 × SELECT * 
  FROM bqdw4_content
```

1 × SELECT m2.language, m2.id 
  FROM bqdw4_menu as m 
  INNER JOIN bqdw4_associations as a 
  ON a.id=m.id 
  AND a.context='com_menus.item' 
  INNER JOIN bqdw4_associations as a2 
  ON a.key=a2.key 
  INNER JOIN bqdw4_menu as m2 
  ON a2.id=m2.id

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as 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, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM bqdw4_content AS a 
  LEFT JOIN bqdw4_categories AS c 
  on c.id = a.catid 
  LEFT JOIN bqdw4_users AS u 
  on u.id = a.created_by 
  LEFT JOIN bqdw4_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN bqdw4_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM bqdw4_categories AS cat JOIN bqdw4_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT language,id 
  FROM `bqdw4_menu`

1 × SELECT version_id 
  FROM bqdw4_schemas

1 × SELECT a.rules 
  FROM bqdw4_assets AS a

1 × SELECT id, rules 
  FROM `bqdw4_viewlevels

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

1 × SELECT `session_id` 
  FROM `bqdw4_session`

1 × SELECT folder AS type, element AS name, params 
  FROM bqdw4_extensions

```
1 × SELECT * 
  FROM bqdw4_languages
```

1 × SELECT `data` 
  FROM `bqdw4_session`

1 × SELECT id, home, template, s.params 
  FROM bqdw4_template_styles as s 
  LEFT JOIN bqdw4_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

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 bqdw4_menu AS m 
  LEFT JOIN bqdw4_extensions AS e 
  ON m.component_id = e.extension_id

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

OTHER Tables:

1 × UPDATE bqdw4_content 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `bqdw4_content

1 × UPDATE `bqdw4_extensions` 
  SET `params` = '{\"mediaversion\":\"c904cfd60b0bb8473280ef52ff9efd3a\"}'

1 × INSERT INTO `bqdw4_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('qrqiq12hsi579m38b6ua9at2q1', 0, '1675778109'

```
1 × DELETE  
  FROM `bqdw4_session`
```

Short breaks

Short break in less known Sicilian places ... our favourites

Sleeping in an art room

Wine Cellars and Pristine Seaside

The Coast facing Africa

Eco-luxury in Favignana

Favignana 'Les Pieds dans l'Eau'

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

35 Queries Logged 54.0 ms

8 duplicate found!

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Parsing errors in language files

Language Files Loaded

Untranslated Strings