BEC is mandated under section 5 of the Botswana Examinations Council Act (Act No 11 of 2002) as amended by the Botswana Examinations Amendment Act, 2019 to manage, conduct examinations and assessments in general education and technical, vocational education and training and to award certificates in respect of the said examinations and assessments.

Legal

Privacy

Disclaimer

Joomla! Debug Console

Session

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

Profile Information

Time

Memory

Time: 358.41 ms / 358.41 ms Memory: 0.402 MB / 0.76 MB Application: afterLoad

Time: 459.39 ms / 817.80 ms Memory: 0.798 MB / 1.56 MB Application: afterInitialise

Time: 213.19 ms / 1031.00 ms Memory: 0.409 MB / 1.97 MB Application: afterRoute

Time: 9.99 ms / 1040.98 ms Memory: 0.085 MB / 2.05 MB Application: beforeRenderComponent com_sppagebuilder

Time: 221.38 ms / 1262.36 ms Memory: 0.059 MB / 2.11 MB Application: Before Access::preloadComponents (all components)

Time: 2.48 ms / 1264.84 ms Memory: 0.054 MB / 2.16 MB Application: After Access::preloadComponents (all components)

Time: 0.09 ms / 1264.93 ms Memory: -0.003 MB / 2.16 MB Application: Before Access::getAssetRules (id:56 name:com_sppagebuilder)

Time: 10.53 ms / 1275.46 ms Memory: 0.008 MB / 2.17 MB Application: After Access::getAssetRules (id:56 name:com_sppagebuilder)

Time: 1984.57 ms / 3260.03 ms Memory: 3.051 MB / 5.22 MB Application: Before Access::preloadPermissions (com_sppagebuilder)

Time: 2.09 ms / 3262.12 ms Memory: 0.092 MB / 5.31 MB Application: After Access::preloadPermissions (com_sppagebuilder)

Time: 0.05 ms / 3262.16 ms Memory: -0.007 MB / 5.30 MB Application: Before Access::getAssetRules (id:356 name:com_sppagebuilder.page.234)

Time: 0.04 ms / 3262.20 ms Memory: 0.002 MB / 5.31 MB Application: After Access::getAssetRules (id:356 name:com_sppagebuilder.page.234)

Time: 0.68 ms / 3262.88 ms Memory: -1.052 MB / 4.25 MB Application: afterRenderComponent com_sppagebuilder

Time: 78.11 ms / 3340.99 ms Memory: 0.008 MB / 4.26 MB Application: afterDispatch

Time: 266.38 ms / 3607.36 ms Memory: 0.285 MB / 4.55 MB Application: beforeRenderModule mod_menu (Offcanvas)

Time: 254.48 ms / 3861.84 ms Memory: 0.120 MB / 4.67 MB Application: afterRenderModule mod_menu (Offcanvas)

Time: 0.14 ms / 3861.98 ms Memory: -0.007 MB / 4.66 MB Application: beforeRenderModule mod_custom (Copyright)

Time: 8.96 ms / 3870.94 ms Memory: 0.007 MB / 4.67 MB Application: afterRenderModule mod_custom (Copyright)

Time: 0.12 ms / 3871.06 ms Memory: -0.001 MB / 4.66 MB Application: beforeRenderModule mod_sppagebuilder (Bottom )

Time: 1178.23 ms / 5049.30 ms Memory: 0.148 MB / 4.81 MB Application: afterRenderModule mod_sppagebuilder (Bottom )

Time: 0.17 ms / 5049.47 ms Memory: -0.040 MB / 4.77 MB Application: beforeRenderModule mod_shacksearch (Shack Search)

Time: 123.99 ms / 5173.46 ms Memory: 0.012 MB / 4.78 MB Application: afterRenderModule mod_shacksearch (Shack Search)

Time: 0.19 ms / 5173.65 ms Memory: 0.010 MB / 4.79 MB Application: beforeRenderModule mod_favsocial (Social Icons)

Time: 39.30 ms / 5212.94 ms Memory: 0.032 MB / 4.83 MB Application: afterRenderModule mod_favsocial (Social Icons)

Time: 0.18 ms / 5213.13 ms Memory: -0.030 MB / 4.80 MB Application: beforeRenderModule mod_custom (Bec Motto)

Time: 9.83 ms / 5222.96 ms Memory: 0.003 MB / 4.80 MB Application: afterRenderModule mod_custom (Bec Motto)

Time: 0.12 ms / 5223.08 ms Memory: 0.000 MB / 4.80 MB Application: beforeRenderModule mod_custom (Logo)

Time: 8.22 ms / 5231.30 ms Memory: 0.003 MB / 4.80 MB Application: afterRenderModule mod_custom (Logo)

Time: 63.34 ms / 5294.64 ms Memory: 0.385 MB / 5.19 MB Application: afterRender

Database queries total: 102.04 ms

Memory Usage

Database Queries

42 Queries Logged 102.04 ms

20 duplicate found!

12 duplicates: #18 #19 #20 #21 #22 #23 #34 #35 #36 #37 #38 #39

5 duplicates: #24 #25 #40 #41 #42

3 duplicates: #27 #28 #29

Query Time: 0.94 ms Query memory: 0.023 MB Memory before query: 1.041 MB Rows returned: 0

SELECT `data`

  FROM `n6a03_session`

  WHERE `session_id` = X'6331707630616c63316f3662636b3835726b736c746d6f706f31'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n6a03_session	const	PRIMARY	PRIMARY	194	const	1

Profile

Status	Duration
Starting	0.12 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.04 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.03 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.11 ms
Reset for next command	0.02 ms

Call Stack

#	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

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

Query Time: 1.20 ms After last query: 17.90 ms Query memory: 0.020 MB Memory before query: 1.055 MB Rows returned: 0

SELECT `session_id`

  FROM `n6a03_session`

  WHERE `session_id` = X'6331707630616c63316f3662636b3835726b736c746d6f706f31' 
  LIMIT 1

Explain

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

Profile

Status	Duration
Starting	0.12 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.04 ms
init	0.08 ms
Optimizing	0.04 ms
Statistics	0.12 ms
Preparing	0.05 ms
Executing	0.04 ms
End of update loop	0.06 ms
Query end	0.03 ms
Commit	0.04 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
closing tables	0.02 ms
Query end	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.13 ms
Reset for next command	0.15 ms

