**PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**
SELECT `data`
FROM `pq26o_session`
WHERE `session_id` = '28fb211ff0d90219c2bfbc69ae0c4ad9'
| 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.03 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.10 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` = '28fb211ff0d90219c2bfbc69ae0c4ad9'
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.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.03 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** |
|---|
| 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
('28fb211ff0d90219c2bfbc69ae0c4ad9', 1, 1664742529, 0, '', 0)
**PLG_DEBUG_QUERY_EXPLAIN_NOT_POSSIBLE**
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| update | 0.14 ms |
| Waiting for query cache lock | 0.01 ms |
| update | 0.01 ms |
| end | 0.01 ms |
| query end | 1.06 ms |
| closing tables | 0.03 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.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.09 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.40 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: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.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.01 ms |
| preparing | 0.01 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** |
|---|
| 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.07 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 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.02 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.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 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.01 ms |
| Creating sort index | 1.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 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.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.20 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** |
|---|
| 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.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.16 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.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 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.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 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.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.08 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| init | 0.07 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.02 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 2.24 ms |
| end | 0.03 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| removing tmp table | 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** |
|---|
| 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/50-modernizare') OR (`dest` = 'tag/50-modernizare') OR ('tag/50-modernizare' 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.09 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 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.01 ms |
| Creating sort index | 0.06 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** |
|---|
| 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.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.02 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** |
|---|
| 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.13 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.06 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.08 ms |
| preparing | 0.04 ms |
| Sorting result | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.53 ms |
| end | 0.02 ms |
| query end | 0.01 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** |
|---|
| 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.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.10 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.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** |
|---|
| 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/50-modernizare'
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.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.13 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** |
|---|
| 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.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 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.02 ms |
| Creating sort index | 0.06 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/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/50-modernizare'
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 | 1 | 100.00 | Using index condition; **PLG_DEBUG_WARNING_USING_FILESORT** |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.17 ms |
| preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.11 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** |
|---|
| 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`=1262, `last_hit`='2022-10-02 20:28:49'
WHERE `id`='7744'
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.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.12 ms |
| updating | 0.19 ms |
| end | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| end | 0.02 ms |
| query end | 0.49 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** |
|---|
| 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.12 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.09 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.20 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 1.06 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.01 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.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.06 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** |
|---|
| 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.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.11 ms |
| preparing | 0.02 ms |
| executing | 0.02 ms |
| Sending data | 0.06 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: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\":\"18ecaba164a08dc5258a700e32097e44\"}'
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.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.08 ms |
| updating | 0.13 ms |
| end | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| end | 0.01 ms |
| query end | 0.63 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** |
|---|
| 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.09 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.09 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.14 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** |
|---|
| 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.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.46 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.24 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** |
|---|
| 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 20:28:49')
AND (c.core_publish_down = '0000-00-00 00:00:00' OR c.core_publish_down >= '2022-10-02 20:28:49')
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 (50)
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 | 47 | 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 | ALL | PRIMARY | **PLG_DEBUG_WARNING_NO_INDEX** | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
| Status | Duration |
|---|
| starting | 0.17 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.38 ms |
| init | 0.15 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.34 ms |
| preparing | 0.05 ms |
| Creating tmp table | 0.06 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 6.39 ms |
| Creating sort index | 0.60 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| removing tmp table | 0.06 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.04 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.05 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.12 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.02 ms |
| checking permissions | 0.03 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 |
| 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 |
| 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 |
| 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 |
| checking permissions | 0.01 ms |
| Sending data | 0.08 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| removing tmp table | 0.03 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**:
#59SELECT *
FROM pq26o_tags
WHERE `id` = '50'
| 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.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.09 ms |
| preparing | 0.01 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.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 20:28:49')
AND (c.core_publish_down = '0000-00-00 00:00:00' OR c.core_publish_down >= '2022-10-02 20:28:49')
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 (50)
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 | 47 | 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 | ALL | PRIMARY | **PLG_DEBUG_WARNING_NO_INDEX** | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
| Status | Duration |
|---|
| starting | 0.18 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.03 ms |
| init | 0.15 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.14 ms |
| preparing | 0.04 ms |
| Creating tmp table | 0.05 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 1.94 ms |
| Creating sort index | 1.26 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| removing tmp table | 0.06 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.04 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 = 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.12 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.05 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.14 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.10 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.10 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.07 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.03 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** |
|---|
| 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.05 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.16 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.02 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.02 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.02 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 |
| 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 |
| 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 |
| 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.02 ms |
| Sending data | 0.13 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| removing tmp table | 0.04 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** |
|---|
| 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=50&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.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 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** |
|---|
| 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('Marţi, 05 aprilie 2016, la sediul Companiei Naţionale de Căi Ferate CFR SA, a avut loc deschiderea ofertelor pentru lucrarea Revizuirea Studiului de Fezabilitate pentru reabilitarea liniei de cale ferată Craiova-Calafat.\r\nReabilitarea liniei de cale ferată Craiova – Calafat este parte a proiectului global de modernizare a tronsonului feroviar Arad – Timisoara – Caransebes – Craiova – Calafat, parte componentă a Coridorului Orient/Est-Mediteranean pe teritoriul României.\r\nLa licitaţia deschisă au depus documentaţie următoarele 6 asocieri/firme româneşti şi străine:\r\n\r\nAsocierea Italferr S.p.A. – S.C. Italrom Inginerie Internationala S.R.L.;\r\nAsocierea SYSTRA S.A. – S.C. IRIMAT CONS S.R.L.;\r\nAsocierea ACCIONA Ingenieria S.A. – Ardanuy Ingenieria S.A.;\r\nAsocierea CONSIS PROIECT S.R.L. – BAICONS IMPEX S.R.L.;\r\nAsocierea SC OBERMEYER Proiectare Bucuresti S.R.L. – SC OBERMEYER Planen + Beraten GmbH Munchen Germania;\r\nEgis Rail S.A.\r\n\r\nObiectivul general al proiectului este modernizarea liniei de cale ferată ca linie simplă, electrificată în sistem de alimentare de 25 kV, controlată de un sistem care sa asigure cerințele de interoperabilitate specificate în normele STI permițând viteze de circulaţie cuprinse între 100 - 120 km/h (pentru trenurile de marfă) și 120 - 160 km/h (pentru trenurile de călători), respectiv introducerea instalațíilor de centralizare electronica/electrodinamica, noi sau reabilitate, după caz, în stațíi șí linie curentă și introducerea sistemului de siguranță ETCS Nivel 1/ETCS Nivel 1+GSM-R/ETCS Nivel 2+GSM-R în conformitate cu Specificațiile Tehnice de Interoperabilitate (STI) şi cu previziunile cererii de trafic de călători şi de marfă naţional şi internațional.\r\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR 'Marţi, 05 aprilie 2016, la sediul Companiei Naţionale de Căi Ferate CFR SA, a avut loc deschiderea ofertelor pentru lucrarea Revizuirea Studiului de Fezabilitate pentru reabilitarea liniei de cale ferată Craiova-Calafat.\r\nReabilitarea liniei de cale ferată Craiova – Calafat este parte a proiectului global de modernizare a tronsonului feroviar Arad – Timisoara – Caransebes – Craiova – Calafat, parte componentă a Coridorului Orient/Est-Mediteranean pe teritoriul României.\r\nLa licitaţia deschisă au depus documentaţie următoarele 6 asocieri/firme româneşti şi străine:\r\n\r\nAsocierea Italferr S.p.A. – S.C. Italrom Inginerie Internationala S.R.L.;\r\nAsocierea SYSTRA S.A. – S.C. IRIMAT CONS S.R.L.;\r\nAsocierea ACCIONA Ingenieria S.A. – Ardanuy Ingenieria S.A.;\r\nAsocierea CONSIS PROIECT S.R.L. – BAICONS IMPEX S.R.L.;\r\nAsocierea SC OBERMEYER Proiectare Bucuresti S.R.L. – SC OBERMEYER Planen + Beraten GmbH Munchen Germania;\r\nEgis Rail S.A.\r\n\r\nObiectivul general al proiectului este modernizarea liniei de cale ferată ca linie simplă, electrificată în sistem de alimentare de 25 kV, controlată de un sistem care sa asigure cerințele de interoperabilitate specificate în normele STI permițând viteze de circulaţie cuprinse între 100 - 120 km/h (pentru trenurile de marfă) și 120 - 160 km/h (pentru trenurile de călători), respectiv introducerea instalațíilor de centralizare electronica/electrodinamica, noi sau reabilitate, după caz, în stațíi șí linie curentă și introducerea sistemului de siguranță ETCS Nivel 1/ETCS Nivel 1+GSM-R/ETCS Nivel 2+GSM-R în conformitate cu Specificațiile Tehnice de Interoperabilitate (STI) şi cu previziunile cererii de trafic de călători şi de marfă naţional şi internațional.\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.19 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.11 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.06 ms |
| preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| Creating sort index | 3.15 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.04 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('Compania Naţională de Căi Ferate CFR SA a finalizat programul de reabilitare a 4 poduri de cale ferată situate între staţiile Constanţa – Agigea Nord şi Costineşti Tabără – Neptun. Valoarea totală a investiţiei se ridică la 8,2 mil. lei şi a fost asigurată din fonduri europene şi de la bugetul de stat. Prin lucrările de reabilitare executate la infrastructura şi suprastructura podurilor se îmbunătăţeşte gradul de siguranţă şi confort, viteza de circulaţie a trenurilor creşte de la 40 km/h la 80 km/h, iar capacitatea mărfurilor transportate ajunge la 21,5 tone/osie.\r\nPrin finalizarea acestui program de reabilitare, CFR SA îşi menţine trendul ascendent în graficul de investiţii, portofoliul său depăşind în acest an 400 de proiecte pe reţeaua de cale ferată, un portofoliu de lucrări structurat în direcţii strategice care vizează reabilitarea infrastructurii şi suprastructurii feroviare de pe Coridorul IV paneuropean, iar pentru restul retelei îmbunătăţirea capacităţilor de exploatare şi a calităţii transportului şi creşterea gradului de siguranţă în traficul feroviar.\r\nInvestiţiile financiare alocate de CFR SA pentru derularea acestor proiecte se ridică astfel la aproximativ 22 de miliarde de lei (4,7 mld euro) şi sunt susţinute financiar din trei surse - fonduri externe, buget de stat şi surse proprii.\r\nMenţionăm faptul că, în prima jumătate a acestui an CFR SA a finalizat 6 mari proiecte de investiţii, în valoare totală de 1,32 mld lei, a relansat 58 proiecte de lucrări, finanţate din fonduri externe şi de la bugetul de stat, în valoare totală de 12,61 mld lei şi a prioritizat 336 de proiectede investiţii şi reparaţii curente, susţinute financiar din surse proprii.\r\nPrin proiectele de investiţii lansate în acest an compania asigură continuitate în implementarea strategiei de modernizare a infrastructurii şi suprastructurii feroviare demarată în 2015, prin lucrări de reabilitare şi electrificare a 825 km de cale ferată, reabilitarea a 234 de poduri, podeţe, tuneluri, viaducte, pasaje CF, modernizarea a altor 24 de gări, cu sursă de finaţare asigurată din fonduri externe şi de la bugetul de stat. La capitolul reparaţii capitale şi reparaţii curente, finanţat din fonduri de la bugetul de stat şi surse proprii ale companiei, sunt programate lucrări de reparaţii în vedere îmbunătăţirii gradului de confort şi a creşterii vitezei de circulaţie pe 120 km de linie de cale ferată, poduri/podeţe/tuneluri/treceri la nivel şi aparate de cale pe intervale de staţii, repartizate pe toate cele 8 regionale de cale ferată.\r\nPlanul de investiţii în infrastructura feroviară, structurat de companie în cele peste 400 de proiecte, reorientează dezvoltarea reţelei feroviare naţionale în 5 direcţii majore:\r\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR 'Compania Naţională de Căi Ferate CFR SA a finalizat programul de reabilitare a 4 poduri de cale ferată situate între staţiile Constanţa – Agigea Nord şi Costineşti Tabără – Neptun. Valoarea totală a investiţiei se ridică la 8,2 mil. lei şi a fost asigurată din fonduri europene şi de la bugetul de stat. Prin lucrările de reabilitare executate la infrastructura şi suprastructura podurilor se îmbunătăţeşte gradul de siguranţă şi confort, viteza de circulaţie a trenurilor creşte de la 40 km/h la 80 km/h, iar capacitatea mărfurilor transportate ajunge la 21,5 tone/osie.\r\nPrin finalizarea acestui program de reabilitare, CFR SA îşi menţine trendul ascendent în graficul de investiţii, portofoliul său depăşind în acest an 400 de proiecte pe reţeaua de cale ferată, un portofoliu de lucrări structurat în direcţii strategice care vizează reabilitarea infrastructurii şi suprastructurii feroviare de pe Coridorul IV paneuropean, iar pentru restul retelei îmbunătăţirea capacităţilor de exploatare şi a calităţii transportului şi creşterea gradului de siguranţă în traficul feroviar.\r\nInvestiţiile financiare alocate de CFR SA pentru derularea acestor proiecte se ridică astfel la aproximativ 22 de miliarde de lei (4,7 mld euro) şi sunt susţinute financiar din trei surse - fonduri externe, buget de stat şi surse proprii.\r\nMenţionăm faptul că, în prima jumătate a acestui an CFR SA a finalizat 6 mari proiecte de investiţii, în valoare totală de 1,32 mld lei, a relansat 58 proiecte de lucrări, finanţate din fonduri externe şi de la bugetul de stat, în valoare totală de 12,61 mld lei şi a prioritizat 336 de proiectede investiţii şi reparaţii curente, susţinute financiar din surse proprii.\r\nPrin proiectele de investiţii lansate în acest an compania asigură continuitate în implementarea strategiei de modernizare a infrastructurii şi suprastructurii feroviare demarată în 2015, prin lucrări de reabilitare şi electrificare a 825 km de cale ferată, reabilitarea a 234 de poduri, podeţe, tuneluri, viaducte, pasaje CF, modernizarea a altor 24 de gări, cu sursă de finaţare asigurată din fonduri externe şi de la bugetul de stat. La capitolul reparaţii capitale şi reparaţii curente, finanţat din fonduri de la bugetul de stat şi surse proprii ale companiei, sunt programate lucrări de reparaţii în vedere îmbunătăţirii gradului de confort şi a creşterii vitezei de circulaţie pe 120 km de linie de cale ferată, poduri/podeţe/tuneluri/treceri la nivel şi aparate de cale pe intervale de staţii, repartizate pe toate cele 8 regionale de cale ferată.\r\nPlanul de investiţii în infrastructura feroviară, structurat de companie în cele peste 400 de proiecte, reorientează dezvoltarea reţelei feroviare naţionale în 5 direcţii majore:\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.41 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| init | 0.23 ms |
| System lock | 0.02 ms |
| optimizing | 0.04 ms |
| statistics | 0.09 ms |
| preparing | 0.04 ms |
| Sorting result | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.03 ms |
| Creating sort index | 7.49 ms |
| end | 0.02 ms |
| query end | 0.01 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** |
|---|
| 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('Compania Naţională de Căi Ferate CFR SA şi Comisia Europeană, prin Agenţia Executivă pentru Inovații și Rețele (INEA), au semnat contractul de finanţare, în valoare totală de 440 milioane de euro, pentru modernizarea tronsonului Apaţa - Caţa, informează compania într-un comunicat.\r\nTronsonul feroviar Apaţa - Caţa reprezintă un lot important în cadrul programului de reabilitarea a liniei de cale ferată Brașov - Sighișoara, componentă a Coridorului Rin - Dunăre.\r\nProiectul de modernizare a tronsonului Apaţa - Caţa, în lungime de 28,44 km, va contribui la atingerea obiectivului principal de promovare a mobilității sustenabile pe secțiunea Frontiera Ungară - Curtici - Arad - Simeria - Sighișoara - Brașov, prin:\r\n\r\ncreșterea vitezei de circulație la 160 km/h\r\nreducerea duratei de transport\r\ncreșterea siguranței feroviare\r\nfacilităţi pentru accesul persoanelor cu mobilitate redusă\r\nintroducerea sistemelor moderne de semnalizare şi de management al traficului.\r\n\r\n\r\n“Prin semnarea acestui contract de finanţare, CFR SA şi-a asigurat sursa de finanţare în vederea lansării procedurii de achiziţie a lucrărilor aferente tronsonului Apaţa - Caţa şi astfel se continuă programul de modernizare a infrastructurii feroviare pe ramura nordică a Coridorului IV feroviar, cuprinsă între Curtici - Braşov - Constanţa”, a declarat Marius CHIPER, director general al CFR SA.\r\n\r\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR 'Compania Naţională de Căi Ferate CFR SA şi Comisia Europeană, prin Agenţia Executivă pentru Inovații și Rețele (INEA), au semnat contractul de finanţare, în valoare totală de 440 milioane de euro, pentru modernizarea tronsonului Apaţa - Caţa, informează compania într-un comunicat.\r\nTronsonul feroviar Apaţa - Caţa reprezintă un lot important în cadrul programului de reabilitarea a liniei de cale ferată Brașov - Sighișoara, componentă a Coridorului Rin - Dunăre.\r\nProiectul de modernizare a tronsonului Apaţa - Caţa, în lungime de 28,44 km, va contribui la atingerea obiectivului principal de promovare a mobilității sustenabile pe secțiunea Frontiera Ungară - Curtici - Arad - Simeria - Sighișoara - Brașov, prin:\r\n\r\ncreșterea vitezei de circulație la 160 km/h\r\nreducerea duratei de transport\r\ncreșterea siguranței feroviare\r\nfacilităţi pentru accesul persoanelor cu mobilitate redusă\r\nintroducerea sistemelor moderne de semnalizare şi de management al traficului.\r\n\r\n\r\n“Prin semnarea acestui contract de finanţare, CFR SA şi-a asigurat sursa de finanţare în vederea lansării procedurii de achiziţie a lucrărilor aferente tronsonului Apaţa - Caţa şi astfel se continuă programul de modernizare a infrastructurii feroviare pe ramura nordică a Coridorului IV feroviar, cuprinsă între Curtici - Braşov - Constanţa”, a declarat Marius CHIPER, director general al CFR SA.\r\n\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.23 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.13 ms |
| System lock | 0.02 ms |
| optimizing | 0.05 ms |
| statistics | 0.06 ms |
| preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.03 ms |
| Creating sort index | 3.38 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 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 = 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.19 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.03 ms |
| statistics | 0.18 ms |
| preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.04 ms |
| Creating sort index | 0.15 ms |
| end | 0.01 ms |
| query end | 0.03 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** |
|---|
| 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.23 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.05 ms |
| init | 0.09 ms |
| System lock | 0.02 ms |
| optimizing | 0.03 ms |
| statistics | 0.13 ms |
| preparing | 0.05 ms |
| Sorting result | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.06 ms |
| Creating sort index | 0.05 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.04 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 Crăciun gara din Arad va deveni cea mai modernă din Europa de Est. O pasarelă supraterană pentru călători a fost construită şi face legătura între peroane şi clădirea istorică a gării. Astfel, vor fi închise pasajele subterane, imediat ce lucrările vor fi finalizate.\r\nPasarela are lifturi, scări rulante, dar şi magazine sau alte tipuri de facilităţi pentru călători. Tot în gară a fost construită o clădire pentru mentenanţă, care va cuprinde ateliere tehnologice, laboratoare, birouri, arhive şi magazii.\r\nDe asemenea, au fost refăcute peroanele şi modernizat un centru de management al traficului feroviar. Lucrările de modernizare a Gării Arad, începute în anul 2012, sunt întârziate.\r\nValoarea investiţiei cu fonduri europene depăşeşte 334 de milioane de lei.\r\nLucrările sunt la stadiul de finisare, fiind deja montate lifturile şi scările rulante. Se mai lucrează la instalaţiile electrice şi de apă.\r\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR 'De Crăciun gara din Arad va deveni cea mai modernă din Europa de Est. O pasarelă supraterană pentru călători a fost construită şi face legătura între peroane şi clădirea istorică a gării. Astfel, vor fi închise pasajele subterane, imediat ce lucrările vor fi finalizate.\r\nPasarela are lifturi, scări rulante, dar şi magazine sau alte tipuri de facilităţi pentru călători. Tot în gară a fost construită o clădire pentru mentenanţă, care va cuprinde ateliere tehnologice, laboratoare, birouri, arhive şi magazii.\r\nDe asemenea, au fost refăcute peroanele şi modernizat un centru de management al traficului feroviar. Lucrările de modernizare a Gării Arad, începute în anul 2012, sunt întârziate.\r\nValoarea investiţiei cu fonduri europene depăşeşte 334 de milioane de lei.\r\nLucrările sunt la stadiul de finisare, fiind deja montate lifturile şi scările rulante. Se mai lucrează la instalaţiile electrice şi de apă.\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.18 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.12 ms |
| System lock | 0.02 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.16 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 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('Alstom va contesta decizia CFR SA de a atribui asocierii Brasig Strabag - Swietelsky licitaţia pentru modernizarea subsecţiunilor Sighişoara- Braşov, anunţând că va recurge la toate mijloacele legale, atât la nivel naţional, cât şi european, informează un comunicat al Alstom.\r\n\r\n\"În data de 5 iulie 2018 am luat act despre decizia CNCF CFR SA de a atribui licitaţia pentru modernizarea subsecţiunilor Braşov - Apaţa şi Caţa - Sighişoara către Asocierea Brasig, formată din Strabag-Swietelsky. Deşi Consorţiul din care facem parte (Asocierea Railworks formată din Alstom, Aktor, Euro Construct Trading \'98 şi Arcada) a fost anterior declarat admisibil şi s-a clasat pe locul I, CFR a decis atribuirea acestui contract către asocierea clasată pe locul al treilea, preţul acestei ofertei fiind semnificativ mai mare. Analizând motivele deciziei invocate în comunicarea primită, am constatat faptul că se referă la starea de insolvenţă a unuia dintre partenerii noştri de consorţiu, deşi credem că acest lucru contravine atât legii insolvenţei cât şi legislaţiei naţionale şi europene în materie de achiziţii publice\", se menţionează în comunicat.\r\n\r\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR 'Alstom va contesta decizia CFR SA de a atribui asocierii Brasig Strabag - Swietelsky licitaţia pentru modernizarea subsecţiunilor Sighişoara- Braşov, anunţând că va recurge la toate mijloacele legale, atât la nivel naţional, cât şi european, informează un comunicat al Alstom.\r\n\r\n\"În data de 5 iulie 2018 am luat act despre decizia CNCF CFR SA de a atribui licitaţia pentru modernizarea subsecţiunilor Braşov - Apaţa şi Caţa - Sighişoara către Asocierea Brasig, formată din Strabag-Swietelsky. Deşi Consorţiul din care facem parte (Asocierea Railworks formată din Alstom, Aktor, Euro Construct Trading \'98 şi Arcada) a fost anterior declarat admisibil şi s-a clasat pe locul I, CFR a decis atribuirea acestui contract către asocierea clasată pe locul al treilea, preţul acestei ofertei fiind semnificativ mai mare. Analizând motivele deciziei invocate în comunicarea primită, am constatat faptul că se referă la starea de insolvenţă a unuia dintre partenerii noştri de consorţiu, deşi credem că acest lucru contravine atât legii insolvenţei cât şi legislaţiei naţionale şi europene în materie de achiziţii publice\", se menţionează în comunicat.\r\n\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.26 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.10 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.04 ms |
| preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| Creating sort index | 2.40 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 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 a inclus în programe de modernizare 497 de poduri şi podeţe, în cadrul Programului Operaţional Infrastructură Mare (POIM) şi a Mecanismului pentru Interconectarea Europei – CEF 2014-2020, informează compania.\r\nDintre acestea, 407 de poduri şi podeţe au fost incluse în programul de modernizare infrastructură şi suprastructură feroviară Frontieră – km 614 – Simeria – Sighişoara. Este vorba despre 228 de poduri şi podeţe pe tronsonul Sighişoara – Coşlariu – Simeria (173 km), care are un grad de execuţie de 94%, 169 de poduri şi podeţe pe tronsonul Simeria – Gurasada – Cap Y Bârzava – km 614 (141 km), aflat în execuţie, şi 10 podeţe pe tronsonul km 614 (Radna) – Frontieră (42 km), finalizat.\r\nDe asemenea, 90 de poduri şi podeţe au fost incluse în programul modernizare pe raza regionalelor de cale ferată – Bucureşti, Craiova, Timişoara, Cluj, Braşov, Iaşi, Galaţi şi Constanţa.\r\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR 'CFR SA a inclus în programe de modernizare 497 de poduri şi podeţe, în cadrul Programului Operaţional Infrastructură Mare (POIM) şi a Mecanismului pentru Interconectarea Europei – CEF 2014-2020, informează compania.\r\nDintre acestea, 407 de poduri şi podeţe au fost incluse în programul de modernizare infrastructură şi suprastructură feroviară Frontieră – km 614 – Simeria – Sighişoara. Este vorba despre 228 de poduri şi podeţe pe tronsonul Sighişoara – Coşlariu – Simeria (173 km), care are un grad de execuţie de 94%, 169 de poduri şi podeţe pe tronsonul Simeria – Gurasada – Cap Y Bârzava – km 614 (141 km), aflat în execuţie, şi 10 podeţe pe tronsonul km 614 (Radna) – Frontieră (42 km), finalizat.\r\nDe asemenea, 90 de poduri şi podeţe au fost incluse în programul modernizare pe raza regionalelor de cale ferată – Bucureşti, Craiova, Timişoara, Cluj, Braşov, Iaşi, Galaţi şi Constanţa.\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.22 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.12 ms |
| System lock | 0.02 ms |
| optimizing | 0.03 ms |
| statistics | 0.06 ms |
| preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.03 ms |
| Creating sort index | 2.32 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.04 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 = 17
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 | 23.07 | Using where |
| Status | Duration |
|---|
| starting | 0.27 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.11 ms |
| System lock | 0.02 ms |
| optimizing | 0.04 ms |
| statistics | 0.25 ms |
| preparing | 0.05 ms |
| Sorting result | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.05 ms |
| Creating sort index | 0.23 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.04 ms |
| freeing items | 0.06 ms |
| cleaning up | 0.02 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**