کانکور سهمیه‌ بندی می‌شود

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

کانکور سهمیه‌ بندی می‌شود

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

وزارت تحصیلات عالی طرحی را تدوین کرده است که براساس آن متقاضیان کانکور هر ولایت براساس نفوس و تعداد نمایندگان همان ولایت در پارلمان، می‌توانند در امتحان کانکور اشتراک کنند.

هدف اصلی این طرح، سهمیه‌بندی کانکور است، طوری که متقاضیان هر ولایت به تناسب تعداد نمایندگانی که در پارلمان دارد، می‌توانند در امتحان کانکور شرکت کنند.

عظیم نوربخش، سخنگوی وزارت تحصیلات عالی، روز گذشته در گفتگو با ۸صبح گفت این طرح در سیمیناری با اشتراک نمایندگان وزارت معارف، کار و امور اجتماعی، جامعه مدنی روسای دانشگاه‌های مرکز و ولایات تدوین شده است.
این همایش تحت عنوان «ارزیابی فیصله‌های فراخوان ملی پیرامون امتحان کانکور و چگونگی اجراات آن» برگزار شده بود.
نوربخش گفت: «در این طرح گفته شده که اخذ امتحان کانکور با در نظرداشت نفوس و تعداد فارغان ولایات در کوتاه‌مدت است.» براساس این طرح، تصدیق فراغت از صنف دوازدهم توسط وزارت معارف، تکمیل ۶۵ درصد نمرات در سه سال آخر دوره ثانوی و سایر لایحه‌های مربوط به این امتحان، در نظر گرفته می‌شود.
اما شماری از احزاب و ایتلاف‌های سیاسی در رابطه به این طرح واکنش نشان دادند و این طرح را خلاف قانون اساسی خواندند.

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

آقای عاصم در رابطه به طرح جدید وزارت تحصیلات عالی گفت: «این‌ها یک سلسله مشکلات جدید و کشمکش‌ها و سردرگمی‌های جدید را به‌وجود می‌آورند.»

او افزود که معیار اصلی کانکور باید شایستگی و نمرات بالا در امتحان باشد، زیرا در غیر این صورت آن‌هایی که زحمت می‌کشند و درس می‌خوانند نمی‌توانند از طریق امتحان کانکور به دانشگاه‌های دولتی راه یابند.

به باور آقای عاصم، طرح جدید وزارت تحصیلات عالی سهمیه را بر شایستگی، لیاقت و معیار نمره در کانکور ترجیح می‌دهد و این مخالف با اصول و معیارهای جهانی کانکور است.

اما حزب حق و عدالت می‌گوید طرح جدید وزارت تحصیلات عالی خلاف قانون اساسی افغانستان است. در ماده چهل‌وسوم قانون اساسی آمده است: «تعلیم حق تمام اتباع افغانستان است که تا درجه لیسانس در موسسات تعلیمی دولتی به‌صورت رایگان از طرف دولت تامین می‌شود.

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

آصف آشنا عضو شورای رهبری حزب حق و عدالت گفت سهمیه‌بندی کانکور منجر به نقض شایسته‌ سالاری می‌شود و زمینه‌های رقابت سالم را از بین می‌برد. او گفت چنین طرحی در سال‌های آینده افغانستان را با بحران شایسته‌سالاری مواجه می‌کند.
آشنا گفت: «به‌جای این طرح، خود وزارت تحصیلات عالی باید اصلاح شود، روش امتحان کانکور باید اصلاح شود تا در سال‌های آینده بتوانیم امتحان کانکور شفاف، سالم و عادلانه را که شایسته‌سالاری را تقویت کند، برگزار کنیم.»
آقای آشنا تاکید کرد که چنین طرحی فرصت‌های برابر و عادلانه را از بین می‌برد و شایسته‌سالاری را صدمه می‌زند.
از سوی دیگر حامد یک تن از تحلیلگران می‌گوید در افغانستان هنوز آمار دقیق نفوس وجو ندارد و تا زمانی‌ که آمار دقیق توسط توزیع شناس‌نامه‌های الکترونیکی به‌دست نیاید، چگونه می‌توان از نفوس ولایات سخن گفت.
به باور حامد دولت به‌جای چنین طرح‌هایی که روحیه دانش‌آموزان را برای ادامه تحصیل ضعیف می‌کند، زمینه‌های بازگشایی مکاتب در ولایات ناامن و استخدام معلمان کافی در این ولایات را فراهم کند.
آقای حامد می‌گوید این طرح منجر به استعدادکُشی می‌شود و نسل جوان افغانستان را که امیدوارانه درس می‌خوانند، نسبت به آینده ناامید می‌کند.

(روزنامه 8صبح)

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

معرفی

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

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

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

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

کلام ناب

امام صادق علیه السلام : مَن ساءَ خُلُقُهُ عَذَّبَ نَفسَهُ؛ هر كه بد اخلاق باشد، خود را شكنجه دهد. گزیده تحف العقول، ح196

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

05446780

امروز

دیروز

این هفته

هفته گذشته

این ماه

ماه گذشته

کل بازدیدها

240

833

3373

5429801

29670

9612

5446780

آی پی شما: 3.14.6.194

2024-04-24 04:01

Visitors Counter

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

جلسه

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1713931280,
                "last": 1713931280,
                "now": 1713931280
            },
            "client": {
                "forwarded": "3.14.6.194"
            },
            "token": "WI5SRkVOWyYjjGmsEBgxw8PbT6dlYuZ3"
        },
        "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": 1713932400
        }
    }
}

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

زمان

حافظه

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

**زمان**: 75.78 ms / 89.96 ms **حافظه**: 5.385 MB / 7.83 MB Application: afterInitialise

**زمان**: 14.48 ms / 104.44 ms **حافظه**: 1.136 MB / 8.97 MB Application: afterRoute

**زمان**: 7.52 ms / 111.96 ms **حافظه**: 0.289 MB / 9.26 MB Application: beforeRenderComponent com_content

**زمان**: 2.60 ms / 114.57 ms **حافظه**: 0.247 MB / 9.51 MB Application: Before Access::preloadComponents (all components)

**زمان**: 0.71 ms / 115.27 ms **حافظه**: 0.054 MB / 9.56 MB Application: After Access::preloadComponents (all components)

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

**زمان**: 1.58 ms / 116.87 ms **حافظه**: 0.640 MB / 10.20 MB Application: After Access::preloadPermissions (com_content)

**زمان**: 0.03 ms / 116.91 ms **حافظه**: -0.034 MB / 10.16 MB Application: Before Access::getAssetRules (id:192 name:com_content.article.67)

**زمان**: 0.43 ms / 117.34 ms **حافظه**: 0.027 MB / 10.19 MB Application: After Access::getAssetRules (id:192 name:com_content.article.67)

**زمان**: 32.48 ms / 149.82 ms **حافظه**: 2.278 MB / 12.47 MB Application: afterRenderComponent com_content

**زمان**: 1.36 ms / 151.18 ms **حافظه**: 0.142 MB / 12.61 MB Application: afterDispatch

**زمان**: 5.58 ms / 156.76 ms **حافظه**: 0.435 MB / 13.04 MB Application: beforeRenderModule mod_menu (منوی بالا)

**زمان**: 7.95 ms / 164.70 ms **حافظه**: 0.360 MB / 13.40 MB Application: afterRenderModule mod_menu (منوی بالا)

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

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

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

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

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

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

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

**زمان**: 2.02 ms / 190.65 ms **حافظه**: 0.150 MB / 15.36 MB Application: afterRenderModule mod_menu (منوی اصلی)

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

**زمان**: 0.67 ms / 192.36 ms **حافظه**: 0.024 MB / 15.39 MB Application: afterRenderModule mod_breadcrumbs (مسیر سایت)

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

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

**زمان**: 0.03 ms / 198.86 ms **حافظه**: -0.020 MB / 15.57 MB Application: beforeRenderModule mod_hadith (کلام ناب)

**زمان**: 0.92 ms / 199.78 ms **حافظه**: 0.021 MB / 15.59 MB Application: afterRenderModule mod_hadith (کلام ناب)

**زمان**: 0.04 ms / 199.82 ms **حافظه**: 0.004 MB / 15.59 MB Application: beforeRenderModule mod_vvisit_counter (آمار بازدیدکنندگان)

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

**زمان**: 0.90 ms / 202.86 ms **حافظه**: 0.001 MB / 15.82 MB Application: beforeRenderModule mod_footer (Footer)

**زمان**: 0.41 ms / 203.27 ms **حافظه**: 0.010 MB / 15.83 MB Application: afterRenderModule mod_footer (Footer)

**زمان**: 2.83 ms / 206.10 ms **حافظه**: 0.089 MB / 15.92 MB Application: afterRender

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

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

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

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

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

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

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

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

SELECT `data`

  FROM `z63bn_session`

  WHERE `session_id` = X'3261393634386636636237343634383931643835376436373763323932393766'

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

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.14 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	1.05 ms
Preparing	0.03 ms
Executing	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.01 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.47 ms** **پس از آخرین پرس و جو: 0.95 ms** **حافظه پرس و جو: 0.020 MB حافظه قبل از پرس و جوی: 4.250 MB** **سطرهای بازگشتی: 0**

SELECT `session_id`

  FROM `z63bn_session`

  WHERE `session_id` = X'3261393634386636636237343634383931643835376436373763323932393766' 
  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.17 ms
checking permissions	0.04 ms
Opening tables	0.01 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.02 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.01 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 برای لینک به فایل ها**]

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

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

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

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

**مشخصات**

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.01 ms
table lock	0.01 ms
init for update	0.02 ms
Update	0.08 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	10.24 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.02 ms

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

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

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

**زمان پرس و جو: 0.86 ms** **پس از آخرین پرس و جو: 1.88 ms** **حافظه پرس و جو: 0.024 MB حافظه قبل از پرس و جوی: 4.507 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.17 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.21 ms
End of update loop	0.02 ms
Query end	0.00 ms
Commit	0.02 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.03 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.32 ms** **پس از آخرین پرس و جو: 1.85 ms** **حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 4.697 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.06 ms
checking permissions	0.01 ms
Opening tables	0.02 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.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.00 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.39 ms** **پس از آخرین پرس و جو: 0.06 ms** **حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 4.709 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.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.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.02 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

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

#	فراخوانده	فایل و شماره خط
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**زمان پرس و جو: 0.55 ms** **پس از آخرین پرس و جو: 0.53 ms** **حافظه پرس و جو: 0.030 MB حافظه قبل از پرس و جوی: 4.778 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.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.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.20 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 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.73 ms** **پس از آخرین پرس و جو: 8.98 ms** **حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 5.700 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.16 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.05 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.01 ms
Reset for next command	0.00 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.37 ms** **پس از آخرین پرس و جو: 0.08 ms** **حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 5.708 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.07 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.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.00 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.44 ms** **پس از آخرین پرس و جو: 2.69 ms** **حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 6.313 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.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.06 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.02 ms
Reset for next command	0.00 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 برای لینک به فایل ها**]

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

SHOW FULL COLUMNS 
  FROM `z63bn_extensions`

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

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

**مشخصات**

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.17 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.00 ms
checking permissions	0.09 ms
closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.06 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.00 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.60 ms** **پس از آخرین پرس و جو: 0.66 ms** **حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 7.279 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.14 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.04 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.00 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.42 ms** **پس از آخرین پرس و جو: 0.09 ms** **حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 7.285 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.08 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.03 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.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.00 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.52 ms** **پس از آخرین پرس و جو: 0.08 ms** **حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 7.290 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.10 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.05 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.00 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.00 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.32 ms** **پس از آخرین پرس و جو: 0.05 ms** **حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 7.296 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.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.01 ms
Optimizing	0.01 ms
Statistics	0.02 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.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.00 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 برای لینک به فایل ها**]

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

UPDATE z63bn_vvisit_counter

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

  WHERE time=1713932400

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

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

**مشخصات**

Status	Duration
Starting	0.18 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 for update	0.06 ms
Updating	0.18 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	4.09 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 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.39 ms** **پس از آخرین پرس و جو: 1.97 ms** **حافظه پرس و جو: 0.112 MB حافظه قبل از پرس و جوی: 8.023 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.21 ms
checking permissions	0.03 ms
Opening tables	0.10 ms
After opening tables	0.03 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.06 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.38 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.09 ms
Starting cleanup	0.01 ms
Freeing items	0.06 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/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 برای لینک به فایل ها**]

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

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

  FROM `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 = 67

  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.31 ms
checking permissions	0.02 ms
Opening tables	0.06 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.11 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.13 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 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.34 ms** **پس از آخرین پرس و جو: 0.49 ms** **حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 8.946 MB** **سطرهای بازگشتی: 1**

SELECT `alias`,`catid`

  FROM `z63bn_content`

  WHERE `id` = 67

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

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.08 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.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.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.00 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.38 ms** **پس از آخرین پرس و جو: 0.16 ms** **حافظه پرس و جو: 0.024 MB حافظه قبل از پرس و جوی: 8.967 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.05 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.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.00 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.46 ms** **پس از آخرین پرس و جو: 0.19 ms** **حافظه پرس و جو: 0.024 MB حافظه قبل از پرس و جوی: 8.978 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.06 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.00 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.04 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 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.42 ms** **پس از آخرین پرس و جو: 0.63 ms** **حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 9.066 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.09 ms
checking permissions	0.02 ms
Opening tables	0.03 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.06 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
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 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 برای لینک به فایل ها**]

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

UPDATE `z63bn_extensions`

  SET `params` = '{\"mediaversion\":\"09fc9814a35815c5026d43c4f3420353\"}'

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

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

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

**مشخصات**

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.03 ms
Updating	0.06 ms
End of update loop	0.03 ms
Query end	0.00 ms
Commit	3.92 ms
closing tables	0.09 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.08 ms
Updating status	0.01 ms
Reset for next command	0.01 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.48 ms** **پس از آخرین پرس و جو: 1.51 ms** **حافظه پرس و جو: 0.019 MB حافظه قبل از پرس و جوی: 9.241 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.09 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.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 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.56 ms** **پس از آخرین پرس و جو: 2.86 ms** **حافظه پرس و جو: 0.027 MB حافظه قبل از پرس و جوی: 9.510 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.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.09 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.15 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.01 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.86 ms** **پس از آخرین پرس و جو: 0.10 ms** **حافظه پرس و جو: 0.122 MB حافظه قبل از پرس و جوی: 9.556 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.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.41 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.02 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.01 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.66 ms** **پس از آخرین پرس و جو: 1.54 ms** **حافظه پرس و جو: 0.031 MB حافظه قبل از پرس و جوی: 10.219 MB** **سطرهای بازگشتی: 31**

SHOW FULL COLUMNS 
  FROM `z63bn_content`

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

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

**مشخصات**

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
closing tables	0.00 ms
Opening tables	0.14 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.07 ms
closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.06 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.00 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 برای لینک به فایل ها**]

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

UPDATE z63bn_content

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

  WHERE `id` = '67'

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

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

**مشخصات**

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.01 ms
init for update	0.09 ms
Updating	0.07 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	3.82 ms
closing tables	0.04 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.09 ms
Updating status	0.02 ms
Reset for next command	0.02 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.69 ms** **پس از آخرین پرس و جو: 1.43 ms** **حافظه پرس و جو: 0.039 MB حافظه قبل از پرس و جوی: 10.641 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 = 67 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-24 04:01:20') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-24 04:01:20') 
  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.12 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.07 ms
Updating status	0.01 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.87 ms** **پس از آخرین پرس و جو: 1.46 ms** **حافظه پرس و جو: 0.027 MB حافظه قبل از پرس و جوی: 10.754 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.12 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.19 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.02 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.69 ms** **پس از آخرین پرس و جو: 0.29 ms** **حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 10.778 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` = 67 
  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.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.12 ms
Preparing	0.08 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.02 ms
Query end	0.00 ms
Commit	0.02 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.01 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.21 ms** **پس از آخرین پرس و جو: 6.60 ms** **حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 11.355 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.16 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
After opening tables	0.02 ms
System lock	0.03 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.08 ms
Statistics	0.08 ms
Preparing	0.03 ms
Creating tmp table	0.05 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.02 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

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

#	فراخوانده	فایل و شماره خط
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/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 برای لینک به فایل ها**]

**زمان پرس و جو: 1.25 ms** **پس از آخرین پرس و جو: 2.96 ms** **حافظه پرس و جو: 0.073 MB حافظه قبل از پرس و جوی: 11.789 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-04-24 04:01:20') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-24 04:01:20')

  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.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.06 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.74 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 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/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.20 ms** **پس از آخرین پرس و جو: 10.94 ms** **حافظه پرس و جو: 0.028 MB حافظه قبل از پرس و جوی: 12.992 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-04-24 04:01:20') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-24 04:01:20') 
  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.20 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.05 ms
Optimizing	0.04 ms
Statistics	0.14 ms
Preparing	0.07 ms
Sorting result	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.26 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

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

#	فراخوانده	فایل و شماره خط
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	*به نظر می رسد خط زیر فراخونده شده باشد.*
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php: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 برای لینک به فایل ها**]

**زمان پرس و جو: 1.73 ms** **پس از آخرین پرس و جو: 22.77 ms** **حافظه پرس و جو: 0.123 MB حافظه قبل از پرس و جوی: 14.810 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-04-24 04:01:20') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-24 04:01:20') 
  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.26 ms
checking permissions	0.01 ms
Opening tables	0.09 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.21 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.06 ms
Creating tmp table	0.05 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.35 ms
Creating sort index	0.11 ms
Removing tmp table	0.08 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.01 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.33 ms** **پس از آخرین پرس و جو: 0.55 ms** **حافظه پرس و جو: 0.029 MB حافظه قبل از پرس و جوی: 14.898 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.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.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 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.60 ms** **پس از آخرین پرس و جو: 1.25 ms** **حافظه پرس و جو: 0.035 MB حافظه قبل از پرس و جوی: 15.094 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.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.09 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 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.52 ms** **پس از آخرین پرس و جو: 0.38 ms** **حافظه پرس و جو: 0.035 MB حافظه قبل از پرس و جوی: 15.120 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.11 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.06 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.07 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.01 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.37 ms** **پس از آخرین پرس و جو: 0.34 ms** **حافظه پرس و جو: 0.028 MB حافظه قبل از پرس و جوی: 15.142 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.09 ms
checking permissions	0.01 ms
Opening tables	0.02 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.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 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.02 ms** **پس از آخرین پرس و جو: 10.14 ms** **حافظه پرس و جو: 0.028 MB حافظه قبل از پرس و جوی: 15.529 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-04-24 04:01:20') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-24 04:01:20')

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

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

#	فراخوانده	فایل و شماره خط
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/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.69 ms** **پس از آخرین پرس و جو: 0.32 ms** **حافظه پرس و جو: 0.031 MB حافظه قبل از پرس و جوی: 15.564 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.18 ms
checking permissions	0.03 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.02 ms
Statistics	0.06 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.07 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.01 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 برای لینک به فایل ها**]

**زمان پرس و جو: 0.82 ms** **پس از آخرین پرس و جو: 0.28 ms** **حافظه پرس و جو: 0.030 MB حافظه قبل از پرس و جوی: 15.581 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.09 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.20 ms
Creating sort index	0.03 ms
Removing tmp table	0.06 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 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.62 ms** **پس از آخرین پرس و جو: 0.40 ms** **حافظه پرس و جو: 0.029 MB حافظه قبل از پرس و جوی: 15.598 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.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.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.12 ms
Creating sort index	0.01 ms
Removing tmp table	0.03 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 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.59 ms** **پس از آخرین پرس و جو: 0.91 ms** **حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 15.596 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.02 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.01 ms
Preparing	0.01 ms
Creating tmp table	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.11 ms
Creating sort index	0.10 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
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.01 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.33 ms** **پس از آخرین پرس و جو: 0.88 ms** **حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 15.690 MB** **سطرهای بازگشتی: 1**

SELECT SUM(visits) AS visits

  FROM z63bn_vvisit_counter

  WHERE time > 1713916800

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z63bn_vvisit_counter	range	PRIMARY,time	PRIMARY	4	NULL	13	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.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.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.00 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'3261393634386636636237343634383931643835376436373763323932393766', 1, 1713931280, 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\":\"09fc9814a35815c5026d43c4f3420353\"}'**

**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="«سروش صبا» پایگاه اطلاع رسانی بنیاد علمی فرهنگی صبا"

خبر فوری

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

کانکور سهمیه‌ بندی می‌شود

معرفی

کلام ناب

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

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

جلسه

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

زمان

حافظه

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

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

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

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

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

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

سایر جداول:

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

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

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

خبر فوری

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

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

**جلسه**

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

**زمان**

**حافظه**

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

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

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

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

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

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

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

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

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

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

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

جلسه

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

زمان

حافظه

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

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

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

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

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

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

سایر جداول:

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

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

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