فهرست - candoism

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

جلسه

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1716100309,
                "last": 1716100309,
                "now": 1716100309
            },
            "token": "93OnTy7J5i0xzEFgDCaYhZXZlzv5iZxA"
        },
        "registry": {
            "com_kunena": {
                "user0_read": {
                    "11": 11,
                    "2": 2,
                    "22": 22,
                    "1": 1,
                    "12": 12,
                    "3": 3,
                    "10": 10,
                    "13": 13,
                    "5": 5,
                    "18": 18,
                    "14": 14,
                    "6": 6,
                    "19": 19,
                    "15": 15,
                    "7": 7,
                    "20": 20,
                    "16": 16,
                    "8": 8,
                    "21": 21,
                    "17": 17,
                    "9": 9
                }
            }
        },
        "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
        },
        "flushSessions": null
    }
}

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qp1hvh7qp_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

#	فراخوانده	فایل و شماره خط
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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qp1hvh7qp_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	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 `qp1hvh7qp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'63333771346a66703936336e30663674633239366c3338373837', 1, 1716100309, 0, '', 0)

مشخصات

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
update	0.05 ms
end	0.00 ms
query end	0.20 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 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 برای لینک به فایل ها]

زمان پرس و جو: 0.45 ms پس از آخرین پرس و جو: 1.35 ms حافظه پرس و جو: 0.033 MB حافظه قبل از پرس و جوی: 3.971 MB سطرهای بازگشتی: 39

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

  FROM `qp1hvh7qp_extensions`

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

توضیح دادن

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qp1hvh7qp_extensions	NULL	ref	extension	extension	82	const	42	1.00	Using where

مشخصات

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.15 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.13 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	به نظر می رسد خط زیر فراخونده شده باشد.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.31 ms پس از آخرین پرس و جو: 1.17 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 4.176 MB سطرهای بازگشتی: 5

SELECT id, rules

  FROM `qp1hvh7qp_viewlevels`

توضیح دادن

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

مشخصات

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.19 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

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

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

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

زمان پرس و جو: 0.31 ms پس از آخرین پرس و جو: 0.04 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 4.191 MB سطرهای بازگشتی: 2

SELECT b.id

  FROM qp1hvh7qp_usergroups AS a

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

  WHERE a.id = 9

توضیح دادن

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	100.00	Using where; Using index

مشخصات

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.16 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

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

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

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

زمان پرس و جو: 0.53 ms پس از آخرین پرس و جو: 0.34 ms حافظه پرس و جو: 0.038 MB حافظه قبل از پرس و جوی: 4.258 MB سطرهای بازگشتی: 93

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

  FROM qp1hvh7qp_extensions

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

  ORDER BY ordering

توضیح دادن

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qp1hvh7qp_extensions	NULL	ref	extension	extension	82	const	134	0.60	Using index condition; Using where; با استفاده از مرتب سازی فایل

مشخصات

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.37 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 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.34 ms پس از آخرین پرس و جو: 23.57 ms حافظه پرس و جو: 0.142 MB حافظه قبل از پرس و جوی: 8.202 MB سطرهای بازگشتی: 167

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

  LEFT JOIN qp1hvh7qp_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	کلید شاخصی برای استفاده نیست	NULL	NULL	251	7.77	Using where; با استفاده از مرتب سازی فایل
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	candoi_sm0simone2.m.component_id	1	100.00	Using where

مشخصات

Status	Duration
starting	0.10 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.26 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.75 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	به نظر می رسد خط زیر فراخونده شده باشد.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.66 ms پس از آخرین پرس و جو: 5.02 ms حافظه پرس و جو: 0.041 MB حافظه قبل از پرس و جوی: 9.365 MB سطرهای بازگشتی: 123

SELECT id, home, template, s.params

  FROM qp1hvh7qp_template_styles as s

  LEFT JOIN qp1hvh7qp_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	candoi_sm0simone2.e.element	25	98.40	Using index condition; Using where

مشخصات

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.17 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.26 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/gantry5/gantry5.php:195
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
8	plgSystemGantry5->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.20 ms پس از آخرین پرس و جو: 4.81 ms حافظه پرس و جو: 0.038 MB حافظه قبل از پرس و جوی: 10.137 MB سطرهای بازگشتی: 1

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

  FROM `qp1hvh7qp_extensions`

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

توضیح دادن

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qp1hvh7qp_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

مشخصات

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.03 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
30	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
29	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	به نظر می رسد خط زیر فراخونده شده باشد.
28	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
27	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
26	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
25	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
24	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
23	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
22	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
21	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/HTML/HTMLHelper.php:731
20	Joomla\CMS\HTML\HTMLHelper::script()	به نظر می رسد خط زیر فراخونده شده باشد.
19	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
18	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
17	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
16	JHtmlJquery::framework()	به نظر می رسد خط زیر فراخونده شده باشد.
15	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
14	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
13	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/jf_simone/jf/jf_particle_class.php:17
12	include_once JROOT/templates/jf_simone/jf/jf_particle_class.php	JROOT/templates/jf_simone/includes/theme.php:31
11	include_once JROOT/templates/jf_simone/includes/theme.php	JROOT/templates/jf_simone/includes/gantry.php:40
10	include JROOT/templates/jf_simone/includes/gantry.php	JROOT/plugins/system/gantry5/gantry5.php:205
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
8	plgSystemGantry5->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.36 ms پس از آخرین پرس و جو: 0.08 ms حافظه پرس و جو: 0.017 MB حافظه قبل از پرس و جوی: 10.140 MB

UPDATE `qp1hvh7qp_extensions`

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

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

توضیح دادن

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	qp1hvh7qp_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

مشخصات

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.03 ms
updating	0.04 ms
end	0.01 ms
query end	0.18 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
25	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
24	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
23	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
22	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
21	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/HTML/HTMLHelper.php:731
20	Joomla\CMS\HTML\HTMLHelper::script()	به نظر می رسد خط زیر فراخونده شده باشد.
19	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
18	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
17	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
16	JHtmlJquery::framework()	به نظر می رسد خط زیر فراخونده شده باشد.
15	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
14	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
13	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/jf_simone/jf/jf_particle_class.php:17
12	include_once JROOT/templates/jf_simone/jf/jf_particle_class.php	JROOT/templates/jf_simone/includes/theme.php:31
11	include_once JROOT/templates/jf_simone/includes/theme.php	JROOT/templates/jf_simone/includes/gantry.php:40
10	include JROOT/templates/jf_simone/includes/gantry.php	JROOT/plugins/system/gantry5/gantry5.php:205
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
8	plgSystemGantry5->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.41 ms پس از آخرین پرس و جو: 6.94 ms حافظه پرس و جو: 0.046 MB حافظه قبل از پرس و جوی: 11.255 MB سطرهای بازگشتی: 121

SELECT s.id, s.template, s.home, s.title AS long_title, s.params

  FROM qp1hvh7qp_template_styles AS s

  WHERE s.client_id = 0 
  AND s.template = 'jf_simone'

  ORDER BY s.id

توضیح دادن

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	index	idx_template,idx_client_id,idx_client_id_home	PRIMARY	4	NULL	125	95.25	Using where

مشخصات

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.16 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry5/classes/Gantry/Joomla/StyleHelper.php:46
14	Gantry\Joomla\StyleHelper::loadStyles()	JROOT/libraries/gantry5/classes/Gantry/Framework/Assignments.php:50
13	Gantry\Framework\Assignments->loadAssignments()	JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:303
12	Gantry\Component\Assignments\AbstractAssignments->init()	JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:104
11	Gantry\Component\Assignments\AbstractAssignments->scores()	JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:91
10	Gantry\Component\Assignments\AbstractAssignments->select()	JROOT/plugins/system/gantry5/gantry5.php:246
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
8	plgSystemGantry5->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.75 ms پس از آخرین پرس و جو: 4.20 ms حافظه پرس و جو: 0.236 MB حافظه قبل از پرس و جوی: 11.845 MB سطرهای بازگشتی: 138

SELECT `name`,`value` 
  FROM `qp1hvh7qp_joombank_setting`

توضیح دادن

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

مشخصات

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.27 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.36 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
17	JDatabaseDriver->loadAssocList()	JROOT/libraries/joombank/cms/joomla/libraries/joomla.php
16	JBNJoomla::globalDbQuery()	JROOT/libraries/joombank/cms/joomla/libraries/joomla.php
15	JBNJoomla::selectByQuery()	JROOT/libraries/joombank/cms/joomla/libraries/joomla.php
14	JBNJoomla::selectAll()	JROOT/libraries/joombank/libraries/cms.php
13	JBNCms::setSettings()	JROOT/libraries/joombank/libraries/cms.php
12	JBNCms::getSetting()	JROOT/libraries/joombank/libraries/bill.php
11	JBNBill->deleteTransactionWhere()	JROOT/libraries/joombank/libraries/bill.php
10	JBNBill->deleteExpireTransactionsAndSendNotification()	JROOT/libraries/joombank/libraries/bill.php
9	JBNBill->doCronJobActions()	JROOT/plugins/system/joombank_loader/joombank_loader.php
8	plgSystemJoombank_loader->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.39 ms پس از آخرین پرس و جو: 2.61 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 12.513 MB

DELETE 
  FROM `qp1hvh7qp_joombank_transactions` 
  WHERE (`status`='1' 
  AND `reserve_date` < '1403/02/30 05:01:49') OR (`status`='2' 
  AND `reserve_date` < '1403/02/30 05:01:49') OR (`status`='3' 
  AND `reserve_date` < '1403/02/30 05:01:49')

توضیح دادن

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	qp1hvh7qp_joombank_transactions	NULL	ALL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	66	100.00	Using where

مشخصات

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.17 ms
init	0.01 ms
System lock	0.01 ms
updating	0.10 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
13	JDatabase->query()	JROOT/libraries/joombank/cms/joomla/libraries/joomla.php
12	JBNJoomla::globalDbQuery()	JROOT/libraries/joombank/cms/joomla/libraries/joomla.php
11	JBNJoomla::delete()	JROOT/libraries/joombank/libraries/bill.php
10	JBNBill->deleteExpireTransactionsAndSendNotification()	JROOT/libraries/joombank/libraries/bill.php
9	JBNBill->doCronJobActions()	JROOT/plugins/system/joombank_loader/joombank_loader.php
8	plgSystemJoombank_loader->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `id`,`status`,`total_amount`,`coupon_count`,`coupon_amount`,`coupon_suspended_ids` 
  FROM `qp1hvh7qp_joombank_transactions` 
  WHERE `user_id` > '0' 
  AND `coupon_amount` > 0 
  AND `status` NOT IN (10,4) 
  AND `modified_date`<'1403/02/30 10:31:49'

توضیح دادن

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

مشخصات

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.03 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT/libraries/joombank/cms/joomla/libraries/joomla.php
13	JBNJoomla::globalDbQuery()	JROOT/libraries/joombank/cms/joomla/libraries/joomla.php
12	JBNJoomla::selectByQuery()	JROOT/libraries/joombank/libraries/coupon.php
11	JBNCoupon::checkSuspendedCoupons()	JROOT/libraries/joombank/libraries/coupon.php
10	JBNCoupon::checkUserCoupons()	JROOT/libraries/joombank/libraries/bill.php
9	JBNBill->doCronJobActions()	JROOT/plugins/system/joombank_loader/joombank_loader.php
8	plgSystemJoombank_loader->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `id`,`user_id`,`count`,`used_count` 
  FROM `qp1hvh7qp_joombank_users_coupon` 
  WHERE `suspended_count`='0' 
  AND (`used_count`+`expired_count`) < `count` 
  AND `expire_date` < '1403/02/30 11:01:49'

توضیح دادن

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

مشخصات

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.14 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT/libraries/joombank/cms/joomla/libraries/joomla.php
13	JBNJoomla::globalDbQuery()	JROOT/libraries/joombank/cms/joomla/libraries/joomla.php
12	JBNJoomla::selectByQuery()	JROOT/libraries/joombank/libraries/coupon.php
11	JBNCoupon::modifyExpireUsedCoupons()	JROOT/libraries/joombank/libraries/coupon.php
10	JBNCoupon::checkUserCoupons()	JROOT/libraries/joombank/libraries/bill.php
9	JBNBill->doCronJobActions()	JROOT/plugins/system/joombank_loader/joombank_loader.php
8	plgSystemJoombank_loader->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `id`,`status`,`total_amount`,`discount_amount`,`discount_code` 
  FROM `qp1hvh7qp_joombank_transactions` 
  WHERE `discount_amount` > 0 
  AND `status` NOT IN (10,4) 
  AND `modified_date`<'1403/02/30 10:31:49'

توضیح دادن

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

مشخصات

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
13	JDatabaseDriver->loadAssocList()	JROOT/libraries/joombank/cms/joomla/libraries/joomla.php
12	JBNJoomla::globalDbQuery()	JROOT/libraries/joombank/cms/joomla/libraries/joomla.php
11	JBNJoomla::selectByQuery()	JROOT/libraries/joombank/libraries/discount.php
10	JBNDiscount->checkUserDiscounts()	JROOT/libraries/joombank/libraries/bill.php
9	JBNBill->doCronJobActions()	JROOT/plugins/system/joombank_loader/joombank_loader.php
8	plgSystemJoombank_loader->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `id`,`code`,`status`,`total_amount`,`wallet_amount`,`user_id` 
  FROM `qp1hvh7qp_joombank_transactions` 
  WHERE `wallet_amount` > 0 
  AND `user_id` > 0 
  AND `status` NOT IN (10,4) 
  AND `modified_date`<'1403/02/30 10:31:49'

توضیح دادن

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

مشخصات

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
13	JDatabaseDriver->loadAssocList()	JROOT/libraries/joombank/cms/joomla/libraries/joomla.php
12	JBNJoomla::globalDbQuery()	JROOT/libraries/joombank/cms/joomla/libraries/joomla.php
11	JBNJoomla::selectByQuery()	JROOT/libraries/joombank/libraries/users.php
10	JBNUsers->checkWalletPayTransactions()	JROOT/libraries/joombank/libraries/bill.php
9	JBNBill->doCronJobActions()	JROOT/plugins/system/joombank_loader/joombank_loader.php
8	plgSystemJoombank_loader->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.31 ms پس از آخرین پرس و جو: 0.90 ms حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 12.731 MB سطرهای بازگشتی: 1

SELECT *

  FROM qp1hvh7qp_languages

  WHERE published=1

  ORDER BY ordering ASC

توضیح دادن

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

مشخصات

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.16 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

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

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

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

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

SELECT * 
  FROM qp1hvh7qp_kunena_configuration 
  WHERE id=1

توضیح دادن

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

مشخصات

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.08 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
9	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/config.php:1289
8	KunenaConfig->load()	JROOT/libraries/kunena/config.php:1223
7	KunenaConfig::getInstance()	JROOT/components/com_kunena/kunena.php:33
6	require_once JROOT/components/com_kunena/kunena.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.34 ms پس از آخرین پرس و جو: 1.94 ms حافظه پرس و جو: 0.032 MB حافظه قبل از پرس و جوی: 13.351 MB سطرهای بازگشتی: 5

SHOW FULL COLUMNS 
  FROM `qp1hvh7qp_kunena_sessions`

توضیح دادن

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

مشخصات

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.09 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.02 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 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/libraries/kunena/tables/kunenasessions.php:31
13	TableKunenaSessions->__construct()	JROOT/libraries/src/Table/Table.php:312
12	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/session.php:96
11	KunenaSession->getTable()	JROOT/libraries/kunena/session.php:110
10	KunenaSession->load()	JROOT/libraries/kunena/session.php:30
9	KunenaSession->__construct()	JROOT/libraries/kunena/session.php:60
8	KunenaSession::getInstance()	JROOT/libraries/kunena/factory.php:86
7	KunenaFactory::getSession()	JROOT/components/com_kunena/kunena.php:61
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.62 ms پس از آخرین پرس و جو: 5.51 ms حافظه پرس و جو: 0.045 MB حافظه قبل از پرس و جوی: 14.202 MB سطرهای بازگشتی: 56

SHOW FULL COLUMNS 
  FROM `qp1hvh7qp_kunena_users`

توضیح دادن

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

مشخصات

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.11 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.08 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.00 ms
freeing items	0.03 ms
cleaning up	0.01 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/kunena/tables/kunenausers.php:329
18	TableKunenaUsers->__construct()	JROOT/libraries/src/Table/Table.php:312
17	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/user/user.php:252
16	KunenaUser->getTable()	JROOT/libraries/kunena/user/user.php:275
15	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:100
14	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:59
13	KunenaUserHelper::initialize()	JROOT/libraries/kunena/user/helper.php:13
12	include_once JROOT/libraries/kunena/user/helper.php	JROOT/libraries/loader.php:738
11	JLoader::_load()	JROOT/libraries/loader.php:707
10	JLoader::_autoload()	به نظر می رسد خط زیر فراخونده شده باشد.
9	spl_autoload_call()	JROOT/libraries/kunena/controller/application/display.php:218
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.62 ms پس از آخرین پرس و جو: 4.48 ms حافظه پرس و جو: 0.035 MB حافظه قبل از پرس و جوی: 15.098 MB سطرهای بازگشتی: 39

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

  FROM `qp1hvh7qp_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_breezingforms','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gantry5','com_installer','com_joombank','com_joomlaupdate','com_kunena','com_languages','com_login','com_logregsms','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

توضیح دادن

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

مشخصات

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.22 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.17 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
17	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
16	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
15	Joomla\CMS\Access\Access::getAssetRules()	JROOT/plugins/kunena/joomla/access.php:461
14	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:233
13	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:224
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT DISTINCT(user_id)

  FROM qp1hvh7qp_usergroups as ug1

  INNER JOIN qp1hvh7qp_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt

  INNER JOIN qp1hvh7qp_user_usergroup_map AS m 
  ON ug2.id=m.group_id

  WHERE ug1.id IN (8)

توضیح دادن

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ug1	NULL	const	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	const	1	100.00	Using temporary
1	SIMPLE	ug2	NULL	range	PRIMARY,idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	33.33	Using where; Using index
1	SIMPLE	m	NULL	index	PRIMARY	PRIMARY	8	NULL	124	10.00	Using where; Using index; Using join buffer (Block Nested Loop)

مشخصات

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Creating tmp table	0.01 ms
executing	0.00 ms
Sending data	0.09 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:441
15	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:492
14	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:233
13	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:224
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.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.20 ms پس از آخرین پرس و جو: 0.04 ms حافظه پرس و جو: 0.029 MB حافظه قبل از پرس و جوی: 15.200 MB سطرهای بازگشتی: 0

SELECT DISTINCT(user_id)

  FROM qp1hvh7qp_usergroups as ug1

  INNER JOIN qp1hvh7qp_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt

  INNER JOIN qp1hvh7qp_user_usergroup_map AS m 
  ON ug2.id=m.group_id

  WHERE ug1.id IN (7)

