Ministry of Foreign Affairs & External Trade - Ministry of Foreign Affairs & External Trade

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1784512820,
                "last": 1784512820,
                "now": 1784512821
            },
            "token": "pVsOuT8Xmq04WLwyk2q594XZtawS5NEh"
        },
        "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
        },
        "a1899967864c1260cba33ddc592cd4bc": 1784512821,
        "com_contactenhanced": {
            "isekeywords": {
                "referer": "http://www.mfaet.gov.sb/component/contactenhanced/4.html",
                "searchEngine": {
                    "engine": "",
                    "searchPhrase": false
                },
                "all_keywords": [
                    ""
                ],
                "filter_keywords": [
                    ""
                ],
                "params": {
                    "load-instructions": "0",
                    "enable-highlight": "0",
                    "integrate-ce": "1",
                    "exclude": "a,e,i,o,u,an,the,for,is,in,are,was,and,from,of,on,with,this,that,or,these,those"
                },
                "queryString": "",
                "excludes": [
                    "a",
                    "e",
                    "i",
                    "o",
                    "u",
                    "an",
                    "the",
                    "for",
                    "is",
                    "in",
                    "are",
                    "was",
                    "and",
                    "from",
                    "of",
                    "on",
                    "with",
                    "this",
                    "that",
                    "or",
                    "these",
                    "those",
                    "us",
                    "be",
                    "have",
                    "not",
                    "he",
                    "as",
                    "do",
                    "you",
                    "he",
                    "she",
                    "we",
                    "me",
                    "will",
                    "my",
                    "a",
                    "e",
                    "i",
                    "o",
                    "u",
                    "an",
                    "the",
                    "for",
                    "is",
                    "in",
                    "are",
                    "was",
                    "and",
                    "from",
                    "of",
                    "on",
                    "with",
                    "this",
                    "that",
                    "or",
                    "these",
                    "those",
                    " ",
                    ".",
                    ",",
                    ";",
                    "!",
                    "?",
                    "|",
                    "\\",
                    "\"",
                    "/",
                    "<",
                    ">",
                    "^",
                    "~",
                    "`",
                    "[",
                    "]",
                    "{",
                    "}",
                    "=",
                    "+",
                    "-",
                    "_",
                    "(",
                    ")",
                    "@",
                    "#",
                    "$",
                    "%",
                    "&",
                    "*"
                ]
            }
        }
    }
}

Profile Information

Time

Memory

Time: 2.56 ms / 2.56 ms Memory: 0.333 MB / 0.68 MB Application: afterLoad

Time: 30.47 ms / 33.03 ms Memory: 1.618 MB / 2.30 MB Application: afterInitialise

Time: 7.02 ms / 40.05 ms Memory: 0.287 MB / 2.59 MB Application: Before Access::preloadComponents (all components)

Time: 0.46 ms / 40.51 ms Memory: 0.058 MB / 2.64 MB Application: After Access::preloadComponents (all components)

Time: 0.01 ms / 40.53 ms Memory: -0.001 MB / 2.64 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.18 ms / 40.71 ms Memory: 0.007 MB / 2.65 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 0.35 ms / 41.06 ms Memory: 0.003 MB / 2.65 MB Application: afterRoute

Time: 0.39 ms / 41.45 ms Memory: 0.036 MB / 2.69 MB Application: beforeRenderComponent com_contactenhanced

Time: 2.65 ms / 44.10 ms Memory: 0.332 MB / 3.02 MB Application: Before Access::getAssetRules (id:121 name:com_contactenhanced)

Time: 0.01 ms / 44.12 ms Memory: 0.002 MB / 3.02 MB Application: After Access::getAssetRules (id:121 name:com_contactenhanced)

Time: 9.15 ms / 53.26 ms Memory: 0.379 MB / 3.40 MB Application: Before Access::preloadPermissions (com_contactenhanced)

Time: 0.60 ms / 53.86 ms Memory: 0.018 MB / 3.42 MB Application: After Access::preloadPermissions (com_contactenhanced)

Time: 0.03 ms / 53.89 ms Memory: 0.000 MB / 3.42 MB Application: Before Access::getAssetRules (id:189 name:com_contactenhanced.category.54)

Time: 0.01 ms / 53.90 ms Memory: 0.001 MB / 3.42 MB Application: After Access::getAssetRules (id:189 name:com_contactenhanced.category.54)

Time: 6.02 ms / 59.92 ms Memory: 1.303 MB / 4.72 MB Application: afterRenderComponent com_contactenhanced

Time: 1.70 ms / 61.62 ms Memory: 0.057 MB / 4.78 MB Application: afterDispatch

Time: 7.75 ms / 69.37 ms Memory: 0.870 MB / 5.65 MB Application: beforeRenderModule mod_menu (Header Menu)

Time: 0.73 ms / 70.10 ms Memory: 0.033 MB / 5.68 MB Application: afterRenderModule mod_menu (Header Menu)

Time: 5.03 ms / 75.13 ms Memory: 0.768 MB / 6.45 MB Application: beforeRenderModule mod_acymailing (Newsletter)

Time: 2.13 ms / 77.26 ms Memory: 0.470 MB / 6.92 MB Application: afterRenderModule mod_acymailing (Newsletter)

Time: 0.32 ms / 77.58 ms Memory: -0.003 MB / 6.92 MB Application: beforeRenderModule mod_search (Search)

Time: 0.36 ms / 77.94 ms Memory: 0.014 MB / 6.93 MB Application: afterRenderModule mod_search (Search)

Time: 1.65 ms / 79.59 ms Memory: 0.037 MB / 6.97 MB Application: beforeRenderModule mod_search (Search)

Time: 0.19 ms / 79.77 ms Memory: 0.006 MB / 6.98 MB Application: afterRenderModule mod_search (Search)

Time: 0.43 ms / 80.20 ms Memory: -0.079 MB / 6.90 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.29 ms / 80.49 ms Memory: 0.024 MB / 6.92 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 1.73 ms / 82.21 ms Memory: 0.027 MB / 6.95 MB Application: beforeRenderModule mod_menu (Quick Links)

Time: 0.51 ms / 82.72 ms Memory: 0.024 MB / 6.97 MB Application: afterRenderModule mod_menu (Quick Links)

Time: 0.12 ms / 82.84 ms Memory: -0.001 MB / 6.97 MB Application: beforeRenderModule mod_menu (About the Website)

Time: 0.36 ms / 83.20 ms Memory: 0.033 MB / 7.00 MB Application: afterRenderModule mod_menu (About the Website)

Time: 0.08 ms / 83.28 ms Memory: -0.002 MB / 7.00 MB Application: beforeRenderModule mod_custom (Contact Details)

Time: 0.19 ms / 83.46 ms Memory: 0.006 MB / 7.01 MB Application: afterRenderModule mod_custom (Contact Details)

Time: 0.57 ms / 84.03 ms Memory: 0.012 MB / 7.02 MB Application: beforeRenderModule mod_search (Search)

Time: 0.16 ms / 84.20 ms Memory: 0.007 MB / 7.03 MB Application: afterRenderModule mod_search (Search)

Time: 214.64 ms / 298.84 ms Memory: 15.199 MB / 22.23 MB Application: afterRender

Database queries total: 17.97 ms

Memory Usage

Database Queries

53 Queries Logged 17.97 ms

6 duplicate found!

2 duplicates: #8 #9

2 duplicates: #19 #21

2 duplicates: #42 #48

Query Time: 0.17 ms Query memory: 0.020 MB Memory before query: 0.762 MB Rows returned: 1

SELECT `session_id`

  FROM `p6im7_session`

  WHERE `session_id` = X'6331313537343431343238643832393435383963636330613933393566393236' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.04 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.00 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
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.31 ms After last query: 0.47 ms Query memory: 0.076 MB Memory before query: 0.792 MB Rows returned: 47

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

  FROM `p6im7_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p6im7_extensions	NULL	ref	extension	extension	82	const	48	1.00	Using where

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.16 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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:225
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.12 ms After last query: 0.48 ms Query memory: 0.020 MB Memory before query: 0.845 MB Rows returned: 5

SELECT id, rules

  FROM `p6im7_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
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:318
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:225
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.15 ms After last query: 0.06 ms Query memory: 0.020 MB Memory before query: 0.855 MB Rows returned: 2

SELECT b.id

  FROM p6im7_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
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:318
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:225
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.64 ms After last query: 0.11 ms Query memory: 0.040 MB Memory before query: 0.876 MB Rows returned: 244

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

  FROM p6im7_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p6im7_extensions	NULL	ref	extension	extension	82	const	302	0.60	Using where; Using filesort

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.52 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
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:356
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:225
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.13 ms After last query: 2.51 ms Query memory: 0.021 MB Memory before query: 1.278 MB Rows returned: 1

SELECT `value`

  FROM `p6im7_admintools_storage`

  WHERE `key` = 'cparams'

Explain

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

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.00 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:122
12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:37
11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:49
10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:409
9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:892
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
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:667
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:225
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.10 ms After last query: 0.13 ms Query memory: 0.021 MB Memory before query: 1.285 MB Rows returned: 0

SELECT *

  FROM `p6im7_admintools_wafexceptions`

  WHERE NOT(`option` LIKE 'com_%')

Explain

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

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:729
10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:640
9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:901
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
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:667
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:225
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.18 ms After last query: 1.68 ms Query memory: 0.022 MB Memory before query: 1.357 MB Rows returned: 1

Duplicate queries: #9

SELECT template

  FROM p6im7_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	7	12.50	Using where

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
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:667
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:225
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.10 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 1.363 MB Rows returned: 1

Duplicate queries: #8

SELECT template

  FROM p6im7_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	7	12.50	Using where

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
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:667
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:225
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.17 ms After last query: 0.63 ms Query memory: 0.020 MB Memory before query: 1.469 MB Rows returned: 2

SELECT extension, file, type

  FROM p6im7_rokcommon_configs

  ORDER BY priority

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:131
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:75
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
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:667
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:225
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.62 ms After last query: 1.23 ms Query memory: 0.105 MB Memory before query: 1.528 MB Rows returned: 85

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

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

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

  ORDER BY m.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	156	5.83	Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	mfaetadmin_365_j36.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.39 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
22	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
19	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
18	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
17	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
16	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
15	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
14	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:434
13	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Layout/FileLayout.php:604
12	Joomla\CMS\Layout\FileLayout->getDefaultIncludePaths()	JROOT/libraries/src/Layout/FileLayout.php:295
11	Joomla\CMS\Layout\FileLayout->getIncludePaths()	JROOT/libraries/src/Layout/FileLayout.php:144
10	Joomla\CMS\Layout\FileLayout->getPath()	JROOT/libraries/src/Layout/FileLayout.php:111
9	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Toolbar/ToolbarHelper.php:42
8	Joomla\CMS\Toolbar\ToolbarHelper::title()	JROOT/plugins/system/koowa/koowa.php:56
7	PlgSystemKoowa->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
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:667
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:225
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.25 ms After last query: 0.37 ms Query memory: 0.022 MB Memory before query: 1.729 MB Rows returned: 7

SELECT id, home, template, s.params

  FROM p6im7_template_styles as s

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

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	mfaetadmin_365_j36.e.element	4	87.50	Using index condition; Using where

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.06 ms
end	0.00 ms
query end	0.01 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
13	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Layout/FileLayout.php:604
12	Joomla\CMS\Layout\FileLayout->getDefaultIncludePaths()	JROOT/libraries/src/Layout/FileLayout.php:295
11	Joomla\CMS\Layout\FileLayout->getIncludePaths()	JROOT/libraries/src/Layout/FileLayout.php:144
10	Joomla\CMS\Layout\FileLayout->getPath()	JROOT/libraries/src/Layout/FileLayout.php:111
9	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Toolbar/ToolbarHelper.php:42
8	Joomla\CMS\Toolbar\ToolbarHelper::title()	JROOT/plugins/system/koowa/koowa.php:56
7	PlgSystemKoowa->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
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:667
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:225
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.14 ms After last query: 0.21 ms Query memory: 0.023 MB Memory before query: 1.757 MB Rows returned: 1

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

  FROM `p6im7_extensions`

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

Explain

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

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
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/libraries/src/Toolbar/ToolbarHelper.php:46
8	Joomla\CMS\Toolbar\ToolbarHelper::title()	JROOT/plugins/system/koowa/koowa.php:56
7	PlgSystemKoowa->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
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:667
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:225
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.25 ms After last query: 0.09 ms Query memory: 0.006 MB Memory before query: 1.748 MB

