اولین جلسه بررسی مدل زیر ساخت فناوری اطلاعات در زمینه ارائه خدمات پزشکی به بیماران با همکاری متخصّصین آلمانی در بیمارستان فوق تخصصی آیت ا... یثربی (ره)
اشکال یابی جوملا
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1715423420,
"last": 1715423420,
"now": 1715423420
}
},
"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
},
"com_mailto": {
"links": {
"7e8418f72c019f2e85b6341292066dac55ae8062": {
"link": "http://yasrebihospital.ir/index.php/news/news/item/247-2017-03-12-07-11-08?tmpl=component&print=1",
"expiry": 1715423420
}
}
}
}
}
زمان
حافظه
زمان: 13.46 ms / 13.46 ms حافظه: 1.840 MB / 2.22 MB Application: afterLoad
زمان: 52.94 ms / 66.41 ms حافظه: 5.665 MB / 7.89 MB Application: afterInitialise
زمان: 20.56 ms / 86.97 ms حافظه: 2.134 MB / 10.02 MB Application: afterRoute
زمان: 0.58 ms / 87.55 ms حافظه: 0.045 MB / 10.07 MB Application: beforeRenderComponent com_k2
زمان: 0.16 ms / 87.71 ms حافظه: 0.027 MB / 10.09 MB Application: Before Access::preloadComponents (all components)
زمان: 1.33 ms / 89.04 ms حافظه: 0.056 MB / 10.15 MB Application: After Access::preloadComponents (all components)
زمان: 0.03 ms / 89.08 ms حافظه: -0.005 MB / 10.15 MB Application: Before Access::getAssetRules (id:411 name:com_k2)
زمان: 0.41 ms / 89.49 ms حافظه: 0.026 MB / 10.17 MB Application: After Access::getAssetRules (id:411 name:com_k2)
زمان: 55.57 ms / 145.06 ms حافظه: 3.735 MB / 13.91 MB Application: afterRenderComponent com_k2
زمان: 1.02 ms / 146.08 ms حافظه: 0.097 MB / 14.00 MB Application: afterDispatch
زمان: 9.54 ms / 155.63 ms حافظه: 1.291 MB / 15.29 MB Application: afterRender
جمع پرس و جوی بانک اطلاعاتی: 34.02 ms
15.87 MB (16,643,096 بایت)
44 پرس و جو ثبت شده 34.02 ms
- زمان پرس و جو: 0.65 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 3.937 MB سطرهای بازگشتی: 0
SELECT `data`
FROM `ve2rc_session`
WHERE `session_id` = X'6535393661373132633066633636336164313530366432366534303966343538'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.08 ms Checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.03 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.08 ms Preparing 0.02 ms Executing 0.03 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.03 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 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:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:854 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:414 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - زمان پرس و جو: 0.46 ms پس از آخرین پرس و جو: 1.09 ms حافظه پرس و جو: 0.020 MB حافظه قبل از پرس و جوی: 4.095 MB سطرهای بازگشتی: 0
SELECT `session_id`
FROM `ve2rc_session`
WHERE `session_id` = X'6535393661373132633066633636336164313530366432366534303966343538'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration Starting 0.04 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 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:856 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:414 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - زمان پرس و جو: 0.89 ms پس از آخرین پرس و جو: 0.08 ms حافظه پرس و جو: 0.004 MB حافظه قبل از پرس و جوی: 4.100 MB
INSERT INTO `ve2rc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6535393661373132633066633636336164313530366432366534303966343538', 1, 1715423420, 0, '', 0)توضیحات در جستجو ممکن نیست: INSERT INTO `ve2rc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6535393661373132633066633636336164313530366432366534303966343538', 1, 1715423420, 0, '', 0)Status Duration Starting 0.05 ms Checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init for update 0.02 ms Update 0.12 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.43 ms Closing tables 0.03 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 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:856 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:414 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - زمان پرس و جو: 0.72 ms پس از آخرین پرس و جو: 2.35 ms حافظه پرس و جو: 0.040 MB حافظه قبل از پرس و جوی: 4.319 MB سطرهای بازگشتی: 41
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ve2rc_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_extensions ref extension extension 82 const 42 Using index condition; Using where Status Duration Starting 0.04 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.23 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 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 - زمان پرس و جو: 0.54 ms پس از آخرین پرس و جو: 1.90 ms حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 4.524 MB سطرهای بازگشتی: 4
SELECT id, rules
FROM `ve2rc_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_viewlevels ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 4 Status Duration Starting 0.03 ms Checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.05 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.05 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.03 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 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.57 ms پس از آخرین پرس و جو: 0.06 ms حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 4.535 MB سطرهای بازگشتی: 1
SELECT b.id
FROM ve2rc_usergroups AS a
LEFT JOIN ve2rc_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.04 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.02 ms Unlocking tables 0.02 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 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.06 ms پس از آخرین پرس و جو: 0.53 ms حافظه پرس و جو: 0.030 MB حافظه قبل از پرس و جوی: 4.604 MB سطرهای بازگشتی: 93
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM ve2rc_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 ve2rc_extensions ref extension extension 82 const 131 Using index condition; Using where; با استفاده از مرتب سازی فایل Status Duration Starting 0.04 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.05 ms Optimizing 0.03 ms Statistics 0.04 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.02 ms Creating sort index 0.47 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.03 ms Closing tables 0.03 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.03 ms # فراخوانده فایل و شماره خط 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php: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 - زمان پرس و جو: 0.54 ms پس از آخرین پرس و جو: 8.37 ms حافظه پرس و جو: 0.024 MB حافظه قبل از پرس و جوی: 5.598 MB سطرهای بازگشتی: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ve2rc_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.04 ms Checking permissions 0.03 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.04 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 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:1662 17 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 16 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() به نظر می رسد خط زیر فراخونده شده باشد. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 13 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 12 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 11 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 10 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 9 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 8 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/ytshortcodes/ytshortcodes.php:34 7 plgSystemYtshortcodes->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 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.81 ms پس از آخرین پرس و جو: 0.11 ms حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 5.591 MB
UPDATE `ve2rc_extensions`
SET `params` = '{\"mediaversion\":\"30addfc745f7f4b2fd4d1e866c3a992f\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'توضیحات در جستجو ممکن نیست: UPDATE `ve2rc_extensions` SET `params` = '{\"mediaversion\":\"30addfc745f7f4b2fd4d1e866c3a992f\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.03 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.02 ms Init for update 0.06 ms Updating 0.09 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.33 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 13 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 12 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 11 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 10 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 9 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 8 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/ytshortcodes/ytshortcodes.php:34 7 plgSystemYtshortcodes->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 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 - زمان پرس و جو: 3.75 ms پس از آخرین پرس و جو: 19.02 ms حافظه پرس و جو: 0.313 MB حافظه قبل از پرس و جوی: 8.075 MB سطرهای بازگشتی: 226
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 ve2rc_menu AS m
LEFT JOIN ve2rc_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 899 Using index condition; Using where; با استفاده از مرتب سازی فایل 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 fpftaick_Hos94MEhr10.m.component_id 1 Using where Status Duration Starting 0.09 ms Checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.06 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.05 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.03 ms Creating sort index 3.07 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 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:445 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:561 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:1169 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.61 ms پس از آخرین پرس و جو: 10.64 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 9.761 MB سطرهای بازگشتی: 2
SELECT *
FROM ve2rc_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_languages ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 5 Using where; با استفاده از مرتب سازی فایل Status Duration Starting 0.04 ms Checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.03 ms Table lock 0.03 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.02 ms Creating sort index 0.06 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.03 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 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/Language/LanguageHelper.php:150 12 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 11 Joomla\CMS\Application\SiteApplication->getParams() JROOT/components/com_k2/helpers/utilities.php:248 10 K2HelperUtilities::getParams() JROOT/administrator/components/com_k2/helpers/html.php:244 9 K2HelperHTML::loadHeadIncludes() JROOT/plugins/system/k2/k2.php:390 8 plgSystemK2->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1218 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.62 ms پس از آخرین پرس و جو: 2.49 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 10.002 MB سطرهای بازگشتی: 4
SELECT id, home, template, s.params
FROM ve2rc_template_styles as s
LEFT JOIN ve2rc_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 5 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 fpftaick_Hos94MEhr10.s.template,const 1 Using index condition; Using where Status Duration Starting 0.06 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.08 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.03 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 19 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/HTML/HTMLHelper.php:365 18 Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() JROOT/libraries/src/HTML/HTMLHelper.php:712 17 Joomla\CMS\HTML\HTMLHelper::script() به نظر می رسد خط زیر فراخونده شده باشد. 16 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 15 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 14 Joomla\CMS\HTML\HTMLHelper::_() JROOT/libraries/cms/html/jquery.php:52 13 JHtmlJquery::framework() به نظر می رسد خط زیر فراخونده شده باشد. 12 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 11 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 10 Joomla\CMS\HTML\HTMLHelper::_() JROOT/administrator/components/com_k2/helpers/html.php:268 9 K2HelperHTML::loadHeadIncludes() JROOT/plugins/system/k2/k2.php:390 8 plgSystemK2->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1218 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.14 ms پس از آخرین پرس و جو: 1.54 ms حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 10.098 MB سطرهای بازگشتی: 41
SELECT `id`,`name`,`rules`,`parent_id`
FROM `ve2rc_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_fsj_main','com_fsj_transman','com_installer','com_jce','com_jch_optimize','com_joomgallery','com_joomlaupdate','com_k2','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_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_assets range idx_asset_name idx_asset_name 202 NULL 42 Using index condition Status Duration Starting 0.06 ms Checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.02 ms Init 0.06 ms Optimizing 0.02 ms Statistics 0.14 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.38 ms End of update loop 0.05 ms Query end 0.02 ms Commit 0.05 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 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/libraries/src/Access/Access.php:429 11 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 10 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 9 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 8 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 7 Joomla\CMS\User\User->authorise() JROOT/components/com_k2/k2.php:16 6 require_once JROOT/components/com_k2/k2.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.57 ms پس از آخرین پرس و جو: 9.59 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 11.225 MB سطرهای بازگشتی: 39
SELECT id
FROM ve2rc_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_k2_categories range category,published,access,trash category 8 NULL 39 Using where; Using index Status Duration Starting 0.04 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.03 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.06 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 13 JDatabaseDriver->loadColumn() JROOT/components/com_k2/helpers/permissions.php:225 12 K2HelperPermissions::canAddItem() JROOT/components/com_k2/views/item/view.html.php:37 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.56 ms پس از آخرین پرس و جو: 0.07 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 11.231 MB سطرهای بازگشتی: 1
SELECT *
FROM ve2rc_k2_items
WHERE id=247
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_k2_items const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Unlocking tables 0.02 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:33 12 K2ModelItem->getData() JROOT/components/com_k2/views/item/view.html.php:44 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.01 ms پس از آخرین پرس و جو: 0.55 ms حافظه پرس و جو: 0.027 MB حافظه قبل از پرس و جوی: 11.277 MB سطرهای بازگشتی: 14
SHOW FULL COLUMNS
FROM `ve2rc_k2_categories`توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `ve2rc_k2_categories`Status Duration Starting 0.03 ms Checking permissions 0.02 ms Closing tables 0.02 ms Opening tables 0.28 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.03 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.02 ms Filling schema table 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms Checking permissions 0.08 ms Closing tables 0.02 ms Executing 0.02 ms Sending data 0.05 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.09 ms Closing tables 0.02 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.03 ms # فراخوانده فایل و شماره خط 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 17 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 15 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_k2/tables/k2category.php:34 14 TableK2Category->__construct() JROOT/libraries/src/Table/Table.php:328 13 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_k2/models/item.php:64 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.53 ms پس از آخرین پرس و جو: 0.45 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 11.316 MB سطرهای بازگشتی: 1
SELECT *
FROM ve2rc_k2_categories
WHERE id = '79'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_k2_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.04 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Unlocking tables 0.02 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:61 13 TableK2Category->load() JROOT/components/com_k2/models/item.php:65 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.20 ms پس از آخرین پرس و جو: 1.70 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 11.484 MB سطرهای بازگشتی: 0
SELECT tag.*
FROM ve2rc_k2_tags AS tag JOIN ve2rc_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 247
ORDER BY xref.id ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE xref ref tagID,itemID itemID 4 const 1 Using where 1 SIMPLE tag eq_ref PRIMARY,published PRIMARY 4 fpftaick_Hos94MEhr10.xref.tagID 1 Using where Status Duration Starting 0.04 ms Checking permissions 0.02 ms Opening tables 0.60 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.03 ms Query end 0.03 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1194 13 K2ModelItem->getItemTags() JROOT/components/com_k2/models/item.php:104 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.75 ms پس از آخرین پرس و جو: 0.09 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 11.493 MB سطرهای بازگشتی: 0
SELECT *
FROM ve2rc_k2_attachments
WHERE itemID=247id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_k2_attachments ref itemID itemID 4 const 1 Status Duration Starting 0.03 ms Checking permissions 0.02 ms Opening tables 0.27 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.03 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1422 13 K2ModelItem->getItemAttachments() JROOT/components/com_k2/models/item.php:156 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.45 ms پس از آخرین پرس و جو: 0.05 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 11.500 MB سطرهای بازگشتی: 0
SELECT *
FROM ve2rc_k2_rating
WHERE itemID = 247id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL کلید شاخصی برای استفاده نیست NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.03 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.02 ms End of update loop 0.02 ms Query end 0.03 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.03 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:907 14 K2ModelItem->getRating() JROOT/components/com_k2/models/item.php:951 13 K2ModelItem->getVotesPercentage() JROOT/components/com_k2/models/item.php:161 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.99 ms پس از آخرین پرس و جو: 0.99 ms حافظه پرس و جو: 0.029 MB حافظه قبل از پرس و جوی: 11.611 MB سطرهای بازگشتی: 16
SHOW FULL COLUMNS
FROM `ve2rc_users`توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `ve2rc_users`Status Duration Starting 0.03 ms Checking permissions 0.02 ms Closing tables 0.02 ms Opening tables 0.28 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.02 ms Filling schema table 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms Checking permissions 0.07 ms Closing tables 0.02 ms Executing 0.02 ms Sending data 0.05 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.08 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.04 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 22 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 21 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 20 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/User.php:41 19 Joomla\CMS\Table\User->__construct() JROOT/libraries/src/Table/Table.php:328 18 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/User/User.php:603 17 Joomla\CMS\User\User::getTable() JROOT/libraries/src/User/User.php:877 16 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 15 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 14 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 13 Joomla\CMS\Factory::getUser() JROOT/components/com_k2/models/item.php:201 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.56 ms پس از آخرین پرس و جو: 0.09 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 11.640 MB سطرهای بازگشتی: 0
SELECT *
FROM `ve2rc_users`
WHERE `id` = 858id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL کلید شاخصی برای استفاده نیست NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.03 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.05 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.04 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.05 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 18 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:87 17 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 16 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 15 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 14 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 13 Joomla\CMS\Factory::getUser() JROOT/components/com_k2/models/item.php:201 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.53 ms پس از آخرین پرس و جو: 1.13 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 11.658 MB سطرهای بازگشتی: 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM ve2rc_k2_users
WHERE userID=858id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_k2_users ref userID userID 4 const 1 Status Duration Starting 0.03 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.03 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.03 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.03 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1674 13 K2ModelItem->getUserProfile() JROOT/components/com_k2/models/item.php:205 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.40 ms پس از آخرین پرس و جو: 4.84 ms حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 12.149 MB سطرهای بازگشتی: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM ve2rc_fields AS a
LEFT JOIN `ve2rc_languages` AS l
ON l.lang_code = a.language
LEFT JOIN ve2rc_users AS uc
ON uc.id=a.checked_out
LEFT JOIN ve2rc_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN ve2rc_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN ve2rc_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_k2.item-media'
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; با استفاده از مرتب سازی فایل 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 fpftaick_Hos94MEhr10.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 fpftaick_Hos94MEhr10.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 fpftaick_Hos94MEhr10.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 fpftaick_Hos94MEhr10.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 fpftaick_Hos94MEhr10.a.group_id 1 Using where Status Duration Starting 0.11 ms Checking permissions 0.02 ms Opening tables 0.07 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.09 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.04 ms Creating tmp table 0.06 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.30 ms Creating sort index 0.03 ms Removing tmp table 0.09 ms Creating sort index 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.03 ms Closing tables 0.03 ms Unlocking tables 0.03 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.03 ms # فراخوانده فایل و شماره خط 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 19 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 18 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 17 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 16 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 15 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:589 12 K2ModelItem->execPlugins() JROOT/components/com_k2/views/item/view.html.php:87 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.24 ms پس از آخرین پرس و جو: 1.17 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 12.208 MB سطرهای بازگشتی: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM ve2rc_fields AS a
LEFT JOIN `ve2rc_languages` AS l
ON l.lang_code = a.language
LEFT JOIN ve2rc_users AS uc
ON uc.id=a.checked_out
LEFT JOIN ve2rc_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN ve2rc_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN ve2rc_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `ve2rc_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.item'
AND (fc.category_id IS NULL OR fc.category_id IN (79,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; با استفاده از مرتب سازی فایل 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 fpftaick_Hos94MEhr10.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 fpftaick_Hos94MEhr10.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 fpftaick_Hos94MEhr10.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 fpftaick_Hos94MEhr10.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 fpftaick_Hos94MEhr10.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 fpftaick_Hos94MEhr10.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.09 ms Checking permissions 0.02 ms Opening tables 0.06 ms After opening tables 0.02 ms System lock 0.03 ms Table lock 0.02 ms Init 0.05 ms Optimizing 0.04 ms Statistics 0.10 ms Preparing 0.06 ms Creating tmp table 0.06 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.25 ms Creating sort index 0.03 ms Removing tmp table 0.06 ms Creating sort index 0.02 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.05 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 19 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 18 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 17 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 16 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 15 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:660 12 K2ModelItem->execPlugins() JROOT/components/com_k2/views/item/view.html.php:87 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.09 ms پس از آخرین پرس و جو: 3.24 ms حافظه پرس و جو: 0.033 MB حافظه قبل از پرس و جوی: 12.550 MB سطرهای بازگشتی: 36
SHOW FULL COLUMNS
FROM `ve2rc_k2_items`توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `ve2rc_k2_items`Status Duration Starting 0.03 ms Checking permissions 0.02 ms Closing tables 0.02 ms Opening tables 0.22 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.02 ms Filling schema table 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms Checking permissions 0.10 ms Closing tables 0.02 ms Executing 0.02 ms Sending data 0.09 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Removing tmp table 0.08 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.03 ms # فراخوانده فایل و شماره خط 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 17 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 15 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_k2/tables/k2item.php:56 14 TableK2Item->__construct() JROOT/libraries/src/Table/Table.php:328 13 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_k2/models/item.php:832 12 K2ModelItem->hit() JROOT/components/com_k2/views/item/view.html.php:146 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.79 ms پس از آخرین پرس و جو: 0.17 ms حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 12.595 MB
UPDATE ve2rc_k2_items
SET `hits` = (`hits` + 1)
WHERE `id` = '247'توضیحات در جستجو ممکن نیست: UPDATE ve2rc_k2_items SET `hits` = (`hits` + 1) WHERE `id` = '247'Status Duration Starting 0.03 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init for update 0.04 ms Updating 0.12 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.30 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 13 Joomla\CMS\Table\Table->hit() JROOT/components/com_k2/models/item.php:833 12 K2ModelItem->hit() JROOT/components/com_k2/views/item/view.html.php:146 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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 پس از آخرین پرس و جو: 0.11 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 12.599 MB سطرهای بازگشتی: 0
SELECT *
FROM ve2rc_k2_comments
WHERE itemID=247
AND published=1
ORDER BY commentDate DESC
LIMIT 0, 10id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_k2_comments range itemID,published,latestComments,countComments latestComments 4 NULL 1 Using where Status Duration Starting 0.03 ms Checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.05 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.03 ms Query end 0.03 ms Commit 0.03 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 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/components/com_k2/models/item.php:1443 12 K2ModelItem->getItemComments() JROOT/components/com_k2/views/item/view.html.php:227 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.99 ms پس از آخرین پرس و جو: 0.86 ms حافظه پرس و جو: 0.056 MB حافظه قبل از پرس و جوی: 12.689 MB سطرهای بازگشتی: 5
SELECT i.*, c.alias AS categoryalias
FROM ve2rc_k2_items AS i
LEFT JOIN ve2rc_k2_categories c
ON c.id = i.catid
WHERE i.id != 247
AND i.published = 1
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-05-11 10:30:20')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-11 10:30:20')
AND i.access IN(1,1)
AND i.trash = 0
AND i.created_by = 858
AND i.created_by_alias=''
AND c.published = 1
AND c.access IN(1,1)
AND c.trash = 0
ORDER BY i.created DESC
LIMIT 0, 5id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i range PRIMARY,catid,created_by,idx_item created_by 8 NULL 18 Using index condition; Using where; با استفاده از مرتب سازی فایل 1 SIMPLE c eq_ref PRIMARY,category,published,access,trash PRIMARY 4 fpftaick_Hos94MEhr10.i.catid 1 Using where Status Duration Starting 0.08 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.05 ms Optimizing 0.04 ms Statistics 0.16 ms Preparing 0.07 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.03 ms Creating sort index 0.21 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.05 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 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/components/com_k2/models/itemlist.php:563 12 K2ModelItemlist->getAuthorLatest() JROOT/components/com_k2/views/item/view.html.php:266 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.72 ms پس از آخرین پرس و جو: 0.56 ms حافظه پرس و جو: 0.038 MB حافظه قبل از پرس و جوی: 12.745 MB سطرهای بازگشتی: 1
SELECT *
FROM ve2rc_k2_items
WHERE id < 247
AND catid = 79
AND published = 1
AND trash = 0
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-05-11 10:30:20')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-05-11 10:30:20')
AND access IN (1,1)
ORDER BY id DESC
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_k2_items range PRIMARY,catid,idx_item catid 8 NULL 16 Using where Status Duration Starting 0.05 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.04 ms Optimizing 0.03 ms Statistics 0.10 ms Preparing 0.06 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.11 ms End of update loop 0.04 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1597 12 K2ModelItem->getPreviousItem() JROOT/components/com_k2/views/item/view.html.php:290 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.86 ms پس از آخرین پرس و جو: 0.50 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 12.815 MB سطرهای بازگشتی: 0
SELECT tag.*
FROM ve2rc_k2_tags AS tag JOIN ve2rc_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 244
ORDER BY xref.id ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE xref ref tagID,itemID itemID 4 const 1 Using where 1 SIMPLE tag eq_ref PRIMARY,published PRIMARY 4 fpftaick_Hos94MEhr10.xref.tagID 1 Using where Status Duration Starting 0.32 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.03 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.03 ms Closing tables 0.03 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.03 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1194 13 K2ModelItem->getItemTags() JROOT/components/com_k2/models/item.php:104 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:292 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.51 ms پس از آخرین پرس و جو: 0.08 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 12.823 MB سطرهای بازگشتی: 0
SELECT *
FROM ve2rc_k2_attachments
WHERE itemID=244id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_k2_attachments ref itemID itemID 4 const 1 Status Duration Starting 0.03 ms Checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.04 ms End of update loop 0.03 ms Query end 0.04 ms Commit 0.03 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1422 13 K2ModelItem->getItemAttachments() JROOT/components/com_k2/models/item.php:156 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:292 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.49 ms پس از آخرین پرس و جو: 0.04 ms حافظه پرس و جو: 0.024 MB حافظه قبل از پرس و جوی: 12.836 MB سطرهای بازگشتی: 0
SELECT *
FROM ve2rc_k2_rating
WHERE itemID = 244id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL کلید شاخصی برای استفاده نیست NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.03 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.03 ms Table lock 0.03 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.02 ms End of update loop 0.03 ms Query end 0.03 ms Commit 0.03 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.03 ms # فراخوانده فایل و شماره خط 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:907 14 K2ModelItem->getRating() JROOT/components/com_k2/models/item.php:951 13 K2ModelItem->getVotesPercentage() JROOT/components/com_k2/models/item.php:161 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:292 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.48 ms پس از آخرین پرس و جو: 0.10 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 12.850 MB سطرهای بازگشتی: 1
SELECT *
FROM `ve2rc_users`
WHERE `id` = 1105id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_users const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Unlocking tables 0.02 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 18 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:87 17 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 16 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 15 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 14 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 13 Joomla\CMS\Factory::getUser() JROOT/components/com_k2/models/item.php:201 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:292 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.59 ms پس از آخرین پرس و جو: 2.56 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 13.666 MB سطرهای بازگشتی: 2
SELECT `g`.`id`,`g`.`title`
FROM `ve2rc_usergroups` AS g
INNER JOIN `ve2rc_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 1105id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY PRIMARY 4 const 2 Using index 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 fpftaick_Hos94MEhr10.m.group_id 1 Status Duration Starting 0.03 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.04 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.04 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.04 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.03 ms # فراخوانده فایل و شماره خط 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 18 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Table/User.php:112 17 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 16 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 15 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 14 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 13 Joomla\CMS\Factory::getUser() JROOT/components/com_k2/models/item.php:201 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:292 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.52 ms پس از آخرین پرس و جو: 0.76 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 13.674 MB سطرهای بازگشتی: 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM ve2rc_k2_users
WHERE userID=1105id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_k2_users ref userID userID 4 const 1 Status Duration Starting 0.03 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.05 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.05 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1674 14 K2ModelItem->getUserProfile() JROOT/components/com_k2/helpers/utilities.php:45 13 K2HelperUtilities::getAvatar() JROOT/components/com_k2/models/item.php:204 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:292 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.45 ms پس از آخرین پرس و جو: 0.03 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 13.681 MB سطرهای بازگشتی: 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM ve2rc_k2_users
WHERE userID=1105id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_k2_users ref userID userID 4 const 1 Status Duration Starting 0.03 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 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/components/com_k2/models/item.php:1674 13 K2ModelItem->getUserProfile() JROOT/components/com_k2/models/item.php:205 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:292 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.70 ms پس از آخرین پرس و جو: 0.43 ms حافظه پرس و جو: 0.038 MB حافظه قبل از پرس و جوی: 13.680 MB سطرهای بازگشتی: 1
SELECT *
FROM ve2rc_k2_items
WHERE id > 247
AND catid = 79
AND published = 1
AND trash = 0
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-05-11 10:30:20')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-05-11 10:30:20')
AND access IN (1,1)
ORDER BY id ASC
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_k2_items range PRIMARY,catid,idx_item PRIMARY 4 NULL 461 Using where Status Duration Starting 0.04 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.04 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.07 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.14 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1656 12 K2ModelItem->getNextItem() JROOT/components/com_k2/views/item/view.html.php:331 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.54 ms پس از آخرین پرس و جو: 0.49 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 13.751 MB سطرهای بازگشتی: 0
SELECT tag.*
FROM ve2rc_k2_tags AS tag JOIN ve2rc_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 248
ORDER BY xref.id ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE xref ref tagID,itemID itemID 4 const 1 Using where 1 SIMPLE tag eq_ref PRIMARY,published PRIMARY 4 fpftaick_Hos94MEhr10.xref.tagID 1 Using where Status Duration Starting 0.03 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1194 13 K2ModelItem->getItemTags() JROOT/components/com_k2/models/item.php:104 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:333 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.50 ms پس از آخرین پرس و جو: 0.10 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 13.759 MB سطرهای بازگشتی: 0
SELECT *
FROM ve2rc_k2_attachments
WHERE itemID=248id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_k2_attachments ref itemID itemID 4 const 1 Status Duration Starting 0.03 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.03 ms Query end 0.05 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.03 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1422 13 K2ModelItem->getItemAttachments() JROOT/components/com_k2/models/item.php:156 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:333 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.47 ms پس از آخرین پرس و جو: 0.04 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 13.766 MB سطرهای بازگشتی: 0
SELECT *
FROM ve2rc_k2_rating
WHERE itemID = 248id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL کلید شاخصی برای استفاده نیست NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.04 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.02 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.04 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.03 ms # فراخوانده فایل و شماره خط 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:907 14 K2ModelItem->getRating() JROOT/components/com_k2/models/item.php:951 13 K2ModelItem->getVotesPercentage() JROOT/components/com_k2/models/item.php:161 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:333 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.52 ms پس از آخرین پرس و جو: 0.64 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 13.774 MB سطرهای بازگشتی: 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM ve2rc_k2_users
WHERE userID=1105id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_k2_users ref userID userID 4 const 1 Status Duration Starting 0.03 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.05 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.05 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.03 ms # فراخوانده فایل و شماره خط 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1674 14 K2ModelItem->getUserProfile() JROOT/components/com_k2/helpers/utilities.php:45 13 K2HelperUtilities::getAvatar() JROOT/components/com_k2/models/item.php:204 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:333 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.46 ms پس از آخرین پرس و جو: 0.04 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 13.781 MB سطرهای بازگشتی: 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM ve2rc_k2_users
WHERE userID=1105id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_k2_users ref userID userID 4 const 1 Status Duration Starting 0.03 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.03 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 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/components/com_k2/models/item.php:1674 13 K2ModelItem->getUserProfile() JROOT/components/com_k2/models/item.php:205 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:333 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.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.55 ms پس از آخرین پرس و جو: 12.17 ms حافظه پرس و جو: 0.020 MB حافظه قبل از پرس و جوی: 15.291 MB سطرهای بازگشتی: 1
SELECT template
FROM ve2rc_template_styles
WHERE home = 1
AND client_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_template_styles ALL idx_client_id,idx_client_id_home کلید شاخصی برای استفاده نیست NULL NULL 5 Using where Status Duration Starting 0.03 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.06 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/yt.php:243 8 plgSystemYt->nameOfSJTemplate() JROOT/plugins/system/yt/yt.php:168 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:1146 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
31 نوع پرس و جو ثبت شده
انتخاب جداول:
5 × SELECT id, gender, description, image, url, `
group`, plugins
FROM ve2rc_k2_users3 × SELECT tag.*
FROM ve2rc_k2_tags AS tag JOIN ve2rc_k2_tags_xref AS xref
ON tag.id = xref.tagID3 × SELECT *
FROM ve2rc_k2_rating3 × SELECT *
FROM ve2rc_k2_attachments2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ve2rc_extensions`2 × SELECT *
FROM ve2rc_k2_items2 × SELECT *
FROM `ve2rc_users`1 × SELECT `data`
FROM `ve2rc_session`1 × SELECT `g`.`id`,`g`.`title`
FROM `ve2rc_usergroups` AS g
INNER JOIN `ve2rc_user_usergroup_map` AS m
ON m.group_id = g.id1 × SELECT i.*, c.alias AS categoryalias
FROM ve2rc_k2_items AS i
LEFT JOIN ve2rc_k2_categories c
ON c.id = i.catid1 × SELECT *
FROM ve2rc_k2_comments1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM ve2rc_fields AS a
LEFT JOIN `ve2rc_languages` AS l
ON l.lang_code = a.language
LEFT JOIN ve2rc_users AS uc
ON uc.id=a.checked_out
LEFT JOIN ve2rc_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN ve2rc_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN ve2rc_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `ve2rc_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM ve2rc_fields AS a
LEFT JOIN `ve2rc_languages` AS l
ON l.lang_code = a.language
LEFT JOIN ve2rc_users AS uc
ON uc.id=a.checked_out
LEFT JOIN ve2rc_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN ve2rc_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN ve2rc_fields_groups AS g
ON g.id = a.group_id1 × SELECT *
FROM ve2rc_k2_categories1 × SELECT `session_id`
FROM `ve2rc_session`1 × SELECT *
FROM ve2rc_k2_items1 × SELECT id
FROM ve2rc_k2_categories1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `ve2rc_assets`1 × SELECT id, home, template, s.params
FROM ve2rc_template_styles as s
LEFT JOIN ve2rc_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM ve2rc_languages1 × 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 ve2rc_menu AS m
LEFT JOIN ve2rc_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM ve2rc_extensions1 × SELECT b.id
FROM ve2rc_usergroups AS a
LEFT JOIN ve2rc_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `ve2rc_viewlevels1 × SELECT template
FROM ve2rc_template_styles
سایر جداول:
1 × INSERT INTO `ve2rc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6535393661373132633066633636336164313530366432366534303966343538', 1, 1715423420, 0, '', 01 × UPDATE `ve2rc_extensions`
SET `params` = '{\"mediaversion\":\"30addfc745f7f4b2fd4d1e866c3a992f\"}'1 × SHOW FULL COLUMNS
FROM `ve2rc_k2_categories1 × SHOW FULL COLUMNS
FROM `ve2rc_users1 × SHOW FULL COLUMNS
FROM `ve2rc_k2_items1 × UPDATE ve2rc_k2_items
SET `hits` = (`hits` + 1)