Covid-19

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

جلسه

{
    "__default": {
        "session": {
            "counter": 63,
            "timer": {
                "start": 1780865219,
                "last": 1780865233,
                "now": 1780865233
            },
            "token": "JvXj0xyBkgmmYcsg39YlWt5MbwpxuIUm"
        },
        "registry": {
            "mailto": {
                "mailto": {
                    "form": {
                        "data": {
                            "link": "1ce05cc15f7ac7a3a866dac1118871b1b141fb08",
                            "sender": "",
                            "subject": "",
                            "emailfrom": "",
                            "emailto": ""
                        }
                    }
                }
            }
        },
        "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
        },
        "plg_system_languagefilter": {
            "language": "fa-IR"
        },
        "com_mailto": {
            "links": {
                "a44a980e6fb053e305fd4b993b9ef7e0c9414cf4": {
                    "link": "https:\/\/www.gciran.com\/%D8%AE%D8%AF%D9%85%D8%A7%D8%AA-%D9%81%D9%86%DB%8C-%D9%88-%D9%85%D9%87%D9%86%D8%AF%D8%B3%DB%8C\/%D8%B3%D8%A7%DB%8C%D8%AA-%D9%88%DB%8C%D8%B2%DB%8C%D8%AA-%DA%A9%D8%A7%D8%B1%D8%AE%D8%A7%D9%86%D8%AC%D8%A7%D8%AA-%D8%8C%D8%A7%D8%AF%D8%A7%D8%B1%D8%A7%D8%AA%D8%8C%D8%AF%D9%81%D8%A7%D8%AA%D8%B1%D8%8C%D9%81%D8%B1%D9%88%D8%B4%DA%AF%D8%A7%D9%87-%D9%87%D8%A7-%D9%88-%D8%AF%D8%B1-%D8%B2%D9%85%DB%8C%D9%86%D9%87-%D8%B9%D9%84%D8%A7%D8%A6%D9%85-%D9%88-%D8%AA%D8%AC%D9%87%DB%8C%D8%B2%D8%A7%D8%AA-%D8%A7%DB%8C%D9%85%D9%86%DB%8C-%D9%88-%D8%AA%D8%B1%D8%A7%D9%81%DB%8C%DA%A9%DB%8C\/item\/402-1465.html",
                    "expiry": 1780865221
                },
                "8e9e3449477471e01a7f203675e3475236a74479": {
                    "link": "https:\/\/www.gciran.com\/%D8%AE%D8%AF%D9%85%D8%A7%D8%AA-%D9%81%D9%86%DB%8C-%D9%88-%D9%85%D9%87%D9%86%D8%AF%D8%B3%DB%8C\/%D8%B3%D8%A7%DB%8C%D8%AA-%D9%88%DB%8C%D8%B2%DB%8C%D8%AA-%DA%A9%D8%A7%D8%B1%D8%AE%D8%A7%D9%86%D8%AC%D8%A7%D8%AA-%D8%8C%D8%A7%D8%AF%D8%A7%D8%B1%D8%A7%D8%AA%D8%8C%D8%AF%D9%81%D8%A7%D8%AA%D8%B1%D8%8C%D9%81%D8%B1%D9%88%D8%B4%DA%AF%D8%A7%D9%87-%D9%87%D8%A7-%D9%88-%D8%AF%D8%B1-%D8%B2%D9%85%DB%8C%D9%86%D9%87-%D8%B9%D9%84%D8%A7%D8%A6%D9%85-%D9%88-%D8%AA%D8%AC%D9%87%DB%8C%D8%B2%D8%A7%D8%AA-%D8%A7%DB%8C%D9%85%D9%86%DB%8C-%D9%88-%D8%AA%D8%B1%D8%A7%D9%81%DB%8C%DA%A9%DB%8C\/item\/411-3407.html",
                    "expiry": 1780865222
                },
                "809601fdbcc1020458989cca0fdb6fd168565876": {
                    "link": "https:\/\/www.gciran.com\/%D8%AE%D8%AF%D9%85%D8%A7%D8%AA-%D9%81%D9%86%DB%8C-%D9%88-%D9%85%D9%87%D9%86%D8%AF%D8%B3%DB%8C\/%D8%A8%D8%A7%D8%B2%D8%B1%D8%B3%DB%8C-%D9%81%D9%86%DB%8C-%D9%88-%D8%A7%DB%8C%D9%85%D9%86%DB%8C-%D8%AF%DB%8C%DA%AF-%D9%87%D8%A7%DB%8C-%D8%A8%D8%AE%D8%A7%D8%B1-%D9%88-%D8%B8%D8%B1%D9%88%D9%81-%D8%AA%D8%AD%D8%AA-%D9%81%D8%B4%D8%A7%D8%B1\/item\/403-1466.html?print=1&tmpl=component",
                    "expiry": 1780865222
                },
                "23fe29f782ea15fb47b6e0deae0d0ebaa86adca8": {
                    "link": "https:\/\/www.gciran.com\/%D8%AE%D8%AF%D9%85%D8%A7%D8%AA-%D9%81%D9%86%DB%8C-%D9%88-%D9%85%D9%87%D9%86%D8%AF%D8%B3%DB%8C\/%D8%A8%D8%A7%D8%B2%D8%B1%D8%B3%DB%8C-%D9%81%D9%86%DB%8C-%D9%88-%D8%A7%DB%8C%D9%85%D9%86%DB%8C-%D8%A7%D9%86%D9%88%D8%A7%D8%B9-%D8%AC%D8%B1%D8%AB%D9%82%DB%8C%D9%84-%D9%88-%D9%84%DB%8C%D9%81%D8%AA%D8%B1%D8%A7%DA%A9\/item\/412-3408.html?print=1&tmpl=component",
                    "expiry": 1780865226
                },
                "b1546aab84d9b0dc680b705b99a9df9540c1a13f": {
                    "link": "https:\/\/www.gciran.com\/%D8%AE%D8%AF%D9%85%D8%A7%D8%AA-%D9%81%D9%86%DB%8C-%D9%88-%D9%85%D9%87%D9%86%D8%AF%D8%B3%DB%8C\/%D8%A8%D8%A7%D8%B2%D8%B1%D8%B3%DB%8C-%D9%81%D9%86%DB%8C-%D9%88-%D8%A7%DB%8C%D9%85%D9%86%DB%8C-%D8%A7%D9%86%D9%88%D8%A7%D8%B9-%D8%AC%D8%B1%D8%AB%D9%82%DB%8C%D9%84-%D9%88-%D9%84%DB%8C%D9%81%D8%AA%D8%B1%D8%A7%DA%A9\/item\/404-1408.html?print=1&tmpl=component",
                    "expiry": 1780865226
                },
                "f0914dc9da103527c5c63dc4dcef5cf5882b631e": {
                    "link": "https:\/\/www.gciran.com\/%D8%B9%D9%84%D8%A7%D8%A6%D9%85-%D8%A7%DB%8C%D9%85%D9%86%DB%8C-%D9%88-%D8%AA%D8%B1%D8%A7%D9%81%DB%8C%DA%A9%DB%8C\/%D8%B9%D9%84%D8%A7%D8%A6%D9%85-%D8%A2%D8%AA%D8%B4-%D9%86%D8%B4%D8%A7%D9%86%DB%8C\/item\/337-0456.html?print=1&tmpl=component",
                    "expiry": 1780865229
                },
                "2d3b9f4047b262092e5589ff5431a0cd3da27210": {
                    "link": "https:\/\/www.gciran.com\/%D8%AE%D8%AF%D9%85%D8%A7%D8%AA-%D9%81%D9%86%DB%8C-%D9%88-%D9%85%D9%87%D9%86%D8%AF%D8%B3%DB%8C\/%D8%A8%D8%A7%D8%B2%D8%B1%D8%B3%DB%8C-%D9%81%D9%86%DB%8C-%D9%88-%D8%A7%DB%8C%D9%85%D9%86%DB%8C-%D8%A8%D8%B1%D9%82-%D8%B3%DB%8C%D8%B3%D8%AA%D9%85-%D8%A7%D8%B1%D8%AA%DB%8C%D9%86%DA%AF\/item\/404-1408.html?print=1&tmpl=component",
                    "expiry": 1780865230
                },
                "7e8226f1aa2141f1d76a5d8befffbf55fa9b3107": {
                    "link": "https:\/\/www.gciran.com\/%D8%B9%D9%84%D8%A7%D8%A6%D9%85-%D8%A7%DB%8C%D9%85%D9%86%DB%8C-%D9%88-%D8%AA%D8%B1%D8%A7%D9%81%DB%8C%DA%A9%DB%8C\/%D8%B9%D9%84%D8%A7%D8%A6%D9%85-%D8%A2%D8%AA%D8%B4-%D9%86%D8%B4%D8%A7%D9%86%DB%8C\/item\/339-0457.html?print=1&tmpl=component",
                    "expiry": 1780865231
                },
                "5c21bc198b78901cbda79441b64ef45af5206a41": {
                    "link": "https:\/\/www.gciran.com\/%D8%B9%D9%84%D8%A7%D8%A6%D9%85-%D8%A7%DB%8C%D9%85%D9%86%DB%8C-%D9%88-%D8%AA%D8%B1%D8%A7%D9%81%DB%8C%DA%A9%DB%8C\/%D9%BE%D9%88%D8%B3%D8%AA%D8%B1%D9%87%D8%A7%DB%8C-%D8%A7%DB%8C%D9%85%D9%86%DB%8C\/item\/981-covid-19-18.html?print=1&tmpl=component",
                    "expiry": 1780865231
                },
                "c71ce6b5e6c91bf9572c1a65ef8d5543c56623d9": {
                    "link": "https:\/\/www.gciran.com\/%D8%B9%D9%84%D8%A7%D8%A6%D9%85-%D8%A7%DB%8C%D9%85%D9%86%DB%8C-%D9%88-%D8%AA%D8%B1%D8%A7%D9%81%DB%8C%DA%A9%DB%8C\/%D8%B9%D9%84%D8%A7%D8%A6%D9%85-%D8%A7%D8%B3%D8%AA%D8%A7%D9%86%D8%AF%D8%A7%D8%B1%D8%AF-ansi\/item\/468-1231.html?print=1&tmpl=component",
                    "expiry": 1780865231
                },
                "aa8c21e58fcb79767cce897010f02e151b0b5841": {
                    "link": "https:\/\/www.gciran.com\/%D8%B9%D9%84%D8%A7%D8%A6%D9%85-%D8%A7%DB%8C%D9%85%D9%86%DB%8C-%D9%88-%D8%AA%D8%B1%D8%A7%D9%81%DB%8C%DA%A9%DB%8C\/%D8%B9%D9%84%D8%A7%D8%A6%D9%85-%D8%A2%D8%AA%D8%B4-%D9%86%D8%B4%D8%A7%D9%86%DB%8C\/item\/412-3408.html?print=1&tmpl=component",
                    "expiry": 1780865231
                },
                "0432158f65d37f8486aa176be77e984a349429c2": {
                    "link": "https:\/\/www.gciran.com\/%D8%B9%D9%84%D8%A7%D8%A6%D9%85-%D8%A7%DB%8C%D9%85%D9%86%DB%8C-%D9%88-%D8%AA%D8%B1%D8%A7%D9%81%DB%8C%DA%A9%DB%8C\/%D8%B9%D9%84%D8%A7%D8%A6%D9%85-%D8%A7%D8%B3%D8%AA%D8%A7%D9%86%D8%AF%D8%A7%D8%B1%D8%AF-ansi\/item\/460-1225.html?print=1&tmpl=component",
                    "expiry": 1780865232
                },
                "4f9655ca6bdabaf347f698fb8c6054fa8626010a": {
                    "link": "https:\/\/www.gciran.com\/%D8%B9%D9%84%D8%A7%D8%A6%D9%85-%D8%A7%DB%8C%D9%85%D9%86%DB%8C-%D9%88-%D8%AA%D8%B1%D8%A7%D9%81%DB%8C%DA%A9%DB%8C\/%D8%B9%D9%84%D8%A7%D8%A6%D9%85-%D8%A7%D8%B3%D8%AA%D8%A7%D9%86%D8%AF%D8%A7%D8%B1%D8%AF-ansi\/item\/484-1243.html?print=1&tmpl=component",
                    "expiry": 1780865232
                },
                "2c5e381eeeb89fa84408fa7504f0598a1775c6f3": {
                    "link": "https:\/\/www.gciran.com\/%D8%AE%D8%AF%D9%85%D8%A7%D8%AA-%D9%81%D9%86%DB%8C-%D9%88-%D9%85%D9%87%D9%86%D8%AF%D8%B3%DB%8C\/%D8%A8%D8%A7%D8%B2%D8%B1%D8%B3%DB%8C-%D9%81%D9%86%DB%8C-%D9%88-%D8%A7%DB%8C%D9%85%D9%86%DB%8C-%D8%AF%DB%8C%DA%AF-%D9%87%D8%A7%DB%8C-%D8%A8%D8%AE%D8%A7%D8%B1-%D9%88-%D8%B8%D8%B1%D9%88%D9%81-%D8%AA%D8%AD%D8%AA-%D9%81%D8%B4%D8%A7%D8%B1\/item\/402-1465.html",
                    "expiry": 1780865232
                },
                "69fac65fbe4aa5d070f33e924a028e1675c2294d": {
                    "link": "https:\/\/www.gciran.com\/%D8%B9%D9%84%D8%A7%D8%A6%D9%85-%D8%A7%DB%8C%D9%85%D9%86%DB%8C-%D9%88-%D8%AA%D8%B1%D8%A7%D9%81%DB%8C%DA%A9%DB%8C\/%D8%B9%D9%84%D8%A7%D8%A6%D9%85-%D8%A7%D8%B3%D8%AA%D8%A7%D9%86%D8%AF%D8%A7%D8%B1%D8%AF-ansi\/item\/483-1242.html?print=1&tmpl=component",
                    "expiry": 1780865233
                },
                "27e67d47ef094dd55a6dddd2ff6a45f31fe0c6ec": {
                    "link": "https:\/\/www.gciran.com\/%D8%B9%D9%84%D8%A7%D8%A6%D9%85-%D8%A7%DB%8C%D9%85%D9%86%DB%8C-%D9%88-%D8%AA%D8%B1%D8%A7%D9%81%DB%8C%DA%A9%DB%8C\/%D8%B9%D9%84%D8%A7%D8%A6%D9%85-%D8%A7%D8%B3%D8%AA%D8%A7%D9%86%D8%AF%D8%A7%D8%B1%D8%AF-ansi\/item\/477-1240.html?print=1&tmpl=component",
                    "expiry": 1780865233
                },
                "68792094e11c70bc8975e41f34eeb664135fbdaa": {
                    "link": "https:\/\/www.gciran.com\/%D8%B9%D9%84%D8%A7%D8%A6%D9%85-%D8%A7%DB%8C%D9%85%D9%86%DB%8C-%D9%88-%D8%AA%D8%B1%D8%A7%D9%81%DB%8C%DA%A9%DB%8C\/%D9%BE%D9%88%D8%B3%D8%AA%D8%B1%D9%87%D8%A7%DB%8C-%D8%A7%DB%8C%D9%85%D9%86%DB%8C\/item\/983-covid-19-17.html?print=1&tmpl=component",
                    "expiry": 1780865234
                }
            }
        }
    }
}

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

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

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

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

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

4 تکراری: #24 #25 #37 #38

زمان پرس و جو: 0.85 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 3.754 MB سطرهای بازگشتی: 1

SELECT `data`

  FROM `dly1p_session`

  WHERE `session_id` = X'3633313835646564623436653861356164633861323735326130326435626535'

توضیح دادن

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

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
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:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
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.17 ms حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 4.153 MB سطرهای بازگشتی: 42

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

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

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.60 ms پس از آخرین پرس و جو: 1.25 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 4.353 MB سطرهای بازگشتی: 5

SELECT id, rules

  FROM `dly1p_viewlevels`

توضیح دادن

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

مشخصات

Status	Duration
Starting	0.06 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.01 ms
init	0.02 ms
Optimizing	0.03 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 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.01 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
closing tables	0.07 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.01 ms

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

#	فراخوانده	فایل و شماره خط
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.59 ms پس از آخرین پرس و جو: 0.05 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 4.365 MB سطرهای بازگشتی: 1

SELECT b.id

  FROM dly1p_usergroups AS a

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

  WHERE a.id = 1

توضیح دادن

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	1	Using where; Using index

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
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:321
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.92 ms پس از آخرین پرس و جو: 0.41 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 4.434 MB سطرهای بازگشتی: 123

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

  FROM dly1p_extensions

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

  ORDER BY ordering

توضیح دادن

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

مشخصات

Status	Duration
Starting	0.05 ms
checking permissions	0.03 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.04 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.02 ms
Creating sort index	0.30 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.01 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Query end	0.02 ms
Starting cleanup	0.04 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:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
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:359
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.81 ms پس از آخرین پرس و جو: 10.41 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 6.578 MB سطرهای بازگشتی: 2

SELECT *

  FROM dly1p_languages

  WHERE published=1

  ORDER BY ordering ASC

توضیح دادن

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

مشخصات

Status	Duration
Starting	0.09 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Sorting result	0.03 ms
Executing	0.02 ms
Sending data	0.04 ms
Creating sort index	0.07 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.03 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:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
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:625
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.74 ms پس از آخرین پرس و جو: 0.07 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 6.588 MB سطرهای بازگشتی: 4

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `dly1p_extensions`

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

توضیح دادن

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

مشخصات

Status	Duration
Starting	0.04 ms
checking permissions	0.02 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.06 ms
Preparing	0.04 ms
Executing	0.02 ms
Sending data	0.05 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.04 ms
Query end	0.02 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

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

#	فراخوانده	فایل و شماره خط
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
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:625
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 1.15 ms پس از آخرین پرس و جو: 5.14 ms حافظه پرس و جو: 0.010 MB حافظه قبل از پرس و جوی: 7.227 MB سطرهای بازگشتی: 60

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

  LEFT JOIN dly1p_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	ALL	idx_client_id_parent_id_alias_language	کلید شاخصی برای استفاده نیست	NULL	NULL	277	Using where; با استفاده از مرتب سازی فایل
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	gciran_ndb.m.component_id	1	Using where

مشخصات

Status	Duration
Starting	0.08 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.02 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.03 ms
Sorting result	0.03 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.38 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.01 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.02 ms
Reset for next command	0.02 ms

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

#	فراخوانده	فایل و شماره خط
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	به نظر می رسد خط زیر فراخونده شده باشد.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
8	PlgSystemLanguageFilter->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:626
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.67 ms پس از آخرین پرس و جو: 5.94 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 8.221 MB سطرهای بازگشتی: 1

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

  FROM `dly1p_extensions`

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

توضیح دادن

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

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	به نظر می رسد خط زیر فراخونده شده باشد.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:374
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 43.52 ms پس از آخرین پرس و جو: 0.08 ms حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 8.214 MB

UPDATE `dly1p_extensions`

  SET `params` = '{\"mediaversion\":\"fc5bff8b68fe3d95b1bc3bf8c369a063\"}'

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

توضیح دادن

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

مشخصات

Status	Duration
Starting	0.04 ms
checking permissions	0.04 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.05 ms
Updating	0.07 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	42.89 ms
Query end	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.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

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

#	فراخوانده	فایل و شماره خط
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:374
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.85 ms پس از آخرین پرس و جو: 4.12 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 8.878 MB سطرهای بازگشتی: 4

SELECT id, home, template, s.params

  FROM dly1p_template_styles as s

  LEFT JOIN dly1p_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	4
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	gciran_ndb.s.template,const	1	Using index condition; Using where

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
19	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
18	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
17	Joomla\CMS\HTML\HTMLHelper::script()	به نظر می رسد خط زیر فراخونده شده باشد.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
13	JHtmlJquery::framework()	به نظر می رسد خط زیر فراخونده شده باشد.
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_k2/helpers/html.php:268
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:390
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.69 ms پس از آخرین پرس و جو: 1.31 ms حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 8.962 MB سطرهای بازگشتی: 42

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

  FROM `dly1p_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_jrealtimeanalytics','com_k2','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_search','com_sppagebuilder','com_spsimpleportfolio','com_tags','com_templates','com_users','com_virtuemart_allinone','com_wrapper')

توضیح دادن

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

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
11	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
10	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
9	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
8	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
7	Joomla\CMS\User\User->authorise()	JROOT/components/com_k2/k2.php:15
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.68 ms پس از آخرین پرس و جو: 6.29 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 10.018 MB سطرهای بازگشتی: 26

SELECT id 
  FROM dly1p_k2_categories 
  WHERE published=1 
  AND trash=0 
  AND access IN(1,1)

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dly1p_k2_categories	ref	category,published,access,trash,idx_category	category	8	const,const,const	26	Using index

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/helpers/permissions.php:225
12	K2HelperPermissions::canAddItem()	JROOT/components/com_k2/views/item/view.html.php:37
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM dly1p_k2_items 
  WHERE id=983 
  AND language IN ('fa-IR', '*') 
  LIMIT 0, 1

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dly1p_k2_items	const	PRIMARY,language	PRIMARY	4	const	1

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:33
12	K2ModelItem->getData()	JROOT/components/com_k2/views/item/view.html.php:44
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.93 ms پس از آخرین پرس و جو: 0.36 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 10.072 MB سطرهای بازگشتی: 15

SHOW FULL COLUMNS 
  FROM `dly1p_k2_categories`

توضیح دادن

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

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2category.php:34
14	TableK2Category->__construct()	JROOT/libraries/src/Table/Table.php:312
13	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/models/item.php:64
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.51 ms پس از آخرین پرس و جو: 0.29 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 10.179 MB سطرهای بازگشتی: 1

SELECT * 
  FROM dly1p_k2_categories 
  WHERE id = '4'

توضیح دادن

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

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:61
13	TableK2Category->load()	JROOT/components/com_k2/models/item.php:65
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM dly1p_k2_categories 
  WHERE id = '1'

توضیح دادن

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

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:61
13	TableK2Category->load()	JROOT/components/com_k2/models/item.php:87
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.72 ms پس از آخرین پرس و جو: 0.15 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 10.325 MB سطرهای بازگشتی: 0

SELECT tag.*
            
  FROM dly1p_k2_tags AS tag
            JOIN dly1p_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
            
  WHERE tag.published = 1
                
  AND xref.itemID = 983
            
  ORDER BY xref.id ASC

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tag	ref	PRIMARY,published	published	2	const	1	Using temporary; با استفاده از مرتب سازی فایل
1	SIMPLE	xref	ref	tagID,itemID,idx_tags_xref_common	idx_tags_xref_common	8	gciran_ndb.tag.id,const	1	Using index

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1222
13	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:111
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM dly1p_k2_attachments 
  WHERE itemID=983

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dly1p_k2_attachments	ref	itemID	itemID	4	const	1

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1450
13	K2ModelItem->getItemAttachments()	JROOT/components/com_k2/models/item.php:164
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.55 ms پس از آخرین پرس و جو: 0.03 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 10.341 MB سطرهای بازگشتی: 0

SELECT * 
  FROM dly1p_k2_rating 
  WHERE itemID = 983

توضیح دادن

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

مشخصات

Status	Duration
Starting	0.03 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.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.03 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.01 ms
Updating status	0.07 ms
Reset for next command	0.02 ms

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

#	فراخوانده	فایل و شماره خط
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:929
14	K2ModelItem->getRating()	JROOT/components/com_k2/models/item.php:973
13	K2ModelItem->getVotesPercentage()	JROOT/components/com_k2/models/item.php:169
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 1.06 ms پس از آخرین پرس و جو: 0.70 ms حافظه پرس و جو: 0.011 MB حافظه قبل از پرس و جوی: 10.451 MB سطرهای بازگشتی: 16

SHOW FULL COLUMNS 
  FROM `dly1p_users`

توضیح دادن

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

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
20	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
19	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
18	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
17	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:210
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM `dly1p_users`

  WHERE `id` = 491

توضیح دادن

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

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
17	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:210
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.55 ms پس از آخرین پرس و جو: 1.49 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 11.241 MB سطرهای بازگشتی: 0

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

  FROM `dly1p_usergroups` AS g

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

  WHERE `m`.`user_id` = 491

توضیح دادن

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	gciran_ndb.m.group_id	1

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
17	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:210
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.53 ms پس از آخرین پرس و جو: 1.07 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 11.358 MB سطرهای بازگشتی: 0

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

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM dly1p_k2_users 
  WHERE userID=491

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dly1p_k2_users	ref	userID	userID	4	const	1

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1702
14	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:46
13	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:213
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.45 ms پس از آخرین پرس و جو: 0.03 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 11.365 MB سطرهای بازگشتی: 0

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

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM dly1p_k2_users 
  WHERE userID=491

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dly1p_k2_users	ref	userID	userID	4	const	1

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1702
13	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:214
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.52 ms پس از آخرین پرس و جو: 0.03 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 11.372 MB سطرهای بازگشتی: 1

SELECT COUNT(*) 
  FROM dly1p_k2_comments 
  WHERE itemID=983 
  AND published=1

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dly1p_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1489
13	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:227
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 1.09 ms پس از آخرین پرس و جو: 3.43 ms حافظه پرس و جو: 0.010 MB حافظه قبل از پرس و جوی: 11.836 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 dly1p_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_k2.item-media' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  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	gciran_ndb.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	gciran_ndb.a.checked_out	1
1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	gciran_ndb.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	gciran_ndb.a.group_id	1	Using where

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
18	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
15	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:603
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 1.23 ms پس از آخرین پرس و جو: 0.55 ms حافظه پرس و جو: 0.010 MB حافظه قبل از پرس و جوی: 11.886 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 dly1p_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_k2.item' 
  AND (fc.category_id IS NULL OR fc.category_id IN (4,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  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	gciran_ndb.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	gciran_ndb.a.checked_out	1
1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	gciran_ndb.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	gciran_ndb.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	gciran_ndb.a.id	1	Using where; Using index; Distinct

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
18	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
15	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:674
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.81 ms پس از آخرین پرس و جو: 2.08 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 12.226 MB سطرهای بازگشتی: 36

SHOW FULL COLUMNS 
  FROM `dly1p_k2_items`

توضیح دادن

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

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2item.php:56
14	TableK2Item->__construct()	JROOT/libraries/src/Table/Table.php:312
13	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/models/item.php:854
12	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:146
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.48 ms پس از آخرین پرس و جو: 0.07 ms حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 12.286 MB

UPDATE dly1p_k2_items

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

  WHERE `id` = '983'

توضیح دادن

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

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1245
13	Joomla\CMS\Table\Table->hit()	JROOT/components/com_k2/models/item.php:855
12	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:146
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.55 ms پس از آخرین پرس و جو: 0.08 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 12.290 MB سطرهای بازگشتی: 0

SELECT * 
  FROM dly1p_k2_comments 
  WHERE itemID=983 
  AND published=1  
  ORDER BY commentDate DESC 
  LIMIT 0, 10

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dly1p_k2_comments	range	itemID,published,latestComments,countComments	latestComments	4	NULL	1	Using where

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1471
12	K2ModelItem->getItemComments()	JROOT/components/com_k2/views/item/view.html.php:227
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 5.35 ms پس از آخرین پرس و جو: 0.61 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 12.380 MB سطرهای بازگشتی: 5

SELECT i.*, c.alias AS categoryalias
            
  FROM dly1p_k2_items AS i
            
  LEFT JOIN dly1p_k2_categories c 
  ON c.id = i.catid
            
  WHERE i.id != 983
                
  AND i.published = 1
                
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-06-07 20:47:14')
                
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-06-07 20:47:14') 
  AND i.access IN(1,1) 
  AND i.language IN('fa-IR', '*') 
  AND i.trash = 0
            
  AND i.created_by = 491
            
  AND i.created_by_alias=''
            
  AND c.published = 1 
  AND c.access IN(1,1) 
  AND c.language IN('fa-IR', '*') 
  AND c.trash = 0
            
  ORDER BY i.created DESC 
  LIMIT 0, 5

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	range	PRIMARY,category,published,access,trash,language,idx_category	published	2	NULL	26	Using index condition; Using where; Using temporary; با استفاده از مرتب سازی فایل
1	SIMPLE	i	ref	PRIMARY,catid,created_by,language,idx_items_common,idx_items_common_backend,idx_items_authors	idx_items_common	12	gciran_ndb.c.id,const,const,const	16	Using index condition; Using where

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:547
12	K2ModelItemlist->getAuthorLatest()	JROOT/components/com_k2/views/item/view.html.php:269
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.64 ms پس از آخرین پرس و جو: 0.46 ms حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 12.439 MB سطرهای بازگشتی: 1

SELECT *
            
  FROM dly1p_k2_items
            
  WHERE id < 983
                
  AND catid = 4
                
  AND published = 1
                
  AND trash = 0
                
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-06-07 20:47:14')
                
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-06-07 20:47:14')
                
  AND access IN (1,1)
                
  AND language IN ('fa-IR', '*')
            
  ORDER BY id DESC 
  LIMIT 0, 1

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dly1p_k2_items	range	PRIMARY,catid,language,idx_items_common,idx_items_common_backend	catid	8	NULL	60	Using where

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1625
12	K2ModelItem->getPreviousItem()	JROOT/components/com_k2/views/item/view.html.php:293
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.85 ms پس از آخرین پرس و جو: 0.41 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 12.506 MB سطرهای بازگشتی: 0

SELECT tag.*
            
  FROM dly1p_k2_tags AS tag
            JOIN dly1p_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
            
  WHERE tag.published = 1
                
  AND xref.itemID = 982
            
  ORDER BY xref.id ASC

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tag	ref	PRIMARY,published	published	2	const	1	Using temporary; با استفاده از مرتب سازی فایل
1	SIMPLE	xref	ref	tagID,itemID,idx_tags_xref_common	idx_tags_xref_common	8	gciran_ndb.tag.id,const	1	Using index

مشخصات

Status	Duration
Starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.10 ms
Creating sort index	0.03 ms
Removing tmp table	0.05 ms
Creating sort index	0.02 ms
End of update loop	0.02 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.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

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

#	فراخوانده	فایل و شماره خط
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1222
13	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:111
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:295
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.62 ms پس از آخرین پرس و جو: 0.05 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 12.514 MB سطرهای بازگشتی: 0

SELECT * 
  FROM dly1p_k2_attachments 
  WHERE itemID=982

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dly1p_k2_attachments	ref	itemID	itemID	4	const	1

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1450
13	K2ModelItem->getItemAttachments()	JROOT/components/com_k2/models/item.php:164
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:295
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.57 ms پس از آخرین پرس و جو: 0.03 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 12.521 MB سطرهای بازگشتی: 0

SELECT * 
  FROM dly1p_k2_rating 
  WHERE itemID = 982

توضیح دادن

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

مشخصات

Status	Duration
Starting	0.03 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.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.02 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.04 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

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

#	فراخوانده	فایل و شماره خط
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:929
14	K2ModelItem->getRating()	JROOT/components/com_k2/models/item.php:973
13	K2ModelItem->getVotesPercentage()	JROOT/components/com_k2/models/item.php:169
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:295
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

پرس و جوی تکراری: #24 #25 #38

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM dly1p_k2_users 
  WHERE userID=491

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dly1p_k2_users	ref	userID	userID	4	const	1

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1702
14	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:46
13	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:213
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:295
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.38 ms پس از آخرین پرس و جو: 0.02 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 12.536 MB سطرهای بازگشتی: 0

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

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM dly1p_k2_users 
  WHERE userID=491

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dly1p_k2_users	ref	userID	userID	4	const	1

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1702
13	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:214
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:295
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.41 ms پس از آخرین پرس و جو: 0.04 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 12.543 MB سطرهای بازگشتی: 1

SELECT COUNT(*) 
  FROM dly1p_k2_comments 
  WHERE itemID=982 
  AND published=1

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dly1p_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1489
13	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:227
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:295
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.59 ms پس از آخرین پرس و جو: 0.20 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 12.535 MB سطرهای بازگشتی: 0

SELECT *
            
  FROM dly1p_k2_items
            
  WHERE id > 983
                
  AND catid = 4
                
  AND published = 1
                
  AND trash = 0
                
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-06-07 20:47:14')
                
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-06-07 20:47:14')
                
  AND access IN (1,1)
                
  AND language IN ('fa-IR', '*')
            
  ORDER BY id ASC 
  LIMIT 0, 1

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dly1p_k2_items	ref\|filter	PRIMARY,catid,language,idx_items_common,idx_items_common_backend	catid\|idx_items_common_backend	4\|6	const	17 (1%)	Using index condition; Using where; Using rowid filter

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1684
12	K2ModelItem->getNextItem()	JROOT/components/com_k2/views/item/view.html.php:334
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.88 ms پس از آخرین پرس و جو: 2.46 ms حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 12.749 MB سطرهای بازگشتی: 6

SHOW FULL COLUMNS 
  FROM `dly1p_template_styles`

توضیح دادن

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

مشخصات

Status	Duration
Starting	0.03 ms
checking permissions	0.02 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.11 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.02 ms
Filling schema table	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.04 ms
closing tables	0.02 ms
checking permissions	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.02 ms
Query end	0.04 ms
closing tables	0.01 ms
Removing tmp table	0.05 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.01 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.01 ms

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

#	فراخوانده	فایل و شماره خط
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
12	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
11	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
10	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
9	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:312
8	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/helix3/helix3.php:37
7	plgSystemHelix3->onAfterDispatch()	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/SiteApplication.php:199
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM dly1p_template_styles

  WHERE `id` = '11'

توضیح دادن

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

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
9	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
8	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/helix3/helix3.php:38
7	plgSystemHelix3->onAfterDispatch()	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/SiteApplication.php:199
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT language,id

  FROM `dly1p_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

توضیح دادن

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

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	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/SiteApplication.php:199
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.65 ms پس از آخرین پرس و جو: 5.41 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 13.605 MB سطرهای بازگشتی: 86

SELECT * 
  FROM dly1p_acymailing_config

توضیح دادن

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

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:464
13	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
12	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:434
11	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:803
10	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:21
9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:22
8	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:146
7	plgSystemRegacymailing->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:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

4 × SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM dly1p_k2_users

2 × SELECT * 
  FROM dly1p_k2_attachments

```
2 × SELECT * 
  FROM dly1p_k2_rating
```

2 × SELECT *             
  FROM dly1p_k2_items

2 × SELECT COUNT(*) 
  FROM dly1p_k2_comments

2 × SELECT * 
  FROM dly1p_k2_categories

2 × SELECT tag.*             
  FROM dly1p_k2_tags AS tag             JOIN dly1p_k2_tags_xref AS xref 
  ON tag.id = xref.tagID

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

1 × SELECT language,id 
  FROM `dly1p_menu`

1 × SELECT * 
  FROM dly1p_template_styles

1 × SELECT i.*, c.alias AS categoryalias             
  FROM dly1p_k2_items AS i             
  LEFT JOIN dly1p_k2_categories c 
  ON c.id = i.catid

1 × SELECT * 
  FROM dly1p_k2_comments

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 dly1p_fields AS a 
  LEFT JOIN `dly1p_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN dly1p_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN dly1p_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN dly1p_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN dly1p_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `dly1p_fields_categories` AS fc 
  ON fc.field_id = a.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 dly1p_fields AS a 
  LEFT JOIN `dly1p_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN dly1p_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN dly1p_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN dly1p_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN dly1p_fields_groups AS g 
  ON g.id = a.group_id

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

1 × SELECT `data` 
  FROM `dly1p_session`

```
1 × SELECT * 
  FROM `dly1p_users`
```
```
1 × SELECT * 
  FROM dly1p_k2_items
```

1 × SELECT id 
  FROM dly1p_k2_categories

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `dly1p_assets`

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

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

1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `dly1p_extensions`

```
1 × SELECT * 
  FROM dly1p_languages
```

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

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

1 × SELECT id, rules 
  FROM `dly1p_viewlevels

1 × SELECT * 
  FROM dly1p_acymailing_confi

سایر جداول:

1 × UPDATE `dly1p_extensions` 
  SET `params` = '{\"mediaversion\":\"fc5bff8b68fe3d95b1bc3bf8c369a063\"}'

1 × SHOW FULL COLUMNS 
  FROM `dly1p_k2_categories

1 × SHOW FULL COLUMNS 
  FROM `dly1p_users

1 × SHOW FULL COLUMNS 
  FROM `dly1p_k2_items

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

1 × SHOW FULL COLUMNS 
  FROM `dly1p_template_styles

Covid-19 - 17

mehdi razabadi

آخرین‌ها از mehdi razabadi

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

جلسه

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

زمان

حافظه

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

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

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

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

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

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

سایر جداول: