**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT `data`
FROM `pq26o_session`
WHERE `session_id` = 'd83c99620a58a0b1226d59022e09de9b'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pq26o_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.83 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.13 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
| 14 | JSessionStorageDatabase->read() | **PLG_DEBUG_CALL_STACK_SAME_FILE** |
| 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:758 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
| 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:344 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT `session_id`
FROM `pq26o_session`
WHERE `session_id` = 'd83c99620a58a0b1226d59022e09de9b'
LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pq26o_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
| 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:344 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY**
INSERT INTO `pq26o_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('d83c99620a58a0b1226d59022e09de9b', 1, 1664736488, 0, '', 0)
**PLG_DEBUG_QUERY_EXPLAIN_NOT_POSSIBLE**
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| update | 0.25 ms |
| Waiting for query cache lock | 0.02 ms |
| update | 0.01 ms |
| end | 0.01 ms |
| query end | 0.76 ms |
| closing tables | 0.02 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
| 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:344 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `pq26o_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pq26o_extensions | NULL | ref | extension | extension | 62 | const | 48 | 1.00 | Using where |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.74 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.22 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 1.06 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
| 10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | **PLG_DEBUG_CALL_STACK_SAME_FILE** |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT id, rules
FROM `pq26o_viewlevels`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pq26o_viewlevels | NULL | ALL | NULL | **PLG_DEBUG_WARNING_NO_INDEX** | NULL | NULL | 5 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.86 ms |
| init | 0.02 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.10 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1500 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT b.id
FROM pq26o_usergroups AS a
LEFT JOIN pq26o_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.59 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.30 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM pq26o_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 | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pq26o_extensions | NULL | ref | extension | extension | 62 | const | 165 | 0.60 | Using index condition; Using where; **PLG_DEBUG_WARNING_USING_FILESORT** |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.05 ms |
| preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| Creating sort index | 2.02 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:354 |
| 9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | **PLG_DEBUG_CALL_STACK_SAME_FILE** |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
**PLG_DEBUG_QUERY_DUPLICATES**:
#9SELECT `manifest_cache`
FROM `pq26o_extensions`
WHERE `type` = 'component'
AND `name` = 'com_admintools'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pq26o_extensions | NULL | ref | extension | extension | 62 | const | 48 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.26 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 13 | JDatabaseDriver->loadResult() | JROOT/libraries/fof30/Container/Container.php:787 |
| 12 | FOF30\Container\Container->getDefaultMediaVersion() | JROOT/libraries/fof30/Container/Container.php:675 |
| 11 | FOF30\Container\Container->__construct() | JROOT/libraries/fof30/Container/Container.php:159 |
| 10 | FOF30\Container\Container::makeInstance() | JROOT/libraries/fof30/Container/Container.php:140 |
| 9 | FOF30\Container\Container::getInstance() | JROOT/plugins/system/admintools/admintools/main.php:818 |
| 8 | plgSystemAdmintools->initialize() | JROOT/plugins/system/admintools/admintools/main.php:110 |
| 7 | plgSystemAdmintools->__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:625 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
**PLG_DEBUG_QUERY_DUPLICATES**:
#8SELECT `manifest_cache`
FROM `pq26o_extensions`
WHERE `type` = 'component'
AND `name` = 'com_admintools'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pq26o_extensions | NULL | ref | extension | extension | 62 | const | 48 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.15 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 13 | JDatabaseDriver->loadResult() | JROOT/libraries/fof30/Container/Container.php:787 |
| 12 | FOF30\Container\Container->getDefaultMediaVersion() | JROOT/libraries/fof30/Container/Container.php:675 |
| 11 | FOF30\Container\Container->__construct() | JROOT/libraries/fof30/Container/Container.php:290 |
| 10 | FOF30\Container\Container::makeInstance() | JROOT/libraries/fof30/Container/Container.php:140 |
| 9 | FOF30\Container\Container::getInstance() | JROOT/plugins/system/admintools/admintools/main.php:818 |
| 8 | plgSystemAdmintools->initialize() | JROOT/plugins/system/admintools/admintools/main.php:110 |
| 7 | plgSystemAdmintools->__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:625 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT `value`
FROM `pq26o_admintools_storage`
WHERE `key` = 'cparams'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pq26o_admintools_storage | NULL | const | PRIMARY | PRIMARY | 402 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.56 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.08 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 13 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_admintools/Helper/Storage.php:123 |
| 12 | Akeeba\AdminTools\Admin\Helper\Storage->load() | JROOT/administrator/components/com_admintools/Helper/Storage.php:53 |
| 11 | Akeeba\AdminTools\Admin\Helper\Storage->__construct() | JROOT/administrator/components/com_admintools/Helper/Storage.php:41 |
| 10 | Akeeba\AdminTools\Admin\Helper\Storage::getInstance() | JROOT/plugins/system/admintools/admintools/main.php:278 |
| 9 | plgSystemAdmintools->loadComponentParameters() | JROOT/plugins/system/admintools/admintools/main.php:836 |
| 8 | plgSystemAdmintools->initialize() | JROOT/plugins/system/admintools/admintools/main.php:110 |
| 7 | plgSystemAdmintools->__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:625 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT *
FROM `pq26o_admintools_wafexceptions`
WHERE NOT(`option` LIKE 'com_%')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pq26o_admintools_wafexceptions | NULL | ALL | NULL | **PLG_DEBUG_WARNING_NO_INDEX** | NULL | NULL | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.50 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.07 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1500 |
| 11 | JDatabaseDriver->loadAssocList() | JROOT/plugins/system/admintools/admintools/main.php:554 |
| 10 | plgSystemAdmintools->loadWAFExceptionsSEF() | JROOT/plugins/system/admintools/admintools/main.php:465 |
| 9 | plgSystemAdmintools->loadWAFExceptions() | JROOT/plugins/system/admintools/admintools/main.php:848 |
| 8 | plgSystemAdmintools->initialize() | JROOT/plugins/system/admintools/admintools/main.php:110 |
| 7 | plgSystemAdmintools->__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:625 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SHOW VARIABLES LIKE "collation_database"
**PLG_DEBUG_QUERY_EXPLAIN_NOT_POSSIBLE**
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.02 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 2.29 ms |
| end | 0.04 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| removing tmp table | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
| 12 | JDatabaseDriver->loadObject() | JROOT/libraries/joomla/database/driver/mysqli.php:342 |
| 11 | JDatabaseDriverMysqli->getCollation() | JROOT/plugins/system/admintools/feature/utf8mb4.php:28 |
| 10 | AtsystemFeatureUtf8mb4->onAfterInitialise() | JROOT/plugins/system/admintools/admintools/main.php:715 |
| 9 | plgSystemAdmintools->runFeature() | JROOT/plugins/system/admintools/admintools/main.php:135 |
| 8 | plgSystemAdmintools->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:626 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT `source`,`keepurlparams`
FROM `pq26o_admintools_redirects`
WHERE ((`dest` = 'tag/199-timisoara') OR (`dest` = 'tag/199-timisoara') OR ('tag/199-timisoara' LIKE `dest`))
AND `published` = '1'
ORDER BY `ordering` DESC
LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pq26o_admintools_redirects | NULL | ALL | NULL | **PLG_DEBUG_WARNING_NO_INDEX** | NULL | NULL | 1 | 100.00 | Using where; **PLG_DEBUG_WARNING_USING_FILESORT** |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.52 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.09 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1767 |
| 11 | JDatabaseDriver->loadRow() | JROOT/plugins/system/admintools/feature/urlredir.php:89 |
| 10 | AtsystemFeatureUrlredir->onAfterInitialise() | JROOT/plugins/system/admintools/admintools/main.php:715 |
| 9 | plgSystemAdmintools->runFeature() | JROOT/plugins/system/admintools/admintools/main.php:135 |
| 8 | plgSystemAdmintools->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:626 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT *
FROM pq26o_languages
ORDER BY ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pq26o_languages | NULL | ALL | NULL | **PLG_DEBUG_WARNING_NO_INDEX** | NULL | NULL | 2 | 100.00 | **PLG_DEBUG_WARNING_USING_FILESORT** |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.73 ms |
| init | 0.04 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.24 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_sh404sef/helpers/language.php:212 |
| 12 | Sh404sefHelperLanguage::getAllContentLanguages() | JROOT/administrator/components/com_sh404sef/helpers/language.php:164 |
| 11 | Sh404sefHelperLanguage::getUrlCodeFromTag() | JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:84 |
| 10 | Sh404sefClassPageinfo->setCurrentLanguage() | JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:100 |
| 9 | Sh404sefClassPageinfo->init() | JROOT/plugins/system/sh404sef/sh404sef.php:60 |
| 8 | plgSystemSh404sef->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:626 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
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 pq26o_menu AS m
LEFT JOIN pq26o_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 | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 49 | 3.33 | Using index condition; Using where; **PLG_DEBUG_WARNING_USING_FILESORT** |
| 1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | feroviar_web2019fv.m.component_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.86 ms |
| init | 0.05 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.11 ms |
| preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.55 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
| 19 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | **PLG_DEBUG_CALL_STACK_SAME_FILE** |
| 18 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 17 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
| 16 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:76 |
| 15 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
| 14 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:131 |
| 13 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:375 |
| 12 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
| 11 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:130 |
| 10 | Sh404sefClassPageinfo->loadHomepages() | JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:102 |
| 9 | Sh404sefClassPageinfo->init() | JROOT/plugins/system/sh404sef/sh404sef.php:60 |
| 8 | plgSystemSh404sef->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:626 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT `params`
FROM pq26o_extensions
WHERE `element`='com_sh404sef'
AND `type`='component';
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pq26o_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.12 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.06 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 15 | JDatabaseDriver->loadResult() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:714 |
| 14 | ShlDbClass->loadResult() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:363 |
| 13 | ShlDbClass->shlLoadResult() | JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483 |
| 12 | ShlDbHelper::selectResult() | JROOT/administrator/components/com_sh404sef/helpers/general.php:143 |
| 11 | Sh404sefHelperGeneral::getComponentParams() | JROOT/administrator/components/com_sh404sef/classes/config.php:636 |
| 10 | Sh404sefClassConfig->__construct() | JROOT/administrator/components/com_sh404sef/sh404seffactory.php:119 |
| 9 | Sh404sefFactory::getConfig() | JROOT/plugins/system/sh404sef/sh404sef.php:83 |
| 8 | plgSystemSh404sef->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:626 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT `id`,`alias`,`newurl`,`hits`
FROM `pq26o_sh404sef_aliases`
WHERE `alias` = 'tag/199-timisoara'
order by `alias` desc
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pq26o_sh404sef_aliases | NULL | ref | alias | alias | 767 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.27 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.09 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
| 13 | JDatabaseDriver->loadObject() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:655 |
| 12 | ShlDbClass->loadObject() | JROOT/administrator/components/com_sh404sef/classes/router.php:617 |
| 11 | Sh404sefClassRouterInternal->_checkAliases() | JROOT/administrator/components/com_sh404sef/classes/router.php:249 |
| 10 | Sh404sefClassRouterInternal->preprocessParseRule() | **PLG_DEBUG_CALL_STACK_SAME_FILE** |
| 9 | call_user_func_array() | JROOT/libraries/src/Router/Router.php:596 |
| 8 | Joomla\CMS\Router\Router->processParseRules() | JROOT/libraries/src/Router/SiteRouter.php:593 |
| 7 | Joomla\CMS\Router\SiteRouter->processParseRules() | JROOT/libraries/src/Router/Router.php:212 |
| 6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
| 5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1074 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT *
FROM pq26o_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pq26o_languages | NULL | ALL | NULL | **PLG_DEBUG_WARNING_NO_INDEX** | NULL | NULL | 2 | 50.00 | Using where; **PLG_DEBUG_WARNING_USING_FILESORT** |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.04 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.02 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.08 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.02 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
| 17 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/administrator/components/com_sh404sef/classes/router.php:1645 |
| 16 | Sh404sefClassRouterInternal->_getSimpleSefLanguageSefCode() | JROOT/administrator/components/com_sh404sef/classes/router.php:1614 |
| 15 | Sh404sefClassRouterInternal->_isSimpleEncodingSef() | JROOT/administrator/components/com_sh404sef/classes/router.php:1560 |
| 14 | Sh404sefClassRouterInternal->_lookupSef() | JROOT/administrator/components/com_sh404sef/classes/router.php:1262 |
| 13 | Sh404sefClassRouterInternal->_parseSefRouteInternal() | JROOT/administrator/components/com_sh404sef/classes/router.php:2158 |
| 12 | Sh404sefClassRouter->_parseSefRoute() | JROOT/administrator/components/com_sh404sef/classes/router.php:383 |
| 11 | Sh404sefClassRouterInternal->parseRule() | **PLG_DEBUG_CALL_STACK_SAME_FILE** |
| 10 | call_user_func_array() | JROOT/libraries/src/Router/Router.php:596 |
| 9 | Joomla\CMS\Router\Router->processParseRules() | JROOT/libraries/src/Router/SiteRouter.php:593 |
| 8 | Joomla\CMS\Router\SiteRouter->processParseRules() | JROOT/libraries/src/Router/Router.php:570 |
| 7 | Joomla\CMS\Router\Router->_processParseRules() | JROOT/libraries/src/Router/Router.php:216 |
| 6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
| 5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1074 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT `oldurl`, `newurl`, `dateadd`, `id`, `cpt`, `rank`
FROM pq26o_sh404sef_urls
WHERE `oldurl`='tag/199-timisoara'
ORDER BY `rank`;
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pq26o_sh404sef_urls | NULL | ref | oldurl | oldurl | 767 | const | 2 | 100.00 | Using index condition; **PLG_DEBUG_WARNING_USING_FILESORT** |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.50 ms |
| init | 0.05 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.46 ms |
| preparing | 0.05 ms |
| Sorting result | 0.02 ms |
| executing | 0.02 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.80 ms |
| end | 0.03 ms |
| query end | 0.03 ms |
| closing tables | 0.02 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.02 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:688 |
| 18 | ShlDbClass->loadObjectList() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:470 |
| 17 | ShlDbClass->shlLoadObjectList() | JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:686 |
| 16 | ShlDbHelper::selectObjectList() | JROOT/administrator/components/com_sh404sef/models/sefurls.php:103 |
| 15 | Sh404sefModelSefurls->getNonSefUrlRecordFromDatabase() | JROOT/administrator/components/com_sh404sef/classes/router.php:1574 |
| 14 | Sh404sefClassRouterInternal->_lookupSef() | JROOT/administrator/components/com_sh404sef/classes/router.php:1262 |
| 13 | Sh404sefClassRouterInternal->_parseSefRouteInternal() | JROOT/administrator/components/com_sh404sef/classes/router.php:2158 |
| 12 | Sh404sefClassRouter->_parseSefRoute() | JROOT/administrator/components/com_sh404sef/classes/router.php:383 |
| 11 | Sh404sefClassRouterInternal->parseRule() | **PLG_DEBUG_CALL_STACK_SAME_FILE** |
| 10 | call_user_func_array() | JROOT/libraries/src/Router/Router.php:596 |
| 9 | Joomla\CMS\Router\Router->processParseRules() | JROOT/libraries/src/Router/SiteRouter.php:593 |
| 8 | Joomla\CMS\Router\SiteRouter->processParseRules() | JROOT/libraries/src/Router/Router.php:570 |
| 7 | Joomla\CMS\Router\Router->_processParseRules() | JROOT/libraries/src/Router/Router.php:216 |
| 6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
| 5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1074 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY**
UPDATE `pq26o_sh404sef_urls`
SET `cpt`=2432, `last_hit`='2022-10-02 18:48:08'
WHERE `id`='12633'
AND `rank`=0;
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | UPDATE | pq26o_sh404sef_urls | NULL | range | PRIMARY,rank | PRIMARY | 4 | const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.04 ms |
| System lock | 0.38 ms |
| updating | 0.32 ms |
| end | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| end | 0.02 ms |
| query end | 0.44 ms |
| closing tables | 0.03 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.02 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/shlib/shl_packages/system/abstractdecorator.php:41 |
| 17 | ShlSystem_Abstractdecorator->__call() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:499 |
| 16 | ShlDbClass->shlExecute() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:488 |
| 15 | ShlDbClass->shlQuery() | JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:797 |
| 14 | ShlDbHelper::update() | JROOT/administrator/components/com_sh404sef/classes/router.php:1277 |
| 13 | Sh404sefClassRouterInternal->_parseSefRouteInternal() | JROOT/administrator/components/com_sh404sef/classes/router.php:2158 |
| 12 | Sh404sefClassRouter->_parseSefRoute() | JROOT/administrator/components/com_sh404sef/classes/router.php:383 |
| 11 | Sh404sefClassRouterInternal->parseRule() | **PLG_DEBUG_CALL_STACK_SAME_FILE** |
| 10 | call_user_func_array() | JROOT/libraries/src/Router/Router.php:596 |
| 9 | Joomla\CMS\Router\Router->processParseRules() | JROOT/libraries/src/Router/SiteRouter.php:593 |
| 8 | Joomla\CMS\Router\SiteRouter->processParseRules() | JROOT/libraries/src/Router/Router.php:570 |
| 7 | Joomla\CMS\Router\Router->_processParseRules() | JROOT/libraries/src/Router/Router.php:216 |
| 6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
| 5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1074 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT `id`,`name`,`rules`,`parent_id`
FROM `pq26o_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_advancedmodules','com_ajax','com_akeeba','com_allvideoshare','com_associations','com_attachments','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jch_optimize','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_obrss','com_phocadownload','com_plugins','com_postinstall','com_privacy','com_redirect','com_regularlabsmanager','com_search','com_seoglossary','com_sh404sef','com_sitemapgenerator','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pq26o_assets | NULL | range | idx_asset_name | idx_asset_name | 152 | NULL | 49 | 100.00 | Using index condition |
| Status | Duration |
|---|
| starting | 0.20 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.64 ms |
| init | 0.15 ms |
| System lock | 0.02 ms |
| optimizing | 0.03 ms |
| statistics | 0.27 ms |
| preparing | 0.04 ms |
| executing | 0.02 ms |
| Sending data | 1.69 ms |
| end | 0.03 ms |
| query end | 0.04 ms |
| closing tables | 0.03 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.02 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 15 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 14 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 13 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 12 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 11 | Joomla\CMS\User\User->authorise() | JROOT/plugins/system/advancedmodules/src/Document.php:30 |
| 10 | RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript() | JROOT/plugins/system/advancedmodules/advancedmodules.php:97 |
| 9 | PlgSystemAdvancedModules->handleOnAfterRoute() | JROOT/libraries/regularlabs/src/SystemPlugin.php:166 |
| 8 | RegularLabs\Library\SystemPlugin->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:1122 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT `id`, `name`,`alias`, `use_feedburner`, `uri`, `feed_type`
FROM `pq26o_obrss`
WHERE `published` = 1
AND `feeded` = 1
ORDER BY `ordering`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pq26o_obrss | NULL | ALL | NULL | **PLG_DEBUG_WARNING_NO_INDEX** | NULL | NULL | 3 | 33.33 | Using where; **PLG_DEBUG_WARNING_USING_FILESORT** |
| Status | Duration |
|---|
| starting | 0.10 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.33 ms |
| init | 0.05 ms |
| System lock | 0.02 ms |
| optimizing | 0.03 ms |
| statistics | 0.04 ms |
| preparing | 0.03 ms |
| Sorting result | 0.02 ms |
| executing | 0.02 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.09 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.02 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/obrss/obrss.php:40 |
| 8 | plgSystemobrss->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:1122 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `pq26o_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pq26o_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.04 ms |
| System lock | 0.02 ms |
| optimizing | 0.03 ms |
| statistics | 0.12 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.07 ms |
| end | 0.02 ms |
| query end | 0.03 ms |
| closing tables | 0.02 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.02 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
| 18 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
| 17 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | **PLG_DEBUG_CALL_STACK_SAME_FILE** |
| 16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
| 14 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
| 13 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
| 12 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
| 11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/obrss/obrss.php:78 |
| 8 | plgSystemobrss->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:1122 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY**
UPDATE `pq26o_extensions`
SET `params` = '{\"mediaversion\":\"52262de6d9ec33ab87cc00619e395105\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | UPDATE | pq26o_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.04 ms |
| System lock | 0.10 ms |
| updating | 0.14 ms |
| end | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| end | 0.02 ms |
| query end | 0.44 ms |
| closing tables | 0.03 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.02 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
| 13 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
| 12 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
| 11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/obrss/obrss.php:78 |
| 8 | plgSystemobrss->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:1122 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT id, home, template, s.params
FROM pq26o_template_styles as s
LEFT JOIN pq26o_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 | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | ALL | idx_template | **PLG_DEBUG_WARNING_NO_INDEX** | NULL | NULL | 8 | 12.50 | Using where |
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 303 | feroviar_web2019fv.s.template,const | 1 | 4.36 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.16 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.61 ms |
| init | 0.10 ms |
| System lock | 0.04 ms |
| optimizing | 0.06 ms |
| statistics | 0.18 ms |
| preparing | 0.07 ms |
| executing | 0.02 ms |
| Sending data | 0.37 ms |
| end | 0.02 ms |
| query end | 0.03 ms |
| closing tables | 0.03 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.02 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 5 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
| 4 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/libraries/src/Application/SiteApplication.php:168 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT *
FROM `pq26o_content_types`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pq26o_content_types | NULL | ALL | NULL | **PLG_DEBUG_WARNING_NO_INDEX** | NULL | NULL | 15 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.42 ms |
| init | 0.04 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.02 ms |
| preparing | 0.02 ms |
| executing | 0.02 ms |
| Sending data | 0.42 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.02 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1500 |
| 18 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Helper/TagsHelper.php:794 |
| 17 | Joomla\CMS\Helper\TagsHelper::getTypes() | JROOT/libraries/src/Helper/TagsHelper.php:628 |
| 16 | Joomla\CMS\Helper\TagsHelper->getTagItemsQuery() | JROOT/components/com_tags/models/tag.php:149 |
| 15 | TagsModelTag->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:133 |
| 14 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 13 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_tags/models/tag.php:86 |
| 12 | TagsModelTag->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_tags/views/tag/view.html.php:93 |
| 10 | TagsViewTag->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_tags/controller.php:52 |
| 8 | TagsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tags/tags.php:15 |
| 6 | require_once JROOT/components/com_tags/tags.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM pq26o_contentitem_tag_map AS m
INNER JOIN pq26o_ucm_content AS c
ON m.type_alias = c.core_type_alias
AND m.core_content_id = c.core_content_id
AND c.core_state IN (1)
AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2022-10-02 18:48:08')
AND (c.core_publish_down = '0000-00-00 00:00:00' OR c.core_publish_down >= '2022-10-02 18:48:08')
INNER JOIN pq26o_content_types AS ct
ON ct.type_alias = m.type_alias
LEFT JOIN pq26o_categories AS tc
ON tc.id = c.core_catid
LEFT JOIN pq26o_users AS ua
ON ua.id = c.core_created_user_id
WHERE m.tag_id IN (199)
AND (c.core_catid = 0 OR tc.published = 1)
AND m.type_alias IN ('com_content.article','com_weblinks.weblink','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_weblinks.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category')
AND c.core_access IN (0,1,5)
GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, author, author_email
ORDER BY MAX(`c`.`core_title`) ASC
LIMIT 20
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ref | idx_tag_type,idx_core_content_id | idx_tag_type | 4 | const | 22 | 50.00 | Using where; Using temporary; **PLG_DEBUG_WARNING_USING_FILESORT** |
| 1 | SIMPLE | ct | NULL | ref | idx_alias | idx_alias | 302 | feroviar_web2019fv.m.type_alias | 1 | 100.00 | Using where |
| 1 | SIMPLE | c | NULL | eq_ref | PRIMARY,tag_idx,idx_access,idx_content_type | PRIMARY | 4 | feroviar_web2019fv.m.core_content_id | 1 | 5.00 | Using where |
| 1 | SIMPLE | tc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | feroviar_web2019fv.c.core_catid | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | feroviar_web2019fv.c.core_created_user_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.35 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| Opening tables | 1.69 ms |
| init | 0.30 ms |
| System lock | 0.02 ms |
| optimizing | 0.05 ms |
| statistics | 0.66 ms |
| preparing | 0.09 ms |
| Creating tmp table | 0.12 ms |
| Sorting result | 0.02 ms |
| executing | 0.02 ms |
| Sending data | 8.46 ms |
| Creating sort index | 1.04 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| removing tmp table | 0.09 ms |
| query end | 0.01 ms |
| closing tables | 0.04 ms |
| freeing items | 0.06 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 13 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_tags/models/tag.php:86 |
| 12 | TagsModelTag->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_tags/views/tag/view.html.php:93 |
| 10 | TagsViewTag->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_tags/controller.php:52 |
| 8 | TagsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tags/tags.php:15 |
| 6 | require_once JROOT/components/com_tags/tags.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SHOW FULL COLUMNS
FROM `pq26o_tags`
**PLG_DEBUG_QUERY_EXPLAIN_NOT_POSSIBLE**
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.21 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.02 ms |
| executing | 0.02 ms |
| Opening tables | 0.40 ms |
| checking permissions | 0.05 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| Sending data | 0.18 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| removing tmp table | 0.05 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 17 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 16 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 15 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_tags/tables/tag.php:29 |
| 14 | TagsTableTag->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 13 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_tags/models/tag.php:272 |
| 12 | TagsModelTag->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_tags/views/tag/view.html.php:94 |
| 10 | TagsViewTag->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_tags/controller.php:52 |
| 8 | TagsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tags/tags.php:15 |
| 6 | require_once JROOT/components/com_tags/tags.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
**PLG_DEBUG_QUERY_DUPLICATES**:
#63SELECT *
FROM pq26o_tags
WHERE `id` = '199'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pq26o_tags | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.05 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.13 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.05 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1459 |
| 14 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
| 13 | Joomla\CMS\Table\Table->load() | JROOT/components/com_tags/models/tag.php:281 |
| 12 | TagsModelTag->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_tags/views/tag/view.html.php:94 |
| 10 | TagsViewTag->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_tags/controller.php:52 |
| 8 | TagsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tags/tags.php:15 |
| 6 | require_once JROOT/components/com_tags/tags.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM pq26o_contentitem_tag_map AS m
INNER JOIN pq26o_ucm_content AS c
ON m.type_alias = c.core_type_alias
AND m.core_content_id = c.core_content_id
AND c.core_state IN (1)
AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2022-10-02 18:48:08')
AND (c.core_publish_down = '0000-00-00 00:00:00' OR c.core_publish_down >= '2022-10-02 18:48:08')
INNER JOIN pq26o_content_types AS ct
ON ct.type_alias = m.type_alias
LEFT JOIN pq26o_categories AS tc
ON tc.id = c.core_catid
LEFT JOIN pq26o_users AS ua
ON ua.id = c.core_created_user_id
WHERE m.tag_id IN (199)
AND (c.core_catid = 0 OR tc.published = 1)
AND m.type_alias IN ('com_content.article','com_weblinks.weblink','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_weblinks.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category')
AND c.core_access IN (0,1,5)
GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, author, author_email
ORDER BY MAX(`c`.`core_title`) ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ref | idx_tag_type,idx_core_content_id | idx_tag_type | 4 | const | 22 | 50.00 | Using where; Using temporary; **PLG_DEBUG_WARNING_USING_FILESORT** |
| 1 | SIMPLE | ct | NULL | ref | idx_alias | idx_alias | 302 | feroviar_web2019fv.m.type_alias | 1 | 100.00 | Using where |
| 1 | SIMPLE | c | NULL | eq_ref | PRIMARY,tag_idx,idx_access,idx_content_type | PRIMARY | 4 | feroviar_web2019fv.m.core_content_id | 1 | 5.00 | Using where |
| 1 | SIMPLE | tc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | feroviar_web2019fv.c.core_catid | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | feroviar_web2019fv.c.core_created_user_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.30 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| init | 0.25 ms |
| System lock | 0.02 ms |
| optimizing | 0.04 ms |
| statistics | 0.27 ms |
| preparing | 0.07 ms |
| Creating tmp table | 0.08 ms |
| Sorting result | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 2.14 ms |
| Creating sort index | 1.06 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| removing tmp table | 0.07 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.06 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:353 |
| 14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT/libraries/src/MVC/Model/ListModel.php:282 |
| 13 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:232 |
| 12 | Joomla\CMS\MVC\Model\ListModel->getPagination() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_tags/views/tag/view.html.php:97 |
| 10 | TagsViewTag->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_tags/controller.php:52 |
| 8 | TagsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tags/tags.php:15 |
| 6 | require_once JROOT/components/com_tags/tags.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
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 `pq26o_categories` AS `s`
INNER JOIN `pq26o_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 26
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | **PLG_DEBUG_WARNING_USING_FILESORT** |
| 1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access,idx_left_right | **PLG_DEBUG_WARNING_NO_INDEX** | NULL | NULL | 36 | 39.04 | Using where |
| Status | Duration |
|---|
| starting | 0.20 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.08 ms |
| init | 0.09 ms |
| System lock | 0.02 ms |
| optimizing | 0.04 ms |
| statistics | 0.26 ms |
| preparing | 0.04 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.04 ms |
| Creating sort index | 0.18 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 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_fields/models/fields.php:203 |
| 17 | FieldsModelFields->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:133 |
| 16 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:135 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:478 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_tags/views/tag/view.html.php:146 |
| 10 | TagsViewTag->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_tags/controller.php:52 |
| 8 | TagsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tags/tags.php:15 |
| 6 | require_once JROOT/components/com_tags/tags.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM pq26o_fields AS a
LEFT JOIN `pq26o_languages` AS l
ON l.lang_code = a.language
LEFT JOIN pq26o_users AS uc
ON uc.id=a.checked_out
LEFT JOIN pq26o_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN pq26o_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN pq26o_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `pq26o_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (26,0,16))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using index condition; Using where; **PLG_DEBUG_WARNING_USING_FILESORT** |
| 1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 21 | feroviar_web2019fv.a.language | 1 | 100.00 | NULL |
| 1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | feroviar_web2019fv.a.checked_out | 1 | 100.00 | NULL |
| 1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | feroviar_web2019fv.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | feroviar_web2019fv.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | feroviar_web2019fv.a.group_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | feroviar_web2019fv.a.id | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.20 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.84 ms |
| init | 0.12 ms |
| System lock | 0.02 ms |
| optimizing | 0.04 ms |
| statistics | 0.22 ms |
| preparing | 0.06 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.04 ms |
| Creating sort index | 0.05 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.03 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 16 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:135 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:478 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_tags/views/tag/view.html.php:146 |
| 10 | TagsViewTag->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_tags/controller.php:52 |
| 8 | TagsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tags/tags.php:15 |
| 6 | require_once JROOT/components/com_tags/tags.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SHOW FULL COLUMNS
FROM `pq26o_sh404sef_metas`
**PLG_DEBUG_QUERY_EXPLAIN_NOT_POSSIBLE**
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.21 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.02 ms |
| executing | 0.02 ms |
| Opening tables | 0.33 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| Sending data | 0.20 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| removing tmp table | 0.05 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 21 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 20 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 19 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_sh404sef/tables/metas.php:127 |
| 18 | Sh404sefTableMetas->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 17 | Joomla\CMS\Table\Table::getInstance() | JROOT/administrator/components/com_sh404sef/models/metas.php:33 |
| 16 | Sh404sefModelMetas->getCustomMetaData() | JROOT/administrator/components/com_sh404sef/helpers/metadata.php:89 |
| 15 | Sh404sefHelperMetadata::getCustomMetaDataFromDb() | JROOT/plugins/system/sh404sef/sh404sef.php:376 |
| 14 | plgSystemSh404sef->searchOGPImage() | JROOT/plugins/system/sh404sef/sh404sef.php:260 |
| 13 | plgSystemSh404sef->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_tags/views/tag/view.html.php:146 |
| 10 | TagsViewTag->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_tags/controller.php:52 |
| 8 | TagsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tags/tags.php:15 |
| 6 | require_once JROOT/components/com_tags/tags.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT *
FROM pq26o_sh404sef_metas
WHERE `newurl`='index.php?option=com_tags&id=199&lang=ro&view=tag';
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | pq26o_sh404sef_metas | NULL | ref | newurl | newurl | 767 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.05 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.10 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.08 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
| 20 | JDatabaseDriver->loadObject() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:655 |
| 19 | ShlDbClass->loadObject() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:451 |
| 18 | ShlDbClass->shlLoadObject() | JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655 |
| 17 | ShlDbHelper::selectObject() | JROOT/administrator/components/com_sh404sef/models/metas.php:34 |
| 16 | Sh404sefModelMetas->getCustomMetaData() | JROOT/administrator/components/com_sh404sef/helpers/metadata.php:89 |
| 15 | Sh404sefHelperMetadata::getCustomMetaDataFromDb() | JROOT/plugins/system/sh404sef/sh404sef.php:376 |
| 14 | plgSystemSh404sef->searchOGPImage() | JROOT/plugins/system/sh404sef/sh404sef.php:260 |
| 13 | plgSystemSh404sef->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_tags/views/tag/view.html.php:146 |
| 10 | TagsViewTag->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_tags/controller.php:52 |
| 8 | TagsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tags/tags.php:15 |
| 6 | require_once JROOT/components/com_tags/tags.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT t.*
FROM pq26o_seoglossary t
LEFT JOIN pq26o_seoglossaries g
ON t.catid = g.id
WHERE t.state = 1
AND g.state = 1
AND ( LOWER('Trenul Interregio Timişoara – Bucureşti, care a plecat din Timişoara la ora 13.49, a oprit după doar 30 de km parcurşi, staţionând în gara din Recaş aproape trei ore. În aceeaşi gară staţiona deja de două ore un tren care trebuia să plece la 12.50 din Timişoara şi care a plecat cu 50 de minute întârziere.\r\nSute de călători ai trenurilor Timişoara – Caransebeş şi Budapesta – Timişoara – Bucureşti au fost blocaţi ore întregi în gara din Recaş, aflată la 30 de km de Timişoara. Primul care a oprit în Recaş a fost trenul regio (personal) Timişoara – Drobeta – Turnu Severin, care trebuia să plece din Timişoara la ora 12.50.\r\nCălătorii au declarat că trenul a plecat cu aproximativ 50 de minute întârziere pentru că nu era curent la liniile de tensiune care alimentau garnitura. Plecat, aşadar, cu o întârziere de aproape o oră, trenul a oprit în gara din Recaş de unde nu a mai pornit până după ora 14.00, când a fost ajuns din urmă de trenul Interregio Budapesta-Timişoara-Bucureşti.\r\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR 'Trenul Interregio Timişoara – Bucureşti, care a plecat din Timişoara la ora 13.49, a oprit după doar 30 de km parcurşi, staţionând în gara din Recaş aproape trei ore. În aceeaşi gară staţiona deja de două ore un tren care trebuia să plece la 12.50 din Timişoara şi care a plecat cu 50 de minute întârziere.\r\nSute de călători ai trenurilor Timişoara – Caransebeş şi Budapesta – Timişoara – Bucureşti au fost blocaţi ore întregi în gara din Recaş, aflată la 30 de km de Timişoara. Primul care a oprit în Recaş a fost trenul regio (personal) Timişoara – Drobeta – Turnu Severin, care trebuia să plece din Timişoara la ora 12.50.\r\nCălătorii au declarat că trenul a plecat cu aproximativ 50 de minute întârziere pentru că nu era curent la liniile de tensiune care alimentau garnitura. Plecat, aşadar, cu o întârziere de aproape o oră, trenul a oprit în gara din Recaş de unde nu a mai pornit până după ora 14.00, când a fost ajuns din urmă de trenul Interregio Budapesta-Timişoara-Bucureşti.\r\n' REGEXP REPLACE(REPLACE(tsynonyms, ', ', '|'), ',', '|') )
AND ( g.language LIKE 'ro-RO' OR g.language = '*' )
ORDER BY ordering;
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | g | NULL | system | PRIMARY | **PLG_DEBUG_WARNING_NO_INDEX** | NULL | NULL | 1 | 100.00 | **PLG_DEBUG_WARNING_USING_FILESORT** |
| 1 | SIMPLE | t | NULL | ALL | NULL | **PLG_DEBUG_WARNING_NO_INDEX** | NULL | NULL | 139 | 1.00 | Using where |
| Status | Duration |
|---|
| starting | 0.21 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.30 ms |
| init | 0.13 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.05 ms |
| preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.03 ms |
| Creating sort index | 2.68 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.03 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/content/seoglossary/seoglossary.php:281 |
| 13 | plgContentSeoglossary->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_tags/views/tag/view.html.php:146 |
| 10 | TagsViewTag->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_tags/controller.php:52 |
| 8 | TagsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tags/tags.php:15 |
| 6 | require_once JROOT/components/com_tags/tags.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT t.*
FROM pq26o_seoglossary t
LEFT JOIN pq26o_seoglossaries g
ON t.catid = g.id
WHERE t.state = 1
AND g.state = 1
AND ( LOWER('Numai în ultimii doi ani, CFR SA a încheiat contracte de 300.000 de euro pentru folosirea unui depozit pe care putea să îl cumpere cu 75.000 de euro. Compania de Căi Ferate nu a fost, însă, interesată de achiziţia bazei, pe care a şi deţinut-o la un moment dat, iar obiectivul de importanţă strategică a ajun în posesia unei firme în care acţionar soţia fostului director al CFR, Valeriu Trică, firmă de care CFR SA este acum dependentă.\r\nBaza de depozitare şi manipulare a materialelor de cale ferată de la Aurel Vlaicu, judeţul Hunedoara, este un obiectiv strategic. Amplasat pe Coridorul IV Paneuropean, depozitul este absolut necesar pentru depozitarea şi manipularea materialelor necesare lucrărilor pe calea ferată.\r\n\r\n„Baza de la Aurel Vlaicu este singura omologată în ţară care asigură depozitarea şi unde se pot face lucrări de mentenanţă şi întreţinere a căilor rulante pentru toţi operatorii de transport feroviar naţionali sau privaţi. Având în vedere poziţionarea strategică pe Culoarul IV Paneuropean, orice entitate care realizează lucrări de reparaţii sau modernizare a infrastructurii feroviare sau lucrări de întreţinere a liniei curente va fi nevoită să încheie contracte de prestări servicii cu firma care deţine baza”, a explicat o sursă „Adevărul” importanţa depozitului de la Aurel Vlaicu.\r\n\r\n\r\n„E foarte importantă (n.r. baza) având în vedere că acum la noi se desfăşoară lucrări pe coridorul IV. E importantă pentru depozitarea materialelor”, confirmă directorul Sucursalei Regionale CFR Timişoara\r\n\r\n\r\n„Avantajul acestei baze este că se află în centrul ţării şi orice materiale vin, e mai uşor să le distribui în ţară”, declară şi fostul director al Regionalei Timişoara, Mircea Benec. Într-un răspuns comunicat la solicitarea ziarului Compania Naţională de Căi Ferate arată că nu deţine informaţii cu privire la existnţa în România a unor baze de depozitare similare celei de la Aurel Vlaicu (judeţul Hunedoara).\r\n\r\nIstoria tumultoasă a bazei de la Aurel Vlaicu începe după Revoluţie. Aflată în proprietatea fostei SNCFR, baza de manipulare şi depozitare a materialelor de cale ferată de la Aurel Vlaicu i-a revenit la reorganizarea din 1998 Societăţii de Construcţii Feroviare CNCF „CFR”SA – Sucursala Regională CF Timişoara. Ulterior, Societea de Construcţii Feroviare s-a privatizat, preluând odată cu privatizarea şi baza de la Aurel Vlaicu.\r\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR 'Numai în ultimii doi ani, CFR SA a încheiat contracte de 300.000 de euro pentru folosirea unui depozit pe care putea să îl cumpere cu 75.000 de euro. Compania de Căi Ferate nu a fost, însă, interesată de achiziţia bazei, pe care a şi deţinut-o la un moment dat, iar obiectivul de importanţă strategică a ajun în posesia unei firme în care acţionar soţia fostului director al CFR, Valeriu Trică, firmă de care CFR SA este acum dependentă.\r\nBaza de depozitare şi manipulare a materialelor de cale ferată de la Aurel Vlaicu, judeţul Hunedoara, este un obiectiv strategic. Amplasat pe Coridorul IV Paneuropean, depozitul este absolut necesar pentru depozitarea şi manipularea materialelor necesare lucrărilor pe calea ferată.\r\n\r\n„Baza de la Aurel Vlaicu este singura omologată în ţară care asigură depozitarea şi unde se pot face lucrări de mentenanţă şi întreţinere a căilor rulante pentru toţi operatorii de transport feroviar naţionali sau privaţi. Având în vedere poziţionarea strategică pe Culoarul IV Paneuropean, orice entitate care realizează lucrări de reparaţii sau modernizare a infrastructurii feroviare sau lucrări de întreţinere a liniei curente va fi nevoită să încheie contracte de prestări servicii cu firma care deţine baza”, a explicat o sursă „Adevărul” importanţa depozitului de la Aurel Vlaicu.\r\n\r\n\r\n„E foarte importantă (n.r. baza) având în vedere că acum la noi se desfăşoară lucrări pe coridorul IV. E importantă pentru depozitarea materialelor”, confirmă directorul Sucursalei Regionale CFR Timişoara\r\n\r\n\r\n„Avantajul acestei baze este că se află în centrul ţării şi orice materiale vin, e mai uşor să le distribui în ţară”, declară şi fostul director al Regionalei Timişoara, Mircea Benec. Într-un răspuns comunicat la solicitarea ziarului Compania Naţională de Căi Ferate arată că nu deţine informaţii cu privire la existnţa în România a unor baze de depozitare similare celei de la Aurel Vlaicu (judeţul Hunedoara).\r\n\r\nIstoria tumultoasă a bazei de la Aurel Vlaicu începe după Revoluţie. Aflată în proprietatea fostei SNCFR, baza de manipulare şi depozitare a materialelor de cale ferată de la Aurel Vlaicu i-a revenit la reorganizarea din 1998 Societăţii de Construcţii Feroviare CNCF „CFR”SA – Sucursala Regională CF Timişoara. Ulterior, Societea de Construcţii Feroviare s-a privatizat, preluând odată cu privatizarea şi baza de la Aurel Vlaicu.\r\n' REGEXP REPLACE(REPLACE(tsynonyms, ', ', '|'), ',', '|') )
AND ( g.language LIKE 'ro-RO' OR g.language = '*' )
ORDER BY ordering;
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | g | NULL | system | PRIMARY | **PLG_DEBUG_WARNING_NO_INDEX** | NULL | NULL | 1 | 100.00 | **PLG_DEBUG_WARNING_USING_FILESORT** |
| 1 | SIMPLE | t | NULL | ALL | NULL | **PLG_DEBUG_WARNING_NO_INDEX** | NULL | NULL | 139 | 1.00 | Using where |
| Status | Duration |
|---|
| starting | 0.30 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.17 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.05 ms |
| preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.03 ms |
| Creating sort index | 5.83 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/content/seoglossary/seoglossary.php:281 |
| 13 | plgContentSeoglossary->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_tags/views/tag/view.html.php:146 |
| 10 | TagsViewTag->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_tags/controller.php:52 |
| 8 | TagsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tags/tags.php:15 |
| 6 | require_once JROOT/components/com_tags/tags.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT t.*
FROM pq26o_seoglossary t
LEFT JOIN pq26o_seoglossaries g
ON t.catid = g.id
WHERE t.state = 1
AND g.state = 1
AND ( LOWER('Conectarea aeroportului din Timişoara pe calea ferată reprezintă un proiect de infrastructură demn de o capitală culturală europeană, susţin cei de la USR, scrie ADEVĂRUL.\r\nÎn perspectiva anului 2021, când Timişoara va fi capitală culturală europeană, USR le propune autorităţilor locale şi judeţene să colaboreze pentru realizeze unui proiect modern: conectarea aeroportului din Timişoara pe calea ferată.\r\nConform proiectului, durata estimată de implementare ar fi 12-16 luni, iar valoarea investiţiei 25 milioane lei.\r\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR 'Conectarea aeroportului din Timişoara pe calea ferată reprezintă un proiect de infrastructură demn de o capitală culturală europeană, susţin cei de la USR, scrie ADEVĂRUL.\r\nÎn perspectiva anului 2021, când Timişoara va fi capitală culturală europeană, USR le propune autorităţilor locale şi judeţene să colaboreze pentru realizeze unui proiect modern: conectarea aeroportului din Timişoara pe calea ferată.\r\nConform proiectului, durata estimată de implementare ar fi 12-16 luni, iar valoarea investiţiei 25 milioane lei.\r\n' REGEXP REPLACE(REPLACE(tsynonyms, ', ', '|'), ',', '|') )
AND ( g.language LIKE 'ro-RO' OR g.language = '*' )
ORDER BY ordering;
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | g | NULL | system | PRIMARY | **PLG_DEBUG_WARNING_NO_INDEX** | NULL | NULL | 1 | 100.00 | **PLG_DEBUG_WARNING_USING_FILESORT** |
| 1 | SIMPLE | t | NULL | ALL | NULL | **PLG_DEBUG_WARNING_NO_INDEX** | NULL | NULL | 139 | 1.00 | Using where |
| Status | Duration |
|---|
| starting | 0.12 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.06 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.04 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.03 ms |
| Creating sort index | 1.09 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/content/seoglossary/seoglossary.php:281 |
| 13 | plgContentSeoglossary->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_tags/views/tag/view.html.php:146 |
| 10 | TagsViewTag->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_tags/controller.php:52 |
| 8 | TagsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tags/tags.php:15 |
| 6 | require_once JROOT/components/com_tags/tags.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
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 `pq26o_categories` AS `s`
INNER JOIN `pq26o_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 24
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | **PLG_DEBUG_WARNING_USING_FILESORT** |
| 1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access,idx_left_right | **PLG_DEBUG_WARNING_NO_INDEX** | NULL | NULL | 36 | 35.49 | Using where |
| Status | Duration |
|---|
| starting | 0.14 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.06 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.15 ms |
| preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.12 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 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_fields/models/fields.php:203 |
| 17 | FieldsModelFields->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:133 |
| 16 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:135 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:478 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_tags/views/tag/view.html.php:146 |
| 10 | TagsViewTag->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_tags/controller.php:52 |
| 8 | TagsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tags/tags.php:15 |
| 6 | require_once JROOT/components/com_tags/tags.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM pq26o_fields AS a
LEFT JOIN `pq26o_languages` AS l
ON l.lang_code = a.language
LEFT JOIN pq26o_users AS uc
ON uc.id=a.checked_out
LEFT JOIN pq26o_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN pq26o_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN pq26o_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `pq26o_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (24,0,16))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using index condition; Using where; **PLG_DEBUG_WARNING_USING_FILESORT** |
| 1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 21 | feroviar_web2019fv.a.language | 1 | 100.00 | NULL |
| 1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | feroviar_web2019fv.a.checked_out | 1 | 100.00 | NULL |
| 1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | feroviar_web2019fv.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | feroviar_web2019fv.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | feroviar_web2019fv.a.group_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | feroviar_web2019fv.a.id | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.15 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| init | 0.06 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.10 ms |
| preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 16 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:135 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:478 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_tags/views/tag/view.html.php:146 |
| 10 | TagsViewTag->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_tags/controller.php:52 |
| 8 | TagsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tags/tags.php:15 |
| 6 | require_once JROOT/components/com_tags/tags.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT t.*
FROM pq26o_seoglossary t
LEFT JOIN pq26o_seoglossaries g
ON t.catid = g.id
WHERE t.state = 1
AND g.state = 1
AND ( LOWER('De luni, 14 septembrie, CFR Călători revine pe ruta Remetea Mică - Timişoara Nord, venind astfel în întâmpinarea solicitărilor de transport, în primul rând pentru elevii, studenții și persoanele al căror loc de muncă depinde de legătura cu Timişoara.\r\nŞase trenuri vor parcurge distanța Remetea Mică - Timişoara Nord și retur în aprox. 57 de minute pe sens şi vor deservi, de asemenea, locuitorii tuturor localităţilor de pe ruta feroviară, având opriri în staţiile Fibiş h*, Bencei h*, Pişchia h*, Cerneteaz h*, Giarmata Hm**, Viile Giarmata h*, Timişoara Est.\r\nTrenurile vor circula în regim Regio, fiind accesibile în ceea ce priveşte prețului de achiziție al biletelor de călătorie. Un bilet la clasa a 2-a costă 5,50 lei, un abonament lunar cu număr nelimitat de călătorii este 115,50 lei, iar abonamentul lunar pentru elevi și studenți este 57,75 lei, aceştia beneficiind de o reducere 75% (din valoarea tarifului integral de transport).\r\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR 'De luni, 14 septembrie, CFR Călători revine pe ruta Remetea Mică - Timişoara Nord, venind astfel în întâmpinarea solicitărilor de transport, în primul rând pentru elevii, studenții și persoanele al căror loc de muncă depinde de legătura cu Timişoara.\r\nŞase trenuri vor parcurge distanța Remetea Mică - Timişoara Nord și retur în aprox. 57 de minute pe sens şi vor deservi, de asemenea, locuitorii tuturor localităţilor de pe ruta feroviară, având opriri în staţiile Fibiş h*, Bencei h*, Pişchia h*, Cerneteaz h*, Giarmata Hm**, Viile Giarmata h*, Timişoara Est.\r\nTrenurile vor circula în regim Regio, fiind accesibile în ceea ce priveşte prețului de achiziție al biletelor de călătorie. Un bilet la clasa a 2-a costă 5,50 lei, un abonament lunar cu număr nelimitat de călătorii este 115,50 lei, iar abonamentul lunar pentru elevi și studenți este 57,75 lei, aceştia beneficiind de o reducere 75% (din valoarea tarifului integral de transport).\r\n' REGEXP REPLACE(REPLACE(tsynonyms, ', ', '|'), ',', '|') )
AND ( g.language LIKE 'ro-RO' OR g.language = '*' )
ORDER BY ordering;
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | g | NULL | system | PRIMARY | **PLG_DEBUG_WARNING_NO_INDEX** | NULL | NULL | 1 | 100.00 | **PLG_DEBUG_WARNING_USING_FILESORT** |
| 1 | SIMPLE | t | NULL | ALL | NULL | **PLG_DEBUG_WARNING_NO_INDEX** | NULL | NULL | 139 | 1.00 | Using where |
| Status | Duration |
|---|
| starting | 0.12 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.08 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| Creating sort index | 1.31 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/content/seoglossary/seoglossary.php:281 |
| 13 | plgContentSeoglossary->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_tags/views/tag/view.html.php:146 |
| 10 | TagsViewTag->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_tags/controller.php:52 |
| 8 | TagsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tags/tags.php:15 |
| 6 | require_once JROOT/components/com_tags/tags.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT t.*
FROM pq26o_seoglossary t
LEFT JOIN pq26o_seoglossaries g
ON t.catid = g.id
WHERE t.state = 1
AND g.state = 1
AND ( LOWER('CFR SA informează, pe pagina oficială Facebook, că a început lucrările de reabilitate a unor lucrări de artă (poduri, podețe) aflate pe raza Regionalei CF Timișoara - în total 5 obiective.\r\nObiective feroviare:\r\n\r\nPodeţ linia c.f. Ilia – Lugoj, jud. Hunedoara, între staţiile Dobra şi Holdea, km 12 + 255;\r\nPod linia c.f. Ilia – Lugoj, jud. Hunedoara, între staţiile Ilia şi Dobra, km 3 + 724;\r\nPod linia c.f. Ilia – Lugoj, jud. Hunedoara, între staţiile Ilia şi Dobra, km 5 + 403;\r\nPod linia c.f. Simeria – Livezeni Directa II, jud. Hunedoara, între staţiile Băniţa şi Petroşani, km 72 + 569;\r\nPod linia c.f. Simeria - Livezeni (Directa I şi II), jud. Hunedoara, între staţiile Subcetate şi Baieşti, km 36 + 673.\r\n\r\nAu fost finalizate lucrările de reabilitare la:\r\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR 'CFR SA informează, pe pagina oficială Facebook, că a început lucrările de reabilitate a unor lucrări de artă (poduri, podețe) aflate pe raza Regionalei CF Timișoara - în total 5 obiective.\r\nObiective feroviare:\r\n\r\nPodeţ linia c.f. Ilia – Lugoj, jud. Hunedoara, între staţiile Dobra şi Holdea, km 12 + 255;\r\nPod linia c.f. Ilia – Lugoj, jud. Hunedoara, între staţiile Ilia şi Dobra, km 3 + 724;\r\nPod linia c.f. Ilia – Lugoj, jud. Hunedoara, între staţiile Ilia şi Dobra, km 5 + 403;\r\nPod linia c.f. Simeria – Livezeni Directa II, jud. Hunedoara, între staţiile Băniţa şi Petroşani, km 72 + 569;\r\nPod linia c.f. Simeria - Livezeni (Directa I şi II), jud. Hunedoara, între staţiile Subcetate şi Baieşti, km 36 + 673.\r\n\r\nAu fost finalizate lucrările de reabilitare la:\r\n' REGEXP REPLACE(REPLACE(tsynonyms, ', ', '|'), ',', '|') )
AND ( g.language LIKE 'ro-RO' OR g.language = '*' )
ORDER BY ordering;
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | g | NULL | system | PRIMARY | **PLG_DEBUG_WARNING_NO_INDEX** | NULL | NULL | 1 | 100.00 | **PLG_DEBUG_WARNING_USING_FILESORT** |
| 1 | SIMPLE | t | NULL | ALL | NULL | **PLG_DEBUG_WARNING_NO_INDEX** | NULL | NULL | 139 | 1.00 | Using where |
| Status | Duration |
|---|
| starting | 0.12 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.06 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.04 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| Creating sort index | 1.08 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | **PLG_DEBUG_CALL_STACK_CALLER** | **PLG_DEBUG_CALL_STACK_FILE_AND_LINE** |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/content/seoglossary/seoglossary.php:281 |
| 13 | plgContentSeoglossary->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_tags/views/tag/view.html.php:146 |
| 10 | TagsViewTag->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_tags/controller.php:52 |
| 8 | TagsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tags/tags.php:15 |
| 6 | require_once JROOT/components/com_tags/tags.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**