mehdi razabadi

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

جلسه

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1780890113,
                "last": 1780890113,
                "now": 1780890113
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "fa-IR"
        }
    }
}

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

زمان

حافظه

زمان: 12.78 ms / 12.78 ms حافظه: 1.631 MB / 2.02 MB Application: afterLoad

زمان: 72.67 ms / 85.45 ms حافظه: 5.516 MB / 7.54 MB Application: afterInitialise

زمان: 35.68 ms / 121.13 ms حافظه: 2.117 MB / 9.65 MB Application: afterRoute

زمان: 0.74 ms / 121.87 ms حافظه: 0.016 MB / 9.67 MB Application: beforeRenderComponent com_k2

زمان: 0.21 ms / 122.07 ms حافظه: 0.027 MB / 9.70 MB Application: Before Access::preloadComponents (all components)

زمان: 2.07 ms / 124.14 ms حافظه: 0.065 MB / 9.76 MB Application: After Access::preloadComponents (all components)

زمان: 0.03 ms / 124.17 ms حافظه: -0.003 MB / 9.76 MB Application: Before Access::getAssetRules (id:262 name:com_k2)

زمان: 0.41 ms / 124.59 ms حافظه: 0.088 MB / 9.85 MB Application: After Access::getAssetRules (id:262 name:com_k2)

زمان: 241.87 ms / 366.45 ms حافظه: 3.926 MB / 13.77 MB Application: afterRenderComponent com_k2

زمان: 2.98 ms / 369.43 ms حافظه: 0.169 MB / 13.94 MB Application: afterDispatch

زمان: 221.36 ms / 590.79 ms حافظه: 1.953 MB / 15.89 MB Application: beforeRenderModule mod_search (جستجو)

زمان: 0.75 ms / 591.54 ms حافظه: 0.038 MB / 15.93 MB Application: afterRenderModule mod_search (جستجو)

زمان: 0.03 ms / 591.57 ms حافظه: -0.003 MB / 15.93 MB Application: beforeRenderModule mod_menu (Off Canvas Menu)

زمان: 3.68 ms / 595.24 ms حافظه: 0.130 MB / 16.06 MB Application: afterRenderModule mod_menu (Off Canvas Menu)

زمان: 0.06 ms / 595.30 ms حافظه: 0.004 MB / 16.06 MB Application: beforeRenderModule mod_acymailing (اشتراک خبرنامه)

زمان: 10.50 ms / 605.80 ms حافظه: 1.111 MB / 17.17 MB Application: afterRenderModule mod_acymailing (اشتراک خبرنامه)

زمان: 0.05 ms / 605.85 ms حافظه: -0.016 MB / 17.16 MB Application: beforeRenderModule mod_k2_content (علائم و تجهیزات پر بازدید)

زمان: 16.30 ms / 622.15 ms حافظه: 0.173 MB / 17.33 MB Application: afterRenderModule mod_k2_content (علائم و تجهیزات پر بازدید)

زمان: 0.08 ms / 622.23 ms حافظه: -0.047 MB / 17.28 MB Application: beforeRenderModule mod_custom (Bottom-1)

زمان: 2.56 ms / 624.79 ms حافظه: 0.024 MB / 17.31 MB Application: afterRenderModule mod_custom (Bottom-1)

زمان: 0.05 ms / 624.84 ms حافظه: -0.001 MB / 17.31 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

زمان: 0.55 ms / 625.39 ms حافظه: 0.023 MB / 17.33 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

زمان: 0.06 ms / 625.45 ms حافظه: -0.005 MB / 17.32 MB Application: beforeRenderModule mod_custom (ایمیل)

زمان: 0.15 ms / 625.59 ms حافظه: 0.003 MB / 17.33 MB Application: afterRenderModule mod_custom (ایمیل)

زمان: 2.36 ms / 627.96 ms حافظه: 0.221 MB / 17.55 MB Application: afterRender

جمع پرس و جوی بانک اطلاعاتی: 269.98 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

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

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

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

مشخصات

Status	Duration
Starting	0.10 ms
checking permissions	0.10 ms
Opening tables	0.09 ms
After opening tables	0.10 ms
System lock	0.17 ms
table lock	0.10 ms
init for update	0.06 ms
Update	0.10 ms
End of update loop	0.05 ms
Query end	0.07 ms
Commit	0.13 ms
Query end	0.12 ms
closing tables	0.09 ms
Unlocking tables	0.09 ms
closing tables	0.13 ms
Query end	0.08 ms
Starting cleanup	0.08 ms
Freeing items	0.07 ms
Updating status	0.07 ms
Reset for next command	0.06 ms

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

#	فراخوانده	فایل و شماره خط
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
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 برای لینک به فایل ها]

زمان پرس و جو: 1.72 ms پس از آخرین پرس و جو: 1.91 ms حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 4.130 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.10 ms
checking permissions	0.09 ms
Opening tables	0.11 ms
After opening tables	0.05 ms
System lock	0.10 ms
table lock	0.07 ms
init	0.14 ms
Optimizing	0.10 ms
Statistics	0.12 ms
Preparing	0.06 ms
Executing	0.08 ms
Sending data	0.24 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.02 ms
closing tables	0.04 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.06 ms
Reset for next command	0.05 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.93 ms پس از آخرین پرس و جو: 1.99 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 4.331 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.07 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.05 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.04 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.05 ms
closing tables	0.06 ms
Query end	0.03 ms
Starting cleanup	0.05 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

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

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

زمان پرس و جو: 4.72 ms پس از آخرین پرس و جو: 0.10 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 4.343 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.07 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Unlocking tables	0.02 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.04 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

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

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

زمان پرس و جو: 4.21 ms پس از آخرین پرس و جو: 0.58 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 4.412 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.07 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.05 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.03 ms
Creating sort index	0.50 ms
End of update loop	0.07 ms
Query end	0.05 ms
Commit	0.04 ms
Query end	0.07 ms
closing tables	0.03 ms
Unlocking tables	0.04 ms
closing tables	0.03 ms
Query end	0.05 ms
Starting cleanup	0.04 ms
Freeing items	0.05 ms
Updating status	0.04 ms
Reset for next command	0.04 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 برای لینک به فایل ها]

زمان پرس و جو: 1.22 ms پس از آخرین پرس و جو: 15.97 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 6.556 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.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.02 ms
Preparing	0.02 ms
Sorting result	0.03 ms
Executing	0.02 ms
Sending data	0.02 ms
Creating sort index	0.07 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.01 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

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

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

زمان پرس و جو: 2.55 ms پس از آخرین پرس و جو: 0.10 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 6.566 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.07 ms
checking permissions	0.05 ms
Opening tables	0.05 ms
After opening tables	0.05 ms
System lock	0.05 ms
table lock	0.06 ms
init	0.05 ms
Optimizing	0.06 ms
Statistics	0.06 ms
Preparing	0.09 ms
Executing	0.05 ms
Sending data	0.11 ms
End of update loop	0.13 ms
Query end	0.05 ms
Commit	0.04 ms
Query end	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
closing tables	0.04 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

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

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

زمان پرس و جو: 5.68 ms پس از آخرین پرس و جو: 6.15 ms حافظه پرس و جو: 0.010 MB حافظه قبل از پرس و جوی: 7.206 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.12 ms
checking permissions	0.05 ms
Opening tables	0.09 ms
After opening tables	0.06 ms
System lock	0.07 ms
table lock	0.05 ms
init	0.07 ms
Optimizing	0.05 ms
Statistics	0.12 ms
Preparing	0.05 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.04 ms
Creating sort index	0.60 ms
End of update loop	0.05 ms
Query end	0.06 ms
Commit	0.09 ms
Query end	0.04 ms
closing tables	0.05 ms
Unlocking tables	0.04 ms
closing tables	0.04 ms
Query end	0.07 ms
Starting cleanup	0.05 ms
Freeing items	0.06 ms
Updating status	0.09 ms
Reset for next command	0.05 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 برای لینک به فایل ها]

زمان پرس و جو: 2.49 ms پس از آخرین پرس و جو: 7.57 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 8.200 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.13 ms
checking permissions	0.07 ms
Opening tables	0.11 ms
After opening tables	0.07 ms
System lock	0.07 ms
table lock	0.06 ms
init	0.21 ms
Optimizing	0.07 ms
Statistics	0.12 ms
Preparing	0.10 ms
Executing	0.04 ms
Sending data	0.15 ms
End of update loop	0.08 ms
Query end	0.06 ms
Commit	0.07 ms
Query end	0.05 ms
closing tables	0.20 ms
Unlocking tables	0.08 ms
closing tables	0.08 ms
Query end	0.11 ms
Starting cleanup	0.29 ms
Freeing items	0.09 ms
Updating status	0.08 ms
Reset for next command	0.05 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 برای لینک به فایل ها]

زمان پرس و جو: 3.41 ms پس از آخرین پرس و جو: 0.11 ms حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 8.193 MB

UPDATE `dly1p_extensions`

  SET `params` = '{\"mediaversion\":\"07a2fd37e542eb5c2ffbc899b1308d01\"}'

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

توضیح دادن

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

مشخصات

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

زمان پرس و جو: 1.82 ms پس از آخرین پرس و جو: 4.48 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 8.856 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.07 ms
checking permissions	0.03 ms
Opening tables	0.09 ms
After opening tables	0.05 ms
System lock	0.06 ms
table lock	0.06 ms
init	0.09 ms
Optimizing	0.06 ms
Statistics	0.11 ms
Preparing	0.14 ms
Executing	0.07 ms
Sending data	0.16 ms
End of update loop	0.08 ms
Query end	0.06 ms
Commit	0.05 ms
Query end	0.05 ms
closing tables	0.05 ms
Unlocking tables	0.08 ms
closing tables	0.07 ms
Query end	0.08 ms
Starting cleanup	0.07 ms
Freeing items	0.10 ms
Updating status	0.09 ms
Reset for next command	0.07 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 برای لینک به فایل ها]

زمان پرس و جو: 2.87 ms پس از آخرین پرس و جو: 3.90 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 9.434 MB سطرهای بازگشتی: 7

SHOW FULL COLUMNS 
  FROM `dly1p_session`

توضیح دادن

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

مشخصات

Status	Duration
Starting	0.08 ms
checking permissions	0.07 ms
closing tables	0.07 ms
checking permissions	0.07 ms
Opening tables	0.26 ms
After opening tables	0.06 ms
System lock	0.09 ms
table lock	0.07 ms
init	0.07 ms
Optimizing	0.09 ms
Statistics	0.06 ms
Preparing	0.05 ms
Executing	0.06 ms
Filling schema table	0.10 ms
Opening tables	0.09 ms
After opening tables	0.07 ms
checking permissions	0.12 ms
closing tables	0.05 ms
checking permissions	0.07 ms
Executing	0.06 ms
Sending data	0.08 ms
End of update loop	0.08 ms
Query end	0.10 ms
closing tables	0.08 ms
Removing tmp table	0.15 ms
closing tables	0.06 ms
Unlocking tables	0.09 ms
closing tables	0.09 ms
Query end	0.09 ms
Starting cleanup	0.10 ms
Freeing items	0.11 ms
Updating status	0.12 ms
Reset for next command	0.08 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_jrealtimeanalytics/tables/session.php:163
14	JRealtimeTableSession->__construct()	JROOT/libraries/src/Table/Table.php:312
13	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_jrealtimeanalytics/framework/helpers/users.php:135
12	JRealtimeHelpersUsers::getSessionTable()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:48
11	plgSystemJRealtimeAnalytics->notifyObservers()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:152
10	plgSystemJRealtimeAnalytics->injectApp()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:601
9	plgSystemJRealtimeAnalytics->startApp()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:628
8	plgSystemJRealtimeAnalytics->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 برای لینک به فایل ها]

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

SELECT *

  FROM dly1p_session

  WHERE `session_id` = 'fc431c9f88e7d7a92db893ce7d6ca347'

توضیح دادن

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.11 ms
checking permissions	0.08 ms
Opening tables	0.11 ms
After opening tables	0.07 ms
System lock	0.13 ms
table lock	0.08 ms
init	0.13 ms
Optimizing	0.13 ms
Statistics	0.14 ms
Preparing	0.09 ms
Unlocking tables	0.11 ms
Preparing	0.12 ms
Executing	0.13 ms
Sending data	0.13 ms
End of update loop	0.15 ms
Query end	0.12 ms
Commit	0.12 ms
Query end	0.05 ms
closing tables	0.08 ms
Unlocking tables	0.09 ms
closing tables	0.10 ms
Query end	0.08 ms
Starting cleanup	0.09 ms
Freeing items	0.10 ms
Updating status	0.15 ms
Reset for next command	0.09 ms

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

#	فراخوانده	فایل و شماره خط
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
13	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_jrealtimeanalytics/framework/helpers/users.php:136
12	JRealtimeHelpersUsers::getSessionTable()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:48
11	plgSystemJRealtimeAnalytics->notifyObservers()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:152
10	plgSystemJRealtimeAnalytics->injectApp()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:601
9	plgSystemJRealtimeAnalytics->startApp()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:628
8	plgSystemJRealtimeAnalytics->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 برای لینک به فایل ها]

زمان پرس و جو: 2.61 ms پس از آخرین پرس و جو: 1.21 ms حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 9.636 MB سطرهای بازگشتی: 0

SELECT * 
  FROM `dly1p_realtimeanalytics_eventstats`
 
  WHERE `type` = 'viewurl'
 
  AND `published` = 1

توضیح دادن

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

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:388
15	JRealtimeModelEventstatsObsrv::loadEventsFromDB()	JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:181
14	JRealtimeModelEventstatsObsrv->trackEventVisitPage()	JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:413
13	JRealtimeModelEventstatsObsrv->update()	JROOT/administrator/components/com_jrealtimeanalytics/framework/model/observable.php:97
12	JRealtimeModelObservable->notify()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:78
11	plgSystemJRealtimeAnalytics->notifyObservers()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:152
10	plgSystemJRealtimeAnalytics->injectApp()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:601
9	plgSystemJRealtimeAnalytics->startApp()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:628
8	plgSystemJRealtimeAnalytics->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 برای لینک به فایل ها]

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

SELECT * 
  FROM `dly1p_realtimeanalytics_eventstats`
 
  WHERE `type` = 'minpages'
 
  AND `published` = 1

توضیح دادن

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

مشخصات

Status	Duration
Starting	0.15 ms
checking permissions	0.17 ms
Opening tables	0.21 ms
After opening tables	0.17 ms
System lock	0.20 ms
table lock	0.12 ms
init	0.14 ms
Optimizing	0.11 ms
Statistics	0.11 ms
Preparing	0.11 ms
Executing	0.14 ms
Sending data	0.19 ms
End of update loop	0.10 ms
Query end	0.13 ms
Commit	0.15 ms
Query end	0.11 ms
closing tables	0.11 ms
Unlocking tables	0.12 ms
closing tables	0.11 ms
Query end	0.17 ms
Starting cleanup	0.10 ms
Freeing items	0.08 ms
Updating status	0.12 ms
Reset for next command	0.10 ms

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

#	فراخوانده	فایل و شماره خط
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:388
15	JRealtimeModelEventstatsObsrv::loadEventsFromDB()	JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:231
14	JRealtimeModelEventstatsObsrv->trackEventMinPageVisited()	JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:416
13	JRealtimeModelEventstatsObsrv->update()	JROOT/administrator/components/com_jrealtimeanalytics/framework/model/observable.php:97
12	JRealtimeModelObservable->notify()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:78
11	plgSystemJRealtimeAnalytics->notifyObservers()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:152
10	plgSystemJRealtimeAnalytics->injectApp()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:601
9	plgSystemJRealtimeAnalytics->startApp()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:628
8	plgSystemJRealtimeAnalytics->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 برای لینک به فایل ها]

زمان پرس و جو: 1.91 ms پس از آخرین پرس و جو: 1.12 ms حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 9.702 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.09 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.06 ms
table lock	0.10 ms
init	0.13 ms
Optimizing	0.12 ms
Statistics	0.12 ms
Preparing	0.05 ms
Executing	0.04 ms
Sending data	0.21 ms
End of update loop	0.05 ms
Query end	0.05 ms
Commit	0.06 ms
Query end	0.07 ms
closing tables	0.07 ms
Unlocking tables	0.08 ms
closing tables	0.07 ms
Query end	0.10 ms
Starting cleanup	0.06 ms
Freeing items	0.10 ms
Updating status	0.08 ms
Reset for next command	0.07 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 برای لینک به فایل ها]

زمان پرس و جو: 2.94 ms پس از آخرین پرس و جو: 10.94 ms حافظه پرس و جو: 0.010 MB حافظه قبل از پرس و جوی: 11.016 MB سطرهای بازگشتی: 16

SHOW FULL COLUMNS 
  FROM `dly1p_users`

توضیح دادن

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

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
20	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
19	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
18	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
17	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
16	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
15	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
14	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
13	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
12	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/views/itemlist/view.html.php:355
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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.84 ms پس از آخرین پرس و جو: 0.08 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 11.051 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.06 ms
checking permissions	0.05 ms
Opening tables	0.06 ms
After opening tables	0.05 ms
System lock	0.05 ms
table lock	0.12 ms
init	0.07 ms
Optimizing	0.05 ms
Statistics	0.08 ms
Preparing	0.04 ms
Unlocking tables	0.08 ms
Preparing	0.10 ms
Executing	0.09 ms
Sending data	0.10 ms
End of update loop	0.07 ms
Query end	0.08 ms
Commit	0.07 ms
Query end	0.05 ms
closing tables	0.08 ms
Unlocking tables	0.09 ms
closing tables	0.08 ms
Query end	0.07 ms
Starting cleanup	0.06 ms
Freeing items	0.08 ms
Updating status	0.06 ms
Reset for next command	0.06 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
16	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
15	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
14	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
13	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
12	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/views/itemlist/view.html.php:355
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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.74 ms پس از آخرین پرس و جو: 2.24 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 11.805 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.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.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.05 ms
Query end	0.04 ms
closing tables	0.04 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.05 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
17	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
16	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
15	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
14	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
13	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
12	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/views/itemlist/view.html.php:355
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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.77 ms پس از آخرین پرس و جو: 0.06 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 11.810 MB سطرهای بازگشتی: 0

پرس و جوی تکراری: #23 #30 #31 #35 #36 #39 #40 #43 #44 #47 #48 #51 #52 #55 #56 #59 #60 #63 #64 #67 #68

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.03 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.05 ms
init	0.03 ms
Optimizing	0.04 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.03 ms
Sending data	0.04 ms
End of update loop	0.04 ms
Query end	0.05 ms
Commit	0.03 ms
Query end	0.06 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.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/itemlist.php:492
12	K2ModelItemlist->getUserProfile()	JROOT/components/com_k2/views/itemlist/view.html.php:363
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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.29 ms پس از آخرین پرس و جو: 0.11 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 11.817 MB سطرهای بازگشتی: 0

پرس و جوی تکراری: #22 #30 #31 #35 #36 #39 #40 #43 #44 #47 #48 #51 #52 #55 #56 #59 #60 #63 #64 #67 #68

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.06 ms
checking permissions	0.07 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.04 ms
table lock	0.04 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
End of update loop	0.02 ms
Query end	0.06 ms
Commit	0.09 ms
Query end	0.06 ms
closing tables	0.08 ms
Unlocking tables	0.10 ms
closing tables	0.09 ms
Query end	0.06 ms
Starting cleanup	0.06 ms
Freeing items	0.04 ms
Updating status	0.08 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/helpers/utilities.php:46
12	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/views/itemlist/view.html.php:366
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

زمان پرس و جو: 55.63 ms پس از آخرین پرس و جو: 2.16 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 12.003 MB سطرهای بازگشتی: 10

/* Frontend / K2 / Items */ SELECT /*+ MAX_EXECUTION_TIME(60000) */ i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams 
  FROM dly1p_k2_items AS i 
  INNER JOIN dly1p_k2_categories AS c 
  ON c.id = i.catid 
  WHERE i.published = 1 
  AND i.access IN(1) 
  AND i.trash = 0 
  AND c.published = 1 
  AND c.access IN(1) 
  AND c.trash = 0 
  AND c.language IN('fa-IR', '*') 
  AND i.language IN('fa-IR', '*') 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-06-08 03:41:53') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-06-08 03:41:53') 
  AND i.created_by=491 
  AND i.created_by_alias='' 
  ORDER BY i.id DESC 
  LIMIT 110, 10

توضیح دادن

توضیحات در جستجو ممکن نیست: /* Frontend / K2 / Items */ SELECT /*+ MAX_EXECUTION_TIME(60000) */ i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams FROM dly1p_k2_items AS i INNER JOIN dly1p_k2_categories AS c ON c.id = i.catid WHERE i.published = 1 AND i.access IN(1) AND i.trash = 0 AND c.published = 1 AND c.access IN(1) AND c.trash = 0 AND c.language IN('fa-IR', '*') AND i.language IN('fa-IR', '*') AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-06-08 03:41:53') AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-06-08 03:41:53') AND i.created_by=491 AND i.created_by_alias='' ORDER BY i.id DESC LIMIT 110, 10

مشخصات

Status	Duration
Starting	0.11 ms
checking permissions	0.04 ms
Opening tables	0.11 ms
After opening tables	0.05 ms
System lock	0.06 ms
table lock	0.08 ms
init	0.10 ms
Optimizing	0.07 ms
Statistics	0.16 ms
Preparing	0.07 ms
Creating tmp table	0.09 ms
Sorting result	0.04 ms
Executing	0.04 ms
Sending data	34.53 ms
Creating sort index	19.34 ms
Removing tmp table	0.29 ms
Creating sort index	0.07 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.04 ms
Starting cleanup	0.05 ms
Freeing items	0.03 ms
Updating status	0.04 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:335
12	K2ModelItemlist->getData()	JROOT/components/com_k2/views/itemlist/view.html.php:576
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

/* Frontend / K2 / Items Count */ SELECT COUNT(*) 
  FROM dly1p_k2_items AS i 
  INNER JOIN dly1p_k2_categories AS c 
  ON c.id = i.catid 
  WHERE i.published = 1 
  AND i.access IN(1) 
  AND i.trash = 0 
  AND c.published = 1 
  AND c.access IN(1) 
  AND c.trash = 0 
  AND c.language IN('fa-IR', '*') 
  AND i.language IN('fa-IR', '*') 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-06-08 03:41:53') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-06-08 03:41:53') 
  AND i.created_by=491 
  AND i.created_by_alias=''

توضیح دادن

توضیحات در جستجو ممکن نیست: /* Frontend / K2 / Items Count */ SELECT COUNT(*) FROM dly1p_k2_items AS i INNER JOIN dly1p_k2_categories AS c ON c.id = i.catid WHERE i.published = 1 AND i.access IN(1) AND i.trash = 0 AND c.published = 1 AND c.access IN(1) AND c.trash = 0 AND c.language IN('fa-IR', '*') AND i.language IN('fa-IR', '*') AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-06-08 03:41:53') AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-06-08 03:41:53') AND i.created_by=491 AND i.created_by_alias=''

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/itemlist.php:345
12	K2ModelItemlist->getData()	JROOT/components/com_k2/views/itemlist/view.html.php:576
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

SHOW FULL COLUMNS 
  FROM `dly1p_k2_categories`

توضیح دادن

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

مشخصات

Status	Duration
Starting	0.15 ms
checking permissions	0.15 ms
closing tables	0.12 ms
checking permissions	0.12 ms
Opening tables	0.23 ms
After opening tables	0.15 ms
System lock	0.16 ms
table lock	0.15 ms
init	0.19 ms
Optimizing	0.15 ms
Statistics	0.15 ms
Preparing	0.15 ms
Executing	0.10 ms
Filling schema table	0.12 ms
Opening tables	0.11 ms
After opening tables	0.13 ms
checking permissions	0.15 ms
closing tables	0.13 ms
checking permissions	0.12 ms
Executing	0.12 ms
Sending data	0.14 ms
End of update loop	0.18 ms
Query end	0.18 ms
closing tables	0.19 ms
Removing tmp table	0.18 ms
closing tables	0.15 ms
Unlocking tables	0.18 ms
closing tables	0.13 ms
Query end	0.18 ms
Starting cleanup	0.18 ms
Freeing items	0.18 ms
Updating status	0.20 ms
Reset for next command	0.21 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
14	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2category.php:34
13	TableK2Category->__construct()	JROOT/libraries/src/Table/Table.php:312
12	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/views/itemlist/view.html.php:730
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

SELECT * 
  FROM dly1p_k2_categories 
  WHERE id = '21'

توضیح دادن

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.13 ms
checking permissions	0.13 ms
Opening tables	0.14 ms
After opening tables	0.15 ms
System lock	0.12 ms
table lock	0.13 ms
init	0.15 ms
Optimizing	0.18 ms
Statistics	0.15 ms
Preparing	0.11 ms
Unlocking tables	0.09 ms
Preparing	0.12 ms
Executing	0.11 ms
Sending data	0.15 ms
End of update loop	0.21 ms
Query end	0.18 ms
Commit	0.17 ms
Query end	0.14 ms
closing tables	0.18 ms
Unlocking tables	0.47 ms
closing tables	0.18 ms
Query end	0.16 ms
Starting cleanup	0.15 ms
Freeing items	0.19 ms
Updating status	0.21 ms
Reset for next command	0.18 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:61
16	TableK2Category->load()	JROOT/components/com_k2/models/item.php:65
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

SELECT * 
  FROM dly1p_k2_categories 
  WHERE id = '18'

توضیح دادن

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.22 ms
checking permissions	0.17 ms
Opening tables	0.12 ms
After opening tables	0.16 ms
System lock	0.14 ms
table lock	0.19 ms
init	0.23 ms
Optimizing	0.19 ms
Statistics	0.16 ms
Preparing	0.15 ms
Unlocking tables	0.20 ms
Preparing	0.22 ms
Executing	0.17 ms
Sending data	0.16 ms
End of update loop	0.16 ms
Query end	0.15 ms
Commit	0.16 ms
Query end	0.18 ms
closing tables	0.14 ms
Unlocking tables	0.15 ms
closing tables	0.13 ms
Query end	0.12 ms
Starting cleanup	0.12 ms
Freeing items	0.16 ms
Updating status	0.19 ms
Reset for next command	0.13 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:61
16	TableK2Category->load()	JROOT/components/com_k2/models/item.php:87
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

زمان پرس و جو: 4.64 ms پس از آخرین پرس و جو: 0.18 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 12.421 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 = 872
            
  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.20 ms
checking permissions	0.21 ms
Opening tables	0.18 ms
After opening tables	0.16 ms
System lock	0.15 ms
table lock	0.15 ms
init	0.14 ms
Optimizing	0.15 ms
Statistics	0.20 ms
Preparing	0.19 ms
Creating tmp table	0.16 ms
Sorting result	0.14 ms
Executing	0.13 ms
Sending data	0.24 ms
Creating sort index	0.17 ms
Removing tmp table	0.23 ms
Creating sort index	0.14 ms
End of update loop	0.14 ms
Query end	0.12 ms
Commit	0.11 ms
Query end	0.15 ms
closing tables	0.16 ms
Unlocking tables	0.13 ms
closing tables	0.15 ms
Query end	0.14 ms
Starting cleanup	0.13 ms
Freeing items	0.13 ms
Updating status	0.18 ms
Reset for next command	0.16 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1222
16	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:111
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

پرس و جوی تکراری: #22 #23 #31 #35 #36 #39 #40 #43 #44 #47 #48 #51 #52 #55 #56 #59 #60 #63 #64 #67 #68

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.17 ms
checking permissions	0.13 ms
Opening tables	0.15 ms
After opening tables	0.14 ms
System lock	0.13 ms
table lock	0.17 ms
init	0.14 ms
Optimizing	0.12 ms
Statistics	0.13 ms
Preparing	0.14 ms
Executing	0.15 ms
Sending data	0.15 ms
End of update loop	0.15 ms
Query end	0.11 ms
Commit	0.12 ms
Query end	0.09 ms
closing tables	0.09 ms
Unlocking tables	0.13 ms
closing tables	0.15 ms
Query end	0.15 ms
Starting cleanup	0.15 ms
Freeing items	0.13 ms
Updating status	0.12 ms
Reset for next command	0.11 ms

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

#	فراخوانده	فایل و شماره خط
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1702
17	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:46
16	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:213
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

پرس و جوی تکراری: #22 #23 #30 #35 #36 #39 #40 #43 #44 #47 #48 #51 #52 #55 #56 #59 #60 #63 #64 #67 #68

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.16 ms
checking permissions	0.13 ms
Opening tables	0.18 ms
After opening tables	0.14 ms
System lock	0.13 ms
table lock	0.14 ms
init	0.11 ms
Optimizing	0.11 ms
Statistics	0.13 ms
Preparing	0.09 ms
Executing	0.15 ms
Sending data	0.16 ms
End of update loop	0.12 ms
Query end	0.12 ms
Commit	0.10 ms
Query end	0.10 ms
closing tables	0.11 ms
Unlocking tables	0.12 ms
closing tables	0.15 ms
Query end	0.09 ms
Starting cleanup	0.13 ms
Freeing items	0.10 ms
Updating status	0.11 ms
Reset for next command	0.10 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1702
16	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:214
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

SELECT COUNT(*) 
  FROM dly1p_k2_comments 
  WHERE itemID=872 
  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.13 ms
checking permissions	0.16 ms
Opening tables	0.17 ms
After opening tables	0.13 ms
System lock	0.13 ms
table lock	0.12 ms
init	0.14 ms
Optimizing	0.16 ms
Statistics	0.15 ms
Preparing	0.14 ms
Executing	0.14 ms
Sending data	0.14 ms
End of update loop	0.12 ms
Query end	0.12 ms
Commit	0.10 ms
Query end	0.12 ms
closing tables	0.23 ms
Unlocking tables	0.19 ms
closing tables	0.15 ms
Query end	0.11 ms
Starting cleanup	0.12 ms
Freeing items	0.13 ms
Updating status	0.12 ms
Reset for next command	0.14 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1489
16	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:227
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

زمان پرس و جو: 3.54 ms پس از آخرین پرس و جو: 3.94 ms حافظه پرس و جو: 0.011 MB حافظه قبل از پرس و جوی: 12.697 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.itemlist' 
  AND (fc.category_id IS NULL OR fc.category_id IN (21,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.17 ms
checking permissions	0.08 ms
Opening tables	0.14 ms
After opening tables	0.08 ms
System lock	0.08 ms
table lock	0.08 ms
init	0.11 ms
Optimizing	0.11 ms
Statistics	0.15 ms
Preparing	0.16 ms
Creating tmp table	0.12 ms
Sorting result	0.08 ms
Executing	0.08 ms
Sending data	0.21 ms
Creating sort index	0.11 ms
Removing tmp table	0.15 ms
Creating sort index	0.11 ms
End of update loop	0.12 ms
Query end	0.13 ms
Commit	0.15 ms
Query end	0.10 ms
closing tables	0.14 ms
Unlocking tables	0.10 ms
closing tables	0.12 ms
Query end	0.13 ms
Starting cleanup	0.17 ms
Freeing items	0.13 ms
Updating status	0.15 ms
Reset for next command	0.11 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/itemlist/view.html.php:741
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

زمان پرس و جو: 3.66 ms پس از آخرین پرس و جو: 2.70 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.074 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 = 871
            
  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.16 ms
checking permissions	0.12 ms
Opening tables	0.21 ms
After opening tables	0.16 ms
System lock	0.10 ms
table lock	0.11 ms
init	0.12 ms
Optimizing	0.11 ms
Statistics	0.14 ms
Preparing	0.09 ms
Creating tmp table	0.10 ms
Sorting result	0.09 ms
Executing	0.11 ms
Sending data	0.18 ms
Creating sort index	0.16 ms
Removing tmp table	0.14 ms
Creating sort index	0.11 ms
End of update loop	0.14 ms
Query end	0.12 ms
Commit	0.12 ms
Query end	0.12 ms
closing tables	0.13 ms
Unlocking tables	0.12 ms
closing tables	0.13 ms
Query end	0.13 ms
Starting cleanup	0.13 ms
Freeing items	0.14 ms
Updating status	0.12 ms
Reset for next command	0.09 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1222
16	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:111
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

پرس و جوی تکراری: #22 #23 #30 #31 #36 #39 #40 #43 #44 #47 #48 #51 #52 #55 #56 #59 #60 #63 #64 #67 #68

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.18 ms
checking permissions	0.14 ms
Opening tables	0.14 ms
After opening tables	0.11 ms
System lock	0.10 ms
table lock	0.13 ms
init	0.11 ms
Optimizing	0.08 ms
Statistics	0.10 ms
Preparing	0.09 ms
Executing	0.09 ms
Sending data	0.07 ms
End of update loop	0.04 ms
Query end	0.08 ms
Commit	0.10 ms
Query end	0.12 ms
closing tables	0.11 ms
Unlocking tables	0.10 ms
closing tables	0.09 ms
Query end	0.11 ms
Starting cleanup	0.11 ms
Freeing items	0.11 ms
Updating status	0.12 ms
Reset for next command	0.13 ms

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

#	فراخوانده	فایل و شماره خط
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1702
17	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:46
16	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:213
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

پرس و جوی تکراری: #22 #23 #30 #31 #35 #39 #40 #43 #44 #47 #48 #51 #52 #55 #56 #59 #60 #63 #64 #67 #68

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.17 ms
checking permissions	0.12 ms
Opening tables	0.14 ms
After opening tables	0.13 ms
System lock	0.11 ms
table lock	0.12 ms
init	0.12 ms
Optimizing	0.10 ms
Statistics	0.14 ms
Preparing	0.15 ms
Executing	0.16 ms
Sending data	0.14 ms
End of update loop	0.12 ms
Query end	0.12 ms
Commit	0.12 ms
Query end	0.07 ms
closing tables	0.13 ms
Unlocking tables	0.12 ms
closing tables	0.15 ms
Query end	0.08 ms
Starting cleanup	0.11 ms
Freeing items	0.10 ms
Updating status	0.09 ms
Reset for next command	0.10 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1702
16	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:214
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

SELECT COUNT(*) 
  FROM dly1p_k2_comments 
  WHERE itemID=871 
  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.12 ms
checking permissions	0.10 ms
Opening tables	0.10 ms
After opening tables	0.14 ms
System lock	0.13 ms
table lock	0.13 ms
init	0.10 ms
Optimizing	0.12 ms
Statistics	0.15 ms
Preparing	0.16 ms
Executing	0.15 ms
Sending data	0.14 ms
End of update loop	0.13 ms
Query end	0.13 ms
Commit	0.10 ms
Query end	0.12 ms
closing tables	0.14 ms
Unlocking tables	0.11 ms
closing tables	0.11 ms
Query end	0.11 ms
Starting cleanup	0.14 ms
Freeing items	0.17 ms
Updating status	0.15 ms
Reset for next command	0.11 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1489
16	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:227
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

زمان پرس و جو: 3.27 ms پس از آخرین پرس و جو: 1.95 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.143 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 = 870
            
  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.12 ms
checking permissions	0.12 ms
Opening tables	0.11 ms
After opening tables	0.13 ms
System lock	0.13 ms
table lock	0.13 ms
init	0.11 ms
Optimizing	0.10 ms
Statistics	0.14 ms
Preparing	0.13 ms
Creating tmp table	0.11 ms
Sorting result	0.14 ms
Executing	0.14 ms
Sending data	0.19 ms
Creating sort index	0.12 ms
Removing tmp table	0.11 ms
Creating sort index	0.09 ms
End of update loop	0.13 ms
Query end	0.11 ms
Commit	0.13 ms
Query end	0.09 ms
closing tables	0.13 ms
Unlocking tables	0.08 ms
closing tables	0.11 ms
Query end	0.09 ms
Starting cleanup	0.07 ms
Freeing items	0.11 ms
Updating status	0.06 ms
Reset for next command	0.14 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1222
16	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:111
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

پرس و جوی تکراری: #22 #23 #30 #31 #35 #36 #40 #43 #44 #47 #48 #51 #52 #55 #56 #59 #60 #63 #64 #67 #68

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.12 ms
checking permissions	0.12 ms
Opening tables	0.11 ms
After opening tables	0.11 ms
System lock	0.08 ms
table lock	0.12 ms
init	0.10 ms
Optimizing	0.08 ms
Statistics	0.15 ms
Preparing	0.11 ms
Executing	0.15 ms
Sending data	0.15 ms
End of update loop	0.13 ms
Query end	0.13 ms
Commit	0.15 ms
Query end	0.16 ms
closing tables	0.15 ms
Unlocking tables	0.12 ms
closing tables	0.11 ms
Query end	0.11 ms
Starting cleanup	0.12 ms
Freeing items	0.13 ms
Updating status	0.17 ms
Reset for next command	0.15 ms

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

#	فراخوانده	فایل و شماره خط
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1702
17	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:46
16	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:213
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

پرس و جوی تکراری: #22 #23 #30 #31 #35 #36 #39 #43 #44 #47 #48 #51 #52 #55 #56 #59 #60 #63 #64 #67 #68

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.11 ms
checking permissions	0.12 ms
Opening tables	0.12 ms
After opening tables	0.10 ms
System lock	0.14 ms
table lock	0.15 ms
init	0.14 ms
Optimizing	0.14 ms
Statistics	0.15 ms
Preparing	0.12 ms
Executing	0.10 ms
Sending data	0.15 ms
End of update loop	0.17 ms
Query end	0.14 ms
Commit	0.16 ms
Query end	0.13 ms
closing tables	0.14 ms
Unlocking tables	0.14 ms
closing tables	0.12 ms
Query end	0.12 ms
Starting cleanup	0.16 ms
Freeing items	0.14 ms
Updating status	0.12 ms
Reset for next command	0.12 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1702
16	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:214
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

SELECT COUNT(*) 
  FROM dly1p_k2_comments 
  WHERE itemID=870 
  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.11 ms
checking permissions	0.14 ms
Opening tables	0.14 ms
After opening tables	0.17 ms
System lock	0.11 ms
table lock	0.16 ms
init	0.14 ms
Optimizing	0.12 ms
Statistics	0.17 ms
Preparing	0.13 ms
Executing	0.17 ms
Sending data	0.16 ms
End of update loop	0.13 ms
Query end	0.10 ms
Commit	0.10 ms
Query end	0.09 ms
closing tables	0.12 ms
Unlocking tables	0.09 ms
closing tables	0.16 ms
Query end	0.11 ms
Starting cleanup	0.10 ms
Freeing items	0.13 ms
Updating status	0.14 ms
Reset for next command	0.12 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1489
16	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:227
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

زمان پرس و جو: 3.18 ms پس از آخرین پرس و جو: 1.34 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.212 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 = 869
            
  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.17 ms
checking permissions	0.13 ms
Opening tables	0.16 ms
After opening tables	0.14 ms
System lock	0.14 ms
table lock	0.10 ms
init	0.11 ms
Optimizing	0.12 ms
Statistics	0.13 ms
Preparing	0.12 ms
Creating tmp table	0.11 ms
Sorting result	0.08 ms
Executing	0.09 ms
Sending data	0.17 ms
Creating sort index	0.11 ms
Removing tmp table	0.11 ms
Creating sort index	0.14 ms
End of update loop	0.10 ms
Query end	0.10 ms
Commit	0.06 ms
Query end	0.11 ms
closing tables	0.08 ms
Unlocking tables	0.08 ms
closing tables	0.08 ms
Query end	0.10 ms
Starting cleanup	0.06 ms
Freeing items	0.10 ms
Updating status	0.11 ms
Reset for next command	0.06 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1222
16	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:111
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

پرس و جوی تکراری: #22 #23 #30 #31 #35 #36 #39 #40 #44 #47 #48 #51 #52 #55 #56 #59 #60 #63 #64 #67 #68

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.11 ms
checking permissions	0.05 ms
Opening tables	0.10 ms
After opening tables	0.12 ms
System lock	0.11 ms
table lock	0.12 ms
init	0.09 ms
Optimizing	0.07 ms
Statistics	0.09 ms
Preparing	0.12 ms
Executing	0.11 ms
Sending data	0.09 ms
End of update loop	0.09 ms
Query end	0.11 ms
Commit	0.10 ms
Query end	0.13 ms
closing tables	0.11 ms
Unlocking tables	0.11 ms
closing tables	0.12 ms
Query end	0.10 ms
Starting cleanup	0.09 ms
Freeing items	0.11 ms
Updating status	0.12 ms
Reset for next command	0.10 ms

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

#	فراخوانده	فایل و شماره خط
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1702
17	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:46
16	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:213
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

پرس و جوی تکراری: #22 #23 #30 #31 #35 #36 #39 #40 #43 #47 #48 #51 #52 #55 #56 #59 #60 #63 #64 #67 #68

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.14 ms
checking permissions	0.12 ms
Opening tables	0.14 ms
After opening tables	0.11 ms
System lock	0.09 ms
table lock	0.10 ms
init	0.18 ms
Optimizing	0.15 ms
Statistics	0.12 ms
Preparing	0.13 ms
Executing	0.09 ms
Sending data	0.09 ms
End of update loop	0.14 ms
Query end	0.11 ms
Commit	0.13 ms
Query end	0.10 ms
closing tables	0.14 ms
Unlocking tables	0.12 ms
closing tables	0.10 ms
Query end	0.08 ms
Starting cleanup	0.09 ms
Freeing items	0.09 ms
Updating status	0.13 ms
Reset for next command	0.10 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1702
16	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:214
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

SELECT COUNT(*) 
  FROM dly1p_k2_comments 
  WHERE itemID=869 
  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.13 ms
checking permissions	0.08 ms
Opening tables	0.09 ms
After opening tables	0.10 ms
System lock	0.09 ms
table lock	0.07 ms
init	0.07 ms
Optimizing	0.09 ms
Statistics	0.09 ms
Preparing	0.11 ms
Executing	0.09 ms
Sending data	0.12 ms
End of update loop	0.12 ms
Query end	0.13 ms
Commit	0.11 ms
Query end	0.11 ms
closing tables	0.12 ms
Unlocking tables	0.13 ms
closing tables	0.13 ms
Query end	0.17 ms
Starting cleanup	0.15 ms
Freeing items	0.16 ms
Updating status	0.21 ms
Reset for next command	0.18 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1489
16	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:227
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

زمان پرس و جو: 4.07 ms پس از آخرین پرس و جو: 1.81 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.281 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 = 868
            
  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.21 ms
checking permissions	0.17 ms
Opening tables	0.16 ms
After opening tables	0.17 ms
System lock	0.15 ms
table lock	0.13 ms
init	0.14 ms
Optimizing	0.11 ms
Statistics	0.17 ms
Preparing	0.15 ms
Creating tmp table	0.16 ms
Sorting result	0.13 ms
Executing	0.11 ms
Sending data	0.24 ms
Creating sort index	0.11 ms
Removing tmp table	0.17 ms
Creating sort index	0.14 ms
End of update loop	0.12 ms
Query end	0.12 ms
Commit	0.11 ms
Query end	0.10 ms
closing tables	0.10 ms
Unlocking tables	0.09 ms
closing tables	0.16 ms
Query end	0.17 ms
Starting cleanup	0.14 ms
Freeing items	0.14 ms
Updating status	0.12 ms
Reset for next command	0.10 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1222
16	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:111
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

پرس و جوی تکراری: #22 #23 #30 #31 #35 #36 #39 #40 #43 #44 #48 #51 #52 #55 #56 #59 #60 #63 #64 #67 #68

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.13 ms
checking permissions	0.10 ms
Opening tables	0.12 ms
After opening tables	0.05 ms
System lock	0.07 ms
table lock	0.10 ms
init	0.13 ms
Optimizing	0.12 ms
Statistics	0.10 ms
Preparing	0.10 ms
Executing	0.13 ms
Sending data	0.09 ms
End of update loop	0.15 ms
Query end	0.07 ms
Commit	0.09 ms
Query end	0.08 ms
closing tables	0.06 ms
Unlocking tables	0.12 ms
closing tables	0.10 ms
Query end	0.08 ms
Starting cleanup	0.14 ms
Freeing items	0.14 ms
Updating status	0.19 ms
Reset for next command	0.15 ms

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

#	فراخوانده	فایل و شماره خط
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1702
17	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:46
16	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:213
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

پرس و جوی تکراری: #22 #23 #30 #31 #35 #36 #39 #40 #43 #44 #47 #51 #52 #55 #56 #59 #60 #63 #64 #67 #68

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.17 ms
checking permissions	0.12 ms
Opening tables	0.17 ms
After opening tables	0.11 ms
System lock	0.14 ms
table lock	0.15 ms
init	0.14 ms
Optimizing	0.13 ms
Statistics	0.15 ms
Preparing	0.16 ms
Executing	0.13 ms
Sending data	0.14 ms
End of update loop	0.14 ms
Query end	0.11 ms
Commit	0.11 ms
Query end	0.09 ms
closing tables	0.10 ms
Unlocking tables	0.09 ms
closing tables	0.17 ms
Query end	0.14 ms
Starting cleanup	0.13 ms
Freeing items	0.16 ms
Updating status	0.11 ms
Reset for next command	0.11 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1702
16	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:214
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

SELECT COUNT(*) 
  FROM dly1p_k2_comments 
  WHERE itemID=868 
  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.20 ms
checking permissions	0.16 ms
Opening tables	0.14 ms
After opening tables	0.13 ms
System lock	0.15 ms
table lock	0.12 ms
init	0.19 ms
Optimizing	0.12 ms
Statistics	0.18 ms
Preparing	0.11 ms
Executing	0.14 ms
Sending data	0.11 ms
End of update loop	0.10 ms
Query end	0.10 ms
Commit	0.13 ms
Query end	0.11 ms
closing tables	0.08 ms
Unlocking tables	0.11 ms
closing tables	0.11 ms
Query end	0.08 ms
Starting cleanup	0.08 ms
Freeing items	0.07 ms
Updating status	0.09 ms
Reset for next command	0.11 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1489
16	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:227
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

زمان پرس و جو: 4.02 ms پس از آخرین پرس و جو: 1.71 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.350 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 = 867
            
  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.15 ms
checking permissions	0.12 ms
Opening tables	0.11 ms
After opening tables	0.15 ms
System lock	0.12 ms
table lock	0.16 ms
init	0.12 ms
Optimizing	0.13 ms
Statistics	0.15 ms
Preparing	0.16 ms
Creating tmp table	0.18 ms
Sorting result	0.11 ms
Executing	0.15 ms
Sending data	0.29 ms
Creating sort index	0.13 ms
Removing tmp table	0.18 ms
Creating sort index	0.14 ms
End of update loop	0.14 ms
Query end	0.16 ms
Commit	0.14 ms
Query end	0.12 ms
closing tables	0.07 ms
Unlocking tables	0.13 ms
closing tables	0.13 ms
Query end	0.14 ms
Starting cleanup	0.12 ms
Freeing items	0.13 ms
Updating status	0.14 ms
Reset for next command	0.12 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1222
16	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:111
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

پرس و جوی تکراری: #22 #23 #30 #31 #35 #36 #39 #40 #43 #44 #47 #48 #52 #55 #56 #59 #60 #63 #64 #67 #68

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.14 ms
checking permissions	0.16 ms
Opening tables	0.16 ms
After opening tables	0.14 ms
System lock	0.14 ms
table lock	0.11 ms
init	0.12 ms
Optimizing	0.09 ms
Statistics	0.13 ms
Preparing	0.08 ms
Executing	0.07 ms
Sending data	0.13 ms
End of update loop	0.11 ms
Query end	0.13 ms
Commit	0.09 ms
Query end	0.11 ms
closing tables	0.11 ms
Unlocking tables	0.14 ms
closing tables	0.12 ms
Query end	0.13 ms
Starting cleanup	0.09 ms
Freeing items	0.12 ms
Updating status	0.15 ms
Reset for next command	0.11 ms

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

#	فراخوانده	فایل و شماره خط
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1702
17	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:46
16	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:213
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

پرس و جوی تکراری: #22 #23 #30 #31 #35 #36 #39 #40 #43 #44 #47 #48 #51 #55 #56 #59 #60 #63 #64 #67 #68

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.14 ms
checking permissions	0.20 ms
Opening tables	0.18 ms
After opening tables	0.12 ms
System lock	0.17 ms
table lock	0.11 ms
init	0.14 ms
Optimizing	0.14 ms
Statistics	0.17 ms
Preparing	0.17 ms
Executing	0.10 ms
Sending data	0.14 ms
End of update loop	0.12 ms
Query end	0.10 ms
Commit	0.12 ms
Query end	0.10 ms
closing tables	0.15 ms
Unlocking tables	0.10 ms
closing tables	0.13 ms
Query end	0.10 ms
Starting cleanup	0.15 ms
Freeing items	0.15 ms
Updating status	0.14 ms
Reset for next command	0.14 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1702
16	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:214
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

SELECT COUNT(*) 
  FROM dly1p_k2_comments 
  WHERE itemID=867 
  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.19 ms
checking permissions	0.13 ms
Opening tables	0.17 ms
After opening tables	0.12 ms
System lock	0.11 ms
table lock	0.14 ms
init	0.15 ms
Optimizing	0.19 ms
Statistics	0.16 ms
Preparing	0.13 ms
Executing	0.13 ms
Sending data	0.16 ms
End of update loop	0.15 ms
Query end	0.20 ms
Commit	0.11 ms
Query end	0.11 ms
closing tables	0.09 ms
Unlocking tables	0.09 ms
closing tables	0.12 ms
Query end	0.08 ms
Starting cleanup	0.12 ms
Freeing items	0.10 ms
Updating status	0.18 ms
Reset for next command	0.14 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1489
16	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:227
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

زمان پرس و جو: 3.43 ms پس از آخرین پرس و جو: 1.73 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.419 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 = 866
            
  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.19 ms
checking permissions	0.17 ms
Opening tables	0.16 ms
After opening tables	0.12 ms
System lock	0.13 ms
table lock	0.18 ms
init	0.14 ms
Optimizing	0.14 ms
Statistics	0.16 ms
Preparing	0.12 ms
Creating tmp table	0.11 ms
Sorting result	0.10 ms
Executing	0.11 ms
Sending data	0.23 ms
Creating sort index	0.11 ms
Removing tmp table	0.13 ms
Creating sort index	0.09 ms
End of update loop	0.11 ms
Query end	0.07 ms
Commit	0.12 ms
Query end	0.07 ms
closing tables	0.07 ms
Unlocking tables	0.09 ms
closing tables	0.08 ms
Query end	0.09 ms
Starting cleanup	0.12 ms
Freeing items	0.07 ms
Updating status	0.10 ms
Reset for next command	0.12 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1222
16	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:111
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

پرس و جوی تکراری: #22 #23 #30 #31 #35 #36 #39 #40 #43 #44 #47 #48 #51 #52 #56 #59 #60 #63 #64 #67 #68

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.11 ms
checking permissions	0.09 ms
Opening tables	0.14 ms
After opening tables	0.07 ms
System lock	0.11 ms
table lock	0.08 ms
init	0.07 ms
Optimizing	0.06 ms
Statistics	0.10 ms
Preparing	0.08 ms
Executing	0.09 ms
Sending data	0.09 ms
End of update loop	0.07 ms
Query end	0.11 ms
Commit	0.09 ms
Query end	0.12 ms
closing tables	0.10 ms
Unlocking tables	0.09 ms
closing tables	0.12 ms
Query end	0.10 ms
Starting cleanup	0.09 ms
Freeing items	0.09 ms
Updating status	0.11 ms
Reset for next command	0.13 ms

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

#	فراخوانده	فایل و شماره خط
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1702
17	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:46
16	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:213
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

پرس و جوی تکراری: #22 #23 #30 #31 #35 #36 #39 #40 #43 #44 #47 #48 #51 #52 #55 #59 #60 #63 #64 #67 #68

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.13 ms
checking permissions	0.08 ms
Opening tables	0.11 ms
After opening tables	0.09 ms
System lock	0.10 ms
table lock	0.09 ms
init	0.07 ms
Optimizing	0.09 ms
Statistics	0.14 ms
Preparing	0.14 ms
Executing	0.07 ms
Sending data	0.13 ms
End of update loop	0.09 ms
Query end	0.08 ms
Commit	0.08 ms
Query end	0.06 ms
closing tables	0.06 ms
Unlocking tables	0.08 ms
closing tables	0.06 ms
Query end	0.11 ms
Starting cleanup	0.08 ms
Freeing items	0.09 ms
Updating status	0.08 ms
Reset for next command	0.10 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1702
16	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:214
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

SELECT COUNT(*) 
  FROM dly1p_k2_comments 
  WHERE itemID=866 
  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.08 ms
checking permissions	0.08 ms
Opening tables	0.07 ms
After opening tables	0.09 ms
System lock	0.09 ms
table lock	0.10 ms
init	0.11 ms
Optimizing	0.15 ms
Statistics	0.15 ms
Preparing	0.12 ms
Executing	0.10 ms
Sending data	0.11 ms
End of update loop	0.10 ms
Query end	0.09 ms
Commit	0.10 ms
Query end	0.11 ms
closing tables	0.15 ms
Unlocking tables	0.11 ms
closing tables	0.09 ms
Query end	0.07 ms
Starting cleanup	0.06 ms
Freeing items	0.06 ms
Updating status	0.09 ms
Reset for next command	0.10 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1489
16	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:227
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

زمان پرس و جو: 2.94 ms پس از آخرین پرس و جو: 2.00 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.488 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 = 865
            
  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.10 ms
checking permissions	0.10 ms
Opening tables	0.11 ms
After opening tables	0.12 ms
System lock	0.09 ms
table lock	0.09 ms
init	0.10 ms
Optimizing	0.10 ms
Statistics	0.12 ms
Preparing	0.08 ms
Creating tmp table	0.10 ms
Sorting result	0.11 ms
Executing	0.08 ms
Sending data	0.26 ms
Creating sort index	0.11 ms
Removing tmp table	0.12 ms
Creating sort index	0.09 ms
End of update loop	0.09 ms
Query end	0.08 ms
Commit	0.11 ms
Query end	0.10 ms
closing tables	0.13 ms
Unlocking tables	0.11 ms
closing tables	0.07 ms
Query end	0.08 ms
Starting cleanup	0.07 ms
Freeing items	0.05 ms
Updating status	0.08 ms
Reset for next command	0.06 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1222
16	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:111
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

پرس و جوی تکراری: #22 #23 #30 #31 #35 #36 #39 #40 #43 #44 #47 #48 #51 #52 #55 #56 #60 #63 #64 #67 #68

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.09 ms
checking permissions	0.09 ms
Opening tables	0.10 ms
After opening tables	0.11 ms
System lock	0.07 ms
table lock	0.09 ms
init	0.12 ms
Optimizing	0.10 ms
Statistics	0.12 ms
Preparing	0.09 ms
Executing	0.09 ms
Sending data	0.11 ms
End of update loop	0.07 ms
Query end	0.12 ms
Commit	0.10 ms
Query end	0.06 ms
closing tables	0.08 ms
Unlocking tables	0.07 ms
closing tables	0.07 ms
Query end	0.10 ms
Starting cleanup	0.07 ms
Freeing items	0.08 ms
Updating status	0.13 ms
Reset for next command	0.10 ms

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

#	فراخوانده	فایل و شماره خط
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1702
17	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:46
16	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:213
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

پرس و جوی تکراری: #22 #23 #30 #31 #35 #36 #39 #40 #43 #44 #47 #48 #51 #52 #55 #56 #59 #63 #64 #67 #68

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.11 ms
checking permissions	0.09 ms
Opening tables	0.11 ms
After opening tables	0.10 ms
System lock	0.07 ms
table lock	0.09 ms
init	0.08 ms
Optimizing	0.11 ms
Statistics	0.10 ms
Preparing	0.13 ms
Executing	0.06 ms
Sending data	0.12 ms
End of update loop	0.09 ms
Query end	0.09 ms
Commit	0.05 ms
Query end	0.07 ms
closing tables	0.06 ms
Unlocking tables	0.09 ms
closing tables	0.10 ms
Query end	0.10 ms
Starting cleanup	0.08 ms
Freeing items	0.11 ms
Updating status	0.08 ms
Reset for next command	0.09 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1702
16	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:214
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

SELECT COUNT(*) 
  FROM dly1p_k2_comments 
  WHERE itemID=865 
  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.09 ms
checking permissions	0.07 ms
Opening tables	0.07 ms
After opening tables	0.07 ms
System lock	0.05 ms
table lock	0.05 ms
init	0.12 ms
Optimizing	0.10 ms
Statistics	0.12 ms
Preparing	0.09 ms
Executing	0.10 ms
Sending data	0.07 ms
End of update loop	0.08 ms
Query end	0.08 ms
Commit	0.07 ms
Query end	0.09 ms
closing tables	0.07 ms
Unlocking tables	0.05 ms
closing tables	0.11 ms
Query end	0.11 ms
Starting cleanup	0.18 ms
Freeing items	0.14 ms
Updating status	0.08 ms
Reset for next command	0.06 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1489
16	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:227
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

زمان پرس و جو: 2.69 ms پس از آخرین پرس و جو: 1.34 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.557 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 = 864
            
  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.12 ms
checking permissions	0.09 ms
Opening tables	0.10 ms
After opening tables	0.09 ms
System lock	0.08 ms
table lock	0.09 ms
init	0.09 ms
Optimizing	0.09 ms
Statistics	0.12 ms
Preparing	0.11 ms
Creating tmp table	0.12 ms
Sorting result	0.09 ms
Executing	0.11 ms
Sending data	0.20 ms
Creating sort index	0.10 ms
Removing tmp table	0.11 ms
Creating sort index	0.07 ms
End of update loop	0.07 ms
Query end	0.06 ms
Commit	0.05 ms
Query end	0.07 ms
closing tables	0.10 ms
Unlocking tables	0.07 ms
closing tables	0.10 ms
Query end	0.08 ms
Starting cleanup	0.08 ms
Freeing items	0.08 ms
Updating status	0.08 ms
Reset for next command	0.05 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1222
16	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:111
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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.25 ms پس از آخرین پرس و جو: 0.11 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.568 MB سطرهای بازگشتی: 0

پرس و جوی تکراری: #22 #23 #30 #31 #35 #36 #39 #40 #43 #44 #47 #48 #51 #52 #55 #56 #59 #60 #64 #67 #68

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

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

#	فراخوانده	فایل و شماره خط
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1702
17	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:46
16	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:213
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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.31 ms پس از آخرین پرس و جو: 0.03 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.576 MB سطرهای بازگشتی: 0

پرس و جوی تکراری: #22 #23 #30 #31 #35 #36 #39 #40 #43 #44 #47 #48 #51 #52 #55 #56 #59 #60 #63 #67 #68

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

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1702
16	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:214
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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.51 ms پس از آخرین پرس و جو: 0.03 ms حافظه پرس و جو: 0.014 MB حافظه قبل از پرس و جوی: 13.594 MB سطرهای بازگشتی: 1

SELECT COUNT(*) 
  FROM dly1p_k2_comments 
  WHERE itemID=864 
  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.06 ms
checking permissions	0.05 ms
Opening tables	0.06 ms
After opening tables	0.06 ms
System lock	0.05 ms
table lock	0.05 ms
init	0.04 ms
Optimizing	0.07 ms
Statistics	0.06 ms
Preparing	0.07 ms
Executing	0.05 ms
Sending data	0.05 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.05 ms
Query end	0.10 ms
closing tables	0.06 ms
Unlocking tables	0.08 ms
closing tables	0.08 ms
Query end	0.08 ms
Starting cleanup	0.07 ms
Freeing items	0.07 ms
Updating status	0.08 ms
Reset for next command	0.07 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1489
16	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:227
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

زمان پرس و جو: 2.94 ms پس از آخرین پرس و جو: 1.30 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.641 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 = 863
            
  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.09 ms
checking permissions	0.07 ms
Opening tables	0.07 ms
After opening tables	0.06 ms
System lock	0.08 ms
table lock	0.09 ms
init	0.08 ms
Optimizing	0.07 ms
Statistics	0.11 ms
Preparing	0.09 ms
Creating tmp table	0.07 ms
Sorting result	0.06 ms
Executing	0.09 ms
Sending data	0.24 ms
Creating sort index	0.13 ms
Removing tmp table	0.15 ms
Creating sort index	0.10 ms
End of update loop	0.08 ms
Query end	0.06 ms
Commit	0.12 ms
Query end	0.11 ms
closing tables	0.17 ms
Unlocking tables	0.15 ms
closing tables	0.11 ms
Query end	0.14 ms
Starting cleanup	0.11 ms
Freeing items	0.09 ms
Updating status	0.10 ms
Reset for next command	0.09 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1222
16	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:111
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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 برای لینک به فایل ها]

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

پرس و جوی تکراری: #22 #23 #30 #31 #35 #36 #39 #40 #43 #44 #47 #48 #51 #52 #55 #56 #59 #60 #63 #64 #68

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.13 ms
checking permissions	0.10 ms
Opening tables	0.10 ms
After opening tables	0.08 ms
System lock	0.08 ms
table lock	0.10 ms
init	0.11 ms
Optimizing	0.11 ms
Statistics	0.09 ms
Preparing	0.10 ms
Executing	0.08 ms
Sending data	0.09 ms
End of update loop	0.06 ms
Query end	0.07 ms
Commit	0.06 ms
Query end	0.05 ms
closing tables	0.05 ms
Unlocking tables	0.07 ms
closing tables	0.10 ms
Query end	0.11 ms
Starting cleanup	0.09 ms
Freeing items	0.14 ms
Updating status	0.11 ms
Reset for next command	0.09 ms

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

#	فراخوانده	فایل و شماره خط
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1702
17	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:46
16	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:213
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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.68 ms پس از آخرین پرس و جو: 0.04 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.660 MB سطرهای بازگشتی: 0

پرس و جوی تکراری: #22 #23 #30 #31 #35 #36 #39 #40 #43 #44 #47 #48 #51 #52 #55 #56 #59 #60 #63 #64 #67

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

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1702
16	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:214
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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.52 ms پس از آخرین پرس و جو: 0.05 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 13.669 MB سطرهای بازگشتی: 1

SELECT COUNT(*) 
  FROM dly1p_k2_comments 
  WHERE itemID=863 
  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.13 ms
checking permissions	0.06 ms
Opening tables	0.09 ms
After opening tables	0.06 ms
System lock	0.07 ms
table lock	0.05 ms
init	0.07 ms
Optimizing	0.07 ms
Statistics	0.08 ms
Preparing	0.07 ms
Executing	0.07 ms
Sending data	0.07 ms
End of update loop	0.05 ms
Query end	0.05 ms
Commit	0.07 ms
Query end	0.07 ms
closing tables	0.07 ms
Unlocking tables	0.04 ms
closing tables	0.05 ms
Query end	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.06 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1489
16	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:227
15	K2ModelItem->prepareItem()	به نظر می رسد خط زیر فراخونده شده باشد.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:732
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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.37 ms پس از آخرین پرس و جو: 0.96 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 13.639 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.03 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.09 ms
Optimizing	0.05 ms
Statistics	0.11 ms
Preparing	0.08 ms
Executing	0.05 ms
Sending data	0.09 ms
End of update loop	0.06 ms
Query end	0.07 ms
Commit	0.06 ms
Query end	0.05 ms
closing tables	0.06 ms
Unlocking tables	0.08 ms
closing tables	0.05 ms
Query end	0.06 ms
Starting cleanup	0.05 ms
Freeing items	0.04 ms
Updating status	0.06 ms
Reset for next command	0.04 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/itemlist/view.html.php:789
11	K2ViewItemlist->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/itemlist.php:50
8	K2ControllerItemlist->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.80 ms پس از آخرین پرس و جو: 3.04 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 13.839 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.13 ms
checking permissions	0.06 ms
Opening tables	0.10 ms
After opening tables	0.08 ms
System lock	0.09 ms
table lock	0.05 ms
init	0.07 ms
Optimizing	0.11 ms
Statistics	0.12 ms
Preparing	0.12 ms
Executing	0.10 ms
Sending data	0.23 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.04 ms
closing tables	0.06 ms
Query end	0.04 ms
Starting cleanup	0.08 ms
Freeing items	0.07 ms
Updating status	0.07 ms
Reset for next command	0.08 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 برای لینک به فایل ها]

زمان پرس و جو: 1.63 ms پس از آخرین پرس و جو: 11.86 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 15.088 MB سطرهای بازگشتی: 9

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

  FROM dly1p_modules AS m

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

  LEFT JOIN dly1p_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-06-08 03:41:53') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-08 03:41:53') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 730 OR mm.menuid <= 0) 
  AND m.language IN ('fa-IR','*')

  ORDER BY m.position, m.ordering

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	PRIMARY,published,newsfeeds,idx_language	کلید شاخصی برای استفاده نیست	NULL	NULL	46	Using where; با استفاده از مرتب سازی فایل
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	gciran_ndb.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	gciran_ndb.m.module,const	1	Using index condition; Using where

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	به نظر می رسد خط زیر فراخونده شده باشد.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
14	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
11	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helix3/core/helix3.php:512
10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:459
9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:268
8	Helix3::generatelayout()	JROOT/templates/shaper_tixon/index.php:162
7	require JROOT/templates/shaper_tixon/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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 برای لینک به فایل ها]

زمان پرس و جو: 1.46 ms پس از آخرین پرس و جو: 217.63 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 16.641 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.06 ms
checking permissions	0.03 ms
Opening tables	0.11 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.04 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.03 ms
Executing	0.05 ms
Sending data	0.16 ms
End of update loop	0.05 ms
Query end	0.03 ms
Commit	0.02 ms
Query end	0.06 ms
closing tables	0.12 ms
Unlocking tables	0.07 ms
closing tables	0.07 ms
Query end	0.05 ms
Starting cleanup	0.08 ms
Freeing items	0.09 ms
Updating status	0.07 ms
Reset for next command	0.06 ms

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

#	فراخوانده	فایل و شماره خط
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:464
15	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
14	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:434
13	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:803
12	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:21
11	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/modules/mod_acymailing/mod_acymailing.php:13
10	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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 برای لینک به فایل ها]

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

SELECT * 
  FROM dly1p_acymailing_list 
  WHERE type = 'list'  
  ORDER BY ordering ASC

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dly1p_acymailing_list	ref	typeorderingindex,typeuseridindex	typeorderingindex	1	const	1	Using index condition; Using where

مشخصات

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.04 ms
table lock	0.17 ms
init	0.08 ms
Optimizing	0.04 ms
Statistics	0.14 ms
Preparing	0.04 ms
Sorting result	0.04 ms
Executing	0.05 ms
Sending data	0.06 ms
End of update loop	0.05 ms
Query end	0.03 ms
Commit	0.06 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.03 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.02 ms

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

#	فراخوانده	فایل و شماره خط
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:464
12	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/list.php:30
11	listClass->getLists()	JROOT/modules/mod_acymailing/mod_acymailing.php:105
10	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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 برای لینک به فایل ها]

زمان پرس و جو: 12.41 ms پس از آخرین پرس و جو: 1.83 ms حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 17.277 MB سطرهای بازگشتی: 3

/* Frontend / mod_k2_content */ SELECT i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams 
  FROM dly1p_k2_items AS i 
  INNER JOIN dly1p_k2_categories AS c 
  ON c.id = i.catid 
  WHERE i.published = 1
                
  AND i.access IN(1)
                
  AND i.trash = 0
                
  AND c.published = 1
                
  AND c.access IN(1)
                
  AND c.trash = 0
                
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-06-08 03:41:53')
                
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-06-08 03:41:53') 
  AND i.language IN('fa-IR', '*') 
  AND c.language IN('fa-IR', '*') 
  ORDER BY i.hits DESC 
  LIMIT 0, 3

توضیح دادن

توضیحات در جستجو ممکن نیست: /* Frontend / mod_k2_content */ SELECT i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams FROM dly1p_k2_items AS i INNER JOIN dly1p_k2_categories AS c ON c.id = i.catid WHERE i.published = 1 AND i.access IN(1) AND i.trash = 0 AND c.published = 1 AND c.access IN(1) AND c.trash = 0 AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-06-08 03:41:53') AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-06-08 03:41:53') AND i.language IN('fa-IR', '*') AND c.language IN('fa-IR', '*') ORDER BY i.hits DESC LIMIT 0, 3

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_k2_content/helper.php:262
11	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:65
10	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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 برای لینک به فایل ها]

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

SELECT id, name, parent 
  FROM dly1p_k2_categories 
  WHERE published=1 
  AND trash=0 
  AND access IN(1,1) 
  AND language IN('fa-IR', '*') 
  ORDER BY parent

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dly1p_k2_categories	ALL	category,published,access,trash,language,idx_category	کلید شاخصی برای استفاده نیست	NULL	NULL	26	Using where; با استفاده از مرتب سازی فایل

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:881
14	K2ModelItemlist->getCategoriesTree()	JROOT/components/com_k2/helpers/route.php:261
13	K2HelperRoute::findMenuItem()	JROOT/components/com_k2/helpers/route.php:41
12	K2HelperRoute::getItemRoute()	JROOT/modules/mod_k2_content/helper.php:281
11	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:65
10	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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 برای لینک به فایل ها]

زمان پرس و جو: 1.62 ms پس از آخرین پرس و جو: 2.06 ms حافظه پرس و جو: 0.010 MB حافظه قبل از پرس و جوی: 17.317 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 = 'mod_custom.content' 
  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.12 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
After opening tables	0.03 ms
System lock	0.04 ms
table lock	0.03 ms
init	0.07 ms
Optimizing	0.04 ms
Statistics	0.13 ms
Preparing	0.06 ms
Creating tmp table	0.15 ms
Sorting result	0.04 ms
Executing	0.04 ms
Sending data	0.19 ms
Creating sort index	0.05 ms
Removing tmp table	0.11 ms
Creating sort index	0.04 ms
End of update loop	0.02 ms
Query end	0.06 ms
Commit	0.02 ms
Query end	0.01 ms
closing tables	0.03 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.04 ms
Starting cleanup	0.05 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.06 ms

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

#	فراخوانده	فایل و شماره خط
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	به نظر می رسد خط زیر فراخونده شده باشد.
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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 برای لینک به فایل ها]

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

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

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

10 × SELECT COUNT(*) 
  FROM dly1p_k2_comments

10 × 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`

2 × SELECT * 
  FROM `dly1p_realtimeanalytics_eventstats`

2 × SELECT * 
  FROM dly1p_k2_categories

1 × SELECT `data` 
  FROM `dly1p_session`

1 × SELECT id, name, parent 
  FROM dly1p_k2_categories

1 × SELECT * 
  FROM dly1p_acymailing_list

1 × SELECT * 
  FROM dly1p_acymailing_confi

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

1 × SELECT language,id 
  FROM `dly1p_menu`

1 × SELECT id 
  FROM dly1p_k2_categories

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 * 
  FROM `dly1p_users`
```

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 `session_id` 
  FROM `dly1p_session`

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

```
1 × SELECT * 
  FROM dly1p_session
```

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 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 × INSERT INTO `dly1p_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6663343331633966383865376437613932646238393363653764366361333437', 1, 1780890113, 0, '', 0

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

1 × SHOW FULL COLUMNS 
  FROM `dly1p_session

1 × SHOW FULL COLUMNS 
  FROM `dly1p_users

1 × /* Frontend / K2 / Items */ SELECT /*+ MAX_EXECUTION_TIME(60000) */ i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams 
  FROM dly1p_k2_items AS i 
  INNER JOIN dly1p_k2_categories AS c 
  ON c.id = i.catid

1 × /* Frontend / K2 / Items Count */ SELECT COUNT(*) 
  FROM dly1p_k2_items AS i 
  INNER JOIN dly1p_k2_categories AS c 
  ON c.id = i.catid

1 × SHOW FULL COLUMNS 
  FROM `dly1p_k2_categories

1 × /* Frontend / mod_k2_content */ SELECT i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams 
  FROM dly1p_k2_items AS i 
  INNER JOIN dly1p_k2_categories AS c 
  ON c.id = i.catid

علائم MSDS

mehdi razabadi

21136

21135

21134

21133

21132

21131

21130

21129

21128

21127

علائم و تجهیزات پر بازدید

اشتراک خبرنامه

جستجو

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

جلسه

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

زمان

حافظه

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

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

77 پرس و جو ثبت شده 269.98 ms

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

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

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

سایر جداول: