**خانه**
اخبار و رویدادها

امضای قرارداد 255 ملیون دالری میان افغانستان وبانک جهانی

اخبار و رویدادها

امضای قرارداد 255 ملیون دالری میان افغانستان وبانک جهانی

**نوشته شده توسط بخش خبر**. **ارسال شده در** اخبار و رویدادها

مقام های وزارت مالیه افغانستان و بانک جهانی چهار قرار داد به ارزش دوصد و پنجاه و پنج میلیون دالر امریکایی را به امضا رساندند قراردادها میان وزیر مالیه افغانستان و فلیپ لی هوریومسوول بانک جهانی برای آسیاى جنوبی، در واشنگتن به امضا رسید.
وزیر مالیه کشور که در راس یک هیات بلند رتبه دولتی در نشست نیمه سال صندوق بین المللی پول و بانک جهانی در واشنگتن شرکت کرده در حاشیه این نشست با آقای لی هوریو دیدار کرد.
Â آقای زاخیلوال، گفت٬ چهار موافقتنامه امضا شده به ارزش 255 ميليون دالر امریکایی، با بانک جھانی در پروژه های برق، معارف و آموزش به مصرف می رسد.
آقای زاخیلوال می گوید٬ چهل میلیون دالر امریکایی، به منظور انکشاف پروژه انتقال برق از آسیایی مرکزی به آسیایی جنوبی به مصروف خواهد رسید.
او افزوده است که قرار داد دیگر به ارزش پانزده میلیون دالر امریکایی برای آموزش های حرفه ای و ایجاد فرصت های کاری در افغانستان اختصاص داده شده است تا ظرفیت کاری کارمندان افزایش یافته و باعث بهبود زندگی جوانان، زنان و مردان در جوامع روستایی و نیمه روستایی افغانستان شود.
او تاکید کرد که یکصد و ده میلیون دالر امریکایی دیگر برای برنامه انکشافی شهرداری کابل کمک شده و 90.5 میلیون دالر امریکایی برای بهبود و موثریت سیستم حمل و نقل شهری کابل اختصاص داده شده است.
گفته می شود که تا کنون بانک جهانی صدها میلیون دالر را به هدف توسعه و پیشرفت افغانستان کمک کرده است.
بیشتر این کمک های بانک جهانی به افغانستان، از طریق وزارت مالیه کشور مصرف می شود.

**<** **قبلی** **بعدی** **>**

معرفی

بنیاد علمی فرهنگی صبا نهادی وابسته به مجموعه‌ای از استادان و دانشجویان جوان حوزه و دانشگاه است.

این نهاد مستقل، با علم به نا به سامانی‌های انبوه جامعه افغانستان، با درک الزامات امروزین زندگی و با آگاهی به نیازهای متنوع مردم زجر دیده خویش، در سال 1389 خورشیدی تشکیل شده و جهت فعالیت‌های علمی - اجتماعی آن در راستای ارتقای اندیشه، اعتلای عقلانیت، تحکیم عقلانی بنیان‌های ارزشی، آگاهی بخشی عامه و حراست از میراث‌های فرهنگی کشور، پاسداری از عنعنات، رسوم و افتخارات ارزشمند ملی و دینی سامان یافته است.

بنیاد صبا به جامعه آزاد، آباد، متدین، معقول و برابر می اندیشد.

نشر فصلنامه «سخن صبا» سایت «سروش صبا» و نیز برگزاری همایش‌های علمی و تحلیلی، در جوار سایر فعالیت‌های اجتماعی، علمی، تحقیقی و تبلیغی، جزئی از عملکردهای ارزشمند اعضای این بنیاد علمی- فرهنگی است. باشد که تلاش پیگیر این جمع و پشتیبانی‌های قلمی و قدمی تمام فرهنگیان عزیز کشور، در زدایش ناهنجاری‌های مدنی، نفی خرافات و انحرافات فکری، استقرار عدالت اجتماعی، برپایی جامعه توسعه‌ یافته دینی، ترقیم رشد و رفاه همگانی و دستیابی به عزت و اقتدار ملی مؤثر افتد.

کلام ناب

امام زمان حضرت مهدي -عجل الله تعالی فرجه الشریف- فرمودند: إِنّا غَیْرُ مُهْمِلینَ لِمُراعاتِكُمْ، وَلا ناسینَ لِذَكْرِكُمْ، وَلَوْلا ذلِكَ لَنَزَلَ بِكُمُ الَّلأْواءُ وَاصْطَلَمَكُمُ الاَْعْداءُ ... ما در رسیدگى و سرپرستى شما كوتاهى و اهمال نكرده و یاد شما را از خاطر نبرده ایم كه اگر جز این بود، دشوارى ها و مصیبت ها بر شما فرود مى آمد و دشمنان، شما را ریشه كن مى نمودند ... احتجاج، ج2، ص323

آمار بازدیدکنندگان

05752267

امروز

دیروز

این هفته

هفته گذشته

این ماه

ماه گذشته

کل بازدیدها

1166

2471

8661

5733219

32785

42157

5752267

آی پی شما: 3.147.68.201

2024-11-21 12:00

Visitors Counter

اشکال یابی جوملا

جلسه

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1732190411,
                "last": 1732190411,
                "now": 1732190411
            },
            "client": {
                "forwarded": "3.147.68.201"
            },
            "token": "L1H7LhpGqBmXBqvrR1KQVy3MRJY5rtXn"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "vvisit_counter": {
            "lastlog": 1732191600
        }
    }
}

اطلاعات مشخصات

زمان

حافظه

**زمان**: 13.17 ms / 13.17 ms **حافظه**: 2.068 MB / 2.45 MB Application: afterLoad

**زمان**: 63.91 ms / 77.08 ms **حافظه**: 5.386 MB / 7.83 MB Application: afterInitialise

**زمان**: 12.32 ms / 89.40 ms **حافظه**: 1.095 MB / 8.93 MB Application: afterRoute

**زمان**: 5.57 ms / 94.96 ms **حافظه**: 0.290 MB / 9.22 MB Application: beforeRenderComponent com_content

**زمان**: 2.74 ms / 97.70 ms **حافظه**: 0.247 MB / 9.47 MB Application: Before Access::preloadComponents (all components)

**زمان**: 0.99 ms / 98.69 ms **حافظه**: 0.054 MB / 9.52 MB Application: After Access::preloadComponents (all components)

**زمان**: 0.02 ms / 98.71 ms **حافظه**: -0.004 MB / 9.52 MB Application: Before Access::preloadPermissions (com_content)

**زمان**: 1.64 ms / 100.34 ms **حافظه**: 0.640 MB / 10.16 MB Application: After Access::preloadPermissions (com_content)

**زمان**: 0.06 ms / 100.40 ms **حافظه**: -0.034 MB / 10.12 MB Application: Before Access::getAssetRules (id:486 name:com_content.article.362)

**زمان**: 0.43 ms / 100.84 ms **حافظه**: 0.027 MB / 10.15 MB Application: After Access::getAssetRules (id:486 name:com_content.article.362)

**زمان**: 33.29 ms / 134.12 ms **حافظه**: 2.294 MB / 12.44 MB Application: afterRenderComponent com_content

**زمان**: 1.78 ms / 135.91 ms **حافظه**: 0.142 MB / 12.59 MB Application: afterDispatch

