MARKET ANALYSIS

"Market Planning Demands Critical Thinking, Self-Reflexiveness, Sober-Headed Analysis.”

For our clients, the marketing plan is simply the difference between success and failure. The foundation of a good marketing plan is market sensing, categorization, study of inter-relationships, and the recognition of the correlations in behavior. All this enables effect-cause-effect thinking needed to remain competitive.

Historical Research

21 May 2019Market AnalysisCathy Lindon

“If I collect data like lessons-learned, search trends, and customer requests, then I suspect I could learn from the past, but I really don’t know how to conduct this type of historical researc...

Read More

Critical Success Factor Analysis
14 February 2019Market AnalysisDavid Wilson
Identifying critical success factors (CSFs) is a valuable and necessary part of strategic development. “Critical success factors are the few things that must go well to ensure success for a manager...
Read More

Quick Links

Our Market Analysis Services

"Market Sensing can be divided into four main business objectives; Market Analysis, Knowledge Curation, Competitive Analysis, and Customer Satisfaction.

Market Analysis is about discovering the best size and value estimation of your market, now and in the future. Our Market Sensing service conducts a market analysis to support strategic planning and decision making. We help clients segment their market to maximize value, while reducing risk and competition.

We also facilitate product definition that will maximize customer satisfaction with product features, return value to the stakeholders, all within current and future business constraints.

Let's Set-up a Call

Or feel free to use our website chat

Your name *
Please enter your first and last name
Phone number to call *
Email *
Select your available time slots
Message
Write your message!
Please Validate *

THE AGENCY
COMMUNITIES
Member Administration
Provoking
Befriending
Activating
SOCIAL MARKETING
The Use of Personas & Roles
Marketing Plays
Messages & Role Mixes
Eight Elements of Teamwork
LEAD GENERATION
Targeting Prospects
Branding and Advertising
Sales and Social Marketing
Performance Models and Measures
MARKET RESEARCH
Market Analysis
Knowledge Curation
Competitive Analysis
Customer Satisfaction
NETWORK GROWTH
Social Network Comparisons
Network Access
Network Size
Serving the Network
WEBSITE CONSTRUCTION
Design for Social Marketing
Technology and Hosting
Sales Psychology
Measure, Analyze, & Update

Joomla! Debug Console
Session
{ "__default": { "session": { "counter": 1, "timer": { "start": 1670188311, "last": 1670188311, "now": 1670188311 }, "token": "y00motjhvpwDjlWIhcERIhyYKBZ9lhoA" }, "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: 17.36 ms / 17.36 ms Memory: 1.634 MB / 1.97 MB Application: afterLoad
Time: 47.43 ms / 64.79 ms Memory: 4.825 MB / 6.80 MB Application: afterInitialise
Time: 16.36 ms / 81.15 ms Memory: 2.427 MB / 9.23 MB Application: afterRoute
Time: 2.53 ms / 83.68 ms Memory: 0.082 MB / 9.31 MB Application: beforeRenderComponent com_sppagebuilder
Time: 5.59 ms / 89.27 ms Memory: 0.636 MB / 9.95 MB Application: Before Access::preloadComponents (all components)
Time: 1.37 ms / 90.64 ms Memory: 0.060 MB / 10.01 MB Application: After Access::preloadComponents (all components)
Time: 0.02 ms / 90.66 ms Memory: -0.003 MB / 10.00 MB Application: Before Access::getAssetRules (id:65 name:com_sppagebuilder)
Time: 0.38 ms / 91.04 ms Memory: 0.028 MB / 10.03 MB Application: After Access::getAssetRules (id:65 name:com_sppagebuilder)
Time: 84.77 ms / 175.80 ms Memory: 7.099 MB / 17.13 MB Application: beforeRenderModule mod_menu (Quick Links M- Market Analysis)
Time: 1.60 ms / 177.41 ms Memory: 0.076 MB / 17.21 MB Application: afterRenderModule mod_menu (Quick Links M- Market Analysis)
Time: 4.18 ms / 181.58 ms Memory: -0.026 MB / 17.18 MB Application: Before Access::preloadPermissions (com_sppagebuilder)
Time: 0.85 ms / 182.44 ms Memory: 0.043 MB / 17.22 MB Application: After Access::preloadPermissions (com_sppagebuilder)
Time: 0.02 ms / 182.45 ms Memory: -0.002 MB / 17.22 MB Application: Before Access::getAssetRules (id:104 name:com_sppagebuilder.page.13)
Time: 0.01 ms / 182.46 ms Memory: 0.002 MB / 17.22 MB Application: After Access::getAssetRules (id:104 name:com_sppagebuilder.page.13)
Time: 0.06 ms / 182.53 ms Memory: -0.144 MB / 17.08 MB Application: afterRenderComponent com_sppagebuilder
Time: 0.99 ms / 183.52 ms Memory: 0.107 MB / 17.18 MB Application: afterDispatch
Time: 7.09 ms / 190.60 ms Memory: 0.413 MB / 17.60 MB Application: beforeRenderModule mod_menu (Main Menu)
Time: 4.17 ms / 194.78 ms Memory: 0.137 MB / 17.74 MB Application: afterRenderModule mod_menu (Main Menu)
Time: 0.07 ms / 194.84 ms Memory: -0.004 MB / 17.73 MB Application: beforeRenderModule mod_finder (Site Search)
Time: 7.30 ms / 202.15 ms Memory: 0.399 MB / 18.13 MB Application: afterRenderModule mod_finder (Site Search)
Time: 10.79 ms / 212.93 ms Memory: 0.476 MB / 18.61 MB Application: afterRender

Database queries total: 38.77 ms
Memory Usage
19.26 MB (20,191,408 Bytes)
Database Queries
47 Queries Logged 38.77 ms

6 duplicate found!
2 duplicates: #18 #20
4 duplicates: #22 #23 #24 #26
Query Time: 0.81 ms Query memory: 0.023 MB Memory before query: 3.700 MB Rows returned: 0
SELECT `data`
  FROM `jos_session`
  WHERE `session_id` = X'3336363830333030656437336261653136623766363836623237306239623637'
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE jos_session const PRIMARY PRIMARY 194 const 1
Profile
Status Duration
Starting 0.15 ms
Checking permissions 0.04 ms
Opening tables 0.22 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.02 ms
Commit 0.02 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740
15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45
14 JSessionStorageDatabase->read() Same as call in the line below.
13 session_start() JROOT/libraries/joomla/session/handler/native.php:260
12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50
11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88
10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660
9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620
8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498
7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455
6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:832
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:392
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.43 ms After last query: 0.92 ms Query memory: 0.020 MB Memory before query: 3.807 MB Rows returned: 0
SELECT `session_id`
  FROM `jos_session`
  WHERE `session_id` = X'3336363830333030656437336261653136623766363836623237306239623637'
  LIMIT 1
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE jos_session const PRIMARY PRIMARY 194 const 1 Using index
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.02 ms
Optimizing 0.02 ms
Statistics 0.03 ms
Preparing 0.02 ms
Executing 0.02 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 0.02 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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:834
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:392
2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140
1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.11 ms After last query: 0.06 ms Query memory: 0.004 MB Memory before query: 3.812 MB
INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
  VALUES (X'3336363830333030656437336261653136623766363836623237306239623637', 1, 1670188311, 0, '', 0)
Explain
EXPLAIN not possible on query: INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3336363830333030656437336261653136623766363836623237306239623637', 1, 1670188311, 0, '', 0)
Profile
Status Duration
Starting 0.03 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 for update 0.02 ms
Update 0.11 ms
End of update loop 0.12 ms
Query end 0.02 ms
Commit 0.55 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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:834
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:392
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.94 ms After last query: 2.49 ms Query memory: 0.024 MB Memory before query: 4.114 MB Rows returned: 38
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
  FROM `jos_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 jos_extensions ref extension extension 82 const 39 Using index condition; Using where
Profile
Status Duration
Starting 0.04 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.03 ms
Optimizing 0.03 ms
Statistics 0.05 ms
Preparing 0.03 ms
Executing 0.02 ms
Sending data 0.18 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 0.02 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
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:203
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: 1.95 ms Query memory: 0.021 MB Memory before query: 4.326 MB Rows returned: 5
SELECT id, rules
  FROM `jos_viewlevels`
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE jos_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5
Profile
Status Duration
Starting 0.03 ms
Checking permissions 0.02 ms
Opening tables 0.19 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.02 ms
Preparing 0.02 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
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
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:203
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.76 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 4.338 MB Rows returned: 2
SELECT b.id
  FROM jos_usergroups AS a
  LEFT JOIN jos_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 index idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 8 NULL 9 Using where; Using index
Profile
Status Duration
Starting 0.04 ms
Checking permissions 0.02 ms
Opening tables 0.21 ms
After opening tables 0.03 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.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
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
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:203
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.00 ms After last query: 0.55 ms Query memory: 0.030 MB Memory before query: 4.409 MB Rows returned: 93
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
  FROM jos_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 jos_extensions ref extension extension 82 const 120 Using index condition; Using where; Using filesort
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.03 ms
Statistics 0.04 ms
Preparing 0.03 ms
Sorting result 0.02 ms
Executing 0.02 ms
Sending data 0.02 ms
Creating sort index 0.43 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 0.02 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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: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:203
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.56 ms After last query: 21.70 ms Query memory: 0.450 MB Memory before query: 7.011 MB Rows returned: 358
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 jos_menu AS m
  LEFT JOIN jos_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 ALL idx_client_id_parent_id_alias_language NO INDEX KEY COULD BE USED NULL NULL 449 Using where; Using filesort
1 SIMPLE e eq_ref PRIMARY PRIMARY 4 i5353153_jos3.m.component_id 1 Using where
Profile
Status Duration
Starting 0.16 ms
Checking permissions 0.02 ms
Opening tables 0.27 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.03 ms
Sorting result 0.02 ms
Executing 0.02 ms
Sending data 0.03 ms
Creating sort index 1.60 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 0.02 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
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:423
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:539
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:1147
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:203
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: 8.99 ms Query memory: 0.025 MB Memory before query: 8.979 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
  FROM `jos_extensions`
  WHERE `type` = 'library'
  AND `element` = 'joomla'
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE jos_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition
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.02 ms
Statistics 0.06 ms
Preparing 0.03 ms
Executing 0.02 ms
Sending data 0.05 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 0.02 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662
18 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167
17 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below.
16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175
14 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43
13 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90
12 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321
11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778
10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234
9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/helixultimate/helixultimate.php:134
8 plgSystemHelixultimate->onAfterRoute() JROOT/libraries/joomla/event/event.php:70
7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108
5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1196
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:203
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.95 ms After last query: 0.13 ms Query memory: 0.006 MB Memory before query: 8.972 MB
UPDATE `jos_extensions`
  SET `params` = '{\"mediaversion\":\"6f49391773c0649ae1d5a47d929953bf\"}'
  WHERE `type` = 'library'
  AND `element` = 'joomla'
Explain
EXPLAIN not possible on query: UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"6f49391773c0649ae1d5a47d929953bf\"}' WHERE `type` = 'library' AND `element` = 'joomla'
Profile
Status Duration
Starting 0.03 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 for update 0.06 ms
Updating 0.07 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 0.50 ms
Closing tables 0.03 ms
Unlocking tables 0.02 ms
Closing tables 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
14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117
13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372
12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331
11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778
10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234
9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/helixultimate/helixultimate.php:134
8 plgSystemHelixultimate->onAfterRoute() JROOT/libraries/joomla/event/event.php:70
7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108
5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1196
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:203
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: 1.59 ms Query memory: 0.019 MB Memory before query: 9.232 MB Rows returned: 1
SELECT *
  FROM jos_languages
  WHERE published=1
  ORDER BY ordering ASC
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE jos_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using filesort
Profile
Status Duration
Starting 0.04 ms
Checking permissions 0.02 ms
Opening tables 0.26 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.02 ms
Preparing 0.02 ms
Sorting result 0.02 ms
Executing 0.02 ms
Sending data 0.02 ms
Creating sort index 0.06 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 0.02 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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:203
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: 0.25 ms Query memory: 0.019 MB Memory before query: 9.242 MB Rows returned: 3
SELECT id, home, template, s.params
  FROM jos_template_styles as s
  LEFT JOIN jos_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 3
1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 i5353153_jos3.s.template,const 1 Using index condition; Using where
Profile
Status Duration
Starting 0.05 ms
Checking permissions 0.02 ms
Opening tables 0.17 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.06 ms
Preparing 0.03 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
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486
4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168
3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203
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.20 ms After last query: 6.27 ms Query memory: 0.028 MB Memory before query: 9.949 MB Rows returned: 38
SELECT `id`,`name`,`rules`,`parent_id`
  FROM `jos_assets`
  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_creativecontactform','com_fields','com_finder','com_installer','com_joomlaupdate','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nexevocontact','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sppagebuilder','com_tags','com_templates','com_users','com_wrapper')
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE jos_assets ALL idx_asset_name NO INDEX KEY COULD BE USED NULL NULL 303 Using where
Profile
Status Duration
Starting 0.09 ms
Checking permissions 0.02 ms
Opening tables 0.22 ms
After opening tables 0.02 ms
System lock 0.02 ms
Table lock 0.02 ms
Init 0.05 ms
Optimizing 0.02 ms
Statistics 0.10 ms
Preparing 0.02 ms
Executing 0.02 ms
Sending data 0.39 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 0.02 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429
19 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213
18 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531
17 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183
16 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398
15 Joomla\CMS\User\User->authorise() JROOT/components/com_sppagebuilder/models/page.php:29
14 SppagebuilderModelPage->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
13 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_sppagebuilder/models/page.php:41
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:672
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39
8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26
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:203
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.99 ms After last query: 0.68 ms Query memory: 0.062 MB Memory before query: 10.043 MB Rows returned: 1
SELECT a.*,l.title AS language_title,ua.name AS author_name
  FROM jos_sppagebuilder as a
  LEFT JOIN `jos_languages` AS l
  ON l.lang_code = a.language
  LEFT JOIN jos_users AS ua
  ON ua.id = a.created_by
  WHERE a.id = 13
  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.05 ms
Checking permissions 0.02 ms
Opening tables 0.34 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 0.09 ms
Preparing 0.02 ms
Unlocking tables 0.02 ms
Preparing 0.02 ms
Executing 0.02 ms
Sending data 0.11 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 0.02 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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:672
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39
8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26
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:203
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.26 ms Query memory: 0.029 MB Memory before query: 10.078 MB Rows returned: 25
SHOW FULL COLUMNS
  FROM `jos_sppagebuilder`
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jos_sppagebuilder`
Profile
Status Duration
Starting 0.04 ms
Checking permissions 0.02 ms
Closing tables 0.02 ms
Opening tables 0.18 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.02 ms
Preparing 0.02 ms
Executing 0.02 ms
Filling schema table 0.02 ms
Opening tables 0.03 ms
After opening tables 0.02 ms
Checking permissions 0.11 ms
Closing tables 0.02 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
Closing tables 0.02 ms
Removing tmp table 0.07 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
17 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448
16 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245
15 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164
14 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_sppagebuilder/tables/page.php:17
13 SppagebuilderTablePage->__construct() JROOT/libraries/src/Table/Table.php:312
12 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_sppagebuilder/models/page.php:176
11 SppagebuilderModelPage->hit() JROOT/components/com_sppagebuilder/views/page/view.html.php:37
10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39
8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26
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:203
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.44 ms Query memory: 0.062 MB Memory before query: 10.132 MB Rows returned: 1
SELECT *
  FROM jos_sppagebuilder
  WHERE `id` = '13'
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE jos_sppagebuilder const PRIMARY PRIMARY 8 const 1
Profile
Status Duration
Starting 0.03 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.04 ms
Preparing 0.02 ms
Unlocking tables 0.02 ms
Preparing 0.02 ms
Executing 0.02 ms
Sending data 0.10 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 0.02 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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:1465
13 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731
12 Joomla\CMS\Table\Table->load() JROOT/components/com_sppagebuilder/models/page.php:177
11 SppagebuilderModelPage->hit() JROOT/components/com_sppagebuilder/views/page/view.html.php:37
10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39
8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26
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:203
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.08 ms After last query: 0.15 ms Query memory: 0.007 MB Memory before query: 10.160 MB
UPDATE jos_sppagebuilder
  SET `hits` = (`hits` + 1)
  WHERE `id` = '13'
Explain
EXPLAIN not possible on query: UPDATE jos_sppagebuilder SET `hits` = (`hits` + 1) WHERE `id` = '13'
Profile
Status Duration
Starting 0.03 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.04 ms
Updating 0.06 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 0.68 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
13 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1245
12 Joomla\CMS\Table\Table->hit() JROOT/components/com_sppagebuilder/models/page.php:178
11 SppagebuilderModelPage->hit() JROOT/components/com_sppagebuilder/views/page/view.html.php:37
10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39
8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26
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:203
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.49 ms After last query: 1.88 ms Query memory: 0.025 MB Memory before query: 10.349 MB Rows returned: 1
Duplicate queries: #20
SELECT `template`
  FROM `jos_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 jos_template_styles ref idx_client_id,idx_client_id_home idx_client_id 1 const 3 Using where
Profile
Status Duration
Starting 0.03 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.04 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
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662
17 JDatabaseDriver->loadObject() JROOT/components/com_sppagebuilder/parser/addon-parser.php:553
16 AddonParser::getTemplateName() JROOT/components/com_sppagebuilder/parser/addon-parser.php:152
15 AddonParser::getAddons() JROOT/components/com_sppagebuilder/parser/addon-parser.php:597
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:40
10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39
8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26
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:203
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: 28.42 ms Query memory: 0.026 MB Memory before query: 13.235 MB Rows returned: 1
SELECT `title`
  FROM `jos_sppagebuilder`
  WHERE id = '13'
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE jos_sppagebuilder const PRIMARY PRIMARY 8 const 1
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.03 ms
Optimizing 0.02 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.02 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 0.02 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740
22 JDatabaseDriver->loadResult() JROOT/components/com_sppagebuilder/router.php:126
21 SppagebuilderRouter->getPageSegment() JROOT/components/com_sppagebuilder/router.php:66
20 SppagebuilderRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532
19 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502
18 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281
17 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155
16 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144
15 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93
14 Joomla\CMS\Router\Route::_() JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:64
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:40
10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39
8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26
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:203
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.50 ms After last query: 1.47 ms Query memory: 0.025 MB Memory before query: 13.339 MB Rows returned: 1
Duplicate queries: #18
SELECT `template`
  FROM `jos_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 jos_template_styles ref idx_client_id,idx_client_id_home idx_client_id 1 const 3 Using where
Profile
Status Duration
Starting 0.03 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.02 ms
Statistics 0.04 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
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
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:190
14 AddonParser::viewAddons() JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:93
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:40
10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39
8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26
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:203
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.10 ms After last query: 4.15 ms Query memory: 0.026 MB Memory before query: 13.737 MB Rows returned: 9
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 jos_tags
  WHERE `published` = '1') AS a
  LEFT JOIN `jos_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 jos_tags ALL tag_idx NO INDEX KEY COULD BE USED NULL NULL 10 Using where; Using temporary; Using filesort
1 SIMPLE b ALL idx_left_right NO INDEX KEY COULD BE USED NULL NULL 10 Range checked for each record (index map: 0x20); Distinct
Profile
Status Duration
Starting 0.06 ms
Checking permissions 0.02 ms
Opening tables 0.31 ms
After opening tables 0.03 ms
System lock 0.02 ms
Table lock 0.02 ms
Init 0.06 ms
Optimizing 0.03 ms
Statistics 0.04 ms
Preparing 0.03 ms
Creating tmp table 0.03 ms
Sorting result 0.02 ms
Executing 0.02 ms
Sending data 0.10 ms
Creating sort index 0.03 ms
Removing tmp table 0.02 ms
Creating sort index 0.02 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 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
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
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:190
14 AddonParser::viewAddons() JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:93
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:40
10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39
8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26
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:203
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.11 ms Query memory: 0.025 MB Memory before query: 13.744 MB Rows returned: 0
Duplicate queries: #23 #24 #26
SELECT a.enabled
  FROM `jos_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 226 Using where
Profile
Status Duration
Starting 0.03 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.02 ms
Optimizing 0.02 ms
Statistics 0.02 ms
Preparing 0.02 ms
Executing 0.02 ms
Sending data 0.12 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 0.02 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740
18 JDatabaseDriver->loadResult() JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:496
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:190
14 AddonParser::viewAddons() JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:93
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:40
10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39
8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26
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:203
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.50 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 13.759 MB Rows returned: 0
Duplicate queries: #22 #24 #26
SELECT a.enabled
  FROM `jos_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 226 Using where
Profile
Status Duration
Starting 0.03 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.02 ms
Optimizing 0.02 ms
Statistics 0.02 ms
Preparing 0.02 ms
Executing 0.02 ms
Sending data 0.10 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 0.02 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740
18 JDatabaseDriver->loadResult() JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:496
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:190
14 AddonParser::viewAddons() JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:93
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:40
10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39
8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26
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:203
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.49 ms After last query: 0.75 ms Query memory: 0.025 MB Memory before query: 13.798 MB Rows returned: 0
Duplicate queries: #22 #23 #26
SELECT a.enabled
  FROM `jos_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 226 Using where
Profile
Status Duration
Starting 0.02 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.02 ms
Optimizing 0.02 ms
Statistics 0.02 ms
Preparing 0.02 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
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740
18 JDatabaseDriver->loadResult() JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:496
17 SpPgaeBuilderBase::k2CatList() JROOT/components/com_sppagebuilder/addons/articles_scroller/admin.php:61
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:190
14 AddonParser::viewAddons() JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:93
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:40
10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39
8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26
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:203
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: 8.81 ms Query memory: 0.025 MB Memory before query: 14.957 MB Rows returned: 0
SELECT a.enabled
  FROM `jos_extensions` AS `a`
  WHERE `a`.`name` = 'AcyMailing'
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 226 Using where
Profile
Status Duration
Starting 0.03 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.02 ms
Optimizing 0.02 ms
Statistics 0.02 ms
Preparing 0.02 ms
Executing 0.02 ms
Sending data 0.10 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 0.02 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740
18 JDatabaseDriver->loadResult() JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:463
17 SpPgaeBuilderBase::acymailingList() JROOT/components/com_sppagebuilder/addons/optin_form/admin.php:162
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:190
14 AddonParser::viewAddons() JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:93
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:40
10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39
8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26
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:203
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: 12.96 ms Query memory: 0.025 MB Memory before query: 15.832 MB Rows returned: 0
Duplicate queries: #22 #23 #24
SELECT a.enabled
  FROM `jos_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 226 Using where
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.02 ms
Optimizing 0.02 ms
Statistics 0.02 ms
Preparing 0.02 ms
Executing 0.02 ms
Sending data 0.11 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 0.02 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740
18 JDatabaseDriver->loadResult() JROOT/components/com_sppagebuilder/addons/articles/site.php:248
17 SppagebuilderAddonArticles::isComponentInstalled() JROOT/components/com_sppagebuilder/addons/articles/site.php:54
16 SppagebuilderAddonArticles->render() JROOT/components/com_sppagebuilder/parser/addon-parser.php:424
15 AddonParser::getAddonHtmlView() JROOT/components/com_sppagebuilder/parser/addon-parser.php:266
14 AddonParser::viewAddons() JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:93
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:40
10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39
8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26
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:203
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.07 ms After last query: 0.83 ms Query memory: 0.026 MB Memory before query: 15.935 MB Rows returned: 0
SELECT *
  FROM `jos_categories`
  WHERE `extension` = 'com_content'
  AND `published` = '1'
  AND `access` IN (1,1,5)
  AND `language` IN ('en-GB', '*')
  AND `parent_id` IN (33)
  ORDER BY `lft` ASC
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE jos_categories ref cat_idx,idx_access,idx_language cat_idx 203 const,const 39 Using index condition; Using where; Using filesort
Profile
Status Duration
Starting 0.04 ms
Checking permissions 0.02 ms
Opening tables 0.27 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.07 ms
Preparing 0.03 ms
Sorting result 0.02 ms
Executing 0.02 ms
Sending data 0.03 ms
Creating sort index 0.21 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 0.02 ms
Closing tables 0.03 ms
Unlocking tables 0.02 ms
Closing tables 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/components/com_sppagebuilder/helpers/articles.php:351
18 SppagebuilderHelperArticles::getCategories() JROOT/components/com_sppagebuilder/helpers/articles.php:48
17 SppagebuilderHelperArticles::getArticles() JROOT/components/com_sppagebuilder/addons/articles/site.php:69
16 SppagebuilderAddonArticles->render() JROOT/components/com_sppagebuilder/parser/addon-parser.php:424
15 AddonParser::getAddonHtmlView() JROOT/components/com_sppagebuilder/parser/addon-parser.php:266
14 AddonParser::viewAddons() JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:93
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:40
10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39
8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26
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:203
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.28 ms After last query: 0.09 ms Query memory: 0.066 MB Memory before query: 15.943 MB Rows returned: 2
SELECT a.*,`b`.`alias` AS `category_alias`,`b`.`title` AS `category`
  FROM `jos_content` AS `a`
  LEFT JOIN `jos_categories` AS `b`
  ON (`a`.`catid` = `b`.`id`)
  WHERE `b`.`extension` = 'com_content'
  AND `a`.`state` = '1'
  AND `a`.`catid` IN (33)
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-12-04 21:11:51')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-12-04 21:11:51')
  AND `a`.`access` IN (1,1,5)
  ORDER BY `a`.`publish_up` DESC,`a`.`created` DESC
  LIMIT 8
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE b const PRIMARY,cat_idx PRIMARY 4 const 1
1 SIMPLE a ref idx_access,idx_state,idx_catid idx_catid 4 const 2 Using where; Using filesort
Profile
Status Duration
Starting 0.08 ms
Checking permissions 0.02 ms
Opening tables 0.33 ms
After opening tables 0.03 ms
System lock 0.02 ms
Table lock 0.02 ms
Init 0.09 ms
Optimizing 0.05 ms
Statistics 0.12 ms
Preparing 0.02 ms
Unlocking tables 0.02 ms
Preparing 0.04 ms
Sorting result 0.02 ms
Executing 0.02 ms
Sending data 0.03 ms
Creating sort index 0.14 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 0.03 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 0.03 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/components/com_sppagebuilder/helpers/articles.php:101
17 SppagebuilderHelperArticles::getArticles() JROOT/components/com_sppagebuilder/addons/articles/site.php:69
16 SppagebuilderAddonArticles->render() JROOT/components/com_sppagebuilder/parser/addon-parser.php:424
15 AddonParser::getAddonHtmlView() JROOT/components/com_sppagebuilder/parser/addon-parser.php:266
14 AddonParser::viewAddons() JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:93
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:40
10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39
8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26
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:203
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.01 ms After last query: 0.89 ms Query memory: 0.031 MB Memory before query: 16.064 MB Rows returned: 16
SHOW FULL COLUMNS
  FROM `jos_users`
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jos_users`
Profile
Status Duration
Starting 0.08 ms
Checking permissions 0.02 ms
Closing tables 0.02 ms
Opening tables 0.19 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.02 ms
Preparing 0.02 ms
Executing 0.02 ms
Filling schema table 0.02 ms
Opening tables 0.03 ms
After opening tables 0.02 ms
Checking permissions 0.10 ms
Closing tables 0.02 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
Closing tables 0.02 ms
Removing tmp table 0.07 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
29 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
28 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448
27 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245
26 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164
25 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/User.php:41
24 Joomla\CMS\Table\User->__construct() JROOT/libraries/src/Table/Table.php:312
23 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/User/User.php:603
22 Joomla\CMS\User\User::getTable() JROOT/libraries/src/User/User.php:877
21 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248
20 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301
19 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266
18 Joomla\CMS\Factory::getUser() JROOT/components/com_sppagebuilder/helpers/articles.php:106
17 SppagebuilderHelperArticles::getArticles() JROOT/components/com_sppagebuilder/addons/articles/site.php:69
16 SppagebuilderAddonArticles->render() JROOT/components/com_sppagebuilder/parser/addon-parser.php:424
15 AddonParser::getAddonHtmlView() JROOT/components/com_sppagebuilder/parser/addon-parser.php:266
14 AddonParser::viewAddons() JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:93
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:40
10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39
8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26
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:203
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.51 ms After last query: 0.08 ms Query memory: 0.027 MB Memory before query: 16.095 MB Rows returned: 1
SELECT *
  FROM `jos_users`
  WHERE `id` = 800
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE jos_users const PRIMARY PRIMARY 4 const 1
Profile
Status Duration
Starting 0.03 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.02 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
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465
23 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:87
22 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880
21 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248
20 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301
19 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266
18 Joomla\CMS\Factory::getUser() JROOT/components/com_sppagebuilder/helpers/articles.php:106
17 SppagebuilderHelperArticles::getArticles() JROOT/components/com_sppagebuilder/addons/articles/site.php:69
16 SppagebuilderAddonArticles->render() JROOT/components/com_sppagebuilder/parser/addon-parser.php:424
15 AddonParser::getAddonHtmlView() JROOT/components/com_sppagebuilder/parser/addon-parser.php:266
14 AddonParser::viewAddons() JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:93
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:40
10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39
8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26
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:203
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.75 ms After last query: 2.54 ms Query memory: 0.027 MB Memory before query: 16.857 MB Rows returned: 5
SELECT `g`.`id`,`g`.`title`
  FROM `jos_usergroups` AS g
  INNER JOIN `jos_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 800
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE m ref PRIMARY PRIMARY 4 const 5 Using index
1 SIMPLE g eq_ref PRIMARY PRIMARY 4 i5353153_jos3.m.group_id 1
Profile
Status Duration
Starting 0.04 ms
Checking permissions 0.02 ms
Opening tables 0.23 ms
After opening tables 0.03 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.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
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506
23 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Table/User.php:112
22 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880
21 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248
20 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301
19 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266
18 Joomla\CMS\Factory::getUser() JROOT/components/com_sppagebuilder/helpers/articles.php:106
17 SppagebuilderHelperArticles::getArticles() JROOT/components/com_sppagebuilder/addons/articles/site.php:69
16 SppagebuilderAddonArticles->render() JROOT/components/com_sppagebuilder/parser/addon-parser.php:424
15 AddonParser::getAddonHtmlView() JROOT/components/com_sppagebuilder/parser/addon-parser.php:266
14 AddonParser::viewAddons() JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:93
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:40
10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39
8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26
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:203
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.85 ms After last query: 0.73 ms Query memory: 0.031 MB Memory before query: 16.917 MB Rows returned: 3
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 `jos_categories` AS `s`
  INNER JOIN `jos_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 = 33
  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 58 Using where; Using filesort
Profile
Status Duration
Starting 0.09 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.05 ms
Optimizing 0.03 ms
Statistics 0.09 ms
Preparing 0.02 ms
Unlocking tables 0.02 ms
Preparing 0.03 ms
Sorting result 0.02 ms
Executing 0.02 ms
Sending data 0.03 ms
Creating sort index 0.10 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 0.02 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
31 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
30 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324
29 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184
28 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72
27 ContentRouter->getCategorySegment() Same as call in the line below.
26 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120
25 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
24 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222
23 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676
22 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266
21 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155
20 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144
19 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93
18 Joomla\CMS\Router\Route::_() JROOT/components/com_sppagebuilder/helpers/articles.php:107
17 SppagebuilderHelperArticles::getArticles() JROOT/components/com_sppagebuilder/addons/articles/site.php:69
16 SppagebuilderAddonArticles->render() JROOT/components/com_sppagebuilder/parser/addon-parser.php:424
15 AddonParser::getAddonHtmlView() JROOT/components/com_sppagebuilder/parser/addon-parser.php:266
14 AddonParser::viewAddons() JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:93
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:40
10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39
8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26
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:203
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.49 ms After last query: 0.52 ms Query memory: 0.029 MB Memory before query: 16.985 MB Rows returned: 1
SELECT *
  FROM `jos_users`
  WHERE `id` = 797
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE jos_users const PRIMARY PRIMARY 4 const 1
Profile
Status Duration
Starting 0.03 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.02 ms
Statistics 0.03 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
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465
23 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:87
22 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880
21 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248
20 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301
19 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266
18 Joomla\CMS\Factory::getUser() JROOT/components/com_sppagebuilder/helpers/articles.php:106
17 SppagebuilderHelperArticles::getArticles() JROOT/components/com_sppagebuilder/addons/articles/site.php:69
16 SppagebuilderAddonArticles->render() JROOT/components/com_sppagebuilder/parser/addon-parser.php:424
15 AddonParser::getAddonHtmlView() JROOT/components/com_sppagebuilder/parser/addon-parser.php:266
14 AddonParser::viewAddons() JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:93
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:40
10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39
8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26
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:203
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.48 ms After last query: 0.07 ms Query memory: 0.027 MB Memory before query: 17.000 MB Rows returned: 4
SELECT `g`.`id`,`g`.`title`
  FROM `jos_usergroups` AS g
  INNER JOIN `jos_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 797
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE m ref PRIMARY PRIMARY 4 const 4 Using index
1 SIMPLE g eq_ref PRIMARY PRIMARY 4 i5353153_jos3.m.group_id 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.02 ms
Optimizing 0.03 ms
Statistics 0.04 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
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506
23 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Table/User.php:112
22 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880
21 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248
20 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301
19 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266
18 Joomla\CMS\Factory::getUser() JROOT/components/com_sppagebuilder/helpers/articles.php:106
17 SppagebuilderHelperArticles::getArticles() JROOT/components/com_sppagebuilder/addons/articles/site.php:69
16 SppagebuilderAddonArticles->render() JROOT/components/com_sppagebuilder/parser/addon-parser.php:424
15 AddonParser::getAddonHtmlView() JROOT/components/com_sppagebuilder/parser/addon-parser.php:266
14 AddonParser::viewAddons() JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:93
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:40
10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39
8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26
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:203
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.75 ms After last query: 2.36 ms Query memory: 0.025 MB Memory before query: 17.040 MB Rows returned: 1
SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
  FROM jos_modules AS m
  WHERE m.published = 1
  AND m.id = 146
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2022-12-04 21:11:51')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-12-04 21:11:51')
  AND m.access IN (1,1,5)
  AND m.client_id = 0
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE m const PRIMARY,published PRIMARY 4 const 1
Profile
Status Duration
Starting 0.05 ms
Checking permissions 0.02 ms
Opening tables 0.22 ms
After opening tables 0.03 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.02 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 0.02 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
18 JDatabaseDriver->loadObjectList() JROOT/components/com_sppagebuilder/addons/module/site.php:99
17 SppagebuilderAddonModule::getModules() JROOT/components/com_sppagebuilder/addons/module/site.php:28
16 SppagebuilderAddonModule->render() JROOT/components/com_sppagebuilder/parser/addon-parser.php:424
15 AddonParser::getAddonHtmlView() JROOT/components/com_sppagebuilder/parser/addon-parser.php:266
14 AddonParser::viewAddons() JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:93
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:40
10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39
8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26
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:203
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.73 ms After last query: 6.52 ms Query memory: 0.029 MB Memory before query: 17.180 MB Rows returned: 41
SELECT `id`,`name`,`rules`,`parent_id`
  FROM `jos_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 jos_assets ALL idx_asset_name,idx_parent_id NO INDEX KEY COULD BE USED NULL NULL 303 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.02 ms
Statistics 0.05 ms
Preparing 0.02 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
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
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: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:40
10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39
8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26
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:203
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.34 ms After last query: 4.52 ms Query memory: 0.049 MB Memory before query: 17.586 MB Rows returned: 48
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM jos_modules AS m
  LEFT JOIN jos_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN jos_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 <= '2022-12-04 21:11:51')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-12-04 21:11:51')
  AND m.access IN (1,1,5)
  AND m.client_id = 0
  AND (mm.menuid = 119 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 50 Using index condition; Using where; Using filesort
1 SIMPLE mm ref PRIMARY PRIMARY 4 i5353153_jos3.m.id 1 Using where; Using index
1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 i5353153_jos3.m.module,const 1 Using index condition; Using where
Profile
Status Duration
Starting 0.07 ms
Checking permissions 0.02 ms
Opening tables 0.16 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.05 ms
Sorting result 0.02 ms
Executing 0.02 ms
Sending data 0.02 ms
Creating sort index 0.58 ms
End of update loop 0.03 ms
Query end 0.02 ms
Commit 0.02 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
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:591
12 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/plugins/system/helixultimate/core/helixultimate.php:570
11 HelixUltimate->count_modules() JROOT/plugins/system/helixultimate/core/helixultimate.php:374
10 HelixUltimate->get_current_row() JROOT/plugins/system/helixultimate/core/helixultimate.php:306
9 HelixUltimate->get_recursive_layout() JROOT/plugins/system/helixultimate/core/helixultimate.php:274
8 HelixUltimate->render_layout() JROOT/templates/shaper_helixultimate/index.php:142
7 require JROOT/templates/shaper_helixultimate/index.php JROOT/libraries/src/Document/HtmlDocument.php:668
6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730
5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545
4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1104
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:209
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: 7.43 ms Query memory: 0.022 MB Memory before query: 17.868 MB Rows returned: 5
SELECT `name`,`element`
  FROM `jos_extensions`
  WHERE `type` = 'plugin'
  AND `folder` = 'finder'
  AND `enabled` = 1
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE jos_extensions ref extension extension 82 const 120 Using index condition; 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.03 ms
Optimizing 0.03 ms
Statistics 0.04 ms
Preparing 0.03 ms
Executing 0.02 ms
Sending data 0.11 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 0.02 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_finder/helpers/language.php:126
11 FinderHelperLanguage::loadPluginLanguage() JROOT/modules/mod_finder/mod_finder.php:51
10 include JROOT/modules/mod_finder/mod_finder.php JROOT/libraries/src/Helper/ModuleHelper.php:200
9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php: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:209
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.73 ms After last query: 1.81 ms Query memory: 0.023 MB Memory before query: 18.051 MB Rows returned: 1
SELECT f.data, f.params
  FROM `jos_finder_filters` AS f
  WHERE f.filter_id = 1
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE f const PRIMARY PRIMARY 4 const 1
Profile
Status Duration
Starting 0.03 ms
Checking permissions 0.02 ms
Opening tables 0.23 ms
After opening tables 0.03 ms
System lock 0.02 ms
Table lock 0.02 ms
Init 0.02 ms
Optimizing 0.02 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.02 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 0.02 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662
14 JDatabaseDriver->loadObject() JROOT/administrator/components/com_finder/helpers/indexer/query.php:498
13 FinderIndexerQuery->processStaticTaxonomy() JROOT/administrator/components/com_finder/helpers/indexer/query.php:214
12 FinderIndexerQuery->__construct() JROOT/modules/mod_finder/helper.php:84
11 ModFinderHelper::getQuery() JROOT/modules/mod_finder/mod_finder.php:54
10 include JROOT/modules/mod_finder/mod_finder.php JROOT/libraries/src/Helper/ModuleHelper.php:200
9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php: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:209
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: 0.07 ms Query memory: 0.023 MB Memory before query: 18.061 MB Rows returned: 11
SELECT t1.id, t1.title, t2.title AS branch
  FROM `jos_finder_taxonomy` AS t1
  INNER JOIN `jos_finder_taxonomy` AS t2
  ON t2.id = t1.parent_id
  WHERE t1.state = 1
  AND t1.access IN (1,1,5)
  AND t1.id IN (19,15,21,17,5,23,18,20,28,24,22,14,3)
  AND t2.state = 1
  AND t2.access IN (1,1,5)
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 ref PRIMARY,parent_id,state,access,idx_parent_published state 1 const 13 Using index condition; Using where
1 SIMPLE t2 eq_ref PRIMARY,state,access PRIMARY 4 i5353153_jos3.t1.parent_id 1 Using where
Profile
Status Duration
Starting 0.05 ms
Checking permissions 0.02 ms
Opening tables 0.24 ms
After opening tables 0.03 ms
System lock 0.02 ms
Table lock 0.02 ms
Init 0.03 ms
Optimizing 0.03 ms
Statistics 0.12 ms
Preparing 0.03 ms
Executing 0.02 ms
Sending data 0.08 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 0.02 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_finder/helpers/indexer/query.php:553
13 FinderIndexerQuery->processStaticTaxonomy() JROOT/administrator/components/com_finder/helpers/indexer/query.php:214
12 FinderIndexerQuery->__construct() JROOT/modules/mod_finder/helper.php:84
11 ModFinderHelper::getQuery() JROOT/modules/mod_finder/mod_finder.php:54
10 include JROOT/modules/mod_finder/mod_finder.php JROOT/libraries/src/Helper/ModuleHelper.php:200
9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php: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:209
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.49 ms After last query: 0.42 ms Query memory: 0.023 MB Memory before query: 18.117 MB Rows returned: 4
SELECT `title`
  FROM `jos_finder_taxonomy`
  WHERE `parent_id` = 1
  AND `state` = 1
  AND `access` IN (1,1,5)
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE jos_finder_taxonomy ref parent_id,state,access,idx_parent_published parent_id 4 const 4 Using where
Profile
Status Duration
Starting 0.03 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.02 ms
Statistics 0.05 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
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550
15 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_finder/helpers/indexer/taxonomy.php:258
14 FinderIndexerTaxonomy::getBranchTitles() JROOT/administrator/components/com_finder/helpers/indexer/query.php:750
13 FinderIndexerQuery->processString() JROOT/administrator/components/com_finder/helpers/indexer/query.php:236
12 FinderIndexerQuery->__construct() JROOT/modules/mod_finder/helper.php:84
11 ModFinderHelper::getQuery() JROOT/modules/mod_finder/mod_finder.php:54
10 include JROOT/modules/mod_finder/mod_finder.php JROOT/libraries/src/Helper/ModuleHelper.php:200
9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php: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:209
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.56 ms After last query: 4.09 ms Query memory: 0.021 MB Memory before query: 18.397 MB Rows returned: 6
SELECT sp.id, st.name as type
  FROM `jos_creative_fields` sp JOIN `jos_creative_field_types` st
  ON st.id = sp.id_type
  WHERE sp.published = '1'
  AND sp.id_form = '3'
  ORDER BY sp.ordering,sp.id
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE sp ref id_form id_form 3 const 7 Using where; Using filesort
1 SIMPLE st eq_ref PRIMARY PRIMARY 4 i5353153_jos3.sp.id_type 1 Using index condition
Profile
Status Duration
Starting 0.05 ms
Checking permissions 0.02 ms
Opening tables 0.94 ms
After opening tables 0.05 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.03 ms
Sorting result 0.02 ms
Executing 0.02 ms
Sending data 0.02 ms
Creating sort index 0.08 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 0.02 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506
10 JDatabaseDriver->loadAssocList() JROOT/plugins/system/creativecontactform/creativecontactform.php:224
9 plgSystemCreativecontactform->ccf_get_types_array() JROOT/plugins/system/creativecontactform/creativecontactform.php:134
8 plgSystemCreativecontactform->render_styles_scripts() JROOT/plugins/system/creativecontactform/creativecontactform.php:248
7 plgSystemCreativecontactform->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:1124
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:209
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.57 ms After last query: 1.75 ms Query memory: 0.022 MB Memory before query: 18.593 MB Rows returned: 6
SELECT sp.id, st.name as type
  FROM `jos_creative_fields` sp JOIN `jos_creative_field_types` st
  ON st.id = sp.id_type
  WHERE sp.published = '1'
  AND sp.id_form = '3'
  ORDER BY sp.ordering,sp.id
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE sp ref id_form id_form 3 const 7 Using where; Using filesort
1 SIMPLE st eq_ref PRIMARY PRIMARY 4 i5353153_jos3.sp.id_type 1 Using index condition
Profile
Status Duration
Starting 0.04 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.04 ms
Preparing 0.03 ms
Sorting result 0.02 ms
Executing 0.02 ms
Sending data 0.02 ms
Creating sort index 0.06 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 0.02 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 0.03 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
13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506
12 JDatabaseDriver->loadAssocList() JROOT/components/com_creativecontactform/helpers/helper.php:229
11 CreativecontactformHelper->get_data() JROOT/components/com_creativecontactform/helpers/helper.php:729
10 CreativecontactformHelper->render_html() JROOT/plugins/system/creativecontactform/creativecontactform.php:43
9 plgSystemCreativecontactform->ccf_make_form() Same as call in the line below.
8 preg_replace_callback() JROOT/plugins/system/creativecontactform/creativecontactform.php:261
7 plgSystemCreativecontactform->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:1124
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:209
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.04 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 18.604 MB Rows returned: 1
SELECT sp.`id_template`, sp.name, sp.top_text, sp.pre_text, sp.thank_you_text, sp.send_text, sp.send_new_text, sp.close_alert_text, sp.form_width, sp.redirect, sp.redirect_itemid, sp.redirect_url, sp.redirect_delay, sp.shake_count, sp.shake_distanse, sp.send_copy_enable, sp.send_copy_text, sp.shake_duration, sp.custom_css, st.styles, sp.render_type, sp.popup_button_text, sp.static_button_position, sp.static_button_offset, sp.appear_animation_type, sp.check_token, sp.next_button_text, sp.prev_button_text
  FROM `jos_creative_forms` sp
  LEFT JOIN `jos_contact_templates` st
  ON st.id = sp.id_template
  WHERE sp.published = '1'
  AND sp.id = '3'
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE sp const PRIMARY PRIMARY 4 const 1
1 SIMPLE st const PRIMARY PRIMARY 3 const 1
Profile
Status Duration
Starting 0.05 ms
Checking permissions 0.02 ms
Opening tables 0.47 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 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
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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:1465
12 JDatabaseDriver->loadAssoc() JROOT/components/com_creativecontactform/helpers/helper.php:283
11 CreativecontactformHelper->get_data() JROOT/components/com_creativecontactform/helpers/helper.php:729
10 CreativecontactformHelper->render_html() JROOT/plugins/system/creativecontactform/creativecontactform.php:43
9 plgSystemCreativecontactform->ccf_make_form() Same as call in the line below.
8 preg_replace_callback() JROOT/plugins/system/creativecontactform/creativecontactform.php:261
7 plgSystemCreativecontactform->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:1124
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:209
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: 0.02 ms Query memory: 0.031 MB Memory before query: 18.618 MB Rows returned: 6
SELECT sp.id, sp.name, sp.tooltip_text, sp.required, sp.ordering_field, sp.select_default_text, sp.show_parent_label, sp.select_no_match_text, sp.width, sp.field_margin_top, sp.select_show_scroll_after, sp.select_show_search_after, sp.upload_button_text, sp.upload_minfilesize, sp.upload_maxfilesize, sp.upload_acceptfiletypes, sp.upload_minfilesize_message, sp.upload_maxfilesize_message, sp.upload_acceptfiletypes_message, sp.captcha_wrong_message, sp.datepicker_date_format, sp.datepicker_animation, sp.datepicker_style, sp.datepicker_icon_style, sp.datepicker_show_icon, sp.datepicker_input_readonly, sp.datepicker_number_months, sp.datepicker_mindate, sp.datepicker_maxdate, sp.datepicker_changemonths, sp.datepicker_changeyears, sp.column_type, sp.custom_html, sp.google_maps, sp.heading, sp.recaptcha_site_key, sp.recaptcha_wrong_message, sp.recaptcha_theme, sp.recaptcha_type, sp.contact_data, sp.contact_data_width, sp.creative_popup, sp.creative_popup_embed, st.name as type
  FROM `jos_creative_fields` sp JOIN `jos_creative_field_types` st
  ON st.id = sp.id_type
  WHERE sp.published = '1'
  AND sp.id_form = '3'
  ORDER BY sp.ordering,sp.id
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE sp ref id_form id_form 3 const 7 Using where; Using filesort
1 SIMPLE st eq_ref PRIMARY PRIMARY 4 i5353153_jos3.sp.id_type 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.04 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.09 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 0.02 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506
12 JDatabaseDriver->loadAssocList() JROOT/components/com_creativecontactform/helpers/helper.php:344
11 CreativecontactformHelper->get_data() JROOT/components/com_creativecontactform/helpers/helper.php:729
10 CreativecontactformHelper->render_html() JROOT/plugins/system/creativecontactform/creativecontactform.php:43
9 plgSystemCreativecontactform->ccf_make_form() Same as call in the line below.
8 preg_replace_callback() JROOT/plugins/system/creativecontactform/creativecontactform.php:261
7 plgSystemCreativecontactform->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:1124
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:209
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: 0.51 ms Query memory: 0.022 MB Memory before query: 18.660 MB Rows returned: 5
SELECT spo.name, spo.id, spo.value, spo.selected
  FROM `jos_creative_form_options` spo
  WHERE spo.id_parent = '40'
  AND spo.showrow = '1'
  ORDER BY spo.ordering
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE spo ALL NULL NO INDEX KEY COULD BE USED NULL NULL 502 Using where; Using filesort
Profile
Status Duration
Starting 0.03 ms
Checking permissions 0.02 ms
Opening tables 0.25 ms
After opening tables 0.03 ms
System lock 0.02 ms
Table lock 0.02 ms
Init 0.03 ms
Optimizing 0.02 ms
Statistics 0.02 ms
Preparing 0.02 ms
Sorting result 0.02 ms
Executing 0.02 ms
Sending data 0.02 ms
Creating sort index 0.15 ms
End of update loop 0.02 ms
Query end 0.02 ms
Commit 0.02 ms
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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
13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506
12 JDatabaseDriver->loadAssocList() JROOT/components/com_creativecontactform/helpers/helper.php:565
11 CreativecontactformHelper->print_fields_array_html() JROOT/components/com_creativecontactform/helpers/helper.php:929
10 CreativecontactformHelper->render_html() JROOT/plugins/system/creativecontactform/creativecontactform.php:43
9 plgSystemCreativecontactform->ccf_make_form() Same as call in the line below.
8 preg_replace_callback() JROOT/plugins/system/creativecontactform/creativecontactform.php:261
7 plgSystemCreativecontactform->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:1124
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:209
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.47 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 18.668 MB Rows returned: 1
SELECT sp.id, sp.recaptcha_site_key, sp.recaptcha_theme, sp.recaptcha_type
  FROM `jos_creative_fields` sp
  WHERE sp.published = '1'
  AND sp.id_type = '19'
  AND sp.id_form = '3'
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE sp ref id_form id_form 3 const 7 Using where
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.02 ms
Statistics 0.03 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
Closing tables 0.02 ms
Unlocking tables 0.02 ms
Closing tables 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:1506
11 JDatabaseDriver->loadAssocList() JROOT/components/com_creativecontactform/helpers/helper.php:1045
10 CreativecontactformHelper->render_html() JROOT/plugins/system/creativecontactform/creativecontactform.php:43
9 plgSystemCreativecontactform->ccf_make_form() Same as call in the line below.
8 preg_replace_callback() JROOT/plugins/system/creativecontactform/creativecontactform.php:261
7 plgSystemCreativecontactform->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:1124
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:209
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.]
38 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
5 × SELECT a.enabled
  FROM `jos_extensions` AS `a`
2 × SELECT *
  FROM `jos_users`
2 × SELECT `g`.`id`,`g`.`title`
  FROM `jos_usergroups` AS g
  INNER JOIN `jos_user_usergroup_map` AS m
  ON m.group_id = g.id
2 × SELECT `template`
  FROM `jos_template_styles`
2 × SELECT `id`,`name`,`rules`,`parent_id`
  FROM `jos_assets`
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
  FROM `jos_extensions`
1 × SELECT sp.`id_template`, sp.name, sp.top_text, sp.pre_text, sp.thank_you_text, sp.send_text, sp.send_new_text, sp.close_alert_text, sp.form_width, sp.redirect, sp.redirect_itemid, sp.redirect_url, sp.redirect_delay, sp.shake_count, sp.shake_distanse, sp.send_copy_enable, sp.send_copy_text, sp.shake_duration, sp.custom_css, st.styles, sp.render_type, sp.popup_button_text, sp.static_button_position, sp.static_button_offset, sp.appear_animation_type, sp.check_token, sp.next_button_text, sp.prev_button_text
  FROM `jos_creative_forms` sp
  LEFT JOIN `jos_contact_templates` st
  ON st.id = sp.id_template
1 × SELECT sp.id, st.name as type
  FROM `jos_creative_fields` sp JOIN `jos_creative_field_types` st
  ON st.id = sp.id_type
1 × SELECT sp.id, st.name as type
  FROM `jos_creative_fields` sp JOIN `jos_creative_field_types` st
  ON st.id = sp.id_type
1 × SELECT `title`
  FROM `jos_finder_taxonomy`
1 × SELECT sp.id, sp.name, sp.tooltip_text, sp.required, sp.ordering_field, sp.select_default_text, sp.show_parent_label, sp.select_no_match_text, sp.width, sp.field_margin_top, sp.select_show_scroll_after, sp.select_show_search_after, sp.upload_button_text, sp.upload_minfilesize, sp.upload_maxfilesize, sp.upload_acceptfiletypes, sp.upload_minfilesize_message, sp.upload_maxfilesize_message, sp.upload_acceptfiletypes_message, sp.captcha_wrong_message, sp.datepicker_date_format, sp.datepicker_animation, sp.datepicker_style, sp.datepicker_icon_style, sp.datepicker_show_icon, sp.datepicker_input_readonly, sp.datepicker_number_months, sp.datepicker_mindate, sp.datepicker_maxdate, sp.datepicker_changemonths, sp.datepicker_changeyears, sp.column_type, sp.custom_html, sp.google_maps, sp.heading, sp.recaptcha_site_key, sp.recaptcha_wrong_message, sp.recaptcha_theme, sp.recaptcha_type, sp.contact_data, sp.contact_data_width, sp.creative_popup, sp.creative_popup_embed, st.name as type
  FROM `jos_creative_fields` sp JOIN `jos_creative_field_types` st
  ON st.id = sp.id_type
1 × SELECT t1.id, t1.title, t2.title AS branch
  FROM `jos_finder_taxonomy` AS t1
  INNER JOIN `jos_finder_taxonomy` AS t2
  ON t2.id = t1.parent_id
1 × SELECT f.data, f.params
  FROM `jos_finder_filters` AS f
1 × SELECT spo.name, spo.id, spo.value, spo.selected
  FROM `jos_creative_form_options` spo
1 × SELECT `name`,`element`
  FROM `jos_extensions`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM jos_modules AS m
  LEFT JOIN jos_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN jos_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
1 × SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
  FROM jos_modules AS m
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 `jos_categories` AS `s`
  INNER JOIN `jos_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 `data`
  FROM `jos_session`
1 × SELECT *
  FROM `jos_categories`
1 × SELECT a.*,`b`.`alias` AS `category_alias`,`b`.`title` AS `category`
  FROM `jos_content` AS `a`
  LEFT JOIN `jos_categories` AS `b`
  ON (`a`.`catid` = `b`.`id`)
1 × SELECT `session_id`
  FROM `jos_session`
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 jos_tags
1 × SELECT `title`
  FROM `jos_sppagebuilder`
1 × SELECT *
  FROM jos_sppagebuilder
1 × SELECT a.*,l.title AS language_title,ua.name AS author_name
  FROM jos_sppagebuilder as a
  LEFT JOIN `jos_languages` AS l
  ON l.lang_code = a.language
  LEFT JOIN jos_users AS ua
  ON ua.id = a.created_by
1 × SELECT id, home, template, s.params
  FROM jos_template_styles as s
  LEFT JOIN jos_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
1 × SELECT *
  FROM jos_languages
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
  FROM jos_menu AS m
  LEFT JOIN jos_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 jos_extensions
1 × SELECT b.id
  FROM jos_usergroups AS a
  LEFT JOIN jos_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
1 × SELECT id, rules
  FROM `jos_viewlevels
1 × SELECT sp.id, sp.recaptcha_site_key, sp.recaptcha_theme, sp.recaptcha_type
  FROM `jos_creative_fields` sp
OTHER Tables:
1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
  VALUES (X'3336363830333030656437336261653136623766363836623237306239623637', 1, 1670188311, 0, '', 0
1 × UPDATE `jos_extensions`
  SET `params` = '{\"mediaversion\":\"6f49391773c0649ae1d5a47d929953bf\"}'
1 × SHOW FULL COLUMNS
  FROM `jos_sppagebuilder
1 × UPDATE jos_sppagebuilder
  SET `hits` = (`hits` + 1)
1 × SHOW FULL COLUMNS
  FROM `jos_users