ติดต่อเรา

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1611133979,
                "last": 1611133979,
                "now": 1611133979
            },
            "token": "ujCsjfWvrqsj7AWsLWvtFIPZeuBT2t3K"
        },
        "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
        },
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-name": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-logo-type": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-logo-custom-image": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-accent-color1": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-accent-color2": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-accent-color3": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-pagesurround-background": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-pagesurround-speed": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-pagesurround-type": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-pagesurround-custompagesurround-image": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-mainmenuanimation-enabled": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-header-textcolor": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-header-background": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-top-textcolor": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-top-background": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-utility-textcolor": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-utility-background": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-showcase-textcolor": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-showcase-background": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-showcase-type": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-showcase-customshowcase-image": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-feature-textcolor": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-feature-background": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-maintop-textcolor": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-maintop-background": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-maintop-type": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-maintop-custommaintop-image": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-expandedtop-textcolor": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-expandedtop-background": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-mainbody-overlay": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-expandedbottom-textcolor": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-expandedbottom-background": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-mainbottom-textcolor": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-mainbottom-background": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-extension-textcolor": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-extension-background": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-bottom-textcolor": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-bottom-background": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-footer-textcolor": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-footer-background": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-copyright-textcolor": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-copyright-background": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-font-family": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-font-size-is": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-menu-type": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-menu-dropdownmenu-responsive-menu": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-menu-splitmenu-responsive-menu": null,
        "vermilion-965e2d05e059cd883b3d3cb8eb897bd9-layout-mode": null
    }
}

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

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT\libraries\joomla\session\storage\database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT\libraries\joomla\session\handler\native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT\libraries\joomla\session\handler\native.php:50
11	JSessionHandlerNative->start()	JROOT\libraries\joomla\session\handler\joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT\libraries\src\Session\Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT\libraries\src\Session\Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT\libraries\src\Session\Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT\libraries\src\Session\Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT\libraries\src\Application\CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT\libraries\src\Application\SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT\libraries\src\Application\CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT\libraries\src\Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT\index.php:46

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

Status	Duration
starting	0.15 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
executing	0.06 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.05 ms
cleaning up	0.01 ms

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

