IWGIA - International Work Group for Indigenous Affairs - is a global human rights organisation dedicated to promoting and defending Indigenous Peoples’ rights. Read more.
For media inquiries click here
IWGIA's global report, the Indigenous World, provides an update of the current situation for Indigenous Peoples worldwide. Read The Indigenous World.
Prinsessegade 29 B, 3rd floor
DK 1422 Copenhagen
Denmark
Phone: (+45) 53 73 28 30
E-mail: iwgia@iwgia.org
CVR: 81294410
Report possible misconduct, fraud, or corruption
![]() |
![]() |
![]() |
![]() |
If you do not change browser settings, you agree to it. Learn more
{ "__default": { "session": { "counter": 1, "timer": { "start": 1750759070, "last": 1750759070, "now": 1750759070 }, "client": { "forwarded": "216.73.216.198" }, "token": "By6PxYX2xXaKuGK0SK59d9btlbKIMRvF" }, "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 }, "plg_system_languagefilter": { "language": "en-GB" } } }
SHOW VARIABLES LIKE 'query_cache_type'
Status | Duration |
---|---|
Starting | 0.06 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.50 ms |
Preparing | 0.01 ms |
Executing | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.01 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
12 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
11 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/database/driver/pdomysql.php:604 |
10 | JDatabaseDriverPdomysql->hasQueryCacheEnabled() | JROOT/libraries/joomla/database/driver/pdomysql.php:160 |
9 | JDatabaseDriverPdomysql->connect() | JROOT/libraries/src/Filter/InputFilter.php:72 |
8 | Joomla\CMS\Filter\InputFilter->__construct() | JROOT/libraries/src/Filter/InputFilter.php:105 |
7 | Joomla\CMS\Filter\InputFilter::getInstance() | JROOT/libraries/src/Input/Input.php:64 |
6 | Joomla\CMS\Input\Input->__construct() | JROOT/libraries/src/Application/WebApplication.php:214 |
5 | Joomla\CMS\Application\WebApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:110 |
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:364 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
SHOW VARIABLES LIKE 'have_profiling'
Status | Duration |
---|---|
Starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Executing | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.05 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
12 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
11 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/database/driver/pdomysql.php:590 |
10 | JDatabaseDriverPdomysql->hasProfiling() | JROOT/libraries/joomla/database/driver/pdomysql.php:165 |
9 | JDatabaseDriverPdomysql->connect() | JROOT/libraries/src/Filter/InputFilter.php:72 |
8 | Joomla\CMS\Filter\InputFilter->__construct() | JROOT/libraries/src/Filter/InputFilter.php:105 |
7 | Joomla\CMS\Filter\InputFilter::getInstance() | JROOT/libraries/src/Input/Input.php:64 |
6 | Joomla\CMS\Input\Input->__construct() | JROOT/libraries/src/Application/WebApplication.php:214 |
5 | Joomla\CMS\Application\WebApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:110 |
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:364 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
SELECT `data`
FROM `iwgia_session`
WHERE `session_id` = X'6a663971307663756c3266683436347034726b696e7071693330'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iwgia_session | const | PRIMARY | PRIMARY | 194 | const | 1 |
Status | Duration |
---|---|
Starting | 0.05 ms |
checking permissions | 0.02 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init for update | 0.02 ms |
Update | 0.08 ms |
Waiting for query cache lock | 0.13 ms |
Update | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.71 ms |
Query end | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
16 | JDatabaseDriverPdo->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:804 |
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:364 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
SELECT `session_id`
FROM `iwgia_session`
WHERE `session_id` = X'6a663971307663756c3266683436347034726b696e7071693330'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iwgia_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
Status | Duration |
---|---|
Starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.08 ms |
Preparing | 0.03 ms |
Executing | 0.00 ms |
Sending data | 0.26 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
9 | JDatabaseDriverPdo->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:806 |
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:364 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
INSERT INTO `iwgia_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6a663971307663756c3266683436347034726b696e7071693330', 1, 1750759070, 0, '', 0)
Status | Duration |
---|---|
Starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.02 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
8 | JDatabaseDriverPdo->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:806 |
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:364 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `iwgia_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iwgia_extensions | ref | extension | extension | 82 | const | 57 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.04 ms |
Preparing | 0.00 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.02 ms |
Executing | 0.00 ms |
Sending data | 0.02 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
12 | JDatabaseDriverPdo->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 |
SELECT id, rules
FROM `iwgia_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iwgia_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 6 |
Status | Duration |
---|---|
Starting | 0.05 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.50 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
10 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:321 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT b.id
FROM iwgia_usergroups AS a
LEFT JOIN iwgia_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | Using where; Using index |
Status | Duration |
---|---|
Starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.04 ms |
Optimizing | 0.02 ms |
Statistics | 0.07 ms |
Preparing | 0.02 ms |
Executing | 0.00 ms |
Sending data | 0.04 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:321 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM iwgia_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iwgia_extensions | ALL | extension | NO INDEX KEY COULD BE USED | NULL | NULL | 340 | Using where; Using filesort |
Status | Duration |
---|---|
Starting | 0.09 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.04 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.04 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.06 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.04 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:354 |
9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Same as call in the line below. |
8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:359 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM `iwgia_nextend2_section_storage`
WHERE `application` = 'smartslider'
AND `section` = 'settings'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iwgia_nextend2_section_storage | ref | application,application_2 | application_2 | 284 | const,const | 1 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.05 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.06 ms |
Preparing | 0.02 ms |
Executing | 0.00 ms |
Sending data | 0.05 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
14 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
13 | JDatabaseDriver->loadAssoc() | JROOT/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:182 |
12 | Nextend\Framework\Database\Joomla\JoomlaConnectorTable->setQuery() | JROOT/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:56 |
11 | Nextend\Framework\Database\Joomla\JoomlaConnectorTable->findByAttributes() | JROOT/libraries/smartslider3/src/Framework/Model/ApplicationSection.php:44 |
10 | Nextend\Framework\Model\ApplicationSection->get() | JROOT/libraries/smartslider3/src/SmartSlider3/Settings.php:17 |
9 | Nextend\SmartSlider3\Settings::getAll() | JROOT/libraries/smartslider3/src/SmartSlider3/Settings.php:25 |
8 | Nextend\SmartSlider3\Settings::get() | JROOT/plugins/system/smartslider3/smartslider3.php:16 |
7 | require_once JROOT/plugins/system/smartslider3/smartslider3.php | JROOT/libraries/src/Plugin/PluginHelper.php:253 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:645 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
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 |
SELECT *
FROM iwgia_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iwgia_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | Using where; Using filesort |
Status | Duration |
---|---|
Starting | 0.07 ms |
checking permissions | 0.01 ms |
closing tables | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.40 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.00 ms |
Filling schema table | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.00 ms |
checking permissions | 0.31 ms |
closing tables | 0.01 ms |
checking permissions | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.05 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Removing tmp table | 0.13 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
10 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
8 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/plugins/system/languagefilter/languagefilter.php:96 |
7 | PlgSystemLanguageFilter->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:645 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
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 |
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `iwgia_extensions`
WHERE `type` = 'language'
AND `state` = 0
AND `enabled` = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iwgia_extensions | ref | extension | extension | 82 | const | 6 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.08 ms |
Preparing | 0.02 ms |
Executing | 0.00 ms |
Sending data | 0.03 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.01 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
10 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:209 |
8 | Joomla\CMS\Language\LanguageHelper::getInstalledLanguages() | JROOT/plugins/system/languagefilter/languagefilter.php:110 |
7 | PlgSystemLanguageFilter->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:645 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
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 |
SHOW FULL COLUMNS
FROM `iwgia_extensions`
Status | Duration |
---|---|
Starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.00 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.02 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
20 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/pdomysql.php:334 |
18 | JDatabaseDriverPdomysql->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
17 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
16 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/Extension.php:32 |
15 | Joomla\CMS\Table\Extension->__construct() | JROOT/libraries/src/Table/Table.php:312 |
14 | Joomla\CMS\Table\Table::getInstance() | JROOT/libraries/quixnxt/app/functions.php:441 |
13 | QuixAppHelper::qxGetComponentInfo() | JROOT/libraries/quixnxt/app/functions.php:57 |
12 | QuixAppHelper::setQuixConstants() | JROOT/libraries/quixnxt/app/bootstrap.php:19 |
11 | include_once JROOT/libraries/quixnxt/app/bootstrap.php | JROOT/libraries/loader.php:226 |
10 | JLoader::import() | JROOT/libraries/loader.php:845 |
9 | jimport() | JROOT/plugins/system/quix/quix.php:108 |
8 | plgSystemQuix::initQuix() | JROOT/plugins/system/quix/quix.php:101 |
7 | plgSystemQuix->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:645 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
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 |
SELECT `extension_id`
FROM `iwgia_extensions`
WHERE element = 'com_quix'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iwgia_extensions | ref | element_clientid,element_folder_clientid | element_clientid | 402 | const | 1 | Using where; Using index |
Status | Duration |
---|---|
Starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.04 ms |
Preparing | 0.02 ms |
Executing | 0.00 ms |
Sending data | 0.03 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
16 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Table/Extension.php:124 |
14 | Joomla\CMS\Table\Extension->find() | JROOT/libraries/quixnxt/app/functions.php:442 |
13 | QuixAppHelper::qxGetComponentInfo() | JROOT/libraries/quixnxt/app/functions.php:57 |
12 | QuixAppHelper::setQuixConstants() | JROOT/libraries/quixnxt/app/bootstrap.php:19 |
11 | include_once JROOT/libraries/quixnxt/app/bootstrap.php | JROOT/libraries/loader.php:226 |
10 | JLoader::import() | JROOT/libraries/loader.php:845 |
9 | jimport() | JROOT/plugins/system/quix/quix.php:108 |
8 | plgSystemQuix::initQuix() | JROOT/plugins/system/quix/quix.php:101 |
7 | plgSystemQuix->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:645 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
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 |
SELECT *
FROM iwgia_extensions
WHERE `extension_id` = '10111'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iwgia_extensions | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.09 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.08 ms |
Preparing | 0.03 ms |
Executing | 0.00 ms |
Sending data | 0.08 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
16 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
15 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
14 | Joomla\CMS\Table\Table->load() | JROOT/libraries/quixnxt/app/functions.php:443 |
13 | QuixAppHelper::qxGetComponentInfo() | JROOT/libraries/quixnxt/app/functions.php:57 |
12 | QuixAppHelper::setQuixConstants() | JROOT/libraries/quixnxt/app/bootstrap.php:19 |
11 | include_once JROOT/libraries/quixnxt/app/bootstrap.php | JROOT/libraries/loader.php:226 |
10 | JLoader::import() | JROOT/libraries/loader.php:845 |
9 | jimport() | JROOT/plugins/system/quix/quix.php:108 |
8 | plgSystemQuix::initQuix() | JROOT/plugins/system/quix/quix.php:101 |
7 | plgSystemQuix->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:645 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
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 |
SELECT template
FROM iwgia_template_styles
WHERE client_id = 0
AND home = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iwgia_template_styles | ALL | idx_client_id,idx_client_id_home | NO INDEX KEY COULD BE USED | NULL | NULL | 7 | Using where |
Status | Duration |
---|---|
Starting | 0.12 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.04 ms |
Optimizing | 0.05 ms |
Statistics | 0.08 ms |
Preparing | 0.03 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 2.48 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.03 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
15 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
14 | JDatabaseDriver->loadResult() | JROOT/libraries/quixnxt/app/functions.php:509 |
13 | QuixAppHelper::quix_default_template() | JROOT/libraries/quixnxt/app/functions.php:82 |
12 | QuixAppHelper::setQuixConstants() | JROOT/libraries/quixnxt/app/bootstrap.php:19 |
11 | include_once JROOT/libraries/quixnxt/app/bootstrap.php | JROOT/libraries/loader.php:226 |
10 | JLoader::import() | JROOT/libraries/loader.php:845 |
9 | jimport() | JROOT/plugins/system/quix/quix.php:108 |
8 | plgSystemQuix::initQuix() | JROOT/plugins/system/quix/quix.php:101 |
7 | plgSystemQuix->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:645 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
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 |
SELECT id,template
FROM iwgia_template_styles
WHERE client_id=0
AND home=1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iwgia_template_styles | ALL | idx_client_id,idx_client_id_home | NO INDEX KEY COULD BE USED | NULL | NULL | 7 | Using where |
Status | Duration |
---|---|
Starting | 0.12 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.12 ms |
Preparing | 0.03 ms |
Executing | 0.00 ms |
Sending data | 0.09 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
18 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
17 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_widgetkit/widgetkit.php:23 |
16 | plgSystemWidgetkit->{closure}() | JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Container.php:240 |
15 | YOOtheme\Framework\Container->offsetGet() | JROOT/administrator/components/com_widgetkit/src/Application.php:49 |
14 | YOOtheme\Widgetkit\Application->YOOtheme\Widgetkit\{closure}() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Event/EventDispatcher.php:113 |
12 | YOOtheme\Framework\Event\EventDispatcher->trigger() | JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Application.php:149 |
11 | YOOtheme\Framework\Application->boot() | JROOT/administrator/components/com_widgetkit/widgetkit.php:91 |
10 | include JROOT/administrator/components/com_widgetkit/widgetkit.php | JROOT/administrator/components/com_widgetkit/widgetkit-app.php:6 |
9 | include JROOT/administrator/components/com_widgetkit/widgetkit-app.php | JROOT/plugins/system/widgetkit/widgetkit.php:9 |
8 | plgSystemWidgetkit->onAfterInitialise() | 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:646 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
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 |
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 iwgia_menu AS m
LEFT JOIN iwgia_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
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 395 | Using index condition; Using where; Using filesort |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | benjamin_iwgia-maindb.m.component_id | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.09 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.04 ms |
Optimizing | 0.02 ms |
Statistics | 0.10 ms |
Preparing | 0.03 ms |
Executing | 0.00 ms |
Sending data | 0.06 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.01 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.04 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
23 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
21 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Same as call in the line below. |
20 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
19 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
18 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
17 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
16 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
15 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:395 |
14 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
13 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
12 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
11 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:511 |
10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/languagefilter/languagefilter.php:145 |
8 | PlgSystemLanguageFilter->onAfterInitialise() | 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:646 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
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 |
SELECT id, home, template, s.params
FROM iwgia_template_styles as s
LEFT JOIN iwgia_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
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | ALL | idx_template,idx_client_id,idx_client_id_home | NO INDEX KEY COULD BE USED | NULL | NULL | 7 | Using where |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | benjamin_iwgia-maindb.s.template,const | 1 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init for update | 0.07 ms |
Updating | 0.07 ms |
End of update loop | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.71 ms |
Query end | 0.01 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.03 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
9 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/plugins/system/mvcoverridecwmulticats/mvcoverridecwmulticats.php:118 |
8 | PlgSystemMVCOverrideCWMulticats->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:1168 |
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 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `iwgia_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iwgia_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
Status | Duration |
---|---|
Starting | 0.11 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.05 ms |
Optimizing | 0.02 ms |
Statistics | 0.12 ms |
Preparing | 0.02 ms |
Executing | 0.00 ms |
Sending data | 0.33 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
15 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
14 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
13 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Same as call in the line below. |
12 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
11 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
10 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
9 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
8 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
7 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
6 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
5 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/src/Application/WebApplication.php:1131 |
4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT/libraries/src/Application/SiteApplication.php:133 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE `iwgia_extensions`
SET `params` = '{\"mediaversion\":\"03924630dc5399e16fa8a69eeda016e2\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
Status | Duration |
---|---|
Starting | 0.11 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.00 ms |
Sending data | 0.11 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.01 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.15 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
10 | JDatabaseDriverPdo->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
9 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
8 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
7 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
6 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
5 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/src/Application/WebApplication.php:1131 |
4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT/libraries/src/Application/SiteApplication.php:133 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `iwgia_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_config','com_contact','com_content','com_contenthistory','com_contenttemplater','com_cpanel','com_docman','com_facebookfeedpro','com_fields','com_finder','com_ingallery','com_installer','com_iquix','com_iwgia','com_jce','com_jmap','com_jmedia','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_miniteklivesearch','com_miniteksmartsearch','com_modules','com_multicats','com_newsfeeds','com_oscontent','com_osmeta','com_plugins','com_postinstall','com_privacy','com_quix','com_redirect','com_redj','com_regularlabsmanager','com_rsfirewall','com_search','com_smartslider3','com_spsimpleportfolio','com_tags','com_templates','com_twitterfeedpro','com_users','com_widgetkit','com_wrapper')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iwgia_assets | range | idx_asset_name | idx_asset_name | 202 | NULL | 58 | Using index condition |
Status | Duration |
---|---|
Starting | 0.04 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.07 ms |
Preparing | 0.03 ms |
Executing | 0.00 ms |
Sending data | 5.28 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
32 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
31 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
30 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
29 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
28 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
27 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
26 | Joomla\CMS\User\User->authorise() | JROOT/libraries/joomlatools/component/koowa/user/trait.php:168 |
25 | ComKoowaUser->authorise() | JROOT/components/com_docman/dispatcher/http.php:104 |
24 | ComDocmanDispatcherHttp->getRequest() | JROOT/libraries/joomlatools/component/koowa/dispatcher/behavior/decoratable.php:34 |
23 | ComKoowaDispatcherBehaviorDecoratable->isSupported() | JROOT/libraries/joomlatools/library/behavior/abstract.php:176 |
22 | KBehaviorAbstract->getHandle() | JROOT/libraries/joomlatools/library/object/queue.php:63 |
21 | KObjectQueue->enqueue() | JROOT/libraries/joomlatools/library/command/chain/chain.php:168 |
20 | KCommandChain->addHandler() | JROOT/libraries/joomlatools/library/command/mixin/mixin.php:259 |
19 | KCommandMixin->addCommandHandler() | JROOT/libraries/joomlatools/library/behavior/mixin/mixin.php:122 |
18 | KBehaviorMixin->addBehavior() | JROOT/libraries/joomlatools/library/behavior/mixin/mixin.php:45 |
17 | KBehaviorMixin->__construct() | JROOT/libraries/joomlatools/library/object/object.php:132 |
16 | KObject->mixin() | JROOT/libraries/joomlatools/library/controller/abstract.php:206 |
15 | KControllerAbstract->mixin() | JROOT/libraries/joomlatools/library/controller/abstract.php:77 |
14 | KControllerAbstract->__construct() | JROOT/libraries/joomlatools/library/dispatcher/abstract.php:49 |
13 | KDispatcherAbstract->__construct() | JROOT/libraries/joomlatools/library/dispatcher/http.php:32 |
12 | KDispatcherHttp->__construct() | JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:25 |
11 | ComKoowaDispatcherHttp->__construct() | JROOT/components/com_docman/dispatcher/http.php:13 |
10 | ComDocmanDispatcherHttp->__construct() | JROOT/libraries/joomlatools/library/dispatcher/http.php:75 |
9 | KDispatcherHttp::getInstance() | JROOT/libraries/joomlatools/library/object/manager/manager.php:721 |
8 | KObjectManager->_instantiate() | JROOT/libraries/joomlatools/library/object/manager/manager.php:161 |
7 | KObjectManager->getObject() | JROOT/components/com_docman/docman.php:10 |
6 | require_once JROOT/components/com_docman/docman.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 |
SELECT c.docman_category_id AS id, a.name AS asset_name, c.created_by AS owner
FROM iwgia_docman_categories AS c
INNER JOIN iwgia_assets AS a
ON c.asset_id = a.id
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 12 | |
1 | SIMPLE | a | eq_ref | PRIMARY | PRIMARY | 4 | benjamin_iwgia-maindb.c.asset_id | 1 |
Status | Duration |
---|---|
Starting | 0.11 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 0.13 ms |
Preparing | 0.03 ms |
Executing | 0.00 ms |
Sending data | 0.06 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.01 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
28 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
27 | JDatabaseDriver->loadObjectList() | JROOT/components/com_docman/controller/permission/abstract.php:194 |
26 | ComDocmanControllerPermissionAbstract->getAuthorisedCategories() | JROOT/components/com_docman/controller/permission/abstract.php:33 |
25 | ComDocmanControllerPermissionAbstract->canAdd() | JROOT/components/com_docman/controller/permission/list.php:54 |
24 | ComDocmanControllerPermissionList->canAdd() | JROOT/libraries/joomlatools/library/object/object.php:398 |
23 | KObject->__call() | JROOT/libraries/joomlatools/library/controller/abstract.php:407 |
22 | KControllerAbstract->__call() | JROOT/libraries/joomlatools/library/controller/view.php:271 |
21 | KControllerView->__call() | JROOT/libraries/joomlatools/library/controller/model.php:404 |
20 | KControllerModel->__call() | JROOT/components/com_docman/controller/list.php:188 |
19 | ComDocmanControllerList->getView() | JROOT/libraries/joomlatools/component/koowa/dispatcher/behavior/decoratable.php:135 |
18 | ComKoowaDispatcherBehaviorDecoratable->getDecorator() | JROOT/libraries/joomlatools/component/koowa/dispatcher/behavior/decoratable.php:52 |
17 | ComKoowaDispatcherBehaviorDecoratable->_beforeDispatch() | JROOT/libraries/joomlatools/library/command/callback/abstract.php:118 |
16 | KCommandCallbackAbstract->invokeCommandCallback() | JROOT/libraries/joomlatools/library/command/callback/abstract.php:98 |
15 | KCommandCallbackAbstract->invokeCallbacks() | JROOT/libraries/joomlatools/library/behavior/abstract.php:119 |
14 | KBehaviorAbstract->execute() | JROOT/libraries/joomlatools/library/controller/behavior/abstract.php:58 |
13 | KControllerBehaviorAbstract->execute() | JROOT/libraries/joomlatools/library/command/chain/chain.php:147 |
12 | KCommandChain->execute() | JROOT/libraries/joomlatools/library/command/mixin/mixin.php:133 |
11 | KCommandMixin->invokeCommand() | JROOT/libraries/joomlatools/library/object/object.php:404 |
10 | KObject->__call() | JROOT/libraries/joomlatools/library/controller/abstract.php:407 |
9 | KControllerAbstract->__call() | JROOT/libraries/joomlatools/library/controller/abstract.php:138 |
8 | KControllerAbstract->execute() | JROOT/libraries/joomlatools/library/controller/abstract.php:394 |
7 | KControllerAbstract->__call() | JROOT/components/com_docman/docman.php:10 |
6 | require_once JROOT/components/com_docman/docman.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 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `iwgia_assets`
WHERE `name` LIKE 'com_docman.%' OR `name` = 'com_docman' OR `parent_id` = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iwgia_assets | ALL | idx_asset_name,idx_parent_id | NO INDEX KEY COULD BE USED | NULL | NULL | 12410 | Using where |
Status | Duration |
---|---|
Starting | 0.11 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 0.85 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.08 ms |
Executing | 0.00 ms |
Sending data | 0.04 ms |
End of update loop | 0.00 ms |
Removing tmp table | 0.00 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.04 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
34 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
33 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 |
32 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 |
31 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 |
30 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
29 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
28 | Joomla\CMS\User\User->authorise() | JROOT/libraries/joomlatools/component/koowa/user/trait.php:168 |
27 | ComKoowaUser->authorise() | JROOT/components/com_docman/controller/permission/abstract.php:210 |
26 | ComDocmanControllerPermissionAbstract->getAuthorisedCategories() | JROOT/components/com_docman/controller/permission/abstract.php:33 |
25 | ComDocmanControllerPermissionAbstract->canAdd() | JROOT/components/com_docman/controller/permission/list.php:54 |
24 | ComDocmanControllerPermissionList->canAdd() | JROOT/libraries/joomlatools/library/object/object.php:398 |
23 | KObject->__call() | JROOT/libraries/joomlatools/library/controller/abstract.php:407 |
22 | KControllerAbstract->__call() | JROOT/libraries/joomlatools/library/controller/view.php:271 |
21 | KControllerView->__call() | JROOT/libraries/joomlatools/library/controller/model.php:404 |
20 | KControllerModel->__call() | JROOT/components/com_docman/controller/list.php:188 |
19 | ComDocmanControllerList->getView() | JROOT/libraries/joomlatools/component/koowa/dispatcher/behavior/decoratable.php:135 |
18 | ComKoowaDispatcherBehaviorDecoratable->getDecorator() | JROOT/libraries/joomlatools/component/koowa/dispatcher/behavior/decoratable.php:52 |
17 | ComKoowaDispatcherBehaviorDecoratable->_beforeDispatch() | JROOT/libraries/joomlatools/library/command/callback/abstract.php:118 |
16 | KCommandCallbackAbstract->invokeCommandCallback() | JROOT/libraries/joomlatools/library/command/callback/abstract.php:98 |
15 | KCommandCallbackAbstract->invokeCallbacks() | JROOT/libraries/joomlatools/library/behavior/abstract.php:119 |
14 | KBehaviorAbstract->execute() | JROOT/libraries/joomlatools/library/controller/behavior/abstract.php:58 |
13 | KControllerBehaviorAbstract->execute() | JROOT/libraries/joomlatools/library/command/chain/chain.php:147 |
12 | KCommandChain->execute() | JROOT/libraries/joomlatools/library/command/mixin/mixin.php:133 |
11 | KCommandMixin->invokeCommand() | JROOT/libraries/joomlatools/library/object/object.php:404 |
10 | KObject->__call() | JROOT/libraries/joomlatools/library/controller/abstract.php:407 |
9 | KControllerAbstract->__call() | JROOT/libraries/joomlatools/library/controller/abstract.php:138 |
8 | KControllerAbstract->execute() | JROOT/libraries/joomlatools/library/controller/abstract.php:394 |
7 | KControllerAbstract->__call() | JROOT/components/com_docman/docman.php:10 |
6 | require_once JROOT/components/com_docman/docman.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 |
SELECT extension_id, params, manifest_cache
FROM iwgia_extensions
WHERE type = 'plugin'
AND element = 'joomlatoolsupdater'
AND folder = 'system'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iwgia_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.09 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.05 ms |
Preparing | 0.01 ms |
Executing | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
25 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
24 | JDatabaseDriver->loadObject() | JROOT/plugins/system/joomlatoolsupdater/license/license.php:252 |
23 | PlgSystemJoomlatoolsupdaterLicense->_getPlugin() | JROOT/plugins/system/joomlatoolsupdater/license/license.php:42 |
22 | PlgSystemJoomlatoolsupdaterLicense->_initialize() | JROOT/libraries/joomlatools/library/object/object.php:73 |
21 | KObject->__construct() | JROOT/plugins/system/joomlatoolsupdater/license/license.php:31 |
20 | PlgSystemJoomlatoolsupdaterLicense->__construct() | JROOT/libraries/joomlatools/library/object/manager/manager.php:723 |
19 | KObjectManager->_instantiate() | JROOT/libraries/joomlatools/library/object/manager/manager.php:161 |
18 | KObjectManager->getObject() | JROOT/libraries/joomlatools/library/object/object.php:290 |
17 | KObject->getObject() | JROOT/plugins/system/joomlatoolsupdater/event/subscriber/license.php:27 |
16 | PlgSystemJoomlatoolsupdaterEventSubscriberLicense->onBeforeDispatcherDispatch() | JROOT/libraries/joomlatools/library/event/publisher/abstract.php:128 |
15 | KEventPublisherAbstract->publishEvent() | JROOT/libraries/joomlatools/component/koowa/event/publisher/publisher.php:43 |
14 | ComKoowaEventPublisher->publishEvent() | JROOT/libraries/joomlatools/library/command/handler/event.php:161 |
13 | KCommandHandlerEvent->execute() | JROOT/libraries/joomlatools/library/command/chain/chain.php:147 |
12 | KCommandChain->execute() | JROOT/libraries/joomlatools/library/command/mixin/mixin.php:133 |
11 | KCommandMixin->invokeCommand() | JROOT/libraries/joomlatools/library/object/object.php:404 |
10 | KObject->__call() | JROOT/libraries/joomlatools/library/controller/abstract.php:407 |
9 | KControllerAbstract->__call() | JROOT/libraries/joomlatools/library/controller/abstract.php:138 |
8 | KControllerAbstract->execute() | JROOT/libraries/joomlatools/library/controller/abstract.php:394 |
7 | KControllerAbstract->__call() | JROOT/components/com_docman/docman.php:10 |
6 | require_once JROOT/components/com_docman/docman.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 |
SELECT GROUP_CONCAT(c.slug
ORDER BY r.level DESC SEPARATOR '/')
FROM `iwgia_docman_category_relations` as r
INNER JOIN `iwgia_docman_categories` AS c2
ON c2.slug = 'documents'
LEFT JOIN `iwgia_docman_categories` AS c
ON c.docman_category_id = r.ancestor_id
WHERE r.descendant_id = c2.docman_category_id
ORDER BY r.level DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c2 | const | docman_category_id,slug | slug | 767 | const | 1 | Using index |
1 | SIMPLE | r | ref | path_index | path_index | 8 | const | 1 | Using index |
1 | SIMPLE | c | eq_ref | docman_category_id | docman_category_id | 8 | benjamin_iwgia-maindb.r.ancestor_id | 1 |
Status | Duration |
---|---|
Starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.08 ms |
Preparing | 0.00 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.04 ms |
Executing | 0.00 ms |
Sending data | 0.03 ms |
End of update loop | 0.00 ms |
Removing tmp table | 0.00 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
45 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
44 | JDatabaseDriver->loadResult() | JROOT/components/com_docman/router.php:83 |
43 | ComDocmanRouter->getCategoryPath() | JROOT/components/com_docman/router.php:192 |
42 | ComDocmanRouter->build() | JROOT/components/com_docman/router.php:398 |
41 | DocmanBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
40 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
39 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
38 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
37 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
36 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:127 |
35 | ComKoowaDispatcherRouterRoute->_getRoute() | JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:92 |
34 | ComKoowaDispatcherRouterRoute->toString() | JROOT/libraries/joomlatools/library/http/url/url.php:709 |
33 | KHttpUrl->__toString() | /home/benjamin/tmp/buffer685a769f98c98706938414:12 |
32 | include /home/benjamin/tmp/buffer685a769f98c98706938414 | JROOT/libraries/joomlatools/library/template/engine/koowa.php:352 |
31 | KTemplateEngineKoowa->_evaluate() | JROOT/libraries/joomlatools/library/template/engine/koowa.php:170 |
30 | KTemplateEngineKoowa->render() | JROOT/libraries/joomlatools/library/template/engine/koowa.php:402 |
29 | KTemplateEngineKoowa->_import() | JROOT/libraries/joomlatools/library/template/abstract.php:213 |
28 | KTemplateAbstract->__call() | /home/benjamin/tmp/buffer685a769f8c5b0625510410:131 |
27 | include /home/benjamin/tmp/buffer685a769f8c5b0625510410 | JROOT/libraries/joomlatools/library/template/engine/koowa.php:352 |
26 | KTemplateEngineKoowa->_evaluate() | JROOT/libraries/joomlatools/library/template/engine/koowa.php:170 |
25 | KTemplateEngineKoowa->render() | JROOT/libraries/joomlatools/library/template/engine/koowa.php:402 |
24 | KTemplateEngineKoowa->_import() | JROOT/libraries/joomlatools/library/template/abstract.php:213 |
23 | KTemplateAbstract->__call() | /home/benjamin/tmp/buffer685a769f8ba9f776319672:14 |
22 | include /home/benjamin/tmp/buffer685a769f8ba9f776319672 | JROOT/libraries/joomlatools/library/template/engine/koowa.php:352 |
21 | KTemplateEngineKoowa->_evaluate() | JROOT/libraries/joomlatools/library/template/engine/koowa.php:170 |
20 | KTemplateEngineKoowa->render() | JROOT/libraries/joomlatools/library/template/template.php:201 |
19 | KTemplate->render() | JROOT/libraries/joomlatools/library/view/template.php:114 |
18 | KViewTemplate->_actionRender() | JROOT/components/com_docman/views/html.php:32 |
17 | ComDocmanViewHtml->_actionRender() | JROOT/libraries/joomlatools/library/view/abstract.php:114 |
16 | KViewAbstract->render() | JROOT/libraries/joomlatools/library/controller/view.php:230 |
15 | KControllerView->_actionRender() | JROOT/libraries/joomlatools/library/controller/model.php:188 |
14 | KControllerModel->_actionRender() | JROOT/libraries/joomlatools/library/controller/abstract.php:156 |
13 | KControllerAbstract->execute() | JROOT/libraries/joomlatools/library/dispatcher/http.php:203 |
12 | KDispatcherHttp->_actionGet() | JROOT/libraries/joomlatools/library/controller/abstract.php:156 |
11 | KControllerAbstract->execute() | JROOT/libraries/joomlatools/library/dispatcher/http.php:142 |
10 | KDispatcherHttp->_actionDispatch() | JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:177 |
9 | ComKoowaDispatcherHttp->_actionDispatch() | JROOT/libraries/joomlatools/library/controller/abstract.php:156 |
8 | KControllerAbstract->execute() | JROOT/libraries/joomlatools/library/controller/abstract.php:394 |
7 | KControllerAbstract->__call() | JROOT/components/com_docman/docman.php:10 |
6 | require_once JROOT/components/com_docman/docman.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 |
SELECT GROUP_CONCAT(c.slug
ORDER BY r.level DESC SEPARATOR '/')
FROM `iwgia_docman_category_relations` as r
INNER JOIN `iwgia_docman_categories` AS c2
ON c2.slug = ''
LEFT JOIN `iwgia_docman_categories` AS c
ON c.docman_category_id = r.ancestor_id
WHERE r.descendant_id = c2.docman_category_id
ORDER BY r.level DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
Starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.06 ms |
Preparing | 0.00 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.04 ms |
Executing | 0.00 ms |
Sending data | 0.02 ms |
End of update loop | 0.00 ms |
Removing tmp table | 0.00 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
45 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
44 | JDatabaseDriver->loadResult() | JROOT/components/com_docman/router.php:83 |
43 | ComDocmanRouter->getCategoryPath() | JROOT/components/com_docman/router.php:203 |
42 | ComDocmanRouter->build() | JROOT/components/com_docman/router.php:398 |
41 | DocmanBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
40 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
39 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
38 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
37 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
36 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:127 |
35 | ComKoowaDispatcherRouterRoute->_getRoute() | JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:92 |
34 | ComKoowaDispatcherRouterRoute->toString() | JROOT/libraries/joomlatools/library/http/url/url.php:709 |
33 | KHttpUrl->__toString() | /home/benjamin/tmp/buffer685a769f98c98706938414:12 |
32 | include /home/benjamin/tmp/buffer685a769f98c98706938414 | JROOT/libraries/joomlatools/library/template/engine/koowa.php:352 |
31 | KTemplateEngineKoowa->_evaluate() | JROOT/libraries/joomlatools/library/template/engine/koowa.php:170 |
30 | KTemplateEngineKoowa->render() | JROOT/libraries/joomlatools/library/template/engine/koowa.php:402 |
29 | KTemplateEngineKoowa->_import() | JROOT/libraries/joomlatools/library/template/abstract.php:213 |
28 | KTemplateAbstract->__call() | /home/benjamin/tmp/buffer685a769f8c5b0625510410:131 |
27 | include /home/benjamin/tmp/buffer685a769f8c5b0625510410 | JROOT/libraries/joomlatools/library/template/engine/koowa.php:352 |
26 | KTemplateEngineKoowa->_evaluate() | JROOT/libraries/joomlatools/library/template/engine/koowa.php:170 |
25 | KTemplateEngineKoowa->render() | JROOT/libraries/joomlatools/library/template/engine/koowa.php:402 |
24 | KTemplateEngineKoowa->_import() | JROOT/libraries/joomlatools/library/template/abstract.php:213 |
23 | KTemplateAbstract->__call() | /home/benjamin/tmp/buffer685a769f8ba9f776319672:14 |
22 | include /home/benjamin/tmp/buffer685a769f8ba9f776319672 | JROOT/libraries/joomlatools/library/template/engine/koowa.php:352 |
21 | KTemplateEngineKoowa->_evaluate() | JROOT/libraries/joomlatools/library/template/engine/koowa.php:170 |
20 | KTemplateEngineKoowa->render() | JROOT/libraries/joomlatools/library/template/template.php:201 |
19 | KTemplate->render() | JROOT/libraries/joomlatools/library/view/template.php:114 |
18 | KViewTemplate->_actionRender() | JROOT/components/com_docman/views/html.php:32 |
17 | ComDocmanViewHtml->_actionRender() | JROOT/libraries/joomlatools/library/view/abstract.php:114 |
16 | KViewAbstract->render() | JROOT/libraries/joomlatools/library/controller/view.php:230 |
15 | KControllerView->_actionRender() | JROOT/libraries/joomlatools/library/controller/model.php:188 |
14 | KControllerModel->_actionRender() | JROOT/libraries/joomlatools/library/controller/abstract.php:156 |
13 | KControllerAbstract->execute() | JROOT/libraries/joomlatools/library/dispatcher/http.php:203 |
12 | KDispatcherHttp->_actionGet() | JROOT/libraries/joomlatools/library/controller/abstract.php:156 |
11 | KControllerAbstract->execute() | JROOT/libraries/joomlatools/library/dispatcher/http.php:142 |
10 | KDispatcherHttp->_actionDispatch() | JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:177 |
9 | ComKoowaDispatcherHttp->_actionDispatch() | JROOT/libraries/joomlatools/library/controller/abstract.php:156 |
8 | KControllerAbstract->execute() | JROOT/libraries/joomlatools/library/controller/abstract.php:394 |
7 | KControllerAbstract->__call() | JROOT/components/com_docman/docman.php:10 |
6 | require_once JROOT/components/com_docman/docman.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 |
SELECT GROUP_CONCAT(c.slug
ORDER BY r.level DESC SEPARATOR '/')
FROM `iwgia_docman_category_relations` as r
INNER JOIN `iwgia_docman_categories` AS c2
ON c2.slug = 'iwgia-job-ads'
LEFT JOIN `iwgia_docman_categories` AS c
ON c.docman_category_id = r.ancestor_id
WHERE r.descendant_id = c2.docman_category_id
ORDER BY r.level DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c2 | const | docman_category_id,slug | slug | 767 | const | 1 | Using index |
1 | SIMPLE | r | ref | path_index | path_index | 8 | const | 1 | Using index |
1 | SIMPLE | c | eq_ref | docman_category_id | docman_category_id | 8 | benjamin_iwgia-maindb.r.ancestor_id | 1 |
Status | Duration |
---|---|
Starting | 0.13 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.12 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.06 ms |
Executing | 0.01 ms |
Sending data | 0.04 ms |
End of update loop | 0.01 ms |
Removing tmp table | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.01 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
45 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
44 | JDatabaseDriver->loadResult() | JROOT/components/com_docman/router.php:83 |
43 | ComDocmanRouter->getCategoryPath() | JROOT/components/com_docman/router.php:192 |
42 | ComDocmanRouter->build() | JROOT/components/com_docman/router.php:398 |
41 | DocmanBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
40 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
39 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
38 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
37 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
36 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:127 |
35 | ComKoowaDispatcherRouterRoute->_getRoute() | JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:92 |
34 | ComKoowaDispatcherRouterRoute->toString() | JROOT/libraries/joomlatools/library/http/url/url.php:709 |
33 | KHttpUrl->__toString() | /home/benjamin/tmp/buffer685a769f9ab8f997759596:12 |
32 | include /home/benjamin/tmp/buffer685a769f9ab8f997759596 | JROOT/libraries/joomlatools/library/template/engine/koowa.php:352 |
31 | KTemplateEngineKoowa->_evaluate() | JROOT/libraries/joomlatools/library/template/engine/koowa.php:170 |
30 | KTemplateEngineKoowa->render() | JROOT/libraries/joomlatools/library/template/engine/koowa.php:402 |
29 | KTemplateEngineKoowa->_import() | JROOT/libraries/joomlatools/library/template/abstract.php:213 |
28 | KTemplateAbstract->__call() | /home/benjamin/tmp/buffer685a769f8c5b0625510410:131 |
27 | include /home/benjamin/tmp/buffer685a769f8c5b0625510410 | JROOT/libraries/joomlatools/library/template/engine/koowa.php:352 |
26 | KTemplateEngineKoowa->_evaluate() | JROOT/libraries/joomlatools/library/template/engine/koowa.php:170 |
25 | KTemplateEngineKoowa->render() | JROOT/libraries/joomlatools/library/template/engine/koowa.php:402 |
24 | KTemplateEngineKoowa->_import() | JROOT/libraries/joomlatools/library/template/abstract.php:213 |
23 | KTemplateAbstract->__call() | /home/benjamin/tmp/buffer685a769f8ba9f776319672:14 |
22 | include /home/benjamin/tmp/buffer685a769f8ba9f776319672 | JROOT/libraries/joomlatools/library/template/engine/koowa.php:352 |
21 | KTemplateEngineKoowa->_evaluate() | JROOT/libraries/joomlatools/library/template/engine/koowa.php:170 |
20 | KTemplateEngineKoowa->render() | JROOT/libraries/joomlatools/library/template/template.php:201 |
19 | KTemplate->render() | JROOT/libraries/joomlatools/library/view/template.php:114 |
18 | KViewTemplate->_actionRender() | JROOT/components/com_docman/views/html.php:32 |
17 | ComDocmanViewHtml->_actionRender() | JROOT/libraries/joomlatools/library/view/abstract.php:114 |
16 | KViewAbstract->render() | JROOT/libraries/joomlatools/library/controller/view.php:230 |
15 | KControllerView->_actionRender() | JROOT/libraries/joomlatools/library/controller/model.php:188 |
14 | KControllerModel->_actionRender() | JROOT/libraries/joomlatools/library/controller/abstract.php:156 |
13 | KControllerAbstract->execute() | JROOT/libraries/joomlatools/library/dispatcher/http.php:203 |
12 | KDispatcherHttp->_actionGet() | JROOT/libraries/joomlatools/library/controller/abstract.php:156 |
11 | KControllerAbstract->execute() | JROOT/libraries/joomlatools/library/dispatcher/http.php:142 |
10 | KDispatcherHttp->_actionDispatch() | JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:177 |
9 | ComKoowaDispatcherHttp->_actionDispatch() | JROOT/libraries/joomlatools/library/controller/abstract.php:156 |
8 | KControllerAbstract->execute() | JROOT/libraries/joomlatools/library/controller/abstract.php:394 |
7 | KControllerAbstract->__call() | JROOT/components/com_docman/docman.php:10 |
6 | require_once JROOT/components/com_docman/docman.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 |
SELECT GROUP_CONCAT(c.slug
ORDER BY r.level DESC SEPARATOR '/')
FROM `iwgia_docman_category_relations` as r
INNER JOIN `iwgia_docman_categories` AS c2
ON c2.slug = 'iwgia-reports'
LEFT JOIN `iwgia_docman_categories` AS c
ON c.docman_category_id = r.ancestor_id
WHERE r.descendant_id = c2.docman_category_id
ORDER BY r.level DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c2 | const | docman_category_id,slug | slug | 767 | const | 1 | Using index |
1 | SIMPLE | r | ref | path_index | path_index | 8 | const | 1 | Using index |
1 | SIMPLE | c | eq_ref | docman_category_id | docman_category_id | 8 | benjamin_iwgia-maindb.r.ancestor_id | 1 |
Status | Duration |
---|---|
Starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.12 ms |
Preparing | 0.03 ms |
Executing | 0.00 ms |
Sending data | 0.29 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.01 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
45 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
44 | JDatabaseDriver->loadResult() | JROOT/components/com_docman/router.php:83 |
43 | ComDocmanRouter->getCategoryPath() | JROOT/components/com_docman/router.php:192 |
42 | ComDocmanRouter->build() | JROOT/components/com_docman/router.php:398 |
41 | DocmanBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
40 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
39 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
38 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
37 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
36 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:127 |
35 | ComKoowaDispatcherRouterRoute->_getRoute() | JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:92 |
34 | ComKoowaDispatcherRouterRoute->toString() | JROOT/libraries/joomlatools/library/http/url/url.php:709 |
33 | KHttpUrl->__toString() | /home/benjamin/tmp/buffer685a769f9c05a975783905:12 |
32 | include /home/benjamin/tmp/buffer685a769f9c05a975783905 | JROOT/libraries/joomlatools/library/template/engine/koowa.php:352 |
31 | KTemplateEngineKoowa->_evaluate() | JROOT/libraries/joomlatools/library/template/engine/koowa.php:170 |
30 | KTemplateEngineKoowa->render() | JROOT/libraries/joomlatools/library/template/engine/koowa.php:402 |
29 | KTemplateEngineKoowa->_import() | JROOT/libraries/joomlatools/library/template/abstract.php:213 |
28 | KTemplateAbstract->__call() | /home/benjamin/tmp/buffer685a769f8c5b0625510410:131 |
27 | include /home/benjamin/tmp/buffer685a769f8c5b0625510410 | JROOT/libraries/joomlatools/library/template/engine/koowa.php:352 |
26 | KTemplateEngineKoowa->_evaluate() | JROOT/libraries/joomlatools/library/template/engine/koowa.php:170 |
25 | KTemplateEngineKoowa->render() | JROOT/libraries/joomlatools/library/template/engine/koowa.php:402 |
24 | KTemplateEngineKoowa->_import() | JROOT/libraries/joomlatools/library/template/abstract.php:213 |
23 | KTemplateAbstract->__call() | /home/benjamin/tmp/buffer685a769f8ba9f776319672:14 |
22 | include /home/benjamin/tmp/buffer685a769f8ba9f776319672 | JROOT/libraries/joomlatools/library/template/engine/koowa.php:352 |
21 | KTemplateEngineKoowa->_evaluate() | JROOT/libraries/joomlatools/library/template/engine/koowa.php:170 |
20 | KTemplateEngineKoowa->render() | JROOT/libraries/joomlatools/library/template/template.php:201 |
19 | KTemplate->render() | JROOT/libraries/joomlatools/library/view/template.php:114 |
18 | KViewTemplate->_actionRender() | JROOT/components/com_docman/views/html.php:32 |
17 | ComDocmanViewHtml->_actionRender() | JROOT/libraries/joomlatools/library/view/abstract.php:114 |
16 | KViewAbstract->render() | JROOT/libraries/joomlatools/library/controller/view.php:230 |
15 | KControllerView->_actionRender() | JROOT/libraries/joomlatools/library/controller/model.php:188 |
14 | KControllerModel->_actionRender() | JROOT/libraries/joomlatools/library/controller/abstract.php:156 |
13 | KControllerAbstract->execute() | JROOT/libraries/joomlatools/library/dispatcher/http.php:203 |
12 | KDispatcherHttp->_actionGet() | JROOT/libraries/joomlatools/library/controller/abstract.php:156 |
11 | KControllerAbstract->execute() | JROOT/libraries/joomlatools/library/dispatcher/http.php:142 |
10 | KDispatcherHttp->_actionDispatch() | JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:177 |
9 | ComKoowaDispatcherHttp->_actionDispatch() | JROOT/libraries/joomlatools/library/controller/abstract.php:156 |
8 | KControllerAbstract->execute() | JROOT/libraries/joomlatools/library/controller/abstract.php:394 |
7 | KControllerAbstract->__call() | JROOT/components/com_docman/docman.php:10 |
6 | require_once JROOT/components/com_docman/docman.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 |
SELECT GROUP_CONCAT(c.slug
ORDER BY r.level DESC SEPARATOR '/')
FROM `iwgia_docman_category_relations` as r
INNER JOIN `iwgia_docman_categories` AS c2
ON c2.slug = 'videos'
LEFT JOIN `iwgia_docman_categories` AS c
ON c.docman_category_id = r.ancestor_id
WHERE r.descendant_id = c2.docman_category_id
ORDER BY r.level DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c2 | const | docman_category_id,slug | slug | 767 | const | 1 | Using index |
1 | SIMPLE | r | ref | path_index | path_index | 8 | const | 1 | Using index |
1 | SIMPLE | c | eq_ref | docman_category_id | docman_category_id | 8 | benjamin_iwgia-maindb.r.ancestor_id | 1 |
Status | Duration |
---|---|
Starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.08 ms |
Preparing | 0.01 ms |
Executing | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
45 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
44 | JDatabaseDriver->loadResult() | JROOT/components/com_docman/router.php:83 |
43 | ComDocmanRouter->getCategoryPath() | JROOT/components/com_docman/router.php:192 |
42 | ComDocmanRouter->build() | JROOT/components/com_docman/router.php:398 |
41 | DocmanBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
40 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
39 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
38 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
37 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
36 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:127 |
35 | ComKoowaDispatcherRouterRoute->_getRoute() | JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:92 |
34 | ComKoowaDispatcherRouterRoute->toString() | JROOT/libraries/joomlatools/library/http/url/url.php:709 |
33 | KHttpUrl->__toString() | /home/benjamin/tmp/buffer685a769f9d564681707174:12 |
32 | include /home/benjamin/tmp/buffer685a769f9d564681707174 | JROOT/libraries/joomlatools/library/template/engine/koowa.php:352 |
31 | KTemplateEngineKoowa->_evaluate() | JROOT/libraries/joomlatools/library/template/engine/koowa.php:170 |
30 | KTemplateEngineKoowa->render() | JROOT/libraries/joomlatools/library/template/engine/koowa.php:402 |
29 | KTemplateEngineKoowa->_import() | JROOT/libraries/joomlatools/library/template/abstract.php:213 |
28 | KTemplateAbstract->__call() | /home/benjamin/tmp/buffer685a769f8c5b0625510410:131 |
27 | include /home/benjamin/tmp/buffer685a769f8c5b0625510410 | JROOT/libraries/joomlatools/library/template/engine/koowa.php:352 |
26 | KTemplateEngineKoowa->_evaluate() | JROOT/libraries/joomlatools/library/template/engine/koowa.php:170 |
25 | KTemplateEngineKoowa->render() | JROOT/libraries/joomlatools/library/template/engine/koowa.php:402 |
24 | KTemplateEngineKoowa->_import() | JROOT/libraries/joomlatools/library/template/abstract.php:213 |
23 | KTemplateAbstract->__call() | /home/benjamin/tmp/buffer685a769f8ba9f776319672:14 |
22 | include /home/benjamin/tmp/buffer685a769f8ba9f776319672 | JROOT/libraries/joomlatools/library/template/engine/koowa.php:352 |
21 | KTemplateEngineKoowa->_evaluate() | JROOT/libraries/joomlatools/library/template/engine/koowa.php:170 |
20 | KTemplateEngineKoowa->render() | JROOT/libraries/joomlatools/library/template/template.php:201 |
19 | KTemplate->render() | JROOT/libraries/joomlatools/library/view/template.php:114 |
18 | KViewTemplate->_actionRender() | JROOT/components/com_docman/views/html.php:32 |
17 | ComDocmanViewHtml->_actionRender() | JROOT/libraries/joomlatools/library/view/abstract.php:114 |
16 | KViewAbstract->render() | JROOT/libraries/joomlatools/library/controller/view.php:230 |
15 | KControllerView->_actionRender() | JROOT/libraries/joomlatools/library/controller/model.php:188 |
14 | KControllerModel->_actionRender() | JROOT/libraries/joomlatools/library/controller/abstract.php:156 |
13 | KControllerAbstract->execute() | JROOT/libraries/joomlatools/library/dispatcher/http.php:203 |
12 | KDispatcherHttp->_actionGet() | JROOT/libraries/joomlatools/library/controller/abstract.php:156 |
11 | KControllerAbstract->execute() | JROOT/libraries/joomlatools/library/dispatcher/http.php:142 |
10 | KDispatcherHttp->_actionDispatch() | JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:177 |
9 | ComKoowaDispatcherHttp->_actionDispatch() | JROOT/libraries/joomlatools/library/controller/abstract.php:156 |
8 | KControllerAbstract->execute() | JROOT/libraries/joomlatools/library/controller/abstract.php:394 |
7 | KControllerAbstract->__call() | JROOT/components/com_docman/docman.php:10 |
6 | require_once JROOT/components/com_docman/docman.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 |
SELECT language,id
FROM `iwgia_menu`
WHERE home = 1
AND published = 1
AND client_id = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iwgia_menu | ALL | idx_client_id_parent_id_alias_language | NO INDEX KEY COULD BE USED | NULL | NULL | 423 | Using where |
Status | Duration |
---|---|
Starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Executing | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
10 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/Multilanguage.php:107 |
8 | Joomla\CMS\Language\Multilanguage::getSiteHomePages() | JROOT/plugins/system/languagefilter/languagefilter.php:751 |
7 | PlgSystemLanguageFilter->onAfterDispatch() | 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/SiteApplication.php:199 |
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 |
SELECT `c2`.`language`,`c2`.`id`
FROM `iwgia_menu` AS `c`
INNER JOIN `iwgia_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `iwgia_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `iwgia_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 1432
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
Starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.00 ms |
Executing | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/Associations.php:115 |
9 | Joomla\CMS\Language\Associations::getAssociations() | JROOT/administrator/components/com_menus/helpers/menus.php:321 |
8 | MenusHelper::getAssociations() | JROOT/plugins/system/languagefilter/languagefilter.php:768 |
7 | PlgSystemLanguageFilter->onAfterDispatch() | 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/SiteApplication.php:199 |
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 |
SELECT a.*,c.state AS item_status
FROM iwgia_quix_conditions AS a
LEFT JOIN iwgia_quix_collections AS c
ON c.id=a.item_id
WHERE a.item_type = "header"
ORDER BY c.ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
Starting | 0.05 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.05 ms |
Optimizing | 0.02 ms |
Statistics | 0.07 ms |
Preparing | 0.03 ms |
Executing | 0.00 ms |
Sending data | 0.02 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.01 ms |
closing tables | 0.00 ms |
Removing tmp table | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/components/com_quix/helpers/theme.php:182 |
9 | QuixFrontendHelperTheme::getByType() | JROOT/plugins/system/quix/includes/theme.php:54 |
8 | QuixSystemHelperTheme->getItem() | JROOT/plugins/system/quix/quix.php:217 |
7 | plgSystemQuix->onAfterDispatch() | 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/SiteApplication.php:199 |
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 |
SELECT a.*,c.state AS item_status
FROM iwgia_quix_conditions AS a
LEFT JOIN iwgia_quix_collections AS c
ON c.id=a.item_id
WHERE a.item_type = "footer"
ORDER BY c.ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
Starting | 0.09 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 0.13 ms |
Preparing | 0.05 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 5.92 ms |
End of update loop | 0.02 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.05 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/components/com_quix/helpers/theme.php:182 |
9 | QuixFrontendHelperTheme::getByType() | JROOT/plugins/system/quix/includes/theme.php:54 |
8 | QuixSystemHelperTheme->getItem() | JROOT/plugins/system/quix/quix.php:218 |
7 | plgSystemQuix->onAfterDispatch() | 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/SiteApplication.php:199 |
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 |
SELECT c.id AS id, a.name AS asset_name
FROM ( SELECT id,asset_id
FROM iwgia_categories
WHERE extension = 'com_quix'
AND published = 1) AS c
INNER JOIN iwgia_assets AS a
ON c.asset_id = a.id
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iwgia_categories | ref | cat_idx | cat_idx | 203 | const,const | 1 | Using index condition |
1 | SIMPLE | a | eq_ref | PRIMARY | PRIMARY | 4 | benjamin_iwgia-maindb.iwgia_categories.asset_id | 1 |
Status | Duration |
---|---|
Starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.05 ms |
Optimizing | 0.02 ms |
Statistics | 0.06 ms |
Preparing | 0.00 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.06 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
10 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/User/User.php:428 |
8 | Joomla\CMS\User\User->getAuthorisedCategories() | JROOT/plugins/system/quix/quix.php:238 |
7 | plgSystemQuix->onAfterDispatch() | 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/SiteApplication.php:199 |
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 |
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM iwgia_modules AS m
LEFT JOIN iwgia_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN iwgia_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-06-24 09:57:51')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-06-24 09:57:51')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 1432 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
ORDER BY m.position, m.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds,idx_language | published | 1 | const | 1098 | Using index condition; Using where; Using filesort |
1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | benjamin_iwgia-maindb.m.id | 1 | Using where; Using index |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | benjamin_iwgia-maindb.m.module,const | 1 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.00 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
19 | JDatabaseDriverPdo->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/templates/yoo_avanti/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54 |
11 | Warp\Joomla\Helper\WidgetsHelper->count() | JROOT/templates/yoo_avanti/layouts/theme.config.php:19 |
10 | include JROOT/templates/yoo_avanti/layouts/theme.config.php | JROOT/templates/yoo_avanti/layouts/theme.php:10 |
9 | include JROOT/templates/yoo_avanti/layouts/theme.php | JROOT/templates/yoo_avanti/warp/src/Warp/Helper/TemplateHelper.php:49 |
8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_avanti/index.php:16 |
7 | require JROOT/templates/yoo_avanti/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:1076 |
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 |
SELECT a.*
FROM `iwgia_quix_collections` AS `a`
WHERE `a`.`id` = 2
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.04 ms |
checking permissions | 0.00 ms |
closing tables | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.44 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Filling schema table | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
checking permissions | 0.08 ms |
closing tables | 0.02 ms |
checking permissions | 0.00 ms |
Executing | 0.00 ms |
Sending data | 0.03 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Removing tmp table | 0.13 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
19 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
18 | JDatabaseDriver->loadObject() | JROOT/components/com_quix/models/collection.php:78 |
17 | QuixModelCollection->getData() | JROOT/libraries/quixnxt/app/functions.php:433 |
16 | QuixAppHelper::qxGetCollectionInfoById() | JROOT/modules/mod_quix/helper.php:37 |
15 | ModQuixHelper::renderShortCode() | JROOT/modules/mod_quix/mod_quix.php:21 |
14 | include JROOT/modules/mod_quix/mod_quix.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
13 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_avanti/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_avanti/layouts/theme.config.php:41 |
10 | include JROOT/templates/yoo_avanti/layouts/theme.config.php | JROOT/templates/yoo_avanti/layouts/theme.php:10 |
9 | include JROOT/templates/yoo_avanti/layouts/theme.php | JROOT/templates/yoo_avanti/warp/src/Warp/Helper/TemplateHelper.php:49 |
8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_avanti/index.php:16 |
7 | require JROOT/templates/yoo_avanti/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:1076 |
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 |
SELECT title
FROM iwgia_usergroups
WHERE id = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iwgia_usergroups | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.00 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
20 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
19 | JDatabaseDriver->loadResult() | JROOT/components/com_quix/helpers/quix.php:46 |
18 | QuixFrontendHelper::getGroupNameByGroupId() | JROOT/components/com_quix/models/collection.php:99 |
17 | QuixModelCollection->getData() | JROOT/libraries/quixnxt/app/functions.php:433 |
16 | QuixAppHelper::qxGetCollectionInfoById() | JROOT/modules/mod_quix/helper.php:37 |
15 | ModQuixHelper::renderShortCode() | JROOT/modules/mod_quix/mod_quix.php:21 |
14 | include JROOT/modules/mod_quix/mod_quix.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
13 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_avanti/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_avanti/layouts/theme.config.php:41 |
10 | include JROOT/templates/yoo_avanti/layouts/theme.config.php | JROOT/templates/yoo_avanti/layouts/theme.php:10 |
9 | include JROOT/templates/yoo_avanti/layouts/theme.php | JROOT/templates/yoo_avanti/warp/src/Warp/Helper/TemplateHelper.php:49 |
8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_avanti/index.php:16 |
7 | require JROOT/templates/yoo_avanti/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:1076 |
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 |
SHOW FULL COLUMNS
FROM `iwgia_users`
Status | Duration |
---|---|
Starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.01 ms |
Optimizing | 0.02 ms |
Statistics | 0.05 ms |
Preparing | 0.02 ms |
Executing | 0.00 ms |
Sending data | 0.03 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
29 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
28 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/pdomysql.php:334 |
27 | JDatabaseDriverPdomysql->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_quix/models/collection.php:105 |
17 | QuixModelCollection->getData() | JROOT/libraries/quixnxt/app/functions.php:433 |
16 | QuixAppHelper::qxGetCollectionInfoById() | JROOT/modules/mod_quix/helper.php:37 |
15 | ModQuixHelper::renderShortCode() | JROOT/modules/mod_quix/mod_quix.php:21 |
14 | include JROOT/modules/mod_quix/mod_quix.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
13 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_avanti/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_avanti/layouts/theme.config.php:41 |
10 | include JROOT/templates/yoo_avanti/layouts/theme.config.php | JROOT/templates/yoo_avanti/layouts/theme.php:10 |
9 | include JROOT/templates/yoo_avanti/layouts/theme.php | JROOT/templates/yoo_avanti/warp/src/Warp/Helper/TemplateHelper.php:49 |
8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_avanti/index.php:16 |
7 | require JROOT/templates/yoo_avanti/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:1076 |
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 |
SELECT *
FROM `iwgia_users`
WHERE `id` = 1157
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iwgia_users | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.09 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.05 ms |
Optimizing | 0.02 ms |
Statistics | 0.06 ms |
Preparing | 0.02 ms |
Executing | 0.00 ms |
Sending data | 0.18 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.01 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.02 ms |
Updating status | 0.04 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
24 | JDatabaseDriverPdo->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_quix/models/collection.php:105 |
17 | QuixModelCollection->getData() | JROOT/libraries/quixnxt/app/functions.php:433 |
16 | QuixAppHelper::qxGetCollectionInfoById() | JROOT/modules/mod_quix/helper.php:37 |
15 | ModQuixHelper::renderShortCode() | JROOT/modules/mod_quix/mod_quix.php:21 |
14 | include JROOT/modules/mod_quix/mod_quix.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
13 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_avanti/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_avanti/layouts/theme.config.php:41 |
10 | include JROOT/templates/yoo_avanti/layouts/theme.config.php | JROOT/templates/yoo_avanti/layouts/theme.php:10 |
9 | include JROOT/templates/yoo_avanti/layouts/theme.php | JROOT/templates/yoo_avanti/warp/src/Warp/Helper/TemplateHelper.php:49 |
8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_avanti/index.php:16 |
7 | require JROOT/templates/yoo_avanti/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:1076 |
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 |
SELECT `g`.`id`,`g`.`title`
FROM `iwgia_usergroups` AS g
INNER JOIN `iwgia_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 1157
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ref | PRIMARY | PRIMARY | 4 | const | 2 | Using index |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | benjamin_iwgia-maindb.m.group_id | 1 |
Status | Duration |
---|---|
Starting | 0.12 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.06 ms |
Optimizing | 0.05 ms |
Statistics | 0.10 ms |
Preparing | 0.04 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 1.99 ms |
End of update loop | 0.02 ms |
Query end | 0.00 ms |
Commit | 0.01 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.10 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
24 | JDatabaseDriverPdo->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_quix/models/collection.php:105 |
17 | QuixModelCollection->getData() | JROOT/libraries/quixnxt/app/functions.php:433 |
16 | QuixAppHelper::qxGetCollectionInfoById() | JROOT/modules/mod_quix/helper.php:37 |
15 | ModQuixHelper::renderShortCode() | JROOT/modules/mod_quix/mod_quix.php:21 |
14 | include JROOT/modules/mod_quix/mod_quix.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
13 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_avanti/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_avanti/layouts/theme.config.php:41 |
10 | include JROOT/templates/yoo_avanti/layouts/theme.config.php | JROOT/templates/yoo_avanti/layouts/theme.php:10 |
9 | include JROOT/templates/yoo_avanti/layouts/theme.php | JROOT/templates/yoo_avanti/warp/src/Warp/Helper/TemplateHelper.php:49 |
8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_avanti/index.php:16 |
7 | require JROOT/templates/yoo_avanti/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:1076 |
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 |
SELECT *
FROM iwgia_jmap_metainfo
WHERE `linkurl` = 'https://iwgia.org/en/documents-
and-publications.html'
AND `published` = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iwgia_jmap_metainfo | ALL | published | NO INDEX KEY COULD BE USED | NULL | NULL | 288 | Using where |
Status | Duration |
---|---|
Starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.06 ms |
Preparing | 0.03 ms |
Sorting result | 0.06 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 1.56 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
14 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
13 | JDatabaseDriver->loadObject() | JROOT/plugins/system/jmap/jmap.php:407 |
12 | plgSystemJMap->onBeforeCompileHead() | JROOT/libraries/joomla/event/event.php:70 |
11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
10 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
9 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 |
8 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 |
7 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php: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:1090 |
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 |
SELECT m.*
FROM iwgia_modules AS m
LEFT JOIN iwgia_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.client_id = 0
AND m.title = 'AJAX Search'
AND m.access IN (1,1,5)
AND m.published = 1
AND e.enabled = 1
ORDER BY m.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ref | published,newsfeeds | published | 1 | const | 1098 | Using index condition; Using where; Using filesort |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | benjamin_iwgia-maindb.m.module,const | 1 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.04 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.03 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
17 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
16 | JDatabaseDriver->loadObject() | JROOT/plugins/system/modulesanywhere/src/Replace.php:672 |
15 | RegularLabs\Plugin\System\ModulesAnywhere\Replace::getModuleFromDatabase() | JROOT/plugins/system/modulesanywhere/src/Replace.php:555 |
14 | RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModule() | JROOT/plugins/system/modulesanywhere/src/Replace.php:336 |
13 | RegularLabs\Plugin\System\ModulesAnywhere\Replace::processMatch() | JROOT/plugins/system/modulesanywhere/src/Replace.php:216 |
12 | RegularLabs\Plugin\System\ModulesAnywhere\Replace::replaceMatches() | JROOT/plugins/system/modulesanywhere/src/Replace.php:198 |
11 | RegularLabs\Plugin\System\ModulesAnywhere\Replace::replace() | JROOT/plugins/system/modulesanywhere/src/Replace.php:157 |
10 | RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModules() | JROOT/plugins/system/modulesanywhere/src/Replace.php:101 |
9 | RegularLabs\Plugin\System\ModulesAnywhere\Replace::replaceTags() | JROOT/plugins/system/modulesanywhere/modulesanywhere.php:99 |
8 | PlgSystemModulesAnywhere->changeFinalHtmlOutput() | JROOT/libraries/regularlabs/src/SystemPlugin.php:147 |
7 | RegularLabs\Library\SystemPlugin->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:1096 |
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 |
SELECT m.*
FROM iwgia_modules AS m
LEFT JOIN iwgia_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.client_id = 0
AND m.title = 'SoMe-links'
AND m.access IN (1,1,5)
AND m.published = 1
AND e.enabled = 1
ORDER BY m.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ref | published,newsfeeds | published | 1 | const | 1098 | Using index condition; Using where; Using filesort |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | benjamin_iwgia-maindb.m.module,const | 1 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.03 ms |
Executing | 0.00 ms |
Sending data | 0.02 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
17 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
16 | JDatabaseDriver->loadObject() | JROOT/plugins/system/modulesanywhere/src/Replace.php:672 |
15 | RegularLabs\Plugin\System\ModulesAnywhere\Replace::getModuleFromDatabase() | JROOT/plugins/system/modulesanywhere/src/Replace.php:555 |
14 | RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModule() | JROOT/plugins/system/modulesanywhere/src/Replace.php:336 |
13 | RegularLabs\Plugin\System\ModulesAnywhere\Replace::processMatch() | JROOT/plugins/system/modulesanywhere/src/Replace.php:216 |
12 | RegularLabs\Plugin\System\ModulesAnywhere\Replace::replaceMatches() | JROOT/plugins/system/modulesanywhere/src/Replace.php:198 |
11 | RegularLabs\Plugin\System\ModulesAnywhere\Replace::replace() | JROOT/plugins/system/modulesanywhere/src/Replace.php:157 |
10 | RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModules() | JROOT/plugins/system/modulesanywhere/src/Replace.php:101 |
9 | RegularLabs\Plugin\System\ModulesAnywhere\Replace::replaceTags() | JROOT/plugins/system/modulesanywhere/modulesanywhere.php:99 |
8 | PlgSystemModulesAnywhere->changeFinalHtmlOutput() | JROOT/libraries/regularlabs/src/SystemPlugin.php:147 |
7 | RegularLabs\Library\SystemPlugin->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:1096 |
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 |
SELECT *
FROM iwgia_quix_editor_map
WHERE (context = 'com_modules.module' OR context = '0')
AND context_id = 1327
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iwgia_quix_editor_map | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 7 | Using where |
Status | Duration |
---|---|
Starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.02 ms |
Preparing | 0.00 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
23 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
22 | JDatabaseDriver->loadObject() | JROOT/components/com_quix/helpers/editor.php:98 |
21 | QuixFrontendHelperEditor::getInfo() | JROOT/plugins/content/quix/quix.php:256 |
20 | plgContentQuix->onRenderModule() | JROOT/libraries/joomla/event/event.php:70 |
19 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
18 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
17 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Helper/ModuleHelper.php:245 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/modulesanywhere/src/Replace.php:596 |
14 | RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModule() | JROOT/plugins/system/modulesanywhere/src/Replace.php:336 |
13 | RegularLabs\Plugin\System\ModulesAnywhere\Replace::processMatch() | JROOT/plugins/system/modulesanywhere/src/Replace.php:216 |
12 | RegularLabs\Plugin\System\ModulesAnywhere\Replace::replaceMatches() | JROOT/plugins/system/modulesanywhere/src/Replace.php:198 |
11 | RegularLabs\Plugin\System\ModulesAnywhere\Replace::replace() | JROOT/plugins/system/modulesanywhere/src/Replace.php:157 |
10 | RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModules() | JROOT/plugins/system/modulesanywhere/src/Replace.php:101 |
9 | RegularLabs\Plugin\System\ModulesAnywhere\Replace::replaceTags() | JROOT/plugins/system/modulesanywhere/modulesanywhere.php:99 |
8 | PlgSystemModulesAnywhere->changeFinalHtmlOutput() | JROOT/libraries/regularlabs/src/SystemPlugin.php:147 |
7 | RegularLabs\Library\SystemPlugin->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:1096 |
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 |
SELECT *
FROM iwgia_quix_editor_map
WHERE (context = 'com_config.modules' OR context = '0')
AND context_id = 1327
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iwgia_quix_editor_map | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 7 | Using where |
Status | Duration |
---|---|
Starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
23 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
22 | JDatabaseDriver->loadObject() | JROOT/components/com_quix/helpers/editor.php:98 |
21 | QuixFrontendHelperEditor::getInfo() | JROOT/plugins/content/quix/quix.php:259 |
20 | plgContentQuix->onRenderModule() | JROOT/libraries/joomla/event/event.php:70 |
19 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
18 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
17 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Helper/ModuleHelper.php:245 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/modulesanywhere/src/Replace.php:596 |
14 | RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModule() | JROOT/plugins/system/modulesanywhere/src/Replace.php:336 |
13 | RegularLabs\Plugin\System\ModulesAnywhere\Replace::processMatch() | JROOT/plugins/system/modulesanywhere/src/Replace.php:216 |
12 | RegularLabs\Plugin\System\ModulesAnywhere\Replace::replaceMatches() | JROOT/plugins/system/modulesanywhere/src/Replace.php:198 |
11 | RegularLabs\Plugin\System\ModulesAnywhere\Replace::replace() | JROOT/plugins/system/modulesanywhere/src/Replace.php:157 |
10 | RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModules() | JROOT/plugins/system/modulesanywhere/src/Replace.php:101 |
9 | RegularLabs\Plugin\System\ModulesAnywhere\Replace::replaceTags() | JROOT/plugins/system/modulesanywhere/modulesanywhere.php:99 |
8 | PlgSystemModulesAnywhere->changeFinalHtmlOutput() | JROOT/libraries/regularlabs/src/SystemPlugin.php:147 |
7 | RegularLabs\Library\SystemPlugin->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:1096 |
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 |
SELECT sleep_until < '2025-06-24 09:57:51'
FROM iwgia_scheduler_metadata
WHERE type = 'metadata'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iwgia_scheduler_metadata | const | unique_type | unique_type | 98 | const | 1 |
Status | Duration |
---|---|
Starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.00 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
10 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
9 | JDatabaseDriver->loadResult() | JROOT/plugins/system/joomlatoolsscheduler/joomlatoolsscheduler.php:128 |
8 | PlgSystemJoomlatoolsscheduler->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/plugins/system/joomlatoolsscheduler/joomlatoolsscheduler.php:167 |
6 | PlgSystemJoomlatoolsscheduler->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:1096 |
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 |
SELECT *
FROM iwgia_jmap_headings
WHERE `linkurl` = 'https://iwgia.org/en/documents-
and-publications.html'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iwgia_jmap_headings | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.09 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.00 ms |
Executing | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
9 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
8 | JDatabaseDriver->loadObject() | JROOT/plugins/system/jmap/jmap.php:720 |
7 | plgSystemJMap->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:1096 |
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 |
SELECT `alias`
FROM `iwgia_content`
WHERE id = '3260'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iwgia_content | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.02 ms |
Executing | 0.00 ms |
Sending data | 0.03 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
19 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
18 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_multicats/copy/code/com_content/router.php:125 |
17 | ContentRouter->getArticleSegment() | Same as call in the line below. |
16 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
15 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
14 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
13 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
12 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
11 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
10 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
9 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
8 | Joomla\CMS\Router\Route::_() | JROOT/plugins/system/sef/sef.php:110 |
7 | PlgSystemSef->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:1096 |
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 |
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 `iwgia_categories` AS `s`
INNER JOIN `iwgia_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-GB','*')) 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 = 3260
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
Starting | 0.04 ms |
Opening tables | 0.03 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Filling schema table | 0.44 ms |
Executing | 0.01 ms |
Sending data | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Removing tmp table | 0.01 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
21 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
19 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
18 | Joomla\CMS\Categories\Categories->get() | JROOT/administrator/components/com_multicats/copy/code/com_content/router.php:72 |
17 | ContentRouter->getCategorySegment() | Same as call in the line below. |
16 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:124 |
15 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
14 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
13 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
12 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
11 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
10 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
9 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
8 | Joomla\CMS\Router\Route::_() | JROOT/plugins/system/sef/sef.php:110 |
7 | PlgSystemSef->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:1096 |
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 |
SELECT *
FROM iwgia_quix_configs
WHERE (`name` = 'head_code') OR (`name` = 'footer_code')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iwgia_quix_configs | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | Using where |
# | Caller | File and line number |
---|---|---|
10 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
9 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/quix/quix.php:506 |
8 | plgSystemQuix->getQuixInternalConfigs() | JROOT/plugins/system/quix/quix.php:287 |
7 | plgSystemQuix->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:1096 |
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 |
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `iwgia_extensions`
2 × SELECT a.*,c.state AS item_status
FROM iwgia_quix_conditions AS a
LEFT JOIN iwgia_quix_collections AS c
ON c.id=a.item_id
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `iwgia_assets`
2 × SELECT *
FROM iwgia_quix_editor_map
2 × SELECT m.*
FROM iwgia_modules AS m
LEFT JOIN iwgia_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT `data`
FROM `iwgia_session`
1 × SELECT title
FROM iwgia_usergroups
1 × SELECT `c2`.`language`,`c2`.`id`
FROM `iwgia_menu` AS `c`
INNER JOIN `iwgia_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `iwgia_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `iwgia_menu` AS `c2`
ON a2.id = c2.`id`
1 × SELECT c.id AS id, a.name AS asset_name
FROM ( SELECT id,asset_id
FROM iwgia_categories
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM iwgia_modules AS m
LEFT JOIN iwgia_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN iwgia_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT a.*
FROM `iwgia_quix_collections` AS `a`
1 × SELECT `g`.`id`,`g`.`title`
FROM `iwgia_usergroups` AS g
INNER JOIN `iwgia_user_usergroup_map` AS m
ON m.group_id = g.id
1 × SELECT *
FROM `iwgia_users`
1 × SELECT GROUP_CONCAT(c.slug
ORDER BY r.level DESC SEPARATOR '/')
FROM `iwgia_docman_category_relations` as r
INNER JOIN `iwgia_docman_categories` AS c2
ON c2.slug = 'videos'
LEFT JOIN `iwgia_docman_categories` AS c
ON c.docman_category_id = r.ancestor_id
1 × SELECT *
FROM iwgia_jmap_metainfo
1 × SELECT sleep_until < '2025-06-24 09:57:51'
FROM iwgia_scheduler_metadata
1 × SELECT *
FROM iwgia_jmap_headings
1 × SELECT `alias`
FROM `iwgia_content`
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 `iwgia_categories` AS `s`
INNER JOIN `iwgia_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
1 × SELECT language,id
FROM `iwgia_menu`
1 × SELECT GROUP_CONCAT(c.slug
ORDER BY r.level DESC SEPARATOR '/')
FROM `iwgia_docman_category_relations` as r
INNER JOIN `iwgia_docman_categories` AS c2
ON c2.slug = 'iwgia-job-ads'
LEFT JOIN `iwgia_docman_categories` AS c
ON c.docman_category_id = r.ancestor_id
1 × SELECT GROUP_CONCAT(c.slug
ORDER BY r.level DESC SEPARATOR '/')
FROM `iwgia_docman_category_relations` as r
INNER JOIN `iwgia_docman_categories` AS c2
ON c2.slug = 'iwgia-reports'
LEFT JOIN `iwgia_docman_categories` AS c
ON c.docman_category_id = r.ancestor_id
1 × SELECT *
FROM iwgia_extensions
1 × SELECT id, rules
FROM `iwgia_viewlevels
1 × SELECT b.id
FROM iwgia_usergroups AS a
LEFT JOIN iwgia_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM iwgia_extensions
1 × SELECT *
FROM `iwgia_nextend2_section_storage`
1 × SELECT *
FROM iwgia_languages
1 × SELECT `element`,`name`,`client_id`,`extension_id`
FROM `iwgia_extensions`
1 × SELECT `extension_id`
FROM `iwgia_extensions`
1 × SELECT template
FROM iwgia_template_styles
1 × SELECT `session_id`
FROM `iwgia_session`
1 × SELECT id,template
FROM iwgia_template_styles
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 iwgia_menu AS m
LEFT JOIN iwgia_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT id, home, template, s.params
FROM iwgia_template_styles as s
LEFT JOIN iwgia_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT c.docman_category_id AS id, a.name AS asset_name, c.created_by AS owner
FROM iwgia_docman_categories AS c
INNER JOIN iwgia_assets AS a
ON c.asset_id = a.i
1 × SELECT extension_id, params, manifest_cache
FROM iwgia_extensions
1 × SELECT GROUP_CONCAT(c.slug
ORDER BY r.level DESC SEPARATOR '/')
FROM `iwgia_docman_category_relations` as r
INNER JOIN `iwgia_docman_categories` AS c2
ON c2.slug = 'documents'
LEFT JOIN `iwgia_docman_categories` AS c
ON c.docman_category_id = r.ancestor_id
1 × SELECT GROUP_CONCAT(c.slug
ORDER BY r.level DESC SEPARATOR '/')
FROM `iwgia_docman_category_relations` as r
INNER JOIN `iwgia_docman_categories` AS c2
ON c2.slug = ''
LEFT JOIN `iwgia_docman_categories` AS c
ON c.docman_category_id = r.ancestor_id
1 × SELECT *
FROM iwgia_quix_configs
1 × SHOW VARIABLES LIKE 'query_cache_type
1 × SHOW VARIABLES LIKE 'have_profiling
1 × INSERT INTO `iwgia_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6a663971307663756c3266683436347034726b696e7071693330', 1, 1750759070, 0, '', 0
1 × SHOW FULL COLUMNS
FROM `iwgia_extensions
1 × UPDATE `iwgia_extensions`
SET `params` = '{\"mediaversion\":\"03924630dc5399e16fa8a69eeda016e2\"}'
1 × SHOW FULL COLUMNS
FROM `iwgia_users