Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1747027175,
                "last": 1747027175,
                "now": 1747027175
            },
            "token": "3tLFY8vvCFkAxwjyS4gPwtkTO00crVBb"
        },
        "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
        },
        "jomsocial_userip": "18.97.14.87"
    }
}

Profile Information

Time

Memory

Time: 7.73 ms / 7.73 ms Memory: 2.028 MB / 2.40 MB Application: afterLoad

Time: 72.34 ms / 80.07 ms Memory: 10.308 MB / 12.70 MB Application: afterInitialise

Time: 83.78 ms / 163.85 ms Memory: 2.622 MB / 15.33 MB Application: Before Access::preloadComponents (all components)

Time: 0.72 ms / 164.57 ms Memory: 0.069 MB / 15.40 MB Application: After Access::preloadComponents (all components)

Time: 0.02 ms / 164.58 ms Memory: -0.004 MB / 15.39 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Time: 0.24 ms / 164.82 ms Memory: 0.026 MB / 15.42 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Time: 13.85 ms / 178.67 ms Memory: 0.741 MB / 16.16 MB Application: afterRoute

Time: 0.30 ms / 178.98 ms Memory: 0.017 MB / 16.18 MB Application: beforeRenderComponent com_joomgallery

Time: 1372.82 ms / 1551.79 ms Memory: 7.588 MB / 23.76 MB Application: afterRenderComponent com_joomgallery

Time: 9.64 ms / 1561.43 ms Memory: 0.721 MB / 24.48 MB Application: afterDispatch

Time: 4.43 ms / 1565.87 ms Memory: 0.671 MB / 25.15 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.02 ms / 1565.89 ms Memory: 0.023 MB / 25.18 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 2.60 ms / 1568.49 ms Memory: 0.237 MB / 25.41 MB Application: beforeRenderModule mod_custom (Social)

Time: 0.18 ms / 1568.67 ms Memory: 0.025 MB / 25.44 MB Application: afterRenderRawModule mod_custom (Social)

Time: 0.01 ms / 1568.68 ms Memory: -0.001 MB / 25.44 MB Application: beforeRenderModule mod_custom (Social)

Time: 0.37 ms / 1569.05 ms Memory: 0.071 MB / 25.51 MB Application: afterRenderModule mod_custom (Social)

Time: 0.07 ms / 1569.12 ms Memory: 0.016 MB / 25.53 MB Application: beforeRenderModule mod_sticky_footer (Sticky Footer Menu)

Time: 0.16 ms / 1569.28 ms Memory: 0.017 MB / 25.54 MB Application: afterRenderRawModule mod_sticky_footer (Sticky Footer Menu)

Time: 0.00 ms / 1569.29 ms Memory: -0.001 MB / 25.54 MB Application: beforeRenderModule mod_sticky_footer (Sticky Footer Menu)

Time: 0.11 ms / 1569.40 ms Memory: 0.002 MB / 25.54 MB Application: afterRenderModule mod_sticky_footer (Sticky Footer Menu)

Time: 0.04 ms / 1569.43 ms Memory: -0.015 MB / 25.53 MB Application: beforeRenderModule mod_custom (Login)

Time: 0.07 ms / 1569.50 ms Memory: 0.002 MB / 25.53 MB Application: afterRenderRawModule mod_custom (Login)

Time: 0.00 ms / 1569.50 ms Memory: 0.001 MB / 25.53 MB Application: beforeRenderModule mod_custom (Login)

Time: 0.08 ms / 1569.58 ms Memory: 0.002 MB / 25.53 MB Application: afterRenderModule mod_custom (Login)

Time: 0.03 ms / 1569.61 ms Memory: 0.002 MB / 25.54 MB Application: beforeRenderModule mod_menu (network menu)

Time: 0.54 ms / 1570.15 ms Memory: 0.041 MB / 25.58 MB Application: afterRenderRawModule mod_menu (network menu)

Time: 0.01 ms / 1570.16 ms Memory: -0.002 MB / 25.57 MB Application: beforeRenderModule mod_menu (network menu)

Time: 0.09 ms / 1570.25 ms Memory: 0.002 MB / 25.58 MB Application: afterRenderModule mod_menu (network menu)

Time: 432.62 ms / 2002.86 ms Memory: 2.001 MB / 27.58 MB Application: afterRender

Database queries total: 1423.79 ms

EXPLAIN not possible on query: INSERT INTO `kez4a_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3137646636343138343437636231616634396132663833656137303061323633', 1, 1747027175, 0, '', 0)

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
update	0.06 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	10.87 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php: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.52 ms After last query: 1.94 ms Query memory: 0.042 MB Memory before query: 4.456 MB Rows returned: 51

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

  FROM `kez4a_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	kez4a_extensions	NULL	ref	extension	extension	82	const	56	1.00	Using where

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.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.27 ms
end	0.01 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
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.19 ms After last query: 1.90 ms Query memory: 0.021 MB Memory before query: 4.738 MB Rows returned: 3

SELECT id, rules

  FROM `kez4a_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 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.01 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.25 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 4.749 MB Rows returned: 1

SELECT b.id

  FROM kez4a_usergroups AS a

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

  WHERE a.id = 1

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	1	100.00	Using where; Using index

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.05 ms
preparing	0.02 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.01 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.98 ms After last query: 0.47 ms Query memory: 0.051 MB Memory before query: 4.818 MB Rows returned: 130

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

  FROM kez4a_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_extensions	NULL	ref	extension	extension	82	const	247	0.40	Using where; Using filesort

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.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.79 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
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.32 ms After last query: 17.22 ms Query memory: 0.004 MB Memory before query: 8.345 MB

UPDATE kez4a_extensions

  SET enabled=1

  WHERE `type`='plugin' 
  AND `element`='jacontenttype' 
  AND `folder`='ajax'

Explain

EXPLAIN not possible on query: UPDATE kez4a_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.08 ms
updating	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
9	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/jacontenttype/jacontenttype.php:62
8	PlgSystemJacontenttype->_check()	JROOT/plugins/system/jacontenttype/jacontenttype.php:44
7	PlgSystemJacontenttype->__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.16 ms After last query: 8.35 ms Query memory: 0.022 MB Memory before query: 9.759 MB Rows returned: 1

SELECT `value`

  FROM `kez4a_admintools_storage`

  WHERE `key` = 'cparams'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_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.04 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:123
12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:53
11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:41
10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:278
9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:831
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
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.77 ms Query memory: 0.021 MB Memory before query: 9.882 MB Rows returned: 0

SELECT *

  FROM `kez4a_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	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.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
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.02 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:549
10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:460
9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:843
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
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.20 ms After last query: 12.60 ms Query memory: 0.031 MB Memory before query: 11.860 MB Rows returned: 91

SELECT *

  FROM kez4a_j2store_configurations

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_j2store_configurations	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	91	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.01 ms
preparing	0.01 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_j2store/helpers/config.php:20
12	J2Config->__construct()	JROOT/administrator/components/com_j2store/helpers/config.php:28
11	J2Config::getInstance()	JROOT/administrator/components/com_j2store/helpers/j2store.php:72
10	J2Store::config()	JROOT/plugins/system/j2store/j2store.php:187
9	plgSystemJ2Store->onJ2StoreCronTask()	JROOT/plugins/system/j2store/j2store.php:167
8	plgSystemJ2Store->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.65 ms After last query: 1.51 ms Query memory: 0.076 MB Memory before query: 12.060 MB Rows returned: 64

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

  LEFT JOIN kez4a_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	234	5.30	Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	demodesign_2021.m.component_id	1	100.00	Using where

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.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.46 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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/plugins/system/t4/t4.php:68
8	PlgSystemT4->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: 0.39 ms Query memory: 0.021 MB Memory before query: 12.304 MB Rows returned: 1

SELECT *

  FROM kez4a_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	kez4a_languages	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.02 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.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/Language/LanguageHelper.php:150
10	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/t4/src/t4/MVC/Router/T4.php:91
9	T4\MVC\Router\T4->__construct()	JROOT/plugins/system/t4/t4.php:68
8	PlgSystemT4->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.88 ms After last query: 1.34 ms Query memory: 0.022 MB Memory before query: 12.527 MB Rows returned: 1

SHOW VARIABLES LIKE "collation_database"

Explain

EXPLAIN not possible on query: SHOW VARIABLES LIKE "collation_database"

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
statistics	0.00 ms
preparing	0.01 ms
executing	0.73 ms
end	0.00 ms
query end	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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/database/driver/mysqli.php:345
11	JDatabaseDriverMysqli->getCollation()	JROOT/plugins/system/admintools/feature/utf8mb4.php:28
10	AtsystemFeatureUtf8mb4->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:710
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
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.10 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 12.536 MB Rows returned: 0

