OUR SERVICES

ICT Services

We provide foremost field services, roll-out and support services company. Our technical teams provide inclusive services from design to implementation and support. SPTL has partnered with the biggest and most innovative companies and.

Energy Management

We are East Africa’s foremost independent provider of energy management services, uniquely qualified to help your company identify, prioritize, and implement strategies that will conserve energy, lower utility bills, and improve your...

Building & Construction

We are made up of dedicated professionals who bring the latest advances in construction to every project. We’ve worked in most of the African states and are ready to deliver wherever the job takes us. We’ve worked in most of the African states

WELCOME TO STEMINAK PREMIER TECHNOLOGIES LTD

SPTL is a leading Energy and ICT services consultancy and contractor in Kenya and East Africa. The company provides foremost field services, roll-out and support services company. Our technical teams provide inclusive services from design to implementation and support. SPTL has partnered with the biggest and most innovative companies and manufacturers in the world to deliver guaranteed quality services and products.

SPTL is East Africa’s foremost independent provider of energy management services, uniquely qualified to help your company identify, prioritize, and implement strategies that will conserve energy, lower utility bills, and improve your bottom line

Why Choose Us

The company provides foremost field services, roll-out and support services company. Our technical teams provide inclusive services from design to implementation and support. SPTL has partnered with the biggest and most innovative companies and manufacturers in the world to deliver guaranteed quality services and products

FUTURE OF ICT

OUR CLIENTS

Contact Us

Steminak Premier Technologies Ltd

P.O. Box 10778 - 00200 Nairobi

MOB 1: +254 708 414 963

MOB 2: +254 775 034 120

Email: info@sptlkenya.co.ke

About Us

We are the leading Energy and ICT services consultancy and contractor in Kenya and East Africa. The company provides foremost field services, roll-out and support services company. Our technical teams provide inclusive services from design to implementation and support

Quick Links

Follow Us on Twitter

Warning: include(/home/sptlkeny/public_html/modules/mod_jatwitter/tmpl/default.php): failed to open stream: No such file or directory in /home/sptlkeny/public_html/modules/mod_jatwitter/mod_jatwitter.php on line 68

Warning: include(): Failed opening '/home/sptlkeny/public_html/modules/mod_jatwitter/tmpl/default.php' for inclusion (include_path='.:/opt/alt/php56/usr/share/pear:/opt/alt/php56/usr/share/php') in /home/sptlkeny/public_html/modules/mod_jatwitter/mod_jatwitter.php on line 68

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1728251807,
                "last": 1728251807,
                "now": 1728251807
            }
        },
        "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: 12.97 ms / 12.97 ms Memory: 0.196 MB / 0.42 MB Application: afterLoad

Time: 75.34 ms / 88.30 ms Memory: 1.539 MB / 1.96 MB Application: afterInitialise

Time: 37.64 ms / 125.95 ms Memory: 0.712 MB / 2.67 MB Application: afterRoute

Time: 1.95 ms / 127.89 ms Memory: 0.067 MB / 2.74 MB Application: beforeRenderComponent com_sppagebuilder

Time: 6.26 ms / 134.16 ms Memory: 0.181 MB / 2.92 MB Application: Before JAccess::preloadComponents (all components)

Time: 3.75 ms / 137.91 ms Memory: 0.094 MB / 3.01 MB Application: After JAccess::preloadComponents (all components)

Time: 0.16 ms / 138.07 ms Memory: 0.000 MB / 3.01 MB Application: Before JAccess::getAssetRules (id:180 name:com_sppagebuilder)

Time: 1.04 ms / 139.10 ms Memory: 0.018 MB / 3.02 MB Application: After JAccess::getAssetRules (id:180 name:com_sppagebuilder)

Time: 48.65 ms / 187.75 ms Memory: 0.817 MB / 3.84 MB Application: beforeRenderModule mod_unite_revolution2 (Home Slider)

Time: 27.87 ms / 215.63 ms Memory: 0.918 MB / 4.76 MB Application: afterRenderModule mod_unite_revolution2 (Home Slider)

Time: 34.81 ms / 250.43 ms Memory: 0.000 MB / 4.69 MB Application: beforeRenderModule mod_super_simple_contact_form (Super Simple Contact Form)

Time: 2.87 ms / 253.31 ms Memory: 0.035 MB / 4.73 MB Application: afterRenderModule mod_super_simple_contact_form (Super Simple Contact Form)

Time: 20.99 ms / 274.30 ms Memory: 0.078 MB / 4.81 MB Application: beforeRenderModule mod_carousel_banner (Client Portfolio)

Time: 14.15 ms / 288.45 ms Memory: 0.193 MB / 5.00 MB Application: afterRenderModule mod_carousel_banner (Client Portfolio)

Time: 9.45 ms / 297.90 ms Memory: 0.022 MB / 5.02 MB Application: beforeRenderModule mod_sp_simple_map (Our Location on Map)

Time: 2.10 ms / 300.00 ms Memory: 0.015 MB / 5.04 MB Application: afterRenderModule mod_sp_simple_map (Our Location on Map)

Time: 3.28 ms / 303.28 ms Memory: 0.000 MB / 4.86 MB Application: afterRenderComponent com_sppagebuilder

Time: 2.96 ms / 306.24 ms Memory: 0.025 MB / 4.89 MB Application: afterDispatch

Time: 95.72 ms / 401.96 ms Memory: 0.503 MB / 5.39 MB Application: beforeRenderModule mod_search (Search)

Time: 2.97 ms / 404.93 ms Memory: 0.027 MB / 5.42 MB Application: afterRenderModule mod_search (Search)

Time: 0.16 ms / 405.09 ms Memory: 0.000 MB / 5.41 MB Application: beforeRenderModule mod_menu (Off Canvas Menu)

Time: 6.03 ms / 411.12 ms Memory: 0.042 MB / 5.45 MB Application: afterRenderModule mod_menu (Off Canvas Menu)

Time: 0.40 ms / 411.52 ms Memory: 0.000 MB / 5.44 MB Application: beforeRenderModule mod_jatwitter (Follow Us on Twitter)

Time: 2.86 ms / 414.38 ms Memory: 0.059 MB / 5.50 MB Application: afterRenderModule mod_jatwitter (Follow Us on Twitter)

Time: 0.33 ms / 414.71 ms Memory: 0.000 MB / 5.49 MB Application: beforeRenderModule mod_menu (Quick Links)

Time: 4.71 ms / 419.41 ms Memory: 0.045 MB / 5.53 MB Application: afterRenderModule mod_menu (Quick Links)

Time: 0.12 ms / 419.53 ms Memory: 0.000 MB / 5.53 MB Application: beforeRenderModule mod_jivosite (Live Chat)

Time: 0.55 ms / 420.08 ms Memory: 0.010 MB / 5.54 MB Application: afterRenderModule mod_jivosite (Live Chat)

Time: 0.25 ms / 420.33 ms Memory: 0.000 MB / 5.53 MB Application: beforeRenderModule mod_custom (About Us)

Time: 1.68 ms / 422.01 ms Memory: 0.012 MB / 5.54 MB Application: afterRenderModule mod_custom (About Us)

Time: 0.26 ms / 422.27 ms Memory: 0.000 MB / 5.54 MB Application: beforeRenderModule mod_custom (Contact Us)

Time: 0.78 ms / 423.05 ms Memory: 0.007 MB / 5.55 MB Application: afterRenderModule mod_custom (Contact Us)

Time: 132.69 ms / 555.74 ms Memory: 0.128 MB / 5.67 MB Application: afterRender

Database queries total: 71.49 ms

Memory Usage

Database Queries

47 Queries Logged 71.49 ms

17 duplicate found!

11 duplicates: #21 #22 #32 #33 #34 #35 #36 #38 #39 #40 #45

6 duplicates: #26 #27 #28 #29 #30 #31

Query Time: 1.45 ms Query memory: 0.008 MB Memory before query: 0.920 MB

DELETE 

  FROM `chdg4_session`

  WHERE `time` < '1728250907'

Explain

EXPLAIN not possible on query: DELETE FROM `chdg4_session` WHERE `time` < '1728250907'

Profile

Status	Duration
Starting	0.11 ms
Checking permissions	0.16 ms
Opening tables	0.09 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.03 ms
Init for update	0.28 ms
Updating	0.19 ms
End of update loop	0.06 ms
Query end	0.03 ms
Commit	0.06 ms
Closing tables	0.05 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.05 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:818
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 1.19 ms After last query: 1.07 ms Query memory: 0.020 MB Memory before query: 0.942 MB Rows returned: 0

SELECT `data`

  FROM `chdg4_session`

  WHERE `session_id` = 'seoghta9g4m95vo2b62fv06ht6'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_session	const	PRIMARY	PRIMARY	766	const	1

Profile

Status	Duration
Starting	0.09 ms
Checking permissions	0.04 ms
Opening tables	0.06 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.04 ms
Init	0.07 ms
Optimizing	0.04 ms
Statistics	0.17 ms
Preparing	0.04 ms
Executing	0.07 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.04 ms
Closing tables	0.05 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.07 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
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:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:825
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 1.06 ms After last query: 2.01 ms Query memory: 0.012 MB Memory before query: 0.996 MB Rows returned: 0

SELECT `session_id`

  FROM `chdg4_session`

  WHERE `session_id` = 'seoghta9g4m95vo2b62fv06ht6' 
  LIMIT 1

Explain

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

Profile

Status	Duration
Starting	0.09 ms
Checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.05 ms
System lock	0.05 ms
Table lock	0.03 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.10 ms
Preparing	0.04 ms
Executing	0.05 ms
End of update loop	0.04 ms
Query end	0.05 ms
Commit	0.04 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.06 ms
Starting cleanup	0.05 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::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.47 ms Query memory: 0.009 MB Memory before query: 1.010 MB

INSERT INTO `chdg4_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('seoghta9g4m95vo2b62fv06ht6', 1, '1728251807', 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `chdg4_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('seoghta9g4m95vo2b62fv06ht6', 1, '1728251807', 0, '', 0)

Profile

Status	Duration
Starting	0.10 ms
Checking permissions	0.05 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.05 ms
Table lock	0.05 ms
Init for update	0.05 ms
Update	0.28 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.64 ms
Closing tables	0.05 ms
Unlocking tables	0.03 ms
Closing tables	0.06 ms
Starting cleanup	0.04 ms
Freeing items	0.03 ms
Updating status	0.08 ms
Reset for next command	0.09 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 2.43 ms After last query: 3.72 ms Query memory: 0.025 MB Memory before query: 1.065 MB Rows returned: 37

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

  FROM `chdg4_extensions`

  WHERE `type` = 'component'

Explain

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

Profile

Status	Duration
Starting	0.13 ms
Checking permissions	0.05 ms
Opening tables	0.07 ms
After opening tables	0.05 ms
System lock	0.05 ms
Table lock	0.05 ms
Init	0.08 ms
Optimizing	0.06 ms
Statistics	0.24 ms
Preparing	0.10 ms
Executing	0.05 ms
Sending data	0.83 ms
End of update loop	0.05 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:452
9	JComponentHelper::{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:460
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.46 ms After last query: 4.27 ms Query memory: 0.015 MB Memory before query: 1.168 MB Rows returned: 0

SELECT b.id

  FROM chdg4_usergroups AS a

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

  WHERE a.id = 13

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.15 ms
Checking permissions	0.05 ms
Opening tables	0.07 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.06 ms
Optimizing	0.05 ms
Statistics	0.30 ms
Preparing	0.05 ms
Executing	0.11 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1047
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.83 ms Query memory: 0.014 MB Memory before query: 1.188 MB Rows returned: 5

SELECT id, rules

  FROM `chdg4_viewlevels`

Explain

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

Profile

Status	Duration
Starting	0.07 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.03 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.17 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1064
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 3.49 ms After last query: 0.71 ms Query memory: 0.017 MB Memory before query: 1.227 MB Rows returned: 76

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

  FROM chdg4_extensions

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

  ORDER BY ordering

Explain

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

Profile

Status	Duration
Starting	0.11 ms
Checking permissions	0.03 ms
Opening tables	0.19 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.03 ms
Init	0.07 ms
Optimizing	0.06 ms
Statistics	0.11 ms
Preparing	0.08 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.04 ms
Creating sort index	1.97 ms
End of update loop	0.05 ms
Query end	0.05 ms
Commit	0.05 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.05 ms
Starting cleanup	0.04 ms
Freeing items	0.05 ms
Updating status	0.06 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:311
9	JPluginHelper::{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:316
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.43 ms After last query: 14.65 ms Query memory: 0.013 MB Memory before query: 1.681 MB Rows returned: 1

SELECT `enabled`

  FROM `chdg4_extensions`

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

Explain

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

Profile

Status	Duration
Starting	0.10 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.03 ms
Init	0.05 ms
Optimizing	0.05 ms
Statistics	0.26 ms
Preparing	0.07 ms
Executing	0.03 ms
Sending data	0.15 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.04 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:80
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:682
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.87 ms After last query: 13.53 ms Query memory: 0.031 MB Memory before query: 2.035 MB Rows returned: 22

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

  LEFT JOIN chdg4_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	72	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	sptlkeny_sptlkenya.m.component_id	1	Using where

Profile

Status	Duration
Starting	0.20 ms
Checking permissions	0.04 ms
Opening tables	0.07 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.08 ms
Optimizing	0.06 ms
Statistics	0.23 ms
Preparing	0.12 ms
Sorting result	0.05 ms
Executing	0.03 ms
Sending data	0.05 ms
Creating sort index	1.39 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
17	JMenuSite->{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
15	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:443
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:548
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1141
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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: 16.44 ms Query memory: 0.025 MB Memory before query: 2.404 MB Rows returned: 1

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

  FROM `chdg4_extensions`

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

Explain

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

Profile

Status	Duration
Starting	0.10 ms
Checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.09 ms
Table lock	0.04 ms
Init	0.06 ms
Optimizing	0.05 ms
Statistics	0.18 ms
Preparing	0.14 ms
Executing	0.03 ms
Sending data	0.12 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.04 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
19	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
18	JLibraryHelper::{closure}()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
16	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
15	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
14	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
13	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:40
9	plgSystemK2->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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: 0.76 ms Query memory: 0.017 MB Memory before query: 2.411 MB

UPDATE `chdg4_extensions`

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

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

Explain

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

Profile

Status	Duration
Starting	0.09 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.03 ms
Init for update	0.17 ms
Updating	0.23 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.55 ms
Closing tables	0.04 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.05 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
14	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
13	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:40
9	plgSystemK2->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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: 2.47 ms Query memory: 0.022 MB Memory before query: 2.534 MB Rows returned: 1

SELECT *

  FROM chdg4_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
Starting	0.08 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.03 ms
Init	0.07 ms
Optimizing	0.05 ms
Statistics	0.05 ms
Preparing	0.06 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.05 ms
Creating sort index	0.21 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
13	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:327
12	JApplicationSite->getParams()	JROOT/components/com_k2/helpers/utilities.php:305
11	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:56
10	K2HelperHTML::loadjQuery()	JROOT/plugins/system/k2/k2.php:45
9	plgSystemK2->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.56 ms After last query: 2.76 ms Query memory: 0.039 MB Memory before query: 2.608 MB Rows returned: 5

SELECT id, home, template, s.params

  FROM chdg4_template_styles as s

  LEFT JOIN chdg4_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	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.11 ms
Checking permissions	0.03 ms
Opening tables	0.06 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.03 ms
Init	0.07 ms
Optimizing	0.06 ms
Statistics	0.13 ms
Preparing	0.11 ms
Executing	0.03 ms
Sending data	0.42 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
20	JApplicationSite->getTemplate()	JROOT/libraries/cms/html/html.php:359
19	JHtml::includeRelativeFiles()	JROOT/libraries/cms/html/html.php:706
18	JHtml::script()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/cms/html/html.php:233
16	JHtml::call()	JROOT/libraries/cms/html/html.php:140
15	JHtml::_()	JROOT/libraries/cms/html/jquery.php:52
14	JHtmlJquery::framework()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/cms/html/html.php:233
12	JHtml::call()	JROOT/libraries/cms/html/html.php:140
11	JHtml::_()	JROOT/administrator/components/com_k2/helpers/html.php:79
10	K2HelperHTML::loadjQuery()	JROOT/plugins/system/k2/k2.php:45
9	plgSystemK2->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.43 ms After last query: 13.12 ms Query memory: 0.029 MB Memory before query: 2.924 MB Rows returned: 37

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

  FROM `chdg4_assets`

  WHERE `name` IN ('com_admin','com_advportfoliopro','com_ajax','com_akeeba','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_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_sppagebuilder','com_tags','com_templates','com_uniterevolution2','com_users','com_wrapper') OR `parent_id` = 0

Explain

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

Profile

Status	Duration
Starting	0.16 ms
Checking permissions	0.04 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.11 ms
Optimizing	0.06 ms
Statistics	0.42 ms
Preparing	0.07 ms
Executing	0.03 ms
Sending data	0.90 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
19	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
18	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
17	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
15	JUser->authorise()	JROOT/components/com_sppagebuilder/models/page.php:29
14	SppagebuilderModelPage->populateState()	JROOT/libraries/legacy/model/legacy.php:434
13	JModelLegacy->getState()	JROOT/components/com_sppagebuilder/models/page.php:41
12	SppagebuilderModelPage->getItem()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:24
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.34 ms After last query: 2.65 ms Query memory: 0.025 MB Memory before query: 3.029 MB Rows returned: 1

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

  FROM chdg4_sppagebuilder as a

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

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

  WHERE a.id = 1 
  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.12 ms
Checking permissions	0.04 ms
Opening tables	0.68 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.09 ms
Optimizing	0.06 ms
Statistics	0.39 ms
Preparing	0.05 ms
Unlocking tables	0.04 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.26 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/models/page.php:82
12	SppagebuilderModelPage->getItem()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:24
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.62 ms After last query: 1.20 ms Query memory: 0.027 MB Memory before query: 3.089 MB Rows returned: 23

SHOW FULL COLUMNS 
  FROM `chdg4_sppagebuilder`

Explain

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

Profile

Status	Duration
Starting	0.08 ms
Checking permissions	0.03 ms
Closing tables	0.03 ms
Opening tables	0.62 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.05 ms
Executing	0.03 ms
Filling schema table	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
Checking permissions	0.43 ms
Closing tables	0.05 ms
Executing	0.03 ms
Sending data	0.14 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.04 ms
Removing tmp table	0.26 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
14	JTable->__construct()	JROOT/administrator/components/com_sppagebuilder/tables/page.php:17
13	SppagebuilderTablePage->__construct()	JROOT/libraries/joomla/table/table.php:311
12	JTable::getInstance()	JROOT/components/com_sppagebuilder/models/page.php:126
11	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/views/page/view.html.php:39
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.34 ms After last query: 2.25 ms Query memory: 0.025 MB Memory before query: 3.176 MB Rows returned: 1

SELECT *

  FROM chdg4_sppagebuilder

  WHERE `id` = '1'

Explain

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

Profile

Status	Duration
Starting	0.07 ms
Checking permissions	0.05 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.07 ms
Optimizing	0.05 ms
Statistics	0.11 ms
Preparing	0.03 ms
Unlocking tables	0.04 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.24 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
12	JTable->load()	JROOT/components/com_sppagebuilder/models/page.php:127
11	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/views/page/view.html.php:39
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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: 0.66 ms Query memory: 0.016 MB Memory before query: 3.207 MB

UPDATE chdg4_sppagebuilder

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

  WHERE `id` = '1'

Explain

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

Profile

Status	Duration
Starting	0.08 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.03 ms
Init for update	0.19 ms
Updating	0.21 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.57 ms
Closing tables	0.04 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1240
12	JTable->hit()	JROOT/components/com_sppagebuilder/models/page.php:128
11	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/views/page/view.html.php:39
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.34 ms After last query: 8.66 ms Query memory: 0.019 MB Memory before query: 3.446 MB Rows returned: 1

SELECT `template`

  FROM `chdg4_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	chdg4_template_styles	ref	idx_home	idx_home	28	const	2	Using index condition; Using where

Profile

Status	Duration
Starting	0.11 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.03 ms
Init	0.06 ms
Optimizing	0.05 ms
Statistics	0.21 ms
Preparing	0.07 ms
Executing	0.03 ms
Sending data	0.17 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.04 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
13	JDatabaseDriver->loadResult()	JROOT/components/com_sppagebuilder/helpers/helper.php:32
12	SppagebuilderHelperSite::getTemplate()	JROOT/components/com_sppagebuilder/helpers/helper.php:19
11	SppagebuilderHelperSite::loadLanguage()	JROOT/components/com_sppagebuilder/views/page/view.html.php:42
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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: 7.21 ms Query memory: 0.024 MB Memory before query: 3.526 MB Rows returned: 1

Duplicate queries: #22 #32 #33 #34 #35 #36 #38 #39 #40 #45

SELECT `template`

  FROM `chdg4_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	chdg4_template_styles	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
17	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:407
16	AddonParser::getTemplateName()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:146
15	AddonParser::getAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:425
14	require_once JROOT/components/com_sppagebuilder/parser/addon-parser.php	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:14
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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: 11.54 ms Query memory: 0.024 MB Memory before query: 3.776 MB Rows returned: 1

Duplicate queries: #21 #32 #33 #34 #35 #36 #38 #39 #40 #45

SELECT `template`

  FROM `chdg4_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	chdg4_template_styles	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using where

Profile

Status	Duration
Starting	0.08 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.03 ms
Init	0.05 ms
Optimizing	0.05 ms
Statistics	0.06 ms
Preparing	0.06 ms
Executing	0.03 ms
Sending data	0.12 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
17	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:407
16	AddonParser::getTemplateName()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:47
15	AddonParser::getAddonPath()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:254
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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: 2.78 ms Query memory: 0.026 MB Memory before query: 3.809 MB Rows returned: 1

SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params

  FROM chdg4_modules AS m

  WHERE m.published = 1 
  AND m.id = 126 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-10-06 21:56:47') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-06 21:56:47') 
  AND m.access IN (1,1) 
  AND m.client_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	const	PRIMARY,published	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.14 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.03 ms
Init	0.08 ms
Optimizing	0.07 ms
Statistics	0.23 ms
Preparing	0.06 ms
Unlocking tables	0.04 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.05 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_sppagebuilder/addons/module/site.php:99
16	SppagebuilderAddonModule::getModules()	JROOT/components/com_sppagebuilder/addons/module/site.php:28
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:265
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.01 ms After last query: 9.61 ms Query memory: 0.033 MB Memory before query: 4.293 MB Rows returned: 1

select * 
  from chdg4_revslider_sliders 
  where id=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_revslider_sliders	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.07 ms
Checking permissions	0.03 ms
Opening tables	0.91 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.09 ms
Preparing	0.06 ms
Unlocking tables	0.03 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.05 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.06 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
23	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
22	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:223
21	UniteDBRev->fetchSingle()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:76
20	RevSlider->initByID()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:119
19	RevSlider->initByMixed()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:1909
18	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
17	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/libraries/cms/module/helper.php:198
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:265
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.60 ms After last query: 1.24 ms Query memory: 0.035 MB Memory before query: 4.351 MB Rows returned: 3

select * 
  from chdg4_revslider_slides 
  where slider_id=1 
  order by slide_order

Explain

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

Profile

Status	Duration
Starting	0.08 ms
Checking permissions	0.03 ms
Opening tables	0.48 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	0.04 ms
Preparing	0.05 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.04 ms
Creating sort index	0.21 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.06 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
24	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
23	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:1502
22	RevSlider->getSlidesFromGallery()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:1395
21	RevSlider->getSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:1581
20	RevSlider->getSlidesForOutput()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:260
19	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162
18	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
17	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/libraries/cms/module/helper.php:198
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:265
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.31 ms After last query: 3.17 ms Query memory: 0.033 MB Memory before query: 4.576 MB Rows returned: 0

Duplicate queries: #27 #28 #29 #30 #31

select * 
  from chdg4_revslider_layer_animations

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_revslider_layer_animations	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found

Profile

Status	Duration
Starting	0.07 ms
Checking permissions	0.03 ms
Opening tables	0.45 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.05 ms
Optimizing	0.05 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.04 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
23	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
22	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533
21	RevOperations::getCustomAnimations()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:686
20	RevSliderOutput->putCreativeLayer()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:654
19	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162
18	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
17	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/libraries/cms/module/helper.php:198
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:265
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.50 ms Query memory: 0.033 MB Memory before query: 4.607 MB Rows returned: 0

Duplicate queries: #26 #28 #29 #30 #31

select * 
  from chdg4_revslider_layer_animations

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_revslider_layer_animations	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found

Profile

Status	Duration
Starting	0.06 ms
Checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.04 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
23	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
22	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533
21	RevOperations::getCustomAnimations()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:687
20	RevSliderOutput->putCreativeLayer()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:654
19	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162
18	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
17	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/libraries/cms/module/helper.php:198
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:265
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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: 1.20 ms Query memory: 0.033 MB Memory before query: 4.640 MB Rows returned: 0

Duplicate queries: #26 #27 #29 #30 #31

select * 
  from chdg4_revslider_layer_animations

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_revslider_layer_animations	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found

Profile

Status	Duration
Starting	0.06 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.03 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.03 ms
Executing	0.04 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
23	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
22	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533
21	RevOperations::getCustomAnimations()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:686
20	RevSliderOutput->putCreativeLayer()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:654
19	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162
18	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
17	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/libraries/cms/module/helper.php:198
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:265
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.94 ms After last query: 0.42 ms Query memory: 0.033 MB Memory before query: 4.671 MB Rows returned: 0

Duplicate queries: #26 #27 #28 #30 #31

select * 
  from chdg4_revslider_layer_animations

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_revslider_layer_animations	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found

Profile

Status	Duration
Starting	0.06 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.03 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.03 ms
Executing	0.04 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.05 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
23	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
22	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533
21	RevOperations::getCustomAnimations()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:687
20	RevSliderOutput->putCreativeLayer()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:654
19	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162
18	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
17	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/libraries/cms/module/helper.php:198
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:265
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.89 ms After last query: 1.10 ms Query memory: 0.033 MB Memory before query: 4.703 MB Rows returned: 0

Duplicate queries: #26 #27 #28 #29 #31

select * 
  from chdg4_revslider_layer_animations

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_revslider_layer_animations	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found

Profile

Status	Duration
Starting	0.06 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.03 ms
Init	0.04 ms
Optimizing	0.04 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.04 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
23	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
22	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533
21	RevOperations::getCustomAnimations()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:686
20	RevSliderOutput->putCreativeLayer()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:654
19	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162
18	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
17	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/libraries/cms/module/helper.php:198
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:265
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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: 0.46 ms Query memory: 0.033 MB Memory before query: 4.734 MB Rows returned: 0

Duplicate queries: #26 #27 #28 #29 #30

select * 
  from chdg4_revslider_layer_animations

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_revslider_layer_animations	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found

Profile

Status	Duration
Starting	0.06 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.03 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.04 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.04 ms
Closing tables	0.03 ms
Starting cleanup	0.04 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
23	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
22	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533
21	RevOperations::getCustomAnimations()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:687
20	RevSliderOutput->putCreativeLayer()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:654
19	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162
18	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
17	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/libraries/cms/module/helper.php:198
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:265
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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: 6.51 ms Query memory: 0.024 MB Memory before query: 4.543 MB Rows returned: 1

Duplicate queries: #21 #22 #33 #34 #35 #36 #38 #39 #40 #45

SELECT `template`

  FROM `chdg4_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	chdg4_template_styles	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using where

Profile

Status	Duration
Starting	0.08 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.03 ms
Init	0.05 ms
Optimizing	0.05 ms
Statistics	0.06 ms
Preparing	0.11 ms
Executing	0.04 ms
Sending data	0.12 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.04 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
17	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:407
16	AddonParser::getTemplateName()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:47
15	AddonParser::getAddonPath()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:254
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.11 ms After last query: 5.46 ms Query memory: 0.024 MB Memory before query: 4.568 MB Rows returned: 1

Duplicate queries: #21 #22 #32 #34 #35 #36 #38 #39 #40 #45

SELECT `template`

  FROM `chdg4_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	chdg4_template_styles	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using where

Profile

Status	Duration
Starting	0.09 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.03 ms
Init	0.06 ms
Optimizing	0.06 ms
Statistics	0.06 ms
Preparing	0.06 ms
Executing	0.03 ms
Sending data	0.11 ms
End of update loop	0.04 ms
Query end	0.04 ms
Commit	0.03 ms
Closing tables	0.04 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
17	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:407
16	AddonParser::getTemplateName()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:47
15	AddonParser::getAddonPath()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:254
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.03 ms After last query: 4.67 ms Query memory: 0.024 MB Memory before query: 4.592 MB Rows returned: 1

Duplicate queries: #21 #22 #32 #33 #35 #36 #38 #39 #40 #45

SELECT `template`

  FROM `chdg4_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	chdg4_template_styles	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using where

Profile

Status	Duration
Starting	0.08 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.03 ms
Init	0.05 ms
Optimizing	0.05 ms
Statistics	0.05 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.11 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.05 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
17	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:407
16	AddonParser::getTemplateName()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:47
15	AddonParser::getAddonPath()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:254
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.02 ms After last query: 6.15 ms Query memory: 0.024 MB Memory before query: 4.617 MB Rows returned: 1

Duplicate queries: #21 #22 #32 #33 #34 #36 #38 #39 #40 #45

SELECT `template`

  FROM `chdg4_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	chdg4_template_styles	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using where

Profile

Status	Duration
Starting	0.07 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.03 ms
Init	0.05 ms
Optimizing	0.05 ms
Statistics	0.07 ms
Preparing	0.06 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
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
17	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:407
16	AddonParser::getTemplateName()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:47
15	AddonParser::getAddonPath()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:254
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.04 ms After last query: 4.55 ms Query memory: 0.024 MB Memory before query: 4.641 MB Rows returned: 1

Duplicate queries: #21 #22 #32 #33 #34 #35 #38 #39 #40 #45

SELECT `template`

  FROM `chdg4_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	chdg4_template_styles	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using where

Profile

Status	Duration
Starting	0.07 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.03 ms
Init	0.05 ms
Optimizing	0.05 ms
Statistics	0.05 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.09 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.05 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
17	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:407
16	AddonParser::getTemplateName()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:47
15	AddonParser::getAddonPath()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:254
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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: 2.26 ms Query memory: 0.026 MB Memory before query: 4.666 MB Rows returned: 1

SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params

  FROM chdg4_modules AS m

  WHERE m.published = 1 
  AND m.id = 150 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-10-06 21:56:47') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-06 21:56:47') 
  AND m.access IN (1,1) 
  AND m.client_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	const	PRIMARY,published	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.13 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.03 ms
Init	0.07 ms
Optimizing	0.07 ms
Statistics	0.22 ms
Preparing	0.04 ms
Unlocking tables	0.04 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.05 ms
End of update loop	0.05 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_sppagebuilder/addons/module/site.php:99
16	SppagebuilderAddonModule::getModules()	JROOT/components/com_sppagebuilder/addons/module/site.php:28
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:265
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.13 ms After last query: 7.72 ms Query memory: 0.024 MB Memory before query: 4.707 MB Rows returned: 1

Duplicate queries: #21 #22 #32 #33 #34 #35 #36 #39 #40 #45

SELECT `template`

  FROM `chdg4_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	chdg4_template_styles	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using where

Profile

Status	Duration
Starting	0.08 ms
Checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.07 ms
Optimizing	0.05 ms
Statistics	0.12 ms
Preparing	0.07 ms
Executing	0.03 ms
Sending data	0.10 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.04 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
17	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:407
16	AddonParser::getTemplateName()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:47
15	AddonParser::getAddonPath()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:254
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.98 ms After last query: 4.81 ms Query memory: 0.024 MB Memory before query: 4.731 MB Rows returned: 1

Duplicate queries: #21 #22 #32 #33 #34 #35 #36 #38 #40 #45

SELECT `template`

  FROM `chdg4_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	chdg4_template_styles	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using where

Profile

Status	Duration
Starting	0.07 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.03 ms
Init	0.05 ms
Optimizing	0.05 ms
Statistics	0.06 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.11 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
17	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:407
16	AddonParser::getTemplateName()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:47
15	AddonParser::getAddonPath()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:254
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.98 ms After last query: 4.59 ms Query memory: 0.024 MB Memory before query: 4.756 MB Rows returned: 1

Duplicate queries: #21 #22 #32 #33 #34 #35 #36 #38 #39 #45

SELECT `template`

  FROM `chdg4_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	chdg4_template_styles	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using where

Profile

Status	Duration
Starting	0.08 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.03 ms
Init	0.05 ms
Optimizing	0.05 ms
Statistics	0.06 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.09 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
17	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:407
16	AddonParser::getTemplateName()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:47
15	AddonParser::getAddonPath()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:254
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.35 ms After last query: 2.27 ms Query memory: 0.026 MB Memory before query: 4.780 MB Rows returned: 1

SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params

  FROM chdg4_modules AS m

  WHERE m.published = 1 
  AND m.id = 145 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-10-06 21:56:47') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-06 21:56:47') 
  AND m.access IN (1,1) 
  AND m.client_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	const	PRIMARY,published	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.15 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.03 ms
Init	0.08 ms
Optimizing	0.07 ms
Statistics	0.12 ms
Preparing	0.04 ms
Unlocking tables	0.05 ms
Preparing	0.08 ms
Executing	0.06 ms
Sending data	0.07 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_sppagebuilder/addons/module/site.php:99
16	SppagebuilderAddonModule::getModules()	JROOT/components/com_sppagebuilder/addons/module/site.php:28
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:265
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.41 ms Query memory: 0.034 MB Memory before query: 4.863 MB Rows returned: 0

SELECT *

  FROM chdg4_banners

  WHERE '2024-10-06 21:56:47' >= 'reset' 
  AND `reset` != '0000-00-00 00:00:00' 
  AND `reset`!= NULL 
  AND (`checked_out` = 0 OR `checked_out` = 0)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE

Profile

Status	Duration
Starting	0.11 ms
Checking permissions	0.04 ms
Opening tables	0.84 ms
After opening tables	0.05 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.09 ms
Optimizing	0.06 ms
Executing	0.07 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
18	BannersHelper::updateReset()	JROOT/modules/mod_carousel_banner/mod_carousel_banner.php:184
17	include JROOT/modules/mod_carousel_banner/mod_carousel_banner.php	JROOT/libraries/cms/module/helper.php:198
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:265
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.27 ms After last query: 1.86 ms Query memory: 0.032 MB Memory before query: 4.938 MB Rows returned: 4

SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions

  FROM chdg4_banners as a

  LEFT JOIN chdg4_banner_clients AS cl 
  ON cl.id = a.cid

  WHERE a.state=1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-06 21:56:47') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-06 21:56:47') 
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
  AND a.catid IN (15)

  ORDER BY a.sticky DESC,a.ordering 
  LIMIT 5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	idx_state,idx_banner_catid	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using where; Using filesort
1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	sptlkeny_sptlkenya.a.cid	1

Profile

Status	Duration
Starting	0.18 ms
Checking permissions	0.04 ms
Opening tables	0.52 ms
After opening tables	0.06 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.09 ms
Optimizing	0.07 ms
Statistics	0.23 ms
Preparing	0.10 ms
Sorting result	0.08 ms
Executing	0.03 ms
Sending data	0.04 ms
Creating sort index	0.31 ms
End of update loop	0.06 ms
Query end	0.05 ms
Commit	0.04 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
21	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
20	JModelList->getItems()	JROOT/components/com_banners/models/banners.php:205
19	BannersModelBanners->getItems()	JROOT/modules/mod_carousel_banner/helper.php:48
18	modCarouselBannerHelper::getList()	JROOT/modules/mod_carousel_banner/mod_carousel_banner.php:185
17	include JROOT/modules/mod_carousel_banner/mod_carousel_banner.php	JROOT/libraries/cms/module/helper.php:198
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:265
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.79 ms After last query: 0.74 ms Query memory: 0.025 MB Memory before query: 4.985 MB

UPDATE chdg4_banners

  SET impmade = (impmade + 1)

  WHERE id IN (2,5,6,7)

Explain

EXPLAIN not possible on query: UPDATE chdg4_banners SET impmade = (impmade + 1) WHERE id IN (2,5,6,7)

Profile

Status	Duration
Starting	0.09 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.03 ms
Init for update	0.15 ms
Updating	0.30 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.62 ms
Closing tables	0.05 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:249
19	BannersModelBanners->impress()	JROOT/modules/mod_carousel_banner/helper.php:51
18	modCarouselBannerHelper::getList()	JROOT/modules/mod_carousel_banner/mod_carousel_banner.php:185
17	include JROOT/modules/mod_carousel_banner/mod_carousel_banner.php	JROOT/libraries/cms/module/helper.php:198
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:265
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.11 ms After last query: 7.16 ms Query memory: 0.024 MB Memory before query: 4.971 MB Rows returned: 1

Duplicate queries: #21 #22 #32 #33 #34 #35 #36 #38 #39 #40

SELECT `template`

  FROM `chdg4_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	chdg4_template_styles	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using where

Profile

Status	Duration
Starting	0.08 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.03 ms
Init	0.05 ms
Optimizing	0.07 ms
Statistics	0.06 ms
Preparing	0.06 ms
Executing	0.03 ms
Sending data	0.11 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.04 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
17	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:407
16	AddonParser::getTemplateName()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:47
15	AddonParser::getAddonPath()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:254
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.32 ms After last query: 2.22 ms Query memory: 0.026 MB Memory before query: 4.996 MB Rows returned: 1

SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params

  FROM chdg4_modules AS m

  WHERE m.published = 1 
  AND m.id = 144 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-10-06 21:56:47') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-06 21:56:47') 
  AND m.access IN (1,1) 
  AND m.client_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	const	PRIMARY,published	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.15 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.03 ms
Init	0.08 ms
Optimizing	0.07 ms
Statistics	0.12 ms
Preparing	0.04 ms
Unlocking tables	0.04 ms
Preparing	0.05 ms
Executing	0.05 ms
Sending data	0.05 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.05 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_sppagebuilder/addons/module/site.php:99
16	SppagebuilderAddonModule::getModules()	JROOT/components/com_sppagebuilder/addons/module/site.php:28
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:265
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:76
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:43
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:35
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 3.52 ms After last query: 71.57 ms Query memory: 0.026 MB Memory before query: 5.319 MB Rows returned: 20

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

  FROM chdg4_modules AS m

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

  LEFT JOIN chdg4_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 <= '2024-10-06 21:56:47') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-06 21:56:47') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 437 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	35	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	sptlkeny_sptlkenya.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	sptlkeny_sptlkenya.m.module,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.29 ms
Checking permissions	0.04 ms
Opening tables	0.08 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.11 ms
Optimizing	0.10 ms
Statistics	0.28 ms
Preparing	0.17 ms
Sorting result	0.06 ms
Executing	0.03 ms
Sending data	0.05 ms
Creating sort index	1.59 ms
End of update loop	0.04 ms
Query end	0.04 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.06 ms
Starting cleanup	0.03 ms
Freeing items	0.05 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
15	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
14	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
13	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
12	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
11	JDocumentHtml->countModules()	JROOT/plugins/system/helix3/core/helix3.php:508
10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:455
9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:264
8	Helix3::generatelayout()	JROOT/templates/sptlk/index.php:156
7	require JROOT/templates/sptlk/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

12 × SELECT `template` 
  FROM `chdg4_template_styles`

6 × select * 
  from chdg4_revslider_layer_animation

4 × SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params 
  FROM chdg4_modules AS m

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

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

1 × SELECT * 
  FROM chdg4_sppagebuilder

1 × select * 
  from chdg4_revslider_sliders

1 × select * 
  from chdg4_revslider_slides

1 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions 
  FROM chdg4_banners as a 
  LEFT JOIN chdg4_banner_clients AS cl 
  ON cl.id = a.cid

```
1 × SELECT * 
  FROM chdg4_banners
```

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

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

1 × SELECT id, rules 
  FROM `chdg4_viewlevels

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

1 × SELECT `session_id` 
  FROM `chdg4_session`

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
  FROM chdg4_extensions

1 × SELECT `enabled` 
  FROM `chdg4_extensions`

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

```
1 × SELECT * 
  FROM chdg4_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 chdg4_menu AS m 
  LEFT JOIN chdg4_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `data` 
  FROM `chdg4_session`

OTHER Tables:

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

1 × UPDATE chdg4_banners 
  SET impmade = (impmade + 1)

1 × SHOW FULL COLUMNS 
  FROM `chdg4_sppagebuilder

1 × UPDATE `chdg4_extensions` 
  SET `params` = '{\"mediaversion\":\"c945f44aae08765fa3ac8015fc9b603a\"}'

1 × INSERT INTO `chdg4_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('seoghta9g4m95vo2b62fv06ht6', 1, '1728251807', 0, '', 0

```
1 × DELETE  
  FROM `chdg4_session`
```

OUR SERVICES

ICT Services

Energy Management

Building & Construction

WELCOME TO STEMINAK PREMIER TECHNOLOGIES LTD

Why Choose Us

Read More

FUTURE OF ICT

OUR CLIENTS

Contact Us

Steminak Premier Technologies Ltd

P.O. Box 10778 - 00200 Nairobi

MOB 1: +254 708 414 963

MOB 2: +254 775 034 120

Email: info@sptlkenya.co.ke

About Us

Quick Links

Follow Us on Twitter

Search

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

47 Queries Logged 71.49 ms

17 duplicate found!

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: