devondev.mcsicloud.com
Open in
urlscan Pro
63.233.142.70
Public Scan
URL:
https://devondev.mcsicloud.com/
Submission Tags: @phishunt_io
Submission: On August 25 via api from DE
Submission Tags: @phishunt_io
Submission: On August 25 via api from DE
Form analysis 1 forms found in the DOM
POST /index.php
<form action="/index.php" method="post" id="login-form" class="form-inline">
<div class="userdata">
<div id="form-login-username" class="control-group">
<div class="controls">
<div class="input-prepend">
<span class="add-on">
<span class="icon-user hasTooltip" title="" data-original-title="Username"></span>
<label for="modlgn-username" class="element-invisible">Username</label>
</span>
<input id="modlgn-username" type="text" name="username" class="input-small" tabindex="0" size="18" placeholder="Username">
</div>
</div>
</div>
<div id="form-login-password" class="control-group">
<div class="controls">
<div class="input-prepend">
<span class="add-on">
<span class="icon-lock hasTooltip" title="" data-original-title="Password">
</span>
<label for="modlgn-passwd" class="element-invisible">Password </label>
</span>
<input id="modlgn-passwd" type="password" name="password" class="input-small" tabindex="0" size="18" placeholder="Password">
</div>
</div>
</div>
<div id="form-login-remember" class="control-group checkbox">
<label for="modlgn-remember" class="control-label">Remember Me</label> <input id="modlgn-remember" type="checkbox" name="remember" class="inputbox" value="yes">
</div>
<div id="form-login-submit" class="control-group">
<div class="controls">
<button type="submit" tabindex="0" name="Submit" class="btn btn-primary login-button">Log in</button>
</div>
</div>
<ul class="unstyled">
<li>
<a href="/index.php/component/users/?view=registration&Itemid=101">
Create an account <span class="icon-arrow-right"></span></a>
</li>
<li>
<a href="/index.php/component/users/?view=remind&Itemid=101">
Forgot your username?</a>
</li>
<li>
<a href="/index.php/component/users/?view=reset&Itemid=101">
Forgot your password?</a>
</li>
</ul>
<input type="hidden" name="option" value="com_users">
<input type="hidden" name="task" value="user.login">
<input type="hidden" name="return" value="aHR0cHM6Ly9kZXZvbmRldi5tY3NpY2xvdWQuY29tLw==">
<input type="hidden" name="00f0947b311dd9832230f9539af5e2dd" value="1">
</div>
</form>Text Content
Devon's Joomla Dev
HOME
* You are here:
* Home
MAIN MENU
* Home
* Contract
* View Contract
LOGIN FORM
Username
Password
Remember Me
Log in
* Create an account
* Forgot your username?
* Forgot your password?
--------------------------------------------------------------------------------
Back to Top
© 2021 Devon's Joomla Dev
JOOMLA! DEBUG CONSOLE
SESSION
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1629851161,
"last": 1629851161,
"now": 1629851161
},
"client": {
"forwarded": "82.102.18.114"
},
"token": "wB0C27gOn4Fppsa5CpIuUWckw3l4HXQR"
},
"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: 22.10 ms / 22.10 ms Memory: 1.830 MB / 2.21 MB Application: afterLoad
Time: 61.91 ms / 84.01 ms Memory: 4.912 MB / 7.12 MB Application:
afterInitialise
Time: 17.62 ms / 101.63 ms Memory: 1.088 MB / 8.21 MB Application: afterRoute
Time: 2.72 ms / 104.36 ms Memory: 0.034 MB / 8.24 MB Application:
beforeRenderComponent com_content
Time: 5.78 ms / 110.13 ms Memory: 0.612 MB / 8.86 MB Application: Before
Access::preloadComponents (all components)
Time: 2.16 ms / 112.29 ms Memory: 0.066 MB / 8.92 MB Application: After
Access::preloadComponents (all components)
Time: 0.03 ms / 112.32 ms Memory: -0.003 MB / 8.92 MB Application: Before
Access::getAssetRules (id:8 name:com_content)
Time: 0.49 ms / 112.81 ms Memory: 0.026 MB / 8.94 MB Application: After
Access::getAssetRules (id:8 name:com_content)
Time: 13.72 ms / 126.53 ms Memory: 0.841 MB / 9.79 MB Application:
afterRenderComponent com_content
Time: 1.61 ms / 128.13 ms Memory: 0.105 MB / 9.89 MB Application: afterDispatch
Time: 4.88 ms / 133.02 ms Memory: 0.166 MB / 10.06 MB Application:
beforeRenderModule mod_menu (Main Menu)
Time: 2.43 ms / 135.45 ms Memory: 0.160 MB / 10.22 MB Application:
afterRenderModule mod_menu (Main Menu)
Time: 0.03 ms / 135.48 ms Memory: -0.003 MB / 10.21 MB Application:
beforeRenderModule mod_login (Login Form)
Time: 2.97 ms / 138.44 ms Memory: 0.144 MB / 10.36 MB Application:
afterRenderModule mod_login (Login Form)
Time: 0.07 ms / 138.52 ms Memory: 0.001 MB / 10.36 MB Application:
beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 1.24 ms / 139.75 ms Memory: 0.045 MB / 10.40 MB Application:
afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 4.19 ms / 143.94 ms Memory: 0.408 MB / 10.81 MB Application: Before
Access::getAssetRules (id:1 name:root.1)
Time: 0.04 ms / 143.98 ms Memory: 0.008 MB / 10.82 MB Application: After
Access::getAssetRules (id:1 name:root.1)
Time: 2.05 ms / 146.03 ms Memory: 0.175 MB / 11.00 MB Application: afterRender
Database queries total: 23.72 ms
MEMORY USAGE
11.21 MB (11,750,096 Bytes)
DATABASE QUERIES
16 QUERIES LOGGED 23.72 MS
1. Query Time: 0.98 ms Query memory: 0.023 MB Memory before query: 3.927 MB
Rows returned: 0
SELECT `data`
FROM `jylk4_session`
WHERE `session_id` = X'6166643536626434386233393661666237333636313835303237356130353764'
Explain
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEjylk4_sessionconstPRIMARYPRIMARY194const1
Profile
StatusDurationStarting0.09 msChecking permissions0.02 msOpening
tables0.05 msAfter opening tables0.02 msSystem lock0.02 msTable
lock0.02 msInit0.05 msOptimizing0.04 msStatistics0.16 msPreparing0.02 msExecuting0.07 msEnd
of update loop0.02 msQuery end0.02 msCommit0.06 msClosing
tables0.02 msUnlocking tables0.02 msClosing tables0.03 msStarting
cleanup0.02 msFreeing items0.02 msUpdating status0.05 msReset for next
command0.02 ms
Call Stack
#CallerFile and line
number16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:174015JDatabaseDriver->loadResult()JROOT/libraries/joomla/session/storage/database.php:4514JSessionStorageDatabase->read()Same
as call in the line
below.13session_start()JROOT/libraries/joomla/session/handler/native.php:26012JSessionHandlerNative->doSessionStart()JROOT/libraries/joomla/session/handler/native.php:5011JSessionHandlerNative->start()JROOT/libraries/joomla/session/handler/joomla.php:8810JSessionHandlerJoomla->start()JROOT/libraries/src/Session/Session.php:6609Joomla\CMS\Session\Session->_start()JROOT/libraries/src/Session/Session.php:6208Joomla\CMS\Session\Session->start()JROOT/libraries/src/Session/Session.php:4987Joomla\CMS\Session\Session->get()JROOT/libraries/src/Session/Session.php:4556Joomla\CMS\Session\Session->isNew()JROOT/libraries/src/Application/CMSApplication.php:8325Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:1364Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:663Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:3922Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:1401Joomla\CMS\Factory::getApplication()JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links
for files.]
--------------------------------------------------------------------------------
2. Query Time: 0.79 ms After last query: 1.25 ms Query memory: 0.020 MB Memory
before query: 4.085 MB Rows returned: 0
SELECT `session_id`
FROM `jylk4_session`
WHERE `session_id` = X'6166643536626434386233393661666237333636313835303237356130353764'
LIMIT 1
Explain
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEjylk4_sessionconstPRIMARYPRIMARY194const1Using index
Profile
StatusDurationStarting0.08 msChecking permissions0.02 msOpening
tables0.03 msAfter opening tables0.02 msSystem lock0.02 msTable
lock0.02 msInit0.04 msOptimizing0.03 msStatistics0.07 msPreparing0.02 msExecuting0.10 msEnd
of update loop0.02 msQuery end0.02 msCommit0.02 msClosing
tables0.02 msUnlocking tables0.02 msClosing tables0.03 msStarting
cleanup0.02 msFreeing items0.02 msUpdating status0.05 msReset for next
command0.02 ms
Call Stack
#CallerFile and line
number9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:17408JDatabaseDriver->loadResult()JROOT/libraries/src/Session/MetadataManager.php:747Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:1546Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:8345Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:1364Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:663Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:3922Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:1401Joomla\CMS\Factory::getApplication()JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links
for files.]
--------------------------------------------------------------------------------
3. Query Time: 2.21 ms After last query: 0.09 ms Query memory: 0.004 MB Memory
before query: 4.091 MB
INSERT INTO `jylk4_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'6166643536626434386233393661666237333636313835303237356130353764', 1, 1629851161, 0, '', 0)
Explain
EXPLAIN not possible on query: INSERT INTO `jylk4_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'6166643536626434386233393661666237333636313835303237356130353764', 1,
1629851161, 0, '', 0)
Profile
StatusDurationStarting0.07 msChecking permissions0.02 msOpening
tables0.03 msAfter opening tables0.02 msSystem lock0.02 msTable
lock0.02 msInit for update0.03 msUpdate0.17 msEnd of update
loop0.02 msQuery end0.02 msCommit1.61 msClosing tables0.03 msUnlocking
tables0.01 msClosing tables0.02 msStarting cleanup0.01 msFreeing
items0.02 msUpdating status0.04 msReset for next command0.01 ms
Call Stack
#CallerFile and line
number8JDatabaseDriverMysqli->execute()JROOT/libraries/src/Session/MetadataManager.php:1167Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:1546Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:8345Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:1364Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:663Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:3922Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:1401Joomla\CMS\Factory::getApplication()JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links
for files.]
--------------------------------------------------------------------------------
4. Query Time: 1.37 ms After last query: 2.66 ms Query memory: 0.025 MB Memory
before query: 4.309 MB Rows returned: 45
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jylk4_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
Explain
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEjylk4_extensionsrefextensionextension82const47Using index condition;
Using where
Profile
StatusDurationStarting0.10 msChecking permissions0.02 msOpening
tables0.04 msAfter opening tables0.02 msSystem lock0.02 msTable
lock0.02 msInit0.05 msOptimizing0.05 msStatistics0.11 msPreparing0.06 msExecuting0.02 msSending
data0.47 msEnd of update loop0.02 msQuery end0.02 msCommit0.02 msClosing
tables0.02 msUnlocking tables0.02 msClosing tables0.04 msStarting
cleanup0.02 msFreeing items0.02 msUpdating status0.05 msReset for next
command0.02 ms
Call Stack
#CallerFile and line
number12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:170111JDatabaseDriver->loadObjectList()JROOT/libraries/src/Component/ComponentHelper.php:44510Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()Same
as call in the line
below.9call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:1738Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Component/ComponentHelper.php:4537Joomla\CMS\Component\ComponentHelper::load()JROOT/libraries/src/Component/ComponentHelper.php:5196Joomla\CMS\Component\ComponentHelper::getComponents()JROOT/libraries/src/Component/ComponentHelper.php:445Joomla\CMS\Component\ComponentHelper::getComponent()JROOT/libraries/src/Component/ComponentHelper.php:1034Joomla\CMS\Component\ComponentHelper::getParams()JROOT/libraries/src/Application/SiteApplication.php:5943Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:2122Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:2031Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links
for files.]
--------------------------------------------------------------------------------
5. Query Time: 0.67 ms After last query: 1.87 ms Query memory: 0.021 MB Memory
before query: 4.506 MB Rows returned: 5
SELECT id, rules
FROM `jylk4_viewlevels`
Explain
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEjylk4_viewlevelsALLNULLNO
INDEX KEY COULD BE USEDNULLNULL5
Profile
StatusDurationStarting0.06 msChecking permissions0.02 msOpening
tables0.04 msAfter opening tables0.02 msSystem lock0.02 msTable
lock0.02 msInit0.03 msOptimizing0.02 msStatistics0.03 msPreparing0.03 msExecuting0.01 msSending
data0.09 msEnd of update loop0.02 msQuery end0.02 msCommit0.02 msClosing
tables0.02 msUnlocking tables0.04 msClosing tables0.03 msStarting
cleanup0.01 msFreeing items0.02 msUpdating status0.04 msReset for next
command0.02 ms
Call Stack
#CallerFile and line
number10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:15069JDatabaseDriver->loadAssocList()JROOT/libraries/src/Access/Access.php:10638Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:4587Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:3186Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:875Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:1294Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:6043Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:2122Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:2031Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links
for files.]
--------------------------------------------------------------------------------
6. Query Time: 0.86 ms After last query: 0.09 ms Query memory: 0.021 MB Memory
before query: 4.518 MB Rows returned: 2
SELECT b.id
FROM jylk4_usergroups AS a
LEFT JOIN jylk4_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
Explain
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEaconstPRIMARYPRIMARY4const11SIMPLEbindexidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup8NULL9Using where;
Using index
Profile
StatusDurationStarting0.11 msChecking permissions0.02 msOpening
tables0.03 msAfter opening tables0.03 msSystem lock0.02 msTable
lock0.02 msInit0.04 msOptimizing0.04 msStatistics0.10 msPreparing0.02 msUnlocking
tables0.02 msPreparing0.05 msExecuting0.01 msSending data0.08 msEnd of
update loop0.02 msQuery end0.02 msCommit0.02 msClosing
tables0.02 msUnlocking tables0.02 msClosing tables0.02 msStarting
cleanup0.03 msFreeing items0.02 msUpdating status0.04 msReset for next
command0.02 ms
Call Stack
#CallerFile and line
number11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:155010JDatabaseDriver->loadColumn()JROOT/libraries/src/Access/Access.php:9809Joomla\CMS\Access\Access::getGroupsByUser()JROOT/libraries/src/Access/Access.php:10958Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:4587Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:3186Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:875Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:1294Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:6043Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:2122Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:2031Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links
for files.]
--------------------------------------------------------------------------------
7. Query Time: 2.21 ms After last query: 0.62 ms Query memory: 0.030 MB Memory
before query: 4.587 MB Rows returned: 110
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jylk4_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
Explain
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEjylk4_extensionsrefextensionextension82const151Using index condition;
Using where; Using filesort
Profile
StatusDurationStarting0.09 msChecking permissions0.02 msOpening
tables0.03 msAfter opening tables0.02 msSystem lock0.02 msTable
lock0.02 msInit0.09 msOptimizing0.04 msStatistics0.09 msPreparing0.06 msSorting
result0.03 msExecuting0.02 msSending data0.03 msCreating sort
index1.38 msEnd of update loop0.02 msQuery end0.02 msCommit0.03 msClosing
tables0.02 msUnlocking tables0.02 msClosing tables0.03 msStarting
cleanup0.02 msFreeing items0.02 msUpdating status0.05 msReset for next
command0.02 ms
Call Stack
#CallerFile and line
number11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:170110JDatabaseDriver->loadObjectList()JROOT/libraries/src/Plugin/PluginHelper.php:3519Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()Same
as call in the line
below.8call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:1737Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Plugin/PluginHelper.php:3566Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:875Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:1294Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:6043Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:2122Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:2031Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links
for files.]
--------------------------------------------------------------------------------
8. Query Time: 1.39 ms After last query: 26.56 ms Query memory: 0.026 MB
Memory before query: 7.310 MB Rows returned: 4
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 jylk4_menu AS m
LEFT JOIN jylk4_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
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEmrangeidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language5NULL12Using index condition;
Using where; Using
filesort1SIMPLEeeq_refPRIMARYPRIMARY4mcsicloud_DevonDev.m.component_id1Using where
Profile
StatusDurationStarting0.16 msChecking permissions0.02 msOpening
tables0.06 msAfter opening tables0.02 msSystem lock0.02 msTable
lock0.02 msInit0.11 msOptimizing0.05 msStatistics0.12 msPreparing0.06 msSorting
result0.03 msExecuting0.02 msSending data0.04 msCreating sort
index0.27 msEnd of update loop0.02 msQuery end0.01 msCommit0.02 msClosing
tables0.02 msUnlocking tables0.01 msClosing tables0.03 msStarting
cleanup0.02 msFreeing items0.03 msUpdating status0.06 msReset for next
command0.02 ms
Call Stack
#CallerFile and line
number19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:170118JDatabaseDriver->loadObjectList()JROOT/libraries/src/Menu/SiteMenu.php:9317Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()Same
as call in the line
below.16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:17315Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Menu/SiteMenu.php:10114Joomla\CMS\Menu\SiteMenu->load()JROOT/libraries/src/Menu/AbstractMenu.php:7813Joomla\CMS\Menu\AbstractMenu->__construct()JROOT/libraries/src/Menu/SiteMenu.php:6212Joomla\CMS\Menu\SiteMenu->__construct()JROOT/libraries/src/Menu/AbstractMenu.php:14211Joomla\CMS\Menu\AbstractMenu::getInstance()JROOT/libraries/src/Application/CMSApplication.php:42310Joomla\CMS\Application\CMSApplication->getMenu()JROOT/libraries/src/Application/SiteApplication.php:2759Joomla\CMS\Application\SiteApplication->getMenu()JROOT/libraries/src/Router/SiteRouter.php:658Joomla\CMS\Router\SiteRouter->__construct()JROOT/libraries/src/Router/Router.php:1897Joomla\CMS\Router\Router::getInstance()JROOT/libraries/src/Application/CMSApplication.php:5396Joomla\CMS\Application\CMSApplication::getRouter()JROOT/libraries/src/Application/SiteApplication.php:4035Joomla\CMS\Application\SiteApplication::getRouter()JROOT/libraries/src/Application/CMSApplication.php:11474Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:7963Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:2182Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:2031Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links
for files.]
--------------------------------------------------------------------------------
9. Query Time: 0.99 ms After last query: 8.07 ms Query memory: 0.025 MB Memory
before query: 7.965 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jylk4_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
Explain
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEjylk4_extensionsrefelement_clientid,element_folder_clientid,extensionextension484const,const1Using index condition
Profile
StatusDurationStarting0.09 msChecking permissions0.02 msOpening
tables0.04 msAfter opening tables0.02 msSystem lock0.02 msTable
lock0.02 msInit0.05 msOptimizing0.08 msStatistics0.15 msPreparing0.05 msExecuting0.02 msSending
data0.12 msEnd of update loop0.02 msQuery end0.01 msCommit0.02 msClosing
tables0.02 msUnlocking tables0.01 msClosing tables0.03 msStarting
cleanup0.02 msFreeing items0.03 msUpdating status0.06 msReset for next
command0.02 ms
Call Stack
#CallerFile and line
number21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:166220JDatabaseDriver->loadObject()JROOT/libraries/src/Helper/LibraryHelper.php:16719Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()Same
as call in the line
below.18call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:17317Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/LibraryHelper.php:17516Joomla\CMS\Helper\LibraryHelper::loadLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:4315Joomla\CMS\Helper\LibraryHelper::getLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:9014Joomla\CMS\Helper\LibraryHelper::getParams()JROOT/libraries/src/Version.php:32113Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:77812Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:23411Joomla\CMS\Factory::getDocument()JROOT/plugins/system/nrframework/NRFramework/Functions.php:22410NRFramework\Functions::isFeed()JROOT/plugins/system/convertforms/convertforms.php:4379PlgSystemConvertForms->getHelper()JROOT/plugins/system/convertforms/convertforms.php:988PlgSystemConvertForms->onAfterRoute()JROOT/libraries/joomla/event/event.php:707JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:1606JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:1085Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:11964Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:7963Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:2182Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:2031Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links
for files.]
--------------------------------------------------------------------------------
10. Query Time: 2.65 ms After last query: 0.18 ms Query memory: 0.007 MB Memory
before query: 7.959 MB
UPDATE `jylk4_extensions`
SET `params` = '{\"mediaversion\":\"300d2f7c91846bed0bedaa207bab172a\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
Explain
EXPLAIN not possible on query: UPDATE `jylk4_extensions` SET `params` =
'{\"mediaversion\":\"300d2f7c91846bed0bedaa207bab172a\"}' WHERE `type` =
'library' AND `element` = 'joomla'
Profile
StatusDurationStarting0.07 msChecking permissions0.02 msOpening
tables0.03 msAfter opening tables0.02 msSystem lock0.02 msTable
lock0.02 msInit for update0.14 msUpdating0.23 msEnd of update
loop0.02 msQuery end0.01 msCommit1.87 msClosing tables0.03 msUnlocking
tables0.02 msClosing tables0.03 msStarting cleanup0.01 msFreeing
items0.02 msUpdating status0.05 msReset for next command0.02 ms
Call Stack
#CallerFile and line
number16JDatabaseDriverMysqli->execute()JROOT/libraries/src/Helper/LibraryHelper.php:11715Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:37214Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:33113Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:77812Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:23411Joomla\CMS\Factory::getDocument()JROOT/plugins/system/nrframework/NRFramework/Functions.php:22410NRFramework\Functions::isFeed()JROOT/plugins/system/convertforms/convertforms.php:4379PlgSystemConvertForms->getHelper()JROOT/plugins/system/convertforms/convertforms.php:988PlgSystemConvertForms->onAfterRoute()JROOT/libraries/joomla/event/event.php:707JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:1606JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:1085Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:11964Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:7963Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:2182Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:2031Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links
for files.]
--------------------------------------------------------------------------------
11. Query Time: 0.95 ms After last query: 2.58 ms Query memory: 0.019 MB Memory
before query: 8.224 MB Rows returned: 1
SELECT *
FROM jylk4_languages
WHERE published=1
ORDER BY ordering ASC
Explain
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEjylk4_languagesALLNULLNO
INDEX KEY COULD BE USEDNULLNULL1Using where; Using filesort
Profile
StatusDurationStarting0.08 msChecking permissions0.02 msOpening
tables0.04 msAfter opening tables0.02 msSystem lock0.02 msTable
lock0.02 msInit0.05 msOptimizing0.03 msStatistics0.03 msPreparing0.04 msSorting
result0.02 msExecuting0.01 msSending data0.04 msCreating sort
index0.18 msEnd of update loop0.02 msQuery end0.01 msCommit0.02 msClosing
tables0.02 msUnlocking tables0.01 msClosing tables0.03 msStarting
cleanup0.01 msFreeing items0.02 msUpdating status0.05 msReset for next
command0.02 ms
Call Stack
#CallerFile and line
number7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:17016JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/LanguageHelper.php:1505Joomla\CMS\Language\LanguageHelper::getLanguages()JROOT/libraries/src/Application/SiteApplication.php:3304Joomla\CMS\Application\SiteApplication->getParams()JROOT/libraries/src/Application/SiteApplication.php:1383Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:2332Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:2031Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links
for files.]
--------------------------------------------------------------------------------
12. Query Time: 1.04 ms After last query: 0.24 ms Query memory: 0.019 MB Memory
before query: 8.237 MB Rows returned: 3
SELECT id, home, template, s.params
FROM jylk4_template_styles as s
LEFT JOIN jylk4_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
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEsALLidx_template,idx_client_id,idx_client_id_homeNO
INDEX KEY COULD BE
USEDNULLNULL6Using where1SIMPLEerefelement_clientid,element_folder_clientid,extensionelement_clientid403mcsicloud_DevonDev.s.template,const1Using index condition;
Using where
Profile
StatusDurationStarting0.09 msChecking permissions0.02 msOpening
tables0.04 msAfter opening tables0.02 msSystem lock0.02 msTable
lock0.02 msInit0.05 msOptimizing0.05 msStatistics0.19 msPreparing0.06 msExecuting0.02 msSending
data0.20 msEnd of update loop0.02 msQuery end0.02 msCommit0.02 msClosing
tables0.02 msUnlocking tables0.02 msClosing tables0.03 msStarting
cleanup0.02 msFreeing items0.02 msUpdating status0.04 msReset for next
command0.02 ms
Call Stack
#CallerFile and line
number6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:17015JDatabaseDriver->loadObjectList()JROOT/libraries/src/Application/SiteApplication.php:4864Joomla\CMS\Application\SiteApplication->getTemplate()JROOT/libraries/src/Application/SiteApplication.php:1683Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:2332Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:2031Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links
for files.]
--------------------------------------------------------------------------------
13. Query Time: 1.99 ms After last query: 6.21 ms Query memory: 0.029 MB Memory
before query: 8.860 MB Rows returned: 45
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jylk4_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_componentbuilder','com_config','com_contact','com_content','com_contenthistory','com_contractitsytem','com_convertforms','com_cpanel','com_fields','com_finder','com_helloworld','com_installer','com_itcontractsystem','com_joomlaupdate','com_languages','com_login','com_mailto','com_manageditsytem','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocapdf','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_tcpdf','com_templates','com_testsystem','com_testtwo','com_users','com_wrapper')
Explain
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEjylk4_assetsALLidx_asset_nameNO
INDEX KEY COULD BE USEDNULLNULL142Using where
Profile
StatusDurationStarting0.16 msChecking permissions0.02 msOpening
tables0.04 msAfter opening tables0.02 msSystem lock0.02 msTable
lock0.02 msInit0.15 msOptimizing0.03 msStatistics0.31 msPreparing0.04 msExecuting0.01 msSending
data0.83 msEnd of update loop0.02 msQuery end0.01 msCommit0.02 msClosing
tables0.01 msUnlocking tables0.01 msClosing tables0.03 msStarting
cleanup0.01 msFreeing items0.02 msUpdating status0.05 msReset for next
command0.02 ms
Call Stack
#CallerFile and line
number21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:170120JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:42919Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:21318Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:53117Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:18316Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:39815Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/articles.php:11514ContentModelArticles->populateState()JROOT/components/com_content/models/featured.php:4513ContentModelFeatured->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:44012Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/libraries/src/MVC/View/HtmlView.php:42511Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:5510ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:6729Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:1188ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:7107Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:436require_once
JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:4025Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:3774Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:1943Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:2332Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:2031Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links
for files.]
--------------------------------------------------------------------------------
14. Query Time: 3.03 ms After last query: 1.46 ms Query memory: 0.024 MB Memory
before query: 9.002 MB Rows returned: 0
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
FROM jylk4_content AS a
INNER JOIN jylk4_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN jylk4_categories AS c
ON c.id = a.catid
LEFT JOIN jylk4_users AS ua
ON ua.id = a.created_by
LEFT JOIN jylk4_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jylk4_categories as parent
ON parent.id = c.parent_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-08-25 00:26:01')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-08-25 00:26:01')
ORDER BY c.lft, a.featured DESC, fp.ordering,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC
LIMIT 4
Explain
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEfpALLPRIMARYNO
INDEX KEY COULD BE USEDNULLNULL1Using temporary; Using
filesort1SIMPLEaeq_refPRIMARY,idx_access,idx_state,idx_catidPRIMARY4mcsicloud_DevonDev.fp.content_id1Using where1SIMPLEuaeq_refPRIMARYPRIMARY4mcsicloud_DevonDev.a.created_by1Using where1SIMPLEuameq_refPRIMARYPRIMARY4mcsicloud_DevonDev.a.modified_by1Using where1SIMPLEceq_refPRIMARY,idx_accessPRIMARY4mcsicloud_DevonDev.a.catid1Using where1SIMPLEparenteq_refPRIMARYPRIMARY4mcsicloud_DevonDev.c.parent_id1Using where
Profile
StatusDurationStarting0.35 msChecking permissions0.02 msOpening
tables0.09 msAfter opening tables0.02 msSystem lock0.02 msTable
lock0.02 msInit0.22 msOptimizing0.10 msStatistics0.17 msPreparing0.09 msCreating
tmp table0.14 msSorting result0.03 msExecuting0.01 msSending
data1.03 msCreating sort index0.07 msRemoving tmp table0.16 msCreating sort
index0.06 msEnd of update loop0.02 msQuery end0.03 msCommit0.02 msClosing
tables0.02 msUnlocking tables0.02 msClosing tables0.03 msStarting
cleanup0.01 msFreeing items0.04 msUpdating status0.05 msReset for next
command0.02 ms
Call Stack
#CallerFile and line
number17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:170116JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:30815Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:18714Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:57613ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:12612ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:42511Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:5610ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:6729Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:1188ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:7107Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:436require_once
JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:4025Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:3774Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:1943Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:2332Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:2031Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links
for files.]
--------------------------------------------------------------------------------
15. Query Time: 1.14 ms After last query: 1.11 ms Query memory: 0.023 MB Memory
before query: 9.102 MB Rows returned: 1
SELECT COUNT(*)
FROM jylk4_content AS a
INNER JOIN jylk4_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN jylk4_categories AS c
ON c.id = a.catid
LEFT JOIN jylk4_users AS ua
ON ua.id = a.created_by
LEFT JOIN jylk4_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jylk4_categories as parent
ON parent.id = c.parent_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-08-25 00:26:01')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-08-25 00:26:01')
Explain
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEfpindexPRIMARYPRIMARY4NULL1Using index1SIMPLEaeq_refPRIMARY,idx_access,idx_state,idx_catidPRIMARY4mcsicloud_DevonDev.fp.content_id1Using where1SIMPLEceq_refPRIMARY,idx_accessPRIMARY4mcsicloud_DevonDev.a.catid1Using where
Profile
StatusDurationStarting0.16 msChecking permissions0.02 msOpening
tables0.07 msAfter opening tables0.02 msSystem lock0.02 msTable
lock0.02 msInit0.08 msOptimizing0.08 msStatistics0.21 msPreparing0.02 msUnlocking
tables0.02 msPreparing0.08 msExecuting0.02 msSending data0.07 msEnd of
update loop0.02 msQuery end0.02 msCommit0.02 msClosing
tables0.02 msUnlocking tables0.01 msClosing tables0.03 msStarting
cleanup0.01 msFreeing items0.03 msUpdating status0.05 msReset for next
command0.02 ms
Call Stack
#CallerFile and line
number16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:174015JDatabaseDriver->loadResult()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:34014Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()JROOT/libraries/src/MVC/Model/ListModel.php:28213Joomla\CMS\MVC\Model\ListModel->getTotal()JROOT/libraries/src/MVC/Model/ListModel.php:23212Joomla\CMS\MVC\Model\ListModel->getPagination()JROOT/libraries/src/MVC/View/HtmlView.php:42511Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:5710ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:6729Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:1188ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:7107Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:436require_once
JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:4025Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:3774Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:1943Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:2332Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:2031Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links
for files.]
--------------------------------------------------------------------------------
16. Query Time: 1.44 ms After last query: 11.20 ms Query memory: 0.023 MB
Memory before query: 10.020 MB Rows returned: 3
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jylk4_modules AS m
LEFT JOIN jylk4_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jylk4_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-08-25 00:26:01')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-08-25 00:26:01')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
Explain
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEmrefPRIMARY,published,newsfeedspublished1const11Using index condition;
Using where; Using
filesort1SIMPLEmmrefPRIMARYPRIMARY4mcsicloud_DevonDev.m.id1Using where;
Using index1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid403mcsicloud_DevonDev.m.module,const1Using index condition;
Using where
Profile
StatusDurationStarting0.14 msChecking permissions0.06 msOpening
tables0.05 msAfter opening tables0.02 msSystem lock0.01 msTable
lock0.02 msInit0.07 msOptimizing0.07 msStatistics0.12 msPreparing0.08 msSorting
result0.03 msExecuting0.01 msSending data0.03 msCreating sort
index0.40 msEnd of update loop0.02 msQuery end0.01 msCommit0.02 msClosing
tables0.01 msUnlocking tables0.03 msClosing tables0.03 msStarting
cleanup0.01 msFreeing items0.02 msUpdating status0.04 msReset for next
command0.02 ms
Call Stack
#CallerFile and line
number15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:170114JDatabaseDriver->loadObjectList()Same
as call in the line
below.13call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:17312Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:44111Joomla\CMS\Helper\ModuleHelper::getModuleList()JROOT/libraries/src/Helper/ModuleHelper.php:37110Joomla\CMS\Helper\ModuleHelper::load()JROOT/libraries/src/Helper/ModuleHelper.php:879Joomla\CMS\Helper\ModuleHelper::getModules()JROOT/libraries/src/Document/HtmlDocument.php:5918Joomla\CMS\Document\HtmlDocument->countModules()JROOT/templates/protostar/index.php:1007require
JROOT/templates/protostar/index.phpJROOT/libraries/src/Document/HtmlDocument.php:6686Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:7305Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:5454Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:11043Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:7782Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:2091Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links
for files.]
--------------------------------------------------------------------------------
15 QUERY TYPES LOGGED, SORTED BY OCCURRENCES.
SELECT TABLES:
1. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jylk4_extensions`
2. 1 × SELECT `data`
FROM `jylk4_session`
3. 1 × SELECT `session_id`
FROM `jylk4_session`
4. 1 × SELECT id, rules
FROM `jylk4_viewlevels
5. 1 × SELECT b.id
FROM jylk4_usergroups AS a
LEFT JOIN jylk4_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
6. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jylk4_extensions
7. 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 jylk4_menu AS m
LEFT JOIN jylk4_extensions AS e
ON m.component_id = e.extension_id
8. 1 × SELECT *
FROM jylk4_languages
9. 1 × SELECT id, home, template, s.params
FROM jylk4_template_styles as s
LEFT JOIN jylk4_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
10. 1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `jylk4_assets`
11. 1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
FROM jylk4_content AS a
INNER JOIN jylk4_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN jylk4_categories AS c
ON c.id = a.catid
LEFT JOIN jylk4_users AS ua
ON ua.id = a.created_by
LEFT JOIN jylk4_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jylk4_categories as parent
ON parent.id = c.parent_id
12. 1 × SELECT COUNT(*)
FROM jylk4_content AS a
INNER JOIN jylk4_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN jylk4_categories AS c
ON c.id = a.catid
LEFT JOIN jylk4_users AS ua
ON ua.id = a.created_by
LEFT JOIN jylk4_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jylk4_categories as parent
ON parent.id = c.parent_id
13. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jylk4_modules AS m
LEFT JOIN jylk4_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jylk4_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
OTHER TABLES:
1. 1 × INSERT INTO `jylk4_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6166643536626434386233393661666237333636313835303237356130353764', 1, 1629851161, 0, '', 0
2. 1 × UPDATE `jylk4_extensions`
SET `params` = '{\"mediaversion\":\"300d2f7c91846bed0bedaa207bab172a\"}'