- سخن صبا
- افغانستان
- مالستان
- لینکستان
- فعالیتها
- اعضاء
- اسدالله احمدی
- چمن شاه اعتمادی
- محمد عوض اعتمادی
- حسن علی افتخاری
- رمضان اكبری
- محمد موسی اكبری
- محمد نبی امینی
- نجیب الله حکیمی
- علی حليمی
- سلمانعلی زكی
- ناصر رحمانی
- عوضعلی رحيمی (افضلی)
- محمد ابراهيم شفق
- عبدالعزيز صادقی
- حسين صالحی
- عبدالحكيم عادلی
- محمد شریف عظیمی
- روح الله فرهنگ
- نوروزعلی محسنی
- عبدالله محمدی
- خالق داد ناصری
- سلمان نوری
خبر فوری
- چکیده تأمل و تفکر در باره زندگی سیاسی و پدیدههای سیاسی همچون؛ قدرت، حکومت و...، از دیرباز در…
- تقدیم به شهیدان مظلوم وطنم:بشمار! یک، دو، سه ... وهزاران شهید رامثل نزول دانه باران، شهید راهرلحظه می…
- تقدیم به وطنم افغانستان:وطن! به روی سرت، چترکهکشان ماندهنوشته نام تو درنقشه جهان ماندهتو می توانی که ازجای…
›
‹
**اشکال یابی جوملا**
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1751760523,
"last": 1751760523,
"now": 1751760523
},
"client": {
"forwarded": "216.73.216.106"
},
"token": "tksRuafgHAeFfcSf4cFhcin63HODFDlo"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
},
"vvisit_counter": {
"lastlog": 1751761200
}
}
}
**زمان**
**حافظه**
**زمان**: 38.67 ms / 38.67 ms **حافظه**: 1.906 MB / 2.26 MB Application: afterLoad
**زمان**: 178.36 ms / 217.03 ms **حافظه**: 4.975 MB / 7.23 MB Application: afterInitialise
**زمان**: 31.21 ms / 248.24 ms **حافظه**: 1.043 MB / 8.27 MB Application: afterRoute
**زمان**: 8.30 ms / 256.54 ms **حافظه**: 0.228 MB / 8.50 MB Application: beforeRenderComponent com_content
**زمان**: 13.53 ms / 270.07 ms **حافظه**: 0.540 MB / 9.04 MB Application: Before Access::preloadComponents (all components)
**زمان**: 2.05 ms / 272.12 ms **حافظه**: 0.056 MB / 9.10 MB Application: After Access::preloadComponents (all components)
**زمان**: 0.07 ms / 272.19 ms **حافظه**: -0.004 MB / 9.09 MB Application: Before Access::preloadPermissions (com_content)
**زمان**: 5.24 ms / 277.43 ms **حافظه**: 0.625 MB / 9.72 MB Application: After Access::preloadPermissions (com_content)
**زمان**: 0.08 ms / 277.51 ms **حافظه**: -0.034 MB / 9.69 MB Application: Before Access::getAssetRules (id:109 name:com_content.category.46)
**زمان**: 1.27 ms / 278.78 ms **حافظه**: 0.027 MB / 9.71 MB Application: After Access::getAssetRules (id:109 name:com_content.category.46)
**زمان**: 8.86 ms / 287.64 ms **حافظه**: 0.289 MB / 10.00 MB Application: Before Access::getAssetRules (id:8 name:com_content)
**زمان**: 0.05 ms / 287.69 ms **حافظه**: 0.002 MB / 10.00 MB Application: After Access::getAssetRules (id:8 name:com_content)
**زمان**: 112.03 ms / 399.72 ms **حافظه**: 2.959 MB / 12.96 MB Application: afterRenderComponent com_content
**زمان**: 0.90 ms / 400.61 ms **حافظه**: 0.006 MB / 12.97 MB Application: afterDispatch
**زمان**: 15.42 ms / 416.03 ms **حافظه**: 0.435 MB / 13.40 MB Application: beforeRenderModule mod_menu (منوی بالا)
**زمان**: 23.79 ms / 439.82 ms **حافظه**: 0.358 MB / 13.76 MB Application: afterRenderModule mod_menu (منوی بالا)
**زمان**: 13.61 ms / 453.43 ms **حافظه**: 0.153 MB / 13.91 MB Application: beforeRenderModule mod_roksprocket (سرتیتر خبر)
**زمان**: 49.60 ms / 503.03 ms **حافظه**: 1.086 MB / 15.00 MB Application: afterRenderModule mod_roksprocket (سرتیتر خبر)
**زمان**: 1.30 ms / 504.33 ms **حافظه**: -0.096 MB / 14.90 MB Application: beforeRenderModule mod_search (جستجوی سایت)
**زمان**: 2.46 ms / 506.79 ms **حافظه**: 0.027 MB / 14.93 MB Application: afterRenderModule mod_search (جستجوی سایت)
**زمان**: 1.17 ms / 507.96 ms **حافظه**: -0.002 MB / 14.93 MB Application: beforeRenderModule mod_menu (منوی اصلی)
**زمان**: 7.16 ms / 515.12 ms **حافظه**: 0.149 MB / 15.08 MB Application: afterRenderModule mod_menu (منوی اصلی)
**زمان**: 3.12 ms / 518.24 ms **حافظه**: -0.002 MB / 15.08 MB Application: beforeRenderModule mod_breadcrumbs (مسیر سایت)
**زمان**: 2.17 ms / 520.42 ms **حافظه**: 0.021 MB / 15.10 MB Application: afterRenderModule mod_breadcrumbs (مسیر سایت)
**زمان**: 1.37 ms / 521.79 ms **حافظه**: 0.000 MB / 15.10 MB Application: beforeRenderModule mod_articles_news (درباره بنیاد علمی - فرهنگی صبا)
**زمان**: 13.08 ms / 534.86 ms **حافظه**: 0.141 MB / 15.24 MB Application: afterRenderModule mod_articles_news (درباره بنیاد علمی - فرهنگی صبا)
**زمان**: 0.05 ms / 534.92 ms **حافظه**: -0.033 MB / 15.21 MB Application: beforeRenderModule mod_hadith (کلام ناب)
**زمان**: 2.32 ms / 537.24 ms **حافظه**: 0.021 MB / 15.23 MB Application: afterRenderModule mod_hadith (کلام ناب)
**زمان**: 0.07 ms / 537.31 ms **حافظه**: 0.004 MB / 15.23 MB Application: beforeRenderModule mod_vvisit_counter (آمار بازدیدکنندگان)
**زمان**: 4.69 ms / 542.00 ms **حافظه**: 0.227 MB / 15.46 MB Application: afterRenderModule mod_vvisit_counter (آمار بازدیدکنندگان)
**زمان**: 1.85 ms / 543.85 ms **حافظه**: 0.001 MB / 15.46 MB Application: beforeRenderModule mod_footer (Footer)
**زمان**: 0.75 ms / 544.60 ms **حافظه**: 0.010 MB / 15.47 MB Application: afterRenderModule mod_footer (Footer)
**زمان**: 8.50 ms / 553.10 ms **حافظه**: 0.078 MB / 15.55 MB Application: afterRender
**جمع پرس و جوی بانک اطلاعاتی: 82.60 ms**
16**.**53 MB (17**,**336**,**888 **بایت**)
**54 پرس و جو ثبت شده** 82.60 ms
- **زمان پرس و جو: 1.03 ms** **حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 3.841 MB** **سطرهای بازگشتی: 0**
SELECT `data`
FROM `z63bn_session`
WHERE `session_id` = X'3030386564396161306537363338343230613234613630646564313763336163'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE z63bn_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.29 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.02 ms Executing 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.15 ms Updating status 0.07 ms Reset for next command 0.02 ms # **فراخوانده** **فایل و شماره خط** 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() **به نظر می رسد خط زیر فراخونده شده باشد.** 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - **زمان پرس و جو: 0.80 ms** **پس از آخرین پرس و جو: 2.61 ms** **حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 3.944 MB** **سطرهای بازگشتی: 0**
SELECT `session_id`
FROM `z63bn_session`
WHERE `session_id` = X'3030386564396161306537363338343230613234613630646564313763336163'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE z63bn_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration Starting 0.18 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.02 ms Statistics 0.05 ms Preparing 0.02 ms Executing 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.14 ms Updating status 0.05 ms Reset for next command 0.02 ms # **فراخوانده** **فایل و شماره خط** 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - **زمان پرس و جو: 1.04 ms** **پس از آخرین پرس و جو: 0.17 ms** **حافظه پرس و جو: 0.004 MB حافظه قبل از پرس و جوی: 3.949 MB**
INSERT INTO `z63bn_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3030386564396161306537363338343230613234613630646564313763336163', 1, 1751760523, 0, '', 0)**توضیحات در جستجو ممکن نیست: INSERT INTO `z63bn_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3030386564396161306537363338343230613234613630646564313763336163', 1, 1751760523, 0, '', 0)**Status Duration Starting 0.22 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 for update 0.04 ms Update 0.18 ms Waiting for query cache lock 0.02 ms Update 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.10 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.14 ms Updating status 0.04 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - **زمان پرس و جو: 1.40 ms** **پس از آخرین پرس و جو: 4.86 ms** **حافظه پرس و جو: 0.030 MB حافظه قبل از پرس و جوی: 4.135 MB** **سطرهای بازگشتی: 39**
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `z63bn_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE z63bn_extensions ref extension extension 82 const 39 Using index condition; Using where Status Duration Starting 0.21 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.07 ms Statistics 0.11 ms Preparing 0.06 ms Executing 0.01 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.03 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.16 ms Updating status 0.07 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() **به نظر می رسد خط زیر فراخونده شده باشد.** 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 0.96 ms** **پس از آخرین پرس و جو: 5.05 ms** **حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 4.393 MB** **سطرهای بازگشتی: 5**
SELECT id, rules
FROM `z63bn_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE z63bn_viewlevels ALL NULL **کلید شاخصی برای استفاده نیست** NULL NULL 5 Status Duration Starting 0.24 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.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.06 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.04 ms Starting cleanup 0.01 ms Freeing items 0.15 ms Updating status 0.04 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.04 ms** **پس از آخرین پرس و جو: 0.20 ms** **حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 4.405 MB** **سطرهای بازگشتی: 2**
SELECT b.id
FROM z63bn_usergroups AS a
LEFT JOIN z63bn_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 Using where; Using index Status Duration Starting 0.22 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.04 ms Optimizing 0.03 ms Statistics 0.11 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.05 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.18 ms Updating status 0.05 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.74 ms** **پس از آخرین پرس و جو: 1.32 ms** **حافظه پرس و جو: 0.039 MB حافظه قبل از پرس و جوی: 4.471 MB** **سطرهای بازگشتی: 90**
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM z63bn_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE z63bn_extensions ALL extension **کلید شاخصی برای استفاده نیست** NULL NULL 226 Using where; **با استفاده از مرتب سازی فایل** Status Duration Starting 0.22 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.05 ms Optimizing 0.07 ms Statistics 0.08 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.65 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.19 ms Updating status 0.09 ms Reset for next command 0.02 ms # **فراخوانده** **فایل و شماره خط** 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() **به نظر می رسد خط زیر فراخونده شده باشد.** 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.13 ms** **پس از آخرین پرس و جو: 27.40 ms** **حافظه پرس و جو: 0.024 MB حافظه قبل از پرس و جوی: 5.400 MB** **سطرهای بازگشتی: 1****پرس و جوی تکراری**: #9
SELECT template
FROM z63bn_template_styles as s
WHERE s.client_id = 0
AND s.home = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ref idx_client_id,idx_client_id_home idx_client_id 1 const 3 Using where Status Duration Starting 0.28 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.09 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.07 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.15 ms Updating status 0.09 ms Reset for next command 0.02 ms # **فراخوانده** **فایل و شماره خط** 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 12 RokCommon_PlatformInfo_Joomla->getDefaultTemplate() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105 11 RokCommon_PlatformInfo_Joomla->setPlatformParameters() JROOT/libraries/rokcommon/RokCommon/Service.php:71 10 RokCommon_Service::getContainer() JROOT/libraries/rokcommon/include.php:38 9 require_once JROOT/libraries/rokcommon/include.php JROOT/plugins/system/rokcommon/rokcommon.php:95 8 plgSystemRokCommon->loadCommonLib() JROOT/plugins/system/rokcommon/rokcommon.php:53 7 plgSystemRokCommon->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 0.89 ms** **پس از آخرین پرس و جو: 0.12 ms** **حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 5.408 MB** **سطرهای بازگشتی: 1****پرس و جوی تکراری**: #8
SELECT template
FROM z63bn_template_styles as s
WHERE s.client_id = 0
AND s.home = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ref idx_client_id,idx_client_id_home idx_client_id 1 const 3 Using where Status Duration Starting 0.20 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.07 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.05 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.14 ms Updating status 0.04 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 13 RokCommon_PlatformInfo_Joomla->getDefaultTemplate() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67 12 RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106 11 RokCommon_PlatformInfo_Joomla->setPlatformParameters() JROOT/libraries/rokcommon/RokCommon/Service.php:71 10 RokCommon_Service::getContainer() JROOT/libraries/rokcommon/include.php:38 9 require_once JROOT/libraries/rokcommon/include.php JROOT/plugins/system/rokcommon/rokcommon.php:95 8 plgSystemRokCommon->loadCommonLib() JROOT/plugins/system/rokcommon/rokcommon.php:53 7 plgSystemRokCommon->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 0.91 ms** **پس از آخرین پرس و جو: 7.25 ms** **حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 5.698 MB** **سطرهای بازگشتی: 4**
SELECT extension, file, type
FROM z63bn_rokcommon_configs
ORDER BY priorityid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE z63bn_rokcommon_configs ALL NULL **کلید شاخصی برای استفاده نیست** NULL NULL 4 **با استفاده از مرتب سازی فایل** Status Duration Starting 0.24 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.02 ms Preparing 0.02 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 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.13 ms Updating status 0.04 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rokcommon/rokcommon.php:131 8 plgSystemRokCommon->processRegisteredConfigs() JROOT/plugins/system/rokcommon/rokcommon.php:75 7 plgSystemRokCommon->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 2.88 ms** **پس از آخرین پرس و جو: 32.47 ms** **حافظه پرس و جو: 0.029 MB حافظه قبل از پرس و جوی: 6.559 MB** **سطرهای بازگشتی: 18**
SHOW FULL COLUMNS
FROM `z63bn_extensions`**توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `z63bn_extensions`**Status Duration Starting 0.36 ms checking permissions 0.03 ms closing tables 0.02 ms checking permissions 0.05 ms Opening tables 1.04 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.04 ms Executing 0.02 ms Filling schema table 0.03 ms Opening tables 0.05 ms After opening tables 0.02 ms checking permissions 0.18 ms closing tables 0.02 ms checking permissions 0.02 ms Executing 0.01 ms Sending data 0.10 ms End of update loop 0.02 ms Query end 0.02 ms closing tables 0.01 ms Removing tmp table 0.24 ms closing tables 0.03 ms Unlocking tables 0.04 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.17 ms Updating status 0.06 ms Reset for next command 0.02 ms # **فراخوانده** **فایل و شماره خط** 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 13 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 12 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 11 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Extension.php:32 10 Joomla\CMS\Table\Extension->__construct() JROOT/libraries/src/Table/Table.php:328 9 Joomla\CMS\Table\Table::getInstance() JROOT/plugins/system/roksprocket/roksprocket.php:45 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.96 ms** **پس از آخرین پرس و جو: 1.29 ms** **حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 6.677 MB** **سطرهای بازگشتی: 1**
SELECT `extension_id`
FROM `z63bn_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE z63bn_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using where; Using index Status Duration Starting 0.27 ms checking permissions 0.05 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.18 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.07 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.84 ms Updating status 0.07 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Extension.php:124 9 Joomla\CMS\Table\Extension->find() JROOT/plugins/system/roksprocket/roksprocket.php:47 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.09 ms** **پس از آخرین پرس و جو: 0.21 ms** **حافظه پرس و جو: 0.028 MB حافظه قبل از پرس و جوی: 6.684 MB** **سطرهای بازگشتی: 1****پرس و جوی تکراری**: #15
SELECT *
FROM z63bn_extensions
WHERE `extension_id` = '10037'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE z63bn_extensions const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.29 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.02 ms Unlocking tables 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 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.17 ms Updating status 0.05 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 9 Joomla\CMS\Table\Table->load() JROOT/plugins/system/roksprocket/roksprocket.php:54 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 0.99 ms** **پس از آخرین پرس و جو: 0.18 ms** **حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 6.688 MB** **سطرهای بازگشتی: 1**
SELECT `extension_id`
FROM `z63bn_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE z63bn_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using where; Using index Status Duration Starting 0.20 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.12 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.16 ms Updating status 0.07 ms Reset for next command 0.02 ms # **فراخوانده** **فایل و شماره خط** 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Extension.php:124 9 Joomla\CMS\Table\Extension->find() JROOT/plugins/system/roksprocket/roksprocket.php:70 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 0.97 ms** **پس از آخرین پرس و جو: 0.16 ms** **حافظه پرس و جو: 0.028 MB حافظه قبل از پرس و جوی: 6.694 MB** **سطرهای بازگشتی: 1****پرس و جوی تکراری**: #13
SELECT *
FROM z63bn_extensions
WHERE `extension_id` = '10037'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE z63bn_extensions const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.21 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.05 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.02 ms Unlocking tables 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 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.18 ms Updating status 0.05 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 9 Joomla\CMS\Table\Table->load() JROOT/plugins/system/roksprocket/roksprocket.php:76 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.30 ms** **پس از آخرین پرس و جو: 35.35 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 7.229 MB**
UPDATE z63bn_vvisit_counter
SET visits=visits+1 , guests=guests+1
WHERE time=1751761200**توضیحات در جستجو ممکن نیست: UPDATE z63bn_vvisit_counter SET visits=visits+1 , guests=guests+1 WHERE time=1751761200**Status Duration Starting 0.31 ms checking permissions 0.02 ms Opening tables 0.07 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.04 ms init for update 0.11 ms Updating 0.19 ms End of update loop 0.02 ms Waiting for query cache lock 0.01 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.09 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.15 ms Updating status 0.05 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 11 JDatabaseDriverMysqli->execute() JROOT/plugins/system/vvisit_counter/vvisit_counter.php:109 10 plgSystemVVisit_Counter::_updateRecord() JROOT/plugins/system/vvisit_counter/vvisit_counter.php:75 9 plgSystemVVisit_Counter::_insertRecord() JROOT/plugins/system/vvisit_counter/vvisit_counter.php:43 8 plgSystemVVisit_Counter->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 2.57 ms** **پس از آخرین پرس و جو: 5.07 ms** **حافظه پرس و جو: 0.111 MB حافظه قبل از پرس و جوی: 7.417 MB** **سطرهای بازگشتی: 77**
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 z63bn_menu AS m
LEFT JOIN z63bn_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.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 94 Using index condition; Using where; **با استفاده از مرتب سازی فایل** 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.m.component_id 1 Using where Status Duration Starting 0.29 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.11 ms Preparing 0.07 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 1.38 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.16 ms Updating status 0.04 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() **به نظر می رسد خط زیر فراخونده شده باشد.** 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1141 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.06 ms** **پس از آخرین پرس و جو: 20.59 ms** **حافظه پرس و جو: 0.028 MB حافظه قبل از پرس و جوی: 8.271 MB** **سطرهای بازگشتی: 8**
SELECT *
FROM z63bn_rokcandy
WHERE published=1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE z63bn_rokcandy ALL NULL **کلید شاخصی برای استفاده نیست** NULL NULL 8 Using where Status Duration Starting 0.27 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.04 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.09 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.16 ms Updating status 0.06 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:27 13 RokCandyHelper::getUserMacros() **به نظر می رسد خط زیر فراخونده شده باشد.** 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 10 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:17 9 RokCandyHelper::getMacros() JROOT/plugins/system/rokcandy/rokcandy.php:28 8 plgSystemRokCandy->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.17 ms** **پس از آخرین پرس و جو: 0.46 ms** **حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 8.283 MB** **سطرهای بازگشتی: 3**
SELECT id, home, template, s.params
FROM z63bn_template_styles as s
LEFT JOIN z63bn_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 = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ref idx_template,idx_client_id,idx_client_id_home idx_client_id 1 const 3 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 sababonyad_taqawi.s.template,const 1 Using index condition; Using where Status Duration Starting 0.21 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.14 ms Preparing 0.06 ms Executing 0.01 ms Sending data 0.13 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.15 ms Updating status 0.04 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 15 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:53 14 RokCandyHelper::readIniFile() **به نظر می رسد خط زیر فراخونده شده باشد.** 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 11 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:44 10 RokCandyHelper::getTemplateOverrides() JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:18 9 RokCandyHelper::getMacros() JROOT/plugins/system/rokcandy/rokcandy.php:28 8 plgSystemRokCandy->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 0.91 ms** **پس از آخرین پرس و جو: 1.21 ms** **حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 8.308 MB** **سطرهای بازگشتی: 1**
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `z63bn_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE z63bn_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.18 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.10 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.06 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.14 ms Updating status 0.04 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() **به نظر می رسد خط زیر فراخونده شده باشد.** 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.00 ms** **پس از آخرین پرس و جو: 0.28 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 8.299 MB**
UPDATE `z63bn_extensions`
SET `params` = '{\"mediaversion\":\"93add9c34dd72bbf2c6a1a6e0266f50e\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'**توضیحات در جستجو ممکن نیست: UPDATE `z63bn_extensions` SET `params` = '{\"mediaversion\":\"93add9c34dd72bbf2c6a1a6e0266f50e\"}' WHERE `type` = 'library' AND `element` = 'joomla'**Status Duration Starting 0.18 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 for update 0.10 ms Updating 0.16 ms End of update loop 0.02 ms Waiting for query cache lock 0.01 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.08 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.17 ms Updating status 0.04 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 0.91 ms** **پس از آخرین پرس و جو: 3.91 ms** **حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 8.484 MB** **سطرهای بازگشتی: 1**
SELECT *
FROM z63bn_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE z63bn_languages ALL NULL **کلید شاخصی برای استفاده نیست** NULL NULL 2 Using where; **با استفاده از مرتب سازی فایل** 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.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 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.14 ms Updating status 0.04 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.62 ms** **پس از آخرین پرس و جو: 14.23 ms** **حافظه پرس و جو: 0.031 MB حافظه قبل از پرس و جوی: 9.047 MB** **سطرهای بازگشتی: 37**
SELECT `id`,`name`,`rules`,`parent_id`
FROM `z63bn_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rokcandy','com_rokgallery','com_roksprocket','com_search','com_tags','com_templates','com_users','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE z63bn_assets range idx_asset_name idx_asset_name 202 NULL 38 Using index condition Status Duration Starting 0.27 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.07 ms Optimizing 0.03 ms Statistics 0.18 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.51 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.15 ms Updating status 0.05 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 18 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 17 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 16 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 15 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 14 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/category.php:139 13 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 2.56 ms** **پس از آخرین پرس و جو: 0.39 ms** **حافظه پرس و جو: 0.119 MB حافظه قبل از پرس و جوی: 9.094 MB** **سطرهای بازگشتی: 813**
SELECT `id`,`name`,`rules`,`parent_id`
FROM `z63bn_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE z63bn_assets ALL idx_asset_name,idx_parent_id **کلید شاخصی برای استفاده نیست** NULL NULL 909 Using where Status Duration Starting 0.19 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.04 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.04 ms Executing 0.01 ms Sending data 1.47 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.15 ms Updating status 0.07 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 18 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 17 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 16 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 15 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 14 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/category.php:139 13 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 2.38 ms** **پس از آخرین پرس و جو: 6.40 ms** **حافظه پرس و جو: 0.037 MB حافظه قبل از پرس و جوی: 9.761 MB** **سطرهای بازگشتی: 2**
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `z63bn_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `z63bn_categories` AS `s`
INNER JOIN `z63bn_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.published = 1
AND s.id = 46
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 PRIMARY c ALL cat_idx,idx_left_right **کلید شاخصی برای استفاده نیست** NULL NULL 81 Using where; **با استفاده از مرتب سازی فایل** 2 DEPENDENT SUBQUERY i ref idx_state,idx_catid idx_catid 4 sababonyad_taqawi.c.id 6 Using index condition; Using where Status Duration Starting 0.35 ms checking permissions 0.02 ms Opening tables 0.07 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.12 ms Optimizing 0.06 ms Statistics 0.20 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.04 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.04 ms Creating sort index 0.26 ms Executing 0.01 ms Sending data 0.14 ms Executing 0.01 ms Sending data 0.27 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.01 ms Removing tmp table 0.06 ms Freeing items 0.19 ms Updating status 0.05 ms Reset for next command 0.02 ms # **فراخوانده** **فایل و شماره خط** 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 15 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 14 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/models/category.php:355 13 ContentModelCategory->getCategory() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:122 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 6.71 ms** **پس از آخرین پرس و جو: 4.20 ms** **حافظه پرس و جو: 0.406 MB حافظه قبل از پرس و جوی: 10.001 MB** **سطرهای بازگشتی: 10**
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
FROM z63bn_content AS a
LEFT JOIN z63bn_categories AS c
ON c.id = a.catid
LEFT JOIN z63bn_users AS ua
ON ua.id = a.created_by
LEFT JOIN z63bn_users AS uam
ON uam.id = a.modified_by
LEFT JOIN z63bn_categories as parent
ON parent.id = c.parent_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid = 46
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-07-06 00:08:43')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-06 00:08:43')
ORDER BY c.lft,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
LIMIT 10id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 1 SIMPLE a ref idx_access,idx_state,idx_catid idx_catid 4 const 17 Using where; **با استفاده از مرتب سازی فایل** 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.modified_by 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 const 1 Using where Status Duration Starting 1.49 ms checking permissions 0.04 ms Opening tables 0.11 ms After opening tables 0.03 ms System lock 0.03 ms table lock 0.03 ms init 0.50 ms Optimizing 0.28 ms Statistics 0.52 ms Preparing 0.03 ms Unlocking tables 0.02 ms Preparing 0.18 ms Sorting result 0.05 ms Executing 0.02 ms Sending data 0.18 ms Creating sort index 2.35 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.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.19 ms Updating status 0.04 ms Reset for next command 0.02 ms # **فراخوانده** **فایل و شماره خط** 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 16 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.36 ms** **پس از آخرین پرس و جو: 3.80 ms** **حافظه پرس و جو: 0.036 MB حافظه قبل از پرس و جوی: 10.597 MB** **سطرهای بازگشتی: 0**
SELECT `m`.`tag_id`,`t`.*
FROM `z63bn_contentitem_tag_map` AS m
INNER JOIN `z63bn_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 722
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type **کلید شاخصی برای استفاده نیست** NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 sababonyad_taqawi.m.tag_id 1 Using where Status Duration Starting 0.34 ms checking permissions 0.03 ms Opening tables 0.07 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.08 ms Optimizing 0.05 ms Statistics 0.15 ms Preparing 0.06 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.16 ms Updating status 0.05 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.65 ms** **پس از آخرین پرس و جو: 0.32 ms** **حافظه پرس و جو: 0.036 MB حافظه قبل از پرس و جوی: 10.621 MB** **سطرهای بازگشتی: 0**
SELECT `m`.`tag_id`,`t`.*
FROM `z63bn_contentitem_tag_map` AS m
INNER JOIN `z63bn_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 700
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type **کلید شاخصی برای استفاده نیست** NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 sababonyad_taqawi.m.tag_id 1 Using where Status Duration Starting 0.26 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.09 ms Optimizing 0.05 ms Statistics 0.10 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.06 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.50 ms Starting cleanup 0.01 ms Freeing items 0.17 ms Updating status 0.05 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.06 ms** **پس از آخرین پرس و جو: 0.31 ms** **حافظه پرس و جو: 0.036 MB حافظه قبل از پرس و جوی: 10.644 MB** **سطرهای بازگشتی: 0**
SELECT `m`.`tag_id`,`t`.*
FROM `z63bn_contentitem_tag_map` AS m
INNER JOIN `z63bn_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 681
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type **کلید شاخصی برای استفاده نیست** NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 sababonyad_taqawi.m.tag_id 1 Using where Status Duration Starting 0.23 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.10 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.06 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.15 ms Updating status 0.05 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.05 ms** **پس از آخرین پرس و جو: 0.30 ms** **حافظه پرس و جو: 0.036 MB حافظه قبل از پرس و جوی: 10.667 MB** **سطرهای بازگشتی: 0**
SELECT `m`.`tag_id`,`t`.*
FROM `z63bn_contentitem_tag_map` AS m
INNER JOIN `z63bn_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 679
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type **کلید شاخصی برای استفاده نیست** NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 sababonyad_taqawi.m.tag_id 1 Using where Status Duration Starting 0.22 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.06 ms Optimizing 0.05 ms Statistics 0.10 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.06 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.05 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.15 ms Updating status 0.04 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 0.95 ms** **پس از آخرین پرس و جو: 0.28 ms** **حافظه پرس و جو: 0.036 MB حافظه قبل از پرس و جوی: 10.690 MB** **سطرهای بازگشتی: 0**
SELECT `m`.`tag_id`,`t`.*
FROM `z63bn_contentitem_tag_map` AS m
INNER JOIN `z63bn_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 598
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type **کلید شاخصی برای استفاده نیست** NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 sababonyad_taqawi.m.tag_id 1 Using where Status Duration Starting 0.17 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.06 ms Optimizing 0.08 ms Statistics 0.10 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.06 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.11 ms Updating status 0.04 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.00 ms** **پس از آخرین پرس و جو: 0.27 ms** **حافظه پرس و جو: 0.036 MB حافظه قبل از پرس و جوی: 10.713 MB** **سطرهای بازگشتی: 0**
SELECT `m`.`tag_id`,`t`.*
FROM `z63bn_contentitem_tag_map` AS m
INNER JOIN `z63bn_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 503
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type **کلید شاخصی برای استفاده نیست** NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 sababonyad_taqawi.m.tag_id 1 Using where Status Duration Starting 0.23 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.10 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.06 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.11 ms Updating status 0.04 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.08 ms** **پس از آخرین پرس و جو: 0.29 ms** **حافظه پرس و جو: 0.038 MB حافظه قبل از پرس و جوی: 10.743 MB** **سطرهای بازگشتی: 0**
SELECT `m`.`tag_id`,`t`.*
FROM `z63bn_contentitem_tag_map` AS m
INNER JOIN `z63bn_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 448
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type **کلید شاخصی برای استفاده نیست** NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 sababonyad_taqawi.m.tag_id 1 Using where Status Duration Starting 0.22 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.06 ms Optimizing 0.05 ms Statistics 0.10 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.05 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.20 ms Updating status 0.04 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.05 ms** **پس از آخرین پرس و جو: 0.27 ms** **حافظه پرس و جو: 0.036 MB حافظه قبل از پرس و جوی: 10.768 MB** **سطرهای بازگشتی: 0**
SELECT `m`.`tag_id`,`t`.*
FROM `z63bn_contentitem_tag_map` AS m
INNER JOIN `z63bn_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 427
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type **کلید شاخصی برای استفاده نیست** NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 sababonyad_taqawi.m.tag_id 1 Using where Status Duration Starting 0.21 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.13 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.06 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.15 ms Updating status 0.04 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.03 ms** **پس از آخرین پرس و جو: 0.26 ms** **حافظه پرس و جو: 0.036 MB حافظه قبل از پرس و جوی: 10.791 MB** **سطرهای بازگشتی: 0**
SELECT `m`.`tag_id`,`t`.*
FROM `z63bn_contentitem_tag_map` AS m
INNER JOIN `z63bn_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 336
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type **کلید شاخصی برای استفاده نیست** NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 sababonyad_taqawi.m.tag_id 1 Using where Status Duration Starting 0.23 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.06 ms Optimizing 0.05 ms Statistics 0.10 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.06 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.15 ms Updating status 0.04 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.02 ms** **پس از آخرین پرس و جو: 0.29 ms** **حافظه پرس و جو: 0.036 MB حافظه قبل از پرس و جوی: 10.814 MB** **سطرهای بازگشتی: 0**
SELECT `m`.`tag_id`,`t`.*
FROM `z63bn_contentitem_tag_map` AS m
INNER JOIN `z63bn_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 335
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type **کلید شاخصی برای استفاده نیست** NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 sababonyad_taqawi.m.tag_id 1 Using where Status Duration Starting 0.20 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.06 ms Optimizing 0.05 ms Statistics 0.09 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.06 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.15 ms Updating status 0.07 ms Reset for next command 0.02 ms # **فراخوانده** **فایل و شماره خط** 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.24 ms** **پس از آخرین پرس و جو: 2.38 ms** **حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 10.912 MB** **سطرهای بازگشتی: 1**
SELECT COUNT(*)
FROM z63bn_content AS a
LEFT JOIN z63bn_categories AS c
ON c.id = a.catid
LEFT JOIN z63bn_users AS ua
ON ua.id = a.created_by
LEFT JOIN z63bn_users AS uam
ON uam.id = a.modified_by
LEFT JOIN z63bn_categories as parent
ON parent.id = c.parent_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid = 46
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-07-06 00:08:43')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-06 00:08:43')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 1 SIMPLE a ref idx_access,idx_state,idx_catid idx_catid 4 const 17 Using where Status Duration Starting 0.29 ms checking permissions 0.02 ms Opening tables 0.07 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.03 ms init 0.05 ms Optimizing 0.05 ms Statistics 0.17 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.11 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.11 ms Updating status 0.03 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354 16 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:289 15 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:239 14 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/components/com_content/models/category.php:265 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 0.71 ms** **پس از آخرین پرس و جو: 0.38 ms** **حافظه پرس و جو: 0.035 MB حافظه قبل از پرس و جوی: 10.921 MB** **سطرهای بازگشتی: 0**
SELECT `m`.`tag_id`,`t`.*
FROM `z63bn_contentitem_tag_map` AS m
INNER JOIN `z63bn_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 46
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type **کلید شاخصی برای استفاده نیست** NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 sababonyad_taqawi.m.tag_id 1 Using where Status Duration Starting 0.14 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.03 ms Executing 0.01 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.10 ms Updating status 0.03 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/libraries/src/MVC/View/CategoryView.php:229 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.18 ms** **پس از آخرین پرس و جو: 13.83 ms** **حافظه پرس و جو: 0.039 MB حافظه قبل از پرس و جوی: 11.437 MB** **سطرهای بازگشتی: 2**
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `z63bn_categories` AS `s`
INNER JOIN `z63bn_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 46
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right **کلید شاخصی برای استفاده نیست** NULL NULL 81 Using where; **با استفاده از مرتب سازی فایل** Status Duration Starting 0.33 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.06 ms Optimizing 0.04 ms Statistics 0.13 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.15 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.11 ms Updating status 0.03 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 2.65 ms** **پس از آخرین پرس و جو: 0.33 ms** **حافظه پرس و جو: 0.037 MB حافظه قبل از پرس و جوی: 11.455 MB** **سطرهای بازگشتی: 0**
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM z63bn_fields AS a
LEFT JOIN `z63bn_languages` AS l
ON l.lang_code = a.language
LEFT JOIN z63bn_users AS uc
ON uc.id=a.checked_out
LEFT JOIN z63bn_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN z63bn_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN z63bn_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `z63bn_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (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)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; **با استفاده از مرتب سازی فایل** 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 sababonyad_taqawi.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.37 ms checking permissions 0.02 ms Opening tables 0.08 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.13 ms Optimizing 0.05 ms Statistics 0.24 ms Preparing 0.11 ms Creating tmp table 0.15 ms Sorting result 0.04 ms Executing 0.01 ms Sending data 0.76 ms Creating sort index 0.09 ms Removing tmp table 0.12 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.07 ms Starting cleanup 0.01 ms Freeing items 0.11 ms Updating status 0.03 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.83 ms** **پس از آخرین پرس و جو: 38.88 ms** **حافظه پرس و جو: 0.041 MB حافظه قبل از پرس و جوی: 12.417 MB** **سطرهای بازگشتی: 0**
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM z63bn_fields AS a
LEFT JOIN `z63bn_languages` AS l
ON l.lang_code = a.language
LEFT JOIN z63bn_users AS uc
ON uc.id=a.checked_out
LEFT JOIN z63bn_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN z63bn_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN z63bn_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_content.categories'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; **با استفاده از مرتب سازی فایل** 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 sababonyad_taqawi.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.group_id 1 Using where Status Duration Starting 0.32 ms checking permissions 0.02 ms Opening tables 0.08 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.05 ms Statistics 0.15 ms Preparing 0.06 ms Creating tmp table 0.07 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.40 ms Creating sort index 0.05 ms Removing tmp table 0.09 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.11 ms Updating status 0.03 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 26 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 25 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 24 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 23 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 22 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 21 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 20 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 19 JEventDispatcher->trigger() JROOT/layouts/joomla/content/category_default.php:25 18 include JROOT/layouts/joomla/content/category_default.php JROOT/libraries/src/Layout/FileLayout.php:125 17 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 16 Joomla\CMS\Layout\LayoutHelper::render() JROOT/templates/imh_saba/warp/systems/joomla/layouts/com_content/category/default.php:19 15 include JROOT/templates/imh_saba/warp/systems/joomla/layouts/com_content/category/default.php JROOT/templates/imh_saba/html/com_content/category/default.php:12 14 include JROOT/templates/imh_saba/html/com_content/category/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 11 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.59 ms** **پس از آخرین پرس و جو: 1.12 ms** **حافظه پرس و جو: 0.041 MB حافظه قبل از پرس و جوی: 12.441 MB** **سطرهای بازگشتی: 0**
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM z63bn_fields AS a
LEFT JOIN `z63bn_languages` AS l
ON l.lang_code = a.language
LEFT JOIN z63bn_users AS uc
ON uc.id=a.checked_out
LEFT JOIN z63bn_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN z63bn_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN z63bn_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `z63bn_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.categories'
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)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; **با استفاده از مرتب سازی فایل** 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 sababonyad_taqawi.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.22 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.01 ms init 0.06 ms Optimizing 0.07 ms Statistics 0.12 ms Preparing 0.05 ms Creating tmp table 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.37 ms Creating sort index 0.04 ms Removing tmp table 0.08 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.13 ms Updating status 0.03 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 28 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 27 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 26 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 25 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 24 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 23 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:404 22 PlgSystemFields->display() JROOT/plugins/system/fields/fields.php:324 21 PlgSystemFields->onContentAfterTitle() JROOT/libraries/joomla/event/event.php:70 20 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 19 JEventDispatcher->trigger() JROOT/layouts/joomla/content/category_default.php:28 18 include JROOT/layouts/joomla/content/category_default.php JROOT/libraries/src/Layout/FileLayout.php:125 17 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 16 Joomla\CMS\Layout\LayoutHelper::render() JROOT/templates/imh_saba/warp/systems/joomla/layouts/com_content/category/default.php:19 15 include JROOT/templates/imh_saba/warp/systems/joomla/layouts/com_content/category/default.php JROOT/templates/imh_saba/html/com_content/category/default.php:12 14 include JROOT/templates/imh_saba/html/com_content/category/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 11 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 2.15 ms** **پس از آخرین پرس و جو: 31.01 ms** **حافظه پرس و جو: 0.031 MB حافظه قبل از پرس و جوی: 13.416 MB** **سطرهای بازگشتی: 15**
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM z63bn_modules AS m
LEFT JOIN z63bn_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN z63bn_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-07-06 00:08:43')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-07-06 00:08:43')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 126 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 26 Using index condition; Using where; **با استفاده از مرتب سازی فایل** 1 SIMPLE mm ref PRIMARY PRIMARY 4 sababonyad_taqawi.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 sababonyad_taqawi.m.module,const 1 Using index condition; Using where Status Duration Starting 0.36 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.02 ms init 0.09 ms Optimizing 0.08 ms Statistics 0.19 ms Preparing 0.10 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.65 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.05 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.17 ms Updating status 0.05 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() **به نظر می رسد خط زیر فراخونده شده باشد.** 17 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 16 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 15 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 14 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 13 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 12 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:49 11 ModulesWarpHelper->count() JROOT/templates/imh_saba/layouts/template.config.php:155 10 include JROOT/templates/imh_saba/layouts/template.config.php JROOT/templates/imh_saba/layouts/template.php:10 9 include JROOT/templates/imh_saba/layouts/template.php JROOT/templates/imh_saba/warp/helpers/template.php:49 8 TemplateWarpHelper->render() JROOT/templates/imh_saba/index.php:19 7 require JROOT/templates/imh_saba/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 3.94 ms** **پس از آخرین پرس و جو: 65.40 ms** **حافظه پرس و جو: 0.089 MB حافظه قبل از پرس و جوی: 14.525 MB** **سطرهای بازگشتی: 3**
SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title
FROM z63bn_content as a
LEFT JOIN z63bn_categories AS c
ON c.id = a.catid
LEFT JOIN z63bn_users AS ua
ON ua.id = a.created_by
LEFT JOIN z63bn_users AS um
ON um.id = a.modified_by
LEFT JOIN z63bn_content_rating AS v
ON a.id = v.content_id
LEFT JOIN z63bn_viewlevels AS vl
ON a.access = vl.id
LEFT JOIN z63bn_languages AS l
ON a.language = l.lang_code
LEFT JOIN z63bn_contentitem_tag_map AS ct
ON ct.content_item_id = a.id
LEFT JOIN z63bn_tags AS t
ON t.id = ct.tag_id
WHERE ((a.access IN(1,1,5)
AND (a.state = 1 or a.state = 2)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-07-06 00:08:43')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-06 00:08:43')
AND (a.state != -2))
AND a.id IN (654,653,651))
GROUP BY id
LIMIT 3id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a range PRIMARY,idx_access,idx_state PRIMARY 4 NULL 3 Using where; Using temporary; **با استفاده از مرتب سازی فایل** 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.catid 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.created_by 1 Using where 1 SIMPLE um eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.modified_by 1 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.id 1 Using where 1 SIMPLE vl eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.access 1 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 sababonyad_taqawi.a.language 1 Using where 1 SIMPLE ct index NULL idx_core_content_id 4 NULL 1 Using where; Using index; Using join buffer (flat, BNL join) Status Duration Starting 0.50 ms checking permissions 0.02 ms Opening tables 0.17 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms init 0.14 ms Optimizing 0.09 ms Statistics 0.36 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.07 ms Creating tmp table 0.13 ms Sorting result 0.05 ms Executing 0.01 ms Sending data 1.12 ms Creating sort index 0.46 ms Removing tmp table 0.21 ms Creating sort index 0.03 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.02 ms Starting cleanup 0.01 ms Freeing items 0.17 ms Updating status 0.05 ms Reset for next command 0.02 ms # **فراخوانده** **فایل و شماره خط** 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:58 23 RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems() JROOT/components/com_roksprocket/lib/RokSprocket.php:294 22 RokSprocket::getItems() JROOT/components/com_roksprocket/lib/RokSprocket.php:230 21 RokSprocket::getItemsWithParams() JROOT/components/com_roksprocket/lib/RokSprocket.php:55 20 RokSprocket->getData() JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52 19 ModRokSprocket->_realGetData() JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80 18 RokSprocket_PlatformHelper_Joomla->getFromCache() JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37 17 ModRokSprocket->getData() JROOT/modules/mod_roksprocket/mod_roksprocket.php:38 16 include JROOT/modules/mod_roksprocket/mod_roksprocket.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:86 13 ModulesWarpHelper->load() JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php:10 12 include JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php JROOT/templates/imh_saba/warp/helpers/template.php:49 11 TemplateWarpHelper->render() JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:64 10 ModulesWarpHelper->render() JROOT/templates/imh_saba/layouts/template.php:145 9 include JROOT/templates/imh_saba/layouts/template.php JROOT/templates/imh_saba/warp/helpers/template.php:49 8 TemplateWarpHelper->render() JROOT/templates/imh_saba/index.php:19 7 require JROOT/templates/imh_saba/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 0.92 ms** **پس از آخرین پرس و جو: 2.04 ms** **حافظه پرس و جو: 0.030 MB حافظه قبل از پرس و جوی: 14.618 MB** **سطرهای بازگشتی: 0**
SELECT ct.content_item_id as article_id, t.title as tag
FROM z63bn_contentitem_tag_map as ct
LEFT JOIN z63bn_tags AS t
ON t.id = ct.tag_id
WHERE ct.content_item_id in (651,653,654)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ct index NULL idx_core_content_id 4 NULL 1 Using where; Using index 1 SIMPLE t eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.ct.tag_id 1 Status Duration Starting 0.23 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.03 ms Statistics 0.05 ms Preparing 0.05 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.14 ms Updating status 0.04 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 26 JDatabaseDriver->loadAssocList() JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/TagMerge.php:26 25 RokSprocket_Provider_Joomla_TagMerge->populateTags() JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla.php:159 24 RokSprocket_Provider_Joomla->populateTags() JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:62 23 RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems() JROOT/components/com_roksprocket/lib/RokSprocket.php:294 22 RokSprocket::getItems() JROOT/components/com_roksprocket/lib/RokSprocket.php:230 21 RokSprocket::getItemsWithParams() JROOT/components/com_roksprocket/lib/RokSprocket.php:55 20 RokSprocket->getData() JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52 19 ModRokSprocket->_realGetData() JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80 18 RokSprocket_PlatformHelper_Joomla->getFromCache() JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37 17 ModRokSprocket->getData() JROOT/modules/mod_roksprocket/mod_roksprocket.php:38 16 include JROOT/modules/mod_roksprocket/mod_roksprocket.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:86 13 ModulesWarpHelper->load() JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php:10 12 include JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php JROOT/templates/imh_saba/warp/helpers/template.php:49 11 TemplateWarpHelper->render() JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:64 10 ModulesWarpHelper->render() JROOT/templates/imh_saba/layouts/template.php:145 9 include JROOT/templates/imh_saba/layouts/template.php JROOT/templates/imh_saba/warp/helpers/template.php:49 8 TemplateWarpHelper->render() JROOT/templates/imh_saba/index.php:19 7 require JROOT/templates/imh_saba/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.50 ms** **پس از آخرین پرس و جو: 4.04 ms** **حافظه پرس و جو: 0.047 MB حافظه قبل از پرس و جوی: 14.820 MB** **سطرهای بازگشتی: 2**
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `z63bn_categories` AS `s`
INNER JOIN `z63bn_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 54
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right **کلید شاخصی برای استفاده نیست** NULL NULL 81 Using where; **با استفاده از مرتب سازی فایل** Status Duration Starting 0.31 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.09 ms Optimizing 0.05 ms Statistics 0.17 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 0.21 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.18 ms Updating status 0.04 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 39 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 38 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 37 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 36 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 35 ContentRouter->getCategorySegment() **به نظر می رسد خط زیر فراخونده شده باشد.** 34 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 33 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 32 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 31 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 30 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 29 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 28 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 27 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 26 Joomla\CMS\Router\Route::_() JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla.php:93 25 RokSprocket_Provider_Joomla->convertRawToItem() JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:83 24 RokSprocket_Provider_AbstarctJoomlaBasedProvider->convertRawToItems() JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:63 23 RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems() JROOT/components/com_roksprocket/lib/RokSprocket.php:294 22 RokSprocket::getItems() JROOT/components/com_roksprocket/lib/RokSprocket.php:230 21 RokSprocket::getItemsWithParams() JROOT/components/com_roksprocket/lib/RokSprocket.php:55 20 RokSprocket->getData() JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52 19 ModRokSprocket->_realGetData() JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80 18 RokSprocket_PlatformHelper_Joomla->getFromCache() JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37 17 ModRokSprocket->getData() JROOT/modules/mod_roksprocket/mod_roksprocket.php:38 16 include JROOT/modules/mod_roksprocket/mod_roksprocket.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:86 13 ModulesWarpHelper->load() JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php:10 12 include JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php JROOT/templates/imh_saba/warp/helpers/template.php:49 11 TemplateWarpHelper->render() JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:64 10 ModulesWarpHelper->render() JROOT/templates/imh_saba/layouts/template.php:145 9 include JROOT/templates/imh_saba/layouts/template.php JROOT/templates/imh_saba/warp/helpers/template.php:49 8 TemplateWarpHelper->render() JROOT/templates/imh_saba/index.php:19 7 require JROOT/templates/imh_saba/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.43 ms** **پس از آخرین پرس و جو: 0.82 ms** **حافظه پرس و جو: 0.047 MB حافظه قبل از پرس و جوی: 14.847 MB** **سطرهای بازگشتی: 2**
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `z63bn_categories` AS `s`
INNER JOIN `z63bn_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 53
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right **کلید شاخصی برای استفاده نیست** NULL NULL 81 Using where; **با استفاده از مرتب سازی فایل** Status Duration Starting 0.29 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.08 ms Optimizing 0.05 ms Statistics 0.16 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 0.23 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.15 ms Updating status 0.04 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 39 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 38 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 37 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 36 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 35 ContentRouter->getCategorySegment() **به نظر می رسد خط زیر فراخونده شده باشد.** 34 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 33 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 32 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 31 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 30 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 29 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 28 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 27 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 26 Joomla\CMS\Router\Route::_() JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla.php:93 25 RokSprocket_Provider_Joomla->convertRawToItem() JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:83 24 RokSprocket_Provider_AbstarctJoomlaBasedProvider->convertRawToItems() JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:63 23 RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems() JROOT/components/com_roksprocket/lib/RokSprocket.php:294 22 RokSprocket::getItems() JROOT/components/com_roksprocket/lib/RokSprocket.php:230 21 RokSprocket::getItemsWithParams() JROOT/components/com_roksprocket/lib/RokSprocket.php:55 20 RokSprocket->getData() JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52 19 ModRokSprocket->_realGetData() JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80 18 RokSprocket_PlatformHelper_Joomla->getFromCache() JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37 17 ModRokSprocket->getData() JROOT/modules/mod_roksprocket/mod_roksprocket.php:38 16 include JROOT/modules/mod_roksprocket/mod_roksprocket.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:86 13 ModulesWarpHelper->load() JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php:10 12 include JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php JROOT/templates/imh_saba/warp/helpers/template.php:49 11 TemplateWarpHelper->render() JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:64 10 ModulesWarpHelper->render() JROOT/templates/imh_saba/layouts/template.php:145 9 include JROOT/templates/imh_saba/layouts/template.php JROOT/templates/imh_saba/warp/helpers/template.php:49 8 TemplateWarpHelper->render() JROOT/templates/imh_saba/index.php:19 7 require JROOT/templates/imh_saba/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 0.89 ms** **پس از آخرین پرس و جو: 0.74 ms** **حافظه پرس و جو: 0.031 MB حافظه قبل از پرس و جوی: 14.870 MB** **سطرهای بازگشتی: 3**
SELECT i.provider_id as id, i.
order, i.params
FROM z63bn_roksprocket_items as i
WHERE i.module_id = '97'
AND i.provider = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i ref idx_module,idx_module_order idx_module 137 const 3 Using index condition; Using where Status Duration Starting 0.18 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.07 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.07 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.13 ms Updating status 0.07 ms Reset for next command 0.02 ms # **فراخوانده** **فایل و شماره خط** 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 25 JDatabaseDriver->loadObjectList() JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:139 24 RokSprocket_Provider_AbstarctJoomlaBasedProvider->mapPerItemData() JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:64 23 RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems() JROOT/components/com_roksprocket/lib/RokSprocket.php:294 22 RokSprocket::getItems() JROOT/components/com_roksprocket/lib/RokSprocket.php:230 21 RokSprocket::getItemsWithParams() JROOT/components/com_roksprocket/lib/RokSprocket.php:55 20 RokSprocket->getData() JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52 19 ModRokSprocket->_realGetData() JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80 18 RokSprocket_PlatformHelper_Joomla->getFromCache() JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37 17 ModRokSprocket->getData() JROOT/modules/mod_roksprocket/mod_roksprocket.php:38 16 include JROOT/modules/mod_roksprocket/mod_roksprocket.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:86 13 ModulesWarpHelper->load() JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php:10 12 include JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php JROOT/templates/imh_saba/warp/helpers/template.php:49 11 TemplateWarpHelper->render() JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:64 10 ModulesWarpHelper->render() JROOT/templates/imh_saba/layouts/template.php:145 9 include JROOT/templates/imh_saba/layouts/template.php JROOT/templates/imh_saba/warp/helpers/template.php:49 8 TemplateWarpHelper->render() JROOT/templates/imh_saba/index.php:19 7 require JROOT/templates/imh_saba/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.81 ms** **پس از آخرین پرس و جو: 30.65 ms** **حافظه پرس و جو: 0.042 MB حافظه قبل از پرس و جوی: 15.159 MB** **سطرهای بازگشتی: 1**
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
FROM z63bn_content AS a
LEFT JOIN z63bn_categories AS c
ON c.id = a.catid
LEFT JOIN z63bn_users AS ua
ON ua.id = a.created_by
LEFT JOIN z63bn_users AS uam
ON uam.id = a.modified_by
LEFT JOIN z63bn_categories as parent
ON parent.id = c.parent_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid IN (65)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-07-06 00:08:43')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-06 00:08:43')
ORDER BY a.publish_up DESC
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 1 SIMPLE a ref idx_access,idx_state,idx_catid idx_catid 4 const 1 Using where; **با استفاده از مرتب سازی فایل** 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.modified_by 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 const 1 Using where Status Duration Starting 0.46 ms checking permissions 0.02 ms Opening tables 0.07 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.13 ms Optimizing 0.09 ms Statistics 0.20 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.07 ms Creating sort index 0.16 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.16 ms Updating status 0.05 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 20 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 19 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 18 ContentModelArticles->getItems() JROOT/modules/mod_articles_news/helper.php:100 17 ModArticlesNewsHelper::getList() JROOT/modules/mod_articles_news/mod_articles_news.php:15 16 include JROOT/modules/mod_articles_news/mod_articles_news.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:86 13 ModulesWarpHelper->load() JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php:10 12 include JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php JROOT/templates/imh_saba/warp/helpers/template.php:49 11 TemplateWarpHelper->render() JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:64 10 ModulesWarpHelper->render() JROOT/templates/imh_saba/layouts/template.php:218 9 include JROOT/templates/imh_saba/layouts/template.php JROOT/templates/imh_saba/warp/helpers/template.php:49 8 TemplateWarpHelper->render() JROOT/templates/imh_saba/index.php:19 7 require JROOT/templates/imh_saba/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.50 ms** **پس از آخرین پرس و جو: 0.59 ms** **حافظه پرس و جو: 0.043 MB حافظه قبل از پرس و جوی: 15.208 MB** **سطرهای بازگشتی: 2**
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `z63bn_categories` AS `s`
INNER JOIN `z63bn_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 65
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right **کلید شاخصی برای استفاده نیست** NULL NULL 81 Using where; **با استفاده از مرتب سازی فایل** Status Duration Starting 0.28 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.08 ms Optimizing 0.05 ms Statistics 0.18 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.05 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.07 ms Creating sort index 0.21 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.19 ms Updating status 0.06 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 31 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 30 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 29 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 28 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 27 ContentRouter->getCategorySegment() **به نظر می رسد خط زیر فراخونده شده باشد.** 26 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 25 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 24 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 23 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 22 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 21 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 20 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 19 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 18 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_news/helper.php:113 17 ModArticlesNewsHelper::getList() JROOT/modules/mod_articles_news/mod_articles_news.php:15 16 include JROOT/modules/mod_articles_news/mod_articles_news.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:86 13 ModulesWarpHelper->load() JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php:10 12 include JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php JROOT/templates/imh_saba/warp/helpers/template.php:49 11 TemplateWarpHelper->render() JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:64 10 ModulesWarpHelper->render() JROOT/templates/imh_saba/layouts/template.php:218 9 include JROOT/templates/imh_saba/layouts/template.php JROOT/templates/imh_saba/warp/helpers/template.php:49 8 TemplateWarpHelper->render() JROOT/templates/imh_saba/index.php:19 7 require JROOT/templates/imh_saba/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 2.32 ms** **پس از آخرین پرس و جو: 0.56 ms** **حافظه پرس و جو: 0.042 MB حافظه قبل از پرس و جوی: 15.231 MB** **سطرهای بازگشتی: 0**
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM z63bn_fields AS a
LEFT JOIN `z63bn_languages` AS l
ON l.lang_code = a.language
LEFT JOIN z63bn_users AS uc
ON uc.id=a.checked_out
LEFT JOIN z63bn_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN z63bn_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN z63bn_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'mod_articles_news.content'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; **با استفاده از مرتب سازی فایل** 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 sababonyad_taqawi.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.group_id 1 Using where Status Duration Starting 0.30 ms checking permissions 0.02 ms Opening tables 0.07 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.23 ms Preparing 0.10 ms Creating tmp table 0.11 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.64 ms Creating sort index 0.09 ms Removing tmp table 0.14 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.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.16 ms Updating status 0.04 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 30 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 29 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 28 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 27 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 26 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 25 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 24 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 23 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 22 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 21 JHtmlContent::prepare() **به نظر می رسد خط زیر فراخونده شده باشد.** 20 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 19 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111 18 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_articles_news/helper.php:123 17 ModArticlesNewsHelper::getList() JROOT/modules/mod_articles_news/mod_articles_news.php:15 16 include JROOT/modules/mod_articles_news/mod_articles_news.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:86 13 ModulesWarpHelper->load() JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php:10 12 include JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php JROOT/templates/imh_saba/warp/helpers/template.php:49 11 TemplateWarpHelper->render() JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:64 10 ModulesWarpHelper->render() JROOT/templates/imh_saba/layouts/template.php:218 9 include JROOT/templates/imh_saba/layouts/template.php JROOT/templates/imh_saba/warp/helpers/template.php:49 8 TemplateWarpHelper->render() JROOT/templates/imh_saba/index.php:19 7 require JROOT/templates/imh_saba/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 2.19 ms** **پس از آخرین پرس و جو: 0.81 ms** **حافظه پرس و جو: 0.041 MB حافظه قبل از پرس و جوی: 15.247 MB** **سطرهای بازگشتی: 0**
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM z63bn_fields AS a
LEFT JOIN `z63bn_languages` AS l
ON l.lang_code = a.language
LEFT JOIN z63bn_users AS uc
ON uc.id=a.checked_out
LEFT JOIN z63bn_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN z63bn_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN z63bn_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `z63bn_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (65,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)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; **با استفاده از مرتب سازی فایل** 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 sababonyad_taqawi.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 sababonyad_taqawi.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.31 ms checking permissions 0.02 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.10 ms Optimizing 0.07 ms Statistics 0.21 ms Preparing 0.08 ms Creating tmp table 0.09 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.57 ms Creating sort index 0.08 ms Removing tmp table 0.12 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.16 ms Updating status 0.04 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 26 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 25 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 24 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 23 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 22 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 21 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 20 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 19 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 18 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/modules/mod_articles_news/helper.php:164 17 ModArticlesNewsHelper::getList() JROOT/modules/mod_articles_news/mod_articles_news.php:15 16 include JROOT/modules/mod_articles_news/mod_articles_news.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:86 13 ModulesWarpHelper->load() JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php:10 12 include JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php JROOT/templates/imh_saba/warp/helpers/template.php:49 11 TemplateWarpHelper->render() JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:64 10 ModulesWarpHelper->render() JROOT/templates/imh_saba/layouts/template.php:218 9 include JROOT/templates/imh_saba/layouts/template.php JROOT/templates/imh_saba/warp/helpers/template.php:49 8 TemplateWarpHelper->render() JROOT/templates/imh_saba/index.php:19 7 require JROOT/templates/imh_saba/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 1.60 ms** **پس از آخرین پرس و جو: 1.76 ms** **حافظه پرس و جو: 0.029 MB حافظه قبل از پرس و جوی: 15.232 MB** **سطرهای بازگشتی: 14**
SELECT *,RAND() AS r
FROM z63bn_hadith
WHERE not(id=0)
ORDER BY rid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE z63bn_hadith ALL PRIMARY **کلید شاخصی برای استفاده نیست** NULL NULL 14 Using where; Using temporary; **با استفاده از مرتب سازی فایل** Status Duration Starting 0.19 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.03 ms Preparing 0.02 ms Creating tmp table 0.04 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.44 ms Creating sort index 0.21 ms End of update loop 0.01 ms Removing tmp table 0.12 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.14 ms Updating status 0.04 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 17 JDatabaseDriver->loadObject() JROOT/modules/mod_hadith/mod_hadith.php:24 16 include JROOT/modules/mod_hadith/mod_hadith.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:86 13 ModulesWarpHelper->load() JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php:10 12 include JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php JROOT/templates/imh_saba/warp/helpers/template.php:49 11 TemplateWarpHelper->render() JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:64 10 ModulesWarpHelper->render() JROOT/templates/imh_saba/layouts/template.php:218 9 include JROOT/templates/imh_saba/layouts/template.php JROOT/templates/imh_saba/warp/helpers/template.php:49 8 TemplateWarpHelper->render() JROOT/templates/imh_saba/index.php:19 7 require JROOT/templates/imh_saba/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **زمان پرس و جو: 0.89 ms** **پس از آخرین پرس و جو: 1.81 ms** **حافظه پرس و جو: 0.027 MB حافظه قبل از پرس و جوی: 15.390 MB** **سطرهای بازگشتی: 1**
SELECT SUM(visits) AS visits
FROM z63bn_vvisit_counter
WHERE time > 1751760000id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE z63bn_vvisit_counter range PRIMARY,time PRIMARY 4 NULL 1 Using where Status Duration Starting 0.19 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.04 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.10 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.05 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.14 ms Updating status 0.04 ms Reset for next command 0.01 ms # **فراخوانده** **فایل و شماره خط** 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/plugins/system/vvisit_counter/helper/vvisit_counter.php:153 17 plgVVisitCounterHelper::getVisitsByType() JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:138 16 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:86 13 ModulesWarpHelper->load() JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php:10 12 include JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php JROOT/templates/imh_saba/warp/helpers/template.php:49 11 TemplateWarpHelper->render() JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:64 10 ModulesWarpHelper->render() JROOT/templates/imh_saba/layouts/template.php:218 9 include JROOT/templates/imh_saba/layouts/template.php JROOT/templates/imh_saba/warp/helpers/template.php:49 8 TemplateWarpHelper->render() JROOT/templates/imh_saba/index.php:19 7 require JROOT/templates/imh_saba/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
**32 نوع پرس و جو ثبت شده**
**انتخاب جداول:**
**11 × SELECT `m`.`tag_id`,`t`.*
FROM `z63bn_contentitem_tag_map` AS m
INNER JOIN `z63bn_tags` AS t
ON `m`.`tag_id` = `t`.`id`****4 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `z63bn_categories` AS `s`
INNER JOIN `z63bn_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)****3 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM z63bn_fields AS a
LEFT JOIN `z63bn_languages` AS l
ON l.lang_code = a.language
LEFT JOIN z63bn_users AS uc
ON uc.id=a.checked_out
LEFT JOIN z63bn_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN z63bn_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN z63bn_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `z63bn_fields_categories` AS fc
ON fc.field_id = a.id****2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `z63bn_assets`****2 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
FROM z63bn_content AS a
LEFT JOIN z63bn_categories AS c
ON c.id = a.catid
LEFT JOIN z63bn_users AS ua
ON ua.id = a.created_by
LEFT JOIN z63bn_users AS uam
ON uam.id = a.modified_by
LEFT JOIN z63bn_categories as parent
ON parent.id = c.parent_id****2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `z63bn_extensions`****2 × SELECT template
FROM z63bn_template_styles as s****2 × SELECT `extension_id`
FROM `z63bn_extensions`****2 × SELECT *
FROM z63bn_extensions****2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM z63bn_fields AS a
LEFT JOIN `z63bn_languages` AS l
ON l.lang_code = a.language
LEFT JOIN z63bn_users AS uc
ON uc.id=a.checked_out
LEFT JOIN z63bn_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN z63bn_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN z63bn_fields_groups AS g
ON g.id = a.group_id****1 × SELECT *,RAND() AS r
FROM z63bn_hadith****1 × SELECT i.provider_id as id, i.
order, i.params
FROM z63bn_roksprocket_items as i****1 × SELECT ct.content_item_id as article_id, t.title as tag
FROM z63bn_contentitem_tag_map as ct
LEFT JOIN z63bn_tags AS t
ON t.id = ct.tag_id****1 × SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title
FROM z63bn_content as a
LEFT JOIN z63bn_categories AS c
ON c.id = a.catid
LEFT JOIN z63bn_users AS ua
ON ua.id = a.created_by
LEFT JOIN z63bn_users AS um
ON um.id = a.modified_by
LEFT JOIN z63bn_content_rating AS v
ON a.id = v.content_id
LEFT JOIN z63bn_viewlevels AS vl
ON a.access = vl.id
LEFT JOIN z63bn_languages AS l
ON a.language = l.lang_code
LEFT JOIN z63bn_contentitem_tag_map AS ct
ON ct.content_item_id = a.id
LEFT JOIN z63bn_tags AS t
ON t.id = ct.tag_id****1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM z63bn_modules AS m
LEFT JOIN z63bn_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN z63bn_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id****1 × SELECT COUNT(*)
FROM z63bn_content AS a
LEFT JOIN z63bn_categories AS c
ON c.id = a.catid
LEFT JOIN z63bn_users AS ua
ON ua.id = a.created_by
LEFT JOIN z63bn_users AS uam
ON uam.id = a.modified_by
LEFT JOIN z63bn_categories as parent
ON parent.id = c.parent_id****1 × SELECT `data`
FROM `z63bn_session`****1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `z63bn_content` AS `i`****1 × SELECT `session_id`
FROM `z63bn_session`****1 × SELECT *
FROM z63bn_languages****1 × SELECT id, home, template, s.params
FROM z63bn_template_styles as s
LEFT JOIN z63bn_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id****1 × SELECT *
FROM z63bn_rokcandy****1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM z63bn_menu AS m
LEFT JOIN z63bn_extensions AS e
ON m.component_id = e.extension_id****1 × SELECT extension, file, type
FROM z63bn_rokcommon_configs****1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM z63bn_extensions****1 × SELECT b.id
FROM z63bn_usergroups AS a
LEFT JOIN z63bn_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt****1 × SELECT id, rules
FROM `z63bn_viewlevels****1 × SELECT SUM(visits) AS visits
FROM z63bn_vvisit_counter**
**سایر جداول:**
**1 × INSERT INTO `z63bn_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3030386564396161306537363338343230613234613630646564313763336163', 1, 1751760523, 0, '', 0****1 × SHOW FULL COLUMNS
FROM `z63bn_extensions****1 × UPDATE z63bn_vvisit_counter
SET visits=visits+1 , guests=guests+1****1 × UPDATE `z63bn_extensions`
SET `params` = '{\"mediaversion\":\"93add9c34dd72bbf2c6a1a6e0266f50e\"}'**
**هیچکدام**
- **بار شده** : JROOT/language/fa-IR/fa-IR.ini
- **بار شده** : JROOT/language/fa-IR/fa-IR.lib_joomla.ini
- **بار شده** : JROOT/administrator/language/fa-IR/fa-IR.plg_system_updatenotification.ini
- **بار شده** : JROOT/administrator/language/fa-IR/fa-IR.plg_system_fields.ini
- **بار شده** : JROOT/administrator/language/fa-IR/fa-IR.plg_system_logrotation.ini
- **بار شده** : JROOT/administrator/language/fa-IR/fa-IR.plg_system_logout.ini
- **بار نشده** : JROOT/language/fa-IR/fa-IR.tpl_imh_saba.ini
- **بار نشده** : JROOT/language/fa-IR/tpl_imh_saba.ini
- **بار نشده** : JROOT/templates/imh_saba/language/fa-IR/fa-IR.tpl_imh_saba.ini
- **بار نشده** : JROOT/templates/imh_saba/language/fa-IR/tpl_imh_saba.ini
- **بار شده** : JROOT/language/fa-IR/fa-IR.com_content.ini
- **بار نشده** : JROOT/administrator/language/fa-IR/fa-IR.plg_content_jw_allvideos.ini
- **بار نشده** : JROOT/administrator/language/fa-IR/plg_content_jw_allvideos.ini
- **بار نشده** : JROOT/plugins/content/jw_allvideos/language/fa-IR/fa-IR.plg_content_jw_allvideos.ini
- **بار نشده** : JROOT/plugins/content/jw_allvideos/language/fa-IR/plg_content_jw_allvideos.ini
- **بار شده** : JROOT/templates/imh_saba/warp/systems/joomla/language/fa-IR/fa-IR.tpl_warp.ini
- **بار شده** : JROOT/language/fa-IR/fa-IR.mod_menu.ini
- **بار نشده** : JROOT/language/fa-IR/fa-IR.mod_roksprocket.ini
- **بار نشده** : JROOT/language/fa-IR/mod_roksprocket.ini
- **بار نشده** : JROOT/modules/mod_roksprocket/language/fa-IR/fa-IR.mod_roksprocket.ini
- **بار نشده** : JROOT/modules/mod_roksprocket/language/fa-IR/mod_roksprocket.ini
- **بار نشده** : JROOT/language/en-GB/en-GB.com_roksprocket.ini
- **بار نشده** : JROOT/language/en-GB/com_roksprocket.ini
- **بار نشده** : JROOT/language/fa-IR/fa-IR.com_roksprocket.ini
- **بار نشده** : JROOT/language/fa-IR/com_roksprocket.ini
- **بار شده** : JROOT/components/com_roksprocket/language/en-GB/en-GB.com_roksprocket.ini
- **بار شده** : JROOT/components/com_roksprocket/language/fa-IR/fa-IR.com_roksprocket.ini
- **بار شده** : JROOT/components/com_roksprocket/layouts/lists/language/en-GB/en-GB.roksprocket_layout_lists.ini
- **بار نشده** : JROOT/components/com_roksprocket/layouts/lists/language/fa-IR/fa-IR.roksprocket_layout_lists.ini
- **بار نشده** : JROOT/components/com_roksprocket/layouts/lists/language/fa-IR/roksprocket_layout_lists.ini
- **بار شده** : JROOT/components/com_roksprocket/layouts/headlines/language/en-GB/en-GB.roksprocket_layout_headlines.ini
- **بار نشده** : JROOT/components/com_roksprocket/layouts/headlines/language/fa-IR/fa-IR.roksprocket_layout_headlines.ini
- **بار نشده** : JROOT/components/com_roksprocket/layouts/headlines/language/fa-IR/roksprocket_layout_headlines.ini
- **بار شده** : JROOT/components/com_roksprocket/layouts/sliders/language/en-GB/en-GB.roksprocket_layout_sliders.ini
- **بار نشده** : JROOT/components/com_roksprocket/layouts/sliders/language/fa-IR/fa-IR.roksprocket_layout_sliders.ini
- **بار نشده** : JROOT/components/com_roksprocket/layouts/sliders/language/fa-IR/roksprocket_layout_sliders.ini
- **بار شده** : JROOT/components/com_roksprocket/layouts/mosaic/language/en-GB/en-GB.roksprocket_layout_mosaic.ini
- **بار شده** : JROOT/components/com_roksprocket/layouts/mosaic/language/fa-IR/fa-IR.roksprocket_layout_mosaic.ini
- **بار شده** : JROOT/components/com_roksprocket/layouts/quotes/language/en-GB/en-GB.roksprocket_layout_quotes.ini
- **بار نشده** : JROOT/components/com_roksprocket/layouts/quotes/language/fa-IR/fa-IR.roksprocket_layout_quotes.ini
- **بار نشده** : JROOT/components/com_roksprocket/layouts/quotes/language/fa-IR/roksprocket_layout_quotes.ini
- **بار شده** : JROOT/components/com_roksprocket/layouts/tabs/language/en-GB/en-GB.roksprocket_layout_tabs.ini
- **بار نشده** : JROOT/components/com_roksprocket/layouts/tabs/language/fa-IR/fa-IR.roksprocket_layout_tabs.ini
- **بار نشده** : JROOT/components/com_roksprocket/layouts/tabs/language/fa-IR/roksprocket_layout_tabs.ini
- **بار شده** : JROOT/components/com_roksprocket/layouts/features/language/en-GB/en-GB.roksprocket_layout_features.ini
- **بار نشده** : JROOT/components/com_roksprocket/layouts/features/language/fa-IR/fa-IR.roksprocket_layout_features.ini
- **بار نشده** : JROOT/components/com_roksprocket/layouts/features/language/fa-IR/roksprocket_layout_features.ini
- **بار شده** : JROOT/components/com_roksprocket/layouts/tables/language/en-GB/en-GB.roksprocket_layout_tables.ini
- **بار نشده** : JROOT/components/com_roksprocket/layouts/tables/language/fa-IR/fa-IR.roksprocket_layout_tables.ini
- **بار نشده** : JROOT/components/com_roksprocket/layouts/tables/language/fa-IR/roksprocket_layout_tables.ini
- **بار شده** : JROOT/components/com_roksprocket/layouts/grids/language/en-GB/en-GB.roksprocket_layout_grids.ini
- **بار نشده** : JROOT/components/com_roksprocket/layouts/grids/language/fa-IR/fa-IR.roksprocket_layout_grids.ini
- **بار نشده** : JROOT/components/com_roksprocket/layouts/grids/language/fa-IR/roksprocket_layout_grids.ini
- **بار شده** : JROOT/components/com_roksprocket/layouts/strips/language/en-GB/en-GB.roksprocket_layout_strips.ini
- **بار نشده** : JROOT/components/com_roksprocket/layouts/strips/language/fa-IR/fa-IR.roksprocket_layout_strips.ini
- **بار نشده** : JROOT/components/com_roksprocket/layouts/strips/language/fa-IR/roksprocket_layout_strips.ini
- **بار شده** : JROOT/language/fa-IR/fa-IR.mod_search.ini
- **بار شده** : JROOT/language/fa-IR/fa-IR.mod_breadcrumbs.ini
- **بار شده** : JROOT/language/fa-IR/fa-IR.mod_articles_news.ini
- **بار شده** : JROOT/language/fa-IR/fa-IR.mod_hadith.ini
- **بار نشده** : JROOT/language/fa-IR/fa-IR.mod_vvisit_counter.ini
- **بار نشده** : JROOT/language/fa-IR/mod_vvisit_counter.ini
- **بار نشده** : JROOT/modules/mod_vvisit_counter/language/fa-IR/fa-IR.mod_vvisit_counter.ini
- **بار نشده** : JROOT/modules/mod_vvisit_counter/language/fa-IR/mod_vvisit_counter.ini
- **بار شده** : JROOT/language/fa-IR/fa-IR.mod_footer.ini
- **بار شده** : JROOT/administrator/language/fa-IR/fa-IR.plg_system_debug.ini
# JROOT/libraries/src/Language/Text.php JW_PLG_AV_DEPRECATED_DOWNLOAD="PLG AV DEPRECATED DOWNLOAD" LOADING_CONTAINER_CONFIG_FILE_FOR_S_FROM_S="container config file for %s from %s" REGISTERING_LIBRARY_PATH_S_FOR_S="library path %s for %s"