Our Team

+256774784232
bsu@gu.ac.ug
Mon - Fri 8:30 - 5:00PM

Our Story since inception in 2011

Building Stronger Universities (BSU)-Gulu is a multifaceted programme aimed at strengthening research capacity at Gulu University in northern Uganda.

It is part of a broader partnership - Building Stronger Universities in Developing Countries (BSU) - between research and higher education institutions in developing countries and Danish universities.

The overall purpose of the collaborative programme is to support Gulu University in its efforts to strengthen research capacity at PhD level and research-based education, with a special emphasis on research ‘for community transformation’.

Partners at Gulu University are drawn from the Institute of Peace and Strategic Studies (IPSS), the Faculty of Business and Development Studies, and the Faculty of Education and Humanities.

The Danish partners include researchers from seven departments at five Danish Universities: Anthropology (University of Copenhagen); Culture and Society (Aarhus University); Law (University of Southern Denmark); Society and Globalisation (Roskilde University); and Culture and Global Studies, Communication and Psychology, Education, Learning and Philosophy (Aalborg University).

Since its inception in 2011, BSU has supported 26 PhDs, several collaborative research projects, and strengthened services and facilities that support research, teaching and learning at Gulu University. Now in its third phase, BSU is focusing on two themes: Transforming education; Rights, resources and gender in post-war development.

Ourprouddedicatedpartners

Management Team

Prof. George O. LadaahPrincipal Investigator

Principal Investigator of the BSU project. He holds a Ph.D in Adult Education, University of KwaZulu-Natal, MSoE (Adult Education), University of Natal and a MSoE (Curriculum Studies in History Education), Makerere University.

Judith Awacorach Deputy Coordinator (Admin)

Deputy coordinator (Administration) of BSU. She is a lecturer in the Department of Accounting and Finance, Faculty of Business and Development Studies. She holds a MSc. BA (Finance) from Punjab Technical University, India, BSc. BA (Finance),Barkatullah University, India, and a MSc. Commerce (applied economics and management),Barkatullah University, India.

Dr. Agatha Alidri Project Coordinator

A lecturer, Department of History, Faculty of Education and Humanities at Gulu University since 2010. She has been part of BSU for the last 10 years serving as the Deputy Project Coordinator BSU II (2013-2016). Her vision is to inspire young academics to build their capacity in research and teaching to transform society.

Ben Waiswa Project accountant

Finance Officer for the BSU Project . He is a CPA student at Level III, Institute of Certified Public Accountants of Uganda (ICPAU). Holds a Post Graduate Diploma in Financial Management (Uganda Management Institute), A BSc. Business Administration (Gulu University) and a Dip. Business Administration (Makerere University Business School)

Prof. Charles Okumu Chairperson

Chair of BSU since its inception in 2011. Charles is an Associate Professor of Literary and Cultural Studies, Department of Languages and Literature, Faculty of Education and Humanities.

Dr. Geofrey TaboDeputy Coordinator (Technical)

A lecturer, Department of Computer Science at Gulu University. He holds a PhD in user-driven innovation, learning and design from Aalborg University, Denmark and a MSc. Computer Science from Makerere University.

Steering Team

Prof. Charles Okumu

Chairperson

Dr. Agatha Alidri

Secretary

Dr. Isingoma Bebwa

Dean, Faculty of Education and Humanities

Dr. David Ross Olanya

Dean, Faculty of Business and Development Studies

Dr. Aloysius Tenywa Malagala

Director, Institute of Peace and Strategic Studies

Dr. Daniel Komaketch

Director Institute Research and Graduate Studies (IRGS)

Prof. Elizabeth A. Opiyo

Lecturer, Faculty of Science (Overlooks research for the project)

Mr. Asaf Adebua

Director, Directorate of Planning and Development

Dr. Geofrey Tabo

Deputy Coordinator (Technical)

Judith Awacorach

Deputy Coordinator (Admin)

Contact

Building Stronger Universities (BSU)-Gulu is a multifaceted programme aimed at strengthening research capacity at Gulu University in northern Uganda

News & Blog

About BSU

Gallery

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1737391032,
                "last": 1737391032,
                "now": 1737391032
            },
            "token": "tW9KGuYEOe3hfn8L5p1BSThNVftQAKAj"
        },
        "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: 19.88 ms / 19.88 ms Memory: 0.546 MB / 0.88 MB Application: afterLoad

Time: 139.67 ms / 159.56 ms Memory: 1.173 MB / 2.05 MB Application: afterInitialise