توضیح دادن

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ug1	NULL	const	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	const	1	100.00	Using temporary
1	SIMPLE	ug2	NULL	range	PRIMARY,idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	6	33.33	Using where; Using index
1	SIMPLE	m	NULL	index	PRIMARY	PRIMARY	8	NULL	124	10.00	Using where; Using index; Using join buffer (Block Nested Loop)

مشخصات

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Creating tmp table	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:441
15	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:492
14	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:233
13	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:224
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.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.19 ms پس از آخرین پرس و جو: 0.02 ms حافظه پرس و جو: 0.027 MB حافظه قبل از پرس و جوی: 15.208 MB سطرهای بازگشتی: 0

SELECT user_id, category_id, role 
  FROM qp1hvh7qp_kunena_user_categories 
  WHERE role IN (1,2)

توضیح دادن

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qp1hvh7qp_kunena_user_categories	NULL	range	role	role	1	NULL	2	100.00	Using index condition

مشخصات

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.08 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/access.php:136
12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:224
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.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.32 ms پس از آخرین پرس و جو: 1.24 ms حافظه پرس و جو: 0.058 MB حافظه قبل از پرس و جوی: 15.421 MB سطرهای بازگشتی: 21

SELECT * 
  FROM qp1hvh7qp_kunena_categories 
  ORDER BY ordering, name

توضیح دادن

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qp1hvh7qp_kunena_categories	NULL	ALL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	21	100.00	با استفاده از مرتب سازی فایل

مشخصات

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.10 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.09 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/category/helper.php:865
20	KunenaForumCategoryHelper::loadCategories()	JROOT/libraries/kunena/forum/category/helper.php:43
19	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:965
18	include_once JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:738
17	JLoader::_load()	JROOT/libraries/loader.php:707
16	JLoader::_autoload()	به نظر می رسد خط زیر فراخونده شده باشد.
15	spl_autoload_call()	JROOT/libraries/kunena/access.php:560
14	KunenaAccess->getAllowedCategories()	JROOT/components/com_kunena/controller/category/index/display.php:50
13	ComponentKunenaControllerCategoryIndexDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/jf_simone/pages/category/list/default.php:13
10	include JROOT/components/com_kunena/template/jf_simone/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.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.36 ms پس از آخرین پرس و جو: 1.90 ms حافظه پرس و جو: 0.047 MB حافظه قبل از پرس و جوی: 15.946 MB سطرهای بازگشتی: 36

SHOW FULL COLUMNS 
  FROM `qp1hvh7qp_kunena_categories`

توضیح دادن

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

مشخصات

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.00 ms
Opening tables	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.02 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
26	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
25	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
24	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenacategories.php:61
23	TableKunenaCategories->__construct()	JROOT/libraries/src/Table/Table.php:312
22	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/database/object.php:282
21	KunenaDatabaseObject->getTable()	JROOT/libraries/kunena/database/object.php:100
20	KunenaDatabaseObject->load()	JROOT/libraries/kunena/forum/category/category.php:1051
19	KunenaForumCategory->load()	JROOT/libraries/kunena/forum/category/helper.php:88
18	KunenaForumCategoryHelper::get()	JROOT/libraries/kunena/html/html/kunenaforum.php:77
17	JHtmlKunenaForum::categorylist()	به نظر می رسد خط زیر فراخونده شده باشد.
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/components/com_kunena/controller/category/index/display.php:61
13	ComponentKunenaControllerCategoryIndexDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/jf_simone/pages/category/list/default.php:13
10	include JROOT/components/com_kunena/template/jf_simone/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.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.19 ms پس از آخرین پرس و جو: 2.40 ms حافظه پرس و جو: 0.051 MB حافظه قبل از پرس و جوی: 16.356 MB سطرهای بازگشتی: 26

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

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

  FROM qp1hvh7qp_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-05-19 06:31:49') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-19 06:31:49') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 380 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

توضیح دادن

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	37	1.69	Using index condition; Using where; با استفاده از مرتب سازی فایل
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	candoi_sm0simone2.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	candoi_sm0simone2.m.id	2	40.00	Using where; Using index

مشخصات

Status	Duration
starting	0.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.28 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.60 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	به نظر می رسد خط زیر فراخونده شده باشد.
25	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
24	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
23	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
22	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
21	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
20	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/components/com_kunena/layout/widget/module.php:33
19	KunenaLayoutWidgetModule->renderPosition()	JROOT/components/com_kunena/template/crypsis/layouts/widget/module/default.php:13
18	include JROOT/components/com_kunena/template/crypsis/layouts/widget/module/default.php	JROOT/libraries/kunena/layout/base.php:183
17	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
16	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
15	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/crypsis/layouts/category/index/default.php:29
14	include JROOT/components/com_kunena/template/crypsis/layouts/category/index/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/jf_simone/pages/category/list/default.php:20
10	include JROOT/components/com_kunena/template/jf_simone/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.56 ms پس از آخرین پرس و جو: 3.08 ms حافظه پرس و جو: 0.043 MB حافظه قبل از پرس و جوی: 16.671 MB سطرهای بازگشتی: 25

SHOW FULL COLUMNS 
  FROM `qp1hvh7qp_kunena_topics`