EXPLAIN not possible on query: INSERT INTO `iry7a_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'36746c676231346c33307671766b33346b6731643865756a7337', 1, 1611133979, 0, '', 0)

Profile

Status	Duration
starting	0.14 ms
Executing hook on transaction	0.02 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.01 ms
update	15.97 ms
end	0.02 ms
query end	0.00 ms
waiting for handler commit	0.79 ms
closing tables	0.03 ms
freeing items	0.08 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:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT\libraries\src\Application\CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT\libraries\src\Application\SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT\libraries\src\Application\CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT\libraries\src\Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT\index.php:46

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

Query Time: 10.50 ms After last query: 9.65 ms Query memory: 0.021 MB Memory before query: 4.597 MB Rows returned: 5

SELECT id, rules

  FROM `iry7a_viewlevels`

Explain

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

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.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.02 ms
executing	10.12 ms
end	0.03 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.03 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:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT\libraries\src\Plugin\PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT\libraries\src\Plugin\PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT\libraries\src\Application\SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 57.73 ms After last query: 0.17 ms Query memory: 0.021 MB Memory before query: 4.609 MB Rows returned: 1

SELECT b.id

  FROM iry7a_usergroups AS a

  LEFT JOIN iry7a_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.09 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	57.14 ms
preparing	0.11 ms
executing	0.06 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.02 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:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT\libraries\src\Plugin\PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT\libraries\src\Plugin\PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT\libraries\src\Application\SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 58.38 ms After last query: 23.43 ms Query memory: 0.022 MB Memory before query: 5.793 MB Rows returned: 1

Duplicate queries: #7

SELECT template

  FROM iry7a_template_styles as s

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT\libraries\rokcommon\RokCommon\PlatformInfo\Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT\libraries\rokcommon\RokCommon\PlatformInfo\Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT\libraries\rokcommon\RokCommon\Service.php:71
10	RokCommon_Service::getContainer()	JROOT\libraries\rokcommon\include.php:38
9	require_once JROOT\libraries\rokcommon\include.php	JROOT\plugins\system\rokcommon\rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT\plugins\system\rokcommon\rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT\libraries\src\Plugin\PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT\libraries\src\Plugin\PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT\libraries\src\Application\CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.47 ms After last query: 0.14 ms Query memory: 0.023 MB Memory before query: 5.800 MB Rows returned: 1

Duplicate queries: #6

SELECT template

  FROM iry7a_template_styles as s

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

Explain

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

Profile

Status	Duration
starting	0.08 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.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.06 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.04 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\libraries\rokcommon\RokCommon\PlatformInfo\Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT\libraries\rokcommon\RokCommon\PlatformInfo\Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT\libraries\rokcommon\RokCommon\PlatformInfo\Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT\libraries\rokcommon\RokCommon\Service.php:71
10	RokCommon_Service::getContainer()	JROOT\libraries\rokcommon\include.php:38
9	require_once JROOT\libraries\rokcommon\include.php	JROOT\plugins\system\rokcommon\rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT\plugins\system\rokcommon\rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT\libraries\src\Plugin\PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT\libraries\src\Plugin\PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT\libraries\src\Application\CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 10.98 ms After last query: 6.03 ms Query memory: 0.021 MB Memory before query: 6.036 MB Rows returned: 2

SELECT extension, file, type

  FROM iry7a_rokcommon_configs

  ORDER BY priority

Explain

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

Profile

Status	Duration
starting	0.10 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.01 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.03 ms
executing	10.50 ms
end	0.03 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\rokcommon\rokcommon.php:131
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT\plugins\system\rokcommon\rokcommon.php:75
7	plgSystemRokCommon->__construct()	JROOT\libraries\src\Plugin\PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT\libraries\src\Plugin\PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT\libraries\src\Application\CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 75.12 ms After last query: 21.08 ms Query memory: 0.021 MB Memory before query: 7.411 MB Rows returned: 0

SELECT `name`

  FROM `iry7a_extensions`

  WHERE `type` = 'package' 
  AND `element` = 'pkg_eventgallery_full'

Explain

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

Profile

Status	Duration
starting	0.14 ms
Executing hook on transaction	0.04 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	74.52 ms
preparing	0.06 ms
executing	0.05 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.06 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT\administrator\components\com_eventgallery\version.php:24
8	include_once JROOT\administrator\components\com_eventgallery\version.php	JROOT\plugins\system\picasaupdater\picasaupdater.php:33
7	plgSystemPicasaupdater->__construct()	JROOT\libraries\src\Plugin\PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT\libraries\src\Plugin\PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT\libraries\src\Application\CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 21.93 ms After last query: 30.72 ms Query memory: 0.020 MB Memory before query: 8.565 MB Rows returned: 1

SELECT count(*)

  FROM `iry7a_cwgears_schedule`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	iry7a_cwgears_schedule	NULL	index	NULL	PRIMARY	4	NULL	4	100.00	Using index

Profile

Status	Duration
starting	0.10 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.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	21.42 ms
end	0.03 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT\plugins\system\cwgears\cwgears.php:102
8	plgSystemCwgears->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:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.66 ms After last query: 0.20 ms Query memory: 0.020 MB Memory before query: 8.570 MB Rows returned: 1

SELECT count(*)

  FROM `iry7a_cwgears_schedule`

  WHERE time + '86400'<'1611133979'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT\plugins\system\cwgears\cwgears.php:145
8	plgSystemCwgears->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:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 112.65 ms After last query: 3.20 ms Query memory: 0.026 MB Memory before query: 8.621 MB Rows returned: 18

SHOW FULL COLUMNS 
  FROM `iry7a_extensions`

Explain

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

Profile

Status	Duration
starting	0.30 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.41 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.08 ms
init	0.17 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.05 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.05 ms
Creating tmp table	0.09 ms
executing	78.75 ms
checking permissions	31.63 ms
checking permissions	0.07 ms
checking permissions	0.05 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.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.08 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
removing tmp table	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\mysqli.php:445
13	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\src\Table\Table.php:245
12	Joomla\CMS\Table\Table->getFields()	JROOT\libraries\src\Table\Table.php:164
11	Joomla\CMS\Table\Table->__construct()	JROOT\libraries\src\Table\Extension.php:32
10	Joomla\CMS\Table\Extension->__construct()	JROOT\libraries\src\Table\Table.php:312
9	Joomla\CMS\Table\Table::getInstance()	JROOT\plugins\system\roksprocket\roksprocket.php:45
8	plgSystemRokSprocket->onAfterInitialise()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.60 ms After last query: 2.61 ms Query memory: 0.021 MB Memory before query: 8.663 MB Rows returned: 1

SELECT `extension_id`

  FROM `iry7a_extensions`

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

Explain

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

Profile

Status	Duration
starting	0.08 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.01 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	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.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT\libraries\src\Table\Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT\plugins\system\roksprocket\roksprocket.php:47
8	plgSystemRokSprocket->onAfterInitialise()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 17.89 ms After last query: 0.27 ms Query memory: 0.021 MB Memory before query: 8.670 MB Rows returned: 1

Duplicate queries: #16

SELECT *

  FROM iry7a_extensions

  WHERE `extension_id` = '10014'

Explain

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT\libraries\src\Table\Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT\plugins\system\roksprocket\roksprocket.php:54
8	plgSystemRokSprocket->onAfterInitialise()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.55 ms After last query: 0.17 ms Query memory: 0.021 MB Memory before query: 8.674 MB Rows returned: 1

SELECT `extension_id`

  FROM `iry7a_extensions`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT\libraries\src\Table\Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT\plugins\system\roksprocket\roksprocket.php:70
8	plgSystemRokSprocket->onAfterInitialise()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.57 ms After last query: 0.15 ms Query memory: 0.021 MB Memory before query: 8.680 MB Rows returned: 1

Duplicate queries: #14

SELECT *

  FROM iry7a_extensions

  WHERE `extension_id` = '10014'

Explain

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

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 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.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT\libraries\src\Table\Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT\plugins\system\roksprocket\roksprocket.php:76
8	plgSystemRokSprocket->onAfterInitialise()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 113.03 ms After last query: 129.04 ms Query memory: 0.021 MB Memory before query: 10.396 MB Rows returned: 0

SELECT ip

  FROM `iry7a_cwtraffic_knownips`

  WHERE state = 1 
  AND count = 0

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT\plugins\system\cwtrafficcount\cwtrafficcount.php:158
8	plgSystemCwtrafficCount->onAfterRoute()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.56 ms After last query: 0.26 ms Query memory: 0.020 MB Memory before query: 10.401 MB Rows returned: 0

SELECT botname

  FROM `iry7a_cwtraffic_knownips`

  WHERE state = 1 
  AND count = 0

Explain

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

Profile

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	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.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT\plugins\system\cwtrafficcount\cwtrafficcount.php:186
8	plgSystemCwtrafficCount->onAfterRoute()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 33.79 ms After last query: 0.22 ms Query memory: 0.020 MB Memory before query: 10.406 MB Rows returned: 1

SELECT count(*)

  FROM `iry7a_cwtraffic`

  WHERE iphash = UNHEX(SHA1('18.215.185.97')) 
  AND tm + '3600'>'1611133979'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	iry7a_cwtraffic	NULL	ref	unique_tm_iphash,idx_iphash,idx_iphashtm	idx_iphash	20	const	1	100.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT\plugins\system\cwtrafficcount\cwtrafficcount.php:242
8	plgSystemCwtrafficCount->onAfterRoute()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 1.71 ms After last query: 5.06 ms Query memory: 0.006 MB Memory before query: 10.456 MB

UPDATE `iry7a_extensions`

  SET `params` = '{\"mediaversion\":\"0c6e44ea0b03b5b7929debaa304eacff\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `iry7a_extensions` SET `params` = '{\"mediaversion\":\"0c6e44ea0b03b5b7929debaa304eacff\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.11 ms
updating	0.48 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.73 ms
closing tables	0.03 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 200.76 ms After last query: 17.89 ms Query memory: 0.024 MB Memory before query: 11.111 MB Rows returned: 3

Duplicate queries: #24

SELECT
					sp.id,
					st.name as type
					
  FROM
					`iry7a_creative_fields` sp
					JOIN `iry7a_creative_field_types` st 
  ON st.id = sp.id_type
					
  WHERE sp.published = '1'
					
  AND sp.id_form = '1'
					
  ORDER BY sp.ordering,sp.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sp	NULL	ref	id_form	id_form	3	const	4	20.00	Using where; Using filesort
1	SIMPLE	st	NULL	eq_ref	PRIMARY	PRIMARY	4	vtc.sp.id_type	1	100.00	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT\components\com_creativecontactform\helpers\helper.php:74
15	CreativecontactformHelper->get_data()	JROOT\components\com_creativecontactform\helpers\helper.php:415
14	CreativecontactformHelper->render_html()	JROOT\components\com_creativecontactform\views\creativecontactform\tmpl\default.php:23
13	include JROOT\components\com_creativecontactform\views\creativecontactform\tmpl\default.php	JROOT\libraries\src\MVC\View\HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT\libraries\src\MVC\View\HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT\components\com_creativecontactform\views\creativecontactform\view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_creativecontactform\controller.php:34
8	CreativeContactFormController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_creativecontactform\creativecontactform.php:32
6	require_once JROOT\components\com_creativecontactform\creativecontactform.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 13.92 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 11.123 MB Rows returned: 1

Duplicate queries: #25

SELECT
					sp.`id_template`,
					sp.name,
					sp.top_text,
					sp.pre_text,
					sp.thank_you_text,
					sp.send_text,
					sp.send_new_text,
					sp.close_alert_text,
					sp.form_width,
					sp.redirect,
					sp.redirect_itemid,
					sp.redirect_url,
					sp.redirect_delay,
					sp.shake_count,
					sp.shake_distanse,
					sp.send_copy_enable,
					sp.send_copy_text,
					sp.shake_duration,
					sp.custom_css,
					st.styles,

					sp.render_type,
					sp.popup_button_text,
					sp.static_button_position,
					sp.static_button_offset,
					sp.appear_animation_type,
					sp.check_token,
					sp.next_button_text,
					sp.prev_button_text

					
  FROM
					`iry7a_creative_forms` sp
					
  LEFT JOIN `iry7a_contact_templates` st 
  ON st.id = sp.id_template
					
  WHERE sp.published = '1'
					
  AND sp.id = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sp	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL
1	SIMPLE	st	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	13.37 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 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.07 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT\components\com_creativecontactform\helpers\helper.php:128
15	CreativecontactformHelper->get_data()	JROOT\components\com_creativecontactform\helpers\helper.php:415
14	CreativecontactformHelper->render_html()	JROOT\components\com_creativecontactform\views\creativecontactform\tmpl\default.php:23
13	include JROOT\components\com_creativecontactform\views\creativecontactform\tmpl\default.php	JROOT\libraries\src\MVC\View\HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT\libraries\src\MVC\View\HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT\components\com_creativecontactform\views\creativecontactform\view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_creativecontactform\controller.php:34
8	CreativeContactFormController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_creativecontactform\creativecontactform.php:32
6	require_once JROOT\components\com_creativecontactform\creativecontactform.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.79 ms After last query: 0.13 ms Query memory: 0.028 MB Memory before query: 11.139 MB Rows returned: 3

Duplicate queries: #26

SELECT
					sp.id,
					sp.name,
					sp.tooltip_text,
					sp.required,
					sp.ordering_field,
					sp.select_default_text,
					sp.show_parent_label,
					sp.select_no_match_text,
					sp.width,
					sp.field_margin_top,
					sp.select_show_scroll_after,
					sp.select_show_search_after,
					sp.upload_button_text,
					sp.upload_minfilesize,
					sp.upload_maxfilesize,
					sp.upload_acceptfiletypes,
					sp.upload_minfilesize_message,
					sp.upload_maxfilesize_message,
					sp.upload_acceptfiletypes_message,
					sp.captcha_wrong_message,

					sp.datepicker_date_format,
					sp.datepicker_animation,
					sp.datepicker_style,
					sp.datepicker_icon_style,
					sp.datepicker_show_icon,
					sp.datepicker_input_readonly,
					sp.datepicker_number_months,
					sp.datepicker_mindate,
					sp.datepicker_maxdate,
					sp.datepicker_changemonths,
					sp.datepicker_changeyears,
					sp.column_type,
					sp.custom_html,
					sp.google_maps,
					sp.heading,
					sp.recaptcha_site_key,
					sp.recaptcha_wrong_message,
					sp.recaptcha_theme,
					sp.recaptcha_type,
					sp.contact_data,
					sp.contact_data_width,
					sp.creative_popup,
					sp.creative_popup_embed,

					st.name as type
				
  FROM
					`iry7a_creative_fields` sp
				JOIN `iry7a_creative_field_types` st 
  ON st.id = sp.id_type
				
  WHERE sp.published = '1'
				
  AND sp.id_form = '1'
				
  ORDER BY sp.ordering,sp.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sp	NULL	ref	id_form	id_form	3	const	4	20.00	Using where; Using filesort
1	SIMPLE	st	NULL	eq_ref	PRIMARY	PRIMARY	4	vtc.sp.id_type	1	100.00	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT\components\com_creativecontactform\helpers\helper.php:189
15	CreativecontactformHelper->get_data()	JROOT\components\com_creativecontactform\helpers\helper.php:415
14	CreativecontactformHelper->render_html()	JROOT\components\com_creativecontactform\views\creativecontactform\tmpl\default.php:23
13	include JROOT\components\com_creativecontactform\views\creativecontactform\tmpl\default.php	JROOT\libraries\src\MVC\View\HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT\libraries\src\MVC\View\HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT\components\com_creativecontactform\views\creativecontactform\view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_creativecontactform\controller.php:34
8	CreativeContactFormController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_creativecontactform\creativecontactform.php:32
6	require_once JROOT\components\com_creativecontactform\creativecontactform.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 3.96 ms After last query: 1.60 ms Query memory: 0.025 MB Memory before query: 11.195 MB Rows returned: 3

Duplicate queries: #21

SELECT
					sp.id,
					st.name as type
					
  FROM
					`iry7a_creative_fields` sp
					JOIN `iry7a_creative_field_types` st 
  ON st.id = sp.id_type
					
  WHERE sp.published = '1'
					
  AND sp.id_form = '1'
					
  ORDER BY sp.ordering,sp.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sp	NULL	ref	id_form	id_form	3	const	4	20.00	Using where; Using filesort
1	SIMPLE	st	NULL	eq_ref	PRIMARY	PRIMARY	4	vtc.sp.id_type	1	100.00	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1506
17	JDatabaseDriver->loadAssocList()	JROOT\components\com_creativecontactform\helpers\helper.php:74
16	CreativecontactformHelper->get_data()	JROOT\components\com_creativecontactform\helpers\helper.php:200
15	CreativecontactformHelper->print_fields_array_html()	JROOT\components\com_creativecontactform\helpers\helper.php:593
14	CreativecontactformHelper->render_html()	JROOT\components\com_creativecontactform\views\creativecontactform\tmpl\default.php:23
13	include JROOT\components\com_creativecontactform\views\creativecontactform\tmpl\default.php	JROOT\libraries\src\MVC\View\HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT\libraries\src\MVC\View\HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT\components\com_creativecontactform\views\creativecontactform\view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_creativecontactform\controller.php:34
8	CreativeContactFormController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_creativecontactform\creativecontactform.php:32
6	require_once JROOT\components\com_creativecontactform\creativecontactform.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.55 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 11.208 MB Rows returned: 1

Duplicate queries: #22

SELECT
					sp.`id_template`,
					sp.name,
					sp.top_text,
					sp.pre_text,
					sp.thank_you_text,
					sp.send_text,
					sp.send_new_text,
					sp.close_alert_text,
					sp.form_width,
					sp.redirect,
					sp.redirect_itemid,
					sp.redirect_url,
					sp.redirect_delay,
					sp.shake_count,
					sp.shake_distanse,
					sp.send_copy_enable,
					sp.send_copy_text,
					sp.shake_duration,
					sp.custom_css,
					st.styles,

					sp.render_type,
					sp.popup_button_text,
					sp.static_button_position,
					sp.static_button_offset,
					sp.appear_animation_type,
					sp.check_token,
					sp.next_button_text,
					sp.prev_button_text

					
  FROM
					`iry7a_creative_forms` sp
					
  LEFT JOIN `iry7a_contact_templates` st 
  ON st.id = sp.id_template
					
  WHERE sp.published = '1'
					
  AND sp.id = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sp	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL
1	SIMPLE	st	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.00 ms
starting	0.01 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.09 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT\components\com_creativecontactform\helpers\helper.php:128
16	CreativecontactformHelper->get_data()	JROOT\components\com_creativecontactform\helpers\helper.php:200
15	CreativecontactformHelper->print_fields_array_html()	JROOT\components\com_creativecontactform\helpers\helper.php:593
14	CreativecontactformHelper->render_html()	JROOT\components\com_creativecontactform\views\creativecontactform\tmpl\default.php:23
13	include JROOT\components\com_creativecontactform\views\creativecontactform\tmpl\default.php	JROOT\libraries\src\MVC\View\HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT\libraries\src\MVC\View\HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT\components\com_creativecontactform\views\creativecontactform\view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_creativecontactform\controller.php:34
8	CreativeContactFormController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_creativecontactform\creativecontactform.php:32
6	require_once JROOT\components\com_creativecontactform\creativecontactform.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.66 ms After last query: 0.08 ms Query memory: 0.027 MB Memory before query: 11.224 MB Rows returned: 3

Duplicate queries: #23

SELECT
					sp.id,
					sp.name,
					sp.tooltip_text,
					sp.required,
					sp.ordering_field,
					sp.select_default_text,
					sp.show_parent_label,
					sp.select_no_match_text,
					sp.width,
					sp.field_margin_top,
					sp.select_show_scroll_after,
					sp.select_show_search_after,
					sp.upload_button_text,
					sp.upload_minfilesize,
					sp.upload_maxfilesize,
					sp.upload_acceptfiletypes,
					sp.upload_minfilesize_message,
					sp.upload_maxfilesize_message,
					sp.upload_acceptfiletypes_message,
					sp.captcha_wrong_message,

					sp.datepicker_date_format,
					sp.datepicker_animation,
					sp.datepicker_style,
					sp.datepicker_icon_style,
					sp.datepicker_show_icon,
					sp.datepicker_input_readonly,
					sp.datepicker_number_months,
					sp.datepicker_mindate,
					sp.datepicker_maxdate,
					sp.datepicker_changemonths,
					sp.datepicker_changeyears,
					sp.column_type,
					sp.custom_html,
					sp.google_maps,
					sp.heading,
					sp.recaptcha_site_key,
					sp.recaptcha_wrong_message,
					sp.recaptcha_theme,
					sp.recaptcha_type,
					sp.contact_data,
					sp.contact_data_width,
					sp.creative_popup,
					sp.creative_popup_embed,

					st.name as type
				
  FROM
					`iry7a_creative_fields` sp
				JOIN `iry7a_creative_field_types` st 
  ON st.id = sp.id_type
				
  WHERE sp.published = '1'
				
  AND sp.id_form = '1'
				
  ORDER BY sp.ordering,sp.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sp	NULL	ref	id_form	id_form	3	const	4	20.00	Using where; Using filesort
1	SIMPLE	st	NULL	eq_ref	PRIMARY	PRIMARY	4	vtc.sp.id_type	1	100.00	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1506
17	JDatabaseDriver->loadAssocList()	JROOT\components\com_creativecontactform\helpers\helper.php:189
16	CreativecontactformHelper->get_data()	JROOT\components\com_creativecontactform\helpers\helper.php:200
15	CreativecontactformHelper->print_fields_array_html()	JROOT\components\com_creativecontactform\helpers\helper.php:593
14	CreativecontactformHelper->render_html()	JROOT\components\com_creativecontactform\views\creativecontactform\tmpl\default.php:23
13	include JROOT\components\com_creativecontactform\views\creativecontactform\tmpl\default.php	JROOT\libraries\src\MVC\View\HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT\libraries\src\MVC\View\HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT\components\com_creativecontactform\views\creativecontactform\view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_creativecontactform\controller.php:34
8	CreativeContactFormController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_creativecontactform\creativecontactform.php:32
6	require_once JROOT\components\com_creativecontactform\creativecontactform.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 7.74 ms After last query: 2.12 ms Query memory: 0.021 MB Memory before query: 11.211 MB Rows returned: 0

SELECT folder.*

  FROM `iry7a_eventgallery_folder` AS folder

  LEFT JOIN `iry7a_eventgallery_file` AS file 
  ON folder.folder = file.folder 
  and file.published=1 
  and file.ismainimage=0

  WHERE file.file IS NULL 
  AND (folder.foldertypeid=1 OR folder.foldertypeid=2 OR folder.foldertypeid=4)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	folder	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	8	33.01	Using where
1	SIMPLE	file	NULL	ref	file,index_folder	file	377	vtc.folder.folder	10	10.00	Using where; Not exists

Profile

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

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\picasaupdater\picasaupdater.php:81
7	plgSystemPicasaupdater->onAfterDispatch()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 104.64 ms After last query: 102.46 ms Query memory: 0.025 MB Memory before query: 14.459 MB Rows returned: 6

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

  FROM iry7a_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-01-20 09:13:00') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-01-20 09:13:00') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 126 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
16	JDatabaseDriver->loadObjectList()	Same as call in the line below.
15	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Helper\ModuleHelper.php:432
13	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT\libraries\src\Helper\ModuleHelper.php:362
12	Joomla\CMS\Helper\ModuleHelper::load()	JROOT\libraries\src\Helper\ModuleHelper.php:87
11	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT\libraries\src\Document\HtmlDocument.php:591
10	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT\libraries\gantry\core\gantry.class.php:804
9	Gantry->getJoomlaModuleCount()	JROOT\libraries\gantry\core\gantry.class.php:757
8	Gantry->countModules()	JROOT\templates\rt_vermilion\index.php:78
7	require JROOT\templates\rt_vermilion\index.php	JROOT\libraries\src\Document\HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT\libraries\src\Application\CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 1.14 ms After last query: 45.23 ms Query memory: 0.025 MB Memory before query: 14.968 MB Rows returned: 0

SELECT ts.template

  FROM iry7a_template_styles AS ts

  INNER JOIN iry7a_menu AS m 
  ON ts.id=m.template_style_id

  WHERE m.id = 126 
  AND m.template_style_id != 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.13 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.63 ms
executing	0.04 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.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT\modules\mod_roknavmenu\lib\RokNavMenu.php:101
16	RokNavMenu::getTemplates()	JROOT\modules\mod_roknavmenu\lib\RokNavMenu.php:74
15	RokNavMenu::loadCatalogs()	JROOT\modules\mod_roknavmenu\lib\RokNavMenu.php:25
14	RokNavMenu->__construct()	JROOT\modules\mod_roknavmenu\mod_roknavmenu.php:21
13	include JROOT\modules\mod_roknavmenu\mod_roknavmenu.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\templates\rt_vermilion\features\dropdownmenu.php:56
10	GantryFeatureDropdownMenu->render()	JROOT\libraries\gantry\core\renderers\gantrymodulesrenderer.class.php:70
9	GantryModulesRenderer::display()	JROOT\libraries\gantry\core\gantry.class.php:867
8	Gantry->displayModules()	JROOT\templates\rt_vermilion\index.php:83
7	require JROOT\templates\rt_vermilion\index.php	JROOT\libraries\src\Document\HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT\libraries\src\Application\CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.43 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 14.976 MB Rows returned: 1

SELECT template

  FROM iry7a_template_styles

  WHERE home = 1 
  AND client_id = 0

Explain

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

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.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.05 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.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT\modules\mod_roknavmenu\lib\RokNavMenu.php:116
16	RokNavMenu::getTemplates()	JROOT\modules\mod_roknavmenu\lib\RokNavMenu.php:74
15	RokNavMenu::loadCatalogs()	JROOT\modules\mod_roknavmenu\lib\RokNavMenu.php:25
14	RokNavMenu->__construct()	JROOT\modules\mod_roknavmenu\mod_roknavmenu.php:21
13	include JROOT\modules\mod_roknavmenu\mod_roknavmenu.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\templates\rt_vermilion\features\dropdownmenu.php:56
10	GantryFeatureDropdownMenu->render()	JROOT\libraries\gantry\core\renderers\gantrymodulesrenderer.class.php:70
9	GantryModulesRenderer::display()	JROOT\libraries\gantry\core\gantry.class.php:867
8	Gantry->displayModules()	JROOT\templates\rt_vermilion\index.php:83
7	require JROOT\templates\rt_vermilion\index.php	JROOT\libraries\src\Document\HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT\libraries\src\Application\CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 45.31 ms After last query: 107.07 ms Query memory: 0.022 MB Memory before query: 15.756 MB Rows returned: 0

SELECT uikit

  FROM `iry7a_cwgears`

  WHERE url = 'http://vtcchonburi.org/index.php?option=com_creativecontactform&view=creativecontactform&form=1&Itemid=126'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT\plugins\system\cwgears\helpers\loadcount.php:64
13	CwGearsHelperLoadcount::getCounts()	JROOT\plugins\system\cwgears\cwgears.php:428
12	plgSystemCwgears->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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 1.53 ms After last query: 0.22 ms Query memory: 0.022 MB Memory before query: 15.763 MB Rows returned: 0

SELECT uikit_plus

  FROM `iry7a_cwgears`

  WHERE url = 'http://vtcchonburi.org/index.php?option=com_creativecontactform&view=creativecontactform&form=1&Itemid=126'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	iry7a_cwgears	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	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
Opening tables	0.04 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	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.01 ms
freeing items	0.03 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\plugins\system\cwgears\helpers\loadcount.php:64
13	CwGearsHelperLoadcount::getCounts()	JROOT\plugins\system\cwgears\cwgears.php:437
12	plgSystemCwgears->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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 25.72 ms After last query: 1.06 ms Query memory: 0.027 MB Memory before query: 15.785 MB Rows returned: 6

SHOW FULL COLUMNS 
  FROM `iry7a_template_styles`

Explain

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

Profile

Status	Duration
starting	0.19 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.30 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.07 ms
init	0.12 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
Creating tmp table	0.07 ms
executing	19.44 ms
checking permissions	0.25 ms
checking permissions	0.08 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.05 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
removing tmp table	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\mysqli.php:445
19	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\src\Table\Table.php:245
18	Joomla\CMS\Table\Table->getFields()	JROOT\libraries\src\Table\Table.php:164
17	Joomla\CMS\Table\Table->__construct()	JROOT\administrator\components\com_templates\tables\style.php:30
16	TemplatesTableStyle->__construct()	JROOT\libraries\src\Table\Table.php:312
15	Joomla\CMS\Table\Table::getInstance()	JROOT\plugins\system\gantry\gantry.php:194
14	plgSystemGantry->getTable()	JROOT\plugins\system\gantry\gantry.php:165
13	plgSystemGantry->isGantryTemplate()	JROOT\plugins\system\gantry\gantry.php:234
12	plgSystemGantry->onBeforeCompileHead()	JROOT\libraries\joomla\event\event.php:70
11	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Document\Renderer\Html\HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT\libraries\src\Document\Renderer\Html\HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 7.69 ms After last query: 0.18 ms Query memory: 0.023 MB Memory before query: 15.805 MB Rows returned: 1

SELECT *

  FROM iry7a_template_styles

  WHERE `id` = '9'

Explain

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

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	6.98 ms
preparing	0.04 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.08 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT\libraries\src\Table\Table.php:731
14	Joomla\CMS\Table\Table->load()	JROOT\plugins\system\gantry\gantry.php:168
13	plgSystemGantry->isGantryTemplate()	JROOT\plugins\system\gantry\gantry.php:234
12	plgSystemGantry->onBeforeCompileHead()	JROOT\libraries\joomla\event\event.php:70
11	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Document\Renderer\Html\HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT\libraries\src\Document\Renderer\Html\HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

28 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

2 × SELECT
      sp.id,
      st.name as type
      
  FROM
      `iry7a_creative_fields` sp
      JOIN `iry7a_creative_field_types` st 
  ON st.id = sp.id_type

2 × SELECT template
 
  FROM iry7a_template_styles as s

2 × SELECT `extension_id`
 
  FROM `iry7a_extensions`

2 × SELECT *
 
  FROM iry7a_extensions

2 × SELECT
      sp.id,
      sp.name,
      sp.tooltip_text,
      sp.required,
      sp.ordering_field,
      sp.select_default_text,
      sp.show_parent_label,
      sp.select_no_match_text,
      sp.width,
      sp.field_margin_top,
      sp.select_show_scroll_after,
      sp.select_show_search_after,
      sp.upload_button_text,
      sp.upload_minfilesize,
      sp.upload_maxfilesize,
      sp.upload_acceptfiletypes,
      sp.upload_minfilesize_message,
      sp.upload_maxfilesize_message,
      sp.upload_acceptfiletypes_message,
      sp.captcha_wrong_message,
 
      sp.datepicker_date_format,
      sp.datepicker_animation,
      sp.datepicker_style,
      sp.datepicker_icon_style,
      sp.datepicker_show_icon,
      sp.datepicker_input_readonly,
      sp.datepicker_number_months,
      sp.datepicker_mindate,
      sp.datepicker_maxdate,
      sp.datepicker_changemonths,
      sp.datepicker_changeyears,
      sp.column_type,
      sp.custom_html,
      sp.google_maps,
      sp.heading,
      sp.recaptcha_site_key,
      sp.recaptcha_wrong_message,
      sp.recaptcha_theme,
      sp.recaptcha_type,
      sp.contact_data,
      sp.contact_data_width,
      sp.creative_popup,
      sp.creative_popup_embed,
 
      st.name as type
     
  FROM
      `iry7a_creative_fields` sp
     JOIN `iry7a_creative_field_types` st 
  ON st.id = sp.id_type

2 × SELECT
      sp.`id_template`,
      sp.name,
      sp.top_text,
      sp.pre_text,
      sp.thank_you_text,
      sp.send_text,
      sp.send_new_text,
      sp.close_alert_text,
      sp.form_width,
      sp.redirect,
      sp.redirect_itemid,
      sp.redirect_url,
      sp.redirect_delay,
      sp.shake_count,
      sp.shake_distanse,
      sp.send_copy_enable,
      sp.send_copy_text,
      sp.shake_duration,
      sp.custom_css,
      st.styles,
 
      sp.render_type,
      sp.popup_button_text,
      sp.static_button_position,
      sp.static_button_offset,
      sp.appear_animation_type,
      sp.check_token,
      sp.next_button_text,
      sp.prev_button_text
 
      
  FROM
      `iry7a_creative_forms` sp
      
  LEFT JOIN `iry7a_contact_templates` st 
  ON st.id = sp.id_template

1 × SELECT `data`
 
  FROM `iry7a_session`

1 × SELECT uikit_plus
 
  FROM `iry7a_cwgears`

1 × SELECT uikit
 
  FROM `iry7a_cwgears`

1 × SELECT template
 
  FROM iry7a_template_styles

1 × SELECT ts.template
 
  FROM iry7a_template_styles AS ts
 
  INNER JOIN iry7a_menu AS m 
  ON ts.id=m.template_style_id

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

1 × SELECT folder.*
 
  FROM `iry7a_eventgallery_folder` AS folder
 
  LEFT JOIN `iry7a_eventgallery_file` AS file 
  ON folder.folder = file.folder 
  and file.published=1 
  and file.ismainimage=0

1 × SELECT botname
 
  FROM `iry7a_cwtraffic_knownips`

1 × SELECT count(*)
 
  FROM `iry7a_cwtraffic`

1 × SELECT `session_id`
 
  FROM `iry7a_session`

1 × SELECT ip
 
  FROM `iry7a_cwtraffic_knownips`

1 × SELECT count(*)
 
  FROM `iry7a_cwgears_schedule`

1 × SELECT count(*)
 
  FROM `iry7a_cwgears_schedule

1 × SELECT `name`
 
  FROM `iry7a_extensions`

1 × SELECT extension, file, type
 
  FROM iry7a_rokcommon_configs

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

1 × SELECT id, rules
 
  FROM `iry7a_viewlevels

1 × SELECT *
 
  FROM iry7a_template_styles

OTHER Tables:

1 × INSERT INTO `iry7a_session`
 (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
 (X'36746c676231346c33307671766b33346b6731643865756a7337', 1, 1611133979, 0, '', 0

1 × SHOW FULL COLUMNS 
  FROM `iry7a_extensions

1 × UPDATE `iry7a_extensions`
 
  SET `params` = '{\"mediaversion\":\"0c6e44ea0b03b5b7929debaa304eacff\"}'

1 × SHOW FULL COLUMNS 
  FROM `iry7a_template_styles