Home VETERANS East NissouriGregory, Otto Chalmers (Chalmers)

Gregory, Otto Chalmers (Chalmers)

Township: East Nissouri
Rank: Private
Branch: Canadian Over-Seas Expeditionary Force
Regiment number: 802865
Date of birth: April 20, 1894
Where born: Braemar, West Zorra Township, Oxford County, Ontario, Canada
Date of death: August 17, 1916
Burial location: St. Marys Cemetery, St. Marys, Ontario, Canada
Wars Served: World War I
Years of service: June 26, 1916 - August 17, 1916
Country enlisted with: Canada

Biography

Chalmers Gregory was the son of Arthur and Louisa (nee Craig) Gregory. He was born near Braemar in East Zorra Township, then the family moved to East Nissouri Township. Later they moved north into Perth County and the Granton area. Chalmers enlisted with the Army on January 21, 1916. His Attestation Paper states he was an unmarried farmer and a member of the Methodist faith. He was with the 135th Unit, Overseas Battalion. The Biddulph History Book mentions that he contracted pneumonia during the course of his service. It would appear that the Army was able to send him home as he is listed as having passed away at the Military Base Hospital in Toronto at the age of 22. He was buried in the St. Marys Cemetery, St. Marys, Ontario.

Happy Family Day from the Heroes of Zorra Project. #familyday2020 https://t.co/5RCZ9id7Im

by Heroes of Zorra

Did you know? Donald Carey lied about his age when he enlisted in 1943. He turned 18 en route to England. Discover… https://t.co/Ah3NjFCPTy

by Heroes of Zorra

Did you know? David Fletcher served as a cook on the HMCS Saguenay in 1966-67. Discover more at… https://t.co/BEslBvsjn0

by Heroes of Zorra

Did you know? Harold Hogg joined the Royal Canadian Air Force in 1944. Discover more at https://t.co/tWTZgE21jE #canadianmilitaryhistory

by Heroes of Zorra

DON'T FORGET TO CHECK BACK OFTEN!
WE'RE CONSTANTLY ADDING NEW INFORMATION.

Joomla! Debug Console

Session

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

Profile Information

Time

Memory

Time: 33.66 ms / 33.66 ms Memory: 1.735 MB / 2.11 MB Application: afterLoad

Time: 122.20 ms / 155.86 ms Memory: 4.906 MB / 7.01 MB Application: afterInitialise

Time: 48.79 ms / 204.65 ms Memory: 1.595 MB / 8.61 MB Application: afterRoute

Time: 2.69 ms / 207.34 ms Memory: 0.081 MB / 8.69 MB Application: beforeRenderComponent com_zoo

Time: 16.16 ms / 223.50 ms Memory: 0.484 MB / 9.17 MB Application: Before Access::preloadComponents (all components)

Time: 1.86 ms / 225.36 ms Memory: 0.062 MB / 9.24 MB Application: After Access::preloadComponents (all components)

Time: 0.06 ms / 225.42 ms Memory: 0.000 MB / 9.23 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 1.05 ms / 226.47 ms Memory: 0.033 MB / 9.27 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 25.14 ms / 251.61 ms Memory: 1.321 MB / 10.59 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.05 ms / 251.66 ms Memory: 0.002 MB / 10.59 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 42.27 ms / 293.92 ms Memory: 2.315 MB / 12.90 MB Application: afterRenderComponent com_zoo

Time: 27.68 ms / 321.60 ms Memory: 0.829 MB / 13.73 MB Application: afterDispatch

Time: 18.51 ms / 340.11 ms Memory: 0.508 MB / 14.24 MB Application: beforeRenderModule mod_custom (Logo)

Time: 18.27 ms / 358.37 ms Memory: 0.632 MB / 14.87 MB Application: afterRenderModule mod_custom (Logo)

Time: 1.28 ms / 359.65 ms Memory: 0.002 MB / 14.88 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 18.61 ms / 378.26 ms Memory: 0.203 MB / 15.08 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 10.83 ms / 389.09 ms Memory: 0.127 MB / 15.21 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 2.06 ms / 391.15 ms Memory: 0.021 MB / 15.23 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 1.68 ms / 392.83 ms Memory: 0.000 MB / 15.22 MB Application: beforeRenderModule mod_custom (Media)

Time: 1.36 ms / 394.19 ms Memory: 0.002 MB / 15.22 MB Application: afterRenderModule mod_custom (Media)

Time: 0.09 ms / 394.28 ms Memory: 0.002 MB / 15.23 MB Application: beforeRenderModule mod_search (Find a Veteran)

Time: 2.26 ms / 396.55 ms Memory: 0.018 MB / 15.24 MB Application: afterRenderModule mod_search (Find a Veteran)

Time: 0.08 ms / 396.63 ms Memory: 0.000 MB / 15.24 MB Application: beforeRenderModule mod_custom (Disclaimer)

Time: 1.30 ms / 397.93 ms Memory: 0.002 MB / 15.24 MB Application: afterRenderModule mod_custom (Disclaimer)

Time: 0.08 ms / 398.01 ms Memory: 0.002 MB / 15.25 MB Application: beforeRenderModule mod_zooitem (Recently Added)

Time: 81.21 ms / 479.22 ms Memory: 0.412 MB / 15.66 MB Application: afterRenderModule mod_zooitem (Recently Added)

Time: 4.20 ms / 483.43 ms Memory: 0.000 MB / 15.64 MB Application: beforeRenderModule mod_widgetkit_twitter (Twitter Bubbles)

Time: 2.77 ms / 486.20 ms Memory: 0.011 MB / 15.65 MB Application: afterRenderModule mod_widgetkit_twitter (Twitter Bubbles)

Time: 0.09 ms / 486.28 ms Memory: 0.000 MB / 15.65 MB Application: beforeRenderModule mod_custom (Home Solar)

Time: 1.47 ms / 487.75 ms Memory: 0.002 MB / 15.65 MB Application: afterRenderModule mod_custom (Home Solar)

Time: 2.48 ms / 490.23 ms Memory: 0.002 MB / 15.65 MB Application: beforeRenderModule mod_menu (Footer Menu)

Time: 3.36 ms / 493.58 ms Memory: 0.015 MB / 15.67 MB Application: afterRenderModule mod_menu (Footer Menu)

Time: 0.08 ms / 493.66 ms Memory: 0.000 MB / 15.66 MB Application: beforeRenderModule mod_custom (Footer)

Time: 1.33 ms / 494.99 ms Memory: 0.005 MB / 15.67 MB Application: afterRenderModule mod_custom (Footer)

Time: 9.77 ms / 504.76 ms Memory: 0.138 MB / 15.81 MB Application: afterRender

Database queries total: 81.85 ms

Memory Usage

Database Queries

28 Queries Logged 81.85 ms

Query Time: 0.58 ms Query memory: 0.025 MB Memory before query: 3.860 MB Rows returned: 0

SELECT `data`

  FROM `hoza1_session`

  WHERE `session_id` = '02f07de63f64fb042235661e08b4b91c'

Explain

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

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
executing	0.02 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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.45 ms After last query: 2.97 ms Query memory: 0.022 MB Memory before query: 3.963 MB Rows returned: 0

SELECT `session_id`

  FROM `hoza1_session`

  WHERE `session_id` = '02f07de63f64fb042235661e08b4b91c' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.04 ms
executing	0.02 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
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 2.07 ms After last query: 0.18 ms Query memory: 0.004 MB Memory before query: 3.968 MB

INSERT INTO `hoza1_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('02f07de63f64fb042235661e08b4b91c', 1, 1581980857, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `hoza1_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('02f07de63f64fb042235661e08b4b91c', 1, 1581980857, 0, '', 0)

Profile

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

Call Stack

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

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

Query Time: 1.08 ms After last query: 6.24 ms Query memory: 0.042 MB Memory before query: 4.179 MB Rows returned: 42

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

  FROM `hoza1_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hoza1_extensions	ref	extension	extension	82	const	42	100.00	Using index condition; Using where

Profile

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

Call Stack

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

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

Query Time: 0.49 ms After last query: 5.04 ms Query memory: 0.022 MB Memory before query: 4.392 MB Rows returned: 3

SELECT id, rules

  FROM `hoza1_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.02 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.06 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
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.57 ms After last query: 0.17 ms Query memory: 0.022 MB Memory before query: 4.403 MB Rows returned: 1

SELECT b.id

  FROM hoza1_usergroups AS a

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

  WHERE a.id = 1

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	NULL
1	SIMPLE	b	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	8	25.00	Using where; Using index

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.02 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/database/driver.php:1544
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.94 ms After last query: 1.44 ms Query memory: 0.089 MB Memory before query: 4.470 MB Rows returned: 101

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

  FROM hoza1_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hoza1_extensions	ref	extension	extension	82	const	124	100.00	Using index condition; Using where; Using filesort

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.03 ms
statistics	0.07 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	1.37 ms
end	0.02 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/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.60 ms After last query: 21.14 ms Query memory: 0.022 MB Memory before query: 5.491 MB Rows returned: 1

SELECT `enabled`

  FROM `hoza1_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hoza1_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.06 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.11 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.06 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
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:36
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.13 ms After last query: 45.87 ms Query memory: 0.069 MB Memory before query: 7.196 MB Rows returned: 53

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

  LEFT JOIN hoza1_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	110	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	heroesofzorra.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.06 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
Creating sort index	1.45 ms
end	0.02 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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.72 ms After last query: 26.43 ms Query memory: 0.024 MB Memory before query: 8.259 MB Rows returned: 1

SELECT id 
  FROM hoza1_zoo_item 
  WHERE alias = 'gregory-otto-chalmers' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hoza1_zoo_item	const	ALIAS_INDEX	ALIAS_INDEX	767	const	1	100.00	NULL

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.14 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.02 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:87
12	DatabaseHelper->queryResult()	JROOT/administrator/components/com_zoo/helpers/alias.php:119
11	AppAlias->translateAliasToID()	JROOT/components/com_zoo/router.php:257
10	ZooParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.73 ms After last query: 5.98 ms Query memory: 0.027 MB Memory before query: 8.415 MB Rows returned: 1

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

  FROM `hoza1_extensions`

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

Explain

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

Profile

Status	Duration
starting	0.08 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.13 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.02 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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jcktypography/jcktypography.php:48
8	plgSystemJCKtypography->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.14 ms After last query: 0.32 ms Query memory: 0.006 MB Memory before query: 8.408 MB

UPDATE `hoza1_extensions`

  SET `params` = '{\"mediaversion\":\"3d790b2d74ebb7a9c67777a77efc3558\"}'

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

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.10 ms
updating	0.09 ms
end	0.02 ms
query end	1.63 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jcktypography/jcktypography.php:48
8	plgSystemJCKtypography->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.63 ms After last query: 5.85 ms Query memory: 0.025 MB Memory before query: 8.674 MB Rows returned: 1

SELECT *

  FROM hoza1_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	hoza1_languages	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.02 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.02 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.09 ms
end	0.02 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
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.78 ms After last query: 0.50 ms Query memory: 0.022 MB Memory before query: 8.685 MB Rows returned: 6

SELECT id, home, template, s.params

  FROM hoza1_template_styles as s

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

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

Explain

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

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.17 ms
end	0.02 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
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.57 ms After last query: 6.14 ms Query memory: 0.028 MB Memory before query: 8.844 MB Rows returned: 1

SELECT * 
  FROM hoza1_zoo_item 
  WHERE id = 1490

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hoza1_zoo_item	const	PRIMARY,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.05 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.09 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
11	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:397
10	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
9	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
8	AppTable->get()	JROOT/administrator/components/com_zoo/helpers/zoo.php:75
7	ZooHelper->getApplication()	JROOT/components/com_zoo/zoo.php:32
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.49 ms After last query: 0.30 ms Query memory: 0.025 MB Memory before query: 8.870 MB Rows returned: 1

SELECT * 
  FROM hoza1_zoo_application 
  WHERE id = 2

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
12	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:397
11	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
10	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
9	AppTable->get()	JROOT/administrator/components/com_zoo/classes/item.php:248
8	Item->getApplication()	JROOT/administrator/components/com_zoo/helpers/zoo.php:76
7	ZooHelper->getApplication()	JROOT/components/com_zoo/zoo.php:32
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.39 ms After last query: 9.28 ms Query memory: 0.031 MB Memory before query: 9.182 MB Rows returned: 40

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

  FROM `hoza1_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_breezingforms','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_widgetkit','com_wrapper','com_zoo')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hoza1_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	122	34.43	Using where

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.11 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.29 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.50 ms
end	0.02 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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
17	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
16	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
15	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
14	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
13	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:222
12	UserAppHelper->isJoomlaSuperAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:54
11	UserAppHelper->get()	JROOT/components/com_zoo/controllers/default.php:106
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:163
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.82 ms After last query: 7.69 ms Query memory: 0.029 MB Memory before query: 9.505 MB Rows returned: 4

SELECT * 
  FROM hoza1_zoo_category 
  WHERE application_id = 2 
  AND published = 1 
  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hoza1_zoo_category	ref	PUBLISHED_INDEX,APPLICATIONID_ID_INDEX	PUBLISHED_INDEX	1	const	4	100.00	Using where; Using filesort

Profile

Status	Duration
starting	0.06 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.06 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.24 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
19	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
18	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:423
17	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/framework/classes/table.php:192
16	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:165
15	AppTable->all()	JROOT/administrator/components/com_zoo/tables/category.php:221
14	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:294
13	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:318
12	Application->getCategoryTree()	JROOT/administrator/components/com_zoo/helpers/route.php:295
11	RouteHelper->item()	JROOT/components/com_zoo/controllers/default.php:131
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:163
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.54 ms After last query: 1.27 ms Query memory: 0.006 MB Memory before query: 9.533 MB

UPDATE hoza1_zoo_item 
  SET hits = (hits + 1) 
  WHERE id = 1490

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hoza1_zoo_item	range	PRIMARY,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	const	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
13	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:180
12	ItemTable->hit()	JROOT/administrator/components/com_zoo/classes/item.php:582
11	Item->hit()	JROOT/components/com_zoo/controllers/default.php:160
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:163
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.43 ms After last query: 0.15 ms Query memory: 0.024 MB Memory before query: 9.540 MB Rows returned: 1

SELECT id 
  FROM hoza1_users 
  WHERE id = 266

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:87
13	DatabaseHelper->queryResult()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:44
12	UserAppHelper->get()	JROOT/administrator/components/com_zoo/classes/item.php:280
11	Item->getAuthor()	JROOT/components/com_zoo/controllers/default.php:173
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:163
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.56 ms After last query: 4.84 ms Query memory: 0.033 MB Memory before query: 9.748 MB Rows returned: 16

SHOW FULL COLUMNS 
  FROM `hoza1_users`

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.43 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.03 ms
checking permissions	0.05 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Sending data	0.15 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.13 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
22	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
21	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:40
20	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
19	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
18	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:880
17	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
16	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
15	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
14	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_zoo/framework/classes/helper.php:69
13	AppHelper->_call()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:51
12	UserAppHelper->get()	JROOT/administrator/components/com_zoo/classes/item.php:280
11	Item->getAuthor()	JROOT/components/com_zoo/controllers/default.php:173
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:163
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.53 ms After last query: 1.26 ms Query memory: 0.031 MB Memory before query: 9.819 MB Rows returned: 1

SELECT *

  FROM `hoza1_users`

  WHERE `id` = 266

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.05 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.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:86
18	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:883
17	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
16	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
15	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
14	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_zoo/framework/classes/helper.php:69
13	AppHelper->_call()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:51
12	UserAppHelper->get()	JROOT/administrator/components/com_zoo/classes/item.php:280
11	Item->getAuthor()	JROOT/components/com_zoo/controllers/default.php:173
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:163
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.58 ms After last query: 5.82 ms Query memory: 0.027 MB Memory before query: 10.569 MB Rows returned: 1