SELECT `source`,`keepurlparams`

  FROM `kez4a_admintools_redirects`

  WHERE ((`dest` = 'competitions-3/dccr/fc-kharkiv-crest-redesign-64353') OR (`dest` = 'competitions-3/dccr/fc-kharkiv-crest-redesign-64353') OR ('competitions-3/dccr/fc-kharkiv-crest-redesign-64353' 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	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.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.01 ms
statistics	0.01 ms
executing	0.00 ms
end	0.00 ms
query end	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:89
10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:710
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
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.18 ms After last query: 9.15 ms Query memory: 0.022 MB Memory before query: 15.030 MB Rows returned: 1

SELECT *

  FROM kez4a_menu

  WHERE alias ='competitions-3' 
  AND published=1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_menu	NULL	ref	idx_alias	idx_alias	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.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.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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/plugins/system/t4/src/t4/MVC/Router/T4.php:346
11	T4\MVC\Router\T4->getMenuByAlias()	JROOT/plugins/system/t4/src/t4/MVC/Router/T4.php:133
10	T4\MVC\Router\T4->parseRule()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
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.39 ms After last query: 1.20 ms Query memory: 0.022 MB Memory before query: 15.299 MB Rows returned: 0

SELECT cid

  FROM kez4a_joomgallery_catg

  WHERE alias = 'dccr/fc-kharkiv-crest-redesign-64353'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_joomgallery_catg	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	239	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.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.29 ms
end	0.00 ms
query end	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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/helpers/routing.php:42
11	JoomRouting::getId()	JROOT/components/com_joomgallery/router.php:499
10	JoomGalleryParseRoute()	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: 73.08 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 15.306 MB Rows returned: 1

SELECT id

  FROM kez4a_joomgallery

  WHERE alias = 'fc-kharkiv-crest-redesign-64353'

Explain

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

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.01 ms
executing	72.98 ms
end	0.01 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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/helpers/routing.php:53
11	JoomRouting::getId()	JROOT/components/com_joomgallery/router.php:499
10	JoomGalleryParseRoute()	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.56 ms After last query: 0.37 ms Query memory: 0.028 MB Memory before query: 15.332 MB Rows returned: 51

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

  FROM `kez4a_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_advancedmodules','com_ajax','com_akeeba','com_allvideoshare','com_associations','com_banners','com_cache','com_categories','com_checkin','com_community','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_j2store','com_jaextmanager','com_jce','com_jlexcomment','com_jlexreview','com_jmap','com_joomgallery','com_joomlaupdate','com_jspeed','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_obrss','com_plugins','com_postinstall','com_privacy','com_profiles','com_redirect','com_search','com_sigpro','com_spambotcheck','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	kez4a_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	52	100.00	Using index condition

Profile

Status	Duration
starting	0.05 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.11 ms
preparing	0.01 ms
executing	0.28 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.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
15	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
14	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
13	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
12	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
11	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:30
10	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/advancedmodules.php:95
9	PlgSystemAdvancedModules->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:533
8	RegularLabs\Library\SystemPlugin->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.21 ms After last query: 0.51 ms Query memory: 0.024 MB Memory before query: 15.514 MB Rows returned: 1

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

  FROM `kez4a_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	kez4a_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.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.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
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/plugins/system/allvideosharefeedmanager/allvideosharefeedmanager.php:24
8	plgSystemAllVideoShareFeedManager->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: 6.57 ms After last query: 0.15 ms Query memory: 0.006 MB Memory before query: 15.506 MB

UPDATE `kez4a_extensions`

  SET `params` = '{\"mediaversion\":\"27df001f6a55102e8d720da4e7f39ca1\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `kez4a_extensions` SET `params` = '{\"mediaversion\":\"27df001f6a55102e8d720da4e7f39ca1\"}' 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.02 ms
init	0.00 ms
System lock	0.04 ms
updating	0.05 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	6.38 ms
closing tables	0.02 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/plugins/system/allvideosharefeedmanager/allvideosharefeedmanager.php:24
8	plgSystemAllVideoShareFeedManager->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.32 ms After last query: 1.35 ms Query memory: 0.021 MB Memory before query: 15.676 MB Rows returned: 0

SELECT * 
  FROM kez4a_allvideoshare_videos 
  WHERE slug=''

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_allvideoshare_videos	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	53	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.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.16 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:1662
9	JDatabaseDriver->loadObject()	JROOT/plugins/system/allvideosharefeedmanager/allvideosharefeedmanager.php:34
8	plgSystemAllVideoShareFeedManager->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.04 ms Query memory: 0.020 MB Memory before query: 15.681 MB Rows returned: 0

SELECT * 
  FROM kez4a_allvideoshare_categories 
  WHERE slug=''

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_allvideoshare_categories	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	20.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.00 ms
System lock	0.00 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.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:1662
9	JDatabaseDriver->loadObject()	JROOT/plugins/system/allvideosharefeedmanager/allvideosharefeedmanager.php:41
8	plgSystemAllVideoShareFeedManager->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.34 ms After last query: 0.29 ms Query memory: 0.021 MB Memory before query: 15.690 MB Rows returned: 1

SELECT id, home, template, s.params

  FROM kez4a_template_styles as s

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

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

Explain

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

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.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.06 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
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t4/src/t4/T4.php:40
9	T4\T4->init()	JROOT/plugins/system/t4/t4.php:84
8	PlgSystemT4->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.18 ms After last query: 0.28 ms Query memory: 0.021 MB Memory before query: 15.701 MB Rows returned: 1

SELECT `id`, `name`,`alias`, `use_feedburner`, `uri`, `feed_type` 
  FROM `kez4a_obrss` 
  WHERE `published` = 1 
  AND `feeded` = 1 
  ORDER BY `ordering`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_obrss	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	50.00	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.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.03 ms
end	0.00 ms
query end	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:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/obrss/obrss.php:40
8	plgSystemobrss->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: 6.86 ms After last query: 6.41 ms Query memory: 0.091 MB Memory before query: 16.512 MB Rows returned: 311

SHOW FULL COLUMNS 
  FROM `kez4a_joomgallery_config`

Explain

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

Profile

Status	Duration
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.45 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_joomgallery/tables/joomgalleryconfig.php:345
14	TableJoomgalleryConfig->__construct()	JROOT/libraries/src/Table/Table.php:328
13	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_joomgallery/helpers/config.php:387
12	JoomConfig->__construct()	JROOT/administrator/components/com_joomgallery/helpers/config.php:450
11	JoomConfig::getInstance()	JROOT/components/com_joomgallery/helpers/ambit.php:145
10	JoomAmbit->__construct()	JROOT/components/com_joomgallery/helpers/ambit.php:218
9	JoomAmbit::getInstance()	JROOT/components/com_joomgallery/controller.php:69
8	JoomGalleryController->__construct()	JROOT/libraries/src/MVC/Controller/BaseController.php:313
7	Joomla\CMS\MVC\Controller\BaseController::getInstance()	JROOT/components/com_joomgallery/joomgallery.php:37
6	require_once JROOT/components/com_joomgallery/joomgallery.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.41 ms After last query: 0.63 ms Query memory: 0.132 MB Memory before query: 16.874 MB Rows returned: 1

SELECT *

  FROM kez4a_joomgallery_config

  WHERE `id` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_joomgallery_config	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
Opening tables	0.05 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.12 ms
preparing	0.01 ms
executing	0.11 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.02 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/administrator/components/com_joomgallery/helpers/config.php:388
12	JoomConfig->__construct()	JROOT/administrator/components/com_joomgallery/helpers/config.php:450
11	JoomConfig::getInstance()	JROOT/components/com_joomgallery/helpers/ambit.php:145
10	JoomAmbit->__construct()	JROOT/components/com_joomgallery/helpers/ambit.php:218
9	JoomAmbit::getInstance()	JROOT/components/com_joomgallery/controller.php:69
8	JoomGalleryController->__construct()	JROOT/libraries/src/MVC/Controller/BaseController.php:313
7	Joomla\CMS\MVC\Controller\BaseController::getInstance()	JROOT/components/com_joomgallery/joomgallery.php:37
6	require_once JROOT/components/com_joomgallery/joomgallery.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: 575.46 ms After last query: 0.72 ms Query memory: 0.006 MB Memory before query: 16.967 MB

DELETE 

  FROM kez4a_joomgallery_countstop

  WHERE NOW() > date_add(cstime, interval 360000 SECOND)

Explain

EXPLAIN not possible on query: DELETE FROM kez4a_joomgallery_countstop WHERE NOW() > date_add(cstime, interval 360000 SECOND)

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
11	JDatabase->query()	JROOT/components/com_joomgallery/models/image.php:150
10	JoomGalleryModelImage->countstop()	JROOT/components/com_joomgallery/models/image.php:95
9	JoomGalleryModelImage->hit()	JROOT/components/com_joomgallery/controller.php:95
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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: 566.63 ms After last query: 0.17 ms Query memory: 0.022 MB Memory before query: 16.973 MB Rows returned: 1

SELECT COUNT(cspicid)

  FROM kez4a_joomgallery_countstop

  WHERE cssessionid = '3tLFY8vvCFkAxwjyS4gPwtkTO00crVBb' 
  AND csip = '18.97.14.87' 
  AND cspicid = 64353

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_joomgallery_countstop	NULL	ref	idx_cspicid	idx_cspicid	4	const	15	1.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/models/image.php:161
10	JoomGalleryModelImage->countstop()	JROOT/components/com_joomgallery/models/image.php:95
9	JoomGalleryModelImage->hit()	JROOT/components/com_joomgallery/controller.php:95
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.16 ms Query memory: 0.006 MB Memory before query: 16.979 MB

INSERT INTO kez4a_joomgallery_countstop
(csip, cssessionid, cspicid, cstime) 
  VALUES 
('18.97.14.87','3tLFY8vvCFkAxwjyS4gPwtkTO00crVBb',64353, NOW())

Explain

EXPLAIN not possible on query: INSERT INTO kez4a_joomgallery_countstop (csip, cssessionid, cspicid, cstime) VALUES ('18.97.14.87','3tLFY8vvCFkAxwjyS4gPwtkTO00crVBb',64353, NOW())

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
update	0.04 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.02 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/database.php:33
11	JDatabase->query()	JROOT/components/com_joomgallery/models/image.php:174
10	JoomGalleryModelImage->countstop()	JROOT/components/com_joomgallery/models/image.php:95
9	JoomGalleryModelImage->hit()	JROOT/components/com_joomgallery/controller.php:95
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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: 2.12 ms After last query: 0.65 ms Query memory: 0.029 MB Memory before query: 17.014 MB Rows returned: 27

SHOW FULL COLUMNS 
  FROM `kez4a_joomgallery`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_joomgallery/tables/joomgalleryimages.php:83
14	TableJoomgalleryImages->__construct()	JROOT/libraries/src/Table/Table.php:328
13	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:110
12	Joomla\CMS\MVC\Factory\LegacyFactory->createTable()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:392
11	Joomla\CMS\MVC\Model\BaseDatabaseModel->_createTable()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:485
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getTable()	JROOT/components/com_joomgallery/models/image.php:97
9	JoomGalleryModelImage->hit()	JROOT/components/com_joomgallery/controller.php:95
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.14 ms Query memory: 0.005 MB Memory before query: 17.053 MB

UPDATE kez4a_joomgallery

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

  WHERE `id` = '64353'

Explain

EXPLAIN not possible on query: UPDATE kez4a_joomgallery SET `hits` = (`hits` + 1) WHERE `id` = '64353'

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.03 ms
updating	0.05 ms
end	0.00 ms
query end	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
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_joomgallery/models/image.php:98
9	JoomGalleryModelImage->hit()	JROOT/components/com_joomgallery/controller.php:95
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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: 6.18 ms Query memory: 0.024 MB Memory before query: 17.637 MB Rows returned: 1

SELECT catid

  FROM kez4a_joomgallery

  WHERE id  = 64353

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_joomgallery	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.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.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/models/detail.php:497
13	JoomGalleryModelDetail->_loadImages()	JROOT/components/com_joomgallery/models/detail.php:274
12	JoomGalleryModelDetail->getImages()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_joomgallery/views/detail/view.html.php:43
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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: 3.32 ms After last query: 0.06 ms Query memory: 0.331 MB Memory before query: 17.647 MB Rows returned: 392

SELECT a.*, a.owner AS imgowner, c.metadesc AS catmetadesc, c.metakey AS catmetakey, c.allow_download as catallow_download, c.allow_comment as catallow_comment, c.allow_rating as catallow_rating,ROUND(LEAST(IF(imgvotes > 0, a.imgvotesum/a.imgvotes, 0.0), 15), 2) AS rating

  FROM kez4a_joomgallery AS a

  LEFT JOIN kez4a_joomgallery_catg AS c 
  ON c.cid = a.catid

  WHERE a.catid = 363 
  AND a.published = 1 
  AND a.approved  = 1 
  AND (a.hidden = 0 OR a.id = 64353) 
  AND a.access   IN (1,1) 
  AND c.access   IN (1,1)

  ORDER BY a.imgdate DESC,a.imgdate DESC,a.imgtitle DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	a	NULL	ref	PRIMARY,idx_catid	idx_catid	4	const	964	0.02	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.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	3.06 ms
end	0.00 ms
query end	0.02 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:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomgallery/models/detail.php:526
13	JoomGalleryModelDetail->_loadImages()	JROOT/components/com_joomgallery/models/detail.php:274
12	JoomGalleryModelDetail->getImages()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_joomgallery/views/detail/view.html.php:43
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.62 ms After last query: 0.88 ms Query memory: 0.070 MB Memory before query: 18.930 MB Rows returned: 222

SELECT c.cid, c.parent_id, c.name, c.access, c.published, c.hidden, c.owner

  FROM kez4a_joomgallery_catg AS c

  WHERE lft > 0 
  AND c.published = 1 
  AND c.access IN (1,1) 
  AND (c.password = '' OR c.cid IN (0))

  ORDER BY c.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	239	0.42	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.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.43 ms
end	0.00 ms
query end	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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomgallery/helpers/ambit.php:490
14	JoomAmbit->getCategoryStructure()	JROOT/components/com_joomgallery/models/detail.php:160
13	JoomGalleryModelDetail->getImage()	JROOT/components/com_joomgallery/models/detail.php:276
12	JoomGalleryModelDetail->getImages()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_joomgallery/views/detail/view.html.php:43
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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: 86.80 ms After last query: 0.28 ms Query memory: 0.039 MB Memory before query: 19.070 MB Rows returned: 225

SELECT catid, COUNT(id) as piccount, SUM(hits) as hitcount

  FROM kez4a_joomgallery

  WHERE approved  = 1 
  AND published = 1 
  AND hidden    = 0 
  AND access IN (1,1)

  GROUP BY catid

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_joomgallery	NULL	index	idx_catid	idx_catid	4	NULL	60230	0.02	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.01 ms
preparing	0.01 ms
executing	86.65 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomgallery/helpers/ambit.php:506
14	JoomAmbit->getCategoryStructure()	JROOT/components/com_joomgallery/models/detail.php:160
13	JoomGalleryModelDetail->getImage()	JROOT/components/com_joomgallery/models/detail.php:276
12	JoomGalleryModelDetail->getImages()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_joomgallery/views/detail/view.html.php:43
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.35 ms Query memory: 0.024 MB Memory before query: 19.131 MB Rows returned: 1

SELECT catpath

  FROM kez4a_joomgallery_catg

  WHERE cid = 363

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_joomgallery_catg	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.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/helpers/helper.php:139
15	JoomHelper::getCatPath()	JROOT/components/com_joomgallery/helpers/ambit.php:336
14	JoomAmbit->getImg()	JROOT/components/com_joomgallery/models/detail.php:167
13	JoomGalleryModelDetail->getImage()	JROOT/components/com_joomgallery/models/detail.php:276
12	JoomGalleryModelDetail->getImages()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_joomgallery/views/detail/view.html.php:43
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.13 ms After last query: 1.63 ms Query memory: 0.026 MB Memory before query: 19.368 MB Rows returned: 1

SELECT `id` 
  FROM `kez4a_users` 
  WHERE `id` = '6456'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_users	NULL	const	PRIMARY	PRIMARY	4	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.01 ms
statistics	0.02 ms
preparing	0.01 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.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:187
21	CFactory::getUser()	JROOT/plugins/joomgallery/joomdisplayjomsocial/joomdisplayjomsocial.php:34
20	plgJoomGalleryJoomDisplayJomsocial->onJoomDisplayUser()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/administrator/components/com_joomgallery/helpers/html/joomgallery.php:86
17	JHtmlJoomGallery::displayName()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_joomgallery/models/detail.php:237
13	JoomGalleryModelDetail->getImage()	JROOT/components/com_joomgallery/models/detail.php:276
12	JoomGalleryModelDetail->getImages()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_joomgallery/views/detail/view.html.php:43
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.78 ms After last query: 2.11 ms Query memory: 0.029 MB Memory before query: 19.694 MB Rows returned: 2

SHOW FULL COLUMNS 
  FROM `kez4a_community_config`

Explain

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

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.37 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
Creating tmp table	0.03 ms
executing	0.05 ms
checking permissions	0.04 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.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
30	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
29	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
28	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
27	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_community/tables/configuration.php:22
26	CommunityTableConfiguration->__construct()	JROOT/libraries/src/Table/Table.php:328
25	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_community/libraries/core.php:1091
24	CConfig::getInstance()	JROOT/components/com_community/libraries/core.php:232
23	CFactory::getConfig()	JROOT/components/com_community/libraries/user.php:135
22	CUser->init()	JROOT/components/com_community/libraries/core.php:199
21	CFactory::getUser()	JROOT/plugins/joomgallery/joomdisplayjomsocial/joomdisplayjomsocial.php:34
20	plgJoomGalleryJoomDisplayJomsocial->onJoomDisplayUser()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/administrator/components/com_joomgallery/helpers/html/joomgallery.php:86
17	JHtmlJoomGallery::displayName()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_joomgallery/models/detail.php:237
13	JoomGalleryModelDetail->getImage()	JROOT/components/com_joomgallery/models/detail.php:276
12	JoomGalleryModelDetail->getImages()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_joomgallery/views/detail/view.html.php:43
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.13 ms After last query: 0.06 ms Query memory: 0.028 MB Memory before query: 19.712 MB Rows returned: 1

SELECT *

  FROM kez4a_community_config

  WHERE `name` = 'config'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_community_config	NULL	const	PRIMARY	PRIMARY	194	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.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.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
26	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
25	Joomla\CMS\Table\Table->load()	JROOT/components/com_community/libraries/core.php:1092
24	CConfig::getInstance()	JROOT/components/com_community/libraries/core.php:232
23	CFactory::getConfig()	JROOT/components/com_community/libraries/user.php:135
22	CUser->init()	JROOT/components/com_community/libraries/core.php:199
21	CFactory::getUser()	JROOT/plugins/joomgallery/joomdisplayjomsocial/joomdisplayjomsocial.php:34
20	plgJoomGalleryJoomDisplayJomsocial->onJoomDisplayUser()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/administrator/components/com_joomgallery/helpers/html/joomgallery.php:86
17	JHtmlJoomGallery::displayName()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_joomgallery/models/detail.php:237
13	JoomGalleryModelDetail->getImage()	JROOT/components/com_joomgallery/models/detail.php:276
12	JoomGalleryModelDetail->getImages()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_joomgallery/views/detail/view.html.php:43
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.30 ms After last query: 2.25 ms Query memory: 0.027 MB Memory before query: 20.055 MB Rows returned: 1

SELECT  	a.`userid` as _userid , 	a.`status` as _status , 	a.`points`	as _points, 	a.`posted_on` as _posted_on, 	a.`avatar`	as _avatar , 	a.`cover`	as _cover , 	a.`thumb`	as _thumb , 	a.`invite`	as _invite, 	a.`params`	as _cparams,  	a.`view`	as _view,  a.`friends` as _friends,  a.`pages` as _pages,  a.`groups` as _groups,  a.`events` as _events,  a.`friendcount` as _friendcount,  a.`alias` as _alias,  a.`profile_id` as _profile_id,  a.`storage` as _storage,  a.`watermark_hash` as _watermark_hash,  a.`search_email` as _search_email,  a.`longitude` as longitude,  a.`latitude` as latitude,  a.`default_avatar` as _defaultAvatar,  a.`usergroup` as _usergroup,  s.`userid` as _isonline, u.*  
  FROM `kez4a_community_users` as a  
  LEFT JOIN `kez4a_users` u  
  ON u.`id`=a.`userid` 
  LEFT 
  OUTER JOIN `kez4a_session` s  
  ON s.`userid`=a.`userid` 
  AND s.`client_id` !='1' 
  WHERE a.`userid`='6456'

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	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	s	NULL	ref	userid,client_id_guest	userid	5	const	1	100.00	Using where

Profile

Status	Duration
starting	0.06 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.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.08 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
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
23	JDatabaseDriver->loadObject()	JROOT/components/com_community/libraries/user.php:176
22	CUser->init()	JROOT/components/com_community/libraries/core.php:199
21	CFactory::getUser()	JROOT/plugins/joomgallery/joomdisplayjomsocial/joomdisplayjomsocial.php:34
20	plgJoomGalleryJoomDisplayJomsocial->onJoomDisplayUser()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/administrator/components/com_joomgallery/helpers/html/joomgallery.php:86
17	JHtmlJoomGallery::displayName()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_joomgallery/models/detail.php:237
13	JoomGalleryModelDetail->getImage()	JROOT/components/com_joomgallery/models/detail.php:276
12	JoomGalleryModelDetail->getImages()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_joomgallery/views/detail/view.html.php:43
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.86 ms After last query: 0.38 ms Query memory: 0.031 MB Memory before query: 20.116 MB Rows returned: 16

SHOW FULL COLUMNS 
  FROM `kez4a_community_profiles`

Explain

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

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.30 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
Creating tmp table	0.03 ms
executing	0.04 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.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.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
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
27	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
26	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
25	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_community/tables/multiprofile.php:33
24	CTableMultiProfile->__construct()	JROOT/libraries/src/Table/Table.php:328
23	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_community/libraries/user.php:843
22	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:200
21	CFactory::getUser()	JROOT/plugins/joomgallery/joomdisplayjomsocial/joomdisplayjomsocial.php:34
20	plgJoomGalleryJoomDisplayJomsocial->onJoomDisplayUser()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/administrator/components/com_joomgallery/helpers/html/joomgallery.php:86
17	JHtmlJoomGallery::displayName()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_joomgallery/models/detail.php:237
13	JoomGalleryModelDetail->getImage()	JROOT/components/com_joomgallery/models/detail.php:276
12	JoomGalleryModelDetail->getImages()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_joomgallery/views/detail/view.html.php:43
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.84 ms After last query: 0.82 ms Query memory: 0.026 MB Memory before query: 20.295 MB Rows returned: 3

SELECT `id` 
  FROM `kez4a_menu` 
  WHERE `link` LIKE '%option=com_community&view=profile%' 
  AND `published`='1' 
  AND `menutype`!='jomsocial' 
  AND `type`='component'

Explain

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

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.57 ms
end	0.01 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
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
23	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1415
22	CRoute::_getViewItemid()	JROOT/components/com_community/libraries/core.php:1325
21	CRoute::_()	JROOT/plugins/joomgallery/joomdisplayjomsocial/joomdisplayjomsocial.php:43
20	plgJoomGalleryJoomDisplayJomsocial->onJoomDisplayUser()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/administrator/components/com_joomgallery/helpers/html/joomgallery.php:86
17	JHtmlJoomGallery::displayName()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_joomgallery/models/detail.php:237
13	JoomGalleryModelDetail->getImage()	JROOT/components/com_joomgallery/models/detail.php:276
12	JoomGalleryModelDetail->getImages()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_joomgallery/views/detail/view.html.php:43
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.74 ms After last query: 2.53 ms Query memory: 0.025 MB Memory before query: 20.545 MB Rows returned: 1

SELECT id

  FROM kez4a_menu

  WHERE link LIKE '%option=com_joomgallery&view=gallery%'

Explain

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

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.54 ms
end	0.01 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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/helpers/routing.php:86
19	JoomRouting::checkItemid()	JROOT/components/com_joomgallery/router.php:150
18	JoomGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_joomgallery/views/detail/view.html.php:104
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.19 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 20.555 MB Rows returned: 1

SELECT alias

  FROM kez4a_joomgallery_catg

  WHERE cid = 18

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_joomgallery_catg	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.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.01 ms
end	0.00 ms
query end	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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/router.php:308
18	JoomGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_joomgallery/views/detail/view.html.php:108
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.13 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 20.566 MB Rows returned: 1

Duplicate queries: #49 #51

SELECT alias

  FROM kez4a_joomgallery_catg

  WHERE cid = 363

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_joomgallery_catg	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.01 ms
optimizing	0.01 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.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/router.php:308
18	JoomGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_joomgallery/views/detail/view.html.php:108
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.04 ms After last query: 0.93 ms Query memory: 0.076 MB Memory before query: 20.676 MB Rows returned: 20

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down

  FROM kez4a_modules AS m

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

  LEFT JOIN kez4a_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.access IN (1,1) 
  AND m.client_id = 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	range	published,newsfeeds	published	5	NULL	38	10.00	Using index condition; Using where; Using filesort
1	SIMPLE	am	NULL	eq_ref	PRIMARY	PRIMARY	4	demodesign_2021.m.id	1	100.00	Using index condition
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	demodesign_2021.m.module,const	1	10.00	Using index condition; Using where

Profile

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.00 ms
starting	0.01 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.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.72 ms
end	0.01 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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:168
18	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:60
17	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:366
14	Joomla\CMS\Helper\_ModuleHelper::load()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:87
13	Joomla\CMS\Helper\_ModuleHelper::getModules()	JROOT/components/com_joomgallery/helpers/helper.php:497
12	JoomHelper::getModules()	JROOT/components/com_joomgallery/helpers/helper.php:533
11	JoomHelper::getRenderedModules()	JROOT/components/com_joomgallery/views/detail/view.html.php:169
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.17 ms After last query: 6.19 ms Query memory: 0.025 MB Memory before query: 21.431 MB Rows returned: 1

SELECT catid, alias

  FROM kez4a_joomgallery

  WHERE id = 64355

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_joomgallery	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.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.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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
19	JDatabaseDriver->loadAssoc()	JROOT/components/com_joomgallery/router.php:325
18	JoomGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_joomgallery/views/detail/view.html.php:304
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.11 ms After last query: 0.03 ms Query memory: 0.025 MB Memory before query: 21.441 MB Rows returned: 1

Duplicate queries: #46 #51

SELECT alias

  FROM kez4a_joomgallery_catg

  WHERE cid = 363

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_joomgallery_catg	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.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/router.php:331
18	JoomGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_joomgallery/views/detail/view.html.php:304
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.13 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 21.453 MB Rows returned: 1

SELECT catid, alias

  FROM kez4a_joomgallery

  WHERE id = 64345

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_joomgallery	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.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
19	JDatabaseDriver->loadAssoc()	JROOT/components/com_joomgallery/router.php:325
18	JoomGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_joomgallery/views/detail/view.html.php:314
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.10 ms After last query: 0.03 ms Query memory: 0.025 MB Memory before query: 21.463 MB Rows returned: 1

Duplicate queries: #46 #49

SELECT alias

  FROM kez4a_joomgallery_catg

  WHERE cid = 363

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_joomgallery_catg	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.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.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/router.php:331
18	JoomGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_joomgallery/views/detail/view.html.php:314
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.11 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 21.472 MB Rows returned: 0

SELECT *, 500 AS maxzindex

  FROM kez4a_joomgallery_nameshields

  WHERE npicid = 64353

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.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.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	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:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomgallery/models/detail.php:561
13	JoomGalleryModelDetail->_loadNametags()	JROOT/components/com_joomgallery/models/detail.php:303
12	JoomGalleryModelDetail->getNametags()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_joomgallery/views/detail/view.html.php:329
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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: 3.52 ms Query memory: 0.025 MB Memory before query: 21.975 MB Rows returned: 0

SELECT *

  FROM kez4a_jlexreview_blacklist

  WHERE method=0 
  AND ip_address='18.97.14.87' 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_jlexreview_blacklist	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.00 ms
System lock	0.01 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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jlexreview/libs/helper.php:94
16	JLexReviewHelperAdmin::getConfig()	JROOT/components/com_jlexreview/load.php:20
15	JLexReviewLoad::init()	JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php:348
14	include JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:701
13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:230
12	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/components/com_joomgallery/view.php:166
11	JoomGalleryView->display()	JROOT/components/com_joomgallery/views/detail/view.html.php:1143
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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: 2.25 ms Query memory: 0.026 MB Memory before query: 22.357 MB Rows returned: 0

Duplicate queries: #58

SELECT `id` 
  FROM `kez4a_users` 
  WHERE `id` = '-1'

Explain

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

Profile

Status	Duration
starting	0.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.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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
21	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:187
20	CFactory::getUser()	JROOT/components/com_jlexreview/libs/profile.php:316
19	JLexReviewProfile->_3rd()	JROOT/components/com_jlexreview/libs/profile.php:171
18	JLexReviewProfile->getUser()	JROOT/components/com_jlexreview/views/reviews/view.html.php:237
17	JLexReviewViewReviews->render()	JROOT/components/com_jlexreview/controllers/reviews.php:78
16	JLexReviewControllerReviews->display()	JROOT/components/com_jlexreview/load.php:48
15	JLexReviewLoad::init()	JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php:348
14	include JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:701
13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:230
12	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/components/com_joomgallery/view.php:166
11	JoomGalleryView->display()	JROOT/components/com_joomgallery/views/detail/view.html.php:1143
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.21 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 22.370 MB Rows returned: 0

SELECT  	a.`userid` as _userid , 	a.`status` as _status , 	a.`points`	as _points, 	a.`posted_on` as _posted_on, 	a.`avatar`	as _avatar , 	a.`cover`	as _cover , 	a.`thumb`	as _thumb , 	a.`invite`	as _invite, 	a.`params`	as _cparams,  	a.`view`	as _view,  a.`friends` as _friends,  a.`pages` as _pages,  a.`groups` as _groups,  a.`events` as _events,  a.`friendcount` as _friendcount,  a.`alias` as _alias,  a.`profile_id` as _profile_id,  a.`storage` as _storage,  a.`watermark_hash` as _watermark_hash,  a.`search_email` as _search_email,  a.`longitude` as longitude,  a.`latitude` as latitude,  a.`default_avatar` as _defaultAvatar,  a.`usergroup` as _usergroup,  s.`userid` as _isonline, u.*  
  FROM `kez4a_community_users` as a  
  LEFT JOIN `kez4a_users` u  
  ON u.`id`=a.`userid` 
  LEFT 
  OUTER JOIN `kez4a_session` s  
  ON s.`userid`=a.`userid` 
  AND s.`client_id` !='1' 
  WHERE a.`userid`='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.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.03 ms
init	0.00 ms
System lock	0.00 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.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
22	JDatabaseDriver->loadObject()	JROOT/components/com_community/libraries/user.php:176
21	CUser->init()	JROOT/components/com_community/libraries/core.php:199
20	CFactory::getUser()	JROOT/components/com_jlexreview/libs/profile.php:316
19	JLexReviewProfile->_3rd()	JROOT/components/com_jlexreview/libs/profile.php:171
18	JLexReviewProfile->getUser()	JROOT/components/com_jlexreview/views/reviews/view.html.php:237
17	JLexReviewViewReviews->render()	JROOT/components/com_jlexreview/controllers/reviews.php:78
16	JLexReviewControllerReviews->display()	JROOT/components/com_jlexreview/load.php:48
15	JLexReviewLoad::init()	JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php:348
14	include JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:701
13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:230
12	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/components/com_joomgallery/view.php:166
11	JoomGalleryView->display()	JROOT/components/com_joomgallery/views/detail/view.html.php:1143
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.13 ms After last query: 1.16 ms Query memory: 0.028 MB Memory before query: 22.486 MB Rows returned: 1

SELECT `id` 
  FROM `kez4a_community_fields` 
  WHERE `fieldcode`='FIELD_GENDER'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_community_fields	NULL	ref	fieldcode	fieldcode	767	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.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	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
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
25	JDatabaseDriver->loadResult()	JROOT/components/com_community/models/profile.php:823
24	CommunityModelProfile->_getgenderId()	JROOT/components/com_community/models/profile.php:797
23	CommunityModelProfile->getGender()	JROOT/components/com_community/libraries/user.php:721
22	CUser->_getGender()	JROOT/components/com_community/libraries/user.php:875
21	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:200
20	CFactory::getUser()	JROOT/components/com_jlexreview/libs/profile.php:316
19	JLexReviewProfile->_3rd()	JROOT/components/com_jlexreview/libs/profile.php:171
18	JLexReviewProfile->getUser()	JROOT/components/com_jlexreview/views/reviews/view.html.php:237
17	JLexReviewViewReviews->render()	JROOT/components/com_jlexreview/controllers/reviews.php:78
16	JLexReviewControllerReviews->display()	JROOT/components/com_jlexreview/load.php:48
15	JLexReviewLoad::init()	JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php:348
14	include JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:701
13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:230
12	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/components/com_joomgallery/view.php:166
11	JoomGalleryView->display()	JROOT/components/com_joomgallery/views/detail/view.html.php:1143
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.10 ms After last query: 0.05 ms Query memory: 0.027 MB Memory before query: 22.497 MB Rows returned: 0

SELECT `value` 
  FROM `kez4a_community_fields_values` 
  WHERE `field_id` = '2' 
  AND `user_id` = '0'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_community_fields_values	NULL	ref	field_id,user_id,idx_user_fieldid	idx_user_fieldid	8	const,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.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
end	0.00 ms
query end	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
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
24	JDatabaseDriver->loadResult()	JROOT/components/com_community/models/profile.php:806
23	CommunityModelProfile->getGender()	JROOT/components/com_community/libraries/user.php:721
22	CUser->_getGender()	JROOT/components/com_community/libraries/user.php:875
21	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:200
20	CFactory::getUser()	JROOT/components/com_jlexreview/libs/profile.php:316
19	JLexReviewProfile->_3rd()	JROOT/components/com_jlexreview/libs/profile.php:171
18	JLexReviewProfile->getUser()	JROOT/components/com_jlexreview/views/reviews/view.html.php:237
17	JLexReviewViewReviews->render()	JROOT/components/com_jlexreview/controllers/reviews.php:78
16	JLexReviewControllerReviews->display()	JROOT/components/com_jlexreview/load.php:48
15	JLexReviewLoad::init()	JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php:348
14	include JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:701
13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:230
12	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/components/com_joomgallery/view.php:166
11	JoomGalleryView->display()	JROOT/components/com_joomgallery/views/detail/view.html.php:1143
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.11 ms After last query: 0.82 ms Query memory: 0.029 MB Memory before query: 22.562 MB Rows returned: 0

Duplicate queries: #54

SELECT `id` 
  FROM `kez4a_users` 
  WHERE `id` = '-1'

Explain

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

Profile

Status	Duration
starting	0.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.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.00 ms

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
30	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:187
29	CFactory::getUser()	JROOT/components/com_community/router.php:25
28	CommunityBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
27	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
26	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
25	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
24	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
23	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
22	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
21	Joomla\CMS\Router\Route::_()	JROOT/components/com_community/libraries/core.php:1392
20	CRoute::_()	JROOT/components/com_jlexreview/libs/profile.php:317
19	JLexReviewProfile->_3rd()	JROOT/components/com_jlexreview/libs/profile.php:171
18	JLexReviewProfile->getUser()	JROOT/components/com_jlexreview/views/reviews/view.html.php:237
17	JLexReviewViewReviews->render()	JROOT/components/com_jlexreview/controllers/reviews.php:78
16	JLexReviewControllerReviews->display()	JROOT/components/com_jlexreview/load.php:48
15	JLexReviewLoad::init()	JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php:348
14	include JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:701
13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:230
12	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/components/com_joomgallery/view.php:166
11	JoomGalleryView->display()	JROOT/components/com_joomgallery/views/detail/view.html.php:1143
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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: 12.14 ms After last query: 0.11 ms Query memory: 0.026 MB Memory before query: 22.576 MB Rows returned: 1

SELECT *

  FROM kez4a_jlexreview_entry

  WHERE object='joomlagallery' 
  AND object_id='64353'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_jlexreview_entry	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	7644	1.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.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	12.00 ms
end	0.01 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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/components/com_jlexreview/models/reviews.php:41
19	JLexReviewModelReviews->getItem()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
18	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_jlexreview/views/reviews/view.html.php:242
17	JLexReviewViewReviews->render()	JROOT/components/com_jlexreview/controllers/reviews.php:78
16	JLexReviewControllerReviews->display()	JROOT/components/com_jlexreview/load.php:48
15	JLexReviewLoad::init()	JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php:348
14	include JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:701
13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:230
12	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/components/com_joomgallery/view.php:166
11	JoomGalleryView->display()	JROOT/components/com_joomgallery/views/detail/view.html.php:1143
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.13 ms After last query: 0.20 ms Query memory: 0.026 MB Memory before query: 22.593 MB Rows returned: 1

SELECT params

  FROM kez4a_jlexreview_form

  WHERE id='1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_jlexreview_form	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.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 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.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/components/com_jlexreview/models/reviews.php:173
19	JLexReviewModelReviews->getItem()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
18	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_jlexreview/views/reviews/view.html.php:242
17	JLexReviewViewReviews->render()	JROOT/components/com_jlexreview/controllers/reviews.php:78
16	JLexReviewControllerReviews->display()	JROOT/components/com_jlexreview/load.php:48
15	JLexReviewLoad::init()	JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php:348
14	include JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:701
13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:230
12	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/components/com_joomgallery/view.php:166
11	JoomGalleryView->display()	JROOT/components/com_joomgallery/views/detail/view.html.php:1143
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.43 ms After last query: 0.08 ms Query memory: 0.026 MB Memory before query: 22.608 MB Rows returned: 1

SELECT COUNT(id)

  FROM kez4a_jlexreview

  WHERE entry_id='5809' 
  AND ip_address='18.97.14.87'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_jlexreview	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	862	1.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.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.32 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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/components/com_jlexreview/models/reviews.php:211
19	JLexReviewModelReviews->getItem()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
18	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_jlexreview/views/reviews/view.html.php:242
17	JLexReviewViewReviews->render()	JROOT/components/com_jlexreview/controllers/reviews.php:78
16	JLexReviewControllerReviews->display()	JROOT/components/com_jlexreview/load.php:48
15	JLexReviewLoad::init()	JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php:348
14	include JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:701
13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:230
12	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/components/com_joomgallery/view.php:166
11	JoomGalleryView->display()	JROOT/components/com_joomgallery/views/detail/view.html.php:1143
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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: 0.19 ms Query memory: 0.026 MB Memory before query: 22.622 MB Rows returned: 0

SELECT ROUND(rating) star_rating, COUNT(id) count_rating

  FROM kez4a_jlexreview

  WHERE entry_id='5809' 
  AND published=1 
  AND rating>0

  GROUP BY ROUND(rating)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_jlexreview	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	862	0.33	Using where; Using temporary

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
Creating tmp table	0.02 ms
executing	0.26 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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_jlexreview/models/reviews.php:1001
20	JLexReviewModelReviews->getStars()	JROOT/components/com_jlexreview/models/reviews.php:967
19	JLexReviewModelReviews->getSummary()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
18	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_jlexreview/views/reviews/view.html.php:290
17	JLexReviewViewReviews->render()	JROOT/components/com_jlexreview/controllers/reviews.php:78
16	JLexReviewControllerReviews->display()	JROOT/components/com_jlexreview/load.php:48
15	JLexReviewLoad::init()	JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php:348
14	include JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:701
13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:230
12	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/components/com_joomgallery/view.php:166
11	JoomGalleryView->display()	JROOT/components/com_joomgallery/views/detail/view.html.php:1143
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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: 2.62 ms After last query: 0.07 ms Query memory: 0.026 MB Memory before query: 22.636 MB Rows returned: 0

SELECT f.field_id id, SUM(f.field_value*1) total_point, SUM(IF(f.field_value=0,0,1)) total_rating

  FROM kez4a_jlexreview_fields f

  LEFT JOIN kez4a_jlexreview r 
  ON r.id=f.review_id

  WHERE f.field_id IN (4,6,7,8) 
  AND r.id IS NOT NULL 
  AND r.published=1 
  AND f.field_value>0 
  AND f.entry_id='5809'

  GROUP BY f.field_id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3460	1.33	Using where; Using temporary
1	SIMPLE	r	NULL	eq_ref	PRIMARY	PRIMARY	4	demodesign_2021.f.review_id	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
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.02 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
executing	2.46 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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_jlexreview/models/reviews.php:1068
20	JLexReviewModelReviews->getCriterias()	JROOT/components/com_jlexreview/models/reviews.php:968
19	JLexReviewModelReviews->getSummary()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
18	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_jlexreview/views/reviews/view.html.php:290
17	JLexReviewViewReviews->render()	JROOT/components/com_jlexreview/controllers/reviews.php:78
16	JLexReviewControllerReviews->display()	JROOT/components/com_jlexreview/load.php:48
15	JLexReviewLoad::init()	JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php:348
14	include JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:701
13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:230
12	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/components/com_joomgallery/view.php:166
11	JoomGalleryView->display()	JROOT/components/com_joomgallery/views/detail/view.html.php:1143
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.90 ms After last query: 0.13 ms Query memory: 0.026 MB Memory before query: 22.649 MB Rows returned: 0

SELECT SQL_CALC_FOUND_ROWS r.*,r.author_name,IF(r.created_by=0,r.author_email,u.email) author_email

  FROM kez4a_jlexreview AS r

  LEFT JOIN kez4a_users AS u 
  ON u.id=r.created_by

  WHERE r.entry_id='5809' 
  AND (r.published=1 OR (r.created_by=0 
  AND r.ip_address='18.97.14.87')) 
  AND r.created<='2025-05-12 05:19:36'

  ORDER BY r.featured DESC,r.created DESC 
  LIMIT 8

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	862	0.36	Using where; Using filesort
1	SIMPLE	u	NULL	eq_ref	PRIMARY	PRIMARY	4	demodesign_2021.r.created_by	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.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.75 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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_jlexreview/models/reviews.php:620
19	JLexReviewModelReviews->getReviews()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
18	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_jlexreview/views/reviews/view.html.php:295
17	JLexReviewViewReviews->render()	JROOT/components/com_jlexreview/controllers/reviews.php:78
16	JLexReviewControllerReviews->display()	JROOT/components/com_jlexreview/load.php:48
15	JLexReviewLoad::init()	JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php:348
14	include JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:701
13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:230
12	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/components/com_joomgallery/view.php:166
11	JoomGalleryView->display()	JROOT/components/com_joomgallery/views/detail/view.html.php:1143
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.05 ms After last query: 0.04 ms Query memory: 0.031 MB Memory before query: 22.668 MB Rows returned: 1

Duplicate queries: #70 #76

SELECT FOUND_ROWS()

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 tables used

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.00 ms
optimizing	0.00 ms
executing	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/components/com_jlexreview/models/reviews.php:621
19	JLexReviewModelReviews->getReviews()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
18	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_jlexreview/views/reviews/view.html.php:295
17	JLexReviewViewReviews->render()	JROOT/components/com_jlexreview/controllers/reviews.php:78
16	JLexReviewControllerReviews->display()	JROOT/components/com_jlexreview/load.php:48
15	JLexReviewLoad::init()	JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php:348
14	include JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:701
13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:230
12	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/components/com_joomgallery/view.php:166
11	JoomGalleryView->display()	JROOT/components/com_joomgallery/views/detail/view.html.php:1143
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.17 ms After last query: 3.95 ms Query memory: 0.025 MB Memory before query: 23.320 MB Rows returned: 0

SELECT *

  FROM kez4a_jlexcomment_blacklist

  WHERE ((method=3 
  AND '18.97.14.87' LIKE REPLACE(method_value, "*", "%")) OR (method=3 
  AND method_value='18.97.14.87') OR (method=3 
  AND method_value='18.97.14.*'))

  ORDER BY method ASC 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_jlexcomment_blacklist	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	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
Opening tables	0.02 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.02 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/components/com_jlexcomment/libraries/helper.php:71
17	JLexCommentHelper::getConfig()	JROOT/components/com_jlexcomment/controller.php:32
16	JLexCommentController->display()	JROOT/components/com_jlexcomment/load.php:51
15	JLexCommentLoader::init()	JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php:585
14	include JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:701
13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:230
12	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/components/com_joomgallery/view.php:166
11	JoomGalleryView->display()	JROOT/components/com_joomgallery/views/detail/view.html.php:1143
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.02 ms After last query: 2.98 ms Query memory: 0.031 MB Memory before query: 23.611 MB Rows returned: 15

SHOW FULL COLUMNS 
  FROM `kez4a_jlexcomment_obj`

Explain

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

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.38 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.03 ms
executing	0.05 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 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.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
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
27	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
26	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
25	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jlexcomment/tables/object.php:44
24	TableCmObject->__construct()	JROOT/libraries/src/Table/Table.php:328
23	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:110
22	Joomla\CMS\MVC\Factory\LegacyFactory->createTable()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:392
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_createTable()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:485
20	Joomla\CMS\MVC\Model\BaseDatabaseModel->getTable()	JROOT/components/com_jlexcomment/models/items.php:90
19	JLexCommentModelItems->getComments()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
18	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_jlexcomment/views/items/view.html.php:46
17	JLexCommentViewItems->render()	JROOT/components/com_jlexcomment/controller.php:212
16	JLexCommentController->display()	JROOT/components/com_jlexcomment/load.php:51
15	JLexCommentLoader::init()	JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php:585
14	include JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:701
13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:230
12	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/components/com_joomgallery/view.php:166
11	JoomGalleryView->display()	JROOT/components/com_joomgallery/views/detail/view.html.php:1143
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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: 55.39 ms After last query: 0.12 ms Query memory: 0.026 MB Memory before query: 23.642 MB Rows returned: 1

SELECT *

  FROM kez4a_jlexcomment_obj

  WHERE `com_name` = 'joomgallery' 
  AND `com_key` = '64353'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_jlexcomment_obj	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	61957	1.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.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	55.22 ms
end	0.01 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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
20	Joomla\CMS\Table\Table->load()	JROOT/components/com_jlexcomment/models/items.php:93
19	JLexCommentModelItems->getComments()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
18	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_jlexcomment/views/items/view.html.php:46
17	JLexCommentViewItems->render()	JROOT/components/com_jlexcomment/controller.php:212
16	JLexCommentController->display()	JROOT/components/com_jlexcomment/load.php:51
15	JLexCommentLoader::init()	JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php:585
14	include JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:701
13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:230
12	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/components/com_joomgallery/view.php:166
11	JoomGalleryView->display()	JROOT/components/com_joomgallery/views/detail/view.html.php:1143
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.59 ms After last query: 0.21 ms Query memory: 0.027 MB Memory before query: 23.655 MB Rows returned: 1

SELECT SQL_CALC_FOUND_ROWS cm.*,u.username,u.name screen_name, u.email user_email,0 isOnline,IF(vote.point=NULL,0,vote.point*1) voted,sticker.path2file sk_path2file,cm2.guest_name AS guest_name2, cm2.created_by AS created_by2

  FROM kez4a_jlexcomment AS cm

  LEFT JOIN kez4a_users AS u 
  ON cm.created_by=u.id

  LEFT JOIN kez4a_jlexcomment_vote AS vote 
  ON (vote.comment_id=cm.id 
  AND vote.ip_address='18.97.14.87')

  LEFT JOIN kez4a_jlexcomment_sticker AS sticker 
  ON(sticker.id=cm.sticker_id 
  AND sticker.published=1) 

  LEFT JOIN kez4a_jlexcomment cm2 
  ON cm.parent_id=cm2.id

  WHERE cm.obj_id=54999 
  AND (cm.published=1 OR (cm.created_by=0 
  AND cm.ip_address='18.97.14.87')) 
  AND cm.root_parent_id=0 
  AND cm.created_time<='2025-05-12 05:19:36'

  GROUP BY cm.id

  ORDER BY cm.featured DESC,cm.created_time ASC 
  LIMIT 35

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cm	NULL	ref	PRIMARY,idx_obj,idx_pid,idx_rid,idx_created,idx_createdby,idx_published,idx_ip,idx_language	idx_obj	4	const	1	12.50	Using where; Using temporary; Using filesort
1	SIMPLE	u	NULL	eq_ref	PRIMARY	PRIMARY	4	demodesign_2021.cm.created_by	1	100.00	Using where
1	SIMPLE	vote	NULL	ref	idx_cmid,idx_ip	idx_ip	137	const	1	100.00	Using where
1	SIMPLE	sticker	NULL	eq_ref	PRIMARY	PRIMARY	4	demodesign_2021.cm.sticker_id	1	100.00	Using where
1	SIMPLE	cm2	NULL	eq_ref	PRIMARY	PRIMARY	4	demodesign_2021.cm.parent_id	1	100.00	NULL

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
Opening tables	0.06 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.15 ms
preparing	0.02 ms
Creating tmp table	0.05 ms
executing	0.10 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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_jlexcomment/models/items.php:311
19	JLexCommentModelItems->getComments()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
18	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_jlexcomment/views/items/view.html.php:46
17	JLexCommentViewItems->render()	JROOT/components/com_jlexcomment/controller.php:212
16	JLexCommentController->display()	JROOT/components/com_jlexcomment/load.php:51
15	JLexCommentLoader::init()	JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php:585
14	include JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:701
13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:230
12	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/components/com_joomgallery/view.php:166
11	JoomGalleryView->display()	JROOT/components/com_joomgallery/views/detail/view.html.php:1143
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.06 ms After last query: 0.05 ms Query memory: 0.026 MB Memory before query: 23.668 MB Rows returned: 1

Duplicate queries: #65 #76

SELECT FOUND_ROWS()

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 tables used

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.00 ms
optimizing	0.00 ms
executing	0.00 ms
end	0.00 ms
query end	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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/components/com_jlexcomment/models/items.php:314
19	JLexCommentModelItems->getComments()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
18	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_jlexcomment/views/items/view.html.php:46
17	JLexCommentViewItems->render()	JROOT/components/com_jlexcomment/controller.php:212
16	JLexCommentController->display()	JROOT/components/com_jlexcomment/load.php:51
15	JLexCommentLoader::init()	JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php:585
14	include JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:701
13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:230
12	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/components/com_joomgallery/view.php:166
11	JoomGalleryView->display()	JROOT/components/com_joomgallery/views/detail/view.html.php:1143
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.10 ms After last query: 0.72 ms Query memory: 0.027 MB Memory before query: 23.719 MB Rows returned: 3

SELECT regexClause,replaceClause,group_cid

  FROM kez4a_jlexcomment_replacer

  WHERE published = 1

Explain

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

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.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
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/components/com_jlexcomment/models/items.php:705
21	JLexCommentModelItems->_getReplaceClauses()	JROOT/components/com_jlexcomment/models/items.php:514
20	JLexCommentModelItems->_formatComment()	JROOT/components/com_jlexcomment/models/items.php:346
19	JLexCommentModelItems->getComments()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
18	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_jlexcomment/views/items/view.html.php:46
17	JLexCommentViewItems->render()	JROOT/components/com_jlexcomment/controller.php:212
16	JLexCommentController->display()	JROOT/components/com_jlexcomment/load.php:51
15	JLexCommentLoader::init()	JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php:585
14	include JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:701
13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:230
12	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/components/com_joomgallery/view.php:166
11	JoomGalleryView->display()	JROOT/components/com_joomgallery/views/detail/view.html.php:1143
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.09 ms After last query: 0.05 ms Query memory: 0.026 MB Memory before query: 23.734 MB Rows returned: 1

SELECT group_id

  FROM kez4a_user_usergroup_map

  WHERE user_id = 6456

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_user_usergroup_map	NULL	ref	PRIMARY	PRIMARY	4	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.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
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
22	JDatabaseDriver->loadColumn()	JROOT/components/com_jlexcomment/models/items.php:689
21	JLexCommentModelItems->_getUserGroups()	JROOT/components/com_jlexcomment/models/items.php:517
20	JLexCommentModelItems->_formatComment()	JROOT/components/com_jlexcomment/models/items.php:346
19	JLexCommentModelItems->getComments()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
18	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_jlexcomment/views/items/view.html.php:46
17	JLexCommentViewItems->render()	JROOT/components/com_jlexcomment/controller.php:212
16	JLexCommentController->display()	JROOT/components/com_jlexcomment/load.php:51
15	JLexCommentLoader::init()	JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php:585
14	include JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:701
13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:230
12	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/components/com_joomgallery/view.php:166
11	JoomGalleryView->display()	JROOT/components/com_joomgallery/views/detail/view.html.php:1143
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.10 ms Query memory: 0.027 MB Memory before query: 23.745 MB Rows returned: 1

SELECT *

  FROM kez4a_jlexcomment_media

  WHERE comment_id=53569

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_jlexcomment_media	NULL	ref	idx_cmid	idx_cmid	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.02 ms
preparing	0.00 ms
executing	0.03 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
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/components/com_jlexcomment/models/items.php:750
21	JLexCommentModelItems->_getMedia()	JROOT/components/com_jlexcomment/models/items.php:633
20	JLexCommentModelItems->_formatComment()	JROOT/components/com_jlexcomment/models/items.php:346
19	JLexCommentModelItems->getComments()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
18	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_jlexcomment/views/items/view.html.php:46
17	JLexCommentViewItems->render()	JROOT/components/com_jlexcomment/controller.php:212
16	JLexCommentController->display()	JROOT/components/com_jlexcomment/load.php:51
15	JLexCommentLoader::init()	JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php:585
14	include JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:701
13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:230
12	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/components/com_joomgallery/view.php:166
11	JoomGalleryView->display()	JROOT/components/com_joomgallery/views/detail/view.html.php:1143
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.09 ms After last query: 0.13 ms Query memory: 0.026 MB Memory before query: 23.751 MB Rows returned: 1

SELECT `cm_i_count_active` 
  FROM kez4a_jlexcomment_obj 
  WHERE id=54999 
  AND published=1 
  LIMIT 0, 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_jlexcomment_obj	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.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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/components/com_jlexcomment/models/items.php:905
19	JLexCommentModelItems->getTotalComment()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
18	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_jlexcomment/views/items/view.html.php:53
17	JLexCommentViewItems->render()	JROOT/components/com_jlexcomment/controller.php:212
16	JLexCommentController->display()	JROOT/components/com_jlexcomment/load.php:51
15	JLexCommentLoader::init()	JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php:585
14	include JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:701
13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:230
12	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/components/com_joomgallery/view.php:166
11	JoomGalleryView->display()	JROOT/components/com_joomgallery/views/detail/view.html.php:1143
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.19 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 23.765 MB Rows returned: 1

SELECT SQL_CALC_FOUND_ROWS u.id, u.name, u.username, u.email

  FROM kez4a_jlexcomment cm

  INNER JOIN kez4a_users u 
  ON cm.created_by=u.id

  WHERE cm.created_by > 0 
  AND cm.published=1 
  AND cm.obj_id=54999

  GROUP BY cm.created_by

  ORDER BY cm.created_time DESC 
  LIMIT 20

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cm	NULL	ref	idx_obj,idx_createdby,idx_published	idx_obj	4	const	1	25.00	Using where; Using temporary; Using filesort
1	SIMPLE	u	NULL	eq_ref	PRIMARY	PRIMARY	4	demodesign_2021.cm.created_by	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
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.04 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
executing	0.03 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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_jlexcomment/models/items.php:865
19	JLexCommentModelItems->getPeoples()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
18	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_jlexcomment/views/items/view.html.php:55
17	JLexCommentViewItems->render()	JROOT/components/com_jlexcomment/controller.php:212
16	JLexCommentController->display()	JROOT/components/com_jlexcomment/load.php:51
15	JLexCommentLoader::init()	JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php:585
14	include JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:701
13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:230
12	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/components/com_joomgallery/view.php:166
11	JoomGalleryView->display()	JROOT/components/com_joomgallery/views/detail/view.html.php:1143
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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.05 ms After last query: 0.03 ms Query memory: 0.026 MB Memory before query: 23.776 MB Rows returned: 1

Duplicate queries: #65 #70

SELECT FOUND_ROWS()

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 tables used

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.00 ms
optimizing	0.00 ms
executing	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/components/com_jlexcomment/models/items.php:867
19	JLexCommentModelItems->getPeoples()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
18	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_jlexcomment/views/items/view.html.php:55
17	JLexCommentViewItems->render()	JROOT/components/com_jlexcomment/controller.php:212
16	JLexCommentController->display()	JROOT/components/com_jlexcomment/load.php:51
15	JLexCommentLoader::init()	JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php:585
14	include JROOT/templates/ja_focus/html/com_joomgallery/detail/bootone.php	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:701
13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:230
12	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/components/com_joomgallery/view.php:166
11	JoomGalleryView->display()	JROOT/components/com_joomgallery/views/detail/view.html.php:1143
10	JoomGalleryViewDetail->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:98
8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:40
6	require_once JROOT/components/com_joomgallery/joomgallery.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: 13.46 ms Query memory: 0.023 MB Memory before query: 24.799 MB Rows returned: 0

SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
				
  FROM kez4a_fields_values fv
				
  LEFT JOIN kez4a_fields f 
  ON fv.field_id = f.id
				
  LEFT JOIN kez4a_fields_groups fg 
  ON fg.id = f.group_id
				
  WHERE fv.item_id = 45
				
  AND f.context = "com_content.categories"
				
  AND f.language IN ("*", "en-GB")
				
  AND f.access = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fv	NULL	ALL	idx_field_id,idx_item_id	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	f	NULL	eq_ref	PRIMARY,idx_access,idx_language,idx_context	PRIMARY	4	demodesign_2021.fv.field_id	1	100.00	Using where
1	SIMPLE	fg	NULL	eq_ref	PRIMARY	PRIMARY	4	demodesign_2021.f.group_id	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.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 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.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:47
12	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/tpls/blocks/mainnav.php:54
11	include JROOT/templates/ja_focus/tpls/blocks/mainnav.php	JROOT/plugins/system/t3/includes/core/template.php:200
10	T3Template->loadBlock()	JROOT/templates/ja_focus/tpls/default.php:35
9	include JROOT/templates/ja_focus/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:226
8	T3Template->loadLayout()	JROOT/templates/ja_focus/index.php:34
7	require JROOT/templates/ja_focus/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.63 ms After last query: 3.34 ms Query memory: 0.021 MB Memory before query: 25.350 MB Rows returned: 1

SELECT `id` 
  FROM `kez4a_menu` 
  WHERE `link` LIKE '%option=com_community&view=chat%' 
  AND `published`='1' 
  AND `menutype`!='jomsocial' 
  AND `type`='component'

Explain

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

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 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
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1415
10	CRoute::_getViewItemid()	JROOT/components/com_community/libraries/core.php:1325
9	CRoute::_()	JROOT/components/com_community/models/chat.php:42
8	CommunityModelChat->getTotalNotifications()	JROOT/plugins/system/jomsocialchatbar/jomsocialchatbar.php:54
7	plgSystemjomsocialchatbar->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1102
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.24 ms After last query: 0.17 ms Query memory: 0.021 MB Memory before query: 25.359 MB Rows returned: 0

SELECT c.id as chat_id, c.type, c.name, c.last_msg, cp.enabled, cp.mute
            
  FROM `kez4a_community_chat` c
            
  INNER JOIN `kez4a_community_chat_participants` cp 
  ON c.id = cp.chat_id
            
  WHERE cp.user_id = 0 
  AND cp.enabled = 1 
  ORDER BY c.last_msg DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cp	NULL	ref	idx_chat_id,idx_user_id	idx_user_id	4	const	1	10.00	Using where; Using temporary; Using filesort
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	demodesign_2021.cp.chat_id	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.04 ms
preparing	0.01 ms
Creating tmp table	0.03 ms
executing	0.02 ms
end	0.00 ms
query end	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
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_community/models/chat.php:379
9	CommunityModelChat->getMyChatList()	JROOT/components/com_community/models/chat.php:49
8	CommunityModelChat->getTotalNotifications()	JROOT/plugins/system/jomsocialchatbar/jomsocialchatbar.php:54
7	plgSystemjomsocialchatbar->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1102
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.23 ms After last query: 4.41 ms Query memory: 0.022 MB Memory before query: 25.925 MB Rows returned: 0

SELECT *
 
  FROM kez4a_jmap_metainfo
 
  WHERE `linkurl` = 'https://www.designfootball.com/competitions-3/dccr/fc-kharkiv-crest-redesign-64353'
 
  AND `published` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_jmap_metainfo	NULL	ref	published	published	1	const	1	100.00	Using where

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 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.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:714
12	plgSystemJMap->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.13 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 25.931 MB Rows returned: 0

SELECT *
 
  FROM kez4a_jmap_canonicals
 
  WHERE `linkurl` = 'https://www.designfootball.com/competitions-3/dccr/fc-kharkiv-crest-redesign-64353'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_jmap_canonicals	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.00 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:814
12	plgSystemJMap->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.15 ms After last query: 8.97 ms Query memory: 0.020 MB Memory before query: 26.125 MB Rows returned: 0

SELECT *
 
  FROM kez4a_jmap_headings
 
  WHERE `linkurl` = 'https://www.designfootball.com/competitions-3/dccr/fc-kharkiv-crest-redesign-64353'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_jmap_headings	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.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.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
8	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:1130
7	plgSystemJMap->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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.12 ms After last query: 0.02 ms Query memory: 0.020 MB Memory before query: 26.130 MB Rows returned: 0

SELECT
 `original_text`,
 `target_text`,
 `original_text_regex`,
 `target_text_regex`
 
  FROM
 `kez4a_jmap_text_replacements`
 
  WHERE
`published` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_jmap_text_replacements	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.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.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
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jmap/jmap.php:357
8	plgSystemJMap->patternReplacements()	JROOT/plugins/system/jmap/jmap.php:1207
7	plgSystemJMap->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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.23 ms After last query: 2.59 ms Query memory: 0.022 MB Memory before query: 26.622 MB Rows returned: 1

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

  FROM kez4a_extensions

  WHERE element = 'jspeed' 
  AND type = 'plugin'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kez4a_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.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.06 ms
preparing	0.01 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.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/plugins/system/jspeed/framework/plugin.php:28
13	JSpeedPlugin::loadplugin()	JROOT/plugins/system/jspeed/framework/plugin.php:48
12	JSpeedPlugin::getPlugin()	JROOT/plugins/system/jspeed/framework/plugin.php:59
11	JSpeedPlugin::getPluginParams()	JROOT/plugins/system/jspeed/framework/filescanner.php:101
10	JSpeedFileScanner::getInstance()	JROOT/plugins/system/jspeed/framework/optimizer.php:66
9	JSpeedOptimizer->process()	JROOT/plugins/system/jspeed/framework/optimizer.php:126
8	JSpeedOptimizer::optimize()	JROOT/plugins/system/jspeed/jspeed.php:186
7	plgSystemJSpeed->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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.]

73 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

4 × SELECT alias 
  FROM kez4a_joomgallery_catg

```
3 × SELECT `id` 
  FROM `kez4a_users`
```
```
3 × SELECT FOUND_ROWS(
```
```
2 × SELECT `id` 
  FROM `kez4a_menu`
```

2 × SELECT   a.`userid` as _userid ,  a.`status` as _status ,  a.`points` as _points,  a.`posted_on` as _posted_on,  a.`avatar` as _avatar ,  a.`cover` as _cover ,  a.`thumb` as _thumb ,  a.`invite` as _invite,  a.`params` as _cparams,   a.`view` as _view,  a.`friends` as _friends,  a.`pages` as _pages,  a.`groups` as _groups,  a.`events` as _events,  a.`friendcount` as _friendcount,  a.`alias` as _alias,  a.`profile_id` as _profile_id,  a.`storage` as _storage,  a.`watermark_hash` as _watermark_hash,  a.`search_email` as _search_email,  a.`longitude` as longitude,  a.`latitude` as latitude,  a.`default_avatar` as _defaultAvatar,  a.`usergroup` as _usergroup,  s.`userid` as _isonline, u.*  
  FROM `kez4a_community_users` as a  
  LEFT JOIN `kez4a_users` u  
  ON u.`id`=a.`userid` 
  LEFT 
  OUTER JOIN `kez4a_session` s  
  ON s.`userid`=a.`userid` 
  AND s.`client_id` !='1'

2 × SELECT catid, alias 
  FROM kez4a_joomgallery

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

1 × SELECT *, 500 AS maxzindex 
  FROM kez4a_joomgallery_nameshields

1 × SELECT * 
  FROM kez4a_jlexreview_blacklist

1 × SELECT `value` 
  FROM `kez4a_community_fields_values`

1 × SELECT * 
  FROM kez4a_jlexreview_entry

1 × SELECT params 
  FROM kez4a_jlexreview_form

1 × SELECT COUNT(id) 
  FROM kez4a_jlexreview

1 × SELECT ROUND(rating) star_rating, COUNT(id) count_rating 
  FROM kez4a_jlexreview

1 × SELECT f.field_id id, SUM(f.field_value*1) total_point, SUM(IF(f.field_value=0,0,1)) total_rating 
  FROM kez4a_jlexreview_fields f 
  LEFT JOIN kez4a_jlexreview r 
  ON r.id=f.review_id

1 × SELECT SQL_CALC_FOUND_ROWS r.*,r.author_name,IF(r.created_by=0,r.author_email,u.email) author_email 
  FROM kez4a_jlexreview AS r 
  LEFT JOIN kez4a_users AS u 
  ON u.id=r.created_by

1 × SELECT `id` 
  FROM `kez4a_community_fields`

1 × SELECT * 
  FROM kez4a_jlexcomment_blacklist

1 × SELECT * 
  FROM kez4a_jlexcomment_obj

1 × SELECT SQL_CALC_FOUND_ROWS cm.*,u.username,u.name screen_name, u.email user_email,0 isOnline,IF(vote.point=NULL,0,vote.point*1) voted,sticker.path2file sk_path2file,cm2.guest_name AS guest_name2, cm2.created_by AS created_by2 
  FROM kez4a_jlexcomment AS cm 
  LEFT JOIN kez4a_users AS u 
  ON cm.created_by=u.id 
  LEFT JOIN kez4a_jlexcomment_vote AS vote 
  ON (vote.comment_id=cm.id 
  AND vote.ip_address='18.97.14.87') 
  LEFT JOIN kez4a_jlexcomment_sticker AS sticker 
  ON(sticker.id=cm.sticker_id 
  AND sticker.published=1)  
  LEFT JOIN kez4a_jlexcomment cm2 
  ON cm.parent_id=cm2.id

1 × SELECT regexClause,replaceClause,group_cid 
  FROM kez4a_jlexcomment_replacer

1 × SELECT group_id 
  FROM kez4a_user_usergroup_map

1 × SELECT * 
  FROM kez4a_jlexcomment_media

1 × SELECT `cm_i_count_active` 
  FROM kez4a_jlexcomment_obj

1 × SELECT SQL_CALC_FOUND_ROWS u.id, u.name, u.username, u.email 
  FROM kez4a_jlexcomment cm 
  INNER JOIN kez4a_users u 
  ON cm.created_by=u.id

1 × SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name     
  FROM kez4a_fields_values fv     
  LEFT JOIN kez4a_fields f 
  ON fv.field_id = f.id     
  LEFT JOIN kez4a_fields_groups fg 
  ON fg.id = f.group_id

1 × SELECT c.id as chat_id, c.type, c.name, c.last_msg, cp.enabled, cp.mute             
  FROM `kez4a_community_chat` c             
  INNER JOIN `kez4a_community_chat_participants` cp 
  ON c.id = cp.chat_id

1 × SELECT *  
  FROM kez4a_jmap_metainfo

1 × SELECT *  
  FROM kez4a_jmap_canonicals

1 × SELECT *  
  FROM kez4a_jmap_headings

1 × SELECT  `original_text`,  `target_text`,  `original_text_regex`,  `target_text_regex`  
  FROM  `kez4a_jmap_text_replacements`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down 
  FROM kez4a_modules AS m 
  LEFT JOIN kez4a_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN kez4a_advancedmodules as am 
  ON am.moduleid = m.id

1 × SELECT `data` 
  FROM `kez4a_session`

```
1 × SELECT id 
  FROM kez4a_menu
```

1 × SELECT id 
  FROM kez4a_joomgallery

1 × SELECT id, rules 
  FROM `kez4a_viewlevels

1 × SELECT b.id 
  FROM kez4a_usergroups AS a 
  LEFT JOIN kez4a_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 kez4a_extensions

1 × SELECT `value` 
  FROM `kez4a_admintools_storage`

1 × SELECT * 
  FROM `kez4a_admintools_wafexceptions`

1 × SELECT * 
  FROM kez4a_j2store_configuration

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

```
1 × SELECT * 
  FROM kez4a_languages
```

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

```
1 × SELECT * 
  FROM kez4a_menu
```

1 × SELECT cid 
  FROM kez4a_joomgallery_catg

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

1 × SELECT `session_id` 
  FROM `kez4a_session`

1 × SELECT * 
  FROM kez4a_allvideoshare_videos

1 × SELECT * 
  FROM kez4a_allvideoshare_categories

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

1 × SELECT `id`, `name`,`alias`, `use_feedburner`, `uri`, `feed_type` 
  FROM `kez4a_obrss`

1 × SELECT * 
  FROM kez4a_joomgallery_config

1 × SELECT COUNT(cspicid) 
  FROM kez4a_joomgallery_countstop

1 × SELECT catid 
  FROM kez4a_joomgallery

1 × SELECT a.*, a.owner AS imgowner, c.metadesc AS catmetadesc, c.metakey AS catmetakey, c.allow_download as catallow_download, c.allow_comment as catallow_comment, c.allow_rating as catallow_rating,ROUND(LEAST(IF(imgvotes > 0, a.imgvotesum/a.imgvotes, 0.0), 15), 2) AS rating 
  FROM kez4a_joomgallery AS a 
  LEFT JOIN kez4a_joomgallery_catg AS c 
  ON c.cid = a.catid

1 × SELECT c.cid, c.parent_id, c.name, c.access, c.published, c.hidden, c.owner 
  FROM kez4a_joomgallery_catg AS c

1 × SELECT catid, COUNT(id) as piccount, SUM(hits) as hitcount 
  FROM kez4a_joomgallery

1 × SELECT catpath 
  FROM kez4a_joomgallery_catg

1 × SELECT * 
  FROM kez4a_community_config

1 × SELECT folder AS type, element AS name, params, extension_id 
  FROM kez4a_extensions

OTHER Tables:

1 × INSERT INTO `kez4a_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3137646636343138343437636231616634396132663833656137303061323633', 1, 1747027175, 0, '', 0

1 × UPDATE kez4a_extensions 
  SET enabled=1

1 × SHOW VARIABLES LIKE "collation_database

1 × UPDATE `kez4a_extensions` 
  SET `params` = '{\"mediaversion\":\"27df001f6a55102e8d720da4e7f39ca1\"}'

1 × SHOW FULL COLUMNS 
  FROM `kez4a_joomgallery_config

1 × DELETE  
  FROM kez4a_joomgallery_countstop

1 × INSERT INTO kez4a_joomgallery_countstop (csip, cssessionid, cspicid, cstime) 
  VALUES  ('18.97.14.87','3tLFY8vvCFkAxwjyS4gPwtkTO00crVBb',64353, NOW()

1 × SHOW FULL COLUMNS 
  FROM `kez4a_joomgallery

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

1 × SHOW FULL COLUMNS 
  FROM `kez4a_community_config

1 × SHOW FULL COLUMNS 
  FROM `kez4a_community_profiles

1 × SHOW FULL COLUMNS 
  FROM `kez4a_jlexcomment_obj

FC Kharkiv | Crest Redesign

Image information

Review

Comments

You are a guest

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

84 Queries Logged 1423.79 ms

8 duplicate found!

73 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: