**زمان پرس و جو: 0.74 ms** **حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 2.672 MB** **سطرهای بازگشتی: 0**
SELECT `data`
FROM `jm3_session`
WHERE `session_id` = 'bc1c7d4aaf99ca959c772ec15239c75f'
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.18 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.08 ms |
Optimizing | 0.03 ms |
Statistics | 0.07 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.08 ms |
closing tables | 0.03 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 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.47 ms** **پس از آخرین پرس و جو: 0.84 ms** **حافظه پرس و جو: 0.004 MB حافظه قبل از پرس و جوی: 2.753 MB** **سطرهای بازگشتی: 0**
SELECT `session_id`
FROM `jm3_session`
WHERE `session_id` = 'bc1c7d4aaf99ca959c772ec15239c75f'
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.08 ms |
checking permissions | 0.02 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.02 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.05 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.02 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Query end | 0.03 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 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.51 ms** **پس از آخرین پرس و جو: 0.04 ms** **حافظه پرس و جو: 0.003 MB حافظه قبل از پرس و جوی: 2.757 MB**
INSERT INTO `jm3_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('bc1c7d4aaf99ca959c772ec15239c75f', 1, '1732251840', 0, '', 0)
**توضیحات در جستجو ممکن نیست: INSERT INTO `jm3_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('bc1c7d4aaf99ca959c772ec15239c75f', 1, '1732251840', 0, '', 0)**
Status | Duration |
---|
Starting | 0.06 ms |
checking permissions | 0.02 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.03 ms |
table lock | 0.01 ms |
init for update | 0.02 ms |
Update | 0.11 ms |
End of update loop | 0.02 ms |
Query end | 0.03 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.04 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 ms |
Updating status | 0.03 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.64 ms** **پس از آخرین پرس و جو: 1.79 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 2.991 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.06 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.07 ms |
Preparing | 0.05 ms |
Executing | 0.01 ms |
Sending data | 0.16 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.03 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 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.57 ms** **پس از آخرین پرس و جو: 2.06 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 3.179 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.09 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.05 ms |
Optimizing | 0.02 ms |
Statistics | 0.04 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 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.42 ms** **پس از آخرین پرس و جو: 0.44 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 3.225 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.05 ms |
checking permissions | 0.03 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.02 ms |
init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.03 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.03 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 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.88 ms** **پس از آخرین پرس و جو: 0.06 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 3.252 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.06 ms |
checking permissions | 0.02 ms |
Opening tables | 0.01 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.06 ms |
Preparing | 0.04 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.01 ms |
Creating sort index | 0.34 ms |
End of update loop | 0.05 ms |
Query end | 0.03 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.05 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 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.22 ms** **پس از آخرین پرس و جو: 22.32 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 5.732 MB** **سطرهای بازگشتی: 227**
SHOW TABLES
**توضیحات در جستجو ممکن نیست: SHOW TABLES**
Status | Duration |
---|
Starting | 0.13 ms |
checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
After opening tables | 0.03 ms |
System lock | 0.04 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.01 ms |
Filling schema table | 0.01 ms |
checking permissions | 0.51 ms |
Executing | 0.04 ms |
Sending data | 0.04 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
closing tables | 0.02 ms |
Removing tmp table | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Query end | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.05 ms |
Updating status | 0.04 ms |
Reset for next command | 0.02 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.67 ms** **پس از آخرین پرس و جو: 0.12 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 5.763 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 <= '2024-11-22 08:34:00'
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.07 ms |
checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.07 ms |
Preparing | 0.05 ms |
Executing | 0.01 ms |
Sending data | 0.03 ms |
End of update loop | 0.05 ms |
Query end | 0.03 ms |
Commit | 0.01 ms |
Query end | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.05 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 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.44 ms** **پس از آخرین پرس و جو: 0.02 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 5.768 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 <= '2024-11-22 08:34:00'
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.05 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.06 ms |
Preparing | 0.04 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Query end | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 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 |
**زمان پرس و جو: 2.14 ms** **پس از آخرین پرس و جو: 2.27 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 6.062 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 | 3 | 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.11 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
table lock | 0.01 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.07 ms |
Preparing | 0.04 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.01 ms |
Creating sort index | 1.37 ms |
End of update loop | 0.03 ms |
Query end | 0.01 ms |
closing tables | 0.04 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.06 ms |
Query end | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.06 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 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.59 ms** **پس از آخرین پرس و جو: 15.19 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 8.497 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.08 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.02 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.14 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.04 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 ms |
Updating status | 0.02 ms |
Reset for next command | 0.03 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.46 ms** **پس از آخرین پرس و جو: 0.08 ms** **حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 8.490 MB**
UPDATE `jm3_extensions`
SET `params` = '{\"mediaversion\":\"b77c0c0a6a41a2639550b88180d3a2f3\"}'
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.05 ms |
checking permissions | 0.02 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init for update | 0.11 ms |
Updating | 0.05 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.04 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 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.53 ms** **پس از آخرین پرس و جو: 1.96 ms** **حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 8.791 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.05 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.02 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.02 ms |
Preparing | 0.01 ms |
Sorting result | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.01 ms |
Creating sort index | 0.06 ms |
End of update loop | 0.05 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.04 ms |
Updating status | 0.04 ms |
Reset for next command | 0.01 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.91 ms** **پس از آخرین پرس و جو: 1.79 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 8.979 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.08 ms |
checking permissions | 0.04 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.03 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.06 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.28 ms |
End of update loop | 0.04 ms |
Query end | 0.01 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.04 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/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.92 ms** **پس از آخرین پرس و جو: 2.79 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 9.028 MB** **سطرهای بازگشتی: 227**
**پرس و جوی تکراری**:
#8 #81SHOW TABLES
**توضیحات در جستجو ممکن نیست: SHOW TABLES**
Status | Duration |
---|
Starting | 0.06 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.03 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.01 ms |
Filling schema table | 0.01 ms |
checking permissions | 0.45 ms |
Executing | 0.04 ms |
Sending data | 0.04 ms |
End of update loop | 0.03 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Removing tmp table | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 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.90 ms** **پس از آخرین پرس و جو: 1.28 ms** **حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 9.088 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.11 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.02 ms |
table lock | 0.01 ms |
init | 0.08 ms |
Optimizing | 0.03 ms |
Statistics | 0.10 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.23 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.04 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 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.64 ms** **پس از آخرین پرس و جو: 8.04 ms** **حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 10.068 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 | 211 | 100.00 | Using where; Using index |
Status | Duration |
---|
Starting | 0.06 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.02 ms |
init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.09 ms |
Preparing | 0.04 ms |
Executing | 0.01 ms |
Sending data | 0.10 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.03 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 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.64 ms** **پس از آخرین پرس و جو: 0.43 ms** **حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 10.104 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.08 ms |
checking permissions | 0.03 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.07 ms |
Preparing | 0.03 ms |
Executing | 0.03 ms |
Sending data | 0.12 ms |
End of update loop | 0.03 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 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.85 ms** **پس از آخرین پرس و جو: 0.03 ms** **حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 10.115 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 | 211 | 26.07 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.07 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.09 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.37 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 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.78 ms** **پس از آخرین پرس و جو: 0.02 ms** **حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 10.131 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 | 211 | 49.76 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.06 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.03 ms |
Statistics | 0.11 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.25 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.06 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 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.76 ms** **پس از آخرین پرس و جو: 0.02 ms** **حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 10.140 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 | 211 | 36.97 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.07 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.12 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.22 ms |
End of update loop | 0.03 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.03 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 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.53 ms** **پس از آخرین پرس و جو: 0.03 ms** **حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 10.152 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.06 ms |
checking permissions | 0.03 ms |
Opening tables | 0.02 ms |
After opening tables | 0.03 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.11 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.04 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 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 |
**زمان پرس و جو: 327.79 ms** **پس از آخرین پرس و جو: 1.42 ms** **حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 10.240 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 <= '2024-11-22 05:04:00' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-22 05:04:00' )
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 0, 10
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | i | ref | item,catid | item | 2 | const | 425 | 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.15 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.09 ms |
Optimizing | 0.05 ms |
Statistics | 0.33 ms |
Preparing | 0.07 ms |
Creating tmp table | 0.06 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 325.06 ms |
Creating sort index | 0.99 ms |
Removing tmp table | 0.56 ms |
Creating sort index | 0.04 ms |
End of update loop | 0.01 ms |
Query end | 0.03 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.02 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.06 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 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 |
**زمان پرس و جو: 106.31 ms** **پس از آخرین پرس و جو: 0.45 ms** **حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 10.361 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 <= '2024-11-22 05:04:00' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-22 05:04:00' )
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 | 425 | 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.18 ms |
checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.09 ms |
Optimizing | 0.06 ms |
Statistics | 0.36 ms |
Preparing | 0.11 ms |
Executing | 0.02 ms |
Sending data | 104.93 ms |
End of update loop | 0.17 ms |
Removing tmp table | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.06 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 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.89 ms** **پس از آخرین پرس و جو: 1.55 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 10.541 MB** **سطرهای بازگشتی: 14**
SHOW FULL COLUMNS
FROM `jm3_k2_categories`
**توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `jm3_k2_categories`**
Status | Duration |
---|
Starting | 0.07 ms |
checking permissions | 0.02 ms |
closing tables | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.17 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
table lock | 0.03 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.04 ms |
Executing | 0.01 ms |
Filling schema table | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
checking permissions | 0.05 ms |
closing tables | 0.01 ms |
checking permissions | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.03 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Removing tmp table | 0.08 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.04 ms |
Updating status | 0.02 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.59 ms** **پس از آخرین پرس و جو: 0.64 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 10.599 MB** **سطرهای بازگشتی: 1**
SELECT *
FROM jm3_k2_categories
WHERE id = '263'
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.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.03 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.03 ms |
End of update loop | 0.01 ms |
Query end | 0.04 ms |
Commit | 0.01 ms |
Query end | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 ms |
Updating status | 0.04 ms |
Reset for next command | 0.02 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 |
**زمان پرس و جو: 1.03 ms** **پس از آخرین پرس و جو: 1.08 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 10.691 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 | 211 | 100.00 | Using index condition; Using where; **با استفاده از مرتب سازی فایل** |
Status | Duration |
---|
Starting | 0.06 ms |
checking permissions | 0.02 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.03 ms |
Statistics | 0.06 ms |
Preparing | 0.04 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.01 ms |
Creating sort index | 0.41 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.04 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 ms |
Updating status | 0.04 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/components/com_k2/models/item.php:78 |
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.43 ms** **پس از آخرین پرس و جو: 3.85 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 10.885 MB** **سطرهای بازگشتی: 1**
SELECT *
FROM jm3_k2_categories
WHERE id = '11'
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.02 ms |
Opening tables | 0.01 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.02 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.02 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 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:96 |
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.54 ms** **پس از آخرین پرس و جو: 0.25 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 10.906 MB** **سطرهای بازگشتی: 0**
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 = 504
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.06 ms |
After opening tables | 0.02 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.05 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 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.70 ms** **پس از آخرین پرس و جو: 0.88 ms** **حافظه پرس و جو: 0.011 MB حافظه قبل از پرس و جوی: 10.977 MB** **سطرهای بازگشتی: 16**
SHOW FULL COLUMNS
FROM `jm3_users`
**توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `jm3_users`**
Status | Duration |
---|
Starting | 0.05 ms |
checking permissions | 0.02 ms |
closing tables | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.16 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.01 ms |
Filling schema table | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
checking permissions | 0.05 ms |
closing tables | 0.01 ms |
checking permissions | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.03 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Removing tmp table | 0.07 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 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.46 ms** **پس از آخرین پرس و جو: 0.08 ms** **حافظه پرس و جو: 0.010 MB حافظه قبل از پرس و جوی: 11.013 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.05 ms |
checking permissions | 0.04 ms |
Opening tables | 0.02 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 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.47 ms** **پس از آخرین پرس و جو: 2.27 ms** **حافظه پرس و جو: 0.011 MB حافظه قبل از پرس و جوی: 11.773 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.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.06 ms |
Preparing | 0.05 ms |
Executing | 0.01 ms |
Sending data | 0.03 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.05 ms |
Updating status | 0.02 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.42 ms** **پس از آخرین پرس و جو: 1.43 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 11.891 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.08 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 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.03 ms |
Preparing | 0.02 ms |
Executing | 0.03 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 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.42 ms** **پس از آخرین پرس و جو: 0.13 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 11.900 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.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.02 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.03 ms |
Updating status | 0.02 ms |
Reset for next command | 0.02 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.14 ms** **پس از آخرین پرس و جو: 7.98 ms** **حافظه پرس و جو: 0.010 MB حافظه قبل از پرس و جوی: 12.520 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 (263,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.10 ms |
checking permissions | 0.03 ms |
Opening tables | 0.06 ms |
After opening tables | 0.03 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.06 ms |
Optimizing | 0.04 ms |
Statistics | 0.10 ms |
Preparing | 0.05 ms |
Creating tmp table | 0.08 ms |
Sorting result | 0.02 ms |
Executing | 0.02 ms |
Sending data | 0.17 ms |
Creating sort index | 0.05 ms |
Removing tmp table | 0.07 ms |
Creating sort index | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 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.50 ms** **پس از آخرین پرس و جو: 3.43 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 12.891 MB** **سطرهای بازگشتی: 0**
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 = 503
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.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.03 ms |
init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.04 ms |
Preparing | 0.02 ms |
Sorting result | 0.01 ms |
Executing | 0.03 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.03 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 ms |
Updating status | 0.03 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.47 ms** **پس از آخرین پرس و جو: 0.32 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 12.900 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.07 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.03 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.03 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.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.06 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.42 ms** **پس از آخرین پرس و جو: 0.11 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 12.909 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.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.02 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.04 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.03 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.43 ms** **پس از آخرین پرس و جو: 1.87 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 12.959 MB** **سطرهای بازگشتی: 0**
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 = 502
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.03 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.04 ms |
Preparing | 0.02 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 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.39 ms** **پس از آخرین پرس و جو: 0.31 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 12.969 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.02 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.02 ms |
Executing | 0.01 ms |
Sending data | 0.01 ms |
End of update loop | 0.03 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 ms |
Updating status | 0.03 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.34 ms** **پس از آخرین پرس و جو: 0.11 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 12.977 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.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.03 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.03 ms |
Updating status | 0.02 ms |
Reset for next command | 0.02 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.50 ms** **پس از آخرین پرس و جو: 1.71 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.021 MB** **سطرهای بازگشتی: 0**
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 = 501
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.13 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.03 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.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 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.40 ms** **پس از آخرین پرس و جو: 0.30 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.031 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.02 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.03 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.03 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.03 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.37 ms** **پس از آخرین پرس و جو: 0.10 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.039 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.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.04 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.03 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.46 ms** **پس از آخرین پرس و جو: 1.80 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.082 MB** **سطرهای بازگشتی: 0**
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 = 499
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.07 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.03 ms |
Statistics | 0.04 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.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.03 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 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.35 ms** **پس از آخرین پرس و جو: 0.31 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.092 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.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.03 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.03 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.42 ms** **پس از آخرین پرس و جو: 0.10 ms** **حافظه پرس و جو: 0.009 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.05 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.03 ms |
Optimizing | 0.01 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.01 ms |
Commit | 0.02 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.04 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.41 ms** **پس از آخرین پرس و جو: 0.96 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.087 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.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 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** **پس از آخرین پرس و جو: 0.64 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.155 MB** **سطرهای بازگشتی: 0**
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 = 493
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.02 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.03 ms |
Statistics | 0.04 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.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 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.41 ms** **پس از آخرین پرس و جو: 0.31 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.165 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.01 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 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.40 ms** **پس از آخرین پرس و جو: 0.11 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.173 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.01 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.02 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.03 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.03 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.98 ms** **پس از آخرین پرس و جو: 0.89 ms** **حافظه پرس و جو: 0.010 MB حافظه قبل از پرس و جوی: 13.146 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.10 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.04 ms |
System lock | 0.02 ms |
table lock | 0.01 ms |
init | 0.06 ms |
Optimizing | 0.03 ms |
Statistics | 0.07 ms |
Preparing | 0.04 ms |
Creating tmp table | 0.06 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.17 ms |
Creating sort index | 0.04 ms |
Removing tmp table | 0.06 ms |
Creating sort index | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 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.50 ms** **پس از آخرین پرس و جو: 0.79 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.228 MB** **سطرهای بازگشتی: 0**
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 = 492
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.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.02 ms |
Sorting result | 0.01 ms |
Executing | 0.03 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.07 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.05 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.38 ms** **پس از آخرین پرس و جو: 0.31 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.237 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.01 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.01 ms |
Statistics | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 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.43 ms** **پس از آخرین پرس و جو: 0.09 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.245 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.06 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.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.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.04 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.54 ms** **پس از آخرین پرس و جو: 1.52 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.289 MB** **سطرهای بازگشتی: 0**
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 = 491
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.11 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.04 ms |
Preparing | 0.02 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.03 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 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.33 ms** **پس از آخرین پرس و جو: 0.31 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.298 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.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.02 ms |
Executing | 0.01 ms |
Sending data | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.05 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.37 ms** **پس از آخرین پرس و جو: 0.11 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.306 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.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.03 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.03 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.42 ms** **پس از آخرین پرس و جو: 1.35 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.350 MB** **سطرهای بازگشتی: 0**
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 = 490
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.01 ms |
System lock | 0.01 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.03 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.03 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.05 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.35 ms** **پس از آخرین پرس و جو: 0.31 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.360 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.06 ms |
checking permissions | 0.02 ms |
Opening tables | 0.01 ms |
After opening tables | 0.02 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.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.03 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.37 ms** **پس از آخرین پرس و جو: 0.09 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.368 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.07 ms |
checking permissions | 0.02 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.04 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 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.40 ms** **پس از آخرین پرس و جو: 1.36 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.412 MB** **سطرهای بازگشتی: 0**
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 = 489
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.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.02 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 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.36 ms** **پس از آخرین پرس و جو: 0.32 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.422 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.01 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.03 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.38 ms** **پس از آخرین پرس و جو: 0.10 ms** **حافظه پرس و جو: 0.014 MB حافظه قبل از پرس و جوی: 13.439 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.07 ms |
checking permissions | 0.02 ms |
Opening tables | 0.01 ms |
After opening tables | 0.02 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.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.03 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.77 ms** **پس از آخرین پرس و جو: 2.35 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.598 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 | 211 | 100.00 | Using where |
Status | Duration |
---|
Starting | 0.06 ms |
checking permissions | 0.02 ms |
Opening tables | 0.01 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.03 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.37 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 ms |
Updating status | 0.05 ms |
Reset for next command | 0.02 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.74 ms** **پس از آخرین پرس و جو: 0.02 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.605 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 | 211 | 100.00 | Using where |
Status | Duration |
---|
Starting | 0.03 ms |
checking permissions | 0.03 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.05 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.30 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.05 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/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.99 ms** **پس از آخرین پرس و جو: 0.07 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.737 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 | 211 | 100.00 | Using where |
Status | Duration |
---|
Starting | 0.06 ms |
checking permissions | 0.02 ms |
Opening tables | 0.01 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.54 ms |
End of update loop | 0.04 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 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.64 ms** **پس از آخرین پرس و جو: 0.02 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.745 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 | 211 | 100.00 | Using where |
Status | Duration |
---|
Starting | 0.05 ms |
checking permissions | 0.02 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.02 ms |
Executing | 0.02 ms |
Sending data | 0.28 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 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/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.79 ms** **پس از آخرین پرس و جو: 0.05 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.877 MB** **سطرهای بازگشتی: 30**
**پرس و جوی تکراری**:
#71select *
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 0
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.05 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.02 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.08 ms |
Preparing | 0.06 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.01 ms |
Creating sort index | 0.25 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 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.69 ms** **پس از آخرین پرس و جو: 0.01 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.884 MB** **سطرهای بازگشتی: 30**
**پرس و جوی تکراری**:
#70select *
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 0
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.06 ms |
checking permissions | 0.02 ms |
Opening tables | 0.01 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.06 ms |
Preparing | 0.06 ms |
Sorting result | 0.01 ms |
Executing | 0.02 ms |
Sending data | 0.01 ms |
Creating sort index | 0.22 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.03 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/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.46 ms** **پس از آخرین پرس و جو: 0.06 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.907 MB** **سطرهای بازگشتی: 27**
**پرس و جوی تکراری**:
#73select 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 | 211 | 100.00 | Using where |
Status | Duration |
---|
Starting | 0.06 ms |
checking permissions | 0.02 ms |
Opening tables | 0.01 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.03 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.09 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 ms |
Updating status | 0.02 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.46 ms** **پس از آخرین پرس و جو: 0.01 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.914 MB** **سطرهای بازگشتی: 27**
**پرس و جوی تکراری**:
#72select 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 | 211 | 100.00 | Using where |
Status | Duration |
---|
Starting | 0.08 ms |
checking permissions | 0.02 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.03 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.10 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.03 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/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.47 ms** **پس از آخرین پرس و جو: 0.04 ms** **حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 13.939 MB** **سطرهای بازگشتی: 44**
**پرس و جوی تکراری**:
#75select 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.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.02 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.01 ms |
Sending data | 0.08 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 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.58 ms** **پس از آخرین پرس و جو: 0.01 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.946 MB** **سطرهای بازگشتی: 44**
**پرس و جوی تکراری**:
#74select 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.12 ms |
checking permissions | 0.02 ms |
Opening tables | 0.01 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.07 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.08 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.03 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 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/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.88 ms** **پس از آخرین پرس و جو: 5.42 ms** **حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 13.271 MB** **سطرهای بازگشتی: 6**
SHOW FULL COLUMNS
FROM `jm3_template_styles`
**توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `jm3_template_styles`**
Status | Duration |
---|
Starting | 0.07 ms |
checking permissions | 0.04 ms |
closing tables | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.20 ms |
After opening tables | 0.03 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.01 ms |
Filling schema table | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
checking permissions | 0.07 ms |
closing tables | 0.02 ms |
checking permissions | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.08 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Removing tmp table | 0.07 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 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.45 ms** **پس از آخرین پرس و جو: 0.06 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 13.288 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.05 ms |
checking permissions | 0.02 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.02 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.07 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.03 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 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.35 ms** **پس از آخرین پرس و جو: 23.33 ms** **حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 15.357 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.13 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.07 ms |
Preparing | 0.07 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.01 ms |
Creating sort index | 0.66 ms |
End of update loop | 0.03 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.05 ms |
Updating status | 0.03 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.37 ms** **پس از آخرین پرس و جو: 7.97 ms** **حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 15.813 MB** **سطرهای بازگشتی: 0**
SELECT *
FROM `jm3_plg_easyfrontendseo`
WHERE `url` = 'index.php?option=com_k2&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.07 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.03 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 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.39 ms** **پس از آخرین پرس و جو: 3.54 ms** **حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 16.236 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.05 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 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.01 ms |
Preparing | 0.02 ms |
Executing | 0.01 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.03 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 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.92 ms** **پس از آخرین پرس و جو: 5.72 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 16.474 MB** **سطرهای بازگشتی: 227**
**پرس و جوی تکراری**:
#8 #16SHOW TABLES
**توضیحات در جستجو ممکن نیست: SHOW TABLES**
Status | Duration |
---|
Starting | 0.06 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.02 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.01 ms |
Filling schema table | 0.01 ms |
checking permissions | 0.48 ms |
Executing | 0.03 ms |
Sending data | 0.04 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Removing tmp table | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.03 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 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 |