Time: 55.91 ms / 215.47 ms Memory: 0.376 MB / 2.43 MB Application: afterRoute

Time: 7.78 ms / 223.25 ms Memory: 0.132 MB / 2.56 MB Application: beforeRenderComponent com_sppagebuilder

Time: 9.30 ms / 232.55 ms Memory: 0.124 MB / 2.68 MB Application: Before Access::preloadComponents (all components)

Time: 6.69 ms / 239.24 ms Memory: 0.056 MB / 2.74 MB Application: After Access::preloadComponents (all components)

Time: 0.02 ms / 239.26 ms Memory: -0.002 MB / 2.74 MB Application: Before Access::getAssetRules (id:56 name:com_sppagebuilder)

Time: 0.46 ms / 239.72 ms Memory: 0.008 MB / 2.74 MB Application: After Access::getAssetRules (id:56 name:com_sppagebuilder)

Time: 167.55 ms / 407.27 ms Memory: 2.586 MB / 5.33 MB Application: Before Access::preloadPermissions (com_sppagebuilder)

Time: 3.14 ms / 410.42 ms Memory: 0.046 MB / 5.38 MB Application: After Access::preloadPermissions (com_sppagebuilder)

Time: 0.02 ms / 410.43 ms Memory: -0.002 MB / 5.37 MB Application: Before Access::getAssetRules (id:219 name:com_sppagebuilder.page.63)

Time: 0.01 ms / 410.44 ms Memory: 0.002 MB / 5.38 MB Application: After Access::getAssetRules (id:219 name:com_sppagebuilder.page.63)

Time: 0.25 ms / 410.70 ms Memory: -0.686 MB / 4.69 MB Application: afterRenderComponent com_sppagebuilder

Time: 1.87 ms / 412.57 ms Memory: 0.069 MB / 4.76 MB Application: afterDispatch

Time: 22.80 ms / 435.37 ms Memory: 0.244 MB / 5.00 MB Application: beforeRenderModule mod_menu (Offcanvas)

Time: 2.12 ms / 437.48 ms Memory: 0.109 MB / 5.11 MB Application: afterRenderModule mod_menu (Offcanvas)

Time: 0.07 ms / 437.55 ms Memory: -0.003 MB / 5.11 MB Application: beforeRenderModule mod_speasyimagegallery (Gallery)

Time: 2.09 ms / 439.64 ms Memory: 0.042 MB / 5.15 MB Application: afterRenderModule mod_speasyimagegallery (Gallery)

Time: 0.05 ms / 439.69 ms Memory: -0.020 MB / 5.13 MB Application: beforeRenderModule mod_menu (About BSU)

Time: 0.54 ms / 440.23 ms Memory: 0.022 MB / 5.15 MB Application: afterRenderModule mod_menu (About BSU)

Time: 0.06 ms / 440.29 ms Memory: -0.002 MB / 5.15 MB Application: beforeRenderModule mod_articles_latest (News & Blog)

Time: 2.52 ms / 442.81 ms Memory: 0.042 MB / 5.19 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Time: 0.04 ms / 442.85 ms Memory: 0.007 MB / 5.20 MB Application: After Access::getAssetRules (id:8 name:com_content)

Time: 26.20 ms / 469.05 ms Memory: 0.054 MB / 5.25 MB Application: afterRenderModule mod_articles_latest (News & Blog)

Time: 0.10 ms / 469.15 ms Memory: -0.029 MB / 5.22 MB Application: beforeRenderModule mod_custom (Contact)

Time: 0.50 ms / 469.65 ms Memory: 0.005 MB / 5.23 MB Application: afterRenderModule mod_custom (Contact)

Time: 0.11 ms / 469.76 ms Memory: 0.000 MB / 5.23 MB Application: beforeRenderModule mod_search (Search)

Time: 0.94 ms / 470.71 ms Memory: 0.013 MB / 5.24 MB Application: afterRenderModule mod_search (Search)

Time: 22.80 ms / 493.50 ms Memory: 0.593 MB / 5.84 MB Application: afterRender

Database queries total: 222.06 ms

Memory Usage

Database Queries

51 Queries Logged 222.06 ms

23 duplicate found!

17 duplicates: #10 #30 #31 #32 #33 #35 #36 #37 #38 #39 #40 #44 #45 #46 #47 #48 #49

3 duplicates: #19 #20 #28

3 duplicates: #22 #23 #24

Query Time: 10.98 ms Query memory: 0.023 MB Memory before query: 1.348 MB Rows returned: 0

SELECT `data`

  FROM `bsu_session`

  WHERE `session_id` = X'6666373230376334313766643662356366386136323539376431626261356566'

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.52 ms After last query: 1.63 ms Query memory: 0.020 MB Memory before query: 1.362 MB Rows returned: 0

SELECT `session_id`

  FROM `bsu_session`

  WHERE `session_id` = X'6666373230376334313766643662356366386136323539376431626261356566' 
  LIMIT 1

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.95 ms After last query: 0.08 ms Query memory: 0.004 MB Memory before query: 1.367 MB

INSERT INTO `bsu_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6666373230376334313766643662356366386136323539376431626261356566', 1, 1737391032, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `bsu_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6666373230376334313766643662356366386136323539376431626261356566', 1, 1737391032, 0, '', 0)

Profile

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

Call Stack

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

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

Query Time: 35.64 ms After last query: 3.12 ms Query memory: 0.024 MB Memory before query: 1.462 MB Rows returned: 40

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

  FROM `bsu_extensions`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 5.48 ms After last query: 6.19 ms Query memory: 0.021 MB Memory before query: 1.492 MB Rows returned: 5

SELECT id, rules

  FROM `bsu_viewlevels`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 10.75 ms After last query: 0.21 ms Query memory: 0.021 MB Memory before query: 1.504 MB Rows returned: 2

SELECT b.id

  FROM bsu_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 4.76 ms After last query: 1.99 ms Query memory: 0.030 MB Memory before query: 1.525 MB Rows returned: 101

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

  FROM bsu_extensions

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

  ORDER BY ordering

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 12.02 ms After last query: 32.25 ms Query memory: 0.048 MB Memory before query: 2.079 MB Rows returned: 23

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

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 26.02 ms After last query: 11.39 ms Query memory: 0.022 MB Memory before query: 2.389 MB Rows returned: 1

SELECT id, home, template, s.params

  FROM bsu_template_styles as s

  LEFT JOIN bsu_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	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	1
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	gu_bsu.s.template,const	1	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
11	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:266
10	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/helixultimate.php:216
9	PlgSystemHelixultimate->attachWebAsset()	JROOT/plugins/system/helixultimate/helixultimate.php:245
8	PlgSystemHelixultimate->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.84 ms After last query: 3.06 ms Query memory: 0.022 MB Memory before query: 2.424 MB Rows returned: 1

Duplicate queries: #30 #31 #32 #33 #35 #36 #37 #38 #39 #40 #44 #45 #46 #47 #48 #49

SELECT *

  FROM `bsu_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '20'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bsu_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
11	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
10	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/helixultimate.php:216
9	PlgSystemHelixultimate->attachWebAsset()	JROOT/plugins/system/helixultimate/helixultimate.php:245
8	PlgSystemHelixultimate->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.94 ms After last query: 1.00 ms Query memory: 0.022 MB Memory before query: 2.509 MB Rows returned: 1

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

  FROM `bsu_extensions`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.74 ms After last query: 0.20 ms Query memory: 0.005 MB Memory before query: 2.500 MB

UPDATE `bsu_extensions`

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

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.11 ms After last query: 3.62 ms Query memory: 0.019 MB Memory before query: 2.521 MB Rows returned: 1

SELECT *

  FROM bsu_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bsu_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.02 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.36 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 6.52 ms After last query: 9.87 ms Query memory: 0.027 MB Memory before query: 2.687 MB Rows returned: 40

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

  FROM `bsu_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','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_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_speasyimagegallery','com_sppagebuilder','com_spsimpleportfolio','com_tags','com_templates','com_uniterevolution2','com_users','com_wrapper')

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_sppagebuilder/models/page.php:29
11	SppagebuilderModelPage->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_sppagebuilder/models/page.php:175
9	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/controller.php:65
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.58 ms After last query: 1.01 ms Query memory: 0.027 MB Memory before query: 2.747 MB Rows returned: 25

SHOW FULL COLUMNS 
  FROM `bsu_sppagebuilder`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
12	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_sppagebuilder/tables/page.php:17
11	SppagebuilderTablePage->__construct()	JROOT/libraries/src/Table/Table.php:328
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_sppagebuilder/models/page.php:176
9	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/controller.php:65
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 3.04 ms After last query: 0.51 ms Query memory: 0.186 MB Memory before query: 2.785 MB Rows returned: 1

SELECT *

  FROM bsu_sppagebuilder

  WHERE `id` = '63'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
10	Joomla\CMS\Table\Table->load()	JROOT/components/com_sppagebuilder/models/page.php:177
9	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/controller.php:65
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.83 ms After last query: 0.21 ms Query memory: 0.006 MB Memory before query: 2.938 MB

UPDATE bsu_sppagebuilder

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

  WHERE `id` = '63'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_sppagebuilder/models/page.php:178
9	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/controller.php:65
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 12.92 ms After last query: 2.02 ms Query memory: 0.187 MB Memory before query: 2.872 MB Rows returned: 1

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

  FROM bsu_sppagebuilder as a

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

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

  WHERE a.id = 63 
  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.11 ms
checking permissions	0.02 ms
Opening tables	0.09 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.07 ms
Optimizing	0.05 ms
Statistics	11.04 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	1.15 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

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

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

Query Time: 0.79 ms After last query: 6.75 ms Query memory: 0.025 MB Memory before query: 2.981 MB Rows returned: 1

Duplicate queries: #20 #28

SELECT `template`

  FROM `bsu_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	bsu_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:643
16	AddonParser::getTemplateName()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:154
15	AddonParser::getAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:739
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/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:37
10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Duplicate queries: #19 #28

SELECT `template`

  FROM `bsu_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	bsu_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:37
16	SpPgaeBuilderBase::getTemplateName()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:45
15	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:37
10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 9.02 ms After last query: 3.23 ms Query memory: 0.034 MB Memory before query: 3.985 MB Rows returned: 70

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

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

  FROM bsu_tags

  WHERE `published` = '1') AS a

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

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

  ORDER BY a.lft ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:194
17	SpPgaeBuilderBase::getArticleTags()	JROOT/components/com_sppagebuilder/addons/articles/admin.php:163
16	require_once JROOT/components/com_sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
15	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:37
10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.82 ms After last query: 0.13 ms Query memory: 0.025 MB Memory before query: 4.002 MB Rows returned: 0

Duplicate queries: #23 #24

SELECT a.enabled

  FROM `bsu_extensions` AS `a`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:545
17	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles/admin.php:172
16	require_once JROOT/components/com_sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
15	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:37
10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.96 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 4.017 MB Rows returned: 0

Duplicate queries: #22 #24

SELECT a.enabled

  FROM `bsu_extensions` AS `a`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:545
17	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles/admin.php:279
16	require_once JROOT/components/com_sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
15	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:37
10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.69 ms After last query: 0.95 ms Query memory: 0.025 MB Memory before query: 4.053 MB Rows returned: 0

Duplicate queries: #22 #23

SELECT a.enabled

  FROM `bsu_extensions` AS `a`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:545
17	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles_scroller/admin.php:138
16	require_once JROOT/components/com_sppagebuilder/addons/articles_scroller/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
15	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:37
10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.87 ms After last query: 17.44 ms Query memory: 0.025 MB Memory before query: 4.739 MB Rows returned: 1

SELECT a.enabled

  FROM `bsu_extensions` AS `a`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:470
17	SpPgaeBuilderBase::acymailingList()	JROOT/components/com_sppagebuilder/addons/optin_form/admin.php:163
16	require_once JROOT/components/com_sppagebuilder/addons/optin_form/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
15	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:37
10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.60 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 4.750 MB Rows returned: 1

SELECT `e`.`manifest_cache`

  FROM `bsu_extensions` AS `e`

  WHERE e.element = 'com_acymailing' OR e.element = 'com_acym'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:529
18	SpPgaeBuilderBase::getExtensionVersion()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:475
17	SpPgaeBuilderBase::acymailingList()	JROOT/components/com_sppagebuilder/addons/optin_form/admin.php:163
16	require_once JROOT/components/com_sppagebuilder/addons/optin_form/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
15	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:37
10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 29.09 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 4.761 MB Rows returned: 1

SELECT `listid`,`name`

  FROM `bsu_acymailing_list`

  WHERE `published` = '1'

  ORDER BY name DESC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:492
17	SpPgaeBuilderBase::acymailingList()	JROOT/components/com_sppagebuilder/addons/optin_form/admin.php:163
16	require_once JROOT/components/com_sppagebuilder/addons/optin_form/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
15	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:37
10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.77 ms After last query: 26.56 ms Query memory: 0.025 MB Memory before query: 5.262 MB Rows returned: 1

Duplicate queries: #19 #20

SELECT `template`

  FROM `bsu_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	bsu_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:37
17	SpPgaeBuilderBase::getTemplateName()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:45
16	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
15	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:288
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:37
10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.98 ms After last query: 3.43 ms Query memory: 0.028 MB Memory before query: 5.332 MB Rows returned: 36

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

  FROM `bsu_assets`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
18	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:97
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:37
10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.65 ms After last query: 5.33 ms Query memory: 0.022 MB Memory before query: 4.784 MB Rows returned: 1

Duplicate queries: #10 #31 #32 #33 #35 #36 #37 #38 #39 #40 #44 #45 #46 #47 #48 #49

SELECT *

  FROM `bsu_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '20'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bsu_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
11	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
10	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:118
9	HelixUltimate\Framework\Core\HelixUltimate->__construct()	JROOT/plugins/system/helixultimate/core/helixultimate.php:37
8	HelixUltimate->__construct()	JROOT/templates/itl_recycling/index.php:17
7	require JROOT/templates/itl_recycling/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.60 ms After last query: 0.20 ms Query memory: 0.022 MB Memory before query: 4.812 MB Rows returned: 1

Duplicate queries: #10 #30 #32 #33 #35 #36 #37 #38 #39 #40 #44 #45 #46 #47 #48 #49

SELECT *

  FROM `bsu_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '20'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bsu_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
11	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
10	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:388
9	HelixUltimate\Framework\Platform\Helper::flushSettingsDataToJs()	JROOT/plugins/system/helixultimate/core/helixultimate.php:38
8	HelixUltimate->__construct()	JROOT/templates/itl_recycling/index.php:17
7	require JROOT/templates/itl_recycling/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.59 ms After last query: 2.53 ms Query memory: 0.024 MB Memory before query: 4.859 MB Rows returned: 1

Duplicate queries: #10 #30 #31 #33 #35 #36 #37 #38 #39 #40 #44 #45 #46 #47 #48 #49

SELECT *

  FROM `bsu_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '20'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bsu_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
15	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
14	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/Classes/HelixultimateMenu.php:95
13	HelixUltimate\Framework\Core\Classes\HelixultimateMenu->__construct()	JROOT/plugins/system/helixultimate/core/classes/menu.php:40
12	HelixultimateMenu->__construct()	JROOT/templates/itl_recycling/features/menu.php:50
11	HelixUltimateFeatureMenu->renderFeature()	JROOT/templates/itl_recycling/headers/style-1/header.php:106
10	include JROOT/templates/itl_recycling/headers/style-1/header.php	JROOT/libraries/src/Layout/FileLayout.php:125
9	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:1588
8	HelixUltimate\Framework\Core\HelixUltimate->getHeaderStyle()	JROOT/templates/itl_recycling/index.php:128
7	require JROOT/templates/itl_recycling/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.58 ms After last query: 2.40 ms Query memory: 0.024 MB Memory before query: 4.927 MB Rows returned: 1

Duplicate queries: #10 #30 #31 #32 #35 #36 #37 #38 #39 #40 #44 #45 #46 #47 #48 #49

SELECT *

  FROM `bsu_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '20'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bsu_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
14	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
13	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/Classes/HelixultimateMenu.php:95
12	HelixUltimate\Framework\Core\Classes\HelixultimateMenu->__construct()	JROOT/plugins/system/helixultimate/core/classes/menu.php:40
11	HelixultimateMenu->__construct()	JROOT/templates/itl_recycling/features/menu.php:50
10	HelixUltimateFeatureMenu->renderFeature()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:555
9	HelixUltimate\Framework\Core\HelixUltimate->include_features()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:573
8	HelixUltimate\Framework\Core\HelixUltimate->render_layout()	JROOT/templates/itl_recycling/index.php:129
7	require JROOT/templates/itl_recycling/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.19 ms After last query: 2.14 ms Query memory: 0.026 MB Memory before query: 4.990 MB Rows returned: 10

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

  FROM bsu_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-01-20 16:37:13') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-01-20 16:37:13') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 215 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	14	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	gu_bsu.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	gu_bsu.m.module,const	1	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:992
11	HelixUltimate\Framework\Core\HelixUltimate->count_modules()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:726
10	HelixUltimate\Framework\Core\HelixUltimate->get_current_row()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:628
9	HelixUltimate\Framework\Core\HelixUltimate->get_recursive_layout()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:594
8	HelixUltimate\Framework\Core\HelixUltimate->render_layout()	JROOT/templates/itl_recycling/index.php:129
7	require JROOT/templates/itl_recycling/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.67 ms After last query: 0.80 ms Query memory: 0.026 MB Memory before query: 5.054 MB Rows returned: 1

Duplicate queries: #10 #30 #31 #32 #33 #36 #37 #38 #39 #40 #44 #45 #46 #47 #48 #49

SELECT *

  FROM `bsu_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '20'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bsu_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
