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

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

مشاورِ تو!

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

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

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

09199100315 - 02126473180

saeed ghiasvand konkoor slide

: 09 آبان 1400; بازدید: 1112

چگونه کیفیت مطالعه را افزایش دهیم؟

اولین نکته بسیار مهم در بالا بردن کیفیت مطالعه، داشتن تراکم در مطالعه است. کما اینکه اگر کسی در تابستان فرضا 15 ساعت در طول روز درس بخواند از لحاظ کمیت بسیار عالیست اما ممکن است تراکم لازم را نداشته و به دلیل ساعت مطالعه بالا و حجم کار کم انجام شده دچار دلزدگی شود.

تراکم در مطالعه

برای جا افتادن مطلب مثال دیگری می زنیم:

برای مثال فرض کنید که شخصی در روز 6 ساعت درس خوانده و با کورنومتر این عدد را ثبت کرده است. حال از این شخص سوال میشود که میزان درگیری او با درس چه قدر بوده و درس خواندن را از چه ساعتی آغاز و در چه ساعتی به اتمام برده است؟ جواب این است: از 8 صبح تا 10 شب!!!!!
یعنی به ازای 14 ساعت درگیری با کتاب فقط 6 ساعت مطالعه مفید داشته و این یعنی عدم تراکم در مطالعه که بسیار آسیب زا است.
در حالی که اگر همین شخص به ازای 6 ساعت مطالعه فرضا 7 ساعت درگیری با کتاب داشته باشد عالی است و موفق شده متراکم خوانی داشته باشد.

متراکم خواندن یعنی اینکه در مطالعه جدی تر باشید

تعداد تست و تمرین زیاد و تسلط بر روی تست ها

دومین فاکتور در افزایش کیفیت مطالعه افزایش تعداد تست و تمرین و تسلط بر روی تست ها است. دستاورد کیفیت مطالعه و ساعت مطالعه بالا باید به این نقطه ختم شود که ما تعداد تست و تمرین را زیاد کرده و روی تست ها به تسلط کافی برسیم. برای مطالعه بار اول نیاز نیست به تسلط کامل برسیم و می توانیم این مهم را با لحاظ کردن تست پوششی در برنامه روزانه به دست آوریم.

به این معنا که از مباحث قبلی حل تست و تمرین انجام داده و سعی کنیم مطالبی که فرضا در هفته گذشته خوانده ایم نه تنها فراموش نکنیم بلکه به تسلط روی آنها دست یابیم. تعداد تست و تمرین زیاد، تکرار تست های علامت دار (تکرار تست هایی که قبلا زده ایم و مجدد از آنها حل تست انجام می دهیم) اهمیت بسیار بسیار بالایی دارد.

تعداد صفحات مورد مطالعه

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

____________________

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

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

articles

Our Rating: 88% - 30 votes

88%

Rating:

( 0 Rating )

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

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

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

شماره تلفن : 02126473180

ایمیل : saeed_ghiasvand61@yahoo.com

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

آپارات: saeedghiasvand

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

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

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

آمار سایت

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

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

جلسه

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

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

زمان

حافظه

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

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

زمان: 70.96 ms / 302.18 ms حافظه: 0.952 MB / 12.45 MB Application: afterRoute

زمان: 17.14 ms / 319.31 ms حافظه: 0.303 MB / 12.75 MB Application: beforeRenderComponent com_content

زمان: 5.60 ms / 324.92 ms حافظه: 0.198 MB / 12.95 MB Application: Before Access::preloadComponents (all components)

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

زمان: 0.08 ms / 332.36 ms حافظه: -0.004 MB / 13.00 MB Application: Before Access::preloadPermissions (com_content)

زمان: 24.80 ms / 357.15 ms حافظه: 0.270 MB / 13.27 MB Application: After Access::preloadPermissions (com_content)

زمان: 0.07 ms / 357.22 ms حافظه: -0.019 MB / 13.25 MB Application: Before Access::getAssetRules (id:4319 name:com_content.article.229)

زمان: 0.73 ms / 357.95 ms حافظه: 0.027 MB / 13.28 MB Application: After Access::getAssetRules (id:4319 name:com_content.article.229)

زمان: 91.76 ms / 449.72 ms حافظه: 3.093 MB / 16.37 MB Application: afterRenderComponent com_content

زمان: 1.62 ms / 451.34 ms حافظه: 0.094 MB / 16.46 MB Application: afterDispatch

زمان: 29.68 ms / 481.02 ms حافظه: 1.031 MB / 17.50 MB Application: beforeRenderModule mod_menu (منوی موبایل offconvas)

زمان: 5.21 ms / 486.23 ms حافظه: 0.087 MB / 17.58 MB Application: afterRenderModule mod_menu (منوی موبایل offconvas)

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

زمان: 0.97 ms / 487.29 ms حافظه: 0.007 MB / 17.58 MB Application: afterRenderModule mod_custom (متن کپی رایت)

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

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

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

زمان: 37.73 ms / 527.66 ms حافظه: 0.054 MB / 17.66 MB Application: afterRenderModule mod_stats (آمار سایت)

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

زمان: 3.40 ms / 531.21 ms حافظه: 0.134 MB / 17.79 MB Application: Before Access::getAssetRules (id:8 name:com_content)

زمان: 0.04 ms / 531.25 ms حافظه: 0.002 MB / 17.79 MB Application: After Access::getAssetRules (id:8 name:com_content)

زمان: 8.47 ms / 539.72 ms حافظه: 0.143 MB / 17.93 MB Application: afterRenderModule mod_articles_popular (مقالات پر بازدید)

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

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

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

زمان: 0.36 ms / 540.70 ms حافظه: 0.003 MB / 17.79 MB Application: afterRenderModule mod_custom (اسلاید داخلی)

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

زمان: 0.39 ms / 541.18 ms حافظه: 0.003 MB / 17.79 MB Application: afterRenderModule mod_custom (شماره های تماس)

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

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

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

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

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

زمان: 0.39 ms / 542.74 ms حافظه: 0.003 MB / 17.80 MB Application: afterRenderModule mod_custom (چراغ چشمک زن)

زمان: 262.69 ms / 805.43 ms حافظه: 4.257 MB / 22.06 MB Application: afterRender

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

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

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

46 پرس و جو ثبت شده 246.49 ms

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

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

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

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

SELECT `data`

  FROM `midx0_session`

  WHERE `session_id` = X'6337656532376232303064633235326639653864633365323034656536363339'

توضیح دادن

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.14 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.34 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	1.34 ms
Preparing	0.05 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

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

#	فراخوانده	فایل و شماره خط
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.83 ms پس از آخرین پرس و جو: 2.42 ms حافظه پرس و جو: 0.020 MB حافظه قبل از پرس و جوی: 4.263 MB سطرهای بازگشتی: 0

SELECT `session_id`

  FROM `midx0_session`

  WHERE `session_id` = X'6337656532376232303064633235326639653864633365323034656536363339' 
  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.11 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.03 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.03 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.04 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

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

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

زمان پرس و جو: 9.32 ms پس از آخرین پرس و جو: 0.15 ms حافظه پرس و جو: 0.004 MB حافظه قبل از پرس و جوی: 4.268 MB

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

توضیح دادن

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

مشخصات

Status	Duration
Starting	0.08 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 for update	0.03 ms
Update	4.59 ms
End of update loop	0.14 ms
Query end	0.03 ms
Commit	4.01 ms
Query end	0.06 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.03 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 برای لینک به فایل ها]

زمان پرس و جو: 16.23 ms پس از آخرین پرس و جو: 4.28 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 4.518 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.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.05 ms
Optimizing	0.05 ms
Statistics	4.84 ms
Preparing	0.11 ms
Executing	0.03 ms
Sending data	10.37 ms
End of update loop	0.09 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.03 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

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

#	فراخوانده	فایل و شماره خط
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.09 ms پس از آخرین پرس و جو: 4.15 ms حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 4.711 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.08 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.41 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

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

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

زمان پرس و جو: 8.76 ms پس از آخرین پرس و جو: 0.14 ms حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 4.723 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.06 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.03 ms
Statistics	7.79 ms
Preparing	0.09 ms
Unlocking tables	0.03 ms
Preparing	0.06 ms
Executing	0.03 ms
Sending data	0.07 ms
End of update loop	0.03 ms
Query end	0.04 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 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: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 برای لینک به فایل ها]

زمان پرس و جو: 6.31 ms پس از آخرین پرس و جو: 1.06 ms حافظه پرس و جو: 0.031 MB حافظه قبل از پرس و جوی: 4.792 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.11 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.05 ms
Optimizing	0.05 ms
Statistics	0.08 ms
Preparing	0.05 ms
Sorting result	0.03 ms
Executing	0.02 ms
Sending data	0.04 ms
Creating sort index	5.28 ms
End of update loop	0.08 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.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

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

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

زمان پرس و جو: 1.52 ms پس از آخرین پرس و جو: 68.37 ms حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 8.240 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.13 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.04 ms
Statistics	0.72 ms
Preparing	0.06 ms
Executing	0.02 ms
Sending data	0.07 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

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

#	فراخوانده	فایل و شماره خط
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.77 ms پس از آخرین پرس و جو: 34.95 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 10.999 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.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	0.03 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
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/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 برای لینک به فایل ها]

زمان پرس و جو: 1.80 ms پس از آخرین پرس و جو: 0.22 ms حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 11.009 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.06 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.76 ms
Preparing	0.06 ms
Executing	0.02 ms
Sending data	0.36 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.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: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 برای لینک به فایل ها]

زمان پرس و جو: 5.50 ms پس از آخرین پرس و جو: 9.40 ms حافظه پرس و جو: 0.111 MB حافظه قبل از پرس و جوی: 11.680 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.14 ms
checking permissions	0.04 ms
Opening tables	0.07 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.42 ms
Preparing	0.08 ms
Sorting result	0.04 ms
Executing	0.02 ms
Sending data	0.04 ms
Creating sort index	4.09 ms
End of update loop	0.09 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

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

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

زمان پرس و جو: 37.73 ms پس از آخرین پرس و جو: 12.96 ms حافظه پرس و جو: 0.024 MB حافظه قبل از پرس و جوی: 12.338 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.22 ms
checking permissions	0.03 ms
Opening tables	0.27 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.04 ms
init	0.10 ms
Optimizing	0.07 ms
Statistics	35.92 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.25 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.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

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

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

زمان پرس و جو: 10.11 ms پس از آخرین پرس و جو: 1.12 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 12.442 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.11 ms
checking permissions	0.03 ms
Opening tables	7.14 ms
After opening tables	0.08 ms
System lock	0.03 ms
table lock	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.16 ms
Unlocking tables	0.03 ms
closing tables	0.04 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	1.38 ms
Preparing	0.08 ms
Executing	0.03 ms
Sending data	0.34 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.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.02 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.13 ms پس از آخرین پرس و جو: 1.38 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 12.482 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.09 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	0.14 ms
Preparing	0.07 ms
Executing	0.03 ms
Sending data	0.08 ms
End of update loop	0.03 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

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

#	فراخوانده	فایل و شماره خط
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.42 ms پس از آخرین پرس و جو: 0.34 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 12.473 MB

UPDATE `midx0_extensions`

  SET `params` = '{\"mediaversion\":\"774e2cee7c1b2c076d408df2ca29dfe2\"}'

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

توضیح دادن

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

مشخصات

Status	Duration
Starting	0.07 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 for update	0.09 ms
Updating	0.38 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	4.24 ms
Query end	0.08 ms
closing tables	0.02 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.05 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 برای لینک به فایل ها]

زمان پرس و جو: 1.80 ms پس از آخرین پرس و جو: 3.69 ms حافظه پرس و جو: 0.019 MB حافظه قبل از پرس و جوی: 12.654 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.11 ms
checking permissions	0.03 ms
Opening tables	0.15 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.03 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.04 ms
Preparing	0.05 ms
Sorting result	0.03 ms
Executing	0.03 ms
Sending data	0.03 ms
Creating sort index	0.37 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

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

#	فراخوانده	فایل و شماره خط
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.64 ms پس از آخرین پرس و جو: 0.59 ms حافظه پرس و جو: 0.035 MB حافظه قبل از پرس و جوی: 12.669 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.10 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.05 ms
Statistics	0.16 ms
Preparing	0.07 ms
Executing	0.03 ms
Sending data	0.56 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.03 ms
Query end	0.03 ms
Starting cleanup	0.04 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.02 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 برای لینک به فایل ها]

زمان پرس و جو: 6.87 ms پس از آخرین پرس و جو: 7.56 ms حافظه پرس و جو: 0.027 MB حافظه قبل از پرس و جوی: 12.952 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.23 ms
checking permissions	0.03 ms
Opening tables	1.23 ms
After opening tables	0.07 ms
System lock	0.03 ms
table lock	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.09 ms
Unlocking tables	0.03 ms
closing tables	0.05 ms
init	0.09 ms
Optimizing	0.04 ms
Statistics	0.22 ms
Preparing	0.06 ms
Executing	0.03 ms
Sending data	3.70 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.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

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

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

زمان پرس و جو: 24.02 ms پس از آخرین پرس و جو: 0.48 ms حافظه پرس و جو: 0.052 MB حافظه قبل از پرس و جوی: 12.999 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.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	0.04 ms
Optimizing	0.04 ms
Statistics	3.63 ms
Preparing	0.10 ms
Executing	0.02 ms
Sending data	19.51 ms
End of update loop	0.08 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.05 ms

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

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

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

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

SHOW FULL COLUMNS 
  FROM `midx0_content`

توضیح دادن

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

مشخصات

Status	Duration
Starting	0.11 ms
checking permissions	0.03 ms
closing tables	0.02 ms
checking permissions	0.02 ms
Opening tables	0.36 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.02 ms
Filling schema table	0.03 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
checking permissions	0.14 ms
closing tables	0.03 ms
checking permissions	0.02 ms
Executing	0.02 ms
Sending data	0.07 ms
End of update loop	0.03 ms
Query end	0.02 ms
closing tables	0.02 ms
Removing tmp table	0.13 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.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 برای لینک به فایل ها]

زمان پرس و جو: 5.30 ms پس از آخرین پرس و جو: 5.24 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 13.603 MB

UPDATE midx0_content

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

  WHERE `id` = '229'

توضیح دادن

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

مشخصات

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.02 ms
table lock	0.02 ms
init for update	0.09 ms
Updating	0.74 ms
End of update loop	0.04 ms
Query end	0.02 ms
Commit	3.82 ms
Query end	0.07 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/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 برای لینک به فایل ها]

زمان پرس و جو: 3.92 ms پس از آخرین پرس و جو: 2.97 ms حافظه پرس و جو: 0.039 MB حافظه قبل از پرس و جوی: 13.724 MB سطرهای بازگشتی: 1

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

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 = 229 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-22 11:50:16') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-22 11:50:16') 
  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.27 ms
checking permissions	0.05 ms
Opening tables	1.71 ms
After opening tables	0.07 ms
System lock	0.03 ms
table lock	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.05 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
init	0.11 ms
Optimizing	0.06 ms
Statistics	0.78 ms
Preparing	0.05 ms
Unlocking tables	0.02 ms
Preparing	0.03 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.02 ms
Unlocking tables	0.02 ms
closing tables	0.04 ms
Query end	0.04 ms
Starting cleanup	0.03 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 برای لینک به فایل ها]

زمان پرس و جو: 1.70 ms پس از آخرین پرس و جو: 3.12 ms حافظه پرس و جو: 0.027 MB حافظه قبل از پرس و جوی: 13.835 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.20 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.10 ms
Optimizing	0.05 ms
Statistics	0.41 ms
Preparing	0.03 ms
Unlocking tables	0.02 ms
Preparing	0.04 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.04 ms
Creating sort index	0.12 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.06 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.03 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.25 ms پس از آخرین پرس و جو: 0.76 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 13.863 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` = 229 
  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.08 ms
checking permissions	0.02 ms
Opening tables	0.30 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.06 ms
Optimizing	0.06 ms
Statistics	0.76 ms
Preparing	0.09 ms
Executing	0.03 ms
Sending data	1.46 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.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 برای لینک به فایل ها]

زمان پرس و جو: 9.51 ms پس از آخرین پرس و جو: 17.26 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 15.316 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.23 ms
checking permissions	0.03 ms
Opening tables	3.00 ms
After opening tables	0.04 ms
System lock	0.02 ms
table lock	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.09 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
init	0.08 ms
Optimizing	0.08 ms
Statistics	3.89 ms
Preparing	0.18 ms
Creating tmp table	0.15 ms
Sorting result	0.06 ms
Executing	0.02 ms
Sending data	0.81 ms
Creating sort index	0.10 ms
Removing tmp table	0.17 ms
Creating sort index	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.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

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

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

زمان پرس و جو: 3.02 ms پس از آخرین پرس و جو: 6.45 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 15.727 MB سطرهای بازگشتی: 1

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

SELECT *

  FROM midx0_itemrating_group

  WHERE id=1

توضیح دادن

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

مشخصات

Status	Duration
Starting	0.11 ms
checking permissions	0.03 ms
Opening tables	1.47 ms
After opening tables	0.05 ms
System lock	0.02 ms
table lock	0.05 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.06 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.48 ms
Preparing	0.03 ms
Unlocking tables	0.02 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.04 ms
End of update loop	0.02 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

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_itemrating/helpers/itemrating.php:1116
16	ItemratingHelper::getGroupData()	JROOT/components/com_itemrating/helpers/itemrating.php:398
15	ItemratingHelper::createWidget()	JROOT/components/com_itemrating/helpers/itemrating.php:57
14	ItemratingHelper::loadWidget()	JROOT/plugins/content/itemrating/itemrating.php:90
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 برای لینک به فایل ها]

زمان پرس و جو: 0.88 ms پس از آخرین پرس و جو: 5.91 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 15.940 MB سطرهای بازگشتی: 1

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

SELECT *

  FROM midx0_itemrating_group

  WHERE id=1

توضیح دادن

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

مشخصات

Status	Duration
Starting	0.11 ms
checking permissions	0.02 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.03 ms
Statistics	0.06 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.05 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.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:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_itemrating/helpers/itemrating.php:1116
16	ItemratingHelper::getGroupData()	JROOT/components/com_itemrating/helpers/itemrating.php:398
15	ItemratingHelper::createWidget()	JROOT/components/com_itemrating/helpers/itemrating.php:57
14	ItemratingHelper::loadWidget()	JROOT/plugins/content/itemrating/itemrating.php:145
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 برای لینک به فایل ها]

زمان پرس و جو: 2.62 ms پس از آخرین پرس و جو: 4.22 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 16.078 MB سطرهای بازگشتی: 1

SELECT *

  FROM midx0_itemrating_item

  WHERE group_id=1 
  AND state=1

  ORDER BY ordering

توضیح دادن

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

مشخصات

Status	Duration
Starting	0.13 ms
checking permissions	0.03 ms
Opening tables	0.79 ms
After opening tables	0.04 ms
System lock	0.02 ms
table lock	0.03 ms
Opening tables	0.05 ms
After opening tables	0.52 ms
System lock	0.05 ms
table lock	0.08 ms
Unlocking tables	0.03 ms
closing tables	0.04 ms
init	0.07 ms
Optimizing	0.05 ms
Statistics	0.05 ms
Preparing	0.04 ms
Sorting result	0.03 ms
Executing	0.03 ms
Sending data	0.06 ms
Creating sort index	0.09 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.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

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_itemrating/helpers/itemrating.php:1133
16	ItemratingHelper::getGroupRating()	JROOT/components/com_itemrating/helpers/itemrating.php:836
15	ItemratingHelper::createWidget()	JROOT/components/com_itemrating/helpers/itemrating.php:57
14	ItemratingHelper::loadWidget()	JROOT/plugins/content/itemrating/itemrating.php:145
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 برای لینک به فایل ها]

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

SELECT *

  FROM `midx0_itemrating_itemdata`

  WHERE `context` = 'com_content' 
  AND `context_id` = 229 
  AND `rating_id` = 1

توضیح دادن

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

مشخصات

Status	Duration
Starting	0.06 ms
checking permissions	0.03 ms
Opening tables	0.71 ms
After opening tables	0.05 ms
System lock	0.03 ms
table lock	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.05 ms
Unlocking tables	0.03 ms
closing tables	0.02 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.87 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.03 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_itemrating/helpers/itemrating.php:1156
16	ItemratingHelper::getRating()	JROOT/components/com_itemrating/helpers/itemrating.php:854
15	ItemratingHelper::createWidget()	JROOT/components/com_itemrating/helpers/itemrating.php:57
14	ItemratingHelper::loadWidget()	JROOT/plugins/content/itemrating/itemrating.php:145
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.39 ms پس از آخرین پرس و جو: 26.60 ms حافظه پرس و جو: 0.048 MB حافظه قبل از پرس و جوی: 17.516 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-22 11:50:16') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-22 11:50:16') 
  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.21 ms
checking permissions	0.03 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.03 ms
init	0.11 ms
Optimizing	0.08 ms
Statistics	0.49 ms
Preparing	0.46 ms
Sorting result	0.04 ms
Executing	0.02 ms
Sending data	0.02 ms
Creating sort index	3.38 ms
End of update loop	0.06 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.03 ms
Query end	0.03 ms
Starting cleanup	0.03 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()	به نظر می رسد خط زیر فراخونده شده باشد.
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.02 ms پس از آخرین پرس و جو: 17.25 ms حافظه پرس و جو: 0.041 MB حافظه قبل از پرس و جوی: 17.616 MB سطرهای بازگشتی: 260

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	242	Using index

مشخصات

Status	Duration
Starting	0.12 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.05 ms
Executing	0.02 ms
Sending data	0.19 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.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/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 برای لینک به فایل ها]

زمان پرس و جو: 4.70 ms پس از آخرین پرس و جو: 2.00 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 17.646 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.09 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.04 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	3.87 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.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: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 برای لینک به فایل ها]

زمان پرس و جو: 4.03 ms پس از آخرین پرس و جو: 0.15 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 17.659 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.06 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.04 ms
Optimizing	0.05 ms
Statistics	3.08 ms
Preparing	0.08 ms
Executing	0.03 ms
Sending data	0.17 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.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.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 برای لینک به فایل ها]

زمان پرس و جو: 26.93 ms پس از آخرین پرس و جو: 0.14 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 17.668 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.06 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.04 ms
Statistics	0.07 ms
Preparing	0.05 ms
Executing	0.02 ms
Sending data	25.87 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.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

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

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

زمان پرس و جو: 5.89 ms پس از آخرین پرس و جو: 4.18 ms حافظه پرس و جو: 0.144 MB حافظه قبل از پرس و جوی: 17.792 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-22 11:50:16') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-22 11:50:16') 
  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.44 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.19 ms
Optimizing	0.11 ms
Statistics	0.67 ms
Preparing	0.04 ms
Unlocking tables	0.03 ms
Preparing	0.13 ms
Sorting result	0.06 ms
Executing	0.04 ms
Sending data	0.06 ms
Creating sort index	3.40 ms
End of update loop	0.09 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.03 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 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/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 برای لینک به فایل ها]

زمان پرس و جو: 0.98 ms پس از آخرین پرس و جو: 7.35 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 17.966 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.11 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.05 ms
Optimizing	0.04 ms
Statistics	0.12 ms
Preparing	0.05 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.02 ms
Unlocking tables	0.03 ms
closing tables	0.03 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

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

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

زمان پرس و جو: 1.88 ms پس از آخرین پرس و جو: 1.50 ms حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 18.049 MB سطرهای بازگشتی: 2

SHOW FULL COLUMNS 
  FROM `midx0_gsd_config`

توضیح دادن

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

مشخصات

Status	Duration
Starting	0.09 ms
checking permissions	0.02 ms
closing tables	0.02 ms
checking permissions	0.02 ms
Opening tables	0.57 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.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.09 ms
closing tables	0.03 ms
checking permissions	0.03 ms
Executing	0.02 ms
Sending data	0.07 ms
End of update loop	0.03 ms
Query end	0.02 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.02 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.79 ms پس از آخرین پرس و جو: 0.16 ms حافظه پرس و جو: 0.024 MB حافظه قبل از پرس و جوی: 18.065 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.07 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.05 ms
Optimizing	0.04 ms
Statistics	0.06 ms
Preparing	0.03 ms
Unlocking tables	0.03 ms
Preparing	0.03 ms
Executing	0.03 ms
Sending data	0.03 ms
End of update loop	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.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: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 برای لینک به فایل ها]

زمان پرس و جو: 1.48 ms پس از آخرین پرس و جو: 19.80 ms حافظه پرس و جو: 0.042 MB حافظه قبل از پرس و جوی: 19.087 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 = 229 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-22 11:50:16') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-22 11:50:16') 
  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.08 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.11 ms
Optimizing	0.09 ms
Statistics	0.21 ms
Preparing	0.03 ms
Unlocking tables	0.03 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.07 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.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

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

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

زمان پرس و جو: 8.20 ms پس از آخرین پرس و جو: 1.65 ms حافظه پرس و جو: 0.241 MB حافظه قبل از پرس و جوی: 19.149 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.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.06 ms
Optimizing	0.05 ms
Statistics	0.76 ms
Preparing	0.06 ms
Sorting result	0.04 ms
Executing	0.02 ms
Sending data	6.52 ms
End of update loop	0.08 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

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

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

زمان پرس و جو: 0.80 ms پس از آخرین پرس و جو: 24.69 ms حافظه پرس و جو: 0.031 MB حافظه قبل از پرس و جوی: 19.539 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.11 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.04 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.03 ms
Executing	0.03 ms
Sending data	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.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.03 ms
Reset for next command	0.02 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 برای لینک به فایل ها]

زمان پرس و جو: 1.63 ms پس از آخرین پرس و جو: 0.94 ms حافظه پرس و جو: 0.036 MB حافظه قبل از پرس و جوی: 19.616 MB سطرهای بازگشتی: 16

SHOW FULL COLUMNS 
  FROM `midx0_users`

توضیح دادن

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

مشخصات

Status	Duration
Starting	0.07 ms
checking permissions	0.02 ms
closing tables	0.02 ms
checking permissions	0.02 ms
Opening tables	0.44 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.04 ms
Executing	0.02 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
checking permissions	0.13 ms
closing tables	0.03 ms
checking permissions	0.03 ms
Executing	0.03 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Removing tmp table	0.15 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.03 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.02 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.77 ms پس از آخرین پرس و جو: 0.18 ms حافظه پرس و جو: 0.032 MB حافظه قبل از پرس و جوی: 19.653 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.05 ms
checking permissions	0.05 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	0.06 ms
Preparing	0.03 ms
Unlocking tables	0.03 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	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.02 ms
Reset for next command	0.02 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 برای لینک به فایل ها]

زمان پرس و جو: 2.24 ms پس از آخرین پرس و جو: 4.43 ms حافظه پرس و جو: 0.032 MB حافظه قبل از پرس و جوی: 20.432 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.12 ms
checking permissions	0.03 ms
Opening tables	1.22 ms
After opening tables	0.05 ms
System lock	0.02 ms
table lock	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.07 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.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

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

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

زمان پرس و جو: 0.94 ms پس از آخرین پرس و جو: 2.85 ms حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 20.444 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.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.09 ms
Preparing	0.06 ms
Sorting result	0.03 ms
Executing	0.02 ms
Sending data	0.04 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.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.02 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 برای لینک به فایل ها]

زمان پرس و جو: 1.30 ms پس از آخرین پرس و جو: 3.07 ms حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 20.558 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.19 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.08 ms
Optimizing	0.05 ms
Statistics	0.14 ms
Preparing	0.03 ms
Unlocking tables	0.02 ms
Preparing	0.05 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.05 ms
Creating sort index	0.13 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.71 ms
Reset for next command	0.04 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 برای لینک به فایل ها]

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

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

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 * 
  FROM midx0_itemrating_item

1 × SELECT * 
  FROM `midx0_itemrating_itemdata`

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'6337656532376232303064633235326639653864633365323034656536363339', 1, 1734868216, 0, '', 0

1 × UPDATE `midx0_extensions` 
  SET `params` = '{\"mediaversion\":\"774e2cee7c1b2c076d408df2ca29dfe2\"}'

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