توضیح دادن

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

مشخصات

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.12 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.02 ms
closing tables	0.00 ms
freeing items	0.03 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
26	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
25	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
24	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenatopics.php:50
23	TableKunenaTopics->__construct()	JROOT/libraries/src/Table/Table.php:312
22	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/database/object.php:282
21	KunenaDatabaseObject->getTable()	JROOT/libraries/kunena/database/object.php:100
20	KunenaDatabaseObject->load()	JROOT/libraries/kunena/forum/topic/topic.php:964
19	KunenaForumTopic->load()	JROOT/libraries/kunena/database/object.php:271
18	KunenaDatabaseObject->__construct()	JROOT/libraries/kunena/forum/topic/topic.php:119
17	KunenaForumTopic->__construct()	JROOT/libraries/kunena/forum/topic/helper.php:42
16	KunenaForumTopicHelper::get()	JROOT/libraries/kunena/forum/category/category.php:566
15	KunenaForumCategory->getLastTopic()	JROOT/components/com_kunena/template/crypsis/layouts/category/index/default.php:192
14	include JROOT/components/com_kunena/template/crypsis/layouts/category/index/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/jf_simone/pages/category/list/default.php:20
10	include JROOT/components/com_kunena/template/jf_simone/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.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.27 ms پس از آخرین پرس و جو: 4.70 ms حافظه پرس و جو: 0.031 MB حافظه قبل از پرس و جوی: 17.252 MB سطرهای بازگشتی: 0

SELECT *

  FROM qp1hvh7qp_kunena_announcement

  WHERE (published = 1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-05-19 06:31:49') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-05-19 06:31:49')

  ORDER BY id DESC 
  LIMIT 1

توضیح دادن

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	NULL	NULL	no matching row in const table

مشخصات

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.09 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/forum/announcement/helper.php:131
14	KunenaForumAnnouncementHelper::getAnnouncements()	JROOT/components/com_kunena/controller/widget/announcement/display.php:40
13	ComponentKunenaControllerWidgetAnnouncementDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
11	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/jf_simone/layouts/page/default.php:61
10	include JROOT/components/com_kunena/template/jf_simone/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:131
6	require_once JROOT/components/com_kunena/kunena.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.47 ms پس از آخرین پرس و جو: 21.07 ms حافظه پرس و جو: 0.045 MB حافظه قبل از پرس و جوی: 21.175 MB سطرهای بازگشتی: 8

SELECT a.menutype

  FROM qp1hvh7qp_menu_types AS a

  WHERE a.client_id = 0

توضیح دادن

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

مشخصات

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.26 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
44	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
43	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_menus/helpers/menus.php:154
42	MenusHelper::getMenuTypes()	JROOT/libraries/gantry5/classes/Gantry/Framework/Menu.php:71
41	Gantry\Framework\Menu->getMenus()	JROOT/libraries/gantry5/classes/Gantry/Component/Menu/AbstractMenu.php:115
40	Gantry\Component\Menu\AbstractMenu->instance()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
39	Twig\Template->getAttribute()	JROOT/cache/gantry5/jf_simone/twig/f6/f6e6833d6a50d76076c7139f6e5088b54fccaca72e77d837e2e7f67d54dcb2e5.php:32
38	__TwigTemplate_f1c20cd65d9be16de7ac0a203710d208e68d0b020aa7a4dd37acd6fcba7f9fda->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/cache/gantry5/jf_simone/twig/3f/3f861f05674b7094538315399861aba8a430a81e66398c37e6ffd3a8e64b033d.php:71
35	__TwigTemplate_e17407a2923321397134376410f98869ab4dfb765de90b146b01624ccd358b4f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
33	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
32	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
30	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/jf_simone/twig/d5/d54e120fbbdfd559496bb752deea2f84d51a76b6d1f05032ec1e3582cefc0ddb.php:47
20	__TwigTemplate_086c1526d3d9ae18ea54c4f9d09e4102f4fc885ffab030fa27529a35596da3c5->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/jf_simone/twig/9d/9df96cd36e4caa3458bc8438bd644e107aee100989f5a7b342a4b7476fecdb08.php:35
17	__TwigTemplate_97934b1148e6abc863a4744e5c8302f1b74b7702dbc942411387ec303506421d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/jf_simone/twig/39/39722aef524ace9ed753356c889aff20f7a313bf36da231a7389796e8c86f0be.php:35
14	__TwigTemplate_941cbae9b696a09165c8a146f2cf5f44a14fbeb4a25a6c37ecd0443324e58e11->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/jf_simone/index.php:23
7	require JROOT/templates/jf_simone/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
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 برای لینک به فایل ها]

زمان پرس و جو: 0.67 ms پس از آخرین پرس و جو: 3.12 ms حافظه پرس و جو: 0.066 MB حافظه قبل از پرس و جوی: 21.567 MB سطرهای بازگشتی: 26

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

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

  FROM qp1hvh7qp_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-05-19 06:31:49') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-19 06:31:49') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 380 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

توضیح دادن

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	37	1.69	Using index condition; Using where; با استفاده از مرتب سازی فایل
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	candoi_sm0simone2.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	candoi_sm0simone2.m.id	2	40.00	Using where; Using index

مشخصات

Status	Duration
starting	0.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.38 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
52	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
51	JDatabaseDriver->loadObjectList()	به نظر می رسد خط زیر فراخونده شده باشد.
50	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
49	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
48	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:276
47	Gantry\Framework\Platform->getModuleList()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:269
46	Gantry\Framework\Platform->getModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:183
45	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
44	Twig\Template->getAttribute()	JROOT/cache/gantry5/jf_simone/twig/9b/9b903012a6c0b66d4c6c5c654e43c162c184463d6caa3adf8520dd833b936d7d.php:43
43	__TwigTemplate_5f68c1608af6647dcad128f7069fc98c4a845e158f60cbe7140b8b13bdb8d180->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
42	Twig\Template->displayBlock()	JROOT/cache/gantry5/jf_simone/twig/eb/eb61fcf498181ae00ea731d5c747a88eb60a56717b19670af72500eba12b9800.php:73
41	__TwigTemplate_27ebd40c91877f6c3bb12e53f152f5ec9cad433bd55643de89c40fe5359e15e8->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/cache/gantry5/jf_simone/twig/9b/9b903012a6c0b66d4c6c5c654e43c162c184463d6caa3adf8520dd833b936d7d.php:35
38	__TwigTemplate_5f68c1608af6647dcad128f7069fc98c4a845e158f60cbe7140b8b13bdb8d180->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/cache/gantry5/jf_simone/twig/cf/cf1cc845c294d5d9e1a4e59be4cacb420749fb5211f3f60658401e74b7d7e669.php:53
35	__TwigTemplate_ab99b38e45e1c6bbe4d472694578094c25b3c1cb165823ad21358019df3e9252->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
33	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
32	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
30	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/jf_simone/twig/d5/d54e120fbbdfd559496bb752deea2f84d51a76b6d1f05032ec1e3582cefc0ddb.php:47
20	__TwigTemplate_086c1526d3d9ae18ea54c4f9d09e4102f4fc885ffab030fa27529a35596da3c5->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/jf_simone/twig/9d/9df96cd36e4caa3458bc8438bd644e107aee100989f5a7b342a4b7476fecdb08.php:35
17	__TwigTemplate_97934b1148e6abc863a4744e5c8302f1b74b7702dbc942411387ec303506421d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/jf_simone/twig/39/39722aef524ace9ed753356c889aff20f7a313bf36da231a7389796e8c86f0be.php:35
14	__TwigTemplate_941cbae9b696a09165c8a146f2cf5f44a14fbeb4a25a6c37ecd0443324e58e11->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/jf_simone/index.php:23
7	require JROOT/templates/jf_simone/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
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 برای لینک به فایل ها]

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

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

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

2 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM qp1hvh7qp_modules AS m 
  LEFT JOIN qp1hvh7qp_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN qp1hvh7qp_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

2 × SELECT DISTINCT(user_id) 
  FROM qp1hvh7qp_usergroups as ug1 
  INNER JOIN qp1hvh7qp_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt 
  INNER JOIN qp1hvh7qp_user_usergroup_map AS m 
  ON ug2.id=m.group_id

1 × SELECT `data` 
  FROM `qp1hvh7qp_session`

1 × SELECT `id`,`code`,`status`,`total_amount`,`wallet_amount`,`user_id` 
  FROM `qp1hvh7qp_joombank_transactions`

1 × SELECT * 
  FROM qp1hvh7qp_kunena_announcement

1 × SELECT * 
  FROM qp1hvh7qp_kunena_categories

1 × SELECT user_id, category_id, role 
  FROM qp1hvh7qp_kunena_user_categories

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

1 × SELECT * 
  FROM qp1hvh7qp_kunena_configuration

1 × SELECT * 
  FROM qp1hvh7qp_languages

1 × SELECT `id`,`user_id`,`count`,`used_count` 
  FROM `qp1hvh7qp_joombank_users_coupon`

1 × SELECT `id`,`status`,`total_amount`,`discount_amount`,`discount_code` 
  FROM `qp1hvh7qp_joombank_transactions`

1 × SELECT `session_id` 
  FROM `qp1hvh7qp_session`

1 × SELECT `id`,`status`,`total_amount`,`coupon_count`,`coupon_amount`,`coupon_suspended_ids` 
  FROM `qp1hvh7qp_joombank_transactions`

1 × SELECT `name`,`value` 
  FROM `qp1hvh7qp_joombank_setting

1 × SELECT s.id, s.template, s.home, s.title AS long_title, s.params 
  FROM qp1hvh7qp_template_styles AS s

1 × SELECT id, home, template, s.params 
  FROM qp1hvh7qp_template_styles as s 
  LEFT JOIN qp1hvh7qp_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 qp1hvh7qp_menu AS m 
  LEFT JOIN qp1hvh7qp_extensions AS e 
  ON m.component_id = e.extension_id

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

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

1 × SELECT id, rules 
  FROM `qp1hvh7qp_viewlevels

1 × SELECT a.menutype 
  FROM qp1hvh7qp_menu_types AS a

سایر جداول:

1 × INSERT INTO `qp1hvh7qp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'63333771346a66703936336e30663674633239366c3338373837', 1, 1716100309, 0, '', 0

1 × UPDATE `qp1hvh7qp_extensions` 
  SET `params` = '{\"mediaversion\":\"daac14ff3c210c40ebdb2d5c641d1421\"}'

1 × DELETE 
  FROM `qp1hvh7qp_joombank_transactions`

1 × SHOW FULL COLUMNS 
  FROM `qp1hvh7qp_kunena_sessions

1 × SHOW FULL COLUMNS 
  FROM `qp1hvh7qp_kunena_users

1 × SHOW FULL COLUMNS 
  FROM `qp1hvh7qp_kunena_categories

1 × SHOW FULL COLUMNS 
  FROM `qp1hvh7qp_kunena_topics

روشنایی ( 1 موضوع)

مشاهده لیست کامل موضوعات (1 lotd)

حرارتی (بدون موضوع)

مشاهده لیست کامل موضوعات (1 lotd)

جریان هوا (بدون موضوع)

مشاهده لیست کامل موضوعات (1 lotd)

صوت (بدون موضوع)

مشاهده لیست کامل موضوعات (1 lotd)

بهینه سازی (بدون موضوع)

مشاهده لیست کامل موضوعات (1 lotd)

شبیه سازی آنلاین (بدون موضوع)

بررسی مدل سه بعدی (بدون موضوع)

شبیه سازی

مدل سازی

پرزانته

شبیه سازی

مدل سازی

پرزانته

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

جلسه

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

زمان

حافظه

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

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

33 پرس و جو ثبت شده 14.09 ms

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

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

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

سایر جداول: