Notice: Trying to get property of non-object in /home/elzenzo/public_html/components/com_tags/views/tag/view.html.php on line 120

Colectivo El Zenzontle

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1729900867,
                "last": 1729900867,
                "now": 1729900867
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profile Information

Memory Usage

Database Queries

23 Queries Logged 55.51 ms

2 duplicate found!

2 duplicates: #18 #20

Query Time: 1.21 ms Query memory: 0.003 MB Memory before query: 2.455 MB

DELETE 

  FROM `jos_session`

  WHERE `time` < '1729899967'

Explain

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

Profile

Status	Duration
Starting	0.28 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init for update	0.16 ms
Updating	0.16 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.03 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.12 ms
Updating status	0.05 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:818
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:412
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.05 ms After last query: 0.83 ms Query memory: 0.007 MB Memory before query: 2.472 MB Rows returned: 0

SELECT `data`

  FROM `jos_session`

  WHERE `session_id` = 'f52efc526e90e1bb653a9779a939dfba'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:825
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:412
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.17 ms After last query: 2.74 ms Query memory: 0.004 MB Memory before query: 2.556 MB Rows returned: 0

SELECT `session_id`

  FROM `jos_session`

  WHERE `session_id` = 'f52efc526e90e1bb653a9779a939dfba' 
  LIMIT 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
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:412
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: 2.58 ms After last query: 0.25 ms Query memory: 0.003 MB Memory before query: 2.560 MB

INSERT INTO `jos_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('f52efc526e90e1bb653a9779a939dfba', 1, '1729900867', 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('f52efc526e90e1bb653a9779a939dfba', 1, '1729900867', 0, '', 0)

Profile

Status	Duration
Starting	0.19 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.07 ms
init for update	0.03 ms
Update	0.16 ms
Waiting for query cache lock	0.02 ms
Update	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	1.52 ms
Query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.17 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
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:412
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.08 ms After last query: 5.65 ms Query memory: 0.005 MB Memory before query: 2.720 MB Rows returned: 38

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

  FROM `jos_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_extensions	ref	extension	extension	82	const	38	100.00	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:452
8	JComponentHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:460
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
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.32 ms After last query: 4.33 ms Query memory: 0.005 MB Memory before query: 2.960 MB Rows returned: 3

SELECT b.id

  FROM jos_usergroups AS a

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

  WHERE a.id = 7

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1047
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
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:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
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: 1.12 ms Query memory: 0.005 MB Memory before query: 3.005 MB Rows returned: 5

SELECT id, rules

  FROM `jos_viewlevels`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1064
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
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:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
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.13 ms After last query: 0.22 ms Query memory: 0.005 MB Memory before query: 3.032 MB Rows returned: 91

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

  FROM jos_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,2,3,6)

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	245	50.61	Using where; Using filesort

Profile

Status	Duration
Starting	0.77 ms
Waiting for query cache lock	0.04 ms
starting	0.02 ms
Checking query cache for query	0.23 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.03 ms
table lock	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.17 ms
Optimizing	0.08 ms
Statistics	0.18 ms
Preparing	0.05 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.02 ms
Waiting for query cache lock	0.03 ms
Creating sort index	0.09 ms
Waiting for query cache lock	0.02 ms
Creating sort index	1.26 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.10 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.28 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.16 ms
Waiting for query cache lock	0.02 ms
Updating status	0.01 ms
Storing result in query cache	0.07 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:311
8	JPluginHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:316
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:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
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.80 ms After last query: 31.08 ms Query memory: 0.009 MB Memory before query: 4.170 MB Rows returned: 24

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

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

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

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	51	57.95	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	elzenzo_2.m.component_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
16	JMenuSite->{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
15	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:443
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:548
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1141
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
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.38 ms After last query: 14.53 ms Query memory: 0.006 MB Memory before query: 4.609 MB Rows returned: 1

SELECT id

  FROM `jos_tags`

  WHERE `alias` = 'por-pp'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_tags	ref	idx_alias	idx_alias	402	const	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
11	JDatabaseDriver->loadResult()	JROOT/components/com_tags/router.php:179
10	TagsRouter->fixSegment()	JROOT/components/com_tags/router.php:147
9	TagsRouter->parse()	JROOT/libraries/cms/router/site.php:432
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
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.25 ms After last query: 0.92 ms Query memory: 0.006 MB Memory before query: 4.647 MB Rows returned: 1

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

  FROM `jos_extensions`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
12	JLibraryHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
10	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1022
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
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.82 ms After last query: 0.34 ms Query memory: 0.005 MB Memory before query: 4.637 MB

UPDATE `jos_extensions`

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

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

Explain

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

Profile

Status	Duration
Starting	0.22 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.13 ms
Updating	0.16 ms
End of update loop	0.02 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.12 ms
Query end	0.02 ms
Commit	1.54 ms
Query end	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.16 ms
Updating status	0.08 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1022
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
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.55 ms After last query: 4.51 ms Query memory: 0.003 MB Memory before query: 4.856 MB Rows returned: 1

SELECT *

  FROM jos_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:327
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
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.73 ms After last query: 0.39 ms Query memory: 0.003 MB Memory before query: 4.867 MB Rows returned: 3

SELECT id, home, template, s.params

  FROM jos_template_styles as s

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

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	3	100.00
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	elzenzo_2.s.template,const	1	2.45	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
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.71 ms After last query: 19.76 ms Query memory: 0.009 MB Memory before query: 5.462 MB Rows returned: 15

SELECT *

  FROM `jos_content_types`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/cms/helper/tags.php:790
17	JHelperTags::getTypes()	JROOT/libraries/cms/helper/tags.php:624
16	JHelperTags->getTagItemsQuery()	JROOT/components/com_tags/models/tag.php:148
15	TagsModelTag->getListQuery()	JROOT/libraries/legacy/model/list.php:132
14	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:186
13	JModelList->getItems()	JROOT/components/com_tags/models/tag.php:86
12	TagsModelTag->getItems()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_tags/views/tag/view.html.php:51
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:265
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.47 ms After last query: 0.39 ms Query memory: 0.007 MB Memory before query: 5.472 MB Rows returned: 0

SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
  CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
  CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email

  FROM jos_contentitem_tag_map AS m

  INNER JOIN jos_ucm_content AS c 
  ON m.type_alias = c.core_type_alias 
  AND m.core_content_id = c.core_content_id 
  AND c.core_state IN (1) 
  AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2024-10-26 00:01:07')  
  AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2024-10-26 00:01:07')

  INNER JOIN jos_content_types AS ct 
  ON ct.type_alias = m.type_alias

  LEFT JOIN jos_categories AS tc 
  ON tc.id = c.core_catid

  LEFT JOIN jos_users AS ua 
  ON ua.id = c.core_created_user_id

  WHERE m.tag_id IN (14) 
  AND (c.core_catid = 0 OR tc.published = 1) 
  AND m.type_alias IN ('com_content.article','com_weblinks.weblink','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_weblinks.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category') 
  AND c.core_access IN (0,1,2,3,6)

  GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, name, author_email

  ORDER BY MAX(`c`.`core_title`) ASC 
  LIMIT 20

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	idx_tag_type,idx_core_content_id	idx_tag_type	4	const	3	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	c	eq_ref	PRIMARY,tag_idx,idx_access,idx_content_type	PRIMARY	4	elzenzo_2.m.core_content_id	1	61.11	Using where
1	SIMPLE	ct	ref	idx_alias	idx_alias	402	elzenzo_2.m.type_alias	1	100.00	Using where
1	SIMPLE	tc	eq_ref	PRIMARY	PRIMARY	4	elzenzo_2.c.core_catid	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	elzenzo_2.c.core_created_user_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
13	JModelList->getItems()	JROOT/components/com_tags/models/tag.php:86
12	TagsModelTag->getItems()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_tags/views/tag/view.html.php:51
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:265
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.39 ms After last query: 5.53 ms Query memory: 0.010 MB Memory before query: 5.750 MB Rows returned: 30

SHOW FULL COLUMNS 
  FROM `jos_tags`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
15	JTable->__construct()	JROOT/administrator/components/com_tags/tables/tag.php:29
14	TagsTableTag->__construct()	JROOT/libraries/joomla/table/table.php:311
13	JTable::getInstance()	JROOT/components/com_tags/models/tag.php:271
12	TagsModelTag->getItem()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_tags/views/tag/view.html.php:52
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:265
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.43 ms After last query: 3.08 ms Query memory: 0.007 MB Memory before query: 5.856 MB Rows returned: 1

Duplicate queries: #20

SELECT *

  FROM jos_tags

  WHERE `id` = '14'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
13	JTable->load()	JROOT/components/com_tags/models/tag.php:280
12	TagsModelTag->getItem()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_tags/views/tag/view.html.php:52
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:265
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.32 ms After last query: 3.03 ms Query memory: 0.007 MB Memory before query: 5.959 MB Rows returned: 0

SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
  CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
  CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email

  FROM jos_contentitem_tag_map AS m

  INNER JOIN jos_ucm_content AS c 
  ON m.type_alias = c.core_type_alias 
  AND m.core_content_id = c.core_content_id 
  AND c.core_state IN (1) 
  AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2024-10-26 00:01:07')  
  AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2024-10-26 00:01:07')

  INNER JOIN jos_content_types AS ct 
  ON ct.type_alias = m.type_alias

  LEFT JOIN jos_categories AS tc 
  ON tc.id = c.core_catid

  LEFT JOIN jos_users AS ua 
  ON ua.id = c.core_created_user_id

  WHERE m.tag_id IN (14) 
  AND (c.core_catid = 0 OR tc.published = 1) 
  AND m.type_alias IN ('com_content.article','com_weblinks.weblink','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_weblinks.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category') 
  AND c.core_access IN (0,1,2,3,6)

  GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, name, author_email

  ORDER BY MAX(`c`.`core_title`) ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	idx_tag_type,idx_core_content_id	idx_tag_type	4	const	3	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	c	eq_ref	PRIMARY,tag_idx,idx_access,idx_content_type	PRIMARY	4	elzenzo_2.m.core_content_id	1	61.11	Using where
1	SIMPLE	ct	ref	idx_alias	idx_alias	402	elzenzo_2.m.type_alias	1	100.00	Using where
1	SIMPLE	tc	eq_ref	PRIMARY	PRIMARY	4	elzenzo_2.c.core_catid	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	elzenzo_2.c.core_created_user_id	1	100.00	Using where

Profile

Status	Duration
Starting	0.15 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.63 ms
checking permissions	0.02 ms
Opening tables	0.12 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
Waiting for query cache lock	0.08 ms
init	0.37 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
Storing result in query cache	0.42 ms
Optimizing	0.15 ms
Statistics	0.40 ms
Preparing	0.14 ms
Creating tmp table	0.18 ms
Sorting result	0.04 ms
Executing	0.01 ms
Sending data	0.67 ms
Creating sort index	0.10 ms
Removing tmp table	0.13 ms
Creating sort index	0.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.16 ms
Updating status	0.07 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/legacy/model/legacy.php:347
14	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:281
13	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:231
12	JModelList->getPagination()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_tags/views/tag/view.html.php:55
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:265
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.55 ms After last query: 0.90 ms Query memory: 0.007 MB Memory before query: 5.966 MB Rows returned: 1

Duplicate queries: #18

SELECT *

  FROM jos_tags

  WHERE `id` = '14'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
12	JTable->load()	JROOT/components/com_tags/models/tag.php:335
11	TagsModelTag->hit()	JROOT/components/com_tags/views/tag/view.html.php:198
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:265
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: 10.86 ms After last query: 0.39 ms Query memory: 0.006 MB Memory before query: 5.973 MB

UPDATE jos_tags

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

  WHERE `id` = '14'

Explain

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

Profile

Status	Duration
Starting	0.27 ms
checking permissions	0.03 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init for update	0.10 ms
Updating	0.18 ms
End of update loop	0.02 ms
Waiting for query cache lock	0.01 ms
End of update loop	8.27 ms
Query end	0.05 ms
Commit	1.23 ms
Query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.26 ms
Updating status	0.07 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1240
12	JTable->hit()	JROOT/components/com_tags/models/tag.php:336
11	TagsModelTag->hit()	JROOT/components/com_tags/views/tag/view.html.php:198
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:265
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.67 ms After last query: 26.58 ms Query memory: 0.011 MB Memory before query: 6.576 MB Rows returned: 37

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `jos_assets`

  WHERE `name` IN ('com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jckman','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR `parent_id` = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_assets	index_merge	idx_asset_name,idx_parent_id	idx_asset_name,idx_parent_id	202,4	NULL	38	100.00	Using sort_union(idx_asset_name,idx_parent_id); Using where

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
20	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
19	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
18	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
17	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
16	JUser->authorise()	JROOT/components/com_tags/views/tag/tmpl/default_items.php:22
15	include JROOT/components/com_tags/views/tag/tmpl/default_items.php	JROOT/libraries/legacy/view/legacy.php:694
14	JViewLegacy->loadTemplate()	JROOT/components/com_tags/views/tag/tmpl/default.php:51
13	include JROOT/components/com_tags/views/tag/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_tags/views/tag/view.html.php:202
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:265
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.55 ms After last query: 18.88 ms Query memory: 0.007 MB Memory before query: 6.884 MB Rows returned: 2

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

  FROM jos_modules AS m

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

  LEFT JOIN jos_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-10-26 00:01:07') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-26 00:01:07') 
  AND m.access IN (1,1,2,3,6) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mm	index	PRIMARY	PRIMARY	8	NULL	22	100.00	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	m	eq_ref	PRIMARY,published,newsfeeds	PRIMARY	4	elzenzo_2.mm.moduleid	1	83.33	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	elzenzo_2.m.module,const	1	100.00	Using index condition; Using where

Profile

Status	Duration
Starting	0.28 ms
Waiting for query cache lock	0.02 ms
starting	0.01 ms
Checking query cache for query	0.29 ms
checking permissions	0.02 ms
Opening tables	0.08 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
Waiting for query cache lock	0.06 ms
init	0.13 ms
Optimizing	0.12 ms
Statistics	0.28 ms
Preparing	0.15 ms
Creating tmp table	0.17 ms
Sorting result	0.04 ms
Executing	0.02 ms
Sending data	0.81 ms
Creating sort index	0.10 ms
Removing tmp table	0.14 ms
Creating sort index	0.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.24 ms
Updating status	0.03 ms
Waiting for query cache lock	0.01 ms
Updating status	0.04 ms
Waiting for query cache lock	0.02 ms
Updating status	0.01 ms
Storing result in query cache	0.23 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:169
12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
10	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
9	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
8	JDocumentHtml->countModules()	JROOT/templates/protostar/index.php:95
7	require JROOT/templates/protostar/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

20 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

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

2 × SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
  CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
  CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email 
  FROM jos_contentitem_tag_map AS m 
  INNER JOIN jos_ucm_content AS c 
  ON m.type_alias = c.core_type_alias 
  AND m.core_content_id = c.core_content_id 
  AND c.core_state IN (1) 
  AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2024-10-26 00:01:07')  
  AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2024-10-26 00:01:07') 
  INNER JOIN jos_content_types AS ct 
  ON ct.type_alias = m.type_alias 
  LEFT JOIN jos_categories AS tc 
  ON tc.id = c.core_catid 
  LEFT JOIN jos_users AS ua 
  ON ua.id = c.core_created_user_id

```
2 × SELECT * 
  FROM jos_tags
```

1 × SELECT `data` 
  FROM `jos_session`

1 × SELECT `session_id` 
  FROM `jos_session`

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

1 × SELECT id, rules 
  FROM `jos_viewlevels

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
  FROM jos_extensions

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

```
1 × SELECT id 
  FROM `jos_tags`
```
```
1 × SELECT * 
  FROM jos_languages
```

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

1 × SELECT * 
  FROM `jos_content_types

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `jos_assets`

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

OTHER Tables:

```
1 × DELETE  
  FROM `jos_session`
```

1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('f52efc526e90e1bb653a9779a939dfba', 1, '1729900867', 0, '', 0

1 × UPDATE `jos_extensions` 
  SET `params` = '{\"mediaversion\":\"df2d197a8e66715e1192847603741d23\"}'

1 × SHOW FULL COLUMNS 
  FROM `jos_tags

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