Call Stack

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

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

Query Time: 1.74 ms After last query: 0.30 ms Query memory: 0.004 MB Memory before query: 1.060 MB

INSERT INTO `n6a03_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6331707630616c63316f3662636b3835726b736c746d6f706f31', 1, 1765765842, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `n6a03_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6331707630616c63316f3662636b3835726b736c746d6f706f31', 1, 1765765842, 0, '', 0)

Profile

Status	Duration
Starting	0.13 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.05 ms
init for update	0.03 ms
Update	0.09 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.88 ms
Query end	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.09 ms
Reset for next command	0.02 ms

Call Stack

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

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

Query Time: 1.78 ms After last query: 35.08 ms Query memory: 0.024 MB Memory before query: 1.091 MB Rows returned: 37

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

  FROM `n6a03_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n6a03_extensions	ref	extension	extension	82	const	37	Using index condition; Using where

Profile

Status	Duration
Starting	0.15 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.06 ms
init	0.06 ms
Optimizing	0.07 ms
Statistics	0.10 ms
Preparing	0.06 ms
Executing	0.03 ms
Sending data	0.43 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.04 ms
closing tables	0.04 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.16 ms
Reset for next command	0.03 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: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.15 ms After last query: 30.37 ms Query memory: 0.021 MB Memory before query: 1.119 MB Rows returned: 5

SELECT id, rules

  FROM `n6a03_viewlevels`

Explain

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

Profile

Status	Duration
Starting	0.13 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.04 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.04 ms
Commit	0.02 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.16 ms
Reset for next command	0.04 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: 1.16 ms After last query: 0.18 ms Query memory: 0.021 MB Memory before query: 1.131 MB Rows returned: 2

SELECT b.id

  FROM n6a03_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.04 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.09 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.07 ms
Executing	0.02 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.04 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.13 ms
Reset for next command	0.05 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: 1.75 ms After last query: 3.02 ms Query memory: 0.030 MB Memory before query: 1.152 MB Rows returned: 89

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

  FROM n6a03_extensions

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

  ORDER BY ordering

Explain

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

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.03 ms
table lock	0.04 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.02 ms
Creating sort index	0.86 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.10 ms
Reset for next command	0.02 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:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Plugin\PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT\libraries\src\Plugin\PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT\libraries\src\Plugin\PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT\libraries\src\Application\SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 1.89 ms After last query: 160.12 ms Query memory: 0.092 MB Memory before query: 1.584 MB Rows returned: 56

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

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

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

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	87	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	bancozim_bec3.m.component_id	1	Using where

Profile

Status	Duration
Starting	0.20 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.12 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.72 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.06 ms
Query end	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.10 ms
Reset for next command	0.04 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:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT\libraries\src\Menu\SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT\libraries\src\Menu\AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT\libraries\src\Application\CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT\libraries\src\Application\SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT\libraries\src\Router\SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT\libraries\src\Router\Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT\libraries\src\Application\CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT\libraries\src\Application\SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT\libraries\src\Application\CMSApplication.php:1073
4	Joomla\CMS\Application\CMSApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.88 ms After last query: 158.46 ms Query memory: 0.025 MB Memory before query: 1.955 MB Rows returned: 1

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

  FROM `n6a03_extensions`

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

Explain

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

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.05 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.11 ms
Reset for next command	0.02 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\helixultimate\helixultimate.php:134
8	plgSystemHelixultimate->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.63 ms After last query: 0.19 ms Query memory: 0.006 MB Memory before query: 1.948 MB

UPDATE `n6a03_extensions`

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

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

Explain

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

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.03 ms
init for update	0.07 ms
Updating	0.08 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.83 ms
Query end	0.04 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.09 ms
Reset for next command	0.02 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\helixultimate\helixultimate.php:134
8	plgSystemHelixultimate->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.92 ms After last query: 24.23 ms Query memory: 0.019 MB Memory before query: 1.971 MB Rows returned: 1

SELECT *

  FROM n6a03_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.03 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.10 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.10 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Language\LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT\libraries\src\Application\SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT\libraries\src\Application\SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php: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.12 ms After last query: 1.21 ms Query memory: 0.066 MB Memory before query: 1.983 MB Rows returned: 6

SELECT id, home, template, s.params

  FROM n6a03_template_styles as s

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	6	Using index condition; Using where
1	SIMPLE	s	ref\|filter	idx_template,idx_client_id,idx_client_id_home	idx_template\|idx_client_id	202\|1	bancozim_bec3.e.element	1 (75%)	Using index condition; Using where; Using rowid filter

Profile

Status	Duration
Starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.03 ms
init	0.03 ms
Optimizing	0.04 ms
Statistics	0.11 ms
Preparing	0.04 ms
Executing	0.02 ms
Sending data	0.23 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.08 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Application\SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT\libraries\src\Application\SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 2.04 ms After last query: 227.15 ms Query memory: 0.027 MB Memory before query: 2.114 MB Rows returned: 37

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

  FROM `n6a03_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_spauthorarchive','com_sppagebuilder','com_tags','com_templates','com_users','com_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n6a03_assets	range	idx_asset_name	idx_asset_name	202	NULL	38	Using index condition

Profile

Status	Duration
Starting	0.19 ms
checking permissions	0.03 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.04 ms
init	0.08 ms
Optimizing	0.05 ms
Statistics	0.19 ms
Preparing	0.12 ms
Executing	0.04 ms
Sending data	0.38 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.03 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.18 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Access\Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT\libraries\src\Access\Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT\libraries\src\Access\Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT\libraries\src\Access\Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT\libraries\src\User\User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT\components\com_sppagebuilder\models\page.php:30
11	SppagebuilderModelPage->populateState()	JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT\components\com_sppagebuilder\models\page.php:176
9	SppagebuilderModelPage->hit()	JROOT\components\com_sppagebuilder\controller.php:65
8	SppagebuilderController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:20
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.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: 30.26 ms After last query: 25.83 ms Query memory: 0.027 MB Memory before query: 2.171 MB Rows returned: 25

SHOW FULL COLUMNS 
  FROM `n6a03_sppagebuilder`

Explain

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

Profile

Status	Duration
Starting	0.15 ms
checking permissions	0.03 ms
closing tables	0.03 ms
checking permissions	0.03 ms
Opening tables	27.72 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.03 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.02 ms
Filling schema table	0.03 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
checking permissions	0.16 ms
closing tables	0.02 ms
checking permissions	0.02 ms
Executing	0.02 ms
Sending data	0.10 ms
End of update loop	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Removing tmp table	1.03 ms
closing tables	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.15 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\mysqli.php:445
14	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\src\Table\Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT\libraries\src\Table\Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT\administrator\components\com_sppagebuilder\tables\page.php:17
11	SppagebuilderTablePage->__construct()	JROOT\libraries\src\Table\Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT\components\com_sppagebuilder\models\page.php:177
9	SppagebuilderModelPage->hit()	JROOT\components\com_sppagebuilder\controller.php:65
8	SppagebuilderController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:20
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.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.58 ms After last query: 22.36 ms Query memory: 0.280 MB Memory before query: 2.208 MB Rows returned: 1

SELECT *

  FROM n6a03_sppagebuilder

  WHERE `id` = '234'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n6a03_sppagebuilder	const	PRIMARY	PRIMARY	8	const	1

Profile

Status	Duration
Starting	0.25 ms
checking permissions	0.06 ms
Opening tables	0.09 ms
After opening tables	0.06 ms
System lock	0.05 ms
table lock	0.09 ms
init	0.11 ms
Optimizing	0.07 ms
Statistics	0.32 ms
Preparing	0.05 ms
Unlocking tables	0.06 ms
Preparing	0.07 ms
Executing	0.05 ms
Sending data	1.08 ms
End of update loop	0.09 ms
Query end	0.07 ms
Commit	0.07 ms
Query end	0.07 ms
closing tables	0.06 ms
Unlocking tables	0.05 ms
closing tables	0.12 ms
Query end	0.06 ms
Starting cleanup	0.06 ms
Freeing items	0.06 ms
Updating status	0.25 ms
Reset for next command	0.08 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT\libraries\src\Table\Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT\components\com_sppagebuilder\models\page.php:178
9	SppagebuilderModelPage->hit()	JROOT\components\com_sppagebuilder\controller.php:65
8	SppagebuilderController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:20
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.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.24 ms After last query: 0.32 ms Query memory: 0.005 MB Memory before query: 2.344 MB

UPDATE n6a03_sppagebuilder

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

  WHERE `id` = '234'

Explain

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

Profile

Status	Duration
Starting	0.34 ms
checking permissions	0.06 ms
Opening tables	0.08 ms
After opening tables	0.06 ms
System lock	0.05 ms
table lock	0.09 ms
init for update	0.15 ms
Updating	0.30 ms
End of update loop	0.06 ms
Query end	0.07 ms
Commit	1.20 ms
Query end	0.05 ms
closing tables	0.04 ms
Unlocking tables	0.04 ms
closing tables	0.14 ms
Query end	0.05 ms
Starting cleanup	0.04 ms
Freeing items	0.05 ms
Updating status	0.22 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\src\Table\Table.php:1245
10	Joomla\CMS\Table\Table->hit()	JROOT\components\com_sppagebuilder\models\page.php:179
9	SppagebuilderModelPage->hit()	JROOT\components\com_sppagebuilder\controller.php:65
8	SppagebuilderController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:20
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.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.51 ms After last query: 18.16 ms Query memory: 0.281 MB Memory before query: 2.302 MB Rows returned: 1

SELECT a.*,l.title AS language_title,ua.name AS author_name

  FROM n6a03_sppagebuilder as a

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

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

  WHERE a.id = 234 
  AND a.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	8	const	1
1	SIMPLE	l	const	idx_langcode	idx_langcode	28	const	0	Unique row not found
1	SIMPLE	ua	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.25 ms
checking permissions	0.05 ms
Opening tables	0.10 ms
After opening tables	0.05 ms
System lock	0.05 ms
table lock	0.08 ms
init	0.12 ms
Optimizing	0.17 ms
Statistics	0.32 ms
Preparing	0.06 ms
Unlocking tables	0.06 ms
Preparing	0.07 ms
Executing	0.05 ms
Sending data	1.02 ms
End of update loop	0.06 ms
Query end	0.05 ms
Commit	0.06 ms
Query end	0.05 ms
closing tables	0.05 ms
Unlocking tables	0.07 ms
closing tables	0.11 ms
Query end	0.06 ms
Starting cleanup	0.05 ms
Freeing items	0.06 ms
Updating status	0.24 ms
Reset for next command	0.09 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT\components\com_sppagebuilder\models\page.php:83
12	SppagebuilderModelPage->getItem()	JROOT\libraries\src\MVC\View\HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT\components\com_sppagebuilder\views\page\view.html.php:27
10	SppagebuilderViewPage->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_sppagebuilder\controller.php:68
8	SppagebuilderController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:20
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 1.64 ms After last query: 7.25 ms Query memory: 0.024 MB Memory before query: 2.457 MB Rows returned: 1

Duplicate queries: #19 #20 #21 #22 #23 #34 #35 #36 #37 #38 #39

SELECT e.manifest_cache,`e`.`manifest_cache`

  FROM `n6a03_extensions` AS `e`

  WHERE `e`.`element` = 'com_sppagebuilder'

Explain

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

Profile

Status	Duration
Starting	0.41 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.04 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.13 ms
Preparing	0.05 ms
Executing	0.02 ms
Sending data	0.10 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.04 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.04 ms
Query end	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.20 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT\components\com_sppagebuilder\helpers\helper.php:134
15	SppagebuilderHelperSite::getVersion()	JROOT\components\com_sppagebuilder\helpers\helper.php:120
14	SppagebuilderHelperSite::addStylesheet()	JROOT\components\com_sppagebuilder\views\page\tmpl\default.php:26
13	include JROOT\components\com_sppagebuilder\views\page\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_sppagebuilder\views\page\view.html.php:42
10	SppagebuilderViewPage->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_sppagebuilder\controller.php:68
8	SppagebuilderController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:20
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 1.37 ms After last query: 0.14 ms Query memory: 0.024 MB Memory before query: 2.467 MB Rows returned: 1

Duplicate queries: #18 #20 #21 #22 #23 #34 #35 #36 #37 #38 #39

SELECT e.manifest_cache,`e`.`manifest_cache`

  FROM `n6a03_extensions` AS `e`

  WHERE `e`.`element` = 'com_sppagebuilder'

Explain

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

Profile

Status	Duration
Starting	0.16 ms
checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.07 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.11 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.09 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.17 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT\components\com_sppagebuilder\helpers\helper.php:134
15	SppagebuilderHelperSite::getVersion()	JROOT\components\com_sppagebuilder\helpers\helper.php:120
14	SppagebuilderHelperSite::addStylesheet()	JROOT\components\com_sppagebuilder\views\page\tmpl\default.php:27
13	include JROOT\components\com_sppagebuilder\views\page\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_sppagebuilder\views\page\view.html.php:42
10	SppagebuilderViewPage->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_sppagebuilder\controller.php:68
8	SppagebuilderController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:20
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 1.21 ms After last query: 0.11 ms Query memory: 0.024 MB Memory before query: 2.476 MB Rows returned: 1

Duplicate queries: #18 #19 #21 #22 #23 #34 #35 #36 #37 #38 #39

SELECT e.manifest_cache,`e`.`manifest_cache`

  FROM `n6a03_extensions` AS `e`

  WHERE `e`.`element` = 'com_sppagebuilder'

Explain

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

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.05 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.08 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.08 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.16 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT\components\com_sppagebuilder\helpers\helper.php:134
15	SppagebuilderHelperSite::getVersion()	JROOT\components\com_sppagebuilder\helpers\helper.php:120
14	SppagebuilderHelperSite::addStylesheet()	JROOT\components\com_sppagebuilder\views\page\tmpl\default.php:32
13	include JROOT\components\com_sppagebuilder\views\page\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_sppagebuilder\views\page\view.html.php:42
10	SppagebuilderViewPage->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_sppagebuilder\controller.php:68
8	SppagebuilderController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:20
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 1.23 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 2.485 MB Rows returned: 1

Duplicate queries: #18 #19 #20 #22 #23 #34 #35 #36 #37 #38 #39

SELECT e.manifest_cache,`e`.`manifest_cache`

  FROM `n6a03_extensions` AS `e`

  WHERE `e`.`element` = 'com_sppagebuilder'

Explain

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

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.03 ms
table lock	0.05 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.08 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.09 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.15 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT\components\com_sppagebuilder\helpers\helper.php:134
15	SppagebuilderHelperSite::getVersion()	JROOT\components\com_sppagebuilder\helpers\helper.php:120
14	SppagebuilderHelperSite::addStylesheet()	JROOT\components\com_sppagebuilder\views\page\tmpl\default.php:37
13	include JROOT\components\com_sppagebuilder\views\page\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_sppagebuilder\views\page\view.html.php:42
10	SppagebuilderViewPage->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_sppagebuilder\controller.php:68
8	SppagebuilderController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:20
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.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.80 ms After last query: 0.13 ms Query memory: 0.023 MB Memory before query: 2.494 MB Rows returned: 1

Duplicate queries: #18 #19 #20 #21 #23 #34 #35 #36 #37 #38 #39

SELECT e.manifest_cache,`e`.`manifest_cache`

  FROM `n6a03_extensions` AS `e`

  WHERE `e`.`element` = 'com_sppagebuilder'

Explain

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

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.03 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.10 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT\components\com_sppagebuilder\helpers\helper.php:134
14	SppagebuilderHelperSite::getVersion()	JROOT\components\com_sppagebuilder\views\page\tmpl\default.php:41
13	include JROOT\components\com_sppagebuilder\views\page\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_sppagebuilder\views\page\view.html.php:42
10	SppagebuilderViewPage->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_sppagebuilder\controller.php:68
8	SppagebuilderController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:20
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.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.97 ms After last query: 9.10 ms Query memory: 0.023 MB Memory before query: 2.503 MB Rows returned: 1

Duplicate queries: #18 #19 #20 #21 #22 #34 #35 #36 #37 #38 #39

SELECT e.manifest_cache,`e`.`manifest_cache`

  FROM `n6a03_extensions` AS `e`

  WHERE `e`.`element` = 'com_sppagebuilder'

Explain

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

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.04 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.11 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT\components\com_sppagebuilder\helpers\helper.php:134
14	SppagebuilderHelperSite::getVersion()	JROOT\components\com_sppagebuilder\views\page\tmpl\default.php:42
13	include JROOT\components\com_sppagebuilder\views\page\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_sppagebuilder\views\page\view.html.php:42
10	SppagebuilderViewPage->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_sppagebuilder\controller.php:68
8	SppagebuilderController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:20
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 1.29 ms After last query: 14.00 ms Query memory: 0.025 MB Memory before query: 2.511 MB Rows returned: 1

Duplicate queries: #25 #40 #41 #42

SELECT `template`

  FROM `n6a03_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n6a03_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	6	Using where

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.06 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.08 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.06 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.18 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT\components\com_sppagebuilder\parser\addon-parser.php:648
16	AddonParser::getTemplateName()	JROOT\components\com_sppagebuilder\parser\addon-parser.php:154
15	AddonParser::getAddons()	JROOT\components\com_sppagebuilder\parser\addon-parser.php:744
14	require_once JROOT\components\com_sppagebuilder\parser\addon-parser.php	JROOT\components\com_sppagebuilder\views\page\tmpl\default.php:59
13	include JROOT\components\com_sppagebuilder\views\page\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_sppagebuilder\views\page\view.html.php:42
10	SppagebuilderViewPage->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_sppagebuilder\controller.php:68
8	SppagebuilderController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:20
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.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.84 ms After last query: 341.41 ms Query memory: 0.025 MB Memory before query: 3.728 MB Rows returned: 1

Duplicate queries: #24 #40 #41 #42

SELECT `template`

  FROM `n6a03_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n6a03_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	6	Using where

Profile

Status	Duration
Starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.03 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.12 ms
Reset for next command	0.02 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_sppagebuilder\builder\classes\base.php:37
16	SpPgaeBuilderBase::getTemplateName()	JROOT\administrator\components\com_sppagebuilder\builder\classes\base.php:45
15	SpPgaeBuilderBase::loadAddons()	JROOT\components\com_sppagebuilder\parser\addon-parser.php:199
14	AddonParser::viewAddons()	JROOT\components\com_sppagebuilder\views\page\tmpl\default.php:97
13	include JROOT\components\com_sppagebuilder\views\page\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_sppagebuilder\views\page\view.html.php:42
10	SppagebuilderViewPage->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_sppagebuilder\controller.php:68
8	SppagebuilderController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:20
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 1.30 ms After last query: 189.52 ms Query memory: 0.026 MB Memory before query: 3.850 MB Rows returned: 7

SELECT DISTINCT a.id, a.title, a.level, a.published, a.lft, a.parent_id

  FROM (
SELECT id,title,level,published,parent_id,lft,rgt

  FROM n6a03_tags

  WHERE `published` = '1') AS a

  LEFT JOIN `n6a03_tags` AS b 
  ON a.lft > b.lft 
  AND a.rgt < b.rgt

  WHERE `a`.`level` != '0'

  ORDER BY a.lft ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n6a03_tags	ALL	tag_idx	NO INDEX KEY COULD BE USED	NULL	NULL	8	Using where; Using temporary; Using filesort
1	SIMPLE	b	ALL	idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	8	Range checked for each record (index map: 0x20); Distinct

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.03 ms
init	0.12 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.13 ms
Creating sort index	0.05 ms
Removing tmp table	0.05 ms
Creating sort index	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.03 ms
Query end	0.02 ms
closing tables	0.02 ms
Removing tmp table	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.09 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT\administrator\components\com_sppagebuilder\builder\classes\base.php:194
17	SpPgaeBuilderBase::getArticleTags()	JROOT\components\com_sppagebuilder\addons\articles\admin.php:163
16	require_once JROOT\components\com_sppagebuilder\addons\articles\admin.php	JROOT\administrator\components\com_sppagebuilder\builder\classes\base.php:68
15	SpPgaeBuilderBase::loadAddons()	JROOT\components\com_sppagebuilder\parser\addon-parser.php:199
14	AddonParser::viewAddons()	JROOT\components\com_sppagebuilder\views\page\tmpl\default.php:97
13	include JROOT\components\com_sppagebuilder\views\page\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_sppagebuilder\views\page\view.html.php:42
10	SppagebuilderViewPage->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_sppagebuilder\controller.php:68
8	SppagebuilderController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:20
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.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.95 ms After last query: 0.16 ms Query memory: 0.025 MB Memory before query: 3.858 MB Rows returned: 0

Duplicate queries: #28 #29

SELECT a.enabled

  FROM `n6a03_extensions` AS `a`

  WHERE `a`.`name` = 'com_k2'

Explain

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

Profile

Status	Duration
Starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.03 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.17 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.10 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT\administrator\components\com_sppagebuilder\builder\classes\base.php:545
17	SpPgaeBuilderBase::k2CatList()	JROOT\components\com_sppagebuilder\addons\articles\admin.php:172
16	require_once JROOT\components\com_sppagebuilder\addons\articles\admin.php	JROOT\administrator\components\com_sppagebuilder\builder\classes\base.php:68
15	SpPgaeBuilderBase::loadAddons()	JROOT\components\com_sppagebuilder\parser\addon-parser.php:199
14	AddonParser::viewAddons()	JROOT\components\com_sppagebuilder\views\page\tmpl\default.php:97
13	include JROOT\components\com_sppagebuilder\views\page\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_sppagebuilder\views\page\view.html.php:42
10	SppagebuilderViewPage->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_sppagebuilder\controller.php:68
8	SppagebuilderController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:20
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.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.91 ms After last query: 0.44 ms Query memory: 0.025 MB Memory before query: 3.873 MB Rows returned: 0

Duplicate queries: #27 #29

SELECT a.enabled

  FROM `n6a03_extensions` AS `a`

  WHERE `a`.`name` = 'com_k2'

Explain

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

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.03 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.04 ms
Executing	0.02 ms
Sending data	0.18 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.03 ms
Freeing items	0.02 ms
Updating status	0.08 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT\administrator\components\com_sppagebuilder\builder\classes\base.php:545
17	SpPgaeBuilderBase::k2CatList()	JROOT\components\com_sppagebuilder\addons\articles\admin.php:279
16	require_once JROOT\components\com_sppagebuilder\addons\articles\admin.php	JROOT\administrator\components\com_sppagebuilder\builder\classes\base.php:68
15	SpPgaeBuilderBase::loadAddons()	JROOT\components\com_sppagebuilder\parser\addon-parser.php:199
14	AddonParser::viewAddons()	JROOT\components\com_sppagebuilder\views\page\tmpl\default.php:97
13	include JROOT\components\com_sppagebuilder\views\page\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_sppagebuilder\views\page\view.html.php:42
10	SppagebuilderViewPage->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_sppagebuilder\controller.php:68
8	SppagebuilderController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:20
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.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.87 ms After last query: 6.15 ms Query memory: 0.025 MB Memory before query: 3.908 MB Rows returned: 0

Duplicate queries: #27 #28

SELECT a.enabled

  FROM `n6a03_extensions` AS `a`

  WHERE `a`.`name` = 'com_k2'

Explain

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

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.03 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.03 ms
Sending data	0.10 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.03 ms
Freeing items	0.02 ms
Updating status	0.09 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT\administrator\components\com_sppagebuilder\builder\classes\base.php:545
17	SpPgaeBuilderBase::k2CatList()	JROOT\components\com_sppagebuilder\addons\articles_scroller\admin.php:138
16	require_once JROOT\components\com_sppagebuilder\addons\articles_scroller\admin.php	JROOT\administrator\components\com_sppagebuilder\builder\classes\base.php:68
15	SpPgaeBuilderBase::loadAddons()	JROOT\components\com_sppagebuilder\parser\addon-parser.php:199
14	AddonParser::viewAddons()	JROOT\components\com_sppagebuilder\views\page\tmpl\default.php:97
13	include JROOT\components\com_sppagebuilder\views\page\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_sppagebuilder\views\page\view.html.php:42
10	SppagebuilderViewPage->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_sppagebuilder\controller.php:68
8	SppagebuilderController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:20
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.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: 2.78 ms After last query: 136.42 ms Query memory: 0.025 MB Memory before query: 4.595 MB Rows returned: 0

SELECT a.enabled

  FROM `n6a03_extensions` AS `a`

  WHERE (`a`.`element` = 'com_acymailing' OR `a`.`element` = 'com_acym')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	element_clientid,element_folder_clientid	element_clientid	402	NULL	2	Using index condition

Profile

Status	Duration
Starting	0.25 ms
checking permissions	0.06 ms
Opening tables	0.08 ms
After opening tables	0.06 ms
System lock	0.05 ms
table lock	0.09 ms
init	0.09 ms
Optimizing	0.08 ms
Statistics	0.21 ms
Preparing	0.09 ms
Executing	0.07 ms
Sending data	0.15 ms
End of update loop	0.07 ms
Query end	0.07 ms
Commit	0.07 ms
Query end	0.08 ms
closing tables	0.32 ms
Unlocking tables	0.07 ms
closing tables	0.07 ms
Query end	0.06 ms
Starting cleanup	0.05 ms
Freeing items	0.06 ms
Updating status	0.28 ms
Reset for next command	0.06 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT\administrator\components\com_sppagebuilder\builder\classes\base.php:470
17	SpPgaeBuilderBase::acymailingList()	JROOT\components\com_sppagebuilder\addons\optin_form\admin.php:163
16	require_once JROOT\components\com_sppagebuilder\addons\optin_form\admin.php	JROOT\administrator\components\com_sppagebuilder\builder\classes\base.php:68
15	SpPgaeBuilderBase::loadAddons()	JROOT\components\com_sppagebuilder\parser\addon-parser.php:199
14	AddonParser::viewAddons()	JROOT\components\com_sppagebuilder\views\page\tmpl\default.php:97
13	include JROOT\components\com_sppagebuilder\views\page\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_sppagebuilder\views\page\view.html.php:42
10	SppagebuilderViewPage->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_sppagebuilder\controller.php:68
8	SppagebuilderController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:20
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 1.66 ms After last query: 1167.20 ms Query memory: 0.034 MB Memory before query: 5.221 MB Rows returned: 80

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

  FROM `n6a03_assets`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n6a03_assets	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	288	Using where

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.04 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.09 ms
Preparing	0.04 ms
Executing	0.02 ms
Sending data	0.55 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.03 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.12 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Access\Access.php:359
18	Joomla\CMS\Access\Access::preloadPermissions()	JROOT\libraries\src\Access\Access.php:226
17	Joomla\CMS\Access\Access::preload()	JROOT\libraries\src\Access\Access.php:540
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT\libraries\src\Access\Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT\libraries\src\User\User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT\components\com_sppagebuilder\views\page\tmpl\default.php:99
13	include JROOT\components\com_sppagebuilder\views\page\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_sppagebuilder\views\page\view.html.php:42
10	SppagebuilderViewPage->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_sppagebuilder\controller.php:68
8	SppagebuilderController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:20
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.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: 4.65 ms After last query: 185.21 ms Query memory: 0.026 MB Memory before query: 4.585 MB Rows returned: 10

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

  FROM n6a03_modules AS m

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

  LEFT JOIN n6a03_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 <= '2025-12-15 02:30:42') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-12-15 02:30:42') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 277 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	17	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	bancozim_bec3.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	bancozim_bec3.m.module,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.39 ms
checking permissions	0.06 ms
Opening tables	0.09 ms
After opening tables	0.06 ms
System lock	0.08 ms
table lock	0.12 ms
init	0.20 ms
Optimizing	0.22 ms
Statistics	0.36 ms
Preparing	0.21 ms
Sorting result	0.10 ms
Executing	0.07 ms
Sending data	0.10 ms
Creating sort index	0.98 ms
End of update loop	0.11 ms
Query end	0.06 ms
Commit	0.06 ms
Query end	0.06 ms
closing tables	0.06 ms
Unlocking tables	0.07 ms
closing tables	0.11 ms
Query end	0.08 ms
Starting cleanup	0.06 ms
Freeing items	0.18 ms
Updating status	0.52 ms
Reset for next command	0.13 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
18	JDatabaseDriver->loadObjectList()	Same as call in the line below.
17	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Helper\ModuleHelper.php:432
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT\libraries\src\Helper\ModuleHelper.php:362
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT\libraries\src\Helper\ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT\libraries\src\Document\HtmlDocument.php:591
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT\plugins\system\helixultimate\core\helixultimate.php:570
11	HelixUltimate->count_modules()	JROOT\plugins\system\helixultimate\core\helixultimate.php:374
10	HelixUltimate->get_current_row()	JROOT\plugins\system\helixultimate\core\helixultimate.php:306
9	HelixUltimate->get_recursive_layout()	JROOT\plugins\system\helixultimate\core\helixultimate.php:274
8	HelixUltimate->render_layout()	JROOT\templates\shaper_languageschool\index.php:147
7	require JROOT\templates\shaper_languageschool\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: 7.09 ms After last query: 428.26 ms Query memory: 0.102 MB Memory before query: 4.690 MB Rows returned: 1

SELECT *

  FROM `n6a03_sppagebuilder`

  WHERE `extension` = 'mod_sppagebuilder' 
  AND `extension_view` = 'module' 
  AND `view_id` = '102'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n6a03_sppagebuilder	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	186	Using where

Profile

Status	Duration
Starting	0.27 ms
checking permissions	0.06 ms
Opening tables	0.09 ms
After opening tables	0.06 ms
System lock	0.06 ms
table lock	0.09 ms
init	0.14 ms
Optimizing	0.10 ms
Statistics	0.08 ms
Preparing	0.16 ms
Executing	0.06 ms
Sending data	4.71 ms
End of update loop	0.09 ms
Query end	0.06 ms
Commit	0.06 ms
Query end	0.08 ms
closing tables	0.06 ms
Unlocking tables	0.06 ms
closing tables	0.10 ms
Query end	0.06 ms
Starting cleanup	0.06 ms
Freeing items	0.06 ms
Updating status	0.26 ms
Reset for next command	0.09 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT\modules\mod_sppagebuilder\helper.php:38
12	ModSPagebuilderHelper::pageBuilderData()	JROOT\modules\mod_sppagebuilder\helper.php:14
11	ModSPagebuilderHelper::getData()	JROOT\modules\mod_sppagebuilder\mod_sppagebuilder.php:13
10	include JROOT\modules\mod_sppagebuilder\mod_sppagebuilder.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->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.59 ms After last query: 8.75 ms Query memory: 0.023 MB Memory before query: 4.737 MB Rows returned: 1

Duplicate queries: #18 #19 #20 #21 #22 #23 #35 #36 #37 #38 #39

SELECT e.manifest_cache,`e`.`manifest_cache`

  FROM `n6a03_extensions` AS `e`

  WHERE `e`.`element` = 'com_sppagebuilder'

Explain

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

Profile

Status	Duration
Starting	0.23 ms
checking permissions	0.03 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.05 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.11 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.08 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.18 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT\components\com_sppagebuilder\helpers\helper.php:134
13	SppagebuilderHelperSite::getVersion()	JROOT\components\com_sppagebuilder\helpers\helper.php:120
12	SppagebuilderHelperSite::addStylesheet()	JROOT\modules\mod_sppagebuilder\tmpl\default.php:22
11	require JROOT\modules\mod_sppagebuilder\tmpl\default.php	JROOT\modules\mod_sppagebuilder\mod_sppagebuilder.php:16
10	include JROOT\modules\mod_sppagebuilder\mod_sppagebuilder.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->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.15 ms After last query: 0.19 ms Query memory: 0.023 MB Memory before query: 4.745 MB Rows returned: 1

Duplicate queries: #18 #19 #20 #21 #22 #23 #34 #36 #37 #38 #39

SELECT e.manifest_cache,`e`.`manifest_cache`

  FROM `n6a03_extensions` AS `e`

  WHERE `e`.`element` = 'com_sppagebuilder'

Explain

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

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.05 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.07 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.04 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.14 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT\components\com_sppagebuilder\helpers\helper.php:134
13	SppagebuilderHelperSite::getVersion()	JROOT\components\com_sppagebuilder\helpers\helper.php:120
12	SppagebuilderHelperSite::addStylesheet()	JROOT\modules\mod_sppagebuilder\tmpl\default.php:23
11	require JROOT\modules\mod_sppagebuilder\tmpl\default.php	JROOT\modules\mod_sppagebuilder\mod_sppagebuilder.php:16
10	include JROOT\modules\mod_sppagebuilder\mod_sppagebuilder.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->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.26 ms After last query: 0.16 ms Query memory: 0.023 MB Memory before query: 4.752 MB Rows returned: 1

Duplicate queries: #18 #19 #20 #21 #22 #23 #34 #35 #37 #38 #39

SELECT e.manifest_cache,`e`.`manifest_cache`

  FROM `n6a03_extensions` AS `e`

  WHERE `e`.`element` = 'com_sppagebuilder'

Explain

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

Profile

Status	Duration
Starting	0.13 ms
checking permissions	0.05 ms
Opening tables	0.08 ms
After opening tables	0.05 ms
System lock	0.07 ms
table lock	0.06 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.07 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.04 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.12 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT\components\com_sppagebuilder\helpers\helper.php:134
13	SppagebuilderHelperSite::getVersion()	JROOT\components\com_sppagebuilder\helpers\helper.php:120
12	SppagebuilderHelperSite::addStylesheet()	JROOT\modules\mod_sppagebuilder\tmpl\default.php:28
11	require JROOT\modules\mod_sppagebuilder\tmpl\default.php	JROOT\modules\mod_sppagebuilder\mod_sppagebuilder.php:16
10	include JROOT\modules\mod_sppagebuilder\mod_sppagebuilder.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->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.06 ms After last query: 0.15 ms Query memory: 0.023 MB Memory before query: 4.759 MB Rows returned: 1

Duplicate queries: #18 #19 #20 #21 #22 #23 #34 #35 #36 #38 #39

SELECT e.manifest_cache,`e`.`manifest_cache`

  FROM `n6a03_extensions` AS `e`

  WHERE `e`.`element` = 'com_sppagebuilder'

Explain

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

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.05 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.07 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.03 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.12 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT\components\com_sppagebuilder\helpers\helper.php:134
13	SppagebuilderHelperSite::getVersion()	JROOT\components\com_sppagebuilder\helpers\helper.php:120
12	SppagebuilderHelperSite::addStylesheet()	JROOT\modules\mod_sppagebuilder\tmpl\default.php:33
11	require JROOT\modules\mod_sppagebuilder\tmpl\default.php	JROOT\modules\mod_sppagebuilder\mod_sppagebuilder.php:16
10	include JROOT\modules\mod_sppagebuilder\mod_sppagebuilder.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->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.05 ms After last query: 0.16 ms Query memory: 0.023 MB Memory before query: 4.767 MB Rows returned: 1

Duplicate queries: #18 #19 #20 #21 #22 #23 #34 #35 #36 #37 #39

SELECT e.manifest_cache,`e`.`manifest_cache`

  FROM `n6a03_extensions` AS `e`

  WHERE `e`.`element` = 'com_sppagebuilder'

Explain

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

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.05 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.06 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Query end	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.12 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT\components\com_sppagebuilder\helpers\helper.php:134
12	SppagebuilderHelperSite::getVersion()	JROOT\modules\mod_sppagebuilder\tmpl\default.php:37
11	require JROOT\modules\mod_sppagebuilder\tmpl\default.php	JROOT\modules\mod_sppagebuilder\mod_sppagebuilder.php:16
10	include JROOT\modules\mod_sppagebuilder\mod_sppagebuilder.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->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.47 ms After last query: 8.51 ms Query memory: 0.023 MB Memory before query: 4.774 MB Rows returned: 1

Duplicate queries: #18 #19 #20 #21 #22 #23 #34 #35 #36 #37 #38

SELECT e.manifest_cache,`e`.`manifest_cache`

  FROM `n6a03_extensions` AS `e`

  WHERE `e`.`element` = 'com_sppagebuilder'

Explain

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

Profile

Status	Duration
Starting	0.17 ms
checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.04 ms
table lock	0.07 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.10 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.08 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.04 ms
closing tables	0.04 ms
Query end	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.20 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT\components\com_sppagebuilder\helpers\helper.php:134
12	SppagebuilderHelperSite::getVersion()	JROOT\modules\mod_sppagebuilder\tmpl\default.php:38
11	require JROOT\modules\mod_sppagebuilder\tmpl\default.php	JROOT\modules\mod_sppagebuilder\mod_sppagebuilder.php:16
10	include JROOT\modules\mod_sppagebuilder\mod_sppagebuilder.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->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.97 ms After last query: 11.33 ms Query memory: 0.023 MB Memory before query: 5.062 MB Rows returned: 1

Duplicate queries: #24 #25 #41 #42

SELECT `template`

  FROM `n6a03_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n6a03_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	6	Using where

Profile

Status	Duration
Starting	0.21 ms
checking permissions	0.06 ms
Opening tables	0.11 ms
After opening tables	0.06 ms
System lock	0.05 ms
table lock	0.09 ms
init	0.09 ms
Optimizing	0.07 ms
Statistics	0.12 ms
Preparing	0.07 ms
Executing	0.04 ms
Sending data	0.10 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	0.04 ms
Query end	0.04 ms
closing tables	0.06 ms
Unlocking tables	0.05 ms
closing tables	0.05 ms
Query end	0.05 ms
Starting cleanup	0.04 ms
Freeing items	0.05 ms
Updating status	0.24 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT\administrator\components\com_sppagebuilder\builder\classes\base.php:37
14	SpPgaeBuilderBase::getTemplateName()	JROOT\administrator\components\com_sppagebuilder\builder\classes\base.php:45
13	SpPgaeBuilderBase::loadAddons()	JROOT\components\com_sppagebuilder\parser\addon-parser.php:199
12	AddonParser::viewAddons()	JROOT\modules\mod_sppagebuilder\tmpl\default.php:42
11	require JROOT\modules\mod_sppagebuilder\tmpl\default.php	JROOT\modules\mod_sppagebuilder\mod_sppagebuilder.php:16
10	include JROOT\modules\mod_sppagebuilder\mod_sppagebuilder.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->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.15 ms After last query: 331.11 ms Query memory: 0.024 MB Memory before query: 5.100 MB Rows returned: 1

Duplicate queries: #24 #25 #40 #42

SELECT `template`

  FROM `n6a03_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n6a03_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	6	Using where

Profile

Status	Duration
Starting	0.12 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.03 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.08 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.11 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT\administrator\components\com_sppagebuilder\builder\classes\base.php:37
15	SpPgaeBuilderBase::getTemplateName()	JROOT\administrator\components\com_sppagebuilder\builder\classes\base.php:45
14	SpPgaeBuilderBase::loadAddons()	JROOT\components\com_sppagebuilder\parser\addon-parser.php:199
13	AddonParser::viewAddons()	JROOT\components\com_sppagebuilder\parser\addon-parser.php:288
12	AddonParser::viewAddons()	JROOT\modules\mod_sppagebuilder\tmpl\default.php:42
11	require JROOT\modules\mod_sppagebuilder\tmpl\default.php	JROOT\modules\mod_sppagebuilder\mod_sppagebuilder.php:16
10	include JROOT\modules\mod_sppagebuilder\mod_sppagebuilder.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->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: 3.00 ms After last query: 442.34 ms Query memory: 0.024 MB Memory before query: 5.138 MB Rows returned: 1

Duplicate queries: #24 #25 #40 #41

SELECT `template`

  FROM `n6a03_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n6a03_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	6	Using where

Profile

Status	Duration
Starting	0.33 ms
checking permissions	0.16 ms
Opening tables	0.09 ms
After opening tables	0.05 ms
System lock	0.09 ms
table lock	0.10 ms
init	0.09 ms
Optimizing	0.09 ms
Statistics	0.30 ms
Preparing	0.11 ms
Executing	0.05 ms
Sending data	0.18 ms
End of update loop	0.07 ms
Query end	0.06 ms
Commit	0.05 ms
Query end	0.05 ms
closing tables	0.05 ms
Unlocking tables	0.05 ms
closing tables	0.14 ms
Query end	0.05 ms
Starting cleanup	0.05 ms
Freeing items	0.11 ms
Updating status	0.32 ms
Reset for next command	0.05 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT\administrator\components\com_sppagebuilder\builder\classes\base.php:37
15	SpPgaeBuilderBase::getTemplateName()	JROOT\administrator\components\com_sppagebuilder\builder\classes\base.php:45
14	SpPgaeBuilderBase::loadAddons()	JROOT\components\com_sppagebuilder\parser\addon-parser.php:199
13	AddonParser::viewAddons()	JROOT\components\com_sppagebuilder\parser\addon-parser.php:288
12	AddonParser::viewAddons()	JROOT\modules\mod_sppagebuilder\tmpl\default.php:42
11	require JROOT\modules\mod_sppagebuilder\tmpl\default.php	JROOT\modules\mod_sppagebuilder\mod_sppagebuilder.php:16
10	include JROOT\modules\mod_sppagebuilder\mod_sppagebuilder.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->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.]

22 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

12 × SELECT e.manifest_cache,`e`.`manifest_cache`
 
  FROM `n6a03_extensions` AS `e`

5 × SELECT `template`
 
  FROM `n6a03_template_styles`

4 × SELECT a.enabled
 
  FROM `n6a03_extensions` AS `a`

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

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

1 × SELECT *
 
  FROM n6a03_sppagebuilder

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

1 × SELECT DISTINCT a.id, a.title, a.level, a.published, a.lft, a.parent_id
 
  FROM (
 SELECT id,title,level,published,parent_id,lft,rgt
 
  FROM n6a03_tags

1 × SELECT a.*,l.title AS language_title,ua.name AS author_name
 
  FROM n6a03_sppagebuilder as a
 
  LEFT JOIN `n6a03_languages` AS l 
  ON l.lang_code = a.language
 
  LEFT JOIN n6a03_users AS ua 
  ON ua.id = a.created_by

1 × SELECT `data`
 
  FROM `n6a03_session`

1 × SELECT `session_id`
 
  FROM `n6a03_session`

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

```
1 × SELECT *
 
  FROM n6a03_languages
```

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

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

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

1 × SELECT id, rules
 
  FROM `n6a03_viewlevels

1 × SELECT *
 
  FROM `n6a03_sppagebuilder`

OTHER Tables:

1 × INSERT INTO `n6a03_session`
 (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
 (X'6331707630616c63316f3662636b3835726b736c746d6f706f31', 1, 1765765842, 0, '', 0

1 × UPDATE `n6a03_extensions`
 
  SET `params` = '{\"mediaversion\":\"e43e791474a3ddce05508cbfe5a6ca27\"}'

1 × SHOW FULL COLUMNS 
  FROM `n6a03_sppagebuilder

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