Family Apartment 4 has two bedrooms, large kitchen with dining room and living room, terrace with table and chairs. There are also two bathrooms. Each bedroom has bed for two persons. One of the bedrooms also has an extra bed for a child and a balcony with the table and chairs for two persons. The balcony has sea view. The living room has an air conditioning, a LCD TV and a sofa. Sofa can be expanded in bed for two children. In front of the apartment, between the pomegranate tree, olive tree and pine trees there is a terrace with table and chairs. Linens, hand and shower towels are provided. Our house is near sea and it takes less then a minute to get on foot from the bed to the sea. Not far from the house, only few minutes of walking, there are several small pebble beaches and one sandy beach.

- AIR CONDITIONING

- SAT TV

- WIFI INTERNET

- CAR PARKING PLACE

View the embedded image gallery online at:
http://croatiapartment.biz/apartment-4#sigProId433cc3047a

Availability calendar

Prices

View the embedded image gallery online at:
http://croatiapartment.biz/apartment-4#sigProId6b69a1fcfe

Go Top

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1747018440,
                "last": 1747018440,
                "now": 1747018440
            }
        },
        "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
        }
    }
}

Profile Information

Time

Memory

Time: 43.48 ms / 43.48 ms Memory: 0.720 MB / 0.94 MB Application: afterLoad

Time: 108.58 ms / 152.07 ms Memory: 4.170 MB / 5.11 MB Application: Start JAccess::getAssetRules Old (1)

Time: 1.36 ms / 153.43 ms Memory: 0.054 MB / 5.17 MB Application: Finish JAccess::getAssetRules Old (1)

Time: 0.03 ms / 153.46 ms Memory: 0.000 MB / 5.16 MB Application: Start JAccess::preload(components)

Time: 2.36 ms / 155.82 ms Memory: 0.295 MB / 5.46 MB Application: Finish JAccess::preload(components)

Time: 77.18 ms / 233.00 ms Memory: 5.225 MB / 10.68 MB Application: afterInitialise

Time: 31.93 ms / 264.93 ms Memory: 1.262 MB / 11.95 MB Application: Start JAccess::getAssetRules Old (1)

Time: 0.38 ms / 265.31 ms Memory: 0.027 MB / 11.97 MB Application: Finish JAccess::getAssetRules Old (1)

Time: 15.65 ms / 280.95 ms Memory: 0.797 MB / 12.77 MB Application: afterRoute

Time: 0.62 ms / 281.57 ms Memory: 0.038 MB / 12.81 MB Application: beforeRenderComponent com_content

Time: 67.21 ms / 348.78 ms Memory: 3.041 MB / 15.85 MB Application: beforeRenderModule mod_dpcalendar_mini (Apartman 4 kalendar)

Time: 12.74 ms / 361.52 ms Memory: 0.168 MB / 16.02 MB Application: New JAccess Preloading Process(com_dpcalendar.category)

Time: 0.35 ms / 361.87 ms Memory: 0.036 MB / 16.05 MB Application: After preloadPermissionsParentIdMapping (com_dpcalendar.category)

Time: 1.14 ms / 363.01 ms Memory: 0.070 MB / 16.12 MB Application: After preloadPermissions (com_dpcalendar.category)

Time: 0.02 ms / 363.02 ms Memory: 0.002 MB / 16.12 MB Application: End New JAccess Preloading Process(com_dpcalendar.category)

Time: 0.03 ms / 363.05 ms Memory: 0.002 MB / 16.12 MB Application: Start JAccess::getAssetRules New (com_dpcalendar.category.91)

Time: 0.18 ms / 363.23 ms Memory: 0.010 MB / 16.13 MB Application: Finish JAccess::getAssetRules New (com_dpcalendar.category.91)

Time: 9.64 ms / 372.87 ms Memory: 0.453 MB / 16.59 MB Application: Start JAccess::getAssetRules New (com_dpcalendar.category.39)

Time: 0.09 ms / 372.96 ms Memory: 0.010 MB / 16.60 MB Application: Finish JAccess::getAssetRules New (com_dpcalendar.category.39)

Time: 0.02 ms / 372.98 ms Memory: 0.001 MB / 16.60 MB Application: Start JAccess::getAssetRules New (com_dpcalendar.category.87)

Time: 0.01 ms / 373.00 ms Memory: 0.003 MB / 16.60 MB Application: Finish JAccess::getAssetRules New (com_dpcalendar.category.87)

Time: 0.02 ms / 373.01 ms Memory: 0.001 MB / 16.60 MB Application: Start JAccess::getAssetRules New (com_dpcalendar.category.88)

Time: 0.01 ms / 373.02 ms Memory: 0.003 MB / 16.60 MB Application: Finish JAccess::getAssetRules New (com_dpcalendar.category.88)

Time: 0.01 ms / 373.04 ms Memory: 0.001 MB / 16.60 MB Application: Start JAccess::getAssetRules New (com_dpcalendar.category.89)

Time: 0.01 ms / 373.05 ms Memory: 0.003 MB / 16.61 MB Application: Finish JAccess::getAssetRules New (com_dpcalendar.category.89)

Time: 0.01 ms / 373.06 ms Memory: 0.001 MB / 16.61 MB Application: Start JAccess::getAssetRules New (com_dpcalendar.category.90)

Time: 0.01 ms / 373.07 ms Memory: 0.003 MB / 16.61 MB Application: Finish JAccess::getAssetRules New (com_dpcalendar.category.90)

Time: 2.53 ms / 375.61 ms Memory: 0.043 MB / 16.65 MB Application: afterRenderModule mod_dpcalendar_mini (Apartman 4 kalendar)

Time: 3.94 ms / 379.54 ms Memory: 0.057 MB / 16.71 MB Application: afterRenderComponent com_content

Time: 2.65 ms / 382.19 ms Memory: 0.013 MB / 16.72 MB Application: afterDispatch

Time: 5.69 ms / 387.88 ms Memory: 0.125 MB / 16.85 MB Application: beforeRenderModule mod_menu (Copyright Menu ENG)

Time: 5.27 ms / 393.15 ms Memory: 0.122 MB / 16.97 MB Application: afterRenderModule mod_menu (Copyright Menu ENG)

Time: 0.07 ms / 393.23 ms Memory: 0.000 MB / 16.96 MB Application: beforeRenderModule mod_custom (footer)

Time: 1.48 ms / 394.71 ms Memory: 0.013 MB / 16.97 MB Application: afterRenderModule mod_custom (footer)

Time: 0.06 ms / 394.77 ms Memory: 0.000 MB / 16.97 MB Application: beforeRenderModule mod_custom (Mapa)

Time: 0.23 ms / 395.00 ms Memory: 0.007 MB / 16.98 MB Application: afterRenderModule mod_custom (Mapa)

Time: 0.06 ms / 395.05 ms Memory: 0.000 MB / 16.98 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 1.49 ms / 396.55 ms Memory: 0.033 MB / 17.01 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.06 ms / 396.61 ms Memory: 0.000 MB / 17.00 MB Application: beforeRenderModule mod_icemegamenu (Meni - ENG)

Time: 14.67 ms / 411.28 ms Memory: 0.581 MB / 17.58 MB Application: afterRenderModule mod_icemegamenu (Meni - ENG)

Time: 0.12 ms / 411.40 ms Memory: 0.000 MB / 17.57 MB Application: beforeRenderModule mod_languages (Language Switcher)

Time: 26.25 ms / 437.65 ms Memory: 1.033 MB / 18.61 MB Application: afterRenderModule mod_languages (Language Switcher)

Time: 0.09 ms / 437.75 ms Memory: 0.000 MB / 18.60 MB Application: beforeRenderModule mod_custom (Kontakt)

Time: 0.53 ms / 438.28 ms Memory: 0.007 MB / 18.61 MB Application: afterRenderModule mod_custom (Kontakt)

Time: 0.07 ms / 438.35 ms Memory: 0.000 MB / 18.60 MB Application: beforeRenderModule mod_custom (Logo ENG)

Time: 0.23 ms / 438.58 ms Memory: 0.007 MB / 18.61 MB Application: afterRenderModule mod_custom (Logo ENG)

Time: 0.05 ms / 438.63 ms Memory: 0.000 MB / 18.61 MB Application: beforeRenderModule mod_custom (Gore ljevo)

Time: 0.23 ms / 438.85 ms Memory: 0.007 MB / 18.62 MB Application: afterRenderModule mod_custom (Gore ljevo)

Time: 55.68 ms / 494.53 ms Memory: 1.341 MB / 19.96 MB Application: afterRender

Database queries total: 22.31 ms

Memory Usage

Database Queries

36 Queries Logged 22.31 ms

4 duplicate found!

2 duplicates: #10 #19

2 duplicates: #31 #33

Query Time: 0.44 ms Query memory: 0.017 MB Memory before query: 2.975 MB Rows returned: 0

SELECT `data`

  FROM `r82m0_session`

  WHERE `session_id` = 'pq8fe7a9v4c5rvtbfcdu2q74j6'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r82m0_session	const	PRIMARY	PRIMARY	575	const	1	100.00

Profile

Status	Duration
Starting	0.06 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
Checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.03 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.00 ms
Waiting for query cache lock	0.00 ms
Updating status	0.01 ms
Waiting for query cache lock	0.02 ms
Updating status	0.00 ms
Storing result in query cache	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Same as call in the line below.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 0.35 ms After last query: 5.33 ms Query memory: 0.010 MB Memory before query: 3.183 MB Rows returned: 0

SELECT `session_id`

  FROM `r82m0_session`

  WHERE `session_id` = 'pq8fe7a9v4c5rvtbfcdu2q74j6' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r82m0_session	const	PRIMARY	PRIMARY	575	const	1	100.00	Using index

Profile

Status	Duration
Starting	0.05 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
Checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.00 ms
Waiting for query cache lock	0.00 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.00 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 0.33 ms After last query: 0.12 ms Query memory: 0.009 MB Memory before query: 3.198 MB

INSERT INTO `r82m0_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('pq8fe7a9v4c5rvtbfcdu2q74j6', 0, 1, '1747018440', 0, '')

Explain

EXPLAIN not possible on query: INSERT INTO `r82m0_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('pq8fe7a9v4c5rvtbfcdu2q74j6', 0, 1, '1747018440', 0, '')

Profile

Status	Duration
Starting	0.09 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.01 ms
init for update	0.01 ms
Update	0.04 ms
Waiting for query cache lock	0.00 ms
Update	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
Waiting for query cache lock	0.00 ms
Unlocking tables	0.02 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 0.65 ms After last query: 4.95 ms Query memory: 0.012 MB Memory before query: 3.455 MB Rows returned: 38

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

  FROM `r82m0_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r82m0_extensions	ref	extension	extension	62	const	30	100.00	Using index condition

Profile

Status	Duration
Starting	0.05 ms
Waiting for query cache lock	0.00 ms
starting	0.00 ms
Checking query cache for query	0.04 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.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.19 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.00 ms
Waiting for query cache lock	0.00 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.00 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 4.86 ms Query memory: 0.014 MB Memory before query: 3.663 MB Rows returned: 2

SELECT b.id

  FROM r82m0_usergroups AS a

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

  WHERE a.id = 16

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	100.00	Using where

Profile

Status	Duration
Starting	0.06 ms
Waiting for query cache lock	0.01 ms
starting	0.02 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
Sending cached result to clien	0.08 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:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.11 ms After last query: 0.82 ms Query memory: 0.012 MB Memory before query: 3.739 MB Rows returned: 5

SELECT id, rules

  FROM `r82m0_viewlevels`

Explain

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

Profile

Status	Duration
Starting	0.05 ms
Waiting for query cache lock	0.00 ms
starting	0.02 ms
Checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
Sending cached result to clien	0.06 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:1494
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.15 ms After last query: 0.15 ms Query memory: 0.010 MB Memory before query: 3.757 MB Rows returned: 70

SELECT folder AS type, element AS name, params

  FROM r82m0_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	filtered	Extra
1	SIMPLE	r82m0_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	242	51.65	Using where; Using filesort

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.00 ms
starting	0.02 ms
Checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.67 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.00 ms
Waiting for query cache lock	0.02 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.79 ms After last query: 31.02 ms Query memory: 0.021 MB Memory before query: 5.038 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `r82m0_assets`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `r82m0_assets`

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
closing tables	0.00 ms
checking permissions	0.01 ms
Opening tables	0.20 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
checking permissions	0.05 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.06 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
14	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
13	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
12	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
11	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
10	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
9	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
8	JUser->authorise()	JROOT/plugins/system/admin8/admin8.php:29
7	plgSystemAdmin8->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.18 ms After last query: 1.43 ms Query memory: 0.016 MB Memory before query: 5.103 MB Rows returned: 1

SELECT *

  FROM r82m0_assets

  WHERE `id` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r82m0_assets	const	PRIMARY	PRIMARY	4	const	1	100.00

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.00 ms
starting	0.00 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
Sending cached result to clien	0.05 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
12	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
11	JTable->load()	JROOT/libraries/joomla/access/access.php:697
10	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
9	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
8	JUser->authorise()	JROOT/plugins/system/admin8/admin8.php:29
7	plgSystemAdmin8->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.12 ms After last query: 0.14 ms Query memory: 0.014 MB Memory before query: 5.117 MB Rows returned: 1

Duplicate queries: #19

SELECT a.rules

  FROM r82m0_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,152	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); Using where

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.00 ms
starting	0.00 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
Sending cached result to clien	0.06 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
9	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
8	JUser->authorise()	JROOT/plugins/system/admin8/admin8.php:29
7	plgSystemAdmin8->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.57 ms After last query: 1.26 ms Query memory: 0.016 MB Memory before query: 5.166 MB Rows returned: 37

SELECT element

  FROM r82m0_extensions

  WHERE type = 'component' 
  AND enabled = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r82m0_extensions	ref	extension	extension	62	const	30	100.00	Using index condition; Using where

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.00 ms
starting	0.00 ms
Checking query cache for query	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.18 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.00 ms
Waiting for query cache lock	0.00 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.00 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
12	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
11	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
10	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
9	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
8	JUser->authorise()	JROOT/plugins/system/admin8/admin8.php:29
7	plgSystemAdmin8->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.14 ms Query memory: 0.016 MB Memory before query: 5.191 MB Rows returned: 37

SELECT a.name, a.rules

  FROM r82m0_assets AS a

  WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_chronoforms5','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dpcalendar','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_quicklogout','com_redirect','com_search','com_sigpro','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap') OR a.name = 'root.1')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	range	idx_asset_name	idx_asset_name	152	NULL	38	100.00	Using index condition

Profile

Status	Duration
Starting	0.06 ms
Waiting for query cache lock	0.00 ms
starting	0.00 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
Sending cached result to clien	0.04 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
12	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
11	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
10	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
9	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
8	JUser->authorise()	JROOT/plugins/system/admin8/admin8.php:29
7	plgSystemAdmin8->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.43 ms After last query: 12.34 ms Query memory: 0.020 MB Memory before query: 5.965 MB Rows returned: 1

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

  FROM `r82m0_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r82m0_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using index condition

Profile

Status	Duration
Starting	0.05 ms
Waiting for query cache lock	0.00 ms
starting	0.00 ms
Checking query cache for query	0.03 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.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.11 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
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.00 ms
Waiting for query cache lock	0.00 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.00 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
16	JDatabaseDriver->loadObject()	Same as call in the line below.
15	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
14	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
13	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
12	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
11	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
10	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
9	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
8	JFactory::getDocument()	JROOT/plugins/system/iceshortcodes/iceshortcodes.php:85
7	PlgSystemIceShortCodes->PlgSystemIceShortCodes()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.52 ms After last query: 0.21 ms Query memory: 0.016 MB Memory before query: 5.970 MB

UPDATE `r82m0_extensions`

  SET `params` = '{\"mediaversion\":\"12efe8e863c6a02a0d1d2f8d23181981\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r82m0_extensions	range	element_clientid,element_folder_clientid,extension	extension	364	NULL	1	100.00	Using where

Profile

Status	Duration
Starting	0.06 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.10 ms
Updating	0.04 ms
End of update loop	0.00 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
Waiting for query cache lock	0.00 ms
Unlocking tables	0.15 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
12	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
11	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
10	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
9	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
8	JFactory::getDocument()	JROOT/plugins/system/iceshortcodes/iceshortcodes.php:85
7	PlgSystemIceShortCodes->PlgSystemIceShortCodes()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 3.15 ms After last query: 5.13 ms Query memory: 0.019 MB Memory before query: 6.259 MB Rows returned: 159

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 r82m0_menu AS m

  LEFT JOIN r82m0_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	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	284	75.33	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	croatiap_grg.m.component_id	1	100.00	Using where

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.00 ms
starting	0.00 ms
Checking query cache for query	0.04 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.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.51 ms
Waiting for query cache lock	0.00 ms
Creating sort index	0.12 ms
Waiting for query cache lock	0.00 ms
Creating sort index	0.15 ms
Waiting for query cache lock	0.00 ms
Creating sort index	0.11 ms
Waiting for query cache lock	0.00 ms
Creating sort index	0.14 ms
Waiting for query cache lock	0.00 ms
Creating sort index	0.09 ms
Waiting for query cache lock	0.00 ms
Creating sort index	0.10 ms
Waiting for query cache lock	0.00 ms
Creating sort index	0.10 ms
Waiting for query cache lock	0.00 ms
Creating sort index	0.14 ms
Waiting for query cache lock	0.00 ms
Creating sort index	0.23 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.00 ms
Waiting for query cache lock	0.00 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.00 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/application/site.php:438
8	JApplicationSite->getTemplate()	JROOT/plugins/system/iceshortcodes/iceshortcodes.php:89
7	PlgSystemIceShortCodes->PlgSystemIceShortCodes()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.63 ms After last query: 4.82 ms Query memory: 0.012 MB Memory before query: 8.237 MB Rows returned: 3

SELECT id, home, template, s.params

  FROM r82m0_template_styles as s

  LEFT JOIN r82m0_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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	croatiap_grg.s.template,const	1	2.48	Using index condition; Using where

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.00 ms
starting	0.00 ms
Checking query cache for query	0.04 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.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.05 ms
Executing	0.00 ms
Sending data	0.23 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.00 ms
Waiting for query cache lock	0.00 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.00 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
8	JApplicationSite->getTemplate()	JROOT/plugins/system/iceshortcodes/iceshortcodes.php:89
7	PlgSystemIceShortCodes->PlgSystemIceShortCodes()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 24.46 ms Query memory: 0.013 MB Memory before query: 9.545 MB Rows returned: 13

SELECT *

  FROM r82m0_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
Starting	0.05 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
Sending cached result to clien	0.05 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
8	JLanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:97
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[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.59 ms Query memory: 0.012 MB Memory before query: 9.618 MB Rows returned: 13

SELECT element

  FROM r82m0_extensions

  WHERE type = 'language' 
  AND client_id = 0 
  AND enabled = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r82m0_extensions	ref	extension	extension	62	const	21	100.00	Using index condition; Using where

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.00 ms
starting	0.00 ms
Checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.00 ms
Waiting for query cache lock	0.00 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	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:1689
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:90
8	JLanguageMultilang::getSiteLangs()	JROOT/plugins/system/languagefilter/languagefilter.php:108
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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: 57.73 ms Query memory: 0.018 MB Memory before query: 11.948 MB Rows returned: 1

Duplicate queries: #10

SELECT a.rules

  FROM r82m0_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,152	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); Using where

Profile

Status	Duration
Starting	0.06 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.05 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
14	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
13	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:176
12	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
11	JUser->authorise()	JROOT/plugins/system/sourcerer/helper.php:73
10	PlgSystemSourcererHelper->__construct()	JROOT/plugins/system/sourcerer/sourcerer.php:95
9	PlgSystemSourcerer->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.81 ms After last query: 24.41 ms Query memory: 0.020 MB Memory before query: 13.241 MB Rows returned: 30

SHOW FULL COLUMNS 
  FROM `r82m0_content`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `r82m0_content`

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Opening tables	0.20 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.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
checking permissions	0.09 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.07 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
12	JTable->__construct()	JROOT/libraries/legacy/table/content.php:31
11	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:308
10	JTable::getInstance()	JROOT/components/com_content/models/article.php:264
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.07 ms After last query: 6.32 ms Query memory: 0.015 MB Memory before query: 13.589 MB Rows returned: 1

SELECT *

  FROM r82m0_content

  WHERE `id` = '171'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r82m0_content	const	PRIMARY	PRIMARY	4	const	1	100.00

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.03 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.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.67 ms
Preparing	0.01 ms
Unlocking tables	0.00 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
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.00 ms
Waiting for query cache lock	0.00 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	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:1453
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
10	JTable->load()	JROOT/components/com_content/models/article.php:265
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 0.15 ms Query memory: 0.014 MB Memory before query: 13.609 MB

UPDATE r82m0_content

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

  WHERE `id` = '171'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r82m0_content	range	PRIMARY	PRIMARY	4	NULL	1	100.00	Using where

Profile

Status	Duration
Starting	0.06 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.03 ms
Updating	0.04 ms
End of update loop	0.00 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
Waiting for query cache lock	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1228
10	JTable->hit()	JROOT/components/com_content/models/article.php:266
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.83 ms After last query: 2.81 ms Query memory: 0.017 MB Memory before query: 13.802 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 r82m0_content AS a

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

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

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

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

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM r82m0_categories AS cat JOIN r82m0_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 = 171 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-05-12 02:54:00') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-05-12 02:54:00') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	const	PRIMARY,idx_state,idx_language	PRIMARY	4	const	1	100.00
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1	100.00
1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1	100.00
1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1	100.00
1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	0.00	Unique row not found
1	PRIMARY	<derived2>	ref	key0	key0	5	const	0	0.00
2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00
2	LATERAL DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	152	const	25	28.09	Using index condition; Using where

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.00 ms
starting	0.00 ms
Checking query cache for query	0.10 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.06 ms
Optimizing	0.03 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Statistics	0.07 ms
Preparing	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Executing	0.00 ms
Sending data	0.13 ms
End of update loop	0.01 ms
Query end	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.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.00 ms
Waiting for query cache lock	0.00 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.00 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:159
12	ContentModelArticle->getItem()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.99 ms After last query: 6.50 ms Query memory: 0.018 MB Memory before query: 14.113 MB Rows returned: 5

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 r82m0_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM r82m0_categories AS cat JOIN r82m0_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

  LEFT JOIN r82m0_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

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

  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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	PRIMARY	c	index_merge	cat_idx,idx_access,idx_left_right,idx_language	idx_language,idx_left_right	21,4	NULL	36	53.93	Using sort_union(idx_language,idx_left_right); Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	croatiap_grg.c.id	2	100.00	Using where
2	LATERAL DERIVED	cat	eq_ref	PRIMARY,idx_left_right	PRIMARY	4	croatiap_grg.c.id	1	100.00
2	LATERAL DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	152	const	26	29.21	Using index condition; Using where

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.00 ms
starting	0.00 ms
Checking query cache for query	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.07 ms
Optimizing	0.03 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Statistics	0.13 ms
Preparing	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
Executing	0.00 ms
Sending data	0.45 ms
Executing	0.01 ms
Sending data	0.16 ms
Executing	0.00 ms
Sending data	0.13 ms
Executing	0.00 ms
Sending data	0.15 ms
Executing	0.00 ms
Sending data	0.15 ms
Creating sort index	0.05 ms
Removing tmp table	0.05 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.00 ms
Waiting for query cache lock	0.00 ms
Updating status	0.01 ms
Waiting for query cache lock	0.02 ms
Updating status	0.00 ms
Storing result in query cache	0.00 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
13	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
12	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
11	ContentHelperRoute::getArticleRoute()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 0.94 ms Query memory: 0.016 MB Memory before query: 14.185 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `r82m0_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 171 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

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

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.00 ms
starting	0.00 ms
Checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.00 ms
Executing	0.10 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.00 ms
Waiting for query cache lock	0.00 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.00 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
11	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:156
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 35.11 ms Query memory: 0.019 MB Memory before query: 15.773 MB Rows returned: 1

SELECT published

  FROM r82m0_modules

  WHERE id='670'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r82m0_modules	const	PRIMARY	PRIMARY	4	const	1	100.00

Profile

Status	Duration
Starting	0.08 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.05 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:65
14	plgContentLoadModuleInArticle->onContentPrepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:161
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.20 ms After last query: 1.28 ms Query memory: 0.020 MB Memory before query: 15.817 MB Rows returned: 1

SELECT *

  FROM r82m0_modules

  WHERE id='670'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r82m0_modules	const	PRIMARY	PRIMARY	4	const	1	100.00

Profile

Status	Duration
Starting	0.05 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:101
15	plgContentLoadModuleInArticle->load_module()	JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74
14	plgContentLoadModuleInArticle->onContentPrepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:161
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.83 ms After last query: 9.75 ms Query memory: 0.029 MB Memory before query: 15.971 MB Rows returned: 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 r82m0_categories as c

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

  LEFT JOIN r82m0_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

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

  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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	PRIMARY	c	range	cat_idx,idx_access,idx_left_right,idx_language	cat_idx	157	NULL	9	100.00	Using index condition; Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	croatiap_grg.c.id	2	100.00	Using where
2	LATERAL DERIVED	cat	eq_ref	PRIMARY,idx_left_right	PRIMARY	4	croatiap_grg.c.id	1	100.00
2	LATERAL DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	100.00	Using index condition; Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.08 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.17 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.01 ms
Waiting for query cache lock	0.02 ms
init	0.13 ms
Optimizing	0.04 ms
Optimizing	0.01 ms
Statistics	0.11 ms
Statistics	0.42 ms
Preparing	0.09 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.09 ms
Executing	0.01 ms
Sending data	0.34 ms
Executing	0.01 ms
Sending data	0.07 ms
Creating sort index	0.06 ms
Removing tmp table	0.06 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.07 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
22	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
21	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
20	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:68
19	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php:27
18	include JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php	JROOT/libraries/cms/module/helper.php:199
17	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
16	JDocumentRendererHtmlModule->render()	JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:107
15	plgContentLoadModuleInArticle->load_module()	JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74
14	plgContentLoadModuleInArticle->onContentPrepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:161
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.13 ms After last query: 0.39 ms Query memory: 0.031 MB Memory before query: 16.014 MB Rows returned: 9

SELECT a.id, a.parent_id

  FROM r82m0_assets AS a

  WHERE (a.name LIKE 'com_dpcalendar.%' OR a.name = 'com_dpcalendar' OR a.id = 1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL	PRIMARY,idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	738	100.00	Using where

Profile

Status	Duration
Starting	0.06 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
Sending cached result to clien	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:332
24	JAccess::preloadPermissionsParentIdMapping()	JROOT/libraries/joomla/access/access.php:240
23	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
22	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
21	JUser->authorise()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:56
20	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:68
19	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php:27
18	include JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php	JROOT/libraries/cms/module/helper.php:199
17	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
16	JDocumentRendererHtmlModule->render()	JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:107
15	plgContentLoadModuleInArticle->load_module()	JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74
14	plgContentLoadModuleInArticle->onContentPrepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:161
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.14 ms After last query: 0.97 ms Query memory: 0.031 MB Memory before query: 16.079 MB Rows returned: 9

SELECT a.id, a.name, a.rules

  FROM r82m0_assets AS a

  WHERE (a.name LIKE 'com_dpcalendar.%' OR a.name = 'com_dpcalendar' OR a.id = 1 )

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL	PRIMARY,idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	738	100.00	Using where

Profile

Status	Duration
Starting	0.06 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
Sending cached result to clien	0.05 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1255
25	JDatabaseDriver->getIterator()	JROOT/libraries/joomla/access/access.php:373
24	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:243
23	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
22	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
21	JUser->authorise()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:56
20	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:68
19	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php:27
18	include JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php	JROOT/libraries/cms/module/helper.php:199
17	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
16	JDocumentRendererHtmlModule->render()	JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:107
15	plgContentLoadModuleInArticle->load_module()	JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74
14	plgContentLoadModuleInArticle->onContentPrepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:161
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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: 4.46 ms Query memory: 0.034 MB Memory before query: 16.352 MB Rows returned: 0

Duplicate queries: #33

SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access

  FROM `r82m0_dpcalendar_caldav_calendars` c

  LEFT 
  OUTER JOIN r82m0_dpcalendar_caldav_principals mainp 
  on mainp.uri = c.principaluri

  LEFT 
  OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri 
  from r82m0_dpcalendar_caldav_principals memberp
				
  inner join r82m0_dpcalendar_caldav_groupmembers m 
  on memberp.id = m.member_id
				
  inner join r82m0_dpcalendar_caldav_principals linkp 
  on m.principal_id = linkp.id) as mp
				
  on mp.linkuri LIKE CONCAT(c.principaluri, '/%')

  WHERE (mainp.external_id = 0 or mp.member_external_id = 0)

  ORDER BY c.displayname ASC 
  LIMIT 100

Explain

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

Profile

Status	Duration
Starting	0.06 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
Sending cached result to clien	0.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
27	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
26	JModelList->getItems()	JROOT/components/com_dpcalendar/models/profile.php:38
25	DPCalendarModelProfile->getItems()	JROOT/plugins/system/dpcalendar/dpcalendar.php:235
24	PlgSystemDpcalendar->fetchCalendars()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/plugin.php:509
23	DPCalendarPlugin->onCalendarsFetch()	Same as call in the line below.
22	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
20	JEventDispatcher->trigger()	JROOT/components/com_dpcalendar/models/calendar.php:102
19	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php:27
18	include JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php	JROOT/libraries/cms/module/helper.php:199
17	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
16	JDocumentRendererHtmlModule->render()	JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:107
15	plgContentLoadModuleInArticle->load_module()	JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74
14	plgContentLoadModuleInArticle->onContentPrepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:161
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.15 ms After last query: 5.11 ms Query memory: 0.028 MB Memory before query: 16.555 MB Rows returned: 6

SELECT c.id AS id, a.name AS asset_name

  FROM (
SELECT id,asset_id

  FROM r82m0_categories

  WHERE extension = 'com_dpcalendar' 
  AND published = 1) AS c

  INNER JOIN r82m0_assets AS a 
  ON c.asset_id = a.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r82m0_categories	ref	cat_idx	cat_idx	153	const,const	6	100.00	Using index condition
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	croatiap_grg.r82m0_categories.asset_id	1	100.00

Profile

Status	Duration
Starting	0.05 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.03 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:1689
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/user/user.php:424
21	JUser->getAuthorisedCategories()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:912
20	DPCalendarHelper::canCreateEvent()	JROOT/modules/mod_dpcalendar_mini/tmpl/default.php:42
19	require JROOT/modules/mod_dpcalendar_mini/tmpl/default.php	JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php:32
18	include JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php	JROOT/libraries/cms/module/helper.php:199
17	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
16	JDocumentRendererHtmlModule->render()	JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:107
15	plgContentLoadModuleInArticle->load_module()	JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74
14	plgContentLoadModuleInArticle->onContentPrepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:161
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.14 ms After last query: 0.60 ms Query memory: 0.035 MB Memory before query: 16.614 MB Rows returned: 0

Duplicate queries: #31

SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access

  FROM `r82m0_dpcalendar_caldav_calendars` c

  LEFT 
  OUTER JOIN r82m0_dpcalendar_caldav_principals mainp 
  on mainp.uri = c.principaluri

  LEFT 
  OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri 
  from r82m0_dpcalendar_caldav_principals memberp
				
  inner join r82m0_dpcalendar_caldav_groupmembers m 
  on memberp.id = m.member_id
				
  inner join r82m0_dpcalendar_caldav_principals linkp 
  on m.principal_id = linkp.id) as mp
				
  on mp.linkuri LIKE CONCAT(c.principaluri, '/%')

  WHERE (mainp.external_id = 0 or mp.member_external_id = 0)

  ORDER BY c.displayname ASC 
  LIMIT 100

Explain

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

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
Sending cached result to clien	0.03 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
28	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
27	JModelList->getItems()	JROOT/components/com_dpcalendar/models/profile.php:38
26	DPCalendarModelProfile->getItems()	JROOT/plugins/system/dpcalendar/dpcalendar.php:235
25	PlgSystemDpcalendar->fetchCalendars()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/plugin.php:509
24	DPCalendarPlugin->onCalendarsFetch()	Same as call in the line below.
23	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
22	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
21	JEventDispatcher->trigger()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:917
20	DPCalendarHelper::canCreateEvent()	JROOT/modules/mod_dpcalendar_mini/tmpl/default.php:42
19	require JROOT/modules/mod_dpcalendar_mini/tmpl/default.php	JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php:32
18	include JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php	JROOT/libraries/cms/module/helper.php:199
17	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
16	JDocumentRendererHtmlModule->render()	JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:107
15	plgContentLoadModuleInArticle->load_module()	JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74
14	plgContentLoadModuleInArticle->onContentPrepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:161
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.49 ms After last query: 10.73 ms Query memory: 0.020 MB Memory before query: 16.870 MB Rows returned: 29

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM r82m0_modules AS m

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

  LEFT JOIN r82m0_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 <= '2025-05-12 02:54:00') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-05-12 02:54:00') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 1089 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	range\|filter	PRIMARY,published,newsfeeds,idx_language	idx_language\|published	21\|5	NULL	29 (64%)	64.00	Using index condition; Using where; Using filesort; Using rowid filter
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	croatiap_grg.m.module,const	1	100.00	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	croatiap_grg.m.id	7	100.00	Using where; Using index

Profile

Status	Duration
Starting	0.05 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.13 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.78 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	Same as call in the line below.
15	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
14	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
13	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
12	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
11	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
10	JDocumentHtml->countModules()	JROOT/templates/it_thelodge3/php/variables.php:49
9	include_once JROOT/templates/it_thelodge3/php/variables.php	JROOT/templates/it_thelodge3/php/template.php:29
8	include_once JROOT/templates/it_thelodge3/php/template.php	JROOT/templates/it_thelodge3/index.php:9
7	require JROOT/templates/it_thelodge3/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.51 ms After last query: 17.78 ms Query memory: 0.025 MB Memory before query: 17.367 MB Rows returned: 1

SELECT id,parent_id 
  FROM r82m0_menu 
  WHERE id = 1089

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r82m0_menu	const	PRIMARY	PRIMARY	4	const	1	100.00

Profile

Status	Duration
Starting	0.07 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.01 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
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.05 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.00 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
20	JDatabaseDriver->loadObject()	JROOT/modules/mod_icemegamenu/libs/menucore.php:87
19	IceMenuTree->getCurrentMenuItem()	JROOT/modules/mod_icemegamenu/libs/menucore.php:69
18	IceMenuTree->__construct()	JROOT/modules/mod_icemegamenu/helper.php:45
17	modIceMegamenuHelper::buildXML()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
15	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
14	JCacheControllerCallback->call()	JROOT/modules/mod_icemegamenu/helper.php:110
13	modIceMegamenuHelper->getXML()	JROOT/modules/mod_icemegamenu/helper.php:148
12	modIceMegamenuHelper->render()	JROOT/modules/mod_icemegamenu/tmpl/default.php:15
11	require JROOT/modules/mod_icemegamenu/tmpl/default.php	JROOT/modules/mod_icemegamenu/mod_icemegamenu.php:61
10	include JROOT/modules/mod_icemegamenu/mod_icemegamenu.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.11 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 17.393 MB Rows returned: 1

SELECT id,parent_id 
  FROM r82m0_menu 
  WHERE id = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r82m0_menu	const	PRIMARY	PRIMARY	4	const	1	100.00

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
Sending cached result to clien	0.04 ms
Updating status	0.01 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
20	JDatabaseDriver->loadObject()	JROOT/modules/mod_icemegamenu/libs/menucore.php:87
19	IceMenuTree->getCurrentMenuItem()	JROOT/modules/mod_icemegamenu/libs/menucore.php:69
18	IceMenuTree->__construct()	JROOT/modules/mod_icemegamenu/helper.php:45
17	modIceMegamenuHelper::buildXML()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
15	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
14	JCacheControllerCallback->call()	JROOT/modules/mod_icemegamenu/helper.php:110
13	modIceMegamenuHelper->getXML()	JROOT/modules/mod_icemegamenu/helper.php:148
12	modIceMegamenuHelper->render()	JROOT/modules/mod_icemegamenu/tmpl/default.php:15
11	require JROOT/modules/mod_icemegamenu/tmpl/default.php	JROOT/modules/mod_icemegamenu/mod_icemegamenu.php:61
10	include JROOT/modules/mod_icemegamenu/mod_icemegamenu.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

30 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

2 × SELECT element 
  FROM r82m0_extensions

2 × SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access 
  FROM `r82m0_dpcalendar_caldav_calendars` c 
  LEFT 
  OUTER JOIN r82m0_dpcalendar_caldav_principals mainp 
  on mainp.uri = c.principaluri 
  LEFT 
  OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri 
  from r82m0_dpcalendar_caldav_principals memberp     
  inner join r82m0_dpcalendar_caldav_groupmembers m 
  on memberp.id = m.member_id     
  inner join r82m0_dpcalendar_caldav_principals linkp 
  on m.principal_id = linkp.id) as mp     
  on mp.linkuri LIKE CONCAT(c.principaluri, '/%')

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 r82m0_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM r82m0_categories AS cat JOIN r82m0_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `r82m0_extensions`

2 × SELECT id,parent_id 
  FROM r82m0_menu

2 × SELECT a.rules 
  FROM r82m0_assets AS a

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

```
1 × SELECT * 
  FROM r82m0_modules
```

1 × SELECT published 
  FROM r82m0_modules

1 × SELECT a.id, a.name, a.rules 
  FROM r82m0_assets AS a

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

1 × SELECT c.id AS id, a.name AS asset_name 
  FROM ( SELECT id,asset_id 
  FROM r82m0_categories

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 r82m0_content AS a 
  LEFT JOIN r82m0_categories AS c 
  on c.id = a.catid 
  LEFT JOIN r82m0_users AS u 
  on u.id = a.created_by 
  LEFT JOIN r82m0_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN r82m0_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM r82m0_categories AS cat JOIN r82m0_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT a.id, a.parent_id 
  FROM r82m0_assets AS a

```
1 × SELECT * 
  FROM r82m0_languages
```

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

1 × SELECT id, rules 
  FROM `r82m0_viewlevels

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

1 × SELECT `session_id` 
  FROM `r82m0_session`

```
1 × SELECT * 
  FROM r82m0_assets
```

1 × SELECT a.name, a.rules 
  FROM r82m0_assets AS a

1 × SELECT `data` 
  FROM `r82m0_session`

1 × SELECT id, home, template, s.params 
  FROM r82m0_template_styles as s 
  LEFT JOIN r82m0_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 r82m0_menu AS m 
  LEFT JOIN r82m0_extensions AS e 
  ON m.component_id = e.extension_id

```
1 × SELECT * 
  FROM r82m0_content
```

OTHER Tables:

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

1 × SHOW FULL COLUMNS 
  FROM `r82m0_content

1 × UPDATE `r82m0_extensions` 
  SET `params` = '{\"mediaversion\":\"12efe8e863c6a02a0d1d2f8d23181981\"}'

1 × SHOW FULL COLUMNS 
  FROM `r82m0_assets

1 × INSERT INTO `r82m0_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('pq8fe7a9v4c5rvtbfcdu2q74j6', 0, 1, '1747018440', 0, ''