وب سایت مشاوره کنکور

_{مبتکر طرح پاد (پروش استعداد های درخشان)}

مشاورِ تو!

برای اولین بار مشاوره آنلاین تلفنی در سطح کشور توسط مهندس غیاثوند

مشاوره آنلاین تلفنی

راه های ارتباطی برای تعیین وقت مشاوره

09199100315 - 02126473180

saeed ghiasvand konkoor slide

: 12 شهریور 1400; بازدید: 672

رتبه‌ای که واسه انتخاب رشته مهمه!

روزی که کارنامه کنکور بیاد، قسمت پایین کارنامه یه جدول مثل عکس بالا داره. دو نوع رتبه اینجا وجود داره! یکی رتبه در سهمیه نهایی و یکی هم رتبه کشوری! حالا کدوم مهمه؟ در این مقاله به بررسی رتبه‌ای که واسه انتخاب رشته مهمه! می پردازیم که چه بسا دغدغه خیلی از شما دانش آموزان میتونه باشه.

روز کنکور که نتایج میاد، خیلیا اولین چیزی که نگاه میکنن رتبه کشوریه! و معمولا رتبه کشوری هم عدد بالاییه و یهو همونجا پس میفتن! رتبه مهم واسه انتخاب رشته، رتبه در سهمیه نهایی هست!

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

حالا چرا رتبه در سهمیه نهایی مهمه؟ نه رتبه کشوری! چون ظرفیت در نظر گرفته شده برای هر سهمیه جداست! و شما طبق رتبه در سهمیه نهاییتون با افرادی که تو سهمیه خودتون هستن، رقابت دارید! البته ریزکاری زیاد داره! مثلا نوع گزینش رشته‌ها (کشوری، استانی و...) داره و متفاوته و الان بازم گیجتون نمیکنم

مثلا بعضی کارنامه‌هایی که میبینی گذاشتن که با رتبه n رقمی یه رشته معقول قبول شده، دقت کن که گاهی رتبه کشوری رو به جای رتبه در سهمیه نهایی میذارن تا رتبه بالاتری باشه و تبلیغ خفن‌تری بشه! البته این کلک‌ها انواع مختلف داره و این فقط یه نوعشه!

مشاوره و برنامه ریزی کنکور | مطالب انگیزشی کنکور | مقالات کاربردی قبولی در کنکور

مهندس سعید غیاثوند

Rating:

( 0 Rating )

راه های ارتباطی با سعید غیاثوند

آدرس آموزشکاه : تهران، رسالت، خیابان هنگام، نرسیده به فرجام، ساختمان عتیق، پلاک ۳۹، واحد ۱۳

موبایل : 09199100315 تعیین وقت

شماره تلفن : 02126473180

ایمیل : saeed_ghiasvand61@yahoo.com

اینستاگرام: saeed_ghiasvand_konkoor

آپارات: saeedghiasvand

مقالات پر بازدید

حاضرین در سایت

ما 261 مهمان و بدون عضو آنلاین داریم

آمار سایت

کاربران: 88
مطالب: 214
نمایش تعداد مطالب: 238111

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

جلسه

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1735243978,
                "last": 1735243978,
                "now": 1735243978
            },
            "token": "ny2aqCqsILY227sR7s3LcMoyyjmGlMpE"
        },
        "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
        }
    }
}

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

زمان

حافظه

زمان: 22.03 ms / 22.03 ms حافظه: 2.009 MB / 2.39 MB Application: afterLoad

زمان: 189.32 ms / 211.35 ms حافظه: 9.101 MB / 11.49 MB Application: afterInitialise

زمان: 38.34 ms / 249.69 ms حافظه: 0.952 MB / 12.44 MB Application: afterRoute

زمان: 14.87 ms / 264.56 ms حافظه: 0.303 MB / 12.74 MB Application: beforeRenderComponent com_content

زمان: 3.83 ms / 268.39 ms حافظه: 0.198 MB / 12.94 MB Application: Before Access::preloadComponents (all components)

زمان: 5.74 ms / 274.13 ms حافظه: 0.056 MB / 13.00 MB Application: After Access::preloadComponents (all components)

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

زمان: 42.38 ms / 316.58 ms حافظه: 0.270 MB / 13.26 MB Application: After Access::preloadPermissions (com_content)

زمان: 0.08 ms / 316.66 ms حافظه: -0.019 MB / 13.24 MB Application: Before Access::getAssetRules (id:4296 name:com_content.article.206)

زمان: 1.00 ms / 317.65 ms حافظه: 0.027 MB / 13.27 MB Application: After Access::getAssetRules (id:4296 name:com_content.article.206)

زمان: 110.50 ms / 428.15 ms حافظه: 2.943 MB / 16.21 MB Application: afterRenderComponent com_content

زمان: 2.79 ms / 430.94 ms حافظه: 0.157 MB / 16.37 MB Application: afterDispatch

زمان: 46.90 ms / 477.84 ms حافظه: 1.031 MB / 17.40 MB Application: beforeRenderModule mod_menu (منوی موبایل offconvas)

زمان: 8.83 ms / 486.68 ms حافظه: 0.087 MB / 17.49 MB Application: afterRenderModule mod_menu (منوی موبایل offconvas)

زمان: 0.14 ms / 486.81 ms حافظه: -0.009 MB / 17.48 MB Application: beforeRenderModule mod_custom (متن کپی رایت)

زمان: 1.78 ms / 488.60 ms حافظه: 0.007 MB / 17.49 MB Application: afterRenderModule mod_custom (متن کپی رایت)

زمان: 0.11 ms / 488.70 ms حافظه: -0.002 MB / 17.48 MB Application: beforeRenderModule mod_whosonline (حاضرین در سایت)

زمان: 3.99 ms / 492.69 ms حافظه: 0.028 MB / 17.51 MB Application: afterRenderModule mod_whosonline (حاضرین در سایت)

زمان: 0.08 ms / 492.78 ms حافظه: -0.003 MB / 17.51 MB Application: beforeRenderModule mod_stats (آمار سایت)

زمان: 49.69 ms / 542.46 ms حافظه: 0.046 MB / 17.56 MB Application: afterRenderModule mod_stats (آمار سایت)

زمان: 0.16 ms / 542.62 ms حافظه: -0.002 MB / 17.55 MB Application: beforeRenderModule mod_articles_popular (مقالات پر بازدید)

زمان: 4.46 ms / 547.08 ms حافظه: 0.134 MB / 17.69 MB Application: Before Access::getAssetRules (id:8 name:com_content)

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

زمان: 9.36 ms / 556.48 ms حافظه: 0.151 MB / 17.84 MB Application: afterRenderModule mod_articles_popular (مقالات پر بازدید)

زمان: 0.16 ms / 556.65 ms حافظه: -0.152 MB / 17.69 MB Application: beforeRenderModule mod_custom (راه های ارتباطی با سعید غیاثوند)

زمان: 0.45 ms / 557.10 ms حافظه: 0.003 MB / 17.69 MB Application: afterRenderModule mod_custom (راه های ارتباطی با سعید غیاثوند)

زمان: 0.08 ms / 557.18 ms حافظه: -0.001 MB / 17.69 MB Application: beforeRenderModule mod_custom (اسلاید داخلی)

زمان: 0.42 ms / 557.60 ms حافظه: 0.003 MB / 17.69 MB Application: afterRenderModule mod_custom (اسلاید داخلی)

زمان: 0.10 ms / 557.70 ms حافظه: 0.001 MB / 17.70 MB Application: beforeRenderModule mod_custom (شماره های تماس)

زمان: 0.43 ms / 558.13 ms حافظه: 0.003 MB / 17.70 MB Application: afterRenderModule mod_custom (شماره های تماس)

زمان: 0.09 ms / 558.22 ms حافظه: -0.001 MB / 17.70 MB Application: beforeRenderModule mod_custom (مشاورِ تو!)

زمان: 0.43 ms / 558.65 ms حافظه: 0.003 MB / 17.70 MB Application: afterRenderModule mod_custom (مشاورِ تو!)

زمان: 0.08 ms / 558.73 ms حافظه: -0.001 MB / 17.70 MB Application: beforeRenderModule mod_custom (لوگوی بالا راست)

زمان: 0.41 ms / 559.13 ms حافظه: 0.006 MB / 17.71 MB Application: afterRenderModule mod_custom (لوگوی بالا راست)

زمان: 0.08 ms / 559.21 ms حافظه: -0.001 MB / 17.71 MB Application: beforeRenderModule mod_custom (چراغ چشمک زن)

زمان: 0.38 ms / 559.59 ms حافظه: 0.003 MB / 17.71 MB Application: afterRenderModule mod_custom (چراغ چشمک زن)

زمان: 342.85 ms / 902.44 ms حافظه: 4.152 MB / 21.86 MB Application: afterRender

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

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

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

44 پرس و جو ثبت شده 252.49 ms

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

2 تکراری: #22 #37

2 تکراری: #26 #27

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

SELECT `data`

  FROM `midx0_session`

  WHERE `session_id` = X'6233316633333635393663633935363933393662303263626135616561663864'

توضیح دادن

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

مشخصات

Status	Duration
Starting	0.13 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	2.94 ms
Preparing	0.07 ms
Executing	0.03 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.03 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.92 ms پس از آخرین پرس و جو: 2.37 ms حافظه پرس و جو: 0.020 MB حافظه قبل از پرس و جوی: 4.256 MB سطرهای بازگشتی: 0

SELECT `session_id`

  FROM `midx0_session`

  WHERE `session_id` = X'6233316633333635393663633935363933393662303263626135616561663864' 
  LIMIT 1

توضیح دادن

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

مشخصات

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

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

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

زمان پرس و جو: 5.96 ms پس از آخرین پرس و جو: 0.19 ms حافظه پرس و جو: 0.004 MB حافظه قبل از پرس و جوی: 4.261 MB

INSERT INTO `midx0_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6233316633333635393663633935363933393662303263626135616561663864', 1, 1735243978, 0, '', 0)

توضیح دادن

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

مشخصات

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

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

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

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

زمان پرس و جو: 4.85 ms پس از آخرین پرس و جو: 4.13 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 4.511 MB سطرهای بازگشتی: 41

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

  FROM `midx0_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	midx0_extensions	ref	extension	extension	82	const	42	Using index condition; Using where

مشخصات

Status	Duration
Starting	0.13 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.05 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.53 ms
Preparing	0.07 ms
Executing	0.03 ms
Sending data	3.32 ms
End of update loop	0.07 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.04 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.31 ms پس از آخرین پرس و جو: 4.08 ms حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 4.705 MB سطرهای بازگشتی: 5

SELECT id, rules

  FROM `midx0_viewlevels`

توضیح دادن

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

مشخصات

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

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

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

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

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

SELECT b.id

  FROM midx0_usergroups AS a

  LEFT JOIN midx0_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.09 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.06 ms
Statistics	0.92 ms
Preparing	0.05 ms
Unlocking tables	0.02 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.06 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

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

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

زمان پرس و جو: 3.96 ms پس از آخرین پرس و جو: 1.20 ms حافظه پرس و جو: 0.031 MB حافظه قبل از پرس و جوی: 4.785 MB سطرهای بازگشتی: 127

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

  FROM midx0_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	midx0_extensions	ALL	extension	کلید شاخصی برای استفاده نیست	NULL	NULL	274	Using where; با استفاده از مرتب سازی فایل

مشخصات

Status	Duration
Starting	0.13 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.04 ms
table lock	0.03 ms
init	0.06 ms
Optimizing	0.06 ms
Statistics	0.10 ms
Preparing	0.05 ms
Sorting result	0.03 ms
Executing	0.03 ms
Sending data	0.03 ms
Creating sort index	2.80 ms
End of update loop	0.08 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.05 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.34 ms پس از آخرین پرس و جو: 69.03 ms حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 8.234 MB سطرهای بازگشتی: 1

SELECT `params`

  FROM `midx0_extensions`

  WHERE `type` = 'component' 
  AND `element` = 'com_jchoptimize'

توضیح دادن

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

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_jchoptimize/lib/src/Service/ConfigurationProvider.php:25
9	JchOptimize\Service\ConfigurationProvider->JchOptimize\Service\{closure}()	JROOT/libraries/vendor/joomla/di/src/Container.php:457
8	Joomla\DI\Container->get()	JROOT/plugins/system/jchoptimize/jchoptimize.php:122
7	plgSystemJchoptimize->__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.92 ms پس از آخرین پرس و جو: 49.19 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 10.993 MB سطرهای بازگشتی: 28

SELECT *

  FROM midx0_rsform_config

توضیح دادن

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

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
11	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
10	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:102
9	RSFormProConfig::getInstance()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:26
8	plgSystemRsformdeletesubmissions->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `template`

  FROM `midx0_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

توضیح دادن

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

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/helix3/helix3.php:240
9	plgSystemHelix3->getTemplateName()	JROOT/plugins/system/helix3/helix3.php:38
8	plgSystemHelix3->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 برای لینک به فایل ها]

زمان پرس و جو: 10.89 ms پس از آخرین پرس و جو: 12.45 ms حافظه پرس و جو: 0.111 MB حافظه قبل از پرس و جوی: 11.674 MB سطرهای بازگشتی: 23

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 midx0_menu AS m

  LEFT JOIN midx0_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	84	Using index condition; Using where; با استفاده از مرتب سازی فایل
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	saeedghiasvand_saeedus.m.component_id	1	Using where

مشخصات

Status	Duration
Starting	0.17 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.06 ms
Optimizing	0.06 ms
Statistics	0.47 ms
Preparing	0.09 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.04 ms
Creating sort index	9.28 ms
End of update loop	0.09 ms
Query end	0.03 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 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 برای لینک به فایل ها]

زمان پرس و جو: 5.95 ms پس از آخرین پرس و جو: 13.06 ms حافظه پرس و جو: 0.024 MB حافظه قبل از پرس و جوی: 12.331 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 `midx0_categories` AS `s`

  INNER JOIN `midx0_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.published = 1 
  AND s.id = 10

  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_left_right	کلید شاخصی برای استفاده نیست	NULL	NULL	13	Using where; با استفاده از مرتب سازی فایل

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
14	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
13	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:165
12	ContentRouter->getCategoryId()	به نظر می رسد خط زیر فراخونده شده باشد.
11	call_user_func_array()	JROOT/libraries/src/Component/Router/Rules/StandardRules.php:93
10	Joomla\CMS\Component\Router\Rules\StandardRules->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 برای لینک به فایل ها]

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

SELECT `id`

  FROM `midx0_content`

  WHERE alias = 'رتبه‌ای-که-واسه-انتخاب-رشته-مهمه' 
  AND catid = '10'

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	midx0_content	ref	idx_catid,idx_alias	idx_alias	766	const	1	Using where

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:225
12	ContentRouter->getArticleId()	به نظر می رسد خط زیر فراخونده شده باشد.
11	call_user_func_array()	JROOT/libraries/src/Component/Router/Rules/StandardRules.php:140
10	Joomla\CMS\Component\Router\Rules\StandardRules->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 برای لینک به فایل ها]

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

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

  FROM `midx0_extensions`

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

توضیح دادن

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

مشخصات

Status	Duration
Starting	0.11 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.06 ms
Optimizing	0.05 ms
Statistics	0.10 ms
Preparing	0.05 ms
Executing	0.02 ms
Sending data	0.06 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.06 ms
Reset for next command	0.03 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 برای لینک به فایل ها]

زمان پرس و جو: 5.06 ms پس از آخرین پرس و جو: 0.29 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 12.466 MB

UPDATE `midx0_extensions`

  SET `params` = '{\"mediaversion\":\"402dda2fe53c9ed51c6232b2c6c962c3\"}'

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

توضیح دادن

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

مشخصات

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

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

SELECT *

  FROM midx0_languages

  WHERE published=1

  ORDER BY ordering ASC

توضیح دادن

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

مشخصات

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.04 ms
Sorting result	0.03 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	1.49 ms
End of update loop	0.04 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.03 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 برای لینک به فایل ها]

زمان پرس و جو: 1.26 ms پس از آخرین پرس و جو: 0.40 ms حافظه پرس و جو: 0.035 MB حافظه قبل از پرس و جوی: 12.663 MB سطرهای بازگشتی: 3

SELECT id, home, template, s.params

  FROM midx0_template_styles as s

  LEFT JOIN midx0_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	saeedghiasvand_saeedus.s.template,const	1	Using index condition; Using where

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
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.42 ms پس از آخرین پرس و جو: 5.33 ms حافظه پرس و جو: 0.027 MB حافظه قبل از پرس و جوی: 12.945 MB سطرهای بازگشتی: 39

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

  FROM `midx0_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_allvideoshare','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_fields','com_finder','com_gsd','com_installer','com_itemrating','com_jce','com_jchoptimize','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_rsform','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	midx0_assets	range	idx_asset_name	idx_asset_name	202	NULL	42	Using index condition

مشخصات

Status	Duration
Starting	0.14 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	0.14 ms
Preparing	0.04 ms
Executing	0.02 ms
Sending data	4.41 ms
End of update loop	0.07 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.02 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 برای لینک به فایل ها]

زمان پرس و جو: 41.21 ms پس از آخرین پرس و جو: 0.40 ms حافظه پرس و جو: 0.052 MB حافظه قبل از پرس و جوی: 12.993 MB سطرهای بازگشتی: 310

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

  FROM `midx0_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	midx0_assets	ALL	idx_asset_name,idx_parent_id	کلید شاخصی برای استفاده نیست	NULL	NULL	6372	Using where

مشخصات

Status	Duration
Starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	7.85 ms
Preparing	0.11 ms
Executing	0.02 ms
Sending data	32.41 ms
End of update loop	0.10 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.02 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 برای لینک به فایل ها]

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

SHOW FULL COLUMNS 
  FROM `midx0_content`

توضیح دادن

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

مشخصات

Status	Duration
Starting	0.12 ms
checking permissions	0.03 ms
closing tables	0.02 ms
checking permissions	0.02 ms
Opening tables	0.54 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.04 ms
Executing	0.02 ms
Filling schema table	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
checking permissions	0.26 ms
closing tables	0.04 ms
checking permissions	0.03 ms
Executing	0.02 ms
Sending data	0.11 ms
End of update loop	0.03 ms
Query end	0.03 ms
closing tables	0.02 ms
Removing tmp table	0.23 ms
closing tables	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.03 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 برای لینک به فایل ها]

زمان پرس و جو: 34.76 ms پس از آخرین پرس و جو: 5.75 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 13.597 MB

UPDATE midx0_content

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

  WHERE `id` = '206'

توضیح دادن

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

مشخصات

Status	Duration
Starting	0.15 ms
checking permissions	0.04 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
init for update	0.13 ms
Updating	19.42 ms
End of update loop	0.09 ms
Query end	0.03 ms
Commit	14.19 ms
Query end	0.24 ms
closing tables	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.02 ms

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

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

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

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

پرس و جوی تکراری: #37

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 midx0_content AS a

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

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

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

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

  WHERE a.id = 206 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-26 20:12:58') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-26 20:12:58') 
  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.03 ms
Opening tables	0.09 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.12 ms
Optimizing	0.08 ms
Statistics	1.39 ms
Preparing	0.04 ms
Unlocking tables	0.02 ms
Preparing	0.04 ms
Executing	0.02 ms
Sending data	0.09 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

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

#	فراخوانده	فایل و شماره خط
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.02 ms پس از آخرین پرس و جو: 3.34 ms حافظه پرس و جو: 0.027 MB حافظه قبل از پرس و جوی: 13.826 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 `midx0_categories` AS `s`

  INNER JOIN `midx0_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 = 10

  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	13	Using where; با استفاده از مرتب سازی فایل

مشخصات

Status	Duration
Starting	0.23 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.10 ms
Optimizing	0.07 ms
Statistics	0.59 ms
Preparing	0.04 ms
Unlocking tables	0.02 ms
Preparing	0.05 ms
Sorting result	0.03 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.15 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.06 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 برای لینک به فایل ها]

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

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

  FROM `midx0_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 206 
  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	742	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	saeedghiasvand_saeedus.m.tag_id	1	Using where

مشخصات

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

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

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

زمان پرس و جو: 4.01 ms پس از آخرین پرس و جو: 18.03 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 15.302 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 midx0_fields AS a

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

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

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

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

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

  LEFT JOIN `midx0_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 (10,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	saeedghiasvand_saeedus.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	saeedghiasvand_saeedus.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	saeedghiasvand_saeedus.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	saeedghiasvand_saeedus.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	saeedghiasvand_saeedus.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	saeedghiasvand_saeedus.a.id	1	Using where; Using index; Distinct

مشخصات

Status	Duration
Starting	0.36 ms
checking permissions	0.04 ms
Opening tables	0.12 ms
After opening tables	0.04 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.13 ms
Optimizing	0.10 ms
Statistics	1.32 ms
Preparing	0.15 ms
Creating tmp table	0.18 ms
Sorting result	0.05 ms
Executing	0.11 ms
Sending data	0.67 ms
Creating sort index	0.08 ms
Removing tmp table	0.18 ms
Creating sort index	0.04 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

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

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

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

زمان پرس و جو: 1.57 ms پس از آخرین پرس و جو: 4.58 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 15.675 MB سطرهای بازگشتی: 0

پرس و جوی تکراری: #27

SELECT *

  FROM `midx0_itemrating_group`

  WHERE `customcategory` REGEXP '"com_content":\\[("[[:digit:]]*",)?"10"' 
  AND `state`=1

توضیح دادن

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

مشخصات

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

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

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

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

زمان پرس و جو: 1.14 ms پس از آخرین پرس و جو: 5.54 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 15.887 MB سطرهای بازگشتی: 0

پرس و جوی تکراری: #26

SELECT *

  FROM `midx0_itemrating_group`

  WHERE `customcategory` REGEXP '"com_content":\\[("[[:digit:]]*",)?"10"' 
  AND `state`=1

توضیح دادن

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

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_itemrating/helpers/itemrating.php:1214
14	ItemratingHelper::allowCategory()	JROOT/plugins/content/itemrating/itemrating.php:106
13	PlgContentItemRating->onContentAfterDisplay()	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:202
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.97 ms پس از آخرین پرس و جو: 43.90 ms حافظه پرس و جو: 0.048 MB حافظه قبل از پرس و جوی: 17.422 MB سطرهای بازگشتی: 39

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

  FROM midx0_modules AS m

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

  LEFT JOIN midx0_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-12-26 20:12:58') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-26 20:12:58') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 108 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	30	Using index condition; Using where; با استفاده از مرتب سازی فایل
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	saeedghiasvand_saeedus.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	saeedghiasvand_saeedus.m.module,const	1	Using index condition; Using where

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	به نظر می رسد خط زیر فراخونده شده باشد.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
14	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
11	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helix3/core/helix3.php:588
10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:535
9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:326
8	Helix3::generatelayout()	JROOT/templates/sitetemplate/index.php:185
7	require JROOT/templates/sitetemplate/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.54 ms پس از آخرین پرس و جو: 28.49 ms حافظه پرس و جو: 0.041 MB حافظه قبل از پرس و جوی: 17.523 MB سطرهای بازگشتی: 261

SELECT guest, client_id

  FROM midx0_session

  WHERE client_id = 0

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	midx0_session	ref	client_id_guest	client_id_guest	2	const	261	Using index

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_whosonline/helper.php:45
11	ModWhosonlineHelper::getOnlineCount()	JROOT/modules/mod_whosonline/mod_whosonline.php:19
10	include JROOT/modules/mod_whosonline/mod_whosonline.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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.80 ms پس از آخرین پرس و جو: 3.18 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 17.552 MB سطرهای بازگشتی: 1

SELECT COUNT(id) AS count_users

  FROM midx0_users

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	midx0_users	index	NULL	idx_block	1	NULL	88	Using index

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/modules/mod_stats/helper.php:80
11	ModStatsHelper::getList()	JROOT/modules/mod_stats/mod_stats.php:17
10	include JROOT/modules/mod_stats/mod_stats.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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.35 ms پس از آخرین پرس و جو: 0.15 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 17.559 MB سطرهای بازگشتی: 1

SELECT COUNT(id) AS count_items

  FROM midx0_content

  WHERE state = 1

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	midx0_content	ref	idx_state	idx_state	1	const	214	Using index

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/modules/mod_stats/helper.php:95
11	ModStatsHelper::getList()	JROOT/modules/mod_stats/mod_stats.php:17
10	include JROOT/modules/mod_stats/mod_stats.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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 برای لینک به فایل ها]

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

SELECT SUM(hits) AS count_hits

  FROM midx0_content

  WHERE state = 1

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	midx0_content	ref	idx_state	idx_state	1	const	214

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/modules/mod_stats/helper.php:129
11	ModStatsHelper::getList()	JROOT/modules/mod_stats/mod_stats.php:17
10	include JROOT/modules/mod_stats/mod_stats.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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 برای لینک به فایل ها]

زمان پرس و جو: 6.58 ms پس از آخرین پرس و جو: 5.37 ms حافظه پرس و جو: 0.145 MB حافظه قبل از پرس و جوی: 17.697 MB سطرهای بازگشتی: 5

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,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM midx0_content AS a

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

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

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

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

  LEFT JOIN midx0_content_rating AS v 
  ON a.id = v.content_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 (10) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-26 20:12:58') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-26 20:12:58') 
  AND (a.created >= '1000-01-01 00:00:00' 
  AND a.created <= '9999-12-31 23:59:59')

  ORDER BY a.hits DESC 
  LIMIT 5

توضیح دادن

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	index_merge	idx_access,idx_state,idx_catid	idx_catid,idx_state	4,1	NULL	112	Using intersect(idx_catid,idx_state); Using where; با استفاده از مرتب سازی فایل
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	saeedghiasvand_saeedus.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	saeedghiasvand_saeedus.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	saeedghiasvand_saeedus.a.id	1	Using where

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_popular/helper.php:77
11	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
10	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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.09 ms پس از آخرین پرس و جو: 8.10 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 17.872 MB سطرهای بازگشتی: 1

SELECT *

  FROM `midx0_extensions`

  WHERE `element` = 'com_gsd' 
  AND `type` = 'component'

توضیح دادن

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

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
19	JDatabaseDriver->loadAssoc()	JROOT/plugins/system/nrframework/NRFramework/Extension.php:124
18	NRFramework\Extension::get()	JROOT/plugins/system/nrframework/NRFramework/Extension.php:176
17	NRFramework\Extension::isEnabled()	JROOT/plugins/system/nrframework/NRFramework/Extension.php:159
16	NRFramework\Extension::componentIsEnabled()	JROOT/plugins/system/gsd/gsd.php:484
15	plgSystemGSD->setup()	JROOT/plugins/system/gsd/gsd.php:527
14	plgSystemGSD->getHelper()	JROOT/plugins/system/gsd/gsd.php:65
13	plgSystemGSD->init()	JROOT/plugins/system/gsd/gsd.php:54
12	plgSystemGSD->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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.50 ms پس از آخرین پرس و جو: 1.99 ms حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 17.956 MB سطرهای بازگشتی: 2

SHOW FULL COLUMNS 
  FROM `midx0_gsd_config`

توضیح دادن

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

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
20	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
19	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_gsd/tables/config.php:26
18	GSDTableConfig->__construct()	JROOT/libraries/src/Table/Table.php:328
17	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_gsd/GSD/Helper.php:412
16	GSD\Helper::getParams()	JROOT/plugins/system/gsd/gsd.php:496
15	plgSystemGSD->setup()	JROOT/plugins/system/gsd/gsd.php:527
14	plgSystemGSD->getHelper()	JROOT/plugins/system/gsd/gsd.php:65
13	plgSystemGSD->init()	JROOT/plugins/system/gsd/gsd.php:54
12	plgSystemGSD->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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.80 ms پس از آخرین پرس و جو: 0.29 ms حافظه پرس و جو: 0.024 MB حافظه قبل از پرس و جوی: 17.971 MB سطرهای بازگشتی: 1

SELECT *

  FROM midx0_gsd_config

  WHERE `name` = 'config'

توضیح دادن

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

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
17	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_gsd/GSD/Helper.php:413
16	GSD\Helper::getParams()	JROOT/plugins/system/gsd/gsd.php:496
15	plgSystemGSD->setup()	JROOT/plugins/system/gsd/gsd.php:527
14	plgSystemGSD->getHelper()	JROOT/plugins/system/gsd/gsd.php:65
13	plgSystemGSD->init()	JROOT/plugins/system/gsd/gsd.php:54
12	plgSystemGSD->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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.04 ms پس از آخرین پرس و جو: 29.85 ms حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 18.993 MB سطرهای بازگشتی: 1

پرس و جوی تکراری: #22

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 midx0_content AS a

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

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

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

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

  WHERE a.id = 206 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-26 20:12:58') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-26 20:12:58') 
  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.32 ms
checking permissions	0.04 ms
Opening tables	0.10 ms
After opening tables	0.04 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.11 ms
Optimizing	0.11 ms
Statistics	0.63 ms
Preparing	0.04 ms
Unlocking tables	0.03 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.08 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

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

#	فراخوانده	فایل و شماره خط
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
22	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
21	ContentModelArticle->getItem()	JROOT/plugins/gsd/content/content.php:55
20	plgGSDContent->viewArticle()	JROOT/administrator/components/com_gsd/GSD/PluginBase.php:395
19	GSD\PluginBase->getPayload()	JROOT/administrator/components/com_gsd/GSD/PluginBase.php:225
18	GSD\PluginBase->onGSDBeforeRender()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_gsd/GSD/Helper.php:451
14	GSD\Helper::event()	JROOT/plugins/system/gsd/gsd.php:85
13	plgSystemGSD->init()	JROOT/plugins/system/gsd/gsd.php:54
12	plgSystemGSD->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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 برای لینک به فایل ها]

زمان پرس و جو: 9.51 ms پس از آخرین پرس و جو: 2.33 ms حافظه پرس و جو: 0.241 MB حافظه قبل از پرس و جوی: 19.055 MB سطرهای بازگشتی: 213

SELECT a.*

  FROM midx0_gsd a

  WHERE a.state = 1 
  AND a.plugin = 'content' 
  AND a.appview IN ('article','*')

  ORDER BY a.id desc

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index	state,plugin	PRIMARY	4	NULL	217	Using where

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_gsd/models/items.php:165
20	GSDModelItems->getItems()	JROOT/administrator/components/com_gsd/GSD/PluginBase.php:294
19	GSD\PluginBase->getSnippets()	JROOT/administrator/components/com_gsd/GSD/PluginBase.php:231
18	GSD\PluginBase->onGSDBeforeRender()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_gsd/GSD/Helper.php:451
14	GSD\Helper::event()	JROOT/plugins/system/gsd/gsd.php:85
13	plgSystemGSD->init()	JROOT/plugins/system/gsd/gsd.php:54
12	plgSystemGSD->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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 برای لینک به فایل ها]

زمان پرس و جو: 10.42 ms پس از آخرین پرس و جو: 30.40 ms حافظه پرس و جو: 0.031 MB حافظه قبل از پرس و جوی: 19.444 MB سطرهای بازگشتی: 1

SELECT count(id)

  FROM midx0_users

  WHERE id = '874'

توضیح دادن

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

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
32	JDatabaseDriver->loadResult()	JROOT/plugins/system/nrframework/NRFramework/User.php:67
31	NRFramework\User::exists()	JROOT/plugins/system/nrframework/NRFramework/User.php:34
30	NRFramework\User::get()	JROOT/plugins/system/nrframework/NRFramework/Factory.php:58
29	NRFramework\Factory->getUser()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/User.php:96
28	NRFramework\SmartTags\User->getUser()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/User.php:50
27	NRFramework\SmartTags\User->fetchValue()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/User.php:106
26	NRFramework\SmartTags\User->getName()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:528
25	NRFramework\SmartTags\SmartTags->getSmartTagValue()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:352
24	NRFramework\SmartTags\SmartTags->replaceSmartTagsInContent()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:274
23	NRFramework\SmartTags\SmartTags->replaceFoundSmartTags()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:238
22	NRFramework\SmartTags\SmartTags->replace()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:245
21	NRFramework\SmartTags\SmartTags->replace()	JROOT/administrator/components/com_gsd/GSD/MappingOptions.php:125
20	GSD\MappingOptions::replace()	JROOT/administrator/components/com_gsd/GSD/PluginBase.php:437
19	GSD\PluginBase->preparePayload()	JROOT/administrator/components/com_gsd/GSD/PluginBase.php:241
18	GSD\PluginBase->onGSDBeforeRender()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_gsd/GSD/Helper.php:451
14	GSD\Helper::event()	JROOT/plugins/system/gsd/gsd.php:85
13	plgSystemGSD->init()	JROOT/plugins/system/gsd/gsd.php:54
12	plgSystemGSD->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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.13 ms پس از آخرین پرس و جو: 1.64 ms حافظه پرس و جو: 0.036 MB حافظه قبل از پرس و جوی: 19.521 MB سطرهای بازگشتی: 16

SHOW FULL COLUMNS 
  FROM `midx0_users`

توضیح دادن

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

مشخصات

Status	Duration
Starting	0.12 ms
checking permissions	0.03 ms
closing tables	0.02 ms
checking permissions	0.02 ms
Opening tables	0.61 ms
After opening tables	0.04 ms
System lock	0.02 ms
table lock	0.03 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.04 ms
Preparing	0.04 ms
Executing	0.03 ms
Filling schema table	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
checking permissions	0.15 ms
closing tables	0.04 ms
checking permissions	0.03 ms
Executing	0.03 ms
Sending data	0.09 ms
End of update loop	0.04 ms
Query end	0.03 ms
closing tables	0.02 ms
Removing tmp table	0.23 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.02 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

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

#	فراخوانده	فایل و شماره خط
42	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
41	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
40	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
39	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
38	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
37	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
36	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
35	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
34	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
33	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
32	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
31	Joomla\CMS\Factory::getUser()	JROOT/plugins/system/nrframework/NRFramework/User.php:39
30	NRFramework\User::get()	JROOT/plugins/system/nrframework/NRFramework/Factory.php:58
29	NRFramework\Factory->getUser()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/User.php:96
28	NRFramework\SmartTags\User->getUser()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/User.php:50
27	NRFramework\SmartTags\User->fetchValue()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/User.php:106
26	NRFramework\SmartTags\User->getName()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:528
25	NRFramework\SmartTags\SmartTags->getSmartTagValue()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:352
24	NRFramework\SmartTags\SmartTags->replaceSmartTagsInContent()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:274
23	NRFramework\SmartTags\SmartTags->replaceFoundSmartTags()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:238
22	NRFramework\SmartTags\SmartTags->replace()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:245
21	NRFramework\SmartTags\SmartTags->replace()	JROOT/administrator/components/com_gsd/GSD/MappingOptions.php:125
20	GSD\MappingOptions::replace()	JROOT/administrator/components/com_gsd/GSD/PluginBase.php:437
19	GSD\PluginBase->preparePayload()	JROOT/administrator/components/com_gsd/GSD/PluginBase.php:241
18	GSD\PluginBase->onGSDBeforeRender()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_gsd/GSD/Helper.php:451
14	GSD\Helper::event()	JROOT/plugins/system/gsd/gsd.php:85
13	plgSystemGSD->init()	JROOT/plugins/system/gsd/gsd.php:54
12	plgSystemGSD->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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.99 ms پس از آخرین پرس و جو: 0.32 ms حافظه پرس و جو: 0.032 MB حافظه قبل از پرس و جوی: 19.558 MB سطرهای بازگشتی: 1

SELECT *

  FROM `midx0_users`

  WHERE `id` = 874

توضیح دادن

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

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
36	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
35	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
34	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
33	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
32	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
31	Joomla\CMS\Factory::getUser()	JROOT/plugins/system/nrframework/NRFramework/User.php:39
30	NRFramework\User::get()	JROOT/plugins/system/nrframework/NRFramework/Factory.php:58
29	NRFramework\Factory->getUser()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/User.php:96
28	NRFramework\SmartTags\User->getUser()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/User.php:50
27	NRFramework\SmartTags\User->fetchValue()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/User.php:106
26	NRFramework\SmartTags\User->getName()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:528
25	NRFramework\SmartTags\SmartTags->getSmartTagValue()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:352
24	NRFramework\SmartTags\SmartTags->replaceSmartTagsInContent()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:274
23	NRFramework\SmartTags\SmartTags->replaceFoundSmartTags()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:238
22	NRFramework\SmartTags\SmartTags->replace()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:245
21	NRFramework\SmartTags\SmartTags->replace()	JROOT/administrator/components/com_gsd/GSD/MappingOptions.php:125
20	GSD\MappingOptions::replace()	JROOT/administrator/components/com_gsd/GSD/PluginBase.php:437
19	GSD\PluginBase->preparePayload()	JROOT/administrator/components/com_gsd/GSD/PluginBase.php:241
18	GSD\PluginBase->onGSDBeforeRender()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_gsd/GSD/Helper.php:451
14	GSD\Helper::event()	JROOT/plugins/system/gsd/gsd.php:85
13	plgSystemGSD->init()	JROOT/plugins/system/gsd/gsd.php:54
12	plgSystemGSD->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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.23 ms پس از آخرین پرس و جو: 5.90 ms حافظه پرس و جو: 0.032 MB حافظه قبل از پرس و جوی: 20.337 MB سطرهای بازگشتی: 1

SELECT `g`.`id`,`g`.`title`

  FROM `midx0_usergroups` AS g

  INNER JOIN `midx0_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 874

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	saeedghiasvand_saeedus.m.group_id	1

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
36	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
35	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
34	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
33	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
32	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
31	Joomla\CMS\Factory::getUser()	JROOT/plugins/system/nrframework/NRFramework/User.php:39
30	NRFramework\User::get()	JROOT/plugins/system/nrframework/NRFramework/Factory.php:58
29	NRFramework\Factory->getUser()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/User.php:96
28	NRFramework\SmartTags\User->getUser()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/User.php:50
27	NRFramework\SmartTags\User->fetchValue()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/User.php:106
26	NRFramework\SmartTags\User->getName()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:528
25	NRFramework\SmartTags\SmartTags->getSmartTagValue()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:352
24	NRFramework\SmartTags\SmartTags->replaceSmartTagsInContent()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:274
23	NRFramework\SmartTags\SmartTags->replaceFoundSmartTags()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:238
22	NRFramework\SmartTags\SmartTags->replace()	JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:245
21	NRFramework\SmartTags\SmartTags->replace()	JROOT/administrator/components/com_gsd/GSD/MappingOptions.php:125
20	GSD\MappingOptions::replace()	JROOT/administrator/components/com_gsd/GSD/PluginBase.php:437
19	GSD\PluginBase->preparePayload()	JROOT/administrator/components/com_gsd/GSD/PluginBase.php:241
18	GSD\PluginBase->onGSDBeforeRender()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_gsd/GSD/Helper.php:451
14	GSD\Helper::event()	JROOT/plugins/system/gsd/gsd.php:85
13	plgSystemGSD->init()	JROOT/plugins/system/gsd/gsd.php:54
12	plgSystemGSD->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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.10 ms پس از آخرین پرس و جو: 3.07 ms حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 20.350 MB سطرهای بازگشتی: 0

SELECT a.*

  FROM midx0_gsd a

  WHERE a.state = 1 
  AND a.plugin = 'menus' 
  AND a.appview IN ('menus','*')

  ORDER BY a.id desc

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	state,plugin	plugin	152	const	1	Using where

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_gsd/models/items.php:165
20	GSDModelItems->getItems()	JROOT/administrator/components/com_gsd/GSD/PluginBase.php:294
19	GSD\PluginBase->getSnippets()	JROOT/administrator/components/com_gsd/GSD/PluginBase.php:231
18	GSD\PluginBase->onGSDBeforeRender()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_gsd/GSD/Helper.php:451
14	GSD\Helper::event()	JROOT/plugins/system/gsd/gsd.php:85
13	plgSystemGSD->init()	JROOT/plugins/system/gsd/gsd.php:54
12	plgSystemGSD->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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.15 ms پس از آخرین پرس و جو: 3.12 ms حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 20.436 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 `midx0_categories` AS `s`

  INNER JOIN `midx0_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 = 12

  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	13	Using where; با استفاده از مرتب سازی فایل

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
17	ContentRouter->getCategorySegment()	به نظر می رسد خط زیر فراخونده شده باشد.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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 برای لینک به فایل ها]

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

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

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 `midx0_categories` AS `s` 
  INNER JOIN `midx0_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 `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `midx0_extensions`

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `midx0_assets`

2 × 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 midx0_content AS a 
  INNER JOIN midx0_categories AS c 
  on c.id = a.catid 
  LEFT JOIN midx0_users AS u 
  on u.id = a.created_by 
  LEFT JOIN midx0_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN midx0_content_rating AS v 
  ON a.id = v.content_id

2 × SELECT * 
  FROM `midx0_itemrating_group`

```
2 × SELECT a.* 
  FROM midx0_gsd a
```

1 × SELECT `data` 
  FROM `midx0_session`

1 × SELECT `session_id` 
  FROM `midx0_session`

1 × SELECT id, rules 
  FROM `midx0_viewlevels

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

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

1 × SELECT `params` 
  FROM `midx0_extensions`

1 × SELECT * 
  FROM midx0_rsform_confi

1 × SELECT `template` 
  FROM `midx0_template_styles`

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 midx0_menu AS m 
  LEFT JOIN midx0_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `id` 
  FROM `midx0_content`

```
1 × SELECT * 
  FROM midx0_languages
```

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

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `midx0_contentitem_tag_map` AS m  
  INNER JOIN `midx0_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 midx0_fields AS a 
  LEFT JOIN `midx0_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN midx0_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN midx0_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN midx0_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN midx0_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `midx0_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM midx0_modules AS m 
  LEFT JOIN midx0_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN midx0_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT guest, client_id 
  FROM midx0_session

1 × SELECT COUNT(id) AS count_users 
  FROM midx0_user

1 × SELECT COUNT(id) AS count_items 
  FROM midx0_content

1 × SELECT SUM(hits) AS count_hits 
  FROM midx0_content

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,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,        COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
  FROM midx0_content AS a 
  LEFT JOIN midx0_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN midx0_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN midx0_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN midx0_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN midx0_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT * 
  FROM `midx0_extensions`

```
1 × SELECT * 
  FROM midx0_gsd_config
```

1 × SELECT count(id) 
  FROM midx0_users

```
1 × SELECT * 
  FROM `midx0_users`
```

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `midx0_usergroups` AS g 
  INNER JOIN `midx0_user_usergroup_map` AS m 
  ON m.group_id = g.id

سایر جداول:

1 × INSERT INTO `midx0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6233316633333635393663633935363933393662303263626135616561663864', 1, 1735243978, 0, '', 0

1 × UPDATE `midx0_extensions` 
  SET `params` = '{\"mediaversion\":\"402dda2fe53c9ed51c6232b2c6c962c3\"}'

1 × SHOW FULL COLUMNS 
  FROM `midx0_content

1 × UPDATE midx0_content 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `midx0_gsd_config

1 × SHOW FULL COLUMNS 
  FROM `midx0_users