17	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
16	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/layouts/frontend/modules.php:18
15	include JROOT/plugins/system/helixultimate/layouts/frontend/modules.php	JROOT/libraries/src/Layout/FileLayout.php:125
14	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/layouts/frontend/rows.php:44
13	include JROOT/plugins/system/helixultimate/layouts/frontend/rows.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/layouts/frontend/generate.php:35
11	include JROOT/plugins/system/helixultimate/layouts/frontend/generate.php	JROOT/libraries/src/Layout/FileLayout.php:125
10	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:698
9	HelixUltimate\Framework\Core\HelixUltimate->get_recursive_layout()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:594
8	HelixUltimate\Framework\Core\HelixUltimate->render_layout()	JROOT/templates/itl_recycling/index.php:129
7	require JROOT/templates/itl_recycling/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.60 ms After last query: 1.10 ms Query memory: 0.026 MB Memory before query: 5.061 MB Rows returned: 1

Duplicate queries: #10 #30 #31 #32 #33 #35 #37 #38 #39 #40 #44 #45 #46 #47 #48 #49

SELECT *

  FROM `bsu_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '20'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bsu_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
17	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
16	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/layouts/frontend/modules.php:18
15	include JROOT/plugins/system/helixultimate/layouts/frontend/modules.php	JROOT/libraries/src/Layout/FileLayout.php:125
14	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/layouts/frontend/rows.php:44
13	include JROOT/plugins/system/helixultimate/layouts/frontend/rows.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/layouts/frontend/generate.php:35
11	include JROOT/plugins/system/helixultimate/layouts/frontend/generate.php	JROOT/libraries/src/Layout/FileLayout.php:125
10	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:698
9	HelixUltimate\Framework\Core\HelixUltimate->get_recursive_layout()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:594
8	HelixUltimate\Framework\Core\HelixUltimate->render_layout()	JROOT/templates/itl_recycling/index.php:129
7	require JROOT/templates/itl_recycling/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.59 ms After last query: 0.28 ms Query memory: 0.026 MB Memory before query: 5.071 MB Rows returned: 1

Duplicate queries: #10 #30 #31 #32 #33 #35 #36 #38 #39 #40 #44 #45 #46 #47 #48 #49

SELECT *

  FROM `bsu_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '20'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bsu_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
17	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
16	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/layouts/frontend/modules.php:18
15	include JROOT/plugins/system/helixultimate/layouts/frontend/modules.php	JROOT/libraries/src/Layout/FileLayout.php:125
14	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/layouts/frontend/rows.php:44
13	include JROOT/plugins/system/helixultimate/layouts/frontend/rows.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/layouts/frontend/generate.php:35
11	include JROOT/plugins/system/helixultimate/layouts/frontend/generate.php	JROOT/libraries/src/Layout/FileLayout.php:125
10	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:698
9	HelixUltimate\Framework\Core\HelixUltimate->get_recursive_layout()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:594
8	HelixUltimate\Framework\Core\HelixUltimate->render_layout()	JROOT/templates/itl_recycling/index.php:129
7	require JROOT/templates/itl_recycling/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.55 ms After last query: 0.27 ms Query memory: 0.026 MB Memory before query: 5.081 MB Rows returned: 1

Duplicate queries: #10 #30 #31 #32 #33 #35 #36 #37 #39 #40 #44 #45 #46 #47 #48 #49

SELECT *

  FROM `bsu_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '20'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bsu_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
17	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
16	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/layouts/frontend/modules.php:18
15	include JROOT/plugins/system/helixultimate/layouts/frontend/modules.php	JROOT/libraries/src/Layout/FileLayout.php:125
14	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/layouts/frontend/rows.php:44
13	include JROOT/plugins/system/helixultimate/layouts/frontend/rows.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/layouts/frontend/generate.php:35
11	include JROOT/plugins/system/helixultimate/layouts/frontend/generate.php	JROOT/libraries/src/Layout/FileLayout.php:125
10	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:698
9	HelixUltimate\Framework\Core\HelixUltimate->get_recursive_layout()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:594
8	HelixUltimate\Framework\Core\HelixUltimate->render_layout()	JROOT/templates/itl_recycling/index.php:129
7	require JROOT/templates/itl_recycling/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.55 ms After last query: 0.27 ms Query memory: 0.026 MB Memory before query: 5.091 MB Rows returned: 1

Duplicate queries: #10 #30 #31 #32 #33 #35 #36 #37 #38 #40 #44 #45 #46 #47 #48 #49

SELECT *

  FROM `bsu_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '20'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bsu_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
17	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
16	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/layouts/frontend/modules.php:18
15	include JROOT/plugins/system/helixultimate/layouts/frontend/modules.php	JROOT/libraries/src/Layout/FileLayout.php:125
14	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/layouts/frontend/rows.php:44
13	include JROOT/plugins/system/helixultimate/layouts/frontend/rows.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/layouts/frontend/generate.php:35
11	include JROOT/plugins/system/helixultimate/layouts/frontend/generate.php	JROOT/libraries/src/Layout/FileLayout.php:125
10	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:698
9	HelixUltimate\Framework\Core\HelixUltimate->get_recursive_layout()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:594
8	HelixUltimate\Framework\Core\HelixUltimate->render_layout()	JROOT/templates/itl_recycling/index.php:129
7	require JROOT/templates/itl_recycling/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.55 ms After last query: 0.43 ms Query memory: 0.026 MB Memory before query: 5.101 MB Rows returned: 1

Duplicate queries: #10 #30 #31 #32 #33 #35 #36 #37 #38 #39 #44 #45 #46 #47 #48 #49

SELECT *

  FROM `bsu_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '20'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bsu_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
17	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
16	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/layouts/frontend/modules.php:18
15	include JROOT/plugins/system/helixultimate/layouts/frontend/modules.php	JROOT/libraries/src/Layout/FileLayout.php:125
14	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/layouts/frontend/rows.php:44
13	include JROOT/plugins/system/helixultimate/layouts/frontend/rows.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/layouts/frontend/generate.php:35
11	include JROOT/plugins/system/helixultimate/layouts/frontend/generate.php	JROOT/libraries/src/Layout/FileLayout.php:125
10	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:698
9	HelixUltimate\Framework\Core\HelixUltimate->get_recursive_layout()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:594
8	HelixUltimate\Framework\Core\HelixUltimate->render_layout()	JROOT/templates/itl_recycling/index.php:129
7	require JROOT/templates/itl_recycling/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.81 ms After last query: 3.88 ms Query memory: 0.024 MB Memory before query: 5.139 MB Rows returned: 6

SELECT a.*

  FROM `bsu_speasyimagegallery_images` AS `a`

  WHERE `album_id` = '1' 
  AND `state` = '1'

  ORDER BY a.ordering DESC 
  LIMIT 6

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_speasyimagegallery/helper.php:83
11	ModSpeasyimagegalleryHelper::getImages()	JROOT/modules/mod_speasyimagegallery/mod_speasyimagegallery.php:29
10	include JROOT/modules/mod_speasyimagegallery/mod_speasyimagegallery.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 16.55 ms After last query: 4.02 ms Query memory: 0.041 MB Memory before query: 5.200 MB Rows returned: 2

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM bsu_content AS a

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

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

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

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

  LEFT JOIN bsu_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid IN (8) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-01-20 16:37:13') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-01-20 16:37:13')

  ORDER BY a.publish_up DESC 
  LIMIT 2

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_state	1	const	58	Using where; Using filesort
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	gu_bsu.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	gu_bsu.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	gu_bsu.a.id	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:123
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 6.14 ms After last query: 1.72 ms Query memory: 0.028 MB Memory before query: 5.253 MB Rows returned: 2

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

  FROM `bsu_categories` AS `s`

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

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

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	13	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
21	ContentRouter->getCategorySegment()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_latest/helper.php:135
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.67 ms After last query: 6.82 ms Query memory: 0.023 MB Memory before query: 5.242 MB Rows returned: 1

Duplicate queries: #10 #30 #31 #32 #33 #35 #36 #37 #38 #39 #40 #45 #46 #47 #48 #49

SELECT *

  FROM `bsu_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '20'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bsu_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
14	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
13	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/helixultimate.php:386
12	PlgSystemHelixultimate->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.59 ms After last query: 0.23 ms Query memory: 0.024 MB Memory before query: 5.272 MB Rows returned: 1

Duplicate queries: #10 #30 #31 #32 #33 #35 #36 #37 #38 #39 #40 #44 #46 #47 #48 #49

SELECT *

  FROM `bsu_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '20'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bsu_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
15	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
14	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:118
13	HelixUltimate\Framework\Core\HelixUltimate->__construct()	JROOT/plugins/system/helixultimate/helixultimate.php:398
12	PlgSystemHelixultimate->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.56 ms After last query: 0.21 ms Query memory: 0.024 MB Memory before query: 5.302 MB Rows returned: 1

Duplicate queries: #10 #30 #31 #32 #33 #35 #36 #37 #38 #39 #40 #44 #45 #47 #48 #49

SELECT *

  FROM `bsu_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '20'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bsu_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
16	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
15	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:1966
14	HelixUltimate\Framework\Core\HelixUltimate->addCustomAssets()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:147
13	HelixUltimate\Framework\Core\HelixUltimate->__call()	JROOT/plugins/system/helixultimate/helixultimate.php:421
12	PlgSystemHelixultimate->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.56 ms After last query: 0.22 ms Query memory: 0.024 MB Memory before query: 5.310 MB Rows returned: 1

Duplicate queries: #10 #30 #31 #32 #33 #35 #36 #37 #38 #39 #40 #44 #45 #46 #48 #49

SELECT *

  FROM `bsu_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '20'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bsu_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
16	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
15	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:1966
14	HelixUltimate\Framework\Core\HelixUltimate->addCustomAssets()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:147
13	HelixUltimate\Framework\Core\HelixUltimate->__call()	JROOT/plugins/system/helixultimate/helixultimate.php:422
12	PlgSystemHelixultimate->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.56 ms After last query: 0.21 ms Query memory: 0.024 MB Memory before query: 5.319 MB Rows returned: 1

Duplicate queries: #10 #30 #31 #32 #33 #35 #36 #37 #38 #39 #40 #44 #45 #46 #47 #49

SELECT *

  FROM `bsu_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '20'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bsu_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
16	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
15	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:1966
14	HelixUltimate\Framework\Core\HelixUltimate->addCustomAssets()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:147
13	HelixUltimate\Framework\Core\HelixUltimate->__call()	JROOT/plugins/system/helixultimate/helixultimate.php:423
12	PlgSystemHelixultimate->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.78 ms After last query: 1.23 ms Query memory: 0.021 MB Memory before query: 5.366 MB Rows returned: 1

Duplicate queries: #10 #30 #31 #32 #33 #35 #36 #37 #38 #39 #40 #44 #45 #46 #47 #48

SELECT *

  FROM `bsu_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '20'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bsu_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
9	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
8	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/helixultimate.php:525
7	PlgSystemHelixultimate->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.30 ms After last query: 7.71 ms Query memory: 0.028 MB Memory before query: 5.446 MB Rows returned: 140

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
15	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
14	JDatabaseDriverMysqli->getTableList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:724
13	acymailing_getTableList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:18
12	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:540
11	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:1080
10	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:27
9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:24
8	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:148
7	plgSystemRegacymailing->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.35 ms After last query: 0.07 ms Query memory: 0.033 MB Memory before query: 5.472 MB Rows returned: 132

SELECT * 
  FROM bsu_acymailing_config

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:628
13	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:23
12	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:540
11	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:1080
10	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:27
9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:24
8	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:148
7	plgSystemRegacymailing->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

28 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

17 × SELECT * 
  FROM `bsu_template_styles`

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

3 × SELECT `template` 
  FROM `bsu_template_styles`

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

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

1 × SELECT `data` 
  FROM `bsu_session`

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

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,        COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
  FROM bsu_content AS a 
  LEFT JOIN bsu_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN bsu_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN bsu_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN bsu_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN bsu_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT a.* 
  FROM `bsu_speasyimagegallery_images` AS `a`

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

1 × SELECT `listid`,`name` 
  FROM `bsu_acymailing_list`

1 × SELECT `e`.`manifest_cache` 
  FROM `bsu_extensions` AS `e`

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

1 × SELECT * 
  FROM bsu_sppagebuilder

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

1 × SELECT `session_id` 
  FROM `bsu_session`

```
1 × SELECT * 
  FROM bsu_languages
```

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

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

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

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

1 × SELECT id, rules 
  FROM `bsu_viewlevels

1 × SELECT * 
  FROM bsu_acymailing_confi

OTHER Tables:

1 × INSERT INTO `bsu_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6666373230376334313766643662356366386136323539376431626261356566', 1, 1737391032, 0, '', 0

1 × UPDATE `bsu_extensions` 
  SET `params` = '{\"mediaversion\":\"a58a357ac7b3d2df5ecbeacd5b9617c4\"}'

1 × SHOW FULL COLUMNS 
  FROM `bsu_sppagebuilder

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

```
1 × SHOW TABLE
```