**زمان پرس و جو: 0.36 ms** **حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 2.674 MB** **سطرهای بازگشتی: 0**
SELECT `data`
FROM `jm3_session`
WHERE `session_id` = 'bf0fdc770e5a7b01a7f31af1fed15a5b'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_session | const | PRIMARY | PRIMARY | 766 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 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:82 |
| 10 | JSessionHandlerJoomla->start() | JROOT/libraries/joomla/session/session.php:648 |
| 9 | JSession->_start() | JROOT/libraries/joomla/session/session.php:608 |
| 8 | JSession->start() | JROOT/libraries/joomla/session/session.php:486 |
| 7 | JSession->get() | JROOT/libraries/joomla/session/session.php:443 |
| 6 | JSession->isNew() | JROOT/libraries/cms/application/cms.php:825 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:412 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
**زمان پرس و جو: 0.27 ms** **پس از آخرین پرس و جو: 0.99 ms** **حافظه پرس و جو: 0.004 MB حافظه قبل از پرس و جوی: 2.755 MB** **سطرهای بازگشتی: 0**
SELECT `session_id`
FROM `jm3_session`
WHERE `session_id` = 'bf0fdc770e5a7b01a7f31af1fed15a5b'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_session | const | PRIMARY | PRIMARY | 766 | const | 1 | 100.00 | Using index |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 7 | JDatabaseDriver->loadResult() | JROOT/libraries/cms/application/cms.php:176 |
| 6 | JApplicationCms->checkSession() | JROOT/libraries/cms/application/cms.php:827 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:412 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
**زمان پرس و جو: 0.23 ms** **پس از آخرین پرس و جو: 0.04 ms** **حافظه پرس و جو: 0.003 MB حافظه قبل از پرس و جوی: 2.759 MB**
INSERT INTO `jm3_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('bf0fdc770e5a7b01a7f31af1fed15a5b', 1, '1745942776', 0, '', 0)
**توضیحات در جستجو ممکن نیست: INSERT INTO `jm3_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('bf0fdc770e5a7b01a7f31af1fed15a5b', 1, '1745942776', 0, '', 0)**
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init for update | 0.01 ms |
| Update | 0.06 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/cms/application/cms.php:216 |
| 6 | JApplicationCms->checkSession() | JROOT/libraries/cms/application/cms.php:827 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:412 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
**زمان پرس و جو: 0.50 ms** **پس از آخرین پرس و جو: 2.09 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 2.993 MB** **سطرهای بازگشتی: 47**
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jm3_extensions`
WHERE `type` = 'component'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_extensions | ref | extension | extension | 82 | const | 38 | 100.00 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.06 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.19 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/component/helper.php:452 |
| 8 | JComponentHelper::{closure}() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 7 | JCacheControllerCallback->get() | JROOT/libraries/cms/component/helper.php:460 |
| 6 | JComponentHelper::load() | JROOT/libraries/cms/component/helper.php:43 |
| 5 | JComponentHelper::getComponent() | JROOT/libraries/cms/component/helper.php:111 |
| 4 | JComponentHelper::getParams() | JROOT/libraries/cms/application/site.php:593 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.36 ms** **پس از آخرین پرس و جو: 2.47 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 3.181 MB** **سطرهای بازگشتی: 2**
SELECT b.id
FROM jm3_usergroups AS a
LEFT JOIN jm3_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
| 1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.05 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:978 |
| 9 | JAccess::getGroupsByUser() | JROOT/libraries/joomla/access/access.php:1047 |
| 8 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:453 |
| 7 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:293 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:603 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.25 ms** **پس از آخرین پرس و جو: 0.52 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 3.226 MB** **سطرهای بازگشتی: 5**
SELECT id, rules
FROM `jm3_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_viewlevels | ALL | NULL | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 5 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1486 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/joomla/access/access.php:1064 |
| 8 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:453 |
| 7 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:293 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:603 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.61 ms** **پس از آخرین پرس و جو: 0.07 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 3.253 MB** **سطرهای بازگشتی: 104**
SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM jm3_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_extensions | ALL | extension | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 278 | 58.99 | Using where; **با استفاده از مرتب سازی فایل** |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.06 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.35 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/plugin/helper.php:311 |
| 8 | JPluginHelper::{closure}() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 7 | JCacheControllerCallback->get() | JROOT/libraries/cms/plugin/helper.php:316 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:603 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 1.17 ms** **پس از آخرین پرس و جو: 28.57 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 5.734 MB** **سطرهای بازگشتی: 227**
SHOW TABLES
**توضیحات در جستجو ممکن نیست: SHOW TABLES**
| Status | Duration |
|---|
| Starting | 0.08 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| Filling schema table | 0.01 ms |
| checking permissions | 0.68 ms |
| Executing | 0.01 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.00 ms |
| Removing tmp table | 0.01 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/database/driver/mysqli.php:497 |
| 9 | JDatabaseDriverMysqli->getTableList() | JROOT/plugins/system/jdownloads/jdownloads.php:78 |
| 8 | plgSystemjdownloads->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:683 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.49 ms** **پس از آخرین پرس و جو: 0.27 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 5.765 MB** **سطرهای بازگشتی: 0**
SELECT file_id
from jm3_jdownloads_files
WHERE published = 1
AND use_timeframe = 1
AND publish_to != '0000-00-00 00:00:00'
AND publish_to <= '2025-04-29 20:36:16'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_jdownloads_files | ref | idx_published | idx_published | 1 | const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.14 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.04 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.03 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 9 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/jdownloads/jdownloads.php:106 |
| 8 | plgSystemjdownloads->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:683 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.22 ms** **پس از آخرین پرس و جو: 0.03 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 5.770 MB** **سطرهای بازگشتی: 0**
SELECT file_id
from jm3_jdownloads_files
WHERE published = 0
AND use_timeframe = 1
AND publish_from != '0000-00-00 00:00:00'
AND publish_from <= '2025-04-29 20:36:16'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_jdownloads_files | ref | idx_published | idx_published | 1 | const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 9 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/jdownloads/jdownloads.php:114 |
| 8 | plgSystemjdownloads->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:683 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 1.90 ms** **پس از آخرین پرس و جو: 3.51 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 6.064 MB** **سطرهای بازگشتی: 234**
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 jm3_menu AS m
LEFT JOIN jm3_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 | filtered | Extra |
|---|
| 1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 245 | 70.61 | Using index condition; Using where; **با استفاده از مرتب سازی فایل** |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | tajhizaf_maindb.m.component_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.05 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 1.55 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/menu/site.php:88 |
| 16 | JMenuSite->{closure}() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 15 | JCacheControllerCallback->get() | JROOT/libraries/cms/menu/site.php:96 |
| 14 | JMenuSite->load() | JROOT/libraries/cms/menu/menu.php:74 |
| 13 | JMenu->__construct() | JROOT/libraries/cms/menu/site.php:57 |
| 12 | JMenuSite->__construct() | JROOT/libraries/cms/menu/menu.php:129 |
| 11 | JMenu::getInstance() | JROOT/libraries/cms/application/cms.php:443 |
| 10 | JApplicationCms->getMenu() | JROOT/libraries/cms/application/site.php:272 |
| 9 | JApplicationSite->getMenu() | JROOT/libraries/cms/router/site.php:59 |
| 8 | JRouterSite->__construct() | JROOT/libraries/cms/router/router.php:198 |
| 7 | JRouter::getInstance() | JROOT/libraries/cms/application/cms.php:548 |
| 6 | JApplicationCms::getRouter() | JROOT/libraries/cms/application/site.php:402 |
| 5 | JApplicationSite::getRouter() | JROOT/libraries/cms/application/cms.php:1141 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.57 ms** **پس از آخرین پرس و جو: 25.71 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 8.500 MB** **سطرهای بازگشتی: 1**
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jm3_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.16 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 17 | JDatabaseDriver->loadObject() | JROOT/libraries/cms/library/helper.php:166 |
| 16 | JLibraryHelper::{closure}() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 15 | JCacheControllerCallback->get() | JROOT/libraries/cms/library/helper.php:174 |
| 14 | JLibraryHelper::loadLibrary() | JROOT/libraries/cms/library/helper.php:42 |
| 13 | JLibraryHelper::getLibrary() | JROOT/libraries/cms/library/helper.php:89 |
| 12 | JLibraryHelper::getParams() | JROOT/libraries/cms/version/version.php:270 |
| 11 | JVersion->getMediaVersion() | JROOT/libraries/joomla/factory.php:760 |
| 10 | JFactory::createDocument() | JROOT/libraries/joomla/factory.php:216 |
| 9 | JFactory::getDocument() | JROOT/plugins/system/k2/k2.php:40 |
| 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/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1151 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.28 ms** **پس از آخرین پرس و جو: 0.12 ms** **حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 8.492 MB**
UPDATE `jm3_extensions`
SET `params` = '{\"mediaversion\":\"dbc590469f8f8ab51313556560b2d476\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_extensions | range | element_clientid,element_folder_clientid,extension | extension | 484 | NULL | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init for update | 0.09 ms |
| Updating | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/cms/library/helper.php:116 |
| 13 | JLibraryHelper::saveParams() | JROOT/libraries/cms/version/version.php:321 |
| 12 | JVersion->setMediaVersion() | JROOT/libraries/cms/version/version.php:280 |
| 11 | JVersion->getMediaVersion() | JROOT/libraries/joomla/factory.php:760 |
| 10 | JFactory::createDocument() | JROOT/libraries/joomla/factory.php:216 |
| 9 | JFactory::getDocument() | JROOT/plugins/system/k2/k2.php:40 |
| 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/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1151 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.31 ms** **پس از آخرین پرس و جو: 3.10 ms** **حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 8.793 MB** **سطرهای بازگشتی: 2**
SELECT *
FROM jm3_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_languages | ALL | NULL | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 2 | 100.00 | Using where; **با استفاده از مرتب سازی فایل** |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.06 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/language/helper.php:148 |
| 12 | JLanguageHelper::getLanguages() | JROOT/libraries/cms/application/site.php:327 |
| 11 | JApplicationSite->getParams() | JROOT/components/com_k2/helpers/utilities.php:305 |
| 10 | K2HelperUtilities::getParams() | JROOT/administrator/components/com_k2/helpers/html.php:56 |
| 9 | K2HelperHTML::loadjQuery() | JROOT/plugins/system/k2/k2.php:45 |
| 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/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1151 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.67 ms** **پس از آخرین پرس و جو: 2.69 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 8.981 MB** **سطرهای بازگشتی: 7**
SELECT id, home, template, s.params
FROM jm3_template_styles as s
LEFT JOIN jm3_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 | filtered | Extra |
|---|
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 6 | 100.00 | Using index condition; Using where |
| 1 | SIMPLE | s | ref | idx_template | idx_template | 202 | tajhizaf_maindb.e.element | 2 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.09 ms |
| Preparing | 0.03 ms |
| Executing | 0.00 ms |
| Sending data | 0.34 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/application/site.php:485 |
| 17 | JApplicationSite->getTemplate() | JROOT/libraries/cms/html/html.php:359 |
| 16 | JHtml::includeRelativeFiles() | JROOT/libraries/cms/html/html.php:706 |
| 15 | JHtml::script() | JROOT/libraries/cms/html/html.php:233 |
| 14 | JHtml::call() | JROOT/libraries/cms/html/html.php:140 |
| 13 | JHtml::_() | JROOT/libraries/cms/html/jquery.php:52 |
| 12 | JHtmlJquery::framework() | JROOT/libraries/cms/html/html.php:233 |
| 11 | JHtml::call() | JROOT/libraries/cms/html/html.php:140 |
| 10 | JHtml::_() | JROOT/administrator/components/com_k2/helpers/html.php:79 |
| 9 | K2HelperHTML::loadjQuery() | JROOT/plugins/system/k2/k2.php:45 |
| 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/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1151 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.73 ms** **پس از آخرین پرس و جو: 5.60 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 9.031 MB** **سطرهای بازگشتی: 227**
**پرس و جوی تکراری**:
#8 #78SHOW TABLES
**توضیحات در جستجو ممکن نیست: SHOW TABLES**
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.00 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Filling schema table | 0.00 ms |
| checking permissions | 0.42 ms |
| Executing | 0.01 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Removing tmp table | 0.01 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/database/driver/mysqli.php:497 |
| 9 | JDatabaseDriverMysqli->getTableList() | JROOT/plugins/system/jdownloads/jdownloads.php:353 |
| 8 | plgSystemjdownloads->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1151 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.64 ms** **پس از آخرین پرس و جو: 2.26 ms** **حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 9.090 MB** **سطرهای بازگشتی: 47**
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jm3_assets`
WHERE `name` IN ('com_acymailing','com_admin','com_advancedmodules','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_creativecontactform','com_easyfrontendseo','com_fields','com_finder','com_installer','com_jdownloads','com_joomlaupdate','com_k2','com_k2additionalcategories','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_rsfiles','com_rsform','com_search','com_sigpro','com_sppagebuilder','com_spsimpleportfolio','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_wrapper') OR `parent_id` = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_assets | index_merge | idx_asset_name,idx_parent_id | idx_asset_name,idx_parent_id | 202,4 | NULL | 48 | 100.00 | Using sort_union(idx_asset_name,idx_parent_id); Using where |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.04 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.08 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.24 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/access/access.php:427 |
| 11 | JAccess::preloadComponents() | JROOT/libraries/joomla/access/access.php:211 |
| 10 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:529 |
| 9 | JAccess::getAssetRules() | JROOT/libraries/joomla/access/access.php:181 |
| 8 | JAccess::check() | JROOT/libraries/joomla/user/user.php:393 |
| 7 | JUser->authorise() | JROOT/components/com_k2/k2.php:16 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.50 ms** **پس از آخرین پرس و جو: 13.01 ms** **حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 10.071 MB** **سطرهای بازگشتی: 219**
SELECT id
FROM jm3_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_categories | range | category,published,access,trash | category | 8 | NULL | 209 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.06 ms |
| Preparing | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.10 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 13 | JDatabaseDriver->loadColumn() | JROOT/components/com_k2/helpers/permissions.php:274 |
| 12 | K2HelperPermissions::canAddItem() | JROOT/components/com_k2/views/itemlist/view.html.php:29 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.38 ms** **پس از آخرین پرس و جو: 0.65 ms** **حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 10.106 MB** **سطرهای بازگشتی: 32**
SELECT id
FROM jm3_k2_categories
WHERE parent IN (1,13,17)
AND id NOT IN (1,13,17)
AND published=1
AND trash=0
AND access IN(1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_categories | range | PRIMARY,category,parent,published,access,trash | parent | 5 | NULL | 41 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.06 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.14 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 14 | JDatabaseDriver->loadColumn() | JROOT/components/com_k2/models/itemlist.php:648 |
| 13 | K2ModelItemlist->getCategoryTree() | JROOT/components/com_k2/models/itemlist.php:263 |
| 12 | K2ModelItemlist->getData() | JROOT/components/com_k2/views/itemlist/view.html.php:387 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.74 ms** **پس از آخرین پرس و جو: 0.04 ms** **حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 10.118 MB** **سطرهای بازگشتی: 42**
SELECT id
FROM jm3_k2_categories
WHERE parent IN (14,15,16,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,10,209,210,5,103,189,262)
AND id NOT IN (14,15,16,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,10,209,210,5,103,189,262)
AND published=1
AND trash=0
AND access IN(1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_categories | ref | PRIMARY,category,parent,published,access,trash | category | 2 | const | 209 | 26.32 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.09 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.42 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 14 | JDatabaseDriver->loadColumn() | JROOT/components/com_k2/models/itemlist.php:648 |
| 13 | K2ModelItemlist->getCategoryTree() | JROOT/components/com_k2/models/itemlist.php:263 |
| 12 | K2ModelItemlist->getData() | JROOT/components/com_k2/views/itemlist/view.html.php:387 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.54 ms** **پس از آخرین پرس و جو: 0.05 ms** **حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 10.133 MB** **سطرهای بازگشتی: 48**
SELECT id
FROM jm3_k2_categories
WHERE parent IN (11,55,104,155,156,157,158,185,186,187,188,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,211,212,213,218,227,233,254,258,259,260,261,264)
AND id NOT IN (11,55,104,155,156,157,158,185,186,187,188,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,211,212,213,218,227,233,254,258,259,260,261,264)
AND published=1
AND trash=0
AND access IN(1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_categories | ref | PRIMARY,category,parent,published,access,trash | category | 2 | const | 209 | 50.24 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.10 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.23 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 14 | JDatabaseDriver->loadColumn() | JROOT/components/com_k2/models/itemlist.php:648 |
| 13 | K2ModelItemlist->getCategoryTree() | JROOT/components/com_k2/models/itemlist.php:263 |
| 12 | K2ModelItemlist->getData() | JROOT/components/com_k2/views/itemlist/view.html.php:387 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.57 ms** **پس از آخرین پرس و جو: 0.05 ms** **حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 10.142 MB** **سطرهای بازگشتی: 36**
SELECT id
FROM jm3_k2_categories
WHERE parent IN (12,56,105,115,118,122,132,139,146,147,148,149,150,151,152,153,154,214,215,216,217,219,221,222,223,224,225,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,251,255,256,257,263)
AND id NOT IN (12,56,105,115,118,122,132,139,146,147,148,149,150,151,152,153,154,214,215,216,217,219,221,222,223,224,225,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,251,255,256,257,263)
AND published=1
AND trash=0
AND access IN(1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_categories | ref | PRIMARY,category,parent,published,access,trash | category | 2 | const | 209 | 37.32 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.11 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.23 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 14 | JDatabaseDriver->loadColumn() | JROOT/components/com_k2/models/itemlist.php:648 |
| 13 | K2ModelItemlist->getCategoryTree() | JROOT/components/com_k2/models/itemlist.php:263 |
| 12 | K2ModelItemlist->getData() | JROOT/components/com_k2/views/itemlist/view.html.php:387 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.30 ms** **پس از آخرین پرس و جو: 0.04 ms** **حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 10.154 MB** **سطرهای بازگشتی: 0**
SELECT id
FROM jm3_k2_categories
WHERE parent IN (57,106,107,108,109,110,111,112,113,114,116,117,119,120,121,123,124,125,126,127,128,129,130,131,133,134,135,136,137,138,140,141,142,143,144,145)
AND id NOT IN (57,106,107,108,109,110,111,112,113,114,116,117,119,120,121,123,124,125,126,127,128,129,130,131,133,134,135,136,137,138,140,141,142,143,144,145)
AND published=1
AND trash=0
AND access IN(1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_categories | range | PRIMARY,category,parent,published,access,trash | parent | 5 | NULL | 36 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.08 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 14 | JDatabaseDriver->loadColumn() | JROOT/components/com_k2/models/itemlist.php:648 |
| 13 | K2ModelItemlist->getCategoryTree() | JROOT/components/com_k2/models/itemlist.php:263 |
| 12 | K2ModelItemlist->getData() | JROOT/components/com_k2/views/itemlist/view.html.php:387 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 318.43 ms** **پس از آخرین پرس و جو: 2.18 ms** **حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 10.242 MB** **سطرهای بازگشتی: 10**
SELECT DISTINCT i.`id`,i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams
FROM jm3_k2_items as i RIGHT JOIN jm3_k2_categories AS c
ON c.id = i.catid
LEFT JOIN jm3_k2_additional_categories AS ca
ON ca.`itemID` = i.`id`
WHERE i.published = 1
AND i.access IN(1,1,5)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1,5)
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-04-29 16:06:16' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-04-29 16:06:16' )
AND (c.id IN (1,13,17,14,15,16,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,10,209,210,5,103,189,262,11,55,104,155,156,157,158,185,186,187,188,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,211,212,213,218,227,233,254,258,259,260,261,264,12,56,105,115,118,122,132,139,146,147,148,149,150,151,152,153,154,214,215,216,217,219,221,222,223,224,225,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,251,255,256,257,263,57,106,107,108,109,110,111,112,113,114,116,117,119,120,121,123,124,125,126,127,128,129,130,131,133,134,135,136,137,138,140,141,142,143,144,145) OR ca.`catid` IN (1,13,17,14,15,16,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,10,209,210,5,103,189,262,11,55,104,155,156,157,158,185,186,187,188,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,211,212,213,218,227,233,254,258,259,260,261,264,12,56,105,115,118,122,132,139,146,147,148,149,150,151,152,153,154,214,215,216,217,219,221,222,223,224,225,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,251,255,256,257,263,57,106,107,108,109,110,111,112,113,114,116,117,119,120,121,123,124,125,126,127,128,129,130,131,133,134,135,136,137,138,140,141,142,143,144,145))
ORDER BY i.id DESC
LIMIT 30, 10
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i | ref | item,catid | item | 2 | const | 420 | 100.00 | Using index condition; Using temporary; **با استفاده از مرتب سازی فایل** |
| 1 | SIMPLE | c | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | tajhizaf_maindb.i.catid | 1 | 100.00 | Using where |
| 1 | SIMPLE | ca | ALL | NULL | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 1241 | 100.00 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.14 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.11 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.30 ms |
| Preparing | 0.05 ms |
| Creating tmp table | 0.04 ms |
| Sorting result | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 315.63 ms |
| Creating sort index | 1.34 ms |
| Removing tmp table | 0.51 ms |
| Creating sort index | 0.02 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/itemlist.php:360 |
| 12 | K2ModelItemlist->getData() | JROOT/components/com_k2/views/itemlist/view.html.php:387 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 107.23 ms** **پس از آخرین پرس و جو: 0.44 ms** **حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 10.352 MB** **سطرهای بازگشتی: 1**
SELECT COUNT(DISTINCT i.`id`)
FROM jm3_k2_items as i RIGHT JOIN jm3_k2_categories c
ON c.id = i.catid
LEFT JOIN jm3_k2_additional_categories AS ca
ON ca.`itemID` = i.`id`
WHERE i.published = 1
AND i.access IN(1,1,5)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1,5)
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-04-29 16:06:16' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-04-29 16:06:16' )
AND (c.id IN (1,13,17,14,15,16,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,10,209,210,5,103,189,262,11,55,104,155,156,157,158,185,186,187,188,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,211,212,213,218,227,233,254,258,259,260,261,264,12,56,105,115,118,122,132,139,146,147,148,149,150,151,152,153,154,214,215,216,217,219,221,222,223,224,225,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,251,255,256,257,263,57,106,107,108,109,110,111,112,113,114,116,117,119,120,121,123,124,125,126,127,128,129,130,131,133,134,135,136,137,138,140,141,142,143,144,145) OR ca.`catid` IN (1,13,17,14,15,16,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,10,209,210,5,103,189,262,11,55,104,155,156,157,158,185,186,187,188,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,211,212,213,218,227,233,254,258,259,260,261,264,12,56,105,115,118,122,132,139,146,147,148,149,150,151,152,153,154,214,215,216,217,219,221,222,223,224,225,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,251,255,256,257,263,57,106,107,108,109,110,111,112,113,114,116,117,119,120,121,123,124,125,126,127,128,129,130,131,133,134,135,136,137,138,140,141,142,143,144,145))
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i | ref | item,catid | item | 2 | const | 420 | 100.00 | Using index condition |
| 1 | SIMPLE | c | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | tajhizaf_maindb.i.catid | 1 | 100.00 | Using where |
| 1 | SIMPLE | ca | ALL | NULL | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 1241 | 100.00 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.15 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.08 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.31 ms |
| Preparing | 0.07 ms |
| Executing | 0.01 ms |
| Sending data | 106.18 ms |
| End of update loop | 0.16 ms |
| Removing tmp table | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 13 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/itemlist.php:598 |
| 12 | K2ModelItemlist->getTotal() | JROOT/components/com_k2/views/itemlist/view.html.php:415 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.72 ms** **پس از آخرین پرس و جو: 1.76 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 10.533 MB** **سطرهای بازگشتی: 14**
SHOW FULL COLUMNS
FROM `jm3_k2_categories`
**توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `jm3_k2_categories`**
| Status | Duration |
|---|
| Starting | 0.08 ms |
| checking permissions | 0.01 ms |
| closing tables | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.21 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Filling schema table | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| checking permissions | 0.08 ms |
| closing tables | 0.01 ms |
| checking permissions | 0.00 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Removing tmp table | 0.08 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 16 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:244 |
| 15 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:163 |
| 14 | JTable->__construct() | JROOT/administrator/components/com_k2/tables/k2category.php:36 |
| 13 | TableK2Category->__construct() | JROOT/libraries/joomla/table/table.php:311 |
| 12 | JTable::getInstance() | JROOT/components/com_k2/views/itemlist/view.html.php:460 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.28 ms** **پس از آخرین پرس و جو: 0.80 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 10.590 MB** **سطرهای بازگشتی: 1**
SELECT *
FROM jm3_k2_categories
WHERE id = '46'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.05 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1445 |
| 16 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_k2/tables/k2category.php:67 |
| 15 | TableK2Category->load() | JROOT/components/com_k2/models/item.php:75 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.39 ms** **پس از آخرین پرس و جو: 2.00 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 10.721 MB** **سطرهای بازگشتی: 2**
SELECT tag.*
FROM jm3_k2_tags AS tag
JOIN jm3_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 441
ORDER BY xref.id ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | xref | ref | tagID,itemID | itemID | 4 | const | 2 | 100.00 | Using where |
| 1 | SIMPLE | tag | eq_ref | PRIMARY,published | PRIMARY | 4 | tajhizaf_maindb.xref.tagID | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.06 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.03 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1403 |
| 15 | K2ModelItem->getItemTags() | JROOT/components/com_k2/models/item.php:109 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.60 ms** **پس از آخرین پرس و جو: 1.40 ms** **حافظه پرس و جو: 0.011 MB حافظه قبل از پرس و جوی: 10.795 MB** **سطرهای بازگشتی: 16**
SHOW FULL COLUMNS
FROM `jm3_users`
**توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `jm3_users`**
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| closing tables | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.16 ms |
| After opening tables | 0.01 ms |
| System lock | 0.03 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Filling schema table | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| checking permissions | 0.06 ms |
| closing tables | 0.01 ms |
| checking permissions | 0.00 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Removing tmp table | 0.09 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 25 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 24 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:244 |
| 23 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:163 |
| 22 | JTable->__construct() | JROOT/libraries/joomla/table/user.php:39 |
| 21 | JTableUser->__construct() | JROOT/libraries/joomla/table/table.php:311 |
| 20 | JTable::getInstance() | JROOT/libraries/joomla/user/user.php:598 |
| 19 | JUser::getTable() | JROOT/libraries/joomla/user/user.php:875 |
| 18 | JUser->load() | JROOT/libraries/joomla/user/user.php:243 |
| 17 | JUser->__construct() | JROOT/libraries/joomla/user/user.php:296 |
| 16 | JUser::getInstance() | JROOT/libraries/joomla/factory.php:248 |
| 15 | JFactory::getUser() | JROOT/components/com_k2/models/item.php:248 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.23 ms** **پس از آخرین پرس و جو: 0.08 ms** **حافظه پرس و جو: 0.010 MB حافظه قبل از پرس و جوی: 10.831 MB** **سطرهای بازگشتی: 1**
SELECT *
FROM `jm3_users`
WHERE `id` = 823
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_users | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1445 |
| 20 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/user.php:85 |
| 19 | JTableUser->load() | JROOT/libraries/joomla/user/user.php:878 |
| 18 | JUser->load() | JROOT/libraries/joomla/user/user.php:243 |
| 17 | JUser->__construct() | JROOT/libraries/joomla/user/user.php:296 |
| 16 | JUser::getInstance() | JROOT/libraries/joomla/factory.php:248 |
| 15 | JFactory::getUser() | JROOT/components/com_k2/models/item.php:248 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.31 ms** **پس از آخرین پرس و جو: 2.51 ms** **حافظه پرس و جو: 0.010 MB حافظه قبل از پرس و جوی: 11.585 MB** **سطرهای بازگشتی: 1**
SELECT `g`.`id`,`g`.`title`
FROM `jm3_usergroups` AS g
INNER JOIN `jm3_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 823
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | tajhizaf_maindb.m.group_id | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1486 |
| 20 | JDatabaseDriver->loadAssocList() | JROOT/libraries/joomla/table/user.php:110 |
| 19 | JTableUser->load() | JROOT/libraries/joomla/user/user.php:878 |
| 18 | JUser->load() | JROOT/libraries/joomla/user/user.php:243 |
| 17 | JUser->__construct() | JROOT/libraries/joomla/user/user.php:296 |
| 16 | JUser::getInstance() | JROOT/libraries/joomla/factory.php:248 |
| 15 | JFactory::getUser() | JROOT/components/com_k2/models/item.php:248 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.27 ms** **پس از آخرین پرس و جو: 1.73 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 11.702 MB** **سطرهای بازگشتی: 0**
SELECT id, gender, description, image, url, `
group`, plugins
FROM jm3_k2_users
WHERE userID=823
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_users | ref | userID | userID | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 16 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1874 |
| 15 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:251 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.22 ms** **پس از آخرین پرس و جو: 0.21 ms** **حافظه پرس و جو: 0.010 MB حافظه قبل از پرس و جوی: 11.717 MB** **سطرهای بازگشتی: 0**
SELECT id, gender, description, image, url, `
group`, plugins
FROM jm3_k2_users
WHERE userID=823
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_users | ref | userID | userID | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 17 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1874 |
| 16 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:55 |
| 15 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:252 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 1.12 ms** **پس از آخرین پرس و جو: 10.46 ms** **حافظه پرس و جو: 0.010 MB حافظه قبل از پرس و جوی: 12.333 MB** **سطرهای بازگشتی: 0**
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM jm3_fields AS a
LEFT JOIN `jm3_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jm3_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jm3_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jm3_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jm3_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jm3_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.itemlist'
AND (fc.category_id IS NULL OR fc.category_id IN (46,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state
ORDER BY a.ordering DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using where; Using temporary; **با استفاده از مرتب سازی فایل** |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | tajhizaf_maindb.a.language | 1 | 100.00 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | tajhizaf_maindb.a.checked_out | 1 | 100.00 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | tajhizaf_maindb.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | tajhizaf_maindb.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | tajhizaf_maindb.a.group_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | tajhizaf_maindb.a.id | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.19 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.07 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.09 ms |
| Preparing | 0.04 ms |
| Creating tmp table | 0.05 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.27 ms |
| Creating sort index | 0.04 ms |
| Removing tmp table | 0.06 ms |
| Creating sort index | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/model/legacy.php:307 |
| 19 | JModelLegacy->_getList() | JROOT/administrator/components/com_fields/models/fields.php:327 |
| 18 | FieldsModelFields->_getList() | JROOT/libraries/legacy/model/list.php:186 |
| 17 | JModelList->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:134 |
| 16 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 15 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:741 |
| 12 | K2ModelItem->execPlugins() | JROOT/components/com_k2/views/itemlist/view.html.php:473 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.42 ms** **پس از آخرین پرس و جو: 4.01 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 12.702 MB** **سطرهای بازگشتی: 2**
SELECT tag.*
FROM jm3_k2_tags AS tag
JOIN jm3_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 440
ORDER BY xref.id ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | xref | ref | tagID,itemID | itemID | 4 | const | 2 | 100.00 | Using where |
| 1 | SIMPLE | tag | eq_ref | PRIMARY,published | PRIMARY | 4 | tajhizaf_maindb.xref.tagID | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.05 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1403 |
| 15 | K2ModelItem->getItemTags() | JROOT/components/com_k2/models/item.php:109 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.28 ms** **پس از آخرین پرس و جو: 0.60 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 12.714 MB** **سطرهای بازگشتی: 0**
SELECT id, gender, description, image, url, `
group`, plugins
FROM jm3_k2_users
WHERE userID=823
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_users | ref | userID | userID | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 16 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1874 |
| 15 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:251 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.26 ms** **پس از آخرین پرس و جو: 0.16 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 12.722 MB** **سطرهای بازگشتی: 0**
SELECT id, gender, description, image, url, `
group`, plugins
FROM jm3_k2_users
WHERE userID=823
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_users | ref | userID | userID | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.01 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 17 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1874 |
| 16 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:55 |
| 15 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:252 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.33 ms** **پس از آخرین پرس و جو: 1.97 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 12.774 MB** **سطرهای بازگشتی: 1**
SELECT tag.*
FROM jm3_k2_tags AS tag
JOIN jm3_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 439
ORDER BY xref.id ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | xref | ref | tagID,itemID | itemID | 4 | const | 1 | 100.00 | Using where |
| 1 | SIMPLE | tag | eq_ref | PRIMARY,published | PRIMARY | 4 | tajhizaf_maindb.xref.tagID | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1403 |
| 15 | K2ModelItem->getItemTags() | JROOT/components/com_k2/models/item.php:109 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.34 ms** **پس از آخرین پرس و جو: 0.64 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 12.786 MB** **سطرهای بازگشتی: 0**
SELECT id, gender, description, image, url, `
group`, plugins
FROM jm3_k2_users
WHERE userID=823
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_users | ref | userID | userID | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| Query end | 0.00 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 16 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1874 |
| 15 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:251 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.23 ms** **پس از آخرین پرس و جو: 0.19 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 12.794 MB** **سطرهای بازگشتی: 0**
SELECT id, gender, description, image, url, `
group`, plugins
FROM jm3_k2_users
WHERE userID=823
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_users | ref | userID | userID | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 17 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1874 |
| 16 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:55 |
| 15 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:252 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.32 ms** **پس از آخرین پرس و جو: 1.71 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 12.838 MB** **سطرهای بازگشتی: 1**
SELECT tag.*
FROM jm3_k2_tags AS tag
JOIN jm3_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 438
ORDER BY xref.id ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | xref | ref | tagID,itemID | itemID | 4 | const | 1 | 100.00 | Using where |
| 1 | SIMPLE | tag | eq_ref | PRIMARY,published | PRIMARY | 4 | tajhizaf_maindb.xref.tagID | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1403 |
| 15 | K2ModelItem->getItemTags() | JROOT/components/com_k2/models/item.php:109 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.24 ms** **پس از آخرین پرس و جو: 0.55 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 12.848 MB** **سطرهای بازگشتی: 0**
SELECT id, gender, description, image, url, `
group`, plugins
FROM jm3_k2_users
WHERE userID=823
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_users | ref | userID | userID | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 16 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1874 |
| 15 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:251 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.22 ms** **پس از آخرین پرس و جو: 0.16 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 12.856 MB** **سطرهای بازگشتی: 0**
SELECT id, gender, description, image, url, `
group`, plugins
FROM jm3_k2_users
WHERE userID=823
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_users | ref | userID | userID | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.01 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 17 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1874 |
| 16 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:55 |
| 15 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:252 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.30 ms** **پس از آخرین پرس و جو: 1.53 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 12.900 MB** **سطرهای بازگشتی: 1**
SELECT tag.*
FROM jm3_k2_tags AS tag
JOIN jm3_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 437
ORDER BY xref.id ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | xref | ref | tagID,itemID | itemID | 4 | const | 1 | 100.00 | Using where |
| 1 | SIMPLE | tag | eq_ref | PRIMARY,published | PRIMARY | 4 | tajhizaf_maindb.xref.tagID | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1403 |
| 15 | K2ModelItem->getItemTags() | JROOT/components/com_k2/models/item.php:109 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.23 ms** **پس از آخرین پرس و جو: 0.54 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 12.911 MB** **سطرهای بازگشتی: 0**
SELECT id, gender, description, image, url, `
group`, plugins
FROM jm3_k2_users
WHERE userID=823
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_users | ref | userID | userID | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 16 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1874 |
| 15 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:251 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.21 ms** **پس از آخرین پرس و جو: 0.16 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 12.919 MB** **سطرهای بازگشتی: 0**
SELECT id, gender, description, image, url, `
group`, plugins
FROM jm3_k2_users
WHERE userID=823
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_users | ref | userID | userID | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 17 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1874 |
| 16 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:55 |
| 15 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:252 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.31 ms** **پس از آخرین پرس و جو: 1.48 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 12.964 MB** **سطرهای بازگشتی: 1**
SELECT tag.*
FROM jm3_k2_tags AS tag
JOIN jm3_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 436
ORDER BY xref.id ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | xref | ref | tagID,itemID | itemID | 4 | const | 1 | 100.00 | Using where |
| 1 | SIMPLE | tag | eq_ref | PRIMARY,published | PRIMARY | 4 | tajhizaf_maindb.xref.tagID | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1403 |
| 15 | K2ModelItem->getItemTags() | JROOT/components/com_k2/models/item.php:109 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.27 ms** **پس از آخرین پرس و جو: 0.47 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 12.975 MB** **سطرهای بازگشتی: 0**
SELECT id, gender, description, image, url, `
group`, plugins
FROM jm3_k2_users
WHERE userID=823
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_users | ref | userID | userID | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.03 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.02 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 16 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1874 |
| 15 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:251 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.22 ms** **پس از آخرین پرس و جو: 0.16 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 12.983 MB** **سطرهای بازگشتی: 0**
SELECT id, gender, description, image, url, `
group`, plugins
FROM jm3_k2_users
WHERE userID=823
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_users | ref | userID | userID | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.01 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 17 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1874 |
| 16 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:55 |
| 15 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:252 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.31 ms** **پس از آخرین پرس و جو: 1.52 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.026 MB** **سطرهای بازگشتی: 1**
SELECT tag.*
FROM jm3_k2_tags AS tag
JOIN jm3_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 435
ORDER BY xref.id ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | xref | ref | tagID,itemID | itemID | 4 | const | 1 | 100.00 | Using where |
| 1 | SIMPLE | tag | eq_ref | PRIMARY,published | PRIMARY | 4 | tajhizaf_maindb.xref.tagID | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1403 |
| 15 | K2ModelItem->getItemTags() | JROOT/components/com_k2/models/item.php:109 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.27 ms** **پس از آخرین پرس و جو: 0.52 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.037 MB** **سطرهای بازگشتی: 0**
SELECT id, gender, description, image, url, `
group`, plugins
FROM jm3_k2_users
WHERE userID=823
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_users | ref | userID | userID | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.02 ms |
| Commit | 0.01 ms |
| Query end | 0.00 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 16 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1874 |
| 15 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:251 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.23 ms** **پس از آخرین پرس و جو: 0.15 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.045 MB** **سطرهای بازگشتی: 0**
SELECT id, gender, description, image, url, `
group`, plugins
FROM jm3_k2_users
WHERE userID=823
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_users | ref | userID | userID | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 17 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1874 |
| 16 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:55 |
| 15 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:252 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.30 ms** **پس از آخرین پرس و جو: 1.63 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.089 MB** **سطرهای بازگشتی: 1**
SELECT tag.*
FROM jm3_k2_tags AS tag
JOIN jm3_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 434
ORDER BY xref.id ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | xref | ref | tagID,itemID | itemID | 4 | const | 1 | 100.00 | Using where |
| 1 | SIMPLE | tag | eq_ref | PRIMARY,published | PRIMARY | 4 | tajhizaf_maindb.xref.tagID | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1403 |
| 15 | K2ModelItem->getItemTags() | JROOT/components/com_k2/models/item.php:109 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.24 ms** **پس از آخرین پرس و جو: 0.56 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.100 MB** **سطرهای بازگشتی: 0**
SELECT id, gender, description, image, url, `
group`, plugins
FROM jm3_k2_users
WHERE userID=823
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_users | ref | userID | userID | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 16 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1874 |
| 15 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:251 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.27 ms** **پس از آخرین پرس و جو: 0.16 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.108 MB** **سطرهای بازگشتی: 0**
SELECT id, gender, description, image, url, `
group`, plugins
FROM jm3_k2_users
WHERE userID=823
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_users | ref | userID | userID | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 17 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1874 |
| 16 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:55 |
| 15 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:252 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.30 ms** **پس از آخرین پرس و جو: 1.64 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.152 MB** **سطرهای بازگشتی: 1**
SELECT tag.*
FROM jm3_k2_tags AS tag
JOIN jm3_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 433
ORDER BY xref.id ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | xref | ref | tagID,itemID | itemID | 4 | const | 1 | 100.00 | Using where |
| 1 | SIMPLE | tag | eq_ref | PRIMARY,published | PRIMARY | 4 | tajhizaf_maindb.xref.tagID | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1403 |
| 15 | K2ModelItem->getItemTags() | JROOT/components/com_k2/models/item.php:109 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.24 ms** **پس از آخرین پرس و جو: 0.57 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.163 MB** **سطرهای بازگشتی: 0**
SELECT id, gender, description, image, url, `
group`, plugins
FROM jm3_k2_users
WHERE userID=823
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_users | ref | userID | userID | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 16 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1874 |
| 15 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:251 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.25 ms** **پس از آخرین پرس و جو: 0.16 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.171 MB** **سطرهای بازگشتی: 0**
SELECT id, gender, description, image, url, `
group`, plugins
FROM jm3_k2_users
WHERE userID=823
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_users | ref | userID | userID | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 17 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1874 |
| 16 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:55 |
| 15 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:252 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.33 ms** **پس از آخرین پرس و جو: 1.83 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.215 MB** **سطرهای بازگشتی: 1**
SELECT tag.*
FROM jm3_k2_tags AS tag
JOIN jm3_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 432
ORDER BY xref.id ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | xref | ref | tagID,itemID | itemID | 4 | const | 1 | 100.00 | Using where |
| 1 | SIMPLE | tag | eq_ref | PRIMARY,published | PRIMARY | 4 | tajhizaf_maindb.xref.tagID | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1403 |
| 15 | K2ModelItem->getItemTags() | JROOT/components/com_k2/models/item.php:109 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.22 ms** **پس از آخرین پرس و جو: 0.72 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.226 MB** **سطرهای بازگشتی: 0**
SELECT id, gender, description, image, url, `
group`, plugins
FROM jm3_k2_users
WHERE userID=823
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_users | ref | userID | userID | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 16 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1874 |
| 15 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:251 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.18 ms** **پس از آخرین پرس و جو: 0.21 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.234 MB** **سطرهای بازگشتی: 0**
SELECT id, gender, description, image, url, `
group`, plugins
FROM jm3_k2_users
WHERE userID=823
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_users | ref | userID | userID | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 17 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1874 |
| 16 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:55 |
| 15 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:252 |
| 14 | K2ModelItem->prepareItem() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:41 |
| 12 | JCacheControllerCallback->call() | JROOT/components/com_k2/views/itemlist/view.html.php:462 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.68 ms** **پس از آخرین پرس و جو: 3.14 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.388 MB** **سطرهای بازگشتی: 27**
select *
from jm3_k2_categories
where alias LIKE 'letter-%'
AND published = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_categories | ALL | category,published | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 209 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.43 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/templates/flex/helpers.php:41 |
| 15 | getLetterCategories() | JROOT/templates/flex/html/com_k2/brands/category.php:19 |
| 14 | include JROOT/templates/flex/html/com_k2/brands/category.php | JROOT/libraries/legacy/view/legacy.php:694 |
| 13 | JViewLegacy->loadTemplate() | JROOT/libraries/legacy/view/legacy.php:229 |
| 12 | JViewLegacy->display() | JROOT/components/com_k2/views/itemlist/view.html.php:770 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.57 ms** **پس از آخرین پرس و جو: 0.02 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.395 MB** **سطرهای بازگشتی: 27**
select *
from jm3_k2_categories
where alias LIKE 'letter-%'
AND published = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_categories | ALL | category,published | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 209 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.33 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/templates/flex/helpers.php:42 |
| 15 | getLetterCategories() | JROOT/templates/flex/html/com_k2/brands/category.php:19 |
| 14 | include JROOT/templates/flex/html/com_k2/brands/category.php | JROOT/libraries/legacy/view/legacy.php:694 |
| 13 | JViewLegacy->loadTemplate() | JROOT/libraries/legacy/view/legacy.php:229 |
| 12 | JViewLegacy->display() | JROOT/components/com_k2/views/itemlist/view.html.php:770 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.49 ms** **پس از آخرین پرس و جو: 0.11 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.527 MB** **سطرهای بازگشتی: 27**
select *
from jm3_k2_categories
where alias LIKE 'letter-%'
AND published = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_categories | ALL | category,published | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 209 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.27 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/templates/flex/helpers.php:69 |
| 15 | getBrandsByPage() | JROOT/templates/flex/html/com_k2/brands/category.php:28 |
| 14 | include JROOT/templates/flex/html/com_k2/brands/category.php | JROOT/libraries/legacy/view/legacy.php:694 |
| 13 | JViewLegacy->loadTemplate() | JROOT/libraries/legacy/view/legacy.php:229 |
| 12 | JViewLegacy->display() | JROOT/components/com_k2/views/itemlist/view.html.php:770 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.51 ms** **پس از آخرین پرس و جو: 0.03 ms** **حافظه پرس و جو: 0.014 MB حافظه قبل از پرس و جوی: 13.544 MB** **سطرهای بازگشتی: 27**
select *
from jm3_k2_categories
where alias LIKE 'letter-%'
AND published = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_categories | ALL | category,published | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 209 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.29 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/templates/flex/helpers.php:70 |
| 15 | getBrandsByPage() | JROOT/templates/flex/html/com_k2/brands/category.php:28 |
| 14 | include JROOT/templates/flex/html/com_k2/brands/category.php | JROOT/libraries/legacy/view/legacy.php:694 |
| 13 | JViewLegacy->loadTemplate() | JROOT/libraries/legacy/view/legacy.php:229 |
| 12 | JViewLegacy->display() | JROOT/components/com_k2/views/itemlist/view.html.php:770 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.53 ms** **پس از آخرین پرس و جو: 0.08 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.681 MB** **سطرهای بازگشتی: 14**
**پرس و جوی تکراری**:
#67select *
from jm3_k2_categories
where parent IN (13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39)
AND published = 1
order by `name`
limit 30 offset 30
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_categories | range | category,parent,published | parent | 5 | NULL | 51 | 100.00 | Using index condition; Using where; **با استفاده از مرتب سازی فایل** |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.07 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.21 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/templates/flex/helpers.php:77 |
| 15 | getBrandsByPage() | JROOT/templates/flex/html/com_k2/brands/category.php:28 |
| 14 | include JROOT/templates/flex/html/com_k2/brands/category.php | JROOT/libraries/legacy/view/legacy.php:694 |
| 13 | JViewLegacy->loadTemplate() | JROOT/libraries/legacy/view/legacy.php:229 |
| 12 | JViewLegacy->display() | JROOT/components/com_k2/views/itemlist/view.html.php:770 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.50 ms** **پس از آخرین پرس و جو: 0.05 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.689 MB** **سطرهای بازگشتی: 14**
**پرس و جوی تکراری**:
#66select *
from jm3_k2_categories
where parent IN (13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39)
AND published = 1
order by `name`
limit 30 offset 30
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_categories | range | category,parent,published | parent | 5 | NULL | 51 | 100.00 | Using index condition; Using where; **با استفاده از مرتب سازی فایل** |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.06 ms |
| Preparing | 0.04 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.19 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/templates/flex/helpers.php:78 |
| 15 | getBrandsByPage() | JROOT/templates/flex/html/com_k2/brands/category.php:28 |
| 14 | include JROOT/templates/flex/html/com_k2/brands/category.php | JROOT/libraries/legacy/view/legacy.php:694 |
| 13 | JViewLegacy->loadTemplate() | JROOT/libraries/legacy/view/legacy.php:229 |
| 12 | JViewLegacy->display() | JROOT/components/com_k2/views/itemlist/view.html.php:770 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.32 ms** **پس از آخرین پرس و جو: 0.11 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.638 MB** **سطرهای بازگشتی: 27**
**پرس و جوی تکراری**:
#69select id, alias
from jm3_k2_categories
where alias LIKE 'letter-%'
AND published = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_categories | ALL | category,published | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 209 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.10 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/templates/flex/helpers.php:105 |
| 15 | getBrandsTotalCount() | JROOT/templates/flex/html/com_k2/brands/category.php:29 |
| 14 | include JROOT/templates/flex/html/com_k2/brands/category.php | JROOT/libraries/legacy/view/legacy.php:694 |
| 13 | JViewLegacy->loadTemplate() | JROOT/libraries/legacy/view/legacy.php:229 |
| 12 | JViewLegacy->display() | JROOT/components/com_k2/views/itemlist/view.html.php:770 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.32 ms** **پس از آخرین پرس و جو: 0.03 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.646 MB** **سطرهای بازگشتی: 27**
**پرس و جوی تکراری**:
#68select id, alias
from jm3_k2_categories
where alias LIKE 'letter-%'
AND published = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_categories | ALL | category,published | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 209 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.10 ms |
| End of update loop | 0.03 ms |
| Query end | 0.01 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/templates/flex/helpers.php:106 |
| 15 | getBrandsTotalCount() | JROOT/templates/flex/html/com_k2/brands/category.php:29 |
| 14 | include JROOT/templates/flex/html/com_k2/brands/category.php | JROOT/libraries/legacy/view/legacy.php:694 |
| 13 | JViewLegacy->loadTemplate() | JROOT/libraries/legacy/view/legacy.php:229 |
| 12 | JViewLegacy->display() | JROOT/components/com_k2/views/itemlist/view.html.php:770 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.34 ms** **پس از آخرین پرس و جو: 0.06 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.670 MB** **سطرهای بازگشتی: 44**
**پرس و جوی تکراری**:
#71select id
from jm3_k2_categories
where parent IN (13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39)
AND published = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_categories | range | category,parent,published | parent | 5 | NULL | 51 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.06 ms |
| Preparing | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.08 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/templates/flex/helpers.php:114 |
| 15 | getBrandsTotalCount() | JROOT/templates/flex/html/com_k2/brands/category.php:29 |
| 14 | include JROOT/templates/flex/html/com_k2/brands/category.php | JROOT/libraries/legacy/view/legacy.php:694 |
| 13 | JViewLegacy->loadTemplate() | JROOT/libraries/legacy/view/legacy.php:229 |
| 12 | JViewLegacy->display() | JROOT/components/com_k2/views/itemlist/view.html.php:770 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.33 ms** **پس از آخرین پرس و جو: 0.03 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.678 MB** **سطرهای بازگشتی: 44**
**پرس و جوی تکراری**:
#70select id
from jm3_k2_categories
where parent IN (13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39)
AND published = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_categories | range | category,parent,published | parent | 5 | NULL | 51 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.06 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.08 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/templates/flex/helpers.php:115 |
| 15 | getBrandsTotalCount() | JROOT/templates/flex/html/com_k2/brands/category.php:29 |
| 14 | include JROOT/templates/flex/html/com_k2/brands/category.php | JROOT/libraries/legacy/view/legacy.php:694 |
| 13 | JViewLegacy->loadTemplate() | JROOT/libraries/legacy/view/legacy.php:229 |
| 12 | JViewLegacy->display() | JROOT/components/com_k2/views/itemlist/view.html.php:770 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.63 ms** **پس از آخرین پرس و جو: 0.27 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.684 MB** **سطرهای بازگشتی: 219**
SELECT id, name, parent
FROM jm3_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1,5)
ORDER BY parent
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_k2_categories | ref | category,published,access,trash | category | 2 | const | 209 | 100.00 | Using index condition; Using where; **با استفاده از مرتب سازی فایل** |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.34 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/itemlist.php:1245 |
| 17 | K2ModelItemlist->getCategoriesTree() | JROOT/components/com_k2/helpers/route.php:314 |
| 16 | K2HelperRoute::_findItem() | JROOT/components/com_k2/helpers/route.php:58 |
| 15 | K2HelperRoute::getCategoryRoute() | JROOT/templates/flex/html/com_k2/brands/category.php:42 |
| 14 | include JROOT/templates/flex/html/com_k2/brands/category.php | JROOT/libraries/legacy/view/legacy.php:694 |
| 13 | JViewLegacy->loadTemplate() | JROOT/libraries/legacy/view/legacy.php:229 |
| 12 | JViewLegacy->display() | JROOT/components/com_k2/views/itemlist/view.html.php:770 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.64 ms** **پس از آخرین پرس و جو: 7.27 ms** **حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 13.231 MB** **سطرهای بازگشتی: 6**
SHOW FULL COLUMNS
FROM `jm3_template_styles`
**توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `jm3_template_styles`**
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| closing tables | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.23 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Filling schema table | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| checking permissions | 0.05 ms |
| closing tables | 0.01 ms |
| checking permissions | 0.00 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Removing tmp table | 0.07 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 12 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:244 |
| 11 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:163 |
| 10 | JTable->__construct() | JROOT/administrator/components/com_templates/tables/style.php:30 |
| 9 | TemplatesTableStyle->__construct() | JROOT/libraries/joomla/table/table.php:311 |
| 8 | JTable::getInstance() | JROOT/plugins/system/helix3/helix3.php:33 |
| 7 | plgSystemHelix3->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 4 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/site.php:196 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.24 ms** **پس از آخرین پرس و جو: 0.08 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 13.249 MB** **سطرهای بازگشتی: 1**
SELECT *
FROM jm3_template_styles
WHERE `id` = '11'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_template_styles | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1445 |
| 9 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:729 |
| 8 | JTable->load() | JROOT/plugins/system/helix3/helix3.php:34 |
| 7 | plgSystemHelix3->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 4 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/site.php:196 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 1.38 ms** **پس از آخرین پرس و جو: 29.13 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 15.318 MB** **سطرهای بازگشتی: 33**
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down
FROM jm3_modules AS m
LEFT JOIN jm3_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN jm3_advancedmodules as am
ON am.moduleid = m.id
WHERE m.published = 1
AND e.enabled = 1
AND m.access IN (1,1,5)
AND m.client_id = 0
ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | ref | published,newsfeeds | published | 1 | const | 39 | 50.65 | Using index condition; Using where; **با استفاده از مرتب سازی فایل** |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | tajhizaf_maindb.m.module,const | 1 | 100.00 | Using index condition; Using where |
| 1 | SIMPLE | am | eq_ref | PRIMARY | PRIMARY | 4 | tajhizaf_maindb.m.id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.19 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.05 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.07 ms |
| Preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.65 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.07 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:402 |
| 17 | PlgSystemAdvancedModuleHelper->getModuleList() | JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:123 |
| 16 | PlgSystemAdvancedModuleHelper->onPrepareModuleList() | JROOT/libraries/joomla/event/dispatcher.php:165 |
| 15 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 14 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/module/helper.php:355 |
| 13 | JModuleHelper::load() | JROOT/libraries/cms/module/helper.php:84 |
| 12 | JModuleHelper::getModules() | JROOT/libraries/joomla/document/html.php:576 |
| 11 | JDocumentHtml->countModules() | JROOT/plugins/system/helix3/core/helix3.php:600 |
| 10 | Helix3::countModules() | JROOT/plugins/system/helix3/core/helix3.php:547 |
| 9 | Helix3::rowColumns() | JROOT/plugins/system/helix3/core/helix3.php:258 |
| 8 | Helix3::generatelayout() | JROOT/templates/flex/index.php:214 |
| 7 | require JROOT/templates/flex/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1098 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.32 ms** **پس از آخرین پرس و جو: 9.77 ms** **حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 15.773 MB** **سطرهای بازگشتی: 0**
SELECT *
FROM `jm3_plg_easyfrontendseo`
WHERE `url` = 'index.php?option=com_k2&limitstart=30&view=itemlist&layout=category&Itemid=271'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_plg_easyfrontendseo | ALL | NULL | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.00 ms |
| Query end | 0.01 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1445 |
| 13 | JDatabaseDriver->loadAssoc() | JROOT/plugins/system/easyfrontendseo/easyfrontendseo.php:476 |
| 12 | PlgSystemEasyFrontendSeo->onBeforeCompileHead() | JROOT/libraries/joomla/event/event.php:70 |
| 11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 10 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 9 | JApplicationBase->triggerEvent() | JROOT/libraries/joomla/document/renderer/html/head.php:63 |
| 8 | JDocumentRendererHtmlHead->fetchHead() | JROOT/libraries/joomla/document/renderer/html/head.php:34 |
| 7 | JDocumentRendererHtmlHead->render() | JROOT/libraries/joomla/document/html.php:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1112 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.28 ms** **پس از آخرین پرس و جو: 4.35 ms** **حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 16.188 MB** **سطرهای بازگشتی: 81**
SELECT *
FROM jm3_acymailing_config
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jm3_acymailing_config | ALL | NULL | **کلید شاخصی برای استفاده نیست** | NULL | NULL | 81 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_acymailing/classes/cpanel.php:17 |
| 10 | cpanelClass->load() | JROOT/administrator/components/com_acymailing/helpers/helper.php:454 |
| 9 | acymailing_config() | JROOT/administrator/components/com_acymailing/helpers/helper.php:1128 |
| 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/joomla/application/base.php:106 |
| 4 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1118 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
**زمان پرس و جو: 0.75 ms** **پس از آخرین پرس و جو: 5.35 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 16.419 MB** **سطرهای بازگشتی: 227**
**پرس و جوی تکراری**:
#8 #16SHOW TABLES
**توضیحات در جستجو ممکن نیست: SHOW TABLES**
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.00 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Filling schema table | 0.00 ms |
| checking permissions | 0.45 ms |
| Executing | 0.01 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Removing tmp table | 0.01 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | **فراخوانده** | **فایل و شماره خط** |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 9 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/database/driver/mysqli.php:497 |
| 8 | JDatabaseDriverMysqli->getTableList() | JROOT/plugins/system/jdownloads/jdownloads.php:253 |
| 7 | plgSystemjdownloads->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 4 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1118 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
