**خانه**
دین و مذهب

امام خمینی ره، احیاگرتفکُّراسلام سیاسی

دین و مذهب

امام خمینی ره، احیاگرتفکُّراسلام سیاسی

**نوشته شده توسط مصطفی موسوی مبلّغ**. **ارسال شده در** دین و مذهب

متفکران و صاحبان اندیشه در این چند دهه که از عمر انقلاب اسلامی ایران می گذرد به زوایای مختلف این انقلاب شکوهمند اشاره کرده اند، اما قطعا یکی از بزرگ ترین دستاوردهای انقلاب اسلامی ایران، احیای تفکر اسلام سیاسی بود. اندیشه سیاسی از مباحث فلسفه سیاست و در حوزه علوم اسلامی از شاخه های علم كلام بوده كه دانشمندان و متكلمین اسلامی آن را در قالب باورهای اعتقادی چون امامت و رهبری و مسائل آن مطرح كرده اند. اما بحث از حكومت كه یكی از محورهای مهم اندیشه سیاسی در اسلام می باشد، همواره از مسائل فقهی به حساب آمده و فقهای اسلامی به مناسبت های مختلف آن را در كتب مختلف فقهی مطرح كرده اند.
با این وجود، مطرح كردن این اندیشه به صورت عملی، آن هم در قالب و طرح جدیدی به نام جمهوری اسلامی، امری است كه به صورت قطع می توان گفت از نو آوری های معمار انقلاب اسلامی و ثمره حركت انسانی و نجات بخش امام خمینی رحمه الله علیه در قالب انقلاب اسلامی می باشد.
در تاریخ اسلام علمای دینی با الهام از آموزه های عدالت طلبانه و ظلم ستیز دین مبین اسلام، در تلاش برای زدودن ظلم و بی عدالتی از جامعه و نجات بشر از چنگال قدرت های استكباری و استعماری، مبارزات پیگیر و دامنه داری را با حكومت های جائر و ظالم انجام داده اند، اما حركت انقلابی و نجات بخش امام خمینی، نه تنها به رهایی ملت ایران از تحت ستم حكومت شاهی 2500 ساله در این كشور انجامید و نه تنها به دمیدن روح مبارزه طلبی در دیگر ملت ها منجر شد، بلكه اندیشه نهادینه سازی حكومت اسلامی را در جوامع مسلمان ترویج نموده و به شكل گیری اندیشه سیاسی عملی در این جوامع انجامید.
با پیروزی انقلاب اسلامی در ایران، چراغ امیدی در قلب امت های اسلامی در سراسر جهان روشن شد و مسلمانانی که تا آن هنگام فکر می کردند برای رهایی از یک ابر قدرت، باید به ابر قدرت دیگری روی آورند و یا گمان می کردند که امکان برقراری حکومت اسلامی در این عصر و زمانه وجود ندارد، اندیشه و فکرشان به طور کلی متحول شد.
از جمله شاهداین مدعا این است که پس از پیروزی انقلاب اسلامی از نفوذ اندیشه های مارکسیستی و ... در میان مسلمانان کاسته شد و در مقابل، اسلام به عنوان راهنمای عمل انتخاب گردید. به این ترتیب فریاد اسلام خواهی دیگر مردم مسلمان در سراسر دنیا، متأثر از انقلاب اسلامی و اندیشه های امام خمینی (ره) به حساب می آید.
بنیانگذار جمهوری اسلامی قیام و نهضت اسلامی خود را با احیای اندیشه سیاسی اسلام به ویژه احیای تئوری حکومتی اسلام آغاز کرد و این در واقع یکی از تفاوت های اساسی نهضت بیدار گرانه و حیات بخش آن امام راحل (ره) نسبت به دیگر نهضت های اسلام خواهانه قرون اخیر در جهان است و همین تفاوت اساسی یکی از عوامل مهم موفقیت و پیروزی انقلاب اسلامی شد.
امام خمینی رحمه الله علیه علاوه بر مبارزه برای نفی استعمار و استبداد، به ارائه فلسفه سیاسی اسلام پرداخت و در واقع به این دو پرسش اساسی که «چه کسی باید حکومت کند؟» و «چگونه باید حکومت کند؟»، پاسخ های صریح و روشنی داد و در عمل نیز به پیاده کردن این اندیشه اهتمام ورزید.
امام خمینی به عنوان عالمی آگاه به اسلام و احکام عبادی ـ سیاسی آن و به عنوان اندیشمندی مصلح و دلسوز جامعه سعی داشتند، با تفسیر و تبیین دقیق اسلام و احکام اسلامی، به خصوص روشن ساختن ابعاد سیاسی ـ حکومتی آن، چهرة اسلام را در میان ادیان الهی دیگر مانند مسیحیت روشن ساخته و آن را توضیح دهند.
از طرف دیگر امام در رابطه با مکاتبی که داعیه‌ی سیاست و کشورداری در میان ممالک پیشرفته را داشتند، احکام سیاسی اسلام را مدون تر و کامل تر از آنها تلقی نمود و در عمل نیز به خوبی نشان داد اگر بر مبنای احکام اسلامی عمل شود، در همه زمینه ها از جمله سیاست و حکومت داری موفق و پیشرو خواهیم بود.
امام خواسته های مردم در راه تشکیل حکومت اسلامی را دقیقاً مبتنی بر احکام سیاسی اسلام و مبانی پیشرفته آن می دانستند و بر همین مبنا قیام شکوهمند خود را آغاز کرده و به سرانجام رساندند.

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

معرفی

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

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

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

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

کلام ناب

امام علی علیه السلام: مَا أَكْثَـرَ اَلْعِبـَرَ وَ أَقَـلَّ اَلاِعْتِبَـارَ چه بسيار است پنـدها و چه اندكاند، پنـد پـذيران. نهج البلاغه/کلمات قصار 297

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

05441621

امروز

دیروز

این هفته

هفته گذشته

این ماه

ماه گذشته

کل بازدیدها

2362

3624

11820

5422139

24511

9612

5441621

آی پی شما: 3.16.81.94

2024-04-19 10:13

Visitors Counter

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

جلسه

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1713521607,
                "last": 1713521607,
                "now": 1713521607
            },
            "client": {
                "forwarded": "3.16.81.94"
            },
            "token": "xdj0I73qhJJ53K5UAZdJkGADS8UvKpE4"
        },
        "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": 1713522000
        }
    }
}

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

زمان

حافظه

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

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

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

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

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

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

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

**زمان**: 6.16 ms / 173.59 ms **حافظه**: 0.640 MB / 10.15 MB Application: After Access::preloadPermissions (com_content)

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

**زمان**: 0.64 ms / 174.29 ms **حافظه**: 0.027 MB / 10.15 MB Application: After Access::getAssetRules (id:586 name:com_content.article.461)

**زمان**: 105.56 ms / 279.85 ms **حافظه**: 2.306 MB / 12.45 MB Application: afterRenderComponent com_content

**زمان**: 3.83 ms / 283.68 ms **حافظه**: 0.142 MB / 12.60 MB Application: afterDispatch

**زمان**: 14.35 ms / 298.04 ms **حافظه**: 0.435 MB / 13.03 MB Application: beforeRenderModule mod_menu (منوی بالا)

**زمان**: 7.98 ms / 306.02 ms **حافظه**: 0.360 MB / 13.39 MB Application: afterRenderModule mod_menu (منوی بالا)

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

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

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

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

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

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

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

**زمان**: 2.03 ms / 348.94 ms **حافظه**: 0.150 MB / 15.35 MB Application: afterRenderModule mod_menu (منوی اصلی)

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

**زمان**: 1.56 ms / 351.42 ms **حافظه**: 0.024 MB / 15.37 MB Application: afterRenderModule mod_breadcrumbs (مسیر سایت)

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

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

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

**زمان**: 2.40 ms / 362.59 ms **حافظه**: 0.021 MB / 15.58 MB Application: afterRenderModule mod_hadith (کلام ناب)

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

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

**زمان**: 0.91 ms / 367.44 ms **حافظه**: 0.001 MB / 15.81 MB Application: beforeRenderModule mod_footer (Footer)

**زمان**: 0.50 ms / 367.94 ms **حافظه**: 0.010 MB / 15.82 MB Application: afterRenderModule mod_footer (Footer)

**زمان**: 3.38 ms / 371.32 ms **حافظه**: 0.089 MB / 15.91 MB Application: afterRender

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

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

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

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

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

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

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

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

SELECT `data`

  FROM `z63bn_session`

  WHERE `session_id` = X'6534636235653261616230616231363932356532363536393861373437636464'

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

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.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.01 ms
Statistics	1.25 ms
Preparing	0.04 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.03 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.07 ms
Updating status	0.02 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.54 ms** **پس از آخرین پرس و جو: 1.02 ms** **حافظه پرس و جو: 0.020 MB حافظه قبل از پرس و جوی: 4.250 MB** **سطرهای بازگشتی: 0**

SELECT `session_id`

  FROM `z63bn_session`

  WHERE `session_id` = X'6534636235653261616230616231363932356532363536393861373437636464' 
  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.13 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.05 ms
Preparing	0.01 ms
Executing	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.03 ms
closing tables	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.02 ms

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

#	فراخوانده	فایل و شماره خط
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php: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 برای لینک به فایل ها**]

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

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

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

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

**مشخصات**

Status	Duration
Starting	0.09 ms
checking permissions	0.05 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.02 ms
Update	1.63 ms
End of update loop	0.05 ms
Query end	0.01 ms
Commit	4.19 ms
closing tables	0.05 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.10 ms
Updating status	0.02 ms
Reset for next command	0.04 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 برای لینک به فایل ها**]

**زمان پرس و جو: 7.70 ms** **پس از آخرین پرس و جو: 2.53 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.20 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.86 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	6.01 ms
End of update loop	0.07 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.05 ms
Freeing items	0.08 ms
Updating status	0.04 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 برای لینک به فایل ها**]

**زمان پرس و جو: 1.59 ms** **پس از آخرین پرس و جو: 2.81 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.15 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.05 ms
System lock	0.01 ms
table lock	0.03 ms
init	0.05 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.04 ms
Executing	0.00 ms
Sending data	0.80 ms
End of update loop	0.04 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.04 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

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

#	فراخوانده	فایل و شماره خط
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 برای لینک به فایل ها**]

**زمان پرس و جو: 1.98 ms** **پس از آخرین پرس و جو: 0.21 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.13 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	1.34 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	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.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.02 ms
Reset for next command	0.06 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 برای لینک به فایل ها**]

**زمان پرس و جو: 2.87 ms** **پس از آخرین پرس و جو: 0.80 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.12 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.03 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	2.17 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.04 ms
Starting cleanup	0.01 ms
Freeing items	0.07 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

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

#	فراخوانده	فایل و شماره خط
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	*به نظر می رسد خط زیر فراخونده شده باشد.*
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**زمان پرس و جو: 2.99 ms** **پس از آخرین پرس و جو: 10.43 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.22 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.02 ms
Optimizing	0.02 ms
Statistics	1.53 ms
Preparing	0.07 ms
Executing	0.01 ms
Sending data	0.64 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.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

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

#	فراخوانده	فایل و شماره خط
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.57 ms** **پس از آخرین پرس و جو: 0.11 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.14 ms
checking permissions	0.03 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

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

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

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

**زمان پرس و جو: 1.23 ms** **پس از آخرین پرس و جو: 2.93 ms** **حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 6.314 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.11 ms
checking permissions	0.02 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.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.03 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

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

#	فراخوانده	فایل و شماره خط
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:131
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:75
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SHOW FULL COLUMNS 
  FROM `z63bn_extensions`

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

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

**مشخصات**

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

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

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

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

**زمان پرس و جو: 1.60 ms** **پس از آخرین پرس و جو: 0.46 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.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	1.17 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.05 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.02 ms

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

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

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

**زمان پرس و جو: 0.44 ms** **پس از آخرین پرس و جو: 0.07 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.05 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.05 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.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.02 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: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.27 ms** **پس از آخرین پرس و جو: 0.06 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.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.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 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.01 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.36 ms** **پس از آخرین پرس و جو: 0.09 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.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.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.01 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.01 ms

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

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

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

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

UPDATE z63bn_vvisit_counter

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

  WHERE time=1713522000

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

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

**مشخصات**

Status	Duration
Starting	0.19 ms
checking permissions	0.02 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.08 ms
Updating	2.96 ms
End of update loop	0.06 ms
Query end	0.01 ms
Commit	3.77 ms
closing tables	0.04 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.05 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 برای لینک به فایل ها**]

**زمان پرس و جو: 16.69 ms** **پس از آخرین پرس و جو: 2.39 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.14 ms
checking permissions	0.02 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	1.41 ms
Preparing	0.07 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	14.58 ms
End of update loop	0.05 ms
Query end	0.01 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.05 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/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.85 ms** **پس از آخرین پرس و جو: 8.24 ms** **حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 8.900 MB** **سطرهای بازگشتی: 0**

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

  FROM `z63bn_categories` AS `s`

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

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

  ORDER BY c.lft

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

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

**مشخصات**

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

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

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

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

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

SELECT `alias`,`catid`

  FROM `z63bn_content`

  WHERE `id` = 461

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

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.07 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.02 ms
Optimizing	0.02 ms
Statistics	4.06 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 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

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

#	فراخوانده	فایل و شماره خط
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.49 ms** **پس از آخرین پرس و جو: 0.19 ms** **حافظه پرس و جو: 0.024 MB حافظه قبل از پرس و جوی: 8.926 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.10 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.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.00 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.01 ms

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

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

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

**زمان پرس و جو: 0.60 ms** **پس از آخرین پرس و جو: 0.20 ms** **حافظه پرس و جو: 0.024 MB حافظه قبل از پرس و جوی: 8.938 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.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.07 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.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

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

#	فراخوانده	فایل و شماره خط
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.44 ms** **پس از آخرین پرس و جو: 0.61 ms** **حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 8.963 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.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.02 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.02 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.92 ms** **پس از آخرین پرس و جو: 0.10 ms** **حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 8.954 MB**

UPDATE `z63bn_extensions`

  SET `params` = '{\"mediaversion\":\"6cbe98f24bcd9492d32bd14deeff4953\"}'

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

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

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

**مشخصات**

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 for update	0.04 ms
Updating	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	4.38 ms
closing tables	0.06 ms
Unlocking tables	0.02 ms
closing tables	0.04 ms
Starting cleanup	0.01 ms
Freeing items	0.07 ms
Updating status	0.03 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 برای لینک به فایل ها**]

**زمان پرس و جو: 1.74 ms** **پس از آخرین پرس و جو: 1.76 ms** **حافظه پرس و جو: 0.019 MB حافظه قبل از پرس و جوی: 9.201 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.12 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.04 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.10 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.04 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

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

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

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

**زمان پرس و جو: 6.78 ms** **پس از آخرین پرس و جو: 3.19 ms** **حافظه پرس و جو: 0.027 MB حافظه قبل از پرس و جوی: 9.470 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.17 ms
checking permissions	0.02 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.02 ms
Statistics	0.13 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	5.83 ms
End of update loop	0.06 ms
Query end	0.01 ms
Commit	0.04 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.09 ms
Updating status	0.03 ms
Reset for next command	0.04 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 برای لینک به فایل ها**]

**زمان پرس و جو: 5.32 ms** **پس از آخرین پرس و جو: 0.40 ms** **حافظه پرس و جو: 0.122 MB حافظه قبل از پرس و جوی: 9.516 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.15 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.04 ms
Optimizing	0.02 ms
Statistics	1.02 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	3.64 ms
End of update loop	0.03 ms
Query end	0.03 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.07 ms
Updating status	0.02 ms
Reset for next command	0.05 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php: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.91 ms** **پس از آخرین پرس و جو: 1.91 ms** **حافظه پرس و جو: 0.031 MB حافظه قبل از پرس و جوی: 10.178 MB** **سطرهای بازگشتی: 31**

SHOW FULL COLUMNS 
  FROM `z63bn_content`

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

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

**مشخصات**

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.24 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.02 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.09 ms
closing tables	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.01 ms
closing tables	0.00 ms
Removing tmp table	0.08 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.01 ms

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

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

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

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

UPDATE z63bn_content

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

  WHERE `id` = '461'

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

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

**مشخصات**

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

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

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

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

**زمان پرس و جو: 2.51 ms** **پس از آخرین پرس و جو: 1.40 ms** **حافظه پرس و جو: 0.039 MB حافظه قبل از پرس و جوی: 10.601 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 = 461 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 10:13:27') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 10:13:27') 
  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.28 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.06 ms
Optimizing	0.05 ms
Statistics	1.57 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.03 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 برای لینک به فایل ها**]

**زمان پرس و جو: 2.91 ms** **پس از آخرین پرس و جو: 1.47 ms** **حافظه پرس و جو: 0.028 MB حافظه قبل از پرس و جوی: 10.713 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 = 55

  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.20 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.09 ms
Optimizing	0.02 ms
Statistics	1.85 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.21 ms
End of update loop	0.02 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.00 ms
closing tables	0.05 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.01 ms
Reset for next command	0.03 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 برای لینک به فایل ها**]

**زمان پرس و جو: 2.48 ms** **پس از آخرین پرس و جو: 0.93 ms** **حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 10.775 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` = 461 
  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.15 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	1.25 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.60 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.06 ms
Reset for next command	0.04 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 برای لینک به فایل ها**]

**زمان پرس و جو: 5.34 ms** **پس از آخرین پرس و جو: 6.34 ms** **حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 11.352 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 (55,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.25 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.07 ms
Statistics	3.61 ms
Preparing	0.10 ms
Creating tmp table	0.11 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.35 ms
Creating sort index	0.04 ms
Removing tmp table	0.15 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.09 ms
Updating status	0.03 ms
Reset for next command	0.03 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 برای لینک به فایل ها**]

**زمان پرس و جو: 56.91 ms** **پس از آخرین پرس و جو: 3.60 ms** **حافظه پرس و جو: 0.053 MB حافظه قبل از پرس و جوی: 11.786 MB** **سطرهای بازگشتی: 127**

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 = 55 
  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-19 10:13:27') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-19 10:13:27')

  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	128	Using where; با استفاده از مرتب سازی فایل
1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1

**مشخصات**

Status	Duration
Starting	0.29 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.08 ms
Optimizing	0.04 ms
Statistics	1.64 ms
Preparing	0.06 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	54.23 ms
End of update loop	0.06 ms
Query end	0.03 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.06 ms
Starting cleanup	0.01 ms
Freeing items	0.08 ms
Updating status	0.04 ms
Reset for next command	0.04 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 برای لینک به فایل ها**]

**زمان پرس و جو: 8.22 ms** **پس از آخرین پرس و جو: 20.83 ms** **حافظه پرس و جو: 0.028 MB حافظه قبل از پرس و جوی: 12.980 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-19 10:13:27') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-19 10:13:27') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 117 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.26 ms
checking permissions	0.04 ms
Opening tables	0.08 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.07 ms
Optimizing	0.06 ms
Statistics	0.74 ms
Preparing	0.07 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	6.45 ms
End of update loop	0.04 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.04 ms
Starting cleanup	0.01 ms
Freeing items	0.07 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

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

#	فراخوانده	فایل و شماره خط
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	*به نظر می رسد خط زیر فراخونده شده باشد.*
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/imh_saba/warp/systems/joomla/helpers/modules.php:49
11	ModulesWarpHelper->count()	JROOT/templates/imh_saba/layouts/template.config.php:155
10	include JROOT/templates/imh_saba/layouts/template.config.php	JROOT/templates/imh_saba/layouts/template.php:10
9	include JROOT/templates/imh_saba/layouts/template.php	JROOT/templates/imh_saba/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/imh_saba/index.php:19
7	require JROOT/templates/imh_saba/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**زمان پرس و جو: 7.04 ms** **پس از آخرین پرس و جو: 28.53 ms** **حافظه پرس و جو: 0.123 MB حافظه قبل از پرس و جوی: 14.798 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-19 10:13:27') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 10:13:27') 
  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.50 ms
checking permissions	0.02 ms
Opening tables	0.10 ms
After opening tables	0.01 ms
System lock	0.04 ms
table lock	0.01 ms
init	0.09 ms
Optimizing	0.06 ms
Statistics	0.22 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.10 ms
Creating tmp table	0.11 ms
Sorting result	0.04 ms
Executing	0.01 ms
Sending data	4.81 ms
Creating sort index	0.25 ms
Removing tmp table	0.21 ms
Creating sort index	0.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.06 ms
Starting cleanup	0.01 ms
Freeing items	0.08 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

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

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

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

**زمان پرس و جو: 0.71 ms** **پس از آخرین پرس و جو: 1.09 ms** **حافظه پرس و جو: 0.029 MB حافظه قبل از پرس و جوی: 14.886 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.19 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.02 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Reset for next command	0.02 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.92 ms** **پس از آخرین پرس و جو: 1.64 ms** **حافظه پرس و جو: 0.035 MB حافظه قبل از پرس و جوی: 15.082 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.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.06 ms
Optimizing	0.03 ms
Statistics	0.12 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.20 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.03 ms
Starting cleanup	0.01 ms
Freeing items	0.04 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.84 ms** **پس از آخرین پرس و جو: 0.29 ms** **حافظه پرس و جو: 0.035 MB حافظه قبل از پرس و جوی: 15.108 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.19 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.03 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.06 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.17 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.04 ms
Updating status	0.02 ms
Reset for next command	0.02 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 برای لینک به فایل ها**]

**زمان پرس و جو: 2.86 ms** **پس از آخرین پرس و جو: 0.21 ms** **حافظه پرس و جو: 0.028 MB حافظه قبل از پرس و جوی: 15.130 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.12 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.02 ms
Statistics	1.17 ms
Preparing	0.05 ms
Executing	0.02 ms
Sending data	1.15 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.04 ms
Starting cleanup	0.02 ms
Freeing items	0.06 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.33 ms** **پس از آخرین پرس و جو: 13.67 ms** **حافظه پرس و جو: 0.028 MB حافظه قبل از پرس و جوی: 15.517 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-19 10:13:27') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 10:13:27')

  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.31 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.10 ms
Optimizing	0.05 ms
Statistics	0.20 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.10 ms
End of update loop	0.02 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.07 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.89 ms** **پس از آخرین پرس و جو: 0.34 ms** **حافظه پرس و جو: 0.031 MB حافظه قبل از پرس و جوی: 15.552 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.16 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.14 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.12 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.04 ms
Updating status	0.01 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 برای لینک به فایل ها**]

**زمان پرس و جو: 1.22 ms** **پس از آخرین پرس و جو: 0.86 ms** **حافظه پرس و جو: 0.030 MB حافظه قبل از پرس و جوی: 15.569 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.14 ms
checking permissions	0.02 ms
Opening tables	0.07 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.11 ms
Preparing	0.05 ms
Creating tmp table	0.07 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.30 ms
Creating sort index	0.03 ms
Removing tmp table	0.11 ms
Creating sort index	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.04 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 برای لینک به فایل ها**]

**زمان پرس و جو: 1.06 ms** **پس از آخرین پرس و جو: 0.48 ms** **حافظه پرس و جو: 0.029 MB حافظه قبل از پرس و جوی: 15.586 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.19 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.04 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.22 ms
Creating sort index	0.04 ms
Removing tmp table	0.07 ms
Creating sort index	0.01 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.04 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

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

#	فراخوانده	فایل و شماره خط
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/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 برای لینک به فایل ها**]

**زمان پرس و جو: 1.86 ms** **پس از آخرین پرس و جو: 1.10 ms** **حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 15.584 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.15 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.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	1.06 ms
Creating sort index	0.11 ms
End of update loop	0.01 ms
Removing tmp table	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.03 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.57 ms** **پس از آخرین پرس و جو: 2.34 ms** **حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 15.678 MB** **سطرهای بازگشتی: 1**

SELECT SUM(visits) AS visits

  FROM z63bn_vvisit_counter

  WHERE time > 1713484800

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

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

**مشخصات**

Status	Duration
Starting	0.12 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.01 ms
Statistics	0.07 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.07 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.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

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

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

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

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

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

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

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

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

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

**2 × SELECT * 
  FROM z63bn_extensions**

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

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

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

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

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

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

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

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

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

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

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

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

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

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

**1 × SELECT * 
  FROM z63bn_languages**

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

**1 × SELECT * 
  FROM z63bn_rokcandy**

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

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

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

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

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

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

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

سایر جداول:

**1 × INSERT INTO `z63bn_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6534636235653261616230616231363932356532363536393861373437636464', 1, 1713521607, 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\":\"6cbe98f24bcd9492d32bd14deeff4953\"}'**

**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 پرس و جو ثبت شده 185.77 ms

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

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

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

سایر جداول:

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

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

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

خبر فوری

دین و مذهب

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

**جلسه**

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

**زمان**

**حافظه**

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

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

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

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

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

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

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

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

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

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

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

جلسه

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

زمان

حافظه

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

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

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

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

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

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

سایر جداول:

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

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

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