براساس شواهد علمی، مجمع جهانی بهداشت به عنوان یک توصیه عمومی تصویب کرده است که نوزادان باید به مدت شش ماه به طور انحصاری از شیر مادر تغذیه شوند و مادران تغذیه با شیر خود را تا دو سالگی ادامه دهند
شیر مادر تقریباً سرشار از ویتامین ها، پروتئین و چربی است و حاوی آنتی بادی هایی است که کودک را در برابر بیماری های ویروسی مقاوم می کند و این بیماری ها همچنین بیماری های عفونی مانند عفونت گوش، بیماری های تنفسی و اسهال در آن ها کمتر دیده می شود.
665 K2_VIEWS
مسیبی
پست الکترونیکی این آدرس ایمیل توسط spambots حفاظت می شود. برای دیدن شما نیاز به جاوا اسکریپت داریدآخرینها از مسیبی
اشکال یابی جوملا
{
"__default": {
"session": {
"counter": 4,
"timer": {
"start": 1715937551,
"last": 1715937555,
"now": 1715937556
}
},
"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": {
"56674bb427881fa3cdc68973c7dd45ffb02278e2": {
"link": "https://yasrebihospital.ir/index.php/news/health-clinic/milk-monitoring/item/552-2019-12-01-12-08-27?tmpl=component&print=1",
"expiry": 1715937555
},
"406d544f630a46cc07f37e23ef9023b1e29545f3": {
"link": "https://yasrebihospital.ir/index.php/news/health-clinic/milk-monitoring/item/608-2019-12-18-06-12-30?tmpl=component&print=1",
"expiry": 1715937556
}
}
}
}
}
زمان
حافظه
زمان: 11.77 ms / 11.77 ms حافظه: 1.840 MB / 2.23 MB Application: afterLoad
زمان: 48.89 ms / 60.66 ms حافظه: 5.648 MB / 7.88 MB Application: afterInitialise
زمان: 23.64 ms / 84.30 ms حافظه: 2.135 MB / 10.01 MB Application: afterRoute
زمان: 0.54 ms / 84.84 ms حافظه: 0.045 MB / 10.06 MB Application: beforeRenderComponent com_k2
زمان: 0.16 ms / 85.01 ms حافظه: 0.027 MB / 10.08 MB Application: Before Access::preloadComponents (all components)
زمان: 1.91 ms / 86.91 ms حافظه: 0.056 MB / 10.14 MB Application: After Access::preloadComponents (all components)
زمان: 0.03 ms / 86.95 ms حافظه: -0.005 MB / 10.14 MB Application: Before Access::getAssetRules (id:411 name:com_k2)
زمان: 0.38 ms / 87.33 ms حافظه: 0.026 MB / 10.16 MB Application: After Access::getAssetRules (id:411 name:com_k2)
زمان: 53.61 ms / 140.93 ms حافظه: 3.707 MB / 13.87 MB Application: afterRenderComponent com_k2
زمان: 1.03 ms / 141.96 ms حافظه: 0.097 MB / 13.96 MB Application: afterDispatch
زمان: 8.79 ms / 150.76 ms حافظه: 1.302 MB / 15.27 MB Application: afterRender
جمع پرس و جوی بانک اطلاعاتی: 39.07 ms
15.78 MB (16,544,144 بایت)
38 پرس و جو ثبت شده 39.07 ms
- زمان پرس و جو: 0.65 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 3.942 MB سطرهای بازگشتی: 1
SELECT `data`
FROM `ve2rc_session`
WHERE `session_id` = X'6262643336663864323039363035656564363036666236303637343139633263'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.09 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.08 ms Preparing 0.02 ms Unlocking tables 0.02 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.02 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 # فراخوانده فایل و شماره خط 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.85 ms پس از آخرین پرس و جو: 2.94 ms حافظه پرس و جو: 0.040 MB حافظه قبل از پرس و جوی: 4.307 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.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 0.03 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.04 ms Executing 0.02 ms Sending data 0.25 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.52 ms پس از آخرین پرس و جو: 1.79 ms حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 4.512 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.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.02 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.05 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 # فراخوانده فایل و شماره خط 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.59 ms پس از آخرین پرس و جو: 0.07 ms حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 4.524 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.05 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.07 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.25 ms پس از آخرین پرس و جو: 0.57 ms حافظه پرس و جو: 0.030 MB حافظه قبل از پرس و جوی: 4.592 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.06 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.02 ms Creating sort index 0.64 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 # فراخوانده فایل و شماره خط 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.65 ms پس از آخرین پرس و جو: 8.17 ms حافظه پرس و جو: 0.024 MB حافظه قبل از پرس و جوی: 5.587 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.05 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.05 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.89 ms پس از آخرین پرس و جو: 0.12 ms حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 5.579 MB
UPDATE `ve2rc_extensions`
SET `params` = '{\"mediaversion\":\"40e21e85f7ea77add0106a07fa6f7a31\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'توضیحات در جستجو ممکن نیست: UPDATE `ve2rc_extensions` SET `params` = '{\"mediaversion\":\"40e21e85f7ea77add0106a07fa6f7a31\"}' WHERE `type` = 'library' AND `element` = 'joomla'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 for update 0.07 ms Updating 0.09 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.36 ms Closing tables 0.04 ms Unlocking tables 0.02 ms Closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 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 - زمان پرس و جو: 7.57 ms پس از آخرین پرس و جو: 18.43 ms حافظه پرس و جو: 0.313 MB حافظه قبل از پرس و جوی: 8.063 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.11 ms Checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.03 ms System lock 0.03 ms Table lock 0.02 ms Init 0.05 ms Optimizing 0.04 ms Statistics 0.09 ms Preparing 0.05 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.04 ms Creating sort index 6.72 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.03 ms Starting cleanup 0.02 ms Freeing items 0.03 ms Updating status 0.04 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.80 ms پس از آخرین پرس و جو: 10.16 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 9.749 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.05 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.03 ms Table lock 0.02 ms Init 0.04 ms Optimizing 0.03 ms Statistics 0.03 ms Preparing 0.03 ms Sorting result 0.03 ms Executing 0.03 ms Sending data 0.03 ms Creating sort index 0.14 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: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.85 ms پس از آخرین پرس و جو: 1.91 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 9.991 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.07 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.04 ms Optimizing 0.04 ms Statistics 0.11 ms Preparing 0.05 ms Executing 0.02 ms Sending data 0.13 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.03 ms Starting cleanup 0.02 ms Freeing items 0.03 ms Updating status 0.04 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.76 ms پس از آخرین پرس و جو: 1.39 ms حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 10.087 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.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.09 ms Optimizing 0.03 ms Statistics 0.29 ms Preparing 0.05 ms Executing 0.02 ms Sending data 0.73 ms End of update loop 0.03 ms Query end 0.10 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 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.89 ms پس از آخرین پرس و جو: 8.69 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 11.213 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.06 ms Checking permissions 0.03 ms Opening tables 0.04 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.15 ms Preparing 0.06 ms Executing 0.02 ms Sending data 0.09 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.07 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.03 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: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.81 ms پس از آخرین پرس و جو: 0.07 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 11.220 MB سطرهای بازگشتی: 1
SELECT *
FROM ve2rc_k2_items
WHERE id=608
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.04 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.05 ms System lock 0.02 ms Table lock 0.02 ms Init 0.06 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.02 ms Unlocking tables 0.03 ms Preparing 0.03 ms Executing 0.03 ms Sending data 0.07 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.03 ms Closing tables 0.03 ms Unlocking tables 0.02 ms Closing tables 0.03 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.66 ms پس از آخرین پرس و جو: 0.48 ms حافظه پرس و جو: 0.027 MB حافظه قبل از پرس و جوی: 11.266 MB سطرهای بازگشتی: 14
SHOW FULL COLUMNS
FROM `ve2rc_k2_categories`توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `ve2rc_k2_categories`Status Duration Starting 0.05 ms Checking permissions 0.02 ms Closing tables 0.02 ms Opening tables 0.36 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.02 ms Filling schema table 0.03 ms Opening tables 0.03 ms After opening tables 0.02 ms Checking permissions 0.14 ms Closing tables 0.03 ms Executing 0.02 ms Sending data 0.07 ms End of update loop 0.02 ms Query end 0.03 ms Commit 0.02 ms Closing tables 0.02 ms Removing tmp table 0.14 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.27 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/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.64 ms پس از آخرین پرس و جو: 0.40 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 11.304 MB سطرهای بازگشتی: 1
SELECT *
FROM ve2rc_k2_categories
WHERE id = '125'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.05 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.04 ms Optimizing 0.03 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.03 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 - زمان پرس و جو: 0.74 ms پس از آخرین پرس و جو: 1.62 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 11.476 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 = 608
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.06 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.02 ms Init 0.04 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.04 ms Sorting result 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.03 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 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.61 ms پس از آخرین پرس و جو: 0.06 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 11.486 MB سطرهای بازگشتی: 0
SELECT *
FROM ve2rc_k2_attachments
WHERE itemID=608id 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.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.05 ms Preparing 0.04 ms Executing 0.02 ms Sending data 0.04 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.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 # فراخوانده فایل و شماره خط 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.60 ms پس از آخرین پرس و جو: 0.03 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 11.494 MB سطرهای بازگشتی: 0
SELECT *
FROM ve2rc_k2_rating
WHERE itemID = 608id 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.04 ms After opening tables 0.02 ms System lock 0.03 ms Table lock 0.03 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.04 ms Preparing 0.03 ms Executing 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.03 ms Starting cleanup 0.02 ms Freeing items 0.03 ms Updating status 0.03 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 - زمان پرس و جو: 1.60 ms پس از آخرین پرس و جو: 0.93 ms حافظه پرس و جو: 0.029 MB حافظه قبل از پرس و جوی: 11.604 MB سطرهای بازگشتی: 16
SHOW FULL COLUMNS
FROM `ve2rc_users`توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `ve2rc_users`Status Duration Starting 0.06 ms Checking permissions 0.03 ms Closing tables 0.03 ms Opening tables 0.39 ms After opening tables 0.04 ms System lock 0.03 ms Table lock 0.03 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.03 ms Preparing 0.04 ms Executing 0.03 ms Filling schema table 0.03 ms Opening tables 0.05 ms After opening tables 0.03 ms Checking permissions 0.14 ms Closing tables 0.03 ms Executing 0.03 ms Sending data 0.09 ms End of update loop 0.03 ms Query end 0.03 ms Commit 0.02 ms Closing tables 0.02 ms Removing tmp table 0.14 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.04 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.64 ms پس از آخرین پرس و جو: 0.09 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 11.634 MB سطرهای بازگشتی: 1
SELECT *
FROM `ve2rc_users`
WHERE `id` = 9880id 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.05 ms Checking permissions 0.03 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.05 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.03 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.70 ms پس از آخرین پرس و جو: 2.16 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 12.387 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` = 9880id 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.06 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.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.04 ms Executing 0.02 ms Sending data 0.06 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.03 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: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: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.65 ms پس از آخرین پرس و جو: 0.75 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 12.395 MB سطرهای بازگشتی: 1
SELECT id, gender, description, image, url, `
group`, plugins
FROM ve2rc_k2_users
WHERE userID=9880id 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.05 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.03 ms System lock 0.03 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.06 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.04 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: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.81 ms پس از آخرین پرس و جو: 4.54 ms حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 12.883 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.15 ms Checking permissions 0.03 ms Opening tables 0.07 ms After opening tables 0.02 ms System lock 0.03 ms Table lock 0.02 ms Init 0.07 ms Optimizing 0.06 ms Statistics 0.17 ms Preparing 0.07 ms Creating tmp table 0.10 ms Sorting result 0.04 ms Executing 0.02 ms Sending data 0.43 ms Creating sort index 0.06 ms Removing tmp table 0.16 ms Creating sort index 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.03 ms Starting cleanup 0.02 ms Freeing items 0.03 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: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.62 ms پس از آخرین پرس و جو: 0.95 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 12.943 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 (125,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.17 ms Checking permissions 0.03 ms Opening tables 0.06 ms After opening tables 0.02 ms System lock 0.03 ms Table lock 0.02 ms Init 0.07 ms Optimizing 0.05 ms Statistics 0.12 ms Preparing 0.06 ms Creating tmp table 0.09 ms Sorting result 0.04 ms Executing 0.02 ms Sending data 0.39 ms Creating sort index 0.05 ms Removing tmp table 0.10 ms Creating sort index 0.02 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.03 ms Starting cleanup 0.02 ms Freeing items 0.03 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.49 ms پس از آخرین پرس و جو: 3.06 ms حافظه پرس و جو: 0.033 MB حافظه قبل از پرس و جوی: 13.285 MB سطرهای بازگشتی: 36
SHOW FULL COLUMNS
FROM `ve2rc_k2_items`توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `ve2rc_k2_items`Status Duration Starting 0.05 ms Checking permissions 0.03 ms Closing tables 0.02 ms Opening tables 0.29 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.02 ms Filling schema table 0.03 ms Opening tables 0.03 ms After opening tables 0.02 ms Checking permissions 0.20 ms Closing tables 0.03 ms Executing 0.02 ms Sending data 0.12 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.13 ms Closing tables 0.02 ms Unlocking tables 0.04 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.04 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 - زمان پرس و جو: 1.03 ms پس از آخرین پرس و جو: 0.11 ms حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 13.331 MB
UPDATE ve2rc_k2_items
SET `hits` = (`hits` + 1)
WHERE `id` = '608'توضیحات در جستجو ممکن نیست: UPDATE ve2rc_k2_items SET `hits` = (`hits` + 1) WHERE `id` = '608'Status Duration Starting 0.05 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 for update 0.07 ms Updating 0.18 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.40 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.03 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.59 ms پس از آخرین پرس و جو: 0.11 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 13.335 MB سطرهای بازگشتی: 0
SELECT *
FROM ve2rc_k2_comments
WHERE itemID=608
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.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.06 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.05 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: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.98 ms پس از آخرین پرس و جو: 0.86 ms حافظه پرس و جو: 0.041 MB حافظه قبل از پرس و جوی: 13.487 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 != 608
AND i.published = 1
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-05-17 09:19:16')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-17 09:19:16')
AND i.access IN(1,1)
AND i.trash = 0
AND i.created_by = 9880
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 index PRIMARY,catid,created_by,idx_item created 5 NULL 20 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.07 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.05 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.28 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: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.80 ms پس از آخرین پرس و جو: 0.19 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 13.532 MB سطرهای بازگشتی: 39
SELECT id, name, parent
FROM ve2rc_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1)
ORDER BY parentid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_k2_categories ref category,published,access,trash category 2 const 39 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.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.02 ms Creating sort index 0.26 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 # فراخوانده فایل و شماره خط 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/itemlist.php:928 14 K2ModelItemlist->getCategoriesTree() JROOT/components/com_k2/helpers/route.php:261 13 K2HelperRoute::findMenuItem() JROOT/components/com_k2/helpers/route.php:41 12 K2HelperRoute::getItemRoute() JROOT/components/com_k2/views/item/view.html.php:269 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.57 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 13.565 MB سطرهای بازگشتی: 1
SELECT *
FROM ve2rc_k2_items
WHERE id < 608
AND catid = 125
AND published = 1
AND trash = 0
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-05-17 09:19:16')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-05-17 09:19:16')
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 3 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.04 ms Statistics 0.06 ms Preparing 0.06 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.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 # فراخوانده فایل و شماره خط 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.56 ms پس از آخرین پرس و جو: 0.51 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 13.637 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 = 552
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.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.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: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.47 ms پس از آخرین پرس و جو: 0.06 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 13.645 MB سطرهای بازگشتی: 0
SELECT *
FROM ve2rc_k2_attachments
WHERE itemID=552id 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.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 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.45 ms پس از آخرین پرس و جو: 0.04 ms حافظه پرس و جو: 0.024 MB حافظه قبل از پرس و جوی: 13.658 MB سطرهای بازگشتی: 0
SELECT *
FROM ve2rc_k2_rating
WHERE itemID = 552id 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.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.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 # فراخوانده فایل و شماره خط 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.71 ms پس از آخرین پرس و جو: 0.99 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 13.653 MB سطرهای بازگشتی: 1
SELECT *
FROM ve2rc_k2_items
WHERE id > 608
AND catid = 125
AND published = 1
AND trash = 0
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-05-17 09:19:16')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-05-17 09:19:16')
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 catid 8 NULL 9 Using index condition; 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.06 ms Preparing 0.06 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.08 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: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.53 ms پس از آخرین پرس و جو: 0.47 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 13.725 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 = 611
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.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.05 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.45 ms پس از آخرین پرس و جو: 0.06 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 13.733 MB سطرهای بازگشتی: 0
SELECT *
FROM ve2rc_k2_attachments
WHERE itemID=611id 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.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: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.42 ms پس از آخرین پرس و جو: 0.03 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 13.739 MB سطرهای بازگشتی: 0
SELECT *
FROM ve2rc_k2_rating
WHERE itemID = 611id 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.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.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 # فراخوانده فایل و شماره خط 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.53 ms پس از آخرین پرس و جو: 12.57 ms حافظه پرس و جو: 0.020 MB حافظه قبل از پرس و جوی: 15.263 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.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.04 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.05 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 # فراخوانده فایل و شماره خط 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
30 نوع پرس و جو ثبت شده
انتخاب جداول:
3 × SELECT tag.*
FROM ve2rc_k2_tags AS tag JOIN ve2rc_k2_tags_xref AS xref
ON tag.id = xref.tagID3 × SELECT *
FROM ve2rc_k2_attachments3 × SELECT *
FROM ve2rc_k2_rating2 × SELECT *
FROM ve2rc_k2_items2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ve2rc_extensions`1 × SELECT id, name, parent
FROM ve2rc_k2_categories1 × 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 id, gender, description, image, url, `
group`, plugins
FROM ve2rc_k2_users1 × 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 *
FROM `ve2rc_users`1 × SELECT `data`
FROM `ve2rc_session`1 × SELECT *
FROM ve2rc_k2_categories1 × 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 × UPDATE `ve2rc_extensions`
SET `params` = '{\"mediaversion\":\"40e21e85f7ea77add0106a07fa6f7a31\"}'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)