UPDATE `p6im7_extensions`

  SET `params` = '{\"mediaversion\":\"17d58aadcf6749e1c807f01d0213a0b9\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `p6im7_extensions` SET `params` = '{\"mediaversion\":\"17d58aadcf6749e1c807f01d0213a0b9\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.03 ms
updating	0.07 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.07 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 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/libraries/src/Toolbar/ToolbarHelper.php:46
8	Joomla\CMS\Toolbar\ToolbarHelper::title()	JROOT/plugins/system/koowa/koowa.php:56
7	PlgSystemKoowa->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
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:667
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:225
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.21 ms After last query: 6.63 ms Query memory: 0.021 MB Memory before query: 2.080 MB Rows returned: 1

SELECT `params`

  FROM `p6im7_extensions`

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

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/libraries/fof40/Params/Params.php:55
12	FOF40\Params\Params->reload()	JROOT/libraries/fof40/Params/Params.php:40
11	FOF40\Params\Params->__construct()	JROOT/libraries/fof40/Container/Container.php:281
10	FOF40\Container\Container->FOF40\Container\{closure}()	JROOT/libraries/fof40/Pimple/Container.php:115
9	FOF40\Pimple\Container->offsetGet()	JROOT/libraries/fof40/Container/ContainerBase.php:27
8	FOF40\Container\ContainerBase->__get()	JROOT/plugins/system/jchoptimize/jchoptimize.php:124
7	plgSystemJchoptimize->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
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:667
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:225
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.10 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 2.099 MB Rows returned: 0

SELECT `source`,`keepurlparams`

  FROM `p6im7_admintools_redirects`

  WHERE ((`dest` = 'component/contactenhanced/4.html') OR (`dest` = 'component/contactenhanced/4.html') OR ('component/contactenhanced/4.html' LIKE `dest`)) 
  AND `published` = '1'

  ORDER BY `ordering` DESC 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
11	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:91
10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
8	plgSystemAdmintools->onAfterInitialise()	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:668
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:225
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.85 ms After last query: 0.35 ms Query memory: 0.022 MB Memory before query: 2.104 MB Rows returned: 18

SHOW FULL COLUMNS 
  FROM `p6im7_extensions`

Explain

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

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.40 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
Creating tmp table	0.03 ms
executing	0.04 ms
checking permissions	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.06 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
11	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
10	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:328
9	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
8	plgSystemRokSprocket->onAfterInitialise()	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:668
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:225
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.13 ms After last query: 0.15 ms Query memory: 0.020 MB Memory before query: 2.131 MB Rows returned: 1

SELECT `extension_id`

  FROM `p6im7_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'

Explain

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

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:46
8	plgSystemRokSprocket->onAfterInitialise()	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:668
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:225
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.07 ms After last query: 0.04 ms Query memory: 0.020 MB Memory before query: 2.137 MB Rows returned: 1

Duplicate queries: #21

SELECT *

  FROM p6im7_extensions

  WHERE `extension_id` = '10002'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
8	plgSystemRokSprocket->onAfterInitialise()	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:668
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:225
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.06 ms After last query: 0.03 ms Query memory: 0.020 MB Memory before query: 2.141 MB Rows returned: 1

SELECT `extension_id`

  FROM `p6im7_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:69
8	plgSystemRokSprocket->onAfterInitialise()	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:668
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:225
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.06 ms After last query: 0.02 ms Query memory: 0.020 MB Memory before query: 2.146 MB Rows returned: 1

Duplicate queries: #19

SELECT *

  FROM p6im7_extensions

  WHERE `extension_id` = '10002'

Explain

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

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
8	plgSystemRokSprocket->onAfterInitialise()	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:668
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:225
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.14 ms After last query: 5.38 ms Query memory: 0.020 MB Memory before query: 2.295 MB Rows returned: 1

SELECT count(1)

  FROM `p6im7_session`

  WHERE `session_id` = '' 
  AND client_id = 1 
  AND guest = 0

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/arktypography/arktypography.php:53
8	plgSystemARKtypography->onAfterInitialise()	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:668
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:225
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.33 ms After last query: 2.51 ms Query memory: 0.022 MB Memory before query: 2.451 MB Rows returned: 9

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `p6im7_categories` AS `c`

  WHERE (c.extension='com_contactenhanced' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1

  ORDER BY c.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	range	cat_idx,idx_access	cat_idx	207	NULL	11	100.00	Using index condition; Using filesort

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.08 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
12	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
11	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_contactenhanced/router.php:8
10	ContactenhancedParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
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:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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:225
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.19 ms After last query: 2.85 ms Query memory: 0.022 MB Memory before query: 2.566 MB Rows returned: 7

SELECT s.id, s.template, s.home, s.title AS long_title, s.params

  FROM p6im7_template_styles AS s

  WHERE s.client_id = 0 
  AND s.template = 'it_365news'

  ORDER BY s.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	const	7	87.50	Using where

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69
14	Gantry\Joomla\StyleHelper::loadStyles()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Assignments.php:63
13	Gantry\Framework\Assignments->loadAssignments()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:301
12	Gantry\Component\Assignments\AbstractAssignments->init()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:99
11	Gantry\Component\Assignments\AbstractAssignments->scores()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:86
10	Gantry\Component\Assignments\AbstractAssignments->select()	JROOT/plugins/system/gantry5/gantry5.php:319
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:112
8	plgSystemGantry5->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:1190
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:225
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.36 ms After last query: 1.31 ms Query memory: 0.022 MB Memory before query: 2.589 MB Rows returned: 46

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

  FROM `p6im7_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_admintools','com_ajax','com_akeeba','com_arkeditor','com_arkmanager','com_arkmedia','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_contactenhanced','com_content','com_contenthistory','com_cpanel','com_edocman','com_fields','com_finder','com_gantry','com_gantry5','com_installer','com_jchoptimize','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_ohanah','com_plugins','com_postinstall','com_privacy','com_redirect','com_roksprocket','com_search','com_tags','com_templates','com_users','com_wrapper')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p6im7_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	48	100.00	Using index condition

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.17 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
13	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
12	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
11	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
10	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
9	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/arkeditoruser/arkeditoruser.php:59
8	PlgSystemArKEditorUser->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:1190
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:225
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.15 ms After last query: 0.32 ms Query memory: 0.075 MB Memory before query: 2.649 MB Rows returned: 1

SELECT params

  FROM `p6im7_extensions`

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

Explain

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

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/arktypography/arktypography.php:127
8	plgSystemARKtypography->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:1190
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:225
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.11 ms After last query: 0.32 ms Query memory: 0.019 MB Memory before query: 2.683 MB Rows returned: 1

SELECT *

  FROM p6im7_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.01 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.00 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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:225
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.32 ms After last query: 2.85 ms Query memory: 0.037 MB Memory before query: 3.027 MB Rows returned: 1

SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias

  FROM p6im7_ce_details AS a

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

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

  WHERE a.id = 4 
  AND (a.published = 1 OR a.published =2)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_contactenhanced/models/contact.php:8
12	ContactenhancedModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contactenhanced/views/contact/view.html.php:8
10	ContactenhancedViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contactenhanced/controller.php:8
8	ContactenhancedController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:8
6	require_once JROOT/components/com_contactenhanced/contactenhanced.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:225
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.14 ms After last query: 0.27 ms Query memory: 0.022 MB Memory before query: 3.073 MB Rows returned: 0

SELECT `t`.`id`

  FROM `p6im7_tags` AS t 

  INNER JOIN `p6im7_contentitem_tag_map` AS m 
  ON `m`.`tag_id` = `t`.`id` 
  AND `m`.`type_alias` = 'com_contactenhanced.contact' 
  AND `m`.`content_item_id` IN ( 4)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	10	10.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY	PRIMARY	4	mfaetadmin_365_j36.m.tag_id	1	100.00	Using index

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Helper/TagsHelper.php:506
13	Joomla\CMS\Helper\TagsHelper->getTagIds()	JROOT/components/com_contactenhanced/models/contact.php:8
12	ContactenhancedModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contactenhanced/views/contact/view.html.php:8
10	ContactenhancedViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contactenhanced/controller.php:8
8	ContactenhancedController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:8
6	require_once JROOT/components/com_contactenhanced/contactenhanced.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:225
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.20 ms After last query: 0.04 ms Query memory: 0.038 MB Memory before query: 3.081 MB Rows returned: 1

SELECT a.*, cc.access as category_access, cc.title as category_name,  
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug

  FROM p6im7_ce_details AS a

  INNER JOIN p6im7_categories AS cc 
  on cc.id = a.catid

  WHERE a.id = 4 
  AND a.published IN (1,2) 
  AND cc.published IN (1,2)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	cc	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.00 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_contactenhanced/models/contact.php:8
13	ContactenhancedModelContact->getContactQuery()	JROOT/components/com_contactenhanced/models/contact.php:8
12	ContactenhancedModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contactenhanced/views/contact/view.html.php:8
10	ContactenhancedViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contactenhanced/controller.php:8
8	ContactenhancedController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:8
6	require_once JROOT/components/com_contactenhanced/contactenhanced.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:225
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.22 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 3.099 MB Rows returned: 9

SELECT a.id,a.title,a.state,a.access,a.catid,a.created,a.language, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug

  FROM p6im7_content as a

  LEFT JOIN p6im7_categories as c 
  on a.catid=c.id

  WHERE a.created_by = 100 
  AND a.state IN (1,2)

  ORDER BY a.state DESC, a.created DESC 
  LIMIT 10

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_createdby	idx_createdby	4	const	9	100.00	Using where; Using filesort
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	mfaetadmin_365_j36.a.catid	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.08 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_contactenhanced/models/contact.php:8
13	ContactenhancedModelContact->getContactQuery()	JROOT/components/com_contactenhanced/models/contact.php:8
12	ContactenhancedModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contactenhanced/views/contact/view.html.php:8
10	ContactenhancedViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contactenhanced/controller.php:8
8	ContactenhancedController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:8
6	require_once JROOT/components/com_contactenhanced/contactenhanced.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:225
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.09 ms After last query: 0.23 ms Query memory: 0.025 MB Memory before query: 3.119 MB Rows returned: 17

SHOW FULL COLUMNS 
  FROM `p6im7_users`

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.51 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
Creating tmp table	0.05 ms
executing	0.06 ms
checking permissions	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
20	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
19	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
18	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
17	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_users/models/user.php:65
16	UsersModelUser->getTable()	JROOT/libraries/src/MVC/Model/AdminModel.php:971
15	Joomla\CMS\MVC\Model\AdminModel->getItem()	JROOT/administrator/components/com_users/models/user.php:90
14	UsersModelUser->getItem()	JROOT/components/com_contactenhanced/models/contact.php:8
13	ContactenhancedModelContact->getContactQuery()	JROOT/components/com_contactenhanced/models/contact.php:8
12	ContactenhancedModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contactenhanced/views/contact/view.html.php:8
10	ContactenhancedViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contactenhanced/controller.php:8
8	ContactenhancedController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:8
6	require_once JROOT/components/com_contactenhanced/contactenhanced.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:225
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.12 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 3.150 MB Rows returned: 1

SELECT *

  FROM `p6im7_users`

  WHERE `id` = 100

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
16	Joomla\CMS\Table\User->load()	JROOT/libraries/src/MVC/Model/AdminModel.php:976
15	Joomla\CMS\MVC\Model\AdminModel->getItem()	JROOT/administrator/components/com_users/models/user.php:90
14	UsersModelUser->getItem()	JROOT/components/com_contactenhanced/models/contact.php:8
13	ContactenhancedModelContact->getContactQuery()	JROOT/components/com_contactenhanced/models/contact.php:8
12	ContactenhancedModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contactenhanced/views/contact/view.html.php:8
10	ContactenhancedViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contactenhanced/controller.php:8
8	ContactenhancedController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:8
6	require_once JROOT/components/com_contactenhanced/contactenhanced.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:225
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.12 ms After last query: 0.27 ms Query memory: 0.023 MB Memory before query: 3.161 MB Rows returned: 1

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

  FROM `p6im7_usergroups` AS g

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

  WHERE `m`.`user_id` = 100

Explain

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

Profile

Status	Duration
starting	0.01 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
17	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
16	Joomla\CMS\Table\User->load()	JROOT/libraries/src/MVC/Model/AdminModel.php:976
15	Joomla\CMS\MVC\Model\AdminModel->getItem()	JROOT/administrator/components/com_users/models/user.php:90
14	UsersModelUser->getItem()	JROOT/components/com_contactenhanced/models/contact.php:8
13	ContactenhancedModelContact->getContactQuery()	JROOT/components/com_contactenhanced/models/contact.php:8
12	ContactenhancedModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contactenhanced/views/contact/view.html.php:8
10	ContactenhancedViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contactenhanced/controller.php:8
8	ContactenhancedController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:8
6	require_once JROOT/components/com_contactenhanced/contactenhanced.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:225
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.31 ms After last query: 0.48 ms Query memory: 0.025 MB Memory before query: 3.238 MB Rows returned: 0

SELECT DISTINCT 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 p6im7_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_users.user' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.01 ms
Creating tmp table	0.03 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:286
17	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
16	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/components/com_contactenhanced/models/contact.php:8
13	ContactenhancedModelContact->getContactQuery()	JROOT/components/com_contactenhanced/models/contact.php:8
12	ContactenhancedModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contactenhanced/views/contact/view.html.php:8
10	ContactenhancedViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contactenhanced/controller.php:8
8	ContactenhancedController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:8
6	require_once JROOT/components/com_contactenhanced/contactenhanced.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:225
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.76 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 3.240 MB Rows returned: 5

SELECT cf.*

  FROM p6im7_ce_cf AS cf

  WHERE cf.access IN (1,1,5) 
  AND (cf.catid = '54' OR cf.catid = 0) 
  AND (cf.published > 0 OR (cf.published = 0 
  AND cf.iscore = 1) ) 
  AND cf.language IN ('en-GB','*')

  ORDER BY cf.catid, cf.ordering ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cf	NULL	range	idx_ce_cf_language,idx_ce_cf_published,idx_ce_cf_access	idx_ce_cf_published	1	NULL	5	36.00	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.59 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_contactenhanced/models/customfields.php:8
14	ContactenhancedModelCustomfields->getCustomFields()	JROOT/components/com_contactenhanced/models/customfields.php:8
13	ContactenhancedModelCustomfields->getItems()	JROOT/components/com_contactenhanced/helpers/helper.php:814
12	ceHelper::getCustomFields()	JROOT/components/com_contactenhanced/models/contact.php:8
11	ContactenhancedModelContact->getCustomFields()	JROOT/components/com_contactenhanced/views/contact/view.html.php:8
10	ContactenhancedViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contactenhanced/controller.php:8
8	ContactenhancedController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:8
6	require_once JROOT/components/com_contactenhanced/contactenhanced.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:225
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.47 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 3.254 MB Rows returned: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
SELECT COUNT(i.`id`)

  FROM `p6im7_ce_details` AS `i`

  WHERE i.`catid` = c.id 
  AND i.published = 1) AS numitems

  FROM `p6im7_categories` AS `s`

  INNER JOIN `p6im7_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_contactenhanced' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 54

  ORDER BY c.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
1	PRIMARY	c	NULL	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	11	69.84	Using index condition; Using where
2	DEPENDENT SUBQUERY	i	NULL	ref	idx_state,idx_catid	idx_catid	4	mfaetadmin_365_j36.c.id	7	28.30	Using where

Profile

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.09 ms
executing	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
14	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
13	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_contactenhanced/models/category.php:8
12	ContactenhancedModelCategory->getCategory()	JROOT/components/com_contactenhanced/models/category.php:8
11	ContactenhancedModelCategory->getItems()	JROOT/components/com_contactenhanced/views/contact/view.html.php:8
10	ContactenhancedViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contactenhanced/controller.php:8
8	ContactenhancedController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:8
6	require_once JROOT/components/com_contactenhanced/contactenhanced.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:225
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.34 ms After last query: 0.30 ms Query memory: 0.038 MB Memory before query: 3.275 MB Rows returned: 2

SELECT a.id, a.name, a.alias, a.name AS title, a.alias AS title_alias, a.params, a.user_id,a.checked_out, a.checked_out_time, a.birthdate, a.department,a.misc, a.con_position, a.address, a.suburb, a.state , a.country, a.postcode, a.telephone, a.fax, a.mobile, a.skype, a.twitter, a.facebook, a.linkedin, a.google_plus, a.webpage, a.image,a.category_image, a.extra_field_1, a.extra_field_2, a.extra_field_3, a.extra_field_4, a.extra_field_5, a.extra_field_6, a.extra_field_7, a.extra_field_8, a.extra_field_9, a.extra_field_10,a.lat, a.lng, a.email_to,a.catid, a.created, a.created_by, a.created_by_alias, a.published AS published_state,  
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.metadata, a.metakey, a.metadesc, a.access, a.xreference, a.featured ,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.published END AS published,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM p6im7_ce_details AS a

  LEFT JOIN p6im7_categories AS c 
  ON c.id = a.catid

  LEFT JOIN p6im7_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN p6im7_users AS uam 
  ON uam.id = a.modified_by

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

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

  WHERE 
  CASE WHEN badcats.id is null THEN a.published ELSE 0 END = 1 
  AND a.catid = 54 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-07-20 02:00:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-07-20 02:00:21')

  ORDER BY ordering  ASC 
  LIMIT 100

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ref	idx_catid	idx_catid	4	const	4	16.00	Using where; Using filesort
1	PRIMARY	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	mfaetadmin_365_j36.a.created_by	1	100.00	Using where
1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	mfaetadmin_365_j36.a.modified_by	1	100.00	Using where
1	PRIMARY	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	mfaetadmin_365_j36.c.parent_id	1	100.00	Using where
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	mfaetadmin_365_j36.c.id	2	100.00	Using where; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	100.00	Using index condition; Using temporary
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	63	11.11	Using where; Using index; Using join buffer (hash join)

Profile

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.79 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
Creating tmp table	0.03 ms
statistics	0.04 ms
preparing	0.06 ms
executing	0.17 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.11 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_contactenhanced/models/contacts.php:7
12	ContactenhancedModelContacts->getItems()	JROOT/components/com_contactenhanced/models/category.php:8
11	ContactenhancedModelCategory->getItems()	JROOT/components/com_contactenhanced/views/contact/view.html.php:8
10	ContactenhancedViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contactenhanced/controller.php:8
8	ContactenhancedController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:8
6	require_once JROOT/components/com_contactenhanced/contactenhanced.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:225
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.38 ms After last query: 0.39 ms Query memory: 0.022 MB Memory before query: 3.368 MB Rows returned: 1

SELECT COUNT(*)

  FROM p6im7_ce_details AS a

  LEFT JOIN p6im7_categories AS c 
  ON c.id = a.catid

  LEFT JOIN p6im7_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN p6im7_users AS uam 
  ON uam.id = a.modified_by

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

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

  WHERE 
  CASE WHEN badcats.id is null THEN a.published ELSE 0 END = 1 
  AND a.catid = 54 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-07-20 02:00:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-07-20 02:00:21')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ref	idx_catid	idx_catid	4	const	4	16.00	Using where
1	PRIMARY	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	mfaetadmin_365_j36.a.created_by	1	100.00	Using where; Using index
1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	mfaetadmin_365_j36.a.modified_by	1	100.00	Using where; Using index
1	PRIMARY	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	mfaetadmin_365_j36.c.parent_id	1	100.00	Using where; Using index
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	mfaetadmin_365_j36.c.id	2	100.00	Using where; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	100.00	Using index condition; Using temporary
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	63	11.11	Using where; Using index; Using join buffer (hash join)

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
statistics	0.03 ms
preparing	0.05 ms
executing	0.07 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_contactenhanced/models/category.php:8
11	ContactenhancedModelCategory->getItems()	JROOT/components/com_contactenhanced/views/contact/view.html.php:8
10	ContactenhancedViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contactenhanced/controller.php:8
8	ContactenhancedController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:8
6	require_once JROOT/components/com_contactenhanced/contactenhanced.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:225
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.16 ms After last query: 0.15 ms Query memory: 0.021 MB Memory before query: 3.370 MB Rows returned: 0

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

  FROM `p6im7_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_contactenhanced.contact' 
  AND `m`.`content_item_id` = 4 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	10	10.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	mfaetadmin_365_j36.m.tag_id	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_contactenhanced/views/contact/view.html.php:8
10	ContactenhancedViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contactenhanced/controller.php:8
8	ContactenhancedController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:8
6	require_once JROOT/components/com_contactenhanced/contactenhanced.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:225
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.51 ms After last query: 0.97 ms Query memory: 0.025 MB Memory before query: 3.403 MB Rows returned: 11

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

  FROM `p6im7_assets`

  WHERE `name` LIKE 'com_contactenhanced.%' OR `name` = 'com_contactenhanced' OR `parent_id` = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p6im7_assets	NULL	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	1212	21.14	Using where

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.38 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.05 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
19	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/libraries/src/Helper/ContentHelper.php:236
14	Joomla\CMS\Helper\ContentHelper::getActions()	JROOT/templates/it_365news/html/com_contactenhanced/contact/default.php:7
13	include JROOT/templates/it_365news/html/com_contactenhanced/contact/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_contactenhanced/views/contact/view.html.php:8
10	ContactenhancedViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contactenhanced/controller.php:8
8	ContactenhancedController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:8
6	require_once JROOT/components/com_contactenhanced/contactenhanced.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:225
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: 0.45 ms Query memory: 0.025 MB Memory before query: 3.441 MB Rows returned: 10

Duplicate queries: #48

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

  FROM p6im7_modules AS m

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

  LEFT JOIN p6im7_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 <= '2026-07-20 02:00:21') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-07-20 02:00:21') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	PRIMARY,published,newsfeeds	NO INDEX KEY COULD BE USED	NULL	NULL	122	1.05	Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	mfaetadmin_365_j36.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	mfaetadmin_365_j36.m.id	2	40.00	Using where; Using index

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.58 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	Same as call in the line below.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
17	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
16	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
15	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/components/com_contactenhanced/helpers/helper.php:2552
14	ceHelper::loadModulePosition()	JROOT/templates/it_365news/html/com_contactenhanced/contact/default.php:21
13	include JROOT/templates/it_365news/html/com_contactenhanced/contact/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_contactenhanced/views/contact/view.html.php:8
10	ContactenhancedViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contactenhanced/controller.php:8
8	ContactenhancedController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:8
6	require_once JROOT/components/com_contactenhanced/contactenhanced.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:225
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.45 ms After last query: 3.31 ms Query memory: 0.027 MB Memory before query: 4.757 MB Rows returned: 1

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `p6im7_categories` AS `s`

  INNER JOIN `p6im7_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_contactenhanced' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 4

  ORDER BY c.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	c	NULL	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	11	65.08	Using index condition; Using where

Profile

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.08 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
26	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
25	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_contactenhanced/router.php:8
24	ContactenhancedBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
23	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
22	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
21	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
18	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
17	Joomla\CMS\Router\Route::_()	JROOT/components/com_contactenhanced/helpers/helper.php:389
16	ceHelper::loadForm()	JROOT/templates/it_365news/html/com_contactenhanced/contact/default_form.php:24
15	include JROOT/templates/it_365news/html/com_contactenhanced/contact/default_form.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/it_365news/html/com_contactenhanced/contact/default.php:122
13	include JROOT/templates/it_365news/html/com_contactenhanced/contact/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_contactenhanced/views/contact/view.html.php:8
10	ContactenhancedViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contactenhanced/controller.php:8
8	ContactenhancedController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:8
6	require_once JROOT/components/com_contactenhanced/contactenhanced.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:225
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.39 ms After last query: 3.05 ms Query memory: 0.022 MB Memory before query: 4.799 MB Rows returned: 7

SELECT s.id, e.extension_id, s.template AS name, s.title, s.params

  FROM p6im7_template_styles AS s

  LEFT JOIN p6im7_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 
  AND e.state = 0

  ORDER BY s.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	1.00	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	mfaetadmin_365_j36.e.element	4	87.50	Using index condition; Using where

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
Creating tmp table	0.03 ms
executing	0.08 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry5/src/classes/Gantry/Admin/ThemeList.php:156
12	Gantry\Admin\ThemeList::loadStyles()	JROOT/libraries/gantry5/src/classes/Gantry/Admin/ThemeList.php:71
11	Gantry\Admin\ThemeList::getStyles()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Outlines.php:96
10	Gantry\Framework\Outlines->load()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Base/Gantry.php:306
9	Gantry\Framework\Base\Gantry::Gantry\Framework\Base\{closure}()	JROOT/libraries/gantry5/compat/vendor/pimple/pimple/src/Pimple/Container.php:118
8	Pimple\Container->offsetGet()	JROOT/templates/it_365news/index.php:20
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
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.25 ms After last query: 0.51 ms Query memory: 0.022 MB Memory before query: 4.821 MB Rows returned: 1

SELECT *

  FROM p6im7_extensions

  WHERE `type` = 'template' 
  AND `element` = 'it_365news' 
  AND `client_id` = '0'

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
13	Joomla\CMS\Table\Table->load()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/ThemeInstaller.php:89
12	Gantry\Framework\ThemeInstaller->loadExtension()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/ThemeInstaller.php:55
11	Gantry\Framework\ThemeInstaller->__construct()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Outlines.php:98
10	Gantry\Framework\Outlines->load()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Base/Gantry.php:306
9	Gantry\Framework\Base\Gantry::Gantry\Framework\Base\{closure}()	JROOT/libraries/gantry5/compat/vendor/pimple/pimple/src/Pimple/Container.php:118
8	Pimple\Container->offsetGet()	JROOT/templates/it_365news/index.php:20
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
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.16 ms After last query: 7.34 ms Query memory: 0.033 MB Memory before query: 5.693 MB Rows returned: 6

SELECT `a`.`menutype`,`a`.`title`

  FROM `p6im7_menu_types` AS `a`

  WHERE `a`.`client_id` = 0

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
44	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
43	JDatabaseDriver->loadAssocList()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:138
42	Gantry\Framework\Menu->getMenuOptions()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:115
41	Gantry\Framework\Menu->getMenus()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Menu/AbstractMenu.php:274
40	Gantry\Component\Menu\AbstractMenu->instance()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:702
39	Twig\Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:32
38	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
36	Twig\Template->display()	JROOT/cache/gantry5/it_365news/twig/5b/5bf14cad423de714de362ba9a517abc8262d52f14edd9f0276119132b78fb7bf.php:85
35	__TwigTemplate_3f81b15ffa47e90b0b84c7cab92fcd033ccd4eeb01522abacc36a6fd1c66cd62->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
33	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
32	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
30	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825
28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:700
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/cf/cf258eb9b695c360fdfe3046762233859471d9c18b902e5b38ade5c1881d0a22.php:47
20	__TwigTemplate_5d75b7df8ef41aeb0e51a4653b1b43a6ee49861466cc215f1c29b7a5812c1ef8->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
18	Twig\Template->display()	JROOT/cache/gantry5/it_365news/twig/c2/c2e6947d8bbea143d371ccf0d7e4b738bb989f377b67a04daa24ceee2f5e7dc5.php:35
17	__TwigTemplate_89ba2da846ceafe4dd030deb530892963a60a954ab3a562ee08d769d566f394d->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
15	Twig\Template->display()	JROOT/cache/gantry5/it_365news/twig/96/96818510ed595801ae7ea4bd2cdce8313de31a81eccb37e19de1fb212e8419c0.php:35
14	__TwigTemplate_36e671e6ad3c7e2fea0aa8447c1ddcffe58edd257952717d84f5b82c1a63366a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
12	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
11	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/it_365news/index.php:28
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
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.34 ms After last query: 0.24 ms Query memory: 0.035 MB Memory before query: 5.720 MB Rows returned: 63

SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id

  FROM p6im7_menu AS m

  WHERE m.menutype = 'mainmenu' 
  AND m.parent_id > 0 
  AND m.client_id = 0 
  AND m.published >= 0

  ORDER BY m.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language,idx_menutype	idx_menutype	98	const	66	19.44	Using where; Using filesort

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.16 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
45	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
44	JDatabaseDriver->loadAssocList()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791
43	Gantry\Framework\Menu->getMenuItemIds()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:310
42	Gantry\Framework\Menu->getItemsFromPlatform()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:753
41	Gantry\Framework\Menu->getList()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Menu/AbstractMenu.php:316
40	Gantry\Component\Menu\AbstractMenu->instance()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:702
39	Twig\Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:32
38	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
36	Twig\Template->display()	JROOT/cache/gantry5/it_365news/twig/5b/5bf14cad423de714de362ba9a517abc8262d52f14edd9f0276119132b78fb7bf.php:85
35	__TwigTemplate_3f81b15ffa47e90b0b84c7cab92fcd033ccd4eeb01522abacc36a6fd1c66cd62->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
33	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
32	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
30	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825
28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:700
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/cf/cf258eb9b695c360fdfe3046762233859471d9c18b902e5b38ade5c1881d0a22.php:47
20	__TwigTemplate_5d75b7df8ef41aeb0e51a4653b1b43a6ee49861466cc215f1c29b7a5812c1ef8->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
18	Twig\Template->display()	JROOT/cache/gantry5/it_365news/twig/c2/c2e6947d8bbea143d371ccf0d7e4b738bb989f377b67a04daa24ceee2f5e7dc5.php:35
17	__TwigTemplate_89ba2da846ceafe4dd030deb530892963a60a954ab3a562ee08d769d566f394d->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
15	Twig\Template->display()	JROOT/cache/gantry5/it_365news/twig/96/96818510ed595801ae7ea4bd2cdce8313de31a81eccb37e19de1fb212e8419c0.php:35
14	__TwigTemplate_36e671e6ad3c7e2fea0aa8447c1ddcffe58edd257952717d84f5b82c1a63366a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
12	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
11	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/it_365news/index.php:28
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
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.05 ms After last query: 2.92 ms Query memory: 0.040 MB Memory before query: 6.429 MB Rows returned: 10

Duplicate queries: #42

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

  FROM p6im7_modules AS m

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

  LEFT JOIN p6im7_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 <= '2026-07-20 02:00:21') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-07-20 02:00:21') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	PRIMARY,published,newsfeeds	NO INDEX KEY COULD BE USED	NULL	NULL	122	1.05	Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	mfaetadmin_365_j36.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	mfaetadmin_365_j36.m.id	2	40.00	Using where; Using index

Profile

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.68 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
62	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
61	JDatabaseDriver->loadObjectList()	Same as call in the line below.
60	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
59	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
58	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:404
57	Gantry\Framework\Platform->getModuleList()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:394
56	Gantry\Framework\Platform->getModule()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:279
55	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:702
54	Twig\Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/79/79a5167f5d66bc96f5ef9b12528a5ae066ad303a993c57ef0f426052954a6431.php:43
53	__TwigTemplate_d067f28330ac896912ca35a14c06be82e080eb6da475964abc229dcf2bc37cea->block_particle()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:214
52	Twig\Template->displayBlock()	JROOT/cache/gantry5/it_365news/twig/e8/e851ec3df02dacae07242db4121c274c858c603c102e6c17b5fa4e31d77fcbc9.php:73
51	__TwigTemplate_edefafb2b689b1307146d5be38acfa374dc5255ada353e391580febb2b0fb1f3->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
50	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
49	Twig\Template->display()	JROOT/cache/gantry5/it_365news/twig/79/79a5167f5d66bc96f5ef9b12528a5ae066ad303a993c57ef0f426052954a6431.php:35
48	__TwigTemplate_d067f28330ac896912ca35a14c06be82e080eb6da475964abc229dcf2bc37cea->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
47	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
46	Twig\Template->display()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:182
45	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->getdisplayParticle()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:526
44	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->getdisplayItem()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:687
43	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->getdisplayItems()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:630
42	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->getdisplayContainers()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:752
41	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->getdisplaySubmenu()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:569
40	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->getdisplayItem()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:687
39	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->getdisplayItems()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:83
38	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
36	Twig\Template->display()	JROOT/cache/gantry5/it_365news/twig/5b/5bf14cad423de714de362ba9a517abc8262d52f14edd9f0276119132b78fb7bf.php:85
35	__TwigTemplate_3f81b15ffa47e90b0b84c7cab92fcd033ccd4eeb01522abacc36a6fd1c66cd62->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
33	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
32	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
30	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825
28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:700
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/cf/cf258eb9b695c360fdfe3046762233859471d9c18b902e5b38ade5c1881d0a22.php:47
20	__TwigTemplate_5d75b7df8ef41aeb0e51a4653b1b43a6ee49861466cc215f1c29b7a5812c1ef8->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
18	Twig\Template->display()	JROOT/cache/gantry5/it_365news/twig/c2/c2e6947d8bbea143d371ccf0d7e4b738bb989f377b67a04daa24ceee2f5e7dc5.php:35
17	__TwigTemplate_89ba2da846ceafe4dd030deb530892963a60a954ab3a562ee08d769d566f394d->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
15	Twig\Template->display()	JROOT/cache/gantry5/it_365news/twig/96/96818510ed595801ae7ea4bd2cdce8313de31a81eccb37e19de1fb212e8419c0.php:35
14	__TwigTemplate_36e671e6ad3c7e2fea0aa8447c1ddcffe58edd257952717d84f5b82c1a63366a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
12	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
11	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/it_365news/index.php:28
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
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.37 ms After last query: 0.45 ms Query memory: 0.045 MB Memory before query: 6.486 MB Rows returned: 139

SELECT * 
  FROM p6im7_acymailing_config

Explain

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

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.24 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
65	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
64	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:481
63	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
62	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:438
61	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:822
60	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:22
59	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/modules/mod_acymailing/mod_acymailing.php:13
58	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
57	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
56	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:294
55	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:702
54	Twig\Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/79/79a5167f5d66bc96f5ef9b12528a5ae066ad303a993c57ef0f426052954a6431.php:43
53	__TwigTemplate_d067f28330ac896912ca35a14c06be82e080eb6da475964abc229dcf2bc37cea->block_particle()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:214
52	Twig\Template->displayBlock()	JROOT/cache/gantry5/it_365news/twig/e8/e851ec3df02dacae07242db4121c274c858c603c102e6c17b5fa4e31d77fcbc9.php:73
51	__TwigTemplate_edefafb2b689b1307146d5be38acfa374dc5255ada353e391580febb2b0fb1f3->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
50	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
49	Twig\Template->display()	JROOT/cache/gantry5/it_365news/twig/79/79a5167f5d66bc96f5ef9b12528a5ae066ad303a993c57ef0f426052954a6431.php:35
48	__TwigTemplate_d067f28330ac896912ca35a14c06be82e080eb6da475964abc229dcf2bc37cea->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
47	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
46	Twig\Template->display()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:182
45	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->getdisplayParticle()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:526
44	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->getdisplayItem()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:687
43	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->getdisplayItems()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:630
42	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->getdisplayContainers()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:752
41	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->getdisplaySubmenu()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:569
40	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->getdisplayItem()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:687
39	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->getdisplayItems()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:83
38	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
36	Twig\Template->display()	JROOT/cache/gantry5/it_365news/twig/5b/5bf14cad423de714de362ba9a517abc8262d52f14edd9f0276119132b78fb7bf.php:85
35	__TwigTemplate_3f81b15ffa47e90b0b84c7cab92fcd033ccd4eeb01522abacc36a6fd1c66cd62->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
33	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
32	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
30	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825
28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:700
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/cf/cf258eb9b695c360fdfe3046762233859471d9c18b902e5b38ade5c1881d0a22.php:47
20	__TwigTemplate_5d75b7df8ef41aeb0e51a4653b1b43a6ee49861466cc215f1c29b7a5812c1ef8->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
18	Twig\Template->display()	JROOT/cache/gantry5/it_365news/twig/c2/c2e6947d8bbea143d371ccf0d7e4b738bb989f377b67a04daa24ceee2f5e7dc5.php:35
17	__TwigTemplate_89ba2da846ceafe4dd030deb530892963a60a954ab3a562ee08d769d566f394d->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
15	Twig\Template->display()	JROOT/cache/gantry5/it_365news/twig/96/96818510ed595801ae7ea4bd2cdce8313de31a81eccb37e19de1fb212e8419c0.php:35
14	__TwigTemplate_36e671e6ad3c7e2fea0aa8447c1ddcffe58edd257952717d84f5b82c1a63366a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
12	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
11	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/it_365news/index.php:28
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
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.15 ms After last query: 1.05 ms Query memory: 0.040 MB Memory before query: 6.902 MB Rows returned: 1

SELECT * 
  FROM p6im7_acymailing_list 
  WHERE type = 'list'  
  ORDER BY ordering ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p6im7_acymailing_list	NULL	system	typeorderingindex,typeuseridindex	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
62	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
61	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:481
60	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/list.php:30
59	listClass->getLists()	JROOT/modules/mod_acymailing/mod_acymailing.php:148
58	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
57	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
56	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:294
55	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:702
54	Twig\Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/79/79a5167f5d66bc96f5ef9b12528a5ae066ad303a993c57ef0f426052954a6431.php:43
53	__TwigTemplate_d067f28330ac896912ca35a14c06be82e080eb6da475964abc229dcf2bc37cea->block_particle()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:214
52	Twig\Template->displayBlock()	JROOT/cache/gantry5/it_365news/twig/e8/e851ec3df02dacae07242db4121c274c858c603c102e6c17b5fa4e31d77fcbc9.php:73
51	__TwigTemplate_edefafb2b689b1307146d5be38acfa374dc5255ada353e391580febb2b0fb1f3->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
50	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
49	Twig\Template->display()	JROOT/cache/gantry5/it_365news/twig/79/79a5167f5d66bc96f5ef9b12528a5ae066ad303a993c57ef0f426052954a6431.php:35
48	__TwigTemplate_d067f28330ac896912ca35a14c06be82e080eb6da475964abc229dcf2bc37cea->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
47	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
46	Twig\Template->display()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:182
45	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->getdisplayParticle()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:526
44	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->getdisplayItem()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:687
43	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->getdisplayItems()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:630
42	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->getdisplayContainers()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:752
41	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->getdisplaySubmenu()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:569
40	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->getdisplayItem()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:687
39	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->getdisplayItems()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:83
38	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
36	Twig\Template->display()	JROOT/cache/gantry5/it_365news/twig/5b/5bf14cad423de714de362ba9a517abc8262d52f14edd9f0276119132b78fb7bf.php:85
35	__TwigTemplate_3f81b15ffa47e90b0b84c7cab92fcd033ccd4eeb01522abacc36a6fd1c66cd62->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
33	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
32	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
30	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825
28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:700
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/cf/cf258eb9b695c360fdfe3046762233859471d9c18b902e5b38ade5c1881d0a22.php:47
20	__TwigTemplate_5d75b7df8ef41aeb0e51a4653b1b43a6ee49861466cc215f1c29b7a5812c1ef8->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
18	Twig\Template->display()	JROOT/cache/gantry5/it_365news/twig/c2/c2e6947d8bbea143d371ccf0d7e4b738bb989f377b67a04daa24ceee2f5e7dc5.php:35
17	__TwigTemplate_89ba2da846ceafe4dd030deb530892963a60a954ab3a562ee08d769d566f394d->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
15	Twig\Template->display()	JROOT/cache/gantry5/it_365news/twig/96/96818510ed595801ae7ea4bd2cdce8313de31a81eccb37e19de1fb212e8419c0.php:35
14	__TwigTemplate_36e671e6ad3c7e2fea0aa8447c1ddcffe58edd257952717d84f5b82c1a63366a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
12	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
11	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/it_365news/index.php:28
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
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.48 ms After last query: 1.91 ms Query memory: 0.039 MB Memory before query: 6.927 MB Rows returned: 0

SELECT DISTINCT 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 p6im7_fields AS a

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

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

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

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

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

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

  ORDER BY a.ordering ASC

Explain

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

Profile

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.02 ms
Creating tmp table	0.05 ms
executing	0.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
59	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
58	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
57	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
56	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
55	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
54	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
53	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
52	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
51	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
50	JHtmlContent::prepare()	Same as call in the line below.
49	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
48	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
47	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:243
46	Gantry\Framework\Platform->filter()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:702
45	Twig\Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/c8/c8778e570a80096c023b378b815d6af37652765bf4c48be33ab14ad199eb0f69.php:41
44	__TwigTemplate_d3ef65b5c60fbdeecf599d55dfa209b64a2c39c3678922fbec141b9596e6becb->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
42	Twig\Template->display()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:182
41	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->getdisplayParticle()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:526
40	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->getdisplayItem()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:687
39	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->getdisplayItems()	JROOT/cache/gantry5/it_365news/twig/bb/bb9172f613996d557ed73fa286eb04ce84c7e35ecea1bb4fc0b8d82d547a7812.php:83
38	__TwigTemplate_1077746f4424922da7493277a28f2b064a1c899c5e6aa773b8968eacab5ae62a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
36	Twig\Template->display()	JROOT/cache/gantry5/it_365news/twig/5b/5bf14cad423de714de362ba9a517abc8262d52f14edd9f0276119132b78fb7bf.php:85
35	__TwigTemplate_3f81b15ffa47e90b0b84c7cab92fcd033ccd4eeb01522abacc36a6fd1c66cd62->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
33	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
32	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
30	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825
28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:700
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/cf/cf258eb9b695c360fdfe3046762233859471d9c18b902e5b38ade5c1881d0a22.php:47
20	__TwigTemplate_5d75b7df8ef41aeb0e51a4653b1b43a6ee49861466cc215f1c29b7a5812c1ef8->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
18	Twig\Template->display()	JROOT/cache/gantry5/it_365news/twig/c2/c2e6947d8bbea143d371ccf0d7e4b738bb989f377b67a04daa24ceee2f5e7dc5.php:35
17	__TwigTemplate_89ba2da846ceafe4dd030deb530892963a60a954ab3a562ee08d769d566f394d->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
15	Twig\Template->display()	JROOT/cache/gantry5/it_365news/twig/96/96818510ed595801ae7ea4bd2cdce8313de31a81eccb37e19de1fb212e8419c0.php:35
14	__TwigTemplate_36e671e6ad3c7e2fea0aa8447c1ddcffe58edd257952717d84f5b82c1a63366a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
12	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
11	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/it_365news/index.php:28
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
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.22 ms After last query: 169.95 ms Query memory: 0.024 MB Memory before query: 21.924 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `p6im7_template_styles`

Explain

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

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.60 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
Creating tmp table	0.04 ms
executing	0.07 ms
checking permissions	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.03 ms
freeing items	0.04 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
17	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
16	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:328
15	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/gantry/gantry.php:194
14	plgSystemGantry->getTable()	JROOT/plugins/system/gantry/gantry.php:165
13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
12	plgSystemGantry->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.10 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 21.944 MB Rows returned: 1

SELECT *

  FROM p6im7_template_styles

  WHERE `id` = '9'

Explain

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

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
14	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/gantry/gantry.php:168
13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
12	plgSystemGantry->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.]

45 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

```
3 × SELECT * 
  FROM p6im7_extensions
```

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

2 × SELECT template 
  FROM p6im7_template_styles as s

2 × SELECT `extension_id` 
  FROM `p6im7_extensions`

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `p6im7_assets`

2 × SELECT DISTINCT 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 p6im7_fields AS a 
  LEFT JOIN `p6im7_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN p6im7_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN p6im7_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN p6im7_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN p6im7_fields_groups AS g 
  ON g.id = a.group_id

2 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM p6im7_modules AS m 
  LEFT JOIN p6im7_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN p6im7_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT `session_id` 
  FROM `p6im7_session`

1 × SELECT id, rules 
  FROM `p6im7_viewlevels

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

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

1 × SELECT `value` 
  FROM `p6im7_admintools_storage`

1 × SELECT * 
  FROM `p6im7_admintools_wafexceptions`

1 × SELECT extension, file, type 
  FROM p6im7_rokcommon_configs

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

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

1 × SELECT `params` 
  FROM `p6im7_extensions`

1 × SELECT `source`,`keepurlparams` 
  FROM `p6im7_admintools_redirects`

1 × SELECT count(1) 
  FROM `p6im7_session`

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `p6im7_categories` AS `c`

1 × SELECT s.id, s.template, s.home, s.title AS long_title, s.params 
  FROM p6im7_template_styles AS s

1 × SELECT params 
  FROM `p6im7_extensions`

```
1 × SELECT * 
  FROM p6im7_languages
```

1 × SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias 
  FROM p6im7_ce_details AS a 
  LEFT JOIN p6im7_categories AS c 
  on c.id = a.catid 
  LEFT JOIN p6im7_categories as parent 
  ON parent.id = c.parent_id

1 × SELECT `t`.`id` 
  FROM `p6im7_tags` AS t  
  INNER JOIN `p6im7_contentitem_tag_map` AS m 
  ON `m`.`tag_id` = `t`.`id` 
  AND `m`.`type_alias` = 'com_contactenhanced.contact' 
  AND `m`.`content_item_id` IN ( 4

1 × SELECT a.*, cc.access as category_access, cc.title as category_name,  
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM p6im7_ce_details AS a 
  INNER JOIN p6im7_categories AS cc 
  on cc.id = a.catid

1 × SELECT a.id,a.title,a.state,a.access,a.catid,a.created,a.language, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug 
  FROM p6im7_content as a 
  LEFT JOIN p6im7_categories as c 
  on a.catid=c.id

```
1 × SELECT * 
  FROM `p6im7_users`
```

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

1 × SELECT cf.* 
  FROM p6im7_ce_cf AS cf

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`) 
  FROM `p6im7_ce_details` AS `i`

1 × SELECT a.id, a.name, a.alias, a.name AS title, a.alias AS title_alias, a.params, a.user_id,a.checked_out, a.checked_out_time, a.birthdate, a.department,a.misc, a.con_position, a.address, a.suburb, a.state , a.country, a.postcode, a.telephone, a.fax, a.mobile, a.skype, a.twitter, a.facebook, a.linkedin, a.google_plus, a.webpage, a.image,a.category_image, a.extra_field_1, a.extra_field_2, a.extra_field_3, a.extra_field_4, a.extra_field_5, a.extra_field_6, a.extra_field_7, a.extra_field_8, a.extra_field_9, a.extra_field_10,a.lat, a.lng, a.email_to,a.catid, a.created, a.created_by, a.created_by_alias, a.published AS published_state,  
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.metadata, a.metakey, a.metadesc, a.access, a.xreference, a.featured ,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.published END AS published,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM p6im7_ce_details AS a 
  LEFT JOIN p6im7_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN p6im7_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN p6im7_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN p6im7_categories as parent 
  ON parent.id = c.parent_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM p6im7_categories AS cat JOIN p6im7_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT COUNT(*) 
  FROM p6im7_ce_details AS a 
  LEFT JOIN p6im7_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN p6im7_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN p6im7_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN p6im7_categories as parent 
  ON parent.id = c.parent_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM p6im7_categories AS cat JOIN p6im7_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

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

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `p6im7_categories` AS `s` 
  INNER JOIN `p6im7_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

1 × SELECT s.id, e.extension_id, s.template AS name, s.title, s.params 
  FROM p6im7_template_styles AS s 
  LEFT JOIN p6im7_extensions AS e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT `a`.`menutype`,`a`.`title` 
  FROM `p6im7_menu_types` AS `a`

1 × SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id 
  FROM p6im7_menu AS m

1 × SELECT * 
  FROM p6im7_acymailing_confi

1 × SELECT * 
  FROM p6im7_acymailing_list

1 × SELECT * 
  FROM p6im7_template_styles

OTHER Tables:

1 × UPDATE `p6im7_extensions` 
  SET `params` = '{\"mediaversion\":\"17d58aadcf6749e1c807f01d0213a0b9\"}'

1 × SHOW FULL COLUMNS 
  FROM `p6im7_extensions

1 × SHOW FULL COLUMNS 
  FROM `p6im7_users

1 × SHOW FULL COLUMNS 
  FROM `p6im7_template_styles

Solomon Islands Government

Ministry of Foreign Affairs and External Trade

Ministry Corporate Service

Ministry of Foreign Affairs and External Trade

Quick Links

About the Website

Contact Details

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

53 Queries Logged 17.97 ms

6 duplicate found!

45 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: