رئیس بیمارستان فوق تخصصی آیت الله یثربی گفت: با اعتباری بالغ بر 10میلیارد ريال بخش چشم پزشکی بیمارستان مجهز به جدیدترین دستگاه لیزر آرگون سبز شد.
115مین جلسه کلاس های تاب آوری نوین (مدیریت هیجانات، کاهش استرس و اضطراب) روز سه شنبه 23 دیماه در بیمارستان فوق تخصصی آیت الله یثربی
رییس انستیتو پاستور ایران از تولید واکسن مشترک ایران و کوبا خبر داد و گفت: با ورود این واکسن گام بسیار خوبی برای ایجاد ایمنی مردم برداشته خواهد شد.
دکتر مهدی رجبی،فلوشیپ فوق تخصصی اینترونشنال درد با بیان اینکه بلوک شبکه سلیاک با روش قدامی تحت راهنمای سونوگرافی و دستگاه اشعه ایکس اتاق عمل در بیمار با دردهای شکمی ناشی از سرطان پانکراس درکلینیک بیمارستان فوق تخصصی آیت الله یثربی انجام شد، گفت: اپروچ انتریور یا روش قدامی بر خلاف روش پوستریوریا خلفی در بیمارانی که به علت آسیت یا درد شکم نمی توانند پوزیشن پرون(وضعیت خوابیده بر روی شکم) را تحمل کنند، انجام می شود و ترکیب گاید سونوگرافی و سی آرم میزان موفقیت را به بیش از ۹۰ درصد افزایش می دهد.
تماس با بیمارستان
- آدرس : کاشان. بلوار قطب راوندی- بلوار پرستار- بیمـارستــان فـوق تخصصــی آیت الله یثربـــی (ره) کاشــان
- ایمیل : info@yasrebihospital.ir
- فکس : 55621530-031
- تلفن : 55585000-031
تماس با اورژانس و دفتر پرستاری
- اورژانس بیمارستان با 16 تخت و مجهز به اتاق تریاژ
- ترومـا و اتـاق احیــاء و سیــستم مـانیتـورینــگ بیمـار
- تلفن اورژانــــــس : 55585000-031 داخلی 215
- تلفن پزشک کشیک : 55585000-031 داخلی 115
- تلفن دفتر پرستاری و متــرون : داخلی 220 و 221
اشکال یابی جوملا
{ "__default": { "session": { "counter": 1, "timer": { "start": 1656763714, "last": 1656763714, "now": 1656763714 }, "token": "3nogZWw1EGpGZ9Biz9ShjHydQQxd5x3P" }, "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 } } }
زمان
حافظه
38 پرس و جو ثبت شده 47.15 ms
- زمان پرس و جو: 0.61 ms حافظه پرس و جو: 0.019 MB حافظه قبل از پرس و جوی: 1.621 MB سطرهای بازگشتی: 0
SELECT `data`
FROM `ve2rc_session`
WHERE `session_id` = X'68676231376d7636366e31376d3874656f367137656533673331'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.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.03 ms Optimizing 0.02 ms Statistics 0.14 ms Preparing 0.01 ms Executing 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() به نظر می رسد خط زیر فراخونده شده باشد. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php: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.42 ms پس از آخرین پرس و جو: 0.90 ms حافظه پرس و جو: 0.011 MB حافظه قبل از پرس و جوی: 1.677 MB سطرهای بازگشتی: 0
SELECT `session_id`
FROM `ve2rc_session`
WHERE `session_id` = X'68676231376d7636366e31376d3874656f367137656533673331'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:856 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:414 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - زمان پرس و جو: 0.79 ms پس از آخرین پرس و جو: 0.21 ms حافظه پرس و جو: 0.010 MB حافظه قبل از پرس و جوی: 1.694 MB
INSERT INTO `ve2rc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'68676231376d7636366e31376d3874656f367137656533673331', 1, 1656763714, 0, '', 0)توضیحات در جستجو ممکن نیست: INSERT INTO `ve2rc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'68676231376d7636366e31376d3874656f367137656533673331', 1, 1656763714, 0, '', 0)Status Duration Starting 0.05 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init for update 0.02 ms Update 0.10 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.41 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:856 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:414 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - زمان پرس و جو: 0.62 ms پس از آخرین پرس و جو: 2.44 ms حافظه پرس و جو: 0.014 MB حافظه قبل از پرس و جوی: 1.772 MB سطرهای بازگشتی: 46
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 47 Using index condition; Using where Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.24 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 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.35 ms پس از آخرین پرس و جو: 1.70 ms حافظه پرس و جو: 0.013 MB حافظه قبل از پرس و جوی: 1.881 MB سطرهای بازگشتی: 4
SELECT id, rules
FROM `ve2rc_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_viewlevels ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 4 Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.48 ms پس از آخرین پرس و جو: 0.20 ms حافظه پرس و جو: 0.014 MB حافظه قبل از پرس و جوی: 1.905 MB سطرهای بازگشتی: 1
SELECT b.id
FROM ve2rc_usergroups AS a
LEFT JOIN ve2rc_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 1 Using where; Using index Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 ms Executing 0.01 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.01 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php: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.20 ms پس از آخرین پرس و جو: 0.75 ms حافظه پرس و جو: 0.013 MB حافظه قبل از پرس و جوی: 1.944 MB سطرهای بازگشتی: 124
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 186 Using index condition; Using where; با استفاده از مرتب سازی فایل Status Duration Starting 0.05 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.03 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.73 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/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.44 ms پس از آخرین پرس و جو: 16.77 ms حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 2.972 MB سطرهای بازگشتی: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ve2rc_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 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.65 ms پس از آخرین پرس و جو: 0.57 ms حافظه پرس و جو: 0.016 MB حافظه قبل از پرس و جوی: 2.978 MB
UPDATE `ve2rc_extensions`
SET `params` = '{\"mediaversion\":\"ea9b4c1a0307ff3b9be2138c0887f0a3\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'توضیحات در جستجو ممکن نیست: UPDATE `ve2rc_extensions` SET `params` = '{\"mediaversion\":\"ea9b4c1a0307ff3b9be2138c0887f0a3\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init for update 0.06 ms Updating 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.32 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 13 JDatabaseDriverMysqli->execute() JROOT/libraries/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 - زمان پرس و جو: 0.36 ms پس از آخرین پرس و جو: 15.76 ms حافظه پرس و جو: 0.017 MB حافظه قبل از پرس و جوی: 3.545 MB سطرهای بازگشتی: 18
SELECT *
FROM ve2rc_acysms_configid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_acysms_config ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 18 Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_acysms/classes/cpanel.php:17 11 ACYSMScpanelClass->load() JROOT/administrator/components/com_acysms/helpers/helper.php:265 10 ACYSMS::config() JROOT/administrator/components/com_acysms/helpers/helper.php:774 9 include_once JROOT/administrator/components/com_acysms/helpers/helper.php JROOT/plugins/system/acysmsusercreation/acysmsusercreation.php:25 8 plgSystemAcysmsUserCreation->init() JROOT/plugins/system/acysmsusercreation/acysmsusercreation.php:18 7 plgSystemAcysmsUserCreation->__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 - زمان پرس و جو: 4.44 ms پس از آخرین پرس و جو: 5.98 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 4.139 MB سطرهای بازگشتی: 215
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 911 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.07 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 3.95 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 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.48 ms پس از آخرین پرس و جو: 19.44 ms حافظه پرس و جو: 0.018 MB حافظه قبل از پرس و جوی: 5.751 MB سطرهای بازگشتی: 2
SELECT *
FROM ve2rc_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_languages ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 5 Using where; با استفاده از مرتب سازی فایل Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.03 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 13 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 12 Joomla\CMS\Application\SiteApplication->getParams() JROOT/components/com_k2/helpers/utilities.php:243 11 K2HelperUtilities::getParams() JROOT/administrator/components/com_k2/helpers/html.php:235 10 K2HelperHTML::loadHeadIncludes() JROOT/plugins/system/k2/k2.php:438 9 plgSystemK2->onAfterRoute() به نظر می رسد خط زیر فراخونده شده باشد. 8 call_user_func_array() 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.56 ms پس از آخرین پرس و جو: 1.26 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 5.864 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.05 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.09 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 20 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/HTML/HTMLHelper.php:365 19 Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() JROOT/libraries/src/HTML/HTMLHelper.php:712 18 Joomla\CMS\HTML\HTMLHelper::script() به نظر می رسد خط زیر فراخونده شده باشد. 17 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 16 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 15 Joomla\CMS\HTML\HTMLHelper::_() JROOT/libraries/cms/html/jquery.php:52 14 JHtmlJquery::framework() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 12 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 11 Joomla\CMS\HTML\HTMLHelper::_() JROOT/administrator/components/com_k2/helpers/html.php:259 10 K2HelperHTML::loadHeadIncludes() JROOT/plugins/system/k2/k2.php:438 9 plgSystemK2->onAfterRoute() به نظر می رسد خط زیر فراخونده شده باشد. 8 call_user_func_array() 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.05 ms پس از آخرین پرس و جو: 4.82 ms حافظه پرس و جو: 0.016 MB حافظه قبل از پرس و جوی: 6.056 MB سطرهای بازگشتی: 46
SELECT `id`,`name`,`rules`,`parent_id`
FROM `ve2rc_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_acysms','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_rsform','com_rstester','com_search','com_tags','com_templates','com_tz_portfolio_plus','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 47 Using index condition Status Duration Starting 0.06 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.07 ms Optimizing 0.02 ms Statistics 0.16 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.48 ms End of update loop 0.01 ms Query end 0.02 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 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 - زمان پرس و جو: 1.11 ms پس از آخرین پرس و جو: 8.10 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 6.510 MB سطرهای بازگشتی: 14
SHOW FULL COLUMNS
FROM `ve2rc_k2_categories`توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `ve2rc_k2_categories`Status Duration Starting 0.04 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.33 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms Checking permissions 0.12 ms Closing tables 0.02 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.12 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 16 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 15 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 14 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_k2/tables/k2category.php:34 13 TableK2Category->__construct() JROOT/libraries/src/Table/Table.php:328 12 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_k2/views/itemlist/view.html.php:112 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.46 ms پس از آخرین پرس و جو: 0.74 ms حافظه پرس و جو: 0.017 MB حافظه قبل از پرس و جوی: 6.568 MB سطرهای بازگشتی: 1
SELECT *
FROM ve2rc_k2_categories
WHERE id = '79'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_k2_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.01 ms Unlocking tables 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.03 ms Query end 0.01 ms Commit 0.02 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 13 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:61 12 TableK2Category->load() JROOT/components/com_k2/views/itemlist/view.html.php:113 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->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 - زمان پرس و جو: 2.10 ms پس از آخرین پرس و جو: 4.18 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 6.721 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.category'
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.18 ms Checking permissions 0.01 ms Opening tables 0.07 ms After opening tables 0.01 ms System lock 0.02 ms Table lock 0.01 ms Init 0.06 ms Optimizing 0.04 ms Statistics 0.13 ms Preparing 0.05 ms Creating tmp table 0.08 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.72 ms Creating sort index 0.04 ms Removing tmp table 0.08 ms Creating sort index 0.29 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 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() به نظر می رسد خط زیر فراخونده شده باشد. 14 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_k2/views/itemlist/view.html.php:182 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->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.67 ms پس از آخرین پرس و جو: 2.01 ms حافظه پرس و جو: 0.018 MB حافظه قبل از پرس و جوی: 6.796 MB سطرهای بازگشتی: 0
SELECT *
FROM ve2rc_k2_categories
WHERE parent=79
AND published=1
AND trash=0
AND access IN(1,1)
ORDER BY id ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_k2_categories ref category,parent,published,access,trash parent 5 const 1 Using where Status Duration Starting 0.06 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.04 ms Optimizing 0.03 ms Statistics 0.14 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/itemlist.php:450 12 K2ModelItemlist->getCategoryFirstChildren() JROOT/components/com_k2/views/itemlist/view.html.php:217 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->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.94 ms پس از آخرین پرس و جو: 0.99 ms حافظه پرس و جو: 0.019 MB حافظه قبل از پرس و جوی: 6.855 MB سطرهای بازگشتی: 0
SELECT id
FROM ve2rc_k2_categories
WHERE parent IN(79)
AND id NOT IN(79)
AND 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 PRIMARY,category,parent,published,access,trash parent 9 NULL 2 Using index condition; Using where Status Duration Starting 0.07 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.03 ms Statistics 1.38 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 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:1550 14 JDatabaseDriver->loadColumn() JROOT/components/com_k2/models/itemlist.php:398 13 K2ModelItemlist->getCategoryTree() JROOT/components/com_k2/models/itemlist.php:119 12 K2ModelItemlist->getData() JROOT/components/com_k2/views/itemlist/view.html.php:563 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->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 - زمان پرس و جو: 11.66 ms پس از آخرین پرس و جو: 0.79 ms حافظه پرس و جو: 0.017 MB حافظه قبل از پرس و جوی: 6.875 MB سطرهای بازگشتی: 4
SELECT SQL_CALC_FOUND_ROWS i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM ve2rc_k2_items AS i RIGHT JOIN ve2rc_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.access IN(1)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1)
AND c.trash = 0
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2022-07-02 12:08:34')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2022-07-02 12:08:34')
AND c.id IN(79)
ORDER BY i.id DESC
LIMIT 32, 4id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,category,published,access,trash PRIMARY 4 const 1 1 SIMPLE i ref item,catid item 2 const 787 Using index condition; Using where; با استفاده از مرتب سازی فایل Status Duration Starting 0.08 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.06 ms Optimizing 0.04 ms Statistics 0.15 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 10.94 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/itemlist.php:338 12 K2ModelItemlist->getData() JROOT/components/com_k2/views/itemlist/view.html.php:563 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->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.24 ms پس از آخرین پرس و جو: 0.36 ms حافظه پرس و جو: 0.017 MB حافظه قبل از پرس و جوی: 6.964 MB سطرهای بازگشتی: 1
SELECT FOUND_ROWS();
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL کلید شاخصی برای استفاده نیست NULL NULL NULL No tables used Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms Init 0.01 ms Optimizing 0.01 ms Executing 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/itemlist.php:351 12 K2ModelItemlist->getData() JROOT/components/com_k2/views/itemlist/view.html.php:563 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.20 ms پس از آخرین پرس و جو: 7.98 ms حافظه پرس و جو: 0.032 MB حافظه قبل از پرس و جوی: 7.174 MB سطرهای بازگشتی: 16
SHOW FULL COLUMNS
FROM `ve2rc_users`توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `ve2rc_users`Status Duration Starting 0.03 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.24 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.02 ms Opening tables 0.30 ms After opening tables 0.01 ms Checking permissions 0.09 ms Closing tables 0.02 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.12 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 26 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 25 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 24 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 23 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/User.php:41 22 Joomla\CMS\Table\User->__construct() JROOT/libraries/src/Table/Table.php:328 21 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/User/User.php:603 20 Joomla\CMS\User\User::getTable() JROOT/libraries/src/User/User.php:877 19 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 18 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 17 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 16 Joomla\CMS\Factory::getUser() JROOT/components/com_k2/models/item.php:201 15 K2ModelItem->prepareItem() به نظر می رسد خط زیر فراخونده شده باشد. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:680 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.46 ms پس از آخرین پرس و جو: 0.63 ms حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 7.243 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.03 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.01 ms Unlocking tables 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 21 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:87 20 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 19 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 18 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 17 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 16 Joomla\CMS\Factory::getUser() JROOT/components/com_k2/models/item.php:201 15 K2ModelItem->prepareItem() به نظر می رسد خط زیر فراخونده شده باشد. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:680 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->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 پس از آخرین پرس و جو: 1.59 ms حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 8.007 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.05 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.10 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 21 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Table/User.php:112 20 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 19 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 18 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 17 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 16 Joomla\CMS\Factory::getUser() JROOT/components/com_k2/models/item.php:201 15 K2ModelItem->prepareItem() به نظر می رسد خط زیر فراخونده شده باشد. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:680 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->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 - زمان پرس و جو: 2.33 ms پس از آخرین پرس و جو: 2.86 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 8.032 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.04 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 1.54 ms Table lock 0.03 ms Init 0.28 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.10 ms End of update loop 0.01 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1668 17 K2ModelItem->getUserProfile() JROOT/components/com_k2/helpers/utilities.php:45 16 K2HelperUtilities::getAvatar() JROOT/components/com_k2/models/item.php:204 15 K2ModelItem->prepareItem() به نظر می رسد خط زیر فراخونده شده باشد. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:680 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->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 پس از آخرین پرس و جو: 6.16 ms حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 8.115 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.itemlist'
AND (fc.category_id IS NULL OR fc.category_id IN (79,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; با استفاده از مرتب سازی فایل 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 fpftaick_Hos94MEhr10.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 fpftaick_Hos94MEhr10.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 fpftaick_Hos94MEhr10.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 fpftaick_Hos94MEhr10.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 fpftaick_Hos94MEhr10.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 fpftaick_Hos94MEhr10.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.16 ms Checking permissions 0.01 ms Opening tables 0.08 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.01 ms Init 0.08 ms Optimizing 0.05 ms Statistics 0.14 ms Preparing 0.07 ms Creating tmp table 0.08 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.45 ms Creating sort index 0.04 ms Removing tmp table 0.09 ms Creating sort index 0.02 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 20 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 19 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 18 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 17 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 16 PlgSystemFields->onContentPrepare() به نظر می رسد خط زیر فراخونده شده باشد. 15 call_user_func_array() 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:651 12 K2ModelItem->execPlugins() JROOT/components/com_k2/views/itemlist/view.html.php:687 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->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 پس از آخرین پرس و جو: 29.52 ms حافظه پرس و جو: 0.017 MB حافظه قبل از پرس و جوی: 8.359 MB سطرهای بازگشتی: 36
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 36 Using where; Using index Status Duration Starting 0.07 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.13 ms End of update loop 0.02 ms Query end 0.32 ms Commit 0.02 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.01 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/itemlist/view.html.php:735 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:19 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:64 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.49 ms پس از آخرین پرس و جو: 14.85 ms حافظه پرس و جو: 0.015 MB حافظه قبل از پرس و جوی: 8.503 MB سطرهای بازگشتی: 1
SELECT template_style_id
FROM ve2rc_menu
WHERE id = 1530id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_menu 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.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:129 10 YtFrameworkTemplate->isOverrideTemplate() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:30 9 YtFrameworkTemplate->YtFrameworkTemplate() JROOT/templates/sj_healthcare/includes/frame_inc.php:29 8 include_once JROOT/templates/sj_healthcare/includes/frame_inc.php JROOT/templates/sj_healthcare/index.php:24 7 require JROOT/templates/sj_healthcare/index.php JROOT/libraries/src/Document/HtmlDocument.php:666 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:728 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:543 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1126 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.78 ms پس از آخرین پرس و جو: 0.08 ms حافظه پرس و جو: 0.015 MB حافظه قبل از پرس و جوی: 8.519 MB سطرهای بازگشتی: 1
SELECT id
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 ref idx_client_id,idx_client_id_home idx_client_id_home 1 const 4 Using where; Using index Status Duration Starting 0.03 ms Checking permissions 0.28 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:133 10 YtFrameworkTemplate->isOverrideTemplate() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:30 9 YtFrameworkTemplate->YtFrameworkTemplate() JROOT/templates/sj_healthcare/includes/frame_inc.php:29 8 include_once JROOT/templates/sj_healthcare/includes/frame_inc.php JROOT/templates/sj_healthcare/index.php:24 7 require JROOT/templates/sj_healthcare/index.php JROOT/libraries/src/Document/HtmlDocument.php:666 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:728 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:543 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1126 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.61 ms پس از آخرین پرس و جو: 1.65 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 8.586 MB سطرهای بازگشتی: 18
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ve2rc_modules AS m
LEFT JOIN ve2rc_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ve2rc_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2022-07-02 12:08:34')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-07-02 12:08:34')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 1530 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 38 Using index condition; Using where; با استفاده از مرتب سازی فایل 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 fpftaick_Hos94MEhr10.m.module,const 1 Using index condition; Using where 1 SIMPLE mm ref PRIMARY PRIMARY 4 fpftaick_Hos94MEhr10.m.id 1 Using where; Using index Status Duration Starting 0.11 ms Checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.06 ms Optimizing 0.05 ms Statistics 0.08 ms Preparing 0.07 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.85 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() به نظر می رسد خط زیر فراخونده شده باشد. 17 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 16 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 15 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 14 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 13 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:589 12 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:188 11 YtFrameworkRenderXML->getBlocks() JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:115 10 YtFrameworkRenderXML->getTagBody() JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:49 9 YtFrameworkRenderXML->YtFrameworkRenderXML() JROOT/templates/sj_healthcare/includes/frame_inc.php:96 8 include_once JROOT/templates/sj_healthcare/includes/frame_inc.php JROOT/templates/sj_healthcare/index.php:24 7 require JROOT/templates/sj_healthcare/index.php JROOT/libraries/src/Document/HtmlDocument.php:666 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:728 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:543 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1126 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.76 ms پس از آخرین پرس و جو: 4.89 ms حافظه پرس و جو: 0.013 MB حافظه قبل از پرس و جوی: 8.751 MB سطرهای بازگشتی: 1
SELECT home
FROM ve2rc_menu
WHERE id=1530id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_menu const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.28 ms System lock 0.02 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 9 JDatabase->query() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:117 8 YtFrameworkTemplate->isHomePage() JROOT/templates/sj_healthcare/index.php:66 7 require JROOT/templates/sj_healthcare/index.php JROOT/libraries/src/Document/HtmlDocument.php:666 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:728 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:543 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1126 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.40 ms پس از آخرین پرس و جو: 0.10 ms حافظه پرس و جو: 0.013 MB حافظه قبل از پرس و جوی: 8.764 MB سطرهای بازگشتی: 1
SELECT home
FROM ve2rc_menu
WHERE id=1530id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_menu const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:118 8 YtFrameworkTemplate->isHomePage() JROOT/templates/sj_healthcare/index.php:66 7 require JROOT/templates/sj_healthcare/index.php JROOT/libraries/src/Document/HtmlDocument.php:666 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:728 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:543 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1126 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.56 ms پس از آخرین پرس و جو: 89.25 ms حافظه پرس و جو: 0.016 MB حافظه قبل از پرس و جوی: 9.555 MB سطرهای بازگشتی: 1
SELECT home
FROM ve2rc_menu
WHERE id=1530id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_menu const PRIMARY PRIMARY 4 const 1 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.01 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.02 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 11 JDatabase->query() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:117 10 YtFrameworkTemplate->isHomePage() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:273 9 YtFrameworkTemplate->renPositionsGroup() JROOT/templates/sj_healthcare/includes/block-content.php:94 8 include JROOT/templates/sj_healthcare/includes/block-content.php JROOT/templates/sj_healthcare/index.php:112 7 require JROOT/templates/sj_healthcare/index.php JROOT/libraries/src/Document/HtmlDocument.php:666 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:728 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:543 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1126 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.46 ms پس از آخرین پرس و جو: 0.11 ms حافظه پرس و جو: 0.016 MB حافظه قبل از پرس و جوی: 9.571 MB سطرهای بازگشتی: 1
SELECT home
FROM ve2rc_menu
WHERE id=1530id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_menu const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.02 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.02 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:118 10 YtFrameworkTemplate->isHomePage() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:273 9 YtFrameworkTemplate->renPositionsGroup() JROOT/templates/sj_healthcare/includes/block-content.php:94 8 include JROOT/templates/sj_healthcare/includes/block-content.php JROOT/templates/sj_healthcare/index.php:112 7 require JROOT/templates/sj_healthcare/index.php JROOT/libraries/src/Document/HtmlDocument.php:666 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:728 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:543 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1126 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.00 ms پس از آخرین پرس و جو: 21.25 ms حافظه پرس و جو: 0.019 MB حافظه قبل از پرس و جوی: 10.173 MB سطرهای بازگشتی: 129
SELECT *
FROM ve2rc_acymailing_configid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_acymailing_config ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 129 Status Duration Starting 0.05 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.37 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.13 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 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/administrator/components/com_acymailing/classes/cpanel.php:17 13 cpanelClass->load() JROOT/administrator/components/com_acymailing/helpers/helper.php:473 12 acymailing_config() JROOT/administrator/components/com_acymailing/helpers/helper.php:1183 11 include_once JROOT/administrator/components/com_acymailing/helpers/helper.php JROOT/modules/mod_acymailing/mod_acymailing.php:12 10 include JROOT/modules/mod_acymailing/mod_acymailing.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:499 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:791 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:565 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.47 ms پس از آخرین پرس و جو: 1.74 ms حافظه پرس و جو: 0.017 MB حافظه قبل از پرس و جوی: 10.329 MB سطرهای بازگشتی: 1
SELECT *
FROM ve2rc_acymailing_list
WHERE type = 'list'
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ve2rc_acymailing_list system typeorderingindex,typeuseridindex کلید شاخصی برای استفاده نیست NULL NULL 1 Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.04 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_acymailing/classes/list.php:29 11 listClass->getLists() JROOT/modules/mod_acymailing/mod_acymailing.php:125 10 include JROOT/modules/mod_acymailing/mod_acymailing.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:499 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:791 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:565 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 2.09 ms پس از آخرین پرس و جو: 1.95 ms حافظه پرس و جو: 0.029 MB حافظه قبل از پرس و جوی: 10.338 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 = 'mod_custom.content'
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.50 ms Checking permissions 0.02 ms Opening tables 0.08 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms Init 0.07 ms Optimizing 0.05 ms Statistics 0.15 ms Preparing 0.06 ms Creating tmp table 0.11 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.51 ms Creating sort index 0.04 ms Removing tmp table 0.10 ms Creating sort index 0.02 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.02 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 22 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 21 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 20 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 19 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 18 PlgSystemFields->onContentPrepare() به نظر می رسد خط زیر فراخونده شده باشد. 17 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 14 JHtmlContent::prepare() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 12 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 11 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom/mod_custom.php:15 10 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:499 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:791 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:565 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.69 ms پس از آخرین پرس و جو: 27.41 ms حافظه پرس و جو: 0.013 MB حافظه قبل از پرس و جوی: 10.739 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.09 ms Checking permissions 0.03 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.02 ms Init 0.04 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms Closing tables 0.01 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.01 ms # فراخوانده فایل و شماره خط 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/yt.php:243 9 plgSystemYt->nameOfSJTemplate() JROOT/plugins/system/yt/yt.php:168 8 plgSystemYt->onAfterRender() به نظر می رسد خط زیر فراخونده شده باشد. 7 call_user_func_array() 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
32 نوع پرس و جو ثبت شده
انتخاب جداول:
4 × SELECT home
FROM ve2rc_menu2 × 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_id2 × SELECT *
FROM ve2rc_k2_categories2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ve2rc_extensions`1 × 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 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 id
FROM ve2rc_k2_categories1 × SELECT id
FROM ve2rc_template_styles1 × SELECT *
FROM ve2rc_acymailing_list1 × SELECT template
FROM ve2rc_template_styles1 × SELECT *
FROM ve2rc_acymailing_confi1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ve2rc_modules AS m
LEFT JOIN ve2rc_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ve2rc_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT *
FROM `ve2rc_users`1 × SELECT template_style_id
FROM ve2rc_menu1 × SELECT id
FROM ve2rc_k2_categories1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM ve2rc_extensions1 × SELECT *
FROM ve2rc_acysms_confi1 × 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 `session_id`
FROM `ve2rc_session`1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM ve2rc_menu AS m
LEFT JOIN ve2rc_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM ve2rc_languages1 × SELECT SQL_CALC_FOUND_ROWS i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM ve2rc_k2_items AS i RIGHT JOIN ve2rc_k2_categories AS c
ON c.id = i.catid1 × SELECT `data`
FROM `ve2rc_session`1 × 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 FOUND_ROWS()
سایر جداول:
1 × SHOW FULL COLUMNS
FROM `ve2rc_users1 × SHOW FULL COLUMNS
FROM `ve2rc_k2_categories1 × UPDATE `ve2rc_extensions`
SET `params` = '{\"mediaversion\":\"ea9b4c1a0307ff3b9be2138c0887f0a3\"}'1 × INSERT INTO `ve2rc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'68676231376d7636366e31376d3874656f367137656533673331', 1, 1656763714, 0, '', 0