- گیج
- اندازه گیری عمومی
- نمونه متن
- گیج
- دستگاه مخصوص
دستگاه مخصوص
در این بخش کاربران عزیز با انواع دستگاههای اندازه گیری مخصوص آشنا میشوند
ایرگیج
قانون اول تلرانس هندسی
19 فروردين 1403 جیگ و فیکسچر تولیدی
03 بهمن 1393 تلرانس لنگی ساده
20 فروردين 1403 چکینگ فیکسچر شیشه
20 فروردين 1401 تلرانس تقارن MMC
03 تیر 1398 تلرانس ابعادی و هندسی
03 بهمن 1393
تعریف فیچرfature
20 فروردين 1403 تلرانس لنگی محوری
20 فروردين 1403 تلرانس گذاری حدی
20 فروردين 1403 تلرانس ابعادی dimensional tolerance
20 فروردين 1403 تلرانس لنگی ساده
20 فروردين 1403 تلرانس ابعادی یکطرفه مثبت یا منفی
20 فروردين 1403 انطباقات
20 فروردين 1403 تلرانس گذاری حدی مینیم یا ماکزیمم
20 فروردين 1403 تلرانس پروفایل یک طرفهunilateral
19 فروردين 1403 تلرانس پروفایل تمام فیچرها allover
19 فروردين 1403 تگها
Articles
رنگهای قالب
اشکال یابی جوملا
{ "__default": { "session": { "counter": 1, "timer": { "start": 1713593852, "last": 1713593852, "now": 1713593852 }, "token": "JVoATiIBRUhPvoTD8jYnGdmeDfyzg5r9" }, "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 } } }
زمان
حافظه
57 پرس و جو ثبت شده 2539.74 ms
- زمان پرس و جو: 1.66 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 4.166 MB سطرهای بازگشتی: 0
SELECT `data`
FROM `i4x98_session`
WHERE `session_id` = X'3233653766666539363239666465303232346233646463666133656533613831'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.10 ms After opening tables 0.05 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.03 ms Statistics 1.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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 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.47 ms پس از آخرین پرس و جو: 1.85 ms حافظه پرس و جو: 0.020 MB حافظه قبل از پرس و جوی: 4.261 MB سطرهای بازگشتی: 0
SELECT `session_id`
FROM `i4x98_session`
WHERE `session_id` = X'3233653766666539363239666465303232346233646463666133656533613831'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 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 - زمان پرس و جو: 3.17 ms پس از آخرین پرس و جو: 0.13 ms حافظه پرس و جو: 0.004 MB حافظه قبل از پرس و جوی: 4.266 MB
INSERT INTO `i4x98_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3233653766666539363239666465303232346233646463666133656533613831', 1, 1713593852, 0, '', 0)توضیحات در جستجو ممکن نیست: INSERT INTO `i4x98_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3233653766666539363239666465303232346233646463666133656533613831', 1, 1713593852, 0, '', 0)Status Duration Starting 0.07 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 for update 0.02 ms Update 2.62 ms End of update loop 0.03 ms Query end 0.01 ms Commit 0.17 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.02 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 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 - زمان پرس و جو: 3.05 ms پس از آخرین پرس و جو: 2.90 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 4.454 MB سطرهای بازگشتی: 42
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `i4x98_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_extensions ref extension extension 82 const 45 Using index condition; Using where Status Duration Starting 0.05 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.02 ms Optimizing 0.03 ms Statistics 0.31 ms Preparing 0.05 ms Executing 0.01 ms Sending data 2.33 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 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 - زمان پرس و جو: 2.09 ms پس از آخرین پرس و جو: 2.87 ms حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 4.711 MB سطرهای بازگشتی: 4
SELECT id, rules
FROM `i4x98_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_viewlevels ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 4 Status Duration Starting 0.04 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.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 1.75 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 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 - زمان پرس و جو: 0.92 ms پس از آخرین پرس و جو: 0.11 ms حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 4.723 MB سطرهای بازگشتی: 1
SELECT b.id
FROM i4x98_usergroups AS a
LEFT JOIN i4x98_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id 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 1 Using where; Using index Status Duration Starting 0.05 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.02 ms Optimizing 0.02 ms Statistics 0.51 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.02 ms Freeing items 0.01 ms Updating status 0.04 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.49 ms پس از آخرین پرس و جو: 0.72 ms حافظه پرس و جو: 0.030 MB حافظه قبل از پرس و جوی: 4.791 MB سطرهای بازگشتی: 110
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM i4x98_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_extensions ALL extension کلید شاخصی برای استفاده نیست NULL NULL 345 Using where; با استفاده از مرتب سازی فایل Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 1.05 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 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.06 ms پس از آخرین پرس و جو: 79.20 ms حافظه پرس و جو: 0.033 MB حافظه قبل از پرس و جوی: 11.332 MB سطرهای بازگشتی: 254
SELECT config_key, config_value
FROM i4x98_eshop_configsid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_eshop_configs ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 254 Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.50 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php 10 EshopHelper::getConfig() JROOT/components/com_eshop/helpers/helper.php 9 EshopHelper::getConfigValue() JROOT/plugins/system/eshopcurrency/eshopcurrency.php 8 plgSystemEshopCurrency->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.59 ms پس از آخرین پرس و جو: 0.46 ms حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 11.376 MB سطرهای بازگشتی: 0
SELECT *
FROM i4x98_eshop_currencies
WHERE currency_code != 'IRR'
AND modified_date <= '2024-04-19 09:47:32'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_eshop_currencies ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 3 Using where Status Duration Starting 0.05 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.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.17 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php 9 EshopHelper::updateCurrencies() JROOT/plugins/system/eshopcurrency/eshopcurrency.php 8 plgSystemEshopCurrency->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.59 ms پس از آخرین پرس و جو: 0.11 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 11.381 MB
UPDATE i4x98_eshop_currencies
SET exchanged_value = 1.00000 , modified_date = '2024-04-20 09:47:32'
WHERE currency_code = 'IRR'توضیحات در جستجو ممکن نیست: UPDATE i4x98_eshop_currencies SET exchanged_value = 1.00000 , modified_date = '2024-04-20 09:47:32' WHERE currency_code = 'IRR'Status Duration Starting 0.05 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.03 ms init for update 0.04 ms Updating 0.09 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.13 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 10 JDatabaseDriverMysqli->execute() JROOT/components/com_eshop/helpers/helper.php 9 EshopHelper::updateCurrencies() JROOT/plugins/system/eshopcurrency/eshopcurrency.php 8 plgSystemEshopCurrency->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.55 ms پس از آخرین پرس و جو: 12.17 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 12.568 MB سطرهای بازگشتی: 22
SELECT *
FROM i4x98_rsform_configid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_rsform_config ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 22 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.17 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsform/helpers/config.php 11 RSFormProConfig->load() JROOT/administrator/components/com_rsform/helpers/config.php 10 RSFormProConfig->__construct() JROOT/administrator/components/com_rsform/helpers/config.php 9 RSFormProConfig::getInstance() JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php 8 plgSystemRsformdeletesubmissions->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 - زمان پرس و جو: 4.91 ms پس از آخرین پرس و جو: 16.69 ms حافظه پرس و جو: 0.107 MB حافظه قبل از پرس و جوی: 14.311 MB سطرهای بازگشتی: 62
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 i4x98_menu AS m
LEFT JOIN i4x98_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 165 Using index condition; Using where; با استفاده از مرتب سازی فایل 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 fixture_almone505480.m.component_id 1 Using where Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.30 ms Preparing 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 4.12 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 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 - زمان پرس و جو: 6.71 ms پس از آخرین پرس و جو: 12.85 ms حافظه پرس و جو: 0.024 MB حافظه قبل از پرس و جوی: 15.254 MB سطرهای بازگشتی: 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 `i4x98_categories` AS `s`
INNER JOIN `i4x98_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)
AND c.published = 1
AND s.id = 124
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 106 Using where; با استفاده از مرتب سازی فایل Status Duration Starting 0.12 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.05 ms Optimizing 0.03 ms Statistics 4.76 ms Preparing 0.04 ms Unlocking tables 0.01 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 1.24 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.05 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 12 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 11 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/helpers/legacyrouter.php:350 10 ContentRouterRulesLegacy->parse() JROOT/libraries/src/Component/Router/RouterView.php:266 9 Joomla\CMS\Component\Router\RouterView->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 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.56 ms پس از آخرین پرس و جو: 0.71 ms حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 15.307 MB سطرهای بازگشتی: 4
SELECT id, home, template, s.params
FROM i4x98_template_styles as s
LEFT JOIN i4x98_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 ALL idx_template,idx_client_id,idx_client_id_home کلید شاخصی برای استفاده نیست NULL NULL 6 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 fixture_almone505480.s.template,const 1 Using index condition; Using where Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.58 ms Preparing 0.05 ms Executing 0.02 ms Sending data 0.48 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 10 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/t3/includes/core/t3.php:320 9 T3::detect() JROOT/plugins/system/t3/t3.php:81 8 plgSystemT3->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.79 ms پس از آخرین پرس و جو: 5.69 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 15.961 MB سطرهای بازگشتی: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `i4x98_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.38 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 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 - زمان پرس و جو: 0.53 ms پس از آخرین پرس و جو: 0.18 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 15.952 MB
UPDATE `i4x98_extensions`
SET `params` = '{\"mediaversion\":\"49bc7cf0a255ca0ac26f053d84556ae3\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'توضیحات در جستجو ممکن نیست: UPDATE `i4x98_extensions` SET `params` = '{\"mediaversion\":\"49bc7cf0a255ca0ac26f053d84556ae3\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.06 ms Updating 0.07 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.12 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 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.69 ms پس از آخرین پرس و جو: 1.85 ms حافظه پرس و جو: 0.020 MB حافظه قبل از پرس و جوی: 16.200 MB سطرهای بازگشتی: 2
SELECT *
FROM i4x98_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_languages ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 5 Using where; با استفاده از مرتب سازی فایل Status Duration Starting 0.03 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.02 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.27 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 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 - زمان پرس و جو: 3.46 ms پس از آخرین پرس و جو: 7.35 ms حافظه پرس و جو: 0.028 MB حافظه قبل از پرس و جوی: 16.791 MB سطرهای بازگشتی: 40
SELECT `id`,`name`,`rules`,`parent_id`
FROM `i4x98_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_admintools','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_eshop','com_fbconnct','com_fields','com_finder','com_installer','com_jce','com_joombank','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_rsform','com_search','com_tags','com_templates','com_users','com_wrapper','com_xmap')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_assets range idx_asset_name idx_asset_name 202 NULL 43 Using index condition Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.02 ms Statistics 0.14 ms Preparing 0.02 ms Executing 0.01 ms Sending data 2.87 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 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 - زمان پرس و جو: 1.17 ms پس از آخرین پرس و جو: 0.20 ms حافظه پرس و جو: 0.068 MB حافظه قبل از پرس و جوی: 16.842 MB سطرهای بازگشتی: 284
SELECT `id`,`name`,`rules`,`parent_id`
FROM `i4x98_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 i4x98_assets ALL idx_asset_name,idx_parent_id کلید شاخصی برای استفاده نیست NULL NULL 483 Using where Status Duration Starting 0.05 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.02 ms Optimizing 0.02 ms Statistics 0.30 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.47 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.02 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 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 - زمان پرس و جو: 0.74 ms پس از آخرین پرس و جو: 1.25 ms حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 17.106 MB سطرهای بازگشتی: 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 `i4x98_categories` AS `s`
INNER JOIN `i4x98_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 = 124
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_left_right کلید شاخصی برای استفاده نیست NULL NULL 106 Using where; با استفاده از مرتب سازی فایل Status Duration Starting 0.10 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.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.13 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 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 - زمان پرس و جو: 4.64 ms پس از آخرین پرس و جو: 2.27 ms حافظه پرس و جو: 0.075 MB حافظه قبل از پرس و جوی: 17.880 MB سطرهای بازگشتی: 4
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,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM i4x98_content AS a
LEFT JOIN i4x98_categories AS c
ON c.id = a.catid
LEFT JOIN i4x98_users AS ua
ON ua.id = a.created_by
LEFT JOIN i4x98_users AS uam
ON uam.id = a.modified_by
LEFT JOIN i4x98_categories as parent
ON parent.id = c.parent_id
LEFT JOIN i4x98_content_rating AS v
ON a.id = v.content_id
WHERE c.published = 1
AND a.state = 1
AND a.catid = 124
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-20 06:17:32')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 06:17:32')
ORDER BY c.lft, a.ordering, a.created
LIMIT 8id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE a ref idx_state,idx_catid idx_catid 4 const 4 Using where; با استفاده از مرتب سازی فایل 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.modified_by 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 const 1 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.id 1 Using where Status Duration Starting 0.16 ms checking permissions 0.03 ms Opening tables 0.11 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.05 ms Statistics 0.71 ms Preparing 0.02 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 3.11 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 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 - زمان پرس و جو: 0.61 ms پس از آخرین پرس و جو: 1.58 ms حافظه پرس و جو: 0.024 MB حافظه قبل از پرس و جوی: 18.089 MB سطرهای بازگشتی: 1
SELECT COUNT(*)
FROM i4x98_content AS a
LEFT JOIN i4x98_categories AS c
ON c.id = a.catid
LEFT JOIN i4x98_users AS ua
ON ua.id = a.created_by
LEFT JOIN i4x98_users AS uam
ON uam.id = a.modified_by
LEFT JOIN i4x98_categories as parent
ON parent.id = c.parent_id
LEFT JOIN i4x98_content_rating AS v
ON a.id = v.content_id
WHERE c.published = 1
AND a.state = 1
AND a.catid = 124
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-20 06:17:32')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 06:17:32')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE a ref idx_state,idx_catid idx_catid 4 const 4 Using where Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 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 - زمان پرس و جو: 1.35 ms پس از آخرین پرس و جو: 1.66 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 18.223 MB سطرهای بازگشتی: 0
SELECT `m`.`tag_id`,`t`.*
FROM `i4x98_contentitem_tag_map` AS m
INNER JOIN `i4x98_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 124
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t ALL PRIMARY,tag_idx,idx_access کلید شاخصی برای استفاده نیست NULL NULL 12 Using where 1 SIMPLE m ref idx_tag_type idx_tag_type 4 fixture_almone505480.t.id 4 Using index condition; Using where Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.07 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.44 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.46 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 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 - زمان پرس و جو: 0.62 ms پس از آخرین پرس و جو: 281.77 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 23.779 MB سطرهای بازگشتی: 1
SELECT template_style_id
FROM i4x98_menu
WHERE id = 1479id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_menu const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.09 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.02 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:187 10 YtFrameworkTemplate->isOverrideTemplate() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:31 9 YtFrameworkTemplate->YtFrameworkTemplate() JROOT/templates/jm_iliya/includes/frame_inc.php 8 include_once JROOT/templates/jm_iliya/includes/frame_inc.php JROOT/templates/jm_iliya/index.php:23 7 require JROOT/templates/jm_iliya/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.53 ms پس از آخرین پرس و جو: 0.08 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 23.785 MB سطرهای بازگشتی: 1
SELECT id
FROM i4x98_template_styles
WHERE home = 1
AND client_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_template_styles ref idx_client_id,idx_client_id_home idx_client_id_home 1 const 4 Using where; Using index Status Duration Starting 0.05 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.02 ms Optimizing 0.02 ms Statistics 0.10 ms Preparing 0.03 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:191 10 YtFrameworkTemplate->isOverrideTemplate() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:31 9 YtFrameworkTemplate->YtFrameworkTemplate() JROOT/templates/jm_iliya/includes/frame_inc.php 8 include_once JROOT/templates/jm_iliya/includes/frame_inc.php JROOT/templates/jm_iliya/index.php:23 7 require JROOT/templates/jm_iliya/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 - زمان پرس و جو: 6.23 ms پس از آخرین پرس و جو: 2.26 ms حافظه پرس و جو: 0.044 MB حافظه قبل از پرس و جوی: 23.889 MB سطرهای بازگشتی: 23
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM i4x98_modules AS m
LEFT JOIN i4x98_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN i4x98_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 <= '2024-04-20 06:17:32')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-20 06:17:32')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 1479 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 ALL PRIMARY,published,newsfeeds کلید شاخصی برای استفاده نیست NULL NULL 116 Using where; با استفاده از مرتب سازی فایل 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 fixture_almone505480.m.module,const 1 Using index condition; Using where 1 SIMPLE mm ref PRIMARY PRIMARY 4 fixture_almone505480.m.id 3 Using where; Using index Status Duration Starting 0.10 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.04 ms Optimizing 0.06 ms Statistics 0.40 ms Preparing 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 5.20 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.03 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 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/plugins/system/yt/includes/site/lib/yt_renderxml.php:177 11 YtFrameworkRenderXML->getBlocks() JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:115 10 YtFrameworkRenderXML->getTagBody() JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:49 9 YtFrameworkRenderXML->YtFrameworkRenderXML() JROOT/templates/jm_iliya/includes/frame_inc.php 8 include_once JROOT/templates/jm_iliya/includes/frame_inc.php JROOT/templates/jm_iliya/index.php:23 7 require JROOT/templates/jm_iliya/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.37 ms پس از آخرین پرس و جو: 1.59 ms حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 23.965 MB سطرهای بازگشتی: 1
SELECT home
FROM i4x98_menu
WHERE id=1479id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_menu const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 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.02 ms Optimizing 0.03 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 9 JDatabase->query() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:175 8 YtFrameworkTemplate->isHomePage() JROOT/templates/jm_iliya/index.php:75 7 require JROOT/templates/jm_iliya/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.34 ms پس از آخرین پرس و جو: 0.05 ms حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 23.970 MB سطرهای بازگشتی: 1
SELECT home
FROM i4x98_menu
WHERE id=1479id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_menu const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:176 8 YtFrameworkTemplate->isHomePage() JROOT/templates/jm_iliya/index.php:75 7 require JROOT/templates/jm_iliya/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.40 ms پس از آخرین پرس و جو: 1.53 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 24.016 MB سطرهای بازگشتی: 1
SELECT home
FROM i4x98_menu
WHERE id=1479id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_menu const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.03 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 11 JDatabase->query() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:175 10 YtFrameworkTemplate->isHomePage() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:328 9 YtFrameworkTemplate->renPositionsGroup() JROOT/templates/jm_iliya/includes/block-content.php 8 include JROOT/templates/jm_iliya/includes/block-content.php JROOT/templates/jm_iliya/index.php:201 7 require JROOT/templates/jm_iliya/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.30 ms پس از آخرین پرس و جو: 0.05 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 24.022 MB سطرهای بازگشتی: 1
SELECT home
FROM i4x98_menu
WHERE id=1479id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_menu const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:176 10 YtFrameworkTemplate->isHomePage() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:328 9 YtFrameworkTemplate->renPositionsGroup() JROOT/templates/jm_iliya/includes/block-content.php 8 include JROOT/templates/jm_iliya/includes/block-content.php JROOT/templates/jm_iliya/index.php:201 7 require JROOT/templates/jm_iliya/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.41 ms پس از آخرین پرس و جو: 6.27 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 24.150 MB سطرهای بازگشتی: 1
SELECT *
FROM i4x98_modules
WHERE id='405'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_modules const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:101 18 plgContentLoadModuleInArticle->load_module() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74 17 plgContentLoadModuleInArticle->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 14 JHtmlContent::prepare() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 12 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111 11 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom/mod_custom.php:15 10 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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 - زمان پرس و جو: 7.98 ms پس از آخرین پرس و جو: 1.20 ms حافظه پرس و جو: 0.067 MB حافظه قبل از پرس و جوی: 24.214 MB سطرهای بازگشتی: 6
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,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM i4x98_content AS a
LEFT JOIN i4x98_categories AS c
ON c.id = a.catid
LEFT JOIN i4x98_users AS ua
ON ua.id = a.created_by
LEFT JOIN i4x98_users AS uam
ON uam.id = a.modified_by
LEFT JOIN i4x98_categories as parent
ON parent.id = c.parent_id
LEFT JOIN i4x98_content_rating AS v
ON a.id = v.content_id
WHERE c.published = 1
AND a.state = 1
AND a.catid IN (112,118,119,120,126,86,116,136,127,80,115,137,97,117)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-20 06:17:32')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 06:17:32')
ORDER BY a.hits DESC
LIMIT 6id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a range idx_state,idx_catid idx_catid 4 NULL 86 Using index condition; Using where; با استفاده از مرتب سازی فایل 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.catid 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.modified_by 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 fixture_almone505480.c.parent_id 1 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.id 1 Using where Status Duration Starting 0.18 ms checking permissions 0.03 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.01 ms init 0.09 ms Optimizing 0.05 ms Statistics 0.13 ms Preparing 0.11 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 7.11 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 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/libraries/src/MVC/Model/ListModel.php:194 24 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 23 ContentModelArticles->getItems() JROOT/modules/mod_articles_popular/helper.php:77 22 ModArticlesPopularHelper::getList() JROOT/modules/mod_articles_popular/mod_articles_popular.php:15 21 include JROOT/modules/mod_articles_popular/mod_articles_popular.php JROOT/libraries/src/Helper/ModuleHelper.php:200 20 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 19 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:107 18 plgContentLoadModuleInArticle->load_module() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74 17 plgContentLoadModuleInArticle->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 14 JHtmlContent::prepare() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 12 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111 11 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom/mod_custom.php:15 10 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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.77 ms پس از آخرین پرس و جو: 0.68 ms حافظه پرس و جو: 0.035 MB حافظه قبل از پرس و جوی: 24.344 MB سطرهای بازگشتی: 3
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 `i4x98_categories` AS `s`
INNER JOIN `i4x98_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)
AND c.published = 1
AND s.id = 97
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 106 Using where; با استفاده از مرتب سازی فایل Status Duration Starting 0.09 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.09 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.17 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 36 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 35 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 34 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 33 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 32 ContentRouter->getCategorySegment() به نظر می رسد خط زیر فراخونده شده باشد. 31 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 30 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 29 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 28 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 27 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 26 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 25 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 24 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 23 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_popular/helper.php:89 22 ModArticlesPopularHelper::getList() JROOT/modules/mod_articles_popular/mod_articles_popular.php:15 21 include JROOT/modules/mod_articles_popular/mod_articles_popular.php JROOT/libraries/src/Helper/ModuleHelper.php:200 20 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 19 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:107 18 plgContentLoadModuleInArticle->load_module() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74 17 plgContentLoadModuleInArticle->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 14 JHtmlContent::prepare() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 12 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111 11 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom/mod_custom.php:15 10 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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.71 ms پس از آخرین پرس و جو: 0.30 ms حافظه پرس و جو: 0.035 MB حافظه قبل از پرس و جوی: 24.381 MB سطرهای بازگشتی: 6
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 `i4x98_categories` AS `s`
INNER JOIN `i4x98_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)
AND c.published = 1
AND s.id = 112
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 106 Using where; با استفاده از مرتب سازی فایل Status Duration Starting 0.09 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.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.17 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 36 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 35 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 34 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 33 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 32 ContentRouter->getCategorySegment() به نظر می رسد خط زیر فراخونده شده باشد. 31 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 30 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 29 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 28 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 27 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 26 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 25 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 24 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 23 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_popular/helper.php:89 22 ModArticlesPopularHelper::getList() JROOT/modules/mod_articles_popular/mod_articles_popular.php:15 21 include JROOT/modules/mod_articles_popular/mod_articles_popular.php JROOT/libraries/src/Helper/ModuleHelper.php:200 20 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 19 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:107 18 plgContentLoadModuleInArticle->load_module() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74 17 plgContentLoadModuleInArticle->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 14 JHtmlContent::prepare() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 12 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111 11 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom/mod_custom.php:15 10 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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.69 ms پس از آخرین پرس و جو: 0.39 ms حافظه پرس و جو: 0.034 MB حافظه قبل از پرس و جوی: 24.419 MB سطرهای بازگشتی: 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 `i4x98_categories` AS `s`
INNER JOIN `i4x98_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)
AND c.published = 1
AND s.id = 116
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 106 Using where; با استفاده از مرتب سازی فایل Status Duration Starting 0.07 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.10 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.14 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 36 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 35 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 34 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 33 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 32 ContentRouter->getCategorySegment() به نظر می رسد خط زیر فراخونده شده باشد. 31 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 30 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 29 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 28 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 27 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 26 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 25 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 24 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 23 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_popular/helper.php:89 22 ModArticlesPopularHelper::getList() JROOT/modules/mod_articles_popular/mod_articles_popular.php:15 21 include JROOT/modules/mod_articles_popular/mod_articles_popular.php JROOT/libraries/src/Helper/ModuleHelper.php:200 20 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 19 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:107 18 plgContentLoadModuleInArticle->load_module() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74 17 plgContentLoadModuleInArticle->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 14 JHtmlContent::prepare() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 12 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111 11 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom/mod_custom.php:15 10 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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.37 ms پس از آخرین پرس و جو: 6.57 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 24.399 MB سطرهای بازگشتی: 1
SELECT *
FROM i4x98_modules
WHERE id='402'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_modules const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:101 18 plgContentLoadModuleInArticle->load_module() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74 17 plgContentLoadModuleInArticle->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 14 JHtmlContent::prepare() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 12 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111 11 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom/mod_custom.php:15 10 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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.95 ms پس از آخرین پرس و جو: 1.13 ms حافظه پرس و جو: 0.067 MB حافظه قبل از پرس و جوی: 24.463 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,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM i4x98_content AS a
LEFT JOIN i4x98_categories AS c
ON c.id = a.catid
LEFT JOIN i4x98_users AS ua
ON ua.id = a.created_by
LEFT JOIN i4x98_users AS uam
ON uam.id = a.modified_by
LEFT JOIN i4x98_categories as parent
ON parent.id = c.parent_id
LEFT JOIN i4x98_content_rating AS v
ON a.id = v.content_id
WHERE c.published = 1
AND a.state = 1
AND a.catid IN (112,118,119,120,90,87,88,86,116,94,80,115,97,117)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-20 06:17:32')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 06:17:32')
ORDER BY a.created DESC
LIMIT 10id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a range idx_state,idx_catid idx_catid 4 NULL 114 Using index condition; Using where; با استفاده از مرتب سازی فایل 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.catid 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.modified_by 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 fixture_almone505480.c.parent_id 1 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.id 1 Using where Status Duration Starting 0.14 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.04 ms Statistics 0.11 ms Preparing 0.09 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.04 ms Creating sort index 1.19 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 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/libraries/src/MVC/Model/ListModel.php:194 24 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 23 ContentModelArticles->getItems() JROOT/modules/mod_articles_latest/helper.php:123 22 ModArticlesLatestHelper::getList() JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 21 include JROOT/modules/mod_articles_latest/mod_articles_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 20 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 19 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:107 18 plgContentLoadModuleInArticle->load_module() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74 17 plgContentLoadModuleInArticle->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 14 JHtmlContent::prepare() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 12 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111 11 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom/mod_custom.php:15 10 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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.65 ms پس از آخرین پرس و جو: 1.03 ms حافظه پرس و جو: 0.034 MB حافظه قبل از پرس و جوی: 24.634 MB سطرهای بازگشتی: 3
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 `i4x98_categories` AS `s`
INNER JOIN `i4x98_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)
AND c.published = 1
AND s.id = 117
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 106 Using where; با استفاده از مرتب سازی فایل Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.13 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 36 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 35 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 34 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 33 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 32 ContentRouter->getCategorySegment() به نظر می رسد خط زیر فراخونده شده باشد. 31 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 30 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 29 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 28 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 27 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 26 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 25 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 24 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 23 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_latest/helper.php:135 22 ModArticlesLatestHelper::getList() JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 21 include JROOT/modules/mod_articles_latest/mod_articles_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 20 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 19 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:107 18 plgContentLoadModuleInArticle->load_module() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74 17 plgContentLoadModuleInArticle->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 14 JHtmlContent::prepare() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 12 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111 11 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom/mod_custom.php:15 10 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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 - زمان پرس و جو: 5.87 ms پس از آخرین پرس و جو: 12.30 ms حافظه پرس و جو: 0.024 MB حافظه قبل از پرس و جوی: 24.662 MB سطرهای بازگشتی: 10
SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params
FROM `i4x98_contentitem_tag_map` AS `m`
INNER JOIN `i4x98_tags` AS `t`
ON `tag_id` = t.id
INNER JOIN `i4x98_ucm_content` AS `c`
ON `m`.`core_content_id` = `c`.`core_content_id`
WHERE `t`.`access` IN (1,1)
AND `t`.`published` = 1
AND `m`.`type_alias` = `c`.`core_type_alias`
AND `c`.`core_state` = 1
AND (`c`.`core_access` IN (1,1) OR `c`.`core_access` = 0)
AND (`c`.`core_publish_up` = '0000-00-00 00:00:00' OR `c`.`core_publish_up` <= '2024-04-20 06:17:32')
AND (`c`.`core_publish_down` = '0000-00-00 00:00:00' OR `c`.`core_publish_down` >= '2024-04-20 06:17:32')
GROUP BY `tag_id`,`title`,`access`,`alias`
ORDER BY `count` DESC
LIMIT 10id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ref PRIMARY,tag_idx,idx_access,idx_content_type tag_idx 1 const 34 Using index condition; Using where; Using temporary; با استفاده از مرتب سازی فایل 1 SIMPLE m ref idx_tag_type,idx_core_content_id idx_core_content_id 4 fixture_almone505480.c.core_content_id 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 fixture_almone505480.m.tag_id 1 Using where Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.10 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.04 ms Statistics 0.74 ms Preparing 0.05 ms Creating tmp table 0.08 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 4.22 ms Creating sort index 0.06 ms Removing tmp table 0.16 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/modules/mod_tags_popular/helper.php:134 14 ModTagsPopularHelper::getList() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:596 11 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_tags_popular/mod_tags_popular.php:22 10 include JROOT/modules/mod_tags_popular/mod_tags_popular.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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.84 ms پس از آخرین پرس و جو: 4.19 ms حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 24.910 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 `i4x98_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `i4x98_categories` AS `s`
INNER JOIN `i4x98_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)
AND c.published = 1
AND s.id = 9
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_access,idx_left_right کلید شاخصی برای استفاده نیست NULL NULL 106 Using where; با استفاده از مرتب سازی فایل 2 DEPENDENT SUBQUERY i ref idx_state,idx_catid idx_catid 4 fixture_almone505480.c.id 2 Using index condition; Using where Status Duration Starting 0.11 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.19 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 1.83 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Removing tmp table 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 17 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 16 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/models/categories.php:115 15 ContentModelCategories->getItems() JROOT/modules/mod_articles_category/helper.php:142 14 ModArticlesCategoryHelper::getList() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:566 11 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_articles_category/mod_articles_category.php:61 10 include JROOT/modules/mod_articles_category/mod_articles_category.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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.07 ms پس از آخرین پرس و جو: 0.21 ms حافظه پرس و جو: 0.027 MB حافظه قبل از پرس و جوی: 24.928 MB سطرهای بازگشتی: 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,( SELECT COUNT(i.`id`)
FROM `i4x98_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `i4x98_categories` AS `s`
INNER JOIN `i4x98_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)
AND c.published = 1
AND s.id = 96
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_access,idx_left_right کلید شاخصی برای استفاده نیست NULL NULL 106 Using where; با استفاده از مرتب سازی فایل 2 DEPENDENT SUBQUERY i ref idx_state,idx_catid idx_catid 4 fixture_almone505480.c.id 2 Using index condition; Using where Status Duration Starting 0.09 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.05 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.17 ms Executing 0.01 ms Sending data 0.03 ms Executing 0.01 ms Sending data 0.06 ms Executing 0.01 ms Sending data 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Removing tmp table 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 17 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 16 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/models/categories.php:115 15 ContentModelCategories->getItems() JROOT/modules/mod_articles_category/helper.php:142 14 ModArticlesCategoryHelper::getList() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:566 11 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_articles_category/mod_articles_category.php:61 10 include JROOT/modules/mod_articles_category/mod_articles_category.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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.11 ms پس از آخرین پرس و جو: 0.22 ms حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 24.952 MB سطرهای بازگشتی: 3
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 `i4x98_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `i4x98_categories` AS `s`
INNER JOIN `i4x98_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)
AND c.published = 1
AND s.id = 97
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_access,idx_left_right کلید شاخصی برای استفاده نیست NULL NULL 106 Using where; با استفاده از مرتب سازی فایل 2 DEPENDENT SUBQUERY i ref idx_state,idx_catid idx_catid 4 fixture_almone505480.c.id 2 Using index condition; Using where Status Duration Starting 0.09 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.08 ms Optimizing 0.05 ms Statistics 0.09 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.13 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.10 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Removing tmp table 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 17 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 16 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/models/categories.php:115 15 ContentModelCategories->getItems() JROOT/modules/mod_articles_category/helper.php:142 14 ModArticlesCategoryHelper::getList() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:566 11 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_articles_category/mod_articles_category.php:61 10 include JROOT/modules/mod_articles_category/mod_articles_category.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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.53 ms پس از آخرین پرس و جو: 0.24 ms حافظه پرس و جو: 0.064 MB حافظه قبل از پرس و جوی: 24.969 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,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM i4x98_content AS a
LEFT JOIN i4x98_categories AS c
ON c.id = a.catid
LEFT JOIN i4x98_users AS ua
ON ua.id = a.created_by
LEFT JOIN i4x98_users AS uam
ON uam.id = a.modified_by
LEFT JOIN i4x98_categories as parent
ON parent.id = c.parent_id
LEFT JOIN i4x98_content_rating AS v
ON a.id = v.content_id
WHERE c.published = 1
AND a.state = 1
AND a.catid NOT IN (9,96,97)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-20 06:17:32')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 06:17:32')
ORDER BY publish_up DESC
LIMIT 10id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a range idx_state,idx_catid idx_catid 4 NULL 186 Using index condition; Using where; با استفاده از مرتب سازی فایل 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.catid 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.modified_by 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 fixture_almone505480.c.parent_id 1 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.id 1 Using where Status Duration Starting 0.14 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.09 ms Preparing 0.07 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 2.82 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 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/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 15 ContentModelArticles->getItems() JROOT/modules/mod_articles_category/helper.php:224 14 ModArticlesCategoryHelper::getList() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:566 11 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_articles_category/mod_articles_category.php:61 10 include JROOT/modules/mod_articles_category/mod_articles_category.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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.73 ms پس از آخرین پرس و جو: 0.82 ms حافظه پرس و جو: 0.029 MB حافظه قبل از پرس و جوی: 25.135 MB سطرهای بازگشتی: 3
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 `i4x98_categories` AS `s`
INNER JOIN `i4x98_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)
AND c.published = 1
AND s.id = 142
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 106 Using where; با استفاده از مرتب سازی فایل Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.14 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 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/Categories/Categories.php:324 26 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 25 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 24 ContentRouter->getCategorySegment() به نظر می رسد خط زیر فراخونده شده باشد. 23 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 22 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 21 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 20 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 19 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 18 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 17 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 16 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 15 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_category/helper.php:260 14 ModArticlesCategoryHelper::getList() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:566 11 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_articles_category/mod_articles_category.php:61 10 include JROOT/modules/mod_articles_category/mod_articles_category.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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 - زمان پرس و جو: 2446.20 ms پس از آخرین پرس و جو: 3.53 ms حافظه پرس و جو: 62.120 MB حافظه قبل از پرس و جوی: 25.024 MB سطرهای بازگشتی: 1158496
SELECT guest, client_id
FROM i4x98_session
WHERE client_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_session ref client_id_guest client_id_guest 2 const 742086 Using index Status Duration Starting 0.03 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.02 ms Optimizing 0.01 ms Statistics 6.29 ms Preparing 0.03 ms Executing 0.01 ms Sending data 2418.58 ms End of update loop 0.04 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_whosonline/helper.php:45 11 ModWhosonlineHelper::getOnlineCount() JROOT/modules/mod_whosonline/mod_whosonline.php:19 10 include JROOT/modules/mod_whosonline/mod_whosonline.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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 - زمان پرس و جو: 5.93 ms پس از آخرین پرس و جو: 1796.95 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 41.048 MB سطرهای بازگشتی: 1
SELECT SUM(hits) AS count_hits
FROM i4x98_content
WHERE state = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_content ALL idx_state کلید شاخصی برای استفاده نیست NULL NULL 190 Using where Status Duration Starting 0.12 ms checking permissions 0.01 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.02 ms Statistics 0.39 ms Preparing 0.04 ms Executing 0.01 ms Sending data 4.94 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/modules/mod_stats/helper.php:129 11 ModStatsHelper::getList() JROOT/modules/mod_stats/mod_stats.php:17 10 include JROOT/modules/mod_stats/mod_stats.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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.49 ms پس از آخرین پرس و جو: 8.93 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 41.758 MB
CREATE TABLE IF NOT EXISTS i4x98_vvisitcounter(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=1
توضیحات در جستجو ممکن نیست: CREATE TABLE IF NOT EXISTS i4x98_vvisitcounter(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=1Status Duration Starting 0.11 ms checking permissions 0.02 ms Opening tables 0.11 ms After opening tables 0.06 ms closing tables 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Commit implicit 0.01 ms Starting cleanup 0.02 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 14 JDatabase->query() JROOT/modules/mod_vvisit_counter/helper.php:1404 13 modVisitCounterHelper->init() JROOT/modules/mod_vvisit_counter/helper.php:482 12 modVisitCounterHelper->__construct() JROOT/modules/mod_vvisit_counter/tmpl/default.php:21 11 require JROOT/modules/mod_vvisit_counter/tmpl/default.php JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 10 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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.39 ms پس از آخرین پرس و جو: 0.20 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 41.765 MB سطرهای بازگشتی: 1
SELECT count( * ) AS records, MAX( id ) AS max
FROM i4x98_vvisitcounterid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL کلید شاخصی برای استفاده نیست NULL NULL NULL Select tables optimized away Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.06 ms Executing 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 14 JDatabaseDriver->loadRow() JROOT/modules/mod_vvisit_counter/helper.php:1417 13 modVisitCounterHelper->init() JROOT/modules/mod_vvisit_counter/helper.php:482 12 modVisitCounterHelper->__construct() JROOT/modules/mod_vvisit_counter/tmpl/default.php:21 11 require JROOT/modules/mod_vvisit_counter/tmpl/default.php JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 10 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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.35 ms پس از آخرین پرس و جو: 0.14 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 41.773 MB
DELETE
FROM i4x98_vvisitcounter
WHERE id<='101167'توضیحات در جستجو ممکن نیست: DELETE FROM i4x98_vvisitcounter WHERE id<='101167'Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.06 ms Updating 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 14 JDatabase->query() JROOT/modules/mod_vvisit_counter/helper.php:1560 13 modVisitCounterHelper->init() JROOT/modules/mod_vvisit_counter/helper.php:482 12 modVisitCounterHelper->__construct() JROOT/modules/mod_vvisit_counter/tmpl/default.php:21 11 require JROOT/modules/mod_vvisit_counter/tmpl/default.php JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 10 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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.16 ms پس از آخرین پرس و جو: 0.09 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 41.780 MB سطرهای بازگشتی: 1
SELECT COUNT(*)
FROM i4x98_vvisitcounter
WHERE ip=UNHEX(SHA1('18.189.193.172'))
AND ( ((unix_timestamp(NOW()) - tm ) / 60 ) < '15' )id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_vvisitcounter ref ip,iptm iptm 20 const 2 Using where; Using index Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.78 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/modules/mod_vvisit_counter/helper.php:1612 13 modVisitCounterHelper->init() JROOT/modules/mod_vvisit_counter/helper.php:482 12 modVisitCounterHelper->__construct() JROOT/modules/mod_vvisit_counter/tmpl/default.php:21 11 require JROOT/modules/mod_vvisit_counter/tmpl/default.php JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 10 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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.39 ms پس از آخرین پرس و جو: 0.10 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 41.788 MB
INSERT INTO i4x98_vvisitcounter ( tm, ip, data )
VALUES ( unix_timestamp(NOW()) , UNHEX(SHA1('18.189.193.172')) , NULL )توضیحات در جستجو ممکن نیست: INSERT INTO i4x98_vvisitcounter ( tm, ip, data ) VALUES ( unix_timestamp(NOW()) , UNHEX(SHA1('18.189.193.172')) , NULL )Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.03 ms Update 0.09 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.05 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 14 JDatabase->query() JROOT/modules/mod_vvisit_counter/helper.php:1651 13 modVisitCounterHelper->init() JROOT/modules/mod_vvisit_counter/helper.php:482 12 modVisitCounterHelper->__construct() JROOT/modules/mod_vvisit_counter/tmpl/default.php:21 11 require JROOT/modules/mod_vvisit_counter/tmpl/default.php JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 10 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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.37 ms پس از آخرین پرس و جو: 0.10 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 41.796 MB سطرهای بازگشتی: 1
SELECT COUNT(*)
FROM i4x98_vvisitcounter
WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW()))
AND UNIX_TIMESTAMP(DATE(NOW()) + INTERVAL 1 DAY)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_vvisitcounter range tm tm 4 NULL 138 Using where; Using index Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.06 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/modules/mod_vvisit_counter/helper.php:1920 13 modVisitCounterHelper->sql_today_visitors() JROOT/modules/mod_vvisit_counter/helper.php:763 12 modVisitCounterHelper->renderPeopleTable() JROOT/modules/mod_vvisit_counter/tmpl/default.php:26 11 require JROOT/modules/mod_vvisit_counter/tmpl/default.php JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 10 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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.38 ms پس از آخرین پرس و جو: 0.06 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 41.803 MB سطرهای بازگشتی: 1
SELECT COUNT(*)
FROM i4x98_vvisitcounter
WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW() - INTERVAL 1 DAY))
AND UNIX_TIMESTAMP(DATE(NOW()))id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_vvisitcounter range tm tm 4 NULL 191 Using where; Using index Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.02 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/modules/mod_vvisit_counter/helper.php:1935 13 modVisitCounterHelper->sql_yesterday_visitors() JROOT/modules/mod_vvisit_counter/helper.php:774 12 modVisitCounterHelper->renderPeopleTable() JROOT/modules/mod_vvisit_counter/tmpl/default.php:26 11 require JROOT/modules/mod_vvisit_counter/tmpl/default.php JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 10 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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.49 ms پس از آخرین پرس و جو: 0.11 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 41.812 MB سطرهای بازگشتی: 1
SELECT COUNT(*)
FROM i4x98_vvisitcounter
WHERE tm BETWEEN 1713126600
AND 1713731400id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_vvisitcounter range tm tm 4 NULL 573 Using where; Using index Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.06 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.10 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/modules/mod_vvisit_counter/helper.php:1979 13 modVisitCounterHelper->sql_week_visitors() JROOT/modules/mod_vvisit_counter/helper.php:784 12 modVisitCounterHelper->renderPeopleTable() JROOT/modules/mod_vvisit_counter/tmpl/default.php:26 11 require JROOT/modules/mod_vvisit_counter/tmpl/default.php JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 10 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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.77 ms پس از آخرین پرس و جو: 0.10 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 41.820 MB سطرهای بازگشتی: 1
SELECT COUNT(*)
FROM i4x98_vvisitcounter
WHERE tm BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(NOW(), "%Y-%m-01"))
AND UNIX_TIMESTAMP(DATE_FORMAT(NOW(), "%Y-%m-01") + INTERVAL 1 MONTH)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_vvisitcounter range tm tm 4 NULL 1898 Using where; Using index Status Duration Starting 0.05 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.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.36 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/modules/mod_vvisit_counter/helper.php:1994 13 modVisitCounterHelper->sql_month_visitors() JROOT/modules/mod_vvisit_counter/helper.php:808 12 modVisitCounterHelper->renderPeopleTable() JROOT/modules/mod_vvisit_counter/tmpl/default.php:26 11 require JROOT/modules/mod_vvisit_counter/tmpl/default.php JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 10 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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.96 ms پس از آخرین پرس و جو: 46.71 ms حافظه پرس و جو: 0.033 MB حافظه قبل از پرس و جوی: 43.140 MB سطرهای بازگشتی: 139
SELECT *
FROM i4x98_acymailing_configid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_acymailing_config ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 139 Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 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_acymailing/compat/joomla.php:481 13 acymailing_loadObjectList() JROOT/administrator/components/com_acymailing/classes/cpanel.php:17 12 cpanelClass->load() JROOT/administrator/components/com_acymailing/helpers/helper.php:438 11 acymailing_config() JROOT/administrator/components/com_acymailing/compat/joomla.php:822 10 include_once JROOT/administrator/components/com_acymailing/compat/joomla.php JROOT/administrator/components/com_acymailing/helpers/helper.php:22 9 include_once JROOT/administrator/components/com_acymailing/helpers/helper.php JROOT/plugins/system/regacymailing/regacymailing.php:22 8 plgSystemRegacymailing->initAcy() JROOT/plugins/system/regacymailing/regacymailing.php:146 7 plgSystemRegacymailing->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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.57 ms پس از آخرین پرس و جو: 5.59 ms حافظه پرس و جو: 0.020 MB حافظه قبل از پرس و جوی: 43.562 MB سطرهای بازگشتی: 1
SELECT template
FROM i4x98_template_styles
WHERE home = 1
AND client_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_template_styles ALL idx_client_id,idx_client_id_home کلید شاخصی برای استفاده نیست NULL NULL 6 Using where Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.66 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.32 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.03 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/yt.php:281 8 plgSystemYt->nameOfSJTemplate() JROOT/plugins/system/yt/yt.php:162 7 plgSystemYt->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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
36 نوع پرس و جو ثبت شده
انتخاب جداول:
7 × 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 `i4x98_categories` AS `s`
INNER JOIN `i4x98_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)5 × SELECT COUNT(*)
FROM i4x98_vvisitcounter4 × SELECT home
FROM i4x98_menu4 × 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,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM i4x98_content AS a
LEFT JOIN i4x98_categories AS c
ON c.id = a.catid
LEFT JOIN i4x98_users AS ua
ON ua.id = a.created_by
LEFT JOIN i4x98_users AS uam
ON uam.id = a.modified_by
LEFT JOIN i4x98_categories as parent
ON parent.id = c.parent_id
LEFT JOIN i4x98_content_rating AS v
ON a.id = v.content_id3 × 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 `i4x98_content` AS `i`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `i4x98_extensions`2 × SELECT *
FROM i4x98_modules2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `i4x98_assets`1 × SELECT `data`
FROM `i4x98_session`1 × SELECT id
FROM i4x98_template_styles1 × SELECT *
FROM i4x98_acymailing_confi1 × SELECT count( * ) AS records, MAX( id ) AS max
FROM i4x98_vvisitcounte1 × SELECT SUM(hits) AS count_hits
FROM i4x98_content1 × SELECT guest, client_id
FROM i4x98_session1 × SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params
FROM `i4x98_contentitem_tag_map` AS `m`
INNER JOIN `i4x98_tags` AS `t`
ON `tag_id` = t.id
INNER JOIN `i4x98_ucm_content` AS `c`
ON `m`.`core_content_id` = `c`.`core_content_id`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM i4x98_modules AS m
LEFT JOIN i4x98_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN i4x98_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT COUNT(*)
FROM i4x98_content AS a
LEFT JOIN i4x98_categories AS c
ON c.id = a.catid
LEFT JOIN i4x98_users AS ua
ON ua.id = a.created_by
LEFT JOIN i4x98_users AS uam
ON uam.id = a.modified_by
LEFT JOIN i4x98_categories as parent
ON parent.id = c.parent_id
LEFT JOIN i4x98_content_rating AS v
ON a.id = v.content_id1 × SELECT template_style_id
FROM i4x98_menu1 × SELECT `m`.`tag_id`,`t`.*
FROM `i4x98_contentitem_tag_map` AS m
INNER JOIN `i4x98_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT `session_id`
FROM `i4x98_session`1 × SELECT *
FROM i4x98_languages1 × SELECT id, home, template, s.params
FROM i4x98_template_styles as s
LEFT JOIN i4x98_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × 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 i4x98_menu AS m
LEFT JOIN i4x98_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM i4x98_rsform_confi1 × SELECT *
FROM i4x98_eshop_currencies1 × SELECT config_key, config_value
FROM i4x98_eshop_config1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM i4x98_extensions1 × SELECT b.id
FROM i4x98_usergroups AS a
LEFT JOIN i4x98_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `i4x98_viewlevels1 × SELECT template
FROM i4x98_template_styles
سایر جداول:
1 × INSERT INTO `i4x98_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3233653766666539363239666465303232346233646463666133656533613831', 1, 1713593852, 0, '', 01 × UPDATE i4x98_eshop_currencies
SET exchanged_value = 1.00000 , modified_date = '2024-04-20 09:47:32'1 × UPDATE `i4x98_extensions`
SET `params` = '{\"mediaversion\":\"49bc7cf0a255ca0ac26f053d84556ae3\"}'1 × CREATE TABLE IF NOT EXISTS i4x98_vvisitcounter(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=
1 × DELETE
FROM i4x98_vvisitcounter1 × INSERT INTO i4x98_vvisitcounter ( tm, ip, data )
VALUES ( unix_timestamp(NOW()) , UNHEX(SHA1('18.189.193.172')) , NULL
تلفن :09123345784