**زمان پرس و جو: 2.84 ms** **حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 3.564 MB** **سطرهای بازگشتی: 0**
SELECT `data`
FROM `ercem_session`
WHERE `session_id` = X'3835383832326635663332393439313962383330346139643061313638626366'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.71 ms |
| checking permissions | 0.11 ms |
| Opening tables | 0.10 ms |
| After opening tables | 0.08 ms |
| System lock | 0.06 ms |
| table lock | 0.12 ms |
| init | 0.11 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.18 ms |
| Preparing | 0.09 ms |
| Executing | 0.07 ms |
| End of update loop | 0.06 ms |
| Query end | 0.04 ms |
| Commit | 0.05 ms |
| Query end | 0.05 ms |
| closing tables | 0.04 ms |
| Unlocking tables | 0.04 ms |
| closing tables | 0.05 ms |
| Query end | 0.10 ms |
| Starting cleanup | 0.08 ms |
| Freeing items | 0.31 ms |
| Updating status | 0.14 ms |
| Reset for next command | 0.10 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
| 14 | JSessionStorageDatabase->read() | **به نظر می رسد خط زیر فراخونده شده باشد.** |
| 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 |
**زمان پرس و جو: 1.79 ms** **پس از آخرین پرس و جو: 3.84 ms** **حافظه پرس و جو: 0.004 MB حافظه قبل از پرس و جوی: 3.729 MB** **سطرهای بازگشتی: 0**
SELECT `session_id`
FROM `ercem_session`
WHERE `session_id` = X'3835383832326635663332393439313962383330346139643061313638626366'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.41 ms |
| checking permissions | 0.06 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.05 ms |
| System lock | 0.04 ms |
| table lock | 0.04 ms |
| init | 0.07 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.12 ms |
| Preparing | 0.04 ms |
| Executing | 0.04 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.30 ms |
| Updating status | 0.10 ms |
| Reset for next command | 0.06 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php: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 |
**زمان پرس و جو: 3.20 ms** **پس از آخرین پرس و جو: 0.26 ms** **حافظه پرس و جو: 0.004 MB حافظه قبل از پرس و جوی: 3.734 MB**
INSERT INTO `ercem_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'3835383832326635663332393439313962383330346139643061313638626366', 1, 1767261425, 0, '', 0)
**توضیحات در جستجو ممکن نیست: INSERT INTO `ercem_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'3835383832326635663332393439313962383330346139643061313638626366', 1, 1767261425, 0, '', 0)**
| Status | Duration |
|---|
| Starting | 0.34 ms |
| checking permissions | 0.09 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.04 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init for update | 0.06 ms |
| Update | 0.21 ms |
| Waiting for query cache lock | 0.05 ms |
| Update | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.03 ms |
| Commit | 1.52 ms |
| Query end | 0.06 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.21 ms |
| Updating status | 0.09 ms |
| Reset for next command | 0.06 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 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 |
**زمان پرس و جو: 3.18 ms** **پس از آخرین پرس و جو: 8.17 ms** **حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 3.945 MB** **سطرهای بازگشتی: 50**
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ercem_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_extensions | ref | extension | extension | 82 | const | 50 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.88 ms |
| checking permissions | 0.07 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.03 ms |
| init | 0.08 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.14 ms |
| Preparing | 0.09 ms |
| Executing | 0.03 ms |
| Sending data | 0.63 ms |
| End of update loop | 0.05 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.17 ms |
| Updating status | 0.08 ms |
| Reset for next command | 0.39 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
| 10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | **به نظر می رسد خط زیر فراخونده شده باشد.** |
| 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 |
**زمان پرس و جو: 2.40 ms** **پس از آخرین پرس و جو: 51.42 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 4.163 MB** **سطرهای بازگشتی: 5**
SELECT id, rules
FROM `ercem_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_viewlevels | ALL | NULL | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 5 | |
| Status | Duration |
|---|
| Starting | 0.66 ms |
| checking permissions | 0.08 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.04 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.08 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.06 ms |
| Preparing | 0.06 ms |
| Executing | 0.03 ms |
| Sending data | 0.29 ms |
| End of update loop | 0.09 ms |
| Query end | 0.03 ms |
| Commit | 0.02 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.17 ms |
| Updating status | 0.13 ms |
| Reset for next command | 0.05 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php: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 |
**زمان پرس و جو: 1.69 ms** **پس از آخرین پرس و جو: 0.48 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 4.175 MB** **سطرهای بازگشتی: 0**
SELECT b.id
FROM ercem_usergroups AS a
LEFT JOIN ercem_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 13
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | **کلید شاخصی برای استفاده نیست** | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.28 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.08 ms |
| After opening tables | 0.07 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.06 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.11 ms |
| Preparing | 0.15 ms |
| Executing | 0.08 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.17 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.07 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
| 9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php: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 |
**زمان پرس و جو: 3.07 ms** **پس از آخرین پرس و جو: 1.73 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 4.240 MB** **سطرهای بازگشتی: 127**
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM ercem_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_extensions | ALL | extension | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 373 | Using where; **با استفاده از مرتب سازی فایل** |
| Status | Duration |
|---|
| Starting | 0.37 ms |
| checking permissions | 0.07 ms |
| Opening tables | 0.23 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.17 ms |
| init | 0.09 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.19 ms |
| Preparing | 0.07 ms |
| Sorting result | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.03 ms |
| Creating sort index | 1.04 ms |
| End of update loop | 0.06 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.14 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.03 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:354 |
| 9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | **به نظر می رسد خط زیر فراخونده شده باشد.** |
| 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 |
**زمان پرس و جو: 1.63 ms** **پس از آخرین پرس و جو: 230.57 ms** **حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 8.303 MB** **سطرهای بازگشتی: 75**
SELECT *
FROM ercem_rsticketspro_configuration
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_rsticketspro_configuration | ALL | NULL | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 75 | |
| Status | Duration |
|---|
| Starting | 0.40 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.08 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.03 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.04 ms |
| Preparing | 0.05 ms |
| Executing | 0.02 ms |
| Sending data | 0.15 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.18 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.07 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_rsticketspro/helpers/config.php |
| 11 | RSTicketsProConfig->load() | JROOT/administrator/components/com_rsticketspro/helpers/config.php |
| 10 | RSTicketsProConfig->__construct() | JROOT/administrator/components/com_rsticketspro/helpers/config.php |
| 9 | RSTicketsProConfig::getInstance() | JROOT/plugins/system/rsticketspro/rsticketspro.php |
| 8 | plgSystemRsticketspro->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 |
**زمان پرس و جو: 1.98 ms** **پس از آخرین پرس و جو: 55.29 ms** **حافظه پرس و جو: 0.010 MB حافظه قبل از پرس و جوی: 8.639 MB** **سطرهای بازگشتی: 1**
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ercem_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.36 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.08 ms |
| System lock | 0.04 ms |
| table lock | 0.03 ms |
| init | 0.06 ms |
| Optimizing | 0.18 ms |
| Statistics | 0.18 ms |
| Preparing | 0.07 ms |
| Executing | 0.02 ms |
| Sending data | 0.10 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.25 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.04 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 20 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
| 19 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | **به نظر می رسد خط زیر فراخونده شده باشد.** |
| 18 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 17 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
| 16 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
| 15 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
| 14 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
| 13 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 12 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 11 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/helix/core/helix.php:50 |
| 10 | Helix::getDocument() | JROOT/plugins/system/helix/core/helix.php:36 |
| 9 | Helix::getInstance() | JROOT/plugins/system/helix/helix.php:21 |
| 8 | plgSystemHelix->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 |
**زمان پرس و جو: 10.24 ms** **پس از آخرین پرس و جو: 0.39 ms** **حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 8.632 MB**
UPDATE `ercem_extensions`
SET `params` = '{\"mediaversion\":\"a1add20493ad904aef2deed5aded5f02\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
**توضیحات در جستجو ممکن نیست: UPDATE `ercem_extensions`
SET `params` = '{\"mediaversion\":\"a1add20493ad904aef2deed5aded5f02\"}'
WHERE `type` = 'library' AND `element` = 'joomla'**
| Status | Duration |
|---|
| Starting | 0.27 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.05 ms |
| checking permissions | 0.02 ms |
| After opening tables | 0.02 ms |
| init for update | 0.02 ms |
| init | 0.04 ms |
| Updating main table | 0.03 ms |
| init | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.02 ms |
| init for update | 0.11 ms |
| Updating | 0.15 ms |
| End of update loop | 0.04 ms |
| Waiting for query cache lock | 0.02 ms |
| End of update loop | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 8.71 ms |
| Query end | 0.06 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.20 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.04 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
| 15 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
| 14 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
| 13 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 12 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 11 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/helix/core/helix.php:50 |
| 10 | Helix::getDocument() | JROOT/plugins/system/helix/core/helix.php:36 |
| 9 | Helix::getInstance() | JROOT/plugins/system/helix/helix.php:21 |
| 8 | plgSystemHelix->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 |
**زمان پرس و جو: 4.32 ms** **پس از آخرین پرس و جو: 3.72 ms** **حافظه پرس و جو: 0.011 MB حافظه قبل از پرس و جوی: 8.926 MB** **سطرهای بازگشتی: 44**
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 ercem_menu AS m
LEFT JOIN ercem_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ALL | idx_client_id_parent_id_alias_language | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 229 | Using where; **با استفاده از مرتب سازی فایل** |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | applyaus_austria.m.component_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.47 ms |
| checking permissions | 0.22 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.04 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.10 ms |
| Optimizing | 0.08 ms |
| Statistics | 0.20 ms |
| Preparing | 0.12 ms |
| Sorting result | 0.06 ms |
| Executing | 0.26 ms |
| Sending data | 0.06 ms |
| Creating sort index | 1.69 ms |
| End of update loop | 0.06 ms |
| Query end | 0.04 ms |
| Commit | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.26 ms |
| Updating status | 0.09 ms |
| Reset for next command | 0.05 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
| 23 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | **به نظر می رسد خط زیر فراخونده شده باشد.** |
| 22 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 21 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
| 20 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:76 |
| 19 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
| 18 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:131 |
| 17 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:375 |
| 16 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
| 15 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:434 |
| 14 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/plugins/system/helix/core/helix.php:65 |
| 13 | Helix::themeName() | JROOT/plugins/system/helix/core/helix.php:114 |
| 12 | Helix::themePath() | JROOT/plugins/system/helix/core/helix.php:302 |
| 11 | Helix::_Import() | JROOT/plugins/system/helix/core/helix.php:290 |
| 10 | Helix::Import() | JROOT/plugins/system/helix/core/helix.php:1592 |
| 9 | Helix::loadHelixOverwrite() | JROOT/plugins/system/helix/helix.php:22 |
| 8 | plgSystemHelix->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 |
**زمان پرس و جو: 3.08 ms** **پس از آخرین پرس و جو: 1.34 ms** **حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 9.131 MB** **سطرهای بازگشتی: 11**
SELECT id, home, template, s.params
FROM ercem_template_styles as s
LEFT JOIN ercem_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 5 | Using index condition; Using where |
| 1 | SIMPLE | s | ref | idx_template,idx_client_id,idx_client_id_home | idx_template | 202 | applyaus_austria.e.element | 2 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.50 ms |
| checking permissions | 0.10 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.08 ms |
| Optimizing | 0.09 ms |
| Statistics | 0.23 ms |
| Preparing | 0.12 ms |
| Executing | 0.03 ms |
| Sending data | 0.78 ms |
| End of update loop | 0.08 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.04 ms |
| Query end | 0.05 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.38 ms |
| Updating status | 0.14 ms |
| Reset for next command | 0.07 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
| 14 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/plugins/system/helix/core/helix.php:65 |
| 13 | Helix::themeName() | JROOT/plugins/system/helix/core/helix.php:114 |
| 12 | Helix::themePath() | JROOT/plugins/system/helix/core/helix.php:302 |
| 11 | Helix::_Import() | JROOT/plugins/system/helix/core/helix.php:290 |
| 10 | Helix::Import() | JROOT/plugins/system/helix/core/helix.php:1592 |
| 9 | Helix::loadHelixOverwrite() | JROOT/plugins/system/helix/helix.php:22 |
| 8 | plgSystemHelix->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 |
**زمان پرس و جو: 1.29 ms** **پس از آخرین پرس و جو: 77.50 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 10.787 MB** **سطرهای بازگشتی: 1**
SELECT *
FROM ercem_kunena_configuration
WHERE id=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_kunena_configuration | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.28 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.06 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.18 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.03 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 19 | JDatabaseDriver->loadAssoc() | JROOT/libraries/kunena/config.php:1289 |
| 18 | KunenaConfig->load() | JROOT/libraries/kunena/config.php:1223 |
| 17 | KunenaConfig::getInstance() | JROOT/libraries/kunena/factory.php:28 |
| 16 | KunenaFactory::getConfig() | JROOT/libraries/kunena/route/route.php:480 |
| 15 | KunenaRoute::initialize() | JROOT/libraries/kunena/route/route.php:17 |
| 14 | include_once JROOT/libraries/kunena/route/route.php | JROOT/libraries/loader.php:759 |
| 13 | JLoader::_load() | JROOT/libraries/loader.php:707 |
| 12 | JLoader::_autoload() | **به نظر می رسد خط زیر فراخونده شده باشد.** |
| 11 | spl_autoload_call() | JROOT/components/com_kunena/router.php:301 |
| 10 | KunenaParseRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:105 |
| 9 | Joomla\CMS\Component\Router\RouterLegacy->parse() | JROOT/libraries/src/Router/SiteRouter.php:437 |
| 8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
| 7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
| 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 |
**زمان پرس و جو: 1.06 ms** **پس از آخرین پرس و جو: 3.30 ms** **حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 10.932 MB** **سطرهای بازگشتی: 1**
SELECT *
FROM ercem_kunena_aliases
WHERE alias LIKE 'user%'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_kunena_aliases | range | alias | alias | 572 | NULL | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.17 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.04 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.12 ms |
| Preparing | 0.05 ms |
| Executing | 0.02 ms |
| Sending data | 0.05 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.11 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.03 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/kunena/route/route.php:450 |
| 11 | KunenaRoute::resolveAlias() | JROOT/components/com_kunena/router.php:316 |
| 10 | KunenaParseRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:105 |
| 9 | Joomla\CMS\Component\Router\RouterLegacy->parse() | JROOT/libraries/src/Router/SiteRouter.php:437 |
| 8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
| 7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
| 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 |
**زمان پرس و جو: 1.15 ms** **پس از آخرین پرس و جو: 3.07 ms** **حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 11.121 MB** **سطرهای بازگشتی: 2**
SELECT *
FROM ercem_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_languages | ALL | NULL | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 3 | Using where; **با استفاده از مرتب سازی فایل** |
| Status | Duration |
|---|
| Starting | 0.17 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.03 ms |
| Preparing | 0.03 ms |
| Sorting result | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.16 ms |
| End of update loop | 0.05 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.15 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.03 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
| 12 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
| 11 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/components/com_k2/helpers/utilities.php:243 |
| 10 | K2HelperUtilities::getParams() | JROOT/administrator/components/com_k2/helpers/html.php:216 |
| 9 | K2HelperHTML::loadHeadIncludes() | JROOT/plugins/system/k2/k2.php:405 |
| 8 | plgSystemK2->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 |
**زمان پرس و جو: 4.90 ms** **پس از آخرین پرس و جو: 12.00 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 11.716 MB** **سطرهای بازگشتی: 7**
SHOW FULL COLUMNS
FROM `ercem_session`
**توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `ercem_session`**
| Status | Duration |
|---|
| Starting | 0.29 ms |
| checking permissions | 0.05 ms |
| closing tables | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 1.52 ms |
| After opening tables | 0.07 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.03 ms |
| Preparing | 0.08 ms |
| Executing | 0.04 ms |
| Filling schema table | 0.04 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.03 ms |
| checking permissions | 0.16 ms |
| closing tables | 0.05 ms |
| checking permissions | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.09 ms |
| End of update loop | 0.05 ms |
| Query end | 0.03 ms |
| closing tables | 0.02 ms |
| Removing tmp table | 0.44 ms |
| closing tables | 0.05 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.25 ms |
| Updating status | 0.10 ms |
| Reset for next command | 0.07 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 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_jrealtimeanalytics/tables/session.php:163 |
| 14 | JRealtimeTableSession->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 13 | Joomla\CMS\Table\Table::getInstance() | JROOT/administrator/components/com_jrealtimeanalytics/framework/helpers/users.php:135 |
| 12 | JRealtimeHelpersUsers::getSessionTable() | JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:48 |
| 11 | plgSystemJRealtimeAnalytics->notifyObservers() | JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:152 |
| 10 | plgSystemJRealtimeAnalytics->injectApp() | JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:581 |
| 9 | plgSystemJRealtimeAnalytics->startApp() | JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:608 |
| 8 | plgSystemJRealtimeAnalytics->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 |
**زمان پرس و جو: 2.69 ms** **پس از آخرین پرس و جو: 2.22 ms** **حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 11.754 MB** **سطرهای بازگشتی: 1**
SELECT *
FROM ercem_session
WHERE `session_id` = '858822f5f3294919b8304a9d0a168bcf'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.44 ms |
| checking permissions | 0.06 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.09 ms |
| Preparing | 0.05 ms |
| Unlocking tables | 0.04 ms |
| Preparing | 0.05 ms |
| Executing | 0.04 ms |
| Sending data | 0.05 ms |
| End of update loop | 0.08 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.04 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.20 ms |
| Updating status | 0.08 ms |
| Reset for next command | 0.05 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 14 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
| 13 | Joomla\CMS\Table\Table->load() | JROOT/administrator/components/com_jrealtimeanalytics/framework/helpers/users.php:136 |
| 12 | JRealtimeHelpersUsers::getSessionTable() | JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:48 |
| 11 | plgSystemJRealtimeAnalytics->notifyObservers() | JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:152 |
| 10 | plgSystemJRealtimeAnalytics->injectApp() | JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:581 |
| 9 | plgSystemJRealtimeAnalytics->startApp() | JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:608 |
| 8 | plgSystemJRealtimeAnalytics->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 |
**زمان پرس و جو: 1.93 ms** **پس از آخرین پرس و جو: 5.51 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 11.923 MB** **سطرهای بازگشتی: 0**
SELECT *
FROM `ercem_realtimeanalytics_eventstats`
WHERE `type` = 'viewurl'
AND `published` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_realtimeanalytics_eventstats | ALL | NULL | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.32 ms |
| checking permissions | 0.06 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.10 ms |
| Optimizing | 0.15 ms |
| Statistics | 0.10 ms |
| Preparing | 0.07 ms |
| Executing | 0.04 ms |
| Sending data | 0.09 ms |
| End of update loop | 0.09 ms |
| Query end | 0.04 ms |
| Commit | 0.02 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.20 ms |
| Updating status | 0.09 ms |
| Reset for next command | 0.05 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:388 |
| 15 | JRealtimeModelEventstatsObsrv::loadEventsFromDB() | JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:181 |
| 14 | JRealtimeModelEventstatsObsrv->trackEventVisitPage() | JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:413 |
| 13 | JRealtimeModelEventstatsObsrv->update() | JROOT/administrator/components/com_jrealtimeanalytics/framework/model/observable.php:97 |
| 12 | JRealtimeModelObservable->notify() | JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:78 |
| 11 | plgSystemJRealtimeAnalytics->notifyObservers() | JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:152 |
| 10 | plgSystemJRealtimeAnalytics->injectApp() | JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:581 |
| 9 | plgSystemJRealtimeAnalytics->startApp() | JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:608 |
| 8 | plgSystemJRealtimeAnalytics->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 |
**زمان پرس و جو: 1.45 ms** **پس از آخرین پرس و جو: 0.16 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 11.931 MB** **سطرهای بازگشتی: 0**
SELECT *
FROM `ercem_realtimeanalytics_eventstats`
WHERE `type` = 'minpages'
AND `published` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_realtimeanalytics_eventstats | ALL | NULL | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.28 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.06 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.04 ms |
| Preparing | 0.05 ms |
| Executing | 0.06 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.03 ms |
| Query end | 0.04 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.20 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.06 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:388 |
| 15 | JRealtimeModelEventstatsObsrv::loadEventsFromDB() | JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:231 |
| 14 | JRealtimeModelEventstatsObsrv->trackEventMinPageVisited() | JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:416 |
| 13 | JRealtimeModelEventstatsObsrv->update() | JROOT/administrator/components/com_jrealtimeanalytics/framework/model/observable.php:97 |
| 12 | JRealtimeModelObservable->notify() | JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:78 |
| 11 | plgSystemJRealtimeAnalytics->notifyObservers() | JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:152 |
| 10 | plgSystemJRealtimeAnalytics->injectApp() | JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:581 |
| 9 | plgSystemJRealtimeAnalytics->startApp() | JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:608 |
| 8 | plgSystemJRealtimeAnalytics->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 |
**زمان پرس و جو: 2.02 ms** **پس از آخرین پرس و جو: 0.43 ms** **حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 11.956 MB** **سطرهای بازگشتی: 9**
SELECT *
FROM ercem_rokcandy
WHERE published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_rokcandy | ALL | NULL | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 9 | Using where |
| Status | Duration |
|---|
| Starting | 0.34 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.06 ms |
| Optimizing | 0.09 ms |
| Statistics | 0.07 ms |
| Preparing | 0.07 ms |
| Executing | 0.05 ms |
| Sending data | 0.15 ms |
| End of update loop | 0.04 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.04 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.28 ms |
| Updating status | 0.13 ms |
| Reset for next command | 0.07 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:27 |
| 13 | RokCandyHelper::getUserMacros() | **به نظر می رسد خط زیر فراخونده شده باشد.** |
| 12 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 11 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 10 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:17 |
| 9 | RokCandyHelper::getMacros() | JROOT/plugins/system/rokcandy/rokcandy.php:28 |
| 8 | plgSystemRokCandy->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 |
**زمان پرس و جو: 4.80 ms** **پس از آخرین پرس و جو: 55.47 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 12.318 MB** **سطرهای بازگشتی: 5**
SHOW FULL COLUMNS
FROM `ercem_kunena_sessions`
**توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `ercem_kunena_sessions`**
| Status | Duration |
|---|
| Starting | 0.47 ms |
| checking permissions | 0.18 ms |
| closing tables | 0.08 ms |
| checking permissions | 0.04 ms |
| Opening tables | 1.52 ms |
| After opening tables | 0.08 ms |
| System lock | 0.03 ms |
| table lock | 0.04 ms |
| init | 0.07 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.05 ms |
| Preparing | 0.05 ms |
| Executing | 0.02 ms |
| Filling schema table | 0.03 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.02 ms |
| checking permissions | 0.13 ms |
| closing tables | 0.05 ms |
| checking permissions | 0.04 ms |
| Executing | 0.03 ms |
| Sending data | 0.16 ms |
| End of update loop | 0.11 ms |
| Query end | 0.04 ms |
| closing tables | 0.03 ms |
| Removing tmp table | 0.44 ms |
| closing tables | 0.06 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.33 ms |
| Updating status | 0.12 ms |
| Reset for next command | 0.06 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 16 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 15 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 14 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/kunena/tables/kunenasessions.php:31 |
| 13 | TableKunenaSessions->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 12 | Joomla\CMS\Table\Table::getInstance() | JROOT/libraries/kunena/session.php:96 |
| 11 | KunenaSession->getTable() | JROOT/libraries/kunena/session.php:110 |
| 10 | KunenaSession->load() | JROOT/libraries/kunena/session.php:30 |
| 9 | KunenaSession->__construct() | JROOT/libraries/kunena/session.php:60 |
| 8 | KunenaSession::getInstance() | JROOT/libraries/kunena/factory.php:86 |
| 7 | KunenaFactory::getSession() | JROOT/components/com_kunena/kunena.php:61 |
| 6 | require_once JROOT/components/com_kunena/kunena.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 |
**زمان پرس و جو: 5.82 ms** **پس از آخرین پرس و جو: 21.52 ms** **حافظه پرس و جو: 0.011 MB حافظه قبل از پرس و جوی: 12.945 MB** **سطرهای بازگشتی: 51**
SHOW FULL COLUMNS
FROM `ercem_kunena_users`
**توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `ercem_kunena_users`**
| Status | Duration |
|---|
| Starting | 0.44 ms |
| checking permissions | 0.09 ms |
| closing tables | 0.05 ms |
| checking permissions | 0.04 ms |
| Opening tables | 1.87 ms |
| After opening tables | 0.08 ms |
| System lock | 0.02 ms |
| table lock | 0.03 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.05 ms |
| Preparing | 0.06 ms |
| Executing | 0.04 ms |
| Filling schema table | 0.08 ms |
| Opening tables | 0.10 ms |
| After opening tables | 0.05 ms |
| checking permissions | 0.57 ms |
| closing tables | 0.10 ms |
| checking permissions | 0.05 ms |
| Executing | 0.04 ms |
| Sending data | 0.30 ms |
| End of update loop | 0.10 ms |
| Query end | 0.05 ms |
| closing tables | 0.04 ms |
| Removing tmp table | 0.49 ms |
| closing tables | 0.06 ms |
| Unlocking tables | 0.08 ms |
| closing tables | 0.03 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.28 ms |
| Updating status | 0.11 ms |
| Reset for next command | 0.06 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 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/libraries/kunena/tables/kunenausers.php:329 |
| 18 | TableKunenaUsers->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 17 | Joomla\CMS\Table\Table::getInstance() | JROOT/libraries/kunena/user/user.php:252 |
| 16 | KunenaUser->getTable() | JROOT/libraries/kunena/user/user.php:275 |
| 15 | KunenaUser->load() | JROOT/libraries/kunena/user/user.php:100 |
| 14 | KunenaUser->__construct() | JROOT/libraries/kunena/user/helper.php:59 |
| 13 | KunenaUserHelper::initialize() | JROOT/libraries/kunena/user/helper.php:13 |
| 12 | include_once JROOT/libraries/kunena/user/helper.php | JROOT/libraries/loader.php:738 |
| 11 | JLoader::_load() | JROOT/libraries/loader.php:707 |
| 10 | JLoader::_autoload() | **به نظر می رسد خط زیر فراخونده شده باشد.** |
| 9 | spl_autoload_call() | JROOT/libraries/kunena/controller/application/display.php:227 |
| 8 | KunenaControllerApplicationDisplay->before() | JROOT/libraries/kunena/controller/application/display.php:83 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:96 |
| 6 | require_once JROOT/components/com_kunena/kunena.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 |
**زمان پرس و جو: 7.84 ms** **پس از آخرین پرس و جو: 69.26 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.787 MB** **سطرهای بازگشتی: 50**
SELECT `id`,`name`,`rules`,`parent_id`
FROM `ercem_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_breezingforms','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_jmap','com_joomlaupdate','com_jrealtimeanalytics','com_k2','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rokcandy','com_rstbox','com_rsticketspro','com_search','com_sppagebuilder','com_spsimpleportfolio','com_tags','com_templates','com_uniterevolution2','com_users','com_virtuemart','com_virtuemart_allinone','com_wrapper')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_assets | ALL | idx_asset_name | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 374 | Using where |
| Status | Duration |
|---|
| Starting | 0.61 ms |
| checking permissions | 0.21 ms |
| Opening tables | 0.15 ms |
| After opening tables | 0.08 ms |
| System lock | 0.04 ms |
| table lock | 0.05 ms |
| init | 0.22 ms |
| Optimizing | 0.60 ms |
| Statistics | 1.46 ms |
| Preparing | 0.21 ms |
| Executing | 0.19 ms |
| Sending data | 2.51 ms |
| End of update loop | 0.10 ms |
| Query end | 0.05 ms |
| Commit | 0.05 ms |
| Query end | 0.04 ms |
| closing tables | 0.04 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.04 ms |
| Query end | 0.05 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.60 ms |
| Updating status | 0.15 ms |
| Reset for next command | 0.09 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 17 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 16 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 15 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/plugins/kunena/joomla/access.php:461 |
| 14 | KunenaAccessJoomla->getAuthorisedUsers() | JROOT/plugins/kunena/joomla/access.php:233 |
| 13 | KunenaAccessJoomla->loadCategoryRoles() | JROOT/libraries/kunena/access.php:125 |
| 12 | KunenaAccess->clearCache() | JROOT/libraries/kunena/access.php:82 |
| 11 | KunenaAccess->__construct() | JROOT/libraries/kunena/access.php:97 |
| 10 | KunenaAccess::getInstance() | JROOT/libraries/kunena/user/user.php:441 |
| 9 | KunenaUser->isAdmin() | JROOT/libraries/kunena/controller/application/display.php:233 |
| 8 | KunenaControllerApplicationDisplay->before() | JROOT/libraries/kunena/controller/application/display.php:83 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:96 |
| 6 | require_once JROOT/components/com_kunena/kunena.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 |
**زمان پرس و جو: 7.27 ms** **پس از آخرین پرس و جو: 2.17 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.887 MB** **سطرهای بازگشتی: 1**
**پرس و جوی تکراری**:
#32SELECT DISTINCT(user_id)
FROM ercem_usergroups as ug1
INNER JOIN ercem_usergroups AS ug2
ON ug2.lft>=ug1.lft
AND ug1.rgt>=ug2.rgt
INNER JOIN ercem_user_usergroup_map AS m
ON ug2.id=m.group_id
WHERE ug1.id IN (8)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ug1 | const | PRIMARY,idx_usergroup_nested_set_lookup | PRIMARY | 4 | const | 1 | Using temporary |
| 1 | SIMPLE | ug2 | range | PRIMARY,idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 1 | Using where; Using index |
| 1 | SIMPLE | m | ALL | NULL | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 7363 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.68 ms |
| checking permissions | 0.10 ms |
| Opening tables | 0.15 ms |
| After opening tables | 0.08 ms |
| System lock | 0.05 ms |
| table lock | 0.05 ms |
| init | 0.08 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.15 ms |
| Preparing | 0.04 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.05 ms |
| Creating tmp table | 0.09 ms |
| Executing | 0.03 ms |
| Sending data | 4.48 ms |
| Removing tmp table | 0.28 ms |
| Sending data | 0.07 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| Commit | 0.02 ms |
| Query end | 0.03 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.02 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.24 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.04 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/plugins/kunena/joomla/access.php:441 |
| 15 | KunenaAccessJoomla->getUsersByGroup() | JROOT/plugins/kunena/joomla/access.php:492 |
| 14 | KunenaAccessJoomla->getAuthorisedUsers() | JROOT/plugins/kunena/joomla/access.php:233 |
| 13 | KunenaAccessJoomla->loadCategoryRoles() | JROOT/libraries/kunena/access.php:125 |
| 12 | KunenaAccess->clearCache() | JROOT/libraries/kunena/access.php:82 |
| 11 | KunenaAccess->__construct() | JROOT/libraries/kunena/access.php:97 |
| 10 | KunenaAccess::getInstance() | JROOT/libraries/kunena/user/user.php:441 |
| 9 | KunenaUser->isAdmin() | JROOT/libraries/kunena/controller/application/display.php:233 |
| 8 | KunenaControllerApplicationDisplay->before() | JROOT/libraries/kunena/controller/application/display.php:83 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:96 |
| 6 | require_once JROOT/components/com_kunena/kunena.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 |
**زمان پرس و جو: 6.82 ms** **پس از آخرین پرس و جو: 0.24 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.896 MB** **سطرهای بازگشتی: 0**
**پرس و جوی تکراری**:
#33SELECT DISTINCT(user_id)
FROM ercem_usergroups as ug1
INNER JOIN ercem_usergroups AS ug2
ON ug2.lft>=ug1.lft
AND ug1.rgt>=ug2.rgt
INNER JOIN ercem_user_usergroup_map AS m
ON ug2.id=m.group_id
WHERE ug1.id IN (7)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ug1 | const | PRIMARY,idx_usergroup_nested_set_lookup | PRIMARY | 4 | const | 1 | Using temporary |
| 1 | SIMPLE | ug2 | range | PRIMARY,idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 6 | Using where; Using index |
| 1 | SIMPLE | m | ALL | NULL | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 7363 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.30 ms |
| checking permissions | 0.06 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.04 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.13 ms |
| Preparing | 0.04 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.04 ms |
| Creating tmp table | 0.09 ms |
| Executing | 0.03 ms |
| Sending data | 4.72 ms |
| Removing tmp table | 0.06 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.19 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.04 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/plugins/kunena/joomla/access.php:441 |
| 15 | KunenaAccessJoomla->getUsersByGroup() | JROOT/plugins/kunena/joomla/access.php:492 |
| 14 | KunenaAccessJoomla->getAuthorisedUsers() | JROOT/plugins/kunena/joomla/access.php:233 |
| 13 | KunenaAccessJoomla->loadCategoryRoles() | JROOT/libraries/kunena/access.php:125 |
| 12 | KunenaAccess->clearCache() | JROOT/libraries/kunena/access.php:82 |
| 11 | KunenaAccess->__construct() | JROOT/libraries/kunena/access.php:97 |
| 10 | KunenaAccess::getInstance() | JROOT/libraries/kunena/user/user.php:441 |
| 9 | KunenaUser->isAdmin() | JROOT/libraries/kunena/controller/application/display.php:233 |
| 8 | KunenaControllerApplicationDisplay->before() | JROOT/libraries/kunena/controller/application/display.php:83 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:96 |
| 6 | require_once JROOT/components/com_kunena/kunena.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 |
**زمان پرس و جو: 2.17 ms** **پس از آخرین پرس و جو: 0.25 ms** **حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 13.902 MB** **سطرهای بازگشتی: 0**
**پرس و جوی تکراری**:
#34SELECT user_id, category_id, role
FROM ercem_kunena_user_categories
WHERE role IN (1,2)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_kunena_user_categories | range | role | role | 1 | NULL | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.28 ms |
| checking permissions | 0.11 ms |
| Opening tables | 0.08 ms |
| After opening tables | 0.05 ms |
| System lock | 0.03 ms |
| table lock | 0.04 ms |
| init | 0.07 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.12 ms |
| Preparing | 0.09 ms |
| Executing | 0.04 ms |
| Sending data | 0.09 ms |
| End of update loop | 0.08 ms |
| Query end | 0.04 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.11 ms |
| closing tables | 0.07 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.32 ms |
| Updating status | 0.11 ms |
| Reset for next command | 0.08 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/kunena/access.php:136 |
| 12 | KunenaAccess->clearCache() | JROOT/libraries/kunena/access.php:82 |
| 11 | KunenaAccess->__construct() | JROOT/libraries/kunena/access.php:97 |
| 10 | KunenaAccess::getInstance() | JROOT/libraries/kunena/user/user.php:441 |
| 9 | KunenaUser->isAdmin() | JROOT/libraries/kunena/controller/application/display.php:233 |
| 8 | KunenaControllerApplicationDisplay->before() | JROOT/libraries/kunena/controller/application/display.php:83 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:96 |
| 6 | require_once JROOT/components/com_kunena/kunena.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 |
**زمان پرس و جو: 3.33 ms** **پس از آخرین پرس و جو: 10.74 ms** **حافظه پرس و جو: 0.011 MB حافظه قبل از پرس و جوی: 14.121 MB** **سطرهای بازگشتی: 16**
SHOW FULL COLUMNS
FROM `ercem_users`
**توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `ercem_users`**
| Status | Duration |
|---|
| Starting | 0.27 ms |
| checking permissions | 0.04 ms |
| closing tables | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.94 ms |
| After opening tables | 0.07 ms |
| System lock | 0.02 ms |
| table lock | 0.10 ms |
| init | 0.05 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.03 ms |
| Preparing | 0.04 ms |
| Executing | 0.02 ms |
| Filling schema table | 0.03 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.02 ms |
| checking permissions | 0.17 ms |
| closing tables | 0.03 ms |
| checking permissions | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.23 ms |
| End of update loop | 0.07 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Removing tmp table | 0.36 ms |
| closing tables | 0.05 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.19 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.04 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 23 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 22 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 21 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/User.php:41 |
| 20 | Joomla\CMS\Table\User->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 19 | Joomla\CMS\Table\Table::getInstance() | JROOT/libraries/src/User/User.php:603 |
| 18 | Joomla\CMS\User\User::getTable() | JROOT/libraries/src/User/User.php:871 |
| 17 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
| 16 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
| 15 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
| 14 | Joomla\CMS\Factory::getUser() | JROOT/components/com_kunena/controller/user/item/display.php:68 |
| 13 | ComponentKunenaControllerUserItemDisplay->before() | JROOT/libraries/kunena/controller/display.php:31 |
| 12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/layout/page.php:46 |
| 11 | KunenaLayoutPage->execute() | JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php:13 |
| 10 | include JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:123 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:96 |
| 6 | require_once JROOT/components/com_kunena/kunena.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 |
**زمان پرس و جو: 1.70 ms** **پس از آخرین پرس و جو: 0.36 ms** **حافظه پرس و جو: 0.010 MB حافظه قبل از پرس و جوی: 14.157 MB** **سطرهای بازگشتی: 1**
SELECT *
FROM `ercem_users`
WHERE `id` = 802
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_users | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.25 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.12 ms |
| Preparing | 0.03 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.10 ms |
| Executing | 0.04 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.07 ms |
| closing tables | 0.06 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.24 ms |
| Updating status | 0.08 ms |
| Reset for next command | 0.04 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 19 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/User.php:87 |
| 18 | Joomla\CMS\Table\User->load() | JROOT/libraries/src/User/User.php:874 |
| 17 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
| 16 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
| 15 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
| 14 | Joomla\CMS\Factory::getUser() | JROOT/components/com_kunena/controller/user/item/display.php:68 |
| 13 | ComponentKunenaControllerUserItemDisplay->before() | JROOT/libraries/kunena/controller/display.php:31 |
| 12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/layout/page.php:46 |
| 11 | KunenaLayoutPage->execute() | JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php:13 |
| 10 | include JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:123 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:96 |
| 6 | require_once JROOT/components/com_kunena/kunena.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 |
**زمان پرس و جو: 2.92 ms** **پس از آخرین پرس و جو: 7.77 ms** **حافظه پرس و جو: 0.010 MB حافظه قبل از پرس و جوی: 14.905 MB** **سطرهای بازگشتی: 1**
SELECT `g`.`id`,`g`.`title`
FROM `ercem_usergroups` AS g
INNER JOIN `ercem_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 802
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | applyaus_austria.m.group_id | 1 | |
| Status | Duration |
|---|
| Starting | 0.54 ms |
| checking permissions | 0.08 ms |
| Opening tables | 0.08 ms |
| After opening tables | 0.12 ms |
| System lock | 0.10 ms |
| table lock | 0.06 ms |
| init | 0.08 ms |
| Optimizing | 0.08 ms |
| Statistics | 0.24 ms |
| Preparing | 0.17 ms |
| Executing | 0.08 ms |
| Sending data | 0.15 ms |
| End of update loop | 0.08 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.05 ms |
| Query end | 0.05 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.43 ms |
| Updating status | 0.12 ms |
| Reset for next command | 0.08 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 19 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Table/User.php:112 |
| 18 | Joomla\CMS\Table\User->load() | JROOT/libraries/src/User/User.php:874 |
| 17 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
| 16 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
| 15 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
| 14 | Joomla\CMS\Factory::getUser() | JROOT/components/com_kunena/controller/user/item/display.php:68 |
| 13 | ComponentKunenaControllerUserItemDisplay->before() | JROOT/libraries/kunena/controller/display.php:31 |
| 12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/layout/page.php:46 |
| 11 | KunenaLayoutPage->execute() | JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php:13 |
| 10 | include JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:123 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:96 |
| 6 | require_once JROOT/components/com_kunena/kunena.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 |
**زمان پرس و جو: 2.77 ms** **پس از آخرین پرس و جو: 0.37 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 14.920 MB** **سطرهای بازگشتی: 1**
SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
FROM ercem_users AS u
LEFT JOIN ercem_kunena_users AS ku
ON u.id = ku.userid
WHERE u.id = 802
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | u | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | ku | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.52 ms |
| checking permissions | 0.08 ms |
| Opening tables | 0.10 ms |
| After opening tables | 0.08 ms |
| System lock | 0.07 ms |
| table lock | 0.10 ms |
| init | 0.15 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.19 ms |
| Preparing | 0.06 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.04 ms |
| Executing | 0.03 ms |
| Sending data | 0.13 ms |
| End of update loop | 0.07 ms |
| Query end | 0.04 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.07 ms |
| Query end | 0.06 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.31 ms |
| Updating status | 0.12 ms |
| Reset for next command | 0.08 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 18 | JDatabaseDriver->loadAssoc() | JROOT/libraries/kunena/tables/kunenausers.php:365 |
| 17 | TableKunenaUsers->load() | JROOT/libraries/kunena/user/user.php:280 |
| 16 | KunenaUser->load() | JROOT/libraries/kunena/user/user.php:100 |
| 15 | KunenaUser->__construct() | JROOT/libraries/kunena/user/helper.php:115 |
| 14 | KunenaUserHelper::get() | JROOT/components/com_kunena/controller/user/item/display.php:69 |
| 13 | ComponentKunenaControllerUserItemDisplay->before() | JROOT/libraries/kunena/controller/display.php:31 |
| 12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/layout/page.php:46 |
| 11 | KunenaLayoutPage->execute() | JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php:13 |
| 10 | include JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:123 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:96 |
| 6 | require_once JROOT/components/com_kunena/kunena.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 |
**زمان پرس و جو: 4.06 ms** **پس از آخرین پرس و جو: 0.74 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 14.941 MB**
UPDATE `ercem_kunena_users`
SET `view`='',`moderator`='0',`ordering`='0',`posts`='0',`karma`='0',`karma_time`='0',`group_id`='1',`uhits`='1',`gender`='0',`birthdate`='0001-01-01',`rank`='0',`hideEmail`='1',`showOnline`='1',`thankyou`='0',`canSubscribe`='-1',`userListtime`='-2',`status`='0',`status_text`='',`ip`=''
WHERE `userid`='802'
**توضیحات در جستجو ممکن نیست: UPDATE `ercem_kunena_users` SET `view`='',`moderator`='0',`ordering`='0',`posts`='0',`karma`='0',`karma_time`='0',`group_id`='1',`uhits`='1',`gender`='0',`birthdate`='0001-01-01',`rank`='0',`hideEmail`='1',`showOnline`='1',`thankyou`='0',`canSubscribe`='-1',`userListtime`='-2',`status`='0',`status_text`='',`ip`='' WHERE `userid`='802'**
| Status | Duration |
|---|
| Starting | 0.75 ms |
| checking permissions | 0.06 ms |
| Opening tables | 0.07 ms |
| checking permissions | 0.06 ms |
| After opening tables | 0.02 ms |
| init for update | 0.02 ms |
| init | 0.04 ms |
| Updating main table | 0.03 ms |
| init | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.02 ms |
| init for update | 0.07 ms |
| Updating | 0.27 ms |
| End of update loop | 0.04 ms |
| Waiting for query cache lock | 0.02 ms |
| End of update loop | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 1.28 ms |
| Query end | 0.07 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.19 ms |
| Updating status | 0.26 ms |
| Reset for next command | 0.06 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/kunena/tables/kunena.php:319 |
| 16 | KunenaTable->updateObject() | JROOT/libraries/kunena/tables/kunena.php:161 |
| 15 | KunenaTable->store() | JROOT/libraries/kunena/user/user.php:327 |
| 14 | KunenaUser->save() | JROOT/components/com_kunena/controller/user/item/display.php:76 |
| 13 | ComponentKunenaControllerUserItemDisplay->before() | JROOT/libraries/kunena/controller/display.php:31 |
| 12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/layout/page.php:46 |
| 11 | KunenaLayoutPage->execute() | JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php:13 |
| 10 | include JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:123 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:96 |
| 6 | require_once JROOT/components/com_kunena/kunena.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 |
**زمان پرس و جو: 10.58 ms** **پس از آخرین پرس و جو: 0.26 ms** **حافظه پرس و جو: 0.010 MB حافظه قبل از پرس و جوی: 14.949 MB** **سطرهای بازگشتی: 1**
**پرس و جوی تکراری**:
#24SELECT DISTINCT(user_id)
FROM ercem_usergroups as ug1
INNER JOIN ercem_usergroups AS ug2
ON ug2.lft>=ug1.lft
AND ug1.rgt>=ug2.rgt
INNER JOIN ercem_user_usergroup_map AS m
ON ug2.id=m.group_id
WHERE ug1.id IN (8)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ug1 | const | PRIMARY,idx_usergroup_nested_set_lookup | PRIMARY | 4 | const | 1 | Using temporary |
| 1 | SIMPLE | ug2 | range | PRIMARY,idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 1 | Using where; Using index |
| 1 | SIMPLE | m | ALL | NULL | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 7363 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.50 ms |
| checking permissions | 0.08 ms |
| Opening tables | 0.08 ms |
| After opening tables | 0.05 ms |
| System lock | 0.03 ms |
| table lock | 0.04 ms |
| init | 0.07 ms |
| Optimizing | 0.10 ms |
| Statistics | 0.29 ms |
| Preparing | 0.09 ms |
| Unlocking tables | 0.05 ms |
| Preparing | 0.07 ms |
| Creating tmp table | 0.13 ms |
| Executing | 0.08 ms |
| Sending data | 6.85 ms |
| Removing tmp table | 0.27 ms |
| Sending data | 0.08 ms |
| End of update loop | 0.05 ms |
| Query end | 0.05 ms |
| Commit | 0.04 ms |
| Query end | 0.04 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.35 ms |
| Starting cleanup | 0.37 ms |
| Freeing items | 0.41 ms |
| Updating status | 0.14 ms |
| Reset for next command | 0.09 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 19 | JDatabaseDriver->loadColumn() | JROOT/plugins/kunena/joomla/access.php:441 |
| 18 | KunenaAccessJoomla->getUsersByGroup() | JROOT/plugins/kunena/joomla/access.php:492 |
| 17 | KunenaAccessJoomla->getAuthorisedUsers() | JROOT/plugins/kunena/joomla/access.php:233 |
| 16 | KunenaAccessJoomla->loadCategoryRoles() | JROOT/libraries/kunena/access.php:125 |
| 15 | KunenaAccess->clearCache() | JROOT/libraries/kunena/user/user.php:333 |
| 14 | KunenaUser->save() | JROOT/components/com_kunena/controller/user/item/display.php:76 |
| 13 | ComponentKunenaControllerUserItemDisplay->before() | JROOT/libraries/kunena/controller/display.php:31 |
| 12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/layout/page.php:46 |
| 11 | KunenaLayoutPage->execute() | JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php:13 |
| 10 | include JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:123 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:96 |
| 6 | require_once JROOT/components/com_kunena/kunena.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 |
**زمان پرس و جو: 9.21 ms** **پس از آخرین پرس و جو: 0.21 ms** **حافظه پرس و جو: 0.011 MB حافظه قبل از پرس و جوی: 14.966 MB** **سطرهای بازگشتی: 0**
**پرس و جوی تکراری**:
#25SELECT DISTINCT(user_id)
FROM ercem_usergroups as ug1
INNER JOIN ercem_usergroups AS ug2
ON ug2.lft>=ug1.lft
AND ug1.rgt>=ug2.rgt
INNER JOIN ercem_user_usergroup_map AS m
ON ug2.id=m.group_id
WHERE ug1.id IN (7)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ug1 | const | PRIMARY,idx_usergroup_nested_set_lookup | PRIMARY | 4 | const | 1 | Using temporary |
| 1 | SIMPLE | ug2 | range | PRIMARY,idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 6 | Using where; Using index |
| 1 | SIMPLE | m | ALL | NULL | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 7363 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.46 ms |
| checking permissions | 0.10 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.05 ms |
| System lock | 0.03 ms |
| table lock | 0.04 ms |
| init | 0.07 ms |
| Optimizing | 0.10 ms |
| Statistics | 0.20 ms |
| Preparing | 0.06 ms |
| Unlocking tables | 0.04 ms |
| Preparing | 0.07 ms |
| Creating tmp table | 0.18 ms |
| Executing | 0.08 ms |
| Sending data | 6.62 ms |
| Removing tmp table | 0.12 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.10 ms |
| Query end | 0.05 ms |
| Commit | 0.04 ms |
| Query end | 0.04 ms |
| closing tables | 0.04 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.21 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.04 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 19 | JDatabaseDriver->loadColumn() | JROOT/plugins/kunena/joomla/access.php:441 |
| 18 | KunenaAccessJoomla->getUsersByGroup() | JROOT/plugins/kunena/joomla/access.php:492 |
| 17 | KunenaAccessJoomla->getAuthorisedUsers() | JROOT/plugins/kunena/joomla/access.php:233 |
| 16 | KunenaAccessJoomla->loadCategoryRoles() | JROOT/libraries/kunena/access.php:125 |
| 15 | KunenaAccess->clearCache() | JROOT/libraries/kunena/user/user.php:333 |
| 14 | KunenaUser->save() | JROOT/components/com_kunena/controller/user/item/display.php:76 |
| 13 | ComponentKunenaControllerUserItemDisplay->before() | JROOT/libraries/kunena/controller/display.php:31 |
| 12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/layout/page.php:46 |
| 11 | KunenaLayoutPage->execute() | JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php:13 |
| 10 | include JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:123 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:96 |
| 6 | require_once JROOT/components/com_kunena/kunena.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 |
**زمان پرس و جو: 12.29 ms** **پس از آخرین پرس و جو: 0.22 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 14.974 MB** **سطرهای بازگشتی: 0**
**پرس و جوی تکراری**:
#26SELECT user_id, category_id, role
FROM ercem_kunena_user_categories
WHERE role IN (1,2)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_kunena_user_categories | range | role | role | 1 | NULL | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.30 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.09 ms |
| Preparing | 0.06 ms |
| Executing | 0.05 ms |
| Sending data | 0.09 ms |
| End of update loop | 0.06 ms |
| Query end | 0.07 ms |
| Commit | 0.04 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.05 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.33 ms |
| Updating status | 0.09 ms |
| Reset for next command | 0.05 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/kunena/access.php:136 |
| 15 | KunenaAccess->clearCache() | JROOT/libraries/kunena/user/user.php:333 |
| 14 | KunenaUser->save() | JROOT/components/com_kunena/controller/user/item/display.php:76 |
| 13 | ComponentKunenaControllerUserItemDisplay->before() | JROOT/libraries/kunena/controller/display.php:31 |
| 12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/layout/page.php:46 |
| 11 | KunenaLayoutPage->execute() | JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php:13 |
| 10 | include JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:123 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:96 |
| 6 | require_once JROOT/components/com_kunena/kunena.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 |
**زمان پرس و جو: 4.38 ms** **پس از آخرین پرس و جو: 5.95 ms** **حافظه پرس و جو: 0.012 MB حافظه قبل از پرس و جوی: 15.122 MB** **سطرهای بازگشتی: 13**
SHOW FULL COLUMNS
FROM `ercem_kunena_users_banned`
**توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `ercem_kunena_users_banned`**
| Status | Duration |
|---|
| Starting | 0.38 ms |
| checking permissions | 0.05 ms |
| closing tables | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 1.54 ms |
| After opening tables | 0.08 ms |
| System lock | 0.04 ms |
| table lock | 0.04 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.03 ms |
| Preparing | 0.06 ms |
| Executing | 0.02 ms |
| Filling schema table | 0.03 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.03 ms |
| checking permissions | 0.18 ms |
| closing tables | 0.04 ms |
| checking permissions | 0.03 ms |
| Executing | 0.05 ms |
| Sending data | 0.13 ms |
| End of update loop | 0.05 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Removing tmp table | 0.41 ms |
| closing tables | 0.07 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.04 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.07 ms |
| Freeing items | 0.35 ms |
| Updating status | 0.10 ms |
| Reset for next command | 0.05 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 25 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 24 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 23 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 22 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/kunena/tables/kunenauserbans.php:43 |
| 21 | TableKunenaUserBans->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 20 | Joomla\CMS\Table\Table::getInstance() | JROOT/libraries/kunena/user/ban.php:356 |
| 19 | KunenaUserBan->getTable() | JROOT/libraries/kunena/user/ban.php:380 |
| 18 | KunenaUserBan->load() | JROOT/libraries/kunena/user/ban.php:56 |
| 17 | KunenaUserBan->__construct() | JROOT/libraries/kunena/user/ban.php:202 |
| 16 | KunenaUserBan::getInstanceByUserid() | JROOT/components/com_kunena/layout/user/item.php:29 |
| 15 | KunenaLayoutUserItem->getTabs() | JROOT/components/com_kunena/template/crypsisb3/layouts/user/item/default.php:13 |
| 14 | include JROOT/components/com_kunena/template/crypsisb3/layouts/user/item/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 13 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 12 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:91 |
| 11 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php:20 |
| 10 | include JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:123 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:96 |
| 6 | require_once JROOT/components/com_kunena/kunena.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 |
**زمان پرس و جو: 3.75 ms** **پس از آخرین پرس و جو: 0.37 ms** **حافظه پرس و جو: 0.010 MB حافظه قبل از پرس و جوی: 15.152 MB** **سطرهای بازگشتی: 0**
SELECT *
FROM ercem_kunena_users_banned
WHERE userid = '802'
AND (expiration = '0000-00-00 00:00:00' OR expiration > '2026-01-01 09:57:05')
ORDER BY id DESC
LIMIT 0, 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_kunena_users_banned | ref | userid,expiration | userid | 5 | const | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.42 ms |
| checking permissions | 0.08 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.08 ms |
| System lock | 0.05 ms |
| table lock | 0.03 ms |
| init | 0.09 ms |
| Optimizing | 0.09 ms |
| Statistics | 0.17 ms |
| Preparing | 0.11 ms |
| Sorting result | 0.06 ms |
| Executing | 0.04 ms |
| Sending data | 0.10 ms |
| End of update loop | 0.06 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.08 ms |
| Unlocking tables | 0.05 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 1.38 ms |
| Updating status | 0.09 ms |
| Reset for next command | 0.05 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 19 | JDatabaseDriver->loadAssoc() | JROOT/libraries/kunena/tables/kunenauserbans.php:72 |
| 18 | TableKunenaUserBans->loadByUserid() | JROOT/libraries/kunena/user/ban.php:406 |
| 17 | KunenaUserBan->loadByUserid() | JROOT/libraries/kunena/user/ban.php:203 |
| 16 | KunenaUserBan::getInstanceByUserid() | JROOT/components/com_kunena/layout/user/item.php:29 |
| 15 | KunenaLayoutUserItem->getTabs() | JROOT/components/com_kunena/template/crypsisb3/layouts/user/item/default.php:13 |
| 14 | include JROOT/components/com_kunena/template/crypsisb3/layouts/user/item/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 13 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 12 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:91 |
| 11 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php:20 |
| 10 | include JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:123 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:96 |
| 6 | require_once JROOT/components/com_kunena/kunena.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 |
**زمان پرس و جو: 2.44 ms** **پس از آخرین پرس و جو: 7.61 ms** **حافظه پرس و جو: 0.011 MB حافظه قبل از پرس و جوی: 15.423 MB** **سطرهای بازگشتی: 10**
SELECT *
FROM ercem_kunena_ranks
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_kunena_ranks | ALL | NULL | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 10 | |
| Status | Duration |
|---|
| Starting | 0.42 ms |
| checking permissions | 0.13 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.13 ms |
| Preparing | 0.12 ms |
| Executing | 0.06 ms |
| Sending data | 0.19 ms |
| End of update loop | 0.07 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.07 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.44 ms |
| Updating status | 0.11 ms |
| Reset for next command | 0.06 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/kunena/user/user.php:766 |
| 19 | KunenaUser->getRank() | JROOT/components/com_kunena/template/crypsisb3/layouts/user/item/summary/default.php:35 |
| 18 | include JROOT/components/com_kunena/template/crypsisb3/layouts/user/item/summary/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 17 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 16 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:91 |
| 15 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/template/crypsisb3/layouts/user/item/default.php:33 |
| 14 | include JROOT/components/com_kunena/template/crypsisb3/layouts/user/item/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 13 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 12 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:91 |
| 11 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php:20 |
| 10 | include JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:123 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:96 |
| 6 | require_once JROOT/components/com_kunena/kunena.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 |
**زمان پرس و جو: 1.42 ms** **پس از آخرین پرس و جو: 1.68 ms** **حافظه پرس و جو: 0.013 MB حافظه قبل از پرس و جوی: 15.470 MB** **سطرهای بازگشتی: 0**
SELECT userid, MAX(time) AS time
FROM ercem_session
WHERE client_id=0
AND userid>0
AND time > 1767259625
GROUP BY userid
ORDER BY time DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_session | range | userid,time,client_id_guest | userid | 5 | NULL | 1 | Using index condition; Using where; Using temporary; **با استفاده از مرتب سازی فایل** |
| Status | Duration |
|---|
| Starting | 0.20 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.14 ms |
| Preparing | 0.06 ms |
| Creating tmp table | 0.06 ms |
| Sorting for group | 0.05 ms |
| Sorting result | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.07 ms |
| Creating sort index | 0.05 ms |
| Removing tmp table | 0.02 ms |
| Creating sort index | 0.02 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.13 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.03 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/kunena/user/helper.php:365 |
| 25 | KunenaUserHelper::getOnlineUsers() | JROOT/libraries/kunena/user/helper.php:524 |
| 24 | KunenaUserHelper::getStatus() | JROOT/libraries/kunena/user/user.php:384 |
| 23 | KunenaUser->getStatus() | JROOT/components/com_kunena/template/crypsisb3/layouts/user/item/status/default.php:14 |
| 22 | include JROOT/components/com_kunena/template/crypsisb3/layouts/user/item/status/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 21 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 20 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:91 |
| 19 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/template/crypsisb3/layouts/user/item/summary/default.php:47 |
| 18 | include JROOT/components/com_kunena/template/crypsisb3/layouts/user/item/summary/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 17 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 16 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:91 |
| 15 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/template/crypsisb3/layouts/user/item/default.php:33 |
| 14 | include JROOT/components/com_kunena/template/crypsisb3/layouts/user/item/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 13 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 12 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:91 |
| 11 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php:20 |
| 10 | include JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:123 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:96 |
| 6 | require_once JROOT/components/com_kunena/kunena.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 |
**زمان پرس و جو: 2.16 ms** **پس از آخرین پرس و جو: 17.82 ms** **حافظه پرس و جو: 0.012 MB حافظه قبل از پرس و جوی: 15.866 MB** **سطرهای بازگشتی: 6**
SELECT *
FROM ercem_kunena_categories
ORDER BY ordering, name
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_kunena_categories | ALL | NULL | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 6 | **با استفاده از مرتب سازی فایل** |
| Status | Duration |
|---|
| Starting | 0.31 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.04 ms |
| init | 0.09 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.04 ms |
| Preparing | 0.03 ms |
| Sorting result | 0.17 ms |
| Executing | 0.08 ms |
| Sending data | 0.05 ms |
| Creating sort index | 0.22 ms |
| End of update loop | 0.05 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.10 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.22 ms |
| Updating status | 0.08 ms |
| Reset for next command | 0.04 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/kunena/forum/category/helper.php:865 |
| 23 | KunenaForumCategoryHelper::loadCategories() | JROOT/libraries/kunena/forum/category/helper.php:43 |
| 22 | KunenaForumCategoryHelper::initialize() | JROOT/libraries/kunena/forum/category/helper.php:965 |
| 21 | include_once JROOT/libraries/kunena/forum/category/helper.php | JROOT/libraries/loader.php:738 |
| 20 | JLoader::_load() | JROOT/libraries/loader.php:707 |
| 19 | JLoader::_autoload() | **به نظر می رسد خط زیر فراخونده شده باشد.** |
| 18 | spl_autoload_call() | JROOT/components/com_kunena/controller/message/list/recent/display.php:120 |
| 17 | ComponentKunenaControllerMessageListRecentDisplay->before() | JROOT/libraries/kunena/controller/display.php:31 |
| 16 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/controller/display.php:127 |
| 15 | KunenaControllerDisplay->__toString() | JROOT/components/com_kunena/template/crypsisb3/layouts/user/item/default.php:54 |
| 14 | include JROOT/components/com_kunena/template/crypsisb3/layouts/user/item/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 13 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 12 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:91 |
| 11 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php:20 |
| 10 | include JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:123 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:96 |
| 6 | require_once JROOT/components/com_kunena/kunena.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 |
**زمان پرس و جو: 1.99 ms** **پس از آخرین پرس و جو: 7.29 ms** **حافظه پرس و جو: 0.010 MB حافظه قبل از پرس و جوی: 16.239 MB** **سطرهای بازگشتی: 1**
SELECT COUNT(*)
FROM ercem_kunena_messages AS a
WHERE a.userid=802
AND a.catid IN (2,1,3,4,5,6)
AND a.moved=0
AND a.hold IN (0)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ref | userid,hold_time,catid_parent | userid | 4 | const | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.44 ms |
| checking permissions | 0.11 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.09 ms |
| Optimizing | 0.12 ms |
| Statistics | 0.17 ms |
| Preparing | 0.08 ms |
| Executing | 0.06 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.21 ms |
| Updating status | 0.10 ms |
| Reset for next command | 0.05 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 19 | JDatabaseDriver->loadResult() | JROOT/libraries/kunena/database/object/finder.php:227 |
| 18 | KunenaDatabaseObjectFinder->count() | JROOT/components/com_kunena/controller/message/list/recent/display.php:123 |
| 17 | ComponentKunenaControllerMessageListRecentDisplay->before() | JROOT/libraries/kunena/controller/display.php:31 |
| 16 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/controller/display.php:127 |
| 15 | KunenaControllerDisplay->__toString() | JROOT/components/com_kunena/template/crypsisb3/layouts/user/item/default.php:54 |
| 14 | include JROOT/components/com_kunena/template/crypsisb3/layouts/user/item/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 13 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 12 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:91 |
| 11 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php:20 |
| 10 | include JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:123 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:96 |
| 6 | require_once JROOT/components/com_kunena/kunena.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 |
**زمان پرس و جو: 2.93 ms** **پس از آخرین پرس و جو: 46.54 ms** **حافظه پرس و جو: 0.010 MB حافظه قبل از پرس و جوی: 16.339 MB** **سطرهای بازگشتی: 0**
SELECT a.id
FROM ercem_kunena_messages AS a
WHERE a.userid=802
AND a.catid IN (2,1,3,4,5,6)
AND a.moved=0
AND a.hold IN (0)
ORDER BY a.`time` DESC
LIMIT 10
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ref | userid,hold_time,catid_parent | userid | 4 | const | 1 | Using where; **با استفاده از مرتب سازی فایل** |
| Status | Duration |
|---|
| Starting | 0.62 ms |
| checking permissions | 0.09 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.04 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.08 ms |
| Optimizing | 0.08 ms |
| Statistics | 0.24 ms |
| Preparing | 0.14 ms |
| Sorting result | 0.19 ms |
| Executing | 0.04 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.13 ms |
| End of update loop | 0.06 ms |
| Query end | 0.03 ms |
| Commit | 0.02 ms |
| Query end | 0.03 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.29 ms |
| Updating status | 0.35 ms |
| Reset for next command | 0.09 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 20 | JDatabaseDriver->loadColumn() | JROOT/libraries/kunena/database/object/finder.php:193 |
| 19 | KunenaDatabaseObjectFinder->find() | JROOT/libraries/kunena/forum/message/finder.php:197 |
| 18 | KunenaForumMessageFinder->find() | JROOT/components/com_kunena/controller/message/list/recent/display.php:191 |
| 17 | ComponentKunenaControllerMessageListRecentDisplay->before() | JROOT/libraries/kunena/controller/display.php:31 |
| 16 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/controller/display.php:127 |
| 15 | KunenaControllerDisplay->__toString() | JROOT/components/com_kunena/template/crypsisb3/layouts/user/item/default.php:54 |
| 14 | include JROOT/components/com_kunena/template/crypsisb3/layouts/user/item/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 13 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 12 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:91 |
| 11 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php:20 |
| 10 | include JROOT/components/com_kunena/template/crypsisb3/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:123 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:96 |
| 6 | require_once JROOT/components/com_kunena/kunena.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 |
**زمان پرس و جو: 9.29 ms** **پس از آخرین پرس و جو: 46.06 ms** **حافظه پرس و جو: 0.015 MB حافظه قبل از پرس و جوی: 17.260 MB** **سطرهای بازگشتی: 86**
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ercem_modules AS m
LEFT JOIN ercem_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ercem_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-01-01 09:57:05')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-01-01 09:57:05')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 1035 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ALL | PRIMARY,published,newsfeeds | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 161 | Using where; **با استفاده از مرتب سازی فایل** |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | applyaus_austria.m.id | 1 | Using where |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | applyaus_austria.m.module,const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.70 ms |
| checking permissions | 0.08 ms |
| Opening tables | 0.10 ms |
| After opening tables | 0.05 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.16 ms |
| Optimizing | 0.16 ms |
| Statistics | 0.23 ms |
| Preparing | 0.15 ms |
| Sorting result | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 0.04 ms |
| Creating sort index | 6.40 ms |
| End of update loop | 0.07 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.32 ms |
| Updating status | 0.15 ms |
| Reset for next command | 0.09 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 32 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 31 | JDatabaseDriver->loadObjectList() | **به نظر می رسد خط زیر فراخونده شده باشد.** |
| 30 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 29 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:432 |
| 28 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:362 |
| 27 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
| 26 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:591 |
| 25 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/components/com_kunena/layout/widget/module.php:33 |
| 24 | KunenaLayoutWidgetModule->renderPosition() | JROOT/components/com_kunena/template/crypsisb3/layouts/widget/module/default.php:13 |
| 23 | include JROOT/components/com_kunena/template/crypsisb3/layouts/widget/module/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 22 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 21 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:91 |
| 20 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/template/crypsisb3/layouts/widget/login/login/default.php:88 |
| 19 | include JROOT/components/com_kunena/template/crypsisb3/layouts/widget/login/login/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 18 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 17 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:91 |
| 16 | KunenaLayoutBase->__toString() | JROOT/libraries/kunena/controller/display.php:159 |
| 15 | KunenaControllerDisplay->__toString() | JROOT/components/com_kunena/template/crypsisb3/layouts/widget/menubar/default.php:18 |
| 14 | include JROOT/components/com_kunena/template/crypsisb3/layouts/widget/menubar/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 13 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 12 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:91 |
| 11 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/template/crypsisb3/layouts/page/default.php:20 |
| 10 | include JROOT/components/com_kunena/template/crypsisb3/layouts/page/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:91 |
| 7 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/kunena.php:131 |
| 6 | require_once JROOT/components/com_kunena/kunena.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 |
**زمان پرس و جو: 2.70 ms** **پس از آخرین پرس و جو: 41.16 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 17.694 MB** **سطرهای بازگشتی: 0**
SELECT *
FROM ercem_kunena_announcement
WHERE (published = 1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-01-01 09:57:05')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-01-01 09:57:05')
ORDER BY id DESC
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_kunena_announcement | index | NULL | PRIMARY | 4 | NULL | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.58 ms |
| checking permissions | 0.09 ms |
| Opening tables | 0.13 ms |
| After opening tables | 0.07 ms |
| System lock | 0.04 ms |
| table lock | 0.03 ms |
| init | 0.11 ms |
| Optimizing | 0.12 ms |
| Statistics | 0.08 ms |
| Preparing | 0.09 ms |
| Sorting result | 0.08 ms |
| Executing | 0.03 ms |
| Sending data | 0.09 ms |
| End of update loop | 0.05 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.07 ms |
| closing tables | 0.04 ms |
| Query end | 0.06 ms |
| Starting cleanup | 0.06 ms |
| Freeing items | 0.31 ms |
| Updating status | 0.18 ms |
| Reset for next command | 0.08 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 15 | JDatabaseDriver->loadAssocList() | JROOT/libraries/kunena/forum/announcement/helper.php:131 |
| 14 | KunenaForumAnnouncementHelper::getAnnouncements() | JROOT/components/com_kunena/controller/widget/announcement/display.php:40 |
| 13 | ComponentKunenaControllerWidgetAnnouncementDisplay->before() | JROOT/libraries/kunena/controller/display.php:31 |
| 12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/controller/display.php:127 |
| 11 | KunenaControllerDisplay->__toString() | JROOT/components/com_kunena/template/crypsisb3/layouts/page/default.php:35 |
| 10 | include JROOT/components/com_kunena/template/crypsisb3/layouts/page/default.php | JROOT/libraries/kunena/layout/base.php:183 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:69 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:91 |
| 7 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/kunena.php:131 |
| 6 | require_once JROOT/components/com_kunena/kunena.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 |
**زمان پرس و جو: 2.00 ms** **پس از آخرین پرس و جو: 33.37 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 18.490 MB** **سطرهای بازگشتی: 1**
SELECT `id`
FROM `ercem_rstbox`
WHERE `published` = 1
AND `testmode` = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_rstbox | ALL | NULL | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 11 | Using where |
| Status | Duration |
|---|
| Starting | 0.31 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.04 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.06 ms |
| Preparing | 0.13 ms |
| Executing | 0.06 ms |
| Sending data | 0.10 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.10 ms |
| closing tables | 0.05 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.40 ms |
| Updating status | 0.11 ms |
| Reset for next command | 0.15 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 9 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_rstbox/EngageBox/Boxes.php:41 |
| 8 | EngageBox\Boxes::render() | JROOT/plugins/system/rstbox/rstbox.php:68 |
| 7 | PlgSystemRstBox->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 1.81 ms** **پس از آخرین پرس و جو: 4.01 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 18.558 MB** **سطرهای بازگشتی: 1**
SELECT *
FROM `ercem_rstbox`
WHERE `id` = 11
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_rstbox | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.28 ms |
| checking permissions | 0.07 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.06 ms |
| System lock | 0.05 ms |
| table lock | 0.05 ms |
| init | 0.06 ms |
| Optimizing | 0.14 ms |
| Statistics | 0.11 ms |
| Preparing | 0.03 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.04 ms |
| Executing | 0.03 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.16 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.04 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 10 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_rstbox/EngageBox/Box.php:183 |
| 9 | EngageBox\Box::get() | JROOT/administrator/components/com_rstbox/EngageBox/Boxes.php:51 |
| 8 | EngageBox\Boxes::render() | JROOT/plugins/system/rstbox/rstbox.php:68 |
| 7 | PlgSystemRstBox->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 2.86 ms** **پس از آخرین پرس و جو: 79.48 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 19.214 MB** **سطرهای بازگشتی: 1**
SELECT enabled
FROM ercem_extensions
WHERE element = 'com_sppagebuilder'
AND type = 'component'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.60 ms |
| checking permissions | 0.09 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.04 ms |
| System lock | 0.04 ms |
| table lock | 0.03 ms |
| init | 0.09 ms |
| Optimizing | 0.08 ms |
| Statistics | 0.28 ms |
| Preparing | 0.14 ms |
| Executing | 0.04 ms |
| Sending data | 0.15 ms |
| End of update loop | 0.05 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.34 ms |
| Updating status | 0.11 ms |
| Reset for next command | 0.06 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 17 | JDatabaseDriver->loadResult() | JROOT/plugins/content/sppagebuilder/sppagebuilder.php:182 |
| 16 | PlgContentSppagebuilder->isSppagebuilderEnabled() | JROOT/plugins/content/sppagebuilder/sppagebuilder.php:36 |
| 15 | PlgContentSppagebuilder->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
| 14 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 13 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/cms/html/content.php:39 |
| 12 | JHtmlContent::prepare() | **به نظر می رسد خط زیر فراخونده شده باشد.** |
| 11 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
| 10 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
| 9 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/administrator/components/com_rstbox/EngageBox/Boxes.php:59 |
| 8 | EngageBox\Boxes::render() | JROOT/plugins/system/rstbox/rstbox.php:68 |
| 7 | PlgSystemRstBox->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 2.77 ms** **پس از آخرین پرس و جو: 295.75 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 20.655 MB** **سطرهای بازگشتی: 1**
SELECT `template`
FROM `ercem_template_styles`
WHERE `client_id` = 0
AND `home` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_template_styles | ALL | idx_client_id,idx_client_id_home | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 13 | Using where |
| Status | Duration |
|---|
| Starting | 0.56 ms |
| checking permissions | 0.07 ms |
| Opening tables | 0.12 ms |
| After opening tables | 0.06 ms |
| System lock | 0.04 ms |
| table lock | 0.04 ms |
| init | 0.07 ms |
| Optimizing | 0.09 ms |
| Statistics | 0.20 ms |
| Preparing | 0.11 ms |
| Executing | 0.05 ms |
| Sending data | 0.15 ms |
| End of update loop | 0.12 ms |
| Query end | 0.05 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.34 ms |
| Updating status | 0.11 ms |
| Reset for next command | 0.06 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 15 | JDatabaseDriver->loadObject() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:337 |
| 14 | AddonParser::getTemplateName() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:130 |
| 13 | AddonParser::getAddons() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:351 |
| 12 | require_once JROOT/components/com_sppagebuilder/parser/addon-parser.php | JROOT/modules/mod_sppagebuilder/tmpl/default.php:11 |
| 11 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:12 |
| 10 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 2.10 ms** **پس از آخرین پرس و جو: 87.12 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 21.962 MB** **سطرهای بازگشتی: 1**
SELECT `template`
FROM `ercem_template_styles`
WHERE `client_id` = 0
AND `home` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_template_styles | ALL | idx_client_id,idx_client_id_home | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 13 | Using where |
| Status | Duration |
|---|
| Starting | 0.45 ms |
| checking permissions | 0.06 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.05 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.08 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.18 ms |
| Preparing | 0.09 ms |
| Executing | 0.03 ms |
| Sending data | 0.13 ms |
| End of update loop | 0.05 ms |
| Query end | 0.02 ms |
| Commit | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.20 ms |
| Updating status | 0.08 ms |
| Reset for next command | 0.08 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 15 | JDatabaseDriver->loadObject() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:337 |
| 14 | AddonParser::getTemplateName() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:40 |
| 13 | AddonParser::getAddonPath() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:213 |
| 12 | AddonParser::viewAddons() | JROOT/modules/mod_sppagebuilder/tmpl/default.php:18 |
| 11 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:12 |
| 10 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 1.77 ms** **پس از آخرین پرس و جو: 6.45 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 22.042 MB** **سطرهای بازگشتی: 1**
SELECT `template`
FROM `ercem_template_styles`
WHERE `client_id` = 0
AND `home` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_template_styles | ALL | idx_client_id,idx_client_id_home | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 13 | Using where |
| Status | Duration |
|---|
| Starting | 0.47 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.06 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.13 ms |
| Preparing | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 0.10 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.23 ms |
| Updating status | 0.10 ms |
| Reset for next command | 0.08 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 15 | JDatabaseDriver->loadObject() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:337 |
| 14 | AddonParser::getTemplateName() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:40 |
| 13 | AddonParser::getAddonPath() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:213 |
| 12 | AddonParser::viewAddons() | JROOT/modules/mod_sppagebuilder/tmpl/default.php:18 |
| 11 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:12 |
| 10 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 1.86 ms** **پس از آخرین پرس و جو: 3.38 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 22.051 MB** **سطرهای بازگشتی: 1**
SELECT `template`
FROM `ercem_template_styles`
WHERE `client_id` = 0
AND `home` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_template_styles | ALL | idx_client_id,idx_client_id_home | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 13 | Using where |
| Status | Duration |
|---|
| Starting | 0.33 ms |
| checking permissions | 0.08 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.04 ms |
| System lock | 0.03 ms |
| table lock | 0.06 ms |
| init | 0.07 ms |
| Optimizing | 0.16 ms |
| Statistics | 0.15 ms |
| Preparing | 0.08 ms |
| Executing | 0.03 ms |
| Sending data | 0.07 ms |
| End of update loop | 0.06 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.19 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.04 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 15 | JDatabaseDriver->loadObject() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:337 |
| 14 | AddonParser::getTemplateName() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:40 |
| 13 | AddonParser::getAddonPath() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:213 |
| 12 | AddonParser::viewAddons() | JROOT/modules/mod_sppagebuilder/tmpl/default.php:18 |
| 11 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:12 |
| 10 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 2.61 ms** **پس از آخرین پرس و جو: 6.41 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 22.060 MB** **سطرهای بازگشتی: 1**
SELECT `template`
FROM `ercem_template_styles`
WHERE `client_id` = 0
AND `home` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_template_styles | ALL | idx_client_id,idx_client_id_home | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 13 | Using where |
| Status | Duration |
|---|
| Starting | 0.49 ms |
| checking permissions | 0.08 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.04 ms |
| System lock | 0.04 ms |
| table lock | 0.04 ms |
| init | 0.13 ms |
| Optimizing | 0.12 ms |
| Statistics | 0.18 ms |
| Preparing | 0.10 ms |
| Executing | 0.04 ms |
| Sending data | 0.13 ms |
| End of update loop | 0.06 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.04 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.04 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.40 ms |
| Updating status | 0.11 ms |
| Reset for next command | 0.08 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 15 | JDatabaseDriver->loadObject() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:337 |
| 14 | AddonParser::getTemplateName() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:40 |
| 13 | AddonParser::getAddonPath() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:213 |
| 12 | AddonParser::viewAddons() | JROOT/modules/mod_sppagebuilder/tmpl/default.php:18 |
| 11 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:12 |
| 10 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 2.49 ms** **پس از آخرین پرس و جو: 3.07 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 22.068 MB** **سطرهای بازگشتی: 1**
SELECT `template`
FROM `ercem_template_styles`
WHERE `client_id` = 0
AND `home` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_template_styles | ALL | idx_client_id,idx_client_id_home | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 13 | Using where |
| Status | Duration |
|---|
| Starting | 0.52 ms |
| checking permissions | 0.09 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.04 ms |
| System lock | 0.04 ms |
| table lock | 0.04 ms |
| init | 0.07 ms |
| Optimizing | 0.09 ms |
| Statistics | 0.17 ms |
| Preparing | 0.14 ms |
| Executing | 0.05 ms |
| Sending data | 0.12 ms |
| End of update loop | 0.08 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.34 ms |
| Updating status | 0.15 ms |
| Reset for next command | 0.07 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 15 | JDatabaseDriver->loadObject() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:337 |
| 14 | AddonParser::getTemplateName() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:40 |
| 13 | AddonParser::getAddonPath() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:213 |
| 12 | AddonParser::viewAddons() | JROOT/modules/mod_sppagebuilder/tmpl/default.php:18 |
| 11 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:12 |
| 10 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 2.35 ms** **پس از آخرین پرس و جو: 2.67 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 22.079 MB** **سطرهای بازگشتی: 1**
SELECT `template`
FROM `ercem_template_styles`
WHERE `client_id` = 0
AND `home` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_template_styles | ALL | idx_client_id,idx_client_id_home | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 13 | Using where |
| Status | Duration |
|---|
| Starting | 0.43 ms |
| checking permissions | 0.08 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.05 ms |
| System lock | 0.04 ms |
| table lock | 0.04 ms |
| init | 0.06 ms |
| Optimizing | 0.09 ms |
| Statistics | 0.14 ms |
| Preparing | 0.15 ms |
| Executing | 0.06 ms |
| Sending data | 0.11 ms |
| End of update loop | 0.06 ms |
| Query end | 0.03 ms |
| Commit | 0.04 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.04 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.31 ms |
| Updating status | 0.16 ms |
| Reset for next command | 0.08 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 15 | JDatabaseDriver->loadObject() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:337 |
| 14 | AddonParser::getTemplateName() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:40 |
| 13 | AddonParser::getAddonPath() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:213 |
| 12 | AddonParser::viewAddons() | JROOT/modules/mod_sppagebuilder/tmpl/default.php:18 |
| 11 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:12 |
| 10 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 1.62 ms** **پس از آخرین پرس و جو: 1.97 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 22.089 MB** **سطرهای بازگشتی: 1**
SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM ercem_modules AS m
WHERE m.published = 1
AND m.id = 219
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-01-01 09:57:05')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-01-01 09:57:05')
AND m.access IN (1,1)
AND m.client_id = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | const | PRIMARY,published | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.32 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.07 ms |
| Optimizing | 0.08 ms |
| Statistics | 0.10 ms |
| Preparing | 0.03 ms |
| Unlocking tables | 0.05 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| Commit | 0.04 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.04 ms |
| closing tables | 0.04 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.19 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.04 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_sppagebuilder/addons/module/site.php:99 |
| 14 | SppagebuilderAddonModule::getModules() | JROOT/components/com_sppagebuilder/addons/module/site.php:28 |
| 13 | SppagebuilderAddonModule->render() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:220 |
| 12 | AddonParser::viewAddons() | JROOT/modules/mod_sppagebuilder/tmpl/default.php:18 |
| 11 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:12 |
| 10 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 1.42 ms** **پس از آخرین پرس و جو: 3.57 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 22.106 MB** **سطرهای بازگشتی: 1**
SELECT `template`
FROM `ercem_template_styles`
WHERE `client_id` = 0
AND `home` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_template_styles | ALL | idx_client_id,idx_client_id_home | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 13 | Using where |
| Status | Duration |
|---|
| Starting | 0.25 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.13 ms |
| Preparing | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 0.11 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.18 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.04 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 15 | JDatabaseDriver->loadObject() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:337 |
| 14 | AddonParser::getTemplateName() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:40 |
| 13 | AddonParser::getAddonPath() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:213 |
| 12 | AddonParser::viewAddons() | JROOT/modules/mod_sppagebuilder/tmpl/default.php:18 |
| 11 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:12 |
| 10 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 38.70 ms** **پس از آخرین پرس و جو: 2.83 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 22.114 MB** **سطرهای بازگشتی: 1**
SELECT `template`
FROM `ercem_template_styles`
WHERE `client_id` = 0
AND `home` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_template_styles | ALL | idx_client_id,idx_client_id_home | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 13 | Using where |
| Status | Duration |
|---|
| Starting | 0.27 ms |
| checking permissions | 0.07 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.07 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.09 ms |
| Preparing | 0.05 ms |
| Executing | 0.02 ms |
| Sending data | 0.07 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.18 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.04 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 15 | JDatabaseDriver->loadObject() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:337 |
| 14 | AddonParser::getTemplateName() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:40 |
| 13 | AddonParser::getAddonPath() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:213 |
| 12 | AddonParser::viewAddons() | JROOT/modules/mod_sppagebuilder/tmpl/default.php:18 |
| 11 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:12 |
| 10 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 2.30 ms** **پس از آخرین پرس و جو: 3.70 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 22.121 MB** **سطرهای بازگشتی: 1**
SELECT `template`
FROM `ercem_template_styles`
WHERE `client_id` = 0
AND `home` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_template_styles | ALL | idx_client_id,idx_client_id_home | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 13 | Using where |
| Status | Duration |
|---|
| Starting | 0.55 ms |
| checking permissions | 0.06 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.05 ms |
| System lock | 0.04 ms |
| table lock | 0.03 ms |
| init | 0.11 ms |
| Optimizing | 0.10 ms |
| Statistics | 0.18 ms |
| Preparing | 0.10 ms |
| Executing | 0.04 ms |
| Sending data | 0.11 ms |
| End of update loop | 0.06 ms |
| Query end | 0.03 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.26 ms |
| Updating status | 0.09 ms |
| Reset for next command | 0.06 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 15 | JDatabaseDriver->loadObject() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:337 |
| 14 | AddonParser::getTemplateName() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:40 |
| 13 | AddonParser::getAddonPath() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:213 |
| 12 | AddonParser::viewAddons() | JROOT/modules/mod_sppagebuilder/tmpl/default.php:18 |
| 11 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:12 |
| 10 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 1.76 ms** **پس از آخرین پرس و جو: 4.26 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 22.129 MB** **سطرهای بازگشتی: 1**
SELECT `template`
FROM `ercem_template_styles`
WHERE `client_id` = 0
AND `home` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_template_styles | ALL | idx_client_id,idx_client_id_home | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 13 | Using where |
| Status | Duration |
|---|
| Starting | 0.31 ms |
| checking permissions | 0.08 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.04 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.05 ms |
| Optimizing | 0.08 ms |
| Statistics | 0.12 ms |
| Preparing | 0.07 ms |
| Executing | 0.04 ms |
| Sending data | 0.10 ms |
| End of update loop | 0.05 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.24 ms |
| Updating status | 0.09 ms |
| Reset for next command | 0.05 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 15 | JDatabaseDriver->loadObject() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:337 |
| 14 | AddonParser::getTemplateName() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:40 |
| 13 | AddonParser::getAddonPath() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:213 |
| 12 | AddonParser::viewAddons() | JROOT/modules/mod_sppagebuilder/tmpl/default.php:18 |
| 11 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:12 |
| 10 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 1.69 ms** **پس از آخرین پرس و جو: 3.31 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 22.141 MB** **سطرهای بازگشتی: 1**
SELECT `template`
FROM `ercem_template_styles`
WHERE `client_id` = 0
AND `home` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_template_styles | ALL | idx_client_id,idx_client_id_home | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 13 | Using where |
| Status | Duration |
|---|
| Starting | 0.32 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.05 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.10 ms |
| Preparing | 0.07 ms |
| Executing | 0.04 ms |
| Sending data | 0.09 ms |
| End of update loop | 0.04 ms |
| Query end | 0.03 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.24 ms |
| Updating status | 0.08 ms |
| Reset for next command | 0.04 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 15 | JDatabaseDriver->loadObject() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:337 |
| 14 | AddonParser::getTemplateName() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:40 |
| 13 | AddonParser::getAddonPath() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:213 |
| 12 | AddonParser::viewAddons() | JROOT/modules/mod_sppagebuilder/tmpl/default.php:18 |
| 11 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:12 |
| 10 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 2.00 ms** **پس از آخرین پرس و جو: 14.09 ms** **حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 21.974 MB** **سطرهای بازگشتی: 0**
SELECT *
FROM ercem_jmap_metainfo
WHERE `linkurl` = 'http://applyaustria.com/forum/user/802-ronald-haveman'
AND `published` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_jmap_metainfo | ref | published | published | 1 | const | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.42 ms |
| checking permissions | 0.26 ms |
| Opening tables | 0.13 ms |
| After opening tables | 0.09 ms |
| System lock | 0.03 ms |
| table lock | 0.02 ms |
| init | 0.07 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.10 ms |
| Preparing | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 0.05 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.05 ms |
| Freeing items | 0.21 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.04 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 13 | JDatabaseDriver->loadObject() | JROOT/plugins/system/jmap/jmap.php:429 |
| 12 | plgSystemJMap->onBeforeCompileHead() | JROOT/libraries/joomla/event/event.php:70 |
| 11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 10 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 9 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 |
| 8 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 |
| 7 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 1.42 ms** **پس از آخرین پرس و جو: 0.12 ms** **حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 21.981 MB** **سطرهای بازگشتی: 0**
SELECT *
FROM ercem_jmap_canonicals
WHERE `linkurl` = 'http://applyaustria.com/forum/user/802-ronald-haveman'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_jmap_canonicals | ALL | NULL | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.40 ms |
| checking permissions | 0.11 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.04 ms |
| System lock | 0.04 ms |
| table lock | 0.03 ms |
| init | 0.05 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.04 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.05 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.17 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.06 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 13 | JDatabaseDriver->loadObject() | JROOT/plugins/system/jmap/jmap.php:508 |
| 12 | plgSystemJMap->onBeforeCompileHead() | JROOT/libraries/joomla/event/event.php:70 |
| 11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 10 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 9 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 |
| 8 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 |
| 7 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 1.55 ms** **پس از آخرین پرس و جو: 68.34 ms** **حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 22.729 MB** **سطرهای بازگشتی: 82**
SELECT *
FROM ercem_acymailing_config
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_acymailing_config | ALL | NULL | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 82 | |
| Status | Duration |
|---|
| Starting | 0.33 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.07 ms |
| Preparing | 0.05 ms |
| Executing | 0.02 ms |
| Sending data | 0.18 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.17 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.04 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_acymailing/classes/cpanel.php:17 |
| 10 | cpanelClass->load() | JROOT/administrator/components/com_acymailing/helpers/helper.php:468 |
| 9 | acymailing_config() | JROOT/administrator/components/com_acymailing/helpers/helper.php:1236 |
| 8 | include_once JROOT/administrator/components/com_acymailing/helpers/helper.php | JROOT/plugins/system/regacymailing/regacymailing.php:139 |
| 7 | plgSystemRegacymailing->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 1.93 ms** **پس از آخرین پرس و جو: 17.39 ms** **حافظه پرس و جو: 0.004 MB حافظه قبل از پرس و جوی: 22.982 MB** **سطرهای بازگشتی: 0**
SELECT *
FROM ercem_jmap_headings
WHERE `linkurl` = 'http://applyaustria.com/forum/user/802-ronald-haveman'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ercem_jmap_headings | ALL | NULL | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.39 ms |
| checking permissions | 0.06 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.05 ms |
| System lock | 0.03 ms |
| table lock | 0.07 ms |
| init | 0.09 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.06 ms |
| Preparing | 0.05 ms |
| Executing | 0.03 ms |
| Sending data | 0.08 ms |
| End of update loop | 0.06 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.25 ms |
| Updating status | 0.11 ms |
| Reset for next command | 0.06 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 8 | JDatabaseDriver->loadObject() | JROOT/plugins/system/jmap/jmap.php:819 |
| 7 | plgSystemJMap->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**12 × SELECT `template`
FROM `ercem_template_styles`**
**4 × SELECT DISTINCT(user_id)
FROM ercem_usergroups as ug1
INNER JOIN ercem_usergroups AS ug2
ON ug2.lft>=ug1.lft
AND ug1.rgt>=ug2.rgt
INNER JOIN ercem_user_usergroup_map AS m
ON ug2.id=m.group_id**
**2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ercem_extensions`**
**2 × SELECT user_id, category_id, role
FROM ercem_kunena_user_categories**
**2 × SELECT *
FROM `ercem_realtimeanalytics_eventstats`**
**1 × SELECT `data`
FROM `ercem_session`**
**1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ercem_modules AS m
LEFT JOIN ercem_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ercem_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id**
**1 × SELECT *
FROM ercem_kunena_categories**
**1 × SELECT COUNT(*)
FROM ercem_kunena_messages AS a**
**1 × SELECT a.id
FROM ercem_kunena_messages AS a**
**1 × SELECT `id`
FROM `ercem_rstbox`**
**1 × SELECT *
FROM ercem_kunena_announcement**
**1 × SELECT *
FROM ercem_kunena_rank**
**1 × SELECT *
FROM `ercem_rstbox`**
**1 × SELECT enabled
FROM ercem_extensions**
**1 × SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM ercem_modules AS m**
**1 × SELECT *
FROM ercem_jmap_metainfo**
**1 × SELECT *
FROM ercem_jmap_canonicals**
**1 × SELECT *
FROM ercem_acymailing_confi**
**1 × SELECT userid, MAX(time) AS time
FROM ercem_session**
**1 × SELECT `g`.`id`,`g`.`title`
FROM `ercem_usergroups` AS g
INNER JOIN `ercem_user_usergroup_map` AS m
ON m.group_id = g.id**
**1 × SELECT *
FROM ercem_kunena_users_banned**
**1 × SELECT *
FROM ercem_kunena_configuration**
**1 × SELECT id, rules
FROM `ercem_viewlevels**
**1 × SELECT b.id
FROM ercem_usergroups AS a
LEFT JOIN ercem_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt**
**1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM ercem_extensions**
**1 × SELECT *
FROM ercem_rsticketspro_configuratio**
**1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM ercem_menu AS m
LEFT JOIN ercem_extensions AS e
ON m.component_id = e.extension_id**
**1 × SELECT id, home, template, s.params
FROM ercem_template_styles as s
LEFT JOIN ercem_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id**
**1 × SELECT *
FROM ercem_kunena_aliases**
**1 × SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
FROM ercem_users AS u
LEFT JOIN ercem_kunena_users AS ku
ON u.id = ku.userid**
**1 × SELECT *
FROM ercem_languages**
**1 × SELECT *
FROM ercem_session**
**1 × SELECT *
FROM ercem_rokcandy**
**1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `ercem_assets`**
**1 × SELECT *
FROM `ercem_users`**
**1 × SELECT `session_id`
FROM `ercem_session`**
**1 × SELECT *
FROM ercem_jmap_headings**