SELECT `g`.`id`,`g`.`title`

  FROM `hoza1_usergroups` AS g

  INNER JOIN `hoza1_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 266

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	heroesofzorra.m.group_id	1	100.00	NULL

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.05 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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
19	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:111
18	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:883
17	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
16	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
15	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
14	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_zoo/framework/classes/helper.php:69
13	AppHelper->_call()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:51
12	UserAppHelper->get()	JROOT/administrator/components/com_zoo/classes/item.php:280
11	Item->getAuthor()	JROOT/components/com_zoo/controllers/default.php:173
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:163
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.59 ms After last query: 0.28 ms Query memory: 0.026 MB Memory before query: 10.577 MB Rows returned: 2

SELECT b.id

  FROM hoza1_user_usergroup_map AS map

  LEFT JOIN hoza1_usergroups AS a 
  ON a.id = map.group_id

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

  WHERE map.user_id = 266

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	map	ref	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	heroesofzorra.map.group_id	1	100.00	NULL
1	SIMPLE	b	ALL	idx_usergroup_nested_set_lookup	NO INDEX KEY COULD BE USED	NULL	NULL	8	100.00	Range checked for each record (index map: 0x10)

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.06 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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
17	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
16	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/User/User.php:480
15	Joomla\CMS\User\User->getAuthorisedGroups()	JROOT/libraries/src/User/User.php:386
14	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:222
13	UserAppHelper->isJoomlaSuperAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:54
12	UserAppHelper->get()	JROOT/administrator/components/com_zoo/classes/item.php:280
11	Item->getAuthor()	JROOT/components/com_zoo/controllers/default.php:173
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:163
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.70 ms After last query: 44.33 ms Query memory: 0.024 MB Memory before query: 12.956 MB Rows returned: 2

SELECT params 
  FROM hoza1_extensions AS e 
  WHERE e.element='com_widgetkit'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	402	const	2	100.00	Using index condition

Profile

Status	Duration
starting	0.08 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.10 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.09 ms
end	0.02 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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_widgetkit/helpers/system.php:254
13	SystemWidgetkitHelper->_getParams()	JROOT/administrator/components/com_widgetkit/helpers/system.php:54
12	SystemWidgetkitHelper->__construct()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129
11	Widgetkit->loadHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76
10	Widgetkit->getHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137
9	Widgetkit->offsetGet()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
8	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
7	plgSystemWidgetkit_System->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.99 ms After last query: 36.19 ms Query memory: 0.031 MB Memory before query: 14.174 MB Rows returned: 12

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

  FROM hoza1_modules AS m

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

  LEFT JOIN hoza1_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 <= '2020-02-17 23:07:37') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-02-17 23:07:37') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 220 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	m	ref	PRIMARY,published,newsfeeds	published	1	const	62	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	heroesofzorra.m.id	1	100.00	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	heroesofzorra.m.module,const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.16 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.08 ms
System lock	0.02 ms
optimizing	0.05 ms
statistics	0.15 ms
preparing	0.07 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	1.02 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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/yoo_solar/warp/systems/joomla/helpers/modules.php:49
11	ModulesWarpHelper->count()	JROOT/templates/yoo_solar/layouts/template.config.php:29
10	include JROOT/templates/yoo_solar/layouts/template.config.php	JROOT/templates/yoo_solar/layouts/template.php:10
9	include JROOT/templates/yoo_solar/layouts/template.php	JROOT/templates/yoo_solar/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_solar/index.php:19
7	require JROOT/templates/yoo_solar/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.04 ms After last query: 20.36 ms Query memory: 0.042 MB Memory before query: 14.831 MB Rows returned: 0

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM hoza1_fields AS a

  LEFT JOIN `hoza1_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN hoza1_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN hoza1_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN hoza1_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN hoza1_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	heroesofzorra.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	heroesofzorra.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	heroesofzorra.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	heroesofzorra.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	heroesofzorra.a.group_id	1	100.00	Using where

Profile

Status	Duration
starting	0.16 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
Opening tables	0.06 ms
init	0.09 ms
System lock	0.03 ms
optimizing	0.04 ms
statistics	0.13 ms
preparing	0.06 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.05 ms
Creating sort index	0.06 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
27	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
26	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
25	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
24	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
23	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
22	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
21	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
20	JHtmlContent::prepare()	Same as call in the line below.
19	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
18	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
17	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
16	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_solar/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_solar/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_solar/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_solar/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_solar/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_solar/layouts/template.php:62
9	include JROOT/templates/yoo_solar/layouts/template.php	JROOT/templates/yoo_solar/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_solar/index.php:19
7	require JROOT/templates/yoo_solar/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 55.71 ms After last query: 43.20 ms Query memory: 0.048 MB Memory before query: 15.289 MB Rows returned: 10

SELECT a.* 
  FROM hoza1_zoo_item AS a 
  LEFT JOIN hoza1_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  IN (8,68,11,3) 
  AND access IN (1) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-02-17 23:07:37') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-02-17 23:07:37') 
  GROUP BY a.id 
  ORDER BY a.priority DESC, a.created DESC 
  LIMIT 0,10

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	MULTI_INDEX	9	const,const,const	11	100.00	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	heroesofzorra.a.id	1	100.00	Using where

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.08 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.22 ms
preparing	0.06 ms
Creating tmp table	0.07 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	50.33 ms
Creating sort index	4.02 ms
end	0.02 ms
removing tmp table	0.31 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.14 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
20	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:423
19	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/tables/item.php:470
18	ItemTable->getByCategory()	JROOT/administrator/components/com_zoo/helpers/module.php:125
17	ModuleHelper->getItems()	JROOT/modules/mod_zooitem/mod_zooitem.php:29
16	include JROOT/modules/mod_zooitem/mod_zooitem.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_solar/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_solar/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_solar/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_solar/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_solar/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_solar/layouts/template.php:125
9	include JROOT/templates/yoo_solar/layouts/template.php	JROOT/templates/yoo_solar/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_solar/index.php:19
7	require JROOT/templates/yoo_solar/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

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

1 × SELECT `data` 
  FROM `hoza1_session`

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

1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM hoza1_fields AS a 
  LEFT JOIN `hoza1_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN hoza1_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN hoza1_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN hoza1_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN hoza1_fields_groups AS g 
  ON g.id = a.group_id

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

1 × SELECT params 
  FROM hoza1_extensions AS e

1 × SELECT b.id 
  FROM hoza1_user_usergroup_map AS map 
  LEFT JOIN hoza1_usergroups AS a 
  ON a.id = map.group_id 
  LEFT JOIN hoza1_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `hoza1_usergroups` AS g 
  INNER JOIN `hoza1_user_usergroup_map` AS m 
  ON m.group_id = g.id

```
1 × SELECT * 
  FROM `hoza1_users`
```
```
1 × SELECT id 
  FROM hoza1_users
```

1 × SELECT * 
  FROM hoza1_zoo_category

```
1 × SELECT * 
  FROM hoza1_zoo_item
```

1 × SELECT * 
  FROM hoza1_zoo_application

1 × SELECT `session_id` 
  FROM `hoza1_session`

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

```
1 × SELECT * 
  FROM hoza1_languages
```
```
1 × SELECT id 
  FROM hoza1_zoo_item
```

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

1 × SELECT `enabled` 
  FROM `hoza1_extensions`

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

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

1 × SELECT id, rules 
  FROM `hoza1_viewlevels

1 × SELECT a.* 
  FROM hoza1_zoo_item AS a 
  LEFT JOIN hoza1_zoo_category_item AS b 
  ON a.id = b.item_id

OTHER Tables:

1 × INSERT INTO `hoza1_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('02f07de63f64fb042235661e08b4b91c', 1, 1581980857, 0, '', 0

1 × UPDATE `hoza1_extensions` 
  SET `params` = '{\"mediaversion\":\"3d790b2d74ebb7a9c67777a77efc3558\"}'

1 × UPDATE hoza1_zoo_item 
  SET hits = (hits + 1)

1 × SHOW FULL COLUMNS 
  FROM `hoza1_users

Gregory, Otto Chalmers (Chalmers)

Biography

DON'T FORGET TO CHECK BACK OFTEN!WE'RE CONSTANTLY ADDING NEW INFORMATION.

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

28 Queries Logged 81.85 ms

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

DON'T FORGET TO CHECK BACK OFTEN!
WE'RE CONSTANTLY ADDING NEW INFORMATION.