**زمان**: 5.39 ms / 141.30 ms **حافظه**: 0.435 MB / 13.02 MB Application: beforeRenderModule mod_menu (منوی بالا)

**زمان**: 7.99 ms / 149.28 ms **حافظه**: 0.360 MB / 13.38 MB Application: afterRenderModule mod_menu (منوی بالا)

**زمان**: 5.05 ms / 154.33 ms **حافظه**: 0.779 MB / 14.16 MB Application: beforeRenderModule mod_roksprocket (سرتیتر خبر)

**زمان**: 8.01 ms / 162.35 ms **حافظه**: 0.626 MB / 14.78 MB Application: Before Access::getAssetRules (id:8 name:com_content)

**زمان**: 0.05 ms / 162.39 ms **حافظه**: 0.002 MB / 14.79 MB Application: After Access::getAssetRules (id:8 name:com_content)

**زمان**: 11.65 ms / 174.04 ms **حافظه**: 0.477 MB / 15.26 MB Application: afterRenderModule mod_roksprocket (سرتیتر خبر)

**زمان**: 0.70 ms / 174.74 ms **حافظه**: -0.096 MB / 15.17 MB Application: beforeRenderModule mod_search (جستجوی سایت)

**زمان**: 0.99 ms / 175.73 ms **حافظه**: 0.027 MB / 15.19 MB Application: afterRenderModule mod_search (جستجوی سایت)

**زمان**: 0.36 ms / 176.09 ms **حافظه**: -0.002 MB / 15.19 MB Application: beforeRenderModule mod_menu (منوی اصلی)

**زمان**: 2.70 ms / 178.79 ms **حافظه**: 0.150 MB / 15.34 MB Application: afterRenderModule mod_menu (منوی اصلی)

**زمان**: 1.37 ms / 180.16 ms **حافظه**: -0.002 MB / 15.34 MB Application: beforeRenderModule mod_breadcrumbs (مسیر سایت)

**زمان**: 0.97 ms / 181.13 ms **حافظه**: 0.024 MB / 15.36 MB Application: afterRenderModule mod_breadcrumbs (مسیر سایت)

**زمان**: 0.53 ms / 181.66 ms **حافظه**: -0.000 MB / 15.36 MB Application: beforeRenderModule mod_articles_news (درباره بنیاد علمی - فرهنگی صبا)

**زمان**: 7.54 ms / 189.20 ms **حافظه**: 0.203 MB / 15.57 MB Application: afterRenderModule mod_articles_news (درباره بنیاد علمی - فرهنگی صبا)

**زمان**: 0.04 ms / 189.23 ms **حافظه**: -0.020 MB / 15.55 MB Application: beforeRenderModule mod_hadith (کلام ناب)

**زمان**: 1.19 ms / 190.42 ms **حافظه**: 0.022 MB / 15.57 MB Application: afterRenderModule mod_hadith (کلام ناب)

**زمان**: 0.06 ms / 190.48 ms **حافظه**: 0.003 MB / 15.57 MB Application: beforeRenderModule mod_vvisit_counter (آمار بازدیدکنندگان)

**زمان**: 2.66 ms / 193.14 ms **حافظه**: 0.223 MB / 15.80 MB Application: afterRenderModule mod_vvisit_counter (آمار بازدیدکنندگان)

**زمان**: 1.21 ms / 194.35 ms **حافظه**: 0.001 MB / 15.80 MB Application: beforeRenderModule mod_footer (Footer)

**زمان**: 0.51 ms / 194.85 ms **حافظه**: 0.010 MB / 15.81 MB Application: afterRenderModule mod_footer (Footer)

**زمان**: 2.84 ms / 197.70 ms **حافظه**: 0.093 MB / 15.90 MB Application: afterRender

**جمع پرس و جوی بانک اطلاعاتی: 40.52 ms**

حافظه استفاده شده

پرس و جو پایگاه داده

45 پرس و جو ثبت شده 40.52 ms

4 تکراری پیدا شد!

**2 تکراری**: #8 #9

**2 تکراری**: #13 #15

**زمان پرس و جو: 0.64 ms** **حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 4.155 MB** **سطرهای بازگشتی: 0**

SELECT `data`

  FROM `z63bn_session`

  WHERE `session_id` = X'3730306162663934613431376561323038653934656336633538346330613261'

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z63bn_session	const	PRIMARY	PRIMARY	194	const	1

**مشخصات**

Status	Duration
Starting	0.15 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.06 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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.15 ms
Reset for next command	0.01 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	*به نظر می رسد خط زیر فراخونده شده باشد.*
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.37 ms** **پس از آخرین پرس و جو: 1.10 ms** **حافظه پرس و جو: 0.020 MB حافظه قبل از پرس و جوی: 4.252 MB** **سطرهای بازگشتی: 0**

SELECT `session_id`

  FROM `z63bn_session`

  WHERE `session_id` = X'3730306162663934613431376561323038653934656336633538346330613261' 
  LIMIT 1

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z63bn_session	const	PRIMARY	PRIMARY	194	const	1	Using index

**مشخصات**

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.00 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:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 2.42 ms** **پس از آخرین پرس و جو: 0.09 ms** **حافظه پرس و جو: 0.004 MB حافظه قبل از پرس و جوی: 4.257 MB**

INSERT INTO `z63bn_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'3730306162663934613431376561323038653934656336633538346330613261', 1, 1732190411, 0, '', 0)

**توضیح دادن**

**توضیحات در جستجو ممکن نیست: INSERT INTO `z63bn_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3730306162663934613431376561323038653934656336633538346330613261', 1, 1732190411, 0, '', 0)**

**مشخصات**

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.03 ms
System lock	0.02 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	1.97 ms
Query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.70 ms** **پس از آخرین پرس و جو: 2.07 ms** **حافظه پرس و جو: 0.024 MB حافظه قبل از پرس و جوی: 4.508 MB** **سطرهای بازگشتی: 39**

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `z63bn_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z63bn_extensions	ref	extension	extension	82	const	39	Using index condition; Using where

**مشخصات**

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	0.17 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.05 ms
Query end	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

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.27 ms** **پس از آخرین پرس و جو: 1.49 ms** **حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 4.699 MB** **سطرهای بازگشتی: 5**

SELECT id, rules

  FROM `z63bn_viewlevels`

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z63bn_viewlevels	ALL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	5

**مشخصات**

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 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.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 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

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.48 ms** **پس از آخرین پرس و جو: 0.10 ms** **حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 4.711 MB** **سطرهای بازگشتی: 2**

SELECT b.id

  FROM z63bn_usergroups AS a

  LEFT JOIN z63bn_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	Using where; Using index

**مشخصات**

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.13 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.05 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.04 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

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.58 ms** **پس از آخرین پرس و جو: 0.50 ms** **حافظه پرس و جو: 0.030 MB حافظه قبل از پرس و جوی: 4.779 MB** **سطرهای بازگشتی: 90**

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM z63bn_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z63bn_extensions	ALL	extension	کلید شاخصی برای استفاده نیست	NULL	NULL	226	Using where; با استفاده از مرتب سازی فایل

**مشخصات**

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.23 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.02 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.63 ms** **پس از آخرین پرس و جو: 8.65 ms** **حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 5.701 MB** **سطرهای بازگشتی: 1**

**پرس و جوی تکراری**: #9

SELECT template

  FROM z63bn_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	3	Using where

**مشخصات**

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.04 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.49 ms** **پس از آخرین پرس و جو: 0.08 ms** **حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 5.709 MB** **سطرهای بازگشتی: 1**

**پرس و جوی تکراری**: #8

SELECT template

  FROM z63bn_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	3	Using where

**مشخصات**

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.51 ms** **پس از آخرین پرس و جو: 2.43 ms** **حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 6.315 MB** **سطرهای بازگشتی: 4**

SELECT extension, file, type

  FROM z63bn_rokcommon_configs

  ORDER BY priority

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z63bn_rokcommon_configs	ALL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	4	با استفاده از مرتب سازی فایل

**مشخصات**

Status	Duration
Starting	0.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.02 ms
Optimizing	0.03 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.10 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	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:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:131
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:75
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 1.26 ms** **پس از آخرین پرس و جو: 11.31 ms** **حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 7.237 MB** **سطرهای بازگشتی: 18**

SHOW FULL COLUMNS 
  FROM `z63bn_extensions`

**توضیح دادن**

**توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `z63bn_extensions`**

**مشخصات**

Status	Duration
Starting	0.17 ms
checking permissions	0.04 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.30 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.04 ms
Executing	0.01 ms
Filling schema table	0.03 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
checking permissions	0.10 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.14 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.00 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
11	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
10	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:328
9	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.45 ms** **پس از آخرین پرس و جو: 0.56 ms** **حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 7.280 MB** **سطرهای بازگشتی: 1**

SELECT `extension_id`

  FROM `z63bn_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z63bn_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using where; Using index

**مشخصات**

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.08 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
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	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:1740
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:47
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.31 ms** **پس از آخرین پرس و جو: 0.08 ms** **حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 7.287 MB** **سطرهای بازگشتی: 1**

**پرس و جوی تکراری**: #15

SELECT *

  FROM z63bn_extensions

  WHERE `extension_id` = '10037'

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z63bn_extensions	const	PRIMARY	PRIMARY	4	const	1

**مشخصات**

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.28 ms** **پس از آخرین پرس و جو: 0.07 ms** **حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 7.291 MB** **سطرهای بازگشتی: 1**

SELECT `extension_id`

  FROM `z63bn_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z63bn_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using where; Using index

**مشخصات**

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:70
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.35 ms** **پس از آخرین پرس و جو: 0.07 ms** **حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 7.297 MB** **سطرهای بازگشتی: 1**

**پرس و جوی تکراری**: #13

SELECT *

  FROM z63bn_extensions

  WHERE `extension_id` = '10037'

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z63bn_extensions	const	PRIMARY	PRIMARY	4	const	1

**مشخصات**

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	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

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 2.29 ms** **پس از آخرین پرس و جو: 10.10 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 7.833 MB**

UPDATE z63bn_vvisit_counter

  SET visits=visits+1
	, guests=guests+1

  WHERE time=1732191600

**توضیح دادن**

**توضیحات در جستجو ممکن نیست: UPDATE z63bn_vvisit_counter SET visits=visits+1 , guests=guests+1 WHERE time=1732191600**

**مشخصات**

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.07 ms
Updating	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	1.79 ms
Query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
11	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/vvisit_counter/vvisit_counter.php:109
10	plgSystemVVisit_Counter::_updateRecord()	JROOT/plugins/system/vvisit_counter/vvisit_counter.php:75
9	plgSystemVVisit_Counter::_insertRecord()	JROOT/plugins/system/vvisit_counter/vvisit_counter.php:43
8	plgSystemVVisit_Counter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 1.23 ms** **پس از آخرین پرس و جو: 1.85 ms** **حافظه پرس و جو: 0.112 MB حافظه قبل از پرس و جوی: 8.024 MB** **سطرهای بازگشتی: 77**

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM z63bn_menu AS m

  LEFT JOIN z63bn_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	94	Using index condition; Using where; با استفاده از مرتب سازی فایل
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	sababonyad_taqawi.m.component_id	1	Using where

**مشخصات**

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.60 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.09 ms
Query end	0.06 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	*به نظر می رسد خط زیر فراخونده شده باشد.*
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.84 ms** **پس از آخرین پرس و جو: 6.87 ms** **حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 8.902 MB** **سطرهای بازگشتی: 0**

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `z63bn_categories` AS `s`

  INNER JOIN `z63bn_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 362

  ORDER BY c.lft

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**مشخصات**

Status	Duration
Starting	0.21 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.14 ms
Optimizing	0.03 ms
Statistics	0.11 ms
Preparing	0.01 ms
Executing	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.05 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
12	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
11	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/helpers/legacyrouter.php:350
10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.31 ms** **پس از آخرین پرس و جو: 0.07 ms** **حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 8.907 MB** **سطرهای بازگشتی: 1**

SELECT `alias`,`catid`

  FROM `z63bn_content`

  WHERE `id` = 362

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z63bn_content	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.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Query end	0.00 ms
Starting cleanup	0.00 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:1662
11	JDatabaseDriver->loadObject()	JROOT/components/com_content/helpers/legacyrouter.php:366
10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.28 ms** **پس از آخرین پرس و جو: 0.17 ms** **حافظه پرس و جو: 0.024 MB حافظه قبل از پرس و جوی: 8.928 MB** **سطرهای بازگشتی: 8**

SELECT * 
  FROM z63bn_rokcandy 
  WHERE published=1

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z63bn_rokcandy	ALL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	8	Using where

**مشخصات**

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:27
13	RokCandyHelper::getUserMacros()	*به نظر می رسد خط زیر فراخونده شده باشد.*
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
10	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:17
9	RokCandyHelper::getMacros()	JROOT/plugins/system/rokcandy/rokcandy.php:28
8	plgSystemRokCandy->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.36 ms** **پس از آخرین پرس و جو: 0.16 ms** **حافظه پرس و جو: 0.024 MB حافظه قبل از پرس و جوی: 8.939 MB** **سطرهای بازگشتی: 3**

SELECT id, home, template, s.params

  FROM z63bn_template_styles as s

  LEFT JOIN z63bn_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	3
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	sababonyad_taqawi.s.template,const	1	Using index condition; Using where

**مشخصات**

Status	Duration
Starting	0.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.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
15	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:53
14	RokCandyHelper::readIniFile()	*به نظر می رسد خط زیر فراخونده شده باشد.*
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
11	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:44
10	RokCandyHelper::getTemplateOverrides()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:18
9	RokCandyHelper::getMacros()	JROOT/plugins/system/rokcandy/rokcandy.php:28
8	plgSystemRokCandy->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.25 ms** **پس از آخرین پرس و جو: 0.54 ms** **حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 8.965 MB** **سطرهای بازگشتی: 1**

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `z63bn_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z63bn_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

**مشخصات**

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	*به نظر می رسد خط زیر فراخونده شده باشد.*
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 2.21 ms** **پس از آخرین پرس و جو: 0.09 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 8.955 MB**

UPDATE `z63bn_extensions`

  SET `params` = '{\"mediaversion\":\"714890ffe9c39b35a9075a21633e8407\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

**توضیح دادن**

**توضیحات در جستجو ممکن نیست: UPDATE `z63bn_extensions` SET `params` = '{\"mediaversion\":\"714890ffe9c39b35a9075a21633e8407\"}' WHERE `type` = 'library' AND `element` = 'joomla'**

**مشخصات**

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.04 ms
Updating	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	1.78 ms
Query end	0.04 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.50 ms** **پس از آخرین پرس و جو: 2.04 ms** **حافظه پرس و جو: 0.019 MB حافظه قبل از پرس و جوی: 9.202 MB** **سطرهای بازگشتی: 1**

SELECT *

  FROM z63bn_languages

  WHERE published=1

  ORDER BY ordering ASC

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z63bn_languages	ALL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	2	Using where; با استفاده از مرتب سازی فایل

**مشخصات**

Status	Duration
Starting	0.06 ms
checking permissions	0.03 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.06 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Query end	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

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.81 ms** **پس از آخرین پرس و جو: 3.00 ms** **حافظه پرس و جو: 0.027 MB حافظه قبل از پرس و جوی: 9.471 MB** **سطرهای بازگشتی: 37**

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `z63bn_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rokcandy','com_rokgallery','com_roksprocket','com_search','com_tags','com_templates','com_users','com_wrapper')

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z63bn_assets	range	idx_asset_name	idx_asset_name	202	NULL	38	Using index condition

**مشخصات**

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.01 ms
Statistics	0.14 ms
Preparing	0.04 ms
Executing	0.00 ms
Sending data	0.22 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.05 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.91 ms** **پس از آخرین پرس و جو: 0.13 ms** **حافظه پرس و جو: 0.122 MB حافظه قبل از پرس و جوی: 9.518 MB** **سطرهای بازگشتی: 813**

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `z63bn_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z63bn_assets	ALL	idx_asset_name,idx_parent_id	کلید شاخصی برای استفاده نیست	NULL	NULL	909	Using where

**مشخصات**

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.08 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.52 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.03 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.97 ms** **پس از آخرین پرس و جو: 1.55 ms** **حافظه پرس و جو: 0.031 MB حافظه قبل از پرس و جوی: 10.180 MB** **سطرهای بازگشتی: 31**

SHOW FULL COLUMNS 
  FROM `z63bn_content`

**توضیح دادن**

**توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `z63bn_content`**

**مشخصات**

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.31 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.10 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.02 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.14 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 2.80 ms** **پس از آخرین پرس و جو: 2.64 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 10.418 MB**

UPDATE z63bn_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '362'

**توضیح دادن**

**توضیحات در جستجو ممکن نیست: UPDATE z63bn_content SET `hits` = (`hits` + 1) WHERE `id` = '362'**

**مشخصات**

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.08 ms
Updating	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	2.11 ms
Query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.08 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.97 ms** **پس از آخرین پرس و جو: 1.61 ms** **حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 10.603 MB** **سطرهای بازگشتی: 1**

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM z63bn_content AS a

  INNER JOIN z63bn_categories AS c 
  on c.id = a.catid

  LEFT JOIN z63bn_users AS u 
  on u.id = a.created_by

  LEFT JOIN z63bn_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN z63bn_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.id = 362 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-21 12:00:11') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-21 12:00:11') 
  AND (a.state = 1 OR a.state =2)

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found

**مشخصات**

Status	Duration
Starting	0.19 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.07 ms
Statistics	0.20 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
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.05 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.92 ms** **پس از آخرین پرس و جو: 1.70 ms** **حافظه پرس و جو: 0.027 MB حافظه قبل از پرس و جوی: 10.711 MB** **سطرهای بازگشتی: 2**

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `z63bn_categories` AS `s`

  INNER JOIN `z63bn_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 49

  ORDER BY c.lft

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	کلید شاخصی برای استفاده نیست	NULL	NULL	81	Using where; با استفاده از مرتب سازی فایل

**مشخصات**

Status	Duration
Starting	0.10 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.06 ms
Optimizing	0.02 ms
Statistics	0.14 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.19 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.00 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.06 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
22	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
21	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
20	ContentRouter->getCategorySegment()	*به نظر می رسد خط زیر فراخونده شده باشد.*
19	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
18	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
17	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
16	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
15	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.42 ms** **پس از آخرین پرس و جو: 0.61 ms** **حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 10.764 MB** **سطرهای بازگشتی: 0**

SELECT `m`.`tag_id`,`t`.*

  FROM `z63bn_contentitem_tag_map` AS m 

  INNER JOIN `z63bn_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 362 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	کلید شاخصی برای استفاده نیست	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sababonyad_taqawi.m.tag_id	1	Using where

**مشخصات**

Status	Duration
Starting	0.05 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 1.43 ms** **پس از آخرین پرس و جو: 5.51 ms** **حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 11.341 MB** **سطرهای بازگشتی: 0**

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM z63bn_fields AS a

  LEFT JOIN `z63bn_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN z63bn_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN z63bn_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN z63bn_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN z63bn_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `z63bn_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (49,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; با استفاده از مرتب سازی فایل
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	sababonyad_taqawi.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	sababonyad_taqawi.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	sababonyad_taqawi.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	sababonyad_taqawi.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	sababonyad_taqawi.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	sababonyad_taqawi.a.id	1	Using where; Using index; Distinct

**مشخصات**

Status	Duration
Starting	0.19 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.03 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.15 ms
Preparing	0.03 ms
Creating tmp table	0.06 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.30 ms
Creating sort index	0.08 ms
Removing tmp table	0.16 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 2.34 ms** **پس از آخرین پرس و جو: 3.03 ms** **حافظه پرس و جو: 0.073 MB حافظه قبل از پرس و جوی: 11.775 MB** **سطرهای بازگشتی: 135**

SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug

  FROM z63bn_content AS a

  LEFT JOIN z63bn_categories AS cc 
  ON cc.id = a.catid

  WHERE a.catid = 49 
  AND a.state = 1 
  AND a.access IN (1,1,5)  
  AND (a.state = 1 OR a.state = -1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-11-21 12:00:11') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-11-21 12:00:11')

  ORDER BY  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	137	Using where; با استفاده از مرتب سازی فایل
1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1

**مشخصات**

Status	Duration
Starting	0.15 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.03 ms
Statistics	0.12 ms
Preparing	0.05 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.57 ms
End of update loop	0.05 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.06 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/pagenavigation/pagenavigation.php:161
13	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 1.00 ms** **پس از آخرین پرس و جو: 12.79 ms** **حافظه پرس و جو: 0.028 MB حافظه قبل از پرس و جوی: 12.970 MB** **سطرهای بازگشتی: 15**

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM z63bn_modules AS m

  LEFT JOIN z63bn_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN z63bn_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-21 12:00:11') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-21 12:00:11') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 120 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	26	Using index condition; Using where; با استفاده از مرتب سازی فایل
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	sababonyad_taqawi.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	sababonyad_taqawi.m.module,const	1	Using index condition; Using where

**مشخصات**

Status	Duration
Starting	0.17 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.06 ms
Statistics	0.11 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.21 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.06 ms
Query end	0.01 ms
Starting cleanup	0.00 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()	*به نظر می رسد خط زیر فراخونده شده باشد.*
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:49
11	ModulesWarpHelper->count()	JROOT/templates/imh_saba/layouts/template.config.php:155
10	include JROOT/templates/imh_saba/layouts/template.config.php	JROOT/templates/imh_saba/layouts/template.php:10
9	include JROOT/templates/imh_saba/layouts/template.php	JROOT/templates/imh_saba/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/imh_saba/index.php:19
7	require JROOT/templates/imh_saba/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 2.39 ms** **پس از آخرین پرس و جو: 22.66 ms** **حافظه پرس و جو: 0.123 MB حافظه قبل از پرس و جوی: 14.788 MB** **سطرهای بازگشتی: 3**

SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title

  FROM z63bn_content as a

  LEFT JOIN z63bn_categories AS c 
  ON c.id = a.catid

  LEFT JOIN z63bn_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN z63bn_users AS um 
  ON um.id = a.modified_by

  LEFT JOIN z63bn_content_rating AS v 
  ON a.id = v.content_id

  LEFT JOIN z63bn_viewlevels AS vl 
  ON a.access = vl.id

  LEFT JOIN z63bn_languages AS l 
  ON a.language = l.lang_code

  LEFT JOIN z63bn_contentitem_tag_map AS ct 
  ON ct.content_item_id = a.id

  LEFT JOIN z63bn_tags AS t 
  ON t.id = ct.tag_id

  WHERE ((a.access IN(1,1,5) 
  AND (a.state = 1 or a.state = 2) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-21 12:00:11') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-21 12:00:11') 
  AND (a.state != -2)) 
  AND a.id IN (654,653,651))

  GROUP BY id 
  LIMIT 3

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	PRIMARY,idx_access,idx_state	PRIMARY	4	NULL	3	Using where; Using temporary; با استفاده از مرتب سازی فایل
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	sababonyad_taqawi.a.catid	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	sababonyad_taqawi.a.created_by	1	Using where
1	SIMPLE	um	eq_ref	PRIMARY	PRIMARY	4	sababonyad_taqawi.a.modified_by	1	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	sababonyad_taqawi.a.id	1	Using where
1	SIMPLE	vl	eq_ref	PRIMARY	PRIMARY	4	sababonyad_taqawi.a.access	1
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	sababonyad_taqawi.a.language	1	Using where
1	SIMPLE	ct	index	NULL	idx_core_content_id	4	NULL	1	Using where; Using index; Using join buffer (flat, BNL join)

**مشخصات**

Status	Duration
Starting	0.31 ms
checking permissions	0.03 ms
Opening tables	0.14 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.15 ms
Optimizing	0.10 ms
Statistics	0.23 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.07 ms
Creating tmp table	0.06 ms
Sorting result	0.05 ms
Executing	0.01 ms
Sending data	0.62 ms
Creating sort index	0.14 ms
Removing tmp table	0.12 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.03 ms
Query end	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

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:58
23	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
22	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
21	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
20	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
19	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
18	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
17	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
16	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php	JROOT/templates/imh_saba/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/imh_saba/layouts/template.php:145
9	include JROOT/templates/imh_saba/layouts/template.php	JROOT/templates/imh_saba/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/imh_saba/index.php:19
7	require JROOT/templates/imh_saba/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.37 ms** **پس از آخرین پرس و جو: 0.91 ms** **حافظه پرس و جو: 0.029 MB حافظه قبل از پرس و جوی: 14.876 MB** **سطرهای بازگشتی: 0**

SELECT ct.content_item_id as article_id, t.title as tag

  FROM z63bn_contentitem_tag_map as ct

  LEFT JOIN z63bn_tags AS t 
  ON t.id = ct.tag_id

  WHERE ct.content_item_id in (651,653,654)

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ct	index	NULL	idx_core_content_id	4	NULL	1	Using where; Using index
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	sababonyad_taqawi.ct.tag_id	1

**مشخصات**

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
26	JDatabaseDriver->loadAssocList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/TagMerge.php:26
25	RokSprocket_Provider_Joomla_TagMerge->populateTags()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla.php:159
24	RokSprocket_Provider_Joomla->populateTags()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:62
23	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
22	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
21	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
20	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
19	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
18	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
17	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
16	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php	JROOT/templates/imh_saba/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/imh_saba/layouts/template.php:145
9	include JROOT/templates/imh_saba/layouts/template.php	JROOT/templates/imh_saba/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/imh_saba/index.php:19
7	require JROOT/templates/imh_saba/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.86 ms** **پس از آخرین پرس و جو: 1.54 ms** **حافظه پرس و جو: 0.035 MB حافظه قبل از پرس و جوی: 15.072 MB** **سطرهای بازگشتی: 2**

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `z63bn_categories` AS `s`

  INNER JOIN `z63bn_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 54

  ORDER BY c.lft

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	کلید شاخصی برای استفاده نیست	NULL	NULL	81	Using where; با استفاده از مرتب سازی فایل

**مشخصات**

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.15 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.06 ms
Creating sort index	0.16 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.03 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
39	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
38	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
37	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
36	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
35	ContentRouter->getCategorySegment()	*به نظر می رسد خط زیر فراخونده شده باشد.*
34	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
33	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
32	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
31	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
30	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
29	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
28	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
27	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
26	Joomla\CMS\Router\Route::_()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla.php:93
25	RokSprocket_Provider_Joomla->convertRawToItem()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:83
24	RokSprocket_Provider_AbstarctJoomlaBasedProvider->convertRawToItems()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:63
23	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
22	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
21	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
20	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
19	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
18	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
17	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
16	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php	JROOT/templates/imh_saba/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/imh_saba/layouts/template.php:145
9	include JROOT/templates/imh_saba/layouts/template.php	JROOT/templates/imh_saba/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/imh_saba/index.php:19
7	require JROOT/templates/imh_saba/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.71 ms** **پس از آخرین پرس و جو: 0.32 ms** **حافظه پرس و جو: 0.035 MB حافظه قبل از پرس و جوی: 15.098 MB** **سطرهای بازگشتی: 2**

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `z63bn_categories` AS `s`

  INNER JOIN `z63bn_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 53

  ORDER BY c.lft

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	کلید شاخصی برای استفاده نیست	NULL	NULL	81	Using where; با استفاده از مرتب سازی فایل

**مشخصات**

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.12 ms
Preparing	0.02 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.12 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
39	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
38	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
37	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
36	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
35	ContentRouter->getCategorySegment()	*به نظر می رسد خط زیر فراخونده شده باشد.*
34	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
33	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
32	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
31	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
30	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
29	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
28	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
27	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
26	Joomla\CMS\Router\Route::_()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla.php:93
25	RokSprocket_Provider_Joomla->convertRawToItem()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:83
24	RokSprocket_Provider_AbstarctJoomlaBasedProvider->convertRawToItems()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:63
23	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
22	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
21	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
20	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
19	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
18	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
17	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
16	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php	JROOT/templates/imh_saba/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/imh_saba/layouts/template.php:145
9	include JROOT/templates/imh_saba/layouts/template.php	JROOT/templates/imh_saba/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/imh_saba/index.php:19
7	require JROOT/templates/imh_saba/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.50 ms** **پس از آخرین پرس و جو: 0.35 ms** **حافظه پرس و جو: 0.028 MB حافظه قبل از پرس و جوی: 15.120 MB** **سطرهای بازگشتی: 3**

SELECT i.provider_id as id, i.
  order, i.params

  FROM z63bn_roksprocket_items as i

  WHERE i.module_id = '97' 
  AND i.provider = 'joomla'

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ref	idx_module,idx_module_order	idx_module	137	const	3	Using index condition; Using where

**مشخصات**

Status	Duration
Starting	0.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.07 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.03 ms
Query end	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

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:139
24	RokSprocket_Provider_AbstarctJoomlaBasedProvider->mapPerItemData()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:64
23	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
22	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
21	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
20	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
19	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
18	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
17	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
16	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php	JROOT/templates/imh_saba/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/imh_saba/layouts/template.php:145
9	include JROOT/templates/imh_saba/layouts/template.php	JROOT/templates/imh_saba/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/imh_saba/index.php:19
7	require JROOT/templates/imh_saba/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 1.22 ms** **پس از آخرین پرس و جو: 12.64 ms** **حافظه پرس و جو: 0.028 MB حافظه قبل از پرس و جوی: 15.507 MB** **سطرهای بازگشتی: 1**

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias

  FROM z63bn_content AS a

  LEFT JOIN z63bn_categories AS c 
  ON c.id = a.catid

  LEFT JOIN z63bn_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN z63bn_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN z63bn_categories as parent 
  ON parent.id = c.parent_id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid IN (65) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-21 12:00:11') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-21 12:00:11')

  ORDER BY a.publish_up DESC 
  LIMIT 1

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	1	Using where; با استفاده از مرتب سازی فایل
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	sababonyad_taqawi.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	sababonyad_taqawi.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where

**مشخصات**

Status	Duration
Starting	0.26 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.08 ms
Optimizing	0.04 ms
Statistics	0.20 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.07 ms
Query end	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

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
18	ContentModelArticles->getItems()	JROOT/modules/mod_articles_news/helper.php:100
17	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
16	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php	JROOT/templates/imh_saba/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/imh_saba/layouts/template.php:218
9	include JROOT/templates/imh_saba/layouts/template.php	JROOT/templates/imh_saba/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/imh_saba/index.php:19
7	require JROOT/templates/imh_saba/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.63 ms** **پس از آخرین پرس و جو: 0.26 ms** **حافظه پرس و جو: 0.031 MB حافظه قبل از پرس و جوی: 15.543 MB** **سطرهای بازگشتی: 2**

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `z63bn_categories` AS `s`

  INNER JOIN `z63bn_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 65

  ORDER BY c.lft

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	کلید شاخصی برای استفاده نیست	NULL	NULL	81	Using where; با استفاده از مرتب سازی فایل

**مشخصات**

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.04 ms
Statistics	0.10 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.09 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.03 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
30	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
29	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
28	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
27	ContentRouter->getCategorySegment()	*به نظر می رسد خط زیر فراخونده شده باشد.*
26	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
25	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
24	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
23	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
22	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
18	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_news/helper.php:113
17	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
16	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php	JROOT/templates/imh_saba/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/imh_saba/layouts/template.php:218
9	include JROOT/templates/imh_saba/layouts/template.php	JROOT/templates/imh_saba/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/imh_saba/index.php:19
7	require JROOT/templates/imh_saba/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 1.18 ms** **پس از آخرین پرس و جو: 0.40 ms** **حافظه پرس و جو: 0.030 MB حافظه قبل از پرس و جوی: 15.560 MB** **سطرهای بازگشتی: 0**

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM z63bn_fields AS a

  LEFT JOIN `z63bn_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN z63bn_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN z63bn_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN z63bn_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN z63bn_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'mod_articles_news.content' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; با استفاده از مرتب سازی فایل
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	sababonyad_taqawi.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	sababonyad_taqawi.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	sababonyad_taqawi.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	sababonyad_taqawi.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	sababonyad_taqawi.a.group_id	1	Using where

**مشخصات**

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.04 ms
Creating tmp table	0.08 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.30 ms
Creating sort index	0.06 ms
Removing tmp table	0.14 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.03 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
28	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
27	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
26	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
25	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
24	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
21	JHtmlContent::prepare()	*به نظر می رسد خط زیر فراخونده شده باشد.*
20	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
19	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
18	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_articles_news/helper.php:123
17	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
16	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php	JROOT/templates/imh_saba/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/imh_saba/layouts/template.php:218
9	include JROOT/templates/imh_saba/layouts/template.php	JROOT/templates/imh_saba/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/imh_saba/index.php:19
7	require JROOT/templates/imh_saba/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.94 ms** **پس از آخرین پرس و جو: 0.63 ms** **حافظه پرس و جو: 0.029 MB حافظه قبل از پرس و جوی: 15.576 MB** **سطرهای بازگشتی: 0**

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM z63bn_fields AS a

  LEFT JOIN `z63bn_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN z63bn_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN z63bn_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN z63bn_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN z63bn_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `z63bn_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (65,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; با استفاده از مرتب سازی فایل
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	sababonyad_taqawi.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	sababonyad_taqawi.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	sababonyad_taqawi.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	sababonyad_taqawi.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	sababonyad_taqawi.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	sababonyad_taqawi.a.id	1	Using where; Using index; Distinct

**مشخصات**

Status	Duration
Starting	0.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.07 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.18 ms
Creating sort index	0.03 ms
Removing tmp table	0.08 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
25	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
24	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
23	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
22	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
21	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
18	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/modules/mod_articles_news/helper.php:164
17	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
16	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php	JROOT/templates/imh_saba/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/imh_saba/layouts/template.php:218
9	include JROOT/templates/imh_saba/layouts/template.php	JROOT/templates/imh_saba/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/imh_saba/index.php:19
7	require JROOT/templates/imh_saba/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.68 ms** **پس از آخرین پرس و جو: 1.12 ms** **حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 15.574 MB** **سطرهای بازگشتی: 14**

SELECT *,RAND() AS r 

  FROM z63bn_hadith

  WHERE not(id=0)

  ORDER BY r

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z63bn_hadith	ALL	PRIMARY	کلید شاخصی برای استفاده نیست	NULL	NULL	14	Using where; Using temporary; با استفاده از مرتب سازی فایل

**مشخصات**

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
Executing	0.02 ms
Sending data	0.17 ms
Creating sort index	0.07 ms
End of update loop	0.01 ms
Removing tmp table	0.06 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/modules/mod_hadith/mod_hadith.php:24
16	include JROOT/modules/mod_hadith/mod_hadith.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php	JROOT/templates/imh_saba/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/imh_saba/layouts/template.php:218
9	include JROOT/templates/imh_saba/layouts/template.php	JROOT/templates/imh_saba/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/imh_saba/index.php:19
7	require JROOT/templates/imh_saba/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

**زمان پرس و جو: 0.45 ms** **پس از آخرین پرس و جو: 1.16 ms** **حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 15.669 MB** **سطرهای بازگشتی: 1**

SELECT SUM(visits) AS visits

  FROM z63bn_vvisit_counter

  WHERE time > 1732147200

**توضیح دادن**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z63bn_vvisit_counter	range	PRIMARY,time	PRIMARY	4	NULL	37	Using where

**مشخصات**

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

**فراخوانی بسته**

#	فراخوانده	فایل و شماره خط
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/plugins/system/vvisit_counter/helper/vvisit_counter.php:153
17	plgVVisitCounterHelper::getVisitsByType()	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:138
16	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/imh_saba/warp/systems/joomla/layouts/modules.php	JROOT/templates/imh_saba/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/imh_saba/layouts/template.php:218
9	include JROOT/templates/imh_saba/layouts/template.php	JROOT/templates/imh_saba/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/imh_saba/index.php:19
7	require JROOT/templates/imh_saba/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها**]

35 نوع پرس و جو ثبت شده

انتخاب جداول:

**5 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `z63bn_categories` AS `s` 
  INNER JOIN `z63bn_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)**

**2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `z63bn_assets`**

**2 × SELECT template 
  FROM z63bn_template_styles as s**

**2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM z63bn_fields AS a 
  LEFT JOIN `z63bn_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN z63bn_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN z63bn_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN z63bn_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN z63bn_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `z63bn_fields_categories` AS fc 
  ON fc.field_id = a.id**

**2 × SELECT * 
  FROM z63bn_extensions**

**2 × SELECT `extension_id` 
  FROM `z63bn_extensions`**

**2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `z63bn_extensions`**

**1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias 
  FROM z63bn_content AS a 
  LEFT JOIN z63bn_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN z63bn_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN z63bn_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN z63bn_categories as parent 
  ON parent.id = c.parent_id**

**1 × SELECT i.provider_id as id, i.
  order, i.params 
  FROM z63bn_roksprocket_items as i**

**1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `z63bn_contentitem_tag_map` AS m  
  INNER JOIN `z63bn_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`**

**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 z63bn_fields AS a 
  LEFT JOIN `z63bn_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN z63bn_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN z63bn_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN z63bn_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN z63bn_fields_groups AS g 
  ON g.id = a.group_id**

**1 × SELECT ct.content_item_id as article_id, t.title as tag 
  FROM z63bn_contentitem_tag_map as ct 
  LEFT JOIN z63bn_tags AS t 
  ON t.id = ct.tag_id**

**1 × SELECT *,RAND() AS r  
  FROM z63bn_hadith**

**1 × SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title 
  FROM z63bn_content as a 
  LEFT JOIN z63bn_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN z63bn_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN z63bn_users AS um 
  ON um.id = a.modified_by 
  LEFT JOIN z63bn_content_rating AS v 
  ON a.id = v.content_id 
  LEFT JOIN z63bn_viewlevels AS vl 
  ON a.access = vl.id 
  LEFT JOIN z63bn_languages AS l 
  ON a.language = l.lang_code 
  LEFT JOIN z63bn_contentitem_tag_map AS ct 
  ON ct.content_item_id = a.id 
  LEFT JOIN z63bn_tags AS t 
  ON t.id = ct.tag_id**

**1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM z63bn_modules AS m 
  LEFT JOIN z63bn_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN z63bn_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id**

**1 × SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM z63bn_content AS a 
  LEFT JOIN z63bn_categories AS cc 
  ON cc.id = a.catid**

**1 × SELECT `data` 
  FROM `z63bn_session`**

**1 × SELECT id, home, template, s.params 
  FROM z63bn_template_styles as s 
  LEFT JOIN z63bn_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id**

**1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM z63bn_content AS a 
  INNER JOIN z63bn_categories AS c 
  on c.id = a.catid 
  LEFT JOIN z63bn_users AS u 
  on u.id = a.created_by 
  LEFT JOIN z63bn_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN z63bn_content_rating AS v 
  ON a.id = v.content_id**

**1 × SELECT * 
  FROM z63bn_languages**

**1 × SELECT `session_id` 
  FROM `z63bn_session`**

**1 × SELECT * 
  FROM z63bn_rokcandy**

**1 × SELECT `alias`,`catid` 
  FROM `z63bn_content`**

**1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM z63bn_menu AS m 
  LEFT JOIN z63bn_extensions AS e 
  ON m.component_id = e.extension_id**

**1 × SELECT extension, file, type 
  FROM z63bn_rokcommon_configs**

**1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM z63bn_extensions**

**1 × SELECT b.id 
  FROM z63bn_usergroups AS a 
  LEFT JOIN z63bn_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt**

**1 × SELECT id, rules 
  FROM `z63bn_viewlevels**

**1 × SELECT SUM(visits) AS visits 
  FROM z63bn_vvisit_counter**

سایر جداول:

**1 × INSERT INTO `z63bn_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3730306162663934613431376561323038653934656336633538346330613261', 1, 1732190411, 0, '', 0**

**1 × SHOW FULL COLUMNS 
  FROM `z63bn_extensions**

**1 × UPDATE z63bn_vvisit_counter 
  SET visits=visits+1  , guests=guests+1**

**1 × UPDATE `z63bn_extensions` 
  SET `params` = '{\"mediaversion\":\"714890ffe9c39b35a9075a21633e8407\"}'**

**1 × SHOW FULL COLUMNS 
  FROM `z63bn_content**

**1 × UPDATE z63bn_content 
  SET `hits` = (`hits` + 1)**

ایرادات بارگذاری در فایل زبان

فایل زبان آپلود شده

**بار شده** : JROOT/language/fa-IR/fa-IR.ini
**بار شده** : JROOT/language/fa-IR/fa-IR.lib_joomla.ini
**بار شده** : JROOT/administrator/language/fa-IR/fa-IR.plg_system_updatenotification.ini
**بار شده** : JROOT/administrator/language/fa-IR/fa-IR.plg_system_fields.ini
**بار شده** : JROOT/administrator/language/fa-IR/fa-IR.plg_system_logrotation.ini
**بار شده** : JROOT/administrator/language/fa-IR/fa-IR.plg_system_logout.ini
**بار نشده** : JROOT/language/fa-IR/fa-IR.tpl_imh_saba.ini
**بار نشده** : JROOT/language/fa-IR/tpl_imh_saba.ini
**بار نشده** : JROOT/templates/imh_saba/language/fa-IR/fa-IR.tpl_imh_saba.ini
**بار نشده** : JROOT/templates/imh_saba/language/fa-IR/tpl_imh_saba.ini
**بار شده** : JROOT/language/fa-IR/fa-IR.com_content.ini
**بار نشده** : JROOT/administrator/language/fa-IR/fa-IR.plg_content_jw_allvideos.ini
**بار نشده** : JROOT/administrator/language/fa-IR/plg_content_jw_allvideos.ini
**بار نشده** : JROOT/plugins/content/jw_allvideos/language/fa-IR/fa-IR.plg_content_jw_allvideos.ini
**بار نشده** : JROOT/plugins/content/jw_allvideos/language/fa-IR/plg_content_jw_allvideos.ini
**بار شده** : JROOT/templates/imh_saba/warp/systems/joomla/language/fa-IR/fa-IR.tpl_warp.ini
**بار شده** : JROOT/language/fa-IR/fa-IR.mod_menu.ini
**بار نشده** : JROOT/language/fa-IR/fa-IR.mod_roksprocket.ini
**بار نشده** : JROOT/language/fa-IR/mod_roksprocket.ini
**بار نشده** : JROOT/modules/mod_roksprocket/language/fa-IR/fa-IR.mod_roksprocket.ini
**بار نشده** : JROOT/modules/mod_roksprocket/language/fa-IR/mod_roksprocket.ini
**بار نشده** : JROOT/language/en-GB/en-GB.com_roksprocket.ini
**بار نشده** : JROOT/language/en-GB/com_roksprocket.ini
**بار نشده** : JROOT/language/fa-IR/fa-IR.com_roksprocket.ini
**بار نشده** : JROOT/language/fa-IR/com_roksprocket.ini
**بار شده** : JROOT/components/com_roksprocket/language/en-GB/en-GB.com_roksprocket.ini
**بار شده** : JROOT/components/com_roksprocket/language/fa-IR/fa-IR.com_roksprocket.ini
**بار شده** : JROOT/components/com_roksprocket/layouts/lists/language/en-GB/en-GB.roksprocket_layout_lists.ini
**بار نشده** : JROOT/components/com_roksprocket/layouts/lists/language/fa-IR/fa-IR.roksprocket_layout_lists.ini
**بار نشده** : JROOT/components/com_roksprocket/layouts/lists/language/fa-IR/roksprocket_layout_lists.ini
**بار شده** : JROOT/components/com_roksprocket/layouts/headlines/language/en-GB/en-GB.roksprocket_layout_headlines.ini
**بار نشده** : JROOT/components/com_roksprocket/layouts/headlines/language/fa-IR/fa-IR.roksprocket_layout_headlines.ini
**بار نشده** : JROOT/components/com_roksprocket/layouts/headlines/language/fa-IR/roksprocket_layout_headlines.ini
**بار شده** : JROOT/components/com_roksprocket/layouts/sliders/language/en-GB/en-GB.roksprocket_layout_sliders.ini
**بار نشده** : JROOT/components/com_roksprocket/layouts/sliders/language/fa-IR/fa-IR.roksprocket_layout_sliders.ini
**بار نشده** : JROOT/components/com_roksprocket/layouts/sliders/language/fa-IR/roksprocket_layout_sliders.ini
**بار شده** : JROOT/components/com_roksprocket/layouts/mosaic/language/en-GB/en-GB.roksprocket_layout_mosaic.ini
**بار شده** : JROOT/components/com_roksprocket/layouts/mosaic/language/fa-IR/fa-IR.roksprocket_layout_mosaic.ini
**بار شده** : JROOT/components/com_roksprocket/layouts/quotes/language/en-GB/en-GB.roksprocket_layout_quotes.ini
**بار نشده** : JROOT/components/com_roksprocket/layouts/quotes/language/fa-IR/fa-IR.roksprocket_layout_quotes.ini
**بار نشده** : JROOT/components/com_roksprocket/layouts/quotes/language/fa-IR/roksprocket_layout_quotes.ini
**بار شده** : JROOT/components/com_roksprocket/layouts/tabs/language/en-GB/en-GB.roksprocket_layout_tabs.ini
**بار نشده** : JROOT/components/com_roksprocket/layouts/tabs/language/fa-IR/fa-IR.roksprocket_layout_tabs.ini
**بار نشده** : JROOT/components/com_roksprocket/layouts/tabs/language/fa-IR/roksprocket_layout_tabs.ini
**بار شده** : JROOT/components/com_roksprocket/layouts/features/language/en-GB/en-GB.roksprocket_layout_features.ini
**بار نشده** : JROOT/components/com_roksprocket/layouts/features/language/fa-IR/fa-IR.roksprocket_layout_features.ini
**بار نشده** : JROOT/components/com_roksprocket/layouts/features/language/fa-IR/roksprocket_layout_features.ini
**بار شده** : JROOT/components/com_roksprocket/layouts/tables/language/en-GB/en-GB.roksprocket_layout_tables.ini
**بار نشده** : JROOT/components/com_roksprocket/layouts/tables/language/fa-IR/fa-IR.roksprocket_layout_tables.ini
**بار نشده** : JROOT/components/com_roksprocket/layouts/tables/language/fa-IR/roksprocket_layout_tables.ini
**بار شده** : JROOT/components/com_roksprocket/layouts/grids/language/en-GB/en-GB.roksprocket_layout_grids.ini
**بار نشده** : JROOT/components/com_roksprocket/layouts/grids/language/fa-IR/fa-IR.roksprocket_layout_grids.ini
**بار نشده** : JROOT/components/com_roksprocket/layouts/grids/language/fa-IR/roksprocket_layout_grids.ini
**بار شده** : JROOT/components/com_roksprocket/layouts/strips/language/en-GB/en-GB.roksprocket_layout_strips.ini
**بار نشده** : JROOT/components/com_roksprocket/layouts/strips/language/fa-IR/fa-IR.roksprocket_layout_strips.ini
**بار نشده** : JROOT/components/com_roksprocket/layouts/strips/language/fa-IR/roksprocket_layout_strips.ini
**بار شده** : JROOT/language/fa-IR/fa-IR.mod_search.ini
**بار شده** : JROOT/language/fa-IR/fa-IR.mod_breadcrumbs.ini
**بار شده** : JROOT/language/fa-IR/fa-IR.mod_articles_news.ini
**بار شده** : JROOT/language/fa-IR/fa-IR.mod_hadith.ini
**بار نشده** : JROOT/language/fa-IR/fa-IR.mod_vvisit_counter.ini
**بار نشده** : JROOT/language/fa-IR/mod_vvisit_counter.ini
**بار نشده** : JROOT/modules/mod_vvisit_counter/language/fa-IR/fa-IR.mod_vvisit_counter.ini
**بار نشده** : JROOT/modules/mod_vvisit_counter/language/fa-IR/mod_vvisit_counter.ini
**بار شده** : JROOT/language/fa-IR/fa-IR.mod_footer.ini
**بار شده** : JROOT/administrator/language/fa-IR/fa-IR.plg_system_debug.ini

رشته ترجمه نشده


# JROOT/libraries/src/Language/Text.php

JW_PLG_AV_DEPRECATED_DOWNLOAD="PLG AV DEPRECATED DOWNLOAD"
LOADING_CONTAINER_CONFIG_FILE_FOR_S_FROM_S="container config file for %s from %s"
REGISTERING_LIBRARY_PATH_S_FOR_S="library path %s for %s"

Soroush-e Saba, Bonyad-e Saba web site alt="«سروش صبا» پایگاه اطلاع رسانی بنیاد علمی فرهنگی صبا" title="«سروش صبا» پایگاه اطلاع رسانی بنیاد علمی فرهنگی صبا"

خبر فوری

اخبار و رویدادها

امضای قرارداد 255 ملیون دالری میان افغانستان وبانک جهانی

معرفی

کلام ناب

آمار بازدیدکنندگان

اشکال یابی جوملا

جلسه

اطلاعات مشخصات

زمان

حافظه

حافظه استفاده شده

پرس و جو پایگاه داده

45 پرس و جو ثبت شده 40.52 ms

4 تکراری پیدا شد!

35 نوع پرس و جو ثبت شده

انتخاب جداول:

سایر جداول:

ایرادات بارگذاری در فایل زبان

فایل زبان آپلود شده

رشته ترجمه نشده

خبر فوری

اخبار و رویدادها

**اشکال یابی جوملا**

**جلسه**

**اطلاعات مشخصات**

**زمان**

**حافظه**

**حافظه استفاده شده**

**پرس و جو پایگاه داده**

**45 پرس و جو ثبت شده** 40.52 ms

**4 تکراری پیدا شد!**

**35 نوع پرس و جو ثبت شده**

**انتخاب جداول:**

**سایر جداول:**

**ایرادات بارگذاری در فایل زبان**

**فایل زبان آپلود شده**

**رشته ترجمه نشده**

اشکال یابی جوملا

جلسه

اطلاعات مشخصات

زمان

حافظه

حافظه استفاده شده

پرس و جو پایگاه داده

45 پرس و جو ثبت شده 40.52 ms

4 تکراری پیدا شد!

35 نوع پرس و جو ثبت شده

انتخاب جداول:

سایر جداول:

ایرادات بارگذاری در فایل زبان

فایل زبان آپلود شده

رشته ترجمه نشده