مشاهده محصولات

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

جلسه

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

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

زمان

حافظه

زمان: 11.63 ms / 11.63 ms حافظه: 0.572 MB / 0.95 MB Application: afterLoad

زمان: 65.63 ms / 77.27 ms حافظه: 1.557 MB / 2.51 MB Application: afterInitialise

زمان: 10.72 ms / 87.98 ms حافظه: 0.621 MB / 3.13 MB Application: Before Access::preloadComponents (all components)

زمان: 0.81 ms / 88.79 ms حافظه: 0.062 MB / 3.19 MB Application: After Access::preloadComponents (all components)

زمان: 0.02 ms / 88.82 ms حافظه: 0.000 MB / 3.19 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

زمان: 0.41 ms / 89.23 ms حافظه: 0.009 MB / 3.20 MB Application: After Access::getAssetRules (id:16 name:com_menus)

زمان: 86.67 ms / 175.90 ms حافظه: 5.153 MB / 8.35 MB Application: afterRoute

زمان: 0.25 ms / 176.15 ms حافظه: 0.001 MB / 8.35 MB Application: beforeRenderComponent com_digicom

زمان: 10.34 ms / 186.49 ms حافظه: 0.261 MB / 8.61 MB Application: Before Access::preloadPermissions (com_digicom)

زمان: 0.62 ms / 187.11 ms حافظه: 0.033 MB / 8.65 MB Application: After Access::preloadPermissions (com_digicom)

زمان: 0.02 ms / 187.13 ms حافظه: 0.000 MB / 8.65 MB Application: Before Access::getAssetRules (id:334 name:com_digicom.category.49)

زمان: 0.03 ms / 187.16 ms حافظه: 0.007 MB / 8.65 MB Application: After Access::getAssetRules (id:334 name:com_digicom.category.49)

زمان: 1.45 ms / 188.61 ms حافظه: 0.047 MB / 8.70 MB Application: Before Access::getAssetRules (id:215 name:com_digicom)

زمان: 0.01 ms / 188.63 ms حافظه: 0.002 MB / 8.70 MB Application: After Access::getAssetRules (id:215 name:com_digicom)

زمان: 20.16 ms / 208.78 ms حافظه: 0.414 MB / 9.12 MB Application: afterRenderComponent com_digicom

زمان: 6.34 ms / 215.12 ms حافظه: 0.040 MB / 9.16 MB Application: afterDispatch

زمان: 21.15 ms / 236.27 ms حافظه: 0.785 MB / 9.94 MB Application: beforeRenderModule mod_flexi_customcode (اسکریپت های عمومی)

زمان: 114.06 ms / 350.33 ms حافظه: 0.020 MB / 9.96 MB Application: afterRenderModule mod_flexi_customcode (اسکریپت های عمومی)

زمان: 1.95 ms / 352.28 ms حافظه: 0.000 MB / 9.96 MB Application: beforeRenderModule mod_digicom_categories (دسته بندی محصولات)

زمان: 4.03 ms / 356.31 ms حافظه: 0.119 MB / 10.08 MB Application: afterRenderModule mod_digicom_categories (دسته بندی محصولات)

زمان: 1.61 ms / 357.92 ms حافظه: 0.004 MB / 10.08 MB Application: beforeRenderModule mod_menu ()

زمان: 4.34 ms / 362.26 ms حافظه: 0.226 MB / 10.31 MB Application: afterRenderModule mod_menu ()

زمان: 0.87 ms / 363.13 ms حافظه: 0.000 MB / 10.26 MB Application: beforeRenderModule mod_menu ()

زمان: 2.95 ms / 366.08 ms حافظه: 0.076 MB / 10.34 MB Application: afterRenderModule mod_menu ()

زمان: 17.92 ms / 384.00 ms حافظه: 0.144 MB / 10.48 MB Application: afterRender

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s1g67_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	s1g67_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 `s1g67_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6532303537613165333734366432643062623638313066623837613231633439', 1, 1786167142, 0, '', 0)

مشخصات

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
update	0.09 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.64 ms
closing tables	0.01 ms
freeing items	1.92 ms
cleaning up	0.02 ms

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

#	فراخوانده	فایل و شماره خط
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php: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.41 ms پس از آخرین پرس و جو: 1.89 ms حافظه پرس و جو: 0.031 MB حافظه قبل از پرس و جوی: 1.343 MB سطرهای بازگشتی: 45

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

  FROM `s1g67_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	s1g67_extensions	NULL	ref	extension	extension	62	const	48	1.00	Using where

مشخصات

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.16 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 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.28 ms پس از آخرین پرس و جو: 1.37 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 1.447 MB سطرهای بازگشتی: 9

SELECT id, rules

  FROM `s1g67_viewlevels`

توضیح دادن

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

مشخصات

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.11 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 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.25 ms پس از آخرین پرس و جو: 0.05 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 1.461 MB سطرهای بازگشتی: 2

SELECT b.id

  FROM s1g67_usergroups AS a

  LEFT JOIN s1g67_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
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.09 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.24 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.56 ms پس از آخرین پرس و جو: 0.21 ms حافظه پرس و جو: 0.034 MB حافظه قبل از پرس و جوی: 1.483 MB سطرهای بازگشتی: 94

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

  FROM s1g67_extensions

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

  ORDER BY ordering

توضیح دادن

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s1g67_extensions	NULL	ref	extension	extension	62	const	137	0.80	Using where; با استفاده از مرتب سازی فایل

مشخصات

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.35 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	18.48 ms
cleaning up	0.05 ms

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

#	فراخوانده	فایل و شماره خط
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	به نظر می رسد خط زیر فراخونده شده باشد.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.95 ms پس از آخرین پرس و جو: 35.00 ms حافظه پرس و جو: 0.027 MB حافظه قبل از پرس و جوی: 2.495 MB سطرهای بازگشتی: 1

SELECT id,template 
  FROM s1g67_template_styles 
  WHERE client_id=0 
  AND home=1

توضیح دادن

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s1g67_template_styles	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	1	33.33	Using where

مشخصات

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.09 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.04 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/widgetkit.php:23
16	plgSystemWidgetkit->{closure}()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Container.php:240
15	YOOtheme\Framework\Container->offsetGet()	JROOT/administrator/components/com_widgetkit/src/Application.php:49
14	YOOtheme\Widgetkit\Application->YOOtheme\Widgetkit\{closure}()	به نظر می رسد خط زیر فراخونده شده باشد.
13	call_user_func_array()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Event/EventDispatcher.php:113
12	YOOtheme\Framework\Event\EventDispatcher->trigger()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Application.php:149
11	YOOtheme\Framework\Application->boot()	JROOT/administrator/components/com_widgetkit/widgetkit.php:91
10	include JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/administrator/components/com_widgetkit/widgetkit-app.php:6
9	include JROOT/administrator/components/com_widgetkit/widgetkit-app.php	JROOT/plugins/system/widgetkit/widgetkit.php:9
8	plgSystemWidgetkit->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 2.06 ms پس از آخرین پرس و جو: 2.59 ms حافظه پرس و جو: 0.093 MB حافظه قبل از پرس و جوی: 2.544 MB سطرهای بازگشتی: 85

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

  LEFT JOIN s1g67_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	158	6.39	Using where; با استفاده از مرتب سازی فایل
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	samaneba_BrShDb.m.component_id	1	100.00	Using where

مشخصات

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.12 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.37 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 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.55 ms پس از آخرین پرس و جو: 6.12 ms حافظه پرس و جو: 0.042 MB حافظه قبل از پرس و جوی: 3.040 MB سطرهای بازگشتی: 17

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `s1g67_categories` AS `c`

  WHERE (c.extension='com_digicom' OR c.extension='system') 
  AND c.access IN (1,1,5,10) 
  AND c.published = 1

  ORDER BY c.lft

توضیح دادن

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

مشخصات

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.16 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
11	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
10	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_digicom/router.php:654
9	DigiComRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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.65 ms پس از آخرین پرس و جو: 0.74 ms حافظه پرس و جو: 0.031 MB حافظه قبل از پرس و جوی: 3.135 MB سطرهای بازگشتی: 45

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

  FROM `s1g67_assets`

  WHERE `name` IN ('root.1','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_banners','com_bigfileuploader','com_blankcomponent','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_digicom','com_fields','com_finder','com_installer','com_jce','com_joominaflileselling','com_joominaticketing','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phpmyjoomla','com_plugins','com_postinstall','com_profiles','com_redirect','com_rsform','com_saveprofile','com_search','com_tags','com_templates','com_users','com_widgetkit','com_wrapper')

توضیح دادن

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s1g67_assets	NULL	range	idx_asset_name	idx_asset_name	152	NULL	46	100.00	Using index condition

مشخصات

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.15 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.25 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 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/libraries/src/Access/Access.php:183
14	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
13	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:28
12	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/src/Helper.php:33
11	RegularLabs\Plugin\System\AdvancedModules\Helper->onAfterRoute()	به نظر می رسد خط زیر فراخونده شده باشد.
10	call_user_func_array()	JROOT/plugins/system/advancedmodules/src/Plugin.php:106
9	RegularLabs\Plugin\System\AdvancedModules\Plugin->run()	JROOT/plugins/system/advancedmodules/advancedmodules.php:62
8	PlgSystemAdvancedModules->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:1123
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 پس از آخرین پرس و جو: 1.28 ms حافظه پرس و جو: 0.032 MB حافظه قبل از پرس و جوی: 3.200 MB سطرهای بازگشتی: 1

SELECT id, home, template, s.params

  FROM s1g67_template_styles as s

  LEFT JOIN s1g67_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	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	1	100.00	NULL
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	samaneba_BrShDb.s.template,const	1	4.68	Using index condition; Using where

مشخصات

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.05 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 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/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/yootheme/yootheme.php:113
9	plgSystemYOOtheme->handleRequest()	JROOT/plugins/system/yootheme/yootheme.php:31
8	plgSystemYOOtheme->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:1123
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 پس از آخرین پرس و جو: 50.33 ms حافظه پرس و جو: 0.030 MB حافظه قبل از پرس و جوی: 7.742 MB سطرهای بازگشتی: 1

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

  FROM `s1g67_extensions`

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

توضیح دادن

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

مشخصات

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
28	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
27	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	به نظر می رسد خط زیر فراخونده شده باشد.
26	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
25	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
24	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
23	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
22	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
21	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
20	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
19	Joomla\CMS\Factory::getDocument()	JROOT/templates/yootheme/vendor/yootheme/framework/src/ContainerTrait.php
18	YOOtheme\Module->__get()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla.php
17	YOOtheme\Theme\Joomla->onInit()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php
16	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php
15	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/index.php
14	YOOtheme\Theme\Joomla->{closure}()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php
13	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php
12	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/app/src/Application.php
11	YOOtheme\Application->init()	JROOT/plugins/system/yootheme/yootheme.php:162
10	plgSystemYOOtheme->loadTemplate()	JROOT/plugins/system/yootheme/yootheme.php:115
9	plgSystemYOOtheme->handleRequest()	JROOT/plugins/system/yootheme/yootheme.php:31
8	plgSystemYOOtheme->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:1123
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 1.36 ms پس از آخرین پرس و جو: 0.16 ms حافظه پرس و جو: 0.010 MB حافظه قبل از پرس و جوی: 7.801 MB

UPDATE `s1g67_extensions`

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

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

توضیح دادن

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

مشخصات

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.05 ms
updating	0.06 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	1.09 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
23	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
22	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
21	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
20	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
19	Joomla\CMS\Factory::getDocument()	JROOT/templates/yootheme/vendor/yootheme/framework/src/ContainerTrait.php
18	YOOtheme\Module->__get()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla.php
17	YOOtheme\Theme\Joomla->onInit()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php
16	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php
15	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/index.php
14	YOOtheme\Theme\Joomla->{closure}()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php
13	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php
12	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/app/src/Application.php
11	YOOtheme\Application->init()	JROOT/plugins/system/yootheme/yootheme.php:162
10	plgSystemYOOtheme->loadTemplate()	JROOT/plugins/system/yootheme/yootheme.php:115
9	plgSystemYOOtheme->handleRequest()	JROOT/plugins/system/yootheme/yootheme.php:31
8	plgSystemYOOtheme->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:1123
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.34 ms پس از آخرین پرس و جو: 2.26 ms حافظه پرس و جو: 0.032 MB حافظه قبل از پرس و جوی: 8.012 MB سطرهای بازگشتی: 3

SELECT *

  FROM s1g67_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	s1g67_languages	NULL	ALL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	3	33.33	Using where; با استفاده از مرتب سازی فایل

مشخصات

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.13 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
22	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
21	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla.php
20	YOOtheme\Theme\Joomla->onSite()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php
19	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php
18	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla.php
17	YOOtheme\Theme\Joomla->onInit()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php
16	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php
15	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/index.php
14	YOOtheme\Theme\Joomla->{closure}()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php
13	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php
12	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/app/src/Application.php
11	YOOtheme\Application->init()	JROOT/plugins/system/yootheme/yootheme.php:162
10	plgSystemYOOtheme->loadTemplate()	JROOT/plugins/system/yootheme/yootheme.php:115
9	plgSystemYOOtheme->handleRequest()	JROOT/plugins/system/yootheme/yootheme.php:31
8	plgSystemYOOtheme->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:1123
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.49 ms پس از آخرین پرس و جو: 41.43 ms حافظه پرس و جو: 0.030 MB حافظه قبل از پرس و جوی: 8.616 MB سطرهای بازگشتی: 22

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

  FROM `s1g67_assets`

  WHERE `name` LIKE 'com_digicom.%' OR `name` = 'com_digicom' OR `parent_id` = 0

توضیح دادن

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

مشخصات

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.18 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
19	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_digicom/models/category.php:142
14	DigiComModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_digicom/views/category/view.html.php:304
11	DigiComViewCategory->commonCategoryDisplay()	JROOT/components/com_digicom/views/category/view.html.php:73
10	DigiComViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_digicom/controller.php:81
8	DigiComController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_digicom/digicom.php:19
6	require_once JROOT/components/com_digicom/digicom.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.84 ms پس از آخرین پرس و جو: 0.27 ms حافظه پرس و جو: 0.039 MB حافظه قبل از پرس و جوی: 8.661 MB سطرهای بازگشتی: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
SELECT COUNT(i.`id`)

  FROM `s1g67_digicom_products` AS `i`

  WHERE i.`catid` = c.id 
  AND i.published = 1) AS numitems

  FROM `s1g67_categories` AS `s`

  INNER JOIN `s1g67_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_digicom' OR c.extension='system') 
  AND c.access IN (1,1,5,10) 
  AND c.published = 1 
  AND s.id = 49

  ORDER BY c.lft

توضیح دادن

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	c	NULL	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	11	53.85	Using index condition; Using where
2	DEPENDENT SUBQUERY	i	NULL	ref	idx_state,idx_catid	idx_catid	4	samaneba_BrShDb.c.id	7	76.30	Using where

مشخصات

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.27 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.07 ms
executing	0.03 ms
executing	0.01 ms
executing	0.03 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 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/src/Categories/Categories.php:324
16	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
15	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_digicom/models/category.php:365
14	DigiComModelCategory->getCategory()	JROOT/components/com_digicom/models/category.php:241
13	DigiComModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_digicom/views/category/view.html.php:305
11	DigiComViewCategory->commonCategoryDisplay()	JROOT/components/com_digicom/views/category/view.html.php:73
10	DigiComViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_digicom/controller.php:81
8	DigiComController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_digicom/digicom.php:19
6	require_once JROOT/components/com_digicom/digicom.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.08 ms پس از آخرین پرس و جو: 0.52 ms حافظه پرس و جو: 0.039 MB حافظه قبل از پرس و جوی: 8.701 MB سطرهای بازگشتی: 1

SELECT a.id, a.name, a.alias,a.price, a.bundle_source,a.hide_public, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.attribs, a.metatitle,  a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.published END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,ua.name AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM s1g67_digicom_products AS a

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

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

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

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

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

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM s1g67_categories AS cat JOIN s1g67_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_digicom' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  WHERE a.access IN (1,1,5,10) 
  AND c.access IN (1,1,5,10) 
  AND 
  CASE WHEN badcats.id is null THEN a.published ELSE 0 END = 1 
  AND a.catid = 49 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-08-08 05:32:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-08 05:32:23')

  ORDER BY    a.created  DESC ,  a.created

توضیح دادن

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	با استفاده از مرتب سازی فایل
1	PRIMARY	a	NULL	ref	idx_access,idx_catid	idx_catid	4	const	1	16.00	Using where
1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	samaneba_BrShDb.a.created_by	1	100.00	Using where
1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	samaneba_BrShDb.a.modified_by	1	100.00	Using where
1	PRIMARY	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
1	PRIMARY	v	NULL	eq_ref	PRIMARY	PRIMARY	4	samaneba_BrShDb.a.id	1	100.00	NULL
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	2	100.00	Using where; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	153	NULL	5	100.00	Using index condition; Using temporary
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	39	11.11	Using where; Using index; Using join buffer (hash join)

مشخصات

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.01 ms
starting	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
Opening tables	0.35 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Creating tmp table	0.04 ms
statistics	0.08 ms
preparing	0.10 ms
executing	0.17 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.74 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_digicom/models/products.php:559
14	DigiComModelProducts->getItems()	JROOT/components/com_digicom/models/category.php:265
13	DigiComModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_digicom/views/category/view.html.php:305
11	DigiComViewCategory->commonCategoryDisplay()	JROOT/components/com_digicom/views/category/view.html.php:73
10	DigiComViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_digicom/controller.php:81
8	DigiComController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_digicom/digicom.php:19
6	require_once JROOT/components/com_digicom/digicom.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM `s1g67_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_digicom.product' 
  AND `m`.`content_item_id` = 70 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5,10)

توضیح دادن

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	کلید شاخصی برای استفاده نیست	NULL	NULL	99	1.01	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	samaneba_BrShDb.m.tag_id	1	96.84	Using where

مشخصات

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.15 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.55 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_digicom/models/products.php:685
14	DigiComModelProducts->getItems()	JROOT/components/com_digicom/models/category.php:265
13	DigiComModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_digicom/views/category/view.html.php:305
11	DigiComViewCategory->commonCategoryDisplay()	JROOT/components/com_digicom/views/category/view.html.php:73
10	DigiComViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_digicom/controller.php:81
8	DigiComController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_digicom/digicom.php:19
6	require_once JROOT/components/com_digicom/digicom.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT COUNT(*)

  FROM s1g67_digicom_products AS a

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

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

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

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

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

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM s1g67_categories AS cat JOIN s1g67_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_digicom' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  WHERE a.access IN (1,1,5,10) 
  AND c.access IN (1,1,5,10) 
  AND 
  CASE WHEN badcats.id is null THEN a.published ELSE 0 END = 1 
  AND a.catid = 49 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-08-08 05:32:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-08 05:32:23')

توضیح دادن

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	a	NULL	ref	idx_access,idx_catid	idx_catid	4	const	1	16.00	Using where
1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	samaneba_BrShDb.a.created_by	1	100.00	Using where; Using index
1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	samaneba_BrShDb.a.modified_by	1	100.00	Using where; Using index
1	PRIMARY	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where; Using index
1	PRIMARY	v	NULL	eq_ref	PRIMARY	PRIMARY	4	samaneba_BrShDb.a.id	1	100.00	Using index
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	2	100.00	Using where; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	153	NULL	5	100.00	Using index condition; Using temporary
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	39	11.11	Using where; Using index; Using join buffer (hash join)

مشخصات

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.00 ms
starting	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
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Creating tmp table	0.03 ms
statistics	0.06 ms
preparing	0.10 ms
executing	0.11 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.65 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
15	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
14	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_digicom/models/category.php:277
13	DigiComModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_digicom/views/category/view.html.php:305
11	DigiComViewCategory->commonCategoryDisplay()	JROOT/components/com_digicom/views/category/view.html.php:73
10	DigiComViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_digicom/controller.php:81
8	DigiComController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_digicom/digicom.php:19
6	require_once JROOT/components/com_digicom/digicom.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.71 ms پس از آخرین پرس و جو: 0.16 ms حافظه پرس و جو: 0.035 MB حافظه قبل از پرس و جوی: 8.762 MB سطرهای بازگشتی: 0

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

  FROM `s1g67_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_digicom.category' 
  AND `m`.`content_item_id` = 49 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5,10)

توضیح دادن

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	کلید شاخصی برای استفاده نیست	NULL	NULL	99	1.01	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	samaneba_BrShDb.m.tag_id	1	96.84	Using where

مشخصات

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	8.28 ms
cleaning up	0.03 ms

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

#	فراخوانده	فایل و شماره خط
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_digicom/views/category/view.html.php:386
11	DigiComViewCategory->commonCategoryDisplay()	JROOT/components/com_digicom/views/category/view.html.php:73
10	DigiComViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_digicom/controller.php:81
8	DigiComController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_digicom/digicom.php:19
6	require_once JROOT/components/com_digicom/digicom.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 0.74 ms پس از آخرین پرس و جو: 8.23 ms حافظه پرس و جو: 0.037 MB حافظه قبل از پرس و جوی: 8.952 MB سطرهای بازگشتی: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM s1g67_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_digicom.category' 
  AND (fc.category_id IS NULL OR fc.category_id IN (49,0,37,36)) 
  AND a.access IN (1,1,5,10) 
  AND (a.group_id = 0 OR g.access IN (1,1,5,10)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

توضیح دادن

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_context	575	const	1	6.23	Using where; Using temporary; با استفاده از مرتب سازی فایل
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	21	samaneba_BrShDb.a.language	1	100.00	Using index condition
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	samaneba_BrShDb.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	samaneba_BrShDb.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	samaneba_BrShDb.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	samaneba_BrShDb.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	samaneba_BrShDb.a.id	1	100.00	Using where; Using index; Distinct

مشخصات

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	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
Opening tables	0.25 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
Creating tmp table	0.04 ms
executing	0.04 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	6.03 ms
cleaning up	0.03 ms

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

#	فراخوانده	فایل و شماره خط
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_digicom/views/category/view.html.php:125
10	DigiComViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_digicom/controller.php:81
8	DigiComController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_digicom/digicom.php:19
6	require_once JROOT/components/com_digicom/digicom.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.22 ms پس از آخرین پرس و جو: 5.96 ms حافظه پرس و جو: 0.029 MB حافظه قبل از پرس و جوی: 9.121 MB سطرهای بازگشتی: 1

SELECT alias

  FROM s1g67_digicom_products

  WHERE id=70

توضیح دادن

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

مشخصات

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
24	JDatabaseDriver->loadResult()	JROOT/components/com_digicom/router.php:238
23	DigiComRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
22	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
21	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
18	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
17	Joomla\CMS\Router\Route::_()	JROOT/components/com_digicom/templates/default/category_item.php:25
16	include JROOT/components/com_digicom/templates/default/category_item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_digicom/templates/default/category.php:88
14	include JROOT/components/com_digicom/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_digicom/views/category/view.html.php:250
10	DigiComViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_digicom/controller.php:81
8	DigiComController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_digicom/digicom.php:19
6	require_once JROOT/components/com_digicom/digicom.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.92 ms پس از آخرین پرس و جو: 8.83 ms حافظه پرس و جو: 0.078 MB حافظه قبل از پرس و جوی: 9.378 MB سطرهای بازگشتی: 17

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down

  FROM s1g67_modules AS m

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

  LEFT JOIN s1g67_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.access IN (1,1,5,10) 
  AND m.client_id = 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	ALL	published,newsfeeds	کلید شاخصی برای استفاده نیست	NULL	NULL	50	4.40	Using where; با استفاده از مرتب سازی فایل
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	303	samaneba_BrShDb.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	am	NULL	eq_ref	PRIMARY	PRIMARY	4	samaneba_BrShDb.m.id	1	100.00	Using where

مشخصات

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.19 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.35 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

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

#	فراخوانده	فایل و شماره خط
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
29	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:413
28	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:127
27	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
26	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
25	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:357
24	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
23	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
22	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla-modules/src/Modules.php
21	YOOtheme\Theme\Modules->countModules()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php
20	YOOtheme\View->__call()	JROOT/templates/yootheme/templates/header-mobile.php
19	unknown()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php
18	YOOtheme\View->evaluate()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/index.php
17	YOOtheme\Module->{closure}()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php
16	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/src/Theme.php
15	YOOtheme\Theme->replace()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php
14	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla/UrlListener.php
13	YOOtheme\Theme\Joomla\UrlListener->__invoke()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php
12	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php
11	YOOtheme\View->render()	به نظر می رسد خط زیر فراخونده شده باشد.
10	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
9	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
8	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/yootheme/index.php:84
7	require JROOT/templates/yootheme/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 112.63 ms پس از آخرین پرس و جو: 19.64 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 9.971 MB

UPDATE `s1g67_rsform_submissions` 
  SET confirmed = 0 
  WHERE SubmissionId IN (SELECT QQQ1.SubmissionId 
  FROM (SELECT * 
  FROM (SELECT QQ1.SubmissionId, RIGHT(CONCAT('0', SUBSTRING(QQ1.ExpireMonthDay, 1, LOCATE('/', QQ1.ExpireMonthDay) - 1)), 2) AS 'ExpireMonth', RIGHT(CONCAT('0', SUBSTRING(QQ1.ExpireMonthDay, LOCATE('/', QQ1.ExpireMonthDay) + 1)), 2) AS 'ExpireDay', QQ1.ExpireYear, 
  LEFT(pdate(CURRENT_DATE), 4) AS 'currentYear', 
  LEFT(RIGHT(pdate(CURRENT_DATE), 5), 2) AS 'currentMonth', RIGHT(RIGHT(pdate(CURRENT_DATE), 5), 2) AS 'currentDay' 
  FROM (SELECT 
  LEFT(Q1.FieldValue, 4) AS 'ExpireYear', SUBSTRING(Q1.FieldValue, LOCATE('/', Q1.FieldValue) + 1) AS 'ExpireMonthDay', Q1.SubmissionId 
  FROM `s1g67_rsform_submission_values` Q1 
  INNER JOIN `s1g67_rsform_submissions` S 
  ON Q1.SubmissionId = S.SubmissionId 
  AND Q1.FormId = S.FormId 
  WHERE Q1.FormId = 24 
  AND Q1.FieldName = 'expireDate' 
  AND S.confirmed = 1) QQ1) QQ2) QQQ1 
  WHERE CONCAT(QQQ1.currentYear, '-', QQQ1.currentMonth, '-', QQQ1.currentDay) > CONCAT(QQQ1.ExpireYear, '-', QQQ1.ExpireMonth, '-', QQQ1.ExpireDay))

توضیح دادن

توضیحات در جستجو ممکن نیست: UPDATE `s1g67_rsform_submissions` SET confirmed = 0 WHERE SubmissionId IN (SELECT QQQ1.SubmissionId FROM (SELECT * FROM (SELECT QQ1.SubmissionId, RIGHT(CONCAT('0', SUBSTRING(QQ1.ExpireMonthDay, 1, LOCATE('/', QQ1.ExpireMonthDay) - 1)), 2) AS 'ExpireMonth', RIGHT(CONCAT('0', SUBSTRING(QQ1.ExpireMonthDay, LOCATE('/', QQ1.ExpireMonthDay) + 1)), 2) AS 'ExpireDay', QQ1.ExpireYear, LEFT(pdate(CURRENT_DATE), 4) AS 'currentYear', LEFT(RIGHT(pdate(CURRENT_DATE), 5), 2) AS 'currentMonth', RIGHT(RIGHT(pdate(CURRENT_DATE), 5), 2) AS 'currentDay' FROM (SELECT LEFT(Q1.FieldValue, 4) AS 'ExpireYear', SUBSTRING(Q1.FieldValue, LOCATE('/', Q1.FieldValue) + 1) AS 'ExpireMonthDay', Q1.SubmissionId FROM `s1g67_rsform_submission_values` Q1 INNER JOIN `s1g67_rsform_submissions` S ON Q1.SubmissionId = S.SubmissionId AND Q1.FormId = S.FormId WHERE Q1.FormId = 24 AND Q1.FieldName = 'expireDate' AND S.confirmed = 1) QQ1) QQ2) QQQ1 WHERE CONCAT(QQQ1.currentYear, '-', QQQ1.currentMonth, '-', QQQ1.currentDay) > CONCAT(QQQ1.ExpireYear, '-', QQQ1.ExpireMonth, '-', QQQ1.ExpireDay))

مشخصات

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.10 ms
executing	0.02 ms
executing	0.06 ms
executing	0.01 ms
executing	0.03 ms
executing	0.03 ms
executing	0.02 ms
executing	0.02 ms
executing	0.02 ms
executing	0.01 ms
executing	0.03 ms
executing	0.02 ms
executing	0.03 ms
executing	0.03 ms
executing	0.02 ms
executing	0.02 ms
executing	0.07 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	8.76 ms
cleaning up	0.03 ms

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

#	فراخوانده	فایل و شماره خط
14	JDatabaseDriverMysqli->execute()	JROOT/tmp/htmlF7Kvgb:6
13	include_once JROOT/tmp/htmlF7Kvgb	JROOT/modules/mod_flexi_customcode/helper.php:25
12	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
11	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
10	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla-modules/src/ModulesRenderer.php
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

زمان پرس و جو: 1.16 ms پس از آخرین پرس و جو: 3.13 ms حافظه پرس و جو: 0.045 MB حافظه قبل از پرس و جوی: 10.008 MB سطرهای بازگشتی: 17

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
SELECT COUNT(i.`id`)

  FROM `s1g67_digicom_products` AS `i`

  WHERE i.`catid` = c.id 
  AND i.published = 1) AS numitems

  FROM `s1g67_categories` AS `c`

  WHERE (c.extension='com_digicom' OR c.extension='system') 
  AND c.access IN (1,1,5,10) 
  AND c.published = 1

  ORDER BY c.lft

توضیح دادن

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	ALL	cat_idx,idx_access	کلید شاخصی برای استفاده نیست	NULL	NULL	39	53.85	Using where; با استفاده از مرتب سازی فایل
2	DEPENDENT SUBQUERY	i	NULL	ref	idx_state,idx_catid	idx_catid	4	samaneba_BrShDb.c.id	7	76.30	Using where

مشخصات

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

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

#	فراخوانده	فایل و شماره خط
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
16	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
15	Joomla\CMS\Categories\Categories->get()	JROOT/modules/mod_digicom_categories/helper.php:39
14	ModDigicomCategoriesHelper::getList()	به نظر می رسد خط زیر فراخونده شده باشد.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:561
11	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_digicom_categories/mod_digicom_categories.php:27
10	include JROOT/modules/mod_digicom_categories/mod_digicom_categories.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla-modules/src/ModulesRenderer.php
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

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

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

2 × SELECT `m`.`tag_id`,`t`.* 
  FROM `s1g67_contentitem_tag_map` AS m  
  INNER JOIN `s1g67_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`) 
  FROM `s1g67_digicom_products` AS `i`

```
1 × SELECT * 
  FROM s1g67_languages
```

1 × SELECT alias 
  FROM s1g67_digicom_products

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM s1g67_fields AS a 
  LEFT JOIN `s1g67_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN s1g67_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN s1g67_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN s1g67_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN s1g67_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `s1g67_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT COUNT(*) 
  FROM s1g67_digicom_products AS a 
  LEFT JOIN s1g67_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN s1g67_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN s1g67_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN s1g67_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN s1g67_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM s1g67_categories AS cat JOIN s1g67_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT a.id, a.name, a.alias,a.price, a.bundle_source,a.hide_public, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.attribs, a.metatitle,  a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.published END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,ua.name AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM s1g67_digicom_products AS a 
  LEFT JOIN s1g67_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN s1g67_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN s1g67_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN s1g67_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN s1g67_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM s1g67_categories AS cat JOIN s1g67_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT `data` 
  FROM `s1g67_session`

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

1 × SELECT `session_id` 
  FROM `s1g67_session`

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `s1g67_categories` AS `c`

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

1 × SELECT id,template 
  FROM s1g67_template_styles

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

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

1 × SELECT id, rules 
  FROM `s1g67_viewlevels

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down 
  FROM s1g67_modules AS m 
  LEFT JOIN s1g67_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN s1g67_advancedmodules as am 
  ON am.moduleid = m.id

سایر جداول:

1 × INSERT INTO `s1g67_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6532303537613165333734366432643062623638313066623837613231633439', 1, 1786167142, 0, '', 0

1 × UPDATE `s1g67_extensions` 
  SET `params` = '{\"mediaversion\":\"dd175ac9c719e616ce267dfe2a3993d5\"}'

1 × UPDATE `s1g67_rsform_submissions` 
  SET confirmed = 0 
  WHERE SubmissionId IN (SELECT QQQ1.SubmissionId 
  FROM (SELECT * 
  FROM (SELECT QQ1.SubmissionId, RIGHT(CONCAT('0', SUBSTRING(QQ1.ExpireMonthDay, 1, LOCATE('/', QQ1.ExpireMonthDay) - 1)), 2) AS 'ExpireMonth', RIGHT(CONCAT('0', SUBSTRING(QQ1.ExpireMonthDay, LOCATE('/', QQ1.ExpireMonthDay) + 1)), 2) AS 'ExpireDay', QQ1.ExpireYear, 
  LEFT(pdate(CURRENT_DATE), 4) AS 'currentYear', 
  LEFT(RIGHT(pdate(CURRENT_DATE), 5), 2) AS 'currentMonth', RIGHT(RIGHT(pdate(CURRENT_DATE), 5), 2) AS 'currentDay' 
  FROM (SELECT 
  LEFT(Q1.FieldValue, 4) AS 'ExpireYear', SUBSTRING(Q1.FieldValue, LOCATE('/', Q1.FieldValue) + 1) AS 'ExpireMonthDay', Q1.SubmissionId 
  FROM `s1g67_rsform_submission_values` Q1 
  INNER JOIN `s1g67_rsform_submissions` S 
  ON Q1.SubmissionId = S.SubmissionId 
  AND Q1.FormId = S.FormId

نمونه سوالات اصول و فلسفه آموزش و پرورش

درباره ما

تماس با ما

شرایط و ضوابط

راهنمای سایت

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

جلسه

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

زمان

حافظه

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

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

26 پرس و جو ثبت شده 132.91 ms

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

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

سایر جداول: