This site uses cookies to offer the best browsing experience possible, as well as for commercial and advertising. If you proceed to browse the site without disabling them, you authorize us to send and the use of cookies on your device.

Legal Terms

The contents of this site are provided by Campo Marzio 9. The company disclaims any responsibility for any direct or indirect damages resulting from errors or inaccuracies of content, or lack of current information, especially where the information is used by the client to the decisions about economic or financial initiatives or activities.

The information in all areas of the site are protected by copyright, but may be freely used providing the source is mentioned and you do not change the same information and data extracted.

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1714020913,
                "last": 1714020913,
                "now": 1714020913
            },
            "client": {
                "forwarded": "3.133.144.197"
            }
        },
        "registry": {
            "cmobile": {
                "ismobile": false,
                "isdevice": false,
                "device": "{}",
                "detection": {
                    "system": false
                }
            }
        },
        "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: 37.06 ms / 37.06 ms Memory: 0.199 MB / 0.42 MB Application: afterLoad

Time: 200.93 ms / 237.99 ms Memory: 3.543 MB / 3.96 MB Application: afterInitialise

Time: 53.42 ms / 291.41 ms Memory: 0.704 MB / 4.67 MB Application: afterRoute

Time: 1.39 ms / 292.80 ms Memory: 0.042 MB / 4.71 MB Application: beforeRenderComponent com_content

Time: 19.83 ms / 312.63 ms Memory: 0.302 MB / 5.01 MB Application: Start JAccess::getAssetRules Old (1)

Time: 1.86 ms / 314.49 ms Memory: 0.037 MB / 5.05 MB Application: Finish JAccess::getAssetRules Old (1)

Time: 0.07 ms / 314.56 ms Memory: 0.000 MB / 5.04 MB Application: Start JAccess::preload(components)

Time: 5.57 ms / 320.12 ms Memory: 0.357 MB / 5.40 MB Application: Finish JAccess::preload(components)

Time: 70.62 ms / 390.74 ms Memory: 0.760 MB / 6.16 MB Application: afterRenderComponent com_content

Time: 133.52 ms / 524.26 ms Memory: 0.503 MB / 6.66 MB Application: afterDispatch

Time: 22.20 ms / 546.45 ms Memory: 0.209 MB / 6.87 MB Application: beforeRenderModule mod_mycopyright (MyCopyright)

Time: 4.95 ms / 551.40 ms Memory: 0.022 MB / 6.89 MB Application: afterRenderModule mod_mycopyright (MyCopyright)

Time: 0.47 ms / 551.87 ms Memory: 0.034 MB / 6.93 MB Application: beforeRenderModule mod_maximenuck (Menu' Footer EN CK)

Time: 36.96 ms / 588.83 ms Memory: 0.270 MB / 7.20 MB Application: afterRenderModule mod_maximenuck (Menu' Footer EN CK)

Time: 0.63 ms / 589.46 ms Memory: 0.000 MB / 7.15 MB Application: beforeRenderModule mod_maximenuck (Maximenu CK (2) inglese)

Time: 6.62 ms / 596.08 ms Memory: 0.692 MB / 7.84 MB Application: beforeRenderModule mod_socialmedialinksgenius (Social Media Links Genius)

Time: 2.49 ms / 598.58 ms Memory: 0.031 MB / 7.87 MB Application: afterRenderModule mod_socialmedialinksgenius (Social Media Links Genius)

Time: 0.34 ms / 598.92 ms Memory: 0.000 MB / 7.85 MB Application: beforeRenderModule mod_languages (Seleziona lingua (inglese))

Time: 3.89 ms / 602.81 ms Memory: 0.027 MB / 7.87 MB Application: afterRenderModule mod_languages (Seleziona lingua (inglese))

Time: 3.08 ms / 605.89 ms Memory: 0.000 MB / 7.30 MB Application: afterRenderModule mod_maximenuck (Maximenu CK (2) inglese)

Time: 60.57 ms / 666.46 ms Memory: 0.091 MB / 7.39 MB Application: afterRender

Database queries total: 167.82 ms

Memory Usage

Database Queries

43 Queries Logged 167.82 ms

2 duplicate found!

2 duplicates: #37 #38

Query Time: 1.44 ms Query memory: 0.019 MB Memory before query: 0.929 MB Rows returned: 0

SELECT `data`

  FROM `itn8g_session`

  WHERE `session_id` = 'fpr514q560fq5artts7p5bt094'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	itn8g_session	NULL	const	PRIMARY	PRIMARY	766	const	1	100.00	NULL

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.03 ms
Opening tables	0.33 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.10 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 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: 3.54 ms After last query: 6.20 ms Query memory: 0.008 MB Memory before query: 0.995 MB

DELETE 

  FROM `itn8g_session`

  WHERE `time` < '1713930913'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	itn8g_session	NULL	range	time	time	59	const	1	100.00	Using where

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.12 ms
updating	2.60 ms
end	0.04 ms
query end	0.02 ms
closing tables	0.06 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:790
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.57 ms After last query: 0.15 ms Query memory: 0.012 MB Memory before query: 1.007 MB Rows returned: 0

SELECT `session_id`

  FROM `itn8g_session`

  WHERE `session_id` = 'fpr514q560fq5artts7p5bt094' 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	itn8g_session	NULL	const	PRIMARY	PRIMARY	766	const	1	100.00	Using index

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 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.82 ms After last query: 0.12 ms Query memory: 0.009 MB Memory before query: 1.022 MB

INSERT INTO `itn8g_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('fpr514q560fq5artts7p5bt094', 0, 1, '1714020913', 0, '')

Explain

EXPLAIN not possible on query: INSERT INTO `itn8g_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('fpr514q560fq5artts7p5bt094', 0, 1, '1714020913', 0, '')

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
update	0.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.05 ms
cleaning up	0.01 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: 1.92 ms After last query: 4.94 ms Query memory: 0.019 MB Memory before query: 1.079 MB Rows returned: 46

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

  FROM `itn8g_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	itn8g_extensions	NULL	ref	extension	extension	82	const	43	100.00	NULL

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.02 ms
Opening tables	0.31 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.17 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.57 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.08 ms
cleaning up	0.01 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: 1.35 ms After last query: 3.28 ms Query memory: 0.016 MB Memory before query: 1.159 MB Rows returned: 2

SELECT b.id

  FROM itn8g_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.34 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.09 ms
cleaning up	0.01 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: 1.01 ms After last query: 1.22 ms Query memory: 0.015 MB Memory before query: 1.180 MB Rows returned: 5

SELECT id, rules

  FROM `itn8g_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.34 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.01 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: 3.00 ms After last query: 0.16 ms Query memory: 0.015 MB Memory before query: 1.199 MB Rows returned: 75

SELECT folder AS type, element AS name, params

  FROM itn8g_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	itn8g_extensions	NULL	ref	extension	extension	82	const	135	0.60	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.24 ms
preparing	0.04 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.95 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.07 ms
cleaning up	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: 1.63 ms After last query: 46.32 ms Query memory: 0.018 MB Memory before query: 1.998 MB Rows returned: 2

SELECT *

  FROM itn8g_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.60 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.01 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: 1.31 ms After last query: 0.60 ms Query memory: 0.014 MB Memory before query: 2.022 MB Rows returned: 2

SELECT element

  FROM itn8g_extensions

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	itn8g_extensions	NULL	ref	extension	extension	82	const	4	1.25	Using index condition; Using where

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.01 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: 5.09 ms After last query: 23.73 ms Query memory: 0.044 MB Memory before query: 2.298 MB Rows returned: 42

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

  LEFT JOIN itn8g_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	57	10.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	campomar70563.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.15 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.41 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	2.32 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
19	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
18	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
17	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
16	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
15	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
14	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
13	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
12	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
11	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
10	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
9	PlgSystemLanguageFilter->onAfterInitialise()	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:670
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: 1.26 ms After last query: 11.60 ms Query memory: 0.017 MB Memory before query: 3.952 MB Rows returned: 0

SELECT *

  FROM `itn8g_rsseo_redirects`

  WHERE `published` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.27 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsseo/rsseo.php:147
9	plgSystemRsseo->onAfterInitialise()	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:670
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: 1.51 ms After last query: 29.11 ms Query memory: 0.026 MB Memory before query: 4.436 MB Rows returned: 1

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

  FROM `itn8g_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	itn8g_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.35 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
18	JDatabaseDriver->loadObject()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
16	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
15	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
14	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
13	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/sl_scrolltotop/sl_scrolltotop.php:84
9	plgSystemSL_ScrollToTop->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: 1.28 ms After last query: 0.30 ms Query memory: 0.018 MB Memory before query: 4.445 MB

UPDATE `itn8g_extensions`

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

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	itn8g_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.26 ms
updating	0.16 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
14	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
13	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/sl_scrolltotop/sl_scrolltotop.php:84
9	plgSystemSL_ScrollToTop->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: 2.05 ms After last query: 5.38 ms Query memory: 0.027 MB Memory before query: 4.547 MB Rows returned: 8

SELECT id, home, template, s.params

  FROM itn8g_template_styles as s

  LEFT JOIN itn8g_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	10	10.00	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	campomar70563.s.template,const	1	5.00	Using index condition; Using where

Profile

Status	Duration
starting	0.13 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.30 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.18 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.36 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
20	JApplicationSite->getTemplate()	JROOT/libraries/cms/html/html.php:339
19	JHtml::includeRelativeFiles()	JROOT/libraries/cms/html/html.php:684
18	JHtml::script()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
16	JHtml::call()	JROOT/libraries/cms/html/html.php:139
15	JHtml::_()	JROOT/libraries/cms/html/behavior.php:64
14	JHtmlBehavior::framework()	JROOT/libraries/cms/html/behavior.php:61
13	JHtmlBehavior::framework()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
11	JHtml::call()	JROOT/libraries/cms/html/html.php:139
10	JHtml::_()	JROOT/plugins/system/sl_scrolltotop/sl_scrolltotop.php:130
9	plgSystemSL_ScrollToTop->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: 2.17 ms After last query: 28.73 ms Query memory: 0.031 MB Memory before query: 4.933 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `itn8g_assets`

Explain

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

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.25 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
Opening tables	0.32 ms
checking permissions	0.06 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.06 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
18	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
17	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
16	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
15	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
14	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
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.11 ms After last query: 2.96 ms Query memory: 0.025 MB Memory before query: 4.994 MB Rows returned: 1

SELECT *

  FROM itn8g_assets

  WHERE `id` = '1'

Explain

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

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
15	JTable->load()	JROOT/libraries/joomla/access/access.php:697
14	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
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.84 ms After last query: 0.20 ms Query memory: 0.021 MB Memory before query: 5.013 MB Rows returned: 1

SELECT a.rules

  FROM itn8g_assets AS a

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

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.19 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	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/user/user.php:385
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
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.57 ms After last query: 1.11 ms Query memory: 0.024 MB Memory before query: 5.046 MB Rows returned: 46

SELECT element

  FROM itn8g_extensions

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	itn8g_extensions	NULL	ref	extension	extension	82	const	43	10.00	Using where

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.49 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
16	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
15	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
14	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
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: 2.03 ms After last query: 0.26 ms Query memory: 0.024 MB Memory before query: 5.078 MB Rows returned: 44

SELECT a.name, a.rules

  FROM itn8g_assets AS a

  WHERE (a.name IN ('com_admin','com_advancedtemplates','com_ajax','com_akeeba','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_contenttemplater','com_cpanel','com_datasafe_pro','com_easyjoomlabackup','com_finder','com_gantry5','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_maximenuck','com_media','com_menus','com_messages','com_mobilejoomla','com_modules','com_newsfeeds','com_nonumbermanager','com_phocamaps','com_phpmyjoomla','com_plugins','com_postinstall','com_redirect','com_rereplacer','com_responsivizer','com_rsform','com_rsseo','com_search','com_tags','com_templates','com_users','com_wrapper') OR a.name = 'root.1')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	239	19.67	Using where

Profile

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.11 ms
System lock	0.04 ms
optimizing	0.02 ms
statistics	0.31 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.82 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
16	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
15	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
14	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
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: 2.23 ms After last query: 3.42 ms Query memory: 0.026 MB Memory before query: 5.415 MB Rows returned: 30

SHOW FULL COLUMNS 
  FROM `itn8g_content`

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.21 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
Opening tables	0.37 ms
checking permissions	0.06 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.04 ms
Sending data	0.19 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.06 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	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.03 ms After last query: 7.84 ms Query memory: 0.024 MB Memory before query: 5.547 MB Rows returned: 1

SELECT *

  FROM itn8g_content

  WHERE `id` = '21'

Explain

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

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 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.48 ms After last query: 0.21 ms Query memory: 0.014 MB Memory before query: 5.562 MB

UPDATE itn8g_content

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

  WHERE `id` = '21'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	itn8g_content	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.04 ms
updating	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	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: 3.15 ms After last query: 2.68 ms Query memory: 0.028 MB Memory before query: 5.631 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 itn8g_content AS a

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

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

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

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

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM itn8g_categories AS cat JOIN itn8g_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 = 21 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-25 04:55:13') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-25 04:55:13') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	v	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
1	PRIMARY	a	NULL	const	PRIMARY,idx_state,idx_language	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	1	100.00	Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	1	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	NULL	ALL	PRIMARY,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	7	14.29	Range checked for each record (index map: 0x11)

Profile

Status	Duration
starting	0.36 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.82 ms
init	0.18 ms
System lock	0.02 ms
optimizing	0.01 ms
optimizing	0.02 ms
statistics	0.34 ms
preparing	0.05 ms
Creating tmp table	0.03 ms
Sorting result	0.04 ms
statistics	0.20 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.06 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.05 ms
end	0.01 ms
query end	0.02 ms
removing tmp table	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.01 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: 3.17 ms After last query: 7.79 ms Query memory: 0.027 MB Memory before query: 5.816 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 itn8g_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM itn8g_categories AS cat JOIN itn8g_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 itn8g_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=2

  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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	PRIMARY	c	NULL	ALL	cat_idx,idx_access,idx_left_right,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	7	22.67	Using where
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	campomar70563.c.id	2	100.00	Using where; Not exists; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	NULL	ALL	PRIMARY,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	7	14.29	Range checked for each record (index map: 0x11)

Profile

Status	Duration
starting	0.32 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.21 ms
System lock	0.02 ms
optimizing	0.01 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.04 ms
Creating tmp table	0.03 ms
Sorting result	0.04 ms
statistics	0.31 ms
preparing	0.07 ms
Creating tmp table	0.09 ms
Sorting result	0.01 ms
executing	0.02 ms
Sending data	0.07 ms
executing	0.01 ms
Sending data	0.04 ms
Creating sort index	0.40 ms
Creating sort index	0.14 ms
end	0.01 ms
query end	0.02 ms
removing tmp table	0.07 ms
query end	0.02 ms
removing tmp table	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.01 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: 1.82 ms After last query: 1.08 ms Query memory: 0.025 MB Memory before query: 5.873 MB Rows returned: 0

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

  FROM `itn8g_contentitem_tag_map` AS m 

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

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	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.13 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.51 ms
init	0.08 ms
System lock	0.02 ms
optimizing	0.06 ms
statistics	0.09 ms
preparing	0.01 ms
executing	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 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: 2.32 ms After last query: 15.08 ms Query memory: 0.026 MB Memory before query: 5.989 MB Rows returned: 0

SELECT r.*

  FROM itn8g_rereplacer AS r

  WHERE r.published = 1 
  AND (r.area = 'articles')

  ORDER BY r.ordering, r.id

Explain

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

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.96 ms
init	0.07 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.14 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rereplacer/helpers/items.php:50
16	PlgSystemReReplacerHelperItems->getItemList()	JROOT/plugins/system/rereplacer/helper.php:34
15	PlgSystemReReplacerHelper->onContentPrepare()	JROOT/plugins/system/rereplacer/rereplacer.php:38
14	PlgSystemReReplacer->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.71 ms After last query: 40.81 ms Query memory: 0.023 MB Memory before query: 6.443 MB Rows returned: 54

SELECT *

  FROM itn8g_rsform_config

Explain

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

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.50 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
13	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
12	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:97
11	RSFormProConfig::getInstance()	JROOT/administrator/components/com_rsform/helpers/rsform.php:391
10	RSFormProHelper::readConfig()	JROOT/plugins/system/rsfpregistration/rsfpregistration.php:25
9	plgSystemRSFPRegistration->canRun()	JROOT/plugins/system/rsfpregistration/rsfpregistration.php:993
8	plgSystemRSFPRegistration->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
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.81 ms After last query: 0.41 ms Query memory: 0.017 MB Memory before query: 6.475 MB Rows returned: 3

SELECT language,id

  FROM `itn8g_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	itn8g_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	58	1.00	Using where

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.41 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.63 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:121
9	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:697
8	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
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.83 ms After last query: 3.57 ms Query memory: 0.017 MB Memory before query: 6.508 MB Rows returned: 2

SELECT `c2`.`language`,`c2`.`id`

  FROM `itn8g_menu` AS `c`

  INNER JOIN `itn8g_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

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

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

  WHERE c.id = 169

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	a	NULL	const	PRIMARY,idx_key	PRIMARY	206	const,const	1	100.00	NULL
1	SIMPLE	a2	NULL	ref	idx_key	idx_key	128	const	2	100.00	NULL
1	SIMPLE	c2	NULL	eq_ref	PRIMARY	PRIMARY	4	campomar70563.a2.id	1	100.00	NULL

Profile

Status	Duration
starting	0.13 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Opening tables	0.45 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.21 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
10	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:284
9	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:714
8	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
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.54 ms After last query: 2.38 ms Query memory: 0.017 MB Memory before query: 6.532 MB Rows returned: 0

SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`

  FROM `itn8g_content` AS `c`

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

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

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

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

  WHERE c.id = 21

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.20 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Opening tables	0.17 ms
init	0.07 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.15 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
11	JLanguageAssociations::getAssociations()	JROOT/components/com_content/helpers/association.php:43
10	ContentHelperAssociation::getAssociations()	Same as call in the line below.
9	call_user_func()	JROOT/plugins/system/languagefilter/languagefilter.php:729
8	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
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.42 ms After last query: 4.28 ms Query memory: 0.016 MB Memory before query: 6.571 MB Rows returned: 1

SELECT `params`

  FROM `itn8g_extensions`

  WHERE `type` = 'component' 
  AND `element` = 'com_rsseo'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	itn8g_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.32 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
11	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_rsseo/helpers/rsseo.php:25
10	rsseoHelper::getConfig()	JROOT/plugins/system/rsseo/rsseo.php:899
9	plgSystemRsseo->sitemap()	JROOT/plugins/system/rsseo/rsseo.php:78
8	plgSystemRsseo->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
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.31 ms After last query: 0.32 ms Query memory: 0.017 MB Memory before query: 6.603 MB Rows returned: 0

SELECT `id`,`title`,`description`,`keywords`,`level`,`crawled`,`modified`,`canonical`,`robots`,`custom`

  FROM `itn8g_rsseo_pages`

  WHERE `url` = 'index.php/eng/legal-terms' 
  AND `published` = 1 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	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.11 ms
checking permissions	0.02 ms
Opening tables	0.33 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/rsseo/rsseo.php:450
9	plgSystemRsseo->meta()	JROOT/plugins/system/rsseo/rsseo.php:117
8	plgSystemRsseo->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
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: 89.70 ms After last query: 0.51 ms Query memory: 0.015 MB Memory before query: 6.636 MB Rows returned: 0

SELECT `id`,`date`

  FROM `itn8g_rsseo_visitors`

  WHERE `session_id` = 'fpr514q560fq5artts7p5bt094'

  ORDER BY `date` DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	itn8g_rsseo_visitors	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	231453	10.00	Using where; Using filesort

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.24 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	88.55 ms
end	0.03 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/rsseo/rsseo.php:964
9	plgSystemRsseo->visit()	JROOT/plugins/system/rsseo/rsseo.php:120
8	plgSystemRsseo->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
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.75 ms After last query: 0.68 ms Query memory: 0.012 MB Memory before query: 6.651 MB

INSERT INTO `itn8g_rsseo_visitors`

  SET `session_id` = 'fpr514q560fq5artts7p5bt094'
	, `date` = '2024-04-25 04:55:13'
	, `ip` = '3.133.144.197'
	, `user_id` = '0'
	, `agent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
	, `referer` = ''
	, `page` = 'index.php/eng/legal-terms'

Explain

EXPLAIN not possible on query: INSERT INTO `itn8g_rsseo_visitors` SET `session_id` = 'fpr514q560fq5artts7p5bt094' , `date` = '2024-04-25 04:55:13' , `ip` = '3.133.144.197' , `user_id` = '0' , `agent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `referer` = '' , `page` = 'index.php/eng/legal-terms'

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
update	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/rsseo/rsseo.php:977
9	plgSystemRsseo->visit()	JROOT/plugins/system/rsseo/rsseo.php:120
8	plgSystemRsseo->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
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: 5.58 ms After last query: 11.39 ms Query memory: 0.050 MB Memory before query: 6.738 MB Rows returned: 9

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

  FROM itn8g_modules AS m

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

  LEFT JOIN itn8g_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 <= '2024-04-25 04:55:13') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-25 04:55:13') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 169 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds,idx_language	published	5	NULL	94	0.66	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	campomar70563.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	campomar70563.m.id	2	40.00	Using where; Using index

Profile

Status	Duration
starting	0.22 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.43 ms
init	0.11 ms
System lock	0.02 ms
optimizing	0.05 ms
statistics	0.36 ms
preparing	0.06 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.07 ms
Creating sort index	3.31 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.06 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
12	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
11	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
10	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
9	JDocumentHtml->countModules()	JROOT/templates/20/library/Artx/Page.php:43
8	ArtxPage->containsModules()	JROOT/templates/20/index.php:70
7	require JROOT/templates/20/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: 4.08 ms After last query: 26.55 ms Query memory: 0.039 MB Memory before query: 7.109 MB Rows returned: 99

Duplicate queries: #38

SELECT *
			
  FROM itn8g_modules
			
  WHERE published=1
			
  ORDER BY id
			;

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	itn8g_modules	NULL	ref	published	published	1	const	105	100.00	Using index condition; Using filesort

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	2.33 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_maximenuck/helper.php:391
12	modMaximenuckHelper::CreateModulesList()	JROOT/modules/mod_maximenuck/helper.php:61
11	modMaximenuckHelper::getItems()	JROOT/modules/mod_maximenuck/mod_maximenuck.php:43
10	include JROOT/modules/mod_maximenuck/mod_maximenuck.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: 3.75 ms After last query: 18.71 ms Query memory: 0.038 MB Memory before query: 7.214 MB Rows returned: 99

Duplicate queries: #37

SELECT *
			
  FROM itn8g_modules
			
  WHERE published=1
			
  ORDER BY id
			;

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	itn8g_modules	NULL	ref	published	published	1	const	105	100.00	Using index condition; Using filesort

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.07 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	2.31 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_maximenuck/helper.php:391
12	modMaximenuckHelper::CreateModulesList()	JROOT/modules/mod_maximenuck/helper.php:61
11	modMaximenuckHelper::getItems()	JROOT/modules/mod_maximenuck/mod_maximenuck.php:43
10	include JROOT/modules/mod_maximenuck/mod_maximenuck.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: 1.16 ms After last query: 18.46 ms Query memory: 0.021 MB Memory before query: 7.303 MB Rows returned: 0

SELECT r.*

  FROM itn8g_rereplacer AS r

  WHERE r.published = 1 
  AND (r.area = 'component')

  ORDER BY r.ordering, r.id

Explain

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

Profile

Status	Duration
starting	0.13 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.08 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rereplacer/helpers/items.php:50
12	PlgSystemReReplacerHelperItems->getItemList()	JROOT/plugins/system/rereplacer/helpers/replace.php:51
11	PlgSystemReReplacerHelperReplace->replaceInArea()	JROOT/plugins/system/rereplacer/helpers/replace.php:37
10	PlgSystemReReplacerHelperReplace->replaceInAreas()	JROOT/plugins/system/rereplacer/helper.php:97
9	PlgSystemReReplacerHelper->onAfterRender()	JROOT/plugins/system/rereplacer/rereplacer.php:58
8	PlgSystemReReplacer->onAfterRender()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
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.75 ms After last query: 0.15 ms Query memory: 0.021 MB Memory before query: 7.320 MB Rows returned: 0

SELECT r.*

  FROM itn8g_rereplacer AS r

  WHERE r.published = 1 
  AND (r.area = 'head')

  ORDER BY r.ordering, r.id

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rereplacer/helpers/items.php:50
12	PlgSystemReReplacerHelperItems->getItemList()	JROOT/plugins/system/rereplacer/helpers/replace.php:51
11	PlgSystemReReplacerHelperReplace->replaceInArea()	JROOT/plugins/system/rereplacer/helpers/replace.php:38
10	PlgSystemReReplacerHelperReplace->replaceInAreas()	JROOT/plugins/system/rereplacer/helper.php:97
9	PlgSystemReReplacerHelper->onAfterRender()	JROOT/plugins/system/rereplacer/rereplacer.php:58
8	PlgSystemReReplacer->onAfterRender()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
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.74 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 7.338 MB Rows returned: 0

SELECT r.*

  FROM itn8g_rereplacer AS r

  WHERE r.published = 1 
  AND (r.area = 'body')

  ORDER BY r.ordering, r.id

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rereplacer/helpers/items.php:50
12	PlgSystemReReplacerHelperItems->getItemList()	JROOT/plugins/system/rereplacer/helpers/replace.php:51
11	PlgSystemReReplacerHelperReplace->replaceInArea()	JROOT/plugins/system/rereplacer/helpers/replace.php:39
10	PlgSystemReReplacerHelperReplace->replaceInAreas()	JROOT/plugins/system/rereplacer/helper.php:97
9	PlgSystemReReplacerHelper->onAfterRender()	JROOT/plugins/system/rereplacer/rereplacer.php:58
8	PlgSystemReReplacer->onAfterRender()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
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.66 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 7.356 MB Rows returned: 0

SELECT r.*

  FROM itn8g_rereplacer AS r

  WHERE r.published = 1 
  AND (r.area = 'everywhere')

  ORDER BY r.ordering, r.id

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.02 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rereplacer/helpers/items.php:50
12	PlgSystemReReplacerHelperItems->getItemList()	JROOT/plugins/system/rereplacer/helpers/replace.php:76
11	PlgSystemReReplacerHelperReplace->replaceEverywhere()	JROOT/plugins/system/rereplacer/helpers/replace.php:41
10	PlgSystemReReplacerHelperReplace->replaceInAreas()	JROOT/plugins/system/rereplacer/helper.php:97
9	PlgSystemReReplacerHelper->onAfterRender()	JROOT/plugins/system/rereplacer/rereplacer.php:58
8	PlgSystemReReplacer->onAfterRender()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
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: 1.34 ms After last query: 3.67 ms Query memory: 0.015 MB Memory before query: 7.399 MB Rows returned: 0

SELECT *

  FROM `itn8g_rsseo_keywords`

  ORDER BY CHAR_LENGTH(keyword) DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.29 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.08 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsseo/rsseo.php:248
8	plgSystemRsseo->onAfterRender()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
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.]

36 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

5 × SELECT r.* 
  FROM itn8g_rereplacer AS r

2 × SELECT *
    
  FROM itn8g_modules

2 × SELECT element 
  FROM itn8g_extensions

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

1 × SELECT language,id 
  FROM `itn8g_menu`

1 × SELECT * 
  FROM itn8g_rsform_confi

1 × SELECT * 
  FROM `itn8g_rsseo_keywords`

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

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `itn8g_menu` AS `c` 
  INNER JOIN `itn8g_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `itn8g_associations` AS `a2` 
  ON a.key = a2.key 
  INNER JOIN `itn8g_menu` AS `c2` 
  ON a2.id = c2.`id`

1 × SELECT `params` 
  FROM `itn8g_extensions`

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

1 × SELECT `id`,`date` 
  FROM `itn8g_rsseo_visitors`

1 × SELECT `id`,`title`,`description`,`keywords`,`level`,`crawled`,`modified`,`canonical`,`robots`,`custom` 
  FROM `itn8g_rsseo_pages`

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

1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid` 
  FROM `itn8g_content` AS `c` 
  INNER JOIN `itn8g_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item' 
  INNER JOIN `itn8g_associations` AS `a2` 
  ON a.key = a2.key 
  INNER JOIN `itn8g_content` AS `c2` 
  ON a2.id = c2.`id` 
  INNER JOIN `itn8g_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

```
1 × SELECT * 
  FROM itn8g_content
```

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

```
1 × SELECT * 
  FROM itn8g_languages
```

1 × SELECT id, rules 
  FROM `itn8g_viewlevels

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

1 × SELECT `session_id` 
  FROM `itn8g_session`

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

1 × SELECT * 
  FROM `itn8g_rsseo_redirects`

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

1 × SELECT `data` 
  FROM `itn8g_session`

1 × SELECT a.rules 
  FROM itn8g_assets AS a

```
1 × SELECT * 
  FROM itn8g_assets
```

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

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM itn8g_content AS a 
  LEFT JOIN itn8g_categories AS c 
  on c.id = a.catid 
  LEFT JOIN itn8g_users AS u 
  on u.id = a.created_by 
  LEFT JOIN itn8g_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN itn8g_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM itn8g_categories AS cat JOIN itn8g_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

OTHER Tables:

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

1 × INSERT INTO `itn8g_rsseo_visitors` 
  SET `session_id` = 'fpr514q560fq5artts7p5bt094'  , `date` = '2024-04-25 04:55:13'  , `ip` = '3.133.144.197'  , `user_id` = '0'  , `agent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'  , `referer` = ''  , `page` = 'index.php/eng/legal-terms

1 × SHOW FULL COLUMNS 
  FROM `itn8g_content

1 × SHOW FULL COLUMNS 
  FROM `itn8g_assets

1 × INSERT INTO `itn8g_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('fpr514q560fq5artts7p5bt094', 0, 1, '1714020913', 0, ''

1 × UPDATE `itn8g_extensions` 
  SET `params` = '{\"mediaversion\":\"b327f044b1ab7b592998c1a3bc988941\"}'

```
1 × DELETE  
  FROM `itn8g_session`
```